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.

23.4.15

Exploring Toronto 311 calls Part1: Why people are calling?


Toronto 311Service Request - Customer Initiated contains information on on customer initiated service requests received by the city of Toronto for Solid Waste Management, Transportation Services, Toronto Water, Municipal Licensing & Standards, and Urban Forestry related request.

In the April session of the Toronto OpenRefine Meetup we took an hour to explore the data set and prepare it to map in using Google Fusion Table. For this example we will use only the 2015 calls available to this date:  from January 1st to March 31. Download it from here: http://opendata.toronto.ca/311/service.request/SR2015.zip


The 311 Service Request - Customer Initiated data set have three fields:
  • CREATION DATE 
  • SERVICE REQUEST LOCATION 
  • SERVICE REQUEST TYPE
In this first article we will explore the relationship between the type of request and its creation date.