我正在try 使用滑块函数来平均天气数据.我本质上想要以10天为增量进行绑定.所以1到10天,11到20天,21到30天.以下是一些示例数据:
historicalWeatherSummary <- structure(list(Historical_date = structure(c(3286, 3287, 3288,
3289, 3290, 3291), class = "Date"), daily_min_temp_daytime = c(25.29,
33.28, 39.33, 14.02, -2.47, 1.02), daily_min_temp_nighttime = c(25.45,
29.82, 36.66, 6.3, -2.72, 1.18)), class = c("grouped_df", "tbl_df",
"tbl", "data.frame"), row.names = c(NA, -6L), groups = structure(list(
Historical_date = structure(c(3286, 3287, 3288, 3289, 3290,
3291), class = "Date"), .rows = structure(list(1L, 2L, 3L,
4L, 5L, 6L), ptype = integer(0), class = c("vctrs_list_of",
"vctrs_vctr", "list"))), class = c("tbl_df", "tbl", "data.frame"
), row.names = c(NA, -6L), .drop = TRUE))
我正在使用下面的代码,我肯定没有正确使用它.
tenDayWindows <- historicalWeatherSummary %>%
ungroup() %>%
arrange(Historical_date) %>%
mutate(`1to10_avg_min_daytime_temp` = slide_dbl(daily_min_temp_daytime, ~mean(.x), .after = 10, .complete = TRUE),
`1to10_avg_min_nighttime_temp` = slide_dbl(daily_min_temp_nighttime, ~mean(.x), .after = 10, .complete = TRUE),
`11to20_avg_min_daytime_temp` = slide_dbl(daily_min_temp_daytime, ~mean(.x), .step = 10, .after = 10, .complete = TRUE),
`11to20_avg_min_nighttime_temp` = slide_dbl(daily_min_temp_nighttime, ~mean(.x), .after = 10, .step = 10, .complete = TRUE),
`21to30_avg_min_daytime_temp` = slide_dbl(daily_min_temp_daytime, ~mean(.x), .after = 10, .step = 20, .complete = TRUE),
`21to30_avg_min_nighttime_temp` = slide_dbl(daily_min_temp_nighttime, ~mean(.x), .after = 10, .step = 20, .complete = TRUE),
)
我的思维过程是,在步数为10和步数为20之后,它会计算出10行的平均值.有人能给我指个正确的方向吗?我正在查看指定日期后第1天到第10天、第11天到20天和第21天到30天的平均值.
编辑-添加的图像示例: