Difference between revisions of "Matching VentureOne (Data)"

McNair Project
Matching VentureOne (Data)
Project Information
Project Title
Start Date
Deadline
Primary Billing
Notes
Has project status
	Copyright © 2016 edegan.com. All Rights Reserved.

Revision as of 14:37, 15 June 2016

Source file for 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

E:\McNair\Projects\Venture One Data\Cleaned and Matched Data.xlsx

Draw the distinct assignees

Z:\allpatentsprocessed\DistinctAssignees2.txt

Match them against themselves

Z:\allpatentsprocessed\DistinctAssignees2matched.txt

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

@@ Line 9: / Line 9: @@
 ==Data==
-*Get the source file for the VentureOne data
+*Get the VentureOne data ready
+::Source file for VentureOne data
 :<code>E:\McNair\Projects\Venture One Data\Venture Data 1.xlsx</code> Original data source
-*Clean it up
+::Clean it up
 :<code>E:\McNair\Software\Scripts\Matcher\Input\Venture Data 1.txt</code> extraneous symbols and words removed
@@ Line 18: / Line 19: @@
 :<code>E:\McNair\Projects\Venture One Data\Cleaned and Matched Data.xlsx</code>
-*Get the patent data
+*Get the patent data ready
-**Draw the distinct assignees
+::Draw the distinct assignees
 :<code>Z:\allpatentsprocessed\DistinctAssignees2.txt </code><br>
-**Match them against themselves
+::Match them against themselves
 :<code>Z:\allpatentsprocessed\DistinctAssignees2matched.txt </code>