Pivoting Pandas Dataframes

Python

Creates a new DataFrame that pivots the orders Dataframe so the rows are product IDs, the columns are order dates and the cell values are units sold. Any NAs are filled with 0s.

 1|  units_by_day = orders.groupby(['Order_Date','ProductID'],as_index=False)['units'].sum()
 2|  units_by_day_pivot = units_by_day.pivot(index='ProductID', columns='Order_Date', values='units').reset_index()
 3|  units_by_day_pivot.fillna(0, inplace=True)
analyseup
Pandas
Did you find this snippet useful?

Sign up for free to to add this to your code library

Remove Stop Words from Text in DataFrame Column
Python

Pandas | Nltk | Nlp

155
LightGBM Custom Loss Function
Python

LightGBM | Loss function

136
Tuning XGBoost Hyperparameters with Grid Search
Python

XGBoost | Tuning

132
How to Convert DataFrame Values Into Percentages
Python

Lambda | Percentages | Pipe

123
How to Scale Data Using Standard Scaler But Keep Column Names
Python

Scaler | Standard

97
LightGBM Hyperparameter Tuning with GridSearch
Python

Python | LightGBM | Hyperparameter tuning | Gridsearch

95
Calculating Root Mean Squared Error (RMSE) with Sklearn and Python
Python

Rmse

92
How to Train a Catboost Classifier with GridSearch Hyperparameter Tuning
Python

Catboost | Hyperparameter tuning

72
Dynamically Create Columns in Pandas Dataframe
Python

Pandas | Columns

72
Overwriting a Python Logging File Instead of Appending
Python

Logging

70