OpenRefine: Information, Tutorials, and Workshops

Getting started

• Please visit our tutorial on installing OpenRefine
• Please note that all computers in the Map and Data Library (on the fifth floor of Robarts Library), and the computer labs on the fourth and fifth floor of Robarts Library have OpenRefine installed

Learning resources

Online courses

• Working with Messy Data in OpenRefine, an online, self-paced course administered through Quercus

Workshops

• Working with Messy Data in OpenRefine

You can also download the sample dataset to follow along, or you can download the slides separately.

Beginner tutorials

• OpenRefine Tutorial 1: Survey of Household Spending Activity
• OpenRefine Tutorial 2: Citizen Science Activity
• OpenRefine Tutorial 3: Regular Expressions (Regex) Activity
• OpenRefine Tutorial 4: 311 Calls Activity

Intermediate tutorials

• OpenRefine Augmenting Activity 1: Preparing the Data
• OpenRefine Augmenting Activity 2: Using Reconciliation Services
• OpenRefine Augmenting Activity 3: Using Add Column by Fetching URLs
• OpenRefine Augmenting Activity 4: Using Python