-1

I have a df I want to add a running total column to

date F1 F2
2020-12-1 10 5
2020-12-3 9 6
2020-12-4 7 16

Expected output:

date F1 F2 F1 Running Total F2 Running Total
2020-12-1 10 5 10 5
2020-12-3 9 6 19 11
2020-12-4 7 16 26 37
Ailurophile
  • 2,552
  • 7
  • 21
  • 46

1 Answers1

0

Use cumsum

  df['F1 Running Total'] = df['F1'].cumsum()
  df['F2 Running Total'] = df['F2'].cumsum()
  df
tj judge
  • 626
  • 3
  • 17