Difference between revisions of "Accelerator Data"

From edegan.com
Jump to navigation Jump to search
Line 15: Line 15:
 
==List of All Relevant Files==
 
==List of All Relevant Files==
  
*'''Original Search'''
+
'''Original Search'''
  
  
**'''List of Preliminary Accelerators'''
+
*'''List of Preliminary Accelerators'''
***Original Location: [[Accelerator Seed List (Data)]]
+
**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.
+
**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
+
**Variables: Names of potential accelerators
  
**'''accelerator_data_noflag'''
+
*'''accelerator_data_noflag'''
***Original Location: Bulk(E:)\McNair\Projects\Accelerators\Spring 2017\Code+Final_Data
+
**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.
+
**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
+
**Variables: Name, Score, Flag, CohortURL, Address, Duration, Vintage, Industry, Description, Equity, Nonprofit, Notes
  
*'''Cohort Directory "Big Push"'''
+
'''Cohort Directory "Big Push"'''
  
  
**'''Data'''
+
*'''Data'''
***Original Location: Bulk(E:)\McNair\Projects\Accelerators\Spring 2017\
+
**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.
+
**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'''
+
*'''List of Python files'''
***'''parse_accelerator_data'''
+
**'''parse_accelerator_data'''
***'''parse_cohort_data'''
+
**'''parse_cohort_data'''
***'''process_locations'''
+
**'''process_locations'''
***'''wayback_machine'''
+
**'''wayback_machine'''
***Location: Bulk(E:)\McNair\Projects\Accelerators\Spring 2017\Code+Final_Data
+
**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.
+
**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'''
+
*'''Cleaned Cohort Data'''
***Original Location: Bulk(E:)\McNair\Projects\Accelerators\Fall 2017
+
**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.
+
**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
+
**Variables: Accelerator Name, Company Name, Description, Website, Industry, Location, Acquisition, Notes, Inverstors, Perks, Status, Funding Stage, Founder, Executive, Program, Cohort, Year
  
*'''Refining the List'''
+
'''Refining the List'''
  
  
**'''New Crunchbase Accelerators'''
+
*'''New Crunchbase Accelerators'''
***Original Location: Bulk(E:)\McNair\Projects\Accelerators\Spring 2017
+
**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.
+
**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
+
**Variables: Names of Missing Accelerators
***Potential Crunchbase Variables
+
**Potential Crunchbase Variables
  
**'''Accelerator_Data'''
+
*'''Accelerator_Data'''
***Original Location: Bulk(E:)\McNair\Projects\Accelerators\Summer 2017\Veeral
+
**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.
+
**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
+
**Variables: Accelerator, homepage_url, city, region, country_code, Creation date
  
**'''ListofAccs'''
+
*'''ListofAccs'''
***Original Location: Bulk(E:)\McNair\Projects\Accelerators\Fall 2017
+
**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.
+
**Description: This text file contains a master list of all current accelerators we have been working with.
***Variables: Accelerator name, Whois parser code
+
**Variables: Accelerator name, Whois parser code
  
*'''Additional Variables'''
+
'''Additional Variables'''
  
  
**'''Accelerator_Cohort_Companies'''
+
*'''Accelerator_Cohort_Companies'''
***Original Location: Bulk(E:)\McNair\Projects\Accelerators\Fall 2017
+
**Original Location: Bulk(E:)\McNair\Projects\Accelerators\Fall 2017
***Description: This text file contains a master list of all cohort companies of all accelerators.
+
**Description: This text file contains a master list of all cohort companies of all accelerators.
***Variables: Cohort Companies, Accelerator name
+
**Variables: Cohort Companies, Accelerator name
  
**'''Current Matched Data'''
+
*'''Current Matched Data'''
***Original Location: Bulk(E:)\McNair\Projects\Accelerators\Fall 2017
+
**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.
+
**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
+
**Variables: VCCompanies, Accelerator, Earliest Round Date
  
**'''founders_linkedin'''
+
*'''founders_linkedin'''
***Original Location: Bulk(E:)\McNair\Projects\Accelerators\Fall 2017
+
**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.
+
**Description: This text file contains founder data for each accelerator found by Peter when crawling LinkedIn.
***Variables: Accelerator name, Founder name, LinkedIn URL
+
**Variables: Accelerator name, Founder name, LinkedIn URL

Revision as of 18:00, 14 November 2017


McNair Project
Accelerator Data
Project logo 02.png
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


  • 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