feature engineering studio october 7, 2013. welcome to bring me a rock day 2
TRANSCRIPT
![Page 1: Feature Engineering Studio October 7, 2013. Welcome to Bring Me a Rock Day 2](https://reader035.vdocuments.us/reader035/viewer/2022070414/5697c0251a28abf838cd524b/html5/thumbnails/1.jpg)
Feature Engineering Studio
October 7, 2013
![Page 2: Feature Engineering Studio October 7, 2013. Welcome to Bring Me a Rock Day 2](https://reader035.vdocuments.us/reader035/viewer/2022070414/5697c0251a28abf838cd524b/html5/thumbnails/2.jpg)
Welcome to Bring Me a Rock Day 2
![Page 3: Feature Engineering Studio October 7, 2013. Welcome to Bring Me a Rock Day 2](https://reader035.vdocuments.us/reader035/viewer/2022070414/5697c0251a28abf838cd524b/html5/thumbnails/3.jpg)
But first…
• Excel Equation Solver
![Page 4: Feature Engineering Studio October 7, 2013. Welcome to Bring Me a Rock Day 2](https://reader035.vdocuments.us/reader035/viewer/2022070414/5697c0251a28abf838cd524b/html5/thumbnails/4.jpg)
What it requires
• Parameters• Goodness metric (typically SSR)
![Page 5: Feature Engineering Studio October 7, 2013. Welcome to Bring Me a Rock Day 2](https://reader035.vdocuments.us/reader035/viewer/2022070414/5697c0251a28abf838cd524b/html5/thumbnails/5.jpg)
Linear Regression Example
• Look at prior variables– And how model prediction is created from
predictor• Create SSR variable
![Page 6: Feature Engineering Studio October 7, 2013. Welcome to Bring Me a Rock Day 2](https://reader035.vdocuments.us/reader035/viewer/2022070414/5697c0251a28abf838cd524b/html5/thumbnails/6.jpg)
Linear Regression Example
• Hand-iterate on variables
![Page 7: Feature Engineering Studio October 7, 2013. Welcome to Bring Me a Rock Day 2](https://reader035.vdocuments.us/reader035/viewer/2022070414/5697c0251a28abf838cd524b/html5/thumbnails/7.jpg)
Linear Regression Example
• Excel equation solver
![Page 8: Feature Engineering Studio October 7, 2013. Welcome to Bring Me a Rock Day 2](https://reader035.vdocuments.us/reader035/viewer/2022070414/5697c0251a28abf838cd524b/html5/thumbnails/8.jpg)
BKT Example
• Go through functions
![Page 9: Feature Engineering Studio October 7, 2013. Welcome to Bring Me a Rock Day 2](https://reader035.vdocuments.us/reader035/viewer/2022070414/5697c0251a28abf838cd524b/html5/thumbnails/9.jpg)
BKT Example
• Excel equation solver
![Page 10: Feature Engineering Studio October 7, 2013. Welcome to Bring Me a Rock Day 2](https://reader035.vdocuments.us/reader035/viewer/2022070414/5697c0251a28abf838cd524b/html5/thumbnails/10.jpg)
BKT Example
• Excel equation solver– Constrain P(G) to under 0.3
![Page 11: Feature Engineering Studio October 7, 2013. Welcome to Bring Me a Rock Day 2](https://reader035.vdocuments.us/reader035/viewer/2022070414/5697c0251a28abf838cd524b/html5/thumbnails/11.jpg)
BKT Example
• Excel equation solver– Try different solver algorithms
![Page 12: Feature Engineering Studio October 7, 2013. Welcome to Bring Me a Rock Day 2](https://reader035.vdocuments.us/reader035/viewer/2022070414/5697c0251a28abf838cd524b/html5/thumbnails/12.jpg)
Questions? Comments?
![Page 13: Feature Engineering Studio October 7, 2013. Welcome to Bring Me a Rock Day 2](https://reader035.vdocuments.us/reader035/viewer/2022070414/5697c0251a28abf838cd524b/html5/thumbnails/13.jpg)
GoogleRefine(now OpenRefine)
![Page 14: Feature Engineering Studio October 7, 2013. Welcome to Bring Me a Rock Day 2](https://reader035.vdocuments.us/reader035/viewer/2022070414/5697c0251a28abf838cd524b/html5/thumbnails/14.jpg)
GoogleRefine(now OpenRefine)
• Functionality to make it easy to regroup and transform data– Find similar names– Connect names– Bin numerical data– Mathematical transforms showing resultant
graphs– Text transforms and column creation
![Page 15: Feature Engineering Studio October 7, 2013. Welcome to Bring Me a Rock Day 2](https://reader035.vdocuments.us/reader035/viewer/2022070414/5697c0251a28abf838cd524b/html5/thumbnails/15.jpg)
GoogleRefine(now OpenRefine)
• Functionality for finding anomalies/outliers
![Page 16: Feature Engineering Studio October 7, 2013. Welcome to Bring Me a Rock Day 2](https://reader035.vdocuments.us/reader035/viewer/2022070414/5697c0251a28abf838cd524b/html5/thumbnails/16.jpg)
GoogleRefine(now OpenRefine)
• Functionality for automatically repeating the same process on a new data set
• *Really* nice for cases where you complete a complex process and want to repeat it
![Page 17: Feature Engineering Studio October 7, 2013. Welcome to Bring Me a Rock Day 2](https://reader035.vdocuments.us/reader035/viewer/2022070414/5697c0251a28abf838cd524b/html5/thumbnails/17.jpg)
GoogleRefine(now OpenRefine)
• Functionality for connecting your data set to web services to get additional relevant info
![Page 18: Feature Engineering Studio October 7, 2013. Welcome to Bring Me a Rock Day 2](https://reader035.vdocuments.us/reader035/viewer/2022070414/5697c0251a28abf838cd524b/html5/thumbnails/18.jpg)
GoogleRefine(now OpenRefine)
• Can load in and export common but hard-to-work-with data types– JSON and XML
![Page 19: Feature Engineering Studio October 7, 2013. Welcome to Bring Me a Rock Day 2](https://reader035.vdocuments.us/reader035/viewer/2022070414/5697c0251a28abf838cd524b/html5/thumbnails/19.jpg)
GoogleRefine(now OpenRefine)
• Some videos you should watch later
• http://www.youtube.com/watch?v=B70J_H_zAWM
• http://www.youtube.com/watch?v=cO8NVCs_Ba0
• http://www.youtube.com/watch?v=5tsyz3ibYzk
![Page 20: Feature Engineering Studio October 7, 2013. Welcome to Bring Me a Rock Day 2](https://reader035.vdocuments.us/reader035/viewer/2022070414/5697c0251a28abf838cd524b/html5/thumbnails/20.jpg)
Questions? Comments?
![Page 21: Feature Engineering Studio October 7, 2013. Welcome to Bring Me a Rock Day 2](https://reader035.vdocuments.us/reader035/viewer/2022070414/5697c0251a28abf838cd524b/html5/thumbnails/21.jpg)
Welcome to Bring Me a Rock Day 2
![Page 22: Feature Engineering Studio October 7, 2013. Welcome to Bring Me a Rock Day 2](https://reader035.vdocuments.us/reader035/viewer/2022070414/5697c0251a28abf838cd524b/html5/thumbnails/22.jpg)
In birthdate order
• Each person should tell us about their favorite feature they created for Bring Me a Rock Day 2
• Tell us what it was• How you created it• Your just-so story• And was your just-so story correct
![Page 23: Feature Engineering Studio October 7, 2013. Welcome to Bring Me a Rock Day 2](https://reader035.vdocuments.us/reader035/viewer/2022070414/5697c0251a28abf838cd524b/html5/thumbnails/23.jpg)
Next
• Tell us about anything cool you did in Excel or another program to create a feature
![Page 24: Feature Engineering Studio October 7, 2013. Welcome to Bring Me a Rock Day 2](https://reader035.vdocuments.us/reader035/viewer/2022070414/5697c0251a28abf838cd524b/html5/thumbnails/24.jpg)
Too Hard?
• Were there any features that anyone kind of wanted to create, but it was too difficult? (or too much work?)
![Page 25: Feature Engineering Studio October 7, 2013. Welcome to Bring Me a Rock Day 2](https://reader035.vdocuments.us/reader035/viewer/2022070414/5697c0251a28abf838cd524b/html5/thumbnails/25.jpg)
Better?
• Who here got better features (in terms of goodness metric) for Bring Me a Rock Day 2, than Bring Me a Rock Day 1?
![Page 26: Feature Engineering Studio October 7, 2013. Welcome to Bring Me a Rock Day 2](https://reader035.vdocuments.us/reader035/viewer/2022070414/5697c0251a28abf838cd524b/html5/thumbnails/26.jpg)
Other Interesting Observations?
![Page 27: Feature Engineering Studio October 7, 2013. Welcome to Bring Me a Rock Day 2](https://reader035.vdocuments.us/reader035/viewer/2022070414/5697c0251a28abf838cd524b/html5/thumbnails/27.jpg)
Assignment 5
![Page 28: Feature Engineering Studio October 7, 2013. Welcome to Bring Me a Rock Day 2](https://reader035.vdocuments.us/reader035/viewer/2022070414/5697c0251a28abf838cd524b/html5/thumbnails/28.jpg)
Assignment 5• Iterative Feature Refinement
– Select three of the features you have created in previous assignments– These features should be “among the best” of the features you have
previously created– For each of these three features, create at least five “close variants” of
these features• “time for last 3 actions” and “time for last 4 actions” are close variants• “time for last 3 actions” and “total time between help requests and next action” are
two separate features
– Using the Excel Equation Solver is a substitute for creating five “close variants”
– If you don’t use the excel equation solver• As you create the close variants for each feature, don’t just make them all at once• Make a variant• Test whether it’s better than the previous variant (by goodness metric)
– If it is, keep going in the same direction– If it isn’t, try doing the opposite or something else
![Page 29: Feature Engineering Studio October 7, 2013. Welcome to Bring Me a Rock Day 2](https://reader035.vdocuments.us/reader035/viewer/2022070414/5697c0251a28abf838cd524b/html5/thumbnails/29.jpg)
Assignment 5
• Write a report that discusses your process– I took feature N– I changed it from N to N*– The goodness changed from G to G*– Then I did…
![Page 30: Feature Engineering Studio October 7, 2013. Welcome to Bring Me a Rock Day 2](https://reader035.vdocuments.us/reader035/viewer/2022070414/5697c0251a28abf838cd524b/html5/thumbnails/30.jpg)
Assignment 5
• You don’t need to prepare a presentation• But be ready to discuss your features in class
![Page 31: Feature Engineering Studio October 7, 2013. Welcome to Bring Me a Rock Day 2](https://reader035.vdocuments.us/reader035/viewer/2022070414/5697c0251a28abf838cd524b/html5/thumbnails/31.jpg)
Next Classes
• 10/9 RapidMiner Practice Session– Bring your RapidMiner process to class with
questions, on a laptop– We’ll learn together
• 10/14 Iterative Feature Refinement– Assignment 5 due
![Page 32: Feature Engineering Studio October 7, 2013. Welcome to Bring Me a Rock Day 2](https://reader035.vdocuments.us/reader035/viewer/2022070414/5697c0251a28abf838cd524b/html5/thumbnails/32.jpg)
Upcoming Classes
• 10/16 No special session today
• 10/21 Feature Adaptation
• 10/23 Special Session on Building Prediction Models
![Page 33: Feature Engineering Studio October 7, 2013. Welcome to Bring Me a Rock Day 2](https://reader035.vdocuments.us/reader035/viewer/2022070414/5697c0251a28abf838cd524b/html5/thumbnails/33.jpg)
Thank you!