按月份合并指定分类并对对应amount值求均值的R数据处理问题
方案1:使用dplyr(tidyverse套件)实现
library(dplyr) # 拆分保留A/B类数据,汇总C/D/E类为F类 df_ab <- df %>% filter(category %in% c("A", "B")) df_f <- df %>% filter(category %in% c("C", "D", "E")) %>% group_by(month) %>% summarise(amount = mean(amount), .groups = "drop") %>% mutate(category = "F") # 合并得到最终结果 result <- bind_rows(df_ab, df_f) %>% arrange(month, category)
也可以写成单管道流式写法:
result <- df %>% mutate(category = ifelse(category %in% c("C", "D", "E"), "F", category)) %>% group_by(month, category) %>% summarise(amount = ifelse(category == "F", mean(amount), first(amount)), .groups = "drop")
输出结果样例:
| category | amount | month |
|---|---|---|
| A | 4 | Dec |
| B | 5 | Dec |
| F | 8.666667 | Dec |
| A | 9 | Jan |
| B | 11 | Jan |
| F | 6.666667 | Jan |
方案2:使用base R实现
# 提取A、B类原始数据 df_ab <- df[df$category %in% c("A", "B"), ] # 按月份计算C/D/E类均值,生成F类数据 df_f <- aggregate(amount ~ month, data = df[df$category %in% c("C","D","E"), ], FUN = mean) df_f$category <- "F" # 合并并重排结果 result <- rbind(df_ab, df_f[, names(df_ab)]) result <- result[order(result$month, result$category), ]
内容的提问来源于stack exchange,提问作者olo
相关产品推荐
相关产品推荐

