← Back

Maps of malaria deaths in Africa

Visualization protocol

Timestamp

1990-2019


Data source

Malaria

Article: owidmalaria

Author: Max Roser, Hannah Ritchie

Journal: Our World in Data

Source: https://ourworldindata.org/malaria

License: https://creativecommons.org/publicdomain/zero/1.0/

Dataset

Download the dataset


Trend of malaria death rates in Africa

Metadata

Entity (Country/Region): The specific countries or regions under consideration

Code: The 3-letter code of the country

Year: The timeframe spanning from the earliest to the latest data

Deaths - Malaria - Sex: Both - Age: Age-standardized (Rate) The death rates due to malaria, expressed as the number of deaths per 100,000 individuals, for each country and each year, considering both sexes

Protocol

Data quality check:

  • Examine the dataset for outliers and missing values
  • Address missing values and outliers through proper measures

Country selection:

  • Manually filter out non-African countries, as there is no dedicated continent column available.

Column filtration:

  • Remove unnecessary columns, such as the ‘Code’ column

Aggregation:

  • Group the data by year, transforming it into a structured format where each year is a column and the corresponding values represent the death rate for each African country.

Flourish configuration:

  • ID: Country
  • Name: Country
  • Label: Year
  • Colored By: Year
  • Region Geometry: We obtained a JSON file with the geographic regions of various countries worldwide since the initial dataset lacked complete country coverage. (reference: https://datahub.io/core/geo-countries)


Total malaria deaths per country in Africa (Nigeria and DRC excluded)

Flourish configuration:

  • ID: Country
  • Name: Country
  • Label: Year
  • Colored By: Grand Total
  • Region Geometry: We obtained a JSON file with the geographic regions of various countries worldwide since the initial dataset lacked complete country coverage. (reference: https://datahub.io/core/geo-countries)


Total malaria deaths per country in Africa (Nigeria and DRC excluded)

Protocol:

We followed the same steps as for the first map, but in this one, we excluded Democratic Republic of Congo and Nigeria from the dataset. This decision is based on exceptionally high death rates, rendering a detailed examination of other countries impractical.