NAME
csvstack - csvstack Documentation
DESCRIPTION
Stack up the rows from multiple CSV files, optionally adding a grouping value to each row:
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.positional arguments:FILE The CSV file(s) to operate on. If omitted, will acceptinput as piped data via STDIN.optional arguments:-h, --help show this help message and exit-g GROUPS, --groups GROUPSA comma-separated list of values to add as "groupingfactors", one per CSV being stacked. These are addedto the output as a new column. You may specify a namefor the new column using the -n flag.-n GROUP_NAME, --group-name GROUP_NAMEA name for the grouping column, e.g. "year". Only usedwhen also specifying -g.--filenames Use the filename of each input file as its groupingvalue. When specified, -g will be ignored.
See also: Arguments common to all tools.
WARNING:
If you redirect output to an input file like csvstack file.csv > file.csv, the file will grow indefinitely.
EXAMPLES
Join a set of files for different years:
csvstack -g 2009,2010 examples/realdata/FY09_EDU_Recipients_by_State.csv examples/realdata/Datagov_FY10_EDU_recp_by_State.csv
Add a single column to the left of a CSV:
csvstack -n NEWCOL -g "" examples/dummy.csv
AUTHOR
Christopher Groskopf and contributors
COPYRIGHT
2016, Christopher Groskopf and James McKinney