OpenRefine How-Tos

General help and support with Refine

To get started with OpenRefine and the GOKb extension, visit our tutorial.

The Open Refine wiki (https://github.com/OpenRefine/OpenRefine/wiki) contains basic information on using Refine, including common 'recipes' for data transformation.

The Open Refine mailing list is active and can often help with advice on how to best use Refine to solve specific problems: http://groups.google.com/d/forum/openrefine

The 'How-Tos' below deal with specific tasks/transformations relevant to GOKb. 

How-Tos

Columns

• Column names and requirements
• Working with columns
  

Comparing two sets of data in Refine

• Simple comparison example
• Comparison with titles example
• Comparison using iterative matching example
• Normalising a Title

Dates

• How to format common dates into a correct GOKb date

• DateLastPackageIssue date issues

• Interpreting Seasons as dates

De-duplicating Lists

Expected TIPPs

Exporting a project

Looking up Controlled Values

Repeated Errors

Rows

• Adding rows
  • Prepend Rows function
  • "Split multi-valued cells" method
• Removing rows

Titles

• Uppercase words in titles

Transformations

• Macros
• Quick Fix Transformations

Requested

• Dealing with multi-package files in Refine