Changes
Jump to navigation
Jump to search
To Do* Match roundinfoclean matched oundinfoclean investors to fundinfocleanfinal investors (roundinfo.txt >> cleanfundfinal.txt)-- 771 errors found; fix before uploading * Match roundinfoclean conname to companyinfo3 coname join by round and company conames*bridge years (companyinfonames.txt >>companyroundnames.txt1990-2016)**try without matcher first, see how accurate the naming system is before reverting to matcherstage, and cmsa* Join round-to-fund populate data with count of companies (CMSADeal flow) and round/fund to company - cmsa/industry**see code for superinfo* Create supportable by MSA by yearestimated amount ($)
→Primary Data Set
* changed all original characters to include CMSA and Industry Codes (companyinfo3, fundinfocleanfinal, roundinfoclean)
* matched funds to avoid any issues with names (i.e. Fund ABC L.P./Fund ABC LP/Fund ABC)
===Hub Candidates Data Set===