# PANDAS
(df_pd
    .groupby([df_pd["date"].dt.year, df_pd["location"]])
    .agg(
        total_sales=("sales", "sum"),
        avg_sales=("sales", "mean")
    )
    .reset_index()
    .sort_values(by=["date", "total_sales"], ascending=[True, False])
)

# POLARS
(df_pl
    .group_by([pl.col("date").dt.year(), pl.col("location")])
    .agg(
        pl.sum("sales").alias("total_sales"),
        pl.mean("sales").alias("avg_sales")
    )
    .sort(by=["date", "total_sales"], descending=[False, True])     
)