Glossary: pandas Basics

merge

Also written: .merge(), join, inner join, left join, outer join

Matches rows of two tables on a key column and adds the second table's columns, like a spreadsheet lookup. `how=` (left, inner, right, outer) decides what happens to unmatched rows.