imdb_top_tv_shows.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "imdb_top_tv_shows.ipynb",
      "provenance": [],
      "collapsed_sections": [],
      "authorship_tag": "ABX9TyO2fd9iT9Hu2n0Wbwc7E9bS",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    },
    "accelerator": "GPU"
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/Suyash-pande-89/Scrapping_soup/blob/main/imdb_top_tv_shows.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "Ryy9S6GFG6wg"
      },
      "source": [
        "#IMDB Top TV shows scrapper\n",
        "This script is a simple code to help beginners to start there first scraping project.\n",
        "Aim of this code is to create a dataframe with following variables:\n",
        "\n",
        "1. Name of the TV show\n",
        "2. Year it aired\n",
        "3. Genre\n",
        "4. IMDB Rating\n",
        "5. Votes \n",
        "\n",
        "\n",
        "\n"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "fjyG0bzW6k_a"
      },
      "source": [
        "import pandas as pd\n",
        "import numpy as np\n",
        "import requests\n",
        "from bs4 import BeautifulSoup"
      ],
      "execution_count": 2,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "snOVUdJV6rvR",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "ad082fa2-ccfa-4380-cb60-a6bbfc4a1858"
      },
      "source": [
        "!nvidia-smi"
      ],
      "execution_count": 1,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Wed Jun  2 14:28:02 2021       \n",
            "+-----------------------------------------------------------------------------+\n",
            "| NVIDIA-SMI 465.19.01    Driver Version: 460.32.03    CUDA Version: 11.2     |\n",
            "|-------------------------------+----------------------+----------------------+\n",
            "| GPU  Name        Persistence-M| Bus-Id        Disp.A | Volatile Uncorr. ECC |\n",
            "| Fan  Temp  Perf  Pwr:Usage/Cap|         Memory-Usage | GPU-Util  Compute M. |\n",
            "|                               |                      |               MIG M. |\n",
            "|===============================+======================+======================|\n",
            "|   0  Tesla T4            Off  | 00000000:00:04.0 Off |                    0 |\n",
            "| N/A   42C    P8     9W /  70W |      0MiB / 15109MiB |      0%      Default |\n",
            "|                               |                      |                  N/A |\n",
            "+-------------------------------+----------------------+----------------------+\n",
            "                                                                               \n",
            "+-----------------------------------------------------------------------------+\n",
            "| Processes:                                                                  |\n",
            "|  GPU   GI   CI        PID   Type   Process name                  GPU Memory |\n",
            "|        ID   ID                                                   Usage      |\n",
            "|=============================================================================|\n",
            "|  No running processes found                                                 |\n",
            "+-----------------------------------------------------------------------------+\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "Shh0gbQIIq5r"
      },
      "source": [
        "Following is the code for scraping"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "A0zYuhdNsc5N"
      },
      "source": [
        "# Get url and generate request\n",
        "url = \"https://www.imdb.com/search/title/?title_type=tv_series&num_votes=1000,&languages=en&sort=num_votes,desc\"\n",
        "response = requests.get(url)\n",
        "soup = BeautifulSoup(response.content,'html.parser')\n",
        "\n",
        "# Get all div tabs\n",
        "movie_data = soup.findAll('div',attrs= {'class': 'lister-item mode-advanced'})\n",
        "\n",
        "# Initialize as lists \n",
        "tvs = []\n",
        "year = []\n",
        "genre = []\n",
        "rating = []\n",
        "votes =[]\n",
        "\n",
        "#create lists for the variables\n",
        "for store in movie_data:\n",
        "  tvs.append(store.h3.a.text)\n",
        "  year.append(store.h3.find('span',class_ =\"lister-item-year text-muted unbold\").text.replace('(', '').replace(')', ''))\n",
        "  genre.append(store.p.find('span',class_ ='genre').text.replace('\\n','').replace('[','').replace(']',''))\n",
        "  rating.append(store.find('div',class_=\"inline-block ratings-imdb-rating\" ).text.replace('\\n',''))\n",
        "  votes.append(store.find_all('span', attrs = {'name': 'nv'})[0].text)\n",
        "\n",
        "#create data frame\n",
        "TVS_DF = pd.DataFrame({'Name of TV show': tvs, 'Year of relase': year, 'Genre': genre, 'Movie Rating': rating, 'Votes': votes})"
      ],
      "execution_count": 3,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "hJuxXKrbs_NO",
        "outputId": "2a76f88d-0ccf-4680-dc88-b14c95f7d392"
      },
      "source": [
        "TVS_DF.sort_values(['Movie Rating'],ascending= False)"
      ],
      "execution_count": 4,
      "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>Name of TV show</th>\n",
              "      <th>Year of relase</th>\n",
              "      <th>Genre</th>\n",
              "      <th>Movie Rating</th>\n",
              "      <th>Votes</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Breaking Bad</td>\n",
              "      <td>2008–2013</td>\n",
              "      <td>Crime, Drama, Thriller</td>\n",
              "      <td>9.4</td>\n",
              "      <td>1,518,773</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Game of Thrones</td>\n",
              "      <td>2011–2019</td>\n",
              "      <td>Action, Adventure, Drama</td>\n",
              "      <td>9.3</td>\n",
              "      <td>1,816,943</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>47</th>\n",
              "      <td>Avatar: The Last Airbender</td>\n",
              "      <td>2005–2008</td>\n",
              "      <td>Animation, Action, Adventure</td>\n",
              "      <td>9.3</td>\n",
              "      <td>259,431</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>38</th>\n",
              "      <td>The Wire</td>\n",
              "      <td>2002–2008</td>\n",
              "      <td>Crime, Drama, Thriller</td>\n",
              "      <td>9.3</td>\n",
              "      <td>293,139</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>Rick and Morty</td>\n",
              "      <td>2013–</td>\n",
              "      <td>Animation, Adventure, Comedy</td>\n",
              "      <td>9.2</td>\n",
              "      <td>392,881</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35</th>\n",
              "      <td>The Sopranos</td>\n",
              "      <td>1999–2007</td>\n",
              "      <td>Crime, Drama</td>\n",
              "      <td>9.2</td>\n",
              "      <td>313,701</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Sherlock</td>\n",
              "      <td>2010–2017</td>\n",
              "      <td>Crime, Drama, Mystery</td>\n",
              "      <td>9.1</td>\n",
              "      <td>827,657</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>49</th>\n",
              "      <td>Firefly</td>\n",
              "      <td>2002–2003</td>\n",
              "      <td>Adventure, Drama, Sci-Fi</td>\n",
              "      <td>9.0</td>\n",
              "      <td>247,186</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>True Detective</td>\n",
              "      <td>2014–2019</td>\n",
              "      <td>Crime, Drama, Mystery</td>\n",
              "      <td>8.9</td>\n",
              "      <td>509,516</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Friends</td>\n",
              "      <td>1994–2004</td>\n",
              "      <td>Comedy, Romance</td>\n",
              "      <td>8.9</td>\n",
              "      <td>858,314</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>The Office</td>\n",
              "      <td>2005–2013</td>\n",
              "      <td>Comedy</td>\n",
              "      <td>8.9</td>\n",
              "      <td>438,418</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>Fargo</td>\n",
              "      <td>2014–</td>\n",
              "      <td>Crime, Drama, Thriller</td>\n",
              "      <td>8.9</td>\n",
              "      <td>336,229</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>Narcos</td>\n",
              "      <td>2015–2017</td>\n",
              "      <td>Biography, Crime, Drama</td>\n",
              "      <td>8.8</td>\n",
              "      <td>369,340</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>The Mandalorian</td>\n",
              "      <td>2019–</td>\n",
              "      <td>Action, Adventure, Sci-Fi</td>\n",
              "      <td>8.8</td>\n",
              "      <td>322,834</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>Black Mirror</td>\n",
              "      <td>2011–</td>\n",
              "      <td>Drama, Sci-Fi, Thriller</td>\n",
              "      <td>8.8</td>\n",
              "      <td>460,582</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>Peaky Blinders</td>\n",
              "      <td>2013–</td>\n",
              "      <td>Crime, Drama</td>\n",
              "      <td>8.8</td>\n",
              "      <td>376,519</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>42</th>\n",
              "      <td>Arrested Development</td>\n",
              "      <td>2003–2019</td>\n",
              "      <td>Comedy</td>\n",
              "      <td>8.7</td>\n",
              "      <td>281,264</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>Better Call Saul</td>\n",
              "      <td>2015–</td>\n",
              "      <td>Crime, Drama</td>\n",
              "      <td>8.7</td>\n",
              "      <td>339,303</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>South Park</td>\n",
              "      <td>1997–</td>\n",
              "      <td>Animation, Comedy</td>\n",
              "      <td>8.7</td>\n",
              "      <td>336,827</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>House M.D.</td>\n",
              "      <td>2004–2012</td>\n",
              "      <td>Drama, Mystery</td>\n",
              "      <td>8.7</td>\n",
              "      <td>421,691</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>House of Cards</td>\n",
              "      <td>2013–2018</td>\n",
              "      <td>Drama</td>\n",
              "      <td>8.7</td>\n",
              "      <td>472,940</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>43</th>\n",
              "      <td>The Boys</td>\n",
              "      <td>2019–</td>\n",
              "      <td>Action, Comedy, Crime</td>\n",
              "      <td>8.7</td>\n",
              "      <td>275,634</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Stranger Things</td>\n",
              "      <td>2016–</td>\n",
              "      <td>Drama, Fantasy, Horror</td>\n",
              "      <td>8.7</td>\n",
              "      <td>859,262</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>Dexter</td>\n",
              "      <td>2006–2021</td>\n",
              "      <td>Crime, Drama, Mystery</td>\n",
              "      <td>8.6</td>\n",
              "      <td>656,847</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>Westworld</td>\n",
              "      <td>2016–</td>\n",
              "      <td>Drama, Mystery, Sci-Fi</td>\n",
              "      <td>8.6</td>\n",
              "      <td>438,510</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>The Simpsons</td>\n",
              "      <td>1989–</td>\n",
              "      <td>Animation, Comedy</td>\n",
              "      <td>8.6</td>\n",
              "      <td>371,762</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>Daredevil</td>\n",
              "      <td>2015–2018</td>\n",
              "      <td>Action, Crime, Drama</td>\n",
              "      <td>8.6</td>\n",
              "      <td>370,055</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>Vikings</td>\n",
              "      <td>2013–2020</td>\n",
              "      <td>Action, Adventure, Drama</td>\n",
              "      <td>8.5</td>\n",
              "      <td>449,632</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>Mr. Robot</td>\n",
              "      <td>2015–2019</td>\n",
              "      <td>Crime, Drama, Thriller</td>\n",
              "      <td>8.5</td>\n",
              "      <td>341,312</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>44</th>\n",
              "      <td>Sons of Anarchy</td>\n",
              "      <td>2008–2014</td>\n",
              "      <td>Crime, Drama, Thriller</td>\n",
              "      <td>8.5</td>\n",
              "      <td>266,735</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>Modern Family</td>\n",
              "      <td>2009–2020</td>\n",
              "      <td>Comedy, Drama, Romance</td>\n",
              "      <td>8.4</td>\n",
              "      <td>369,444</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>Supernatural</td>\n",
              "      <td>2005–2020</td>\n",
              "      <td>Drama, Fantasy, Horror</td>\n",
              "      <td>8.4</td>\n",
              "      <td>399,025</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>Suits</td>\n",
              "      <td>2011–2019</td>\n",
              "      <td>Comedy, Drama</td>\n",
              "      <td>8.4</td>\n",
              "      <td>370,567</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31</th>\n",
              "      <td>Money Heist</td>\n",
              "      <td>2017–2021</td>\n",
              "      <td>Action, Crime, Mystery</td>\n",
              "      <td>8.3</td>\n",
              "      <td>326,925</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>Lost</td>\n",
              "      <td>2004–2010</td>\n",
              "      <td>Adventure, Drama, Fantasy</td>\n",
              "      <td>8.3</td>\n",
              "      <td>505,802</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>Prison Break</td>\n",
              "      <td>2005–2017</td>\n",
              "      <td>Action, Crime, Drama</td>\n",
              "      <td>8.3</td>\n",
              "      <td>486,369</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>How I Met Your Mother</td>\n",
              "      <td>2005–2014</td>\n",
              "      <td>Comedy, Romance</td>\n",
              "      <td>8.3</td>\n",
              "      <td>616,344</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\n",
              "      <td>Homeland</td>\n",
              "      <td>2011–2020</td>\n",
              "      <td>Crime, Drama, Mystery</td>\n",
              "      <td>8.3</td>\n",
              "      <td>319,633</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>34</th>\n",
              "      <td>The Witcher</td>\n",
              "      <td>2019–</td>\n",
              "      <td>Action, Adventure, Fantasy</td>\n",
              "      <td>8.2</td>\n",
              "      <td>318,849</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>The Walking Dead</td>\n",
              "      <td>2010–2022</td>\n",
              "      <td>Drama, Horror, Thriller</td>\n",
              "      <td>8.2</td>\n",
              "      <td>872,489</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>37</th>\n",
              "      <td>Family Guy</td>\n",
              "      <td>1999–</td>\n",
              "      <td>Animation, Comedy</td>\n",
              "      <td>8.1</td>\n",
              "      <td>309,573</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>The Big Bang Theory</td>\n",
              "      <td>2007–2019</td>\n",
              "      <td>Comedy, Romance</td>\n",
              "      <td>8.1</td>\n",
              "      <td>735,815</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>48</th>\n",
              "      <td>Lucifer</td>\n",
              "      <td>2016–</td>\n",
              "      <td>Crime, Drama, Fantasy</td>\n",
              "      <td>8.1</td>\n",
              "      <td>248,130</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>41</th>\n",
              "      <td>American Horror Story</td>\n",
              "      <td>2011–</td>\n",
              "      <td>Drama, Horror, Thriller</td>\n",
              "      <td>8.0</td>\n",
              "      <td>281,978</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>40</th>\n",
              "      <td>Orange Is the New Black</td>\n",
              "      <td>2013–2019</td>\n",
              "      <td>Comedy, Crime, Drama</td>\n",
              "      <td>8.0</td>\n",
              "      <td>282,249</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>36</th>\n",
              "      <td>The Flash</td>\n",
              "      <td>2014–</td>\n",
              "      <td>Action, Adventure, Drama</td>\n",
              "      <td>7.7</td>\n",
              "      <td>313,457</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>39</th>\n",
              "      <td>The Vampire Diaries</td>\n",
              "      <td>2009–2017</td>\n",
              "      <td>Drama, Fantasy, Horror</td>\n",
              "      <td>7.7</td>\n",
              "      <td>289,568</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>45</th>\n",
              "      <td>13 Reasons Why</td>\n",
              "      <td>2017–2020</td>\n",
              "      <td>Drama, Mystery, Thriller</td>\n",
              "      <td>7.6</td>\n",
              "      <td>261,974</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>Arrow</td>\n",
              "      <td>2012–2020</td>\n",
              "      <td>Action, Adventure, Crime</td>\n",
              "      <td>7.5</td>\n",
              "      <td>411,910</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>46</th>\n",
              "      <td>Grey's Anatomy</td>\n",
              "      <td>2005–</td>\n",
              "      <td>Drama, Romance</td>\n",
              "      <td>7.5</td>\n",
              "      <td>259,996</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "               Name of TV show Year of relase  ... Movie Rating      Votes\n",
              "1                 Breaking Bad      2008–2013  ...          9.4  1,518,773\n",
              "0              Game of Thrones      2011–2019  ...          9.3  1,816,943\n",
              "47  Avatar: The Last Airbender      2005–2008  ...          9.3    259,431\n",
              "38                    The Wire      2002–2008  ...          9.3    293,139\n",
              "20              Rick and Morty         2013–   ...          9.2    392,881\n",
              "35                The Sopranos      1999–2007  ...          9.2    313,701\n",
              "5                     Sherlock      2010–2017  ...          9.1    827,657\n",
              "49                     Firefly      2002–2003  ...          9.0    247,186\n",
              "9               True Detective      2014–2019  ...          8.9    509,516\n",
              "4                      Friends      1994–2004  ...          8.9    858,314\n",
              "16                  The Office      2005–2013  ...          8.9    438,418\n",
              "30                       Fargo         2014–   ...          8.9    336,229\n",
              "26                      Narcos      2015–2017  ...          8.8    369,340\n",
              "32             The Mandalorian         2019–   ...          8.8    322,834\n",
              "13                Black Mirror         2011–   ...          8.8    460,582\n",
              "21              Peaky Blinders         2013–   ...          8.8    376,519\n",
              "42        Arrested Development      2003–2019  ...          8.7    281,264\n",
              "28            Better Call Saul         2015–   ...          8.7    339,303\n",
              "29                  South Park         1997–   ...          8.7    336,827\n",
              "17                  House M.D.      2004–2012  ...          8.7    421,691\n",
              "12              House of Cards      2013–2018  ...          8.7    472,940\n",
              "43                    The Boys         2019–   ...          8.7    275,634\n",
              "3              Stranger Things         2016–   ...          8.7    859,262\n",
              "7                       Dexter      2006–2021  ...          8.6    656,847\n",
              "15                   Westworld         2016–   ...          8.6    438,510\n",
              "22                The Simpsons         1989–   ...          8.6    371,762\n",
              "24                   Daredevil      2015–2018  ...          8.6    370,055\n",
              "14                     Vikings      2013–2020  ...          8.5    449,632\n",
              "27                   Mr. Robot      2015–2019  ...          8.5    341,312\n",
              "44             Sons of Anarchy      2008–2014  ...          8.5    266,735\n",
              "25               Modern Family      2009–2020  ...          8.4    369,444\n",
              "19                Supernatural      2005–2020  ...          8.4    399,025\n",
              "23                       Suits      2011–2019  ...          8.4    370,567\n",
              "31                 Money Heist      2017–2021  ...          8.3    326,925\n",
              "10                        Lost      2004–2010  ...          8.3    505,802\n",
              "11                Prison Break      2005–2017  ...          8.3    486,369\n",
              "8        How I Met Your Mother      2005–2014  ...          8.3    616,344\n",
              "33                    Homeland      2011–2020  ...          8.3    319,633\n",
              "34                 The Witcher         2019–   ...          8.2    318,849\n",
              "2             The Walking Dead      2010–2022  ...          8.2    872,489\n",
              "37                  Family Guy         1999–   ...          8.1    309,573\n",
              "6          The Big Bang Theory      2007–2019  ...          8.1    735,815\n",
              "48                     Lucifer         2016–   ...          8.1    248,130\n",
              "41       American Horror Story         2011–   ...          8.0    281,978\n",
              "40     Orange Is the New Black      2013–2019  ...          8.0    282,249\n",
              "36                   The Flash         2014–   ...          7.7    313,457\n",
              "39         The Vampire Diaries      2009–2017  ...          7.7    289,568\n",
              "45              13 Reasons Why      2017–2020  ...          7.6    261,974\n",
              "18                       Arrow      2012–2020  ...          7.5    411,910\n",
              "46              Grey's Anatomy         2005–   ...          7.5    259,996\n",
              "\n",
              "[50 rows x 5 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 4
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "r5w93sy0wWWm"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    }
  ]
}