将每小时降雨数据转换为特定时间间隔内的每日降雨数据 [英] convert hourly rainfall data into daily in specific time interval

问题描述

我有很长一段时间的每小时降雨量和温度数据.我想从每小时数据中获取每日价值.我正在考虑从 07:00:00 到第二天 07:00:00 的日期.

I have hourly rainfall and temperature data for long period. I would like to get daily values from hourly data. I am considering day means from 07:00:00 to next day 07:00:00.

您能告诉我如何在特定时间间隔之间将每小时数据转换为每天吗?

Could you tell me how to convert hourly data to daily between specific time interval?

示例:07:00:00 到 07:00:00 或 12:00:00 到 12:00:00)

降雨数据如下:

1970-01-05 00:00:00      1.0 
1970-01-05 01:00:00      1.0
1970-01-05 02:00:00      1.0
1970-01-05 03:00:00      1.0
1970-01-05 04:00:00      1.0
1970-01-05 05:00:00      3.6
1970-01-05 06:00:00      3.6
1970-01-05 07:00:00      2.2
1970-01-05 08:00:00      2.2
1970-01-05 09:00:00      2.2
1970-01-05 10:00:00      2.2
1970-01-05 11:00:00      2.2
1970-01-05 12:00:00      2.2
1970-01-05 13:00:00      2.2
1970-01-05 14:00:00      2.2
1970-01-05 15:00:00      2.2
1970-01-05 16:00:00      0.0
1970-01-05 17:00:00      0.0
1970-01-05 18:00:00      0.0
1970-01-05 19:00:00      0.0
1970-01-05 20:00:00      0.0
1970-01-05 21:00:00      0.0
1970-01-05 22:00:00      0.0
1970-01-05 23:00:00      0.0
1970-01-06 00:00:00      0.0

推荐答案

你可以用这个代码:

fun <- function(s,i,j) { sum(s[i:(i+j-1)]) }
sapply(X=seq(1,24*nb_of_days,24),FUN=fun,s=your_time_serie,j=24)

您只需将 1 更改为另一个值即可获得不同的时间间隔:07:00:00 到 07:00:00 的 8 个或 12:00:00 的 13 个到 12:00:00

You just have to change 1 to another value to have different interval of time : 8 of 07:00:00 to 07:00:00 or 13 for 12:00:00 to 12:00:00

这篇关于将每小时降雨数据转换为特定时间间隔内的每日降雨数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！