Library Carpentry OpenRefine

This Library Carpentry lesson introduces librarians to working with data in OpenRefine. At the conclusion of the lesson you will: understand what the OpenRefine software does; use the OpenRefine software to work with data files.


To complete this lesson you will need Firefox web browser and OpenRefine. If not already installed, you will need to install Firefox and OpenRefine.


Setup Download files required for the lesson
00:00 1. Introduction to OpenRefine What is OpenRefine? What can it do?
00:15 2. Importing data into OpenRefine How do I get data into OpenRefine?
00:30 3. Layout of OpenRefine, Rows vs Records How is data organised in OpenRefine?
How do I access options to amend data in OpenRefine?
What is the difference between Rows and Records in OpenRefine?
How do I work with single cells that contain multiple values in a list?
00:45 4. Faceting and filtering What is a facet in OpenRefine?
What is a filter in OpenRefine?
How can I use filters and facets to explore data OpenRefine?
How can I easily correct common data issues in my data with OpenRefine?
01:05 5. Clustering What is Clustering in OpenRefine and when woud you use it?
How does clustering work in OpenRefine?
01:25 6. Working with columns and sorting How do I move, rename or remove columns in OpenRefine?
How do I sort data in OpenRefine?
01:35 7. Transformations How do I use transformations to programmatically edit my data?
How do I use GREL, the General Refine Expression Language?
How do I save and reuse a set of operations for use in subsequent projects?
What are the data formats supported by OpenRefine and why should I care?
02:35 8. Advanced OpenRefine functions How do I fetch data from an Application Programming Interface (API) to be used in OpenRefine?
How do I reconcile my data by comparing it to authoritative datasets
How do I install extensions for OpenRefine
03:05 Finish

The actual schedule may vary slightly depending on the topics and exercises chosen by the instructor.