UdemyProjects-Netflix.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "c83a2dcf",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "5c0103aa",
   "metadata": {},
   "outputs": [],
   "source": [
    "data = pd.read_csv('Netflix+Dataset.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "cafe9b97",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Show_Id</th>\n",
       "      <th>Category</th>\n",
       "      <th>Title</th>\n",
       "      <th>Director</th>\n",
       "      <th>Cast</th>\n",
       "      <th>Country</th>\n",
       "      <th>Release_Date</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Duration</th>\n",
       "      <th>Type</th>\n",
       "      <th>Description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>s1</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>3%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>João Miguel, Bianca Comparato, Michel Gomes, R...</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>August 14, 2020</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>4 Seasons</td>\n",
       "      <td>International TV Shows, TV Dramas, TV Sci-Fi &amp;...</td>\n",
       "      <td>In a future where the elite inhabit an island ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>s2</td>\n",
       "      <td>Movie</td>\n",
       "      <td>07:19</td>\n",
       "      <td>Jorge Michel Grau</td>\n",
       "      <td>Demián Bichir, Héctor Bonilla, Oscar Serrano, ...</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>December 23, 2016</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>93 min</td>\n",
       "      <td>Dramas, International Movies</td>\n",
       "      <td>After a devastating earthquake hits Mexico Cit...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>s3</td>\n",
       "      <td>Movie</td>\n",
       "      <td>23:59</td>\n",
       "      <td>Gilbert Chan</td>\n",
       "      <td>Tedd Chan, Stella Chung, Henley Hii, Lawrence ...</td>\n",
       "      <td>Singapore</td>\n",
       "      <td>December 20, 2018</td>\n",
       "      <td>R</td>\n",
       "      <td>78 min</td>\n",
       "      <td>Horror Movies, International Movies</td>\n",
       "      <td>When an army recruit is found dead, his fellow...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>s4</td>\n",
       "      <td>Movie</td>\n",
       "      <td>9</td>\n",
       "      <td>Shane Acker</td>\n",
       "      <td>Elijah Wood, John C. Reilly, Jennifer Connelly...</td>\n",
       "      <td>United States</td>\n",
       "      <td>November 16, 2017</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>80 min</td>\n",
       "      <td>Action &amp; Adventure, Independent Movies, Sci-Fi...</td>\n",
       "      <td>In a postapocalyptic world, rag-doll robots hi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>s5</td>\n",
       "      <td>Movie</td>\n",
       "      <td>21</td>\n",
       "      <td>Robert Luketic</td>\n",
       "      <td>Jim Sturgess, Kevin Spacey, Kate Bosworth, Aar...</td>\n",
       "      <td>United States</td>\n",
       "      <td>January 1, 2020</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>123 min</td>\n",
       "      <td>Dramas</td>\n",
       "      <td>A brilliant group of students become card-coun...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7784</th>\n",
       "      <td>s7783</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Zozo</td>\n",
       "      <td>Josef Fares</td>\n",
       "      <td>Imad Creidi, Antoinette Turk, Elias Gergi, Car...</td>\n",
       "      <td>Sweden, Czech Republic, United Kingdom, Denmar...</td>\n",
       "      <td>October 19, 2020</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>99 min</td>\n",
       "      <td>Dramas, International Movies</td>\n",
       "      <td>When Lebanon's Civil War deprives Zozo of his ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7785</th>\n",
       "      <td>s7784</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Zubaan</td>\n",
       "      <td>Mozez Singh</td>\n",
       "      <td>Vicky Kaushal, Sarah-Jane Dias, Raaghav Chanan...</td>\n",
       "      <td>India</td>\n",
       "      <td>March 2, 2019</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>111 min</td>\n",
       "      <td>Dramas, International Movies, Music &amp; Musicals</td>\n",
       "      <td>A scrappy but poor boy worms his way into a ty...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7786</th>\n",
       "      <td>s7785</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Zulu Man in Japan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nasty C</td>\n",
       "      <td>NaN</td>\n",
       "      <td>September 25, 2020</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>44 min</td>\n",
       "      <td>Documentaries, International Movies, Music &amp; M...</td>\n",
       "      <td>In this documentary, South African rapper Nast...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7787</th>\n",
       "      <td>s7786</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Zumbo's Just Desserts</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Adriano Zumbo, Rachel Khoo</td>\n",
       "      <td>Australia</td>\n",
       "      <td>October 31, 2020</td>\n",
       "      <td>TV-PG</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>International TV Shows, Reality TV</td>\n",
       "      <td>Dessert wizard Adriano Zumbo looks for the nex...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7788</th>\n",
       "      <td>s7787</td>\n",
       "      <td>Movie</td>\n",
       "      <td>ZZ TOP: THAT LITTLE OL' BAND FROM TEXAS</td>\n",
       "      <td>Sam Dunn</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United Kingdom, Canada, United States</td>\n",
       "      <td>March 1, 2020</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>90 min</td>\n",
       "      <td>Documentaries, Music &amp; Musicals</td>\n",
       "      <td>This documentary delves into the mystique behi...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7789 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Show_Id Category                                    Title  \\\n",
       "0         s1  TV Show                                       3%   \n",
       "1         s2    Movie                                    07:19   \n",
       "2         s3    Movie                                    23:59   \n",
       "3         s4    Movie                                        9   \n",
       "4         s5    Movie                                       21   \n",
       "...      ...      ...                                      ...   \n",
       "7784   s7783    Movie                                     Zozo   \n",
       "7785   s7784    Movie                                   Zubaan   \n",
       "7786   s7785    Movie                        Zulu Man in Japan   \n",
       "7787   s7786  TV Show                    Zumbo's Just Desserts   \n",
       "7788   s7787    Movie  ZZ TOP: THAT LITTLE OL' BAND FROM TEXAS   \n",
       "\n",
       "               Director                                               Cast  \\\n",
       "0                   NaN  João Miguel, Bianca Comparato, Michel Gomes, R...   \n",
       "1     Jorge Michel Grau  Demián Bichir, Héctor Bonilla, Oscar Serrano, ...   \n",
       "2          Gilbert Chan  Tedd Chan, Stella Chung, Henley Hii, Lawrence ...   \n",
       "3           Shane Acker  Elijah Wood, John C. Reilly, Jennifer Connelly...   \n",
       "4        Robert Luketic  Jim Sturgess, Kevin Spacey, Kate Bosworth, Aar...   \n",
       "...                 ...                                                ...   \n",
       "7784        Josef Fares  Imad Creidi, Antoinette Turk, Elias Gergi, Car...   \n",
       "7785        Mozez Singh  Vicky Kaushal, Sarah-Jane Dias, Raaghav Chanan...   \n",
       "7786                NaN                                            Nasty C   \n",
       "7787                NaN                         Adriano Zumbo, Rachel Khoo   \n",
       "7788           Sam Dunn                                                NaN   \n",
       "\n",
       "                                                Country        Release_Date  \\\n",
       "0                                                Brazil     August 14, 2020   \n",
       "1                                                Mexico   December 23, 2016   \n",
       "2                                             Singapore   December 20, 2018   \n",
       "3                                         United States   November 16, 2017   \n",
       "4                                         United States     January 1, 2020   \n",
       "...                                                 ...                 ...   \n",
       "7784  Sweden, Czech Republic, United Kingdom, Denmar...    October 19, 2020   \n",
       "7785                                              India       March 2, 2019   \n",
       "7786                                                NaN  September 25, 2020   \n",
       "7787                                          Australia    October 31, 2020   \n",
       "7788              United Kingdom, Canada, United States       March 1, 2020   \n",
       "\n",
       "     Rating   Duration                                               Type  \\\n",
       "0     TV-MA  4 Seasons  International TV Shows, TV Dramas, TV Sci-Fi &...   \n",
       "1     TV-MA     93 min                       Dramas, International Movies   \n",
       "2         R     78 min                Horror Movies, International Movies   \n",
       "3     PG-13     80 min  Action & Adventure, Independent Movies, Sci-Fi...   \n",
       "4     PG-13    123 min                                             Dramas   \n",
       "...     ...        ...                                                ...   \n",
       "7784  TV-MA     99 min                       Dramas, International Movies   \n",
       "7785  TV-14    111 min     Dramas, International Movies, Music & Musicals   \n",
       "7786  TV-MA     44 min  Documentaries, International Movies, Music & M...   \n",
       "7787  TV-PG   1 Season                 International TV Shows, Reality TV   \n",
       "7788  TV-MA     90 min                    Documentaries, Music & Musicals   \n",
       "\n",
       "                                            Description  \n",
       "0     In a future where the elite inhabit an island ...  \n",
       "1     After a devastating earthquake hits Mexico Cit...  \n",
       "2     When an army recruit is found dead, his fellow...  \n",
       "3     In a postapocalyptic world, rag-doll robots hi...  \n",
       "4     A brilliant group of students become card-coun...  \n",
       "...                                                 ...  \n",
       "7784  When Lebanon's Civil War deprives Zozo of his ...  \n",
       "7785  A scrappy but poor boy worms his way into a ty...  \n",
       "7786  In this documentary, South African rapper Nast...  \n",
       "7787  Dessert wizard Adriano Zumbo looks for the nex...  \n",
       "7788  This documentary delves into the mystique behi...  \n",
       "\n",
       "[7789 rows x 11 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "ee30e879",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Show_Id</th>\n",
       "      <th>Category</th>\n",
       "      <th>Title</th>\n",
       "      <th>Director</th>\n",
       "      <th>Cast</th>\n",
       "      <th>Country</th>\n",
       "      <th>Release_Date</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Duration</th>\n",
       "      <th>Type</th>\n",
       "      <th>Description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>s1</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>3%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>João Miguel, Bianca Comparato, Michel Gomes, R...</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>August 14, 2020</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>4 Seasons</td>\n",
       "      <td>International TV Shows, TV Dramas, TV Sci-Fi &amp;...</td>\n",
       "      <td>In a future where the elite inhabit an island ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>s2</td>\n",
       "      <td>Movie</td>\n",
       "      <td>07:19</td>\n",
       "      <td>Jorge Michel Grau</td>\n",
       "      <td>Demián Bichir, Héctor Bonilla, Oscar Serrano, ...</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>December 23, 2016</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>93 min</td>\n",
       "      <td>Dramas, International Movies</td>\n",
       "      <td>After a devastating earthquake hits Mexico Cit...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>s3</td>\n",
       "      <td>Movie</td>\n",
       "      <td>23:59</td>\n",
       "      <td>Gilbert Chan</td>\n",
       "      <td>Tedd Chan, Stella Chung, Henley Hii, Lawrence ...</td>\n",
       "      <td>Singapore</td>\n",
       "      <td>December 20, 2018</td>\n",
       "      <td>R</td>\n",
       "      <td>78 min</td>\n",
       "      <td>Horror Movies, International Movies</td>\n",
       "      <td>When an army recruit is found dead, his fellow...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>s4</td>\n",
       "      <td>Movie</td>\n",
       "      <td>9</td>\n",
       "      <td>Shane Acker</td>\n",
       "      <td>Elijah Wood, John C. Reilly, Jennifer Connelly...</td>\n",
       "      <td>United States</td>\n",
       "      <td>November 16, 2017</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>80 min</td>\n",
       "      <td>Action &amp; Adventure, Independent Movies, Sci-Fi...</td>\n",
       "      <td>In a postapocalyptic world, rag-doll robots hi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>s5</td>\n",
       "      <td>Movie</td>\n",
       "      <td>21</td>\n",
       "      <td>Robert Luketic</td>\n",
       "      <td>Jim Sturgess, Kevin Spacey, Kate Bosworth, Aar...</td>\n",
       "      <td>United States</td>\n",
       "      <td>January 1, 2020</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>123 min</td>\n",
       "      <td>Dramas</td>\n",
       "      <td>A brilliant group of students become card-coun...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Show_Id Category  Title           Director  \\\n",
       "0      s1  TV Show     3%                NaN   \n",
       "1      s2    Movie  07:19  Jorge Michel Grau   \n",
       "2      s3    Movie  23:59       Gilbert Chan   \n",
       "3      s4    Movie      9        Shane Acker   \n",
       "4      s5    Movie     21     Robert Luketic   \n",
       "\n",
       "                                                Cast        Country  \\\n",
       "0  João Miguel, Bianca Comparato, Michel Gomes, R...         Brazil   \n",
       "1  Demián Bichir, Héctor Bonilla, Oscar Serrano, ...         Mexico   \n",
       "2  Tedd Chan, Stella Chung, Henley Hii, Lawrence ...      Singapore   \n",
       "3  Elijah Wood, John C. Reilly, Jennifer Connelly...  United States   \n",
       "4  Jim Sturgess, Kevin Spacey, Kate Bosworth, Aar...  United States   \n",
       "\n",
       "        Release_Date Rating   Duration  \\\n",
       "0    August 14, 2020  TV-MA  4 Seasons   \n",
       "1  December 23, 2016  TV-MA     93 min   \n",
       "2  December 20, 2018      R     78 min   \n",
       "3  November 16, 2017  PG-13     80 min   \n",
       "4    January 1, 2020  PG-13    123 min   \n",
       "\n",
       "                                                Type  \\\n",
       "0  International TV Shows, TV Dramas, TV Sci-Fi &...   \n",
       "1                       Dramas, International Movies   \n",
       "2                Horror Movies, International Movies   \n",
       "3  Action & Adventure, Independent Movies, Sci-Fi...   \n",
       "4                                             Dramas   \n",
       "\n",
       "                                         Description  \n",
       "0  In a future where the elite inhabit an island ...  \n",
       "1  After a devastating earthquake hits Mexico Cit...  \n",
       "2  When an army recruit is found dead, his fellow...  \n",
       "3  In a postapocalyptic world, rag-doll robots hi...  \n",
       "4  A brilliant group of students become card-coun...  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "033408fc",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Show_Id</th>\n",
       "      <th>Category</th>\n",
       "      <th>Title</th>\n",
       "      <th>Director</th>\n",
       "      <th>Cast</th>\n",
       "      <th>Country</th>\n",
       "      <th>Release_Date</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Duration</th>\n",
       "      <th>Type</th>\n",
       "      <th>Description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>7784</th>\n",
       "      <td>s7783</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Zozo</td>\n",
       "      <td>Josef Fares</td>\n",
       "      <td>Imad Creidi, Antoinette Turk, Elias Gergi, Car...</td>\n",
       "      <td>Sweden, Czech Republic, United Kingdom, Denmar...</td>\n",
       "      <td>October 19, 2020</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>99 min</td>\n",
       "      <td>Dramas, International Movies</td>\n",
       "      <td>When Lebanon's Civil War deprives Zozo of his ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7785</th>\n",
       "      <td>s7784</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Zubaan</td>\n",
       "      <td>Mozez Singh</td>\n",
       "      <td>Vicky Kaushal, Sarah-Jane Dias, Raaghav Chanan...</td>\n",
       "      <td>India</td>\n",
       "      <td>March 2, 2019</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>111 min</td>\n",
       "      <td>Dramas, International Movies, Music &amp; Musicals</td>\n",
       "      <td>A scrappy but poor boy worms his way into a ty...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7786</th>\n",
       "      <td>s7785</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Zulu Man in Japan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nasty C</td>\n",
       "      <td>NaN</td>\n",
       "      <td>September 25, 2020</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>44 min</td>\n",
       "      <td>Documentaries, International Movies, Music &amp; M...</td>\n",
       "      <td>In this documentary, South African rapper Nast...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7787</th>\n",
       "      <td>s7786</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Zumbo's Just Desserts</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Adriano Zumbo, Rachel Khoo</td>\n",
       "      <td>Australia</td>\n",
       "      <td>October 31, 2020</td>\n",
       "      <td>TV-PG</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>International TV Shows, Reality TV</td>\n",
       "      <td>Dessert wizard Adriano Zumbo looks for the nex...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7788</th>\n",
       "      <td>s7787</td>\n",
       "      <td>Movie</td>\n",
       "      <td>ZZ TOP: THAT LITTLE OL' BAND FROM TEXAS</td>\n",
       "      <td>Sam Dunn</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United Kingdom, Canada, United States</td>\n",
       "      <td>March 1, 2020</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>90 min</td>\n",
       "      <td>Documentaries, Music &amp; Musicals</td>\n",
       "      <td>This documentary delves into the mystique behi...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Show_Id Category                                    Title     Director  \\\n",
       "7784   s7783    Movie                                     Zozo  Josef Fares   \n",
       "7785   s7784    Movie                                   Zubaan  Mozez Singh   \n",
       "7786   s7785    Movie                        Zulu Man in Japan          NaN   \n",
       "7787   s7786  TV Show                    Zumbo's Just Desserts          NaN   \n",
       "7788   s7787    Movie  ZZ TOP: THAT LITTLE OL' BAND FROM TEXAS     Sam Dunn   \n",
       "\n",
       "                                                   Cast  \\\n",
       "7784  Imad Creidi, Antoinette Turk, Elias Gergi, Car...   \n",
       "7785  Vicky Kaushal, Sarah-Jane Dias, Raaghav Chanan...   \n",
       "7786                                            Nasty C   \n",
       "7787                         Adriano Zumbo, Rachel Khoo   \n",
       "7788                                                NaN   \n",
       "\n",
       "                                                Country        Release_Date  \\\n",
       "7784  Sweden, Czech Republic, United Kingdom, Denmar...    October 19, 2020   \n",
       "7785                                              India       March 2, 2019   \n",
       "7786                                                NaN  September 25, 2020   \n",
       "7787                                          Australia    October 31, 2020   \n",
       "7788              United Kingdom, Canada, United States       March 1, 2020   \n",
       "\n",
       "     Rating  Duration                                               Type  \\\n",
       "7784  TV-MA    99 min                       Dramas, International Movies   \n",
       "7785  TV-14   111 min     Dramas, International Movies, Music & Musicals   \n",
       "7786  TV-MA    44 min  Documentaries, International Movies, Music & M...   \n",
       "7787  TV-PG  1 Season                 International TV Shows, Reality TV   \n",
       "7788  TV-MA    90 min                    Documentaries, Music & Musicals   \n",
       "\n",
       "                                            Description  \n",
       "7784  When Lebanon's Civil War deprives Zozo of his ...  \n",
       "7785  A scrappy but poor boy worms his way into a ty...  \n",
       "7786  In this documentary, South African rapper Nast...  \n",
       "7787  Dessert wizard Adriano Zumbo looks for the nex...  \n",
       "7788  This documentary delves into the mystique behi...  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "8f25d5c5",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(7789, 11)"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "f03a942c",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 7789 entries, 0 to 7788\n",
      "Data columns (total 11 columns):\n",
      " #   Column        Non-Null Count  Dtype \n",
      "---  ------        --------------  ----- \n",
      " 0   Show_Id       7789 non-null   object\n",
      " 1   Category      7789 non-null   object\n",
      " 2   Title         7789 non-null   object\n",
      " 3   Director      5401 non-null   object\n",
      " 4   Cast          7071 non-null   object\n",
      " 5   Country       7282 non-null   object\n",
      " 6   Release_Date  7779 non-null   object\n",
      " 7   Rating        7782 non-null   object\n",
      " 8   Duration      7789 non-null   object\n",
      " 9   Type          7789 non-null   object\n",
      " 10  Description   7789 non-null   object\n",
      "dtypes: object(11)\n",
      "memory usage: 669.5+ KB\n"
     ]
    }
   ],
   "source": [
    "data.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "ff512a05",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "85679"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.size"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "9aaf13ac",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Show_Id', 'Category', 'Title', 'Director', 'Cast', 'Country',\n",
       "       'Release_Date', 'Rating', 'Duration', 'Type', 'Description'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "97c16b3b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Show_Id         object\n",
       "Category        object\n",
       "Title           object\n",
       "Director        object\n",
       "Cast            object\n",
       "Country         object\n",
       "Release_Date    object\n",
       "Rating          object\n",
       "Duration        object\n",
       "Type            object\n",
       "Description     object\n",
       "dtype: object"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.dtypes"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "268a206c",
   "metadata": {},
   "source": [
    "# Task.1. Is there any Duplicate Record in this dataset ? If yes, then remove the duplicate records."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "1c6df2a9",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Show_Id</th>\n",
       "      <th>Category</th>\n",
       "      <th>Title</th>\n",
       "      <th>Director</th>\n",
       "      <th>Cast</th>\n",
       "      <th>Country</th>\n",
       "      <th>Release_Date</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Duration</th>\n",
       "      <th>Type</th>\n",
       "      <th>Description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>s1</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>3%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>João Miguel, Bianca Comparato, Michel Gomes, R...</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>August 14, 2020</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>4 Seasons</td>\n",
       "      <td>International TV Shows, TV Dramas, TV Sci-Fi &amp;...</td>\n",
       "      <td>In a future where the elite inhabit an island ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>s2</td>\n",
       "      <td>Movie</td>\n",
       "      <td>07:19</td>\n",
       "      <td>Jorge Michel Grau</td>\n",
       "      <td>Demián Bichir, Héctor Bonilla, Oscar Serrano, ...</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>December 23, 2016</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>93 min</td>\n",
       "      <td>Dramas, International Movies</td>\n",
       "      <td>After a devastating earthquake hits Mexico Cit...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>s3</td>\n",
       "      <td>Movie</td>\n",
       "      <td>23:59</td>\n",
       "      <td>Gilbert Chan</td>\n",
       "      <td>Tedd Chan, Stella Chung, Henley Hii, Lawrence ...</td>\n",
       "      <td>Singapore</td>\n",
       "      <td>December 20, 2018</td>\n",
       "      <td>R</td>\n",
       "      <td>78 min</td>\n",
       "      <td>Horror Movies, International Movies</td>\n",
       "      <td>When an army recruit is found dead, his fellow...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>s4</td>\n",
       "      <td>Movie</td>\n",
       "      <td>9</td>\n",
       "      <td>Shane Acker</td>\n",
       "      <td>Elijah Wood, John C. Reilly, Jennifer Connelly...</td>\n",
       "      <td>United States</td>\n",
       "      <td>November 16, 2017</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>80 min</td>\n",
       "      <td>Action &amp; Adventure, Independent Movies, Sci-Fi...</td>\n",
       "      <td>In a postapocalyptic world, rag-doll robots hi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>s5</td>\n",
       "      <td>Movie</td>\n",
       "      <td>21</td>\n",
       "      <td>Robert Luketic</td>\n",
       "      <td>Jim Sturgess, Kevin Spacey, Kate Bosworth, Aar...</td>\n",
       "      <td>United States</td>\n",
       "      <td>January 1, 2020</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>123 min</td>\n",
       "      <td>Dramas</td>\n",
       "      <td>A brilliant group of students become card-coun...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Show_Id Category  Title           Director  \\\n",
       "0      s1  TV Show     3%                NaN   \n",
       "1      s2    Movie  07:19  Jorge Michel Grau   \n",
       "2      s3    Movie  23:59       Gilbert Chan   \n",
       "3      s4    Movie      9        Shane Acker   \n",
       "4      s5    Movie     21     Robert Luketic   \n",
       "\n",
       "                                                Cast        Country  \\\n",
       "0  João Miguel, Bianca Comparato, Michel Gomes, R...         Brazil   \n",
       "1  Demián Bichir, Héctor Bonilla, Oscar Serrano, ...         Mexico   \n",
       "2  Tedd Chan, Stella Chung, Henley Hii, Lawrence ...      Singapore   \n",
       "3  Elijah Wood, John C. Reilly, Jennifer Connelly...  United States   \n",
       "4  Jim Sturgess, Kevin Spacey, Kate Bosworth, Aar...  United States   \n",
       "\n",
       "        Release_Date Rating   Duration  \\\n",
       "0    August 14, 2020  TV-MA  4 Seasons   \n",
       "1  December 23, 2016  TV-MA     93 min   \n",
       "2  December 20, 2018      R     78 min   \n",
       "3  November 16, 2017  PG-13     80 min   \n",
       "4    January 1, 2020  PG-13    123 min   \n",
       "\n",
       "                                                Type  \\\n",
       "0  International TV Shows, TV Dramas, TV Sci-Fi &...   \n",
       "1                       Dramas, International Movies   \n",
       "2                Horror Movies, International Movies   \n",
       "3  Action & Adventure, Independent Movies, Sci-Fi...   \n",
       "4                                             Dramas   \n",
       "\n",
       "                                         Description  \n",
       "0  In a future where the elite inhabit an island ...  \n",
       "1  After a devastating earthquake hits Mexico Cit...  \n",
       "2  When an army recruit is found dead, his fellow...  \n",
       "3  In a postapocalyptic world, rag-doll robots hi...  \n",
       "4  A brilliant group of students become card-coun...  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "8bc7ca1a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(7789, 11)"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "e44dd732",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Show_Id</th>\n",
       "      <th>Category</th>\n",
       "      <th>Title</th>\n",
       "      <th>Director</th>\n",
       "      <th>Cast</th>\n",
       "      <th>Country</th>\n",
       "      <th>Release_Date</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Duration</th>\n",
       "      <th>Type</th>\n",
       "      <th>Description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>6300</th>\n",
       "      <td>s684</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Backfire</td>\n",
       "      <td>Dave Patten</td>\n",
       "      <td>Black Deniro, Byron \"Squally\" Vinson, Dominic ...</td>\n",
       "      <td>United States</td>\n",
       "      <td>April 5, 2019</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>97 min</td>\n",
       "      <td>Dramas, Independent Movies, Thrillers</td>\n",
       "      <td>When two would-be robbers accidentally kill a ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6622</th>\n",
       "      <td>s6621</td>\n",
       "      <td>Movie</td>\n",
       "      <td>The Lost Okoroshi</td>\n",
       "      <td>Abba T. Makama</td>\n",
       "      <td>Seun Ajayi, Judith Audu, Tope Tedela, Ifu Enna...</td>\n",
       "      <td>Nigeria</td>\n",
       "      <td>September 4, 2020</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>94 min</td>\n",
       "      <td>Comedies, Dramas, Independent Movies</td>\n",
       "      <td>A disillusioned security guard transforms into...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Show_Id Category              Title        Director  \\\n",
       "6300    s684    Movie           Backfire     Dave Patten   \n",
       "6622   s6621    Movie  The Lost Okoroshi  Abba T. Makama   \n",
       "\n",
       "                                                   Cast        Country  \\\n",
       "6300  Black Deniro, Byron \"Squally\" Vinson, Dominic ...  United States   \n",
       "6622  Seun Ajayi, Judith Audu, Tope Tedela, Ifu Enna...        Nigeria   \n",
       "\n",
       "           Release_Date Rating Duration  \\\n",
       "6300      April 5, 2019  TV-MA   97 min   \n",
       "6622  September 4, 2020  TV-MA   94 min   \n",
       "\n",
       "                                       Type  \\\n",
       "6300  Dramas, Independent Movies, Thrillers   \n",
       "6622   Comedies, Dramas, Independent Movies   \n",
       "\n",
       "                                            Description  \n",
       "6300  When two would-be robbers accidentally kill a ...  \n",
       "6622  A disillusioned security guard transforms into...  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data.duplicated()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "6cbd534c",
   "metadata": {},
   "outputs": [],
   "source": [
    "data.drop_duplicates(inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "6f6d62bc",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(7787, 11)"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "3e973c13",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Show_Id</th>\n",
       "      <th>Category</th>\n",
       "      <th>Title</th>\n",
       "      <th>Director</th>\n",
       "      <th>Cast</th>\n",
       "      <th>Country</th>\n",
       "      <th>Release_Date</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Duration</th>\n",
       "      <th>Type</th>\n",
       "      <th>Description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [Show_Id, Category, Title, Director, Cast, Country, Release_Date, Rating, Duration, Type, Description]\n",
       "Index: []"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data.duplicated()]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e43c326a",
   "metadata": {},
   "source": [
    "# Task.2. Is there any Null Value present in any column ? Show with Heat-map."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "897a7296",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Show_Id            0\n",
       "Category           0\n",
       "Title              0\n",
       "Director        2388\n",
       "Cast             718\n",
       "Country          507\n",
       "Release_Date      10\n",
       "Rating             7\n",
       "Duration           0\n",
       "Type               0\n",
       "Description        0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "c0a5765c",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "D:\\anaconda\\lib\\site-packages\\scipy\\__init__.py:146: UserWarning: A NumPy version >=1.16.5 and <1.23.0 is required for this version of SciPy (detected version 1.24.3\n",
      "  warnings.warn(f\"A NumPy version >={np_minversion} and <{np_maxversion}\"\n"
     ]
    }
   ],
   "source": [
    "import seaborn as sns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "24ade8cd",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:>"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAW0AAAE3CAYAAABhFBCzAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjUuMSwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/YYfK9AAAACXBIWXMAAAsTAAALEwEAmpwYAAA+kElEQVR4nO2deZhcVbX2f2/CGCAENXCZBwWUWYboRVQEQeBeQEUFHEDxE0FQhs8BRBQVPxFRQOCCyAVBEWTUIJOAzGMShhAEJMwBJASUUQlJv98fexepVKq7q7tODad6/Z7nPKmzz6m9d3V3Vu2z9nrXkm2CIAiCcjCq0xMIgiAIGieMdhAEQYkIox0EQVAiwmgHQRCUiDDaQRAEJSKMdhAEQYlou9GWtJ2kByVNl3RIu8cPgiAoM2012pJGAycB2wPrALtLWqedcwiCIGgHkk6XNFPStH6uS9Iv8gJ2qqSNG+m33SvtCcB024/Yng2cC+zc5jkEQRC0g18D2w1wfXtgzXzsDZzcSKftNtorAk9Wnc/IbUEQBD2F7RuAFwa4ZWfgLCduA8ZJWn6wfhcqaoINojptC+joJe1N+uZBo5feZNSoJVo9r1Lzr6dvbGn/i6/w/pb2HwRFMWf2U/VsTMO8MeuRhvN6LDL+7V8m26nMqbZPHcJw/S1inxnoTe022jOAlavOVwKerr0pf/BTARZaZMVIjjIIYVSDoCD65jZ8a7WdGiYNLWJrabd7ZBKwpqTVJS0C7AZMbPMcgiAI6uO+xo/maWgRW0tbjbbtOcD+wJXA/cB5tu9r5xyCIAj6pa+v8aN5JgJ75CiS9wIv2h7QNQLtd49g+zLgsnaPGwRBMBguZgUNgKRzgC2Bt0maAXwPWDiN41NIdnAHYDrwGvCFRvptu9EOglpavZEK4fcPGqSYFTQAtncf5LqB/YbabxjtoOOEQQ26hrlvdHoGgzJsn7akxSTdIekeSfdJ+n5u/72ku/PxmKS7c/tbJV0r6RVJJxY0/yAIguJo70bksGhmpf06sJXtVyQtDNwk6XLbu1ZukPQz4MV8+m/gcGC9fARBEHQXBbpHWsWwjXb2x7ySTxfOx5sxhpIEfArYKt//Ksmwv2PYsw2CIGghRW5EtoqmQv4kjc7uj5nAVbZvr7r8fuBZ2w81M0YQBEHbaG/I37Boymjbnmt7I1JQ+ARJ1W6P3YFzhtOvpL0lTZY0ua/v1WamGARB0Dg97tN+E9v/lHQdKaPVNEkLAR8HNhlmfyFjD4Kg/fR49Mh4SePy68WBDwMP5MsfBh6wPaPpGQZBELSLErhHmllpLw+cmQsbjCJJ0v+Ur+1GHdeIpMeAscAikj4KbGv7r03MIQiCoDhKsBHZTPTIVODd/Vz7fD/tqw13vCAIgpbTyyF/QRAEvYbdeGrWTjFsoy1pbeD3VU1rAN+1fVy+/nXgp8B427MkbQMcBSwCzAa+Yfsvwx0/mEcUQQiCgpg7p9MzGJRm3CMPAhvBmwV7nwIuzucrA9sAT1S9ZRawo+2nc2jglUSpsUJotVGNL4VgxNDLPu0atgYetv14Pj8W+Cbwx8oNtu+quv8+YDFJi9p+vaA5jFjakSWvlUSWv6BrGELlmk5RlNF+M1pE0k7AU7bvSUr2uuwC3BUGuxjCIAVBQYyElXYuG7YTcKikMcBhwLYD3L8u8JNB7qku7EsU9g2CoC2MkOiR7YE7bT8raX1gdaCyyl4JuFPSBNt/l7QSye+9h+2H++swFJFDI3zOQVAQI2GlTVWOEdv3AstWLmQxzaY5emQccClwqO2bCxg3yIRRDYKCmNP90SPNZvkbQ4oSuaiB2/cH3gEcXlUkYdnB3hQEQdAu7LkNH52iqZW27deAtw5wfbWq10cCRzYzXhAEQUsZIT7toMOETzsICqIXfNqSTgf+G5hpe73c9kngCOBdwATbk3P7W4ELgM2AX9vev6qfK0hJphYCbgT2cxk0oyUgxDVBUBA9stL+NXAicFZV2zRSvuxf1tw7UB3IT9l+KZchuwD4JHDuMOYctJkwqsGIoRdW2rZvkLRaTdv9ALXimYHqQNp+qWrMRaiqJxk0R6yEg6Agejn3yHCQdCUwAbictNoOCiCMahAURI+4RwrD9kckLQacTarSflU7x+9VYqUdBAURRntBbP9b0kRgZ/ox2iFjHxphVIOgIErg025KXNMokpaUtHx+vRCwA/PqSS6A7VNtb2p70zDYQRC0jV6oESnpHGBL4G2SZgDfA14ATgDGA5dKutv2R/L9j1FTBxJ4HpgoaVFgNPAX4JSiP0wQBEFT9MJGpO3d+7l0cT/3r9bP/Zs1OKdgiIRPOwgKogTukVBEBkEQVIiNyKAdxEo4CAqiBEZ70I1ISadLmilpWp1rX5dkSW/L5wtLOlPSvZLul3RonfdMrNdXEARBx7EbPzpEI9Ejvwa2q23sp3jvJ4FFba8PbAJ8uVpNKenjwCtNzDcIgqB19EL0SD0Ze2aB4r0kafoSOaxvcWA28BKksD/gYFL89XnNTTuopuwbkVHYN+gaeiF6pB4DFO+9gCSaeQYYAxxk+4V87YfAz4DXhj/doB5lN0hln3/QQxS8gpa0HXA8KdT5NNtH1VxfGvgtsArJHh9j+4yB+hyy0R6keO8EYC6wArAMcKOkq0lx2++wfVA/q/baMUIRGQRB+ynQVy1pNHASyY08A5gkaaLtv1bdth/wV9s7ShoPPCjpbNuz++t3OCvtt9NP8V7g08AVtt8AZkq6GdiUVN1mkyy8WQhYVtJ1tresN0AU9g2CoCMUu9KeAEy3/QiApHNJnohqo21gqZyyekmScHFAH82QZey277W9rO3VspBmBrCx7b+TNiW3UmIJ4L3AA7ZPtr1Cvn8L4G/9GewgCIKOMYSNSEl7S5pcdexd09uKwJNV5zNyWzUnkorJPA3cCxxgD6zwaSTk7xzgVmBtSTMkfXGA208ifVtMAyYBZ9ieOtgYQRAEXYH7Gj6qcyTl49Sa3lRvhJrzjwB3k1zKGwEnSho70BSbkbFXrq9W9foVUtjfQPc/xoJVbYIgCDqO5xRaAXEGsHLV+UqkFXU1XwCOsm1guqRHgXcCd/TXaVuy/AVBEJSCIay0G2ASsKak1SUtAuwGTKy55wlgawBJywFrA48M1OmwFJGSNpJ0m6S7sy9nQm5fTdK/cvvdkk6pes91kh6surZsI586CIKgbfS58WMQbM8B9geuBO4HzrN9n6R9JO2Tb/shsLmke4FrgG/ZnjVQv8Mt7Hs08H3bl0vaIZ9vma89bHujfvr6TKVyexBUCHFN0DUUHKdt+zLgspq2U6peP0398Ol+Ga4i0qTYa4ClWdBPEwQNEwY16BpKkDBquFn+DgSulHQMycWyedW11SXdRZKvf8d29TLqDElzgQuBI7PzPWiSssvYg6BrmFvoRmRLGK7R3pckUb9Q0qeA/wU+TJKvr2L7eUmbAH+QtK7tl0iukackLUUy2p9jfpfLm4QicmiEUQ2CgmjAV91phmu09wQOyK/PB04DsP068Hp+PUXSw8BawGTbT+X2lyX9jqQWqmu0QxE5sgifdtA19HDlmqeBDwLXAVsBDwFk7fwLtudKWgNYE3gkZ/0bZ3uWpIWB/waubnbyQW8QBjXoGnphpd1PYd8vAcdnY/xvsisD+ADwA0lzSImj9rH9Qpa0X5kN9miSwf5V0R8mCIKgGdwLG5EDKCI3qXPvhSR/dW37q/XuD4Ig6Cp6YaUdBEEwYihB9EgjisiVJV2baz7eJ+mA3P5TSQ9ImirpYknjcvs2kqbkOpFTJG1V1dcikk6V9Lf83l1a9smCIAiGSgnKjTWSe2QO8H9tv4uUanU/SesAVwHr2d4A+BtQKeI7C9gx14ncE/hNVV+HATNtrwWsA1xfzMcIgiAogAJl7K2iEZ/2M6T460q43v3Airb/XHXbbcAn8j13VbXfBywmadEcDrgXKYMVOWfsgBr7IAiCtlKCkL8hZfnLcvZ3A7fXXNoLuLzOW3YB7rL9esV9AvxQ0p2Szs9ZrYIgCLqDXlhpV8jV1C8EDswKx0r7YSQXytk1968L/IR5yVAWIuWTvdn2wZIOBo4hKSODLiZk8sFIoeB82i2hIaOd46svBM62fVFV+54koczW1XlEJK0EXAzsYfvh3Pw8qRL7xfn8fKBuFZyQsQ+NMKpBUBAlCPlrJHpEpNwi99v+eVX7dsC3gJ1sv1bVPg64FDjU9s2V9mzUL2FeCtetmb/AJVX3vlnGJwx2EARto9giCC1BgyXak7QFcCOp6GRlpt8GfgEsSlpBA9xmex9J3yFFkjxU1c22tmdKWpUUTTIOeA74gu0nBho/co/0PpF7JCiKObOfqleXsWFeOXinhu3Nkj+f2NRYw2VQo91pwmgHQdAozRrtlw/csWF7s9Rxl3TEaIciMgiCoEIJfNphtHuA2IgMgoLohegRSSuT8l7/B8mnfart4yUdQcr291y+9du2L8tVh38JbJrvP8D2dbn4QbV1WQn4re0Di/owI5UwqkFQED2y0q7I2O/MhneKpKvytWNtH1Nz/5cAbK+fK65fLmkz2y8DG1VukjQFuIggCIIuodv3+KAJGfsAb1mHVAqeHDHyT9Kq+47KDZLWBJZl/pV3MEzCPRIEBdEjK+03qZGxvw/YX9IewGTSavwfwD3AzpLOBVYm5dFemSqjDewO/D4K+xZDGNUgKIgSGO2Gc4/UkbGfDLyd5PJ4BvhZvvV0YAbJkB8H3EJysVSzG3DOAGPtLWmypMl9fa82OsUgCIKmcJ8bPjrFsGXstp+tuv4r4E+5fQ5wUNW1W6gS2kjaEFjI9pT+xovCvkEQdIQ53W9uGoke6U/Gvnz2dwN8DJiW28eQRDuvStoGmGO7Wq6+OwOssoMgCDpFJ1fQjdLISvt9pEx890q6O7d9G9hd0kaAgceAL+dry5KK+PYBT7FgFr9PATs0NesgCIJW0AtG2/ZNQD255mX93P8YsPYA/a3R6OSCxojokSAoiO6vgRCKyF4gjGoQFEMZ3CPNFPbdUNKtuYDvJZLGVr1ng3ztvnx9sdy+ez6fKukKSW9r3UcLgiAYGp7jho9O0Uxh39OAQ3IB34uBbwBIWgj4LbCP7XVJ+bPfyO3HAx/KxYCnAvsX/HmCIAiGT98Qjg7RjCJybeCGfNtVwJXA4aTyYlNt35Pf8zy8GTYoYAlJzwNjgemFfpqgJYTPPBgplKCub1OKyGnATsAfgU+SVI8AawGWdCUwHjjX9tG235C0L6mYwquk2O39ivgQQWsJoxqMGEpgtJtRRO5FcpVMAZYCZudbFwK2AD6T//2YpK3zSntfktFfgeQeObSfsUIRGQRB2ylBtbHGjHY/isgHbG9rexOSWKZSwHcGcL3tWbl25GXAxuQMf7YfzjlHzgM2rzde1IgMgqAjFOzTlrSdpAclTZd0SD/3bCnp7hy4cf1gfTajiFw2Z/EbBXwHOCVfuhL4ZlZGzgY+CBxLEtqsI2m87eeAbYD7Bxs/6Dzh0w5GCn21WZKaQNJo4CSSrZsBTJI0sVohnguh/w+wne0ncjrrAWlGEbmmpIpP+iLgDADb/5D0c2ASSS15me1L8wS/D9wg6Q3gceDzDYwfdJgwqsFIoWC3xwRguu1HAHLm052B6rQenwYuqhQ4tz1zsE6bUURCCuGr957fksL+attPYd6KPAiCoLtw47V6Je0N7F3VdGpOdldhReDJqvMZwHtqulkLWFjSdaS9weNtnzXQuKGI7AHCfREExTCUlXZ1NtJ+qPcNUKvKWYhUc2BrYHHgVkm32f5bf5024tNejBSPvWi+/wLb35P0Q9JSvw+YCXze9tOSJlR9EAFH2L4497UrcBgwGrjU9jcHGz8YnLIb1VZ/6UD5f0ZBe3Bf4yvtBpjBvFBoSHVxn65zzyzbrwKvSroB2BAYvtEGXge2sv1KjiK5SdLlwE9tHw4g6WvAd4F9SPHbm9qeI2l54B5JlwBLAz8FNrH9nKQzJW1t+5oG5hAMQKy0g6AYCvZpTyLt/a1OCsTYjeTDruaPwIlZMb4IyX1y7ECdNuLTNvBKPl04H86x2hWWIC/7c5hfhcWY9ziwBvC3HDkCcDWwC7meZBAEQafpm1vcSjsvXPcnRdSNBk63fZ+kffL1U2zfL+kKkm6lDzjN9rSB+lUjZRpz6MoU4B3ASba/ldt/BOwBvEjKKfJcbn8PqezYqsDnbF8saRmSGnIL0iPB74FFbO840NhRuSYIgkaZM/uppqzuk5tt3bC9WXnSNYX6UhqlIXGN7bm2NyL5ZCZIWi+3H2Z7ZeBsqpI/2b49J4vaDDhU0mK56O++JGN9I6lwQoFRkUEQBM1hN350ioZl7AC2/wlcB2xXc+l3JFdH7f33k/KMVIz8JbbfY/s/gQepqh1ZTcjYgyDoBO5Tw0enaCR6ZDzwhu1/Sloc+DDwE0lr2q4Y3Z2AB/L9qwNPZn/OqqRsgI/laxUV5TLAV0ilxxYgCvt2F7HRGYwUOmmMG6WR6JHlgTOzX3sUcJ7tP0m6UNLaJOf546TIEUg+60Oy6rEP+IrtWfna8bkaO8APBopFDBonjGoQFEORG5GtoqGNyE4SK+0gCBql2Y3Ih9f7SMP25u3TruyIhQ9FZDAosZIPRgo9VwQhGJmEUQ1GCn1DyD3SKZqRsf+etMkIMA74p+2NJL0VuIAU7vdr2/tX9bUJ8GuSxv4y4AB3u3+mBJR9JRwy9qBbcC8YbfqRsdvetXKDpJ+RBDYA/ybVilwvH9WcTMqKdRvJaG8HXN7cRwjKbpDKPv+gdyhD9MigcdpOLCBjr1zPRRI+Rapeg+1XczrXf1f3k/OQjLV9a15dnwV8tIgPEQRBUAR9c9Xw0SkaLTc2OhdAmAlcZfv2qsvvB56titnujxVJ8vUKM3JbEARBV9BnNXx0iqZk7JndyavsQWgkt2y6MRSRQRB0AFsNH51iSNEjWRV5HckXPS2nE/w4KYn3YMwgGf0K9XLLVsYJReQQKPtGZBB0C2UIixi2jD1f/jDwgO0Z/XaQsf2MpJclvRe4nZQd8IThTz2oEEY1CIqhJ0L+6EfGnq/tRh3XiKTHgLHAIpI+CmybKxDvy7yQv8uJyJEgCLqIngj5sz0VeHc/1z7fT/tq/bRPZsEwwCAIgq5gbglC/kIRGQRBkCnDSrvhfNo57O8uSX/K52+RdJWkh/K/y+T2hXP9x3sl3S/p0Ko+fiTpSUmv9DdOEARBpyhDyN9QVtoHAPeTfNUAhwDX2D5K0iH5/FvAJ4FFba8vaQzwV0nn2H4MuAQ4kX6KHwTDI6JHgqAYShA80rC4ZiXgv4DTqpp3Bs7Mr89knrrRwBI5HHBxYDbwEoDt22w/0/y0gyAIiqeXVtrHAd8ElqpqW65igHM437K5/QKSQX8GGAMcZPuFYqYb1CNWwkFQDHNL4NNuJE77v4GZtqdI2rKBPicAc4EVgGWAGyVdbfuRRiclaW9SYik0emlGjVqi0beOSNqRJa/sxBdb0AiuK9zuLhpZab8P2EnSDsBiwFhJvwWelbR8XmUvT8pLAvBp4ArbbwAzJd0MbAo0bLRDEdldhMELRgp9JbA2jcRpHwocCpBX2l+3/VlJPwX2BI7K//4xv+UJYKts2McA7yW5V4IWEUY1CIqhrwQr7YZD/upwFLCNpIeAbfI5wEnAksA0YBJwRhboIOloSTOAMZJmSDqiifGDIAgKxajho1NEYd8eoOw+7XhSCIqi2cK+Vy23a8P2Zptnfx+FfYPhEUYvCIphbgncI2G0e4AQ1wRBMZSgGHvjRjtn+ZsMPGX7v6vavw78FBhve5ak1UjKyQfzLbfZ3ierI88H3k4KCbzE9iHFfIyRTRjVICiGXgn5q1ArY0fSyqRNyCdq7n04V7qp5Rjb10paBLhG0va2Iz1rk8RKOwiKoQRJ/hoz2lUy9h8BB1ddOpaklPxjvfdVY/s14Nr8erakO5m/kk0wTMKoBkExlCHkb9gydkk7kVwl96SC7POxuqS7SDlHvmN7vqWgpHHAjsDxw5t20Eu0I/olvtiCRpjb6Qk0wLBk7Nk/fRiwbZ23PAOsYvt5SZsAf5C0ru2X8nsXIlW7+UV/0vaQsY8swqAG3ULfggvQrmNYMnbgN8DqQGWVvRJwp6QJtv8OvA6QDf3DwFqkTUxI8vSHbB/X34AhYx8a4dMOgmIog7EZrox9l+p7ck3ITXP0yHjgBdtzJa0BrEnOOyLpSGBp4P8U+BmCIAgKoQwhf83I2PvjA8BUSfeQ0rTuY/uFvJl5GLAOaVV+t6Qw3kEQdA19avxoBEnbSXpQ0vRcLKa/+zaTNFfSJwbrc0jiGtvXAdfVaV+t6vWFwIV17pkBJdiaLSHhvgiCYigyeiRrW04ihUXPACZJmmj7r3Xu+wlwZSP9tmKlHQRBUErmqvGjASYA020/Yns2cC6pQEwtXyUtdGfWubYAzRT23UjSbdnNMVnShNy+jaQpubDvFElbVfVxhaR7JN0n6ZT8DRMEQdAV9A3hkLR3tn2VY++a7lYEnqw6n5Hb3kTSisDHgFManWMzisijge/bvjxHlhwNbAnMAna0/bSk9UhL/spEP2X7JaWQkwtIRYDPHcIcgg4Q0SnBSGEo0SPVUW79UG89XjvEccC3cuBGQ+M2o4g08wz40sDTALbvqnrrfcBikha1/XolVjuPu0idDxAMgzCqQVAMBcvYZwArV52vRLaTVWwKnJsN9tuAHSTNsf2H/jptprDvgcCVko4huVk2r/O+XYC7bL9eaZB0JcnXczlptR00SRjVICiGgkP+JgFrSlodeArYjVSO8U1sr155LenXwJ8GMtjQgE+7WhFZc2lfUqX1lYGDgP+ted+6pB3RL9dM8iPA8sCiwFbUodpX1Nf36mBTDIIgKISh+LQHw/YcYH+Si/h+4Dzb90naR9I+w53joJVrJP0Y+Bwwh3mKyItIuUPG2Xb2Ub9oe2x+z0rAX4Av2L65n373BDazvf9A44ciMgiCRmm2cs3/rPzZhu3NV578bUdCmAddads+1PZKORZ7N+Avtj9L8s18MN+2FfAQvJkM6lLg0GqDLWnJXLW9kn9kB+CB4j5KEARBcxS50m4VzVSu+RJwfDbA/yYneCI9DrwDOFzS4bltW9JO6kRJiwKjSSvxhsNcgv6JjcggKIYyPNYPWxFp+yZgkzr3HAkc2U8Xmw1tekEQBO2jZ4ogBEEQjATKkDCq0Tjtx4CXSTnC59jeVNIngSOAdwETbE/O9y4C/JIUf9gHHJBX6NX9TQTWsL1eMR8jKDNRBCHoFnqiCEIVH7I9q+p8GvBxkoGu5ksAtteXtCxwuaTNbPcBSPo48EoTcw5qKLtBKvv8g96hp90jtu8HqCO9XAe4Jt8zU9I/SavuOyQtSVJU7g2cN9yxg/mJjcggKIaecY+QNlX/LMnAL7Pmvj/uAXaWdC5JwrlJ/vcO4IfAz4DXhj/loJYwqkFQDL0UPfK+nABqWeAqSQ/YvqGfe08n+bknA48DtwBzJG0EvMP2QZJWa3LeQRAEhdNXArPdkNG2XUkGNVPSxaTcIXWNdpZuHlQ5l3QLSXjzQWCTvKm5ELCspOtsb1nbRxT2DYKgE5TBPdJI7pElJC1VeU0Sykwb4P4x+T4kbUOKNvmr7ZNtr5CVlVsAf6tnsCGlPLS9qe1Nw2AHQdAu5g7h6BSNrLSXAy7OG44LAb+zfYWkjwEnAOOBSyXdnZNBLUvK/tdHymz1udZMPQiCoFh6InrE9iPAhnXaLwYurtP+GLD2IH0+BkSMdhAEXUXP+LSDkU2EFAYjhe432WG0gwYIoxqMFMqwEdmMjP0IkvrxuXzbt21flu/fgKSUHEv6OWxm+9+SriMVQPhXfs+2thuqQBwEQdBqes09UitjBzjW9jHVDTlV62+Bz9m+R9JbgTeqbvlMJU9JEARBN9FruUcaZVtgqu17AGw/34IxgiAICqcMK+1B47QzFRn7lCx8qbC/pKmSTpe0TG5bC7CkKyXdKembNX2dIeluSYer0ZrxQRAEbcBDODrFsGXswMmkXCJmXk6RvXKfW5AKHrwGXCNpiu1rSK6Rp7JY50JSDPdZtYOFInJolD26I1KzBt1Cz2xE1pOxV+cekfQr4E/5dAZwfcX/LekyYGPgGttP5X5elvQ7khx+AaOdE1KdClHYdyQQBjXoFlwC98igRjtL0kdlQ1uRsf9A0vK2n8m3fYx50vYrgW9KGgPMJuUcOTZvUI6zPUvSwsB/A1cX/HlGJGH0gqAY5vSC0aZ/GftvcuY+A48BXwaw/Q9JPwcm5WuX2b40G/wrs8EeTTLYvyr48wRBEAyb7jfZzcnY+80pYvu3pLC/6rZXqVMIOGiesvu0g6BbKEP0SCgie4AwqkFQDD2zEdmPInJD4BRgSZJ75DO2X5I0gbyJCAg4IieXqhT9PRHYkvTzOcz2hYV9mhFKrLSDoBh6YiOyilpF5GnA121fL2kv4BvA4aQNyU1tz5G0PHCPpEtycYTDgJm215I0CnhLQZ8jCIKgaXpmpd0PazOves1VpKiRw21X139cjPl9+3sB7wTI1dlrZfHBMIiVcBAUw9wSrLSbUUROA3bKrz9JKt4LgKT3SLoPuBfYJ6+6x+XLP8xKyfMlLdf8RwiCICiGPrvho1M0o4jcC/iFpO8CE0kx2QDYvh1YV9K7gDMlXZ7HWgm42fbBkg4GjqFOZZtQRA6N8GkHQTF0/zq7wZV2tSKSVK1mgu0HbG9rexPgHODhOu+7H3iVVKXmeZKsvVLt5nySUrLeeFEjMgiCttOHGz46RTOKyGWzrH0U8B1SJAmSVgeezC6RVUm+78dsW9IlpMiRvwBbA39tyacaYZR9JRy5R4JuoVeiR/pTRB4gab98z0XAGfn1FsAhkt4gbcZ+pSrq5FvAbyQdRyqe8IViPkbQSsL9EowUyhA9InfQod4IkTBqcMKoBkFizuynmkr3/IlVd2rY3lzw+MSOpJYORWQPUPbUqfGlEHQLRa+0JW0HHE/Kt3Sa7aNqrn+G5IEAeAXYt1JApj8aVUSOI4lp1iNtsO4F7ADsTPqcM4HPVzYsJR0KfJGkoPya7Stz++7At3MfTwOfrVPCLOgywqgGI4UiPQ+SRgMnAduQUlZPkjTRdvVe3qPAB3Oive1JavL3DNRvo3HaxwNX2H4nKXnU/cBPbW9geyNSLu3v5omuA+wGrAtsB/yPpNE5NevxJGXlBsBUYP8Gxw+CIGg5BUePTACm237E9mzgXNJC901s32L7H/n0NlJY9IA0Ej0yFvgA8Pk8yGyqYrIzSzAvxHFn4FzbrwOPSpqeJz+ZlItkCUnPkyq1Tx9s/GBwwn0RBMUwFPdItZ4kc2ou4FJhReDJqvMZDLyK/iJw+WDjNuIeWYMU6XFGThI1BTjA9quSfgTsAbwIfKhqorfVTHRF27dK2pekknwVeAjYj6BpwqgGQTHMHYLZrq6w1Q/1NirrLtElfYhktLcYbNxG3CMLkUQwJ9t+N8ngHgJg+zDbKwNnM8/VUXeiufjBvsC7gRVI7pFDGxg/CIKgLdhu+GiAGVSl9yC5Pp6uvUnSBqQ9w51tPz9Yp40Y7RnAjCxNB7iABZWMvwN2GWSiGwHYftjpE58HbF5vQEl7S5osaXJf36sNTDEIgqB5+oZwNMAkYE1Jq+e01LuRUn68iaRVSDqXz9n+WyOdNlK55u+SnpS0tu0HyUpGSWvafijfthPwQH49EfhdLjm2ArAmcAdJpLOOpPG2nyPtqN7fz5hR2HcIhE87CIqhSEVkVoXvT8qAOho43fZ9kvbJ108hBXC8lRSwAblewUD9NiSuybUgTwMWAR4hKRlPI0nU+4DHSdn8nsr3H0YKC5wDHGj78ty+D3AA8EZ+z+cHexwIox0EQaM0K6758MofadjeXP3klR0R14QiMgiCnqFZo731Sts2bG+umfHnUEQGwyPcI0FQDEOJHukUYbSDIAgynSxu0CgNKSIljZN0gaQHJN0v6T9z+1clPSjpPklH57aFJZ0p6d5876FV/WyS26dL+oWy5z0IgqAb8BCOTtHoSrsiY/9EDl0Zk4PBdwY2sP16rmoDqfTYorbXlzSGFGlyju3HgJNJCqLbgMtIMvdBFUBBEATtoJPFDRpl2DL2rG48KsvVK1VtIH0JLZFzjSxOkry/lCuzj7V9a+73LOCjhNFumsjyFwTF0BNGm35k7MBawPuzlP3fwNdtTyKJb3YGngHGAAfZfkHSpiThTYUZJMl70CRhVIOgGOa6NzYiKzL2r9q+XdLxJBn7QsAywHuBzYDzJK1BSg41lySsWQa4UdLVDE2HH4V9h0AY1SAohjKUG2tGxj4DuMiJO0gim7cBnyb5v9/ILpObgcoquzrtYF0dPkRh3yAIOkPBuUdawqBG2/bfgSclrZ2bKgV5/wBsBSBpLZJachbwBLCVEkuQVuIP2H4GeFnSe3PUyB7AHwv+PEEQBMOmJ6qxZ74KnJ0jRyoy9leB0yVNI2027pkrrp9EKvI7jeQSOcP21NzPvsCvSRuUlxObkIUQPu0gKIZuV4hDyNiDIOghmpWxb/gfmzdsb+75+y0hYw+GR6y0g6AYeiJ6JPuyf1/VtAYpneBZuX014DHgU7k45WqklKsP5vtvs71P7qtS6WYZ20sW8xGCiNMOgmIoQ/TIkNwjubrwU6Q6Z/sBL9g+StIhJEP8rWy0/2R7vTrvfy8pJetDjRrtcI8EQdAozbpH3rXshIbtzf0z7yiFe2Rr4GHbj0vaGdgyt58JXAd8a6A3274NIFKOFEushIOgGMqw0h6q0d4NOCe/Xi6H8WH7marcIwCrS7oLeAn4ju3WWpURThjVICiGMmT5a9ho53C/nRi8GO8zwCq2n5e0CfAHSevafmkIY4UicgTR6icFiC+2oDF6baW9PXCn7Wfz+bOSls+r7OWBmQA5gVQlidQUSQ+T8pRMbnSgqBE5sgiDGnQLZYgeaSifdmZ35rlGIBXw3TO/3pOsbpQ0Pm9YknORrEkS5ARBEHQ1dl/DR6dotAjCGFL19Iuqmo8CtpH0UL52VG7/ADBV0j2kPCX72H4h93O0pBmkfNwzJB1RzMcIgiBonjLI2EMR2QOUPXokfNpBUTQb8rfKW9Zv2N488cK9pQj5C4LCCYMadAs9UQShP0Wk7ePy9a8DPwXG254lqeIqWYSUSOobtv+SXSznA28n5du+xPYhRX6YkUoYvSAohrl93b8ROajRtv0gsBHMp4i8OJ+vTPJnP1H1llnAjraflrQecCXzKtQcY/vaHD54jaTtbUemvyYpu3skCLqFXgv5gypFZD4/FvgmVXmxbd9Vdf99wGKSFrX9GnBtvme2pDuZvyhCMEzK7nOOL4WgW+j2PT5oQhEpaSfgKdv3DCBL3wW4q1L8t4KkccCOpCrvQZcTRjUYKfSET7tCtSIy+6cPA7Yd4P51gZ/U3pOrtJ8D/MJ2xG8XQKyEg6AYem2l/aYiUtL6wOpAZZW9EnCnpAm2/y5pJZLfew/bD9f0cyopy99x/Q0UMvahEUY1CIqhp3KPUKWItH0v8GaCKEmPAZvm6JFxwKXAobZvru5A0pHA0sD/GWigkLEPjXbEObeS+NIJuoUyyNgbEtdkd8iTwBq2X6xz/THmGe3vkJJKPVR1y7akEMAngQfIuUmAE22fNtDYYbSDIGiUZsU1Y5dYo2F789Krj3REXBOKyB4gfNpBkGjWaC85ZvWG7c0rrz0aishgeIRRDYJi6MU47SAIgp6l1zYigy4l3CNBUAzd7i6GMNo9QRjVICiGvoKjRyRtRxIRjgZOs31UzXXl6zsArwGft33nQH2G0e4BYqUdBMVQ5Eo752o6iZSfaQYwSdJE23+tum17UqGYNYH3ACfnf/sljHYPEEY1CIqhYOfIBGB6Rfkt6VxgZ6DaaO8MnOX0bXGbpHGVMo79ddr1RnuoITyS9s7inJbQ6v7bMUbZ+2/HGGXvvx1jlL3/egzF3lQrtzOn1sx3RZI2pcIMFlxF17tnRVKB9LoMpUZkWdh78Fu6uv92jFH2/tsxRtn7b8cYZe+/KWyfanvTqqP2C6beF0DtYr6Re+ajF412EARBNzADWLnqfCXg6WHcMx9htIMgCFrDJGBNSavnLKm7ARNr7pkI7KHEe4EXB/JnQwl82sOg1T6wdvjYyv4Z4mfU+f7bMUbZ+28ptudI2p9UvWs0cLrt+yTtk6+fAlxGCvebTgr5+8Jg/XZ97pEgCIJgHuEeCYIgKBFhtIMgCEpEGO0gCBpG0uKS1u70PEYyYbQbIMtRW9X3WpKukTQtn2+QC0kUOYYkrTz4nd2LpLd0eg4jHUk7AncDV+TzjSTVRkMELabUG5GD/Ue2/UJB4zwKXACcUZM3oIi+rwe+AfzS9rtz2zTb6xU8zhTbmxTZZ03/19jeerC2Jvp/iGQwzgAud4v+cCWtCqxp+2pJiwML2X65oL4/Xqf5ReBe2zMLGmM88CVgNaqiw2zvVUDfU4CtgOuq/lan2t6g2b5rxhkNLMf883+iyDHKTNlD/qaQ1EMCVgH+kV+PA54gFR8ugg1IMZanSRoFnA6ca/ulAvoeY/uOXCC5wpwC+q3lNkmb2Z5UZKeSFgPGAG+TtAzzFF5jgRUKHGot4MPAXsAJkn4P/Nr234oaQNKXSCq8twBvJwkdTgEK+eIBvgj8J3BtPt8SuA1YS9IPbP+mgDH+CNwIXA3MLaC/aubYfrHmb7VQJH0V+B7wLFBJuWfS/8EAUlarsh+k/1g7VJ1vD/ysRWN9AHgKeBU4E3hHk/1dTjIQd+bzT5BWkkXP+6+kL4OHganAvcDUAvo9AHiUVPfzkfz6UeAeYP8W/Q4+lH8H/wSuB/6zoH7vJtUyvauq7d4C530JsFzV+XLARaQviWlFfYZW/Mxz3/8LfDr//awJnACcUvAY04G3tuoz9MLR8QkU9IueUqdtcoH9jwZ2Ai4G7gIOzv/hPgH8rcm+1yCtil7LhugmYLUW/IxWrXcU2P9XW/w7fmv+gpgMXAp8nPSkuCnwaEFj3J7/vSv/u1ARX2xV/d9bc66Ksa7+omhyjCOrFzAF/w7GAD8iKf0m59eLFTzGtSSXVMv+lsp+lN09UqFSBf63pEepzwLPF9j/Q6Q/pp/avqWq/QJJH2imY6e0jR+WtAQwygX5T+uM87ikDYFKHtcbbd9T4BB/l7SU7Zfz72Jj4EgPktB9CNwK/Ab4qO0ZVe2TJZ1S0BjXS/o2sLikbYCvkFbHRXGjpD8B5+fzXYAb8u/+nwWNcQDwbUmzgTdym22PbbZj268Bh0n6Se6zFX+rjwDXSbqU9PRWGfvnLRirlJR6I7JC3pD8Hsl1AXAD8H0XsBGZN0UOs/2DZvuq6ffgga4X/Ucq6QDSBtVFueljpFSSJxTU/1TbG0jaAvgxcAzwbdsDJnRvsO/RpC/MAX9mBYwziuR33pa0Cr7S9q8K7F8kQ/2+3P9NwIUuyX9CSZuR9nOWyk0vAnvZnlLgGN+r1277+0WNUXZ6wmi3GknX2v5QwX3W/ePMuAVfElNJvt9X8/kSwK0uaOdf0l223y3pxyQ3wO8qbQX1X1gkygBjHGD7+MHauh1JOzFvAXOd7T8V1O9UYD/bN+bzLYD/KepvqGaspUj/D14puu+yU2r3iKRLGCD3rO2dChrqFkknAr8nbUBW+h/2o39l5SDpfbZvrr4m6X3D7XcAxPzRBHOpn8t3uDwl6ZekCI+fSFqUYnUAd+eY4POZ/3dwUf9vGTJ7kur1VfP5Om3DIof8/QRYlvSzFwW5LqrGOArYDDg7Nx0gaQvbhxTQ/csVgw1g+yZJhbpIJK1HcoO9JZ/PAvawfV+R45SZUq+0JX1woOu2ry9onGvrNNv2VgX0faftjQdrK2Ccg0lG6eLc9FHgTNvHFtT/GGA70ir7IUnLA+vb/nNB/Z9Rp9kuJv54d1JUxBakcLkKSwFzbX+42THyONOBHW3fX0R//YwxFdjIThVqs2vpriJWw5KOJW1GnkNaLO1KCrO9EJpbxFSNcQvJHXltPt8S+H+2N2+2716h1CvtRo2ypAtt79LEOIW6RgAk/SewOTC+xr89lhStUii2fy7pOpJhEvAF23cV2P9rwEWSlpW0Sm5+oKj+SZWsW/VEcgupvNPbgJ9Vtb9MCm8rimdbabCrGAdU9nOWLrDfjfK/ta69zUlGvOlFDLBExWAD2L4uu/KCTKmN9hBYo5k3S1qa+Tc6rwd+YPvFJrpdBFiS9DtYqqr9JVIoYaFI+o3tzwF31mkrov+dSAZvBWAmSez0ALBuEf2TYoJrnz7qtQ0Z248Dj5OEL61kchYF/YH5IyOKdPH8GLgrPx2K9Dd7aEF9f9h20YKdWh6RdDjJRQIpEuzRFo9ZKkrtHmmUZt0Nki4EppHENACfAza0XU+WPNS+V81Go6XU/gzyY/O9ttcpqP97SCutq/OG5IeA3W03Veev6onkQKDalTMW+JjtDZvpv2as95K+CN5F+lIdDbxalM+5lS6emnGWJ/m1RYo9/3tB/VbSOZzeqieGrKr9PvOeCG8AjrD9j1aMV0ZGykq7Wd5e4175vqS7m+lQ0om29wdOlLTAN2dRm6iSDgUqsccV2b2A2RRbGeQN289LGiVplO1rczxvs7TzieREUrqC80minT2AdxTVue1Bq5IMF0nvtP2ApMoXcyWWfQVJKxQUL19J5/C/LUjnAEA2zl8rqr9eZKSstJsKPZN0K/AN2zfl8/cBx9ge9uO0pJdsj+1vM7WoTdSq8X5su6jH5Hr9X03a3PwxyTc8E9isqA2kdjyRSJpse1NVJUGSdEuzn0HSN20fLekE6kQ72W7aSEk61fberdg0l7SQ7Tk1bR8gbUiOI62+f2h7ehNjHGf7wP4iwgqMBCs9PbHSlrQVcFveDKvHt5ocYl/gzOzbFmmT5/NN9vkwFG+cB+AOSUtX/PCSxgFb2v5DM51KegdJ0r8z8C/gIOAzJJn8V5vpu4ZFJZ3Kgtnritj8qvCaUgHWuyUdTdqcLGITrOJKmFxAX3WpckNtb/vf1deUkno1wx3Axtml9l+kpF2rkvYwziapbC8jJfUaLhUf9jFN9DEi6ImVtqSzgPeSpOs35uOmov1gksYCFPE4KGkG0K/q0cUrIu+2vVFNW9PiFyVZ9rdtT61p3xT4nu0dm+m/qr97SInBplAVb+5i1XirkrLLLUL68lmaJB4Z9gqypv9P2j5/sLYmxyg8hLTyfkmPkNI5nGb71pp7flHQE8MB7gGBUyvpCaNdQdIKJD/n14EVbBfyJKH6kvMXSYmq7h5mn88AJ9OPwMUFy3ZVJ++xpHttr99kv/3m/i6i/6q+WpoPvGqc8QC2n2tB3y2LyZf0H8CKpPw7n4b5UuSeYvudTfRdWWCMIT1NzWc0ilxg9PMzanpx0Uv0invks6RHtPWBWaQNpRsHfNPQ2DQfleRB/0XKdLaPpPNtHz2MPp9xwVL1QZgs6efASaT/dF8lrVqbZaBH78UL6L/CJZK+QhIHVYfLFZFfRqSQzv1Jxm6UpDnACUX8jiRtD+wArCjpF1WXxlJc7vSPkFx2KzH/E9zLpI3oZhhN2gxW/rdwqgROq2v+ajhLUWzyt9LTEyttJanrw6TH52ttP1Zw/1cCuzjnQZC0JGnz5WOk1faQw+bavXrIAoXDSTJzgD8DP3LORdJEv+cAf3FNYiVJXwS2tb1rM/1X9VcvVte2m4rBz30fRDKqe9t+NLetQXoSusJNqkaVsituBPwA+G7VpZdJf6+FufEk7WL7wqL6y30WrtCtM8aqpKIlPwaqJfcvk9LjtqIwSCnpCaMNIGldkpBgC1KC9gcLFI7cT4rLnp3PFyUlm3/XcI2vpLcUsUocxrhLusAkPJKWI61+ZzNv5b4pyS/8saJihFuJpLuAbWzPqmkfD/y5qC9XSQvbfmPwO5se579IoqY3n4KaeWLowALjP4AJpCfCSWX4G2onveIeGUtS4K1Kii5Ymnmliorgd6RyXX/M5zsC5+TV67BqRrbbYEvaHDiN9Hi7Sl79fdn2V5rp1/azwOZZTFPxbV9q+y9NTbgGSXv0M/5ZBXS/cK3Bzn0/J2nhAvqvsJpSFsR1mN+gNv20UEEpt/gY4EOk3/cnSNEfzdDS7IrV5Ce07wF/IbljTlAqxXZ6u+bQ7fTESlspSc5N+bjB8yfJL2qMTZin0rrJdsvCt1qBpNtJ/4EnuoUFhFtFjnGusBjJkNxpu2mBzUCP/0W6BiTdRDJIx5K++L9A+j84UJreoY5RyWte+XdJ4CLb2xY1RiuR9CCwue3n8/lbgVtsr93ZmXUPPbHSrhJCLMUAqVqbZHHgJdtnSBovafWK/7Ms2H5S8xdlbXUeicKwPV/Md46ZL6IQLsCGmqcWnW8YBt5oHSqL275GkpyEQkdIupEFEzA1QyVG+7UcTfU8xRW4bgczSH7sCi8DT3ZoLl1JTxhtzZ+DV5KeA/a0Pa2g/r9H8tOuDZwBLEwKrWpF3utW8WR2kTgLSL7GPNFHGXmNtHfRNLYbyqooaZkmNw3/rST/fkjS/qSaoMs20V89LsnCqZ+SkoMZKKz6Tht4Crg9uyJNEm3dUQm7LVq/UEZ6wmiTcmgc7Plz8J5KSjRUBB8D3k3OkGf76byqLxP7kJL5r0hazfwZ2K+jMxoCml/ePJqU1Om8Nk/jGprLKnggyd/8NeCHpARbdX31wyF/IVxj+5/AhVn4tJiby0bZbh7OR4XKPlLZ/r+1jF4x2q3OwTvbtpUTOxXcd8vJ8uPjbH+m03Npgmp58xzg8VbsXQxCU5V+bE/KL18BviBpIVIhgdubnVjuv0/Sz8gpZm2/TlVMexkoWlTWixRZDqqTPCLpcEmr5eM7FJuD9zylUlrjJH0JuJq0M18KnHIgj89ukVLilKPlAdKKaxlSiGHbpzGcN0kaK+lQSSdK2laJ/YHpwKeKnSJ/lrSLajYvuh1Jx+V/L5E0sfbo8PS6il6JHml5Dl5J2zB/le6riuq7HeQvnY2BicxfY7EUPkJJnyL5aa8j/Q7eT8q8eEEb5zCsSJLsn/0HcCsp6mUZUhz7AcNNgzDAWC+TklzNIW1KFl6HshVI2sT2FLUp62WZ6Qmj3Wok/cT2twZr62bUT/X3sjyOKiWM2sb2zHw+nlRwobAiCA3MYbhCqjdzsGRX1SxgFduFFsUtO/lnc6btz3Z6Lt1MT/i0Ja1FShK1Gq1J27kNC6Z33b5OW9dSFuM8AKMqBjvzPC1w70naAlizEtoJLFkV2jlckcmbKkjbcyU92iqDrZTnegFs39CK8Yok/2zGS1qkoj4OFqQnjDap0sgpJD9zYbHHkvYFvgKskQU8FZYCbq7/ru5CvZNc/gqlHDDn5PNdSTmcC2Ow0M4mVKzVceBiXhWhVrguvlH1ejGSHHwKxRTdbQePATdnP3bp3HjtoFeM9hzbJ7eg398Bl1MniU0n8oYMk1Inl1cusmD7G5I+zrx9i1tJCfiLpCWhnY3GgReBa/KXS1oZGE4Wyk7xdD5GEWF+dSm1T1vSW/LLr5HKWxWetrNmvGWZP2fEE0X232rUwlzRrUJtKrKQ+7zD9gTNS/q/BHCra/KQl4kcRTLVBeU1DzpP2VfaU0iP/JXwpq/XXC8kEY+kHUk5ilcgfTmsSlITrltE/60k/6dtWa7oNrBarcEGsD1Z0moFj1Ub2rkX5VITVnK0VFZio0gpYe/p2ISGiKSrgE9mgVAlMuxc2x/p6MS6iLIb7V2BJ20/AyBpT2AXkl/siALHOZJUzuxq2+9Wymi3e4H9t5IDST7ZzVyTK1rSQW4yV3QbaFeRBWwfk0M7XyL5tb9bttBO5q9DOQc4x3Yp9l8y4ysGG1J19vyEG2TKLq45hewOybvmPwbOJJUCO7XAcd7IWcdGSRqV1ZcbFdh/K9kD2L06uZXtR4DPUqCEuoVMyqve+VBK4VlYfcjc5xKkgg7fIK2wF1exqVlbju0zSRu0l9k+u2QGG2CupFUqJ0rFEcrrw20BZV9pj67yW+8KnOpUteNCSXcXOM4/lVJc3gCcLWkmxZWJajXtyhXdKg4ELpb0GeoUWSh4rBuA9+dH8qtJq9ZdSdXlu5oecINVOAy4SVJFTPMBYO8B7h9xlN5oS1rIqRTR1sz/y236s1UiF0iZxv5FqtD9GZJP+6sDvLWbGCjetetjYd2mIgsZ2X4tr+JPsH20UlWbMnAg5XaDAWD7Ckkbk9yRAg6qt+gYyZQ9euQwUm2/WaTKNRvnxE7vICmrmkqd2s7IhVYhaS5V8a7Vl0gZ4Mqw2m4L2UB/hVSk4Iu271OBFeVbidpUMq3VSHofqZTfq0oFuzcGjs/5xwNKvtK2/SNJ1wDLk/4wq3fNi1gJtzNyoSW0M0a4BzgAOBS4OBvsNYBrB3lPt1B2N1iFk0lipA1JQqHTgbOAujlJRiKlNtoAtm+r0/a3grpvW+RC0Hmy1PuGqvNHSBqAMlBqN1gVc/LT8s7AL2z/b44KCzKlN9otZpKkL9meL1a3FZELQefJroRvsmAl8zJIwNtVMq3VvCzpUOBzpE3h0aR0AkGm1D7tViNpOZLKcjZ1Ihds/71TcwuKR9Kfgd+TRFr7AHsCz5Upm2PZkfQfwKeBSbZvzOF/W9o+q8NT6xrCaDdATeTCfS2KXAg6jKQptjdRrmSe2663Hf7UNpJjs9e0fbWkMaTQ3khjmwn3SANkMU1ZNqSC4VNJofqMpP8iJS5aqYPzGXFkIdXepCLdbyfVND2F4afF7TnCaAfBPI6UtDTwf4ETgLGk2PygfexHSid7O4Dth0LGPj9htIMgY/tP+eWLwIc6OZcRzOu2ZyuXuFQqfhw+3CrKnnskCApD0lqSrpE0LZ9voFQkOmgf10v6NinvyzakAieXdHhOXUVsRAZBJue7+Abwy4qCUNI02+sN/M6gKCSNAr5IVRFt4DSHoXqTcI8EwTzG2L6j8mieKUtisJ7Adp+kPwB/KFOxjnYS7pEgmMcsSW8n+1AlfQJ4prNTGhkocYSkWcADwIOSnpP03U7PrdsIox0E89gP+CXwTklPkTLn7dvRGY0cDmRelsK32n4L8B7gfZIigqeK8GkHQQ25GMKoEHS0j17JUtgOwqcdjHgkHdxPOwC2f97WCY1MeiVLYcsJox0EsFSnJxD0TJbClhPukSAIOk4U62ic2IgMgkyIazqH7dG2x9Y5lgqDPT9htINgHr8iVa55AyBXLdqtozMKghrCaAfBPMbYvqOmLcQ1QVcRRjsI5hHimqDriY3IIMjkQr6nApsD/wAeBT4TlcCDbiKMdhDUUBHXAP8CdrV9doenFARvEu6RYMQjaaykQyWdmNOBvkaqDzkd+FRnZxcE8xMr7WDEI+mPJHfIraSyVsuQijcfYPvuDk4tCBYgjHYw4pF0r+318+vRwCxglcg9EnQj4R4JgnkFfbE9F3g0DHbQrcRKOxjx1EioBSxO8msLsO2xnZpbENQSRjsIgqBEhHskCIKgRITRDoIgKBFhtIMgCEpEGO0gCIIS8f8BB3otFUCOlDsAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 2 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "sns.heatmap(data.isnull())     "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d16874d4",
   "metadata": {},
   "source": [
    "# Q.1. For 'House of Cards', what is the Show Id and Who is the Director of this show ?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "8eea2a78",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Show_Id</th>\n",
       "      <th>Category</th>\n",
       "      <th>Title</th>\n",
       "      <th>Director</th>\n",
       "      <th>Cast</th>\n",
       "      <th>Country</th>\n",
       "      <th>Release_Date</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Duration</th>\n",
       "      <th>Type</th>\n",
       "      <th>Description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2832</th>\n",
       "      <td>s2833</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>House of Cards</td>\n",
       "      <td>Robin Wright, David Fincher, Gerald McRaney, J...</td>\n",
       "      <td>Kevin Spacey, Robin Wright, Kate Mara, Corey S...</td>\n",
       "      <td>United States</td>\n",
       "      <td>November 2, 2018</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>6 Seasons</td>\n",
       "      <td>TV Dramas, TV Thrillers</td>\n",
       "      <td>A ruthless politician will stop at nothing to ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Show_Id Category           Title  \\\n",
       "2832   s2833  TV Show  House of Cards   \n",
       "\n",
       "                                               Director  \\\n",
       "2832  Robin Wright, David Fincher, Gerald McRaney, J...   \n",
       "\n",
       "                                                   Cast        Country  \\\n",
       "2832  Kevin Spacey, Robin Wright, Kate Mara, Corey S...  United States   \n",
       "\n",
       "          Release_Date Rating   Duration                     Type  \\\n",
       "2832  November 2, 2018  TV-MA  6 Seasons  TV Dramas, TV Thrillers   \n",
       "\n",
       "                                            Description  \n",
       "2832  A ruthless politician will stop at nothing to ...  "
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data['Title'].isin(['House of Cards'])]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "9c9fe0b4",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Show_Id</th>\n",
       "      <th>Category</th>\n",
       "      <th>Title</th>\n",
       "      <th>Director</th>\n",
       "      <th>Cast</th>\n",
       "      <th>Country</th>\n",
       "      <th>Release_Date</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Duration</th>\n",
       "      <th>Type</th>\n",
       "      <th>Description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2832</th>\n",
       "      <td>s2833</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>House of Cards</td>\n",
       "      <td>Robin Wright, David Fincher, Gerald McRaney, J...</td>\n",
       "      <td>Kevin Spacey, Robin Wright, Kate Mara, Corey S...</td>\n",
       "      <td>United States</td>\n",
       "      <td>November 2, 2018</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>6 Seasons</td>\n",
       "      <td>TV Dramas, TV Thrillers</td>\n",
       "      <td>A ruthless politician will stop at nothing to ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Show_Id Category           Title  \\\n",
       "2832   s2833  TV Show  House of Cards   \n",
       "\n",
       "                                               Director  \\\n",
       "2832  Robin Wright, David Fincher, Gerald McRaney, J...   \n",
       "\n",
       "                                                   Cast        Country  \\\n",
       "2832  Kevin Spacey, Robin Wright, Kate Mara, Corey S...  United States   \n",
       "\n",
       "          Release_Date Rating   Duration                     Type  \\\n",
       "2832  November 2, 2018  TV-MA  6 Seasons  TV Dramas, TV Thrillers   \n",
       "\n",
       "                                            Description  \n",
       "2832  A ruthless politician will stop at nothing to ...  "
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data['Title'].str.contains('House of Cards')]  "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9703e56c",
   "metadata": {},
   "source": [
    "# Q.2. In which year highest number of the TV Shows & Movies were released ? Show with Bar Graph."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "ce550dad",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Show_Id         object\n",
       "Category        object\n",
       "Title           object\n",
       "Director        object\n",
       "Cast            object\n",
       "Country         object\n",
       "Release_Date    object\n",
       "Rating          object\n",
       "Duration        object\n",
       "Type            object\n",
       "Description     object\n",
       "dtype: object"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "9bded858",
   "metadata": {},
   "outputs": [],
   "source": [
    "data['Date_N'] = pd.to_datetime(data['Release_Date'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "db174c6e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Show_Id</th>\n",
       "      <th>Category</th>\n",
       "      <th>Title</th>\n",
       "      <th>Director</th>\n",
       "      <th>Cast</th>\n",
       "      <th>Country</th>\n",
       "      <th>Release_Date</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Duration</th>\n",
       "      <th>Type</th>\n",
       "      <th>Description</th>\n",
       "      <th>Date_N</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>s1</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>3%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>João Miguel, Bianca Comparato, Michel Gomes, R...</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>August 14, 2020</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>4 Seasons</td>\n",
       "      <td>International TV Shows, TV Dramas, TV Sci-Fi &amp;...</td>\n",
       "      <td>In a future where the elite inhabit an island ...</td>\n",
       "      <td>2020-08-14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>s2</td>\n",
       "      <td>Movie</td>\n",
       "      <td>07:19</td>\n",
       "      <td>Jorge Michel Grau</td>\n",
       "      <td>Demián Bichir, Héctor Bonilla, Oscar Serrano, ...</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>December 23, 2016</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>93 min</td>\n",
       "      <td>Dramas, International Movies</td>\n",
       "      <td>After a devastating earthquake hits Mexico Cit...</td>\n",
       "      <td>2016-12-23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>s3</td>\n",
       "      <td>Movie</td>\n",
       "      <td>23:59</td>\n",
       "      <td>Gilbert Chan</td>\n",
       "      <td>Tedd Chan, Stella Chung, Henley Hii, Lawrence ...</td>\n",
       "      <td>Singapore</td>\n",
       "      <td>December 20, 2018</td>\n",
       "      <td>R</td>\n",
       "      <td>78 min</td>\n",
       "      <td>Horror Movies, International Movies</td>\n",
       "      <td>When an army recruit is found dead, his fellow...</td>\n",
       "      <td>2018-12-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>s4</td>\n",
       "      <td>Movie</td>\n",
       "      <td>9</td>\n",
       "      <td>Shane Acker</td>\n",
       "      <td>Elijah Wood, John C. Reilly, Jennifer Connelly...</td>\n",
       "      <td>United States</td>\n",
       "      <td>November 16, 2017</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>80 min</td>\n",
       "      <td>Action &amp; Adventure, Independent Movies, Sci-Fi...</td>\n",
       "      <td>In a postapocalyptic world, rag-doll robots hi...</td>\n",
       "      <td>2017-11-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>s5</td>\n",
       "      <td>Movie</td>\n",
       "      <td>21</td>\n",
       "      <td>Robert Luketic</td>\n",
       "      <td>Jim Sturgess, Kevin Spacey, Kate Bosworth, Aar...</td>\n",
       "      <td>United States</td>\n",
       "      <td>January 1, 2020</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>123 min</td>\n",
       "      <td>Dramas</td>\n",
       "      <td>A brilliant group of students become card-coun...</td>\n",
       "      <td>2020-01-01</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Show_Id Category  Title           Director  \\\n",
       "0      s1  TV Show     3%                NaN   \n",
       "1      s2    Movie  07:19  Jorge Michel Grau   \n",
       "2      s3    Movie  23:59       Gilbert Chan   \n",
       "3      s4    Movie      9        Shane Acker   \n",
       "4      s5    Movie     21     Robert Luketic   \n",
       "\n",
       "                                                Cast        Country  \\\n",
       "0  João Miguel, Bianca Comparato, Michel Gomes, R...         Brazil   \n",
       "1  Demián Bichir, Héctor Bonilla, Oscar Serrano, ...         Mexico   \n",
       "2  Tedd Chan, Stella Chung, Henley Hii, Lawrence ...      Singapore   \n",
       "3  Elijah Wood, John C. Reilly, Jennifer Connelly...  United States   \n",
       "4  Jim Sturgess, Kevin Spacey, Kate Bosworth, Aar...  United States   \n",
       "\n",
       "        Release_Date Rating   Duration  \\\n",
       "0    August 14, 2020  TV-MA  4 Seasons   \n",
       "1  December 23, 2016  TV-MA     93 min   \n",
       "2  December 20, 2018      R     78 min   \n",
       "3  November 16, 2017  PG-13     80 min   \n",
       "4    January 1, 2020  PG-13    123 min   \n",
       "\n",
       "                                                Type  \\\n",
       "0  International TV Shows, TV Dramas, TV Sci-Fi &...   \n",
       "1                       Dramas, International Movies   \n",
       "2                Horror Movies, International Movies   \n",
       "3  Action & Adventure, Independent Movies, Sci-Fi...   \n",
       "4                                             Dramas   \n",
       "\n",
       "                                         Description     Date_N  \n",
       "0  In a future where the elite inhabit an island ... 2020-08-14  \n",
       "1  After a devastating earthquake hits Mexico Cit... 2016-12-23  \n",
       "2  When an army recruit is found dead, his fellow... 2018-12-20  \n",
       "3  In a postapocalyptic world, rag-doll robots hi... 2017-11-16  \n",
       "4  A brilliant group of students become card-coun... 2020-01-01  "
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "6ea55aa0",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Show_Id                 object\n",
       "Category                object\n",
       "Title                   object\n",
       "Director                object\n",
       "Cast                    object\n",
       "Country                 object\n",
       "Release_Date            object\n",
       "Rating                  object\n",
       "Duration                object\n",
       "Type                    object\n",
       "Description             object\n",
       "Date_N          datetime64[ns]\n",
       "dtype: object"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "e91e6d7b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2019.0    2153\n",
       "2020.0    2009\n",
       "2018.0    1685\n",
       "2017.0    1225\n",
       "2016.0     443\n",
       "2021.0     117\n",
       "2015.0      88\n",
       "2014.0      25\n",
       "2011.0      13\n",
       "2013.0      11\n",
       "2012.0       3\n",
       "2008.0       2\n",
       "2009.0       2\n",
       "2010.0       1\n",
       "Name: Date_N, dtype: int64"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['Date_N'].dt.year.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "d6efcde7",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2019.0    2153\n",
       "2020.0    2009\n",
       "2018.0    1685\n",
       "2017.0    1225\n",
       "2016.0     443\n",
       "2021.0     117\n",
       "2015.0      88\n",
       "2014.0      25\n",
       "2011.0      13\n",
       "2013.0      11\n",
       "2012.0       3\n",
       "2008.0       2\n",
       "2009.0       2\n",
       "2010.0       1\n",
       "Name: Date_N, dtype: int64"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['Date_N'].dt.year.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "00d6f93d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:>"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAX0AAAERCAYAAACXT3dwAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjUuMSwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/YYfK9AAAACXBIWXMAAAsTAAALEwEAmpwYAAAS2ElEQVR4nO3dfbBcd13H8ffHBGqHUmlJWmoSm6pRaFGqxIqiYxkemqFq6ygYVKhaJg6UERlmbCoq+BDM6MhD1dapwNCOQikiNlpQOkVgdMBySyshLbXRpjRNaMOTVJRq6tc/9gR2bje5uXcfbk5/79fMzj3727Of88tJ7ifnnj27N1WFJKkN37DcE5AkzY6lL0kNsfQlqSGWviQ1xNKXpIasXO4JLGTVqlW1fv365Z6GJPXKLbfc8rmqWj1//Jgv/fXr1zM3N7fc05CkXklyz6hxT+9IUkMsfUlqiKUvSQ2x9CWpIZa+JDXE0pekhlj6ktQQS1+SGmLpS1JDjvl35B7O+q03LGr9PdvPn9JMJKk/PNKXpIZY+pLUEEtfkhpi6UtSQyx9SWqIpS9JDbH0Jakhlr4kNcTSl6SGWPqS1JAFSz/JuiT/kOSOJLuSvLIbPznJjUnu6r6eNPScy5LsTnJnkvOGxp+eZGf32OVJMp0/liRplKM50j8IvLqqngI8A7gkyZnAVuCmqtoA3NTdp3tsM3AWsAm4IsmKLutKYAuwobttmuCfRZK0gAU/cK2q9gP7u+UHk9wBrAEuAM7tVrsa+BBwaTd+bVU9BNydZDdwTpI9wIlV9VGAJNcAFwLvn9wfZ3L8QDdJj0aLOqefZD3wPcA/A6d2/yEc+o/hlG61NcC9Q0/b242t6Zbnj4/azpYkc0nmDhw4sJgpSpKO4KhLP8kJwHuAX6mqLx9p1RFjdYTxRw5WXVVVG6tq4+rVq492ipKkBRxV6Sd5DIPC/4uq+qtu+P4kp3WPnwY80I3vBdYNPX0tsK8bXztiXJI0I0dz9U6AtwJ3VNUbhh7aAVzULV8EXD80vjnJcUnOYPCC7c3dKaAHkzyjy3zJ0HMkSTNwNL8565nAi4GdSW7rxn4N2A5cl+Ri4DPACwCqaleS64DbGVz5c0lVPdw972XA24HjGbyAe0y+iCtJj1ZHc/XOPzL6fDzAsw/znG3AthHjc8BTFzNBSdLk+I5cSWqIpS9JDbH0Jakhlr4kNcTSl6SGWPqS1BBLX5IaYulLUkMsfUlqiKUvSQ2x9CWpIZa+JDXE0pekhlj6ktQQS1+SGmLpS1JDLH1JaoilL0kNsfQlqSGWviQ1xNKXpIZY+pLUEEtfkhpi6UtSQyx9SWrIyuWeQKvWb73hqNfds/38Kc5EUks80pekhlj6ktQQS1+SGmLpS1JDLH1JaoilL0kNsfQlqSGWviQ1xNKXpIZY+pLUEEtfkhpi6UtSQyx9SWrIgqWf5G1JHkjyqaGx1yW5L8lt3e35Q49dlmR3kjuTnDc0/vQkO7vHLk+Syf9xJElHcjRH+m8HNo0Yf2NVnd3d3geQ5ExgM3BW95wrkqzo1r8S2AJs6G6jMiVJU7Rg6VfVR4AvHGXeBcC1VfVQVd0N7AbOSXIacGJVfbSqCrgGuHCJc5YkLdE45/RfkeST3emfk7qxNcC9Q+vs7cbWdMvzx0dKsiXJXJK5AwcOjDFFSdKwpZb+lcC3AWcD+4E/7MZHnaevI4yPVFVXVdXGqtq4evXqJU5RkjTfkkq/qu6vqoer6v+APwPO6R7aC6wbWnUtsK8bXztiXJI0Q0sq/e4c/SE/ARy6smcHsDnJcUnOYPCC7c1VtR94MMkzuqt2XgJcP8a8JUlLsOAvRk/yTuBcYFWSvcBrgXOTnM3gFM0e4JcAqmpXkuuA24GDwCVV9XAX9TIGVwIdD7y/u0mSZmjB0q+qF40YfusR1t8GbBsxPgc8dVGzkyRNlO/IlaSGWPqS1BBLX5IaYulLUkMsfUlqiKUvSQ2x9CWpIZa+JDXE0pekhlj6ktQQS1+SGmLpS1JDLH1JaoilL0kNsfQlqSGWviQ1xNKXpIZY+pLUEEtfkhpi6UtSQyx9SWrIyuWegCZv/dYbFrX+nu3nT2kmko41HulLUkMsfUlqiKUvSQ2x9CWpIZa+JDXE0pekhlj6ktQQS1+SGmLpS1JDLH1JaoilL0kNsfQlqSGWviQ1xNKXpIZY+pLUEEtfkhpi6UtSQxYs/SRvS/JAkk8NjZ2c5MYkd3VfTxp67LIku5PcmeS8ofGnJ9nZPXZ5kkz+jyNJOpKjOdJ/O7Bp3thW4Kaq2gDc1N0nyZnAZuCs7jlXJFnRPedKYAuwobvNz5QkTdmCpV9VHwG+MG/4AuDqbvlq4MKh8Wur6qGquhvYDZyT5DTgxKr6aFUVcM3QcyRJM7LUc/qnVtV+gO7rKd34GuDeofX2dmNruuX54yMl2ZJkLsncgQMHljhFSdJ8k34hd9R5+jrC+EhVdVVVbayqjatXr57Y5CSpdUst/fu7UzZ0Xx/oxvcC64bWWwvs68bXjhiXJM3QUkt/B3BRt3wRcP3Q+OYkxyU5g8ELtjd3p4AeTPKM7qqdlww9R5I0IysXWiHJO4FzgVVJ9gKvBbYD1yW5GPgM8AKAqtqV5DrgduAgcElVPdxFvYzBlUDHA+/vbpKkGVqw9KvqRYd56NmHWX8bsG3E+Bzw1EXNTpI0Ub4jV5IaYulLUkMsfUlqiKUvSQ2x9CWpIZa+JDXE0pekhlj6ktQQS1+SGmLpS1JDLH1JaoilL0kNsfQlqSGWviQ1xNKXpIZY+pLUEEtfkhpi6UtSQyx9SWqIpS9JDbH0Jakhlr4kNcTSl6SGWPqS1BBLX5IaYulLUkMsfUlqiKUvSQ2x9CWpIZa+JDXE0pekhlj6ktQQS1+SGmLpS1JDLH1JaoilL0kNsfQlqSGWviQ1xNKXpIZY+pLUkLFKP8meJDuT3JZkrhs7OcmNSe7qvp40tP5lSXYnuTPJeeNOXpK0OJM40n9WVZ1dVRu7+1uBm6pqA3BTd58kZwKbgbOATcAVSVZMYPuSpKM0jdM7FwBXd8tXAxcOjV9bVQ9V1d3AbuCcKWxfknQY45Z+AR9IckuSLd3YqVW1H6D7eko3vga4d+i5e7uxR0iyJclckrkDBw6MOUVJ0iErx3z+M6tqX5JTgBuTfPoI62bEWI1asaquAq4C2Lhx48h1JEmLN9aRflXt674+ALyXwema+5OcBtB9faBbfS+wbujpa4F942xfkrQ4Sy79JI9L8vhDy8DzgE8BO4CLutUuAq7vlncAm5Mcl+QMYANw81K3L0lavHFO75wKvDfJoZx3VNXfJfk4cF2Si4HPAC8AqKpdSa4DbgcOApdU1cNjzV6StChLLv2q+nfgaSPGPw88+zDP2QZsW+o2dWxYv/WGRa2/Z/v5U5qJpMXyHbmS1BBLX5IaYulLUkMsfUlqiKUvSQ2x9CWpIZa+JDXE0pekhlj6ktQQS1+SGmLpS1JDLH1JaoilL0kNsfQlqSGWviQ1xNKXpIZY+pLUEEtfkhpi6UtSQyx9SWqIpS9JDbH0Jakhlr4kNcTSl6SGWPqS1BBLX5IaYulLUkMsfUlqiKUvSQ2x9CWpISuXewLSfOu33rCo9fdsP39KM5EefTzSl6SGWPqS1BBP76g5nj5SyzzSl6SGWPqS1BBLX5IaYulLUkMsfUlqyMyv3kmyCXgzsAJ4S1Vtn/UcpGny6iAdy2Za+klWAH8CPBfYC3w8yY6qun2W85D6zP9UNI5ZH+mfA+yuqn8HSHItcAFg6UvHiGn/p2L+8kpVzW5jyU8Bm6rqpd39FwPfX1WvmLfeFmBLd/c7gTsXsZlVwOcmMN3lyO/z3M033/xjK//0qlo9f3DWR/oZMfaI/3Wq6irgqiVtIJmrqo1Lee5y5/d57uabb34/8md99c5eYN3Q/bXAvhnPQZKaNevS/ziwIckZSR4LbAZ2zHgOktSsmZ7eqaqDSV4B/D2DSzbfVlW7JryZJZ0WOkby+zx38803vwf5M30hV5K0vHxHriQ1xNKXpIZY+pLUEEtfkhrS61+XmCQMPtphDYM3ee0Dbq4JvTptvvnm9zO/z3Ofdn5vr95J8jzgCuAu4L5ueC3w7cDLq+oD5ptvfnv5fZ77LPKpql7egDuA9SPGzwDuMN9889vM7/PcZ5Hf53P6Kxl8rMN89wGPMd9885vN7/Pcp57f53P6b2PwefzXAvd2Y+sYfLTDW8033/xm8/s896nn9/acPkCSpzD4PP41DD7Bcy8wsV/KYr755vczv89zn3Z+r0tfkrQ4fT6nf1hJXme++eabP8vsvuQ/KksfuMV88803f8bZvcj39I4kNaTXR/pJnpXkj5Ncn+Q9SbYn+fYJ5p+X5MokO7ptXJlk04SyT07ym0lemoHXJPnbJH+Q5KQJ5L8hyTMnMdfD5P9EkpO75dVJrkmyM8m7kqyd1na77f3mBDJWzbv/c0kuT7KlezfkxCX54DRyR2xnEvsnSV6Y5AXd8rO7/fPyJBPpje776+Ik6+eN/+KYuVP93uq20d/u6euRfpLtwKnATcCFwN3AvwIvB15fVe8eM/9NwHcA1/D1a2bXAi8B7qqqV46Z/z5gJ3Ai8JRu+TrgucDTquqCMfMPAPcAq4F3Ae+sqlvHyZyXf3tVndktvwv4GPBu4DnAz1bVcye1rRHb/kxVfcuYGZ+oqu/tln8d+GHgHcCPAnur6lVj5n9y/hCDf093AlTVd4+Tv8C2J7F/rgBOAR4LfBk4Dvgb4PnA/RP49/964IeATwA/Brypqv6oe+xrfzdLzJ7291avu2esd3Yt5w3YObS8Evinbvkk4FMTyP/Xw4yn2/Hj5t82lHffqMfGzL+1+7oB+A1gF/Bp4LXAd0wg/86h5VumMP8vH+b2IHBwUvunW/4E8Lhu+THD/7bGyN8B/DnwZOB0YD2Da65PB07vwf7ZObQ/Pg88tru/ckL7Zyewslt+AvA+4I3z/26WmH1b93Va31u97p4+n975v0OnF4BvZvDrF6mqLzLYOeP6apJzRox/H/DVCeR/Q/ej5jrghEM/4iZ5IoOjq3EVQFXdVVW/U1VnAS8EvpHBN9i4PpTkt5Mc3y1fCIMfe4H/mED+l4ANVXXivNvjgf0TyD8+yfckeTqwoqq+AlBV/ws8PG54Vf048B4Gv+LuaVW1B/jfqrqnqu4ZN5/p75+D8LX98fGq+p/u/kEmsH8YFP6hbXyJwdH+iUnezfj//qf9vdXr7unzO3JfD9ya5E4GR1Mvg8H5ZeBfJpD/88CVSR7P13/EWsfgaOrnJ5D/ewyOvAF+EXhLkgLOBH5rAvmP+MdXVZ8EPglcNoH8VwCvoTtdAbwqyVcYnAJ48QTyr2FwVHz/iMfeMYH8/cAbuuUvJDmtqvZ3xXBwAvlU1XuTfAD4nSQvZTKFc8i0989nk5xQVf9ZVV87l5zkScD/TCD/35L8SFV9GKCqHgYuTvK7wE+OmT3t761ed09vz+nD4AUb4FuB3d3RwjS28SSG3hVXVZ+dYPYKBn8HB5OsBM5m8OPo2Edqh75hx805ym19E4Mjt8/PYnvT1P2dHFdV/zXh3KcBP1BVfzrJ3FlL8jgGp8IeGDPneICq+u8Rj62pqvse+axF5U/te6vL72339Lr0DyfJk6vq0wuveVRZj+l+xB0eW1VVn5tE/mG2ObH59z3f/W/+EjN6+3n3C2x37H3T53P6RzLe503ztUuy9gL7knxg3mVlY+cvoPl897/5S5XB59HfBbyOwdVG5zM4rXNX99hYpp2/gLH3fW/P6Se5/HAPMbgaYFy/D5xXVbuS/BRwY5IXV9XHmMCLNdOef9/zcf+bv3RvBp7TvXg+vM0zGFzE8JRjOX/a+763pQ/8AvBq4KERj71oAvmPrapdAFX1l0nuAP4qyVa6K2PGNO359z3f/W/+UvX68+6Z9r4f95rP5boBHwR+8DCP3T2B/DngSfPG1gK3AQ/2YP59z3f/m7/U7MuAW4FLgZ/pbpd2Y5dNYO7Tzp/qvu/tC7ndq+dfrQlfZTGU/xzgQFX9y7zxJwCXVNW2MfOnPf++57v/zR8n/0zgx5ne591PLX/q+6avpS9JWrzeXr2T5Jsy+JCjTyf5fHe7oxt7gvnmm99mfp/nPov83pY+gw9Q+iJwblU9saqeCDyrGxvrA4/MN9/8XucfLvtLE8hezvzJ7PtxXxRYrhtDH/i1mMfMN9/8R3d+n+c+i/w+H+nfk+RXk5x6aCDJqUku5eu/Qd58881vL7/Pc596fp9L/6eBJwIfTvLFJF8APgSczODTJM033/w28/s89+nnj/ujwnLeGHzC3XOAE+aNbzLffPPbze/z3Ke+byYxweW4Ab/M4GN9/xrYA1ww9NgnzDff/Dbz+zz3meSPG7BcNwa/eeeEbnk9g3dwvrK7f6v55pvfZn6f5z6L/D5/9s6K6j4vvqr2JDkX+MskpzOZ315jvvnm9zO/z3Ofen6fX8j9bJKzD93pdtKPAquA7zLffPObze/z3KefP+6PCst1Y/DhW086zGPPNN9889vM7/PcZ5HvZ+9IUkP6fHpHkrRIlr4kNcTSl6SGWPqS1JD/BwDTuHk0I3jAAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "data['Date_N'].dt.year.value_counts().plot(kind='bar')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "60702a91",
   "metadata": {},
   "source": [
    "# Q.3. How many Movies & TV Shows are in the dataset ? Show with Bar Graph."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "3d56584e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Category\n",
       "Movie      5377\n",
       "TV Show    2410\n",
       "Name: Category, dtype: int64"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.groupby('Category').Category.count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "5ab6b6bd",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "D:\\anaconda\\lib\\site-packages\\seaborn\\_decorators.py:36: FutureWarning: Pass the following variable as a keyword arg: x. From version 0.12, the only valid positional argument will be `data`, and passing other arguments without an explicit keyword will result in an error or misinterpretation.\n",
      "  warnings.warn(\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:xlabel='Category', ylabel='count'>"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYsAAAEGCAYAAACUzrmNAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjUuMSwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/YYfK9AAAACXBIWXMAAAsTAAALEwEAmpwYAAAT/klEQVR4nO3df7Bc5X3f8fcHgYEWEyAIIks4oo7aWBCbGJXQuPnhkBoldiKcmFQe2ygOU6WUZOJO7Qwkbf2jVeKZuJkE15BoUhvJTcFKHIziCXEYueDExcZXNkYITFENAQWCBE5icFtq4W//2EdmfbX3PldYu1fSfb9mzpxzvuc85z7LLPrs+bHPpqqQJGk2x8x3ByRJhz/DQpLUZVhIkroMC0lSl2EhSeo6dr47MC6nn356LV++fL67IUlHlO3btz9RVYun14/asFi+fDlTU1Pz3Q1JOqIk+ctRdS9DSZK6DAtJUpdhIUnqMiwkSV2GhSSpy7CQJHUZFpKkLsNCktRlWEiSuo7ab3BLR7OH3/09890FHYZe/O93jO3YnllIkroMC0lSl2EhSeoyLCRJXYaFJKnLsJAkdRkWkqQuw0KS1GVYSJK6DAtJUtdYwyLJQ0l2JLkryVSrnZbk1iQPtPmpQ/tfnWRXkvuTXDxUP78dZ1eSa5JknP2WJH2zSZxZvKqqzquqVW39KmBbVa0AtrV1kqwE1gLnAKuBa5Msam2uA9YDK9q0egL9liQ183EZag2wqS1vAi4Zqt9YVc9U1YPALuCCJEuAk6vqjqoqYPNQG0nSBIw7LAr4syTbk6xvtTOr6jGANj+j1ZcCjwy13d1qS9vy9PoBkqxPMpVkau/evYfwZUjSwjbuIcpfWVWPJjkDuDXJF2fZd9R9iJqlfmCxaiOwEWDVqlUj95EkHbyxnllU1aNtvge4CbgAeLxdWqLN97TddwNnDTVfBjza6stG1CVJEzK2sEjy95O8cP8y8GrgHmArsK7ttg64uS1vBdYmOT7J2QxuZN/ZLlU9leTC9hTUZUNtJEkTMM7LUGcCN7WnXI8F/ltV/WmSzwJbklwOPAxcClBVO5NsAe4F9gFXVtWz7VhXANcDJwK3tEmSNCFjC4uq+hLw8hH1J4GLZmizAdgwoj4FnHuo+yhJmhu/wS1J6jIsJEldhoUkqcuwkCR1GRaSpC7DQpLUZVhIkroMC0lSl2EhSeoyLCRJXYaFJKnLsJAkdRkWkqQuw0KS1GVYSJK6DAtJUpdhIUnqMiwkSV2GhSSpy7CQJHUZFpKkLsNCktRlWEiSugwLSVKXYSFJ6jIsJEldhoUkqcuwkCR1GRaSpC7DQpLUNfawSLIoyeeTfKytn5bk1iQPtPmpQ/tenWRXkvuTXDxUPz/JjrbtmiQZd78lSc+ZxJnFLwH3Da1fBWyrqhXAtrZOkpXAWuAcYDVwbZJFrc11wHpgRZtWT6DfkqRmrGGRZBnwGuD3hsprgE1teRNwyVD9xqp6pqoeBHYBFyRZApxcVXdUVQGbh9pIkiZg3GcWvwX8MvD1odqZVfUYQJuf0epLgUeG9tvdakvb8vT6AZKsTzKVZGrv3r2H5AVIksYYFkleC+ypqu1zbTKiVrPUDyxWbayqVVW1avHixXP8s5KknmPHeOxXAj+Z5MeBE4CTk/xX4PEkS6rqsXaJaU/bfzdw1lD7ZcCjrb5sRF2SNCFjO7OoqqurallVLWdw4/oTVfUmYCuwru22Dri5LW8F1iY5PsnZDG5k39kuVT2V5ML2FNRlQ20kSRMwzjOLmbwH2JLkcuBh4FKAqtqZZAtwL7APuLKqnm1trgCuB04EbmmTJGlCJhIWVXUbcFtbfhK4aIb9NgAbRtSngHPH10NJ0mz8BrckqcuwkCR1GRaSpC7DQpLUZVhIkroMC0lSl2EhSeoyLCRJXYaFJKnLsJAkdRkWkqQuw0KS1GVYSJK6DAtJUpdhIUnqMiwkSV2GhSSpy7CQJHUZFpKkLsNCktRlWEiSugwLSVKXYSFJ6jIsJEldhoUkqcuwkCR1GRaSpC7DQpLUNaewSLJtLjVJ0tFp1rBIckKS04DTk5ya5LQ2LQdeNIe2dyb5QpKdSd7V6qcluTXJA21+6lCbq5PsSnJ/kouH6ucn2dG2XZMk39KrliQdlN6Zxc8D24HvbvP9083A+zttnwF+pKpeDpwHrE5yIXAVsK2qVgDb2jpJVgJrgXOA1cC1SRa1Y10HrAdWtGn13F+iJOlbNWtYVNVvV9XZwNuq6h9U1dltenlV/edO26qqp9vqcW0qYA2wqdU3AZe05TXAjVX1TFU9COwCLkiyBDi5qu6oqgI2D7WRJE3AsXPZqarel+T7geXDbapq82zt2pnBduC7gPdX1WeSnFlVj7X2jyU5o+2+FPj0UPPdrfa1tjy9PurvrWdwBsKLX/ziubw0SdIczCksknwIeAlwF/BsK+//lD+jqnoWOC/JKcBNSc6d7c+MOsQs9VF/byOwEWDVqlUj95EkHbw5hQWwCljZLgMdtKr62yS3MbjX8HiSJe2sYgmwp+22GzhrqNky4NFWXzaiLkmakLl+z+Ie4DsO5sBJFrczCpKcCPwo8EVgK7Cu7baOwc1yWn1tkuOTnM3gRvad7ZLVU0kubE9BXTbURpI0AXM9szgduDfJnQyecgKgqn5yljZLgE3tvsUxwJaq+liSO4AtSS4HHgYubcfamWQLcC+wD7iyXcYCuAK4HjgRuKVNkqQJmWtYvPNgD1xVdwPfO6L+JHDRDG02ABtG1KeA2e53SJLGaK5PQ90+7o5Ikg5fc30a6imeewLpBQy+M/HVqjp5XB2TJB0+5npm8cLh9SSXABeMo0OSpMPP8xp1tqo+CvzIoe2KJOlwNdfLUD81tHoMg+9d+KU3SVog5vo01E8MLe8DHmIwlpMkaQGY6z2Lt4y7I5Kkw9dcf/xoWZKbkuxJ8niSjyRZ1m8pSToazPUG9wcZDMfxIgYjvv5xq0mSFoC5hsXiqvpgVe1r0/XA4jH2S5J0GJlrWDyR5E1JFrXpTcCT4+yYJOnwMdew+DngZ4C/Bh4DXg9401uSFoi5Pjr7H4B1VfU3AElOA97LIEQkSUe5uZ5ZvGx/UABU1ZcZMaKsJOnoNNewOCbJqftX2pnFXM9KJElHuLn+g/+fgP+R5A8ZDPPxM4z43QlJ0tFprt/g3pxkisHggQF+qqruHWvPJEmHjTlfSmrhsGAC4vy3b57vLugwtP03LpvvLkjz4nkNUS5JWlgMC0lSl2EhSeoyLCRJXYaFJKnLsJAkdRkWkqQuw0KS1GVYSJK6DAtJUpdhIUnqMiwkSV1jC4skZyX570nuS7IzyS+1+mlJbk3yQJsP/07G1Ul2Jbk/ycVD9fOT7GjbrkmScfVbknSgcZ5Z7AP+TVW9FLgQuDLJSuAqYFtVrQC2tXXatrXAOcBq4Noki9qxrgPWAyvatHqM/ZYkTTO2sKiqx6rqc235KeA+YCmwBtjUdtsEXNKW1wA3VtUzVfUgsAu4IMkS4OSquqOqCtg81EaSNAETuWeRZDmD3+z+DHBmVT0Gg0ABzmi7LQUeGWq2u9WWtuXp9VF/Z32SqSRTe/fuPaSvQZIWsrGHRZKTgI8Ab62qr8y264hazVI/sFi1sapWVdWqxYsXH3xnJUkjjTUskhzHICh+v6r+qJUfb5eWaPM9rb4bOGuo+TLg0VZfNqIuSZqQcT4NFeC/APdV1W8ObdoKrGvL64Cbh+prkxyf5GwGN7LvbJeqnkpyYTvmZUNtJEkTMOff4H4eXgm8GdiR5K5W+xXgPcCWJJcDDwOXAlTVziRbGPzO9z7gyqp6trW7ArgeOBG4pU2SpAkZW1hU1V8w+n4DwEUztNkAbBhRnwLOPXS9kyQdDL/BLUnqMiwkSV2GhSSpy7CQJHUZFpKkLsNCktRlWEiSugwLSVKXYSFJ6jIsJEldhoUkqcuwkCR1GRaSpC7DQpLUZVhIkroMC0lSl2EhSeoyLCRJXYaFJKnLsJAkdRkWkqQuw0KS1GVYSJK6DAtJUpdhIUnqMiwkSV2GhSSpy7CQJHUZFpKkrrGFRZIPJNmT5J6h2mlJbk3yQJufOrTt6iS7ktyf5OKh+vlJdrRt1yTJuPosSRptnGcW1wOrp9WuArZV1QpgW1snyUpgLXBOa3NtkkWtzXXAemBFm6YfU5I0ZmMLi6r6JPDlaeU1wKa2vAm4ZKh+Y1U9U1UPAruAC5IsAU6uqjuqqoDNQ20kSRMy6XsWZ1bVYwBtfkarLwUeGdpvd6stbcvT6yMlWZ9kKsnU3r17D2nHJWkhO1xucI+6D1Gz1Eeqqo1VtaqqVi1evPiQdU6SFrpJh8Xj7dISbb6n1XcDZw3ttwx4tNWXjahLkiZo0mGxFVjXltcBNw/V1yY5PsnZDG5k39kuVT2V5ML2FNRlQ20kSRNy7LgOnOQG4IeB05PsBt4BvAfYkuRy4GHgUoCq2plkC3AvsA+4sqqebYe6gsGTVScCt7RJkjRBYwuLqnrDDJsummH/DcCGEfUp4NxD2DVJ0kE6XG5wS5IOY4aFJKnLsJAkdRkWkqQuw0KS1GVYSJK6DAtJUpdhIUnqMiwkSV2GhSSpy7CQJHUZFpKkLsNCktRlWEiSugwLSVKXYSFJ6jIsJEldhoUkqcuwkCR1GRaSpC7DQpLUZVhIkroMC0lSl2EhSeoyLCRJXYaFJKnLsJAkdRkWkqQuw0KS1GVYSJK6jpiwSLI6yf1JdiW5ar77I0kLyRERFkkWAe8HfgxYCbwhycr57ZUkLRxHRFgAFwC7qupLVfX/gBuBNfPcJ0laMI6d7w7M0VLgkaH13cD3Td8pyXpgfVt9Osn9E+jbQnA68MR8d+JwkPeum+8u6EC+P/d7Rw7FUb5zVPFICYtR/wXqgELVRmDj+LuzsCSZqqpV890PaRTfn5NxpFyG2g2cNbS+DHh0nvoiSQvOkRIWnwVWJDk7yQuAtcDWee6TJC0YR8RlqKral+QXgI8Di4APVNXOee7WQuKlPR3OfH9OQKoOuPQvSdI3OVIuQ0mS5pFhIUnqMiyOMkm+PcldbfrrJH81tH7xtH3fmuTaEcf41SQ7k9zd2n1fqz+U5PRJvRYtLEkqyYeG1o9NsjfJx57n8f5lkssOXQ8XtiPiBrfmrqqeBM4DSPJO4Omqem+Sn2fwFNnHh3ZfC7x9uH2SfwK8FnhFVT3TwuEFE+i69FXg3CQnVtX/Af4Z8FfP92BV9TuHrGfyzGIB+UPgtUmOB0iyHHgR8BfT9lsCPFFVzwBU1RNVNfydll9M8rkkO5J8dzvWaUk+2s5EPp3kZa2+I8kpGXhy/6e8JB9K8qNjfbU6Ut0CvKYtvwG4Yf+GUe+zJMe0M95ThvbbleTMJO9M8rZWe0mSP02yPcmf73/vau4MiwWinXHcCaxupbXAh+vAx+H+DDgryf9Mcm2SH5q2/YmqegVwHfC2VnsX8PmqehnwK8DmVv8U8ErgHOBLwA+0+oXApw/NK9NR5kZgbZITgJcBnxnadsD7rKq+DtwMvA6gXTJ9qKoen3bcjcAvVtX5DN63B1x+1ewMi4XlBgYhQZvfMH2HqnoaOJ/BGFt7gQ8n+dmhXf6ozbcDy9vyPwU+1Np/Avj2JN8G/Dnwg226DvieJEuBL7e/I32TqrqbwfvqDcCfTNs80/vsw8A/b/usbevfkOQk4PuBP0hyF/C7DM6gdRAMi4Xlo8BFSV4BnFhVnxu1U1U9W1W3VdU7gF8Afnpo8zNt/izP3fOaaeyuTzI4m/gB4DYG4fN6BiEizWQr8F4O/DAz0/vsDuC7kiwGLuG5DzT7HQP8bVWdNzS99BD3+ahnWCwg7dP8bcAHGHFWAZDkHyVZMVQ6D/jLzqE/Cbyxtf9hBpeqvlJVjzAYEXRFVX2Jwf2Rt2FYaHYfAN5dVTum1Wd6nxVwE/CbwH3tkus3VNVXgAeTXNraJsnLx/sSjj4+DbXw3MDgk9faGbafBLyv3TDcB+ziuWHfZ/JO4INJ7gb+NzA8jvdnGAzRAoOQ+HUOvKkufUNV7QZ+e8SmdzLz++zDDMaQ+9kZDvtG4Lok/xY4jsG9kS8coi4vCA73IUnq8jKUJKnLsJAkdRkWkqQuw0KS1GVYSJK6DAtpFkm+I8mNSf5XknuT/EmSfzjDvqck+VeT7qM0CYaFNIMkYfBlr9uq6iVVtZLBmERnztDkFGDsYZHE70dp4gwLaWavAr42PNR1Vd0FfD7JtqHRd9e0ze8BXtJ+A+Q3AJK8Pcln20ip79p/nCT/LskXk9ya5Iah0VHPayOq3p3kpiSntvptSX4tye3AryZ5MMlxbdvJbeTV4ybxH0ULk59QpJmdy2DAxOn+L/C6qvpK+72PTyfZClwFnFtV5wEkeTWwAriAwbhGW5P8IINvH/808L0M/h/83NDf2cxgdNTbk7wbeAfw1rbtlKr6oXbs5QyG8v4og2/jf6SqvnbIXrk0jWEhHbwAv9b+4f86sJTRl6Ze3abPt/WTGITHC4Gb2w/8kOSP2/zbGATC7W3/TcAfDB1veDTV3wN+mUFYvAX4F9/yq5JmYVhIM9vJYJTc6d4ILAbOr6qvJXkIOGHEfgF+vap+95uKyb9+nv356v6FqvpUkuXt90YWVdU9z/OY0px4z0Ka2SeA45N841N7kn8MfCewpwXFq9o6wFMMzhr2+zjwc+33FEiyNMkZDAZS/IkkJ7RtrwGoqr8D/ibJ/h+JejNwOzPbzGBgyA9+i69T6vLMQppBVVWS1wG/leQqBvcqHmIw+uk1SaaAu4Avtv2fTPKpJPcAt1TV25O8FLhj8GAVTwNvqqrPtnscX2Aw/PsU8Hftz64DfifJ32Pw64JvmaWLvw/8R2YYbl46lBx1VpoHSU6qqqdbKHwSWD/Tj1HNcozXA2uq6s1j6aQ0xDMLaX5sTLKSwb2OTc8jKN4H/Bjw4+PonDSdZxaSpC5vcEuSugwLSVKXYSFJ6jIsJEldhoUkqev/AyyEbmoIbGSuAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "sns.countplot(data['Category'])"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f8e1761d",
   "metadata": {},
   "source": [
    "# Q.4. Show all the Movies that were released in year 2000."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "00da9dc4",
   "metadata": {},
   "outputs": [],
   "source": [
    "data['Year'] = data['Date_N'].dt.year"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "2a05d0d8",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Show_Id</th>\n",
       "      <th>Category</th>\n",
       "      <th>Title</th>\n",
       "      <th>Director</th>\n",
       "      <th>Cast</th>\n",
       "      <th>Country</th>\n",
       "      <th>Release_Date</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Duration</th>\n",
       "      <th>Type</th>\n",
       "      <th>Description</th>\n",
       "      <th>Date_N</th>\n",
       "      <th>Year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>s1</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>3%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>João Miguel, Bianca Comparato, Michel Gomes, R...</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>August 14, 2020</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>4 Seasons</td>\n",
       "      <td>International TV Shows, TV Dramas, TV Sci-Fi &amp;...</td>\n",
       "      <td>In a future where the elite inhabit an island ...</td>\n",
       "      <td>2020-08-14</td>\n",
       "      <td>2020.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>s2</td>\n",
       "      <td>Movie</td>\n",
       "      <td>07:19</td>\n",
       "      <td>Jorge Michel Grau</td>\n",
       "      <td>Demián Bichir, Héctor Bonilla, Oscar Serrano, ...</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>December 23, 2016</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>93 min</td>\n",
       "      <td>Dramas, International Movies</td>\n",
       "      <td>After a devastating earthquake hits Mexico Cit...</td>\n",
       "      <td>2016-12-23</td>\n",
       "      <td>2016.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Show_Id Category  Title           Director  \\\n",
       "0      s1  TV Show     3%                NaN   \n",
       "1      s2    Movie  07:19  Jorge Michel Grau   \n",
       "\n",
       "                                                Cast Country  \\\n",
       "0  João Miguel, Bianca Comparato, Michel Gomes, R...  Brazil   \n",
       "1  Demián Bichir, Héctor Bonilla, Oscar Serrano, ...  Mexico   \n",
       "\n",
       "        Release_Date Rating   Duration  \\\n",
       "0    August 14, 2020  TV-MA  4 Seasons   \n",
       "1  December 23, 2016  TV-MA     93 min   \n",
       "\n",
       "                                                Type  \\\n",
       "0  International TV Shows, TV Dramas, TV Sci-Fi &...   \n",
       "1                       Dramas, International Movies   \n",
       "\n",
       "                                         Description     Date_N    Year  \n",
       "0  In a future where the elite inhabit an island ... 2020-08-14  2020.0  \n",
       "1  After a devastating earthquake hits Mexico Cit... 2016-12-23  2016.0  "
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "c8d61334",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Show_Id</th>\n",
       "      <th>Category</th>\n",
       "      <th>Title</th>\n",
       "      <th>Director</th>\n",
       "      <th>Cast</th>\n",
       "      <th>Country</th>\n",
       "      <th>Release_Date</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Duration</th>\n",
       "      <th>Type</th>\n",
       "      <th>Description</th>\n",
       "      <th>Date_N</th>\n",
       "      <th>Year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [Show_Id, Category, Title, Director, Cast, Country, Release_Date, Rating, Duration, Type, Description, Date_N, Year]\n",
       "Index: []"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[ (data['Category'] == 'Movie') & (data['Year']==2000) ]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "608239eb",
   "metadata": {},
   "source": [
    "# Q.5. Show only the Titles of all TV Shows that were released in India only."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "87a308f8",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "86            21 Sarfarosh: Saragarhi 1897\n",
       "132                              7 (Seven)\n",
       "340                           Agent Raghav\n",
       "364                           Akbar Birbal\n",
       "533                    Anjaan: Rural Myths\n",
       "                       ...                \n",
       "6249                  The Creative Indians\n",
       "6400    The Golden Years with Javed Akhtar\n",
       "6469                The House That Made Me\n",
       "7294                            Typewriter\n",
       "7705                       Yeh Meri Family\n",
       "Name: Title, Length: 71, dtype: object"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[ (data['Category']=='TV Show') & (data['Country']=='India') ] ['Title']"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "15d3b083",
   "metadata": {},
   "source": [
    "# Q.6. Show Top 10 Directors, who gave the highest number of TV Shows & Movies to Netflix ?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "03b03d2a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Raúl Campos, Jan Suter    18\n",
       "Marcus Raboy              16\n",
       "Jay Karas                 14\n",
       "Cathy Garcia-Molina       13\n",
       "Jay Chapman               12\n",
       "Youssef Chahine           12\n",
       "Martin Scorsese           12\n",
       "Steven Spielberg          10\n",
       "David Dhawan               9\n",
       "Hakan Algül                8\n",
       "Name: Director, dtype: int64"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['Director'].value_counts().head(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f4770b62",
   "metadata": {},
   "source": [
    "# Q.7. Show all the Records, where \"Category is Movie and Type is Comedies\" or \"Country is United Kingdom\"."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "33b1195b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Show_Id</th>\n",
       "      <th>Category</th>\n",
       "      <th>Title</th>\n",
       "      <th>Director</th>\n",
       "      <th>Cast</th>\n",
       "      <th>Country</th>\n",
       "      <th>Release_Date</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Duration</th>\n",
       "      <th>Type</th>\n",
       "      <th>Description</th>\n",
       "      <th>Date_N</th>\n",
       "      <th>Year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>s34</td>\n",
       "      <td>Movie</td>\n",
       "      <td>#realityhigh</td>\n",
       "      <td>Fernando Lebrija</td>\n",
       "      <td>Nesta Cooper, Kate Walsh, John Michael Higgins...</td>\n",
       "      <td>United States</td>\n",
       "      <td>September 8, 2017</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>99 min</td>\n",
       "      <td>Comedies</td>\n",
       "      <td>When nerdy high schooler Dani finally attracts...</td>\n",
       "      <td>2017-09-08</td>\n",
       "      <td>2017.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>s73</td>\n",
       "      <td>Movie</td>\n",
       "      <td>17 Again</td>\n",
       "      <td>Burr Steers</td>\n",
       "      <td>Zac Efron, Leslie Mann, Matthew Perry, Thomas ...</td>\n",
       "      <td>United States</td>\n",
       "      <td>January 1, 2021</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>102 min</td>\n",
       "      <td>Comedies</td>\n",
       "      <td>Nearing a midlife crisis, thirty-something Mik...</td>\n",
       "      <td>2021-01-01</td>\n",
       "      <td>2021.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>s85</td>\n",
       "      <td>Movie</td>\n",
       "      <td>21 &amp; Over</td>\n",
       "      <td>Jon Lucas, Scott Moore</td>\n",
       "      <td>Miles Teller, Skylar Astin, Justin Chon, Sarah...</td>\n",
       "      <td>United States</td>\n",
       "      <td>April 16, 2019</td>\n",
       "      <td>R</td>\n",
       "      <td>93 min</td>\n",
       "      <td>Comedies</td>\n",
       "      <td>Jeff's straight-and-narrow life changes abrupt...</td>\n",
       "      <td>2019-04-16</td>\n",
       "      <td>2019.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>s149</td>\n",
       "      <td>Movie</td>\n",
       "      <td>A Bad Moms Christmas</td>\n",
       "      <td>Jon Lucas, Scott Moore</td>\n",
       "      <td>Mila Kunis, Kristen Bell, Kathryn Hahn, Susan ...</td>\n",
       "      <td>United States, China</td>\n",
       "      <td>February 14, 2020</td>\n",
       "      <td>R</td>\n",
       "      <td>104 min</td>\n",
       "      <td>Comedies</td>\n",
       "      <td>Stressed-out moms Amy, Carla and Kiki are back...</td>\n",
       "      <td>2020-02-14</td>\n",
       "      <td>2020.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>s175</td>\n",
       "      <td>Movie</td>\n",
       "      <td>A Futile and Stupid Gesture</td>\n",
       "      <td>David Wain</td>\n",
       "      <td>Will Forte, Domhnall Gleeson, Martin Mull, Joe...</td>\n",
       "      <td>United States</td>\n",
       "      <td>January 26, 2018</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>102 min</td>\n",
       "      <td>Comedies</td>\n",
       "      <td>In a brief life full of triumph and failure, \"...</td>\n",
       "      <td>2018-01-26</td>\n",
       "      <td>2018.0</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7341</th>\n",
       "      <td>s7340</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Undercover Brother 2</td>\n",
       "      <td>Leslie Small</td>\n",
       "      <td>Michael Jai White, Vince Swann, Barry Bostwick...</td>\n",
       "      <td>United States</td>\n",
       "      <td>November 5, 2019</td>\n",
       "      <td>R</td>\n",
       "      <td>85 min</td>\n",
       "      <td>Comedies</td>\n",
       "      <td>When a beloved secret agent falls deep into a ...</td>\n",
       "      <td>2019-11-05</td>\n",
       "      <td>2019.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7590</th>\n",
       "      <td>s7589</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Where's the Money</td>\n",
       "      <td>Scott Zabielski</td>\n",
       "      <td>Andrew Bachelor, Kat Graham, Mike Epps, Terry ...</td>\n",
       "      <td>United States</td>\n",
       "      <td>January 22, 2018</td>\n",
       "      <td>R</td>\n",
       "      <td>86 min</td>\n",
       "      <td>Comedies</td>\n",
       "      <td>Hunting for a stash of stolen money, a sharp-w...</td>\n",
       "      <td>2018-01-22</td>\n",
       "      <td>2018.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7623</th>\n",
       "      <td>s7622</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Wild Oats</td>\n",
       "      <td>Andy Tennant</td>\n",
       "      <td>Shirley MacLaine, Jessica Lange, Billy Connoll...</td>\n",
       "      <td>Germany, United States</td>\n",
       "      <td>May 13, 2017</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>86 min</td>\n",
       "      <td>Comedies</td>\n",
       "      <td>When insurance accidentally pays her millions,...</td>\n",
       "      <td>2017-05-13</td>\n",
       "      <td>2017.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7634</th>\n",
       "      <td>s7633</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Wine Country</td>\n",
       "      <td>Amy Poehler</td>\n",
       "      <td>Amy Poehler, Maya Rudolph, Ana Gasteyer, Rache...</td>\n",
       "      <td>United States</td>\n",
       "      <td>May 10, 2019</td>\n",
       "      <td>R</td>\n",
       "      <td>104 min</td>\n",
       "      <td>Comedies</td>\n",
       "      <td>When longtime friends meet up for a wine-soake...</td>\n",
       "      <td>2019-05-10</td>\n",
       "      <td>2019.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7664</th>\n",
       "      <td>s7663</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Work It</td>\n",
       "      <td>Laura Terruso</td>\n",
       "      <td>Sabrina Carpenter, Jordan Fisher, Liza Koshy, ...</td>\n",
       "      <td>United States</td>\n",
       "      <td>August 7, 2020</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>94 min</td>\n",
       "      <td>Comedies</td>\n",
       "      <td>A brilliant but clumsy high school senior vows...</td>\n",
       "      <td>2020-08-07</td>\n",
       "      <td>2020.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>97 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Show_Id Category                        Title                Director  \\\n",
       "33       s34    Movie                 #realityhigh        Fernando Lebrija   \n",
       "72       s73    Movie                     17 Again             Burr Steers   \n",
       "84       s85    Movie                    21 & Over  Jon Lucas, Scott Moore   \n",
       "148     s149    Movie         A Bad Moms Christmas  Jon Lucas, Scott Moore   \n",
       "174     s175    Movie  A Futile and Stupid Gesture              David Wain   \n",
       "...      ...      ...                          ...                     ...   \n",
       "7341   s7340    Movie         Undercover Brother 2            Leslie Small   \n",
       "7590   s7589    Movie            Where's the Money         Scott Zabielski   \n",
       "7623   s7622    Movie                    Wild Oats            Andy Tennant   \n",
       "7634   s7633    Movie                 Wine Country             Amy Poehler   \n",
       "7664   s7663    Movie                      Work It           Laura Terruso   \n",
       "\n",
       "                                                   Cast  \\\n",
       "33    Nesta Cooper, Kate Walsh, John Michael Higgins...   \n",
       "72    Zac Efron, Leslie Mann, Matthew Perry, Thomas ...   \n",
       "84    Miles Teller, Skylar Astin, Justin Chon, Sarah...   \n",
       "148   Mila Kunis, Kristen Bell, Kathryn Hahn, Susan ...   \n",
       "174   Will Forte, Domhnall Gleeson, Martin Mull, Joe...   \n",
       "...                                                 ...   \n",
       "7341  Michael Jai White, Vince Swann, Barry Bostwick...   \n",
       "7590  Andrew Bachelor, Kat Graham, Mike Epps, Terry ...   \n",
       "7623  Shirley MacLaine, Jessica Lange, Billy Connoll...   \n",
       "7634  Amy Poehler, Maya Rudolph, Ana Gasteyer, Rache...   \n",
       "7664  Sabrina Carpenter, Jordan Fisher, Liza Koshy, ...   \n",
       "\n",
       "                     Country       Release_Date Rating Duration      Type  \\\n",
       "33             United States  September 8, 2017  TV-14   99 min  Comedies   \n",
       "72             United States    January 1, 2021  PG-13  102 min  Comedies   \n",
       "84             United States     April 16, 2019      R   93 min  Comedies   \n",
       "148     United States, China  February 14, 2020      R  104 min  Comedies   \n",
       "174            United States   January 26, 2018  TV-MA  102 min  Comedies   \n",
       "...                      ...                ...    ...      ...       ...   \n",
       "7341           United States   November 5, 2019      R   85 min  Comedies   \n",
       "7590           United States   January 22, 2018      R   86 min  Comedies   \n",
       "7623  Germany, United States       May 13, 2017  PG-13   86 min  Comedies   \n",
       "7634           United States       May 10, 2019      R  104 min  Comedies   \n",
       "7664           United States     August 7, 2020  TV-14   94 min  Comedies   \n",
       "\n",
       "                                            Description     Date_N    Year  \n",
       "33    When nerdy high schooler Dani finally attracts... 2017-09-08  2017.0  \n",
       "72    Nearing a midlife crisis, thirty-something Mik... 2021-01-01  2021.0  \n",
       "84    Jeff's straight-and-narrow life changes abrupt... 2019-04-16  2019.0  \n",
       "148   Stressed-out moms Amy, Carla and Kiki are back... 2020-02-14  2020.0  \n",
       "174   In a brief life full of triumph and failure, \"... 2018-01-26  2018.0  \n",
       "...                                                 ...        ...     ...  \n",
       "7341  When a beloved secret agent falls deep into a ... 2019-11-05  2019.0  \n",
       "7590  Hunting for a stash of stolen money, a sharp-w... 2018-01-22  2018.0  \n",
       "7623  When insurance accidentally pays her millions,... 2017-05-13  2017.0  \n",
       "7634  When longtime friends meet up for a wine-soake... 2019-05-10  2019.0  \n",
       "7664  A brilliant but clumsy high school senior vows... 2020-08-07  2020.0  \n",
       "\n",
       "[97 rows x 13 columns]"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[ (data['Category']=='Movie') & (data['Type']=='Comedies') ]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "6a185ce3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Show_Id</th>\n",
       "      <th>Category</th>\n",
       "      <th>Title</th>\n",
       "      <th>Director</th>\n",
       "      <th>Cast</th>\n",
       "      <th>Country</th>\n",
       "      <th>Release_Date</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Duration</th>\n",
       "      <th>Type</th>\n",
       "      <th>Description</th>\n",
       "      <th>Date_N</th>\n",
       "      <th>Year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>s20</td>\n",
       "      <td>Movie</td>\n",
       "      <td>'89</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Lee Dixon, Ian Wright, Paul Merson</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>May 16, 2018</td>\n",
       "      <td>TV-PG</td>\n",
       "      <td>87 min</td>\n",
       "      <td>Sports Movies</td>\n",
       "      <td>Mixing old footage with interviews, this is th...</td>\n",
       "      <td>2018-05-16</td>\n",
       "      <td>2018.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>s34</td>\n",
       "      <td>Movie</td>\n",
       "      <td>#realityhigh</td>\n",
       "      <td>Fernando Lebrija</td>\n",
       "      <td>Nesta Cooper, Kate Walsh, John Michael Higgins...</td>\n",
       "      <td>United States</td>\n",
       "      <td>September 8, 2017</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>99 min</td>\n",
       "      <td>Comedies</td>\n",
       "      <td>When nerdy high schooler Dani finally attracts...</td>\n",
       "      <td>2017-09-08</td>\n",
       "      <td>2017.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>s59</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>100% Hotter</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Daniel Palmer, Melissa Sophia, Karen Williams,...</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>November 1, 2019</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>British TV Shows, International TV Shows, Real...</td>\n",
       "      <td>A stylist, a hair designer and a makeup artist...</td>\n",
       "      <td>2019-11-01</td>\n",
       "      <td>2019.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>s73</td>\n",
       "      <td>Movie</td>\n",
       "      <td>17 Again</td>\n",
       "      <td>Burr Steers</td>\n",
       "      <td>Zac Efron, Leslie Mann, Matthew Perry, Thomas ...</td>\n",
       "      <td>United States</td>\n",
       "      <td>January 1, 2021</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>102 min</td>\n",
       "      <td>Comedies</td>\n",
       "      <td>Nearing a midlife crisis, thirty-something Mik...</td>\n",
       "      <td>2021-01-01</td>\n",
       "      <td>2021.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>s83</td>\n",
       "      <td>Movie</td>\n",
       "      <td>2036 Origin Unknown</td>\n",
       "      <td>Hasraf Dulull</td>\n",
       "      <td>Katee Sackhoff, Ray Fearon, Julie Cox, Steven ...</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>December 20, 2018</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>95 min</td>\n",
       "      <td>Sci-Fi &amp; Fantasy</td>\n",
       "      <td>Working with an artificial intelligence to inv...</td>\n",
       "      <td>2018-12-20</td>\n",
       "      <td>2018.0</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7670</th>\n",
       "      <td>s7669</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>World War II in Colour</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Robert Powell</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>August 1, 2017</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>British TV Shows, Docuseries, International TV...</td>\n",
       "      <td>Footage of the most dramatic moments from Worl...</td>\n",
       "      <td>2017-08-01</td>\n",
       "      <td>2017.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7671</th>\n",
       "      <td>s7670</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>World's Busiest Cities</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Anita Rani, Ade Adepitan, Dan Snow</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>February 1, 2019</td>\n",
       "      <td>TV-PG</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>British TV Shows, Docuseries</td>\n",
       "      <td>From Moscow to Mexico City, three BBC journali...</td>\n",
       "      <td>2019-02-01</td>\n",
       "      <td>2019.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7688</th>\n",
       "      <td>s7687</td>\n",
       "      <td>Movie</td>\n",
       "      <td>XV: Beyond the Tryline</td>\n",
       "      <td>Pierre Deschamps</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>March 18, 2020</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>91 min</td>\n",
       "      <td>Documentaries, Sports Movies</td>\n",
       "      <td>Set against the 2015 Rugby World Cup, this doc...</td>\n",
       "      <td>2020-03-18</td>\n",
       "      <td>2020.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7725</th>\n",
       "      <td>s7724</td>\n",
       "      <td>Movie</td>\n",
       "      <td>You Can Tutu</td>\n",
       "      <td>James Brown</td>\n",
       "      <td>Lily O'Regan, Jeannettsy Enriquez Borges, Joel...</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>December 31, 2017</td>\n",
       "      <td>TV-G</td>\n",
       "      <td>87 min</td>\n",
       "      <td>Children &amp; Family Movies</td>\n",
       "      <td>A gifted young ballet dancer struggles to find...</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>2017.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7740</th>\n",
       "      <td>s7739</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Young Wallander</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Adam Pålsson, Richard Dillane, Leanne Best, El...</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>September 3, 2020</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>Crime TV Shows, International TV Shows, TV Dramas</td>\n",
       "      <td>An incendiary hate crime stirs civil unrest, f...</td>\n",
       "      <td>2020-09-03</td>\n",
       "      <td>2020.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>485 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Show_Id Category                   Title          Director  \\\n",
       "19       s20    Movie                     '89               NaN   \n",
       "33       s34    Movie            #realityhigh  Fernando Lebrija   \n",
       "58       s59  TV Show             100% Hotter               NaN   \n",
       "72       s73    Movie                17 Again       Burr Steers   \n",
       "82       s83    Movie     2036 Origin Unknown     Hasraf Dulull   \n",
       "...      ...      ...                     ...               ...   \n",
       "7670   s7669  TV Show  World War II in Colour               NaN   \n",
       "7671   s7670  TV Show  World's Busiest Cities               NaN   \n",
       "7688   s7687    Movie  XV: Beyond the Tryline  Pierre Deschamps   \n",
       "7725   s7724    Movie            You Can Tutu       James Brown   \n",
       "7740   s7739  TV Show         Young Wallander               NaN   \n",
       "\n",
       "                                                   Cast         Country  \\\n",
       "19                   Lee Dixon, Ian Wright, Paul Merson  United Kingdom   \n",
       "33    Nesta Cooper, Kate Walsh, John Michael Higgins...   United States   \n",
       "58    Daniel Palmer, Melissa Sophia, Karen Williams,...  United Kingdom   \n",
       "72    Zac Efron, Leslie Mann, Matthew Perry, Thomas ...   United States   \n",
       "82    Katee Sackhoff, Ray Fearon, Julie Cox, Steven ...  United Kingdom   \n",
       "...                                                 ...             ...   \n",
       "7670                                      Robert Powell  United Kingdom   \n",
       "7671                 Anita Rani, Ade Adepitan, Dan Snow  United Kingdom   \n",
       "7688                                                NaN  United Kingdom   \n",
       "7725  Lily O'Regan, Jeannettsy Enriquez Borges, Joel...  United Kingdom   \n",
       "7740  Adam Pålsson, Richard Dillane, Leanne Best, El...  United Kingdom   \n",
       "\n",
       "           Release_Date Rating  Duration  \\\n",
       "19         May 16, 2018  TV-PG    87 min   \n",
       "33    September 8, 2017  TV-14    99 min   \n",
       "58     November 1, 2019  TV-14  1 Season   \n",
       "72      January 1, 2021  PG-13   102 min   \n",
       "82    December 20, 2018  TV-14    95 min   \n",
       "...                 ...    ...       ...   \n",
       "7670     August 1, 2017  TV-MA  1 Season   \n",
       "7671   February 1, 2019  TV-PG  1 Season   \n",
       "7688     March 18, 2020  TV-14    91 min   \n",
       "7725  December 31, 2017   TV-G    87 min   \n",
       "7740  September 3, 2020  TV-MA  1 Season   \n",
       "\n",
       "                                                   Type  \\\n",
       "19                                        Sports Movies   \n",
       "33                                             Comedies   \n",
       "58    British TV Shows, International TV Shows, Real...   \n",
       "72                                             Comedies   \n",
       "82                                     Sci-Fi & Fantasy   \n",
       "...                                                 ...   \n",
       "7670  British TV Shows, Docuseries, International TV...   \n",
       "7671                       British TV Shows, Docuseries   \n",
       "7688                       Documentaries, Sports Movies   \n",
       "7725                           Children & Family Movies   \n",
       "7740  Crime TV Shows, International TV Shows, TV Dramas   \n",
       "\n",
       "                                            Description     Date_N    Year  \n",
       "19    Mixing old footage with interviews, this is th... 2018-05-16  2018.0  \n",
       "33    When nerdy high schooler Dani finally attracts... 2017-09-08  2017.0  \n",
       "58    A stylist, a hair designer and a makeup artist... 2019-11-01  2019.0  \n",
       "72    Nearing a midlife crisis, thirty-something Mik... 2021-01-01  2021.0  \n",
       "82    Working with an artificial intelligence to inv... 2018-12-20  2018.0  \n",
       "...                                                 ...        ...     ...  \n",
       "7670  Footage of the most dramatic moments from Worl... 2017-08-01  2017.0  \n",
       "7671  From Moscow to Mexico City, three BBC journali... 2019-02-01  2019.0  \n",
       "7688  Set against the 2015 Rugby World Cup, this doc... 2020-03-18  2020.0  \n",
       "7725  A gifted young ballet dancer struggles to find... 2017-12-31  2017.0  \n",
       "7740  An incendiary hate crime stirs civil unrest, f... 2020-09-03  2020.0  \n",
       "\n",
       "[485 rows x 13 columns]"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[ (data['Category']=='Movie') & (data['Type']=='Comedies') | (data['Country']=='United Kingdom')]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "625601c8",
   "metadata": {},
   "source": [
    "# Q.8. In how many movies/shows, Tom Cruise was cast ?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "6bcd61fe",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Show_Id</th>\n",
       "      <th>Category</th>\n",
       "      <th>Title</th>\n",
       "      <th>Director</th>\n",
       "      <th>Cast</th>\n",
       "      <th>Country</th>\n",
       "      <th>Release_Date</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Duration</th>\n",
       "      <th>Type</th>\n",
       "      <th>Description</th>\n",
       "      <th>Date_N</th>\n",
       "      <th>Year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [Show_Id, Category, Title, Director, Cast, Country, Release_Date, Rating, Duration, Type, Description, Date_N, Year]\n",
       "Index: []"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data['Cast'] == 'Lee Dixon']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "b0ea7e00",
   "metadata": {},
   "outputs": [],
   "source": [
    "#data[data['Cast'].str.contains('Lee Dixon')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "9086a1c2",
   "metadata": {},
   "outputs": [],
   "source": [
    "data_new = data.dropna()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "d0aacf1a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Show_Id</th>\n",
       "      <th>Category</th>\n",
       "      <th>Title</th>\n",
       "      <th>Director</th>\n",
       "      <th>Cast</th>\n",
       "      <th>Country</th>\n",
       "      <th>Release_Date</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Duration</th>\n",
       "      <th>Type</th>\n",
       "      <th>Description</th>\n",
       "      <th>Date_N</th>\n",
       "      <th>Year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3860</th>\n",
       "      <td>s3861</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Magnolia</td>\n",
       "      <td>Paul Thomas Anderson</td>\n",
       "      <td>Jeremy Blackman, Tom Cruise, Melinda Dillon, A...</td>\n",
       "      <td>United States</td>\n",
       "      <td>January 1, 2020</td>\n",
       "      <td>R</td>\n",
       "      <td>189 min</td>\n",
       "      <td>Dramas, Independent Movies</td>\n",
       "      <td>Through chance, human action, past history and...</td>\n",
       "      <td>2020-01-01</td>\n",
       "      <td>2020.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5071</th>\n",
       "      <td>s5071</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Rain Man</td>\n",
       "      <td>Barry Levinson</td>\n",
       "      <td>Dustin Hoffman, Tom Cruise, Valeria Golino, Ge...</td>\n",
       "      <td>United States</td>\n",
       "      <td>July 1, 2019</td>\n",
       "      <td>R</td>\n",
       "      <td>134 min</td>\n",
       "      <td>Classic Movies, Dramas</td>\n",
       "      <td>A fast-talking yuppie is forced to slow down w...</td>\n",
       "      <td>2019-07-01</td>\n",
       "      <td>2019.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Show_Id Category     Title              Director  \\\n",
       "3860   s3861    Movie  Magnolia  Paul Thomas Anderson   \n",
       "5071   s5071    Movie  Rain Man        Barry Levinson   \n",
       "\n",
       "                                                   Cast        Country  \\\n",
       "3860  Jeremy Blackman, Tom Cruise, Melinda Dillon, A...  United States   \n",
       "5071  Dustin Hoffman, Tom Cruise, Valeria Golino, Ge...  United States   \n",
       "\n",
       "         Release_Date Rating Duration                        Type  \\\n",
       "3860  January 1, 2020      R  189 min  Dramas, Independent Movies   \n",
       "5071     July 1, 2019      R  134 min      Classic Movies, Dramas   \n",
       "\n",
       "                                            Description     Date_N    Year  \n",
       "3860  Through chance, human action, past history and... 2020-01-01  2020.0  \n",
       "5071  A fast-talking yuppie is forced to slow down w... 2019-07-01  2019.0  "
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_new[data_new['Cast'].str.contains('Tom Cruise')]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d70cb27f",
   "metadata": {},
   "source": [
    "# Q.9. What are the different Ratings defined by Netflix ?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "id": "457cbcc9",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "14"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['Rating'].nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "ac44b8fd",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['TV-MA', 'R', 'PG-13', 'TV-14', 'TV-PG', 'NR', 'TV-G', 'TV-Y', nan,\n",
       "       'TV-Y7', 'PG', 'G', 'NC-17', 'TV-Y7-FV', 'UR'], dtype=object)"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['Rating'].unique()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "21baf724",
   "metadata": {},
   "source": [
    "# Q.9.1. How many Movies got the 'TV-14' rating, in Canada ?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "c2fb1b3e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(1272, 13)"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[(data['Category']=='Movie') & (data['Rating']=='TV-14')].shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "00a8c88d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(11, 13)"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[(data['Category']=='Movie') & (data['Rating']=='TV-14') & (data['Country']=='Canada')].shape"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "167ae3bd",
   "metadata": {},
   "source": [
    "# Q.9.2. How many TV Show got the 'R' rating, after year 2018 ?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "id": "2ebf79c7",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Show_Id</th>\n",
       "      <th>Category</th>\n",
       "      <th>Title</th>\n",
       "      <th>Director</th>\n",
       "      <th>Cast</th>\n",
       "      <th>Country</th>\n",
       "      <th>Release_Date</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Duration</th>\n",
       "      <th>Type</th>\n",
       "      <th>Description</th>\n",
       "      <th>Date_N</th>\n",
       "      <th>Year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4497</th>\n",
       "      <td>s4498</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Nobel</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Aksel Hennie, Tuva Novotny, Anders Danielsen L...</td>\n",
       "      <td>Norway</td>\n",
       "      <td>December 10, 2016</td>\n",
       "      <td>R</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>International TV Shows, TV Dramas, TV Thrillers</td>\n",
       "      <td>A series of incidents in Afghanistan set compl...</td>\n",
       "      <td>2016-12-10</td>\n",
       "      <td>2016.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6437</th>\n",
       "      <td>s6436</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>The Hateful Eight: Extended Version</td>\n",
       "      <td>Quentin Tarantino</td>\n",
       "      <td>Samuel L. Jackson, Kurt Russell, Jennifer Jaso...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>April 25, 2019</td>\n",
       "      <td>R</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>TV Shows</td>\n",
       "      <td>Trapped at a stagecoach stop as a storm rages ...</td>\n",
       "      <td>2019-04-25</td>\n",
       "      <td>2019.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Show_Id Category                                Title           Director  \\\n",
       "4497   s4498  TV Show                                Nobel                NaN   \n",
       "6437   s6436  TV Show  The Hateful Eight: Extended Version  Quentin Tarantino   \n",
       "\n",
       "                                                   Cast Country  \\\n",
       "4497  Aksel Hennie, Tuva Novotny, Anders Danielsen L...  Norway   \n",
       "6437  Samuel L. Jackson, Kurt Russell, Jennifer Jaso...     NaN   \n",
       "\n",
       "           Release_Date Rating  Duration  \\\n",
       "4497  December 10, 2016      R  1 Season   \n",
       "6437     April 25, 2019      R  1 Season   \n",
       "\n",
       "                                                 Type  \\\n",
       "4497  International TV Shows, TV Dramas, TV Thrillers   \n",
       "6437                                         TV Shows   \n",
       "\n",
       "                                            Description     Date_N    Year  \n",
       "4497  A series of incidents in Afghanistan set compl... 2016-12-10  2016.0  \n",
       "6437  Trapped at a stagecoach stop as a storm rages ... 2019-04-25  2019.0  "
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[(data['Category']=='TV Show') & (data['Rating']=='R')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "74aea79b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Show_Id</th>\n",
       "      <th>Category</th>\n",
       "      <th>Title</th>\n",
       "      <th>Director</th>\n",
       "      <th>Cast</th>\n",
       "      <th>Country</th>\n",
       "      <th>Release_Date</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Duration</th>\n",
       "      <th>Type</th>\n",
       "      <th>Description</th>\n",
       "      <th>Date_N</th>\n",
       "      <th>Year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>6437</th>\n",
       "      <td>s6436</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>The Hateful Eight: Extended Version</td>\n",
       "      <td>Quentin Tarantino</td>\n",
       "      <td>Samuel L. Jackson, Kurt Russell, Jennifer Jaso...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>April 25, 2019</td>\n",
       "      <td>R</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>TV Shows</td>\n",
       "      <td>Trapped at a stagecoach stop as a storm rages ...</td>\n",
       "      <td>2019-04-25</td>\n",
       "      <td>2019.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Show_Id Category                                Title           Director  \\\n",
       "6437   s6436  TV Show  The Hateful Eight: Extended Version  Quentin Tarantino   \n",
       "\n",
       "                                                   Cast Country  \\\n",
       "6437  Samuel L. Jackson, Kurt Russell, Jennifer Jaso...     NaN   \n",
       "\n",
       "        Release_Date Rating  Duration      Type  \\\n",
       "6437  April 25, 2019      R  1 Season  TV Shows   \n",
       "\n",
       "                                            Description     Date_N    Year  \n",
       "6437  Trapped at a stagecoach stop as a storm rages ... 2019-04-25  2019.0  "
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[(data['Category']=='TV Show') & (data['Rating']=='R') & (data['Year'] > 2018)]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "33b46072",
   "metadata": {},
   "source": [
    "# Q.10. What is the maximum duration of a Movie/Show on Netflix ?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "id": "d9c76320",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['4 Seasons', '93 min', '78 min', '80 min', '123 min', '1 Season',\n",
       "       '95 min', '119 min', '118 min', '143 min', '103 min', '89 min',\n",
       "       '91 min', '149 min', '144 min', '124 min', '87 min', '110 min',\n",
       "       '128 min', '117 min', '100 min', '2 Seasons', '84 min', '99 min',\n",
       "       '90 min', '102 min', '104 min', '105 min', '56 min', '125 min',\n",
       "       '81 min', '97 min', '106 min', '107 min', '109 min', '44 min',\n",
       "       '75 min', '101 min', '3 Seasons', '37 min', '113 min', '114 min',\n",
       "       '130 min', '94 min', '140 min', '135 min', '82 min', '70 min',\n",
       "       '121 min', '92 min', '164 min', '53 min', '83 min', '116 min',\n",
       "       '86 min', '120 min', '96 min', '126 min', '129 min', '77 min',\n",
       "       '137 min', '148 min', '28 min', '122 min', '176 min', '85 min',\n",
       "       '22 min', '68 min', '111 min', '29 min', '142 min', '168 min',\n",
       "       '21 min', '59 min', '20 min', '98 min', '108 min', '76 min',\n",
       "       '26 min', '156 min', '30 min', '57 min', '150 min', '133 min',\n",
       "       '115 min', '154 min', '127 min', '146 min', '136 min', '88 min',\n",
       "       '131 min', '24 min', '112 min', '74 min', '63 min', '38 min',\n",
       "       '25 min', '174 min', '60 min', '153 min', '158 min', '151 min',\n",
       "       '162 min', '54 min', '51 min', '69 min', '64 min', '147 min',\n",
       "       '42 min', '79 min', '5 Seasons', '40 min', '45 min', '172 min',\n",
       "       '10 min', '163 min', '9 Seasons', '55 min', '72 min', '61 min',\n",
       "       '71 min', '160 min', '171 min', '48 min', '139 min', '157 min',\n",
       "       '15 min', '65 min', '134 min', '161 min', '62 min', '8 Seasons',\n",
       "       '186 min', '49 min', '73 min', '58 min', '165 min', '166 min',\n",
       "       '138 min', '159 min', '141 min', '132 min', '52 min', '67 min',\n",
       "       '34 min', '66 min', '312 min', '180 min', '47 min', '6 Seasons',\n",
       "       '155 min', '14 min', '177 min', '11 min', '9 min', '46 min',\n",
       "       '145 min', '11 Seasons', '7 Seasons', '13 Seasons', '8 min',\n",
       "       '12 min', '12 Seasons', '10 Seasons', '43 min', '50 min', '23 min',\n",
       "       '185 min', '200 min', '169 min', '27 min', '170 min', '196 min',\n",
       "       '33 min', '181 min', '204 min', '32 min', '35 min', '167 min',\n",
       "       '16 Seasons', '179 min', '193 min', '13 min', '214 min', '17 min',\n",
       "       '173 min', '192 min', '209 min', '187 min', '41 min', '182 min',\n",
       "       '224 min', '233 min', '189 min', '152 min', '19 min', '15 Seasons',\n",
       "       '208 min', '237 min', '31 min', '178 min', '230 min', '194 min',\n",
       "       '228 min', '195 min', '3 min', '16 min', '5 min', '18 min',\n",
       "       '205 min', '190 min', '36 min', '201 min', '253 min', '203 min',\n",
       "       '191 min'], dtype=object)"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.Duration.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "3a95bcc0",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dtype('O')"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.Duration.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "id": "3516864c",
   "metadata": {},
   "outputs": [],
   "source": [
    "data[['Minutes', 'Unit']] = data['Duration'].str.split(' ', expand = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "id": "3cf277f4",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Show_Id</th>\n",
       "      <th>Category</th>\n",
       "      <th>Title</th>\n",
       "      <th>Director</th>\n",
       "      <th>Cast</th>\n",
       "      <th>Country</th>\n",
       "      <th>Release_Date</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Duration</th>\n",
       "      <th>Type</th>\n",
       "      <th>Description</th>\n",
       "      <th>Date_N</th>\n",
       "      <th>Year</th>\n",
       "      <th>Minutes</th>\n",
       "      <th>Unit</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>s1</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>3%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>João Miguel, Bianca Comparato, Michel Gomes, R...</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>August 14, 2020</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>4 Seasons</td>\n",
       "      <td>International TV Shows, TV Dramas, TV Sci-Fi &amp;...</td>\n",
       "      <td>In a future where the elite inhabit an island ...</td>\n",
       "      <td>2020-08-14</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>4</td>\n",
       "      <td>Seasons</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>s2</td>\n",
       "      <td>Movie</td>\n",
       "      <td>07:19</td>\n",
       "      <td>Jorge Michel Grau</td>\n",
       "      <td>Demián Bichir, Héctor Bonilla, Oscar Serrano, ...</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>December 23, 2016</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>93 min</td>\n",
       "      <td>Dramas, International Movies</td>\n",
       "      <td>After a devastating earthquake hits Mexico Cit...</td>\n",
       "      <td>2016-12-23</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>93</td>\n",
       "      <td>min</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Show_Id Category  Title           Director  \\\n",
       "0      s1  TV Show     3%                NaN   \n",
       "1      s2    Movie  07:19  Jorge Michel Grau   \n",
       "\n",
       "                                                Cast Country  \\\n",
       "0  João Miguel, Bianca Comparato, Michel Gomes, R...  Brazil   \n",
       "1  Demián Bichir, Héctor Bonilla, Oscar Serrano, ...  Mexico   \n",
       "\n",
       "        Release_Date Rating   Duration  \\\n",
       "0    August 14, 2020  TV-MA  4 Seasons   \n",
       "1  December 23, 2016  TV-MA     93 min   \n",
       "\n",
       "                                                Type  \\\n",
       "0  International TV Shows, TV Dramas, TV Sci-Fi &...   \n",
       "1                       Dramas, International Movies   \n",
       "\n",
       "                                         Description     Date_N    Year  \\\n",
       "0  In a future where the elite inhabit an island ... 2020-08-14  2020.0   \n",
       "1  After a devastating earthquake hits Mexico Cit... 2016-12-23  2016.0   \n",
       "\n",
       "  Minutes     Unit  \n",
       "0       4  Seasons  \n",
       "1      93      min  "
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "id": "b531cd98",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'99'"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['Minutes'].max()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "id": "f162ec88",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'1'"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['Minutes'].min()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "id": "987f5feb",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "inf"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['Minutes'].mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "id": "4e74397d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Show_Id                 object\n",
       "Category                object\n",
       "Title                   object\n",
       "Director                object\n",
       "Cast                    object\n",
       "Country                 object\n",
       "Release_Date            object\n",
       "Rating                  object\n",
       "Duration                object\n",
       "Type                    object\n",
       "Description             object\n",
       "Date_N          datetime64[ns]\n",
       "Year                   float64\n",
       "Minutes                 object\n",
       "Unit                    object\n",
       "dtype: object"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.dtypes"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "381fc525",
   "metadata": {},
   "source": [
    "# Q.11. Which individual country has the Highest No. of TV Shows ?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "id": "4d0fa45c",
   "metadata": {},
   "outputs": [],
   "source": [
    "data_tvshow = data[data['Category'] == 'TV Show']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "id": "50b524f6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "United States     705\n",
       "United Kingdom    204\n",
       "Japan             157\n",
       "Name: Country, dtype: int64"
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_tvshow.Country.value_counts().head(3)\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "05ad71ed",
   "metadata": {},
   "source": [
    "# Q.12. How can we sort the dataset by Year ?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "id": "c0e41ad8",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Show_Id</th>\n",
       "      <th>Category</th>\n",
       "      <th>Title</th>\n",
       "      <th>Director</th>\n",
       "      <th>Cast</th>\n",
       "      <th>Country</th>\n",
       "      <th>Release_Date</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Duration</th>\n",
       "      <th>Type</th>\n",
       "      <th>Description</th>\n",
       "      <th>Date_N</th>\n",
       "      <th>Year</th>\n",
       "      <th>Minutes</th>\n",
       "      <th>Unit</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>7115</th>\n",
       "      <td>s7114</td>\n",
       "      <td>Movie</td>\n",
       "      <td>To and From New York</td>\n",
       "      <td>Sorin Dan Mihalcescu</td>\n",
       "      <td>Barbara King, Shaana Diya, John Krisiukenas, Y...</td>\n",
       "      <td>United States</td>\n",
       "      <td>January 1, 2008</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>81 min</td>\n",
       "      <td>Dramas, Independent Movies, Thrillers</td>\n",
       "      <td>While covering a story in New York City, a Sea...</td>\n",
       "      <td>2008-01-01</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>81</td>\n",
       "      <td>min</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1765</th>\n",
       "      <td>s1766</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Dinner for Five</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States</td>\n",
       "      <td>February 4, 2008</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>Stand-Up Comedy &amp; Talk Shows</td>\n",
       "      <td>In each episode, four celebrities join host Jo...</td>\n",
       "      <td>2008-02-04</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Season</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3248</th>\n",
       "      <td>s3249</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Just Another Love Story</td>\n",
       "      <td>Ole Bornedal</td>\n",
       "      <td>Anders W. Berthelsen, Rebecka Hemse, Nikolaj L...</td>\n",
       "      <td>Denmark</td>\n",
       "      <td>May 5, 2009</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>104 min</td>\n",
       "      <td>Dramas, International Movies</td>\n",
       "      <td>When he causes a car accident that leaves a yo...</td>\n",
       "      <td>2009-05-05</td>\n",
       "      <td>2009.0</td>\n",
       "      <td>104</td>\n",
       "      <td>min</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5766</th>\n",
       "      <td>s5766</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Splatter</td>\n",
       "      <td>Joe Dante</td>\n",
       "      <td>Corey Feldman, Tony Todd, Tara Leigh, Erin Way...</td>\n",
       "      <td>United States</td>\n",
       "      <td>November 18, 2009</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>29 min</td>\n",
       "      <td>Horror Movies</td>\n",
       "      <td>After committing suicide, a washed-up rocker r...</td>\n",
       "      <td>2009-11-18</td>\n",
       "      <td>2009.0</td>\n",
       "      <td>29</td>\n",
       "      <td>min</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3840</th>\n",
       "      <td>s3841</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Mad Ron's Prevues from Hell</td>\n",
       "      <td>Jim Monaco</td>\n",
       "      <td>Nick Pawlow, Jordu Schell, Jay Kushwara, Micha...</td>\n",
       "      <td>United States</td>\n",
       "      <td>November 1, 2010</td>\n",
       "      <td>NR</td>\n",
       "      <td>84 min</td>\n",
       "      <td>Cult Movies, Horror Movies</td>\n",
       "      <td>This collection cherry-picks trailers, forgott...</td>\n",
       "      <td>2010-11-01</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>84</td>\n",
       "      <td>min</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>3374</th>\n",
       "      <td>s3375</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Kikoriki</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Igor Dmitriev</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TV-Y</td>\n",
       "      <td>2 Seasons</td>\n",
       "      <td>Kids' TV</td>\n",
       "      <td>A wacky rabbit and his gang of animal pals hav...</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>Seasons</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3492</th>\n",
       "      <td>s3493</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>La Familia P. Luche</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Eugenio Derbez, Consuelo Duval, Luis Manuel Áv...</td>\n",
       "      <td>United States</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>3 Seasons</td>\n",
       "      <td>International TV Shows, Spanish-Language TV Sh...</td>\n",
       "      <td>This irreverent sitcom featues Ludovico, Feder...</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>Seasons</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3946</th>\n",
       "      <td>s3947</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Maron</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Marc Maron, Judd Hirsch, Josh Brener, Nora Zeh...</td>\n",
       "      <td>United States</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>4 Seasons</td>\n",
       "      <td>TV Comedies</td>\n",
       "      <td>Marc Maron stars as Marc Maron, who interviews...</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>Seasons</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5138</th>\n",
       "      <td>s5138</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Red vs. Blue</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Burnie Burns, Jason Saldaña, Gustavo Sorola, G...</td>\n",
       "      <td>United States</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>13 Seasons</td>\n",
       "      <td>TV Action &amp; Adventure, TV Comedies, TV Sci-Fi ...</td>\n",
       "      <td>This parody of first-person shooter games, mil...</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13</td>\n",
       "      <td>Seasons</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6066</th>\n",
       "      <td>s6066</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>The Adventures of Figaro Pho</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Luke Jurevicius, Craig Behenna, Charlotte Haml...</td>\n",
       "      <td>Australia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TV-Y7</td>\n",
       "      <td>2 Seasons</td>\n",
       "      <td>Kids' TV, TV Comedies</td>\n",
       "      <td>Imagine your worst fears, then multiply them: ...</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>Seasons</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7787 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Show_Id Category                         Title              Director  \\\n",
       "7115   s7114    Movie          To and From New York  Sorin Dan Mihalcescu   \n",
       "1765   s1766  TV Show               Dinner for Five                   NaN   \n",
       "3248   s3249    Movie       Just Another Love Story          Ole Bornedal   \n",
       "5766   s5766    Movie                      Splatter             Joe Dante   \n",
       "3840   s3841    Movie   Mad Ron's Prevues from Hell            Jim Monaco   \n",
       "...      ...      ...                           ...                   ...   \n",
       "3374   s3375  TV Show                      Kikoriki                   NaN   \n",
       "3492   s3493  TV Show           La Familia P. Luche                   NaN   \n",
       "3946   s3947  TV Show                         Maron                   NaN   \n",
       "5138   s5138  TV Show                  Red vs. Blue                   NaN   \n",
       "6066   s6066  TV Show  The Adventures of Figaro Pho                   NaN   \n",
       "\n",
       "                                                   Cast        Country  \\\n",
       "7115  Barbara King, Shaana Diya, John Krisiukenas, Y...  United States   \n",
       "1765                                                NaN  United States   \n",
       "3248  Anders W. Berthelsen, Rebecka Hemse, Nikolaj L...        Denmark   \n",
       "5766  Corey Feldman, Tony Todd, Tara Leigh, Erin Way...  United States   \n",
       "3840  Nick Pawlow, Jordu Schell, Jay Kushwara, Micha...  United States   \n",
       "...                                                 ...            ...   \n",
       "3374                                      Igor Dmitriev            NaN   \n",
       "3492  Eugenio Derbez, Consuelo Duval, Luis Manuel Áv...  United States   \n",
       "3946  Marc Maron, Judd Hirsch, Josh Brener, Nora Zeh...  United States   \n",
       "5138  Burnie Burns, Jason Saldaña, Gustavo Sorola, G...  United States   \n",
       "6066  Luke Jurevicius, Craig Behenna, Charlotte Haml...      Australia   \n",
       "\n",
       "           Release_Date Rating    Duration  \\\n",
       "7115    January 1, 2008  TV-MA      81 min   \n",
       "1765   February 4, 2008  TV-MA    1 Season   \n",
       "3248        May 5, 2009  TV-MA     104 min   \n",
       "5766  November 18, 2009  TV-MA      29 min   \n",
       "3840   November 1, 2010     NR      84 min   \n",
       "...                 ...    ...         ...   \n",
       "3374                NaN   TV-Y   2 Seasons   \n",
       "3492                NaN  TV-14   3 Seasons   \n",
       "3946                NaN  TV-MA   4 Seasons   \n",
       "5138                NaN     NR  13 Seasons   \n",
       "6066                NaN  TV-Y7   2 Seasons   \n",
       "\n",
       "                                                   Type  \\\n",
       "7115              Dramas, Independent Movies, Thrillers   \n",
       "1765                       Stand-Up Comedy & Talk Shows   \n",
       "3248                       Dramas, International Movies   \n",
       "5766                                      Horror Movies   \n",
       "3840                         Cult Movies, Horror Movies   \n",
       "...                                                 ...   \n",
       "3374                                           Kids' TV   \n",
       "3492  International TV Shows, Spanish-Language TV Sh...   \n",
       "3946                                        TV Comedies   \n",
       "5138  TV Action & Adventure, TV Comedies, TV Sci-Fi ...   \n",
       "6066                              Kids' TV, TV Comedies   \n",
       "\n",
       "                                            Description     Date_N    Year  \\\n",
       "7115  While covering a story in New York City, a Sea... 2008-01-01  2008.0   \n",
       "1765  In each episode, four celebrities join host Jo... 2008-02-04  2008.0   \n",
       "3248  When he causes a car accident that leaves a yo... 2009-05-05  2009.0   \n",
       "5766  After committing suicide, a washed-up rocker r... 2009-11-18  2009.0   \n",
       "3840  This collection cherry-picks trailers, forgott... 2010-11-01  2010.0   \n",
       "...                                                 ...        ...     ...   \n",
       "3374  A wacky rabbit and his gang of animal pals hav...        NaT     NaN   \n",
       "3492  This irreverent sitcom featues Ludovico, Feder...        NaT     NaN   \n",
       "3946  Marc Maron stars as Marc Maron, who interviews...        NaT     NaN   \n",
       "5138  This parody of first-person shooter games, mil...        NaT     NaN   \n",
       "6066  Imagine your worst fears, then multiply them: ...        NaT     NaN   \n",
       "\n",
       "     Minutes     Unit  \n",
       "7115      81      min  \n",
       "1765       1   Season  \n",
       "3248     104      min  \n",
       "5766      29      min  \n",
       "3840      84      min  \n",
       "...      ...      ...  \n",
       "3374       2  Seasons  \n",
       "3492       3  Seasons  \n",
       "3946       4  Seasons  \n",
       "5138      13  Seasons  \n",
       "6066       2  Seasons  \n",
       "\n",
       "[7787 rows x 15 columns]"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.sort_values(by = 'Year')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "id": "f701516a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Show_Id</th>\n",
       "      <th>Category</th>\n",
       "      <th>Title</th>\n",
       "      <th>Director</th>\n",
       "      <th>Cast</th>\n",
       "      <th>Country</th>\n",
       "      <th>Release_Date</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Duration</th>\n",
       "      <th>Type</th>\n",
       "      <th>Description</th>\n",
       "      <th>Date_N</th>\n",
       "      <th>Year</th>\n",
       "      <th>Minutes</th>\n",
       "      <th>Unit</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>5564</th>\n",
       "      <td>s5564</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Sherlock Holmes</td>\n",
       "      <td>Guy Ritchie</td>\n",
       "      <td>Robert Downey Jr., Jude Law, Rachel McAdams, M...</td>\n",
       "      <td>United States, Germany, United Kingdom, Australia</td>\n",
       "      <td>January 1, 2021</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>128 min</td>\n",
       "      <td>Action &amp; Adventure, Comedies</td>\n",
       "      <td>The game is afoot for an eccentric detective w...</td>\n",
       "      <td>2021-01-01</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>128</td>\n",
       "      <td>min</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5919</th>\n",
       "      <td>s5919</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Surf's Up</td>\n",
       "      <td>Ash Brannon, Chris Buck</td>\n",
       "      <td>Shia LaBeouf, Jeff Bridges, Zooey Deschanel, J...</td>\n",
       "      <td>United States</td>\n",
       "      <td>January 1, 2021</td>\n",
       "      <td>PG</td>\n",
       "      <td>86 min</td>\n",
       "      <td>Children &amp; Family Movies, Comedies, Sports Movies</td>\n",
       "      <td>This Oscar-nominated animated comedy goes behi...</td>\n",
       "      <td>2021-01-01</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>86</td>\n",
       "      <td>min</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>980</th>\n",
       "      <td>s981</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Bling Empire</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>January 15, 2021</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>Reality TV</td>\n",
       "      <td>Follow LA's wildly wealthy Asian and Asian Ame...</td>\n",
       "      <td>2021-01-15</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Season</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5955</th>\n",
       "      <td>s5955</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Taare Zameen Par</td>\n",
       "      <td>Aamir Khan</td>\n",
       "      <td>Aamir Khan, Darsheel Safary, Tanay Chheda, Tis...</td>\n",
       "      <td>India</td>\n",
       "      <td>January 10, 2021</td>\n",
       "      <td>PG</td>\n",
       "      <td>162 min</td>\n",
       "      <td>Dramas, International Movies</td>\n",
       "      <td>When daydreamer Ishaan is sent to boarding sch...</td>\n",
       "      <td>2021-01-10</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>162</td>\n",
       "      <td>min</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>366</th>\n",
       "      <td>s367</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Al acecho</td>\n",
       "      <td>Francisco D'Eufemia</td>\n",
       "      <td>Rodrigo de la Serna, Belen Blanco, Walter Jako...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>January 12, 2021</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>81 min</td>\n",
       "      <td>International Movies, Thrillers</td>\n",
       "      <td>Looking for a fresh start, a park ranger gets ...</td>\n",
       "      <td>2021-01-12</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>81</td>\n",
       "      <td>min</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>560</th>\n",
       "      <td>s561</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Apaharan</td>\n",
       "      <td>Prakash Jha</td>\n",
       "      <td>Ajay Devgn, Nana Patekar, Bipasha Basu, Ayub K...</td>\n",
       "      <td>India</td>\n",
       "      <td>January 8, 2021</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>161 min</td>\n",
       "      <td>Dramas, International Movies</td>\n",
       "      <td>Raised under the condescending eye of his acti...</td>\n",
       "      <td>2021-01-08</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>161</td>\n",
       "      <td>min</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1355</th>\n",
       "      <td>s1356</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Chris Rock Total Blackout: The Tamborine Exten...</td>\n",
       "      <td>Chris Rock</td>\n",
       "      <td>Chris Rock</td>\n",
       "      <td>NaN</td>\n",
       "      <td>January 12, 2021</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>98 min</td>\n",
       "      <td>Stand-Up Comedy</td>\n",
       "      <td>In this extended cut of his 2018 special, Chri...</td>\n",
       "      <td>2021-01-12</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>98</td>\n",
       "      <td>min</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5922</th>\n",
       "      <td>s5922</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Surviving Death</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States</td>\n",
       "      <td>January 6, 2021</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>Docuseries, Reality TV</td>\n",
       "      <td>What happens after we die? This docuseries exp...</td>\n",
       "      <td>2021-01-06</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Season</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4269</th>\n",
       "      <td>s4270</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Mud</td>\n",
       "      <td>Jeff Nichols</td>\n",
       "      <td>Matthew McConaughey, Reese Witherspoon, Tye Sh...</td>\n",
       "      <td>United States</td>\n",
       "      <td>January 1, 2021</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>131 min</td>\n",
       "      <td>Dramas, Independent Movies</td>\n",
       "      <td>Two Mississippi teens meet peculiar drifter Mu...</td>\n",
       "      <td>2021-01-01</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>131</td>\n",
       "      <td>min</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2799</th>\n",
       "      <td>s2800</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Hook</td>\n",
       "      <td>Steven Spielberg</td>\n",
       "      <td>Dustin Hoffman, Robin Williams, Julia Roberts,...</td>\n",
       "      <td>United States</td>\n",
       "      <td>January 15, 2021</td>\n",
       "      <td>PG</td>\n",
       "      <td>142 min</td>\n",
       "      <td>Children &amp; Family Movies</td>\n",
       "      <td>Peter Pan, now grown up and a workaholic, must...</td>\n",
       "      <td>2021-01-15</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>142</td>\n",
       "      <td>min</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Show_Id Category                                              Title  \\\n",
       "5564   s5564    Movie                                    Sherlock Holmes   \n",
       "5919   s5919    Movie                                          Surf's Up   \n",
       "980     s981  TV Show                                       Bling Empire   \n",
       "5955   s5955    Movie                                   Taare Zameen Par   \n",
       "366     s367    Movie                                          Al acecho   \n",
       "560     s561    Movie                                           Apaharan   \n",
       "1355   s1356    Movie  Chris Rock Total Blackout: The Tamborine Exten...   \n",
       "5922   s5922  TV Show                                    Surviving Death   \n",
       "4269   s4270    Movie                                                Mud   \n",
       "2799   s2800    Movie                                               Hook   \n",
       "\n",
       "                     Director  \\\n",
       "5564              Guy Ritchie   \n",
       "5919  Ash Brannon, Chris Buck   \n",
       "980                       NaN   \n",
       "5955               Aamir Khan   \n",
       "366       Francisco D'Eufemia   \n",
       "560               Prakash Jha   \n",
       "1355               Chris Rock   \n",
       "5922                      NaN   \n",
       "4269             Jeff Nichols   \n",
       "2799         Steven Spielberg   \n",
       "\n",
       "                                                   Cast  \\\n",
       "5564  Robert Downey Jr., Jude Law, Rachel McAdams, M...   \n",
       "5919  Shia LaBeouf, Jeff Bridges, Zooey Deschanel, J...   \n",
       "980                                                 NaN   \n",
       "5955  Aamir Khan, Darsheel Safary, Tanay Chheda, Tis...   \n",
       "366   Rodrigo de la Serna, Belen Blanco, Walter Jako...   \n",
       "560   Ajay Devgn, Nana Patekar, Bipasha Basu, Ayub K...   \n",
       "1355                                         Chris Rock   \n",
       "5922                                                NaN   \n",
       "4269  Matthew McConaughey, Reese Witherspoon, Tye Sh...   \n",
       "2799  Dustin Hoffman, Robin Williams, Julia Roberts,...   \n",
       "\n",
       "                                                Country      Release_Date  \\\n",
       "5564  United States, Germany, United Kingdom, Australia   January 1, 2021   \n",
       "5919                                      United States   January 1, 2021   \n",
       "980                                                 NaN  January 15, 2021   \n",
       "5955                                              India  January 10, 2021   \n",
       "366                                                 NaN  January 12, 2021   \n",
       "560                                               India   January 8, 2021   \n",
       "1355                                                NaN  January 12, 2021   \n",
       "5922                                      United States   January 6, 2021   \n",
       "4269                                      United States   January 1, 2021   \n",
       "2799                                      United States  January 15, 2021   \n",
       "\n",
       "     Rating  Duration                                               Type  \\\n",
       "5564  PG-13   128 min                       Action & Adventure, Comedies   \n",
       "5919     PG    86 min  Children & Family Movies, Comedies, Sports Movies   \n",
       "980   TV-MA  1 Season                                         Reality TV   \n",
       "5955     PG   162 min                       Dramas, International Movies   \n",
       "366   TV-MA    81 min                    International Movies, Thrillers   \n",
       "560   TV-14   161 min                       Dramas, International Movies   \n",
       "1355  TV-MA    98 min                                    Stand-Up Comedy   \n",
       "5922  TV-MA  1 Season                             Docuseries, Reality TV   \n",
       "4269  PG-13   131 min                         Dramas, Independent Movies   \n",
       "2799     PG   142 min                           Children & Family Movies   \n",
       "\n",
       "                                            Description     Date_N    Year  \\\n",
       "5564  The game is afoot for an eccentric detective w... 2021-01-01  2021.0   \n",
       "5919  This Oscar-nominated animated comedy goes behi... 2021-01-01  2021.0   \n",
       "980   Follow LA's wildly wealthy Asian and Asian Ame... 2021-01-15  2021.0   \n",
       "5955  When daydreamer Ishaan is sent to boarding sch... 2021-01-10  2021.0   \n",
       "366   Looking for a fresh start, a park ranger gets ... 2021-01-12  2021.0   \n",
       "560   Raised under the condescending eye of his acti... 2021-01-08  2021.0   \n",
       "1355  In this extended cut of his 2018 special, Chri... 2021-01-12  2021.0   \n",
       "5922  What happens after we die? This docuseries exp... 2021-01-06  2021.0   \n",
       "4269  Two Mississippi teens meet peculiar drifter Mu... 2021-01-01  2021.0   \n",
       "2799  Peter Pan, now grown up and a workaholic, must... 2021-01-15  2021.0   \n",
       "\n",
       "     Minutes    Unit  \n",
       "5564     128     min  \n",
       "5919      86     min  \n",
       "980        1  Season  \n",
       "5955     162     min  \n",
       "366       81     min  \n",
       "560      161     min  \n",
       "1355      98     min  \n",
       "5922       1  Season  \n",
       "4269     131     min  \n",
       "2799     142     min  "
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.sort_values(by = 'Year', ascending = False).head(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ea6376f7",
   "metadata": {},
   "source": [
    "# Q.13. Find all the instances where : \n",
    "### Category is 'Movie' and Type is 'Dramas'\n",
    "###  Category is 'TV Show' & Type is 'Kids' TV'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "id": "e01af801",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Show_Id</th>\n",
       "      <th>Category</th>\n",
       "      <th>Title</th>\n",
       "      <th>Director</th>\n",
       "      <th>Cast</th>\n",
       "      <th>Country</th>\n",
       "      <th>Release_Date</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Duration</th>\n",
       "      <th>Type</th>\n",
       "      <th>Description</th>\n",
       "      <th>Date_N</th>\n",
       "      <th>Year</th>\n",
       "      <th>Minutes</th>\n",
       "      <th>Unit</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>s5</td>\n",
       "      <td>Movie</td>\n",
       "      <td>21</td>\n",
       "      <td>Robert Luketic</td>\n",
       "      <td>Jim Sturgess, Kevin Spacey, Kate Bosworth, Aar...</td>\n",
       "      <td>United States</td>\n",
       "      <td>January 1, 2020</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>123 min</td>\n",
       "      <td>Dramas</td>\n",
       "      <td>A brilliant group of students become card-coun...</td>\n",
       "      <td>2020-01-01</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>123</td>\n",
       "      <td>min</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>s8</td>\n",
       "      <td>Movie</td>\n",
       "      <td>187</td>\n",
       "      <td>Kevin Reynolds</td>\n",
       "      <td>Samuel L. Jackson, John Heard, Kelly Rowan, Cl...</td>\n",
       "      <td>United States</td>\n",
       "      <td>November 1, 2019</td>\n",
       "      <td>R</td>\n",
       "      <td>119 min</td>\n",
       "      <td>Dramas</td>\n",
       "      <td>After one of his high school students attacks ...</td>\n",
       "      <td>2019-11-01</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>119</td>\n",
       "      <td>min</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Show_Id Category Title        Director  \\\n",
       "4      s5    Movie    21  Robert Luketic   \n",
       "7      s8    Movie   187  Kevin Reynolds   \n",
       "\n",
       "                                                Cast        Country  \\\n",
       "4  Jim Sturgess, Kevin Spacey, Kate Bosworth, Aar...  United States   \n",
       "7  Samuel L. Jackson, John Heard, Kelly Rowan, Cl...  United States   \n",
       "\n",
       "       Release_Date Rating Duration    Type  \\\n",
       "4   January 1, 2020  PG-13  123 min  Dramas   \n",
       "7  November 1, 2019      R  119 min  Dramas   \n",
       "\n",
       "                                         Description     Date_N    Year  \\\n",
       "4  A brilliant group of students become card-coun... 2020-01-01  2020.0   \n",
       "7  After one of his high school students attacks ... 2019-11-01  2019.0   \n",
       "\n",
       "  Minutes Unit  \n",
       "4     123  min  \n",
       "7     119  min  "
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data [ (data['Category']=='Movie') & (data['Type']=='Dramas') ].head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "id": "626687a4",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Show_Id</th>\n",
       "      <th>Category</th>\n",
       "      <th>Title</th>\n",
       "      <th>Director</th>\n",
       "      <th>Cast</th>\n",
       "      <th>Country</th>\n",
       "      <th>Release_Date</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Duration</th>\n",
       "      <th>Type</th>\n",
       "      <th>Description</th>\n",
       "      <th>Date_N</th>\n",
       "      <th>Year</th>\n",
       "      <th>Minutes</th>\n",
       "      <th>Unit</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>s112</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>44 Cats</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sarah Natochenny, Suzy Myers, Simona Berman, E...</td>\n",
       "      <td>Italy</td>\n",
       "      <td>October 1, 2020</td>\n",
       "      <td>TV-Y7</td>\n",
       "      <td>2 Seasons</td>\n",
       "      <td>Kids' TV</td>\n",
       "      <td>Paw-esome tales abound when singing furry frie...</td>\n",
       "      <td>2020-10-01</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>2</td>\n",
       "      <td>Seasons</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276</th>\n",
       "      <td>s277</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Abby Hatcher</td>\n",
       "      <td>Kyran Kelly</td>\n",
       "      <td>Macy Drouin, Wyatt White, Paul Sun-Hyung Lee, ...</td>\n",
       "      <td>United States, Canada</td>\n",
       "      <td>July 1, 2020</td>\n",
       "      <td>TV-Y</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>Kids' TV</td>\n",
       "      <td>A big-hearted girl helps her Fuzzly friends wh...</td>\n",
       "      <td>2020-07-01</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Season</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>434</th>\n",
       "      <td>s435</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Alphablocks</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Teresa Gallagher, David Holt, Lizzie Waterworth</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>May 25, 2020</td>\n",
       "      <td>TV-Y</td>\n",
       "      <td>5 Seasons</td>\n",
       "      <td>Kids' TV</td>\n",
       "      <td>The letters of the alphabet come to life in Al...</td>\n",
       "      <td>2020-05-25</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>5</td>\n",
       "      <td>Seasons</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>598</th>\n",
       "      <td>s599</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Ask the StoryBots</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Judy Greer, Erin Fitzgerald, Fred Tatasciore, ...</td>\n",
       "      <td>United States</td>\n",
       "      <td>August 2, 2019</td>\n",
       "      <td>TV-Y</td>\n",
       "      <td>3 Seasons</td>\n",
       "      <td>Kids' TV</td>\n",
       "      <td>Five curious little creatures track down the a...</td>\n",
       "      <td>2019-08-02</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>3</td>\n",
       "      <td>Seasons</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>706</th>\n",
       "      <td>s707</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Bal Ganesh</td>\n",
       "      <td>Vijay S. Bhanushali</td>\n",
       "      <td>Meghna Erande Joshi, Parminder Ghumman</td>\n",
       "      <td>NaN</td>\n",
       "      <td>March 31, 2020</td>\n",
       "      <td>TV-Y7</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>Kids' TV</td>\n",
       "      <td>Watch Ganesh destroy demons, disarm invaders a...</td>\n",
       "      <td>2020-03-31</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Season</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>7668</th>\n",
       "      <td>s7667</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>World of Winx</td>\n",
       "      <td>Iginio Straffi</td>\n",
       "      <td>Haven Paschall, Alysha Deslorieux, Jessica Paq...</td>\n",
       "      <td>Italy, United States</td>\n",
       "      <td>June 16, 2017</td>\n",
       "      <td>TV-Y7</td>\n",
       "      <td>2 Seasons</td>\n",
       "      <td>Kids' TV</td>\n",
       "      <td>The reality show \"WOW!\" engages the Winx in th...</td>\n",
       "      <td>2017-06-16</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>2</td>\n",
       "      <td>Seasons</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7717</th>\n",
       "      <td>s7716</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Yoko</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Eileen Stevens, Alyson Leigh Rosenfeld, Sarah ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>June 23, 2018</td>\n",
       "      <td>TV-Y</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>Kids' TV</td>\n",
       "      <td>Friends Mai, Oto and Vik's games at the park b...</td>\n",
       "      <td>2018-06-23</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Season</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7719</th>\n",
       "      <td>s7718</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>YOM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sairaj, Devyani Dagaonkar, Ketan Singh, Mayur ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>June 7, 2018</td>\n",
       "      <td>TV-Y7</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>Kids' TV</td>\n",
       "      <td>With the mind of a human being, and the body o...</td>\n",
       "      <td>2018-06-07</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Season</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7758</th>\n",
       "      <td>s7757</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Z4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Apollo Costa, Gabriel Santana, Matheus Lustosa...</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>February 22, 2019</td>\n",
       "      <td>TV-PG</td>\n",
       "      <td>2 Seasons</td>\n",
       "      <td>Kids' TV</td>\n",
       "      <td>Fading music biz veteran Zé realizes he has ju...</td>\n",
       "      <td>2019-02-22</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>2</td>\n",
       "      <td>Seasons</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7761</th>\n",
       "      <td>s7760</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Zak Storm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Michael Johnston, Jessica Gee-George, Christin...</td>\n",
       "      <td>United States, France, South Korea, Indonesia</td>\n",
       "      <td>September 13, 2018</td>\n",
       "      <td>TV-Y7</td>\n",
       "      <td>3 Seasons</td>\n",
       "      <td>Kids' TV</td>\n",
       "      <td>Teen surfer Zak Storm is mysteriously transpor...</td>\n",
       "      <td>2018-09-13</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>3</td>\n",
       "      <td>Seasons</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>205 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Show_Id Category              Title             Director  \\\n",
       "111     s112  TV Show            44 Cats                  NaN   \n",
       "276     s277  TV Show       Abby Hatcher          Kyran Kelly   \n",
       "434     s435  TV Show        Alphablocks                  NaN   \n",
       "598     s599  TV Show  Ask the StoryBots                  NaN   \n",
       "706     s707  TV Show         Bal Ganesh  Vijay S. Bhanushali   \n",
       "...      ...      ...                ...                  ...   \n",
       "7668   s7667  TV Show      World of Winx       Iginio Straffi   \n",
       "7717   s7716  TV Show               Yoko                  NaN   \n",
       "7719   s7718  TV Show                YOM                  NaN   \n",
       "7758   s7757  TV Show                 Z4                  NaN   \n",
       "7761   s7760  TV Show          Zak Storm                  NaN   \n",
       "\n",
       "                                                   Cast  \\\n",
       "111   Sarah Natochenny, Suzy Myers, Simona Berman, E...   \n",
       "276   Macy Drouin, Wyatt White, Paul Sun-Hyung Lee, ...   \n",
       "434     Teresa Gallagher, David Holt, Lizzie Waterworth   \n",
       "598   Judy Greer, Erin Fitzgerald, Fred Tatasciore, ...   \n",
       "706              Meghna Erande Joshi, Parminder Ghumman   \n",
       "...                                                 ...   \n",
       "7668  Haven Paschall, Alysha Deslorieux, Jessica Paq...   \n",
       "7717  Eileen Stevens, Alyson Leigh Rosenfeld, Sarah ...   \n",
       "7719  Sairaj, Devyani Dagaonkar, Ketan Singh, Mayur ...   \n",
       "7758  Apollo Costa, Gabriel Santana, Matheus Lustosa...   \n",
       "7761  Michael Johnston, Jessica Gee-George, Christin...   \n",
       "\n",
       "                                            Country        Release_Date  \\\n",
       "111                                           Italy     October 1, 2020   \n",
       "276                           United States, Canada        July 1, 2020   \n",
       "434                                  United Kingdom        May 25, 2020   \n",
       "598                                   United States      August 2, 2019   \n",
       "706                                             NaN      March 31, 2020   \n",
       "...                                             ...                 ...   \n",
       "7668                           Italy, United States       June 16, 2017   \n",
       "7717                                            NaN       June 23, 2018   \n",
       "7719                                            NaN        June 7, 2018   \n",
       "7758                                         Brazil   February 22, 2019   \n",
       "7761  United States, France, South Korea, Indonesia  September 13, 2018   \n",
       "\n",
       "     Rating   Duration      Type  \\\n",
       "111   TV-Y7  2 Seasons  Kids' TV   \n",
       "276    TV-Y   1 Season  Kids' TV   \n",
       "434    TV-Y  5 Seasons  Kids' TV   \n",
       "598    TV-Y  3 Seasons  Kids' TV   \n",
       "706   TV-Y7   1 Season  Kids' TV   \n",
       "...     ...        ...       ...   \n",
       "7668  TV-Y7  2 Seasons  Kids' TV   \n",
       "7717   TV-Y   1 Season  Kids' TV   \n",
       "7719  TV-Y7   1 Season  Kids' TV   \n",
       "7758  TV-PG  2 Seasons  Kids' TV   \n",
       "7761  TV-Y7  3 Seasons  Kids' TV   \n",
       "\n",
       "                                            Description     Date_N    Year  \\\n",
       "111   Paw-esome tales abound when singing furry frie... 2020-10-01  2020.0   \n",
       "276   A big-hearted girl helps her Fuzzly friends wh... 2020-07-01  2020.0   \n",
       "434   The letters of the alphabet come to life in Al... 2020-05-25  2020.0   \n",
       "598   Five curious little creatures track down the a... 2019-08-02  2019.0   \n",
       "706   Watch Ganesh destroy demons, disarm invaders a... 2020-03-31  2020.0   \n",
       "...                                                 ...        ...     ...   \n",
       "7668  The reality show \"WOW!\" engages the Winx in th... 2017-06-16  2017.0   \n",
       "7717  Friends Mai, Oto and Vik's games at the park b... 2018-06-23  2018.0   \n",
       "7719  With the mind of a human being, and the body o... 2018-06-07  2018.0   \n",
       "7758  Fading music biz veteran Zé realizes he has ju... 2019-02-22  2019.0   \n",
       "7761  Teen surfer Zak Storm is mysteriously transpor... 2018-09-13  2018.0   \n",
       "\n",
       "     Minutes     Unit  \n",
       "111        2  Seasons  \n",
       "276        1   Season  \n",
       "434        5  Seasons  \n",
       "598        3  Seasons  \n",
       "706        1   Season  \n",
       "...      ...      ...  \n",
       "7668       2  Seasons  \n",
       "7717       1   Season  \n",
       "7719       1   Season  \n",
       "7758       2  Seasons  \n",
       "7761       3  Seasons  \n",
       "\n",
       "[205 rows x 15 columns]"
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data [ (data['Category']=='TV Show') & (data['Type']== \"Kids' TV\") ]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "id": "07749d50",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Show_Id</th>\n",
       "      <th>Category</th>\n",
       "      <th>Title</th>\n",
       "      <th>Director</th>\n",
       "      <th>Cast</th>\n",
       "      <th>Country</th>\n",
       "      <th>Release_Date</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Duration</th>\n",
       "      <th>Type</th>\n",
       "      <th>Description</th>\n",
       "      <th>Date_N</th>\n",
       "      <th>Year</th>\n",
       "      <th>Minutes</th>\n",
       "      <th>Unit</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>s5</td>\n",
       "      <td>Movie</td>\n",
       "      <td>21</td>\n",
       "      <td>Robert Luketic</td>\n",
       "      <td>Jim Sturgess, Kevin Spacey, Kate Bosworth, Aar...</td>\n",
       "      <td>United States</td>\n",
       "      <td>January 1, 2020</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>123 min</td>\n",
       "      <td>Dramas</td>\n",
       "      <td>A brilliant group of students become card-coun...</td>\n",
       "      <td>2020-01-01</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>123</td>\n",
       "      <td>min</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>s8</td>\n",
       "      <td>Movie</td>\n",
       "      <td>187</td>\n",
       "      <td>Kevin Reynolds</td>\n",
       "      <td>Samuel L. Jackson, John Heard, Kelly Rowan, Cl...</td>\n",
       "      <td>United States</td>\n",
       "      <td>November 1, 2019</td>\n",
       "      <td>R</td>\n",
       "      <td>119 min</td>\n",
       "      <td>Dramas</td>\n",
       "      <td>After one of his high school students attacks ...</td>\n",
       "      <td>2019-11-01</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>119</td>\n",
       "      <td>min</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>s112</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>44 Cats</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sarah Natochenny, Suzy Myers, Simona Berman, E...</td>\n",
       "      <td>Italy</td>\n",
       "      <td>October 1, 2020</td>\n",
       "      <td>TV-Y7</td>\n",
       "      <td>2 Seasons</td>\n",
       "      <td>Kids' TV</td>\n",
       "      <td>Paw-esome tales abound when singing furry frie...</td>\n",
       "      <td>2020-10-01</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>2</td>\n",
       "      <td>Seasons</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>s171</td>\n",
       "      <td>Movie</td>\n",
       "      <td>A Family Man</td>\n",
       "      <td>Mark Williams</td>\n",
       "      <td>Gerard Butler, Gretchen Mol, Alison Brie, Will...</td>\n",
       "      <td>Canada, United States</td>\n",
       "      <td>December 15, 2019</td>\n",
       "      <td>R</td>\n",
       "      <td>110 min</td>\n",
       "      <td>Dramas</td>\n",
       "      <td>A ruthless corporate headhunter battles his ri...</td>\n",
       "      <td>2019-12-15</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>110</td>\n",
       "      <td>min</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>232</th>\n",
       "      <td>s233</td>\n",
       "      <td>Movie</td>\n",
       "      <td>A Stoning in Fulham County</td>\n",
       "      <td>Larry Elikann</td>\n",
       "      <td>Ken Olin, Jill Eikenberry, Maureen Mueller, Gr...</td>\n",
       "      <td>United States</td>\n",
       "      <td>October 1, 2011</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>95 min</td>\n",
       "      <td>Dramas</td>\n",
       "      <td>After reckless teens kill an Amish child, a pr...</td>\n",
       "      <td>2011-10-01</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>95</td>\n",
       "      <td>min</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>7668</th>\n",
       "      <td>s7667</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>World of Winx</td>\n",
       "      <td>Iginio Straffi</td>\n",
       "      <td>Haven Paschall, Alysha Deslorieux, Jessica Paq...</td>\n",
       "      <td>Italy, United States</td>\n",
       "      <td>June 16, 2017</td>\n",
       "      <td>TV-Y7</td>\n",
       "      <td>2 Seasons</td>\n",
       "      <td>Kids' TV</td>\n",
       "      <td>The reality show \"WOW!\" engages the Winx in th...</td>\n",
       "      <td>2017-06-16</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>2</td>\n",
       "      <td>Seasons</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7717</th>\n",
       "      <td>s7716</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Yoko</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Eileen Stevens, Alyson Leigh Rosenfeld, Sarah ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>June 23, 2018</td>\n",
       "      <td>TV-Y</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>Kids' TV</td>\n",
       "      <td>Friends Mai, Oto and Vik's games at the park b...</td>\n",
       "      <td>2018-06-23</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Season</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7719</th>\n",
       "      <td>s7718</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>YOM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sairaj, Devyani Dagaonkar, Ketan Singh, Mayur ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>June 7, 2018</td>\n",
       "      <td>TV-Y7</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>Kids' TV</td>\n",
       "      <td>With the mind of a human being, and the body o...</td>\n",
       "      <td>2018-06-07</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Season</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7758</th>\n",
       "      <td>s7757</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Z4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Apollo Costa, Gabriel Santana, Matheus Lustosa...</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>February 22, 2019</td>\n",
       "      <td>TV-PG</td>\n",
       "      <td>2 Seasons</td>\n",
       "      <td>Kids' TV</td>\n",
       "      <td>Fading music biz veteran Zé realizes he has ju...</td>\n",
       "      <td>2019-02-22</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>2</td>\n",
       "      <td>Seasons</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7761</th>\n",
       "      <td>s7760</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Zak Storm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Michael Johnston, Jessica Gee-George, Christin...</td>\n",
       "      <td>United States, France, South Korea, Indonesia</td>\n",
       "      <td>September 13, 2018</td>\n",
       "      <td>TV-Y7</td>\n",
       "      <td>3 Seasons</td>\n",
       "      <td>Kids' TV</td>\n",
       "      <td>Teen surfer Zak Storm is mysteriously transpor...</td>\n",
       "      <td>2018-09-13</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>3</td>\n",
       "      <td>Seasons</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>322 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Show_Id Category                       Title        Director  \\\n",
       "4         s5    Movie                          21  Robert Luketic   \n",
       "7         s8    Movie                         187  Kevin Reynolds   \n",
       "111     s112  TV Show                     44 Cats             NaN   \n",
       "170     s171    Movie                A Family Man   Mark Williams   \n",
       "232     s233    Movie  A Stoning in Fulham County   Larry Elikann   \n",
       "...      ...      ...                         ...             ...   \n",
       "7668   s7667  TV Show               World of Winx  Iginio Straffi   \n",
       "7717   s7716  TV Show                        Yoko             NaN   \n",
       "7719   s7718  TV Show                         YOM             NaN   \n",
       "7758   s7757  TV Show                          Z4             NaN   \n",
       "7761   s7760  TV Show                   Zak Storm             NaN   \n",
       "\n",
       "                                                   Cast  \\\n",
       "4     Jim Sturgess, Kevin Spacey, Kate Bosworth, Aar...   \n",
       "7     Samuel L. Jackson, John Heard, Kelly Rowan, Cl...   \n",
       "111   Sarah Natochenny, Suzy Myers, Simona Berman, E...   \n",
       "170   Gerard Butler, Gretchen Mol, Alison Brie, Will...   \n",
       "232   Ken Olin, Jill Eikenberry, Maureen Mueller, Gr...   \n",
       "...                                                 ...   \n",
       "7668  Haven Paschall, Alysha Deslorieux, Jessica Paq...   \n",
       "7717  Eileen Stevens, Alyson Leigh Rosenfeld, Sarah ...   \n",
       "7719  Sairaj, Devyani Dagaonkar, Ketan Singh, Mayur ...   \n",
       "7758  Apollo Costa, Gabriel Santana, Matheus Lustosa...   \n",
       "7761  Michael Johnston, Jessica Gee-George, Christin...   \n",
       "\n",
       "                                            Country        Release_Date  \\\n",
       "4                                     United States     January 1, 2020   \n",
       "7                                     United States    November 1, 2019   \n",
       "111                                           Italy     October 1, 2020   \n",
       "170                           Canada, United States   December 15, 2019   \n",
       "232                                   United States     October 1, 2011   \n",
       "...                                             ...                 ...   \n",
       "7668                           Italy, United States       June 16, 2017   \n",
       "7717                                            NaN       June 23, 2018   \n",
       "7719                                            NaN        June 7, 2018   \n",
       "7758                                         Brazil   February 22, 2019   \n",
       "7761  United States, France, South Korea, Indonesia  September 13, 2018   \n",
       "\n",
       "     Rating   Duration      Type  \\\n",
       "4     PG-13    123 min    Dramas   \n",
       "7         R    119 min    Dramas   \n",
       "111   TV-Y7  2 Seasons  Kids' TV   \n",
       "170       R    110 min    Dramas   \n",
       "232   TV-14     95 min    Dramas   \n",
       "...     ...        ...       ...   \n",
       "7668  TV-Y7  2 Seasons  Kids' TV   \n",
       "7717   TV-Y   1 Season  Kids' TV   \n",
       "7719  TV-Y7   1 Season  Kids' TV   \n",
       "7758  TV-PG  2 Seasons  Kids' TV   \n",
       "7761  TV-Y7  3 Seasons  Kids' TV   \n",
       "\n",
       "                                            Description     Date_N    Year  \\\n",
       "4     A brilliant group of students become card-coun... 2020-01-01  2020.0   \n",
       "7     After one of his high school students attacks ... 2019-11-01  2019.0   \n",
       "111   Paw-esome tales abound when singing furry frie... 2020-10-01  2020.0   \n",
       "170   A ruthless corporate headhunter battles his ri... 2019-12-15  2019.0   \n",
       "232   After reckless teens kill an Amish child, a pr... 2011-10-01  2011.0   \n",
       "...                                                 ...        ...     ...   \n",
       "7668  The reality show \"WOW!\" engages the Winx in th... 2017-06-16  2017.0   \n",
       "7717  Friends Mai, Oto and Vik's games at the park b... 2018-06-23  2018.0   \n",
       "7719  With the mind of a human being, and the body o... 2018-06-07  2018.0   \n",
       "7758  Fading music biz veteran Zé realizes he has ju... 2019-02-22  2019.0   \n",
       "7761  Teen surfer Zak Storm is mysteriously transpor... 2018-09-13  2018.0   \n",
       "\n",
       "     Minutes     Unit  \n",
       "4        123      min  \n",
       "7        119      min  \n",
       "111        2  Seasons  \n",
       "170      110      min  \n",
       "232       95      min  \n",
       "...      ...      ...  \n",
       "7668       2  Seasons  \n",
       "7717       1   Season  \n",
       "7719       1   Season  \n",
       "7758       2  Seasons  \n",
       "7761       3  Seasons  \n",
       "\n",
       "[322 rows x 15 columns]"
      ]
     },
     "execution_count": 62,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data [ (data['Category']=='Movie') & (data['Type']=='Dramas') | (data['Category']=='TV Show') & (data['Type']== \"Kids' TV\") ]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d5410872",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}