I have yearly data e.g., 2012-2022. Each year has seperate folder contaning approx 17000 csv files. csv file names are same for each year in separate folder. For example
(2012 folder) > sta_x1_y1.csv – sta_x179_y225.csv (17000 files)
(2013 folder) > sta_x1_y1.csv – sta_x179_y225.csv (17000 files)
.
.
(2022 folder) > sta_x1_y1.csv – sta_x179_y225.csv (17000 files)
I want to merge all these files based on the name. Each station file (sta_x1_y1.csv) should contain all the data from 2012 to 2022 in one csv.
no experience with scripting language.
New contributor
Asfand Tehseen is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.