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
Prepare comprehensive expert witness reports and testimony that meet Daubert standards for admissibility and withstand cross-examination scrutiny. You'll get structured case analyses integrating psychological assessments, relevant case law citations, and anticipated counterarguments. The skill helps you document your forensic opinions with the legal rigor required in criminal, civil, and family law proceedings.
by skillslib
You design robust motion control systems by generating control architectures, tuning PID and state-space controllers, and analyzing stability margins with detailed performance predictions. You'll get transfer functions, tuned gains, frequency response plots, real-time constraint validation, and code templates ready for implementation in MATLAB or Python.
by skillslib
You can systematically evaluate architectural options by building decision matrices, identifying trade-offs, and documenting design rationale. This skill generates comparison frameworks, risk assessments, and architecture decision records (ADRs) that help you choose between competing approaches based on concrete criteria like performance, scalability, cost, and team capabilities.
by skillslib
You provide a single core insight or perspective, and this skill transforms it into a complete, coordinated thought leadership content suite across every major channel. It generates optimized articles, social threads, email sequences, presentation outlines, and more—all reinforcing the same core message while adapting to each platform's unique audience and format. Every piece maintains strategic consistency while maximizing reach and engagement.
by skillslib
Analyze commercial insurance applications by extracting risk factors, evaluating loss history and industry exposure, and generating structured underwriting recommendations with standardized documentation. You'll reduce review time per application, ensure consistent decision criteria across your team, and maintain compliant audit trails for every underwriting action.
by skillslib
You can systematically diagnose flow problems in your Kanban board by analyzing stage-by-stage work accumulation, cycle time patterns, and throughput trends. The skill generates flow metrics dashboards, identifies capacity constraints, forecasts delivery dates based on historical data, and produces prioritized improvement recommendations with estimated impact—giving you objective evidence to guide WIP adjustments, process changes, and retrospective discussions.
by skillslib
You can map your game's features to certification requirements across ESRB, PEGI, USK, CLASSIND, and platform-specific standards simultaneously. The skill generates compliant test cases that prove adherence to each body's content and technical standards, tracks certification status to identify gaps before submission, and documents evidence trails for audits and appeals. This prevents costly certification rejections (2-8 week delays, $2,500-$10,000+ resubmission fees) by ensuring comprehensive compliance documentation from the QA phase onward.
by skillslib
You can design culturally appropriate survey instruments tailored to international development contexts, analyze mixed-methods data by integrating quantitative findings with qualitative insights, and implement robust data quality management systems for your field operations. Claude helps you create survey templates with adaptive logic, develop validation protocols, and produce data quality reports that highlight issues before analysis begins.
by skillslib