Prompt lesson · 22 prompts
Data Validation prompts for Data Entry Specialists
22 ready-to-use prompts from our AI for Data Entry Specialists course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Assess Data Quality
Use this when you need to evaluate the quality of a dataset and identify areas for improvement.
Role You are a data quality analyst. Your goal is to thoroughly assess the provided dataset for accuracy, completeness, consistency, and timeliness, and to provide actionable recommendations for improvement.
Context you provide
- {{dataset}}: The data you want assessed (e.g., a CSV file, spreadsheet, or text snippet).
- {{focus_areas}}: (Optional) Specific aspects to prioritize, such as missing values, formatting, or outliers.
Instructions
- If the dataset is not provided, ask the user to supply it before proceeding.
- Analyze the dataset for common data quality issues: missing values, duplicates, inconsistencies, formatting errors, and outliers.
- For each issue found, provide a clear description, the location (e.g., row/column), and a suggested fix.
- Assess the overall quality of the dataset against the dimensions of accuracy, completeness, consistency, and timeliness (if applicable).
- Prioritize the issues by severity and impact on downstream use.
- Provide a summary of the most critical improvements and a recommended action plan.
Output format
- A structured report with sections: Executive Summary, Key Issues Found, Detailed Findings (with examples), and Recommendations.
- Use bullet points and tables where helpful. Keep the tone professional and objective.
Guardrails
- Do not invent data or make assumptions about the dataset's context; flag any uncertainties.
- Stay within the scope of data quality assessment; do not perform unrelated analysis.
- If the dataset is too large, suggest sampling or provide a method for handling it.
Example {{dataset}}: "customer_records.csv" with 10,000 rows including fields: name, email, phone, signup_date.
Open this prompt Analysis · Intermediate
Automated Data Validation Script
Use this when you need to create a script that automatically checks data entry for accuracy and consistency.
Role You are an expert data quality engineer. Your goal is to design a robust, automated data validation script that ensures accuracy and consistency in data entry processes.
Context you provide
- {{dataset_description}}: Describe the dataset (e.g., customer records, sales transactions) and its source.
- {{validation_rules}}: List specific rules or standards the data must meet (e.g., required fields, data types, ranges).
- {{script_language}}: Specify the programming language or tool you prefer (e.g., Python, SQL, Excel).
Instructions
- If any of the above inputs are missing, ask for them before proceeding.
- Based on the dataset description and validation rules, design a validation script that checks for common issues like missing values, duplicates, format errors, and out-of-range entries.
- Include clear error reporting that flags problematic records and explains the issue.
- Suggest how to integrate the script into an existing data pipeline or workflow.
- Provide instructions for running the script and interpreting its output.
Output format Provide the script in a code block with comments explaining each section, followed by a brief summary of what the script does and how to use it. Keep the tone technical and concise.
Guardrails
- Do not invent validation rules; base them on the provided context.
- Flag any assumptions about the dataset or environment.
- Stay within the scope of data validation; do not suggest unrelated features.
Example Dataset: customer orders with fields order_id, customer_email, order_date, amount; rules: order_id unique, email format valid, amount > 0; language: Python.
Open this prompt Coding · Intermediate
Completeness Check for Data Fields
Use this when you need to verify that all required fields in a dataset or form are populated and identify any missing information.
Open this prompt Analysis · Beginner
Cross-Field Validation Rules
Use this when you need to ensure that data entered in one field is consistent with data in another field within a form or dataset.
Open this prompt Creating · Intermediate
Cross-Source Consistency Check
Use this when you need to verify that data is consistent across different sources or systems.
Open this prompt Analysis · Intermediate
Custom Validation Rules Design
Use this when you need to create validation rules tailored to your business's specific requirements, such as compliance or data accuracy.
Open this prompt Creating · Intermediate
Data Accuracy Checks
Use this when you need to verify the accuracy of data entries by comparing them against original sources or cross-referencing with existing records.
Open this prompt Analysis · Beginner
Data Accuracy Validation Algorithm
Use this when you need to develop an algorithm or process to automatically verify the accuracy of data being entered into a system.
Open this prompt Coding · Advanced
Data Cleansing Audit & Recommendations
Use this when you need to identify and flag duplicate, outdated, or inconsistent records in a dataset.
Open this prompt Analysis · Intermediate
Data Completeness Validation
Use this when you need to ensure all required data fields are filled in during data entry and identify any missing information.
Open this prompt Analysis · Intermediate
Data Consistency Checks
Use this when you need to verify that data is consistent across multiple systems or databases and identify discrepancies.
Open this prompt Analysis · Intermediate
Data Format Validation Rules
Use this when you need to create rules or scripts to validate data formats like dates, phone numbers, and email addresses.
Open this prompt Creating · Intermediate
Data Formatting Standardization
Use this when you need to reformat or standardize data fields like dates, currency, phone numbers, or text case for consistency.
Open this prompt Creating · Beginner
Data Integrity Checks
Use this when you need to verify the accuracy and consistency of recently entered data against existing records.
Open this prompt Analysis · Beginner
Data Integrity Verification
Use this when you need to verify the overall integrity and reliability of data, including identifying duplicates, conflicts, or irregularities.
Open this prompt Analysis · Advanced
Data Quality Assessment
Use this when you need to evaluate the quality of data entries for inconsistencies, duplicates, accuracy, and completeness.
Open this prompt Analysis · Intermediate
Data Standardization and Consistency
Use this when you need to standardize data formats, units, and naming conventions across a dataset to ensure consistency and usability.
Open this prompt Analysis · Beginner
Detect and Correct Errors
Use this when you need to identify and fix errors in a dataset to ensure high-quality data.
Open this prompt Analysis · Intermediate
Detect Duplicate Data
Use this when you need to identify and remove duplicate records from a database or dataset.
Open this prompt Coding · Intermediate
Identify and Fix Data Errors
Use this when you need to identify and correct inconsistencies, duplicates, formatting errors, or outliers in a dataset.
Open this prompt Analysis · Beginner
Identify Duplicate Entries
Use this when you need to find and remove duplicate records from a dataset, with a focus on identifying them accurately.
Open this prompt Analysis · Beginner
Implement Real-time Validation
Use this when you need to add real-time validation to a data entry form or system to catch errors as they occur.
Open this prompt Coding · Advanced