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 | |
:E:\McNair\Projects\Venture One Data\Venture Data 1.xlsx Original data source | :E:\McNair\Projects\Venture One Data\Venture Data 1.xlsx Original data source | ||
| − | + | *Clean it up | |
:E:\McNair\Software\Scripts\Matcher\Input\Venture Data 1.txt extraneous symbols and words removed | :E:\McNair\Software\Scripts\Matcher\Input\Venture Data 1.txt extraneous symbols and words removed | ||
| − | + | *Match it against itself | |
:E:\McNair\Projects\Venture One Data\Cleaned and Matched Data.xlsx | :E:\McNair\Projects\Venture One Data\Cleaned and Matched Data.xlsx | ||
| − | + | *Get the patent data | |
| − | + | **Draw the distinct assignees | |
:Z:\allpatent\DistinctAssignees2.txt | :Z:\allpatent\DistinctAssignees2.txt | ||
| − | + | **Match them against themselves | |
:Z:\allpatent\DistinctAssignees2matched.txt | :Z:\allpatent\DistinctAssignees2matched.txt | ||
| − | + | **Load the VebtureOne data into a dbase | |
Revision as of 12:17, 14 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.xlsx Original data source
- Clean it up
- E:\McNair\Software\Scripts\Matcher\Input\Venture Data 1.txt extraneous 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:\allpatent\DistinctAssignees2.txt
- Match them against themselves
- Z:\allpatent\DistinctAssignees2matched.txt
- Load the VebtureOne data into a dbase