Difference between revisions of "Matching VentureOne (Data)"

From edegan.com
Jump to navigation Jump to search
Line 28: Line 28:
 
:<code>Z:\allpatentsprocessed\Venture Patent Matched.txt</code>
 
:<code>Z:\allpatentsprocessed\Venture Patent Matched.txt</code>
  
*Join patent data to assignee data, creating firstjoin_cleaned
+
*Join <code>patent</code> data to <code>assignee</code> data, creating <code>firstjoin_cleaned</code>
*Join firstjoin_cleaned data to matchassignee data, creating secondjoin_cleaned
+
*Join <code>firstjoin_cleaned</code> data to <code>matchassignee</code> data, creating secondjoin_cleaned</code>
*Join secondjoin_cleaned data to venturepatentmatched data, creating fourthjoin_cleaned
+
*Join <code>secondjoin_cleaned</code> data to <code>venturepatentmatched</code> data, creating fourthjoin_cleaned</code>

Revision as of 15:33, 15 June 2016


McNair Project
Matching VentureOne (Data)
Project logo 02.png
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:\allpatentsprocessed\DistinctAssignees2.txt
    • Match them against themselves
Z:\allpatentsprocessed\DistinctAssignees2matched.txt


  • Match venture data to patent data
Z:\allpatentsprocessed\Venture Patent Matched.txt
  • 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