我有一个数据帧"DF1",其中有两列可能有重复数据,例如:
日期 | 名称 | |
---|---|---|
2022-03-13 | 鲍勃 | |
2022-03-13 | Bob | |
2022-03-13 | 蒂姆 | |
2022-03-14 | 鲍勃 | |
2022-03-13 | 蒂姆 | |
2022-03-14 | Jim |
获取前缀"计数";您可以使用paste()
功能,例如
library(dplyr)
df <- read.table(text = "Date Name
2022-03-13 Bob
2022-03-13 Bob
2022-03-13 Tim
2022-03-14 Bob
2022-03-13 Tim
2022-03-14 Jim", header = TRUE)
df %>%
group_by(Name, Date) %>%
summarise(Count = paste("Count", n(), sep = " ")) %>%
arrange(desc(Count))
#> `summarise()` has grouped output by 'Name'. You can override using the
#> `.groups` argument.
#> # A tibble: 4 × 3
#> # Groups: Name [3]
#> Name Date Count
#> <chr> <chr> <chr>
#> 1 Bob 2022-03-13 Count 2
#> 2 Tim 2022-03-13 Count 2
#> 3 Bob 2022-03-14 Count 1
#> 4 Jim 2022-03-14 Count 1
创建于2022-08-15由reprex包(v2.0.1(