how to use groupby() + cumsum() + last()

Asked Mar 02 '21 at 16:21

Active Mar 02 '21 at 16:21

Viewed 18 times

How to make this groupby() cumsum() show only the last cumsum() by its groupby(), in this new column?

df_dea['profit_usd'] = df_dea.groupby('key_br_acc_posid')['notional_usd'].cumsum()

if I insert a .last() at the end of this code I get an error:

TypeError: last() missing 1 required positional argument: 'offset'

asked Mar 02 '21 at 16:21

Daniel Arges

1

you want to show only the last cumsum in the last row or the last cumsum in all rows? – Terry Mar 02 '21 at 16:25
last cumsum for each grouping, just in the last row – Daniel Arges Mar 02 '21 at 16:27
solved with one more line code with .tail(1) – Daniel Arges Mar 02 '21 at 16:45

0 Answers0