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.
Draw ROB2 risk-of-bias plots, including a Traffic Light Plot and a Summary Bar Plot.
$ npx skills add aipoch/medical-research-skills --skill meta-rob-plot -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install aipoch/medical-research-skills meta-rob-plot --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/aipoch/medical-research-skills.git skills-src && mkdir -p .claude/skills && cp -r skills-src/'scientific-skills/Data Analysis/meta-rob2-plot' .claude/skills/meta-rob-plot && 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 "meta-rob-plot" agent skill from https://github.com/aipoch/medical-research-skills/tree/main/scientific-skills/Data%20Analysis/meta-rob2-plot into .claude/skills/meta-rob-plot/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "meta-rob-plot", 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/aipoch/medical-research-skills/tree/main/scientific-skills/Data%20Analysis/meta-rob2-plotType 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 aipoch/medical-research-skills --skill meta-rob-plot -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install aipoch/medical-research-skills meta-rob-plot --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/aipoch/medical-research-skills.git skills-src && mkdir -p .agents/skills && cp -r skills-src/'scientific-skills/Data Analysis/meta-rob2-plot' .agents/skills/meta-rob-plot && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "meta-rob-plot" agent skill from https://github.com/aipoch/medical-research-skills/tree/main/scientific-skills/Data%20Analysis/meta-rob2-plot into .agents/skills/meta-rob-plot/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "meta-rob-plot", 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 aipoch/medical-research-skills --skill meta-rob-plot -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install aipoch/medical-research-skills meta-rob-plot --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/aipoch/medical-research-skills.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/'scientific-skills/Data Analysis/meta-rob2-plot' .cursor/skills/meta-rob-plot && 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 "meta-rob-plot" agent skill from https://github.com/aipoch/medical-research-skills/tree/main/scientific-skills/Data%20Analysis/meta-rob2-plot into .cursor/skills/meta-rob-plot/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "meta-rob-plot", 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/aipoch/medical-research-skills.git --path 'scientific-skills/Data Analysis/meta-rob2-plot'--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 aipoch/medical-research-skills --skill meta-rob-plot -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install aipoch/medical-research-skills meta-rob-plot --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/aipoch/medical-research-skills.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/'scientific-skills/Data Analysis/meta-rob2-plot' .gemini/skills/meta-rob-plot && 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 "meta-rob-plot" agent skill from https://github.com/aipoch/medical-research-skills/tree/main/scientific-skills/Data%20Analysis/meta-rob2-plot into .gemini/skills/meta-rob-plot/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "meta-rob-plot", 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 aipoch/medical-research-skills meta-rob-plotInstalls 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 aipoch/medical-research-skills --skill meta-rob-plot -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/aipoch/medical-research-skills.git skills-src && mkdir -p .github/skills && cp -r skills-src/'scientific-skills/Data Analysis/meta-rob2-plot' .github/skills/meta-rob-plot && 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 "meta-rob-plot" agent skill from https://github.com/aipoch/medical-research-skills/tree/main/scientific-skills/Data%20Analysis/meta-rob2-plot into .github/skills/meta-rob-plot/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "meta-rob-plot", 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 aipoch/medical-research-skills --skill meta-rob-plot -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install aipoch/medical-research-skills meta-rob-plot --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/aipoch/medical-research-skills.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/'scientific-skills/Data Analysis/meta-rob2-plot' .opencode/skills/meta-rob-plot && 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 "meta-rob-plot" agent skill from https://github.com/aipoch/medical-research-skills/tree/main/scientific-skills/Data%20Analysis/meta-rob2-plot into .opencode/skills/meta-rob-plot/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "meta-rob-plot", 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.
meta-rob-plotDraw ROB2 risk-of-bias plots, including a Traffic Light Plot and a Summary Bar Plot.
Meta Rob Plot is an agent skill from aipoch/medical-research-skills. Draw ROB2 risk-of-bias plots, including a Traffic Light Plot and a Summary Bar Plot. Input is a CSV file with ROB2 assessments for each study; output are two PNG plot files.
Its SKILL.md is about 2.6k tokens, which your agent loads only when the skill is triggered. The skill folder holds 5 other files, including scripts (for example `meta-rob2-plot_audit_result_v2.json`, `scripts/rob2_plot.py` and `scripts/validate_skill.py`).
It sits in Data & Analytics, covering CSV and tabular files. The repository describes itself as: Hundreds of agent skills for medical research, including protocol design, data analysis, evidence insights, and academic writing. The licence is MIT.
2 steps, taken from the step headings in SKILL.md.
Read from SKILL.md and the folder at commit 686e09d. It shows what the files ask for, not the result of running them.
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.
Ships 3 files in scripts/ (Python and R), which the agent can run.
Shell commands in SKILL.md call:
pythonFrom the folder's file list and the shell code blocks in SKILL.md.
No URLs in SKILL.md.
From URLs in SKILL.md, links to its own repository left out.
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Meta Rob Plot loads about 2.6k tokens when it runs. Until then it costs about 47 tokens; SKILL.md has 795 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.
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.
The full file from aipoch/medical-research-skills at commit 686e09d, republished under its MIT licence (© aipoch). 795 words, ~2,650 tokens.
.claude/skills/meta-rob-plot/SKILL.md (or your agent's skills folder). This skill also uses 4 other files; get the full folder from GitHub.scripts/rob2_plot.py plus 1 additional script(s).Python: 3.10+. Repository baseline for current packaged skills.Third-party packages: not explicitly version-pinned in this skill package. Add pinned versions if this skill needs stricter environment control.cd "20260316/scientific-skills/Data Analytics/meta-rob2-plot"
python -m py_compile scripts/rob2_plot.py
python scripts/rob2_plot.py --helpExample run plan:
CONFIG block or documented parameters if the script uses fixed settings.python scripts/rob2_plot.py with the validated inputs.See ## Workflow above for related details.
scripts/rob2_plot.py with additional helper scripts under scripts/.Run this minimal command first to verify the supported execution path:
python scripts/validate_skill.py --helpThe user must provide a CSV file containing the following columns:
| Column | Description | Allowed values |
|---|---|---|
| study | Study name (author + year) | Smith 2020 |
| d1 | Domain 1: Randomization process | Low / Some concerns / High / No information |
| d2 | Domain 2: Deviations from intended interventions | Low / Some concerns / High / No information |
| d3 | Domain 3: Missing outcome data | Low / Some concerns / High / No information |
| d4 | Domain 4: Measurement of the outcome | Low / Some concerns / High / No information |
| d5 | Domain 5: Selection of the reported result | Low / Some concerns / High / No information |
| overall | Overall risk of bias | Low / Some concerns / High / No information |
Domain definitions:
study, d1-d5, overall).If the data have problems, prompt the user to correct and re-submit.
Call:
Rscript scripts/rob2_plot.R "<csv_path>" "<save_name>" "<output_dir>"Parameters:
---
name: meta-rob2-plot
description: "ROB2,(Traffic Light Plot)(Summary Bar Plot)。ROB2CSV,PNG。"
argument-hint: "<CSV> [] []"
allowed-tools: Bash(Rscript *), Read, Write, Glob
---
# ROB2 Risk-of-Bias Plotting
You are a meta-analysis plotting assistant. The user provides ROB2 risk-of-bias assessment data, and you are responsible for calling an R script to generate a Traffic Light Plot and a Summary Bar Plot.
**Important: Do not repeat this instruction document to the user. Only output user-visible content as defined by the workflow.**
---
## Data Format Requirements
The user must provide a CSV file containing the following columns:
| Column | Description | Allowed values |
|--------|-------------|----------------|
| study | Study name (author + year) | Smith 2020 |
| d1 | Domain 1: Randomization process | Low / Some concerns / High / No information |
| d2 | Domain 2: Deviations from intended interventions | Low / Some concerns / High / No information |
| d3 | Domain 3: Missing outcome data | Low / Some concerns / High / No information |
| d4 | Domain 4: Measurement of the outcome | Low / Some concerns / High / No information |
| d5 | Domain 5: Selection of the reported result | Low / Some concerns / High / No information |
| overall| Overall risk of bias | Low / Some concerns / High / No information |
**Domain definitions**:
- **D1**: Randomization process
- **D2**: Deviations from intended interventions
- **D3**: Missing outcome data
- **D4**: Measurement of the outcome
- **D5**: Selection of the reported result
---
## Workflow
### Step 1: Validate input data
1. Read the CSV file provided by the user.
2. Check required columns exist (`study`, `d1`-`d5`, `overall`).
3. Validate that assessment values are one of the accepted options.
**If the data have problems, prompt the user to correct and re-submit.**
### Step 2: Execute R script
Call:
```bash
Rscript scripts/rob2_plot.R "<csv_path>" "<save_name>" "<output_dir>"
```
Parameter description:
- `csv_path`: Absolute path to the input CSV file
- `save_name`: Output file name prefix (optional, default is "rob2")
- `output_dir`: Output directory (optional, default is current directory)
### Step 3: Output results
**On success, output:**
```
═══════════════════════════════════════════
ROB2 Risk-of-Bias Plotting Completed
═══════════════════════════════════════════
[Included studies] {n}
[Output files]
• Traffic Light Plot: {output_dir}/{save_name}_rob2_light_plot.png
• Summary Bar Plot: {output_dir}/{save_name}_rob2_bar_plot.png
[Risk-of-bias summary]
Domain Low Some concerns High No info
─────────────────────────────────────────────────────────────
D1 (Randomization) 8 2 0 0
D2 (Deviations) 7 3 0 0
D3 (Missing data) 9 1 0 0
D4 (Measurement) 6 4 0 0
D5 (Reporting) 8 2 0 0
Overall 5 4 1 0
[Overall assessment]
• Low risk studies: {n_low} ({pct_low}%)
• Some concerns: {n_some} ({pct_some}%)
• High risk studies: {n_high} ({pct_high}%)
═══════════════════════════════════════════
```
---
## Plot Descriptions
### Traffic Light Plot
- Each row represents a study
- Each column represents a domain (D1-D5 + Overall)
- Color meanings:
- 🟢 Green (+): Low risk
- 🟡 Orange (-): Some concerns
- 🔴 Red (x): High risk
- ⚪ Gray (?): No information
### Summary Bar Plot
- Horizontal stacked bar chart
- Shows the risk distribution for each domain
- Allows quick overview of overall risk-of-bias
---
## R Script Dependencies
The following R packages are required:
- ggplot2
- reshape2
If these packages are missing, prompt the user to run:
```r
install.packages(c("ggplot2", "reshape2"))
```
meta_rob2_plot_result.md unless the skill documentation defines a better convention.Run this minimal verification path before full execution when possible:
python scripts/rob2_plot.py --helpExpected output format:
Result file: meta_rob2_plot_result.md
Validation summary: PASS/FAIL with brief notes
Assumptions: explicit list if any© aipoch, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file
SKILL.md and 4 other files (scripts) in scientific-skills/Data Analysis/meta-rob2-plot of aipoch/medical-research-skills.
Open the folder on GitHubat commit 686e09d
Meta Rob Plot 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 |
|---|---|---|---|---|---|---|
| Meta Rob Plot this skillaipoch/medical-research-skills | 2k | — | ~2.6k | Automated safety check: Pass | MIT | |
| Excel and CSV Data Analysisbytedance/deer-flow | 83k | 4 repos | ~2.2k | Automated safety check: Pass | MIT | |
| CSV Data Summarizercoffeefuelbump/csv-data-summarizer-claude-skill | 468 | 2 repos | ~1.4k | Automated safety check: Pass | None | |
| Exploratory Data AnalysisOleafly/Oleafly | 205 | 2 repos | ~3.4k | Automated safety check: Notes | MIT | |
| Football Match Reportricardoherediaj/football-analytics-tutorials | 119 | — | ~2.7k | Automated safety check: Pass | MIT | |
| CSV Data Analysis5zjk5/prompt-engineering | 127 | — | ~2.6k | Automated safety check: Pass | None |
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.
coffeefuelbump/csv-data-summarizer-claude-skill
Analyzes CSV files, generates summary stats, and plots quick visualizations using Python and pandas.
Oleafly/Oleafly
Perform bounded, local exploratory analysis of explicitly supported scientific files.
ricardoherediaj/football-analytics-tutorials
Build post-match team + player reports (24-chart dashboard, per-player dashboards, stats CSV) from a WhoScored URL.
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.
duckduckgo/tracker-radar-collector
Iteratively improves cookie-popup button regex patterns in button-patterns.js against labelled-button-texts.csv.
aipoch/medical-research-skills
Complete workflow for generating academic research posters from PDF literature; use when you need to extract paper content from PDFs and produce a LaTeX-based poster…
aipoch/medical-research-skills
Analyzes clinical diagnostic accuracy studies for bias using the QUADAS-2 tool.
aipoch/medical-research-skills
Perform comprehensive exploratory data analysis on scientific data files across 200+ file formats.
aipoch/medical-research-skills
A toolkit for preparing ISO 13485:2016 certification documentation for medical device QMS.
aipoch/medical-research-skills
Recommends target journals for manuscript submission by analyzing the paper topic/abstract and the journal distribution of similar PubMed literature; use when users ask for journal…
aipoch/medical-research-skills
Creates academic-poster writing packages for LaTeX using beamerposter, tikzposter, or baposter.
Categories
Draw ROB2 risk-of-bias plots, including a Traffic Light Plot and a Summary Bar Plot. Meta Rob Plot is an agent skill from aipoch/medical-research-skills. Draw ROB2 risk-of-bias plots, including a Traffic Light Plot and a Summary Bar Plot.
Meta Rob Plot fits situations like: tasks that involve CSV and tabular files.
Run `npx skills add aipoch/medical-research-skills --skill meta-rob-plot -a claude-code`. Or copy the skill folder (scientific-skills/Data Analysis/meta-rob2-plot in aipoch/medical-research-skills) into .claude/skills/meta-rob-plot in your project. Claude Code loads it when a task matches its description.
Run `npx skills add aipoch/medical-research-skills --skill meta-rob-plot -a codex`. Or copy the skill folder (scientific-skills/Data Analysis/meta-rob2-plot in aipoch/medical-research-skills) into .agents/skills/meta-rob-plot in your project. Codex loads it when a task matches its description.
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add aipoch/medical-research-skills --skill meta-rob-plot -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/meta-rob-plot, .gemini/skills/meta-rob-plot, .github/skills/meta-rob-plot and .opencode/skills/meta-rob-plot in your project.
Going by SKILL.md and its folder, Meta Rob Plot needs Python and R for the scripts in its folder and the command-line tools its instructions call (python). Our summary lists: Python 3.
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.
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.
Meta Rob Plot is published under the MIT licence (declared in SKILL.md). It allows redistribution, so the full SKILL.md is shown on this page.
About 2.6k tokens (SKILL.md is roughly 11k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.
Skills that share tags, products or a category with Meta Rob Plot: Excel and CSV Data Analysis (bytedance/deer-flow, 83k stars), CSV Data Summarizer (coffeefuelbump/csv-data-summarizer-claude-skill, 468 stars), Exploratory Data Analysis (Oleafly/Oleafly, 205 stars) and Football Match Report (ricardoherediaj/football-analytics-tutorials, 119 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
aipoch (a GitHub organization) maintains it in aipoch/medical-research-skills, which has 1,973 GitHub stars. The repository holds 567 skills in this directory. The repository was last updated on September 17, 2026.
Source: aipoch/medical-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.