Now we’ve got the data into a MySQL database, so next step is accessing it from our prefered application (sometimes, that means MS Excel, i.e.). So, let’s go: 1) Make sure you system is up to date (specially the Jet Engine). 2) Download and install the last MySQL ODBC Connector. …
Next is the database. In this example I’m going to use MySQL, although you could use PostgreSQL, or MS SQL, for example. I’m in a Windows OS. 2) Creating the database and dumping the data into it. a. Create the database: CREATE DATABASE netflix; b. Create the tables: “training_ser” is …
The Netflix Prize is in the company’s own words the”quest” for “substantially improve(ing) the accuracy of predictions about how much someone is going to love a movie based on their movie preferences”. I read about the prize last february on Michael Trick’s blog and the first thing I saw was …