# Joining Tables

Joining Tables: Joining Tables with merge, Inner, Left, Right and Outer Joins, When a Join Goes Wrong.

Updated: November 19, 2026

1. [Joining Tables with merge](https://www.ask-codey.com/lessons/pandas-merge) (Apprentice): merge lines up the rows of two tables by a key column they share, the job a spreadsheet's VLOOKUP does, with on= when the key has the same name in both, left_on and right_on when it doesn't, and suffixes to tell apart other columns the two tables share.
2. [Inner, Left, Right and Outer Joins](https://www.ask-codey.com/lessons/pandas-join-types) (Journeyman): A join has to decide what happens to rows that find no match, and merge's how= says which ones to keep (inner only the matches, left every row of the left table, right every row of the right one, outer every row of both), while indicator=True and a row count before and after show what the join did.
3. [When a Join Goes Wrong](https://www.ask-codey.com/lessons/pandas-join-pitfalls) (Journeyman): A join can run without an error and still give wrong answers, when a key that repeats in the lookup table copies rows (which validate= catches), when the key is a number in one table and text in the other, or when spaces hide in the keys, and each has a check and a fix.

Source: https://www.ask-codey.com/courses/python-data-analysis/topics/data-joining-tables
