2_bdd_finale_merged.ipynb

{
 "cells": [
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Construction bdd finale merged avec données température"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd "
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Données ENEDIS"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "\"Ce jeu de données restitue la consommation d’électricité au pas 1/2h des points de soutirage <= 36kVA raccordés au réseau Enedis. Il donne les volumes d'énergie soutirés, les courbes de charge moyennes de clients dotés de compteurs communicants et le nombre de clients. Ces agrégats sont disponibles par plage de puissance souscrite, profil et région.\""
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Dictionnaire des variables : https://data.enedis.fr/api/datasets/1.0/conso-inf36-region/attachments/note_externe_jdd_article_23_pdf/"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "metadata": {},
   "outputs": [],
   "source": [
    "enedis_2020=pd.read_csv(\"Données/enedis_2020.csv\")\n",
    "enedis_2021=pd.read_csv(\"Données/enedis_2021.csv\")\n",
    "\n",
    "enedis=pd.concat([enedis_2020,enedis_2021])\n",
    "enedis.drop_duplicates(inplace=True)\n",
    "enedis.sort_values(\"horodate\",inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>horodate</th>\n",
       "      <th>region</th>\n",
       "      <th>code_region</th>\n",
       "      <th>total_energie_soutiree_wh</th>\n",
       "      <th>plage_de_puissance_souscrite</th>\n",
       "      <th>nb_points_soutirage</th>\n",
       "      <th>jour_max_du_mois_0_1</th>\n",
       "      <th>semaine_max_du_mois_0_1</th>\n",
       "      <th>profil</th>\n",
       "      <th>profil_type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-06-04T00:00:00+00:00</td>\n",
       "      <td>Auvergne-Rhône-Alpes</td>\n",
       "      <td>84</td>\n",
       "      <td>2799437.0</td>\n",
       "      <td>P5: ]12-15] kVA</td>\n",
       "      <td>10621</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>PRO1 (+ PRO1WE)</td>\n",
       "      <td>PRO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>598</th>\n",
       "      <td>2020-06-04T00:00:00+00:00</td>\n",
       "      <td>Provence-Alpes-Côte d'Azur</td>\n",
       "      <td>93</td>\n",
       "      <td>1728585.0</td>\n",
       "      <td>P6: ]15-18] kVA</td>\n",
       "      <td>2184</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>PRO3</td>\n",
       "      <td>PRO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>599</th>\n",
       "      <td>2020-06-04T00:00:00+00:00</td>\n",
       "      <td>Auvergne-Rhône-Alpes</td>\n",
       "      <td>84</td>\n",
       "      <td>8589737.0</td>\n",
       "      <td>P3: ]6-9] kVA</td>\n",
       "      <td>60839</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>PRO1 (+ PRO1WE)</td>\n",
       "      <td>PRO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600</th>\n",
       "      <td>2020-06-04T00:00:00+00:00</td>\n",
       "      <td>Auvergne-Rhône-Alpes</td>\n",
       "      <td>84</td>\n",
       "      <td>16135438.0</td>\n",
       "      <td>P6: ]15-18] kVA</td>\n",
       "      <td>51910</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>PRO1 (+ PRO1WE)</td>\n",
       "      <td>PRO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>601</th>\n",
       "      <td>2020-06-04T00:00:00+00:00</td>\n",
       "      <td>Auvergne-Rhône-Alpes</td>\n",
       "      <td>84</td>\n",
       "      <td>16634527.0</td>\n",
       "      <td>P9: ]30-36] kVA</td>\n",
       "      <td>12497</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>PRO2 (+ PRO2WE + PRO6)</td>\n",
       "      <td>PRO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9719463</th>\n",
       "      <td>2021-08-15T00:00:00+00:00</td>\n",
       "      <td>Hauts-de-France</td>\n",
       "      <td>32</td>\n",
       "      <td>43857840.0</td>\n",
       "      <td>P0: Total &lt;= 36 kVA</td>\n",
       "      <td>72969</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>PRO2 (+ PRO2WE + PRO6)</td>\n",
       "      <td>PRO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9719464</th>\n",
       "      <td>2021-08-15T00:00:00+00:00</td>\n",
       "      <td>Pays de la Loire</td>\n",
       "      <td>52</td>\n",
       "      <td>9344100.0</td>\n",
       "      <td>P6: ]15-18] kVA</td>\n",
       "      <td>20440</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES2 (+ RES5)</td>\n",
       "      <td>RES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9719465</th>\n",
       "      <td>2021-08-15T00:00:00+00:00</td>\n",
       "      <td>Grand-Est</td>\n",
       "      <td>44</td>\n",
       "      <td>586136.0</td>\n",
       "      <td>P6: ]15-18] kVA</td>\n",
       "      <td>906</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>PRO3</td>\n",
       "      <td>PRO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9719454</th>\n",
       "      <td>2021-08-15T00:00:00+00:00</td>\n",
       "      <td>Grand-Est</td>\n",
       "      <td>44</td>\n",
       "      <td>7963365.0</td>\n",
       "      <td>P1: ]0-3] kVA</td>\n",
       "      <td>19448</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>PRO5</td>\n",
       "      <td>PRO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9720055</th>\n",
       "      <td>2021-08-15T00:00:00+00:00</td>\n",
       "      <td>Normandie</td>\n",
       "      <td>28</td>\n",
       "      <td>964757.0</td>\n",
       "      <td>P5: ]12-15] kVA</td>\n",
       "      <td>4717</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES11 (+ RES11WE)</td>\n",
       "      <td>RES</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>18894156 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                          horodate                      region  code_region  \\\n",
       "0        2020-06-04T00:00:00+00:00        Auvergne-Rhône-Alpes           84   \n",
       "598      2020-06-04T00:00:00+00:00  Provence-Alpes-Côte d'Azur           93   \n",
       "599      2020-06-04T00:00:00+00:00        Auvergne-Rhône-Alpes           84   \n",
       "600      2020-06-04T00:00:00+00:00        Auvergne-Rhône-Alpes           84   \n",
       "601      2020-06-04T00:00:00+00:00        Auvergne-Rhône-Alpes           84   \n",
       "...                            ...                         ...          ...   \n",
       "9719463  2021-08-15T00:00:00+00:00             Hauts-de-France           32   \n",
       "9719464  2021-08-15T00:00:00+00:00            Pays de la Loire           52   \n",
       "9719465  2021-08-15T00:00:00+00:00                   Grand-Est           44   \n",
       "9719454  2021-08-15T00:00:00+00:00                   Grand-Est           44   \n",
       "9720055  2021-08-15T00:00:00+00:00                   Normandie           28   \n",
       "\n",
       "         total_energie_soutiree_wh plage_de_puissance_souscrite  \\\n",
       "0                        2799437.0              P5: ]12-15] kVA   \n",
       "598                      1728585.0              P6: ]15-18] kVA   \n",
       "599                      8589737.0                P3: ]6-9] kVA   \n",
       "600                     16135438.0              P6: ]15-18] kVA   \n",
       "601                     16634527.0              P9: ]30-36] kVA   \n",
       "...                            ...                          ...   \n",
       "9719463                 43857840.0          P0: Total <= 36 kVA   \n",
       "9719464                  9344100.0              P6: ]15-18] kVA   \n",
       "9719465                   586136.0              P6: ]15-18] kVA   \n",
       "9719454                  7963365.0                P1: ]0-3] kVA   \n",
       "9720055                   964757.0              P5: ]12-15] kVA   \n",
       "\n",
       "         nb_points_soutirage  jour_max_du_mois_0_1  semaine_max_du_mois_0_1  \\\n",
       "0                      10621                     0                        0   \n",
       "598                     2184                     0                        0   \n",
       "599                    60839                     0                        0   \n",
       "600                    51910                     0                        0   \n",
       "601                    12497                     0                        0   \n",
       "...                      ...                   ...                      ...   \n",
       "9719463                72969                     0                        0   \n",
       "9719464                20440                     0                        0   \n",
       "9719465                  906                     0                        0   \n",
       "9719454                19448                     0                        0   \n",
       "9720055                 4717                     0                        0   \n",
       "\n",
       "                         profil profil_type  \n",
       "0               PRO1 (+ PRO1WE)         PRO  \n",
       "598                        PRO3         PRO  \n",
       "599             PRO1 (+ PRO1WE)         PRO  \n",
       "600             PRO1 (+ PRO1WE)         PRO  \n",
       "601      PRO2 (+ PRO2WE + PRO6)         PRO  \n",
       "...                         ...         ...  \n",
       "9719463  PRO2 (+ PRO2WE + PRO6)         PRO  \n",
       "9719464           RES2 (+ RES5)         RES  \n",
       "9719465                    PRO3         PRO  \n",
       "9719454                    PRO5         PRO  \n",
       "9720055       RES11 (+ RES11WE)         RES  \n",
       "\n",
       "[18894156 rows x 10 columns]"
      ]
     },
     "execution_count": 67,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "enedis[\"profil_type\"]=enedis[\"profil\"].apply(lambda x : x[0:3])\n",
    "enedis"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {},
   "outputs": [],
   "source": [
    "enedis.drop(enedis[enedis[\"profil_type\"]!=\"RES\"].index,inplace=True)"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "On récupère la date :\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>horodate</th>\n",
       "      <th>region</th>\n",
       "      <th>code_region</th>\n",
       "      <th>total_energie_soutiree_wh</th>\n",
       "      <th>plage_de_puissance_souscrite</th>\n",
       "      <th>nb_points_soutirage</th>\n",
       "      <th>jour_max_du_mois_0_1</th>\n",
       "      <th>semaine_max_du_mois_0_1</th>\n",
       "      <th>profil</th>\n",
       "      <th>profil_type</th>\n",
       "      <th>date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>602</th>\n",
       "      <td>2020-06-04T00:00:00+00:00</td>\n",
       "      <td>Auvergne-Rhône-Alpes</td>\n",
       "      <td>84</td>\n",
       "      <td>130666817.0</td>\n",
       "      <td>P2: ]3-6] kVA</td>\n",
       "      <td>1685439</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES1 (+ RES1WE)</td>\n",
       "      <td>RES</td>\n",
       "      <td>2020-06-04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603</th>\n",
       "      <td>2020-06-04T00:00:00+00:00</td>\n",
       "      <td>Auvergne-Rhône-Alpes</td>\n",
       "      <td>84</td>\n",
       "      <td>436083.0</td>\n",
       "      <td>P8: ]24-30] kVA</td>\n",
       "      <td>901</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES11 (+ RES11WE)</td>\n",
       "      <td>RES</td>\n",
       "      <td>2020-06-04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>604</th>\n",
       "      <td>2020-06-04T00:00:00+00:00</td>\n",
       "      <td>Auvergne-Rhône-Alpes</td>\n",
       "      <td>84</td>\n",
       "      <td>2133213.0</td>\n",
       "      <td>P9: ]30-36] kVA</td>\n",
       "      <td>3839</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES11 (+ RES11WE)</td>\n",
       "      <td>RES</td>\n",
       "      <td>2020-06-04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>605</th>\n",
       "      <td>2020-06-04T00:00:00+00:00</td>\n",
       "      <td>Auvergne-Rhône-Alpes</td>\n",
       "      <td>84</td>\n",
       "      <td>104448854.0</td>\n",
       "      <td>P4: ]9-12] kVA</td>\n",
       "      <td>269648</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES2 (+ RES5)</td>\n",
       "      <td>RES</td>\n",
       "      <td>2020-06-04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>606</th>\n",
       "      <td>2020-06-04T00:00:00+00:00</td>\n",
       "      <td>Auvergne-Rhône-Alpes</td>\n",
       "      <td>84</td>\n",
       "      <td>804838.0</td>\n",
       "      <td>P4: ]9-12] kVA</td>\n",
       "      <td>1830</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES2WE</td>\n",
       "      <td>RES</td>\n",
       "      <td>2020-06-04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9719458</th>\n",
       "      <td>2021-08-15T00:00:00+00:00</td>\n",
       "      <td>Grand-Est</td>\n",
       "      <td>44</td>\n",
       "      <td>2278143.0</td>\n",
       "      <td>P0: Total &lt;= 36 kVA</td>\n",
       "      <td>13717</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES2WE</td>\n",
       "      <td>RES</td>\n",
       "      <td>2021-08-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9719459</th>\n",
       "      <td>2021-08-15T00:00:00+00:00</td>\n",
       "      <td>Grand-Est</td>\n",
       "      <td>44</td>\n",
       "      <td>4639000.0</td>\n",
       "      <td>P0: Total &lt;= 36 kVA</td>\n",
       "      <td>14822</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES3</td>\n",
       "      <td>RES</td>\n",
       "      <td>2021-08-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9719460</th>\n",
       "      <td>2021-08-15T00:00:00+00:00</td>\n",
       "      <td>Grand-Est</td>\n",
       "      <td>44</td>\n",
       "      <td>1200637.0</td>\n",
       "      <td>P6: ]15-18] kVA</td>\n",
       "      <td>3395</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES3</td>\n",
       "      <td>RES</td>\n",
       "      <td>2021-08-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9719464</th>\n",
       "      <td>2021-08-15T00:00:00+00:00</td>\n",
       "      <td>Pays de la Loire</td>\n",
       "      <td>52</td>\n",
       "      <td>9344100.0</td>\n",
       "      <td>P6: ]15-18] kVA</td>\n",
       "      <td>20440</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES2 (+ RES5)</td>\n",
       "      <td>RES</td>\n",
       "      <td>2021-08-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9720055</th>\n",
       "      <td>2021-08-15T00:00:00+00:00</td>\n",
       "      <td>Normandie</td>\n",
       "      <td>28</td>\n",
       "      <td>964757.0</td>\n",
       "      <td>P5: ]12-15] kVA</td>\n",
       "      <td>4717</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES11 (+ RES11WE)</td>\n",
       "      <td>RES</td>\n",
       "      <td>2021-08-15</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4876517 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                          horodate                region  code_region  \\\n",
       "602      2020-06-04T00:00:00+00:00  Auvergne-Rhône-Alpes           84   \n",
       "603      2020-06-04T00:00:00+00:00  Auvergne-Rhône-Alpes           84   \n",
       "604      2020-06-04T00:00:00+00:00  Auvergne-Rhône-Alpes           84   \n",
       "605      2020-06-04T00:00:00+00:00  Auvergne-Rhône-Alpes           84   \n",
       "606      2020-06-04T00:00:00+00:00  Auvergne-Rhône-Alpes           84   \n",
       "...                            ...                   ...          ...   \n",
       "9719458  2021-08-15T00:00:00+00:00             Grand-Est           44   \n",
       "9719459  2021-08-15T00:00:00+00:00             Grand-Est           44   \n",
       "9719460  2021-08-15T00:00:00+00:00             Grand-Est           44   \n",
       "9719464  2021-08-15T00:00:00+00:00      Pays de la Loire           52   \n",
       "9720055  2021-08-15T00:00:00+00:00             Normandie           28   \n",
       "\n",
       "         total_energie_soutiree_wh plage_de_puissance_souscrite  \\\n",
       "602                    130666817.0                P2: ]3-6] kVA   \n",
       "603                       436083.0              P8: ]24-30] kVA   \n",
       "604                      2133213.0              P9: ]30-36] kVA   \n",
       "605                    104448854.0               P4: ]9-12] kVA   \n",
       "606                       804838.0               P4: ]9-12] kVA   \n",
       "...                            ...                          ...   \n",
       "9719458                  2278143.0          P0: Total <= 36 kVA   \n",
       "9719459                  4639000.0          P0: Total <= 36 kVA   \n",
       "9719460                  1200637.0              P6: ]15-18] kVA   \n",
       "9719464                  9344100.0              P6: ]15-18] kVA   \n",
       "9720055                   964757.0              P5: ]12-15] kVA   \n",
       "\n",
       "         nb_points_soutirage  jour_max_du_mois_0_1  semaine_max_du_mois_0_1  \\\n",
       "602                  1685439                     0                        0   \n",
       "603                      901                     0                        0   \n",
       "604                     3839                     0                        0   \n",
       "605                   269648                     0                        0   \n",
       "606                     1830                     0                        0   \n",
       "...                      ...                   ...                      ...   \n",
       "9719458                13717                     0                        0   \n",
       "9719459                14822                     0                        0   \n",
       "9719460                 3395                     0                        0   \n",
       "9719464                20440                     0                        0   \n",
       "9720055                 4717                     0                        0   \n",
       "\n",
       "                    profil profil_type        date  \n",
       "602        RES1 (+ RES1WE)         RES  2020-06-04  \n",
       "603      RES11 (+ RES11WE)         RES  2020-06-04  \n",
       "604      RES11 (+ RES11WE)         RES  2020-06-04  \n",
       "605          RES2 (+ RES5)         RES  2020-06-04  \n",
       "606                 RES2WE         RES  2020-06-04  \n",
       "...                    ...         ...         ...  \n",
       "9719458             RES2WE         RES  2021-08-15  \n",
       "9719459               RES3         RES  2021-08-15  \n",
       "9719460               RES3         RES  2021-08-15  \n",
       "9719464      RES2 (+ RES5)         RES  2021-08-15  \n",
       "9720055  RES11 (+ RES11WE)         RES  2021-08-15  \n",
       "\n",
       "[4876517 rows x 11 columns]"
      ]
     },
     "execution_count": 70,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "## On extrait la date pour classifier par jour \n",
    "enedis[\"date\"]=enedis[\"horodate\"].apply(lambda x : x[0:10])\n",
    "enedis"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Données sur les nombres de ménage : "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code_reg</th>\n",
       "      <th>nom_reg</th>\n",
       "      <th>Ensemble</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>84</td>\n",
       "      <td>Auvergne-Rhône-Alpes</td>\n",
       "      <td>3606282</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>27</td>\n",
       "      <td>Bourgogne-Franche-Comté</td>\n",
       "      <td>1299216</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>53</td>\n",
       "      <td>Bretagne</td>\n",
       "      <td>1548963</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>24</td>\n",
       "      <td>Centre-Val de Loire</td>\n",
       "      <td>1167419</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>94</td>\n",
       "      <td>Corse</td>\n",
       "      <td>151391</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>44</td>\n",
       "      <td>Grand Est</td>\n",
       "      <td>2498203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>32</td>\n",
       "      <td>Hauts-de-France</td>\n",
       "      <td>2561265</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>11</td>\n",
       "      <td>Île-de-France</td>\n",
       "      <td>5255900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>28</td>\n",
       "      <td>Normandie</td>\n",
       "      <td>1500834</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>75</td>\n",
       "      <td>Nouvelle-Aquitaine</td>\n",
       "      <td>2821985</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>76</td>\n",
       "      <td>Occitanie</td>\n",
       "      <td>2761061</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>52</td>\n",
       "      <td>Pays de la Loire</td>\n",
       "      <td>1695032</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>93</td>\n",
       "      <td>Provence-Alpes-Côte d'Azur</td>\n",
       "      <td>2331136</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    code_reg                     nom_reg  Ensemble\n",
       "0         84        Auvergne-Rhône-Alpes   3606282\n",
       "1         27     Bourgogne-Franche-Comté   1299216\n",
       "2         53                    Bretagne   1548963\n",
       "3         24         Centre-Val de Loire   1167419\n",
       "4         94                       Corse    151391\n",
       "5         44                   Grand Est   2498203\n",
       "6         32             Hauts-de-France   2561265\n",
       "7         11               Île-de-France   5255900\n",
       "8         28                   Normandie   1500834\n",
       "9         75          Nouvelle-Aquitaine   2821985\n",
       "10        76                   Occitanie   2761061\n",
       "11        52            Pays de la Loire   1695032\n",
       "12        93  Provence-Alpes-Côte d'Azur   2331136"
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "menage=pd.read_csv(\"Données/nb_ménages.csv\",sep=\";\")\n",
    "menage"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "metadata": {},
   "outputs": [],
   "source": [
    "enedis_menage=enedis.merge(menage,how=\"left\",right_on=\"code_reg\",left_on=\"code_region\")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>horodate</th>\n",
       "      <th>region</th>\n",
       "      <th>code_region</th>\n",
       "      <th>total_energie_soutiree_wh</th>\n",
       "      <th>plage_de_puissance_souscrite</th>\n",
       "      <th>nb_points_soutirage</th>\n",
       "      <th>jour_max_du_mois_0_1</th>\n",
       "      <th>semaine_max_du_mois_0_1</th>\n",
       "      <th>profil</th>\n",
       "      <th>profil_type</th>\n",
       "      <th>date</th>\n",
       "      <th>code_reg</th>\n",
       "      <th>nom_reg</th>\n",
       "      <th>Ensemble</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-06-04T00:00:00+00:00</td>\n",
       "      <td>Auvergne-Rhône-Alpes</td>\n",
       "      <td>84</td>\n",
       "      <td>130666817.0</td>\n",
       "      <td>P2: ]3-6] kVA</td>\n",
       "      <td>1685439</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES1 (+ RES1WE)</td>\n",
       "      <td>RES</td>\n",
       "      <td>2020-06-04</td>\n",
       "      <td>84</td>\n",
       "      <td>Auvergne-Rhône-Alpes</td>\n",
       "      <td>3606282</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-06-04T00:00:00+00:00</td>\n",
       "      <td>Auvergne-Rhône-Alpes</td>\n",
       "      <td>84</td>\n",
       "      <td>436083.0</td>\n",
       "      <td>P8: ]24-30] kVA</td>\n",
       "      <td>901</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES11 (+ RES11WE)</td>\n",
       "      <td>RES</td>\n",
       "      <td>2020-06-04</td>\n",
       "      <td>84</td>\n",
       "      <td>Auvergne-Rhône-Alpes</td>\n",
       "      <td>3606282</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-06-04T00:00:00+00:00</td>\n",
       "      <td>Auvergne-Rhône-Alpes</td>\n",
       "      <td>84</td>\n",
       "      <td>2133213.0</td>\n",
       "      <td>P9: ]30-36] kVA</td>\n",
       "      <td>3839</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES11 (+ RES11WE)</td>\n",
       "      <td>RES</td>\n",
       "      <td>2020-06-04</td>\n",
       "      <td>84</td>\n",
       "      <td>Auvergne-Rhône-Alpes</td>\n",
       "      <td>3606282</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-06-04T00:00:00+00:00</td>\n",
       "      <td>Auvergne-Rhône-Alpes</td>\n",
       "      <td>84</td>\n",
       "      <td>104448854.0</td>\n",
       "      <td>P4: ]9-12] kVA</td>\n",
       "      <td>269648</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES2 (+ RES5)</td>\n",
       "      <td>RES</td>\n",
       "      <td>2020-06-04</td>\n",
       "      <td>84</td>\n",
       "      <td>Auvergne-Rhône-Alpes</td>\n",
       "      <td>3606282</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-06-04T00:00:00+00:00</td>\n",
       "      <td>Auvergne-Rhône-Alpes</td>\n",
       "      <td>84</td>\n",
       "      <td>804838.0</td>\n",
       "      <td>P4: ]9-12] kVA</td>\n",
       "      <td>1830</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES2WE</td>\n",
       "      <td>RES</td>\n",
       "      <td>2020-06-04</td>\n",
       "      <td>84</td>\n",
       "      <td>Auvergne-Rhône-Alpes</td>\n",
       "      <td>3606282</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4876512</th>\n",
       "      <td>2021-08-15T00:00:00+00:00</td>\n",
       "      <td>Grand-Est</td>\n",
       "      <td>44</td>\n",
       "      <td>2278143.0</td>\n",
       "      <td>P0: Total &lt;= 36 kVA</td>\n",
       "      <td>13717</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES2WE</td>\n",
       "      <td>RES</td>\n",
       "      <td>2021-08-15</td>\n",
       "      <td>44</td>\n",
       "      <td>Grand Est</td>\n",
       "      <td>2498203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4876513</th>\n",
       "      <td>2021-08-15T00:00:00+00:00</td>\n",
       "      <td>Grand-Est</td>\n",
       "      <td>44</td>\n",
       "      <td>4639000.0</td>\n",
       "      <td>P0: Total &lt;= 36 kVA</td>\n",
       "      <td>14822</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES3</td>\n",
       "      <td>RES</td>\n",
       "      <td>2021-08-15</td>\n",
       "      <td>44</td>\n",
       "      <td>Grand Est</td>\n",
       "      <td>2498203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4876514</th>\n",
       "      <td>2021-08-15T00:00:00+00:00</td>\n",
       "      <td>Grand-Est</td>\n",
       "      <td>44</td>\n",
       "      <td>1200637.0</td>\n",
       "      <td>P6: ]15-18] kVA</td>\n",
       "      <td>3395</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES3</td>\n",
       "      <td>RES</td>\n",
       "      <td>2021-08-15</td>\n",
       "      <td>44</td>\n",
       "      <td>Grand Est</td>\n",
       "      <td>2498203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4876515</th>\n",
       "      <td>2021-08-15T00:00:00+00:00</td>\n",
       "      <td>Pays de la Loire</td>\n",
       "      <td>52</td>\n",
       "      <td>9344100.0</td>\n",
       "      <td>P6: ]15-18] kVA</td>\n",
       "      <td>20440</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES2 (+ RES5)</td>\n",
       "      <td>RES</td>\n",
       "      <td>2021-08-15</td>\n",
       "      <td>52</td>\n",
       "      <td>Pays de la Loire</td>\n",
       "      <td>1695032</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4876516</th>\n",
       "      <td>2021-08-15T00:00:00+00:00</td>\n",
       "      <td>Normandie</td>\n",
       "      <td>28</td>\n",
       "      <td>964757.0</td>\n",
       "      <td>P5: ]12-15] kVA</td>\n",
       "      <td>4717</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES11 (+ RES11WE)</td>\n",
       "      <td>RES</td>\n",
       "      <td>2021-08-15</td>\n",
       "      <td>28</td>\n",
       "      <td>Normandie</td>\n",
       "      <td>1500834</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4876517 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                          horodate                region  code_region  \\\n",
       "0        2020-06-04T00:00:00+00:00  Auvergne-Rhône-Alpes           84   \n",
       "1        2020-06-04T00:00:00+00:00  Auvergne-Rhône-Alpes           84   \n",
       "2        2020-06-04T00:00:00+00:00  Auvergne-Rhône-Alpes           84   \n",
       "3        2020-06-04T00:00:00+00:00  Auvergne-Rhône-Alpes           84   \n",
       "4        2020-06-04T00:00:00+00:00  Auvergne-Rhône-Alpes           84   \n",
       "...                            ...                   ...          ...   \n",
       "4876512  2021-08-15T00:00:00+00:00             Grand-Est           44   \n",
       "4876513  2021-08-15T00:00:00+00:00             Grand-Est           44   \n",
       "4876514  2021-08-15T00:00:00+00:00             Grand-Est           44   \n",
       "4876515  2021-08-15T00:00:00+00:00      Pays de la Loire           52   \n",
       "4876516  2021-08-15T00:00:00+00:00             Normandie           28   \n",
       "\n",
       "         total_energie_soutiree_wh plage_de_puissance_souscrite  \\\n",
       "0                      130666817.0                P2: ]3-6] kVA   \n",
       "1                         436083.0              P8: ]24-30] kVA   \n",
       "2                        2133213.0              P9: ]30-36] kVA   \n",
       "3                      104448854.0               P4: ]9-12] kVA   \n",
       "4                         804838.0               P4: ]9-12] kVA   \n",
       "...                            ...                          ...   \n",
       "4876512                  2278143.0          P0: Total <= 36 kVA   \n",
       "4876513                  4639000.0          P0: Total <= 36 kVA   \n",
       "4876514                  1200637.0              P6: ]15-18] kVA   \n",
       "4876515                  9344100.0              P6: ]15-18] kVA   \n",
       "4876516                   964757.0              P5: ]12-15] kVA   \n",
       "\n",
       "         nb_points_soutirage  jour_max_du_mois_0_1  semaine_max_du_mois_0_1  \\\n",
       "0                    1685439                     0                        0   \n",
       "1                        901                     0                        0   \n",
       "2                       3839                     0                        0   \n",
       "3                     269648                     0                        0   \n",
       "4                       1830                     0                        0   \n",
       "...                      ...                   ...                      ...   \n",
       "4876512                13717                     0                        0   \n",
       "4876513                14822                     0                        0   \n",
       "4876514                 3395                     0                        0   \n",
       "4876515                20440                     0                        0   \n",
       "4876516                 4717                     0                        0   \n",
       "\n",
       "                    profil profil_type        date  code_reg  \\\n",
       "0          RES1 (+ RES1WE)         RES  2020-06-04        84   \n",
       "1        RES11 (+ RES11WE)         RES  2020-06-04        84   \n",
       "2        RES11 (+ RES11WE)         RES  2020-06-04        84   \n",
       "3            RES2 (+ RES5)         RES  2020-06-04        84   \n",
       "4                   RES2WE         RES  2020-06-04        84   \n",
       "...                    ...         ...         ...       ...   \n",
       "4876512             RES2WE         RES  2021-08-15        44   \n",
       "4876513               RES3         RES  2021-08-15        44   \n",
       "4876514               RES3         RES  2021-08-15        44   \n",
       "4876515      RES2 (+ RES5)         RES  2021-08-15        52   \n",
       "4876516  RES11 (+ RES11WE)         RES  2021-08-15        28   \n",
       "\n",
       "                      nom_reg  Ensemble  \n",
       "0        Auvergne-Rhône-Alpes   3606282  \n",
       "1        Auvergne-Rhône-Alpes   3606282  \n",
       "2        Auvergne-Rhône-Alpes   3606282  \n",
       "3        Auvergne-Rhône-Alpes   3606282  \n",
       "4        Auvergne-Rhône-Alpes   3606282  \n",
       "...                       ...       ...  \n",
       "4876512             Grand Est   2498203  \n",
       "4876513             Grand Est   2498203  \n",
       "4876514             Grand Est   2498203  \n",
       "4876515      Pays de la Loire   1695032  \n",
       "4876516             Normandie   1500834  \n",
       "\n",
       "[4876517 rows x 14 columns]"
      ]
     },
     "execution_count": 72,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "enedis_menage"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Ajout de la conso moyenne (conso totale / nb de ménages ):"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 96,
   "metadata": {},
   "outputs": [],
   "source": [
    "enedis_menage[\"conso_moyenne\"]=enedis_menage[\"total_energie_soutiree_wh\"]/enedis_menage[\"Ensemble\"]"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Données méteo\n"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Données des températures régionales du 1er janvier 2018 au 31 octobre 2022 :**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>date</th>\n",
       "      <th>code_insee_region</th>\n",
       "      <th>region</th>\n",
       "      <th>tmin</th>\n",
       "      <th>tmax</th>\n",
       "      <th>tmoy</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2018-01-01T00:00:00-11</td>\n",
       "      <td>2018-01-01</td>\n",
       "      <td>11</td>\n",
       "      <td>Île-de-France</td>\n",
       "      <td>5.96</td>\n",
       "      <td>9.28</td>\n",
       "      <td>7.62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2018-01-01T00:00:00-28</td>\n",
       "      <td>2018-01-01</td>\n",
       "      <td>28</td>\n",
       "      <td>Normandie</td>\n",
       "      <td>5.00</td>\n",
       "      <td>8.98</td>\n",
       "      <td>6.99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2018-01-01T00:00:00-24</td>\n",
       "      <td>2018-01-01</td>\n",
       "      <td>24</td>\n",
       "      <td>Centre-Val de Loire</td>\n",
       "      <td>5.25</td>\n",
       "      <td>9.68</td>\n",
       "      <td>7.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2018-01-02T00:00:00-11</td>\n",
       "      <td>2018-01-02</td>\n",
       "      <td>11</td>\n",
       "      <td>Île-de-France</td>\n",
       "      <td>5.32</td>\n",
       "      <td>13.60</td>\n",
       "      <td>9.46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2018-01-02T00:00:00-84</td>\n",
       "      <td>2018-01-02</td>\n",
       "      <td>84</td>\n",
       "      <td>Auvergne-Rhône-Alpes</td>\n",
       "      <td>3.02</td>\n",
       "      <td>11.56</td>\n",
       "      <td>7.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32404</th>\n",
       "      <td>2022-10-30T00:00:00-93</td>\n",
       "      <td>2022-10-30</td>\n",
       "      <td>93</td>\n",
       "      <td>Provence-Alpes-Côte d'Azur</td>\n",
       "      <td>11.82</td>\n",
       "      <td>23.62</td>\n",
       "      <td>17.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32405</th>\n",
       "      <td>2022-10-30T00:00:00-32</td>\n",
       "      <td>2022-10-30</td>\n",
       "      <td>32</td>\n",
       "      <td>Hauts-de-France</td>\n",
       "      <td>11.66</td>\n",
       "      <td>16.96</td>\n",
       "      <td>14.31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32406</th>\n",
       "      <td>2022-10-30T00:00:00-76</td>\n",
       "      <td>2022-10-30</td>\n",
       "      <td>76</td>\n",
       "      <td>Occitanie</td>\n",
       "      <td>12.33</td>\n",
       "      <td>23.24</td>\n",
       "      <td>17.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32407</th>\n",
       "      <td>2022-10-31T00:00:00-24</td>\n",
       "      <td>2022-10-31</td>\n",
       "      <td>24</td>\n",
       "      <td>Centre-Val de Loire</td>\n",
       "      <td>11.05</td>\n",
       "      <td>21.63</td>\n",
       "      <td>16.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32408</th>\n",
       "      <td>2022-10-31T00:00:00-84</td>\n",
       "      <td>2022-10-31</td>\n",
       "      <td>84</td>\n",
       "      <td>Auvergne-Rhône-Alpes</td>\n",
       "      <td>11.73</td>\n",
       "      <td>22.35</td>\n",
       "      <td>17.04</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>32409 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                           id        date  code_insee_region  \\\n",
       "0      2018-01-01T00:00:00-11  2018-01-01                 11   \n",
       "1      2018-01-01T00:00:00-28  2018-01-01                 28   \n",
       "2      2018-01-01T00:00:00-24  2018-01-01                 24   \n",
       "3      2018-01-02T00:00:00-11  2018-01-02                 11   \n",
       "4      2018-01-02T00:00:00-84  2018-01-02                 84   \n",
       "...                       ...         ...                ...   \n",
       "32404  2022-10-30T00:00:00-93  2022-10-30                 93   \n",
       "32405  2022-10-30T00:00:00-32  2022-10-30                 32   \n",
       "32406  2022-10-30T00:00:00-76  2022-10-30                 76   \n",
       "32407  2022-10-31T00:00:00-24  2022-10-31                 24   \n",
       "32408  2022-10-31T00:00:00-84  2022-10-31                 84   \n",
       "\n",
       "                           region   tmin   tmax   tmoy  \n",
       "0                   Île-de-France   5.96   9.28   7.62  \n",
       "1                       Normandie   5.00   8.98   6.99  \n",
       "2             Centre-Val de Loire   5.25   9.68   7.47  \n",
       "3                   Île-de-France   5.32  13.60   9.46  \n",
       "4            Auvergne-Rhône-Alpes   3.02  11.56   7.29  \n",
       "...                           ...    ...    ...    ...  \n",
       "32404  Provence-Alpes-Côte d'Azur  11.82  23.62  17.72  \n",
       "32405             Hauts-de-France  11.66  16.96  14.31  \n",
       "32406                   Occitanie  12.33  23.24  17.78  \n",
       "32407         Centre-Val de Loire  11.05  21.63  16.34  \n",
       "32408        Auvergne-Rhône-Alpes  11.73  22.35  17.04  \n",
       "\n",
       "[32409 rows x 7 columns]"
      ]
     },
     "execution_count": 73,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "meteo_reg_df=pd.read_csv(\"Données/temperature-quotidienne-regionale.csv\",\";\")\n",
    "meteo_reg_df\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "metadata": {},
   "outputs": [],
   "source": [
    "meteo_3h=pd.read_csv(\"Données/donnees-temperatures-3h.csv\",sep=\";\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "<ipython-input-75-a7baeb0e4234>:2: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  meteo_3h_reduce.dropna(inplace=True)\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>Température (°C)</th>\n",
       "      <th>communes (name)</th>\n",
       "      <th>region (name)</th>\n",
       "      <th>region (code)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-11-22T19:00:00+01:00</td>\n",
       "      <td>23.5</td>\n",
       "      <td>Sainte-Marie</td>\n",
       "      <td>La Réunion</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-11-22T22:00:00+01:00</td>\n",
       "      <td>5.1</td>\n",
       "      <td>Prunay</td>\n",
       "      <td>Grand Est</td>\n",
       "      <td>44.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-11-23T01:00:00+01:00</td>\n",
       "      <td>2.4</td>\n",
       "      <td>Mérignac</td>\n",
       "      <td>Nouvelle-Aquitaine</td>\n",
       "      <td>75.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-11-23T01:00:00+01:00</td>\n",
       "      <td>6.4</td>\n",
       "      <td>Lucciana</td>\n",
       "      <td>Corse</td>\n",
       "      <td>94.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-11-23T04:00:00+01:00</td>\n",
       "      <td>7.5</td>\n",
       "      <td>Athis-Mons</td>\n",
       "      <td>Île-de-France</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216488</th>\n",
       "      <td>2021-05-25T14:00:00+02:00</td>\n",
       "      <td>27.6</td>\n",
       "      <td>les Éparses de l'océan Indien</td>\n",
       "      <td>Terres australes et antarctiques françaises</td>\n",
       "      <td>984.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216489</th>\n",
       "      <td>2021-05-25T23:00:00+02:00</td>\n",
       "      <td>14.7</td>\n",
       "      <td>Montélimar</td>\n",
       "      <td>Auvergne-Rhône-Alpes</td>\n",
       "      <td>84.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216490</th>\n",
       "      <td>2021-05-25T23:00:00+02:00</td>\n",
       "      <td>28.8</td>\n",
       "      <td>Saint-Georges</td>\n",
       "      <td>Guyane</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216491</th>\n",
       "      <td>2021-05-26T02:00:00+02:00</td>\n",
       "      <td>22.7</td>\n",
       "      <td>Sainte-Marie</td>\n",
       "      <td>La Réunion</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216492</th>\n",
       "      <td>2021-05-26T05:00:00+02:00</td>\n",
       "      <td>8.5</td>\n",
       "      <td>Fretin</td>\n",
       "      <td>Hauts-de-France</td>\n",
       "      <td>32.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>198815 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                             Date  Température (°C)  \\\n",
       "0       2020-11-22T19:00:00+01:00              23.5   \n",
       "1       2020-11-22T22:00:00+01:00               5.1   \n",
       "2       2020-11-23T01:00:00+01:00               2.4   \n",
       "3       2020-11-23T01:00:00+01:00               6.4   \n",
       "4       2020-11-23T04:00:00+01:00               7.5   \n",
       "...                           ...               ...   \n",
       "216488  2021-05-25T14:00:00+02:00              27.6   \n",
       "216489  2021-05-25T23:00:00+02:00              14.7   \n",
       "216490  2021-05-25T23:00:00+02:00              28.8   \n",
       "216491  2021-05-26T02:00:00+02:00              22.7   \n",
       "216492  2021-05-26T05:00:00+02:00               8.5   \n",
       "\n",
       "                      communes (name)  \\\n",
       "0                        Sainte-Marie   \n",
       "1                              Prunay   \n",
       "2                            Mérignac   \n",
       "3                            Lucciana   \n",
       "4                          Athis-Mons   \n",
       "...                               ...   \n",
       "216488  les Éparses de l'océan Indien   \n",
       "216489                     Montélimar   \n",
       "216490                  Saint-Georges   \n",
       "216491                   Sainte-Marie   \n",
       "216492                         Fretin   \n",
       "\n",
       "                                      region (name)  region (code)  \n",
       "0                                        La Réunion            4.0  \n",
       "1                                         Grand Est           44.0  \n",
       "2                                Nouvelle-Aquitaine           75.0  \n",
       "3                                             Corse           94.0  \n",
       "4                                     Île-de-France           11.0  \n",
       "...                                             ...            ...  \n",
       "216488  Terres australes et antarctiques françaises          984.0  \n",
       "216489                         Auvergne-Rhône-Alpes           84.0  \n",
       "216490                                       Guyane            3.0  \n",
       "216491                                   La Réunion            4.0  \n",
       "216492                              Hauts-de-France           32.0  \n",
       "\n",
       "[198815 rows x 5 columns]"
      ]
     },
     "execution_count": 75,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "meteo_3h_reduce=meteo_3h[['Date',\"Température (°C)\",'communes (name)','region (name)','region (code)']]\n",
    "meteo_3h_reduce.dropna(inplace=True)\n",
    "meteo_3h_reduce"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "On calcule la température moyenne par région pour toutes les trois heures :"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "<ipython-input-76-9d7da9c6c86d>:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  meteo_3h_reduce[\"region (code)\"]=meteo_3h_reduce[\"region (code)\"].astype(\"int\")\n",
      "<ipython-input-76-9d7da9c6c86d>:2: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  meteo_3h_reduce[\"region (code)\"]=meteo_3h_reduce[\"region (code)\"].astype(\"str\")\n"
     ]
    }
   ],
   "source": [
    "meteo_3h_reduce[\"region (code)\"]=meteo_3h_reduce[\"region (code)\"].astype(\"int\")\n",
    "meteo_3h_reduce[\"region (code)\"]=meteo_3h_reduce[\"region (code)\"].astype(\"str\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "metadata": {},
   "outputs": [],
   "source": [
    "meteo_3h_mean=meteo_3h_reduce.groupby([\"Date\",\"region (code)\"])[\"Température (°C)\"].mean().reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>region (code)</th>\n",
       "      <th>Température (°C)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-06-01T02:00:00+02:00</td>\n",
       "      <td>1</td>\n",
       "      <td>27.350000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-06-01T02:00:00+02:00</td>\n",
       "      <td>11</td>\n",
       "      <td>16.100000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-06-01T02:00:00+02:00</td>\n",
       "      <td>2</td>\n",
       "      <td>27.550000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-06-01T02:00:00+02:00</td>\n",
       "      <td>24</td>\n",
       "      <td>15.650000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-06-01T02:00:00+02:00</td>\n",
       "      <td>27</td>\n",
       "      <td>12.800000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74362</th>\n",
       "      <td>2021-08-31T23:00:00+02:00</td>\n",
       "      <td>93</td>\n",
       "      <td>19.633333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74363</th>\n",
       "      <td>2021-08-31T23:00:00+02:00</td>\n",
       "      <td>94</td>\n",
       "      <td>19.650000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74364</th>\n",
       "      <td>2021-08-31T23:00:00+02:00</td>\n",
       "      <td>975</td>\n",
       "      <td>17.300000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74365</th>\n",
       "      <td>2021-08-31T23:00:00+02:00</td>\n",
       "      <td>977</td>\n",
       "      <td>31.600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74366</th>\n",
       "      <td>2021-08-31T23:00:00+02:00</td>\n",
       "      <td>984</td>\n",
       "      <td>15.400000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>74367 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                            Date region (code)  Température (°C)\n",
       "0      2020-06-01T02:00:00+02:00             1         27.350000\n",
       "1      2020-06-01T02:00:00+02:00            11         16.100000\n",
       "2      2020-06-01T02:00:00+02:00             2         27.550000\n",
       "3      2020-06-01T02:00:00+02:00            24         15.650000\n",
       "4      2020-06-01T02:00:00+02:00            27         12.800000\n",
       "...                          ...           ...               ...\n",
       "74362  2021-08-31T23:00:00+02:00            93         19.633333\n",
       "74363  2021-08-31T23:00:00+02:00            94         19.650000\n",
       "74364  2021-08-31T23:00:00+02:00           975         17.300000\n",
       "74365  2021-08-31T23:00:00+02:00           977         31.600000\n",
       "74366  2021-08-31T23:00:00+02:00           984         15.400000\n",
       "\n",
       "[74367 rows x 3 columns]"
      ]
     },
     "execution_count": 78,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "meteo_3h_mean"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Données socio économique"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Code</th>\n",
       "      <th>Libellé</th>\n",
       "      <th>Part des \"artisans, commerçants, chefs d'entreprise\" dans la population 2018</th>\n",
       "      <th>Part des \"employés\" dans la population 2018</th>\n",
       "      <th>Part des \"ouvriers\" dans la population 2018</th>\n",
       "      <th>Part des \"retraités\" dans la population 2018</th>\n",
       "      <th>Part des \"agriculteurs exploitants\" dans la population 2018</th>\n",
       "      <th>Part des \"professions intermédiaires\" dans la population 2018</th>\n",
       "      <th>Part des \"autres sans activité professionnelle\" dans la population 2018</th>\n",
       "      <th>Part des \"autres sans activité professionnelle\" dans la population 2018.1</th>\n",
       "      <th>Part des \"cadres et professions intellectuelles supérieures\" dans la population 2018</th>\n",
       "      <th>Médiane du revenu disponible par UC 2018</th>\n",
       "      <th>Population au dernier recensement 2018</th>\n",
       "      <th>Part des 15-29 ans 2018</th>\n",
       "      <th>Part des 30-44 ans 2018</th>\n",
       "      <th>Part des 45-59 ans 2018</th>\n",
       "      <th>Part des 60-74 ans 2018</th>\n",
       "      <th>Part des 75 ans et plus 2018</th>\n",
       "      <th>Taux de chômage des 15 ans et plus (RP) 2018</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Guadeloupe</td>\n",
       "      <td>4.9</td>\n",
       "      <td>18.7</td>\n",
       "      <td>10.4</td>\n",
       "      <td>23.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>12.0</td>\n",
       "      <td>25.3</td>\n",
       "      <td>26.5</td>\n",
       "      <td>4.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>387629.0</td>\n",
       "      <td>16.4</td>\n",
       "      <td>16.3</td>\n",
       "      <td>23.3</td>\n",
       "      <td>17.3</td>\n",
       "      <td>8.3</td>\n",
       "      <td>28.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Martinique</td>\n",
       "      <td>3.9</td>\n",
       "      <td>19.0</td>\n",
       "      <td>11.1</td>\n",
       "      <td>25.2</td>\n",
       "      <td>0.7</td>\n",
       "      <td>12.4</td>\n",
       "      <td>22.4</td>\n",
       "      <td>22.8</td>\n",
       "      <td>5.2</td>\n",
       "      <td>17880.0</td>\n",
       "      <td>368783.0</td>\n",
       "      <td>15.7</td>\n",
       "      <td>15.5</td>\n",
       "      <td>24.6</td>\n",
       "      <td>18.2</td>\n",
       "      <td>9.6</td>\n",
       "      <td>23.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Guyane</td>\n",
       "      <td>3.3</td>\n",
       "      <td>15.2</td>\n",
       "      <td>10.7</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>10.9</td>\n",
       "      <td>46.8</td>\n",
       "      <td>51.1</td>\n",
       "      <td>5.2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>276128.0</td>\n",
       "      <td>23.4</td>\n",
       "      <td>20.5</td>\n",
       "      <td>14.5</td>\n",
       "      <td>6.8</td>\n",
       "      <td>1.9</td>\n",
       "      <td>34.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>La Réunion</td>\n",
       "      <td>3.5</td>\n",
       "      <td>20.3</td>\n",
       "      <td>13.1</td>\n",
       "      <td>14.9</td>\n",
       "      <td>0.9</td>\n",
       "      <td>12.2</td>\n",
       "      <td>30.1</td>\n",
       "      <td>35.2</td>\n",
       "      <td>4.9</td>\n",
       "      <td>15440.0</td>\n",
       "      <td>855961.0</td>\n",
       "      <td>19.7</td>\n",
       "      <td>19.2</td>\n",
       "      <td>21.2</td>\n",
       "      <td>12.3</td>\n",
       "      <td>4.7</td>\n",
       "      <td>32.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>6</td>\n",
       "      <td>Mayotte</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>11</td>\n",
       "      <td>Île-de-France</td>\n",
       "      <td>3.2</td>\n",
       "      <td>16.4</td>\n",
       "      <td>8.5</td>\n",
       "      <td>19.4</td>\n",
       "      <td>0.1</td>\n",
       "      <td>15.9</td>\n",
       "      <td>18.3</td>\n",
       "      <td>20.7</td>\n",
       "      <td>18.2</td>\n",
       "      <td>23860.0</td>\n",
       "      <td>12213447.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>21.2</td>\n",
       "      <td>19.4</td>\n",
       "      <td>13.2</td>\n",
       "      <td>6.8</td>\n",
       "      <td>12.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>24</td>\n",
       "      <td>Centre-Val de Loire</td>\n",
       "      <td>3.2</td>\n",
       "      <td>16.0</td>\n",
       "      <td>13.9</td>\n",
       "      <td>31.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>13.8</td>\n",
       "      <td>14.1</td>\n",
       "      <td>16.2</td>\n",
       "      <td>7.1</td>\n",
       "      <td>21560.0</td>\n",
       "      <td>2572853.0</td>\n",
       "      <td>15.9</td>\n",
       "      <td>17.5</td>\n",
       "      <td>20.1</td>\n",
       "      <td>18.1</td>\n",
       "      <td>10.7</td>\n",
       "      <td>12.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>27</td>\n",
       "      <td>Bourgogne-Franche-Comté</td>\n",
       "      <td>3.3</td>\n",
       "      <td>15.2</td>\n",
       "      <td>14.8</td>\n",
       "      <td>31.4</td>\n",
       "      <td>1.2</td>\n",
       "      <td>13.1</td>\n",
       "      <td>14.6</td>\n",
       "      <td>17.1</td>\n",
       "      <td>6.3</td>\n",
       "      <td>21480.0</td>\n",
       "      <td>2807807.0</td>\n",
       "      <td>16.2</td>\n",
       "      <td>17.3</td>\n",
       "      <td>20.1</td>\n",
       "      <td>18.6</td>\n",
       "      <td>10.9</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>28</td>\n",
       "      <td>Normandie</td>\n",
       "      <td>3.2</td>\n",
       "      <td>16.0</td>\n",
       "      <td>14.4</td>\n",
       "      <td>30.1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>13.4</td>\n",
       "      <td>15.5</td>\n",
       "      <td>17.6</td>\n",
       "      <td>6.4</td>\n",
       "      <td>21200.0</td>\n",
       "      <td>3327477.0</td>\n",
       "      <td>16.9</td>\n",
       "      <td>17.7</td>\n",
       "      <td>19.9</td>\n",
       "      <td>17.8</td>\n",
       "      <td>9.9</td>\n",
       "      <td>13.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>32</td>\n",
       "      <td>Hauts-de-France</td>\n",
       "      <td>2.6</td>\n",
       "      <td>16.4</td>\n",
       "      <td>14.7</td>\n",
       "      <td>25.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>13.5</td>\n",
       "      <td>19.8</td>\n",
       "      <td>23.4</td>\n",
       "      <td>7.0</td>\n",
       "      <td>20110.0</td>\n",
       "      <td>6004108.0</td>\n",
       "      <td>18.5</td>\n",
       "      <td>18.8</td>\n",
       "      <td>19.5</td>\n",
       "      <td>15.9</td>\n",
       "      <td>7.9</td>\n",
       "      <td>16.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>44</td>\n",
       "      <td>Grand Est</td>\n",
       "      <td>2.9</td>\n",
       "      <td>16.4</td>\n",
       "      <td>14.7</td>\n",
       "      <td>27.3</td>\n",
       "      <td>0.8</td>\n",
       "      <td>13.8</td>\n",
       "      <td>17.0</td>\n",
       "      <td>20.4</td>\n",
       "      <td>7.2</td>\n",
       "      <td>21610.0</td>\n",
       "      <td>5550389.0</td>\n",
       "      <td>17.5</td>\n",
       "      <td>18.3</td>\n",
       "      <td>20.6</td>\n",
       "      <td>17.1</td>\n",
       "      <td>9.3</td>\n",
       "      <td>13.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>52</td>\n",
       "      <td>Pays de la Loire</td>\n",
       "      <td>3.3</td>\n",
       "      <td>15.3</td>\n",
       "      <td>14.8</td>\n",
       "      <td>29.4</td>\n",
       "      <td>1.2</td>\n",
       "      <td>14.2</td>\n",
       "      <td>13.9</td>\n",
       "      <td>15.6</td>\n",
       "      <td>7.8</td>\n",
       "      <td>21620.0</td>\n",
       "      <td>3781423.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>18.4</td>\n",
       "      <td>19.5</td>\n",
       "      <td>16.8</td>\n",
       "      <td>9.7</td>\n",
       "      <td>11.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>53</td>\n",
       "      <td>Bretagne</td>\n",
       "      <td>3.5</td>\n",
       "      <td>15.1</td>\n",
       "      <td>13.0</td>\n",
       "      <td>31.2</td>\n",
       "      <td>1.3</td>\n",
       "      <td>13.7</td>\n",
       "      <td>14.7</td>\n",
       "      <td>16.2</td>\n",
       "      <td>7.6</td>\n",
       "      <td>21750.0</td>\n",
       "      <td>3335414.0</td>\n",
       "      <td>16.4</td>\n",
       "      <td>17.6</td>\n",
       "      <td>20.1</td>\n",
       "      <td>18.1</td>\n",
       "      <td>10.5</td>\n",
       "      <td>11.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>75</td>\n",
       "      <td>Nouvelle-Aquitaine</td>\n",
       "      <td>4.0</td>\n",
       "      <td>15.9</td>\n",
       "      <td>12.1</td>\n",
       "      <td>31.9</td>\n",
       "      <td>1.3</td>\n",
       "      <td>13.1</td>\n",
       "      <td>14.7</td>\n",
       "      <td>16.7</td>\n",
       "      <td>7.1</td>\n",
       "      <td>21290.0</td>\n",
       "      <td>5979778.0</td>\n",
       "      <td>15.9</td>\n",
       "      <td>17.4</td>\n",
       "      <td>20.3</td>\n",
       "      <td>19.0</td>\n",
       "      <td>11.4</td>\n",
       "      <td>12.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>76</td>\n",
       "      <td>Occitanie</td>\n",
       "      <td>4.3</td>\n",
       "      <td>15.7</td>\n",
       "      <td>10.2</td>\n",
       "      <td>29.3</td>\n",
       "      <td>1.2</td>\n",
       "      <td>13.6</td>\n",
       "      <td>17.3</td>\n",
       "      <td>20.1</td>\n",
       "      <td>8.4</td>\n",
       "      <td>20740.0</td>\n",
       "      <td>5885496.0</td>\n",
       "      <td>16.8</td>\n",
       "      <td>17.7</td>\n",
       "      <td>20.0</td>\n",
       "      <td>18.1</td>\n",
       "      <td>10.7</td>\n",
       "      <td>14.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>84</td>\n",
       "      <td>Auvergne-Rhône-Alpes</td>\n",
       "      <td>3.9</td>\n",
       "      <td>15.6</td>\n",
       "      <td>12.4</td>\n",
       "      <td>27.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>15.2</td>\n",
       "      <td>15.7</td>\n",
       "      <td>18.3</td>\n",
       "      <td>9.4</td>\n",
       "      <td>22480.0</td>\n",
       "      <td>7994459.0</td>\n",
       "      <td>17.6</td>\n",
       "      <td>18.8</td>\n",
       "      <td>19.8</td>\n",
       "      <td>16.2</td>\n",
       "      <td>9.4</td>\n",
       "      <td>11.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>93</td>\n",
       "      <td>Provence-Alpes-Côte d'Azur</td>\n",
       "      <td>4.4</td>\n",
       "      <td>16.4</td>\n",
       "      <td>9.7</td>\n",
       "      <td>28.9</td>\n",
       "      <td>0.4</td>\n",
       "      <td>13.6</td>\n",
       "      <td>18.3</td>\n",
       "      <td>21.5</td>\n",
       "      <td>8.3</td>\n",
       "      <td>21350.0</td>\n",
       "      <td>5052832.0</td>\n",
       "      <td>16.1</td>\n",
       "      <td>17.9</td>\n",
       "      <td>20.1</td>\n",
       "      <td>18.0</td>\n",
       "      <td>11.1</td>\n",
       "      <td>14.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>94</td>\n",
       "      <td>Corse</td>\n",
       "      <td>5.7</td>\n",
       "      <td>18.6</td>\n",
       "      <td>10.4</td>\n",
       "      <td>27.0</td>\n",
       "      <td>0.9</td>\n",
       "      <td>11.8</td>\n",
       "      <td>20.3</td>\n",
       "      <td>26.3</td>\n",
       "      <td>5.3</td>\n",
       "      <td>20670.0</td>\n",
       "      <td>338554.0</td>\n",
       "      <td>14.9</td>\n",
       "      <td>19.1</td>\n",
       "      <td>20.7</td>\n",
       "      <td>18.5</td>\n",
       "      <td>11.2</td>\n",
       "      <td>11.7</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Code                     Libellé  \\\n",
       "0      1                  Guadeloupe   \n",
       "1      2                  Martinique   \n",
       "2      3                      Guyane   \n",
       "3      4                  La Réunion   \n",
       "4      6                     Mayotte   \n",
       "5     11               Île-de-France   \n",
       "6     24         Centre-Val de Loire   \n",
       "7     27     Bourgogne-Franche-Comté   \n",
       "8     28                   Normandie   \n",
       "9     32             Hauts-de-France   \n",
       "10    44                   Grand Est   \n",
       "11    52            Pays de la Loire   \n",
       "12    53                    Bretagne   \n",
       "13    75          Nouvelle-Aquitaine   \n",
       "14    76                   Occitanie   \n",
       "15    84        Auvergne-Rhône-Alpes   \n",
       "16    93  Provence-Alpes-Côte d'Azur   \n",
       "17    94                       Corse   \n",
       "\n",
       "    Part des \"artisans, commerçants, chefs d'entreprise\" dans la population 2018  \\\n",
       "0                                                 4.9                              \n",
       "1                                                 3.9                              \n",
       "2                                                 3.3                              \n",
       "3                                                 3.5                              \n",
       "4                                                 NaN                              \n",
       "5                                                 3.2                              \n",
       "6                                                 3.2                              \n",
       "7                                                 3.3                              \n",
       "8                                                 3.2                              \n",
       "9                                                 2.6                              \n",
       "10                                                2.9                              \n",
       "11                                                3.3                              \n",
       "12                                                3.5                              \n",
       "13                                                4.0                              \n",
       "14                                                4.3                              \n",
       "15                                                3.9                              \n",
       "16                                                4.4                              \n",
       "17                                                5.7                              \n",
       "\n",
       "    Part des \"employés\" dans la population 2018  \\\n",
       "0                                          18.7   \n",
       "1                                          19.0   \n",
       "2                                          15.2   \n",
       "3                                          20.3   \n",
       "4                                           NaN   \n",
       "5                                          16.4   \n",
       "6                                          16.0   \n",
       "7                                          15.2   \n",
       "8                                          16.0   \n",
       "9                                          16.4   \n",
       "10                                         16.4   \n",
       "11                                         15.3   \n",
       "12                                         15.1   \n",
       "13                                         15.9   \n",
       "14                                         15.7   \n",
       "15                                         15.6   \n",
       "16                                         16.4   \n",
       "17                                         18.6   \n",
       "\n",
       "    Part des \"ouvriers\" dans la population 2018  \\\n",
       "0                                          10.4   \n",
       "1                                          11.1   \n",
       "2                                          10.7   \n",
       "3                                          13.1   \n",
       "4                                           NaN   \n",
       "5                                           8.5   \n",
       "6                                          13.9   \n",
       "7                                          14.8   \n",
       "8                                          14.4   \n",
       "9                                          14.7   \n",
       "10                                         14.7   \n",
       "11                                         14.8   \n",
       "12                                         13.0   \n",
       "13                                         12.1   \n",
       "14                                         10.2   \n",
       "15                                         12.4   \n",
       "16                                          9.7   \n",
       "17                                         10.4   \n",
       "\n",
       "    Part des \"retraités\" dans la population 2018  \\\n",
       "0                                           23.0   \n",
       "1                                           25.2   \n",
       "2                                            7.0   \n",
       "3                                           14.9   \n",
       "4                                            NaN   \n",
       "5                                           19.4   \n",
       "6                                           31.0   \n",
       "7                                           31.4   \n",
       "8                                           30.1   \n",
       "9                                           25.5   \n",
       "10                                          27.3   \n",
       "11                                          29.4   \n",
       "12                                          31.2   \n",
       "13                                          31.9   \n",
       "14                                          29.3   \n",
       "15                                          27.0   \n",
       "16                                          28.9   \n",
       "17                                          27.0   \n",
       "\n",
       "    Part des \"agriculteurs exploitants\" dans la population 2018  \\\n",
       "0                                                 0.8             \n",
       "1                                                 0.7             \n",
       "2                                                 0.8             \n",
       "3                                                 0.9             \n",
       "4                                                 NaN             \n",
       "5                                                 0.1             \n",
       "6                                                 1.0             \n",
       "7                                                 1.2             \n",
       "8                                                 1.0             \n",
       "9                                                 0.5             \n",
       "10                                                0.8             \n",
       "11                                                1.2             \n",
       "12                                                1.3             \n",
       "13                                                1.3             \n",
       "14                                                1.2             \n",
       "15                                                0.8             \n",
       "16                                                0.4             \n",
       "17                                                0.9             \n",
       "\n",
       "    Part des \"professions intermédiaires\" dans la population 2018  \\\n",
       "0                                                12.0               \n",
       "1                                                12.4               \n",
       "2                                                10.9               \n",
       "3                                                12.2               \n",
       "4                                                 NaN               \n",
       "5                                                15.9               \n",
       "6                                                13.8               \n",
       "7                                                13.1               \n",
       "8                                                13.4               \n",
       "9                                                13.5               \n",
       "10                                               13.8               \n",
       "11                                               14.2               \n",
       "12                                               13.7               \n",
       "13                                               13.1               \n",
       "14                                               13.6               \n",
       "15                                               15.2               \n",
       "16                                               13.6               \n",
       "17                                               11.8               \n",
       "\n",
       "    Part des \"autres sans activité professionnelle\" dans la population 2018  \\\n",
       "0                                                25.3                         \n",
       "1                                                22.4                         \n",
       "2                                                46.8                         \n",
       "3                                                30.1                         \n",
       "4                                                 NaN                         \n",
       "5                                                18.3                         \n",
       "6                                                14.1                         \n",
       "7                                                14.6                         \n",
       "8                                                15.5                         \n",
       "9                                                19.8                         \n",
       "10                                               17.0                         \n",
       "11                                               13.9                         \n",
       "12                                               14.7                         \n",
       "13                                               14.7                         \n",
       "14                                               17.3                         \n",
       "15                                               15.7                         \n",
       "16                                               18.3                         \n",
       "17                                               20.3                         \n",
       "\n",
       "    Part des \"autres sans activité professionnelle\" dans la population 2018.1  \\\n",
       "0                                                26.5                           \n",
       "1                                                22.8                           \n",
       "2                                                51.1                           \n",
       "3                                                35.2                           \n",
       "4                                                 NaN                           \n",
       "5                                                20.7                           \n",
       "6                                                16.2                           \n",
       "7                                                17.1                           \n",
       "8                                                17.6                           \n",
       "9                                                23.4                           \n",
       "10                                               20.4                           \n",
       "11                                               15.6                           \n",
       "12                                               16.2                           \n",
       "13                                               16.7                           \n",
       "14                                               20.1                           \n",
       "15                                               18.3                           \n",
       "16                                               21.5                           \n",
       "17                                               26.3                           \n",
       "\n",
       "    Part des \"cadres et professions intellectuelles supérieures\" dans la population 2018  \\\n",
       "0                                                 4.8                                      \n",
       "1                                                 5.2                                      \n",
       "2                                                 5.2                                      \n",
       "3                                                 4.9                                      \n",
       "4                                                 NaN                                      \n",
       "5                                                18.2                                      \n",
       "6                                                 7.1                                      \n",
       "7                                                 6.3                                      \n",
       "8                                                 6.4                                      \n",
       "9                                                 7.0                                      \n",
       "10                                                7.2                                      \n",
       "11                                                7.8                                      \n",
       "12                                                7.6                                      \n",
       "13                                                7.1                                      \n",
       "14                                                8.4                                      \n",
       "15                                                9.4                                      \n",
       "16                                                8.3                                      \n",
       "17                                                5.3                                      \n",
       "\n",
       "    Médiane du revenu disponible par UC 2018  \\\n",
       "0                                        NaN   \n",
       "1                                    17880.0   \n",
       "2                                        NaN   \n",
       "3                                    15440.0   \n",
       "4                                        NaN   \n",
       "5                                    23860.0   \n",
       "6                                    21560.0   \n",
       "7                                    21480.0   \n",
       "8                                    21200.0   \n",
       "9                                    20110.0   \n",
       "10                                   21610.0   \n",
       "11                                   21620.0   \n",
       "12                                   21750.0   \n",
       "13                                   21290.0   \n",
       "14                                   20740.0   \n",
       "15                                   22480.0   \n",
       "16                                   21350.0   \n",
       "17                                   20670.0   \n",
       "\n",
       "    Population au dernier recensement 2018  Part des 15-29 ans 2018  \\\n",
       "0                                 387629.0                     16.4   \n",
       "1                                 368783.0                     15.7   \n",
       "2                                 276128.0                     23.4   \n",
       "3                                 855961.0                     19.7   \n",
       "4                                      NaN                      NaN   \n",
       "5                               12213447.0                     20.0   \n",
       "6                                2572853.0                     15.9   \n",
       "7                                2807807.0                     16.2   \n",
       "8                                3327477.0                     16.9   \n",
       "9                                6004108.0                     18.5   \n",
       "10                               5550389.0                     17.5   \n",
       "11                               3781423.0                     17.0   \n",
       "12                               3335414.0                     16.4   \n",
       "13                               5979778.0                     15.9   \n",
       "14                               5885496.0                     16.8   \n",
       "15                               7994459.0                     17.6   \n",
       "16                               5052832.0                     16.1   \n",
       "17                                338554.0                     14.9   \n",
       "\n",
       "    Part des 30-44 ans 2018  Part des 45-59 ans 2018  Part des 60-74 ans 2018  \\\n",
       "0                      16.3                     23.3                     17.3   \n",
       "1                      15.5                     24.6                     18.2   \n",
       "2                      20.5                     14.5                      6.8   \n",
       "3                      19.2                     21.2                     12.3   \n",
       "4                       NaN                      NaN                      NaN   \n",
       "5                      21.2                     19.4                     13.2   \n",
       "6                      17.5                     20.1                     18.1   \n",
       "7                      17.3                     20.1                     18.6   \n",
       "8                      17.7                     19.9                     17.8   \n",
       "9                      18.8                     19.5                     15.9   \n",
       "10                     18.3                     20.6                     17.1   \n",
       "11                     18.4                     19.5                     16.8   \n",
       "12                     17.6                     20.1                     18.1   \n",
       "13                     17.4                     20.3                     19.0   \n",
       "14                     17.7                     20.0                     18.1   \n",
       "15                     18.8                     19.8                     16.2   \n",
       "16                     17.9                     20.1                     18.0   \n",
       "17                     19.1                     20.7                     18.5   \n",
       "\n",
       "    Part des 75 ans et plus 2018  Taux de chômage des 15 ans et plus (RP) 2018  \n",
       "0                            8.3                                          28.3  \n",
       "1                            9.6                                          23.0  \n",
       "2                            1.9                                          34.2  \n",
       "3                            4.7                                          32.8  \n",
       "4                            NaN                                           NaN  \n",
       "5                            6.8                                          12.1  \n",
       "6                           10.7                                          12.5  \n",
       "7                           10.9                                          12.0  \n",
       "8                            9.9                                          13.2  \n",
       "9                            7.9                                          16.3  \n",
       "10                           9.3                                          13.3  \n",
       "11                           9.7                                          11.2  \n",
       "12                          10.5                                          11.4  \n",
       "13                          11.4                                          12.6  \n",
       "14                          10.7                                          14.5  \n",
       "15                           9.4                                          11.4  \n",
       "16                          11.1                                          14.0  \n",
       "17                          11.2                                          11.7  "
      ]
     },
     "execution_count": 79,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "socio=pd.read_csv(\"Données/data_socio.csv\",sep=\";\",header=2)\n",
    "socio"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Code</th>\n",
       "      <th>Libellé</th>\n",
       "      <th>Part des \"artisans, commerçants, chefs d'entreprise\" dans la population 2018</th>\n",
       "      <th>Part des \"employés\" dans la population 2018</th>\n",
       "      <th>Part des \"ouvriers\" dans la population 2018</th>\n",
       "      <th>Part des \"retraités\" dans la population 2018</th>\n",
       "      <th>Part des \"agriculteurs exploitants\" dans la population 2018</th>\n",
       "      <th>Part des \"professions intermédiaires\" dans la population 2018</th>\n",
       "      <th>Part des \"autres sans activité professionnelle\" dans la population 2018</th>\n",
       "      <th>Part des \"autres sans activité professionnelle\" dans la population 2018.1</th>\n",
       "      <th>Part des \"cadres et professions intellectuelles supérieures\" dans la population 2018</th>\n",
       "      <th>Médiane du revenu disponible par UC 2018</th>\n",
       "      <th>Population au dernier recensement 2018</th>\n",
       "      <th>Part des 15-29 ans 2018</th>\n",
       "      <th>Part des 30-44 ans 2018</th>\n",
       "      <th>Part des 45-59 ans 2018</th>\n",
       "      <th>Part des 60-74 ans 2018</th>\n",
       "      <th>Part des 75 ans et plus 2018</th>\n",
       "      <th>Taux de chômage des 15 ans et plus (RP) 2018</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>11</td>\n",
       "      <td>Île-de-France</td>\n",
       "      <td>3.2</td>\n",
       "      <td>16.4</td>\n",
       "      <td>8.5</td>\n",
       "      <td>19.4</td>\n",
       "      <td>0.1</td>\n",
       "      <td>15.9</td>\n",
       "      <td>18.3</td>\n",
       "      <td>20.7</td>\n",
       "      <td>18.2</td>\n",
       "      <td>23860.0</td>\n",
       "      <td>12213447.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>21.2</td>\n",
       "      <td>19.4</td>\n",
       "      <td>13.2</td>\n",
       "      <td>6.8</td>\n",
       "      <td>12.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>24</td>\n",
       "      <td>Centre-Val de Loire</td>\n",
       "      <td>3.2</td>\n",
       "      <td>16.0</td>\n",
       "      <td>13.9</td>\n",
       "      <td>31.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>13.8</td>\n",
       "      <td>14.1</td>\n",
       "      <td>16.2</td>\n",
       "      <td>7.1</td>\n",
       "      <td>21560.0</td>\n",
       "      <td>2572853.0</td>\n",
       "      <td>15.9</td>\n",
       "      <td>17.5</td>\n",
       "      <td>20.1</td>\n",
       "      <td>18.1</td>\n",
       "      <td>10.7</td>\n",
       "      <td>12.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>27</td>\n",
       "      <td>Bourgogne-Franche-Comté</td>\n",
       "      <td>3.3</td>\n",
       "      <td>15.2</td>\n",
       "      <td>14.8</td>\n",
       "      <td>31.4</td>\n",
       "      <td>1.2</td>\n",
       "      <td>13.1</td>\n",
       "      <td>14.6</td>\n",
       "      <td>17.1</td>\n",
       "      <td>6.3</td>\n",
       "      <td>21480.0</td>\n",
       "      <td>2807807.0</td>\n",
       "      <td>16.2</td>\n",
       "      <td>17.3</td>\n",
       "      <td>20.1</td>\n",
       "      <td>18.6</td>\n",
       "      <td>10.9</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>28</td>\n",
       "      <td>Normandie</td>\n",
       "      <td>3.2</td>\n",
       "      <td>16.0</td>\n",
       "      <td>14.4</td>\n",
       "      <td>30.1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>13.4</td>\n",
       "      <td>15.5</td>\n",
       "      <td>17.6</td>\n",
       "      <td>6.4</td>\n",
       "      <td>21200.0</td>\n",
       "      <td>3327477.0</td>\n",
       "      <td>16.9</td>\n",
       "      <td>17.7</td>\n",
       "      <td>19.9</td>\n",
       "      <td>17.8</td>\n",
       "      <td>9.9</td>\n",
       "      <td>13.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>32</td>\n",
       "      <td>Hauts-de-France</td>\n",
       "      <td>2.6</td>\n",
       "      <td>16.4</td>\n",
       "      <td>14.7</td>\n",
       "      <td>25.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>13.5</td>\n",
       "      <td>19.8</td>\n",
       "      <td>23.4</td>\n",
       "      <td>7.0</td>\n",
       "      <td>20110.0</td>\n",
       "      <td>6004108.0</td>\n",
       "      <td>18.5</td>\n",
       "      <td>18.8</td>\n",
       "      <td>19.5</td>\n",
       "      <td>15.9</td>\n",
       "      <td>7.9</td>\n",
       "      <td>16.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>44</td>\n",
       "      <td>Grand Est</td>\n",
       "      <td>2.9</td>\n",
       "      <td>16.4</td>\n",
       "      <td>14.7</td>\n",
       "      <td>27.3</td>\n",
       "      <td>0.8</td>\n",
       "      <td>13.8</td>\n",
       "      <td>17.0</td>\n",
       "      <td>20.4</td>\n",
       "      <td>7.2</td>\n",
       "      <td>21610.0</td>\n",
       "      <td>5550389.0</td>\n",
       "      <td>17.5</td>\n",
       "      <td>18.3</td>\n",
       "      <td>20.6</td>\n",
       "      <td>17.1</td>\n",
       "      <td>9.3</td>\n",
       "      <td>13.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>52</td>\n",
       "      <td>Pays de la Loire</td>\n",
       "      <td>3.3</td>\n",
       "      <td>15.3</td>\n",
       "      <td>14.8</td>\n",
       "      <td>29.4</td>\n",
       "      <td>1.2</td>\n",
       "      <td>14.2</td>\n",
       "      <td>13.9</td>\n",
       "      <td>15.6</td>\n",
       "      <td>7.8</td>\n",
       "      <td>21620.0</td>\n",
       "      <td>3781423.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>18.4</td>\n",
       "      <td>19.5</td>\n",
       "      <td>16.8</td>\n",
       "      <td>9.7</td>\n",
       "      <td>11.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>53</td>\n",
       "      <td>Bretagne</td>\n",
       "      <td>3.5</td>\n",
       "      <td>15.1</td>\n",
       "      <td>13.0</td>\n",
       "      <td>31.2</td>\n",
       "      <td>1.3</td>\n",
       "      <td>13.7</td>\n",
       "      <td>14.7</td>\n",
       "      <td>16.2</td>\n",
       "      <td>7.6</td>\n",
       "      <td>21750.0</td>\n",
       "      <td>3335414.0</td>\n",
       "      <td>16.4</td>\n",
       "      <td>17.6</td>\n",
       "      <td>20.1</td>\n",
       "      <td>18.1</td>\n",
       "      <td>10.5</td>\n",
       "      <td>11.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>75</td>\n",
       "      <td>Nouvelle-Aquitaine</td>\n",
       "      <td>4.0</td>\n",
       "      <td>15.9</td>\n",
       "      <td>12.1</td>\n",
       "      <td>31.9</td>\n",
       "      <td>1.3</td>\n",
       "      <td>13.1</td>\n",
       "      <td>14.7</td>\n",
       "      <td>16.7</td>\n",
       "      <td>7.1</td>\n",
       "      <td>21290.0</td>\n",
       "      <td>5979778.0</td>\n",
       "      <td>15.9</td>\n",
       "      <td>17.4</td>\n",
       "      <td>20.3</td>\n",
       "      <td>19.0</td>\n",
       "      <td>11.4</td>\n",
       "      <td>12.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>76</td>\n",
       "      <td>Occitanie</td>\n",
       "      <td>4.3</td>\n",
       "      <td>15.7</td>\n",
       "      <td>10.2</td>\n",
       "      <td>29.3</td>\n",
       "      <td>1.2</td>\n",
       "      <td>13.6</td>\n",
       "      <td>17.3</td>\n",
       "      <td>20.1</td>\n",
       "      <td>8.4</td>\n",
       "      <td>20740.0</td>\n",
       "      <td>5885496.0</td>\n",
       "      <td>16.8</td>\n",
       "      <td>17.7</td>\n",
       "      <td>20.0</td>\n",
       "      <td>18.1</td>\n",
       "      <td>10.7</td>\n",
       "      <td>14.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>84</td>\n",
       "      <td>Auvergne-Rhône-Alpes</td>\n",
       "      <td>3.9</td>\n",
       "      <td>15.6</td>\n",
       "      <td>12.4</td>\n",
       "      <td>27.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>15.2</td>\n",
       "      <td>15.7</td>\n",
       "      <td>18.3</td>\n",
       "      <td>9.4</td>\n",
       "      <td>22480.0</td>\n",
       "      <td>7994459.0</td>\n",
       "      <td>17.6</td>\n",
       "      <td>18.8</td>\n",
       "      <td>19.8</td>\n",
       "      <td>16.2</td>\n",
       "      <td>9.4</td>\n",
       "      <td>11.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>93</td>\n",
       "      <td>Provence-Alpes-Côte d'Azur</td>\n",
       "      <td>4.4</td>\n",
       "      <td>16.4</td>\n",
       "      <td>9.7</td>\n",
       "      <td>28.9</td>\n",
       "      <td>0.4</td>\n",
       "      <td>13.6</td>\n",
       "      <td>18.3</td>\n",
       "      <td>21.5</td>\n",
       "      <td>8.3</td>\n",
       "      <td>21350.0</td>\n",
       "      <td>5052832.0</td>\n",
       "      <td>16.1</td>\n",
       "      <td>17.9</td>\n",
       "      <td>20.1</td>\n",
       "      <td>18.0</td>\n",
       "      <td>11.1</td>\n",
       "      <td>14.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>94</td>\n",
       "      <td>Corse</td>\n",
       "      <td>5.7</td>\n",
       "      <td>18.6</td>\n",
       "      <td>10.4</td>\n",
       "      <td>27.0</td>\n",
       "      <td>0.9</td>\n",
       "      <td>11.8</td>\n",
       "      <td>20.3</td>\n",
       "      <td>26.3</td>\n",
       "      <td>5.3</td>\n",
       "      <td>20670.0</td>\n",
       "      <td>338554.0</td>\n",
       "      <td>14.9</td>\n",
       "      <td>19.1</td>\n",
       "      <td>20.7</td>\n",
       "      <td>18.5</td>\n",
       "      <td>11.2</td>\n",
       "      <td>11.7</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Code                     Libellé  \\\n",
       "5    11               Île-de-France   \n",
       "6    24         Centre-Val de Loire   \n",
       "7    27     Bourgogne-Franche-Comté   \n",
       "8    28                   Normandie   \n",
       "9    32             Hauts-de-France   \n",
       "10   44                   Grand Est   \n",
       "11   52            Pays de la Loire   \n",
       "12   53                    Bretagne   \n",
       "13   75          Nouvelle-Aquitaine   \n",
       "14   76                   Occitanie   \n",
       "15   84        Auvergne-Rhône-Alpes   \n",
       "16   93  Provence-Alpes-Côte d'Azur   \n",
       "17   94                       Corse   \n",
       "\n",
       "    Part des \"artisans, commerçants, chefs d'entreprise\" dans la population 2018  \\\n",
       "5                                                 3.2                              \n",
       "6                                                 3.2                              \n",
       "7                                                 3.3                              \n",
       "8                                                 3.2                              \n",
       "9                                                 2.6                              \n",
       "10                                                2.9                              \n",
       "11                                                3.3                              \n",
       "12                                                3.5                              \n",
       "13                                                4.0                              \n",
       "14                                                4.3                              \n",
       "15                                                3.9                              \n",
       "16                                                4.4                              \n",
       "17                                                5.7                              \n",
       "\n",
       "    Part des \"employés\" dans la population 2018  \\\n",
       "5                                          16.4   \n",
       "6                                          16.0   \n",
       "7                                          15.2   \n",
       "8                                          16.0   \n",
       "9                                          16.4   \n",
       "10                                         16.4   \n",
       "11                                         15.3   \n",
       "12                                         15.1   \n",
       "13                                         15.9   \n",
       "14                                         15.7   \n",
       "15                                         15.6   \n",
       "16                                         16.4   \n",
       "17                                         18.6   \n",
       "\n",
       "    Part des \"ouvriers\" dans la population 2018  \\\n",
       "5                                           8.5   \n",
       "6                                          13.9   \n",
       "7                                          14.8   \n",
       "8                                          14.4   \n",
       "9                                          14.7   \n",
       "10                                         14.7   \n",
       "11                                         14.8   \n",
       "12                                         13.0   \n",
       "13                                         12.1   \n",
       "14                                         10.2   \n",
       "15                                         12.4   \n",
       "16                                          9.7   \n",
       "17                                         10.4   \n",
       "\n",
       "    Part des \"retraités\" dans la population 2018  \\\n",
       "5                                           19.4   \n",
       "6                                           31.0   \n",
       "7                                           31.4   \n",
       "8                                           30.1   \n",
       "9                                           25.5   \n",
       "10                                          27.3   \n",
       "11                                          29.4   \n",
       "12                                          31.2   \n",
       "13                                          31.9   \n",
       "14                                          29.3   \n",
       "15                                          27.0   \n",
       "16                                          28.9   \n",
       "17                                          27.0   \n",
       "\n",
       "    Part des \"agriculteurs exploitants\" dans la population 2018  \\\n",
       "5                                                 0.1             \n",
       "6                                                 1.0             \n",
       "7                                                 1.2             \n",
       "8                                                 1.0             \n",
       "9                                                 0.5             \n",
       "10                                                0.8             \n",
       "11                                                1.2             \n",
       "12                                                1.3             \n",
       "13                                                1.3             \n",
       "14                                                1.2             \n",
       "15                                                0.8             \n",
       "16                                                0.4             \n",
       "17                                                0.9             \n",
       "\n",
       "    Part des \"professions intermédiaires\" dans la population 2018  \\\n",
       "5                                                15.9               \n",
       "6                                                13.8               \n",
       "7                                                13.1               \n",
       "8                                                13.4               \n",
       "9                                                13.5               \n",
       "10                                               13.8               \n",
       "11                                               14.2               \n",
       "12                                               13.7               \n",
       "13                                               13.1               \n",
       "14                                               13.6               \n",
       "15                                               15.2               \n",
       "16                                               13.6               \n",
       "17                                               11.8               \n",
       "\n",
       "    Part des \"autres sans activité professionnelle\" dans la population 2018  \\\n",
       "5                                                18.3                         \n",
       "6                                                14.1                         \n",
       "7                                                14.6                         \n",
       "8                                                15.5                         \n",
       "9                                                19.8                         \n",
       "10                                               17.0                         \n",
       "11                                               13.9                         \n",
       "12                                               14.7                         \n",
       "13                                               14.7                         \n",
       "14                                               17.3                         \n",
       "15                                               15.7                         \n",
       "16                                               18.3                         \n",
       "17                                               20.3                         \n",
       "\n",
       "    Part des \"autres sans activité professionnelle\" dans la population 2018.1  \\\n",
       "5                                                20.7                           \n",
       "6                                                16.2                           \n",
       "7                                                17.1                           \n",
       "8                                                17.6                           \n",
       "9                                                23.4                           \n",
       "10                                               20.4                           \n",
       "11                                               15.6                           \n",
       "12                                               16.2                           \n",
       "13                                               16.7                           \n",
       "14                                               20.1                           \n",
       "15                                               18.3                           \n",
       "16                                               21.5                           \n",
       "17                                               26.3                           \n",
       "\n",
       "    Part des \"cadres et professions intellectuelles supérieures\" dans la population 2018  \\\n",
       "5                                                18.2                                      \n",
       "6                                                 7.1                                      \n",
       "7                                                 6.3                                      \n",
       "8                                                 6.4                                      \n",
       "9                                                 7.0                                      \n",
       "10                                                7.2                                      \n",
       "11                                                7.8                                      \n",
       "12                                                7.6                                      \n",
       "13                                                7.1                                      \n",
       "14                                                8.4                                      \n",
       "15                                                9.4                                      \n",
       "16                                                8.3                                      \n",
       "17                                                5.3                                      \n",
       "\n",
       "    Médiane du revenu disponible par UC 2018  \\\n",
       "5                                    23860.0   \n",
       "6                                    21560.0   \n",
       "7                                    21480.0   \n",
       "8                                    21200.0   \n",
       "9                                    20110.0   \n",
       "10                                   21610.0   \n",
       "11                                   21620.0   \n",
       "12                                   21750.0   \n",
       "13                                   21290.0   \n",
       "14                                   20740.0   \n",
       "15                                   22480.0   \n",
       "16                                   21350.0   \n",
       "17                                   20670.0   \n",
       "\n",
       "    Population au dernier recensement 2018  Part des 15-29 ans 2018  \\\n",
       "5                               12213447.0                     20.0   \n",
       "6                                2572853.0                     15.9   \n",
       "7                                2807807.0                     16.2   \n",
       "8                                3327477.0                     16.9   \n",
       "9                                6004108.0                     18.5   \n",
       "10                               5550389.0                     17.5   \n",
       "11                               3781423.0                     17.0   \n",
       "12                               3335414.0                     16.4   \n",
       "13                               5979778.0                     15.9   \n",
       "14                               5885496.0                     16.8   \n",
       "15                               7994459.0                     17.6   \n",
       "16                               5052832.0                     16.1   \n",
       "17                                338554.0                     14.9   \n",
       "\n",
       "    Part des 30-44 ans 2018  Part des 45-59 ans 2018  Part des 60-74 ans 2018  \\\n",
       "5                      21.2                     19.4                     13.2   \n",
       "6                      17.5                     20.1                     18.1   \n",
       "7                      17.3                     20.1                     18.6   \n",
       "8                      17.7                     19.9                     17.8   \n",
       "9                      18.8                     19.5                     15.9   \n",
       "10                     18.3                     20.6                     17.1   \n",
       "11                     18.4                     19.5                     16.8   \n",
       "12                     17.6                     20.1                     18.1   \n",
       "13                     17.4                     20.3                     19.0   \n",
       "14                     17.7                     20.0                     18.1   \n",
       "15                     18.8                     19.8                     16.2   \n",
       "16                     17.9                     20.1                     18.0   \n",
       "17                     19.1                     20.7                     18.5   \n",
       "\n",
       "    Part des 75 ans et plus 2018  Taux de chômage des 15 ans et plus (RP) 2018  \n",
       "5                            6.8                                          12.1  \n",
       "6                           10.7                                          12.5  \n",
       "7                           10.9                                          12.0  \n",
       "8                            9.9                                          13.2  \n",
       "9                            7.9                                          16.3  \n",
       "10                           9.3                                          13.3  \n",
       "11                           9.7                                          11.2  \n",
       "12                          10.5                                          11.4  \n",
       "13                          11.4                                          12.6  \n",
       "14                          10.7                                          14.5  \n",
       "15                           9.4                                          11.4  \n",
       "16                          11.1                                          14.0  \n",
       "17                          11.2                                          11.7  "
      ]
     },
     "execution_count": 80,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "socio[\"Code\"]=socio[\"Code\"].astype(\"str\")\n",
    "socio.drop( socio[ (socio['Code'] == \"1\") | (socio['Code'] == \"2\") | (socio['Code'] == \"3\") | (socio['Code'] == \"4\") | (socio['Code'] == \"6\")].index, inplace=True)\n",
    "socio"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Base de données merged"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 98,
   "metadata": {},
   "outputs": [],
   "source": [
    "enedis_menage[\"code_region\"]=enedis_menage[\"code_region\"].astype(\"str\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 99,
   "metadata": {},
   "outputs": [],
   "source": [
    "enedis_socio=pd.merge(enedis_menage,socio,how='left',left_on=\"code_region\",right_on=\"Code\")"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Finalement, il faut merger les données météo et enedis sur date et région"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 100,
   "metadata": {},
   "outputs": [],
   "source": [
    "meteo_reg_df[\"code_insee_region\"]=meteo_reg_df[\"code_insee_region\"].astype(\"str\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 101,
   "metadata": {},
   "outputs": [],
   "source": [
    "enedis_final=pd.merge(enedis_socio,meteo_reg_df,how='left',left_on=[\"date\",\"code_region\"],right_on=[\"date\",\"code_insee_region\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 102,
   "metadata": {},
   "outputs": [],
   "source": [
    "enedis_final.drop(columns=[\"region_y\",\"id\",\"tmin\",\"tmax\",\"code_insee_region\"],inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 103,
   "metadata": {},
   "outputs": [],
   "source": [
    "enedis_final.to_csv(\"Données/enedis_final.csv\",index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 113,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>horodate</th>\n",
       "      <th>region_x</th>\n",
       "      <th>code_region</th>\n",
       "      <th>total_energie_soutiree_wh</th>\n",
       "      <th>plage_de_puissance_souscrite</th>\n",
       "      <th>nb_points_soutirage</th>\n",
       "      <th>jour_max_du_mois_0_1</th>\n",
       "      <th>semaine_max_du_mois_0_1</th>\n",
       "      <th>profil</th>\n",
       "      <th>profil_type</th>\n",
       "      <th>...</th>\n",
       "      <th>Médiane du revenu disponible par UC 2018</th>\n",
       "      <th>Population au dernier recensement 2018</th>\n",
       "      <th>Part des 15-29 ans 2018</th>\n",
       "      <th>Part des 30-44 ans 2018</th>\n",
       "      <th>Part des 45-59 ans 2018</th>\n",
       "      <th>Part des 60-74 ans 2018</th>\n",
       "      <th>Part des 75 ans et plus 2018</th>\n",
       "      <th>Taux de chômage des 15 ans et plus (RP) 2018</th>\n",
       "      <th>tmoy</th>\n",
       "      <th>date_cut</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-06-04T00:00:00+00:00</td>\n",
       "      <td>Auvergne-Rhône-Alpes</td>\n",
       "      <td>84</td>\n",
       "      <td>130666817.0</td>\n",
       "      <td>P2: ]3-6] kVA</td>\n",
       "      <td>1685439</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES1 (+ RES1WE)</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>22480.0</td>\n",
       "      <td>7994459.0</td>\n",
       "      <td>17.6</td>\n",
       "      <td>18.8</td>\n",
       "      <td>19.8</td>\n",
       "      <td>16.2</td>\n",
       "      <td>9.4</td>\n",
       "      <td>11.4</td>\n",
       "      <td>16.48</td>\n",
       "      <td>2020-06-04T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-06-04T00:00:00+00:00</td>\n",
       "      <td>Auvergne-Rhône-Alpes</td>\n",
       "      <td>84</td>\n",
       "      <td>436083.0</td>\n",
       "      <td>P8: ]24-30] kVA</td>\n",
       "      <td>901</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES11 (+ RES11WE)</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>22480.0</td>\n",
       "      <td>7994459.0</td>\n",
       "      <td>17.6</td>\n",
       "      <td>18.8</td>\n",
       "      <td>19.8</td>\n",
       "      <td>16.2</td>\n",
       "      <td>9.4</td>\n",
       "      <td>11.4</td>\n",
       "      <td>16.48</td>\n",
       "      <td>2020-06-04T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-06-04T00:00:00+00:00</td>\n",
       "      <td>Auvergne-Rhône-Alpes</td>\n",
       "      <td>84</td>\n",
       "      <td>2133213.0</td>\n",
       "      <td>P9: ]30-36] kVA</td>\n",
       "      <td>3839</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES11 (+ RES11WE)</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>22480.0</td>\n",
       "      <td>7994459.0</td>\n",
       "      <td>17.6</td>\n",
       "      <td>18.8</td>\n",
       "      <td>19.8</td>\n",
       "      <td>16.2</td>\n",
       "      <td>9.4</td>\n",
       "      <td>11.4</td>\n",
       "      <td>16.48</td>\n",
       "      <td>2020-06-04T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-06-04T00:00:00+00:00</td>\n",
       "      <td>Auvergne-Rhône-Alpes</td>\n",
       "      <td>84</td>\n",
       "      <td>104448854.0</td>\n",
       "      <td>P4: ]9-12] kVA</td>\n",
       "      <td>269648</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES2 (+ RES5)</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>22480.0</td>\n",
       "      <td>7994459.0</td>\n",
       "      <td>17.6</td>\n",
       "      <td>18.8</td>\n",
       "      <td>19.8</td>\n",
       "      <td>16.2</td>\n",
       "      <td>9.4</td>\n",
       "      <td>11.4</td>\n",
       "      <td>16.48</td>\n",
       "      <td>2020-06-04T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-06-04T00:00:00+00:00</td>\n",
       "      <td>Auvergne-Rhône-Alpes</td>\n",
       "      <td>84</td>\n",
       "      <td>804838.0</td>\n",
       "      <td>P4: ]9-12] kVA</td>\n",
       "      <td>1830</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES2WE</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>22480.0</td>\n",
       "      <td>7994459.0</td>\n",
       "      <td>17.6</td>\n",
       "      <td>18.8</td>\n",
       "      <td>19.8</td>\n",
       "      <td>16.2</td>\n",
       "      <td>9.4</td>\n",
       "      <td>11.4</td>\n",
       "      <td>16.48</td>\n",
       "      <td>2020-06-04T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4876512</th>\n",
       "      <td>2021-08-15T00:00:00+00:00</td>\n",
       "      <td>Grand-Est</td>\n",
       "      <td>44</td>\n",
       "      <td>2278143.0</td>\n",
       "      <td>P0: Total &lt;= 36 kVA</td>\n",
       "      <td>13717</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES2WE</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>21610.0</td>\n",
       "      <td>5550389.0</td>\n",
       "      <td>17.5</td>\n",
       "      <td>18.3</td>\n",
       "      <td>20.6</td>\n",
       "      <td>17.1</td>\n",
       "      <td>9.3</td>\n",
       "      <td>13.3</td>\n",
       "      <td>22.76</td>\n",
       "      <td>2021-08-15T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4876513</th>\n",
       "      <td>2021-08-15T00:00:00+00:00</td>\n",
       "      <td>Grand-Est</td>\n",
       "      <td>44</td>\n",
       "      <td>4639000.0</td>\n",
       "      <td>P0: Total &lt;= 36 kVA</td>\n",
       "      <td>14822</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES3</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>21610.0</td>\n",
       "      <td>5550389.0</td>\n",
       "      <td>17.5</td>\n",
       "      <td>18.3</td>\n",
       "      <td>20.6</td>\n",
       "      <td>17.1</td>\n",
       "      <td>9.3</td>\n",
       "      <td>13.3</td>\n",
       "      <td>22.76</td>\n",
       "      <td>2021-08-15T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4876514</th>\n",
       "      <td>2021-08-15T00:00:00+00:00</td>\n",
       "      <td>Grand-Est</td>\n",
       "      <td>44</td>\n",
       "      <td>1200637.0</td>\n",
       "      <td>P6: ]15-18] kVA</td>\n",
       "      <td>3395</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES3</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>21610.0</td>\n",
       "      <td>5550389.0</td>\n",
       "      <td>17.5</td>\n",
       "      <td>18.3</td>\n",
       "      <td>20.6</td>\n",
       "      <td>17.1</td>\n",
       "      <td>9.3</td>\n",
       "      <td>13.3</td>\n",
       "      <td>22.76</td>\n",
       "      <td>2021-08-15T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4876515</th>\n",
       "      <td>2021-08-15T00:00:00+00:00</td>\n",
       "      <td>Pays de la Loire</td>\n",
       "      <td>52</td>\n",
       "      <td>9344100.0</td>\n",
       "      <td>P6: ]15-18] kVA</td>\n",
       "      <td>20440</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES2 (+ RES5)</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>21620.0</td>\n",
       "      <td>3781423.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>18.4</td>\n",
       "      <td>19.5</td>\n",
       "      <td>16.8</td>\n",
       "      <td>9.7</td>\n",
       "      <td>11.2</td>\n",
       "      <td>20.08</td>\n",
       "      <td>2021-08-15T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4876516</th>\n",
       "      <td>2021-08-15T00:00:00+00:00</td>\n",
       "      <td>Normandie</td>\n",
       "      <td>28</td>\n",
       "      <td>964757.0</td>\n",
       "      <td>P5: ]12-15] kVA</td>\n",
       "      <td>4717</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES11 (+ RES11WE)</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>21200.0</td>\n",
       "      <td>3327477.0</td>\n",
       "      <td>16.9</td>\n",
       "      <td>17.7</td>\n",
       "      <td>19.9</td>\n",
       "      <td>17.8</td>\n",
       "      <td>9.9</td>\n",
       "      <td>13.2</td>\n",
       "      <td>18.23</td>\n",
       "      <td>2021-08-15T00:00:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4876517 rows × 36 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                          horodate              region_x code_region  \\\n",
       "0        2020-06-04T00:00:00+00:00  Auvergne-Rhône-Alpes          84   \n",
       "1        2020-06-04T00:00:00+00:00  Auvergne-Rhône-Alpes          84   \n",
       "2        2020-06-04T00:00:00+00:00  Auvergne-Rhône-Alpes          84   \n",
       "3        2020-06-04T00:00:00+00:00  Auvergne-Rhône-Alpes          84   \n",
       "4        2020-06-04T00:00:00+00:00  Auvergne-Rhône-Alpes          84   \n",
       "...                            ...                   ...         ...   \n",
       "4876512  2021-08-15T00:00:00+00:00             Grand-Est          44   \n",
       "4876513  2021-08-15T00:00:00+00:00             Grand-Est          44   \n",
       "4876514  2021-08-15T00:00:00+00:00             Grand-Est          44   \n",
       "4876515  2021-08-15T00:00:00+00:00      Pays de la Loire          52   \n",
       "4876516  2021-08-15T00:00:00+00:00             Normandie          28   \n",
       "\n",
       "         total_energie_soutiree_wh plage_de_puissance_souscrite  \\\n",
       "0                      130666817.0                P2: ]3-6] kVA   \n",
       "1                         436083.0              P8: ]24-30] kVA   \n",
       "2                        2133213.0              P9: ]30-36] kVA   \n",
       "3                      104448854.0               P4: ]9-12] kVA   \n",
       "4                         804838.0               P4: ]9-12] kVA   \n",
       "...                            ...                          ...   \n",
       "4876512                  2278143.0          P0: Total <= 36 kVA   \n",
       "4876513                  4639000.0          P0: Total <= 36 kVA   \n",
       "4876514                  1200637.0              P6: ]15-18] kVA   \n",
       "4876515                  9344100.0              P6: ]15-18] kVA   \n",
       "4876516                   964757.0              P5: ]12-15] kVA   \n",
       "\n",
       "         nb_points_soutirage  jour_max_du_mois_0_1  semaine_max_du_mois_0_1  \\\n",
       "0                    1685439                     0                        0   \n",
       "1                        901                     0                        0   \n",
       "2                       3839                     0                        0   \n",
       "3                     269648                     0                        0   \n",
       "4                       1830                     0                        0   \n",
       "...                      ...                   ...                      ...   \n",
       "4876512                13717                     0                        0   \n",
       "4876513                14822                     0                        0   \n",
       "4876514                 3395                     0                        0   \n",
       "4876515                20440                     0                        0   \n",
       "4876516                 4717                     0                        0   \n",
       "\n",
       "                    profil profil_type  ...  \\\n",
       "0          RES1 (+ RES1WE)         RES  ...   \n",
       "1        RES11 (+ RES11WE)         RES  ...   \n",
       "2        RES11 (+ RES11WE)         RES  ...   \n",
       "3            RES2 (+ RES5)         RES  ...   \n",
       "4                   RES2WE         RES  ...   \n",
       "...                    ...         ...  ...   \n",
       "4876512             RES2WE         RES  ...   \n",
       "4876513               RES3         RES  ...   \n",
       "4876514               RES3         RES  ...   \n",
       "4876515      RES2 (+ RES5)         RES  ...   \n",
       "4876516  RES11 (+ RES11WE)         RES  ...   \n",
       "\n",
       "        Médiane du revenu disponible par UC 2018  \\\n",
       "0                                        22480.0   \n",
       "1                                        22480.0   \n",
       "2                                        22480.0   \n",
       "3                                        22480.0   \n",
       "4                                        22480.0   \n",
       "...                                          ...   \n",
       "4876512                                  21610.0   \n",
       "4876513                                  21610.0   \n",
       "4876514                                  21610.0   \n",
       "4876515                                  21620.0   \n",
       "4876516                                  21200.0   \n",
       "\n",
       "         Population au dernier recensement 2018 Part des 15-29 ans 2018  \\\n",
       "0                                     7994459.0                    17.6   \n",
       "1                                     7994459.0                    17.6   \n",
       "2                                     7994459.0                    17.6   \n",
       "3                                     7994459.0                    17.6   \n",
       "4                                     7994459.0                    17.6   \n",
       "...                                         ...                     ...   \n",
       "4876512                               5550389.0                    17.5   \n",
       "4876513                               5550389.0                    17.5   \n",
       "4876514                               5550389.0                    17.5   \n",
       "4876515                               3781423.0                    17.0   \n",
       "4876516                               3327477.0                    16.9   \n",
       "\n",
       "         Part des 30-44 ans 2018  Part des 45-59 ans 2018  \\\n",
       "0                           18.8                     19.8   \n",
       "1                           18.8                     19.8   \n",
       "2                           18.8                     19.8   \n",
       "3                           18.8                     19.8   \n",
       "4                           18.8                     19.8   \n",
       "...                          ...                      ...   \n",
       "4876512                     18.3                     20.6   \n",
       "4876513                     18.3                     20.6   \n",
       "4876514                     18.3                     20.6   \n",
       "4876515                     18.4                     19.5   \n",
       "4876516                     17.7                     19.9   \n",
       "\n",
       "        Part des 60-74 ans 2018 Part des 75 ans et plus 2018  \\\n",
       "0                          16.2                          9.4   \n",
       "1                          16.2                          9.4   \n",
       "2                          16.2                          9.4   \n",
       "3                          16.2                          9.4   \n",
       "4                          16.2                          9.4   \n",
       "...                         ...                          ...   \n",
       "4876512                    17.1                          9.3   \n",
       "4876513                    17.1                          9.3   \n",
       "4876514                    17.1                          9.3   \n",
       "4876515                    16.8                          9.7   \n",
       "4876516                    17.8                          9.9   \n",
       "\n",
       "         Taux de chômage des 15 ans et plus (RP) 2018   tmoy  \\\n",
       "0                                                11.4  16.48   \n",
       "1                                                11.4  16.48   \n",
       "2                                                11.4  16.48   \n",
       "3                                                11.4  16.48   \n",
       "4                                                11.4  16.48   \n",
       "...                                               ...    ...   \n",
       "4876512                                          13.3  22.76   \n",
       "4876513                                          13.3  22.76   \n",
       "4876514                                          13.3  22.76   \n",
       "4876515                                          11.2  20.08   \n",
       "4876516                                          13.2  18.23   \n",
       "\n",
       "                    date_cut  \n",
       "0        2020-06-04T00:00:00  \n",
       "1        2020-06-04T00:00:00  \n",
       "2        2020-06-04T00:00:00  \n",
       "3        2020-06-04T00:00:00  \n",
       "4        2020-06-04T00:00:00  \n",
       "...                      ...  \n",
       "4876512  2021-08-15T00:00:00  \n",
       "4876513  2021-08-15T00:00:00  \n",
       "4876514  2021-08-15T00:00:00  \n",
       "4876515  2021-08-15T00:00:00  \n",
       "4876516  2021-08-15T00:00:00  \n",
       "\n",
       "[4876517 rows x 36 columns]"
      ]
     },
     "execution_count": 113,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "enedis_final"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Table enedis pour toutes les 3H :"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 105,
   "metadata": {},
   "outputs": [],
   "source": [
    "meteo_3h_mean[\"date_cut\"]=meteo_3h_mean[\"Date\"].str[0:19]\n",
    "enedis_final[\"date_cut\"]=enedis_final[\"horodate\"].str[0:19]\n",
    "enedis_final[\"code_region\"]=enedis_final[\"code_region\"].astype(\"str\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 106,
   "metadata": {},
   "outputs": [],
   "source": [
    "enedis_final_3h=pd.merge(enedis_final,meteo_3h_mean,how='left',left_on=[\"date_cut\",\"code_region\"],right_on=[\"date_cut\",\"region (code)\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 107,
   "metadata": {},
   "outputs": [],
   "source": [
    "enedis_final_3h.dropna(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 108,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>horodate</th>\n",
       "      <th>region_x</th>\n",
       "      <th>code_region</th>\n",
       "      <th>total_energie_soutiree_wh</th>\n",
       "      <th>plage_de_puissance_souscrite</th>\n",
       "      <th>nb_points_soutirage</th>\n",
       "      <th>jour_max_du_mois_0_1</th>\n",
       "      <th>semaine_max_du_mois_0_1</th>\n",
       "      <th>profil</th>\n",
       "      <th>profil_type</th>\n",
       "      <th>...</th>\n",
       "      <th>Part des 30-44 ans 2018</th>\n",
       "      <th>Part des 45-59 ans 2018</th>\n",
       "      <th>Part des 60-74 ans 2018</th>\n",
       "      <th>Part des 75 ans et plus 2018</th>\n",
       "      <th>Taux de chômage des 15 ans et plus (RP) 2018</th>\n",
       "      <th>tmoy</th>\n",
       "      <th>date_cut</th>\n",
       "      <th>Date</th>\n",
       "      <th>region (code)</th>\n",
       "      <th>Température (°C)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1110</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Bretagne</td>\n",
       "      <td>53</td>\n",
       "      <td>266081.0</td>\n",
       "      <td>P9: ]30-36] kVA</td>\n",
       "      <td>626</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES11 (+ RES11WE)</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>17.6</td>\n",
       "      <td>20.1</td>\n",
       "      <td>18.1</td>\n",
       "      <td>10.5</td>\n",
       "      <td>11.4</td>\n",
       "      <td>14.26</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>53</td>\n",
       "      <td>13.600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1111</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Bretagne</td>\n",
       "      <td>53</td>\n",
       "      <td>776483.0</td>\n",
       "      <td>P7: ]18-24] kVA</td>\n",
       "      <td>1998</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES2 (+ RES5)</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>17.6</td>\n",
       "      <td>20.1</td>\n",
       "      <td>18.1</td>\n",
       "      <td>10.5</td>\n",
       "      <td>11.4</td>\n",
       "      <td>14.26</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>53</td>\n",
       "      <td>13.600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1112</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Bretagne</td>\n",
       "      <td>53</td>\n",
       "      <td>302715.0</td>\n",
       "      <td>P8: ]24-30] kVA</td>\n",
       "      <td>652</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES2 (+ RES5)</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>17.6</td>\n",
       "      <td>20.1</td>\n",
       "      <td>18.1</td>\n",
       "      <td>10.5</td>\n",
       "      <td>11.4</td>\n",
       "      <td>14.26</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>53</td>\n",
       "      <td>13.600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1113</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Centre-Val de Loire</td>\n",
       "      <td>24</td>\n",
       "      <td>853235.0</td>\n",
       "      <td>P5: ]12-15] kVA</td>\n",
       "      <td>4498</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES11 (+ RES11WE)</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>17.5</td>\n",
       "      <td>20.1</td>\n",
       "      <td>18.1</td>\n",
       "      <td>10.7</td>\n",
       "      <td>12.5</td>\n",
       "      <td>15.43</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>24</td>\n",
       "      <td>14.850000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1114</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Centre-Val de Loire</td>\n",
       "      <td>24</td>\n",
       "      <td>489877.0</td>\n",
       "      <td>P5: ]12-15] kVA</td>\n",
       "      <td>1974</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES4</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>17.5</td>\n",
       "      <td>20.1</td>\n",
       "      <td>18.1</td>\n",
       "      <td>10.7</td>\n",
       "      <td>12.5</td>\n",
       "      <td>15.43</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>24</td>\n",
       "      <td>14.850000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1115</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Grand-Est</td>\n",
       "      <td>44</td>\n",
       "      <td>1096505.0</td>\n",
       "      <td>P9: ]30-36] kVA</td>\n",
       "      <td>1991</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES11 (+ RES11WE)</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>18.3</td>\n",
       "      <td>20.6</td>\n",
       "      <td>17.1</td>\n",
       "      <td>9.3</td>\n",
       "      <td>13.3</td>\n",
       "      <td>15.82</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>44</td>\n",
       "      <td>15.380000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1116</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Hauts-de-France</td>\n",
       "      <td>32</td>\n",
       "      <td>90834160.0</td>\n",
       "      <td>P0: Total &lt;= 36 kVA</td>\n",
       "      <td>1204025</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES1 (+ RES1WE)</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>18.8</td>\n",
       "      <td>19.5</td>\n",
       "      <td>15.9</td>\n",
       "      <td>7.9</td>\n",
       "      <td>16.3</td>\n",
       "      <td>13.66</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>32</td>\n",
       "      <td>12.850000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1117</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Hauts-de-France</td>\n",
       "      <td>32</td>\n",
       "      <td>391487.0</td>\n",
       "      <td>P4: ]9-12] kVA</td>\n",
       "      <td>1732</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES2WE</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>18.8</td>\n",
       "      <td>19.5</td>\n",
       "      <td>15.9</td>\n",
       "      <td>7.9</td>\n",
       "      <td>16.3</td>\n",
       "      <td>13.66</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>32</td>\n",
       "      <td>12.850000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1118</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Grand-Est</td>\n",
       "      <td>44</td>\n",
       "      <td>431878.0</td>\n",
       "      <td>P7: ]18-24] kVA</td>\n",
       "      <td>1097</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES11 (+ RES11WE)</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>18.3</td>\n",
       "      <td>20.6</td>\n",
       "      <td>17.1</td>\n",
       "      <td>9.3</td>\n",
       "      <td>13.3</td>\n",
       "      <td>15.82</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>44</td>\n",
       "      <td>15.380000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1119</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Centre-Val de Loire</td>\n",
       "      <td>24</td>\n",
       "      <td>43173333.0</td>\n",
       "      <td>P3: ]6-9] kVA</td>\n",
       "      <td>233830</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES2 (+ RES5)</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>17.5</td>\n",
       "      <td>20.1</td>\n",
       "      <td>18.1</td>\n",
       "      <td>10.7</td>\n",
       "      <td>12.5</td>\n",
       "      <td>15.43</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>24</td>\n",
       "      <td>14.850000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1120</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Auvergne-Rhône-Alpes</td>\n",
       "      <td>84</td>\n",
       "      <td>1664940.0</td>\n",
       "      <td>P6: ]15-18] kVA</td>\n",
       "      <td>6451</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES3</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>18.8</td>\n",
       "      <td>19.8</td>\n",
       "      <td>16.2</td>\n",
       "      <td>9.4</td>\n",
       "      <td>11.4</td>\n",
       "      <td>16.48</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>84</td>\n",
       "      <td>14.925000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1121</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Île-de-France</td>\n",
       "      <td>11</td>\n",
       "      <td>81861728.0</td>\n",
       "      <td>P1: ]0-6] kVA</td>\n",
       "      <td>803718</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES2 (+ RES5)</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>21.2</td>\n",
       "      <td>19.4</td>\n",
       "      <td>13.2</td>\n",
       "      <td>6.8</td>\n",
       "      <td>12.1</td>\n",
       "      <td>14.51</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>11</td>\n",
       "      <td>14.900000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1122</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Île-de-France</td>\n",
       "      <td>11</td>\n",
       "      <td>49033027.0</td>\n",
       "      <td>P4: ]9-12] kVA</td>\n",
       "      <td>222124</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES2 (+ RES5)</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>21.2</td>\n",
       "      <td>19.4</td>\n",
       "      <td>13.2</td>\n",
       "      <td>6.8</td>\n",
       "      <td>12.1</td>\n",
       "      <td>14.51</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>11</td>\n",
       "      <td>14.900000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1123</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Île-de-France</td>\n",
       "      <td>11</td>\n",
       "      <td>3908376.0</td>\n",
       "      <td>P0: Total &lt;= 36 kVA</td>\n",
       "      <td>29220</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES2WE</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>21.2</td>\n",
       "      <td>19.4</td>\n",
       "      <td>13.2</td>\n",
       "      <td>6.8</td>\n",
       "      <td>12.1</td>\n",
       "      <td>14.51</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>11</td>\n",
       "      <td>14.900000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1124</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Normandie</td>\n",
       "      <td>28</td>\n",
       "      <td>2361096.0</td>\n",
       "      <td>P6: ]15-18] kVA</td>\n",
       "      <td>7983</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES4</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>17.7</td>\n",
       "      <td>19.9</td>\n",
       "      <td>17.8</td>\n",
       "      <td>9.9</td>\n",
       "      <td>13.2</td>\n",
       "      <td>13.02</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>28</td>\n",
       "      <td>13.400000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1125</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Nouvelle Aquitaine</td>\n",
       "      <td>75</td>\n",
       "      <td>10631790.0</td>\n",
       "      <td>P4: ]9-12] kVA</td>\n",
       "      <td>69305</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES11 (+ RES11WE)</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>17.4</td>\n",
       "      <td>20.3</td>\n",
       "      <td>19.0</td>\n",
       "      <td>11.4</td>\n",
       "      <td>12.6</td>\n",
       "      <td>16.66</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>75</td>\n",
       "      <td>15.020000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1126</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Nouvelle Aquitaine</td>\n",
       "      <td>75</td>\n",
       "      <td>513252.0</td>\n",
       "      <td>P7: ]18-24] kVA</td>\n",
       "      <td>1444</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES11 (+ RES11WE)</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>17.4</td>\n",
       "      <td>20.3</td>\n",
       "      <td>19.0</td>\n",
       "      <td>11.4</td>\n",
       "      <td>12.6</td>\n",
       "      <td>16.66</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>75</td>\n",
       "      <td>15.020000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1127</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Normandie</td>\n",
       "      <td>28</td>\n",
       "      <td>2095910.0</td>\n",
       "      <td>P6: ]15-18] kVA</td>\n",
       "      <td>1988</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES3</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>17.7</td>\n",
       "      <td>19.9</td>\n",
       "      <td>17.8</td>\n",
       "      <td>9.9</td>\n",
       "      <td>13.2</td>\n",
       "      <td>13.02</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>28</td>\n",
       "      <td>13.400000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1128</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Pays de la Loire</td>\n",
       "      <td>52</td>\n",
       "      <td>324194.0</td>\n",
       "      <td>P9: ]30-36] kVA</td>\n",
       "      <td>644</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES11 (+ RES11WE)</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>18.4</td>\n",
       "      <td>19.5</td>\n",
       "      <td>16.8</td>\n",
       "      <td>9.7</td>\n",
       "      <td>11.2</td>\n",
       "      <td>15.48</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>52</td>\n",
       "      <td>12.600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1129</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Pays de la Loire</td>\n",
       "      <td>52</td>\n",
       "      <td>32554925.0</td>\n",
       "      <td>P4: ]9-12] kVA</td>\n",
       "      <td>155670</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES2 (+ RES5)</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>18.4</td>\n",
       "      <td>19.5</td>\n",
       "      <td>16.8</td>\n",
       "      <td>9.7</td>\n",
       "      <td>11.2</td>\n",
       "      <td>15.48</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>52</td>\n",
       "      <td>12.600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1130</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Pays de la Loire</td>\n",
       "      <td>52</td>\n",
       "      <td>275792.0</td>\n",
       "      <td>P8: ]24-30] kVA</td>\n",
       "      <td>627</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES2 (+ RES5)</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>18.4</td>\n",
       "      <td>19.5</td>\n",
       "      <td>16.8</td>\n",
       "      <td>9.7</td>\n",
       "      <td>11.2</td>\n",
       "      <td>15.48</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>52</td>\n",
       "      <td>12.600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1131</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Pays de la Loire</td>\n",
       "      <td>52</td>\n",
       "      <td>471675.0</td>\n",
       "      <td>P9: ]30-36] kVA</td>\n",
       "      <td>972</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES2 (+ RES5)</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>18.4</td>\n",
       "      <td>19.5</td>\n",
       "      <td>16.8</td>\n",
       "      <td>9.7</td>\n",
       "      <td>11.2</td>\n",
       "      <td>15.48</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>52</td>\n",
       "      <td>12.600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1132</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Pays de la Loire</td>\n",
       "      <td>52</td>\n",
       "      <td>2634494.0</td>\n",
       "      <td>P0: Total &lt;= 36 kVA</td>\n",
       "      <td>11855</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES3</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>18.4</td>\n",
       "      <td>19.5</td>\n",
       "      <td>16.8</td>\n",
       "      <td>9.7</td>\n",
       "      <td>11.2</td>\n",
       "      <td>15.48</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>52</td>\n",
       "      <td>12.600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1133</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Occitanie</td>\n",
       "      <td>76</td>\n",
       "      <td>455401.0</td>\n",
       "      <td>P7: ]18-24] kVA</td>\n",
       "      <td>1302</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES11 (+ RES11WE)</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>17.7</td>\n",
       "      <td>20.0</td>\n",
       "      <td>18.1</td>\n",
       "      <td>10.7</td>\n",
       "      <td>14.5</td>\n",
       "      <td>17.74</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>76</td>\n",
       "      <td>16.414286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1134</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Provence-Alpes-Côte d'Azur</td>\n",
       "      <td>93</td>\n",
       "      <td>12281876.0</td>\n",
       "      <td>P0: Total &lt;= 36 kVA</td>\n",
       "      <td>37061</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES4</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>17.9</td>\n",
       "      <td>20.1</td>\n",
       "      <td>18.0</td>\n",
       "      <td>11.1</td>\n",
       "      <td>14.0</td>\n",
       "      <td>17.02</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>93</td>\n",
       "      <td>17.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1135</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Hauts-de-France</td>\n",
       "      <td>32</td>\n",
       "      <td>764259.0</td>\n",
       "      <td>P4: ]9-12] kVA</td>\n",
       "      <td>3186</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES3</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>18.8</td>\n",
       "      <td>19.5</td>\n",
       "      <td>15.9</td>\n",
       "      <td>7.9</td>\n",
       "      <td>16.3</td>\n",
       "      <td>13.66</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>32</td>\n",
       "      <td>12.850000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1136</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Auvergne-Rhône-Alpes</td>\n",
       "      <td>84</td>\n",
       "      <td>235895.0</td>\n",
       "      <td>P7: ]18-30] kVA</td>\n",
       "      <td>547</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES3</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>18.8</td>\n",
       "      <td>19.8</td>\n",
       "      <td>16.2</td>\n",
       "      <td>9.4</td>\n",
       "      <td>11.4</td>\n",
       "      <td>16.48</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>84</td>\n",
       "      <td>14.925000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1137</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Grand-Est</td>\n",
       "      <td>44</td>\n",
       "      <td>50629249.0</td>\n",
       "      <td>P1: ]0-6] kVA</td>\n",
       "      <td>395843</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES2 (+ RES5)</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>18.3</td>\n",
       "      <td>20.6</td>\n",
       "      <td>17.1</td>\n",
       "      <td>9.3</td>\n",
       "      <td>13.3</td>\n",
       "      <td>15.82</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>44</td>\n",
       "      <td>15.380000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1138</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Bourgogne-Franche-Comté</td>\n",
       "      <td>27</td>\n",
       "      <td>20737277.0</td>\n",
       "      <td>P4: ]9-12] kVA</td>\n",
       "      <td>96358</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES2 (+ RES5)</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>17.3</td>\n",
       "      <td>20.1</td>\n",
       "      <td>18.6</td>\n",
       "      <td>10.9</td>\n",
       "      <td>12.0</td>\n",
       "      <td>17.17</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>27</td>\n",
       "      <td>15.100000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1139</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Bourgogne-Franche-Comté</td>\n",
       "      <td>27</td>\n",
       "      <td>3132694.0</td>\n",
       "      <td>P6: ]15-18] kVA</td>\n",
       "      <td>11845</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES4</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>17.3</td>\n",
       "      <td>20.1</td>\n",
       "      <td>18.6</td>\n",
       "      <td>10.9</td>\n",
       "      <td>12.0</td>\n",
       "      <td>17.17</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>27</td>\n",
       "      <td>15.100000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1140</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Centre-Val de Loire</td>\n",
       "      <td>24</td>\n",
       "      <td>24110907.0</td>\n",
       "      <td>P1: ]0-6] kVA</td>\n",
       "      <td>201818</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES2 (+ RES5)</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>17.5</td>\n",
       "      <td>20.1</td>\n",
       "      <td>18.1</td>\n",
       "      <td>10.7</td>\n",
       "      <td>12.5</td>\n",
       "      <td>15.43</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>24</td>\n",
       "      <td>14.850000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1141</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Grand-Est</td>\n",
       "      <td>44</td>\n",
       "      <td>561739.0</td>\n",
       "      <td>P4: ]9-12] kVA</td>\n",
       "      <td>2208</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES3</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>18.3</td>\n",
       "      <td>20.6</td>\n",
       "      <td>17.1</td>\n",
       "      <td>9.3</td>\n",
       "      <td>13.3</td>\n",
       "      <td>15.82</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>44</td>\n",
       "      <td>15.380000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1142</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Grand-Est</td>\n",
       "      <td>44</td>\n",
       "      <td>4815545.0</td>\n",
       "      <td>P6: ]15-18] kVA</td>\n",
       "      <td>17768</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES4</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>18.3</td>\n",
       "      <td>20.6</td>\n",
       "      <td>17.1</td>\n",
       "      <td>9.3</td>\n",
       "      <td>13.3</td>\n",
       "      <td>15.82</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>44</td>\n",
       "      <td>15.380000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1143</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Hauts-de-France</td>\n",
       "      <td>32</td>\n",
       "      <td>574648.0</td>\n",
       "      <td>P9: ]30-36] kVA</td>\n",
       "      <td>1196</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES11 (+ RES11WE)</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>18.8</td>\n",
       "      <td>19.5</td>\n",
       "      <td>15.9</td>\n",
       "      <td>7.9</td>\n",
       "      <td>16.3</td>\n",
       "      <td>13.66</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>32</td>\n",
       "      <td>12.850000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1144</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Hauts-de-France</td>\n",
       "      <td>32</td>\n",
       "      <td>5118712.0</td>\n",
       "      <td>P5: ]12-15] kVA</td>\n",
       "      <td>22631</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES2 (+ RES5)</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>18.8</td>\n",
       "      <td>19.5</td>\n",
       "      <td>15.9</td>\n",
       "      <td>7.9</td>\n",
       "      <td>16.3</td>\n",
       "      <td>13.66</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>32</td>\n",
       "      <td>12.850000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1145</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Hauts-de-France</td>\n",
       "      <td>32</td>\n",
       "      <td>809933.0</td>\n",
       "      <td>P6: ]15-18] kVA</td>\n",
       "      <td>2854</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES3</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>18.8</td>\n",
       "      <td>19.5</td>\n",
       "      <td>15.9</td>\n",
       "      <td>7.9</td>\n",
       "      <td>16.3</td>\n",
       "      <td>13.66</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>32</td>\n",
       "      <td>12.850000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1146</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Île-de-France</td>\n",
       "      <td>11</td>\n",
       "      <td>8138884.0</td>\n",
       "      <td>P5: ]12-15] kVA</td>\n",
       "      <td>33089</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES2 (+ RES5)</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>21.2</td>\n",
       "      <td>19.4</td>\n",
       "      <td>13.2</td>\n",
       "      <td>6.8</td>\n",
       "      <td>12.1</td>\n",
       "      <td>14.51</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>11</td>\n",
       "      <td>14.900000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1147</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Île-de-France</td>\n",
       "      <td>11</td>\n",
       "      <td>3218503.0</td>\n",
       "      <td>P0: Total &lt;= 36 kVA</td>\n",
       "      <td>12892</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES3</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>21.2</td>\n",
       "      <td>19.4</td>\n",
       "      <td>13.2</td>\n",
       "      <td>6.8</td>\n",
       "      <td>12.1</td>\n",
       "      <td>14.51</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>11</td>\n",
       "      <td>14.900000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1148</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Normandie</td>\n",
       "      <td>28</td>\n",
       "      <td>95048.0</td>\n",
       "      <td>P1: ]0-9] kVA</td>\n",
       "      <td>508</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES4</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>17.7</td>\n",
       "      <td>19.9</td>\n",
       "      <td>17.8</td>\n",
       "      <td>9.9</td>\n",
       "      <td>13.2</td>\n",
       "      <td>13.02</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>28</td>\n",
       "      <td>13.400000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1149</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Nouvelle Aquitaine</td>\n",
       "      <td>75</td>\n",
       "      <td>71853022.0</td>\n",
       "      <td>P2: ]3-6] kVA</td>\n",
       "      <td>995854</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES1 (+ RES1WE)</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>17.4</td>\n",
       "      <td>20.3</td>\n",
       "      <td>19.0</td>\n",
       "      <td>11.4</td>\n",
       "      <td>12.6</td>\n",
       "      <td>16.66</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>75</td>\n",
       "      <td>15.020000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1150</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Nouvelle Aquitaine</td>\n",
       "      <td>75</td>\n",
       "      <td>41343258.0</td>\n",
       "      <td>P0: Total &lt;= 36 kVA</td>\n",
       "      <td>328078</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES11 (+ RES11WE)</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>17.4</td>\n",
       "      <td>20.3</td>\n",
       "      <td>19.0</td>\n",
       "      <td>11.4</td>\n",
       "      <td>12.6</td>\n",
       "      <td>16.66</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>75</td>\n",
       "      <td>15.020000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1151</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Nouvelle Aquitaine</td>\n",
       "      <td>75</td>\n",
       "      <td>7785663.0</td>\n",
       "      <td>P5: ]12-15] kVA</td>\n",
       "      <td>34640</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES2 (+ RES5)</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>17.4</td>\n",
       "      <td>20.3</td>\n",
       "      <td>19.0</td>\n",
       "      <td>11.4</td>\n",
       "      <td>12.6</td>\n",
       "      <td>16.66</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>75</td>\n",
       "      <td>15.020000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1152</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Nouvelle Aquitaine</td>\n",
       "      <td>75</td>\n",
       "      <td>6364190.0</td>\n",
       "      <td>P0: Total &lt;= 36 kVA</td>\n",
       "      <td>29147</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES3</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>17.4</td>\n",
       "      <td>20.3</td>\n",
       "      <td>19.0</td>\n",
       "      <td>11.4</td>\n",
       "      <td>12.6</td>\n",
       "      <td>16.66</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>75</td>\n",
       "      <td>15.020000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1153</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Nouvelle Aquitaine</td>\n",
       "      <td>75</td>\n",
       "      <td>3152510.0</td>\n",
       "      <td>P1: ]0-9] kVA</td>\n",
       "      <td>16491</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES3</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>17.4</td>\n",
       "      <td>20.3</td>\n",
       "      <td>19.0</td>\n",
       "      <td>11.4</td>\n",
       "      <td>12.6</td>\n",
       "      <td>16.66</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>75</td>\n",
       "      <td>15.020000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1154</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Île-de-France</td>\n",
       "      <td>11</td>\n",
       "      <td>836639.0</td>\n",
       "      <td>P9: ]30-36] kVA</td>\n",
       "      <td>1746</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES11 (+ RES11WE)</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>21.2</td>\n",
       "      <td>19.4</td>\n",
       "      <td>13.2</td>\n",
       "      <td>6.8</td>\n",
       "      <td>12.1</td>\n",
       "      <td>14.51</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>11</td>\n",
       "      <td>14.900000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1155</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Île-de-France</td>\n",
       "      <td>11</td>\n",
       "      <td>648180.0</td>\n",
       "      <td>P8: ]24-30] kVA</td>\n",
       "      <td>1489</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES2 (+ RES5)</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>21.2</td>\n",
       "      <td>19.4</td>\n",
       "      <td>13.2</td>\n",
       "      <td>6.8</td>\n",
       "      <td>12.1</td>\n",
       "      <td>14.51</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>11</td>\n",
       "      <td>14.900000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1156</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Occitanie</td>\n",
       "      <td>76</td>\n",
       "      <td>8896150.0</td>\n",
       "      <td>P6: ]15-18] kVA</td>\n",
       "      <td>34797</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES2 (+ RES5)</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>17.7</td>\n",
       "      <td>20.0</td>\n",
       "      <td>18.1</td>\n",
       "      <td>10.7</td>\n",
       "      <td>14.5</td>\n",
       "      <td>17.74</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>76</td>\n",
       "      <td>16.414286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1157</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Pays de la Loire</td>\n",
       "      <td>52</td>\n",
       "      <td>5306677.0</td>\n",
       "      <td>P6: ]15-18] kVA</td>\n",
       "      <td>20041</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES2 (+ RES5)</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>18.4</td>\n",
       "      <td>19.5</td>\n",
       "      <td>16.8</td>\n",
       "      <td>9.7</td>\n",
       "      <td>11.2</td>\n",
       "      <td>15.48</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>52</td>\n",
       "      <td>12.600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1158</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Provence-Alpes-Côte d'Azur</td>\n",
       "      <td>93</td>\n",
       "      <td>382428.0</td>\n",
       "      <td>P9: ]30-36] kVA</td>\n",
       "      <td>631</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES3</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>17.9</td>\n",
       "      <td>20.1</td>\n",
       "      <td>18.0</td>\n",
       "      <td>11.1</td>\n",
       "      <td>14.0</td>\n",
       "      <td>17.02</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>93</td>\n",
       "      <td>17.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1159</th>\n",
       "      <td>2020-06-04T02:00:00+00:00</td>\n",
       "      <td>Pays de la Loire</td>\n",
       "      <td>52</td>\n",
       "      <td>251626.0</td>\n",
       "      <td>P5: ]12-15] kVA</td>\n",
       "      <td>964</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RES4</td>\n",
       "      <td>RES</td>\n",
       "      <td>...</td>\n",
       "      <td>18.4</td>\n",
       "      <td>19.5</td>\n",
       "      <td>16.8</td>\n",
       "      <td>9.7</td>\n",
       "      <td>11.2</td>\n",
       "      <td>15.48</td>\n",
       "      <td>2020-06-04T02:00:00</td>\n",
       "      <td>2020-06-04T02:00:00+02:00</td>\n",
       "      <td>52</td>\n",
       "      <td>12.600000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>50 rows × 39 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                       horodate                    region_x code_region  \\\n",
       "1110  2020-06-04T02:00:00+00:00                    Bretagne          53   \n",
       "1111  2020-06-04T02:00:00+00:00                    Bretagne          53   \n",
       "1112  2020-06-04T02:00:00+00:00                    Bretagne          53   \n",
       "1113  2020-06-04T02:00:00+00:00         Centre-Val de Loire          24   \n",
       "1114  2020-06-04T02:00:00+00:00         Centre-Val de Loire          24   \n",
       "1115  2020-06-04T02:00:00+00:00                   Grand-Est          44   \n",
       "1116  2020-06-04T02:00:00+00:00             Hauts-de-France          32   \n",
       "1117  2020-06-04T02:00:00+00:00             Hauts-de-France          32   \n",
       "1118  2020-06-04T02:00:00+00:00                   Grand-Est          44   \n",
       "1119  2020-06-04T02:00:00+00:00         Centre-Val de Loire          24   \n",
       "1120  2020-06-04T02:00:00+00:00        Auvergne-Rhône-Alpes          84   \n",
       "1121  2020-06-04T02:00:00+00:00               Île-de-France          11   \n",
       "1122  2020-06-04T02:00:00+00:00               Île-de-France          11   \n",
       "1123  2020-06-04T02:00:00+00:00               Île-de-France          11   \n",
       "1124  2020-06-04T02:00:00+00:00                   Normandie          28   \n",
       "1125  2020-06-04T02:00:00+00:00          Nouvelle Aquitaine          75   \n",
       "1126  2020-06-04T02:00:00+00:00          Nouvelle Aquitaine          75   \n",
       "1127  2020-06-04T02:00:00+00:00                   Normandie          28   \n",
       "1128  2020-06-04T02:00:00+00:00            Pays de la Loire          52   \n",
       "1129  2020-06-04T02:00:00+00:00            Pays de la Loire          52   \n",
       "1130  2020-06-04T02:00:00+00:00            Pays de la Loire          52   \n",
       "1131  2020-06-04T02:00:00+00:00            Pays de la Loire          52   \n",
       "1132  2020-06-04T02:00:00+00:00            Pays de la Loire          52   \n",
       "1133  2020-06-04T02:00:00+00:00                   Occitanie          76   \n",
       "1134  2020-06-04T02:00:00+00:00  Provence-Alpes-Côte d'Azur          93   \n",
       "1135  2020-06-04T02:00:00+00:00             Hauts-de-France          32   \n",
       "1136  2020-06-04T02:00:00+00:00        Auvergne-Rhône-Alpes          84   \n",
       "1137  2020-06-04T02:00:00+00:00                   Grand-Est          44   \n",
       "1138  2020-06-04T02:00:00+00:00     Bourgogne-Franche-Comté          27   \n",
       "1139  2020-06-04T02:00:00+00:00     Bourgogne-Franche-Comté          27   \n",
       "1140  2020-06-04T02:00:00+00:00         Centre-Val de Loire          24   \n",
       "1141  2020-06-04T02:00:00+00:00                   Grand-Est          44   \n",
       "1142  2020-06-04T02:00:00+00:00                   Grand-Est          44   \n",
       "1143  2020-06-04T02:00:00+00:00             Hauts-de-France          32   \n",
       "1144  2020-06-04T02:00:00+00:00             Hauts-de-France          32   \n",
       "1145  2020-06-04T02:00:00+00:00             Hauts-de-France          32   \n",
       "1146  2020-06-04T02:00:00+00:00               Île-de-France          11   \n",
       "1147  2020-06-04T02:00:00+00:00               Île-de-France          11   \n",
       "1148  2020-06-04T02:00:00+00:00                   Normandie          28   \n",
       "1149  2020-06-04T02:00:00+00:00          Nouvelle Aquitaine          75   \n",
       "1150  2020-06-04T02:00:00+00:00          Nouvelle Aquitaine          75   \n",
       "1151  2020-06-04T02:00:00+00:00          Nouvelle Aquitaine          75   \n",
       "1152  2020-06-04T02:00:00+00:00          Nouvelle Aquitaine          75   \n",
       "1153  2020-06-04T02:00:00+00:00          Nouvelle Aquitaine          75   \n",
       "1154  2020-06-04T02:00:00+00:00               Île-de-France          11   \n",
       "1155  2020-06-04T02:00:00+00:00               Île-de-France          11   \n",
       "1156  2020-06-04T02:00:00+00:00                   Occitanie          76   \n",
       "1157  2020-06-04T02:00:00+00:00            Pays de la Loire          52   \n",
       "1158  2020-06-04T02:00:00+00:00  Provence-Alpes-Côte d'Azur          93   \n",
       "1159  2020-06-04T02:00:00+00:00            Pays de la Loire          52   \n",
       "\n",
       "      total_energie_soutiree_wh plage_de_puissance_souscrite  \\\n",
       "1110                   266081.0              P9: ]30-36] kVA   \n",
       "1111                   776483.0              P7: ]18-24] kVA   \n",
       "1112                   302715.0              P8: ]24-30] kVA   \n",
       "1113                   853235.0              P5: ]12-15] kVA   \n",
       "1114                   489877.0              P5: ]12-15] kVA   \n",
       "1115                  1096505.0              P9: ]30-36] kVA   \n",
       "1116                 90834160.0          P0: Total <= 36 kVA   \n",
       "1117                   391487.0               P4: ]9-12] kVA   \n",
       "1118                   431878.0              P7: ]18-24] kVA   \n",
       "1119                 43173333.0                P3: ]6-9] kVA   \n",
       "1120                  1664940.0              P6: ]15-18] kVA   \n",
       "1121                 81861728.0                P1: ]0-6] kVA   \n",
       "1122                 49033027.0               P4: ]9-12] kVA   \n",
       "1123                  3908376.0          P0: Total <= 36 kVA   \n",
       "1124                  2361096.0              P6: ]15-18] kVA   \n",
       "1125                 10631790.0               P4: ]9-12] kVA   \n",
       "1126                   513252.0              P7: ]18-24] kVA   \n",
       "1127                  2095910.0              P6: ]15-18] kVA   \n",
       "1128                   324194.0              P9: ]30-36] kVA   \n",
       "1129                 32554925.0               P4: ]9-12] kVA   \n",
       "1130                   275792.0              P8: ]24-30] kVA   \n",
       "1131                   471675.0              P9: ]30-36] kVA   \n",
       "1132                  2634494.0          P0: Total <= 36 kVA   \n",
       "1133                   455401.0              P7: ]18-24] kVA   \n",
       "1134                 12281876.0          P0: Total <= 36 kVA   \n",
       "1135                   764259.0               P4: ]9-12] kVA   \n",
       "1136                   235895.0              P7: ]18-30] kVA   \n",
       "1137                 50629249.0                P1: ]0-6] kVA   \n",
       "1138                 20737277.0               P4: ]9-12] kVA   \n",
       "1139                  3132694.0              P6: ]15-18] kVA   \n",
       "1140                 24110907.0                P1: ]0-6] kVA   \n",
       "1141                   561739.0               P4: ]9-12] kVA   \n",
       "1142                  4815545.0              P6: ]15-18] kVA   \n",
       "1143                   574648.0              P9: ]30-36] kVA   \n",
       "1144                  5118712.0              P5: ]12-15] kVA   \n",
       "1145                   809933.0              P6: ]15-18] kVA   \n",
       "1146                  8138884.0              P5: ]12-15] kVA   \n",
       "1147                  3218503.0          P0: Total <= 36 kVA   \n",
       "1148                    95048.0                P1: ]0-9] kVA   \n",
       "1149                 71853022.0                P2: ]3-6] kVA   \n",
       "1150                 41343258.0          P0: Total <= 36 kVA   \n",
       "1151                  7785663.0              P5: ]12-15] kVA   \n",
       "1152                  6364190.0          P0: Total <= 36 kVA   \n",
       "1153                  3152510.0                P1: ]0-9] kVA   \n",
       "1154                   836639.0              P9: ]30-36] kVA   \n",
       "1155                   648180.0              P8: ]24-30] kVA   \n",
       "1156                  8896150.0              P6: ]15-18] kVA   \n",
       "1157                  5306677.0              P6: ]15-18] kVA   \n",
       "1158                   382428.0              P9: ]30-36] kVA   \n",
       "1159                   251626.0              P5: ]12-15] kVA   \n",
       "\n",
       "      nb_points_soutirage  jour_max_du_mois_0_1  semaine_max_du_mois_0_1  \\\n",
       "1110                  626                     0                        0   \n",
       "1111                 1998                     0                        0   \n",
       "1112                  652                     0                        0   \n",
       "1113                 4498                     0                        0   \n",
       "1114                 1974                     0                        0   \n",
       "1115                 1991                     0                        0   \n",
       "1116              1204025                     0                        0   \n",
       "1117                 1732                     0                        0   \n",
       "1118                 1097                     0                        0   \n",
       "1119               233830                     0                        0   \n",
       "1120                 6451                     0                        0   \n",
       "1121               803718                     0                        0   \n",
       "1122               222124                     0                        0   \n",
       "1123                29220                     0                        0   \n",
       "1124                 7983                     0                        0   \n",
       "1125                69305                     0                        0   \n",
       "1126                 1444                     0                        0   \n",
       "1127                 1988                     0                        0   \n",
       "1128                  644                     0                        0   \n",
       "1129               155670                     0                        0   \n",
       "1130                  627                     0                        0   \n",
       "1131                  972                     0                        0   \n",
       "1132                11855                     0                        0   \n",
       "1133                 1302                     0                        0   \n",
       "1134                37061                     0                        0   \n",
       "1135                 3186                     0                        0   \n",
       "1136                  547                     0                        0   \n",
       "1137               395843                     0                        0   \n",
       "1138                96358                     0                        0   \n",
       "1139                11845                     0                        0   \n",
       "1140               201818                     0                        0   \n",
       "1141                 2208                     0                        0   \n",
       "1142                17768                     0                        0   \n",
       "1143                 1196                     0                        0   \n",
       "1144                22631                     0                        0   \n",
       "1145                 2854                     0                        0   \n",
       "1146                33089                     0                        0   \n",
       "1147                12892                     0                        0   \n",
       "1148                  508                     0                        0   \n",
       "1149               995854                     0                        0   \n",
       "1150               328078                     0                        0   \n",
       "1151                34640                     0                        0   \n",
       "1152                29147                     0                        0   \n",
       "1153                16491                     0                        0   \n",
       "1154                 1746                     0                        0   \n",
       "1155                 1489                     0                        0   \n",
       "1156                34797                     0                        0   \n",
       "1157                20041                     0                        0   \n",
       "1158                  631                     0                        0   \n",
       "1159                  964                     0                        0   \n",
       "\n",
       "                 profil profil_type  ... Part des 30-44 ans 2018  \\\n",
       "1110  RES11 (+ RES11WE)         RES  ...                    17.6   \n",
       "1111      RES2 (+ RES5)         RES  ...                    17.6   \n",
       "1112      RES2 (+ RES5)         RES  ...                    17.6   \n",
       "1113  RES11 (+ RES11WE)         RES  ...                    17.5   \n",
       "1114               RES4         RES  ...                    17.5   \n",
       "1115  RES11 (+ RES11WE)         RES  ...                    18.3   \n",
       "1116    RES1 (+ RES1WE)         RES  ...                    18.8   \n",
       "1117             RES2WE         RES  ...                    18.8   \n",
       "1118  RES11 (+ RES11WE)         RES  ...                    18.3   \n",
       "1119      RES2 (+ RES5)         RES  ...                    17.5   \n",
       "1120               RES3         RES  ...                    18.8   \n",
       "1121      RES2 (+ RES5)         RES  ...                    21.2   \n",
       "1122      RES2 (+ RES5)         RES  ...                    21.2   \n",
       "1123             RES2WE         RES  ...                    21.2   \n",
       "1124               RES4         RES  ...                    17.7   \n",
       "1125  RES11 (+ RES11WE)         RES  ...                    17.4   \n",
       "1126  RES11 (+ RES11WE)         RES  ...                    17.4   \n",
       "1127               RES3         RES  ...                    17.7   \n",
       "1128  RES11 (+ RES11WE)         RES  ...                    18.4   \n",
       "1129      RES2 (+ RES5)         RES  ...                    18.4   \n",
       "1130      RES2 (+ RES5)         RES  ...                    18.4   \n",
       "1131      RES2 (+ RES5)         RES  ...                    18.4   \n",
       "1132               RES3         RES  ...                    18.4   \n",
       "1133  RES11 (+ RES11WE)         RES  ...                    17.7   \n",
       "1134               RES4         RES  ...                    17.9   \n",
       "1135               RES3         RES  ...                    18.8   \n",
       "1136               RES3         RES  ...                    18.8   \n",
       "1137      RES2 (+ RES5)         RES  ...                    18.3   \n",
       "1138      RES2 (+ RES5)         RES  ...                    17.3   \n",
       "1139               RES4         RES  ...                    17.3   \n",
       "1140      RES2 (+ RES5)         RES  ...                    17.5   \n",
       "1141               RES3         RES  ...                    18.3   \n",
       "1142               RES4         RES  ...                    18.3   \n",
       "1143  RES11 (+ RES11WE)         RES  ...                    18.8   \n",
       "1144      RES2 (+ RES5)         RES  ...                    18.8   \n",
       "1145               RES3         RES  ...                    18.8   \n",
       "1146      RES2 (+ RES5)         RES  ...                    21.2   \n",
       "1147               RES3         RES  ...                    21.2   \n",
       "1148               RES4         RES  ...                    17.7   \n",
       "1149    RES1 (+ RES1WE)         RES  ...                    17.4   \n",
       "1150  RES11 (+ RES11WE)         RES  ...                    17.4   \n",
       "1151      RES2 (+ RES5)         RES  ...                    17.4   \n",
       "1152               RES3         RES  ...                    17.4   \n",
       "1153               RES3         RES  ...                    17.4   \n",
       "1154  RES11 (+ RES11WE)         RES  ...                    21.2   \n",
       "1155      RES2 (+ RES5)         RES  ...                    21.2   \n",
       "1156      RES2 (+ RES5)         RES  ...                    17.7   \n",
       "1157      RES2 (+ RES5)         RES  ...                    18.4   \n",
       "1158               RES3         RES  ...                    17.9   \n",
       "1159               RES4         RES  ...                    18.4   \n",
       "\n",
       "      Part des 45-59 ans 2018 Part des 60-74 ans 2018  \\\n",
       "1110                     20.1                    18.1   \n",
       "1111                     20.1                    18.1   \n",
       "1112                     20.1                    18.1   \n",
       "1113                     20.1                    18.1   \n",
       "1114                     20.1                    18.1   \n",
       "1115                     20.6                    17.1   \n",
       "1116                     19.5                    15.9   \n",
       "1117                     19.5                    15.9   \n",
       "1118                     20.6                    17.1   \n",
       "1119                     20.1                    18.1   \n",
       "1120                     19.8                    16.2   \n",
       "1121                     19.4                    13.2   \n",
       "1122                     19.4                    13.2   \n",
       "1123                     19.4                    13.2   \n",
       "1124                     19.9                    17.8   \n",
       "1125                     20.3                    19.0   \n",
       "1126                     20.3                    19.0   \n",
       "1127                     19.9                    17.8   \n",
       "1128                     19.5                    16.8   \n",
       "1129                     19.5                    16.8   \n",
       "1130                     19.5                    16.8   \n",
       "1131                     19.5                    16.8   \n",
       "1132                     19.5                    16.8   \n",
       "1133                     20.0                    18.1   \n",
       "1134                     20.1                    18.0   \n",
       "1135                     19.5                    15.9   \n",
       "1136                     19.8                    16.2   \n",
       "1137                     20.6                    17.1   \n",
       "1138                     20.1                    18.6   \n",
       "1139                     20.1                    18.6   \n",
       "1140                     20.1                    18.1   \n",
       "1141                     20.6                    17.1   \n",
       "1142                     20.6                    17.1   \n",
       "1143                     19.5                    15.9   \n",
       "1144                     19.5                    15.9   \n",
       "1145                     19.5                    15.9   \n",
       "1146                     19.4                    13.2   \n",
       "1147                     19.4                    13.2   \n",
       "1148                     19.9                    17.8   \n",
       "1149                     20.3                    19.0   \n",
       "1150                     20.3                    19.0   \n",
       "1151                     20.3                    19.0   \n",
       "1152                     20.3                    19.0   \n",
       "1153                     20.3                    19.0   \n",
       "1154                     19.4                    13.2   \n",
       "1155                     19.4                    13.2   \n",
       "1156                     20.0                    18.1   \n",
       "1157                     19.5                    16.8   \n",
       "1158                     20.1                    18.0   \n",
       "1159                     19.5                    16.8   \n",
       "\n",
       "      Part des 75 ans et plus 2018  \\\n",
       "1110                          10.5   \n",
       "1111                          10.5   \n",
       "1112                          10.5   \n",
       "1113                          10.7   \n",
       "1114                          10.7   \n",
       "1115                           9.3   \n",
       "1116                           7.9   \n",
       "1117                           7.9   \n",
       "1118                           9.3   \n",
       "1119                          10.7   \n",
       "1120                           9.4   \n",
       "1121                           6.8   \n",
       "1122                           6.8   \n",
       "1123                           6.8   \n",
       "1124                           9.9   \n",
       "1125                          11.4   \n",
       "1126                          11.4   \n",
       "1127                           9.9   \n",
       "1128                           9.7   \n",
       "1129                           9.7   \n",
       "1130                           9.7   \n",
       "1131                           9.7   \n",
       "1132                           9.7   \n",
       "1133                          10.7   \n",
       "1134                          11.1   \n",
       "1135                           7.9   \n",
       "1136                           9.4   \n",
       "1137                           9.3   \n",
       "1138                          10.9   \n",
       "1139                          10.9   \n",
       "1140                          10.7   \n",
       "1141                           9.3   \n",
       "1142                           9.3   \n",
       "1143                           7.9   \n",
       "1144                           7.9   \n",
       "1145                           7.9   \n",
       "1146                           6.8   \n",
       "1147                           6.8   \n",
       "1148                           9.9   \n",
       "1149                          11.4   \n",
       "1150                          11.4   \n",
       "1151                          11.4   \n",
       "1152                          11.4   \n",
       "1153                          11.4   \n",
       "1154                           6.8   \n",
       "1155                           6.8   \n",
       "1156                          10.7   \n",
       "1157                           9.7   \n",
       "1158                          11.1   \n",
       "1159                           9.7   \n",
       "\n",
       "      Taux de chômage des 15 ans et plus (RP) 2018   tmoy  \\\n",
       "1110                                          11.4  14.26   \n",
       "1111                                          11.4  14.26   \n",
       "1112                                          11.4  14.26   \n",
       "1113                                          12.5  15.43   \n",
       "1114                                          12.5  15.43   \n",
       "1115                                          13.3  15.82   \n",
       "1116                                          16.3  13.66   \n",
       "1117                                          16.3  13.66   \n",
       "1118                                          13.3  15.82   \n",
       "1119                                          12.5  15.43   \n",
       "1120                                          11.4  16.48   \n",
       "1121                                          12.1  14.51   \n",
       "1122                                          12.1  14.51   \n",
       "1123                                          12.1  14.51   \n",
       "1124                                          13.2  13.02   \n",
       "1125                                          12.6  16.66   \n",
       "1126                                          12.6  16.66   \n",
       "1127                                          13.2  13.02   \n",
       "1128                                          11.2  15.48   \n",
       "1129                                          11.2  15.48   \n",
       "1130                                          11.2  15.48   \n",
       "1131                                          11.2  15.48   \n",
       "1132                                          11.2  15.48   \n",
       "1133                                          14.5  17.74   \n",
       "1134                                          14.0  17.02   \n",
       "1135                                          16.3  13.66   \n",
       "1136                                          11.4  16.48   \n",
       "1137                                          13.3  15.82   \n",
       "1138                                          12.0  17.17   \n",
       "1139                                          12.0  17.17   \n",
       "1140                                          12.5  15.43   \n",
       "1141                                          13.3  15.82   \n",
       "1142                                          13.3  15.82   \n",
       "1143                                          16.3  13.66   \n",
       "1144                                          16.3  13.66   \n",
       "1145                                          16.3  13.66   \n",
       "1146                                          12.1  14.51   \n",
       "1147                                          12.1  14.51   \n",
       "1148                                          13.2  13.02   \n",
       "1149                                          12.6  16.66   \n",
       "1150                                          12.6  16.66   \n",
       "1151                                          12.6  16.66   \n",
       "1152                                          12.6  16.66   \n",
       "1153                                          12.6  16.66   \n",
       "1154                                          12.1  14.51   \n",
       "1155                                          12.1  14.51   \n",
       "1156                                          14.5  17.74   \n",
       "1157                                          11.2  15.48   \n",
       "1158                                          14.0  17.02   \n",
       "1159                                          11.2  15.48   \n",
       "\n",
       "                 date_cut                       Date  region (code)  \\\n",
       "1110  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             53   \n",
       "1111  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             53   \n",
       "1112  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             53   \n",
       "1113  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             24   \n",
       "1114  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             24   \n",
       "1115  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             44   \n",
       "1116  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             32   \n",
       "1117  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             32   \n",
       "1118  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             44   \n",
       "1119  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             24   \n",
       "1120  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             84   \n",
       "1121  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             11   \n",
       "1122  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             11   \n",
       "1123  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             11   \n",
       "1124  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             28   \n",
       "1125  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             75   \n",
       "1126  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             75   \n",
       "1127  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             28   \n",
       "1128  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             52   \n",
       "1129  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             52   \n",
       "1130  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             52   \n",
       "1131  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             52   \n",
       "1132  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             52   \n",
       "1133  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             76   \n",
       "1134  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             93   \n",
       "1135  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             32   \n",
       "1136  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             84   \n",
       "1137  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             44   \n",
       "1138  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             27   \n",
       "1139  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             27   \n",
       "1140  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             24   \n",
       "1141  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             44   \n",
       "1142  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             44   \n",
       "1143  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             32   \n",
       "1144  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             32   \n",
       "1145  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             32   \n",
       "1146  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             11   \n",
       "1147  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             11   \n",
       "1148  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             28   \n",
       "1149  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             75   \n",
       "1150  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             75   \n",
       "1151  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             75   \n",
       "1152  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             75   \n",
       "1153  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             75   \n",
       "1154  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             11   \n",
       "1155  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             11   \n",
       "1156  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             76   \n",
       "1157  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             52   \n",
       "1158  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             93   \n",
       "1159  2020-06-04T02:00:00  2020-06-04T02:00:00+02:00             52   \n",
       "\n",
       "      Température (°C)  \n",
       "1110         13.600000  \n",
       "1111         13.600000  \n",
       "1112         13.600000  \n",
       "1113         14.850000  \n",
       "1114         14.850000  \n",
       "1115         15.380000  \n",
       "1116         12.850000  \n",
       "1117         12.850000  \n",
       "1118         15.380000  \n",
       "1119         14.850000  \n",
       "1120         14.925000  \n",
       "1121         14.900000  \n",
       "1122         14.900000  \n",
       "1123         14.900000  \n",
       "1124         13.400000  \n",
       "1125         15.020000  \n",
       "1126         15.020000  \n",
       "1127         13.400000  \n",
       "1128         12.600000  \n",
       "1129         12.600000  \n",
       "1130         12.600000  \n",
       "1131         12.600000  \n",
       "1132         12.600000  \n",
       "1133         16.414286  \n",
       "1134         17.333333  \n",
       "1135         12.850000  \n",
       "1136         14.925000  \n",
       "1137         15.380000  \n",
       "1138         15.100000  \n",
       "1139         15.100000  \n",
       "1140         14.850000  \n",
       "1141         15.380000  \n",
       "1142         15.380000  \n",
       "1143         12.850000  \n",
       "1144         12.850000  \n",
       "1145         12.850000  \n",
       "1146         14.900000  \n",
       "1147         14.900000  \n",
       "1148         13.400000  \n",
       "1149         15.020000  \n",
       "1150         15.020000  \n",
       "1151         15.020000  \n",
       "1152         15.020000  \n",
       "1153         15.020000  \n",
       "1154         14.900000  \n",
       "1155         14.900000  \n",
       "1156         16.414286  \n",
       "1157         12.600000  \n",
       "1158         17.333333  \n",
       "1159         12.600000  \n",
       "\n",
       "[50 rows x 39 columns]"
      ]
     },
     "execution_count": 108,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "enedis_final_3h.head(50)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 109,
   "metadata": {},
   "outputs": [],
   "source": [
    "enedis_final_3h.to_csv(\"Données/enedis_final_3h.csv\",index=False)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "base",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.8"
  },
  "orig_nbformat": 4,
  "vscode": {
   "interpreter": {
    "hash": "785e3c9f83d912aef9fa5659340428c82ffe0739e0f19f8b623e957eac01574f"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}