CSV Tool

I found a nice tool wich provides a command line interface for basic operations on csv files. It supports joins, filters and a lot of other things.

The tool is named csvkit and the installation is straightforward.

Installation

pip install csvkit

Examples

It's quite easy to join some tables. To use a right outher join, just write:

csvjoin -c1,1 --right artists.csv releases.csv | csvcut -C9 > dataset.csv