This Library Carpentry lesson (shorten version) introduces librarians to working with data in OpenRefine. At the conclusion of the lesson you will understand what the OpenRefine software does and how to use the OpenRefine software to work with data files.
Information about the development of this shortened version can be found on the lc-open-refine-short wiki page
Prerequisites
To complete this lesson you will need a web browser and OpenRefine. If not already installed, you will need to install OpenRefine.
| Setup | Download files required for the lesson | |
| 00:00 | 1. Introduction to OpenRefine | What is OpenRefine? What can it do? |
| 00:05 | 2. Importing data into OpenRefine |
How do I get data into OpenRefine?
How is data organised in OpenRefine? How do I access options to amend data in OpenRefine? |
| 00:15 | 3. Faceting - Filtering - Splitting |
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? |
| 00:25 | 4. Clustering |
What is Clustering in OpenRefine and when would you use it?
How does clustering work in OpenRefine? |
| 00:45 | 5. Undo and Redo | How do the Undo and Redo features work? |
| 00:50 | 6. Introduction to Transformations |
How do I use transformations to programmatically edit my data?
What are the kind of transformations Open Refine supports? What is GREL? |
| 01:00 | 7. Writing Transformations |
Where do I write GREL expressions in the OpenRefine interface?
How do I write a valid GREL expression? |
| 01:15 | 8. Transforming Strings, Numbers, Dates and Booleans |
How do I use transformations to programmatically edit my data?
How do I transform the various data types? |
| 01:25 | 9. Exporting | How do I export transformed data? |
| 01:30 | Finish |
The actual schedule may vary slightly depending on the topics and exercises chosen by the instructor.