Cleaning Data with OpenRefine Part 1 (Online)

 
Data sets often have problematic content such as formatting inconsistencies and incomplete elements that are beyond the capabilities of spreadsheet programs like Excel to deal with easily. OpenRefine is a powerful tool for working with messy data. It will help you do things like standardize date formatting; split up cells with multiple authors into separate cells; match local data up to other data sets; and enhance a data set with data from other sources. Part 1 of this workshop will focus on the basic functions of OpenRefine. Part 2 will focus on advanced features like fetching data from APIs, reconciling data by comparing it to external data sets, and looking at extensions to OpenRefine to perform other tasks.

This session requires you to have access to OpenRefine. Please follow the instructions on the registration page to download the software.

Instructor: David Romito

Additional course information:

• This series will be offered via Zoom ONLY. Registration closes 24 hours before the start of the workshop.
• Zoom link for this course will be sent prior to the course. Registration must be made at least 1 day prior to the course date to receive the Zoom link.