OpenRefine is a Java-based power tool that allows you to load data, understand it, clean it up, reconcile it, and augment it with data coming from the web. All from a web browser and the comfort and privacy of your own computer.
OpenRefine is used to standardize the fields in order to eliminate any discrepancies that may affect the results for any dataset that is used for analysis.
Example Use Cases
Data Cleaning for City of Las Vegas