Event box
Data Cleaning and OpenRefine for Social Scientists Online
Presenter: Alexandra Wong and Priscilla Carmini
An important part of the data workflow is preparing data for analysis. OpenRefine is a powerful free and open source tool for working with messy data: cleaning it and transforming its formats.
- Date:
- Wednesday, November 2, 2022
- Time:
- 1:00pm - 4:00pm
- Time Zone:
- Eastern Time - US & Canada (change)
- Audience:
- Faculty Graduate Students Undergraduate Students
- Categories:
- Data Skills Research Support Software Tools
- Online:
- This is an online event. Event URL will be sent via registration email.
An important part of the data workflow is preparing data for analysis. Some of this involves data cleaning, where errors in the data are identified and corrected or formatting made consistent. This step must be taken with the same care and attention to reproducibility as the analysis. OpenRefine is a powerful free and open source tool for working with messy data: cleaning it and transforming it from one format into another. This workshop will teach you to use OpenRefine to effectively clean and format data and automatically track any changes that you make. Many people comment that this tool saves them literally months of work trying to make these edits by hand.
By the end of the workshop, participants will be able to:
- Understand the kinds of challenges presented by raw data
- Install and use the OpenRefine tool on your own computer
- Use several time-saving techniques to cluster, clean, and process your data