Calculate cumsum() while ignoring NA values

by

You can do this in one line with:

cumsum(ifelse(is.na(x), 0, x)) + x*0
#  a  b  c  d  e  f  g  h 
#  1  3  3 NA  7 NA NA 13

Or, similarly:

library(dplyr)
cumsum(coalesce(x, 0)) + x*0
#  a  b  c  d  e  f  g  h 
#  1  3  3 NA  7 NA NA 13

More Related Contents:

  1. How can I find compound words, removing spaces between them and replace them in my corpus?
  2. Faster ways to calculate frequencies and cast from long to wide
  3. How can I remove all duplicates so that NONE are left in a data frame?
  4. strptime, as.POSIXct and as.Date return unexpected NA
  5. How to delete a row by reference in data.table?
  6. How to replace NA with mean by group / subset?
  7. Measuring function execution time in R
  8. R – Concatenate two dataframes?
  9. Error in plot.new() : figure margins too large in R
  10. Generate a repeating sequence based on vector
  11. anova test fails on lme fits created with pasted formula
  12. How can we make xkcd style graphs?
  13. lib unspecified & Error in loadNamespace
  14. First entry from string split
  15. Replace values in a vector based on another vector
  16. Sort a data.table fast by Ascending/Descending order
  17. Join R data.tables where key values are not exactly equal–combine rows with closest times
  18. Reasons that ggplot2 legend does not appear [duplicate]
  19. How to convert integer into categorical data in R?
  20. set ggplot plots to have same x-axis width and same space between dot plot rows
  21. lapply-ing with the “$” function
  22. How to change the first row to be the header in R?
  23. Insert a logo in upper right corner of R markdown pdf document
  24. How to replace NA (missing values) in a data frame with neighbouring values
  25. Add row in each group using dplyr and add_row()
  26. list of masked functions in R
  27. Using R convert data.frame to simple vector
  28. R programming: cache the inverse of a matrix
  29. Multiply columns in a data frame by a vector
  30. R – What algorithm does geom_density() use and how to extract points/equation of curves?

Leave a Comment