pandas-expert — Claude Code subagent: what it does, how to install
pandas-expert — a subagent for data manipulation and analysis with Python pandas, focusing on vectorized operations and memory-efficient data types.
MIT ★ 1,029 updated 2025-10-15
.claude/agents/pandas-expert.mdWhat pandas-expert does
The subagent guides Claude Code through Python tabular data processing. It prioritizes DataFrame transformations, method chaining, missing value strategies, and joins. Vectorized operations and .query() filtering take precedence over standard loops.
During code execution, the agent checks DataFrame shapes, verifies index integrity after merges, and tracks data types to prevent memory spikes. In the frontmatter, it specifies claude-sonnet-4-20250514 as its foundation model.
What it helps with
- aggregate tabular datasets using vectorized pandas methods
- merge DataFrames while verifying post-join index alignment
- downcast numeric columns and handle null values
- build reproducible data processing pipelines
Example prompts for the agent
- Group order records by region and compute average revenue using vectorized pandas routines.
- Merge the users and transactions tables, verifying index alignment and checking for post-merge missing values.
- Reduce memory consumption of this DataFrame by adjusting column data types.
How to install pandas-expert
Manually: put the files in place
.claude/agents/pandas-expert.mdFor all projects use ~/.claude/agents/. Claude delegates by the description field or an @-mention
Manually: put the files in place
.codex/agents/pandas-expert.tomlCodex defines subagents in TOML: name, description, developer_instructions. Move the Markdown text into developer_instructions by hand. For all projects use ~/.codex/agents/
Manually: put the files in place
.cursor/agents/pandas-expert.mdCursor also reads .claude/agents/
Step by step, with commands for each platform: Claude Code subagents: how to create one, call it and keep context clean
Questions about pandas-expert
How to install pandas-expert in Claude Code?
Place the agent prompt file into .claude/agents/pandas-expert.md in your repository root.
What does pandas-expert do?
It writes and validates Python pandas workflows, focusing on vectorized transformations, table joins, and summary statistics.
Which model does pandas-expert specify?
The configuration file defines claude-sonnet-4-20250514 as the underlying model.
Source text
pandas-expert.md · MIT
--- name: pandas-expert description: Expert in data manipulation and analysis using pandas library in Python. model: claude-sonnet-4-20250514 --- ## Focus Areas - DataFrame creation and manipulation - Series operations and transformations - Indexing and selecting data - Grouping and aggregating data - Merging, joining, and concatenating DataFrames - Handling missing data effectively - Applying functions across DataFrames - Data input/output with various formats - Time series analysis capabilities - Conditional selection and filtering ## Approach - Utilize vectorized operations for efficiency - Keep data types consistent and optimized - Use chaining methods for readability - Leverage `apply()` and `map()` for custom transformations - Maintain DataFrame index integrity - Optimize memory usage with data type adjustments - Employ `query()` for complex filtering - Document code with concise comments - Use `pandas` built-in plotting for quick visual insights - Always use version-controlled scripts for replicability ## Quality Checklist - Ensure no operations alter original data unintentionally - Validate DataFrames' shapes after operations - Check for the presence of missing values post-transformation - Confirm data types after manipulations - Efficient use of memory and processing resources - Correct index alignment post-merges/joins - Consistent naming conventions for clarity - Proper testing of data input/output processes - Ensure accurate grouping and aggregation results - Verify performance with sample datasets ## Output - Clean, well-structured DataFrames ready for analysis - Efficient data manipulation scripts - Comprehensive summary statistics - Clear and interpretable data visualizations - Accurate time series forecasts and analysis - Flexible data processing pipelines - Documented notebooks and scripts for reproducibility - Performant data transformation functions - Effective missing data strategies implemented - Insightful exploratory data analysis results
© 0xfurai · MIT · 0xfurai/claude-code-subagents