netflixreviw.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>5</th>\n",
       "      <td>s6</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>46</td>\n",
       "      <td>Serdar Akar</td>\n",
       "      <td>Erdal Beşikçioğlu, Yasemin Allen, Melis Birkan...</td>\n",
       "      <td>Turkey</td>\n",
       "      <td>July 1, 2017</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>International TV Shows, TV Dramas, TV Mysteries</td>\n",
       "      <td>A genetics professor experiments with a treatm...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>s7</td>\n",
       "      <td>Movie</td>\n",
       "      <td>122</td>\n",
       "      <td>Yasir Al Yasiri</td>\n",
       "      <td>Amina Khalil, Ahmed Dawood, Tarek Lotfy, Ahmed...</td>\n",
       "      <td>Egypt</td>\n",
       "      <td>June 1, 2020</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>95 min</td>\n",
       "      <td>Horror Movies, International Movies</td>\n",
       "      <td>After an awful accident, a couple admitted to ...</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>s9</td>\n",
       "      <td>Movie</td>\n",
       "      <td>706</td>\n",
       "      <td>Shravan Kumar</td>\n",
       "      <td>Divya Dutta, Atul Kulkarni, Mohan Agashe, Anup...</td>\n",
       "      <td>India</td>\n",
       "      <td>April 1, 2019</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>118 min</td>\n",
       "      <td>Horror Movies, International Movies</td>\n",
       "      <td>When a doctor goes missing, his psychiatrist w...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>s10</td>\n",
       "      <td>Movie</td>\n",
       "      <td>1920</td>\n",
       "      <td>Vikram Bhatt</td>\n",
       "      <td>Rajneesh Duggal, Adah Sharma, Indraneil Sengup...</td>\n",
       "      <td>India</td>\n",
       "      <td>December 15, 2017</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>143 min</td>\n",
       "      <td>Horror Movies, International Movies, Thrillers</td>\n",
       "      <td>An architect and his wife move into a castle t...</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",
       "5      s6  TV Show     46        Serdar Akar   \n",
       "6      s7    Movie    122    Yasir Al Yasiri   \n",
       "7      s8    Movie    187     Kevin Reynolds   \n",
       "8      s9    Movie    706      Shravan Kumar   \n",
       "9     s10    Movie   1920       Vikram Bhatt   \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",
       "5  Erdal Beşikçioğlu, Yasemin Allen, Melis Birkan...         Turkey   \n",
       "6  Amina Khalil, Ahmed Dawood, Tarek Lotfy, Ahmed...          Egypt   \n",
       "7  Samuel L. Jackson, John Heard, Kelly Rowan, Cl...  United States   \n",
       "8  Divya Dutta, Atul Kulkarni, Mohan Agashe, Anup...          India   \n",
       "9  Rajneesh Duggal, Adah Sharma, Indraneil Sengup...          India   \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",
       "5       July 1, 2017  TV-MA   1 Season   \n",
       "6       June 1, 2020  TV-MA     95 min   \n",
       "7   November 1, 2019      R    119 min   \n",
       "8      April 1, 2019  TV-14    118 min   \n",
       "9  December 15, 2017  TV-MA    143 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",
       "5    International TV Shows, TV Dramas, TV Mysteries   \n",
       "6                Horror Movies, International Movies   \n",
       "7                                             Dramas   \n",
       "8                Horror Movies, International Movies   \n",
       "9     Horror Movies, International Movies, Thrillers   \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",
       "5  A genetics professor experiments with a treatm...  \n",
       "6  After an awful accident, a couple admitted to ...  \n",
       "7  After one of his high school students attacks ...  \n",
       "8  When a doctor goes missing, his psychiatrist w...  \n",
       "9  An architect and his wife move into a castle t...  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data=pd.read_csv('Netflix Dataset.csv')\n",
    "data.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data.duplicated()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "data.drop_duplicates(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data.duplicated()]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Q1 IS THERE ANY NULL DATA?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:>"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAW0AAAE2CAYAAACqSMMWAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuNCwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8QVMy6AAAACXBIWXMAAAsTAAALEwEAmpwYAAA+SElEQVR4nO29eZhcVbX//fkmYQoQJoOXScLsZRYCzoooCCggogyiOF25IFGGnwOIKCq+IqIyXhARBEVQGQRkUuZ5SCAJiYAECJCAYEDGKCHp7/vH3pWcVKo71V2nqquq1yfPebrOPrvW3qe7smqftdcg2wRBEASdwbDBnkAQBEFQP6G0gyAIOohQ2kEQBB1EKO0gCIIOIpR2EARBBxFKOwiCoINoudKWtJOkhyVNk3REq8cPgiBoBZLOlvScpCm9XJekk7MunCxpq3rktlRpSxoOnAbsDGwM7Ctp41bOIQiCoEX8Gtipj+s7Axvk4wDg9HqEtnqlvS0wzfZjtucAFwK7t3gOQRAETcf2LcALfXTZHTjPibuAFSWttji5I8qaYJ2sATxVOJ8BvL26k6QDSN88aPgKWw8btmxrZhcEQUczd85MNfL+N2Y9VneI+JKj1/tfsp7KnGn7zH4MV0sfrgE809ebWq20a/1CF/kl5Rs/E2DEkmtEnH0QBG1HUU8NkLr0YTWtVtozgLUK52sCT7d4DkEQBLXpmdfK0QakD1tt074X2EDSOpKWBPYBLm/xHIIgCGrjnvqPxrkc2D97kbwDeMl2n6YRaPFK2/ZcSeOAa4HhwNm2p7ZyDkEQBL3heXNLkyXpAmA74E2SZgDfBZYAsH0GcBWwCzANmA18vi657Z6aNWzaffPvp29t+hjLrP7epo8RBGXQ6EbknBkP1L8RueZmDY01UFpt0w5KJhRqEJRIOWaPphJKOwiCoEJrNyIHxIA3IiUtLekeSZMkTZX0vdz+e0kT8zFd0sTcvoqkGyW9KunUkuYfBEFQHq3diBwQjay0Xwe2t/2qpCWA2yRdbXvvSgdJPwVeyqf/AY4GNs1HUAJh0w6C8ihzI7JZDFhpO+1gvppPl8jHfCO+JAF7Advn/q+RFPv6A55tsAihUIOgRHq63KadE0BNANYHTrN9d+Hye4FnbT8yALnFMHYijL1vmr3abvYXQzwtBG1Dt29E2p4HbClpReBSSZvarqQh3Be4YIByI4y9H3S6Qur0+QddRAdsRJbiPWL7RUk3kdIQTpE0Avg4sHUZ8oMgCFpCB6y0G/EeGZ1X2EhaBvgQ8FC+/CHgIdszGp5hEARBq+jpqf8YJBpZaa8GnJvt2sOAP9j+c762DzVMI5KmA6OAJSV9DNjR9t8amEMQBEF5dLn3yGTgbb1c+1wv7WMGOl4QBEGzSdt07U1ERAZBEFToAJv2gJW2pI2A3xea1gW+Y/vEfP1rwE+A0bZnSdoBOA5YEpgDfN32DQMdP+geOt1lMegiutlP2/bDwJYw3197JnBpPl8L2AF4svCWWcCutp+WtCkpPesaAx0/SHSDj3Mo1aBt6OaVdhUfBB61/UQ+/znwDeCySgfb9xf6TwWWlrSU7ddLmsOQJBReEJTIUPHTpuAtImk3YKbtSSmSvSZ7Avf3prAjIjIIgkGhm71HKuSyYbsBR0oaCRwF7NhH/02AH/fVJyIigyAYFIaIeWRn4D7bz0raDFgHqKyy1wTuk7St7X9IWpNk997f9qMljB3Qmo28Zo4RJp6gbejmjcgC83OM2H4AWLVyIQfTjM3eIysCVwJH2r69hHGDTKcndArvkaBt6Halnc0hOwD/W0f3caRsgEdLOjq37Wj7uUbmEDSfUHrBUKHrg2tszwZW6eP6mMLrY4FjGxkvWJRucPkLgrahAzYiB5wwKmgPQqEGQYl0Q8IoSWcDHwWes71pbvskcAzw38C2tsfn9lWAi4BtgF/bHleQcw0pydQI4FbgYHfCs0gQG53B0KFLvEd+DZwKnFdom0LKl/2Lqr591YHcy/bLuQzZRcAngQsHMOegim5QSt1wD0EX0A0bkbZvkTSmqu1BgOrgmb7qQNp+uTDmkhTqSQYDpxts2uE9ErQNXbLSLg1J1wLbAleTVttBg3SDQuqGewi6hA5Yabd0I9L2h0l27aXIVdprIekASeMlje/pea1l8wuCYIgzb279xyDRcu8R2/8BLgd276PPmbbH2h4beUeCIGgZHeA90hKlLWk5Savl1yOAXVhQTzIIgqA9cE/9xyBRj8vfBcB2wJskzQC+C7wAnAKMBq6UNDGbPmrWgQSeBy6XtBQwHLgBOKPsmwmCIGiIDrBp1+M9sm8vly7tpf+YXvpvU+ecgn7QCu+RZhMbkUHbEN4jQbMJhRcEJdINK+2g/emG1XaziS+3oC7mtX+Q9oDC2AvXqov3LgGcBWyVZZ9n+0dV77kcWLdaVtC+hMILhgxdstL+NYuGsfdWvPeTwFK2N8tpW/8m6QLb0/N7Pg68WsK8gwKhVIOgJDpAaS/W5c/2LSRvkWoqxXuL4egGls1ufcsAc4CXIbn9AYcT6VmDIGhXSnb5k7STpIclTZN0RI3rK0i6QtIkSVMlfX5xMgdk0+6jeO9FpKCZZ4CRwGG2Kwr/B8BPgdl1yI/CvnXSDblHgqBtKHGlLWk4cBrJIjEDuFfS5bb/Vuh2MPA327tKGg08LOl823N6k9tvpb2Y4r3bAvOA1YGVgFslXUfy217f9mHVyadqEYV96ycUahCUSLkbkdsC02w/BiDpQtKitqi0DSyfs58uR7Jq9BkjP5CV9nr0UrwX+BRwje03gOck3Q6MJVW32ToH3owAVpV0k+3tBjB+UEVkyQuCkujHSrtoEcicmRecFdYAniqczwDeXiXmVFJaj6eB5YG97b5tL/1W2osp3vsksL2k35LMI+8ATrQ9GTg99x8D/DkUdnmEUg2CkuhHcE3RItALqtFWbTn4MDCRlEBvPeCvkm4tpLJehMVuROYw9juBjSTNkPTFPrqfRlriTwHuBc7JCjsIgqDtcY/rPupgBrBW4XxN0oq6yOeBS5yYBjwOvLUvoY2EsVeujym8fpXk9tdX/+ksWtUmCIJg8CnX5e9eYANJ6wAzgX1IJuQiTwIfJO3/vRnYCHisL6ERERkEQVChxNwjtudKGgdcS0qUd7btqZIOzNfPIHnV/VrSAyRzyjdtz+pL7kAL+25JytK3NGmn88u278n26geBh/Pb77J9YH7PTaQCCP/O13a0/Vx9tx/0RaeHsYdNPmgb5pYbxm77KuCqqrYzCq+fprYnXq8MNCLyeOB7tq+WtEs+3y5fe9T2lr3I2q9SuT0oj1B6QVASHRAROaDCvqQd0FH59QosalwPWkQE1wRBibj9w0IGatM+FLhW0gkkD5R3Fa6tI+l+Uvj6t20Xtco5kuYBFwPH2rV/QxER2V6EH3gwZOiGlXYvHEQKUb9Y0l7Ar4APkcLX32L7eUlbA3+StEn2OdzP9kxJy5OU9meoSkJVISIi6ycUXhCUSH2ufIPKQJX2Z4FD8us/ktKxYvt14PX8eoKkR4ENgfG2Z+b2VyT9jhTiWVNpB/0jVsJBUBLdkE+7F54G3g/cRIrkeQQgJzx5wfY8SesCGwCP5ax/KxZybn8UuK7RyQeJUKpBUA7uBvNIL4V9vwSclJXxf1gQf/8+4PuS5pISRx1o+wVJy5Js4EuQ/BWvA35Z9s0EQRA0RDeYR/qIiNy6Rt+LSfbq6vbXavUPgiBoK6KwbxAEQQfRDSvtXFbsPOC/gB5S+sGTJP0E2JVUneZR4PO2X5S0A3AcsGS+9nXbN2RZS5ICdbbLso7Kq/OgAWIjMghKohts2qQw9f9n+77srjdB0l+BvwJH5vj6HwNHAt8EZgG72n5a0qakuPs1sqyjSOHwG0oaBqxc9g0NNf799K2hVIOgLLrBe8T2MyT/64q73oPAGrb/Uuh2F/CJ3Of+QvtUYGlJS2V3wC+Q0w7mRN99JkYJFk8o7CAokW4wjxTJ4exvA+6uuvQF4Pc13rIncL/t1yWtmNt+IGk7kkllnO1n+zOHYGEijD0IyqMrXP4q5GrqFwOHFqsqSDqKZEI5v6r/JsCPWZDBagQpCfjttg+XdDhwAikysnqsCGOvk1CoQVAiHbDSXmzlGoDsX30xcL7tSwrtnyUFyuxXzCMiaU3gUmB/24/m5udJldgvzed/BLaqNZ7tM22PtT02FHYQBC2jx/Ufg0Q93iMi5RZ50PbPCu07kTYe3297dqF9ReBK0ibl7ZV225Z0Bclz5AZStYZiVeJggIT3SBCURJf4ab+bZMJ4QNLE3PYt4GRgKVIhSlhQ8GAcsD5wtKSjc/9KwYNvAr+RdCLwT1J9tKABOr0AQhC0E57b/kpbvWRHbRsiy18QBPUyd87MWhXQ6+aVr360bn2z/Ml/bmisgRIRkUEQBBW6yXskCIKg6+kA75FGwtiPIWX7+2fu+i3bV+VQ9V8AY3P/Q2zflKMpiwbYNYHf2j60rJsZqsRGZBCURDcobXoPYwf4ue0Tqvp/CcD2ZpJWBa6WtI3tV4AtK50kTQAuIWiYUKpBUA6e1/7mkcX6adt+xvZ9+fUrwIMsyCVSi42B63P/54AXSavu+UjaAFiVhVfeQRAEg0sH+GnXFVxToUYY+zhJkyWdLWml3DYJ2F3SCEnrkPJor1Ulal/g930V9pU0XtL4np7X+jPFIAiCAeMe130MFnUr7Rph7KcD65FMHs8AP81dzwZmAOOBE4E7SCaWIvsAF/Q2VkREBkEwKHTASrsu75FaYezFRE+Sfgn8ObfPBQ4rXLuDXEMyn28BjLA9oYwbCIIgKI32N2k3FMa+Wk7bCrAHMCW3jyQF7byWCyLMtV0MV9+XPlbZQf+ILH9BUB6Dafaol0bC2PeVtCVgYDrwv/naqqQivj3ATBbN4rcXsEtDsw7mEwo1CEpkbhcobdu3AbXCNa/qpf90YKM+5K1b7+SCIAhaSbestIMgCIYGXWLT7i0icgvgDGA5knlkv0pxBEmbk6IiR+X3bGP7P5L2JZlWDDwNfNp2lBxrkIiIDIJy6ISV9mKz/ElaDVitGBEJfAw4F/ia7ZslfQFYx/bRkkYA9wGfsT1J0iqkABuRFPXGtmdJOh6YbfuYvsaPLH9BENRLo1n+Xtj9/XXrm5Uvu7k9s/z1VtiXZLe+JXf7K6nq+tGk8mKTbU/K73ke5rsNClhW0vOkVfi0Uu9mCBLeI0FQHh1QA6Ghwr5TgN2Ay4BPsiDqcUPAkq4FRgMX2j7e9huSDgIeAF4j+W4f3Ms4USOyTkKhBkF5uDoMsA1pJCLyC8DBOfHT8sCc3HUE8B5gv/xzD0kfzCvtg0hKf3VgMnBkrbEiIjIIgkGhpx9HHUjaSdLDkqZJOqKXPttJmihpqqSbFyezkYjIh8iV1iVtCHwkd58B3FzZYJR0FamA78v5fY/m9j8ANW8iCIJgMCjTPCJpOHAasANJL94r6fJisGGuqft/wE62n8yZUftksSvtPiIiV80/hwHfJnmSQLJtby5pZN6UfD+pgO9MYGNJo3O/HUgZA4MgCNoC99R/1MG2wDTbj9meA1wI7F7V51PAJbafhPmZUfukkYjIDSRVbNKXAOfkQf8l6WfAvSTXvqtsXwkg6XvALZLeAJ4APlfH+EEQBC2hPyvt4t5b5kzbZxbO1wCeKpzPAN5eJWZDYAlJN5HMzCfZPq+vcRuJiAQ4qZf3/Bb4bY32M1iwIg+CIGgrPK9+L76soM/so0stYdUuhSNI6as/CCwD3CnpLtt/701oRER2OOHyFwTl4Z5SXa9nsHAtgTVJsSrVfWbZfg14TdItwBZAr0q7Hpv20pLukTQp725+L7f/IBdAmCjpL5JWz+3b5raJ+T17FGTtnd8zNQfXBEEQtA0l27TvJZmR18m1c/cBLq/qcxnw3lw0ZiTJfNLnXl89K+3Xge1tv5q9SG6TdDXwE9tHA0j6KvAd4ECS//ZY23NzNOUkSVcAKwA/Aba2/U9J50r6oO3r67r9oCaxCg6C8rDLW2lnHTiO5JwxHDjb9lRJB+brZ9h+UNI1JBfoHuAs21P6kluPTdvAq/l0iXy4kmcksyzZVmN7dqF9aRbYcNYF/m67Ur39OmBPcj3JYOB0Q+6RZt5DfLEF9VJ2RKTtq6jKiJr39ornPyEtaOuiXj/t4aScI+sDp9m+O7f/ENgfeAn4QKH/20llx9Ym5SCZK2ka8NYcVTmDlL9kyXonGvRONyilbriHoPMp2abdFOqKiLQ9z/aWJEP6tpI2ze1H2V4LOB8YV+h/t+1NgG2AIyUtbftfpIjI35OqsE9n0dqRQBT2DYJgcOiZp7qPwaJf1dhtvwjcBOxUdel3JFNHdf8HSXlGKkr+Cttvt/1O4GEKtSOr3hdh7EEQtBz3qO5jsKjHe2R0DrVE0jLAh4CHJG1Q6LYb8FDus06OhETS2qRsgNPzeSWKciXgy8BZZd1IEARBo9j1H4NFPTbt1YBzs117GPAH23+WdLGkjUg7nk+QPEcgJYk6Ikc99gBfLhQ6qBRPAPh+Xw7kQf10w0Zks4nfUVAPnWDTXmwRhMEmiiD0TQTXBMECGi2C8OimH65b36w35dr2LIIQBM0mVsFBu9B1RRCC9qMbFFI33EPQHczr6ZdvxqDQSBj77wvh6tMrGQAlrSLpRkmvSjq1StbWkh7ICcFPzmlfgyAI2oJO8B4ZcBi77b0rHST9lBRgA/AfUq3ITfNR5HRSKsO7SFFCOwFXN3YLQacTdvmgXWjzLT6ggTD2yvW8Wt4L2D73f42k2Ncvysl5SEbZvjOfn0eKigyl3QD/fvrWjldInT7/oHvoBO+RhsLYM+8FnrVdM1CmwBqk8PUKM3JbrfGisG8/iI28ICiHnhITRjWLupS27XnAljnI5lJJmxYyUe0LXFCHmHoSglfGm59cPFz+up/40gnahZ5uWWlXsP1iLouzEzAlRz5+nFR5YXHMIOUuqVArIXjQhoRSDYYKXbHSzoV438gKuxLG/uN8+UPAQ7Zn9CogY/sZSa9IegdwNyk74CkDn3oAofCCoEzKzKfdLAYcxp6v7UMN04ik6cAoYElJHwN2zGXjDwJ+TaqFdjWxCRkEQRvRLd4jk4G39XLtc720j+mlfTyLugEGQRC0BV1hHgmCsGkHQ4VuMY8A893+xgMzbX9U0sqkggZjSKlX97L9rxyAcxawVZZ/nu0fZRmVSjcr2V6uzBsJmkco1WCoMK+blDZwCKlK8Kh8fgRwve3jJB2Rz78JfBJYyvZmubrw3yRdYHs6cAVwKr0UPwjak1hpB0OFrjGPSFoT+AjwQ+Dw3Lw7sF1+fS6pos03Sb7Xy2Z3wGWAOcDLALbvyvJKmXyQCKUaBOXQTeaRE4FvAMsX2t5s+xmY7863am6/iKTQnwFGAofZfqE/k4qIyP4RSjUIyqEDMrPW5af9UeA52xMkbVeHzG2BecDqwErArZKus/1YvZOKiMj6iWRLQVAerhm43V7Us9J+N7CbpF2ApYFRkn4LPCtptbzKXg14Lvf/FHCN7TeA5yTdDowF6lbaQf2EQg2C8pjbDeYR20cCRwLklfbXbH9a0k+AzwLH5Z+X5bc8CWyfFftI4B0k80rQJMKmHQTl0C0r7d44DviDpC+SFPUnc/tpwDnAFFKSqHNygA6SjietxEdKmgGcZfuYBuYQEEo1CMqiE2zaUdg3CIKuodHCvn958z5165sdn70wCvsGQRAMJp2w0g6lHQRBkOkqpV0dxl5o/xrwE2C07VmSxpAiJx/OXe6yfWCOjvwjsB7JJfAK20eUcxtDl3D5C4LymNcBgX+NhLEjaS1gB9JGZJFHbW9ZQ8YJtm+UtCRwvaSdbUd61gYIhRoE5dHTLd4jvYSxA/ycFCl5Wa33FbE9G7gxv54j6T4WrmQTDJBw+QuCcugEr4cBh7FL2o1kKplUI5fIOpLuJ+Uc+bbthbRKrjW5K3BSrcEijL1/hFINgnLoCpt2rTD2bJ8+CtixxlueAd5i+3lJWwN/krSJ7Zfze0eQqt2c3Ftoe4Sxtxexkg+GCj1dYtNeJIwd+A2wDlBZZa8J3CdpW9v/AF4HyIr+UWBD0iYmJGX8iO0Ty7yRoUpsRAZBeXTCCnGgYex7FvvkmpBjs/fIaOAF2/MkrQtsQM47IulYYAXgf0q8hyFNKNQgKI+5JS+0Je1EMgMPJ0WAH9dLv22Au4C9bV/Ul8xh5U4RgPcBkyVNIqVpPdD2C3kz8yhgY9KqfKKkUN5BELQNPajuY3FkN+nTgJ1Jem9fSRv30u/HwLX1zLFfwTW2byIVO6huH1N4fTFwcY0+M6AD/GmCIBiylGwe2RaYVtm7k3QhqdbA36r6fYWkM7epR2gzVtpBEAQdSY/qPyQdIGl84TigStwawFOF8xm5bT6S1gD2AM6od46NFPbdMg+0NDAX+LLteyTtQMoAuCSp1NjXbd+QZVwDrJbHvRU42Pa8eucQLEo3bESGd0rQLvTH5a/o5dYLtSwL1Yv5E4Fv5j3AusZtJCLyeOB7tq/OniXHk2pGzgJ2tf20pE1JdprKt8tetl9Wmt1FpHSuF/ZjDkEV3aCQuuEegu5gXrkG3BnAWoXzNYGnq/qMBS7MCvtNwC6S5tr+U29C6zKPFCIizyo0mwUKfIXKZGzfb7sysanA0pKWytdezu0jSCvxTvCwCYJgiNDTj6MO7gU2kLROTt2xD3B5sYPtdWyPyfuCF5EsFn/qS2gjhX0PBa6VdAJJ+b+rxvv2BO63/XqlQdK1JAP91XmSixARke1HM00YsdIO2oUyIyJtz5U0jmRtGA6cbXuqpAPz9brt2EUaKex7EKnS+sWS9gJ+BXyo8L5NSG4sC0VN2v6wpKWB84Htgb9WjxkRkfXTKpt2KNZgKFB2iUjbVwFXVbXVVNa2P1ePzHrMI5WIyOkk+3Ol/uNngUtynz+SVs/AfHPKpcD+th+tMbn/kB4Tdq9nkkEQBK2gZPNIU1is0rZ9pO01s81lH+AG258m2bDfn7ttDzwC85NBXQkcafv2ihxJy+Wq7ZX8I7sAD5V3K0EQBI3RCUq7kco1XwJOygr4P2QbNDAOWB84WtLRuW1HkvvL5XlTcjhwA/3wTQxqs8zq722JiaSZdIPbYtAdlOw90hQGHBFp+zZg6xp9jgWO7UVEXRE/wdAiFGrQLnRFatagven0VXYQtBOdoLTr9dOeLumBnORpfG77pKSpknokjS30XVLSObn/pCqPk0qfyyVNKesmgiAIysD9OAaL/qy0P2B7VuF8CvBx4BdV/b4EYHszSasCV0vaxnYPgKSPA682MOegQJgWgqA8ejrApj3ghFG2H7T9cI1LGwPX5z7PAS+SQjWRtBypxmRvNu8gCIJBo5u8Rwz8RZKBX+Tgl96YBOye0xCuRdqsXAu4B/gB8FNg9sCnHFQTCZeCoBzmdUBmjXqV9rtzAqhVgb9Kesj2Lb30PRv4b1JGwCeAO4C5OSvg+rYPkzSmr8EijL1/hFINgnLohI3IupR2JQGU7eckXUqKfqyptG3PBQ6rnEu6gxR4835g6xxZOQJYVdJNtrerISPC2IMgaDmdoGzqyT2yLDDM9iv59Y7A9/voPxKQ7ddybu25tv9GqtZweu4zBvhzLYUd9I8ITAmC8uiWlfabgUtzvtcRwO9sXyNpD+AUYDRwpaSJtj8MrErK/tcDzAQ+05ypBxAKNQjKpBO8R+qpxv4YsEWN9ktJSaGq26cDGy1G5nRg03onGQRB0Ao6YSMyakR2OBERGQTl0U0uf0GbEuaRICiPnm5ZafcSxn6MpJm5bWKuE1npv7mkO3OY+wO56AGSbpL0cOE9qzbntoIgCPpPt4exA/zc9gnFhpyq9bfAZ2xPkrQK8Eahy362xw9sukEQBM2jW7xH+suOwGTbkwBsP9+EMYIgCEqna8wjLAhjn5CjFSuMkzRZ0tmSVsptGwKWdK2k+yR9o0rWOdk0crSyH2E1kg6QNF7S+J6e1/p3R0OM2IgMgvKY149jsKhXab/b9lbAzsDBkt5HCpRZD9gSeIaUUwTS6v09wH755x6SPpiv7Wd7M+C9+ajpw237TNtjbY+NEPa+iY3IICgP9+PfYFGX0i6GsZN8s7e1/azteTnl6i9ZUNh3BnCz7Vm2Z5MqEW+V3z8z/3wF+F3hPUEQBINOV7j89RbGLmk128/kbnuQ8msDXAt8I4ezzyHlHPl53qBc0fYsSUsAHwWuK/l+hhwRxh4E5dEJNu1Gwth/kzP3GZgO/C+A7X9J+hlwb752le0rs8K/Nivs4SSF/cuS72fIEQo1CMqj/VV2Y2HsveYUsf1bkttfse01ahQCDhrj30/fGoo7CEqiW1baQZsTRRCCoBy6JvdILxGRW+SoxwckXSFpVG7fthDxOClnA6zIWVLSmZL+LukhSXs257aCIAj6T1dsRBaojog8C/ia7ZslfQH4OnA0aUNyrO25klYDJkm6IhdHOAp4zvaGkoYBK5d0H0OWWAUHQXkMpitfvTRiHtmIBdVr/kryGjk6u/lVWJqFbftfAN4KkF0Fq8PigwEQ5pEgKIduCmOvVdh3CrAbcBnwSVLxXgAkvZ1UK3JtUg6SuZJWzJd/IGk74FFgnO1nqweLGpH9I5RqEJRDj7tnpb1IYV/SqvlkSd8BLif5ZANg+25gE0n/DZwr6eo81prA7bYPl3Q4cAI1oiKjRmT/iJV2EJRDJ2xEDriwb87utyOApA2Bj9R434OSXiNVqZkAzGZBtZs/Al9s+A6GOK0IrokvhWCo0BU27T4iIlfNSnwY8G3gjNx/HeCpbBJZm2T7nm7bkq4AtgNuAD5IKvYbNEAovCAoj26xafcWEXmIpINzn0uAc/Lr9wBHSHqD9Dv4csHr5JvAbySdCPwT+Hw5tzF06YYsf/HFE7QLnRBcI7e54T1s2kEQ1MvcOTMbqqf+ibV3q1vfXPTE5YsdS9JOwEmk1B1n2T6u6vp+pMUswKvAQZVaBL0REZFBEASZMs0jkoYDpwE7kLKf3ivpcttFs/DjwPtzzqadSQ4Yb+9Lbl1KO7vrnUXaUDTJc2QXYHfSfT4HfK6yYSnpSNIm4zzgq7avze37At/KMp4GPl2jhFnQDyLLXxCUxzyXatXeFpiW8zch6UKSzpyvtG3fUeh/F8nDrk/qXWmfBFxj+xOSlgRGAlNtH50n81XgO8CBkjYG9gE2AVYHrsveJcpyNs7pWY8HxgHH1DmHYJAI75FgqNAflV2MJ8mcmd2VK6wBPFU4n0Hfq+gvAlcvbtx6vEdGAe8DPgdgew4Fn+zMsiyIfNwduND268DjkqaRvnHGkxT3spKeB0YB0xY3fjD4hFINhgr9cfkrxpP0Qi2bd80BJH2ApLTfs7hx61lpr0vy9DhH0hYkf+tDbL8m6YfA/sBLwAdy/zVIy/wKM4A1bN8p6SDgAeA14BHgYIKGCIUaBOVRsvfIDAqR4iTTx9PVnSRtTjI/71xPIfR6svyNIJULO93220gK9wgA20fZXgs4n2TqgF6+XXLxg4OAt5HMJpOBI2sNGIV9gyAYDGzXfdTBvcAGktbJZuV9SNHj85H0FpLL9Gds/70eofUo7RnAjByaDnARueZjgd8Bexb61/p22RLA9qNOd/wH4F21BozCvkEQDAZlpmbNmU3HkZLpPQj8wfZUSQdKOjB3+w6wCvB/xdTXfVFP5Zp/SHpK0ka2HyZHMkrawPYjudtuwEP59eXA73LJsdWBDYB7SEE6G0sabfufJDeYB+u49yAIgpYwr+SYSNtXkYqbF9vOKLz+H+B/+iOzXu+RrwDn5yX+Y6RIxrMkbUT60nkCODBPYqqkP5DcWuYCB9ueBzwt6XvALTla8gny5mYQBEE70O7BhhARkUEQdBGNRkR+YM0d6tY3N874a0NjDZSIiAyCIMh0RZa/IAiCoUInFEGot7DvipIuysV4H5T0ztz+FUkPS5qaIxyRtISkc3PB3wdzSHtFzta5fZqkk5VTBwZBELQD83Ddx2Ax4DD2HMGzO7C57ddzVRtIpceWsr2ZpJEkT5MLbE8HTieFfd5F2lHdiTrCNoMgCFpBJ6RmXexKuxDG/itIYey2XyQFyhyXw9Wx/Vx+i0mh6iOAZUgh7y/nyuyjbN+Z/bTPAz5W7u0EQRAMnJKDa5rCgMPYgQ2B9+ZQ9v8AX7N9Lyn4ZnfgGVJiqcNsvyBpLCnwpsIMUsj7IkRh3/4RCZ2CoBw6YaVdj9KuhLF/xfbdkk4ihbGPAFYC3gFsA/xB0rqk5FDzSIE1KwG3SrqOfiRPicK+/SOUahCUQyd4jzQSxj4DuMSJe0hBNm8CPkWyf7+RTSa3A5VVdjFXbM3kKUEQBINFJ5hHFqu0bf8DeCpHP8KCgrx/AraH+dXYlwRmAU8C2yuxLGkl/pDtZ4BXJL0je43sD1xW8v0EQRAMmHnuqfsYLBoJY38NOFvSFNJm42dzxfXTSEV+p5BMIufYnpzlHAT8mrRBeTXhOdIwUbkmCMqjE2zaEcbeBcRGZBAkGg1j3/y/3lm3vpn8jzsjjD0YGKFUg6AcOiEisp5yYxsBvy80rUvKAXtebh8DTAf2yhWFx5BSrj6c+99l+8Asq1LpZiXby5VzC0ObbjCPxJNC0C50gvdIPfm0HyYXMMgl4WcCl5Lc/q63fZykI/L5N/PbHrW9ZQ1xVwCnkkqNBQEQSjVoHwZzg7Fe+mse+SBJIT8haXdgu9x+LnATC5R2TWzfBRApR8qjFQovVsLBUKErzCNV7ANckF+/ObvxYfuZQu4RgHUk3Q+8DHzbdr/+10dEZP8IpRoE5dAV5pEK2d1vN3opxlvgGeAttp+XtDXwJ0mb2H653rEiInJo0Q12+aA76LaV9s7AfbafzefPSlotr7JXA54DyAmkKkmkJkh6lJSnZLEFK4P+0wqF12xCoQbtQlettIF9WWAagVTA97PAcfnnZQCSRgMv2J6Xc5FsQArICZpAKLwgKA93wEZkvUUQRpKqp19SaD4O2EHSI/nacbn9fcBkSZNIeUoOtP1ClnO8pBmkfNwzJB1Tzm0EQRA0TieEsUdEZIcT9uAgWECjEZFrrrxp3fpmxgtTIiIy6D+hUIOgPNp9EQv1Va7ZSNLEwvGypEML178myZLelM93kDQh14KcIKmSCXCkpCtzncmpko7rZcigH3TDRmQ33EPQHfTYdR+DRSMRkUhai2TPfrLwllnArraflrQpcC0LKtScYPvG7D54vaSdbUemvwbohpV2N9xD0B10gvdIXRuRBeZHRObznwPfoFCBxvb9tivFDaYCS0tayvZs2zfmPnOA+1i4KEIQBMGg0glFEAYcESlpN2Cm7Ul9hKXvCdxfKf5bQdKKwK6kKu9BA8RGZBCUR1flHilGRGYXwKOAHfvovwnw4+o+uUr7BcDJtmv6b0cYe/2EQg2C8ujaiEhJmwHrAJVV9prAfZK2tf0PSWuS7N772360Ss6ZwCO2T+xtoAhj7x+ReyQIyqETvEcGFBFp+wFgfoIoSdOBsbZnZdPHlcCRtm8vCpB0LLAC8D+NTTsoEko1CMqhE8qNNRIR2RvjgPWBowtugqvm1fdRwMakVflESaG8gyBoGzphIzIiIjuc2IgMggU0GhG57Mgxdeub12ZPj4jIoP+EQg2C8ui2jcigTYmNyCAoh3a3PEAo7Y6nG0LA40snaBfKjoiUtBMpHmU4cJbt46quK1/fBZgNfM72fX3JDKUdDDqhVIN2ocyVdk77cRrJiWMGcK+ky23/rdBtZ1LNgQ2AtwOn55+9Ekq7w4nCvkFQHiWbR7YFplWCCCVdCOwOFJX27sB5TgPfJWnFSkWw3oS2vdLu726wpANycE5TaLb8VozRbvLnzpnZ9DGGmvxWjNHp8mvxRj/0TTFyO3Nm1XzXAJ4qnM9g0VV0rT5rkGrt1qS/CaM6gQMW36Wt5bdijE6X34oxOl1+K8bodPkNYftM22MLR/UXTK0vgOqlfD19FqIblXYQBEE7MANYq3C+JvD0APosRCjtIAiC5nAvsIGkdXLCvX1IBdGLXA7sr8Q7gJf6smdDB9i0B0CzbWCtsLF1+j3E72jw5bdijE6X31Rsz5U0jlQIZjhwtu2pkg7M188AriK5+00jufx9fnFy2z6MPQiCIFhAmEeCIAg6iFDaQRAEHUQo7SAI6kbSMpI2Gux5DGVCaddBDkdtluwNJV0vaUo+31zSt0seQ5LWWnzP9kXSyoM9h6GOpF2BicA1+XxLSdXeEEGT6eiNyMX9R7b9QknjPA5cBJxTlTegDNk3A18HfmH7bbltiu1NSx5ngu2ty5RZJf962x9cXFsD8h8hKYxzgKvdpA+upLWBDWxfJ2kZYITtV0qS/fEazS8BD9h+rqQxRgNfAsZQ8A6z/YUSZE8AtgduKnxWJ9vevFHZVeMMB97MwvN/sswxOplOd/mbQIoeEvAW4F/59YrAk6Q6lmWwOcnH8ixJw4CzgQttv1yC7JG276mqaD+3BLnV3CVpG9v3lilU0tLASOBNklZiQYTXKGD1EofaEPgQ8AXgFEm/B35t++9lDSDpS6QovJWB9UiBDmcApXzxAF8E3gncmM+3A+4CNpT0fdu/KWGMy4BbgeuAeSXIKzLX9ktVn9VSkfQV4LvAs0ClNLpJ/wcD6F95nXY9SP+xdimc7wz8tEljvQ+YCbwGnAus36C8q0kK4r58/gnSSrLsef+N9GXwKDAZeACYXILcQ4DHgdeBx/Lrx4FJwLgm/Q0+kP8GLwI3A+8sSe5EYEng/kLbAyXO+wrgzYXzN5NK+K0MTCnrHprxO8+yfwV8Kn9+NgBOAc4oeYxpwCrNuoduOAZ9AiX9oSfUaBtfovzhwG6kCvP3A4fn/3CfAP7eoOx1Saui2VkR3QaMacLvaO1aR4nyv9Lkv/Eq+QtiPKlw9MdJT4pjgcdLGuPu/PP+/HNEGV9sBfkPVJ2roqyLXxQNjnFscQFT8t9gJPBDUqTf+Px66ZLHuJFkkmraZ6nTj043j1SYlTfvfkt6lPo08HyJ8h8hfZh+YvuOQvtFkt7XiGCntI0fkrQsMMwl2U9rjPOEpC2ASh7UW21PKnGIf0ha3vYr+W+xFXCsF5PQvR/cCfwG+JjtGYX28ZLOKGmMmyV9C1hG0g7Al0mr47K4VdKfgT/m8z2BW/Lf/sWSxjgE+JakOcAbuc22RzUq2PZs4ChJP84ym/FZfQy4SdKVpKe3ytg/a8JYHUlHb0RWyBuS3yWZLgBuAb7nEjYi86bIUba/36isKrmH93W97A+ppENIG1SX5KY9SKkkTylJ/mTbm0t6D/Aj4ATgW7b7TOhep+zhpC/MPn9nJYwzjGR33pG0Cr7W9i9LlC+Son53ln8bcLE75D+hpG1I+znL56aXgC/YnlDiGN+t1W77e2WN0el0hdJuNpJutP2BkmXW/HBm3IQvickk2+9r+XxZ4E6XtPMv6X7bb5P0I5IZ4HeVtpLkl+aJ0scYh9g+aXFt7Y6k3ViwgLnJ9p9LkjsZONj2rfn8PcD/lfUZqhpredL/g1fLlt3pdLR5RNIV9JF71vZuJQ11h6RTgd+TNiAr8gf86F9ZOUh6t+3bi9ckvXugcvtALOxNMI/auXwHykxJvyB5ePxY0lKUGwcwMfsE/5GF/waX9P6WfvNZUr2+Ip+r0TYgssvfj4FVSb97UZLpojDGccA2wPm56RBJ77F9RAniX6kobADbt0kq1UQiaVOSGWzlfD4L2N/21DLH6WQ6eqUt6f19Xbd9c0nj3Fij2ba3L0H2fba3WlxbCeMcTlJKl+amjwHn2v55SfJHAjuRVtmPSFoN2Mz2X0qSf06NZrsc/+N9SV4R7yG5y1VYHphn+0ONjpHHmQbsavvBMuT1MsZkYEvbPfl8OGmTs+HVsKSfkzYjLyAtlvYmudleDI0tYgpj3EEyR96Yz7cD/j/b72pUdrfQ0SvtepWypItt79nAOKWaRgAkvRN4FzC6yr49iuStUiq2fybpJpJiEvB52/eXKH82cImkVSW9JTc/VJZ8UiXrZj2R3EEq7/Qm4KeF9ldI7m1l8WwzFXaBFYHKfs4KJcrdMv+sNu29i6TEG17EAMtWFDaA7ZuyKS/IdLTS7gfrNvJmSSuw8EbnzcD3bb/UgNglgeVIf4PlC+0vk1wJS0XSb2x/BrivRlsZ8ncjKbzVgedIwU4PAZuUIZ/kE1z99FGrrd/YfgJ4ghT40kzG56CgP7GwZ0SZJp4fAffnp0ORPrNHliT7Q7bLDtip5jFJR5NMJJA8wR5v8pgdRUebR+qlUXODpIuBKaRgGoDPAFvYrhWW3F/Za2el0VSqfwf5sfkB2xuXJH8SaaV1Xd6Q/ACwr+2G6vwVnkgOBYqmnFHAHra3aER+1VjvIH0R/DfpS3U48FpZNudmmniqxlmNZNcWyff8HyXJraRzOLtZTww5qvZ7LHgivAU4xva/mjFeJzJUVtqNsl6VeeV7kiY2IlDSqbbHAadKWuSbs6xNVElHAhXf40rYvYA5lFsZ5A3bz0saJmmY7RuzP2+jtPKJ5FRSuoI/koJ29gfWL0u47cVWJRkokt5q+yFJlS/mii/76pJWL8lfvpLO4VdNSOcAQFbOXy1LXjcyVFbaDbmeSboT+Lrt2/L5u4ETbA/4cVrSy7ZH9baZWtYmamG8H9ku6zG5lvzrSJubPyLZhp8DtilrA6kVTySSxtseq0ISJEl3NHoPkr5h+3hJp1DD28l2w0pK0pm2D2jGprmkEbbnVrW9j7QhuSJp9f0D29MaGONE24f25hFWoidYx9MVK21J2wN35c2wWnyzwSEOAs7Ntm2RNnk+16DMR6F85dwH90haoWKHl7QisJ3tPzUiVNL6pJD+3YF/A4cB+5HC5L/SiOwqlpJ0Jotmrytj86vCbKUCrBMlHU/anCxjE6xiShhfgqyaFMxQO9v+T/GaUlKvRrgH2Cqb1D5CStq1NmkP43xSlO1VpKReA6Viwz6hARlDgq5YaUs6D3gHKXT91nzcVrYdTNIogDIeByXNAHqNenT5EZETbW9Z1dZw8ItSWPa3bE+uah8LfNf2ro3IL8ibREoMNoGCv7nLjcZbm5RdbknSl88KpOCRAa8gq+R/0vYfF9fW4Bilu5BW3i/pMVI6h7Ns31nV5+SSnhgOcRcEODWTrlDaFSStTrJzfg1Y3XYpTxKqHXL+EilR1cQBynwGOJ1eAlxcctiuauQ9lvSA7c0alNtr7u8y5BdkNTUfeGGc0QC2/9kE2U3zyZf0X8AapPw7n4KFUuSeYfutDciuLDBGkp6mFlIaZS4wevkdNby46Ca6xTzyadIj2mbALNKG0q19vql/jM1HJXnQR0iZzg6U9Efbxw9A5jMuOVR9MYyX9DPgNNJ/uq+QVq2N0tej9zIlyK9whaQvk4KDiu5yZeSXEcmlcxxJ2Q2TNBc4pYy/kaSdgV2ANSSdXLg0ivJyp3+YZLJbk4Wf4F4hbUQ3wnDSZrDyz9IpBDito4Wr4SxPucnfOp6uWGkrhbo+Snp8vtH29JLlXwvs6ZwHQdJypM2XPUir7X67zbV69ZADFI4mhZkD/AX4oXMukgbkXgDc4KrESpK+COxoe+9G5Bfk1fLVte2GfPCz7MNISvUA24/ntnVJT0LXuMGoUaXsilsC3we+U7j0CunzWpoZT9Keti8uS16WWXqEbo0x1iYVLfkRUAy5f4WUHrcZhUE6kq5Q2gCSNiEFEryHlKD94RIDRx4k+WXPyedLkZLN//dAla+klctYJQ5g3OVcYhIeSW8mrX7nsGDlPpZkF96jLB/hZiLpfmAH27Oq2kcDfynry1XSErbfWHzPhsf5CCmoaf5TUCNPDIOwwPgvYFvSE+G9nfAZaiXdYh4ZRYrAW5vkXbACC0oVlcHvSOW6LsvnuwIX5NXrgGpGtlphS3oXcBbp8fYtefX3v7a/3Ihc288C78rBNBXb9pW2b2howlVI2r+X8c8rQfwS1Qo7y/6npCVKkF9hjFIWxI1ZWKE2/LRQQSm3+EjgA6S/9ydI3h+N0NTsikXyE9p3gRtI5phTlEqxnd2qObQ7XbHSVkqSc1s+bvHCSfLLGmNrFkRp3Wa7ae5bzUDS3aT/wJe7iQWEm0X2ca6wNEmR3Ge74QCbvh7/yzQNSLqNpJB+Tvri/zzp/2BfaXr7O0Ylr3nl53LAJbZ3LGuMZiLpYeBdtp/P56sAd9jeaHBn1j50xUq7EAixPH2kam2QZYCXbZ8jabSkdSr2z07B9lNauChrs/NIlIbthXy+s898GYVwAbbQgmjRhYah743W/rKM7eslySlQ6BhJt7JoAqZGqPhoz87eVM9TXoHrVjCDZMeu8Arw1CDNpS3pCqWthXPwStI/gc/anlKS/O+S7LQbAecAS5Bcq5qR97pZPJVNJM4BJF9lQdBHJzKbtHfRMLbryqooaaUGNw3/oxT+/YikcaSaoKs2IK8WV+TAqZ+QkoMZKK36TguYCdydTZEmBW3dU3G7LTt+oRPpCqVNyqFxuBfOwXsmKdFQGewBvI2cIc/203lV30kcSErmvwZpNfMX4OBBnVE/0MLhzcNJSZ3+0OJpXE9jWQUPJdmbvwr8gJRgq6atfiDkL4Trbb8IXJwDn5Z2Y9koW82j+ahQ2UfqtP9vTaNblHazc/DOsW3lxE4ly246Ofz4RNv7DfZcGqAY3jwXeKIZexeLoaFKP7bvzS9fBT4vaQSpkMDdjU4sy++R9FNyilnbr1Pwae8Eyg4q60bKLAc1mDwm6WhJY/LxbcrNwfsHpVJaK0r6EnAdaWe+I3DKgTw6m0U6EqccLQ+RVlwrkVwMWz6NgbxJ0ihJR0o6VdKOSowDpgF7lTtF/iJpT1VtXrQ7kk7MP6+QdHn1McjTayu6xXuk6Tl4Je3AwlW6/1qW7FaQv3S2Ai5n4RqLHWEjlLQXyU57E+lv8F5S5sWLWjiHAXmSZPvsv4A7SV4vK5H82A8ZaBqEPsZ6hZTkai5pU7L0OpTNQNLWtieoRVkvO5muUNrNRtKPbX9zcW3tjHqp/t4pj6NKCaN2sP1cPh9NKrhQWhGEOuYw0ECq+TlYsqlqFvAW26UWxe108u/mXNufHuy5tDNdYdOWtCEpSdQYmpO2cwcWTe+6c422tqVTlHMfDKso7MzzNMG8J+k9wAYV105guYJr50CDTOZHQdqeJ+nxZilspTzXi2D7lmaMVyb5dzNa0pKV6ONgUbpCaZMqjZxBsjOX5nss6SDgy8C6OYCnwvLA7bXf1V6oe5LLX6OUA+aCfL43KYdzaSzOtbOBKNaiH7hYUEWoGaaLrxdeL00KB59AOUV3W8F04PZsx+44M14r6BalPdf26U2Q+zvgamoksRmMvCEDpKOTyysXWbD9dUkfZ8G+xZ2kBPxl0hTXznr9wMvAVfnLJa0FDCQL5WDxdD6GEW5+Nelom7aklfPLr5LKW5WetrNqvFVZOGfEk2XKbzZqYq7oZqEWFVnIMu+xva0WJP1fFrjTVXnIO4nsRTLZJeU1DwafTl9pTyA98lfcm75Wdb2URDySdiXlKF6d9OWwNimacJMy5DeT/J+2abmiW8CYaoUNYHu8pDElj1Xt2vkFOiuasJKjpbISG0ZKCTtp0CbUTyT9FfhkDhCqeIZdaPvDgzqxNqLTlfbewFO2nwGQ9FlgT5Jd7JgSxzmWVM7sOttvU8pot2+J8pvJoSSb7DauyhUt6TA3mCu6BbSqyAK2T8iunS+T7Nrf6TTXThauQzkXuMB2R+y/ZEZXFDak6uz5CTfIdHpwzRlkc0jeNf8RcC6pFNiZJY7zRs46NkzSsBx9uWWJ8pvJ/sC+xeRWth8DPk2JIdRN5N686l0IpRSepdWHzDKXJRV0+Dpphb2Myk3N2nRsn0vaoL3K9vkdprAB5kl6S+VEqThC59pwm0Cnr7SHF+zWewNnOlXtuFjSxBLHeVEpxeUtwPmSnqO8MlHNplW5opvFocClkvajRpGFkse6BXhvfiS/jrRq3ZtUXb6t6QIzWIWjgNskVYJp3gcc0Ef/IUfHK21JI5xKEX2Qhf+4Dd9bxXOBlGns36QK3fuRbNpf6eOt7URf/q5t7wvrFhVZyMj27LyKP8X28UpVbTqBQ+lsMxgAtq+RtBXJHCngsFqLjqFMp3uPHEWq7TeLVLlmq5zYaX1SZFVDqVNb6bnQLCTNo+DvWrxEygDXCavtlpAV9JdJRQq+aHuqSqwo30zUopJpzUbSu0ml/F5TKti9FXBSzj8e0OErbds/lHQ9sBrpg1ncNS9jJdxKz4Wm0Eof4S7gEOBI4NKssNcFblzMe9qFTjeDVTidFIy0BSlQ6GzgPKBmTpKhSEcrbQDbd9Vo+3tJ4lvmuRAMPjnU+5bC+WOkGIBOoKPNYAXm5qfl3YGTbf8qe4UFmY5X2k3mXklfsr2Qr24zPBeCwSebEr7BopXMOyEEvFUl05rNK5KOBD5D2hQeTkonEGQ62qbdbCS9mRRlOYcangu2/zFYcwvKR9JfgN+TgrQOBD4L/LOTsjl2OpL+C/gUcK/tW7P733a2zxvkqbUNobTroMpzYWqTPBeCQUbSBNtbK1cyz2032w57agvJvtkb2L5O0kiSa2+ksc2EeaQOcjBNp2xIBQOnkkL1GUkfISUuWnMQ5zPkyIFUB5CKdK9Hqml6BgNPi9t1hNIOggUcK2kF4P8BpwCjSL75Qes4mJRO9m4A249EGPvChNIOgoztP+eXLwEfGMy5DGFetz1HucSlUvHjsOEW6PTcI0FQGpI2lHS9pCn5fHOlItFB67hZ0rdIeV92IBU4uWKQ59RWxEZkEGRyvouvA7+oRBBKmmJ7077fGZSFpGHAFykU0QbOciiq+YR5JAgWMNL2PZVH80ynJAbrCmz3SPoT8KdOKtbRSsI8EgQLmCVpPbINVdIngGcGd0pDAyWOkTQLeAh4WNI/JX1nsOfWboTSDoIFHAz8AnirpJmkzHkHDeqMhg6HsiBL4Sq2VwbeDrxbUnjwFAibdhBUkYshDIuAjtbRLVkKW0HYtIMhj6TDe2kHwPbPWjqhoUm3ZClsOqG0gwCWH+wJBF2TpbDphHkkCIJBJ4p11E9sRAZBJoJrBg/bw22PqnEsHwp7YUJpB8ECfkmqXPMGQK5atM+gzigIqgilHQQLGGn7nqq2CK4J2opQ2kGwgAiuCdqe2IgMgkwu5Hsm8C7gX8DjwH5RCTxoJ0JpB0EVleAa4N/A3rbPH+QpBcF8wjwSDHkkjZJ0pKRTczrQ2aT6kNOAvQZ3dkGwMLHSDoY8ki4jmUPuJJW1WolUvPkQ2xMHcWpBsAihtIMhj6QHbG+WXw8HZgFvidwjQTsS5pEgWFDQF9vzgMdDYQftSqy0gyFPVQi1gGVIdm0Btj1qsOYWBNWE0g6CIOggwjwSBEHQQYTSDoIg6CBCaQdBEHQQobSDIAg6iP8fRBvM3YPvJbYAAAAASUVORK5CYII=",
      "text/plain": [
       "<Figure size 432x288 with 2 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "sns.heatmap(data.isnull())"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Q2 FOR HOUSE OF CARDS WHAT IS THE SHOW ID AND WHO IS THE DIRECTOR?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data['Title'].isin(['House of Cards'])]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['Date N']=pd.to_datetime(data['Release_Date'])\n",
    "data.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "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",
       "2009.0       2\n",
       "2008.0       2\n",
       "2010.0       1\n",
       "Name: Date N, dtype: int64"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['Date N'].dt.year.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:>"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAX0AAAERCAYAAACXT3dwAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuNCwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8QVMy6AAAACXBIWXMAAAsTAAALEwEAmpwYAAAS8ElEQVR4nO3de7BdZ13G8e9jArVDqbQkLTWJTZUgtChVYkXRsQyXZijSMoIGFYqWiQNlRMcZSb2Bl2BGRy5VW6cCQzsKpdxstKB0qujooOWUVkJaaqNNaZrQhgJSL1RTf/6xV2DP6U5OztmXk9X3+5nZc9Z+99rPerOS82SdtdfeJ1WFJKkN37DcE5AkzY6lL0kNsfQlqSGWviQ1xNKXpIasXO4JLGTVqlW1fv365Z6GJPXKzTff/IWqWj1//Jgv/fXr1zM3N7fc05CkXkly96hxT+9IUkMsfUlqiKUvSQ2x9CWpIZa+JDXE0pekhlj6ktQQS1+SGmLpS1JDjvl35B7O+q3XL2r9PdvPn9JMJKk/PNKXpIZY+pLUEEtfkhpi6UtSQyx9SWqIpS9JDbH0Jakhlr4kNcTSl6SGWPqS1JAFSz/JuiR/k+T2JLuSvL4bPznJDUnu7L6eNPScS5PsTnJHkvOGxp+ZZGf32GVJMp0/liRplKM50j8I/EJVPQ14FnBJkjOBrcCNVbUBuLG7T/fYZuAsYBNweZIVXdYVwBZgQ3fbNME/iyRpAQt+4FpV7Qf2d8sPJrkdWANcAJzbrXYV8HHgDd34NVX1EHBXkt3AOUn2ACdW1ScAklwNXAh8dHJ/nMnxA90kPRot6px+kvXAdwH/BJza/Ydw6D+GU7rV1gD3DD1tbze2pluePz5qO1uSzCWZO3DgwGKmKEk6gqMu/SQnAB8Efq6qvnKkVUeM1RHGHzlYdWVVbayqjatXrz7aKUqSFnBUpZ/kMQwK/0+r6kPd8H1JTusePw24vxvfC6wbevpaYF83vnbEuCRpRo7m6p0A7wRur6q3DD20A7ioW74IuG5ofHOS45KcweAF25u6U0APJnlWl/nKoedIkmbgaH5z1rOBVwA7k9zajf0SsB24NsnFwOeAlwFU1a4k1wK3Mbjy55Kqerh73muAdwPHM3gB95h8EVeSHq2O5uqdv2f0+XiA5x7mOduAbSPG54CnL2aCkqTJ8R25ktQQS1+SGmLpS1JDLH1JaoilL0kNsfQlqSGWviQ1xNKXpIZY+pLUEEtfkhpi6UtSQyx9SWqIpS9JDbH0Jakhlr4kNcTSl6SGWPqS1BBLX5IaYulLUkMsfUlqiKUvSQ2x9CWpIZa+JDXE0pekhlj6ktSQlcs9gVat33r9Ua+7Z/v5U5yJpJZ4pC9JDbH0Jakhlr4kNcTSl6SGWPqS1BBLX5IaYulLUkMsfUlqiKUvSQ2x9CWpIZa+JDXE0pekhlj6ktSQBUs/ybuS3J/kM0Njb0pyb5Jbu9sLhx67NMnuJHckOW9o/JlJdnaPXZYkk//jSJKO5GiO9N8NbBox/taqOru7fQQgyZnAZuCs7jmXJ1nRrX8FsAXY0N1GZUqSpmjB0q+qvwO+eJR5FwDXVNVDVXUXsBs4J8lpwIlV9YmqKuBq4MIlzlmStETjnNN/XZJPd6d/TurG1gD3DK2ztxtb0y3PHx8pyZYkc0nmDhw4MMYUJUnDllr6VwDfBpwN7Ad+rxsfdZ6+jjA+UlVdWVUbq2rj6tWrlzhFSdJ8Syr9qrqvqh6uqv8D/hg4p3toL7BuaNW1wL5ufO2IcUnSDC2p9Ltz9Ie8BDh0Zc8OYHOS45KcweAF25uqaj/wYJJndVftvBK4box5S5KWYMFfjJ7kvcC5wKoke4E3AucmOZvBKZo9wM8AVNWuJNcCtwEHgUuq6uEu6jUMrgQ6Hvhod5MkzdCCpV9VLx8x/M4jrL8N2DZifA54+qJmJ0maKN+RK0kNsfQlqSGWviQ1xNKXpIZY+pLUEEtfkhpi6UtSQyx9SWqIpS9JDbH0Jakhlr4kNcTSl6SGWPqS1BBLX5IaYulLUkMsfUlqiKUvSQ2x9CWpIZa+JDXE0pekhlj6ktSQlcs9AU3e+q3XL2r9PdvPn9JMJB1rPNKXpIZY+pLUEEtfkhpi6UtSQyx9SWqIpS9JDbH0Jakhlr4kNcTSl6SGWPqS1BBLX5IaYulLUkMsfUlqiKUvSQ2x9CWpIZa+JDXE0pekhixY+kneleT+JJ8ZGjs5yQ1J7uy+njT02KVJdie5I8l5Q+PPTLKze+yyJJn8H0eSdCRHc6T/bmDTvLGtwI1VtQG4sbtPkjOBzcBZ3XMuT7Kie84VwBZgQ3ebnylJmrIFS7+q/g744rzhC4CruuWrgAuHxq+pqoeq6i5gN3BOktOAE6vqE1VVwNVDz5EkzchSz+mfWlX7Abqvp3Tja4B7htbb242t6Zbnj4+UZEuSuSRzBw4cWOIUJUnzTfqF3FHn6esI4yNV1ZVVtbGqNq5evXpik5Ok1i219O/rTtnQfb2/G98LrBtaby2wrxtfO2JckjRDSy39HcBF3fJFwHVD45uTHJfkDAYv2N7UnQJ6MMmzuqt2Xjn0HEnSjKxcaIUk7wXOBVYl2Qu8EdgOXJvkYuBzwMsAqmpXkmuB24CDwCVV9XAX9RoGVwIdD3y0u0mSZmjB0q+qlx/moeceZv1twLYR43PA0xc1O0nSRPmOXElqiKUvSQ2x9CWpIZa+JDXE0pekhlj6ktQQS1+SGmLpS1JDLH1JaoilL0kNsfQlqSGWviQ1xNKXpIZY+pLUEEtfkhpi6UtSQyx9SWqIpS9JDbH0Jakhlr4kNcTSl6SGWPqS1BBLX5IaYulLUkMsfUlqiKUvSQ2x9CWpIZa+JDXE0pekhlj6ktQQS1+SGmLpS1JDLH1JaoilL0kNsfQlqSGWviQ1xNKXpIZY+pLUEEtfkhpi6UtSQ8Yq/SR7kuxMcmuSuW7s5CQ3JLmz+3rS0PqXJtmd5I4k5407eUnS4kziSP85VXV2VW3s7m8FbqyqDcCN3X2SnAlsBs4CNgGXJ1kxge1Lko7SNE7vXABc1S1fBVw4NH5NVT1UVXcBu4FzprB9SdJhjFv6BXwsyc1JtnRjp1bVfoDu6ynd+BrgnqHn7u3GHiHJliRzSeYOHDgw5hQlSYesHPP5z66qfUlOAW5I8tkjrJsRYzVqxaq6ErgSYOPGjSPXkSQt3lhH+lW1r/t6P/BhBqdr7ktyGkD39f5u9b3AuqGnrwX2jbN9SdLiLLn0kzwuyeMPLQMvAD4D7AAu6la7CLiuW94BbE5yXJIzgA3ATUvdviRp8cY5vXMq8OEkh3LeU1V/meSTwLVJLgY+B7wMoKp2JbkWuA04CFxSVQ+PNXtJ0qIsufSr6t+AZ4wYfwB47mGesw3YttRt6tiwfuv1i1p/z/bzpzQTSYvlO3IlqSGWviQ1xNKXpIZY+pLUEEtfkhpi6UtSQyx9SWqIpS9JDbH0Jakhlr4kNcTSl6SGWPqS1BBLX5IaYulLUkMsfUlqiKUvSQ2x9CWpIZa+JDXE0pekhlj6ktQQS1+SGmLpS1JDLH1JaoilL0kNsfQlqSGWviQ1xNKXpIZY+pLUEEtfkhpi6UtSQ1Yu9wSk+dZvvX5R6+/Zfv6UZiI9+nikL0kNsfQlqSGe3lFzPH2klnmkL0kNsfQlqSGWviQ1xNKXpIZY+pLUkJlfvZNkE/B2YAXwjqraPus5SNPk1UE6ls209JOsAP4QeD6wF/hkkh1Vddss5yH1mf+paByzPtI/B9hdVf8GkOQa4ALA0peOEdP+T8X85ZWqmt3GkpcCm6rq1d39VwDfW1Wvm7feFmBLd/fbgTsWsZlVwBcmMN3lyO/z3M033/xjK//0qlo9f3DWR/oZMfaI/3Wq6krgyiVtIJmrqo1Lee5y5/d57uabb34/8md99c5eYN3Q/bXAvhnPQZKaNevS/ySwIckZSR4LbAZ2zHgOktSsmZ7eqaqDSV4H/BWDSzbfVVW7JryZJZ0WOkby+zx38803vwf5M30hV5K0vHxHriQ1xNKXpIZY+pLUEEtfkhrS61+XmCQMPtphDYM3ee0DbqoJvTptvvnm9zO/z3Ofdn5vr95J8gLgcuBO4N5ueC3wZOC1VfUx8803v738Ps99FvlUVS9vwO3A+hHjZwC3m2+++W3m93nus8jv8zn9lQw+1mG+e4HHmG+++c3m93nuU8/v8zn9dzH4PP5rgHu6sXUMPtrhneabb36z+X2e+9Tze3tOHyDJ0xh8Hv8aBp/guReY2C9lMd988/uZ3+e5Tzu/16UvSVqcPp/TP6wkbzLffPPNn2V2X/IflaUP3Gy++eabP+PsXuR7ekeSGtLrI/0kz0nyB0muS/LBJNuTPHmC+ecluSLJjm4bVyTZNKHsk5P8WpJXZ+CXk/xFkt9NctIE8t+S5NmTmOth8l+S5ORueXWSq5PsTPK+JGuntd1ue782gYxV8+7/ZJLLkmzp3g05cUn+ehq5I7Yzif2TJD+a5GXd8nO7/fPaJBPpje776+Ik6+eN//QEsqfWDdP+3u22Mb3u6euRfpLtwKnAjcCFwF3AvwCvBd5cVe8fM/9twFOAq/n6NbNrgVcCd1bV68fM/wiwEzgReFq3fC3wfOAZVXXBmPkHgLuB1cD7gPdW1S3jZM7Lv62qzuyW3wf8I/B+4HnAT1TV8ye1rRHb/lxVfcuYGZ+qqu/uln8F+EHgPcCLgL1V9fNj5n96/hCDf093AFTVd46Tv8C2J7F/LgdOAR4LfAU4Dvhz4IXAfRP49/9m4AeATwE/DLytqn6/e+xrfzdLzJ52N0z7e/dtTLF7xnpn13LegJ1DyyuBf+iWTwI+M4H8fznMeLodP27+rUN59456bMz8W7qvG4BfBXYBnwXeCDxlAvl3DC3fPIX5f+UwtweBg5PaP93yp4DHdcuPGf63NUb+DuBPgKcCpwPrGVxzfTpweg/2z86h/fEA8Nju/soJ7Z+dwMpu+QnAR4C3zv+7GWfuQ/OddDfc2n2d1vfuVLunz6d3/u/Q6QXgmxn8+kWq6ksMds64vprknBHj3wN8dQL539D9KLgOOOHQj7hJnsjg6GpcBVBVd1bVb1bVWcCPAt/I4BtsXB9P8htJju+WL4TBj9XAv08g/8vAhqo6cd7t8cD+CeQfn+S7kjwTWFFV/wlQVf8LPDxueFW9GPggg19x94yq2gP8b1XdXVV3j5vP9PfPQfja/vhkVf1Pd/8gE9g/DAr/0Da+zOBo/8Qk72f8f//T7oZpf+9OtXv6/I7cNwO3JLmDwdHUa2Bwfhn45wnkvwq4Isnj+fqPWOsYHE29agL5v83gyBvgp4F3JCngTODXJ5D/iH/cVfVp4NPApRPIfx3wy3SnK4CfT/KfDE4BvGIC+VczOCq+b8Rj75lA/n7gLd3yF5OcVlX7u2/cgxPIp6o+nORjwG8meTWTKYRDpr1/Pp/khKr6j6r62rnkJE8C/mcC+f+a5Ieq6m8Bquph4OIkvwX8yJjZ0+6GaX/vvoopdk9vz+nD4AUV4FuB3d3RwjS28SSG3hVXVZ+fYPYKBn8HB5OsBM5m8OPi2Edqh75hx805ym19E4Mjtwdmsb1p6v5Ojquq/5pw7jOA76uqP5pk7qwleRyDU2H3j5lzPEBV/feIx9ZU1b2PfNai8qfaDdP83h3axlS6p9elfzhJnlpVn114zaPKekz3I+7w2Kqq+sIk8g+zzYnNv+/57n/zl5jR28+7X2C7Y++bPp/TP5LxPm+ar13ytRfYl+Rj8y4rGzt/Ac3nu//NX6oMPo/+TuBNDK42Op/BaZc7u8fGMu38BYy973t7Tj/JZYd7iMHVAOP6HeC8qtqV5KXADUleUVX/yAReDJr2/Puej/vf/KV7O/C87sXz4W2eweAihqcdy/nT3ve9LX3gp4BfAB4a8djLJ5D/2KraBVBVH0hyO/ChJFvprowZ07Tn3/d897/5S9Xrz7tn2vt+3Gs+l+sG/DXw/Yd57K4J5M8BT5o3tha4FXiwB/Pve7773/ylZl8K3AK8Afjx7vaGbuzSCcx92vlT3fe9fSG3e3X+qzXhqyyG8p8HHKiqf543/gTgkqraNmb+tOff93z3v/nj5J8JvJjpfd791PKnvm/6WvqSpMXr7dU7Sb4pgw9R+mySB7rb7d3YE8w33/w28/s891nk97b0GXzA0ZeAc6vqiVX1ROA53dhYH6hkvvnm9zr/cNlfnkD2cuZPZt+P+6LAct0Y+sCvxTxmvvnmP7rz+zz3WeT3+Uj/7iS/mOTUQwNJTk3yBr7+G+TNN9/89vL7PPep5/e59H8MeCLwt0m+lOSLwMeBkxl8mqT55pvfZn6f5z79/HF/VFjOG4NP0HsecMK88U3mm29+u/l9nvvU980kJrgcN+BnGXys758Be4ALhh77lPnmm99mfp/nPpP8cQOW68bgN++c0C2vZ/AOztd3928x33zz28zv89xnkd/nz95ZUd3nxVfVniTnAh9IcjqT+e045ptvfj/z+zz3qef3+YXczyc5+9Cdbie9CFgFfIf55pvfbH6f5z79/HF/VFiuG4MP33rSYR57tvnmm99mfp/nPot8P3tHkhrS59M7kqRFsvQlqSGWviQ1xNKXpIb8P2FkuHmbpZGXAAAAAElFTkSuQmCC",
      "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",
   "metadata": {},
   "source": [
    "Q3 HOW MANY MOVIES AND TV SHOWS ARE THERE IN THIS DATASET"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Category\n",
       "Movie      5377\n",
       "TV Show    2410\n",
       "Name: Category, dtype: int64"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.groupby('Category').Category.count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\Snigdha\\anaconda3\\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": 19,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYsAAAEGCAYAAACUzrmNAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuNCwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8QVMy6AAAACXBIWXMAAAsTAAALEwEAmpwYAAAT/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",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "sns.countplot(data['Category'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "data['Year']=data['Date N'].dt.year"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Q6 LIST MOVIES IN THE YEAR 2000"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "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": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[(data['Category']=='Movie')&(data['Year']==2000)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "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>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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>s7</td>\n",
       "      <td>Movie</td>\n",
       "      <td>122</td>\n",
       "      <td>Yasir Al Yasiri</td>\n",
       "      <td>Amina Khalil, Ahmed Dawood, Tarek Lotfy, Ahmed...</td>\n",
       "      <td>Egypt</td>\n",
       "      <td>June 1, 2020</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>95 min</td>\n",
       "      <td>Horror Movies, International Movies</td>\n",
       "      <td>After an awful accident, a couple admitted to ...</td>\n",
       "      <td>2020-06-01</td>\n",
       "      <td>2020.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>s15</td>\n",
       "      <td>Movie</td>\n",
       "      <td>3022</td>\n",
       "      <td>John Suits</td>\n",
       "      <td>Omar Epps, Kate Walsh, Miranda Cosgrove, Angus...</td>\n",
       "      <td>United States</td>\n",
       "      <td>March 19, 2020</td>\n",
       "      <td>R</td>\n",
       "      <td>91 min</td>\n",
       "      <td>Independent Movies, Sci-Fi &amp; Fantasy, Thrillers</td>\n",
       "      <td>Stranded when the Earth is suddenly destroyed ...</td>\n",
       "      <td>2020-03-19</td>\n",
       "      <td>2020.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>s28</td>\n",
       "      <td>Movie</td>\n",
       "      <td>#Alive</td>\n",
       "      <td>Cho Il</td>\n",
       "      <td>Yoo Ah-in, Park Shin-hye</td>\n",
       "      <td>South Korea</td>\n",
       "      <td>September 8, 2020</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>99 min</td>\n",
       "      <td>Horror Movies, International Movies, Thrillers</td>\n",
       "      <td>As a grisly virus rampages a city, a lone man ...</td>\n",
       "      <td>2020-09-08</td>\n",
       "      <td>2020.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>s29</td>\n",
       "      <td>Movie</td>\n",
       "      <td>#AnneFrank - Parallel Stories</td>\n",
       "      <td>Sabina Fedeli, Anna Migotto</td>\n",
       "      <td>Helen Mirren, Gengher Gatti</td>\n",
       "      <td>Italy</td>\n",
       "      <td>July 1, 2020</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>95 min</td>\n",
       "      <td>Documentaries, International Movies</td>\n",
       "      <td>Through her diary, Anne Frank's story is retol...</td>\n",
       "      <td>2020-07-01</td>\n",
       "      <td>2020.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>7762</th>\n",
       "      <td>s7761</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Zaki Chan</td>\n",
       "      <td>Wael Ihsan</td>\n",
       "      <td>Ahmed Helmy, Yasmin Abdulaziz, Hassan Hosny, H...</td>\n",
       "      <td>Egypt</td>\n",
       "      <td>May 19, 2020</td>\n",
       "      <td>TV-PG</td>\n",
       "      <td>109 min</td>\n",
       "      <td>Comedies, International Movies, Romantic Movies</td>\n",
       "      <td>An unqualified young man has his work cut out ...</td>\n",
       "      <td>2020-05-19</td>\n",
       "      <td>2020.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7783</th>\n",
       "      <td>s7782</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Zoom</td>\n",
       "      <td>Peter Hewitt</td>\n",
       "      <td>Tim Allen, Courteney Cox, Chevy Chase, Kate Ma...</td>\n",
       "      <td>United States</td>\n",
       "      <td>January 11, 2020</td>\n",
       "      <td>PG</td>\n",
       "      <td>88 min</td>\n",
       "      <td>Children &amp; Family Movies, Comedies</td>\n",
       "      <td>Dragged from civilian life, a former superhero...</td>\n",
       "      <td>2020-01-11</td>\n",
       "      <td>2020.0</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",
       "      <td>2020-10-19</td>\n",
       "      <td>2020.0</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",
       "      <td>2020-09-25</td>\n",
       "      <td>2020.0</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",
       "      <td>2020-03-01</td>\n",
       "      <td>2020.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1312 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Show_Id Category                                    Title  \\\n",
       "4         s5    Movie                                       21   \n",
       "6         s7    Movie                                      122   \n",
       "14       s15    Movie                                     3022   \n",
       "27       s28    Movie                                   #Alive   \n",
       "28       s29    Movie            #AnneFrank - Parallel Stories   \n",
       "...      ...      ...                                      ...   \n",
       "7762   s7761    Movie                                Zaki Chan   \n",
       "7783   s7782    Movie                                     Zoom   \n",
       "7784   s7783    Movie                                     Zozo   \n",
       "7786   s7785    Movie                        Zulu Man in Japan   \n",
       "7788   s7787    Movie  ZZ TOP: THAT LITTLE OL' BAND FROM TEXAS   \n",
       "\n",
       "                         Director  \\\n",
       "4                  Robert Luketic   \n",
       "6                 Yasir Al Yasiri   \n",
       "14                     John Suits   \n",
       "27                         Cho Il   \n",
       "28    Sabina Fedeli, Anna Migotto   \n",
       "...                           ...   \n",
       "7762                   Wael Ihsan   \n",
       "7783                 Peter Hewitt   \n",
       "7784                  Josef Fares   \n",
       "7786                          NaN   \n",
       "7788                     Sam Dunn   \n",
       "\n",
       "                                                   Cast  \\\n",
       "4     Jim Sturgess, Kevin Spacey, Kate Bosworth, Aar...   \n",
       "6     Amina Khalil, Ahmed Dawood, Tarek Lotfy, Ahmed...   \n",
       "14    Omar Epps, Kate Walsh, Miranda Cosgrove, Angus...   \n",
       "27                             Yoo Ah-in, Park Shin-hye   \n",
       "28                          Helen Mirren, Gengher Gatti   \n",
       "...                                                 ...   \n",
       "7762  Ahmed Helmy, Yasmin Abdulaziz, Hassan Hosny, H...   \n",
       "7783  Tim Allen, Courteney Cox, Chevy Chase, Kate Ma...   \n",
       "7784  Imad Creidi, Antoinette Turk, Elias Gergi, Car...   \n",
       "7786                                            Nasty C   \n",
       "7788                                                NaN   \n",
       "\n",
       "                                                Country        Release_Date  \\\n",
       "4                                         United States     January 1, 2020   \n",
       "6                                                 Egypt        June 1, 2020   \n",
       "14                                        United States      March 19, 2020   \n",
       "27                                          South Korea   September 8, 2020   \n",
       "28                                                Italy        July 1, 2020   \n",
       "...                                                 ...                 ...   \n",
       "7762                                              Egypt        May 19, 2020   \n",
       "7783                                      United States    January 11, 2020   \n",
       "7784  Sweden, Czech Republic, United Kingdom, Denmar...    October 19, 2020   \n",
       "7786                                                NaN  September 25, 2020   \n",
       "7788              United Kingdom, Canada, United States       March 1, 2020   \n",
       "\n",
       "     Rating Duration                                               Type  \\\n",
       "4     PG-13  123 min                                             Dramas   \n",
       "6     TV-MA   95 min                Horror Movies, International Movies   \n",
       "14        R   91 min    Independent Movies, Sci-Fi & Fantasy, Thrillers   \n",
       "27    TV-MA   99 min     Horror Movies, International Movies, Thrillers   \n",
       "28    TV-14   95 min                Documentaries, International Movies   \n",
       "...     ...      ...                                                ...   \n",
       "7762  TV-PG  109 min    Comedies, International Movies, Romantic Movies   \n",
       "7783     PG   88 min                 Children & Family Movies, Comedies   \n",
       "7784  TV-MA   99 min                       Dramas, International Movies   \n",
       "7786  TV-MA   44 min  Documentaries, International Movies, Music & M...   \n",
       "7788  TV-MA   90 min                    Documentaries, Music & Musicals   \n",
       "\n",
       "                                            Description     Date N    Year  \n",
       "4     A brilliant group of students become card-coun... 2020-01-01  2020.0  \n",
       "6     After an awful accident, a couple admitted to ... 2020-06-01  2020.0  \n",
       "14    Stranded when the Earth is suddenly destroyed ... 2020-03-19  2020.0  \n",
       "27    As a grisly virus rampages a city, a lone man ... 2020-09-08  2020.0  \n",
       "28    Through her diary, Anne Frank's story is retol... 2020-07-01  2020.0  \n",
       "...                                                 ...        ...     ...  \n",
       "7762  An unqualified young man has his work cut out ... 2020-05-19  2020.0  \n",
       "7783  Dragged from civilian life, a former superhero... 2020-01-11  2020.0  \n",
       "7784  When Lebanon's Civil War deprives Zozo of his ... 2020-10-19  2020.0  \n",
       "7786  In this documentary, South African rapper Nast... 2020-09-25  2020.0  \n",
       "7788  This documentary delves into the mystique behi... 2020-03-01  2020.0  \n",
       "\n",
       "[1312 rows x 13 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[(data['Category']=='Movie')&(data['Year']==2020)]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Q7 LIST THE TOP 10 DIRECTORS GIVING US MAX MOVIES  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "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",
       "Youssef Chahine           12\n",
       "Martin Scorsese           12\n",
       "Jay Chapman               12\n",
       "Steven Spielberg          10\n",
       "David Dhawan               9\n",
       "Johnnie To                 8\n",
       "Name: Director, dtype: int64"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['Director'].value_counts().head(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Q8 SHOW ALL THE RECORDS , WHERE CATEGORY IS MOVIES AND TYPE IS COMEDY OR COUNTRY IS UK?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>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",
       "    </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",
       "    </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",
       "    </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",
       "    </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",
       "    </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>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",
       "    </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",
       "    </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",
       "    </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",
       "    </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",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>485 rows × 11 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  \n",
       "19    Mixing old footage with interviews, this is th...  \n",
       "33    When nerdy high schooler Dani finally attracts...  \n",
       "58    A stylist, a hair designer and a makeup artist...  \n",
       "72    Nearing a midlife crisis, thirty-something Mik...  \n",
       "82    Working with an artificial intelligence to inv...  \n",
       "...                                                 ...  \n",
       "7670  Footage of the most dramatic moments from Worl...  \n",
       "7671  From Moscow to Mexico City, three BBC journali...  \n",
       "7688  Set against the 2015 Rugby World Cup, this doc...  \n",
       "7725  A gifted young ballet dancer struggles to find...  \n",
       "7740  An incendiary hate crime stirs civil unrest, f...  \n",
       "\n",
       "[485 rows x 11 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[(data['Category']=='Movie')&(data['Type']=='Comedies')|(data['Country']=='United Kingdom')]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Q9 HOW MANY MOVIES HAD TOM CRUISE IN IT?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data['Cast']=='Tom Cruise']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "ename": "ValueError",
     "evalue": "Cannot mask with non-boolean array containing NA / NaN values",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mValueError\u001b[0m                                Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-6-99100bfe290c>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[0mdata\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0mdata\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m'Cast'\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mstr\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mcontains\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m'Tom Cruise'\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;32m~\\anaconda3\\lib\\site-packages\\pandas\\core\\frame.py\u001b[0m in \u001b[0;36m__getitem__\u001b[1;34m(self, key)\u001b[0m\n\u001b[0;32m   3012\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   3013\u001b[0m         \u001b[1;31m# Do we have a (boolean) 1d indexer?\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m-> 3014\u001b[1;33m         \u001b[1;32mif\u001b[0m \u001b[0mcom\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mis_bool_indexer\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m   3015\u001b[0m             \u001b[1;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_getitem_bool_array\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   3016\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\anaconda3\\lib\\site-packages\\pandas\\core\\common.py\u001b[0m in \u001b[0;36mis_bool_indexer\u001b[1;34m(key)\u001b[0m\n\u001b[0;32m    112\u001b[0m                     \u001b[1;31m# Don't raise on e.g. [\"A\", \"B\", np.nan], see\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    113\u001b[0m                     \u001b[1;31m#  test_loc_getitem_list_of_labels_categoricalindex_with_na\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 114\u001b[1;33m                     \u001b[1;32mraise\u001b[0m \u001b[0mValueError\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mna_msg\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    115\u001b[0m                 \u001b[1;32mreturn\u001b[0m \u001b[1;32mFalse\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    116\u001b[0m             \u001b[1;32mreturn\u001b[0m \u001b[1;32mTrue\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;31mValueError\u001b[0m: Cannot mask with non-boolean array containing NA / NaN values"
     ]
    }
   ],
   "source": [
    "data[data['Cast'].str.contains('Tom Cruise')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Show_Id         0\n",
       "Category        0\n",
       "Title           0\n",
       "Director        0\n",
       "Cast            0\n",
       "Country         0\n",
       "Release_Date    0\n",
       "Rating          0\n",
       "Duration        0\n",
       "Type            0\n",
       "Description     0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Create a new data frame without null values\n",
    "data1=data.dropna()\n",
    "data1.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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>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",
       "    </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",
       "    </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  \n",
       "3860  Through chance, human action, past history and...  \n",
       "5071  A fast-talking yuppie is forced to slow down w...  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data1[data1['Cast'].str.contains('Tom Cruise')]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Q11 WHAT ARE THE DIFFERENT RATINGS DEFINED BY NETFLIX?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "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": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['Rating'].unique()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Q12 HOW MANY MOVIES GOT THE TV-14 RATING IN CANADA?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "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>30</th>\n",
       "      <td>s31</td>\n",
       "      <td>Movie</td>\n",
       "      <td>#cats_the_mewvie</td>\n",
       "      <td>Michael Margolis</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Canada</td>\n",
       "      <td>February 5, 2020</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>90 min</td>\n",
       "      <td>Documentaries, International Movies</td>\n",
       "      <td>This pawesome documentary explores how our fel...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>s35</td>\n",
       "      <td>Movie</td>\n",
       "      <td>#Roxy</td>\n",
       "      <td>Michael Kennedy</td>\n",
       "      <td>Jake Short, Sarah Fisher, Booboo Stewart, Dann...</td>\n",
       "      <td>Canada</td>\n",
       "      <td>April 10, 2019</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>105 min</td>\n",
       "      <td>Comedies, Romantic Movies</td>\n",
       "      <td>A teenage hacker with a huge nose helps a cool...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>608</th>\n",
       "      <td>s609</td>\n",
       "      <td>Movie</td>\n",
       "      <td>At First Light</td>\n",
       "      <td>Jason Stone</td>\n",
       "      <td>Stefanie Scott, Theodore Pellerin, Percy Hynes...</td>\n",
       "      <td>Canada</td>\n",
       "      <td>December 27, 2018</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>91 min</td>\n",
       "      <td>Dramas, Sci-Fi &amp; Fantasy</td>\n",
       "      <td>After mysterious lights imbue her with extraor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1506</th>\n",
       "      <td>s1507</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Counterfeiting in Suburbia</td>\n",
       "      <td>Jason Bourque</td>\n",
       "      <td>Sarah Butler, Larissa Albuquerque, Kayla Walla...</td>\n",
       "      <td>Canada</td>\n",
       "      <td>July 1, 2018</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>88 min</td>\n",
       "      <td>Dramas, Thrillers</td>\n",
       "      <td>Two teenagers print counterfeit money in their...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3713</th>\n",
       "      <td>s3714</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Long Time Running</td>\n",
       "      <td>Jennifer Baichwal, Nicholas de Pencier</td>\n",
       "      <td>Gord Downie, Paul Langlois, Gord Sinclair, Rob...</td>\n",
       "      <td>Canada</td>\n",
       "      <td>November 12, 2017</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>96 min</td>\n",
       "      <td>Documentaries, International Movies, Music &amp; M...</td>\n",
       "      <td>This documentary follows the 2016 tour of belo...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3956</th>\n",
       "      <td>s3957</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Martin Matte: La vie, la mort...eh la la..!</td>\n",
       "      <td>Jean-François Blais</td>\n",
       "      <td>Martin Matte</td>\n",
       "      <td>Canada</td>\n",
       "      <td>October 14, 2019</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>62 min</td>\n",
       "      <td>Stand-Up Comedy</td>\n",
       "      <td>Quebecois comedy star Martin Matte serves up e...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5336</th>\n",
       "      <td>s5336</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Sadie's Last Days on Earth</td>\n",
       "      <td>Michael Seater</td>\n",
       "      <td>Morgan Taylor Campbell, Clark Backo, Ricardo H...</td>\n",
       "      <td>Canada</td>\n",
       "      <td>August 22, 2017</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>94 min</td>\n",
       "      <td>Comedies, Sci-Fi &amp; Fantasy</td>\n",
       "      <td>High schooler Sadie Mitchell believes the worl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5393</th>\n",
       "      <td>s5393</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Sardaar ji</td>\n",
       "      <td>Rohit Jugraj</td>\n",
       "      <td>Diljit Dosanjh, Neeru Bajwa, Mandy Takhar, Jas...</td>\n",
       "      <td>Canada</td>\n",
       "      <td>December 1, 2017</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>140 min</td>\n",
       "      <td>Comedies, International Movies, Music &amp; Musicals</td>\n",
       "      <td>When a palatial wedding venue turns out to be ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6062</th>\n",
       "      <td>s6062</td>\n",
       "      <td>Movie</td>\n",
       "      <td>The Accountant of Auschwitz</td>\n",
       "      <td>Matthew Shoychet</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Canada</td>\n",
       "      <td>July 1, 2019</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>78 min</td>\n",
       "      <td>Documentaries, International Movies</td>\n",
       "      <td>Decades after WWII, a former SS officer stands...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7025</th>\n",
       "      <td>s7024</td>\n",
       "      <td>Movie</td>\n",
       "      <td>The Wrong Babysitter</td>\n",
       "      <td>George Mendeluk</td>\n",
       "      <td>Daphne Zuniga, Seann Gallagher, Lisa Marie Car...</td>\n",
       "      <td>Canada</td>\n",
       "      <td>June 18, 2019</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>89 min</td>\n",
       "      <td>Thrillers</td>\n",
       "      <td>A widow searches for her missing teenage daugh...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7041</th>\n",
       "      <td>s7040</td>\n",
       "      <td>Movie</td>\n",
       "      <td>There's Something in the Water</td>\n",
       "      <td>Ellen Page, Ian Daniel</td>\n",
       "      <td>Ellen Page</td>\n",
       "      <td>Canada</td>\n",
       "      <td>March 27, 2020</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>72 min</td>\n",
       "      <td>Documentaries, International Movies</td>\n",
       "      <td>This documentary spotlights the struggle of mi...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Show_Id Category                                        Title  \\\n",
       "30       s31    Movie                             #cats_the_mewvie   \n",
       "34       s35    Movie                                        #Roxy   \n",
       "608     s609    Movie                               At First Light   \n",
       "1506   s1507    Movie                   Counterfeiting in Suburbia   \n",
       "3713   s3714    Movie                            Long Time Running   \n",
       "3956   s3957    Movie  Martin Matte: La vie, la mort...eh la la..!   \n",
       "5336   s5336    Movie                   Sadie's Last Days on Earth   \n",
       "5393   s5393    Movie                                   Sardaar ji   \n",
       "6062   s6062    Movie                  The Accountant of Auschwitz   \n",
       "7025   s7024    Movie                         The Wrong Babysitter   \n",
       "7041   s7040    Movie               There's Something in the Water   \n",
       "\n",
       "                                    Director  \\\n",
       "30                          Michael Margolis   \n",
       "34                           Michael Kennedy   \n",
       "608                              Jason Stone   \n",
       "1506                           Jason Bourque   \n",
       "3713  Jennifer Baichwal, Nicholas de Pencier   \n",
       "3956                     Jean-François Blais   \n",
       "5336                          Michael Seater   \n",
       "5393                            Rohit Jugraj   \n",
       "6062                        Matthew Shoychet   \n",
       "7025                         George Mendeluk   \n",
       "7041                  Ellen Page, Ian Daniel   \n",
       "\n",
       "                                                   Cast Country  \\\n",
       "30                                                  NaN  Canada   \n",
       "34    Jake Short, Sarah Fisher, Booboo Stewart, Dann...  Canada   \n",
       "608   Stefanie Scott, Theodore Pellerin, Percy Hynes...  Canada   \n",
       "1506  Sarah Butler, Larissa Albuquerque, Kayla Walla...  Canada   \n",
       "3713  Gord Downie, Paul Langlois, Gord Sinclair, Rob...  Canada   \n",
       "3956                                       Martin Matte  Canada   \n",
       "5336  Morgan Taylor Campbell, Clark Backo, Ricardo H...  Canada   \n",
       "5393  Diljit Dosanjh, Neeru Bajwa, Mandy Takhar, Jas...  Canada   \n",
       "6062                                                NaN  Canada   \n",
       "7025  Daphne Zuniga, Seann Gallagher, Lisa Marie Car...  Canada   \n",
       "7041                                         Ellen Page  Canada   \n",
       "\n",
       "           Release_Date Rating Duration  \\\n",
       "30     February 5, 2020  TV-14   90 min   \n",
       "34       April 10, 2019  TV-14  105 min   \n",
       "608   December 27, 2018  TV-14   91 min   \n",
       "1506       July 1, 2018  TV-14   88 min   \n",
       "3713  November 12, 2017  TV-14   96 min   \n",
       "3956   October 14, 2019  TV-14   62 min   \n",
       "5336    August 22, 2017  TV-14   94 min   \n",
       "5393   December 1, 2017  TV-14  140 min   \n",
       "6062       July 1, 2019  TV-14   78 min   \n",
       "7025      June 18, 2019  TV-14   89 min   \n",
       "7041     March 27, 2020  TV-14   72 min   \n",
       "\n",
       "                                                   Type  \\\n",
       "30                  Documentaries, International Movies   \n",
       "34                            Comedies, Romantic Movies   \n",
       "608                            Dramas, Sci-Fi & Fantasy   \n",
       "1506                                  Dramas, Thrillers   \n",
       "3713  Documentaries, International Movies, Music & M...   \n",
       "3956                                    Stand-Up Comedy   \n",
       "5336                         Comedies, Sci-Fi & Fantasy   \n",
       "5393   Comedies, International Movies, Music & Musicals   \n",
       "6062                Documentaries, International Movies   \n",
       "7025                                          Thrillers   \n",
       "7041                Documentaries, International Movies   \n",
       "\n",
       "                                            Description  \n",
       "30    This pawesome documentary explores how our fel...  \n",
       "34    A teenage hacker with a huge nose helps a cool...  \n",
       "608   After mysterious lights imbue her with extraor...  \n",
       "1506  Two teenagers print counterfeit money in their...  \n",
       "3713  This documentary follows the 2016 tour of belo...  \n",
       "3956  Quebecois comedy star Martin Matte serves up e...  \n",
       "5336  High schooler Sadie Mitchell believes the worl...  \n",
       "5393  When a palatial wedding venue turns out to be ...  \n",
       "6062  Decades after WWII, a former SS officer stands...  \n",
       "7025  A widow searches for her missing teenage daugh...  \n",
       "7041  This documentary spotlights the struggle of mi...  "
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[(data['Rating']=='TV-14')& (data['Country']=='Canada')&(data['Category']=='Movie')]"
   ]
  }
 ],
 "metadata": {
  "interpreter": {
   "hash": "ceadcfe871b6a1549e0d7f40a1530a6203609864d99fe03b93a50265ade114f8"
  },
  "kernelspec": {
   "display_name": "Python 3.8.8",
   "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.8.8"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}