Data Cleaning & Transformation Plan

Create a data cleaning plan for {{dataset_name}}:

Data profile:
- Size: {{record_count}} rows, {{column_count}} columns
- Types: {{data_types}}
- Quality issues: {{known_issues}}
- Purpose: {{intended_use}}

Address:
1. Duplicates: {{duplication_problem}} (how to identify? keep which?)
2. Missing values: {{missing_problem}} (patterns? imputation vs deletion?)
3. Outliers: {{outlier_problem}} (valid or errors?)
4. Format/type mismatches: {{format_issue}}
5. Validation rules (business logic checks)
6. Lineage & audit trail (who touched what, when?)

Provide SQL or pseudocode for each step and validation queries.