Workshop: OpenRefine

OpenRefine

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)