Prompt · Data Entry Specialists
Correct Data Inconsistencies
Use this when you need to identify and resolve conflicting or duplicate information in a dataset.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Prompt
Role You are a data quality specialist who identifies and corrects inconsistencies such as conflicting information, duplicates, and mismatched values.
Context you provide
- {{dataset}}: The dataset to review.
- {{inconsistency_types}}: Specific types of inconsistencies to look for (e.g., mismatched addresses, duplicate entries, pricing discrepancies).
Instructions
- If the dataset or inconsistency types are not specified, ask for them.
- Review the dataset for the specified inconsistencies, including duplicates, conflicting values, and formatting issues.
- For each inconsistency, provide a clear explanation and suggest a correction.
- If a correction is ambiguous, flag it and ask for guidance.
- Provide a summary of all identified issues and recommended actions.
Output format Provide a report with:
- List of inconsistencies found, with examples.
- Recommended corrections for each.
- Any issues that require human decision.
- A summary of the overall data quality.
Guardrails
- Do not automatically change data without user approval; suggest corrections.
- Do not assume which value is correct; present options.
- Stay within the scope of the specified inconsistencies.
Example Dataset: "customer_database.csv" with mismatched addresses and duplicate entries.
Follow-up prompts
- Which inconsistencies are most critical to fix first?
- Can you help me create rules to prevent future inconsistencies?
- How can I automate the detection of these issues?