460
edits
Changes
Jump to navigation
Jump to search
no edit summary
;*Join patent data to venture data to get patent information of each venture-backed companies
#Join <code>patent</code> data to <code>assignee</code> data, creating <code>firstjoin_cleaned</code>which matches assignees to patent numbers.#Join <code>firstjoin_cleaned</code> data to <code>matchassignee</code> data, creating <code>secondjoin_cleaned</code>which matches standard org names to patent numbers#Join <code>secondjoin_cleaned</code> data to <code>venturepatentmatched</code> data, creating <code>fourthjoin_cleaned</code>which matches standard venture company names to patent numbers
;*Final summary tables
#Summary table displaying number of patentsowned, 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 <code>E:\McNair\Projects\Venture One Data\venturepatentfullyjoined.txt</code>
