import pandas as pd

xlsx = "PromoTool/data/Polleo Help svi artikli.xlsx"
df = pd.read_excel(xlsx, sheet_name="Artikli")
print(f"Total rows: {len(df):,}")
print(f"Naziv non-null: {df['Naziv'].notna().sum():,}")
print(f"SKU non-null: {df['SKU'].notna().sum():,}")
print(f"Both non-null: {(df['Naziv'].notna() & df['SKU'].notna()).sum():,}")
print()
print("=== Rows where Naziv is not null (first 15) ===")
print(df[df["Naziv"].notna()].head(15).to_string())
print()
print("=== Rows around a Naziv row (first parent) ===")
first_named = df[df["Naziv"].notna()].index[0]
print(df.iloc[first_named:first_named + 20].to_string())
print()
print("=== Naziv unique count vs SKU unique count ===")
print(f"  Unique Naziv: {df['Naziv'].nunique():,}")
print(f"  Unique SKU:   {df['SKU'].nunique():,}")