# csv-analysis

csv-analysis is a Claude Code skill that evaluates CSV files, detects statistical anomalies, and suggests charts. Runs whenever you ask for tabular data analysis or trend reviews.

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, OpenCode, Windsurf (Devin Desktop), Claude.ai · 1 install · ★ 1 repo stars
- Author: ljchg12-hue
- License: not stated · policy=link-only · description only; the file stays with the author
- Source: https://github.com/ljchg12-hue/dotfiles/tree/HEAD/skills/csv-analysis/SKILL.md
- Updated: 2026-01-16
- Security check: automated, 2026-11-16 (text) — no signs of malicious code found.
- HTML: https://affpapa.org/en/nevibecode/skills/csv-analysis

## What it does

The skill inspects tabular files across five structured phases, checking file encoding, row counts, and null values. It calculates descriptive metrics such as mean, standard deviation, percentiles, and correlation matrices.

Outliers get flagged via interquartile range (IQR) or z-score algorithms. Quick summaries rely on Unix utilities like `awk`, `cut`, `sort`, and `wc`. Advanced grouping, pivot tables, and correlation sweeps require an environment with Python, `pandas`, and `numpy`.

## Install

### Claude Code (native platform)

1. **Skills CLI (Vercel)**
```bash
npx skills add ljchg12-hue/dotfiles --skill csv-analysis -a claude-code
```

2. **Manually: put the files in place**
- File: `~/.claude/skills/csv-analysis/SKILL.md` — Copy the whole skill folder; for one project use .claude/skills/csv-analysis/

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add ljchg12-hue/dotfiles --skill csv-analysis -a codex
```

2. **Manually: put the files in place**
- File: `.agents/skills/csv-analysis/SKILL.md` — For all projects use ~/.agents/skills/

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add ljchg12-hue/dotfiles --skill csv-analysis -a cursor
```

2. **Manually: put the files in place**
- File: `.cursor/skills/csv-analysis/SKILL.md` — Cursor also reads .agents/skills/ and .claude/skills/

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install ljchg12-hue/dotfiles skills/csv-analysis
```

2. **Manually: put the files in place**
- File: `.github/skills/csv-analysis/SKILL.md`

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add ljchg12-hue/dotfiles --skill csv-analysis -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/ljchg12-hue/dotfiles --path skills/csv-analysis
```

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/csv-analysis/SKILL.md` — The legacy .windsurf/skills/ path still works

### OpenCode

**Skills CLI (Vercel)**
```bash
npx skills add ljchg12-hue/dotfiles --skill csv-analysis -a opencode
```

### Claude.ai

**Claude.ai**
- Zip the folder and upload it in Settings → Capabilities → Skills

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/ljchg12-hue/dotfiles/tree/HEAD/skills/csv-analysis/SKILL.md

## When to use it
- detect missing entries and duplicate rows in CSV spreadsheets
- calculate summary metrics and correlation matrices
- flag numerical outliers using IQR and z-scores
- recommend chart formats for presenting tabular distributions

## Example prompts
- Analyze `sales.csv` and point out any unusual revenue spikes
- Calculate descriptive statistics and check missing values in `data.csv`
- Find duplicates and clean up invalid records in `customers.csv`

## Similar
- [csv-data-summarizer](https://affpapa.org/en/nevibecode/skills/csv-data-summarizer.md) — skill · 2100 installs
- [data-analysis-skill](https://affpapa.org/en/nevibecode/skills/data-analysis-skill.md) — skill · 205 installs
- [statistical-analysis](https://affpapa.org/en/nevibecode/skills/anthropics-statistical-analysis.md) — skill · 4900 installs
- [data-analysis](https://affpapa.org/en/nevibecode/skills/lingzhi227-data-analysis.md) — skill · 2100 installs
- [csv-excel-merger](https://affpapa.org/en/nevibecode/skills/csv-excel-merger.md) — skill · 1200 installs
- [csv-processor](https://affpapa.org/en/nevibecode/skills/csv-processor.md) — skill · 1 install

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md
