Using OpenRefine for Library Metadata

$250.00

Dates: October 7 - November 3

Credits: 1.5 CEUs or 15 PDHs

OpenRefine is a free open-source tool that makes editing messy metadata easier through clustering, faceting, advanced find and replace scripting, and linked data reconciliation in a spreadsheet-like environment. In addition to cleaning up metadata, OpenRefine’s linked data and URL building tools can extend metadata through databases and API calls.

This course will introduce OpenRefine from a beginning level with installation, introduce how to effectively use standard features, and go on to introduce more advanced features such as reconciliation against Library of Congress Subject Headings linked data and creating an API call.

Learning outcomes:

  • Students will be able to install and run OpenRefine on their computers.
  • Students will be able to edit a spreadsheet file with simple errors.
  • Students will be understand the role of clustering, faceting, and searching in editing data.
  • Students will be able to construct a simple API call to search against their data.
  • Students will be able to install a simple reconciliation extension service.

Note: Students may want to use the following book as background material for the course. It is widely available in libraries: Ruben Verborgh and Max De Wilde, Using OpenRefine (Birmingham: Packt Publishing, 2013) http://www.worldcat.org/oclc/889271264

This course can be taken as one of eight courses needed to earn our Certificate in Cataloging and Technical Services, but can be taken as a stand-alone course as well.

Category:
Instructor:

Course Information

Session

Credits

1.5 CEUs or 15 PDHs

Registration dates

We accept registrations through the first week of classes, unless enrollment is full, and unless the class was canceled before it started due to low enrollment.

Course Description

OpenRefine is a free open-source tool that makes editing messy metadata easier through clustering, faceting, advanced find and replace scripting, and linked data reconciliation in a spreadsheet-like environment. In addition to cleaning up metadata, OpenRefine’s linked data and URL building tools can extend metadata through databases and API calls.

This course will introduce OpenRefine from a beginning level with installation, introduce how to effectively use standard features, and go on to introduce more advanced features such as reconciliation against Library of Congress Subject Headings linked data and creating an API call.

Learning outcomes:

  • Students will be able to install and run OpenRefine on their computers.
  • Students will be able to edit a spreadsheet file with simple errors.
  • Students will be understand the role of clustering, faceting, and searching in editing data.
  • Students will be able to construct a simple API call to search against their data.
  • Students will be able to install a simple reconciliation extension service.

Note: Students may want to use the following book as background material for the course. It is widely available in libraries: Ruben Verborgh and Max De Wilde, Using OpenRefine (Birmingham: Packt Publishing, 2013) http://www.worldcat.org/oclc/889271264

This course can be taken as one of eight courses needed to earn our Certificate in Cataloging and Technical Services, but can be taken as a stand-alone course as well.

Greer Martin

Greer MartinGreer Martin is the Metadata Technologies Librarian at Loyola University Chicago, where she coordinates metadata interoperability across library platforms. She has written and presented on using OpenRefine for metadata cleanup and authority reconciliation, and has managed metadata migration projects. Greer previously held metadata librarian positions at the Illinois Institute of Technology and the University of Georgia where she created and enhanced metadata for aggregation by Digital Public Library of America. She received an MLIS from the University of Illinois at Urbana-Champaign.

How to Register

To enroll yourself or other participants in a class, use the “Register” button that follows the description of each course. If the “Register” button does not show up, try loading the page in a different web browser. Contact us if you have technical difficulties using our shopping cart system or would like to pay for an enrollment using another method. On the payment page in the shopping cart system, there is a place to add notes, such as the names and email addresses of participants you wish to enroll. We will contact you to request this information in response to your processed payment if you do not include it in the “notes” field. Prior to the start of the workshop, we will send participants their login instructions.

Payment Info

Our shopping cart system allows you to pay with a credit card, or with PayPal.

Alternatively, if it is an institutional payment, we can arrange to invoice you. Contact us by email, and we can make arrangements to suit your institution's business processes.

Special Session

Please contact us to arrange a special session of this class for a group of seven or more, with a negotiable discount, or to be notified when it is next scheduled.

Reviews

There are no reviews yet.

Be the first to review “Using OpenRefine for Library Metadata”

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.