What does HackerNews think of OpenRefine?
OpenRefine is a free, open source power tool for working with messy data and improving it
Language:
Java
#33
in
Java
I would suggest https://github.com/OpenRefine/OpenRefine to clean your data.
It was openSourced as OpenRefine. https://github.com/OpenRefine/OpenRefine
Have you heard of OpenRefine, formerly Google Refine? https://github.com/OpenRefine/OpenRefine