OpenRefine: Information, Tutorials, and Workshops
Getting started
- Please visit our tutorial on installing OpenRefine
OpenRefine
To build your skills in OpenRefine, we suggest following our tutorials in this order:
i. (Optional) OpenRefine Installation Instructions
ii. OpenRefine Tutorial 1. Survey of Household Spending Activity
iii. OpenRefine Tutorial 2. Citizen Science Activity
iv. OpenRefine Tutorial 3. Regular Expressions (Regex) Activity
v. OpenRefine Tutorial 4. 311 Calls Activity
vi. OpenRefine Augmenting Activity 1: Preparing the data
vii. OpenRefine Augmenting Activity 2: Using Reconciliation Services
viii. OpenRefine Augmenting Activity 3: Using Add Column by Fetching URLs
ix. OpenRefine Augmenting Activity 4: Using Python
Please note that we also have converted some of this tutorial into a self-paced course with videos. U of T students, staff, and faculty can enroll in our OpenRefine Quercus course.
OpenRefine Augmenting Activity 4: Using Python
This tutorial has been developed for OpenRefine version 3.7.5
OpenRefine Augmenting Activity 3: Using Add Column by Fetching URLs
This tutorial has been developed for OpenRefine version 3.7.5
OpenRefine Augmenting Activity 2: Using Reconciliation Services
This tutorial has been developed for OpenRefine version 3.7.5
OpenRefine Augmenting Activity 1: Preparing the data
We are going to work with a different dataset for the next few activities. In order to start augmenting the dataset, we need to do a bit of preparation work first.
OpenRefine Tutorial 3. Regular Expressions (Regex) Activity
In this activity, you are going to:
OpenRefine Tutorial 2. Citizen Science Activity
In this activity, you are going to:
Create a new project from the citizen science dataset and use the clustering feature
OpenRefine Installation Instructions
OpenRefine, formerly GoogleRefine, is a free and open-source program to clean data.
1. Download a copy of OpenRefine. We recommend downloading the latest "final release" and not a "beta" or "release candidate" version.