Python Forum
Pandas - cumulative sum of two columns
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Pandas - cumulative sum of two columns
#2
I think you might have your desired output cumulative sums mixed up(or i don't understand), this output is not the same but i think it could be what you are after.

import pandas as pd

df = pd.DataFrame([
    ["Gothenburg", "Malmo", 2018, 1, 1],
    ["Malmo", "Gothenburg",  2018, 1, 1],
    ["Malmo", "Gothenburg", 2018, 0, 3],
    ["Gothenburg", "Malmo", 2018, 1, 1],
    ["Gothenburg", "Malmo", 2018, 0, 3],
    ["Gothenburg", "Malmo", 2018, 1, 1],
    ["Gothenburg", "Malmo", 2018, 0, 3],
    ["Malmo", "Gothenburg", 2018, 0, 3],
    ["Gothenburg", "Malmo", 2018, 1, 1],
    ["Malmo", "Gothenburg", 2018, 0, 3],
    ["Malmo", "Gothenburg", 2018, 1, 1],
    ["Malmo", "Gothenburg", 2018, 0, 3],
])

df.columns = ['H_team', 'A_team', 'Year', 'H_points', 'A_points']
df['H_cumsum'] = df['H_points'].cumsum().shift(1)
df['A_cumsum'] = df['A_points'].cumsum().shift(1)
print(df)
Output:
H_team A_team Year H_points A_points H_cumsum A_cumsum 0 Gothenburg Malmo 2018 1 1 NaN NaN 1 Malmo Gothenburg 2018 1 1 1.0 1.0 2 Malmo Gothenburg 2018 0 3 2.0 2.0 3 Gothenburg Malmo 2018 1 1 2.0 5.0 4 Gothenburg Malmo 2018 0 3 3.0 6.0 5 Gothenburg Malmo 2018 1 1 3.0 9.0 6 Gothenburg Malmo 2018 0 3 4.0 10.0 7 Malmo Gothenburg 2018 0 3 4.0 13.0 8 Gothenburg Malmo 2018 1 1 4.0 16.0 9 Malmo Gothenburg 2018 0 3 5.0 17.0 10 Malmo Gothenburg 2018 1 1 5.0 20.0 11 Malmo Gothenburg 2018 0 3 6.0 21.0
Reply


Messages In This Thread
Pandas - cumulative sum of two columns - by tobbs - May-19-2019, 09:29 AM
RE: Pandas - cumulative sum of two columns - by Yoriz - May-19-2019, 10:48 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  iretate over columns in df and calculate euclidean distance with one column in pandas Pit292 0 3,346 May-09-2021, 06:46 PM
Last Post: Pit292
  pandas.to_datetime: Combine data from 2 columns ju21878436312 1 2,484 Feb-20-2021, 08:25 PM
Last Post: perfringo
  Remove extra count columns created by pandas groupby spyf8 1 2,759 Feb-10-2021, 09:19 AM
Last Post: Naheed
  Pandas: summing columns conditional on the column labels ddd2332 0 2,165 Sep-10-2020, 05:58 PM
Last Post: ddd2332
  Difference of two columns in Pandas dataframe zinho 2 3,412 Jun-17-2020, 03:36 PM
Last Post: zinho
  Pandas dataframe columns collapsed in Spyder when printing UniKlixX 2 4,824 Nov-04-2019, 07:00 AM
Last Post: UniKlixX
  [pandas] How to re-arrange DataFrame columns SriMekala 8 5,017 Jun-22-2019, 12:55 AM
Last Post: scidam
  comparing two columns two different files in pandas nuncio 0 2,432 Jun-06-2018, 01:04 PM
Last Post: nuncio
  subtruction of columns in pandas garikhgh0 3 2,711 May-14-2018, 10:31 AM
Last Post: volcano63

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020