csv-data-analyst_skill

Overview

This skill analyzes CSV files to produce a complete, automated data summary and visual report. It inspects structure, produces statistical summaries, detects data types and missing values, and generates relevant visualizations. The skill is optimized for immediate, end-to-end analysis whenever a CSV is provided—no follow-up questions required.

How this skill works

The skill loads the CSV into a pandas DataFrame and inspects columns to identify numeric, categorical, and date/time fields. It selects appropriate analyses (time-series, distributions, correlations, category counts) based on detected column types and generates visualizations only where they make sense. Output includes data overview, missing-data diagnostics, key statistics for numeric fields, category breakdowns, and actionable insights tailored to the dataset.

When to use it

• When you upload, attach, or reference a CSV file
• When you ask to summarize or analyze tabular data
• When you want immediate insights into data quality and structure
• When you need visualizations generated automatically
• When you want a full analysis without back-and-forth questions

Best practices

• Provide the CSV file with meaningful column names (dates, amounts, categories) for better automatic detection
• Keep sensitive identifiers removed or anonymized before upload
• Include timezone or date format notes in file when possible to improve time-series accuracy
• Supply a representative sample if the full dataset is extremely large to speed iteration
• Expect numeric, date, and categorical analyses to be produced automatically without additional prompts

Example use cases

• E-commerce sales CSV — automatic revenue trends, product performance, and seasonality charts
• Customer roster CSV — demographic distributions, regional patterns, and churn indicators
• Financial transactions CSV — trend analysis, outlier detection, and correlation heatmap of numeric fields
• Operational logs CSV — timestamp-based performance charts and status distributions
• Survey results CSV — response frequency tables, rating distributions, and cross-tabulations