data-analysis
Analyze Excel/CSV files with DuckDB SQL via bash.
npx skills add HezaoHezao/poirot --skill data-analysis --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# Data Analysis ## Overview Analyzes user-provided Excel (.xlsx/.xls) or CSV files using DuckDB — an in-process analytical SQL engine. Supports schema inspection, SQL querying, statistical summaries, and result export. > **Poirot note:** The original deer-flow skill uses a bundled > `scripts/analyze.py` helper. Poirot doesn't bundle that script, so this > version uses `bash` with `python3` + `duckdb` directly. Install duckdb first: > `pip install duckdb`. ## When to Use - User uploads Excel/CSV files and wants analysis - User wants statistics, summaries, pivot tables, or SQL queries on data - User wants to filter, join, or aggregate structured data ## Prerequisites ```bash # Install duckdb if not present pip install duckdb openpyxl ``` ## Workflow ### Step 1: Inspect File Structure ```bash python3 -c " import duckdb con = duckdb.connect() # For CSV result = con.execute(\"DESCRIBE SELECT * FROM read_csv_auto('data.csv')\").fetchall() for col in result: print(f'{col[0]:30s} {col[1]}') # For Excel (each sheet = a table) result = con.execute(\"SELECT * FROM st_read('data.xlsx', layer='Sheet1') LIMIT 0\").fetchall() # Row count count = con.execute(\"SELECT COUNT(*) FROM read_csv_auto('d
- Overview
- When to Use
- Prerequisites
- Workflow
- Step 1: Inspect File Structure
- Step 2: Statistical Summary
- Step 3: SQL Queries
- Step 4: Export Results
- Common Patterns
- Pivot table
- Percentiles
- Multi-sheet Excel
- Pitfalls
Install duckdb if not present
pip install duckdb openpyxl
python3 -c "
import duckdb
con = duckdb.connect()
For CSV
result = con.execute(\"DESCRIBE SELECT * FROM read_csv_auto('data.csv')\").fetchall()
for col in result:
For Excel (each sheet = a table)
result = con.execute(\"SELECT * FROM st_read('data.xlsx', layer='Sheet1') LIMIT 0\").fetchall()What does the data-analysis skill do?
Analyze Excel/CSV files with DuckDB SQL via bash.
How do I install it?
Run `npx skills add HezaoHezao/poirot --skill data-analysis --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From HezaoHezao/poirot, a repository with 139 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.