codes/final_query.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "players = pd.read_csv(\"../data/players.csv\")\n",
    "teams = pd.read_csv(\"../data/teams.csv\")"
   ]
  },
  {
   "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>player</th>\n",
       "      <th>position</th>\n",
       "      <th>team</th>\n",
       "      <th>shirt_number</th>\n",
       "      <th>dob</th>\n",
       "      <th>age</th>\n",
       "      <th>height</th>\n",
       "      <th>strong_foot</th>\n",
       "      <th>date_joined</th>\n",
       "      <th>date_contract</th>\n",
       "      <th>market_value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Thibaut Courtois</td>\n",
       "      <td>Goalkeeper</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>1</td>\n",
       "      <td>May 11, 1992</td>\n",
       "      <td>30</td>\n",
       "      <td>2.00m</td>\n",
       "      <td>left</td>\n",
       "      <td>Aug 9, 2018</td>\n",
       "      <td>Jun 30, 2026</td>\n",
       "      <td>€60.00m</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Andriy Lunin</td>\n",
       "      <td>Goalkeeper</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>13</td>\n",
       "      <td>Feb 11, 1999</td>\n",
       "      <td>23</td>\n",
       "      <td>1.91m</td>\n",
       "      <td>right</td>\n",
       "      <td>Jul 1, 2018</td>\n",
       "      <td>Jun 30, 2024</td>\n",
       "      <td>€2.50m</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Éder Militão</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>3</td>\n",
       "      <td>Jan 18, 1998</td>\n",
       "      <td>24</td>\n",
       "      <td>1.86m</td>\n",
       "      <td>right</td>\n",
       "      <td>Jul 1, 2019</td>\n",
       "      <td>Jun 30, 2025</td>\n",
       "      <td>€60.00m</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>David Alaba</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>4</td>\n",
       "      <td>Jun 24, 1992</td>\n",
       "      <td>30</td>\n",
       "      <td>1.80m</td>\n",
       "      <td>left</td>\n",
       "      <td>Jul 1, 2021</td>\n",
       "      <td>Jun 30, 2026</td>\n",
       "      <td>€55.00m</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Antonio Rüdiger</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>22</td>\n",
       "      <td>Mar 3, 1993</td>\n",
       "      <td>29</td>\n",
       "      <td>1.90m</td>\n",
       "      <td>right</td>\n",
       "      <td>Jul 1, 2022</td>\n",
       "      <td>Jun 30, 2026</td>\n",
       "      <td>€40.00m</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             player     position         team shirt_number           dob  age  \\\n",
       "0  Thibaut Courtois   Goalkeeper  Real Madrid            1  May 11, 1992   30   \n",
       "1      Andriy Lunin   Goalkeeper  Real Madrid           13  Feb 11, 1999   23   \n",
       "2      Éder Militão  Centre-Back  Real Madrid            3  Jan 18, 1998   24   \n",
       "3       David Alaba  Centre-Back  Real Madrid            4  Jun 24, 1992   30   \n",
       "4   Antonio Rüdiger  Centre-Back  Real Madrid           22   Mar 3, 1993   29   \n",
       "\n",
       "  height strong_foot  date_joined date_contract market_value  \n",
       "0  2.00m        left  Aug 9, 2018  Jun 30, 2026      €60.00m  \n",
       "1  1.91m       right  Jul 1, 2018  Jun 30, 2024       €2.50m  \n",
       "2  1.86m       right  Jul 1, 2019  Jun 30, 2025      €60.00m  \n",
       "3  1.80m        left  Jul 1, 2021  Jun 30, 2026      €55.00m  \n",
       "4  1.90m       right  Jul 1, 2022  Jun 30, 2026      €40.00m  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "players.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "def convert_numeric_abbr(s):\n",
    "    mapping = {'k': 1000, 'm': 1000000, 'b': 1000000000}\n",
    "    # Do a check first so it doesn't choke on valid floats     \n",
    "    if s[-1].isalpha():\n",
    "        return float(s[:-1]) * mapping[s[-1].lower()]\n",
    "\n",
    "    return float(s)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Wrangling data before moving towards analysis\n",
    "# we wont be able to sum the market value as it is not an int \n",
    "players['market_value'] = players[\"market_value\"].apply(lambda x: x.replace(\"€\",\"\"))\n",
    "players['market_value'] = players[\"market_value\"].apply(lambda x: convert_numeric_abbr(x))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>position</th>\n",
       "      <th>team</th>\n",
       "      <th>shirt_number</th>\n",
       "      <th>dob</th>\n",
       "      <th>age</th>\n",
       "      <th>height</th>\n",
       "      <th>strong_foot</th>\n",
       "      <th>date_joined</th>\n",
       "      <th>date_contract</th>\n",
       "      <th>market_value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Thibaut Courtois</td>\n",
       "      <td>Goalkeeper</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>1</td>\n",
       "      <td>May 11, 1992</td>\n",
       "      <td>30</td>\n",
       "      <td>2.00m</td>\n",
       "      <td>left</td>\n",
       "      <td>Aug 9, 2018</td>\n",
       "      <td>Jun 30, 2026</td>\n",
       "      <td>60000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Andriy Lunin</td>\n",
       "      <td>Goalkeeper</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>13</td>\n",
       "      <td>Feb 11, 1999</td>\n",
       "      <td>23</td>\n",
       "      <td>1.91m</td>\n",
       "      <td>right</td>\n",
       "      <td>Jul 1, 2018</td>\n",
       "      <td>Jun 30, 2024</td>\n",
       "      <td>2500000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Éder Militão</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>3</td>\n",
       "      <td>Jan 18, 1998</td>\n",
       "      <td>24</td>\n",
       "      <td>1.86m</td>\n",
       "      <td>right</td>\n",
       "      <td>Jul 1, 2019</td>\n",
       "      <td>Jun 30, 2025</td>\n",
       "      <td>60000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>David Alaba</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>4</td>\n",
       "      <td>Jun 24, 1992</td>\n",
       "      <td>30</td>\n",
       "      <td>1.80m</td>\n",
       "      <td>left</td>\n",
       "      <td>Jul 1, 2021</td>\n",
       "      <td>Jun 30, 2026</td>\n",
       "      <td>55000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Antonio Rüdiger</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>22</td>\n",
       "      <td>Mar 3, 1993</td>\n",
       "      <td>29</td>\n",
       "      <td>1.90m</td>\n",
       "      <td>right</td>\n",
       "      <td>Jul 1, 2022</td>\n",
       "      <td>Jun 30, 2026</td>\n",
       "      <td>40000000.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             player     position         team shirt_number           dob  age  \\\n",
       "0  Thibaut Courtois   Goalkeeper  Real Madrid            1  May 11, 1992   30   \n",
       "1      Andriy Lunin   Goalkeeper  Real Madrid           13  Feb 11, 1999   23   \n",
       "2      Éder Militão  Centre-Back  Real Madrid            3  Jan 18, 1998   24   \n",
       "3       David Alaba  Centre-Back  Real Madrid            4  Jun 24, 1992   30   \n",
       "4   Antonio Rüdiger  Centre-Back  Real Madrid           22   Mar 3, 1993   29   \n",
       "\n",
       "  height strong_foot  date_joined date_contract  market_value  \n",
       "0  2.00m        left  Aug 9, 2018  Jun 30, 2026    60000000.0  \n",
       "1  1.91m       right  Jul 1, 2018  Jun 30, 2024     2500000.0  \n",
       "2  1.86m       right  Jul 1, 2019  Jun 30, 2025    60000000.0  \n",
       "3  1.80m        left  Jul 1, 2021  Jun 30, 2026    55000000.0  \n",
       "4  1.90m       right  Jul 1, 2022  Jun 30, 2026    40000000.0  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "players.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### The Final Required Query"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "final_query = players.groupby([\"team\",\"position\"]).aggregate({\"market_value\":\"sum\"})\n",
    "final_query = final_query.reset_index()\n",
    "final_query.to_csv(\"../data/final_query.csv\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Since we have our required table, let's try to analyse the table a little bit and try to understand which position for which team has the highest market value. This is obviously biased as positions like midfield and forward require more players to play than let's say Goalkeeper. Since there are more players, the total market value would be more for these positions. But it will be interesting to see which team's which position has highest market value."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/aviarora/Desktop/OneDrive - Georgetown University/BCSG test/laliga_data_scrapping/env/lib/python3.10/site-packages/altair/utils/core.py:317: FutureWarning: iteritems is deprecated and will be removed in a future version. Use .items instead.\n",
      "  for col_name, dtype in df.dtypes.iteritems():\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "\n",
       "<div id=\"altair-viz-4f17d45520c64fafaee9a1b8cd64698d\"></div>\n",
       "<script type=\"text/javascript\">\n",
       "  var VEGA_DEBUG = (typeof VEGA_DEBUG == \"undefined\") ? {} : VEGA_DEBUG;\n",
       "  (function(spec, embedOpt){\n",
       "    let outputDiv = document.currentScript.previousElementSibling;\n",
       "    if (outputDiv.id !== \"altair-viz-4f17d45520c64fafaee9a1b8cd64698d\") {\n",
       "      outputDiv = document.getElementById(\"altair-viz-4f17d45520c64fafaee9a1b8cd64698d\");\n",
       "    }\n",
       "    const paths = {\n",
       "      \"vega\": \"https://cdn.jsdelivr.net/npm//vega@5?noext\",\n",
       "      \"vega-lib\": \"https://cdn.jsdelivr.net/npm//vega-lib?noext\",\n",
       "      \"vega-lite\": \"https://cdn.jsdelivr.net/npm//vega-lite@4.17.0?noext\",\n",
       "      \"vega-embed\": \"https://cdn.jsdelivr.net/npm//vega-embed@6?noext\",\n",
       "    };\n",
       "\n",
       "    function maybeLoadScript(lib, version) {\n",
       "      var key = `${lib.replace(\"-\", \"\")}_version`;\n",
       "      return (VEGA_DEBUG[key] == version) ?\n",
       "        Promise.resolve(paths[lib]) :\n",
       "        new Promise(function(resolve, reject) {\n",
       "          var s = document.createElement('script');\n",
       "          document.getElementsByTagName(\"head\")[0].appendChild(s);\n",
       "          s.async = true;\n",
       "          s.onload = () => {\n",
       "            VEGA_DEBUG[key] = version;\n",
       "            return resolve(paths[lib]);\n",
       "          };\n",
       "          s.onerror = () => reject(`Error loading script: ${paths[lib]}`);\n",
       "          s.src = paths[lib];\n",
       "        });\n",
       "    }\n",
       "\n",
       "    function showError(err) {\n",
       "      outputDiv.innerHTML = `<div class=\"error\" style=\"color:red;\">${err}</div>`;\n",
       "      throw err;\n",
       "    }\n",
       "\n",
       "    function displayChart(vegaEmbed) {\n",
       "      vegaEmbed(outputDiv, spec, embedOpt)\n",
       "        .catch(err => showError(`Javascript Error: ${err.message}<br>This usually means there's a typo in your chart specification. See the javascript console for the full traceback.`));\n",
       "    }\n",
       "\n",
       "    if(typeof define === \"function\" && define.amd) {\n",
       "      requirejs.config({paths});\n",
       "      require([\"vega-embed\"], displayChart, err => showError(`Error loading script: ${err.message}`));\n",
       "    } else {\n",
       "      maybeLoadScript(\"vega\", \"5\")\n",
       "        .then(() => maybeLoadScript(\"vega-lite\", \"4.17.0\"))\n",
       "        .then(() => maybeLoadScript(\"vega-embed\", \"6\"))\n",
       "        .catch(showError)\n",
       "        .then(() => displayChart(vegaEmbed));\n",
       "    }\n",
       "  })({\"config\": {\"view\": {\"continuousWidth\": 400, \"continuousHeight\": 300, \"strokeWidth\": 0}, \"axis\": {\"grid\": false}}, \"data\": {\"name\": \"data-cb52d655ef8b310ab66d44ce6b3ed38c\"}, \"mark\": {\"type\": \"bar\", \"width\": 10}, \"encoding\": {\"color\": {\"value\": \"#fbb4ae\"}, \"tooltip\": [{\"field\": \"x\", \"type\": \"nominal\"}], \"x\": {\"field\": \"x\", \"title\": \"Team & Position\", \"type\": \"nominal\"}, \"y\": {\"field\": \"market_value\", \"title\": \"Market value (in \\u20ac)\", \"type\": \"quantitative\"}}, \"selection\": {\"selector002\": {\"type\": \"interval\", \"bind\": \"scales\", \"encodings\": [\"x\", \"y\"]}}, \"title\": {\"text\": [\"Which Team's which positon has the highes market value?\"], \"subtitle\": [\"Plot of total market value of teams and positions\"]}, \"width\": 600, \"$schema\": \"https://vega.github.io/schema/vega-lite/v4.17.0.json\", \"datasets\": {\"data-cb52d655ef8b310ab66d44ce6b3ed38c\": [{\"team\": \"Athletic Bilbao\", \"position\": \"Attacking Midfield\", \"market_value\": 36000000.0, \"x\": \"Athletic BilbaoAttacking Midfield\"}, {\"team\": \"Athletic Bilbao\", \"position\": \"Central Midfield\", \"market_value\": 34500000.0, \"x\": \"Athletic BilbaoCentral Midfield\"}, {\"team\": \"Athletic Bilbao\", \"position\": \"Centre-Back\", \"market_value\": 48400000.0, \"x\": \"Athletic BilbaoCentre-Back\"}, {\"team\": \"Athletic Bilbao\", \"position\": \"Centre-Forward\", \"market_value\": 32500000.0, \"x\": \"Athletic BilbaoCentre-Forward\"}, {\"team\": \"Athletic Bilbao\", \"position\": \"Defensive Midfield\", \"market_value\": 3000000.0, \"x\": \"Athletic BilbaoDefensive Midfield\"}, {\"team\": \"Athletic Bilbao\", \"position\": \"Goalkeeper\", \"market_value\": 30000000.0, \"x\": \"Athletic BilbaoGoalkeeper\"}, {\"team\": \"Athletic Bilbao\", \"position\": \"Left Winger\", \"market_value\": 4000000.0, \"x\": \"Athletic BilbaoLeft Winger\"}, {\"team\": \"Athletic Bilbao\", \"position\": \"Left-Back\", \"market_value\": 4200000.0, \"x\": \"Athletic BilbaoLeft-Back\"}, {\"team\": \"Athletic Bilbao\", \"position\": \"Right Winger\", \"market_value\": 37000000.0, \"x\": \"Athletic BilbaoRight Winger\"}, {\"team\": \"Athletic Bilbao\", \"position\": \"Right-Back\", \"market_value\": 7300000.0, \"x\": \"Athletic BilbaoRight-Back\"}, {\"team\": \"Atl\\u00e9tico de Madrid\", \"position\": \"Attacking Midfield\", \"market_value\": 35000000.0, \"x\": \"Atl\\u00e9tico de MadridAttacking Midfield\"}, {\"team\": \"Atl\\u00e9tico de Madrid\", \"position\": \"Central Midfield\", \"market_value\": 115000000.0, \"x\": \"Atl\\u00e9tico de MadridCentral Midfield\"}, {\"team\": \"Atl\\u00e9tico de Madrid\", \"position\": \"Centre-Back\", \"market_value\": 83000000.0, \"x\": \"Atl\\u00e9tico de MadridCentre-Back\"}, {\"team\": \"Atl\\u00e9tico de Madrid\", \"position\": \"Centre-Forward\", \"market_value\": 55000000.0, \"x\": \"Atl\\u00e9tico de MadridCentre-Forward\"}, {\"team\": \"Atl\\u00e9tico de Madrid\", \"position\": \"Defensive Midfield\", \"market_value\": 25000000.0, \"x\": \"Atl\\u00e9tico de MadridDefensive Midfield\"}, {\"team\": \"Atl\\u00e9tico de Madrid\", \"position\": \"Goalkeeper\", \"market_value\": 43500000.0, \"x\": \"Atl\\u00e9tico de MadridGoalkeeper\"}, {\"team\": \"Atl\\u00e9tico de Madrid\", \"position\": \"Left Winger\", \"market_value\": 40000000.0, \"x\": \"Atl\\u00e9tico de MadridLeft Winger\"}, {\"team\": \"Atl\\u00e9tico de Madrid\", \"position\": \"Left-Back\", \"market_value\": 50000000.0, \"x\": \"Atl\\u00e9tico de MadridLeft-Back\"}, {\"team\": \"Atl\\u00e9tico de Madrid\", \"position\": \"Right Winger\", \"market_value\": 40000000.0, \"x\": \"Atl\\u00e9tico de MadridRight Winger\"}, {\"team\": \"Atl\\u00e9tico de Madrid\", \"position\": \"Right-Back\", \"market_value\": 20000000.0, \"x\": \"Atl\\u00e9tico de MadridRight-Back\"}, {\"team\": \"Atl\\u00e9tico de Madrid\", \"position\": \"Second Striker\", \"market_value\": 105000000.0, \"x\": \"Atl\\u00e9tico de MadridSecond Striker\"}, {\"team\": \"CA Osasuna\", \"position\": \"Attacking Midfield\", \"market_value\": 6000000.0, \"x\": \"CA OsasunaAttacking Midfield\"}, {\"team\": \"CA Osasuna\", \"position\": \"Central Midfield\", \"market_value\": 14400000.0, \"x\": \"CA OsasunaCentral Midfield\"}, {\"team\": \"CA Osasuna\", \"position\": \"Centre-Back\", \"market_value\": 23000000.0, \"x\": \"CA OsasunaCentre-Back\"}, {\"team\": \"CA Osasuna\", \"position\": \"Centre-Forward\", \"market_value\": 17800000.0, \"x\": \"CA OsasunaCentre-Forward\"}, {\"team\": \"CA Osasuna\", \"position\": \"Defensive Midfield\", \"market_value\": 5000000.0, \"x\": \"CA OsasunaDefensive Midfield\"}, {\"team\": \"CA Osasuna\", \"position\": \"Goalkeeper\", \"market_value\": 11100000.0, \"x\": \"CA OsasunaGoalkeeper\"}, {\"team\": \"CA Osasuna\", \"position\": \"Left Winger\", \"market_value\": 24200000.0, \"x\": \"CA OsasunaLeft Winger\"}, {\"team\": \"CA Osasuna\", \"position\": \"Left-Back\", \"market_value\": 12000000.0, \"x\": \"CA OsasunaLeft-Back\"}, {\"team\": \"CA Osasuna\", \"position\": \"Right Winger\", \"market_value\": 3000000.0, \"x\": \"CA OsasunaRight Winger\"}, {\"team\": \"CA Osasuna\", \"position\": \"Right-Back\", \"market_value\": 7500000.0, \"x\": \"CA OsasunaRight-Back\"}, {\"team\": \"Celta de Vigo\", \"position\": \"Attacking Midfield\", \"market_value\": 17000000.0, \"x\": \"Celta de VigoAttacking Midfield\"}, {\"team\": \"Celta de Vigo\", \"position\": \"Central Midfield\", \"market_value\": 22000000.0, \"x\": \"Celta de VigoCentral Midfield\"}, {\"team\": \"Celta de Vigo\", \"position\": \"Centre-Back\", \"market_value\": 22000000.0, \"x\": \"Celta de VigoCentre-Back\"}, {\"team\": \"Celta de Vigo\", \"position\": \"Centre-Forward\", \"market_value\": 21000000.0, \"x\": \"Celta de VigoCentre-Forward\"}, {\"team\": \"Celta de Vigo\", \"position\": \"Defensive Midfield\", \"market_value\": 10000000.0, \"x\": \"Celta de VigoDefensive Midfield\"}, {\"team\": \"Celta de Vigo\", \"position\": \"Goalkeeper\", \"market_value\": 5200000.0, \"x\": \"Celta de VigoGoalkeeper\"}, {\"team\": \"Celta de Vigo\", \"position\": \"Left Winger\", \"market_value\": 5000000.0, \"x\": \"Celta de VigoLeft Winger\"}, {\"team\": \"Celta de Vigo\", \"position\": \"Left-Back\", \"market_value\": 12000000.0, \"x\": \"Celta de VigoLeft-Back\"}, {\"team\": \"Celta de Vigo\", \"position\": \"Right Winger\", \"market_value\": 8500000.0, \"x\": \"Celta de VigoRight Winger\"}, {\"team\": \"Celta de Vigo\", \"position\": \"Right-Back\", \"market_value\": 6000000.0, \"x\": \"Celta de VigoRight-Back\"}, {\"team\": \"C\\u00e1diz CF\", \"position\": \"Attacking Midfield\", \"market_value\": 5000000.0, \"x\": \"C\\u00e1diz CFAttacking Midfield\"}, {\"team\": \"C\\u00e1diz CF\", \"position\": \"Central Midfield\", \"market_value\": 4000000.0, \"x\": \"C\\u00e1diz CFCentral Midfield\"}, {\"team\": \"C\\u00e1diz CF\", \"position\": \"Centre-Back\", \"market_value\": 7100000.0, \"x\": \"C\\u00e1diz CFCentre-Back\"}, {\"team\": \"C\\u00e1diz CF\", \"position\": \"Centre-Forward\", \"market_value\": 10000000.0, \"x\": \"C\\u00e1diz CFCentre-Forward\"}, {\"team\": \"C\\u00e1diz CF\", \"position\": \"Defensive Midfield\", \"market_value\": 8800000.0, \"x\": \"C\\u00e1diz CFDefensive Midfield\"}, {\"team\": \"C\\u00e1diz CF\", \"position\": \"Goalkeeper\", \"market_value\": 6800000.0, \"x\": \"C\\u00e1diz CFGoalkeeper\"}, {\"team\": \"C\\u00e1diz CF\", \"position\": \"Left Winger\", \"market_value\": 7800000.0, \"x\": \"C\\u00e1diz CFLeft Winger\"}, {\"team\": \"C\\u00e1diz CF\", \"position\": \"Left-Back\", \"market_value\": 6800000.0, \"x\": \"C\\u00e1diz CFLeft-Back\"}, {\"team\": \"C\\u00e1diz CF\", \"position\": \"Right Winger\", \"market_value\": 3200000.0, \"x\": \"C\\u00e1diz CFRight Winger\"}, {\"team\": \"C\\u00e1diz CF\", \"position\": \"Right-Back\", \"market_value\": 5500000.0, \"x\": \"C\\u00e1diz CFRight-Back\"}, {\"team\": \"FC Barcelona\", \"position\": \"Central Midfield\", \"market_value\": 268000000.0, \"x\": \"FC BarcelonaCentral Midfield\"}, {\"team\": \"FC Barcelona\", \"position\": \"Centre-Back\", \"market_value\": 176000000.0, \"x\": \"FC BarcelonaCentre-Back\"}, {\"team\": \"FC Barcelona\", \"position\": \"Centre-Forward\", \"market_value\": 70000000.0, \"x\": \"FC BarcelonaCentre-Forward\"}, {\"team\": \"FC Barcelona\", \"position\": \"Defensive Midfield\", \"market_value\": 9000000.0, \"x\": \"FC BarcelonaDefensive Midfield\"}, {\"team\": \"FC Barcelona\", \"position\": \"Goalkeeper\", \"market_value\": 35700000.0, \"x\": \"FC BarcelonaGoalkeeper\"}, {\"team\": \"FC Barcelona\", \"position\": \"Left Winger\", \"market_value\": 100000000.0, \"x\": \"FC BarcelonaLeft Winger\"}, {\"team\": \"FC Barcelona\", \"position\": \"Left-Back\", \"market_value\": 29000000.0, \"x\": \"FC BarcelonaLeft-Back\"}, {\"team\": \"FC Barcelona\", \"position\": \"Right Winger\", \"market_value\": 100000000.0, \"x\": \"FC BarcelonaRight Winger\"}, {\"team\": \"FC Barcelona\", \"position\": \"Right-Back\", \"market_value\": 26000000.0, \"x\": \"FC BarcelonaRight-Back\"}, {\"team\": \"Getafe CF\", \"position\": \"Central Midfield\", \"market_value\": 32500000.0, \"x\": \"Getafe CFCentral Midfield\"}, {\"team\": \"Getafe CF\", \"position\": \"Centre-Back\", \"market_value\": 28800000.0, \"x\": \"Getafe CFCentre-Back\"}, {\"team\": \"Getafe CF\", \"position\": \"Centre-Forward\", \"market_value\": 44000000.0, \"x\": \"Getafe CFCentre-Forward\"}, {\"team\": \"Getafe CF\", \"position\": \"Defensive Midfield\", \"market_value\": 12000000.0, \"x\": \"Getafe CFDefensive Midfield\"}, {\"team\": \"Getafe CF\", \"position\": \"Goalkeeper\", \"market_value\": 9000000.0, \"x\": \"Getafe CFGoalkeeper\"}, {\"team\": \"Getafe CF\", \"position\": \"Left-Back\", \"market_value\": 8000000.0, \"x\": \"Getafe CFLeft-Back\"}, {\"team\": \"Getafe CF\", \"position\": \"Right Winger\", \"market_value\": 6000000.0, \"x\": \"Getafe CFRight Winger\"}, {\"team\": \"Getafe CF\", \"position\": \"Right-Back\", \"market_value\": 4000000.0, \"x\": \"Getafe CFRight-Back\"}, {\"team\": \"Girona FC\", \"position\": \"Attacking Midfield\", \"market_value\": 10300000.0, \"x\": \"Girona FCAttacking Midfield\"}, {\"team\": \"Girona FC\", \"position\": \"Central Midfield\", \"market_value\": 18000000.0, \"x\": \"Girona FCCentral Midfield\"}, {\"team\": \"Girona FC\", \"position\": \"Centre-Back\", \"market_value\": 7800000.0, \"x\": \"Girona FCCentre-Back\"}, {\"team\": \"Girona FC\", \"position\": \"Centre-Forward\", \"market_value\": 13500000.0, \"x\": \"Girona FCCentre-Forward\"}, {\"team\": \"Girona FC\", \"position\": \"Defensive Midfield\", \"market_value\": 6600000.0, \"x\": \"Girona FCDefensive Midfield\"}, {\"team\": \"Girona FC\", \"position\": \"Goalkeeper\", \"market_value\": 2600000.0, \"x\": \"Girona FCGoalkeeper\"}, {\"team\": \"Girona FC\", \"position\": \"Left Winger\", \"market_value\": 6500000.0, \"x\": \"Girona FCLeft Winger\"}, {\"team\": \"Girona FC\", \"position\": \"Left-Back\", \"market_value\": 10500000.0, \"x\": \"Girona FCLeft-Back\"}, {\"team\": \"Girona FC\", \"position\": \"Right Winger\", \"market_value\": 4800000.0, \"x\": \"Girona FCRight Winger\"}, {\"team\": \"Girona FC\", \"position\": \"Right-Back\", \"market_value\": 11000000.0, \"x\": \"Girona FCRight-Back\"}, {\"team\": \"RCD Espanyol Barcelona\", \"position\": \"Central Midfield\", \"market_value\": 23500000.0, \"x\": \"RCD Espanyol BarcelonaCentral Midfield\"}, {\"team\": \"RCD Espanyol Barcelona\", \"position\": \"Centre-Back\", \"market_value\": 8800000.0, \"x\": \"RCD Espanyol BarcelonaCentre-Back\"}, {\"team\": \"RCD Espanyol Barcelona\", \"position\": \"Centre-Forward\", \"market_value\": 13500000.0, \"x\": \"RCD Espanyol BarcelonaCentre-Forward\"}, {\"team\": \"RCD Espanyol Barcelona\", \"position\": \"Defensive Midfield\", \"market_value\": 4500000.0, \"x\": \"RCD Espanyol BarcelonaDefensive Midfield\"}, {\"team\": \"RCD Espanyol Barcelona\", \"position\": \"Goalkeeper\", \"market_value\": 9400000.0, \"x\": \"RCD Espanyol BarcelonaGoalkeeper\"}, {\"team\": \"RCD Espanyol Barcelona\", \"position\": \"Left Winger\", \"market_value\": 18000000.0, \"x\": \"RCD Espanyol BarcelonaLeft Winger\"}, {\"team\": \"RCD Espanyol Barcelona\", \"position\": \"Left-Back\", \"market_value\": 9500000.0, \"x\": \"RCD Espanyol BarcelonaLeft-Back\"}, {\"team\": \"RCD Espanyol Barcelona\", \"position\": \"Right-Back\", \"market_value\": 5000000.0, \"x\": \"RCD Espanyol BarcelonaRight-Back\"}, {\"team\": \"RCD Mallorca\", \"position\": \"Attacking Midfield\", \"market_value\": 10200000.0, \"x\": \"RCD MallorcaAttacking Midfield\"}, {\"team\": \"RCD Mallorca\", \"position\": \"Central Midfield\", \"market_value\": 7800000.0, \"x\": \"RCD MallorcaCentral Midfield\"}, {\"team\": \"RCD Mallorca\", \"position\": \"Centre-Back\", \"market_value\": 9900000.0, \"x\": \"RCD MallorcaCentre-Back\"}, {\"team\": \"RCD Mallorca\", \"position\": \"Centre-Forward\", \"market_value\": 18500000.0, \"x\": \"RCD MallorcaCentre-Forward\"}, {\"team\": \"RCD Mallorca\", \"position\": \"Defensive Midfield\", \"market_value\": 1800000.0, \"x\": \"RCD MallorcaDefensive Midfield\"}, {\"team\": \"RCD Mallorca\", \"position\": \"Goalkeeper\", \"market_value\": 11300000.0, \"x\": \"RCD MallorcaGoalkeeper\"}, {\"team\": \"RCD Mallorca\", \"position\": \"Left Winger\", \"market_value\": 3200000.0, \"x\": \"RCD MallorcaLeft Winger\"}, {\"team\": \"RCD Mallorca\", \"position\": \"Left-Back\", \"market_value\": 2400000.0, \"x\": \"RCD MallorcaLeft-Back\"}, {\"team\": \"RCD Mallorca\", \"position\": \"Right-Back\", \"market_value\": 6500000.0, \"x\": \"RCD MallorcaRight-Back\"}, {\"team\": \"Rayo Vallecano\", \"position\": \"Attacking Midfield\", \"market_value\": 8200000.0, \"x\": \"Rayo VallecanoAttacking Midfield\"}, {\"team\": \"Rayo Vallecano\", \"position\": \"Central Midfield\", \"market_value\": 15000000.0, \"x\": \"Rayo VallecanoCentral Midfield\"}, {\"team\": \"Rayo Vallecano\", \"position\": \"Centre-Back\", \"market_value\": 10100000.0, \"x\": \"Rayo VallecanoCentre-Back\"}, {\"team\": \"Rayo Vallecano\", \"position\": \"Centre-Forward\", \"market_value\": 19200000.0, \"x\": \"Rayo VallecanoCentre-Forward\"}, {\"team\": \"Rayo Vallecano\", \"position\": \"Goalkeeper\", \"market_value\": 5100000.0, \"x\": \"Rayo VallecanoGoalkeeper\"}, {\"team\": \"Rayo Vallecano\", \"position\": \"Left Winger\", \"market_value\": 6800000.0, \"x\": \"Rayo VallecanoLeft Winger\"}, {\"team\": \"Rayo Vallecano\", \"position\": \"Left-Back\", \"market_value\": 8300000.0, \"x\": \"Rayo VallecanoLeft-Back\"}, {\"team\": \"Rayo Vallecano\", \"position\": \"Right Winger\", \"market_value\": 7000000.0, \"x\": \"Rayo VallecanoRight Winger\"}, {\"team\": \"Rayo Vallecano\", \"position\": \"Right-Back\", \"market_value\": 2800000.0, \"x\": \"Rayo VallecanoRight-Back\"}, {\"team\": \"Real Betis Balompi\\u00e9\", \"position\": \"Attacking Midfield\", \"market_value\": 67000000.0, \"x\": \"Real Betis Balompi\\u00e9Attacking Midfield\"}, {\"team\": \"Real Betis Balompi\\u00e9\", \"position\": \"Central Midfield\", \"market_value\": 2500000.0, \"x\": \"Real Betis Balompi\\u00e9Central Midfield\"}, {\"team\": \"Real Betis Balompi\\u00e9\", \"position\": \"Centre-Back\", \"market_value\": 32500000.0, \"x\": \"Real Betis Balompi\\u00e9Centre-Back\"}, {\"team\": \"Real Betis Balompi\\u00e9\", \"position\": \"Centre-Forward\", \"market_value\": 36000000.0, \"x\": \"Real Betis Balompi\\u00e9Centre-Forward\"}, {\"team\": \"Real Betis Balompi\\u00e9\", \"position\": \"Defensive Midfield\", \"market_value\": 45000000.0, \"x\": \"Real Betis Balompi\\u00e9Defensive Midfield\"}, {\"team\": \"Real Betis Balompi\\u00e9\", \"position\": \"Goalkeeper\", \"market_value\": 18000000.0, \"x\": \"Real Betis Balompi\\u00e9Goalkeeper\"}, {\"team\": \"Real Betis Balompi\\u00e9\", \"position\": \"Left Winger\", \"market_value\": 15000000.0, \"x\": \"Real Betis Balompi\\u00e9Left Winger\"}, {\"team\": \"Real Betis Balompi\\u00e9\", \"position\": \"Left-Back\", \"market_value\": 23000000.0, \"x\": \"Real Betis Balompi\\u00e9Left-Back\"}, {\"team\": \"Real Betis Balompi\\u00e9\", \"position\": \"Right Winger\", \"market_value\": 13500000.0, \"x\": \"Real Betis Balompi\\u00e9Right Winger\"}, {\"team\": \"Real Betis Balompi\\u00e9\", \"position\": \"Right-Back\", \"market_value\": 7500000.0, \"x\": \"Real Betis Balompi\\u00e9Right-Back\"}, {\"team\": \"Real Madrid\", \"position\": \"Central Midfield\", \"market_value\": 179000000.0, \"x\": \"Real MadridCentral Midfield\"}, {\"team\": \"Real Madrid\", \"position\": \"Centre-Back\", \"market_value\": 165000000.0, \"x\": \"Real MadridCentre-Back\"}, {\"team\": \"Real Madrid\", \"position\": \"Centre-Forward\", \"market_value\": 34000000.0, \"x\": \"Real MadridCentre-Forward\"}, {\"team\": \"Real Madrid\", \"position\": \"Defensive Midfield\", \"market_value\": 80000000.0, \"x\": \"Real MadridDefensive Midfield\"}, {\"team\": \"Real Madrid\", \"position\": \"Goalkeeper\", \"market_value\": 62500000.0, \"x\": \"Real MadridGoalkeeper\"}, {\"team\": \"Real Madrid\", \"position\": \"Left Winger\", \"market_value\": 132000000.0, \"x\": \"Real MadridLeft Winger\"}, {\"team\": \"Real Madrid\", \"position\": \"Left-Back\", \"market_value\": 40000000.0, \"x\": \"Real MadridLeft-Back\"}, {\"team\": \"Real Madrid\", \"position\": \"Right Winger\", \"market_value\": 117000000.0, \"x\": \"Real MadridRight Winger\"}, {\"team\": \"Real Madrid\", \"position\": \"Right-Back\", \"market_value\": 28000000.0, \"x\": \"Real MadridRight-Back\"}, {\"team\": \"Real Sociedad\", \"position\": \"Attacking Midfield\", \"market_value\": 7000000.0, \"x\": \"Real SociedadAttacking Midfield\"}, {\"team\": \"Real Sociedad\", \"position\": \"Central Midfield\", \"market_value\": 80000000.0, \"x\": \"Real SociedadCentral Midfield\"}, {\"team\": \"Real Sociedad\", \"position\": \"Centre-Back\", \"market_value\": 71000000.0, \"x\": \"Real SociedadCentre-Back\"}, {\"team\": \"Real Sociedad\", \"position\": \"Centre-Forward\", \"market_value\": 53000000.0, \"x\": \"Real SociedadCentre-Forward\"}, {\"team\": \"Real Sociedad\", \"position\": \"Defensive Midfield\", \"market_value\": 38000000.0, \"x\": \"Real SociedadDefensive Midfield\"}, {\"team\": \"Real Sociedad\", \"position\": \"Goalkeeper\", \"market_value\": 22300000.0, \"x\": \"Real SociedadGoalkeeper\"}, {\"team\": \"Real Sociedad\", \"position\": \"Left Winger\", \"market_value\": 70500000.0, \"x\": \"Real SociedadLeft Winger\"}, {\"team\": \"Real Sociedad\", \"position\": \"Left-Back\", \"market_value\": 9000000.0, \"x\": \"Real SociedadLeft-Back\"}, {\"team\": \"Real Sociedad\", \"position\": \"Right Winger\", \"market_value\": 9000000.0, \"x\": \"Real SociedadRight Winger\"}, {\"team\": \"Real Sociedad\", \"position\": \"Right-Back\", \"market_value\": 11500000.0, \"x\": \"Real SociedadRight-Back\"}, {\"team\": \"Real Valladolid CF\", \"position\": \"Central Midfield\", \"market_value\": 11500000.0, \"x\": \"Real Valladolid CFCentral Midfield\"}, {\"team\": \"Real Valladolid CF\", \"position\": \"Centre-Back\", \"market_value\": 9000000.0, \"x\": \"Real Valladolid CFCentre-Back\"}, {\"team\": \"Real Valladolid CF\", \"position\": \"Centre-Forward\", \"market_value\": 13700000.0, \"x\": \"Real Valladolid CFCentre-Forward\"}, {\"team\": \"Real Valladolid CF\", \"position\": \"Defensive Midfield\", \"market_value\": 3000000.0, \"x\": \"Real Valladolid CFDefensive Midfield\"}, {\"team\": \"Real Valladolid CF\", \"position\": \"Goalkeeper\", \"market_value\": 4700000.0, \"x\": \"Real Valladolid CFGoalkeeper\"}, {\"team\": \"Real Valladolid CF\", \"position\": \"Left Winger\", \"market_value\": 7000000.0, \"x\": \"Real Valladolid CFLeft Winger\"}, {\"team\": \"Real Valladolid CF\", \"position\": \"Left-Back\", \"market_value\": 4300000.0, \"x\": \"Real Valladolid CFLeft-Back\"}, {\"team\": \"Real Valladolid CF\", \"position\": \"Right Winger\", \"market_value\": 9300000.0, \"x\": \"Real Valladolid CFRight Winger\"}, {\"team\": \"Real Valladolid CF\", \"position\": \"Right-Back\", \"market_value\": 2650000.0, \"x\": \"Real Valladolid CFRight-Back\"}, {\"team\": \"Sevilla FC\", \"position\": \"Attacking Midfield\", \"market_value\": 7500000.0, \"x\": \"Sevilla FCAttacking Midfield\"}, {\"team\": \"Sevilla FC\", \"position\": \"Central Midfield\", \"market_value\": 40000000.0, \"x\": \"Sevilla FCCentral Midfield\"}, {\"team\": \"Sevilla FC\", \"position\": \"Centre-Back\", \"market_value\": 28000000.0, \"x\": \"Sevilla FCCentre-Back\"}, {\"team\": \"Sevilla FC\", \"position\": \"Centre-Forward\", \"market_value\": 53000000.0, \"x\": \"Sevilla FCCentre-Forward\"}, {\"team\": \"Sevilla FC\", \"position\": \"Defensive Midfield\", \"market_value\": 8000000.0, \"x\": \"Sevilla FCDefensive Midfield\"}, {\"team\": \"Sevilla FC\", \"position\": \"Goalkeeper\", \"market_value\": 23000000.0, \"x\": \"Sevilla FCGoalkeeper\"}, {\"team\": \"Sevilla FC\", \"position\": \"Left Winger\", \"market_value\": 6000000.0, \"x\": \"Sevilla FCLeft Winger\"}, {\"team\": \"Sevilla FC\", \"position\": \"Left-Back\", \"market_value\": 36000000.0, \"x\": \"Sevilla FCLeft-Back\"}, {\"team\": \"Sevilla FC\", \"position\": \"Right Winger\", \"market_value\": 53000000.0, \"x\": \"Sevilla FCRight Winger\"}, {\"team\": \"Sevilla FC\", \"position\": \"Right-Back\", \"market_value\": 22000000.0, \"x\": \"Sevilla FCRight-Back\"}, {\"team\": \"UD Almer\\u00eda\", \"position\": \"Central Midfield\", \"market_value\": 12000000.0, \"x\": \"UD Almer\\u00edaCentral Midfield\"}, {\"team\": \"UD Almer\\u00eda\", \"position\": \"Centre-Back\", \"market_value\": 16400000.0, \"x\": \"UD Almer\\u00edaCentre-Back\"}, {\"team\": \"UD Almer\\u00eda\", \"position\": \"Centre-Forward\", \"market_value\": 8700000.0, \"x\": \"UD Almer\\u00edaCentre-Forward\"}, {\"team\": \"UD Almer\\u00eda\", \"position\": \"Defensive Midfield\", \"market_value\": 7000000.0, \"x\": \"UD Almer\\u00edaDefensive Midfield\"}, {\"team\": \"UD Almer\\u00eda\", \"position\": \"Goalkeeper\", \"market_value\": 4200000.0, \"x\": \"UD Almer\\u00edaGoalkeeper\"}, {\"team\": \"UD Almer\\u00eda\", \"position\": \"Left Winger\", \"market_value\": 17000000.0, \"x\": \"UD Almer\\u00edaLeft Winger\"}, {\"team\": \"UD Almer\\u00eda\", \"position\": \"Left-Back\", \"market_value\": 6500000.0, \"x\": \"UD Almer\\u00edaLeft-Back\"}, {\"team\": \"UD Almer\\u00eda\", \"position\": \"Right Winger\", \"market_value\": 6000000.0, \"x\": \"UD Almer\\u00edaRight Winger\"}, {\"team\": \"UD Almer\\u00eda\", \"position\": \"Right-Back\", \"market_value\": 7700000.0, \"x\": \"UD Almer\\u00edaRight-Back\"}, {\"team\": \"UD Almer\\u00eda\", \"position\": \"Second Striker\", \"market_value\": 1500000.0, \"x\": \"UD Almer\\u00edaSecond Striker\"}, {\"team\": \"Valencia CF\", \"position\": \"Central Midfield\", \"market_value\": 62000000.0, \"x\": \"Valencia CFCentral Midfield\"}, {\"team\": \"Valencia CF\", \"position\": \"Centre-Back\", \"market_value\": 18000000.0, \"x\": \"Valencia CFCentre-Back\"}, {\"team\": \"Valencia CF\", \"position\": \"Centre-Forward\", \"market_value\": 19000000.0, \"x\": \"Valencia CFCentre-Forward\"}, {\"team\": \"Valencia CF\", \"position\": \"Defensive Midfield\", \"market_value\": 25000000.0, \"x\": \"Valencia CFDefensive Midfield\"}, {\"team\": \"Valencia CF\", \"position\": \"Goalkeeper\", \"market_value\": 22700000.0, \"x\": \"Valencia CFGoalkeeper\"}, {\"team\": \"Valencia CF\", \"position\": \"Left Winger\", \"market_value\": 27000000.0, \"x\": \"Valencia CFLeft Winger\"}, {\"team\": \"Valencia CF\", \"position\": \"Left-Back\", \"market_value\": 42500000.0, \"x\": \"Valencia CFLeft-Back\"}, {\"team\": \"Valencia CF\", \"position\": \"Right Winger\", \"market_value\": 6000000.0, \"x\": \"Valencia CFRight Winger\"}, {\"team\": \"Valencia CF\", \"position\": \"Right-Back\", \"market_value\": 15000000.0, \"x\": \"Valencia CFRight-Back\"}, {\"team\": \"Villarreal CF\", \"position\": \"Central Midfield\", \"market_value\": 48000000.0, \"x\": \"Villarreal CFCentral Midfield\"}, {\"team\": \"Villarreal CF\", \"position\": \"Centre-Back\", \"market_value\": 67000000.0, \"x\": \"Villarreal CFCentre-Back\"}, {\"team\": \"Villarreal CF\", \"position\": \"Centre-Forward\", \"market_value\": 94000000.0, \"x\": \"Villarreal CFCentre-Forward\"}, {\"team\": \"Villarreal CF\", \"position\": \"Defensive Midfield\", \"market_value\": 8000000.0, \"x\": \"Villarreal CFDefensive Midfield\"}, {\"team\": \"Villarreal CF\", \"position\": \"Goalkeeper\", \"market_value\": 7700000.0, \"x\": \"Villarreal CFGoalkeeper\"}, {\"team\": \"Villarreal CF\", \"position\": \"Left Winger\", \"market_value\": 10000000.0, \"x\": \"Villarreal CFLeft Winger\"}, {\"team\": \"Villarreal CF\", \"position\": \"Left-Back\", \"market_value\": 28000000.0, \"x\": \"Villarreal CFLeft-Back\"}, {\"team\": \"Villarreal CF\", \"position\": \"Right Winger\", \"market_value\": 70000000.0, \"x\": \"Villarreal CFRight Winger\"}, {\"team\": \"Villarreal CF\", \"position\": \"Right-Back\", \"market_value\": 27500000.0, \"x\": \"Villarreal CFRight-Back\"}]}}, {\"mode\": \"vega-lite\"});\n",
       "</script>"
      ],
      "text/plain": [
       "alt.Chart(...)"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import altair as alt\n",
    "final_query1 = final_query[final_query['market_value'] > 100000]\n",
    "final_query1[\"x\"] = final_query1['team'] + final_query1['position']\n",
    "click = alt.selection_multi(encodings=['color'])\n",
    "timeunit='date'\n",
    "# EXAMPLE\n",
    "fig = (\n",
    "        alt.Chart(final_query1)\n",
    "        .mark_bar(width=10)\n",
    "        .encode(\n",
    "            x = alt.X(\"x\", title=\"Team & Position\"),\n",
    "            y=alt.Y(\"market_value\", title=\"Market value (in €)\"),\n",
    "            \n",
    "            color=alt.value('#fbb4ae'),\n",
    "            tooltip=[alt.Tooltip('x')]\n",
    "        )\n",
    "    ).properties(width=600,title={\n",
    "      \"text\": [\"Which Team's which positon has the highes market value?\"], \n",
    "      \"subtitle\": [\"Plot of total market value of teams and positions\"]\n",
    "    },).interactive().configure_axis(\n",
    "    grid=False\n",
    ").configure_view(\n",
    "    strokeWidth=0\n",
    ")\n",
    "#fig.save(\"plots/fig2.html\")\n",
    "fig"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "After looking at this chart, we can say that we are not able to tell much from this as the data is alot for us to comprehend. Thus we need to selectively filter our data for a better visual. Since the objective is to see which team's which position has more market value, we can very easily filter on market value. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/var/folders/gc/n0p2_5d52qz9v6vm5nmmszx40000gn/T/ipykernel_90293/2942482980.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  final_query2[\"x\"] = final_query2['team'] +\" \" + final_query2['position']\n",
      "/Users/aviarora/Desktop/OneDrive - Georgetown University/BCSG test/laliga_data_scrapping/env/lib/python3.10/site-packages/altair/utils/core.py:317: FutureWarning: iteritems is deprecated and will be removed in a future version. Use .items instead.\n",
      "  for col_name, dtype in df.dtypes.iteritems():\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "\n",
       "<div id=\"altair-viz-11fc06db2c2447ee829693d458d6530a\"></div>\n",
       "<script type=\"text/javascript\">\n",
       "  var VEGA_DEBUG = (typeof VEGA_DEBUG == \"undefined\") ? {} : VEGA_DEBUG;\n",
       "  (function(spec, embedOpt){\n",
       "    let outputDiv = document.currentScript.previousElementSibling;\n",
       "    if (outputDiv.id !== \"altair-viz-11fc06db2c2447ee829693d458d6530a\") {\n",
       "      outputDiv = document.getElementById(\"altair-viz-11fc06db2c2447ee829693d458d6530a\");\n",
       "    }\n",
       "    const paths = {\n",
       "      \"vega\": \"https://cdn.jsdelivr.net/npm//vega@5?noext\",\n",
       "      \"vega-lib\": \"https://cdn.jsdelivr.net/npm//vega-lib?noext\",\n",
       "      \"vega-lite\": \"https://cdn.jsdelivr.net/npm//vega-lite@4.17.0?noext\",\n",
       "      \"vega-embed\": \"https://cdn.jsdelivr.net/npm//vega-embed@6?noext\",\n",
       "    };\n",
       "\n",
       "    function maybeLoadScript(lib, version) {\n",
       "      var key = `${lib.replace(\"-\", \"\")}_version`;\n",
       "      return (VEGA_DEBUG[key] == version) ?\n",
       "        Promise.resolve(paths[lib]) :\n",
       "        new Promise(function(resolve, reject) {\n",
       "          var s = document.createElement('script');\n",
       "          document.getElementsByTagName(\"head\")[0].appendChild(s);\n",
       "          s.async = true;\n",
       "          s.onload = () => {\n",
       "            VEGA_DEBUG[key] = version;\n",
       "            return resolve(paths[lib]);\n",
       "          };\n",
       "          s.onerror = () => reject(`Error loading script: ${paths[lib]}`);\n",
       "          s.src = paths[lib];\n",
       "        });\n",
       "    }\n",
       "\n",
       "    function showError(err) {\n",
       "      outputDiv.innerHTML = `<div class=\"error\" style=\"color:red;\">${err}</div>`;\n",
       "      throw err;\n",
       "    }\n",
       "\n",
       "    function displayChart(vegaEmbed) {\n",
       "      vegaEmbed(outputDiv, spec, embedOpt)\n",
       "        .catch(err => showError(`Javascript Error: ${err.message}<br>This usually means there's a typo in your chart specification. See the javascript console for the full traceback.`));\n",
       "    }\n",
       "\n",
       "    if(typeof define === \"function\" && define.amd) {\n",
       "      requirejs.config({paths});\n",
       "      require([\"vega-embed\"], displayChart, err => showError(`Error loading script: ${err.message}`));\n",
       "    } else {\n",
       "      maybeLoadScript(\"vega\", \"5\")\n",
       "        .then(() => maybeLoadScript(\"vega-lite\", \"4.17.0\"))\n",
       "        .then(() => maybeLoadScript(\"vega-embed\", \"6\"))\n",
       "        .catch(showError)\n",
       "        .then(() => displayChart(vegaEmbed));\n",
       "    }\n",
       "  })({\"config\": {\"view\": {\"continuousWidth\": 400, \"continuousHeight\": 300, \"strokeWidth\": 0}, \"axis\": {\"grid\": false}}, \"data\": {\"name\": \"data-4d8316f8394dfbd11152b3c530dc9e9b\"}, \"mark\": {\"type\": \"bar\", \"width\": 20}, \"encoding\": {\"color\": {\"value\": \"#fbb4ae\"}, \"tooltip\": [{\"field\": \"market_value\", \"type\": \"quantitative\"}], \"x\": {\"field\": \"x\", \"title\": \"Team & Position\", \"type\": \"nominal\"}, \"y\": {\"field\": \"market_value\", \"title\": \"Market value (in \\u20ac)\", \"type\": \"quantitative\"}}, \"selection\": {\"selector012\": {\"type\": \"interval\", \"bind\": \"scales\", \"encodings\": [\"x\", \"y\"]}}, \"title\": {\"text\": [\"Which Team's which positon has the highes market value?\"], \"subtitle\": [\"Plot of total market value of teams and positions\"]}, \"width\": 600, \"$schema\": \"https://vega.github.io/schema/vega-lite/v4.17.0.json\", \"datasets\": {\"data-4d8316f8394dfbd11152b3c530dc9e9b\": [{\"team\": \"Atl\\u00e9tico de Madrid\", \"position\": \"Central Midfield\", \"market_value\": 115000000.0, \"x\": \"Atl\\u00e9tico de Madrid Central Midfield\"}, {\"team\": \"Atl\\u00e9tico de Madrid\", \"position\": \"Centre-Back\", \"market_value\": 83000000.0, \"x\": \"Atl\\u00e9tico de Madrid Centre-Back\"}, {\"team\": \"Atl\\u00e9tico de Madrid\", \"position\": \"Centre-Forward\", \"market_value\": 55000000.0, \"x\": \"Atl\\u00e9tico de Madrid Centre-Forward\"}, {\"team\": \"Atl\\u00e9tico de Madrid\", \"position\": \"Second Striker\", \"market_value\": 105000000.0, \"x\": \"Atl\\u00e9tico de Madrid Second Striker\"}, {\"team\": \"FC Barcelona\", \"position\": \"Central Midfield\", \"market_value\": 268000000.0, \"x\": \"FC Barcelona Central Midfield\"}, {\"team\": \"FC Barcelona\", \"position\": \"Centre-Back\", \"market_value\": 176000000.0, \"x\": \"FC Barcelona Centre-Back\"}, {\"team\": \"FC Barcelona\", \"position\": \"Centre-Forward\", \"market_value\": 70000000.0, \"x\": \"FC Barcelona Centre-Forward\"}, {\"team\": \"FC Barcelona\", \"position\": \"Left Winger\", \"market_value\": 100000000.0, \"x\": \"FC Barcelona Left Winger\"}, {\"team\": \"FC Barcelona\", \"position\": \"Right Winger\", \"market_value\": 100000000.0, \"x\": \"FC Barcelona Right Winger\"}, {\"team\": \"Real Betis Balompi\\u00e9\", \"position\": \"Attacking Midfield\", \"market_value\": 67000000.0, \"x\": \"Real Betis Balompi\\u00e9 Attacking Midfield\"}, {\"team\": \"Real Madrid\", \"position\": \"Central Midfield\", \"market_value\": 179000000.0, \"x\": \"Real Madrid Central Midfield\"}, {\"team\": \"Real Madrid\", \"position\": \"Centre-Back\", \"market_value\": 165000000.0, \"x\": \"Real Madrid Centre-Back\"}, {\"team\": \"Real Madrid\", \"position\": \"Defensive Midfield\", \"market_value\": 80000000.0, \"x\": \"Real Madrid Defensive Midfield\"}, {\"team\": \"Real Madrid\", \"position\": \"Goalkeeper\", \"market_value\": 62500000.0, \"x\": \"Real Madrid Goalkeeper\"}, {\"team\": \"Real Madrid\", \"position\": \"Left Winger\", \"market_value\": 132000000.0, \"x\": \"Real Madrid Left Winger\"}, {\"team\": \"Real Madrid\", \"position\": \"Right Winger\", \"market_value\": 117000000.0, \"x\": \"Real Madrid Right Winger\"}, {\"team\": \"Real Sociedad\", \"position\": \"Central Midfield\", \"market_value\": 80000000.0, \"x\": \"Real Sociedad Central Midfield\"}, {\"team\": \"Real Sociedad\", \"position\": \"Centre-Back\", \"market_value\": 71000000.0, \"x\": \"Real Sociedad Centre-Back\"}, {\"team\": \"Real Sociedad\", \"position\": \"Centre-Forward\", \"market_value\": 53000000.0, \"x\": \"Real Sociedad Centre-Forward\"}, {\"team\": \"Real Sociedad\", \"position\": \"Left Winger\", \"market_value\": 70500000.0, \"x\": \"Real Sociedad Left Winger\"}, {\"team\": \"Sevilla FC\", \"position\": \"Centre-Forward\", \"market_value\": 53000000.0, \"x\": \"Sevilla FC Centre-Forward\"}, {\"team\": \"Sevilla FC\", \"position\": \"Right Winger\", \"market_value\": 53000000.0, \"x\": \"Sevilla FC Right Winger\"}, {\"team\": \"Valencia CF\", \"position\": \"Central Midfield\", \"market_value\": 62000000.0, \"x\": \"Valencia CF Central Midfield\"}, {\"team\": \"Villarreal CF\", \"position\": \"Centre-Back\", \"market_value\": 67000000.0, \"x\": \"Villarreal CF Centre-Back\"}, {\"team\": \"Villarreal CF\", \"position\": \"Centre-Forward\", \"market_value\": 94000000.0, \"x\": \"Villarreal CF Centre-Forward\"}, {\"team\": \"Villarreal CF\", \"position\": \"Right Winger\", \"market_value\": 70000000.0, \"x\": \"Villarreal CF Right Winger\"}]}}, {\"mode\": \"vega-lite\"});\n",
       "</script>"
      ],
      "text/plain": [
       "alt.Chart(...)"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import altair as alt\n",
    "final_query2 = final_query[final_query['market_value'] > 50000000]\n",
    "final_query2[\"x\"] = final_query2['team'] +\" \" + final_query2['position']\n",
    "click = alt.selection_multi(encodings=['color'])\n",
    "timeunit='date'\n",
    "# EXAMPLE\n",
    "fig = (\n",
    "        alt.Chart(final_query2)\n",
    "        .mark_bar(width=20)\n",
    "        .encode(\n",
    "            x = alt.X(\"x\", title=\"Team & Position\"),\n",
    "            y=alt.Y(\"market_value\", title=\"Market value (in €)\"),\n",
    "            \n",
    "            color=alt.value('#fbb4ae'),\n",
    "            tooltip=[alt.Tooltip('market_value')]\n",
    "        )\n",
    "    ).properties(width=600,title={\n",
    "      \"text\": [\"Which Team's which positon has the highes market value?\"], \n",
    "      \"subtitle\": [\"Plot of total market value of teams and positions\"]\n",
    "    },).interactive().configure_axis(\n",
    "    grid=False\n",
    ").configure_view(\n",
    "    strokeWidth=0\n",
    ")\n",
    "fig.save(\"../plots/highest_market_values.html\")\n",
    "fig"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3.10.2 ('env': venv)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.2"
  },
  "orig_nbformat": 4,
  "vscode": {
   "interpreter": {
    "hash": "62610cecab943f77cec9c06beaf12945c4dddc5ca5f490fec4e0ef661bb8ad75"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}