Data tools for everyday journalism

@maartenzam

Dataharvest | EIJC

Mechelen

May 25 2018

Tools

SCRAPING

Why these tools?

Fast

Easy

Low cost

Quality output

But it all starts with

Scraping

=importhtml() in Google Sheet (data)

Getting structured data out of web pages

More advanced (no coding):

Parsehub, Apify, Octoparse, Web Robots

(data)

Get data out of pdf files

 

Data: Eurostat

Inspecting data

Cleaning data

Transforming data

Enriching data

Data

csv

pdf

Addresses to coordinates

Chartbuilder

By qz.com

Simple charts

Consistent styling

Static images (.png, .svg)

No spreadsheet

Chartbuilder

Data

Tutorials

vs Chartbuilder

More chart types

Highlight & annotate

Interactive charts

Maps

Tutorials

vs Chartbuilder & Datawrapper

Unconventional visualizations

Drag & drop

Output is vector only

Charts, maps and interactive stories

Tutorials

Want more?

Video courses

Thanks!

slides.com/maartenzam/dh18-tools