Topic · Data & Analytics
Best data cleaning skills for Claude Code, Codex and other agents.
- skills
- 257
- official
- 12
Data cleaning skills, ranked
Ranked by score. Sort bymost stars,trending,newest,recently updated
| # | Skill | Repository | Stars | Used in | Tokens | Auto-check | Licence | Updated |
|---|---|---|---|---|---|---|---|---|
| 1 | Creates, edits and analyzes spreadsheets (.xlsx, .xlsm, .csv, .tsv) with openpyxl and pandas, writing live formulas and recalculating to confirm zero formula errors. | anthropics/ | 180k | 4 repos | ~2.1k | Automated safety check: Pass | Proprietary | 2 days ago |
| 2 | Turn a natural-language financial question into a polished, self-contained HTML report. | refraction-ray/ | 2.7k | — | ~3.2k | Automated safety check: Pass | MIT | 2 mo ago |
| 3 | Stream-JSON chaining for multi-agent pipelines, data transformation, and sequential workflows | ruvnet/ | 816 | 5 repos | ~3.2k | Automated safety check: Pass | No licence | 21 days ago |
| 4 | Guides an agent through reproducing papers built on the CHARLS health and retirement survey, from variable mapping to cognition, depression and isolation scores. | xjtulyc/ | 617 | 1 repo | ~1.8k | Automated safety check: Pass | No licence | 6 mo ago |
| 5 | A skill your agent uses when the user wants to fact-check an article or verify factual claims in a document. | MigoXLab/ | 757 | — | ~741 | Automated safety check: Notes | Apache-2.0 | 9 days ago |
| 6 | Validates data against common and custom rules (required fields, formats, ranges). | platonai/ | 1.2k | — | ~896 | Automated safety check: Pass | Apache-2.0 | today |
| 7 | Use truffler to find similar or pre-existing JavaScript/TypeScript symbols before implementing new code, especially helpers, utilities, parsers, formatters, scanners, fuzzy matchers, and other… | millionco/ | 15k | — | ~1.2k | Automated safety check: Pass | Unknown | today |
| 8 | Implement a pnpm feature, bug fix, or refactor by checking existing capabilities, prioritizing code reuse and deduplication, assessing architecture impact, and validating the final change. | pnpm/ | 37k | — | ~1.1k | Automated safety check: Pass | MIT | today |
| 9 | A skill your agent uses when the user wants to fact-check an article or verify factual claims in a document. | MigoXLab/ | 757 | — | ~833 | Automated safety check: Pass | Apache-2.0 | 9 days ago |
| 10 | Handles deduplication of YouTrack issues. An agent skill from JetBrains/ideavim. | JetBrains/ | 10k | — | ~1.3k | Automated safety check: Pass | MIT | today |
| 11 | Builds, edits, cleans, recalculates and reads Excel workbooks and CSV files with openpyxl and pandas, plus LibreOffice for recalculation and PDF export. | XiaomiMiMo/ | 14k | — | ~2.9k | Automated safety check: Pass | Apache-2.0 | 4 days ago |
| 12 | 12.Pandas Pro Handles pandas DataFrame work: cleaning, merging, groupby aggregation, pivots, time-series resampling and memory tuning, with checks on dtypes, shapes and nulls. | Jeffallan/ | 12k | 1 repo | ~1.5k | Automated safety check: Pass | MIT | 4 days ago |
| 13 | Fetch financial, market, economic, fundamental, news, options, crypto, ETF, index, and macro data through the OpenBB Python interface instead of the OpenBB MCP server. | monarchjuno/ | 299 | — | ~2.9k | Automated safety check: Notes | MIT | 5 mo ago |
| 14 | Cleans raw credit data and screens variables before loan modeling, dropping unstable, noisy or redundant features and writing an Excel report of every step. | github/ | 40k | 1 repo | ~1.5k | Automated safety check: Pass | MIT | today |
| 15 | Design, add, review, or modify AIC Collector operations and their case population. | ai-dynamo/ | 454 | — | ~3k | Automated safety check: Pass | Apache-2.0 | 18 days ago |
| 16 | Investigates geocoder data quality issues by querying live S3 parquet files via MotherDuck MCP. | walkthru-earth/ | 153 | — | ~935 | Automated safety check: Pass | CC-BY-4.0 | 3 mo ago |
| 17 | A skill your agent uses when writing or refactoring React + Tailwind v4 code in this repo. | mailtrap/ | 106 | — | ~2.7k | Automated safety check: Pass | MIT | 1 mo ago |
| 18 | Plan and execute Convex schema migrations safely, including adding fields, creating tables, and data transformations. | waynesutton/ | 628 | 1 repo | ~958 | Automated safety check: Pass | MIT | 4 mo ago |
| 19 | Design, build, or debug data processing pipelines. An agent skill from agulli/atlas-agents. | agulli/ | 578 | — | ~714 | Automated safety check: Pass | MIT | 2 mo ago |
| 20 | SPD V1 Batch. An agent skill from flaqai/backlink_skills. | flaqai/ | 750 | — | ~1.7k | Automated safety check: Pass | MIT | 13 days ago |
| 21 | Workflow skill for evidence-based renewable energy market research, V4 full country wind-market status reports, source-to-final continuity, project pipeline verification, deduplication, product-fit… | liangdabiao/ | 109 | — | ~9.5k | Automated safety check: Pass | No licence | 1 mo ago |
| 22 | 22.Data Cleanup Clean and standardize messy tabular data (CSV, spreadsheet paste, system exports) into an analysis-ready dataset — consistent dates and names, typed columns, duplicates identified, missing values… | sgharlow/ | 388 | — | ~566 | Automated safety check: Pass | Unknown | 2 mo ago |
| 23 | 23.Nemo Curator GPU-accelerated data curation for LLM training. An agent skill from Orchestra-Research/AI-Research-SKILLs. | Orchestra-Research/ | 13k | 5 repos | ~2.3k | Automated safety check: Pass | MIT | 3 mo ago |
| 24 | 24.Librarian Reviews, curates, and maintains the Forge library of agents, skills, and templates. | jdforsythe/ | 151 | — | ~5.1k | Automated safety check: Pass | MIT | 3 mo ago |
| 25 | Loads, cleans, aggregates and joins tabular data with pandas under a verification rule: every number reported must be one that the code actually printed. | pipeshub-ai/ | 3.8k | — | ~1.2k | Automated safety check: Pass | Apache-2.0 | today |
| 26 | A skill your agent uses when you need to write and execute Python/R code to process, transform, and analyze data, delivering reproducible computational results with complete code-level methodology… | openJiuwen-ai/ | 148 | — | ~2.8k | Automated safety check: Pass | Apache-2.0 | 5 days ago |
| 27 | Audit an Odoo database's data quality with evidence before trusting AI answers, importing, or migrating — duplicates, missing required values, orphaned references, format anomalies — and drive… | erpipe-org/ | 419 | — | ~765 | Automated safety check: Pass | MIT | 1 mo ago |
| 28 | Finds authoritative public data sources for modeling tasks, prefers official APIs and bulk downloads, and outputs a reproducible fetch and cleaning plan with citations. | yushui2022/ | 452 | 1 repo | ~1.1k | Automated safety check: Pass | MIT | 10 days ago |
| 29 | 29.Daily Papers Daily arXiv paper recommendations with automatic deduplication | Xiangyue-Zhang/ | 1.3k | — | ~309 | Automated safety check: Pass | Apache-2.0 | 4 mo ago |
| 30 | 30.Diagnose Check memory system health and troubleshoot connectivity issues. | kbanc85/ | 296 | — | ~1.8k | Automated safety check: Pass | Unknown | 1 mo ago |
| 31 | Perform data analysis tasks including data cleaning, statistical analysis, visualization, and insight generation. | xiaoyuge886/ | 198 | 1 repo | ~794 | Automated safety check: Pass | MIT | 2 mo ago |
| 32 | Finds duplicate and junk records in a CRM CSV export with fuzzy matching, normalizes fields and writes a reviewable merge plan plus import-ready files without touching the live CRM. | OneWave-AI/ | 322 | — | ~2.5k | Automated safety check: Pass | MIT | 5 days ago |
| 33 | Methodology for market research and data collection, ensuring data quality and source traceability | chekusu/ | 688 | — | ~533 | Automated safety check: Pass | Apache-2.0 | 3 mo ago |
| 34 | Sets up data quality checks with Great Expectations, dbt tests and data contracts, with checkpoints and pass-fail reports for pipelines. | wshobson/ | 40k | 10 repos | ~1.1k | Automated safety check: Pass | MIT | 2 days ago |
| 35 | 35.Clean Data A skill your agent uses when a clinical CSV/Excel dataset needs profiling and cleaning before analysis (missing values, outliers, duplicates, type mismatches). | Aperivue/ | 329 | — | ~2k | Automated safety check: Pass | MIT | 2 days ago |
| 36 | Run comprehensive quality checks on tabular data (CSV/Excel/TSV/JSON), detecting missing values, duplicates, outliers, format issues, and type inconsistencies to produce an overall score, grade, and… | zebbern/ | 4.6k | — | ~996 | Automated safety check: Pass | MIT | today |
| 37 | Cleans raw or scraped competition data and produces exploratory charts and a figure plan as one stage of a mathematical modeling paper workflow. | yushui2022/ | 452 | 1 repo | ~1.7k | Automated safety check: Pass | MIT | 10 days ago |
| 38 | Master dbt (data build tool) for analytics engineering with model organization, testing, documentation, and incremental strategies. | wshobson/ | 40k | 8 repos | ~781 | Automated safety check: Pass | MIT | 2 days ago |
| 39 | 39.Clean Data Data cleaning, entity matching, and deduplication skill for Claude Code and Codex: triage, standardize, and validate a CSV, Excel, or JSON list of B2B companies or contacts before enrichment. | explorium-ai/ | 160 | — | ~2k | Automated safety check: Pass | MIT | 13 days ago |
| 40 | Audit a local or remote tabular file (CSV/TSV) for common data quality issues — schema, nulls, types, duplicates. | datopian/ | 2.4k | — | ~1.5k | Automated safety check: Pass | MIT | 1 mo ago |
| 41 | 执行全面的异常值检测与数据质量评估,利用 IQR 方法识别异常值并结合偏度、峰度分析数据分布特征,适用于非正态分布数据的预处理阶段。 | MichaelYang-lyx/ | 111 | 1 repo | ~1k | Automated safety check: Pass | No licence | 9 days ago |
| 42 | 42.Dedupe Rank A skill your agent uses when a broad paper candidate pool needs deterministic deduplication and a stable core set. | WILLOSCAR/ | 513 | — | ~438 | Automated safety check: Pass | No licence | 2 days ago |
| 43 | Systematic dataset profiling protocol for empirical research. | aspi6246/ | 157 | — | ~2k | Automated safety check: Pass | No licence | 1 mo ago |
| 44 | Validate data quality in market analysis documents and blog articles before publication. | tradermonty/ | 3k | 1 repo | ~1.5k | Automated safety check: Pass | MIT | yesterday |
| 45 | Excel 数据分析多步编排器。覆盖:(1) 读取多 Sheet Excel 文件并统计行数,(2) 大文件检测(≥10k 行自动 Parquet 优化),(3) 数据清洗(缺失值、文本标准化、无效字符),(4) 条件筛选与分类提取,(5) 跨 Sheet 统计聚合,(6) 导出 Excel/CSV 并提供下载链接。覆盖从数据读取到报告生成全流程,按步骤编排 capability 子… | MichaelYang-lyx/ | 111 | 1 repo | ~2.5k | Automated safety check: Pass | No licence | 9 days ago |
| 46 | Validate alignment quality with insert size distribution, proper pairing rates, GC bias, strand balance, and other post-alignment metrics. | GPTomics/ | 1.2k | 2 repos | ~3.7k | Automated safety check: Pass | MIT | 1 mo ago |
| 47 | Aggregate and rank signals from multiple edge-finding skills (edge-candidate-agent, theme-detector, sector-analyst, institutional-flow-tracker) into a prioritized conviction dashboard with weighted… | tradermonty/ | 3k | 1 repo | ~1.8k | Automated safety check: Pass | MIT | yesterday |
| 48 | Finds usable public datasets, judges whether the data can support a research idea, and checks train and test splits for leakage before results are trusted. | Light0305/ | 640 | — | ~4.9k | Automated safety check: Pass | MIT | 3 mo ago |
Questions, answered from the data.
What is the best data cleaning skill?
Excel Spreadsheet Creation and Editing (official) from anthropics/skills ranks first of the 257 data cleaning skills listed here, with the highest score: its repository has 180k GitHub stars, 4 other GitHub owners carry a copy, its SKILL.md loads about 2.1k tokens and it passes the automated safety check with no findings. Next come Question2report and Stream Chain.
Which data cleaning skills are official?
12 of the 257 data cleaning skills are official, published by the vendor's own GitHub organization: Excel Spreadsheet Creation and Editing, Issues Deduplication, Credit Risk Data Cleaning, AWS Step Functions, Datalineage Summary and 7 more.
How are these skills ranked?
By Skill Navigator score, which combines the GitHub stars of the skill's repository (shared across that repo's skills and discounted for large collections), how many other GitHub owners carry a copy of the skill, and automated SKILL.md quality checks, minus penalties for safety-check warnings and for each further skill from the same repository. Skills that fail the safety check are not listed.