Data Cleaning in OpenRefine

Description

Do you work with data in spreadsheets? This Johns Hopkins Data Services workshop will teach you how to clean and standardize your tabular 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! The bulk of this 2.5-hour workshop will be a hands-on tutorial cleaning a dataset in OpenRefine.

After taking this workshop, participants will:

• Understand the common features of messy datasets
• Be able to carry out several transformations in OpenRefine to clean and standardize data for further analysis
• Leave with a test project that can be used to practice further data analysis or learn advanced features of OpenRefine, such as working with APIs