Academic Strategies: Cleaning Messy Data Using Excel and OpenRefine
Event box
Academic Strategies: Cleaning Messy Data Using Excel and OpenRefine Online
Once you have the dataset you will be working with, you need to clean it up before running it through statistical software such as R. Excel and OpenRefine are most useful where you have data in a simple tabular format such as a spreadsheet, a comma separated values file (csv) or a tab delimited file (tsv) but with internal inconsistencies either in data formats, or where data appears, or in terminology used.
Workshop attendees will learn how to resolve inconstancies in their data, combine datasets, and sort data.
See the full list of workshops in the Academic Strategies series here.
Any student who participates in at least 3 library workshops during the Fall 2023 semester will be eligible for a prize. Learn more about the Workshop Incentive Program.
- Date:
- Friday, October 13, 2023
- Time:
- 3:00pm - 4:00pm
- Time Zone:
- Eastern Time - US & Canada (change)
- Online:
- This is an online event. Event URL will be sent via registration email.
- Categories:
- Graduate Students Marx Science and Social Science Library