csvcut

all

Filter and truncate CSV files. Like Unix's `cut` command, but for tabular data. Included in csvkit.

Options (3)

-n, --namesboolean

Print indices and names of all columns

Example: csvcut {{[-n|--names]}} {{data.csv}}

-c, --columnsboolean

Extract the first and third columns

Example: csvcut {{[-c|--columns]}} {{1,3}} {{data.csv}}

-C, --not-columnsboolean

Extract all columns except the fourth one

Example: csvcut {{[-C|--not-columns]}} {{4}} {{data.csv}}

Print indices and names of all columns

csvcut [-n|--names] data.csv

Extract the first and third columns

csvcut [-c|--columns] 1,3 data.csv

Extract all columns except the fourth one

csvcut [-C|--not-columns] 4 data.csv

Extract the columns named "id" and "first name" (in that order)

csvcut [-c|--columns] id,"first name" data.csv