Tool of the Month – OpenRefine

Tool of the Month – OpenRefine

Hollie Abbott

Hollie Abbott

Last month, we visited the news:rewired conference and gained some valuable insights into how news and journalism is developing. One of sessions, hosted by Leila Haddou from the Sunday Times shared a list of the great tools out there for the media industry and amongst them we found some goodies. Our favourite and henceforth our Tool of the Month has got to be OpenRefine.

One of the most tedious jobs in the creative industry has got to be data crunching tasks, especially when the data you’re working with is all over the place. Small errors like extra spaces, misspellings and varying abbreviations often go unnoticed in large datasets and you may be missing out on vital stats.

With OpenRefine, the tool can pick up these inconsistencies in the file, so you have a fully reliable dataset ready to crunch. OpenRefine can also transform the format of the data. So, if you were looking at a set of data in a list and you wanted it in table, OpenRefine can do that for you too. Data cleansing has never been so easy!

Share this story:

Read more from the blog

Blog

Lights, camera, action or no action?

Last month, we visited the news:rewired conference and gained some valuable insights into how news and journalism is developing. One of sessions, hosted by Leila Haddou from the Sunday Times shared a list of the great tools out there for the media industry and amongst them we found some goodies. Our favourite and henceforth our […] ...Read more

Ben Brigham
Ben Brigham
Blog

Implementing robust customer communications during a cyberattack

Last month, we visited the news:rewired conference and gained some valuable insights into how news and journalism is developing. One of sessions, hosted by Leila Haddou from the Sunday Times shared a list of the great tools out there for the media industry and amongst them we found some goodies. Our favourite and henceforth our […] ...Read more

Megan Hogg
Megan Hogg
Blog

A fish rots from the head: reputation needs leadership

Last month, we visited the news:rewired conference and gained some valuable insights into how news and journalism is developing. One of sessions, hosted by Leila Haddou from the Sunday Times shared a list of the great tools out there for the media industry and amongst them we found some goodies. Our favourite and henceforth our […] ...Read more

Selina Jardim
Selina Jardim

Add a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Is it time to shape your reputation?

We operate in London, Paris and Munich, and have a network of like-minded partners across the globe.

Get in touch

Sign up to Spark, our newsletter

Receive thought pieces from our leadership team, views on the news, tool of the month and light relief for comms folk

You can unsubscribe at any time, please read our privacy policy for more information