我有这个df:
structure(list(CN = c("BR", "BR", "BR", "PL", "PL", "PL",
"BR", "BR", "BR", "BR", "PL", "PL", "PL"), Year = c(2019,
2019, 2019, 2019, 2019, 2019, 2020, 2020, 2020, 2020, 2020, 2020,
2020), Squad = c("A", "B", "C", "A", "B", "C", "C", "F", "G",
"I", "D", "E", "F"), X = c(1, 2, 3, 1, 2, 3, 1, 2, 3, 1, 2, 3,
1), Y = c(1, 2, 3, 1, 2, 3, 1, 2, 3, 1, 2, 3, 1)), row.names = c(NA,
-13L), class = c("tbl_df", "tbl", "data.frame"))
我想总结一下(x+y和阵容总数之和),按CN和年份分组;在相同的 struct 中,添加一列,其中包含仅按CN分组的团队的唯一/不同值的计数.
看起来是这样的:
structure(list(CN = c("BR", "BR", "PL", "PL"), Year = c(2019,
2020, 2019, 2020), Sum = c(12, 14, 12, 12), n_squad = c(3, 4,
3, 3), n_squad_distinct = c(6, 6, 6, 6)), row.names = c(NA, -4L
), class = c("tbl_df", "tbl", "data.frame"))
谢谢