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, 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

Software / Account Requirements:

Download and install the latest version of Open Refine.

If you have any issues with your install, please contact the IT Help Desk. 

PLEASE NOTE:

When you register for this workshop you are committing to attend the entire workshop unless otherwise confirmed with the instructor. This workshop is limited to 12 attendees. If you are suddenly not able to attend, please contact us as soon as possible so that we can offer your spot to someone on our waiting list.

You must have all required software installed and working ahead of the workshop. We cannot troubleshoot software during the session. If you are not able to get it working ahead of the meeting, please contact us as soon as possible so that we can offer your spot to someone on our waiting list.

This workshop will take place online via Zoom.  A reminder email with the meeting link will be emailed to you 24 hours before the workshop.