Data_summary_results.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "d66d816d",
   "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>Player</th>\n",
       "      <th>Salary</th>\n",
       "      <th>rf</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Fábio Carvalho</td>\n",
       "      <td>1664000</td>\n",
       "      <td>8132160.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Kalvin  Phillips</td>\n",
       "      <td>8320000</td>\n",
       "      <td>5856920.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Denis Zakaria</td>\n",
       "      <td>2704000</td>\n",
       "      <td>4543080.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Lewis O'Brien</td>\n",
       "      <td>156000</td>\n",
       "      <td>6990400.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Jesse Lingard</td>\n",
       "      <td>5200000</td>\n",
       "      <td>2953160.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Orel Mangala</td>\n",
       "      <td>3134560</td>\n",
       "      <td>3050880.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Cheikhou Kouyate</td>\n",
       "      <td>3484000</td>\n",
       "      <td>2749080.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Remo Freuler</td>\n",
       "      <td>2236000</td>\n",
       "      <td>5426400.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Ivan Perišić</td>\n",
       "      <td>9360000</td>\n",
       "      <td>6202400.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Yves Bissouma</td>\n",
       "      <td>4472000</td>\n",
       "      <td>3255200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Fàbio Vieira</td>\n",
       "      <td>4264000</td>\n",
       "      <td>4984480.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Christian Eriksen</td>\n",
       "      <td>8840000</td>\n",
       "      <td>3536040.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Casemiro</td>\n",
       "      <td>15600000</td>\n",
       "      <td>4731120.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Amadou Onana</td>\n",
       "      <td>1976000</td>\n",
       "      <td>1960960.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>James Garner</td>\n",
       "      <td>2008000</td>\n",
       "      <td>5189600.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Idrissa Gueye</td>\n",
       "      <td>6760000</td>\n",
       "      <td>7483600.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>João Palhinha</td>\n",
       "      <td>2140000</td>\n",
       "      <td>3430800.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Andreas Pereira</td>\n",
       "      <td>2080000</td>\n",
       "      <td>6756000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Flynn Downes</td>\n",
       "      <td>1300000</td>\n",
       "      <td>6305760.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Lucas Paquetá</td>\n",
       "      <td>7800000</td>\n",
       "      <td>8064400.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Billy Gilmour</td>\n",
       "      <td>2250000</td>\n",
       "      <td>3540180.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Boubacar Kamara</td>\n",
       "      <td>7800000</td>\n",
       "      <td>5158400.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Leander Dendoncker</td>\n",
       "      <td>4680000</td>\n",
       "      <td>2356440.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Ainsley Maitland-Niles</td>\n",
       "      <td>2704000</td>\n",
       "      <td>2638640.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Matheus Luiz Nunes</td>\n",
       "      <td>4420000</td>\n",
       "      <td>6081920.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Boubacar Traoré</td>\n",
       "      <td>260000</td>\n",
       "      <td>4568180.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Cheick Oumar Doucouré</td>\n",
       "      <td>2444000</td>\n",
       "      <td>5735600.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Arthur Melo</td>\n",
       "      <td>6552000</td>\n",
       "      <td>4341348.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Player    Salary         rf\n",
       "0           Fábio Carvalho   1664000  8132160.0\n",
       "1         Kalvin  Phillips   8320000  5856920.0\n",
       "2            Denis Zakaria   2704000  4543080.0\n",
       "3            Lewis O'Brien    156000  6990400.0\n",
       "4            Jesse Lingard   5200000  2953160.0\n",
       "5             Orel Mangala   3134560  3050880.0\n",
       "6         Cheikhou Kouyate   3484000  2749080.0\n",
       "7             Remo Freuler   2236000  5426400.0\n",
       "8             Ivan Perišić   9360000  6202400.0\n",
       "9            Yves Bissouma   4472000  3255200.0\n",
       "10            Fàbio Vieira   4264000  4984480.0\n",
       "11       Christian Eriksen   8840000  3536040.0\n",
       "12                Casemiro  15600000  4731120.0\n",
       "13            Amadou Onana   1976000  1960960.0\n",
       "14            James Garner   2008000  5189600.0\n",
       "15           Idrissa Gueye   6760000  7483600.0\n",
       "16           João Palhinha   2140000  3430800.0\n",
       "17         Andreas Pereira   2080000  6756000.0\n",
       "18            Flynn Downes   1300000  6305760.0\n",
       "19           Lucas Paquetá   7800000  8064400.0\n",
       "20           Billy Gilmour   2250000  3540180.0\n",
       "21         Boubacar Kamara   7800000  5158400.0\n",
       "22      Leander Dendoncker   4680000  2356440.0\n",
       "23  Ainsley Maitland-Niles   2704000  2638640.0\n",
       "24      Matheus Luiz Nunes   4420000  6081920.0\n",
       "25         Boubacar Traoré    260000  4568180.0\n",
       "26   Cheick Oumar Doucouré   2444000  5735600.0\n",
       "27             Arthur Melo   6552000  4341348.0"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "midfielder = pd.read_csv('midfielder_df.csv', index_col=0)\n",
    "midfielder"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "756e24e8",
   "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>Player</th>\n",
       "      <th>Salary</th>\n",
       "      <th>Expectation</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Darwin Núñez</td>\n",
       "      <td>7280000.0</td>\n",
       "      <td>5594883.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Raheem Sterling</td>\n",
       "      <td>16900000.0</td>\n",
       "      <td>3744241.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Aubameyang</td>\n",
       "      <td>8320000.0</td>\n",
       "      <td>7131600.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Taiwo Awoniyi</td>\n",
       "      <td>2184000.0</td>\n",
       "      <td>4903575.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Emmanuel Dennis</td>\n",
       "      <td>2184000.0</td>\n",
       "      <td>3771800.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Hwang Ui-jo</td>\n",
       "      <td>1800000.0</td>\n",
       "      <td>4166848.96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>josh Bowler</td>\n",
       "      <td>1560000.0</td>\n",
       "      <td>1806466.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Richarlison</td>\n",
       "      <td>4680000.0</td>\n",
       "      <td>4394200.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Marcus Vinicius Oliveira Alencar</td>\n",
       "      <td>1560000.0</td>\n",
       "      <td>2586660.32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Gabriel Jesus</td>\n",
       "      <td>13780000.0</td>\n",
       "      <td>10092560.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Antony Matheus Dos Santos</td>\n",
       "      <td>10400000.0</td>\n",
       "      <td>9885572.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Neal Maupay</td>\n",
       "      <td>2600000.0</td>\n",
       "      <td>2615000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Dwight McNeil</td>\n",
       "      <td>1300000.0</td>\n",
       "      <td>7536346.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Luis Sinisterra</td>\n",
       "      <td>520000.0</td>\n",
       "      <td>11559720.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Willian Borges da Silva</td>\n",
       "      <td>4420000.0</td>\n",
       "      <td>3979920.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Carlos Vinícius</td>\n",
       "      <td>440167.0</td>\n",
       "      <td>5760950.88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Daniel James</td>\n",
       "      <td>2704000.0</td>\n",
       "      <td>3938626.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Hwang Hee-Chan</td>\n",
       "      <td>1560000.0</td>\n",
       "      <td>2553160.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Gonçalo Manuel Ganchinho Guedes</td>\n",
       "      <td>4732000.0</td>\n",
       "      <td>4606880.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Alexander Isak</td>\n",
       "      <td>6240000.0</td>\n",
       "      <td>2178506.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Malcolm Perewari Ebiowei</td>\n",
       "      <td>1300000.0</td>\n",
       "      <td>2601657.28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>​</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                               Player      Salary  Expectation\n",
       "0                        Darwin Núñez   7280000.0   5594883.72\n",
       "1                     Raheem Sterling  16900000.0   3744241.86\n",
       "2                          Aubameyang   8320000.0   7131600.00\n",
       "3                       Taiwo Awoniyi   2184000.0   4903575.04\n",
       "4                     Emmanuel Dennis   2184000.0   3771800.00\n",
       "5                         Hwang Ui-jo   1800000.0   4166848.96\n",
       "6                         josh Bowler   1560000.0   1806466.40\n",
       "7                         Richarlison   4680000.0   4394200.00\n",
       "8    Marcus Vinicius Oliveira Alencar   1560000.0   2586660.32\n",
       "9                       Gabriel Jesus  13780000.0  10092560.00\n",
       "10          Antony Matheus Dos Santos  10400000.0   9885572.80\n",
       "11                        Neal Maupay   2600000.0   2615000.00\n",
       "12                      Dwight McNeil   1300000.0   7536346.40\n",
       "13                    Luis Sinisterra    520000.0  11559720.00\n",
       "14            Willian Borges da Silva   4420000.0   3979920.00\n",
       "15                    Carlos Vinícius    440167.0   5760950.88\n",
       "16                       Daniel James   2704000.0   3938626.40\n",
       "17                     Hwang Hee-Chan   1560000.0   2553160.00\n",
       "18    Gonçalo Manuel Ganchinho Guedes   4732000.0   4606880.00\n",
       "19                     Alexander Isak   6240000.0   2178506.40\n",
       "20           Malcolm Perewari Ebiowei   1300000.0   2601657.28\n",
       "NaN                               NaN         NaN          NaN\n",
       "​                                 NaN         NaN          NaN"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "forward = pd.read_csv('forward_df.csv', index_col=0)\n",
    "forward"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "76a89997",
   "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>Player</th>\n",
       "      <th>Salary</th>\n",
       "      <th>Expectation</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Darwin Núñez</td>\n",
       "      <td>7280000.0</td>\n",
       "      <td>5594883.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Raheem Sterling</td>\n",
       "      <td>16900000.0</td>\n",
       "      <td>3744241.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Aubameyang</td>\n",
       "      <td>8320000.0</td>\n",
       "      <td>7131600.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Taiwo Awoniyi</td>\n",
       "      <td>2184000.0</td>\n",
       "      <td>4903575.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Emmanuel Dennis</td>\n",
       "      <td>2184000.0</td>\n",
       "      <td>3771800.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Hwang Ui-jo</td>\n",
       "      <td>1800000.0</td>\n",
       "      <td>4166848.96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>josh Bowler</td>\n",
       "      <td>1560000.0</td>\n",
       "      <td>1806466.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Richarlison</td>\n",
       "      <td>4680000.0</td>\n",
       "      <td>4394200.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Marcus Vinicius Oliveira Alencar</td>\n",
       "      <td>1560000.0</td>\n",
       "      <td>2586660.32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Gabriel Jesus</td>\n",
       "      <td>13780000.0</td>\n",
       "      <td>10092560.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Antony Matheus Dos Santos</td>\n",
       "      <td>10400000.0</td>\n",
       "      <td>9885572.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Neal Maupay</td>\n",
       "      <td>2600000.0</td>\n",
       "      <td>2615000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Dwight McNeil</td>\n",
       "      <td>1300000.0</td>\n",
       "      <td>7536346.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Luis Sinisterra</td>\n",
       "      <td>520000.0</td>\n",
       "      <td>11559720.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Willian Borges da Silva</td>\n",
       "      <td>4420000.0</td>\n",
       "      <td>3979920.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Carlos Vinícius</td>\n",
       "      <td>440167.0</td>\n",
       "      <td>5760950.88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Daniel James</td>\n",
       "      <td>2704000.0</td>\n",
       "      <td>3938626.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Hwang Hee-Chan</td>\n",
       "      <td>1560000.0</td>\n",
       "      <td>2553160.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Gonçalo Manuel Ganchinho Guedes</td>\n",
       "      <td>4732000.0</td>\n",
       "      <td>4606880.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Alexander Isak</td>\n",
       "      <td>6240000.0</td>\n",
       "      <td>2178506.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Malcolm Perewari Ebiowei</td>\n",
       "      <td>1300000.0</td>\n",
       "      <td>2601657.28</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                              Player      Salary  Expectation\n",
       "0                       Darwin Núñez   7280000.0   5594883.72\n",
       "1                    Raheem Sterling  16900000.0   3744241.86\n",
       "2                         Aubameyang   8320000.0   7131600.00\n",
       "3                      Taiwo Awoniyi   2184000.0   4903575.04\n",
       "4                    Emmanuel Dennis   2184000.0   3771800.00\n",
       "5                        Hwang Ui-jo   1800000.0   4166848.96\n",
       "6                        josh Bowler   1560000.0   1806466.40\n",
       "7                        Richarlison   4680000.0   4394200.00\n",
       "8   Marcus Vinicius Oliveira Alencar   1560000.0   2586660.32\n",
       "9                      Gabriel Jesus  13780000.0  10092560.00\n",
       "10         Antony Matheus Dos Santos  10400000.0   9885572.80\n",
       "11                       Neal Maupay   2600000.0   2615000.00\n",
       "12                     Dwight McNeil   1300000.0   7536346.40\n",
       "13                   Luis Sinisterra    520000.0  11559720.00\n",
       "14           Willian Borges da Silva   4420000.0   3979920.00\n",
       "15                   Carlos Vinícius    440167.0   5760950.88\n",
       "16                      Daniel James   2704000.0   3938626.40\n",
       "17                    Hwang Hee-Chan   1560000.0   2553160.00\n",
       "18   Gonçalo Manuel Ganchinho Guedes   4732000.0   4606880.00\n",
       "19                    Alexander Isak   6240000.0   2178506.40\n",
       "20          Malcolm Perewari Ebiowei   1300000.0   2601657.28"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "forward =forward.dropna(how = 'all')\n",
    "forward"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "647670ec",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0      1685116.28000\n",
      "1     13155758.14000\n",
      "2      1188400.00000\n",
      "3     -2719575.04000\n",
      "4     -1587800.00000\n",
      "5     -2366848.96000\n",
      "6      -246466.40000\n",
      "7       285800.00000\n",
      "8     -1026660.32000\n",
      "9      3687440.00000\n",
      "10      514427.20000\n",
      "11      -15000.00000\n",
      "12    -6236346.40000\n",
      "13   -11039720.00000\n",
      "14      440080.00000\n",
      "15    -5320783.88000\n",
      "16    -1234626.40000\n",
      "17     -993160.00000\n",
      "18      125120.00000\n",
      "19     4061493.60000\n",
      "20    -1301657.28000\n",
      "dtype: float64\n"
     ]
    }
   ],
   "source": [
    "sub_forward = forward[\"Salary\"] - forward[\"Expectation\"]\n",
    "print(sub_forward)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "87743b24",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0     1685116.28000\n",
       "1    13155758.14000\n",
       "2     1188400.00000\n",
       "3     2719575.04000\n",
       "4     1587800.00000\n",
       "5     2366848.96000\n",
       "6      246466.40000\n",
       "7      285800.00000\n",
       "8     1026660.32000\n",
       "9     3687440.00000\n",
       "10     514427.20000\n",
       "11      15000.00000\n",
       "12    6236346.40000\n",
       "13   11039720.00000\n",
       "14     440080.00000\n",
       "15    5320783.88000\n",
       "16    1234626.40000\n",
       "17     993160.00000\n",
       "18     125120.00000\n",
       "19    4061493.60000\n",
       "20    1301657.28000\n",
       "dtype: float64"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "abs_forward=sub_forward.abs()\n",
    "abs_forward"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "45b600ac",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0    -6468160.00000\n",
      "1     2463080.00000\n",
      "2    -1839080.00000\n",
      "3    -6834400.00000\n",
      "4     2246840.00000\n",
      "5       83680.00000\n",
      "6      734920.00000\n",
      "7    -3190400.00000\n",
      "8     3157600.00000\n",
      "9     1216800.00000\n",
      "10    -720480.00000\n",
      "11    5303960.00000\n",
      "12   10868880.00000\n",
      "13      15040.00000\n",
      "14   -3181600.00000\n",
      "15    -723600.00000\n",
      "16   -1290800.00000\n",
      "17   -4676000.00000\n",
      "18   -5005760.00000\n",
      "19    -264400.00000\n",
      "20   -1290180.00000\n",
      "21    2641600.00000\n",
      "22    2323560.00000\n",
      "23      65360.00000\n",
      "24   -1661920.00000\n",
      "25   -4308180.00000\n",
      "26   -3291600.00000\n",
      "27    2210652.00000\n",
      "dtype: float64\n"
     ]
    }
   ],
   "source": [
    "sub_midfielder = midfielder[\"Salary\"] - midfielder[\"rf\"]\n",
    "print(sub_midfielder)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "b72ec2dd",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0     6468160.00000\n",
       "1     2463080.00000\n",
       "2     1839080.00000\n",
       "3     6834400.00000\n",
       "4     2246840.00000\n",
       "5       83680.00000\n",
       "6      734920.00000\n",
       "7     3190400.00000\n",
       "8     3157600.00000\n",
       "9     1216800.00000\n",
       "10     720480.00000\n",
       "11    5303960.00000\n",
       "12   10868880.00000\n",
       "13      15040.00000\n",
       "14    3181600.00000\n",
       "15     723600.00000\n",
       "16    1290800.00000\n",
       "17    4676000.00000\n",
       "18    5005760.00000\n",
       "19     264400.00000\n",
       "20    1290180.00000\n",
       "21    2641600.00000\n",
       "22    2323560.00000\n",
       "23      65360.00000\n",
       "24    1661920.00000\n",
       "25    4308180.00000\n",
       "26    3291600.00000\n",
       "27    2210652.00000\n",
       "dtype: float64"
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "abs_midfielder=sub_midfielder.abs()\n",
    "abs_midfielder"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "b741545a",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "count          21.00000\n",
       "mean      -425952.83143\n",
       "std       4550173.88311\n",
       "min     -11039720.00000\n",
       "25%      -1587800.00000\n",
       "50%       -246466.40000\n",
       "75%        514427.20000\n",
       "max      13155758.14000\n",
       "dtype: float64"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "\n",
    "pd.options.display.float_format = '{:.5f}'.format\n",
    "\n",
    "sub_forward.describe() #포워드 \"연봉 -예측값\" describe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "2d8c4c61",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "count         28.00000\n",
       "mean     -407663.85714\n",
       "std      3740397.15997\n",
       "min     -6834400.00000\n",
       "25%     -3183800.00000\n",
       "50%      -492440.00000\n",
       "75%      2219699.00000\n",
       "max     10868880.00000\n",
       "dtype: float64"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sub_midfielder.describe() # 미드필더 \"연봉 -예측값\" describe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "id": "e4bb0d47",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "count         21.00000\n",
       "mean     2820584.75714\n",
       "std      3541342.49700\n",
       "min        15000.00000\n",
       "25%       514427.20000\n",
       "50%      1301657.28000\n",
       "75%      3687440.00000\n",
       "max     13155758.14000\n",
       "dtype: float64"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "abs_forward.describe() #포워드 \"|연봉 -예측값|\" describe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "4e9a02e3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "count         28.00000\n",
       "mean     2788519.00000\n",
       "std      2469632.29895\n",
       "min        15040.00000\n",
       "25%      1096330.00000\n",
       "50%      2285200.00000\n",
       "75%      3545745.00000\n",
       "max     10868880.00000\n",
       "dtype: float64"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "abs_midfielder.describe() # 미드필더 \"|연봉 -예측값|\" describe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f429a3ea",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.9.12"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}