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

SAG-AFTRA Strikes and the Ripple Effect on AI Adoption

The influence of the recent SAG-AFTRA strikes extends far beyond pay. Driven by concerns over fair compensation and working conditions, the strikes have highlighted broader issues surrounding the relationship between technology (AI in particular) and labour. ...Read more

Emily Royle
Emily Royle
Blog

From potato to progress: Addressing communication breakdowns

Miscommunication and misunderstanding are part and parcel of life. They happen often, and if corrected in good time, no big deal. But what happens when there’s a communication breakdown that is left unaddressed? The relationship breaks down too. ...Read more

Charlotte Stoel
Charlotte Stoel
Blog

Pan-European PR: It’s so much more than translation

We often consider translation to be at the heart of communicating across borders - but Pan-European PR is so much more. ...Read more

Megan Hogg
Megan Hogg

Add a comment

Time limit exceeded. Please complete the captcha once again.

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