Xcut
Xcut is an Enhanced cut command, which is used to help grep column.
Install
pip install xcut
pip3 install xcut
xcut --help
Usage
Let's test a file named test.csv
> ~ cat test/test.csv
name,gender,job
Jack,male,coder
Lucy,female,artist
Cut fields
> ~ xcut -f job,name test/test.csv
job,name
coder,Jack
artist,Lucy
Set title type
The default title type is head: -t head
> ~ xcut -f name,gender test/test.csv
Set title type to index: -t index
> ~ xcut -f 1,3 -t index test/test.csv
1,3
name,job
Jack,coder
Lucy,artist
Set title type to custom(--titles TITLES)
> ~ xcut -f '职业,姓名' --titles '姓名,性别,职业' test/test.csv -od $'\t'
职业 姓名
job name
coder Jack
artist Lucy
Set title type to kv(-t kv)
> ~ echo 'key1=v1,key2=v2,key3=v3' | xcut -f key3,key2 -t kv
key3,key2
v3,v2
Set input delimiter(d)
> ~ xcut -f job,name test/test.csv -d ',' -od '`'
job`name
coder`Jack
artist`Lucy
Set output delimiter(od)
> ~ xcut -f job,name test/test.csv -od '`'
job`name
coder`Jack
artist`Lucy
pretty output
You could set the output delimiter(od), also you can print it via pretty
> ~ xcut -f '职业,姓名' --titles '姓名,性别,职业' test/test.csv -od $'\t\t' --pretty
职业 姓名
----------------------------------------
job name
coder Jack
artist Lucy
Use csv format
Not only you could parse csv format file with --from-csv:
$ echo 'Lucy,"98,99",23' | python xcut -f scores,name --titles name,scores,age
scores,name
"98,Lucy
$ echo 'Lucy,"98,99",23' | python xcut -f scores,name --titles name,scores,age --from-csv
scores,name
98,99,Lucy
You could also save the output to csv format with(--to-csv)
$ echo 'Lucy,"98,99",23' | python xcut -f scores,name --titles name,scores,age --from-csv --to-csv
scores,name
"98,99",Lucy
Required
- python>=3.5
- click
