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.