Difference between revisions of "Matching VentureOne (Data)"
Jump to navigation
Jump to search
| Line 10: | Line 10: | ||
==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 | + | :<code>E:\McNair\Projects\Venture One Data\Venture Data 1.xlsx</code> Original data source |
*Clean it up | *Clean it up | ||
Revision as of 13:31, 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.xlsxOriginal 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
