import pandas as pd

records = [
    {
        "order_id": 1001,
        "customer": "Ada Lovelace",
        "region": "EMEA",
        "total_usd": 149.50,
        "paid": True,
    },
    {
        "order_id": 1002,
        "customer": "Lin Chen",
        "region": "APAC",
        "total_usd": 89.00,
        "paid": False,
    },
    {
        "order_id": 1003,
        "customer": "Maya Patel",
        "region": "AMER",
        "total_usd": 212.00,
        "paid": True,
    },
]

column_order = ["order_id", "customer", "region", "total_usd", "paid"]
row_labels = ["order-1001", "order-1002", "order-1003"]

df = pd.DataFrame(records, columns=column_order, index=row_labels)

print(f"pandas {pd.__version__}")
print()

print("DATAFRAME")
print(df)
print()

print("VERIFY_SHAPE")
print(df.shape)
print()

print("VERIFY_COLUMNS")
print(df.columns.tolist())
print()

print("VERIFY_INDEX")
print(df.index.tolist())
print()

print("VERIFY_DTYPES")
print(df.dtypes)
print()

print("VERIFY_ROW")
print(df.loc["order-1002", ["customer", "total_usd"]])