Would you like to receive notifications about more lessons?

Close icon
Sign-up to Africa Data Hub Newsletter for updates on training.

Training

Sorting and cleaning data for journalism

How to scrape fixed table data from a website using ImportHTML

10:38

minutes

View all courses
>

Sorting and cleaning data for journalism

>
How to scrape fixed table data from a website using ImportHTML
>
No items found.
>
Next Course

Choose a lesson

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

About this lesson
Instructors
More Courses

About this lesson

In this video you will learn: 1) What ImportHTML is 2) How ImportHTML works and how to use the tool to copy table data from a website 3) How to visualise the data you scraped using Datawrapper

In this lesson you will learn:

1. What ImportHTML is

2. How ImportHTML works and how to use the tool to copy table data from a website

3. How to visualise the data you scraped using Datawrapper

Lesson Resources

Download icon

Resources used in this lesson are available to download

Download resources

More courses

Tools for visualising data in journalism

Visualisations bring the “ooooh” factor to data-driven journalism, but their purpose is greater than simply making your story “pretty”. This course will teach you where and how you can source data for your journalism stories, how to clean and organise data, as well as how to visualise data using simple charts.

2

lessons

38:78min

An introduction to visualising data using choropleth maps

In this course you will learn how to visualise data using a template map and a map you have found yourself. You will also learn how to source, visualise, and add data to a map for your story using Mapshaper, Datawrapper, and Flourish.

5

lessons

1h 33min

How to do solutions journalism

This course introduces you to the concept of solutions journalism through a series of lectures by experienced members of Solutions Journalism Network. It is intended to make you conscious of why this form of journalism is valuable and necessary. The introduction to solutions journalism is also aimed at helping you get started in the process of producing your own solutions journalism story.

5

lessons

40min

View all ADH courses

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
Mapped data
Vaccine Tracker
COVID-19 Observer
Data Repository
Knowledge and feedback
Glossary
Attribution Guide
User survey
Cookie policy
Code of conduct
Newsletter
Our Brand
Contact
info@africadatahub.org
Social media
© Africa Data Hub. Open Cities Lab is a non-profit organisation DSD: 255-261NPO / PBO (18A): 930067929. The ADH project is Licensed under a Creative Commons Attribution 4.0 International License.