Changes

#Clean it up <code>E:\McNair\Software\Scripts\Matcher\Input\Venture Data 1.txt</code> extraneous symbols and words removed

#Match it against itself to get standardized entity names <code>E:\McNair\Projects\Venture One Data\Cleaned and Matched Data.xlsx</code>

;*Get the patent data ready

#Draw the distinct assignees <code>Z:\allpatentsprocessed\DistinctAssignees2.txt </code>

#Match them against themselves to get standardized org names for patent data <code>Z:\allpatentsprocessed\DistinctAssignees2matched.txt </code>

;*Match standardized org names of patent data to standardized entity names of venture data

:<code>Z:\allpatentsprocessed\Venture Patent Matched.txt</code>

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

#Join <code>patent</code> data to <code>assignee</code> data, creating <code>firstjoin_cleaned</code>

#Join <code>firstjoin_cleaned</code> data to <code>matchassignee</code> data, creating <code>secondjoin_cleaned</code>

#Join <code>secondjoin_cleaned</code> data to <code>venturepatentmatched</code> data, creating <code>fourthjoin_cleaned</code>

*Final summary Tables

#Summary table displaying number of patents, minimum grant year, maximum grant year and average grant year for each company <code>E:\McNair\Projects\Venture One Data\venturepatentreallyfinal.txt</code>

#A table of all patent information for each company that has patent <code>E:\McNair\Projects\Venture One Data\venturepatentfullyjoined.txt</code>