PromptItIn logoPromptItIn
Research skill

Data Cleaning Checklist Agent Skill

Audits a CSV or spreadsheet for duplicates, gaps and bad formats, then fixes it.

SKILL.md

--- name: data-cleaning description: Use when the user shares a CSV, spreadsheet or table and wants it cleaned, checked for errors, or prepared for analysis. --- # Data Cleaning Checklist ## Steps 1. Profile the data: row count, columns, type of each column, % empty per column. 2. Check for: - Exact and near duplicates (same email or ID with different casing or spaces). - Missing values: which columns, how many rows. - Inconsistent formats: dates, phone numbers, currencies, country names, true/false. - Outliers: values far outside the normal range; flag, do not delete. - Leading/trailing spaces and hidden characters. 3. Propose a fix for each issue and state how many rows it touches. 4. Apply only the safe fixes (trim, standardise formats, drop exact duplicates). Ask before deleting rows or filling missing values. ## Output 1. An issues table:

Sign up to see the whole prompt

Make a free account to read the last part and open this prompt in the generator.

Sign up free

Already have an account? Sign in

How to install this skill

  1. Copy or download the file. It is a complete SKILL.md: frontmatter plus instructions.
  2. Save it in your skills folder. Claude Code: ~/.claude/skills/<skill-name>/SKILL.md (or .claude/skills/ inside a project).
  3. Ask as usual. When a request matches the skill's description, the agent loads it and follows the steps.

More skills

Research Brief

Researches a question and returns a sourced brief with key findings and gaps.

View →

SEO Article Writer

Writes search-ready articles from a keyword: intent check, outline, draft, meta tags.

View →

Code Reviewer

Reviews a diff or file for bugs, security issues and readability, ranked by severity.

View →