Text & chat prompt
Plan how to clean a messy dataset
Plan how to clean a messy dataset: a free, copy-paste prompt for ChatGPT, Gemini and Claude. Paste the prompt and replace each [BRACKETED] field with your own details.
The prompt
Act as a data analyst. Help me clean this dataset. Dataset description: [WHAT IT CONTAINS] Columns and problems I see: [e.g. duplicate rows, missing values, mixed date formats] Tool: [PYTHON PANDAS / EXCEL / SQL] Give a step-by-step cleaning plan in the order I should do it, with code for each step, checks to confirm it worked and what to document for others.
Pro tip: Keep the raw file untouched and clean a copy.
How to use this prompt
- Open ChatGPT and start a new chat.
- Paste the prompt.
- Replace each [BRACKETED] field with your real details and paste in your own text where asked.
- Reply with follow-ups such as "make it shorter" or "make it sound more like me".
Prompt at a glance
- Category
- Text & chat
- Works with
- ChatGPT · Gemini · Claude
- Length
- 63 words
- Fields to fill in
- WHAT IT CONTAINS, PYTHON PANDAS / EXCEL / SQL
- Last updated
Frequently asked questions
Which AI tools work with this prompt?
It is written for ChatGPT, Gemini and Claude. Paste it into your preferred tool and adjust the wording if the result is off.
What do I need to fill in?
Replace these fields before you send it: WHAT IT CONTAINS, PYTHON PANDAS / EXCEL / SQL. Each field shows an example in the prompt.
Should I paste private information into the prompt?
Only what the task needs. Remove names, contact details and other sensitive data before pasting a resume or document into any AI tool.
More chat & writing prompts
Text & chat · TrendingRewrite resume points (ATS-friendly)ChatGPT · Gemini · Claude
Text & chat · TrendingMock interview practice (one question at a time)ChatGPT · Gemini · Claude
Text & chat · TrendingResearch a company before your interviewChatGPT · Gemini · Claude
Text & chat · TrendingViral Reel / Shorts script with a hookChatGPT · Gemini · Claude