9. Data Cleaning A–Z in pandas

9.2 Rename, Strip, Standardise

By Ravindra Bagale · Last updated: 30 September 2026

df = raw.copy()
df.columns = (
    df.columns.str.strip().str.lower().str.replace(" ", "_")
)
df["city"] = df["city"].str.strip().str.title()
df["status"] = df["status"].str.strip().str.title()