我有一个df,有很多站点和变量.我需要计算每个站点的非零值的数量.我觉得我应该可以用summarize()
和count()
或tally()
来做这件事,但我不太清楚.
雷普雷克斯:
df <-
tribble(
~variable, ~site1, ~site2, ~site3,
"var1", 0 , 1, 0,
"var2", .5, 0, 0,
"var3", .1, 2, 0,
"var4", 0, .8, 1
)
# does not work:
df %>%
summarise(across(where(is.numeric), ~ count(.x>0)))
期望输出:
# A tibble: 1 × 3
site1 site2 site3
<dbl> <dbl> <dbl>
1 2 3 1