Problem using rowwise() to count the number of NA's in each row of a dataframe
2
0
I'm having trouble using rowwise() to count the number of NAs in each row. My minimal example: df <- data.frame(Q1 = c(rep(1, 1), rep(NA, 9)), Q2 = c(rep(2, 2), rep(NA, 8)), Q3 = c(rep(3, 3), rep(NA, 7)) ) df Q1 Q2 Q3 1 1 2 3 2 NA 2 3 3 NA NA 3 4 NA NA NA 5 NA NA NA 6 NA NA NA 7 NA NA NA 8 NA NA NA 9 NA NA NA 10 NA NA NA I would like to create a new column that counts the number of NAs in each row. I can do this very simply by writing df$Count_NA <- rowSums(is.na(df)) df Q1 Q2 Q3 Count_NA 1 1 2 3 0 2 NA 2 3 1 3 NA NA 3 2 4 NA NA NA 3 5 NA NA NA 3 6 NA NA NA 3 7 NA NA NA 3 8 NA NA NA 3 9 NA NA NA 3 10 NA NA NA 3 B...