Use q For High IQ
"q" is a nifty command line tool if you would like to do some text file processing and lookups.
So what is it?
Basically SQL for csv/tsv (and other tabelated) files. It supports most of the basic queries and also allows to perform them over multiple files (supports joining).
How does it work? You can imagine a file with tabelated data as a single table of a database. Just type in the command prompt: