csv-data-summarizer

What it does

This skill analyzes data contained within Comma Separated Value (CSV) files. It leverages Python's pandas library to calculate descriptive statistics like mean, median, standard deviation, and minimum/maximum values for numerical columns. Furthermore, the skill can generate basic visualizations such as histograms or scatter plots based on the CSV data provided.

When to use it

• Quick Data Exploration: You have a newly acquired dataset in CSV format and need a rapid understanding of its key characteristics.
• Identifying Outliers: Determine if there are any unusual values within your data that require further investigation.
• Generating Reports: Create concise summaries of numerical data to include in reports or presentations.
• Data Quality Checks: Assess the distribution and range of values to identify potential errors or inconsistencies in a dataset.

Key capabilities

• Calculates descriptive statistics (mean, median, standard deviation, min/max)
• Generates histograms for numerical columns
• Creates scatter plots based on two selected columns
• Uses Python and pandas library for analysis

Example prompts

• "Summarize the data in 'sales_data.csv' and show me a histogram of the 'revenue' column."
• "Calculate the mean, median, and standard deviation for all numerical columns in 'customer_data.csv'."
• "Create a scatter plot showing the relationship between 'advertising_spend' and 'website_visits' from 'marketing_campaigns.csv'."

Tips & gotchas

• The skill requires access to the CSV file, either through direct upload or a publicly accessible URL.
• Ensure your CSV file is properly formatted with clear headers for each column; otherwise, the analysis may be inaccurate.