pandas-data-analysis

What problem does it solve?

This Skill helps you choose the most efficient and appropriate pandas operations for your data analysis tasks, preventing performance bottlenecks and improving code clarity.

Core Features & Use Cases

• Method Selection: Guides you on when to use groupby vs. pivot_table, merge vs. concat, and apply vs. vectorized operations.
• Data Cleaning Strategies: Provides decision frameworks for handling missing values, duplicates, and outliers.
• Performance Optimization: Offers advice on vectorization, memory optimization, and choosing alternatives for large datasets.
• Use Case: You have a large dataset and need to calculate the monthly sales per region. This Skill will guide you to use groupby().resample() or pivot_table() instead of a slow apply function.

Quick Start

Use the pandas-data-analysis skill to decide the best way to combine two dataframes based on a common key.