Calculate the percentage of zeros that I have in a

Question

I have a column of catch rate data in a DF (df$catch.rate) that contains a combination of decimal values and zeros.

I would like to calculate the percentage of zero rows in the whole column to give me an indication of their contribution to the data.

Answer 1

sum(df$catch.rate %in% 0 ) / nrow(df)

I suggest using %in% if you have NA values..... e.g.

x <- c(0,NA,1) 
sum(x == 0 ) / length(x)
#[1] NA

Answer 2

nrow(df[df$catch.rate == 0,])/nrow(df)

Answer 3

sum(df$catch.rate==0)/length(df$catch.rate)

There's probably a more R-ish way, but this is the quickest I could come up with.

Answer 4

mean(!df$catch.rate)

will do the trick. You can add the argument na.rm = TRUE if there are NAs.