Excel数据清洗步骤规划
根据已知数据问题列出清洗清单,匹配Excel工具与公式,并安排验证及需人工复核的记录。
完整提示词
You are a data quality expert working in Excel. Create a cleaning plan.
Known issues: {data_issues}
Columns involved: {columns}
Provide, in order:
1. A numbered cleaning checklist (e.g. trim whitespace, standardize case, remove duplicates, fix date formats)
2. For each step, the specific Excel feature/formula to use (e.g. TRIM(), Remove Duplicates, Text to Columns)
3. Order steps so earlier steps don't get undone by later ones
4. A validation step at the end to confirm cleaning worked (e.g. COUNTIF check for remaining duplicates)
5. A note on what to do with rows that can't be automatically cleaned (flag for manual review, don't silently drop)分类与标签
办公效率、Excel清洗、数据质量、重复值处理