460
edits
Changes
Jump to navigation
Jump to search
no edit summary
}}
==Overview==In this matching process, we will join patent data to venture backed companies and count the number of patents that affiliated to venture backed companies. We first get the standard entity names for venture backed companies from the source VentureOne data set, and match the standard entity names with the standard company names that have patents from our patent database. Based on the common standard company names, we join patent information to venture backed companies. *Variables used from source data set: EntityName ===Final Matched Table==#Summary table displaying number of patents owned, minimum grant year, maximum grant year and average grant year for each company #A table contains all patent information for each company that has patents ==Detailed Data Processing==
;*Get the VentureOne data ready
#Source file for VentureOne data <code>E:\McNair\Projects\Venture One Data\Venture Data 1.xlsx</code> Original data source
;*Final summary tables
#Summary table displaying number of patents owned, minimum grant year, maximum grant year and average grant year for each company <code>E:\McNair\Projects\Venture One Data\venturepatentreallyfinal.txt</code>
#A table of all patent information for each company that has patent patents <code>E:\McNair\Projects\Venture One Data\venturepatentfullyjoined.txt</code>
;*Notes
