Python Pandas Data Analyzer skill for Claude and Codex
Runnable Pandas code that cleans, reshapes, and analyses a described dataset, with the missing-value handling and optional plot already written.
Install it once and Claude or Codex runs it for you. When your request matches, your AI loads the skill, asks for anything it is missing, and works through the template itself. Prefer to fill it in by hand? See the full prompt template.
Download the skill (.zip) · View SKILL.md
When it is used
Use when an analyst needs Pandas code to clean and analyse a dataset they can describe by its columns and goal. Do not use for SQL queries or choosing which statistical test to use. Related topics: data, python, coding.
What it will ask you for
- Dataset (columns and data types) (longer free text)
- Goal of the analysis (longer free text)
- Operations to include (choose any: GroupBy, Merge or join, Handle missing values, Pivot tables, Date parsing)
- Add a Matplotlib or Seaborn plot (choose one: Yes, No)
- Output format (choose one: Python script, Jupyter notebook cells)
How it works
- Write the load step with checks for dtypes, nulls, and duplicates, and print the findings.
- Add cleaning for missing values and dates, each with a comment on the assumption it makes.
- Implement the requested operations with vectorised Pandas, done when the final DataFrame answers the stated goal.
- Add the plot if requested, with labelled axes and a title.
- Include a small sample dataset and list any column-name or dtype assumptions.
What you get
One code block in the chosen format (script or notebook cells) with comments and sample data, then a short list of assumptions.
What it watches out for
- Using loops or apply where a vectorised operation is faster and clearer.
- Filling missing values silently, which changes the result without the reader knowing.
- Merging without checking key uniqueness, which duplicates rows and inflates totals.
How to install
Claude.ai and the Claude desktop app
- Download the skill .zip.
- Open Settings, then Capabilities, and find Skills.
- Choose Upload skill and select the .zip.
- Ask Claude for help with the task. It loads the skill when your request matches.
Claude Code
- Download the skill .zip.
- Unzip it into ~/.claude/skills/ (or .claude/skills/ inside a project).
- Start a new session. Claude Code loads the skill when your request matches.
Codex
- Download the skill .zip.
- Unzip it into ~/.agents/skills/ (or .agents/skills/ inside a project).
- Codex picks it up on its own. Type $ and the skill name to use it, or just ask for the task.
Cursor
- Download the Cursor rule (.mdc).
- Save it in .cursor/rules/ inside your project.
- Cursor's agent applies the rule when your request matches its description.
AGENTS.md (Codex, Cursor, and other coding agents)
- Copy the AGENTS.md section.
- Paste it into AGENTS.md at the root of your repository, creating the file if needed.
- Coding agents that read AGENTS.md follow it when your request fits.