Pyckpocket_3_feature_engineering.ipynb

{
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "kaVArw2cLCH5"
      },
      "source": [
        "Monter le drive dans google colab"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "TFFWcFhsWqLZ",
        "outputId": "1cfc0089-10df-4f36-b7c1-e0bbbee029de"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Mounted at /content/drive\n"
          ]
        }
      ],
      "source": [
        "from google.colab import drive\n",
        "drive.mount('/content/drive')"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "6WEekJTfGYg4"
      },
      "source": [
        "Import des librairies"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "H3dpxxIIGVM5"
      },
      "outputs": [],
      "source": [
        "import pandas as pd\n",
        "import numpy as np\n",
        "import datetime"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "eAEc6OC86fSi"
      },
      "source": [
        "Import des fichiers df, df_by_team au format csv dans google colab : si besoin, changer le chemin /content/..."
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "-feyL4j26L0L"
      },
      "outputs": [],
      "source": [
        "# Gestion des dates au format date avec format européen\n",
        "df= pd.read_csv('/content/df.csv', parse_dates=['Date'],dayfirst=True,index_col=0)\n",
        "df_by_team= pd.read_csv('/content/df_by_team.csv', parse_dates=['Date'],dayfirst=True,index_col=0)\n",
        "\n",
        "# La saison lue en tant que numérique est remise en chaine de caractère\n",
        "df['Saison'] = df['Saison'] .astype(str)\n",
        "df_by_team['Saison'] = df_by_team['Saison'] .astype(str)\n",
        "\n",
        "# Import d'un csv contenant les notes FIFA (jeu) par équipe et saison\n",
        "df_note = pd.read_csv('/content/note_equipe.csv', sep=';') \n",
        "df_note[\"Saison\"]=df_note[\"Saison\"].astype(str)"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "FXSaICg68T0M"
      },
      "source": [
        "## Feature engineering"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "UR2wXLmw8182"
      },
      "source": [
        "Ajout du résultat du même match la saison précédante"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "awiCNV9i8fFR"
      },
      "outputs": [],
      "source": [
        "# On ne garde que les variables qui serviront soit à la fusion, soit à l'ajout de variables qui nous interessent (résultat, nb de buts)\n",
        "df_result_last_an = df[['Equipe_exterieur','Equipe_domicile','Saison','Resultat_match','Nb_buts_equipe_dom','Nb_buts_equipe_ext']]\n",
        "df_result_last_an=df_result_last_an.rename(columns={'Resultat_match' : 'Resultat_match_an_dernier',\n",
        "                                  'Nb_buts_equipe_dom':'Nb_buts_equipe_dom_an_dernier',\n",
        "                                  'Nb_buts_equipe_ext':'Nb_buts_equipe_ext_an_dernier'})\n",
        "\n",
        "# Ajout de 1 à la saison pour préparation de la fusion\n",
        "df_result_last_an.loc[:,'Saison']=(df_result_last_an.loc[:,'Saison'].astype(int)+1).astype(str)\n",
        "\n",
        "# Fusion du dataframe de départ avec les résultats de l'an dernier\n",
        "df = df.merge(right = df_result_last_an, on = ['Equipe_domicile','Equipe_exterieur','Saison'], how = 'left')\n",
        "\n",
        "# Remplacement des valeurs manquantes par 0 pour les nombres de buts\n",
        "df['Nb_buts_equipe_dom_an_dernier'].fillna(0,inplace=True)\n",
        "df['Nb_buts_equipe_ext_an_dernier'].fillna(0,inplace=True)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 601
        },
        "id": "PzU_Z646882A",
        "outputId": "fa61e14e-c458-4eb7-be80-e5c82ccd5977"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "\n",
              "  <div id=\"df-557c5b65-6c6d-4ec2-aaf0-810dd874067e\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>Saison</th>\n",
              "      <th>Equipe_domicile</th>\n",
              "      <th>Equipe_exterieur</th>\n",
              "      <th>Nb_buts_equipe_dom</th>\n",
              "      <th>Nb_buts_equipe_ext</th>\n",
              "      <th>Resultat_match</th>\n",
              "      <th>Nb_buts_mi_temps_equipe_dom</th>\n",
              "      <th>Nb_buts_mi_temps_equipe_ext</th>\n",
              "      <th>Resultat_mi_temps</th>\n",
              "      <th>Nb_tirs_equipe_dom</th>\n",
              "      <th>Nb_tirs_equipe_ext</th>\n",
              "      <th>Nb_tirs_cadres_equipe_dom</th>\n",
              "      <th>Nb_tirs_cadres_equipe_ext</th>\n",
              "      <th>Nb_fautes_equipe_dom</th>\n",
              "      <th>Nb_fautes_equipe_ext</th>\n",
              "      <th>Corners_equipe_dom</th>\n",
              "      <th>Corners_equipe_ext</th>\n",
              "      <th>Nb_cartons_J_equipe_dom</th>\n",
              "      <th>Nb_cartons_J_equipe_ext</th>\n",
              "      <th>Nb_cartons_R_equipe_dom</th>\n",
              "      <th>Nb_cartons_R_equipe_ext</th>\n",
              "      <th>Nb_total_but_match</th>\n",
              "      <th>Moy_cote_domicile</th>\n",
              "      <th>Max_cote_domicile</th>\n",
              "      <th>Min_cote_domicile</th>\n",
              "      <th>Moy_cote_exterieur</th>\n",
              "      <th>Max_cote_exterieur</th>\n",
              "      <th>Min_cote_exterieur</th>\n",
              "      <th>Moy_cote_nul</th>\n",
              "      <th>Max_cote_nul</th>\n",
              "      <th>Min_cote_nul</th>\n",
              "      <th>Resultat_match_an_dernier</th>\n",
              "      <th>Nb_buts_equipe_dom_an_dernier</th>\n",
              "      <th>Nb_buts_equipe_ext_an_dernier</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>2389</th>\n",
              "      <td>2022-01-23</td>\n",
              "      <td>2021</td>\n",
              "      <td>Metz</td>\n",
              "      <td>Nice</td>\n",
              "      <td>0</td>\n",
              "      <td>2</td>\n",
              "      <td>A</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>D</td>\n",
              "      <td>8</td>\n",
              "      <td>7</td>\n",
              "      <td>1</td>\n",
              "      <td>6</td>\n",
              "      <td>14</td>\n",
              "      <td>6</td>\n",
              "      <td>3</td>\n",
              "      <td>4</td>\n",
              "      <td>3</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>2</td>\n",
              "      <td>4.96</td>\n",
              "      <td>5.25</td>\n",
              "      <td>4.60</td>\n",
              "      <td>1.72</td>\n",
              "      <td>1.75</td>\n",
              "      <td>1.70</td>\n",
              "      <td>3.72</td>\n",
              "      <td>3.90</td>\n",
              "      <td>3.50</td>\n",
              "      <td>D</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1313</th>\n",
              "      <td>2018-12-22</td>\n",
              "      <td>2018</td>\n",
              "      <td>Reims</td>\n",
              "      <td>Caen</td>\n",
              "      <td>2</td>\n",
              "      <td>2</td>\n",
              "      <td>D</td>\n",
              "      <td>1</td>\n",
              "      <td>2</td>\n",
              "      <td>A</td>\n",
              "      <td>19</td>\n",
              "      <td>7</td>\n",
              "      <td>11</td>\n",
              "      <td>2</td>\n",
              "      <td>9</td>\n",
              "      <td>16</td>\n",
              "      <td>10</td>\n",
              "      <td>2</td>\n",
              "      <td>3</td>\n",
              "      <td>3</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>4</td>\n",
              "      <td>1.74</td>\n",
              "      <td>1.80</td>\n",
              "      <td>1.70</td>\n",
              "      <td>5.50</td>\n",
              "      <td>5.92</td>\n",
              "      <td>4.75</td>\n",
              "      <td>3.45</td>\n",
              "      <td>3.50</td>\n",
              "      <td>3.40</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>805</th>\n",
              "      <td>2017-09-09</td>\n",
              "      <td>2017</td>\n",
              "      <td>Troyes</td>\n",
              "      <td>Toulouse</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>D</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>D</td>\n",
              "      <td>11</td>\n",
              "      <td>7</td>\n",
              "      <td>3</td>\n",
              "      <td>0</td>\n",
              "      <td>12</td>\n",
              "      <td>13</td>\n",
              "      <td>4</td>\n",
              "      <td>1</td>\n",
              "      <td>2</td>\n",
              "      <td>3</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>2.88</td>\n",
              "      <td>2.98</td>\n",
              "      <td>2.80</td>\n",
              "      <td>2.55</td>\n",
              "      <td>2.60</td>\n",
              "      <td>2.50</td>\n",
              "      <td>3.19</td>\n",
              "      <td>3.28</td>\n",
              "      <td>3.10</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1843</th>\n",
              "      <td>2020-09-27</td>\n",
              "      <td>2020</td>\n",
              "      <td>Dijon</td>\n",
              "      <td>Montpellier</td>\n",
              "      <td>2</td>\n",
              "      <td>2</td>\n",
              "      <td>D</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>H</td>\n",
              "      <td>15</td>\n",
              "      <td>14</td>\n",
              "      <td>6</td>\n",
              "      <td>5</td>\n",
              "      <td>15</td>\n",
              "      <td>11</td>\n",
              "      <td>6</td>\n",
              "      <td>13</td>\n",
              "      <td>4</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>4</td>\n",
              "      <td>4.31</td>\n",
              "      <td>4.50</td>\n",
              "      <td>4.20</td>\n",
              "      <td>1.84</td>\n",
              "      <td>1.87</td>\n",
              "      <td>1.80</td>\n",
              "      <td>3.59</td>\n",
              "      <td>3.78</td>\n",
              "      <td>3.45</td>\n",
              "      <td>D</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1521</th>\n",
              "      <td>2019-08-10</td>\n",
              "      <td>2019</td>\n",
              "      <td>Angers</td>\n",
              "      <td>Bordeaux</td>\n",
              "      <td>3</td>\n",
              "      <td>1</td>\n",
              "      <td>H</td>\n",
              "      <td>3</td>\n",
              "      <td>1</td>\n",
              "      <td>H</td>\n",
              "      <td>14</td>\n",
              "      <td>8</td>\n",
              "      <td>4</td>\n",
              "      <td>3</td>\n",
              "      <td>11</td>\n",
              "      <td>15</td>\n",
              "      <td>4</td>\n",
              "      <td>3</td>\n",
              "      <td>2</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>4</td>\n",
              "      <td>2.36</td>\n",
              "      <td>2.40</td>\n",
              "      <td>2.34</td>\n",
              "      <td>3.24</td>\n",
              "      <td>3.35</td>\n",
              "      <td>3.10</td>\n",
              "      <td>3.14</td>\n",
              "      <td>3.29</td>\n",
              "      <td>3.10</td>\n",
              "      <td>A</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1146</th>\n",
              "      <td>2018-08-12</td>\n",
              "      <td>2018</td>\n",
              "      <td>Bordeaux</td>\n",
              "      <td>Strasbourg</td>\n",
              "      <td>0</td>\n",
              "      <td>2</td>\n",
              "      <td>A</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>D</td>\n",
              "      <td>5</td>\n",
              "      <td>17</td>\n",
              "      <td>2</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>12</td>\n",
              "      <td>3</td>\n",
              "      <td>10</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>2</td>\n",
              "      <td>1.75</td>\n",
              "      <td>1.80</td>\n",
              "      <td>1.70</td>\n",
              "      <td>4.89</td>\n",
              "      <td>5.11</td>\n",
              "      <td>4.60</td>\n",
              "      <td>3.59</td>\n",
              "      <td>3.80</td>\n",
              "      <td>3.40</td>\n",
              "      <td>A</td>\n",
              "      <td>0.0</td>\n",
              "      <td>3.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2388</th>\n",
              "      <td>2022-01-22</td>\n",
              "      <td>2021</td>\n",
              "      <td>Lens</td>\n",
              "      <td>Marseille</td>\n",
              "      <td>0</td>\n",
              "      <td>2</td>\n",
              "      <td>A</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>A</td>\n",
              "      <td>9</td>\n",
              "      <td>10</td>\n",
              "      <td>3</td>\n",
              "      <td>7</td>\n",
              "      <td>7</td>\n",
              "      <td>6</td>\n",
              "      <td>8</td>\n",
              "      <td>5</td>\n",
              "      <td>3</td>\n",
              "      <td>2</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>2</td>\n",
              "      <td>2.55</td>\n",
              "      <td>2.60</td>\n",
              "      <td>2.50</td>\n",
              "      <td>2.71</td>\n",
              "      <td>2.75</td>\n",
              "      <td>2.65</td>\n",
              "      <td>3.46</td>\n",
              "      <td>3.63</td>\n",
              "      <td>3.30</td>\n",
              "      <td>D</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>600</th>\n",
              "      <td>2017-02-04</td>\n",
              "      <td>2016</td>\n",
              "      <td>Dijon</td>\n",
              "      <td>Paris SG</td>\n",
              "      <td>1</td>\n",
              "      <td>3</td>\n",
              "      <td>A</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>D</td>\n",
              "      <td>7</td>\n",
              "      <td>21</td>\n",
              "      <td>1</td>\n",
              "      <td>8</td>\n",
              "      <td>12</td>\n",
              "      <td>5</td>\n",
              "      <td>2</td>\n",
              "      <td>9</td>\n",
              "      <td>1</td>\n",
              "      <td>2</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>4</td>\n",
              "      <td>9.53</td>\n",
              "      <td>11.00</td>\n",
              "      <td>7.50</td>\n",
              "      <td>1.34</td>\n",
              "      <td>1.40</td>\n",
              "      <td>1.30</td>\n",
              "      <td>5.14</td>\n",
              "      <td>5.50</td>\n",
              "      <td>4.30</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>444</th>\n",
              "      <td>2016-09-24</td>\n",
              "      <td>2016</td>\n",
              "      <td>Lorient</td>\n",
              "      <td>Lyon</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>H</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>D</td>\n",
              "      <td>11</td>\n",
              "      <td>18</td>\n",
              "      <td>2</td>\n",
              "      <td>8</td>\n",
              "      <td>13</td>\n",
              "      <td>8</td>\n",
              "      <td>3</td>\n",
              "      <td>8</td>\n",
              "      <td>2</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>4.15</td>\n",
              "      <td>4.33</td>\n",
              "      <td>4.00</td>\n",
              "      <td>1.89</td>\n",
              "      <td>1.92</td>\n",
              "      <td>1.85</td>\n",
              "      <td>3.56</td>\n",
              "      <td>3.74</td>\n",
              "      <td>3.30</td>\n",
              "      <td>A</td>\n",
              "      <td>1.0</td>\n",
              "      <td>3.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1579</th>\n",
              "      <td>2019-09-24</td>\n",
              "      <td>2019</td>\n",
              "      <td>Dijon</td>\n",
              "      <td>Marseille</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>D</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>D</td>\n",
              "      <td>18</td>\n",
              "      <td>9</td>\n",
              "      <td>6</td>\n",
              "      <td>2</td>\n",
              "      <td>9</td>\n",
              "      <td>14</td>\n",
              "      <td>8</td>\n",
              "      <td>3</td>\n",
              "      <td>3</td>\n",
              "      <td>3</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>3.63</td>\n",
              "      <td>3.75</td>\n",
              "      <td>3.50</td>\n",
              "      <td>2.07</td>\n",
              "      <td>2.15</td>\n",
              "      <td>2.00</td>\n",
              "      <td>3.40</td>\n",
              "      <td>3.50</td>\n",
              "      <td>3.30</td>\n",
              "      <td>A</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-557c5b65-6c6d-4ec2-aaf0-810dd874067e')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-557c5b65-6c6d-4ec2-aaf0-810dd874067e button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-557c5b65-6c6d-4ec2-aaf0-810dd874067e');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ],
            "text/plain": [
              "           Date  ... Nb_buts_equipe_ext_an_dernier\n",
              "2389 2022-01-23  ...                           1.0\n",
              "1313 2018-12-22  ...                           0.0\n",
              "805  2017-09-09  ...                           0.0\n",
              "1843 2020-09-27  ...                           2.0\n",
              "1521 2019-08-10  ...                           2.0\n",
              "1146 2018-08-12  ...                           3.0\n",
              "2388 2022-01-22  ...                           2.0\n",
              "600  2017-02-04  ...                           0.0\n",
              "444  2016-09-24  ...                           3.0\n",
              "1579 2019-09-24  ...                           2.0\n",
              "\n",
              "[10 rows x 35 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 5
        }
      ],
      "source": [
        "# Extrait du dataframe\n",
        "df.sample(10)"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "PZwMRtc9qZem"
      },
      "source": [
        "Nombre de points moyens par match depuis le début de l'année (correspond à un classement des équipes sur la saison)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "jg55bnLE8jkB"
      },
      "outputs": [],
      "source": [
        "df_by_team_saison = df_by_team.copy()\n",
        "\n",
        "# Tri par Saison, Equipe et date pour calculer correctement les ordres de matchs et le cumul des points\n",
        "df_by_team_saison.sort_values(by=['Saison','Equipe','Date'],inplace=True)\n",
        "\n",
        "# Ordre du match pour chaque équipe (+1 car la numérotation commence à 0)\n",
        "df_by_team_saison['Num_match'] = df_by_team_saison.groupby(['Saison','Equipe'])['Nb_points'].cumcount()+1\n",
        "\n",
        "# Calcul du nombre de points moyens depuis le début de la saison (en prenant en compte le match de la ligne sur laquelle on se trouve)\n",
        "df_by_team_saison['Nb_points_moy_par_match_saison'] = df_by_team_saison.groupby(['Saison','Equipe'])['Nb_points'].cumsum()/(df_by_team_saison.groupby(['Saison','Equipe'])['Nb_points'].cumcount()+1)\n",
        "\n",
        "# Arrondi du nombre de points moyens à la 3eme décimale\n",
        "df_by_team_saison['Nb_points_moy_par_match_saison'] = np.round(df_by_team_saison['Nb_points_moy_par_match_saison'], decimals = 3) "
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "DdRQ5ddGxzv7"
      },
      "source": [
        "Moyenne des variables sur les 5 derniers matchs (état de forme du moment)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "XP5mV3wHxyiL",
        "outputId": "fd5cb198-8ec2-4da1-9889-c73c98988715"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Avant calcul, le dataframe df_by_team_saison contient 4796 lignes\n"
          ]
        },
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            "/usr/local/lib/python3.7/dist-packages/ipykernel_launcher.py:18: 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",
            "/usr/local/lib/python3.7/dist-packages/ipykernel_launcher.py:19: 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",
            "/usr/local/lib/python3.7/dist-packages/ipykernel_launcher.py:20: 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",
            "/usr/local/lib/python3.7/dist-packages/ipykernel_launcher.py:21: 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",
            "/usr/local/lib/python3.7/dist-packages/ipykernel_launcher.py:22: 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",
            "/usr/local/lib/python3.7/dist-packages/ipykernel_launcher.py:23: 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",
            "/usr/local/lib/python3.7/dist-packages/ipykernel_launcher.py:24: 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",
            "/usr/local/lib/python3.7/dist-packages/ipykernel_launcher.py:25: 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"
          ]
        },
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Après calcul, le dataframe df_by_team_saison contient 4796 lignes\n"
          ]
        }
      ],
      "source": [
        "# Création d'un dictionnaire vide qui va contenir les données par équipe\n",
        "dict_eq = {}\n",
        "\n",
        "# Recherche de l'ensemble des équipes ayant été en Ligue 1 depuis 2015\n",
        "equipes = pd.unique(df_by_team_saison['Equipe'])\n",
        "df_by_team_saison = df_by_team_saison.sort_values(by=['Equipe','Saison','Date'])\n",
        "\n",
        "# Pour vérification avant/après\n",
        "print(\"Avant calcul, le dataframe df_by_team_saison contient\",df_by_team_saison.shape[0],\"lignes\")\n",
        "\n",
        "# Pour chaque équipe\n",
        "for equipe in equipes:\n",
        "\n",
        "  # Sélection des données d'une équipe seule\n",
        "  dict_eq['df_'+equipe] = df_by_team_saison[df_by_team_saison['Equipe']==equipe]\n",
        "  \n",
        "  # Calcul des moyennes de chaque variable sur les 5 matchs précédents (avec un minimum de 1 match si pas 5 match disponibles)\n",
        "  dict_eq['df_'+equipe]['Moy_points_5_matchs'] = dict_eq['df_'+equipe]['Nb_points'].rolling(5,closed='left',min_periods=1).mean()\n",
        "  dict_eq['df_'+equipe]['Moy_buts_5_matchs'] = dict_eq['df_'+equipe]['Buts'].rolling(5,closed='left',min_periods=1).mean()\n",
        "  dict_eq['df_'+equipe]['Moy_tirs_cadres_5_matchs'] = dict_eq['df_'+equipe]['Nb_tirs_cadres'].rolling(5,closed='left',min_periods=1).mean()\n",
        "  dict_eq['df_'+equipe]['Moy_tirs_5_matchs'] = dict_eq['df_'+equipe]['Nb_tirs'].rolling(5,closed='left',min_periods=1).mean()\n",
        "  dict_eq['df_'+equipe]['Moy_nb_fautes_5_matchs'] = dict_eq['df_'+equipe]['Nb_fautes'].rolling(5,closed='left',min_periods=1).mean()\n",
        "  dict_eq['df_'+equipe]['Moy_corners_5_matchs'] = dict_eq['df_'+equipe]['Corners'].rolling(5,closed='left',min_periods=1).mean()\n",
        "  dict_eq['df_'+equipe]['Moy_carton_J_5_matchs'] = dict_eq['df_'+equipe]['Carton_jaune'].rolling(5,closed='left',min_periods=1).mean()\n",
        "  dict_eq['df_'+equipe]['Moy_carton_R_5_matchs'] = dict_eq['df_'+equipe]['Carton_rouge'].rolling(5,closed='left',min_periods=1).mean()\n",
        "\n",
        "# Fusion des données de toutes les équipes\n",
        "df_by_team_saison = pd.concat([dict_eq[\"df_Ajaccio GFCO\"],dict_eq['df_Amiens'],dict_eq['df_Angers'],dict_eq['df_Bastia'],dict_eq['df_Bordeaux'],\n",
        "dict_eq['df_Brest'],dict_eq['df_Caen'],dict_eq['df_Clermont'],dict_eq['df_Dijon'],dict_eq['df_Guingamp'],dict_eq['df_Lens'],dict_eq['df_Lille'],\n",
        "dict_eq['df_Lorient'],dict_eq['df_Lyon'],dict_eq['df_Marseille'],dict_eq['df_Metz'],dict_eq['df_Monaco'],dict_eq['df_Montpellier'],\n",
        "dict_eq['df_Nancy'],dict_eq['df_Nantes'],dict_eq['df_Nice'],dict_eq['df_Nimes'],dict_eq['df_Paris SG'],dict_eq['df_Reims'],dict_eq['df_Rennes'],\n",
        "dict_eq['df_St Etienne'],dict_eq['df_Strasbourg'],dict_eq['df_Toulouse'],dict_eq['df_Troyes']])\n",
        "\n",
        "# Vérification de la taille du dataframe \n",
        "print(\"Après calcul, le dataframe df_by_team_saison contient\",df_by_team_saison.shape[0],\"lignes\")"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "PduUA3RP8qHV"
      },
      "source": [
        "Nombre de jours entre 2 matchs : pour le premier match de la saison, on prend le nombre de jours moyens sur tous les autres matchs de toutes les saisons sauf celle de test"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 357
        },
        "id": "xXRgGdg88mwi",
        "outputId": "4fa1bc62-7898-41f4-a227-6d5fa76418ab"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "\n",
              "  <div id=\"df-795db6ff-7112-47b4-823d-bba72a38948f\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>Equipe</th>\n",
              "      <th>Adversaire</th>\n",
              "      <th>Buts</th>\n",
              "      <th>Buts_mi_temps</th>\n",
              "      <th>Nb_tirs</th>\n",
              "      <th>Nb_tirs_cadres</th>\n",
              "      <th>Nb_fautes</th>\n",
              "      <th>Corners</th>\n",
              "      <th>Carton_jaune</th>\n",
              "      <th>Carton_rouge</th>\n",
              "      <th>Date</th>\n",
              "      <th>Saison</th>\n",
              "      <th>Resultat_match</th>\n",
              "      <th>D_E</th>\n",
              "      <th>Nb_points</th>\n",
              "      <th>Num_match</th>\n",
              "      <th>Nb_points_moy_par_match_saison</th>\n",
              "      <th>Moy_points_5_matchs</th>\n",
              "      <th>Moy_buts_5_matchs</th>\n",
              "      <th>Moy_tirs_cadres_5_matchs</th>\n",
              "      <th>Moy_tirs_5_matchs</th>\n",
              "      <th>Moy_nb_fautes_5_matchs</th>\n",
              "      <th>Moy_corners_5_matchs</th>\n",
              "      <th>Moy_carton_J_5_matchs</th>\n",
              "      <th>Moy_carton_R_5_matchs</th>\n",
              "      <th>Nb_jours_dernier_match</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Ajaccio GFCO</td>\n",
              "      <td>Troyes</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>6</td>\n",
              "      <td>1</td>\n",
              "      <td>8</td>\n",
              "      <td>3</td>\n",
              "      <td>4</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-08-08</td>\n",
              "      <td>2015</td>\n",
              "      <td>Nul</td>\n",
              "      <td>E</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1.000</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>8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>Ajaccio GFCO</td>\n",
              "      <td>Paris SG</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>8</td>\n",
              "      <td>2</td>\n",
              "      <td>14</td>\n",
              "      <td>1</td>\n",
              "      <td>3</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-08-16</td>\n",
              "      <td>2015</td>\n",
              "      <td>Défaite</td>\n",
              "      <td>E</td>\n",
              "      <td>0</td>\n",
              "      <td>2</td>\n",
              "      <td>0.500</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>6.000000</td>\n",
              "      <td>8.000000</td>\n",
              "      <td>3.000000</td>\n",
              "      <td>4.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>Ajaccio GFCO</td>\n",
              "      <td>Angers</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>8</td>\n",
              "      <td>3</td>\n",
              "      <td>12</td>\n",
              "      <td>9</td>\n",
              "      <td>2</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-08-22</td>\n",
              "      <td>2015</td>\n",
              "      <td>Défaite</td>\n",
              "      <td>D</td>\n",
              "      <td>0</td>\n",
              "      <td>3</td>\n",
              "      <td>0.333</td>\n",
              "      <td>0.500000</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.5</td>\n",
              "      <td>7.000000</td>\n",
              "      <td>11.000000</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>3.5</td>\n",
              "      <td>0.0</td>\n",
              "      <td>6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\n",
              "      <td>Ajaccio GFCO</td>\n",
              "      <td>Lille</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>12</td>\n",
              "      <td>6</td>\n",
              "      <td>17</td>\n",
              "      <td>4</td>\n",
              "      <td>3</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-08-29</td>\n",
              "      <td>2015</td>\n",
              "      <td>Défaite</td>\n",
              "      <td>E</td>\n",
              "      <td>0</td>\n",
              "      <td>4</td>\n",
              "      <td>0.250</td>\n",
              "      <td>0.333333</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>7.333333</td>\n",
              "      <td>11.333333</td>\n",
              "      <td>4.333333</td>\n",
              "      <td>3.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>47</th>\n",
              "      <td>Ajaccio GFCO</td>\n",
              "      <td>Monaco</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>24</td>\n",
              "      <td>4</td>\n",
              "      <td>16</td>\n",
              "      <td>14</td>\n",
              "      <td>3</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-09-13</td>\n",
              "      <td>2015</td>\n",
              "      <td>Défaite</td>\n",
              "      <td>D</td>\n",
              "      <td>0</td>\n",
              "      <td>5</td>\n",
              "      <td>0.200</td>\n",
              "      <td>0.250000</td>\n",
              "      <td>0.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>8.500000</td>\n",
              "      <td>12.750000</td>\n",
              "      <td>4.250000</td>\n",
              "      <td>3.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-795db6ff-7112-47b4-823d-bba72a38948f')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-795db6ff-7112-47b4-823d-bba72a38948f button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-795db6ff-7112-47b4-823d-bba72a38948f');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ],
            "text/plain": [
              "          Equipe Adversaire  ...  Moy_carton_R_5_matchs  Nb_jours_dernier_match\n",
              "6   Ajaccio GFCO     Troyes  ...                    NaN                       8\n",
              "18  Ajaccio GFCO   Paris SG  ...                    0.0                       8\n",
              "21  Ajaccio GFCO     Angers  ...                    0.0                       6\n",
              "33  Ajaccio GFCO      Lille  ...                    0.0                       7\n",
              "47  Ajaccio GFCO     Monaco  ...                    0.0                      15\n",
              "\n",
              "[5 rows x 26 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 8
        }
      ],
      "source": [
        "df_by_team_saison['Nb_jours_dernier_match']=(df_by_team_saison['Date']-np.roll(df_by_team_saison['Date'], 1)).dt.days\n",
        "df_by_team_saison.loc[df_by_team_saison.Num_match==1,'Nb_jours_dernier_match']=round(df_by_team_saison.loc[(df_by_team_saison['Saison'] != '2021') & (df_by_team_saison.Num_match!=1),'Nb_jours_dernier_match'].mean())\n",
        "df_by_team_saison.head()"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "Ewyve1Nnssck"
      },
      "source": [
        "Fusion avec le dataframe par match"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "vCnoRVJnoBLe"
      },
      "outputs": [],
      "source": [
        "# Fusion du dataframe avec 1 ligne par match avec le dataframe avec 1 ligne par équipe pour récupérer le numéro du match de l'équipe à domicile\n",
        "# ainsi que les données sur les 5 matchs précédents pour l'équipe à domicile\n",
        "df = df.merge(right = df_by_team_saison[['Equipe','Date','Saison','Num_match','Moy_points_5_matchs','Moy_buts_5_matchs','Moy_tirs_cadres_5_matchs','Moy_tirs_5_matchs','Nb_jours_dernier_match',\n",
        "'Moy_nb_fautes_5_matchs','Moy_corners_5_matchs','Moy_carton_J_5_matchs','Moy_carton_R_5_matchs']],right_on = ['Equipe','Date','Saison'],left_on = ['Equipe_domicile','Date','Saison'],how='left')\n",
        "df.rename(columns={'Num_match': 'Num_match_dom',\n",
        "                   'Moy_points_5_matchs':'Moy_points_5_match_dom',\n",
        "                   'Moy_buts_5_matchs':'Moy_buts_5_matchs_dom',\n",
        "                   'Moy_tirs_cadres_5_matchs':'Moy_tirs_cadres_5_matchs_dom',\n",
        "                   'Moy_tirs_5_matchs':'Moy_tirs_5_matchs_dom',\n",
        "                   'Moy_nb_fautes_5_matchs':'Moy_nb_fautes_5_matchs_dom',\n",
        "                   'Moy_corners_5_matchs':'Moy_corners_5_matchs_dom',\n",
        "                   'Moy_carton_J_5_matchs':'Moy_carton_J_5_matchs_dom',\n",
        "                   'Moy_carton_R_5_matchs':'Moy_carton_R_5_matchs_dom',\n",
        "                   'Nb_jours_dernier_match':'Nb_jours_dernier_match_dom'},inplace=True)\n",
        "\n",
        "# Fusion du dataframe avec 1 ligne par match avec le dataframe avec 1 ligne par équipe pour récupérer le numéro du match de l'équipe à l'extérieur (peut être différent de celui à domicile (décalage de match par exemple))\n",
        "# ainsi que les données sur les 5 matchs précédents pour l'équipe à l'extérieur\n",
        "df = df.merge(right = df_by_team_saison[['Equipe','Date','Saison','Num_match','Moy_points_5_matchs','Moy_buts_5_matchs','Moy_tirs_cadres_5_matchs','Moy_tirs_5_matchs','Nb_jours_dernier_match',\n",
        "'Moy_nb_fautes_5_matchs','Moy_corners_5_matchs','Moy_carton_J_5_matchs','Moy_carton_R_5_matchs']],right_on = ['Equipe','Date','Saison'],left_on = ['Equipe_exterieur','Date','Saison'],how='left')\n",
        "df.rename(columns={'Num_match': 'Num_match_ext',\n",
        "                   'Moy_points_5_matchs':'Moy_points_5_match_ext',\n",
        "                   'Moy_buts_5_matchs':'Moy_buts_5_matchs_ext',\n",
        "                   'Moy_tirs_cadres_5_matchs':'Moy_tirs_cadres_5_matchs_ext',\n",
        "                   'Moy_tirs_5_matchs':'Moy_tirs_5_matchs_ext',\n",
        "                   'Moy_nb_fautes_5_matchs':'Moy_nb_fautes_5_matchs_ext',\n",
        "                   'Moy_corners_5_matchs':'Moy_corners_5_matchs_ext',\n",
        "                   'Moy_carton_J_5_matchs':'Moy_carton_J_5_matchs_ext',\n",
        "                   'Moy_carton_R_5_matchs':'Moy_carton_R_5_matchs_ext',\n",
        "                   'Nb_jours_dernier_match':'Nb_jours_dernier_match_ext'},inplace=True)\n",
        "\n",
        "# Suppression des variables ajoutées lors des fusions\n",
        "df.drop(['Equipe_y','Equipe_x'],axis=1,inplace=True)\n",
        "\n",
        "# Dans la dataframe df_model, nous voulons le nombre de points par macth depuis le début de la saison vu à la fin du match précédent \n",
        "# (par exemple pour le 4ème match, prendre les données à la fin du 5ème match)\n",
        "# Nous ajoutons donc 1 au numéro de match dans le dataframe par équipe pour pouvoir faire la fusion correctement\n",
        "df_by_team_saison['Num_match']= df_by_team_saison['Num_match']+1\n",
        "\n",
        "# Fusion des deux dataframes par Equipe/Saison/Numéro de match recalculé pour l'équipe domicile puis extérieur\n",
        "df = df.merge(right = df_by_team_saison[['Equipe','Saison','Num_match','Nb_points_moy_par_match_saison']],\n",
        "left_on = ['Equipe_domicile','Saison','Num_match_dom'], right_on=['Equipe','Saison','Num_match'], how = 'left')\n",
        "\n",
        "df.rename(columns={'Nb_points_moy_par_match_saison': 'Points_moy_match_saison_dom'},inplace=True)\n",
        "\n",
        "# Suppression des variables ajoutées lors des fusions\n",
        "df.drop(['Equipe','Num_match'],axis=1,inplace=True)\n",
        "\n",
        "# Extérieur\n",
        "df = df.merge(right = df_by_team_saison[['Equipe','Saison','Num_match','Nb_points_moy_par_match_saison']],\n",
        "left_on = ['Equipe_exterieur','Saison','Num_match_ext'], right_on=['Equipe','Saison','Num_match'], how = 'left')\n",
        "\n",
        "df.rename(columns={'Nb_points_moy_par_match_saison': 'Points_moy_match_saison_ext'},inplace=True)\n",
        "\n",
        "# Suppression des variables ajoutées lors des fusions\n",
        "df.drop(['Equipe','Num_match'],axis=1,inplace=True)\n",
        "\n"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "aBC0aq_fgzVZ"
      },
      "source": [
        "Remplacement des données manquantes"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 357
        },
        "id": "COBP3sRETbYZ",
        "outputId": "6e96f46f-7aab-4d2e-9336-ad991700dd3a"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "\n",
              "  <div id=\"df-8abc4c5c-dd54-4336-ad2b-9ca48bd58d33\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>Saison</th>\n",
              "      <th>Equipe_domicile</th>\n",
              "      <th>Equipe_exterieur</th>\n",
              "      <th>Nb_buts_equipe_dom</th>\n",
              "      <th>Nb_buts_equipe_ext</th>\n",
              "      <th>Resultat_match</th>\n",
              "      <th>Nb_buts_mi_temps_equipe_dom</th>\n",
              "      <th>Nb_buts_mi_temps_equipe_ext</th>\n",
              "      <th>Resultat_mi_temps</th>\n",
              "      <th>Nb_tirs_equipe_dom</th>\n",
              "      <th>Nb_tirs_equipe_ext</th>\n",
              "      <th>Nb_tirs_cadres_equipe_dom</th>\n",
              "      <th>Nb_tirs_cadres_equipe_ext</th>\n",
              "      <th>Nb_fautes_equipe_dom</th>\n",
              "      <th>Nb_fautes_equipe_ext</th>\n",
              "      <th>Corners_equipe_dom</th>\n",
              "      <th>Corners_equipe_ext</th>\n",
              "      <th>Nb_cartons_J_equipe_dom</th>\n",
              "      <th>Nb_cartons_J_equipe_ext</th>\n",
              "      <th>Nb_cartons_R_equipe_dom</th>\n",
              "      <th>Nb_cartons_R_equipe_ext</th>\n",
              "      <th>Nb_total_but_match</th>\n",
              "      <th>Moy_cote_domicile</th>\n",
              "      <th>Max_cote_domicile</th>\n",
              "      <th>Min_cote_domicile</th>\n",
              "      <th>Moy_cote_exterieur</th>\n",
              "      <th>Max_cote_exterieur</th>\n",
              "      <th>Min_cote_exterieur</th>\n",
              "      <th>Moy_cote_nul</th>\n",
              "      <th>Max_cote_nul</th>\n",
              "      <th>Min_cote_nul</th>\n",
              "      <th>Resultat_match_an_dernier</th>\n",
              "      <th>Nb_buts_equipe_dom_an_dernier</th>\n",
              "      <th>Nb_buts_equipe_ext_an_dernier</th>\n",
              "      <th>Num_match_dom</th>\n",
              "      <th>Moy_points_5_match_dom</th>\n",
              "      <th>Moy_buts_5_matchs_dom</th>\n",
              "      <th>Moy_tirs_cadres_5_matchs_dom</th>\n",
              "      <th>Moy_tirs_5_matchs_dom</th>\n",
              "      <th>Nb_jours_dernier_match_dom</th>\n",
              "      <th>Moy_nb_fautes_5_matchs_dom</th>\n",
              "      <th>Moy_corners_5_matchs_dom</th>\n",
              "      <th>Moy_carton_J_5_matchs_dom</th>\n",
              "      <th>Moy_carton_R_5_matchs_dom</th>\n",
              "      <th>Num_match_ext</th>\n",
              "      <th>Moy_points_5_match_ext</th>\n",
              "      <th>Moy_buts_5_matchs_ext</th>\n",
              "      <th>Moy_tirs_cadres_5_matchs_ext</th>\n",
              "      <th>Moy_tirs_5_matchs_ext</th>\n",
              "      <th>Nb_jours_dernier_match_ext</th>\n",
              "      <th>Moy_nb_fautes_5_matchs_ext</th>\n",
              "      <th>Moy_corners_5_matchs_ext</th>\n",
              "      <th>Moy_carton_J_5_matchs_ext</th>\n",
              "      <th>Moy_carton_R_5_matchs_ext</th>\n",
              "      <th>Points_moy_match_saison_dom</th>\n",
              "      <th>Points_moy_match_saison_ext</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2015-08-07</td>\n",
              "      <td>2015</td>\n",
              "      <td>Lille</td>\n",
              "      <td>Paris SG</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>A</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>D</td>\n",
              "      <td>12</td>\n",
              "      <td>7</td>\n",
              "      <td>2</td>\n",
              "      <td>2</td>\n",
              "      <td>20</td>\n",
              "      <td>17</td>\n",
              "      <td>3</td>\n",
              "      <td>2</td>\n",
              "      <td>3</td>\n",
              "      <td>2</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>6.22</td>\n",
              "      <td>7.00</td>\n",
              "      <td>4.65</td>\n",
              "      <td>1.65</td>\n",
              "      <td>1.75</td>\n",
              "      <td>1.57</td>\n",
              "      <td>3.63</td>\n",
              "      <td>3.80</td>\n",
              "      <td>3.40</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.29075</td>\n",
              "      <td>4.122589</td>\n",
              "      <td>11.9191</td>\n",
              "      <td>8</td>\n",
              "      <td>13.019501</td>\n",
              "      <td>4.765234</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.322451</td>\n",
              "      <td>4.190211</td>\n",
              "      <td>12.128774</td>\n",
              "      <td>8</td>\n",
              "      <td>12.97336</td>\n",
              "      <td>4.873537</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2015-08-08</td>\n",
              "      <td>2015</td>\n",
              "      <td>Bastia</td>\n",
              "      <td>Rennes</td>\n",
              "      <td>2</td>\n",
              "      <td>1</td>\n",
              "      <td>H</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>A</td>\n",
              "      <td>11</td>\n",
              "      <td>6</td>\n",
              "      <td>3</td>\n",
              "      <td>3</td>\n",
              "      <td>15</td>\n",
              "      <td>19</td>\n",
              "      <td>6</td>\n",
              "      <td>2</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>3</td>\n",
              "      <td>2.56</td>\n",
              "      <td>2.71</td>\n",
              "      <td>2.30</td>\n",
              "      <td>2.97</td>\n",
              "      <td>3.10</td>\n",
              "      <td>2.80</td>\n",
              "      <td>3.01</td>\n",
              "      <td>3.10</td>\n",
              "      <td>2.88</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.29075</td>\n",
              "      <td>4.122589</td>\n",
              "      <td>11.9191</td>\n",
              "      <td>8</td>\n",
              "      <td>13.019501</td>\n",
              "      <td>4.765234</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.322451</td>\n",
              "      <td>4.190211</td>\n",
              "      <td>12.128774</td>\n",
              "      <td>8</td>\n",
              "      <td>12.97336</td>\n",
              "      <td>4.873537</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2015-08-08</td>\n",
              "      <td>2015</td>\n",
              "      <td>Marseille</td>\n",
              "      <td>Caen</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>A</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>A</td>\n",
              "      <td>17</td>\n",
              "      <td>8</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "      <td>10</td>\n",
              "      <td>10</td>\n",
              "      <td>14</td>\n",
              "      <td>2</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>1.55</td>\n",
              "      <td>1.57</td>\n",
              "      <td>1.50</td>\n",
              "      <td>6.05</td>\n",
              "      <td>6.59</td>\n",
              "      <td>5.50</td>\n",
              "      <td>4.08</td>\n",
              "      <td>4.40</td>\n",
              "      <td>3.70</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.29075</td>\n",
              "      <td>4.122589</td>\n",
              "      <td>11.9191</td>\n",
              "      <td>8</td>\n",
              "      <td>13.019501</td>\n",
              "      <td>4.765234</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.322451</td>\n",
              "      <td>4.190211</td>\n",
              "      <td>12.128774</td>\n",
              "      <td>8</td>\n",
              "      <td>12.97336</td>\n",
              "      <td>4.873537</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>2015-08-08</td>\n",
              "      <td>2015</td>\n",
              "      <td>Montpellier</td>\n",
              "      <td>Angers</td>\n",
              "      <td>0</td>\n",
              "      <td>2</td>\n",
              "      <td>A</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>A</td>\n",
              "      <td>11</td>\n",
              "      <td>16</td>\n",
              "      <td>4</td>\n",
              "      <td>6</td>\n",
              "      <td>12</td>\n",
              "      <td>15</td>\n",
              "      <td>5</td>\n",
              "      <td>9</td>\n",
              "      <td>3</td>\n",
              "      <td>2</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>2</td>\n",
              "      <td>1.78</td>\n",
              "      <td>1.83</td>\n",
              "      <td>1.75</td>\n",
              "      <td>5.09</td>\n",
              "      <td>5.53</td>\n",
              "      <td>4.35</td>\n",
              "      <td>3.33</td>\n",
              "      <td>3.50</td>\n",
              "      <td>3.10</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.29075</td>\n",
              "      <td>4.122589</td>\n",
              "      <td>11.9191</td>\n",
              "      <td>8</td>\n",
              "      <td>13.019501</td>\n",
              "      <td>4.765234</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.322451</td>\n",
              "      <td>4.190211</td>\n",
              "      <td>12.128774</td>\n",
              "      <td>8</td>\n",
              "      <td>12.97336</td>\n",
              "      <td>4.873537</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2015-08-08</td>\n",
              "      <td>2015</td>\n",
              "      <td>Nantes</td>\n",
              "      <td>Guingamp</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>H</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>D</td>\n",
              "      <td>9</td>\n",
              "      <td>10</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "      <td>13</td>\n",
              "      <td>16</td>\n",
              "      <td>6</td>\n",
              "      <td>2</td>\n",
              "      <td>2</td>\n",
              "      <td>2</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>2.17</td>\n",
              "      <td>2.25</td>\n",
              "      <td>2.10</td>\n",
              "      <td>3.68</td>\n",
              "      <td>4.20</td>\n",
              "      <td>3.40</td>\n",
              "      <td>3.07</td>\n",
              "      <td>3.15</td>\n",
              "      <td>2.90</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.29075</td>\n",
              "      <td>4.122589</td>\n",
              "      <td>11.9191</td>\n",
              "      <td>8</td>\n",
              "      <td>13.019501</td>\n",
              "      <td>4.765234</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.322451</td>\n",
              "      <td>4.190211</td>\n",
              "      <td>12.128774</td>\n",
              "      <td>8</td>\n",
              "      <td>12.97336</td>\n",
              "      <td>4.873537</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-8abc4c5c-dd54-4336-ad2b-9ca48bd58d33')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-8abc4c5c-dd54-4336-ad2b-9ca48bd58d33 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-8abc4c5c-dd54-4336-ad2b-9ca48bd58d33');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ],
            "text/plain": [
              "        Date Saison  ... Points_moy_match_saison_dom Points_moy_match_saison_ext\n",
              "0 2015-08-07   2015  ...                         1.0                         1.0\n",
              "1 2015-08-08   2015  ...                         1.0                         1.0\n",
              "2 2015-08-08   2015  ...                         1.0                         1.0\n",
              "3 2015-08-08   2015  ...                         1.0                         1.0\n",
              "4 2015-08-08   2015  ...                         1.0                         1.0\n",
              "\n",
              "[5 rows x 57 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 10
        }
      ],
      "source": [
        "# Remplacement des données manquantes de la première journée : on met des valeurs par défaut ou les moyennes hors saison 2021/2022 \n",
        "# qui sera l'échantillon de test\n",
        "df['Points_moy_match_saison_dom']=df['Points_moy_match_saison_dom'].fillna(1)\n",
        "df['Points_moy_match_saison_ext']=df['Points_moy_match_saison_ext'].fillna(1)\n",
        "df['Moy_points_5_match_dom']=df['Moy_points_5_match_dom'].fillna(1)\n",
        "df['Moy_buts_5_matchs_dom']=df['Moy_buts_5_matchs_dom'].fillna(df.loc[df['Saison'] != '2021', 'Moy_buts_5_matchs_dom'].mean())\n",
        "df['Moy_tirs_cadres_5_matchs_dom']=df['Moy_tirs_cadres_5_matchs_dom'].fillna(df.loc[df['Saison'] != '2021', 'Moy_tirs_cadres_5_matchs_dom'].mean())\n",
        "df['Moy_tirs_5_matchs_dom']=df['Moy_tirs_5_matchs_dom'].fillna(df.loc[df['Saison'] != '2021', 'Moy_tirs_5_matchs_dom'].mean())\n",
        "df['Moy_nb_fautes_5_matchs_dom']=df['Moy_nb_fautes_5_matchs_dom'].fillna(df.loc[df['Saison'] != '2021', 'Moy_nb_fautes_5_matchs_dom'].mean())\n",
        "df['Moy_corners_5_matchs_dom']=df['Moy_corners_5_matchs_dom'].fillna(df.loc[df['Saison'] != '2021', 'Moy_corners_5_matchs_dom'].mean())\n",
        "df['Moy_carton_J_5_matchs_dom']=df['Moy_carton_J_5_matchs_dom'].fillna(0)\n",
        "df['Moy_carton_R_5_matchs_dom']=df['Moy_carton_R_5_matchs_dom'].fillna(0)\n",
        "df['Moy_points_5_match_ext']=df['Moy_points_5_match_ext'].fillna(1)\n",
        "df['Moy_buts_5_matchs_ext']=df['Moy_buts_5_matchs_ext'].fillna(df.loc[df['Saison'] != '2021', 'Moy_buts_5_matchs_ext'].mean())\n",
        "df['Moy_tirs_cadres_5_matchs_ext']=df['Moy_tirs_cadres_5_matchs_ext'].fillna(df.loc[df['Saison'] != '2021', 'Moy_tirs_cadres_5_matchs_ext'].mean())\n",
        "df['Moy_tirs_5_matchs_ext']=df['Moy_tirs_5_matchs_ext'].fillna(df.loc[df['Saison'] != '2021', 'Moy_tirs_5_matchs_ext'].mean())\n",
        "df['Moy_nb_fautes_5_matchs_ext']=df['Moy_nb_fautes_5_matchs_ext'].fillna(df.loc[df['Saison'] != '2021', 'Moy_nb_fautes_5_matchs_ext'].mean())\n",
        "df['Moy_corners_5_matchs_ext']=df['Moy_corners_5_matchs_ext'].fillna(df.loc[df['Saison'] != '2021', 'Moy_corners_5_matchs_ext'].mean())\n",
        "df['Moy_carton_J_5_matchs_ext']=df['Moy_carton_J_5_matchs_ext'].fillna(0)\n",
        "df['Moy_carton_R_5_matchs_ext']=df['Moy_carton_R_5_matchs_ext'].fillna(0)\n",
        "\n",
        "df.head(5)"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "uDonDVU9DTk7"
      },
      "source": [
        "Ajout du poucentage de buts / tirs cadrés sur 5 matchs"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "h02is21tDX4a"
      },
      "outputs": [],
      "source": [
        "df['Pct_buts_par_tirs_cadres_5m_dom']=df['Moy_buts_5_matchs_dom']/df['Moy_tirs_cadres_5_matchs_dom']\n",
        "df['Pct_buts_par_tirs_cadres_5m_ext']=df['Moy_buts_5_matchs_ext']/df['Moy_tirs_cadres_5_matchs_ext']"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "MfkMcC7UXFS2"
      },
      "source": [
        "Fusion avec le dataframe précédent pour mettre les notes des équipes à domicile et à l'extérieur"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "B0hDOGscb_hR"
      },
      "outputs": [],
      "source": [
        "# Domicile\n",
        "df = df.merge(right = df_note[['Equipe','Saison',\n",
        "                               'note_att','note_mil',\n",
        "                               'note_def', 'note_gen']],left_on = ['Equipe_domicile','Saison'],right_on = ['Equipe','Saison'],how='left')\n",
        "\n",
        "df.rename(columns={'note_att':'note_att_dom',\n",
        "                   'note_mil':'note_mil_dom',\n",
        "                   'note_def':'note_def_dom',\n",
        "                   'note_gen':'note_gen_dom',},inplace=True)\n",
        "\n",
        "# Extérieur\n",
        "df = df.merge(right = df_note[['Equipe','Saison',\n",
        "                               'note_att','note_mil',\n",
        "                               'note_def', 'note_gen']],left_on = ['Equipe_exterieur','Saison'],right_on = ['Equipe','Saison'],how='left')\n",
        "\n",
        "df.rename(columns={'note_att':'note_att_ext',\n",
        "                   'note_mil':'note_mil_ext',\n",
        "                   'note_def':'note_def_ext',\n",
        "                   'note_gen':'note_gen_ext',},inplace=True)"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "a3o0tCB1Il6Y"
      },
      "source": [
        "Mise en forme du résultat de l'an dernier au format numérique (dummies)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "YygjKR0vIie7"
      },
      "outputs": [],
      "source": [
        "df = pd.get_dummies(df, columns=[\"Resultat_match_an_dernier\"], prefix = [\"Res_an_dernier\"])"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "e9YzFWUGi06D"
      },
      "source": [
        "Création d'un index et du daraframe final"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "OBaUzl1vfQp_"
      },
      "outputs": [],
      "source": [
        "# Création d'un index unique\n",
        "df.index = df.Saison + ' - ' + df.Equipe_domicile + ' - ' + df.Equipe_exterieur\n",
        "\n",
        "# Suppression des variables qui ont servi à la création des variables connues avant le match\n",
        "df_model= df.drop(['Date','Equipe_domicile','Equipe_exterieur','Nb_buts_equipe_dom','Nb_buts_equipe_ext','Nb_buts_mi_temps_equipe_dom',\n",
        "                   'Nb_buts_mi_temps_equipe_ext','Resultat_mi_temps', 'Nb_tirs_equipe_dom','Nb_tirs_equipe_ext','Nb_tirs_cadres_equipe_dom',\n",
        "                   'Nb_tirs_cadres_equipe_ext','Nb_fautes_equipe_dom','Nb_fautes_equipe_ext','Corners_equipe_dom','Corners_equipe_ext',\n",
        "                   'Nb_cartons_J_equipe_dom','Nb_cartons_J_equipe_ext','Nb_cartons_R_equipe_dom','Nb_cartons_R_equipe_ext','Nb_total_but_match',\n",
        "                   'Equipe_y','Equipe_x'],axis=1)\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "vct9xw4YBPqz"
      },
      "outputs": [],
      "source": [
        "# Export du csv df_by_team dans google colab pour réutilisation dans le feature engineering\n",
        "df_model.to_csv('/content/df_model.csv')"
      ]
    }
  ],
  "metadata": {
    "colab": {
      "collapsed_sections": [],
      "name": "Pyckpocket_3_Feature_engineering.ipynb",
      "provenance": []
    },
    "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.8.8"
    }
  },
  "nbformat": 4,
  "nbformat_minor": 0
}