DataDesk
All topics
Pandas: groupby & aggregation — practice · DataDesk
DataDesk
How it works
Scenarios
Practice
For trainers
Pricing
Log in
Start free
Python
Pandas: groupby & aggregation
Summaries per group.
0
/ 20 solved
All levels
Basic (6)
Intermediate (7)
Advanced (7)
All
To do
Solved
1
Count rows per group
Basic
2
Sum per group
Basic
3
Average per group
Basic
4
value_counts
Basic
5
Max per group
Basic
6
Group by two columns
Basic
7
Several aggregations
Intermediate
8
Distinct count per group
Intermediate
9
Filter groups
Intermediate
10
Group total on every row
Intermediate
11
Monthly revenue
Intermediate
12
Sort groups by total
Intermediate
13
Percentage within group
Intermediate
14
Top earner per department
Interview
Advanced
15
Rank inside groups
Advanced
16
Cumulative per customer
Advanced
17
First and last order per customer
Advanced
18
Custom aggregation
Advanced
19
Group by month and city
Advanced
20
Customers above city average
Interview
Advanced