csv-tools

name	csv-tools
description	Parse and analyze CSV data
disable-model-invocation	false
permissions	{"tools":{"allow":["exec"]},"egress":{"mode":"deny"},"inference":{"allow":["*"]}}

CSV Tools

Work with CSV files using standard shell tools.

View

• First few rows: head -5 data.csv
• Column headers: head -1 data.csv
• Row count: wc -l data.csv
• Specific columns (1st and 3rd): cut -d',' -f1,3 data.csv

Filter and sort

• Filter rows: awk -F',' '$3 > 100' data.csv
• Sort by column: sort -t',' -k2 -n data.csv
• Unique values in column: cut -d',' -f2 data.csv | sort -u
• Count by value: cut -d',' -f2 data.csv | sort | uniq -c | sort -rn

Transform

• Remove header: tail -n +2 data.csv
• Add line numbers: nl -ba data.csv
• Replace delimiter: sed 's/,/\t/g' data.csv (CSV to TSV)

Python (for complex operations)

python3 -c "
import csv, sys
reader = csv.DictReader(open('data.csv'))
for row in reader:
    print(row)
" | head -10