csv

Compare original and translation side by side

🇺🇸

Original

English

🇨🇳

Translation

Chinese

CSV Processing Skill

CSV处理技能

Process CSV files using standard bash tools (awk, cut, sort, grep).

使用标准bash工具（awk、cut、sort、grep）处理CSV文件。

Available Scripts

可用脚本

analyze.sh

Get statistics and summary of a CSV file.

bash

bash /skills/csv/scripts/analyze.sh data.csv

获取CSV文件的统计信息和摘要。

bash

bash /skills/csv/scripts/analyze.sh data.csv

filter.sh

Filter rows where a column matches a value.

bash

bash /skills/csv/scripts/filter.sh data.csv <column_number> <value>

筛选出某列匹配指定值的行。

bash

bash /skills/csv/scripts/filter.sh data.csv <column_number> <value>

select.sh

Select specific columns from CSV.

bash

bash /skills/csv/scripts/select.sh data.csv <col1,col2,col3>

从CSV中选择特定列。

bash

bash /skills/csv/scripts/select.sh data.csv <col1,col2,col3>

sort.sh

Sort CSV by a column.

bash

bash /skills/csv/scripts/sort.sh data.csv <column_number> [--numeric] [--reverse]

按某列对CSV进行排序。

bash

bash /skills/csv/scripts/sort.sh data.csv <column_number> [--numeric] [--reverse]

Examples

示例

bash

undefined

bash

undefined

Show CSV summary

显示CSV摘要

bash /skills/csv/scripts/analyze.sh sales.csv

Filter where column 3 equals "active"

筛选第3列等于"active"的行

bash /skills/csv/scripts/filter.sh users.csv 3 active

Select columns 1, 2, and 4

选择第1、2和4列

bash /skills/csv/scripts/select.sh data.csv 1,2,4

Sort by column 2 numerically in reverse

按第2列进行数值反向排序

bash /skills/csv/scripts/sort.sh data.csv 2 --numeric --reverse

undefined

bash /skills/csv/scripts/sort.sh data.csv 2 --numeric --reverse

undefined