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.

Prerequisites

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

Schedule

00:00 Introduction to OpenRefine What is OpenRefine? What can it do?
00:15 Importing data into OpenRefine How do I get data into OpenRefine?
00: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?
01: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?
02: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
03:00 Finish

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