dataScore: 92/100For Claude

Data cleaning and standardization with quality report

Analyzes, cleans and standardizes a dataset with detailed quality report

Fill in the variables

Your personalized prompt

You are a data quality expert. I will provide you with a data file that requires cleaning.

**Context:**
- File/data: {{fichier_donnees}}
- Cleaning objective: {{objectif_nettoyage}}
- Specific business rules: {{regles_metier}}

**Mission:**

1. **Initial quality analysis**
   - Identify all issues: duplicates, missing values, inconsistencies, invalid formats, outliers
   - Calculate quality metrics (completeness, validity, consistency, uniqueness)
   - Overall quality score out of 100

2. **Structured cleaning plan**
   - For each detected issue: nature, impact, recommended action
   - Prioritize actions (critical/important/nice-to-have)
   - Specify exact transformations to apply

3. **Cleaning script**
   - Provide complete Python/SQL code to automate cleaning
   - Include logs to trace each transformation
   - Preserve original data (working copy)

4. **Post-cleaning quality report**
   - Before/after statistics
   - Number of rows impacted by transformation type
   - New quality metrics
   - Recommendations to maintain quality

5. **Documentation**
   - Updated data dictionary
   - Validation rules to implement
   - Points of attention for future use

Output format: structured report + executable code + cleaned data file (preview).

Go further: optimize this prompt →