data-analysis
/data-analysis
Loads CSV, Excel, and JSON data files, performs statistical analysis, and generates charts and reports. Use when the user asks to analyze a dataset, compute statistics, create visualizations, find trends, or produce a data report.
- Author
- 0xranx ↗
- Repository
- golembot ↗
- Licence
- MIT
- Last repository change
- 25.10.2026
Assessment and security
- Files in this package
- 2
- Scripts
- 1
- HTML comments
- 0
- URLs in SKILL.md
- 0
No signals detected. Repository changed on 25.10.2026, without references to retired models or APIs.
MIT, open: use and modify while retaining author attribution.
- 1 scripts in this package. Review them before installing, as Claude may execute them.
Scripts: calc.py
What it does and when to use it
Loads CSV, Excel, and JSON data files, performs statistical analysis, and generates charts and reports. Use when the user asks to analyze a dataset, compute statistics, create visualizations, find trends, or produce a data report.
Original author description
Loads CSV, Excel, and JSON data files, performs statistical analysis, and generates charts and reports. Use when the user asks to analyze a dataset, compute statistics, create visualizations, find trends, or produce a data report.
How it works
- Step-by-Step Workflow
- Validation Checkpoints
- Using calc.py
- Output Format
SKILL.md preview
---
name: data-analysis
description: "Loads CSV, Excel, and JSON data files, performs statistical analysis, and generates charts and reports. Use when the user asks to analyze a dataset, compute statistics, create visualizations, find trends, or produce a data report."
---
# Data Analysis Skill
Process data files in the `data/` directory, perform analysis, and output reports to `reports/`.
## Step-by-Step Workflow
1. **Identify the data source** — List available files and confirm with the user which to analyze:
```bash
ls data/
```
2. **Load and inspect the data** — Use Python to read the file and show a summary:
```python
import pandas as pd
df = pd.read_csv("data/sales.csv") # or read_excel / read_json
print(f"Shape: {df.shape}")
print(f"Columns: {list(df.columns)}")
print(df.dtypes)
print(df.describe())
print(f"Missing values:\n{df.isnull().sum()}")
```
3. **Clean the data** — Handle missing values, fix types, remove duplicates:
```python
df = df.drop_duplicates()
df["date"] = pd.to_datetime(df["date"], errors="coerce")
df["amount"] = pd.to_numeric(df["amount"], errors="coerce")
df = df.dropna(subset=["date", "amount"])
print(f"Clean shape: {df.shape}")
```
4. **Analyze** — Compute the requested statistics or aggregations:
```python
# Example: monthly revenue trend
monthly = df.groupby(df["date"].dt.to_period("M"))["amount"].sum()
print(monthly)
# Example: correlation matrix
print(df[["amount", "quantity", "discount"]].corr())
```
5. **Visualize** — Generate charts and save to `reports/`:
```python
import matplotlib
matplotlib.use("Agg")
import matplotlib.pyplot as plt
monthly.plot(kind="bar", title="Monthly Revenue")
plt.tight_layout()
plt.savefig("reports/monthly_revenue.png", dpi=150)
plt.close()
print("Chart saved to reports/monthly_revenue.png")
```
6. **Write the report** — Save a Markdown report to `reports/`:
```python
with open("reports/analysis_report.md", "w") as f:
f.write("# Analysis Report\n\n")
f.write("## Summary\n")
f.write(f"- Total records: {len(df)}\n")
f.write(f"- Date range: {df['date'].min()} to {df['date'].max()}\n")
f.write(f"- Total revenue: {df['amount'].sum():,.2f}\n\n")
f.write("## Charts\n")
f.write("\n")
print("Report saved to reports/analysis_report.md")
```
## Validation Checkpoints
After each step, verify before proceeding:
- After loading: confirm row count and column names are plausible
- After cleaning: check that no critical data was dropped unexpectedly (compare row counts)
- After analysis: sanity-check totals and aggregations (e.g., no negative counts)
- After saving: confirm output files exist with `ls reports/`
## Using calc.py
For complex or specialized calculations, use the `calc.py` helper script:
```bash
python calc.py --input data/sales.csv --operation regression --output reports/regression.json
```
## Output Format
Analysis reports should follow this structure:
```
# [Analysis Topic] Report
## Summary
- Key finding 1
- Key finding 2
## Data Overview
- Records: N rows
- Time range: ...
## Detailed Analysis
...
## Recommendations
...
```
Files in this package (2)
- SKILL.md 3 KB
- calc.py 2 KB
Versions
| Repository | Score | Licence |
|---|---|---|
| This page · 0xranx/golembot | 98 | MIT |
| DomynAI/domyn-agents | 100 | Apache-2.0 |
| bytedance/deer-flow | 100 | MIT |
| quantummetric/qm-plugin-skills | 100 | MIT |
| Sellyew/Workbuddy-workflow | 100 | MIT |
| DougTrajano/pydantic-ai-skills | 100 | MIT |
| microclaw/microclaw | 100 | MIT |
| lynricsy/hyperskills | 100 | MIT |
| DvJ4Y/shipwright | 100 | MIT |
Database snapshot: 13.11.2026 · package version 0f4dde304558 (SHA-256 digest of the entire package)
Downloads in the last 30 days: 0 · ranking
Report a problem with this skill: harmful content, incorrect descriptions or an author’s removal request.
Similar skills
- 100csv-data-analysis
This skill should be used when users need to analyze CSV or Excel files, understand data patterns, generate statistical summaries, or create data visualizations. Trigger keywords include "analyze CSV", "analyze Excel", "data analysis", "CSV analysis", "Excel analysis", "data… - 90data-analysis-report
Analyse a dataset (CSV, JSON or query output) and write a reproducible report - data checks, descriptive statistics, the analysis that answers the question, charts and caveats. Use when asked to analyse, explore or explain data. - 100data-analyst
Cleans, analyzes and visualizes data from CSV, Excel or JSON files and explains the findings in plain language. Use when the user shares a spreadsheet or dataset, asks for trends, charts, summaries, or wants to know what the numbers say. - 100data-analyst
Use when analysing data files (CSV, JSON, Excel), writing SQL queries, identifying trends and patterns, building dashboards or charts, summarising metrics, validating data quality, or turning raw data into actionable insights for decision-making. - 100spreadsheet-ops
Spreadsheet processing and analysis for CSV/Excel; trigger when users ask to merge/clean tabular data, run statistics, add/edit Excel formulas, apply formatting, generate charts, or force workbook recalculation. - 86data-analyst
当用户要在内存中对 CSV / JSON / Excel 做数据加载、清洗、统计分析、假设检验、图表可视化或数据质量检查时使用。