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