Merging DataFrames: JOINs in Pandas

The Merge Function

orders = pd.read_csv('orders.csv')

customers = pd.read_csv('customers.csv')

# INNER JOIN

merged = pd.merge(orders, customers, on='customer_id', how='inner')

# LEFT JOIN

merged = pd.merge(orders, customers, on='customer_id', how='left')

# RIGHT JOIN

merged = pd.merge(orders, customers, on='customer_id', how='right')

# OUTER JOIN

merged = pd.merge(orders, customers, on='customer_id', how='outer')

Different Column Names

pd.merge(orders, customers, left_on='cust_id', right_on='id')

*Day 109: Handling Missing Data.*