HELINA-Workshop-2019-notebook-3.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "%run resources/library.py"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style> \n",
       "div.text_cell_render { /* Customize text cells */ \n",
       "    font-family: 'Arial'; \n",
       "    font-size:20px;\n",
       "    line-height: 1.5em;\n",
       "    padding-left:3em; \n",
       "    padding-right:3em; \n",
       "}\n",
       ".CodeMirror {\n",
       "    font-family:  'Source Code Pro', monospace;\n",
       "    font-size: 18px;\n",
       "}\n",
       "\n",
       "/* Cell output */\n",
       "\n",
       ".rendered_html pre, .rendered_html code {\n",
       "    color: inherit !important;\n",
       "    background-color: inherit !important;\n",
       "}\n",
       "div.output_area pre {\n",
       "    line-height: 1.2em;\n",
       "    color: #93a1a1 !important;\n",
       "    font-family: 'Source Code Pro', monospace;\n",
       "    font-size: 16px;\n",
       "}\n",
       ".rendered_html table, .rendered_html td, .rendered_html th {\n",
       "    border: 1px solid #586e75 !important;\n",
       "    font-family: 'Arial';\n",
       "    font-size: 16px;\n",
       "}\n",
       "</style>"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "style_notebook()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Welcome to Notebook 3 of the HELINA Workshop"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This notebook will help us explore the Place building block of Botswana's HIV epidemic. Using the pickle file of Table 6 of the BAIS 2013 report, we'll create a choropleth map."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### First, we need to read in the pickle file"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import pandas as pd\n",
    "import matplotlib as plt\n",
    "import geopandas as gpd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "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>District</th>\n",
       "      <th>Male</th>\n",
       "      <th>Female</th>\n",
       "      <th>TotalPop</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Gaborone</td>\n",
       "      <td>13.4</td>\n",
       "      <td>19.8</td>\n",
       "      <td>17.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Francistown</td>\n",
       "      <td>20.7</td>\n",
       "      <td>27.5</td>\n",
       "      <td>24.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Lobatse</td>\n",
       "      <td>13.4</td>\n",
       "      <td>20.0</td>\n",
       "      <td>17.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Selebi-Phikwe</td>\n",
       "      <td>25.4</td>\n",
       "      <td>29.3</td>\n",
       "      <td>27.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Orapa</td>\n",
       "      <td>9.9</td>\n",
       "      <td>20.2</td>\n",
       "      <td>15.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Jwaneng</td>\n",
       "      <td>8.5</td>\n",
       "      <td>16.7</td>\n",
       "      <td>12.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Sowa</td>\n",
       "      <td>13.3</td>\n",
       "      <td>26.5</td>\n",
       "      <td>19.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Southern</td>\n",
       "      <td>10.6</td>\n",
       "      <td>12.8</td>\n",
       "      <td>11.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Barolong</td>\n",
       "      <td>8.9</td>\n",
       "      <td>25.7</td>\n",
       "      <td>20.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Ngwaketse West</td>\n",
       "      <td>10.9</td>\n",
       "      <td>24.5</td>\n",
       "      <td>18.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Southeast</td>\n",
       "      <td>19.0</td>\n",
       "      <td>14.6</td>\n",
       "      <td>16.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Kweneng East</td>\n",
       "      <td>20.2</td>\n",
       "      <td>22.1</td>\n",
       "      <td>21.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Kweneng West</td>\n",
       "      <td>7.0</td>\n",
       "      <td>16.1</td>\n",
       "      <td>11.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Kgatleng</td>\n",
       "      <td>15.6</td>\n",
       "      <td>23.8</td>\n",
       "      <td>19.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Central-Serowe</td>\n",
       "      <td>16.4</td>\n",
       "      <td>17.8</td>\n",
       "      <td>17.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Central-Mahalapye</td>\n",
       "      <td>20.1</td>\n",
       "      <td>25.9</td>\n",
       "      <td>23.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Central-Bobonong</td>\n",
       "      <td>15.3</td>\n",
       "      <td>22.0</td>\n",
       "      <td>19.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Central-Boteti</td>\n",
       "      <td>15.5</td>\n",
       "      <td>25.5</td>\n",
       "      <td>20.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Central-Tutume</td>\n",
       "      <td>14.1</td>\n",
       "      <td>21.5</td>\n",
       "      <td>18.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Northeast</td>\n",
       "      <td>13.0</td>\n",
       "      <td>20.4</td>\n",
       "      <td>17.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Ngamiland South</td>\n",
       "      <td>13.3</td>\n",
       "      <td>17.2</td>\n",
       "      <td>15.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Ngamiland North</td>\n",
       "      <td>10.6</td>\n",
       "      <td>15.4</td>\n",
       "      <td>13.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Chobe</td>\n",
       "      <td>16.5</td>\n",
       "      <td>18.9</td>\n",
       "      <td>17.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Ghanzi</td>\n",
       "      <td>14.6</td>\n",
       "      <td>19.9</td>\n",
       "      <td>17.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Kgalagadi South</td>\n",
       "      <td>7.1</td>\n",
       "      <td>15.0</td>\n",
       "      <td>11.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Kgalagadi North</td>\n",
       "      <td>18.2</td>\n",
       "      <td>18.1</td>\n",
       "      <td>18.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Total Population</td>\n",
       "      <td>15.6</td>\n",
       "      <td>20.8</td>\n",
       "      <td>18.5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             District  Male Female TotalPop\n",
       "3            Gaborone  13.4   19.8     17.0\n",
       "4         Francistown  20.7   27.5     24.3\n",
       "5             Lobatse  13.4   20.0     17.2\n",
       "6       Selebi-Phikwe  25.4   29.3     27.5\n",
       "7               Orapa   9.9   20.2     15.6\n",
       "8             Jwaneng   8.5   16.7     12.8\n",
       "9                Sowa  13.3   26.5     19.8\n",
       "10           Southern  10.6   12.8     11.8\n",
       "11           Barolong   8.9   25.7     20.3\n",
       "12     Ngwaketse West  10.9   24.5     18.8\n",
       "13          Southeast  19.0   14.6     16.6\n",
       "14       Kweneng East  20.2   22.1     21.5\n",
       "15       Kweneng West   7.0   16.1     11.8\n",
       "16           Kgatleng  15.6   23.8     19.9\n",
       "17     Central-Serowe  16.4   17.8     17.1\n",
       "18  Central-Mahalapye  20.1   25.9     23.1\n",
       "19   Central-Bobonong  15.3   22.0     19.3\n",
       "20     Central-Boteti  15.5   25.5     20.3\n",
       "21     Central-Tutume  14.1   21.5     18.2\n",
       "22          Northeast  13.0   20.4     17.7\n",
       "23    Ngamiland South  13.3   17.2     15.2\n",
       "24    Ngamiland North  10.6   15.4     13.5\n",
       "25              Chobe  16.5   18.9     17.7\n",
       "26             Ghanzi  14.6   19.9     17.1\n",
       "27    Kgalagadi South   7.1   15.0     11.1\n",
       "28    Kgalagadi North  18.2   18.1     18.1\n",
       "29   Total Population  15.6   20.8     18.5"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "table6 = pd.read_pickle('outputs/table6pickle.pkl')\n",
    "table6"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "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>District</th>\n",
       "      <th>Male</th>\n",
       "      <th>Female</th>\n",
       "      <th>TotalPop</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Gaborone</td>\n",
       "      <td>13.4</td>\n",
       "      <td>19.8</td>\n",
       "      <td>17.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Francistown</td>\n",
       "      <td>20.7</td>\n",
       "      <td>27.5</td>\n",
       "      <td>24.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Lobatse</td>\n",
       "      <td>13.4</td>\n",
       "      <td>20.0</td>\n",
       "      <td>17.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Selebi-Phikwe</td>\n",
       "      <td>25.4</td>\n",
       "      <td>29.3</td>\n",
       "      <td>27.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Orapa</td>\n",
       "      <td>9.9</td>\n",
       "      <td>20.2</td>\n",
       "      <td>15.6</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        District  Male Female TotalPop\n",
       "3       Gaborone  13.4   19.8     17.0\n",
       "4    Francistown  20.7   27.5     24.3\n",
       "5        Lobatse  13.4   20.0     17.2\n",
       "6  Selebi-Phikwe  25.4   29.3     27.5\n",
       "7          Orapa   9.9   20.2     15.6"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Rename district names to match with the shapefile. \n",
    "table6 = table6.replace({\"Barolong\": \"Goodhope\", \"Central-Bobonong\": \"Bobirwa\", \"Central-Boteti\": \"Boteti\", \n",
    "                        \"Central-Mahalapye\": \"Mahalapye\", \"Central-Serowe\": \"Serowe\", \"Central-Tutume\": \"Tutume\",\n",
    "                        \"Ngamiland North\": \"Okavango\", \"Ngamiland South\": \"Ngamiland\", \"Ngwaketse West\": \"Mabutsane\",\n",
    "                        \"Northeast\": \"North East\", \"Southeast\": \"South East\"})\n",
    "table6.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "District    object\n",
       "Male        object\n",
       "Female      object\n",
       "TotalPop    object\n",
       "dtype: object"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# check data types.\n",
    "table6.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "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>Dname</th>\n",
       "      <th>uid</th>\n",
       "      <th>psnuuid</th>\n",
       "      <th>snulist</th>\n",
       "      <th>class</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Gaborone</td>\n",
       "      <td>VB7am4futjm</td>\n",
       "      <td>Y6TnOG79VvP</td>\n",
       "      <td>Greater Gabarone Cluster</td>\n",
       "      <td>2.0</td>\n",
       "      <td>POLYGON ((25.91833 -24.73833, 25.87139 -24.744...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Lobatse</td>\n",
       "      <td>m9qc7MnDafM</td>\n",
       "      <td>m9qc7MnDafM</td>\n",
       "      <td>Lobatse</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLYGON ((25.71922 -25.26861, 25.71179 -25.277...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Selebi-Phikwe</td>\n",
       "      <td>qUdeJw9Q0Vk</td>\n",
       "      <td>qUdeJw9Q0Vk</td>\n",
       "      <td>Selebi-Phikwe</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLYGON ((27.86585 -22.02339, 27.86016 -22.013...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Francistown</td>\n",
       "      <td>h1CepDrLWib</td>\n",
       "      <td>ZmWGSvpahPk</td>\n",
       "      <td>Greater Francistown Cluster</td>\n",
       "      <td>1.0</td>\n",
       "      <td>POLYGON ((27.44500 -21.22735, 27.43540 -21.186...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Boteti</td>\n",
       "      <td>p5JLtcOw9iv</td>\n",
       "      <td>p5JLtcOw9iv</td>\n",
       "      <td>Boteti</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLYGON ((24.80555 -22.16306, 24.56528 -21.860...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Chobe</td>\n",
       "      <td>e9Ze74PEe99</td>\n",
       "      <td>e9Ze74PEe99</td>\n",
       "      <td>Chobe</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLYGON ((24.99055 -19.00167, 24.71111 -19.000...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Ghanzi</td>\n",
       "      <td>saOJtBcENzM</td>\n",
       "      <td>saOJtBcENzM</td>\n",
       "      <td>Ghanzi</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLYGON ((23.88083 -20.99007, 24.19639 -21.393...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Kgalagadi South</td>\n",
       "      <td>KrgFtpUJ20E</td>\n",
       "      <td>KrgFtpUJ20E</td>\n",
       "      <td>Kgalagadi South District</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLYGON ((23.04889 -24.83722, 23.04972 -24.851...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Kgatleng</td>\n",
       "      <td>yNcvm7JYBfi</td>\n",
       "      <td>Y6TnOG79VvP</td>\n",
       "      <td>Greater Gaborone Cluster</td>\n",
       "      <td>2.0</td>\n",
       "      <td>POLYGON ((26.16783 -24.66397, 26.14139 -24.622...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Kweneng East</td>\n",
       "      <td>Uz8LWtC0vYF</td>\n",
       "      <td>Y6TnOG79VvP</td>\n",
       "      <td>Greater Gaborone Cluster</td>\n",
       "      <td>2.0</td>\n",
       "      <td>POLYGON ((25.81139 -23.34084, 25.82694 -23.344...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Ngamiland</td>\n",
       "      <td>TnDQJQtNVCK</td>\n",
       "      <td>TnDQJQtNVCK</td>\n",
       "      <td>Ngamiland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLYGON ((23.56055 -18.35417, 23.55972 -18.358...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>North East</td>\n",
       "      <td>nszh0FzynAQ</td>\n",
       "      <td>ZmWGSvpahPk</td>\n",
       "      <td>Greater Francistown Cluster</td>\n",
       "      <td>1.0</td>\n",
       "      <td>POLYGON ((27.43250 -20.47223, 27.51639 -20.476...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>South East</td>\n",
       "      <td>YksWHI1yLuv</td>\n",
       "      <td>Y6TnOG79VvP</td>\n",
       "      <td>Greater Gaborone Cluster</td>\n",
       "      <td>2.0</td>\n",
       "      <td>POLYGON ((25.95120 -24.50751, 26.14139 -24.622...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Mabutsane</td>\n",
       "      <td>GgzMAsHUgHC</td>\n",
       "      <td>GgzMAsHUgHC</td>\n",
       "      <td>Mabutsane</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLYGON ((23.90694 -24.84584, 23.48139 -24.848...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Okavango</td>\n",
       "      <td>ML9AwCIGjAx</td>\n",
       "      <td>ML9AwCIGjAx</td>\n",
       "      <td>Okavango</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLYGON ((20.99353 -19.17195, 20.99416 -18.695...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Kgalagadi North</td>\n",
       "      <td>oGXMBBGIRJl</td>\n",
       "      <td>oGXMBBGIRJl</td>\n",
       "      <td>Kgalagadi North District</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLYGON ((20.05917 -24.82639, 20.04444 -24.812...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Goodhope</td>\n",
       "      <td>y8A4MNQse4l</td>\n",
       "      <td>y8A4MNQse4l</td>\n",
       "      <td>Goodhope</td>\n",
       "      <td>2.0</td>\n",
       "      <td>POLYGON ((25.54722 -25.38528, 25.53500 -25.426...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Kweneng West</td>\n",
       "      <td>w2kp2bfOmNv</td>\n",
       "      <td>w2kp2bfOmNv</td>\n",
       "      <td>Kweneng West</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLYGON ((24.79000 -24.50445, 24.57722 -24.443...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Mahalapye</td>\n",
       "      <td>iY69BUSqcnC</td>\n",
       "      <td>iY69BUSqcnC</td>\n",
       "      <td>Mahalapye</td>\n",
       "      <td>2.0</td>\n",
       "      <td>POLYGON ((28.10972 -22.80611, 28.04944 -22.863...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Tutume</td>\n",
       "      <td>gchw5PMi4N2</td>\n",
       "      <td>ZmWGSvpahPk</td>\n",
       "      <td>Greater Francistown Cluster</td>\n",
       "      <td>1.0</td>\n",
       "      <td>POLYGON ((26.23887 -21.42929, 26.33437 -21.182...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Serowe</td>\n",
       "      <td>TcLMNlsgbcz</td>\n",
       "      <td>TcLMNlsgbcz</td>\n",
       "      <td>Serowe</td>\n",
       "      <td>1.0</td>\n",
       "      <td>POLYGON ((27.58646 -22.15963, 27.54326 -22.206...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Bobirwa</td>\n",
       "      <td>gGqaAXuUGpb</td>\n",
       "      <td>gGqaAXuUGpb</td>\n",
       "      <td>Bobirwa</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLYGON ((28.16194 -21.59361, 28.20277 -21.596...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Jwaneng</td>\n",
       "      <td>dEkUfWWZQ61</td>\n",
       "      <td>dEkUfWWZQ61</td>\n",
       "      <td>Jwaneng</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLYGON ((25.43238 -24.68462, 25.38345 -24.738...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Southern</td>\n",
       "      <td>LEUjALXInGD</td>\n",
       "      <td>LEUjALXInGD</td>\n",
       "      <td>Southern</td>\n",
       "      <td>2.0</td>\n",
       "      <td>POLYGON ((25.60806 -25.19139, 25.56341 -25.333...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Charleshill</td>\n",
       "      <td>v3v0gu2Gtol</td>\n",
       "      <td>v3v0gu2Gtol</td>\n",
       "      <td>Charleshill</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLYGON ((20.02576 -22.29043, 20.02493 -22.254...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Moshupa</td>\n",
       "      <td>xLLFT8x1CF5</td>\n",
       "      <td>xLLFT8x1CF5</td>\n",
       "      <td>Moshupa</td>\n",
       "      <td>2.0</td>\n",
       "      <td>POLYGON ((25.36943 -24.78912, 25.38345 -24.738...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Palapye</td>\n",
       "      <td>YmeyoDakwFX</td>\n",
       "      <td>YmeyoDakwFX</td>\n",
       "      <td>Palapye</td>\n",
       "      <td>1.0</td>\n",
       "      <td>POLYGON ((26.82830 -22.55473, 27.01026 -22.472...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              Dname          uid      psnuuid                      snulist  \\\n",
       "0          Gaborone  VB7am4futjm  Y6TnOG79VvP     Greater Gabarone Cluster   \n",
       "1           Lobatse  m9qc7MnDafM  m9qc7MnDafM                      Lobatse   \n",
       "2     Selebi-Phikwe  qUdeJw9Q0Vk  qUdeJw9Q0Vk                Selebi-Phikwe   \n",
       "3       Francistown  h1CepDrLWib  ZmWGSvpahPk  Greater Francistown Cluster   \n",
       "4            Boteti  p5JLtcOw9iv  p5JLtcOw9iv                       Boteti   \n",
       "5             Chobe  e9Ze74PEe99  e9Ze74PEe99                        Chobe   \n",
       "6            Ghanzi  saOJtBcENzM  saOJtBcENzM                       Ghanzi   \n",
       "7   Kgalagadi South  KrgFtpUJ20E  KrgFtpUJ20E     Kgalagadi South District   \n",
       "8          Kgatleng  yNcvm7JYBfi  Y6TnOG79VvP     Greater Gaborone Cluster   \n",
       "9      Kweneng East  Uz8LWtC0vYF  Y6TnOG79VvP     Greater Gaborone Cluster   \n",
       "10        Ngamiland  TnDQJQtNVCK  TnDQJQtNVCK                    Ngamiland   \n",
       "11       North East  nszh0FzynAQ  ZmWGSvpahPk  Greater Francistown Cluster   \n",
       "12       South East  YksWHI1yLuv  Y6TnOG79VvP     Greater Gaborone Cluster   \n",
       "13        Mabutsane  GgzMAsHUgHC  GgzMAsHUgHC                    Mabutsane   \n",
       "14         Okavango  ML9AwCIGjAx  ML9AwCIGjAx                     Okavango   \n",
       "15  Kgalagadi North  oGXMBBGIRJl  oGXMBBGIRJl     Kgalagadi North District   \n",
       "16         Goodhope  y8A4MNQse4l  y8A4MNQse4l                     Goodhope   \n",
       "17     Kweneng West  w2kp2bfOmNv  w2kp2bfOmNv                 Kweneng West   \n",
       "18        Mahalapye  iY69BUSqcnC  iY69BUSqcnC                    Mahalapye   \n",
       "19           Tutume  gchw5PMi4N2  ZmWGSvpahPk  Greater Francistown Cluster   \n",
       "20           Serowe  TcLMNlsgbcz  TcLMNlsgbcz                       Serowe   \n",
       "21          Bobirwa  gGqaAXuUGpb  gGqaAXuUGpb                      Bobirwa   \n",
       "22          Jwaneng  dEkUfWWZQ61  dEkUfWWZQ61                      Jwaneng   \n",
       "23         Southern  LEUjALXInGD  LEUjALXInGD                     Southern   \n",
       "24      Charleshill  v3v0gu2Gtol  v3v0gu2Gtol                  Charleshill   \n",
       "25          Moshupa  xLLFT8x1CF5  xLLFT8x1CF5                      Moshupa   \n",
       "26          Palapye  YmeyoDakwFX  YmeyoDakwFX                      Palapye   \n",
       "\n",
       "    class                                           geometry  \n",
       "0     2.0  POLYGON ((25.91833 -24.73833, 25.87139 -24.744...  \n",
       "1     NaN  POLYGON ((25.71922 -25.26861, 25.71179 -25.277...  \n",
       "2     NaN  POLYGON ((27.86585 -22.02339, 27.86016 -22.013...  \n",
       "3     1.0  POLYGON ((27.44500 -21.22735, 27.43540 -21.186...  \n",
       "4     NaN  POLYGON ((24.80555 -22.16306, 24.56528 -21.860...  \n",
       "5     NaN  POLYGON ((24.99055 -19.00167, 24.71111 -19.000...  \n",
       "6     NaN  POLYGON ((23.88083 -20.99007, 24.19639 -21.393...  \n",
       "7     NaN  POLYGON ((23.04889 -24.83722, 23.04972 -24.851...  \n",
       "8     2.0  POLYGON ((26.16783 -24.66397, 26.14139 -24.622...  \n",
       "9     2.0  POLYGON ((25.81139 -23.34084, 25.82694 -23.344...  \n",
       "10    NaN  POLYGON ((23.56055 -18.35417, 23.55972 -18.358...  \n",
       "11    1.0  POLYGON ((27.43250 -20.47223, 27.51639 -20.476...  \n",
       "12    2.0  POLYGON ((25.95120 -24.50751, 26.14139 -24.622...  \n",
       "13    NaN  POLYGON ((23.90694 -24.84584, 23.48139 -24.848...  \n",
       "14    NaN  POLYGON ((20.99353 -19.17195, 20.99416 -18.695...  \n",
       "15    NaN  POLYGON ((20.05917 -24.82639, 20.04444 -24.812...  \n",
       "16    2.0  POLYGON ((25.54722 -25.38528, 25.53500 -25.426...  \n",
       "17    NaN  POLYGON ((24.79000 -24.50445, 24.57722 -24.443...  \n",
       "18    2.0  POLYGON ((28.10972 -22.80611, 28.04944 -22.863...  \n",
       "19    1.0  POLYGON ((26.23887 -21.42929, 26.33437 -21.182...  \n",
       "20    1.0  POLYGON ((27.58646 -22.15963, 27.54326 -22.206...  \n",
       "21    NaN  POLYGON ((28.16194 -21.59361, 28.20277 -21.596...  \n",
       "22    NaN  POLYGON ((25.43238 -24.68462, 25.38345 -24.738...  \n",
       "23    2.0  POLYGON ((25.60806 -25.19139, 25.56341 -25.333...  \n",
       "24    NaN  POLYGON ((20.02576 -22.29043, 20.02493 -22.254...  \n",
       "25    2.0  POLYGON ((25.36943 -24.78912, 25.38345 -24.738...  \n",
       "26    1.0  POLYGON ((26.82830 -22.55473, 27.01026 -22.472...  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# load in a shapefile\n",
    "\n",
    "fp = \"resources/BW_27Health_Districts.shp\"\n",
    "map_df = gpd.read_file(fp)\n",
    "# check data type so we can see that this is not a normal dataframe, but a GEOdataframe\n",
    "map_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Dname         object\n",
       "uid           object\n",
       "psnuuid       object\n",
       "snulist       object\n",
       "class        float64\n",
       "geometry    geometry\n",
       "dtype: object"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "map_df.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "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>District</th>\n",
       "      <th>uid</th>\n",
       "      <th>psnuuid</th>\n",
       "      <th>snulist</th>\n",
       "      <th>class</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Gaborone</td>\n",
       "      <td>VB7am4futjm</td>\n",
       "      <td>Y6TnOG79VvP</td>\n",
       "      <td>Greater Gabarone Cluster</td>\n",
       "      <td>2.0</td>\n",
       "      <td>POLYGON ((25.91833 -24.73833, 25.87139 -24.744...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Lobatse</td>\n",
       "      <td>m9qc7MnDafM</td>\n",
       "      <td>m9qc7MnDafM</td>\n",
       "      <td>Lobatse</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLYGON ((25.71922 -25.26861, 25.71179 -25.277...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Selebi-Phikwe</td>\n",
       "      <td>qUdeJw9Q0Vk</td>\n",
       "      <td>qUdeJw9Q0Vk</td>\n",
       "      <td>Selebi-Phikwe</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLYGON ((27.86585 -22.02339, 27.86016 -22.013...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Francistown</td>\n",
       "      <td>h1CepDrLWib</td>\n",
       "      <td>ZmWGSvpahPk</td>\n",
       "      <td>Greater Francistown Cluster</td>\n",
       "      <td>1.0</td>\n",
       "      <td>POLYGON ((27.44500 -21.22735, 27.43540 -21.186...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Boteti</td>\n",
       "      <td>p5JLtcOw9iv</td>\n",
       "      <td>p5JLtcOw9iv</td>\n",
       "      <td>Boteti</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLYGON ((24.80555 -22.16306, 24.56528 -21.860...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Chobe</td>\n",
       "      <td>e9Ze74PEe99</td>\n",
       "      <td>e9Ze74PEe99</td>\n",
       "      <td>Chobe</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLYGON ((24.99055 -19.00167, 24.71111 -19.000...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Ghanzi</td>\n",
       "      <td>saOJtBcENzM</td>\n",
       "      <td>saOJtBcENzM</td>\n",
       "      <td>Ghanzi</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLYGON ((23.88083 -20.99007, 24.19639 -21.393...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Kgalagadi South</td>\n",
       "      <td>KrgFtpUJ20E</td>\n",
       "      <td>KrgFtpUJ20E</td>\n",
       "      <td>Kgalagadi South District</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLYGON ((23.04889 -24.83722, 23.04972 -24.851...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Kgatleng</td>\n",
       "      <td>yNcvm7JYBfi</td>\n",
       "      <td>Y6TnOG79VvP</td>\n",
       "      <td>Greater Gaborone Cluster</td>\n",
       "      <td>2.0</td>\n",
       "      <td>POLYGON ((26.16783 -24.66397, 26.14139 -24.622...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Kweneng East</td>\n",
       "      <td>Uz8LWtC0vYF</td>\n",
       "      <td>Y6TnOG79VvP</td>\n",
       "      <td>Greater Gaborone Cluster</td>\n",
       "      <td>2.0</td>\n",
       "      <td>POLYGON ((25.81139 -23.34084, 25.82694 -23.344...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Ngamiland</td>\n",
       "      <td>TnDQJQtNVCK</td>\n",
       "      <td>TnDQJQtNVCK</td>\n",
       "      <td>Ngamiland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLYGON ((23.56055 -18.35417, 23.55972 -18.358...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>North East</td>\n",
       "      <td>nszh0FzynAQ</td>\n",
       "      <td>ZmWGSvpahPk</td>\n",
       "      <td>Greater Francistown Cluster</td>\n",
       "      <td>1.0</td>\n",
       "      <td>POLYGON ((27.43250 -20.47223, 27.51639 -20.476...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>South East</td>\n",
       "      <td>YksWHI1yLuv</td>\n",
       "      <td>Y6TnOG79VvP</td>\n",
       "      <td>Greater Gaborone Cluster</td>\n",
       "      <td>2.0</td>\n",
       "      <td>POLYGON ((25.95120 -24.50751, 26.14139 -24.622...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Mabutsane</td>\n",
       "      <td>GgzMAsHUgHC</td>\n",
       "      <td>GgzMAsHUgHC</td>\n",
       "      <td>Mabutsane</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLYGON ((23.90694 -24.84584, 23.48139 -24.848...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Okavango</td>\n",
       "      <td>ML9AwCIGjAx</td>\n",
       "      <td>ML9AwCIGjAx</td>\n",
       "      <td>Okavango</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLYGON ((20.99353 -19.17195, 20.99416 -18.695...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Kgalagadi North</td>\n",
       "      <td>oGXMBBGIRJl</td>\n",
       "      <td>oGXMBBGIRJl</td>\n",
       "      <td>Kgalagadi North District</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLYGON ((20.05917 -24.82639, 20.04444 -24.812...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Goodhope</td>\n",
       "      <td>y8A4MNQse4l</td>\n",
       "      <td>y8A4MNQse4l</td>\n",
       "      <td>Goodhope</td>\n",
       "      <td>2.0</td>\n",
       "      <td>POLYGON ((25.54722 -25.38528, 25.53500 -25.426...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Kweneng West</td>\n",
       "      <td>w2kp2bfOmNv</td>\n",
       "      <td>w2kp2bfOmNv</td>\n",
       "      <td>Kweneng West</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLYGON ((24.79000 -24.50445, 24.57722 -24.443...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Mahalapye</td>\n",
       "      <td>iY69BUSqcnC</td>\n",
       "      <td>iY69BUSqcnC</td>\n",
       "      <td>Mahalapye</td>\n",
       "      <td>2.0</td>\n",
       "      <td>POLYGON ((28.10972 -22.80611, 28.04944 -22.863...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Tutume</td>\n",
       "      <td>gchw5PMi4N2</td>\n",
       "      <td>ZmWGSvpahPk</td>\n",
       "      <td>Greater Francistown Cluster</td>\n",
       "      <td>1.0</td>\n",
       "      <td>POLYGON ((26.23887 -21.42929, 26.33437 -21.182...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Serowe</td>\n",
       "      <td>TcLMNlsgbcz</td>\n",
       "      <td>TcLMNlsgbcz</td>\n",
       "      <td>Serowe</td>\n",
       "      <td>1.0</td>\n",
       "      <td>POLYGON ((27.58646 -22.15963, 27.54326 -22.206...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Bobirwa</td>\n",
       "      <td>gGqaAXuUGpb</td>\n",
       "      <td>gGqaAXuUGpb</td>\n",
       "      <td>Bobirwa</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLYGON ((28.16194 -21.59361, 28.20277 -21.596...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Jwaneng</td>\n",
       "      <td>dEkUfWWZQ61</td>\n",
       "      <td>dEkUfWWZQ61</td>\n",
       "      <td>Jwaneng</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLYGON ((25.43238 -24.68462, 25.38345 -24.738...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Southern</td>\n",
       "      <td>LEUjALXInGD</td>\n",
       "      <td>LEUjALXInGD</td>\n",
       "      <td>Southern</td>\n",
       "      <td>2.0</td>\n",
       "      <td>POLYGON ((25.60806 -25.19139, 25.56341 -25.333...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Charleshill</td>\n",
       "      <td>v3v0gu2Gtol</td>\n",
       "      <td>v3v0gu2Gtol</td>\n",
       "      <td>Charleshill</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLYGON ((20.02576 -22.29043, 20.02493 -22.254...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Moshupa</td>\n",
       "      <td>xLLFT8x1CF5</td>\n",
       "      <td>xLLFT8x1CF5</td>\n",
       "      <td>Moshupa</td>\n",
       "      <td>2.0</td>\n",
       "      <td>POLYGON ((25.36943 -24.78912, 25.38345 -24.738...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Palapye</td>\n",
       "      <td>YmeyoDakwFX</td>\n",
       "      <td>YmeyoDakwFX</td>\n",
       "      <td>Palapye</td>\n",
       "      <td>1.0</td>\n",
       "      <td>POLYGON ((26.82830 -22.55473, 27.01026 -22.472...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           District          uid      psnuuid                      snulist  \\\n",
       "0          Gaborone  VB7am4futjm  Y6TnOG79VvP     Greater Gabarone Cluster   \n",
       "1           Lobatse  m9qc7MnDafM  m9qc7MnDafM                      Lobatse   \n",
       "2     Selebi-Phikwe  qUdeJw9Q0Vk  qUdeJw9Q0Vk                Selebi-Phikwe   \n",
       "3       Francistown  h1CepDrLWib  ZmWGSvpahPk  Greater Francistown Cluster   \n",
       "4            Boteti  p5JLtcOw9iv  p5JLtcOw9iv                       Boteti   \n",
       "5             Chobe  e9Ze74PEe99  e9Ze74PEe99                        Chobe   \n",
       "6            Ghanzi  saOJtBcENzM  saOJtBcENzM                       Ghanzi   \n",
       "7   Kgalagadi South  KrgFtpUJ20E  KrgFtpUJ20E     Kgalagadi South District   \n",
       "8          Kgatleng  yNcvm7JYBfi  Y6TnOG79VvP     Greater Gaborone Cluster   \n",
       "9      Kweneng East  Uz8LWtC0vYF  Y6TnOG79VvP     Greater Gaborone Cluster   \n",
       "10        Ngamiland  TnDQJQtNVCK  TnDQJQtNVCK                    Ngamiland   \n",
       "11       North East  nszh0FzynAQ  ZmWGSvpahPk  Greater Francistown Cluster   \n",
       "12       South East  YksWHI1yLuv  Y6TnOG79VvP     Greater Gaborone Cluster   \n",
       "13        Mabutsane  GgzMAsHUgHC  GgzMAsHUgHC                    Mabutsane   \n",
       "14         Okavango  ML9AwCIGjAx  ML9AwCIGjAx                     Okavango   \n",
       "15  Kgalagadi North  oGXMBBGIRJl  oGXMBBGIRJl     Kgalagadi North District   \n",
       "16         Goodhope  y8A4MNQse4l  y8A4MNQse4l                     Goodhope   \n",
       "17     Kweneng West  w2kp2bfOmNv  w2kp2bfOmNv                 Kweneng West   \n",
       "18        Mahalapye  iY69BUSqcnC  iY69BUSqcnC                    Mahalapye   \n",
       "19           Tutume  gchw5PMi4N2  ZmWGSvpahPk  Greater Francistown Cluster   \n",
       "20           Serowe  TcLMNlsgbcz  TcLMNlsgbcz                       Serowe   \n",
       "21          Bobirwa  gGqaAXuUGpb  gGqaAXuUGpb                      Bobirwa   \n",
       "22          Jwaneng  dEkUfWWZQ61  dEkUfWWZQ61                      Jwaneng   \n",
       "23         Southern  LEUjALXInGD  LEUjALXInGD                     Southern   \n",
       "24      Charleshill  v3v0gu2Gtol  v3v0gu2Gtol                  Charleshill   \n",
       "25          Moshupa  xLLFT8x1CF5  xLLFT8x1CF5                      Moshupa   \n",
       "26          Palapye  YmeyoDakwFX  YmeyoDakwFX                      Palapye   \n",
       "\n",
       "    class                                           geometry  \n",
       "0     2.0  POLYGON ((25.91833 -24.73833, 25.87139 -24.744...  \n",
       "1     NaN  POLYGON ((25.71922 -25.26861, 25.71179 -25.277...  \n",
       "2     NaN  POLYGON ((27.86585 -22.02339, 27.86016 -22.013...  \n",
       "3     1.0  POLYGON ((27.44500 -21.22735, 27.43540 -21.186...  \n",
       "4     NaN  POLYGON ((24.80555 -22.16306, 24.56528 -21.860...  \n",
       "5     NaN  POLYGON ((24.99055 -19.00167, 24.71111 -19.000...  \n",
       "6     NaN  POLYGON ((23.88083 -20.99007, 24.19639 -21.393...  \n",
       "7     NaN  POLYGON ((23.04889 -24.83722, 23.04972 -24.851...  \n",
       "8     2.0  POLYGON ((26.16783 -24.66397, 26.14139 -24.622...  \n",
       "9     2.0  POLYGON ((25.81139 -23.34084, 25.82694 -23.344...  \n",
       "10    NaN  POLYGON ((23.56055 -18.35417, 23.55972 -18.358...  \n",
       "11    1.0  POLYGON ((27.43250 -20.47223, 27.51639 -20.476...  \n",
       "12    2.0  POLYGON ((25.95120 -24.50751, 26.14139 -24.622...  \n",
       "13    NaN  POLYGON ((23.90694 -24.84584, 23.48139 -24.848...  \n",
       "14    NaN  POLYGON ((20.99353 -19.17195, 20.99416 -18.695...  \n",
       "15    NaN  POLYGON ((20.05917 -24.82639, 20.04444 -24.812...  \n",
       "16    2.0  POLYGON ((25.54722 -25.38528, 25.53500 -25.426...  \n",
       "17    NaN  POLYGON ((24.79000 -24.50445, 24.57722 -24.443...  \n",
       "18    2.0  POLYGON ((28.10972 -22.80611, 28.04944 -22.863...  \n",
       "19    1.0  POLYGON ((26.23887 -21.42929, 26.33437 -21.182...  \n",
       "20    1.0  POLYGON ((27.58646 -22.15963, 27.54326 -22.206...  \n",
       "21    NaN  POLYGON ((28.16194 -21.59361, 28.20277 -21.596...  \n",
       "22    NaN  POLYGON ((25.43238 -24.68462, 25.38345 -24.738...  \n",
       "23    2.0  POLYGON ((25.60806 -25.19139, 25.56341 -25.333...  \n",
       "24    NaN  POLYGON ((20.02576 -22.29043, 20.02493 -22.254...  \n",
       "25    2.0  POLYGON ((25.36943 -24.78912, 25.38345 -24.738...  \n",
       "26    1.0  POLYGON ((26.82830 -22.55473, 27.01026 -22.472...  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# rename \"NAME_2\" columnt to \"District\" to match with the csv.\n",
    "map_df.rename(columns={'Dname':'District'}, inplace=True)\n",
    "map_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "District      object\n",
       "uid           object\n",
       "psnuuid       object\n",
       "snulist       object\n",
       "class        float64\n",
       "geometry    geometry\n",
       "dtype: object"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "map_df.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "# save shapefile as GeoJson.\n",
    "map_df.to_file('resources/polygons.json', driver=\"GeoJSON\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x7f532075ab70>"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%matplotlib inline\n",
    "map_df.plot()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "scrolled": true
   },
   "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>District</th>\n",
       "      <th>Male</th>\n",
       "      <th>Female</th>\n",
       "      <th>TotalPop</th>\n",
       "      <th>uid</th>\n",
       "      <th>psnuuid</th>\n",
       "      <th>snulist</th>\n",
       "      <th>class</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Gaborone</td>\n",
       "      <td>13.4</td>\n",
       "      <td>19.8</td>\n",
       "      <td>17.0</td>\n",
       "      <td>VB7am4futjm</td>\n",
       "      <td>Y6TnOG79VvP</td>\n",
       "      <td>Greater Gabarone Cluster</td>\n",
       "      <td>2.0</td>\n",
       "      <td>POLYGON ((25.91833 -24.73833, 25.87139 -24.744...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Francistown</td>\n",
       "      <td>20.7</td>\n",
       "      <td>27.5</td>\n",
       "      <td>24.3</td>\n",
       "      <td>h1CepDrLWib</td>\n",
       "      <td>ZmWGSvpahPk</td>\n",
       "      <td>Greater Francistown Cluster</td>\n",
       "      <td>1.0</td>\n",
       "      <td>POLYGON ((27.44500 -21.22735, 27.43540 -21.186...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Lobatse</td>\n",
       "      <td>13.4</td>\n",
       "      <td>20.0</td>\n",
       "      <td>17.2</td>\n",
       "      <td>m9qc7MnDafM</td>\n",
       "      <td>m9qc7MnDafM</td>\n",
       "      <td>Lobatse</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLYGON ((25.71922 -25.26861, 25.71179 -25.277...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Selebi-Phikwe</td>\n",
       "      <td>25.4</td>\n",
       "      <td>29.3</td>\n",
       "      <td>27.5</td>\n",
       "      <td>qUdeJw9Q0Vk</td>\n",
       "      <td>qUdeJw9Q0Vk</td>\n",
       "      <td>Selebi-Phikwe</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLYGON ((27.86585 -22.02339, 27.86016 -22.013...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Orapa</td>\n",
       "      <td>9.9</td>\n",
       "      <td>20.2</td>\n",
       "      <td>15.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Jwaneng</td>\n",
       "      <td>8.5</td>\n",
       "      <td>16.7</td>\n",
       "      <td>12.8</td>\n",
       "      <td>dEkUfWWZQ61</td>\n",
       "      <td>dEkUfWWZQ61</td>\n",
       "      <td>Jwaneng</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLYGON ((25.43238 -24.68462, 25.38345 -24.738...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Sowa</td>\n",
       "      <td>13.3</td>\n",
       "      <td>26.5</td>\n",
       "      <td>19.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Southern</td>\n",
       "      <td>10.6</td>\n",
       "      <td>12.8</td>\n",
       "      <td>11.8</td>\n",
       "      <td>LEUjALXInGD</td>\n",
       "      <td>LEUjALXInGD</td>\n",
       "      <td>Southern</td>\n",
       "      <td>2.0</td>\n",
       "      <td>POLYGON ((25.60806 -25.19139, 25.56341 -25.333...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Goodhope</td>\n",
       "      <td>8.9</td>\n",
       "      <td>25.7</td>\n",
       "      <td>20.3</td>\n",
       "      <td>y8A4MNQse4l</td>\n",
       "      <td>y8A4MNQse4l</td>\n",
       "      <td>Goodhope</td>\n",
       "      <td>2.0</td>\n",
       "      <td>POLYGON ((25.54722 -25.38528, 25.53500 -25.426...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Mabutsane</td>\n",
       "      <td>10.9</td>\n",
       "      <td>24.5</td>\n",
       "      <td>18.8</td>\n",
       "      <td>GgzMAsHUgHC</td>\n",
       "      <td>GgzMAsHUgHC</td>\n",
       "      <td>Mabutsane</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLYGON ((23.90694 -24.84584, 23.48139 -24.848...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>South East</td>\n",
       "      <td>19.0</td>\n",
       "      <td>14.6</td>\n",
       "      <td>16.6</td>\n",
       "      <td>YksWHI1yLuv</td>\n",
       "      <td>Y6TnOG79VvP</td>\n",
       "      <td>Greater Gaborone Cluster</td>\n",
       "      <td>2.0</td>\n",
       "      <td>POLYGON ((25.95120 -24.50751, 26.14139 -24.622...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Kweneng East</td>\n",
       "      <td>20.2</td>\n",
       "      <td>22.1</td>\n",
       "      <td>21.5</td>\n",
       "      <td>Uz8LWtC0vYF</td>\n",
       "      <td>Y6TnOG79VvP</td>\n",
       "      <td>Greater Gaborone Cluster</td>\n",
       "      <td>2.0</td>\n",
       "      <td>POLYGON ((25.81139 -23.34084, 25.82694 -23.344...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Kweneng West</td>\n",
       "      <td>7.0</td>\n",
       "      <td>16.1</td>\n",
       "      <td>11.8</td>\n",
       "      <td>w2kp2bfOmNv</td>\n",
       "      <td>w2kp2bfOmNv</td>\n",
       "      <td>Kweneng West</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLYGON ((24.79000 -24.50445, 24.57722 -24.443...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Kgatleng</td>\n",
       "      <td>15.6</td>\n",
       "      <td>23.8</td>\n",
       "      <td>19.9</td>\n",
       "      <td>yNcvm7JYBfi</td>\n",
       "      <td>Y6TnOG79VvP</td>\n",
       "      <td>Greater Gaborone Cluster</td>\n",
       "      <td>2.0</td>\n",
       "      <td>POLYGON ((26.16783 -24.66397, 26.14139 -24.622...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Serowe</td>\n",
       "      <td>16.4</td>\n",
       "      <td>17.8</td>\n",
       "      <td>17.1</td>\n",
       "      <td>TcLMNlsgbcz</td>\n",
       "      <td>TcLMNlsgbcz</td>\n",
       "      <td>Serowe</td>\n",
       "      <td>1.0</td>\n",
       "      <td>POLYGON ((27.58646 -22.15963, 27.54326 -22.206...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Mahalapye</td>\n",
       "      <td>20.1</td>\n",
       "      <td>25.9</td>\n",
       "      <td>23.1</td>\n",
       "      <td>iY69BUSqcnC</td>\n",
       "      <td>iY69BUSqcnC</td>\n",
       "      <td>Mahalapye</td>\n",
       "      <td>2.0</td>\n",
       "      <td>POLYGON ((28.10972 -22.80611, 28.04944 -22.863...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Bobirwa</td>\n",
       "      <td>15.3</td>\n",
       "      <td>22.0</td>\n",
       "      <td>19.3</td>\n",
       "      <td>gGqaAXuUGpb</td>\n",
       "      <td>gGqaAXuUGpb</td>\n",
       "      <td>Bobirwa</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLYGON ((28.16194 -21.59361, 28.20277 -21.596...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Boteti</td>\n",
       "      <td>15.5</td>\n",
       "      <td>25.5</td>\n",
       "      <td>20.3</td>\n",
       "      <td>p5JLtcOw9iv</td>\n",
       "      <td>p5JLtcOw9iv</td>\n",
       "      <td>Boteti</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLYGON ((24.80555 -22.16306, 24.56528 -21.860...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Tutume</td>\n",
       "      <td>14.1</td>\n",
       "      <td>21.5</td>\n",
       "      <td>18.2</td>\n",
       "      <td>gchw5PMi4N2</td>\n",
       "      <td>ZmWGSvpahPk</td>\n",
       "      <td>Greater Francistown Cluster</td>\n",
       "      <td>1.0</td>\n",
       "      <td>POLYGON ((26.23887 -21.42929, 26.33437 -21.182...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>North East</td>\n",
       "      <td>13.0</td>\n",
       "      <td>20.4</td>\n",
       "      <td>17.7</td>\n",
       "      <td>nszh0FzynAQ</td>\n",
       "      <td>ZmWGSvpahPk</td>\n",
       "      <td>Greater Francistown Cluster</td>\n",
       "      <td>1.0</td>\n",
       "      <td>POLYGON ((27.43250 -20.47223, 27.51639 -20.476...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Ngamiland</td>\n",
       "      <td>13.3</td>\n",
       "      <td>17.2</td>\n",
       "      <td>15.2</td>\n",
       "      <td>TnDQJQtNVCK</td>\n",
       "      <td>TnDQJQtNVCK</td>\n",
       "      <td>Ngamiland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLYGON ((23.56055 -18.35417, 23.55972 -18.358...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Okavango</td>\n",
       "      <td>10.6</td>\n",
       "      <td>15.4</td>\n",
       "      <td>13.5</td>\n",
       "      <td>ML9AwCIGjAx</td>\n",
       "      <td>ML9AwCIGjAx</td>\n",
       "      <td>Okavango</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLYGON ((20.99353 -19.17195, 20.99416 -18.695...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Chobe</td>\n",
       "      <td>16.5</td>\n",
       "      <td>18.9</td>\n",
       "      <td>17.7</td>\n",
       "      <td>e9Ze74PEe99</td>\n",
       "      <td>e9Ze74PEe99</td>\n",
       "      <td>Chobe</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLYGON ((24.99055 -19.00167, 24.71111 -19.000...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Ghanzi</td>\n",
       "      <td>14.6</td>\n",
       "      <td>19.9</td>\n",
       "      <td>17.1</td>\n",
       "      <td>saOJtBcENzM</td>\n",
       "      <td>saOJtBcENzM</td>\n",
       "      <td>Ghanzi</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLYGON ((23.88083 -20.99007, 24.19639 -21.393...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Kgalagadi South</td>\n",
       "      <td>7.1</td>\n",
       "      <td>15.0</td>\n",
       "      <td>11.1</td>\n",
       "      <td>KrgFtpUJ20E</td>\n",
       "      <td>KrgFtpUJ20E</td>\n",
       "      <td>Kgalagadi South District</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLYGON ((23.04889 -24.83722, 23.04972 -24.851...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Kgalagadi North</td>\n",
       "      <td>18.2</td>\n",
       "      <td>18.1</td>\n",
       "      <td>18.1</td>\n",
       "      <td>oGXMBBGIRJl</td>\n",
       "      <td>oGXMBBGIRJl</td>\n",
       "      <td>Kgalagadi North District</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLYGON ((20.05917 -24.82639, 20.04444 -24.812...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Total Population</td>\n",
       "      <td>15.6</td>\n",
       "      <td>20.8</td>\n",
       "      <td>18.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Charleshill</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>v3v0gu2Gtol</td>\n",
       "      <td>v3v0gu2Gtol</td>\n",
       "      <td>Charleshill</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLYGON ((20.02576 -22.29043, 20.02493 -22.254...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Moshupa</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>xLLFT8x1CF5</td>\n",
       "      <td>xLLFT8x1CF5</td>\n",
       "      <td>Moshupa</td>\n",
       "      <td>2.0</td>\n",
       "      <td>POLYGON ((25.36943 -24.78912, 25.38345 -24.738...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Palapye</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>YmeyoDakwFX</td>\n",
       "      <td>YmeyoDakwFX</td>\n",
       "      <td>Palapye</td>\n",
       "      <td>1.0</td>\n",
       "      <td>POLYGON ((26.82830 -22.55473, 27.01026 -22.472...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            District  Male Female TotalPop          uid      psnuuid  \\\n",
       "0           Gaborone  13.4   19.8     17.0  VB7am4futjm  Y6TnOG79VvP   \n",
       "1        Francistown  20.7   27.5     24.3  h1CepDrLWib  ZmWGSvpahPk   \n",
       "2            Lobatse  13.4   20.0     17.2  m9qc7MnDafM  m9qc7MnDafM   \n",
       "3      Selebi-Phikwe  25.4   29.3     27.5  qUdeJw9Q0Vk  qUdeJw9Q0Vk   \n",
       "4              Orapa   9.9   20.2     15.6          NaN          NaN   \n",
       "5            Jwaneng   8.5   16.7     12.8  dEkUfWWZQ61  dEkUfWWZQ61   \n",
       "6               Sowa  13.3   26.5     19.8          NaN          NaN   \n",
       "7           Southern  10.6   12.8     11.8  LEUjALXInGD  LEUjALXInGD   \n",
       "8           Goodhope   8.9   25.7     20.3  y8A4MNQse4l  y8A4MNQse4l   \n",
       "9          Mabutsane  10.9   24.5     18.8  GgzMAsHUgHC  GgzMAsHUgHC   \n",
       "10        South East  19.0   14.6     16.6  YksWHI1yLuv  Y6TnOG79VvP   \n",
       "11      Kweneng East  20.2   22.1     21.5  Uz8LWtC0vYF  Y6TnOG79VvP   \n",
       "12      Kweneng West   7.0   16.1     11.8  w2kp2bfOmNv  w2kp2bfOmNv   \n",
       "13          Kgatleng  15.6   23.8     19.9  yNcvm7JYBfi  Y6TnOG79VvP   \n",
       "14            Serowe  16.4   17.8     17.1  TcLMNlsgbcz  TcLMNlsgbcz   \n",
       "15         Mahalapye  20.1   25.9     23.1  iY69BUSqcnC  iY69BUSqcnC   \n",
       "16           Bobirwa  15.3   22.0     19.3  gGqaAXuUGpb  gGqaAXuUGpb   \n",
       "17            Boteti  15.5   25.5     20.3  p5JLtcOw9iv  p5JLtcOw9iv   \n",
       "18            Tutume  14.1   21.5     18.2  gchw5PMi4N2  ZmWGSvpahPk   \n",
       "19        North East  13.0   20.4     17.7  nszh0FzynAQ  ZmWGSvpahPk   \n",
       "20         Ngamiland  13.3   17.2     15.2  TnDQJQtNVCK  TnDQJQtNVCK   \n",
       "21          Okavango  10.6   15.4     13.5  ML9AwCIGjAx  ML9AwCIGjAx   \n",
       "22             Chobe  16.5   18.9     17.7  e9Ze74PEe99  e9Ze74PEe99   \n",
       "23            Ghanzi  14.6   19.9     17.1  saOJtBcENzM  saOJtBcENzM   \n",
       "24   Kgalagadi South   7.1   15.0     11.1  KrgFtpUJ20E  KrgFtpUJ20E   \n",
       "25   Kgalagadi North  18.2   18.1     18.1  oGXMBBGIRJl  oGXMBBGIRJl   \n",
       "26  Total Population  15.6   20.8     18.5          NaN          NaN   \n",
       "27       Charleshill   NaN    NaN      NaN  v3v0gu2Gtol  v3v0gu2Gtol   \n",
       "28           Moshupa   NaN    NaN      NaN  xLLFT8x1CF5  xLLFT8x1CF5   \n",
       "29           Palapye   NaN    NaN      NaN  YmeyoDakwFX  YmeyoDakwFX   \n",
       "\n",
       "                        snulist  class  \\\n",
       "0      Greater Gabarone Cluster    2.0   \n",
       "1   Greater Francistown Cluster    1.0   \n",
       "2                       Lobatse    NaN   \n",
       "3                 Selebi-Phikwe    NaN   \n",
       "4                           NaN    NaN   \n",
       "5                       Jwaneng    NaN   \n",
       "6                           NaN    NaN   \n",
       "7                      Southern    2.0   \n",
       "8                      Goodhope    2.0   \n",
       "9                     Mabutsane    NaN   \n",
       "10     Greater Gaborone Cluster    2.0   \n",
       "11     Greater Gaborone Cluster    2.0   \n",
       "12                 Kweneng West    NaN   \n",
       "13     Greater Gaborone Cluster    2.0   \n",
       "14                       Serowe    1.0   \n",
       "15                    Mahalapye    2.0   \n",
       "16                      Bobirwa    NaN   \n",
       "17                       Boteti    NaN   \n",
       "18  Greater Francistown Cluster    1.0   \n",
       "19  Greater Francistown Cluster    1.0   \n",
       "20                    Ngamiland    NaN   \n",
       "21                     Okavango    NaN   \n",
       "22                        Chobe    NaN   \n",
       "23                       Ghanzi    NaN   \n",
       "24     Kgalagadi South District    NaN   \n",
       "25     Kgalagadi North District    NaN   \n",
       "26                          NaN    NaN   \n",
       "27                  Charleshill    NaN   \n",
       "28                      Moshupa    2.0   \n",
       "29                      Palapye    1.0   \n",
       "\n",
       "                                             geometry  \n",
       "0   POLYGON ((25.91833 -24.73833, 25.87139 -24.744...  \n",
       "1   POLYGON ((27.44500 -21.22735, 27.43540 -21.186...  \n",
       "2   POLYGON ((25.71922 -25.26861, 25.71179 -25.277...  \n",
       "3   POLYGON ((27.86585 -22.02339, 27.86016 -22.013...  \n",
       "4                                                None  \n",
       "5   POLYGON ((25.43238 -24.68462, 25.38345 -24.738...  \n",
       "6                                                None  \n",
       "7   POLYGON ((25.60806 -25.19139, 25.56341 -25.333...  \n",
       "8   POLYGON ((25.54722 -25.38528, 25.53500 -25.426...  \n",
       "9   POLYGON ((23.90694 -24.84584, 23.48139 -24.848...  \n",
       "10  POLYGON ((25.95120 -24.50751, 26.14139 -24.622...  \n",
       "11  POLYGON ((25.81139 -23.34084, 25.82694 -23.344...  \n",
       "12  POLYGON ((24.79000 -24.50445, 24.57722 -24.443...  \n",
       "13  POLYGON ((26.16783 -24.66397, 26.14139 -24.622...  \n",
       "14  POLYGON ((27.58646 -22.15963, 27.54326 -22.206...  \n",
       "15  POLYGON ((28.10972 -22.80611, 28.04944 -22.863...  \n",
       "16  POLYGON ((28.16194 -21.59361, 28.20277 -21.596...  \n",
       "17  POLYGON ((24.80555 -22.16306, 24.56528 -21.860...  \n",
       "18  POLYGON ((26.23887 -21.42929, 26.33437 -21.182...  \n",
       "19  POLYGON ((27.43250 -20.47223, 27.51639 -20.476...  \n",
       "20  POLYGON ((23.56055 -18.35417, 23.55972 -18.358...  \n",
       "21  POLYGON ((20.99353 -19.17195, 20.99416 -18.695...  \n",
       "22  POLYGON ((24.99055 -19.00167, 24.71111 -19.000...  \n",
       "23  POLYGON ((23.88083 -20.99007, 24.19639 -21.393...  \n",
       "24  POLYGON ((23.04889 -24.83722, 23.04972 -24.851...  \n",
       "25  POLYGON ((20.05917 -24.82639, 20.04444 -24.812...  \n",
       "26                                               None  \n",
       "27  POLYGON ((20.02576 -22.29043, 20.02493 -22.254...  \n",
       "28  POLYGON ((25.36943 -24.78912, 25.38345 -24.738...  \n",
       "29  POLYGON ((26.82830 -22.55473, 27.01026 -22.472...  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Check if districts in csv and shapefile match. \n",
    "df_merge = pd.merge(table6, map_df, on='District', how='outer')\n",
    "df_merge"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "# save as a csv.\n",
    "table6.to_csv('resources/popdata_matched.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "import folium\n",
    "import json"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "state_geo = r'resources/polygons.json'\n",
    "table = r'resources/popdata_matched.csv'\n",
    "csvtable = pd.read_csv(table)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "m = folium.Map(location=[-22.212136, 23.717579], zoom_start=6)\n",
    "\n",
    "folium.Choropleth(\n",
    "    geo_data=state_geo,\n",
    "    name='choropleth',\n",
    "    data=csvtable,\n",
    "    columns=['District', 'TotalPop'],\n",
    "    key_on='feature.properties.District',\n",
    "    fill_color='YlGn',\n",
    "    fill_opacity=0.7,\n",
    "    line_opacity=0.2,\n",
    "    legend_name=\"HIV Prevalence Total Population\",\n",
    ").add_to(m)\n",
    "\n",
    "m.save(os.path.join('resources', 'map_total.html'))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "HIV Prevalence Total Population (5 disticts have no data and display in dark grey). "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "        <iframe\n",
       "            width=\"950\"\n",
       "            height=\"600\"\n",
       "            src=\"resources/map_total.html\"\n",
       "            frameborder=\"0\"\n",
       "            allowfullscreen\n",
       "        ></iframe>\n",
       "        "
      ],
      "text/plain": [
       "<IPython.lib.display.IFrame at 0x7f531b684400>"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from IPython.display import IFrame\n",
    "\n",
    "IFrame(src='resources/map_total.html', width=950, height=600)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "m = folium.Map(location=[-22.212136, 23.717579], zoom_start=6)\n",
    "\n",
    "folium.Choropleth(\n",
    "    geo_data=state_geo,\n",
    "    name='choropleth',\n",
    "    data=csvtable,\n",
    "    columns=['District', 'Male'],\n",
    "    key_on='feature.properties.District',\n",
    "    fill_color='GnBu',\n",
    "    fill_opacity=0.7,\n",
    "    line_opacity=0.2,\n",
    "    legend_name=\"HIV Prevalence Male\",\n",
    ").add_to(m)\n",
    "\n",
    "m.save(os.path.join('resources', 'map_males.html'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "        <iframe\n",
       "            width=\"950\"\n",
       "            height=\"600\"\n",
       "            src=\"resources/map_males.html\"\n",
       "            frameborder=\"0\"\n",
       "            allowfullscreen\n",
       "        ></iframe>\n",
       "        "
      ],
      "text/plain": [
       "<IPython.lib.display.IFrame at 0x7f531b67be48>"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from IPython.display import IFrame\n",
    "\n",
    "IFrame(src='resources/map_males.html', width=950, height=600)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "m = folium.Map(location=[-22.212136, 23.717579], zoom_start=6)\n",
    "\n",
    "folium.Choropleth(\n",
    "    geo_data=state_geo,\n",
    "    name='choropleth',\n",
    "    data=csvtable,\n",
    "    columns=['District', 'Female'],\n",
    "    key_on='feature.properties.District',\n",
    "    fill_color='BuPu',\n",
    "    fill_opacity=0.7,\n",
    "    line_opacity=0.2,\n",
    "    legend_name=\"HIV Prevalence Female\",\n",
    ").add_to(m)\n",
    "\n",
    "m.save(os.path.join('resources', 'map_females.html'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "        <iframe\n",
       "            width=\"950\"\n",
       "            height=\"600\"\n",
       "            src=\"resources/map_females.html\"\n",
       "            frameborder=\"0\"\n",
       "            allowfullscreen\n",
       "        ></iframe>\n",
       "        "
      ],
      "text/plain": [
       "<IPython.lib.display.IFrame at 0x7f531b64a400>"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from IPython.display import IFrame\n",
    "\n",
    "IFrame(src='resources/map_females.html', width=950, height=600)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "But, wait! Why are some areas of the map grayed out?\n",
    "\n",
    "There are 26 records in BAIS 2013 table vs 27 records in the current Botswana Shapefile. Three districts on the map have no data and display as dark grey. Orapa and Sowa from BAIS report are towns so they could not be matched to district shapefile. They could be counted as part of districts they are in. Palapye, Charleshill, Moshupa areas in the shapefile do not have matches with BAIS, maybe because they were not surveyed by BAIS or surveyed as part of other districts from which they separated later."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Congratulations !  You have completed the \"Place\" lego block."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "![PLACE LEGO](resources/Place_Lego_block.png)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}