Wazimap profile curation handbook
  • Start Here
    • Introduction
  • Point Mapper
    • What is Point Mapper?
    • Shaping Data for Point Collections
    • Uploading Point Collections
    • Creating Themes for Profile Collections
    • Creating Profile Collections from Point Collections
    • Uploading additional points to an existing Point Collection
    • Editing existing Point Data in Django
    • Bulk updates to an existing point collection
    • Navigating Point Mapper
  • Profile Admin
    • Creating Datasets
    • Sub-Indicator groups (columns)
    • Creating Universes
    • Creating Variables
    • Creating Point Collections
    • Creating a Profile Highlight
    • Creating Profile Indicators
    • Creating a Profile Key Metric
    • Managing Categories and Sub-Categories
    • Managing Point Themes and Profile Collections
    • Profile configuration options
  • Curation Concepts
    • Geography Codes
    • Zero-values vs missing data
    • Glossary
  • Common practices
    • General
    • SANEF election dashboard
    • Africa Data Hub
    • Data handling tips
  • Promotion and usage
    • Analytics
Powered by GitBook
On this page

Was this helpful?

Export as PDF
  1. Common practices

Africa Data Hub

PreviousSANEF election dashboardNextData handling tips

Last updated 3 years ago

Was this helpful?

These are the steps needed to generated datasets for Africa Data Hub.

The script of ADH can be found at https://github.com/OpenUpSA/wazimap-adh-data under the folder COVID Countries and Africa Admin 1.

Collection data

Download owid-covid-latest.csv from https://github.com/owid/covid-19-data/tree/master/public/data

Download from https://github.com/dsfsi/covid19za/tree/master/data the following files: covid19za_provincial_cumulative_timeline_confirmed.csv, covid19za_provincial_cumulative_timeline_deaths.csv, covid19za_provincial_cumulative_timeline_recoveries.csv

Download from https://data.humdata.org/organization/hera-humanitarian-emergency-response-africa ALL( for various countries) csv files that end with Coronavirus (Covid-19) Subnational eg. Niger: Coronavirus (Covid-19) Subnational. All the datasets from this source should be saved in a folder named HERA

For each csv file in HERA folder, change columns name from

['CONTAMINES', 'DECES', 'GUERIS', 'CONTAMINES_FEMME', 'CONTAMINES_HOMME', 'CONTAMINES_GENRE_NON_SPECIFIE']

These dataset should be saved under the folder wazimap-adh-data-main/COVID Countries and Africa Admin 1 After downloading the datasets, run the script as in the following order

Admin0_dataTransformation_v2.ipynb

Africa_Admin1_dataTransformation.ipynb

Data_Aggregation.ipynb

Data_Aggregation.ipynb will generate cases_monthly, death_monthly .