You need to enable JavaScript to run this app. 按月份合并指定分类并对对应amount值求均值的R数据处理问题
优惠活动
大模型
产品
解决方案
定价
更多

按月份合并指定分类并对对应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")

输出结果样例:

categoryamountmonth
A4Dec
B5Dec
F8.666667Dec
A9Jan
B11Jan
F6.666667Jan

方案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

相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级,最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分), 限时 9.9 元起

最近更新时间:2026.10.15 23:45:03