coffeefuelbump avatar

csv-data-summarizer

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

by coffeefuelbump|Open Source
<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 - AI Agent Skill for Claude Code & Cursor | Agent Skills