📦 CSV Tool Pro — CSV 工具 Pro

📊 CSV 工具 Pro

Author: Lin Hui | GitHub | MIT License | v1.0.0

One command to rule all your CSV files. View, 过滤器, 排序, merge, split, dedupe, convert, and analyze — all without leaving your terminal or opening Excel.

✨ Features Core Operations View — Pretty-print CSV with alignment and t运行cation 过滤器 — Row 过滤器ing by column value, regex, or numeric range 排序 — Single or multi-column 排序 (asc/desc) Dedupe — 移除 duplicate rows by key columns Multi-File Operations Merge — Combine multiple CSVs (union by headers) Join — Inner/left/right/full join on key columns Split — Split large CSV into smaller files by row count or column value 格式化 Conversion to JSON — Array of objects or nested 格式化 to YAML — 清理 YAML 输出 to TSV — Tab-separated 输出 to Markdown — GitHub-flavored markdown table to HTML — Styled HTML table 分析 Stats — Count, mean, median, min, max, std for numeric columns Frequency — Value frequency distribution Pivot — Pivot table aggregation 🚀 Usage View a CSV file Read the CSV file at /path/to/data.csv and show the first 20 rows in a nice table.

过滤器 and 排序 Read sales.csv, 过滤器 rows where amount > 1000, 排序 by date descending.

Merge multiple CSVs Merge january.csv and february.csv into a single file Q1.csv.

Convert to JSON Convert users.csv to JSON 格式化 and save as users.json.

Stats Show statistics for all numeric columns in 指标.csv.

Dedupe 移除 duplicate rows from contacts.csv based on the emAIl column.

Pivot table 创建 a pivot table from sales.csv with region as rows, product as columns, sum of amount as values.

⚙️ Technical DetAIls 运行time: Python 3.6+ Dependencies: Zero (stdlib only: csv, json, statistics, re, arg解析, os) Encoding: Auto-检测 UTF-8/GBK/UTF-8-BOM Large files: 流ing processing for files >100MB Delimiters: Auto-检测 comma, tab, semicolon, pipe 📝 Notes Auto-检测s delimiter (comma, tab, semicolon, pipe) Handles quoted fields with embedded delimiters and newlines Preserves original encoding on write Supports gzip-压缩ed CSV files