Sorting and cleaning data for journalism

5

lessons

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse varius enim in eros elementum tristique. Duis cursus, mi quis viverra ornare, eros dolor interdum nulla, ut commodo diam libero vitae erat. Aenean faucibus nibh et justo cursus id rutrum lorem imperdiet. Nunc ut sem vitae risus tristique posuere.

minutes

COURSE INTRODUCTION

This course will teach you where and how you can source data for your journalism stories, how to clean and organise data so that it’s ready for analysing and visualising in your data story.

Start Course

Course lessons

Course introduction

How to get started with sourcing, cleaning, and visualising data in Google Sheets

9

min

How create simple data visualisations in Google Sheets

10:41

min

How to source and scrape data to support your journalism

01:31

min

How to scrape data from PDF documents using Tabula

15:03

min

How to scrape fixed table data from a website using ImportHTML

10:38

min

instructors

Tegan Bedser

Tegan Bedser is a project manager for training and editorial projects at Media Hack Collective (MHC).

FAQ

Be the first to know about our new training material!

Africa Data Hub seeks to lower the barriers that African journalists face to access and use data in their storytelling around health and development.

This work is supported by the Bill & Melinda Gates Foundation.

Data resources

Knowledge and feedback