00_form_subset.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "f4f35871",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import geopandas as gpd\n",
    "import os\n",
    "import re\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "c05792a5",
   "metadata": {},
   "outputs": [],
   "source": [
    "%run ./00_subsetting_funcs.ipynb"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "fda0558c",
   "metadata": {},
   "outputs": [],
   "source": [
    "urba_gov=pd.read_excel(\"D:/urba_gov.xlsx\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3b74db51",
   "metadata": {},
   "source": [
    "# Load input data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "49c75777",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Sales aggregated to unique customer ids\n",
    "sales=pd.read_csv(\"C:/Users/Salif SAWADOGO/dynamic segmentation/data_acquisition/Sales data/sales_cust_level.csv\")\n",
    "sales=sales.rename(columns={\"AMOUNT_EUR\": \"NSR\", \"AMOUNT_GROSS_EUR\":\"GSR\"})\n",
    "# Raw CMD \n",
    "cmd=pd.read_excel(\"D:/data_quality/data/BDD G 26.04.2021.XLSX\")\n",
    "cmd= cmd.rename(columns={'Client': 'CUSTOMER_COD'})\n",
    "\n",
    "#read government urbanicity\n",
    "urba_gov=pd.read_excel(\"D:/urba_gov.xlsx\")\n",
    "\n",
    "# Complete trade area set - prior to aggregation for neighbours\n",
    "ta_og_tizi_ouzou = gpd.read_file(os.path.join('C:/Users/Salif SAWADOGO/dynamic segmentation/urbanicty/code/', 'cmd_ta_preagg.json'))\n",
    "ta_og_tizi_ouzou= ta_og_tizi_ouzou.rename(columns={'Client': 'CUSTOMER_COD'})\n",
    " \n",
    "# Trade area set post aggregation and formatting\n",
    "ta_p_tizi_ouzou = pd.read_excel('C:/Users/Salif SAWADOGOL/dynamic segmentation/urbanicty/ta_tizi_ouzou_250.xlsx')\n",
    "ta_p_tizi_ouzou= ta_p_tizi_ouzou.rename(columns={'Client': 'CUSTOMER_COD'})\n",
    "\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "54c83fa5",
   "metadata": {},
   "source": [
    "# Form a combo set"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9534e7e8",
   "metadata": {},
   "source": [
    "1) Merge cmd (raw) and sales (aggregated to unique cust ids)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "4709d4ce",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(64560, 87)"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "internal_combi = merge_custom_sets(cmd, sales)\n",
    "internal_combi.shape"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "59ab4abf",
   "metadata": {},
   "source": [
    "\n",
    "2) Form marrakech combo set from internal and trade area data\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "e28eb153",
   "metadata": {},
   "outputs": [],
   "source": [
    "tizi_ouzou_combi = \\\n",
    "  combine_tizi_ouzou(\n",
    "    ta_og=ta_og_tizi_ouzou, \n",
    "    ta_p=ta_p_tizi_ouzou, \n",
    "    internal_combi=internal_combi, \n",
    "    urba_gov=urba_gov,\n",
    "    top_field='NSR', \n",
    "    combi_keepers=['CUSTOMER_COD', 'NSR', 'GSR', 'UNIT_CASES','TRANSACTIONS']\n",
    "  )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "da38f266",
   "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>CHANNEL_CUSTOM</th>\n",
       "      <th>AG</th>\n",
       "      <th>HORECA</th>\n",
       "      <th>OTHER</th>\n",
       "      <th>SNACK</th>\n",
       "      <th>All</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Classification client</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>Bronze</th>\n",
       "      <td>651</td>\n",
       "      <td>998</td>\n",
       "      <td>1</td>\n",
       "      <td>92</td>\n",
       "      <td>1742</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gold</th>\n",
       "      <td>97</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>21</td>\n",
       "      <td>133</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Silver</th>\n",
       "      <td>523</td>\n",
       "      <td>446</td>\n",
       "      <td>1</td>\n",
       "      <td>135</td>\n",
       "      <td>1105</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tin</th>\n",
       "      <td>1271</td>\n",
       "      <td>21</td>\n",
       "      <td>518</td>\n",
       "      <td>758</td>\n",
       "      <td>2568</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>All</th>\n",
       "      <td>2542</td>\n",
       "      <td>1480</td>\n",
       "      <td>520</td>\n",
       "      <td>1006</td>\n",
       "      <td>5548</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "CHANNEL_CUSTOM           AG  HORECA  OTHER  SNACK   All\n",
       "Classification client                                  \n",
       "Bronze                  651     998      1     92  1742\n",
       "Gold                     97      15      0     21   133\n",
       "Silver                  523     446      1    135  1105\n",
       "Tin                    1271      21    518    758  2568\n",
       "All                    2542    1480    520   1006  5548"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "channel_scope=tizi_ouzou_combi.loc[~tizi_ouzou_combi[\"Classification client\"].isin([\"Platinum\",\"Prestigieux\"])]\n",
    "pd.crosstab(channel_scope[\"Classification client\"], channel_scope.CHANNEL_CUSTOM, margins=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "4d73dfed",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "dataframe dimensions: (2473, 96)\n"
     ]
    },
    {
     "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>Communes</th>\n",
       "      <th>Outlets</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Tizi Ouzou</td>\n",
       "      <td>608</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Draa Ben Khedda</td>\n",
       "      <td>150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Freha</td>\n",
       "      <td>125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Azazga</td>\n",
       "      <td>98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Tigzirt</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Boghni</td>\n",
       "      <td>85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Ouadhia</td>\n",
       "      <td>83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Bouzguen</td>\n",
       "      <td>67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Makouda</td>\n",
       "      <td>66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Mekla</td>\n",
       "      <td>64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Tizi Rached</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Tadmait</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Beni Douala</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Draa El Mizan</td>\n",
       "      <td>52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Larba Nait Irathen</td>\n",
       "      <td>51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Ain El Hammam</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Timizart</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Azeffoun</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Tirmitine</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Maatka</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              Communes  Outlets\n",
       "0           Tizi Ouzou      608\n",
       "1      Draa Ben Khedda      150\n",
       "2                Freha      125\n",
       "3               Azazga       98\n",
       "4              Tigzirt       90\n",
       "5               Boghni       85\n",
       "6              Ouadhia       83\n",
       "7             Bouzguen       67\n",
       "8              Makouda       66\n",
       "9                Mekla       64\n",
       "10         Tizi Rached       56\n",
       "11             Tadmait       54\n",
       "12         Beni Douala       54\n",
       "13       Draa El Mizan       52\n",
       "14  Larba Nait Irathen       51\n",
       "15       Ain El Hammam       45\n",
       "16            Timizart       38\n",
       "17            Azeffoun       35\n",
       "18           Tirmitine       34\n",
       "19              Maatka       34"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "subset_horeca = tizi_ouzou_combi.loc[tizi_ouzou_combi['Type Canal'].isin(['Horeca'])]\n",
    "print(\"dataframe dimensions:\", subset_horeca.shape)\n",
    "subset_horeca['ADM2_EN'].value_counts().reset_index().rename(columns={\"index\":\"Communes\",\"ADM2_EN\":\"Outlets\"}).head(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "2a72de18",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Number of items proportionate to group size!\n"
     ]
    },
    {
     "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>CUSTOMER_COD</th>\n",
       "      <th>ADM2_EN</th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>Groupe</th>\n",
       "      <th>OrgCm</th>\n",
       "      <th>CDis</th>\n",
       "      <th>SA</th>\n",
       "      <th>Titre</th>\n",
       "      <th>Anc.Client</th>\n",
       "      <th>Nom</th>\n",
       "      <th>...</th>\n",
       "      <th>osm_count</th>\n",
       "      <th>dist_km</th>\n",
       "      <th>NSR</th>\n",
       "      <th>GSR</th>\n",
       "      <th>UNIT_CASES</th>\n",
       "      <th>TRANSACTIONS</th>\n",
       "      <th>NSR_rank</th>\n",
       "      <th>Commune_y</th>\n",
       "      <th>urba_gov_Population</th>\n",
       "      <th>urba_gov_Superficie</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>37832</td>\n",
       "      <td>Ain El Hammam</td>\n",
       "      <td>3113</td>\n",
       "      <td>ZA04</td>\n",
       "      <td>A000</td>\n",
       "      <td>DD</td>\n",
       "      <td>10</td>\n",
       "      <td>Monsieur</td>\n",
       "      <td>1100108.0</td>\n",
       "      <td>CHABA AKLI</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>0.598761</td>\n",
       "      <td>2865.209961</td>\n",
       "      <td>2898.154748</td>\n",
       "      <td>757.326700</td>\n",
       "      <td>9380.0</td>\n",
       "      <td>821</td>\n",
       "      <td>Ain El Hammam</td>\n",
       "      <td>20401.0</td>\n",
       "      <td>38.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>38867</td>\n",
       "      <td>Azazga</td>\n",
       "      <td>1634</td>\n",
       "      <td>ZA04</td>\n",
       "      <td>A000</td>\n",
       "      <td>DD</td>\n",
       "      <td>10</td>\n",
       "      <td>Monsieur</td>\n",
       "      <td>1101163.0</td>\n",
       "      <td>OUGACHE KAMEL</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>0.429676</td>\n",
       "      <td>1257.254905</td>\n",
       "      <td>1275.350501</td>\n",
       "      <td>285.258685</td>\n",
       "      <td>5790.0</td>\n",
       "      <td>1796</td>\n",
       "      <td>Azazga</td>\n",
       "      <td>34683.0</td>\n",
       "      <td>77.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>52322</td>\n",
       "      <td>Beni Douala</td>\n",
       "      <td>4867</td>\n",
       "      <td>ZA04</td>\n",
       "      <td>A000</td>\n",
       "      <td>DD</td>\n",
       "      <td>10</td>\n",
       "      <td>Monsieur</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LADJADJ MOURAD</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>4.623919</td>\n",
       "      <td>4323.772863</td>\n",
       "      <td>4361.556065</td>\n",
       "      <td>1183.367765</td>\n",
       "      <td>13980.0</td>\n",
       "      <td>455</td>\n",
       "      <td>Beni Douala</td>\n",
       "      <td>21551.0</td>\n",
       "      <td>35.08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>54407</td>\n",
       "      <td>Bouzguen</td>\n",
       "      <td>4693</td>\n",
       "      <td>ZA04</td>\n",
       "      <td>A000</td>\n",
       "      <td>DD</td>\n",
       "      <td>10</td>\n",
       "      <td>Monsieur</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MOUDJEB AMAR</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>0.598761</td>\n",
       "      <td>3131.501270</td>\n",
       "      <td>3163.239883</td>\n",
       "      <td>920.662940</td>\n",
       "      <td>8678.0</td>\n",
       "      <td>724</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>52393</td>\n",
       "      <td>Freha</td>\n",
       "      <td>236</td>\n",
       "      <td>ZA04</td>\n",
       "      <td>A000</td>\n",
       "      <td>DD</td>\n",
       "      <td>10</td>\n",
       "      <td>Monsieur</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MALLEK IDIR</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>5.191190</td>\n",
       "      <td>6345.284588</td>\n",
       "      <td>6414.487029</td>\n",
       "      <td>1547.466735</td>\n",
       "      <td>23154.0</td>\n",
       "      <td>233</td>\n",
       "      <td>Freha</td>\n",
       "      <td>24228.0</td>\n",
       "      <td>68.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>41201</td>\n",
       "      <td>Freha</td>\n",
       "      <td>1920</td>\n",
       "      <td>ZA04</td>\n",
       "      <td>A000</td>\n",
       "      <td>DD</td>\n",
       "      <td>10</td>\n",
       "      <td>Monsieur</td>\n",
       "      <td>1104091.0</td>\n",
       "      <td>SALEMKOUR BESSAM</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>0.429676</td>\n",
       "      <td>4893.812806</td>\n",
       "      <td>4909.646522</td>\n",
       "      <td>1471.318190</td>\n",
       "      <td>14332.0</td>\n",
       "      <td>380</td>\n",
       "      <td>Freha</td>\n",
       "      <td>24228.0</td>\n",
       "      <td>68.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>41524</td>\n",
       "      <td>Larba Nait Irathen</td>\n",
       "      <td>3891</td>\n",
       "      <td>ZA04</td>\n",
       "      <td>A000</td>\n",
       "      <td>DD</td>\n",
       "      <td>10</td>\n",
       "      <td>Monsieur</td>\n",
       "      <td>1104425.0</td>\n",
       "      <td>DJEMA HOCINE</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>7.235475</td>\n",
       "      <td>8566.522060</td>\n",
       "      <td>8645.668051</td>\n",
       "      <td>2246.748165</td>\n",
       "      <td>31082.0</td>\n",
       "      <td>128</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>38185</td>\n",
       "      <td>Makouda</td>\n",
       "      <td>5176</td>\n",
       "      <td>ZA04</td>\n",
       "      <td>A000</td>\n",
       "      <td>DD</td>\n",
       "      <td>10</td>\n",
       "      <td>Monsieur</td>\n",
       "      <td>1100467.0</td>\n",
       "      <td>BOURAYA HOCINE</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>8.024678</td>\n",
       "      <td>2647.730387</td>\n",
       "      <td>2679.973191</td>\n",
       "      <td>707.840590</td>\n",
       "      <td>9596.0</td>\n",
       "      <td>925</td>\n",
       "      <td>Makouda</td>\n",
       "      <td>23388.0</td>\n",
       "      <td>57.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>56171</td>\n",
       "      <td>Mekla</td>\n",
       "      <td>3625</td>\n",
       "      <td>ZA04</td>\n",
       "      <td>A000</td>\n",
       "      <td>DD</td>\n",
       "      <td>10</td>\n",
       "      <td>Monsieur</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CHEHRITE RABAH</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>8.024678</td>\n",
       "      <td>6383.224049</td>\n",
       "      <td>6445.065314</td>\n",
       "      <td>1103.456980</td>\n",
       "      <td>19396.0</td>\n",
       "      <td>228</td>\n",
       "      <td>Mekla</td>\n",
       "      <td>24237.0</td>\n",
       "      <td>64.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>46060</td>\n",
       "      <td>Tigzirt</td>\n",
       "      <td>5052</td>\n",
       "      <td>ZA04</td>\n",
       "      <td>A000</td>\n",
       "      <td>DD</td>\n",
       "      <td>10</td>\n",
       "      <td>Société</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TIZI LUNCH</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>3.012929</td>\n",
       "      <td>4572.627916</td>\n",
       "      <td>4634.294336</td>\n",
       "      <td>1217.190120</td>\n",
       "      <td>13360.0</td>\n",
       "      <td>422</td>\n",
       "      <td>Tigzirt</td>\n",
       "      <td>11962.0</td>\n",
       "      <td>41.68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>41152</td>\n",
       "      <td>Tizi Ouzou</td>\n",
       "      <td>271</td>\n",
       "      <td>ZA04</td>\n",
       "      <td>A000</td>\n",
       "      <td>DD</td>\n",
       "      <td>10</td>\n",
       "      <td>Monsieur</td>\n",
       "      <td>1104033.0</td>\n",
       "      <td>TOUZOUTI LYES</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>0.598761</td>\n",
       "      <td>5367.373501</td>\n",
       "      <td>5434.291977</td>\n",
       "      <td>1457.962130</td>\n",
       "      <td>26442.0</td>\n",
       "      <td>316</td>\n",
       "      <td>Tizi Ouzou</td>\n",
       "      <td>135088.0</td>\n",
       "      <td>102.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>42084</td>\n",
       "      <td>Tizi Ouzou</td>\n",
       "      <td>3375</td>\n",
       "      <td>ZA04</td>\n",
       "      <td>A000</td>\n",
       "      <td>DD</td>\n",
       "      <td>10</td>\n",
       "      <td>Monsieur</td>\n",
       "      <td>1158497.0</td>\n",
       "      <td>MAHMOUDI NOURDINE 2</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>0.598761</td>\n",
       "      <td>4506.365966</td>\n",
       "      <td>4551.141600</td>\n",
       "      <td>1116.224040</td>\n",
       "      <td>15822.0</td>\n",
       "      <td>430</td>\n",
       "      <td>Tizi Ouzou</td>\n",
       "      <td>135088.0</td>\n",
       "      <td>102.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>38173</td>\n",
       "      <td>Tizi Ouzou</td>\n",
       "      <td>1058</td>\n",
       "      <td>ZA04</td>\n",
       "      <td>A000</td>\n",
       "      <td>DD</td>\n",
       "      <td>10</td>\n",
       "      <td>Monsieur</td>\n",
       "      <td>1100455.0</td>\n",
       "      <td>LAGAB  Brahim</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>2.692850</td>\n",
       "      <td>3994.043371</td>\n",
       "      <td>4037.172133</td>\n",
       "      <td>1096.041140</td>\n",
       "      <td>12924.0</td>\n",
       "      <td>512</td>\n",
       "      <td>Tizi Ouzou</td>\n",
       "      <td>135088.0</td>\n",
       "      <td>102.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>42695</td>\n",
       "      <td>Tizi Ouzou</td>\n",
       "      <td>777</td>\n",
       "      <td>ZA04</td>\n",
       "      <td>A000</td>\n",
       "      <td>DD</td>\n",
       "      <td>10</td>\n",
       "      <td>Société</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SARL CATPHORE</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.429676</td>\n",
       "      <td>3791.127675</td>\n",
       "      <td>3860.720946</td>\n",
       "      <td>957.452520</td>\n",
       "      <td>15498.0</td>\n",
       "      <td>550</td>\n",
       "      <td>Tizi Ouzou</td>\n",
       "      <td>135088.0</td>\n",
       "      <td>102.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>38739</td>\n",
       "      <td>Tizi Ouzou</td>\n",
       "      <td>40</td>\n",
       "      <td>ZA04</td>\n",
       "      <td>A000</td>\n",
       "      <td>DD</td>\n",
       "      <td>10</td>\n",
       "      <td>Monsieur</td>\n",
       "      <td>1101034.0</td>\n",
       "      <td>AIT MOHAMED MAHFOUD</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>0.598761</td>\n",
       "      <td>3313.945136</td>\n",
       "      <td>3345.146999</td>\n",
       "      <td>889.513930</td>\n",
       "      <td>11530.0</td>\n",
       "      <td>675</td>\n",
       "      <td>Tizi Ouzou</td>\n",
       "      <td>135088.0</td>\n",
       "      <td>102.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>41156</td>\n",
       "      <td>Tizi Ouzou</td>\n",
       "      <td>3312</td>\n",
       "      <td>ZA04</td>\n",
       "      <td>A000</td>\n",
       "      <td>DD</td>\n",
       "      <td>10</td>\n",
       "      <td>Monsieur</td>\n",
       "      <td>1104038.0</td>\n",
       "      <td>TWELVE</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>0.598761</td>\n",
       "      <td>2229.143366</td>\n",
       "      <td>2299.244746</td>\n",
       "      <td>441.243090</td>\n",
       "      <td>8324.0</td>\n",
       "      <td>1109</td>\n",
       "      <td>Tizi Ouzou</td>\n",
       "      <td>135088.0</td>\n",
       "      <td>102.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>38041</td>\n",
       "      <td>Tizi Ouzou</td>\n",
       "      <td>2906</td>\n",
       "      <td>ZA04</td>\n",
       "      <td>A000</td>\n",
       "      <td>DD</td>\n",
       "      <td>10</td>\n",
       "      <td>Monsieur</td>\n",
       "      <td>1100318.0</td>\n",
       "      <td>TAHRAOUI YOUCEF</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.598761</td>\n",
       "      <td>1921.060676</td>\n",
       "      <td>1953.826394</td>\n",
       "      <td>580.493265</td>\n",
       "      <td>6366.0</td>\n",
       "      <td>1275</td>\n",
       "      <td>Tizi Ouzou</td>\n",
       "      <td>135088.0</td>\n",
       "      <td>102.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>40198</td>\n",
       "      <td>Tizi Rached</td>\n",
       "      <td>4833</td>\n",
       "      <td>ZA04</td>\n",
       "      <td>A000</td>\n",
       "      <td>DD</td>\n",
       "      <td>10</td>\n",
       "      <td>Monsieur</td>\n",
       "      <td>1102513.0</td>\n",
       "      <td>Hidous Yazid</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0.598761</td>\n",
       "      <td>3944.378472</td>\n",
       "      <td>3994.798621</td>\n",
       "      <td>1029.770315</td>\n",
       "      <td>15808.0</td>\n",
       "      <td>521</td>\n",
       "      <td>Tizi Rached</td>\n",
       "      <td>17161.0</td>\n",
       "      <td>31.05</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>18 rows × 96 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    CUSTOMER_COD             ADM2_EN  Unnamed: 0 Groupe OrgCm CDis  SA  \\\n",
       "0          37832       Ain El Hammam        3113   ZA04  A000   DD  10   \n",
       "1          38867              Azazga        1634   ZA04  A000   DD  10   \n",
       "2          52322         Beni Douala        4867   ZA04  A000   DD  10   \n",
       "3          54407            Bouzguen        4693   ZA04  A000   DD  10   \n",
       "4          52393               Freha         236   ZA04  A000   DD  10   \n",
       "5          41201               Freha        1920   ZA04  A000   DD  10   \n",
       "6          41524  Larba Nait Irathen        3891   ZA04  A000   DD  10   \n",
       "7          38185             Makouda        5176   ZA04  A000   DD  10   \n",
       "8          56171               Mekla        3625   ZA04  A000   DD  10   \n",
       "9          46060             Tigzirt        5052   ZA04  A000   DD  10   \n",
       "10         41152          Tizi Ouzou         271   ZA04  A000   DD  10   \n",
       "11         42084          Tizi Ouzou        3375   ZA04  A000   DD  10   \n",
       "12         38173          Tizi Ouzou        1058   ZA04  A000   DD  10   \n",
       "13         42695          Tizi Ouzou         777   ZA04  A000   DD  10   \n",
       "14         38739          Tizi Ouzou          40   ZA04  A000   DD  10   \n",
       "15         41156          Tizi Ouzou        3312   ZA04  A000   DD  10   \n",
       "16         38041          Tizi Ouzou        2906   ZA04  A000   DD  10   \n",
       "17         40198         Tizi Rached        4833   ZA04  A000   DD  10   \n",
       "\n",
       "       Titre  Anc.Client                  Nom  ... osm_count   dist_km  \\\n",
       "0   Monsieur   1100108.0           CHABA AKLI  ...         9  0.598761   \n",
       "1   Monsieur   1101163.0        OUGACHE KAMEL  ...         2  0.429676   \n",
       "2   Monsieur         NaN       LADJADJ MOURAD  ...         0  4.623919   \n",
       "3   Monsieur         NaN         MOUDJEB AMAR  ...         2  0.598761   \n",
       "4   Monsieur         NaN          MALLEK IDIR  ...         0  5.191190   \n",
       "5   Monsieur   1104091.0     SALEMKOUR BESSAM  ...        10  0.429676   \n",
       "6   Monsieur   1104425.0         DJEMA HOCINE  ...         8  7.235475   \n",
       "7   Monsieur   1100467.0       BOURAYA HOCINE  ...         0  8.024678   \n",
       "8   Monsieur         NaN       CHEHRITE RABAH  ...         0  8.024678   \n",
       "9    Société         NaN           TIZI LUNCH  ...         0  3.012929   \n",
       "10  Monsieur   1104033.0        TOUZOUTI LYES  ...         6  0.598761   \n",
       "11  Monsieur   1158497.0  MAHMOUDI NOURDINE 2  ...         9  0.598761   \n",
       "12  Monsieur   1100455.0        LAGAB  Brahim  ...         9  2.692850   \n",
       "13   Société         NaN        SARL CATPHORE  ...         0  0.429676   \n",
       "14  Monsieur   1101034.0  AIT MOHAMED MAHFOUD  ...         2  0.598761   \n",
       "15  Monsieur   1104038.0               TWELVE  ...         3  0.598761   \n",
       "16  Monsieur   1100318.0      TAHRAOUI YOUCEF  ...         0  0.598761   \n",
       "17  Monsieur   1102513.0         Hidous Yazid  ...         1  0.598761   \n",
       "\n",
       "            NSR          GSR   UNIT_CASES TRANSACTIONS  NSR_rank  \\\n",
       "0   2865.209961  2898.154748   757.326700       9380.0       821   \n",
       "1   1257.254905  1275.350501   285.258685       5790.0      1796   \n",
       "2   4323.772863  4361.556065  1183.367765      13980.0       455   \n",
       "3   3131.501270  3163.239883   920.662940       8678.0       724   \n",
       "4   6345.284588  6414.487029  1547.466735      23154.0       233   \n",
       "5   4893.812806  4909.646522  1471.318190      14332.0       380   \n",
       "6   8566.522060  8645.668051  2246.748165      31082.0       128   \n",
       "7   2647.730387  2679.973191   707.840590       9596.0       925   \n",
       "8   6383.224049  6445.065314  1103.456980      19396.0       228   \n",
       "9   4572.627916  4634.294336  1217.190120      13360.0       422   \n",
       "10  5367.373501  5434.291977  1457.962130      26442.0       316   \n",
       "11  4506.365966  4551.141600  1116.224040      15822.0       430   \n",
       "12  3994.043371  4037.172133  1096.041140      12924.0       512   \n",
       "13  3791.127675  3860.720946   957.452520      15498.0       550   \n",
       "14  3313.945136  3345.146999   889.513930      11530.0       675   \n",
       "15  2229.143366  2299.244746   441.243090       8324.0      1109   \n",
       "16  1921.060676  1953.826394   580.493265       6366.0      1275   \n",
       "17  3944.378472  3994.798621  1029.770315      15808.0       521   \n",
       "\n",
       "        Commune_y  urba_gov_Population  urba_gov_Superficie  \n",
       "0   Ain El Hammam              20401.0                38.55  \n",
       "1          Azazga              34683.0                77.05  \n",
       "2     Beni Douala              21551.0                35.08  \n",
       "3             NaN                  NaN                  NaN  \n",
       "4           Freha              24228.0                68.55  \n",
       "5           Freha              24228.0                68.55  \n",
       "6             NaN                  NaN                  NaN  \n",
       "7         Makouda              23388.0                57.43  \n",
       "8           Mekla              24237.0                64.71  \n",
       "9         Tigzirt              11962.0                41.68  \n",
       "10     Tizi Ouzou             135088.0               102.36  \n",
       "11     Tizi Ouzou             135088.0               102.36  \n",
       "12     Tizi Ouzou             135088.0               102.36  \n",
       "13     Tizi Ouzou             135088.0               102.36  \n",
       "14     Tizi Ouzou             135088.0               102.36  \n",
       "15     Tizi Ouzou             135088.0               102.36  \n",
       "16     Tizi Ouzou             135088.0               102.36  \n",
       "17    Tizi Rached              17161.0                31.05  \n",
       "\n",
       "[18 rows x 96 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "subset_thresh = form_subset(\n",
    "  data=subset_horeca, \n",
    "  group_var='ADM2_EN', \n",
    "  equal_brackets=0, \n",
    "  top_field='NSR',\n",
    "  sample_size=100,\n",
    "  gold_portion=0.15,\n",
    "  bronze_portion=0.1\n",
    ")\n",
    " \n",
    "subset_thresh"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8a75015e",
   "metadata": {},
   "source": [
    "# Form a subset to validate TA matching against"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "032ae007",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Number of items proportionate to group size!\n"
     ]
    }
   ],
   "source": [
    "# 1) Build selector\n",
    "select_number = construct_selector(subset_horeca,\n",
    "                                   equal_brackets=0,\n",
    "                                   sample_size=225,\n",
    "                                   gold_portion=0.2,\n",
    "                                   bronze_portion=0,\n",
    "                                   )\n",
    "\n",
    "select_gold =  round(select_number['n_gold']).astype(int)\n",
    "select_silver =  round(select_number['n_silver']).astype(int)\n",
    "select_bronze =  round(select_number['n_bronze']).astype(int)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "543b7a0c",
   "metadata": {},
   "outputs": [],
   "source": [
    "# 2 define parameters\n",
    "TIER=\"Classification client\"\n",
    "group_var=\"ADM2_EN\"\n",
    "top_field_short='NSR_rank'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "98a6cd28",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(22, 96)"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 3) Form  subset \n",
    "# 3.1) gold set\n",
    "gold=lambda dfg: dfg.nsmallest(select_gold[dfg.name], columns=top_field_short)\n",
    "gold = subset_horeca.loc[subset_horeca[TIER]=='Gold'].groupby(group_var).apply(gold).reset_index(drop =True)\n",
    "gold.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "d6812ff9",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(0, 96)"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 3.1) bronze set\n",
    "bronze=lambda dfg: dfg.nsmallest(select_bronze[dfg.name], columns=top_field_short)\n",
    "bronze= subset_horeca.loc[subset_horeca[TIER]=='Bronze'].groupby(group_var).apply(bronze).reset_index(drop =True)\n",
    "bronze.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "3e4b321e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(176, 96)"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "silver=lambda dfg: dfg.nsmallest(select_silver[dfg.name], columns=top_field_short)\n",
    "silver= subset_horeca.loc[subset_horeca[TIER]=='Silver'].groupby(group_var).apply(silver).reset_index(drop =True)\n",
    "silver.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "fe20413a",
   "metadata": {},
   "outputs": [],
   "source": [
    "subset_thresh =gold.append(silver).append(bronze).sort_values(by=[group_var, TIER])"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f165ceea",
   "metadata": {},
   "source": [
    "# Set stats\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "04b5c90b",
   "metadata": {},
   "source": [
    "### Subset Breakdowns\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "49c17f2b",
   "metadata": {},
   "outputs": [],
   "source": [
    "pd.set_option('display.float_format', lambda x: '%.2f' % x)\n",
    "pd.options.display.max_rows = 100\n",
    "pd.options.display.max_columns= 100"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "25b6ed4c",
   "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>ADM2_EN</th>\n",
       "      <th>Abi Youcef</th>\n",
       "      <th>Aghni Goughran</th>\n",
       "      <th>Aghrib</th>\n",
       "      <th>Ain El Hammam</th>\n",
       "      <th>Ain Zaouia</th>\n",
       "      <th>Ait Aissa Mimoun</th>\n",
       "      <th>Ait Bouadou</th>\n",
       "      <th>Ait Khelili</th>\n",
       "      <th>Ait Mahmoud</th>\n",
       "      <th>Ait Toudert</th>\n",
       "      <th>Ait Yahia</th>\n",
       "      <th>Ait Yahia Moussa</th>\n",
       "      <th>Azazga</th>\n",
       "      <th>Azeffoun</th>\n",
       "      <th>Beni Aissi</th>\n",
       "      <th>Beni Douala</th>\n",
       "      <th>Beni Yenni</th>\n",
       "      <th>Beni Zmenzer</th>\n",
       "      <th>Boghni</th>\n",
       "      <th>Boudjima</th>\n",
       "      <th>Bounouh</th>\n",
       "      <th>Bouzguen</th>\n",
       "      <th>Draa Ben Khedda</th>\n",
       "      <th>Draa El Mizan</th>\n",
       "      <th>Freha</th>\n",
       "      <th>Iboudraren</th>\n",
       "      <th>Idjeur</th>\n",
       "      <th>Iferhounene</th>\n",
       "      <th>Ifigha</th>\n",
       "      <th>Iflissen</th>\n",
       "      <th>Iloula Oumalou</th>\n",
       "      <th>Irdjen</th>\n",
       "      <th>Larba Nait Irathen</th>\n",
       "      <th>Maatka</th>\n",
       "      <th>Makouda</th>\n",
       "      <th>Mechtrass</th>\n",
       "      <th>Mekla</th>\n",
       "      <th>Mizrana</th>\n",
       "      <th>Ouacif</th>\n",
       "      <th>Ouadhia</th>\n",
       "      <th>Ouaguenoun</th>\n",
       "      <th>Sidi Naamane</th>\n",
       "      <th>Souamaa</th>\n",
       "      <th>Tadmait</th>\n",
       "      <th>Tigzirt</th>\n",
       "      <th>Timizart</th>\n",
       "      <th>Tirmitine</th>\n",
       "      <th>Tizi N'Thleta</th>\n",
       "      <th>Tizi Ouzou</th>\n",
       "      <th>Tizi Rached</th>\n",
       "      <th>Yakouren</th>\n",
       "      <th>All</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Classification client</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",
       "      <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",
       "      <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>All</th>\n",
       "      <td>1.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>4.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>8.00</td>\n",
       "      <td>3.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>5.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>6.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>6.00</td>\n",
       "      <td>11.00</td>\n",
       "      <td>4.00</td>\n",
       "      <td>11.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>5.00</td>\n",
       "      <td>3.00</td>\n",
       "      <td>6.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>6.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>6.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>4.00</td>\n",
       "      <td>7.00</td>\n",
       "      <td>3.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>52.00</td>\n",
       "      <td>5.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>198</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Silver</th>\n",
       "      <td>1.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>3.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>7.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>4.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>6.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>5.00</td>\n",
       "      <td>11.00</td>\n",
       "      <td>4.00</td>\n",
       "      <td>9.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>4.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>5.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>5.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>6.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>4.00</td>\n",
       "      <td>6.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>44.00</td>\n",
       "      <td>4.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>176</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gold</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>8.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "ADM2_EN                Abi Youcef  Aghni Goughran  Aghrib  Ain El Hammam  \\\n",
       "Classification client                                                      \n",
       "All                          1.00            1.00    1.00           4.00   \n",
       "Silver                       1.00            1.00    1.00           3.00   \n",
       "Gold                         0.00            0.00    0.00           1.00   \n",
       "\n",
       "ADM2_EN                Ain Zaouia  Ait Aissa Mimoun  Ait Bouadou  Ait Khelili  \\\n",
       "Classification client                                                           \n",
       "All                          1.00              2.00         2.00         1.00   \n",
       "Silver                       1.00              2.00         2.00         1.00   \n",
       "Gold                         0.00              0.00         0.00         0.00   \n",
       "\n",
       "ADM2_EN                Ait Mahmoud  Ait Toudert  Ait Yahia  Ait Yahia Moussa  \\\n",
       "Classification client                                                          \n",
       "All                           1.00         1.00       1.00              1.00   \n",
       "Silver                        1.00         1.00       1.00              1.00   \n",
       "Gold                          0.00         0.00       0.00              0.00   \n",
       "\n",
       "ADM2_EN                Azazga  Azeffoun  Beni Aissi  Beni Douala  Beni Yenni  \\\n",
       "Classification client                                                          \n",
       "All                      8.00      3.00        2.00         5.00        1.00   \n",
       "Silver                   7.00      2.00        2.00         4.00        1.00   \n",
       "Gold                     1.00      1.00        0.00         1.00        0.00   \n",
       "\n",
       "ADM2_EN                Beni Zmenzer  Boghni  Boudjima  Bounouh  Bouzguen  \\\n",
       "Classification client                                                      \n",
       "All                            1.00    6.00      2.00     1.00      6.00   \n",
       "Silver                         1.00    6.00      2.00     1.00      5.00   \n",
       "Gold                           0.00    0.00      0.00     0.00      1.00   \n",
       "\n",
       "ADM2_EN                Draa Ben Khedda  Draa El Mizan  Freha  Iboudraren  \\\n",
       "Classification client                                                      \n",
       "All                              11.00           4.00  11.00        1.00   \n",
       "Silver                           11.00           4.00   9.00        1.00   \n",
       "Gold                              0.00           0.00   2.00        0.00   \n",
       "\n",
       "ADM2_EN                Idjeur  Iferhounene  Ifigha  Iflissen  Iloula Oumalou  \\\n",
       "Classification client                                                          \n",
       "All                      1.00         1.00    1.00      2.00            1.00   \n",
       "Silver                   1.00         1.00    1.00      2.00            1.00   \n",
       "Gold                     0.00         0.00    0.00      0.00            0.00   \n",
       "\n",
       "ADM2_EN                Irdjen  Larba Nait Irathen  Maatka  Makouda  Mechtrass  \\\n",
       "Classification client                                                           \n",
       "All                      2.00                5.00    3.00     6.00       1.00   \n",
       "Silver                   2.00                4.00    2.00     5.00       1.00   \n",
       "Gold                     0.00                1.00    1.00     1.00       0.00   \n",
       "\n",
       "ADM2_EN                Mekla  Mizrana  Ouacif  Ouadhia  Ouaguenoun  \\\n",
       "Classification client                                                \n",
       "All                     6.00     1.00    2.00     6.00        2.00   \n",
       "Silver                  5.00     1.00    2.00     6.00        2.00   \n",
       "Gold                    1.00     0.00    0.00     0.00        0.00   \n",
       "\n",
       "ADM2_EN                Sidi Naamane  Souamaa  Tadmait  Tigzirt  Timizart  \\\n",
       "Classification client                                                      \n",
       "All                            2.00     1.00     4.00     7.00      3.00   \n",
       "Silver                         2.00     1.00     4.00     6.00      2.00   \n",
       "Gold                           0.00     0.00     0.00     1.00      1.00   \n",
       "\n",
       "ADM2_EN                Tirmitine  Tizi N'Thleta  Tizi Ouzou  Tizi Rached  \\\n",
       "Classification client                                                      \n",
       "All                         2.00           1.00       52.00         5.00   \n",
       "Silver                      2.00           1.00       44.00         4.00   \n",
       "Gold                        0.00           0.00        8.00         1.00   \n",
       "\n",
       "ADM2_EN                Yakouren  All  \n",
       "Classification client                 \n",
       "All                        2.00  198  \n",
       "Silver                     2.00  176  \n",
       "Gold                       0.00   22  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Tier\n",
    "pd.crosstab(subset_thresh[TIER], subset_thresh['ADM2_EN'], values=subset_thresh[\"CUSTOMER_COD\"], aggfunc='count', margins=True). \\\n",
    "  sort_values(by=['All'], ascending=False).fillna(0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "d359136d",
   "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>ADM2_EN</th>\n",
       "      <th>Abi Youcef</th>\n",
       "      <th>Aghni Goughran</th>\n",
       "      <th>Aghrib</th>\n",
       "      <th>Ain El Hammam</th>\n",
       "      <th>Ain Zaouia</th>\n",
       "      <th>Ait Aissa Mimoun</th>\n",
       "      <th>Ait Bouadou</th>\n",
       "      <th>Ait Khelili</th>\n",
       "      <th>Ait Mahmoud</th>\n",
       "      <th>Ait Toudert</th>\n",
       "      <th>Ait Yahia</th>\n",
       "      <th>Ait Yahia Moussa</th>\n",
       "      <th>Azazga</th>\n",
       "      <th>Azeffoun</th>\n",
       "      <th>Beni Aissi</th>\n",
       "      <th>Beni Douala</th>\n",
       "      <th>Beni Yenni</th>\n",
       "      <th>Beni Zmenzer</th>\n",
       "      <th>Boghni</th>\n",
       "      <th>Boudjima</th>\n",
       "      <th>Bounouh</th>\n",
       "      <th>Bouzguen</th>\n",
       "      <th>Draa Ben Khedda</th>\n",
       "      <th>Draa El Mizan</th>\n",
       "      <th>Freha</th>\n",
       "      <th>Iboudraren</th>\n",
       "      <th>Idjeur</th>\n",
       "      <th>Iferhounene</th>\n",
       "      <th>Ifigha</th>\n",
       "      <th>Iflissen</th>\n",
       "      <th>Iloula Oumalou</th>\n",
       "      <th>Irdjen</th>\n",
       "      <th>Larba Nait Irathen</th>\n",
       "      <th>Maatka</th>\n",
       "      <th>Makouda</th>\n",
       "      <th>Mechtrass</th>\n",
       "      <th>Mekla</th>\n",
       "      <th>Mizrana</th>\n",
       "      <th>Ouacif</th>\n",
       "      <th>Ouadhia</th>\n",
       "      <th>Ouaguenoun</th>\n",
       "      <th>Sidi Naamane</th>\n",
       "      <th>Souamaa</th>\n",
       "      <th>Tadmait</th>\n",
       "      <th>Tigzirt</th>\n",
       "      <th>Timizart</th>\n",
       "      <th>Tirmitine</th>\n",
       "      <th>Tizi N'Thleta</th>\n",
       "      <th>Tizi Ouzou</th>\n",
       "      <th>Tizi Rached</th>\n",
       "      <th>Yakouren</th>\n",
       "      <th>All</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Classification client</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",
       "      <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",
       "      <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>All</th>\n",
       "      <td>1583.11</td>\n",
       "      <td>470.19</td>\n",
       "      <td>2389.12</td>\n",
       "      <td>11517.47</td>\n",
       "      <td>3417.51</td>\n",
       "      <td>6293.85</td>\n",
       "      <td>2818.95</td>\n",
       "      <td>1458.68</td>\n",
       "      <td>356.49</td>\n",
       "      <td>1188.42</td>\n",
       "      <td>2583.98</td>\n",
       "      <td>95.97</td>\n",
       "      <td>10491.74</td>\n",
       "      <td>2177.99</td>\n",
       "      <td>6357.39</td>\n",
       "      <td>12759.05</td>\n",
       "      <td>847.98</td>\n",
       "      <td>1056.58</td>\n",
       "      <td>11799.90</td>\n",
       "      <td>4826.13</td>\n",
       "      <td>1400.07</td>\n",
       "      <td>21289.39</td>\n",
       "      <td>8714.89</td>\n",
       "      <td>4309.16</td>\n",
       "      <td>38437.19</td>\n",
       "      <td>1060.65</td>\n",
       "      <td>3024.87</td>\n",
       "      <td>1120.05</td>\n",
       "      <td>1696.65</td>\n",
       "      <td>4854.49</td>\n",
       "      <td>859.01</td>\n",
       "      <td>5678.12</td>\n",
       "      <td>16785.32</td>\n",
       "      <td>3524.41</td>\n",
       "      <td>12281.27</td>\n",
       "      <td>1625.05</td>\n",
       "      <td>15148.87</td>\n",
       "      <td>2532.91</td>\n",
       "      <td>4042.41</td>\n",
       "      <td>14469.52</td>\n",
       "      <td>2766.83</td>\n",
       "      <td>1129.71</td>\n",
       "      <td>210.13</td>\n",
       "      <td>4095.52</td>\n",
       "      <td>18894.66</td>\n",
       "      <td>8169.39</td>\n",
       "      <td>4118.50</td>\n",
       "      <td>783.63</td>\n",
       "      <td>112961.84</td>\n",
       "      <td>10033.72</td>\n",
       "      <td>1190.31</td>\n",
       "      <td>411699.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Silver</th>\n",
       "      <td>1583.11</td>\n",
       "      <td>470.19</td>\n",
       "      <td>2389.12</td>\n",
       "      <td>8652.26</td>\n",
       "      <td>3417.51</td>\n",
       "      <td>6293.85</td>\n",
       "      <td>2818.95</td>\n",
       "      <td>1458.68</td>\n",
       "      <td>356.49</td>\n",
       "      <td>1188.42</td>\n",
       "      <td>2583.98</td>\n",
       "      <td>95.97</td>\n",
       "      <td>9234.49</td>\n",
       "      <td>1939.12</td>\n",
       "      <td>6357.39</td>\n",
       "      <td>8435.28</td>\n",
       "      <td>847.98</td>\n",
       "      <td>1056.58</td>\n",
       "      <td>11799.90</td>\n",
       "      <td>4826.13</td>\n",
       "      <td>1400.07</td>\n",
       "      <td>18157.89</td>\n",
       "      <td>8714.89</td>\n",
       "      <td>4309.16</td>\n",
       "      <td>27198.10</td>\n",
       "      <td>1060.65</td>\n",
       "      <td>3024.87</td>\n",
       "      <td>1120.05</td>\n",
       "      <td>1696.65</td>\n",
       "      <td>4854.49</td>\n",
       "      <td>859.01</td>\n",
       "      <td>5678.12</td>\n",
       "      <td>8218.79</td>\n",
       "      <td>2454.31</td>\n",
       "      <td>9633.54</td>\n",
       "      <td>1625.05</td>\n",
       "      <td>8765.64</td>\n",
       "      <td>2532.91</td>\n",
       "      <td>4042.41</td>\n",
       "      <td>14469.52</td>\n",
       "      <td>2766.83</td>\n",
       "      <td>1129.71</td>\n",
       "      <td>210.13</td>\n",
       "      <td>4095.52</td>\n",
       "      <td>14322.03</td>\n",
       "      <td>4158.42</td>\n",
       "      <td>4118.50</td>\n",
       "      <td>783.63</td>\n",
       "      <td>86746.48</td>\n",
       "      <td>6089.34</td>\n",
       "      <td>1190.31</td>\n",
       "      <td>331232.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gold</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2865.21</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1257.25</td>\n",
       "      <td>238.87</td>\n",
       "      <td>0.00</td>\n",
       "      <td>4323.77</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>3131.50</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>11239.10</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>8566.52</td>\n",
       "      <td>1070.10</td>\n",
       "      <td>2647.73</td>\n",
       "      <td>0.00</td>\n",
       "      <td>6383.22</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>4572.63</td>\n",
       "      <td>4010.97</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>26215.37</td>\n",
       "      <td>3944.38</td>\n",
       "      <td>0.00</td>\n",
       "      <td>80466.63</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "ADM2_EN                Abi Youcef  Aghni Goughran  Aghrib  Ain El Hammam  \\\n",
       "Classification client                                                      \n",
       "All                       1583.11          470.19 2389.12       11517.47   \n",
       "Silver                    1583.11          470.19 2389.12        8652.26   \n",
       "Gold                         0.00            0.00    0.00        2865.21   \n",
       "\n",
       "ADM2_EN                Ain Zaouia  Ait Aissa Mimoun  Ait Bouadou  Ait Khelili  \\\n",
       "Classification client                                                           \n",
       "All                       3417.51           6293.85      2818.95      1458.68   \n",
       "Silver                    3417.51           6293.85      2818.95      1458.68   \n",
       "Gold                         0.00              0.00         0.00         0.00   \n",
       "\n",
       "ADM2_EN                Ait Mahmoud  Ait Toudert  Ait Yahia  Ait Yahia Moussa  \\\n",
       "Classification client                                                          \n",
       "All                         356.49      1188.42    2583.98             95.97   \n",
       "Silver                      356.49      1188.42    2583.98             95.97   \n",
       "Gold                          0.00         0.00       0.00              0.00   \n",
       "\n",
       "ADM2_EN                 Azazga  Azeffoun  Beni Aissi  Beni Douala  Beni Yenni  \\\n",
       "Classification client                                                           \n",
       "All                   10491.74   2177.99     6357.39     12759.05      847.98   \n",
       "Silver                 9234.49   1939.12     6357.39      8435.28      847.98   \n",
       "Gold                   1257.25    238.87        0.00      4323.77        0.00   \n",
       "\n",
       "ADM2_EN                Beni Zmenzer   Boghni  Boudjima  Bounouh  Bouzguen  \\\n",
       "Classification client                                                       \n",
       "All                         1056.58 11799.90   4826.13  1400.07  21289.39   \n",
       "Silver                      1056.58 11799.90   4826.13  1400.07  18157.89   \n",
       "Gold                           0.00     0.00      0.00     0.00   3131.50   \n",
       "\n",
       "ADM2_EN                Draa Ben Khedda  Draa El Mizan    Freha  Iboudraren  \\\n",
       "Classification client                                                        \n",
       "All                            8714.89        4309.16 38437.19     1060.65   \n",
       "Silver                         8714.89        4309.16 27198.10     1060.65   \n",
       "Gold                              0.00           0.00 11239.10        0.00   \n",
       "\n",
       "ADM2_EN                Idjeur  Iferhounene  Ifigha  Iflissen  Iloula Oumalou  \\\n",
       "Classification client                                                          \n",
       "All                   3024.87      1120.05 1696.65   4854.49          859.01   \n",
       "Silver                3024.87      1120.05 1696.65   4854.49          859.01   \n",
       "Gold                     0.00         0.00    0.00      0.00            0.00   \n",
       "\n",
       "ADM2_EN                Irdjen  Larba Nait Irathen  Maatka  Makouda  Mechtrass  \\\n",
       "Classification client                                                           \n",
       "All                   5678.12            16785.32 3524.41 12281.27    1625.05   \n",
       "Silver                5678.12             8218.79 2454.31  9633.54    1625.05   \n",
       "Gold                     0.00             8566.52 1070.10  2647.73       0.00   \n",
       "\n",
       "ADM2_EN                  Mekla  Mizrana  Ouacif  Ouadhia  Ouaguenoun  \\\n",
       "Classification client                                                  \n",
       "All                   15148.87  2532.91 4042.41 14469.52     2766.83   \n",
       "Silver                 8765.64  2532.91 4042.41 14469.52     2766.83   \n",
       "Gold                   6383.22     0.00    0.00     0.00        0.00   \n",
       "\n",
       "ADM2_EN                Sidi Naamane  Souamaa  Tadmait  Tigzirt  Timizart  \\\n",
       "Classification client                                                      \n",
       "All                         1129.71   210.13  4095.52 18894.66   8169.39   \n",
       "Silver                      1129.71   210.13  4095.52 14322.03   4158.42   \n",
       "Gold                           0.00     0.00     0.00  4572.63   4010.97   \n",
       "\n",
       "ADM2_EN                Tirmitine  Tizi N'Thleta  Tizi Ouzou  Tizi Rached  \\\n",
       "Classification client                                                      \n",
       "All                      4118.50         783.63   112961.84     10033.72   \n",
       "Silver                   4118.50         783.63    86746.48      6089.34   \n",
       "Gold                        0.00           0.00    26215.37      3944.38   \n",
       "\n",
       "ADM2_EN                Yakouren       All  \n",
       "Classification client                      \n",
       "All                     1190.31 411699.06  \n",
       "Silver                  1190.31 331232.43  \n",
       "Gold                       0.00  80466.63  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Total NSR by tier\n",
    "pd.crosstab(subset_thresh[TIER], subset_thresh['ADM2_EN'], values=subset_thresh['NSR'], aggfunc='sum', margins=True). \\\n",
    "  sort_values(by=['All'], ascending=False).fillna(0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "b8f60362",
   "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>ADM2_EN</th>\n",
       "      <th>Abi Youcef</th>\n",
       "      <th>Aghni Goughran</th>\n",
       "      <th>Aghrib</th>\n",
       "      <th>Ain El Hammam</th>\n",
       "      <th>Ain Zaouia</th>\n",
       "      <th>Ait Aissa Mimoun</th>\n",
       "      <th>Ait Bouadou</th>\n",
       "      <th>Ait Khelili</th>\n",
       "      <th>Ait Mahmoud</th>\n",
       "      <th>Ait Toudert</th>\n",
       "      <th>Ait Yahia</th>\n",
       "      <th>Ait Yahia Moussa</th>\n",
       "      <th>Azazga</th>\n",
       "      <th>Azeffoun</th>\n",
       "      <th>Beni Aissi</th>\n",
       "      <th>Beni Douala</th>\n",
       "      <th>Beni Yenni</th>\n",
       "      <th>Beni Zmenzer</th>\n",
       "      <th>Boghni</th>\n",
       "      <th>Boudjima</th>\n",
       "      <th>Bounouh</th>\n",
       "      <th>Bouzguen</th>\n",
       "      <th>Draa Ben Khedda</th>\n",
       "      <th>Draa El Mizan</th>\n",
       "      <th>Freha</th>\n",
       "      <th>Iboudraren</th>\n",
       "      <th>Idjeur</th>\n",
       "      <th>Iferhounene</th>\n",
       "      <th>Ifigha</th>\n",
       "      <th>Iflissen</th>\n",
       "      <th>Iloula Oumalou</th>\n",
       "      <th>Irdjen</th>\n",
       "      <th>Larba Nait Irathen</th>\n",
       "      <th>Maatka</th>\n",
       "      <th>Makouda</th>\n",
       "      <th>Mechtrass</th>\n",
       "      <th>Mekla</th>\n",
       "      <th>Mizrana</th>\n",
       "      <th>Ouacif</th>\n",
       "      <th>Ouadhia</th>\n",
       "      <th>Ouaguenoun</th>\n",
       "      <th>Sidi Naamane</th>\n",
       "      <th>Souamaa</th>\n",
       "      <th>Tadmait</th>\n",
       "      <th>Tigzirt</th>\n",
       "      <th>Timizart</th>\n",
       "      <th>Tirmitine</th>\n",
       "      <th>Tizi N'Thleta</th>\n",
       "      <th>Tizi Ouzou</th>\n",
       "      <th>Tizi Rached</th>\n",
       "      <th>Yakouren</th>\n",
       "      <th>All</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>urbanicity_overall</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",
       "      <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",
       "      <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>All</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>11</td>\n",
       "      <td>4</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>52</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>198</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>10</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>48</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "ADM2_EN             Abi Youcef  Aghni Goughran  Aghrib  Ain El Hammam  \\\n",
       "urbanicity_overall                                                      \n",
       "All                          1               1       1              4   \n",
       "1                            0               0       0              2   \n",
       "2                            0               1       0              0   \n",
       "3                            0               0       0              0   \n",
       "10                           0               0       1              0   \n",
       "4                            0               0       0              0   \n",
       "7                            0               0       0              0   \n",
       "6                            1               0       0              0   \n",
       "8                            0               0       0              2   \n",
       "9                            0               0       0              0   \n",
       "5                            0               0       0              0   \n",
       "\n",
       "ADM2_EN             Ain Zaouia  Ait Aissa Mimoun  Ait Bouadou  Ait Khelili  \\\n",
       "urbanicity_overall                                                           \n",
       "All                          1                 2            2            1   \n",
       "1                            0                 1            0            0   \n",
       "2                            0                 0            0            0   \n",
       "3                            0                 0            0            0   \n",
       "10                           1                 1            0            0   \n",
       "4                            0                 0            2            0   \n",
       "7                            0                 0            0            1   \n",
       "6                            0                 0            0            0   \n",
       "8                            0                 0            0            0   \n",
       "9                            0                 0            0            0   \n",
       "5                            0                 0            0            0   \n",
       "\n",
       "ADM2_EN             Ait Mahmoud  Ait Toudert  Ait Yahia  Ait Yahia Moussa  \\\n",
       "urbanicity_overall                                                          \n",
       "All                           1            1          1                 1   \n",
       "1                             0            0          1                 0   \n",
       "2                             0            0          0                 0   \n",
       "3                             0            0          0                 0   \n",
       "10                            0            1          0                 0   \n",
       "4                             1            0          0                 0   \n",
       "7                             0            0          0                 0   \n",
       "6                             0            0          0                 1   \n",
       "8                             0            0          0                 0   \n",
       "9                             0            0          0                 0   \n",
       "5                             0            0          0                 0   \n",
       "\n",
       "ADM2_EN             Azazga  Azeffoun  Beni Aissi  Beni Douala  Beni Yenni  \\\n",
       "urbanicity_overall                                                          \n",
       "All                      8         3           2            5           1   \n",
       "1                        5         0           2            1           0   \n",
       "2                        0         0           0            2           0   \n",
       "3                        2         1           0            0           0   \n",
       "10                       0         0           0            0           1   \n",
       "4                        1         1           0            1           0   \n",
       "7                        0         0           0            0           0   \n",
       "6                        0         1           0            0           0   \n",
       "8                        0         0           0            0           0   \n",
       "9                        0         0           0            0           0   \n",
       "5                        0         0           0            1           0   \n",
       "\n",
       "ADM2_EN             Beni Zmenzer  Boghni  Boudjima  Bounouh  Bouzguen  \\\n",
       "urbanicity_overall                                                      \n",
       "All                            1       6         2        1         6   \n",
       "1                              1       6         0        0         4   \n",
       "2                              0       0         0        0         0   \n",
       "3                              0       0         1        0         0   \n",
       "10                             0       0         1        0         0   \n",
       "4                              0       0         0        0         2   \n",
       "7                              0       0         0        0         0   \n",
       "6                              0       0         0        0         0   \n",
       "8                              0       0         0        0         0   \n",
       "9                              0       0         0        1         0   \n",
       "5                              0       0         0        0         0   \n",
       "\n",
       "ADM2_EN             Draa Ben Khedda  Draa El Mizan  Freha  Iboudraren  Idjeur  \\\n",
       "urbanicity_overall                                                              \n",
       "All                              11              4     11           1       1   \n",
       "1                                10              2      3           1       1   \n",
       "2                                 1              1      3           0       0   \n",
       "3                                 0              0      4           0       0   \n",
       "10                                0              0      0           0       0   \n",
       "4                                 0              1      0           0       0   \n",
       "7                                 0              0      1           0       0   \n",
       "6                                 0              0      0           0       0   \n",
       "8                                 0              0      0           0       0   \n",
       "9                                 0              0      0           0       0   \n",
       "5                                 0              0      0           0       0   \n",
       "\n",
       "ADM2_EN             Iferhounene  Ifigha  Iflissen  Iloula Oumalou  Irdjen  \\\n",
       "urbanicity_overall                                                          \n",
       "All                           1       1         2               1       2   \n",
       "1                             1       0         1               1       2   \n",
       "2                             0       1         0               0       0   \n",
       "3                             0       0         0               0       0   \n",
       "10                            0       0         0               0       0   \n",
       "4                             0       0         0               0       0   \n",
       "7                             0       0         1               0       0   \n",
       "6                             0       0         0               0       0   \n",
       "8                             0       0         0               0       0   \n",
       "9                             0       0         0               0       0   \n",
       "5                             0       0         0               0       0   \n",
       "\n",
       "ADM2_EN             Larba Nait Irathen  Maatka  Makouda  Mechtrass  Mekla  \\\n",
       "urbanicity_overall                                                          \n",
       "All                                  5       3        6          1      6   \n",
       "1                                    0       0        2          0      3   \n",
       "2                                    1       0        1          1      0   \n",
       "3                                    1       0        1          0      1   \n",
       "10                                   0       1        0          0      0   \n",
       "4                                    0       0        0          0      0   \n",
       "7                                    0       1        1          0      1   \n",
       "6                                    2       1        0          0      0   \n",
       "8                                    0       0        1          0      1   \n",
       "9                                    1       0        0          0      0   \n",
       "5                                    0       0        0          0      0   \n",
       "\n",
       "ADM2_EN             Mizrana  Ouacif  Ouadhia  Ouaguenoun  Sidi Naamane  \\\n",
       "urbanicity_overall                                                       \n",
       "All                       1       2        6           2             2   \n",
       "1                         0       1        3           1             0   \n",
       "2                         0       0        3           0             0   \n",
       "3                         1       0        0           1             0   \n",
       "10                        0       1        0           0             0   \n",
       "4                         0       0        0           0             0   \n",
       "7                         0       0        0           0             2   \n",
       "6                         0       0        0           0             0   \n",
       "8                         0       0        0           0             0   \n",
       "9                         0       0        0           0             0   \n",
       "5                         0       0        0           0             0   \n",
       "\n",
       "ADM2_EN             Souamaa  Tadmait  Tigzirt  Timizart  Tirmitine  \\\n",
       "urbanicity_overall                                                   \n",
       "All                       1        4        7         3          2   \n",
       "1                         0        2        2         0          0   \n",
       "2                         0        0        2         3          1   \n",
       "3                         0        0        0         0          0   \n",
       "10                        0        2        1         0          0   \n",
       "4                         0        0        0         0          1   \n",
       "7                         0        0        1         0          0   \n",
       "6                         0        0        0         0          0   \n",
       "8                         0        0        1         0          0   \n",
       "9                         1        0        0         0          0   \n",
       "5                         0        0        0         0          0   \n",
       "\n",
       "ADM2_EN             Tizi N'Thleta  Tizi Ouzou  Tizi Rached  Yakouren  All  \n",
       "urbanicity_overall                                                         \n",
       "All                             1          52            5         2  198  \n",
       "1                               0          48            5         0  112  \n",
       "2                               1           3            0         0   25  \n",
       "3                               0           0            0         0   13  \n",
       "10                              0           1            0         1   13  \n",
       "4                               0           0            0         0   10  \n",
       "7                               0           0            0         0    9  \n",
       "6                               0           0            0         0    6  \n",
       "8                               0           0            0         0    5  \n",
       "9                               0           0            0         0    3  \n",
       "5                               0           0            0         1    2  "
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Derived urbanicity\n",
    "pd.crosstab(subset_thresh['urbanicity_overall'], subset_thresh['ADM2_EN'], margins=True). \\\n",
    "  sort_values(by=['All'], ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "d418c2b2",
   "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>ADM2_EN</th>\n",
       "      <th>Abi Youcef</th>\n",
       "      <th>Aghni Goughran</th>\n",
       "      <th>Aghrib</th>\n",
       "      <th>Ain El Hammam</th>\n",
       "      <th>Ain Zaouia</th>\n",
       "      <th>Ait Aissa Mimoun</th>\n",
       "      <th>Ait Bouadou</th>\n",
       "      <th>Ait Khelili</th>\n",
       "      <th>Ait Mahmoud</th>\n",
       "      <th>Ait Toudert</th>\n",
       "      <th>Ait Yahia</th>\n",
       "      <th>Ait Yahia Moussa</th>\n",
       "      <th>Azazga</th>\n",
       "      <th>Azeffoun</th>\n",
       "      <th>Beni Aissi</th>\n",
       "      <th>Beni Douala</th>\n",
       "      <th>Beni Yenni</th>\n",
       "      <th>Beni Zmenzer</th>\n",
       "      <th>Boghni</th>\n",
       "      <th>Boudjima</th>\n",
       "      <th>Bounouh</th>\n",
       "      <th>Bouzguen</th>\n",
       "      <th>Draa Ben Khedda</th>\n",
       "      <th>Draa El Mizan</th>\n",
       "      <th>Freha</th>\n",
       "      <th>Iboudraren</th>\n",
       "      <th>Idjeur</th>\n",
       "      <th>Iferhounene</th>\n",
       "      <th>Ifigha</th>\n",
       "      <th>Iflissen</th>\n",
       "      <th>Iloula Oumalou</th>\n",
       "      <th>Irdjen</th>\n",
       "      <th>Larba Nait Irathen</th>\n",
       "      <th>Maatka</th>\n",
       "      <th>Makouda</th>\n",
       "      <th>Mechtrass</th>\n",
       "      <th>Mekla</th>\n",
       "      <th>Mizrana</th>\n",
       "      <th>Ouacif</th>\n",
       "      <th>Ouadhia</th>\n",
       "      <th>Ouaguenoun</th>\n",
       "      <th>Sidi Naamane</th>\n",
       "      <th>Souamaa</th>\n",
       "      <th>Tadmait</th>\n",
       "      <th>Tigzirt</th>\n",
       "      <th>Timizart</th>\n",
       "      <th>Tirmitine</th>\n",
       "      <th>Tizi N'Thleta</th>\n",
       "      <th>Tizi Ouzou</th>\n",
       "      <th>Tizi Rached</th>\n",
       "      <th>Yakouren</th>\n",
       "      <th>All</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>urbanicity_overall</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",
       "      <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",
       "      <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>All</th>\n",
       "      <td>1583.11</td>\n",
       "      <td>470.19</td>\n",
       "      <td>2389.12</td>\n",
       "      <td>11517.47</td>\n",
       "      <td>3417.51</td>\n",
       "      <td>6293.85</td>\n",
       "      <td>2818.95</td>\n",
       "      <td>1458.68</td>\n",
       "      <td>356.49</td>\n",
       "      <td>1188.42</td>\n",
       "      <td>2583.98</td>\n",
       "      <td>95.97</td>\n",
       "      <td>10491.74</td>\n",
       "      <td>2177.99</td>\n",
       "      <td>6357.39</td>\n",
       "      <td>12759.05</td>\n",
       "      <td>847.98</td>\n",
       "      <td>1056.58</td>\n",
       "      <td>11799.90</td>\n",
       "      <td>4826.13</td>\n",
       "      <td>1400.07</td>\n",
       "      <td>21289.39</td>\n",
       "      <td>8714.89</td>\n",
       "      <td>4309.16</td>\n",
       "      <td>38437.19</td>\n",
       "      <td>1060.65</td>\n",
       "      <td>3024.87</td>\n",
       "      <td>1120.05</td>\n",
       "      <td>1696.65</td>\n",
       "      <td>4854.49</td>\n",
       "      <td>859.01</td>\n",
       "      <td>5678.12</td>\n",
       "      <td>16785.32</td>\n",
       "      <td>3524.41</td>\n",
       "      <td>12281.27</td>\n",
       "      <td>1625.05</td>\n",
       "      <td>15148.87</td>\n",
       "      <td>2532.91</td>\n",
       "      <td>4042.41</td>\n",
       "      <td>14469.52</td>\n",
       "      <td>2766.83</td>\n",
       "      <td>1129.71</td>\n",
       "      <td>210.13</td>\n",
       "      <td>4095.52</td>\n",
       "      <td>18894.66</td>\n",
       "      <td>8169.39</td>\n",
       "      <td>4118.50</td>\n",
       "      <td>783.63</td>\n",
       "      <td>112961.84</td>\n",
       "      <td>10033.72</td>\n",
       "      <td>1190.31</td>\n",
       "      <td>411699.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>5839.14</td>\n",
       "      <td>0.00</td>\n",
       "      <td>3354.58</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2583.98</td>\n",
       "      <td>0.00</td>\n",
       "      <td>4845.78</td>\n",
       "      <td>0.00</td>\n",
       "      <td>6357.39</td>\n",
       "      <td>2139.27</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1056.58</td>\n",
       "      <td>11799.90</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>16220.46</td>\n",
       "      <td>7287.00</td>\n",
       "      <td>2567.86</td>\n",
       "      <td>9999.98</td>\n",
       "      <td>1060.65</td>\n",
       "      <td>3024.87</td>\n",
       "      <td>1120.05</td>\n",
       "      <td>0.00</td>\n",
       "      <td>3300.11</td>\n",
       "      <td>859.01</td>\n",
       "      <td>5678.12</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>3810.95</td>\n",
       "      <td>0.00</td>\n",
       "      <td>6265.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2060.77</td>\n",
       "      <td>7396.46</td>\n",
       "      <td>647.58</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2076.18</td>\n",
       "      <td>3883.98</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>103871.67</td>\n",
       "      <td>10033.72</td>\n",
       "      <td>0.00</td>\n",
       "      <td>229141.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.00</td>\n",
       "      <td>470.19</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>4371.77</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1427.90</td>\n",
       "      <td>835.55</td>\n",
       "      <td>9605.70</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1696.65</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1826.30</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1912.23</td>\n",
       "      <td>1625.05</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>7073.06</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>7113.92</td>\n",
       "      <td>8169.39</td>\n",
       "      <td>2751.55</td>\n",
       "      <td>783.63</td>\n",
       "      <td>6365.04</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>56027.94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>4235.73</td>\n",
       "      <td>1199.78</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2117.12</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>15303.50</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2304.47</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1362.01</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1414.91</td>\n",
       "      <td>2532.91</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2119.25</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>32589.68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2389.12</td>\n",
       "      <td>0.00</td>\n",
       "      <td>3417.51</td>\n",
       "      <td>2939.27</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1188.42</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>847.98</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2709.01</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>419.38</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1981.65</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2019.34</td>\n",
       "      <td>2931.49</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2725.13</td>\n",
       "      <td>0.00</td>\n",
       "      <td>397.52</td>\n",
       "      <td>23965.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1458.68</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>3528.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1554.39</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1070.10</td>\n",
       "      <td>2647.73</td>\n",
       "      <td>0.00</td>\n",
       "      <td>6383.22</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1129.71</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2155.42</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>19927.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2818.95</td>\n",
       "      <td>0.00</td>\n",
       "      <td>356.49</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1410.23</td>\n",
       "      <td>238.87</td>\n",
       "      <td>0.00</td>\n",
       "      <td>4323.77</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>5068.93</td>\n",
       "      <td>0.00</td>\n",
       "      <td>905.75</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1366.94</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>16489.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1583.11</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>95.97</td>\n",
       "      <td>0.00</td>\n",
       "      <td>739.34</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>11491.19</td>\n",
       "      <td>2034.92</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>15944.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>5678.33</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2548.36</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1085.73</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2809.84</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>12122.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1400.07</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1163.36</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>210.13</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2773.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1924.24</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>792.79</td>\n",
       "      <td>2717.03</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "ADM2_EN             Abi Youcef  Aghni Goughran  Aghrib  Ain El Hammam  \\\n",
       "urbanicity_overall                                                      \n",
       "All                    1583.11          470.19 2389.12       11517.47   \n",
       "1                         0.00            0.00    0.00        5839.14   \n",
       "2                         0.00          470.19    0.00           0.00   \n",
       "3                         0.00            0.00    0.00           0.00   \n",
       "10                        0.00            0.00 2389.12           0.00   \n",
       "7                         0.00            0.00    0.00           0.00   \n",
       "4                         0.00            0.00    0.00           0.00   \n",
       "6                      1583.11            0.00    0.00           0.00   \n",
       "8                         0.00            0.00    0.00        5678.33   \n",
       "9                         0.00            0.00    0.00           0.00   \n",
       "5                         0.00            0.00    0.00           0.00   \n",
       "\n",
       "ADM2_EN             Ain Zaouia  Ait Aissa Mimoun  Ait Bouadou  Ait Khelili  \\\n",
       "urbanicity_overall                                                           \n",
       "All                    3417.51           6293.85      2818.95      1458.68   \n",
       "1                         0.00           3354.58         0.00         0.00   \n",
       "2                         0.00              0.00         0.00         0.00   \n",
       "3                         0.00              0.00         0.00         0.00   \n",
       "10                     3417.51           2939.27         0.00         0.00   \n",
       "7                         0.00              0.00         0.00      1458.68   \n",
       "4                         0.00              0.00      2818.95         0.00   \n",
       "6                         0.00              0.00         0.00         0.00   \n",
       "8                         0.00              0.00         0.00         0.00   \n",
       "9                         0.00              0.00         0.00         0.00   \n",
       "5                         0.00              0.00         0.00         0.00   \n",
       "\n",
       "ADM2_EN             Ait Mahmoud  Ait Toudert  Ait Yahia  Ait Yahia Moussa  \\\n",
       "urbanicity_overall                                                          \n",
       "All                      356.49      1188.42    2583.98             95.97   \n",
       "1                          0.00         0.00    2583.98              0.00   \n",
       "2                          0.00         0.00       0.00              0.00   \n",
       "3                          0.00         0.00       0.00              0.00   \n",
       "10                         0.00      1188.42       0.00              0.00   \n",
       "7                          0.00         0.00       0.00              0.00   \n",
       "4                        356.49         0.00       0.00              0.00   \n",
       "6                          0.00         0.00       0.00             95.97   \n",
       "8                          0.00         0.00       0.00              0.00   \n",
       "9                          0.00         0.00       0.00              0.00   \n",
       "5                          0.00         0.00       0.00              0.00   \n",
       "\n",
       "ADM2_EN              Azazga  Azeffoun  Beni Aissi  Beni Douala  Beni Yenni  \\\n",
       "urbanicity_overall                                                           \n",
       "All                10491.74   2177.99     6357.39     12759.05      847.98   \n",
       "1                   4845.78      0.00     6357.39      2139.27        0.00   \n",
       "2                      0.00      0.00        0.00      4371.77        0.00   \n",
       "3                   4235.73   1199.78        0.00         0.00        0.00   \n",
       "10                     0.00      0.00        0.00         0.00      847.98   \n",
       "7                      0.00      0.00        0.00         0.00        0.00   \n",
       "4                   1410.23    238.87        0.00      4323.77        0.00   \n",
       "6                      0.00    739.34        0.00         0.00        0.00   \n",
       "8                      0.00      0.00        0.00         0.00        0.00   \n",
       "9                      0.00      0.00        0.00         0.00        0.00   \n",
       "5                      0.00      0.00        0.00      1924.24        0.00   \n",
       "\n",
       "ADM2_EN             Beni Zmenzer   Boghni  Boudjima  Bounouh  Bouzguen  \\\n",
       "urbanicity_overall                                                       \n",
       "All                      1056.58 11799.90   4826.13  1400.07  21289.39   \n",
       "1                        1056.58 11799.90      0.00     0.00  16220.46   \n",
       "2                           0.00     0.00      0.00     0.00      0.00   \n",
       "3                           0.00     0.00   2117.12     0.00      0.00   \n",
       "10                          0.00     0.00   2709.01     0.00      0.00   \n",
       "7                           0.00     0.00      0.00     0.00      0.00   \n",
       "4                           0.00     0.00      0.00     0.00   5068.93   \n",
       "6                           0.00     0.00      0.00     0.00      0.00   \n",
       "8                           0.00     0.00      0.00     0.00      0.00   \n",
       "9                           0.00     0.00      0.00  1400.07      0.00   \n",
       "5                           0.00     0.00      0.00     0.00      0.00   \n",
       "\n",
       "ADM2_EN             Draa Ben Khedda  Draa El Mizan    Freha  Iboudraren  \\\n",
       "urbanicity_overall                                                        \n",
       "All                         8714.89        4309.16 38437.19     1060.65   \n",
       "1                           7287.00        2567.86  9999.98     1060.65   \n",
       "2                           1427.90         835.55  9605.70        0.00   \n",
       "3                              0.00           0.00 15303.50        0.00   \n",
       "10                             0.00           0.00     0.00        0.00   \n",
       "7                              0.00           0.00  3528.00        0.00   \n",
       "4                              0.00         905.75     0.00        0.00   \n",
       "6                              0.00           0.00     0.00        0.00   \n",
       "8                              0.00           0.00     0.00        0.00   \n",
       "9                              0.00           0.00     0.00        0.00   \n",
       "5                              0.00           0.00     0.00        0.00   \n",
       "\n",
       "ADM2_EN             Idjeur  Iferhounene  Ifigha  Iflissen  Iloula Oumalou  \\\n",
       "urbanicity_overall                                                          \n",
       "All                3024.87      1120.05 1696.65   4854.49          859.01   \n",
       "1                  3024.87      1120.05    0.00   3300.11          859.01   \n",
       "2                     0.00         0.00 1696.65      0.00            0.00   \n",
       "3                     0.00         0.00    0.00      0.00            0.00   \n",
       "10                    0.00         0.00    0.00      0.00            0.00   \n",
       "7                     0.00         0.00    0.00   1554.39            0.00   \n",
       "4                     0.00         0.00    0.00      0.00            0.00   \n",
       "6                     0.00         0.00    0.00      0.00            0.00   \n",
       "8                     0.00         0.00    0.00      0.00            0.00   \n",
       "9                     0.00         0.00    0.00      0.00            0.00   \n",
       "5                     0.00         0.00    0.00      0.00            0.00   \n",
       "\n",
       "ADM2_EN             Irdjen  Larba Nait Irathen  Maatka  Makouda  Mechtrass  \\\n",
       "urbanicity_overall                                                           \n",
       "All                5678.12            16785.32 3524.41 12281.27    1625.05   \n",
       "1                  5678.12                0.00    0.00  3810.95       0.00   \n",
       "2                     0.00             1826.30    0.00  1912.23    1625.05   \n",
       "3                     0.00             2304.47    0.00  1362.01       0.00   \n",
       "10                    0.00                0.00  419.38     0.00       0.00   \n",
       "7                     0.00                0.00 1070.10  2647.73       0.00   \n",
       "4                     0.00                0.00    0.00     0.00       0.00   \n",
       "6                     0.00            11491.19 2034.92     0.00       0.00   \n",
       "8                     0.00                0.00    0.00  2548.36       0.00   \n",
       "9                     0.00             1163.36    0.00     0.00       0.00   \n",
       "5                     0.00                0.00    0.00     0.00       0.00   \n",
       "\n",
       "ADM2_EN               Mekla  Mizrana  Ouacif  Ouadhia  Ouaguenoun  \\\n",
       "urbanicity_overall                                                  \n",
       "All                15148.87  2532.91 4042.41 14469.52     2766.83   \n",
       "1                   6265.00     0.00 2060.77  7396.46      647.58   \n",
       "2                      0.00     0.00    0.00  7073.06        0.00   \n",
       "3                   1414.91  2532.91    0.00     0.00     2119.25   \n",
       "10                     0.00     0.00 1981.65     0.00        0.00   \n",
       "7                   6383.22     0.00    0.00     0.00        0.00   \n",
       "4                      0.00     0.00    0.00     0.00        0.00   \n",
       "6                      0.00     0.00    0.00     0.00        0.00   \n",
       "8                   1085.73     0.00    0.00     0.00        0.00   \n",
       "9                      0.00     0.00    0.00     0.00        0.00   \n",
       "5                      0.00     0.00    0.00     0.00        0.00   \n",
       "\n",
       "ADM2_EN             Sidi Naamane  Souamaa  Tadmait  Tigzirt  Timizart  \\\n",
       "urbanicity_overall                                                      \n",
       "All                      1129.71   210.13  4095.52 18894.66   8169.39   \n",
       "1                           0.00     0.00  2076.18  3883.98      0.00   \n",
       "2                           0.00     0.00     0.00  7113.92   8169.39   \n",
       "3                           0.00     0.00     0.00     0.00      0.00   \n",
       "10                          0.00     0.00  2019.34  2931.49      0.00   \n",
       "7                        1129.71     0.00     0.00  2155.42      0.00   \n",
       "4                           0.00     0.00     0.00     0.00      0.00   \n",
       "6                           0.00     0.00     0.00     0.00      0.00   \n",
       "8                           0.00     0.00     0.00  2809.84      0.00   \n",
       "9                           0.00   210.13     0.00     0.00      0.00   \n",
       "5                           0.00     0.00     0.00     0.00      0.00   \n",
       "\n",
       "ADM2_EN             Tirmitine  Tizi N'Thleta  Tizi Ouzou  Tizi Rached  \\\n",
       "urbanicity_overall                                                      \n",
       "All                   4118.50         783.63   112961.84     10033.72   \n",
       "1                        0.00           0.00   103871.67     10033.72   \n",
       "2                     2751.55         783.63     6365.04         0.00   \n",
       "3                        0.00           0.00        0.00         0.00   \n",
       "10                       0.00           0.00     2725.13         0.00   \n",
       "7                        0.00           0.00        0.00         0.00   \n",
       "4                     1366.94           0.00        0.00         0.00   \n",
       "6                        0.00           0.00        0.00         0.00   \n",
       "8                        0.00           0.00        0.00         0.00   \n",
       "9                        0.00           0.00        0.00         0.00   \n",
       "5                        0.00           0.00        0.00         0.00   \n",
       "\n",
       "ADM2_EN             Yakouren       All  \n",
       "urbanicity_overall                      \n",
       "All                  1190.31 411699.06  \n",
       "1                       0.00 229141.02  \n",
       "2                       0.00  56027.94  \n",
       "3                       0.00  32589.68  \n",
       "10                    397.52  23965.83  \n",
       "7                       0.00  19927.25  \n",
       "4                       0.00  16489.95  \n",
       "6                       0.00  15944.54  \n",
       "8                       0.00  12122.25  \n",
       "9                       0.00   2773.56  \n",
       "5                     792.79   2717.03  "
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Total NSR by derived urbanicity\n",
    "pd.set_option('display.float_format', lambda x: '%.2f' % x)\n",
    "pd.crosstab(subset_thresh['urbanicity_overall'], subset_thresh['ADM2_EN'], values=subset_thresh['NSR'], aggfunc='sum', margins=True). \\\n",
    "  sort_values(by=['All'], ascending=False).fillna(0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "7112713e",
   "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>ADM2_EN</th>\n",
       "      <th>Abi Youcef</th>\n",
       "      <th>Aghni Goughran</th>\n",
       "      <th>Aghrib</th>\n",
       "      <th>Ain El Hammam</th>\n",
       "      <th>Ain Zaouia</th>\n",
       "      <th>Ait Aissa Mimoun</th>\n",
       "      <th>Ait Bouadou</th>\n",
       "      <th>Ait Khelili</th>\n",
       "      <th>Ait Mahmoud</th>\n",
       "      <th>Ait Toudert</th>\n",
       "      <th>Ait Yahia</th>\n",
       "      <th>Ait Yahia Moussa</th>\n",
       "      <th>Azazga</th>\n",
       "      <th>Azeffoun</th>\n",
       "      <th>Beni Aissi</th>\n",
       "      <th>Beni Douala</th>\n",
       "      <th>Beni Yenni</th>\n",
       "      <th>Beni Zmenzer</th>\n",
       "      <th>Boghni</th>\n",
       "      <th>Boudjima</th>\n",
       "      <th>Bounouh</th>\n",
       "      <th>Bouzguen</th>\n",
       "      <th>Draa Ben Khedda</th>\n",
       "      <th>Draa El Mizan</th>\n",
       "      <th>Freha</th>\n",
       "      <th>Iboudraren</th>\n",
       "      <th>Idjeur</th>\n",
       "      <th>Iferhounene</th>\n",
       "      <th>Ifigha</th>\n",
       "      <th>Iflissen</th>\n",
       "      <th>Iloula Oumalou</th>\n",
       "      <th>Irdjen</th>\n",
       "      <th>Larba Nait Irathen</th>\n",
       "      <th>Maatka</th>\n",
       "      <th>Makouda</th>\n",
       "      <th>Mechtrass</th>\n",
       "      <th>Mekla</th>\n",
       "      <th>Mizrana</th>\n",
       "      <th>Ouacif</th>\n",
       "      <th>Ouadhia</th>\n",
       "      <th>Ouaguenoun</th>\n",
       "      <th>Sidi Naamane</th>\n",
       "      <th>Souamaa</th>\n",
       "      <th>Tadmait</th>\n",
       "      <th>Tigzirt</th>\n",
       "      <th>Timizart</th>\n",
       "      <th>Tirmitine</th>\n",
       "      <th>Tizi N'Thleta</th>\n",
       "      <th>Tizi Ouzou</th>\n",
       "      <th>Tizi Rached</th>\n",
       "      <th>Yakouren</th>\n",
       "      <th>All</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>urbanicity_overall</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",
       "      <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",
       "      <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>1</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>40802.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>20268.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>14439.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>173415.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>15256.00</td>\n",
       "      <td>21551.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>187578.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>313820.00</td>\n",
       "      <td>77772.00</td>\n",
       "      <td>72684.00</td>\n",
       "      <td>5398.00</td>\n",
       "      <td>10301.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>14311.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>26298.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>46776.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>72711.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>47313.00</td>\n",
       "      <td>17425.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>45676.00</td>\n",
       "      <td>23924.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>6484224.00</td>\n",
       "      <td>85805.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>7817747.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>43102.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>31382.00</td>\n",
       "      <td>38886.00</td>\n",
       "      <td>72684.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>9160.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>23388.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>47313.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>23924.00</td>\n",
       "      <td>86988.00</td>\n",
       "      <td>19027.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>405264.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>801118.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>69366.00</td>\n",
       "      <td>16847.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>15628.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>96912.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>23388.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>24237.00</td>\n",
       "      <td>9469.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>17425.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>273272.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>7699.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>34683.00</td>\n",
       "      <td>16847.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>21551.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>38886.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>19027.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>138693.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>21551.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>12203.00</td>\n",
       "      <td>33754.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7693.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>20426.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>16847.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>44966.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>24228.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>14311.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>23388.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>24237.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>11962.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>98126.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>40802.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>23388.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>24237.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>11962.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>100389.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>9731.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>9954.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>19685.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>17320.00</td>\n",
       "      <td>20268.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>8521.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>15628.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>45676.00</td>\n",
       "      <td>11962.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>135088.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>12203.00</td>\n",
       "      <td>266666.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>All</th>\n",
       "      <td>7693.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>81604.00</td>\n",
       "      <td>17320.00</td>\n",
       "      <td>40536.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>7699.00</td>\n",
       "      <td>8521.00</td>\n",
       "      <td>14439.00</td>\n",
       "      <td>20426.00</td>\n",
       "      <td>277464.00</td>\n",
       "      <td>50541.00</td>\n",
       "      <td>15256.00</td>\n",
       "      <td>107755.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>187578.00</td>\n",
       "      <td>31256.00</td>\n",
       "      <td>9731.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>345202.00</td>\n",
       "      <td>155544.00</td>\n",
       "      <td>266508.00</td>\n",
       "      <td>5398.00</td>\n",
       "      <td>10301.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>9160.00</td>\n",
       "      <td>28622.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>26298.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>140328.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>145422.00</td>\n",
       "      <td>9469.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>94626.00</td>\n",
       "      <td>34850.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>9954.00</td>\n",
       "      <td>91352.00</td>\n",
       "      <td>83734.00</td>\n",
       "      <td>86988.00</td>\n",
       "      <td>38054.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>7024576.00</td>\n",
       "      <td>85805.00</td>\n",
       "      <td>24406.00</td>\n",
       "      <td>9594416.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "ADM2_EN             Abi Youcef  Aghni Goughran  Aghrib  Ain El Hammam  \\\n",
       "urbanicity_overall                                                      \n",
       "1                         0.00            0.00    0.00       40802.00   \n",
       "2                         0.00            0.00    0.00           0.00   \n",
       "3                         0.00            0.00    0.00           0.00   \n",
       "4                         0.00            0.00    0.00           0.00   \n",
       "5                         0.00            0.00    0.00           0.00   \n",
       "6                      7693.00            0.00    0.00           0.00   \n",
       "7                         0.00            0.00    0.00           0.00   \n",
       "8                         0.00            0.00    0.00       40802.00   \n",
       "9                         0.00            0.00    0.00           0.00   \n",
       "10                        0.00            0.00    0.00           0.00   \n",
       "All                    7693.00            0.00    0.00       81604.00   \n",
       "\n",
       "ADM2_EN             Ain Zaouia  Ait Aissa Mimoun  Ait Bouadou  Ait Khelili  \\\n",
       "urbanicity_overall                                                           \n",
       "1                         0.00          20268.00         0.00         0.00   \n",
       "2                         0.00              0.00         0.00         0.00   \n",
       "3                         0.00              0.00         0.00         0.00   \n",
       "4                         0.00              0.00         0.00         0.00   \n",
       "5                         0.00              0.00         0.00         0.00   \n",
       "6                         0.00              0.00         0.00         0.00   \n",
       "7                         0.00              0.00         0.00         0.00   \n",
       "8                         0.00              0.00         0.00         0.00   \n",
       "9                         0.00              0.00         0.00         0.00   \n",
       "10                    17320.00          20268.00         0.00         0.00   \n",
       "All                   17320.00          40536.00         0.00         0.00   \n",
       "\n",
       "ADM2_EN             Ait Mahmoud  Ait Toudert  Ait Yahia  Ait Yahia Moussa  \\\n",
       "urbanicity_overall                                                          \n",
       "1                          0.00         0.00   14439.00              0.00   \n",
       "2                          0.00         0.00       0.00              0.00   \n",
       "3                          0.00         0.00       0.00              0.00   \n",
       "4                       7699.00         0.00       0.00              0.00   \n",
       "5                          0.00         0.00       0.00              0.00   \n",
       "6                          0.00         0.00       0.00          20426.00   \n",
       "7                          0.00         0.00       0.00              0.00   \n",
       "8                          0.00         0.00       0.00              0.00   \n",
       "9                          0.00         0.00       0.00              0.00   \n",
       "10                         0.00      8521.00       0.00              0.00   \n",
       "All                     7699.00      8521.00   14439.00          20426.00   \n",
       "\n",
       "ADM2_EN               Azazga  Azeffoun  Beni Aissi  Beni Douala  Beni Yenni  \\\n",
       "urbanicity_overall                                                            \n",
       "1                  173415.00      0.00    15256.00     21551.00        0.00   \n",
       "2                       0.00      0.00        0.00     43102.00        0.00   \n",
       "3                   69366.00  16847.00        0.00         0.00        0.00   \n",
       "4                   34683.00  16847.00        0.00     21551.00        0.00   \n",
       "5                       0.00      0.00        0.00     21551.00        0.00   \n",
       "6                       0.00  16847.00        0.00         0.00        0.00   \n",
       "7                       0.00      0.00        0.00         0.00        0.00   \n",
       "8                       0.00      0.00        0.00         0.00        0.00   \n",
       "9                       0.00      0.00        0.00         0.00        0.00   \n",
       "10                      0.00      0.00        0.00         0.00        0.00   \n",
       "All                277464.00  50541.00    15256.00    107755.00        0.00   \n",
       "\n",
       "ADM2_EN             Beni Zmenzer    Boghni  Boudjima  Bounouh  Bouzguen  \\\n",
       "urbanicity_overall                                                        \n",
       "1                           0.00 187578.00      0.00     0.00      0.00   \n",
       "2                           0.00      0.00      0.00     0.00      0.00   \n",
       "3                           0.00      0.00  15628.00     0.00      0.00   \n",
       "4                           0.00      0.00      0.00     0.00      0.00   \n",
       "5                           0.00      0.00      0.00     0.00      0.00   \n",
       "6                           0.00      0.00      0.00     0.00      0.00   \n",
       "7                           0.00      0.00      0.00     0.00      0.00   \n",
       "8                           0.00      0.00      0.00     0.00      0.00   \n",
       "9                           0.00      0.00      0.00  9731.00      0.00   \n",
       "10                          0.00      0.00  15628.00     0.00      0.00   \n",
       "All                         0.00 187578.00  31256.00  9731.00      0.00   \n",
       "\n",
       "ADM2_EN             Draa Ben Khedda  Draa El Mizan     Freha  Iboudraren  \\\n",
       "urbanicity_overall                                                         \n",
       "1                         313820.00       77772.00  72684.00     5398.00   \n",
       "2                          31382.00       38886.00  72684.00        0.00   \n",
       "3                              0.00           0.00  96912.00        0.00   \n",
       "4                              0.00       38886.00      0.00        0.00   \n",
       "5                              0.00           0.00      0.00        0.00   \n",
       "6                              0.00           0.00      0.00        0.00   \n",
       "7                              0.00           0.00  24228.00        0.00   \n",
       "8                              0.00           0.00      0.00        0.00   \n",
       "9                              0.00           0.00      0.00        0.00   \n",
       "10                             0.00           0.00      0.00        0.00   \n",
       "All                       345202.00      155544.00 266508.00     5398.00   \n",
       "\n",
       "ADM2_EN              Idjeur  Iferhounene  Ifigha  Iflissen  Iloula Oumalou  \\\n",
       "urbanicity_overall                                                           \n",
       "1                  10301.00         0.00    0.00  14311.00            0.00   \n",
       "2                      0.00         0.00 9160.00      0.00            0.00   \n",
       "3                      0.00         0.00    0.00      0.00            0.00   \n",
       "4                      0.00         0.00    0.00      0.00            0.00   \n",
       "5                      0.00         0.00    0.00      0.00            0.00   \n",
       "6                      0.00         0.00    0.00      0.00            0.00   \n",
       "7                      0.00         0.00    0.00  14311.00            0.00   \n",
       "8                      0.00         0.00    0.00      0.00            0.00   \n",
       "9                      0.00         0.00    0.00      0.00            0.00   \n",
       "10                     0.00         0.00    0.00      0.00            0.00   \n",
       "All                10301.00         0.00 9160.00  28622.00            0.00   \n",
       "\n",
       "ADM2_EN              Irdjen  Larba Nait Irathen  Maatka   Makouda  Mechtrass  \\\n",
       "urbanicity_overall                                                             \n",
       "1                  26298.00                0.00    0.00  46776.00       0.00   \n",
       "2                      0.00                0.00    0.00  23388.00       0.00   \n",
       "3                      0.00                0.00    0.00  23388.00       0.00   \n",
       "4                      0.00                0.00    0.00      0.00       0.00   \n",
       "5                      0.00                0.00    0.00      0.00       0.00   \n",
       "6                      0.00                0.00    0.00      0.00       0.00   \n",
       "7                      0.00                0.00    0.00  23388.00       0.00   \n",
       "8                      0.00                0.00    0.00  23388.00       0.00   \n",
       "9                      0.00                0.00    0.00      0.00       0.00   \n",
       "10                     0.00                0.00    0.00      0.00       0.00   \n",
       "All                26298.00                0.00    0.00 140328.00       0.00   \n",
       "\n",
       "ADM2_EN                Mekla  Mizrana  Ouacif  Ouadhia  Ouaguenoun  \\\n",
       "urbanicity_overall                                                   \n",
       "1                   72711.00     0.00    0.00 47313.00    17425.00   \n",
       "2                       0.00     0.00    0.00 47313.00        0.00   \n",
       "3                   24237.00  9469.00    0.00     0.00    17425.00   \n",
       "4                       0.00     0.00    0.00     0.00        0.00   \n",
       "5                       0.00     0.00    0.00     0.00        0.00   \n",
       "6                       0.00     0.00    0.00     0.00        0.00   \n",
       "7                   24237.00     0.00    0.00     0.00        0.00   \n",
       "8                   24237.00     0.00    0.00     0.00        0.00   \n",
       "9                       0.00     0.00    0.00     0.00        0.00   \n",
       "10                      0.00     0.00    0.00     0.00        0.00   \n",
       "All                145422.00  9469.00    0.00 94626.00    34850.00   \n",
       "\n",
       "ADM2_EN             Sidi Naamane  Souamaa  Tadmait  Tigzirt  Timizart  \\\n",
       "urbanicity_overall                                                      \n",
       "1                           0.00     0.00 45676.00 23924.00      0.00   \n",
       "2                           0.00     0.00     0.00 23924.00  86988.00   \n",
       "3                           0.00     0.00     0.00     0.00      0.00   \n",
       "4                           0.00     0.00     0.00     0.00      0.00   \n",
       "5                           0.00     0.00     0.00     0.00      0.00   \n",
       "6                           0.00     0.00     0.00     0.00      0.00   \n",
       "7                           0.00     0.00     0.00 11962.00      0.00   \n",
       "8                           0.00     0.00     0.00 11962.00      0.00   \n",
       "9                           0.00  9954.00     0.00     0.00      0.00   \n",
       "10                          0.00     0.00 45676.00 11962.00      0.00   \n",
       "All                         0.00  9954.00 91352.00 83734.00  86988.00   \n",
       "\n",
       "ADM2_EN             Tirmitine  Tizi N'Thleta  Tizi Ouzou  Tizi Rached  \\\n",
       "urbanicity_overall                                                      \n",
       "1                        0.00           0.00  6484224.00     85805.00   \n",
       "2                    19027.00           0.00   405264.00         0.00   \n",
       "3                        0.00           0.00        0.00         0.00   \n",
       "4                    19027.00           0.00        0.00         0.00   \n",
       "5                        0.00           0.00        0.00         0.00   \n",
       "6                        0.00           0.00        0.00         0.00   \n",
       "7                        0.00           0.00        0.00         0.00   \n",
       "8                        0.00           0.00        0.00         0.00   \n",
       "9                        0.00           0.00        0.00         0.00   \n",
       "10                       0.00           0.00   135088.00         0.00   \n",
       "All                  38054.00           0.00  7024576.00     85805.00   \n",
       "\n",
       "ADM2_EN             Yakouren        All  \n",
       "urbanicity_overall                       \n",
       "1                       0.00 7817747.00  \n",
       "2                       0.00  801118.00  \n",
       "3                       0.00  273272.00  \n",
       "4                       0.00  138693.00  \n",
       "5                   12203.00   33754.00  \n",
       "6                       0.00   44966.00  \n",
       "7                       0.00   98126.00  \n",
       "8                       0.00  100389.00  \n",
       "9                       0.00   19685.00  \n",
       "10                  12203.00  266666.00  \n",
       "All                 24406.00 9594416.00  "
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Gov metrics by derived urbanicity\n",
    "pd.crosstab(subset_thresh['urbanicity_overall'], subset_thresh['ADM2_EN'], values=subset_thresh['urba_gov_Population'], aggfunc='sum', margins=True).fillna(0)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "4d314330",
   "metadata": {},
   "source": [
    "# Export DATA"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "3ed4a653",
   "metadata": {},
   "outputs": [],
   "source": [
    "subset_thresh.to_csv(\"horeca_tz_customer_subset.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "91d9b8d8",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(198, 96)"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "subset_thresh.shape"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.7"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}