Data Organization, Data Cleaning, and OpenRefine (Zoom)

Tidy data is a data format that is consistent and machine readable. In the first session, we will explore what makes data "tidy" beginning with good data entry practices, formatting data tables in spreadsheets, avoiding common formatting mistakes, and approaches for handling dates in spreadsheets. The second session will introduce OpenRefine, a powerful, free tool for working with messy data to clean and transform it from one format to another. This lesson will teach you to use OpenRefine to clean and format data effectively 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.

**This workshop series is offered in collaboration with the University of Central Oklahoma**