- Home
- Skills
- Workflow Automation
- csv-data-cleaner
Csv Data Cleaner
Audit and clean messy CSVs with a full change report
$6
Works with the AI Agents you already use
About this skill
Raw CSVs are almost never analysis-ready: inconsistent nulls (N/A, none, -), stray whitespace, duplicated rows, mixed formats. This skill profiles any CSV with the included Python script (standard library only — runs anywhere Python 3 runs), then applies explicit cleaning rules and produces a markdown audit report that logs every row it touched. Nothing is ever dropped silently.
Give you a repeatable, auditable two-pass workflow for dirty CSVs: profile first, choose cleaning rules deliberately, apply, then verify with a second audit run. The script detects the delimiter, profiles every column (null counts with the distinct null tokens found, inferred types, duplicate rows, min/max for numerics), and in clean mode emits a cleaned CSV plus a row-by-row change log.
-
A CSV import, scrape, or export has messy values before analysis or a database load.
-
You need to deduplicate rows, normalize null tokens, or trim whitespace safely.
-
A colleague asks "what did you change in this file?" and you want a written answer.
-
The file isn't CSV-like at all (Excel, JSON, XML) — use a parser for that format.
-
Cleaning requires domain judgment per row (e.g. which of two conflicting records is true) — the script only handles mechanical rules; judgment calls stay human.
-
Sensitive data you aren't authorized to read — the profiler reads the whole file.
-
You need date-format normalization or currency conversion — out of scope by design (see Limitations).
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 1 month ago