460
edits
Changes
Jump to navigation
Jump to search
no edit summary
==Data==
*;Get the source file for the VentureOne data
:<code>E:\McNair\Projects\Venture One Data\Venture Data 1.xlsx</code> Original data source
*Clean it up
:<code>E:\McNair\Software\Scripts\Matcher\Input\Venture Data 1.txt </code> extraneous symbols and words removed
*Match it against itself
:<code>E:\McNair\Projects\Venture One Data\Cleaned and Matched Data.xlsx</code>
*Get the patent data
**Draw the distinct assignees
:<code>Z:\allpatentsprocessed\DistinctAssignees2.txt </code>
**Match them against themselves
:<code>Z:\allpatentsprocessed\DistinctAssignees2matched.txt </code>**Load the VentureOne data into a dbase
*Match venture data to patent data
:<code>Z:\allpatentsprocessed\Venture Patent Matched.txt</code>
*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
