8. Combining Data

8.1 concat — Stack Rows

By Ravindra Bagale · Last updated: 30 September 2026

import pandas as pd

sep = pd.DataFrame({"order_id": ["BLK-A"], "city": ["Pune"], "amount": [100]})
oct_ = pd.DataFrame({"order_id": ["BLK-B"], "city": ["Nashik"], "amount": [200]})
all_orders = pd.concat([sep, oct_], ignore_index=True)
all_orders

Use concat when columns match (same grain). For side-by-side joins, use merge.