data_cleaning.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "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>Unnamed: 0</th>\n",
       "      <th>year</th>\n",
       "      <th>rank</th>\n",
       "      <th>player</th>\n",
       "      <th>team</th>\n",
       "      <th>points</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>1956</td>\n",
       "      <td>1st</td>\n",
       "      <td>Stanley Matthews</td>\n",
       "      <td>Blackpool</td>\n",
       "      <td>47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>1956</td>\n",
       "      <td>2nd</td>\n",
       "      <td>Alfredo Di Stéfano</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>1956</td>\n",
       "      <td>3rd</td>\n",
       "      <td>Raymond Kopa</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>1957</td>\n",
       "      <td>1st</td>\n",
       "      <td>Alfredo Di Stéfano[note 1]</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>1957</td>\n",
       "      <td>2nd</td>\n",
       "      <td>Billy Wright</td>\n",
       "      <td>Wolverhampton Wanderers</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0  year rank                      player                     team  \\\n",
       "0           0  1956  1st            Stanley Matthews                Blackpool   \n",
       "1           1  1956  2nd          Alfredo Di Stéfano              Real Madrid   \n",
       "2           2  1956  3rd                Raymond Kopa              Real Madrid   \n",
       "3           3  1957  1st  Alfredo Di Stéfano[note 1]              Real Madrid   \n",
       "4           4  1957  2nd                Billy Wright  Wolverhampton Wanderers   \n",
       "\n",
       "  points  \n",
       "0     47  \n",
       "1     44  \n",
       "2     33  \n",
       "3     72  \n",
       "4     19  "
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "\n",
    "df = pd.read_csv('data/to_clean/ballondor.csv')\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "supprimer la collonne sans nom \"Unname: 0\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>year</th>\n",
       "      <th>rank</th>\n",
       "      <th>player</th>\n",
       "      <th>team</th>\n",
       "      <th>points</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1956</td>\n",
       "      <td>1st</td>\n",
       "      <td>Stanley Matthews</td>\n",
       "      <td>Blackpool</td>\n",
       "      <td>47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1956</td>\n",
       "      <td>2nd</td>\n",
       "      <td>Alfredo Di Stéfano</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1956</td>\n",
       "      <td>3rd</td>\n",
       "      <td>Raymond Kopa</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1957</td>\n",
       "      <td>1st</td>\n",
       "      <td>Alfredo Di Stéfano[note 1]</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1957</td>\n",
       "      <td>2nd</td>\n",
       "      <td>Billy Wright</td>\n",
       "      <td>Wolverhampton Wanderers</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   year rank                      player                     team points\n",
       "0  1956  1st            Stanley Matthews                Blackpool     47\n",
       "1  1956  2nd          Alfredo Di Stéfano              Real Madrid     44\n",
       "2  1956  3rd                Raymond Kopa              Real Madrid     33\n",
       "3  1957  1st  Alfredo Di Stéfano[note 1]              Real Madrid     72\n",
       "4  1957  2nd                Billy Wright  Wolverhampton Wanderers     19"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.drop(columns='Unnamed: 0').head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "la suppression ne s'est pas faite sur la liste elle meme.\n",
    "voyons "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>Unnamed: 0</th>\n",
       "      <th>year</th>\n",
       "      <th>rank</th>\n",
       "      <th>player</th>\n",
       "      <th>team</th>\n",
       "      <th>points</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>1956</td>\n",
       "      <td>1st</td>\n",
       "      <td>Stanley Matthews</td>\n",
       "      <td>Blackpool</td>\n",
       "      <td>47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>1956</td>\n",
       "      <td>2nd</td>\n",
       "      <td>Alfredo Di Stéfano</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>1956</td>\n",
       "      <td>3rd</td>\n",
       "      <td>Raymond Kopa</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>1957</td>\n",
       "      <td>1st</td>\n",
       "      <td>Alfredo Di Stéfano[note 1]</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>1957</td>\n",
       "      <td>2nd</td>\n",
       "      <td>Billy Wright</td>\n",
       "      <td>Wolverhampton Wanderers</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0  year rank                      player                     team  \\\n",
       "0           0  1956  1st            Stanley Matthews                Blackpool   \n",
       "1           1  1956  2nd          Alfredo Di Stéfano              Real Madrid   \n",
       "2           2  1956  3rd                Raymond Kopa              Real Madrid   \n",
       "3           3  1957  1st  Alfredo Di Stéfano[note 1]              Real Madrid   \n",
       "4           4  1957  2nd                Billy Wright  Wolverhampton Wanderers   \n",
       "\n",
       "  points  \n",
       "0     47  \n",
       "1     44  \n",
       "2     33  \n",
       "3     72  \n",
       "4     19  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "pour que ca le soit l'argument 'inplace' doit etre a True"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>year</th>\n",
       "      <th>rank</th>\n",
       "      <th>player</th>\n",
       "      <th>team</th>\n",
       "      <th>points</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1956</td>\n",
       "      <td>1st</td>\n",
       "      <td>Stanley Matthews</td>\n",
       "      <td>Blackpool</td>\n",
       "      <td>47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1956</td>\n",
       "      <td>2nd</td>\n",
       "      <td>Alfredo Di Stéfano</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1956</td>\n",
       "      <td>3rd</td>\n",
       "      <td>Raymond Kopa</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1957</td>\n",
       "      <td>1st</td>\n",
       "      <td>Alfredo Di Stéfano[note 1]</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1957</td>\n",
       "      <td>2nd</td>\n",
       "      <td>Billy Wright</td>\n",
       "      <td>Wolverhampton Wanderers</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   year rank                      player                     team points\n",
       "0  1956  1st            Stanley Matthews                Blackpool     47\n",
       "1  1956  2nd          Alfredo Di Stéfano              Real Madrid     44\n",
       "2  1956  3rd                Raymond Kopa              Real Madrid     33\n",
       "3  1957  1st  Alfredo Di Stéfano[note 1]              Real Madrid     72\n",
       "4  1957  2nd                Billy Wright  Wolverhampton Wanderers     19"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.drop(columns='Unnamed: 0', inplace=True)# cette methode ne peut etre appliquee qu'une seule fois\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 194 entries, 0 to 193\n",
      "Data columns (total 5 columns):\n",
      "year      194 non-null int64\n",
      "rank      194 non-null object\n",
      "player    194 non-null object\n",
      "team      190 non-null object\n",
      "points    190 non-null object\n",
      "dtypes: int64(1), object(4)\n",
      "memory usage: 7.7+ KB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(0,)"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "np.where(df.loc[7].isna())[0].shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Real Madrid'"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[2, 'team']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "####  pour regler le probleme d'execo dont les cellules ce sont deplacees\n",
    "####  exemple index 6, pas de rank et de point et les valeur de player et team se sont deplacees\n",
    "#### ce sont des execo donc, rank et points sont egaux aux valeurs directement precedentes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>year</th>\n",
       "      <th>rank</th>\n",
       "      <th>player</th>\n",
       "      <th>team</th>\n",
       "      <th>points</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1956</td>\n",
       "      <td>1st</td>\n",
       "      <td>Stanley Matthews</td>\n",
       "      <td>Blackpool</td>\n",
       "      <td>47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1956</td>\n",
       "      <td>2nd</td>\n",
       "      <td>Alfredo Di Stéfano</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1956</td>\n",
       "      <td>3rd</td>\n",
       "      <td>Raymond Kopa</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1957</td>\n",
       "      <td>1st</td>\n",
       "      <td>Alfredo Di Stéfano[note 1]</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1957</td>\n",
       "      <td>2nd</td>\n",
       "      <td>Billy Wright</td>\n",
       "      <td>Wolverhampton Wanderers</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1957</td>\n",
       "      <td>3rd</td>\n",
       "      <td>Duncan Edwards</td>\n",
       "      <td>Manchester United</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1957</td>\n",
       "      <td>3rd</td>\n",
       "      <td>Raymond Kopa</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1958</td>\n",
       "      <td>1st</td>\n",
       "      <td>Raymond Kopa</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1958</td>\n",
       "      <td>2nd</td>\n",
       "      <td>Helmut Rahn</td>\n",
       "      <td>Rot-Weiss Essen</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1958</td>\n",
       "      <td>3rd</td>\n",
       "      <td>Just Fontaine</td>\n",
       "      <td>Stade de Reims</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   year rank                      player                     team points\n",
       "0  1956  1st            Stanley Matthews                Blackpool     47\n",
       "1  1956  2nd          Alfredo Di Stéfano              Real Madrid     44\n",
       "2  1956  3rd                Raymond Kopa              Real Madrid     33\n",
       "3  1957  1st  Alfredo Di Stéfano[note 1]              Real Madrid     72\n",
       "4  1957  2nd                Billy Wright  Wolverhampton Wanderers     19\n",
       "5  1957  3rd              Duncan Edwards        Manchester United     16\n",
       "6  1957  3rd                Raymond Kopa              Real Madrid     16\n",
       "7  1958  1st                Raymond Kopa              Real Madrid     71\n",
       "8  1958  2nd                 Helmut Rahn          Rot-Weiss Essen     40\n",
       "9  1958  3rd               Just Fontaine           Stade de Reims     23"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "f = df.loc[0]\n",
    "for index in range(df.shape[0]):\n",
    "    if np.where(df.loc[index].isna())[0].shape[0] != 0:\n",
    "        df.loc[index, 'team'] = df.loc[index, 'player']\n",
    "        df.loc[index, 'player'] = df.loc[index, 'rank']\n",
    "        df.loc[index, 'rank'] = f['rank']\n",
    "        df.loc[index, 'points'] = f['points']\n",
    "    f = df.loc[index]\n",
    "df.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "year                 1991\n",
       "rank                  2nd\n",
       "player    Lothar Matthäus\n",
       "team       Internazionale\n",
       "points                 42\n",
       "Name: 109, dtype: object"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[109]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Dans la colonne points, certaines valeurs sont en pourcentage d'autre en nombre\n",
    "pour uniformiser, nous allons creer une nouvelle colonne percenteges pour les pourcentages\n",
    "deplacer les pourcentage la-bas et calculer le pourcentage respectif des autres valeurs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['pourcentages'] = np.nan"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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>year</th>\n",
       "      <th>rank</th>\n",
       "      <th>player</th>\n",
       "      <th>team</th>\n",
       "      <th>points</th>\n",
       "      <th>pourcentages</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1956</td>\n",
       "      <td>1st</td>\n",
       "      <td>Stanley Matthews</td>\n",
       "      <td>Blackpool</td>\n",
       "      <td>47</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1956</td>\n",
       "      <td>2nd</td>\n",
       "      <td>Alfredo Di Stéfano</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>44</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1956</td>\n",
       "      <td>3rd</td>\n",
       "      <td>Raymond Kopa</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>33</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1957</td>\n",
       "      <td>1st</td>\n",
       "      <td>Alfredo Di Stéfano[note 1]</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>72</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1957</td>\n",
       "      <td>2nd</td>\n",
       "      <td>Billy Wright</td>\n",
       "      <td>Wolverhampton Wanderers</td>\n",
       "      <td>19</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   year rank                      player                     team points  \\\n",
       "0  1956  1st            Stanley Matthews                Blackpool     47   \n",
       "1  1956  2nd          Alfredo Di Stéfano              Real Madrid     44   \n",
       "2  1956  3rd                Raymond Kopa              Real Madrid     33   \n",
       "3  1957  1st  Alfredo Di Stéfano[note 1]              Real Madrid     72   \n",
       "4  1957  2nd                Billy Wright  Wolverhampton Wanderers     19   \n",
       "\n",
       "   pourcentages  \n",
       "0           NaN  \n",
       "1           NaN  \n",
       "2           NaN  \n",
       "3           NaN  \n",
       "4           NaN  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Affecter les valeurs en pourcentage"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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>year</th>\n",
       "      <th>rank</th>\n",
       "      <th>player</th>\n",
       "      <th>team</th>\n",
       "      <th>points</th>\n",
       "      <th>pourcentages</th>\n",
       "      <th>pourcentage</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1956</td>\n",
       "      <td>1st</td>\n",
       "      <td>Stanley Matthews</td>\n",
       "      <td>Blackpool</td>\n",
       "      <td>47</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1956</td>\n",
       "      <td>2nd</td>\n",
       "      <td>Alfredo Di Stéfano</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>44</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1956</td>\n",
       "      <td>3rd</td>\n",
       "      <td>Raymond Kopa</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>33</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1957</td>\n",
       "      <td>1st</td>\n",
       "      <td>Alfredo Di Stéfano[note 1]</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>72</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1957</td>\n",
       "      <td>2nd</td>\n",
       "      <td>Billy Wright</td>\n",
       "      <td>Wolverhampton Wanderers</td>\n",
       "      <td>19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   year rank                      player                     team points  \\\n",
       "0  1956  1st            Stanley Matthews                Blackpool     47   \n",
       "1  1956  2nd          Alfredo Di Stéfano              Real Madrid     44   \n",
       "2  1956  3rd                Raymond Kopa              Real Madrid     33   \n",
       "3  1957  1st  Alfredo Di Stéfano[note 1]              Real Madrid     72   \n",
       "4  1957  2nd                Billy Wright  Wolverhampton Wanderers     19   \n",
       "\n",
       "   pourcentages pourcentage  \n",
       "0           NaN         NaN  \n",
       "1           NaN         NaN  \n",
       "2           NaN         NaN  \n",
       "3           NaN         NaN  \n",
       "4           NaN         NaN  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['pourcentage'] = df[df['points'].str.endswith('%')]['points']\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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>year</th>\n",
       "      <th>rank</th>\n",
       "      <th>player</th>\n",
       "      <th>team</th>\n",
       "      <th>points</th>\n",
       "      <th>pourcentages</th>\n",
       "      <th>pourcentage</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>177</th>\n",
       "      <td>2014</td>\n",
       "      <td>2nd</td>\n",
       "      <td>Lionel Messi</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>15.76%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15.76%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>178</th>\n",
       "      <td>2014</td>\n",
       "      <td>3rd</td>\n",
       "      <td>Manuel Neuer</td>\n",
       "      <td>Bayern Munich</td>\n",
       "      <td>15.72%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15.72%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>2015</td>\n",
       "      <td>1st</td>\n",
       "      <td>Lionel Messi</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>41.33%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.33%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>2015</td>\n",
       "      <td>2nd</td>\n",
       "      <td>Cristiano Ronaldo</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>27.76%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>27.76%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>2015</td>\n",
       "      <td>3rd</td>\n",
       "      <td>Neymar</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>7.86%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.86%</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     year rank             player           team  points  pourcentages  \\\n",
       "177  2014  2nd       Lionel Messi      Barcelona  15.76%           NaN   \n",
       "178  2014  3rd       Manuel Neuer  Bayern Munich  15.72%           NaN   \n",
       "179  2015  1st       Lionel Messi      Barcelona  41.33%           NaN   \n",
       "180  2015  2nd  Cristiano Ronaldo    Real Madrid  27.76%           NaN   \n",
       "181  2015  3rd             Neymar      Barcelona   7.86%           NaN   \n",
       "\n",
       "    pourcentage  \n",
       "177      15.76%  \n",
       "178      15.72%  \n",
       "179      41.33%  \n",
       "180      27.76%  \n",
       "181       7.86%  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[177:181]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### les deux colonnes pourcentages et pourcentage ne sont pas conformes\n",
    "nous allons renomer 'pourcentage' en 'percentages' et supprimer 'pourcentages'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "# cette cellule ne doit etre executee qu'une seule fois\n",
    "df.rename(columns={'pourcentage': 'percentages'}, inplace=True)\n",
    "df.drop(columns=['pourcentages'], inplace=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "suppremer les valeurs en pourcentage dans la colonne points"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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>year</th>\n",
       "      <th>rank</th>\n",
       "      <th>player</th>\n",
       "      <th>team</th>\n",
       "      <th>points</th>\n",
       "      <th>percentages</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>2012</td>\n",
       "      <td>1st</td>\n",
       "      <td>Lionel Messi</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.60%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>2012</td>\n",
       "      <td>2nd</td>\n",
       "      <td>Cristiano Ronaldo</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23.68%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>2012</td>\n",
       "      <td>3rd</td>\n",
       "      <td>Andrés Iniesta</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.91%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>2013</td>\n",
       "      <td>1st</td>\n",
       "      <td>Cristiano Ronaldo</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>NaN</td>\n",
       "      <td>27.99%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>2013</td>\n",
       "      <td>2nd</td>\n",
       "      <td>Lionel Messi</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24.72%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>2013</td>\n",
       "      <td>3rd</td>\n",
       "      <td>Franck Ribéry</td>\n",
       "      <td>Bayern Munich</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23.36%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176</th>\n",
       "      <td>2014</td>\n",
       "      <td>1st</td>\n",
       "      <td>Cristiano Ronaldo</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>NaN</td>\n",
       "      <td>37.66%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177</th>\n",
       "      <td>2014</td>\n",
       "      <td>2nd</td>\n",
       "      <td>Lionel Messi</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15.76%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>178</th>\n",
       "      <td>2014</td>\n",
       "      <td>3rd</td>\n",
       "      <td>Manuel Neuer</td>\n",
       "      <td>Bayern Munich</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15.72%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>2015</td>\n",
       "      <td>1st</td>\n",
       "      <td>Lionel Messi</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.33%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>2015</td>\n",
       "      <td>2nd</td>\n",
       "      <td>Cristiano Ronaldo</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>NaN</td>\n",
       "      <td>27.76%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>2015</td>\n",
       "      <td>3rd</td>\n",
       "      <td>Neymar</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.86%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182</th>\n",
       "      <td>2016</td>\n",
       "      <td>1st</td>\n",
       "      <td>Cristiano Ronaldo</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>745</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>2016</td>\n",
       "      <td>2nd</td>\n",
       "      <td>Lionel Messi</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>316</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     year rank             player           team points percentages\n",
       "170  2012  1st       Lionel Messi      Barcelona    NaN      41.60%\n",
       "171  2012  2nd  Cristiano Ronaldo    Real Madrid    NaN      23.68%\n",
       "172  2012  3rd     Andrés Iniesta      Barcelona    NaN      10.91%\n",
       "173  2013  1st  Cristiano Ronaldo    Real Madrid    NaN      27.99%\n",
       "174  2013  2nd       Lionel Messi      Barcelona    NaN      24.72%\n",
       "175  2013  3rd      Franck Ribéry  Bayern Munich    NaN      23.36%\n",
       "176  2014  1st  Cristiano Ronaldo    Real Madrid    NaN      37.66%\n",
       "177  2014  2nd       Lionel Messi      Barcelona    NaN      15.76%\n",
       "178  2014  3rd       Manuel Neuer  Bayern Munich    NaN      15.72%\n",
       "179  2015  1st       Lionel Messi      Barcelona    NaN      41.33%\n",
       "180  2015  2nd  Cristiano Ronaldo    Real Madrid    NaN      27.76%\n",
       "181  2015  3rd             Neymar      Barcelona    NaN       7.86%\n",
       "182  2016  1st  Cristiano Ronaldo    Real Madrid    745         NaN\n",
       "183  2016  2nd       Lionel Messi      Barcelona    316         NaN"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['points'].where(df['points'].str.find('%') == -1, np.nan, inplace=True)\n",
    "df.loc[170:183]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "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></th>\n",
       "      <th>year</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>year</th>\n",
       "      <th>points</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">1956</th>\n",
       "      <th>33</th>\n",
       "      <td>1956</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>1956</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>1956</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">1957</th>\n",
       "      <th>16</th>\n",
       "      <td>3914</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1957</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>1957</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">1958</th>\n",
       "      <th>23</th>\n",
       "      <td>1958</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>1958</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>1958</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">1959</th>\n",
       "      <th>24</th>\n",
       "      <td>1959</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>1959</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>1959</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">1960</th>\n",
       "      <th>33</th>\n",
       "      <td>1960</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>1960</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>1960</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">1961</th>\n",
       "      <th>22</th>\n",
       "      <td>1961</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>1961</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>1961</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">1962</th>\n",
       "      <th>33</th>\n",
       "      <td>1962</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>1962</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>1962</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">1963</th>\n",
       "      <th>50</th>\n",
       "      <td>1963</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>1963</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>1963</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">1964</th>\n",
       "      <th>38</th>\n",
       "      <td>1964</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>1964</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>1964</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">1965</th>\n",
       "      <th>45</th>\n",
       "      <td>1965</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>1965</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>1965</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">2004</th>\n",
       "      <th>133</th>\n",
       "      <td>2004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>2004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>2004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">2005</th>\n",
       "      <th>142</th>\n",
       "      <td>2005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>2005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225</th>\n",
       "      <td>2005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">2006</th>\n",
       "      <th>121</th>\n",
       "      <td>2006</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>2006</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>2006</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">2007</th>\n",
       "      <th>255</th>\n",
       "      <td>2007</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>277</th>\n",
       "      <td>2007</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>444</th>\n",
       "      <td>2007</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">2008</th>\n",
       "      <th>179</th>\n",
       "      <td>2008</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>281</th>\n",
       "      <td>2008</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>446</th>\n",
       "      <td>2008</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">2009</th>\n",
       "      <th>170</th>\n",
       "      <td>2009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>233</th>\n",
       "      <td>2009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473</th>\n",
       "      <td>2009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">2016</th>\n",
       "      <th>198</th>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>316</th>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>745</th>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">2017</th>\n",
       "      <th>361</th>\n",
       "      <td>2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>670</th>\n",
       "      <td>2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>946</th>\n",
       "      <td>2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">2018</th>\n",
       "      <th>414</th>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476</th>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>753</th>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">2019</th>\n",
       "      <th>476</th>\n",
       "      <td>2019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>679</th>\n",
       "      <td>2019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>686</th>\n",
       "      <td>2019</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>172 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             year\n",
       "year points      \n",
       "1956 33      1956\n",
       "     44      1956\n",
       "     47      1956\n",
       "1957 16      3914\n",
       "     19      1957\n",
       "     72      1957\n",
       "1958 23      1958\n",
       "     40      1958\n",
       "     71      1958\n",
       "1959 24      1959\n",
       "     42      1959\n",
       "     80      1959\n",
       "1960 33      1960\n",
       "     37      1960\n",
       "     54      1960\n",
       "1961 22      1961\n",
       "     40      1961\n",
       "     46      1961\n",
       "1962 33      1962\n",
       "     53      1962\n",
       "     65      1962\n",
       "1963 50      1963\n",
       "     55      1963\n",
       "     73      1963\n",
       "1964 38      1964\n",
       "     43      1964\n",
       "     61      1964\n",
       "1965 45      1965\n",
       "     59      1965\n",
       "     67      1965\n",
       "...           ...\n",
       "2004 133     2004\n",
       "     139     2004\n",
       "     175     2004\n",
       "2005 142     2005\n",
       "     148     2005\n",
       "     225     2005\n",
       "2006 121     2006\n",
       "     124     2006\n",
       "     173     2006\n",
       "2007 255     2007\n",
       "     277     2007\n",
       "     444     2007\n",
       "2008 179     2008\n",
       "     281     2008\n",
       "     446     2008\n",
       "2009 170     2009\n",
       "     233     2009\n",
       "     473     2009\n",
       "2016 198     2016\n",
       "     316     2016\n",
       "     745     2016\n",
       "2017 361     2017\n",
       "     670     2017\n",
       "     946     2017\n",
       "2018 414     2018\n",
       "     476     2018\n",
       "     753     2018\n",
       "2019 476     2019\n",
       "     679     2019\n",
       "     686     2019\n",
       "\n",
       "[172 rows x 1 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "grouped = df.groupby(['year', 'points'])\n",
    "grouped.apply(lambda x: x.sum(numeric_only=True))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 194 entries, 0 to 193\n",
      "Data columns (total 6 columns):\n",
      "year           194 non-null int64\n",
      "rank           194 non-null object\n",
      "player         194 non-null object\n",
      "team           194 non-null object\n",
      "points         176 non-null object\n",
      "percentages    18 non-null object\n",
      "dtypes: int64(1), object(5)\n",
      "memory usage: 9.2+ KB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0       47.0\n",
       "1       44.0\n",
       "2       33.0\n",
       "3       72.0\n",
       "4       19.0\n",
       "5       16.0\n",
       "6       16.0\n",
       "7       71.0\n",
       "8       40.0\n",
       "9       23.0\n",
       "10      80.0\n",
       "11      42.0\n",
       "12      24.0\n",
       "13      54.0\n",
       "14      37.0\n",
       "15      33.0\n",
       "16      46.0\n",
       "17      40.0\n",
       "18      22.0\n",
       "19      65.0\n",
       "20      53.0\n",
       "21      33.0\n",
       "22      73.0\n",
       "23      55.0\n",
       "24      50.0\n",
       "25      61.0\n",
       "26      43.0\n",
       "27      38.0\n",
       "28      67.0\n",
       "29      59.0\n",
       "       ...  \n",
       "164      NaN\n",
       "165      NaN\n",
       "166      NaN\n",
       "167      NaN\n",
       "168      NaN\n",
       "169      NaN\n",
       "170      NaN\n",
       "171      NaN\n",
       "172      NaN\n",
       "173      NaN\n",
       "174      NaN\n",
       "175      NaN\n",
       "176      NaN\n",
       "177      NaN\n",
       "178      NaN\n",
       "179      NaN\n",
       "180      NaN\n",
       "181      NaN\n",
       "182    745.0\n",
       "183    316.0\n",
       "184    198.0\n",
       "185    946.0\n",
       "186    670.0\n",
       "187    361.0\n",
       "188    753.0\n",
       "189    476.0\n",
       "190    414.0\n",
       "191    686.0\n",
       "192    679.0\n",
       "193    476.0\n",
       "Name: points, Length: 194, dtype: float64"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.to_numeric(df['points'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['points'] = df['points'].astype('int64', errors='ignore')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 194 entries, 0 to 193\n",
      "Data columns (total 6 columns):\n",
      "year           194 non-null int64\n",
      "rank           194 non-null object\n",
      "player         194 non-null object\n",
      "team           194 non-null object\n",
      "points         176 non-null object\n",
      "percentages    18 non-null object\n",
      "dtypes: int64(1), object(5)\n",
      "memory usage: 9.2+ KB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 194 entries, 0 to 193\n",
      "Data columns (total 6 columns):\n",
      "year           194 non-null int64\n",
      "rank           194 non-null object\n",
      "player         194 non-null object\n",
      "team           194 non-null object\n",
      "points         176 non-null float64\n",
      "percentages    18 non-null object\n",
      "dtypes: float64(1), int64(1), object(4)\n",
      "memory usage: 9.2+ KB\n"
     ]
    }
   ],
   "source": [
    "df['points'] = pd.to_numeric(df['points'], downcast='integer', errors='ignore')\n",
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "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>year</th>\n",
       "      <th>points</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>year</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1956</th>\n",
       "      <td>5868.0</td>\n",
       "      <td>124.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1957</th>\n",
       "      <td>7828.0</td>\n",
       "      <td>123.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1958</th>\n",
       "      <td>5874.0</td>\n",
       "      <td>134.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1959</th>\n",
       "      <td>5877.0</td>\n",
       "      <td>146.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1960</th>\n",
       "      <td>5880.0</td>\n",
       "      <td>124.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        year  points\n",
       "year                \n",
       "1956  5868.0   124.0\n",
       "1957  7828.0   123.0\n",
       "1958  5874.0   134.0\n",
       "1959  5877.0   146.0\n",
       "1960  5880.0   124.0"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "grouped = df.groupby('year')\n",
    "sum_grouped = grouped.apply(lambda x: x.sum(numeric_only=True))\n",
    "sum_grouped.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 64 entries, 1956 to 2019\n",
      "Data columns (total 2 columns):\n",
      "year      64 non-null float64\n",
      "points    64 non-null float64\n",
      "dtypes: float64(2)\n",
      "memory usage: 1.5 KB\n"
     ]
    }
   ],
   "source": [
    "sum_grouped.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "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>year</th>\n",
       "      <th>rank</th>\n",
       "      <th>player</th>\n",
       "      <th>team</th>\n",
       "      <th>points</th>\n",
       "      <th>percentages</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>1991</td>\n",
       "      <td>2nd</td>\n",
       "      <td>Darko Pančev</td>\n",
       "      <td>Red Star Belgrade</td>\n",
       "      <td>42.0</td>\n",
       "      <td>15.73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>1999</td>\n",
       "      <td>2nd</td>\n",
       "      <td>David Beckham</td>\n",
       "      <td>Manchester United</td>\n",
       "      <td>154.0</td>\n",
       "      <td>35.24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>2013</td>\n",
       "      <td>3rd</td>\n",
       "      <td>Franck Ribéry</td>\n",
       "      <td>Bayern Munich</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23.36%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>2001</td>\n",
       "      <td>3rd</td>\n",
       "      <td>Oliver Kahn</td>\n",
       "      <td>Bayern Munich</td>\n",
       "      <td>114.0</td>\n",
       "      <td>26.51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>1988</td>\n",
       "      <td>3rd</td>\n",
       "      <td>Frank Rijkaard[note 8]</td>\n",
       "      <td>Milan</td>\n",
       "      <td>45.0</td>\n",
       "      <td>17.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>2003</td>\n",
       "      <td>3rd</td>\n",
       "      <td>Paolo Maldini</td>\n",
       "      <td>Milan</td>\n",
       "      <td>123.0</td>\n",
       "      <td>27.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>1997</td>\n",
       "      <td>3rd</td>\n",
       "      <td>Zinedine Zidane</td>\n",
       "      <td>Juventus</td>\n",
       "      <td>63.0</td>\n",
       "      <td>17.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>1977</td>\n",
       "      <td>1st</td>\n",
       "      <td>Allan Simonsen</td>\n",
       "      <td>Borussia Mönchengladbach</td>\n",
       "      <td>74.0</td>\n",
       "      <td>34.42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>2003</td>\n",
       "      <td>1st</td>\n",
       "      <td>Pavel Nedvěd</td>\n",
       "      <td>Juventus</td>\n",
       "      <td>190.0</td>\n",
       "      <td>43.08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>1979</td>\n",
       "      <td>1st</td>\n",
       "      <td>Kevin Keegan</td>\n",
       "      <td>Hamburg</td>\n",
       "      <td>118.0</td>\n",
       "      <td>55.92</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     year rank                  player                      team  points  \\\n",
       "108  1991  2nd            Darko Pančev         Red Star Belgrade    42.0   \n",
       "132  1999  2nd           David Beckham         Manchester United   154.0   \n",
       "175  2013  3rd           Franck Ribéry             Bayern Munich     NaN   \n",
       "139  2001  3rd             Oliver Kahn             Bayern Munich   114.0   \n",
       "99   1988  3rd  Frank Rijkaard[note 8]                     Milan    45.0   \n",
       "145  2003  3rd           Paolo Maldini                     Milan   123.0   \n",
       "127  1997  3rd         Zinedine Zidane                  Juventus    63.0   \n",
       "64   1977  1st          Allan Simonsen  Borussia Mönchengladbach    74.0   \n",
       "143  2003  1st            Pavel Nedvěd                  Juventus   190.0   \n",
       "70   1979  1st            Kevin Keegan                   Hamburg   118.0   \n",
       "\n",
       "    percentages  \n",
       "108       15.73  \n",
       "132       35.24  \n",
       "175      23.36%  \n",
       "139       26.51  \n",
       "99        17.18  \n",
       "145       27.89  \n",
       "127       17.85  \n",
       "64        34.42  \n",
       "143       43.08  \n",
       "70        55.92  "
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "for index in range(df.shape[0]):\n",
    "    if pd.isna(df.loc[index, 'points']) is False:\n",
    "#        calculer le pourcentage et garder selement deux chiffres apres la virgule \n",
    "        df.loc[index, 'percentages'] = round(df.loc[index, 'points'] * 100 / sum_grouped.loc[df.loc[index, 'year'], 'points'], 2)\n",
    "        df.loc[index, 'points'] = int(df.loc[index, 'points']) # garder seulement la partie entiere\n",
    "df.sample(n=10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "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>year</th>\n",
       "      <th>rank</th>\n",
       "      <th>player</th>\n",
       "      <th>team</th>\n",
       "      <th>points</th>\n",
       "      <th>percentages</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>2005</td>\n",
       "      <td>2nd</td>\n",
       "      <td>Frank Lampard</td>\n",
       "      <td>Chelsea</td>\n",
       "      <td>148.0</td>\n",
       "      <td>28.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>2005</td>\n",
       "      <td>3rd</td>\n",
       "      <td>Steven Gerrard</td>\n",
       "      <td>Liverpool</td>\n",
       "      <td>142.0</td>\n",
       "      <td>27.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>2006</td>\n",
       "      <td>1st</td>\n",
       "      <td>Fabio Cannavaro [note 16]</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>173.0</td>\n",
       "      <td>41.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>2006</td>\n",
       "      <td>2nd</td>\n",
       "      <td>Gianluigi Buffon</td>\n",
       "      <td>Juventus</td>\n",
       "      <td>124.0</td>\n",
       "      <td>29.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>2006</td>\n",
       "      <td>3rd</td>\n",
       "      <td>Thierry Henry</td>\n",
       "      <td>Arsenal</td>\n",
       "      <td>121.0</td>\n",
       "      <td>28.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>2007</td>\n",
       "      <td>1st</td>\n",
       "      <td>Kaká</td>\n",
       "      <td>Milan</td>\n",
       "      <td>444.0</td>\n",
       "      <td>45.49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>2007</td>\n",
       "      <td>2nd</td>\n",
       "      <td>Cristiano Ronaldo</td>\n",
       "      <td>Manchester United</td>\n",
       "      <td>277.0</td>\n",
       "      <td>28.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>2007</td>\n",
       "      <td>3rd</td>\n",
       "      <td>Lionel Messi</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>255.0</td>\n",
       "      <td>26.13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>2008</td>\n",
       "      <td>1st</td>\n",
       "      <td>Cristiano Ronaldo</td>\n",
       "      <td>Manchester United</td>\n",
       "      <td>446.0</td>\n",
       "      <td>49.23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>2008</td>\n",
       "      <td>2nd</td>\n",
       "      <td>Lionel Messi</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>281.0</td>\n",
       "      <td>31.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>2008</td>\n",
       "      <td>3rd</td>\n",
       "      <td>Fernando Torres</td>\n",
       "      <td>Liverpool</td>\n",
       "      <td>179.0</td>\n",
       "      <td>19.76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>2009</td>\n",
       "      <td>1st</td>\n",
       "      <td>Lionel Messi</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>473.0</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>2009</td>\n",
       "      <td>2nd</td>\n",
       "      <td>Cristiano Ronaldo[note 17]</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>233.0</td>\n",
       "      <td>26.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>2009</td>\n",
       "      <td>3rd</td>\n",
       "      <td>Xavi</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>170.0</td>\n",
       "      <td>19.41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>2010</td>\n",
       "      <td>1st</td>\n",
       "      <td>Lionel Messi</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22.65%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>2010</td>\n",
       "      <td>2nd</td>\n",
       "      <td>Andrés Iniesta</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17.36%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>2010</td>\n",
       "      <td>3rd</td>\n",
       "      <td>Xavi</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16.48%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>2011</td>\n",
       "      <td>1st</td>\n",
       "      <td>Lionel Messi</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>NaN</td>\n",
       "      <td>47.88%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>2011</td>\n",
       "      <td>2nd</td>\n",
       "      <td>Cristiano Ronaldo</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21.60%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>2011</td>\n",
       "      <td>3rd</td>\n",
       "      <td>Xavi</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.23%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>2012</td>\n",
       "      <td>1st</td>\n",
       "      <td>Lionel Messi</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.60%</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     year rank                      player               team  points  \\\n",
       "150  2005  2nd               Frank Lampard            Chelsea   148.0   \n",
       "151  2005  3rd              Steven Gerrard          Liverpool   142.0   \n",
       "152  2006  1st   Fabio Cannavaro [note 16]        Real Madrid   173.0   \n",
       "153  2006  2nd            Gianluigi Buffon           Juventus   124.0   \n",
       "154  2006  3rd               Thierry Henry            Arsenal   121.0   \n",
       "155  2007  1st                        Kaká              Milan   444.0   \n",
       "156  2007  2nd           Cristiano Ronaldo  Manchester United   277.0   \n",
       "157  2007  3rd                Lionel Messi          Barcelona   255.0   \n",
       "158  2008  1st           Cristiano Ronaldo  Manchester United   446.0   \n",
       "159  2008  2nd                Lionel Messi          Barcelona   281.0   \n",
       "160  2008  3rd             Fernando Torres          Liverpool   179.0   \n",
       "161  2009  1st                Lionel Messi          Barcelona   473.0   \n",
       "162  2009  2nd  Cristiano Ronaldo[note 17]        Real Madrid   233.0   \n",
       "163  2009  3rd                        Xavi          Barcelona   170.0   \n",
       "164  2010  1st                Lionel Messi          Barcelona     NaN   \n",
       "165  2010  2nd              Andrés Iniesta          Barcelona     NaN   \n",
       "166  2010  3rd                        Xavi          Barcelona     NaN   \n",
       "167  2011  1st                Lionel Messi          Barcelona     NaN   \n",
       "168  2011  2nd           Cristiano Ronaldo        Real Madrid     NaN   \n",
       "169  2011  3rd                        Xavi          Barcelona     NaN   \n",
       "170  2012  1st                Lionel Messi          Barcelona     NaN   \n",
       "\n",
       "    percentages  \n",
       "150       28.74  \n",
       "151       27.57  \n",
       "152       41.39  \n",
       "153       29.67  \n",
       "154       28.95  \n",
       "155       45.49  \n",
       "156       28.38  \n",
       "157       26.13  \n",
       "158       49.23  \n",
       "159       31.02  \n",
       "160       19.76  \n",
       "161          54  \n",
       "162        26.6  \n",
       "163       19.41  \n",
       "164      22.65%  \n",
       "165      17.36%  \n",
       "166      16.48%  \n",
       "167      47.88%  \n",
       "168      21.60%  \n",
       "169       9.23%  \n",
       "170      41.60%  "
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[150:170]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Supprimer le '%' dans la colonne percentages"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "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>year</th>\n",
       "      <th>rank</th>\n",
       "      <th>player</th>\n",
       "      <th>team</th>\n",
       "      <th>points</th>\n",
       "      <th>percentages</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>1967</td>\n",
       "      <td>2nd</td>\n",
       "      <td>Bobby Charlton</td>\n",
       "      <td>Manchester United</td>\n",
       "      <td>40.0</td>\n",
       "      <td>27.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>2005</td>\n",
       "      <td>2nd</td>\n",
       "      <td>Frank Lampard</td>\n",
       "      <td>Chelsea</td>\n",
       "      <td>148.0</td>\n",
       "      <td>28.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>2008</td>\n",
       "      <td>1st</td>\n",
       "      <td>Cristiano Ronaldo</td>\n",
       "      <td>Manchester United</td>\n",
       "      <td>446.0</td>\n",
       "      <td>49.23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1958</td>\n",
       "      <td>3rd</td>\n",
       "      <td>Just Fontaine</td>\n",
       "      <td>Stade de Reims</td>\n",
       "      <td>23.0</td>\n",
       "      <td>17.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>1978</td>\n",
       "      <td>3rd</td>\n",
       "      <td>Rob Rensenbrink</td>\n",
       "      <td>Anderlecht</td>\n",
       "      <td>50.0</td>\n",
       "      <td>22.94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>1973</td>\n",
       "      <td>1st</td>\n",
       "      <td>Johan Cruyff[note 3]</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>96.0</td>\n",
       "      <td>51.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>1976</td>\n",
       "      <td>2nd</td>\n",
       "      <td>Rob Rensenbrink</td>\n",
       "      <td>Anderlecht</td>\n",
       "      <td>75.0</td>\n",
       "      <td>34.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>1982</td>\n",
       "      <td>1st</td>\n",
       "      <td>Paolo Rossi</td>\n",
       "      <td>Juventus</td>\n",
       "      <td>115.0</td>\n",
       "      <td>52.75</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     year rank                player               team  points percentages\n",
       "35   1967  2nd        Bobby Charlton  Manchester United    40.0       27.21\n",
       "150  2005  2nd         Frank Lampard            Chelsea   148.0       28.74\n",
       "158  2008  1st     Cristiano Ronaldo  Manchester United   446.0       49.23\n",
       "9    1958  3rd         Just Fontaine     Stade de Reims    23.0       17.16\n",
       "69   1978  3rd       Rob Rensenbrink         Anderlecht    50.0       22.94\n",
       "52   1973  1st  Johan Cruyff[note 3]          Barcelona    96.0       51.34\n",
       "62   1976  2nd       Rob Rensenbrink         Anderlecht    75.0        34.4\n",
       "79   1982  1st           Paolo Rossi           Juventus   115.0       52.75"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cleanig_percentages = lambda elem: str(elem)[:str(elem).find('%')] if str(elem).endswith('%') else elem\n",
    "df['percentages'] = df['percentages'].apply(cleanig_percentages)\n",
    "df.sample(n=8)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### certains valeur de player contien des [ not..] \n",
    "\n",
    "nous allons les supprimer"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "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>year</th>\n",
       "      <th>rank</th>\n",
       "      <th>player</th>\n",
       "      <th>team</th>\n",
       "      <th>points</th>\n",
       "      <th>percentages</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>1991</td>\n",
       "      <td>1st</td>\n",
       "      <td>Jean-Pierre Papin</td>\n",
       "      <td>Marseille</td>\n",
       "      <td>141.0</td>\n",
       "      <td>52.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>1984</td>\n",
       "      <td>1st</td>\n",
       "      <td>Michel Platini</td>\n",
       "      <td>Juventus</td>\n",
       "      <td>110.0</td>\n",
       "      <td>51.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>2015</td>\n",
       "      <td>3rd</td>\n",
       "      <td>Neymar</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1956</td>\n",
       "      <td>1st</td>\n",
       "      <td>Stanley Matthews</td>\n",
       "      <td>Blackpool</td>\n",
       "      <td>47.0</td>\n",
       "      <td>37.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>2008</td>\n",
       "      <td>1st</td>\n",
       "      <td>Cristiano Ronaldo</td>\n",
       "      <td>Manchester United</td>\n",
       "      <td>446.0</td>\n",
       "      <td>49.23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1960</td>\n",
       "      <td>3rd</td>\n",
       "      <td>Uwe Seeler</td>\n",
       "      <td>Hamburg</td>\n",
       "      <td>33.0</td>\n",
       "      <td>26.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>178</th>\n",
       "      <td>2014</td>\n",
       "      <td>3rd</td>\n",
       "      <td>Manuel Neuer</td>\n",
       "      <td>Bayern Munich</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1965</td>\n",
       "      <td>2nd</td>\n",
       "      <td>Giacinto Facchetti</td>\n",
       "      <td>Internazionale</td>\n",
       "      <td>59.0</td>\n",
       "      <td>34.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>1982</td>\n",
       "      <td>2nd</td>\n",
       "      <td>Alain Giresse</td>\n",
       "      <td>Bordeaux</td>\n",
       "      <td>64.0</td>\n",
       "      <td>29.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>2000</td>\n",
       "      <td>1st</td>\n",
       "      <td>Luís Figo</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>197.0</td>\n",
       "      <td>42.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>1999</td>\n",
       "      <td>3rd</td>\n",
       "      <td>Andriy Shevchenko</td>\n",
       "      <td>Milan</td>\n",
       "      <td>64.0</td>\n",
       "      <td>14.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1958</td>\n",
       "      <td>3rd</td>\n",
       "      <td>Just Fontaine</td>\n",
       "      <td>Stade de Reims</td>\n",
       "      <td>23.0</td>\n",
       "      <td>17.16</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     year rank              player               team  points percentages\n",
       "106  1991  1st   Jean-Pierre Papin          Marseille   141.0       52.81\n",
       "85   1984  1st      Michel Platini           Juventus   110.0       51.16\n",
       "181  2015  3rd              Neymar          Barcelona     NaN        7.86\n",
       "0    1956  1st    Stanley Matthews          Blackpool    47.0        37.9\n",
       "158  2008  1st   Cristiano Ronaldo  Manchester United   446.0       49.23\n",
       "15   1960  3rd          Uwe Seeler            Hamburg    33.0       26.61\n",
       "178  2014  3rd        Manuel Neuer      Bayern Munich     NaN       15.72\n",
       "29   1965  2nd  Giacinto Facchetti     Internazionale    59.0        34.5\n",
       "80   1982  2nd       Alain Giresse           Bordeaux    64.0       29.36\n",
       "134  2000  1st           Luís Figo        Real Madrid   197.0       42.55\n",
       "133  1999  3rd   Andriy Shevchenko              Milan    64.0       14.65\n",
       "9    1958  3rd       Just Fontaine     Stade de Reims    23.0       17.16"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# s'il contient, retourner les carcteres avant les corchets, sinon retourner toute la chaine\n",
    "df['player'] = df['player'].apply(lambda elem: elem[:elem.find('[')] if elem.find('[') >= 0 else elem)\n",
    "df.sample(n=12)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Afficher les 10 dernieres lignes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "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>year</th>\n",
       "      <th>rank</th>\n",
       "      <th>player</th>\n",
       "      <th>team</th>\n",
       "      <th>points</th>\n",
       "      <th>percentages</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>2016</td>\n",
       "      <td>3rd</td>\n",
       "      <td>Antoine Griezmann</td>\n",
       "      <td>Atlético Madrid</td>\n",
       "      <td>198.0</td>\n",
       "      <td>15.73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>2017</td>\n",
       "      <td>1st</td>\n",
       "      <td>Cristiano Ronaldo</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>946.0</td>\n",
       "      <td>47.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186</th>\n",
       "      <td>2017</td>\n",
       "      <td>2nd</td>\n",
       "      <td>Lionel Messi</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>670.0</td>\n",
       "      <td>33.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187</th>\n",
       "      <td>2017</td>\n",
       "      <td>3rd</td>\n",
       "      <td>Neymar</td>\n",
       "      <td>Paris Saint-Germain</td>\n",
       "      <td>361.0</td>\n",
       "      <td>18.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>2018</td>\n",
       "      <td>1st</td>\n",
       "      <td>Luka Modrić</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>753.0</td>\n",
       "      <td>45.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189</th>\n",
       "      <td>2018</td>\n",
       "      <td>2nd</td>\n",
       "      <td>Cristiano Ronaldo</td>\n",
       "      <td>Juventus</td>\n",
       "      <td>476.0</td>\n",
       "      <td>28.97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>190</th>\n",
       "      <td>2018</td>\n",
       "      <td>3rd</td>\n",
       "      <td>Antoine Griezmann</td>\n",
       "      <td>Atlético Madrid</td>\n",
       "      <td>414.0</td>\n",
       "      <td>25.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191</th>\n",
       "      <td>2019</td>\n",
       "      <td>1st</td>\n",
       "      <td>Lionel Messi</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>686.0</td>\n",
       "      <td>37.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>192</th>\n",
       "      <td>2019</td>\n",
       "      <td>2nd</td>\n",
       "      <td>Virgil van Dijk</td>\n",
       "      <td>Liverpool</td>\n",
       "      <td>679.0</td>\n",
       "      <td>36.88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>193</th>\n",
       "      <td>2019</td>\n",
       "      <td>3rd</td>\n",
       "      <td>Cristiano Ronaldo</td>\n",
       "      <td>Juventus</td>\n",
       "      <td>476.0</td>\n",
       "      <td>25.86</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     year rank             player                 team  points percentages\n",
       "184  2016  3rd  Antoine Griezmann      Atlético Madrid   198.0       15.73\n",
       "185  2017  1st  Cristiano Ronaldo          Real Madrid   946.0       47.85\n",
       "186  2017  2nd       Lionel Messi            Barcelona   670.0       33.89\n",
       "187  2017  3rd             Neymar  Paris Saint-Germain   361.0       18.26\n",
       "188  2018  1st        Luka Modrić          Real Madrid   753.0       45.83\n",
       "189  2018  2nd  Cristiano Ronaldo             Juventus   476.0       28.97\n",
       "190  2018  3rd  Antoine Griezmann      Atlético Madrid   414.0        25.2\n",
       "191  2019  1st       Lionel Messi            Barcelona   686.0       37.26\n",
       "192  2019  2nd    Virgil van Dijk            Liverpool   679.0       36.88\n",
       "193  2019  3rd  Cristiano Ronaldo             Juventus   476.0       25.86"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.tail(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Enregistrement des dans des fichiers csv et excel\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv('data/cleaned/ballon-d-or.csv')\n",
    "df.to_excel('data/cleaned/ballon-d-or.xlsx')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}