Library Workshops and Events
VIRTUAL--Library Carpentry--OpenRefine (Session 2 of 2)
Connect via Zoom: a URL to join the Zoom session will be emailed to you several hours 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 email@example.com with any questions or issues.
This session further explores the features of OpenRefine. We’ll useOpenRefine 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.
Work with columns and sorting to reorder, rename, remove, and sort columns
Understand common transformations
Use transformations to programmatically edit data
Use GREL, the General Refine Expression Language and write a valid GREL expression
Save and apply a set of steps to a new set of data using the “Extract” and “Apply” features
Transform Strings, Numbers, Dates and Booleans
Use Arrays in data transformation
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.
Use your own laptop. You need to install OpenRefine and download a 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 firstname.lastname@example.org.
This workshop is part of a series. You can take this workshop to build toward completion of either the Software or Library Carpentries lesson series. This workshop is taught by a Carpentries-certified instructor.
- Thursday, April 9, 2020
- 4:00PM - 5:00PM
- Natalie Meyers
- CDS | Carpentries Workshops