merge vs join vs concat in pandas
`merge` combines rows by key columns, `join` is index-oriented sugar, and `concat` stacks objects along an axis.
- merge is SQL-like
- join defaults to index alignment
- concat appends rows or columns
merge vs join vs concat in pandas