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.
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…
Install Data Analysis Router
$ npx skills add franklee16/academic-research-skills --skill data-analysis-router -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install franklee16/academic-research-skills data-analysis-router --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/franklee16/academic-research-skills.git skills-src && mkdir -p .claude/skills && cp -r skills-src/data-analysis/data-analysis-router-main .claude/skills/data-analysis-router && 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 "data-analysis-router" agent skill from https://github.com/franklee16/academic-research-skills/tree/master/data-analysis/data-analysis-router-main into .claude/skills/data-analysis-router/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "data-analysis-router", 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/franklee16/academic-research-skills/tree/master/data-analysis/data-analysis-router-mainType 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 franklee16/academic-research-skills --skill data-analysis-router -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install franklee16/academic-research-skills data-analysis-router --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/franklee16/academic-research-skills.git skills-src && mkdir -p .agents/skills && cp -r skills-src/data-analysis/data-analysis-router-main .agents/skills/data-analysis-router && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "data-analysis-router" agent skill from https://github.com/franklee16/academic-research-skills/tree/master/data-analysis/data-analysis-router-main into .agents/skills/data-analysis-router/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "data-analysis-router", 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 franklee16/academic-research-skills --skill data-analysis-router -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install franklee16/academic-research-skills data-analysis-router --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/franklee16/academic-research-skills.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/data-analysis/data-analysis-router-main .cursor/skills/data-analysis-router && 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 "data-analysis-router" agent skill from https://github.com/franklee16/academic-research-skills/tree/master/data-analysis/data-analysis-router-main into .cursor/skills/data-analysis-router/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "data-analysis-router", 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/franklee16/academic-research-skills.git --path data-analysis/data-analysis-router-main--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 franklee16/academic-research-skills --skill data-analysis-router -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install franklee16/academic-research-skills data-analysis-router --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/franklee16/academic-research-skills.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/data-analysis/data-analysis-router-main .gemini/skills/data-analysis-router && 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 "data-analysis-router" agent skill from https://github.com/franklee16/academic-research-skills/tree/master/data-analysis/data-analysis-router-main into .gemini/skills/data-analysis-router/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "data-analysis-router", 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 franklee16/academic-research-skills data-analysis-routerInstalls 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 franklee16/academic-research-skills --skill data-analysis-router -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/franklee16/academic-research-skills.git skills-src && mkdir -p .github/skills && cp -r skills-src/data-analysis/data-analysis-router-main .github/skills/data-analysis-router && 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 "data-analysis-router" agent skill from https://github.com/franklee16/academic-research-skills/tree/master/data-analysis/data-analysis-router-main into .github/skills/data-analysis-router/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "data-analysis-router", 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 franklee16/academic-research-skills --skill data-analysis-router -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install franklee16/academic-research-skills data-analysis-router --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/franklee16/academic-research-skills.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/data-analysis/data-analysis-router-main .opencode/skills/data-analysis-router && 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 "data-analysis-router" agent skill from https://github.com/franklee16/academic-research-skills/tree/master/data-analysis/data-analysis-router-main into .opencode/skills/data-analysis-router/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "data-analysis-router", 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
data-analysis-router- GitHub stars
- 223
- Token cost
- ~1k tokens
- SKILL.md length
- 444 words
- Files
- 13 (incl. scripts, references)
- Skills in repo
- 1,616
- Repo updated
- First seen
- Licence
- None found
At a glance
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…
- Works in 7 steps: Inspect the user request, attached… → If a dataset is available and profiling… → Read references/routing-rules.md to… → …
- Codex needs to inspect data fields
- SKILL.md covers Overview, Workflow, Dataset Profiling and Reference Selection, plus 2 more sections
- Runs Python scripts from its folder; calls python3
What it does
Data Analysis Router is an agent skill from 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 producing insights, charts, recommendations, or a structured report. Use when Codex needs to inspect data fields, infer the business domain, profile one or more tables, choose among ecommerce, content operation, advertising, store operation, finance, user feedback, or general analysis frameworks, and explain the…
Its SKILL.md is about 1k tokens, which your agent loads only when the skill is triggered. The skill folder holds 15 other files, including scripts and reference files (for example `README.md`, `agents/openai.yaml` and `references/advertising.md`).
It sits in Data & Analytics, covering Data analysis, Excel spreadsheets and E-commerce operations. It works with Microsoft Excel. The repository describes itself as: Comprehensive collection of Claude Code skills for academic research in economics, finance, and social sciences.
When your agent uses it
- Codex needs to inspect data fields
- Infer the business domain
- Choose among ecommerce
- Content operation
Example prompts
- “/data-analysis-router”
Requirements
- Python 3
Workflow steps
7 steps, taken from the first numbered list in SKILL.md.
- Inspect the user request, attached files, filenames, sheet names, field names, and visible sample rows.
- If a dataset is available and profiling would help, run scripts/profile_dataset.py on all relevant .csv and .xlsx files.
- Read references/routing-rules.md to choose the likely domain.
- If one domain clearly matches, read only that domain reference plus references/report-format.md.
- If multiple domains plausibly match, state the ambiguity, read the relevant domain references, and combine the frameworks.
- If no domain is clear, read references/general-analysis.md and references/report-format.md.
- Produce a structured report with domain judgment, evidence, metrics, findings, chart suggestions, action recommendations, and missing data.
What it can do on your machine
Read from SKILL.md and the folder at commit 9a4b2db. 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 1 file in scripts/ (Python), which the agent can run.
Shell commands in SKILL.md call:
python3
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
Data Analysis Router loads about 1k tokens when it runs, and up to ~5.9k if it reads all its reference files. Until then it costs about 143 tokens; SKILL.md has 444 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); 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 444 words (~1,040 tokens).
“Use this skill to analyze business data by first identifying the likely domain, then applying the matching framework. Prefer explicit domain reasoning over jumping straight into calculations.”
- name
- data-analysis-router
Files
SKILL.md and 12 other files (scripts, references) in data-analysis/data-analysis-router-main of franklee16/academic-research-skills.
- SKILL.md
- README.md
- agents/openai.yaml
- references/advertising.md
- references/content-operation.md
- references/ecommerce.md
- references/finance.md
- references/general-analysis.md
- references/report-format.md
- references/routing-rules.md
- references/store-operation.md
- references/user-feedback.md
- scripts/profile_dataset.py
Open the folder on GitHubat commit 9a4b2db
Compare with similar skills
Data Analysis Router 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 |
|---|---|---|---|---|---|---|
| Data Analysis Router this skillfranklee16/academic-research-skills | 223 | — | ~1k | Automated safety check: Pass | None | |
| Excel and CSV Data Analysisbytedance/deer-flow | 83k | 4 repos | ~2.2k | Automated safety check: Pass | MIT | |
| Raccoon DataanalysisSenseTime-Copilot/raccoon-dataanalysis-skill | 137 | — | ~1.9k | Automated safety check: Pass | None | |
| CSV Data Analysis5zjk5/prompt-engineering | 127 | — | ~2.6k | Automated safety check: Pass | None | |
| Exploring Dataoaustegard/claude-skills | 150 | — | ~1.7k | Automated safety check: Pass | MIT | |
| Pie Chart Data AnalysisMichaelYang-lyx/AIDABench | 111 | 1 repos | ~964 | Automated safety check: Pass | None |
Similar skills
Raccoon Dataanalysis
SenseTime-Copilot/raccoon-dataanalysis-skill
Raccoon (小浣熊) Data Analysis - Remote code interpreter and data visualization service powered by SenseTime.
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.
Exploring Data
oaustegard/claude-skills
Exploratory data analysis. An agent skill from oaustegard/claude-skills.
Pie Chart Data Analysis
MichaelYang-lyx/AIDABench
对多Sheet Excel或CSV数据进行分类汇总统计，自动识别关键字段并生成包含占比、数值及美化饼图的可下载分析报告。
Codebook
brycewang-stanford/Auto-Empirical-Research-Skills
Auto-generates a Markdown codebook from a dataset (CSV, DTA, Excel, Parquet) with types and summary statistics.
More from franklee16/academic-research-skills
All 1,616 skills in this repoEconometric Research Writing
franklee16/academic-research-skills
End-to-end econometric analysis and economics/management paper-writing workflow.
Paper Revision
franklee16/academic-research-skills
Comprehensive workflow for handling journal Revise and Resubmit (R&R) decisions.
Sci Ssci Polishing
franklee16/academic-research-skills
A skill your agent uses when researchers need Chinese academic prose translated into publication-oriented English or English manuscript paragraphs and complete sections polished for SCI, SSCI, or…
Research Defense Radar
franklee16/academic-research-skills
Assess and monitor an ongoing research project's competitor landscape, novelty risk, and method/data opportunities from a proposal, paper, research question, data or method notes, or a suspected…
Academic Grant
franklee16/academic-research-skills
Generate or fill in academic grant application forms (project statement, education plan, pathway to impact, references) using draft research material.
Chinese Reference Formatter Skill
franklee16/academic-research-skills
A skill your agent uses when a user needs通用中文参考文献、GB/T 7714-style bibliography entries, Chinese academic reference formatting, or BibTeX completion from Chinese or English literature titles…
Related
Works with
Categories
Questions about Data Analysis Router
What does Data Analysis Router do?
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…. Data Analysis Router is an agent skill from 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 producing insights, charts, recommendations, or a structured report.
When should I use Data Analysis Router?
Data Analysis Router fits situations like: Codex needs to inspect data fields; infer the business domain; choose among ecommerce; content operation.
How do I install Data Analysis Router in Claude Code?
Run `npx skills add franklee16/academic-research-skills --skill data-analysis-router -a claude-code`. Or copy the skill folder (data-analysis/data-analysis-router-main in franklee16/academic-research-skills) into .claude/skills/data-analysis-router in your project. Claude Code loads it when a task matches its description.
How do I install Data Analysis Router in Codex?
Run `npx skills add franklee16/academic-research-skills --skill data-analysis-router -a codex`. Or copy the skill folder (data-analysis/data-analysis-router-main in franklee16/academic-research-skills) into .agents/skills/data-analysis-router in your project. Codex loads it when a task matches its description.
Can I use Data Analysis Router 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 franklee16/academic-research-skills --skill data-analysis-router -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/data-analysis-router, .gemini/skills/data-analysis-router, .github/skills/data-analysis-router and .opencode/skills/data-analysis-router in your project.
What does Data Analysis Router need to run?
Going by SKILL.md and its folder, Data Analysis Router needs Python for the scripts in its folder and the command-line tools its instructions call (python3). Our summary lists: Python 3.
Does Data Analysis Router 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 Data Analysis Router 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 Data Analysis Router use?
No licence was found for Data Analysis Router or its repository. Without one, default copyright applies: ask the author before reusing or redistributing it.
How many tokens does Data Analysis Router use?
About 1k tokens (SKILL.md is roughly 4.2k 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 4.8k tokens, read only when the agent opens those files.
What are the alternatives to Data Analysis Router?
Skills that share tags, products or a category with Data Analysis Router: Excel and CSV Data Analysis (bytedance/deer-flow, 83k stars), Raccoon Dataanalysis (SenseTime-Copilot/raccoon-dataanalysis-skill, 137 stars), CSV Data Analysis (5zjk5/prompt-engineering, 127 stars) and Exploring Data (oaustegard/claude-skills, 150 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Who maintains Data Analysis Router?
franklee16 (a GitHub user) maintains it in franklee16/academic-research-skills, which has 223 GitHub stars. The repository holds 1,616 skills in this directory. The repository was last updated on September 18, 2026.
Source: franklee16/academic-research-skills on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.