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.
Post Date:
Post Date:
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.
2. If… Read more.