Csv Toolkit

该 Skill 提供一个纯 Python 命令行脚本，对 CSV 文件执行查看（表格显示）、条件筛选、排序、列选择、CSV 与 JSON 互转、列统计、去重和合并，支持自定义分隔符、编码和输出文件，无外部依赖。

johnnywang2001

热度 83.04

最近更新 2026-05-11 17:35:11

分类：效率依赖：代码执行 / 读写文件应用场景：数据处理 / 文件转换

安装技能

复制下面的话术发给你的 Agent，它会通过 secure-skills 检索并安装该技能。

执行命令安装此 skill： npx secure-skills-cli add csv-toolkit

Metadata

name: csv-toolkit
description: Manipulate CSV files from the command line — view, filter, sort, select columns, convert CSV to/from JSON, compute statistics, deduplicate, and merge files. Use when the user needs to work with CSV data, inspect a spreadsheet export, clean up tabular data, convert formats, or get quick column stats. Zero external dependencies.

CSV Toolkit

Command-line CSV manipulation — view, filter, sort, select, convert, stats, dedup, and merge. Pure Python, no dependencies.

Quick Start

# View as formatted table
python3 scripts/csv_toolkit.py view data.csv
python3 scripts/csv_toolkit.py view data.csv --head 10

# Filter rows
python3 scripts/csv_toolkit.py filter data.csv -w 'age>30' 'city==Chicago'

# Sort
python3 scripts/csv_toolkit.py sort data.csv --by salary --desc

# Select columns
python3 scripts/csv_toolkit.py select data.csv -c "name,email,salary"

# Convert to JSON
python3 scripts/csv_toolkit.py to-json data.csv -o data.json

# Convert JSON back to CSV
python3 scripts/csv_toolkit.py from-json data.json -o data.csv

# Column statistics
python3 scripts/csv_toolkit.py stats data.csv -c "age,salary"

# Remove duplicates
python3 scripts/csv_toolkit.py dedup data.csv -o clean.csv

# Merge files
python3 scripts/csv_toolkit.py merge file1.csv file2.csv -o combined.csv

Commands

Command	Description
`view`	Display CSV as a formatted table. Use `--head N` / `--tail N` to limit rows.
`filter`	Filter rows with `-w` conditions: `col>val`, `col==val`, `col!=val`, `col<=val`. Multiple conditions = AND.
`sort`	Sort by column with `--by col`. Add `--desc` for descending. Numeric-aware.
`select`	Pick columns with `-c "col1,col2"`.
`to-json`	Convert CSV to JSON array of objects. Auto-detects numbers.
`from-json`	Convert a JSON array of objects to CSV.
`stats`	Column statistics: count, unique values, min/max/mean/median for numeric columns.
`dedup`	Remove duplicate rows.
`merge`	Concatenate multiple CSV files (same headers).

Global Options

Flag	Description
`-d, --delimiter`	Field delimiter (default: `,`). Use `-d '\t'` for TSV.
`--encoding`	File encoding (default: `utf-8`).
`-o, --output`	Write result to file instead of stdout.