# Africa Data Hub

These are the steps needed to generated datasets for Africa Data Hub.&#x20;

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

![](https://lh4.googleusercontent.com/7yGuwQu2HWJmxCO5Z9Or41QiS7DiaQPIo8ix1uQg_HMV_HsZvMg-PBU75i1iYhBCqhDGZSilIV1xhKAxn2qKE7EOn9rDexx1YEe_VTAs24Phy5efH9bf0zekk5aPfjZtsWPjUUmR)

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

![](https://lh4.googleusercontent.com/dEEGjVUzeWNtfP2piujHLNv91JD0qmabNGBLmNIDBtU5iyQMi9o9i75iO2p1R8-oXya07wLf5ytVotxgtIy1XLS90afAGXmny4gEL_pBVCmL65_PuZNNKXPssGaKRuGaQWRnsr_m)

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

![](https://lh3.googleusercontent.com/gtNuyk-rkawbhui7WehOqzeeYVy6I_jX8NmoIF9boDjnQzsC65ZXkj4ek7_D1KEYPUUKtt92DeLkxM_JZYWbNxX54p5DVMzS4vjh8AhgKrUrOX4Z0HqBqPZdRXm2IF1h4VG5EvIP)

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&#x20;

Admin0\_dataTransformation\_v2.ipynb&#x20;

Africa\_Admin1\_dataTransformation.ipynb

&#x20;Data\_Aggregation.ipynb&#x20;

Data\_Aggregation.ipynb will generate cases\_monthly, death\_monthly .
