Calculate cumulative product and cumulative sum of DataFrame Columns in Pandas
Calculation of a cumulative product and sum:
import pandas as pd df = pd.DataFrame([[10, 20, 30, 40], [7, 14, 21, 28], [55, 15, 8, 12], [15, 14, 1, 8], [7, 1, 1, 8], [5, 4, 9, 2]], columns=['Apple', 'Orange', 'Banana', 'Pear'], index=['Basket1', 'Basket2', 'Basket3', 'Basket4', 'Basket5', 'Basket6']) print("\n----------- Cumulative Product -----------\n") print(df[['Apple', 'Orange', 'Banana', 'Pear']].cumprod()) print("\n----------- Cumulative Sum -----------\n") print(df[['Apple', 'Orange', 'Banana', 'Pear']].cumsum())
C:\pandas>python example.py ----------- Cumulative Product ----------- Apple Orange Banana Pear Basket1 10 20 30 40 Basket2 70 280 630 1120 Basket3 3850 4200 5040 13440 Basket4 57750 58800 5040 107520 Basket5 404250 58800 5040 860160 Basket6 2021250 235200 45360 1720320 ----------- Cumulative Sum ----------- Apple Orange Banana Pear Basket1 10 20 30 40 Basket2 17 34 51 68 Basket3 72 49 59 80 Basket4 87 63 60 88 Basket5 94 64 61 96 Basket6 99 68 70 98 C:\pandas>
2018-11-06T21:33:15+05:30
2018-11-06T21:33:15+05:30
Amit Arora
Amit Arora
Python Programming Tutorial
Python
Practical Solution