Data Preprocessing_.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "dac222b9-1dba-47da-8c91-64a013de30f5",
   "metadata": {},
   "source": [
    "## Malaria in Africa - Team Gitops"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "2a3a2817-a0df-46a5-8438-995b7ae5004c",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "sns.set(rc={'figure.figsize':(12,6)})\n",
    "pd.set_option('display.max_columns', 50)\n",
    "import missingno as msno\n",
    "# import pycountry\n",
    "\n",
    "%matplotlib inline\n",
    "\n",
    "import warnings\n",
    "warnings.filterwarnings(\"ignore\") "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "89d22845-d998-4b94-9bac-4bd3713af660",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "malaria = pd.read_excel(\"AfricaMalariaData.xlsx\")\n",
    "climate_data = pd.read_csv('climate_change_data.csv')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "62032432-9218-4566-a8c4-057f309e7711",
   "metadata": {},
   "source": [
    "### Data Description\n",
    "- Malaria_data was obtained from several indicators(19) found in [Databank](https://databank.worldbank.org/reports.aspx?source=2&series=SP.RUR.TOTL.ZS&country=#), transformed and merge in power query editor.\n",
    "- Climate data was obtain from [Kaggle](https://www.kaggle.com/datasets/goyaladi/climate-insights-dataset?select=climate_change_data.csv)\n",
    "\n",
    "### Data Dictionary\n",
    "\n",
    "\n",
    "| Indicator Name | Description |\n",
    "| ----------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------ |\n",
    "| Rural population (% of total population) | Rural population refers to people living in rural areas as defined by national statistical offices. It is calculated as the difference between total population and urban population. |\n",
    "| People using at least basic drinking water services (% of population) |  Improved water sources include piped water, boreholes or tubewells, protected dug wells, protected springs, and packaged or delivered water. |\n",
    "| People using at least basic drinking water services, rural (% of rural population) |  Improved water sources include piped water, boreholes or tubewells, protected dug wells, protected springs, and packaged or delivered water in rural areas. |\n",
    "| People using at least basic drinking water services, urban (% of urban population |  Improved water sources include piped water, boreholes or tubewells, protected dug wells, protected springs, and packaged or delivered water in urban areas. |\n",
    "| People using at least basic sanitation services (% of population) |  Improved sanitation facilities include flush/pour flush to piped sewer systems, septic tanks or pit latrines; ventilated improved pit latrines, compositing toilets or pit latrines with slabs. |\n",
    "| People using at least basic sanitation services, rural (% of rural population) | Improved sanitation facilities include flush/pour flush to piped sewer systems, septic tanks or pit latrines; ventilated improved pit latrines, compositing toilets or pit latrines with slabs in rural areas. |\n",
    "| People using at least basic sanitation services, urban (% of urban population) |   Improved sanitation facilities include flush/pour flush to piped sewer systems, septic tanks or pit latrines; ventilated improved pit latrines, compositing toilets or pit latrines with slabs in urban areas. |\n",
    "| People using safely managed drinking water services (% of population) |  The percentage of people using drinking water from an improved source that is accessible on premises, available when needed and free from faecal and priority chemical contamination. |\n",
    "| People using safely managed drinking water services, rural (% of rural population) |  The percentage of people using drinking water from an improved source that is accessible on premises, available when needed and free from faecal and priority chemical contamination in rural. |\n",
    "| People using safely managed drinking water services, urban (% of urban population) |  The percentage of people using drinking water from an improved source that is accessible on premises, available when needed and free from faecal and priority chemical contamination urban. |\n",
    "| People using safely managed sanitation services (% of population) |  The percentage of people using improved sanitation facilities that are not shared with other households and where excreta are safely disposed of in situ or transported and treated offsite. |\n",
    "| People using safely managed sanitation services, rural (% of rural population) |  The percentage of people using improved sanitation facilities that are not shared with other households and where excreta are safely disposed of in situ or transported and treated offsite rural areas. |\n",
    "| People using safely managed sanitation services, urban (% of urban population |  The percentage of people using improved sanitation facilities that are not shared with other households and where excreta are safely disposed of in situ or transported and treated offsite urban areas. |\n",
    "| Children with fever receiving antimalarial drugs (% of children under age 5 with fever) |  Malaria treatment refers to the percentage of children under age five who were ill with fever in the last two weeks and received any appropriate (locally defined) anti-malarial drugs.\n",
    "| Incidence of malaria (per 1,000 population at risk) |  Incidence of malaria is the number of new cases of malaria in a year per 1,000 population at risk. |\n",
    "| Urban population (% of total population) |  People living in urban areas as defined by national statistical offices. |\n",
    "| Literacy rate, adult total (% of people ages 15 and above) |  Percentage of people ages 15 and above who can both read and write with understanding a short simple statement about their everyday life.\n",
    "| Use of insecticide-treated bed nets (% of under-5 population) |  Use of insecticide-treated bed nets refers to the percentage of children under age five who slept under an insecticide-treated bednet to prevent malaria.\n",
    "| Death rate, crude (per 1,000 people) |  Crude death rate indicates the number of deaths occurring during the year, per 1,000 population estimated at midyear. |\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "8f55cf0a-4f88-47fa-94ca-b2881e1a67bc",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "This main dataset contains 918 rows and 26 columns\n"
     ]
    }
   ],
   "source": [
    "print(f\"This main dataset contains {malaria.shape[0]} rows and {malaria.shape[1]} columns\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "526b01e5-c971-4097-aeb4-ab5cb6225d22",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Country Code</th>\n",
       "      <th>Country</th>\n",
       "      <th>Income Group</th>\n",
       "      <th>Year</th>\n",
       "      <th>Incidence of malaria (per 1,000 population at risk)</th>\n",
       "      <th>People using at least basic drinking water services (% of population)</th>\n",
       "      <th>People using at least basic drinking water services, rural (% of rural populatio</th>\n",
       "      <th>People using at least basic drinking water services, urban (% of urban populatio</th>\n",
       "      <th>People using at least basic sanitation services (% of population)</th>\n",
       "      <th>People using at least basic sanitation services, rural (% of rural population)</th>\n",
       "      <th>People using at least basic sanitation services, urban (% of urban population)</th>\n",
       "      <th>Children with fever receiving antimalarial drugs (% of children under age 5 with</th>\n",
       "      <th>Death rate, crude (per 1,000 people).1</th>\n",
       "      <th>Literacy rate, adult total (% of people ages 15 and above).1</th>\n",
       "      <th>Rural population (% of total population).1</th>\n",
       "      <th>People using safely managed drinking water services (% of population)</th>\n",
       "      <th>People using safely managed drinking water services, rural (% of rural populatio</th>\n",
       "      <th>People using safely managed drinking water services, urban (% of urban populatio</th>\n",
       "      <th>People using safely managed sanitation services (% of population)</th>\n",
       "      <th>People using safely managed sanitation services, rural (% of rural population)</th>\n",
       "      <th>People using safely managed sanitation services, urban (% of urban population)</th>\n",
       "      <th>Urban population (% of total population).1</th>\n",
       "      <th>Use of insecticide-treated bed nets (% of under-5 population).1</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>DZA</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>Lower middle income</td>\n",
       "      <td>2005</td>\n",
       "      <td>0.0</td>\n",
       "      <td>91.1</td>\n",
       "      <td>85.0</td>\n",
       "      <td>94.6</td>\n",
       "      <td>85.8</td>\n",
       "      <td>75.4</td>\n",
       "      <td>91.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.9</td>\n",
       "      <td>0.0</td>\n",
       "      <td>36.2</td>\n",
       "      <td>72.8</td>\n",
       "      <td>56.5</td>\n",
       "      <td>82.0</td>\n",
       "      <td>60.5</td>\n",
       "      <td>50.4</td>\n",
       "      <td>66.2</td>\n",
       "      <td>63.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>28.033886</td>\n",
       "      <td>1.659626</td>\n",
       "      <td>POINT (28.033886 1.659626)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>DZA</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>Lower middle income</td>\n",
       "      <td>2006</td>\n",
       "      <td>0.0</td>\n",
       "      <td>91.4</td>\n",
       "      <td>85.4</td>\n",
       "      <td>94.7</td>\n",
       "      <td>86.1</td>\n",
       "      <td>75.7</td>\n",
       "      <td>91.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.9</td>\n",
       "      <td>72.6</td>\n",
       "      <td>35.4</td>\n",
       "      <td>73.2</td>\n",
       "      <td>57.4</td>\n",
       "      <td>81.9</td>\n",
       "      <td>60.8</td>\n",
       "      <td>50.8</td>\n",
       "      <td>66.3</td>\n",
       "      <td>64.6</td>\n",
       "      <td>0.0</td>\n",
       "      <td>28.033886</td>\n",
       "      <td>1.659626</td>\n",
       "      <td>POINT (28.033886 1.659626)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>DZA</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>Lower middle income</td>\n",
       "      <td>2007</td>\n",
       "      <td>0.0</td>\n",
       "      <td>91.6</td>\n",
       "      <td>85.7</td>\n",
       "      <td>94.7</td>\n",
       "      <td>86.3</td>\n",
       "      <td>76.1</td>\n",
       "      <td>91.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.9</td>\n",
       "      <td>0.0</td>\n",
       "      <td>34.7</td>\n",
       "      <td>73.7</td>\n",
       "      <td>58.3</td>\n",
       "      <td>81.9</td>\n",
       "      <td>61.1</td>\n",
       "      <td>51.2</td>\n",
       "      <td>66.4</td>\n",
       "      <td>65.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>28.033886</td>\n",
       "      <td>1.659626</td>\n",
       "      <td>POINT (28.033886 1.659626)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>DZA</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>Lower middle income</td>\n",
       "      <td>2008</td>\n",
       "      <td>0.0</td>\n",
       "      <td>91.8</td>\n",
       "      <td>86.0</td>\n",
       "      <td>94.8</td>\n",
       "      <td>86.5</td>\n",
       "      <td>76.4</td>\n",
       "      <td>91.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.9</td>\n",
       "      <td>75.1</td>\n",
       "      <td>33.9</td>\n",
       "      <td>74.2</td>\n",
       "      <td>59.3</td>\n",
       "      <td>81.8</td>\n",
       "      <td>61.4</td>\n",
       "      <td>51.6</td>\n",
       "      <td>66.4</td>\n",
       "      <td>66.1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>28.033886</td>\n",
       "      <td>1.659626</td>\n",
       "      <td>POINT (28.033886 1.659626)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>DZA</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>Lower middle income</td>\n",
       "      <td>2009</td>\n",
       "      <td>0.0</td>\n",
       "      <td>92.1</td>\n",
       "      <td>86.4</td>\n",
       "      <td>94.9</td>\n",
       "      <td>86.8</td>\n",
       "      <td>76.7</td>\n",
       "      <td>91.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>33.2</td>\n",
       "      <td>74.6</td>\n",
       "      <td>60.2</td>\n",
       "      <td>81.8</td>\n",
       "      <td>61.7</td>\n",
       "      <td>52.0</td>\n",
       "      <td>66.5</td>\n",
       "      <td>66.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>28.033886</td>\n",
       "      <td>1.659626</td>\n",
       "      <td>POINT (28.033886 1.659626)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>913</th>\n",
       "      <td>ZWE</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>Lower middle income</td>\n",
       "      <td>2017</td>\n",
       "      <td>115.2</td>\n",
       "      <td>64.0</td>\n",
       "      <td>50.1</td>\n",
       "      <td>93.3</td>\n",
       "      <td>36.9</td>\n",
       "      <td>32.6</td>\n",
       "      <td>46.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>67.8</td>\n",
       "      <td>26.9</td>\n",
       "      <td>13.6</td>\n",
       "      <td>55.1</td>\n",
       "      <td>33.6</td>\n",
       "      <td>31.3</td>\n",
       "      <td>38.4</td>\n",
       "      <td>32.2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-19.015438</td>\n",
       "      <td>29.154857</td>\n",
       "      <td>POINT (-19.015438 29.154857)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>914</th>\n",
       "      <td>ZWE</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>Lower middle income</td>\n",
       "      <td>2018</td>\n",
       "      <td>53.6</td>\n",
       "      <td>63.5</td>\n",
       "      <td>49.5</td>\n",
       "      <td>93.2</td>\n",
       "      <td>36.4</td>\n",
       "      <td>32.4</td>\n",
       "      <td>44.6</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>67.8</td>\n",
       "      <td>26.8</td>\n",
       "      <td>13.3</td>\n",
       "      <td>55.2</td>\n",
       "      <td>33.5</td>\n",
       "      <td>31.1</td>\n",
       "      <td>38.7</td>\n",
       "      <td>32.2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-19.015438</td>\n",
       "      <td>29.154857</td>\n",
       "      <td>POINT (-19.015438 29.154857)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>915</th>\n",
       "      <td>ZWE</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>Lower middle income</td>\n",
       "      <td>2019</td>\n",
       "      <td>64.7</td>\n",
       "      <td>63.1</td>\n",
       "      <td>48.9</td>\n",
       "      <td>93.0</td>\n",
       "      <td>35.8</td>\n",
       "      <td>32.2</td>\n",
       "      <td>43.2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>67.8</td>\n",
       "      <td>26.7</td>\n",
       "      <td>13.1</td>\n",
       "      <td>55.3</td>\n",
       "      <td>33.0</td>\n",
       "      <td>30.9</td>\n",
       "      <td>37.4</td>\n",
       "      <td>32.2</td>\n",
       "      <td>14.9</td>\n",
       "      <td>-19.015438</td>\n",
       "      <td>29.154857</td>\n",
       "      <td>POINT (-19.015438 29.154857)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>916</th>\n",
       "      <td>ZWE</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>Lower middle income</td>\n",
       "      <td>2020</td>\n",
       "      <td>93.4</td>\n",
       "      <td>62.7</td>\n",
       "      <td>48.3</td>\n",
       "      <td>92.9</td>\n",
       "      <td>35.2</td>\n",
       "      <td>32.0</td>\n",
       "      <td>41.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>67.8</td>\n",
       "      <td>26.6</td>\n",
       "      <td>12.9</td>\n",
       "      <td>55.4</td>\n",
       "      <td>32.4</td>\n",
       "      <td>30.6</td>\n",
       "      <td>36.0</td>\n",
       "      <td>32.2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-19.015438</td>\n",
       "      <td>29.154857</td>\n",
       "      <td>POINT (-19.015438 29.154857)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>917</th>\n",
       "      <td>ZWE</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>Lower middle income</td>\n",
       "      <td>2021</td>\n",
       "      <td>27.2</td>\n",
       "      <td>62.3</td>\n",
       "      <td>47.7</td>\n",
       "      <td>92.8</td>\n",
       "      <td>34.6</td>\n",
       "      <td>31.8</td>\n",
       "      <td>40.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>67.7</td>\n",
       "      <td>26.5</td>\n",
       "      <td>12.6</td>\n",
       "      <td>55.5</td>\n",
       "      <td>31.8</td>\n",
       "      <td>30.4</td>\n",
       "      <td>34.7</td>\n",
       "      <td>32.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-19.015438</td>\n",
       "      <td>29.154857</td>\n",
       "      <td>POINT (-19.015438 29.154857)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>918 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Country Code   Country         Income Group  Year  \\\n",
       "0            DZA   Algeria  Lower middle income  2005   \n",
       "1            DZA   Algeria  Lower middle income  2006   \n",
       "2            DZA   Algeria  Lower middle income  2007   \n",
       "3            DZA   Algeria  Lower middle income  2008   \n",
       "4            DZA   Algeria  Lower middle income  2009   \n",
       "..           ...       ...                  ...   ...   \n",
       "913          ZWE  Zimbabwe  Lower middle income  2017   \n",
       "914          ZWE  Zimbabwe  Lower middle income  2018   \n",
       "915          ZWE  Zimbabwe  Lower middle income  2019   \n",
       "916          ZWE  Zimbabwe  Lower middle income  2020   \n",
       "917          ZWE  Zimbabwe  Lower middle income  2021   \n",
       "\n",
       "     Incidence of malaria (per 1,000 population at risk)  \\\n",
       "0                                                  0.0     \n",
       "1                                                  0.0     \n",
       "2                                                  0.0     \n",
       "3                                                  0.0     \n",
       "4                                                  0.0     \n",
       "..                                                 ...     \n",
       "913                                              115.2     \n",
       "914                                               53.6     \n",
       "915                                               64.7     \n",
       "916                                               93.4     \n",
       "917                                               27.2     \n",
       "\n",
       "     People using at least basic drinking water services (% of population)  \\\n",
       "0                                                 91.1                       \n",
       "1                                                 91.4                       \n",
       "2                                                 91.6                       \n",
       "3                                                 91.8                       \n",
       "4                                                 92.1                       \n",
       "..                                                 ...                       \n",
       "913                                               64.0                       \n",
       "914                                               63.5                       \n",
       "915                                               63.1                       \n",
       "916                                               62.7                       \n",
       "917                                               62.3                       \n",
       "\n",
       "     People using at least basic drinking water services, rural (% of rural populatio  \\\n",
       "0                                                 85.0                                  \n",
       "1                                                 85.4                                  \n",
       "2                                                 85.7                                  \n",
       "3                                                 86.0                                  \n",
       "4                                                 86.4                                  \n",
       "..                                                 ...                                  \n",
       "913                                               50.1                                  \n",
       "914                                               49.5                                  \n",
       "915                                               48.9                                  \n",
       "916                                               48.3                                  \n",
       "917                                               47.7                                  \n",
       "\n",
       "     People using at least basic drinking water services, urban (% of urban populatio  \\\n",
       "0                                                 94.6                                  \n",
       "1                                                 94.7                                  \n",
       "2                                                 94.7                                  \n",
       "3                                                 94.8                                  \n",
       "4                                                 94.9                                  \n",
       "..                                                 ...                                  \n",
       "913                                               93.3                                  \n",
       "914                                               93.2                                  \n",
       "915                                               93.0                                  \n",
       "916                                               92.9                                  \n",
       "917                                               92.8                                  \n",
       "\n",
       "     People using at least basic sanitation services (% of population)  \\\n",
       "0                                                 85.8                   \n",
       "1                                                 86.1                   \n",
       "2                                                 86.3                   \n",
       "3                                                 86.5                   \n",
       "4                                                 86.8                   \n",
       "..                                                 ...                   \n",
       "913                                               36.9                   \n",
       "914                                               36.4                   \n",
       "915                                               35.8                   \n",
       "916                                               35.2                   \n",
       "917                                               34.6                   \n",
       "\n",
       "     People using at least basic sanitation services, rural (% of rural population)  \\\n",
       "0                                                 75.4                                \n",
       "1                                                 75.7                                \n",
       "2                                                 76.1                                \n",
       "3                                                 76.4                                \n",
       "4                                                 76.7                                \n",
       "..                                                 ...                                \n",
       "913                                               32.6                                \n",
       "914                                               32.4                                \n",
       "915                                               32.2                                \n",
       "916                                               32.0                                \n",
       "917                                               31.8                                \n",
       "\n",
       "     People using at least basic sanitation services, urban (% of urban population)  \\\n",
       "0                                                 91.7                                \n",
       "1                                                 91.7                                \n",
       "2                                                 91.7                                \n",
       "3                                                 91.7                                \n",
       "4                                                 91.7                                \n",
       "..                                                 ...                                \n",
       "913                                               46.0                                \n",
       "914                                               44.6                                \n",
       "915                                               43.2                                \n",
       "916                                               41.8                                \n",
       "917                                               40.4                                \n",
       "\n",
       "     Children with fever receiving antimalarial drugs (% of children under age 5 with  \\\n",
       "0                                                  0.0                                  \n",
       "1                                                  0.0                                  \n",
       "2                                                  0.0                                  \n",
       "3                                                  0.0                                  \n",
       "4                                                  0.0                                  \n",
       "..                                                 ...                                  \n",
       "913                                                0.0                                  \n",
       "914                                                0.0                                  \n",
       "915                                                0.0                                  \n",
       "916                                                0.0                                  \n",
       "917                                                0.0                                  \n",
       "\n",
       "     Death rate, crude (per 1,000 people).1  \\\n",
       "0                                       4.9   \n",
       "1                                       4.9   \n",
       "2                                       4.9   \n",
       "3                                       4.9   \n",
       "4                                       4.7   \n",
       "..                                      ...   \n",
       "913                                     8.3   \n",
       "914                                     8.0   \n",
       "915                                     8.0   \n",
       "916                                     8.1   \n",
       "917                                     9.1   \n",
       "\n",
       "     Literacy rate, adult total (% of people ages 15 and above).1  \\\n",
       "0                                                  0.0              \n",
       "1                                                 72.6              \n",
       "2                                                  0.0              \n",
       "3                                                 75.1              \n",
       "4                                                  0.0              \n",
       "..                                                 ...              \n",
       "913                                                0.0              \n",
       "914                                                0.0              \n",
       "915                                                0.0              \n",
       "916                                                0.0              \n",
       "917                                                0.0              \n",
       "\n",
       "     Rural population (% of total population).1  \\\n",
       "0                                          36.2   \n",
       "1                                          35.4   \n",
       "2                                          34.7   \n",
       "3                                          33.9   \n",
       "4                                          33.2   \n",
       "..                                          ...   \n",
       "913                                        67.8   \n",
       "914                                        67.8   \n",
       "915                                        67.8   \n",
       "916                                        67.8   \n",
       "917                                        67.7   \n",
       "\n",
       "     People using safely managed drinking water services (% of population)  \\\n",
       "0                                                 72.8                       \n",
       "1                                                 73.2                       \n",
       "2                                                 73.7                       \n",
       "3                                                 74.2                       \n",
       "4                                                 74.6                       \n",
       "..                                                 ...                       \n",
       "913                                               26.9                       \n",
       "914                                               26.8                       \n",
       "915                                               26.7                       \n",
       "916                                               26.6                       \n",
       "917                                               26.5                       \n",
       "\n",
       "     People using safely managed drinking water services, rural (% of rural populatio  \\\n",
       "0                                                 56.5                                  \n",
       "1                                                 57.4                                  \n",
       "2                                                 58.3                                  \n",
       "3                                                 59.3                                  \n",
       "4                                                 60.2                                  \n",
       "..                                                 ...                                  \n",
       "913                                               13.6                                  \n",
       "914                                               13.3                                  \n",
       "915                                               13.1                                  \n",
       "916                                               12.9                                  \n",
       "917                                               12.6                                  \n",
       "\n",
       "     People using safely managed drinking water services, urban (% of urban populatio  \\\n",
       "0                                                 82.0                                  \n",
       "1                                                 81.9                                  \n",
       "2                                                 81.9                                  \n",
       "3                                                 81.8                                  \n",
       "4                                                 81.8                                  \n",
       "..                                                 ...                                  \n",
       "913                                               55.1                                  \n",
       "914                                               55.2                                  \n",
       "915                                               55.3                                  \n",
       "916                                               55.4                                  \n",
       "917                                               55.5                                  \n",
       "\n",
       "     People using safely managed sanitation services (% of population)  \\\n",
       "0                                                 60.5                   \n",
       "1                                                 60.8                   \n",
       "2                                                 61.1                   \n",
       "3                                                 61.4                   \n",
       "4                                                 61.7                   \n",
       "..                                                 ...                   \n",
       "913                                               33.6                   \n",
       "914                                               33.5                   \n",
       "915                                               33.0                   \n",
       "916                                               32.4                   \n",
       "917                                               31.8                   \n",
       "\n",
       "     People using safely managed sanitation services, rural (% of rural population)  \\\n",
       "0                                                 50.4                                \n",
       "1                                                 50.8                                \n",
       "2                                                 51.2                                \n",
       "3                                                 51.6                                \n",
       "4                                                 52.0                                \n",
       "..                                                 ...                                \n",
       "913                                               31.3                                \n",
       "914                                               31.1                                \n",
       "915                                               30.9                                \n",
       "916                                               30.6                                \n",
       "917                                               30.4                                \n",
       "\n",
       "     People using safely managed sanitation services, urban (% of urban population)  \\\n",
       "0                                                 66.2                                \n",
       "1                                                 66.3                                \n",
       "2                                                 66.4                                \n",
       "3                                                 66.4                                \n",
       "4                                                 66.5                                \n",
       "..                                                 ...                                \n",
       "913                                               38.4                                \n",
       "914                                               38.7                                \n",
       "915                                               37.4                                \n",
       "916                                               36.0                                \n",
       "917                                               34.7                                \n",
       "\n",
       "     Urban population (% of total population).1  \\\n",
       "0                                          63.8   \n",
       "1                                          64.6   \n",
       "2                                          65.3   \n",
       "3                                          66.1   \n",
       "4                                          66.8   \n",
       "..                                          ...   \n",
       "913                                        32.2   \n",
       "914                                        32.2   \n",
       "915                                        32.2   \n",
       "916                                        32.2   \n",
       "917                                        32.3   \n",
       "\n",
       "     Use of insecticide-treated bed nets (% of under-5 population).1  \\\n",
       "0                                                  0.0                 \n",
       "1                                                  0.0                 \n",
       "2                                                  0.0                 \n",
       "3                                                  0.0                 \n",
       "4                                                  0.0                 \n",
       "..                                                 ...                 \n",
       "913                                                0.0                 \n",
       "914                                                0.0                 \n",
       "915                                               14.9                 \n",
       "916                                                0.0                 \n",
       "917                                                0.0                 \n",
       "\n",
       "      Latitude  Longitude                       Geometry  \n",
       "0    28.033886    1.659626    POINT (28.033886 1.659626)  \n",
       "1    28.033886    1.659626    POINT (28.033886 1.659626)  \n",
       "2    28.033886    1.659626    POINT (28.033886 1.659626)  \n",
       "3    28.033886    1.659626    POINT (28.033886 1.659626)  \n",
       "4    28.033886    1.659626    POINT (28.033886 1.659626)  \n",
       "..         ...         ...                           ...  \n",
       "913 -19.015438   29.154857  POINT (-19.015438 29.154857)  \n",
       "914 -19.015438   29.154857  POINT (-19.015438 29.154857)  \n",
       "915 -19.015438   29.154857  POINT (-19.015438 29.154857)  \n",
       "916 -19.015438   29.154857  POINT (-19.015438 29.154857)  \n",
       "917 -19.015438   29.154857  POINT (-19.015438 29.154857)  \n",
       "\n",
       "[918 rows x 26 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "malaria"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "a63f837e-74d3-4493-8165-7a052f8af090",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Algeria', 'Angola', 'Benin', 'Botswana', 'Burkina Faso',\n",
       "       'Burundi', 'Cabo Verde', 'Cameroon', 'Central African Republic',\n",
       "       'Chad', 'Comoros', 'Congo, Dem. Rep.', 'Congo, Rep.',\n",
       "       \"Cote d'Ivoire\", 'Djibouti', 'Egypt, Arab Rep.',\n",
       "       'Equatorial Guinea', 'Eritrea', 'Eswatini', 'Ethiopia', 'Gabon',\n",
       "       'Gambia, The', 'Ghana', 'Guinea', 'Guinea-Bissau', 'Kenya',\n",
       "       'Lesotho', 'Liberia', 'Libya', 'Madagascar', 'Malawi', 'Mali',\n",
       "       'Mauritania', 'Mauritius', 'Morocco', 'Mozambique', 'Namibia',\n",
       "       'Niger', 'Nigeria', 'Rwanda', 'Sao Tome and Principe', 'Senegal',\n",
       "       'Seychelles', 'Sierra Leone', 'Somalia', 'South Africa',\n",
       "       'South Sudan', 'Sudan', 'Tanzania', 'Togo', 'Tunisia', 'Uganda',\n",
       "       'Zambia', 'Zimbabwe'], dtype=object)"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "malaria[\"Country\"].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "63e52d08-ec83-42c5-9b47-948902225834",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 918 entries, 0 to 917\n",
      "Data columns (total 26 columns):\n",
      " #   Column                                                                            Non-Null Count  Dtype  \n",
      "---  ------                                                                            --------------  -----  \n",
      " 0   Country Code                                                                      918 non-null    object \n",
      " 1   Country                                                                           918 non-null    object \n",
      " 2   Income Group                                                                      918 non-null    object \n",
      " 3   Year                                                                              918 non-null    int64  \n",
      " 4   Incidence of malaria (per 1,000 population at risk)                               918 non-null    float64\n",
      " 5   People using at least basic drinking water services (% of population)             918 non-null    float64\n",
      " 6   People using at least basic drinking water services, rural (% of rural populatio  918 non-null    float64\n",
      " 7   People using at least basic drinking water services, urban (% of urban populatio  918 non-null    float64\n",
      " 8   People using at least basic sanitation services (% of population)                 918 non-null    float64\n",
      " 9   People using at least basic sanitation services, rural (% of rural population)    918 non-null    float64\n",
      " 10  People using at least basic sanitation services, urban (% of urban population)    918 non-null    float64\n",
      " 11  Children with fever receiving antimalarial drugs (% of children under age 5 with  918 non-null    float64\n",
      " 12  Death rate, crude (per 1,000 people).1                                            918 non-null    float64\n",
      " 13  Literacy rate, adult total (% of people ages 15 and above).1                      918 non-null    float64\n",
      " 14  Rural population (% of total population).1                                        918 non-null    float64\n",
      " 15  People using safely managed drinking water services (% of population)             918 non-null    float64\n",
      " 16  People using safely managed drinking water services, rural (% of rural populatio  918 non-null    float64\n",
      " 17  People using safely managed drinking water services, urban (% of urban populatio  918 non-null    float64\n",
      " 18  People using safely managed sanitation services (% of population)                 918 non-null    float64\n",
      " 19  People using safely managed sanitation services, rural (% of rural population)    918 non-null    float64\n",
      " 20  People using safely managed sanitation services, urban (% of urban population)    918 non-null    float64\n",
      " 21  Urban population (% of total population).1                                        918 non-null    float64\n",
      " 22  Use of insecticide-treated bed nets (% of under-5 population).1                   918 non-null    float64\n",
      " 23  Latitude                                                                          918 non-null    float64\n",
      " 24  Longitude                                                                         918 non-null    float64\n",
      " 25  Geometry                                                                          918 non-null    object \n",
      "dtypes: float64(21), int64(1), object(4)\n",
      "memory usage: 186.6+ KB\n"
     ]
    }
   ],
   "source": [
    "malaria.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "e4d2560d-d824-4bf5-86c2-02a0eeb8272e",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Check the pattern for missing values\n",
    "# msno.matrix(malaria)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "68dfa80c-32ce-4f58-8c52-bb02d08a5092",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Country Code', 'Country', 'Income Group', 'Year',\n",
       "       'Incidence of malaria (per 1,000 population at risk)',\n",
       "       'People using at least basic drinking water services (% of population)',\n",
       "       'People using at least basic drinking water services, rural (% of rural populatio',\n",
       "       'People using at least basic drinking water services, urban (% of urban populatio',\n",
       "       'People using at least basic sanitation services (% of population)',\n",
       "       'People using at least basic sanitation services, rural (% of rural population)',\n",
       "       'People using at least basic sanitation services, urban (% of urban population)',\n",
       "       'Children with fever receiving antimalarial drugs (% of children under age 5 with',\n",
       "       'Death rate, crude (per 1,000 people).1',\n",
       "       'Literacy rate, adult total (% of people ages 15 and above).1',\n",
       "       'Rural population (% of total population).1',\n",
       "       'People using safely managed drinking water services (% of population)',\n",
       "       'People using safely managed drinking water services, rural (% of rural populatio',\n",
       "       'People using safely managed drinking water services, urban (% of urban populatio',\n",
       "       'People using safely managed sanitation services (% of population)',\n",
       "       'People using safely managed sanitation services, rural (% of rural population)',\n",
       "       'People using safely managed sanitation services, urban (% of urban population)',\n",
       "       'Urban population (% of total population).1',\n",
       "       'Use of insecticide-treated bed nets (% of under-5 population).1',\n",
       "       'Latitude', 'Longitude ', 'Geometry'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "malaria.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "b9c7c064-de6f-44db-baab-24850da82bea",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "# rename columns names using dictionary \n",
    "\n",
    "mapping = {malaria.columns[4]: 'incidence_rate',\n",
    "           malaria.columns[5]: '% basic_DW_all',\n",
    "           malaria.columns[6]: '% basic_DW_rural',\n",
    "           malaria.columns[7]: '% basic_DW_urban',\n",
    "           malaria.columns[8]: '% basic_sanitation_all',\n",
    "           malaria.columns[9]: '% basic_sanitation_rural',\n",
    "           malaria.columns[10]: '% basic_sanitation_urban',\n",
    "           malaria.columns[11]: '% death_rate',\n",
    "           malaria.columns[12]: '% children_with_fever',\n",
    "           malaria.columns[13]: '% literacy_rate',\n",
    "           malaria.columns[14]: '% rural_pop',\n",
    "           malaria.columns[15]: '% safe_DW_all',\n",
    "           malaria.columns[16]: '% safe_DW_rural',\n",
    "           malaria.columns[17]: '% safe_DW_urban',\n",
    "           malaria.columns[18]: '% safe_sanitation_all',\n",
    "           malaria.columns[19]: '% safe_sanitation_rural',\n",
    "           malaria.columns[20]: '% safe_sanitation_urban',\n",
    "           malaria.columns[21]: '% urban_pop',\n",
    "           malaria.columns[22]: '% insecticide',\n",
    "          }\n",
    "\n",
    "malaria = malaria.rename(columns=mapping)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "390568a4-b7a9-426e-b4c5-fb4e6b244006",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Country Code</th>\n",
       "      <th>Country</th>\n",
       "      <th>Income Group</th>\n",
       "      <th>Year</th>\n",
       "      <th>incidence_rate</th>\n",
       "      <th>% basic_DW_all</th>\n",
       "      <th>% basic_DW_rural</th>\n",
       "      <th>% basic_DW_urban</th>\n",
       "      <th>% basic_sanitation_all</th>\n",
       "      <th>% basic_sanitation_rural</th>\n",
       "      <th>% basic_sanitation_urban</th>\n",
       "      <th>% death_rate</th>\n",
       "      <th>% children_with_fever</th>\n",
       "      <th>% literacy_rate</th>\n",
       "      <th>% rural_pop</th>\n",
       "      <th>% safe_DW_all</th>\n",
       "      <th>% safe_DW_rural</th>\n",
       "      <th>% safe_DW_urban</th>\n",
       "      <th>% safe_sanitation_all</th>\n",
       "      <th>% safe_sanitation_rural</th>\n",
       "      <th>% safe_sanitation_urban</th>\n",
       "      <th>% urban_pop</th>\n",
       "      <th>% insecticide</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>DZA</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>Lower middle income</td>\n",
       "      <td>2005</td>\n",
       "      <td>0.0</td>\n",
       "      <td>91.1</td>\n",
       "      <td>85.0</td>\n",
       "      <td>94.6</td>\n",
       "      <td>85.8</td>\n",
       "      <td>75.4</td>\n",
       "      <td>91.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.9</td>\n",
       "      <td>0.0</td>\n",
       "      <td>36.2</td>\n",
       "      <td>72.8</td>\n",
       "      <td>56.5</td>\n",
       "      <td>82.0</td>\n",
       "      <td>60.5</td>\n",
       "      <td>50.4</td>\n",
       "      <td>66.2</td>\n",
       "      <td>63.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>28.033886</td>\n",
       "      <td>1.659626</td>\n",
       "      <td>POINT (28.033886 1.659626)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>DZA</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>Lower middle income</td>\n",
       "      <td>2006</td>\n",
       "      <td>0.0</td>\n",
       "      <td>91.4</td>\n",
       "      <td>85.4</td>\n",
       "      <td>94.7</td>\n",
       "      <td>86.1</td>\n",
       "      <td>75.7</td>\n",
       "      <td>91.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.9</td>\n",
       "      <td>72.6</td>\n",
       "      <td>35.4</td>\n",
       "      <td>73.2</td>\n",
       "      <td>57.4</td>\n",
       "      <td>81.9</td>\n",
       "      <td>60.8</td>\n",
       "      <td>50.8</td>\n",
       "      <td>66.3</td>\n",
       "      <td>64.6</td>\n",
       "      <td>0.0</td>\n",
       "      <td>28.033886</td>\n",
       "      <td>1.659626</td>\n",
       "      <td>POINT (28.033886 1.659626)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>DZA</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>Lower middle income</td>\n",
       "      <td>2007</td>\n",
       "      <td>0.0</td>\n",
       "      <td>91.6</td>\n",
       "      <td>85.7</td>\n",
       "      <td>94.7</td>\n",
       "      <td>86.3</td>\n",
       "      <td>76.1</td>\n",
       "      <td>91.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.9</td>\n",
       "      <td>0.0</td>\n",
       "      <td>34.7</td>\n",
       "      <td>73.7</td>\n",
       "      <td>58.3</td>\n",
       "      <td>81.9</td>\n",
       "      <td>61.1</td>\n",
       "      <td>51.2</td>\n",
       "      <td>66.4</td>\n",
       "      <td>65.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>28.033886</td>\n",
       "      <td>1.659626</td>\n",
       "      <td>POINT (28.033886 1.659626)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>DZA</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>Lower middle income</td>\n",
       "      <td>2008</td>\n",
       "      <td>0.0</td>\n",
       "      <td>91.8</td>\n",
       "      <td>86.0</td>\n",
       "      <td>94.8</td>\n",
       "      <td>86.5</td>\n",
       "      <td>76.4</td>\n",
       "      <td>91.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.9</td>\n",
       "      <td>75.1</td>\n",
       "      <td>33.9</td>\n",
       "      <td>74.2</td>\n",
       "      <td>59.3</td>\n",
       "      <td>81.8</td>\n",
       "      <td>61.4</td>\n",
       "      <td>51.6</td>\n",
       "      <td>66.4</td>\n",
       "      <td>66.1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>28.033886</td>\n",
       "      <td>1.659626</td>\n",
       "      <td>POINT (28.033886 1.659626)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>DZA</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>Lower middle income</td>\n",
       "      <td>2009</td>\n",
       "      <td>0.0</td>\n",
       "      <td>92.1</td>\n",
       "      <td>86.4</td>\n",
       "      <td>94.9</td>\n",
       "      <td>86.8</td>\n",
       "      <td>76.7</td>\n",
       "      <td>91.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>33.2</td>\n",
       "      <td>74.6</td>\n",
       "      <td>60.2</td>\n",
       "      <td>81.8</td>\n",
       "      <td>61.7</td>\n",
       "      <td>52.0</td>\n",
       "      <td>66.5</td>\n",
       "      <td>66.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>28.033886</td>\n",
       "      <td>1.659626</td>\n",
       "      <td>POINT (28.033886 1.659626)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>913</th>\n",
       "      <td>ZWE</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>Lower middle income</td>\n",
       "      <td>2017</td>\n",
       "      <td>115.2</td>\n",
       "      <td>64.0</td>\n",
       "      <td>50.1</td>\n",
       "      <td>93.3</td>\n",
       "      <td>36.9</td>\n",
       "      <td>32.6</td>\n",
       "      <td>46.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>67.8</td>\n",
       "      <td>26.9</td>\n",
       "      <td>13.6</td>\n",
       "      <td>55.1</td>\n",
       "      <td>33.6</td>\n",
       "      <td>31.3</td>\n",
       "      <td>38.4</td>\n",
       "      <td>32.2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-19.015438</td>\n",
       "      <td>29.154857</td>\n",
       "      <td>POINT (-19.015438 29.154857)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>914</th>\n",
       "      <td>ZWE</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>Lower middle income</td>\n",
       "      <td>2018</td>\n",
       "      <td>53.6</td>\n",
       "      <td>63.5</td>\n",
       "      <td>49.5</td>\n",
       "      <td>93.2</td>\n",
       "      <td>36.4</td>\n",
       "      <td>32.4</td>\n",
       "      <td>44.6</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>67.8</td>\n",
       "      <td>26.8</td>\n",
       "      <td>13.3</td>\n",
       "      <td>55.2</td>\n",
       "      <td>33.5</td>\n",
       "      <td>31.1</td>\n",
       "      <td>38.7</td>\n",
       "      <td>32.2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-19.015438</td>\n",
       "      <td>29.154857</td>\n",
       "      <td>POINT (-19.015438 29.154857)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>915</th>\n",
       "      <td>ZWE</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>Lower middle income</td>\n",
       "      <td>2019</td>\n",
       "      <td>64.7</td>\n",
       "      <td>63.1</td>\n",
       "      <td>48.9</td>\n",
       "      <td>93.0</td>\n",
       "      <td>35.8</td>\n",
       "      <td>32.2</td>\n",
       "      <td>43.2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>67.8</td>\n",
       "      <td>26.7</td>\n",
       "      <td>13.1</td>\n",
       "      <td>55.3</td>\n",
       "      <td>33.0</td>\n",
       "      <td>30.9</td>\n",
       "      <td>37.4</td>\n",
       "      <td>32.2</td>\n",
       "      <td>14.9</td>\n",
       "      <td>-19.015438</td>\n",
       "      <td>29.154857</td>\n",
       "      <td>POINT (-19.015438 29.154857)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>916</th>\n",
       "      <td>ZWE</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>Lower middle income</td>\n",
       "      <td>2020</td>\n",
       "      <td>93.4</td>\n",
       "      <td>62.7</td>\n",
       "      <td>48.3</td>\n",
       "      <td>92.9</td>\n",
       "      <td>35.2</td>\n",
       "      <td>32.0</td>\n",
       "      <td>41.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>67.8</td>\n",
       "      <td>26.6</td>\n",
       "      <td>12.9</td>\n",
       "      <td>55.4</td>\n",
       "      <td>32.4</td>\n",
       "      <td>30.6</td>\n",
       "      <td>36.0</td>\n",
       "      <td>32.2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-19.015438</td>\n",
       "      <td>29.154857</td>\n",
       "      <td>POINT (-19.015438 29.154857)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>917</th>\n",
       "      <td>ZWE</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>Lower middle income</td>\n",
       "      <td>2021</td>\n",
       "      <td>27.2</td>\n",
       "      <td>62.3</td>\n",
       "      <td>47.7</td>\n",
       "      <td>92.8</td>\n",
       "      <td>34.6</td>\n",
       "      <td>31.8</td>\n",
       "      <td>40.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>67.7</td>\n",
       "      <td>26.5</td>\n",
       "      <td>12.6</td>\n",
       "      <td>55.5</td>\n",
       "      <td>31.8</td>\n",
       "      <td>30.4</td>\n",
       "      <td>34.7</td>\n",
       "      <td>32.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-19.015438</td>\n",
       "      <td>29.154857</td>\n",
       "      <td>POINT (-19.015438 29.154857)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>918 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Country Code   Country         Income Group  Year  incidence_rate  \\\n",
       "0            DZA   Algeria  Lower middle income  2005             0.0   \n",
       "1            DZA   Algeria  Lower middle income  2006             0.0   \n",
       "2            DZA   Algeria  Lower middle income  2007             0.0   \n",
       "3            DZA   Algeria  Lower middle income  2008             0.0   \n",
       "4            DZA   Algeria  Lower middle income  2009             0.0   \n",
       "..           ...       ...                  ...   ...             ...   \n",
       "913          ZWE  Zimbabwe  Lower middle income  2017           115.2   \n",
       "914          ZWE  Zimbabwe  Lower middle income  2018            53.6   \n",
       "915          ZWE  Zimbabwe  Lower middle income  2019            64.7   \n",
       "916          ZWE  Zimbabwe  Lower middle income  2020            93.4   \n",
       "917          ZWE  Zimbabwe  Lower middle income  2021            27.2   \n",
       "\n",
       "     % basic_DW_all  % basic_DW_rural  % basic_DW_urban  \\\n",
       "0              91.1              85.0              94.6   \n",
       "1              91.4              85.4              94.7   \n",
       "2              91.6              85.7              94.7   \n",
       "3              91.8              86.0              94.8   \n",
       "4              92.1              86.4              94.9   \n",
       "..              ...               ...               ...   \n",
       "913            64.0              50.1              93.3   \n",
       "914            63.5              49.5              93.2   \n",
       "915            63.1              48.9              93.0   \n",
       "916            62.7              48.3              92.9   \n",
       "917            62.3              47.7              92.8   \n",
       "\n",
       "     % basic_sanitation_all  % basic_sanitation_rural  \\\n",
       "0                      85.8                      75.4   \n",
       "1                      86.1                      75.7   \n",
       "2                      86.3                      76.1   \n",
       "3                      86.5                      76.4   \n",
       "4                      86.8                      76.7   \n",
       "..                      ...                       ...   \n",
       "913                    36.9                      32.6   \n",
       "914                    36.4                      32.4   \n",
       "915                    35.8                      32.2   \n",
       "916                    35.2                      32.0   \n",
       "917                    34.6                      31.8   \n",
       "\n",
       "     % basic_sanitation_urban  % death_rate  % children_with_fever  \\\n",
       "0                        91.7           0.0                    4.9   \n",
       "1                        91.7           0.0                    4.9   \n",
       "2                        91.7           0.0                    4.9   \n",
       "3                        91.7           0.0                    4.9   \n",
       "4                        91.7           0.0                    4.7   \n",
       "..                        ...           ...                    ...   \n",
       "913                      46.0           0.0                    8.3   \n",
       "914                      44.6           0.0                    8.0   \n",
       "915                      43.2           0.0                    8.0   \n",
       "916                      41.8           0.0                    8.1   \n",
       "917                      40.4           0.0                    9.1   \n",
       "\n",
       "     % literacy_rate  % rural_pop  % safe_DW_all  % safe_DW_rural  \\\n",
       "0                0.0         36.2           72.8             56.5   \n",
       "1               72.6         35.4           73.2             57.4   \n",
       "2                0.0         34.7           73.7             58.3   \n",
       "3               75.1         33.9           74.2             59.3   \n",
       "4                0.0         33.2           74.6             60.2   \n",
       "..               ...          ...            ...              ...   \n",
       "913              0.0         67.8           26.9             13.6   \n",
       "914              0.0         67.8           26.8             13.3   \n",
       "915              0.0         67.8           26.7             13.1   \n",
       "916              0.0         67.8           26.6             12.9   \n",
       "917              0.0         67.7           26.5             12.6   \n",
       "\n",
       "     % safe_DW_urban  % safe_sanitation_all  % safe_sanitation_rural  \\\n",
       "0               82.0                   60.5                     50.4   \n",
       "1               81.9                   60.8                     50.8   \n",
       "2               81.9                   61.1                     51.2   \n",
       "3               81.8                   61.4                     51.6   \n",
       "4               81.8                   61.7                     52.0   \n",
       "..               ...                    ...                      ...   \n",
       "913             55.1                   33.6                     31.3   \n",
       "914             55.2                   33.5                     31.1   \n",
       "915             55.3                   33.0                     30.9   \n",
       "916             55.4                   32.4                     30.6   \n",
       "917             55.5                   31.8                     30.4   \n",
       "\n",
       "     % safe_sanitation_urban  % urban_pop  % insecticide   Latitude  \\\n",
       "0                       66.2         63.8            0.0  28.033886   \n",
       "1                       66.3         64.6            0.0  28.033886   \n",
       "2                       66.4         65.3            0.0  28.033886   \n",
       "3                       66.4         66.1            0.0  28.033886   \n",
       "4                       66.5         66.8            0.0  28.033886   \n",
       "..                       ...          ...            ...        ...   \n",
       "913                     38.4         32.2            0.0 -19.015438   \n",
       "914                     38.7         32.2            0.0 -19.015438   \n",
       "915                     37.4         32.2           14.9 -19.015438   \n",
       "916                     36.0         32.2            0.0 -19.015438   \n",
       "917                     34.7         32.3            0.0 -19.015438   \n",
       "\n",
       "     Longitude                       Geometry  \n",
       "0      1.659626    POINT (28.033886 1.659626)  \n",
       "1      1.659626    POINT (28.033886 1.659626)  \n",
       "2      1.659626    POINT (28.033886 1.659626)  \n",
       "3      1.659626    POINT (28.033886 1.659626)  \n",
       "4      1.659626    POINT (28.033886 1.659626)  \n",
       "..          ...                           ...  \n",
       "913   29.154857  POINT (-19.015438 29.154857)  \n",
       "914   29.154857  POINT (-19.015438 29.154857)  \n",
       "915   29.154857  POINT (-19.015438 29.154857)  \n",
       "916   29.154857  POINT (-19.015438 29.154857)  \n",
       "917   29.154857  POINT (-19.015438 29.154857)  \n",
       "\n",
       "[918 rows x 26 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "malaria"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8b165176-cb2e-4c88-b502-5a6dedbdbd8e",
   "metadata": {
    "tags": []
   },
   "source": [
    "#### Climate Change Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "1ece2e5d-859f-4f41-b304-ee8b42a8433a",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>Location</th>\n",
       "      <th>Country</th>\n",
       "      <th>Temperature</th>\n",
       "      <th>CO2 Emissions</th>\n",
       "      <th>Sea Level Rise</th>\n",
       "      <th>Precipitation</th>\n",
       "      <th>Humidity</th>\n",
       "      <th>Wind Speed</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2000-01-01 00:00:00.000000000</td>\n",
       "      <td>New Williamtown</td>\n",
       "      <td>Latvia</td>\n",
       "      <td>10.688986</td>\n",
       "      <td>403.118903</td>\n",
       "      <td>0.717506</td>\n",
       "      <td>13.835237</td>\n",
       "      <td>23.631256</td>\n",
       "      <td>18.492026</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2000-01-01 20:09:43.258325832</td>\n",
       "      <td>North Rachel</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>13.814430</td>\n",
       "      <td>396.663499</td>\n",
       "      <td>1.205715</td>\n",
       "      <td>40.974084</td>\n",
       "      <td>43.982946</td>\n",
       "      <td>34.249300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2000-01-02 16:19:26.516651665</td>\n",
       "      <td>West Williamland</td>\n",
       "      <td>French Guiana</td>\n",
       "      <td>27.323718</td>\n",
       "      <td>451.553155</td>\n",
       "      <td>-0.160783</td>\n",
       "      <td>42.697931</td>\n",
       "      <td>96.652600</td>\n",
       "      <td>34.124261</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2000-01-03 12:29:09.774977497</td>\n",
       "      <td>South David</td>\n",
       "      <td>Vietnam</td>\n",
       "      <td>12.309581</td>\n",
       "      <td>422.404983</td>\n",
       "      <td>-0.475931</td>\n",
       "      <td>5.193341</td>\n",
       "      <td>47.467938</td>\n",
       "      <td>8.554563</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2000-01-04 08:38:53.033303330</td>\n",
       "      <td>New Scottburgh</td>\n",
       "      <td>Moldova</td>\n",
       "      <td>13.210885</td>\n",
       "      <td>410.472999</td>\n",
       "      <td>1.135757</td>\n",
       "      <td>78.695280</td>\n",
       "      <td>61.789672</td>\n",
       "      <td>8.001164</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                            Date          Location        Country  \\\n",
       "0  2000-01-01 00:00:00.000000000   New Williamtown         Latvia   \n",
       "1  2000-01-01 20:09:43.258325832      North Rachel   South Africa   \n",
       "2  2000-01-02 16:19:26.516651665  West Williamland  French Guiana   \n",
       "3  2000-01-03 12:29:09.774977497       South David        Vietnam   \n",
       "4  2000-01-04 08:38:53.033303330    New Scottburgh        Moldova   \n",
       "\n",
       "   Temperature  CO2 Emissions  Sea Level Rise  Precipitation   Humidity  \\\n",
       "0    10.688986     403.118903        0.717506      13.835237  23.631256   \n",
       "1    13.814430     396.663499        1.205715      40.974084  43.982946   \n",
       "2    27.323718     451.553155       -0.160783      42.697931  96.652600   \n",
       "3    12.309581     422.404983       -0.475931       5.193341  47.467938   \n",
       "4    13.210885     410.472999        1.135757      78.695280  61.789672   \n",
       "\n",
       "   Wind Speed  \n",
       "0   18.492026  \n",
       "1   34.249300  \n",
       "2   34.124261  \n",
       "3    8.554563  \n",
       "4    8.001164  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "climate = pd.read_csv('climate_change_data.csv')\n",
    "climate.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "2f84fb27-6d26-45dc-a51d-f355a9d87d72",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(10000, 9)"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "climate.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "d1e91a3b-4649-48ac-a23d-7ea2e5417940",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "africa_climate = climate.loc[climate['Country'].isin(['Algeria', 'Angola', 'Benin', 'Botswana', 'Burkina Faso','Burundi',\n",
    "                'Cabo Verde', 'Cameroon', 'Central African Republic', 'Chad', 'Comoros', 'Congo, Dem. Rep.', 'Congo, Rep.', \n",
    "                \"Cote d'Ivoire\", 'Djibouti', 'Egypt, Arab Rep.','Equatorial Guinea', 'Eritrea', 'Eswatini', 'Ethiopia', \n",
    "                'Gabon', 'Gambia, The', 'Ghana', 'Guinea', 'Guinea-Bissau', 'Kenya','Lesotho', 'Liberia', 'Libya', 'Madagascar', \n",
    "                'Malawi', 'Mali','Mauritania', 'Mauritius', 'Morocco', 'Mozambique', 'Namibia', 'Niger', 'Nigeria', 'Rwanda', \n",
    "                'Sao Tome and Principe', 'Senegal','Seychelles', 'Sierra Leone', 'Somalia', 'South Africa', 'South Sudan',\n",
    "                'Sudan', 'Tanzania', 'Togo', 'Tunisia', 'Uganda','Zambia', 'Zimbabwe'])]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "b40508e5-ea69-46c9-a88f-79c76dadc4cc",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>Location</th>\n",
       "      <th>Country</th>\n",
       "      <th>Temperature</th>\n",
       "      <th>CO2 Emissions</th>\n",
       "      <th>Sea Level Rise</th>\n",
       "      <th>Precipitation</th>\n",
       "      <th>Humidity</th>\n",
       "      <th>Wind Speed</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2000-01-01 20:09:43.258325832</td>\n",
       "      <td>North Rachel</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>13.814430</td>\n",
       "      <td>396.663499</td>\n",
       "      <td>1.205715</td>\n",
       "      <td>40.974084</td>\n",
       "      <td>43.982946</td>\n",
       "      <td>34.249300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2000-01-08 13:27:29.324932493</td>\n",
       "      <td>North Thomas</td>\n",
       "      <td>Chad</td>\n",
       "      <td>14.121563</td>\n",
       "      <td>410.517072</td>\n",
       "      <td>-1.712224</td>\n",
       "      <td>15.351583</td>\n",
       "      <td>88.422794</td>\n",
       "      <td>47.922521</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2000-01-11 22:06:22.358235823</td>\n",
       "      <td>Hughesville</td>\n",
       "      <td>Rwanda</td>\n",
       "      <td>15.788181</td>\n",
       "      <td>373.341298</td>\n",
       "      <td>-2.061536</td>\n",
       "      <td>13.361683</td>\n",
       "      <td>56.944885</td>\n",
       "      <td>23.386008</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2000-01-14 10:35:32.133213321</td>\n",
       "      <td>Port Robertborough</td>\n",
       "      <td>Equatorial Guinea</td>\n",
       "      <td>14.799344</td>\n",
       "      <td>396.997808</td>\n",
       "      <td>-1.086790</td>\n",
       "      <td>23.288764</td>\n",
       "      <td>37.695590</td>\n",
       "      <td>41.688415</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2000-01-16 23:04:41.908190819</td>\n",
       "      <td>Bakerburgh</td>\n",
       "      <td>Mali</td>\n",
       "      <td>10.874589</td>\n",
       "      <td>415.608633</td>\n",
       "      <td>1.218314</td>\n",
       "      <td>57.990681</td>\n",
       "      <td>15.764407</td>\n",
       "      <td>10.098797</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9988</th>\n",
       "      <td>2022-12-21 18:13:04.158415744</td>\n",
       "      <td>New Sandra</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>15.292410</td>\n",
       "      <td>363.940234</td>\n",
       "      <td>1.092427</td>\n",
       "      <td>38.633572</td>\n",
       "      <td>50.161462</td>\n",
       "      <td>45.363407</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9990</th>\n",
       "      <td>2022-12-23 10:32:30.675067392</td>\n",
       "      <td>Taylorbury</td>\n",
       "      <td>Gabon</td>\n",
       "      <td>16.144944</td>\n",
       "      <td>446.058349</td>\n",
       "      <td>-1.410918</td>\n",
       "      <td>91.810285</td>\n",
       "      <td>31.853808</td>\n",
       "      <td>4.659991</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9993</th>\n",
       "      <td>2022-12-25 23:01:40.450044928</td>\n",
       "      <td>South Joseph</td>\n",
       "      <td>Cameroon</td>\n",
       "      <td>17.667267</td>\n",
       "      <td>423.686881</td>\n",
       "      <td>1.033963</td>\n",
       "      <td>66.063186</td>\n",
       "      <td>35.660745</td>\n",
       "      <td>12.749542</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9994</th>\n",
       "      <td>2022-12-26 19:11:23.708370816</td>\n",
       "      <td>New Thomas</td>\n",
       "      <td>Mozambique</td>\n",
       "      <td>17.147936</td>\n",
       "      <td>414.475259</td>\n",
       "      <td>-0.046996</td>\n",
       "      <td>20.815504</td>\n",
       "      <td>39.215362</td>\n",
       "      <td>15.988626</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9999</th>\n",
       "      <td>2022-12-31 00:00:00.000000000</td>\n",
       "      <td>West Anthonyburgh</td>\n",
       "      <td>Sao Tome and Principe</td>\n",
       "      <td>12.661928</td>\n",
       "      <td>381.172746</td>\n",
       "      <td>2.260788</td>\n",
       "      <td>78.339658</td>\n",
       "      <td>99.243923</td>\n",
       "      <td>41.856539</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1920 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                               Date            Location  \\\n",
       "1     2000-01-01 20:09:43.258325832        North Rachel   \n",
       "9     2000-01-08 13:27:29.324932493        North Thomas   \n",
       "13    2000-01-11 22:06:22.358235823         Hughesville   \n",
       "16    2000-01-14 10:35:32.133213321  Port Robertborough   \n",
       "19    2000-01-16 23:04:41.908190819          Bakerburgh   \n",
       "...                             ...                 ...   \n",
       "9988  2022-12-21 18:13:04.158415744          New Sandra   \n",
       "9990  2022-12-23 10:32:30.675067392          Taylorbury   \n",
       "9993  2022-12-25 23:01:40.450044928        South Joseph   \n",
       "9994  2022-12-26 19:11:23.708370816          New Thomas   \n",
       "9999  2022-12-31 00:00:00.000000000   West Anthonyburgh   \n",
       "\n",
       "                    Country  Temperature  CO2 Emissions  Sea Level Rise  \\\n",
       "1              South Africa    13.814430     396.663499        1.205715   \n",
       "9                      Chad    14.121563     410.517072       -1.712224   \n",
       "13                   Rwanda    15.788181     373.341298       -2.061536   \n",
       "16        Equatorial Guinea    14.799344     396.997808       -1.086790   \n",
       "19                     Mali    10.874589     415.608633        1.218314   \n",
       "...                     ...          ...            ...             ...   \n",
       "9988                Algeria    15.292410     363.940234        1.092427   \n",
       "9990                  Gabon    16.144944     446.058349       -1.410918   \n",
       "9993               Cameroon    17.667267     423.686881        1.033963   \n",
       "9994             Mozambique    17.147936     414.475259       -0.046996   \n",
       "9999  Sao Tome and Principe    12.661928     381.172746        2.260788   \n",
       "\n",
       "      Precipitation   Humidity  Wind Speed  \n",
       "1         40.974084  43.982946   34.249300  \n",
       "9         15.351583  88.422794   47.922521  \n",
       "13        13.361683  56.944885   23.386008  \n",
       "16        23.288764  37.695590   41.688415  \n",
       "19        57.990681  15.764407   10.098797  \n",
       "...             ...        ...         ...  \n",
       "9988      38.633572  50.161462   45.363407  \n",
       "9990      91.810285  31.853808    4.659991  \n",
       "9993      66.063186  35.660745   12.749542  \n",
       "9994      20.815504  39.215362   15.988626  \n",
       "9999      78.339658  99.243923   41.856539  \n",
       "\n",
       "[1920 rows x 9 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "africa_climate"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "d1d6ff13-c55d-4169-8fa0-665aae755a82",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "46"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "africa_climate[\"Country\"].nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "dd9e4872-ca49-4b0d-802b-471dfcfc5c3d",
   "metadata": {},
   "outputs": [],
   "source": [
    "africa_climate.to_csv('climate_change_africa.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "f6de02fc-c0bd-4696-849a-0056f8727e31",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "africa_climate = pd.read_csv(\"climate_change_africa.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "71f5662a-fa07-4563-8488-c8430c1b49f8",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>Date</th>\n",
       "      <th>Location</th>\n",
       "      <th>Country</th>\n",
       "      <th>Temperature</th>\n",
       "      <th>CO2 Emissions</th>\n",
       "      <th>Sea Level Rise</th>\n",
       "      <th>Precipitation</th>\n",
       "      <th>Humidity</th>\n",
       "      <th>Wind Speed</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>2000-01-01 20:09:43.258325832</td>\n",
       "      <td>North Rachel</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>13.814430</td>\n",
       "      <td>396.663499</td>\n",
       "      <td>1.205715</td>\n",
       "      <td>40.974084</td>\n",
       "      <td>43.982946</td>\n",
       "      <td>34.249300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>9</td>\n",
       "      <td>2000-01-08 13:27:29.324932493</td>\n",
       "      <td>North Thomas</td>\n",
       "      <td>Chad</td>\n",
       "      <td>14.121563</td>\n",
       "      <td>410.517072</td>\n",
       "      <td>-1.712224</td>\n",
       "      <td>15.351583</td>\n",
       "      <td>88.422794</td>\n",
       "      <td>47.922521</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>13</td>\n",
       "      <td>2000-01-11 22:06:22.358235823</td>\n",
       "      <td>Hughesville</td>\n",
       "      <td>Rwanda</td>\n",
       "      <td>15.788181</td>\n",
       "      <td>373.341298</td>\n",
       "      <td>-2.061536</td>\n",
       "      <td>13.361683</td>\n",
       "      <td>56.944885</td>\n",
       "      <td>23.386008</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>16</td>\n",
       "      <td>2000-01-14 10:35:32.133213321</td>\n",
       "      <td>Port Robertborough</td>\n",
       "      <td>Equatorial Guinea</td>\n",
       "      <td>14.799344</td>\n",
       "      <td>396.997808</td>\n",
       "      <td>-1.086790</td>\n",
       "      <td>23.288764</td>\n",
       "      <td>37.695590</td>\n",
       "      <td>41.688415</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>19</td>\n",
       "      <td>2000-01-16 23:04:41.908190819</td>\n",
       "      <td>Bakerburgh</td>\n",
       "      <td>Mali</td>\n",
       "      <td>10.874589</td>\n",
       "      <td>415.608633</td>\n",
       "      <td>1.218314</td>\n",
       "      <td>57.990681</td>\n",
       "      <td>15.764407</td>\n",
       "      <td>10.098797</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1915</th>\n",
       "      <td>9988</td>\n",
       "      <td>2022-12-21 18:13:04.158415744</td>\n",
       "      <td>New Sandra</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>15.292410</td>\n",
       "      <td>363.940234</td>\n",
       "      <td>1.092427</td>\n",
       "      <td>38.633572</td>\n",
       "      <td>50.161462</td>\n",
       "      <td>45.363407</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1916</th>\n",
       "      <td>9990</td>\n",
       "      <td>2022-12-23 10:32:30.675067392</td>\n",
       "      <td>Taylorbury</td>\n",
       "      <td>Gabon</td>\n",
       "      <td>16.144944</td>\n",
       "      <td>446.058349</td>\n",
       "      <td>-1.410918</td>\n",
       "      <td>91.810285</td>\n",
       "      <td>31.853808</td>\n",
       "      <td>4.659991</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1917</th>\n",
       "      <td>9993</td>\n",
       "      <td>2022-12-25 23:01:40.450044928</td>\n",
       "      <td>South Joseph</td>\n",
       "      <td>Cameroon</td>\n",
       "      <td>17.667267</td>\n",
       "      <td>423.686881</td>\n",
       "      <td>1.033963</td>\n",
       "      <td>66.063186</td>\n",
       "      <td>35.660745</td>\n",
       "      <td>12.749542</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1918</th>\n",
       "      <td>9994</td>\n",
       "      <td>2022-12-26 19:11:23.708370816</td>\n",
       "      <td>New Thomas</td>\n",
       "      <td>Mozambique</td>\n",
       "      <td>17.147936</td>\n",
       "      <td>414.475259</td>\n",
       "      <td>-0.046996</td>\n",
       "      <td>20.815504</td>\n",
       "      <td>39.215362</td>\n",
       "      <td>15.988626</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1919</th>\n",
       "      <td>9999</td>\n",
       "      <td>2022-12-31 00:00:00.000000000</td>\n",
       "      <td>West Anthonyburgh</td>\n",
       "      <td>Sao Tome and Principe</td>\n",
       "      <td>12.661928</td>\n",
       "      <td>381.172746</td>\n",
       "      <td>2.260788</td>\n",
       "      <td>78.339658</td>\n",
       "      <td>99.243923</td>\n",
       "      <td>41.856539</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1920 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Unnamed: 0                           Date            Location  \\\n",
       "0              1  2000-01-01 20:09:43.258325832        North Rachel   \n",
       "1              9  2000-01-08 13:27:29.324932493        North Thomas   \n",
       "2             13  2000-01-11 22:06:22.358235823         Hughesville   \n",
       "3             16  2000-01-14 10:35:32.133213321  Port Robertborough   \n",
       "4             19  2000-01-16 23:04:41.908190819          Bakerburgh   \n",
       "...          ...                            ...                 ...   \n",
       "1915        9988  2022-12-21 18:13:04.158415744          New Sandra   \n",
       "1916        9990  2022-12-23 10:32:30.675067392          Taylorbury   \n",
       "1917        9993  2022-12-25 23:01:40.450044928        South Joseph   \n",
       "1918        9994  2022-12-26 19:11:23.708370816          New Thomas   \n",
       "1919        9999  2022-12-31 00:00:00.000000000   West Anthonyburgh   \n",
       "\n",
       "                    Country  Temperature  CO2 Emissions  Sea Level Rise  \\\n",
       "0              South Africa    13.814430     396.663499        1.205715   \n",
       "1                      Chad    14.121563     410.517072       -1.712224   \n",
       "2                    Rwanda    15.788181     373.341298       -2.061536   \n",
       "3         Equatorial Guinea    14.799344     396.997808       -1.086790   \n",
       "4                      Mali    10.874589     415.608633        1.218314   \n",
       "...                     ...          ...            ...             ...   \n",
       "1915                Algeria    15.292410     363.940234        1.092427   \n",
       "1916                  Gabon    16.144944     446.058349       -1.410918   \n",
       "1917               Cameroon    17.667267     423.686881        1.033963   \n",
       "1918             Mozambique    17.147936     414.475259       -0.046996   \n",
       "1919  Sao Tome and Principe    12.661928     381.172746        2.260788   \n",
       "\n",
       "      Precipitation   Humidity  Wind Speed  \n",
       "0         40.974084  43.982946   34.249300  \n",
       "1         15.351583  88.422794   47.922521  \n",
       "2         13.361683  56.944885   23.386008  \n",
       "3         23.288764  37.695590   41.688415  \n",
       "4         57.990681  15.764407   10.098797  \n",
       "...             ...        ...         ...  \n",
       "1915      38.633572  50.161462   45.363407  \n",
       "1916      91.810285  31.853808    4.659991  \n",
       "1917      66.063186  35.660745   12.749542  \n",
       "1918      20.815504  39.215362   15.988626  \n",
       "1919      78.339658  99.243923   41.856539  \n",
       "\n",
       "[1920 rows x 10 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "africa_climate"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "d4010383-e219-40e3-a59e-d8f07823053f",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['Algeria' 'Angola' 'Benin' 'Botswana' 'Burkina Faso' 'Burundi' 'Cameroon'\n",
      " 'Central African Republic' 'Chad' 'Comoros' \"Cote d'Ivoire\" 'Djibouti'\n",
      " 'Equatorial Guinea' 'Eritrea' 'Ethiopia' 'Gabon' 'Ghana' 'Guinea'\n",
      " 'Guinea-Bissau' 'Kenya' 'Lesotho' 'Liberia' 'Madagascar' 'Malawi' 'Mali'\n",
      " 'Mauritania' 'Mauritius' 'Morocco' 'Mozambique' 'Namibia' 'Niger'\n",
      " 'Nigeria' 'Rwanda' 'Sao Tome and Principe' 'Senegal' 'Seychelles'\n",
      " 'Sierra Leone' 'Somalia' 'South Africa' 'Sudan' 'Tanzania' 'Togo'\n",
      " 'Tunisia' 'Uganda' 'Zambia' 'Zimbabwe']\n",
      "46\n"
     ]
    }
   ],
   "source": [
    "print(africa_climate[\"Country\"].sort_values().unique())\n",
    "print(africa_climate[\"Country\"].nunique())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "66d860ea-397d-4c42-a7e6-0fa8db364429",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 1920 entries, 0 to 1919\n",
      "Data columns (total 10 columns):\n",
      " #   Column          Non-Null Count  Dtype  \n",
      "---  ------          --------------  -----  \n",
      " 0   Unnamed: 0      1920 non-null   int64  \n",
      " 1   Date            1920 non-null   object \n",
      " 2   Location        1920 non-null   object \n",
      " 3   Country         1920 non-null   object \n",
      " 4   Temperature     1920 non-null   float64\n",
      " 5   CO2 Emissions   1920 non-null   float64\n",
      " 6   Sea Level Rise  1920 non-null   float64\n",
      " 7   Precipitation   1920 non-null   float64\n",
      " 8   Humidity        1920 non-null   float64\n",
      " 9   Wind Speed      1920 non-null   float64\n",
      "dtypes: float64(6), int64(1), object(3)\n",
      "memory usage: 150.1+ KB\n"
     ]
    }
   ],
   "source": [
    "africa_climate.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "cddf0b7d-172d-459d-afcc-46d25cc23fe0",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "# Convert the 'date' column to datetime if it's not already in datetime format\n",
    "africa_climate['Date'] = pd.to_datetime(africa_climate['Date'])\n",
    "\n",
    "# Extract the 'year' column from the 'date' column\n",
    "africa_climate['Year'] = africa_climate['Date'].dt.year\n",
    "\n",
    "# Subset the data to include only years from 2005 to 2021\n",
    "africa_climate_subset = africa_climate[(africa_climate['Year'] >= 2005) & (africa_climate['Year'] <= 2021)]\n",
    "\n",
    "# Split the DataFrame by country\n",
    "grouped = africa_climate_subset.groupby('Country')[\"Date\", \"Temperature\", \"Precipitation\", \"Humidity\", \"Wind Speed\"]\n",
    "\n",
    "# Initialize an empty DataFrame to store the resampled data\n",
    "resampled_dfs = []\n",
    "\n",
    "# Iterate through each group (country) and resample the time series data to yearly resolution\n",
    "for country, group_df in grouped:\n",
    "    # Resample the time series data to yearly resolution and sum the values\n",
    "    resampled_df = group_df.resample('Y', on='Date').mean().reset_index()\n",
    "    \n",
    "    # Add a 'country' column with the current country name\n",
    "    resampled_df['Country'] = country\n",
    "    \n",
    "    # Append the resampled DataFrame to the list\n",
    "    resampled_dfs.append(resampled_df)\n",
    "\n",
    "# Combine all resampled DataFrames into a single DataFrame\n",
    "africa_climate_new = pd.concat(resampled_dfs, ignore_index=True)\n",
    "\n",
    "# Fill missing values with 0\n",
    "africa_climate_new = africa_climate_new.fillna(0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "001797e9-134f-4f61-a2c1-b551841ce80f",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "africa_climate_new[\"Year\"] = africa_climate_new[\"Date\"].dt.year"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "59060dd7-f962-4462-af30-2406f6af4726",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "africa_climate_new.drop(columns=\"Date\", inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "6db4df57-3ce6-463c-85bc-e6f038eb3579",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Temperature      660\n",
       "Precipitation    660\n",
       "Humidity         660\n",
       "Wind Speed       660\n",
       "Country           46\n",
       "Year              17\n",
       "dtype: int64"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "africa_climate_new.nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "0776025a-b150-4c96-b5a8-823db5bedaf5",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Temperature</th>\n",
       "      <th>Precipitation</th>\n",
       "      <th>Humidity</th>\n",
       "      <th>Wind Speed</th>\n",
       "      <th>Country</th>\n",
       "      <th>Year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>13.504072</td>\n",
       "      <td>10.968121</td>\n",
       "      <td>31.734205</td>\n",
       "      <td>8.769347</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>2005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>2006</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>5.783653</td>\n",
       "      <td>74.638687</td>\n",
       "      <td>69.520863</td>\n",
       "      <td>25.478604</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>2007</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>7.554852</td>\n",
       "      <td>86.310334</td>\n",
       "      <td>52.958708</td>\n",
       "      <td>8.661352</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>2008</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>17.102406</td>\n",
       "      <td>44.402714</td>\n",
       "      <td>88.990603</td>\n",
       "      <td>26.639289</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>2009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>761</th>\n",
       "      <td>11.331474</td>\n",
       "      <td>77.844800</td>\n",
       "      <td>82.059757</td>\n",
       "      <td>24.699471</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>762</th>\n",
       "      <td>13.514309</td>\n",
       "      <td>64.274397</td>\n",
       "      <td>67.200243</td>\n",
       "      <td>32.318263</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>763</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>2019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>764</th>\n",
       "      <td>17.690752</td>\n",
       "      <td>7.302774</td>\n",
       "      <td>46.634126</td>\n",
       "      <td>30.698054</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>2020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>765</th>\n",
       "      <td>16.638985</td>\n",
       "      <td>88.509625</td>\n",
       "      <td>80.140177</td>\n",
       "      <td>14.681265</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>766 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Temperature  Precipitation   Humidity  Wind Speed   Country  Year\n",
       "0      13.504072      10.968121  31.734205    8.769347   Algeria  2005\n",
       "1       0.000000       0.000000   0.000000    0.000000   Algeria  2006\n",
       "2       5.783653      74.638687  69.520863   25.478604   Algeria  2007\n",
       "3       7.554852      86.310334  52.958708    8.661352   Algeria  2008\n",
       "4      17.102406      44.402714  88.990603   26.639289   Algeria  2009\n",
       "..           ...            ...        ...         ...       ...   ...\n",
       "761    11.331474      77.844800  82.059757   24.699471  Zimbabwe  2017\n",
       "762    13.514309      64.274397  67.200243   32.318263  Zimbabwe  2018\n",
       "763     0.000000       0.000000   0.000000    0.000000  Zimbabwe  2019\n",
       "764    17.690752       7.302774  46.634126   30.698054  Zimbabwe  2020\n",
       "765    16.638985      88.509625  80.140177   14.681265  Zimbabwe  2021\n",
       "\n",
       "[766 rows x 6 columns]"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "africa_climate_new"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "0b7b815d-8d49-49e4-895c-7b525ff5e433",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>Country</th>\n",
       "      <th colspan=\"17\" halign=\"left\">Humidity</th>\n",
       "      <th colspan=\"7\" halign=\"left\">Precipitation</th>\n",
       "      <th>...</th>\n",
       "      <th colspan=\"8\" halign=\"left\">Temperature</th>\n",
       "      <th colspan=\"17\" halign=\"left\">Wind Speed</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Year</th>\n",
       "      <th></th>\n",
       "      <th>2005</th>\n",
       "      <th>2006</th>\n",
       "      <th>2007</th>\n",
       "      <th>2008</th>\n",
       "      <th>2009</th>\n",
       "      <th>2010</th>\n",
       "      <th>2011</th>\n",
       "      <th>2012</th>\n",
       "      <th>2013</th>\n",
       "      <th>2014</th>\n",
       "      <th>2015</th>\n",
       "      <th>2016</th>\n",
       "      <th>2017</th>\n",
       "      <th>2018</th>\n",
       "      <th>2019</th>\n",
       "      <th>2020</th>\n",
       "      <th>2021</th>\n",
       "      <th>2005</th>\n",
       "      <th>2006</th>\n",
       "      <th>2007</th>\n",
       "      <th>2008</th>\n",
       "      <th>2009</th>\n",
       "      <th>2010</th>\n",
       "      <th>2011</th>\n",
       "      <th>...</th>\n",
       "      <th>2014</th>\n",
       "      <th>2015</th>\n",
       "      <th>2016</th>\n",
       "      <th>2017</th>\n",
       "      <th>2018</th>\n",
       "      <th>2019</th>\n",
       "      <th>2020</th>\n",
       "      <th>2021</th>\n",
       "      <th>2005</th>\n",
       "      <th>2006</th>\n",
       "      <th>2007</th>\n",
       "      <th>2008</th>\n",
       "      <th>2009</th>\n",
       "      <th>2010</th>\n",
       "      <th>2011</th>\n",
       "      <th>2012</th>\n",
       "      <th>2013</th>\n",
       "      <th>2014</th>\n",
       "      <th>2015</th>\n",
       "      <th>2016</th>\n",
       "      <th>2017</th>\n",
       "      <th>2018</th>\n",
       "      <th>2019</th>\n",
       "      <th>2020</th>\n",
       "      <th>2021</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Togo</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>73.181082</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>37.720680</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>61.730457</td>\n",
       "      <td>78.234777</td>\n",
       "      <td>11.049721</td>\n",
       "      <td>95.991481</td>\n",
       "      <td>63.889302</td>\n",
       "      <td>42.312771</td>\n",
       "      <td>29.037184</td>\n",
       "      <td>85.699043</td>\n",
       "      <td>60.615155</td>\n",
       "      <td>35.845687</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>36.869436</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>56.897712</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>18.796785</td>\n",
       "      <td>16.290425</td>\n",
       "      <td>11.126824</td>\n",
       "      <td>12.531665</td>\n",
       "      <td>9.970553</td>\n",
       "      <td>16.335278</td>\n",
       "      <td>20.695541</td>\n",
       "      <td>8.111251</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>19.657790</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>13.705605</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>12.674124</td>\n",
       "      <td>47.937468</td>\n",
       "      <td>49.248877</td>\n",
       "      <td>16.334928</td>\n",
       "      <td>14.995832</td>\n",
       "      <td>14.531358</td>\n",
       "      <td>14.476728</td>\n",
       "      <td>33.725042</td>\n",
       "      <td>9.415613</td>\n",
       "      <td>30.595866</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Tunisia</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>65.073717</td>\n",
       "      <td>10.987813</td>\n",
       "      <td>68.726140</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>83.771781</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>26.936851</td>\n",
       "      <td>26.232351</td>\n",
       "      <td>68.563177</td>\n",
       "      <td>96.244077</td>\n",
       "      <td>44.889674</td>\n",
       "      <td>4.058973</td>\n",
       "      <td>50.154000</td>\n",
       "      <td>79.528181</td>\n",
       "      <td>30.428573</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>85.256403</td>\n",
       "      <td>4.881068</td>\n",
       "      <td>77.526048</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>32.396517</td>\n",
       "      <td>...</td>\n",
       "      <td>15.823375</td>\n",
       "      <td>11.440848</td>\n",
       "      <td>15.780500</td>\n",
       "      <td>16.139289</td>\n",
       "      <td>11.855880</td>\n",
       "      <td>16.258650</td>\n",
       "      <td>12.109965</td>\n",
       "      <td>17.813247</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>43.826587</td>\n",
       "      <td>42.089392</td>\n",
       "      <td>22.052089</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>17.309332</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>19.684637</td>\n",
       "      <td>21.096688</td>\n",
       "      <td>19.864217</td>\n",
       "      <td>36.572152</td>\n",
       "      <td>27.370838</td>\n",
       "      <td>39.029300</td>\n",
       "      <td>17.489059</td>\n",
       "      <td>18.599703</td>\n",
       "      <td>16.173891</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Uganda</td>\n",
       "      <td>66.445066</td>\n",
       "      <td>39.557870</td>\n",
       "      <td>40.007771</td>\n",
       "      <td>59.659015</td>\n",
       "      <td>71.061064</td>\n",
       "      <td>27.115879</td>\n",
       "      <td>63.782654</td>\n",
       "      <td>19.752093</td>\n",
       "      <td>49.969562</td>\n",
       "      <td>35.350664</td>\n",
       "      <td>36.245156</td>\n",
       "      <td>34.266406</td>\n",
       "      <td>32.035863</td>\n",
       "      <td>89.549945</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>10.535036</td>\n",
       "      <td>23.519262</td>\n",
       "      <td>25.443067</td>\n",
       "      <td>32.744189</td>\n",
       "      <td>37.651787</td>\n",
       "      <td>36.168870</td>\n",
       "      <td>73.066705</td>\n",
       "      <td>51.748017</td>\n",
       "      <td>...</td>\n",
       "      <td>9.353790</td>\n",
       "      <td>17.869590</td>\n",
       "      <td>12.966406</td>\n",
       "      <td>21.556224</td>\n",
       "      <td>12.271019</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>10.757327</td>\n",
       "      <td>22.343457</td>\n",
       "      <td>15.393006</td>\n",
       "      <td>10.397634</td>\n",
       "      <td>20.314838</td>\n",
       "      <td>14.943059</td>\n",
       "      <td>34.695212</td>\n",
       "      <td>24.560116</td>\n",
       "      <td>24.741432</td>\n",
       "      <td>32.998629</td>\n",
       "      <td>28.761873</td>\n",
       "      <td>20.186546</td>\n",
       "      <td>25.371733</td>\n",
       "      <td>16.505745</td>\n",
       "      <td>1.955935</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>10.582751</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Zambia</td>\n",
       "      <td>39.058852</td>\n",
       "      <td>19.343329</td>\n",
       "      <td>69.911205</td>\n",
       "      <td>27.943915</td>\n",
       "      <td>73.699489</td>\n",
       "      <td>60.865824</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>40.821889</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>44.611555</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>42.061997</td>\n",
       "      <td>16.924386</td>\n",
       "      <td>23.098652</td>\n",
       "      <td>11.520808</td>\n",
       "      <td>29.762889</td>\n",
       "      <td>45.338479</td>\n",
       "      <td>5.595614</td>\n",
       "      <td>28.686468</td>\n",
       "      <td>2.259173</td>\n",
       "      <td>25.609107</td>\n",
       "      <td>48.803589</td>\n",
       "      <td>23.027473</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>19.127783</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>19.913722</td>\n",
       "      <td>15.819389</td>\n",
       "      <td>18.105429</td>\n",
       "      <td>5.020545</td>\n",
       "      <td>9.895585</td>\n",
       "      <td>8.764173</td>\n",
       "      <td>2.551066</td>\n",
       "      <td>17.709448</td>\n",
       "      <td>12.984582</td>\n",
       "      <td>12.715654</td>\n",
       "      <td>30.134256</td>\n",
       "      <td>32.561467</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>22.901857</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>20.742051</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>29.239778</td>\n",
       "      <td>33.104305</td>\n",
       "      <td>27.578445</td>\n",
       "      <td>33.024498</td>\n",
       "      <td>31.872643</td>\n",
       "      <td>41.700604</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>84.637621</td>\n",
       "      <td>82.935361</td>\n",
       "      <td>65.267397</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>53.006882</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>62.788038</td>\n",
       "      <td>53.008820</td>\n",
       "      <td>66.185496</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>82.059757</td>\n",
       "      <td>67.200243</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>46.634126</td>\n",
       "      <td>80.140177</td>\n",
       "      <td>43.180898</td>\n",
       "      <td>25.109887</td>\n",
       "      <td>49.161725</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>74.418893</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>12.108643</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>11.331474</td>\n",
       "      <td>13.514309</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>17.690752</td>\n",
       "      <td>16.638985</td>\n",
       "      <td>21.931433</td>\n",
       "      <td>42.483612</td>\n",
       "      <td>29.371254</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>34.040420</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>20.208926</td>\n",
       "      <td>26.884074</td>\n",
       "      <td>20.430332</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>24.699471</td>\n",
       "      <td>32.318263</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>30.698054</td>\n",
       "      <td>14.681265</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 69 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Country   Humidity                                              \\\n",
       "Year                 2005       2006       2007       2008       2009   \n",
       "41        Togo   0.000000  73.181082   0.000000  37.720680   0.000000   \n",
       "42     Tunisia   0.000000  65.073717  10.987813  68.726140   0.000000   \n",
       "43      Uganda  66.445066  39.557870  40.007771  59.659015  71.061064   \n",
       "44      Zambia  39.058852  19.343329  69.911205  27.943915  73.699489   \n",
       "45    Zimbabwe  84.637621  82.935361  65.267397   0.000000  53.006882   \n",
       "\n",
       "                                                                        \\\n",
       "Year       2010       2011       2012       2013       2014       2015   \n",
       "41     0.000000   0.000000  61.730457  78.234777  11.049721  95.991481   \n",
       "42     0.000000  83.771781   0.000000  26.936851  26.232351  68.563177   \n",
       "43    27.115879  63.782654  19.752093  49.969562  35.350664  36.245156   \n",
       "44    60.865824   0.000000  40.821889   0.000000  44.611555   0.000000   \n",
       "45     0.000000   0.000000  62.788038  53.008820  66.185496   0.000000   \n",
       "\n",
       "                                                                        \\\n",
       "Year       2016       2017       2018       2019       2020       2021   \n",
       "41    63.889302  42.312771  29.037184  85.699043  60.615155  35.845687   \n",
       "42    96.244077  44.889674   4.058973  50.154000  79.528181  30.428573   \n",
       "43    34.266406  32.035863  89.549945   0.000000   0.000000  10.535036   \n",
       "44    42.061997  16.924386  23.098652  11.520808  29.762889  45.338479   \n",
       "45     0.000000  82.059757  67.200243   0.000000  46.634126  80.140177   \n",
       "\n",
       "     Precipitation                                                         \\\n",
       "Year          2005       2006       2007       2008       2009       2010   \n",
       "41        0.000000  36.869436   0.000000  56.897712   0.000000   0.000000   \n",
       "42        0.000000  85.256403   4.881068  77.526048   0.000000   0.000000   \n",
       "43       23.519262  25.443067  32.744189  37.651787  36.168870  73.066705   \n",
       "44        5.595614  28.686468   2.259173  25.609107  48.803589  23.027473   \n",
       "45       43.180898  25.109887  49.161725   0.000000  74.418893   0.000000   \n",
       "\n",
       "                 ... Temperature                                              \\\n",
       "Year       2011  ...        2014       2015       2016       2017       2018   \n",
       "41     0.000000  ...   18.796785  16.290425  11.126824  12.531665   9.970553   \n",
       "42    32.396517  ...   15.823375  11.440848  15.780500  16.139289  11.855880   \n",
       "43    51.748017  ...    9.353790  17.869590  12.966406  21.556224  12.271019   \n",
       "44     0.000000  ...   19.127783   0.000000  19.913722  15.819389  18.105429   \n",
       "45     0.000000  ...   12.108643   0.000000   0.000000  11.331474  13.514309   \n",
       "\n",
       "                                      Wind Speed                        \\\n",
       "Year       2019       2020       2021       2005       2006       2007   \n",
       "41    16.335278  20.695541   8.111251   0.000000  19.657790   0.000000   \n",
       "42    16.258650  12.109965  17.813247   0.000000  43.826587  42.089392   \n",
       "43     0.000000   0.000000  10.757327  22.343457  15.393006  10.397634   \n",
       "44     5.020545   9.895585   8.764173   2.551066  17.709448  12.984582   \n",
       "45     0.000000  17.690752  16.638985  21.931433  42.483612  29.371254   \n",
       "\n",
       "                                                                        \\\n",
       "Year       2008       2009       2010       2011       2012       2013   \n",
       "41    13.705605   0.000000   0.000000   0.000000  12.674124  47.937468   \n",
       "42    22.052089   0.000000   0.000000  17.309332   0.000000  19.684637   \n",
       "43    20.314838  14.943059  34.695212  24.560116  24.741432  32.998629   \n",
       "44    12.715654  30.134256  32.561467   0.000000  22.901857   0.000000   \n",
       "45     0.000000  34.040420   0.000000   0.000000  20.208926  26.884074   \n",
       "\n",
       "                                                                        \\\n",
       "Year       2014       2015       2016       2017       2018       2019   \n",
       "41    49.248877  16.334928  14.995832  14.531358  14.476728  33.725042   \n",
       "42    21.096688  19.864217  36.572152  27.370838  39.029300  17.489059   \n",
       "43    28.761873  20.186546  25.371733  16.505745   1.955935   0.000000   \n",
       "44    20.742051   0.000000  29.239778  33.104305  27.578445  33.024498   \n",
       "45    20.430332   0.000000   0.000000  24.699471  32.318263   0.000000   \n",
       "\n",
       "                            \n",
       "Year       2020       2021  \n",
       "41     9.415613  30.595866  \n",
       "42    18.599703  16.173891  \n",
       "43     0.000000  10.582751  \n",
       "44    31.872643  41.700604  \n",
       "45    30.698054  14.681265  \n",
       "\n",
       "[5 rows x 69 columns]"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Create a pivot table with sum as the aggregation function\n",
    "pivot_table = pd.pivot_table(africa_climate_new, values=['Temperature', 'Precipitation', 'Humidity', 'Wind Speed'], index='Country', columns='Year', aggfunc='mean', fill_value=0)\n",
    "\n",
    "normal_df = pivot_table.reset_index()\n",
    "normal_df.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "86d9a5e3-3e02-4714-99b6-f4cd3ecc4dc9",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Country</th>\n",
       "      <th>Variable</th>\n",
       "      <th>Year</th>\n",
       "      <th>Value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Algeria</td>\n",
       "      <td>Humidity</td>\n",
       "      <td>2005</td>\n",
       "      <td>31.734205</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Angola</td>\n",
       "      <td>Humidity</td>\n",
       "      <td>2005</td>\n",
       "      <td>61.583924</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Benin</td>\n",
       "      <td>Humidity</td>\n",
       "      <td>2005</td>\n",
       "      <td>59.062993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Botswana</td>\n",
       "      <td>Humidity</td>\n",
       "      <td>2005</td>\n",
       "      <td>77.038247</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Burkina Faso</td>\n",
       "      <td>Humidity</td>\n",
       "      <td>2005</td>\n",
       "      <td>25.270016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3123</th>\n",
       "      <td>Togo</td>\n",
       "      <td>Wind Speed</td>\n",
       "      <td>2021</td>\n",
       "      <td>30.595866</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3124</th>\n",
       "      <td>Tunisia</td>\n",
       "      <td>Wind Speed</td>\n",
       "      <td>2021</td>\n",
       "      <td>16.173891</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3125</th>\n",
       "      <td>Uganda</td>\n",
       "      <td>Wind Speed</td>\n",
       "      <td>2021</td>\n",
       "      <td>10.582751</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3126</th>\n",
       "      <td>Zambia</td>\n",
       "      <td>Wind Speed</td>\n",
       "      <td>2021</td>\n",
       "      <td>41.700604</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3127</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>Wind Speed</td>\n",
       "      <td>2021</td>\n",
       "      <td>14.681265</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3128 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           Country    Variable  Year      Value\n",
       "0          Algeria    Humidity  2005  31.734205\n",
       "1           Angola    Humidity  2005  61.583924\n",
       "2            Benin    Humidity  2005  59.062993\n",
       "3         Botswana    Humidity  2005  77.038247\n",
       "4     Burkina Faso    Humidity  2005  25.270016\n",
       "...            ...         ...   ...        ...\n",
       "3123          Togo  Wind Speed  2021  30.595866\n",
       "3124       Tunisia  Wind Speed  2021  16.173891\n",
       "3125        Uganda  Wind Speed  2021  10.582751\n",
       "3126        Zambia  Wind Speed  2021  41.700604\n",
       "3127      Zimbabwe  Wind Speed  2021  14.681265\n",
       "\n",
       "[3128 rows x 4 columns]"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Unpivot the DataFrame\n",
    "unpivoted_df = pd.melt(normal_df, id_vars='Country', var_name=['Variable', 'Year'], value_name='Value')\n",
    "\n",
    "# Display the unpivoted DataFrame\n",
    "unpivoted_df\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "7313e463-280f-4f92-a376-caaa5ede39e2",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th>Variable</th>\n",
       "      <th>Country</th>\n",
       "      <th>Year</th>\n",
       "      <th>Humidity</th>\n",
       "      <th>Precipitation</th>\n",
       "      <th>Temperature</th>\n",
       "      <th>Wind Speed</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Algeria</td>\n",
       "      <td>2005</td>\n",
       "      <td>31.734205</td>\n",
       "      <td>10.968121</td>\n",
       "      <td>13.504072</td>\n",
       "      <td>8.769347</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Algeria</td>\n",
       "      <td>2006</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Algeria</td>\n",
       "      <td>2007</td>\n",
       "      <td>69.520863</td>\n",
       "      <td>74.638687</td>\n",
       "      <td>5.783653</td>\n",
       "      <td>25.478604</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Algeria</td>\n",
       "      <td>2008</td>\n",
       "      <td>52.958708</td>\n",
       "      <td>86.310334</td>\n",
       "      <td>7.554852</td>\n",
       "      <td>8.661352</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Algeria</td>\n",
       "      <td>2009</td>\n",
       "      <td>88.990603</td>\n",
       "      <td>44.402714</td>\n",
       "      <td>17.102406</td>\n",
       "      <td>26.639289</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>777</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>2017</td>\n",
       "      <td>82.059757</td>\n",
       "      <td>77.844800</td>\n",
       "      <td>11.331474</td>\n",
       "      <td>24.699471</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>778</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>2018</td>\n",
       "      <td>67.200243</td>\n",
       "      <td>64.274397</td>\n",
       "      <td>13.514309</td>\n",
       "      <td>32.318263</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>2019</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>780</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>2020</td>\n",
       "      <td>46.634126</td>\n",
       "      <td>7.302774</td>\n",
       "      <td>17.690752</td>\n",
       "      <td>30.698054</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>781</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>2021</td>\n",
       "      <td>80.140177</td>\n",
       "      <td>88.509625</td>\n",
       "      <td>16.638985</td>\n",
       "      <td>14.681265</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>782 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "Variable   Country  Year   Humidity  Precipitation  Temperature  Wind Speed\n",
       "0          Algeria  2005  31.734205      10.968121    13.504072    8.769347\n",
       "1          Algeria  2006   0.000000       0.000000     0.000000    0.000000\n",
       "2          Algeria  2007  69.520863      74.638687     5.783653   25.478604\n",
       "3          Algeria  2008  52.958708      86.310334     7.554852    8.661352\n",
       "4          Algeria  2009  88.990603      44.402714    17.102406   26.639289\n",
       "..             ...   ...        ...            ...          ...         ...\n",
       "777       Zimbabwe  2017  82.059757      77.844800    11.331474   24.699471\n",
       "778       Zimbabwe  2018  67.200243      64.274397    13.514309   32.318263\n",
       "779       Zimbabwe  2019   0.000000       0.000000     0.000000    0.000000\n",
       "780       Zimbabwe  2020  46.634126       7.302774    17.690752   30.698054\n",
       "781       Zimbabwe  2021  80.140177      88.509625    16.638985   14.681265\n",
       "\n",
       "[782 rows x 6 columns]"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pivot_table_new = pd.pivot_table(unpivoted_df, values='Value', index=['Country', 'Year'], columns='Variable', aggfunc='sum')\n",
    "africa_climate_new = pivot_table_new.reset_index()\n",
    "africa_climate_new"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "05c94170-3367-48ca-8785-f3fbd9a8d645",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Country Code</th>\n",
       "      <th>Country</th>\n",
       "      <th>Income Group</th>\n",
       "      <th>Year</th>\n",
       "      <th>incidence_rate</th>\n",
       "      <th>% basic_DW_all</th>\n",
       "      <th>% basic_DW_rural</th>\n",
       "      <th>% basic_DW_urban</th>\n",
       "      <th>% basic_sanitation_all</th>\n",
       "      <th>% basic_sanitation_rural</th>\n",
       "      <th>% basic_sanitation_urban</th>\n",
       "      <th>% death_rate</th>\n",
       "      <th>% children_with_fever</th>\n",
       "      <th>% literacy_rate</th>\n",
       "      <th>% rural_pop</th>\n",
       "      <th>% safe_DW_all</th>\n",
       "      <th>% safe_DW_rural</th>\n",
       "      <th>% safe_DW_urban</th>\n",
       "      <th>% safe_sanitation_all</th>\n",
       "      <th>% safe_sanitation_rural</th>\n",
       "      <th>% safe_sanitation_urban</th>\n",
       "      <th>% urban_pop</th>\n",
       "      <th>% insecticide</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>DZA</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>Lower middle income</td>\n",
       "      <td>2005</td>\n",
       "      <td>0.0</td>\n",
       "      <td>91.1</td>\n",
       "      <td>85.0</td>\n",
       "      <td>94.6</td>\n",
       "      <td>85.8</td>\n",
       "      <td>75.4</td>\n",
       "      <td>91.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.9</td>\n",
       "      <td>0.0</td>\n",
       "      <td>36.2</td>\n",
       "      <td>72.8</td>\n",
       "      <td>56.5</td>\n",
       "      <td>82.0</td>\n",
       "      <td>60.5</td>\n",
       "      <td>50.4</td>\n",
       "      <td>66.2</td>\n",
       "      <td>63.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>28.033886</td>\n",
       "      <td>1.659626</td>\n",
       "      <td>POINT (28.033886 1.659626)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>DZA</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>Lower middle income</td>\n",
       "      <td>2006</td>\n",
       "      <td>0.0</td>\n",
       "      <td>91.4</td>\n",
       "      <td>85.4</td>\n",
       "      <td>94.7</td>\n",
       "      <td>86.1</td>\n",
       "      <td>75.7</td>\n",
       "      <td>91.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.9</td>\n",
       "      <td>72.6</td>\n",
       "      <td>35.4</td>\n",
       "      <td>73.2</td>\n",
       "      <td>57.4</td>\n",
       "      <td>81.9</td>\n",
       "      <td>60.8</td>\n",
       "      <td>50.8</td>\n",
       "      <td>66.3</td>\n",
       "      <td>64.6</td>\n",
       "      <td>0.0</td>\n",
       "      <td>28.033886</td>\n",
       "      <td>1.659626</td>\n",
       "      <td>POINT (28.033886 1.659626)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>DZA</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>Lower middle income</td>\n",
       "      <td>2007</td>\n",
       "      <td>0.0</td>\n",
       "      <td>91.6</td>\n",
       "      <td>85.7</td>\n",
       "      <td>94.7</td>\n",
       "      <td>86.3</td>\n",
       "      <td>76.1</td>\n",
       "      <td>91.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.9</td>\n",
       "      <td>0.0</td>\n",
       "      <td>34.7</td>\n",
       "      <td>73.7</td>\n",
       "      <td>58.3</td>\n",
       "      <td>81.9</td>\n",
       "      <td>61.1</td>\n",
       "      <td>51.2</td>\n",
       "      <td>66.4</td>\n",
       "      <td>65.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>28.033886</td>\n",
       "      <td>1.659626</td>\n",
       "      <td>POINT (28.033886 1.659626)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>DZA</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>Lower middle income</td>\n",
       "      <td>2008</td>\n",
       "      <td>0.0</td>\n",
       "      <td>91.8</td>\n",
       "      <td>86.0</td>\n",
       "      <td>94.8</td>\n",
       "      <td>86.5</td>\n",
       "      <td>76.4</td>\n",
       "      <td>91.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.9</td>\n",
       "      <td>75.1</td>\n",
       "      <td>33.9</td>\n",
       "      <td>74.2</td>\n",
       "      <td>59.3</td>\n",
       "      <td>81.8</td>\n",
       "      <td>61.4</td>\n",
       "      <td>51.6</td>\n",
       "      <td>66.4</td>\n",
       "      <td>66.1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>28.033886</td>\n",
       "      <td>1.659626</td>\n",
       "      <td>POINT (28.033886 1.659626)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>DZA</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>Lower middle income</td>\n",
       "      <td>2009</td>\n",
       "      <td>0.0</td>\n",
       "      <td>92.1</td>\n",
       "      <td>86.4</td>\n",
       "      <td>94.9</td>\n",
       "      <td>86.8</td>\n",
       "      <td>76.7</td>\n",
       "      <td>91.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>33.2</td>\n",
       "      <td>74.6</td>\n",
       "      <td>60.2</td>\n",
       "      <td>81.8</td>\n",
       "      <td>61.7</td>\n",
       "      <td>52.0</td>\n",
       "      <td>66.5</td>\n",
       "      <td>66.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>28.033886</td>\n",
       "      <td>1.659626</td>\n",
       "      <td>POINT (28.033886 1.659626)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>913</th>\n",
       "      <td>ZWE</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>Lower middle income</td>\n",
       "      <td>2017</td>\n",
       "      <td>115.2</td>\n",
       "      <td>64.0</td>\n",
       "      <td>50.1</td>\n",
       "      <td>93.3</td>\n",
       "      <td>36.9</td>\n",
       "      <td>32.6</td>\n",
       "      <td>46.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>67.8</td>\n",
       "      <td>26.9</td>\n",
       "      <td>13.6</td>\n",
       "      <td>55.1</td>\n",
       "      <td>33.6</td>\n",
       "      <td>31.3</td>\n",
       "      <td>38.4</td>\n",
       "      <td>32.2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-19.015438</td>\n",
       "      <td>29.154857</td>\n",
       "      <td>POINT (-19.015438 29.154857)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>914</th>\n",
       "      <td>ZWE</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>Lower middle income</td>\n",
       "      <td>2018</td>\n",
       "      <td>53.6</td>\n",
       "      <td>63.5</td>\n",
       "      <td>49.5</td>\n",
       "      <td>93.2</td>\n",
       "      <td>36.4</td>\n",
       "      <td>32.4</td>\n",
       "      <td>44.6</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>67.8</td>\n",
       "      <td>26.8</td>\n",
       "      <td>13.3</td>\n",
       "      <td>55.2</td>\n",
       "      <td>33.5</td>\n",
       "      <td>31.1</td>\n",
       "      <td>38.7</td>\n",
       "      <td>32.2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-19.015438</td>\n",
       "      <td>29.154857</td>\n",
       "      <td>POINT (-19.015438 29.154857)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>915</th>\n",
       "      <td>ZWE</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>Lower middle income</td>\n",
       "      <td>2019</td>\n",
       "      <td>64.7</td>\n",
       "      <td>63.1</td>\n",
       "      <td>48.9</td>\n",
       "      <td>93.0</td>\n",
       "      <td>35.8</td>\n",
       "      <td>32.2</td>\n",
       "      <td>43.2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>67.8</td>\n",
       "      <td>26.7</td>\n",
       "      <td>13.1</td>\n",
       "      <td>55.3</td>\n",
       "      <td>33.0</td>\n",
       "      <td>30.9</td>\n",
       "      <td>37.4</td>\n",
       "      <td>32.2</td>\n",
       "      <td>14.9</td>\n",
       "      <td>-19.015438</td>\n",
       "      <td>29.154857</td>\n",
       "      <td>POINT (-19.015438 29.154857)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>916</th>\n",
       "      <td>ZWE</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>Lower middle income</td>\n",
       "      <td>2020</td>\n",
       "      <td>93.4</td>\n",
       "      <td>62.7</td>\n",
       "      <td>48.3</td>\n",
       "      <td>92.9</td>\n",
       "      <td>35.2</td>\n",
       "      <td>32.0</td>\n",
       "      <td>41.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>67.8</td>\n",
       "      <td>26.6</td>\n",
       "      <td>12.9</td>\n",
       "      <td>55.4</td>\n",
       "      <td>32.4</td>\n",
       "      <td>30.6</td>\n",
       "      <td>36.0</td>\n",
       "      <td>32.2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-19.015438</td>\n",
       "      <td>29.154857</td>\n",
       "      <td>POINT (-19.015438 29.154857)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>917</th>\n",
       "      <td>ZWE</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>Lower middle income</td>\n",
       "      <td>2021</td>\n",
       "      <td>27.2</td>\n",
       "      <td>62.3</td>\n",
       "      <td>47.7</td>\n",
       "      <td>92.8</td>\n",
       "      <td>34.6</td>\n",
       "      <td>31.8</td>\n",
       "      <td>40.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>67.7</td>\n",
       "      <td>26.5</td>\n",
       "      <td>12.6</td>\n",
       "      <td>55.5</td>\n",
       "      <td>31.8</td>\n",
       "      <td>30.4</td>\n",
       "      <td>34.7</td>\n",
       "      <td>32.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-19.015438</td>\n",
       "      <td>29.154857</td>\n",
       "      <td>POINT (-19.015438 29.154857)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>918 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Country Code   Country         Income Group  Year  incidence_rate  \\\n",
       "0            DZA   Algeria  Lower middle income  2005             0.0   \n",
       "1            DZA   Algeria  Lower middle income  2006             0.0   \n",
       "2            DZA   Algeria  Lower middle income  2007             0.0   \n",
       "3            DZA   Algeria  Lower middle income  2008             0.0   \n",
       "4            DZA   Algeria  Lower middle income  2009             0.0   \n",
       "..           ...       ...                  ...   ...             ...   \n",
       "913          ZWE  Zimbabwe  Lower middle income  2017           115.2   \n",
       "914          ZWE  Zimbabwe  Lower middle income  2018            53.6   \n",
       "915          ZWE  Zimbabwe  Lower middle income  2019            64.7   \n",
       "916          ZWE  Zimbabwe  Lower middle income  2020            93.4   \n",
       "917          ZWE  Zimbabwe  Lower middle income  2021            27.2   \n",
       "\n",
       "     % basic_DW_all  % basic_DW_rural  % basic_DW_urban  \\\n",
       "0              91.1              85.0              94.6   \n",
       "1              91.4              85.4              94.7   \n",
       "2              91.6              85.7              94.7   \n",
       "3              91.8              86.0              94.8   \n",
       "4              92.1              86.4              94.9   \n",
       "..              ...               ...               ...   \n",
       "913            64.0              50.1              93.3   \n",
       "914            63.5              49.5              93.2   \n",
       "915            63.1              48.9              93.0   \n",
       "916            62.7              48.3              92.9   \n",
       "917            62.3              47.7              92.8   \n",
       "\n",
       "     % basic_sanitation_all  % basic_sanitation_rural  \\\n",
       "0                      85.8                      75.4   \n",
       "1                      86.1                      75.7   \n",
       "2                      86.3                      76.1   \n",
       "3                      86.5                      76.4   \n",
       "4                      86.8                      76.7   \n",
       "..                      ...                       ...   \n",
       "913                    36.9                      32.6   \n",
       "914                    36.4                      32.4   \n",
       "915                    35.8                      32.2   \n",
       "916                    35.2                      32.0   \n",
       "917                    34.6                      31.8   \n",
       "\n",
       "     % basic_sanitation_urban  % death_rate  % children_with_fever  \\\n",
       "0                        91.7           0.0                    4.9   \n",
       "1                        91.7           0.0                    4.9   \n",
       "2                        91.7           0.0                    4.9   \n",
       "3                        91.7           0.0                    4.9   \n",
       "4                        91.7           0.0                    4.7   \n",
       "..                        ...           ...                    ...   \n",
       "913                      46.0           0.0                    8.3   \n",
       "914                      44.6           0.0                    8.0   \n",
       "915                      43.2           0.0                    8.0   \n",
       "916                      41.8           0.0                    8.1   \n",
       "917                      40.4           0.0                    9.1   \n",
       "\n",
       "     % literacy_rate  % rural_pop  % safe_DW_all  % safe_DW_rural  \\\n",
       "0                0.0         36.2           72.8             56.5   \n",
       "1               72.6         35.4           73.2             57.4   \n",
       "2                0.0         34.7           73.7             58.3   \n",
       "3               75.1         33.9           74.2             59.3   \n",
       "4                0.0         33.2           74.6             60.2   \n",
       "..               ...          ...            ...              ...   \n",
       "913              0.0         67.8           26.9             13.6   \n",
       "914              0.0         67.8           26.8             13.3   \n",
       "915              0.0         67.8           26.7             13.1   \n",
       "916              0.0         67.8           26.6             12.9   \n",
       "917              0.0         67.7           26.5             12.6   \n",
       "\n",
       "     % safe_DW_urban  % safe_sanitation_all  % safe_sanitation_rural  \\\n",
       "0               82.0                   60.5                     50.4   \n",
       "1               81.9                   60.8                     50.8   \n",
       "2               81.9                   61.1                     51.2   \n",
       "3               81.8                   61.4                     51.6   \n",
       "4               81.8                   61.7                     52.0   \n",
       "..               ...                    ...                      ...   \n",
       "913             55.1                   33.6                     31.3   \n",
       "914             55.2                   33.5                     31.1   \n",
       "915             55.3                   33.0                     30.9   \n",
       "916             55.4                   32.4                     30.6   \n",
       "917             55.5                   31.8                     30.4   \n",
       "\n",
       "     % safe_sanitation_urban  % urban_pop  % insecticide   Latitude  \\\n",
       "0                       66.2         63.8            0.0  28.033886   \n",
       "1                       66.3         64.6            0.0  28.033886   \n",
       "2                       66.4         65.3            0.0  28.033886   \n",
       "3                       66.4         66.1            0.0  28.033886   \n",
       "4                       66.5         66.8            0.0  28.033886   \n",
       "..                       ...          ...            ...        ...   \n",
       "913                     38.4         32.2            0.0 -19.015438   \n",
       "914                     38.7         32.2            0.0 -19.015438   \n",
       "915                     37.4         32.2           14.9 -19.015438   \n",
       "916                     36.0         32.2            0.0 -19.015438   \n",
       "917                     34.7         32.3            0.0 -19.015438   \n",
       "\n",
       "     Longitude                       Geometry  \n",
       "0      1.659626    POINT (28.033886 1.659626)  \n",
       "1      1.659626    POINT (28.033886 1.659626)  \n",
       "2      1.659626    POINT (28.033886 1.659626)  \n",
       "3      1.659626    POINT (28.033886 1.659626)  \n",
       "4      1.659626    POINT (28.033886 1.659626)  \n",
       "..          ...                           ...  \n",
       "913   29.154857  POINT (-19.015438 29.154857)  \n",
       "914   29.154857  POINT (-19.015438 29.154857)  \n",
       "915   29.154857  POINT (-19.015438 29.154857)  \n",
       "916   29.154857  POINT (-19.015438 29.154857)  \n",
       "917   29.154857  POINT (-19.015438 29.154857)  \n",
       "\n",
       "[918 rows x 26 columns]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "malaria"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "69257b2e-1d6a-4517-a0b0-91bca5912fea",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "malaria_combine = pd.merge(malaria, africa_climate_new, on=['Country', 'Year'], how='inner')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "bb62ffb0-dc06-4691-86a8-74bba49345ca",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Country Code</th>\n",
       "      <th>Country</th>\n",
       "      <th>Income Group</th>\n",
       "      <th>Year</th>\n",
       "      <th>incidence_rate</th>\n",
       "      <th>% basic_DW_all</th>\n",
       "      <th>% basic_DW_rural</th>\n",
       "      <th>% basic_DW_urban</th>\n",
       "      <th>% basic_sanitation_all</th>\n",
       "      <th>% basic_sanitation_rural</th>\n",
       "      <th>% basic_sanitation_urban</th>\n",
       "      <th>% death_rate</th>\n",
       "      <th>% children_with_fever</th>\n",
       "      <th>% literacy_rate</th>\n",
       "      <th>% rural_pop</th>\n",
       "      <th>% safe_DW_all</th>\n",
       "      <th>% safe_DW_rural</th>\n",
       "      <th>% safe_DW_urban</th>\n",
       "      <th>% safe_sanitation_all</th>\n",
       "      <th>% safe_sanitation_rural</th>\n",
       "      <th>% safe_sanitation_urban</th>\n",
       "      <th>% urban_pop</th>\n",
       "      <th>% insecticide</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Geometry</th>\n",
       "      <th>Humidity</th>\n",
       "      <th>Precipitation</th>\n",
       "      <th>Temperature</th>\n",
       "      <th>Wind Speed</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>DZA</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>Lower middle income</td>\n",
       "      <td>2005</td>\n",
       "      <td>0.0</td>\n",
       "      <td>91.1</td>\n",
       "      <td>85.0</td>\n",
       "      <td>94.6</td>\n",
       "      <td>85.8</td>\n",
       "      <td>75.4</td>\n",
       "      <td>91.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.9</td>\n",
       "      <td>0.0</td>\n",
       "      <td>36.2</td>\n",
       "      <td>72.8</td>\n",
       "      <td>56.5</td>\n",
       "      <td>82.0</td>\n",
       "      <td>60.5</td>\n",
       "      <td>50.4</td>\n",
       "      <td>66.2</td>\n",
       "      <td>63.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>28.033886</td>\n",
       "      <td>1.659626</td>\n",
       "      <td>POINT (28.033886 1.659626)</td>\n",
       "      <td>31.734205</td>\n",
       "      <td>10.968121</td>\n",
       "      <td>13.504072</td>\n",
       "      <td>8.769347</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>DZA</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>Lower middle income</td>\n",
       "      <td>2006</td>\n",
       "      <td>0.0</td>\n",
       "      <td>91.4</td>\n",
       "      <td>85.4</td>\n",
       "      <td>94.7</td>\n",
       "      <td>86.1</td>\n",
       "      <td>75.7</td>\n",
       "      <td>91.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.9</td>\n",
       "      <td>72.6</td>\n",
       "      <td>35.4</td>\n",
       "      <td>73.2</td>\n",
       "      <td>57.4</td>\n",
       "      <td>81.9</td>\n",
       "      <td>60.8</td>\n",
       "      <td>50.8</td>\n",
       "      <td>66.3</td>\n",
       "      <td>64.6</td>\n",
       "      <td>0.0</td>\n",
       "      <td>28.033886</td>\n",
       "      <td>1.659626</td>\n",
       "      <td>POINT (28.033886 1.659626)</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>DZA</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>Lower middle income</td>\n",
       "      <td>2007</td>\n",
       "      <td>0.0</td>\n",
       "      <td>91.6</td>\n",
       "      <td>85.7</td>\n",
       "      <td>94.7</td>\n",
       "      <td>86.3</td>\n",
       "      <td>76.1</td>\n",
       "      <td>91.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.9</td>\n",
       "      <td>0.0</td>\n",
       "      <td>34.7</td>\n",
       "      <td>73.7</td>\n",
       "      <td>58.3</td>\n",
       "      <td>81.9</td>\n",
       "      <td>61.1</td>\n",
       "      <td>51.2</td>\n",
       "      <td>66.4</td>\n",
       "      <td>65.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>28.033886</td>\n",
       "      <td>1.659626</td>\n",
       "      <td>POINT (28.033886 1.659626)</td>\n",
       "      <td>69.520863</td>\n",
       "      <td>74.638687</td>\n",
       "      <td>5.783653</td>\n",
       "      <td>25.478604</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>DZA</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>Lower middle income</td>\n",
       "      <td>2008</td>\n",
       "      <td>0.0</td>\n",
       "      <td>91.8</td>\n",
       "      <td>86.0</td>\n",
       "      <td>94.8</td>\n",
       "      <td>86.5</td>\n",
       "      <td>76.4</td>\n",
       "      <td>91.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.9</td>\n",
       "      <td>75.1</td>\n",
       "      <td>33.9</td>\n",
       "      <td>74.2</td>\n",
       "      <td>59.3</td>\n",
       "      <td>81.8</td>\n",
       "      <td>61.4</td>\n",
       "      <td>51.6</td>\n",
       "      <td>66.4</td>\n",
       "      <td>66.1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>28.033886</td>\n",
       "      <td>1.659626</td>\n",
       "      <td>POINT (28.033886 1.659626)</td>\n",
       "      <td>52.958708</td>\n",
       "      <td>86.310334</td>\n",
       "      <td>7.554852</td>\n",
       "      <td>8.661352</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>DZA</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>Lower middle income</td>\n",
       "      <td>2009</td>\n",
       "      <td>0.0</td>\n",
       "      <td>92.1</td>\n",
       "      <td>86.4</td>\n",
       "      <td>94.9</td>\n",
       "      <td>86.8</td>\n",
       "      <td>76.7</td>\n",
       "      <td>91.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>33.2</td>\n",
       "      <td>74.6</td>\n",
       "      <td>60.2</td>\n",
       "      <td>81.8</td>\n",
       "      <td>61.7</td>\n",
       "      <td>52.0</td>\n",
       "      <td>66.5</td>\n",
       "      <td>66.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>28.033886</td>\n",
       "      <td>1.659626</td>\n",
       "      <td>POINT (28.033886 1.659626)</td>\n",
       "      <td>88.990603</td>\n",
       "      <td>44.402714</td>\n",
       "      <td>17.102406</td>\n",
       "      <td>26.639289</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>777</th>\n",
       "      <td>ZWE</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>Lower middle income</td>\n",
       "      <td>2017</td>\n",
       "      <td>115.2</td>\n",
       "      <td>64.0</td>\n",
       "      <td>50.1</td>\n",
       "      <td>93.3</td>\n",
       "      <td>36.9</td>\n",
       "      <td>32.6</td>\n",
       "      <td>46.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>67.8</td>\n",
       "      <td>26.9</td>\n",
       "      <td>13.6</td>\n",
       "      <td>55.1</td>\n",
       "      <td>33.6</td>\n",
       "      <td>31.3</td>\n",
       "      <td>38.4</td>\n",
       "      <td>32.2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-19.015438</td>\n",
       "      <td>29.154857</td>\n",
       "      <td>POINT (-19.015438 29.154857)</td>\n",
       "      <td>82.059757</td>\n",
       "      <td>77.844800</td>\n",
       "      <td>11.331474</td>\n",
       "      <td>24.699471</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>778</th>\n",
       "      <td>ZWE</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>Lower middle income</td>\n",
       "      <td>2018</td>\n",
       "      <td>53.6</td>\n",
       "      <td>63.5</td>\n",
       "      <td>49.5</td>\n",
       "      <td>93.2</td>\n",
       "      <td>36.4</td>\n",
       "      <td>32.4</td>\n",
       "      <td>44.6</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>67.8</td>\n",
       "      <td>26.8</td>\n",
       "      <td>13.3</td>\n",
       "      <td>55.2</td>\n",
       "      <td>33.5</td>\n",
       "      <td>31.1</td>\n",
       "      <td>38.7</td>\n",
       "      <td>32.2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-19.015438</td>\n",
       "      <td>29.154857</td>\n",
       "      <td>POINT (-19.015438 29.154857)</td>\n",
       "      <td>67.200243</td>\n",
       "      <td>64.274397</td>\n",
       "      <td>13.514309</td>\n",
       "      <td>32.318263</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779</th>\n",
       "      <td>ZWE</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>Lower middle income</td>\n",
       "      <td>2019</td>\n",
       "      <td>64.7</td>\n",
       "      <td>63.1</td>\n",
       "      <td>48.9</td>\n",
       "      <td>93.0</td>\n",
       "      <td>35.8</td>\n",
       "      <td>32.2</td>\n",
       "      <td>43.2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>67.8</td>\n",
       "      <td>26.7</td>\n",
       "      <td>13.1</td>\n",
       "      <td>55.3</td>\n",
       "      <td>33.0</td>\n",
       "      <td>30.9</td>\n",
       "      <td>37.4</td>\n",
       "      <td>32.2</td>\n",
       "      <td>14.9</td>\n",
       "      <td>-19.015438</td>\n",
       "      <td>29.154857</td>\n",
       "      <td>POINT (-19.015438 29.154857)</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>780</th>\n",
       "      <td>ZWE</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>Lower middle income</td>\n",
       "      <td>2020</td>\n",
       "      <td>93.4</td>\n",
       "      <td>62.7</td>\n",
       "      <td>48.3</td>\n",
       "      <td>92.9</td>\n",
       "      <td>35.2</td>\n",
       "      <td>32.0</td>\n",
       "      <td>41.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>67.8</td>\n",
       "      <td>26.6</td>\n",
       "      <td>12.9</td>\n",
       "      <td>55.4</td>\n",
       "      <td>32.4</td>\n",
       "      <td>30.6</td>\n",
       "      <td>36.0</td>\n",
       "      <td>32.2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-19.015438</td>\n",
       "      <td>29.154857</td>\n",
       "      <td>POINT (-19.015438 29.154857)</td>\n",
       "      <td>46.634126</td>\n",
       "      <td>7.302774</td>\n",
       "      <td>17.690752</td>\n",
       "      <td>30.698054</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>781</th>\n",
       "      <td>ZWE</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>Lower middle income</td>\n",
       "      <td>2021</td>\n",
       "      <td>27.2</td>\n",
       "      <td>62.3</td>\n",
       "      <td>47.7</td>\n",
       "      <td>92.8</td>\n",
       "      <td>34.6</td>\n",
       "      <td>31.8</td>\n",
       "      <td>40.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>67.7</td>\n",
       "      <td>26.5</td>\n",
       "      <td>12.6</td>\n",
       "      <td>55.5</td>\n",
       "      <td>31.8</td>\n",
       "      <td>30.4</td>\n",
       "      <td>34.7</td>\n",
       "      <td>32.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-19.015438</td>\n",
       "      <td>29.154857</td>\n",
       "      <td>POINT (-19.015438 29.154857)</td>\n",
       "      <td>80.140177</td>\n",
       "      <td>88.509625</td>\n",
       "      <td>16.638985</td>\n",
       "      <td>14.681265</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>782 rows × 30 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Country Code   Country         Income Group  Year  incidence_rate  \\\n",
       "0            DZA   Algeria  Lower middle income  2005             0.0   \n",
       "1            DZA   Algeria  Lower middle income  2006             0.0   \n",
       "2            DZA   Algeria  Lower middle income  2007             0.0   \n",
       "3            DZA   Algeria  Lower middle income  2008             0.0   \n",
       "4            DZA   Algeria  Lower middle income  2009             0.0   \n",
       "..           ...       ...                  ...   ...             ...   \n",
       "777          ZWE  Zimbabwe  Lower middle income  2017           115.2   \n",
       "778          ZWE  Zimbabwe  Lower middle income  2018            53.6   \n",
       "779          ZWE  Zimbabwe  Lower middle income  2019            64.7   \n",
       "780          ZWE  Zimbabwe  Lower middle income  2020            93.4   \n",
       "781          ZWE  Zimbabwe  Lower middle income  2021            27.2   \n",
       "\n",
       "     % basic_DW_all  % basic_DW_rural  % basic_DW_urban  \\\n",
       "0              91.1              85.0              94.6   \n",
       "1              91.4              85.4              94.7   \n",
       "2              91.6              85.7              94.7   \n",
       "3              91.8              86.0              94.8   \n",
       "4              92.1              86.4              94.9   \n",
       "..              ...               ...               ...   \n",
       "777            64.0              50.1              93.3   \n",
       "778            63.5              49.5              93.2   \n",
       "779            63.1              48.9              93.0   \n",
       "780            62.7              48.3              92.9   \n",
       "781            62.3              47.7              92.8   \n",
       "\n",
       "     % basic_sanitation_all  % basic_sanitation_rural  \\\n",
       "0                      85.8                      75.4   \n",
       "1                      86.1                      75.7   \n",
       "2                      86.3                      76.1   \n",
       "3                      86.5                      76.4   \n",
       "4                      86.8                      76.7   \n",
       "..                      ...                       ...   \n",
       "777                    36.9                      32.6   \n",
       "778                    36.4                      32.4   \n",
       "779                    35.8                      32.2   \n",
       "780                    35.2                      32.0   \n",
       "781                    34.6                      31.8   \n",
       "\n",
       "     % basic_sanitation_urban  % death_rate  % children_with_fever  \\\n",
       "0                        91.7           0.0                    4.9   \n",
       "1                        91.7           0.0                    4.9   \n",
       "2                        91.7           0.0                    4.9   \n",
       "3                        91.7           0.0                    4.9   \n",
       "4                        91.7           0.0                    4.7   \n",
       "..                        ...           ...                    ...   \n",
       "777                      46.0           0.0                    8.3   \n",
       "778                      44.6           0.0                    8.0   \n",
       "779                      43.2           0.0                    8.0   \n",
       "780                      41.8           0.0                    8.1   \n",
       "781                      40.4           0.0                    9.1   \n",
       "\n",
       "     % literacy_rate  % rural_pop  % safe_DW_all  % safe_DW_rural  \\\n",
       "0                0.0         36.2           72.8             56.5   \n",
       "1               72.6         35.4           73.2             57.4   \n",
       "2                0.0         34.7           73.7             58.3   \n",
       "3               75.1         33.9           74.2             59.3   \n",
       "4                0.0         33.2           74.6             60.2   \n",
       "..               ...          ...            ...              ...   \n",
       "777              0.0         67.8           26.9             13.6   \n",
       "778              0.0         67.8           26.8             13.3   \n",
       "779              0.0         67.8           26.7             13.1   \n",
       "780              0.0         67.8           26.6             12.9   \n",
       "781              0.0         67.7           26.5             12.6   \n",
       "\n",
       "     % safe_DW_urban  % safe_sanitation_all  % safe_sanitation_rural  \\\n",
       "0               82.0                   60.5                     50.4   \n",
       "1               81.9                   60.8                     50.8   \n",
       "2               81.9                   61.1                     51.2   \n",
       "3               81.8                   61.4                     51.6   \n",
       "4               81.8                   61.7                     52.0   \n",
       "..               ...                    ...                      ...   \n",
       "777             55.1                   33.6                     31.3   \n",
       "778             55.2                   33.5                     31.1   \n",
       "779             55.3                   33.0                     30.9   \n",
       "780             55.4                   32.4                     30.6   \n",
       "781             55.5                   31.8                     30.4   \n",
       "\n",
       "     % safe_sanitation_urban  % urban_pop  % insecticide   Latitude  \\\n",
       "0                       66.2         63.8            0.0  28.033886   \n",
       "1                       66.3         64.6            0.0  28.033886   \n",
       "2                       66.4         65.3            0.0  28.033886   \n",
       "3                       66.4         66.1            0.0  28.033886   \n",
       "4                       66.5         66.8            0.0  28.033886   \n",
       "..                       ...          ...            ...        ...   \n",
       "777                     38.4         32.2            0.0 -19.015438   \n",
       "778                     38.7         32.2            0.0 -19.015438   \n",
       "779                     37.4         32.2           14.9 -19.015438   \n",
       "780                     36.0         32.2            0.0 -19.015438   \n",
       "781                     34.7         32.3            0.0 -19.015438   \n",
       "\n",
       "     Longitude                       Geometry   Humidity  Precipitation  \\\n",
       "0      1.659626    POINT (28.033886 1.659626)  31.734205      10.968121   \n",
       "1      1.659626    POINT (28.033886 1.659626)   0.000000       0.000000   \n",
       "2      1.659626    POINT (28.033886 1.659626)  69.520863      74.638687   \n",
       "3      1.659626    POINT (28.033886 1.659626)  52.958708      86.310334   \n",
       "4      1.659626    POINT (28.033886 1.659626)  88.990603      44.402714   \n",
       "..          ...                           ...        ...            ...   \n",
       "777   29.154857  POINT (-19.015438 29.154857)  82.059757      77.844800   \n",
       "778   29.154857  POINT (-19.015438 29.154857)  67.200243      64.274397   \n",
       "779   29.154857  POINT (-19.015438 29.154857)   0.000000       0.000000   \n",
       "780   29.154857  POINT (-19.015438 29.154857)  46.634126       7.302774   \n",
       "781   29.154857  POINT (-19.015438 29.154857)  80.140177      88.509625   \n",
       "\n",
       "     Temperature  Wind Speed  \n",
       "0      13.504072    8.769347  \n",
       "1       0.000000    0.000000  \n",
       "2       5.783653   25.478604  \n",
       "3       7.554852    8.661352  \n",
       "4      17.102406   26.639289  \n",
       "..           ...         ...  \n",
       "777    11.331474   24.699471  \n",
       "778    13.514309   32.318263  \n",
       "779     0.000000    0.000000  \n",
       "780    17.690752   30.698054  \n",
       "781    16.638985   14.681265  \n",
       "\n",
       "[782 rows x 30 columns]"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "malaria_combine"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "c76efa08-9b4f-4ce2-a15f-381a53371275",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "46"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "malaria_combine[\"Country\"].nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "159f8e07-464d-4412-ba1f-49390f9a1cf2",
   "metadata": {},
   "outputs": [],
   "source": [
    "malaria_combine.to_csv(\"malaria_climate_data.csv\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "98317909-cbd1-493c-ba91-e3a59363b6a9",
   "metadata": {},
   "source": [
    "### Contributors\n",
    "- Oluwafemi Abiona\n",
    "- Solomon "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "91d39d6e-887a-419e-9756-8e76740e3b98",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}