如何计算每个页面名称的不同visit_id的数量？
visit_id post_pagename
1 A
1 B
1 C
1 D
2 A
2 A
3 A
3 B
结果应为：
post_pagename distinct_visit_ids
A 3
B 2
C 1
D 1
尝试了
test_df<-data.frame(cbind(c(1,1,1,1,2,2,3,3),c("A","B","C","D","A","A","A","B")))
colnames(test_df)<-c("visit_id","post_pagename")
test_df
test_df %>%
group_by(post_pagename) %>%
summarize(vis_count = n_distinct(visit_id))
但这仅给我数据集中不同的visit_id的数量
test_df %>%
distinct() %>%
count(post_pagename)
# post_pagename n
# <fct> <int>
# 1 A 3
# 2 B 2
# 3 C 1
# 4 D 1
test_df %>%
group_by(post_pagename) %>%
summarise(distinct_visit_ids = n_distinct(visit_id))
# A tibble: 4 x 2
# post_pagename distinct_visit_ids
# <fct> <int>
#1 A 3
#2 B 2
#3 C 1
#4 D 1
*D has one visit, so it must be counted*
本文收集自互联网，转载请注明来源。
如有侵权，请联系 [email protected] 删除。
我来说两句