{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Concat & transform RTE data  \n",
    "\n",
    "Ce notebook concat et transforme les données RAW RTE"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "from energy_forecast.energy import ECO2MixDownloader"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Fetching data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022, 2023, 2024]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list_years = list(range(2014, 2025))\n",
    "list_years"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "list_of_dataframes = []\n",
    "for year in list_years:\n",
    "    downloader = ECO2MixDownloader(year)\n",
    "    downloader.download()\n",
    "    df = downloader.read_file()\n",
    "    list_of_dataframes.append(df)\n",
    "df = pd.concat(list_of_dataframes)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Périmètre</th>\n",
       "      <th>Nature</th>\n",
       "      <th>Date</th>\n",
       "      <th>Heures</th>\n",
       "      <th>Consommation</th>\n",
       "      <th>Prévision J-1</th>\n",
       "      <th>Prévision J</th>\n",
       "      <th>Fioul</th>\n",
       "      <th>Charbon</th>\n",
       "      <th>Gaz</th>\n",
       "      <th>...</th>\n",
       "      <th>Gaz - TAC</th>\n",
       "      <th>Gaz - Cogén.</th>\n",
       "      <th>Gaz - CCG</th>\n",
       "      <th>Gaz - Autres</th>\n",
       "      <th>Hydraulique - Fil de l?eau + éclusée</th>\n",
       "      <th>Hydraulique - Lacs</th>\n",
       "      <th>Hydraulique - STEP turbinage</th>\n",
       "      <th>Bioénergies - Déchets</th>\n",
       "      <th>Bioénergies - Biomasse</th>\n",
       "      <th>Bioénergies - Biogaz</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>time</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2014-01-01 00:00:00</th>\n",
       "      <td>France</td>\n",
       "      <td>Données définitives</td>\n",
       "      <td>2014-01-01</td>\n",
       "      <td>0 days 00:00:00</td>\n",
       "      <td>64660.0</td>\n",
       "      <td>63200.0</td>\n",
       "      <td>63200.0</td>\n",
       "      <td>454.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2303.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1809.0</td>\n",
       "      <td>422.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>5662.0</td>\n",
       "      <td>2125.0</td>\n",
       "      <td>693.0</td>\n",
       "      <td>460.0</td>\n",
       "      <td>165.0</td>\n",
       "      <td>179.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-01-01 01:00:00</th>\n",
       "      <td>France</td>\n",
       "      <td>Données définitives</td>\n",
       "      <td>2014-01-01</td>\n",
       "      <td>0 days 01:00:00</td>\n",
       "      <td>61362.0</td>\n",
       "      <td>59900.0</td>\n",
       "      <td>59900.0</td>\n",
       "      <td>281.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2188.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1848.0</td>\n",
       "      <td>258.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>5457.0</td>\n",
       "      <td>2040.0</td>\n",
       "      <td>76.0</td>\n",
       "      <td>591.0</td>\n",
       "      <td>173.0</td>\n",
       "      <td>181.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-01-01 02:00:00</th>\n",
       "      <td>France</td>\n",
       "      <td>Données définitives</td>\n",
       "      <td>2014-01-01</td>\n",
       "      <td>0 days 02:00:00</td>\n",
       "      <td>60748.0</td>\n",
       "      <td>59900.0</td>\n",
       "      <td>60200.0</td>\n",
       "      <td>281.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2187.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1853.0</td>\n",
       "      <td>252.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>5201.0</td>\n",
       "      <td>1592.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>597.0</td>\n",
       "      <td>174.0</td>\n",
       "      <td>180.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-01-01 03:00:00</th>\n",
       "      <td>France</td>\n",
       "      <td>Données définitives</td>\n",
       "      <td>2014-01-01</td>\n",
       "      <td>0 days 03:00:00</td>\n",
       "      <td>58061.0</td>\n",
       "      <td>56500.0</td>\n",
       "      <td>56600.0</td>\n",
       "      <td>281.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2179.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1844.0</td>\n",
       "      <td>253.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>4947.0</td>\n",
       "      <td>1200.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>594.0</td>\n",
       "      <td>174.0</td>\n",
       "      <td>179.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-01-01 04:00:00</th>\n",
       "      <td>France</td>\n",
       "      <td>Données définitives</td>\n",
       "      <td>2014-01-01</td>\n",
       "      <td>0 days 04:00:00</td>\n",
       "      <td>54475.0</td>\n",
       "      <td>53200.0</td>\n",
       "      <td>53300.0</td>\n",
       "      <td>280.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2185.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1844.0</td>\n",
       "      <td>260.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>4662.0</td>\n",
       "      <td>1252.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>591.0</td>\n",
       "      <td>171.0</td>\n",
       "      <td>177.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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <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>2024-06-23 05:00:00</th>\n",
       "      <td>France</td>\n",
       "      <td>Données temps réel</td>\n",
       "      <td>2024-06-23</td>\n",
       "      <td>0 days 05:00:00</td>\n",
       "      <td>30263.0</td>\n",
       "      <td>30000</td>\n",
       "      <td>30400.0</td>\n",
       "      <td>123.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>434.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>321</td>\n",
       "      <td>114.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5353</td>\n",
       "      <td>1716</td>\n",
       "      <td>551.0</td>\n",
       "      <td>196</td>\n",
       "      <td>355.0</td>\n",
       "      <td>244.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-06-23 06:00:00</th>\n",
       "      <td>France</td>\n",
       "      <td>Données temps réel</td>\n",
       "      <td>2024-06-23</td>\n",
       "      <td>0 days 06:00:00</td>\n",
       "      <td>30056.0</td>\n",
       "      <td>29400</td>\n",
       "      <td>30000.0</td>\n",
       "      <td>124.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>433.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>321</td>\n",
       "      <td>114.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5251</td>\n",
       "      <td>1838</td>\n",
       "      <td>589.0</td>\n",
       "      <td>193</td>\n",
       "      <td>352.0</td>\n",
       "      <td>244.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-06-23 07:00:00</th>\n",
       "      <td>France</td>\n",
       "      <td>Données temps réel</td>\n",
       "      <td>2024-06-23</td>\n",
       "      <td>0 days 07:00:00</td>\n",
       "      <td>30573.0</td>\n",
       "      <td>30200</td>\n",
       "      <td>30700.0</td>\n",
       "      <td>124.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>322</td>\n",
       "      <td>116.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5242</td>\n",
       "      <td>1907</td>\n",
       "      <td>373.0</td>\n",
       "      <td>189</td>\n",
       "      <td>356.0</td>\n",
       "      <td>244.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-06-23 08:00:00</th>\n",
       "      <td>France</td>\n",
       "      <td>Données temps réel</td>\n",
       "      <td>2024-06-23</td>\n",
       "      <td>0 days 08:00:00</td>\n",
       "      <td>32099.0</td>\n",
       "      <td>31700</td>\n",
       "      <td>32200.0</td>\n",
       "      <td>124.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>434.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>321</td>\n",
       "      <td>115.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5238</td>\n",
       "      <td>1925</td>\n",
       "      <td>372.0</td>\n",
       "      <td>189</td>\n",
       "      <td>352.0</td>\n",
       "      <td>244.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-06-23 09:00:00</th>\n",
       "      <td>France</td>\n",
       "      <td>Données temps réel</td>\n",
       "      <td>2024-06-23</td>\n",
       "      <td>0 days 09:00:00</td>\n",
       "      <td>34821.0</td>\n",
       "      <td>34500</td>\n",
       "      <td>34900.0</td>\n",
       "      <td>124.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>432.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>319</td>\n",
       "      <td>115.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5177</td>\n",
       "      <td>1922</td>\n",
       "      <td>373.0</td>\n",
       "      <td>192</td>\n",
       "      <td>351.0</td>\n",
       "      <td>244.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>91834 rows × 36 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Périmètre               Nature       Date          Heures  \\\n",
       "time                                                                            \n",
       "2014-01-01 00:00:00    France  Données définitives 2014-01-01 0 days 00:00:00   \n",
       "2014-01-01 01:00:00    France  Données définitives 2014-01-01 0 days 01:00:00   \n",
       "2014-01-01 02:00:00    France  Données définitives 2014-01-01 0 days 02:00:00   \n",
       "2014-01-01 03:00:00    France  Données définitives 2014-01-01 0 days 03:00:00   \n",
       "2014-01-01 04:00:00    France  Données définitives 2014-01-01 0 days 04:00:00   \n",
       "...                       ...                  ...        ...             ...   \n",
       "2024-06-23 05:00:00    France   Données temps réel 2024-06-23 0 days 05:00:00   \n",
       "2024-06-23 06:00:00    France   Données temps réel 2024-06-23 0 days 06:00:00   \n",
       "2024-06-23 07:00:00    France   Données temps réel 2024-06-23 0 days 07:00:00   \n",
       "2024-06-23 08:00:00    France   Données temps réel 2024-06-23 0 days 08:00:00   \n",
       "2024-06-23 09:00:00    France   Données temps réel 2024-06-23 0 days 09:00:00   \n",
       "\n",
       "                     Consommation Prévision J-1  Prévision J  Fioul  Charbon  \\\n",
       "time                                                                           \n",
       "2014-01-01 00:00:00       64660.0       63200.0      63200.0  454.0      0.0   \n",
       "2014-01-01 01:00:00       61362.0       59900.0      59900.0  281.0      0.0   \n",
       "2014-01-01 02:00:00       60748.0       59900.0      60200.0  281.0      0.0   \n",
       "2014-01-01 03:00:00       58061.0       56500.0      56600.0  281.0      0.0   \n",
       "2014-01-01 04:00:00       54475.0       53200.0      53300.0  280.0      0.0   \n",
       "...                           ...           ...          ...    ...      ...   \n",
       "2024-06-23 05:00:00       30263.0         30000      30400.0  123.0      0.0   \n",
       "2024-06-23 06:00:00       30056.0         29400      30000.0  124.0      0.0   \n",
       "2024-06-23 07:00:00       30573.0         30200      30700.0  124.0      0.0   \n",
       "2024-06-23 08:00:00       32099.0         31700      32200.0  124.0      0.0   \n",
       "2024-06-23 09:00:00       34821.0         34500      34900.0  124.0      0.0   \n",
       "\n",
       "                        Gaz  ...  Gaz - TAC  Gaz - Cogén.  Gaz - CCG  \\\n",
       "time                         ...                                       \n",
       "2014-01-01 00:00:00  2303.0  ...        0.0        1809.0      422.0   \n",
       "2014-01-01 01:00:00  2188.0  ...        0.0        1848.0      258.0   \n",
       "2014-01-01 02:00:00  2187.0  ...        0.0        1853.0      252.0   \n",
       "2014-01-01 03:00:00  2179.0  ...        0.0        1844.0      253.0   \n",
       "2014-01-01 04:00:00  2185.0  ...        0.0        1844.0      260.0   \n",
       "...                     ...  ...        ...           ...        ...   \n",
       "2024-06-23 05:00:00   434.0  ...          0           321      114.0   \n",
       "2024-06-23 06:00:00   433.0  ...          0           321      114.0   \n",
       "2024-06-23 07:00:00   437.0  ...          0           322      116.0   \n",
       "2024-06-23 08:00:00   434.0  ...          0           321      115.0   \n",
       "2024-06-23 09:00:00   432.0  ...          0           319      115.0   \n",
       "\n",
       "                     Gaz - Autres  Hydraulique - Fil de l?eau + éclusée  \\\n",
       "time                                                                      \n",
       "2014-01-01 00:00:00          72.0                                5662.0   \n",
       "2014-01-01 01:00:00          83.0                                5457.0   \n",
       "2014-01-01 02:00:00          83.0                                5201.0   \n",
       "2014-01-01 03:00:00          83.0                                4947.0   \n",
       "2014-01-01 04:00:00          83.0                                4662.0   \n",
       "...                           ...                                   ...   \n",
       "2024-06-23 05:00:00           0.0                                  5353   \n",
       "2024-06-23 06:00:00           0.0                                  5251   \n",
       "2024-06-23 07:00:00           0.0                                  5242   \n",
       "2024-06-23 08:00:00           0.0                                  5238   \n",
       "2024-06-23 09:00:00           0.0                                  5177   \n",
       "\n",
       "                     Hydraulique - Lacs  Hydraulique - STEP turbinage  \\\n",
       "time                                                                    \n",
       "2014-01-01 00:00:00              2125.0                         693.0   \n",
       "2014-01-01 01:00:00              2040.0                          76.0   \n",
       "2014-01-01 02:00:00              1592.0                           0.0   \n",
       "2014-01-01 03:00:00              1200.0                           0.0   \n",
       "2014-01-01 04:00:00              1252.0                           0.0   \n",
       "...                                 ...                           ...   \n",
       "2024-06-23 05:00:00                1716                         551.0   \n",
       "2024-06-23 06:00:00                1838                         589.0   \n",
       "2024-06-23 07:00:00                1907                         373.0   \n",
       "2024-06-23 08:00:00                1925                         372.0   \n",
       "2024-06-23 09:00:00                1922                         373.0   \n",
       "\n",
       "                     Bioénergies - Déchets Bioénergies - Biomasse  \\\n",
       "time                                                                \n",
       "2014-01-01 00:00:00                  460.0                  165.0   \n",
       "2014-01-01 01:00:00                  591.0                  173.0   \n",
       "2014-01-01 02:00:00                  597.0                  174.0   \n",
       "2014-01-01 03:00:00                  594.0                  174.0   \n",
       "2014-01-01 04:00:00                  591.0                  171.0   \n",
       "...                                    ...                    ...   \n",
       "2024-06-23 05:00:00                    196                  355.0   \n",
       "2024-06-23 06:00:00                    193                  352.0   \n",
       "2024-06-23 07:00:00                    189                  356.0   \n",
       "2024-06-23 08:00:00                    189                  352.0   \n",
       "2024-06-23 09:00:00                    192                  351.0   \n",
       "\n",
       "                    Bioénergies - Biogaz  \n",
       "time                                      \n",
       "2014-01-01 00:00:00                179.0  \n",
       "2014-01-01 01:00:00                181.0  \n",
       "2014-01-01 02:00:00                180.0  \n",
       "2014-01-01 03:00:00                179.0  \n",
       "2014-01-01 04:00:00                177.0  \n",
       "...                                  ...  \n",
       "2024-06-23 05:00:00                244.0  \n",
       "2024-06-23 06:00:00                244.0  \n",
       "2024-06-23 07:00:00                244.0  \n",
       "2024-06-23 08:00:00                244.0  \n",
       "2024-06-23 09:00:00                244.0  \n",
       "\n",
       "[91834 rows x 36 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Only keep hourly data\n",
    "df = df[df.index.minute == 0]\n",
    "df = df.dropna()\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "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>Périmètre</th>\n",
       "      <th>Nature</th>\n",
       "      <th>Date</th>\n",
       "      <th>Heures</th>\n",
       "      <th>Consommation</th>\n",
       "      <th>Prévision J-1</th>\n",
       "      <th>Prévision J</th>\n",
       "      <th>Fioul</th>\n",
       "      <th>Charbon</th>\n",
       "      <th>Gaz</th>\n",
       "      <th>...</th>\n",
       "      <th>Hydraulique - Fil de l?eau + éclusée</th>\n",
       "      <th>Hydraulique - Lacs</th>\n",
       "      <th>Hydraulique - STEP turbinage</th>\n",
       "      <th>Bioénergies - Déchets</th>\n",
       "      <th>Bioénergies - Biomasse</th>\n",
       "      <th>Bioénergies - Biogaz</th>\n",
       "      <th>Stockage batterie</th>\n",
       "      <th>Déstockage batterie</th>\n",
       "      <th>Eolien terrestre</th>\n",
       "      <th>Eolien offshore</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>France</td>\n",
       "      <td>Données définitives</td>\n",
       "      <td>2014-01-01</td>\n",
       "      <td>00:00</td>\n",
       "      <td>64660.0</td>\n",
       "      <td>63200</td>\n",
       "      <td>63200.0</td>\n",
       "      <td>454.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2303.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5662</td>\n",
       "      <td>2125</td>\n",
       "      <td>693.0</td>\n",
       "      <td>460</td>\n",
       "      <td>165.0</td>\n",
       "      <td>179.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>France</td>\n",
       "      <td>Données définitives</td>\n",
       "      <td>2014-01-01</td>\n",
       "      <td>00:30</td>\n",
       "      <td>63494.0</td>\n",
       "      <td>62100</td>\n",
       "      <td>61500.0</td>\n",
       "      <td>281.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2367.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5569</td>\n",
       "      <td>2450</td>\n",
       "      <td>495.0</td>\n",
       "      <td>592</td>\n",
       "      <td>170.0</td>\n",
       "      <td>181.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>France</td>\n",
       "      <td>Données définitives</td>\n",
       "      <td>2014-01-01</td>\n",
       "      <td>01:00</td>\n",
       "      <td>61362.0</td>\n",
       "      <td>59900</td>\n",
       "      <td>59900.0</td>\n",
       "      <td>281.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2188.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5457</td>\n",
       "      <td>2040</td>\n",
       "      <td>76.0</td>\n",
       "      <td>591</td>\n",
       "      <td>173.0</td>\n",
       "      <td>181.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>France</td>\n",
       "      <td>Données définitives</td>\n",
       "      <td>2014-01-01</td>\n",
       "      <td>01:30</td>\n",
       "      <td>61217.0</td>\n",
       "      <td>60600</td>\n",
       "      <td>60300.0</td>\n",
       "      <td>281.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2190.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5286</td>\n",
       "      <td>1849</td>\n",
       "      <td>0.0</td>\n",
       "      <td>595</td>\n",
       "      <td>174.0</td>\n",
       "      <td>180.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>France</td>\n",
       "      <td>Données définitives</td>\n",
       "      <td>2014-01-01</td>\n",
       "      <td>02:00</td>\n",
       "      <td>60748.0</td>\n",
       "      <td>59900</td>\n",
       "      <td>60200.0</td>\n",
       "      <td>281.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2187.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5201</td>\n",
       "      <td>1592</td>\n",
       "      <td>0.0</td>\n",
       "      <td>597</td>\n",
       "      <td>174.0</td>\n",
       "      <td>180.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 40 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  Périmètre               Nature        Date Heures  Consommation  \\\n",
       "0    France  Données définitives  2014-01-01  00:00       64660.0   \n",
       "1    France  Données définitives  2014-01-01  00:30       63494.0   \n",
       "2    France  Données définitives  2014-01-01  01:00       61362.0   \n",
       "3    France  Données définitives  2014-01-01  01:30       61217.0   \n",
       "4    France  Données définitives  2014-01-01  02:00       60748.0   \n",
       "\n",
       "  Prévision J-1  Prévision J  Fioul  Charbon     Gaz  ...  \\\n",
       "0         63200      63200.0  454.0      0.0  2303.0  ...   \n",
       "1         62100      61500.0  281.0      0.0  2367.0  ...   \n",
       "2         59900      59900.0  281.0      0.0  2188.0  ...   \n",
       "3         60600      60300.0  281.0      0.0  2190.0  ...   \n",
       "4         59900      60200.0  281.0      0.0  2187.0  ...   \n",
       "\n",
       "   Hydraulique - Fil de l?eau + éclusée  Hydraulique - Lacs  \\\n",
       "0                                  5662                2125   \n",
       "1                                  5569                2450   \n",
       "2                                  5457                2040   \n",
       "3                                  5286                1849   \n",
       "4                                  5201                1592   \n",
       "\n",
       "   Hydraulique - STEP turbinage  Bioénergies - Déchets  \\\n",
       "0                         693.0                    460   \n",
       "1                         495.0                    592   \n",
       "2                          76.0                    591   \n",
       "3                           0.0                    595   \n",
       "4                           0.0                    597   \n",
       "\n",
       "   Bioénergies - Biomasse  Bioénergies - Biogaz   Stockage batterie  \\\n",
       "0                   165.0                 179.0                 NaN   \n",
       "1                   170.0                 181.0                 NaN   \n",
       "2                   173.0                 181.0                 NaN   \n",
       "3                   174.0                 180.0                 NaN   \n",
       "4                   174.0                 180.0                 NaN   \n",
       "\n",
       "   Déstockage batterie Eolien terrestre Eolien offshore  \n",
       "0                  NaN              NaN             NaN  \n",
       "1                  NaN              NaN             NaN  \n",
       "2                  NaN              NaN             NaN  \n",
       "3                  NaN              NaN             NaN  \n",
       "4                  NaN              NaN             NaN  \n",
       "\n",
       "[5 rows x 40 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "display(df.head())"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}