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.
|Setup||Download files required for the lesson|
|00:00||1. 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. Layout of OpenRefine, Rows vs Records||
How is data organised in OpenRefine?
How do I access options to amend data in OpenRefine?
What is the difference between Rows and Records in OpenRefine?
How do I work with single cells that contain multiple values in a list?
|00:45||4. Faceting and filtering||
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?
What is Clustering in OpenRefine and when woud you use it?
How does clustering work in OpenRefine?
|01:25||6. Working with columns and sorting||
How do I move, rename or remove columns in OpenRefine?
How do I sort data in OpenRefine?
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:35||8. 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
The actual schedule may vary slightly depending on the topics and exercises chosen by the instructor.