Parse wikipedia.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<!DOCTYPE html>\n",
      "<html class=\"client-nojs\" dir=\"ltr\" lang=\"en\">\n",
      " <head>\n",
      "  <meta charset=\"utf-8\"/>\n",
      "  <title>\n",
      "   List of highest-grossing films - Wikipedia\n",
      "  </title>\n",
      "  <script>\n",
      "   document.documentElement.className=\"client-js\";RLCONF={\"wgBreakFrames\":!1,\"wgSeparatorTransformTable\":[\"\",\"\"],\"wgDigitTransformTable\":[\"\",\"\"],\"wgDefaultDateFormat\":\"dmy\",\"wgMonthNames\":[\"\",\"January\",\"February\",\"March\",\"April\",\"May\",\"June\",\"July\",\"August\",\"September\",\"October\",\"November\",\"December\"],\"wgRequestId\":\"a91edc8b-fe31-46b2-82a2-16cbb24a5e94\",\"wgCSPNonce\":!1,\"wgCanonicalNamespace\":\"\",\"wgCanonicalSpecialPageName\":!1,\"wgNamespaceNumber\":0,\"wgPageName\":\"List_of_highest-grossing_films\",\"wgTitle\":\"List of highest-grossing films\",\"wgCurRevisionId\":961013473,\"wgRevisionId\":961013473,\"wgArticleId\":59892,\"wgIsArticle\":!0,\"wgIsRedirect\":!1,\"wgAction\":\"view\",\"wgUserName\":null,\"wgUserGroups\":[\"*\"],\"wgCategories\":[\"CS1 uses Russian-language script (ru)\",\"CS1 Russian-\n"
     ]
    }
   ],
   "source": [
    "# Documentation: https://www.crummy.com/software/BeautifulSoup/bs4/doc/\n",
    "\n",
    "from bs4 import BeautifulSoup\n",
    "import requests\n",
    "\n",
    "page = requests.get(\"https://en.wikipedia.org/wiki/List_of_highest-grossing_films\")\n",
    "\n",
    "soup = BeautifulSoup(page.content)\n",
    "\n",
    "# Print the first 950 chars of the page.\n",
    "print(soup.prettify()[:950])\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "List of highest-grossing films - Wikipedia\n"
     ]
    }
   ],
   "source": [
    "print(soup.title.string)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[('1', 'Avengers: Endgame', '/wiki/Avengers:_Endgame', '$2,797,800,564', '2019'), ('2', 'Avatar', '/wiki/Avatar_(2009_film)', '$2,790,439,000', '2009'), ('3', 'Titanic', '/wiki/Titanic_(1997_film)', '$2,194,439,542', '1997'), ('4', 'Star Wars: The Force Awakens', '/wiki/Star_Wars:_The_Force_Awakens', '$2,068,223,624', '2015'), ('5', 'Avengers: Infinity War', '/wiki/Avengers:_Infinity_War', '$2,048,359,754', '2018'), ('6', 'Jurassic World', '/wiki/Jurassic_World', '$1,671,713,208', '2015'), ('7', 'The Lion King', '/wiki/The_Lion_King_(2019_film)', '$1,656,943,394', '2019'), ('8', 'The Avengers', '/wiki/The_Avengers_(2012_film)', '$1,518,812,988', '2012'), ('9', 'Furious 7', '/wiki/Furious_7', '$1,516,045,911', '2015'), ('10', 'Frozen II', '/wiki/Frozen_II', '$1,450,026,933', '2019'), ('11', 'Avengers: Age of Ultron', '/wiki/Avengers:_Age_of_Ultron', '$1,402,805,868', '2015'), ('12', 'Black Panther', '/wiki/Black_Panther_(film)', '$1,346,913,161', '2018'), ('13', 'Harry Potter and the Deathly Hallows – Part 2', '/wiki/Harry_Potter_and_the_Deathly_Hallows_%E2%80%93_Part_2', '$1,341,693,157', '2011'), ('14', 'Star Wars: The Last Jedi', '/wiki/Star_Wars:_The_Last_Jedi', '$1,332,539,889', '2017'), ('15', 'Jurassic World: Fallen Kingdom', '/wiki/Jurassic_World:_Fallen_Kingdom', '$1,309,484,461', '2018'), ('16', 'Frozen', '/wiki/Frozen_(2013_film)', 'F$1,290,000,000', '2013'), ('17', 'Beauty and the Beast', '/wiki/Beauty_and_the_Beast_(2017_film)', '$1,263,521,126', '2017'), ('18', 'Incredibles 2', '/wiki/Incredibles_2', '$1,242,805,359', '2018'), ('19', 'The Fate of the Furious', '/wiki/The_Fate_of_the_Furious', 'F8$1,238,764,765', '2017'), ('20', 'Iron Man 3', '/wiki/Iron_Man_3', '$1,214,811,252', '2013'), ('21', 'Minions', '/wiki/Minions_(film)', '$1,159,398,397', '2015'), ('22', 'Captain America: Civil War', '/wiki/Captain_America:_Civil_War', '$1,153,304,495', '2016'), ('23', 'Aquaman', '/wiki/Aquaman_(film)', '$1,148,161,807', '2018'), ('24', 'The Lord of the Rings: The Return of the King', '/wiki/The_Lord_of_the_Rings:_The_Return_of_the_King', '$1,142,219,401', '2003'), ('25', 'Spider-Man: Far From Home', '/wiki/Spider-Man:_Far_From_Home', '$1,131,927,996', '2019'), ('26', 'Captain Marvel', '/wiki/Captain_Marvel_(film)', '$1,128,274,794', '2019'), ('27', 'Transformers: Dark of the Moon', '/wiki/Transformers:_Dark_of_the_Moon', '$1,123,794,079', '2011'), ('28', 'Skyfall', '/wiki/Skyfall', '$1,108,561,013', '2012'), ('29', 'Transformers: Age of Extinction', '/wiki/Transformers:_Age_of_Extinction', '$1,104,054,072', '2014'), ('30', 'The Dark Knight Rises', '/wiki/The_Dark_Knight_Rises', '$1,084,939,099', '2012'), ('31', 'Joker', '/wiki/Joker_(2019_film)', '$1,074,251,311', '2019'), ('32', 'Star Wars: The Rise of Skywalker', '/wiki/Star_Wars:_The_Rise_of_Skywalker', '$1,074,144,248', '2019'), ('33', 'Toy Story 4', '/wiki/Toy_Story_4', '$1,073,394,593', '2019'), ('34', 'Toy Story 3', '/wiki/Toy_Story_3', '$1,066,969,703', '2010'), ('35', \"Pirates of the Caribbean: Dead Man's Chest\", '/wiki/Pirates_of_the_Caribbean:_Dead_Man%27s_Chest', '$1,066,179,725', '2006'), ('36', 'Rogue One: A Star Wars Story', '/wiki/Rogue_One:_A_Star_Wars_Story', '$1,056,057,273', '2016'), ('37', 'Aladdin', '/wiki/Aladdin_(2019_film)', '$1,050,693,953', '2019'), ('38', 'Pirates of the Caribbean: On Stranger Tides', '/wiki/Pirates_of_the_Caribbean:_On_Stranger_Tides', '$1,045,713,802', '2011'), ('39', 'Despicable Me 3', '/wiki/Despicable_Me_3', '$1,034,799,409', '2017'), ('40', 'Jurassic Park', '/wiki/Jurassic_Park_(film)', '$1,029,939,903', '1993'), ('41', 'Finding Dory', '/wiki/Finding_Dory', '$1,028,570,889', '2016'), ('42', 'Star Wars: Episode I – The Phantom Menace', '/wiki/Star_Wars:_Episode_I_%E2%80%93_The_Phantom_Menace', '$1,027,044,677', '1999'), ('43', 'Alice in Wonderland', '/wiki/Alice_in_Wonderland_(2010_film)', '$1,025,467,110', '2010'), ('44', 'Zootopia', '/wiki/Zootopia', '$1,023,784,195', '2016'), ('45', 'The Hobbit: An Unexpected Journey', '/wiki/The_Hobbit:_An_Unexpected_Journey', '$1,021,103,568', '2012'), ('46', 'The Dark Knight', '/wiki/The_Dark_Knight_(film)', '$1,004,934,033', '2008'), ('47', \"Harry Potter and the Philosopher's Stone\", '/wiki/Harry_Potter_and_the_Philosopher%27s_Stone_(film)', '$975,051,288', '2001'), ('48', 'Despicable Me 2', '/wiki/Despicable_Me_2', '$970,761,885', '2013'), ('49', 'The Lion King', '/wiki/The_Lion_King', '$968,483,777', '1994'), ('50', 'The Jungle Book', '/wiki/The_Jungle_Book_(2016_film)', '$966,550,600', '2016')]\n"
     ]
    }
   ],
   "source": [
    "film_table = soup.find(\"table\", class_=\"wikitable\")\n",
    "\n",
    "def clean_string(string):\n",
    "    if(string):\n",
    "        cleaned_string = string.replace('\\n', ' ').replace('\\r', '').strip();\n",
    "        return cleaned_string;\n",
    "\n",
    "    return string;\n",
    "\n",
    "\n",
    "all_results = [] #add at end\n",
    "\n",
    "\n",
    "for row in film_table.find_all(\"tr\"):\n",
    "    columns = row.find_all([\"td\", \"th\"])\n",
    "    if(columns[0].get(\"scope\")):\n",
    "        continue\n",
    "    rank = clean_string(columns[0].text)\n",
    "    \n",
    "    \n",
    "    title = clean_string(columns[2].text)\n",
    "\n",
    "    link_to_detail = columns[2].find(\"a\")['href']\n",
    "    \n",
    "    gross = clean_string(columns[3].text)\n",
    "    \n",
    "    year = clean_string(columns[4].text)\n",
    "    \n",
    "    result = (rank, title, link_to_detail, gross, year)\n",
    "    all_results.append(result)\n",
    "\n",
    "    \n",
    "print(all_results)\n",
    "\n"
   ]
  },
  {
   "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>Rank</th>\n",
       "      <th>Film</th>\n",
       "      <th>link</th>\n",
       "      <th>Worldwide gross ($USD)</th>\n",
       "      <th>Year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Avengers: Endgame</td>\n",
       "      <td>/wiki/Avengers:_Endgame</td>\n",
       "      <td>$2,797,800,564</td>\n",
       "      <td>2019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Avatar</td>\n",
       "      <td>/wiki/Avatar_(2009_film)</td>\n",
       "      <td>$2,790,439,000</td>\n",
       "      <td>2009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Titanic</td>\n",
       "      <td>/wiki/Titanic_(1997_film)</td>\n",
       "      <td>$2,194,439,542</td>\n",
       "      <td>1997</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Star Wars: The Force Awakens</td>\n",
       "      <td>/wiki/Star_Wars:_The_Force_Awakens</td>\n",
       "      <td>$2,068,223,624</td>\n",
       "      <td>2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Avengers: Infinity War</td>\n",
       "      <td>/wiki/Avengers:_Infinity_War</td>\n",
       "      <td>$2,048,359,754</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Rank                          Film                                link  \\\n",
       "0    1             Avengers: Endgame             /wiki/Avengers:_Endgame   \n",
       "1    2                        Avatar            /wiki/Avatar_(2009_film)   \n",
       "2    3                       Titanic           /wiki/Titanic_(1997_film)   \n",
       "3    4  Star Wars: The Force Awakens  /wiki/Star_Wars:_The_Force_Awakens   \n",
       "4    5        Avengers: Infinity War        /wiki/Avengers:_Infinity_War   \n",
       "\n",
       "  Worldwide gross ($USD)  Year  \n",
       "0         $2,797,800,564  2019  \n",
       "1         $2,790,439,000  2009  \n",
       "2         $2,194,439,542  1997  \n",
       "3         $2,068,223,624  2015  \n",
       "4         $2,048,359,754  2018  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "df = pd.DataFrame(all_results, columns=['Rank', 'Film', 'link', 'Worldwide gross ($USD)', \"Year\"])\n",
    "\n",
    "df.head() # can remove rank here."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "def from_details_get_description(soup):\n",
    "    main_content = soup.find(class_=\"mw-parser-output\")\n",
    "    description = \"\"\n",
    "    for child in main_content.children:\n",
    "        if(child.name == \"p\"):\n",
    "            description+= \"\\n\" + child.text\n",
    "        if(child.name == \"h2\"):\n",
    "            break\n",
    "    description = description.strip()\n",
    "    return description\n",
    "\n",
    "\n",
    "\n",
    "def from_details_get_director(soup):\n",
    "    main_content = soup.find(class_=\"infobox\")\n",
    "    table_rows = main_content.find_all(\"tr\")\n",
    "\n",
    "    for row in table_rows:\n",
    "        header = row.find('th')\n",
    "        if(header and header.text == \"Directed by\"):\n",
    "            column  = row.find('td')\n",
    "            director = clean_string(column.text)\n",
    "            return director\n",
    "    \n",
    "\n",
    "\n",
    "\n",
    "def get_film_details(film_url):\n",
    "    \n",
    "    page = requests.get(\"https://en.wikipedia.org/\" + film_url)\n",
    "\n",
    "    soup = BeautifulSoup(page.content)\n",
    "    \n",
    "    description = from_details_get_description(soup);\n",
    "#     print(description)\n",
    "\n",
    "    director = from_details_get_director(soup);\n",
    "#     print(director)\n",
    "    return (description, director)\n",
    "    \n",
    "        \n",
    "        \n",
    "\n",
    "    \n",
    "result = df['link'].sample(2).map(get_film_details)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "from time import perf_counter "
   ]
  },
  {
   "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>Rank</th>\n",
       "      <th>Film</th>\n",
       "      <th>link</th>\n",
       "      <th>Worldwide gross ($USD)</th>\n",
       "      <th>Year</th>\n",
       "      <th>description</th>\n",
       "      <th>director</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Avengers: Endgame</td>\n",
       "      <td>/wiki/Avengers:_Endgame</td>\n",
       "      <td>$2,797,800,564</td>\n",
       "      <td>2019</td>\n",
       "      <td>Avengers: Endgame is a 2019 American superhero...</td>\n",
       "      <td>Anthony RussoJoe Russo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Avatar</td>\n",
       "      <td>/wiki/Avatar_(2009_film)</td>\n",
       "      <td>$2,790,439,000</td>\n",
       "      <td>2009</td>\n",
       "      <td>Avatar (marketed as James Cameron's Avatar) is...</td>\n",
       "      <td>James Cameron</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Titanic</td>\n",
       "      <td>/wiki/Titanic_(1997_film)</td>\n",
       "      <td>$2,194,439,542</td>\n",
       "      <td>1997</td>\n",
       "      <td>Titanic is a 1997 American epic romance and di...</td>\n",
       "      <td>James Cameron</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Star Wars: The Force Awakens</td>\n",
       "      <td>/wiki/Star_Wars:_The_Force_Awakens</td>\n",
       "      <td>$2,068,223,624</td>\n",
       "      <td>2015</td>\n",
       "      <td>Star Wars: The Force Awakens (also known as St...</td>\n",
       "      <td>J. J. Abrams</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Avengers: Infinity War</td>\n",
       "      <td>/wiki/Avengers:_Infinity_War</td>\n",
       "      <td>$2,048,359,754</td>\n",
       "      <td>2018</td>\n",
       "      <td>Avengers: Infinity War is a 2018 American supe...</td>\n",
       "      <td>Anthony RussoJoe Russo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>Jurassic World</td>\n",
       "      <td>/wiki/Jurassic_World</td>\n",
       "      <td>$1,671,713,208</td>\n",
       "      <td>2015</td>\n",
       "      <td>Jurassic World is a 2015 American science fict...</td>\n",
       "      <td>Colin Trevorrow</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>The Lion King</td>\n",
       "      <td>/wiki/The_Lion_King_(2019_film)</td>\n",
       "      <td>$1,656,943,394</td>\n",
       "      <td>2019</td>\n",
       "      <td>The Lion King is a 2019 American musical drama...</td>\n",
       "      <td>Jon Favreau</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>The Avengers</td>\n",
       "      <td>/wiki/The_Avengers_(2012_film)</td>\n",
       "      <td>$1,518,812,988</td>\n",
       "      <td>2012</td>\n",
       "      <td>Marvel's The Avengers[6] (classified under the...</td>\n",
       "      <td>Joss Whedon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>Furious 7</td>\n",
       "      <td>/wiki/Furious_7</td>\n",
       "      <td>$1,516,045,911</td>\n",
       "      <td>2015</td>\n",
       "      <td>Furious 7 (titled onscreen and other territori...</td>\n",
       "      <td>James Wan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>Frozen II</td>\n",
       "      <td>/wiki/Frozen_II</td>\n",
       "      <td>$1,450,026,933</td>\n",
       "      <td>2019</td>\n",
       "      <td>Frozen II, also known as Frozen 2, is a 2019 A...</td>\n",
       "      <td>Chris Buck Jennifer Lee</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>Avengers: Age of Ultron</td>\n",
       "      <td>/wiki/Avengers:_Age_of_Ultron</td>\n",
       "      <td>$1,402,805,868</td>\n",
       "      <td>2015</td>\n",
       "      <td>Avengers: Age of Ultron is a 2015 American sup...</td>\n",
       "      <td>Joss Whedon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>Black Panther</td>\n",
       "      <td>/wiki/Black_Panther_(film)</td>\n",
       "      <td>$1,346,913,161</td>\n",
       "      <td>2018</td>\n",
       "      <td>Black Panther is a 2018 American superhero fil...</td>\n",
       "      <td>Ryan Coogler</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>Harry Potter and the Deathly Hallows – Part 2</td>\n",
       "      <td>/wiki/Harry_Potter_and_the_Deathly_Hallows_%E2...</td>\n",
       "      <td>$1,341,693,157</td>\n",
       "      <td>2011</td>\n",
       "      <td>Harry Potter and the Deathly Hallows – Part 2 ...</td>\n",
       "      <td>David Yates</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14</td>\n",
       "      <td>Star Wars: The Last Jedi</td>\n",
       "      <td>/wiki/Star_Wars:_The_Last_Jedi</td>\n",
       "      <td>$1,332,539,889</td>\n",
       "      <td>2017</td>\n",
       "      <td>Star Wars: The Last Jedi (also known as Star W...</td>\n",
       "      <td>Rian Johnson</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15</td>\n",
       "      <td>Jurassic World: Fallen Kingdom</td>\n",
       "      <td>/wiki/Jurassic_World:_Fallen_Kingdom</td>\n",
       "      <td>$1,309,484,461</td>\n",
       "      <td>2018</td>\n",
       "      <td>Jurassic World: Fallen Kingdom is a 2018 Ameri...</td>\n",
       "      <td>J. A. Bayona</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16</td>\n",
       "      <td>Frozen</td>\n",
       "      <td>/wiki/Frozen_(2013_film)</td>\n",
       "      <td>F$1,290,000,000</td>\n",
       "      <td>2013</td>\n",
       "      <td>Frozen is a 2013 American 3D computer-animated...</td>\n",
       "      <td>Chris Buck Jennifer Lee</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>17</td>\n",
       "      <td>Beauty and the Beast</td>\n",
       "      <td>/wiki/Beauty_and_the_Beast_(2017_film)</td>\n",
       "      <td>$1,263,521,126</td>\n",
       "      <td>2017</td>\n",
       "      <td>Beauty and the Beast is a 2017 American musica...</td>\n",
       "      <td>Bill Condon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18</td>\n",
       "      <td>Incredibles 2</td>\n",
       "      <td>/wiki/Incredibles_2</td>\n",
       "      <td>$1,242,805,359</td>\n",
       "      <td>2018</td>\n",
       "      <td>Incredibles 2 is a 2018 American computer-anim...</td>\n",
       "      <td>Brad Bird</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>19</td>\n",
       "      <td>The Fate of the Furious</td>\n",
       "      <td>/wiki/The_Fate_of_the_Furious</td>\n",
       "      <td>F8$1,238,764,765</td>\n",
       "      <td>2017</td>\n",
       "      <td>The Fate of the Furious (alternatively known a...</td>\n",
       "      <td>F. Gary Gray</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>20</td>\n",
       "      <td>Iron Man 3</td>\n",
       "      <td>/wiki/Iron_Man_3</td>\n",
       "      <td>$1,214,811,252</td>\n",
       "      <td>2013</td>\n",
       "      <td>Iron Man 3 is a 2013 American superhero film b...</td>\n",
       "      <td>Shane Black</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>21</td>\n",
       "      <td>Minions</td>\n",
       "      <td>/wiki/Minions_(film)</td>\n",
       "      <td>$1,159,398,397</td>\n",
       "      <td>2015</td>\n",
       "      <td>Minions is a 2015 American 3D computer-animate...</td>\n",
       "      <td>Pierre Coffin Kyle Balda</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22</td>\n",
       "      <td>Captain America: Civil War</td>\n",
       "      <td>/wiki/Captain_America:_Civil_War</td>\n",
       "      <td>$1,153,304,495</td>\n",
       "      <td>2016</td>\n",
       "      <td>Captain America: Civil War is a 2016 American ...</td>\n",
       "      <td>Anthony RussoJoe Russo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>23</td>\n",
       "      <td>Aquaman</td>\n",
       "      <td>/wiki/Aquaman_(film)</td>\n",
       "      <td>$1,148,161,807</td>\n",
       "      <td>2018</td>\n",
       "      <td>Aquaman is a 2018 American superhero film base...</td>\n",
       "      <td>James Wan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>24</td>\n",
       "      <td>The Lord of the Rings: The Return of the King</td>\n",
       "      <td>/wiki/The_Lord_of_the_Rings:_The_Return_of_the...</td>\n",
       "      <td>$1,142,219,401</td>\n",
       "      <td>2003</td>\n",
       "      <td>The Lord of the Rings: The Return of the King ...</td>\n",
       "      <td>Peter Jackson</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>25</td>\n",
       "      <td>Spider-Man: Far From Home</td>\n",
       "      <td>/wiki/Spider-Man:_Far_From_Home</td>\n",
       "      <td>$1,131,927,996</td>\n",
       "      <td>2019</td>\n",
       "      <td>Spider-Man: Far From Home is a 2019 American s...</td>\n",
       "      <td>Jon Watts</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>26</td>\n",
       "      <td>Captain Marvel</td>\n",
       "      <td>/wiki/Captain_Marvel_(film)</td>\n",
       "      <td>$1,128,274,794</td>\n",
       "      <td>2019</td>\n",
       "      <td>Captain Marvel is a 2019 American superhero fi...</td>\n",
       "      <td>Anna BodenRyan Fleck</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>27</td>\n",
       "      <td>Transformers: Dark of the Moon</td>\n",
       "      <td>/wiki/Transformers:_Dark_of_the_Moon</td>\n",
       "      <td>$1,123,794,079</td>\n",
       "      <td>2011</td>\n",
       "      <td>Transformers: Dark of the Moon is a 2011 Ameri...</td>\n",
       "      <td>Michael Bay</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>28</td>\n",
       "      <td>Skyfall</td>\n",
       "      <td>/wiki/Skyfall</td>\n",
       "      <td>$1,108,561,013</td>\n",
       "      <td>2012</td>\n",
       "      <td>Skyfall is a 2012 spy film and the twenty-thir...</td>\n",
       "      <td>Sam Mendes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>29</td>\n",
       "      <td>Transformers: Age of Extinction</td>\n",
       "      <td>/wiki/Transformers:_Age_of_Extinction</td>\n",
       "      <td>$1,104,054,072</td>\n",
       "      <td>2014</td>\n",
       "      <td>Transformers: Age of Extinction is a 2014 Amer...</td>\n",
       "      <td>Michael Bay</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>30</td>\n",
       "      <td>The Dark Knight Rises</td>\n",
       "      <td>/wiki/The_Dark_Knight_Rises</td>\n",
       "      <td>$1,084,939,099</td>\n",
       "      <td>2012</td>\n",
       "      <td>The Dark Knight Rises is a 2012 superhero film...</td>\n",
       "      <td>Christopher Nolan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>31</td>\n",
       "      <td>Joker</td>\n",
       "      <td>/wiki/Joker_(2019_film)</td>\n",
       "      <td>$1,074,251,311</td>\n",
       "      <td>2019</td>\n",
       "      <td>Joker is a 2019 American psychological thrille...</td>\n",
       "      <td>Todd Phillips</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>32</td>\n",
       "      <td>Star Wars: The Rise of Skywalker</td>\n",
       "      <td>/wiki/Star_Wars:_The_Rise_of_Skywalker</td>\n",
       "      <td>$1,074,144,248</td>\n",
       "      <td>2019</td>\n",
       "      <td>Star Wars: The Rise of Skywalker (also known a...</td>\n",
       "      <td>J. J. Abrams</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>33</td>\n",
       "      <td>Toy Story 4</td>\n",
       "      <td>/wiki/Toy_Story_4</td>\n",
       "      <td>$1,073,394,593</td>\n",
       "      <td>2019</td>\n",
       "      <td>Toy Story 4 is a 2019 American computer-animat...</td>\n",
       "      <td>Josh Cooley</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>34</td>\n",
       "      <td>Toy Story 3</td>\n",
       "      <td>/wiki/Toy_Story_3</td>\n",
       "      <td>$1,066,969,703</td>\n",
       "      <td>2010</td>\n",
       "      <td>Toy Story 3 is a  2010 American computer-anima...</td>\n",
       "      <td>Lee Unkrich</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>35</td>\n",
       "      <td>Pirates of the Caribbean: Dead Man's Chest</td>\n",
       "      <td>/wiki/Pirates_of_the_Caribbean:_Dead_Man%27s_C...</td>\n",
       "      <td>$1,066,179,725</td>\n",
       "      <td>2006</td>\n",
       "      <td>Pirates of the Caribbean: Dead Man's Chest is ...</td>\n",
       "      <td>Gore Verbinski</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>36</td>\n",
       "      <td>Rogue One: A Star Wars Story</td>\n",
       "      <td>/wiki/Rogue_One:_A_Star_Wars_Story</td>\n",
       "      <td>$1,056,057,273</td>\n",
       "      <td>2016</td>\n",
       "      <td>Rogue One: A Star Wars Story (or simply Rogue ...</td>\n",
       "      <td>Gareth Edwards</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>37</td>\n",
       "      <td>Aladdin</td>\n",
       "      <td>/wiki/Aladdin_(2019_film)</td>\n",
       "      <td>$1,050,693,953</td>\n",
       "      <td>2019</td>\n",
       "      <td>Aladdin is a 2019 American musical fantasy fil...</td>\n",
       "      <td>Guy Ritchie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>38</td>\n",
       "      <td>Pirates of the Caribbean: On Stranger Tides</td>\n",
       "      <td>/wiki/Pirates_of_the_Caribbean:_On_Stranger_Tides</td>\n",
       "      <td>$1,045,713,802</td>\n",
       "      <td>2011</td>\n",
       "      <td>Pirates of the Caribbean: On Stranger Tides (r...</td>\n",
       "      <td>Rob Marshall</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>39</td>\n",
       "      <td>Despicable Me 3</td>\n",
       "      <td>/wiki/Despicable_Me_3</td>\n",
       "      <td>$1,034,799,409</td>\n",
       "      <td>2017</td>\n",
       "      <td>Despicable Me 3 is a 2017 American computer-an...</td>\n",
       "      <td>Pierre Coffin Kyle Balda</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>40</td>\n",
       "      <td>Jurassic Park</td>\n",
       "      <td>/wiki/Jurassic_Park_(film)</td>\n",
       "      <td>$1,029,939,903</td>\n",
       "      <td>1993</td>\n",
       "      <td>Jurassic Park is a 1993 American science ficti...</td>\n",
       "      <td>Steven Spielberg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>41</td>\n",
       "      <td>Finding Dory</td>\n",
       "      <td>/wiki/Finding_Dory</td>\n",
       "      <td>$1,028,570,889</td>\n",
       "      <td>2016</td>\n",
       "      <td>Finding Dory is a 2016 American 3D computer-an...</td>\n",
       "      <td>Andrew Stanton</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>42</td>\n",
       "      <td>Star Wars: Episode I – The Phantom Menace</td>\n",
       "      <td>/wiki/Star_Wars:_Episode_I_%E2%80%93_The_Phant...</td>\n",
       "      <td>$1,027,044,677</td>\n",
       "      <td>1999</td>\n",
       "      <td>Star Wars: Episode I – The Phantom Menace is a...</td>\n",
       "      <td>George Lucas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>43</td>\n",
       "      <td>Alice in Wonderland</td>\n",
       "      <td>/wiki/Alice_in_Wonderland_(2010_film)</td>\n",
       "      <td>$1,025,467,110</td>\n",
       "      <td>2010</td>\n",
       "      <td>Alice in Wonderland is a 2010 American dark fa...</td>\n",
       "      <td>Tim Burton</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>44</td>\n",
       "      <td>Zootopia</td>\n",
       "      <td>/wiki/Zootopia</td>\n",
       "      <td>$1,023,784,195</td>\n",
       "      <td>2016</td>\n",
       "      <td>Zootopia (titled Zootropolis in the UK)[6] is ...</td>\n",
       "      <td>Byron Howard Rich Moore</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>45</td>\n",
       "      <td>The Hobbit: An Unexpected Journey</td>\n",
       "      <td>/wiki/The_Hobbit:_An_Unexpected_Journey</td>\n",
       "      <td>$1,021,103,568</td>\n",
       "      <td>2012</td>\n",
       "      <td>The Hobbit: An Unexpected Journey is a 2012 ep...</td>\n",
       "      <td>Peter Jackson</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>46</td>\n",
       "      <td>The Dark Knight</td>\n",
       "      <td>/wiki/The_Dark_Knight_(film)</td>\n",
       "      <td>$1,004,934,033</td>\n",
       "      <td>2008</td>\n",
       "      <td>The Dark Knight is a 2008 superhero film direc...</td>\n",
       "      <td>Christopher Nolan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>47</td>\n",
       "      <td>Harry Potter and the Philosopher's Stone</td>\n",
       "      <td>/wiki/Harry_Potter_and_the_Philosopher%27s_Sto...</td>\n",
       "      <td>$975,051,288</td>\n",
       "      <td>2001</td>\n",
       "      <td>Harry Potter and the Philosopher's Stone (rele...</td>\n",
       "      <td>Chris Columbus</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>48</td>\n",
       "      <td>Despicable Me 2</td>\n",
       "      <td>/wiki/Despicable_Me_2</td>\n",
       "      <td>$970,761,885</td>\n",
       "      <td>2013</td>\n",
       "      <td>Despicable Me 2 is a 2013 American computer-an...</td>\n",
       "      <td>Chris RenaudPierre Coffin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>49</td>\n",
       "      <td>The Lion King</td>\n",
       "      <td>/wiki/The_Lion_King</td>\n",
       "      <td>$968,483,777</td>\n",
       "      <td>1994</td>\n",
       "      <td>The Lion King is a 1994 American animated musi...</td>\n",
       "      <td>Roger AllersRob Minkoff</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>50</td>\n",
       "      <td>The Jungle Book</td>\n",
       "      <td>/wiki/The_Jungle_Book_(2016_film)</td>\n",
       "      <td>$966,550,600</td>\n",
       "      <td>2016</td>\n",
       "      <td>The Jungle Book is  2016 American fantasy adve...</td>\n",
       "      <td>Jon Favreau</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Rank                                           Film  \\\n",
       "0     1                              Avengers: Endgame   \n",
       "1     2                                         Avatar   \n",
       "2     3                                        Titanic   \n",
       "3     4                   Star Wars: The Force Awakens   \n",
       "4     5                         Avengers: Infinity War   \n",
       "5     6                                 Jurassic World   \n",
       "6     7                                  The Lion King   \n",
       "7     8                                   The Avengers   \n",
       "8     9                                      Furious 7   \n",
       "9    10                                      Frozen II   \n",
       "10   11                        Avengers: Age of Ultron   \n",
       "11   12                                  Black Panther   \n",
       "12   13  Harry Potter and the Deathly Hallows – Part 2   \n",
       "13   14                       Star Wars: The Last Jedi   \n",
       "14   15                 Jurassic World: Fallen Kingdom   \n",
       "15   16                                         Frozen   \n",
       "16   17                           Beauty and the Beast   \n",
       "17   18                                  Incredibles 2   \n",
       "18   19                        The Fate of the Furious   \n",
       "19   20                                     Iron Man 3   \n",
       "20   21                                        Minions   \n",
       "21   22                     Captain America: Civil War   \n",
       "22   23                                        Aquaman   \n",
       "23   24  The Lord of the Rings: The Return of the King   \n",
       "24   25                      Spider-Man: Far From Home   \n",
       "25   26                                 Captain Marvel   \n",
       "26   27                 Transformers: Dark of the Moon   \n",
       "27   28                                        Skyfall   \n",
       "28   29                Transformers: Age of Extinction   \n",
       "29   30                          The Dark Knight Rises   \n",
       "30   31                                          Joker   \n",
       "31   32               Star Wars: The Rise of Skywalker   \n",
       "32   33                                    Toy Story 4   \n",
       "33   34                                    Toy Story 3   \n",
       "34   35     Pirates of the Caribbean: Dead Man's Chest   \n",
       "35   36                   Rogue One: A Star Wars Story   \n",
       "36   37                                        Aladdin   \n",
       "37   38    Pirates of the Caribbean: On Stranger Tides   \n",
       "38   39                                Despicable Me 3   \n",
       "39   40                                  Jurassic Park   \n",
       "40   41                                   Finding Dory   \n",
       "41   42      Star Wars: Episode I – The Phantom Menace   \n",
       "42   43                            Alice in Wonderland   \n",
       "43   44                                       Zootopia   \n",
       "44   45              The Hobbit: An Unexpected Journey   \n",
       "45   46                                The Dark Knight   \n",
       "46   47       Harry Potter and the Philosopher's Stone   \n",
       "47   48                                Despicable Me 2   \n",
       "48   49                                  The Lion King   \n",
       "49   50                                The Jungle Book   \n",
       "\n",
       "                                                 link Worldwide gross ($USD)  \\\n",
       "0                             /wiki/Avengers:_Endgame         $2,797,800,564   \n",
       "1                            /wiki/Avatar_(2009_film)         $2,790,439,000   \n",
       "2                           /wiki/Titanic_(1997_film)         $2,194,439,542   \n",
       "3                  /wiki/Star_Wars:_The_Force_Awakens         $2,068,223,624   \n",
       "4                        /wiki/Avengers:_Infinity_War         $2,048,359,754   \n",
       "5                                /wiki/Jurassic_World         $1,671,713,208   \n",
       "6                     /wiki/The_Lion_King_(2019_film)         $1,656,943,394   \n",
       "7                      /wiki/The_Avengers_(2012_film)         $1,518,812,988   \n",
       "8                                     /wiki/Furious_7         $1,516,045,911   \n",
       "9                                     /wiki/Frozen_II         $1,450,026,933   \n",
       "10                      /wiki/Avengers:_Age_of_Ultron         $1,402,805,868   \n",
       "11                         /wiki/Black_Panther_(film)         $1,346,913,161   \n",
       "12  /wiki/Harry_Potter_and_the_Deathly_Hallows_%E2...         $1,341,693,157   \n",
       "13                     /wiki/Star_Wars:_The_Last_Jedi         $1,332,539,889   \n",
       "14               /wiki/Jurassic_World:_Fallen_Kingdom         $1,309,484,461   \n",
       "15                           /wiki/Frozen_(2013_film)        F$1,290,000,000   \n",
       "16             /wiki/Beauty_and_the_Beast_(2017_film)         $1,263,521,126   \n",
       "17                                /wiki/Incredibles_2         $1,242,805,359   \n",
       "18                      /wiki/The_Fate_of_the_Furious       F8$1,238,764,765   \n",
       "19                                   /wiki/Iron_Man_3         $1,214,811,252   \n",
       "20                               /wiki/Minions_(film)         $1,159,398,397   \n",
       "21                   /wiki/Captain_America:_Civil_War         $1,153,304,495   \n",
       "22                               /wiki/Aquaman_(film)         $1,148,161,807   \n",
       "23  /wiki/The_Lord_of_the_Rings:_The_Return_of_the...         $1,142,219,401   \n",
       "24                    /wiki/Spider-Man:_Far_From_Home         $1,131,927,996   \n",
       "25                        /wiki/Captain_Marvel_(film)         $1,128,274,794   \n",
       "26               /wiki/Transformers:_Dark_of_the_Moon         $1,123,794,079   \n",
       "27                                      /wiki/Skyfall         $1,108,561,013   \n",
       "28              /wiki/Transformers:_Age_of_Extinction         $1,104,054,072   \n",
       "29                        /wiki/The_Dark_Knight_Rises         $1,084,939,099   \n",
       "30                            /wiki/Joker_(2019_film)         $1,074,251,311   \n",
       "31             /wiki/Star_Wars:_The_Rise_of_Skywalker         $1,074,144,248   \n",
       "32                                  /wiki/Toy_Story_4         $1,073,394,593   \n",
       "33                                  /wiki/Toy_Story_3         $1,066,969,703   \n",
       "34  /wiki/Pirates_of_the_Caribbean:_Dead_Man%27s_C...         $1,066,179,725   \n",
       "35                 /wiki/Rogue_One:_A_Star_Wars_Story         $1,056,057,273   \n",
       "36                          /wiki/Aladdin_(2019_film)         $1,050,693,953   \n",
       "37  /wiki/Pirates_of_the_Caribbean:_On_Stranger_Tides         $1,045,713,802   \n",
       "38                              /wiki/Despicable_Me_3         $1,034,799,409   \n",
       "39                         /wiki/Jurassic_Park_(film)         $1,029,939,903   \n",
       "40                                 /wiki/Finding_Dory         $1,028,570,889   \n",
       "41  /wiki/Star_Wars:_Episode_I_%E2%80%93_The_Phant...         $1,027,044,677   \n",
       "42              /wiki/Alice_in_Wonderland_(2010_film)         $1,025,467,110   \n",
       "43                                     /wiki/Zootopia         $1,023,784,195   \n",
       "44            /wiki/The_Hobbit:_An_Unexpected_Journey         $1,021,103,568   \n",
       "45                       /wiki/The_Dark_Knight_(film)         $1,004,934,033   \n",
       "46  /wiki/Harry_Potter_and_the_Philosopher%27s_Sto...           $975,051,288   \n",
       "47                              /wiki/Despicable_Me_2           $970,761,885   \n",
       "48                                /wiki/The_Lion_King           $968,483,777   \n",
       "49                  /wiki/The_Jungle_Book_(2016_film)           $966,550,600   \n",
       "\n",
       "    Year                                        description  \\\n",
       "0   2019  Avengers: Endgame is a 2019 American superhero...   \n",
       "1   2009  Avatar (marketed as James Cameron's Avatar) is...   \n",
       "2   1997  Titanic is a 1997 American epic romance and di...   \n",
       "3   2015  Star Wars: The Force Awakens (also known as St...   \n",
       "4   2018  Avengers: Infinity War is a 2018 American supe...   \n",
       "5   2015  Jurassic World is a 2015 American science fict...   \n",
       "6   2019  The Lion King is a 2019 American musical drama...   \n",
       "7   2012  Marvel's The Avengers[6] (classified under the...   \n",
       "8   2015  Furious 7 (titled onscreen and other territori...   \n",
       "9   2019  Frozen II, also known as Frozen 2, is a 2019 A...   \n",
       "10  2015  Avengers: Age of Ultron is a 2015 American sup...   \n",
       "11  2018  Black Panther is a 2018 American superhero fil...   \n",
       "12  2011  Harry Potter and the Deathly Hallows – Part 2 ...   \n",
       "13  2017  Star Wars: The Last Jedi (also known as Star W...   \n",
       "14  2018  Jurassic World: Fallen Kingdom is a 2018 Ameri...   \n",
       "15  2013  Frozen is a 2013 American 3D computer-animated...   \n",
       "16  2017  Beauty and the Beast is a 2017 American musica...   \n",
       "17  2018  Incredibles 2 is a 2018 American computer-anim...   \n",
       "18  2017  The Fate of the Furious (alternatively known a...   \n",
       "19  2013  Iron Man 3 is a 2013 American superhero film b...   \n",
       "20  2015  Minions is a 2015 American 3D computer-animate...   \n",
       "21  2016  Captain America: Civil War is a 2016 American ...   \n",
       "22  2018  Aquaman is a 2018 American superhero film base...   \n",
       "23  2003  The Lord of the Rings: The Return of the King ...   \n",
       "24  2019  Spider-Man: Far From Home is a 2019 American s...   \n",
       "25  2019  Captain Marvel is a 2019 American superhero fi...   \n",
       "26  2011  Transformers: Dark of the Moon is a 2011 Ameri...   \n",
       "27  2012  Skyfall is a 2012 spy film and the twenty-thir...   \n",
       "28  2014  Transformers: Age of Extinction is a 2014 Amer...   \n",
       "29  2012  The Dark Knight Rises is a 2012 superhero film...   \n",
       "30  2019  Joker is a 2019 American psychological thrille...   \n",
       "31  2019  Star Wars: The Rise of Skywalker (also known a...   \n",
       "32  2019  Toy Story 4 is a 2019 American computer-animat...   \n",
       "33  2010  Toy Story 3 is a  2010 American computer-anima...   \n",
       "34  2006  Pirates of the Caribbean: Dead Man's Chest is ...   \n",
       "35  2016  Rogue One: A Star Wars Story (or simply Rogue ...   \n",
       "36  2019  Aladdin is a 2019 American musical fantasy fil...   \n",
       "37  2011  Pirates of the Caribbean: On Stranger Tides (r...   \n",
       "38  2017  Despicable Me 3 is a 2017 American computer-an...   \n",
       "39  1993  Jurassic Park is a 1993 American science ficti...   \n",
       "40  2016  Finding Dory is a 2016 American 3D computer-an...   \n",
       "41  1999  Star Wars: Episode I – The Phantom Menace is a...   \n",
       "42  2010  Alice in Wonderland is a 2010 American dark fa...   \n",
       "43  2016  Zootopia (titled Zootropolis in the UK)[6] is ...   \n",
       "44  2012  The Hobbit: An Unexpected Journey is a 2012 ep...   \n",
       "45  2008  The Dark Knight is a 2008 superhero film direc...   \n",
       "46  2001  Harry Potter and the Philosopher's Stone (rele...   \n",
       "47  2013  Despicable Me 2 is a 2013 American computer-an...   \n",
       "48  1994  The Lion King is a 1994 American animated musi...   \n",
       "49  2016  The Jungle Book is  2016 American fantasy adve...   \n",
       "\n",
       "                     director  \n",
       "0      Anthony RussoJoe Russo  \n",
       "1               James Cameron  \n",
       "2               James Cameron  \n",
       "3                J. J. Abrams  \n",
       "4      Anthony RussoJoe Russo  \n",
       "5             Colin Trevorrow  \n",
       "6                 Jon Favreau  \n",
       "7                 Joss Whedon  \n",
       "8                   James Wan  \n",
       "9     Chris Buck Jennifer Lee  \n",
       "10                Joss Whedon  \n",
       "11               Ryan Coogler  \n",
       "12                David Yates  \n",
       "13               Rian Johnson  \n",
       "14               J. A. Bayona  \n",
       "15    Chris Buck Jennifer Lee  \n",
       "16                Bill Condon  \n",
       "17                  Brad Bird  \n",
       "18               F. Gary Gray  \n",
       "19                Shane Black  \n",
       "20   Pierre Coffin Kyle Balda  \n",
       "21     Anthony RussoJoe Russo  \n",
       "22                  James Wan  \n",
       "23              Peter Jackson  \n",
       "24                  Jon Watts  \n",
       "25       Anna BodenRyan Fleck  \n",
       "26                Michael Bay  \n",
       "27                 Sam Mendes  \n",
       "28                Michael Bay  \n",
       "29          Christopher Nolan  \n",
       "30              Todd Phillips  \n",
       "31               J. J. Abrams  \n",
       "32                Josh Cooley  \n",
       "33                Lee Unkrich  \n",
       "34             Gore Verbinski  \n",
       "35             Gareth Edwards  \n",
       "36                Guy Ritchie  \n",
       "37               Rob Marshall  \n",
       "38   Pierre Coffin Kyle Balda  \n",
       "39           Steven Spielberg  \n",
       "40             Andrew Stanton  \n",
       "41               George Lucas  \n",
       "42                 Tim Burton  \n",
       "43    Byron Howard Rich Moore  \n",
       "44              Peter Jackson  \n",
       "45          Christopher Nolan  \n",
       "46             Chris Columbus  \n",
       "47  Chris RenaudPierre Coffin  \n",
       "48    Roger AllersRob Minkoff  \n",
       "49                Jon Favreau  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Method1 time_taken:  16.68904751599996\n"
     ]
    }
   ],
   "source": [
    "time1 = perf_counter()\n",
    "\n",
    "result = df['link'].map(get_film_details)\n",
    "df['description'], df['director'] = zip(*result) \n",
    "\n",
    "display(df)\n",
    "\n",
    "time2 = perf_counter()\n",
    "\n",
    "print(\"Method1 time_taken: \", time2-time1)"
   ]
  },
  {
   "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>Rank</th>\n",
       "      <th>Film</th>\n",
       "      <th>link</th>\n",
       "      <th>Worldwide gross ($USD)</th>\n",
       "      <th>Year</th>\n",
       "      <th>description</th>\n",
       "      <th>director</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Avengers: Endgame</td>\n",
       "      <td>/wiki/Avengers:_Endgame</td>\n",
       "      <td>$2,797,800,564</td>\n",
       "      <td>2019</td>\n",
       "      <td>Avengers: Endgame is a 2019 American superhero...</td>\n",
       "      <td>Anthony RussoJoe Russo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Avatar</td>\n",
       "      <td>/wiki/Avatar_(2009_film)</td>\n",
       "      <td>$2,790,439,000</td>\n",
       "      <td>2009</td>\n",
       "      <td>Avatar (marketed as James Cameron's Avatar) is...</td>\n",
       "      <td>James Cameron</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Titanic</td>\n",
       "      <td>/wiki/Titanic_(1997_film)</td>\n",
       "      <td>$2,194,439,542</td>\n",
       "      <td>1997</td>\n",
       "      <td>Titanic is a 1997 American epic romance and di...</td>\n",
       "      <td>James Cameron</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Star Wars: The Force Awakens</td>\n",
       "      <td>/wiki/Star_Wars:_The_Force_Awakens</td>\n",
       "      <td>$2,068,223,624</td>\n",
       "      <td>2015</td>\n",
       "      <td>Star Wars: The Force Awakens (also known as St...</td>\n",
       "      <td>J. J. Abrams</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Avengers: Infinity War</td>\n",
       "      <td>/wiki/Avengers:_Infinity_War</td>\n",
       "      <td>$2,048,359,754</td>\n",
       "      <td>2018</td>\n",
       "      <td>Avengers: Infinity War is a 2018 American supe...</td>\n",
       "      <td>Anthony RussoJoe Russo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>Jurassic World</td>\n",
       "      <td>/wiki/Jurassic_World</td>\n",
       "      <td>$1,671,713,208</td>\n",
       "      <td>2015</td>\n",
       "      <td>Jurassic World is a 2015 American science fict...</td>\n",
       "      <td>Colin Trevorrow</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>The Lion King</td>\n",
       "      <td>/wiki/The_Lion_King_(2019_film)</td>\n",
       "      <td>$1,656,943,394</td>\n",
       "      <td>2019</td>\n",
       "      <td>The Lion King is a 2019 American musical drama...</td>\n",
       "      <td>Jon Favreau</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>The Avengers</td>\n",
       "      <td>/wiki/The_Avengers_(2012_film)</td>\n",
       "      <td>$1,518,812,988</td>\n",
       "      <td>2012</td>\n",
       "      <td>Marvel's The Avengers[6] (classified under the...</td>\n",
       "      <td>Joss Whedon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>Furious 7</td>\n",
       "      <td>/wiki/Furious_7</td>\n",
       "      <td>$1,516,045,911</td>\n",
       "      <td>2015</td>\n",
       "      <td>Furious 7 (titled onscreen and other territori...</td>\n",
       "      <td>James Wan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>Frozen II</td>\n",
       "      <td>/wiki/Frozen_II</td>\n",
       "      <td>$1,450,026,933</td>\n",
       "      <td>2019</td>\n",
       "      <td>Frozen II, also known as Frozen 2, is a 2019 A...</td>\n",
       "      <td>Chris Buck Jennifer Lee</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>Avengers: Age of Ultron</td>\n",
       "      <td>/wiki/Avengers:_Age_of_Ultron</td>\n",
       "      <td>$1,402,805,868</td>\n",
       "      <td>2015</td>\n",
       "      <td>Avengers: Age of Ultron is a 2015 American sup...</td>\n",
       "      <td>Joss Whedon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>Black Panther</td>\n",
       "      <td>/wiki/Black_Panther_(film)</td>\n",
       "      <td>$1,346,913,161</td>\n",
       "      <td>2018</td>\n",
       "      <td>Black Panther is a 2018 American superhero fil...</td>\n",
       "      <td>Ryan Coogler</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>Harry Potter and the Deathly Hallows – Part 2</td>\n",
       "      <td>/wiki/Harry_Potter_and_the_Deathly_Hallows_%E2...</td>\n",
       "      <td>$1,341,693,157</td>\n",
       "      <td>2011</td>\n",
       "      <td>Harry Potter and the Deathly Hallows – Part 2 ...</td>\n",
       "      <td>David Yates</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14</td>\n",
       "      <td>Star Wars: The Last Jedi</td>\n",
       "      <td>/wiki/Star_Wars:_The_Last_Jedi</td>\n",
       "      <td>$1,332,539,889</td>\n",
       "      <td>2017</td>\n",
       "      <td>Star Wars: The Last Jedi (also known as Star W...</td>\n",
       "      <td>Rian Johnson</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15</td>\n",
       "      <td>Jurassic World: Fallen Kingdom</td>\n",
       "      <td>/wiki/Jurassic_World:_Fallen_Kingdom</td>\n",
       "      <td>$1,309,484,461</td>\n",
       "      <td>2018</td>\n",
       "      <td>Jurassic World: Fallen Kingdom is a 2018 Ameri...</td>\n",
       "      <td>J. A. Bayona</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16</td>\n",
       "      <td>Frozen</td>\n",
       "      <td>/wiki/Frozen_(2013_film)</td>\n",
       "      <td>F$1,290,000,000</td>\n",
       "      <td>2013</td>\n",
       "      <td>Frozen is a 2013 American 3D computer-animated...</td>\n",
       "      <td>Chris Buck Jennifer Lee</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>17</td>\n",
       "      <td>Beauty and the Beast</td>\n",
       "      <td>/wiki/Beauty_and_the_Beast_(2017_film)</td>\n",
       "      <td>$1,263,521,126</td>\n",
       "      <td>2017</td>\n",
       "      <td>Beauty and the Beast is a 2017 American musica...</td>\n",
       "      <td>Bill Condon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18</td>\n",
       "      <td>Incredibles 2</td>\n",
       "      <td>/wiki/Incredibles_2</td>\n",
       "      <td>$1,242,805,359</td>\n",
       "      <td>2018</td>\n",
       "      <td>Incredibles 2 is a 2018 American computer-anim...</td>\n",
       "      <td>Brad Bird</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>19</td>\n",
       "      <td>The Fate of the Furious</td>\n",
       "      <td>/wiki/The_Fate_of_the_Furious</td>\n",
       "      <td>F8$1,238,764,765</td>\n",
       "      <td>2017</td>\n",
       "      <td>The Fate of the Furious (alternatively known a...</td>\n",
       "      <td>F. Gary Gray</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>20</td>\n",
       "      <td>Iron Man 3</td>\n",
       "      <td>/wiki/Iron_Man_3</td>\n",
       "      <td>$1,214,811,252</td>\n",
       "      <td>2013</td>\n",
       "      <td>Iron Man 3 is a 2013 American superhero film b...</td>\n",
       "      <td>Shane Black</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>21</td>\n",
       "      <td>Minions</td>\n",
       "      <td>/wiki/Minions_(film)</td>\n",
       "      <td>$1,159,398,397</td>\n",
       "      <td>2015</td>\n",
       "      <td>Minions is a 2015 American 3D computer-animate...</td>\n",
       "      <td>Pierre Coffin Kyle Balda</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22</td>\n",
       "      <td>Captain America: Civil War</td>\n",
       "      <td>/wiki/Captain_America:_Civil_War</td>\n",
       "      <td>$1,153,304,495</td>\n",
       "      <td>2016</td>\n",
       "      <td>Captain America: Civil War is a 2016 American ...</td>\n",
       "      <td>Anthony RussoJoe Russo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>23</td>\n",
       "      <td>Aquaman</td>\n",
       "      <td>/wiki/Aquaman_(film)</td>\n",
       "      <td>$1,148,161,807</td>\n",
       "      <td>2018</td>\n",
       "      <td>Aquaman is a 2018 American superhero film base...</td>\n",
       "      <td>James Wan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>24</td>\n",
       "      <td>The Lord of the Rings: The Return of the King</td>\n",
       "      <td>/wiki/The_Lord_of_the_Rings:_The_Return_of_the...</td>\n",
       "      <td>$1,142,219,401</td>\n",
       "      <td>2003</td>\n",
       "      <td>The Lord of the Rings: The Return of the King ...</td>\n",
       "      <td>Peter Jackson</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>25</td>\n",
       "      <td>Spider-Man: Far From Home</td>\n",
       "      <td>/wiki/Spider-Man:_Far_From_Home</td>\n",
       "      <td>$1,131,927,996</td>\n",
       "      <td>2019</td>\n",
       "      <td>Spider-Man: Far From Home is a 2019 American s...</td>\n",
       "      <td>Jon Watts</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>26</td>\n",
       "      <td>Captain Marvel</td>\n",
       "      <td>/wiki/Captain_Marvel_(film)</td>\n",
       "      <td>$1,128,274,794</td>\n",
       "      <td>2019</td>\n",
       "      <td>Captain Marvel is a 2019 American superhero fi...</td>\n",
       "      <td>Anna BodenRyan Fleck</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>27</td>\n",
       "      <td>Transformers: Dark of the Moon</td>\n",
       "      <td>/wiki/Transformers:_Dark_of_the_Moon</td>\n",
       "      <td>$1,123,794,079</td>\n",
       "      <td>2011</td>\n",
       "      <td>Transformers: Dark of the Moon is a 2011 Ameri...</td>\n",
       "      <td>Michael Bay</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>28</td>\n",
       "      <td>Skyfall</td>\n",
       "      <td>/wiki/Skyfall</td>\n",
       "      <td>$1,108,561,013</td>\n",
       "      <td>2012</td>\n",
       "      <td>Skyfall is a 2012 spy film and the twenty-thir...</td>\n",
       "      <td>Sam Mendes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>29</td>\n",
       "      <td>Transformers: Age of Extinction</td>\n",
       "      <td>/wiki/Transformers:_Age_of_Extinction</td>\n",
       "      <td>$1,104,054,072</td>\n",
       "      <td>2014</td>\n",
       "      <td>Transformers: Age of Extinction is a 2014 Amer...</td>\n",
       "      <td>Michael Bay</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>30</td>\n",
       "      <td>The Dark Knight Rises</td>\n",
       "      <td>/wiki/The_Dark_Knight_Rises</td>\n",
       "      <td>$1,084,939,099</td>\n",
       "      <td>2012</td>\n",
       "      <td>The Dark Knight Rises is a 2012 superhero film...</td>\n",
       "      <td>Christopher Nolan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>31</td>\n",
       "      <td>Joker</td>\n",
       "      <td>/wiki/Joker_(2019_film)</td>\n",
       "      <td>$1,074,251,311</td>\n",
       "      <td>2019</td>\n",
       "      <td>Joker is a 2019 American psychological thrille...</td>\n",
       "      <td>Todd Phillips</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>32</td>\n",
       "      <td>Star Wars: The Rise of Skywalker</td>\n",
       "      <td>/wiki/Star_Wars:_The_Rise_of_Skywalker</td>\n",
       "      <td>$1,074,144,248</td>\n",
       "      <td>2019</td>\n",
       "      <td>Star Wars: The Rise of Skywalker (also known a...</td>\n",
       "      <td>J. J. Abrams</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>33</td>\n",
       "      <td>Toy Story 4</td>\n",
       "      <td>/wiki/Toy_Story_4</td>\n",
       "      <td>$1,073,394,593</td>\n",
       "      <td>2019</td>\n",
       "      <td>Toy Story 4 is a 2019 American computer-animat...</td>\n",
       "      <td>Josh Cooley</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>34</td>\n",
       "      <td>Toy Story 3</td>\n",
       "      <td>/wiki/Toy_Story_3</td>\n",
       "      <td>$1,066,969,703</td>\n",
       "      <td>2010</td>\n",
       "      <td>Toy Story 3 is a  2010 American computer-anima...</td>\n",
       "      <td>Lee Unkrich</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>35</td>\n",
       "      <td>Pirates of the Caribbean: Dead Man's Chest</td>\n",
       "      <td>/wiki/Pirates_of_the_Caribbean:_Dead_Man%27s_C...</td>\n",
       "      <td>$1,066,179,725</td>\n",
       "      <td>2006</td>\n",
       "      <td>Pirates of the Caribbean: Dead Man's Chest is ...</td>\n",
       "      <td>Gore Verbinski</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>36</td>\n",
       "      <td>Rogue One: A Star Wars Story</td>\n",
       "      <td>/wiki/Rogue_One:_A_Star_Wars_Story</td>\n",
       "      <td>$1,056,057,273</td>\n",
       "      <td>2016</td>\n",
       "      <td>Rogue One: A Star Wars Story (or simply Rogue ...</td>\n",
       "      <td>Gareth Edwards</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>37</td>\n",
       "      <td>Aladdin</td>\n",
       "      <td>/wiki/Aladdin_(2019_film)</td>\n",
       "      <td>$1,050,693,953</td>\n",
       "      <td>2019</td>\n",
       "      <td>Aladdin is a 2019 American musical fantasy fil...</td>\n",
       "      <td>Guy Ritchie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>38</td>\n",
       "      <td>Pirates of the Caribbean: On Stranger Tides</td>\n",
       "      <td>/wiki/Pirates_of_the_Caribbean:_On_Stranger_Tides</td>\n",
       "      <td>$1,045,713,802</td>\n",
       "      <td>2011</td>\n",
       "      <td>Pirates of the Caribbean: On Stranger Tides (r...</td>\n",
       "      <td>Rob Marshall</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>39</td>\n",
       "      <td>Despicable Me 3</td>\n",
       "      <td>/wiki/Despicable_Me_3</td>\n",
       "      <td>$1,034,799,409</td>\n",
       "      <td>2017</td>\n",
       "      <td>Despicable Me 3 is a 2017 American computer-an...</td>\n",
       "      <td>Pierre Coffin Kyle Balda</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>40</td>\n",
       "      <td>Jurassic Park</td>\n",
       "      <td>/wiki/Jurassic_Park_(film)</td>\n",
       "      <td>$1,029,939,903</td>\n",
       "      <td>1993</td>\n",
       "      <td>Jurassic Park is a 1993 American science ficti...</td>\n",
       "      <td>Steven Spielberg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>41</td>\n",
       "      <td>Finding Dory</td>\n",
       "      <td>/wiki/Finding_Dory</td>\n",
       "      <td>$1,028,570,889</td>\n",
       "      <td>2016</td>\n",
       "      <td>Finding Dory is a 2016 American 3D computer-an...</td>\n",
       "      <td>Andrew Stanton</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>42</td>\n",
       "      <td>Star Wars: Episode I – The Phantom Menace</td>\n",
       "      <td>/wiki/Star_Wars:_Episode_I_%E2%80%93_The_Phant...</td>\n",
       "      <td>$1,027,044,677</td>\n",
       "      <td>1999</td>\n",
       "      <td>Star Wars: Episode I – The Phantom Menace is a...</td>\n",
       "      <td>George Lucas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>43</td>\n",
       "      <td>Alice in Wonderland</td>\n",
       "      <td>/wiki/Alice_in_Wonderland_(2010_film)</td>\n",
       "      <td>$1,025,467,110</td>\n",
       "      <td>2010</td>\n",
       "      <td>Alice in Wonderland is a 2010 American dark fa...</td>\n",
       "      <td>Tim Burton</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>44</td>\n",
       "      <td>Zootopia</td>\n",
       "      <td>/wiki/Zootopia</td>\n",
       "      <td>$1,023,784,195</td>\n",
       "      <td>2016</td>\n",
       "      <td>Zootopia (titled Zootropolis in the UK)[6] is ...</td>\n",
       "      <td>Byron Howard Rich Moore</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>45</td>\n",
       "      <td>The Hobbit: An Unexpected Journey</td>\n",
       "      <td>/wiki/The_Hobbit:_An_Unexpected_Journey</td>\n",
       "      <td>$1,021,103,568</td>\n",
       "      <td>2012</td>\n",
       "      <td>The Hobbit: An Unexpected Journey is a 2012 ep...</td>\n",
       "      <td>Peter Jackson</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>46</td>\n",
       "      <td>The Dark Knight</td>\n",
       "      <td>/wiki/The_Dark_Knight_(film)</td>\n",
       "      <td>$1,004,934,033</td>\n",
       "      <td>2008</td>\n",
       "      <td>The Dark Knight is a 2008 superhero film direc...</td>\n",
       "      <td>Christopher Nolan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>47</td>\n",
       "      <td>Harry Potter and the Philosopher's Stone</td>\n",
       "      <td>/wiki/Harry_Potter_and_the_Philosopher%27s_Sto...</td>\n",
       "      <td>$975,051,288</td>\n",
       "      <td>2001</td>\n",
       "      <td>Harry Potter and the Philosopher's Stone (rele...</td>\n",
       "      <td>Chris Columbus</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>48</td>\n",
       "      <td>Despicable Me 2</td>\n",
       "      <td>/wiki/Despicable_Me_2</td>\n",
       "      <td>$970,761,885</td>\n",
       "      <td>2013</td>\n",
       "      <td>Despicable Me 2 is a 2013 American computer-an...</td>\n",
       "      <td>Chris RenaudPierre Coffin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>49</td>\n",
       "      <td>The Lion King</td>\n",
       "      <td>/wiki/The_Lion_King</td>\n",
       "      <td>$968,483,777</td>\n",
       "      <td>1994</td>\n",
       "      <td>The Lion King is a 1994 American animated musi...</td>\n",
       "      <td>Roger AllersRob Minkoff</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>50</td>\n",
       "      <td>The Jungle Book</td>\n",
       "      <td>/wiki/The_Jungle_Book_(2016_film)</td>\n",
       "      <td>$966,550,600</td>\n",
       "      <td>2016</td>\n",
       "      <td>The Jungle Book is  2016 American fantasy adve...</td>\n",
       "      <td>Jon Favreau</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Rank                                           Film  \\\n",
       "0     1                              Avengers: Endgame   \n",
       "1     2                                         Avatar   \n",
       "2     3                                        Titanic   \n",
       "3     4                   Star Wars: The Force Awakens   \n",
       "4     5                         Avengers: Infinity War   \n",
       "5     6                                 Jurassic World   \n",
       "6     7                                  The Lion King   \n",
       "7     8                                   The Avengers   \n",
       "8     9                                      Furious 7   \n",
       "9    10                                      Frozen II   \n",
       "10   11                        Avengers: Age of Ultron   \n",
       "11   12                                  Black Panther   \n",
       "12   13  Harry Potter and the Deathly Hallows – Part 2   \n",
       "13   14                       Star Wars: The Last Jedi   \n",
       "14   15                 Jurassic World: Fallen Kingdom   \n",
       "15   16                                         Frozen   \n",
       "16   17                           Beauty and the Beast   \n",
       "17   18                                  Incredibles 2   \n",
       "18   19                        The Fate of the Furious   \n",
       "19   20                                     Iron Man 3   \n",
       "20   21                                        Minions   \n",
       "21   22                     Captain America: Civil War   \n",
       "22   23                                        Aquaman   \n",
       "23   24  The Lord of the Rings: The Return of the King   \n",
       "24   25                      Spider-Man: Far From Home   \n",
       "25   26                                 Captain Marvel   \n",
       "26   27                 Transformers: Dark of the Moon   \n",
       "27   28                                        Skyfall   \n",
       "28   29                Transformers: Age of Extinction   \n",
       "29   30                          The Dark Knight Rises   \n",
       "30   31                                          Joker   \n",
       "31   32               Star Wars: The Rise of Skywalker   \n",
       "32   33                                    Toy Story 4   \n",
       "33   34                                    Toy Story 3   \n",
       "34   35     Pirates of the Caribbean: Dead Man's Chest   \n",
       "35   36                   Rogue One: A Star Wars Story   \n",
       "36   37                                        Aladdin   \n",
       "37   38    Pirates of the Caribbean: On Stranger Tides   \n",
       "38   39                                Despicable Me 3   \n",
       "39   40                                  Jurassic Park   \n",
       "40   41                                   Finding Dory   \n",
       "41   42      Star Wars: Episode I – The Phantom Menace   \n",
       "42   43                            Alice in Wonderland   \n",
       "43   44                                       Zootopia   \n",
       "44   45              The Hobbit: An Unexpected Journey   \n",
       "45   46                                The Dark Knight   \n",
       "46   47       Harry Potter and the Philosopher's Stone   \n",
       "47   48                                Despicable Me 2   \n",
       "48   49                                  The Lion King   \n",
       "49   50                                The Jungle Book   \n",
       "\n",
       "                                                 link Worldwide gross ($USD)  \\\n",
       "0                             /wiki/Avengers:_Endgame         $2,797,800,564   \n",
       "1                            /wiki/Avatar_(2009_film)         $2,790,439,000   \n",
       "2                           /wiki/Titanic_(1997_film)         $2,194,439,542   \n",
       "3                  /wiki/Star_Wars:_The_Force_Awakens         $2,068,223,624   \n",
       "4                        /wiki/Avengers:_Infinity_War         $2,048,359,754   \n",
       "5                                /wiki/Jurassic_World         $1,671,713,208   \n",
       "6                     /wiki/The_Lion_King_(2019_film)         $1,656,943,394   \n",
       "7                      /wiki/The_Avengers_(2012_film)         $1,518,812,988   \n",
       "8                                     /wiki/Furious_7         $1,516,045,911   \n",
       "9                                     /wiki/Frozen_II         $1,450,026,933   \n",
       "10                      /wiki/Avengers:_Age_of_Ultron         $1,402,805,868   \n",
       "11                         /wiki/Black_Panther_(film)         $1,346,913,161   \n",
       "12  /wiki/Harry_Potter_and_the_Deathly_Hallows_%E2...         $1,341,693,157   \n",
       "13                     /wiki/Star_Wars:_The_Last_Jedi         $1,332,539,889   \n",
       "14               /wiki/Jurassic_World:_Fallen_Kingdom         $1,309,484,461   \n",
       "15                           /wiki/Frozen_(2013_film)        F$1,290,000,000   \n",
       "16             /wiki/Beauty_and_the_Beast_(2017_film)         $1,263,521,126   \n",
       "17                                /wiki/Incredibles_2         $1,242,805,359   \n",
       "18                      /wiki/The_Fate_of_the_Furious       F8$1,238,764,765   \n",
       "19                                   /wiki/Iron_Man_3         $1,214,811,252   \n",
       "20                               /wiki/Minions_(film)         $1,159,398,397   \n",
       "21                   /wiki/Captain_America:_Civil_War         $1,153,304,495   \n",
       "22                               /wiki/Aquaman_(film)         $1,148,161,807   \n",
       "23  /wiki/The_Lord_of_the_Rings:_The_Return_of_the...         $1,142,219,401   \n",
       "24                    /wiki/Spider-Man:_Far_From_Home         $1,131,927,996   \n",
       "25                        /wiki/Captain_Marvel_(film)         $1,128,274,794   \n",
       "26               /wiki/Transformers:_Dark_of_the_Moon         $1,123,794,079   \n",
       "27                                      /wiki/Skyfall         $1,108,561,013   \n",
       "28              /wiki/Transformers:_Age_of_Extinction         $1,104,054,072   \n",
       "29                        /wiki/The_Dark_Knight_Rises         $1,084,939,099   \n",
       "30                            /wiki/Joker_(2019_film)         $1,074,251,311   \n",
       "31             /wiki/Star_Wars:_The_Rise_of_Skywalker         $1,074,144,248   \n",
       "32                                  /wiki/Toy_Story_4         $1,073,394,593   \n",
       "33                                  /wiki/Toy_Story_3         $1,066,969,703   \n",
       "34  /wiki/Pirates_of_the_Caribbean:_Dead_Man%27s_C...         $1,066,179,725   \n",
       "35                 /wiki/Rogue_One:_A_Star_Wars_Story         $1,056,057,273   \n",
       "36                          /wiki/Aladdin_(2019_film)         $1,050,693,953   \n",
       "37  /wiki/Pirates_of_the_Caribbean:_On_Stranger_Tides         $1,045,713,802   \n",
       "38                              /wiki/Despicable_Me_3         $1,034,799,409   \n",
       "39                         /wiki/Jurassic_Park_(film)         $1,029,939,903   \n",
       "40                                 /wiki/Finding_Dory         $1,028,570,889   \n",
       "41  /wiki/Star_Wars:_Episode_I_%E2%80%93_The_Phant...         $1,027,044,677   \n",
       "42              /wiki/Alice_in_Wonderland_(2010_film)         $1,025,467,110   \n",
       "43                                     /wiki/Zootopia         $1,023,784,195   \n",
       "44            /wiki/The_Hobbit:_An_Unexpected_Journey         $1,021,103,568   \n",
       "45                       /wiki/The_Dark_Knight_(film)         $1,004,934,033   \n",
       "46  /wiki/Harry_Potter_and_the_Philosopher%27s_Sto...           $975,051,288   \n",
       "47                              /wiki/Despicable_Me_2           $970,761,885   \n",
       "48                                /wiki/The_Lion_King           $968,483,777   \n",
       "49                  /wiki/The_Jungle_Book_(2016_film)           $966,550,600   \n",
       "\n",
       "    Year                                        description  \\\n",
       "0   2019  Avengers: Endgame is a 2019 American superhero...   \n",
       "1   2009  Avatar (marketed as James Cameron's Avatar) is...   \n",
       "2   1997  Titanic is a 1997 American epic romance and di...   \n",
       "3   2015  Star Wars: The Force Awakens (also known as St...   \n",
       "4   2018  Avengers: Infinity War is a 2018 American supe...   \n",
       "5   2015  Jurassic World is a 2015 American science fict...   \n",
       "6   2019  The Lion King is a 2019 American musical drama...   \n",
       "7   2012  Marvel's The Avengers[6] (classified under the...   \n",
       "8   2015  Furious 7 (titled onscreen and other territori...   \n",
       "9   2019  Frozen II, also known as Frozen 2, is a 2019 A...   \n",
       "10  2015  Avengers: Age of Ultron is a 2015 American sup...   \n",
       "11  2018  Black Panther is a 2018 American superhero fil...   \n",
       "12  2011  Harry Potter and the Deathly Hallows – Part 2 ...   \n",
       "13  2017  Star Wars: The Last Jedi (also known as Star W...   \n",
       "14  2018  Jurassic World: Fallen Kingdom is a 2018 Ameri...   \n",
       "15  2013  Frozen is a 2013 American 3D computer-animated...   \n",
       "16  2017  Beauty and the Beast is a 2017 American musica...   \n",
       "17  2018  Incredibles 2 is a 2018 American computer-anim...   \n",
       "18  2017  The Fate of the Furious (alternatively known a...   \n",
       "19  2013  Iron Man 3 is a 2013 American superhero film b...   \n",
       "20  2015  Minions is a 2015 American 3D computer-animate...   \n",
       "21  2016  Captain America: Civil War is a 2016 American ...   \n",
       "22  2018  Aquaman is a 2018 American superhero film base...   \n",
       "23  2003  The Lord of the Rings: The Return of the King ...   \n",
       "24  2019  Spider-Man: Far From Home is a 2019 American s...   \n",
       "25  2019  Captain Marvel is a 2019 American superhero fi...   \n",
       "26  2011  Transformers: Dark of the Moon is a 2011 Ameri...   \n",
       "27  2012  Skyfall is a 2012 spy film and the twenty-thir...   \n",
       "28  2014  Transformers: Age of Extinction is a 2014 Amer...   \n",
       "29  2012  The Dark Knight Rises is a 2012 superhero film...   \n",
       "30  2019  Joker is a 2019 American psychological thrille...   \n",
       "31  2019  Star Wars: The Rise of Skywalker (also known a...   \n",
       "32  2019  Toy Story 4 is a 2019 American computer-animat...   \n",
       "33  2010  Toy Story 3 is a  2010 American computer-anima...   \n",
       "34  2006  Pirates of the Caribbean: Dead Man's Chest is ...   \n",
       "35  2016  Rogue One: A Star Wars Story (or simply Rogue ...   \n",
       "36  2019  Aladdin is a 2019 American musical fantasy fil...   \n",
       "37  2011  Pirates of the Caribbean: On Stranger Tides (r...   \n",
       "38  2017  Despicable Me 3 is a 2017 American computer-an...   \n",
       "39  1993  Jurassic Park is a 1993 American science ficti...   \n",
       "40  2016  Finding Dory is a 2016 American 3D computer-an...   \n",
       "41  1999  Star Wars: Episode I – The Phantom Menace is a...   \n",
       "42  2010  Alice in Wonderland is a 2010 American dark fa...   \n",
       "43  2016  Zootopia (titled Zootropolis in the UK)[6] is ...   \n",
       "44  2012  The Hobbit: An Unexpected Journey is a 2012 ep...   \n",
       "45  2008  The Dark Knight is a 2008 superhero film direc...   \n",
       "46  2001  Harry Potter and the Philosopher's Stone (rele...   \n",
       "47  2013  Despicable Me 2 is a 2013 American computer-an...   \n",
       "48  1994  The Lion King is a 1994 American animated musi...   \n",
       "49  2016  The Jungle Book is  2016 American fantasy adve...   \n",
       "\n",
       "                     director  \n",
       "0      Anthony RussoJoe Russo  \n",
       "1               James Cameron  \n",
       "2               James Cameron  \n",
       "3                J. J. Abrams  \n",
       "4      Anthony RussoJoe Russo  \n",
       "5             Colin Trevorrow  \n",
       "6                 Jon Favreau  \n",
       "7                 Joss Whedon  \n",
       "8                   James Wan  \n",
       "9     Chris Buck Jennifer Lee  \n",
       "10                Joss Whedon  \n",
       "11               Ryan Coogler  \n",
       "12                David Yates  \n",
       "13               Rian Johnson  \n",
       "14               J. A. Bayona  \n",
       "15    Chris Buck Jennifer Lee  \n",
       "16                Bill Condon  \n",
       "17                  Brad Bird  \n",
       "18               F. Gary Gray  \n",
       "19                Shane Black  \n",
       "20   Pierre Coffin Kyle Balda  \n",
       "21     Anthony RussoJoe Russo  \n",
       "22                  James Wan  \n",
       "23              Peter Jackson  \n",
       "24                  Jon Watts  \n",
       "25       Anna BodenRyan Fleck  \n",
       "26                Michael Bay  \n",
       "27                 Sam Mendes  \n",
       "28                Michael Bay  \n",
       "29          Christopher Nolan  \n",
       "30              Todd Phillips  \n",
       "31               J. J. Abrams  \n",
       "32                Josh Cooley  \n",
       "33                Lee Unkrich  \n",
       "34             Gore Verbinski  \n",
       "35             Gareth Edwards  \n",
       "36                Guy Ritchie  \n",
       "37               Rob Marshall  \n",
       "38   Pierre Coffin Kyle Balda  \n",
       "39           Steven Spielberg  \n",
       "40             Andrew Stanton  \n",
       "41               George Lucas  \n",
       "42                 Tim Burton  \n",
       "43    Byron Howard Rich Moore  \n",
       "44              Peter Jackson  \n",
       "45          Christopher Nolan  \n",
       "46             Chris Columbus  \n",
       "47  Chris RenaudPierre Coffin  \n",
       "48    Roger AllersRob Minkoff  \n",
       "49                Jon Favreau  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Method2 time_taken:  3.3524462889999995\n"
     ]
    }
   ],
   "source": [
    "import multiprocessing as mp\n",
    "\n",
    "\n",
    "time1 = perf_counter()\n",
    "\n",
    "\n",
    "with mp.Pool(mp.cpu_count()) as pool:\n",
    "    result = pool.map(get_film_details, df['link'])\n",
    "\n",
    "df['description'], df['director'] = zip(*result) \n",
    "\n",
    "display(df)\n",
    "\n",
    "time2 = perf_counter()\n",
    "\n",
    "print(\"Method2 time_taken: \", time2-time1)\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv(\"Top_grossing_films.csv\", columns = ['Film', \"Worldwide gross ($USD)\", \"Year\", \"description\", \"director\" ])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "12\n"
     ]
    }
   ],
   "source": [
    "# How many cpu's does this machine actually have\n",
    "print(mp.cpu_count())"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}