158
edits
Changes
Jump to navigation
Jump to search
→7/9/18 Update
Here's a project update on the work that has been done since coming to McNair. The most recent file is
/bulk/McNair/Projects/Accelerators/Summer 2018/'''The File to Rule Them All.xlsx'''
===Merging Cohort Companies with Crunchbase Info===
More information on this part of the project can be found on the page [[Merging Existing Data with Crunchbase]].
The newest updated sheet of cohort company info is under the '''Cohorts Final''' sheet of '''The File to Rule Them All.xlsx'''.
Working with [[Maxine Tao]], we have matched companies to their respective pages and information found in Crunchbase (via UUID). We ensured single matches by doing a 1-1-1-1 match with our data and with Crunchbase (using the Matcher). We then received additional information on 8092 companies. The following new information is included in the sheet:
*short_description
*long_description
*category_list (details the company's category)
*category_group_list (a less refined, more all-encompassing category classification)
*founded_on date
*employee_count
*linkedin_url
*address
And the following information was also pulled from Crunchbase and '''merged''' with our existing data:
*URL (was merged with courl cells)
*city (was merged with colocation)
*state_code (was merged with colocation)
*country_code (was merged with colocation)
*status (was merged with costatus)
===The Equity Variables: COMPLETE===
