*Worked with Matthew to compile tables in our database of the matched VC-portfolio company lists and the overall accelerator cohort information. Found multiple errors in the cohort file which needed to be fixed before finishing the tables and analyzing the data
3/23/17 14:00 - 16:00
*Finished cleaning the cohort file once again.3/24/17 14:00 - 16:00*Continued practicing my SQL and creating the code for compiling the tables3/29/17 14:00 - 16:00*Worked on the matched data with Matthew. Will run the RegEx code that will filter the URLs, and I will look through the duplicates where two different VC-backed company names matched to one cohort company name3/30/17 14:00 - 16:00*Examined the Regex code for the URLs and attempted to filter them out4/03/17 14:00 - 16:00*Continued learning some SQL from Ed4/04/17 14:00 - 16:00*Began examining the Crunchbase data; looked through the 2013 snapshot*Created a new Crunchbase account with McNair center and examined the basic access, which does not give us much information4/05/17 14:00 - 16:00*Made the final VC percentage table from our database and previous code with Ed; realized we were missing many accelerators as well as a lot of important cohort data so need to reexamine our previous data.4/06/17 14:00 - 16:00*Continued looking through Crunchbase to see how we can pull accelerators up until 2013; most likely will use objects to sort the data into accelerators, perhaps keywords from "accelerators"4/07/17 14:00 - 16:00*Examined SARP and attempted to match their accelerators with the ones from our data, realized that a few of our cohorts were missing as well as a few of the actual accelerators so we need to fix the data in our excel file*Began compiling a list of missing accelerators on textpad to later insert into our excel.
[[Category:Work Log]]