OpenRefine is a program used to clean and format data reproducibly with track changes. This workshop is targeted towards new users of OpenRefine working with humanities data, particularly categorical data. We will be working with a dataset of open-access articles from the Directory of Open Access Journals.

By the end of this workshop, learners should be able to:

• clean and format data
• use GREL (Google Refine Expression Langauge) expressions for data transformation

For any questions, please contact the instructor at bwright23@ou.edu.

Requirements

• Pre-requisites: No prior knowledge is needed, but you will need to bring a laptop in order to follow along with this workshop.
• Software requirements: 
  • Have this data file downloaded. We will be using JupyterLab to work with OpenRefine
• Registration is: required.
• Minimum registrations for workshop to be hosted is 10.

Accessibility

• Materials
  • The curriculum is freely available online at: https://librarycarpentry.github.io/lc-open-refine/.
• Format
  • This workshop will be offered in person.
• Scheduling
  • This workshop is typically offered once per semester. 
  • This workshop can also be scheduled on request. 
  • We have two scheduled breaks, at a rate of about one per hour.
• Captioning
  • Automatic captioning will be provided via Zoom.
• Food/drinks
  • Food and drinks are not provided.
  • Food and drinks are allowed in the classroom.
  • Water fountains are available on all floors.
  • Bizzell Memorial Library has a coffee shop on LL1 (hours may vary) and vending machines on LL1, in the hall east of LL118 (the community room).
• Restrooms
  • Gendered restrooms are available on the same floor.
  • Family restrooms are available on the same floor.
• For additional accommodations on the basis of disability, please contact the workshop instructor bwright23@ou.edu.