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 | + | *;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 | ||
Revision as of 12:29, 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