usage: csvjoin [-h] [-d DELIMITER] [-t] [-q QUOTECHAR] [-u {0,1,2,3}] [-b]


               [-p ESCAPECHAR] [-z FIELD_SIZE_LIMIT] [-e ENCODING] [-L LOCALE]


               [-S] [--blanks] [--null-value NULL_VALUES [NULL_VALUES ...]]


               [--date-format DATE_FORMAT] [--datetime-format DATETIME_FORMAT]


               [-H] [-K SKIP_LINES] [-v] [-l] [--zero] [-V] [-c COLUMNS]


               [--outer] [--left] [--right] [-y SNIFF_LIMIT] [-I]


               [FILE [FILE ...]]
Execute a SQL-like join to merge CSV files on a specified column or columns.
positional arguments:


  FILE                  The CSV files to operate on. If only one is specified,


                        it will be copied to STDOUT.
optional arguments:


  -h, --help            show this help message and exit


  -c COLUMNS, --columns COLUMNS


                        The column name(s) on which to join. Should be either


                        one name (or index) or a comma-separated list with one


                        name (or index) per file, in the same order in which


                        the files were specified. If not specified, the two


                        files will be joined sequentially without matching.


  --outer               Perform a full outer join, rather than the default


                        inner join.


  --left                Perform a left outer join, rather than the default


                        inner join. If more than two files are provided this


                        will be executed as a sequence of left outer joins,


                        starting at the left.


  --right               Perform a right outer join, rather than the default


                        inner join. If more than two files are provided this


                        will be executed as a sequence of right outer joins,


                        starting at the right.


  -y SNIFF_LIMIT, --snifflimit SNIFF_LIMIT


                        Limit CSV dialect sniffing to the specified number of


                        bytes. Specify "0" to disable sniffing.


  -I, --no-inference    Disable type inference when parsing CSV input.
Note that the join operation requires reading all files into memory. Don't try
this on very large files.

csvjoin -c 1 examples/join_a.csv examples/join_b.csv

echo "," | csvjoin examples/dummy.csv -

echo "new-column" | csvjoin examples/dummy.csv -