Difference between revisions of "Matching VentureOne (Data)"
Jump to navigation
Jump to search
| Line 9: | Line 9: | ||
==Data== | ==Data== | ||
| − | * | + | *Get the source file for the VentureOne data |
:<code>E:\McNair\Projects\Venture One Data\Venture Data 1.xlsx</code> Original data source | :<code>E:\McNair\Projects\Venture One Data\Venture Data 1.xlsx</code> Original data source | ||
*Clean it up | *Clean it up | ||
| − | :E:\McNair\Software\Scripts\Matcher\Input\Venture Data 1.txt 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 | ||
| − | :E:\McNair\Projects\Venture One Data\Cleaned and Matched Data.xlsx | + | :<code>E:\McNair\Projects\Venture One Data\Cleaned and Matched Data.xlsx</code> |
*Get the patent data | *Get the patent data | ||
**Draw the distinct assignees | **Draw the distinct assignees | ||
| − | :Z:\allpatentsprocessed\DistinctAssignees2.txt | + | :<code>Z:\allpatentsprocessed\DistinctAssignees2.txt </code> |
**Match them against themselves | **Match them against themselves | ||
| − | :Z:\allpatentsprocessed\DistinctAssignees2matched.txt | + | :<code>Z:\allpatentsprocessed\DistinctAssignees2matched.txt </code> |
| − | + | ||
*Match venture data to patent data | *Match venture data to patent data | ||
| + | :<code>Z:\allpatentsprocessed\Venture Patent Matched.txt</code> | ||
*Join patent data to assignee data, creating firstjoin_cleaned | *Join patent data to assignee data, creating firstjoin_cleaned | ||
*Join firstjoin_cleaned data to matchassignee data, creating secondjoin_cleaned | *Join firstjoin_cleaned data to matchassignee data, creating secondjoin_cleaned | ||
*Join secondjoin_cleaned data to venturepatentmatched data, creating fourthjoin_cleaned | *Join secondjoin_cleaned data to venturepatentmatched data, creating fourthjoin_cleaned | ||
Revision as of 15:29, 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 patent data to assignee data, creating firstjoin_cleaned
- Join firstjoin_cleaned data to matchassignee data, creating secondjoin_cleaned
- Join secondjoin_cleaned data to venturepatentmatched data, creating fourthjoin_cleaned
