Data Cleaning Plan
Given a messy dataset, writes a step-by-step cleaning plan: what's wrong, what to check, what to fix, and what to leave alone.
The prompt
I have a messy dataset. Write a cleaning plan. Ask for: - The tool I'm using (Excel/Sheets, Python + pandas, R, SQL, other) - A sample: 5-10 rows and the column names, or a description of the shape - What I plan to DO with the cleaned data (analysis, chart, load into another system) Output: **What's wrong** — bullet list of the specific issues you see. Not "the data is messy," but "column X has mixed date formats" or "duplicates in rows 4, 7, 12." **Priority-ranked cleaning steps** — numbered list. Each step: - What to do - The exact tool command / formula / function to do it - What to check after to confirm it worked **What to LEAVE ALONE** — things that look like errors but might not be. Trailing whitespace in some fields, weird outliers that are real, etc. **What I can't tell without seeing more** — data quality issues you can't judge from a sample alone. Row counts by category, distribution shape, missing patterns. Rules: - Never suggest deleting rows/columns without saying what to save first. - Prefer non-destructive steps (create a cleaned copy) over destructive (overwrite). - If the data has structural problems (wrong shape entirely), address that before cell-level cleanup. ## How to use it Paste this prompt, then paste sample rows. Follow the steps in order. Save a "clean" version alongside the raw one so you can rerun. ## Why it works Cleaning-as-you-go loses. Cleaning against a written plan catches the failure modes you'd otherwise discover mid-analysis. The "leave alone" section prevents the common overshooting where cleaning removes real signal.
How to use it
I have a messy dataset. Write a cleaning plan.
Ask for:
- The tool I’m using (Excel/Sheets, Python + pandas, R, SQL, other)
- A sample: 5-10 rows and the column names, or a description of the shape
- What I plan to DO with the cleaned data (analysis, chart, load into another system)
Output:
What’s wrong — bullet list of the specific issues you see. Not “the data is messy,” but “column X has mixed date formats” or “duplicates in rows 4, 7, 12.”
Priority-ranked cleaning steps — numbered list. Each step:
- What to do
- The exact tool command / formula / function to do it
- What to check after to confirm it worked
What to LEAVE ALONE — things that look like errors but might not be. Trailing whitespace in some fields, weird outliers that are real, etc.
What I can’t tell without seeing more — data quality issues you can’t judge from a sample alone. Row counts by category, distribution shape, missing patterns.
Rules:
- Never suggest deleting rows/columns without saying what to save first.
- Prefer non-destructive steps (create a cleaned copy) over destructive (overwrite).
- If the data has structural problems (wrong shape entirely), address that before cell-level cleanup.
How to use it
Paste this prompt, then paste sample rows. Follow the steps in order. Save a “clean” version alongside the raw one so you can rerun.
Why it works
Cleaning-as-you-go loses. Cleaning against a written plan catches the failure modes you’d otherwise discover mid-analysis. The “leave alone” section prevents the common overshooting where cleaning removes real signal.
✦ More like this
Related prompts
Book Recommender (Honest)
Recommends 3-5 books based on what you actually liked before. No 'Sapiens for the 400th time.' Includes honest reasons and what NOT to expect.
Chart Type Chooser
Given the data you have and the question you're answering, picks the right chart type and explains what to avoid. No dual-axis, no pie chart traps.
Code Refactor Helper
Refactors a function or file without changing behavior. Explains what changed and why, and flags any behavior it wasn't sure about.