Difference between revisions of "Matching VentureOne (Data)"
Jump to navigation
Jump to search
| Line 22: | Line 22: | ||
;*Join patent data to venture data to get patent information of each venture-backed companies | ;*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> | + | #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> | + | #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> | + | #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 | ;*Final summary tables | ||
| − | #Summary table displaying number of patents, minimum grant year, maximum grant year and average grant year for each company <code>E:\McNair\Projects\Venture One Data\venturepatentreallyfinal.txt</code> | + | #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 <code>E:\McNair\Projects\Venture One Data\venturepatentfullyjoined.txt</code> | #A table of all patent information for each company that has patent <code>E:\McNair\Projects\Venture One Data\venturepatentfullyjoined.txt</code> | ||
Revision as of 11:50, 16 June 2016
| Matching VentureOne (Data) | |
|---|---|
| Project Information | |
| Project Title | |
| Start Date | |
| Deadline | |
| Primary Billing | |
| Notes | |
| Has project status | |
| Copyright © 2016 edegan.com. All Rights Reserved. | |
Data Processing
- Get the VentureOne data ready
- Source file for VentureOne data
E:\McNair\Projects\Venture One Data\Venture Data 1.xlsxOriginal data source - Clean it up
E:\McNair\Software\Scripts\Matcher\Input\Venture Data 1.txtextraneous symbols and words removed - Match it against itself to get standardized entity names
E:\McNair\Projects\Venture One Data\Cleaned and Matched Data.xlsx
- Get the patent data ready
- Draw the distinct assignees
Z:\allpatentsprocessed\DistinctAssignees2.txt - Match them against themselves to get standardized org names for patent data
Z:\allpatentsprocessed\DistinctAssignees2matched.txt
- Match standardized org names of patent data to standardized entity names of venture data
Z:\allpatentsprocessed\Venture Patent Matched.txt
- Join patent data to venture data to get patent information of each venture-backed companies
- Join
patentdata toassigneedata, creatingfirstjoin_cleanedwhich matches assignees to patent numbers. - Join
firstjoin_cleaneddata tomatchassigneedata, creatingsecondjoin_cleanedwhich matches standard org names to patent numbers - Join
secondjoin_cleaneddata toventurepatentmatcheddata, creatingfourthjoin_cleanedwhich matches standard venture company names to patent numbers
- Final summary tables
- Summary table displaying number of patents owned, minimum grant year, maximum grant year and average grant year for each company
E:\McNair\Projects\Venture One Data\venturepatentreallyfinal.txt - A table of all patent information for each company that has patent
E:\McNair\Projects\Venture One Data\venturepatentfullyjoined.txt
- Notes
- All data in
allpatentsprocessed database. Access it by logging on toresearcher@McNair DBServ:/bulk/allpatentsprocessed - A detailed processing procedure can be found at
E:\McNair\Projects\Venture One Data\patent data script.txt
