pre_scrape.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "* Scrape https://eugene.diamondleague.com/program-results-eugene/ for eventname,gender,lastname,firstname,Country,SB,PB,DOB,html link"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "import pandas as pd\n",
    "from bs4 import BeautifulSoup"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "BASE_URL = 'https://eugene.diamondleague.com'\n",
    "EUGENE_URL = 'https://eugene.diamondleague.com/program-results-eugene/'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "def make_request_and_get_soup(url):\n",
    "    r = requests.get(url)\n",
    "    s = BeautifulSoup(r.text, 'html.parser')\n",
    "    \n",
    "    return s"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "soup = make_request_and_get_soup(EUGENE_URL)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "event_names = []\n",
    "event_elems = soup.findAll(\"div\", {'class': 'name'})\n",
    "for elem in event_elems:\n",
    "    event_names.append(elem.text)\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "link_elems = soup.findAll(\"div\", {'class': 'links'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "event_hrefs = []\n",
    "for link in link_elems:\n",
    "    a_elem = link.find('a')\n",
    "    if a_elem:\n",
    "        event_hrefs.append('{}{}'.format(BASE_URL, a_elem['href']))\n",
    "    else:\n",
    "        event_hrefs.append(pd.np.nan)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.DataFrame()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['event_name'] = event_names\n",
    "df['event_hrefs'] = event_hrefs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_athlete_hrefs(event_href):\n",
    "    try:\n",
    "        event_soup = make_request_and_get_soup(event_href)\n",
    "\n",
    "        athlete_info = []\n",
    "        athlete_href_elems = event_soup.findAll('div', {'class': 'column name'})\n",
    "        athlete_sb_elems = event_soup.findAll('div', {'class': 'column sb'})\n",
    "        athlete_pb_elems = event_soup.findAll('div', {'class': 'column pb'})\n",
    "        \n",
    "        \n",
    "        for i in range(1, len(athlete_href_elems)):            \n",
    "            href = '{}{}'.format(BASE_URL, athlete_href_elems[i].find('a')['href'])\n",
    "            sb = athlete_sb_elems[i].text\n",
    "            pb = athlete_pb_elems[i].text\n",
    "            \n",
    "            athlete_info.append([href, sb, pb])\n",
    "        \n",
    "        return athlete_info\n",
    "    \n",
    "    except:\n",
    "        return pd.np.nan\n",
    "    \n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "df['athlete_infos'] = df['event_hrefs'].apply(get_athlete_hrefs)"
   ]
  },
  {
   "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>event_name</th>\n",
       "      <th>event_hrefs</th>\n",
       "      <th>athlete_infos</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Men's Pole Vault</td>\n",
       "      <td>https://eugene.diamondleague.com/program-resul...</td>\n",
       "      <td>[[https://eugene.diamondleague.com/athletes/14...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Men High School 100m</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Women High School 100m</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Women's Shot Put</td>\n",
       "      <td>https://eugene.diamondleague.com/program-resul...</td>\n",
       "      <td>[[https://eugene.diamondleague.com/athletes/14...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>400m Hurdles Men</td>\n",
       "      <td>https://eugene.diamondleague.com/program-resul...</td>\n",
       "      <td>[[https://eugene.diamondleague.com/athletes/14...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               event_name                                        event_hrefs  \\\n",
       "0        Men's Pole Vault  https://eugene.diamondleague.com/program-resul...   \n",
       "1    Men High School 100m                                                NaN   \n",
       "2  Women High School 100m                                                NaN   \n",
       "3        Women's Shot Put  https://eugene.diamondleague.com/program-resul...   \n",
       "4        400m Hurdles Men  https://eugene.diamondleague.com/program-resul...   \n",
       "\n",
       "                                       athlete_infos  \n",
       "0  [[https://eugene.diamondleague.com/athletes/14...  \n",
       "1                                                NaN  \n",
       "2                                                NaN  \n",
       "3  [[https://eugene.diamondleague.com/athletes/14...  \n",
       "4  [[https://eugene.diamondleague.com/athletes/14...  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "# split each athlete onto their own row.\n",
    "df = df.athlete_infos.apply(pd.Series) \\\n",
    "    .merge(df, right_index = True, left_index = True) \\\n",
    "    .drop([\"athlete_infos\"], axis = 1) \\\n",
    "    .melt(id_vars = ['event_name', 'event_hrefs'], value_name = \"athlete_info\") \\\n",
    "    .drop(\"variable\", axis = 1) \\\n",
    "    .dropna()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "def return_list_index(x, index=None):\n",
    "    return x[index]\n",
    "\n",
    "df['athlete_href'] = df['athlete_info'].apply(return_list_index, index=0)\n",
    "df['athlete_sb'] = df['athlete_info'].apply(return_list_index, index=1)\n",
    "df['athlete_pb'] = df['athlete_info'].apply(return_list_index, index=2)\n",
    "df.drop(columns='athlete_info', inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "s = make_request_and_get_soup('https://eugene.diamondleague.com/athletes/14377443.html')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_athlete_data(athlete_href):\n",
    "    try:\n",
    "        athlete_soup = make_request_and_get_soup(athlete_href)\n",
    "        header = athlete_soup.find('h1')\n",
    "        \n",
    "        full_name = header.find('div').text\n",
    "        full_name_list = full_name.split(' ')\n",
    "        first_name = full_name_list[0]\n",
    "        last_name = full_name_list[1]\n",
    "        \n",
    "        birthdate = header.find('div', {'class': 'birthdate'}).text\n",
    "        country = header.find('div', {'class': 'country'}).text\n",
    "        \n",
    "        return pd.Series([first_name, last_name, birthdate, country])\n",
    "    \n",
    "    except:\n",
    "        return pd.Series([pd.np.nan, pd.np.nan, pd.np.nan, pd.np.nan])\n",
    "    \n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "df[['first_name', 'last_name', 'birthdate', 'country']] = df['athlete_href'].apply(get_athlete_data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "def clean_bd(x):\n",
    "    try: \n",
    "        return x.replace('.', '/')\n",
    "    except: \n",
    "        return pd.np.nan\n",
    "    \n",
    "    \n",
    "df['birthdate'] = df['birthdate'].apply(clean_bd)\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.drop(columns=['event_hrefs'], inplace=True)\n",
    "df.sort_values('event_name', inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = df[['event_name', 'last_name', 'first_name', 'country', 'athlete_sb', 'athlete_pb', 'birthdate', 'athlete_href']]"
   ]
  },
  {
   "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>event_name</th>\n",
       "      <th>last_name</th>\n",
       "      <th>first_name</th>\n",
       "      <th>country</th>\n",
       "      <th>athlete_sb</th>\n",
       "      <th>athlete_pb</th>\n",
       "      <th>birthdate</th>\n",
       "      <th>athlete_href</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>1 Mile Men</td>\n",
       "      <td>KAAZOUZI</td>\n",
       "      <td>Brahim</td>\n",
       "      <td>Morocco</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>15/06/1990</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1447...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>1 Mile Men</td>\n",
       "      <td>INGEBRIGTSEN</td>\n",
       "      <td>Jakob</td>\n",
       "      <td>Norway</td>\n",
       "      <td></td>\n",
       "      <td>3:52.28</td>\n",
       "      <td>19/09/2000</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1465...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>1 Mile Men</td>\n",
       "      <td>INGEBRIGTSEN</td>\n",
       "      <td>Filip</td>\n",
       "      <td>Norway</td>\n",
       "      <td></td>\n",
       "      <td>3:53.23</td>\n",
       "      <td>20/04/1993</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1445...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>1 Mile Men</td>\n",
       "      <td>CENTROWITZ</td>\n",
       "      <td>Matthew</td>\n",
       "      <td>United States</td>\n",
       "      <td></td>\n",
       "      <td>3:50.53</td>\n",
       "      <td>18/10/1989</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1423...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>1 Mile Men</td>\n",
       "      <td>Motonei</td>\n",
       "      <td>Elijah</td>\n",
       "      <td>Kenya</td>\n",
       "      <td></td>\n",
       "      <td>3:49.08</td>\n",
       "      <td>05/01/1993</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1459...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>1 Mile Men</td>\n",
       "      <td>ENGELS</td>\n",
       "      <td>Craig</td>\n",
       "      <td>United States</td>\n",
       "      <td></td>\n",
       "      <td>3:55.12</td>\n",
       "      <td>01/05/1994</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1446...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>197</th>\n",
       "      <td>1 Mile Men</td>\n",
       "      <td>TEFERA</td>\n",
       "      <td>Samuel</td>\n",
       "      <td>Ethiopia</td>\n",
       "      <td></td>\n",
       "      <td>3:51.26</td>\n",
       "      <td>23/10/1999</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1479...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>1 Mile Men</td>\n",
       "      <td>BIRGEN</td>\n",
       "      <td>Bethwell</td>\n",
       "      <td>Kenya</td>\n",
       "      <td></td>\n",
       "      <td>3:50.42</td>\n",
       "      <td>06/08/1988</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1436...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>1 Mile Men</td>\n",
       "      <td>SOULEIMAN</td>\n",
       "      <td>Ayanleh</td>\n",
       "      <td>Djibouti</td>\n",
       "      <td></td>\n",
       "      <td>3:47.32</td>\n",
       "      <td>03/12/1992</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1437...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>215</th>\n",
       "      <td>1 Mile Men</td>\n",
       "      <td>WILLIS</td>\n",
       "      <td>Nick</td>\n",
       "      <td>New Zealand</td>\n",
       "      <td></td>\n",
       "      <td>3:49.83</td>\n",
       "      <td>25/04/1983</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1421...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>233</th>\n",
       "      <td>1 Mile Men</td>\n",
       "      <td>WOTE</td>\n",
       "      <td>Aman</td>\n",
       "      <td>Ethiopia</td>\n",
       "      <td></td>\n",
       "      <td>3:48.60</td>\n",
       "      <td>18/04/1984</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1442...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>1 Mile Men</td>\n",
       "      <td>GREGOREK</td>\n",
       "      <td>John</td>\n",
       "      <td>United States</td>\n",
       "      <td></td>\n",
       "      <td>3:54.53</td>\n",
       "      <td>07/12/1991</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1450...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>1 Mile Men</td>\n",
       "      <td>CHERUIYOT</td>\n",
       "      <td>Timothy</td>\n",
       "      <td>Kenya</td>\n",
       "      <td></td>\n",
       "      <td>3:49.64</td>\n",
       "      <td>20/11/1995</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1464...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>1500m Women</td>\n",
       "      <td>JONES</td>\n",
       "      <td>Danielle</td>\n",
       "      <td>United States</td>\n",
       "      <td>4:20.57</td>\n",
       "      <td>4:07.33</td>\n",
       "      <td>21/08/1996</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1447...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>1500m Women</td>\n",
       "      <td>HAILU</td>\n",
       "      <td>Lemlem</td>\n",
       "      <td>Ethiopia</td>\n",
       "      <td></td>\n",
       "      <td>4:20.36</td>\n",
       "      <td>21/05/2001</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1480...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>267</th>\n",
       "      <td>1500m Women</td>\n",
       "      <td>TSEGAY</td>\n",
       "      <td>Gudaf</td>\n",
       "      <td>Ethiopia</td>\n",
       "      <td>3:59.57</td>\n",
       "      <td>3:57.64</td>\n",
       "      <td>23/01/1997</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1459...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>1500m Women</td>\n",
       "      <td>HALL</td>\n",
       "      <td>Linden</td>\n",
       "      <td>Australia</td>\n",
       "      <td></td>\n",
       "      <td>4:00.86</td>\n",
       "      <td>20/06/1991</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1427...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>1500m Women</td>\n",
       "      <td>EMBAYE</td>\n",
       "      <td>Axumawit</td>\n",
       "      <td>Ethiopia</td>\n",
       "      <td>4:00.17</td>\n",
       "      <td>4:00.17</td>\n",
       "      <td>18/10/1994</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1453...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231</th>\n",
       "      <td>1500m Women</td>\n",
       "      <td>MUIR</td>\n",
       "      <td>Laura</td>\n",
       "      <td>Great Britain &amp; NI</td>\n",
       "      <td>4:05.37</td>\n",
       "      <td>3:55.22</td>\n",
       "      <td>09/05/1993</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1442...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>1500m Women</td>\n",
       "      <td>HOULIHAN</td>\n",
       "      <td>Shelby</td>\n",
       "      <td>United States</td>\n",
       "      <td></td>\n",
       "      <td>3:57.34</td>\n",
       "      <td>08/02/1993</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1436...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>1500m Women</td>\n",
       "      <td>GRACE</td>\n",
       "      <td>Kate</td>\n",
       "      <td>United States</td>\n",
       "      <td></td>\n",
       "      <td>4:03.59</td>\n",
       "      <td>24/10/1988</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1432...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>1500m Women</td>\n",
       "      <td>BISHOP</td>\n",
       "      <td>Melissa</td>\n",
       "      <td>Canada</td>\n",
       "      <td>4:09.36</td>\n",
       "      <td>4:09.36</td>\n",
       "      <td>05/08/1988</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1426...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213</th>\n",
       "      <td>1500m Women</td>\n",
       "      <td>KIPYEGON</td>\n",
       "      <td>Faith</td>\n",
       "      <td>Kenya</td>\n",
       "      <td></td>\n",
       "      <td>3:56.41</td>\n",
       "      <td>10/01/1994</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1441...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177</th>\n",
       "      <td>1500m Women</td>\n",
       "      <td>HULL</td>\n",
       "      <td>Jessica</td>\n",
       "      <td>Australia</td>\n",
       "      <td>4:09.90</td>\n",
       "      <td>4:08.75</td>\n",
       "      <td>22/10/1996</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1446...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>1500m Women</td>\n",
       "      <td>EFRAIMSON</td>\n",
       "      <td>Alexa</td>\n",
       "      <td>United States</td>\n",
       "      <td>4:04.06</td>\n",
       "      <td>4:03.39</td>\n",
       "      <td>20/02/1997</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1452...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>1500m Women</td>\n",
       "      <td>CHEBET</td>\n",
       "      <td>Winny</td>\n",
       "      <td>Kenya</td>\n",
       "      <td>4:02.84</td>\n",
       "      <td>3:59.16</td>\n",
       "      <td>20/12/1990</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1428...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1500m Women</td>\n",
       "      <td>ARAFI</td>\n",
       "      <td>Rababe</td>\n",
       "      <td>Morocco</td>\n",
       "      <td>4:01.15</td>\n",
       "      <td>3:59.15</td>\n",
       "      <td>12/01/1991</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1429...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>249</th>\n",
       "      <td>1500m Women</td>\n",
       "      <td>SAMUEL</td>\n",
       "      <td>Alemaz</td>\n",
       "      <td>Ethiopia</td>\n",
       "      <td>4:03.79</td>\n",
       "      <td>4:01.78</td>\n",
       "      <td>05/07/1999</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1471...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>400m Hurdles Men</td>\n",
       "      <td>HOLMES</td>\n",
       "      <td>TJ</td>\n",
       "      <td>United States</td>\n",
       "      <td></td>\n",
       "      <td>48.30</td>\n",
       "      <td>02/07/1995</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1453...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>400m Hurdles Men</td>\n",
       "      <td>SAMBA</td>\n",
       "      <td>Abderrahman</td>\n",
       "      <td>Qatar</td>\n",
       "      <td>47.51</td>\n",
       "      <td>46.98</td>\n",
       "      <td>05/09/1995</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1475...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>Women's 3000m Steeplechase</td>\n",
       "      <td>JEPKEMEI</td>\n",
       "      <td>Daisy</td>\n",
       "      <td>Kenya</td>\n",
       "      <td></td>\n",
       "      <td>9:10.71</td>\n",
       "      <td>13/02/1996</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1453...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186</th>\n",
       "      <td>Women's 3000m Steeplechase</td>\n",
       "      <td>QUIGLEY</td>\n",
       "      <td>Colleen</td>\n",
       "      <td>United States</td>\n",
       "      <td></td>\n",
       "      <td>9:10.27</td>\n",
       "      <td>20/11/1992</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1443...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Women's 3000m Steeplechase</td>\n",
       "      <td>CHEPKOECH</td>\n",
       "      <td>Beatrice</td>\n",
       "      <td>Kenya</td>\n",
       "      <td></td>\n",
       "      <td>8:44.32</td>\n",
       "      <td>06/07/1991</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1438...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>Women's 3000m Steeplechase</td>\n",
       "      <td>Felicitas</td>\n",
       "      <td>Gesa</td>\n",
       "      <td>Germany</td>\n",
       "      <td></td>\n",
       "      <td>9:11.85</td>\n",
       "      <td>03/08/1992</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1432...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>Women's 3000m Steeplechase</td>\n",
       "      <td>FRERICHS</td>\n",
       "      <td>Courtney</td>\n",
       "      <td>United States</td>\n",
       "      <td></td>\n",
       "      <td>9:00.85</td>\n",
       "      <td>18/01/1993</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1450...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Women's 3000m Steeplechase</td>\n",
       "      <td>Chepteek</td>\n",
       "      <td>Celliphine</td>\n",
       "      <td>Kenya</td>\n",
       "      <td></td>\n",
       "      <td>8:58.78</td>\n",
       "      <td>23/03/1999</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1471...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>Women's 3000m Steeplechase</td>\n",
       "      <td>COBURN</td>\n",
       "      <td>Emma</td>\n",
       "      <td>United States</td>\n",
       "      <td></td>\n",
       "      <td>9:02.58</td>\n",
       "      <td>19/10/1990</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1430...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>240</th>\n",
       "      <td>Women's 3000m Steeplechase</td>\n",
       "      <td>Mutile</td>\n",
       "      <td>Winfred</td>\n",
       "      <td>Bahrain</td>\n",
       "      <td>9:46.18</td>\n",
       "      <td>9:10.74</td>\n",
       "      <td>31/12/1999</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1469...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Women's 3000m Steeplechase</td>\n",
       "      <td>CHEMUTAI</td>\n",
       "      <td>Peruth</td>\n",
       "      <td>Uganda</td>\n",
       "      <td></td>\n",
       "      <td>9:07.94</td>\n",
       "      <td>10/07/1999</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1470...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>Women's 3000m Steeplechase</td>\n",
       "      <td>JERUTO</td>\n",
       "      <td>Norah</td>\n",
       "      <td>Kenya</td>\n",
       "      <td></td>\n",
       "      <td>8:59.62</td>\n",
       "      <td>02/10/1995</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1447...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222</th>\n",
       "      <td>Women's 3000m Steeplechase</td>\n",
       "      <td>XU</td>\n",
       "      <td>Shuangshuang</td>\n",
       "      <td>PR of China</td>\n",
       "      <td>9:51.76</td>\n",
       "      <td>9:47.42</td>\n",
       "      <td>06/04/1996</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1453...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Women's 3000m Steeplechase</td>\n",
       "      <td>CHEPNGETICH</td>\n",
       "      <td>Roseline</td>\n",
       "      <td>Kenya</td>\n",
       "      <td></td>\n",
       "      <td>9:08.23</td>\n",
       "      <td>17/06/1997</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1453...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>Women's 3000m Steeplechase</td>\n",
       "      <td>KIYENG</td>\n",
       "      <td>Hyvin</td>\n",
       "      <td>Kenya</td>\n",
       "      <td></td>\n",
       "      <td>9:00.01</td>\n",
       "      <td>13/01/1992</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1447...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>204</th>\n",
       "      <td>Women's 3000m Steeplechase</td>\n",
       "      <td>TUIGONG</td>\n",
       "      <td>Caroline</td>\n",
       "      <td>Kenya</td>\n",
       "      <td></td>\n",
       "      <td>9:28.81</td>\n",
       "      <td>12/03/1990</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1428...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Women's High Jump</td>\n",
       "      <td>CUNNINGHAM</td>\n",
       "      <td>Vashti</td>\n",
       "      <td>United States</td>\n",
       "      <td>1.94</td>\n",
       "      <td>1.99</td>\n",
       "      <td>18/01/1998</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1448...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>Women's High Jump</td>\n",
       "      <td>LEVCHENKO</td>\n",
       "      <td>Yuliya</td>\n",
       "      <td>Ukraine</td>\n",
       "      <td></td>\n",
       "      <td>2.01</td>\n",
       "      <td>28/11/1997</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1459...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Women's High Jump</td>\n",
       "      <td>KINSEY</td>\n",
       "      <td>Erika</td>\n",
       "      <td>Sweden</td>\n",
       "      <td></td>\n",
       "      <td>1.97</td>\n",
       "      <td>10/03/1988</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1430...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>Women's High Jump</td>\n",
       "      <td>PALÅ YTÃ</td>\n",
       "      <td>AirinÃ©</td>\n",
       "      <td>Lithuania</td>\n",
       "      <td></td>\n",
       "      <td>1.98</td>\n",
       "      <td>13/07/1992</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1429...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>Women's High Jump</td>\n",
       "      <td>LASITSKENE</td>\n",
       "      <td>Mariya</td>\n",
       "      <td>Authorised Neutral Athlete</td>\n",
       "      <td></td>\n",
       "      <td>2.06</td>\n",
       "      <td>14/01/1993</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1429...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>Women's High Jump</td>\n",
       "      <td>MAHUCHIKH</td>\n",
       "      <td>Yaroslava</td>\n",
       "      <td>Ukraine</td>\n",
       "      <td></td>\n",
       "      <td>1.95</td>\n",
       "      <td>19/09/2001</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1473...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Women's High Jump</td>\n",
       "      <td>LAKE</td>\n",
       "      <td>Morgan</td>\n",
       "      <td>Great Britain &amp; NI</td>\n",
       "      <td></td>\n",
       "      <td>1.97</td>\n",
       "      <td>12/05/1997</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1440...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>Women's Shot Put</td>\n",
       "      <td>THOMAS-DODD</td>\n",
       "      <td>Danniel</td>\n",
       "      <td>Jamaica</td>\n",
       "      <td>19.48</td>\n",
       "      <td>19.48</td>\n",
       "      <td>11/11/1992</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1446...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Women's Shot Put</td>\n",
       "      <td>EALEY</td>\n",
       "      <td>Chase</td>\n",
       "      <td>United States</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>20/07/1994</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1453...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>Women's Shot Put</td>\n",
       "      <td>SCHWANITZ</td>\n",
       "      <td>Christina</td>\n",
       "      <td>Germany</td>\n",
       "      <td></td>\n",
       "      <td>20.77</td>\n",
       "      <td>24/12/1985</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1427...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>Women's Shot Put</td>\n",
       "      <td>SAUNDERS</td>\n",
       "      <td>Raven</td>\n",
       "      <td>United States</td>\n",
       "      <td></td>\n",
       "      <td>19.76</td>\n",
       "      <td>15/05/1996</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1461...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>Women's Shot Put</td>\n",
       "      <td>EWEN</td>\n",
       "      <td>Maggie</td>\n",
       "      <td>United States</td>\n",
       "      <td></td>\n",
       "      <td>19.46</td>\n",
       "      <td>23/09/1994</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1442...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>Women's Shot Put</td>\n",
       "      <td>MÃRTON</td>\n",
       "      <td>Anita</td>\n",
       "      <td>Hungary</td>\n",
       "      <td>17.85</td>\n",
       "      <td>19.87</td>\n",
       "      <td>15/01/1989</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1428...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>Women's Shot Put</td>\n",
       "      <td>GONG</td>\n",
       "      <td>Lijiao</td>\n",
       "      <td>PR of China</td>\n",
       "      <td>19.18</td>\n",
       "      <td>20.43</td>\n",
       "      <td>24/01/1989</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1426...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Women's Shot Put</td>\n",
       "      <td>CARTER</td>\n",
       "      <td>Michelle</td>\n",
       "      <td>United States</td>\n",
       "      <td></td>\n",
       "      <td>20.63</td>\n",
       "      <td>12/10/1985</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1430...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Women's Shot Put</td>\n",
       "      <td>DUBITSKAYA</td>\n",
       "      <td>Aliona</td>\n",
       "      <td>Belarus</td>\n",
       "      <td></td>\n",
       "      <td>19.21</td>\n",
       "      <td>25/01/1990</td>\n",
       "      <td>https://eugene.diamondleague.com/athletes/1426...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>105 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     event_name     last_name    first_name  \\\n",
       "143                  1 Mile Men      KAAZOUZI        Brahim   \n",
       "125                  1 Mile Men  INGEBRIGTSEN         Jakob   \n",
       "107                  1 Mile Men  INGEBRIGTSEN         Filip   \n",
       "35                   1 Mile Men    CENTROWITZ       Matthew   \n",
       "161                  1 Mile Men       Motonei        Elijah   \n",
       "71                   1 Mile Men        ENGELS         Craig   \n",
       "197                  1 Mile Men        TEFERA        Samuel   \n",
       "17                   1 Mile Men        BIRGEN      Bethwell   \n",
       "179                  1 Mile Men     SOULEIMAN       Ayanleh   \n",
       "215                  1 Mile Men        WILLIS          Nick   \n",
       "233                  1 Mile Men          WOTE          Aman   \n",
       "89                   1 Mile Men      GREGOREK          John   \n",
       "53                   1 Mile Men     CHERUIYOT       Timothy   \n",
       "195                 1500m Women         JONES      Danielle   \n",
       "123                 1500m Women         HAILU        Lemlem   \n",
       "267                 1500m Women        TSEGAY         Gudaf   \n",
       "141                 1500m Women          HALL        Linden   \n",
       "87                  1500m Women        EMBAYE      Axumawit   \n",
       "231                 1500m Women          MUIR         Laura   \n",
       "159                 1500m Women      HOULIHAN        Shelby   \n",
       "105                 1500m Women         GRACE          Kate   \n",
       "33                  1500m Women        BISHOP       Melissa   \n",
       "213                 1500m Women      KIPYEGON         Faith   \n",
       "177                 1500m Women          HULL       Jessica   \n",
       "69                  1500m Women     EFRAIMSON         Alexa   \n",
       "51                  1500m Women        CHEBET         Winny   \n",
       "15                  1500m Women         ARAFI        Rababe   \n",
       "249                 1500m Women        SAMUEL        Alemaz   \n",
       "58             400m Hurdles Men        HOLMES            TJ   \n",
       "112            400m Hurdles Men         SAMBA   Abderrahman   \n",
       "..                          ...           ...           ...   \n",
       "114  Women's 3000m Steeplechase      JEPKEMEI         Daisy   \n",
       "186  Women's 3000m Steeplechase       QUIGLEY       Colleen   \n",
       "24   Women's 3000m Steeplechase     CHEPKOECH      Beatrice   \n",
       "168  Women's 3000m Steeplechase     Felicitas          Gesa   \n",
       "96   Women's 3000m Steeplechase      FRERICHS      Courtney   \n",
       "60   Women's 3000m Steeplechase      Chepteek    Celliphine   \n",
       "78   Women's 3000m Steeplechase        COBURN          Emma   \n",
       "240  Women's 3000m Steeplechase        Mutile       Winfred   \n",
       "6    Women's 3000m Steeplechase      CHEMUTAI        Peruth   \n",
       "132  Women's 3000m Steeplechase        JERUTO         Norah   \n",
       "222  Women's 3000m Steeplechase            XU  Shuangshuang   \n",
       "42   Women's 3000m Steeplechase   CHEPNGETICH      Roseline   \n",
       "150  Women's 3000m Steeplechase        KIYENG         Hyvin   \n",
       "204  Women's 3000m Steeplechase       TUIGONG      Caroline   \n",
       "5             Women's High Jump    CUNNINGHAM        Vashti   \n",
       "77            Women's High Jump     LEVCHENKO        Yuliya   \n",
       "23            Women's High Jump        KINSEY         Erika   \n",
       "113           Women's High Jump     PALÅ YTÃ       AirinÃ©   \n",
       "59            Women's High Jump    LASITSKENE        Mariya   \n",
       "95            Women's High Jump     MAHUCHIKH     Yaroslava   \n",
       "41            Women's High Jump          LAKE        Morgan   \n",
       "147            Women's Shot Put   THOMAS-DODD       Danniel   \n",
       "39             Women's Shot Put         EALEY         Chase   \n",
       "129            Women's Shot Put     SCHWANITZ     Christina   \n",
       "111            Women's Shot Put      SAUNDERS         Raven   \n",
       "57             Women's Shot Put          EWEN        Maggie   \n",
       "93             Women's Shot Put       MÃRTON         Anita   \n",
       "75             Women's Shot Put          GONG        Lijiao   \n",
       "3              Women's Shot Put        CARTER      Michelle   \n",
       "21             Women's Shot Put    DUBITSKAYA        Aliona   \n",
       "\n",
       "                        country athlete_sb athlete_pb   birthdate  \\\n",
       "143                     Morocco                        15/06/1990   \n",
       "125                      Norway               3:52.28  19/09/2000   \n",
       "107                      Norway               3:53.23  20/04/1993   \n",
       "35                United States               3:50.53  18/10/1989   \n",
       "161                       Kenya               3:49.08  05/01/1993   \n",
       "71                United States               3:55.12  01/05/1994   \n",
       "197                    Ethiopia               3:51.26  23/10/1999   \n",
       "17                        Kenya               3:50.42  06/08/1988   \n",
       "179                    Djibouti               3:47.32  03/12/1992   \n",
       "215                 New Zealand               3:49.83  25/04/1983   \n",
       "233                    Ethiopia               3:48.60  18/04/1984   \n",
       "89                United States               3:54.53  07/12/1991   \n",
       "53                        Kenya               3:49.64  20/11/1995   \n",
       "195               United States    4:20.57    4:07.33  21/08/1996   \n",
       "123                    Ethiopia               4:20.36  21/05/2001   \n",
       "267                    Ethiopia    3:59.57    3:57.64  23/01/1997   \n",
       "141                   Australia               4:00.86  20/06/1991   \n",
       "87                     Ethiopia    4:00.17    4:00.17  18/10/1994   \n",
       "231          Great Britain & NI    4:05.37    3:55.22  09/05/1993   \n",
       "159               United States               3:57.34  08/02/1993   \n",
       "105               United States               4:03.59  24/10/1988   \n",
       "33                       Canada    4:09.36    4:09.36  05/08/1988   \n",
       "213                       Kenya               3:56.41  10/01/1994   \n",
       "177                   Australia    4:09.90    4:08.75  22/10/1996   \n",
       "69                United States    4:04.06    4:03.39  20/02/1997   \n",
       "51                        Kenya    4:02.84    3:59.16  20/12/1990   \n",
       "15                      Morocco    4:01.15    3:59.15  12/01/1991   \n",
       "249                    Ethiopia    4:03.79    4:01.78  05/07/1999   \n",
       "58                United States                 48.30  02/07/1995   \n",
       "112                       Qatar      47.51      46.98  05/09/1995   \n",
       "..                          ...        ...        ...         ...   \n",
       "114                       Kenya               9:10.71  13/02/1996   \n",
       "186               United States               9:10.27  20/11/1992   \n",
       "24                        Kenya               8:44.32  06/07/1991   \n",
       "168                     Germany               9:11.85  03/08/1992   \n",
       "96                United States               9:00.85  18/01/1993   \n",
       "60                        Kenya               8:58.78  23/03/1999   \n",
       "78                United States               9:02.58  19/10/1990   \n",
       "240                     Bahrain    9:46.18    9:10.74  31/12/1999   \n",
       "6                        Uganda               9:07.94  10/07/1999   \n",
       "132                       Kenya               8:59.62  02/10/1995   \n",
       "222                 PR of China    9:51.76    9:47.42  06/04/1996   \n",
       "42                        Kenya               9:08.23  17/06/1997   \n",
       "150                       Kenya               9:00.01  13/01/1992   \n",
       "204                       Kenya               9:28.81  12/03/1990   \n",
       "5                 United States       1.94       1.99  18/01/1998   \n",
       "77                      Ukraine                  2.01  28/11/1997   \n",
       "23                       Sweden                  1.97  10/03/1988   \n",
       "113                   Lithuania                  1.98  13/07/1992   \n",
       "59   Authorised Neutral Athlete                  2.06  14/01/1993   \n",
       "95                      Ukraine                  1.95  19/09/2001   \n",
       "41           Great Britain & NI                  1.97  12/05/1997   \n",
       "147                     Jamaica      19.48      19.48  11/11/1992   \n",
       "39                United States                        20/07/1994   \n",
       "129                     Germany                 20.77  24/12/1985   \n",
       "111               United States                 19.76  15/05/1996   \n",
       "57                United States                 19.46  23/09/1994   \n",
       "93                      Hungary      17.85      19.87  15/01/1989   \n",
       "75                  PR of China      19.18      20.43  24/01/1989   \n",
       "3                 United States                 20.63  12/10/1985   \n",
       "21                      Belarus                 19.21  25/01/1990   \n",
       "\n",
       "                                          athlete_href  \n",
       "143  https://eugene.diamondleague.com/athletes/1447...  \n",
       "125  https://eugene.diamondleague.com/athletes/1465...  \n",
       "107  https://eugene.diamondleague.com/athletes/1445...  \n",
       "35   https://eugene.diamondleague.com/athletes/1423...  \n",
       "161  https://eugene.diamondleague.com/athletes/1459...  \n",
       "71   https://eugene.diamondleague.com/athletes/1446...  \n",
       "197  https://eugene.diamondleague.com/athletes/1479...  \n",
       "17   https://eugene.diamondleague.com/athletes/1436...  \n",
       "179  https://eugene.diamondleague.com/athletes/1437...  \n",
       "215  https://eugene.diamondleague.com/athletes/1421...  \n",
       "233  https://eugene.diamondleague.com/athletes/1442...  \n",
       "89   https://eugene.diamondleague.com/athletes/1450...  \n",
       "53   https://eugene.diamondleague.com/athletes/1464...  \n",
       "195  https://eugene.diamondleague.com/athletes/1447...  \n",
       "123  https://eugene.diamondleague.com/athletes/1480...  \n",
       "267  https://eugene.diamondleague.com/athletes/1459...  \n",
       "141  https://eugene.diamondleague.com/athletes/1427...  \n",
       "87   https://eugene.diamondleague.com/athletes/1453...  \n",
       "231  https://eugene.diamondleague.com/athletes/1442...  \n",
       "159  https://eugene.diamondleague.com/athletes/1436...  \n",
       "105  https://eugene.diamondleague.com/athletes/1432...  \n",
       "33   https://eugene.diamondleague.com/athletes/1426...  \n",
       "213  https://eugene.diamondleague.com/athletes/1441...  \n",
       "177  https://eugene.diamondleague.com/athletes/1446...  \n",
       "69   https://eugene.diamondleague.com/athletes/1452...  \n",
       "51   https://eugene.diamondleague.com/athletes/1428...  \n",
       "15   https://eugene.diamondleague.com/athletes/1429...  \n",
       "249  https://eugene.diamondleague.com/athletes/1471...  \n",
       "58   https://eugene.diamondleague.com/athletes/1453...  \n",
       "112  https://eugene.diamondleague.com/athletes/1475...  \n",
       "..                                                 ...  \n",
       "114  https://eugene.diamondleague.com/athletes/1453...  \n",
       "186  https://eugene.diamondleague.com/athletes/1443...  \n",
       "24   https://eugene.diamondleague.com/athletes/1438...  \n",
       "168  https://eugene.diamondleague.com/athletes/1432...  \n",
       "96   https://eugene.diamondleague.com/athletes/1450...  \n",
       "60   https://eugene.diamondleague.com/athletes/1471...  \n",
       "78   https://eugene.diamondleague.com/athletes/1430...  \n",
       "240  https://eugene.diamondleague.com/athletes/1469...  \n",
       "6    https://eugene.diamondleague.com/athletes/1470...  \n",
       "132  https://eugene.diamondleague.com/athletes/1447...  \n",
       "222  https://eugene.diamondleague.com/athletes/1453...  \n",
       "42   https://eugene.diamondleague.com/athletes/1453...  \n",
       "150  https://eugene.diamondleague.com/athletes/1447...  \n",
       "204  https://eugene.diamondleague.com/athletes/1428...  \n",
       "5    https://eugene.diamondleague.com/athletes/1448...  \n",
       "77   https://eugene.diamondleague.com/athletes/1459...  \n",
       "23   https://eugene.diamondleague.com/athletes/1430...  \n",
       "113  https://eugene.diamondleague.com/athletes/1429...  \n",
       "59   https://eugene.diamondleague.com/athletes/1429...  \n",
       "95   https://eugene.diamondleague.com/athletes/1473...  \n",
       "41   https://eugene.diamondleague.com/athletes/1440...  \n",
       "147  https://eugene.diamondleague.com/athletes/1446...  \n",
       "39   https://eugene.diamondleague.com/athletes/1453...  \n",
       "129  https://eugene.diamondleague.com/athletes/1427...  \n",
       "111  https://eugene.diamondleague.com/athletes/1461...  \n",
       "57   https://eugene.diamondleague.com/athletes/1442...  \n",
       "93   https://eugene.diamondleague.com/athletes/1428...  \n",
       "75   https://eugene.diamondleague.com/athletes/1426...  \n",
       "3    https://eugene.diamondleague.com/athletes/1430...  \n",
       "21   https://eugene.diamondleague.com/athletes/1426...  \n",
       "\n",
       "[105 rows x 8 columns]"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.to_csv('pre_stats.csv', index=False)"
   ]
  }
 ],
 "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.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}