"""Inspect 'incoming supply po tjednima.xlsx'."""
from pathlib import Path
import pandas as pd

p = Path(__file__).parent / "incoming supply po tjednima.xlsx"
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("\nfirst 10 rows:")
    print(df.head(10).to_string())
    print("\nlast 5 rows:")
    print(df.tail(5).to_string())