Cumulative sum until maximum reached, then repeat from zero in the next row

by

I think this is best done with a for loop, can’t think of a function that could do so out of the box. The following should do what you want (if I understand you correctly).

current.sum <- 0
for (c in 1:nrow(caribou.sub)) {
    current.sum <- current.sum + caribou.sub[c, "difference"]
    carribou.sub[c, "difference_sum"] <- current.sum
    if (current.sum >= 1470) {
        caribou.sub[c, "keep"] <- 1
        current.sum <- 0
    }
}

Feel free to comment if it does not exactly what you want. But as pointed out by alexwhan, your description is not completely clear.

More Related Contents:

  1. Loop through a R matrix row-wise and print elements [duplicate]
  2. How to prevent ifelse() from turning Date objects into numeric objects
  3. Does ifelse really calculate both of its vectors every time? Is it slow?
  4. Is the “*apply” family really not vectorized?
  5. Vectorized IF statement in R?
  6. Calculate cumulative sum (cumsum) by group
  7. Can dplyr package be used for conditional mutating?
  8. Create group number for contiguous runs of equal values
  9. The condition has length > 1 and only the first element will be used
  10. R Loop for Variable Names to run linear regression model
  11. How to Loop/Repeat a Linear Regression in R
  12. Merge by Range in R – Applying Loops
  13. if-else vs ifelse with lists
  14. if – else if – else statement and brackets
  15. Which is the best method to apply a script repetitively to n .csv files in R?
  16. Comparing two vectors in an if statement
  17. Conditional cumsum with reset
  18. Unexpected ‘else’ in “else” error
  19. R assigning ggplot objects to list in loop
  20. how to create a loop that includes both a code chunk and text with knitr in R
  21. dplyr if_else() vs base R ifelse()
  22. Create a loop that includes both a code chunk and text
  23. Using ifelse in R
  24. Difference between if() and ifelse() functions
  25. if else condition in ggplot to add an extra layer
  26. Create new column based on 4 values in another column
  27. Assign a value, if a number is in between two numbers
  28. Rowwise cumulative sum
  29. How do I create a new column based on multiple conditions from multiple columns?
  30. resetting cumsum if value goes to negative in r

Leave a Comment