NAME
csvcut - csvcut Documentation
DESCRIPTION
Filters and truncates CSV files. Like the Unix "cut" command, but for tabular data:
usage: csvcut [-h] [-d DELIMITER] [-t] [-q QUOTECHAR] [-u {0,1,2,3}] [-b][-p ESCAPECHAR] [-z FIELD_SIZE_LIMIT] [-e ENCODING] [-S] [-H][-K SKIP_LINES] [-v] [-l] [--zero] [-V] [-n] [-c COLUMNS][-C NOT_COLUMNS] [-x][FILE]Filter and truncate CSV files. Like the Unix "cut" command, but for tabulardata.positional arguments:FILE The CSV file to operate on. If omitted, will acceptinput as piped data via STDIN.optional arguments:-h, --help show this help message and exit-n, --names Display column names and indices from the input CSVand exit.-c COLUMNS, --columns COLUMNSA comma-separated list of column indices, names orranges to be extracted, e.g. "1,id,3-5". Defaults toall columns.-C NOT_COLUMNS, --not-columns NOT_COLUMNSA comma-separated list of column indices, names orranges to be excluded, e.g. "1,id,3-5". Defaults to nocolumns. Ignores unknown columns.-x, --delete-empty-rowsAfter cutting, delete rows which are completely empty.
See also: Arguments common to all tools.
NOTE:
csvcut does not implement row filtering, for this you should pipe data to csvgrep.
NOTE:
If a data row is longer than the header row, its additional columns are truncated.
EXAMPLES
Print columns
Print the indices and names of all columns:
$ csvcut -n examples/realdata/FY09_EDU_Recipients_by_State.csv1: State Name2: State Abbreviate3: Code4: Montgomery GI Bill-Active Duty5: Montgomery GI Bill- Selective Reserve6: Dependents' Educational Assistance7: Reserve Educational Assistance Program8: Post-Vietnam Era Veteran's Educational Assistance Program9: TOTAL10:
Print only the names of all columns, by removing the indices with the cut command:
$ csvcut -n examples/realdata/FY09_EDU_Recipients_by_State.csv | cut -c6-State NameState AbbreviateCodeMontgomery GI Bill-Active DutyMontgomery GI Bill- Selective ReserveDependents' Educational AssistanceReserve Educational Assistance ProgramPost-Vietnam Era Veteran's Educational Assistance ProgramTOTAL
Extract columns
Extract the first and third columns:
csvcut -c 1,3 examples/realdata/FY09_EDU_Recipients_by_State.csv
Extract columns named "TOTAL" and "State Name" (in that order):
csvcut -c TOTAL,"State Name" examples/realdata/FY09_EDU_Recipients_by_State.csv
Extract a column that may not exist in all files:
echo d, | csvjoin examples/dummy.csv - | csvcut -c decho d, | csvjoin examples/join_no_header_row.csv - | csvcut -c d
Other
Add line numbers to a file, making no other changes:
csvcut -l examples/realdata/FY09_EDU_Recipients_by_State.csv
Display a column's unique values:
csvcut -c 1 examples/realdata/FY09_EDU_Recipients_by_State.csv | sed 1d | sort | uniq
Or:
csvcut -c 1 examples/realdata/FY09_EDU_Recipients_by_State.csv | csvsql --query 'SELECT DISTINCT("State Name") FROM stdin'
AUTHOR
Christopher Groskopf and contributors
COPYRIGHT
2016, Christopher Groskopf and James McKinney