DC
Data Cleaning Pass
🔵 Stable🕐 updated 2026-07-19
🔷 SkillSpec L3
pm-cowork
Clean a messy dataset methodically — the profiling pass that finds what's actually wrong (dupes, format drift, phantom spaces, mixed types), the fix order that doesn't corrupt while correcting, and the log that makes the cleaning defensible. Use when asked clean this export, why is my pivot double-counting, these names don't match between sheets, or prep this data for analysis. Produces the profile of what's wrong, the ordered cleaning plan, the join-key repairs, and the cleaning log.
What to give it
▸The data — the sheet/export, and where it came from (system exports have signature messes: leading zeros eaten, dates re-typed, thousands separators as text)
▸The destination — a pivot, a join, a chart, an import; the destination defines "clean enough" (a join needs perfect keys; a chart needs consistent types)
▸The authority questions — when duplicates conflict (two rows, same customer, different phone), which source wins? Cleaning makes merge decisions; someone must own the rule
✅ The bar it holds itself to
Every skill in this library self-verifies — these are this skill's own quality checks, straight from its definition.
✓Profiling produced counts before any edit
✓The order ran normalize-before-dedupe
✓The duplicate key and conflict authority are stated
✓No blank was filled without a confirmed semantic
✓The log accounts for every transformation, and the original survives untouched
⚠️ What it refuses to do
Do not clean in place — the original is the rollback and the audit
Do not dedupe first — un-normalized duplicates hide from the dedupe
Do not invent values for should-have-value blanks — flag them; fabrication compounds downstream
Do not global find-replace without column scoping — the classic self-inflicted corruption
Do not deliver cleaned data without the log — numbers whose provenance can't be stated get re-cleaned by the next skeptic
Install
npx pm-claude-skills add --agent claude # or codex · cursor · gemini · hermes
# or one-line MCP (every skill, any client):
claude mcp add pm-skills -- npx -y pm-claude-skills-mcpRelated skills
🔌 Embed this skill
Drop this on your blog, docs, or site — it renders a "Run this skill" card:
<div data-pm-skill="data-cleaning-pass"></div>
<script src="https://mohitagw15856.github.io/pm-claude-skills/embed.js" async></script>💬 Discussion
Data Cleaning Pass is one of 750 open-source professional AI agent skills — all SkillSpec L3.
Try them all in the browser · ⭐ Star on GitHub · Browse the full catalog