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: 
 http://openrefine.org/download.html

You should install the version called "OpenRefine 3.2" at the top of the page (not the beta version).

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