import sys
sys.stdout.reconfigure(encoding="utf-8")
import pandas as pd
for f in ['data/VrstaRabatnePolitike06.xlsx', 'data/VrstaRabatnePolitikesummer buddy.xlsx']:
    df = pd.read_excel(f)
    print(f'=== {f} ===')
    for col in ('Cijena', 'Rabat %', 'MP Marža', 'VP Marža', 'Akcija%'):
        if col in df.columns:
            print(f'  {col}  non-null: {df[col].notna().sum()}/{len(df)}')
    print()