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.

15.11.12

Finding (Nearly) Duplicate Items in a Data Column (from around the web)

10:26 AM  , , , ,

An other great article by Tony Hirst. This tutorial will show you how to use clustering function (ngram and fingerprint) directly in your facet. Really handy.

Read the full article.

Read More

7.11.12

From Excel file to RDF with links to DBpedia and Europeana (from around the web)

9:40 AM  , , ,

DERI Galway the author of the RDF extension (download and documentation here) show steps by steps how to use the RDF extension to reconcile your data against DBpedia and Europeana. This tutorial also go through the step to create an RDF schema

Read More
Read more »

6.11.12

Chit Chat with New Datasets – Facets in OpenRefine (Was /Google Refine/) (from around the web)

12:27 PM  , ,

A good review of faceting capability including text, numeric, timeline customized and scatterplot facet.

Read the full article 

Read More

31.10.12

Cleaning Date with Google Refine (from around the web)

12:55 PM  , , , , ,

Basic tutorial to clean up some date using OpenRefine. Great example of well structure GREL syntax to build complex transformation.

Read the full article on Hermanes Barbara's blog. 

Read More

26.10.12

Refine your EventBrite guestlist (from around the web)

9:26 AM  , ,

This recipe shows you how to use Google Refine to fetch details from your EventBrite account, and to explore your guest lists in detail. This tutorial show how to - use the Create Project via Web Addresses (URLs)' and - retrieve guest information using the EventBrite API.

The full article: http://www.opendatacookbook.net/wiki/recipe/a_refined_guestlist

Read More

22.10.12

A framework for the OpenRefine community

7:50 PM  

Following the results from the Google Refine Usage Survey, I would like to share a more personal vision of the birth of the OpenRefine community. The code and all issues have been recently moved to Github, the wiki will close soon and the project would have left the Google code environment.

However while a clear consensus have been found to go for GitHub (GitHub got voted 35 out of 43 responses, see results here) to host the code and issue tracker, I am not sure that GitHub is the right place to for the documentation. In this post I'll try to explain the reason why. Please note that I am open to comments and suggestions regarding analysis and proposition I'll do in this post. OpenRefine is now within the community hands and everyone voice count.

Read More
Read more »

19.10.12

Google Refine Administrativa Survey Results

9:53 AM  ,

Following the Usage Survey (see first results), we open a survey to understand the community preference regarding tool to administrate OpenRefine. Thanks to the 43 participants. 

I blow provide a first flat analysis of the results with decision that have already been made based on this survey. You can access details answers here and the survey form here.

Read More
Read more »
Subscribe to: Posts (Atom)