What problem does it solve?
This Skill automates the process of analyzing, cleaning, aggregating, and visualizing data from tabular files like CSV, Excel, and JSON, transforming raw data into actionable insights.
Core Features & Use Cases
- Iterative Data Exploration: Guides users through a multi-turn process of probing data before coding.
- Robust Scripting: Utilizes Python with pandas and matplotlib for data manipulation and visualization.
- Data Cleaning & Transformation: Handles missing values, type conversions, and data standardization.
- Visualization: Generates various chart types (bar, line, scatter, etc.) with proper labeling and formatting.
- Use Case: Analyze monthly sales data from an Excel file to identify top-performing regions, generate a bar chart of regional sales, and save the summarized data to a new CSV file.
Quick Start
Use the data-analysis skill to inspect the structure of the file 'sales_data.xlsx'.