Project 2 — Sales Analysis

sales = pd.DataFrame({
    'date':   pd.to_datetime(['2024-01-05','2024-01-20','2024-02-10','2024-02-25','2024-03-03']),
    'region': ['East','West','East','West','East'],
    'product':['A','B','A','A','B'],
    'amount': [1200, 800, 1500, 900, 1100]
})

# Total & average by region
sales.groupby('region')['amount'].agg(['sum','mean','count'])

# Monthly revenue trend
sales.set_index('date')['amount'].resample('M').sum()

# Best-selling product
sales.groupby('product')['amount'].sum().nlargest(1)

# Region × product pivot
sales.pivot_table(index='region', columns='product',
                  values='amount', aggfunc='sum', fill_value=0, margins=True)

Insight pattern: groupby for segment KPIs, resample for trend, pivot_table for a two-dimensional summary with totals.