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.
|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
The actual schedule may vary slightly depending on the topics and exercises chosen by the instructor.