gebruder 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