import pandas as pd

df = pd.read_excel(
    "sales.xlsx",
    sheet_name="Orders",
    engine="openpyxl",
    usecols=["Order ID", "Customer", "Region", "Total", "Order Date"],
    dtype={
        "Order ID": "string",
        "Customer": "string",
        "Region": "string",
    },
    parse_dates=["Order Date"],
    na_values=["pending"],
)

df = df.rename(
    columns={
        "Order ID": "order_id",
        "Customer": "customer",
        "Region": "region",
        "Total": "total_usd",
        "Order Date": "order_date",
    }
)

print(df.to_string(index=False))
print()
print(df.dtypes)
print()
print(f"Rows: {len(df)}")
print(f"Columns: {', '.join(df.columns)}")