Tutorial 1

Tutorial: Data Cleaning with OpenRefine

Teacher: Natkamon Tovanich

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 download and install it from here.
• You should install the "OpenRefine 3.7.7" at the top of the page (not the beta version).
• Download the following dataset: UniversityData.csv
• The tutorial instructions are available in this Google Docs.

References

• The Open Refine documentation is available here.
• Here is the pointer to the Open Refine Expression Language.

Reminder

• Install Tableau in advance of the tutorial in the next two weeks. You could request a free student license here. It took a few days for Tableau to validate your student card. Please be sure to be prepared.
• Make sure you install Jupyter Notebook and Altair library or create Google Colaboratory account for the next tutorial. See the instructions in Altair tutorial page