How does this skill help me prepare my data for analysis?

This skill performs an automated audit of your CSV or spreadsheet export, identifying data quality issues like mixed formats, duplicates, and outliers before you begin analysis or cleaning.

Will this skill modify my original CSV file during the sanity check?

No, this skill is designed for non-destructive reporting; it reads and profiles your file without altering the original data or structure.

Which AI platforms or agents can I use this skill with?

This skill is compatible with any AI agent that supports file uploads, and it includes a 'prompt.md' version for manual use with standard chatbots.

What specific metrics are included in the profiling report?

Beyond basic counts, you get insights into numeric ranges, case/spacing variants, distinct value counts, and a specific list of questions to ask the data owner to ensure integrity.

Is there a cost to use this skill, and what is included in the package?

This is a free, open-source tool under the MIT license; you can access the full source code, documentation, and the paste-in prompt version via the official GitHub repository.

CSV Profile and Sanity Check

Example session with this skill installed

Profile this CSV before I use it: [file]. It should contain ...

Read your context and instructions
Compiled the csv profile

Before: Opening a 891-row export and scrolling for a few minutes to see if it looks fine.

After (skill output, from a real test run): Test run on a public 891-row passenger CSV. It reported 19% blank in Age (177 rows) and 77% blank in Cabin, 15 zero fares, 53 high fare outliers, a Ticket column that should be read as text, trailing spaces in names and 2 blank Embarked values, named the two rows, and asked the owner eight questions, such as whether Fare is per person or per ticket. It changed nothing in the file.

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

About this skill

Reads a CSV or spreadsheet export without changing it and reports what is in it, including row and column counts, each column's type, blanks, distinct values, numeric ranges, duplicates, mixed formats, odd outliers and case or spacing variants, then lists what to ask the data's owner before anyone uses it. Use when someone has a CSV or exported sheet and says "what is in this file", "is this data OK", "sanity check this export", "profile this CSV", or before cleaning, joining or analysing a file.

Free and open source (MIT). Source and README: https://github.com/proskillpacks/skills/tree/main/skills/data/csv-profile-and-sanity-check All our free skills: https://github.com/proskillpacks/skills . More from Pro Skill Packs: https://proskillpacks.github.io

Every skill in the folder ships with prompt.md, a paste-in version for chatbots that cannot load skills.

How to use

Skills on Agensi run inside your AI agent. Copy the prompt, paste it into your agent, and it connects to Agensi and installs this skill for you. If a payment is needed, your agent shows it to you first.

Reviews

No reviews yet

Be one of the first to try it. Every listed skill passes our trust checks below.

Security scanned

Passed our 8-point scan before listing

Fresh listing

Recently published to Agensi

Free forever

No account required to browse

Frequently Asked Questions

CSV Profile and Sanity Check