csv-data-summarizer_skill

Overview

This skill analyzes CSV files and generates a full set of summary statistics and visualizations automatically. I'll analyze this data comprehensively right now and return a complete, ready-to-read report without asking the user for direction. The output combines data structure inspection, quality checks, statistical summaries, and context-aware plots.

How this skill works

The skill reads the CSV into a pandas DataFrame and inspects column types, missing values, and date formats. It selects relevant analyses — numeric summaries, categorical distributions, time-series plots, correlation matrices, and data quality diagnostics — and generates visualizations with matplotlib/seaborn. All applicable plots are created automatically and included alongside textual summaries and key metrics.

When to use it

• User uploads or references a CSV and wants an immediate full analysis.
• You need a quick snapshot of dataset structure, quality, and key statistics.
• Exploring unfamiliar tabular data before modeling or visualization work.
• Validating data cleanliness, missingness, or unexpected value ranges.

Best practices

• Provide the CSV with clear headers and consistent encoding (UTF-8 preferred).
• Ensure date/time columns are in a parseable format for time-series detection.
• For large files, consider sampling or using a smaller representative CSV to speed analysis.
• Keep categorical labels consistent to produce meaningful distribution plots.
• Review generated diagnostics and use them to guide downstream cleaning or modeling.

Example use cases

• A data analyst uploads sales.csv to get automated summaries, revenue trends, and customer segment distributions.
• A product manager drops in event logs to receive immediate time-series activity charts and anomaly highlights.
• A researcher provides experiment_results.csv to obtain descriptive statistics, missing-data reports, and correlation heatmaps.
• A QA engineer scans exported system metrics CSV to surface unexpected value ranges and data-quality issues.