GroupBy aggregations and pivot tables for business reporting

                  import pandas as pd

df = pd.read_parquet('events.parquet')
df['event_date'] = pd.to_datetime(df['event_date'])
df['month'] = df['event_date'].dt.to_period('M').astype(str)

channel_summary = (
    df.groupby(['month', 'acquisition_channel'], as_index=False)
    .agg(
        sessions=('session_id', 'nunique'),
        users=('user_id', 'nunique'),
        revenue=('revenue', 'sum'),
        avg_order_value=('revenue', 'mean'),
    )
)

revenue_matrix = pd.pivot_table(
    channel_summary,
    index='month',
    columns='acquisition_channel',
    values='revenue',
    fill_value=0,
    aggfunc='sum',
)

print(channel_summary.head())
print(revenue_matrix.tail())