327
edits
Changes
Jump to navigation
Jump to search
The Impact of Entrepreneurship Hubs on Urban Venture Capital Investment (view source)
Revision as of 12:16, 1 July 2016
, 12:16, 1 July 2016→Tables and Specific Procedure Used
==Tables and Specific Procedure Used==
===Raw data tables===
#'''Funds''': fund name, first investment date, last investment date, fund closing date, address, known investment, average investment, number of companies invested, MSA, MSA code.#'''Rounds''': round date, company name, state, round number, stage 1, stage 2, stage 3#'''Combined Rounds''': company name, round date, disclosed amount, investor#'''Companies''': company name, first investment, last investment, MSA, MSA code, address, state, date founded, known funding, industry#'''MSA listList''': MSA, MSA code, CMSA, CMSA code#'''Industry listList''': changes 6 industry categories to 4— ICT, Life Sciences, Semiconductors, Other
The final table here contains all venture capital transactions by disclosed funds and portfolio companies, together with their CMSAs.
To get the table, we processed the raw data sets in the following steps:
#Clean company '''Company''' data
##Import raw data companies
##Add variable 'CMSA' from data set MSA list, update variable 'industry' by joining data set industry list
##Remove duplicates and remove undisclosed companies
#Clean fund '''Fund''' data
##Import raw data funds
##Add variable 'CMSA'
##Remove duplicates and remove undisclosed funds
##Match fund names with itself using [The Matcher (Tool) |The Matcher] to get the standard fund names
#Clean round '''Round''' data
##Import raw data rounds and combined rounds
##Add variables 'number of investment', 'estimated investment' and 'year'
##Remove duplicates and remove undisclosed funds
#'''Combine companies ''' '''Companies''' and rounds'''Rounds'''
##Combine cleaned companies and rounds data table on company names
##Add variable 'round number' and 'stage'
##Remove duplicates
#Combining funds '''Combine''' '''Funds''' and '''rounds-companies'''
##Match fund names in rounds data table with standard fund names using [The Matcher (Tool) |The Matcher] to standardize fund names in rounds data table
##Join standard fund names to rounds-companies table
