Resample dataframe `frame` to resolution of 1 hour `1H` for timeseries index, summing values in the column `radiation` averaging those in column `tamb`
frame.resample('1H').agg({'radiation': np.sum, 'tamb': np.mean})