Yesss. Glad to see this getting some love. I use this tool very frequently in my day-to-day and my work would be so much harder without it.

A lot of folks mentioning great projects/solutions that work the same but I love me some good unix piping action:

    cat data.csv | xsv select 1,3 | q 'select * from - where col1 != "foo"'

(xsv: also invaluable on the terminal: https://github.com/BurntSushi/xsv)

And yet another set of tools is vnlog (https://github.com/dkogan/vnlog). It assumes you have whitespace-separated data, with a legend comment, then you can do the above thing with

  < data.vnl vnl-filter -p thiscolumn,thatcolumn 'thiscolumn != "foo"'

If you don't strictly need csv, those tools are quite nice, and have a really friendly learning curve. Disclaimer: I'm the author