"""Inspect the two new files: NabavneCijene.xlsx + SifrarnikArtikala.xlsx."""
from pathlib import Path
import pandas as pd

DATA = Path(__file__).parent
for name in ("NabavneCijene.xlsx", "SifrarnikArtikala.xlsx"):
    p = DATA / name
    print(f"\n{'='*70}\n{name}  ({p.stat().st_size/1024:,.0f} KB)\n{'='*70}")
    xl = pd.ExcelFile(p)
    print(f"sheets: {xl.sheet_names}")
    for sn in xl.sheet_names:
        df = pd.read_excel(p, sheet_name=sn)
        print(f"\n[sheet: {sn}]  shape={df.shape}")
        print("columns:", list(df.columns))
        print("dtypes:")
        print(df.dtypes)
        print("head:")
        print(df.head(6).to_string())
        # If big, also peek at random rows
        if len(df) > 50:
            print("\nrandom 3:")
            print(df.sample(min(3, len(df)), random_state=1).to_string())