Event box

Data Cleaning in OpenRefine 

Wednesday, April 21, 2021
1:00pm - 3:30pm
Registration has closed.

Do you work with data in spreadsheets? Are you tired of editing spreadsheets cell-by-cell to clean your data? This JHU Data Services workshop will teach you how to clean and standardize your data efficiently and reproducibly using OpenRefine. OpenRefine is a free, open source tool with a graphical user interface (GUI) to clean and organize data - no coding required! This workshop will start with an overview of OpenRefine and what it means to have "clean" data. Instructors will provide a dataset and lead a hands-on tutorial to show common data cleaning steps in OpenRefine. The workshop will focus on cleaning text-based spreadsheets to prepare data for further analysis.