LibGuides: OpenRefine: Data Preparation and Normalization

Data Preparation and Normalization

OpenRefine offers a wide variety of functions for normalizing, expanding, and preparing your data quickly and efficiently. Whether it’s correcting misspelled values, removing unnecessary duplicates, or combining or splitting values, OpenRefine has a function designed to make cleaning your data a simple and thorough process.

Common Transformations
Make quick changes to column values using preset transformation functions.
Removing Duplicates
Remove unnecessary duplicate values within a selected column.
Splitting Cell Values
Separate multi-valued cells into more useful divisions, either into new columns or into a multi-row record.
Combining Cell Values
Combine values from across different columns into one column.
Data Shaping
Transpose information between rows and columns to visualize the information in a different arrangement.
Clustering
Identify possible matching values within a selected column.

5/3/2018 - Brinna Michael