pandasAnalyze, transform, and clean DataFrames with efficient patterns for filtering, grouping, merging, and pivoting.
Install via ClawdBot CLI:
clawdbot install ivangdavila/pandasRequires:
Grade Fair — based on market validation, documentation quality, package completeness, maintenance status, and authenticity signals.
Potentially destructive shell commands in tool definitions
rm -rf ~Calls external URL not in known-safe list
https://clawic.com/skills/pandasAI Analysis
The skill's primary risk is calling an external URL (clawic.com) for setup documentation, which could be a privacy concern if the domain is untrusted, but no data exfiltration or credential harvesting patterns are present. The skill definition itself contains standard pandas best practices and no hidden malicious instructions or obfuscation.
Audited Apr 16, 2026 · audit v1.0
Generated Mar 20, 2026
A retail company analyzes transaction data to segment customers based on purchase frequency, average spend, and demographics. The skill helps clean and aggregate data, apply filters with query(), and group results for targeted marketing campaigns.
A finance team processes monthly sales and expense data from multiple sources. The skill merges datasets with validation, handles missing values, and pivots data to generate standardized reports, reducing manual effort and errors.
A hospital manages patient records with categorical fields like diagnosis codes and treatment status. The skill optimizes memory with categorical dtypes, cleans data by dropping or filling missing values, and sets indexes for fast lookups.
An online retailer analyzes product sales and stock levels across warehouses. The skill uses vectorized operations to calculate turnover rates, applies complex filters with query(), and exports results to identify slow-moving items.
Researchers process survey data with multiple variables, handling outliers and merging datasets from different studies. The skill chains methods for readability, validates merges to prevent data loss, and prepares clean DataFrames for statistical analysis.
Offer tailored data analysis services to businesses lacking in-house expertise, using the skill to clean, transform, and analyze client data efficiently. Revenue comes from project-based fees or retainer contracts.
Develop a cloud-based tool that integrates this skill for automated data processing and reporting, targeting small to medium enterprises. Revenue is generated through subscription tiers based on data volume and features.
Provide courses and certifications on data analysis with pandas, leveraging the skill's best practices and common traps. Revenue streams include course fees, certification exams, and corporate training packages.
💬 Integration Tip
Integrate with related skills like csv or sql for seamless data import/export, and ensure local data storage compliance by keeping operations within ~/pandas/.
Scored Apr 16, 2026
Use the @steipete/oracle CLI to bundle a prompt plus the right files and get a second-model review (API or browser) for debugging, refactors, design checks, or cross-validation.
Local search/indexing CLI (BM25 + vectors + rerank) with MCP mode.
Design data models for construction projects. Create entity-relationship diagrams, define schemas, and generate database structures.
MarkItDown is a Python utility from Microsoft for converting various files (PDF, Word, Excel, PPTX, Images, Audio) to Markdown. Useful for extracting structu...
Connect to Supabase for database operations, vector search, and storage. Use for storing data, running SQL queries, similarity search with pgvector, and managing tables. Triggers on requests involving databases, vector stores, embeddings, or Supabase specifically.
Use when designing database schemas, writing migrations, optimizing SQL queries, fixing N+1 problems, creating indexes, setting up PostgreSQL, configuring EF Core, implementing caching, partitioning tables, or any database performance question.