I have a problem in merging files for a big data sets like below. I want you help me to let me know the script that can do such task.
fine name: fluxes_year_lat_long I have 30 years of daily fluxes files for more that 100 location(lat_long) I want to merge from year 1 to year 30 of each point files.
my file looks like this
2000 1 1 5000 .... 2000 1 2 2000 .... . . . 2000 12 31 5000 YYYY M D Fluxes
2001 1 1 5000 YYYY M D Fluxes . . .
all the way to:
2030 1 1 5000 YYYY M D Fluxes . . .
The number of rows for each file is the same.
I want the output to be merging the daily fluxes from year 2000 to 2030 for each point's location like
YYYY MM DD Fluxes value.
In addition, I want the script read and merge file starting with the name fluxes_. I appreciate your response.