PreCourse Steps:
-
Download the Kaggle data: https://www.kaggle.com/c/GiveMeSomeCredit/download/cs-training.csv
- Move this file to your Desktop.
-
Load into a MySQL database
- In your terminal:
which mysql
to verify you have mysql installed. If you don't,brew install mysql
. - Start mysql server: 'mysql.server start'
- Enter mysql from your command line: 'mysql -u root'. Add the -p password flag if you have a password set up: 'mysql -u root -p'. This will prompt you for your password on the next line.
- Create a database to load this file into:
SHOW DATABASES;
CREATE DATABASE learningMachines;
SHOW DATABASES;
to verify it workedUSE learningMachines;
will switch into using the newly created database- Create the table that you'll be loading the data into:
- This will create a table with all the right columns, and the right format for each column
CREATE TABLE IF NOT EXISTS neuralNet ( id int NOT NULL AUTO_INCREMENT, seriousDelinquency int, creditUtilization float, age int, 30To60DaysLate int, DebtRatio float, MonthlyIncome int, NumberOfOpenCreditLines int, 90DaysLate int, NumberOfRealEstateLoansOrLines int, 60To89DaysLate int, NumberOfDependents int, PRIMARY KEY (id) );
SHOW TABLES;
should show neuralNet as a tableDESCRIBE neuralNet;
- Load data from the download to the table you just created:
- Clean the data:
- Replace all ",NA" with ",0"
- Investigate your line endings. Some programs will save in an odd format by default. In Sublime Text, got to View, Line Endings, and then click on Unix. That will switch it to being what we'd expect to see, i.e., '\n'
- Back in your MySQL command prompt:
LOAD DATA INFILE '/Users/preston/Desktop/cs-training.csv' INTO TABLE neuralNet FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 ROWS;
- Verify the data has loaded correctly:
SELECT * FROM neuralNet LIMIT 15;
Should look like the fist 15 rows of your dataSELECT COUNT(id) FROM neuralNet;
Should return 150,000
- In your terminal:
-
Create a node.js server to do three things: Load data from MySQL db, process data to get it into the right format for our neural net, Run the neural net
- If you're familiar with Node.js, try using my server as an inspiration to build your own
- If you're not familiar with Node.js, fork and clone my repo
- Go to https://github.com/ClimbsRocks/learningMachines and click Fork in the upper right.
cd ~/Desktop
changes directory to the Desktop. Feel free to use whichever directory you want.git clone https://github.com/YOUR_USERNAME_HERE/learningMachines
creates a folder on your Desktop that is a clone of your forkcd learningmachines
changes the directory into that foldersubl .
to open up the folder in sublime, assuming you have the subl command installed- Back in the terminal:
cd neuralNet
, and thencd server
npm install
. If this gives you an error, trysudo npm install
nodemon --max-old-space-size=3000 server.js
. This line does three things: it starts your node server based on the path you give it from the current directory (server.js). It starts nodemon on it, which means it will restart whenever you make a change to any file in the server directory. It allocates 3000 MB of memory to node, so that it doesn't crash if node runs over the 1.76 GB typically allocated to Node.js. You can adjust this number based on your system's capabilities and the problem you're solving.- You can now make api calls to this server, either through your browser (http://localhost:5000/neuralNet/startNet), or through curl on your command line
curl localhost:5000/neuralNet/startNet
- You now have a running node server on your computer, with all the right dependencies installed!
-
The key files in our node server are in the neuralNet folder.
- neuralNetLogic.js is where we have all the actual JS logic built out.
-
Your turn! Here are the things I expect you to do
- Create a new net
- Train that net
- Get predicted outcomes from that net in testing
- Add in new data to train the net. Rewrite what's currently in formatData with new data points, or 'features' as they're called in data science, that are combinations of the raw data we already have. Examples would include exact ratios that the net currently can't access because we've already transformed the data into a number between 0 and 1.
-
Extra Credit
- Handle cases that have missing data ("NA") differently than cases that have full data
-
Fantasy Mode
- Parallelize the training of multiple nets at the same time. Training each net is synchronous, so parallelizing won't help you train a single net any faster. But you could try creating multiple versions that have different parameters (number of nodes, hidden layers, learning rate, etc.) and train those in parallel with each other.