Track 14 · Lesson 9 of 12
Combining data
Join tables on a key with merge, choose the right join type, stack tables with concat, and check that a merge did what you expected.
You will be able to
- Merge two DataFrames on a key column with pd.merge / DataFrame.merge
- Choose between inner, left, right and outer joins
- Stack DataFrames with the same columns using pd.concat
- Validate a merge by checking row counts, unmatched keys and duplicate keys
Included with a Formula Quest membership
It has 4 graded exercises with feedback, hints and solutions. Python Quest is included in Formula Quest memberships that cover Python; membership and billing are managed on Formula Quest.
View Formula Quest memberships
Tracks 1 and 2, the first lesson of every track, the playground and the dataset library are free.