csv-data-summarizer
Analyzes CSV files, generates summary stats, and plots quick visualizations using Python and pandas.
Safety scan
A static text scan, not a guarantee. Select the badge to see what was scanned and every finding.
Badge for your README
Markdown
[](/listings/coffeefuelbump-csv-data-summarizer-claude-skill)HTML
<a href="/listings/coffeefuelbump-csv-data-summarizer-claude-skill"><img src="/api/listings/coffeefuelbump-csv-data-summarizer-claude-skill/badge.svg" alt="findsafeskills safety rating" /></a>Install
Install instructions from the README
As written by the repo's author. findsafeskills has not verified these steps.
For Claude.ai Users
1. Download the latest release: [`csv-data-summarizer.zip`](https://github.com/coffeefuelbump/csv-data-summarizer-claude-skill/releases) 2. Go to [Claude.ai](https://claude.ai) → Settings → Capabilities → Skills 3. Upload the zip file 4. Enable the skill 5. 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
What was scanned
The files the safety scan read, as written by the repository's author and shown as plain text. Lines with a finding are marked.
SKILL.md · Manifest · 149 lines
View this file on GitHub (read at the repository's current version: the scan did not record which commit it read)
- ---
- name: csv-data-summarizer
- description: Analyzes CSV files, generates summary stats, and plots quick visualizations using Python and pandas.
- metadata:
- version: 2.1.0
- dependencies: python>=3.8, pandas>=2.0.0, matplotlib>=3.7.0, seaborn>=0.12.0
- ---
- # CSV Data Summarizer
- This Skill analyzes CSV files and provides comprehensive summaries with statistical insights and visualizations.
- ## When to Use This Skill
- Claude should use this Skill whenever the user:
- - Uploads or references a CSV file
- - Asks to summarize, analyze, or visualize tabular data
- - Requests insights from CSV data
- - Wants to understand data structure and quality
- ## How It Works
- ## ⚠️ CRITICAL BEHAVIOR REQUIREMENT ⚠️
- **DO NOT ASK THE USER WHAT THEY WANT TO DO WITH THE DATA.**
- **DO NOT OFFER OPTIONS OR CHOICES.**
- **DO NOT SAY "What would you like me to help you with?"**
- **DO NOT LIST POSSIBLE ANALYSES.**
- **IMMEDIATELY AND AUTOMATICALLY:**
- 1. Run the comprehensive analysis
- 2. Generate ALL relevant visualizations
- 3. Present complete results
- 4. NO questions, NO options, NO waiting for user input
- **THE USER WANTS A FULL ANALYSIS RIGHT AWAY - JUST DO IT.**
- ### Automatic Analysis Steps:
- **The skill intelligently adapts to different data types and industries by inspecting the data first, then determining what analyses are most relevant.**
- 1. **Load and inspect** the CSV file into pandas DataFrame
- 2. **Identify data structure** - column types, date columns, numeric columns, categories
- 3. **Determine relevant analyses** based on what's actually in the data:
- - **Sales/E-commerce data** (order dates, revenue, products): Time-series trends, revenue analysis, product performance
- - **Customer data** (demographics, segments, regions): Distribution analysis, segmentation, geographic patterns
- - **Financial data** (transactions, amounts, dates): Trend analysis, statistical summaries, correlations
- - **Operational data** (timestamps, metrics, status): Time-series, performance metrics, distributions
- - **Survey data** (categorical responses, ratings): Frequency analysis, cross-tabulations, distributions
- - **Generic tabular data**: Adapts based on column types found
- 4. **Only create visualizations that make sense** for the specific dataset:
- - Time-series plots ONLY if date/timestamp columns exist
- - Correlation heatmaps ONLY if multiple numeric columns exist
- - Category distributions ONLY if categorical columns exist
- - Histograms for numeric distributions when relevant
- 5. **Generate comprehensive output** automatically including:
- - Data overview (rows, columns, types)
- - Key statistics and metrics relevant to the data type
- - Missing data analysis
- - Multiple relevant visualizations (only those that apply)
- - Actionable insights based on patterns found in THIS specific dataset
- 6. **Present everything** in one complete analysis - no follow-up questions
- **Example adaptations:**
- - Healthcare data with patient IDs → Focus on demographics, treatment patterns, temporal trends
- - Inventory data with stock levels → Focus on quantity distributions, reorder patterns, SKU analysis
- - Web analytics with timestamps → Focus on traffic patterns, conversion metrics, time-of-day analysis
- - Survey responses → Focus on response distributions, demographic breakdowns, sentiment patterns
- ### Behavior Guidelines
- ✅ **CORRECT APPROACH - SAY THIS:**
- - "I'll analyze this data comprehensively right now."
- - "Here's the complete analysis with visualizations:"
- - "I've identified this as [type] data and generated relevant insights:"
- - Then IMMEDIATELY show the full analysis
- ✅ **DO:**
- - Immediately run the analysis script
- - Generate ALL relevant charts automatically
- - Provide complete insights without being asked
- - Be thorough and complete in first response
- - Act decisively without asking permission
- ❌ **NEVER SAY THESE PHRASES:**
- - "What would you like to do with this data?"
- - "What would you like me to help you with?"
- - "Here are some common options:"
- - "Let me know what you'd like help with"
- - "I can create a comprehensive analysis if you'd like!"
- - Any sentence ending with "?" asking for user direction
- - Any list of options or choices
- - Any conditional "I can do X if you want"
- ❌ **FORBIDDEN BEHAVIORS:**
- - Asking what the user wants
- - Listing options for the user to choose from
- - Waiting for user direction before analyzing
- - Providing partial analysis that requires follow-up
- - Describing what you COULD do instead of DOING it
- ### Usage
- The Skill provides a Python function `summarize_csv(file_path)` that:
- - Accepts a path to a CSV file
- - Returns a comprehensive text summary with statistics
- - Generates multiple visualizations automatically based on data structure
- ### Example Prompts
- > "Here's `sales_data.csv`. Can you summarize this file?"
- > "Analyze this customer data CSV and show me trends."
- > "What insights can you find in `orders.csv`?"
- ### Example Output
- **Dataset Overview**
- - 5,000 rows × 8 columns
- - 3 numeric columns, 1 date column
- **Summary Statistics**
- - Average order value: $58.2
- - Standard deviation: $12.4
- - Missing values: 2% (100 cells)
- **Insights**
- - Sales show upward trend over time
- - Peak activity in Q4
- *(Attached: trend plot)*
- ## Files
- - `analyze.py` - Core analysis logic
- - `requirements.txt` - Python dependencies
- - `resources/sample.csv` - Example dataset for testing
- - `resources/README.md` - Additional documentation
- ## Notes
- - Automatically detects date columns (columns containing 'date' in name)
- - Handles missing data gracefully
- - Generates visualizations only when date columns are present
- - All numeric columns are included in statistical summary
README.md · README · 198 lines
View this file on GitHub (read at the repository's current version: the scan did not record which commit it read)
- <div align="center">
- [-4F46E5?style=for-the-badge)](https://www.skool.com/ai-for-your-business)
- [](https://github.com/coffeefuelbump)
- [](https://linktr.ee/corbin_brown)
- [](https://www.youtube.com/channel/UCJFMlSxcvlZg5yZUYJT0Pug/join)
- </div>
- ---
- # 📊 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!
- <div align="center">
- [](https://github.com/coffeefuelbump/csv-data-summarizer-claude-skill)
- [](https://www.python.org/)
- [](LICENSE)
- </div>
- ## 🚀 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
- <div align="center">
- ### Get Started in 2 Steps
- **1️⃣ Download the Skill**
- [](https://github.com/coffeefuelbump/csv-data-summarizer-claude-skill/raw/main/csv-data-summarizer.zip)
- **2️⃣ Try the Demo Data**
- [](https://github.com/coffeefuelbump/csv-data-summarizer-claude-skill/raw/main/examples/showcase_financial_pl_data.csv)
- </div>
- ---
- ## 📦 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
- 1. **Upload** any CSV file to Claude.ai
- 2. **Skill activates** automatically when CSV is detected
- 3. **Analysis runs** immediately - inspects data structure and adapts
- 4. **Results delivered** - Complete analysis with multiple visualizations
- No prompting needed. No options to choose. Just instant, comprehensive insights!
- ## 📥 Installation
- ### For Claude.ai Users
- 1. Download the latest release: [`csv-data-summarizer.zip`](https://github.com/coffeefuelbump/csv-data-summarizer-claude-skill/releases)
- 2. Go to [Claude.ai](https://claude.ai) → Settings → Capabilities → Skills
- 3. Upload the zip file
- 4. Enable the skill
- 5. Done! Upload any CSV and watch it work ✨
- ### For Developers
- ```bash
- 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
- ```
- ============================================================
- 📊 DATA OVERVIEW
- ============================================================
- Rows: 100 | Columns: 15
- 📋 DATA TYPES:
- • order_date: object
- • total_revenue: float64
- • customer_segment: object
- ...
- 🔍 DATA QUALITY:
- ✓ No missing values - dataset is complete!
- 📈 NUMERICAL ANALYSIS:
- [Summary statistics for all numeric columns]
- 🔗 CORRELATIONS:
- [Correlation matrix showing relationships]
- 📅 TIME SERIES ANALYSIS:
- Date range: 2024-01-05 to 2024-04-11
- Span: 97 days
- 📊 VISUALIZATIONS CREATED:
- ✓ correlation_heatmap.png
- ✓ time_series_analysis.png
- ✓ distributions.png
- ✓ categorical_distributions.png
- ```
- ## 🌟 Connect & Learn More
- <div align="center">
- [-blue?style=for-the-badge&logo=data:image/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHdpZHRoPSIyNCIgaGVpZ2h0PSIyNCIgdmlld0JveD0iMCAwIDI0IDI0IiBmaWxsPSJ3aGl0ZSI+PHBhdGggZD0iTTEyIDJDNi40OCAyIDIgNi40OCAyIDEyczQuNDggMTAgMTAgMTAgMTAtNC40OCAxMC0xMFMxNy41MiAyIDEyIDJ6bTAgM2MxLjY2IDAgMyAxLjM0IDMgM3MtMS4zNCAzLTMgMy0zLTEuMzQtMy0zIDEuMzQtMyAzLTN6bTAgMTQuMmMtMi41IDAtNC43MS0xLjI4LTYtMy4yMi4wMy0xLjk5IDQtMy4wOCA2LTMuMDggMS45OSAwIDUuOTcgMS4wOSA2IDMuMDgtMS4yOSAxLjk0LTMuNSAzLjIyLTYgMy4yMnoiLz48L3N2Zz4=)](https://www.skool.com/ai-for-your-business/about)
- [](https://linktr.ee/corbin_brown)
- [](https://www.youtube.com/channel/UCJFMlSxcvlZg5yZUYJT0Pug/join)
- [](https://twitter.com/corbin_braun)
- </div>
- ## 🤝 Contributing
- Contributions are welcome! Feel free to:
- - Report bugs
- - Suggest new features
- - Submit pull requests
- - Share your use cases
- ## 📄 License
- MIT License - feel free to use this skill for personal or commercial projects!
- ## 🙏 Acknowledgments
- Built for the Claude Skills platform by [Anthropic](https://www.anthropic.com/news/skills).
- ---
- <div align="center">
- **Made with ❤️ for the AI community**
- ⭐ Star this repo if you find it useful!
- </div>
Ratings and comments
Sign in to rate this skill.
Sign inFree to use. If it’s helped, pass it on.