WikiGalaxy
Multi-level Grouping in Pandas
Understanding Multi-level Grouping:
Multi-level grouping in Pandas allows you to perform grouping operations on multiple levels or columns. This is particularly useful when you have hierarchical data and want to analyze it at different levels of granularity.
Use Cases:
Common use cases include sales data analysis by region and product, financial data analysis by year and quarter, and more.
Advantages:
It provides a flexible way to aggregate data and derive insights from complex datasets, making it easier to handle and analyze large volumes of data.
Example 1: Sales Data Grouping
Scenario:
Suppose you have a dataset of sales transactions with columns for Region, Product, and Sales. You want to find the total sales for each product in each region.
import pandas as pd
# Sample DataFrame
data = {'Region': ['North', 'South', 'North', 'South'],
'Product': ['A', 'A', 'B', 'B'],
'Sales': [100, 150, 200, 250]}
df = pd.DataFrame(data)
# Multi-level Grouping
grouped = df.groupby(['Region', 'Product']).sum()
print(grouped)
Explanation:
The code groups the sales data by Region and Product, summing up the sales for each combination. The result shows total sales for each product in each region.
Example 2: Financial Data Grouping
Scenario:
Consider a dataset with columns for Year, Quarter, and Revenue. You want to calculate the average revenue for each quarter across different years.
import pandas as pd
# Sample DataFrame
data = {'Year': [2020, 2020, 2021, 2021],
'Quarter': ['Q1', 'Q2', 'Q1', 'Q2'],
'Revenue': [300, 400, 500, 600]}
df = pd.DataFrame(data)
# Multi-level Grouping
grouped = df.groupby(['Year', 'Quarter']).mean()
print(grouped)
Explanation:
This example demonstrates grouping by Year and Quarter to calculate the average revenue for each quarter. It helps in understanding quarterly performance trends over the years.
Example 3: Employee Data Grouping
Scenario:
You have an employee dataset with columns for Department, Role, and Salary. You want to find the maximum salary for each role within each department.
import pandas as pd
# Sample DataFrame
data = {'Department': ['HR', 'HR', 'IT', 'IT'],
'Role': ['Manager', 'Staff', 'Manager', 'Staff'],
'Salary': [70000, 40000, 90000, 50000]}
df = pd.DataFrame(data)
# Multi-level Grouping
grouped = df.groupby(['Department', 'Role']).max()
print(grouped)
Explanation:
This example groups employees by Department and Role to determine the highest salary for each role within each department. It's useful for identifying salary benchmarks in different roles.
Example 4: Product Review Grouping
Scenario:
Imagine a dataset with columns for Product, Rating, and Review Count. You want to find the average rating for each product category.
import pandas as pd
# Sample DataFrame
data = {'Product': ['Laptop', 'Laptop', 'Phone', 'Phone'],
'Rating': [4.5, 4.0, 3.5, 4.0],
'Review Count': [100, 150, 200, 250]}
df = pd.DataFrame(data)
# Multi-level Grouping
grouped = df.groupby('Product').mean()
print(grouped)
Explanation:
This example groups the data by Product to calculate the average rating and review count. It helps in understanding customer satisfaction across different product categories.
Example 5: Weather Data Grouping
Scenario:
Consider a dataset with columns for City, Month, and Temperature. You want to find the average temperature for each city in each month.
import pandas as pd
# Sample DataFrame
data = {'City': ['NYC', 'NYC', 'LA', 'LA'],
'Month': ['Jan', 'Feb', 'Jan', 'Feb'],
'Temperature': [30, 32, 60, 62]}
df = pd.DataFrame(data)
# Multi-level Grouping
grouped = df.groupby(['City', 'Month']).mean()
print(grouped)
Explanation:
This example groups the data by City and Month to calculate the average temperature. It helps in analyzing weather patterns across different cities and months.
