Library Workshops and Events
Event Details
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 cds@nd.edu 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.
Objectives:
-
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 cds@nd.edu.
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.
- DATE
- Thursday, April 9, 2020
- TIME
- 4:00PM - 5:00PM
- PRESENTER
- Natalie Meyers
- CATEGORIES
- CDS | Carpentries Workshops
Contact Info
Hesburgh Library
University of Notre Dame
Notre Dame, IN 46556
hl-research-data-services-list@nd.edu | |
libguides.library.nd.edu/research-data-services |