Using OpenRefine to Standardize and Augment Your Data
- Conference Year
- Online Northwest 2017
- Session
- 2
- Type
- Breakout Session
- Presenters
- Blake Galbreath, Washington State University
- Abstract
As librarians, we work with an ever-increasing amount of data and metadata. However, these data are often messy, disorganized, and seemingly disparate from other caches of data. Free tools such as OpenRefine allow us to clean, organize, and connect data sets to one another – all without knowing how to write complicated code. In this presentation, I will demonstrate the refining I have undertaken to create better and more usable data sets.
- Learning Outcomes
- Learn how to install OpenRefine
- Learn how to use the tools in OpenRefine to standardize data:
- Facets
- Transformations
- Clusters
- Filters
- Learn how to augment your data with data from web services
- Learn how to use the Google Refine Expression Language
- Links