C9PythonIntermediateAbout 110 min to complete
Merge, Join & Concatenate
Combining datasets without silently duplicating or losing rows.
Notebook
About 110 minutes to complete
Enrol to read the notebook and download it to run.
What this module covers
Combining datasets without silently duplicating or losing rows.
By the end of it
- Apply the four join types and predict each one's row count
- Diagnose key mismatches before merging
- Detect unintended row multiplication from many-to-many joins
- Use validate= and indicator= to make joins self-checking
- Merge on multiple keys, differing column names, and indexes
- Concatenate frames vertically and horizontally, with alignment
- Choose between merge, join, concat, and combine_first
- Build a validated multi-table pipeline