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
Bayestest model not showing posterior probabilitiesDear Stata Users community, I am trying to compare the posterior probabilities of a series of ologi…
Variable Construction based on Time StampsDear Statalist, I have a dataset that records the time when staffs successfully pick the products a…
filling in missing values for panel dataHi there, I have panel data in which the education variable has missing values. I must use the surr…
DEA commands: dea vs. teradialbcGood day, Using the dea command produces technical efficiency scores with values b/t 0-1. However, …
Loading database file via ODBCUsing Stata 16.1 on Windows server 2012 with 256GB of memory. Trying to load 400GB MySQL database ta…
Subscribe to:
Post Comments (Atom)
0 Response to Merge multiple csv files
Post a Comment