(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 …
Image by Carla Pedret© Anyone interested in data journalism – also called data-driven journalism or #ddj – should know who are the experts in the field. Twitter is a good place to follow them and also to find training, tips and inspiration. The following list compiles 15 Twitter accounts from all over the world that every data …