Do you have a research dataset in need of review and cleaning? OpenRefine, an open-source software for data cleanup and transformation, can help you interpret and remediate tabular data, including spreadsheet data. During this workshop, we explored how OpenRefine can help maximize the usefulness of your data and learn general organizational tricks to optimize the responsiveness of your dataset. The workshop was divided into two sections: the first, a discussion of how OpenRefine can solve your data cleaning needs, and the second, a demonstration focused on troubleshooting issues and the more advanced and specific functions of OpenRefine.
Daniel Peart, data services librarian, and Michael Stewart, metadata librarian, led the workshop. This virtual workshop was co-sponsored by the Graduate College.