Difference between revisions of "Matching VentureOne (Data)"
Jump to navigation
Jump to search
| Line 29: | Line 29: | ||
*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> | ||
| − | *Join <code>firstjoin_cleaned</code> data to <code>matchassignee</code> data, creating secondjoin_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 fourthjoin_cleaned</code> | + | *Join <code>secondjoin_cleaned</code> data to <code>venturepatentmatched</code> data, creating <code>fourthjoin_cleaned</code> |
Revision as of 14:34, 15 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 source file for the 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
E:\McNair\Projects\Venture One Data\Cleaned and Matched Data.xlsx
- Get the patent data
- Draw the distinct assignees
Z:\allpatentsprocessed\DistinctAssignees2.txt
- Match them against themselves
Z:\allpatentsprocessed\DistinctAssignees2matched.txt
- Match venture data to patent data
Z:\allpatentsprocessed\Venture Patent Matched.txt
- Join
patentdata toassigneedata, creatingfirstjoin_cleaned - Join
firstjoin_cleaneddata tomatchassigneedata, creatingsecondjoin_cleaned - Join
secondjoin_cleaneddata toventurepatentmatcheddata, creatingfourthjoin_cleaned
