数据分析进阶

数据清洗流水线 Skill

自动处理缺失值、异常值、格式不统一、重复数据。

📋 SKILL.md 完整代码

---
name: data-clean-skill
description: >-
  自动处理缺失值、异常值、格式不统一、重复数据。
  Use when working on data clean skill tasks.
allowed-tools: Read,Write,Bash
---

# 数据清洗流水线 Skill

## Quick Start
1. Save as `~/.claude/skills/data-clean-skill/SKILL.md`
2. Restart Claude Code
3. Type `/data-clean-skill` or describe your task naturally
4. Claude auto-triggers when your task matches the description

## Instructions
- Understand the user's specific context and needs
- Apply domain best practices consistently
- Provide actionable, specific guidance with examples
- Verify all outputs before presenting to user

## Gotchas
- Test with a fresh Claude instance after changes
- Keep SKILL.md under 500 lines; use references/ for details
- Description is the trigger key — make it specific and keyword-rich

🚀 怎么用

1. 复制上面的 SKILL.md 代码
2. 保存为 ~/.claude/skills/data-clean-skill/SKILL.md
3. 重启 Claude Code
4. 输入 /data-clean-skill 或直接描述任务触发
5. AI 自动按 Skill 流程执行

清洗流程

扫描→识别问题（缺失/异常/重复/格式错）→自动修复（填充缺失值/删除异常行/去重/统一格式）→验证→输出报告。支持 CSV/Excel/SQL/JSON。每一步都给出处理逻辑和影响评估。