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

sql2csv
Executes arbitrary commands against an SQL database and outputs the results as a
CSV. Csvkit (version 0.8.0) by Christopher Groskopf (2014). http://csvkit.readthe
docs.org .
$ sudo pip install csvkit
$ sql2csv --help
ssh
Login to remote machines. OpenSSH client (version 1.8.9) by Tatu Ylonen, Aaron
Campbell, Bob Beck, Markus Friedl, Niels Provos, Theo de Raadt, Dug Song, and
Markus Friedl (2014). http://www.openssh.com .
$ sudo apt-get install ssh
$ man ssh
sudo
Execute a command as another user. Sudo (version 1.8.9p5) by Todd C. Miller (2013).
http://www.sudo.ws/sudo .
$ sudo apt-get install sudo
$ man sudo
tail
Output the last part of files. Tail (version 8.21) by Paul Rubin, David MacKenzie, Ian
Lance Taylor, and Jim Meyering (2012). http://www.gnu.org/so ​ ware/coreutils .
$ sudo apt-get install coreutils
$ man tail
$ seq 5 | tail -n 3
3
4
5
tapkee
Reduce dimensionality of a data set using various algorithms. Tapkee by Sergey Lisit‐
syn and Fernando Iglesias (2014). http://tapkee.lisitsyn.me .
$ # See website for installation instructions
$ tapkee --help
$ < iris.csv cols -C species body tapkee --method pca | header -r x,y,species