Before we are able to analyze or visualize our data, we have to clean and prepare it. Typical tasks include fixing spelling, removing duplicate rows, finding and replacing text, changing number formats, and merging and splitting columns.

OpenRefine is a powerful data manipulation tool that cleans, reshapes and edits batches of messy and unstructured data. When using OpenRefine to clean and transform data, you can easily facet, cluster, edit cells, reconcile and extend web services to convert a dataset to a more structured format.

By the end of this workshop you will be able to:

• explain the importance of cleaning your data
• complete basic data cleaning tasks using OpenRefine

You must download and install the latest version of Open Refine. If you have any issues with your install, please contact the IT Help Desk.