Skip to content
Back to search

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.

Checked today
Badge for your README
findsafeskills safety rating

Markdown

[![findsafeskills safety rating](/api/listings/coffeefuelbump-csv-data-summarizer-claude-skill/badge.svg)](/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

i

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)

  1. ---
  2. name: csv-data-summarizer
  3. description: Analyzes CSV files, generates summary stats, and plots quick visualizations using Python and pandas.
  4. metadata:
  5. version: 2.1.0
  6. dependencies: python>=3.8, pandas>=2.0.0, matplotlib>=3.7.0, seaborn>=0.12.0
  7. ---
  8. # CSV Data Summarizer
  9. This Skill analyzes CSV files and provides comprehensive summaries with statistical insights and visualizations.
  10. ## When to Use This Skill
  11. Claude should use this Skill whenever the user:
  12. - Uploads or references a CSV file
  13. - Asks to summarize, analyze, or visualize tabular data
  14. - Requests insights from CSV data
  15. - Wants to understand data structure and quality
  16. ## How It Works
  17. ## ⚠️ CRITICAL BEHAVIOR REQUIREMENT ⚠️
  18. **DO NOT ASK THE USER WHAT THEY WANT TO DO WITH THE DATA.**
  19. **DO NOT OFFER OPTIONS OR CHOICES.**
  20. **DO NOT SAY "What would you like me to help you with?"**
  21. **DO NOT LIST POSSIBLE ANALYSES.**
  22. **IMMEDIATELY AND AUTOMATICALLY:**
  23. 1. Run the comprehensive analysis
  24. 2. Generate ALL relevant visualizations
  25. 3. Present complete results
  26. 4. NO questions, NO options, NO waiting for user input
  27. **THE USER WANTS A FULL ANALYSIS RIGHT AWAY - JUST DO IT.**
  28. ### Automatic Analysis Steps:
  29. **The skill intelligently adapts to different data types and industries by inspecting the data first, then determining what analyses are most relevant.**
  30. 1. **Load and inspect** the CSV file into pandas DataFrame
  31. 2. **Identify data structure** - column types, date columns, numeric columns, categories
  32. 3. **Determine relevant analyses** based on what's actually in the data:
  33. - **Sales/E-commerce data** (order dates, revenue, products): Time-series trends, revenue analysis, product performance
  34. - **Customer data** (demographics, segments, regions): Distribution analysis, segmentation, geographic patterns
  35. - **Financial data** (transactions, amounts, dates): Trend analysis, statistical summaries, correlations
  36. - **Operational data** (timestamps, metrics, status): Time-series, performance metrics, distributions
  37. - **Survey data** (categorical responses, ratings): Frequency analysis, cross-tabulations, distributions
  38. - **Generic tabular data**: Adapts based on column types found
  39. 4. **Only create visualizations that make sense** for the specific dataset:
  40. - Time-series plots ONLY if date/timestamp columns exist
  41. - Correlation heatmaps ONLY if multiple numeric columns exist
  42. - Category distributions ONLY if categorical columns exist
  43. - Histograms for numeric distributions when relevant
  44. 5. **Generate comprehensive output** automatically including:
  45. - Data overview (rows, columns, types)
  46. - Key statistics and metrics relevant to the data type
  47. - Missing data analysis
  48. - Multiple relevant visualizations (only those that apply)
  49. - Actionable insights based on patterns found in THIS specific dataset
  50. 6. **Present everything** in one complete analysis - no follow-up questions
  51. **Example adaptations:**
  52. - Healthcare data with patient IDs → Focus on demographics, treatment patterns, temporal trends
  53. - Inventory data with stock levels → Focus on quantity distributions, reorder patterns, SKU analysis
  54. - Web analytics with timestamps → Focus on traffic patterns, conversion metrics, time-of-day analysis
  55. - Survey responses → Focus on response distributions, demographic breakdowns, sentiment patterns
  56. ### Behavior Guidelines
  57. ✅ **CORRECT APPROACH - SAY THIS:**
  58. - "I'll analyze this data comprehensively right now."
  59. - "Here's the complete analysis with visualizations:"
  60. - "I've identified this as [type] data and generated relevant insights:"
  61. - Then IMMEDIATELY show the full analysis
  62. ✅ **DO:**
  63. - Immediately run the analysis script
  64. - Generate ALL relevant charts automatically
  65. - Provide complete insights without being asked
  66. - Be thorough and complete in first response
  67. - Act decisively without asking permission
  68. ❌ **NEVER SAY THESE PHRASES:**
  69. - "What would you like to do with this data?"
  70. - "What would you like me to help you with?"
  71. - "Here are some common options:"
  72. - "Let me know what you'd like help with"
  73. - "I can create a comprehensive analysis if you'd like!"
  74. - Any sentence ending with "?" asking for user direction
  75. - Any list of options or choices
  76. - Any conditional "I can do X if you want"
  77. ❌ **FORBIDDEN BEHAVIORS:**
  78. - Asking what the user wants
  79. - Listing options for the user to choose from
  80. - Waiting for user direction before analyzing
  81. - Providing partial analysis that requires follow-up
  82. - Describing what you COULD do instead of DOING it
  83. ### Usage
  84. The Skill provides a Python function `summarize_csv(file_path)` that:
  85. - Accepts a path to a CSV file
  86. - Returns a comprehensive text summary with statistics
  87. - Generates multiple visualizations automatically based on data structure
  88. ### Example Prompts
  89. > "Here's `sales_data.csv`. Can you summarize this file?"
  90. > "Analyze this customer data CSV and show me trends."
  91. > "What insights can you find in `orders.csv`?"
  92. ### Example Output
  93. **Dataset Overview**
  94. - 5,000 rows × 8 columns
  95. - 3 numeric columns, 1 date column
  96. **Summary Statistics**
  97. - Average order value: $58.2
  98. - Standard deviation: $12.4
  99. - Missing values: 2% (100 cells)
  100. **Insights**
  101. - Sales show upward trend over time
  102. - Peak activity in Q4
  103. *(Attached: trend plot)*
  104. ## Files
  105. - `analyze.py` - Core analysis logic
  106. - `requirements.txt` - Python dependencies
  107. - `resources/sample.csv` - Example dataset for testing
  108. - `resources/README.md` - Additional documentation
  109. ## Notes
  110. - Automatically detects date columns (columns containing 'date' in name)
  111. - Handles missing data gracefully
  112. - Generates visualizations only when date columns are present
  113. - 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)

  1. <div align="center">
  2. [![Join AI Community](https://img.shields.io/badge/🚀_Join-AI_Community_(FREE)-4F46E5?style=for-the-badge)](https://www.skool.com/ai-for-your-business)
  3. [![GitHub Profile](https://img.shields.io/badge/GitHub-@coffeefuelbump-181717?style=for-the-badge&logo=github)](https://github.com/coffeefuelbump)
  4. [![Link Tree](https://img.shields.io/badge/Linktree-Everything-green?style=for-the-badge&logo=linktree&logoColor=white)](https://linktr.ee/corbin_brown)
  5. [![YouTube Membership](https://img.shields.io/badge/YouTube-Become%20a%20Builder-red?style=for-the-badge&logo=youtube&logoColor=white)](https://www.youtube.com/channel/UCJFMlSxcvlZg5yZUYJT0Pug/join)
  6. </div>
  7. ---
  8. # 📊 CSV Data Summarizer - Claude Skill
  9. 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!
  10. <div align="center">
  11. [![Version](https://img.shields.io/badge/version-2.1.0-blue.svg)](https://github.com/coffeefuelbump/csv-data-summarizer-claude-skill)
  12. [![Python](https://img.shields.io/badge/python-3.8+-green.svg)](https://www.python.org/)
  13. [![License](https://img.shields.io/badge/license-MIT-orange.svg)](LICENSE)
  14. </div>
  15. ## 🚀 Features
  16. - **🤖 Intelligent & Adaptive** - Automatically detects data type (sales, customer, financial, survey, etc.) and applies relevant analysis
  17. - **📈 Comprehensive Analysis** - Generates statistics, correlations, distributions, and trends
  18. - **🎨 Auto Visualizations** - Creates multiple charts based on what's in your data:
  19. - Time-series plots for date-based data
  20. - Correlation heatmaps for numeric relationships
  21. - Distribution histograms
  22. - Categorical breakdowns
  23. - **⚡ Proactive** - No questions asked! Just upload CSV and get complete analysis immediately
  24. - **🔍 Data Quality Checks** - Automatically detects and reports missing values
  25. - **📊 Multi-Industry Support** - Adapts to e-commerce, healthcare, finance, operations, surveys, and more
  26. ## 📥 Quick Download
  27. <div align="center">
  28. ### Get Started in 2 Steps
  29. **1️⃣ Download the Skill**
  30. [![Download Skill](https://img.shields.io/badge/Download-CSV%20Data%20Summarizer%20Skill-blue?style=for-the-badge&logo=download)](https://github.com/coffeefuelbump/csv-data-summarizer-claude-skill/raw/main/csv-data-summarizer.zip)
  31. **2️⃣ Try the Demo Data**
  32. [![Download Demo CSV](https://img.shields.io/badge/Download-Sample%20P%26L%20Financial%20Data-green?style=for-the-badge&logo=data)](https://github.com/coffeefuelbump/csv-data-summarizer-claude-skill/raw/main/examples/showcase_financial_pl_data.csv)
  33. </div>
  34. ---
  35. ## 📦 What's Included
  36. ```
  37. csv-data-summarizer-claude-skill/
  38. ├── SKILL.md # Claude Skill definition
  39. ├── analyze.py # Comprehensive analysis engine
  40. ├── requirements.txt # Python dependencies
  41. ├── examples/
  42. │ └── showcase_financial_pl_data.csv # Demo P&L financial dataset (15 months, 25 metrics)
  43. └── resources/
  44. ├── sample.csv # Example dataset
  45. └── README.md # Usage documentation
  46. ```
  47. ## 🎯 How It Works
  48. 1. **Upload** any CSV file to Claude.ai
  49. 2. **Skill activates** automatically when CSV is detected
  50. 3. **Analysis runs** immediately - inspects data structure and adapts
  51. 4. **Results delivered** - Complete analysis with multiple visualizations
  52. No prompting needed. No options to choose. Just instant, comprehensive insights!
  53. ## 📥 Installation
  54. ### For Claude.ai Users
  55. 1. Download the latest release: [`csv-data-summarizer.zip`](https://github.com/coffeefuelbump/csv-data-summarizer-claude-skill/releases)
  56. 2. Go to [Claude.ai](https://claude.ai) → Settings → Capabilities → Skills
  57. 3. Upload the zip file
  58. 4. Enable the skill
  59. 5. Done! Upload any CSV and watch it work ✨
  60. ### For Developers
  61. ```bash
  62. git clone git@github.com:coffeefuelbump/csv-data-summarizer-claude-skill.git
  63. cd csv-data-summarizer-claude-skill
  64. pip install -r requirements.txt
  65. ```
  66. ## 📊 Sample Dataset Highlights
  67. The included demo CSV contains **15 months of P&L data** with:
  68. - 3 product lines (SaaS, Enterprise, Services)
  69. - 25 financial metrics including revenue, expenses, margins, CAC, LTV
  70. - Quarterly trends showing business growth
  71. - Perfect for showcasing time-series analysis, correlations, and financial insights
  72. ## 🎨 Example Use Cases
  73. - **📊 Sales Data** → Revenue trends, product performance, regional analysis
  74. - **👥 Customer Data** → Demographics, segmentation, geographic patterns
  75. - **💰 Financial Data** → Transaction analysis, trend detection, correlations
  76. - **⚙️ Operational Data** → Performance metrics, time-series analysis
  77. - **📋 Survey Data** → Response distributions, cross-tabulations
  78. ## 🛠️ Technical Details
  79. **Dependencies:**
  80. - Python 3.8+
  81. - pandas 2.0+
  82. - matplotlib 3.7+
  83. - seaborn 0.12+
  84. **Visualizations Generated:**
  85. - Time-series trend plots
  86. - Correlation heatmaps
  87. - Distribution histograms
  88. - Categorical bar charts
  89. ## 📝 Example Output
  90. ```
  91. ============================================================
  92. 📊 DATA OVERVIEW
  93. ============================================================
  94. Rows: 100 | Columns: 15
  95. 📋 DATA TYPES:
  96. • order_date: object
  97. • total_revenue: float64
  98. • customer_segment: object
  99. ...
  100. 🔍 DATA QUALITY:
  101. ✓ No missing values - dataset is complete!
  102. 📈 NUMERICAL ANALYSIS:
  103. [Summary statistics for all numeric columns]
  104. 🔗 CORRELATIONS:
  105. [Correlation matrix showing relationships]
  106. 📅 TIME SERIES ANALYSIS:
  107. Date range: 2024-01-05 to 2024-04-11
  108. Span: 97 days
  109. 📊 VISUALIZATIONS CREATED:
  110. ✓ correlation_heatmap.png
  111. ✓ time_series_analysis.png
  112. ✓ distributions.png
  113. ✓ categorical_distributions.png
  114. ```
  115. ## 🌟 Connect & Learn More
  116. <div align="center">
  117. [![Join AI Community](https://img.shields.io/badge/Join-AI%20Community%20(FREE)-blue?style=for-the-badge&logo=data:image/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHdpZHRoPSIyNCIgaGVpZ2h0PSIyNCIgdmlld0JveD0iMCAwIDI0IDI0IiBmaWxsPSJ3aGl0ZSI+PHBhdGggZD0iTTEyIDJDNi40OCAyIDIgNi40OCAyIDEyczQuNDggMTAgMTAgMTAgMTAtNC40OCAxMC0xMFMxNy41MiAyIDEyIDJ6bTAgM2MxLjY2IDAgMyAxLjM0IDMgM3MtMS4zNCAzLTMgMy0zLTEuMzQtMy0zIDEuMzQtMyAzLTN6bTAgMTQuMmMtMi41IDAtNC43MS0xLjI4LTYtMy4yMi4wMy0xLjk5IDQtMy4wOCA2LTMuMDggMS45OSAwIDUuOTcgMS4wOSA2IDMuMDgtMS4yOSAxLjk0LTMuNSAzLjIyLTYgMy4yMnoiLz48L3N2Zz4=)](https://www.skool.com/ai-for-your-business/about)
  118. [![Link Tree](https://img.shields.io/badge/Linktree-Everything-green?style=for-the-badge&logo=linktree&logoColor=white)](https://linktr.ee/corbin_brown)
  119. [![YouTube Membership](https://img.shields.io/badge/YouTube-Become%20a%20Builder-red?style=for-the-badge&logo=youtube&logoColor=white)](https://www.youtube.com/channel/UCJFMlSxcvlZg5yZUYJT0Pug/join)
  120. [![Twitter Follow](https://img.shields.io/badge/Twitter-Follow%20@corbin__braun-1DA1F2?style=for-the-badge&logo=twitter&logoColor=white)](https://twitter.com/corbin_braun)
  121. </div>
  122. ## 🤝 Contributing
  123. Contributions are welcome! Feel free to:
  124. - Report bugs
  125. - Suggest new features
  126. - Submit pull requests
  127. - Share your use cases
  128. ## 📄 License
  129. MIT License - feel free to use this skill for personal or commercial projects!
  130. ## 🙏 Acknowledgments
  131. Built for the Claude Skills platform by [Anthropic](https://www.anthropic.com/news/skills).
  132. ---
  133. <div align="center">
  134. **Made with ❤️ for the AI community**
  135. ⭐ Star this repo if you find it useful!
  136. </div>

Ratings and comments

Sign in to rate this skill.

Sign in

Free to use. If it’s helped, pass it on.