One of the most frustrating aspects of data journalism is that, even when data is publicly available and easy to download, it is often in a format that’s nearly impossible to work with. The congressional election results
that the Federal Election Commission maintains are a perfect example. The vote totals for every candidate in every race are all tossed into one large, poorly documented Excel file. Some candidates appear multiple times under different parties, which are listed on a separate sheet.