Fixing CSV Data with csvkit
TL;DR: csvkit is a great little library and set of UNIX-style utilities for dealing with CSV data. Here I show how I solved a problem with some CSV Data I had at work and how I solved it with Python and csvkit!
Problem Basically the problem boiled down to the classical GIGO problem where I had a CSV Input Source containing inconsistent data as well as inconsitent formatting (superfluous whitespace).
[Read More]