Data Cleaning in OpenRefine 

Description

Do you work with data in spreadsheets? Are you tired of editing spreadsheets cell-by-cell to clean your data? This Johns Hopkins 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 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.