**Are you struggling with cleaning and organizing your large data sets?**
Consider registering for our upcoming workshop introducing participants to using OpenRefine for data cleaning. OpenRefine is an open source application for data cleaning and transformation, also known as data wrangling. OpenRefine allows you to view and manipulate large quantities of data, making it an excellent tool for wrangling big data sets.
By the end of this workshop, participants will gain experience conducting key data cleaning practices, including:
* Removing duplicate records
* Analyzing the occurrence of values throughout a data set
* Clustering and standardizing values
* Separating multiple values contained in the same field
* Joining multiple values contained in separate fields
_This session is part of the [Pathways to Research Data Management series](https://libguides.uvic.ca/c.php?g=721709)._
---
## Activity Instructions
**Pre-class activities:** 15 min
**Face-to-face presentation:** 15 min
**Face-to-face activities:** 60 min
**Presenter:** Shahira Khair (skhair@uvic.ca)
---
**Step 1: Pre-Class Videos, Readings, & Exercises**
* [Install OpenRefine](https://openrefine.org/download.html) (follow the instructions for your operating system)
* [Watch Introductory YouTube video](https://www.youtube.com/watch?v=B70J_H_zAWM)
**Step 2: Download In-Class Active Learning Activities & Instruction**
* [Presenter slides](https://docs.google.com/presentation/d/1fcX0a2q3xpS4H9lG-VqNF8USYfwEt23KzKrkAFi2eO4/edit?usp=sharing)
* [Activity instructions](https://docs.google.com/document/d/1dYUoVqcOn05M-En6Z8t-TGyqFNdZXoGNG7peVkONDB0/edit?usp=sharing)
* [Dataset 1: Samuel Maclure](https://osf.io/ye6jp/)
* [Dataset 2: McTaggart Cowan](https://osf.io/u6z4q/)
**Step 3: More Resources, Post Class Assessment & Course Feedback**
* [Using OpenRefine guidebook](http://ezproxy.library.uvic.ca/login?url=http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=639455) (E-book available from UVic Libraries)
* [Online Guide to OpenRefine](https://guides.library.illinois.edu/openrefine/grel) (University of Illinois Urbana Champaign Library)
* [GREL Recipes](https://github.com/OpenRefine/OpenRefine/wiki/Recipes) (OpenRefine Github webpage)
