Original image by GotCredit/Flickr Maps are a powerful tool to visualise data because they can explain stories with a high level of detail. You can show the data within countries, regions or even electoral wards. The only thing you need to know is how to work with KML files. The open source data cleaning tool Open Refine can help …
Image by Craig Chew-Moulding/Flickr CSV files are a common format when working with spreadsheets. The process to open a CSV file is really easy and usually takes only a couple of minutes, as this tutorial shows. However, what can you do if the standard process fails? You can use Open Refine, a powerful tool that can help …
(Image by r2hox/Flickr) CSV – comma separated values – is a common format for datasets. Excel or the free spreadsheet software Google Sheets can open them easily and, in some cases, automatically. Open your CSV file with Excel. You will get a messy data set without format, but don’t panic: that is how a CSV should look like. Select …
Image by Tom Brown/Flickr Data journalists should know how to use Excel or the free spreadsheet software Google sheets to clean and process data. Some data sets will tell us a story with only some sorting or creating a pivot table while others require some maths. In this post, you will find some examples of basic formulas to analyse data and find stories …