Data cleaning plan
ProblemA messy export has duplicates, mixed formats and blanks, and cleaning it by hand is error-prone.
pandas · columns: name, phone, city, signup_date (formats: 03/10/26, 2026-10-03, '3 Oct')
signup_date: 3 formats → pd.to_datetime(df.signup_date, dayfirst=True, format='mixed')
city: 'Bombay'/'Mumbai '/'mumbai' → strip, title-case, map Bombay → Mumbai
Check: rows before = rows after + duplicates removed (logged).
Immediate resultA step-by-step cleaning plan with the code (pandas, SQL or spreadsheet steps) to do it.


