csv-tools
/csv-tools
Inspect, filter, aggregate, and clean CSV/TSV data with Python. Use when users hand over a .csv/.tsv file or paste tabular data and want a quick look, column stats, filtering, sorting, deduping, group-by sums/counts, or cleanup — without needing a full spreadsheet. Triggers on mentions of csv, tsv, columns, rows, filter, group by, aggregate, dedupe, clean data, 表格, 逗号分隔, 去重, 分组统计, 筛选.
- Author
- microclaw ↗
- Repository
- microclaw ↗
- Licence
- MIT
- Last repository change
- 26.10.2026
Assessment and security
- Files in this package
- 1
- Scripts
- 0
- HTML comments
- 0
- URLs in SKILL.md
- 0
No signals detected. Repository changed on 26.10.2026, without references to retired models or APIs.
MIT, open: use and modify while retaining author attribution.
What it does and when to use it
Inspect, filter, aggregate, and clean CSV/TSV data with Python. Use when users hand over a .csv/.tsv file or paste tabular data and want a quick look, column stats, filtering, sorting, deduping, group-by sums/counts, or cleanup — without needing a full spreadsheet. Triggers on mentions of csv, tsv, columns, rows, filter, group by, aggregate, dedupe, clean data, 表格, 逗号分隔, 去重, 分组统计, 筛选.
Original author description
Inspect, filter, aggregate, and clean CSV/TSV data with Python. Use when users hand over a .csv/.tsv file or paste tabular data and want a quick look, column stats, filtering, sorting, deduping, group-by sums/counts, or cleanup — without needing a full spreadsheet. Triggers on mentions of csv, tsv, columns, rows, filter, group by, aggregate, dedupe, clean data, 表格, 逗号分隔, 去重, 分组统计, 筛选.
How it works
- Peek: headers, row count, first rows
- Filter rows by a column
- Group-by aggregate (sum / count)
- Dedupe / clean
- Guidance
SKILL.md preview
---
name: csv-tools
description: "Inspect, filter, aggregate, and clean CSV/TSV data with Python. Use when users hand over a .csv/.tsv file or paste tabular data and want a quick look, column stats, filtering, sorting, deduping, group-by sums/counts, or cleanup — without needing a full spreadsheet. Triggers on mentions of csv, tsv, columns, rows, filter, group by, aggregate, dedupe, clean data, 表格, 逗号分隔, 去重, 分组统计, 筛选."
license: Proprietary. LICENSE.txt has complete terms
compatibility: "Requires python3. Works on macOS, Linux, and Windows."
---
# CSV Tools
Use Python's stdlib `csv` (always available). Reach for `pandas` only if it's installed
and the task is heavy (`python3 -c "import pandas"` to check first).
## Peek: headers, row count, first rows
```bash
python3 - <<'PY'
import csv
with open('data.csv', newline='') as f:
r = list(csv.reader(f))
print('cols:', r[0])
print('rows:', len(r)-1)
for row in r[1:4]: print(row)
PY
```
## Filter rows by a column
```bash
python3 - <<'PY'
import csv
with open('data.csv', newline='') as f:
for row in csv.DictReader(f):
if row['status'] == 'active':
print(row['id'], row['name'])
PY
```
## Group-by aggregate (sum / count)
```bash
python3 - <<'PY'
import csv, collections
sums = collections.Counter()
with open('sales.csv', newline='') as f:
for row in csv.DictReader(f):
sums[row['region']] += float(row['amount'])
for k,v in sums.most_common():
print(f'{k}: {v:.2f}')
PY
```
## Dedupe / clean
```bash
python3 - <<'PY'
import csv
seen=set(); out=[]
with open('data.csv', newline='') as f:
rd=csv.reader(f); header=next(rd)
for row in rd:
key=tuple(c.strip() for c in row)
if key not in seen:
seen.add(key); out.append(row)
with open('clean.csv','w',newline='') as f:
w=csv.writer(f); w.writerow(header); w.writerows(out)
print('wrote', len(out), 'unique rows')
PY
```
## Guidance
- Always check the delimiter (`,` vs `\t` vs `;`) and whether there's a header row.
- Watch for quoted fields containing commas/newlines — `csv` handles them; manual splitting won't.
- Report a short summary (rows in/out, columns, key numbers), not the whole file.
- If the deliverable is a polished spreadsheet with formatting/charts, use the `xlsx` skill instead.
Versions
The database has no other skills named csv-tools.
Database snapshot: 13.11.2026 · package version d3ec2111252b (SHA-256 digest of the entire package)
Downloads in the last 30 days: 0 · ranking
Report a problem with this skill: harmful content, incorrect descriptions or an author’s removal request.
Similar skills
- 100cisivi
Use the cisivi CLI to read, filter, sort, count, convert, join, set, append, and delete data in CSV files from shell scripts and pipelines. Use when the user wants to query or edit CSV, TSV, or semicolon-separated files, extract columns or values, print a table as JSON or… - 100csv-pipeline
Process, transform, analyze, and report on CSV and JSON data files. Use when the user needs to filter rows, join datasets, compute aggregates, convert formats, deduplicate, or generate summary reports from tabular data. Works with any CSV, TSV, or JSON Lines file. - 90data-file-ops
Use when inspecting, cleaning, transforming, comparing, or summarizing local JSON, CSV, TSV, or text data files with minimal ceremony and reproducible outputs. Triggers: clean this CSV, transform JSON, diff these tables, summarize the data file. - 100csv-profile
Profiles a CSV file and reports column types, null rates, distinct counts, and duplicate rows. Use when the user asks to inspect, sanity-check, or summarize the shape of a CSV or TSV file before analyzing it. - 100data-wrangler
Production-grade tabular data manipulation using pandas & openpyxl. This skill should be used when editing, creating, filtering, sorting, merging, pivoting, deduplicating, validating, or transforming CSV, Excel (xlsx/xls), JSON, Parquet, or TSV files. Supports 18 operations via… - 100tsv
TSV data processing — view, filter, convert tab-separated data. Zero barrier — use with x-cmd, awk, or Python. Use for "tsv", "tab-separated", "data", "conversion".