Csv & Spreadsheet Analyzer
Analyze CSV, Excel & JSON data: statistics, quality issues & Python code
What You Can Do
Systematically analyze any CSV, Excel, or JSON dataset to understand its structure, quality, and patterns. You'll receive detailed summary statistics (mean, median, standard deviation, quartiles), identify missing values, duplicates, and type mismatches, detect statistical outliers and anomalies, and get working Python/pandas code you can run or integrate directly into your data pipelines.
Features
Calculate mean, median, standard deviation, quartiles, and value counts for all numeric and categorical columns
Automatically detect missing values, duplicates, type inconsistencies, and cardinality issues across your dataset
Identify statistical anomalies using IQR, Z-score, and distribution analysis methods
Generate ready-to-run pandas code that replicates the analysis for integration into your workflows
Map null patterns and provide insights into data completeness by column and row
Identify relationships between numeric variables to spot patterns and dependencies
Analyze value distributions, skewness, and kurtosis to understand data shape and spread
Example Output
Input: CSV with 1,000 sales records
Output:
- Dataset has 1,000 rows × 8 columns; 2.3% missing values in 'region'
- Top 3 anomalies: 3 orders with negative quantities, 15 prices >3 std devs above mean
- Correlation matrix shows strong relationship (0.87) between order_value and quantity
- Python code block with pandas script to reproduce all findings
Input: Excel spreadsheet with employee data
Output:
- 145 employees; 12 duplicates by email found; salary range $35k–$250k (outlier: one record at $1.2M)
- Missing department values in 8 records; job_title has 42 unique values
- Recommended data cleaning steps with code snippet to handle duplicates and type conversions
What's Included
- SKILL.md: Complete system prompt with analysis methods and output structure
- Data Quality Checklist: Step-by-step checklist for validating datasets before analysis
- Python Code Templates: Reusable pandas snippets for statistics, outlier detection, and profiling
- Analysis Report Framework: Structured markdown template for documenting findings and recommendations
- Sample Datasets: Example CSV files to test the skill and practice exploratory data analysis
Who It's For
- Data Analysts — Quickly onboard and validate new datasets before modeling
- Data Engineers — Profile raw data and identify quality issues before pipeline processing
- Business Analysts — Understand data structure and anomalies for reporting and insights
- Data Scientists — Perform exploratory data analysis and detect outliers before feature engineering
- Database Administrators — Validate data integrity and completeness across source systems
Best For
- Exploratory Data Analysis (EDA) — Get a complete statistical overview of unfamiliar datasets
- Data Quality Assessment — Detect missing values, duplicates, type mismatches, and anomalies
- Outlier Detection — Identify statistical anomalies and unusual records using multiple methods
- Data Validation Workflows — Validate datasets before downstream processing or analysis
- Python Code Generation — Receive reproducible pandas code ready to integrate into pipelines
You might also like
Create comprehensive KPI dashboards that track supply chain performance across cost, quality, delivery, and service metrics. Automate variance analysis to identify root causes of performance deviations and generate executive-level reports that translate operational data into actionable insights for leadership and stakeholders.
by skillslib
You'll design robust SCADA system architectures, configure industrial protocols (Modbus, Profibus, OPC-UA, DNP3), and diagnose connectivity and performance issues across distributed control networks. Get step-by-step configuration guidance, integration workflows, and troubleshooting decision trees tailored to your specific hardware and protocol stack.
by skillslib
You can establish systematic color grading workflows that accelerate project delivery, ensure visual consistency across episodes and projects, and maintain broadcast-quality standards. Claude generates reusable templates, quality control checklists, and grading decision frameworks tailored to your project's color science and deliverable requirements.
by skillslib
You can orchestrate every aspect of your live event with a unified command center that responds to real-time incidents, coordinates teams across departments, and adjusts plans on the fly. The skill generates contingency workflows, communication protocols, and decision frameworks so you stay ahead of problems instead of reacting to them. You'll have structured guidance for everything from timeline adjustments to vendor coordination to emergency escalations.
by skillslib
You'll build complete activation funnels by analyzing user behavior, identifying conversion bottlenecks, and designing targeted onboarding campaigns. Claude creates customer journey maps, funnel stage definitions, engagement messaging frameworks, and A/B testing strategies tailored to your product and audience.
by skillslib
Use Claude to automate your entire collection workflow, from first touch to recovery, with legally sound escalation protocols. You'll recover more money in less time, reduce bad debt write-offs by 25-40%, and build defensible collection records that withstand legal scrutiny. Claude handles customized demand letters, compliance validation, debtor profiling, and escalation strategies tailored to account age, debtor behavior, and jurisdiction.
by skillslib
You can conduct comprehensive active transportation network audits that identify missing links, connectivity gaps, and underserved communities. Claude helps you prioritize infrastructure investments against limited budgets using equity screening, mode-share modeling, and cost-benefit analysis—producing client-ready documentation and stakeholder presentations that justify infrastructure decisions with quantitative evidence rather than assumptions.
by skillslib
This skill helps you troubleshoot Wwise integration issues, diagnose audio performance bottlenecks, and generate comprehensive documentation for interactive audio specifications. You'll get step-by-step fixes for common implementation problems, performance optimization strategies, and best practices for audio systems across different game engines and platforms.
by skillslib