ignore NA in dplyr row sum

by

You could use this:

library(dplyr)
data %>% 
  #rowwise will make sure the sum operation will occur on each row
  rowwise() %>% 
  #then a simple sum(..., na.rm=TRUE) is enough to result in what you need
  mutate(sum = sum(a,b,c, na.rm=TRUE))

Output:

Source: local data frame [4 x 4]
Groups: <by row>

      a     b     c   sum
  (dbl) (dbl) (dbl) (dbl)
1     1     4     7    12
2     2    NA     8    10
3     3     5     9    17
4     4     6    NA    10

More Related Contents:

  1. Row-wise sum for select columns while ignoring NAs [closed]
  2. Replace values greater than zero with 1 in r
  3. How does one access the piped data.frame in dplyr::funs?
  4. Extract row corresponding to minimum value of a variable by group
  5. How to select the rows with maximum values in each group with dplyr? [duplicate]
  6. Filter multiple values on a string column in dplyr
  7. Applying a function to every row of a table using dplyr?
  8. Concatenate strings by group with dplyr [duplicate]
  9. Reverse stacked bar order
  10. Can dplyr package be used for conditional mutating?
  11. What does %>% function mean in R?
  12. Dplyr join on by=(a = b), where a and b are variables containing strings?
  13. R cumulative sum by condition with reset
  14. Non-standard evaluation (NSE) in dplyr’s filter_ & pulling data from MySQL
  15. Proper idiom for adding zero count rows in tidyr/dplyr
  16. Why is enquo + !! preferable to substitute + eval
  17. Can I replace NAs when joining two data frames with dplyr?
  18. Merge rows in a dataframe where the rows are disjoint and contain NAs
  19. Reshape from long to wide and create columns with binary value
  20. dplyr broadcasting single value per group in mutate
  21. Can dplyr join on multiple columns or composite key?
  22. How to deal with nonstandard column names (white space, punctuation, starts with numbers)
  23. dplyr if_else() vs base R ifelse()
  24. Using column names as function arguments
  25. How to change the now deprecated dplyr::funs() which includes an ifelse argument?
  26. Apply a ggplot-function per group with dplyr and set title per group
  27. Mutate multiple variable to create multiple new variables
  28. Run a custom function on a data frame in R, by group
  29. Dealing with spaces and “weird” characters in column names with dplyr::rename()
  30. Filtering rows in R unexpectedly removes NAs when using subset or dplyr::filter

Leave a Comment