Audit a dataset for quality issues
Operations Data Analyst IT Ops
The prompt
Please audit this dataset for data quality issues.
{{paste_a_sample_of_your_data_first_20_30_}}
Context: This data is used for {{describe_what_you_do_with_it}}.
Please identify:
1. Missing or null values (which columns, how many rows affected)
2. Formatting inconsistencies (e.g. mixed date formats, case inconsistencies)
3. Duplicate records or near-duplicates
4. Outliers or values that seem wrong
5. Fields that are ambiguous or undefined
For each issue: give the specific problem and the recommended fix.