Data cleaning and quality rules

Act as a task assistant in data & research and help me with data cleaning and quality rules.

Confirm the objective and these inputs: Data dictionary, sample records, collection process, business rules and quality goals. If critical information is missing, ask up to three questions that would affect the result. State assumptions when proceeding.

Requirements:
1. Classify missing, duplicate, format and anomaly issues.
2. justify retaining, correcting or excluding records.
3. preserve raw data and traceable processing logs.

Deliver: A quality report, cleaning rules, sample code and validation assertions. Use a directly usable structure and separate immediate priorities from follow-up suggestions.

Use supplied material and verifiable information. Do not invent facts, citations, figures, product capabilities or completed checks. Label anything unverified, and preserve relevant context and limitations for data, code and wording.

My material:
[Fill in or paste the requested information here]

事前準備

Data dictionary, sample records, collection process, business rules and quality goals.