Will Cleland (Work Log)

Will Cleland Work Logs (log page)

20160210 (Wed) 2:30 - Finish reading NHL paper, determine necessary variables for paper, find variables in SQL code

20160210 (Wed) 5:30 - Read paper, and created list of necessary variables and where to find them

20160211 (Thur) 2:30 - Update NHL page with all work done so far created new dropbox with necessary files and variables and where to find them

20160211 (Thur) 5:30 - Updated page and dropbox worked with Ed to determine create final list of necessary information in order to begin downloads

20160216 (Tue) 2:30 - Download all of the databases in order to begin creating master table and get as far as possible on master table

20160216 (Tue) 5:30 - Downloaded databases and found distinct player-seasons to help begin join

20160217 (Wed) 2:30 - Continue working on the master table, today we want to count unique data entries in each table to facilitate the join and whatever else is needed.

20160217 (Wed) 5:30 - Created new tables for each of the original tables where all player-seasons are unique.

20160219 (Fri) 2:00 - Join tables

20160219 (Fri) 6:00 - Joined everything except the Cap Geek Table

20160222 (Mon) 2:00 - Join the CapGeek Table to the other tables

20160222 (Mon) 5:45 - Reformatted date of birth, team, and season entries in order to begin fuzzy matching

20160224 (Wed) 2:10 - Set up Fuzzy Match and do it

20160224 (Wed) 5:19 - Fuzzy Matched

20160226 (Fri) 2:00 - Sort through fuzzy matched and determine exceptions so that we can join tables

20160226 (Fri) 5:00 - Refined fuzzy match search and began search

20160307 (Mon) 2:00 - Sort through Fuzzy Match

20160307 (Mon) 6:00 - Found path and set up terminal, fixed date of birth issue, learned how to join bios and historical table with bios data