Changes

9/11/2017 2:00-5:00 pm: *Spoke to Ed about the project going forward. Organized the current updated data for our project.

9/12/2017 3:00-5:00 pm: *Began going through the Cleaned Cohort Data Excel file and found a few problems with it. Will continue the cleaning process for the rest of the week.

9/13/2017 2:00-5:00 pm: *Sorted through Cleaned Cohort Data and finalized our List of Accelerators. We can begin the process of creating our PercentVC table.

9/14/2017 3:00-5:00 pm: *Completely finalized our dataset of accelerators and startups. Met with Michelle Passo to discuss objectives of the research for credit course.

9/18/2017 2:00-4:00 pm: *Talked with Peter about the LinkedIn crawler data. Went through VC page that Meghana sent me.

9/19/2017 3:00-5:00 pm: *Completed SDC pull of updated VC Data.

9/20/2017 2:00-5:00 pm: *Attempted several times to run the Matcher. Cleaned our pulled data.

9/21/2017 3:00-5:00 pm: *Came extremely close to running the Matcher the correctly. Reviewed the final LinkedIn data from Peter.

9/25/2017 2:00-5:00 pm: *Finalized the matched file of accelerator companies with VC portfolio companies. Gave Ben the data on Georgia accelerators.

9/26/2017 3:00-5:00 pm: *Worked on finding the duplicates in our Matched file in order to have the most accurate data.

9/27/2017 2:00-5:00 pm: *Attempted to find a way to organize the duplicate matches.

9/28/2017 4:00-5:00 pm: *Continued running through matched data in order to organize it effectively.

10/2/2017 2:00-5:00 pm: *Talked to Ed about next steps for the project. Practiced accessing the crunchbase database on SQL. Brushed up on SQL code.

10/3/2017 3:00-5:00 pm: *Searched the database for crunchbase investment information.

10/4/2017 2:00-5:00 pm: *Pulled the funding rounds table from SQL and matched it with the companies that have received VC funding in order to gather round dates.

10/6/2017 3:00-5:00 pm: *Went through the matched data. Brainstormed ways to get the dates for cohort companies going through accelerators.

10/11/2017 2:00-3:30 pm: *Looked into using the WhoIs Parser in order to find when the companies went through their accelerators.

10/12/2017 3:00-5:00 pm: *Discovered that the Wayback Machine will not be a good option for finding when companies went through their accelerators. Created a list of VCCompanies and their earliest round date. Included a column for the date they went through their accelerators and will fill it in when we find a good method of finding this date.

10/16/2017 2:00-3:30 pm: *Continued working on sorting VCCompanies by their earliest round date.

10/17/2017 3:00-5:00 pm: *Worked with Ben to find a solution to our problem of data acquisition. Finalized earliest round date for VCCompanies.

10/18/2017 2:00-5:00 pm: *Updated our VC data with Ed's help in order to increase the accuracy and completion of our data.

10/19/2017 3:00-5:00 pm: *Organized all of our matched data and updated it in order to reflect the most recent SDC pull with Ed. Matched Crunchbase data with our cohort companies.

10/20/2017 2:00-3:30 pm: *Generated the new list of VCCompanies as well as their earliest round dates.

10/23/2017 2:00-3:30 pm: *Worked on sorting out the discrepancies in our matched data.

10/24/2017 3:00-5:00 pm: *Went through list of VCCompanies and began adding respective accelerators in order to proceed with VCPercentage table.

10/25/2017 2:00-5:00 pm: *Continued going through list of VCCompanies and adding accelerators.

10/26/2017 3:30-5:30 pm: *Continued going through list of VCCompanies and adding accelerators. Will have this completed on Monday.

10/30/2017 2:00-3:30 pm: *Finished adding all of the accelerators to the list of VCCompanies. Added a column indicating whether or not the company went through two or more accelerators.

10/31/2017 3:00-5:00 pm: *Began compiling data in the column for Date Company went through Accelerator.

11/1/2017 2:00-4:00 pm: *Finalized entering dates for Y Combinator cohort companies.

11/2/2017 4:00-5:30 pm: *Continued entering cohort company dates into Excel file.

11/6/2017 2:00-4:00 pm: *Continued entering cohort company dates into Excel file. Began compiling a list of keywords for demo day press releases.