Transforming data

  • Permanent “view” changes (not data changes, quite) like rearranging columns, removing columns, and renaming columns.

Edit cells

Overview

Transform

  • Transform…
  • Common transforms
    • Trim / Collapse
    • Unescape
    • Replace
    • Case
    • Data type
    • To null/empty

Fill down

Blank down

Split multi-valued cells...

Join multi-valued cells...

Cluster and edit...

Replace

Edit column

Overview

Split or Join

Add column based on this column

Add column by fetching URLs

Add columns from reconciled values

Rename or Remove

Move

Transpose

Overview

Transpose cells across columns into rows

Transpose cells in rows into columns

Columnize by key/value columns

Reconcile

Overview

Sources

https://github.com/OpenRefine/OpenRefine/wiki/Reconcilable-Data-Sources

Functions

  • Match each cell to its best candidate
  • Create a new item for each cell
  • Create one new item for similar cells
  • Match all filtered cells
  • Discard all reconciliation judgments
  • Clear reconciliation data
  • Copy reconciliation data
  • Use values as identifiers
Last updated on by allanaaa