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,272
  • 4
  • 31
  • 56
KKhosra
  • 163
  • 1
  • 4
  • 9

2 Answers2

6

Add in na.rm=TRUE

i.e 

rowSums(na.rm=TRUE)
MLPNPC
  • 454
  • 5
  • 18
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