Understanding the CSV file format is perhaps the most important thing that any textsmith can ever do: it is both a plain text document without much fanfare, and one that carries portable data in a way that proprietary formats do in spreadshees.

It is a universal truth that textsmiths work with data formats. Yet formats are attempts to impose structure on messy reality, but no format can decide what the right structure is for you. So in this article, we are going to look at what data cleaning is.