How have I gone so long without knowing about Python’s csvkit?
csvkit is a suite of utilities for converting to and working with CSV, the king of tabular file formats. …
csvkit is to tabular data what the standard Unix text processing suite (grep, sed, cut, sort) is to text. As such, csvkit adheres to the Unix philosophy.
csvkit usefully replaces the built-in Python csv module (pretty useful in and of itself) and also provides a really nice set of command line utility for creating, slicing, and dicing csv files.