I wish to calculate the mean temperature data for 1 km grid cells from a list of csv files containing 1 km grid cell max and min daily values for individual months.
Here are the numbers of files I am dealing with and their approximate data. A problem is that the first two columns contain coordinate data which shouldn't be averaged. Another problem may be that January, February and March contain have differing numbers of days and so will have different numbers of columns.
Here are the numbers of files I am dealing with and a rough overview of my approach to achieving the desired result:
Here is an example of a data file:
I have already tried to import multiple files using the list.files() function but think I require some guidance on breaking down the stages of the above.
I could do this by hand but it would take a few days, and I wouldn't learn anything.
Any help is much appreciated, thank you.