I was wondering if there is a method in R for the following scenario:
I have collected data from various weather stations in the area. In order to do my analysis, I want to combine the values from each station to create the average picture for the area. All of the data is in the exact same format (example below) so I would want to keep the Day/Month/Year the same while averaging the individual cells in the other columns.
| Day | Month | Year | Min Temp | Max Temp | Mean Temp | Humidity |
|---|---|---|---|---|---|---|
| 1 | 1 | 2023 | 1 | 15 | 8 | 98 |
| 2 | 1 | 2023 | -2 | 9 | 3.5 | 82 |
The only solutions I can think of are more manual – adding the columns and then creating an average but this does not seem practical if I increase the types of observations (and therefore increase the number of columns significantly) and have even more sources and therefore dozens of tables.
I appreciate any advice on this!