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

Is AI compromising our curiosity?

As AI becomes increasingly prominent in our lives, it is time for comms professionals to consider the impact on creativity and curiosity. ...Read more

Selina Jardim
Selina Jardim
Technology

Cracking the communication code in technology

Often, when communicating about technology, conversations can become quite technical. How can brands cut through the noise and communicate effectively? ...Read more

Sameer Jama
Sameer Jama
Blog

How Barbie’s reputational overhaul painted the world pink

Barbie's reputation hasn't always been positive, but this year's Barbie film has changed the tides. What can this teach us about reputation shaping? ...Read more

Alexandra Kourakis
Alexandra Kourakis

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