Difference between revisions of "Matching VentureOne (Data)"
Jump to navigation
Jump to search
| Line 16: | Line 16: | ||
:<code>E:\McNair\Software\Scripts\Matcher\Input\Venture Data 1.txt</code> extraneous symbols and words removed | :<code>E:\McNair\Software\Scripts\Matcher\Input\Venture Data 1.txt</code> extraneous symbols and words removed | ||
| − | *Match it against itself | + | *Match it against itself to get standardized entity names |
:<code>E:\McNair\Projects\Venture One Data\Cleaned and Matched Data.xlsx</code> | :<code>E:\McNair\Projects\Venture One Data\Cleaned and Matched Data.xlsx</code> | ||
| Line 22: | Line 22: | ||
::Draw the distinct assignees | ::Draw the distinct assignees | ||
:<code>Z:\allpatentsprocessed\DistinctAssignees2.txt </code><br> | :<code>Z:\allpatentsprocessed\DistinctAssignees2.txt </code><br> | ||
| − | ::Match them against themselves | + | ::Match them against themselves to get standardized org names for patent data |
:<code>Z:\allpatentsprocessed\DistinctAssignees2matched.txt </code> | :<code>Z:\allpatentsprocessed\DistinctAssignees2matched.txt </code> | ||
| + | *Match standardized org names of patent data to standardized entity names of venture data | ||
| + | :<code>Z:\allpatentsprocessed\Venture Patent Matched.txt</code> | ||
| − | * | + | *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>firstjoin_cleaned</code> data to <code>matchassignee</code> data, creating <code>secondjoin_cleaned</code> | ||
| + | #Join <code>secondjoin_cleaned</code> data to <code>venturepatentmatched</code> data, creating <code>fourthjoin_cleaned</code> | ||
| − | * | + | *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> | |
| − | + | #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:29, 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
- 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_cleaned - Join
firstjoin_cleaneddata tomatchassigneedata, creatingsecondjoin_cleaned - Join
secondjoin_cleaneddata toventurepatentmatcheddata, creatingfourthjoin_cleaned
- Final summary Tables
- Summary table displaying number of patents, 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
