Study
Pandas · merge and join
SQL-style joins with merge (inner, left, right, outer), the indicator flag, validate, and stacking with concat.
- merge is pandas' SQL JOIN; the how argument picks inner, left, right or outer.
- indicator=True adds a column saying where each row came from, which is great for debugging joins.