Does it improve code readability?

Absolutely. It refactors monolithic blocks of code into clean method chains using .pipe() and .query(), making complex data transformations much easier to follow.

How does this skill improve Pandas execution speed?

It identifies row-based loops like .iterrows() and .apply() calls, replacing them with vectorized operations that leverage NumPy-backed internal processing for significant speedups.

Can it fix SettingWithCopyWarning errors?

Yes, it detects ambiguous chained indexing and refactors it into explicit .loc or .iloc access, ensuring your data modifications are predictable and warning-free.

Does it support the latest Pandas 2.0 features?

Yes, it implements modern patterns including the PyArrow backend for faster I/O and Copy-on-Write for more efficient memory handling and safer data manipulation.

How does it reduce memory consumption?

The skill analyzes data cardinality to suggest 'category' types for strings and automatically downcasts numeric columns to the most efficient bitsize without losing precision.

Pandas Refactoring & Optimization

Name: Pandas Refactoring & Optimization
Author: SnakeO

bySnakeO

0•

データサイエンスとML

Refactors Pandas code to improve performance, readability, and memory efficiency using modern best practices and 2.0+ features.

This skill acts as an elite Pandas specialist, transforming legacy or inefficient data manipulation code into high-performance, maintainable implementations. It identifies and eliminates common anti-patterns such as row-based iteration, inefficient .apply() calls, and chained indexing. By leveraging modern Pandas 2.0+ features like the PyArrow backend, Copy-on-Write, and vectorized operations, the skill ensures your data pipelines are not only faster and more memory-efficient but also cleaner and easier to debug.

主な機能

01Implements Pandas 2.0+ features including PyArrow and Copy-on-Write

02Optimizes memory usage through intelligent dtype downcasting and categorical conversion

03Refactors complex transformations into readable method chains and pipelines

04Vectorizes loops and .apply() calls for massive performance gains

050 GitHub stars

06Eliminates SettingWithCopyWarning by refactoring chained indexing patterns

ユースケース

01Converting slow legacy scripts into high-speed vectorized data pipelines

02Migrating existing codebases to utilize Pandas 2.0 performance improvements

03Optimizing memory-intensive data processing for large-scale datasets

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add snakeo/claude-debug-and-refactor-skills-plugin refactor-pandas

For use in Claude.ai and ChatGPT

Download Skill