Do you work with data in spreadsheets? This JHU Data Services workshop will teach you how to process and standardize your tabular data efficiently and reproducibly using OpenRefine. OpenRefine is a free, open-source tool with a graphical user interface (GUI) to process and organize data – no coding required! The bulk of this 2.5-hour workshop will be a hands-on tutorial processing a dataset in OpenRefine.
After taking this workshop, participants will:
- Be able to target features of a given dataset that require processing and standardization
- 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
