I'm not sure how much you want to open this guide up to discussing specific methods for fixing these problems, but given that you already mention manual spelling correction, it might be worth noting OpenRefine's clustering function as an invaluable aid for working through that particular data issue.
I'm not sure how much you want to open this guide up to discussing specific methods for fixing these problems, but given that you already mention manual spelling correction, it might be worth noting OpenRefine's clustering function as an invaluable aid for working through that particular data issue.
:+1: for a marvelous guide!