pandas · Lesson 6.1 · Pro
merge
Join two tables on a shared key, keeping only matches or every row from one side.
In this lesson
- Inner merge: only matches
- Left merge: keep everything on the left
- Different key names
- Merge, then summarise
Go Pro to read this lesson
Pro unlocks every lesson and practice problem in SQL, Python, pandas and NumPy, with answers and step-by-step explanations.