Christmas_Movies.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": [],
      "authorship_tag": "ABX9TyOf7TUd7ING/OkMWlrfW/6x",
      "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/TulipAggarwal/Merry-Christmas/blob/main/Christmas_Movies.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "###**Christmas Movies (2017-22) Analysis**\n",
        "\n",
        "This project works on analysis of various Christmas Movies which were launched from 2017-22. It analyses the data by :   \n",
        "\n",
        "\n",
        "> 1. Finding out which actors appeared the most and the least in christmas movies as a pair that were released from 2017-22.\n",
        "> 2. Finding out the number of movies done by each of the main cast actor for Christmas Movies released from 2017-22.\n",
        "> 3. Finding out the most and least voted Christmas Movies from the ones that were released from 2017-2022.\n",
        "> 4. Finding out the most and least used genre for Christmas Movies released from 2017-2022.\n",
        "> 5. Finding out the longest and shortest christmas movie released from 2017-22.\n",
        "> 6. Finding all the Christmas Movies that start with C, have a rating 6.0 + and are of Drama genre.\n",
        "> 7. Finding out the director who has worked most and least on Christmas Movies released from 2017-22.\n",
        "> 8. Finding out the per category/certificate count for the Christmas Movies released from 2017-2022.\n",
        "> 9. Finding out the exactly 7.1 rated Christmas Movies which were released from 2017-2022.\n",
        "> 10. Finding out the Christmas Movies that have 'cookie' in their description.\n",
        "> 11. Finding out the most common cast (i.e., the 4 people who have appeared together the most) for the Christmas Movies which were released from 2017-22.\n",
        "\n",
        "\n",
        "\n",
        "\n",
        "\n",
        "\n",
        "Dataset used : [IMDB Dataset of All Christmas Movies 2016-2022](https://www.kaggle.com/datasets/fc32844f7c01a95f32aac01a62ec15cc73f000a8809a945ee2e113cd4107a54a)\n"
      ],
      "metadata": {
        "id": "t2PmbawPh5DP"
      }
    },
    {
      "cell_type": "code",
      "execution_count": 90,
      "metadata": {
        "id": "Q9zaJfD42D2m"
      },
      "outputs": [],
      "source": [
        "#importing the pandas library \n",
        "import pandas as pd\n",
        "df = pd.read_csv(\"/content/christmas_movies.csv\", encoding = 'unicode_escape', engine ='python')"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#converting into .xlsx file type and printing the first 20 rows\n",
        "df.to_excel(\"christmas_movie_excel.xlsx\" , index = False)\n",
        "df.head(20)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "5Iz8aH0V5V2W",
        "outputId": "8cf26a78-c6c1-4de4-ed7e-75dad365739e"
      },
      "execution_count": 91,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                      movie_title     release_year certificate     time  \\\n",
              "0                         Shazam!            -2019       PG-13  132 min   \n",
              "1                    Little Women            -2019          PG  135 min   \n",
              "2            A Bad Moms Christmas            -2017           R  104 min   \n",
              "3                      The Grinch            -2018          PG   85 min   \n",
              "4                  Last Christmas            -2019       PG-13  103 min   \n",
              "5                 Happiest Season            -2020       PG-13  102 min   \n",
              "6                        Holidate            -2020       TV-MA  104 min   \n",
              "7                           Klaus            -2019          PG   96 min   \n",
              "8        Christmas at Castle Hart  (2021 TV Movie)        TV-G   84 min   \n",
              "9             The Christmas Train  (2017 TV Movie)        TV-G   99 min   \n",
              "10                 Instant Family            -2018       PG-13  118 min   \n",
              "11       The Christmas Chronicles            -2018          PG  104 min   \n",
              "12               A Christmas Wish  (2019 TV Movie)       TV-PG   90 min   \n",
              "13                         Fatman            -2020           R  100 min   \n",
              "14           Next Stop, Christmas  (2021 TV Movie)        TV-G   84 min   \n",
              "15           Christmas on My Mind  (2019 TV Movie)         NaN   84 min   \n",
              "16              One Royal Holiday  (2020 TV Movie)        TV-G   85 min   \n",
              "17  The Nine Kittens of Christmas  (2021 TV Movie)        TV-G   84 min   \n",
              "18           A Timeless Christmas  (2020 TV Movie)        TV-G   84 min   \n",
              "19       My Christmas Family Tree  (2021 TV Movie)        TV-G   84 min   \n",
              "\n",
              "                           genre  stars                          Score  \\\n",
              "0      Action, Adventure, Comedy    7.0  71        \\n        Metascore   \n",
              "1                 Drama, Romance    7.8  91        \\n        Metascore   \n",
              "2                         Comedy    5.6  42        \\n        Metascore   \n",
              "3      Animation, Comedy, Family    6.3  51        \\n        Metascore   \n",
              "4         Comedy, Drama, Fantasy    6.5  50        \\n        Metascore   \n",
              "5         Comedy, Drama, Romance    6.6  69        \\n        Metascore   \n",
              "6                Comedy, Romance    6.1  44        \\n        Metascore   \n",
              "7   Animation, Adventure, Comedy    8.1  65        \\n        Metascore   \n",
              "8                        Romance    6.3                            NaN   \n",
              "9                 Drama, Romance    6.4                            NaN   \n",
              "10                 Comedy, Drama    7.3  57        \\n        Metascore   \n",
              "11     Adventure, Comedy, Family    7.0  52        \\n        Metascore   \n",
              "12         Comedy, Drama, Family    6.3                            NaN   \n",
              "13     Action, Adventure, Comedy    5.9  40        \\n        Metascore   \n",
              "14        Comedy, Drama, Fantasy    7.1                            NaN   \n",
              "15        Comedy, Drama, Romance    6.5                            NaN   \n",
              "16         Comedy, Drama, Family    7.0                            NaN   \n",
              "17         Comedy, Drama, Family    6.7                            NaN   \n",
              "18      Comedy, Fantasy, Romance    7.1                            NaN   \n",
              "19                Drama, Romance    7.7                            NaN   \n",
              "\n",
              "                                          description      director_name  \\\n",
              "0   A newly fostered young boy in search of his mo...  David F. Sandberg   \n",
              "1   Jo March reflects back and forth on her life, ...       Greta Gerwig   \n",
              "2   As their own mothers drop in unexpectedly, our...          Jon Lucas   \n",
              "3   A grumpy Grinch plots to ruin Christmas for th...      Yarrow Cheney   \n",
              "4   Kate is a young woman subscribed to bad decisi...          Paul Feig   \n",
              "5   A holiday romantic comedy that captures the ra...        Clea DuVall   \n",
              "6   Fed up with being single on holidays, two stra...     John Whitesell   \n",
              "7   A simple act of kindness always sparks another...      Sergio Pablos   \n",
              "8   Brooke Bennett goes to Ireland for Christmas t...      Stefan Scaini   \n",
              "9   A cynical journalist decides to take a train f...         Ron Oliver   \n",
              "10  A couple find themselves in over their heads w...        Sean Anders   \n",
              "11  The story of sister and brother, Kate and Tedd...        Clay Kaytis   \n",
              "12  Maddie slips in a wish that her sister Faith w...  Emily Moss Wilson   \n",
              "13  A rowdy, unorthodox Santa Claus is fighting to...        Eshom Nelms   \n",
              "14  Angie is determined to spend Christmas alone b...      Dustin Rikert   \n",
              "15  When Lucy wakes up with a wedding dress in han...     Maclain Nelson   \n",
              "16  When Anna offers a stranded mother and son she...      Dustin Rikert   \n",
              "17  Zachary and Marilee are thrown back together a...      David Winning   \n",
              "18  Charles Whitley travels from 1903 to 2020 wher...         Ron Oliver   \n",
              "19  When Vanessa receives the results from her Fam...      Jason Bourque   \n",
              "\n",
              "                    cast1                      cast2              cast3  \\\n",
              "0            Zachary Levi                Mark Strong        Asher Angel   \n",
              "1           Saoirse Ronan                Emma Watson      Florence Pugh   \n",
              "2             Scott Moore                 Mila Kunis       Kristen Bell   \n",
              "3            Scott Mosier       Benedict Cumberbatch      Cameron Seely   \n",
              "4       Madison Ingoldsby              Emma Thompson     Boris Isakovic   \n",
              "5         Kristen Stewart            Mackenzie Davis   Mary Steenburgen   \n",
              "6            Emma Roberts                Luke Bracey  Kristin Chenoweth   \n",
              "7   Carlos Martínez López          Jason Schwartzman       J.K. Simmons   \n",
              "8           Lacey Chabert            Stuart Townsend       Ali Hardiman   \n",
              "9         Dermot Mulroney  Kimberly Williams-Paisley       Danny Glover   \n",
              "10          Mark Wahlberg                 Rose Byrne     Isabela Merced   \n",
              "11           Kurt Russell                 Darby Camp        Judah Lewis   \n",
              "12         Hilarie Burton               Tyler Hilton         Megan Park   \n",
              "13              Ian Nelms                 Mel Gibson     Walton Goggins   \n",
              "14         Lyndsy Fonseca            Chandler Massey       Erika Slezak   \n",
              "15          Ashley Greene           Andrew W. Walker       Jackée Harry   \n",
              "16            Laura Osnes          Krystal Joy Brown        Tom McGowan   \n",
              "17          Brandon Routh           Kimberley Sustad   Gregory Harrison   \n",
              "18            Erin Cahill                Ryan Paevey   Brandi Alexander   \n",
              "19        Aimee Teegarden           Andrew W. Walker       James Tupper   \n",
              "\n",
              "                     cast4     votes  \n",
              "0        Jack Dylan Grazer  3,35,718  \n",
              "1            Eliza Scanlen  2,03,580  \n",
              "2             Kathryn Hahn    51,131  \n",
              "3            Rashida Jones    70,679  \n",
              "4              Lucy Miller    78,112  \n",
              "5            Victor Garber    39,569  \n",
              "6           Frances Fisher    65,781  \n",
              "7            Rashida Jones  1,48,613  \n",
              "8             Kate O'Toole     1,328  \n",
              "9              Joan Cusack     2,682  \n",
              "10         Gustavo Escobar  1,07,576  \n",
              "11           Oliver Hudson    72,575  \n",
              "12              Lee Norris       882  \n",
              "13  Marianne Jean-Baptiste    25,257  \n",
              "14            Eric Freeman     1,872  \n",
              "15         Donna Benedicto     1,328  \n",
              "16            Bradley Rose     1,940  \n",
              "17       Stephanie Bennett     1,313  \n",
              "18              Zahf Paroo     2,427  \n",
              "19           Kendall Cross     1,734  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-de18d9b4-698f-4b17-ac85-ec36cc0bf964\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>release_year</th>\n",
              "      <th>certificate</th>\n",
              "      <th>time</th>\n",
              "      <th>genre</th>\n",
              "      <th>stars</th>\n",
              "      <th>Score</th>\n",
              "      <th>description</th>\n",
              "      <th>director_name</th>\n",
              "      <th>cast1</th>\n",
              "      <th>cast2</th>\n",
              "      <th>cast3</th>\n",
              "      <th>cast4</th>\n",
              "      <th>votes</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Shazam!</td>\n",
              "      <td>-2019</td>\n",
              "      <td>PG-13</td>\n",
              "      <td>132 min</td>\n",
              "      <td>Action, Adventure, Comedy</td>\n",
              "      <td>7.0</td>\n",
              "      <td>71        \\n        Metascore</td>\n",
              "      <td>A newly fostered young boy in search of his mo...</td>\n",
              "      <td>David F. Sandberg</td>\n",
              "      <td>Zachary Levi</td>\n",
              "      <td>Mark Strong</td>\n",
              "      <td>Asher Angel</td>\n",
              "      <td>Jack Dylan Grazer</td>\n",
              "      <td>3,35,718</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Little Women</td>\n",
              "      <td>-2019</td>\n",
              "      <td>PG</td>\n",
              "      <td>135 min</td>\n",
              "      <td>Drama, Romance</td>\n",
              "      <td>7.8</td>\n",
              "      <td>91        \\n        Metascore</td>\n",
              "      <td>Jo March reflects back and forth on her life, ...</td>\n",
              "      <td>Greta Gerwig</td>\n",
              "      <td>Saoirse Ronan</td>\n",
              "      <td>Emma Watson</td>\n",
              "      <td>Florence Pugh</td>\n",
              "      <td>Eliza Scanlen</td>\n",
              "      <td>2,03,580</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>A Bad Moms Christmas</td>\n",
              "      <td>-2017</td>\n",
              "      <td>R</td>\n",
              "      <td>104 min</td>\n",
              "      <td>Comedy</td>\n",
              "      <td>5.6</td>\n",
              "      <td>42        \\n        Metascore</td>\n",
              "      <td>As their own mothers drop in unexpectedly, our...</td>\n",
              "      <td>Jon Lucas</td>\n",
              "      <td>Scott Moore</td>\n",
              "      <td>Mila Kunis</td>\n",
              "      <td>Kristen Bell</td>\n",
              "      <td>Kathryn Hahn</td>\n",
              "      <td>51,131</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>The Grinch</td>\n",
              "      <td>-2018</td>\n",
              "      <td>PG</td>\n",
              "      <td>85 min</td>\n",
              "      <td>Animation, Comedy, Family</td>\n",
              "      <td>6.3</td>\n",
              "      <td>51        \\n        Metascore</td>\n",
              "      <td>A grumpy Grinch plots to ruin Christmas for th...</td>\n",
              "      <td>Yarrow Cheney</td>\n",
              "      <td>Scott Mosier</td>\n",
              "      <td>Benedict Cumberbatch</td>\n",
              "      <td>Cameron Seely</td>\n",
              "      <td>Rashida Jones</td>\n",
              "      <td>70,679</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Last Christmas</td>\n",
              "      <td>-2019</td>\n",
              "      <td>PG-13</td>\n",
              "      <td>103 min</td>\n",
              "      <td>Comedy, Drama, Fantasy</td>\n",
              "      <td>6.5</td>\n",
              "      <td>50        \\n        Metascore</td>\n",
              "      <td>Kate is a young woman subscribed to bad decisi...</td>\n",
              "      <td>Paul Feig</td>\n",
              "      <td>Madison Ingoldsby</td>\n",
              "      <td>Emma Thompson</td>\n",
              "      <td>Boris Isakovic</td>\n",
              "      <td>Lucy Miller</td>\n",
              "      <td>78,112</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Happiest Season</td>\n",
              "      <td>-2020</td>\n",
              "      <td>PG-13</td>\n",
              "      <td>102 min</td>\n",
              "      <td>Comedy, Drama, Romance</td>\n",
              "      <td>6.6</td>\n",
              "      <td>69        \\n        Metascore</td>\n",
              "      <td>A holiday romantic comedy that captures the ra...</td>\n",
              "      <td>Clea DuVall</td>\n",
              "      <td>Kristen Stewart</td>\n",
              "      <td>Mackenzie Davis</td>\n",
              "      <td>Mary Steenburgen</td>\n",
              "      <td>Victor Garber</td>\n",
              "      <td>39,569</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Holidate</td>\n",
              "      <td>-2020</td>\n",
              "      <td>TV-MA</td>\n",
              "      <td>104 min</td>\n",
              "      <td>Comedy, Romance</td>\n",
              "      <td>6.1</td>\n",
              "      <td>44        \\n        Metascore</td>\n",
              "      <td>Fed up with being single on holidays, two stra...</td>\n",
              "      <td>John Whitesell</td>\n",
              "      <td>Emma Roberts</td>\n",
              "      <td>Luke Bracey</td>\n",
              "      <td>Kristin Chenoweth</td>\n",
              "      <td>Frances Fisher</td>\n",
              "      <td>65,781</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>Klaus</td>\n",
              "      <td>-2019</td>\n",
              "      <td>PG</td>\n",
              "      <td>96 min</td>\n",
              "      <td>Animation, Adventure, Comedy</td>\n",
              "      <td>8.1</td>\n",
              "      <td>65        \\n        Metascore</td>\n",
              "      <td>A simple act of kindness always sparks another...</td>\n",
              "      <td>Sergio Pablos</td>\n",
              "      <td>Carlos Martínez López</td>\n",
              "      <td>Jason Schwartzman</td>\n",
              "      <td>J.K. Simmons</td>\n",
              "      <td>Rashida Jones</td>\n",
              "      <td>1,48,613</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>Christmas at Castle Hart</td>\n",
              "      <td>(2021 TV Movie)</td>\n",
              "      <td>TV-G</td>\n",
              "      <td>84 min</td>\n",
              "      <td>Romance</td>\n",
              "      <td>6.3</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Brooke Bennett goes to Ireland for Christmas t...</td>\n",
              "      <td>Stefan Scaini</td>\n",
              "      <td>Lacey Chabert</td>\n",
              "      <td>Stuart Townsend</td>\n",
              "      <td>Ali Hardiman</td>\n",
              "      <td>Kate O'Toole</td>\n",
              "      <td>1,328</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>The Christmas Train</td>\n",
              "      <td>(2017 TV Movie)</td>\n",
              "      <td>TV-G</td>\n",
              "      <td>99 min</td>\n",
              "      <td>Drama, Romance</td>\n",
              "      <td>6.4</td>\n",
              "      <td>NaN</td>\n",
              "      <td>A cynical journalist decides to take a train f...</td>\n",
              "      <td>Ron Oliver</td>\n",
              "      <td>Dermot Mulroney</td>\n",
              "      <td>Kimberly Williams-Paisley</td>\n",
              "      <td>Danny Glover</td>\n",
              "      <td>Joan Cusack</td>\n",
              "      <td>2,682</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>Instant Family</td>\n",
              "      <td>-2018</td>\n",
              "      <td>PG-13</td>\n",
              "      <td>118 min</td>\n",
              "      <td>Comedy, Drama</td>\n",
              "      <td>7.3</td>\n",
              "      <td>57        \\n        Metascore</td>\n",
              "      <td>A couple find themselves in over their heads w...</td>\n",
              "      <td>Sean Anders</td>\n",
              "      <td>Mark Wahlberg</td>\n",
              "      <td>Rose Byrne</td>\n",
              "      <td>Isabela Merced</td>\n",
              "      <td>Gustavo Escobar</td>\n",
              "      <td>1,07,576</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>The Christmas Chronicles</td>\n",
              "      <td>-2018</td>\n",
              "      <td>PG</td>\n",
              "      <td>104 min</td>\n",
              "      <td>Adventure, Comedy, Family</td>\n",
              "      <td>7.0</td>\n",
              "      <td>52        \\n        Metascore</td>\n",
              "      <td>The story of sister and brother, Kate and Tedd...</td>\n",
              "      <td>Clay Kaytis</td>\n",
              "      <td>Kurt Russell</td>\n",
              "      <td>Darby Camp</td>\n",
              "      <td>Judah Lewis</td>\n",
              "      <td>Oliver Hudson</td>\n",
              "      <td>72,575</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>A Christmas Wish</td>\n",
              "      <td>(2019 TV Movie)</td>\n",
              "      <td>TV-PG</td>\n",
              "      <td>90 min</td>\n",
              "      <td>Comedy, Drama, Family</td>\n",
              "      <td>6.3</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Maddie slips in a wish that her sister Faith w...</td>\n",
              "      <td>Emily Moss Wilson</td>\n",
              "      <td>Hilarie Burton</td>\n",
              "      <td>Tyler Hilton</td>\n",
              "      <td>Megan Park</td>\n",
              "      <td>Lee Norris</td>\n",
              "      <td>882</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>Fatman</td>\n",
              "      <td>-2020</td>\n",
              "      <td>R</td>\n",
              "      <td>100 min</td>\n",
              "      <td>Action, Adventure, Comedy</td>\n",
              "      <td>5.9</td>\n",
              "      <td>40        \\n        Metascore</td>\n",
              "      <td>A rowdy, unorthodox Santa Claus is fighting to...</td>\n",
              "      <td>Eshom Nelms</td>\n",
              "      <td>Ian Nelms</td>\n",
              "      <td>Mel Gibson</td>\n",
              "      <td>Walton Goggins</td>\n",
              "      <td>Marianne Jean-Baptiste</td>\n",
              "      <td>25,257</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>Next Stop, Christmas</td>\n",
              "      <td>(2021 TV Movie)</td>\n",
              "      <td>TV-G</td>\n",
              "      <td>84 min</td>\n",
              "      <td>Comedy, Drama, Fantasy</td>\n",
              "      <td>7.1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Angie is determined to spend Christmas alone b...</td>\n",
              "      <td>Dustin Rikert</td>\n",
              "      <td>Lyndsy Fonseca</td>\n",
              "      <td>Chandler Massey</td>\n",
              "      <td>Erika Slezak</td>\n",
              "      <td>Eric Freeman</td>\n",
              "      <td>1,872</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>Christmas on My Mind</td>\n",
              "      <td>(2019 TV Movie)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>84 min</td>\n",
              "      <td>Comedy, Drama, Romance</td>\n",
              "      <td>6.5</td>\n",
              "      <td>NaN</td>\n",
              "      <td>When Lucy wakes up with a wedding dress in han...</td>\n",
              "      <td>Maclain Nelson</td>\n",
              "      <td>Ashley Greene</td>\n",
              "      <td>Andrew W. Walker</td>\n",
              "      <td>Jackée Harry</td>\n",
              "      <td>Donna Benedicto</td>\n",
              "      <td>1,328</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>One Royal Holiday</td>\n",
              "      <td>(2020 TV Movie)</td>\n",
              "      <td>TV-G</td>\n",
              "      <td>85 min</td>\n",
              "      <td>Comedy, Drama, Family</td>\n",
              "      <td>7.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>When Anna offers a stranded mother and son she...</td>\n",
              "      <td>Dustin Rikert</td>\n",
              "      <td>Laura Osnes</td>\n",
              "      <td>Krystal Joy Brown</td>\n",
              "      <td>Tom McGowan</td>\n",
              "      <td>Bradley Rose</td>\n",
              "      <td>1,940</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>The Nine Kittens of Christmas</td>\n",
              "      <td>(2021 TV Movie)</td>\n",
              "      <td>TV-G</td>\n",
              "      <td>84 min</td>\n",
              "      <td>Comedy, Drama, Family</td>\n",
              "      <td>6.7</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Zachary and Marilee are thrown back together a...</td>\n",
              "      <td>David Winning</td>\n",
              "      <td>Brandon Routh</td>\n",
              "      <td>Kimberley Sustad</td>\n",
              "      <td>Gregory Harrison</td>\n",
              "      <td>Stephanie Bennett</td>\n",
              "      <td>1,313</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>A Timeless Christmas</td>\n",
              "      <td>(2020 TV Movie)</td>\n",
              "      <td>TV-G</td>\n",
              "      <td>84 min</td>\n",
              "      <td>Comedy, Fantasy, Romance</td>\n",
              "      <td>7.1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Charles Whitley travels from 1903 to 2020 wher...</td>\n",
              "      <td>Ron Oliver</td>\n",
              "      <td>Erin Cahill</td>\n",
              "      <td>Ryan Paevey</td>\n",
              "      <td>Brandi Alexander</td>\n",
              "      <td>Zahf Paroo</td>\n",
              "      <td>2,427</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>My Christmas Family Tree</td>\n",
              "      <td>(2021 TV Movie)</td>\n",
              "      <td>TV-G</td>\n",
              "      <td>84 min</td>\n",
              "      <td>Drama, Romance</td>\n",
              "      <td>7.7</td>\n",
              "      <td>NaN</td>\n",
              "      <td>When Vanessa receives the results from her Fam...</td>\n",
              "      <td>Jason Bourque</td>\n",
              "      <td>Aimee Teegarden</td>\n",
              "      <td>Andrew W. Walker</td>\n",
              "      <td>James Tupper</td>\n",
              "      <td>Kendall Cross</td>\n",
              "      <td>1,734</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-de18d9b4-698f-4b17-ac85-ec36cc0bf964')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-de18d9b4-698f-4b17-ac85-ec36cc0bf964 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-de18d9b4-698f-4b17-ac85-ec36cc0bf964');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 91
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#dropping the column 'score' as very few movies have the score and hence will tamper the data \n",
        "del df[\"Score\"]"
      ],
      "metadata": {
        "id": "16rNhxHBGVzy"
      },
      "execution_count": 92,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "#creating a new column of all actors that has cummulative results from cast1,2,3 and 4 separated by commas\n",
        "df[\"all_actors\"] = df[['cast1', 'cast2', 'cast3', 'cast4']].astype(str).agg(' , '.join, axis=1)\n",
        "df.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 635
        },
        "id": "Hkhz2grA57HQ",
        "outputId": "b66d30e4-666e-443d-cc7f-caf3cf43a6e5"
      },
      "execution_count": 93,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "            movie_title release_year certificate     time  \\\n",
              "0               Shazam!        -2019       PG-13  132 min   \n",
              "1          Little Women        -2019          PG  135 min   \n",
              "2  A Bad Moms Christmas        -2017           R  104 min   \n",
              "3            The Grinch        -2018          PG   85 min   \n",
              "4        Last Christmas        -2019       PG-13  103 min   \n",
              "\n",
              "                       genre  stars  \\\n",
              "0  Action, Adventure, Comedy    7.0   \n",
              "1             Drama, Romance    7.8   \n",
              "2                     Comedy    5.6   \n",
              "3  Animation, Comedy, Family    6.3   \n",
              "4     Comedy, Drama, Fantasy    6.5   \n",
              "\n",
              "                                         description      director_name  \\\n",
              "0  A newly fostered young boy in search of his mo...  David F. Sandberg   \n",
              "1  Jo March reflects back and forth on her life, ...       Greta Gerwig   \n",
              "2  As their own mothers drop in unexpectedly, our...          Jon Lucas   \n",
              "3  A grumpy Grinch plots to ruin Christmas for th...      Yarrow Cheney   \n",
              "4  Kate is a young woman subscribed to bad decisi...          Paul Feig   \n",
              "\n",
              "               cast1                 cast2           cast3              cast4  \\\n",
              "0       Zachary Levi           Mark Strong     Asher Angel  Jack Dylan Grazer   \n",
              "1      Saoirse Ronan           Emma Watson   Florence Pugh      Eliza Scanlen   \n",
              "2        Scott Moore            Mila Kunis    Kristen Bell       Kathryn Hahn   \n",
              "3       Scott Mosier  Benedict Cumberbatch   Cameron Seely      Rashida Jones   \n",
              "4  Madison Ingoldsby         Emma Thompson  Boris Isakovic        Lucy Miller   \n",
              "\n",
              "      votes                                         all_actors  \n",
              "0  3,35,718  Zachary Levi , Mark Strong , Asher Angel , Jac...  \n",
              "1  2,03,580  Saoirse Ronan , Emma Watson , Florence Pugh , ...  \n",
              "2    51,131  Scott Moore , Mila Kunis , Kristen Bell , Kath...  \n",
              "3    70,679  Scott Mosier , Benedict Cumberbatch , Cameron ...  \n",
              "4    78,112  Madison Ingoldsby , Emma Thompson , Boris Isak...  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-780697e4-b48a-4e34-a613-1d43e85d8612\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>release_year</th>\n",
              "      <th>certificate</th>\n",
              "      <th>time</th>\n",
              "      <th>genre</th>\n",
              "      <th>stars</th>\n",
              "      <th>description</th>\n",
              "      <th>director_name</th>\n",
              "      <th>cast1</th>\n",
              "      <th>cast2</th>\n",
              "      <th>cast3</th>\n",
              "      <th>cast4</th>\n",
              "      <th>votes</th>\n",
              "      <th>all_actors</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Shazam!</td>\n",
              "      <td>-2019</td>\n",
              "      <td>PG-13</td>\n",
              "      <td>132 min</td>\n",
              "      <td>Action, Adventure, Comedy</td>\n",
              "      <td>7.0</td>\n",
              "      <td>A newly fostered young boy in search of his mo...</td>\n",
              "      <td>David F. Sandberg</td>\n",
              "      <td>Zachary Levi</td>\n",
              "      <td>Mark Strong</td>\n",
              "      <td>Asher Angel</td>\n",
              "      <td>Jack Dylan Grazer</td>\n",
              "      <td>3,35,718</td>\n",
              "      <td>Zachary Levi , Mark Strong , Asher Angel , Jac...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Little Women</td>\n",
              "      <td>-2019</td>\n",
              "      <td>PG</td>\n",
              "      <td>135 min</td>\n",
              "      <td>Drama, Romance</td>\n",
              "      <td>7.8</td>\n",
              "      <td>Jo March reflects back and forth on her life, ...</td>\n",
              "      <td>Greta Gerwig</td>\n",
              "      <td>Saoirse Ronan</td>\n",
              "      <td>Emma Watson</td>\n",
              "      <td>Florence Pugh</td>\n",
              "      <td>Eliza Scanlen</td>\n",
              "      <td>2,03,580</td>\n",
              "      <td>Saoirse Ronan , Emma Watson , Florence Pugh , ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>A Bad Moms Christmas</td>\n",
              "      <td>-2017</td>\n",
              "      <td>R</td>\n",
              "      <td>104 min</td>\n",
              "      <td>Comedy</td>\n",
              "      <td>5.6</td>\n",
              "      <td>As their own mothers drop in unexpectedly, our...</td>\n",
              "      <td>Jon Lucas</td>\n",
              "      <td>Scott Moore</td>\n",
              "      <td>Mila Kunis</td>\n",
              "      <td>Kristen Bell</td>\n",
              "      <td>Kathryn Hahn</td>\n",
              "      <td>51,131</td>\n",
              "      <td>Scott Moore , Mila Kunis , Kristen Bell , Kath...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>The Grinch</td>\n",
              "      <td>-2018</td>\n",
              "      <td>PG</td>\n",
              "      <td>85 min</td>\n",
              "      <td>Animation, Comedy, Family</td>\n",
              "      <td>6.3</td>\n",
              "      <td>A grumpy Grinch plots to ruin Christmas for th...</td>\n",
              "      <td>Yarrow Cheney</td>\n",
              "      <td>Scott Mosier</td>\n",
              "      <td>Benedict Cumberbatch</td>\n",
              "      <td>Cameron Seely</td>\n",
              "      <td>Rashida Jones</td>\n",
              "      <td>70,679</td>\n",
              "      <td>Scott Mosier , Benedict Cumberbatch , Cameron ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Last Christmas</td>\n",
              "      <td>-2019</td>\n",
              "      <td>PG-13</td>\n",
              "      <td>103 min</td>\n",
              "      <td>Comedy, Drama, Fantasy</td>\n",
              "      <td>6.5</td>\n",
              "      <td>Kate is a young woman subscribed to bad decisi...</td>\n",
              "      <td>Paul Feig</td>\n",
              "      <td>Madison Ingoldsby</td>\n",
              "      <td>Emma Thompson</td>\n",
              "      <td>Boris Isakovic</td>\n",
              "      <td>Lucy Miller</td>\n",
              "      <td>78,112</td>\n",
              "      <td>Madison Ingoldsby , Emma Thompson , Boris Isak...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-780697e4-b48a-4e34-a613-1d43e85d8612')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-780697e4-b48a-4e34-a613-1d43e85d8612 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-780697e4-b48a-4e34-a613-1d43e85d8612');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 93
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "## Finding out which actors appeared the most and the least in Christmas Movies as a pair that were released from 2017-22."
      ],
      "metadata": {
        "id": "YM5HAfvY58Wc"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "#10 most common pairs appeared in the christmas movies from 2017-2022\n",
        "from itertools import combinations\n",
        "from collections import Counter\n",
        "\n",
        "count = Counter()\n",
        "for row in df[\"all_actors\"]:\n",
        "  row_list = row.split(',') #Creating the sublist and segrating by each comma\n",
        "  count.update(Counter(combinations(row_list,2)))\n",
        "count.most_common(10) "
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "hopc9W6r9Aao",
        "outputId": "ef356c0f-b716-482a-83c2-3849ed44179b"
      },
      "execution_count": 109,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "[(('Rose McIver ', ' Ben Lamb '), 3),\n",
              " (('Rose McIver ', ' Alice Krige '), 3),\n",
              " (('Rose McIver ', ' Honor Kneafsey'), 3),\n",
              " ((' Ben Lamb ', ' Alice Krige '), 3),\n",
              " ((' Ben Lamb ', ' Honor Kneafsey'), 3),\n",
              " ((' Alice Krige ', ' Honor Kneafsey'), 3),\n",
              " (('Erin Krakow ', ' Niall Matter '), 3),\n",
              " (('Kurt Russell ', ' Darby Camp '), 2),\n",
              " (('Kimberley Sustad ', ' Paul Campbell '), 2),\n",
              " (('Vanessa Hudgens ', ' Sam Palladio '), 2)]"
            ]
          },
          "metadata": {},
          "execution_count": 109
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#10 most uncommon pairs appeared in the christmas movies from 2017-2022\n",
        "from itertools import combinations\n",
        "from collections import Counter\n",
        "\n",
        "count = Counter()\n",
        "for row in df[\"all_actors\"]:\n",
        "  row_list = row.split(',') #Creating the sublist and segrating by each comma\n",
        "  count.update(Counter(combinations(row_list,2)))\n",
        "count.most_common()[:-10-1:-1]   "
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "RyuuYPM4-A3b",
        "outputId": "46a597e2-ea31-449f-d532-ad172e2a4ee4"
      },
      "execution_count": 108,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "[((' Fabrice-Ange Zaphiratos ', ' nan'), 1),\n",
              " ((' Jay Bauman ', ' nan'), 1),\n",
              " ((' Jay Bauman ', ' Fabrice-Ange Zaphiratos '), 1),\n",
              " (('Josh Davis ', ' nan'), 1),\n",
              " (('Josh Davis ', ' Fabrice-Ange Zaphiratos '), 1),\n",
              " (('Josh Davis ', ' Jay Bauman '), 1),\n",
              " ((' Lare Roberts ', ' Kathlene Ashcraft'), 1),\n",
              " ((' Lewis Wright ', ' Kathlene Ashcraft'), 1),\n",
              " ((' Lewis Wright ', ' Lare Roberts '), 1),\n",
              " (('Spencer Kingsley ', ' Kathlene Ashcraft'), 1)]"
            ]
          },
          "metadata": {},
          "execution_count": 108
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "## Finding out the number of movies done by each of the main cast actor for Christmas Movies released from 2017-22."
      ],
      "metadata": {
        "id": "JvEfb4qMBzXw"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "#number of films done by each of the main cast actors\n",
        "newdf = df.groupby(\"cast1\")[\"cast1\"].count()\n",
        "newdf.sort_values(ascending=False)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "gu60Y27K-_Av",
        "outputId": "baeb891a-5f8d-4f5b-85cf-fb6f7b91bb0e"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "cast1\n",
              "Alicia Witt             5\n",
              "Lacey Chabert           5\n",
              "Merritt Patterson       5\n",
              "Taylor Cole             4\n",
              "Erin Cahill             4\n",
              "                       ..\n",
              "Holly Deveaux           1\n",
              "Holly Robinson Peete    1\n",
              "Ian Nelms               1\n",
              "Ida Elise Broch         1\n",
              "Zachary Levi            1\n",
              "Name: cast1, Length: 207, dtype: int64"
            ]
          },
          "metadata": {},
          "execution_count": 138
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "## Finding out the most and least voted Christmas Movies from the ones that were released from 2017-2022."
      ],
      "metadata": {
        "id": "P7X1-JHHCA5h"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "#removing the commas from votes and converting the values into int type\n",
        "#printing the 5 most voted movie released from 2017-2022\n",
        "df[\"votes\"] = df[\"votes\"].str.replace(',', '').astype(int)\n",
        "df.sort_values(\"votes\", ascending=False)\n",
        "df.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 635
        },
        "id": "ysB5uhnQCIFO",
        "outputId": "91133dab-86e3-4f96-fc26-8a3519be7090"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "            movie_title release_year certificate     time  \\\n",
              "0               Shazam!        -2019       PG-13  132 min   \n",
              "1          Little Women        -2019          PG  135 min   \n",
              "2  A Bad Moms Christmas        -2017           R  104 min   \n",
              "3            The Grinch        -2018          PG   85 min   \n",
              "4        Last Christmas        -2019       PG-13  103 min   \n",
              "\n",
              "                       genre  stars  \\\n",
              "0  Action, Adventure, Comedy    7.0   \n",
              "1             Drama, Romance    7.8   \n",
              "2                     Comedy    5.6   \n",
              "3  Animation, Comedy, Family    6.3   \n",
              "4     Comedy, Drama, Fantasy    6.5   \n",
              "\n",
              "                                         description      director_name  \\\n",
              "0  A newly fostered young boy in search of his mo...  David F. Sandberg   \n",
              "1  Jo March reflects back and forth on her life, ...       Greta Gerwig   \n",
              "2  As their own mothers drop in unexpectedly, our...          Jon Lucas   \n",
              "3  A grumpy Grinch plots to ruin Christmas for th...      Yarrow Cheney   \n",
              "4  Kate is a young woman subscribed to bad decisi...          Paul Feig   \n",
              "\n",
              "               cast1                 cast2           cast3              cast4  \\\n",
              "0       Zachary Levi           Mark Strong     Asher Angel  Jack Dylan Grazer   \n",
              "1      Saoirse Ronan           Emma Watson   Florence Pugh      Eliza Scanlen   \n",
              "2        Scott Moore            Mila Kunis    Kristen Bell       Kathryn Hahn   \n",
              "3       Scott Mosier  Benedict Cumberbatch   Cameron Seely      Rashida Jones   \n",
              "4  Madison Ingoldsby         Emma Thompson  Boris Isakovic        Lucy Miller   \n",
              "\n",
              "    votes                                         all_actors  \n",
              "0  335718  Zachary Levi , Mark Strong , Asher Angel , Jac...  \n",
              "1  203580  Saoirse Ronan , Emma Watson , Florence Pugh , ...  \n",
              "2   51131  Scott Moore , Mila Kunis , Kristen Bell , Kath...  \n",
              "3   70679  Scott Mosier , Benedict Cumberbatch , Cameron ...  \n",
              "4   78112  Madison Ingoldsby , Emma Thompson , Boris Isak...  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-f6ab3b2e-6307-4ec8-a350-ec7bf17eaafb\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>release_year</th>\n",
              "      <th>certificate</th>\n",
              "      <th>time</th>\n",
              "      <th>genre</th>\n",
              "      <th>stars</th>\n",
              "      <th>description</th>\n",
              "      <th>director_name</th>\n",
              "      <th>cast1</th>\n",
              "      <th>cast2</th>\n",
              "      <th>cast3</th>\n",
              "      <th>cast4</th>\n",
              "      <th>votes</th>\n",
              "      <th>all_actors</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Shazam!</td>\n",
              "      <td>-2019</td>\n",
              "      <td>PG-13</td>\n",
              "      <td>132 min</td>\n",
              "      <td>Action, Adventure, Comedy</td>\n",
              "      <td>7.0</td>\n",
              "      <td>A newly fostered young boy in search of his mo...</td>\n",
              "      <td>David F. Sandberg</td>\n",
              "      <td>Zachary Levi</td>\n",
              "      <td>Mark Strong</td>\n",
              "      <td>Asher Angel</td>\n",
              "      <td>Jack Dylan Grazer</td>\n",
              "      <td>335718</td>\n",
              "      <td>Zachary Levi , Mark Strong , Asher Angel , Jac...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Little Women</td>\n",
              "      <td>-2019</td>\n",
              "      <td>PG</td>\n",
              "      <td>135 min</td>\n",
              "      <td>Drama, Romance</td>\n",
              "      <td>7.8</td>\n",
              "      <td>Jo March reflects back and forth on her life, ...</td>\n",
              "      <td>Greta Gerwig</td>\n",
              "      <td>Saoirse Ronan</td>\n",
              "      <td>Emma Watson</td>\n",
              "      <td>Florence Pugh</td>\n",
              "      <td>Eliza Scanlen</td>\n",
              "      <td>203580</td>\n",
              "      <td>Saoirse Ronan , Emma Watson , Florence Pugh , ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>A Bad Moms Christmas</td>\n",
              "      <td>-2017</td>\n",
              "      <td>R</td>\n",
              "      <td>104 min</td>\n",
              "      <td>Comedy</td>\n",
              "      <td>5.6</td>\n",
              "      <td>As their own mothers drop in unexpectedly, our...</td>\n",
              "      <td>Jon Lucas</td>\n",
              "      <td>Scott Moore</td>\n",
              "      <td>Mila Kunis</td>\n",
              "      <td>Kristen Bell</td>\n",
              "      <td>Kathryn Hahn</td>\n",
              "      <td>51131</td>\n",
              "      <td>Scott Moore , Mila Kunis , Kristen Bell , Kath...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>The Grinch</td>\n",
              "      <td>-2018</td>\n",
              "      <td>PG</td>\n",
              "      <td>85 min</td>\n",
              "      <td>Animation, Comedy, Family</td>\n",
              "      <td>6.3</td>\n",
              "      <td>A grumpy Grinch plots to ruin Christmas for th...</td>\n",
              "      <td>Yarrow Cheney</td>\n",
              "      <td>Scott Mosier</td>\n",
              "      <td>Benedict Cumberbatch</td>\n",
              "      <td>Cameron Seely</td>\n",
              "      <td>Rashida Jones</td>\n",
              "      <td>70679</td>\n",
              "      <td>Scott Mosier , Benedict Cumberbatch , Cameron ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Last Christmas</td>\n",
              "      <td>-2019</td>\n",
              "      <td>PG-13</td>\n",
              "      <td>103 min</td>\n",
              "      <td>Comedy, Drama, Fantasy</td>\n",
              "      <td>6.5</td>\n",
              "      <td>Kate is a young woman subscribed to bad decisi...</td>\n",
              "      <td>Paul Feig</td>\n",
              "      <td>Madison Ingoldsby</td>\n",
              "      <td>Emma Thompson</td>\n",
              "      <td>Boris Isakovic</td>\n",
              "      <td>Lucy Miller</td>\n",
              "      <td>78112</td>\n",
              "      <td>Madison Ingoldsby , Emma Thompson , Boris Isak...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-f6ab3b2e-6307-4ec8-a350-ec7bf17eaafb')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-f6ab3b2e-6307-4ec8-a350-ec7bf17eaafb button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-f6ab3b2e-6307-4ec8-a350-ec7bf17eaafb');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 154
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#printing the 5 least voted movie released from 2017-2022\n",
        "df.sort_values(\"votes\")\n",
        "df.tail(5)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 704
        },
        "id": "GKJEiAP0HbDu",
        "outputId": "4b51c3b0-f702-4e45-af4b-6b569bf95c9e"
      },
      "execution_count": 8,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                     movie_title     release_year certificate     time  \\\n",
              "273    An Unremarkable Christmas  (2020 TV Movie)       TV-14   82 min   \n",
              "274        Christmas with Cookie            -2016         NaN   53 min   \n",
              "275  Community Theater Christmas            -2019       TV-14  103 min   \n",
              "276             Discarding Santa            -2018         NaN   85 min   \n",
              "277                     re: View         (2016 )         NaN   37 min   \n",
              "\n",
              "                       genre  stars  \\\n",
              "273             Comedy,Drama    3.2   \n",
              "274     Comedy,Horror,Sci-Fi    4.7   \n",
              "275                   Comedy    7.5   \n",
              "276  Adventure,Comedy,Family    4.8   \n",
              "277         Comedy,Talk-Show    7.1   \n",
              "\n",
              "                                           description       director_name  \\\n",
              "273  Before the events of S1, Juanquini, El Ñato an...  Juan Camilo Pinzon   \n",
              "274  In the year 3978 global warming has made a des...         Alan Maxson   \n",
              "275  A community theater competes for a state grant...     Melissa Vitello   \n",
              "276  \"In 2010, the city of Leitchfield, Kentucky de...            Bob Maze   \n",
              "277  Jay Bauman and Josh Davis take a look at Jay's...          Jay Bauman   \n",
              "\n",
              "                   cast1           cast2                    cast3  \\\n",
              "273  Luis Eduardo Arango   Julián Cerati   Aura Cristina Geithner   \n",
              "274       Shawn Schminke     Alan Maxson              Dana Austen   \n",
              "275      IsaBeall Quella  Veronica Wylie          Marissa Pistone   \n",
              "276     Spencer Kingsley    Lewis Wright             Lare Roberts   \n",
              "277           Josh Davis      Jay Bauman  Fabrice-Ange Zaphiratos   \n",
              "\n",
              "                 cast4 votes  \\\n",
              "273      Mariana Gómez   144   \n",
              "274       Justin Armao    70   \n",
              "275           Dan Pena    52   \n",
              "276  Kathlene Ashcraft    41   \n",
              "277                NaN    18   \n",
              "\n",
              "                                            all_actors  \n",
              "273  Luis Eduardo Arango , Julián Cerati , Aura Cri...  \n",
              "274  Shawn Schminke , Alan Maxson , Dana Austen , J...  \n",
              "275  IsaBeall Quella , Veronica Wylie , Marissa Pis...  \n",
              "276  Spencer Kingsley , Lewis Wright , Lare Roberts...  \n",
              "277  Josh Davis , Jay Bauman , Fabrice-Ange Zaphira...  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-7a6f3e70-fee4-4d11-bab6-121e926f1499\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>release_year</th>\n",
              "      <th>certificate</th>\n",
              "      <th>time</th>\n",
              "      <th>genre</th>\n",
              "      <th>stars</th>\n",
              "      <th>description</th>\n",
              "      <th>director_name</th>\n",
              "      <th>cast1</th>\n",
              "      <th>cast2</th>\n",
              "      <th>cast3</th>\n",
              "      <th>cast4</th>\n",
              "      <th>votes</th>\n",
              "      <th>all_actors</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>273</th>\n",
              "      <td>An Unremarkable Christmas</td>\n",
              "      <td>(2020 TV Movie)</td>\n",
              "      <td>TV-14</td>\n",
              "      <td>82 min</td>\n",
              "      <td>Comedy,Drama</td>\n",
              "      <td>3.2</td>\n",
              "      <td>Before the events of S1, Juanquini, El Ñato an...</td>\n",
              "      <td>Juan Camilo Pinzon</td>\n",
              "      <td>Luis Eduardo Arango</td>\n",
              "      <td>Julián Cerati</td>\n",
              "      <td>Aura Cristina Geithner</td>\n",
              "      <td>Mariana Gómez</td>\n",
              "      <td>144</td>\n",
              "      <td>Luis Eduardo Arango , Julián Cerati , Aura Cri...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>274</th>\n",
              "      <td>Christmas with Cookie</td>\n",
              "      <td>-2016</td>\n",
              "      <td>NaN</td>\n",
              "      <td>53 min</td>\n",
              "      <td>Comedy,Horror,Sci-Fi</td>\n",
              "      <td>4.7</td>\n",
              "      <td>In the year 3978 global warming has made a des...</td>\n",
              "      <td>Alan Maxson</td>\n",
              "      <td>Shawn Schminke</td>\n",
              "      <td>Alan Maxson</td>\n",
              "      <td>Dana Austen</td>\n",
              "      <td>Justin Armao</td>\n",
              "      <td>70</td>\n",
              "      <td>Shawn Schminke , Alan Maxson , Dana Austen , J...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>275</th>\n",
              "      <td>Community Theater Christmas</td>\n",
              "      <td>-2019</td>\n",
              "      <td>TV-14</td>\n",
              "      <td>103 min</td>\n",
              "      <td>Comedy</td>\n",
              "      <td>7.5</td>\n",
              "      <td>A community theater competes for a state grant...</td>\n",
              "      <td>Melissa Vitello</td>\n",
              "      <td>IsaBeall Quella</td>\n",
              "      <td>Veronica Wylie</td>\n",
              "      <td>Marissa Pistone</td>\n",
              "      <td>Dan Pena</td>\n",
              "      <td>52</td>\n",
              "      <td>IsaBeall Quella , Veronica Wylie , Marissa Pis...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>276</th>\n",
              "      <td>Discarding Santa</td>\n",
              "      <td>-2018</td>\n",
              "      <td>NaN</td>\n",
              "      <td>85 min</td>\n",
              "      <td>Adventure,Comedy,Family</td>\n",
              "      <td>4.8</td>\n",
              "      <td>\"In 2010, the city of Leitchfield, Kentucky de...</td>\n",
              "      <td>Bob Maze</td>\n",
              "      <td>Spencer Kingsley</td>\n",
              "      <td>Lewis Wright</td>\n",
              "      <td>Lare Roberts</td>\n",
              "      <td>Kathlene Ashcraft</td>\n",
              "      <td>41</td>\n",
              "      <td>Spencer Kingsley , Lewis Wright , Lare Roberts...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>277</th>\n",
              "      <td>re: View</td>\n",
              "      <td>(2016 )</td>\n",
              "      <td>NaN</td>\n",
              "      <td>37 min</td>\n",
              "      <td>Comedy,Talk-Show</td>\n",
              "      <td>7.1</td>\n",
              "      <td>Jay Bauman and Josh Davis take a look at Jay's...</td>\n",
              "      <td>Jay Bauman</td>\n",
              "      <td>Josh Davis</td>\n",
              "      <td>Jay Bauman</td>\n",
              "      <td>Fabrice-Ange Zaphiratos</td>\n",
              "      <td>NaN</td>\n",
              "      <td>18</td>\n",
              "      <td>Josh Davis , Jay Bauman , Fabrice-Ange Zaphira...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-7a6f3e70-fee4-4d11-bab6-121e926f1499')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-7a6f3e70-fee4-4d11-bab6-121e926f1499 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-7a6f3e70-fee4-4d11-bab6-121e926f1499');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 8
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "##Finding out the most and least used genre for Christmas Movies released from 2017-2022."
      ],
      "metadata": {
        "id": "JF8N3OVkIyRW"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "#Cleaning the data so that 'Drama' and ' Drama' is being read as same\n",
        "df[\"genre\"] = df[\"genre\"].str.replace(' ', '').astype(str)\n",
        "df.sort_values(\"genre\", ascending=False)\n",
        "df.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 635
        },
        "id": "oM-fLsj584_x",
        "outputId": "1a6553d3-4060-474e-e8c2-355b458211ae"
      },
      "execution_count": 9,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "            movie_title release_year certificate     time  \\\n",
              "0               Shazam!        -2019       PG-13  132 min   \n",
              "1          Little Women        -2019          PG  135 min   \n",
              "2  A Bad Moms Christmas        -2017           R  104 min   \n",
              "3            The Grinch        -2018          PG   85 min   \n",
              "4        Last Christmas        -2019       PG-13  103 min   \n",
              "\n",
              "                     genre  stars  \\\n",
              "0  Action,Adventure,Comedy    7.0   \n",
              "1            Drama,Romance    7.8   \n",
              "2                   Comedy    5.6   \n",
              "3  Animation,Comedy,Family    6.3   \n",
              "4     Comedy,Drama,Fantasy    6.5   \n",
              "\n",
              "                                         description      director_name  \\\n",
              "0  A newly fostered young boy in search of his mo...  David F. Sandberg   \n",
              "1  Jo March reflects back and forth on her life, ...       Greta Gerwig   \n",
              "2  As their own mothers drop in unexpectedly, our...          Jon Lucas   \n",
              "3  A grumpy Grinch plots to ruin Christmas for th...      Yarrow Cheney   \n",
              "4  Kate is a young woman subscribed to bad decisi...          Paul Feig   \n",
              "\n",
              "               cast1                 cast2           cast3              cast4  \\\n",
              "0       Zachary Levi           Mark Strong     Asher Angel  Jack Dylan Grazer   \n",
              "1      Saoirse Ronan           Emma Watson   Florence Pugh      Eliza Scanlen   \n",
              "2        Scott Moore            Mila Kunis    Kristen Bell       Kathryn Hahn   \n",
              "3       Scott Mosier  Benedict Cumberbatch   Cameron Seely      Rashida Jones   \n",
              "4  Madison Ingoldsby         Emma Thompson  Boris Isakovic        Lucy Miller   \n",
              "\n",
              "      votes                                         all_actors  \n",
              "0  3,35,718  Zachary Levi , Mark Strong , Asher Angel , Jac...  \n",
              "1  2,03,580  Saoirse Ronan , Emma Watson , Florence Pugh , ...  \n",
              "2    51,131  Scott Moore , Mila Kunis , Kristen Bell , Kath...  \n",
              "3    70,679  Scott Mosier , Benedict Cumberbatch , Cameron ...  \n",
              "4    78,112  Madison Ingoldsby , Emma Thompson , Boris Isak...  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-698e8c0a-89ec-4860-9ec7-edae0c87b5e9\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>release_year</th>\n",
              "      <th>certificate</th>\n",
              "      <th>time</th>\n",
              "      <th>genre</th>\n",
              "      <th>stars</th>\n",
              "      <th>description</th>\n",
              "      <th>director_name</th>\n",
              "      <th>cast1</th>\n",
              "      <th>cast2</th>\n",
              "      <th>cast3</th>\n",
              "      <th>cast4</th>\n",
              "      <th>votes</th>\n",
              "      <th>all_actors</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Shazam!</td>\n",
              "      <td>-2019</td>\n",
              "      <td>PG-13</td>\n",
              "      <td>132 min</td>\n",
              "      <td>Action,Adventure,Comedy</td>\n",
              "      <td>7.0</td>\n",
              "      <td>A newly fostered young boy in search of his mo...</td>\n",
              "      <td>David F. Sandberg</td>\n",
              "      <td>Zachary Levi</td>\n",
              "      <td>Mark Strong</td>\n",
              "      <td>Asher Angel</td>\n",
              "      <td>Jack Dylan Grazer</td>\n",
              "      <td>3,35,718</td>\n",
              "      <td>Zachary Levi , Mark Strong , Asher Angel , Jac...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Little Women</td>\n",
              "      <td>-2019</td>\n",
              "      <td>PG</td>\n",
              "      <td>135 min</td>\n",
              "      <td>Drama,Romance</td>\n",
              "      <td>7.8</td>\n",
              "      <td>Jo March reflects back and forth on her life, ...</td>\n",
              "      <td>Greta Gerwig</td>\n",
              "      <td>Saoirse Ronan</td>\n",
              "      <td>Emma Watson</td>\n",
              "      <td>Florence Pugh</td>\n",
              "      <td>Eliza Scanlen</td>\n",
              "      <td>2,03,580</td>\n",
              "      <td>Saoirse Ronan , Emma Watson , Florence Pugh , ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>A Bad Moms Christmas</td>\n",
              "      <td>-2017</td>\n",
              "      <td>R</td>\n",
              "      <td>104 min</td>\n",
              "      <td>Comedy</td>\n",
              "      <td>5.6</td>\n",
              "      <td>As their own mothers drop in unexpectedly, our...</td>\n",
              "      <td>Jon Lucas</td>\n",
              "      <td>Scott Moore</td>\n",
              "      <td>Mila Kunis</td>\n",
              "      <td>Kristen Bell</td>\n",
              "      <td>Kathryn Hahn</td>\n",
              "      <td>51,131</td>\n",
              "      <td>Scott Moore , Mila Kunis , Kristen Bell , Kath...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>The Grinch</td>\n",
              "      <td>-2018</td>\n",
              "      <td>PG</td>\n",
              "      <td>85 min</td>\n",
              "      <td>Animation,Comedy,Family</td>\n",
              "      <td>6.3</td>\n",
              "      <td>A grumpy Grinch plots to ruin Christmas for th...</td>\n",
              "      <td>Yarrow Cheney</td>\n",
              "      <td>Scott Mosier</td>\n",
              "      <td>Benedict Cumberbatch</td>\n",
              "      <td>Cameron Seely</td>\n",
              "      <td>Rashida Jones</td>\n",
              "      <td>70,679</td>\n",
              "      <td>Scott Mosier , Benedict Cumberbatch , Cameron ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Last Christmas</td>\n",
              "      <td>-2019</td>\n",
              "      <td>PG-13</td>\n",
              "      <td>103 min</td>\n",
              "      <td>Comedy,Drama,Fantasy</td>\n",
              "      <td>6.5</td>\n",
              "      <td>Kate is a young woman subscribed to bad decisi...</td>\n",
              "      <td>Paul Feig</td>\n",
              "      <td>Madison Ingoldsby</td>\n",
              "      <td>Emma Thompson</td>\n",
              "      <td>Boris Isakovic</td>\n",
              "      <td>Lucy Miller</td>\n",
              "      <td>78,112</td>\n",
              "      <td>Madison Ingoldsby , Emma Thompson , Boris Isak...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-698e8c0a-89ec-4860-9ec7-edae0c87b5e9')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-698e8c0a-89ec-4860-9ec7-edae0c87b5e9 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-698e8c0a-89ec-4860-9ec7-edae0c87b5e9');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 9
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#10 most common genre appeared in the christmas movies from 2017-2022\n",
        "from itertools import combinations\n",
        "from collections import Counter\n",
        "\n",
        "count = Counter()\n",
        "for row in df[\"genre\"]:\n",
        "  row_list = row.split(',') #Creating the sublist and segrating by each comma\n",
        "  count.update(Counter(combinations(row_list,1)))\n",
        "count.most_common(5)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "g0XewZS7NeCz",
        "outputId": "36b10310-933b-4ff2-b8b7-10717d6ae51a"
      },
      "execution_count": 10,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "[(('Romance',), 190),\n",
              " (('Drama',), 177),\n",
              " (('Comedy',), 157),\n",
              " (('Family',), 68),\n",
              " (('Fantasy',), 23)]"
            ]
          },
          "metadata": {},
          "execution_count": 10
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#10 most uncommon genres appeared in the christmas movies from 2017-2022\n",
        "from itertools import combinations\n",
        "from collections import Counter\n",
        "\n",
        "count = Counter()\n",
        "for row in df[\"genre\"]:\n",
        "  row_list = row.split(',') #Creating the sublist and segrating by each comma\n",
        "  count.update(Counter(combinations(row_list,1)))\n",
        "count.most_common()[:-5-1:-1]  "
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "twB3E6JKOXNg",
        "outputId": "c30b1092-7c99-4e1d-aab6-a715ad5c88f1"
      },
      "execution_count": 11,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "[(('Talk-Show',), 1),\n",
              " (('Sci-Fi',), 1),\n",
              " (('War',), 1),\n",
              " (('History',), 1),\n",
              " (('Western',), 1)]"
            ]
          },
          "metadata": {},
          "execution_count": 11
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "## Finding out the longest and shortest Christmas Movies released from 2017-22."
      ],
      "metadata": {
        "id": "bnL_0Htp9yF_"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "#converting the first 3 elements of time as a single integer and the sorting and printing the longest movies\n",
        "df[\"time(in mins)\"] = df[\"time\"].str[0:3].astype(int)\n",
        "df.sort_values(\"time(in mins)\", ascending=False)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "7Z_JMsVD_XJ3",
        "outputId": "1b39351e-1fbc-4c9e-eb3b-7778414b11d5"
      },
      "execution_count": 28,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                            movie_title       release_year certificate  \\\n",
              "1                          Little Women              -2019          PG   \n",
              "0                               Shazam!              -2019       PG-13   \n",
              "265                   This Is Christmas              -2017         NaN   \n",
              "100  Jingle Jangle: A Christmas Journey              -2020          PG   \n",
              "160                Small Town Christmas    (2018 TV Movie)        TV-G   \n",
              "..                                  ...                ...         ...   \n",
              "277                            re: View           (2016 )         NaN   \n",
              "32                   Home for Christmas        (20192020)       TV-MA   \n",
              "269             A Trash Truck Christmas  (2020 TV Special)         NaN   \n",
              "272                Christmas Coming Out              -2021   Not Rated   \n",
              "267                Delivering Christmas    (2017 TV Short)       TV-PG   \n",
              "\n",
              "        time                        genre  stars  \\\n",
              "1    135 min               Drama, Romance    7.8   \n",
              "0    132 min    Action, Adventure, Comedy    7.0   \n",
              "265  128 min                        Drama    3.2   \n",
              "100  122 min     Family, Fantasy, Musical    6.4   \n",
              "160  120 min       Comedy, Drama, Romance    6.7   \n",
              "..       ...                          ...    ...   \n",
              "277   37 min            Comedy, Talk-Show    7.1   \n",
              "32    29 min       Comedy, Drama, Romance    7.7   \n",
              "269   28 min  Animation, Short, Adventure    5.6   \n",
              "272   17 min         Short, Comedy, Drama    6.5   \n",
              "267   11 min                 Short, Drama    7.0   \n",
              "\n",
              "                                           description      director_name  \\\n",
              "1    Jo March reflects back and forth on her life, ...       Greta Gerwig   \n",
              "0    A newly fostered young boy in search of his mo...  David F. Sandberg   \n",
              "265  Christmas is approaching, and best friends Har...     Joseph Rassulo   \n",
              "100  An imaginary world comes to life in a holiday ...   David E. Talbert   \n",
              "160  A high-flying female novelist from New York ta...     Maclain Nelson   \n",
              "..                                                 ...                ...   \n",
              "277  Jay Bauman and Josh Davis take a look at Jay's...         Jay Bauman   \n",
              "32   When the constant comments on her single statu...     Dennis Storhøi   \n",
              "269  When Santa crash-lands in the junkyard on Chri...        Eddie Rosas   \n",
              "272  An action figure from a young gay man's Christ...     Art Arutyunyan   \n",
              "267  After a little girl tells her mailman her wido...     David DeCoteau   \n",
              "\n",
              "                  cast1               cast2                    cast3  \\\n",
              "1         Saoirse Ronan         Emma Watson            Florence Pugh   \n",
              "0          Zachary Levi         Mark Strong              Asher Angel   \n",
              "265  A. Russell Andrews    Lynsey Bartilson         Scarlett Chorvat   \n",
              "100     Forest Whitaker  Keegan-Michael Key          Hugh Bonneville   \n",
              "160    Ashley Newbrough   Kristoffer Polaha      Preston Vanderslice   \n",
              "..                  ...                 ...                      ...   \n",
              "277          Josh Davis          Jay Bauman  Fabrice-Ange Zaphiratos   \n",
              "32      Ida Elise Broch       Oddgeir Thune             Hege Schøyen   \n",
              "269         Henry Keane          Glen Keane               Lucas Neff   \n",
              "272         Ford Nelson          Tyler Horn         Arthur Marroquin   \n",
              "267   Jason-Shane Scott      Jessica Morris                  CC King   \n",
              "\n",
              "                 cast4     votes  \\\n",
              "1        Eliza Scanlen  2,03,580   \n",
              "0    Jack Dylan Grazer  3,35,718   \n",
              "265         Jsu Garcia        22   \n",
              "100    Anika Noni Rose    18,583   \n",
              "160      Bailey Skodje     1,593   \n",
              "..                 ...       ...   \n",
              "277                NaN        18   \n",
              "32                 NaN    14,096   \n",
              "269  Brian Baumgartner       220   \n",
              "272     Katryn Schmidt        17   \n",
              "267     Elaine Partnow       119   \n",
              "\n",
              "                                            all_actors  time(in mins)  \n",
              "1    Saoirse Ronan , Emma Watson , Florence Pugh , ...            135  \n",
              "0    Zachary Levi , Mark Strong , Asher Angel , Jac...            132  \n",
              "265  A. Russell Andrews , Lynsey Bartilson , Scarle...            128  \n",
              "100  Forest Whitaker , Keegan-Michael Key , Hugh Bo...            122  \n",
              "160  Ashley Newbrough , Kristoffer Polaha , Preston...            120  \n",
              "..                                                 ...            ...  \n",
              "277  Josh Davis , Jay Bauman , Fabrice-Ange Zaphira...             37  \n",
              "32   Ida Elise Broch , Oddgeir Thune , Hege Schøyen...             29  \n",
              "269  Henry Keane , Glen Keane , Lucas Neff , Brian ...             28  \n",
              "272  Ford Nelson , Tyler Horn , Arthur Marroquin , ...             17  \n",
              "267  Jason-Shane Scott , Jessica Morris , CC King ,...             11  \n",
              "\n",
              "[278 rows x 15 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-99bf423d-ac17-49e5-9cde-69d4bfe18947\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>release_year</th>\n",
              "      <th>certificate</th>\n",
              "      <th>time</th>\n",
              "      <th>genre</th>\n",
              "      <th>stars</th>\n",
              "      <th>description</th>\n",
              "      <th>director_name</th>\n",
              "      <th>cast1</th>\n",
              "      <th>cast2</th>\n",
              "      <th>cast3</th>\n",
              "      <th>cast4</th>\n",
              "      <th>votes</th>\n",
              "      <th>all_actors</th>\n",
              "      <th>time(in mins)</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Little Women</td>\n",
              "      <td>-2019</td>\n",
              "      <td>PG</td>\n",
              "      <td>135 min</td>\n",
              "      <td>Drama, Romance</td>\n",
              "      <td>7.8</td>\n",
              "      <td>Jo March reflects back and forth on her life, ...</td>\n",
              "      <td>Greta Gerwig</td>\n",
              "      <td>Saoirse Ronan</td>\n",
              "      <td>Emma Watson</td>\n",
              "      <td>Florence Pugh</td>\n",
              "      <td>Eliza Scanlen</td>\n",
              "      <td>2,03,580</td>\n",
              "      <td>Saoirse Ronan , Emma Watson , Florence Pugh , ...</td>\n",
              "      <td>135</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Shazam!</td>\n",
              "      <td>-2019</td>\n",
              "      <td>PG-13</td>\n",
              "      <td>132 min</td>\n",
              "      <td>Action, Adventure, Comedy</td>\n",
              "      <td>7.0</td>\n",
              "      <td>A newly fostered young boy in search of his mo...</td>\n",
              "      <td>David F. Sandberg</td>\n",
              "      <td>Zachary Levi</td>\n",
              "      <td>Mark Strong</td>\n",
              "      <td>Asher Angel</td>\n",
              "      <td>Jack Dylan Grazer</td>\n",
              "      <td>3,35,718</td>\n",
              "      <td>Zachary Levi , Mark Strong , Asher Angel , Jac...</td>\n",
              "      <td>132</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>265</th>\n",
              "      <td>This Is Christmas</td>\n",
              "      <td>-2017</td>\n",
              "      <td>NaN</td>\n",
              "      <td>128 min</td>\n",
              "      <td>Drama</td>\n",
              "      <td>3.2</td>\n",
              "      <td>Christmas is approaching, and best friends Har...</td>\n",
              "      <td>Joseph Rassulo</td>\n",
              "      <td>A. Russell Andrews</td>\n",
              "      <td>Lynsey Bartilson</td>\n",
              "      <td>Scarlett Chorvat</td>\n",
              "      <td>Jsu Garcia</td>\n",
              "      <td>22</td>\n",
              "      <td>A. Russell Andrews , Lynsey Bartilson , Scarle...</td>\n",
              "      <td>128</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>100</th>\n",
              "      <td>Jingle Jangle: A Christmas Journey</td>\n",
              "      <td>-2020</td>\n",
              "      <td>PG</td>\n",
              "      <td>122 min</td>\n",
              "      <td>Family, Fantasy, Musical</td>\n",
              "      <td>6.4</td>\n",
              "      <td>An imaginary world comes to life in a holiday ...</td>\n",
              "      <td>David E. Talbert</td>\n",
              "      <td>Forest Whitaker</td>\n",
              "      <td>Keegan-Michael Key</td>\n",
              "      <td>Hugh Bonneville</td>\n",
              "      <td>Anika Noni Rose</td>\n",
              "      <td>18,583</td>\n",
              "      <td>Forest Whitaker , Keegan-Michael Key , Hugh Bo...</td>\n",
              "      <td>122</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>160</th>\n",
              "      <td>Small Town Christmas</td>\n",
              "      <td>(2018 TV Movie)</td>\n",
              "      <td>TV-G</td>\n",
              "      <td>120 min</td>\n",
              "      <td>Comedy, Drama, Romance</td>\n",
              "      <td>6.7</td>\n",
              "      <td>A high-flying female novelist from New York ta...</td>\n",
              "      <td>Maclain Nelson</td>\n",
              "      <td>Ashley Newbrough</td>\n",
              "      <td>Kristoffer Polaha</td>\n",
              "      <td>Preston Vanderslice</td>\n",
              "      <td>Bailey Skodje</td>\n",
              "      <td>1,593</td>\n",
              "      <td>Ashley Newbrough , Kristoffer Polaha , Preston...</td>\n",
              "      <td>120</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>277</th>\n",
              "      <td>re: View</td>\n",
              "      <td>(2016 )</td>\n",
              "      <td>NaN</td>\n",
              "      <td>37 min</td>\n",
              "      <td>Comedy, Talk-Show</td>\n",
              "      <td>7.1</td>\n",
              "      <td>Jay Bauman and Josh Davis take a look at Jay's...</td>\n",
              "      <td>Jay Bauman</td>\n",
              "      <td>Josh Davis</td>\n",
              "      <td>Jay Bauman</td>\n",
              "      <td>Fabrice-Ange Zaphiratos</td>\n",
              "      <td>NaN</td>\n",
              "      <td>18</td>\n",
              "      <td>Josh Davis , Jay Bauman , Fabrice-Ange Zaphira...</td>\n",
              "      <td>37</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>Home for Christmas</td>\n",
              "      <td>(20192020)</td>\n",
              "      <td>TV-MA</td>\n",
              "      <td>29 min</td>\n",
              "      <td>Comedy, Drama, Romance</td>\n",
              "      <td>7.7</td>\n",
              "      <td>When the constant comments on her single statu...</td>\n",
              "      <td>Dennis Storhøi</td>\n",
              "      <td>Ida Elise Broch</td>\n",
              "      <td>Oddgeir Thune</td>\n",
              "      <td>Hege Schøyen</td>\n",
              "      <td>NaN</td>\n",
              "      <td>14,096</td>\n",
              "      <td>Ida Elise Broch , Oddgeir Thune , Hege Schøyen...</td>\n",
              "      <td>29</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>269</th>\n",
              "      <td>A Trash Truck Christmas</td>\n",
              "      <td>(2020 TV Special)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>28 min</td>\n",
              "      <td>Animation, Short, Adventure</td>\n",
              "      <td>5.6</td>\n",
              "      <td>When Santa crash-lands in the junkyard on Chri...</td>\n",
              "      <td>Eddie Rosas</td>\n",
              "      <td>Henry Keane</td>\n",
              "      <td>Glen Keane</td>\n",
              "      <td>Lucas Neff</td>\n",
              "      <td>Brian Baumgartner</td>\n",
              "      <td>220</td>\n",
              "      <td>Henry Keane , Glen Keane , Lucas Neff , Brian ...</td>\n",
              "      <td>28</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>272</th>\n",
              "      <td>Christmas Coming Out</td>\n",
              "      <td>-2021</td>\n",
              "      <td>Not Rated</td>\n",
              "      <td>17 min</td>\n",
              "      <td>Short, Comedy, Drama</td>\n",
              "      <td>6.5</td>\n",
              "      <td>An action figure from a young gay man's Christ...</td>\n",
              "      <td>Art Arutyunyan</td>\n",
              "      <td>Ford Nelson</td>\n",
              "      <td>Tyler Horn</td>\n",
              "      <td>Arthur Marroquin</td>\n",
              "      <td>Katryn Schmidt</td>\n",
              "      <td>17</td>\n",
              "      <td>Ford Nelson , Tyler Horn , Arthur Marroquin , ...</td>\n",
              "      <td>17</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>267</th>\n",
              "      <td>Delivering Christmas</td>\n",
              "      <td>(2017 TV Short)</td>\n",
              "      <td>TV-PG</td>\n",
              "      <td>11 min</td>\n",
              "      <td>Short, Drama</td>\n",
              "      <td>7.0</td>\n",
              "      <td>After a little girl tells her mailman her wido...</td>\n",
              "      <td>David DeCoteau</td>\n",
              "      <td>Jason-Shane Scott</td>\n",
              "      <td>Jessica Morris</td>\n",
              "      <td>CC King</td>\n",
              "      <td>Elaine Partnow</td>\n",
              "      <td>119</td>\n",
              "      <td>Jason-Shane Scott , Jessica Morris , CC King ,...</td>\n",
              "      <td>11</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>278 rows × 15 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-99bf423d-ac17-49e5-9cde-69d4bfe18947')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-99bf423d-ac17-49e5-9cde-69d4bfe18947 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-99bf423d-ac17-49e5-9cde-69d4bfe18947');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 28
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#5 shortest movies\n",
        "df.sort_values(\"time(in mins)\", ascending=True)\n",
        "df.tail()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 721
        },
        "id": "6wAal4J1C3BX",
        "outputId": "ad917cf9-b649-4354-f66d-b4a82dd64bc9"
      },
      "execution_count": 27,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                     movie_title     release_year certificate     time  \\\n",
              "273    An Unremarkable Christmas  (2020 TV Movie)       TV-14   82 min   \n",
              "274        Christmas with Cookie            -2016         NaN   53 min   \n",
              "275  Community Theater Christmas            -2019       TV-14  103 min   \n",
              "276             Discarding Santa            -2018         NaN   85 min   \n",
              "277                     re: View         (2016 )         NaN   37 min   \n",
              "\n",
              "                         genre  stars  \\\n",
              "273              Comedy, Drama    3.2   \n",
              "274     Comedy, Horror, Sci-Fi    4.7   \n",
              "275                     Comedy    7.5   \n",
              "276  Adventure, Comedy, Family    4.8   \n",
              "277          Comedy, Talk-Show    7.1   \n",
              "\n",
              "                                           description       director_name  \\\n",
              "273  Before the events of S1, Juanquini, El Ñato an...  Juan Camilo Pinzon   \n",
              "274  In the year 3978 global warming has made a des...         Alan Maxson   \n",
              "275  A community theater competes for a state grant...     Melissa Vitello   \n",
              "276  \"In 2010, the city of Leitchfield, Kentucky de...            Bob Maze   \n",
              "277  Jay Bauman and Josh Davis take a look at Jay's...          Jay Bauman   \n",
              "\n",
              "                   cast1           cast2                    cast3  \\\n",
              "273  Luis Eduardo Arango   Julián Cerati   Aura Cristina Geithner   \n",
              "274       Shawn Schminke     Alan Maxson              Dana Austen   \n",
              "275      IsaBeall Quella  Veronica Wylie          Marissa Pistone   \n",
              "276     Spencer Kingsley    Lewis Wright             Lare Roberts   \n",
              "277           Josh Davis      Jay Bauman  Fabrice-Ange Zaphiratos   \n",
              "\n",
              "                 cast4 votes  \\\n",
              "273      Mariana Gómez   144   \n",
              "274       Justin Armao    70   \n",
              "275           Dan Pena    52   \n",
              "276  Kathlene Ashcraft    41   \n",
              "277                NaN    18   \n",
              "\n",
              "                                            all_actors  time(in mins)  \n",
              "273  Luis Eduardo Arango , Julián Cerati , Aura Cri...             82  \n",
              "274  Shawn Schminke , Alan Maxson , Dana Austen , J...             53  \n",
              "275  IsaBeall Quella , Veronica Wylie , Marissa Pis...            103  \n",
              "276  Spencer Kingsley , Lewis Wright , Lare Roberts...             85  \n",
              "277  Josh Davis , Jay Bauman , Fabrice-Ange Zaphira...             37  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-0fda14f5-4520-4f00-ab7b-1307662392a4\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>release_year</th>\n",
              "      <th>certificate</th>\n",
              "      <th>time</th>\n",
              "      <th>genre</th>\n",
              "      <th>stars</th>\n",
              "      <th>description</th>\n",
              "      <th>director_name</th>\n",
              "      <th>cast1</th>\n",
              "      <th>cast2</th>\n",
              "      <th>cast3</th>\n",
              "      <th>cast4</th>\n",
              "      <th>votes</th>\n",
              "      <th>all_actors</th>\n",
              "      <th>time(in mins)</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>273</th>\n",
              "      <td>An Unremarkable Christmas</td>\n",
              "      <td>(2020 TV Movie)</td>\n",
              "      <td>TV-14</td>\n",
              "      <td>82 min</td>\n",
              "      <td>Comedy, Drama</td>\n",
              "      <td>3.2</td>\n",
              "      <td>Before the events of S1, Juanquini, El Ñato an...</td>\n",
              "      <td>Juan Camilo Pinzon</td>\n",
              "      <td>Luis Eduardo Arango</td>\n",
              "      <td>Julián Cerati</td>\n",
              "      <td>Aura Cristina Geithner</td>\n",
              "      <td>Mariana Gómez</td>\n",
              "      <td>144</td>\n",
              "      <td>Luis Eduardo Arango , Julián Cerati , Aura Cri...</td>\n",
              "      <td>82</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>274</th>\n",
              "      <td>Christmas with Cookie</td>\n",
              "      <td>-2016</td>\n",
              "      <td>NaN</td>\n",
              "      <td>53 min</td>\n",
              "      <td>Comedy, Horror, Sci-Fi</td>\n",
              "      <td>4.7</td>\n",
              "      <td>In the year 3978 global warming has made a des...</td>\n",
              "      <td>Alan Maxson</td>\n",
              "      <td>Shawn Schminke</td>\n",
              "      <td>Alan Maxson</td>\n",
              "      <td>Dana Austen</td>\n",
              "      <td>Justin Armao</td>\n",
              "      <td>70</td>\n",
              "      <td>Shawn Schminke , Alan Maxson , Dana Austen , J...</td>\n",
              "      <td>53</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>275</th>\n",
              "      <td>Community Theater Christmas</td>\n",
              "      <td>-2019</td>\n",
              "      <td>TV-14</td>\n",
              "      <td>103 min</td>\n",
              "      <td>Comedy</td>\n",
              "      <td>7.5</td>\n",
              "      <td>A community theater competes for a state grant...</td>\n",
              "      <td>Melissa Vitello</td>\n",
              "      <td>IsaBeall Quella</td>\n",
              "      <td>Veronica Wylie</td>\n",
              "      <td>Marissa Pistone</td>\n",
              "      <td>Dan Pena</td>\n",
              "      <td>52</td>\n",
              "      <td>IsaBeall Quella , Veronica Wylie , Marissa Pis...</td>\n",
              "      <td>103</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>276</th>\n",
              "      <td>Discarding Santa</td>\n",
              "      <td>-2018</td>\n",
              "      <td>NaN</td>\n",
              "      <td>85 min</td>\n",
              "      <td>Adventure, Comedy, Family</td>\n",
              "      <td>4.8</td>\n",
              "      <td>\"In 2010, the city of Leitchfield, Kentucky de...</td>\n",
              "      <td>Bob Maze</td>\n",
              "      <td>Spencer Kingsley</td>\n",
              "      <td>Lewis Wright</td>\n",
              "      <td>Lare Roberts</td>\n",
              "      <td>Kathlene Ashcraft</td>\n",
              "      <td>41</td>\n",
              "      <td>Spencer Kingsley , Lewis Wright , Lare Roberts...</td>\n",
              "      <td>85</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>277</th>\n",
              "      <td>re: View</td>\n",
              "      <td>(2016 )</td>\n",
              "      <td>NaN</td>\n",
              "      <td>37 min</td>\n",
              "      <td>Comedy, Talk-Show</td>\n",
              "      <td>7.1</td>\n",
              "      <td>Jay Bauman and Josh Davis take a look at Jay's...</td>\n",
              "      <td>Jay Bauman</td>\n",
              "      <td>Josh Davis</td>\n",
              "      <td>Jay Bauman</td>\n",
              "      <td>Fabrice-Ange Zaphiratos</td>\n",
              "      <td>NaN</td>\n",
              "      <td>18</td>\n",
              "      <td>Josh Davis , Jay Bauman , Fabrice-Ange Zaphira...</td>\n",
              "      <td>37</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-0fda14f5-4520-4f00-ab7b-1307662392a4')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-0fda14f5-4520-4f00-ab7b-1307662392a4 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-0fda14f5-4520-4f00-ab7b-1307662392a4');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 27
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "## Finding all the Christmas Movies that start with C, have a rating 6.0 + and are of Drama genre."
      ],
      "metadata": {
        "id": "YnXVdqypEE6E"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "#Filtering the movies starting with C\n",
        "import re\n",
        "newdf = (df.loc[df[\"movie_title\"].str.contains('^c[a-z]*', flags=re.I, regex=True)])\n",
        "newdf"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "IhHPyxBMDIGx",
        "outputId": "f913c4b4-2dee-4e72-aa37-2cd43732862a"
      },
      "execution_count": 80,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                      movie_title     release_year certificate     time  \\\n",
              "8        Christmas at Castle Hart  (2021 TV Movie)        TV-G   84 min   \n",
              "15           Christmas on My Mind  (2019 TV Movie)         NaN   84 min   \n",
              "28         Christmas by Starlight  (2020 TV Movie)        TV-G   84 min   \n",
              "29              Chateau Christmas  (2020 TV Movie)        TV-G   84 min   \n",
              "33    Christmas with the Darlings  (2020 TV Movie)        TV-G   84 min   \n",
              "..                            ...              ...         ...      ...   \n",
              "261              Christmas Belles  (2019 TV Movie)       TV-14   85 min   \n",
              "270  Christmas at the Royal Hotel            -2018         NaN  108 min   \n",
              "272          Christmas Coming Out            -2021   Not Rated   17 min   \n",
              "274         Christmas with Cookie            -2016         NaN   53 min   \n",
              "275   Community Theater Christmas            -2019       TV-14  103 min   \n",
              "\n",
              "                       genre  stars  \\\n",
              "8                    Romance    6.3   \n",
              "15    Comedy, Drama, Romance    6.5   \n",
              "28    Comedy, Drama, Romance    7.2   \n",
              "29      Comedy, Drama, Music    6.4   \n",
              "33   Comedy, Family, Romance    7.1   \n",
              "..                       ...    ...   \n",
              "261                   Comedy    6.3   \n",
              "270      Drama, History, War    4.3   \n",
              "272     Short, Comedy, Drama    6.5   \n",
              "274   Comedy, Horror, Sci-Fi    4.7   \n",
              "275                   Comedy    7.5   \n",
              "\n",
              "                                           description    director_name  \\\n",
              "8    Brooke Bennett goes to Ireland for Christmas t...    Stefan Scaini   \n",
              "15   When Lucy wakes up with a wedding dress in han...   Maclain Nelson   \n",
              "28   When her family's beloved café is slated for d...       Gary Yates   \n",
              "29   World-famous pianist Margot returns to Chateau...  Michael Robison   \n",
              "33   A woman helps a charming man look after his or...  Catherine Cyran   \n",
              "..                                                 ...              ...   \n",
              "261  Despite being successful in their careers, two...  Terri J. Vaughn   \n",
              "270  In 1941, Hong Kong was the Casablanca of the E...   Craig McCourry   \n",
              "272  An action figure from a young gay man's Christ...   Art Arutyunyan   \n",
              "274  In the year 3978 global warming has made a des...      Alan Maxson   \n",
              "275  A community theater competes for a state grant...  Melissa Vitello   \n",
              "\n",
              "                 cast1             cast2             cast3            cast4  \\\n",
              "8        Lacey Chabert   Stuart Townsend      Ali Hardiman     Kate O'Toole   \n",
              "15       Ashley Greene  Andrew W. Walker      Jackée Harry  Donna Benedicto   \n",
              "28    Kimberley Sustad     Paul Campbell    Darren Martens     Bruce Dawson   \n",
              "29   Merritt Patterson   Luke Macfarlane       Jesse Hutch     Julia Benson   \n",
              "33         Katrina Law       Carlo Marks       Steve Bacic   Islie Hirvonen   \n",
              "..                 ...               ...               ...              ...   \n",
              "261      Raven Goodwin    DomiNque Perry      Omar Gooding      Mark Taylor   \n",
              "270         Harry Oram    Lydia Lee Tang      Ashley Leung       Wil Cheung   \n",
              "272        Ford Nelson        Tyler Horn  Arthur Marroquin   Katryn Schmidt   \n",
              "274     Shawn Schminke       Alan Maxson       Dana Austen     Justin Armao   \n",
              "275    IsaBeall Quella    Veronica Wylie   Marissa Pistone         Dan Pena   \n",
              "\n",
              "     votes                                         all_actors  \n",
              "8    1,328  Lacey Chabert , Stuart Townsend , Ali Hardiman...  \n",
              "15   1,328  Ashley Greene , Andrew W. Walker , Jackée Harr...  \n",
              "28   1,716  Kimberley Sustad , Paul Campbell , Darren Mart...  \n",
              "29   1,479  Merritt Patterson , Luke Macfarlane , Jesse Hu...  \n",
              "33   1,390  Katrina Law , Carlo Marks , Steve Bacic , Isli...  \n",
              "..     ...                                                ...  \n",
              "261    132  Raven Goodwin , DomiNque Perry , Omar Gooding ...  \n",
              "270     45  Harry Oram , Lydia Lee Tang , Ashley Leung , W...  \n",
              "272     17  Ford Nelson , Tyler Horn , Arthur Marroquin , ...  \n",
              "274     70  Shawn Schminke , Alan Maxson , Dana Austen , J...  \n",
              "275     52  IsaBeall Quella , Veronica Wylie , Marissa Pis...  \n",
              "\n",
              "[80 rows x 14 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-bf99396d-7d4e-4a17-a1f7-1a9150edae26\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>release_year</th>\n",
              "      <th>certificate</th>\n",
              "      <th>time</th>\n",
              "      <th>genre</th>\n",
              "      <th>stars</th>\n",
              "      <th>description</th>\n",
              "      <th>director_name</th>\n",
              "      <th>cast1</th>\n",
              "      <th>cast2</th>\n",
              "      <th>cast3</th>\n",
              "      <th>cast4</th>\n",
              "      <th>votes</th>\n",
              "      <th>all_actors</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>Christmas at Castle Hart</td>\n",
              "      <td>(2021 TV Movie)</td>\n",
              "      <td>TV-G</td>\n",
              "      <td>84 min</td>\n",
              "      <td>Romance</td>\n",
              "      <td>6.3</td>\n",
              "      <td>Brooke Bennett goes to Ireland for Christmas t...</td>\n",
              "      <td>Stefan Scaini</td>\n",
              "      <td>Lacey Chabert</td>\n",
              "      <td>Stuart Townsend</td>\n",
              "      <td>Ali Hardiman</td>\n",
              "      <td>Kate O'Toole</td>\n",
              "      <td>1,328</td>\n",
              "      <td>Lacey Chabert , Stuart Townsend , Ali Hardiman...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>Christmas on My Mind</td>\n",
              "      <td>(2019 TV Movie)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>84 min</td>\n",
              "      <td>Comedy, Drama, Romance</td>\n",
              "      <td>6.5</td>\n",
              "      <td>When Lucy wakes up with a wedding dress in han...</td>\n",
              "      <td>Maclain Nelson</td>\n",
              "      <td>Ashley Greene</td>\n",
              "      <td>Andrew W. Walker</td>\n",
              "      <td>Jackée Harry</td>\n",
              "      <td>Donna Benedicto</td>\n",
              "      <td>1,328</td>\n",
              "      <td>Ashley Greene , Andrew W. Walker , Jackée Harr...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>Christmas by Starlight</td>\n",
              "      <td>(2020 TV Movie)</td>\n",
              "      <td>TV-G</td>\n",
              "      <td>84 min</td>\n",
              "      <td>Comedy, Drama, Romance</td>\n",
              "      <td>7.2</td>\n",
              "      <td>When her family's beloved café is slated for d...</td>\n",
              "      <td>Gary Yates</td>\n",
              "      <td>Kimberley Sustad</td>\n",
              "      <td>Paul Campbell</td>\n",
              "      <td>Darren Martens</td>\n",
              "      <td>Bruce Dawson</td>\n",
              "      <td>1,716</td>\n",
              "      <td>Kimberley Sustad , Paul Campbell , Darren Mart...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>Chateau Christmas</td>\n",
              "      <td>(2020 TV Movie)</td>\n",
              "      <td>TV-G</td>\n",
              "      <td>84 min</td>\n",
              "      <td>Comedy, Drama, Music</td>\n",
              "      <td>6.4</td>\n",
              "      <td>World-famous pianist Margot returns to Chateau...</td>\n",
              "      <td>Michael Robison</td>\n",
              "      <td>Merritt Patterson</td>\n",
              "      <td>Luke Macfarlane</td>\n",
              "      <td>Jesse Hutch</td>\n",
              "      <td>Julia Benson</td>\n",
              "      <td>1,479</td>\n",
              "      <td>Merritt Patterson , Luke Macfarlane , Jesse Hu...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\n",
              "      <td>Christmas with the Darlings</td>\n",
              "      <td>(2020 TV Movie)</td>\n",
              "      <td>TV-G</td>\n",
              "      <td>84 min</td>\n",
              "      <td>Comedy, Family, Romance</td>\n",
              "      <td>7.1</td>\n",
              "      <td>A woman helps a charming man look after his or...</td>\n",
              "      <td>Catherine Cyran</td>\n",
              "      <td>Katrina Law</td>\n",
              "      <td>Carlo Marks</td>\n",
              "      <td>Steve Bacic</td>\n",
              "      <td>Islie Hirvonen</td>\n",
              "      <td>1,390</td>\n",
              "      <td>Katrina Law , Carlo Marks , Steve Bacic , Isli...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>261</th>\n",
              "      <td>Christmas Belles</td>\n",
              "      <td>(2019 TV Movie)</td>\n",
              "      <td>TV-14</td>\n",
              "      <td>85 min</td>\n",
              "      <td>Comedy</td>\n",
              "      <td>6.3</td>\n",
              "      <td>Despite being successful in their careers, two...</td>\n",
              "      <td>Terri J. Vaughn</td>\n",
              "      <td>Raven Goodwin</td>\n",
              "      <td>DomiNque Perry</td>\n",
              "      <td>Omar Gooding</td>\n",
              "      <td>Mark Taylor</td>\n",
              "      <td>132</td>\n",
              "      <td>Raven Goodwin , DomiNque Perry , Omar Gooding ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>270</th>\n",
              "      <td>Christmas at the Royal Hotel</td>\n",
              "      <td>-2018</td>\n",
              "      <td>NaN</td>\n",
              "      <td>108 min</td>\n",
              "      <td>Drama, History, War</td>\n",
              "      <td>4.3</td>\n",
              "      <td>In 1941, Hong Kong was the Casablanca of the E...</td>\n",
              "      <td>Craig McCourry</td>\n",
              "      <td>Harry Oram</td>\n",
              "      <td>Lydia Lee Tang</td>\n",
              "      <td>Ashley Leung</td>\n",
              "      <td>Wil Cheung</td>\n",
              "      <td>45</td>\n",
              "      <td>Harry Oram , Lydia Lee Tang , Ashley Leung , W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>272</th>\n",
              "      <td>Christmas Coming Out</td>\n",
              "      <td>-2021</td>\n",
              "      <td>Not Rated</td>\n",
              "      <td>17 min</td>\n",
              "      <td>Short, Comedy, Drama</td>\n",
              "      <td>6.5</td>\n",
              "      <td>An action figure from a young gay man's Christ...</td>\n",
              "      <td>Art Arutyunyan</td>\n",
              "      <td>Ford Nelson</td>\n",
              "      <td>Tyler Horn</td>\n",
              "      <td>Arthur Marroquin</td>\n",
              "      <td>Katryn Schmidt</td>\n",
              "      <td>17</td>\n",
              "      <td>Ford Nelson , Tyler Horn , Arthur Marroquin , ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>274</th>\n",
              "      <td>Christmas with Cookie</td>\n",
              "      <td>-2016</td>\n",
              "      <td>NaN</td>\n",
              "      <td>53 min</td>\n",
              "      <td>Comedy, Horror, Sci-Fi</td>\n",
              "      <td>4.7</td>\n",
              "      <td>In the year 3978 global warming has made a des...</td>\n",
              "      <td>Alan Maxson</td>\n",
              "      <td>Shawn Schminke</td>\n",
              "      <td>Alan Maxson</td>\n",
              "      <td>Dana Austen</td>\n",
              "      <td>Justin Armao</td>\n",
              "      <td>70</td>\n",
              "      <td>Shawn Schminke , Alan Maxson , Dana Austen , J...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>275</th>\n",
              "      <td>Community Theater Christmas</td>\n",
              "      <td>-2019</td>\n",
              "      <td>TV-14</td>\n",
              "      <td>103 min</td>\n",
              "      <td>Comedy</td>\n",
              "      <td>7.5</td>\n",
              "      <td>A community theater competes for a state grant...</td>\n",
              "      <td>Melissa Vitello</td>\n",
              "      <td>IsaBeall Quella</td>\n",
              "      <td>Veronica Wylie</td>\n",
              "      <td>Marissa Pistone</td>\n",
              "      <td>Dan Pena</td>\n",
              "      <td>52</td>\n",
              "      <td>IsaBeall Quella , Veronica Wylie , Marissa Pis...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>80 rows × 14 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-bf99396d-7d4e-4a17-a1f7-1a9150edae26')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-bf99396d-7d4e-4a17-a1f7-1a9150edae26 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-bf99396d-7d4e-4a17-a1f7-1a9150edae26');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 80
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#With the filtered set of movies that start with C, further filtering the ones that have a rating of 8.0 +\n",
        "newdf[\"stars\"].astype(float)\n",
        "newdf = newdf[newdf[\"stars\"] > 7.0]\n",
        "newdf"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 450
        },
        "id": "8Jrvtr9AHtOz",
        "outputId": "9628d20f-8160-4b42-a5b6-78ad1e8d13e1"
      },
      "execution_count": 56,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                     movie_title     release_year certificate     time  \\\n",
              "28        Christmas by Starlight  (2020 TV Movie)        TV-G   84 min   \n",
              "33   Christmas with the Darlings  (2020 TV Movie)        TV-G   84 min   \n",
              "275  Community Theater Christmas            -2019       TV-14  103 min   \n",
              "\n",
              "                       genre  stars  \\\n",
              "28    Comedy, Drama, Romance    7.2   \n",
              "33   Comedy, Family, Romance    7.1   \n",
              "275                   Comedy    7.5   \n",
              "\n",
              "                                           description    director_name  \\\n",
              "28   When her family's beloved café is slated for d...       Gary Yates   \n",
              "33   A woman helps a charming man look after his or...  Catherine Cyran   \n",
              "275  A community theater competes for a state grant...  Melissa Vitello   \n",
              "\n",
              "                cast1           cast2            cast3           cast4  votes  \\\n",
              "28   Kimberley Sustad   Paul Campbell   Darren Martens    Bruce Dawson  1,716   \n",
              "33        Katrina Law     Carlo Marks      Steve Bacic  Islie Hirvonen  1,390   \n",
              "275   IsaBeall Quella  Veronica Wylie  Marissa Pistone        Dan Pena     52   \n",
              "\n",
              "                                            all_actors  \n",
              "28   Kimberley Sustad , Paul Campbell , Darren Mart...  \n",
              "33   Katrina Law , Carlo Marks , Steve Bacic , Isli...  \n",
              "275  IsaBeall Quella , Veronica Wylie , Marissa Pis...  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-b407c247-25e0-4716-97d6-740cd28122b2\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>release_year</th>\n",
              "      <th>certificate</th>\n",
              "      <th>time</th>\n",
              "      <th>genre</th>\n",
              "      <th>stars</th>\n",
              "      <th>description</th>\n",
              "      <th>director_name</th>\n",
              "      <th>cast1</th>\n",
              "      <th>cast2</th>\n",
              "      <th>cast3</th>\n",
              "      <th>cast4</th>\n",
              "      <th>votes</th>\n",
              "      <th>all_actors</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>Christmas by Starlight</td>\n",
              "      <td>(2020 TV Movie)</td>\n",
              "      <td>TV-G</td>\n",
              "      <td>84 min</td>\n",
              "      <td>Comedy, Drama, Romance</td>\n",
              "      <td>7.2</td>\n",
              "      <td>When her family's beloved café is slated for d...</td>\n",
              "      <td>Gary Yates</td>\n",
              "      <td>Kimberley Sustad</td>\n",
              "      <td>Paul Campbell</td>\n",
              "      <td>Darren Martens</td>\n",
              "      <td>Bruce Dawson</td>\n",
              "      <td>1,716</td>\n",
              "      <td>Kimberley Sustad , Paul Campbell , Darren Mart...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\n",
              "      <td>Christmas with the Darlings</td>\n",
              "      <td>(2020 TV Movie)</td>\n",
              "      <td>TV-G</td>\n",
              "      <td>84 min</td>\n",
              "      <td>Comedy, Family, Romance</td>\n",
              "      <td>7.1</td>\n",
              "      <td>A woman helps a charming man look after his or...</td>\n",
              "      <td>Catherine Cyran</td>\n",
              "      <td>Katrina Law</td>\n",
              "      <td>Carlo Marks</td>\n",
              "      <td>Steve Bacic</td>\n",
              "      <td>Islie Hirvonen</td>\n",
              "      <td>1,390</td>\n",
              "      <td>Katrina Law , Carlo Marks , Steve Bacic , Isli...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>275</th>\n",
              "      <td>Community Theater Christmas</td>\n",
              "      <td>-2019</td>\n",
              "      <td>TV-14</td>\n",
              "      <td>103 min</td>\n",
              "      <td>Comedy</td>\n",
              "      <td>7.5</td>\n",
              "      <td>A community theater competes for a state grant...</td>\n",
              "      <td>Melissa Vitello</td>\n",
              "      <td>IsaBeall Quella</td>\n",
              "      <td>Veronica Wylie</td>\n",
              "      <td>Marissa Pistone</td>\n",
              "      <td>Dan Pena</td>\n",
              "      <td>52</td>\n",
              "      <td>IsaBeall Quella , Veronica Wylie , Marissa Pis...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-b407c247-25e0-4716-97d6-740cd28122b2')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-b407c247-25e0-4716-97d6-740cd28122b2 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-b407c247-25e0-4716-97d6-740cd28122b2');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 56
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#Now after two filtering finally filtering the movies that are of genre 'Drama'\n",
        "newdf.loc[newdf[\"genre\"].str.contains(\"Drama\")]"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 231
        },
        "id": "8COwd9B1JLWu",
        "outputId": "7d07d290-084e-4949-aaf7-20f6c30b7c7e"
      },
      "execution_count": 65,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "               movie_title     release_year certificate    time  \\\n",
              "28  Christmas by Starlight  (2020 TV Movie)        TV-G  84 min   \n",
              "\n",
              "                     genre  stars  \\\n",
              "28  Comedy, Drama, Romance    7.2   \n",
              "\n",
              "                                          description director_name  \\\n",
              "28  When her family's beloved café is slated for d...    Gary Yates   \n",
              "\n",
              "               cast1          cast2           cast3         cast4  votes  \\\n",
              "28  Kimberley Sustad  Paul Campbell  Darren Martens  Bruce Dawson  1,716   \n",
              "\n",
              "                                           all_actors  \n",
              "28  Kimberley Sustad , Paul Campbell , Darren Mart...  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-7a1b4e33-3084-4023-ba52-7cdc16ef5acb\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>release_year</th>\n",
              "      <th>certificate</th>\n",
              "      <th>time</th>\n",
              "      <th>genre</th>\n",
              "      <th>stars</th>\n",
              "      <th>description</th>\n",
              "      <th>director_name</th>\n",
              "      <th>cast1</th>\n",
              "      <th>cast2</th>\n",
              "      <th>cast3</th>\n",
              "      <th>cast4</th>\n",
              "      <th>votes</th>\n",
              "      <th>all_actors</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>Christmas by Starlight</td>\n",
              "      <td>(2020 TV Movie)</td>\n",
              "      <td>TV-G</td>\n",
              "      <td>84 min</td>\n",
              "      <td>Comedy, Drama, Romance</td>\n",
              "      <td>7.2</td>\n",
              "      <td>When her family's beloved café is slated for d...</td>\n",
              "      <td>Gary Yates</td>\n",
              "      <td>Kimberley Sustad</td>\n",
              "      <td>Paul Campbell</td>\n",
              "      <td>Darren Martens</td>\n",
              "      <td>Bruce Dawson</td>\n",
              "      <td>1,716</td>\n",
              "      <td>Kimberley Sustad , Paul Campbell , Darren Mart...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-7a1b4e33-3084-4023-ba52-7cdc16ef5acb')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-7a1b4e33-3084-4023-ba52-7cdc16ef5acb button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-7a1b4e33-3084-4023-ba52-7cdc16ef5acb');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 65
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "## Finding out the director who has worked most and least on Christmas Movies released from 2017-22."
      ],
      "metadata": {
        "id": "R8RdRkuEKgQL"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "#number of films done by each of the directors\n",
        "newdf = df.groupby(\"director_name\")[\"director_name\"].count()\n",
        "newdf.sort_values(ascending=False)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "sCRhjHWIKw0g",
        "outputId": "220c704b-cbd3-4aef-dcb3-c5fb08e0dc33"
      },
      "execution_count": 67,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "director_name\n",
              "Justin G. Dyck     12\n",
              "Jake Helgren        7\n",
              "David Winning       7\n",
              "Don McBrearty       6\n",
              "Marita Grabiak      5\n",
              "                   ..\n",
              "Gary Harvey         1\n",
              "Eshom Nelms         1\n",
              "Erik Bloomquist     1\n",
              "Erica Dunton        1\n",
              "Yarrow Cheney       1\n",
              "Name: director_name, Length: 168, dtype: int64"
            ]
          },
          "metadata": {},
          "execution_count": 67
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "##Finding out the per category/certificate count for the Christmas Movies released from 2017-2022."
      ],
      "metadata": {
        "id": "yKKw6qz3Wauq"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "newdf = df.groupby(\"certificate\")[\"certificate\"].count()\n",
        "newdf.sort_values(ascending=False)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "LChWHskpXH9_",
        "outputId": "467a2623-d507-4d30-cfc7-4a70ce11d704"
      },
      "execution_count": 82,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "certificate\n",
              "TV-G         124\n",
              "TV-PG         55\n",
              "PG            18\n",
              "TV-14          8\n",
              "PG-13          6\n",
              "Not Rated      5\n",
              "R              5\n",
              "Unrated        5\n",
              "G              4\n",
              "TV-MA          2\n",
              "TV-Y           1\n",
              "Name: certificate, dtype: int64"
            ]
          },
          "metadata": {},
          "execution_count": 82
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "## Finding out the exactly 7.1 rated Christmas Movies which were released from 2017-2022."
      ],
      "metadata": {
        "id": "cEPNILudLBbO"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df[\"stars\"] = df[\"stars\"].astype(str)\n",
        "df.loc[df[\"stars\"].str.contains(\"7.1\")]"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 822
        },
        "id": "Dk8XSszDY6y2",
        "outputId": "b8374e27-a303-4fc3-de20-f167314b0959"
      },
      "execution_count": 100,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                     movie_title     release_year certificate    time  \\\n",
              "14          Next Stop, Christmas  (2021 TV Movie)        TV-G  84 min   \n",
              "18          A Timeless Christmas  (2020 TV Movie)        TV-G  84 min   \n",
              "33   Christmas with the Darlings  (2020 TV Movie)        TV-G  84 min   \n",
              "59     A Bramble House Christmas  (2017 TV Movie)   Not Rated  84 min   \n",
              "77                   Holly & Ivy  (2020 TV Movie)        TV-G  85 min   \n",
              "277                     re: View         (2016 )         NaN  37 min   \n",
              "\n",
              "                        genre stars  \\\n",
              "14     Comedy, Drama, Fantasy   7.1   \n",
              "18   Comedy, Fantasy, Romance   7.1   \n",
              "33    Comedy, Family, Romance   7.1   \n",
              "59             Drama, Romance   7.1   \n",
              "77     Drama, Family, Romance   7.1   \n",
              "277         Comedy, Talk-Show   7.1   \n",
              "\n",
              "                                           description     director_name  \\\n",
              "14   Angie is determined to spend Christmas alone b...     Dustin Rikert   \n",
              "18   Charles Whitley travels from 1903 to 2020 wher...        Ron Oliver   \n",
              "33   A woman helps a charming man look after his or...   Catherine Cyran   \n",
              "59   Finn Conrad becomes suspicious as to why his f...  Steven R. Monroe   \n",
              "77   A contractor helps a woman renovate a house so...      Erica Dunton   \n",
              "277  Jay Bauman and Josh Davis take a look at Jay's...        Jay Bauman   \n",
              "\n",
              "              cast1              cast2                    cast3  \\\n",
              "14   Lyndsy Fonseca    Chandler Massey             Erika Slezak   \n",
              "18      Erin Cahill        Ryan Paevey         Brandi Alexander   \n",
              "33      Katrina Law        Carlo Marks              Steve Bacic   \n",
              "59    Autumn Reeser  David Haydn-Jones              Liam Hughes   \n",
              "77    Janel Parrish      Jeremy Jordan          Marisol Nichols   \n",
              "277      Josh Davis         Jay Bauman  Fabrice-Ange Zaphiratos   \n",
              "\n",
              "              cast4  votes                                         all_actors  \n",
              "14     Eric Freeman  1,872  Lyndsy Fonseca , Chandler Massey , Erika Sleza...  \n",
              "18       Zahf Paroo  2,427  Erin Cahill , Ryan Paevey , Brandi Alexander ,...  \n",
              "33   Islie Hirvonen  1,390  Katrina Law , Carlo Marks , Steve Bacic , Isli...  \n",
              "59    Teryl Rothery  2,301  Autumn Reeser , David Haydn-Jones , Liam Hughe...  \n",
              "77    Sadie Coleman  1,133  Janel Parrish , Jeremy Jordan , Marisol Nichol...  \n",
              "277             NaN     18  Josh Davis , Jay Bauman , Fabrice-Ange Zaphira...  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-e6534068-eddf-4371-9e73-0b5fcbf0815e\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>release_year</th>\n",
              "      <th>certificate</th>\n",
              "      <th>time</th>\n",
              "      <th>genre</th>\n",
              "      <th>stars</th>\n",
              "      <th>description</th>\n",
              "      <th>director_name</th>\n",
              "      <th>cast1</th>\n",
              "      <th>cast2</th>\n",
              "      <th>cast3</th>\n",
              "      <th>cast4</th>\n",
              "      <th>votes</th>\n",
              "      <th>all_actors</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>Next Stop, Christmas</td>\n",
              "      <td>(2021 TV Movie)</td>\n",
              "      <td>TV-G</td>\n",
              "      <td>84 min</td>\n",
              "      <td>Comedy, Drama, Fantasy</td>\n",
              "      <td>7.1</td>\n",
              "      <td>Angie is determined to spend Christmas alone b...</td>\n",
              "      <td>Dustin Rikert</td>\n",
              "      <td>Lyndsy Fonseca</td>\n",
              "      <td>Chandler Massey</td>\n",
              "      <td>Erika Slezak</td>\n",
              "      <td>Eric Freeman</td>\n",
              "      <td>1,872</td>\n",
              "      <td>Lyndsy Fonseca , Chandler Massey , Erika Sleza...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>A Timeless Christmas</td>\n",
              "      <td>(2020 TV Movie)</td>\n",
              "      <td>TV-G</td>\n",
              "      <td>84 min</td>\n",
              "      <td>Comedy, Fantasy, Romance</td>\n",
              "      <td>7.1</td>\n",
              "      <td>Charles Whitley travels from 1903 to 2020 wher...</td>\n",
              "      <td>Ron Oliver</td>\n",
              "      <td>Erin Cahill</td>\n",
              "      <td>Ryan Paevey</td>\n",
              "      <td>Brandi Alexander</td>\n",
              "      <td>Zahf Paroo</td>\n",
              "      <td>2,427</td>\n",
              "      <td>Erin Cahill , Ryan Paevey , Brandi Alexander ,...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\n",
              "      <td>Christmas with the Darlings</td>\n",
              "      <td>(2020 TV Movie)</td>\n",
              "      <td>TV-G</td>\n",
              "      <td>84 min</td>\n",
              "      <td>Comedy, Family, Romance</td>\n",
              "      <td>7.1</td>\n",
              "      <td>A woman helps a charming man look after his or...</td>\n",
              "      <td>Catherine Cyran</td>\n",
              "      <td>Katrina Law</td>\n",
              "      <td>Carlo Marks</td>\n",
              "      <td>Steve Bacic</td>\n",
              "      <td>Islie Hirvonen</td>\n",
              "      <td>1,390</td>\n",
              "      <td>Katrina Law , Carlo Marks , Steve Bacic , Isli...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>59</th>\n",
              "      <td>A Bramble House Christmas</td>\n",
              "      <td>(2017 TV Movie)</td>\n",
              "      <td>Not Rated</td>\n",
              "      <td>84 min</td>\n",
              "      <td>Drama, Romance</td>\n",
              "      <td>7.1</td>\n",
              "      <td>Finn Conrad becomes suspicious as to why his f...</td>\n",
              "      <td>Steven R. Monroe</td>\n",
              "      <td>Autumn Reeser</td>\n",
              "      <td>David Haydn-Jones</td>\n",
              "      <td>Liam Hughes</td>\n",
              "      <td>Teryl Rothery</td>\n",
              "      <td>2,301</td>\n",
              "      <td>Autumn Reeser , David Haydn-Jones , Liam Hughe...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>77</th>\n",
              "      <td>Holly &amp; Ivy</td>\n",
              "      <td>(2020 TV Movie)</td>\n",
              "      <td>TV-G</td>\n",
              "      <td>85 min</td>\n",
              "      <td>Drama, Family, Romance</td>\n",
              "      <td>7.1</td>\n",
              "      <td>A contractor helps a woman renovate a house so...</td>\n",
              "      <td>Erica Dunton</td>\n",
              "      <td>Janel Parrish</td>\n",
              "      <td>Jeremy Jordan</td>\n",
              "      <td>Marisol Nichols</td>\n",
              "      <td>Sadie Coleman</td>\n",
              "      <td>1,133</td>\n",
              "      <td>Janel Parrish , Jeremy Jordan , Marisol Nichol...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>277</th>\n",
              "      <td>re: View</td>\n",
              "      <td>(2016 )</td>\n",
              "      <td>NaN</td>\n",
              "      <td>37 min</td>\n",
              "      <td>Comedy, Talk-Show</td>\n",
              "      <td>7.1</td>\n",
              "      <td>Jay Bauman and Josh Davis take a look at Jay's...</td>\n",
              "      <td>Jay Bauman</td>\n",
              "      <td>Josh Davis</td>\n",
              "      <td>Jay Bauman</td>\n",
              "      <td>Fabrice-Ange Zaphiratos</td>\n",
              "      <td>NaN</td>\n",
              "      <td>18</td>\n",
              "      <td>Josh Davis , Jay Bauman , Fabrice-Ange Zaphira...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-e6534068-eddf-4371-9e73-0b5fcbf0815e')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-e6534068-eddf-4371-9e73-0b5fcbf0815e button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-e6534068-eddf-4371-9e73-0b5fcbf0815e');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 100
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "## Finding out the Christmas Movies that have 'cookie' in their description."
      ],
      "metadata": {
        "id": "vYi0H95-eepV"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df.loc[df[\"description\"].str.contains('cookie[a-z]*', flags=re.I, regex=True)]"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 332
        },
        "id": "XUfANEp_etNi",
        "outputId": "c95f3f4e-45b0-424e-c43e-ae2d31eebe08"
      },
      "execution_count": 106,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                movie_title     release_year certificate    time  \\\n",
              "169       Christmas Cookies  (2016 TV Movie)        TV-G  84 min   \n",
              "175  Spotlight on Christmas  (2020 TV Movie)       TV-PG  84 min   \n",
              "\n",
              "              genre stars                                        description  \\\n",
              "169  Drama, Romance   6.4  A corporate agent is sent to a small town to b...   \n",
              "175  Drama, Romance   6.1  Dumped before Christmas, famous Hollywood actr...   \n",
              "\n",
              "    director_name          cast1             cast2            cast3  \\\n",
              "169    James Head    Jill Wagner         Wes Brown  P. Lynn Johnson   \n",
              "175   Ali Liebert  Tori Anderson  Victor Zinck Jr.    Lia Frankland   \n",
              "\n",
              "              cast4  votes                                         all_actors  \n",
              "169  Chris Gauthier  2,366  Jill Wagner , Wes Brown , P. Lynn Johnson , Ch...  \n",
              "175    Janet Kidder    684  Tori Anderson , Victor Zinck Jr. , Lia Frankla...  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-ccd22a0d-abc9-4acb-a327-8543ebec934f\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>release_year</th>\n",
              "      <th>certificate</th>\n",
              "      <th>time</th>\n",
              "      <th>genre</th>\n",
              "      <th>stars</th>\n",
              "      <th>description</th>\n",
              "      <th>director_name</th>\n",
              "      <th>cast1</th>\n",
              "      <th>cast2</th>\n",
              "      <th>cast3</th>\n",
              "      <th>cast4</th>\n",
              "      <th>votes</th>\n",
              "      <th>all_actors</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>169</th>\n",
              "      <td>Christmas Cookies</td>\n",
              "      <td>(2016 TV Movie)</td>\n",
              "      <td>TV-G</td>\n",
              "      <td>84 min</td>\n",
              "      <td>Drama, Romance</td>\n",
              "      <td>6.4</td>\n",
              "      <td>A corporate agent is sent to a small town to b...</td>\n",
              "      <td>James Head</td>\n",
              "      <td>Jill Wagner</td>\n",
              "      <td>Wes Brown</td>\n",
              "      <td>P. Lynn Johnson</td>\n",
              "      <td>Chris Gauthier</td>\n",
              "      <td>2,366</td>\n",
              "      <td>Jill Wagner , Wes Brown , P. Lynn Johnson , Ch...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>175</th>\n",
              "      <td>Spotlight on Christmas</td>\n",
              "      <td>(2020 TV Movie)</td>\n",
              "      <td>TV-PG</td>\n",
              "      <td>84 min</td>\n",
              "      <td>Drama, Romance</td>\n",
              "      <td>6.1</td>\n",
              "      <td>Dumped before Christmas, famous Hollywood actr...</td>\n",
              "      <td>Ali Liebert</td>\n",
              "      <td>Tori Anderson</td>\n",
              "      <td>Victor Zinck Jr.</td>\n",
              "      <td>Lia Frankland</td>\n",
              "      <td>Janet Kidder</td>\n",
              "      <td>684</td>\n",
              "      <td>Tori Anderson , Victor Zinck Jr. , Lia Frankla...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-ccd22a0d-abc9-4acb-a327-8543ebec934f')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-ccd22a0d-abc9-4acb-a327-8543ebec934f button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-ccd22a0d-abc9-4acb-a327-8543ebec934f');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 106
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "## Finding out the most common cast (i.e., the 4 people who have appeared together the most) for the Christmas Movies which were released from 2017-22."
      ],
      "metadata": {
        "id": "CByyjo5rgT-s"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "from itertools import combinations\n",
        "from collections import Counter\n",
        "\n",
        "count = Counter()\n",
        "for row in df[\"all_actors\"]:\n",
        "  row_list = row.split(',') #Creating the sublist and segrating by each comma\n",
        "  count.update(Counter(combinations(row_list,4)))\n",
        "count.most_common(1) "
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "NEs6XS2ogJ6b",
        "outputId": "0a826bc3-1321-4337-c5c3-d1c22ef229fd"
      },
      "execution_count": 114,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "[(('Rose McIver ', ' Ben Lamb ', ' Alice Krige ', ' Honor Kneafsey'), 3)]"
            ]
          },
          "metadata": {},
          "execution_count": 114
        }
      ]
    }
  ]
}