Column Profile — Paste CSV Rows, Get Fill Rate per Column

    1

    Count blank, distinct, and numeric values per CSV column. Ragged rows are marked; source data is not changed.

    Free

    Security scanned

    Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    Column Profile — Paste CSV Rows, Get Fill Rate per Column

    Example session with this skill installed

    python3 scripts/column_profile.py examples/people.csv

    • Read your context and instructions
    • Compiled the column profile

    Data rows: 3
    Counts only; values are not changed and no cleanup advice is provided.
    Column | rows | blanks | blank rate | distinct | numeric | min | max | non-numeric (not read as a number)
    name | 3 | 0 | 0.00% | 3 | 0 | — | — | 3
    age | 3 | 1 | 33.33% | 3 | 1 | 36 | 36 | 1
    score | 3 | 0 | 0.00% | 3 | 3 | 0 | 98.5 | 0
    note | 3 | 1 | 33.33% | 2 | 0 | — | — | 2

    Connects securely to your tools. The creator never sees your data.

    About this skill

    Paste CSV rows with a header. You get per-column row counts, blank counts and rates, distinct values, numeric counts and ranges, and non-numeric counts. Rows with a different number of cells show the source line and the actual count. The blank rate uses the number of rows where that column's cell exists.

    This tool counts only. It does not change values or suggest cleanup. Empty cells are empty strings or whitespace only. Numeric values may have a leading + or -, 3-digit commas, a currency marker ($, €, £, ¥), and/or a trailing %. Exponent notation is not accepted. Units and other text are counted as non-numeric (not read as a number) and are excluded from numeric min and max. Distinct values are case-sensitive; only surrounding whitespace is trimmed.

    Output formats: text, JSON, CSV. Input can be a file or standard input. Requires Python 3.9 or newer and only the standard library. Includes examples and unit tests.

    Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Data & Databases.

    Duplicate headings, invalid UTF-8 and malformed CSV are rejected with exit code 2. Input is limited to 100,000 UTF-8 bytes and 5,000 data rows. A missing cell in a short row is absent from that column's row count, not treated as empty. Cells with units, dates or other text are counted as non-numeric, not interpreted. Distinct values are case-sensitive. The tool counts only and gives no cleanup advice.

    How to use

    1. 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. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before buying a skill.

    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

    Free to use

    No account required to browse

    Trust & safety

    Security scan

    Security scan passed today

    • Free with an Agensi account

    Software
    Python 3.9+

    Permissions

    Terminal / Shell
    Read Files
    Listedtoday

    What's inside

    Frequently Asked Questions

    Count blank, distinct, and numeric values per CSV column. Ragged rows are marked; source data is not changed.

    This skill uses the open SKILL.md standard. Use it through an MCP-compatible agent connected to Agensi, and check the compatibility information on this page for confirmed agents and required capabilities.

    Connect your AI agent to Agensi through MCP, then ask it to use Column Profile — Paste CSV Rows, Get Fill Rate per Column on your task. Your agent loads the latest approved version each time. Paid skills require a purchase or active subscription. Skill files are not available for download; your licence does not allow you to save, copy or export any part of a skill.

    New in Data & Databases

    Free