460
edits
Changes
Jump to navigation
Jump to search
<noinclude>{{McNair Projects|Project Title=Matching VentureOne (Other),|Topic Area=Patents and Innovation,|Owner=Ariel Sun,This is the "McNair Faculty" form.|Start Term=Summer 2016,To create a page with this form|Status=Active, enter the page name below;if a page with that name already exists|Deliverable=Other, you will be sent to a form to edit that page.}}
{{#forminput*Clean it up:form=<code>E:\McNair Faculty}}\Software\Scripts\Matcher\Input\Venture Data 1.txt</code> extraneous symbols and words removed
'''Free text*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>
{{{standard input|free text|rows=10}}}
{{{standard input|summary}}}*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>{{{standard input|minor edit}}} {{{standard input|watch}}} {{{standard input|save}}} {{{standard input|preview}}} {{{standard input|changes}}} {{{standard input|cancel}}}*Join <code>secondjoin_cleaned</code> data to <code>venturepatentmatched</code> data, creating fourthjoin_cleaned</includeonlycode>
no edit summary
==Data==
*Get the source file for the VentureOne data
:<code>E:\McNair\Projects\Venture One Data\Venture Data 1.xlsx</code> Original data source
*Match it against itself:</noinclude><includeonlycode><div id="wikiPreview" style="displayE: none; padding-bottom: 25px; margin-bottom: 25px; border-bottom: 1px solid #AAAAAA;">\McNair\Projects\Venture One Data\Cleaned and Matched Data.xlsx</divcode>{{{for template|Infobox McNair Faculty}}}{| class="formtable"! Name: | {{{field|Name}}}|-! Title: | {{{field|Title}}}|-! Degree: | {{{field|Degree}}}|-! School: | {{{field|School}}}|-! Phone Number: | {{{field|Phone Number}}}|-! Email Address: | {{{field|Email Address}}}|-! Skype Name: | {{{field|Skype Name}}}|-! Date Joined: | {{{field|Date Joined}}}|}{{{end template}}}
*Match venture data to patent data
:<code>Z:\allpatentsprocessed\Venture Patent Matched.txt</code>
