Cleaning Data with OpenRefine: Data Preparation

OpenRefine has a variety of functions for organizing, analyzing, and expanding your data quickly and simply.

• Common Transformations - For quick changes to column values

• Removing Duplicate Data - Remove data that has been erroneously entered multiple times.

• Splitting Column Values - Break down your columns into more useful divisions based on a delimiter.

• Merging Column Values - Consolidate extraneous columns into one.

• Transposing Data - Rearrange how the data is presented within the spreadsheet.

• Clustering - Identify misspelled data values in your spreadsheet.