python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - cumsum

Calculation of the cumulative points before the event/game

I would like to cumulate the points of several football clubs for each one for a match day. I have created a sample dataset to explain the problem: t <- data.frame(Heim = c("A", "B&q...
test-img

Louisa Fritz

r

dataframe

cumsum

Votes: 0

Answers: 1

Latest Answer

Probably not the shortest solution. But I would do t <- t %>% group_by(Saison) %>% mutate(Heim_Points_Veränderung = case_when(Ergebnis == "S" ~ 3, ...
test-img

Valkyr

R: cumulative sum resetting every n rows

Reprex set.seed(4) df <- data.frame(week = rep(rep(c(1,2), each=5), times=98), day = rep(c("Monday", "Tuesday", "Wednesday", "Thursday", &qu...
test-img

SourceCoda

r

cumulative-sum

cumsum

Votes: 0

Answers: 1

Latest Answer

The first version resets every 5 rows, the second resets every Monday: df$test1 <- ave(df$hours, (seq_along(df$hours)-1)%/%5 , FUN=cumsum ) or df$test2 <- ave(df$hours, cumsum(df$day=="Mon...
test-img

George Savva

How to count the number of times a value changes, grouped by two variables in R

I have a dataframe similar to the constructed one below, but much larger. id <- rep(c("a", "b", "c", "d"), each = 3) date <- seq(as.Date("2019-01-27&...
test-img

TRS6

r

grouping

cumsum

Votes: 0

Answers: 0

Resetting a group&#39;s cumsum when a condition is met

First time poster here, so apologies if I get something wrong. I have a data table that looks like this currently: dt_achieved<-data.table(last_nm=c("raus","stroper", "degr...
test-img

MeowMix

r

group-by

conditional-statements

reset

cumsum

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs