Back to catalog
Human reviewedData & analysis

Skill dossier

pandas-pro

Source declaration

Performs pandas DataFrame operations for data analysis, manipulation, and transformation. Use when working with pandas DataFrames, data cleaning, aggregation, merging, or time series analysis. Invoke for data manipulation tasks such as joining DataFrames on multiple keys, pivoting tables, resampling time series, handling NaN values with interpolation or forward-fill, groupby aggregations, type conversion, or performance optimization of large datasets.

The author's original description, preserved in English. It describes intent, not verified performance.

Performs pandas DataFrame operations for data analysis, manipulation, and transformation. Use when working with pandas DataFrames, data cleaning, aggregation, merging, or time series analysis. Invoke for data manipulation tasks such as joining DataFrames on multiple keys, pivoting tables, resampling time series, handling NaN values with interpolation or forward-fill, groupby aggregations, type conversion, or performance optimization of large datasets.

datareferences

Research summary

Human reviewed

Skill Atlas editorial review · editorial-preview-1.0.0

A pandas Skill that favors vectorized operations and explicit data validation, covering cleaning, merging, groupby, resampling and memory optimization.

Review scope

Deterministic static analysis of collected SKILL.md and supporting text/code. Machine-assisted candidates and findings await human editorial review; no dynamic behavior or effect is assessed.

Observable capabilities

  • Inspects dtypes, memory usage and missing values before transforming.
  • Writes vectorized, method-chained code instead of row loops.
  • Merges with validate and indicator checks and aggregates with groupby.
  • Asserts shapes, nulls and columns after transforms and optimizes memory.

Limitations & scope

  • Scope is pandas; other dataframe libraries are not addressed.
  • Imputation examples such as median or mode fill may not suit every dataset.
  • No code is executed against your data here.

Relevant for

  • Data analysts and scientists
  • Engineers cleaning tabular data
  • Developers optimizing slow pandas code

What ships with the skill

The file inventory comes from the collected source at the recorded commit. Paths and sizes are structural observations, not a measure of quality.

files
6
Markdown files
6
scripts
0
references
5
Size
68.9 KB
Structural complexity
Low

File inventory

PathTypeBytes
skills/pandas-pro/references/aggregation-groupby.mdReference12.9 KB
skills/pandas-pro/references/data-cleaning.mdReference12.7 KB
skills/pandas-pro/references/dataframe-operations.mdReference9.4 KB
skills/pandas-pro/references/merging-joining.mdReference13.2 KB
skills/pandas-pro/references/performance-optimization.mdReference14.7 KB
skills/pandas-pro/SKILL.mdInstruction6 KB

SKILL.md frontmatter

{
  "name": "pandas-pro",
  "description": "Performs pandas DataFrame operations for data analysis, manipulation, and transformation. Use when working with pandas DataFrames, data cleaning, aggregation, merging, or time series analysis. Invoke for data manipulation tasks such as joining DataFrames on multiple keys, pivoting tables, resampling time series, handling NaN values with interpolation or forward-fill, groupby aggregations, type conversion, or performance optimization of large datasets.",
  "license": "MIT",
  "metadata": {
    "author": "https://github.com/Jeffallan",
    "company": "https://synergetic.solutions",
    "version": "1.1.0",
    "domain": "data-ml",
    "triggers": "pandas, DataFrame, data manipulation, data cleaning, aggregation, groupby, merge, join, time series, data wrangling, pivot table, data transformation",
    "role": "expert",
    "scope": "implementation",
    "output-format": "code",
    "related-skills": "python-pro"
  }
}

A reading of the operating sequence

This workflow reconstructs the apparent sequence from source material. Unless controlled evaluation is explicitly recorded, it is provisional—not an observed trace.

  1. 01
    Input

    Assess data structure

    Examine dtypes, memory usage, missing values and data quality.

  2. 02
    Action

    Implement efficiently

    Use vectorized methods, method chaining and proper indexing.

  3. 03
    Decision

    Validate results

    Check dtypes, shapes, null counts and row counts with assertions.

  4. 04
    Output

    Deliver code with checks

    Provide commented code, performance notes for large data and validation checks.

Potential risk surfaces

Static findings identify points to inspect before installation. They do not establish that a skill is safe, malicious, or effective.

Attention recommended

66 deterministic lexical finding(s) require review across the collected text. Findings can occur in documentation and do not prove execution or exploitability; binary-only files were not scanned.

Network accessObserved
File writesObserved
Credential useNot observed
Note

File modification is described or implemented

57 occurrences

This line contains a possible file-write or redirection operation. Check destination paths and overwrite behavior; the static review did not write any file. This rule matched 57 location(s) in the collected text; 3 representative location(s) are cited. Matching text may be documentation, and the analyzer did not execute it.

High

Dynamic command execution is referenced

5 occurrences

A shell, dynamic evaluation, or process execution primitive appears here. Inspect arguments and input control. Presence in source does not prove a command ran. This rule matched 5 location(s) in the collected text; 3 representative location(s) are cited. Matching text may be documentation, and the analyzer did not execute it.

Medium

Network access is mentioned

4 occurrences

A URL or network client appears in this source line. Review destinations, data sent, and trust boundaries; static text cannot establish actual network activity. This rule matched 4 location(s) in the collected text; 3 representative location(s) are cited. Matching text may be documentation, and the analyzer did not execute it.

Editorial security note

Check any file paths, data sources and in-place modifications before running generated code on real or sensitive datasets.

Where context can be spent

Discovery, activation, and resource layers have different meanings. Exact values appear only when the official token-counting method was run with a named model.

Exact token counts unavailable

All token values, including per-file inventory, are null until the pipeline performs an official exact count with an explicit model.

No token measurement was recorded with the required official method. This dossier does not substitute character counts, file sizes, or estimates.

Controlled evaluation

No controlled evaluation

This skill has only the evidence identified above. No task success, token efficiency, latency, or quality advantage is claimed.

Not tested

Use with the source in view

Install command
git clone https://github.com/Jeffallan/claude-skills.git cd claude-skills # Copy this skill directory into one of: # ~/.claude/skills/pandas-pro # .claude/skills/pandas-pro
  1. Open the pinned source at https://github.com/Jeffallan/claude-skills/blob/67c1961b180dc92cf08983344627109e983e8f51/skills/pandas-pro/SKILL.md.
  2. Review the license, prerequisites and all bundled reference files.
  3. Copy the skill directory into a personal or project-level Claude Code skills directory.
  4. Restart or refresh Claude Code so the skill can be discovered.
Verify installation

Ask Claude Code to clean a DataFrame and confirm it inspects dtypes and nulls first and asserts row counts afterward.

Prerequisites

  • Scope is pandas; other dataframe libraries are not addressed.
  • Imputation examples such as median or mode fill may not suit every dataset.
  • No code is executed against your data here.

Example prompts

Representative task

Using the pandas-pro skill, merge orders and customers on customer_id and date with validation, aggregate revenue by region and category, resample to daily totals, and assert the row counts.

Inspect before use

Read the pandas-pro skill at https://github.com/Jeffallan/claude-skills/blob/67c1961b180dc92cf08983344627109e983e8f51/skills/pandas-pro/SKILL.md and its reference files. Explain its workflow, any commands it tells the agent to run, and the main risks before I decide whether to install it.

A decision, with its limits attached

Strengths

  • Before and after examples for common pitfalls such as chained indexing.
  • Treats validation of results as a core step.

Considerations

  • Assertions in examples may need adapting to real expected values.
  • Some pandas idioms may differ across versions.
Research conclusion

A compact, practical guide for writing clean and verifiable pandas code.

Traceable by construction

The dossier is a time-bound reading of a public artifact, not an endorsement. Use the source link to inspect the exact upstream material.

Jeffallanclaude-skillsskills/pandas-pro
Source type
Community
Commit
67c1961b180dc92cf08983344627109e983e8f51
Collected
20 Nov 2026
Last checked
20 Nov 2026
Upstream license
MIT
Repository stars
12,464
Content basis

Deterministic lexical parsing, YAML frontmatter validation, file inventory, source-described workflow extraction, and heuristic provisional classification of the supplied files only. Generated by machine; no LLM, execution, dynamic testing, or human editorial approval.