Tutorial 1-2022

Data wrangling with OpenRefine

In this tutorial, you will learn to use Google Refine to clean a dataset and create files for analysis. We will perform some cleaning together in class.

Getting Started

• Install Google Refine. You can install download and install from here.
• You should install the version called "OpenRefine 3.2" at the top of the page (not the beta version).
• Download the following dataset: UniversityData.csv

References

• The documentation for Google Refine / Open Refine is available here.
• There are also a set of nice introductory tutorials available on YouTube: Part 1, Part 2, Part 3.
• Here are helpful pointers to the Open Refine Expression Language.
• If you have not been in class, follow this tutorial after having watched the videos above: http://enipedia.tudelft.nl/wiki/OpenRefine_Tutorial

Reminder

The tutorial next week will give an introduction about Tableau. Please install Tableau in advance. You could request a free license as students here.