Lijst van veelgebruikte tools

My recommended tools for data journalism. Carefully selected and frequently used by myself. I categorized these tools in three phases of data journalism: Data finding, data cleaning and data visualisation.

Data finding


ScraperWiki

  • Write your own scraper in Ruby/Python or request data (read: pay someone to scrape).


Scraper (plugin)

  • Plugin for Chrome browser to scrape web pages to Google Spreadsheets



Silk

  • Find, play around and visualise data. Spreadsheet data in wikipedia form, uploaded by users. Also, a nice way to store your data.

Data cleaning


CometDocs

  • Transform documents to spreadsheets. Not perfect, but saves a lot of time.



Excel

  • Essential software for each data journalist.


Google Refine

  • Great tool for mass editting data. Not for calculations, but specifically data cleaning.


Mr. Data Converter

  • Transform data from one format to another: HTML, XML, JSON, MySQL, Ruby, PHP, Python.

Data visualisation


ColorBrewer

  • What colors do you need to use? ColowBrewer categorizes color scales in sequential, diverging and qualitative color schemes.


D3.js

  • An extensive library for data visualisation. Keep in mind: a lot of programming.


FusionCharts

  • Visualizes data from XML to Flash or HTML5 graphics.


Fusion Tables

  • Visualisation tool, especially for maps. Also for line, bar, pie graphs, scatter plots and network visualisations, but not great.


Fusion Tables Layer Wizard

  • Want to optimize your Fusion Tables map, this is the tool. Generates an HTML document.


Gephi

  • Fast and easy networks visualisations


Google Charts

  • Easy and fast charts made with the Google Charts API. Through Google Spreadsheets (embeddable charts) or the Charts Playground (self-hosted)

Google Maps Style Wizard

  • Tool for styling a Google Map. Customize labels and colors.


HighCharts

  • Completely Javascript-based visualisation library.

Raphaël

  • Vector-based library for drawing graphics. Not easyily learned.


SHP Escape

  • Essential for converting SHP files to KML’s. You need Fusion Tables to make this work