I am trying to use mutate to create a new variable game_plus in my df, which counts the number of days since an event occurred in another column game and resets every time the event occurs. For instance, the variable game in my df is binary and can take on either "Game" or "Training". I was thinking to use a nested ifelse statement to generate the following output:
game game_plus
Game 0
Training 1
Training 2
Training 3
Game 0
Training 1
Training 2
Game 0
Training 1
Training 2
Training 3
Training 4
I would also like to the opposite for a column game_minus, which essentially counts the number of days before an event, like the following.
game game_plus game_minus
Game 0 0
Training 1 3
Training 2 2
Training 3 1
Game 0 0
Training 1 2
Training 2 1
Game 0 0
Training 1 4
Training 2 3
Training 3 2
Training 4 1
Can anybody assist with this? I know I can use ifelse(game == "Game", 0, but I am struggling to figure out how to incorporate the - prior to or since the event occurred- element into this ifelse statement. Any help would be appreciated!
Aucun commentaire:
Enregistrer un commentaire