{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "def olympic_crud():"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_athlete = pd.read_csv(\"../Project2/data/athlete_events.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>ID</th>\n",
       "      <th>Name</th>\n",
       "      <th>Sex</th>\n",
       "      <th>Age</th>\n",
       "      <th>Height</th>\n",
       "      <th>Weight</th>\n",
       "      <th>Team</th>\n",
       "      <th>NOC</th>\n",
       "      <th>Games</th>\n",
       "      <th>Year</th>\n",
       "      <th>Season</th>\n",
       "      <th>City</th>\n",
       "      <th>Sport</th>\n",
       "      <th>Event</th>\n",
       "      <th>Medal</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>A Dijiang</td>\n",
       "      <td>M</td>\n",
       "      <td>24.0</td>\n",
       "      <td>180.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>1992 Summer</td>\n",
       "      <td>1992</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>Basketball</td>\n",
       "      <td>Basketball Men's Basketball</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>A Lamusi</td>\n",
       "      <td>M</td>\n",
       "      <td>23.0</td>\n",
       "      <td>170.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2012 Summer</td>\n",
       "      <td>2012</td>\n",
       "      <td>Summer</td>\n",
       "      <td>London</td>\n",
       "      <td>Judo</td>\n",
       "      <td>Judo Men's Extra-Lightweight</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Gunnar Nielsen Aaby</td>\n",
       "      <td>M</td>\n",
       "      <td>24.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Denmark</td>\n",
       "      <td>DEN</td>\n",
       "      <td>1920 Summer</td>\n",
       "      <td>1920</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Antwerpen</td>\n",
       "      <td>Football</td>\n",
       "      <td>Football Men's Football</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Edgar Lindenau Aabye</td>\n",
       "      <td>M</td>\n",
       "      <td>34.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Denmark/Sweden</td>\n",
       "      <td>DEN</td>\n",
       "      <td>1900 Summer</td>\n",
       "      <td>1900</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Paris</td>\n",
       "      <td>Tug-Of-War</td>\n",
       "      <td>Tug-Of-War Men's Tug-Of-War</td>\n",
       "      <td>Gold</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Christine Jacoba Aaftink</td>\n",
       "      <td>F</td>\n",
       "      <td>21.0</td>\n",
       "      <td>185.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>Netherlands</td>\n",
       "      <td>NED</td>\n",
       "      <td>1988 Winter</td>\n",
       "      <td>1988</td>\n",
       "      <td>Winter</td>\n",
       "      <td>Calgary</td>\n",
       "      <td>Speed Skating</td>\n",
       "      <td>Speed Skating Women's 500 metres</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   ID                      Name Sex   Age  Height  Weight            Team  \\\n",
       "0   1                 A Dijiang   M  24.0   180.0    80.0           China   \n",
       "1   2                  A Lamusi   M  23.0   170.0    60.0           China   \n",
       "2   3       Gunnar Nielsen Aaby   M  24.0     NaN     NaN         Denmark   \n",
       "3   4      Edgar Lindenau Aabye   M  34.0     NaN     NaN  Denmark/Sweden   \n",
       "4   5  Christine Jacoba Aaftink   F  21.0   185.0    82.0     Netherlands   \n",
       "\n",
       "   NOC        Games  Year  Season       City          Sport  \\\n",
       "0  CHN  1992 Summer  1992  Summer  Barcelona     Basketball   \n",
       "1  CHN  2012 Summer  2012  Summer     London           Judo   \n",
       "2  DEN  1920 Summer  1920  Summer  Antwerpen       Football   \n",
       "3  DEN  1900 Summer  1900  Summer      Paris     Tug-Of-War   \n",
       "4  NED  1988 Winter  1988  Winter    Calgary  Speed Skating   \n",
       "\n",
       "                              Event Medal  \n",
       "0       Basketball Men's Basketball   NaN  \n",
       "1      Judo Men's Extra-Lightweight   NaN  \n",
       "2           Football Men's Football   NaN  \n",
       "3       Tug-Of-War Men's Tug-Of-War  Gold  \n",
       "4  Speed Skating Women's 500 metres   NaN  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_athlete.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_noc = pd.read_csv(\"../Project2/data/noc_regions.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>NOC</th>\n",
       "      <th>region</th>\n",
       "      <th>notes</th>\n",
       "      <th>Lat</th>\n",
       "      <th>Lng</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AFG</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>33.9391</td>\n",
       "      <td>67.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AHO</td>\n",
       "      <td>Curacao</td>\n",
       "      <td>Netherlands Antilles</td>\n",
       "      <td>12.1696</td>\n",
       "      <td>68.99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ALB</td>\n",
       "      <td>Albania</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ALG</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AND</td>\n",
       "      <td>Andorra</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   NOC       region                 notes      Lat    Lng\n",
       "0  AFG  Afghanistan                   NaN  33.9391  67.71\n",
       "1  AHO      Curacao  Netherlands Antilles  12.1696  68.99\n",
       "2  ALB      Albania                   NaN      NaN    NaN\n",
       "3  ALG      Algeria                   NaN      NaN    NaN\n",
       "4  AND      Andorra                   NaN      NaN    NaN"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_noc.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "athlete_noc_pd = pd.merge(df_athlete, df_noc, on='NOC', how='outer')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>ID</th>\n",
       "      <th>Name</th>\n",
       "      <th>Sex</th>\n",
       "      <th>Age</th>\n",
       "      <th>Height</th>\n",
       "      <th>Weight</th>\n",
       "      <th>Team</th>\n",
       "      <th>NOC</th>\n",
       "      <th>Games</th>\n",
       "      <th>Year</th>\n",
       "      <th>Season</th>\n",
       "      <th>City</th>\n",
       "      <th>Sport</th>\n",
       "      <th>Event</th>\n",
       "      <th>Medal</th>\n",
       "      <th>region</th>\n",
       "      <th>notes</th>\n",
       "      <th>Lat</th>\n",
       "      <th>Lng</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>A Dijiang</td>\n",
       "      <td>M</td>\n",
       "      <td>24.0</td>\n",
       "      <td>180.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>1992 Summer</td>\n",
       "      <td>1992</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>Basketball</td>\n",
       "      <td>Basketball Men's Basketball</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>A Lamusi</td>\n",
       "      <td>M</td>\n",
       "      <td>23.0</td>\n",
       "      <td>170.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2012 Summer</td>\n",
       "      <td>2012</td>\n",
       "      <td>Summer</td>\n",
       "      <td>London</td>\n",
       "      <td>Judo</td>\n",
       "      <td>Judo Men's Extra-Lightweight</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>602</td>\n",
       "      <td>Abudoureheman</td>\n",
       "      <td>M</td>\n",
       "      <td>22.0</td>\n",
       "      <td>182.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2000 Summer</td>\n",
       "      <td>2000</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Sydney</td>\n",
       "      <td>Boxing</td>\n",
       "      <td>Boxing Men's Middleweight</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1463</td>\n",
       "      <td>Ai Linuer</td>\n",
       "      <td>M</td>\n",
       "      <td>25.0</td>\n",
       "      <td>160.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2004 Summer</td>\n",
       "      <td>2004</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Athina</td>\n",
       "      <td>Wrestling</td>\n",
       "      <td>Wrestling Men's Lightweight, Greco-Roman</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1464</td>\n",
       "      <td>Ai Yanhan</td>\n",
       "      <td>F</td>\n",
       "      <td>14.0</td>\n",
       "      <td>168.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2016 Summer</td>\n",
       "      <td>2016</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>Swimming</td>\n",
       "      <td>Swimming Women's 200 metres Freestyle</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1464</td>\n",
       "      <td>Ai Yanhan</td>\n",
       "      <td>F</td>\n",
       "      <td>14.0</td>\n",
       "      <td>168.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2016 Summer</td>\n",
       "      <td>2016</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>Swimming</td>\n",
       "      <td>Swimming Women's 4 x 200 metres Freestyle Relay</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>3605</td>\n",
       "      <td>An Weijiang</td>\n",
       "      <td>M</td>\n",
       "      <td>22.0</td>\n",
       "      <td>178.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2006 Winter</td>\n",
       "      <td>2006</td>\n",
       "      <td>Winter</td>\n",
       "      <td>Torino</td>\n",
       "      <td>Speed Skating</td>\n",
       "      <td>Speed Skating Men's 500 metres</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>3605</td>\n",
       "      <td>An Weijiang</td>\n",
       "      <td>M</td>\n",
       "      <td>22.0</td>\n",
       "      <td>178.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2006 Winter</td>\n",
       "      <td>2006</td>\n",
       "      <td>Winter</td>\n",
       "      <td>Torino</td>\n",
       "      <td>Speed Skating</td>\n",
       "      <td>Speed Skating Men's 1,000 metres</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>3610</td>\n",
       "      <td>An Yulong</td>\n",
       "      <td>M</td>\n",
       "      <td>19.0</td>\n",
       "      <td>173.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>1998 Winter</td>\n",
       "      <td>1998</td>\n",
       "      <td>Winter</td>\n",
       "      <td>Nagano</td>\n",
       "      <td>Short Track Speed Skating</td>\n",
       "      <td>Short Track Speed Skating Men's 500 metres</td>\n",
       "      <td>Silver</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>3610</td>\n",
       "      <td>An Yulong</td>\n",
       "      <td>M</td>\n",
       "      <td>19.0</td>\n",
       "      <td>173.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>1998 Winter</td>\n",
       "      <td>1998</td>\n",
       "      <td>Winter</td>\n",
       "      <td>Nagano</td>\n",
       "      <td>Short Track Speed Skating</td>\n",
       "      <td>Short Track Speed Skating Men's 1,000 metres</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>3610</td>\n",
       "      <td>An Yulong</td>\n",
       "      <td>M</td>\n",
       "      <td>19.0</td>\n",
       "      <td>173.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>1998 Winter</td>\n",
       "      <td>1998</td>\n",
       "      <td>Winter</td>\n",
       "      <td>Nagano</td>\n",
       "      <td>Short Track Speed Skating</td>\n",
       "      <td>Short Track Speed Skating Men's 5,000 metres R...</td>\n",
       "      <td>Bronze</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>3610</td>\n",
       "      <td>An Yulong</td>\n",
       "      <td>M</td>\n",
       "      <td>23.0</td>\n",
       "      <td>173.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2002 Winter</td>\n",
       "      <td>2002</td>\n",
       "      <td>Winter</td>\n",
       "      <td>Salt Lake City</td>\n",
       "      <td>Short Track Speed Skating</td>\n",
       "      <td>Short Track Speed Skating Men's 5,000 metres R...</td>\n",
       "      <td>Bronze</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>3611</td>\n",
       "      <td>An Zhongxin</td>\n",
       "      <td>F</td>\n",
       "      <td>23.0</td>\n",
       "      <td>170.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>1996 Summer</td>\n",
       "      <td>1996</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Atlanta</td>\n",
       "      <td>Softball</td>\n",
       "      <td>Softball Women's Softball</td>\n",
       "      <td>Silver</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>3611</td>\n",
       "      <td>An Zhongxin</td>\n",
       "      <td>F</td>\n",
       "      <td>27.0</td>\n",
       "      <td>170.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2000 Summer</td>\n",
       "      <td>2000</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Sydney</td>\n",
       "      <td>Softball</td>\n",
       "      <td>Softball Women's Softball</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>4639</td>\n",
       "      <td>Ao Changrong</td>\n",
       "      <td>M</td>\n",
       "      <td>25.0</td>\n",
       "      <td>173.0</td>\n",
       "      <td>71.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2008 Summer</td>\n",
       "      <td>2008</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Beijing</td>\n",
       "      <td>Hockey</td>\n",
       "      <td>Hockey Men's Hockey</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>4641</td>\n",
       "      <td>Ao Tegen</td>\n",
       "      <td>M</td>\n",
       "      <td>21.0</td>\n",
       "      <td>181.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>1996 Summer</td>\n",
       "      <td>1996</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Atlanta</td>\n",
       "      <td>Judo</td>\n",
       "      <td>Judo Men's Middleweight</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>6376</td>\n",
       "      <td>Ba Dexin</td>\n",
       "      <td>M</td>\n",
       "      <td>23.0</td>\n",
       "      <td>185.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2014 Winter</td>\n",
       "      <td>2014</td>\n",
       "      <td>Winter</td>\n",
       "      <td>Sochi</td>\n",
       "      <td>Curling</td>\n",
       "      <td>Curling Men's Curling</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>6381</td>\n",
       "      <td>Ba Yan</td>\n",
       "      <td>F</td>\n",
       "      <td>21.0</td>\n",
       "      <td>183.0</td>\n",
       "      <td>78.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>1984 Summer</td>\n",
       "      <td>1984</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Los Angeles</td>\n",
       "      <td>Basketball</td>\n",
       "      <td>Basketball Women's Basketball</td>\n",
       "      <td>Bronze</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>6382</td>\n",
       "      <td>Ba Yanchuan</td>\n",
       "      <td>M</td>\n",
       "      <td>24.0</td>\n",
       "      <td>187.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>1996 Summer</td>\n",
       "      <td>1996</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Atlanta</td>\n",
       "      <td>Wrestling</td>\n",
       "      <td>Wrestling Men's Heavyweight, Greco-Roman</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>6383</td>\n",
       "      <td>Ba Yongshan</td>\n",
       "      <td>M</td>\n",
       "      <td>22.0</td>\n",
       "      <td>180.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>1984 Summer</td>\n",
       "      <td>1984</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Los Angeles</td>\n",
       "      <td>Archery</td>\n",
       "      <td>Archery Men's Individual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>6847</td>\n",
       "      <td>Bai Anqi</td>\n",
       "      <td>F</td>\n",
       "      <td>19.0</td>\n",
       "      <td>164.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2012 Summer</td>\n",
       "      <td>2012</td>\n",
       "      <td>Summer</td>\n",
       "      <td>London</td>\n",
       "      <td>Swimming</td>\n",
       "      <td>Swimming Women's 200 metres Backstroke</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>6848</td>\n",
       "      <td>Bai Chongguang</td>\n",
       "      <td>M</td>\n",
       "      <td>21.0</td>\n",
       "      <td>184.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>1992 Summer</td>\n",
       "      <td>1992</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>Boxing</td>\n",
       "      <td>Boxing Men's Light-Heavyweight</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>6849</td>\n",
       "      <td>Bai Faquan</td>\n",
       "      <td>M</td>\n",
       "      <td>26.0</td>\n",
       "      <td>173.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2012 Summer</td>\n",
       "      <td>2012</td>\n",
       "      <td>Summer</td>\n",
       "      <td>London</td>\n",
       "      <td>Triathlon</td>\n",
       "      <td>Triathlon Men's Olympic Distance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>6849</td>\n",
       "      <td>Bai Faquan</td>\n",
       "      <td>M</td>\n",
       "      <td>30.0</td>\n",
       "      <td>173.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2016 Summer</td>\n",
       "      <td>2016</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>Triathlon</td>\n",
       "      <td>Triathlon Men's Olympic Distance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>6851</td>\n",
       "      <td>Bai Jie</td>\n",
       "      <td>F</td>\n",
       "      <td>28.0</td>\n",
       "      <td>163.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2000 Summer</td>\n",
       "      <td>2000</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Sydney</td>\n",
       "      <td>Football</td>\n",
       "      <td>Football Women's Football</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>6853</td>\n",
       "      <td>Bai Lili</td>\n",
       "      <td>F</td>\n",
       "      <td>25.0</td>\n",
       "      <td>168.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2004 Summer</td>\n",
       "      <td>2004</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Athina</td>\n",
       "      <td>Football</td>\n",
       "      <td>Football Women's Football</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>6854</td>\n",
       "      <td>Bai Mei</td>\n",
       "      <td>F</td>\n",
       "      <td>17.0</td>\n",
       "      <td>166.0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>1992 Summer</td>\n",
       "      <td>1992</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>Rhythmic Gymnastics</td>\n",
       "      <td>Rhythmic Gymnastics Women's Individual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>6855</td>\n",
       "      <td>Bai Qiuming</td>\n",
       "      <td>M</td>\n",
       "      <td>19.0</td>\n",
       "      <td>173.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2014 Winter</td>\n",
       "      <td>2014</td>\n",
       "      <td>Winter</td>\n",
       "      <td>Sochi</td>\n",
       "      <td>Speed Skating</td>\n",
       "      <td>Speed Skating Men's 500 metres</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>6857</td>\n",
       "      <td>Bai Xue</td>\n",
       "      <td>F</td>\n",
       "      <td>19.0</td>\n",
       "      <td>165.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2008 Summer</td>\n",
       "      <td>2008</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Beijing</td>\n",
       "      <td>Athletics</td>\n",
       "      <td>Athletics Women's 10,000 metres</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>7595</td>\n",
       "      <td>Bao Chunlai</td>\n",
       "      <td>M</td>\n",
       "      <td>21.0</td>\n",
       "      <td>190.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2004 Summer</td>\n",
       "      <td>2004</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Athina</td>\n",
       "      <td>Badminton</td>\n",
       "      <td>Badminton Men's Singles</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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",
       "      <td>...</td>\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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>17295</td>\n",
       "      <td>Cai Yanshu</td>\n",
       "      <td>M</td>\n",
       "      <td>24.0</td>\n",
       "      <td>169.0</td>\n",
       "      <td>79.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>1988 Summer</td>\n",
       "      <td>1988</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Seoul</td>\n",
       "      <td>Weightlifting</td>\n",
       "      <td>Weightlifting Men's Middleweight</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>17295</td>\n",
       "      <td>Cai Yanshu</td>\n",
       "      <td>M</td>\n",
       "      <td>28.0</td>\n",
       "      <td>169.0</td>\n",
       "      <td>79.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>1992 Summer</td>\n",
       "      <td>1992</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>Weightlifting</td>\n",
       "      <td>Weightlifting Men's Light-Heavyweight</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>17296</td>\n",
       "      <td>Cai Yeqing</td>\n",
       "      <td>F</td>\n",
       "      <td>29.0</td>\n",
       "      <td>165.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2000 Summer</td>\n",
       "      <td>2000</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Sydney</td>\n",
       "      <td>Shooting</td>\n",
       "      <td>Shooting Women's Sporting Pistol, 25 metres</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>17297</td>\n",
       "      <td>Cai Yingquan</td>\n",
       "      <td>M</td>\n",
       "      <td>21.0</td>\n",
       "      <td>180.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>1988 Summer</td>\n",
       "      <td>1988</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Seoul</td>\n",
       "      <td>Cycling</td>\n",
       "      <td>Cycling Men's Road Race, Individual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>17298</td>\n",
       "      <td>Cai Yingying</td>\n",
       "      <td>F</td>\n",
       "      <td>17.0</td>\n",
       "      <td>162.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>1996 Summer</td>\n",
       "      <td>1996</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Atlanta</td>\n",
       "      <td>Rhythmic Gymnastics</td>\n",
       "      <td>Rhythmic Gymnastics Women's Group</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>17299</td>\n",
       "      <td>Cai Yun</td>\n",
       "      <td>M</td>\n",
       "      <td>24.0</td>\n",
       "      <td>181.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>China-2</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2004 Summer</td>\n",
       "      <td>2004</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Athina</td>\n",
       "      <td>Badminton</td>\n",
       "      <td>Badminton Men's Doubles</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>17299</td>\n",
       "      <td>Cai Yun</td>\n",
       "      <td>M</td>\n",
       "      <td>28.0</td>\n",
       "      <td>181.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>China-1</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2008 Summer</td>\n",
       "      <td>2008</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Beijing</td>\n",
       "      <td>Badminton</td>\n",
       "      <td>Badminton Men's Doubles</td>\n",
       "      <td>Silver</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>17299</td>\n",
       "      <td>Cai Yun</td>\n",
       "      <td>M</td>\n",
       "      <td>32.0</td>\n",
       "      <td>181.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>China-1</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2012 Summer</td>\n",
       "      <td>2012</td>\n",
       "      <td>Summer</td>\n",
       "      <td>London</td>\n",
       "      <td>Badminton</td>\n",
       "      <td>Badminton Men's Doubles</td>\n",
       "      <td>Gold</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>17300</td>\n",
       "      <td>Cai Zelin</td>\n",
       "      <td>M</td>\n",
       "      <td>21.0</td>\n",
       "      <td>175.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2012 Summer</td>\n",
       "      <td>2012</td>\n",
       "      <td>Summer</td>\n",
       "      <td>London</td>\n",
       "      <td>Athletics</td>\n",
       "      <td>Athletics Men's 20 kilometres Walk</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>17300</td>\n",
       "      <td>Cai Zelin</td>\n",
       "      <td>M</td>\n",
       "      <td>25.0</td>\n",
       "      <td>175.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2016 Summer</td>\n",
       "      <td>2016</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>Athletics</td>\n",
       "      <td>Athletics Men's 20 kilometres Walk</td>\n",
       "      <td>Silver</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>17992</td>\n",
       "      <td>Cao Guicheng</td>\n",
       "      <td>M</td>\n",
       "      <td>25.0</td>\n",
       "      <td>160.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>1936 Summer</td>\n",
       "      <td>1936</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Berlin</td>\n",
       "      <td>Football</td>\n",
       "      <td>Football Men's Football</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>17993</td>\n",
       "      <td>Cao Guifeng</td>\n",
       "      <td>F</td>\n",
       "      <td>19.0</td>\n",
       "      <td>160.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>1980 Winter</td>\n",
       "      <td>1980</td>\n",
       "      <td>Winter</td>\n",
       "      <td>Lake Placid</td>\n",
       "      <td>Speed Skating</td>\n",
       "      <td>Speed Skating Women's 500 metres</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>17993</td>\n",
       "      <td>Cao Guifeng</td>\n",
       "      <td>F</td>\n",
       "      <td>19.0</td>\n",
       "      <td>160.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>1980 Winter</td>\n",
       "      <td>1980</td>\n",
       "      <td>Winter</td>\n",
       "      <td>Lake Placid</td>\n",
       "      <td>Speed Skating</td>\n",
       "      <td>Speed Skating Women's 1,000 metres</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>17993</td>\n",
       "      <td>Cao Guifeng</td>\n",
       "      <td>F</td>\n",
       "      <td>23.0</td>\n",
       "      <td>160.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>1984 Winter</td>\n",
       "      <td>1984</td>\n",
       "      <td>Winter</td>\n",
       "      <td>Sarajevo</td>\n",
       "      <td>Speed Skating</td>\n",
       "      <td>Speed Skating Women's 500 metres</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>17993</td>\n",
       "      <td>Cao Guifeng</td>\n",
       "      <td>F</td>\n",
       "      <td>23.0</td>\n",
       "      <td>160.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>1984 Winter</td>\n",
       "      <td>1984</td>\n",
       "      <td>Winter</td>\n",
       "      <td>Sarajevo</td>\n",
       "      <td>Speed Skating</td>\n",
       "      <td>Speed Skating Women's 1,000 metres</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>17994</td>\n",
       "      <td>Cao Hui</td>\n",
       "      <td>F</td>\n",
       "      <td>24.0</td>\n",
       "      <td>175.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2016 Summer</td>\n",
       "      <td>2016</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>Archery</td>\n",
       "      <td>Archery Women's Individual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>17994</td>\n",
       "      <td>Cao Hui</td>\n",
       "      <td>F</td>\n",
       "      <td>24.0</td>\n",
       "      <td>175.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2016 Summer</td>\n",
       "      <td>2016</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>Archery</td>\n",
       "      <td>Archery Women's Team</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>17995</td>\n",
       "      <td>Cao Lei</td>\n",
       "      <td>F</td>\n",
       "      <td>24.0</td>\n",
       "      <td>168.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2008 Summer</td>\n",
       "      <td>2008</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Beijing</td>\n",
       "      <td>Weightlifting</td>\n",
       "      <td>Weightlifting Women's Heavyweight</td>\n",
       "      <td>Gold</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>17996</td>\n",
       "      <td>Cao Mianying</td>\n",
       "      <td>F</td>\n",
       "      <td>21.0</td>\n",
       "      <td>176.0</td>\n",
       "      <td>71.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>1988 Summer</td>\n",
       "      <td>1988</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Seoul</td>\n",
       "      <td>Rowing</td>\n",
       "      <td>Rowing Women's Double Sculls</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>17996</td>\n",
       "      <td>Cao Mianying</td>\n",
       "      <td>F</td>\n",
       "      <td>25.0</td>\n",
       "      <td>176.0</td>\n",
       "      <td>71.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>1992 Summer</td>\n",
       "      <td>1992</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>Rowing</td>\n",
       "      <td>Rowing Women's Coxless Fours</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>17996</td>\n",
       "      <td>Cao Mianying</td>\n",
       "      <td>F</td>\n",
       "      <td>25.0</td>\n",
       "      <td>176.0</td>\n",
       "      <td>71.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>1992 Summer</td>\n",
       "      <td>1992</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>Rowing</td>\n",
       "      <td>Rowing Women's Coxed Eights</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>17996</td>\n",
       "      <td>Cao Mianying</td>\n",
       "      <td>F</td>\n",
       "      <td>29.0</td>\n",
       "      <td>176.0</td>\n",
       "      <td>71.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>1996 Summer</td>\n",
       "      <td>1996</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Atlanta</td>\n",
       "      <td>Rowing</td>\n",
       "      <td>Rowing Women's Double Sculls</td>\n",
       "      <td>Silver</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>17996</td>\n",
       "      <td>Cao Mianying</td>\n",
       "      <td>F</td>\n",
       "      <td>29.0</td>\n",
       "      <td>176.0</td>\n",
       "      <td>71.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>1996 Summer</td>\n",
       "      <td>1996</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Atlanta</td>\n",
       "      <td>Rowing</td>\n",
       "      <td>Rowing Women's Quadruple Sculls</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>17998</td>\n",
       "      <td>Cao Ping</td>\n",
       "      <td>M</td>\n",
       "      <td>26.0</td>\n",
       "      <td>190.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>1984 Summer</td>\n",
       "      <td>1984</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Los Angeles</td>\n",
       "      <td>Volleyball</td>\n",
       "      <td>Volleyball Men's Volleyball</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>17999</td>\n",
       "      <td>Cao Qi</td>\n",
       "      <td>F</td>\n",
       "      <td>26.0</td>\n",
       "      <td>182.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2000 Summer</td>\n",
       "      <td>2000</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Sydney</td>\n",
       "      <td>Athletics</td>\n",
       "      <td>Athletics Women's Discus Throw</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>18000</td>\n",
       "      <td>Cao Shuo</td>\n",
       "      <td>M</td>\n",
       "      <td>20.0</td>\n",
       "      <td>180.0</td>\n",
       "      <td>77.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2012 Summer</td>\n",
       "      <td>2012</td>\n",
       "      <td>Summer</td>\n",
       "      <td>London</td>\n",
       "      <td>Athletics</td>\n",
       "      <td>Athletics Men's Triple Jump</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>18000</td>\n",
       "      <td>Cao Shuo</td>\n",
       "      <td>M</td>\n",
       "      <td>24.0</td>\n",
       "      <td>180.0</td>\n",
       "      <td>77.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2016 Summer</td>\n",
       "      <td>2016</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>Athletics</td>\n",
       "      <td>Athletics Men's Triple Jump</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>18001</td>\n",
       "      <td>Cao Xianming</td>\n",
       "      <td>M</td>\n",
       "      <td>25.0</td>\n",
       "      <td>170.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2002 Winter</td>\n",
       "      <td>2002</td>\n",
       "      <td>Winter</td>\n",
       "      <td>Salt Lake City</td>\n",
       "      <td>Figure Skating</td>\n",
       "      <td>Figure Skating Mixed Ice Dancing</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>18002</td>\n",
       "      <td>Cao Xiaobo</td>\n",
       "      <td>M</td>\n",
       "      <td>29.0</td>\n",
       "      <td>169.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>1996 Summer</td>\n",
       "      <td>1996</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Atlanta</td>\n",
       "      <td>Sailing</td>\n",
       "      <td>Sailing Mixed One Person Dinghy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>18003</td>\n",
       "      <td>Cao Yifei</td>\n",
       "      <td>M</td>\n",
       "      <td>20.0</td>\n",
       "      <td>175.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2008 Summer</td>\n",
       "      <td>2008</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Beijing</td>\n",
       "      <td>Shooting</td>\n",
       "      <td>Shooting Men's Air Rifle, 10 metres</td>\n",
       "      <td>NaN</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>100 rows × 19 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       ID            Name Sex   Age  Height  Weight     Team  NOC  \\\n",
       "0       1       A Dijiang   M  24.0   180.0    80.0    China  CHN   \n",
       "1       2        A Lamusi   M  23.0   170.0    60.0    China  CHN   \n",
       "2     602   Abudoureheman   M  22.0   182.0    75.0    China  CHN   \n",
       "3    1463       Ai Linuer   M  25.0   160.0    62.0    China  CHN   \n",
       "4    1464       Ai Yanhan   F  14.0   168.0    54.0    China  CHN   \n",
       "5    1464       Ai Yanhan   F  14.0   168.0    54.0    China  CHN   \n",
       "6    3605     An Weijiang   M  22.0   178.0    72.0    China  CHN   \n",
       "7    3605     An Weijiang   M  22.0   178.0    72.0    China  CHN   \n",
       "8    3610       An Yulong   M  19.0   173.0    70.0    China  CHN   \n",
       "9    3610       An Yulong   M  19.0   173.0    70.0    China  CHN   \n",
       "10   3610       An Yulong   M  19.0   173.0    70.0    China  CHN   \n",
       "11   3610       An Yulong   M  23.0   173.0    70.0    China  CHN   \n",
       "12   3611     An Zhongxin   F  23.0   170.0    65.0    China  CHN   \n",
       "13   3611     An Zhongxin   F  27.0   170.0    65.0    China  CHN   \n",
       "14   4639    Ao Changrong   M  25.0   173.0    71.0    China  CHN   \n",
       "15   4641        Ao Tegen   M  21.0   181.0    90.0    China  CHN   \n",
       "16   6376        Ba Dexin   M  23.0   185.0    80.0    China  CHN   \n",
       "17   6381          Ba Yan   F  21.0   183.0    78.0    China  CHN   \n",
       "18   6382     Ba Yanchuan   M  24.0   187.0   100.0    China  CHN   \n",
       "19   6383     Ba Yongshan   M  22.0   180.0    70.0    China  CHN   \n",
       "20   6847        Bai Anqi   F  19.0   164.0    59.0    China  CHN   \n",
       "21   6848  Bai Chongguang   M  21.0   184.0    83.0    China  CHN   \n",
       "22   6849      Bai Faquan   M  26.0   173.0    66.0    China  CHN   \n",
       "23   6849      Bai Faquan   M  30.0   173.0    66.0    China  CHN   \n",
       "24   6851         Bai Jie   F  28.0   163.0    53.0    China  CHN   \n",
       "25   6853        Bai Lili   F  25.0   168.0    57.0    China  CHN   \n",
       "26   6854         Bai Mei   F  17.0   166.0    46.0    China  CHN   \n",
       "27   6855     Bai Qiuming   M  19.0   173.0    70.0    China  CHN   \n",
       "28   6857         Bai Xue   F  19.0   165.0    53.0    China  CHN   \n",
       "29   7595     Bao Chunlai   M  21.0   190.0    80.0    China  CHN   \n",
       "..    ...             ...  ..   ...     ...     ...      ...  ...   \n",
       "70  17295      Cai Yanshu   M  24.0   169.0    79.0    China  CHN   \n",
       "71  17295      Cai Yanshu   M  28.0   169.0    79.0    China  CHN   \n",
       "72  17296      Cai Yeqing   F  29.0   165.0    50.0    China  CHN   \n",
       "73  17297    Cai Yingquan   M  21.0   180.0    72.0    China  CHN   \n",
       "74  17298    Cai Yingying   F  17.0   162.0    42.0    China  CHN   \n",
       "75  17299         Cai Yun   M  24.0   181.0    68.0  China-2  CHN   \n",
       "76  17299         Cai Yun   M  28.0   181.0    68.0  China-1  CHN   \n",
       "77  17299         Cai Yun   M  32.0   181.0    68.0  China-1  CHN   \n",
       "78  17300       Cai Zelin   M  21.0   175.0    55.0    China  CHN   \n",
       "79  17300       Cai Zelin   M  25.0   175.0    55.0    China  CHN   \n",
       "80  17992    Cao Guicheng   M  25.0   160.0    61.0    China  CHN   \n",
       "81  17993     Cao Guifeng   F  19.0   160.0    57.0    China  CHN   \n",
       "82  17993     Cao Guifeng   F  19.0   160.0    57.0    China  CHN   \n",
       "83  17993     Cao Guifeng   F  23.0   160.0    57.0    China  CHN   \n",
       "84  17993     Cao Guifeng   F  23.0   160.0    57.0    China  CHN   \n",
       "85  17994         Cao Hui   F  24.0   175.0    70.0    China  CHN   \n",
       "86  17994         Cao Hui   F  24.0   175.0    70.0    China  CHN   \n",
       "87  17995         Cao Lei   F  24.0   168.0    75.0    China  CHN   \n",
       "88  17996    Cao Mianying   F  21.0   176.0    71.0    China  CHN   \n",
       "89  17996    Cao Mianying   F  25.0   176.0    71.0    China  CHN   \n",
       "90  17996    Cao Mianying   F  25.0   176.0    71.0    China  CHN   \n",
       "91  17996    Cao Mianying   F  29.0   176.0    71.0    China  CHN   \n",
       "92  17996    Cao Mianying   F  29.0   176.0    71.0    China  CHN   \n",
       "93  17998        Cao Ping   M  26.0   190.0    75.0    China  CHN   \n",
       "94  17999          Cao Qi   F  26.0   182.0    83.0    China  CHN   \n",
       "95  18000        Cao Shuo   M  20.0   180.0    77.0    China  CHN   \n",
       "96  18000        Cao Shuo   M  24.0   180.0    77.0    China  CHN   \n",
       "97  18001    Cao Xianming   M  25.0   170.0     NaN    China  CHN   \n",
       "98  18002      Cao Xiaobo   M  29.0   169.0    65.0    China  CHN   \n",
       "99  18003       Cao Yifei   M  20.0   175.0    75.0    China  CHN   \n",
       "\n",
       "          Games  Year  Season            City                      Sport  \\\n",
       "0   1992 Summer  1992  Summer       Barcelona                 Basketball   \n",
       "1   2012 Summer  2012  Summer          London                       Judo   \n",
       "2   2000 Summer  2000  Summer          Sydney                     Boxing   \n",
       "3   2004 Summer  2004  Summer          Athina                  Wrestling   \n",
       "4   2016 Summer  2016  Summer  Rio de Janeiro                   Swimming   \n",
       "5   2016 Summer  2016  Summer  Rio de Janeiro                   Swimming   \n",
       "6   2006 Winter  2006  Winter          Torino              Speed Skating   \n",
       "7   2006 Winter  2006  Winter          Torino              Speed Skating   \n",
       "8   1998 Winter  1998  Winter          Nagano  Short Track Speed Skating   \n",
       "9   1998 Winter  1998  Winter          Nagano  Short Track Speed Skating   \n",
       "10  1998 Winter  1998  Winter          Nagano  Short Track Speed Skating   \n",
       "11  2002 Winter  2002  Winter  Salt Lake City  Short Track Speed Skating   \n",
       "12  1996 Summer  1996  Summer         Atlanta                   Softball   \n",
       "13  2000 Summer  2000  Summer          Sydney                   Softball   \n",
       "14  2008 Summer  2008  Summer         Beijing                     Hockey   \n",
       "15  1996 Summer  1996  Summer         Atlanta                       Judo   \n",
       "16  2014 Winter  2014  Winter           Sochi                    Curling   \n",
       "17  1984 Summer  1984  Summer     Los Angeles                 Basketball   \n",
       "18  1996 Summer  1996  Summer         Atlanta                  Wrestling   \n",
       "19  1984 Summer  1984  Summer     Los Angeles                    Archery   \n",
       "20  2012 Summer  2012  Summer          London                   Swimming   \n",
       "21  1992 Summer  1992  Summer       Barcelona                     Boxing   \n",
       "22  2012 Summer  2012  Summer          London                  Triathlon   \n",
       "23  2016 Summer  2016  Summer  Rio de Janeiro                  Triathlon   \n",
       "24  2000 Summer  2000  Summer          Sydney                   Football   \n",
       "25  2004 Summer  2004  Summer          Athina                   Football   \n",
       "26  1992 Summer  1992  Summer       Barcelona        Rhythmic Gymnastics   \n",
       "27  2014 Winter  2014  Winter           Sochi              Speed Skating   \n",
       "28  2008 Summer  2008  Summer         Beijing                  Athletics   \n",
       "29  2004 Summer  2004  Summer          Athina                  Badminton   \n",
       "..          ...   ...     ...             ...                        ...   \n",
       "70  1988 Summer  1988  Summer           Seoul              Weightlifting   \n",
       "71  1992 Summer  1992  Summer       Barcelona              Weightlifting   \n",
       "72  2000 Summer  2000  Summer          Sydney                   Shooting   \n",
       "73  1988 Summer  1988  Summer           Seoul                    Cycling   \n",
       "74  1996 Summer  1996  Summer         Atlanta        Rhythmic Gymnastics   \n",
       "75  2004 Summer  2004  Summer          Athina                  Badminton   \n",
       "76  2008 Summer  2008  Summer         Beijing                  Badminton   \n",
       "77  2012 Summer  2012  Summer          London                  Badminton   \n",
       "78  2012 Summer  2012  Summer          London                  Athletics   \n",
       "79  2016 Summer  2016  Summer  Rio de Janeiro                  Athletics   \n",
       "80  1936 Summer  1936  Summer          Berlin                   Football   \n",
       "81  1980 Winter  1980  Winter     Lake Placid              Speed Skating   \n",
       "82  1980 Winter  1980  Winter     Lake Placid              Speed Skating   \n",
       "83  1984 Winter  1984  Winter        Sarajevo              Speed Skating   \n",
       "84  1984 Winter  1984  Winter        Sarajevo              Speed Skating   \n",
       "85  2016 Summer  2016  Summer  Rio de Janeiro                    Archery   \n",
       "86  2016 Summer  2016  Summer  Rio de Janeiro                    Archery   \n",
       "87  2008 Summer  2008  Summer         Beijing              Weightlifting   \n",
       "88  1988 Summer  1988  Summer           Seoul                     Rowing   \n",
       "89  1992 Summer  1992  Summer       Barcelona                     Rowing   \n",
       "90  1992 Summer  1992  Summer       Barcelona                     Rowing   \n",
       "91  1996 Summer  1996  Summer         Atlanta                     Rowing   \n",
       "92  1996 Summer  1996  Summer         Atlanta                     Rowing   \n",
       "93  1984 Summer  1984  Summer     Los Angeles                 Volleyball   \n",
       "94  2000 Summer  2000  Summer          Sydney                  Athletics   \n",
       "95  2012 Summer  2012  Summer          London                  Athletics   \n",
       "96  2016 Summer  2016  Summer  Rio de Janeiro                  Athletics   \n",
       "97  2002 Winter  2002  Winter  Salt Lake City             Figure Skating   \n",
       "98  1996 Summer  1996  Summer         Atlanta                    Sailing   \n",
       "99  2008 Summer  2008  Summer         Beijing                   Shooting   \n",
       "\n",
       "                                                Event   Medal region notes  \\\n",
       "0                         Basketball Men's Basketball     NaN  China   NaN   \n",
       "1                        Judo Men's Extra-Lightweight     NaN  China   NaN   \n",
       "2                           Boxing Men's Middleweight     NaN  China   NaN   \n",
       "3            Wrestling Men's Lightweight, Greco-Roman     NaN  China   NaN   \n",
       "4               Swimming Women's 200 metres Freestyle     NaN  China   NaN   \n",
       "5     Swimming Women's 4 x 200 metres Freestyle Relay     NaN  China   NaN   \n",
       "6                      Speed Skating Men's 500 metres     NaN  China   NaN   \n",
       "7                    Speed Skating Men's 1,000 metres     NaN  China   NaN   \n",
       "8          Short Track Speed Skating Men's 500 metres  Silver  China   NaN   \n",
       "9        Short Track Speed Skating Men's 1,000 metres     NaN  China   NaN   \n",
       "10  Short Track Speed Skating Men's 5,000 metres R...  Bronze  China   NaN   \n",
       "11  Short Track Speed Skating Men's 5,000 metres R...  Bronze  China   NaN   \n",
       "12                          Softball Women's Softball  Silver  China   NaN   \n",
       "13                          Softball Women's Softball     NaN  China   NaN   \n",
       "14                                Hockey Men's Hockey     NaN  China   NaN   \n",
       "15                            Judo Men's Middleweight     NaN  China   NaN   \n",
       "16                              Curling Men's Curling     NaN  China   NaN   \n",
       "17                      Basketball Women's Basketball  Bronze  China   NaN   \n",
       "18           Wrestling Men's Heavyweight, Greco-Roman     NaN  China   NaN   \n",
       "19                           Archery Men's Individual     NaN  China   NaN   \n",
       "20             Swimming Women's 200 metres Backstroke     NaN  China   NaN   \n",
       "21                     Boxing Men's Light-Heavyweight     NaN  China   NaN   \n",
       "22                   Triathlon Men's Olympic Distance     NaN  China   NaN   \n",
       "23                   Triathlon Men's Olympic Distance     NaN  China   NaN   \n",
       "24                          Football Women's Football     NaN  China   NaN   \n",
       "25                          Football Women's Football     NaN  China   NaN   \n",
       "26             Rhythmic Gymnastics Women's Individual     NaN  China   NaN   \n",
       "27                     Speed Skating Men's 500 metres     NaN  China   NaN   \n",
       "28                    Athletics Women's 10,000 metres     NaN  China   NaN   \n",
       "29                            Badminton Men's Singles     NaN  China   NaN   \n",
       "..                                                ...     ...    ...   ...   \n",
       "70                   Weightlifting Men's Middleweight     NaN  China   NaN   \n",
       "71              Weightlifting Men's Light-Heavyweight     NaN  China   NaN   \n",
       "72        Shooting Women's Sporting Pistol, 25 metres     NaN  China   NaN   \n",
       "73                Cycling Men's Road Race, Individual     NaN  China   NaN   \n",
       "74                  Rhythmic Gymnastics Women's Group     NaN  China   NaN   \n",
       "75                            Badminton Men's Doubles     NaN  China   NaN   \n",
       "76                            Badminton Men's Doubles  Silver  China   NaN   \n",
       "77                            Badminton Men's Doubles    Gold  China   NaN   \n",
       "78                 Athletics Men's 20 kilometres Walk     NaN  China   NaN   \n",
       "79                 Athletics Men's 20 kilometres Walk  Silver  China   NaN   \n",
       "80                            Football Men's Football     NaN  China   NaN   \n",
       "81                   Speed Skating Women's 500 metres     NaN  China   NaN   \n",
       "82                 Speed Skating Women's 1,000 metres     NaN  China   NaN   \n",
       "83                   Speed Skating Women's 500 metres     NaN  China   NaN   \n",
       "84                 Speed Skating Women's 1,000 metres     NaN  China   NaN   \n",
       "85                         Archery Women's Individual     NaN  China   NaN   \n",
       "86                               Archery Women's Team     NaN  China   NaN   \n",
       "87                  Weightlifting Women's Heavyweight    Gold  China   NaN   \n",
       "88                       Rowing Women's Double Sculls     NaN  China   NaN   \n",
       "89                       Rowing Women's Coxless Fours     NaN  China   NaN   \n",
       "90                        Rowing Women's Coxed Eights     NaN  China   NaN   \n",
       "91                       Rowing Women's Double Sculls  Silver  China   NaN   \n",
       "92                    Rowing Women's Quadruple Sculls     NaN  China   NaN   \n",
       "93                        Volleyball Men's Volleyball     NaN  China   NaN   \n",
       "94                     Athletics Women's Discus Throw     NaN  China   NaN   \n",
       "95                        Athletics Men's Triple Jump     NaN  China   NaN   \n",
       "96                        Athletics Men's Triple Jump     NaN  China   NaN   \n",
       "97                   Figure Skating Mixed Ice Dancing     NaN  China   NaN   \n",
       "98                    Sailing Mixed One Person Dinghy     NaN  China   NaN   \n",
       "99                Shooting Men's Air Rifle, 10 metres     NaN  China   NaN   \n",
       "\n",
       "    Lat  Lng  \n",
       "0   NaN  NaN  \n",
       "1   NaN  NaN  \n",
       "2   NaN  NaN  \n",
       "3   NaN  NaN  \n",
       "4   NaN  NaN  \n",
       "5   NaN  NaN  \n",
       "6   NaN  NaN  \n",
       "7   NaN  NaN  \n",
       "8   NaN  NaN  \n",
       "9   NaN  NaN  \n",
       "10  NaN  NaN  \n",
       "11  NaN  NaN  \n",
       "12  NaN  NaN  \n",
       "13  NaN  NaN  \n",
       "14  NaN  NaN  \n",
       "15  NaN  NaN  \n",
       "16  NaN  NaN  \n",
       "17  NaN  NaN  \n",
       "18  NaN  NaN  \n",
       "19  NaN  NaN  \n",
       "20  NaN  NaN  \n",
       "21  NaN  NaN  \n",
       "22  NaN  NaN  \n",
       "23  NaN  NaN  \n",
       "24  NaN  NaN  \n",
       "25  NaN  NaN  \n",
       "26  NaN  NaN  \n",
       "27  NaN  NaN  \n",
       "28  NaN  NaN  \n",
       "29  NaN  NaN  \n",
       "..  ...  ...  \n",
       "70  NaN  NaN  \n",
       "71  NaN  NaN  \n",
       "72  NaN  NaN  \n",
       "73  NaN  NaN  \n",
       "74  NaN  NaN  \n",
       "75  NaN  NaN  \n",
       "76  NaN  NaN  \n",
       "77  NaN  NaN  \n",
       "78  NaN  NaN  \n",
       "79  NaN  NaN  \n",
       "80  NaN  NaN  \n",
       "81  NaN  NaN  \n",
       "82  NaN  NaN  \n",
       "83  NaN  NaN  \n",
       "84  NaN  NaN  \n",
       "85  NaN  NaN  \n",
       "86  NaN  NaN  \n",
       "87  NaN  NaN  \n",
       "88  NaN  NaN  \n",
       "89  NaN  NaN  \n",
       "90  NaN  NaN  \n",
       "91  NaN  NaN  \n",
       "92  NaN  NaN  \n",
       "93  NaN  NaN  \n",
       "94  NaN  NaN  \n",
       "95  NaN  NaN  \n",
       "96  NaN  NaN  \n",
       "97  NaN  NaN  \n",
       "98  NaN  NaN  \n",
       "99  NaN  NaN  \n",
       "\n",
       "[100 rows x 19 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "athlete_noc_pd.head(100)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "athlete_noc_pd = athlete_noc_pd.rename(columns={'region': 'Country'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "athlete_noc_pd[['Medal']] = athlete_noc_pd[['Medal']].fillna(value=0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_latlng = pd.read_csv(\"../Project2/data/Countries_LatLng.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Country</th>\n",
       "      <th>Latitude (generated)</th>\n",
       "      <th>Longitude (generated)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>-19.098</td>\n",
       "      <td>30.047</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Zambia</td>\n",
       "      <td>-15.130</td>\n",
       "      <td>25.268</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Yemen</td>\n",
       "      <td>15.569</td>\n",
       "      <td>47.793</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Virgin Islands, US</td>\n",
       "      <td>17.740</td>\n",
       "      <td>-64.800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Virgin Islands, British</td>\n",
       "      <td>18.439</td>\n",
       "      <td>-64.586</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   Country  Latitude (generated)  Longitude (generated)\n",
       "0                 Zimbabwe               -19.098                 30.047\n",
       "1                   Zambia               -15.130                 25.268\n",
       "2                    Yemen                15.569                 47.793\n",
       "3       Virgin Islands, US                17.740                -64.800\n",
       "4  Virgin Islands, British                18.439                -64.586"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_latlng.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "athlete_noc_latlng_pd = pd.merge(athlete_noc_pd, df_latlng, on='Country', how='outer')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ID</th>\n",
       "      <th>Name</th>\n",
       "      <th>Sex</th>\n",
       "      <th>Age</th>\n",
       "      <th>Height</th>\n",
       "      <th>Weight</th>\n",
       "      <th>Team</th>\n",
       "      <th>NOC</th>\n",
       "      <th>Games</th>\n",
       "      <th>Year</th>\n",
       "      <th>...</th>\n",
       "      <th>City</th>\n",
       "      <th>Sport</th>\n",
       "      <th>Event</th>\n",
       "      <th>Medal</th>\n",
       "      <th>Country</th>\n",
       "      <th>notes</th>\n",
       "      <th>Lat</th>\n",
       "      <th>Lng</th>\n",
       "      <th>Latitude (generated)</th>\n",
       "      <th>Longitude (generated)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>A Dijiang</td>\n",
       "      <td>M</td>\n",
       "      <td>24.0</td>\n",
       "      <td>180.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>1992 Summer</td>\n",
       "      <td>1992</td>\n",
       "      <td>...</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>Basketball</td>\n",
       "      <td>Basketball Men's Basketball</td>\n",
       "      <td>0</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.1753</td>\n",
       "      <td>99.3877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>A Lamusi</td>\n",
       "      <td>M</td>\n",
       "      <td>23.0</td>\n",
       "      <td>170.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2012 Summer</td>\n",
       "      <td>2012</td>\n",
       "      <td>...</td>\n",
       "      <td>London</td>\n",
       "      <td>Judo</td>\n",
       "      <td>Judo Men's Extra-Lightweight</td>\n",
       "      <td>0</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.1753</td>\n",
       "      <td>99.3877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>602</td>\n",
       "      <td>Abudoureheman</td>\n",
       "      <td>M</td>\n",
       "      <td>22.0</td>\n",
       "      <td>182.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2000 Summer</td>\n",
       "      <td>2000</td>\n",
       "      <td>...</td>\n",
       "      <td>Sydney</td>\n",
       "      <td>Boxing</td>\n",
       "      <td>Boxing Men's Middleweight</td>\n",
       "      <td>0</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.1753</td>\n",
       "      <td>99.3877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1463</td>\n",
       "      <td>Ai Linuer</td>\n",
       "      <td>M</td>\n",
       "      <td>25.0</td>\n",
       "      <td>160.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2004 Summer</td>\n",
       "      <td>2004</td>\n",
       "      <td>...</td>\n",
       "      <td>Athina</td>\n",
       "      <td>Wrestling</td>\n",
       "      <td>Wrestling Men's Lightweight, Greco-Roman</td>\n",
       "      <td>0</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.1753</td>\n",
       "      <td>99.3877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1464</td>\n",
       "      <td>Ai Yanhan</td>\n",
       "      <td>F</td>\n",
       "      <td>14.0</td>\n",
       "      <td>168.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2016 Summer</td>\n",
       "      <td>2016</td>\n",
       "      <td>...</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>Swimming</td>\n",
       "      <td>Swimming Women's 200 metres Freestyle</td>\n",
       "      <td>0</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.1753</td>\n",
       "      <td>99.3877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1464</td>\n",
       "      <td>Ai Yanhan</td>\n",
       "      <td>F</td>\n",
       "      <td>14.0</td>\n",
       "      <td>168.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2016 Summer</td>\n",
       "      <td>2016</td>\n",
       "      <td>...</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>Swimming</td>\n",
       "      <td>Swimming Women's 4 x 200 metres Freestyle Relay</td>\n",
       "      <td>0</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.1753</td>\n",
       "      <td>99.3877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>3605</td>\n",
       "      <td>An Weijiang</td>\n",
       "      <td>M</td>\n",
       "      <td>22.0</td>\n",
       "      <td>178.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2006 Winter</td>\n",
       "      <td>2006</td>\n",
       "      <td>...</td>\n",
       "      <td>Torino</td>\n",
       "      <td>Speed Skating</td>\n",
       "      <td>Speed Skating Men's 500 metres</td>\n",
       "      <td>0</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.1753</td>\n",
       "      <td>99.3877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>3605</td>\n",
       "      <td>An Weijiang</td>\n",
       "      <td>M</td>\n",
       "      <td>22.0</td>\n",
       "      <td>178.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2006 Winter</td>\n",
       "      <td>2006</td>\n",
       "      <td>...</td>\n",
       "      <td>Torino</td>\n",
       "      <td>Speed Skating</td>\n",
       "      <td>Speed Skating Men's 1,000 metres</td>\n",
       "      <td>0</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.1753</td>\n",
       "      <td>99.3877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>3610</td>\n",
       "      <td>An Yulong</td>\n",
       "      <td>M</td>\n",
       "      <td>19.0</td>\n",
       "      <td>173.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>1998 Winter</td>\n",
       "      <td>1998</td>\n",
       "      <td>...</td>\n",
       "      <td>Nagano</td>\n",
       "      <td>Short Track Speed Skating</td>\n",
       "      <td>Short Track Speed Skating Men's 500 metres</td>\n",
       "      <td>Silver</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.1753</td>\n",
       "      <td>99.3877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>3610</td>\n",
       "      <td>An Yulong</td>\n",
       "      <td>M</td>\n",
       "      <td>19.0</td>\n",
       "      <td>173.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>1998 Winter</td>\n",
       "      <td>1998</td>\n",
       "      <td>...</td>\n",
       "      <td>Nagano</td>\n",
       "      <td>Short Track Speed Skating</td>\n",
       "      <td>Short Track Speed Skating Men's 1,000 metres</td>\n",
       "      <td>0</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.1753</td>\n",
       "      <td>99.3877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>3610</td>\n",
       "      <td>An Yulong</td>\n",
       "      <td>M</td>\n",
       "      <td>19.0</td>\n",
       "      <td>173.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>1998 Winter</td>\n",
       "      <td>1998</td>\n",
       "      <td>...</td>\n",
       "      <td>Nagano</td>\n",
       "      <td>Short Track Speed Skating</td>\n",
       "      <td>Short Track Speed Skating Men's 5,000 metres R...</td>\n",
       "      <td>Bronze</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.1753</td>\n",
       "      <td>99.3877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>3610</td>\n",
       "      <td>An Yulong</td>\n",
       "      <td>M</td>\n",
       "      <td>23.0</td>\n",
       "      <td>173.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2002 Winter</td>\n",
       "      <td>2002</td>\n",
       "      <td>...</td>\n",
       "      <td>Salt Lake City</td>\n",
       "      <td>Short Track Speed Skating</td>\n",
       "      <td>Short Track Speed Skating Men's 5,000 metres R...</td>\n",
       "      <td>Bronze</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.1753</td>\n",
       "      <td>99.3877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>3611</td>\n",
       "      <td>An Zhongxin</td>\n",
       "      <td>F</td>\n",
       "      <td>23.0</td>\n",
       "      <td>170.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>1996 Summer</td>\n",
       "      <td>1996</td>\n",
       "      <td>...</td>\n",
       "      <td>Atlanta</td>\n",
       "      <td>Softball</td>\n",
       "      <td>Softball Women's Softball</td>\n",
       "      <td>Silver</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.1753</td>\n",
       "      <td>99.3877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>3611</td>\n",
       "      <td>An Zhongxin</td>\n",
       "      <td>F</td>\n",
       "      <td>27.0</td>\n",
       "      <td>170.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2000 Summer</td>\n",
       "      <td>2000</td>\n",
       "      <td>...</td>\n",
       "      <td>Sydney</td>\n",
       "      <td>Softball</td>\n",
       "      <td>Softball Women's Softball</td>\n",
       "      <td>0</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.1753</td>\n",
       "      <td>99.3877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>4639</td>\n",
       "      <td>Ao Changrong</td>\n",
       "      <td>M</td>\n",
       "      <td>25.0</td>\n",
       "      <td>173.0</td>\n",
       "      <td>71.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2008 Summer</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Beijing</td>\n",
       "      <td>Hockey</td>\n",
       "      <td>Hockey Men's Hockey</td>\n",
       "      <td>0</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.1753</td>\n",
       "      <td>99.3877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>4641</td>\n",
       "      <td>Ao Tegen</td>\n",
       "      <td>M</td>\n",
       "      <td>21.0</td>\n",
       "      <td>181.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>1996 Summer</td>\n",
       "      <td>1996</td>\n",
       "      <td>...</td>\n",
       "      <td>Atlanta</td>\n",
       "      <td>Judo</td>\n",
       "      <td>Judo Men's Middleweight</td>\n",
       "      <td>0</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.1753</td>\n",
       "      <td>99.3877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>6376</td>\n",
       "      <td>Ba Dexin</td>\n",
       "      <td>M</td>\n",
       "      <td>23.0</td>\n",
       "      <td>185.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2014 Winter</td>\n",
       "      <td>2014</td>\n",
       "      <td>...</td>\n",
       "      <td>Sochi</td>\n",
       "      <td>Curling</td>\n",
       "      <td>Curling Men's Curling</td>\n",
       "      <td>0</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.1753</td>\n",
       "      <td>99.3877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>6381</td>\n",
       "      <td>Ba Yan</td>\n",
       "      <td>F</td>\n",
       "      <td>21.0</td>\n",
       "      <td>183.0</td>\n",
       "      <td>78.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>1984 Summer</td>\n",
       "      <td>1984</td>\n",
       "      <td>...</td>\n",
       "      <td>Los Angeles</td>\n",
       "      <td>Basketball</td>\n",
       "      <td>Basketball Women's Basketball</td>\n",
       "      <td>Bronze</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.1753</td>\n",
       "      <td>99.3877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>6382</td>\n",
       "      <td>Ba Yanchuan</td>\n",
       "      <td>M</td>\n",
       "      <td>24.0</td>\n",
       "      <td>187.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>1996 Summer</td>\n",
       "      <td>1996</td>\n",
       "      <td>...</td>\n",
       "      <td>Atlanta</td>\n",
       "      <td>Wrestling</td>\n",
       "      <td>Wrestling Men's Heavyweight, Greco-Roman</td>\n",
       "      <td>0</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.1753</td>\n",
       "      <td>99.3877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>6383</td>\n",
       "      <td>Ba Yongshan</td>\n",
       "      <td>M</td>\n",
       "      <td>22.0</td>\n",
       "      <td>180.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>1984 Summer</td>\n",
       "      <td>1984</td>\n",
       "      <td>...</td>\n",
       "      <td>Los Angeles</td>\n",
       "      <td>Archery</td>\n",
       "      <td>Archery Men's Individual</td>\n",
       "      <td>0</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.1753</td>\n",
       "      <td>99.3877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>6847</td>\n",
       "      <td>Bai Anqi</td>\n",
       "      <td>F</td>\n",
       "      <td>19.0</td>\n",
       "      <td>164.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2012 Summer</td>\n",
       "      <td>2012</td>\n",
       "      <td>...</td>\n",
       "      <td>London</td>\n",
       "      <td>Swimming</td>\n",
       "      <td>Swimming Women's 200 metres Backstroke</td>\n",
       "      <td>0</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.1753</td>\n",
       "      <td>99.3877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>6848</td>\n",
       "      <td>Bai Chongguang</td>\n",
       "      <td>M</td>\n",
       "      <td>21.0</td>\n",
       "      <td>184.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>1992 Summer</td>\n",
       "      <td>1992</td>\n",
       "      <td>...</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>Boxing</td>\n",
       "      <td>Boxing Men's Light-Heavyweight</td>\n",
       "      <td>0</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.1753</td>\n",
       "      <td>99.3877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>6849</td>\n",
       "      <td>Bai Faquan</td>\n",
       "      <td>M</td>\n",
       "      <td>26.0</td>\n",
       "      <td>173.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2012 Summer</td>\n",
       "      <td>2012</td>\n",
       "      <td>...</td>\n",
       "      <td>London</td>\n",
       "      <td>Triathlon</td>\n",
       "      <td>Triathlon Men's Olympic Distance</td>\n",
       "      <td>0</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.1753</td>\n",
       "      <td>99.3877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>6849</td>\n",
       "      <td>Bai Faquan</td>\n",
       "      <td>M</td>\n",
       "      <td>30.0</td>\n",
       "      <td>173.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2016 Summer</td>\n",
       "      <td>2016</td>\n",
       "      <td>...</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>Triathlon</td>\n",
       "      <td>Triathlon Men's Olympic Distance</td>\n",
       "      <td>0</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.1753</td>\n",
       "      <td>99.3877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>6851</td>\n",
       "      <td>Bai Jie</td>\n",
       "      <td>F</td>\n",
       "      <td>28.0</td>\n",
       "      <td>163.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2000 Summer</td>\n",
       "      <td>2000</td>\n",
       "      <td>...</td>\n",
       "      <td>Sydney</td>\n",
       "      <td>Football</td>\n",
       "      <td>Football Women's Football</td>\n",
       "      <td>0</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.1753</td>\n",
       "      <td>99.3877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>6853</td>\n",
       "      <td>Bai Lili</td>\n",
       "      <td>F</td>\n",
       "      <td>25.0</td>\n",
       "      <td>168.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2004 Summer</td>\n",
       "      <td>2004</td>\n",
       "      <td>...</td>\n",
       "      <td>Athina</td>\n",
       "      <td>Football</td>\n",
       "      <td>Football Women's Football</td>\n",
       "      <td>0</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.1753</td>\n",
       "      <td>99.3877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>6854</td>\n",
       "      <td>Bai Mei</td>\n",
       "      <td>F</td>\n",
       "      <td>17.0</td>\n",
       "      <td>166.0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>1992 Summer</td>\n",
       "      <td>1992</td>\n",
       "      <td>...</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>Rhythmic Gymnastics</td>\n",
       "      <td>Rhythmic Gymnastics Women's Individual</td>\n",
       "      <td>0</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.1753</td>\n",
       "      <td>99.3877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>6855</td>\n",
       "      <td>Bai Qiuming</td>\n",
       "      <td>M</td>\n",
       "      <td>19.0</td>\n",
       "      <td>173.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2014 Winter</td>\n",
       "      <td>2014</td>\n",
       "      <td>...</td>\n",
       "      <td>Sochi</td>\n",
       "      <td>Speed Skating</td>\n",
       "      <td>Speed Skating Men's 500 metres</td>\n",
       "      <td>0</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.1753</td>\n",
       "      <td>99.3877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>6857</td>\n",
       "      <td>Bai Xue</td>\n",
       "      <td>F</td>\n",
       "      <td>19.0</td>\n",
       "      <td>165.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2008 Summer</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Beijing</td>\n",
       "      <td>Athletics</td>\n",
       "      <td>Athletics Women's 10,000 metres</td>\n",
       "      <td>0</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.1753</td>\n",
       "      <td>99.3877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>7595</td>\n",
       "      <td>Bao Chunlai</td>\n",
       "      <td>M</td>\n",
       "      <td>21.0</td>\n",
       "      <td>190.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2004 Summer</td>\n",
       "      <td>2004</td>\n",
       "      <td>...</td>\n",
       "      <td>Athina</td>\n",
       "      <td>Badminton</td>\n",
       "      <td>Badminton Men's Singles</td>\n",
       "      <td>0</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.1753</td>\n",
       "      <td>99.3877</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",
       "      <td>...</td>\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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271086</th>\n",
       "      <td>86637</td>\n",
       "      <td>Lebenya Nkoka</td>\n",
       "      <td>M</td>\n",
       "      <td>33.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>LES</td>\n",
       "      <td>2016 Summer</td>\n",
       "      <td>2016</td>\n",
       "      <td>...</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>Athletics</td>\n",
       "      <td>Athletics Men's Marathon</td>\n",
       "      <td>0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-29.4460</td>\n",
       "      <td>28.3710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271087</th>\n",
       "      <td>87277</td>\n",
       "      <td>Frans Ntaole</td>\n",
       "      <td>M</td>\n",
       "      <td>33.0</td>\n",
       "      <td>168.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>LES</td>\n",
       "      <td>1984 Summer</td>\n",
       "      <td>1984</td>\n",
       "      <td>...</td>\n",
       "      <td>Los Angeles</td>\n",
       "      <td>Athletics</td>\n",
       "      <td>Athletics Men's 10,000 metres</td>\n",
       "      <td>0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-29.4460</td>\n",
       "      <td>28.3710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271088</th>\n",
       "      <td>87277</td>\n",
       "      <td>Frans Ntaole</td>\n",
       "      <td>M</td>\n",
       "      <td>33.0</td>\n",
       "      <td>168.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>LES</td>\n",
       "      <td>1984 Summer</td>\n",
       "      <td>1984</td>\n",
       "      <td>...</td>\n",
       "      <td>Los Angeles</td>\n",
       "      <td>Athletics</td>\n",
       "      <td>Athletics Men's Marathon</td>\n",
       "      <td>0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-29.4460</td>\n",
       "      <td>28.3710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271089</th>\n",
       "      <td>87282</td>\n",
       "      <td>Noheku Nteso</td>\n",
       "      <td>M</td>\n",
       "      <td>26.0</td>\n",
       "      <td>152.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>LES</td>\n",
       "      <td>1988 Summer</td>\n",
       "      <td>1988</td>\n",
       "      <td>...</td>\n",
       "      <td>Seoul</td>\n",
       "      <td>Athletics</td>\n",
       "      <td>Athletics Men's Marathon</td>\n",
       "      <td>0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-29.4460</td>\n",
       "      <td>28.3710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271090</th>\n",
       "      <td>87288</td>\n",
       "      <td>Mpesela Ntlot'soeu</td>\n",
       "      <td>M</td>\n",
       "      <td>27.0</td>\n",
       "      <td>154.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>LES</td>\n",
       "      <td>2004 Summer</td>\n",
       "      <td>2004</td>\n",
       "      <td>...</td>\n",
       "      <td>Athina</td>\n",
       "      <td>Athletics</td>\n",
       "      <td>Athletics Men's Marathon</td>\n",
       "      <td>0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-29.4460</td>\n",
       "      <td>28.3710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271091</th>\n",
       "      <td>95244</td>\n",
       "      <td>Mantokoane Angelina Pitso Sephooa</td>\n",
       "      <td>F</td>\n",
       "      <td>17.0</td>\n",
       "      <td>148.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>LES</td>\n",
       "      <td>1992 Summer</td>\n",
       "      <td>1992</td>\n",
       "      <td>...</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>Athletics</td>\n",
       "      <td>Athletics Women's 800 metres</td>\n",
       "      <td>0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-29.4460</td>\n",
       "      <td>28.3710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271092</th>\n",
       "      <td>95244</td>\n",
       "      <td>Mantokoane Angelina Pitso Sephooa</td>\n",
       "      <td>F</td>\n",
       "      <td>17.0</td>\n",
       "      <td>148.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>LES</td>\n",
       "      <td>1992 Summer</td>\n",
       "      <td>1992</td>\n",
       "      <td>...</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>Athletics</td>\n",
       "      <td>Athletics Women's 1,500 metres</td>\n",
       "      <td>0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-29.4460</td>\n",
       "      <td>28.3710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271093</th>\n",
       "      <td>98490</td>\n",
       "      <td>Gabashane Vincent Rakabaele</td>\n",
       "      <td>M</td>\n",
       "      <td>31.0</td>\n",
       "      <td>163.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>LES</td>\n",
       "      <td>1980 Summer</td>\n",
       "      <td>1980</td>\n",
       "      <td>...</td>\n",
       "      <td>Moskva</td>\n",
       "      <td>Athletics</td>\n",
       "      <td>Athletics Men's Marathon</td>\n",
       "      <td>0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-29.4460</td>\n",
       "      <td>28.3710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271094</th>\n",
       "      <td>98490</td>\n",
       "      <td>Gabashane Vincent Rakabaele</td>\n",
       "      <td>M</td>\n",
       "      <td>35.0</td>\n",
       "      <td>163.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>LES</td>\n",
       "      <td>1984 Summer</td>\n",
       "      <td>1984</td>\n",
       "      <td>...</td>\n",
       "      <td>Los Angeles</td>\n",
       "      <td>Athletics</td>\n",
       "      <td>Athletics Men's Marathon</td>\n",
       "      <td>0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-29.4460</td>\n",
       "      <td>28.3710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271095</th>\n",
       "      <td>98536</td>\n",
       "      <td>Thabisio Ralekhetla</td>\n",
       "      <td>M</td>\n",
       "      <td>36.0</td>\n",
       "      <td>172.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>LES</td>\n",
       "      <td>1996 Summer</td>\n",
       "      <td>1996</td>\n",
       "      <td>...</td>\n",
       "      <td>Atlanta</td>\n",
       "      <td>Athletics</td>\n",
       "      <td>Athletics Men's Marathon</td>\n",
       "      <td>0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-29.4460</td>\n",
       "      <td>28.3710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271096</th>\n",
       "      <td>98555</td>\n",
       "      <td>Patrick Rama</td>\n",
       "      <td>M</td>\n",
       "      <td>27.0</td>\n",
       "      <td>165.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>LES</td>\n",
       "      <td>1992 Summer</td>\n",
       "      <td>1992</td>\n",
       "      <td>...</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>Athletics</td>\n",
       "      <td>Athletics Men's 10,000 metres</td>\n",
       "      <td>0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-29.4460</td>\n",
       "      <td>28.3710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271097</th>\n",
       "      <td>98690</td>\n",
       "      <td>Tsepo Ramonene-Mathibelle</td>\n",
       "      <td>M</td>\n",
       "      <td>21.0</td>\n",
       "      <td>171.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>LES</td>\n",
       "      <td>2012 Summer</td>\n",
       "      <td>2012</td>\n",
       "      <td>...</td>\n",
       "      <td>London</td>\n",
       "      <td>Athletics</td>\n",
       "      <td>Athletics Men's Marathon</td>\n",
       "      <td>0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-29.4460</td>\n",
       "      <td>28.3710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271098</th>\n",
       "      <td>98690</td>\n",
       "      <td>Tsepo Ramonene-Mathibelle</td>\n",
       "      <td>M</td>\n",
       "      <td>25.0</td>\n",
       "      <td>171.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>LES</td>\n",
       "      <td>2016 Summer</td>\n",
       "      <td>2016</td>\n",
       "      <td>...</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>Athletics</td>\n",
       "      <td>Athletics Men's Marathon</td>\n",
       "      <td>0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-29.4460</td>\n",
       "      <td>28.3710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271099</th>\n",
       "      <td>108093</td>\n",
       "      <td>Isaac Sejama Seatile</td>\n",
       "      <td>M</td>\n",
       "      <td>23.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>LES</td>\n",
       "      <td>1996 Summer</td>\n",
       "      <td>1996</td>\n",
       "      <td>...</td>\n",
       "      <td>Atlanta</td>\n",
       "      <td>Athletics</td>\n",
       "      <td>Athletics Men's 4 x 400 metres Relay</td>\n",
       "      <td>0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-29.4460</td>\n",
       "      <td>28.3710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271100</th>\n",
       "      <td>108485</td>\n",
       "      <td>Sebongile Sello</td>\n",
       "      <td>F</td>\n",
       "      <td>20.0</td>\n",
       "      <td>158.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>LES</td>\n",
       "      <td>1996 Summer</td>\n",
       "      <td>1996</td>\n",
       "      <td>...</td>\n",
       "      <td>Atlanta</td>\n",
       "      <td>Athletics</td>\n",
       "      <td>Athletics Women's 4 x 100 metres Relay</td>\n",
       "      <td>0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-29.4460</td>\n",
       "      <td>28.3710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271101</th>\n",
       "      <td>108486</td>\n",
       "      <td>Tsepang Gladys Sello</td>\n",
       "      <td>F</td>\n",
       "      <td>19.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>LES</td>\n",
       "      <td>2016 Summer</td>\n",
       "      <td>2016</td>\n",
       "      <td>...</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>Athletics</td>\n",
       "      <td>Athletics Women's 800 metres</td>\n",
       "      <td>0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-29.4460</td>\n",
       "      <td>28.3710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271102</th>\n",
       "      <td>109447</td>\n",
       "      <td>Bothloko Shebe</td>\n",
       "      <td>M</td>\n",
       "      <td>20.0</td>\n",
       "      <td>178.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>LES</td>\n",
       "      <td>1992 Summer</td>\n",
       "      <td>1992</td>\n",
       "      <td>...</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>Athletics</td>\n",
       "      <td>Athletics Men's 100 metres</td>\n",
       "      <td>0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-29.4460</td>\n",
       "      <td>28.3710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271103</th>\n",
       "      <td>109447</td>\n",
       "      <td>Bothloko Shebe</td>\n",
       "      <td>M</td>\n",
       "      <td>20.0</td>\n",
       "      <td>178.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>LES</td>\n",
       "      <td>1992 Summer</td>\n",
       "      <td>1992</td>\n",
       "      <td>...</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>Athletics</td>\n",
       "      <td>Athletics Men's 200 metres</td>\n",
       "      <td>0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-29.4460</td>\n",
       "      <td>28.3710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271104</th>\n",
       "      <td>109961</td>\n",
       "      <td>Lineo Florence Shoai</td>\n",
       "      <td>F</td>\n",
       "      <td>17.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>LES</td>\n",
       "      <td>1996 Summer</td>\n",
       "      <td>1996</td>\n",
       "      <td>...</td>\n",
       "      <td>Atlanta</td>\n",
       "      <td>Athletics</td>\n",
       "      <td>Athletics Women's 200 metres</td>\n",
       "      <td>0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-29.4460</td>\n",
       "      <td>28.3710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271105</th>\n",
       "      <td>109961</td>\n",
       "      <td>Lineo Florence Shoai</td>\n",
       "      <td>F</td>\n",
       "      <td>17.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>LES</td>\n",
       "      <td>1996 Summer</td>\n",
       "      <td>1996</td>\n",
       "      <td>...</td>\n",
       "      <td>Atlanta</td>\n",
       "      <td>Athletics</td>\n",
       "      <td>Athletics Women's 4 x 100 metres Relay</td>\n",
       "      <td>0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-29.4460</td>\n",
       "      <td>28.3710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271106</th>\n",
       "      <td>109961</td>\n",
       "      <td>Lineo Florence Shoai</td>\n",
       "      <td>F</td>\n",
       "      <td>21.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>LES</td>\n",
       "      <td>2000 Summer</td>\n",
       "      <td>2000</td>\n",
       "      <td>...</td>\n",
       "      <td>Sydney</td>\n",
       "      <td>Athletics</td>\n",
       "      <td>Athletics Women's 200 metres</td>\n",
       "      <td>0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-29.4460</td>\n",
       "      <td>28.3710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271107</th>\n",
       "      <td>116595</td>\n",
       "      <td>Inkululeko Suntele</td>\n",
       "      <td>M</td>\n",
       "      <td>22.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>LES</td>\n",
       "      <td>2016 Summer</td>\n",
       "      <td>2016</td>\n",
       "      <td>...</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>Boxing</td>\n",
       "      <td>Boxing Men's Bantamweight</td>\n",
       "      <td>0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-29.4460</td>\n",
       "      <td>28.3710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271108</th>\n",
       "      <td>119456</td>\n",
       "      <td>Motlalepula Thabana</td>\n",
       "      <td>M</td>\n",
       "      <td>30.0</td>\n",
       "      <td>153.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>LES</td>\n",
       "      <td>1980 Summer</td>\n",
       "      <td>1980</td>\n",
       "      <td>...</td>\n",
       "      <td>Moskva</td>\n",
       "      <td>Athletics</td>\n",
       "      <td>Athletics Men's 10,000 metres</td>\n",
       "      <td>0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-29.4460</td>\n",
       "      <td>28.3710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271109</th>\n",
       "      <td>119487</td>\n",
       "      <td>Likeleli Alinah Thamae</td>\n",
       "      <td>F</td>\n",
       "      <td>22.0</td>\n",
       "      <td>170.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>LES</td>\n",
       "      <td>2000 Summer</td>\n",
       "      <td>2000</td>\n",
       "      <td>...</td>\n",
       "      <td>Sydney</td>\n",
       "      <td>Taekwondo</td>\n",
       "      <td>Taekwondo Women's Flyweight</td>\n",
       "      <td>0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-29.4460</td>\n",
       "      <td>28.3710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271110</th>\n",
       "      <td>119563</td>\n",
       "      <td>Masempe Theko</td>\n",
       "      <td>F</td>\n",
       "      <td>25.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>LES</td>\n",
       "      <td>2012 Summer</td>\n",
       "      <td>2012</td>\n",
       "      <td>...</td>\n",
       "      <td>London</td>\n",
       "      <td>Swimming</td>\n",
       "      <td>Swimming Women's 50 metres Freestyle</td>\n",
       "      <td>0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-29.4460</td>\n",
       "      <td>28.3710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271111</th>\n",
       "      <td>120575</td>\n",
       "      <td>Mamorallo Tjoka</td>\n",
       "      <td>F</td>\n",
       "      <td>23.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>LES</td>\n",
       "      <td>2008 Summer</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Beijing</td>\n",
       "      <td>Athletics</td>\n",
       "      <td>Athletics Women's Marathon</td>\n",
       "      <td>0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-29.4460</td>\n",
       "      <td>28.3710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271112</th>\n",
       "      <td>120575</td>\n",
       "      <td>Mamorallo Tjoka</td>\n",
       "      <td>F</td>\n",
       "      <td>27.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>LES</td>\n",
       "      <td>2012 Summer</td>\n",
       "      <td>2012</td>\n",
       "      <td>...</td>\n",
       "      <td>London</td>\n",
       "      <td>Athletics</td>\n",
       "      <td>Athletics Women's Marathon</td>\n",
       "      <td>0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-29.4460</td>\n",
       "      <td>28.3710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271113</th>\n",
       "      <td>122166</td>\n",
       "      <td>M'apotlaki Ts'elho</td>\n",
       "      <td>F</td>\n",
       "      <td>15.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>LES</td>\n",
       "      <td>1996 Summer</td>\n",
       "      <td>1996</td>\n",
       "      <td>...</td>\n",
       "      <td>Atlanta</td>\n",
       "      <td>Athletics</td>\n",
       "      <td>Athletics Women's 4 x 100 metres Relay</td>\n",
       "      <td>0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-29.4460</td>\n",
       "      <td>28.3710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271114</th>\n",
       "      <td>122215</td>\n",
       "      <td>Lefa Tsapi</td>\n",
       "      <td>M</td>\n",
       "      <td>23.0</td>\n",
       "      <td>170.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>LES</td>\n",
       "      <td>1984 Summer</td>\n",
       "      <td>1984</td>\n",
       "      <td>...</td>\n",
       "      <td>Los Angeles</td>\n",
       "      <td>Boxing</td>\n",
       "      <td>Boxing Men's Welterweight</td>\n",
       "      <td>0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-29.4460</td>\n",
       "      <td>28.3710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271115</th>\n",
       "      <td>122299</td>\n",
       "      <td>Mosolesa Tsie</td>\n",
       "      <td>M</td>\n",
       "      <td>20.0</td>\n",
       "      <td>175.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>LES</td>\n",
       "      <td>2000 Summer</td>\n",
       "      <td>2000</td>\n",
       "      <td>...</td>\n",
       "      <td>Sydney</td>\n",
       "      <td>Boxing</td>\n",
       "      <td>Boxing Men's Welterweight</td>\n",
       "      <td>0</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-29.4460</td>\n",
       "      <td>28.3710</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>271116 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            ID                               Name Sex   Age  Height  Weight  \\\n",
       "0            1                          A Dijiang   M  24.0   180.0    80.0   \n",
       "1            2                           A Lamusi   M  23.0   170.0    60.0   \n",
       "2          602                      Abudoureheman   M  22.0   182.0    75.0   \n",
       "3         1463                          Ai Linuer   M  25.0   160.0    62.0   \n",
       "4         1464                          Ai Yanhan   F  14.0   168.0    54.0   \n",
       "5         1464                          Ai Yanhan   F  14.0   168.0    54.0   \n",
       "6         3605                        An Weijiang   M  22.0   178.0    72.0   \n",
       "7         3605                        An Weijiang   M  22.0   178.0    72.0   \n",
       "8         3610                          An Yulong   M  19.0   173.0    70.0   \n",
       "9         3610                          An Yulong   M  19.0   173.0    70.0   \n",
       "10        3610                          An Yulong   M  19.0   173.0    70.0   \n",
       "11        3610                          An Yulong   M  23.0   173.0    70.0   \n",
       "12        3611                        An Zhongxin   F  23.0   170.0    65.0   \n",
       "13        3611                        An Zhongxin   F  27.0   170.0    65.0   \n",
       "14        4639                       Ao Changrong   M  25.0   173.0    71.0   \n",
       "15        4641                           Ao Tegen   M  21.0   181.0    90.0   \n",
       "16        6376                           Ba Dexin   M  23.0   185.0    80.0   \n",
       "17        6381                             Ba Yan   F  21.0   183.0    78.0   \n",
       "18        6382                        Ba Yanchuan   M  24.0   187.0   100.0   \n",
       "19        6383                        Ba Yongshan   M  22.0   180.0    70.0   \n",
       "20        6847                           Bai Anqi   F  19.0   164.0    59.0   \n",
       "21        6848                     Bai Chongguang   M  21.0   184.0    83.0   \n",
       "22        6849                         Bai Faquan   M  26.0   173.0    66.0   \n",
       "23        6849                         Bai Faquan   M  30.0   173.0    66.0   \n",
       "24        6851                            Bai Jie   F  28.0   163.0    53.0   \n",
       "25        6853                           Bai Lili   F  25.0   168.0    57.0   \n",
       "26        6854                            Bai Mei   F  17.0   166.0    46.0   \n",
       "27        6855                        Bai Qiuming   M  19.0   173.0    70.0   \n",
       "28        6857                            Bai Xue   F  19.0   165.0    53.0   \n",
       "29        7595                        Bao Chunlai   M  21.0   190.0    80.0   \n",
       "...        ...                                ...  ..   ...     ...     ...   \n",
       "271086   86637                      Lebenya Nkoka   M  33.0     NaN     NaN   \n",
       "271087   87277                       Frans Ntaole   M  33.0   168.0    62.0   \n",
       "271088   87277                       Frans Ntaole   M  33.0   168.0    62.0   \n",
       "271089   87282                       Noheku Nteso   M  26.0   152.0    44.0   \n",
       "271090   87288                 Mpesela Ntlot'soeu   M  27.0   154.0    58.0   \n",
       "271091   95244  Mantokoane Angelina Pitso Sephooa   F  17.0   148.0    45.0   \n",
       "271092   95244  Mantokoane Angelina Pitso Sephooa   F  17.0   148.0    45.0   \n",
       "271093   98490        Gabashane Vincent Rakabaele   M  31.0   163.0    54.0   \n",
       "271094   98490        Gabashane Vincent Rakabaele   M  35.0   163.0    54.0   \n",
       "271095   98536                Thabisio Ralekhetla   M  36.0   172.0    54.0   \n",
       "271096   98555                       Patrick Rama   M  27.0   165.0    65.0   \n",
       "271097   98690          Tsepo Ramonene-Mathibelle   M  21.0   171.0    54.0   \n",
       "271098   98690          Tsepo Ramonene-Mathibelle   M  25.0   171.0    54.0   \n",
       "271099  108093               Isaac Sejama Seatile   M  23.0     NaN     NaN   \n",
       "271100  108485                    Sebongile Sello   F  20.0   158.0    41.0   \n",
       "271101  108486               Tsepang Gladys Sello   F  19.0     NaN     NaN   \n",
       "271102  109447                     Bothloko Shebe   M  20.0   178.0    65.0   \n",
       "271103  109447                     Bothloko Shebe   M  20.0   178.0    65.0   \n",
       "271104  109961               Lineo Florence Shoai   F  17.0     NaN     NaN   \n",
       "271105  109961               Lineo Florence Shoai   F  17.0     NaN     NaN   \n",
       "271106  109961               Lineo Florence Shoai   F  21.0     NaN     NaN   \n",
       "271107  116595                 Inkululeko Suntele   M  22.0     NaN     NaN   \n",
       "271108  119456                Motlalepula Thabana   M  30.0   153.0    54.0   \n",
       "271109  119487             Likeleli Alinah Thamae   F  22.0   170.0    49.0   \n",
       "271110  119563                      Masempe Theko   F  25.0     NaN     NaN   \n",
       "271111  120575                    Mamorallo Tjoka   F  23.0   150.0    56.0   \n",
       "271112  120575                    Mamorallo Tjoka   F  27.0   150.0    56.0   \n",
       "271113  122166                 M'apotlaki Ts'elho   F  15.0     NaN     NaN   \n",
       "271114  122215                         Lefa Tsapi   M  23.0   170.0    63.0   \n",
       "271115  122299                      Mosolesa Tsie   M  20.0   175.0    75.0   \n",
       "\n",
       "           Team  NOC        Games  Year  ...            City  \\\n",
       "0         China  CHN  1992 Summer  1992  ...       Barcelona   \n",
       "1         China  CHN  2012 Summer  2012  ...          London   \n",
       "2         China  CHN  2000 Summer  2000  ...          Sydney   \n",
       "3         China  CHN  2004 Summer  2004  ...          Athina   \n",
       "4         China  CHN  2016 Summer  2016  ...  Rio de Janeiro   \n",
       "5         China  CHN  2016 Summer  2016  ...  Rio de Janeiro   \n",
       "6         China  CHN  2006 Winter  2006  ...          Torino   \n",
       "7         China  CHN  2006 Winter  2006  ...          Torino   \n",
       "8         China  CHN  1998 Winter  1998  ...          Nagano   \n",
       "9         China  CHN  1998 Winter  1998  ...          Nagano   \n",
       "10        China  CHN  1998 Winter  1998  ...          Nagano   \n",
       "11        China  CHN  2002 Winter  2002  ...  Salt Lake City   \n",
       "12        China  CHN  1996 Summer  1996  ...         Atlanta   \n",
       "13        China  CHN  2000 Summer  2000  ...          Sydney   \n",
       "14        China  CHN  2008 Summer  2008  ...         Beijing   \n",
       "15        China  CHN  1996 Summer  1996  ...         Atlanta   \n",
       "16        China  CHN  2014 Winter  2014  ...           Sochi   \n",
       "17        China  CHN  1984 Summer  1984  ...     Los Angeles   \n",
       "18        China  CHN  1996 Summer  1996  ...         Atlanta   \n",
       "19        China  CHN  1984 Summer  1984  ...     Los Angeles   \n",
       "20        China  CHN  2012 Summer  2012  ...          London   \n",
       "21        China  CHN  1992 Summer  1992  ...       Barcelona   \n",
       "22        China  CHN  2012 Summer  2012  ...          London   \n",
       "23        China  CHN  2016 Summer  2016  ...  Rio de Janeiro   \n",
       "24        China  CHN  2000 Summer  2000  ...          Sydney   \n",
       "25        China  CHN  2004 Summer  2004  ...          Athina   \n",
       "26        China  CHN  1992 Summer  1992  ...       Barcelona   \n",
       "27        China  CHN  2014 Winter  2014  ...           Sochi   \n",
       "28        China  CHN  2008 Summer  2008  ...         Beijing   \n",
       "29        China  CHN  2004 Summer  2004  ...          Athina   \n",
       "...         ...  ...          ...   ...  ...             ...   \n",
       "271086  Lesotho  LES  2016 Summer  2016  ...  Rio de Janeiro   \n",
       "271087  Lesotho  LES  1984 Summer  1984  ...     Los Angeles   \n",
       "271088  Lesotho  LES  1984 Summer  1984  ...     Los Angeles   \n",
       "271089  Lesotho  LES  1988 Summer  1988  ...           Seoul   \n",
       "271090  Lesotho  LES  2004 Summer  2004  ...          Athina   \n",
       "271091  Lesotho  LES  1992 Summer  1992  ...       Barcelona   \n",
       "271092  Lesotho  LES  1992 Summer  1992  ...       Barcelona   \n",
       "271093  Lesotho  LES  1980 Summer  1980  ...          Moskva   \n",
       "271094  Lesotho  LES  1984 Summer  1984  ...     Los Angeles   \n",
       "271095  Lesotho  LES  1996 Summer  1996  ...         Atlanta   \n",
       "271096  Lesotho  LES  1992 Summer  1992  ...       Barcelona   \n",
       "271097  Lesotho  LES  2012 Summer  2012  ...          London   \n",
       "271098  Lesotho  LES  2016 Summer  2016  ...  Rio de Janeiro   \n",
       "271099  Lesotho  LES  1996 Summer  1996  ...         Atlanta   \n",
       "271100  Lesotho  LES  1996 Summer  1996  ...         Atlanta   \n",
       "271101  Lesotho  LES  2016 Summer  2016  ...  Rio de Janeiro   \n",
       "271102  Lesotho  LES  1992 Summer  1992  ...       Barcelona   \n",
       "271103  Lesotho  LES  1992 Summer  1992  ...       Barcelona   \n",
       "271104  Lesotho  LES  1996 Summer  1996  ...         Atlanta   \n",
       "271105  Lesotho  LES  1996 Summer  1996  ...         Atlanta   \n",
       "271106  Lesotho  LES  2000 Summer  2000  ...          Sydney   \n",
       "271107  Lesotho  LES  2016 Summer  2016  ...  Rio de Janeiro   \n",
       "271108  Lesotho  LES  1980 Summer  1980  ...          Moskva   \n",
       "271109  Lesotho  LES  2000 Summer  2000  ...          Sydney   \n",
       "271110  Lesotho  LES  2012 Summer  2012  ...          London   \n",
       "271111  Lesotho  LES  2008 Summer  2008  ...         Beijing   \n",
       "271112  Lesotho  LES  2012 Summer  2012  ...          London   \n",
       "271113  Lesotho  LES  1996 Summer  1996  ...         Atlanta   \n",
       "271114  Lesotho  LES  1984 Summer  1984  ...     Los Angeles   \n",
       "271115  Lesotho  LES  2000 Summer  2000  ...          Sydney   \n",
       "\n",
       "                            Sport  \\\n",
       "0                      Basketball   \n",
       "1                            Judo   \n",
       "2                          Boxing   \n",
       "3                       Wrestling   \n",
       "4                        Swimming   \n",
       "5                        Swimming   \n",
       "6                   Speed Skating   \n",
       "7                   Speed Skating   \n",
       "8       Short Track Speed Skating   \n",
       "9       Short Track Speed Skating   \n",
       "10      Short Track Speed Skating   \n",
       "11      Short Track Speed Skating   \n",
       "12                       Softball   \n",
       "13                       Softball   \n",
       "14                         Hockey   \n",
       "15                           Judo   \n",
       "16                        Curling   \n",
       "17                     Basketball   \n",
       "18                      Wrestling   \n",
       "19                        Archery   \n",
       "20                       Swimming   \n",
       "21                         Boxing   \n",
       "22                      Triathlon   \n",
       "23                      Triathlon   \n",
       "24                       Football   \n",
       "25                       Football   \n",
       "26            Rhythmic Gymnastics   \n",
       "27                  Speed Skating   \n",
       "28                      Athletics   \n",
       "29                      Badminton   \n",
       "...                           ...   \n",
       "271086                  Athletics   \n",
       "271087                  Athletics   \n",
       "271088                  Athletics   \n",
       "271089                  Athletics   \n",
       "271090                  Athletics   \n",
       "271091                  Athletics   \n",
       "271092                  Athletics   \n",
       "271093                  Athletics   \n",
       "271094                  Athletics   \n",
       "271095                  Athletics   \n",
       "271096                  Athletics   \n",
       "271097                  Athletics   \n",
       "271098                  Athletics   \n",
       "271099                  Athletics   \n",
       "271100                  Athletics   \n",
       "271101                  Athletics   \n",
       "271102                  Athletics   \n",
       "271103                  Athletics   \n",
       "271104                  Athletics   \n",
       "271105                  Athletics   \n",
       "271106                  Athletics   \n",
       "271107                     Boxing   \n",
       "271108                  Athletics   \n",
       "271109                  Taekwondo   \n",
       "271110                   Swimming   \n",
       "271111                  Athletics   \n",
       "271112                  Athletics   \n",
       "271113                  Athletics   \n",
       "271114                     Boxing   \n",
       "271115                     Boxing   \n",
       "\n",
       "                                                    Event   Medal  Country  \\\n",
       "0                             Basketball Men's Basketball       0    China   \n",
       "1                            Judo Men's Extra-Lightweight       0    China   \n",
       "2                               Boxing Men's Middleweight       0    China   \n",
       "3                Wrestling Men's Lightweight, Greco-Roman       0    China   \n",
       "4                   Swimming Women's 200 metres Freestyle       0    China   \n",
       "5         Swimming Women's 4 x 200 metres Freestyle Relay       0    China   \n",
       "6                          Speed Skating Men's 500 metres       0    China   \n",
       "7                        Speed Skating Men's 1,000 metres       0    China   \n",
       "8              Short Track Speed Skating Men's 500 metres  Silver    China   \n",
       "9            Short Track Speed Skating Men's 1,000 metres       0    China   \n",
       "10      Short Track Speed Skating Men's 5,000 metres R...  Bronze    China   \n",
       "11      Short Track Speed Skating Men's 5,000 metres R...  Bronze    China   \n",
       "12                              Softball Women's Softball  Silver    China   \n",
       "13                              Softball Women's Softball       0    China   \n",
       "14                                    Hockey Men's Hockey       0    China   \n",
       "15                                Judo Men's Middleweight       0    China   \n",
       "16                                  Curling Men's Curling       0    China   \n",
       "17                          Basketball Women's Basketball  Bronze    China   \n",
       "18               Wrestling Men's Heavyweight, Greco-Roman       0    China   \n",
       "19                               Archery Men's Individual       0    China   \n",
       "20                 Swimming Women's 200 metres Backstroke       0    China   \n",
       "21                         Boxing Men's Light-Heavyweight       0    China   \n",
       "22                       Triathlon Men's Olympic Distance       0    China   \n",
       "23                       Triathlon Men's Olympic Distance       0    China   \n",
       "24                              Football Women's Football       0    China   \n",
       "25                              Football Women's Football       0    China   \n",
       "26                 Rhythmic Gymnastics Women's Individual       0    China   \n",
       "27                         Speed Skating Men's 500 metres       0    China   \n",
       "28                        Athletics Women's 10,000 metres       0    China   \n",
       "29                                Badminton Men's Singles       0    China   \n",
       "...                                                   ...     ...      ...   \n",
       "271086                           Athletics Men's Marathon       0  Lesotho   \n",
       "271087                      Athletics Men's 10,000 metres       0  Lesotho   \n",
       "271088                           Athletics Men's Marathon       0  Lesotho   \n",
       "271089                           Athletics Men's Marathon       0  Lesotho   \n",
       "271090                           Athletics Men's Marathon       0  Lesotho   \n",
       "271091                       Athletics Women's 800 metres       0  Lesotho   \n",
       "271092                     Athletics Women's 1,500 metres       0  Lesotho   \n",
       "271093                           Athletics Men's Marathon       0  Lesotho   \n",
       "271094                           Athletics Men's Marathon       0  Lesotho   \n",
       "271095                           Athletics Men's Marathon       0  Lesotho   \n",
       "271096                      Athletics Men's 10,000 metres       0  Lesotho   \n",
       "271097                           Athletics Men's Marathon       0  Lesotho   \n",
       "271098                           Athletics Men's Marathon       0  Lesotho   \n",
       "271099               Athletics Men's 4 x 400 metres Relay       0  Lesotho   \n",
       "271100             Athletics Women's 4 x 100 metres Relay       0  Lesotho   \n",
       "271101                       Athletics Women's 800 metres       0  Lesotho   \n",
       "271102                         Athletics Men's 100 metres       0  Lesotho   \n",
       "271103                         Athletics Men's 200 metres       0  Lesotho   \n",
       "271104                       Athletics Women's 200 metres       0  Lesotho   \n",
       "271105             Athletics Women's 4 x 100 metres Relay       0  Lesotho   \n",
       "271106                       Athletics Women's 200 metres       0  Lesotho   \n",
       "271107                          Boxing Men's Bantamweight       0  Lesotho   \n",
       "271108                      Athletics Men's 10,000 metres       0  Lesotho   \n",
       "271109                        Taekwondo Women's Flyweight       0  Lesotho   \n",
       "271110               Swimming Women's 50 metres Freestyle       0  Lesotho   \n",
       "271111                         Athletics Women's Marathon       0  Lesotho   \n",
       "271112                         Athletics Women's Marathon       0  Lesotho   \n",
       "271113             Athletics Women's 4 x 100 metres Relay       0  Lesotho   \n",
       "271114                          Boxing Men's Welterweight       0  Lesotho   \n",
       "271115                          Boxing Men's Welterweight       0  Lesotho   \n",
       "\n",
       "       notes Lat  Lng  Latitude (generated)  Longitude (generated)  \n",
       "0        NaN NaN  NaN               35.1753                99.3877  \n",
       "1        NaN NaN  NaN               35.1753                99.3877  \n",
       "2        NaN NaN  NaN               35.1753                99.3877  \n",
       "3        NaN NaN  NaN               35.1753                99.3877  \n",
       "4        NaN NaN  NaN               35.1753                99.3877  \n",
       "5        NaN NaN  NaN               35.1753                99.3877  \n",
       "6        NaN NaN  NaN               35.1753                99.3877  \n",
       "7        NaN NaN  NaN               35.1753                99.3877  \n",
       "8        NaN NaN  NaN               35.1753                99.3877  \n",
       "9        NaN NaN  NaN               35.1753                99.3877  \n",
       "10       NaN NaN  NaN               35.1753                99.3877  \n",
       "11       NaN NaN  NaN               35.1753                99.3877  \n",
       "12       NaN NaN  NaN               35.1753                99.3877  \n",
       "13       NaN NaN  NaN               35.1753                99.3877  \n",
       "14       NaN NaN  NaN               35.1753                99.3877  \n",
       "15       NaN NaN  NaN               35.1753                99.3877  \n",
       "16       NaN NaN  NaN               35.1753                99.3877  \n",
       "17       NaN NaN  NaN               35.1753                99.3877  \n",
       "18       NaN NaN  NaN               35.1753                99.3877  \n",
       "19       NaN NaN  NaN               35.1753                99.3877  \n",
       "20       NaN NaN  NaN               35.1753                99.3877  \n",
       "21       NaN NaN  NaN               35.1753                99.3877  \n",
       "22       NaN NaN  NaN               35.1753                99.3877  \n",
       "23       NaN NaN  NaN               35.1753                99.3877  \n",
       "24       NaN NaN  NaN               35.1753                99.3877  \n",
       "25       NaN NaN  NaN               35.1753                99.3877  \n",
       "26       NaN NaN  NaN               35.1753                99.3877  \n",
       "27       NaN NaN  NaN               35.1753                99.3877  \n",
       "28       NaN NaN  NaN               35.1753                99.3877  \n",
       "29       NaN NaN  NaN               35.1753                99.3877  \n",
       "...      ...  ..  ...                   ...                    ...  \n",
       "271086   NaN NaN  NaN              -29.4460                28.3710  \n",
       "271087   NaN NaN  NaN              -29.4460                28.3710  \n",
       "271088   NaN NaN  NaN              -29.4460                28.3710  \n",
       "271089   NaN NaN  NaN              -29.4460                28.3710  \n",
       "271090   NaN NaN  NaN              -29.4460                28.3710  \n",
       "271091   NaN NaN  NaN              -29.4460                28.3710  \n",
       "271092   NaN NaN  NaN              -29.4460                28.3710  \n",
       "271093   NaN NaN  NaN              -29.4460                28.3710  \n",
       "271094   NaN NaN  NaN              -29.4460                28.3710  \n",
       "271095   NaN NaN  NaN              -29.4460                28.3710  \n",
       "271096   NaN NaN  NaN              -29.4460                28.3710  \n",
       "271097   NaN NaN  NaN              -29.4460                28.3710  \n",
       "271098   NaN NaN  NaN              -29.4460                28.3710  \n",
       "271099   NaN NaN  NaN              -29.4460                28.3710  \n",
       "271100   NaN NaN  NaN              -29.4460                28.3710  \n",
       "271101   NaN NaN  NaN              -29.4460                28.3710  \n",
       "271102   NaN NaN  NaN              -29.4460                28.3710  \n",
       "271103   NaN NaN  NaN              -29.4460                28.3710  \n",
       "271104   NaN NaN  NaN              -29.4460                28.3710  \n",
       "271105   NaN NaN  NaN              -29.4460                28.3710  \n",
       "271106   NaN NaN  NaN              -29.4460                28.3710  \n",
       "271107   NaN NaN  NaN              -29.4460                28.3710  \n",
       "271108   NaN NaN  NaN              -29.4460                28.3710  \n",
       "271109   NaN NaN  NaN              -29.4460                28.3710  \n",
       "271110   NaN NaN  NaN              -29.4460                28.3710  \n",
       "271111   NaN NaN  NaN              -29.4460                28.3710  \n",
       "271112   NaN NaN  NaN              -29.4460                28.3710  \n",
       "271113   NaN NaN  NaN              -29.4460                28.3710  \n",
       "271114   NaN NaN  NaN              -29.4460                28.3710  \n",
       "271115   NaN NaN  NaN              -29.4460                28.3710  \n",
       "\n",
       "[271116 rows x 21 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "athlete_noc_latlng_pd.head(271117)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "athlete_noc_latlng_pd = athlete_noc_latlng_pd.set_index('ID')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Name</th>\n",
       "      <th>Sex</th>\n",
       "      <th>Age</th>\n",
       "      <th>Height</th>\n",
       "      <th>Weight</th>\n",
       "      <th>Team</th>\n",
       "      <th>NOC</th>\n",
       "      <th>Games</th>\n",
       "      <th>Year</th>\n",
       "      <th>Season</th>\n",
       "      <th>City</th>\n",
       "      <th>Sport</th>\n",
       "      <th>Event</th>\n",
       "      <th>Medal</th>\n",
       "      <th>Country</th>\n",
       "      <th>notes</th>\n",
       "      <th>Lat</th>\n",
       "      <th>Lng</th>\n",
       "      <th>Latitude (generated)</th>\n",
       "      <th>Longitude (generated)</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ID</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>A Dijiang</td>\n",
       "      <td>M</td>\n",
       "      <td>24.0</td>\n",
       "      <td>180.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>1992 Summer</td>\n",
       "      <td>1992</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>Basketball</td>\n",
       "      <td>Basketball Men's Basketball</td>\n",
       "      <td>0</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.1753</td>\n",
       "      <td>99.3877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>A Lamusi</td>\n",
       "      <td>M</td>\n",
       "      <td>23.0</td>\n",
       "      <td>170.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2012 Summer</td>\n",
       "      <td>2012</td>\n",
       "      <td>Summer</td>\n",
       "      <td>London</td>\n",
       "      <td>Judo</td>\n",
       "      <td>Judo Men's Extra-Lightweight</td>\n",
       "      <td>0</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.1753</td>\n",
       "      <td>99.3877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>602</th>\n",
       "      <td>Abudoureheman</td>\n",
       "      <td>M</td>\n",
       "      <td>22.0</td>\n",
       "      <td>182.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2000 Summer</td>\n",
       "      <td>2000</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Sydney</td>\n",
       "      <td>Boxing</td>\n",
       "      <td>Boxing Men's Middleweight</td>\n",
       "      <td>0</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.1753</td>\n",
       "      <td>99.3877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1463</th>\n",
       "      <td>Ai Linuer</td>\n",
       "      <td>M</td>\n",
       "      <td>25.0</td>\n",
       "      <td>160.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2004 Summer</td>\n",
       "      <td>2004</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Athina</td>\n",
       "      <td>Wrestling</td>\n",
       "      <td>Wrestling Men's Lightweight, Greco-Roman</td>\n",
       "      <td>0</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.1753</td>\n",
       "      <td>99.3877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1464</th>\n",
       "      <td>Ai Yanhan</td>\n",
       "      <td>F</td>\n",
       "      <td>14.0</td>\n",
       "      <td>168.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2016 Summer</td>\n",
       "      <td>2016</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>Swimming</td>\n",
       "      <td>Swimming Women's 200 metres Freestyle</td>\n",
       "      <td>0</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.1753</td>\n",
       "      <td>99.3877</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               Name Sex   Age  Height  Weight   Team  NOC        Games  Year  \\\n",
       "ID                                                                             \n",
       "1         A Dijiang   M  24.0   180.0    80.0  China  CHN  1992 Summer  1992   \n",
       "2          A Lamusi   M  23.0   170.0    60.0  China  CHN  2012 Summer  2012   \n",
       "602   Abudoureheman   M  22.0   182.0    75.0  China  CHN  2000 Summer  2000   \n",
       "1463      Ai Linuer   M  25.0   160.0    62.0  China  CHN  2004 Summer  2004   \n",
       "1464      Ai Yanhan   F  14.0   168.0    54.0  China  CHN  2016 Summer  2016   \n",
       "\n",
       "      Season            City       Sport  \\\n",
       "ID                                         \n",
       "1     Summer       Barcelona  Basketball   \n",
       "2     Summer          London        Judo   \n",
       "602   Summer          Sydney      Boxing   \n",
       "1463  Summer          Athina   Wrestling   \n",
       "1464  Summer  Rio de Janeiro    Swimming   \n",
       "\n",
       "                                         Event Medal Country notes  Lat  Lng  \\\n",
       "ID                                                                             \n",
       "1                  Basketball Men's Basketball     0   China   NaN  NaN  NaN   \n",
       "2                 Judo Men's Extra-Lightweight     0   China   NaN  NaN  NaN   \n",
       "602                  Boxing Men's Middleweight     0   China   NaN  NaN  NaN   \n",
       "1463  Wrestling Men's Lightweight, Greco-Roman     0   China   NaN  NaN  NaN   \n",
       "1464     Swimming Women's 200 metres Freestyle     0   China   NaN  NaN  NaN   \n",
       "\n",
       "      Latitude (generated)  Longitude (generated)  \n",
       "ID                                                 \n",
       "1                  35.1753                99.3877  \n",
       "2                  35.1753                99.3877  \n",
       "602                35.1753                99.3877  \n",
       "1463               35.1753                99.3877  \n",
       "1464               35.1753                99.3877  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "athlete_noc_latlng_pd.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "athlete_noc_latlng_pd = athlete_noc_latlng_pd.drop([\"notes\", \"Lat\", \"Lng\"], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "athlete_noc_latlng_pd = athlete_noc_latlng_pd.rename(columns={'Latitude (generated)': 'Lat'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "athlete_noc_latlng_pd = athlete_noc_latlng_pd.rename(columns={'Longitude (generated)': 'Lng'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "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>ID</th>\n",
       "      <th>Name</th>\n",
       "      <th>Sex</th>\n",
       "      <th>Age</th>\n",
       "      <th>Height</th>\n",
       "      <th>Weight</th>\n",
       "      <th>Team</th>\n",
       "      <th>NOC</th>\n",
       "      <th>Games</th>\n",
       "      <th>Year</th>\n",
       "      <th>Season</th>\n",
       "      <th>City</th>\n",
       "      <th>Sport</th>\n",
       "      <th>Event</th>\n",
       "      <th>Medal</th>\n",
       "      <th>Country</th>\n",
       "      <th>Lat</th>\n",
       "      <th>Lng</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>A Dijiang</td>\n",
       "      <td>M</td>\n",
       "      <td>24.0</td>\n",
       "      <td>180.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>1992 Summer</td>\n",
       "      <td>1992</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>Basketball</td>\n",
       "      <td>Basketball Men's Basketball</td>\n",
       "      <td>0</td>\n",
       "      <td>China</td>\n",
       "      <td>35.1753</td>\n",
       "      <td>99.3877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>A Lamusi</td>\n",
       "      <td>M</td>\n",
       "      <td>23.0</td>\n",
       "      <td>170.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2012 Summer</td>\n",
       "      <td>2012</td>\n",
       "      <td>Summer</td>\n",
       "      <td>London</td>\n",
       "      <td>Judo</td>\n",
       "      <td>Judo Men's Extra-Lightweight</td>\n",
       "      <td>0</td>\n",
       "      <td>China</td>\n",
       "      <td>35.1753</td>\n",
       "      <td>99.3877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>602</td>\n",
       "      <td>Abudoureheman</td>\n",
       "      <td>M</td>\n",
       "      <td>22.0</td>\n",
       "      <td>182.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2000 Summer</td>\n",
       "      <td>2000</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Sydney</td>\n",
       "      <td>Boxing</td>\n",
       "      <td>Boxing Men's Middleweight</td>\n",
       "      <td>0</td>\n",
       "      <td>China</td>\n",
       "      <td>35.1753</td>\n",
       "      <td>99.3877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1463</td>\n",
       "      <td>Ai Linuer</td>\n",
       "      <td>M</td>\n",
       "      <td>25.0</td>\n",
       "      <td>160.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2004 Summer</td>\n",
       "      <td>2004</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Athina</td>\n",
       "      <td>Wrestling</td>\n",
       "      <td>Wrestling Men's Lightweight, Greco-Roman</td>\n",
       "      <td>0</td>\n",
       "      <td>China</td>\n",
       "      <td>35.1753</td>\n",
       "      <td>99.3877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1464</td>\n",
       "      <td>Ai Yanhan</td>\n",
       "      <td>F</td>\n",
       "      <td>14.0</td>\n",
       "      <td>168.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CHN</td>\n",
       "      <td>2016 Summer</td>\n",
       "      <td>2016</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>Swimming</td>\n",
       "      <td>Swimming Women's 200 metres Freestyle</td>\n",
       "      <td>0</td>\n",
       "      <td>China</td>\n",
       "      <td>35.1753</td>\n",
       "      <td>99.3877</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     ID           Name Sex   Age  Height  Weight   Team  NOC        Games  \\\n",
       "0     1      A Dijiang   M  24.0   180.0    80.0  China  CHN  1992 Summer   \n",
       "1     2       A Lamusi   M  23.0   170.0    60.0  China  CHN  2012 Summer   \n",
       "2   602  Abudoureheman   M  22.0   182.0    75.0  China  CHN  2000 Summer   \n",
       "3  1463      Ai Linuer   M  25.0   160.0    62.0  China  CHN  2004 Summer   \n",
       "4  1464      Ai Yanhan   F  14.0   168.0    54.0  China  CHN  2016 Summer   \n",
       "\n",
       "   Year  Season            City       Sport  \\\n",
       "0  1992  Summer       Barcelona  Basketball   \n",
       "1  2012  Summer          London        Judo   \n",
       "2  2000  Summer          Sydney      Boxing   \n",
       "3  2004  Summer          Athina   Wrestling   \n",
       "4  2016  Summer  Rio de Janeiro    Swimming   \n",
       "\n",
       "                                      Event Medal Country      Lat      Lng  \n",
       "0               Basketball Men's Basketball     0   China  35.1753  99.3877  \n",
       "1              Judo Men's Extra-Lightweight     0   China  35.1753  99.3877  \n",
       "2                 Boxing Men's Middleweight     0   China  35.1753  99.3877  \n",
       "3  Wrestling Men's Lightweight, Greco-Roman     0   China  35.1753  99.3877  \n",
       "4     Swimming Women's 200 metres Freestyle     0   China  35.1753  99.3877  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "athlete_noc_latlng_pd = athlete_noc_latlng_pd.reset_index()\n",
    "athlete_noc_latlng_pd.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "athlete_noc_latlng_pd.to_csv('../Project2/data/athlete_noc.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "24.0"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "athlete_noc_latlng_pd.iloc[0,3]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "olympics_list = []\n",
    "# define a placeholder for saved variables\n",
    "olympics_dict = {}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in range(len(athlete_noc_latlng_pd)):\n",
    "    olympics_dict[\"id\"] = athlete_noc_latlng_pd.iloc[i,0]\n",
    "    olympics_dict[\"name\"] = athlete_noc_latlng_pd.iloc[i,1]\n",
    "    olympics_dict[\"sex\"] = athlete_noc_latlng_pd.iloc[i,2]\n",
    "    olympics_dict[\"age\"] = athlete_noc_latlng_pd.iloc[i,3]\n",
    "    olympics_dict[\"height\"] = athlete_noc_latlng_pd.iloc[i,4]\n",
    "    olympics_dict[\"weight\"] = athlete_noc_latlng_pd.iloc[i,5]\n",
    "    olympics_dict[\"team\"] = athlete_noc_latlng_pd.iloc[i,6]\n",
    "    olympics_dict[\"noc\"] = athlete_noc_latlng_pd.iloc[i,7]\n",
    "    olympics_dict[\"games\"] = athlete_noc_latlng_pd.iloc[i,8]\n",
    "    olympics_dict[\"year\"] = athlete_noc_latlng_pd.iloc[i,9]\n",
    "    olympics_dict[\"season\"] = athlete_noc_latlng_pd.iloc[i,10]\n",
    "    olympics_dict[\"city\"] = athlete_noc_latlng_pd.iloc[i,11]\n",
    "    olympics_dict[\"sport\"] = athlete_noc_latlng_pd.iloc[i,12]\n",
    "    olympics_dict[\"event\"] = athlete_noc_latlng_pd.iloc[i,13]\n",
    "    olympics_dict[\"medal\"] = athlete_noc_latlng_pd.iloc[i,14]\n",
    "    olympics_dict[\"country\"] = athlete_noc_latlng_pd.iloc[i,15]\n",
    "    olympics_dict[\"lat\"] = athlete_noc_latlng_pd.iloc[i,16]\n",
    "    olympics_dict[\"lng\"] = athlete_noc_latlng_pd.iloc[i,17]\n",
    "    olympics_list.append(olympics_dict)\n",
    "    olympics_dict = {}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "IOPub data rate exceeded.\n",
      "The notebook server will temporarily stop sending output\n",
      "to the client in order to avoid crashing it.\n",
      "To change this limit, set the config variable\n",
      "`--NotebookApp.iopub_data_rate_limit`.\n",
      "\n",
      "Current values:\n",
      "NotebookApp.iopub_data_rate_limit=1000000.0 (bytes/sec)\n",
      "NotebookApp.rate_limit_window=3.0 (secs)\n",
      "\n"
     ]
    }
   ],
   "source": [
    "print(olympics_list)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "271116"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(olympics_list)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'id': 1,\n",
       "  'name': 'A Dijiang',\n",
       "  'sex': 'M',\n",
       "  'age': 24.0,\n",
       "  'height': 180.0,\n",
       "  'weight': 80.0,\n",
       "  'team': 'China',\n",
       "  'noc': 'CHN',\n",
       "  'games': '1992 Summer',\n",
       "  'year': 1992,\n",
       "  'season': 'Summer',\n",
       "  'city': 'Barcelona',\n",
       "  'sport': 'Basketball',\n",
       "  'event': \"Basketball Men's Basketball\",\n",
       "  'medal': 0,\n",
       "  'country': 'China',\n",
       "  'lat': 35.1753,\n",
       "  'lng': 99.3877},\n",
       " {'id': 2,\n",
       "  'name': 'A Lamusi',\n",
       "  'sex': 'M',\n",
       "  'age': 23.0,\n",
       "  'height': 170.0,\n",
       "  'weight': 60.0,\n",
       "  'team': 'China',\n",
       "  'noc': 'CHN',\n",
       "  'games': '2012 Summer',\n",
       "  'year': 2012,\n",
       "  'season': 'Summer',\n",
       "  'city': 'London',\n",
       "  'sport': 'Judo',\n",
       "  'event': \"Judo Men's Extra-Lightweight\",\n",
       "  'medal': 0,\n",
       "  'country': 'China',\n",
       "  'lat': 35.1753,\n",
       "  'lng': 99.3877},\n",
       " {'id': 602,\n",
       "  'name': 'Abudoureheman',\n",
       "  'sex': 'M',\n",
       "  'age': 22.0,\n",
       "  'height': 182.0,\n",
       "  'weight': 75.0,\n",
       "  'team': 'China',\n",
       "  'noc': 'CHN',\n",
       "  'games': '2000 Summer',\n",
       "  'year': 2000,\n",
       "  'season': 'Summer',\n",
       "  'city': 'Sydney',\n",
       "  'sport': 'Boxing',\n",
       "  'event': \"Boxing Men's Middleweight\",\n",
       "  'medal': 0,\n",
       "  'country': 'China',\n",
       "  'lat': 35.1753,\n",
       "  'lng': 99.3877},\n",
       " {'id': 1463,\n",
       "  'name': 'Ai Linuer',\n",
       "  'sex': 'M',\n",
       "  'age': 25.0,\n",
       "  'height': 160.0,\n",
       "  'weight': 62.0,\n",
       "  'team': 'China',\n",
       "  'noc': 'CHN',\n",
       "  'games': '2004 Summer',\n",
       "  'year': 2004,\n",
       "  'season': 'Summer',\n",
       "  'city': 'Athina',\n",
       "  'sport': 'Wrestling',\n",
       "  'event': \"Wrestling Men's Lightweight, Greco-Roman\",\n",
       "  'medal': 0,\n",
       "  'country': 'China',\n",
       "  'lat': 35.1753,\n",
       "  'lng': 99.3877},\n",
       " {'id': 1464,\n",
       "  'name': 'Ai Yanhan',\n",
       "  'sex': 'F',\n",
       "  'age': 14.0,\n",
       "  'height': 168.0,\n",
       "  'weight': 54.0,\n",
       "  'team': 'China',\n",
       "  'noc': 'CHN',\n",
       "  'games': '2016 Summer',\n",
       "  'year': 2016,\n",
       "  'season': 'Summer',\n",
       "  'city': 'Rio de Janeiro',\n",
       "  'sport': 'Swimming',\n",
       "  'event': \"Swimming Women's 200 metres Freestyle\",\n",
       "  'medal': 0,\n",
       "  'country': 'China',\n",
       "  'lat': 35.1753,\n",
       "  'lng': 99.3877},\n",
       " {'id': 1464,\n",
       "  'name': 'Ai Yanhan',\n",
       "  'sex': 'F',\n",
       "  'age': 14.0,\n",
       "  'height': 168.0,\n",
       "  'weight': 54.0,\n",
       "  'team': 'China',\n",
       "  'noc': 'CHN',\n",
       "  'games': '2016 Summer',\n",
       "  'year': 2016,\n",
       "  'season': 'Summer',\n",
       "  'city': 'Rio de Janeiro',\n",
       "  'sport': 'Swimming',\n",
       "  'event': \"Swimming Women's 4 x 200 metres Freestyle Relay\",\n",
       "  'medal': 0,\n",
       "  'country': 'China',\n",
       "  'lat': 35.1753,\n",
       "  'lng': 99.3877},\n",
       " {'id': 3605,\n",
       "  'name': 'An Weijiang',\n",
       "  'sex': 'M',\n",
       "  'age': 22.0,\n",
       "  'height': 178.0,\n",
       "  'weight': 72.0,\n",
       "  'team': 'China',\n",
       "  'noc': 'CHN',\n",
       "  'games': '2006 Winter',\n",
       "  'year': 2006,\n",
       "  'season': 'Winter',\n",
       "  'city': 'Torino',\n",
       "  'sport': 'Speed Skating',\n",
       "  'event': \"Speed Skating Men's 500 metres\",\n",
       "  'medal': 0,\n",
       "  'country': 'China',\n",
       "  'lat': 35.1753,\n",
       "  'lng': 99.3877},\n",
       " {'id': 3605,\n",
       "  'name': 'An Weijiang',\n",
       "  'sex': 'M',\n",
       "  'age': 22.0,\n",
       "  'height': 178.0,\n",
       "  'weight': 72.0,\n",
       "  'team': 'China',\n",
       "  'noc': 'CHN',\n",
       "  'games': '2006 Winter',\n",
       "  'year': 2006,\n",
       "  'season': 'Winter',\n",
       "  'city': 'Torino',\n",
       "  'sport': 'Speed Skating',\n",
       "  'event': \"Speed Skating Men's 1,000 metres\",\n",
       "  'medal': 0,\n",
       "  'country': 'China',\n",
       "  'lat': 35.1753,\n",
       "  'lng': 99.3877},\n",
       " {'id': 3610,\n",
       "  'name': 'An Yulong',\n",
       "  'sex': 'M',\n",
       "  'age': 19.0,\n",
       "  'height': 173.0,\n",
       "  'weight': 70.0,\n",
       "  'team': 'China',\n",
       "  'noc': 'CHN',\n",
       "  'games': '1998 Winter',\n",
       "  'year': 1998,\n",
       "  'season': 'Winter',\n",
       "  'city': 'Nagano',\n",
       "  'sport': 'Short Track Speed Skating',\n",
       "  'event': \"Short Track Speed Skating Men's 500 metres\",\n",
       "  'medal': 'Silver',\n",
       "  'country': 'China',\n",
       "  'lat': 35.1753,\n",
       "  'lng': 99.3877},\n",
       " {'id': 3610,\n",
       "  'name': 'An Yulong',\n",
       "  'sex': 'M',\n",
       "  'age': 19.0,\n",
       "  'height': 173.0,\n",
       "  'weight': 70.0,\n",
       "  'team': 'China',\n",
       "  'noc': 'CHN',\n",
       "  'games': '1998 Winter',\n",
       "  'year': 1998,\n",
       "  'season': 'Winter',\n",
       "  'city': 'Nagano',\n",
       "  'sport': 'Short Track Speed Skating',\n",
       "  'event': \"Short Track Speed Skating Men's 1,000 metres\",\n",
       "  'medal': 0,\n",
       "  'country': 'China',\n",
       "  'lat': 35.1753,\n",
       "  'lng': 99.3877}]"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "olympics_list[0:10]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "return olympics_list"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
