Library Workshops and Events

Event Details

VIRTUAL--Library Carpentry--OpenRefine (Session 2 of 2)

OPEN TO:
-Faculty -Graduate Students -Postdocs -Public, Alumni, & Friends -Staff -Undergraduate Students

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
Registration has closed.

Contact Info

Profile photo of Research Data Services Team
Research Data Services Team