Transforms and cleans data with step-by-step processing
Help me transform and clean data.
Source data format: {format} (CSV / Excel / JSON)
Data description: {description}
Data issues: {issues} (missing values / duplicates / inconsistent date formats / unstructured)
Desired result: {result}
I need:
1. **Diagnosis**: what problems exist in the data and how to fix them
2. **Python code (pandas)** for:
- Loading the data
- Removing/filling missing values (strategy)
- Removing duplicates
- Casting data types
- Normalization (dates, numbers, text)
- Creating new columns (if needed)
- Exporting to the desired format
3. **No-code alternative**: how to do the same in Excel/Google Sheets
4. **Quality check**: how to verify the data is clean
5. **Report**: how many rows before/after, what was removed and why
0 copies
Variables
Replace these variables with your own values before using:
AI Tools