460
edits
Changes
Jump to navigation
Jump to search
no edit summary
:<code>E:\McNair\Software\Scripts\Matcher\Input\Venture Data 1.txt</code> extraneous symbols and words removed
*Match it against itselfto get standardized entity names
:<code>E:\McNair\Projects\Venture One Data\Cleaned and Matched Data.xlsx</code>
::Draw the distinct assignees
:<code>Z:\allpatentsprocessed\DistinctAssignees2.txt </code><br>
::Match them against themselvesto 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>
*Match 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>Z:\allpatentsprocessed\Venture Patent Matched.txtfourthjoin_cleaned</code>
*Join <code>patent</code> data to <code>assignee</code> dataFinal summary Tables#Summary table displaying number of patents, creating <code>firstjoin_cleaned</code>*Join <code>firstjoin_cleaned</code> data to <code>matchassignee</code> dataminimum grant year, creating maximum grant year and average grant year for each company <code>secondjoin_cleanedE:\McNair\Projects\Venture One Data\venturepatentreallyfinal.txt</code>*Join <code>secondjoin_cleaned</code> data to <code>venturepatentmatched</code> data, creating #A table of all patent information for each company that has patent <code>fourthjoin_cleanedE:\McNair\Projects\Venture One Data\venturepatentfullyjoined.txt</code>
