I want to count the number of existing zeros in each column of a database of 181,000 rows and 330 variables.
i just run the following code:
db %>%
summarise_all(funs(sum(. == 0)))
the result is a full vector of NA, but I do the same procedure with a fragment of the database, and it works correctly.
It should be noted that I do the same procedure, only looking for the NA values
db %>%
summarise_all(funs(sum(is.na(.))))
and in this case it works perfectly.