import pandas as pd

inc = pd.read_csv("data/incoming_supply.csv")
sup = pd.read_csv("data/supply_master.csv")
m = inc.merge(sup[["sku", "supplier"]], on="sku", how="left")
abc = m[m["supplier"].fillna("").str.contains("ABC NUTRITIONAL", case=False)]
print(f"ABC incoming PO rows: {len(abc)} across {abc['sku'].nunique()} SKUs, total qty {int(abc['qty'].sum()):,}")
print()
print("By delivery week:")
print(abc.groupby(["year", "week"]).agg(skus=("sku", "nunique"), qty=("qty", "sum")).sort_index())
print()
print("Range of weeks:", abc["week"].min(), "to", abc["week"].max(), "year:", abc["year"].unique())