I'm rather fond of using [1] csvkit for doing my csv wrangling. That and google refine (now open refine).

[1] http://csvkit.readthedocs.org/