WebScrapingIMDb.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": [],
      "collapsed_sections": [],
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/Animeshsinghiit/Web-Scraping-Practises/blob/main/WebScrapingIMDb.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "cpSHRvVDxY49"
      },
      "source": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "UcunukYTxbbl"
      },
      "source": [
        "# Web Scraping IMDb"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "62kwkNPgoAfZ"
      },
      "source": [
        "A tutorial to scrape movie information from IMDb"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "TAbyCCOexkxm"
      },
      "source": [
        "1: Import Necessary Libraries"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "6rr-6yuixhc-"
      },
      "source": [
        "from bs4 import BeautifulSoup as bs\n",
        "import requests #to access website\n",
        "import pandas as pd"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "8vNUGsrFxwrQ"
      },
      "source": [
        "2: Load the webpage"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "AYrvktIMxzIl",
        "outputId": "4a7826aa-0632-4a95-c343-60c44873f83b",
        "colab": {
          "base_uri": "https://localhost:8080/"
        }
      },
      "source": [
        "r = requests.get(\"https://www.imdb.com/chart/top/\")\n",
        "\n",
        "# Convert to a beautiful soup object\n",
        "soup = bs(r.content)\n",
        "\n",
        "# Print out HTML\n",
        "contents = soup.prettify()\n",
        "print(contents[:100])"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "<!DOCTYPE html>\n",
            "<html xmlns:fb=\"http://www.facebook.com/2008/fbml\" xmlns:og=\"http://ogp.me/ns#\">\n",
            " <h\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "WhZdIGL9x1Kh"
      },
      "source": [
        "3: Creating empty list"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "B1LyQaqux8w7"
      },
      "source": [
        "movie_title = []\n",
        "movie_year = []\n",
        "movie_rating = []"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "_4AKRoqPx4_k"
      },
      "source": [
        "*4*: Extract HTML tag contents"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "tIcc0qFRyEFe"
      },
      "source": [
        "imdb_table = soup.find(class_=\"chart full-width\")"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "-3MncpYsMuPs"
      },
      "source": [
        "movie_titlecolumn = imdb_table.find_all(class_=\"titleColumn\")"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "v-1waFIeMt-8"
      },
      "source": [
        "movie_ratingscolumn = imdb_table.find_all(class_=\"ratingColumn imdbRating\")"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "XJ9EkMaxBcq3",
        "outputId": "372412e5-ef26-4f03-c567-1744dc27df26"
      },
      "source": [
        "for row in movie_titlecolumn:\n",
        "    title = row.a.text # tag content extraction\n",
        "    movie_title.append(title)\n",
        "movie_title"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "['The Shawshank Redemption',\n",
              " 'The Godfather',\n",
              " 'The Godfather: Part II',\n",
              " 'The Dark Knight',\n",
              " '12 Angry Men',\n",
              " \"Schindler's List\",\n",
              " 'The Lord of the Rings: The Return of the King',\n",
              " 'Pulp Fiction',\n",
              " 'The Good, the Bad and the Ugly',\n",
              " 'The Lord of the Rings: The Fellowship of the Ring',\n",
              " 'Fight Club',\n",
              " 'Forrest Gump',\n",
              " 'Inception',\n",
              " 'The Lord of the Rings: The Two Towers',\n",
              " 'Star Wars: Episode V - The Empire Strikes Back',\n",
              " 'The Matrix',\n",
              " 'Goodfellas',\n",
              " \"One Flew Over the Cuckoo's Nest\",\n",
              " 'Seven Samurai',\n",
              " 'Se7en',\n",
              " 'The Silence of the Lambs',\n",
              " 'City of God',\n",
              " 'Life Is Beautiful',\n",
              " \"It's a Wonderful Life\",\n",
              " 'Star Wars: Episode IV - A New Hope',\n",
              " 'Saving Private Ryan',\n",
              " 'Spirited Away',\n",
              " 'Interstellar',\n",
              " 'The Green Mile',\n",
              " 'Parasite',\n",
              " 'Léon: The Professional',\n",
              " 'Hara-Kiri',\n",
              " 'The Pianist',\n",
              " 'The Usual Suspects',\n",
              " 'Terminator 2: Judgment Day',\n",
              " 'Back to the Future',\n",
              " 'Psycho',\n",
              " 'Modern Times',\n",
              " 'The Lion King',\n",
              " 'American History X',\n",
              " 'City Lights',\n",
              " 'Grave of the Fireflies',\n",
              " 'Gladiator',\n",
              " 'Whiplash',\n",
              " 'The Departed',\n",
              " 'The Intouchables',\n",
              " 'The Prestige',\n",
              " 'Casablanca',\n",
              " 'Once Upon a Time in the West',\n",
              " 'Rear Window',\n",
              " 'Cinema Paradiso',\n",
              " 'Alien',\n",
              " 'Apocalypse Now',\n",
              " 'Memento',\n",
              " 'Indiana Jones and the Raiders of the Lost Ark',\n",
              " 'The Great Dictator',\n",
              " 'The Lives of Others',\n",
              " 'Django Unchained',\n",
              " 'Paths of Glory',\n",
              " 'Sunset Blvd.',\n",
              " 'WALL·E',\n",
              " 'The Shining',\n",
              " 'Avengers: Infinity War',\n",
              " 'Witness for the Prosecution',\n",
              " 'Dr. Strangelove or: How I Learned to Stop Worrying and Love the Bomb',\n",
              " 'Spider-Man: Into the Spider-Verse',\n",
              " 'Joker',\n",
              " 'Princess Mononoke',\n",
              " 'Oldboy',\n",
              " 'Your Name.',\n",
              " 'Once Upon a Time in America',\n",
              " 'The Dark Knight Rises',\n",
              " 'Aliens',\n",
              " 'Coco',\n",
              " 'Hamilton',\n",
              " 'Capharnaüm',\n",
              " 'Das Boot',\n",
              " 'Avengers: Endgame',\n",
              " 'High and Low',\n",
              " 'American Beauty',\n",
              " 'Toy Story',\n",
              " '3 Idiots',\n",
              " 'Amadeus',\n",
              " 'Braveheart',\n",
              " 'Inglourious Basterds',\n",
              " 'Good Will Hunting',\n",
              " 'Star Wars: Episode VI - Return of the Jedi',\n",
              " '2001: A Space Odyssey',\n",
              " 'Reservoir Dogs',\n",
              " 'Like Stars on Earth',\n",
              " 'M',\n",
              " 'Vertigo',\n",
              " 'Citizen Kane',\n",
              " 'Pather Panchali',\n",
              " 'Come and See',\n",
              " 'The Hunt',\n",
              " 'Requiem for a Dream',\n",
              " \"Singin' in the Rain\",\n",
              " 'North by Northwest',\n",
              " 'Eternal Sunshine of the Spotless Mind',\n",
              " 'Ikiru',\n",
              " 'Bicycle Thieves',\n",
              " 'Lawrence of Arabia',\n",
              " 'The Kid',\n",
              " 'Dangal',\n",
              " 'Full Metal Jacket',\n",
              " 'The Father',\n",
              " 'A Clockwork Orange',\n",
              " 'Metropolis',\n",
              " 'Taxi Driver',\n",
              " 'The Apartment',\n",
              " 'Double Indemnity',\n",
              " 'Incendies',\n",
              " 'The Sting',\n",
              " 'A Separation',\n",
              " '1917',\n",
              " 'Scarface',\n",
              " 'Amélie',\n",
              " 'Snatch',\n",
              " 'Toy Story 3',\n",
              " 'To Kill a Mockingbird',\n",
              " 'For a Few Dollars More',\n",
              " 'Up',\n",
              " 'Indiana Jones and the Last Crusade',\n",
              " 'L.A. Confidential',\n",
              " 'Heat',\n",
              " 'Rashomon',\n",
              " 'Yojimbo',\n",
              " 'Ran',\n",
              " 'Die Hard',\n",
              " 'Green Book',\n",
              " 'Downfall',\n",
              " 'Monty Python and the Holy Grail',\n",
              " 'All About Eve',\n",
              " 'Some Like It Hot',\n",
              " 'Batman Begins',\n",
              " 'Unforgiven',\n",
              " 'Children of Heaven',\n",
              " \"Howl's Moving Castle\",\n",
              " 'The Wolf of Wall Street',\n",
              " 'The Great Escape',\n",
              " 'Judgment at Nuremberg',\n",
              " 'Casino',\n",
              " 'There Will Be Blood',\n",
              " 'The Treasure of the Sierra Madre',\n",
              " \"Pan's Labyrinth\",\n",
              " 'A Beautiful Mind',\n",
              " 'The Secret in Their Eyes',\n",
              " 'Raging Bull',\n",
              " 'My Neighbor Totoro',\n",
              " 'Chinatown',\n",
              " 'Lock, Stock and Two Smoking Barrels',\n",
              " 'The Gold Rush',\n",
              " 'Shutter Island',\n",
              " 'No Country for Old Men',\n",
              " 'Dial M for Murder',\n",
              " 'Three Billboards Outside Ebbing, Missouri',\n",
              " 'The Seventh Seal',\n",
              " 'The Elephant Man',\n",
              " 'The Thing',\n",
              " 'The Sixth Sense',\n",
              " 'Klaus',\n",
              " 'The Third Man',\n",
              " 'V for Vendetta',\n",
              " 'Wild Strawberries',\n",
              " 'Inside Out',\n",
              " 'Jurassic Park',\n",
              " 'The Truman Show',\n",
              " 'Memories of Murder',\n",
              " 'Blade Runner',\n",
              " 'Trainspotting',\n",
              " 'The Bridge on the River Kwai',\n",
              " 'Warrior',\n",
              " 'Fargo',\n",
              " 'Finding Nemo',\n",
              " 'My Father and My Son',\n",
              " 'Gone with the Wind',\n",
              " 'Kill Bill: Vol. 1',\n",
              " 'Tokyo Story',\n",
              " 'On the Waterfront',\n",
              " 'Stalker',\n",
              " 'Wild Tales',\n",
              " 'The General',\n",
              " 'Sherlock Jr.',\n",
              " 'The Deer Hunter',\n",
              " 'Gran Torino',\n",
              " 'Persona',\n",
              " 'The Grand Budapest Hotel',\n",
              " 'Before Sunrise',\n",
              " 'Mary and Max',\n",
              " 'Prisoners',\n",
              " 'Room',\n",
              " 'Mr. Smith Goes to Washington',\n",
              " 'In the Name of the Father',\n",
              " 'Catch Me If You Can',\n",
              " 'Gone Girl',\n",
              " 'Barry Lyndon',\n",
              " 'Hacksaw Ridge',\n",
              " 'To Be or Not to Be',\n",
              " 'Andhadhun',\n",
              " 'The Passion of Joan of Arc',\n",
              " 'Ford v Ferrari',\n",
              " 'The Big Lebowski',\n",
              " '12 Years a Slave',\n",
              " 'How to Train Your Dragon',\n",
              " 'Mad Max: Fury Road',\n",
              " 'Dead Poets Society',\n",
              " 'Ben-Hur',\n",
              " 'Million Dollar Baby',\n",
              " 'The Wages of Fear',\n",
              " 'Harry Potter and the Deathly Hallows: Part 2',\n",
              " 'Autumn Sonata',\n",
              " 'Network',\n",
              " 'Stand by Me',\n",
              " 'The Handmaiden',\n",
              " 'Cool Hand Luke',\n",
              " 'The 400 Blows',\n",
              " 'Logan',\n",
              " \"Hachi: A Dog's Tale\",\n",
              " 'La Haine',\n",
              " 'The Bandit',\n",
              " 'Platoon',\n",
              " 'Gangs of Wasseypur',\n",
              " 'Spotlight',\n",
              " \"Monty Python's Life of Brian\",\n",
              " 'Hotel Rwanda',\n",
              " 'A Silent Voice: The Movie',\n",
              " 'Monsters, Inc.',\n",
              " 'Rebecca',\n",
              " 'Rush',\n",
              " 'Andrei Rublev',\n",
              " 'Into the Wild',\n",
              " \"Love's a Bitch\",\n",
              " 'In the Mood for Love',\n",
              " 'Rocky',\n",
              " 'It Happened One Night',\n",
              " 'Neon Genesis Evangelion: The End of Evangelion',\n",
              " 'Nausicaä of the Valley of the Wind',\n",
              " 'The Battle of Algiers',\n",
              " 'Before Sunset',\n",
              " 'Fanny and Alexander',\n",
              " 'Three Colors: Red',\n",
              " 'The Princess Bride',\n",
              " 'Rififi',\n",
              " 'Paris, Texas',\n",
              " 'Demon Slayer: Mugen Train',\n",
              " 'Nights of Cabiria',\n",
              " 'Sunrise',\n",
              " 'Raatchasan',\n",
              " 'Hera Pheri']"
            ]
          },
          "metadata": {},
          "execution_count": 7
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "yI8nXvvLMhVG",
        "outputId": "1908f904-7eca-4a9e-9c3b-7a95142636db"
      },
      "source": [
        "for row in movie_titlecolumn:\n",
        "    year = row.span.text # tag content extraction\n",
        "    movie_year.append(year)\n",
        "movie_year"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "['(1994)',\n",
              " '(1972)',\n",
              " '(1974)',\n",
              " '(2008)',\n",
              " '(1957)',\n",
              " '(1993)',\n",
              " '(2003)',\n",
              " '(1994)',\n",
              " '(1966)',\n",
              " '(2001)',\n",
              " '(1999)',\n",
              " '(1994)',\n",
              " '(2010)',\n",
              " '(2002)',\n",
              " '(1980)',\n",
              " '(1999)',\n",
              " '(1990)',\n",
              " '(1975)',\n",
              " '(1954)',\n",
              " '(1995)',\n",
              " '(1991)',\n",
              " '(2002)',\n",
              " '(1997)',\n",
              " '(1946)',\n",
              " '(1977)',\n",
              " '(1998)',\n",
              " '(2001)',\n",
              " '(2014)',\n",
              " '(1999)',\n",
              " '(2019)',\n",
              " '(1994)',\n",
              " '(1962)',\n",
              " '(2002)',\n",
              " '(1995)',\n",
              " '(1991)',\n",
              " '(1985)',\n",
              " '(1960)',\n",
              " '(1936)',\n",
              " '(1994)',\n",
              " '(1998)',\n",
              " '(1931)',\n",
              " '(1988)',\n",
              " '(2000)',\n",
              " '(2014)',\n",
              " '(2006)',\n",
              " '(2011)',\n",
              " '(2006)',\n",
              " '(1942)',\n",
              " '(1968)',\n",
              " '(1954)',\n",
              " '(1988)',\n",
              " '(1979)',\n",
              " '(1979)',\n",
              " '(2000)',\n",
              " '(1981)',\n",
              " '(1940)',\n",
              " '(2006)',\n",
              " '(2012)',\n",
              " '(1957)',\n",
              " '(1950)',\n",
              " '(2008)',\n",
              " '(1980)',\n",
              " '(2018)',\n",
              " '(1957)',\n",
              " '(1964)',\n",
              " '(2018)',\n",
              " '(2019)',\n",
              " '(1997)',\n",
              " '(2003)',\n",
              " '(2016)',\n",
              " '(1984)',\n",
              " '(2012)',\n",
              " '(1986)',\n",
              " '(2017)',\n",
              " '(2020)',\n",
              " '(1981)',\n",
              " '(2018)',\n",
              " '(2019)',\n",
              " '(1963)',\n",
              " '(1999)',\n",
              " '(1995)',\n",
              " '(2009)',\n",
              " '(1984)',\n",
              " '(1995)',\n",
              " '(2009)',\n",
              " '(1997)',\n",
              " '(1983)',\n",
              " '(1968)',\n",
              " '(1992)',\n",
              " '(2007)',\n",
              " '(1931)',\n",
              " '(1955)',\n",
              " '(1958)',\n",
              " '(1941)',\n",
              " '(1985)',\n",
              " '(2012)',\n",
              " '(2000)',\n",
              " '(1952)',\n",
              " '(1959)',\n",
              " '(2004)',\n",
              " '(1952)',\n",
              " '(1948)',\n",
              " '(1962)',\n",
              " '(1921)',\n",
              " '(2016)',\n",
              " '(1987)',\n",
              " '(2020)',\n",
              " '(1971)',\n",
              " '(1927)',\n",
              " '(1976)',\n",
              " '(1960)',\n",
              " '(2010)',\n",
              " '(1944)',\n",
              " '(1973)',\n",
              " '(2011)',\n",
              " '(2019)',\n",
              " '(1983)',\n",
              " '(2001)',\n",
              " '(2000)',\n",
              " '(2010)',\n",
              " '(1962)',\n",
              " '(1965)',\n",
              " '(2009)',\n",
              " '(1989)',\n",
              " '(1997)',\n",
              " '(1995)',\n",
              " '(1950)',\n",
              " '(1961)',\n",
              " '(1985)',\n",
              " '(1988)',\n",
              " '(2018)',\n",
              " '(1975)',\n",
              " '(2004)',\n",
              " '(1950)',\n",
              " '(1959)',\n",
              " '(2005)',\n",
              " '(1992)',\n",
              " '(1997)',\n",
              " '(2004)',\n",
              " '(2013)',\n",
              " '(1963)',\n",
              " '(1961)',\n",
              " '(1995)',\n",
              " '(1948)',\n",
              " '(2007)',\n",
              " '(2006)',\n",
              " '(2001)',\n",
              " '(2009)',\n",
              " '(1980)',\n",
              " '(1988)',\n",
              " '(1974)',\n",
              " '(1998)',\n",
              " '(1925)',\n",
              " '(2010)',\n",
              " '(2007)',\n",
              " '(1954)',\n",
              " '(2017)',\n",
              " '(1957)',\n",
              " '(1980)',\n",
              " '(1982)',\n",
              " '(1999)',\n",
              " '(2019)',\n",
              " '(1949)',\n",
              " '(2005)',\n",
              " '(2015)',\n",
              " '(1957)',\n",
              " '(1993)',\n",
              " '(1998)',\n",
              " '(2003)',\n",
              " '(1982)',\n",
              " '(1996)',\n",
              " '(1957)',\n",
              " '(2011)',\n",
              " '(1996)',\n",
              " '(2003)',\n",
              " '(1939)',\n",
              " '(2005)',\n",
              " '(2003)',\n",
              " '(1953)',\n",
              " '(1954)',\n",
              " '(1979)',\n",
              " '(2014)',\n",
              " '(1926)',\n",
              " '(1924)',\n",
              " '(1978)',\n",
              " '(2008)',\n",
              " '(2014)',\n",
              " '(1966)',\n",
              " '(1995)',\n",
              " '(2009)',\n",
              " '(2013)',\n",
              " '(2015)',\n",
              " '(1939)',\n",
              " '(1993)',\n",
              " '(2002)',\n",
              " '(2014)',\n",
              " '(2016)',\n",
              " '(1975)',\n",
              " '(1942)',\n",
              " '(2018)',\n",
              " '(1928)',\n",
              " '(2019)',\n",
              " '(1998)',\n",
              " '(2013)',\n",
              " '(2010)',\n",
              " '(2015)',\n",
              " '(1989)',\n",
              " '(1959)',\n",
              " '(2004)',\n",
              " '(1953)',\n",
              " '(2011)',\n",
              " '(1978)',\n",
              " '(1976)',\n",
              " '(1986)',\n",
              " '(2016)',\n",
              " '(1967)',\n",
              " '(1959)',\n",
              " '(2017)',\n",
              " '(2009)',\n",
              " '(1995)',\n",
              " '(1996)',\n",
              " '(1986)',\n",
              " '(2015)',\n",
              " '(2012)',\n",
              " '(1979)',\n",
              " '(2004)',\n",
              " '(2001)',\n",
              " '(2016)',\n",
              " '(1940)',\n",
              " '(2013)',\n",
              " '(2007)',\n",
              " '(1966)',\n",
              " '(2000)',\n",
              " '(2000)',\n",
              " '(1976)',\n",
              " '(1934)',\n",
              " '(1984)',\n",
              " '(1997)',\n",
              " '(1966)',\n",
              " '(2004)',\n",
              " '(1982)',\n",
              " '(1994)',\n",
              " '(1987)',\n",
              " '(1955)',\n",
              " '(1984)',\n",
              " '(2020)',\n",
              " '(1927)',\n",
              " '(1957)',\n",
              " '(2019)',\n",
              " '(2000)']"
            ]
          },
          "metadata": {},
          "execution_count": 8
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "IKm_CaldyI5y",
        "outputId": "7c3b6147-a1e0-4cf3-d89b-296af67719c3"
      },
      "source": [
        "for row in movie_ratingscolumn:\n",
        "    rating = row.strong.text # tag content extraction\n",
        "    movie_rating.append(rating)\n",
        "movie_rating"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "['9.2',\n",
              " '9.1',\n",
              " '9.0',\n",
              " '9.0',\n",
              " '8.9',\n",
              " '8.9',\n",
              " '8.9',\n",
              " '8.8',\n",
              " '8.8',\n",
              " '8.8',\n",
              " '8.8',\n",
              " '8.7',\n",
              " '8.7',\n",
              " '8.7',\n",
              " '8.7',\n",
              " '8.6',\n",
              " '8.6',\n",
              " '8.6',\n",
              " '8.6',\n",
              " '8.6',\n",
              " '8.6',\n",
              " '8.6',\n",
              " '8.6',\n",
              " '8.6',\n",
              " '8.6',\n",
              " '8.5',\n",
              " '8.5',\n",
              " '8.5',\n",
              " '8.5',\n",
              " '8.5',\n",
              " '8.5',\n",
              " '8.5',\n",
              " '8.5',\n",
              " '8.5',\n",
              " '8.5',\n",
              " '8.5',\n",
              " '8.5',\n",
              " '8.5',\n",
              " '8.5',\n",
              " '8.5',\n",
              " '8.5',\n",
              " '8.5',\n",
              " '8.5',\n",
              " '8.5',\n",
              " '8.5',\n",
              " '8.5',\n",
              " '8.5',\n",
              " '8.4',\n",
              " '8.4',\n",
              " '8.4',\n",
              " '8.4',\n",
              " '8.4',\n",
              " '8.4',\n",
              " '8.4',\n",
              " '8.4',\n",
              " '8.4',\n",
              " '8.4',\n",
              " '8.4',\n",
              " '8.4',\n",
              " '8.4',\n",
              " '8.4',\n",
              " '8.4',\n",
              " '8.4',\n",
              " '8.4',\n",
              " '8.4',\n",
              " '8.4',\n",
              " '8.4',\n",
              " '8.3',\n",
              " '8.3',\n",
              " '8.3',\n",
              " '8.3',\n",
              " '8.3',\n",
              " '8.3',\n",
              " '8.3',\n",
              " '8.3',\n",
              " '8.3',\n",
              " '8.3',\n",
              " '8.3',\n",
              " '8.3',\n",
              " '8.3',\n",
              " '8.3',\n",
              " '8.3',\n",
              " '8.3',\n",
              " '8.3',\n",
              " '8.3',\n",
              " '8.3',\n",
              " '8.3',\n",
              " '8.3',\n",
              " '8.3',\n",
              " '8.3',\n",
              " '8.3',\n",
              " '8.3',\n",
              " '8.3',\n",
              " '8.3',\n",
              " '8.3',\n",
              " '8.3',\n",
              " '8.3',\n",
              " '8.3',\n",
              " '8.3',\n",
              " '8.3',\n",
              " '8.3',\n",
              " '8.3',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.2',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.1',\n",
              " '8.0',\n",
              " '8.0',\n",
              " '8.0',\n",
              " '8.0',\n",
              " '8.0',\n",
              " '8.0',\n",
              " '8.0',\n",
              " '8.0',\n",
              " '8.0',\n",
              " '8.0',\n",
              " '8.0',\n",
              " '8.0',\n",
              " '8.0',\n",
              " '8.0',\n",
              " '8.0',\n",
              " '8.0',\n",
              " '8.0',\n",
              " '8.0',\n",
              " '8.0',\n",
              " '8.0',\n",
              " '8.0',\n",
              " '8.0',\n",
              " '8.0',\n",
              " '8.0',\n",
              " '8.0',\n",
              " '8.0',\n",
              " '8.0',\n",
              " '8.0',\n",
              " '8.0',\n",
              " '8.0',\n",
              " '8.0',\n",
              " '8.0']"
            ]
          },
          "metadata": {},
          "execution_count": 9
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "baZtHVKxyNaO"
      },
      "source": [
        "\n",
        "\n",
        "```\n",
        "# This is formatted as code\n",
        "```\n",
        "\n",
        "5: Create Dataframe"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 963
        },
        "id": "TGInrO-zyOVw",
        "outputId": "0a54f5f0-d48b-43ff-d5de-3fb0278e1dbb"
      },
      "source": [
        "movie_df = pd.DataFrame({'Movie Title': movie_title, 'Year of Release': movie_year, 'IMDb Rating': movie_rating})\n",
        "movie_df.head(30) #View first 30 rows of dataframe"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Movie Title</th>\n",
              "      <th>Year of Release</th>\n",
              "      <th>IMDb Rating</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>The Shawshank Redemption</td>\n",
              "      <td>(1994)</td>\n",
              "      <td>9.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>The Godfather</td>\n",
              "      <td>(1972)</td>\n",
              "      <td>9.1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>The Godfather: Part II</td>\n",
              "      <td>(1974)</td>\n",
              "      <td>9.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>The Dark Knight</td>\n",
              "      <td>(2008)</td>\n",
              "      <td>9.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>12 Angry Men</td>\n",
              "      <td>(1957)</td>\n",
              "      <td>8.9</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Schindler's List</td>\n",
              "      <td>(1993)</td>\n",
              "      <td>8.9</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>The Lord of the Rings: The Return of the King</td>\n",
              "      <td>(2003)</td>\n",
              "      <td>8.9</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>Pulp Fiction</td>\n",
              "      <td>(1994)</td>\n",
              "      <td>8.8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>The Good, the Bad and the Ugly</td>\n",
              "      <td>(1966)</td>\n",
              "      <td>8.8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>The Lord of the Rings: The Fellowship of the Ring</td>\n",
              "      <td>(2001)</td>\n",
              "      <td>8.8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>Fight Club</td>\n",
              "      <td>(1999)</td>\n",
              "      <td>8.8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>Forrest Gump</td>\n",
              "      <td>(1994)</td>\n",
              "      <td>8.7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>Inception</td>\n",
              "      <td>(2010)</td>\n",
              "      <td>8.7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>The Lord of the Rings: The Two Towers</td>\n",
              "      <td>(2002)</td>\n",
              "      <td>8.7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>Star Wars: Episode V - The Empire Strikes Back</td>\n",
              "      <td>(1980)</td>\n",
              "      <td>8.7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>The Matrix</td>\n",
              "      <td>(1999)</td>\n",
              "      <td>8.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>Goodfellas</td>\n",
              "      <td>(1990)</td>\n",
              "      <td>8.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>One Flew Over the Cuckoo's Nest</td>\n",
              "      <td>(1975)</td>\n",
              "      <td>8.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>Seven Samurai</td>\n",
              "      <td>(1954)</td>\n",
              "      <td>8.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>Se7en</td>\n",
              "      <td>(1995)</td>\n",
              "      <td>8.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>The Silence of the Lambs</td>\n",
              "      <td>(1991)</td>\n",
              "      <td>8.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>City of God</td>\n",
              "      <td>(2002)</td>\n",
              "      <td>8.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>Life Is Beautiful</td>\n",
              "      <td>(1997)</td>\n",
              "      <td>8.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>It's a Wonderful Life</td>\n",
              "      <td>(1946)</td>\n",
              "      <td>8.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>Star Wars: Episode IV - A New Hope</td>\n",
              "      <td>(1977)</td>\n",
              "      <td>8.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>Saving Private Ryan</td>\n",
              "      <td>(1998)</td>\n",
              "      <td>8.5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>Spirited Away</td>\n",
              "      <td>(2001)</td>\n",
              "      <td>8.5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>Interstellar</td>\n",
              "      <td>(2014)</td>\n",
              "      <td>8.5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>The Green Mile</td>\n",
              "      <td>(1999)</td>\n",
              "      <td>8.5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>Parasite</td>\n",
              "      <td>(2019)</td>\n",
              "      <td>8.5</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                                          Movie Title  ... IMDb Rating\n",
              "0                            The Shawshank Redemption  ...         9.2\n",
              "1                                       The Godfather  ...         9.1\n",
              "2                              The Godfather: Part II  ...         9.0\n",
              "3                                     The Dark Knight  ...         9.0\n",
              "4                                        12 Angry Men  ...         8.9\n",
              "5                                    Schindler's List  ...         8.9\n",
              "6       The Lord of the Rings: The Return of the King  ...         8.9\n",
              "7                                        Pulp Fiction  ...         8.8\n",
              "8                      The Good, the Bad and the Ugly  ...         8.8\n",
              "9   The Lord of the Rings: The Fellowship of the Ring  ...         8.8\n",
              "10                                         Fight Club  ...         8.8\n",
              "11                                       Forrest Gump  ...         8.7\n",
              "12                                          Inception  ...         8.7\n",
              "13              The Lord of the Rings: The Two Towers  ...         8.7\n",
              "14     Star Wars: Episode V - The Empire Strikes Back  ...         8.7\n",
              "15                                         The Matrix  ...         8.6\n",
              "16                                         Goodfellas  ...         8.6\n",
              "17                    One Flew Over the Cuckoo's Nest  ...         8.6\n",
              "18                                      Seven Samurai  ...         8.6\n",
              "19                                              Se7en  ...         8.6\n",
              "20                           The Silence of the Lambs  ...         8.6\n",
              "21                                        City of God  ...         8.6\n",
              "22                                  Life Is Beautiful  ...         8.6\n",
              "23                              It's a Wonderful Life  ...         8.6\n",
              "24                 Star Wars: Episode IV - A New Hope  ...         8.6\n",
              "25                                Saving Private Ryan  ...         8.5\n",
              "26                                      Spirited Away  ...         8.5\n",
              "27                                       Interstellar  ...         8.5\n",
              "28                                     The Green Mile  ...         8.5\n",
              "29                                           Parasite  ...         8.5\n",
              "\n",
              "[30 rows x 3 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 10
        }
      ]
    }
  ]
}