# Cumulative sum within group, reset when encounters a 0

8 visualizzazioni (ultimi 30 giorni)
Namrata Goswami il 17 Dic 2020
Risposto: Eric Sofen il 6 Gen 2021
I have a table and I want to get the cumulative sum within a group(by ID), but the cumulative count should reset if the counter is 0 at any point within a group and again start the cumulative count from 1.
Input
ID Counter
A 1
A 0
A 1
A 1
B 1
B 0
B 1
Expected output:
ID Counter Cumulative
A 1 1
A 0 0
A 1 1
A 1 2
B 1 1
B 0 0
B 1 1
##### 0 CommentiMostra -2 commenti meno recentiNascondi -2 commenti meno recenti

Accedi per commentare.

### Risposte (1)

Eric Sofen il 6 Gen 2021
It took me a while to come up with a way to do this without looping, then it clicked! You need to create groups based on where the 0s are. To do that, flip the logic of the counter and cumsum that:
t.ResetGroup = cumsum(~t.Counter);
Then, you can use varfun to group by both ID and ResetGroup and do the cumsum.
t = varfun(@cumsum, t, "GroupingVariable",["ID","ResetGroup"])
##### 0 CommentiMostra -2 commenti meno recentiNascondi -2 commenti meno recenti

Accedi per commentare.

### Categorie

Scopri di più su Logical in Help Center e File Exchange

### Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by