CSV Data Analysis
5zjk5/prompt-engineering
This skill should be used when users need to analyze CSV or Excel files, understand data patterns, generate statistical summaries, or create data visualizations.
提取指定类别列并统计各类别数量与占比，生成高分辨率的柱状图、饼图等组合可视化报告，适用于分类数据的分布情况分析. An agent skill from MichaelYang-lyx/AIDABench.
Install Category Statistics
$ npx skills add MichaelYang-lyx/AIDABench --skill category-statistics -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install MichaelYang-lyx/AIDABench category-statistics --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/MichaelYang-lyx/AIDABench.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/sn-da-excel-workflow/capability/excel-data-statistics/category-statistics .claude/skills/category-statistics && rm -rf skills-srcUse ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.
Claude Code skills documentation · loads skills from .claude/skills/
Install the "category-statistics" agent skill from https://github.com/MichaelYang-lyx/AIDABench/tree/main/skills/sn-da-excel-workflow/capability/excel-data-statistics/category-statistics into .claude/skills/category-statistics/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "category-statistics", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/MichaelYang-lyx/AIDABench/tree/main/skills/sn-da-excel-workflow/capability/excel-data-statistics/category-statisticsType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add MichaelYang-lyx/AIDABench --skill category-statistics -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install MichaelYang-lyx/AIDABench category-statistics --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/MichaelYang-lyx/AIDABench.git skills-src && mkdir -p .agents/skills && cp -r skills-src/skills/sn-da-excel-workflow/capability/excel-data-statistics/category-statistics .agents/skills/category-statistics && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "category-statistics" agent skill from https://github.com/MichaelYang-lyx/AIDABench/tree/main/skills/sn-da-excel-workflow/capability/excel-data-statistics/category-statistics into .agents/skills/category-statistics/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "category-statistics", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add MichaelYang-lyx/AIDABench --skill category-statistics -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install MichaelYang-lyx/AIDABench category-statistics --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/MichaelYang-lyx/AIDABench.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/skills/sn-da-excel-workflow/capability/excel-data-statistics/category-statistics .cursor/skills/category-statistics && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "category-statistics" agent skill from https://github.com/MichaelYang-lyx/AIDABench/tree/main/skills/sn-da-excel-workflow/capability/excel-data-statistics/category-statistics into .cursor/skills/category-statistics/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "category-statistics", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/MichaelYang-lyx/AIDABench.git --path skills/sn-da-excel-workflow/capability/excel-data-statistics/category-statistics--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add MichaelYang-lyx/AIDABench --skill category-statistics -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install MichaelYang-lyx/AIDABench category-statistics --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/MichaelYang-lyx/AIDABench.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/skills/sn-da-excel-workflow/capability/excel-data-statistics/category-statistics .gemini/skills/category-statistics && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "category-statistics" agent skill from https://github.com/MichaelYang-lyx/AIDABench/tree/main/skills/sn-da-excel-workflow/capability/excel-data-statistics/category-statistics into .gemini/skills/category-statistics/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "category-statistics", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install MichaelYang-lyx/AIDABench category-statisticsInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add MichaelYang-lyx/AIDABench --skill category-statistics -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/MichaelYang-lyx/AIDABench.git skills-src && mkdir -p .github/skills && cp -r skills-src/skills/sn-da-excel-workflow/capability/excel-data-statistics/category-statistics .github/skills/category-statistics && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "category-statistics" agent skill from https://github.com/MichaelYang-lyx/AIDABench/tree/main/skills/sn-da-excel-workflow/capability/excel-data-statistics/category-statistics into .github/skills/category-statistics/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "category-statistics", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add MichaelYang-lyx/AIDABench --skill category-statistics -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install MichaelYang-lyx/AIDABench category-statistics --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/MichaelYang-lyx/AIDABench.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/skills/sn-da-excel-workflow/capability/excel-data-statistics/category-statistics .opencode/skills/category-statistics && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "category-statistics" agent skill from https://github.com/MichaelYang-lyx/AIDABench/tree/main/skills/sn-da-excel-workflow/capability/excel-data-statistics/category-statistics into .opencode/skills/category-statistics/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "category-statistics", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
Facts
- Skill name
category-statistics- GitHub stars
- 111
- Used in
- 1 other repo
- Token cost
- ~1.2k tokens
- SKILL.md length
- 8 words
- Files
- 1
- Skills in repo
- 39
- Repo updated
- First seen
- Licence
- None found
At a glance
提取指定类别列并统计各类别数量与占比，生成高分辨率的柱状图、饼图等组合可视化报告，适用于分类数据的分布情况分析. An agent skill from MichaelYang-lyx/AIDABench.
- Tasks that involve Statistics
- Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md
- Tasks that involve Excel spreadsheets
What it does
Category Statistics is an agent skill from MichaelYang-lyx/AIDABench. 提取指定类别列并统计各类别数量与占比，生成高分辨率的柱状图、饼图等组合可视化报告，适用于分类数据的分布情况分析。
Its SKILL.md is about 1.2k tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.
It sits in Data & Analytics, covering Statistics and Excel spreadsheets. It works with Microsoft Excel. The repository describes itself as: Code for paper AIDABench: AI Data Analytics Benchmark.
When your agent uses it
- Tasks that involve Statistics
- Tasks that involve Excel spreadsheets
Example prompts
- “/category-statistics”
Requirements
- Python 3
What it can do on your machine
Read from SKILL.md and the folder at commit 6dd4206. It shows what the files ask for, not the result of running them.
Tool permissions
Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.
From allowed-tools in the SKILL.md frontmatter.
Runs code
No scripts in the folder and no shell commands in SKILL.md (its code samples are python).
From the folder's file list and the shell code blocks in SKILL.md.
Network
No URLs in SKILL.md.
From URLs in SKILL.md, links to its own repository left out.
Credentials
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Context cost
Category Statistics loads about 1.2k tokens when it runs. Until then it costs about 19 tokens; SKILL.md has 8 words of instructions outside code blocks.
Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.
Safety
Auto-check passed
The automated check found no risky patterns in SKILL.md.
Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.
SKILL.md
Without a licence we can't republish the file, so here is its outline and opening line. It has 8 words (~1,205 tokens).
- name
- category-statistics
Files
Just SKILL.md in skills/sn-da-excel-workflow/capability/excel-data-statistics/category-statistics of MichaelYang-lyx/AIDABench.
Open the folder on GitHubat commit 6dd4206
Used in 1 other repository
We found 1 copy of this SKILL.md (exact, near-identical or edited) in other folders, from 1 other GitHub owner. This page covers the copy in MichaelYang-lyx/AIDABench, which our catalogue first saw on October 7, 2026.
Compare with similar skills
Category Statistics next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Category Statistics this skillMichaelYang-lyx/AIDABench | 111 | 1 repos | ~1.2k | Automated safety check: Pass | None | |
| CSV Data Analysis5zjk5/prompt-engineering | 127 | — | ~2.6k | Automated safety check: Pass | None | |
| Regression Modelerzebbern/claude-code-guide | 4.7k | — | ~909 | Automated safety check: Pass | MIT | |
| Excel and CSV Data Analysisbytedance/deer-flow | 83k | 4 repos | ~2.2k | Automated safety check: Pass | MIT | |
| Research Integrity Auditxuzhougeng/wisp-science | 1k | — | ~2.6k | Automated safety check: Pass | AGPL-3.0 | |
| Raccoon DataanalysisSenseTime-Copilot/raccoon-dataanalysis-skill | 137 | — | ~1.9k | Automated safety check: Pass | None |
Similar skills
Regression Modeler
zebbern/claude-code-guide
Run regression analysis (OLS or logistic) on uploaded CSV/Excel data, generating coefficients, R², p-values, VIF, and plain-language interpretation.
Excel and CSV Data Analysis
bytedance/deer-flow
Analyzes uploaded Excel and CSV files with SQL through DuckDB, producing schema inspections, statistical summaries and exports to CSV, JSON or Markdown.
Research Integrity Audit
xuzhougeng/wisp-science
学术审查 / research-integrity screening of a manuscript's figures and reported numbers.
Raccoon Dataanalysis
SenseTime-Copilot/raccoon-dataanalysis-skill
Raccoon (小浣熊) Data Analysis - Remote code interpreter and data visualization service powered by SenseTime.
Dataset Quality Audit
zebbern/claude-code-guide
Run comprehensive quality checks on tabular data (CSV/Excel/TSV/JSON), detecting missing values, duplicates, outliers, format issues, and type inconsistencies to produce an overall score, grade, and…
More from MichaelYang-lyx/AIDABench
All 39 skills in this repoSn Da Image Caption
MichaelYang-lyx/AIDABench
图片理解与数据提取 skill。当图片文件（.png/.jpg/.jpeg/.gif/.webp/.bmp）是主要输入且用户需要理解、提取数据或分析图片内容时使用。提供预配置的 caption 脚本（scripts/caption.py），通过 vision 模型将图片转为文本描述，无需额外配置 API Key。覆盖：(1) 通过 scripts/caption.py…
Category Filtering And Difficulty Analysis
MichaelYang-lyx/AIDABench
对Excel数据进行自定义分类统计、交叉分析与可视化，并基于多维度指标（如文本长度、术语密度、正则匹配等）进行综合评分与分级，适用于多类别数据分布统计及文本内容难度/质量评估场景。
Excel Bar Chart Visualization
MichaelYang-lyx/AIDABench
读取多工作表Excel文件，自动处理合并单元格与数据清洗，进行交叉分组统计并生成带总计行的结果表，最后绘制支持中英文字体的美化柱状图，适用于多维度数据汇总与可视化分析。
Outlier Detection And Quality Assessment
MichaelYang-lyx/AIDABench
执行全面的异常值检测与数据质量评估，利用 IQR 方法识别异常值并结合偏度、峰度分析数据分布特征，适用于非正态分布数据的预处理阶段。
Sn Da Excel Workflow
MichaelYang-lyx/AIDABench
Excel 数据分析多步编排器。覆盖：(1) 读取多 Sheet Excel 文件并统计行数，(2) 大文件检测（≥10k 行自动 Parquet 优化），(3) 数据清洗（缺失值、文本标准化、无效字符），(4) 条件筛选与分类提取，(5) 跨 Sheet 统计聚合，(6) 导出 Excel/CSV 并提供下载链接。覆盖从数据读取到报告生成全流程，按步骤编排 capability 子…
Sn Da Large File Analysis
MichaelYang-lyx/AIDABench
万行以上 Excel 数据集的高性能分析引擎。提供 openpyxl readonly 流式读取（iterrows 支持 10 万行以上）、Parquet 转换加速、内存优化、分块处理和大文件写入模式。遇到以下任一情况就主动使用本 skill：①数据行数 ≥ 10k（由 sn-da-excel-workflow 的行数评估步骤触发）；②用户出现触发词：大文件 / 大数据量 / 性能优化 /…
Related
Works with
Categories
Questions about Category Statistics
What does Category Statistics do?
提取指定类别列并统计各类别数量与占比，生成高分辨率的柱状图、饼图等组合可视化报告，适用于分类数据的分布情况分析. An agent skill from MichaelYang-lyx/AIDABench. Category Statistics is an agent skill from MichaelYang-lyx/AIDABench.
When should I use Category Statistics?
Category Statistics fits situations like: tasks that involve Statistics; tasks that involve Excel spreadsheets.
How do I install Category Statistics in Claude Code?
Run `npx skills add MichaelYang-lyx/AIDABench --skill category-statistics -a claude-code`. Or copy the skill folder (skills/sn-da-excel-workflow/capability/excel-data-statistics/category-statistics in MichaelYang-lyx/AIDABench) into .claude/skills/category-statistics in your project. Claude Code loads it when a task matches its description.
How do I install Category Statistics in Codex?
Run `npx skills add MichaelYang-lyx/AIDABench --skill category-statistics -a codex`. Or copy the skill folder (skills/sn-da-excel-workflow/capability/excel-data-statistics/category-statistics in MichaelYang-lyx/AIDABench) into .agents/skills/category-statistics in your project. Codex loads it when a task matches its description.
Can I use Category Statistics in Cursor, Gemini CLI or GitHub Copilot?
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add MichaelYang-lyx/AIDABench --skill category-statistics -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/category-statistics, .gemini/skills/category-statistics, .github/skills/category-statistics and .opencode/skills/category-statistics in your project.
What does Category Statistics need to run?
SKILL.md names no scripts, command-line tools or credentials: Category Statistics is instructions for the agent only. Our summary lists: Python 3.
Does Category Statistics access the network?
SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.
Is Category Statistics safe to install?
Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.
What licence does Category Statistics use?
No licence was found for Category Statistics or its repository. Without one, default copyright applies: ask the author before reusing or redistributing it.
How many tokens does Category Statistics use?
About 1.2k tokens (SKILL.md is roughly 4.8k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.
What are the alternatives to Category Statistics?
Skills that share tags, products or a category with Category Statistics: CSV Data Analysis (5zjk5/prompt-engineering, 127 stars), Regression Modeler (zebbern/claude-code-guide, 4.7k stars), Excel and CSV Data Analysis (bytedance/deer-flow, 83k stars) and Research Integrity Audit (xuzhougeng/wisp-science, 1k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Who maintains Category Statistics?
MichaelYang-lyx (a GitHub user) maintains it in MichaelYang-lyx/AIDABench, which has 111 GitHub stars. The repository holds 39 skills in this directory. The repository was last updated on September 28, 2026.
Source: MichaelYang-lyx/AIDABench on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.