Scroll to navigation

CSVSTACK(1) User Commands CSVSTACK(1)

NAME

csvstack - manual page for csvstack 1.0.5

DESCRIPTION

usage: csvstack [-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] [-g GROUPS] [-n GROUP_NAME] [--filenames] [FILE [FILE ...]]

Stack up the rows from multiple CSV files, optionally adding a grouping value. Files are assumed to have the same columns in the same order.

positional arguments:

The CSV file(s) to operate on. If omitted, will accept input as piped data via STDIN.

optional arguments:

show this help message and exit
Delimiting character of the input CSV file.
Specify that the input CSV file is delimited with tabs. Overrides "-d".
Character used to quote strings in the input CSV file.
Quoting style used in the input CSV file. 0 = Quote Minimal, 1 = Quote All, 2 = Quote Non-numeric, 3 = Quote None.
Whether or not double quotes are doubled in the input CSV file.
Character used to escape the delimiter if --quoting 3 ("Quote None") is specified and to escape the QUOTECHAR if --no-doublequote is specified.
Maximum length of a single field in the input CSV file.
Specify the encoding of the input CSV file.
Ignore whitespace immediately following the delimiter.
Specify that the input CSV file has no header row. Will create default headers (a,b,c,...).
Specify the number of initial lines to skip before the header row (e.g. comments, copyright notices, empty rows).
Print detailed tracebacks when errors occur.
Insert a column of line numbers at the front of the output. Useful when piping to grep or as a simple primary key.
When interpreting or displaying column numbers, use zero-based numbering instead of the default 1-based numbering.
Display version information and exit.
A comma-separated list of values to add as "grouping factors", one for each CSV being stacked. These will be added to the stacked CSV as a new column. You may specify a name for the grouping column using the -n flag.
A name for the grouping column, e.g. "year". Only used when also specifying -g.
Use the filename of each input file as its grouping value. When specified, -g will be ignored.

SEE ALSO

The full documentation for csvstack is maintained as a Texinfo manual. If the info and csvstack programs are properly installed at your site, the command

info csvstack

should give you access to the complete manual.

October 2020 csvstack 1.0.5