import pandas as pd

df = pd.read_excel("sales.xlsx", sheet_name="Data")
df.columns = df.columns.str.strip().str.lower()
df["region"] = df["region"].str.strip().str.title()
df["qty"] = pd.to_numeric(df["qty"], errors="coerce")
df["amount"] = df["qty"] * df["price"]

managers = pd.read_excel("sales.xlsx", sheet_name="Managers")
df = df.merge(managers, on="region", how="left")

pivot = pd.pivot_table(df, index="region", columns="product", values="amount",
                       aggfunc="sum", fill_value=0, margins=True)
with pd.ExcelWriter("summary.xlsx") as xl:
    pivot.to_excel(xl, sheet_name="Pivot")
    df.to_excel(xl, sheet_name="Clean data", index=False)
print(pivot)