IVE_MAMH.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "IVE-MAMH.ipynb",
      "provenance": [],
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/Enkerli/litteratiedonnees/blob/main/IVE_MAMH.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "-cF8aQpc4Cuk"
      },
      "source": [
        "import pandas as pd\n",
        "import numpy as np\n",
        "from pandas import Series\n",
        "from bs4 import BeautifulSoup\n",
        "from IPython.display import HTML\n",
        "#from os import path\n",
        "from PIL import Image\n",
        "from wordcloud import WordCloud, STOPWORDS, ImageColorGenerator\n",
        "import matplotlib.pyplot as plt\n",
        "% matplotlib inline"
      ],
      "execution_count": 1,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 756
        },
        "id": "iokz_XCcze1Y",
        "outputId": "9a46363a-f656-4a13-d4cc-b93a2547cabb"
      },
      "source": [
        "#ive2016=pd.read_excel(\"https://github.com/Enkerli/litteratiedonnees/blob/main/IVE2016_ISQ-MAMH.xlsx?raw=true\", index_col='Nom de la localité et statut juridique')\n",
        "#ive2016.index.rename('Nom', inplace=True)\n",
        "ive2016=pd.read_excel(\"https://github.com/Enkerli/litteratiedonnees/blob/main/IVE2016_ISQ-MAMH.xlsx?raw=true\", index_col=(1,2))\n",
        "ive2016.index.rename(('Nom', 'Region'), inplace=True)\n",
        "ive2016.drop(columns='Unnamed: 7', inplace=True)\n",
        "ive2016.rename(columns={'Indice de vitalité économique (n)': 'IVE', 'Revenu total médian des particuliers de 18 ans et plus ($)': 'Revenu', \n",
        "                        'TAAM de la population sur 5 ans (pour mille)': 'TAAM', 'Taux de travailleurs des 25-64 ans (%)': 'Travailleurs'}, inplace=True)\n",
        "ive2016['Quintile']=pd.qcut(ive2016['Rang'], q=5, labels=False)+1\n",
        "#ive2016.rename(columns={'Rang':'Rang2016'}, inplace=True)\n",
        "ive2016=ive2016.add_suffix('_2016')\n",
        "\n",
        "ive2014=pd.read_excel(\"https://github.com/Enkerli/litteratiedonnees/blob/main/IVE2014_ISQ-MAMH.xlsx?raw=true\", index_col=(1,2))\n",
        "ive2014.index.rename(('Nom', 'Region'), inplace=True)\n",
        "ive2014.drop(columns='Unnamed: 7', inplace=True)\n",
        "ive2014.rename(columns={'Indice de vitalité économique (n)': 'IVE', 'Revenu total médian des particuliers de 18 ans et plus ($)': 'Revenu', \n",
        "                        'TAAM de la population sur 5 ans (pour mille)': 'TAAM', 'Taux de travailleurs des 25-64 ans (%)': 'Travailleurs'}, inplace=True)\n",
        "ive2014['Quintile']=pd.qcut(ive2014['Rang'], q=5, labels=False)+1\n",
        "ive2014=ive2014.add_suffix('_2014')\n",
        "\n",
        "ive2002=pd.read_excel(\"https://github.com/Enkerli/litteratiedonnees/blob/main/IVE2002_ISQ-MAMH.xlsx?raw=true\", index_col=(1,2))\n",
        "ive2002.index.rename(('Nom', 'Region'), inplace=True)\n",
        "#ive2002.drop(columns='Unnamed: 7', inplace=True)\n",
        "ive2002.rename(columns={'Indice de vitalité économique (n)': 'IVE', 'Revenu total médian des particuliers de 18 ans et plus ($)': 'Revenu', \n",
        "                        'TAAM de la population sur 5 ans (pour mille)': 'TAAM', 'Taux de travailleurs des 25-64 ans (%)': 'Travailleurs'}, inplace=True)\n",
        "ive2002['Quintile']=pd.qcut(ive2002['Rang'], q=5, labels=False)+1\n",
        "ive2002=ive2002.add_suffix('_2002')\n",
        "\n",
        "ive2003=pd.read_excel(\"https://github.com/Enkerli/litteratiedonnees/blob/main/IVE2003_ISQ-MAMH.xlsx?raw=true\", index_col=(1,2))\n",
        "ive2003.index.rename(('Nom', 'Region'), inplace=True)\n",
        "ive2003.rename(columns={'Indice de vitalité économique (n)': 'IVE', 'Revenu total médian des particuliers de 18 ans et plus ($)': 'Revenu', \n",
        "                        'TAAM de la population sur 5 ans (pour mille)': 'TAAM', 'Taux de travailleurs des 25-64 ans (%)': 'Travailleurs'}, inplace=True)\n",
        "ive2003['Quintile']=pd.qcut(ive2003['Rang'], q=5, labels=False)+1\n",
        "ive2003=ive2003.add_suffix('_2003')\n",
        "\n",
        "ive2004=pd.read_excel(\"https://github.com/Enkerli/litteratiedonnees/blob/main/IVE2004_ISQ-MAMH.xlsx?raw=true\", index_col=(1,2))\n",
        "ive2004.index.rename(('Nom', 'Region'), inplace=True)\n",
        "ive2004.rename(columns={'Indice de vitalité économique (n)': 'IVE', 'Revenu total médian des particuliers de 18 ans et plus ($)': 'Revenu',\n",
        "                        'TAAM de la population sur 5 ans (pour mille)': 'TAAM', 'Taux de travailleurs des 25-64 ans (%)': 'Travailleurs'}, inplace=True)\n",
        "ive2004['Quintile']=pd.qcut(ive2004['Rang'], q=5, labels=False)+1\n",
        "ive2004=ive2004.add_suffix('_2004')\n",
        "\n",
        "ive2005=pd.read_excel(\"https://github.com/Enkerli/litteratiedonnees/blob/main/IVE2005_ISQ-MAMH.xlsx?raw=true\", index_col=(1,2))\n",
        "ive2005.index.rename(('Nom', 'Region'), inplace=True)\n",
        "ive2005.rename(columns={'Indice de vitalité économique (n)': 'IVE', 'Revenu total médian des particuliers de 18 ans et plus ($)': 'Revenu', \n",
        "                        'TAAM de la population sur 5 ans (pour mille)': 'TAAM', 'Taux de travailleurs des 25-64 ans (%)': 'Travailleurs'}, inplace=True)\n",
        "ive2005['Quintile']=pd.qcut(ive2005['Rang'], q=5, labels=False)+1\n",
        "ive2005=ive2005.add_suffix('_2005')\n",
        "\n",
        "ive2006=pd.read_excel(\"https://github.com/Enkerli/litteratiedonnees/blob/main/IVE2006_ISQ-MAMH.xlsx?raw=true\", index_col=(1,2))\n",
        "ive2006.index.rename(('Nom', 'Region'), inplace=True)\n",
        "ive2006.rename(columns={'Indice de vitalité économique (n)': 'IVE', 'Revenu total médian des particuliers de 18 ans et plus ($)': 'Revenu', \n",
        "                        'TAAM de la population sur 5 ans (pour mille)': 'TAAM', 'Taux de travailleurs des 25-64 ans (%)': 'Travailleurs'}, inplace=True)\n",
        "ive2006['Quintile']=pd.qcut(ive2006['Rang'], q=5, labels=False)+1\n",
        "ive2006=ive2006.add_suffix('_2006')\n",
        "\n",
        "ive2007=pd.read_excel(\"https://github.com/Enkerli/litteratiedonnees/blob/main/IVE2007_ISQ-MAMH.xlsx?raw=true\", index_col=(1,2))\n",
        "ive2007.index.rename(('Nom', 'Region'), inplace=True)\n",
        "ive2007.rename(columns={'Indice de vitalité économique (n)': 'IVE', 'Revenu total médian des particuliers de 18 ans et plus ($)': 'Revenu', \n",
        "                        'TAAM de la population sur 5 ans (pour mille)': 'TAAM', 'Taux de travailleurs des 25-64 ans (%)': 'Travailleurs'}, inplace=True)\n",
        "ive2007['Quintile']=pd.qcut(ive2007['Rang'], q=5, labels=False)+1\n",
        "ive2007=ive2007.add_suffix('_2007')\n",
        "\n",
        "ive2008=pd.read_excel(\"https://github.com/Enkerli/litteratiedonnees/blob/main/IVE2008_ISQ-MAMH.xlsx?raw=true\", index_col=(1,2))\n",
        "ive2008.index.rename(('Nom', 'Region'), inplace=True)\n",
        "ive2008.rename(columns={'Indice de vitalité économique (n)': 'IVE', 'Revenu total médian des particuliers de 18 ans et plus ($)': 'Revenu', \n",
        "                        'TAAM de la population sur 5 ans (pour mille)': 'TAAM', 'Taux de travailleurs des 25-64 ans (%)': 'Travailleurs'}, inplace=True)\n",
        "ive2008['Quintile']=pd.qcut(ive2008['Rang'], q=5, labels=False)+1\n",
        "ive2008=ive2008.add_suffix('_2008')\n",
        "\n",
        "ive2009=pd.read_excel(\"https://github.com/Enkerli/litteratiedonnees/blob/main/IVE2009_ISQ-MAMH.xlsx?raw=true\", index_col=(1,2))\n",
        "ive2009.index.rename(('Nom', 'Region'), inplace=True)\n",
        "ive2009.rename(columns={'Indice de vitalité économique (n)': 'IVE', 'Revenu total médian des particuliers de 18 ans et plus ($)': 'Revenu', \n",
        "                        'TAAM de la population sur 5 ans (pour mille)': 'TAAM', 'Taux de travailleurs des 25-64 ans (%)': 'Travailleurs'}, inplace=True)\n",
        "ive2009['Quintile']=pd.qcut(ive2009['Rang'], q=5, labels=False)+1\n",
        "ive2009=ive2009.add_suffix('_2009')\n",
        "\n",
        "ive2010=pd.read_excel(\"https://github.com/Enkerli/litteratiedonnees/blob/main/IVE2010_ISQ-MAMH.xlsx?raw=true\", index_col=(1,2))\n",
        "ive2010.index.rename(('Nom', 'Region'), inplace=True)\n",
        "ive2010.rename(columns={'Indice de vitalité économique (n)': 'IVE', 'Revenu total médian des particuliers de 18 ans et plus ($)': 'Revenu', \n",
        "                        'TAAM de la population sur 5 ans (pour mille)': 'TAAM', 'Taux de travailleurs des 25-64 ans (%)': 'Travailleurs'}, inplace=True)\n",
        "ive2010['Quintile']=pd.qcut(ive2010['Rang'], q=5, labels=False)+1\n",
        "ive2010=ive2010.add_suffix('_2010')\n",
        "\n",
        "ive2011=pd.read_excel(\"https://github.com/Enkerli/litteratiedonnees/blob/main/IVE2011_ISQ-MAMH.xlsx?raw=true\", index_col=(1,2))\n",
        "ive2011.index.rename(('Nom', 'Region'), inplace=True)\n",
        "ive2011.rename(columns={'Indice de vitalité économique (n)': 'IVE', 'Revenu total médian des particuliers de 18 ans et plus ($)': 'Revenu', \n",
        "                        'TAAM de la population sur 5 ans (pour mille)': 'TAAM', 'Taux de travailleurs des 25-64 ans (%)': 'Travailleurs'}, inplace=True)\n",
        "ive2011['Quintile']=pd.qcut(ive2011['Rang'], q=5, labels=False)+1\n",
        "ive2011=ive2011.add_suffix('_2011')\n",
        "\n",
        "ive2012=pd.read_excel(\"https://github.com/Enkerli/litteratiedonnees/blob/main/IVE2012_ISQ-MAMH.xlsx?raw=true\", index_col=(1,2))\n",
        "ive2012.index.rename(('Nom', 'Region'), inplace=True)\n",
        "ive2012.rename(columns={'Indice de vitalité économique (n)': 'IVE', 'Revenu total médian des particuliers de 18 ans et plus ($)': 'Revenu', \n",
        "                        'TAAM de la population sur 5 ans (pour mille)': 'TAAM', 'Taux de travailleurs des 25-64 ans (%)': 'Travailleurs'}, inplace=True)\n",
        "ive2012['Quintile']=pd.qcut(ive2012['Rang'], q=5, labels=False)+1\n",
        "ive2012=ive2012.add_suffix('_2012')\n",
        "\n",
        "ive2013=pd.read_excel(\"https://github.com/Enkerli/litteratiedonnees/blob/main/IVE2013_ISQ-MAMH.xlsx?raw=true\", index_col=(1,2))\n",
        "ive2013.index.rename(('Nom', 'Region'), inplace=True)\n",
        "ive2013.rename(columns={'Indice de vitalité économique (n)': 'IVE', 'Revenu total médian des particuliers de 18 ans et plus ($)': 'Revenu', \n",
        "                        'TAAM de la population sur 5 ans (pour mille)': 'TAAM', 'Taux de travailleurs des 25-64 ans (%)': 'Travailleurs'}, inplace=True)\n",
        "ive2013['Quintile']=pd.qcut(ive2013['Rang'], q=5, labels=False)+1\n",
        "ive2013=ive2013.add_suffix('_2013')\n",
        "\n",
        "#ive=pd.merge(left=ive2002, right=ive2003, on='Nom')\n",
        "ive=pd.merge(left=ive2002, right=ive2003, on=('Nom','Region'))\n",
        "ive=pd.merge(left=ive, right=ive2004, on=('Nom','Region'))\n",
        "ive=pd.merge(left=ive, right=ive2005, on=('Nom','Region'))\n",
        "ive=pd.merge(left=ive, right=ive2006, on=('Nom','Region'))\n",
        "ive=pd.merge(left=ive, right=ive2007, on=('Nom','Region'))\n",
        "ive=pd.merge(left=ive, right=ive2008, on=('Nom','Region'))\n",
        "ive=pd.merge(left=ive, right=ive2009, on=('Nom','Region'))\n",
        "ive=pd.merge(left=ive, right=ive2010, on=('Nom','Region'))\n",
        "ive=pd.merge(left=ive, right=ive2011, on=('Nom','Region'))\n",
        "ive=pd.merge(left=ive, right=ive2012, on=('Nom','Region'))\n",
        "ive=pd.merge(left=ive, right=ive2013, on=('Nom','Region'))\n",
        "ive=pd.merge(left=ive, right=ive2014, on=('Nom','Region'))\n",
        "ive=pd.merge(left=ive, right=ive2016, on=('Nom','Region'))\n",
        "#ive.loc[:, ive.columns.str.startswith(\"Quint\")]\n",
        "ive"
      ],
      "execution_count": 196,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th>Rang_2002</th>\n",
              "      <th>IVE_2002</th>\n",
              "      <th>Revenu_2002</th>\n",
              "      <th>Travailleurs_2002</th>\n",
              "      <th>TAAM_2002</th>\n",
              "      <th>Quintile_2002</th>\n",
              "      <th>Rang_2003</th>\n",
              "      <th>IVE_2003</th>\n",
              "      <th>Revenu_2003</th>\n",
              "      <th>Travailleurs_2003</th>\n",
              "      <th>TAAM_2003</th>\n",
              "      <th>Quintile_2003</th>\n",
              "      <th>Rang_2004</th>\n",
              "      <th>IVE_2004</th>\n",
              "      <th>Revenu_2004</th>\n",
              "      <th>Travailleurs_2004</th>\n",
              "      <th>TAAM_2004</th>\n",
              "      <th>Quintile_2004</th>\n",
              "      <th>Rang_2005</th>\n",
              "      <th>IVE_2005</th>\n",
              "      <th>Revenu_2005</th>\n",
              "      <th>Travailleurs_2005</th>\n",
              "      <th>TAAM_2005</th>\n",
              "      <th>Quintile_2005</th>\n",
              "      <th>Rang_2006</th>\n",
              "      <th>IVE_2006</th>\n",
              "      <th>Revenu_2006</th>\n",
              "      <th>Travailleurs_2006</th>\n",
              "      <th>TAAM_2006</th>\n",
              "      <th>Quintile_2006</th>\n",
              "      <th>Rang_2007</th>\n",
              "      <th>IVE_2007</th>\n",
              "      <th>Revenu_2007</th>\n",
              "      <th>Travailleurs_2007</th>\n",
              "      <th>TAAM_2007</th>\n",
              "      <th>Quintile_2007</th>\n",
              "      <th>Rang_2008</th>\n",
              "      <th>IVE_2008</th>\n",
              "      <th>Revenu_2008</th>\n",
              "      <th>Travailleurs_2008</th>\n",
              "      <th>...</th>\n",
              "      <th>Revenu_2009</th>\n",
              "      <th>Travailleurs_2009</th>\n",
              "      <th>TAAM_2009</th>\n",
              "      <th>Quintile_2009</th>\n",
              "      <th>Rang_2010</th>\n",
              "      <th>IVE_2010</th>\n",
              "      <th>Revenu_2010</th>\n",
              "      <th>Travailleurs_2010</th>\n",
              "      <th>TAAM_2010</th>\n",
              "      <th>Quintile_2010</th>\n",
              "      <th>Rang_2011</th>\n",
              "      <th>IVE_2011</th>\n",
              "      <th>Revenu_2011</th>\n",
              "      <th>Travailleurs_2011</th>\n",
              "      <th>TAAM_2011</th>\n",
              "      <th>Quintile_2011</th>\n",
              "      <th>Rang_2012</th>\n",
              "      <th>IVE_2012</th>\n",
              "      <th>Revenu_2012</th>\n",
              "      <th>Travailleurs_2012</th>\n",
              "      <th>TAAM_2012</th>\n",
              "      <th>Quintile_2012</th>\n",
              "      <th>Rang_2013</th>\n",
              "      <th>IVE_2013</th>\n",
              "      <th>Revenu_2013</th>\n",
              "      <th>Travailleurs_2013</th>\n",
              "      <th>TAAM_2013</th>\n",
              "      <th>Quintile_2013</th>\n",
              "      <th>Rang_2014</th>\n",
              "      <th>IVE_2014</th>\n",
              "      <th>Revenu_2014</th>\n",
              "      <th>Travailleurs_2014</th>\n",
              "      <th>TAAM_2014</th>\n",
              "      <th>Quintile_2014</th>\n",
              "      <th>Rang_2016</th>\n",
              "      <th>IVE_2016</th>\n",
              "      <th>Revenu_2016</th>\n",
              "      <th>Travailleurs_2016</th>\n",
              "      <th>TAAM_2016</th>\n",
              "      <th>Quintile_2016</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Nom</th>\n",
              "      <th>Region</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",
              "      <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>Lac-Saint-Joseph (V)</th>\n",
              "      <th>Capitale-Nationale</th>\n",
              "      <td>1</td>\n",
              "      <td>33.7260</td>\n",
              "      <td>39162</td>\n",
              "      <td>70.0</td>\n",
              "      <td>132.5</td>\n",
              "      <td>1</td>\n",
              "      <td>2</td>\n",
              "      <td>32.6030</td>\n",
              "      <td>37295</td>\n",
              "      <td>72.8</td>\n",
              "      <td>112.2</td>\n",
              "      <td>1</td>\n",
              "      <td>2</td>\n",
              "      <td>31.6690</td>\n",
              "      <td>41095</td>\n",
              "      <td>71.4</td>\n",
              "      <td>109.3</td>\n",
              "      <td>1</td>\n",
              "      <td>2</td>\n",
              "      <td>30.3416</td>\n",
              "      <td>41588</td>\n",
              "      <td>72.9</td>\n",
              "      <td>97.4</td>\n",
              "      <td>1</td>\n",
              "      <td>3</td>\n",
              "      <td>29.3327</td>\n",
              "      <td>44868</td>\n",
              "      <td>73.9</td>\n",
              "      <td>69.0</td>\n",
              "      <td>1</td>\n",
              "      <td>24</td>\n",
              "      <td>21.3868</td>\n",
              "      <td>46614</td>\n",
              "      <td>69.7</td>\n",
              "      <td>54.5</td>\n",
              "      <td>1</td>\n",
              "      <td>48</td>\n",
              "      <td>16.9689</td>\n",
              "      <td>47130</td>\n",
              "      <td>70.4</td>\n",
              "      <td>...</td>\n",
              "      <td>48768</td>\n",
              "      <td>69.3</td>\n",
              "      <td>16.3</td>\n",
              "      <td>1</td>\n",
              "      <td>351</td>\n",
              "      <td>3.4107</td>\n",
              "      <td>50775</td>\n",
              "      <td>67.2</td>\n",
              "      <td>-11.5</td>\n",
              "      <td>2</td>\n",
              "      <td>263</td>\n",
              "      <td>5.3343</td>\n",
              "      <td>54643</td>\n",
              "      <td>69.9</td>\n",
              "      <td>-10.9</td>\n",
              "      <td>2</td>\n",
              "      <td>342</td>\n",
              "      <td>3.7008</td>\n",
              "      <td>56493</td>\n",
              "      <td>68.5</td>\n",
              "      <td>-14.3</td>\n",
              "      <td>2</td>\n",
              "      <td>379</td>\n",
              "      <td>2.8579</td>\n",
              "      <td>54489</td>\n",
              "      <td>65.6</td>\n",
              "      <td>-8.6</td>\n",
              "      <td>2</td>\n",
              "      <td>409</td>\n",
              "      <td>2.2830</td>\n",
              "      <td>58185</td>\n",
              "      <td>66.7</td>\n",
              "      <td>-14.7</td>\n",
              "      <td>2</td>\n",
              "      <td>221</td>\n",
              "      <td>6.8622</td>\n",
              "      <td>60550</td>\n",
              "      <td>65.9</td>\n",
              "      <td>3.9</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Lac-Delage (V)</th>\n",
              "      <th>Capitale-Nationale</th>\n",
              "      <td>2</td>\n",
              "      <td>29.9800</td>\n",
              "      <td>38506</td>\n",
              "      <td>80.2</td>\n",
              "      <td>45.4</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>33.5240</td>\n",
              "      <td>40770</td>\n",
              "      <td>83.3</td>\n",
              "      <td>49.8</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>32.5375</td>\n",
              "      <td>41957</td>\n",
              "      <td>79.9</td>\n",
              "      <td>58.8</td>\n",
              "      <td>1</td>\n",
              "      <td>4</td>\n",
              "      <td>27.9531</td>\n",
              "      <td>41780</td>\n",
              "      <td>78.0</td>\n",
              "      <td>51.6</td>\n",
              "      <td>1</td>\n",
              "      <td>10</td>\n",
              "      <td>24.5473</td>\n",
              "      <td>43977</td>\n",
              "      <td>77.7</td>\n",
              "      <td>31.9</td>\n",
              "      <td>1</td>\n",
              "      <td>7</td>\n",
              "      <td>26.1084</td>\n",
              "      <td>46383</td>\n",
              "      <td>83.0</td>\n",
              "      <td>29.9</td>\n",
              "      <td>1</td>\n",
              "      <td>14</td>\n",
              "      <td>23.7555</td>\n",
              "      <td>47595</td>\n",
              "      <td>84.6</td>\n",
              "      <td>...</td>\n",
              "      <td>47460</td>\n",
              "      <td>84.8</td>\n",
              "      <td>-0.8</td>\n",
              "      <td>1</td>\n",
              "      <td>116</td>\n",
              "      <td>11.2865</td>\n",
              "      <td>44672</td>\n",
              "      <td>84.0</td>\n",
              "      <td>-2.3</td>\n",
              "      <td>1</td>\n",
              "      <td>9</td>\n",
              "      <td>22.6683</td>\n",
              "      <td>48336</td>\n",
              "      <td>85.6</td>\n",
              "      <td>23.9</td>\n",
              "      <td>1</td>\n",
              "      <td>8</td>\n",
              "      <td>22.7075</td>\n",
              "      <td>49981</td>\n",
              "      <td>85.2</td>\n",
              "      <td>24.8</td>\n",
              "      <td>1</td>\n",
              "      <td>5</td>\n",
              "      <td>24.8296</td>\n",
              "      <td>49452</td>\n",
              "      <td>86.1</td>\n",
              "      <td>33.1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>28.5563</td>\n",
              "      <td>53285</td>\n",
              "      <td>86.8</td>\n",
              "      <td>43.4</td>\n",
              "      <td>1</td>\n",
              "      <td>8</td>\n",
              "      <td>21.4693</td>\n",
              "      <td>56948</td>\n",
              "      <td>85.2</td>\n",
              "      <td>12.8</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Notre-Dame-de-l'Île-Perrot (V)</th>\n",
              "      <th>Montérégie</th>\n",
              "      <td>3</td>\n",
              "      <td>27.9557</td>\n",
              "      <td>34823</td>\n",
              "      <td>83.0</td>\n",
              "      <td>39.3</td>\n",
              "      <td>1</td>\n",
              "      <td>4</td>\n",
              "      <td>27.4872</td>\n",
              "      <td>36179</td>\n",
              "      <td>83.0</td>\n",
              "      <td>36.6</td>\n",
              "      <td>1</td>\n",
              "      <td>8</td>\n",
              "      <td>25.9467</td>\n",
              "      <td>36666</td>\n",
              "      <td>82.6</td>\n",
              "      <td>34.7</td>\n",
              "      <td>1</td>\n",
              "      <td>9</td>\n",
              "      <td>25.2970</td>\n",
              "      <td>37313</td>\n",
              "      <td>83.4</td>\n",
              "      <td>35.2</td>\n",
              "      <td>1</td>\n",
              "      <td>11</td>\n",
              "      <td>23.7527</td>\n",
              "      <td>38546</td>\n",
              "      <td>83.2</td>\n",
              "      <td>27.6</td>\n",
              "      <td>1</td>\n",
              "      <td>15</td>\n",
              "      <td>23.6618</td>\n",
              "      <td>40124</td>\n",
              "      <td>85.2</td>\n",
              "      <td>27.9</td>\n",
              "      <td>1</td>\n",
              "      <td>20</td>\n",
              "      <td>22.2272</td>\n",
              "      <td>40810</td>\n",
              "      <td>85.1</td>\n",
              "      <td>...</td>\n",
              "      <td>40590</td>\n",
              "      <td>83.3</td>\n",
              "      <td>20.2</td>\n",
              "      <td>1</td>\n",
              "      <td>32</td>\n",
              "      <td>19.7428</td>\n",
              "      <td>41712</td>\n",
              "      <td>83.7</td>\n",
              "      <td>17.4</td>\n",
              "      <td>1</td>\n",
              "      <td>38</td>\n",
              "      <td>16.3068</td>\n",
              "      <td>42674</td>\n",
              "      <td>83.6</td>\n",
              "      <td>13.3</td>\n",
              "      <td>1</td>\n",
              "      <td>56</td>\n",
              "      <td>14.2639</td>\n",
              "      <td>43053</td>\n",
              "      <td>83.9</td>\n",
              "      <td>8.4</td>\n",
              "      <td>1</td>\n",
              "      <td>72</td>\n",
              "      <td>13.2859</td>\n",
              "      <td>43903</td>\n",
              "      <td>83.5</td>\n",
              "      <td>6.4</td>\n",
              "      <td>1</td>\n",
              "      <td>89</td>\n",
              "      <td>11.9666</td>\n",
              "      <td>44077</td>\n",
              "      <td>83.3</td>\n",
              "      <td>4.2</td>\n",
              "      <td>1</td>\n",
              "      <td>100</td>\n",
              "      <td>11.5169</td>\n",
              "      <td>45329</td>\n",
              "      <td>81.9</td>\n",
              "      <td>3.7</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Blainville (V)</th>\n",
              "      <th>Laurentides</th>\n",
              "      <td>4</td>\n",
              "      <td>26.6627</td>\n",
              "      <td>32319</td>\n",
              "      <td>81.7</td>\n",
              "      <td>44.1</td>\n",
              "      <td>1</td>\n",
              "      <td>5</td>\n",
              "      <td>27.0753</td>\n",
              "      <td>33316</td>\n",
              "      <td>81.7</td>\n",
              "      <td>46.3</td>\n",
              "      <td>1</td>\n",
              "      <td>6</td>\n",
              "      <td>27.2232</td>\n",
              "      <td>34737</td>\n",
              "      <td>81.8</td>\n",
              "      <td>48.0</td>\n",
              "      <td>1</td>\n",
              "      <td>6</td>\n",
              "      <td>26.5353</td>\n",
              "      <td>35663</td>\n",
              "      <td>82.1</td>\n",
              "      <td>49.1</td>\n",
              "      <td>1</td>\n",
              "      <td>6</td>\n",
              "      <td>26.6181</td>\n",
              "      <td>36869</td>\n",
              "      <td>81.6</td>\n",
              "      <td>48.2</td>\n",
              "      <td>1</td>\n",
              "      <td>5</td>\n",
              "      <td>26.2952</td>\n",
              "      <td>38371</td>\n",
              "      <td>84.2</td>\n",
              "      <td>45.2</td>\n",
              "      <td>1</td>\n",
              "      <td>10</td>\n",
              "      <td>25.1948</td>\n",
              "      <td>39327</td>\n",
              "      <td>84.2</td>\n",
              "      <td>...</td>\n",
              "      <td>38633</td>\n",
              "      <td>82.9</td>\n",
              "      <td>35.4</td>\n",
              "      <td>1</td>\n",
              "      <td>19</td>\n",
              "      <td>22.0795</td>\n",
              "      <td>39057</td>\n",
              "      <td>82.5</td>\n",
              "      <td>31.1</td>\n",
              "      <td>1</td>\n",
              "      <td>21</td>\n",
              "      <td>18.4891</td>\n",
              "      <td>39825</td>\n",
              "      <td>83.3</td>\n",
              "      <td>26.6</td>\n",
              "      <td>1</td>\n",
              "      <td>28</td>\n",
              "      <td>17.4927</td>\n",
              "      <td>40739</td>\n",
              "      <td>83.5</td>\n",
              "      <td>23.2</td>\n",
              "      <td>1</td>\n",
              "      <td>33</td>\n",
              "      <td>16.7134</td>\n",
              "      <td>41287</td>\n",
              "      <td>83.5</td>\n",
              "      <td>20.5</td>\n",
              "      <td>1</td>\n",
              "      <td>43</td>\n",
              "      <td>15.2215</td>\n",
              "      <td>41725</td>\n",
              "      <td>83.1</td>\n",
              "      <td>17.0</td>\n",
              "      <td>1</td>\n",
              "      <td>45</td>\n",
              "      <td>15.3127</td>\n",
              "      <td>43382</td>\n",
              "      <td>82.8</td>\n",
              "      <td>13.0</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Saint-Lazare (V)</th>\n",
              "      <th>Montérégie</th>\n",
              "      <td>5</td>\n",
              "      <td>25.8718</td>\n",
              "      <td>35209</td>\n",
              "      <td>81.9</td>\n",
              "      <td>32.4</td>\n",
              "      <td>1</td>\n",
              "      <td>7</td>\n",
              "      <td>26.3793</td>\n",
              "      <td>35371</td>\n",
              "      <td>81.5</td>\n",
              "      <td>37.5</td>\n",
              "      <td>1</td>\n",
              "      <td>5</td>\n",
              "      <td>27.2426</td>\n",
              "      <td>36945</td>\n",
              "      <td>81.4</td>\n",
              "      <td>42.5</td>\n",
              "      <td>1</td>\n",
              "      <td>7</td>\n",
              "      <td>26.4277</td>\n",
              "      <td>37457</td>\n",
              "      <td>81.3</td>\n",
              "      <td>45.2</td>\n",
              "      <td>1</td>\n",
              "      <td>5</td>\n",
              "      <td>28.3160</td>\n",
              "      <td>38655</td>\n",
              "      <td>81.0</td>\n",
              "      <td>53.0</td>\n",
              "      <td>1</td>\n",
              "      <td>4</td>\n",
              "      <td>27.6897</td>\n",
              "      <td>39844</td>\n",
              "      <td>83.4</td>\n",
              "      <td>49.7</td>\n",
              "      <td>1</td>\n",
              "      <td>7</td>\n",
              "      <td>26.6117</td>\n",
              "      <td>40221</td>\n",
              "      <td>83.6</td>\n",
              "      <td>...</td>\n",
              "      <td>40160</td>\n",
              "      <td>82.7</td>\n",
              "      <td>36.9</td>\n",
              "      <td>1</td>\n",
              "      <td>13</td>\n",
              "      <td>22.6029</td>\n",
              "      <td>40699</td>\n",
              "      <td>82.1</td>\n",
              "      <td>30.4</td>\n",
              "      <td>1</td>\n",
              "      <td>19</td>\n",
              "      <td>18.5560</td>\n",
              "      <td>41692</td>\n",
              "      <td>83.0</td>\n",
              "      <td>23.6</td>\n",
              "      <td>1</td>\n",
              "      <td>33</td>\n",
              "      <td>16.8047</td>\n",
              "      <td>42353</td>\n",
              "      <td>82.9</td>\n",
              "      <td>18.7</td>\n",
              "      <td>1</td>\n",
              "      <td>49</td>\n",
              "      <td>15.0038</td>\n",
              "      <td>43176</td>\n",
              "      <td>83.2</td>\n",
              "      <td>12.3</td>\n",
              "      <td>1</td>\n",
              "      <td>64</td>\n",
              "      <td>13.4300</td>\n",
              "      <td>43631</td>\n",
              "      <td>83.0</td>\n",
              "      <td>8.8</td>\n",
              "      <td>1</td>\n",
              "      <td>87</td>\n",
              "      <td>12.5642</td>\n",
              "      <td>45418</td>\n",
              "      <td>82.8</td>\n",
              "      <td>4.9</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>L'Ascension-de-Patapédia (M)</th>\n",
              "      <th>Gaspésie–Îles-de-la-Madeleine</th>\n",
              "      <td>1036</td>\n",
              "      <td>-19.9764</td>\n",
              "      <td>14651</td>\n",
              "      <td>39.0</td>\n",
              "      <td>-26.8</td>\n",
              "      <td>5</td>\n",
              "      <td>1040</td>\n",
              "      <td>-22.5422</td>\n",
              "      <td>13746</td>\n",
              "      <td>42.6</td>\n",
              "      <td>-34.3</td>\n",
              "      <td>5</td>\n",
              "      <td>1044</td>\n",
              "      <td>-21.1809</td>\n",
              "      <td>13872</td>\n",
              "      <td>46.0</td>\n",
              "      <td>-31.4</td>\n",
              "      <td>5</td>\n",
              "      <td>1051</td>\n",
              "      <td>-21.6867</td>\n",
              "      <td>14751</td>\n",
              "      <td>42.1</td>\n",
              "      <td>-31.9</td>\n",
              "      <td>5</td>\n",
              "      <td>1048</td>\n",
              "      <td>-18.9776</td>\n",
              "      <td>15873</td>\n",
              "      <td>38.5</td>\n",
              "      <td>-19.7</td>\n",
              "      <td>5</td>\n",
              "      <td>1052</td>\n",
              "      <td>-16.6632</td>\n",
              "      <td>16504</td>\n",
              "      <td>42.7</td>\n",
              "      <td>-13.5</td>\n",
              "      <td>5</td>\n",
              "      <td>1056</td>\n",
              "      <td>-17.6028</td>\n",
              "      <td>16380</td>\n",
              "      <td>45.5</td>\n",
              "      <td>...</td>\n",
              "      <td>18727</td>\n",
              "      <td>43.3</td>\n",
              "      <td>-9.2</td>\n",
              "      <td>5</td>\n",
              "      <td>1077</td>\n",
              "      <td>-21.0685</td>\n",
              "      <td>17391</td>\n",
              "      <td>41.2</td>\n",
              "      <td>-19.1</td>\n",
              "      <td>5</td>\n",
              "      <td>1085</td>\n",
              "      <td>-19.6336</td>\n",
              "      <td>17701</td>\n",
              "      <td>43.6</td>\n",
              "      <td>-20.8</td>\n",
              "      <td>5</td>\n",
              "      <td>1091</td>\n",
              "      <td>-22.0714</td>\n",
              "      <td>18792</td>\n",
              "      <td>42.7</td>\n",
              "      <td>-28.9</td>\n",
              "      <td>5</td>\n",
              "      <td>1094</td>\n",
              "      <td>-23.0353</td>\n",
              "      <td>19332</td>\n",
              "      <td>43.3</td>\n",
              "      <td>-32.5</td>\n",
              "      <td>5</td>\n",
              "      <td>1161</td>\n",
              "      <td>-22.7425</td>\n",
              "      <td>19535</td>\n",
              "      <td>47.7</td>\n",
              "      <td>-35.8</td>\n",
              "      <td>5</td>\n",
              "      <td>1161</td>\n",
              "      <td>-22.1057</td>\n",
              "      <td>20758</td>\n",
              "      <td>45.6</td>\n",
              "      <td>-19.8</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Sainte-Madeleine-de-la-Rivière-Madeleine (M)</th>\n",
              "      <th>Gaspésie–Îles-de-la-Madeleine</th>\n",
              "      <td>1037</td>\n",
              "      <td>-19.9979</td>\n",
              "      <td>13771</td>\n",
              "      <td>41.7</td>\n",
              "      <td>-25.3</td>\n",
              "      <td>5</td>\n",
              "      <td>1042</td>\n",
              "      <td>-24.4379</td>\n",
              "      <td>13976</td>\n",
              "      <td>36.7</td>\n",
              "      <td>-36.4</td>\n",
              "      <td>5</td>\n",
              "      <td>1046</td>\n",
              "      <td>-23.3932</td>\n",
              "      <td>14554</td>\n",
              "      <td>40.3</td>\n",
              "      <td>-36.8</td>\n",
              "      <td>5</td>\n",
              "      <td>1050</td>\n",
              "      <td>-21.6584</td>\n",
              "      <td>15116</td>\n",
              "      <td>41.5</td>\n",
              "      <td>-32.8</td>\n",
              "      <td>5</td>\n",
              "      <td>1055</td>\n",
              "      <td>-21.8774</td>\n",
              "      <td>15056</td>\n",
              "      <td>40.6</td>\n",
              "      <td>-29.9</td>\n",
              "      <td>5</td>\n",
              "      <td>1061</td>\n",
              "      <td>-19.3221</td>\n",
              "      <td>16458</td>\n",
              "      <td>41.7</td>\n",
              "      <td>-21.4</td>\n",
              "      <td>5</td>\n",
              "      <td>1053</td>\n",
              "      <td>-17.1898</td>\n",
              "      <td>16461</td>\n",
              "      <td>42.9</td>\n",
              "      <td>...</td>\n",
              "      <td>17354</td>\n",
              "      <td>42.1</td>\n",
              "      <td>-6.3</td>\n",
              "      <td>5</td>\n",
              "      <td>1076</td>\n",
              "      <td>-20.8894</td>\n",
              "      <td>17284</td>\n",
              "      <td>38.1</td>\n",
              "      <td>-15.8</td>\n",
              "      <td>5</td>\n",
              "      <td>1086</td>\n",
              "      <td>-20.2119</td>\n",
              "      <td>18555</td>\n",
              "      <td>38.8</td>\n",
              "      <td>-20.9</td>\n",
              "      <td>5</td>\n",
              "      <td>1090</td>\n",
              "      <td>-21.8360</td>\n",
              "      <td>18871</td>\n",
              "      <td>40.0</td>\n",
              "      <td>-25.1</td>\n",
              "      <td>5</td>\n",
              "      <td>1095</td>\n",
              "      <td>-24.5141</td>\n",
              "      <td>18910</td>\n",
              "      <td>39.9</td>\n",
              "      <td>-33.2</td>\n",
              "      <td>5</td>\n",
              "      <td>1164</td>\n",
              "      <td>-26.0451</td>\n",
              "      <td>20219</td>\n",
              "      <td>39.5</td>\n",
              "      <td>-42.1</td>\n",
              "      <td>5</td>\n",
              "      <td>1162</td>\n",
              "      <td>-26.9656</td>\n",
              "      <td>20783</td>\n",
              "      <td>43.8</td>\n",
              "      <td>-33.7</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Cloridorme (CT)</th>\n",
              "      <th>Gaspésie–Îles-de-la-Madeleine</th>\n",
              "      <td>1038</td>\n",
              "      <td>-21.1820</td>\n",
              "      <td>14283</td>\n",
              "      <td>43.1</td>\n",
              "      <td>-34.6</td>\n",
              "      <td>5</td>\n",
              "      <td>1039</td>\n",
              "      <td>-22.2865</td>\n",
              "      <td>14972</td>\n",
              "      <td>44.6</td>\n",
              "      <td>-43.5</td>\n",
              "      <td>5</td>\n",
              "      <td>1045</td>\n",
              "      <td>-22.0592</td>\n",
              "      <td>15725</td>\n",
              "      <td>47.4</td>\n",
              "      <td>-49.0</td>\n",
              "      <td>5</td>\n",
              "      <td>1052</td>\n",
              "      <td>-21.9721</td>\n",
              "      <td>17174</td>\n",
              "      <td>43.0</td>\n",
              "      <td>-50.1</td>\n",
              "      <td>5</td>\n",
              "      <td>1053</td>\n",
              "      <td>-20.9406</td>\n",
              "      <td>17161</td>\n",
              "      <td>42.9</td>\n",
              "      <td>-39.0</td>\n",
              "      <td>5</td>\n",
              "      <td>1062</td>\n",
              "      <td>-20.2153</td>\n",
              "      <td>17945</td>\n",
              "      <td>46.4</td>\n",
              "      <td>-37.0</td>\n",
              "      <td>5</td>\n",
              "      <td>1058</td>\n",
              "      <td>-18.0609</td>\n",
              "      <td>19272</td>\n",
              "      <td>49.1</td>\n",
              "      <td>...</td>\n",
              "      <td>20302</td>\n",
              "      <td>48.1</td>\n",
              "      <td>-22.7</td>\n",
              "      <td>5</td>\n",
              "      <td>1038</td>\n",
              "      <td>-14.2952</td>\n",
              "      <td>20206</td>\n",
              "      <td>48.8</td>\n",
              "      <td>-11.7</td>\n",
              "      <td>5</td>\n",
              "      <td>989</td>\n",
              "      <td>-10.3346</td>\n",
              "      <td>21594</td>\n",
              "      <td>51.1</td>\n",
              "      <td>-4.5</td>\n",
              "      <td>5</td>\n",
              "      <td>978</td>\n",
              "      <td>-9.4498</td>\n",
              "      <td>21891</td>\n",
              "      <td>51.5</td>\n",
              "      <td>-0.3</td>\n",
              "      <td>5</td>\n",
              "      <td>966</td>\n",
              "      <td>-9.1454</td>\n",
              "      <td>22607</td>\n",
              "      <td>54.5</td>\n",
              "      <td>-1.9</td>\n",
              "      <td>5</td>\n",
              "      <td>1055</td>\n",
              "      <td>-10.4798</td>\n",
              "      <td>22846</td>\n",
              "      <td>52.9</td>\n",
              "      <td>-3.9</td>\n",
              "      <td>5</td>\n",
              "      <td>1149</td>\n",
              "      <td>-16.8383</td>\n",
              "      <td>24448</td>\n",
              "      <td>52.5</td>\n",
              "      <td>-18.5</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Saint-Guy (M)</th>\n",
              "      <th>Bas-Saint-Laurent</th>\n",
              "      <td>1039</td>\n",
              "      <td>-21.9456</td>\n",
              "      <td>11813</td>\n",
              "      <td>40.6</td>\n",
              "      <td>-23.5</td>\n",
              "      <td>5</td>\n",
              "      <td>1041</td>\n",
              "      <td>-24.2123</td>\n",
              "      <td>13083</td>\n",
              "      <td>40.7</td>\n",
              "      <td>-35.7</td>\n",
              "      <td>5</td>\n",
              "      <td>1047</td>\n",
              "      <td>-26.4298</td>\n",
              "      <td>13198</td>\n",
              "      <td>43.1</td>\n",
              "      <td>-48.1</td>\n",
              "      <td>5</td>\n",
              "      <td>1053</td>\n",
              "      <td>-22.7832</td>\n",
              "      <td>14278</td>\n",
              "      <td>42.3</td>\n",
              "      <td>-35.0</td>\n",
              "      <td>5</td>\n",
              "      <td>1056</td>\n",
              "      <td>-27.1661</td>\n",
              "      <td>12600</td>\n",
              "      <td>37.7</td>\n",
              "      <td>-38.6</td>\n",
              "      <td>5</td>\n",
              "      <td>1065</td>\n",
              "      <td>-26.1567</td>\n",
              "      <td>14309</td>\n",
              "      <td>35.3</td>\n",
              "      <td>-33.3</td>\n",
              "      <td>5</td>\n",
              "      <td>1067</td>\n",
              "      <td>-23.2751</td>\n",
              "      <td>15412</td>\n",
              "      <td>43.4</td>\n",
              "      <td>...</td>\n",
              "      <td>15714</td>\n",
              "      <td>44.9</td>\n",
              "      <td>-17.6</td>\n",
              "      <td>5</td>\n",
              "      <td>1051</td>\n",
              "      <td>-15.7560</td>\n",
              "      <td>16052</td>\n",
              "      <td>53.2</td>\n",
              "      <td>-10.9</td>\n",
              "      <td>5</td>\n",
              "      <td>992</td>\n",
              "      <td>-10.5118</td>\n",
              "      <td>16567</td>\n",
              "      <td>45.0</td>\n",
              "      <td>6.6</td>\n",
              "      <td>5</td>\n",
              "      <td>981</td>\n",
              "      <td>-9.5463</td>\n",
              "      <td>17753</td>\n",
              "      <td>52.5</td>\n",
              "      <td>4.5</td>\n",
              "      <td>5</td>\n",
              "      <td>992</td>\n",
              "      <td>-10.1464</td>\n",
              "      <td>17179</td>\n",
              "      <td>54.5</td>\n",
              "      <td>2.3</td>\n",
              "      <td>5</td>\n",
              "      <td>1151</td>\n",
              "      <td>-17.2458</td>\n",
              "      <td>17722</td>\n",
              "      <td>51.5</td>\n",
              "      <td>-14.3</td>\n",
              "      <td>5</td>\n",
              "      <td>1164</td>\n",
              "      <td>-33.0630</td>\n",
              "      <td>18430</td>\n",
              "      <td>32.1</td>\n",
              "      <td>-35.5</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Saint-Jean-de-Cherbourg (P)</th>\n",
              "      <th>Bas-Saint-Laurent</th>\n",
              "      <td>1040</td>\n",
              "      <td>-22.3496</td>\n",
              "      <td>12949</td>\n",
              "      <td>38.9</td>\n",
              "      <td>-27.7</td>\n",
              "      <td>5</td>\n",
              "      <td>1037</td>\n",
              "      <td>-20.3862</td>\n",
              "      <td>12306</td>\n",
              "      <td>48.3</td>\n",
              "      <td>-26.5</td>\n",
              "      <td>5</td>\n",
              "      <td>1037</td>\n",
              "      <td>-18.9654</td>\n",
              "      <td>13370</td>\n",
              "      <td>42.3</td>\n",
              "      <td>-17.2</td>\n",
              "      <td>5</td>\n",
              "      <td>1034</td>\n",
              "      <td>-15.8451</td>\n",
              "      <td>13503</td>\n",
              "      <td>44.5</td>\n",
              "      <td>-9.1</td>\n",
              "      <td>5</td>\n",
              "      <td>911</td>\n",
              "      <td>-7.5752</td>\n",
              "      <td>14577</td>\n",
              "      <td>43.6</td>\n",
              "      <td>12.3</td>\n",
              "      <td>5</td>\n",
              "      <td>941</td>\n",
              "      <td>-8.2131</td>\n",
              "      <td>15606</td>\n",
              "      <td>39.7</td>\n",
              "      <td>11.2</td>\n",
              "      <td>5</td>\n",
              "      <td>977</td>\n",
              "      <td>-10.3304</td>\n",
              "      <td>16945</td>\n",
              "      <td>43.6</td>\n",
              "      <td>...</td>\n",
              "      <td>17254</td>\n",
              "      <td>44.1</td>\n",
              "      <td>-4.8</td>\n",
              "      <td>5</td>\n",
              "      <td>1074</td>\n",
              "      <td>-19.6911</td>\n",
              "      <td>17564</td>\n",
              "      <td>42.7</td>\n",
              "      <td>-16.5</td>\n",
              "      <td>5</td>\n",
              "      <td>1080</td>\n",
              "      <td>-18.8672</td>\n",
              "      <td>18617</td>\n",
              "      <td>46.0</td>\n",
              "      <td>-23.3</td>\n",
              "      <td>5</td>\n",
              "      <td>1092</td>\n",
              "      <td>-22.7679</td>\n",
              "      <td>19085</td>\n",
              "      <td>42.2</td>\n",
              "      <td>-32.4</td>\n",
              "      <td>5</td>\n",
              "      <td>1092</td>\n",
              "      <td>-20.9882</td>\n",
              "      <td>18567</td>\n",
              "      <td>45.0</td>\n",
              "      <td>-23.8</td>\n",
              "      <td>5</td>\n",
              "      <td>1158</td>\n",
              "      <td>-20.0981</td>\n",
              "      <td>19007</td>\n",
              "      <td>43.0</td>\n",
              "      <td>-18.3</td>\n",
              "      <td>5</td>\n",
              "      <td>1158</td>\n",
              "      <td>-19.2640</td>\n",
              "      <td>20959</td>\n",
              "      <td>47.3</td>\n",
              "      <td>-13.9</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>941 rows × 84 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "                                                                            Rang_2002  ...  Quintile_2016\n",
              "Nom                                          Region                                    ...               \n",
              "Lac-Saint-Joseph (V)                         Capitale-Nationale                     1  ...              1\n",
              "Lac-Delage (V)                               Capitale-Nationale                     2  ...              1\n",
              "Notre-Dame-de-l'Île-Perrot (V)               Montérégie                             3  ...              1\n",
              "Blainville (V)                               Laurentides                            4  ...              1\n",
              "Saint-Lazare (V)                             Montérégie                             5  ...              1\n",
              "...                                                                               ...  ...            ...\n",
              "L'Ascension-de-Patapédia (M)                 Gaspésie–Îles-de-la-Madeleine       1036  ...              5\n",
              "Sainte-Madeleine-de-la-Rivière-Madeleine (M) Gaspésie–Îles-de-la-Madeleine       1037  ...              5\n",
              "Cloridorme (CT)                              Gaspésie–Îles-de-la-Madeleine       1038  ...              5\n",
              "Saint-Guy (M)                                Bas-Saint-Laurent                   1039  ...              5\n",
              "Saint-Jean-de-Cherbourg (P)                  Bas-Saint-Laurent                   1040  ...              5\n",
              "\n",
              "[941 rows x 84 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 196
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "n2FMgs8y1ThZ"
      },
      "source": [
        "ive['Qdif03']=np.where(ive['Quintile_2002']==ive['Quintile_2003'],0, 1)\n",
        "ive['Qdif04']=np.where(ive['Quintile_2003']==ive['Quintile_2004'],0, 1)\n",
        "ive['Qdif05']=np.where(ive['Quintile_2004']==ive['Quintile_2005'],0, 1)\n",
        "ive['Qdif06']=np.where(ive['Quintile_2005']==ive['Quintile_2006'],0, 1)\n",
        "ive['Qdif07']=np.where(ive['Quintile_2006']==ive['Quintile_2007'],0, 1)\n",
        "ive['Qdif08']=np.where(ive['Quintile_2007']==ive['Quintile_2008'],0, 1)\n",
        "ive['Qdif09']=np.where(ive['Quintile_2008']==ive['Quintile_2009'],0, 1)\n",
        "ive['Qdif10']=np.where(ive['Quintile_2009']==ive['Quintile_2010'],0, 1)\n",
        "ive['Qdif11']=np.where(ive['Quintile_2010']==ive['Quintile_2011'],0, 1)\n",
        "ive['Qdif12']=np.where(ive['Quintile_2011']==ive['Quintile_2012'],0, 1)\n",
        "ive['Qdif13']=np.where(ive['Quintile_2012']==ive['Quintile_2013'],0, 1)\n",
        "ive['Qdif14']=np.where(ive['Quintile_2013']==ive['Quintile_2014'],0, 1)\n",
        "ive['Qdif16']=np.where(ive['Quintile_2014']==ive['Quintile_2016'],0, 1)\n",
        "ive['QuintDif']=ive['Qdif03']+ive['Qdif04']+ive['Qdif05']+ive['Qdif06']+ive['Qdif07']+ive['Qdif08']+ive['Qdif09']+ive['Qdif10']+ive['Qdif11']+ive['Qdif12']+ive['Qdif13']+ive['Qdif14']+ive['Qdif16']\n",
        "#ive.sort_values(by='QuintDif', ascending=False)\n",
        "#ive.loc[:,ive.columns.str.startswith(\"Quint\")].sort_values(by='QuintDif', ascending=False)"
      ],
      "execution_count": 197,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "et1VQEIsKhOA",
        "outputId": "7378968b-bf7f-423f-850d-b7e004685f70"
      },
      "source": [
        "ive['QuintDif'].sort_values(ascending=False)"
      ],
      "execution_count": 217,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Nom                             Region              \n",
              "Saint-Onésime-d'Ixworth (M)     Bas-Saint-Laurent       9\n",
              "Saint-Camille (CT)              Estrie                  8\n",
              "Lawrenceville (VL)              Estrie                  8\n",
              "Sheenboro (M)                   Outaouais               8\n",
              "Fortierville (M)                Centre-du-Québec        8\n",
              "                                                       ..\n",
              "Saint-Germain-de-Grantham (M)   Centre-du-Québec        0\n",
              "L'Assomption (V)                Lanaudière              0\n",
              "Sainte-Martine (M)              Montérégie              0\n",
              "Sainte-Lucie-de-Beauregard (M)  Chaudière-Appalaches    0\n",
              "Saint-Jean-de-Cherbourg (P)     Bas-Saint-Laurent       0\n",
              "Name: QuintDif, Length: 941, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 217
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "B5GH-g9QSTYj",
        "outputId": "d1d501bb-4c6e-48be-b19f-7748f2471ce9"
      },
      "source": [
        "ive['Quintile_2002'].loc[ive['QuintDif']==0]"
      ],
      "execution_count": 218,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Nom                                           Region                       \n",
              "Lac-Delage (V)                                Capitale-Nationale               1\n",
              "Notre-Dame-de-l'Île-Perrot (V)                Montérégie                       1\n",
              "Blainville (V)                                Laurentides                      1\n",
              "Saint-Lazare (V)                              Montérégie                       1\n",
              "Cantley (M)                                   Outaouais                        1\n",
              "                                                                              ..\n",
              "L'Ascension-de-Patapédia (M)                  Gaspésie–Îles-de-la-Madeleine    5\n",
              "Sainte-Madeleine-de-la-Rivière-Madeleine (M)  Gaspésie–Îles-de-la-Madeleine    5\n",
              "Cloridorme (CT)                               Gaspésie–Îles-de-la-Madeleine    5\n",
              "Saint-Guy (M)                                 Bas-Saint-Laurent                5\n",
              "Saint-Jean-de-Cherbourg (P)                   Bas-Saint-Laurent                5\n",
              "Name: Quintile_2002, Length: 209, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 218
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "l5fBweJP2DPU",
        "outputId": "d824dfc5-1b69-4c03-a03e-56f2fb55dc1c"
      },
      "source": [
        "ive['Quintile_2002'].loc[(ive['QuintDif']==0) & (ive['Quintile_2002']==1)]"
      ],
      "execution_count": 216,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Nom                             Region            \n",
              "Lac-Delage (V)                  Capitale-Nationale    1\n",
              "Notre-Dame-de-l'Île-Perrot (V)  Montérégie            1\n",
              "Blainville (V)                  Laurentides           1\n",
              "Saint-Lazare (V)                Montérégie            1\n",
              "Cantley (M)                     Outaouais             1\n",
              "                                                     ..\n",
              "Brossard (V)                    Montérégie            1\n",
              "Beloeil (V)                     Montérégie            1\n",
              "La Présentation (M)             Montérégie            1\n",
              "Québec (V)                      Capitale-Nationale    1\n",
              "Saint-Amable (V)                Montérégie            1\n",
              "Name: Quintile_2002, Length: 108, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 216
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "rlEXfBTv1Otu",
        "outputId": "422ac56a-8f6d-49b8-b909-e3857ed75bb9"
      },
      "source": [
        "ive['Quintile_2002'].loc[(ive['QuintDif']==0) & (ive['Quintile_2002']==5)]"
      ],
      "execution_count": 246,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Nom                                           Region                       \n",
              "Saint-Juste-du-Lac (M)                        Bas-Saint-Laurent                5\n",
              "Mont-Albert (NO)                              Gaspésie–Îles-de-la-Madeleine    5\n",
              "Saint-Léon-le-Grand (P)                       Bas-Saint-Laurent                5\n",
              "Chute-aux-Outardes (VL)                       Côte-Nord                        5\n",
              "Padoue (M)                                    Bas-Saint-Laurent                5\n",
              "                                                                              ..\n",
              "L'Ascension-de-Patapédia (M)                  Gaspésie–Îles-de-la-Madeleine    5\n",
              "Sainte-Madeleine-de-la-Rivière-Madeleine (M)  Gaspésie–Îles-de-la-Madeleine    5\n",
              "Cloridorme (CT)                               Gaspésie–Îles-de-la-Madeleine    5\n",
              "Saint-Guy (M)                                 Bas-Saint-Laurent                5\n",
              "Saint-Jean-de-Cherbourg (P)                   Bas-Saint-Laurent                5\n",
              "Name: Quintile_2002, Length: 79, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 246
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "NPCgfJeRXT9C",
        "outputId": "9cc7dcdd-b227-4000-b5c9-22b6fc5408d3"
      },
      "source": [
        "ive['Quintile_2002'].loc[(ive['QuintDif']==0) & (ive['Quintile_2002']==5) & (ive.index.get_level_values(level=1).str.contains(\"Sag\"))]"
      ],
      "execution_count": 248,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Nom                      Region                 \n",
              "Lac-Bouchette (M)        Saguenay–Lac-Saint-Jean    5\n",
              "Petit-Saguenay (M)       Saguenay–Lac-Saint-Jean    5\n",
              "Saint-Thomas-Didyme (M)  Saguenay–Lac-Saint-Jean    5\n",
              "Name: Quintile_2002, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 248
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "QavOn_JvXfqS",
        "outputId": "64d2f0bd-a3d0-42d3-fe84-fd0af51fc667"
      },
      "source": [
        "ive['Quintile_2002'].loc[(ive['QuintDif']==0) & (ive['Quintile_2002']==1) & (ive.index.get_level_values(level=1).str.contains(\"Sag\"))]"
      ],
      "execution_count": 254,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Series([], Name: Quintile_2002, dtype: int64)"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 254
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "nL-mjpH3XvsB",
        "outputId": "f3198c8b-481b-4034-dc7c-b000f8332121"
      },
      "source": [
        "ive['Quintile_2002'].loc[(ive['QuintDif']==0) & (ive['Quintile_2002']==2) & (ive.index.get_level_values(level=1).str.contains(\"Sag\"))]"
      ],
      "execution_count": 256,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Series([], Name: Quintile_2002, dtype: int64)"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 256
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "tWKF4Qc3XyOD",
        "outputId": "5d5cbe6f-a801-43c8-b058-39c9414e1595"
      },
      "source": [
        "ive['Quintile_2002'].loc[(ive['QuintDif']==0) & (ive['Quintile_2002']==3) & (ive.index.get_level_values(level=1).str.contains(\"Sag\"))]"
      ],
      "execution_count": 258,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Nom                 Region                 \n",
              "Saint-Félicien (V)  Saguenay–Lac-Saint-Jean    3\n",
              "Name: Quintile_2002, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 258
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "hOHsnyRmX0xC",
        "outputId": "10932351-64d8-43d0-dcfe-25dcad852887"
      },
      "source": [
        "ive['Quintile_2002'].loc[(ive['QuintDif']==0) & (ive['Quintile_2002']==4) & (ive.index.get_level_values(level=1).str.contains(\"Sag\"))]"
      ],
      "execution_count": 261,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Nom                     Region                 \n",
              "Roberval (V)            Saguenay–Lac-Saint-Jean    4\n",
              "Dolbeau-Mistassini (V)  Saguenay–Lac-Saint-Jean    4\n",
              "Name: Quintile_2002, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 261
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "L97WWexaX7B6",
        "outputId": "77c070f8-dc1d-492b-84b5-a7d758df3116"
      },
      "source": [
        "ive['Quintile_2002'].loc[(ive['QuintDif']==0) & (ive.index.get_level_values(level=1).str.contains(\"Sag\"))].sort_values()"
      ],
      "execution_count": 273,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Nom                      Region                 \n",
              "Saint-Félicien (V)       Saguenay–Lac-Saint-Jean    3\n",
              "Roberval (V)             Saguenay–Lac-Saint-Jean    4\n",
              "Dolbeau-Mistassini (V)   Saguenay–Lac-Saint-Jean    4\n",
              "Lac-Bouchette (M)        Saguenay–Lac-Saint-Jean    5\n",
              "Petit-Saguenay (M)       Saguenay–Lac-Saint-Jean    5\n",
              "Saint-Thomas-Didyme (M)  Saguenay–Lac-Saint-Jean    5\n",
              "Name: Quintile_2002, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 273
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "8t2BmkKNaaj3",
        "outputId": "e319ab25-df20-474d-f6f7-43c1bfc871ab"
      },
      "source": [
        "ive['Quintile_2002'].loc[(ive['QuintDif']>5) & (ive.index.get_level_values(level=1).str.contains(\"Sag\"))].sort_values()"
      ],
      "execution_count": 279,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Nom                      Region                 \n",
              "Sainte-Rose-du-Nord (P)  Saguenay–Lac-Saint-Jean    4\n",
              "Name: Quintile_2002, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 279
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 194
        },
        "id": "6WwiuiEfaolI",
        "outputId": "a058625f-406e-44f6-8903-6d10e867fdda"
      },
      "source": [
        "ive.loc[ive.index.get_level_values(level=0).str.contains(\"Rose-du\"), ive.columns.str.startswith(\"Quint\")] # Le Bonheur de Pierre est sorti en 2009"
      ],
      "execution_count": 283,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th>Quintile_2002</th>\n",
              "      <th>Quintile_2003</th>\n",
              "      <th>Quintile_2004</th>\n",
              "      <th>Quintile_2005</th>\n",
              "      <th>Quintile_2006</th>\n",
              "      <th>Quintile_2007</th>\n",
              "      <th>Quintile_2008</th>\n",
              "      <th>Quintile_2009</th>\n",
              "      <th>Quintile_2010</th>\n",
              "      <th>Quintile_2011</th>\n",
              "      <th>Quintile_2012</th>\n",
              "      <th>Quintile_2013</th>\n",
              "      <th>Quintile_2014</th>\n",
              "      <th>Quintile_2016</th>\n",
              "      <th>QuintDif</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Nom</th>\n",
              "      <th>Region</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>Sainte-Rose-du-Nord (P)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>4</td>\n",
              "      <td>3</td>\n",
              "      <td>4</td>\n",
              "      <td>3</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "      <td>5</td>\n",
              "      <td>5</td>\n",
              "      <td>5</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "      <td>6</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                                                 Quintile_2002  ...  QuintDif\n",
              "Nom                     Region                                  ...          \n",
              "Sainte-Rose-du-Nord (P) Saguenay–Lac-Saint-Jean              4  ...         6\n",
              "\n",
              "[1 rows x 15 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 283
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "oZ3A1RbqSrY1",
        "outputId": "213fe884-20b9-4ce8-81e5-e41d658c9817"
      },
      "source": [
        "ive['Quintile_2002'].loc[(ive['QuintDif']==0) & (ive['Quintile_2002']==5)].sort_index(level='Region', ascending=False)"
      ],
      "execution_count": 238,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Nom                        Region                 \n",
              "Saint-Thomas-Didyme (M)    Saguenay–Lac-Saint-Jean    5\n",
              "Petit-Saguenay (M)         Saguenay–Lac-Saint-Jean    5\n",
              "Lac-Bouchette (M)          Saguenay–Lac-Saint-Jean    5\n",
              "Saint-Joseph-de-Sorel (V)  Montérégie                 5\n",
              "Lac-du-Cerf (M)            Laurentides                5\n",
              "                                                     ..\n",
              "Rémigny (M)                Abitibi-Témiscamingue      5\n",
              "Rochebaucourt (M)          Abitibi-Témiscamingue      5\n",
              "Normétal (M)               Abitibi-Témiscamingue      5\n",
              "Latulipe-et-Gaboury (CU)   Abitibi-Témiscamingue      5\n",
              "La Morandière (M)          Abitibi-Témiscamingue      5\n",
              "Name: Quintile_2002, Length: 79, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 238
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "87TJyVJ0WPLN",
        "outputId": "46395a26-1420-4843-8504-fe04a5ecbfd6"
      },
      "source": [
        "ive.loc[ive.index.get_level_values(level=1).str.contains(\"Sag\")].reindex(columns=['QuintDif', 'Quintile_2002', 'Quintile_2016']).sort_values(by='Nom')"
      ],
      "execution_count": 272,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th>QuintDif</th>\n",
              "      <th>Quintile_2002</th>\n",
              "      <th>Quintile_2016</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Nom</th>\n",
              "      <th>Region</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>Albanel (M)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>1</td>\n",
              "      <td>4</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Alma (V)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>2</td>\n",
              "      <td>3</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Bégin (M)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>2</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Chambord (M)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>1</td>\n",
              "      <td>4</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Desbiens (V)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>1</td>\n",
              "      <td>5</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Dolbeau-Mistassini (V)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>0</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Ferland-et-Boilleau (M)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>2</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Girardville (M)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>2</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Hébertville (M)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>4</td>\n",
              "      <td>3</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Hébertville-Station (VL)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>3</td>\n",
              "      <td>5</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>L'Anse-Saint-Jean (M)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>3</td>\n",
              "      <td>5</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>L'Ascension-de-Notre-Seigneur (P)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>1</td>\n",
              "      <td>4</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>La Doré (P)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>2</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Labrecque (M)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>2</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Lac-Bouchette (M)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>0</td>\n",
              "      <td>5</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Lamarche (M)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>4</td>\n",
              "      <td>5</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Larouche (M)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>1</td>\n",
              "      <td>3</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Mashteuiatsh (R)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>5</td>\n",
              "      <td>5</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Métabetchouan--Lac-à-la-Croix (V)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>3</td>\n",
              "      <td>4</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Normandin (V)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>3</td>\n",
              "      <td>4</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Passes-Dangereuses (NO)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>4</td>\n",
              "      <td>5</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Petit-Saguenay (M)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>0</td>\n",
              "      <td>5</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Péribonka (M)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>2</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Rivière-Éternité (M)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>4</td>\n",
              "      <td>5</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Roberval (V)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>0</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Saguenay (V)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>2</td>\n",
              "      <td>3</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Saint-Ambroise (M)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>2</td>\n",
              "      <td>4</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Saint-André-du-Lac-Saint-Jean (VL)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>1</td>\n",
              "      <td>5</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Saint-Augustin (P)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>5</td>\n",
              "      <td>5</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Saint-Bruno (M)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>4</td>\n",
              "      <td>3</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Saint-Charles-de-Bourget (M)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Saint-David-de-Falardeau (M)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>4</td>\n",
              "      <td>3</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Saint-Edmond-les-Plaines (M)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>1</td>\n",
              "      <td>5</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Saint-François-de-Sales (M)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>1</td>\n",
              "      <td>4</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Saint-Fulgence (M)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>4</td>\n",
              "      <td>3</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Saint-Félicien (V)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>0</td>\n",
              "      <td>3</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Saint-Félix-d'Otis (M)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>3</td>\n",
              "      <td>3</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Saint-Gédéon (M)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>1</td>\n",
              "      <td>3</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Saint-Henri-de-Taillon (M)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>3</td>\n",
              "      <td>3</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Saint-Honoré (V)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>4</td>\n",
              "      <td>3</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Saint-Ludger-de-Milot (M)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>2</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Saint-Nazaire (M)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>3</td>\n",
              "      <td>4</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Saint-Prime (M)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>2</td>\n",
              "      <td>2</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Saint-Stanislas (M)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>5</td>\n",
              "      <td>4</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Saint-Thomas-Didyme (M)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>0</td>\n",
              "      <td>5</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Sainte-Hedwidge (M)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Sainte-Jeanne-d'Arc (VL)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>3</td>\n",
              "      <td>5</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Sainte-Monique (M)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Sainte-Rose-du-Nord (P)</th>\n",
              "      <th>Saguenay–Lac-Saint-Jean</th>\n",
              "      <td>6</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                                                            QuintDif  ...  Quintile_2016\n",
              "Nom                                Region                             ...               \n",
              "Albanel (M)                        Saguenay–Lac-Saint-Jean         1  ...              3\n",
              "Alma (V)                           Saguenay–Lac-Saint-Jean         2  ...              3\n",
              "Bégin (M)                          Saguenay–Lac-Saint-Jean         2  ...              4\n",
              "Chambord (M)                       Saguenay–Lac-Saint-Jean         1  ...              3\n",
              "Desbiens (V)                       Saguenay–Lac-Saint-Jean         1  ...              4\n",
              "Dolbeau-Mistassini (V)             Saguenay–Lac-Saint-Jean         0  ...              4\n",
              "Ferland-et-Boilleau (M)            Saguenay–Lac-Saint-Jean         2  ...              4\n",
              "Girardville (M)                    Saguenay–Lac-Saint-Jean         2  ...              4\n",
              "Hébertville (M)                    Saguenay–Lac-Saint-Jean         4  ...              3\n",
              "Hébertville-Station (VL)           Saguenay–Lac-Saint-Jean         3  ...              2\n",
              "L'Anse-Saint-Jean (M)              Saguenay–Lac-Saint-Jean         3  ...              4\n",
              "L'Ascension-de-Notre-Seigneur (P)  Saguenay–Lac-Saint-Jean         1  ...              3\n",
              "La Doré (P)                        Saguenay–Lac-Saint-Jean         2  ...              4\n",
              "Labrecque (M)                      Saguenay–Lac-Saint-Jean         2  ...              4\n",
              "Lac-Bouchette (M)                  Saguenay–Lac-Saint-Jean         0  ...              5\n",
              "Lamarche (M)                       Saguenay–Lac-Saint-Jean         4  ...              5\n",
              "Larouche (M)                       Saguenay–Lac-Saint-Jean         1  ...              2\n",
              "Mashteuiatsh (R)                   Saguenay–Lac-Saint-Jean         5  ...              4\n",
              "Métabetchouan--Lac-à-la-Croix (V)  Saguenay–Lac-Saint-Jean         3  ...              3\n",
              "Normandin (V)                      Saguenay–Lac-Saint-Jean         3  ...              3\n",
              "Passes-Dangereuses (NO)            Saguenay–Lac-Saint-Jean         4  ...              5\n",
              "Petit-Saguenay (M)                 Saguenay–Lac-Saint-Jean         0  ...              5\n",
              "Péribonka (M)                      Saguenay–Lac-Saint-Jean         2  ...              4\n",
              "Rivière-Éternité (M)               Saguenay–Lac-Saint-Jean         4  ...              5\n",
              "Roberval (V)                       Saguenay–Lac-Saint-Jean         0  ...              4\n",
              "Saguenay (V)                       Saguenay–Lac-Saint-Jean         2  ...              3\n",
              "Saint-Ambroise (M)                 Saguenay–Lac-Saint-Jean         2  ...              2\n",
              "Saint-André-du-Lac-Saint-Jean (VL) Saguenay–Lac-Saint-Jean         1  ...              4\n",
              "Saint-Augustin (P)                 Saguenay–Lac-Saint-Jean         5  ...              4\n",
              "Saint-Bruno (M)                    Saguenay–Lac-Saint-Jean         4  ...              1\n",
              "Saint-Charles-de-Bourget (M)       Saguenay–Lac-Saint-Jean         4  ...              2\n",
              "Saint-David-de-Falardeau (M)       Saguenay–Lac-Saint-Jean         4  ...              3\n",
              "Saint-Edmond-les-Plaines (M)       Saguenay–Lac-Saint-Jean         1  ...              4\n",
              "Saint-François-de-Sales (M)        Saguenay–Lac-Saint-Jean         1  ...              5\n",
              "Saint-Fulgence (M)                 Saguenay–Lac-Saint-Jean         4  ...              2\n",
              "Saint-Félicien (V)                 Saguenay–Lac-Saint-Jean         0  ...              3\n",
              "Saint-Félix-d'Otis (M)             Saguenay–Lac-Saint-Jean         3  ...              2\n",
              "Saint-Gédéon (M)                   Saguenay–Lac-Saint-Jean         1  ...              2\n",
              "Saint-Henri-de-Taillon (M)         Saguenay–Lac-Saint-Jean         3  ...              4\n",
              "Saint-Honoré (V)                   Saguenay–Lac-Saint-Jean         4  ...              1\n",
              "Saint-Ludger-de-Milot (M)          Saguenay–Lac-Saint-Jean         2  ...              4\n",
              "Saint-Nazaire (M)                  Saguenay–Lac-Saint-Jean         3  ...              3\n",
              "Saint-Prime (M)                    Saguenay–Lac-Saint-Jean         2  ...              2\n",
              "Saint-Stanislas (M)                Saguenay–Lac-Saint-Jean         5  ...              3\n",
              "Saint-Thomas-Didyme (M)            Saguenay–Lac-Saint-Jean         0  ...              5\n",
              "Sainte-Hedwidge (M)                Saguenay–Lac-Saint-Jean         4  ...              3\n",
              "Sainte-Jeanne-d'Arc (VL)           Saguenay–Lac-Saint-Jean         3  ...              4\n",
              "Sainte-Monique (M)                 Saguenay–Lac-Saint-Jean         4  ...              4\n",
              "Sainte-Rose-du-Nord (P)            Saguenay–Lac-Saint-Jean         6  ...              4\n",
              "\n",
              "[49 rows x 3 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 272
        }
      ]
    }
  ]
}