Skip to content
Skills Library
Data & analytics · Analysis

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, 表格, 逗号分隔, 去重, 分组统计, 筛选.

Repository
microclaw ↗
Licence
MIT
Last repository change
26.10.2026

Assessment and security

100/ 100Class: good
Format25 / 25
Frontmatter with name and description, valid name, description up to 1,024 characters, name matching the folder.
Discoverability25 / 25
Description explains when to use the skill, has a reasonable length and uses third person.
Content35 / 35
At least 150 words and at most 500 lines, headings, step lists, examples or code.
Hygiene15 / 15
No placeholders such as TODO, no Windows paths, with a licence.
Riskno signals detected in the scan
Files in this package
1
Scripts
0
HTML comments
0
URLs in SKILL.md
0
Deprecation

No signals detected. Repository changed on 26.10.2026, without references to retired models or APIs.

Licence

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

  1. Peek: headers, row count, first rows
  2. Filter rows by a column
  3. Group-by aggregate (sum / count)
  4. Dedupe / clean
  5. Guidance
Original SKILL.md headings · 70 lines, 234 words
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".

Feedback and reports

Your message goes to Bartosz Sokoliński. An email address is needed only for a reply. See the privacy policy.