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

A changing landscape: Building reputations amid shrinking media pools 

Amid shrinking media pools, PR professionals need to begin thinking broader and deeper than simply media relations. ...Read more

Claire Walker
Claire Walker
Blog

Step forward with year-round inclusive PR campaigns this Pride Month

How can organisations do better this Pride Month and beyond? We discuss the dos and don'ts for inclusive PR campaigns. ...Read more

Megan Hogg
Megan Hogg
Tech News

Summer is here, and so are our top tech news stories of the month

Whilst June flew by in a flash of picnics in the park, it didn’t fall short on delivering yet more weird and wonderful tech news stories. ...Read more

Georgia Dallas
Georgia Dallas

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