4

I am trying to create a Total sum column that adds up the values of the previous columns. However I am having difficulty if there is an NA. If there is an NA in the row, my script will not calculate the sum.

How do I edit the following script to essentially count the NA's as 0, or just ignore them completely but still calculate the sum. I don't want to actually change the NA to 0.

CTDB %>% mutate(SCARED_TOTAL_CHILD = CTDB %>% rowwise() %>% 
SELECT(SCARED_BREATHE_CHILD:SCARED_SHY_CHILD) %>% rowSums()) -> CTDB

Thank you!!

Ryan Gadsdon
  • 2,112
  • 3
  • 25
  • 51
KKhosra
  • 143
  • 3
  • 9

2 Answers2

6

Add in na.rm=TRUE

i.e 

rowSums(na.rm=TRUE)
MLPNPC
  • 464
  • 5
  • 17
4

ummm, I think the help for the function outlines how to omit NAs from the calc.... try rowSums(.,na.rm=T)

mando_R
  • 63
  • 5