DLR Explorer Notebook.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Domestic Load Research Data Explorer for the Curious\n",
    "This notebook contains the functions that do the data processing in the DLR Data Explorer app so that curious researchers can have a more fine grained view of the dataset."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Function and Data Setup"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Import Statements"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<script>requirejs.config({paths: { 'plotly': ['https://cdn.plot.ly/plotly-latest.min']},});if(!window.Plotly) {{require(['plotly'],function(plotly) {window.Plotly=plotly;});}}</script>"
      ],
      "text/vnd.plotly.v1+html": [
       "<script>requirejs.config({paths: { 'plotly': ['https://cdn.plot.ly/plotly-latest.min']},});if(!window.Plotly) {{require(['plotly'],function(plotly) {window.Plotly=plotly;});}}</script>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "import dash\n",
    "import dash_core_components as dcc\n",
    "import dash_html_components as html\n",
    "import dash_table_experiments as dt\n",
    "from dash.dependencies import Input, Output#, State\n",
    "\n",
    "import plotly.graph_objs as go\n",
    "import plotly.offline as po\n",
    "po.init_notebook_mode(connected=True)\n",
    "\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import os\n",
    "import base64\n",
    "\n",
    "import features\n",
    "from support import appProfiles \n",
    "\n",
    "mapbox_access_token = 'pk.eyJ1Ijoic2FpbnRseXZpIiwiYSI6ImNqZHZpNXkzcjFwejkyeHBkNnp3NTkzYnQifQ.Rj_C-fOaZXZTVhTlliofMA'"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Data Import\n",
    "Requires datasets to be in the /data folder"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Get load profile data from disk\n",
    "profiles = appProfiles(1994,2014)  \n",
    "\n",
    "# Load datasets\n",
    "ids = features.loadID()\n",
    "\n",
    "#a little bit of data wrangling\n",
    "loc_summary = pd.pivot_table(ids, values = ['AnswerID'], index = ['Year','LocName','Lat','Long','Municipality','Province'],aggfunc = np.count_nonzero)\n",
    "loc_summary.reset_index(inplace=True)\n",
    "loc_summary.rename(columns={'AnswerID':'# households'}, inplace=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Survey Locations"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Map View"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "def create_map(ids_df):\n",
    " \n",
    "    georef = pd.pivot_table(ids_df, values = ['AnswerID'], index = ['Year','LocName','Lat','Long','Municipality','Province'],aggfunc = np.count_nonzero)\n",
    "    georef.reset_index(inplace=True)\n",
    "    georef.rename(columns={'AnswerID':'# households'}, inplace=True)\n",
    "                           \n",
    "    traces = []\n",
    "    for y in range(georef.Year.min(), georef.Year.max()+1):\n",
    "        lat = georef.loc[(georef.Year==y), 'Lat']\n",
    "        lon = georef.loc[(georef.Year==y), 'Long']\n",
    "        text = georef.loc[(georef.Year==y), '# households'].astype(str) + ' household surveys</br>'+ georef.loc[(georef.Year==y), 'LocName'] + ', ' + georef.loc[(georef.Year==y), 'Municipality']\n",
    "        marker_size = georef.loc[georef.Year==y,'# households']**(1/2.5)*2.7\n",
    "        marker_size.replace([0,1,2,3,4, 5], 6, inplace=True)\n",
    "        trace=go.Scattermapbox(\n",
    "                name=y,\n",
    "                lat=lat,\n",
    "                lon=lon,\n",
    "                mode='markers',\n",
    "                marker=go.Marker(\n",
    "                    size=marker_size\n",
    "                ),\n",
    "                text=text,\n",
    "            )\n",
    "        traces.append(trace)\n",
    "    figure=go.Figure(\n",
    "        data=go.Data(traces),\n",
    "        layout = go.Layout(\n",
    "                autosize=True,\n",
    "                hovermode='closest',\n",
    "                mapbox=dict(\n",
    "                    accesstoken=mapbox_access_token,\n",
    "                    bearing=0,\n",
    "                    center=dict(\n",
    "                        lat=-29.1,\n",
    "                        lon=25\n",
    "                    ),\n",
    "                    pitch=0,\n",
    "                    zoom=4.32,\n",
    "                    style='light'\n",
    "                ),\n",
    "                margin = go.Margin(\n",
    "                        l = 10,\n",
    "                        r = 10,\n",
    "                        t = 20,\n",
    "                        b = 30\n",
    "                ),\n",
    "                showlegend=True\n",
    "            )\n",
    "    )\n",
    "    return po.iplot( figure)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.plotly.v1+json": {
       "data": [
        {
         "lat": [
          -33.9
         ],
         "lon": [
          18.85
         ],
         "marker": {
          "size": [
           12.910758747165502
          ]
         },
         "mode": "markers",
         "name": 1994,
         "text": [
          "50 household surveys</br>Cloetesville, Stellenbosch"
         ],
         "type": "scattermapbox"
        },
        {
         "lat": [
          -33.88,
          -29.97
         ],
         "lon": [
          25.58,
          30.86
         ],
         "marker": {
          "size": [
           14.427176282530075,
           11.065099688948147
          ]
         },
         "mode": "markers",
         "name": 1995,
         "text": [
          "66 household surveys</br>Kwazakhele, Nelson Mandela Bay",
          "34 household surveys</br>Umlazi AA, eThekwini"
         ],
         "type": "scattermapbox"
        },
        {
         "lat": [
          -26.18,
          -29.16,
          -29.6
         ],
         "lon": [
          27.95,
          27.46,
          30.29
         ],
         "marker": {
          "size": [
           14.685995826529712,
           13.794455700089644,
           14.938148166003993
          ]
         },
         "mode": "markers",
         "name": 1996,
         "text": [
          "69 household surveys</br>Claremont, City of Johannesburg",
          "59 household surveys</br>Manyatseng, Mantsopa",
          "72 household surveys</br>Sweetwaters, The Msunduzi"
         ],
         "type": "scattermapbox"
        },
        {
         "lat": [
          -26.18,
          -34.11,
          -24.92,
          -29.16,
          -29.6,
          -32.13,
          -29.95,
          -29.97,
          -33.99
         ],
         "lon": [
          27.95,
          18.84,
          29.04,
          27.46,
          30.29,
          26.81,
          30.84,
          30.86,
          25.59
         ],
         "marker": {
          "size": [
           15.020794626086364,
           12.487252595496072,
           6,
           15.184072527418282,
           14.854810078735389,
           6,
           6,
           6,
           14.854810078735389
          ]
         },
         "mode": "markers",
         "name": 1997,
         "text": [
          "73 household surveys</br>Claremont, City of Johannesburg",
          "46 household surveys</br>Helderberg, City of Cape Town",
          "0 household surveys</br>Makipsvlei, Ephraim Mogale",
          "75 household surveys</br>Manyatseng, Mantsopa",
          "71 household surveys</br>Sweetwaters, The Msunduzi",
          "0 household surveys</br>Tambo, Enoch Mgijima",
          "0 household surveys</br>Umgaga, eThekwini",
          "0 household surveys</br>Umlazi AA, eThekwini",
          "71 household surveys</br>Walmer Dunes, Nelson Mandela Bay"
         ],
         "type": "scattermapbox"
        },
        {
         "lat": [
          -26.18,
          -34.11,
          -25.994387,
          -29.99,
          -24.16,
          -24.92,
          -30,
          -34.05,
          -32.13,
          -29.95,
          -29.97,
          -33.99
         ],
         "lon": [
          27.95,
          18.84,
          28.197012,
          30.91,
          30.1,
          29.04,
          30.91,
          18.63,
          26.81,
          30.84,
          30.86,
          25.59
         ],
         "marker": {
          "size": [
           15.344758374622844,
           13.887506151238615,
           6,
           14.07085345442472,
           6,
           6,
           16.82954822505986,
           14.770764711240766,
           6,
           12.595137335239937,
           14.339338164003273,
           14.685995826529712
          ]
         },
         "mode": "markers",
         "name": 1998,
         "text": [
          "77 household surveys</br>Claremont, City of Johannesburg",
          "60 household surveys</br>Helderberg, City of Cape Town",
          "0 household surveys</br>Ivory Park, City of Johannesburg",
          "62 household surveys</br>Lotus Park, eThekwini",
          "0 household surveys</br>Mafefe, Lepele-Nkumpi",
          "0 household surveys</br>Makipsvlei, Ephraim Mogale",
          "97 household surveys</br>Orient Hills, eThekwini",
          "70 household surveys</br>Tafelsig, City of Cape Town",
          "0 household surveys</br>Tambo, Enoch Mgijima",
          "47 household surveys</br>Umgaga, eThekwini",
          "65 household surveys</br>Umlazi AA, eThekwini",
          "69 household surveys</br>Walmer Dunes, Nelson Mandela Bay"
         ],
         "type": "scattermapbox"
        },
        {
         "lat": [
          -30.09,
          -24.56,
          -27.11,
          -34.11,
          -25.994387,
          -29.99,
          -24.16,
          -24.92,
          -30,
          -31.19,
          -33.96,
          -26.1,
          -34,
          -34.05,
          -32.13,
          -29.97
         ],
         "lon": [
          29.81,
          30.16,
          23.05,
          18.84,
          28.197012,
          30.91,
          30.1,
          29.04,
          30.91,
          28.87,
          18.38,
          27.91,
          25.65,
          18.63,
          26.81,
          30.86
         ],
         "marker": {
          "size": [
           6,
           6,
           6,
           13.605474930389867,
           6,
           13.21521131449353,
           6,
           6,
           14.770764711240766,
           6,
           12.04102561621379,
           11.194146386427404,
           13.31438981908953,
           14.339338164003273,
           6,
           14.514219452043303
          ]
         },
         "mode": "markers",
         "name": 1999,
         "text": [
          "0 household surveys</br>Antioch, Umzimkhulu",
          "0 household surveys</br>Garagapola, Greater Tubatse/Fetakgomo",
          "0 household surveys</br>Gasese, Joe Morolong",
          "57 household surveys</br>Helderberg, City of Cape Town",
          "0 household surveys</br>Ivory Park, City of Johannesburg",
          "53 household surveys</br>Lotus Park, eThekwini",
          "0 household surveys</br>Mafefe, Lepele-Nkumpi",
          "0 household surveys</br>Makipsvlei, Ephraim Mogale",
          "70 household surveys</br>Orient Hills, eThekwini",
          "0 household surveys</br>Qumbu, Mhlontlo",
          "42 household surveys</br>Rontree Estate, City of Cape Town",
          "35 household surveys</br>Sanctuary Gardens, City of Johannesburg",
          "54 household surveys</br>Summerstrand, Nelson Mandela Bay",
          "65 household surveys</br>Tafelsig, City of Cape Town",
          "0 household surveys</br>Tambo, Enoch Mgijima",
          "67 household surveys</br>Umlazi AA, eThekwini"
         ],
         "type": "scattermapbox"
        },
        {
         "lat": [
          -30.09,
          -24.56,
          -27.11,
          -34.11,
          -29.99,
          -24.16,
          -24.92,
          -30,
          -31.19,
          -33.96,
          -26.1,
          -34,
          -34.05,
          -32.13,
          -29.91
         ],
         "lon": [
          29.81,
          30.16,
          23.05,
          18.84,
          30.91,
          30.1,
          29.04,
          30.91,
          28.87,
          18.38,
          27.91,
          25.65,
          18.63,
          26.81,
          30.94
         ],
         "marker": {
          "size": [
           14.854810078735389,
           14.07085345442472,
           14.427176282530075,
           12.487252595496072,
           13.979630679476134,
           14.854810078735389,
           14.514219452043303,
           15.735817319149103,
           11.568504045912809,
           13.013431626316205,
           13.605474930389867,
           13.605474930389867,
           13.41247235883031,
           13.979630679476134,
           13.794455700089644
          ]
         },
         "mode": "markers",
         "name": 2000,
         "text": [
          "71 household surveys</br>Antioch, Umzimkhulu",
          "62 household surveys</br>Garagapola, Greater Tubatse/Fetakgomo",
          "66 household surveys</br>Gasese, Joe Morolong",
          "46 household surveys</br>Helderberg, City of Cape Town",
          "61 household surveys</br>Lotus Park, eThekwini",
          "71 household surveys</br>Mafefe, Lepele-Nkumpi",
          "67 household surveys</br>Makipsvlei, Ephraim Mogale",
          "82 household surveys</br>Orient Hills, eThekwini",
          "38 household surveys</br>Qumbu, Mhlontlo",
          "51 household surveys</br>Rontree Estate, City of Cape Town",
          "57 household surveys</br>Sanctuary Gardens, City of Johannesburg",
          "57 household surveys</br>Summerstrand, Nelson Mandela Bay",
          "55 household surveys</br>Tafelsig, City of Cape Town",
          "61 household surveys</br>Tambo, Enoch Mgijima",
          "59 household surveys</br>Woodhaven, eThekwini"
         ],
         "type": "scattermapbox"
        },
        {
         "lat": [
          -30.09,
          -24.56,
          -27.11,
          -33.99,
          -33.95,
          -24.16,
          -30.55,
          -25.82,
          -32.13,
          -33.87,
          -34.04,
          -29.91
         ],
         "lon": [
          29.81,
          30.16,
          23.05,
          18.53,
          25.49,
          30.1,
          30.55,
          28.29,
          26.81,
          18.6,
          18.59,
          30.94
         ],
         "marker": {
          "size": [
           15.812298386236543,
           13.605474930389867,
           13.31438981908953,
           13.700454085733535,
           12.910758747165502,
           14.685995826529712,
           13.700454085733535,
           12.910758747165502,
           14.161197636911268,
           14.339338164003273,
           13.794455700089644,
           13.013431626316205
          ]
         },
         "mode": "markers",
         "name": 2001,
         "text": [
          "83 household surveys</br>Antioch, Umzimkhulu",
          "57 household surveys</br>Garagapola, Greater Tubatse/Fetakgomo",
          "54 household surveys</br>Gasese, Joe Morolong",
          "58 household surveys</br>Greenturf, City of Cape Town",
          "50 household surveys</br>Kabega, Nelson Mandela Bay",
          "69 household surveys</br>Mafefe, Lepele-Nkumpi",
          "58 household surveys</br>Mfazazane, Ray Nkonyeni",
          "50 household surveys</br>Moreletta Park, City of Tshwane",
          "63 household surveys</br>Tambo, Enoch Mgijima",
          "65 household surveys</br>Welgemoed, City of Cape Town",
          "59 household surveys</br>Westridge, City of Cape Town",
          "51 household surveys</br>Woodhaven, eThekwini"
         ],
         "type": "scattermapbox"
        },
        {
         "lat": [
          -30.09,
          -24.56,
          -27.11,
          -33.99,
          -33.95,
          -29.57,
          -24.16,
          -28.75,
          -30.55,
          -25.82,
          -32.13,
          -33.87,
          -34.04,
          -29.91
         ],
         "lon": [
          29.81,
          30.16,
          23.05,
          18.53,
          25.49,
          30.55,
          30.1,
          31.85,
          30.55,
          28.29,
          26.81,
          18.6,
          18.59,
          30.94
         ],
         "marker": {
          "size": [
           14.938148166003993,
           14.600486573057768,
           14.600486573057768,
           13.887506151238615,
           13.605474930389867,
           6,
           6,
           13.21521131449353,
           13.887506151238615,
           13.509490646560558,
           15.020794626086364,
           14.514219452043303,
           14.427176282530075,
           13.013431626316205
          ]
         },
         "mode": "markers",
         "name": 2002,
         "text": [
          "72 household surveys</br>Antioch, Umzimkhulu",
          "68 household surveys</br>Garagapola, Greater Tubatse/Fetakgomo",
          "68 household surveys</br>Gasese, Joe Morolong",
          "60 household surveys</br>Greenturf, City of Cape Town",
          "57 household surveys</br>Kabega, Nelson Mandela Bay",
          "0 household surveys</br>Maconqo, Mkhambathini",
          "0 household surveys</br>Mafefe, Lepele-Nkumpi",
          "53 household surveys</br>Matshana, uMhlathuze",
          "60 household surveys</br>Mfazazane, Ray Nkonyeni",
          "56 household surveys</br>Moreletta Park, City of Tshwane",
          "73 household surveys</br>Tambo, Enoch Mgijima",
          "67 household surveys</br>Welgemoed, City of Cape Town",
          "66 household surveys</br>Westridge, City of Cape Town",
          "51 household surveys</br>Woodhaven, eThekwini"
         ],
         "type": "scattermapbox"
        },
        {
         "lat": [
          -30.09,
          -24.56,
          -27.11,
          -33.99,
          -28.73,
          -33.95,
          -29.57,
          -28.75,
          -30.55,
          -25.82,
          -32.13,
          -34.04
         ],
         "lon": [
          29.81,
          30.16,
          23.05,
          18.53,
          26.1,
          25.49,
          30.55,
          31.85,
          30.55,
          28.29,
          26.81,
          18.59
         ],
         "marker": {
          "size": [
           14.685995826529712,
           13.979630679476134,
           14.161197636911268,
           13.41247235883031,
           15.344758374622844,
           6,
           12.80684626326909,
           13.979630679476134,
           13.794455700089644,
           13.700454085733535,
           14.854810078735389,
           13.41247235883031
          ]
         },
         "mode": "markers",
         "name": 2003,
         "text": [
          "69 household surveys</br>Antioch, Umzimkhulu",
          "61 household surveys</br>Garagapola, Greater Tubatse/Fetakgomo",
          "63 household surveys</br>Gasese, Joe Morolong",
          "55 household surveys</br>Greenturf, City of Cape Town",
          "77 household surveys</br>Ikgomotseng, Mangaung",
          "0 household surveys</br>Kabega, Nelson Mandela Bay",
          "49 household surveys</br>Maconqo, Mkhambathini",
          "61 household surveys</br>Matshana, uMhlathuze",
          "59 household surveys</br>Mfazazane, Ray Nkonyeni",
          "58 household surveys</br>Moreletta Park, City of Tshwane",
          "71 household surveys</br>Tambo, Enoch Mgijima",
          "55 household surveys</br>Westridge, City of Cape Town"
         ],
         "type": "scattermapbox"
        },
        {
         "lat": [
          -25.44,
          -25.7,
          -33.99,
          -33.95,
          -34.04,
          -28.75,
          -25.33,
          -34.04
         ],
         "lon": [
          25.86,
          31.55,
          18.53,
          25.49,
          18.69,
          31.85,
          28.87,
          18.59
         ],
         "marker": {
          "size": [
           14.250685436347261,
           14.07085345442472,
           12.701653443266478,
           10.238279389054552,
           12.80684626326909,
           13.114903567386017,
           13.013431626316205,
           13.21521131449353
          ]
         },
         "mode": "markers",
         "name": 2004,
         "text": [
          "64 household surveys</br>Dinokana, Ramotshere Moiloa",
          "62 household surveys</br>Driekoppies, Nkomazi",
          "48 household surveys</br>Greenturf, City of Cape Town",
          "28 household surveys</br>Kabega, Nelson Mandela Bay",
          "49 household surveys</br>Khayalitsha, City of Cape Town",
          "52 household surveys</br>Matshana, uMhlathuze",
          "51 household surveys</br>Vlaklaagte, Thembisile",
          "53 household surveys</br>Westridge, City of Cape Town"
         ],
         "type": "scattermapbox"
        },
        {
         "lat": [
          -25.44,
          -25.7,
          -33.99,
          -33.95,
          -34.04,
          -29.748282,
          -28.75,
          -28.44,
          -25.33,
          -34.04,
          -25.814629999999998
         ],
         "lon": [
          25.86,
          31.55,
          18.53,
          25.49,
          18.69,
          31.066504,
          31.85,
          29.74,
          28.87,
          18.59,
          28.315609000000002
         ],
         "marker": {
          "size": [
           14.600486573057768,
           14.600486573057768,
           12.80684626326909,
           13.887506151238615,
           15.184072527418282,
           6,
           13.794455700089644,
           15.424162968036704,
           15.658774563947281,
           12.910758747165502,
           6
          ]
         },
         "mode": "markers",
         "name": 2005,
         "text": [
          "68 household surveys</br>Dinokana, Ramotshere Moiloa",
          "68 household surveys</br>Driekoppies, Nkomazi",
          "49 household surveys</br>Greenturf, City of Cape Town",
          "60 household surveys</br>Kabega, Nelson Mandela Bay",
          "75 household surveys</br>Khayalitsha, City of Cape Town",
          "0 household surveys</br>La Lucia, eThekwini",
          "59 household surveys</br>Matshana, uMhlathuze",
          "78 household surveys</br>Peacetown, Alfred Duma",
          "81 household surveys</br>Vlaklaagte, Thembisile",
          "50 household surveys</br>Westridge, City of Cape Town",
          "0 household surveys</br>Woodhill, City of Tshwane"
         ],
         "type": "scattermapbox"
        },
        {
         "lat": [
          -25.44,
          -33.99,
          -33.95,
          -34.04,
          -29.748282,
          -28.75,
          -28.44,
          -25.33,
          -34.04,
          -25.814629999999998
         ],
         "lon": [
          25.86,
          18.53,
          25.49,
          18.69,
          31.066504,
          31.85,
          29.74,
          28.87,
          18.59,
          28.315609000000002
         ],
         "marker": {
          "size": [
           14.600486573057768,
           6,
           13.887506151238615,
           14.685995826529712,
           7.0456463152529585,
           13.700454085733535,
           15.58115898379791,
           15.344758374622844,
           6,
           15.102764556754302
          ]
         },
         "mode": "markers",
         "name": 2006,
         "text": [
          "68 household surveys</br>Dinokana, Ramotshere Moiloa",
          "0 household surveys</br>Greenturf, City of Cape Town",
          "60 household surveys</br>Kabega, Nelson Mandela Bay",
          "69 household surveys</br>Khayalitsha, City of Cape Town",
          "11 household surveys</br>La Lucia, eThekwini",
          "58 household surveys</br>Matshana, uMhlathuze",
          "80 household surveys</br>Peacetown, Alfred Duma",
          "77 household surveys</br>Vlaklaagte, Thembisile",
          "0 household surveys</br>Westridge, City of Cape Town",
          "74 household surveys</br>Woodhill, City of Tshwane"
         ],
         "type": "scattermapbox"
        },
        {
         "lat": [
          -25.44,
          -34.04,
          -28.75,
          -28.44,
          -25.33,
          -25.814629999999998
         ],
         "lon": [
          25.86,
          18.69,
          31.85,
          29.74,
          28.87,
          28.315609000000002
         ],
         "marker": {
          "size": [
           6,
           6,
           6,
           6,
           6,
           6
          ]
         },
         "mode": "markers",
         "name": 2007,
         "text": [
          "0 household surveys</br>Dinokana, Ramotshere Moiloa",
          "0 household surveys</br>Khayalitsha, City of Cape Town",
          "0 household surveys</br>Matshana, uMhlathuze",
          "0 household surveys</br>Peacetown, Alfred Duma",
          "0 household surveys</br>Vlaklaagte, Thembisile",
          "0 household surveys</br>Woodhill, City of Tshwane"
         ],
         "type": "scattermapbox"
        },
        {
         "lat": [
          -25.44,
          -34.04,
          -28.75,
          -28.44,
          -25.33,
          -25.814629999999998
         ],
         "lon": [
          25.86,
          18.69,
          31.85,
          29.74,
          28.87,
          28.315609000000002
         ],
         "marker": {
          "size": [
           13.013431626316205,
           12.595137335239937,
           12.910758747165502,
           14.07085345442472,
           15.020794626086364,
           14.938148166003993
          ]
         },
         "mode": "markers",
         "name": 2008,
         "text": [
          "51 household surveys</br>Dinokana, Ramotshere Moiloa",
          "47 household surveys</br>Khayalitsha, City of Cape Town",
          "50 household surveys</br>Matshana, uMhlathuze",
          "62 household surveys</br>Peacetown, Alfred Duma",
          "73 household surveys</br>Vlaklaagte, Thembisile",
          "72 household surveys</br>Woodhill, City of Tshwane"
         ],
         "type": "scattermapbox"
        },
        {
         "lat": [
          -25.44,
          -24.416673,
          -34.04,
          -28.75,
          -28.44,
          -25.33,
          -26.221097999999998,
          -25.814629999999998
         ],
         "lon": [
          25.86,
          29.783334999999997,
          18.69,
          31.85,
          29.74,
          28.87,
          28.30327,
          28.315609000000002
         ],
         "marker": {
          "size": [
           12.910758747165502,
           6,
           12.595137335239937,
           13.114903567386017,
           15.184072527418282,
           15.264732604390185,
           6,
           15.184072527418282
          ]
         },
         "mode": "markers",
         "name": 2009,
         "text": [
          "50 household surveys</br>Dinokana, Ramotshere Moiloa",
          "0 household surveys</br>Ga-Nkoane, Greater Tubatse/Fetakgomo",
          "47 household surveys</br>Khayalitsha, City of Cape Town",
          "52 household surveys</br>Matshana, uMhlathuze",
          "75 household surveys</br>Peacetown, Alfred Duma",
          "76 household surveys</br>Vlaklaagte, Thembisile",
          "0 household surveys</br>Wattville, Ekurhuleni",
          "75 household surveys</br>Woodhill, City of Tshwane"
         ],
         "type": "scattermapbox"
        },
        {
         "lat": [
          -25.507355,
          -24.416673,
          -33.824081,
          -28.75,
          -25.33,
          -26.221097999999998
         ],
         "lon": [
          27.190904999999997,
          29.783334999999997,
          24.871931,
          31.85,
          28.87,
          28.30327
         ],
         "marker": {
          "size": [
           6,
           21.694227994916414,
           6,
           18.862517177350654,
           23.05237127203879,
           21.309780859084647
          ]
         },
         "mode": "markers",
         "name": 2010,
         "text": [
          "0 household surveys</br>Ga-Luka, Rustenburg",
          "183 household surveys</br>Ga-Nkoane, Greater Tubatse/Fetakgomo",
          "0 household surveys</br>Hankey, Kouga",
          "129 household surveys</br>Matshana, uMhlathuze",
          "213 household surveys</br>Vlaklaagte, Thembisile",
          "175 household surveys</br>Wattville, Ekurhuleni"
         ],
         "type": "scattermapbox"
        },
        {
         "lat": [
          -25.507355,
          -24.416673,
          -33.824081,
          -28.75,
          -25.33,
          -26.221097999999998
         ],
         "lon": [
          27.190904999999997,
          29.783334999999997,
          24.871931,
          31.85,
          28.87,
          28.30327
         ],
         "marker": {
          "size": [
           21.551264953521976,
           20.352305053374753,
           21.551264953521976,
           18.862517177350654,
           23.437158331284934,
           21.113596051741904
          ]
         },
         "mode": "markers",
         "name": 2011,
         "text": [
          "180 household surveys</br>Ga-Luka, Rustenburg",
          "156 household surveys</br>Ga-Nkoane, Greater Tubatse/Fetakgomo",
          "180 household surveys</br>Hankey, Kouga",
          "129 household surveys</br>Matshana, uMhlathuze",
          "222 household surveys</br>Vlaklaagte, Thembisile",
          "171 household surveys</br>Wattville, Ekurhuleni"
         ],
         "type": "scattermapbox"
        },
        {
         "lat": [
          -32.31762239,
          -25.507355,
          -24.416673,
          -33.824081,
          -28.75,
          -25.51232515,
          -29.19967496,
          -25.33,
          -26.221097999999998
         ],
         "lon": [
          28.20553465,
          27.190904999999997,
          29.783334999999997,
          24.871931,
          31.85,
          31.34582484,
          26.80923109,
          28.87,
          28.30327
         ],
         "marker": {
          "size": [
           20.19483627074896,
           20.96464326571595,
           21.26098903357619,
           20.352305053374753,
           19.71100467733987,
           19.545708126548192,
           23.05237127203879,
           22.11486311965557,
           21.113596051741904
          ]
         },
         "mode": "markers",
         "name": 2012,
         "text": [
          "153 household surveys</br>Butterworth, Mnquma",
          "168 household surveys</br>Ga-Luka, Rustenburg",
          "174 household surveys</br>Ga-Nkoane, Greater Tubatse/Fetakgomo",
          "156 household surveys</br>Hankey, Kouga",
          "144 household surveys</br>Matshana, uMhlathuze",
          "141 household surveys</br>Matsulu, Mbombela",
          "213 household surveys</br>Seloshesa, Mangaung",
          "192 household surveys</br>Vlaklaagte, Thembisile",
          "171 household surveys</br>Wattville, Ekurhuleni"
         ],
         "type": "scattermapbox"
        },
        {
         "lat": [
          -26.69245893,
          -32.31762239,
          -29.51060165,
          -25.507355,
          -24.416673,
          -33.824081,
          -28.75,
          -25.51232515,
          -28.01601881,
          -29.19967496,
          -25.33,
          -26.221097999999998
         ],
         "lon": [
          27.79967542,
          28.20553465,
          27.14995751,
          27.190904999999997,
          29.783334999999997,
          24.871931,
          31.85,
          31.34582484,
          27.08179789,
          26.80923109,
          28.87,
          28.30327
         ],
         "marker": {
          "size": [
           6,
           6,
           6,
           6,
           6,
           6,
           6,
           6,
           6,
           6,
           6,
           6
          ]
         },
         "mode": "markers",
         "name": 2013,
         "text": [
          "0 household surveys</br>Bophelong, Emfuleni",
          "0 household surveys</br>Butterworth, Mnquma",
          "0 household surveys</br>Dipelaneng, Mantsopa",
          "0 household surveys</br>Ga-Luka, Rustenburg",
          "0 household surveys</br>Ga-Nkoane, Greater Tubatse/Fetakgomo",
          "0 household surveys</br>Hankey, Kouga",
          "0 household surveys</br>Matshana, uMhlathuze",
          "0 household surveys</br>Matsulu, Mbombela",
          "0 household surveys</br>Phomolong, Matjhabeng",
          "0 household surveys</br>Seloshesa, Mangaung",
          "0 household surveys</br>Vlaklaagte, Thembisile",
          "0 household surveys</br>Wattville, Ekurhuleni"
         ],
         "type": "scattermapbox"
        },
        {
         "lat": [
          -26.69245893,
          -32.31762239,
          -29.51060165,
          -25.507355,
          -24.416673,
          -33.824081,
          -28.75,
          -25.51232515,
          -28.01601881,
          -29.19967496,
          -25.33,
          -26.221097999999998
         ],
         "lon": [
          27.79967542,
          28.20553465,
          27.14995751,
          27.190904999999997,
          29.783334999999997,
          24.871931,
          31.85,
          31.34582484,
          27.08179789,
          26.80923109,
          28.87,
          28.30327
         ],
         "marker": {
          "size": [
           6,
           6,
           6,
           6,
           6,
           6,
           6,
           6,
           6,
           6,
           6,
           6
          ]
         },
         "mode": "markers",
         "name": 2014,
         "text": [
          "0 household surveys</br>Bophelong, Emfuleni",
          "0 household surveys</br>Butterworth, Mnquma",
          "0 household surveys</br>Dipelaneng, Mantsopa",
          "0 household surveys</br>Ga-Luka, Rustenburg",
          "0 household surveys</br>Ga-Nkoane, Greater Tubatse/Fetakgomo",
          "0 household surveys</br>Hankey, Kouga",
          "0 household surveys</br>Matshana, uMhlathuze",
          "0 household surveys</br>Matsulu, Mbombela",
          "0 household surveys</br>Phomolong, Matjhabeng",
          "0 household surveys</br>Seloshesa, Mangaung",
          "0 household surveys</br>Vlaklaagte, Thembisile",
          "0 household surveys</br>Wattville, Ekurhuleni"
         ],
         "type": "scattermapbox"
        }
       ],
       "layout": {
        "autosize": true,
        "hovermode": "closest",
        "mapbox": {
         "accesstoken": "pk.eyJ1Ijoic2FpbnRseXZpIiwiYSI6ImNqZHZpNXkzcjFwejkyeHBkNnp3NTkzYnQifQ.Rj_C-fOaZXZTVhTlliofMA",
         "bearing": 0,
         "center": {
          "lat": -29.1,
          "lon": 25
         },
         "pitch": 0,
         "style": "light",
         "zoom": 4.32
        },
        "margin": {
         "b": 30,
         "l": 10,
         "r": 10,
         "t": 20
        },
        "showlegend": true
       }
      },
      "text/html": [
       "<div id=\"703b1437-18f5-4c45-a094-91fa863652c7\" style=\"height: 525px; width: 100%;\" class=\"plotly-graph-div\"></div><script type=\"text/javascript\">require([\"plotly\"], function(Plotly) { window.PLOTLYENV=window.PLOTLYENV || {};window.PLOTLYENV.BASE_URL=\"https://plot.ly\";Plotly.newPlot(\"703b1437-18f5-4c45-a094-91fa863652c7\", [{\"type\": \"scattermapbox\", \"name\": 1994, \"lat\": [-33.9], \"lon\": [18.85], \"mode\": \"markers\", \"marker\": {\"size\": [12.910758747165502]}, \"text\": [\"50 household surveys</br>Cloetesville, Stellenbosch\"]}, {\"type\": \"scattermapbox\", \"name\": 1995, \"lat\": [-33.88, -29.97], \"lon\": [25.58, 30.86], \"mode\": \"markers\", \"marker\": {\"size\": [14.427176282530075, 11.065099688948147]}, \"text\": [\"66 household surveys</br>Kwazakhele, Nelson Mandela Bay\", \"34 household surveys</br>Umlazi AA, eThekwini\"]}, {\"type\": \"scattermapbox\", \"name\": 1996, \"lat\": [-26.18, -29.16, -29.6], \"lon\": [27.95, 27.46, 30.29], \"mode\": \"markers\", \"marker\": {\"size\": [14.685995826529712, 13.794455700089644, 14.938148166003993]}, \"text\": [\"69 household surveys</br>Claremont, City of Johannesburg\", \"59 household surveys</br>Manyatseng, Mantsopa\", \"72 household surveys</br>Sweetwaters, The Msunduzi\"]}, {\"type\": \"scattermapbox\", \"name\": 1997, \"lat\": [-26.18, -34.11, -24.92, -29.16, -29.6, -32.13, -29.95, -29.97, -33.99], \"lon\": [27.95, 18.84, 29.04, 27.46, 30.29, 26.81, 30.84, 30.86, 25.59], \"mode\": \"markers\", \"marker\": {\"size\": [15.020794626086364, 12.487252595496072, 6.0, 15.184072527418282, 14.854810078735389, 6.0, 6.0, 6.0, 14.854810078735389]}, \"text\": [\"73 household surveys</br>Claremont, City of Johannesburg\", \"46 household surveys</br>Helderberg, City of Cape Town\", \"0 household surveys</br>Makipsvlei, Ephraim Mogale\", \"75 household surveys</br>Manyatseng, Mantsopa\", \"71 household surveys</br>Sweetwaters, The Msunduzi\", \"0 household surveys</br>Tambo, Enoch Mgijima\", \"0 household surveys</br>Umgaga, eThekwini\", \"0 household surveys</br>Umlazi AA, eThekwini\", \"71 household surveys</br>Walmer Dunes, Nelson Mandela Bay\"]}, {\"type\": \"scattermapbox\", \"name\": 1998, \"lat\": [-26.18, -34.11, -25.994387, -29.99, -24.16, -24.92, -30.0, -34.05, -32.13, -29.95, -29.97, -33.99], \"lon\": [27.95, 18.84, 28.197012, 30.91, 30.1, 29.04, 30.91, 18.63, 26.81, 30.84, 30.86, 25.59], \"mode\": \"markers\", \"marker\": {\"size\": [15.344758374622844, 13.887506151238615, 6.0, 14.07085345442472, 6.0, 6.0, 16.82954822505986, 14.770764711240766, 6.0, 12.595137335239937, 14.339338164003273, 14.685995826529712]}, \"text\": [\"77 household surveys</br>Claremont, City of Johannesburg\", \"60 household surveys</br>Helderberg, City of Cape Town\", \"0 household surveys</br>Ivory Park, City of Johannesburg\", \"62 household surveys</br>Lotus Park, eThekwini\", \"0 household surveys</br>Mafefe, Lepele-Nkumpi\", \"0 household surveys</br>Makipsvlei, Ephraim Mogale\", \"97 household surveys</br>Orient Hills, eThekwini\", \"70 household surveys</br>Tafelsig, City of Cape Town\", \"0 household surveys</br>Tambo, Enoch Mgijima\", \"47 household surveys</br>Umgaga, eThekwini\", \"65 household surveys</br>Umlazi AA, eThekwini\", \"69 household surveys</br>Walmer Dunes, Nelson Mandela Bay\"]}, {\"type\": \"scattermapbox\", \"name\": 1999, \"lat\": [-30.09, -24.56, -27.11, -34.11, -25.994387, -29.99, -24.16, -24.92, -30.0, -31.19, -33.96, -26.1, -34.0, -34.05, -32.13, -29.97], \"lon\": [29.81, 30.16, 23.05, 18.84, 28.197012, 30.91, 30.1, 29.04, 30.91, 28.87, 18.38, 27.91, 25.65, 18.63, 26.81, 30.86], \"mode\": \"markers\", \"marker\": {\"size\": [6.0, 6.0, 6.0, 13.605474930389867, 6.0, 13.21521131449353, 6.0, 6.0, 14.770764711240766, 6.0, 12.04102561621379, 11.194146386427404, 13.31438981908953, 14.339338164003273, 6.0, 14.514219452043303]}, \"text\": [\"0 household surveys</br>Antioch, Umzimkhulu\", \"0 household surveys</br>Garagapola, Greater Tubatse/Fetakgomo\", \"0 household surveys</br>Gasese, Joe Morolong\", \"57 household surveys</br>Helderberg, City of Cape Town\", \"0 household surveys</br>Ivory Park, City of Johannesburg\", \"53 household surveys</br>Lotus Park, eThekwini\", \"0 household surveys</br>Mafefe, Lepele-Nkumpi\", \"0 household surveys</br>Makipsvlei, Ephraim Mogale\", \"70 household surveys</br>Orient Hills, eThekwini\", \"0 household surveys</br>Qumbu, Mhlontlo\", \"42 household surveys</br>Rontree Estate, City of Cape Town\", \"35 household surveys</br>Sanctuary Gardens, City of Johannesburg\", \"54 household surveys</br>Summerstrand, Nelson Mandela Bay\", \"65 household surveys</br>Tafelsig, City of Cape Town\", \"0 household surveys</br>Tambo, Enoch Mgijima\", \"67 household surveys</br>Umlazi AA, eThekwini\"]}, {\"type\": \"scattermapbox\", \"name\": 2000, \"lat\": [-30.09, -24.56, -27.11, -34.11, -29.99, -24.16, -24.92, -30.0, -31.19, -33.96, -26.1, -34.0, -34.05, -32.13, -29.91], \"lon\": [29.81, 30.16, 23.05, 18.84, 30.91, 30.1, 29.04, 30.91, 28.87, 18.38, 27.91, 25.65, 18.63, 26.81, 30.94], \"mode\": \"markers\", \"marker\": {\"size\": [14.854810078735389, 14.07085345442472, 14.427176282530075, 12.487252595496072, 13.979630679476134, 14.854810078735389, 14.514219452043303, 15.735817319149103, 11.568504045912809, 13.013431626316205, 13.605474930389867, 13.605474930389867, 13.41247235883031, 13.979630679476134, 13.794455700089644]}, \"text\": [\"71 household surveys</br>Antioch, Umzimkhulu\", \"62 household surveys</br>Garagapola, Greater Tubatse/Fetakgomo\", \"66 household surveys</br>Gasese, Joe Morolong\", \"46 household surveys</br>Helderberg, City of Cape Town\", \"61 household surveys</br>Lotus Park, eThekwini\", \"71 household surveys</br>Mafefe, Lepele-Nkumpi\", \"67 household surveys</br>Makipsvlei, Ephraim Mogale\", \"82 household surveys</br>Orient Hills, eThekwini\", \"38 household surveys</br>Qumbu, Mhlontlo\", \"51 household surveys</br>Rontree Estate, City of Cape Town\", \"57 household surveys</br>Sanctuary Gardens, City of Johannesburg\", \"57 household surveys</br>Summerstrand, Nelson Mandela Bay\", \"55 household surveys</br>Tafelsig, City of Cape Town\", \"61 household surveys</br>Tambo, Enoch Mgijima\", \"59 household surveys</br>Woodhaven, eThekwini\"]}, {\"type\": \"scattermapbox\", \"name\": 2001, \"lat\": [-30.09, -24.56, -27.11, -33.99, -33.95, -24.16, -30.55, -25.82, -32.13, -33.87, -34.04, -29.91], \"lon\": [29.81, 30.16, 23.05, 18.53, 25.49, 30.1, 30.55, 28.29, 26.81, 18.6, 18.59, 30.94], \"mode\": \"markers\", \"marker\": {\"size\": [15.812298386236543, 13.605474930389867, 13.31438981908953, 13.700454085733535, 12.910758747165502, 14.685995826529712, 13.700454085733535, 12.910758747165502, 14.161197636911268, 14.339338164003273, 13.794455700089644, 13.013431626316205]}, \"text\": [\"83 household surveys</br>Antioch, Umzimkhulu\", \"57 household surveys</br>Garagapola, Greater Tubatse/Fetakgomo\", \"54 household surveys</br>Gasese, Joe Morolong\", \"58 household surveys</br>Greenturf, City of Cape Town\", \"50 household surveys</br>Kabega, Nelson Mandela Bay\", \"69 household surveys</br>Mafefe, Lepele-Nkumpi\", \"58 household surveys</br>Mfazazane, Ray Nkonyeni\", \"50 household surveys</br>Moreletta Park, City of Tshwane\", \"63 household surveys</br>Tambo, Enoch Mgijima\", \"65 household surveys</br>Welgemoed, City of Cape Town\", \"59 household surveys</br>Westridge, City of Cape Town\", \"51 household surveys</br>Woodhaven, eThekwini\"]}, {\"type\": \"scattermapbox\", \"name\": 2002, \"lat\": [-30.09, -24.56, -27.11, -33.99, -33.95, -29.57, -24.16, -28.75, -30.55, -25.82, -32.13, -33.87, -34.04, -29.91], \"lon\": [29.81, 30.16, 23.05, 18.53, 25.49, 30.55, 30.1, 31.85, 30.55, 28.29, 26.81, 18.6, 18.59, 30.94], \"mode\": \"markers\", \"marker\": {\"size\": [14.938148166003993, 14.600486573057768, 14.600486573057768, 13.887506151238615, 13.605474930389867, 6.0, 6.0, 13.21521131449353, 13.887506151238615, 13.509490646560558, 15.020794626086364, 14.514219452043303, 14.427176282530075, 13.013431626316205]}, \"text\": [\"72 household surveys</br>Antioch, Umzimkhulu\", \"68 household surveys</br>Garagapola, Greater Tubatse/Fetakgomo\", \"68 household surveys</br>Gasese, Joe Morolong\", \"60 household surveys</br>Greenturf, City of Cape Town\", \"57 household surveys</br>Kabega, Nelson Mandela Bay\", \"0 household surveys</br>Maconqo, Mkhambathini\", \"0 household surveys</br>Mafefe, Lepele-Nkumpi\", \"53 household surveys</br>Matshana, uMhlathuze\", \"60 household surveys</br>Mfazazane, Ray Nkonyeni\", \"56 household surveys</br>Moreletta Park, City of Tshwane\", \"73 household surveys</br>Tambo, Enoch Mgijima\", \"67 household surveys</br>Welgemoed, City of Cape Town\", \"66 household surveys</br>Westridge, City of Cape Town\", \"51 household surveys</br>Woodhaven, eThekwini\"]}, {\"type\": \"scattermapbox\", \"name\": 2003, \"lat\": [-30.09, -24.56, -27.11, -33.99, -28.73, -33.95, -29.57, -28.75, -30.55, -25.82, -32.13, -34.04], \"lon\": [29.81, 30.16, 23.05, 18.53, 26.1, 25.49, 30.55, 31.85, 30.55, 28.29, 26.81, 18.59], \"mode\": \"markers\", \"marker\": {\"size\": [14.685995826529712, 13.979630679476134, 14.161197636911268, 13.41247235883031, 15.344758374622844, 6.0, 12.80684626326909, 13.979630679476134, 13.794455700089644, 13.700454085733535, 14.854810078735389, 13.41247235883031]}, \"text\": [\"69 household surveys</br>Antioch, Umzimkhulu\", \"61 household surveys</br>Garagapola, Greater Tubatse/Fetakgomo\", \"63 household surveys</br>Gasese, Joe Morolong\", \"55 household surveys</br>Greenturf, City of Cape Town\", \"77 household surveys</br>Ikgomotseng, Mangaung\", \"0 household surveys</br>Kabega, Nelson Mandela Bay\", \"49 household surveys</br>Maconqo, Mkhambathini\", \"61 household surveys</br>Matshana, uMhlathuze\", \"59 household surveys</br>Mfazazane, Ray Nkonyeni\", \"58 household surveys</br>Moreletta Park, City of Tshwane\", \"71 household surveys</br>Tambo, Enoch Mgijima\", \"55 household surveys</br>Westridge, City of Cape Town\"]}, {\"type\": \"scattermapbox\", \"name\": 2004, \"lat\": [-25.44, -25.7, -33.99, -33.95, -34.04, -28.75, -25.33, -34.04], \"lon\": [25.86, 31.55, 18.53, 25.49, 18.69, 31.85, 28.87, 18.59], \"mode\": \"markers\", \"marker\": {\"size\": [14.250685436347261, 14.07085345442472, 12.701653443266478, 10.238279389054552, 12.80684626326909, 13.114903567386017, 13.013431626316205, 13.21521131449353]}, \"text\": [\"64 household surveys</br>Dinokana, Ramotshere Moiloa\", \"62 household surveys</br>Driekoppies, Nkomazi\", \"48 household surveys</br>Greenturf, City of Cape Town\", \"28 household surveys</br>Kabega, Nelson Mandela Bay\", \"49 household surveys</br>Khayalitsha, City of Cape Town\", \"52 household surveys</br>Matshana, uMhlathuze\", \"51 household surveys</br>Vlaklaagte, Thembisile\", \"53 household surveys</br>Westridge, City of Cape Town\"]}, {\"type\": \"scattermapbox\", \"name\": 2005, \"lat\": [-25.44, -25.7, -33.99, -33.95, -34.04, -29.748282, -28.75, -28.44, -25.33, -34.04, -25.814629999999998], \"lon\": [25.86, 31.55, 18.53, 25.49, 18.69, 31.066504, 31.85, 29.74, 28.87, 18.59, 28.315609000000002], \"mode\": \"markers\", \"marker\": {\"size\": [14.600486573057768, 14.600486573057768, 12.80684626326909, 13.887506151238615, 15.184072527418282, 6.0, 13.794455700089644, 15.424162968036704, 15.658774563947281, 12.910758747165502, 6.0]}, \"text\": [\"68 household surveys</br>Dinokana, Ramotshere Moiloa\", \"68 household surveys</br>Driekoppies, Nkomazi\", \"49 household surveys</br>Greenturf, City of Cape Town\", \"60 household surveys</br>Kabega, Nelson Mandela Bay\", \"75 household surveys</br>Khayalitsha, City of Cape Town\", \"0 household surveys</br>La Lucia, eThekwini\", \"59 household surveys</br>Matshana, uMhlathuze\", \"78 household surveys</br>Peacetown, Alfred Duma\", \"81 household surveys</br>Vlaklaagte, Thembisile\", \"50 household surveys</br>Westridge, City of Cape Town\", \"0 household surveys</br>Woodhill, City of Tshwane\"]}, {\"type\": \"scattermapbox\", \"name\": 2006, \"lat\": [-25.44, -33.99, -33.95, -34.04, -29.748282, -28.75, -28.44, -25.33, -34.04, -25.814629999999998], \"lon\": [25.86, 18.53, 25.49, 18.69, 31.066504, 31.85, 29.74, 28.87, 18.59, 28.315609000000002], \"mode\": \"markers\", \"marker\": {\"size\": [14.600486573057768, 6.0, 13.887506151238615, 14.685995826529712, 7.0456463152529585, 13.700454085733535, 15.58115898379791, 15.344758374622844, 6.0, 15.102764556754302]}, \"text\": [\"68 household surveys</br>Dinokana, Ramotshere Moiloa\", \"0 household surveys</br>Greenturf, City of Cape Town\", \"60 household surveys</br>Kabega, Nelson Mandela Bay\", \"69 household surveys</br>Khayalitsha, City of Cape Town\", \"11 household surveys</br>La Lucia, eThekwini\", \"58 household surveys</br>Matshana, uMhlathuze\", \"80 household surveys</br>Peacetown, Alfred Duma\", \"77 household surveys</br>Vlaklaagte, Thembisile\", \"0 household surveys</br>Westridge, City of Cape Town\", \"74 household surveys</br>Woodhill, City of Tshwane\"]}, {\"type\": \"scattermapbox\", \"name\": 2007, \"lat\": [-25.44, -34.04, -28.75, -28.44, -25.33, -25.814629999999998], \"lon\": [25.86, 18.69, 31.85, 29.74, 28.87, 28.315609000000002], \"mode\": \"markers\", \"marker\": {\"size\": [6.0, 6.0, 6.0, 6.0, 6.0, 6.0]}, \"text\": [\"0 household surveys</br>Dinokana, Ramotshere Moiloa\", \"0 household surveys</br>Khayalitsha, City of Cape Town\", \"0 household surveys</br>Matshana, uMhlathuze\", \"0 household surveys</br>Peacetown, Alfred Duma\", \"0 household surveys</br>Vlaklaagte, Thembisile\", \"0 household surveys</br>Woodhill, City of Tshwane\"]}, {\"type\": \"scattermapbox\", \"name\": 2008, \"lat\": [-25.44, -34.04, -28.75, -28.44, -25.33, -25.814629999999998], \"lon\": [25.86, 18.69, 31.85, 29.74, 28.87, 28.315609000000002], \"mode\": \"markers\", \"marker\": {\"size\": [13.013431626316205, 12.595137335239937, 12.910758747165502, 14.07085345442472, 15.020794626086364, 14.938148166003993]}, \"text\": [\"51 household surveys</br>Dinokana, Ramotshere Moiloa\", \"47 household surveys</br>Khayalitsha, City of Cape Town\", \"50 household surveys</br>Matshana, uMhlathuze\", \"62 household surveys</br>Peacetown, Alfred Duma\", \"73 household surveys</br>Vlaklaagte, Thembisile\", \"72 household surveys</br>Woodhill, City of Tshwane\"]}, {\"type\": \"scattermapbox\", \"name\": 2009, \"lat\": [-25.44, -24.416673, -34.04, -28.75, -28.44, -25.33, -26.221097999999998, -25.814629999999998], \"lon\": [25.86, 29.783334999999997, 18.69, 31.85, 29.74, 28.87, 28.30327, 28.315609000000002], \"mode\": \"markers\", \"marker\": {\"size\": [12.910758747165502, 6.0, 12.595137335239937, 13.114903567386017, 15.184072527418282, 15.264732604390185, 6.0, 15.184072527418282]}, \"text\": [\"50 household surveys</br>Dinokana, Ramotshere Moiloa\", \"0 household surveys</br>Ga-Nkoane, Greater Tubatse/Fetakgomo\", \"47 household surveys</br>Khayalitsha, City of Cape Town\", \"52 household surveys</br>Matshana, uMhlathuze\", \"75 household surveys</br>Peacetown, Alfred Duma\", \"76 household surveys</br>Vlaklaagte, Thembisile\", \"0 household surveys</br>Wattville, Ekurhuleni\", \"75 household surveys</br>Woodhill, City of Tshwane\"]}, {\"type\": \"scattermapbox\", \"name\": 2010, \"lat\": [-25.507355, -24.416673, -33.824081, -28.75, -25.33, -26.221097999999998], \"lon\": [27.190904999999997, 29.783334999999997, 24.871931, 31.85, 28.87, 28.30327], \"mode\": \"markers\", \"marker\": {\"size\": [6.0, 21.694227994916414, 6.0, 18.862517177350654, 23.05237127203879, 21.309780859084647]}, \"text\": [\"0 household surveys</br>Ga-Luka, Rustenburg\", \"183 household surveys</br>Ga-Nkoane, Greater Tubatse/Fetakgomo\", \"0 household surveys</br>Hankey, Kouga\", \"129 household surveys</br>Matshana, uMhlathuze\", \"213 household surveys</br>Vlaklaagte, Thembisile\", \"175 household surveys</br>Wattville, Ekurhuleni\"]}, {\"type\": \"scattermapbox\", \"name\": 2011, \"lat\": [-25.507355, -24.416673, -33.824081, -28.75, -25.33, -26.221097999999998], \"lon\": [27.190904999999997, 29.783334999999997, 24.871931, 31.85, 28.87, 28.30327], \"mode\": \"markers\", \"marker\": {\"size\": [21.551264953521976, 20.352305053374753, 21.551264953521976, 18.862517177350654, 23.437158331284934, 21.113596051741904]}, \"text\": [\"180 household surveys</br>Ga-Luka, Rustenburg\", \"156 household surveys</br>Ga-Nkoane, Greater Tubatse/Fetakgomo\", \"180 household surveys</br>Hankey, Kouga\", \"129 household surveys</br>Matshana, uMhlathuze\", \"222 household surveys</br>Vlaklaagte, Thembisile\", \"171 household surveys</br>Wattville, Ekurhuleni\"]}, {\"type\": \"scattermapbox\", \"name\": 2012, \"lat\": [-32.31762239, -25.507355, -24.416673, -33.824081, -28.75, -25.51232515, -29.19967496, -25.33, -26.221097999999998], \"lon\": [28.20553465, 27.190904999999997, 29.783334999999997, 24.871931, 31.85, 31.34582484, 26.80923109, 28.87, 28.30327], \"mode\": \"markers\", \"marker\": {\"size\": [20.19483627074896, 20.96464326571595, 21.26098903357619, 20.352305053374753, 19.71100467733987, 19.545708126548192, 23.05237127203879, 22.11486311965557, 21.113596051741904]}, \"text\": [\"153 household surveys</br>Butterworth, Mnquma\", \"168 household surveys</br>Ga-Luka, Rustenburg\", \"174 household surveys</br>Ga-Nkoane, Greater Tubatse/Fetakgomo\", \"156 household surveys</br>Hankey, Kouga\", \"144 household surveys</br>Matshana, uMhlathuze\", \"141 household surveys</br>Matsulu, Mbombela\", \"213 household surveys</br>Seloshesa, Mangaung\", \"192 household surveys</br>Vlaklaagte, Thembisile\", \"171 household surveys</br>Wattville, Ekurhuleni\"]}, {\"type\": \"scattermapbox\", \"name\": 2013, \"lat\": [-26.69245893, -32.31762239, -29.51060165, -25.507355, -24.416673, -33.824081, -28.75, -25.51232515, -28.01601881, -29.19967496, -25.33, -26.221097999999998], \"lon\": [27.79967542, 28.20553465, 27.14995751, 27.190904999999997, 29.783334999999997, 24.871931, 31.85, 31.34582484, 27.08179789, 26.80923109, 28.87, 28.30327], \"mode\": \"markers\", \"marker\": {\"size\": [6.0, 6.0, 6.0, 6.0, 6.0, 6.0, 6.0, 6.0, 6.0, 6.0, 6.0, 6.0]}, \"text\": [\"0 household surveys</br>Bophelong, Emfuleni\", \"0 household surveys</br>Butterworth, Mnquma\", \"0 household surveys</br>Dipelaneng, Mantsopa\", \"0 household surveys</br>Ga-Luka, Rustenburg\", \"0 household surveys</br>Ga-Nkoane, Greater Tubatse/Fetakgomo\", \"0 household surveys</br>Hankey, Kouga\", \"0 household surveys</br>Matshana, uMhlathuze\", \"0 household surveys</br>Matsulu, Mbombela\", \"0 household surveys</br>Phomolong, Matjhabeng\", \"0 household surveys</br>Seloshesa, Mangaung\", \"0 household surveys</br>Vlaklaagte, Thembisile\", \"0 household surveys</br>Wattville, Ekurhuleni\"]}, {\"type\": \"scattermapbox\", \"name\": 2014, \"lat\": [-26.69245893, -32.31762239, -29.51060165, -25.507355, -24.416673, -33.824081, -28.75, -25.51232515, -28.01601881, -29.19967496, -25.33, -26.221097999999998], \"lon\": [27.79967542, 28.20553465, 27.14995751, 27.190904999999997, 29.783334999999997, 24.871931, 31.85, 31.34582484, 27.08179789, 26.80923109, 28.87, 28.30327], \"mode\": \"markers\", \"marker\": {\"size\": [6.0, 6.0, 6.0, 6.0, 6.0, 6.0, 6.0, 6.0, 6.0, 6.0, 6.0, 6.0]}, \"text\": [\"0 household surveys</br>Bophelong, Emfuleni\", \"0 household surveys</br>Butterworth, Mnquma\", \"0 household surveys</br>Dipelaneng, Mantsopa\", \"0 household surveys</br>Ga-Luka, Rustenburg\", \"0 household surveys</br>Ga-Nkoane, Greater Tubatse/Fetakgomo\", \"0 household surveys</br>Hankey, Kouga\", \"0 household surveys</br>Matshana, uMhlathuze\", \"0 household surveys</br>Matsulu, Mbombela\", \"0 household surveys</br>Phomolong, Matjhabeng\", \"0 household surveys</br>Seloshesa, Mangaung\", \"0 household surveys</br>Vlaklaagte, Thembisile\", \"0 household surveys</br>Wattville, Ekurhuleni\"]}], {\"autosize\": true, \"hovermode\": \"closest\", \"mapbox\": {\"accesstoken\": \"pk.eyJ1Ijoic2FpbnRseXZpIiwiYSI6ImNqZHZpNXkzcjFwejkyeHBkNnp3NTkzYnQifQ.Rj_C-fOaZXZTVhTlliofMA\", \"bearing\": 0, \"center\": {\"lat\": -29.1, \"lon\": 25}, \"pitch\": 0, \"zoom\": 4.32, \"style\": \"light\"}, \"margin\": {\"l\": 10, \"r\": 10, \"t\": 20, \"b\": 30}, \"showlegend\": true}, {\"showLink\": true, \"linkText\": \"Export to plot.ly\"})});</script>"
      ],
      "text/vnd.plotly.v1+html": [
       "<div id=\"703b1437-18f5-4c45-a094-91fa863652c7\" style=\"height: 525px; width: 100%;\" class=\"plotly-graph-div\"></div><script type=\"text/javascript\">require([\"plotly\"], function(Plotly) { window.PLOTLYENV=window.PLOTLYENV || {};window.PLOTLYENV.BASE_URL=\"https://plot.ly\";Plotly.newPlot(\"703b1437-18f5-4c45-a094-91fa863652c7\", [{\"type\": \"scattermapbox\", \"name\": 1994, \"lat\": [-33.9], \"lon\": [18.85], \"mode\": \"markers\", \"marker\": {\"size\": [12.910758747165502]}, \"text\": [\"50 household surveys</br>Cloetesville, Stellenbosch\"]}, {\"type\": \"scattermapbox\", \"name\": 1995, \"lat\": [-33.88, -29.97], \"lon\": [25.58, 30.86], \"mode\": \"markers\", \"marker\": {\"size\": [14.427176282530075, 11.065099688948147]}, \"text\": [\"66 household surveys</br>Kwazakhele, Nelson Mandela Bay\", \"34 household surveys</br>Umlazi AA, eThekwini\"]}, {\"type\": \"scattermapbox\", \"name\": 1996, \"lat\": [-26.18, -29.16, -29.6], \"lon\": [27.95, 27.46, 30.29], \"mode\": \"markers\", \"marker\": {\"size\": [14.685995826529712, 13.794455700089644, 14.938148166003993]}, \"text\": [\"69 household surveys</br>Claremont, City of Johannesburg\", \"59 household surveys</br>Manyatseng, Mantsopa\", \"72 household surveys</br>Sweetwaters, The Msunduzi\"]}, {\"type\": \"scattermapbox\", \"name\": 1997, \"lat\": [-26.18, -34.11, -24.92, -29.16, -29.6, -32.13, -29.95, -29.97, -33.99], \"lon\": [27.95, 18.84, 29.04, 27.46, 30.29, 26.81, 30.84, 30.86, 25.59], \"mode\": \"markers\", \"marker\": {\"size\": [15.020794626086364, 12.487252595496072, 6.0, 15.184072527418282, 14.854810078735389, 6.0, 6.0, 6.0, 14.854810078735389]}, \"text\": [\"73 household surveys</br>Claremont, City of Johannesburg\", \"46 household surveys</br>Helderberg, City of Cape Town\", \"0 household surveys</br>Makipsvlei, Ephraim Mogale\", \"75 household surveys</br>Manyatseng, Mantsopa\", \"71 household surveys</br>Sweetwaters, The Msunduzi\", \"0 household surveys</br>Tambo, Enoch Mgijima\", \"0 household surveys</br>Umgaga, eThekwini\", \"0 household surveys</br>Umlazi AA, eThekwini\", \"71 household surveys</br>Walmer Dunes, Nelson Mandela Bay\"]}, {\"type\": \"scattermapbox\", \"name\": 1998, \"lat\": [-26.18, -34.11, -25.994387, -29.99, -24.16, -24.92, -30.0, -34.05, -32.13, -29.95, -29.97, -33.99], \"lon\": [27.95, 18.84, 28.197012, 30.91, 30.1, 29.04, 30.91, 18.63, 26.81, 30.84, 30.86, 25.59], \"mode\": \"markers\", \"marker\": {\"size\": [15.344758374622844, 13.887506151238615, 6.0, 14.07085345442472, 6.0, 6.0, 16.82954822505986, 14.770764711240766, 6.0, 12.595137335239937, 14.339338164003273, 14.685995826529712]}, \"text\": [\"77 household surveys</br>Claremont, City of Johannesburg\", \"60 household surveys</br>Helderberg, City of Cape Town\", \"0 household surveys</br>Ivory Park, City of Johannesburg\", \"62 household surveys</br>Lotus Park, eThekwini\", \"0 household surveys</br>Mafefe, Lepele-Nkumpi\", \"0 household surveys</br>Makipsvlei, Ephraim Mogale\", \"97 household surveys</br>Orient Hills, eThekwini\", \"70 household surveys</br>Tafelsig, City of Cape Town\", \"0 household surveys</br>Tambo, Enoch Mgijima\", \"47 household surveys</br>Umgaga, eThekwini\", \"65 household surveys</br>Umlazi AA, eThekwini\", \"69 household surveys</br>Walmer Dunes, Nelson Mandela Bay\"]}, {\"type\": \"scattermapbox\", \"name\": 1999, \"lat\": [-30.09, -24.56, -27.11, -34.11, -25.994387, -29.99, -24.16, -24.92, -30.0, -31.19, -33.96, -26.1, -34.0, -34.05, -32.13, -29.97], \"lon\": [29.81, 30.16, 23.05, 18.84, 28.197012, 30.91, 30.1, 29.04, 30.91, 28.87, 18.38, 27.91, 25.65, 18.63, 26.81, 30.86], \"mode\": \"markers\", \"marker\": {\"size\": [6.0, 6.0, 6.0, 13.605474930389867, 6.0, 13.21521131449353, 6.0, 6.0, 14.770764711240766, 6.0, 12.04102561621379, 11.194146386427404, 13.31438981908953, 14.339338164003273, 6.0, 14.514219452043303]}, \"text\": [\"0 household surveys</br>Antioch, Umzimkhulu\", \"0 household surveys</br>Garagapola, Greater Tubatse/Fetakgomo\", \"0 household surveys</br>Gasese, Joe Morolong\", \"57 household surveys</br>Helderberg, City of Cape Town\", \"0 household surveys</br>Ivory Park, City of Johannesburg\", \"53 household surveys</br>Lotus Park, eThekwini\", \"0 household surveys</br>Mafefe, Lepele-Nkumpi\", \"0 household surveys</br>Makipsvlei, Ephraim Mogale\", \"70 household surveys</br>Orient Hills, eThekwini\", \"0 household surveys</br>Qumbu, Mhlontlo\", \"42 household surveys</br>Rontree Estate, City of Cape Town\", \"35 household surveys</br>Sanctuary Gardens, City of Johannesburg\", \"54 household surveys</br>Summerstrand, Nelson Mandela Bay\", \"65 household surveys</br>Tafelsig, City of Cape Town\", \"0 household surveys</br>Tambo, Enoch Mgijima\", \"67 household surveys</br>Umlazi AA, eThekwini\"]}, {\"type\": \"scattermapbox\", \"name\": 2000, \"lat\": [-30.09, -24.56, -27.11, -34.11, -29.99, -24.16, -24.92, -30.0, -31.19, -33.96, -26.1, -34.0, -34.05, -32.13, -29.91], \"lon\": [29.81, 30.16, 23.05, 18.84, 30.91, 30.1, 29.04, 30.91, 28.87, 18.38, 27.91, 25.65, 18.63, 26.81, 30.94], \"mode\": \"markers\", \"marker\": {\"size\": [14.854810078735389, 14.07085345442472, 14.427176282530075, 12.487252595496072, 13.979630679476134, 14.854810078735389, 14.514219452043303, 15.735817319149103, 11.568504045912809, 13.013431626316205, 13.605474930389867, 13.605474930389867, 13.41247235883031, 13.979630679476134, 13.794455700089644]}, \"text\": [\"71 household surveys</br>Antioch, Umzimkhulu\", \"62 household surveys</br>Garagapola, Greater Tubatse/Fetakgomo\", \"66 household surveys</br>Gasese, Joe Morolong\", \"46 household surveys</br>Helderberg, City of Cape Town\", \"61 household surveys</br>Lotus Park, eThekwini\", \"71 household surveys</br>Mafefe, Lepele-Nkumpi\", \"67 household surveys</br>Makipsvlei, Ephraim Mogale\", \"82 household surveys</br>Orient Hills, eThekwini\", \"38 household surveys</br>Qumbu, Mhlontlo\", \"51 household surveys</br>Rontree Estate, City of Cape Town\", \"57 household surveys</br>Sanctuary Gardens, City of Johannesburg\", \"57 household surveys</br>Summerstrand, Nelson Mandela Bay\", \"55 household surveys</br>Tafelsig, City of Cape Town\", \"61 household surveys</br>Tambo, Enoch Mgijima\", \"59 household surveys</br>Woodhaven, eThekwini\"]}, {\"type\": \"scattermapbox\", \"name\": 2001, \"lat\": [-30.09, -24.56, -27.11, -33.99, -33.95, -24.16, -30.55, -25.82, -32.13, -33.87, -34.04, -29.91], \"lon\": [29.81, 30.16, 23.05, 18.53, 25.49, 30.1, 30.55, 28.29, 26.81, 18.6, 18.59, 30.94], \"mode\": \"markers\", \"marker\": {\"size\": [15.812298386236543, 13.605474930389867, 13.31438981908953, 13.700454085733535, 12.910758747165502, 14.685995826529712, 13.700454085733535, 12.910758747165502, 14.161197636911268, 14.339338164003273, 13.794455700089644, 13.013431626316205]}, \"text\": [\"83 household surveys</br>Antioch, Umzimkhulu\", \"57 household surveys</br>Garagapola, Greater Tubatse/Fetakgomo\", \"54 household surveys</br>Gasese, Joe Morolong\", \"58 household surveys</br>Greenturf, City of Cape Town\", \"50 household surveys</br>Kabega, Nelson Mandela Bay\", \"69 household surveys</br>Mafefe, Lepele-Nkumpi\", \"58 household surveys</br>Mfazazane, Ray Nkonyeni\", \"50 household surveys</br>Moreletta Park, City of Tshwane\", \"63 household surveys</br>Tambo, Enoch Mgijima\", \"65 household surveys</br>Welgemoed, City of Cape Town\", \"59 household surveys</br>Westridge, City of Cape Town\", \"51 household surveys</br>Woodhaven, eThekwini\"]}, {\"type\": \"scattermapbox\", \"name\": 2002, \"lat\": [-30.09, -24.56, -27.11, -33.99, -33.95, -29.57, -24.16, -28.75, -30.55, -25.82, -32.13, -33.87, -34.04, -29.91], \"lon\": [29.81, 30.16, 23.05, 18.53, 25.49, 30.55, 30.1, 31.85, 30.55, 28.29, 26.81, 18.6, 18.59, 30.94], \"mode\": \"markers\", \"marker\": {\"size\": [14.938148166003993, 14.600486573057768, 14.600486573057768, 13.887506151238615, 13.605474930389867, 6.0, 6.0, 13.21521131449353, 13.887506151238615, 13.509490646560558, 15.020794626086364, 14.514219452043303, 14.427176282530075, 13.013431626316205]}, \"text\": [\"72 household surveys</br>Antioch, Umzimkhulu\", \"68 household surveys</br>Garagapola, Greater Tubatse/Fetakgomo\", \"68 household surveys</br>Gasese, Joe Morolong\", \"60 household surveys</br>Greenturf, City of Cape Town\", \"57 household surveys</br>Kabega, Nelson Mandela Bay\", \"0 household surveys</br>Maconqo, Mkhambathini\", \"0 household surveys</br>Mafefe, Lepele-Nkumpi\", \"53 household surveys</br>Matshana, uMhlathuze\", \"60 household surveys</br>Mfazazane, Ray Nkonyeni\", \"56 household surveys</br>Moreletta Park, City of Tshwane\", \"73 household surveys</br>Tambo, Enoch Mgijima\", \"67 household surveys</br>Welgemoed, City of Cape Town\", \"66 household surveys</br>Westridge, City of Cape Town\", \"51 household surveys</br>Woodhaven, eThekwini\"]}, {\"type\": \"scattermapbox\", \"name\": 2003, \"lat\": [-30.09, -24.56, -27.11, -33.99, -28.73, -33.95, -29.57, -28.75, -30.55, -25.82, -32.13, -34.04], \"lon\": [29.81, 30.16, 23.05, 18.53, 26.1, 25.49, 30.55, 31.85, 30.55, 28.29, 26.81, 18.59], \"mode\": \"markers\", \"marker\": {\"size\": [14.685995826529712, 13.979630679476134, 14.161197636911268, 13.41247235883031, 15.344758374622844, 6.0, 12.80684626326909, 13.979630679476134, 13.794455700089644, 13.700454085733535, 14.854810078735389, 13.41247235883031]}, \"text\": [\"69 household surveys</br>Antioch, Umzimkhulu\", \"61 household surveys</br>Garagapola, Greater Tubatse/Fetakgomo\", \"63 household surveys</br>Gasese, Joe Morolong\", \"55 household surveys</br>Greenturf, City of Cape Town\", \"77 household surveys</br>Ikgomotseng, Mangaung\", \"0 household surveys</br>Kabega, Nelson Mandela Bay\", \"49 household surveys</br>Maconqo, Mkhambathini\", \"61 household surveys</br>Matshana, uMhlathuze\", \"59 household surveys</br>Mfazazane, Ray Nkonyeni\", \"58 household surveys</br>Moreletta Park, City of Tshwane\", \"71 household surveys</br>Tambo, Enoch Mgijima\", \"55 household surveys</br>Westridge, City of Cape Town\"]}, {\"type\": \"scattermapbox\", \"name\": 2004, \"lat\": [-25.44, -25.7, -33.99, -33.95, -34.04, -28.75, -25.33, -34.04], \"lon\": [25.86, 31.55, 18.53, 25.49, 18.69, 31.85, 28.87, 18.59], \"mode\": \"markers\", \"marker\": {\"size\": [14.250685436347261, 14.07085345442472, 12.701653443266478, 10.238279389054552, 12.80684626326909, 13.114903567386017, 13.013431626316205, 13.21521131449353]}, \"text\": [\"64 household surveys</br>Dinokana, Ramotshere Moiloa\", \"62 household surveys</br>Driekoppies, Nkomazi\", \"48 household surveys</br>Greenturf, City of Cape Town\", \"28 household surveys</br>Kabega, Nelson Mandela Bay\", \"49 household surveys</br>Khayalitsha, City of Cape Town\", \"52 household surveys</br>Matshana, uMhlathuze\", \"51 household surveys</br>Vlaklaagte, Thembisile\", \"53 household surveys</br>Westridge, City of Cape Town\"]}, {\"type\": \"scattermapbox\", \"name\": 2005, \"lat\": [-25.44, -25.7, -33.99, -33.95, -34.04, -29.748282, -28.75, -28.44, -25.33, -34.04, -25.814629999999998], \"lon\": [25.86, 31.55, 18.53, 25.49, 18.69, 31.066504, 31.85, 29.74, 28.87, 18.59, 28.315609000000002], \"mode\": \"markers\", \"marker\": {\"size\": [14.600486573057768, 14.600486573057768, 12.80684626326909, 13.887506151238615, 15.184072527418282, 6.0, 13.794455700089644, 15.424162968036704, 15.658774563947281, 12.910758747165502, 6.0]}, \"text\": [\"68 household surveys</br>Dinokana, Ramotshere Moiloa\", \"68 household surveys</br>Driekoppies, Nkomazi\", \"49 household surveys</br>Greenturf, City of Cape Town\", \"60 household surveys</br>Kabega, Nelson Mandela Bay\", \"75 household surveys</br>Khayalitsha, City of Cape Town\", \"0 household surveys</br>La Lucia, eThekwini\", \"59 household surveys</br>Matshana, uMhlathuze\", \"78 household surveys</br>Peacetown, Alfred Duma\", \"81 household surveys</br>Vlaklaagte, Thembisile\", \"50 household surveys</br>Westridge, City of Cape Town\", \"0 household surveys</br>Woodhill, City of Tshwane\"]}, {\"type\": \"scattermapbox\", \"name\": 2006, \"lat\": [-25.44, -33.99, -33.95, -34.04, -29.748282, -28.75, -28.44, -25.33, -34.04, -25.814629999999998], \"lon\": [25.86, 18.53, 25.49, 18.69, 31.066504, 31.85, 29.74, 28.87, 18.59, 28.315609000000002], \"mode\": \"markers\", \"marker\": {\"size\": [14.600486573057768, 6.0, 13.887506151238615, 14.685995826529712, 7.0456463152529585, 13.700454085733535, 15.58115898379791, 15.344758374622844, 6.0, 15.102764556754302]}, \"text\": [\"68 household surveys</br>Dinokana, Ramotshere Moiloa\", \"0 household surveys</br>Greenturf, City of Cape Town\", \"60 household surveys</br>Kabega, Nelson Mandela Bay\", \"69 household surveys</br>Khayalitsha, City of Cape Town\", \"11 household surveys</br>La Lucia, eThekwini\", \"58 household surveys</br>Matshana, uMhlathuze\", \"80 household surveys</br>Peacetown, Alfred Duma\", \"77 household surveys</br>Vlaklaagte, Thembisile\", \"0 household surveys</br>Westridge, City of Cape Town\", \"74 household surveys</br>Woodhill, City of Tshwane\"]}, {\"type\": \"scattermapbox\", \"name\": 2007, \"lat\": [-25.44, -34.04, -28.75, -28.44, -25.33, -25.814629999999998], \"lon\": [25.86, 18.69, 31.85, 29.74, 28.87, 28.315609000000002], \"mode\": \"markers\", \"marker\": {\"size\": [6.0, 6.0, 6.0, 6.0, 6.0, 6.0]}, \"text\": [\"0 household surveys</br>Dinokana, Ramotshere Moiloa\", \"0 household surveys</br>Khayalitsha, City of Cape Town\", \"0 household surveys</br>Matshana, uMhlathuze\", \"0 household surveys</br>Peacetown, Alfred Duma\", \"0 household surveys</br>Vlaklaagte, Thembisile\", \"0 household surveys</br>Woodhill, City of Tshwane\"]}, {\"type\": \"scattermapbox\", \"name\": 2008, \"lat\": [-25.44, -34.04, -28.75, -28.44, -25.33, -25.814629999999998], \"lon\": [25.86, 18.69, 31.85, 29.74, 28.87, 28.315609000000002], \"mode\": \"markers\", \"marker\": {\"size\": [13.013431626316205, 12.595137335239937, 12.910758747165502, 14.07085345442472, 15.020794626086364, 14.938148166003993]}, \"text\": [\"51 household surveys</br>Dinokana, Ramotshere Moiloa\", \"47 household surveys</br>Khayalitsha, City of Cape Town\", \"50 household surveys</br>Matshana, uMhlathuze\", \"62 household surveys</br>Peacetown, Alfred Duma\", \"73 household surveys</br>Vlaklaagte, Thembisile\", \"72 household surveys</br>Woodhill, City of Tshwane\"]}, {\"type\": \"scattermapbox\", \"name\": 2009, \"lat\": [-25.44, -24.416673, -34.04, -28.75, -28.44, -25.33, -26.221097999999998, -25.814629999999998], \"lon\": [25.86, 29.783334999999997, 18.69, 31.85, 29.74, 28.87, 28.30327, 28.315609000000002], \"mode\": \"markers\", \"marker\": {\"size\": [12.910758747165502, 6.0, 12.595137335239937, 13.114903567386017, 15.184072527418282, 15.264732604390185, 6.0, 15.184072527418282]}, \"text\": [\"50 household surveys</br>Dinokana, Ramotshere Moiloa\", \"0 household surveys</br>Ga-Nkoane, Greater Tubatse/Fetakgomo\", \"47 household surveys</br>Khayalitsha, City of Cape Town\", \"52 household surveys</br>Matshana, uMhlathuze\", \"75 household surveys</br>Peacetown, Alfred Duma\", \"76 household surveys</br>Vlaklaagte, Thembisile\", \"0 household surveys</br>Wattville, Ekurhuleni\", \"75 household surveys</br>Woodhill, City of Tshwane\"]}, {\"type\": \"scattermapbox\", \"name\": 2010, \"lat\": [-25.507355, -24.416673, -33.824081, -28.75, -25.33, -26.221097999999998], \"lon\": [27.190904999999997, 29.783334999999997, 24.871931, 31.85, 28.87, 28.30327], \"mode\": \"markers\", \"marker\": {\"size\": [6.0, 21.694227994916414, 6.0, 18.862517177350654, 23.05237127203879, 21.309780859084647]}, \"text\": [\"0 household surveys</br>Ga-Luka, Rustenburg\", \"183 household surveys</br>Ga-Nkoane, Greater Tubatse/Fetakgomo\", \"0 household surveys</br>Hankey, Kouga\", \"129 household surveys</br>Matshana, uMhlathuze\", \"213 household surveys</br>Vlaklaagte, Thembisile\", \"175 household surveys</br>Wattville, Ekurhuleni\"]}, {\"type\": \"scattermapbox\", \"name\": 2011, \"lat\": [-25.507355, -24.416673, -33.824081, -28.75, -25.33, -26.221097999999998], \"lon\": [27.190904999999997, 29.783334999999997, 24.871931, 31.85, 28.87, 28.30327], \"mode\": \"markers\", \"marker\": {\"size\": [21.551264953521976, 20.352305053374753, 21.551264953521976, 18.862517177350654, 23.437158331284934, 21.113596051741904]}, \"text\": [\"180 household surveys</br>Ga-Luka, Rustenburg\", \"156 household surveys</br>Ga-Nkoane, Greater Tubatse/Fetakgomo\", \"180 household surveys</br>Hankey, Kouga\", \"129 household surveys</br>Matshana, uMhlathuze\", \"222 household surveys</br>Vlaklaagte, Thembisile\", \"171 household surveys</br>Wattville, Ekurhuleni\"]}, {\"type\": \"scattermapbox\", \"name\": 2012, \"lat\": [-32.31762239, -25.507355, -24.416673, -33.824081, -28.75, -25.51232515, -29.19967496, -25.33, -26.221097999999998], \"lon\": [28.20553465, 27.190904999999997, 29.783334999999997, 24.871931, 31.85, 31.34582484, 26.80923109, 28.87, 28.30327], \"mode\": \"markers\", \"marker\": {\"size\": [20.19483627074896, 20.96464326571595, 21.26098903357619, 20.352305053374753, 19.71100467733987, 19.545708126548192, 23.05237127203879, 22.11486311965557, 21.113596051741904]}, \"text\": [\"153 household surveys</br>Butterworth, Mnquma\", \"168 household surveys</br>Ga-Luka, Rustenburg\", \"174 household surveys</br>Ga-Nkoane, Greater Tubatse/Fetakgomo\", \"156 household surveys</br>Hankey, Kouga\", \"144 household surveys</br>Matshana, uMhlathuze\", \"141 household surveys</br>Matsulu, Mbombela\", \"213 household surveys</br>Seloshesa, Mangaung\", \"192 household surveys</br>Vlaklaagte, Thembisile\", \"171 household surveys</br>Wattville, Ekurhuleni\"]}, {\"type\": \"scattermapbox\", \"name\": 2013, \"lat\": [-26.69245893, -32.31762239, -29.51060165, -25.507355, -24.416673, -33.824081, -28.75, -25.51232515, -28.01601881, -29.19967496, -25.33, -26.221097999999998], \"lon\": [27.79967542, 28.20553465, 27.14995751, 27.190904999999997, 29.783334999999997, 24.871931, 31.85, 31.34582484, 27.08179789, 26.80923109, 28.87, 28.30327], \"mode\": \"markers\", \"marker\": {\"size\": [6.0, 6.0, 6.0, 6.0, 6.0, 6.0, 6.0, 6.0, 6.0, 6.0, 6.0, 6.0]}, \"text\": [\"0 household surveys</br>Bophelong, Emfuleni\", \"0 household surveys</br>Butterworth, Mnquma\", \"0 household surveys</br>Dipelaneng, Mantsopa\", \"0 household surveys</br>Ga-Luka, Rustenburg\", \"0 household surveys</br>Ga-Nkoane, Greater Tubatse/Fetakgomo\", \"0 household surveys</br>Hankey, Kouga\", \"0 household surveys</br>Matshana, uMhlathuze\", \"0 household surveys</br>Matsulu, Mbombela\", \"0 household surveys</br>Phomolong, Matjhabeng\", \"0 household surveys</br>Seloshesa, Mangaung\", \"0 household surveys</br>Vlaklaagte, Thembisile\", \"0 household surveys</br>Wattville, Ekurhuleni\"]}, {\"type\": \"scattermapbox\", \"name\": 2014, \"lat\": [-26.69245893, -32.31762239, -29.51060165, -25.507355, -24.416673, -33.824081, -28.75, -25.51232515, -28.01601881, -29.19967496, -25.33, -26.221097999999998], \"lon\": [27.79967542, 28.20553465, 27.14995751, 27.190904999999997, 29.783334999999997, 24.871931, 31.85, 31.34582484, 27.08179789, 26.80923109, 28.87, 28.30327], \"mode\": \"markers\", \"marker\": {\"size\": [6.0, 6.0, 6.0, 6.0, 6.0, 6.0, 6.0, 6.0, 6.0, 6.0, 6.0, 6.0]}, \"text\": [\"0 household surveys</br>Bophelong, Emfuleni\", \"0 household surveys</br>Butterworth, Mnquma\", \"0 household surveys</br>Dipelaneng, Mantsopa\", \"0 household surveys</br>Ga-Luka, Rustenburg\", \"0 household surveys</br>Ga-Nkoane, Greater Tubatse/Fetakgomo\", \"0 household surveys</br>Hankey, Kouga\", \"0 household surveys</br>Matshana, uMhlathuze\", \"0 household surveys</br>Matsulu, Mbombela\", \"0 household surveys</br>Phomolong, Matjhabeng\", \"0 household surveys</br>Seloshesa, Mangaung\", \"0 household surveys</br>Vlaklaagte, Thembisile\", \"0 household surveys</br>Wattville, Ekurhuleni\"]}], {\"autosize\": true, \"hovermode\": \"closest\", \"mapbox\": {\"accesstoken\": \"pk.eyJ1Ijoic2FpbnRseXZpIiwiYSI6ImNqZHZpNXkzcjFwejkyeHBkNnp3NTkzYnQifQ.Rj_C-fOaZXZTVhTlliofMA\", \"bearing\": 0, \"center\": {\"lat\": -29.1, \"lon\": 25}, \"pitch\": 0, \"zoom\": 4.32, \"style\": \"light\"}, \"margin\": {\"l\": 10, \"r\": 10, \"t\": 20, \"b\": 30}, \"showlegend\": true}, {\"showLink\": true, \"linkText\": \"Export to plot.ly\"})});</script>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "create_map(ids)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Total surveyed households by year"
   ]
  },
  {
   "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># households</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Year</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1994</th>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1995</th>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1996</th>\n",
       "      <td>200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1997</th>\n",
       "      <td>336</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1998</th>\n",
       "      <td>547</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999</th>\n",
       "      <td>443</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000</th>\n",
       "      <td>904</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2001</th>\n",
       "      <td>717</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2002</th>\n",
       "      <td>751</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2003</th>\n",
       "      <td>678</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2004</th>\n",
       "      <td>407</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2005</th>\n",
       "      <td>588</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2006</th>\n",
       "      <td>497</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2008</th>\n",
       "      <td>355</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2009</th>\n",
       "      <td>375</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010</th>\n",
       "      <td>700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011</th>\n",
       "      <td>1038</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012</th>\n",
       "      <td>1512</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      # households\n",
       "Year              \n",
       "1994            50\n",
       "1995           100\n",
       "1996           200\n",
       "1997           336\n",
       "1998           547\n",
       "1999           443\n",
       "2000           904\n",
       "2001           717\n",
       "2002           751\n",
       "2003           678\n",
       "2004           407\n",
       "2005           588\n",
       "2006           497\n",
       "2007             0\n",
       "2008           355\n",
       "2009           375\n",
       "2010           700\n",
       "2011          1038\n",
       "2012          1512\n",
       "2013             0\n",
       "2014             0"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame(loc_summary.groupby(['Year'])['# households'].sum())"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Total surveyed household count by municipality"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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></th>\n",
       "      <th># households</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Province</th>\n",
       "      <th>Municipality</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">EC</th>\n",
       "      <th>Enoch Mgijima</th>\n",
       "      <td>268</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kouga</th>\n",
       "      <td>336</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mhlontlo</th>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mnquma</th>\n",
       "      <td>153</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nelson Mandela Bay</th>\n",
       "      <td>572</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">FS</th>\n",
       "      <th>Mangaung</th>\n",
       "      <td>290</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mantsopa</th>\n",
       "      <td>134</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Matjhabeng</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">GP</th>\n",
       "      <th>City of Johannesburg</th>\n",
       "      <td>311</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>City of Tshwane</th>\n",
       "      <td>385</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ekurhuleni</th>\n",
       "      <td>517</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Emfuleni</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"7\" valign=\"top\">KZN</th>\n",
       "      <th>Alfred Duma</th>\n",
       "      <td>295</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mkhambathini</th>\n",
       "      <td>49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ray Nkonyeni</th>\n",
       "      <td>177</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The Msunduzi</th>\n",
       "      <td>143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Umzimkhulu</th>\n",
       "      <td>295</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>eThekwini</th>\n",
       "      <td>810</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>uMhlathuze</th>\n",
       "      <td>787</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">LIM</th>\n",
       "      <th>Ephraim Mogale</th>\n",
       "      <td>67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Greater Tubatse/Fetakgomo</th>\n",
       "      <td>761</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lepele-Nkumpi</th>\n",
       "      <td>140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">MP</th>\n",
       "      <th>Mbombela</th>\n",
       "      <td>141</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nkomazi</th>\n",
       "      <td>130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Thembisile</th>\n",
       "      <td>985</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NC</th>\n",
       "      <th>Joe Morolong</th>\n",
       "      <td>251</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">NW</th>\n",
       "      <th>Ramotshere Moiloa</th>\n",
       "      <td>301</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rustenburg</th>\n",
       "      <td>348</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">WC</th>\n",
       "      <th>City of Cape Town</th>\n",
       "      <td>1464</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Stellenbosch</th>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    # households\n",
       "Province Municipality                           \n",
       "EC       Enoch Mgijima                       268\n",
       "         Kouga                               336\n",
       "         Mhlontlo                             38\n",
       "         Mnquma                              153\n",
       "         Nelson Mandela Bay                  572\n",
       "FS       Mangaung                            290\n",
       "         Mantsopa                            134\n",
       "         Matjhabeng                            0\n",
       "GP       City of Johannesburg                311\n",
       "         City of Tshwane                     385\n",
       "         Ekurhuleni                          517\n",
       "         Emfuleni                              0\n",
       "KZN      Alfred Duma                         295\n",
       "         Mkhambathini                         49\n",
       "         Ray Nkonyeni                        177\n",
       "         The Msunduzi                        143\n",
       "         Umzimkhulu                          295\n",
       "         eThekwini                           810\n",
       "         uMhlathuze                          787\n",
       "LIM      Ephraim Mogale                       67\n",
       "         Greater Tubatse/Fetakgomo           761\n",
       "         Lepele-Nkumpi                       140\n",
       "MP       Mbombela                            141\n",
       "         Nkomazi                             130\n",
       "         Thembisile                          985\n",
       "NC       Joe Morolong                        251\n",
       "NW       Ramotshere Moiloa                   301\n",
       "         Rustenburg                          348\n",
       "WC       City of Cape Town                  1464\n",
       "         Stellenbosch                         50"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame(loc_summary.groupby(['Province','Municipality'])['# households'].sum())"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Surveyed household count per municipality per year (1994 - 2014)"
   ]
  },
  {
   "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>Year</th>\n",
       "      <th>1994</th>\n",
       "      <th>1995</th>\n",
       "      <th>1996</th>\n",
       "      <th>1997</th>\n",
       "      <th>1998</th>\n",
       "      <th>1999</th>\n",
       "      <th>2000</th>\n",
       "      <th>2001</th>\n",
       "      <th>2002</th>\n",
       "      <th>2003</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Province</th>\n",
       "      <th>Municipality</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">EC</th>\n",
       "      <th>Enoch Mgijima</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>61</td>\n",
       "      <td>63</td>\n",
       "      <td>73</td>\n",
       "      <td>71</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>Kouga</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>0</td>\n",
       "      <td>180</td>\n",
       "      <td>156</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mhlontlo</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>38</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>Mnquma</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>153</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nelson Mandela Bay</th>\n",
       "      <td></td>\n",
       "      <td>66</td>\n",
       "      <td></td>\n",
       "      <td>71</td>\n",
       "      <td>69</td>\n",
       "      <td>54</td>\n",
       "      <td>57</td>\n",
       "      <td>50</td>\n",
       "      <td>57</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>60</td>\n",
       "      <td>60</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 rowspan=\"3\" valign=\"top\">FS</th>\n",
       "      <th>Mangaung</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>77</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>213</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mantsopa</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>59</td>\n",
       "      <td>75</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>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Matjhabeng</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>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">GP</th>\n",
       "      <th>City of Johannesburg</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>69</td>\n",
       "      <td>73</td>\n",
       "      <td>77</td>\n",
       "      <td>35</td>\n",
       "      <td>57</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>City of Tshwane</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>50</td>\n",
       "      <td>56</td>\n",
       "      <td>58</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>74</td>\n",
       "      <td>0</td>\n",
       "      <td>72</td>\n",
       "      <td>75</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ekurhuleni</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>0</td>\n",
       "      <td>175</td>\n",
       "      <td>171</td>\n",
       "      <td>171</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Emfuleni</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>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"7\" valign=\"top\">KZN</th>\n",
       "      <th>Alfred Duma</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>78</td>\n",
       "      <td>80</td>\n",
       "      <td>0</td>\n",
       "      <td>62</td>\n",
       "      <td>75</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mkhambathini</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>0</td>\n",
       "      <td>49</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>Ray Nkonyeni</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>58</td>\n",
       "      <td>60</td>\n",
       "      <td>59</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>The Msunduzi</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>72</td>\n",
       "      <td>71</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>Umzimkhulu</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>71</td>\n",
       "      <td>83</td>\n",
       "      <td>72</td>\n",
       "      <td>69</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>eThekwini</th>\n",
       "      <td></td>\n",
       "      <td>34</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>271</td>\n",
       "      <td>190</td>\n",
       "      <td>202</td>\n",
       "      <td>51</td>\n",
       "      <td>51</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>11</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>uMhlathuze</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>53</td>\n",
       "      <td>61</td>\n",
       "      <td>...</td>\n",
       "      <td>59</td>\n",
       "      <td>58</td>\n",
       "      <td>0</td>\n",
       "      <td>50</td>\n",
       "      <td>52</td>\n",
       "      <td>129</td>\n",
       "      <td>129</td>\n",
       "      <td>144</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">LIM</th>\n",
       "      <th>Ephraim Mogale</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>67</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>Greater Tubatse/Fetakgomo</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>62</td>\n",
       "      <td>57</td>\n",
       "      <td>68</td>\n",
       "      <td>61</td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>183</td>\n",
       "      <td>156</td>\n",
       "      <td>174</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lepele-Nkumpi</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>71</td>\n",
       "      <td>69</td>\n",
       "      <td>0</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 rowspan=\"3\" valign=\"top\">MP</th>\n",
       "      <th>Mbombela</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>141</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nkomazi</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>68</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>Thembisile</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>81</td>\n",
       "      <td>77</td>\n",
       "      <td>0</td>\n",
       "      <td>73</td>\n",
       "      <td>76</td>\n",
       "      <td>213</td>\n",
       "      <td>222</td>\n",
       "      <td>192</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NC</th>\n",
       "      <th>Joe Morolong</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>66</td>\n",
       "      <td>54</td>\n",
       "      <td>68</td>\n",
       "      <td>63</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 rowspan=\"2\" valign=\"top\">NW</th>\n",
       "      <th>Ramotshere Moiloa</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>68</td>\n",
       "      <td>68</td>\n",
       "      <td>0</td>\n",
       "      <td>51</td>\n",
       "      <td>50</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rustenburg</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>0</td>\n",
       "      <td>180</td>\n",
       "      <td>168</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">WC</th>\n",
       "      <th>City of Cape Town</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>46</td>\n",
       "      <td>130</td>\n",
       "      <td>164</td>\n",
       "      <td>152</td>\n",
       "      <td>182</td>\n",
       "      <td>193</td>\n",
       "      <td>110</td>\n",
       "      <td>...</td>\n",
       "      <td>174</td>\n",
       "      <td>69</td>\n",
       "      <td>0</td>\n",
       "      <td>47</td>\n",
       "      <td>47</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Stellenbosch</th>\n",
       "      <td>50</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",
       "  </tbody>\n",
       "</table>\n",
       "<p>30 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "Year                               1994 1995 1996 1997 1998 1999 2000 2001  \\\n",
       "Province Municipality                                                        \n",
       "EC       Enoch Mgijima                               0    0    0   61   63   \n",
       "         Kouga                                                               \n",
       "         Mhlontlo                                              0   38        \n",
       "         Mnquma                                                              \n",
       "         Nelson Mandela Bay               66        71   69   54   57   50   \n",
       "FS       Mangaung                                                            \n",
       "         Mantsopa                              59   75                       \n",
       "         Matjhabeng                                                          \n",
       "GP       City of Johannesburg                  69   73   77   35   57        \n",
       "         City of Tshwane                                                50   \n",
       "         Ekurhuleni                                                          \n",
       "         Emfuleni                                                            \n",
       "KZN      Alfred Duma                                                         \n",
       "         Mkhambathini                                                        \n",
       "         Ray Nkonyeni                                                   58   \n",
       "         The Msunduzi                          72   71                       \n",
       "         Umzimkhulu                                            0   71   83   \n",
       "         eThekwini                        34         0  271  190  202   51   \n",
       "         uMhlathuze                                                          \n",
       "LIM      Ephraim Mogale                              0    0    0   67        \n",
       "         Greater Tubatse/Fetakgomo                             0   62   57   \n",
       "         Lepele-Nkumpi                                    0    0   71   69   \n",
       "MP       Mbombela                                                            \n",
       "         Nkomazi                                                             \n",
       "         Thembisile                                                          \n",
       "NC       Joe Morolong                                          0   66   54   \n",
       "NW       Ramotshere Moiloa                                                   \n",
       "         Rustenburg                                                          \n",
       "WC       City of Cape Town                          46  130  164  152  182   \n",
       "         Stellenbosch                50                                      \n",
       "\n",
       "Year                               2002 2003 ...  2005 2006 2007 2008 2009  \\\n",
       "Province Municipality                        ...                             \n",
       "EC       Enoch Mgijima               73   71 ...                             \n",
       "         Kouga                               ...                             \n",
       "         Mhlontlo                            ...                             \n",
       "         Mnquma                              ...                             \n",
       "         Nelson Mandela Bay          57    0 ...    60   60                  \n",
       "FS       Mangaung                         77 ...                             \n",
       "         Mantsopa                            ...                             \n",
       "         Matjhabeng                          ...                             \n",
       "GP       City of Johannesburg                ...                             \n",
       "         City of Tshwane             56   58 ...     0   74    0   72   75   \n",
       "         Ekurhuleni                          ...                         0   \n",
       "         Emfuleni                            ...                             \n",
       "KZN      Alfred Duma                         ...    78   80    0   62   75   \n",
       "         Mkhambathini                 0   49 ...                             \n",
       "         Ray Nkonyeni                60   59 ...                             \n",
       "         The Msunduzi                        ...                             \n",
       "         Umzimkhulu                  72   69 ...                             \n",
       "         eThekwini                   51      ...     0   11                  \n",
       "         uMhlathuze                  53   61 ...    59   58    0   50   52   \n",
       "LIM      Ephraim Mogale                      ...                             \n",
       "         Greater Tubatse/Fetakgomo   68   61 ...                         0   \n",
       "         Lepele-Nkumpi                0      ...                             \n",
       "MP       Mbombela                            ...                             \n",
       "         Nkomazi                             ...    68                       \n",
       "         Thembisile                          ...    81   77    0   73   76   \n",
       "NC       Joe Morolong                68   63 ...                             \n",
       "NW       Ramotshere Moiloa                   ...    68   68    0   51   50   \n",
       "         Rustenburg                          ...                             \n",
       "WC       City of Cape Town          193  110 ...   174   69    0   47   47   \n",
       "         Stellenbosch                        ...                             \n",
       "\n",
       "Year                               2010 2011 2012 2013 2014  \n",
       "Province Municipality                                        \n",
       "EC       Enoch Mgijima                                       \n",
       "         Kouga                        0  180  156    0    0  \n",
       "         Mhlontlo                                            \n",
       "         Mnquma                               153    0    0  \n",
       "         Nelson Mandela Bay                                  \n",
       "FS       Mangaung                             213    0    0  \n",
       "         Mantsopa                                    0    0  \n",
       "         Matjhabeng                                  0    0  \n",
       "GP       City of Johannesburg                                \n",
       "         City of Tshwane                                     \n",
       "         Ekurhuleni                 175  171  171    0    0  \n",
       "         Emfuleni                                    0    0  \n",
       "KZN      Alfred Duma                                         \n",
       "         Mkhambathini                                        \n",
       "         Ray Nkonyeni                                        \n",
       "         The Msunduzi                                        \n",
       "         Umzimkhulu                                          \n",
       "         eThekwini                                           \n",
       "         uMhlathuze                 129  129  144    0    0  \n",
       "LIM      Ephraim Mogale                                      \n",
       "         Greater Tubatse/Fetakgomo  183  156  174    0    0  \n",
       "         Lepele-Nkumpi                                       \n",
       "MP       Mbombela                             141    0    0  \n",
       "         Nkomazi                                             \n",
       "         Thembisile                 213  222  192    0    0  \n",
       "NC       Joe Morolong                                        \n",
       "NW       Ramotshere Moiloa                                   \n",
       "         Rustenburg                   0  180  168    0    0  \n",
       "WC       City of Cape Town                                   \n",
       "         Stellenbosch                                        \n",
       "\n",
       "[30 rows x 21 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "loc_summary.pivot_table(aggfunc=sum,columns='Year',index=['Province','Municipality'],values='# households',fill_value='')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Socio-demographic Summaries"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Understanding Survey Data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Search Survey Questions for Key Words"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "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>Question</th>\n",
       "      <th>Datatype</th>\n",
       "      <th>QuestionaireID</th>\n",
       "      <th>ColumnNo</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>707</th>\n",
       "      <td>PeopleAreLivingAtShop</td>\n",
       "      <td>num</td>\n",
       "      <td>1000001</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>714</th>\n",
       "      <td>NumberOfPeopleLivingAtShop</td>\n",
       "      <td>num</td>\n",
       "      <td>1000001</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>791</th>\n",
       "      <td>PeopleAreLivingAtSchool</td>\n",
       "      <td>num</td>\n",
       "      <td>1000002</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>792</th>\n",
       "      <td>NumOfPeopleLivingAtSchool</td>\n",
       "      <td>num</td>\n",
       "      <td>1000002</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                       Question Datatype  QuestionaireID  ColumnNo\n",
       "707       PeopleAreLivingAtShop      num         1000001         5\n",
       "714  NumberOfPeopleLivingAtShop      num         1000001        10\n",
       "791     PeopleAreLivingAtSchool      num         1000002        12\n",
       "792   NumOfPeopleLivingAtSchool      num         1000002        13"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "features.searchQuestions('liv')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Create Dataframe with Selected Features"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "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>AnswerID</th>\n",
       "      <th>QuestionaireID</th>\n",
       "      <th>years_electrified</th>\n",
       "      <th>monthly_income</th>\n",
       "      <th>fridge_freezer</th>\n",
       "      <th>geyser</th>\n",
       "      <th>heater</th>\n",
       "      <th>hotplate</th>\n",
       "      <th>iron</th>\n",
       "      <th>kettle</th>\n",
       "      <th>microwave</th>\n",
       "      <th>3_plate</th>\n",
       "      <th>4_plate</th>\n",
       "      <th>tv</th>\n",
       "      <th>washing_machine</th>\n",
       "      <th>main switch</th>\n",
       "      <th>floor area</th>\n",
       "      <th>rooms</th>\n",
       "      <th>wall</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1415</td>\n",
       "      <td>6</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2900.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>60.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1414</td>\n",
       "      <td>6</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1450.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1411</td>\n",
       "      <td>6</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2550.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1412</td>\n",
       "      <td>6</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1300.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1409</td>\n",
       "      <td>6</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>60.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  AnswerID QuestionaireID  years_electrified  monthly_income  fridge_freezer  \\\n",
       "0     1415              6               10.0          2900.0             1.0   \n",
       "1     1414              6               10.0          1450.0             1.0   \n",
       "2     1411              6               10.0          2550.0             1.0   \n",
       "3     1412              6               10.0          1300.0             1.0   \n",
       "4     1409              6               10.0             0.0             NaN   \n",
       "\n",
       "   geyser  heater  hotplate  iron  kettle  microwave  3_plate  4_plate   tv  \\\n",
       "0     1.0     1.0       1.0   1.0     1.0        NaN      NaN      1.0  1.0   \n",
       "1     1.0     NaN       NaN   1.0     1.0        NaN      NaN      1.0  1.0   \n",
       "2     1.0     1.0       NaN   1.0     1.0        NaN      NaN      1.0  1.0   \n",
       "3     1.0     NaN       NaN   1.0     1.0        NaN      NaN      1.0  1.0   \n",
       "4     1.0     NaN       NaN   1.0     NaN        NaN      1.0      NaN  1.0   \n",
       "\n",
       "   washing_machine  main switch  floor area  rooms  wall  \n",
       "0              NaN         60.0        50.0    5.0   3.0  \n",
       "1              1.0         60.0        50.0    5.0   3.0  \n",
       "2              1.0         60.0        50.0    5.0   3.0  \n",
       "3              1.0         60.0        50.0    6.0   3.0  \n",
       "4              NaN         60.0        50.0    5.0   3.0  "
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "appliances = ['fridge freezer','geyser','heater','hotplate','iron','kettle','microwave','3 plate','4 plate','tv',\n",
    " 'washing machine']\n",
    "other_socios = ['main switch', 'floor area', 'rooms', 'wall']\n",
    " \n",
    "#load socio-demographic feature frame\n",
    "sd = features.socio_demographics(appliances, other_socios)\n",
    "sd.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### View Locations for Year"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Khayalitsha',\n",
       " 'Greenturf',\n",
       " 'Vlaklaagte',\n",
       " 'Woodhill',\n",
       " 'La Lucia',\n",
       " 'Dinokana',\n",
       " 'Peacetown',\n",
       " 'Kabega',\n",
       " 'Matshana',\n",
       " 'Westridge',\n",
       " 'Driekoppies']"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Specify Survey Year\n",
    "year = 2005\n",
    "\n",
    "ids_yr = ids[ids.Year==year]\n",
    "list(ids_yr.LocName.unique())"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Location Details"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "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>years_electrified</th>\n",
       "      <th>monthly_income</th>\n",
       "      <th>fridge_freezer</th>\n",
       "      <th>geyser</th>\n",
       "      <th>heater</th>\n",
       "      <th>hotplate</th>\n",
       "      <th>iron</th>\n",
       "      <th>kettle</th>\n",
       "      <th>microwave</th>\n",
       "      <th>3_plate</th>\n",
       "      <th>4_plate</th>\n",
       "      <th>tv</th>\n",
       "      <th>washing_machine</th>\n",
       "      <th>main switch</th>\n",
       "      <th>floor area</th>\n",
       "      <th>rooms</th>\n",
       "      <th>wall</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>68.000000</td>\n",
       "      <td>68.000000</td>\n",
       "      <td>35.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>68.000000</td>\n",
       "      <td>68.000000</td>\n",
       "      <td>68.000000</td>\n",
       "      <td>68.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>3.176471</td>\n",
       "      <td>770.588235</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>22.941176</td>\n",
       "      <td>66.602941</td>\n",
       "      <td>4.294118</td>\n",
       "      <td>6.514706</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>1.827985</td>\n",
       "      <td>921.204407</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.517764</td>\n",
       "      <td>39.467780</td>\n",
       "      <td>2.102300</td>\n",
       "      <td>3.605521</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>8.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>2.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>29.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>4.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>2.000000</td>\n",
       "      <td>780.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>56.000000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>6.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>3.250000</td>\n",
       "      <td>850.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>99.500000</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>11.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>7.000000</td>\n",
       "      <td>6000.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>60.000000</td>\n",
       "      <td>162.000000</td>\n",
       "      <td>8.000000</td>\n",
       "      <td>11.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       years_electrified  monthly_income  fridge_freezer  geyser  heater  \\\n",
       "count          68.000000       68.000000            35.0     0.0     7.0   \n",
       "mean            3.176471      770.588235             1.0     NaN     1.0   \n",
       "std             1.827985      921.204407             0.0     NaN     0.0   \n",
       "min             1.000000        0.000000             1.0     NaN     1.0   \n",
       "25%             2.000000       75.000000             1.0     NaN     1.0   \n",
       "50%             2.000000      780.000000             1.0     NaN     1.0   \n",
       "75%             3.250000      850.000000             1.0     NaN     1.0   \n",
       "max             7.000000     6000.000000             1.0     NaN     1.0   \n",
       "\n",
       "       hotplate  iron  kettle  microwave  3_plate  4_plate    tv  \\\n",
       "count      28.0  33.0    35.0        4.0      3.0      8.0  43.0   \n",
       "mean        1.0   1.0     1.0        1.0      1.0      1.0   1.0   \n",
       "std         0.0   0.0     0.0        0.0      0.0      0.0   0.0   \n",
       "min         1.0   1.0     1.0        1.0      1.0      1.0   1.0   \n",
       "25%         1.0   1.0     1.0        1.0      1.0      1.0   1.0   \n",
       "50%         1.0   1.0     1.0        1.0      1.0      1.0   1.0   \n",
       "75%         1.0   1.0     1.0        1.0      1.0      1.0   1.0   \n",
       "max         1.0   1.0     1.0        1.0      1.0      1.0   1.0   \n",
       "\n",
       "       washing_machine  main switch  floor area      rooms       wall  \n",
       "count              3.0    68.000000   68.000000  68.000000  68.000000  \n",
       "mean               1.0    22.941176   66.602941   4.294118   6.514706  \n",
       "std                0.0    10.517764   39.467780   2.102300   3.605521  \n",
       "min                1.0    20.000000    8.000000   1.000000   1.000000  \n",
       "25%                1.0    20.000000   29.000000   2.000000   4.000000  \n",
       "50%                1.0    20.000000   56.000000   4.000000   6.000000  \n",
       "75%                1.0    20.000000   99.500000   6.000000  11.000000  \n",
       "max                1.0    60.000000  162.000000   8.000000  11.000000  "
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "location = 'Dinokana'\n",
    "\n",
    "aid_select = ids_yr.loc[(ids_yr.LocName==location)&(ids_yr.AnswerID!=0), 'AnswerID']\n",
    "sd_yr = sd[sd.AnswerID.isin(aid_select)]\n",
    "sd_yr.describe()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Electricity Supply"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "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>years_electrified</th>\n",
       "      <th>main switch</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>68.000000</td>\n",
       "      <td>68.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>3.176471</td>\n",
       "      <td>22.941176</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>1.827985</td>\n",
       "      <td>10.517764</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>20.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>2.000000</td>\n",
       "      <td>20.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>2.000000</td>\n",
       "      <td>20.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>3.250000</td>\n",
       "      <td>20.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>7.000000</td>\n",
       "      <td>60.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       years_electrified  main switch\n",
       "count          68.000000    68.000000\n",
       "mean            3.176471    22.941176\n",
       "std             1.827985    10.517764\n",
       "min             1.000000    20.000000\n",
       "25%             2.000000    20.000000\n",
       "50%             2.000000    20.000000\n",
       "75%             3.250000    20.000000\n",
       "max             7.000000    60.000000"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sd_yr[['years_electrified','main switch']].describe()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Appliance Ownership"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "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>Ownership (%hh)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>fridge_freezer</th>\n",
       "      <td>0.514706</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>geyser</th>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>heater</th>\n",
       "      <td>0.102941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>hotplate</th>\n",
       "      <td>0.411765</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>iron</th>\n",
       "      <td>0.485294</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>kettle</th>\n",
       "      <td>0.514706</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>microwave</th>\n",
       "      <td>0.058824</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3_plate</th>\n",
       "      <td>0.044118</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4_plate</th>\n",
       "      <td>0.117647</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tv</th>\n",
       "      <td>0.632353</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>washing_machine</th>\n",
       "      <td>0.044118</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Ownership (%hh)\n",
       "fridge_freezer          0.514706\n",
       "geyser                  0.000000\n",
       "heater                  0.102941\n",
       "hotplate                0.411765\n",
       "iron                    0.485294\n",
       "kettle                  0.514706\n",
       "microwave               0.058824\n",
       "3_plate                 0.044118\n",
       "4_plate                 0.117647\n",
       "tv                      0.632353\n",
       "washing_machine         0.044118"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame(sd_yr.iloc[:,4:4+len(appliances)].count()/len(sd_yr), columns=['Ownership (%hh)'])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Size of Housing"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "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>floor area</th>\n",
       "      <th>rooms</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>68.000000</td>\n",
       "      <td>68.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>66.602941</td>\n",
       "      <td>4.294118</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>39.467780</td>\n",
       "      <td>2.102300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>8.000000</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>29.000000</td>\n",
       "      <td>2.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>56.000000</td>\n",
       "      <td>4.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>99.500000</td>\n",
       "      <td>6.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>162.000000</td>\n",
       "      <td>8.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       floor area      rooms\n",
       "count   68.000000  68.000000\n",
       "mean    66.602941   4.294118\n",
       "std     39.467780   2.102300\n",
       "min      8.000000   1.000000\n",
       "25%     29.000000   2.000000\n",
       "50%     56.000000   4.000000\n",
       "75%     99.500000   6.000000\n",
       "max    162.000000   8.000000"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sd_yr[['floor area','rooms']].describe()"
   ]
  },
  {
   "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.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}