Agent skill

CSV Data Analysis

by 5zjk5 in 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.

No licenceAuto-check passedData & Analytics

Install CSV Data Analysis

skills CLI
$ npx skills add 5zjk5/prompt-engineering --skill csv-data-analysis -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install 5zjk5/prompt-engineering csv-data-analysis --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/5zjk5/prompt-engineering.git skills-src && mkdir -p .claude/skills && cp -r skills-src/Agent/ChatExcel/backend/skills/csv-data-analysis .claude/skills/csv-data-analysis && rm -rf skills-src

Use ~/.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/

Facts

Skill name
csv-data-analysis
GitHub stars
127
Token cost
~2.6k tokens
SKILL.md length
1,048 words
Files
5 (incl. scripts, references)
Skills in repo
5
Repo updated
First seen
Licence
None found

At a glance

This skill should be used when users need to analyze CSV or Excel files, understand data patterns, generate statistical summaries, or create data visualizations.

  • Works in 2 steps: Extract Data Features (Execute Script) → Generate Insights & Display Report…
  • Keywords include analyze CSV
  • SKILL.md covers Core Workflow (Required…, Placeholder Reference (9…, Why Choose This Tool? and File Structure
  • Runs Python scripts from its folder

What it does

CSV Data Analysis is an agent skill from 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. Trigger keywords include "analyze CSV", "analyze Excel", "data analysis", "CSV analysis", "Excel analysis", "data statistics", "generate charts", "data visualization", "分析CSV", "分析Excel", "数据分析", "CSV分析", "Excel分析", "数据统计", "生成图表", "数据可视化".

Its SKILL.md is about 2.6k tokens, which your agent loads only when the skill is triggered. The skill folder holds 7 other files, including scripts and reference files (for example `references/reference.md`, `scripts/csv_analyzer.py` and `scripts/example.py`).

It sits in Data & Analytics, covering CSV and tabular files, Data analysis and Excel spreadsheets. It works with Microsoft Excel.

When your agent uses it

  • Keywords include analyze CSV
  • Data statistics
  • Generate charts
  • Data visualization

Example prompts

  • “analyze CSV”
  • “analyze Excel”
  • “data analysis”
  • “/csv-data-analysis”

Requirements

  • Python 3

Workflow steps

2 steps, taken from the step headings in SKILL.md.

  1. Extract Data Features (Execute Script)
  2. Generate Insights & Display Report (Inject into Template)

What it can do on your machine

Read from SKILL.md and the folder at commit e563dd1. 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

    Ships 2 files in scripts/ (Python), which the agent can run.

    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

CSV Data Analysis loads about 2.6k tokens when it runs, and up to ~2.7k if it reads all its reference files. Until then it costs about 105 tokens; SKILL.md has 1,048 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~105
When it runs · the whole SKILL.md, loaded when a task matches
~2.6k
With references · SKILL.md plus every file in references/, read only if the agent opens them
~2.7k

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); the scripts in this folder are not scanned.

SKILL.md

Without a licence we can't republish the file, so here is its outline and opening line. It has 1,048 words (~2,600 tokens).

“The Data Analysis Tool is an AI-powered deep automated data exploration tool built on frontend visualization technologies (ECharts + Tailwind CSS). It rapidly extracts statistical features, data quality metrics, numerical distributions, outlier detection, categorical information, correlations, rankings, and time series…”

— opening of SKILL.md by 5zjk5
name
csv-data-analysis

Read the full SKILL.md on GitHub

Files

SKILL.md and 4 other files (scripts, references) in Agent/ChatExcel/backend/skills/csv-data-analysis of 5zjk5/prompt-engineering.

  • SKILL.md
  • references/reference.md
  • scripts/csv_analyzer.py
  • scripts/example.py
  • templates/report_template.html

Open the folder on GitHubat commit e563dd1

Compare with similar skills

CSV Data Analysis 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.

CSV Data Analysis compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
CSV Data Analysis this skill5zjk5/prompt-engineering127—~2.6kAutomated safety check: PassNone
Raccoon DataanalysisSenseTime-Copilot/raccoon-dataanalysis-skill137—~1.9kAutomated safety check: PassNone
Pie Chart Data AnalysisMichaelYang-lyx/AIDABench1111 repos~964Automated safety check: PassNone
Research Data Auto Analysis PlottingDrchronx/ai-agent-research-starter-kit135—~463Automated safety check: PassCustom licence
Excel and CSV Data Analysisbytedance/deer-flow83k4 repos~2.2kAutomated safety check: PassMIT
Regression Modelerzebbern/claude-code-guide4.7k—~909Automated safety check: PassMIT

Similar skills

  • Raccoon Dataanalysis

    SenseTime-Copilot/raccoon-dataanalysis-skill

    Raccoon (小浣熊) Data Analysis - Remote code interpreter and data visualization service powered by SenseTime.

    137 GitHub stars~1.9k tokensUpdated 6 mo ago
    Data & AnalyticsAuto-check passed
  • Pie Chart Data Analysis

    MichaelYang-lyx/AIDABench

    对多Sheet Excel或CSV数据进行分类汇总统计,自动识别关键字段并生成包含占比、数值及美化饼图的可下载分析报告。

    111 GitHub starsUsed in 1 repo~964 tokens
    Documents & OfficeAuto-check passed
  • Research Data Auto Analysis Plotting

    Drchronx/ai-agent-research-starter-kit

    Automatically analyze research datasets and generate publication-ready statistical tables, correlation figures, grouped comparison plots, and regression diagnostics.

    135 GitHub stars~463 tokensUpdated 4 mo ago
    Documents & OfficeAuto-check passed
  • 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.

    83k GitHub starsUsed in 4 repos~2.2k tokens
    Data & AnalyticsAuto-check passed
  • 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.

    4.7k GitHub stars~909 tokensUpdated today
    Data & AnalyticsAuto-check passed
  • Data Analysis Router

    franklee16/academic-research-skills

    Multi-domain data analysis router for uploaded datasets, spreadsheets, CSV/XLSX files, business metric tables, or user questions that require selecting the right business analysis framework before…

    223 GitHub stars~1k tokensUpdated 20 days ago
    Data & AnalyticsAuto-check passed

More from 5zjk5/prompt-engineering

  • Byteplus Edge Pages Deploy

    5zjk5/prompt-engineering

    Deploy static websites to BytePlus Edge Pages with CDN. An agent skill from 5zjk5/prompt-engineering.

    127 GitHub stars~3.9k tokensUpdated 23 days ago
    Auto-check passed
  • Fastapi Backend Scaffold

    5zjk5/prompt-engineering

    生成标准 FastAPI 后端分层架构目录脚手架。当用户需要从零搭建 FastAPI 后端、重构后端目录结构、或创建新的后端项目时触发此技能。技能内置 LLM 多模型客户端(支持重试、流式、备用切换)、会话级日志、SQLite 数据访问层、SSE 流式 API 示例等生产级模板代码,一键生成完整可运行的后端骨架。触发场景包括"搭建后端"、"创建 FastAPI…

    127 GitHub stars~1.3k tokensUpdated 23 days ago
    Auto-check: notes
  • Langchain Langgraph Coding Assistant

    5zjk5/prompt-engineering

    当用户需要编写LangChain或LangGraph相关代码时,提供基于示例代码的编码辅助,包括RAG、Agent、工作流、工具定义、中间件等多种功能模块的实现指导。

    127 GitHub starsUsed in 1 repo~1.8k tokens
    Auto-check passed
  • Project Analyzer

    5zjk5/prompt-engineering

    代码仓库梳理与项目文档生成技能。当用户明确要求梳理项目或使用项目梳理功能时触发此技能。典型触发场景包括"帮我梳理这个项目"、"梳理一下这个代码仓"、"使用项目梳理"等。此技能读取项目代码仓,按照结构化模板生成完整的项目梳理 Markdown 文档。

    127 GitHub stars~1.3k tokensUpdated 23 days ago
    Auto-check: notes

Works with

Questions about CSV Data Analysis

What does CSV Data Analysis do?

This skill should be used when users need to analyze CSV or Excel files, understand data patterns, generate statistical summaries, or create data visualizations. CSV Data Analysis is an agent skill from 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.

When should I use CSV Data Analysis?

CSV Data Analysis fits situations like: keywords include analyze CSV; data statistics; generate charts; data visualization.

How do I install CSV Data Analysis in Claude Code?

Run `npx skills add 5zjk5/prompt-engineering --skill csv-data-analysis -a claude-code`. Or copy the skill folder (Agent/ChatExcel/backend/skills/csv-data-analysis in 5zjk5/prompt-engineering) into .claude/skills/csv-data-analysis in your project. Claude Code loads it when a task matches its description.

How do I install CSV Data Analysis in Codex?

Run `npx skills add 5zjk5/prompt-engineering --skill csv-data-analysis -a codex`. Or copy the skill folder (Agent/ChatExcel/backend/skills/csv-data-analysis in 5zjk5/prompt-engineering) into .agents/skills/csv-data-analysis in your project. Codex loads it when a task matches its description.

Can I use CSV Data Analysis 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 5zjk5/prompt-engineering --skill csv-data-analysis -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/csv-data-analysis, .gemini/skills/csv-data-analysis, .github/skills/csv-data-analysis and .opencode/skills/csv-data-analysis in your project.

What does CSV Data Analysis need to run?

Going by SKILL.md and its folder, CSV Data Analysis needs Python for the scripts in its folder. Our summary lists: Python 3.

Does CSV Data Analysis 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 CSV Data Analysis 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. The check reads SKILL.md only: the scripts in the folder are not scanned, so read them before running anything.

What licence does CSV Data Analysis use?

No licence was found for CSV Data Analysis or its repository. Without one, default copyright applies: ask the author before reusing or redistributing it.

How many tokens does CSV Data Analysis use?

About 2.6k tokens (SKILL.md is roughly 10k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full. Its references folder adds about 72 tokens, read only when the agent opens those files.

What are the alternatives to CSV Data Analysis?

Skills that share tags, products or a category with CSV Data Analysis: Raccoon Dataanalysis (SenseTime-Copilot/raccoon-dataanalysis-skill, 137 stars), Pie Chart Data Analysis (MichaelYang-lyx/AIDABench, 111 stars), Research Data Auto Analysis Plotting (Drchronx/ai-agent-research-starter-kit, 135 stars) and Excel and CSV Data Analysis (bytedance/deer-flow, 83k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains CSV Data Analysis?

5zjk5 (a GitHub user) maintains it in 5zjk5/prompt-engineering, which has 127 GitHub stars. The repository holds 5 skills in this directory. The repository was last updated on September 15, 2026.

Source: 5zjk5/prompt-engineering on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.