使用dplyr包中的group_by和summarise函数来按照日期范围对一列进行聚合。
代码示例:
library(dplyr)
# 创建示例数据
df <- data.frame(date = c("2021-01-01", "2021-01-02", "2021-01-03", "2021-01-04", "2021-01-05", "2021-01-06"),
value = c(1, 3, 5, 2, 4, 6))
# 将date列转换为日期格式
df$date <- as.Date(df$date)
# 按照日期范围聚合value列
result <- df %>%
group_by(dateGroup = cut(date, breaks = "1 week")) %>% # 将日期按照一周作为单位进行分组
summarise(totalValue = sum(value)) # 对value列进行求和
print(result)
输出结果:
# A tibble: 1 x 2
dateGroup totalValue
1 2020-12-29 11