9.1 Messy Sample

By Ravindra Bagale Last updated: 30 September 2026

import pandas as pd
import numpy as np

raw = pd.DataFrame({
    "Order ID": ["BLK-1", "BLK-2", "BLK-2", "AMN-3", "BLK-4", "BLK-5"],
    "City": ["Pune", "pune", "Pune", "Nashik", None, "Nagpur"],
    "Amount": ["64", "90", "90", "1,299", "200", "N/A"],
    "Status": ["Delivered", "Delivered", "Delivered", "Cancelled", "Delivered", "Returned"],
    "Mins": [9, 12, 12, 14, 999, 11],
})
raw