668
edits
Changes
Jump to navigation
Jump to search
The Effect of Leverage Buyouts on Innovation (view source)
Revision as of 12:30, 16 June 2016
, 12:30, 16 June 2016→Work Description
:access it by logging on to <code>researcher@McNair DBServ:/bulk/allpatentsprocessed</code>
*Join patent data to assignee data, creating firstjoin_cleaned . firstjoin_cleaned shows organization names of assignees from the patent data and their patent numbers
:again, just look inside database
*join firstjoin_cleaned to matchassignees data, creating secondjoin_cleaned. secondjoin_cleaned shows standardized organization names, organization names, and patent numbers
*join secondjoin_cleaned to lbopatentmatch data, creating thirdjoin_cleaned. This final step matches the LBO data with the patent data, creating a list of thirdjoin_cleaned shows LBO's names, standardized organization names, and their patent numbers in order to show lbo's that had patents
:a text file of the final copy can be found here
::<code>Z:\allpatentsprocessed\LBO Patent Data Joined</code>
