coffeefuelbump avatar

csv-data-summarizer

Analyzes CSV files, generates summary stats, and plots quick visualizations using Python and pandas.

提供方 coffeefuelbump|开源
<div align="center">

Join AI Community GitHub Profile

Link Tree YouTube Membership

</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">

Version Python 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
Download Skill

2️⃣ Try the Demo Data
Download Demo 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
  2. Go to 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

📊 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">

Join AI Community

Link Tree

YouTube Membership

Twitter Follow

</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.


<div align="center">

Made with ❤️ for the AI community

⭐ Star this repo if you find it useful!

</div>
csv-data-summarizer - 适用于 Claude Code 与 Cursor 的 AI 智能体 Skill | Agent Skills