计算R中每个组中有多少下降 [英] Count how many fall in each group in R

问题描述

我有类似的数据:

  User id    Ranking   Country 
    1           1         USA 
    2           3         AUS 
    3           1         USA 
    4           1         AUS 
    5           2         USA

，我希望得到以下结果:

and I would like to have the following results:

USA Ranking 1 = 2
USA Ranking 2 = 1
USA Ranking 3 = 0
AUS Ranking 1 = 1
AUS Ranking 2 = 0
AUS Ranking 3 = 1

请问如何在R中执行此操作?

How may I do this in R please?

推荐答案

一种 dplyr 方法.如果需要，很容易更改.

A dplyr approach. Pretty easy to alter if wanted.

library(dplyr)
df = data.frame(
  UserID = seq(1:5),
  Ranking = c(1, 3, 1, 1, 2),
  Country = c("USA", "AUS", "USA", "AUS", "USA")
)


df_2 <- df %>% 
  group_by(Country, Ranking) %>% 
  summarise(Counts = n())

df_2

  Country Ranking Counts
1 AUS           1      1
2 AUS           3      1
3 USA           1      2
4 USA           2      1

这篇关于计算R中每个组中有多少下降的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！