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 OpenRefine to complete this lesson.
| Setup | Download files required for the lesson | |
| 00:00 | 1. Notes: 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. 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 | 4. 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 | 5. 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.