This is the RefinePro knowledge base about OpenRefine. We build it over the years, and keep adding to it. From great tutorials and how-to, to handy GREL expressions and links to external resources, you will find here one of the most comprehensive list of resources to learn OpenRefine.

For a comprehensive documentation you should refer to the official OpenRefine wiki.

Don't where to get started? Search for a specific function below, or read our most popular article from the right side menu.

Showing posts with label editing. Show all posts
Showing posts with label editing. Show all posts

13.4.21

Edit value from the facet

 

I just can't believe we have not yet published a tutorial for this essential OpenRefine feature! 

When you select the edit option from the facet menu, you can edit all matching values in a column, similar to a search and replace function. Of course, the update is recorded in OpenRefine history and can be replicated on a similar dataset.

You can use the edit using facet to quickly clean up typos or misspelled cells. It is also useful to address duplicates that are either not detected by the clustering feature or caught in larger clusters with irrelevant matches. 

In this video example below, we replace the value US  to United States for 45 cells in one shot.


18.9.11

Google Refine 2.0 Training video

In this video you will learn to:

28.7.11

remove " (quotation) mark

Hard time removing the " (quote sign) from your expression. Instead of quoting your quote mark with double quote, do it with simple like this :

22.7.11

Remove or replace a specific character in a column

You want to remove a space or a specific character from your column like the sign # before some number.