Skip to main content Start main content

Workshop: OpenRefine

Workshop/ Training/ Webinar



Date: 11 Oct

Time: 14:30 - 17:00

Target Audience: All Students

Medium of Instruction: English

Pre-requisite: N/A

What you will learn

  • After completion of the workshop, you are able to handle messy data by the free tool -- OpenRefine.
  • You will learn how to install OpenRefine, exploring data and transforming data to the format you need.


Course outline

  1. What is OpenRefine?
  2. Why OpenRefine?
  3. Getting Open Refine
  4. Creating a Project
  5. Exploring data
    1. Data Type
    2. Facets
    3. Cluster
    4. Filter
    5. Sort and view
  6. Editing cells and columns
    1. Reorder and remove columns
    2. Join Dataset
    3. Remove blank rows
    4. Remove duplicates
    5. Remove whitespace
    6. Change data format
    7. Reconciliation
    8. Undo/Redo
  7. Export Dataset
  8. Google Refine Expression Language (GREL)

Your browser is not the latest version. If you continue to browse our website, Some pages may not function properly.

You are recommended to upgrade to a newer version or switch to a different browser. A list of the web browsers that we support can be found here