r - 频率变量总结

Question

我有一个数据框，现在我正在寻找变量的汇总计数

df <-data.frame(aa = c(NA,"bali",NA,"bali","bali",NA),
                    bb = c("can",NA,"can","can",NA,NA),
                    cc = c(NA,NA,NA,NA,"ban",NA),
                    dd = c(NA,NA,NA,NA,NA,NA))

汇总计数仅适用于具有任何单个值的变量。排除大于 0 的变量

var count
aa 3
bb 3
cc 1

标签： r

Answer 1

您可以获取长格式数据，删除NA值，然后count：

library(dplyr)

df %>% 
  tidyr::pivot_longer(cols = everything(), values_drop_na = TRUE) %>%
  count(name)

#  name      n
#  <chr> <int>
#1 aa        3
#2 bb        3
#3 cc        1