A quite simple question that I hope someone can help me with. I have a massive database of hourly minimum and maximum temperatures, from many automatic weather stations. I need to estimate the average monthly minimum, maximum and mean temperatures for each stations, like that provided by climatologies such as bioclim, worldclim, CHELSA, etc.
Given the following one-day example data:
Date Time tMin tMax
1 2009-05-01 0 24.2 24.4
2 2009-05-01 100 24.1 24.3
3 2009-05-01 200 24.0 24.2
4 2009-05-01 300 23.8 24.1
5 2009-05-01 400 23.7 23.9
6 2009-05-01 500 23.6 23.8
7 2009-05-01 600 23.5 23.6
8 2009-05-01 700 23.5 23.7
9 2009-05-01 800 23.3 23.7
10 2009-05-01 900 23.4 23.5
11 2009-05-01 1000 23.4 24.2
12 2009-05-01 1100 24.2 26.2
13 2009-05-01 1200 26.2 28.4
14 2009-05-01 1300 27.5 29.8
15 2009-05-01 1400 28.3 30.1
16 2009-05-01 1500 28.4 30.9
17 2009-05-01 1600 30.5 31.7
18 2009-05-01 1700 30.7 31.9
19 2009-05-01 1800 29.5 31.2
20 2009-05-01 1900 27.9 30.6
21 2009-05-01 2000 27.6 28.6
22 2009-05-01 2100 26.3 27.6
23 2009-05-01 2200 25.3 26.2
24 2009-05-01 2300 24.6 25.7
How do I calculate the required parameters? I'm confused between two options:
1) Simply by calculating the average of each column each day, and then averaging these averages to calculate the mean temperature: (tMin average: 25.7; tMax average: 26.8; and tMean: 26.2).
2) Picking the lowest daily minimum temperature (23.3), and the highest daily maximum temperature (31.9), and then averaging both (27.6).
Then, once I've got the dailies information estimated, I think I must to calculate the overall average for each of the three parameters each month.
Any feedback will be more than appreciated!
Best!