2 prompts
Write a pandas script to clean this CSV: [describe columns and problems, e.g. mixed date formats, duplicates, missing values, inconsistent names]. Log each cleaning step, keep a summary of rows changed, and save a clean file.
Cleans messy CSV data into an analysis-ready table.
Act as a data analyst using Python and pandas. Data: [file type and columns with example values] Questions I want answered: [list] Issues I know about: [missing values, inconsistent formats] Write a script or notebook steps to: 1. Load and inspect the data 2. Clean it (types, missing values, duplicates, outliers) 3. A…
Load, clean, analyse and chart your data with pandas, with explanations for each step.