oscar.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Academy Award for Best Actor"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Setup"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "from requests import get\n",
    "from bs4 import BeautifulSoup\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "from io import StringIO\n",
    "import re"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Request and parse HTML"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "200\n"
     ]
    }
   ],
   "source": [
    "url = 'https://en.wikipedia.org/wiki/Academy_Award_for_Best_Actor'\n",
    "\n",
    "r = get(url)\n",
    "print(r.status_code)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "soup = BeautifulSoup(r.content, 'html.parser')\n",
    "\n",
    "table = soup.find_all('table', class_='wikitable sortable')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## HTML to Dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Tables: 11\n",
      "Tables type: <class 'pandas.core.frame.DataFrame'>\n"
     ]
    },
    {
     "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>Year</th>\n",
       "      <th>Actor</th>\n",
       "      <th>Role(s)</th>\n",
       "      <th>Film</th>\n",
       "      <th>Ref.</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1927/28 (1st)</td>\n",
       "      <td>Emil Jannings ‡[A]</td>\n",
       "      <td>Grand Duke Sergius Alexander</td>\n",
       "      <td>The Last Command</td>\n",
       "      <td>[7]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1927/28 (1st)</td>\n",
       "      <td>Emil Jannings ‡[A]</td>\n",
       "      <td>August Schilling</td>\n",
       "      <td>The Way of All Flesh</td>\n",
       "      <td>[7]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1927/28 (1st)</td>\n",
       "      <td>Richard Barthelmess</td>\n",
       "      <td>Nickie Elkins</td>\n",
       "      <td>The Noose</td>\n",
       "      <td>[7]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1927/28 (1st)</td>\n",
       "      <td>Richard Barthelmess</td>\n",
       "      <td>Patent Leather Kid</td>\n",
       "      <td>The Patent Leather Kid</td>\n",
       "      <td>[7]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1927/28 (1st)</td>\n",
       "      <td>Charlie Chaplin[B]</td>\n",
       "      <td>The Tramp</td>\n",
       "      <td>The Circus</td>\n",
       "      <td>[8]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Year                Actor                       Role(s)  \\\n",
       "0  1927/28 (1st)   Emil Jannings ‡[A]  Grand Duke Sergius Alexander   \n",
       "1  1927/28 (1st)   Emil Jannings ‡[A]              August Schilling   \n",
       "2  1927/28 (1st)  Richard Barthelmess                 Nickie Elkins   \n",
       "3  1927/28 (1st)  Richard Barthelmess            Patent Leather Kid   \n",
       "4  1927/28 (1st)   Charlie Chaplin[B]                     The Tramp   \n",
       "\n",
       "                     Film Ref.  \n",
       "0        The Last Command  [7]  \n",
       "1    The Way of All Flesh  [7]  \n",
       "2               The Noose  [7]  \n",
       "3  The Patent Leather Kid  [7]  \n",
       "4              The Circus  [8]  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_html(StringIO(str(table)))\n",
    "print(f'Tables: {len(df)}')\n",
    "print(f'Tables type: {type(df[0])}')\n",
    "df[0].head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Year', 'Actor', 'Role(s)', 'Film'], dtype='object')"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Drop 'Ref.' column\n",
    "for i in range(len(df)):\n",
    "    df[i] = df[i].drop(columns='Ref.')\n",
    "\n",
    "df[0].columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Year</th>\n",
       "      <th>Actor</th>\n",
       "      <th>Role(s)</th>\n",
       "      <th>Film</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1927/28 (1st)</td>\n",
       "      <td>Emil Jannings ‡[A]</td>\n",
       "      <td>Grand Duke Sergius Alexander</td>\n",
       "      <td>The Last Command</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1927/28 (1st)</td>\n",
       "      <td>Emil Jannings ‡[A]</td>\n",
       "      <td>August Schilling</td>\n",
       "      <td>The Way of All Flesh</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1928/29 (2nd) [note 1]</td>\n",
       "      <td>Warner Baxter ‡</td>\n",
       "      <td>The Cisco Kid</td>\n",
       "      <td>In Old Arizona</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1929/30 (3rd)</td>\n",
       "      <td>George Arliss ‡[C]</td>\n",
       "      <td>Benjamin Disraeli</td>\n",
       "      <td>Disraeli</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1930/31 (4th)</td>\n",
       "      <td>Lionel Barrymore ‡</td>\n",
       "      <td>Stephen Ashe</td>\n",
       "      <td>A Free Soul</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     Year               Actor                       Role(s)  \\\n",
       "0           1927/28 (1st)  Emil Jannings ‡[A]  Grand Duke Sergius Alexander   \n",
       "1           1927/28 (1st)  Emil Jannings ‡[A]              August Schilling   \n",
       "2  1928/29 (2nd) [note 1]     Warner Baxter ‡                 The Cisco Kid   \n",
       "3           1929/30 (3rd)  George Arliss ‡[C]             Benjamin Disraeli   \n",
       "4           1930/31 (4th)  Lionel Barrymore ‡                  Stephen Ashe   \n",
       "\n",
       "                   Film  \n",
       "0      The Last Command  \n",
       "1  The Way of All Flesh  \n",
       "2        In Old Arizona  \n",
       "3              Disraeli  \n",
       "4           A Free Soul  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "winners = []\n",
    "\n",
    "for table in df:\n",
    "    mask1 = table['Actor'].str.contains('‡|§', regex=True)\n",
    "    mask2 = table['Actor'].str.contains('†') & (table.index.isin([0,5,10,15,20,25,30,35,40,45]))\n",
    "    table.loc[mask1 | (mask2)]\n",
    "    winners.append(table.loc[(mask1) | (mask2)])\n",
    "\n",
    "df = pd.concat(winners, ignore_index=True)\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Cleaning"
   ]
  },
  {
   "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>Year</th>\n",
       "      <th>Actor</th>\n",
       "      <th>Role(s)</th>\n",
       "      <th>Film</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1927/28</td>\n",
       "      <td>Emil Jannings</td>\n",
       "      <td>Grand Duke Sergius Alexander</td>\n",
       "      <td>The Last Command</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1927/28</td>\n",
       "      <td>Emil Jannings</td>\n",
       "      <td>August Schilling</td>\n",
       "      <td>The Way of All Flesh</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1928/29</td>\n",
       "      <td>Warner Baxter</td>\n",
       "      <td>The Cisco Kid</td>\n",
       "      <td>In Old Arizona</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1929/30</td>\n",
       "      <td>George Arliss</td>\n",
       "      <td>Benjamin Disraeli</td>\n",
       "      <td>Disraeli</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1930/31</td>\n",
       "      <td>Lionel Barrymore</td>\n",
       "      <td>Stephen Ashe</td>\n",
       "      <td>A Free Soul</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Year             Actor                       Role(s)  \\\n",
       "0  1927/28     Emil Jannings  Grand Duke Sergius Alexander   \n",
       "1  1927/28     Emil Jannings              August Schilling   \n",
       "2  1928/29     Warner Baxter                 The Cisco Kid   \n",
       "3  1929/30     George Arliss             Benjamin Disraeli   \n",
       "4  1930/31  Lionel Barrymore                  Stephen Ashe   \n",
       "\n",
       "                   Film  \n",
       "0      The Last Command  \n",
       "1  The Way of All Flesh  \n",
       "2        In Old Arizona  \n",
       "3              Disraeli  \n",
       "4           A Free Soul  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "for col in df:\n",
    "    df[col] = df[col].str.replace(r'([\\[\\(].*[\\]\\)])', '', regex=True)\\\n",
    "    .str.replace(r'‡|§|†', '', regex=True).str.strip() # Removes text in square brackets and parenthesis, legend from website and leading/trailing white spaces\n",
    "    \n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>Year</th>\n",
       "      <th>Actor</th>\n",
       "      <th>Role(s)</th>\n",
       "      <th>Film</th>\n",
       "      <th>ActorID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1927/28</td>\n",
       "      <td>Emil Jannings</td>\n",
       "      <td>Grand Duke Sergius Alexander</td>\n",
       "      <td>The Last Command</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1927/28</td>\n",
       "      <td>Emil Jannings</td>\n",
       "      <td>August Schilling</td>\n",
       "      <td>The Way of All Flesh</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1928/29</td>\n",
       "      <td>Warner Baxter</td>\n",
       "      <td>The Cisco Kid</td>\n",
       "      <td>In Old Arizona</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1929/30</td>\n",
       "      <td>George Arliss</td>\n",
       "      <td>Benjamin Disraeli</td>\n",
       "      <td>Disraeli</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1930/31</td>\n",
       "      <td>Lionel Barrymore</td>\n",
       "      <td>Stephen Ashe</td>\n",
       "      <td>A Free Soul</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>2019</td>\n",
       "      <td>Joaquin Phoenix</td>\n",
       "      <td>Arthur Fleck / Joker</td>\n",
       "      <td>Joker</td>\n",
       "      <td>82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>2020/21</td>\n",
       "      <td>Anthony Hopkins</td>\n",
       "      <td>Anthony</td>\n",
       "      <td>The Father</td>\n",
       "      <td>59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>2021</td>\n",
       "      <td>Will Smith</td>\n",
       "      <td>Richard Williams</td>\n",
       "      <td>King Richard</td>\n",
       "      <td>83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>2022</td>\n",
       "      <td>Brendan Fraser</td>\n",
       "      <td>Charlie</td>\n",
       "      <td>The Whale</td>\n",
       "      <td>84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>2023</td>\n",
       "      <td>Cillian Murphy</td>\n",
       "      <td>J. Robert Oppenheimer</td>\n",
       "      <td>Oppenheimer</td>\n",
       "      <td>85</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>98 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Year             Actor                       Role(s)  \\\n",
       "0   1927/28     Emil Jannings  Grand Duke Sergius Alexander   \n",
       "1   1927/28     Emil Jannings              August Schilling   \n",
       "2   1928/29     Warner Baxter                 The Cisco Kid   \n",
       "3   1929/30     George Arliss             Benjamin Disraeli   \n",
       "4   1930/31  Lionel Barrymore                  Stephen Ashe   \n",
       "..      ...               ...                           ...   \n",
       "93     2019   Joaquin Phoenix          Arthur Fleck / Joker   \n",
       "94  2020/21   Anthony Hopkins                       Anthony   \n",
       "95     2021        Will Smith              Richard Williams   \n",
       "96     2022    Brendan Fraser                       Charlie   \n",
       "97     2023    Cillian Murphy         J. Robert Oppenheimer   \n",
       "\n",
       "                    Film  ActorID  \n",
       "0       The Last Command        0  \n",
       "1   The Way of All Flesh        0  \n",
       "2         In Old Arizona        1  \n",
       "3               Disraeli        2  \n",
       "4            A Free Soul        3  \n",
       "..                   ...      ...  \n",
       "93                 Joker       82  \n",
       "94            The Father       59  \n",
       "95          King Richard       83  \n",
       "96             The Whale       84  \n",
       "97           Oppenheimer       85  \n",
       "\n",
       "[98 rows x 5 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "actors = df['Actor'].unique()\n",
    "\n",
    "df['ActorID'] = 0\n",
    "\n",
    "for idx, actor in enumerate(actors):\n",
    "    df.loc[df['Actor'] == actor, 'ActorID'] = idx\n",
    "\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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>Year</th>\n",
       "      <th>ActorID</th>\n",
       "      <th>Actor</th>\n",
       "      <th>Role(s)</th>\n",
       "      <th>Film</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1927/28</td>\n",
       "      <td>0</td>\n",
       "      <td>Emil Jannings</td>\n",
       "      <td>Grand Duke Sergius Alexander</td>\n",
       "      <td>The Last Command</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1927/28</td>\n",
       "      <td>0</td>\n",
       "      <td>Emil Jannings</td>\n",
       "      <td>August Schilling</td>\n",
       "      <td>The Way of All Flesh</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1928/29</td>\n",
       "      <td>1</td>\n",
       "      <td>Warner Baxter</td>\n",
       "      <td>The Cisco Kid</td>\n",
       "      <td>In Old Arizona</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1929/30</td>\n",
       "      <td>2</td>\n",
       "      <td>George Arliss</td>\n",
       "      <td>Benjamin Disraeli</td>\n",
       "      <td>Disraeli</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1930/31</td>\n",
       "      <td>3</td>\n",
       "      <td>Lionel Barrymore</td>\n",
       "      <td>Stephen Ashe</td>\n",
       "      <td>A Free Soul</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Year  ActorID             Actor                       Role(s)  \\\n",
       "0  1927/28        0     Emil Jannings  Grand Duke Sergius Alexander   \n",
       "1  1927/28        0     Emil Jannings              August Schilling   \n",
       "2  1928/29        1     Warner Baxter                 The Cisco Kid   \n",
       "3  1929/30        2     George Arliss             Benjamin Disraeli   \n",
       "4  1930/31        3  Lionel Barrymore                  Stephen Ashe   \n",
       "\n",
       "                   Film  \n",
       "0      The Last Command  \n",
       "1  The Way of All Flesh  \n",
       "2        In Old Arizona  \n",
       "3              Disraeli  \n",
       "4           A Free Soul  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = df.reindex(columns=['Year', 'ActorID', 'Actor', 'Role(s)', 'Film'])\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Grand Duke Sergius Alexander'"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[0, 'Role(s)']"
   ]
  },
  {
   "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>Year</th>\n",
       "      <th>ActorID</th>\n",
       "      <th>Actor</th>\n",
       "      <th>Role(s)</th>\n",
       "      <th>Film</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1927/28</td>\n",
       "      <td>0</td>\n",
       "      <td>Emil Jannings</td>\n",
       "      <td>Grand Duke Sergius Alexander, August Schilling</td>\n",
       "      <td>The Last Command, The Way of All Flesh</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1927/28</td>\n",
       "      <td>0</td>\n",
       "      <td>Emil Jannings</td>\n",
       "      <td>August Schilling</td>\n",
       "      <td>The Way of All Flesh</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Year  ActorID          Actor  \\\n",
       "0  1927/28        0  Emil Jannings   \n",
       "1  1927/28        0  Emil Jannings   \n",
       "\n",
       "                                          Role(s)  \\\n",
       "0  Grand Duke Sergius Alexander, August Schilling   \n",
       "1                                August Schilling   \n",
       "\n",
       "                                     Film  \n",
       "0  The Last Command, The Way of All Flesh  \n",
       "1                    The Way of All Flesh  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[0, 'Role(s)'] = df.loc[0, 'Role(s)'] + ', ' + df.loc[1, 'Role(s)']\n",
    "df.loc[0, 'Film'] = df.loc[0, 'Film'] + ', ' + df.loc[1, 'Film']\n",
    "df.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Year</th>\n",
       "      <th>ActorID</th>\n",
       "      <th>Actor</th>\n",
       "      <th>Role(s)</th>\n",
       "      <th>Film</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1927/28</td>\n",
       "      <td>0</td>\n",
       "      <td>Emil Jannings</td>\n",
       "      <td>Grand Duke Sergius Alexander, August Schilling</td>\n",
       "      <td>The Last Command, The Way of All Flesh</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1928/29</td>\n",
       "      <td>1</td>\n",
       "      <td>Warner Baxter</td>\n",
       "      <td>The Cisco Kid</td>\n",
       "      <td>In Old Arizona</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Year  ActorID          Actor  \\\n",
       "0  1927/28        0  Emil Jannings   \n",
       "2  1928/29        1  Warner Baxter   \n",
       "\n",
       "                                          Role(s)  \\\n",
       "0  Grand Duke Sergius Alexander, August Schilling   \n",
       "2                                   The Cisco Kid   \n",
       "\n",
       "                                     Film  \n",
       "0  The Last Command, The Way of All Flesh  \n",
       "2                          In Old Arizona  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.drop(index=1, inplace=True)\n",
    "df.head(2)"
   ]
  },
  {
   "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>Year</th>\n",
       "      <th>ActorID</th>\n",
       "      <th>Actor</th>\n",
       "      <th>Role(s)</th>\n",
       "      <th>Film</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1927/28</td>\n",
       "      <td>0</td>\n",
       "      <td>Emil Jannings</td>\n",
       "      <td>Grand Duke Sergius Alexander, August Schilling</td>\n",
       "      <td>The Last Command, The Way of All Flesh</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1928/29</td>\n",
       "      <td>1</td>\n",
       "      <td>Warner Baxter</td>\n",
       "      <td>The Cisco Kid</td>\n",
       "      <td>In Old Arizona</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1929/30</td>\n",
       "      <td>2</td>\n",
       "      <td>George Arliss</td>\n",
       "      <td>Benjamin Disraeli</td>\n",
       "      <td>Disraeli</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1930/31</td>\n",
       "      <td>3</td>\n",
       "      <td>Lionel Barrymore</td>\n",
       "      <td>Stephen Ashe</td>\n",
       "      <td>A Free Soul</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1931/32</td>\n",
       "      <td>4</td>\n",
       "      <td>Wallace Beery</td>\n",
       "      <td>Andy \"Champ\" Purcell</td>\n",
       "      <td>The Champ</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Year  ActorID             Actor  \\\n",
       "0  1927/28        0     Emil Jannings   \n",
       "1  1928/29        1     Warner Baxter   \n",
       "2  1929/30        2     George Arliss   \n",
       "3  1930/31        3  Lionel Barrymore   \n",
       "4  1931/32        4     Wallace Beery   \n",
       "\n",
       "                                          Role(s)  \\\n",
       "0  Grand Duke Sergius Alexander, August Schilling   \n",
       "1                                   The Cisco Kid   \n",
       "2                               Benjamin Disraeli   \n",
       "3                                    Stephen Ashe   \n",
       "4                            Andy \"Champ\" Purcell   \n",
       "\n",
       "                                     Film  \n",
       "0  The Last Command, The Way of All Flesh  \n",
       "1                          In Old Arizona  \n",
       "2                                Disraeli  \n",
       "3                             A Free Soul  \n",
       "4                               The Champ  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.reset_index(drop=True, inplace=True)\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Extracting links"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "tables = soup.find_all('table', class_='wikitable sortable')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Gets href from the first <a> whose text is the actor's name\n",
    "def get_link(actor):\n",
    "    for table in tables:\n",
    "        a = table.find('a', string=actor)\n",
    "        if a is not None:\n",
    "            return a['href']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0        /wiki/Emil_Jannings\n",
       "1        /wiki/Warner_Baxter\n",
       "2        /wiki/George_Arliss\n",
       "3     /wiki/Lionel_Barrymore\n",
       "4        /wiki/Wallace_Beery\n",
       "               ...          \n",
       "92     /wiki/Joaquin_Phoenix\n",
       "93     /wiki/Anthony_Hopkins\n",
       "94          /wiki/Will_Smith\n",
       "95      /wiki/Brendan_Fraser\n",
       "96      /wiki/Cillian_Murphy\n",
       "Name: Link, Length: 97, dtype: object"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Link'] = df['Actor'].apply(get_link)\n",
    "df['Link']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "True"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(df['Link'].unique()) == len(df['Actor'].unique())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "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>Year</th>\n",
       "      <th>ActorID</th>\n",
       "      <th>Actor</th>\n",
       "      <th>Role(s)</th>\n",
       "      <th>Film</th>\n",
       "      <th>Link</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1927/28</td>\n",
       "      <td>0</td>\n",
       "      <td>Emil Jannings</td>\n",
       "      <td>Grand Duke Sergius Alexander, August Schilling</td>\n",
       "      <td>The Last Command, The Way of All Flesh</td>\n",
       "      <td>/wiki/Emil_Jannings</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1928/29</td>\n",
       "      <td>1</td>\n",
       "      <td>Warner Baxter</td>\n",
       "      <td>The Cisco Kid</td>\n",
       "      <td>In Old Arizona</td>\n",
       "      <td>/wiki/Warner_Baxter</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1929/30</td>\n",
       "      <td>2</td>\n",
       "      <td>George Arliss</td>\n",
       "      <td>Benjamin Disraeli</td>\n",
       "      <td>Disraeli</td>\n",
       "      <td>/wiki/George_Arliss</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1930/31</td>\n",
       "      <td>3</td>\n",
       "      <td>Lionel Barrymore</td>\n",
       "      <td>Stephen Ashe</td>\n",
       "      <td>A Free Soul</td>\n",
       "      <td>/wiki/Lionel_Barrymore</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1931/32</td>\n",
       "      <td>4</td>\n",
       "      <td>Wallace Beery</td>\n",
       "      <td>Andy \"Champ\" Purcell</td>\n",
       "      <td>The Champ</td>\n",
       "      <td>/wiki/Wallace_Beery</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Year  ActorID             Actor  \\\n",
       "0  1927/28        0     Emil Jannings   \n",
       "1  1928/29        1     Warner Baxter   \n",
       "2  1929/30        2     George Arliss   \n",
       "3  1930/31        3  Lionel Barrymore   \n",
       "4  1931/32        4     Wallace Beery   \n",
       "\n",
       "                                          Role(s)  \\\n",
       "0  Grand Duke Sergius Alexander, August Schilling   \n",
       "1                                   The Cisco Kid   \n",
       "2                               Benjamin Disraeli   \n",
       "3                                    Stephen Ashe   \n",
       "4                            Andy \"Champ\" Purcell   \n",
       "\n",
       "                                     Film                    Link  \n",
       "0  The Last Command, The Way of All Flesh     /wiki/Emil_Jannings  \n",
       "1                          In Old Arizona     /wiki/Warner_Baxter  \n",
       "2                                Disraeli     /wiki/George_Arliss  \n",
       "3                             A Free Soul  /wiki/Lionel_Barrymore  \n",
       "4                               The Champ     /wiki/Wallace_Beery  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Retrieving and treating relevant data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Actor: Emil Jannings.\n",
      "Birthday: 1884-07-23\n",
      "Died: (1950-01-02)\n",
      "Birthplace: Rorschach, Switzerland\n",
      "Deathplace: Strobl, Allied-occupied Austria\n",
      "Spouse: Hanna Ralph​ ​\n",
      "Married in 1919, divorced in 1921.\n",
      "Spouse: Lucie Höflich​ ​\n",
      "Married in 1921, divorced in 1921.\n",
      "Spouse: Gussy Holl ​\n",
      "Married in 1923\n",
      "Number of children: 1\n",
      "------------------------------------------------\n",
      "Actor: Warner Baxter.\n",
      "Birthday: 1889-03-29\n",
      "Died: (1951-05-07)\n",
      "Birthplace: Columbus, Ohio, U.S.\n",
      "Deathplace: Beverly Hills, California, U.S.\n",
      "Spouse: Viola Caldwell​ ​\n",
      "Married in 1911, divorced in 1913.\n",
      "Spouse: Winifred Bryson ​\n",
      "Married in 1918\n",
      "Number of children: 0\n",
      "------------------------------------------------\n",
      "Actor: George Arliss.\n",
      "Birthday: 1868-04-10\n",
      "Died: (1946-02-05)\n",
      "Birthplace: London, England\n",
      "Deathplace: London, England\n",
      "Spouse: Florence Montgomery ​\n",
      "Married in 1899\n",
      "Number of children: 0\n",
      "------------------------------------------------\n",
      "Actor: Lionel Barrymore.\n",
      "Birthday: 1878-04-28\n",
      "Died: (1954-11-15)\n",
      "Birthplace: Philadelphia, Pennsylvania, U.S.\n",
      "Deathplace: Los Angeles, California, U.S.\n",
      "Spouse: Doris Rankin​ ​\n",
      "Married in 1904, divorced in 1922.\n",
      "Spouse: Irene Fenwick​ ​\n",
      "Married in 1923, divorced in 1936.\n",
      "Number of children: 2\n",
      "------------------------------------------------\n",
      "Actor: Wallace Beery.\n",
      "Birthday: 1885-04-01\n",
      "Died: (1949-04-15)\n",
      "Birthplace: Clay County, Missouri, U.S.\n",
      "Deathplace: Beverly Hills, California, U.S.\n",
      "Spouse: Gloria Swanson​ ​\n",
      "Married in 1916, divorced in 1918.\n",
      "Spouse: Rita Gilman​ ​\n",
      "Married in 1924, divorced in 1939.\n",
      "Number of children: 1\n",
      "------------------------------------------------\n",
      "Actor: Fredric March.\n",
      "Birthday: 1897-08-31\n",
      "Died: (1975-04-14)\n",
      "Birthplace: Racine, Wisconsin, U.S.\n",
      "Deathplace: Los Angeles, California, U.S.\n",
      "Spouse: Ellis Baker​ ​\n",
      "Married in 1921, divorced in 1927.\n",
      "Spouse: Florence Eldridge​ ​\n",
      "Married in 1927\n",
      "Number of children: 2\n",
      "------------------------------------------------\n",
      "Actor: Charles Laughton.\n",
      "Birthday: 1899-07-01\n",
      "Died: (1962-12-15)\n",
      "Birthplace: Scarborough, North Riding of Yorkshire, England\n",
      "Deathplace: Hollywood, California, U.S.\n",
      "Spouse: Elsa Lanchester ​\n",
      "Married in 1929\n",
      "Number of children: 0\n",
      "------------------------------------------------\n",
      "Actor: Clark Gable.\n",
      "Birthday: 1901-02-01\n",
      "Died: (1960-11-16)\n",
      "Birthplace: Cadiz, Ohio, U.S.\n",
      "Deathplace: Los Angeles, California, U.S.\n",
      "Spouse: Josephine Dillon​ ​\n",
      "Married in 1924, divorced in 1930.\n",
      "Spouse: Maria Langham​ ​\n",
      "Married in 1931, divorced in 1939.\n",
      "Spouse: Carole Lombard​ ​\n",
      "Married in 1939, divorced in 1942.\n",
      "Spouse: Sylvia Ashley​ ​\n",
      "Married in 1949, divorced in 1952.\n",
      "Spouse: Kay Williams ​\n",
      "Married in 1955\n",
      "Number of children: 2, including Judy Lewis\n",
      "------------------------------------------------\n",
      "Actor: Victor McLaglen.\n",
      "Birthday: 1886-12-10\n",
      "Died: (1959-11-07)\n",
      "Birthplace: Tunbridge Wells, Kent or Stepney, East London, U.K.\n",
      "Deathplace: Newport Beach, California, U.S.\n",
      "Spouse: Enid Lamont​ ​\n",
      "Married in 1919, divorced in 1942.\n",
      "Spouse: Suzanne M. Brueggeman​ ​\n",
      "Married in 1943, divorced in 1948.\n",
      "Spouse: Margaret Pumphrey​ ​\n",
      "Married in 1948\n",
      "Number of children: 3\n",
      "------------------------------------------------\n",
      "Actor: Paul Muni.\n",
      "Birthday: 1895-09-22\n",
      "Died: (1967-08-25)\n",
      "Birthplace: Lemberg, Austro-Hungarian Empire(now Lviv, Ukraine)\n",
      "Deathplace: Montecito, California, U.S.\n",
      "Spouse: Bella Finkel ​\n",
      "Married in 1921\n",
      "Number of children: 0\n",
      "------------------------------------------------\n",
      "Actor: Spencer Tracy.\n",
      "Birthday: 1900-04-05\n",
      "Died: (1967-06-10)\n",
      "Birthplace: Milwaukee, Wisconsin, U.S.\n",
      "Deathplace: Beverly Hills, California, U.S.\n",
      "Spouse: Louise Treadwell​ ​\n",
      "Married in 1923, divorced in 1933.\n",
      "Number of children: 2\n",
      "------------------------------------------------\n",
      "Actor: Robert Donat.\n",
      "Birthday: 1905-03-18\n",
      "Died: (1958-06-09)\n",
      "Birthplace: Withington, Manchester, England\n",
      "Deathplace: London, England\n",
      "Spouse: Ella Annesley​ ​\n",
      "Married in 1929, divorced in 1946.\n",
      "Spouse: Renée Asherson​ ​\n",
      "Married in 1953\n",
      "Number of children: 3\n",
      "------------------------------------------------\n",
      "Actor: James Stewart.\n",
      "Birthday: 1908-05-20\n",
      "Died: (1997-07-02)\n",
      "Birthplace: Indiana, Pennsylvania, U.S.\n",
      "Deathplace: Beverly Hills, California, U.S.\n",
      "Spouse: Gloria Hatrick McLean​ ​\n",
      "Married in 1949, divorced in 1994.\n",
      "Number of children: 4\n",
      "------------------------------------------------\n",
      "Actor: Gary Cooper.\n",
      "Birthday: 1901-05-07\n",
      "Died: (1961-05-13)\n",
      "Birthplace: Helena, Montana, U.S.\n",
      "Deathplace: Los Angeles, California, U.S.\n",
      "Spouse: Veronica Balfe ​\n",
      "Married in 1933\n",
      "Number of children: 1\n",
      "------------------------------------------------\n",
      "Actor: James Cagney.\n",
      "Birthday: 1899-07-17\n",
      "Died: (1986-03-30)\n",
      "Birthplace: New York City, U.S.\n",
      "Deathplace: Stanford, New York, U.S.\n",
      "Spouse: Frances Willard Vernon​ ​\n",
      "Married in 1922\n",
      "Number of children: 2\n",
      "------------------------------------------------\n",
      "Actor: Paul Lukas.\n",
      "Birthday: 1894-05-26\n",
      "Died: (1971-08-15)\n",
      "Birthplace: Budapest, Austria-Hungary\n",
      "Deathplace: Tangier, Morocco\n",
      "Spouse: Gizella \"Daisy\" Benes​ ​\n",
      "Married in 1927, divorced in 1962.\n",
      "Spouse: Annette M. Driesens​ ​\n",
      "Married in 1963\n",
      "Number of children: 0\n",
      "------------------------------------------------\n",
      "Actor: Bing Crosby.\n",
      "Birthday: 1903-05-03\n",
      "Died: (1977-10-14)\n",
      "Birthplace: Tacoma, Washington, U.S.\n",
      "Deathplace: Alcobendas, Spain\n",
      "Spouse: Dixie Lee​ ​\n",
      "Married in 1930, divorced in 1952.\n",
      "Spouse: Kathryn Grant ​\n",
      "Married in 1957\n",
      "Number of children: GaryDennisPhillipLindsay (with Dixie)Harry IIIMaryNathaniel (with Kathryn)\n",
      "------------------------------------------------\n",
      "Actor: Ray Milland.\n",
      "Birthday: 1907-01-03\n",
      "Died: (1986-03-10)\n",
      "Birthplace: Neath, Glamorgan, Wales\n",
      "Deathplace: Torrance, California, U.S.\n",
      "Spouse: Muriel Weber ​\n",
      "Married in 1932\n",
      "Number of children: 2\n",
      "------------------------------------------------\n",
      "Actor: Ronald Colman.\n",
      "Birthday: 1891-02-09\n",
      "Died: (1958-05-19)\n",
      "Birthplace: Richmond, Surrey, England, UK\n",
      "Deathplace: Santa Barbara, California, US\n",
      "Spouse: Thelma Raye​ ​\n",
      "Married in 1920, divorced in 1934.\n",
      "Spouse: Benita Hume ​\n",
      "Married in 1938\n",
      "Number of children: 1\n",
      "------------------------------------------------\n",
      "Actor: Laurence Olivier.\n",
      "Birthday: 1907-05-22\n",
      "Died: (1989-07-11)\n",
      "Birthplace: Dorking, Surrey, England\n",
      "Deathplace: Steyning, West Sussex, England\n",
      "Spouse: Jill Esmond​ ​\n",
      "Married in 1930, divorced in 1940.\n",
      "Spouse: Vivien Leigh​ ​\n",
      "Married in 1940, divorced in 1960.\n",
      "Spouse: Joan Plowright ​\n",
      "Married in 1961\n",
      "Number of children: 4\n",
      "------------------------------------------------\n",
      "Actor: Broderick Crawford.\n",
      "Birthday: 1911-12-09\n",
      "Died: (1986-04-26)\n",
      "Birthplace: Philadelphia, Pennsylvania, U.S.\n",
      "Deathplace: Rancho Mirage, California, U.S.\n",
      "Spouse: Kay Griffith​ ​\n",
      "Married in 1940, divorced in 1957.\n",
      "Spouse: Joan Tabor​ ​\n",
      "Married in 1962, divorced in 1967.\n",
      "Spouse: Mary Alice Moore​ ​\n",
      "Married in 1973\n",
      "Number of children: 2\n",
      "------------------------------------------------\n",
      "Actor: José Ferrer.\n",
      "Birthday: 1912-01-08\n",
      "Died: (1992-01-26)\n",
      "Birthplace: San Juan, Puerto Rico\n",
      "Deathplace: Coral Gables, Florida, U.S.\n",
      "Spouse: Uta Hagen​ ​\n",
      "Married in 1938, divorced in 1948.\n",
      "Spouse: Phyllis Hill​ ​\n",
      "Married in 1948, divorced in 1953.\n",
      "Spouse: Rosemary Clooney​ ​\n",
      "Married in 1953, divorced in 1961.\n",
      "Spouse: ​\n",
      "Married in 1964, divorced in 1967.\n",
      "Spouse: Stella Magee ​\n",
      "Married in 1977\n",
      "Number of children: 6, including Miguel Ferrer\n",
      "------------------------------------------------\n",
      "Actor: Humphrey Bogart.\n",
      "Birthday: 1899-12-25\n",
      "Died: (1957-01-14)\n",
      "Birthplace: New York City, U.S.\n",
      "Deathplace: Los Angeles, California, U.S.\n",
      "Spouse: Helen Menken​ ​\n",
      "Married in 1926, divorced in 1927.\n",
      "Spouse: Mary Philips​ ​\n",
      "Married in 1928, divorced in 1937.\n",
      "Spouse: Mayo Methot​ ​\n",
      "Married in 1938, divorced in 1945.\n",
      "Spouse: Lauren Bacall ​\n",
      "Married in 1945\n",
      "Number of children: 2, including Stephen Humphrey\n",
      "------------------------------------------------\n",
      "Actor: William Holden.\n",
      "Birthday: 1918-04-17\n",
      "Died: (1981-11-12)\n",
      "Birthplace: O'Fallon, Illinois, U.S.\n",
      "Deathplace: Santa Monica, California, U.S.\n",
      "Spouse: Brenda Marshall​ ​\n",
      "Married in 1941, divorced in 1971.\n",
      "Number of children: 4\n",
      "------------------------------------------------\n",
      "Actor: Marlon Brando.\n",
      "Birthday: 1924-04-03\n",
      "Died: (2004-07-01)\n",
      "Birthplace: Omaha, Nebraska, U.S.\n",
      "Deathplace: Los Angeles, California\n",
      "Spouse: Anna Kashfi​ ​\n",
      "Married in 1957, divorced in 1959.\n",
      "Spouse: Movita Castaneda​ ​\n",
      "Married in 1960, divorced in 1968.\n",
      "Spouse: Tarita Teriipaia​ ​\n",
      "Married in 1962, divorced in 1972.\n",
      "Number of children: 11, including Christian and Cheyenne\n",
      "------------------------------------------------\n",
      "Actor: Ernest Borgnine.\n",
      "Birthday: 1917-01-24\n",
      "Died: (2012-07-08)\n",
      "Birthplace: Hamden, Connecticut, U.S.\n",
      "Deathplace: Los Angeles, California, U.S.\n",
      "Spouse: Rhoda Kemins​ ​\n",
      "Married in 1949, divorced in 1958.\n",
      "Spouse: Katy Jurado​ ​\n",
      "Married in 1959, divorced in 1963.\n",
      "Spouse: Ethel Merman​ ​\n",
      "Married in 1964, divorced in 1964.\n",
      "Spouse: Donna Rancourt​ ​\n",
      "Married in 1965, divorced in 1972.\n",
      "Spouse: Tova Traesnaes ​\n",
      "Married in 1973\n",
      "Number of children: 4\n",
      "------------------------------------------------\n",
      "Actor: Yul Brynner.\n",
      "Birthday: 1920-07-11\n",
      "Died: (1985-10-10)\n",
      "Birthplace: Vladivostok, Far Eastern Republic\n",
      "Deathplace: New York City, U.S.\n",
      "Spouse: Virginia Gilmore​ ​\n",
      "Married in 1944, divorced in 1960.\n",
      "Spouse: Doris Kleiner​ ​\n",
      "Married in 1960, divorced in 1967.\n",
      "Spouse: Jacqueline Thion de la Chaume​ ​\n",
      "Married in 1971, divorced in 1981.\n",
      "Spouse: Kathy Lee ​\n",
      "Married in 1983\n",
      "Number of children: 5\n",
      "------------------------------------------------\n",
      "Actor: Alec Guinness.\n",
      "Birthday: 1914-04-02\n",
      "Died: (2000-08-05)\n",
      "Birthplace: Maida Vale, London, England\n",
      "Deathplace: Midhurst, West Sussex, England\n",
      "Spouse: Merula Salaman ​\n",
      "Married in 1938\n",
      "Number of children: Matthew Guinness\n",
      "------------------------------------------------\n",
      "Actor: David Niven.\n",
      "Birthday: 1910-03-01\n",
      "Died: (1983-07-29)\n",
      "Birthplace: Victoria, London, England\n",
      "Deathplace: Château-d'Œx, Switzerland\n",
      "Spouse: Primula Susan Rollo​ ​\n",
      "Married in 1940, divorced in 1946.\n",
      "Spouse: Hjördis Genberg ​\n",
      "Married in 1948\n",
      "Number of children: 4, including David Jr.\n",
      "------------------------------------------------\n",
      "Actor: Charlton Heston.\n",
      "Birthday: 1923-10-04\n",
      "Died: (2008-04-05)\n",
      "Birthplace: Wilmette, Illinois, U.S.\n",
      "Deathplace: Beverly Hills, California, U.S.\n",
      "Spouse: Lydia Clarke ​\n",
      "Married in 1944\n",
      "Number of children: 2, including Fraser Clarke Heston\n",
      "------------------------------------------------\n",
      "Actor: Burt Lancaster.\n",
      "Birthday: 1913-11-02\n",
      "Died: (1994-10-20)\n",
      "Birthplace: New York City, U.S.\n",
      "Deathplace: Los Angeles, U.S.\n",
      "Spouse: June Ernst​ ​\n",
      "Married in 1935, divorced in 1946.\n",
      "Spouse: Norma Anderson​ ​\n",
      "Married in 1946, divorced in 1969.\n",
      "Spouse: Susan Martin​ ​\n",
      "Married in 1990\n",
      "Number of children: 5; including Bill\n",
      "------------------------------------------------\n",
      "Actor: Maximilian Schell.\n",
      "Birthday: 1930-12-08\n",
      "Died: (2014-02-01)\n",
      "Birthplace: Vienna, Austria\n",
      "Deathplace: Innsbruck, Austria\n",
      "Spouse: Natalya Andrejchenko​ ​\n",
      "Married in 1985, divorced in 2005.\n",
      "Spouse: Iva Mihanovic ​\n",
      "Married in 2013\n",
      "Number of children: 1\n",
      "------------------------------------------------\n",
      "Actor: Gregory Peck.\n",
      "Birthday: 1916-04-05\n",
      "Died: (2003-06-12)\n",
      "Birthplace: San Diego, California, U.S.\n",
      "Deathplace: Los Angeles, California, U.S.\n",
      "Spouse: Greta Kukkonen​ ​\n",
      "Married in 1942, divorced in 1955.\n",
      "Spouse: Veronique Passani ​\n",
      "Married in 1955\n",
      "Number of children: 5, including Cecilia Peck\n",
      "------------------------------------------------\n",
      "Actor: Sidney Poitier.\n",
      "Birthday: 1927-02-20\n",
      "Died: (2022-01-06)\n",
      "Birthplace: Miami, Florida, U.S.\n",
      "Deathplace: Beverly Hills, California, U.S.\n",
      "Spouse: Juanita Hardy​ ​\n",
      "Married in 1950, divorced in 1965.\n",
      "Spouse: Joanna Shimkus ​\n",
      "Married in 1976\n",
      "Number of children: 6, including Sydney Tamiia\n",
      "------------------------------------------------\n",
      "Actor: Rex Harrison.\n",
      "Birthday: 1908-03-05\n",
      "Died: (1990-06-02)\n",
      "Birthplace: Huyton, Lancashire, England\n",
      "Deathplace: New York City, U.S.\n",
      "Spouse: Noel Margery Colette-Thomas​ ​\n",
      "Married in 1934, divorced in 1942.\n",
      "Spouse: Lilli Palmer​ ​\n",
      "Married in 1943, divorced in 1957.\n",
      "Spouse: Kay Kendall​ ​\n",
      "Married in 1957, divorced in 1959.\n",
      "Spouse: Rachel Roberts​ ​\n",
      "Married in 1962, divorced in 1971.\n",
      "Spouse: Elizabeth Rees-Williams​ ​\n",
      "Married in 1971, divorced in 1975.\n",
      "Spouse: Mercia Tinker ​\n",
      "Married in 1979\n",
      "Number of children: \n",
      "Noel\n",
      "Carey\n",
      "\n",
      "------------------------------------------------\n",
      "Actor: Lee Marvin.\n",
      "Birthday: 1924-02-19\n",
      "Died: (1987-08-29)\n",
      "Birthplace: New York City, U.S.\n",
      "Deathplace: Tucson, Arizona, U.S.\n",
      "Spouse: Betty Ebeling​ ​\n",
      "Married in 1952, divorced in 1967.\n",
      "Spouse: Pamela Feeley ​\n",
      "Married in 1970\n",
      "Number of children: 4\n",
      "------------------------------------------------\n",
      "Actor: Paul Scofield.\n",
      "Birthday: 1922-01-21\n",
      "Died: (2008-03-19)\n",
      "Birthplace: Birmingham, Warwickshire, England\n",
      "Deathplace: Brighton, East Sussex, England\n",
      "Spouse: Joy Parker ​\n",
      "Married in 1943\n",
      "Number of children: 2\n",
      "------------------------------------------------\n",
      "Actor: Rod Steiger.\n",
      "Birthday: 1925-04-14\n",
      "Died: (2002-07-09)\n",
      "Birthplace: Westhampton, New York, U.S.\n",
      "Deathplace: Los Angeles, California, U.S.\n",
      "Number of children: 0\n",
      "------------------------------------------------\n",
      "Actor: Cliff Robertson.\n",
      "Birthday: 1923-09-09\n",
      "Died: (2011-09-10)\n",
      "Birthplace: San Diego, California, U.S.\n",
      "Deathplace: Stony Brook, New York, U.S.\n",
      "Spouse: Cynthia Stone ​ ​\n",
      "Married in 1957, divorced in 1959.\n",
      "Spouse: Dina Merrill ​ ​\n",
      "Married in 1966, divorced in 1989.\n",
      "Number of children: 2\n",
      "------------------------------------------------\n",
      "Actor: John Wayne.\n",
      "Birthday: 1907-05-26\n",
      "Died: (1979-06-11)\n",
      "Birthplace: Winterset, Iowa, U.S.\n",
      "Deathplace: Los Angeles, California, U.S.\n",
      "Spouse: Josephine Saenz​ ​\n",
      "Married in 1933, divorced in 1945.\n",
      "Spouse: Esperanza Baur​ ​\n",
      "Married in 1946, divorced in 1954.\n",
      "Spouse: Pilar Pallete ​\n",
      "Married in 1954\n",
      "Number of children: 7, including Michael, Patrick, and Ethan\n",
      "------------------------------------------------\n",
      "Actor: George C. Scott.\n",
      "Birthday: 1927-10-18\n",
      "Died: (1999-09-22)\n",
      "Birthplace: Wise, Virginia, U.S.\n",
      "Deathplace: Westlake Village, California, U.S.\n",
      "Spouse: Carolyn Hughes​ ​\n",
      "Married in 1951, divorced in 1955.\n",
      "Spouse: Patricia Reed​ ​\n",
      "Married in 1955, divorced in 1960.\n",
      "Spouse: Colleen Dewhurst​ ​\n",
      "Married in 1960, divorced in 1965.\n",
      "Spouse: ​\n",
      "Married in 1967, divorced in 1972.\n",
      "Spouse: Trish Van Devere​ ​\n",
      "Married in 1972\n",
      "Number of children: 7, including Devon and Campbell Scott\n",
      "------------------------------------------------\n",
      "Actor: Gene Hackman.\n",
      "Birthday: 1930-01-30\n",
      "Died: None\n",
      "Birthplace: San Bernardino, California, U.S.\n",
      "Deathplace: None\n",
      "Spouse: Faye Maltese​ ​\n",
      "Married in 1956, divorced in 1986.\n",
      "Spouse: Betsy Arakawa ​\n",
      "Married in 1991\n",
      "Number of children: 3\n",
      "------------------------------------------------\n",
      "Actor: Jack Lemmon.\n",
      "Birthday: 1925-02-08\n",
      "Died: (2001-06-27)\n",
      "Birthplace: Newton, Massachusetts, U.S.\n",
      "Deathplace: Los Angeles, California, U.S.\n",
      "Spouse: Cynthia Stone​ ​\n",
      "Married in 1950, divorced in 1956.\n",
      "Spouse: Felicia Farr ​\n",
      "Married in 1962\n",
      "Number of children: 2, including Chris Lemmon\n",
      "------------------------------------------------\n",
      "Actor: Art Carney.\n",
      "Birthday: 1918-11-04\n",
      "Died: (2003-11-09)\n",
      "Birthplace: Mount Vernon, New York, U.S.\n",
      "Deathplace: Chester, Connecticut, U.S.\n",
      "Spouse: Jean Myers​ ​\n",
      "Married in 1940, divorced in 1965.\n",
      "Spouse: ​\n",
      "Married in 1980\n",
      "Spouse: Barbara Isaac​ ​\n",
      "Married in 1966, divorced in 1977.\n",
      "Number of children: 3\n",
      "------------------------------------------------\n",
      "Actor: Jack Nicholson.\n",
      "Birthday: 1937-04-22\n",
      "Died: None\n",
      "Birthplace: Neptune City, New Jersey, U.S.\n",
      "Deathplace: None\n",
      "Spouse: Sandra Knight​ ​\n",
      "Married in 1962, divorced in 1968.\n",
      "Number of children: 6, including Lorraine and Ray\n",
      "------------------------------------------------\n",
      "Actor: Peter Finch.\n",
      "Birthday: 1916-09-28\n",
      "Died: (1977-01-14)\n",
      "Birthplace: South Kensington, London, England\n",
      "Deathplace: Beverly Hills, California, U.S.\n",
      "Spouse: Tamara Tchinarova​ ​\n",
      "Married in 1943, divorced in 1959.\n",
      "Spouse: Yolande Turner​ ​\n",
      "Married in 1959, divorced in 1965.\n",
      "Spouse: Eletha Barrett​ ​\n",
      "Married in 1973\n",
      "Number of children: 4; including Charles Finch\n",
      "------------------------------------------------\n",
      "Actor: Richard Dreyfuss.\n",
      "Birthday: 1947-10-29\n",
      "Died: None\n",
      "Birthplace: New York City, U.S.\n",
      "Deathplace: None\n",
      "Spouse: Jeramie Rain​ ​\n",
      "Married in 1983, divorced in 1995.\n",
      "Spouse: Janelle Lacey​ ​\n",
      "Married in 1999, divorced in 2005.\n",
      "Spouse: Svetlana Erokhin ​\n",
      "Married in 2006\n",
      "Number of children: 3, including Emily and Ben\n",
      "------------------------------------------------\n",
      "Actor: Jon Voight.\n",
      "Birthday: 1938-12-29\n",
      "Died: None\n",
      "Birthplace: Yonkers, New York, U.S.\n",
      "Deathplace: None\n",
      "Spouse: Lauri Peters​ ​\n",
      "Married in 1962, divorced in 1967.\n",
      "Spouse: Marcheline Bertrand​ ​\n",
      "Married in 1971, divorced in 1980.\n",
      "Number of children: James HavenAngelina Jolie\n",
      "------------------------------------------------\n",
      "Actor: Dustin Hoffman.\n",
      "Birthday: 1937-08-08\n",
      "Died: None\n",
      "Birthplace: Los Angeles, California, U.S.\n",
      "Deathplace: None\n",
      "Spouse: Anne Byrne​ ​\n",
      "Married in 1969, divorced in 1980.\n",
      "Spouse: Lisa Gottsegen ​\n",
      "Married in 1980\n",
      "Number of children: 6, including Jake\n",
      "------------------------------------------------\n",
      "Actor: Robert De Niro.\n",
      "Birthday: 1943-08-17\n",
      "Died: None\n",
      "Birthplace: New York City, U.S.\n",
      "Deathplace: None\n",
      "Spouse: Diahnne Abbott​ ​\n",
      "Married in 1976, divorced in 1988.\n",
      "Spouse: Grace Hightower​ ​\n",
      "Married in 1997, divorced in 2018.\n",
      "Number of children: 7, including Drena and Raphael\n",
      "------------------------------------------------\n",
      "Actor: Henry Fonda.\n",
      "Birthday: 1905-05-16\n",
      "Died: (1982-08-12)\n",
      "Birthplace: Grand Island, Nebraska, U.S.\n",
      "Deathplace: Los Angeles, California, U.S.\n",
      "Spouse: Margaret Sullavan​ ​\n",
      "Married in 1931, divorced in 1933.\n",
      "Spouse: Frances Ford Seymour​ ​\n",
      "Married in 1936, divorced in 1950.\n",
      "Spouse: Susan Blanchard​ ​\n",
      "Married in 1950, divorced in 1956.\n",
      "Spouse: Afdera Franchetti​ ​\n",
      "Married in 1957, divorced in 1961.\n",
      "Spouse: Shirlee Mae Adams ​\n",
      "Married in 1965\n",
      "Number of children: 3, including Jane and Peter\n",
      "------------------------------------------------\n",
      "Actor: Ben Kingsley.\n",
      "Birthday: 1943-12-31\n",
      "Died: None\n",
      "Birthplace: Snainton, North Riding of Yorkshire, England\n",
      "Deathplace: None\n",
      "Spouse: Angela Morant​ ​\n",
      "Married in 1966, divorced in 1976.\n",
      "Spouse: Alison Sutcliffe​ ​\n",
      "Married in 1978, divorced in 1992.\n",
      "Spouse: Alexandra Christmann​ ​\n",
      "Married in 2003, divorced in 2005.\n",
      "Spouse: Daniela Lavender ​\n",
      "Married in 2007\n",
      "Number of children: 4, including Ferdinand Kingsley\n",
      "------------------------------------------------\n",
      "Actor: Robert Duvall.\n",
      "Birthday: 1931-01-05\n",
      "Died: None\n",
      "Birthplace: San Diego, California, U.S.\n",
      "Deathplace: None\n",
      "Spouse: Barbara Benjamin Marcus​ ​\n",
      "Married in 1964, divorced in 1981.\n",
      "Spouse: Gail Youngs​ ​\n",
      "Married in 1982, divorced in 1986.\n",
      "Spouse: Sharon Brophy​ ​\n",
      "Married in 1991, divorced in 1995.\n",
      "Spouse: Luciana Pedraza ​\n",
      "Married in 2005\n",
      "Number of children: 0\n",
      "------------------------------------------------\n",
      "Actor: F. Murray Abraham.\n",
      "Birthday: 1939-10-24\n",
      "Died: None\n",
      "Birthplace: Pittsburgh, Pennsylvania, U.S.\n",
      "Deathplace: None\n",
      "Spouse: Kate Hannan​ ​\n",
      "Married in 1962, divorced in 2022.\n",
      "Number of children: 2\n",
      "------------------------------------------------\n",
      "Actor: William Hurt.\n",
      "Birthday: 1950-03-20\n",
      "Died: (2022-03-13)\n",
      "Birthplace: Washington, D.C., U.S.\n",
      "Deathplace: Portland, Oregon, U.S.\n",
      "Spouse: Mary Beth Supinger​ ​\n",
      "Married in 1971, divorced in 1982.\n",
      "Spouse: Heidi Henderson​ ​\n",
      "Married in 1989, divorced in 1993.\n",
      "Number of children: 4\n",
      "------------------------------------------------\n",
      "Actor: Paul Newman.\n",
      "Birthday: 1925-01-26\n",
      "Died: (2008-09-26)\n",
      "Birthplace: Shaker Heights, Ohio, U.S.\n",
      "Deathplace: Westport, Connecticut, U.S.\n",
      "Spouse: Jackie Witte​ ​\n",
      "Married in 1949, divorced in 1958.\n",
      "Spouse: Joanne Woodward ​\n",
      "Married in 1958\n",
      "Number of children: 6, including Scott, Nell, and Melissa\n",
      "------------------------------------------------\n",
      "Actor: Michael Douglas.\n",
      "Birthday: 1944-09-25\n",
      "Died: None\n",
      "Birthplace: New Brunswick, New Jersey, U.S.\n",
      "Deathplace: None\n",
      "Spouse: Diandra Luker​ ​\n",
      "Married in 1977, divorced in 2000.\n",
      "Spouse: Catherine Zeta-Jones​ ​\n",
      "Married in 2000\n",
      "Number of children: 3, including Cameron Douglas\n",
      "------------------------------------------------\n",
      "Actor: Daniel Day-Lewis.\n",
      "Birthday: 1957-04-29\n",
      "Died: None\n",
      "Birthplace: London, England\n",
      "Deathplace: None\n",
      "Spouse: Rebecca Miller ​\n",
      "Married in 1996\n",
      "Number of children: 3\n",
      "------------------------------------------------\n",
      "Actor: Jeremy Irons.\n",
      "Birthday: 1948-09-19\n",
      "Died: None\n",
      "Birthplace: Cowes, Isle of Wight, England\n",
      "Deathplace: None\n",
      "Spouse: Julie Hallam​ ​\n",
      "Married in 1969, divorced in 1969.\n",
      "Spouse: Sinéad Cusack ​\n",
      "Married in 1978\n",
      "Number of children: 2, including Max Irons\n",
      "------------------------------------------------\n",
      "Actor: Anthony Hopkins.\n",
      "Birthday: 1937-12-31\n",
      "Died: None\n",
      "Birthplace: Port Talbot, Glamorgan, Wales\n",
      "Deathplace: None\n",
      "Spouse: Petronella Barker​ ​\n",
      "Married in 1966, divorced in 1972.\n",
      "Spouse: Jennifer Lynton​ ​\n",
      "Married in 1973, divorced in 2002.\n",
      "Spouse: Stella Arroyave ​\n",
      "Married in 2003\n",
      "Number of children: 1\n",
      "------------------------------------------------\n",
      "Actor: Al Pacino.\n",
      "Birthday: 1940-04-25\n",
      "Died: None\n",
      "Birthplace: New York City, U.S.\n",
      "Deathplace: None\n",
      "Number of children: 4\n",
      "------------------------------------------------\n",
      "Actor: Tom Hanks.\n",
      "Birthday: 1956-07-09\n",
      "Died: None\n",
      "Birthplace: Concord, California, U.S.\n",
      "Deathplace: None\n",
      "Spouse: Samantha Lewes​ ​\n",
      "Married in 1978, divorced in 1987.\n",
      "Spouse: Rita Wilson ​\n",
      "Married in 1988\n",
      "Number of children: 4, including Colin and Chet\n",
      "------------------------------------------------\n",
      "Actor: Nicolas Cage.\n",
      "Birthday: 1964-01-07\n",
      "Died: None\n",
      "Birthplace: Long Beach, California, U.S.\n",
      "Deathplace: None\n",
      "Spouse: Patricia Arquette​ ​\n",
      "Married in 1995, divorced in 2001.\n",
      "Spouse: Lisa Marie Presley​ ​\n",
      "Married in 2002, divorced in 2004.\n",
      "Spouse: Alice Kim​ ​\n",
      "Married in 2004, divorced in 2016.\n",
      "Spouse: Erika Koike​ ​\n",
      "Married in 2019, divorced in 2019.\n",
      "Spouse: Riko Shibata ​\n",
      "Married in 2021\n",
      "Number of children: 3\n",
      "------------------------------------------------\n",
      "Actor: Geoffrey Rush.\n",
      "Birthday: 1951-07-06\n",
      "Died: None\n",
      "Birthplace: Toowoomba, Queensland, Australia\n",
      "Deathplace: None\n",
      "Spouse: Jane Menelaus ​\n",
      "Married in 1988\n",
      "Number of children: 2\n",
      "------------------------------------------------\n",
      "Actor: Roberto Benigni.\n",
      "Birthday: 1952-10-27\n",
      "Died: None\n",
      "Birthplace: Castiglion Fiorentino, Tuscany, Italy\n",
      "Deathplace: None\n",
      "Spouse: Nicoletta Braschi ​\n",
      "Married in 1991\n",
      "Number of children: 0\n",
      "------------------------------------------------\n",
      "Actor: Kevin Spacey.\n",
      "Birthday: 1959-07-26\n",
      "Died: None\n",
      "Birthplace: South Orange, New Jersey, U.S.\n",
      "Deathplace: None\n",
      "Number of children: 0\n",
      "------------------------------------------------\n",
      "Actor: Russell Crowe.\n",
      "Birthday: 1964-04-07\n",
      "Died: None\n",
      "Birthplace: Wellington, New Zealand\n",
      "Deathplace: None\n",
      "Spouse: Danielle Spencer​ ​\n",
      "Married in 2003, divorced in 2018.\n",
      "Number of children: 2\n",
      "------------------------------------------------\n",
      "Actor: Denzel Washington.\n",
      "Birthday: 1954-12-28\n",
      "Died: None\n",
      "Birthplace: Mount Vernon, New York, U.S.\n",
      "Deathplace: None\n",
      "Spouse: Pauletta Pearson ​\n",
      "Married in 1983\n",
      "Number of children: 4, including John David\n",
      "------------------------------------------------\n",
      "Actor: Adrien Brody.\n",
      "Birthday: 1973-04-14\n",
      "Died: None\n",
      "Birthplace: New York City, U.S.\n",
      "Deathplace: None\n",
      "Number of children: 0\n",
      "------------------------------------------------\n",
      "Actor: Sean Penn.\n",
      "Birthday: 1960-08-17\n",
      "Died: None\n",
      "Birthplace: Santa Monica, California, U.S.\n",
      "Deathplace: None\n",
      "Spouse: Madonna​ ​\n",
      "Married in 1985, divorced in 1989.\n",
      "Spouse: Robin Wright​ ​\n",
      "Married in 1996, divorced in 2010.\n",
      "Spouse: Leila George​ ​\n",
      "Married in 2020, divorced in 2022.\n",
      "Number of children: Dylan PennHopper Penn\n",
      "------------------------------------------------\n",
      "Actor: Jamie Foxx.\n",
      "Birthday: 1967-12-13\n",
      "Died: None\n",
      "Birthplace: Terrell, Texas, U.S.\n",
      "Deathplace: None\n",
      "Number of children: 2, including Corinne\n",
      "------------------------------------------------\n",
      "Actor: Philip Seymour Hoffman.\n",
      "Birthday: 1967-07-23\n",
      "Died: (2014-02-02)\n",
      "Birthplace: Fairport, New York, U.S.\n",
      "Deathplace: New York City, U.S.\n",
      "Number of children: 3, including Cooper\n",
      "------------------------------------------------\n",
      "Actor: Forest Whitaker.\n",
      "Birthday: 1961-07-15\n",
      "Died: None\n",
      "Birthplace: Longview, Texas, U.S.\n",
      "Deathplace: None\n",
      "Spouse: Keisha Nash​ ​\n",
      "Married in 1996, divorced in 2021.\n",
      "Number of children: 3\n",
      "------------------------------------------------\n",
      "Actor: Jeff Bridges.\n",
      "Birthday: 1949-12-04\n",
      "Died: None\n",
      "Birthplace: Los Angeles, California, U.S.\n",
      "Deathplace: None\n",
      "Spouse: Susan Geston ​\n",
      "Married in 1977\n",
      "Number of children: 3\n",
      "------------------------------------------------\n",
      "Actor: Colin Firth.\n",
      "Birthday: 1960-09-10\n",
      "Died: None\n",
      "Birthplace: Grayshott, Hampshire, England\n",
      "Deathplace: None\n",
      "Spouse: Livia Giuggioli​ ​\n",
      "Married in 1997, divorced in 2021.\n",
      "Number of children: 3\n",
      "------------------------------------------------\n",
      "Actor: Jean Dujardin.\n",
      "Birthday: 1972-06-19\n",
      "Died: None\n",
      "Birthplace: Rueil-Malmaison, France\n",
      "Deathplace: None\n",
      "Spouse: Gaëlle Demars ​\n",
      "Married in 2003\n",
      "Spouse: Alexandra Lamy​ ​\n",
      "Married in 2009, divorced in 2014.\n",
      "Spouse: Nathalie Péchalat ​\n",
      "Married in 2018\n",
      "Number of children: 4\n",
      "------------------------------------------------\n",
      "Actor: Matthew McConaughey.\n",
      "Birthday: 1969-11-04\n",
      "Died: None\n",
      "Birthplace: Uvalde, Texas, U.S.\n",
      "Deathplace: None\n",
      "Spouse: Camila Alves ​\n",
      "Married in 2012\n",
      "Number of children: 3\n",
      "------------------------------------------------\n",
      "Actor: Eddie Redmayne.\n",
      "Birthday: 1982-01-06\n",
      "Died: None\n",
      "Birthplace: Westminster, London, England\n",
      "Deathplace: None\n",
      "Spouse: Hannah Bagshawe ​\n",
      "Married in 2014\n",
      "Number of children: 2\n",
      "------------------------------------------------\n",
      "Actor: Leonardo DiCaprio.\n",
      "Birthday: 1974-11-11\n",
      "Died: None\n",
      "Birthplace: Los Angeles, California, U.S.\n",
      "Deathplace: None\n",
      "Number of children: 0\n",
      "------------------------------------------------\n",
      "Actor: Casey Affleck.\n",
      "Birthday: 1975-08-12\n",
      "Died: None\n",
      "Birthplace: Falmouth, Massachusetts, U.S.\n",
      "Deathplace: None\n",
      "Spouse: Summer Phoenix​ ​\n",
      "Married in 2006, divorced in 2017.\n",
      "Number of children: 2\n",
      "------------------------------------------------\n",
      "Actor: Gary Oldman.\n",
      "Birthday: 1958-03-21\n",
      "Died: None\n",
      "Birthplace: London, England\n",
      "Deathplace: None\n",
      "Spouse: Lesley Manville​ ​\n",
      "Married in 1987, divorced in 1990.\n",
      "Spouse: Uma Thurman​ ​\n",
      "Married in 1990, divorced in 1992.\n",
      "Spouse: Donya Fiorentino​ ​\n",
      "Married in 1997, divorced in 2001.\n",
      "Spouse: Alexandra Edenborough​ ​\n",
      "Married in 2008, divorced in 2015.\n",
      "Spouse: Gisele Schmidt ​\n",
      "Married in 2017\n",
      "Number of children: 3\n",
      "------------------------------------------------\n",
      "Actor: Rami Malek.\n",
      "Birthday: 1981-05-12\n",
      "Died: None\n",
      "Birthplace: Torrance, California, U.S.\n",
      "Deathplace: None\n",
      "Number of children: 0\n",
      "------------------------------------------------\n",
      "Actor: Joaquin Phoenix.\n",
      "Birthday: 1974-10-28\n",
      "Died: None\n",
      "Birthplace: San Juan, Puerto Rico\n",
      "Deathplace: None\n",
      "Number of children: 1\n",
      "------------------------------------------------\n",
      "Actor: Will Smith.\n",
      "Birthday: 1968-09-25\n",
      "Died: None\n",
      "Birthplace: Philadelphia, Pennsylvania, U.S.\n",
      "Deathplace: None\n",
      "Spouse: Sheree Zampino​ ​\n",
      "Married in 1992, divorced in 1995.\n",
      "Spouse: Jada Pinkett​ ​\n",
      "Married in 1997, divorced in 2016.\n",
      "Number of children: 3, including Jaden and Willow\n",
      "------------------------------------------------\n",
      "Actor: Brendan Fraser.\n",
      "Birthday: 1968-12-03\n",
      "Died: None\n",
      "Birthplace: Indianapolis, Indiana, U.S.\n",
      "Deathplace: None\n",
      "Spouse: Afton Smith​ ​\n",
      "Married in 1998, divorced in 2009.\n",
      "Number of children: 3\n",
      "------------------------------------------------\n",
      "Actor: Cillian Murphy.\n",
      "Birthday: 1976-05-25\n",
      "Died: None\n",
      "Birthplace: Cork, Ireland\n",
      "Deathplace: None\n",
      "Spouse: Yvonne McGuinness ​\n",
      "Married in 2004\n",
      "Number of children: 2\n",
      "------------------------------------------------\n"
     ]
    }
   ],
   "source": [
    "url = 'https://en.wikipedia.org/'\n",
    "\n",
    "actor_list = []\n",
    "actor_id_list = []\n",
    "bday_list = []\n",
    "death_list = []\n",
    "birthplace_list = []\n",
    "deathplace_list = []\n",
    "spouses_list = []\n",
    "wedding_date_list = []\n",
    "divorce_date_list = []\n",
    "n_children_list = []\n",
    "\n",
    "pat = re.compile(r'(\\d{4})') # Matches groups of 4 digits\n",
    "\n",
    "for link in df['Link'].unique():\n",
    "    r = get(url + link)\n",
    "    soup = BeautifulSoup(r.content, 'html.parser')\n",
    "    \n",
    "    actor_id = df.loc[df['Link'] == link, 'ActorID'].values[0]\n",
    "    actor = df.loc[df['ActorID'] == actor_id, 'Actor'].values[0]\n",
    "    actor_list.append(actor)\n",
    "\n",
    "    # BIRTHDAY ---------------------\n",
    "    bday = soup.find('span', class_='bday').string\n",
    "    bday_list.append(bday)\n",
    "    \n",
    "    print(f'Actor: {actor}.\\nBirthday: {bday}')\n",
    "\n",
    "    # DEATH ------------------------\n",
    "    death_tag = soup.find('th', string='Died')\n",
    "    if death_tag == None:\n",
    "        death = None\n",
    "\n",
    "    else:\n",
    "        death = death_tag.findNext('span', style='display:none').text\n",
    "\n",
    "    death_list.append(death)\n",
    "    print(f'Died: {death}')\n",
    "\n",
    "    # BIRTHPLACE -------------------\n",
    "    birthplace_tag = soup.find('div', class_='birthplace')\n",
    "    if birthplace_tag == None:\n",
    "        birthplace = None\n",
    "\n",
    "    else:\n",
    "        birthplace = birthplace_tag.text\n",
    "\n",
    "    print(f'Birthplace: {birthplace}')\n",
    "    birthplace_list.append(birthplace)\n",
    "\n",
    "    # DEATHPLACE -------------------\n",
    "    deathplace_tag = soup.find('div', class_='deathplace')\n",
    "    if deathplace_tag == None:\n",
    "        deathplace = None\n",
    "    else:\n",
    "        deathplace = deathplace_tag.text\n",
    "\n",
    "    print(f'Deathplace: {deathplace}')\n",
    "    deathplace_list.append(deathplace)\n",
    "\n",
    "    # SPOUSES ----------------------\n",
    "    spouses = soup.find_all('div', class_='marriage-display-ws')\n",
    "\n",
    "    for spouse in spouses:\n",
    "        actor_id_list.append(actor_id)\n",
    "        print(f\"Spouse: {spouse.text.split('(')[0].replace('\\n', '').strip()}\")\n",
    "        spouse_name = spouse.text.split('(')[0].replace('\\n', '').strip()\n",
    "        spouses_list.append(spouse_name)\n",
    "        dates = spouse.text\n",
    "        dates = re.findall(pat, dates)\n",
    "        \n",
    "        if len(dates) == 1:\n",
    "            print(f'Married in {dates[0]}')\n",
    "            wedding_date_list.append(dates[0])\n",
    "            divorce_date_list.append(None)\n",
    "        else:\n",
    "            print(f'Married in {dates[0]}, divorced in {dates[1]}.')\n",
    "            wedding_date_list.append(dates[0])\n",
    "            divorce_date_list.append(dates[1])\n",
    "\n",
    "\n",
    "    # CHILDREN ---------------------\n",
    "    children_tag = soup.find('th', string='Children')\n",
    "    if children_tag == None:\n",
    "        n_children = 0\n",
    "\n",
    "    else:\n",
    "        n_children = children_tag.findNext('td').text\n",
    "        \n",
    "    n_children_list.append(n_children)\n",
    "    print(f'Number of children: {n_children}')\n",
    "    \n",
    "    print('------------------------------------------------')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "for actor, bday, death, n_children, birthplace, deathplace in zip(actor_list, bday_list, death_list, n_children_list, birthplace_list, deathplace_list):\n",
    "    df.loc[df['Actor'] == actor, 'Born'] = bday\n",
    "    df.loc[df['Actor'] == actor, 'Died'] = death\n",
    "    df.loc[df['Actor'] == actor, 'Birthplace'] = birthplace\n",
    "    df.loc[df['Actor'] == actor, 'Deathplace'] = deathplace\n",
    "    df.loc[df['Actor'] == actor, 'Children'] = n_children\n",
    "\n",
    "df['Died'] = df['Died'].str.replace(r'[\\(\\)]', '', regex=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "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>Year</th>\n",
       "      <th>ActorID</th>\n",
       "      <th>Actor</th>\n",
       "      <th>Role(s)</th>\n",
       "      <th>Film</th>\n",
       "      <th>Link</th>\n",
       "      <th>Born</th>\n",
       "      <th>Died</th>\n",
       "      <th>Birthplace</th>\n",
       "      <th>Deathplace</th>\n",
       "      <th>Children</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1927/28</td>\n",
       "      <td>0</td>\n",
       "      <td>Emil Jannings</td>\n",
       "      <td>Grand Duke Sergius Alexander, August Schilling</td>\n",
       "      <td>The Last Command, The Way of All Flesh</td>\n",
       "      <td>/wiki/Emil_Jannings</td>\n",
       "      <td>1884-07-23</td>\n",
       "      <td>1950-01-02</td>\n",
       "      <td>Rorschach, Switzerland</td>\n",
       "      <td>Strobl, Allied-occupied Austria</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1928/29</td>\n",
       "      <td>1</td>\n",
       "      <td>Warner Baxter</td>\n",
       "      <td>The Cisco Kid</td>\n",
       "      <td>In Old Arizona</td>\n",
       "      <td>/wiki/Warner_Baxter</td>\n",
       "      <td>1889-03-29</td>\n",
       "      <td>1951-05-07</td>\n",
       "      <td>Columbus, Ohio, U.S.</td>\n",
       "      <td>Beverly Hills, California, U.S.</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1929/30</td>\n",
       "      <td>2</td>\n",
       "      <td>George Arliss</td>\n",
       "      <td>Benjamin Disraeli</td>\n",
       "      <td>Disraeli</td>\n",
       "      <td>/wiki/George_Arliss</td>\n",
       "      <td>1868-04-10</td>\n",
       "      <td>1946-02-05</td>\n",
       "      <td>London, England</td>\n",
       "      <td>London, England</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1930/31</td>\n",
       "      <td>3</td>\n",
       "      <td>Lionel Barrymore</td>\n",
       "      <td>Stephen Ashe</td>\n",
       "      <td>A Free Soul</td>\n",
       "      <td>/wiki/Lionel_Barrymore</td>\n",
       "      <td>1878-04-28</td>\n",
       "      <td>1954-11-15</td>\n",
       "      <td>Philadelphia, Pennsylvania, U.S.</td>\n",
       "      <td>Los Angeles, California, U.S.</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1931/32</td>\n",
       "      <td>4</td>\n",
       "      <td>Wallace Beery</td>\n",
       "      <td>Andy \"Champ\" Purcell</td>\n",
       "      <td>The Champ</td>\n",
       "      <td>/wiki/Wallace_Beery</td>\n",
       "      <td>1885-04-01</td>\n",
       "      <td>1949-04-15</td>\n",
       "      <td>Clay County, Missouri, U.S.</td>\n",
       "      <td>Beverly Hills, California, U.S.</td>\n",
       "      <td>1</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>2019</td>\n",
       "      <td>82</td>\n",
       "      <td>Joaquin Phoenix</td>\n",
       "      <td>Arthur Fleck / Joker</td>\n",
       "      <td>Joker</td>\n",
       "      <td>/wiki/Joaquin_Phoenix</td>\n",
       "      <td>1974-10-28</td>\n",
       "      <td>None</td>\n",
       "      <td>San Juan, Puerto Rico</td>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>2020/21</td>\n",
       "      <td>59</td>\n",
       "      <td>Anthony Hopkins</td>\n",
       "      <td>Anthony</td>\n",
       "      <td>The Father</td>\n",
       "      <td>/wiki/Anthony_Hopkins</td>\n",
       "      <td>1937-12-31</td>\n",
       "      <td>None</td>\n",
       "      <td>Port Talbot, Glamorgan, Wales</td>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>2021</td>\n",
       "      <td>83</td>\n",
       "      <td>Will Smith</td>\n",
       "      <td>Richard Williams</td>\n",
       "      <td>King Richard</td>\n",
       "      <td>/wiki/Will_Smith</td>\n",
       "      <td>1968-09-25</td>\n",
       "      <td>None</td>\n",
       "      <td>Philadelphia, Pennsylvania, U.S.</td>\n",
       "      <td>None</td>\n",
       "      <td>3, including Jaden and Willow</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>2022</td>\n",
       "      <td>84</td>\n",
       "      <td>Brendan Fraser</td>\n",
       "      <td>Charlie</td>\n",
       "      <td>The Whale</td>\n",
       "      <td>/wiki/Brendan_Fraser</td>\n",
       "      <td>1968-12-03</td>\n",
       "      <td>None</td>\n",
       "      <td>Indianapolis, Indiana, U.S.</td>\n",
       "      <td>None</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>2023</td>\n",
       "      <td>85</td>\n",
       "      <td>Cillian Murphy</td>\n",
       "      <td>J. Robert Oppenheimer</td>\n",
       "      <td>Oppenheimer</td>\n",
       "      <td>/wiki/Cillian_Murphy</td>\n",
       "      <td>1976-05-25</td>\n",
       "      <td>None</td>\n",
       "      <td>Cork, Ireland</td>\n",
       "      <td>None</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>97 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Year  ActorID             Actor  \\\n",
       "0   1927/28        0     Emil Jannings   \n",
       "1   1928/29        1     Warner Baxter   \n",
       "2   1929/30        2     George Arliss   \n",
       "3   1930/31        3  Lionel Barrymore   \n",
       "4   1931/32        4     Wallace Beery   \n",
       "..      ...      ...               ...   \n",
       "92     2019       82   Joaquin Phoenix   \n",
       "93  2020/21       59   Anthony Hopkins   \n",
       "94     2021       83        Will Smith   \n",
       "95     2022       84    Brendan Fraser   \n",
       "96     2023       85    Cillian Murphy   \n",
       "\n",
       "                                           Role(s)  \\\n",
       "0   Grand Duke Sergius Alexander, August Schilling   \n",
       "1                                    The Cisco Kid   \n",
       "2                                Benjamin Disraeli   \n",
       "3                                     Stephen Ashe   \n",
       "4                             Andy \"Champ\" Purcell   \n",
       "..                                             ...   \n",
       "92                            Arthur Fleck / Joker   \n",
       "93                                         Anthony   \n",
       "94                                Richard Williams   \n",
       "95                                         Charlie   \n",
       "96                           J. Robert Oppenheimer   \n",
       "\n",
       "                                      Film                    Link  \\\n",
       "0   The Last Command, The Way of All Flesh     /wiki/Emil_Jannings   \n",
       "1                           In Old Arizona     /wiki/Warner_Baxter   \n",
       "2                                 Disraeli     /wiki/George_Arliss   \n",
       "3                              A Free Soul  /wiki/Lionel_Barrymore   \n",
       "4                                The Champ     /wiki/Wallace_Beery   \n",
       "..                                     ...                     ...   \n",
       "92                                   Joker   /wiki/Joaquin_Phoenix   \n",
       "93                              The Father   /wiki/Anthony_Hopkins   \n",
       "94                            King Richard        /wiki/Will_Smith   \n",
       "95                               The Whale    /wiki/Brendan_Fraser   \n",
       "96                             Oppenheimer    /wiki/Cillian_Murphy   \n",
       "\n",
       "          Born        Died                        Birthplace  \\\n",
       "0   1884-07-23  1950-01-02            Rorschach, Switzerland   \n",
       "1   1889-03-29  1951-05-07              Columbus, Ohio, U.S.   \n",
       "2   1868-04-10  1946-02-05                   London, England   \n",
       "3   1878-04-28  1954-11-15  Philadelphia, Pennsylvania, U.S.   \n",
       "4   1885-04-01  1949-04-15       Clay County, Missouri, U.S.   \n",
       "..         ...         ...                               ...   \n",
       "92  1974-10-28        None             San Juan, Puerto Rico   \n",
       "93  1937-12-31        None     Port Talbot, Glamorgan, Wales   \n",
       "94  1968-09-25        None  Philadelphia, Pennsylvania, U.S.   \n",
       "95  1968-12-03        None       Indianapolis, Indiana, U.S.   \n",
       "96  1976-05-25        None                     Cork, Ireland   \n",
       "\n",
       "                         Deathplace                       Children  \n",
       "0   Strobl, Allied-occupied Austria                              1  \n",
       "1   Beverly Hills, California, U.S.                              0  \n",
       "2                   London, England                              0  \n",
       "3     Los Angeles, California, U.S.                              2  \n",
       "4   Beverly Hills, California, U.S.                              1  \n",
       "..                              ...                            ...  \n",
       "92                             None                              1  \n",
       "93                             None                              1  \n",
       "94                             None  3, including Jaden and Willow  \n",
       "95                             None                              3  \n",
       "96                             None                              2  \n",
       "\n",
       "[97 rows x 11 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['1', 0, '2', '2, including Judy Lewis', '3', '4',\n",
       "       'GaryDennisPhillipLindsay (with Dixie)Harry IIIMaryNathaniel (with Kathryn)',\n",
       "       '6, including Miguel Ferrer', '2, including Stephen Humphrey',\n",
       "       '11, including Christian and Cheyenne', '5', 'Matthew Guinness',\n",
       "       '4, including David Jr.', '2, including Fraser Clarke Heston',\n",
       "       '5; including Bill', '5, including Cecilia Peck',\n",
       "       '6, including Sydney Tamiia', '\\nNoel\\nCarey\\n',\n",
       "       '7, including Michael, Patrick, and Ethan',\n",
       "       '7, including Devon and Campbell Scott',\n",
       "       '2, including Chris Lemmon', '6, including Lorraine and Ray',\n",
       "       '4; including Charles Finch', '3, including Emily and Ben',\n",
       "       'James HavenAngelina Jolie', '6, including Jake',\n",
       "       '7, including Drena and Raphael', '3, including Jane and Peter',\n",
       "       '4, including Ferdinand Kingsley',\n",
       "       '6, including Scott, Nell, and Melissa',\n",
       "       '3, including Cameron Douglas', '2, including Max Irons',\n",
       "       '4, including Colin and Chet', '4, including John David',\n",
       "       'Dylan PennHopper Penn', '2, including Corinne',\n",
       "       '3, including Cooper', '3, including Jaden and Willow'],\n",
       "      dtype=object)"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Children'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "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>Children</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ActorID</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2, including Judy Lewis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>GaryDennisPhillipLindsay (with Dixie)Harry III...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>6, including Miguel Ferrer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2, including Stephen Humphrey</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>11, including Christian and Cheyenne</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Matthew Guinness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>4, including David Jr.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2, including Fraser Clarke Heston</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>5; including Bill</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>5, including Cecilia Peck</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>6, including Sydney Tamiia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>\\nNoel\\nCarey\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>7, including Michael, Patrick, and Ethan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>7, including Devon and Campbell Scott</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>11, including Christian and Cheyenne</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>2, including Chris Lemmon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>6, including Lorraine and Ray</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>4; including Charles Finch</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>3, including Emily and Ben</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>James HavenAngelina Jolie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>6, including Jake</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>7, including Drena and Raphael</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>3, including Jane and Peter</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>4, including Ferdinand Kingsley</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>6, including Scott, Nell, and Melissa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>3, including Cameron Douglas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>6, including Jake</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>2, including Max Irons</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>4, including Colin and Chet</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>4, including Colin and Chet</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>6, including Lorraine and Ray</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>4, including John David</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>Dylan PennHopper Penn</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>2, including Corinne</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>3, including Cooper</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>Dylan PennHopper Penn</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>3, including Jaden and Willow</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                  Children\n",
       "ActorID                                                   \n",
       "7                                  2, including Judy Lewis\n",
       "16       GaryDennisPhillipLindsay (with Dixie)Harry III...\n",
       "21                              6, including Miguel Ferrer\n",
       "22                           2, including Stephen Humphrey\n",
       "24                    11, including Christian and Cheyenne\n",
       "27                                        Matthew Guinness\n",
       "28                                  4, including David Jr.\n",
       "29                       2, including Fraser Clarke Heston\n",
       "30                                       5; including Bill\n",
       "32                               5, including Cecilia Peck\n",
       "33                              6, including Sydney Tamiia\n",
       "34                                         \\nNoel\\nCarey\\n\n",
       "39                7, including Michael, Patrick, and Ethan\n",
       "40                   7, including Devon and Campbell Scott\n",
       "24                    11, including Christian and Cheyenne\n",
       "42                               2, including Chris Lemmon\n",
       "44                           6, including Lorraine and Ray\n",
       "45                              4; including Charles Finch\n",
       "46                              3, including Emily and Ben\n",
       "47                               James HavenAngelina Jolie\n",
       "48                                       6, including Jake\n",
       "49                          7, including Drena and Raphael\n",
       "50                             3, including Jane and Peter\n",
       "51                         4, including Ferdinand Kingsley\n",
       "55                   6, including Scott, Nell, and Melissa\n",
       "56                            3, including Cameron Douglas\n",
       "48                                       6, including Jake\n",
       "58                                  2, including Max Irons\n",
       "61                             4, including Colin and Chet\n",
       "61                             4, including Colin and Chet\n",
       "44                           6, including Lorraine and Ray\n",
       "67                                 4, including John David\n",
       "69                                   Dylan PennHopper Penn\n",
       "70                                    2, including Corinne\n",
       "71                                     3, including Cooper\n",
       "69                                   Dylan PennHopper Penn\n",
       "83                           3, including Jaden and Willow"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "children = df.loc[df['Children'].str.len() > 1, ['ActorID','Children']].set_index('ActorID')\n",
    "children"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "def extract_number(text):\n",
    "  match = re.search(r'\\d+', text)\n",
    "  return match.group() if match else text"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "children = children['Children'].apply(extract_number)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['2',\n",
       "       'GaryDennisPhillipLindsay (with Dixie)Harry IIIMaryNathaniel (with Kathryn)',\n",
       "       '6', '11', 'Matthew Guinness', '4', '5', '\\nNoel\\nCarey\\n', '7',\n",
       "       '3', 'James HavenAngelina Jolie', 'Dylan PennHopper Penn'],\n",
       "      dtype=object)"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "children.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ActorID\n",
       "7                                                     2\n",
       "16    GaryDennisPhillipLindsay (with Dixie)Harry III...\n",
       "21                                                    6\n",
       "22                                                    2\n",
       "24                                                   11\n",
       "27                                     Matthew Guinness\n",
       "28                                                    4\n",
       "29                                                    2\n",
       "30                                                    5\n",
       "32                                                    5\n",
       "33                                                    6\n",
       "34                                      \\nNoel\\nCarey\\n\n",
       "39                                                    7\n",
       "40                                                    7\n",
       "24                                                   11\n",
       "42                                                    2\n",
       "44                                                    6\n",
       "45                                                    4\n",
       "46                                                    3\n",
       "47                            James HavenAngelina Jolie\n",
       "48                                                    6\n",
       "49                                                    7\n",
       "50                                                    3\n",
       "51                                                    4\n",
       "55                                                    6\n",
       "56                                                    3\n",
       "48                                                    6\n",
       "58                                                    2\n",
       "61                                                    4\n",
       "61                                                    4\n",
       "44                                                    6\n",
       "67                                                    4\n",
       "69                                Dylan PennHopper Penn\n",
       "70                                                    2\n",
       "71                                                    3\n",
       "69                                Dylan PennHopper Penn\n",
       "83                                                    3\n",
       "Name: Children, dtype: object"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "children"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "children[16] = '7'\n",
    "children[27] = '1'\n",
    "children[34] = '2'\n",
    "children[47] = '2'\n",
    "children[69] = '2'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ActorID\n",
       "7      2\n",
       "16     7\n",
       "21     6\n",
       "22     2\n",
       "24    11\n",
       "27     1\n",
       "28     4\n",
       "29     2\n",
       "30     5\n",
       "32     5\n",
       "33     6\n",
       "34     2\n",
       "39     7\n",
       "40     7\n",
       "24    11\n",
       "42     2\n",
       "44     6\n",
       "45     4\n",
       "46     3\n",
       "47     2\n",
       "48     6\n",
       "49     7\n",
       "50     3\n",
       "51     4\n",
       "55     6\n",
       "56     3\n",
       "48     6\n",
       "58     2\n",
       "61     4\n",
       "61     4\n",
       "44     6\n",
       "67     4\n",
       "69     2\n",
       "70     2\n",
       "71     3\n",
       "69     2\n",
       "83     3\n",
       "Name: Children, dtype: object"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "children"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['1', 0, '2', '3', '4', '7', '6', '11', '5'], dtype=object)"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "for actor_id, child_count in children.items():\n",
    "    df.loc[df['ActorID'] == actor_id, 'Children'] = child_count\n",
    "\n",
    "df['Children'].unique()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Marriages"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "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>ActorID</th>\n",
       "      <th>Spouse</th>\n",
       "      <th>From</th>\n",
       "      <th>To</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>Hanna Ralph​ ​</td>\n",
       "      <td>1919</td>\n",
       "      <td>1921</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>Lucie Höflich​ ​</td>\n",
       "      <td>1921</td>\n",
       "      <td>1921</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>Gussy Holl ​</td>\n",
       "      <td>1923</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>Viola Caldwell​ ​</td>\n",
       "      <td>1911</td>\n",
       "      <td>1913</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>Winifred Bryson ​</td>\n",
       "      <td>1918</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  ActorID             Spouse  From    To\n",
       "0       0     Hanna Ralph​ ​  1919  1921\n",
       "1       0   Lucie Höflich​ ​  1921  1921\n",
       "2       0       Gussy Holl ​  1923  None\n",
       "3       1  Viola Caldwell​ ​  1911  1913\n",
       "4       1  Winifred Bryson ​  1918  None"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data = np.stack([actor_id_list, spouses_list, wedding_date_list,divorce_date_list]).T\n",
    "\n",
    "marriages = pd.DataFrame(data, columns=['ActorID', 'Spouse', 'From', 'To'])\n",
    "marriages.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Hanna Ralph\\u200b \\u200b'"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "marriages['Spouse'][0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "14"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(marriages['Spouse'][0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [],
   "source": [
    "marriages['Spouse'] = marriages['Spouse'].str.replace('\\u200b', '').str.strip()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "11"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(marriages['Spouse'][0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [],
   "source": [
    "marriages.to_csv('data/marriages.csv')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Awards dates"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [],
   "source": [
    "url = 'https://en.wikipedia.org/wiki/List_of_Academy_Awards_ceremonies'\n",
    "\n",
    "r = get(url)\n",
    "soup = BeautifulSoup(r.content, 'html.parser')\n",
    "\n",
    "tables = soup.find_all('table', class_='wikitable sortable sticky-header')\n",
    "tables = pd.read_html(StringIO(str(tables)))\n",
    "awards = tables[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "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>#</th>\n",
       "      <th>Date</th>\n",
       "      <th>Best Picture</th>\n",
       "      <th>Most awarded film(s)</th>\n",
       "      <th>Number of viewers P2+</th>\n",
       "      <th>HH Rating</th>\n",
       "      <th>Host(s)</th>\n",
       "      <th>Producer(s)</th>\n",
       "      <th>Venue</th>\n",
       "      <th>Broadcast partner(s)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1st</td>\n",
       "      <td>May 16, 1929</td>\n",
       "      <td>Wings</td>\n",
       "      <td>7th Heaven Sunrise</td>\n",
       "      <td>—</td>\n",
       "      <td>—</td>\n",
       "      <td>Douglas Fairbanks</td>\n",
       "      <td>—</td>\n",
       "      <td>The Hollywood Roosevelt Hotel</td>\n",
       "      <td>none</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2nd</td>\n",
       "      <td>April 3, 1930</td>\n",
       "      <td>The Broadway Melody</td>\n",
       "      <td>The Bridge of San Luis Rey The Broadway Melody...</td>\n",
       "      <td>—</td>\n",
       "      <td>—</td>\n",
       "      <td>William C. deMille</td>\n",
       "      <td>—</td>\n",
       "      <td>Ambassador Hotel</td>\n",
       "      <td>KNX-AM[a][7]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3rd</td>\n",
       "      <td>November 5, 1930</td>\n",
       "      <td>All Quiet on the Western Front</td>\n",
       "      <td>All Quiet on the Western Front The Big House</td>\n",
       "      <td>—</td>\n",
       "      <td>—</td>\n",
       "      <td>Conrad Nagel</td>\n",
       "      <td>—</td>\n",
       "      <td>Ambassador Hotel</td>\n",
       "      <td>KNX-AM[a]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4th</td>\n",
       "      <td>November 10, 1931</td>\n",
       "      <td>Cimarron</td>\n",
       "      <td>Cimarron</td>\n",
       "      <td>—</td>\n",
       "      <td>—</td>\n",
       "      <td>Lawrence Grant</td>\n",
       "      <td>—</td>\n",
       "      <td>Biltmore Hotel</td>\n",
       "      <td>KHJ-AM[b]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5th</td>\n",
       "      <td>November 18, 1932</td>\n",
       "      <td>Grand Hotel</td>\n",
       "      <td>Bad Girl The Champ</td>\n",
       "      <td>—</td>\n",
       "      <td>—</td>\n",
       "      <td>Lionel Barrymore Conrad Nagel</td>\n",
       "      <td>—</td>\n",
       "      <td>Ambassador Hotel</td>\n",
       "      <td>KECA-AM[c]</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>93rd</td>\n",
       "      <td>April 25, 2021</td>\n",
       "      <td>Nomadland</td>\n",
       "      <td>Nomadland</td>\n",
       "      <td>10.40 million</td>\n",
       "      <td>5.9</td>\n",
       "      <td>none</td>\n",
       "      <td>Jesse Collins Stacey Sher Steven Soderbergh</td>\n",
       "      <td>Union Station</td>\n",
       "      <td>ABC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>94th</td>\n",
       "      <td>March 27, 2022</td>\n",
       "      <td>CODA</td>\n",
       "      <td>Dune</td>\n",
       "      <td>16.62 million</td>\n",
       "      <td>9.0</td>\n",
       "      <td>Regina Hall Amy Schumer Wanda Sykes</td>\n",
       "      <td>Will Packer Shayla Cowan</td>\n",
       "      <td>Dolby Theatre</td>\n",
       "      <td>ABC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>95th</td>\n",
       "      <td>March 12, 2023</td>\n",
       "      <td>Everything Everywhere All at Once</td>\n",
       "      <td>Everything Everywhere All at Once</td>\n",
       "      <td>18.70 million</td>\n",
       "      <td>9.9</td>\n",
       "      <td>Jimmy Kimmel</td>\n",
       "      <td>Ricky Kirshner Glenn Weiss</td>\n",
       "      <td>Dolby Theatre</td>\n",
       "      <td>ABC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>96th</td>\n",
       "      <td>March 10, 2024</td>\n",
       "      <td>Oppenheimer</td>\n",
       "      <td>Oppenheimer</td>\n",
       "      <td>19.50 million</td>\n",
       "      <td>9.9</td>\n",
       "      <td>Jimmy Kimmel</td>\n",
       "      <td>Raj Kapoor Katy Mullan</td>\n",
       "      <td>Dolby Theatre</td>\n",
       "      <td>ABC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>97th</td>\n",
       "      <td>March 2, 2025</td>\n",
       "      <td>TBA</td>\n",
       "      <td>TBA</td>\n",
       "      <td>TBA</td>\n",
       "      <td>TBA</td>\n",
       "      <td>TBA</td>\n",
       "      <td>TBA</td>\n",
       "      <td>Dolby Theatre</td>\n",
       "      <td>ABC</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>97 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       #               Date                       Best Picture  \\\n",
       "0    1st       May 16, 1929                              Wings   \n",
       "1    2nd      April 3, 1930                The Broadway Melody   \n",
       "2    3rd   November 5, 1930     All Quiet on the Western Front   \n",
       "3    4th  November 10, 1931                           Cimarron   \n",
       "4    5th  November 18, 1932                        Grand Hotel   \n",
       "..   ...                ...                                ...   \n",
       "92  93rd     April 25, 2021                          Nomadland   \n",
       "93  94th     March 27, 2022                               CODA   \n",
       "94  95th     March 12, 2023  Everything Everywhere All at Once   \n",
       "95  96th     March 10, 2024                        Oppenheimer   \n",
       "96  97th      March 2, 2025                                TBA   \n",
       "\n",
       "                                 Most awarded film(s) Number of viewers P2+  \\\n",
       "0                                  7th Heaven Sunrise                     —   \n",
       "1   The Bridge of San Luis Rey The Broadway Melody...                     —   \n",
       "2        All Quiet on the Western Front The Big House                     —   \n",
       "3                                            Cimarron                     —   \n",
       "4                                  Bad Girl The Champ                     —   \n",
       "..                                                ...                   ...   \n",
       "92                                          Nomadland         10.40 million   \n",
       "93                                               Dune         16.62 million   \n",
       "94                  Everything Everywhere All at Once         18.70 million   \n",
       "95                                        Oppenheimer         19.50 million   \n",
       "96                                                TBA                   TBA   \n",
       "\n",
       "   HH Rating                              Host(s)  \\\n",
       "0          —                    Douglas Fairbanks   \n",
       "1          —                   William C. deMille   \n",
       "2          —                         Conrad Nagel   \n",
       "3          —                       Lawrence Grant   \n",
       "4          —        Lionel Barrymore Conrad Nagel   \n",
       "..       ...                                  ...   \n",
       "92       5.9                                 none   \n",
       "93       9.0  Regina Hall Amy Schumer Wanda Sykes   \n",
       "94       9.9                         Jimmy Kimmel   \n",
       "95       9.9                         Jimmy Kimmel   \n",
       "96       TBA                                  TBA   \n",
       "\n",
       "                                    Producer(s)  \\\n",
       "0                                             —   \n",
       "1                                             —   \n",
       "2                                             —   \n",
       "3                                             —   \n",
       "4                                             —   \n",
       "..                                          ...   \n",
       "92  Jesse Collins Stacey Sher Steven Soderbergh   \n",
       "93                     Will Packer Shayla Cowan   \n",
       "94                   Ricky Kirshner Glenn Weiss   \n",
       "95                       Raj Kapoor Katy Mullan   \n",
       "96                                          TBA   \n",
       "\n",
       "                            Venue Broadcast partner(s)  \n",
       "0   The Hollywood Roosevelt Hotel                 none  \n",
       "1                Ambassador Hotel         KNX-AM[a][7]  \n",
       "2                Ambassador Hotel            KNX-AM[a]  \n",
       "3                  Biltmore Hotel            KHJ-AM[b]  \n",
       "4                Ambassador Hotel           KECA-AM[c]  \n",
       "..                            ...                  ...  \n",
       "92                  Union Station                  ABC  \n",
       "93                  Dolby Theatre                  ABC  \n",
       "94                  Dolby Theatre                  ABC  \n",
       "95                  Dolby Theatre                  ABC  \n",
       "96                  Dolby Theatre                  ABC  \n",
       "\n",
       "[97 rows x 10 columns]"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "awards"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [],
   "source": [
    "awards.drop(96, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "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>#</th>\n",
       "      <th>Date</th>\n",
       "      <th>Best Picture</th>\n",
       "      <th>Most awarded film(s)</th>\n",
       "      <th>Number of viewers P2+</th>\n",
       "      <th>HH Rating</th>\n",
       "      <th>Host(s)</th>\n",
       "      <th>Producer(s)</th>\n",
       "      <th>Venue</th>\n",
       "      <th>Broadcast partner(s)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1st</td>\n",
       "      <td>May 16, 1929</td>\n",
       "      <td>Wings</td>\n",
       "      <td>7th Heaven Sunrise</td>\n",
       "      <td>—</td>\n",
       "      <td>—</td>\n",
       "      <td>Douglas Fairbanks</td>\n",
       "      <td>—</td>\n",
       "      <td>The Hollywood Roosevelt Hotel</td>\n",
       "      <td>none</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2nd</td>\n",
       "      <td>April 3, 1930</td>\n",
       "      <td>The Broadway Melody</td>\n",
       "      <td>The Bridge of San Luis Rey The Broadway Melody...</td>\n",
       "      <td>—</td>\n",
       "      <td>—</td>\n",
       "      <td>William C. deMille</td>\n",
       "      <td>—</td>\n",
       "      <td>Ambassador Hotel</td>\n",
       "      <td>KNX-AM[a][7]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3rd</td>\n",
       "      <td>November 5, 1930</td>\n",
       "      <td>All Quiet on the Western Front</td>\n",
       "      <td>All Quiet on the Western Front The Big House</td>\n",
       "      <td>—</td>\n",
       "      <td>—</td>\n",
       "      <td>Conrad Nagel</td>\n",
       "      <td>—</td>\n",
       "      <td>Ambassador Hotel</td>\n",
       "      <td>KNX-AM[a]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4th</td>\n",
       "      <td>November 10, 1931</td>\n",
       "      <td>Cimarron</td>\n",
       "      <td>Cimarron</td>\n",
       "      <td>—</td>\n",
       "      <td>—</td>\n",
       "      <td>Lawrence Grant</td>\n",
       "      <td>—</td>\n",
       "      <td>Biltmore Hotel</td>\n",
       "      <td>KHJ-AM[b]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5th</td>\n",
       "      <td>November 18, 1932</td>\n",
       "      <td>Grand Hotel</td>\n",
       "      <td>Bad Girl The Champ</td>\n",
       "      <td>—</td>\n",
       "      <td>—</td>\n",
       "      <td>Lionel Barrymore Conrad Nagel</td>\n",
       "      <td>—</td>\n",
       "      <td>Ambassador Hotel</td>\n",
       "      <td>KECA-AM[c]</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>92nd</td>\n",
       "      <td>February 9, 2020</td>\n",
       "      <td>Parasite</td>\n",
       "      <td>Parasite</td>\n",
       "      <td>23.64 million</td>\n",
       "      <td>13.59[9]</td>\n",
       "      <td>none</td>\n",
       "      <td>Lynette Howell Taylor Stephanie Allain</td>\n",
       "      <td>Dolby Theatre</td>\n",
       "      <td>ABC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>93rd</td>\n",
       "      <td>April 25, 2021</td>\n",
       "      <td>Nomadland</td>\n",
       "      <td>Nomadland</td>\n",
       "      <td>10.40 million</td>\n",
       "      <td>5.9</td>\n",
       "      <td>none</td>\n",
       "      <td>Jesse Collins Stacey Sher Steven Soderbergh</td>\n",
       "      <td>Union Station</td>\n",
       "      <td>ABC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>94th</td>\n",
       "      <td>March 27, 2022</td>\n",
       "      <td>CODA</td>\n",
       "      <td>Dune</td>\n",
       "      <td>16.62 million</td>\n",
       "      <td>9.0</td>\n",
       "      <td>Regina Hall Amy Schumer Wanda Sykes</td>\n",
       "      <td>Will Packer Shayla Cowan</td>\n",
       "      <td>Dolby Theatre</td>\n",
       "      <td>ABC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>95th</td>\n",
       "      <td>March 12, 2023</td>\n",
       "      <td>Everything Everywhere All at Once</td>\n",
       "      <td>Everything Everywhere All at Once</td>\n",
       "      <td>18.70 million</td>\n",
       "      <td>9.9</td>\n",
       "      <td>Jimmy Kimmel</td>\n",
       "      <td>Ricky Kirshner Glenn Weiss</td>\n",
       "      <td>Dolby Theatre</td>\n",
       "      <td>ABC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>96th</td>\n",
       "      <td>March 10, 2024</td>\n",
       "      <td>Oppenheimer</td>\n",
       "      <td>Oppenheimer</td>\n",
       "      <td>19.50 million</td>\n",
       "      <td>9.9</td>\n",
       "      <td>Jimmy Kimmel</td>\n",
       "      <td>Raj Kapoor Katy Mullan</td>\n",
       "      <td>Dolby Theatre</td>\n",
       "      <td>ABC</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>96 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       #               Date                       Best Picture  \\\n",
       "0    1st       May 16, 1929                              Wings   \n",
       "1    2nd      April 3, 1930                The Broadway Melody   \n",
       "2    3rd   November 5, 1930     All Quiet on the Western Front   \n",
       "3    4th  November 10, 1931                           Cimarron   \n",
       "4    5th  November 18, 1932                        Grand Hotel   \n",
       "..   ...                ...                                ...   \n",
       "91  92nd   February 9, 2020                           Parasite   \n",
       "92  93rd     April 25, 2021                          Nomadland   \n",
       "93  94th     March 27, 2022                               CODA   \n",
       "94  95th     March 12, 2023  Everything Everywhere All at Once   \n",
       "95  96th     March 10, 2024                        Oppenheimer   \n",
       "\n",
       "                                 Most awarded film(s) Number of viewers P2+  \\\n",
       "0                                  7th Heaven Sunrise                     —   \n",
       "1   The Bridge of San Luis Rey The Broadway Melody...                     —   \n",
       "2        All Quiet on the Western Front The Big House                     —   \n",
       "3                                            Cimarron                     —   \n",
       "4                                  Bad Girl The Champ                     —   \n",
       "..                                                ...                   ...   \n",
       "91                                           Parasite         23.64 million   \n",
       "92                                          Nomadland         10.40 million   \n",
       "93                                               Dune         16.62 million   \n",
       "94                  Everything Everywhere All at Once         18.70 million   \n",
       "95                                        Oppenheimer         19.50 million   \n",
       "\n",
       "   HH Rating                              Host(s)  \\\n",
       "0          —                    Douglas Fairbanks   \n",
       "1          —                   William C. deMille   \n",
       "2          —                         Conrad Nagel   \n",
       "3          —                       Lawrence Grant   \n",
       "4          —        Lionel Barrymore Conrad Nagel   \n",
       "..       ...                                  ...   \n",
       "91  13.59[9]                                 none   \n",
       "92       5.9                                 none   \n",
       "93       9.0  Regina Hall Amy Schumer Wanda Sykes   \n",
       "94       9.9                         Jimmy Kimmel   \n",
       "95       9.9                         Jimmy Kimmel   \n",
       "\n",
       "                                    Producer(s)  \\\n",
       "0                                             —   \n",
       "1                                             —   \n",
       "2                                             —   \n",
       "3                                             —   \n",
       "4                                             —   \n",
       "..                                          ...   \n",
       "91       Lynette Howell Taylor Stephanie Allain   \n",
       "92  Jesse Collins Stacey Sher Steven Soderbergh   \n",
       "93                     Will Packer Shayla Cowan   \n",
       "94                   Ricky Kirshner Glenn Weiss   \n",
       "95                       Raj Kapoor Katy Mullan   \n",
       "\n",
       "                            Venue Broadcast partner(s)  \n",
       "0   The Hollywood Roosevelt Hotel                 none  \n",
       "1                Ambassador Hotel         KNX-AM[a][7]  \n",
       "2                Ambassador Hotel            KNX-AM[a]  \n",
       "3                  Biltmore Hotel            KHJ-AM[b]  \n",
       "4                Ambassador Hotel           KECA-AM[c]  \n",
       "..                            ...                  ...  \n",
       "91                  Dolby Theatre                  ABC  \n",
       "92                  Union Station                  ABC  \n",
       "93                  Dolby Theatre                  ABC  \n",
       "94                  Dolby Theatre                  ABC  \n",
       "95                  Dolby Theatre                  ABC  \n",
       "\n",
       "[96 rows x 10 columns]"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "awards"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "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>Year</th>\n",
       "      <th>ActorID</th>\n",
       "      <th>Actor</th>\n",
       "      <th>Role(s)</th>\n",
       "      <th>Film</th>\n",
       "      <th>Link</th>\n",
       "      <th>Born</th>\n",
       "      <th>Died</th>\n",
       "      <th>Birthplace</th>\n",
       "      <th>Deathplace</th>\n",
       "      <th>Children</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1931/32</td>\n",
       "      <td>4</td>\n",
       "      <td>Wallace Beery</td>\n",
       "      <td>Andy \"Champ\" Purcell</td>\n",
       "      <td>The Champ</td>\n",
       "      <td>/wiki/Wallace_Beery</td>\n",
       "      <td>1885-04-01</td>\n",
       "      <td>1949-04-15</td>\n",
       "      <td>Clay County, Missouri, U.S.</td>\n",
       "      <td>Beverly Hills, California, U.S.</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1931/32</td>\n",
       "      <td>5</td>\n",
       "      <td>Fredric March</td>\n",
       "      <td>Dr. Henry Jekyll / Mr. Edward Hyde</td>\n",
       "      <td>Dr. Jekyll and Mr. Hyde</td>\n",
       "      <td>/wiki/Fredric_March</td>\n",
       "      <td>1897-08-31</td>\n",
       "      <td>1975-04-14</td>\n",
       "      <td>Racine, Wisconsin, U.S.</td>\n",
       "      <td>Los Angeles, California, U.S.</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1946</td>\n",
       "      <td>5</td>\n",
       "      <td>Fredric March</td>\n",
       "      <td>Platoon Sergeant Al Stephenson</td>\n",
       "      <td>The Best Years of Our Lives</td>\n",
       "      <td>/wiki/Fredric_March</td>\n",
       "      <td>1897-08-31</td>\n",
       "      <td>1975-04-14</td>\n",
       "      <td>Racine, Wisconsin, U.S.</td>\n",
       "      <td>Los Angeles, California, U.S.</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       Year  ActorID          Actor                             Role(s)  \\\n",
       "4   1931/32        4  Wallace Beery                Andy \"Champ\" Purcell   \n",
       "5   1931/32        5  Fredric March  Dr. Henry Jekyll / Mr. Edward Hyde   \n",
       "19     1946        5  Fredric March      Platoon Sergeant Al Stephenson   \n",
       "\n",
       "                           Film                 Link        Born        Died  \\\n",
       "4                     The Champ  /wiki/Wallace_Beery  1885-04-01  1949-04-15   \n",
       "5       Dr. Jekyll and Mr. Hyde  /wiki/Fredric_March  1897-08-31  1975-04-14   \n",
       "19  The Best Years of Our Lives  /wiki/Fredric_March  1897-08-31  1975-04-14   \n",
       "\n",
       "                     Birthplace                       Deathplace Children  \n",
       "4   Clay County, Missouri, U.S.  Beverly Hills, California, U.S.        1  \n",
       "5       Racine, Wisconsin, U.S.    Los Angeles, California, U.S.        2  \n",
       "19      Racine, Wisconsin, U.S.    Los Angeles, California, U.S.        2  "
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[df['Actor'].isin(['Wallace Beery', 'Fredric March'])]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [],
   "source": [
    "award_dates = awards['Date'].to_list()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'November 18, 1932'"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "award_dates[4]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [],
   "source": [
    "award_dates.insert(5, award_dates[4])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['May 16, 1929',\n",
       " 'April 3, 1930',\n",
       " 'November 5, 1930',\n",
       " 'November 10, 1931',\n",
       " 'November 18, 1932',\n",
       " 'November 18, 1932',\n",
       " 'March 16, 1934',\n",
       " 'February 27, 1935',\n",
       " 'March 5, 1936',\n",
       " 'March 4, 1937',\n",
       " 'March 10, 1938',\n",
       " 'February 23, 1939',\n",
       " 'February 29, 1940',\n",
       " 'February 27, 1941',\n",
       " 'February 26, 1942',\n",
       " 'March 4, 1943',\n",
       " 'March 2, 1944',\n",
       " 'March 15, 1945',\n",
       " 'March 7, 1946',\n",
       " 'March 13, 1947',\n",
       " 'March 20, 1948',\n",
       " 'March 24, 1949',\n",
       " 'March 23, 1950',\n",
       " 'March 29, 1951',\n",
       " 'March 20, 1952',\n",
       " 'March 19, 1953',\n",
       " 'March 25, 1954',\n",
       " 'March 30, 1955',\n",
       " 'March 21, 1956',\n",
       " 'March 27, 1957',\n",
       " 'March 26, 1958',\n",
       " 'April 6, 1959',\n",
       " 'April 4, 1960',\n",
       " 'April 17, 1961',\n",
       " 'April 9, 1962',\n",
       " 'April 8, 1963',\n",
       " 'April 13, 1964',\n",
       " 'April 5, 1965',\n",
       " 'April 18, 1966',\n",
       " 'April 10, 1967',\n",
       " 'April 10, 1968',\n",
       " 'April 14, 1969',\n",
       " 'April 7, 1970',\n",
       " 'April 15, 1971',\n",
       " 'April 10, 1972',\n",
       " 'March 27, 1973',\n",
       " 'April 2, 1974',\n",
       " 'April 8, 1975',\n",
       " 'March 29, 1976',\n",
       " 'March 28, 1977',\n",
       " 'April 3, 1978',\n",
       " 'April 9, 1979',\n",
       " 'April 14, 1980',\n",
       " 'March 31, 1981',\n",
       " 'March 29, 1982',\n",
       " 'April 11, 1983',\n",
       " 'April 9, 1984',\n",
       " 'March 25, 1985',\n",
       " 'March 24, 1986',\n",
       " 'March 30, 1987',\n",
       " 'April 11, 1988',\n",
       " 'March 29, 1989',\n",
       " 'March 26, 1990',\n",
       " 'March 25, 1991',\n",
       " 'March 30, 1992',\n",
       " 'March 29, 1993',\n",
       " 'March 21, 1994',\n",
       " 'March 27, 1995',\n",
       " 'March 25, 1996',\n",
       " 'March 24, 1997',\n",
       " 'March 23, 1998',\n",
       " 'March 21, 1999',\n",
       " 'March 26, 2000',\n",
       " 'March 25, 2001',\n",
       " 'March 24, 2002',\n",
       " 'March 23, 2003',\n",
       " 'February 29, 2004',\n",
       " 'February 27, 2005',\n",
       " 'March 5, 2006',\n",
       " 'February 25, 2007',\n",
       " 'February 24, 2008',\n",
       " 'February 22, 2009',\n",
       " 'March 7, 2010',\n",
       " 'February 27, 2011',\n",
       " 'February 26, 2012',\n",
       " 'February 24, 2013',\n",
       " 'March 2, 2014',\n",
       " 'February 22, 2015',\n",
       " 'February 28, 2016',\n",
       " 'February 26, 2017',\n",
       " 'March 4, 2018',\n",
       " 'February 24, 2019',\n",
       " 'February 9, 2020',\n",
       " 'April 25, 2021',\n",
       " 'March 27, 2022',\n",
       " 'March 12, 2023',\n",
       " 'March 10, 2024']"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "award_dates"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "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>Year</th>\n",
       "      <th>ActorID</th>\n",
       "      <th>Actor</th>\n",
       "      <th>Role(s)</th>\n",
       "      <th>Film</th>\n",
       "      <th>Link</th>\n",
       "      <th>Born</th>\n",
       "      <th>Died</th>\n",
       "      <th>Birthplace</th>\n",
       "      <th>Deathplace</th>\n",
       "      <th>Children</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>May 16, 1929</td>\n",
       "      <td>0</td>\n",
       "      <td>Emil Jannings</td>\n",
       "      <td>Grand Duke Sergius Alexander, August Schilling</td>\n",
       "      <td>The Last Command, The Way of All Flesh</td>\n",
       "      <td>/wiki/Emil_Jannings</td>\n",
       "      <td>1884-07-23</td>\n",
       "      <td>1950-01-02</td>\n",
       "      <td>Rorschach, Switzerland</td>\n",
       "      <td>Strobl, Allied-occupied Austria</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>April 3, 1930</td>\n",
       "      <td>1</td>\n",
       "      <td>Warner Baxter</td>\n",
       "      <td>The Cisco Kid</td>\n",
       "      <td>In Old Arizona</td>\n",
       "      <td>/wiki/Warner_Baxter</td>\n",
       "      <td>1889-03-29</td>\n",
       "      <td>1951-05-07</td>\n",
       "      <td>Columbus, Ohio, U.S.</td>\n",
       "      <td>Beverly Hills, California, U.S.</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>November 5, 1930</td>\n",
       "      <td>2</td>\n",
       "      <td>George Arliss</td>\n",
       "      <td>Benjamin Disraeli</td>\n",
       "      <td>Disraeli</td>\n",
       "      <td>/wiki/George_Arliss</td>\n",
       "      <td>1868-04-10</td>\n",
       "      <td>1946-02-05</td>\n",
       "      <td>London, England</td>\n",
       "      <td>London, England</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>November 10, 1931</td>\n",
       "      <td>3</td>\n",
       "      <td>Lionel Barrymore</td>\n",
       "      <td>Stephen Ashe</td>\n",
       "      <td>A Free Soul</td>\n",
       "      <td>/wiki/Lionel_Barrymore</td>\n",
       "      <td>1878-04-28</td>\n",
       "      <td>1954-11-15</td>\n",
       "      <td>Philadelphia, Pennsylvania, U.S.</td>\n",
       "      <td>Los Angeles, California, U.S.</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>November 18, 1932</td>\n",
       "      <td>4</td>\n",
       "      <td>Wallace Beery</td>\n",
       "      <td>Andy \"Champ\" Purcell</td>\n",
       "      <td>The Champ</td>\n",
       "      <td>/wiki/Wallace_Beery</td>\n",
       "      <td>1885-04-01</td>\n",
       "      <td>1949-04-15</td>\n",
       "      <td>Clay County, Missouri, U.S.</td>\n",
       "      <td>Beverly Hills, California, U.S.</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                Year  ActorID             Actor  \\\n",
       "0       May 16, 1929        0     Emil Jannings   \n",
       "1      April 3, 1930        1     Warner Baxter   \n",
       "2   November 5, 1930        2     George Arliss   \n",
       "3  November 10, 1931        3  Lionel Barrymore   \n",
       "4  November 18, 1932        4     Wallace Beery   \n",
       "\n",
       "                                          Role(s)  \\\n",
       "0  Grand Duke Sergius Alexander, August Schilling   \n",
       "1                                   The Cisco Kid   \n",
       "2                               Benjamin Disraeli   \n",
       "3                                    Stephen Ashe   \n",
       "4                            Andy \"Champ\" Purcell   \n",
       "\n",
       "                                     Film                    Link        Born  \\\n",
       "0  The Last Command, The Way of All Flesh     /wiki/Emil_Jannings  1884-07-23   \n",
       "1                          In Old Arizona     /wiki/Warner_Baxter  1889-03-29   \n",
       "2                                Disraeli     /wiki/George_Arliss  1868-04-10   \n",
       "3                             A Free Soul  /wiki/Lionel_Barrymore  1878-04-28   \n",
       "4                               The Champ     /wiki/Wallace_Beery  1885-04-01   \n",
       "\n",
       "         Died                        Birthplace  \\\n",
       "0  1950-01-02            Rorschach, Switzerland   \n",
       "1  1951-05-07              Columbus, Ohio, U.S.   \n",
       "2  1946-02-05                   London, England   \n",
       "3  1954-11-15  Philadelphia, Pennsylvania, U.S.   \n",
       "4  1949-04-15       Clay County, Missouri, U.S.   \n",
       "\n",
       "                        Deathplace Children  \n",
       "0  Strobl, Allied-occupied Austria        1  \n",
       "1  Beverly Hills, California, U.S.        0  \n",
       "2                  London, England        0  \n",
       "3    Los Angeles, California, U.S.        2  \n",
       "4  Beverly Hills, California, U.S.        1  "
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Year'] = award_dates\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "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>Year</th>\n",
       "      <th>ActorID</th>\n",
       "      <th>Actor</th>\n",
       "      <th>Role(s)</th>\n",
       "      <th>Film</th>\n",
       "      <th>Link</th>\n",
       "      <th>Born</th>\n",
       "      <th>Died</th>\n",
       "      <th>Birthplace</th>\n",
       "      <th>Deathplace</th>\n",
       "      <th>Children</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>November 18, 1932</td>\n",
       "      <td>4</td>\n",
       "      <td>Wallace Beery</td>\n",
       "      <td>Andy \"Champ\" Purcell</td>\n",
       "      <td>The Champ</td>\n",
       "      <td>/wiki/Wallace_Beery</td>\n",
       "      <td>1885-04-01</td>\n",
       "      <td>1949-04-15</td>\n",
       "      <td>Clay County, Missouri, U.S.</td>\n",
       "      <td>Beverly Hills, California, U.S.</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>November 18, 1932</td>\n",
       "      <td>5</td>\n",
       "      <td>Fredric March</td>\n",
       "      <td>Dr. Henry Jekyll / Mr. Edward Hyde</td>\n",
       "      <td>Dr. Jekyll and Mr. Hyde</td>\n",
       "      <td>/wiki/Fredric_March</td>\n",
       "      <td>1897-08-31</td>\n",
       "      <td>1975-04-14</td>\n",
       "      <td>Racine, Wisconsin, U.S.</td>\n",
       "      <td>Los Angeles, California, U.S.</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>March 13, 1947</td>\n",
       "      <td>5</td>\n",
       "      <td>Fredric March</td>\n",
       "      <td>Platoon Sergeant Al Stephenson</td>\n",
       "      <td>The Best Years of Our Lives</td>\n",
       "      <td>/wiki/Fredric_March</td>\n",
       "      <td>1897-08-31</td>\n",
       "      <td>1975-04-14</td>\n",
       "      <td>Racine, Wisconsin, U.S.</td>\n",
       "      <td>Los Angeles, California, U.S.</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Year  ActorID          Actor  \\\n",
       "4   November 18, 1932        4  Wallace Beery   \n",
       "5   November 18, 1932        5  Fredric March   \n",
       "19     March 13, 1947        5  Fredric March   \n",
       "\n",
       "                               Role(s)                         Film  \\\n",
       "4                 Andy \"Champ\" Purcell                    The Champ   \n",
       "5   Dr. Henry Jekyll / Mr. Edward Hyde      Dr. Jekyll and Mr. Hyde   \n",
       "19      Platoon Sergeant Al Stephenson  The Best Years of Our Lives   \n",
       "\n",
       "                   Link        Born        Died                   Birthplace  \\\n",
       "4   /wiki/Wallace_Beery  1885-04-01  1949-04-15  Clay County, Missouri, U.S.   \n",
       "5   /wiki/Fredric_March  1897-08-31  1975-04-14      Racine, Wisconsin, U.S.   \n",
       "19  /wiki/Fredric_March  1897-08-31  1975-04-14      Racine, Wisconsin, U.S.   \n",
       "\n",
       "                         Deathplace Children  \n",
       "4   Beverly Hills, California, U.S.        1  \n",
       "5     Los Angeles, California, U.S.        2  \n",
       "19    Los Angeles, California, U.S.        2  "
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[df['Actor'].isin(['Wallace Beery', 'Fredric March'])]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "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>Date</th>\n",
       "      <th>ActorID</th>\n",
       "      <th>Actor</th>\n",
       "      <th>Role(s)</th>\n",
       "      <th>Film</th>\n",
       "      <th>Link</th>\n",
       "      <th>Born</th>\n",
       "      <th>Died</th>\n",
       "      <th>Birthplace</th>\n",
       "      <th>Deathplace</th>\n",
       "      <th>Children</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>May 16, 1929</td>\n",
       "      <td>0</td>\n",
       "      <td>Emil Jannings</td>\n",
       "      <td>Grand Duke Sergius Alexander, August Schilling</td>\n",
       "      <td>The Last Command, The Way of All Flesh</td>\n",
       "      <td>/wiki/Emil_Jannings</td>\n",
       "      <td>1884-07-23</td>\n",
       "      <td>1950-01-02</td>\n",
       "      <td>Rorschach, Switzerland</td>\n",
       "      <td>Strobl, Allied-occupied Austria</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           Date  ActorID          Actor  \\\n",
       "0  May 16, 1929        0  Emil Jannings   \n",
       "\n",
       "                                          Role(s)  \\\n",
       "0  Grand Duke Sergius Alexander, August Schilling   \n",
       "\n",
       "                                     Film                 Link        Born  \\\n",
       "0  The Last Command, The Way of All Flesh  /wiki/Emil_Jannings  1884-07-23   \n",
       "\n",
       "         Died              Birthplace                       Deathplace  \\\n",
       "0  1950-01-02  Rorschach, Switzerland  Strobl, Allied-occupied Austria   \n",
       "\n",
       "  Children  \n",
       "0        1  "
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.rename(columns={'Year': 'Date'}, inplace=True)\n",
    "df.head(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['Date'] = pd.to_datetime(df['Date'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv('data/awards.csv')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": ".venv",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.12.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}