返回提示词目录第 1476 页

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清洗、数据质量、重复值处理

前往 AI 图片创作