CSVKit

References: https://csvkit.readthedocs.org http://www.anthonydebarros.com/2011/09/11/csvkit-data-files/ https://jonlabelle.com/snippets/view/shell/csvkit-commands http://jeroenjanssens.com/2013/09/19/seven-command-line-tools-for-data-science.html http://csvkit.readthedocs.org/en/latest/tutorial/3_power_tools.html https://csvkit.readthedocs.org/en/0.9.1/scripts/csvclean.html

I personally use Ubuntu, if you don’t the commands may be slightly different. To install: