Plan for cleaning messy data
A ready-to-use “Data & Analysis” AI prompt template, designed and tested with Claude. Replace the (bracketed) parts below with your own needs.
Prompt template
You are a data-cleaning expert. Below is a sample of my raw data: (paste 10 rows with problems). Please: 1) list the data-quality issues you find (missing, duplicate, inconsistent format, outliers). 2) for each issue, give a concrete handling method and criterion. 3) provide cleaning steps executable in Excel or Python (pandas) so the data is ready for analysis.
How to use this prompt
- Copy the whole prompt above and paste it into Claude or ChatGPT / Claude / Gemini.
- Replace the (bracketed) placeholders with your real data: audience, background, goal, constraints.
- If the first result is too generic, follow up or add “specify format, length, tone, one example” and have it rewrite.
Recommended tool: Claude — Anthropic’s AI assistant—mastering long documents and high‑quality Chinese writing