DataDesk
All topics
Pandas: merge, pivot & reshape — practice · DataDesk
DataDesk
How it works
Scenarios
Practice
For trainers
Pricing
Log in
Start free
Python
Pandas: merge, pivot & reshape
Join DataFrames and change their shape.
0
/ 20 solved
All levels
Basic (5)
Intermediate (7)
Advanced (8)
All
To do
Solved
1
Inner merge
Basic
2
Left merge
Basic
3
Concatenate rows
Basic
4
Select after merge
Basic
5
Customers without orders
Interview
Basic
6
Merge with different key names
Intermediate
7
Merge indicator
Intermediate
8
Pivot table
Intermediate
9
Melt wide to long
Intermediate
10
Crosstab
Intermediate
11
Merge then group
Intermediate
12
Validate the merge
Intermediate
13
Unstack
Advanced
14
Self-merge: same-city colleagues
Advanced
15
Merge as of a date
Advanced
16
Pivot with margins
Advanced
17
Wide again with pivot
Advanced
18
Anti-join on two keys
Advanced
19
Customer summary report
Interview
Advanced
20
Month over month table
Advanced