import sys
sys.stdout.reconfigure(encoding="utf-8", errors="replace")
import pandas as pd
p = r"C:\Users\Alaa_S\Downloads\orders_export_1794572909.csv"
df = pd.read_csv(p, dtype=str, encoding="utf-8-sig").fillna("")
print("rows:", len(df), "| cols:", len(df.columns))
print(df.columns.tolist())
print("\nstatus counts:")
print(df["حالة الاوردر"].value_counts().head(20).to_string())
df["dt"] = pd.to_datetime(df["تاريخ انشاء الاوردر"], errors="coerce", dayfirst=False)
print("\nrange:", df["dt"].min(), "->", df["dt"].max())
print("null dates:", df["dt"].isna().sum())
print("\ncommission sum:", df["العمولة"].str.replace(",","").astype(float).sum())