Creating a Running Total Column in Pandas

Python
Data Preprocessing

Creates a column in the orders DataFrame that contains a running total for each ProductID over time.

 1|  orders.sort_values(by=['Order_Date'], inplace=True)
 2|  orders['running_total'] = orders.groupby(['ProductID'],as_index=False)['units'].cumsum()
ANALYSEUP
3 Upvotes
Tags: Pandas
Did you find this snippet useful?

Sign up to bookmark this in your snippet library

Normalize Windowed Time Series
Python
Data Preprocessing

Scaler | Normalize | Scale | Min-max

4
Convert All Non-numeric Columns to Category Data Types
Python
Data Preprocessing

Pandas

4
Pivoting Pandas Dataframes
Python
Data Preprocessing

Pandas

3
Renaming Columns in a Pandas Dataframe Using Dictionaries & Lists
Python
Data Preprocessing

Rename

2
How to Remove Punctuation From Text with Python
Python
Data Preprocessing

Nlp | String | Punctuation

2
How To Set First Row of a Pandas Dataframe as Column Headers
Python
Data Preprocessing

Headers

2
How to Create Different Aggregations Using GroupBy, Agg & Dictionaries
Python
Data Preprocessing

Groupby | Agg

2
Using Pandas GroupBy Transform Function
Python
Data Preprocessing

Transform | Groupby

2
Extract Date & Time Features From a Pandas Date Column
Python
Data Preprocessing

Dt | Dates

2
Transpose Dataframe Columns to Rows
Python
Data Preprocessing

Transpose

2