OpenRefine Lessons for Digital Humanities

This Library Carpentry lesson introduces working with digital humanities 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.


You will need to install Firefox and Open Refine 2.6 to complete this lesson.


09:00 Introduction to OpenRefine What is OpenRefine? What can it do?
09:15 Importing data into OpenRefine How do I get data into OpenRefine?
09:30 Basic OpenRefine functions I: Working with columns, sorting, faceting, filtering and clustering How do I move, rename or remove columns in OpenRefine?
How do I sort data in OpenRefine?
How can I work with a subset of my full data set in OpenRefine?
How can I easily correct common data issues in my data with OpenRefine?
10:30 Basic OpenRefine functions II: How do I edit my data based on filters and facets?
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?
11:30 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
12:00 Finish and next lesson (SQLite for Librarians)