首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >按子组dplyr汇总

问按子组dplyr汇总
EN

Stack Overflow用户
提问于 2020-04-13 19:09:15
回答 2查看 60关注 0票数 1

我是dyplr的新手,我正在努力使用摘要函数来获得像比例这样简单的东西。

我的数据集的一部分

代码语言:javascript
复制
city = rep(c("A","B"), each = 5)
month = c("Jan","Jan","Jan","Feb","Feb","Jan","Jan","Feb","Feb","Feb")
species = c("aegypti","gambiae","quinque","aegypti","quinque",
            "aegypti","gambiae","quinque","aegypti","quinque")
total = c(20, 5, 25, 12, 23, 10, 10, 0, 20, 0)
df = data.frame(city, month, species, total)

然后我要计算每个城市每个月每个物种的比例。我可以计算每个城市和每个月的总数。

代码语言:javascript
复制
df %>% group_by(city, month) %>% summarise(total = sum(total))

# A tibble: 4 x 3
# Groups:   city [2]
#  city  month total
#  <fct> <fct> <dbl>
#1 A     Feb      35
#2 A     Jan      50
#3 B     Feb      20
#4 B     Jan      20

然后我可以按物种单独计算

代码语言:javascript
复制
df %>% group_by(city, month, species) %>% summarise(total = sum(total)

# A tibble: 9 x 4
# Groups:   city, month [4]
#  city  month species total
#  <fct> <fct> <fct>   <dbl>
#1 A     Feb   aegypti    12
#2 A     Feb   quinque    23
#3 A     Jan   aegypti    20
#4 A     Jan   gambiae     5
#5 A     Jan   quinque    25
#6 B     Feb   aegypti    20
#7 B     Feb   quinque     0
#8 B     Jan   aegypti    10
#9 B     Jan   gambiae    10

但我需要这样的东西来计算比例。我希望这张桌子看起来像这样。

代码语言:javascript
复制
# A tibble: 9 x 4
# Groups:   city, month [4]
#  city  month species total total1 prop
#  <fct> <fct> <fct>   <dbl> <dbl>  <dbl>
#1 A     Feb   aegypti    12   35    34.29
#2 A     Feb   quinque    23   35    65.71
#3 A     Jan   aegypti    20   50    40.00
#4 A     Jan   gambiae     5   50    10.00
#5 A     Jan   quinque    25   50    50.00
#6 B     Feb   aegypti    20   20   100.00
#7 B     Feb   quinque     0   20     0
#8 B     Jan   aegypti    10   20    50.00
#9 B     Jan   gambiae    10   20    50.00

我一直在玩,但我找不到做这事的方法。谢谢!

EN

回答 2

Stack Overflow用户

回答已采纳

发布于 2020-04-13 19:11:28

group_by city和month,并将total除以组中的sum以获得比例。

代码语言:javascript
复制
library(dplyr)
df %>% group_by(city, month) %>% mutate(total = total/sum(total) * 100)

#  city  month species total
#   <fct> <fct> <fct>   <dbl>
# 1 A     Jan   aegypti  40  
# 2 A     Jan   gambiae  10  
# 3 A     Jan   quinque  50  
# 4 A     Feb   aegypti  34.3
# 5 A     Feb   quinque  65.7
# 6 B     Jan   aegypti  50  
# 7 B     Jan   gambiae  50  
# 8 B     Feb   quinque   0  
# 9 B     Feb   aegypti 100  
#10 B     Feb   quinque   0  

或在基数R中:

代码语言:javascript
复制
df$total <- with(df, total/ave(total, city, month, FUN = sum))
票数 1
EN

Stack Overflow用户

发布于 2020-04-14 02:04:23

我们可以使用data.table

代码语言:javascript
复制
library(data.table)
setDT(df)[, total := total/sum(total) * 100, .(city, month)]
票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/61186579

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档