我有一个数据集,每小时降雨量(mm),我希望计算平均日降雨量。以20.00作为起始点和端点,而不是00.00 - 24.00。是否有可能从20点到20点得到平均值(降雨量)?
这是包含日期、时间和降雨量(mm)的数据集。https://drive.google.com/file/d/1JlEGTsJpAAVBQW2v6VTD3B-mrp9W6tWD/view?usp=sharing
发布于 2022-05-18 21:20:40
就像这样:
library(lubridate)
library(tidyverse)
df %>%
filter(row_number() != 1:20) %>%
mutate(x_axis = trimws(`Date and time`, whitespace = ' .*')) %>%
group_by(group_id = cumsum(Hour == 20)) %>%
mutate(mean20_20 = mean(`Rainfall mm`)) %>%
slice(1) %>%
drop_na() %>%
ggplot(aes(x = x_axis, y=mean20_20, group=1)) +
geom_point(size= 1, color = "blue")+
geom_line(color = "red")+
theme_minimal()+
theme(axis.text.x = element_text(angle = 45, vjust = 0.5, hjust=1))
https://stackoverflow.com/questions/72295274
复制相似问题