Dealing with common and uncommon problems with parsing CSV with Ruby

At first glance, parsing CSV files with Ruby seems really straightforward and non-problematic. The same for the CSV format itself, it’s just a set of data separated mainly by commas. However, the practice is usually more problematic and complex, especially when you have to parse CSV files uploaded by users.You can assume that the file will be complete in terms of structure and appropriately encoded. The harsh truth is that files uploaded by users are often malformed, poorly formatted, or encoded. Some of them may even contain duplicated headers or empty rows. This article is a first-aid kit that you can use when you will spot any problems with parsing CSV.