Decision Guide
Use merge() when:
- Joining on column values (like SQL)
- Different key column names
- Need all join types
Use join() when:
- Joining on index
- Quick left join on index
- Joining multiple DataFrames at once
Use concat() when:
- Stacking similar DataFrames
- Combining monthly/yearly data
- No key matching needed