What is the correct way to report historical daily Max / Min / Avg Temperature by City? I starting a weather project where I'm using ERA5 hourly dataset (ref: https://cds.climate.copernicus.eu/cdsapp#!/dataset/reanalysis-era5-single-levels?tab=form). Using this dataset in python, I have now a dataframe as below.
As you can see, for one State I have n observations considering latitude|longitude and Time of observation. So, now I would like to aggregate this dataset daily, considering Admin2 and Admin1, in order to have Max Temp, Min Temp and Total precipitation. Is there a right way to do this aggregation or is this simple the max / min values from 2m temp and sum of precipitation?
As you can see, by the content of my question, I'm not a meterologist. I'm just trying to build a reliable database for past historical weather data from some cities around the world.
Yes, daily minima, maxima and precipitation totals are calculated simply as you suggested in your question. Take care that there aren't missing values,, but that's more of an issue calculating means. Also check whether the reported values for precipitation are in fact a null value, it's unlikely that it could be measured in such small units.