How to Create Different Aggregations Using GroupBy, Agg & Dictionaries

Python

Data Preprocessing

Here we want to create a new dataframe that sums the sales and counts the order numbers for each category in an existing dataframe.

We create a dictionary containing the columns we want to aggregate as keys and the aggregate we want to perform as the value. This can then be passed into the groupby agg function to create the new aggregated dataframe.

 1|  #Dictionary to declare aggregations to perform
 2|  aggregations = {'Sales':'sum', 'OrderNo':'count'}
 3|  
 4|  df_2 = df.groupby(['category'],as_index=False).agg(aggregations)

DETRO

2 Upvotes

Tags: Groupby | Agg

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

4

Creating a Running Total Column in Pandas

Python

Data Preprocessing

3

Pivoting Pandas Dataframes

Python

Data Preprocessing

3

Renaming Columns in a Pandas Dataframe Using Dictionaries & Lists

Python

Data Preprocessing

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

2

Using Pandas GroupBy Transform Function

Python

Data Preprocessing

Transform | Groupby

2

Extract Date & Time Features From a Pandas Date Column

Python

Data Preprocessing

2

Transpose Dataframe Columns to Rows

Python

Data Preprocessing

2