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.

Data Processing

• Get the VentureOne data ready

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

• Match it against itself to get standardized entity names

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

• Get the patent data ready

Draw the distinct assignees

Z:\allpatentsprocessed\DistinctAssignees2.txt

Match them against themselves to get standardized org names for patent data

Z:\allpatentsprocessed\DistinctAssignees2matched.txt

• Match standardized org names of patent data to standardized entity names of venture data

Z:\allpatentsprocessed\Venture Patent Matched.txt

• Join patent data to venture data to get patent information of each venture-backed companies

1. Join patent data to assignee data, creating firstjoin_cleaned
2. Join firstjoin_cleaned data to matchassignee data, creating secondjoin_cleaned
3. Join secondjoin_cleaned data to venturepatentmatched data, creating fourthjoin_cleaned

• Final summary Tables

1. Summary table displaying number of patents, minimum grant year, maximum grant year and average grant year for each company E:\McNair\Projects\Venture One Data\venturepatentreallyfinal.txt
2. A table of all patent information for each company that has patent E:\McNair\Projects\Venture One Data\venturepatentfullyjoined.txt