Cleaning Your Data With Openrefine (Workshop - Professional Development) #182041

Import to your Calendar

OpenRefine is an open sourced, java-based, powerful tool that lets you clean your messy data easily and in ways Excel and other traditional spreadsheet software programs cannot. In this 2 hour hands-on workshop you will learn how to explore your data, how to clean and transform it, and how to automate processes. Go beyond “find and replace” to find all variations of a term (i.e., UC, U.C., Univ. of Cinci., University of Cincinnati, U Cincinatti) to correct errors, to group like categories together, to convert columns to new formats, to make mistakes, and to fix them.
 
Participants should follow the directions to download the latest stable version of OpenRefine at this URL https://openrefine.org/download.html 

Note – you may need to install Java separately.

Please, follow instructions to connect to the session in the Reminder Email sent by the FEC.

Course Details
Thursday, October 21, 2021
From 1:00 PM to 3:00 PM
Rebecca Olson
This session will be presented virtually.

Presenter: Rebecca Olson

Rebecca Olson, Informationist for Business and Social Science. 

Rebecca Olson is a member of the Research and Data Services department at the UC Libraries. She is one of the designated reps on campus for ICSPR and helps everyone on campus find data, places to store their data, and how to use that data.