csv-profiler
Profiles a CSV file column by column, reporting inferred type, missing values, unique counts and min, max and mean for numeric columns. Use when the user hands over a CSV and asks what is in it, whether the data is clean, or what to check before analysis.
#data
Install
npx skills add https://github.com/Lethe044/agentskill-kit/tree/main/skills/csv-profiler
claude plugin marketplace add https://llmmart.ai/marketplace.json && claude plugin install lethe044-agentskill-kit@llmmart
git clone https://github.com/Lethe044/agentskill-kit.git
The skills CLI installs just this skill, for any of its supported agents. Claude Code installs the whole lethe044/agentskill-kit collection as a plugin from our marketplace. Git is the plain clone.
Skill manifest
CSV profiler
Gives an agent a reliable picture of a CSV file before it writes any analysis code.
When to use
- The user uploads or points to a CSV and asks "what is in this file?".
- Before cleaning, joining or plotting data, to find empty columns and mixed types.
- When a script fails on a column and the user suspects bad values.
How to run
python scripts/profile_csv.py data.csv
python scripts/profile_csv.py data.tsv --delimiter tab
The delimiter is detected automatically when it is not given. Use --delimiter tab for tab separated files.
Output
JSON with rows, columns and a profile list. Each column has name, type
(integer, float, boolean, date, string or empty), missing, unique, sample
and, for numeric columns, min, max and mean.
Reading the result
- A column with a large
missingcount needs a decision: drop it, fill it, or ask the user. - A
stringcolumn whoseuniquecount is close torowsis probably an identifier. - A
stringcolumn with few unique values is a good candidate for a categorical type. - Report surprises first: mixed types, empty columns, duplicated headers.
Errors
A missing file exits with code 2. A file with no rows returns rows: 0.
Files (agentskill-kit)
-
scripts
-
profile_csv.py 2.7 KB
Loading…
-
-
tests
-
cases.json 1.3 KB
Loading…
-
-
SKILL.md 1.6 KB
--- name: csv-profiler description: Profiles a CSV file column by column, reporting inferred type, missing values, unique counts and min, max and mean for numeric columns. Use when the user hands over a CSV and asks what is in it, whether the data is clean, or what to check before analysis. license: MIT metadata: version: 1.0.0 author: Lethe044 tags: [csv, data, profiling, analysis] --- # CSV profiler Gives an agent a reliable picture of a CSV file before it writes any analysis code. ## When to use - The user uploads or points to a CSV and asks "what is in this file?". - Before cleaning, joining or plotting data, to find empty columns and mixed types. - When a script fails on a column and the user suspects bad values. ## How to run ```bash python scripts/profile_csv.py data.csv python scripts/profile_csv.py data.tsv --delimiter tab ``` The delimiter is detected automatically when it is not given. Use `--delimiter tab` for tab separated files. ## Output JSON with `rows`, `columns` and a `profile` list. Each column has `name`, `type` (`integer`, `float`, `boolean`, `date`, `string` or `empty`), `missing`, `unique`, `sample` and, for numeric columns, `min`, `max` and `mean`. ## Reading the result - A column with a large `missing` count needs a decision: drop it, fill it, or ask the user. - A `string` column whose `unique` count is close to `rows` is probably an identifier. - A `string` column with few unique values is a good candidate for a categorical type. - Report surprises first: mixed types, empty columns, duplicated headers. ## Errors A missing file exits with code 2. A file with no rows returns `rows: 0`.
Comments (0)
Sign in to join the conversation.
Reviews (0)
No reviews yet.
No comments yet.