Dear all,
I have a set of csv files named firm1, firm2, ..., firmn. Each file contains a specific date range (for instance, firm1 may have dates from Jan 1, 2000 to Dec 31, 2015 and firm2 may have dates from Apr 1, 2008 to Dec 31, 2020) and data for four variables with the same name in each file (var1, var2, var3 and var4). I want to merge all these csv files into one with dates from Jan 1, 2000 to Dec 31, 2020 (max range), keep observations according to their dates, and for the four variables to add as termination the name of the firm (e.g., var1firm1, var1firm2, var2firm1, var2firm2 and so on).
Thanks in advance for your help.
Related Posts with Merge multiple csv files
Generating variable for a range of datesHi, I am looking to create a variable that encompasses several dates. I am doing a project on produ…
Trouble working with panel data and including too many dummy variablesI am analyzing public and charter high schools in the state of California. I am interested in Charte…
Check whether coefficients are significant using 2 SE bandsHello, I am reading a paper and it says that the following figure (which draws 2 SE bands) is used …
how to calculate the typical paper:change in relative wage1963-1987: suppl and demand in stata(is there an order?)does anyone know how to calculate the typical paper:change in relative wage1963-1987: suppl and dema…
set quarterly datesDear All, I have this dataset, Code: * Example generated by -dataex-. To install: ssc install data…
Subscribe to:
Post Comments (Atom)
0 Response to Merge multiple csv files
Post a Comment