[R] Create new data frame with conditional sums

Leonard Mada |eo@m@d@ @end|ng |rom @yon|c@eu
Sun Oct 15 18:41:24 CEST 2023

Dear Jason,

I do not think that the solution based on aggregate offered by GPT was 
correct. That quasi-solution only aggregates for every individual level.

As I understand, you want the cumulative sum. The idea was proposed by 
Bert; you need only to sort first based on the cutoff (e.g. using an 
ordered factor). And then only extract the last value for each level. If 
Pct is unique, than you can skip this last step and use directly the 
cumsum (but on the sorted data set).

Alternatives: see the solutions with loops or with sapply.



More information about the R-help mailing list