OpenRefine

OpenRefine: Reliable tool that will help manage messy data sets and clean inconsistencies that will lead to errors.

OpenRefine is a reliable tool that was created in order to help users easily manage their messy data sets, and also clean inconsistencies that will eventually lead to errors, and will provide the means to import data sets.

Users will also be able to include web services into their data sets, which will be very useful for when they need to connect to their database to a new infrastructure, and will also come with a reconciliation function that lets the user link text names in their data in order to create identifiers.

Users will need to complete that entail weeb scraping, analyzing Apache logs, translating street addresses to coordinate with latitude, longitude and just removing duplicate row values.

Overall, OpenRefine is a great tool that was designed to help users manage their messy data sets without any effort, and also clean inconsistencies that will commonly lead to errors.