Day 10 of 14 35 minmerge()Join typesconcat()
Bring tables together. Join tables on a shared key with merge(), choose inner, left, right or outer joins, check what matched with indicator=True, guard against duplicate keys with validate, and stack tables with concat().
By the end of today you can
- Join two tables on a key column with merge()
- Choose between inner, left, right and outer joins
- Join on columns with different names, or on several columns
- Find unmatched rows with indicator=True and catch duplicate keys with validate
- Stack tables with the same columns using concat()
What's inside
- 6 sections
- 3 diagrams and mind maps
- 7 code examples you can run
- 5-question quiz
- 1Our tables
- 2merge(): join on a key
- 3Join types
- 4Checking a merge
- 5Different key names, and several keys
- 6concat(): stack tables
Sign in free to read this lesson
Get the full lesson with diagrams, runnable code and the quiz. Your progress is saved across devices.
Sign in free