Fill in your details optional The prompt below updates as you type. What you type stays in this browser and is never sent to us.
You are an expert in this kind of work, and you know the Education sector from the inside.
## Your task
Here is a sample of messy data from a school and online-learning provider: [PASTE SAMPLE]. List every quality problem (missing values, duplicates, formats, outliers, inconsistent labels), the rule to fix each, and Python pandas code that applies the rules.
## About my situation
- Who this is for: students, teachers and parents
- What we must respect: accessibility, age-appropriate content and student data privacy
- How we measure success: course completion and learning outcomes
## What matters in Education
- Numbers that matter: course completion rate; learning outcomes and test scores; attendance; student engagement; enrolment and retention; parent satisfaction.
- Tools commonly used: Google Classroom or Moodle; Zoom or Meet; Google Forms; WhatsApp groups for parents.
- Rules and standards that usually apply: student data privacy (FERPA and COPPA in the US, GDPR, India's DPDP Act with parental consent for children); accessibility (WCAG and Universal Design for Learning); age-appropriate content; the board or curriculum standard (CBSE, ICSE, state boards, Common Core, IB); academic integrity.
- Rules differ by country. If I have not said where I work, ask me, and do not present one country's law as if it applied everywhere.
## How to work through it
1. List every quality problem.
2. Write a rule to fix each.
3. Write pandas code that applies the rules.
4. Show the cleaned sample.
## What to deliver
- Problem and rule table
- Python pandas code
- Cleaned sample
## Rules
- Make every point specific to my situation and my industry; replace generic advice with detail that fits.
- Use plain language, short sentences, and tables where they make the answer easier to scan.
- Use only the facts I give you. Do not invent figures, laws, sources or quotes. Mark anything you had to assume with "Assumption:".
- If something important is missing, ask me up to 3 short questions before you start.
## Before you answer
Check your draft against this list and fix anything that fails:
- Every number comes from my data or is marked as an assumption, and correlation is never presented as cause.
- It is written for a school and online-learning provider; nothing in it would read the same for any other business.
- Nothing in it breaks accessibility, age-appropriate content and student data privacy.
- Every item under "What to deliver" is included.
How to use this prompt
- Copy the prompt. Press Copy prompt and the full text goes to your clipboard.
- Fill the brackets. Use the form above, or replace [PASTE SAMPLE] with your own details.
- Paste and send. Paste it into ChatGPT, Claude and DeepSeek and send. Ask follow-up questions to refine the answer.
Why this prompt works
The “Data cleaning plan” prompt tells the assistant exactly what to hand back: problem and rule table; python pandas code; and cleaned sample. It makes the assistant work through 4 steps in order, starting with "list every quality problem", instead of jumping straight to an answer. Before replying, the assistant checks its draft against 4 tests and fixes anything that fails.
This version is written for a school and online-learning provider, so the assistant keeps accessibility, age-appropriate content and student data privacy in mind and judges the result by course completion and learning outcomes. If an important detail is missing, it asks you up to 3 short questions before it starts.
How to get the best answer
- Fill every bracket with real detail: [PASTE SAMPLE] should hold real names, numbers and dates, not placeholders.
- Paste real material: where the prompt asks for notes, data or text, paste the actual content rather than a summary.
- Refine in the same chat: ask "make it shorter", "turn it into a table" or "add more detail on step 2".
- Check the result: review it against what you know about course completion and learning outcomes before you share it.
Other industries
Same prompt for other industries
The same data cleaning plan prompt, rewritten for each industry.
FAQ
Frequently asked questions
Which AI assistant works best with the “Data cleaning plan” prompt?
The “Data cleaning plan” prompt works in any chat assistant and suits ChatGPT, Claude and DeepSeek best. Paste it in, send it, and ask follow-up questions in the same chat to refine the answer.
What do I fill in before sending the “Data cleaning plan” prompt?
Replace the highlighted bracket – [PASTE SAMPLE] – with your own details. The more specific you are, the better the answer.
Is the “Data cleaning plan” prompt only for Education?
No. This version is written for a school and online-learning provider, and the same prompt is also written for 15 other industries, listed on this page.
Is the “Data cleaning plan” prompt free to use?
Yes. First AI Prompt prompts are free to copy and use in personal and business work, with no sign-up, no account and no daily limit.
Can I trust the answer the “Data cleaning plan” prompt gives?
Treat it as a strong first draft: the prompt tells the assistant not to invent facts and to mark its assumptions, but check figures yourself, especially anything with legal, financial or safety consequences.
Keep exploring