Africa Data Hub

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 .