A recurring theme at the New York Times’ Open Government event was the pain involved in taking public data and making it usable. I’ve done very little data cleaning, but enough that I know it is a pain in the ass. ProPublica’s guide almost makes it seem easy.
ProPublica's Guide for Collecting Data