7,612
edits
Changes
Jump to navigation
Jump to search
Estimating Unobserved Complementarities between Entrepreneurs and Venture Capitalists (view source)
Revision as of 14:10, 30 November 2017
, 14:10, 30 November 2017no edit summary
|Has title=Estimating Unobserved Complementarities between Entrepreneurs and Venture Capitalists
|Has author=Ed Egan, Jeremy Fox, David Hsu,
|Has RAs=Amir Kazempour,Meghana Gaur
|Has paper status=In development
}}
==Work Done in Late November by Dylan & Ed==
SBIR Data taken from McNair\Projects\SBIR\Data\Aggregate SBIR\SBIR.txt. -Note! This file needed to be opened in excel to be readable, and took a very long time to open due to its large size. SBIR firm names converted to a pivot table to eliminate exact repeat entries, and then exported to a txt file, NSBIR. NSBIR then matched using The Matcher in mode 2 with the following code "-file1="NSBIR.txt" -file2="NSBIR.txt" -mode=2" Output then placed in McNair\Projects\MatchingEntrepsToVC\Matching\Output. The original pre-matched, cleaned NSBIR.txt file is moved to McNair\Projects\MatchingEntrepsToVC\Matching\Intput.
There is a sql file to extract VC portcos (SEL backed only), with key info from vcdb2, and distinct assignee names from allpatentsprocessed here:
E:\McNair\Projects\MatchingEntrepsToVC\Matching
There are three input files:
*distinctNSBIR.txt - made by pivot tabling SBIR.txt from the SBIR aggregation project
*distinctassignees.txt - extracted as distinct from allpatentsprocessed
*vcbackedselcokeys.txt - extracted with key info from vcdb2. It needs pivot tabling to get unique names.
There are three
