Hardin Open Workshops - Data: Reviewing and Cleaning Up Spreadsheet Data with OpenRefine
Nov 29, 2022
11:00 AM - 12:00 PM
600 Newton Road, Iowa City, IA 52246
Nearly everyone works with data in spreadsheets or tables. This workshop will provide you with hands-on experience in using a free tool, called OpenRefine, to check data in spreadsheets, and fix some common issues, from typos to splitting columns. OpenRefine is easy to use, will save you a lot of time, and it keeps track of the changes you’ve made so you can reuse them or roll them back.
This workshop can be tailored for specific groups and disciplines. Follow-up sessions and individual consultations are also available. If you have a data set that you would like to work on, contact the instructor for a consultation.
Prior to the workshop, please install the Release Version of OpenRefine on your laptop: https://github.com/OpenRefine/OpenRefine/wiki/Installation-Instructions
Individuals with disabilities are encouraged to attend all University of Iowa–sponsored events. If you are a person with a disability who requires a reasonable accommodation in order to participate in this program, please contact in advance at