data-cleanup

Clean and standardize messy CSV and spreadsheet data with auditable transformation logs.

Updated Jun 15, 2026
One-click install
npx skills add https://github.com/ravenslight2010/Production-run-calculator --skill data-cleanup-ravenslight2010
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: data-cleanup
Source: https://github.com/ravenslight2010/Production-run-calculator/tree/main/.agents/skills/data-cleanup
Command: npx skills add https://github.com/ravenslight2010/Production-run-calculator --skill data-cleanup-ravenslight2010

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Messy tabular data from CSVs, spreadsheet pastes, and system exports often contains inconsistent formats, duplicates, and ambiguous values that get silently mangled by ad-hoc cleanup. This Skill enforces a disciplined workflow that preserves the original data, surfaces ambiguity instead of guessing, and accounts for every row. ## Core Features & Use Cases - Source Preservation and Profiling: Records row counts, column types, missing values, and anomalies before any edits, never overwriting the original input. - Confirmed Transformation Rules: Proposes target formats, duplicate keys, and missing-value policies, requiring confirmation before any meaning-changing merge, deletion, or imputation. - Auditable Output: Delivers a cleaned dataset plus a transformation log with quarantined rows, dropped-row reasons, and an explicit row equation (input = output + dropped + quarantined). - Use Case: You receive a 5,000-row customer export with mixed date formats like 02/03/24, inconsistent casing, and possible duplicates. The Skill profiles the file, proposes normalization rules, quarantines ambiguous rows for your review, and produces a cleaned file with a full audit trail. ## Quick Start Clean and standardize the attached messy CSV export, deduplicate it, and show me a transformation log accounting for every row.

Frequently Asked Questions about data-cleanup

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I clean and standardize a messy CSV file?

Profile the source first by recording row counts, column types, missing values, and format inconsistencies. Then propose normalization rules for each column, get confirmation before applying them, and deliver the cleaned file with a transformation log covering every change.

How to deduplicate a list without losing data?

Define exact versus fuzzy duplicate keys before merging, and list every affected record with the reason for each decision. Report both input rows consumed and output rows produced so the merge arithmetic remains auditable.

What happens to rows that cannot be parsed during data cleaning?

Unparseable or unresolved rows are quarantined in a separate, reviewable output rather than being silently discarded or mangled. Ambiguous values like unclear dates or unknown units are flagged for human decision instead of being guessed.

Can data cleaning overwrite my original spreadsheet?

No, the original input is never replaced. Cleaned results are written to a new file, table, or explicitly approved version, so the source remains available for verification and reprocessing.

When should I not use a generic data cleanup workflow?

Avoid it for database mutations or repairing incorrect values already persisted to storage, which require dedicated data-heal safeguards. Imported customer or spec workbooks should also route through project-specific import audit processes first.