Overview

This session further explores the features of OpenRefine. We’ll use OpenRefine to apply a set of steps to a dataset using the “Extract” and “Apply” features. We’ll be working with data types and regular expressions to write more complex transformations using General Refine Expression Language (GREL). We’ll use arrays in data transformation and learn how to export data in different formats.

Objectives

1. Work with columns and sorting to reorder, rename, remove, and sort columns
2. Understand common transformations
3. Use transformations to programmatically edit data
4. Use GREL, the General Refine Expression Language and write a valid GREL expression
5. Save and apply a set of steps to a new set of data using the “Extract” and “Apply” features
6. Transform Strings, Numbers, Dates and Booleans
7. Use Arrays in data transformation
8. Export data in different formats from OpenRefine

In this lesson we further use OpenRefine to manipulate and enhance datasets. Please review episodes 1-5 from the OpenRefine carpentries curriculum which we covered in the previous session before attending this workshop.

Connect via Zoom

Please register for this event. A URL to join the Zoom session will be emailed to you one hour before the workshop start time. To ensure access to the workshop from the virtual waiting room, your Zoom name should match the information provided when registering for the workshop. Please email cds@nd.edu with any questions or issues.

Prerequisites

You will need to install OpenRefine and download the data file doaj-article-sample.csv to follow the lesson in this session.

OpenRefine does not support Internet Explorer or Edge. For this session please use Firefox, Chrome or Safari instead. See Setup for more information. If you’d like help to address difficulties you encounter with setup, please contact cds@nd.edu.