📊 CSV Data Summarizer - Claude Skill
A powerful Claude Skill that automatically analyzes CSV files and generates comprehensive insights with visualizations. Upload any CSV and get instant, intelligent analysis without being asked what you want!
🚀 Features
- 🤖 Intelligent & Adaptive - Automatically detects data type (sales, customer, financial, survey, etc.) and applies relevant analysis
- 📈 Comprehensive Analysis - Generates statistics, correlations, distributions, and trends
- 🎨 Auto Visualizations - Creates multiple charts based on what's in your data:
- Time-series plots for date-based data
- Correlation heatmaps for numeric relationships
- Distribution histograms
- Categorical breakdowns
- ⚡ Proactive - No questions asked! Just upload CSV and get complete analysis immediately
- 🔍 Data Quality Checks - Automatically detects and reports missing values
- 📊 Multi-Industry Support - Adapts to e-commerce, healthcare, finance, operations, surveys, and more
📥 Quick Download
Get Started in 2 Steps
1️⃣ Download the Skill
2️⃣ Try the Demo Data
📦 What's Included
csv-data-summarizer-claude-skill/
├── SKILL.md # Claude Skill definition
├── analyze.py # Comprehensive analysis engine
├── requirements.txt # Python dependencies
├── examples/
│ └── showcase_financial_pl_data.csv # Demo P&L financial dataset (15 months, 25 metrics)
└── resources/
├── sample.csv # Example dataset
└── README.md # Usage documentation
🎯 How It Works
- Upload any CSV file to Claude.ai
- Skill activates automatically when CSV is detected
- Analysis runs immediately - inspects data structure and adapts
- Results delivered - Complete analysis with multiple visualizations
No prompting needed. No options to choose. Just instant, comprehensive insights!
📥 Installation
For Claude.ai Users
- Download the latest release:
csv-data-summarizer.zip
- Go to Claude.ai → Settings → Capabilities → Skills
- Upload the zip file
- Enable the skill
- Done! Upload any CSV and watch it work ✨
For Developers
git clone git@github.com:coffeefuelbump/csv-data-summarizer-claude-skill.git
cd csv-data-summarizer-claude-skill
pip install -r requirements.txt
📊 Sample Dataset Highlights
The included demo CSV contains 15 months of P&L data with:
- 3 product lines (SaaS, Enterprise, Services)
- 25 financial metrics including revenue, expenses, margins, CAC, LTV
- Quarterly trends showing business growth
- Perfect for showcasing time-series analysis, correlations, and financial insights
🎨 Example Use Cases
- 📊 Sales Data → Revenue trends, product performance, regional analysis
- 👥 Customer Data → Demographics, segmentation, geographic patterns
- 💰 Financial Data → Transaction analysis, trend detection, correlations
- ⚙️ Operational Data → Performance metrics, time-series analysis
- 📋 Survey Data → Response distributions, cross-tabulations
🛠️ Technical Details
Dependencies:
- Python 3.8+
- pandas 2.0+
- matplotlib 3.7+
- seaborn 0.12+
Visualizations Generated:
- Time-series trend plots
- Correlation heatmaps
- Distribution histograms
- Categorical bar charts
📝 Example Output
===========================================
## Code Examples
### showcase_financial_pl_data.csv
month,year,quarter,product_line,total_revenue,cost_of_goods_sold,gross_profit,gross_margin_pct,marketing_expense,sales_expense,rd_expense,admin_expense,total_operating_expenses,operating_income,operating_margin_pct,interest_expense,tax_expense,net_income,net_margin_pct,customer_acquisition_cost,customer_lifetime_value,units_sold,avg_selling_price,headcount,revenue_per_employee
Jan,2023,Q1,SaaS Platform,450000,135000,315000,70.0,65000,85000,45000,35000,230000,85000,18.9,5000,16000,64000,14.2,125,2400,1200,375,45,10000
Jan,2023,Q1,Enterprise Solutions,280000,112000,168000,60.0,35000,55000,25000,20000,135000,33000,11.8,3000,6600,23400,8.4,450,8500,450,622,45,6222
Jan,2023,Q1,Professional Services,125000,50000,75000,60.0,15000,22000,8000,12000,57000,18000,14.4,1500,3600,12900,10.3,200,3200,95,1316,45,2778
Feb,2023,Q1,SaaS Platform,475000,142500,332500,70.0,68000,89000,47000,36000,240000,92500,19.5,5200,18500,68800,14.5,120,2500,1300,365,47,10106
Feb,2023,Q1,Enterprise Solutions,295000,1180
-4F46E5?style=for-the-badge){kind=icon}
