Difference between revisions of "Matching VentureOne (Data)"

From edegan.com
Jump to navigation Jump to search
Line 9: Line 9:
  
 
==Data==
 
==Data==
#Get the source file for the LBOs
+
#Get the source file for the VentureOne data
 
:E:\McNair\Projects\Venture One Data\Venture Data 1.xlsx Original data source
 
:E:\McNair\Projects\Venture One Data\Venture Data 1.xlsx Original data source
  

Revision as of 10:08, 14 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

  1. Get the source file for the VentureOne data
E:\McNair\Projects\Venture One Data\Venture Data 1.xlsx Original data source
  1. Clean it up
E:\McNair\Software\Scripts\Matcher\Input\Venture Data 1.txt extraneous symbols and words removed
  1. Match it against itself
E:\McNair\Projects\Venture One Data\Cleaned and Matched Data.xlsx
  1. Get the patent data
    1. Draw the distinct assignees
    2. Match them against themselves
  2. Load the LBO data into a dbase