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.
Prerequisites
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) |