Research Guides: DPDS Social Sciences Workshop Resources: Examining Numbers

Examining Numbers in OpenRefine

Objectives:

1. Transform a text column into a number column.
2. Identify and modify non-numeric values in a numeric column using facets.

Key Points:

1. OpenRefine also provides ways to examine and clean numerical data.

Examining Numbers in OpenRefine Video Demonstration
Watch the workshop zoom video demonstration examining numbers in OpenRefine. Video length is 6 minutes 37 seconds.
Social Science Workshop Registration
Register for the Social Science Workshop to gain hands-on experience and practice section objectives.

Examining Numbers in OpenRefine Guide
Workshop guide provided by Data Carpentry that explains transforming column contents to numbers, and using a numeric facet.
OpenRefine Manual: Exploring Facets
Provides an overview of facets with examples, and explains the different types of facets and how to use them.
OpenRefine Manual: Cell editing
Provides an overview of features for editing and improving the contents of cells like using the undo/redo function and using transforms like trim leading and trailing whitespace.