ANALYSEUP
3 Upvotes

Creating a Running Total Column in Pandas

Python
Data Preprocessing
#Pandas

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

orders.sort_values(by=['Order_Date'], inplace=True)
orders['running_total'] = orders.groupby(['ProductID'],as_index=False) ['units'].cumsum()

By analyseup - Last Updated Jan. 12, 2022, 12:24 a.m.

Did you find this snippet useful?

Sign up to bookmark this in your snippet library

COMMENTS
RELATED SNIPPETS
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

3
Pivoting Pandas Dataframes
Python
Data Preprocessing

Pandas

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

Nlp - String - Punctuation

2
Set First Row of Dataframe as Column Headers
Python
Data Preprocessing

Headers

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

Groupby - Agg

2
Pandas Groupby Transform
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
Remove Leading and Trailing Whitespace with Pandas
Python
Data Preprocessing

String - Lstrip - Whitespace - Rstrip

2
Top Contributors
detro
103
analyseup
100
GregHe1979
48
Find Snippets by Language
Python
R
SQL
Terminal
Find Snippets by Use
Data Preprocessing
Statistics & Probability
Visualisation & EDA
Data Preparation for Models
Supervised Learning
Computer Vision