# 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>

![](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 .


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://openup.gitbook.io/wazimap-ng/common-practices/africa-data-hub.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.