Lab 3: Categorising Connect 4 Boards
- Grab the connect 4 data in xl. My
server doesn't serve up .xlsm files so it's a .txt file. Just save
it as connect-4.xlsm.
- If you'd like, you can get the data right from the
University of California at Irvine's site. All I did
was take every other line with the odds being the train set
and the evens the test set.
- You're welcome to do the lab in Java or some other lab, but
I'll walk you through it in Visual Basic.
- Hit the developer tab, and then visual basic. Add a form, and
a command button and edit box to the form.
- Click the button to get the VB editor. Add TextBox1.Text = "hi"
to the click sub, and run it. (There, you've got VB running.)
- I did TextBox1.Text = VBAProject.Sheet2.Range("A1").Value to
put the train A1 value into the box
- Write a function that returns the numbers of cells in two
rows that are different. I used
Private Function distance2( first as Range, second As Range) as Integer
- Make a function that finds the closest row to the first test row.
(Mine took about 10 seconds to run.)
- Guess the answer to the test from the closest other row, and put
that in the spreadsheet.
- Run that over the first 10 test items.
- How well do you do? I got 15/25 training on the test set.
- Can you improve the metric?