Difference between revisions of "Accelerator Data"
Jump to navigation
Jump to search
Line 15: | Line 15: | ||
==List of All Relevant Files== | ==List of All Relevant Files== | ||
− | + | '''Original Search''' | |
− | + | *'''List of Preliminary Accelerators''' | |
− | + | **Original Location: [[Accelerator Seed List (Data)]] | |
− | + | **Description: This is the very first master list we compiled of potential accelerators. Look to [[Accelerator Seed List (Data)]] for process. | |
− | + | **Variables: Names of potential accelerators | |
− | + | *'''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. | |
− | + | *'''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 | |
− | + | '''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 |
Revision as of 18:00, 14 November 2017
Accelerator Data | |
---|---|
Project Information | |
Project Title | Composite Accelerator Data |
Owner | Matthew Ringheanu, Shrey Agarwal |
Start Date | Fall 2016 |
Deadline | Fall 2017 |
Keywords | Accelerator, Data |
Primary Billing | |
Notes | [[Has notes::Continuation of [Accelerator Seed List (Data)]]] |
Has project status | Active |
Is dependent on | Accelerator Seed List (Data) |
Copyright © 2016 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
- List of Preliminary Accelerators
- Original Location: Accelerator Seed List (Data)
- Description: This is the very first master list we compiled of potential accelerators. Look to Accelerator Seed List (Data) for process.
- Variables: Names of potential accelerators
- 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.
- 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
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