In this activity, you are going to:
Review the dataset and load it into OpenRefine
Perform some basic data cleanup to get familiar with the OpenRefine interface
Use OpenRefine to sort, filter and facet data
Transpose the data from wide format to… Read more.
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.
Posted:
Posted:
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… Read more.