Accelerator Data

From edegan.com
Revision as of 13:41, 21 September 2020 by Ed (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search


Project
Accelerator Data
Project logo 02.png
Project Information
Has title Composite Accelerator Data
Has owner Matthew Ringheanu, Shrey Agarwal
Has start date Fall 2016
Has deadline date
Has keywords Accelerator, Data
Has project status Subsume
Is dependent on Accelerator Seed List (Data)
Subsumed by: U.S. Seed Accelerators
Has sponsor McNair Center
Has project output Data
Copyright © 2019 edegan.com. All Rights Reserved.

Relevant Files

Location for All Relevant Files

  • All relevant files are located in Bulk(E:)\McNair\Projects\Accelerators\All Relevant Files

List of All Relevant Files

Original Search

  • accelerator_data_noflag
    • Original Location: Bulk(E:)\McNair\Projects\Accelerators\Spring 2017\Code+Final_Data
    • Description: This text file contains the data on all accelerators that we found from our first round of research that were not flagged. It consolidates the data collected by all McNair Center interns, filtering out the organizations which are not accelerators.
    • Variables: Name, Score, Flag, CohortURL, Address, Duration, Vintage, Industry, Description, Equity, Nonprofit, Notes

Cohort Directory "Big Push"

  • Data
    • Original Location: Bulk(E:)\McNair\Projects\Accelerators\Spring 2017\
    • Description: This folder contains files for each of the accelerators that we searched through from the "List of Preliminary Accelerators". There are three files per accelerator: 1) The "accelerator name.txt" file which contains each of the variables recorded by all of the McNair Center workers during our big push on the project winter 2016, 2) The .html file for the cohort page if the entry was indeed an accelerator and if the worker could find the cohort page on that accelerator, and 3) a "accelerator name.cohort.txt" file which contains a list of the cohort companies as well as all variables which were easily found alongside the cohort.
  • List of Python files
    • parse_accelerator_data
    • parse_cohort_data
    • process_locations
    • wayback_machine
    • Location: Bulk(E:)\McNair\Projects\Accelerators\Spring 2017\Code+Final_Data
    • Description: These files contain the code which Peter used to categorize the data from the "Data Copy" folder in Bulk(E:)\McNair\Projects\Accelerators\Spring 2017\, which is just a copy of our cleaned data file. From this code, Peter returned for us a list of accelerators categorized by their flag and a compiled list of all the cohort companies as well as the variables recorded by McNair workers.
    • Note: We manually altered the cohort data which came out of Peter's code so that we could homogenize the formatting. This resulted in a unique cohort file which will not be replicated when running the code again. On the other hand, we manually altered the individual txt files for the accelerators to fix format so running Peter's code again should result in a similar file.
  • Cleaned Cohort Data
    • Original Location: Bulk(E:)\McNair\Projects\Accelerators\Fall 2017
    • Description: This Excel file contains all data on all cohort companies for our entire list of current accelerators. All missing accelerators were updated by Veeral and we have used this as our final list of cohort companies for all accelerators.
    • Variables: Accelerator Name, Company Name, Description, Website, Industry, Location, Acquisition, Notes, Inverstors, Perks, Status, Funding Stage, Founder, Executive, Program, Cohort, Year
  • First_Incomplete_PercentVC_Table
    • Original Location: Bulk(Z:)\Accelerators
    • Description: The VC percentage raise rate for 198 accelerators. At this point we realized we were missing almost 100 accelerators, so we decided to expand our list and gather more data.
    • Variables: Accelerator Name, Number of Cohort Companies, Number of VC Backed Cohort Companies, Raise rate percentage

Refining the List

  • New Crunchbase Accelerators
    • Original Location: Bulk(E:)\McNair\Projects\Accelerators\Spring 2017
    • Description: After conducting some SDC matches with cohort data from the cohort companies of the accelerators in the accelerator_data_noflag text file, we realized many potential accelerators were missing. We then got an Excel file from Crunchbase containing all of its organizations, which we then sorted to identify potential missing accelerators. The accelerators we were actually missing are in this Excel file.
    • Variables: Names of Missing Accelerators
    • Potential Crunchbase Variables
  • Accelerator_Data
    • Original Location: Bulk(E:)\McNair\Projects\Accelerators\Summer 2017\Veeral
    • Description: This text file contains cleaned data on all of our current accelerators. This file was compiled by Veeral over Summer 2017. Some of these accelerators are not based in the United States.
    • Variables: Accelerator, homepage_url, city, region, country_code, Creation date
  • ListofAccs
    • Original Location: Bulk(E:)\McNair\Projects\Accelerators\Fall 2017
    • Description: This text file contains a master list of all current accelerators we have been working with.
    • Variables: Accelerator name, Whois parser code

Additional Variables

  • Accelerator_Cohort_Companies
    • Original Location: Bulk(E:)\McNair\Projects\Accelerators\Fall 2017
    • Description: This text file contains a master list of all cohort companies of all accelerators.
    • Variables: Cohort Companies, Accelerator name
  • Current Matched Data
    • Original Location: Bulk(E:)\McNair\Projects\Accelerators\Fall 2017
    • Description: Sheet 1 contains our matched data from matching our SDC pull with our cohort companies list found in Accelerator_Cohort_Companies. Sheet 2 removes the duplicates from the previous match. Sheet 3 contains the list of VCCompanies, which accelerator they went through, the date of their first investment. Sheet 4 contains our cohort list matched with the crunchbase organizations, but it contains too many duplicates to use.
    • Variables: VCCompanies, Accelerator, Earliest Round Date
  • founders_linkedin
    • Original Location: Bulk(E:)\McNair\Projects\Accelerators\Fall 2017
    • Description: This text file contains founder data for each accelerator found by Peter when crawling LinkedIn.
    • Variables: Accelerator name, Founder name, LinkedIn URL