Pivoting Pandas Dataframes

Python
Data Preprocessing

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
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
Creating a Running Total Column in Pandas
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