Learn how to clean, standardize, and transform messy data using OpenRefine, a powerful open source tool for working with large or inconsistent datasets. This hands on session will introduce key features such as faceting, clustering, data transformation, and enrichment. OpenRefine runs locally in your web browser and works especially well with CSV and TSV files.

What You’ll Learn
•        How to explore and assess a dataset
•        Techniques for identifying and resolving inconsistencies
•        Ways to split, transform, and standardize data

Prerequisites
•        Install OpenRefine before the workshop by going to https://openrefine.org/
•        Basic familiarity with Excel or Google Sheets

Who Should Attend
Researchers, students, librarians, and anyone who works with structured data and wants faster, more reliable cleanup workflows.

This workshop is offered as part of UC Love Data Week. Advance registration required.

Questions? Contact datalab-training@ucdavis.edu.