Basic_Analysis.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Load Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "oo = pd.read_csv(\"D:/my_workspace/pythons/data/olympics.csv\", encoding='ISO-8859-1')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Basic Analysis\n",
    "- Exercise 1 In which events did Jesse Owens win a medal?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {
    "scrolled": true
   },
   "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>City</th>\n",
       "      <th>Year</th>\n",
       "      <th>Sport</th>\n",
       "      <th>Discipline</th>\n",
       "      <th>Event</th>\n",
       "      <th>Athlete</th>\n",
       "      <th>Gender</th>\n",
       "      <th>Country_Code</th>\n",
       "      <th>Country</th>\n",
       "      <th>Event_gender</th>\n",
       "      <th>Medal</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [City, Year, Sport, Discipline, Event, Athlete, Gender, Country_Code, Country, Event_gender, Medal]\n",
       "Index: []"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "oo[oo.Athlete.str.contains('Owens') == True]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "- Exercise 2 :  Which country has won the most men's gold medals in singles badminton over the years? Sort the results alphabetically by the players' names."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Indonesia       8\n",
       "Korea, South    6\n",
       "China           4\n",
       "Denmark         1\n",
       "Name: Country, dtype: int64"
      ]
     },
     "execution_count": 87,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mbg = oo[(oo.Sport == 'Badminton') & (oo.Medal == 'Gold') & (oo.Gender == 'Men')]\n",
    "mbg.Country.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "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>Athlete</th>\n",
       "      <th>Gender</th>\n",
       "      <th>Country</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>6254</th>\n",
       "      <td>BUDI KUSUMA, Alan</td>\n",
       "      <td>Men</td>\n",
       "      <td>Indonesia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9922</th>\n",
       "      <td>GUNAWAN, Tony</td>\n",
       "      <td>Men</td>\n",
       "      <td>Indonesia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11949</th>\n",
       "      <td>HA, Tae-Kwon</td>\n",
       "      <td>Men</td>\n",
       "      <td>Korea, South</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11943</th>\n",
       "      <td>HIDAYAT, Taufik</td>\n",
       "      <td>Men</td>\n",
       "      <td>Indonesia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7990</th>\n",
       "      <td>HOYER-LARSEN, Poul Erik</td>\n",
       "      <td>Men</td>\n",
       "      <td>Denmark</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9931</th>\n",
       "      <td>JI, Xinpeng</td>\n",
       "      <td>Men</td>\n",
       "      <td>China</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13957</th>\n",
       "      <td>KIDO, Markis</td>\n",
       "      <td>Men</td>\n",
       "      <td>Indonesia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11955</th>\n",
       "      <td>KIM, Dong Moon</td>\n",
       "      <td>Men</td>\n",
       "      <td>Korea, South</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7999</th>\n",
       "      <td>KIM, Dong Moon</td>\n",
       "      <td>Men</td>\n",
       "      <td>Korea, South</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6258</th>\n",
       "      <td>KIM, Moon-Soo</td>\n",
       "      <td>Men</td>\n",
       "      <td>Korea, South</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13945</th>\n",
       "      <td>LEE, Yongdae</td>\n",
       "      <td>Men</td>\n",
       "      <td>Korea, South</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13960</th>\n",
       "      <td>LIN, Dan</td>\n",
       "      <td>Men</td>\n",
       "      <td>China</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7994</th>\n",
       "      <td>MAINAKY, Rexy Ronald</td>\n",
       "      <td>Men</td>\n",
       "      <td>Indonesia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6263</th>\n",
       "      <td>PARK, Joo-Bong</td>\n",
       "      <td>Men</td>\n",
       "      <td>Korea, South</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13939</th>\n",
       "      <td>SETIAWAN, Hendra</td>\n",
       "      <td>Men</td>\n",
       "      <td>Indonesia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8001</th>\n",
       "      <td>SUBAGJA, Ricky Achmad</td>\n",
       "      <td>Men</td>\n",
       "      <td>Indonesia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9929</th>\n",
       "      <td>WIJAYA, Candra</td>\n",
       "      <td>Men</td>\n",
       "      <td>Indonesia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9938</th>\n",
       "      <td>ZHANG, Jun</td>\n",
       "      <td>Men</td>\n",
       "      <td>China</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11934</th>\n",
       "      <td>ZHANG, Jun</td>\n",
       "      <td>Men</td>\n",
       "      <td>China</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                       Athlete Gender       Country\n",
       "6254         BUDI KUSUMA, Alan    Men     Indonesia\n",
       "9922             GUNAWAN, Tony    Men     Indonesia\n",
       "11949             HA, Tae-Kwon    Men  Korea, South\n",
       "11943          HIDAYAT, Taufik    Men     Indonesia\n",
       "7990   HOYER-LARSEN, Poul Erik    Men       Denmark\n",
       "9931               JI, Xinpeng    Men         China\n",
       "13957             KIDO, Markis    Men     Indonesia\n",
       "11955           KIM, Dong Moon    Men  Korea, South\n",
       "7999            KIM, Dong Moon    Men  Korea, South\n",
       "6258             KIM, Moon-Soo    Men  Korea, South\n",
       "13945             LEE, Yongdae    Men  Korea, South\n",
       "13960                 LIN, Dan    Men         China\n",
       "7994      MAINAKY, Rexy Ronald    Men     Indonesia\n",
       "6263            PARK, Joo-Bong    Men  Korea, South\n",
       "13939         SETIAWAN, Hendra    Men     Indonesia\n",
       "8001     SUBAGJA, Ricky Achmad    Men     Indonesia\n",
       "9929            WIJAYA, Candra    Men     Indonesia\n",
       "9938                ZHANG, Jun    Men         China\n",
       "11934               ZHANG, Jun    Men         China"
      ]
     },
     "execution_count": 86,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "result = mbg.sort_values(by=['Athlete'])\n",
    "result[['Athlete', 'Gender', 'Country']]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "- Exercise 3 :  Which three countries have won the most medals in recent years, that's from 1984 to 2008?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 103,
   "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>City</th>\n",
       "      <th>Year</th>\n",
       "      <th>Sport</th>\n",
       "      <th>Discipline</th>\n",
       "      <th>Event</th>\n",
       "      <th>Athlete</th>\n",
       "      <th>Gender</th>\n",
       "      <th>Country_Code</th>\n",
       "      <th>Country</th>\n",
       "      <th>Event_gender</th>\n",
       "      <th>Medal</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2809</th>\n",
       "      <td>Los Angeles</td>\n",
       "      <td>1984.0</td>\n",
       "      <td>Aquatics</td>\n",
       "      <td>Diving</td>\n",
       "      <td>3m springboard</td>\n",
       "      <td>MCCORMICK, Kelly Anne</td>\n",
       "      <td>Women</td>\n",
       "      <td>USA</td>\n",
       "      <td>United States</td>\n",
       "      <td>W</td>\n",
       "      <td>Silver</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2810</th>\n",
       "      <td>Los Angeles</td>\n",
       "      <td>1984.0</td>\n",
       "      <td>Aquatics</td>\n",
       "      <td>Diving</td>\n",
       "      <td>10m platform</td>\n",
       "      <td>KIMBALL, Bruce D.</td>\n",
       "      <td>Men</td>\n",
       "      <td>USA</td>\n",
       "      <td>United States</td>\n",
       "      <td>M</td>\n",
       "      <td>Silver</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2811</th>\n",
       "      <td>Los Angeles</td>\n",
       "      <td>1984.0</td>\n",
       "      <td>Aquatics</td>\n",
       "      <td>Diving</td>\n",
       "      <td>3m springboard</td>\n",
       "      <td>MERRIOTT, Ronald Marshall</td>\n",
       "      <td>Men</td>\n",
       "      <td>USA</td>\n",
       "      <td>United States</td>\n",
       "      <td>M</td>\n",
       "      <td>Bronze</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2812</th>\n",
       "      <td>Los Angeles</td>\n",
       "      <td>1984.0</td>\n",
       "      <td>Aquatics</td>\n",
       "      <td>Diving</td>\n",
       "      <td>3m springboard</td>\n",
       "      <td>SEUFERT, Christina</td>\n",
       "      <td>Women</td>\n",
       "      <td>USA</td>\n",
       "      <td>United States</td>\n",
       "      <td>W</td>\n",
       "      <td>Bronze</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2813</th>\n",
       "      <td>Los Angeles</td>\n",
       "      <td>1984.0</td>\n",
       "      <td>Aquatics</td>\n",
       "      <td>Diving</td>\n",
       "      <td>3m springboard</td>\n",
       "      <td>TAN, Liang-De</td>\n",
       "      <td>Men</td>\n",
       "      <td>CHN</td>\n",
       "      <td>China</td>\n",
       "      <td>M</td>\n",
       "      <td>Silver</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             City    Year     Sport Discipline           Event  \\\n",
       "2809  Los Angeles  1984.0  Aquatics     Diving  3m springboard   \n",
       "2810  Los Angeles  1984.0  Aquatics     Diving    10m platform   \n",
       "2811  Los Angeles  1984.0  Aquatics     Diving  3m springboard   \n",
       "2812  Los Angeles  1984.0  Aquatics     Diving  3m springboard   \n",
       "2813  Los Angeles  1984.0  Aquatics     Diving  3m springboard   \n",
       "\n",
       "                        Athlete Gender Country_Code        Country  \\\n",
       "2809      MCCORMICK, Kelly Anne  Women          USA  United States   \n",
       "2810          KIMBALL, Bruce D.    Men          USA  United States   \n",
       "2811  MERRIOTT, Ronald Marshall    Men          USA  United States   \n",
       "2812         SEUFERT, Christina  Women          USA  United States   \n",
       "2813              TAN, Liang-De    Men          CHN          China   \n",
       "\n",
       "     Event_gender   Medal  \n",
       "2809            W  Silver  \n",
       "2810            M  Silver  \n",
       "2811            M  Bronze  \n",
       "2812            W  Bronze  \n",
       "2813            M  Silver  "
      ]
     },
     "execution_count": 103,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rec = oo[oo.Year >= 1984]\n",
    "rec.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 96,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "United States    1837\n",
       "Australia         762\n",
       "Germany           691\n",
       "Name: Country, dtype: int64"
      ]
     },
     "execution_count": 96,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rec.Country.value_counts().head(3)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "- Exercise 4:  Display the male gold medal winners of the 100-meters track and field sprint event over the years. List the results starting with the most recent first and show the Olympic city, edition, athlete and the country they represent."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 122,
   "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>City</th>\n",
       "      <th>Year</th>\n",
       "      <th>Athlete</th>\n",
       "      <th>Country</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>13839</th>\n",
       "      <td>Beijing</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>BOLT, Usain</td>\n",
       "      <td>Jamaica</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11901</th>\n",
       "      <td>Athens</td>\n",
       "      <td>2004.0</td>\n",
       "      <td>GATLIN, Justin</td>\n",
       "      <td>United States</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9850</th>\n",
       "      <td>Sydney</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>GREENE, Maurice</td>\n",
       "      <td>United States</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7881</th>\n",
       "      <td>Atlanta</td>\n",
       "      <td>1996.0</td>\n",
       "      <td>BAILEY, Donovan</td>\n",
       "      <td>Canada</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6198</th>\n",
       "      <td>Barcelona</td>\n",
       "      <td>1992.0</td>\n",
       "      <td>CHRISTIE, Linford</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4587</th>\n",
       "      <td>Seoul</td>\n",
       "      <td>1988.0</td>\n",
       "      <td>LEWIS, Carl</td>\n",
       "      <td>United States</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3052</th>\n",
       "      <td>Los Angeles</td>\n",
       "      <td>1984.0</td>\n",
       "      <td>LEWIS, Carl</td>\n",
       "      <td>United States</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1657</th>\n",
       "      <td>Moscow</td>\n",
       "      <td>1980.0</td>\n",
       "      <td>WELLS, Allan</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>308</th>\n",
       "      <td>Montreal</td>\n",
       "      <td>1976.0</td>\n",
       "      <td>CRAWFORD, Hasely</td>\n",
       "      <td>Trinidad and Tobago</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              City    Year            Athlete              Country\n",
       "13839      Beijing  2008.0        BOLT, Usain              Jamaica\n",
       "11901       Athens  2004.0     GATLIN, Justin        United States\n",
       "9850        Sydney  2000.0    GREENE, Maurice        United States\n",
       "7881       Atlanta  1996.0    BAILEY, Donovan               Canada\n",
       "6198     Barcelona  1992.0  CHRISTIE, Linford       United Kingdom\n",
       "4587         Seoul  1988.0        LEWIS, Carl        United States\n",
       "3052   Los Angeles  1984.0        LEWIS, Carl        United States\n",
       "1657        Moscow  1980.0       WELLS, Allan       United Kingdom\n",
       "308       Montreal  1976.0   CRAWFORD, Hasely  Trinidad and Tobago"
      ]
     },
     "execution_count": 122,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mgs = oo[ (oo.Gender == 'Men') & (oo.Medal == 'Gold') & (oo.Event == '100m')]\n",
    "sorted_mgs= mgs.sort_values(by=['Year'], ascending=False)\n",
    "sorted_mgs[['City', 'Year', 'Athlete', 'Country']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}