668
edits
Changes
Jump to navigation
Jump to search
==Work Description==
*Get the source file for the LBOs
:<code>E:\McNair\Projects\LBO\LBO_List_and_data.xlsx</code> Original data source
*Clean it up
:<code>E:\McNair\Projects\LBO\LBO_cleaned_data.xlsx</code> Names of LBO's/deal numbers with extraneous symbols and words removed
*Match it against itself
:<code>E:\McNair\Software\Scripts\Matcher\Output\LBO_cleaned_data.txt-LBO_cleaned_data.txt.matched</code> Original matched data
:<code>E:\McNair\Projects\LBO\LBO_cleaned_data_duplicates_removed</code>
*Get the patent data
:Draw the distinct assignees
::<code>Z:\allpatentsprocessed\DistinctAssignees2</code>
:Match them against themselves
::<code>Z:\allpatentsprocessed\DistinctAssignees2matched</code>
*Load the LBO data into a dbase
*match the LBO data to the patent data
:<code>Z:\allpatentsprocessed\LBO Patent matched</code>
*Note - all data in allpatentsprocessed database
: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. 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>
*create table lbopatentinfo showing lbo names, patent numbers, and grant dates of the patents
*use lbopatentinfo to create table lbopatentsummary to show lbo names, amount of patents they have, minimum grant date years, maximum grant date years, and average grant date years
*import lbo data matched against itself into table(lbodistinct), then use that table and lbopatentsummary to create to create lbofinal. lbofinal then shows distinct lbonames, number of patents, minimum grant year, maximum grant year, and average grant year
*use lbofinal to create lboreallyfinal. lboreallyfinal is the same as lbofinal but with null space in number of patents replaced with 0
*FINAL DATA IN THE FOLLOWING FOLDER
:<code>E:\McNair\Projects\LBO</code>
*After getting lboreallyfinal, create a table with all of its columns in addition to the lbo deal numbers, and whether it was public to private or private to private in the following steps
#import LBOcleaneddata.txt into table dealnumbxcleannames. it will have the deal numbers and cleaned original lbo names (duplicates not removed)
#import Originallbomatch.txt into table lbonamesxcleannames. it will have the matched standardized lbo names and the cleaned original lbo names
#join those two tables together to reach the standardized lbo names with the deal numbers in table lbonamesxdealnumb, and create a column that says whether the deal was public to private or private to private in the table lboxpriv
#join lbo_list_and_data and lbopatentmatch together using lboxpriv as a go between. this provides a reference in case we want to join using stdorgname to the patent database
#join lbo_list_and_data and lboreallyfinal together using lboxpriv as a go between. this is the final table it can be found in the following folder under the name lbopatentsreallyfinal
:<code>E:\McNair\Projects\LBO\Data Sets</code>
The Effect of Leverage Buyouts on Innovation (view source)
Revision as of 10:42, 5 July 2016
, 10:42, 5 July 2016no edit summary
==Abstract==
This academic paper investigates the current trend of leveraged buyouts (LBO) in the US financial market and assesses its impacts on innovative activities within the firms that undergo LBOs.
==Work Description==
*Get the source file for the LBOs
:<code>E:\McNair\Projects\LBO\LBO_List_and_data.xlsx</code> Original data source
*Clean it up
:<code>E:\McNair\Projects\LBO\LBO_cleaned_data.xlsx</code> Names of LBO's/deal numbers with extraneous symbols and words removed
*Match it against itself
:<code>E:\McNair\Software\Scripts\Matcher\Output\LBO_cleaned_data.txt-LBO_cleaned_data.txt.matched</code> Original matched data
:<code>E:\McNair\Projects\LBO\LBO_cleaned_data_duplicates_removed</code>
*Get the patent data
:Draw the distinct assignees
::<code>Z:\allpatentsprocessed\DistinctAssignees2</code>
:Match them against themselves
::<code>Z:\allpatentsprocessed\DistinctAssignees2matched</code>
*Load the LBO data into a dbase
*match the LBO data to the patent data
:<code>Z:\allpatentsprocessed\LBO Patent matched</code>
*Note - all data in allpatentsprocessed database
: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. 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>
*create table lbopatentinfo showing lbo names, patent numbers, and grant dates of the patents
*use lbopatentinfo to create table lbopatentsummary to show lbo names, amount of patents they have, minimum grant date years, maximum grant date years, and average grant date years
*import lbo data matched against itself into table(lbodistinct), then use that table and lbopatentsummary to create to create lbofinal. lbofinal then shows distinct lbonames, number of patents, minimum grant year, maximum grant year, and average grant year
*use lbofinal to create lboreallyfinal. lboreallyfinal is the same as lbofinal but with null space in number of patents replaced with 0
*FINAL DATA IN THE FOLLOWING FOLDER
:<code>E:\McNair\Projects\LBO</code>
*After getting lboreallyfinal, create a table with all of its columns in addition to the lbo deal numbers, and whether it was public to private or private to private in the following steps
#import LBOcleaneddata.txt into table dealnumbxcleannames. it will have the deal numbers and cleaned original lbo names (duplicates not removed)
#import Originallbomatch.txt into table lbonamesxcleannames. it will have the matched standardized lbo names and the cleaned original lbo names
#join those two tables together to reach the standardized lbo names with the deal numbers in table lbonamesxdealnumb, and create a column that says whether the deal was public to private or private to private in the table lboxpriv
#join lbo_list_and_data and lbopatentmatch together using lboxpriv as a go between. this provides a reference in case we want to join using stdorgname to the patent database
#join lbo_list_and_data and lboreallyfinal together using lboxpriv as a go between. this is the final table it can be found in the following folder under the name lbopatentsreallyfinal
:<code>E:\McNair\Projects\LBO\Data Sets</code>
==Compustat Variables==
RE -- Retained Earnings
==References==
