Connor Rothschild (Work Log)

Summer 2018

06/22/2018 - Finished going through Accelerator Master Variable List to refine industry classification and update addresses/accelerator statuses.

06/21/2018 - Began manually editing entries in Accelerator Master Variable List. Reached out to Grace and Maxine and sent them the necessary sheets/txt files so they could begin on their Crunchbase project. I also made these graphics to better represent what our collaborative work would look like, and what the final project would include.

https://docs.google.com/document/d/13Mb7lOLydm9r-ENYxSlZJVGgY9wxClATR6Hy8F9YK1Y/edit?usp=sharing

The list of accelerators that we know take equity can be found in \bulk\McNair\Projects\Accelerators\All Relevant Files\accelerator_data_noflag.txt

This file has 266 rows. The most recent, actual version of our accelerator database (found at McNair\Projects\Accelerators\Summer 2018\Accelerator Master List - Revised by Ed V2.xlsx under the sheet Master Variable List) only has 167 rows, meaning the accelerator_data_noflag.txt file has too many rows.

You will need to do a left join of Accelerator Master List with accelerator_data_noflag.txt to get rid of the accelerator names that are in accelerator_data_noflag but NOT in Accelerator Master List.

Once this is finished, you should have an “Equity” classification variable for every accelerator in Accelerator Master List. The accelerators that have a Y (or maybe it’s a 1) are companies that do take equity. These are the companies you’ll be able to do your Crunchbase work on to see when accelerators take equity.

06/20/2018 - Talked with Ed about project details. Began looking through the Accelerator Master List to better understand project description. Sent Grace and Maxine the relevant company names listed in the Accelerator Master Spreadsheet so they could begin using their relevant parsers and tools to sort through data.

06/19/2018 - Set up work stations on balcony, trained

06/18/2018 - Trained, met other interns