Difference between revisions of "Connor Rothschild (Work Log)"

From edegan.com
Jump to navigation Jump to search
Line 5: Line 5:
 
06/27/2018 -  
 
06/27/2018 -  
 
*Finished coding duplicates. Final file can be found at:
 
*Finished coding duplicates. Final file can be found at:
  FILE NAME.
+
  /bulk/McNair/Projects/Accelerators/Summer 2018/DUPLICATE COMPANIES MASTER SHEET.xlsx
 +
 
 
*Dylan taught interns basic Excel skills
 
*Dylan taught interns basic Excel skills
  

Revision as of 15:21, 27 June 2018

Summer 2018

06/27/2018 -

  • Finished coding duplicates. Final file can be found at:
/bulk/McNair/Projects/Accelerators/Summer 2018/DUPLICATE COMPANIES MASTER SHEET.xlsx
  • Dylan taught interns basic Excel skills

06/26/2018 -

  • Began coding duplicates in CohortMainBaseWCounts.txt file that Ed sent. Sorted by company name alphabetically, then used conditional formatting to highlight when an accelerator had the same name as the accelerator above. This narrowed down the results to instances in which a company would go through the same accelerator twice. Most of the time, this was due to an error with the normalizer, so I moved those un-normalized company names to their own sheet and deleted them from the file.

06/25/2018 -

  • Went through and manually fixed discrepancies between our accelerator data and the Crunchbase data, found at
/bulk/McNair/Projects/Accelerators/Summer 2018/Accelerators Matched by Name and Homepage URL.xlsx
  • Finalized a sheet with a list of accelerator names as we code them, as Crunchbase codes them, and the appropriate UUID for each accelerator. I recommend updating the names in our spreadsheet of accelerators to the Crunchbase list so that we will be able to look up that name without having an in-between. The list can be found in the rightmost columns here:
/bulk/McNair/Projects/Accelerators/Summer 2018/Accelerator Master Variable List - Revised by Ed V2.xlsx

and here:

https://docs.google.com/spreadsheets/d/1n1sX5DqZrm_0vbUXG9ZaZIagF9sa0Kva9PAno-6H854/edit?usp=sharing


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

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