Changes

Matching VentureOne (Data) (view source)

76 bytes added , 15:29, 15 June 2016

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

460

edits