List of Command-Line Tools - Data Science at the Command Line - page 169

csvgrep
Filter tabular data to only those rows where certain columns contain a given value or
match a regular expression. Csvkit (version 0.8.0) by Christopher Groskopf (2014).
http://csvkit.readthedocs.org .
$ sudo pip install csvkit
$ csvgrep --help
csvjoin
Merge two or more CSV tables together using a method analogous to a SQL JOIN
operation. Csvkit (version 0.8.0) by Christopher Groskopf (2014). http://csvkit.read
thedocs.org .
$ sudo pip install csvkit
$ csvjoin --help
csvlook
Renders a CSV file to the command line in a readable, fixed-width format. Csvkit
(version 0.8.0) by Christopher Groskopf (2014). http://csvkit.readthedocs.org .
$ sudo pip install csvkit
$ csvlook --help
$ echo -e "a,b\n1,2\n3,4" | csvlook
|----+----|
| a | b |
|----+----|
| 1 | 2 |
| 3 | 4 |
|----+----|
csvsort
Sort CSV files. Like the sort command-line tool, but for tabular data. Csvkit (version
0.8.0) by Christopher Groskopf (2014). http://csvkit.readthedocs.org .
$ sudo pip install csvkit
$ csvsort --help
csvsql
Execute SQL queries directly on CSV data or insert CSV into a database. Csvkit (ver‐
sion 0.8.0) by Christopher Groskopf (2014). http://csvkit.readthedocs.org .
$ sudo pip install csvkit
$ csvsql --help