linux 处理csv一些操作

# 使用 tr，将制表符替换为逗号
tr '\t' ',' < input.tsv > step1.csv

awk '
NR==1 {h=$0; next}
{
  f = int((NR-2)/1000000)
  if ((NR-2)%1000000 == 0) {
    name = sprintf("part_%03d.csv", f)
    print h > name
  }
  print >> name
}
' step1.csv

part_000.csv
part_001.csv
part_002.csv

head -n 5 part_000.csv

wc -l part_000.csv

cut -d',' -f3 part_000.csv | head

awk -F',' '$2=="xxx"' part_000.csv