data-analysis

Analyze tabular files with iterative Python code using pandas and matplotlib.

348|33|Updated Feb 3, 2026
One-click install
npx skills add https://github.com/opencmit/alphora --skill data-analysis-opencmit
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: data-analysis
Source: https://github.com/opencmit/alphora/tree/main/examples/chat_excel/skills/data-analysis
Command: npx skills add https://github.com/opencmit/alphora --skill data-analysis-opencmit

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, openpyxl, matplotlib, and includes scripts (resource) and references (resource) components.

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'.

Frequently Asked Questions about data-analysis

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I analyze tabular data from CSV and Excel files using pandas?

To analyze tabular data from CSV and Excel files, this Skill uses pandas to perform an iterative, multi-turn data probing workflow, ensuring you explore the dataset thoroughly before generating step-by-step Python code for aggregation and visualization.

Can I generate data visualizations directly from an Excel file?

Yes, you can generate data visualizations directly from an Excel file. This Skill uses matplotlib to create various chart types like bar, line, and scatter plots with proper labeling, while pandas handles the underlying data manipulation and cleaning.

What is the best way to clean and aggregate raw JSON or TSV data?

The best way to clean and aggregate raw JSON or TSV data is through a structured, step-by-step approach. This Skill enforces a human-like analyst workflow, preventing large code blocks at once to ensure missing values and type conversions are handled accurately.

Does this data analysis approach support iterative coding for step-by-step exploration?

Yes, this data analysis approach strictly supports iterative coding for step-by-step exploration. It enforces rules against skipping data exploration and writing large code blocks at once, ensuring all conclusions are evidence-based through multi-turn data probing.

Why should I not skip data exploration before writing Python scripts for analysis?

You should not skip data exploration because this Skill enforces a human-like data analyst workflow that requires multi-turn data probing before coding. Skipping exploration leads to uninformed scripts, whereas this method ensures high-quality, evidence-based outputs.