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.
Cleaning data
Click on the Clean tab in the toolbar.
This is the Cleaning Configuration page, specifically the default configuration.
Cleaning configurations produce higher quality analysis and visualizations by removing errors and extraneous data. The… Read more.
Once you log in, you’ll be taken to your dashboard where you build a new dataset or access old ones.
Select Build New Dataset to create a new query.
Fill in the filters with your search parameters.
The visualization on the right will automatically… Read more.
Table of Contents
Our tutorial for the Digital Scholar Lab (DSL) includes the introductory page you are reading, plus six major sections. Click on any of the links below to jump to the relevant tutorial. We suggest following them in order:
Access… Read more.
This tutorial has been developed for OpenRefine version 3.7.5
Sometimes when you construct an API call and use the Add Column by Fetching URLs feature, it won’t work. In these cases, you can use python to help. So far we’ve been writing GREL… Read more.
This tutorial has been developed for OpenRefine version 3.7.5
You may have noticed from Activity 2 that sometimes you searched for a property to add from Wikidata, but got an error. Other times you might want to augment your dataset with data that… Read more.
This tutorial has been developed for OpenRefine version 3.7.5
To learn more about reconciliation services and how you can use them to augment your data, check out the official OpenRefine guide to reconciling Feel free to read just the introduction… Read more.
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. This activity will showcase some new concepts and features for OpenRefine, as well as… Read more.
In this activity, you are going to:
Create a new project by making an API call to pull in data and parse the resulting JSON
Manipulate the data by using GREL date expressions and facet the data to make discoveries
Create a new project by… Read more.
In this activity, you are going to:
Open regex101.com and load some sample data
Practice some regex basics
Use regex in OpenRefine
Open regex101.com and load some sample data
1. Browse to the website regex101.com. The REGULAR EXPRESSION box at the… Read more.