460
edits
Changes
Jump to navigation
Jump to search
no edit summary
{{#default_form:McNair FacultyProjects|Project Title=Matching VentureOne (Other),|Topic Area=Patents and Innovation,|Owner=Ariel Sun,|Start Term=Summer 2016,|Status=Active,|Deliverable=Other,}} ==Data==*Get the source file for the VentureOne data:<code>E:\McNair\Projects\Venture One Data\Venture Data 1.xlsx</code> Original data source *Clean it up:<code>E:\McNair\Software\Scripts\Matcher\Input\Venture Data 1.txt</code> extraneous symbols and words removed *Match it against itself:<code>E:\McNair\Projects\Venture One Data\Cleaned and Matched Data.xlsx</code> *Get the patent data**Draw the distinct assignees :<code>Z:\allpatentsprocessed\DistinctAssignees2.txt </code><br>**Match them against themselves:<code>Z:\allpatentsprocessed\DistinctAssignees2matched.txt </code> *Match venture data to patent data:<code>Z:\allpatentsprocessed\Venture Patent Matched.txt</code> *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 secondjoin_cleaned</code>*Join <code>secondjoin_cleaned</code> data to <code>venturepatentmatched</code> data, creating fourthjoin_cleaned</code>
