data-cleaning SKILL.md skillA

data-cleaning from ssameer20/data-analyst-toolkit is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add ssameer20/data-analyst-toolkit/data-cleaning@git:20261103.e47dce4

Pins git:20261103.e47dce4 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
ssameer20/data-analyst-toolkit
Path
skills/data-cleaning/SKILL.md
Versions recorded
3
Latest version
git:20261103.e47dce4, committed Nov 3, 2026
First version recorded
Nov 3, 2026
Size
6,546 bytes
Repository stars
2
License
MIT

Use when profiling, cleaning, transforming, standardizing, deduplicating, or validating data with Excel, Google Sheets, Oracle SQL, Python/Pandas, Informatica IDMC, or similar tools.

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

# Data Cleaning

Data cleaning identifies, corrects, and manages inaccurate, incomplete, duplicated, or inconsistent data so it is reliable, consistent, and suitable for analysis and reporting. Preserve data integrity and avoid unnecessary information loss.

## Core tasks
- **Missing values:** Identify null, blank, and placeholder values; choose a treatment based on data type, missingness pattern, and business context.
- **Duplicates:** Detect exact duplicate rows and duplicate keys or entities; distinguish genuine repeats from records that should be consolidated.
- **Data types:** Correct types for dates, numbers, text, categories, and identifiers without losing meaningful formatting or leading zeros.
- **Standardization:** Align date and text formats, units, categories, and naming conventions.
- **Inconsistent or invalid values:** Correct spelling or label variations only when the intended value is clear; validate permitted values and business rules.
- **Outliers:** Identify unusual values and investigate whether they are errors or valid observations before changing or excluding them.
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add ssameer20/data-analyst-toolkit/data-cleaning@sha256:2c48e0376b8d6a2e

The line at the top of this page pins the label git:20261103.e47dce4, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_tz2d2gg2nh2lalxi.svg)](https://markdownregistry.com/a/art_tz2d2gg2nh2lalxi)

2 badge image fetches in 30 days. What the badge shows.

Versions

The registry has recorded 3 versions of this file, all committed on Nov 3, 2026.

versioncommittedcommitsizeaudit
git:20261103.e47dce4 latest2026-11-03 e47dce4 6,546 BA view · diff
git:20261103.646dff12026-11-03 646dff1 2,272 BA view · diff
git:20261103.1f68b762026-11-03 1f68b76 1,780 BA view

Audit of the latest version

A  17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (6546 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

ssameer20/data-analyst-toolkit · 2 stars · license MIT · pushed 2026-11-03 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_tz2d2gg2nh2lalxi
GET https://markdownregistry.com/api/v1/resolve?ref=ssameer20/data-analyst-toolkit/data-cleaning
GET https://markdownregistry.com/api/v1/blob/2c48e0376b8d6a2efaa7a3c85f0d7265d75e42c0eb56707f081ebee302d5a524

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from ssameer20/data-analyst-toolkit

bi-expert SKILL.md skill
ssameer20/data-analyst-toolkit · skills/bi-expert/SKILL.md · Use for business intelligence and analytics reporting across Tableau, Power BI, Looker, Qlik, Excel, Google Sheets, and…
git:20261103.1d1c5e0 · audit A · 2 stars
data-analyst-workflow SKILL.md skill
ssameer20/data-analyst-toolkit · skills/data-analyst-workflow/SKILL.md · Use when coordinating an end-to-end data analysis workflow, or when a request spans data cleaning, data quality…
git:20261103.1d1c5e0 · audit A · 2 stars
data-quality SKILL.md skill
ssameer20/data-analyst-toolkit · skills/data-quality/SKILL.md · Use when auditing data quality, defining validation rules, measuring defects, prioritizing data issues, or recommending…
git:20261103.646dff1 · audit A · 2 stars
feature-engineering SKILL.md skill
ssameer20/data-analyst-toolkit · skills/feature-engineering/SKILL.md · Use when designing, creating, transforming, selecting, or validating analytical or machine-learning features from raw…
git:20261103.646dff1 · audit A · 2 stars
sql-expert SKILL.md skill
ssameer20/data-analyst-toolkit · skills/sql-expert/SKILL.md · Use when writing, explaining, optimizing, or debugging SQL, especially Oracle SQL queries, analytic functions, dates…
git:20261103.646dff1 · audit A · 2 stars

Every file in ssameer20/data-analyst-toolkit

Other files named data-cleaning

data-cleaning SKILL.md skill
genspark-ai/genoffice · skills/recommended/data-cleaning/SKILL.md · Define cleaning rules, then deduplicate and standardise dirty data into a clean table with a line-by-line cleaning log…
v1.0.0 · audit A · 11,564 stars
data-cleaning SKILL.md skill
ericrisco/rsc-harness · skills/data-cleaning/SKILL.md · Use when a raw table is too dirty to trust — nulls, sentinels, duplicate rows, category sprawl, mixed types, bad dates…
git:20260729.3ecb845 · audit A · 429 stars
data-cleaning SKILL.md skill
magnus919/agent-skills · data-cleaning/SKILL.md · Clean, profile, validate, reshape, and document messy tabular, text, JSON, and relational data through an…
git:20260914.9917fb4 · audit A · 162 stars

Browse by kind, by grade A, or by owner.