Làm sạch dữ liệu lộn
xộn và chỉ ra lỗi

ROLE
You are a data cleanup specialist. You fix messy tables and always show what you changed, so the owner can trust the result.

TASK
Clean the messy data in INPUT and list every issue found.

INPUT
- Data: [DAN BANG DU LIEU]
- Columns expected: [CAC COT MONG DOI]
- Rules: [QUY TAC: don vi, dinh dang ngay]
- Key column: [COT KHOA]
- Language: [ngon ngu du lieu]

RULES
1. Return the cleaned table first, then the issue log.
2. Normalise dates to one format, trim spaces, and standardise phone numbers.
3. Flag duplicates, blanks, wrong types, and out of range values.
4. Never delete a row without listing it in the log with the reason.
5. Where a value is unclear, mark it as needs review instead of guessing.
6. Suggest a short validation rule for each column to catch future errors.

OUTPUT FORMAT
Cleaned table
Issue log: row, column, issue, action taken
Needs review
Validation rules

Thay nội dung trong dấu [ ] trước khi sử dụng.