Netflix analysis.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "c557db27",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "149ac06c",
   "metadata": {},
   "outputs": [
    {
     "ename": "SyntaxError",
     "evalue": "(unicode error) 'unicodeescape' codec can't decode bytes in position 2-3: truncated \\UXXXXXXXX escape (Temp/ipykernel_9600/3320598686.py, line 1)",
     "output_type": "error",
     "traceback": [
      "\u001b[1;36m  File \u001b[1;32m\"C:\\Users\\USER\\AppData\\Local\\Temp/ipykernel_9600/3320598686.py\"\u001b[1;36m, line \u001b[1;32m1\u001b[0m\n\u001b[1;33m    data=pd.read_csv(\"C:\\Users\\USER\\Desktop\\jupyter\\8. Netflix_Dataset.csv\")\u001b[0m\n\u001b[1;37m                                                                           ^\u001b[0m\n\u001b[1;31mSyntaxError\u001b[0m\u001b[1;31m:\u001b[0m (unicode error) 'unicodeescape' codec can't decode bytes in position 2-3: truncated \\UXXXXXXXX escape\n"
     ]
    }
   ],
   "source": [
    "data=pd.read_csv(\"C:\\Users\\USER\\Desktop\\jupyter\\8. Netflix_Dataset.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "ba5f4708",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Show_Id</th>\n",
       "      <th>Category</th>\n",
       "      <th>Title</th>\n",
       "      <th>Director</th>\n",
       "      <th>Cast</th>\n",
       "      <th>Country</th>\n",
       "      <th>Release_Date</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Duration</th>\n",
       "      <th>Type</th>\n",
       "      <th>Description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>s1</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>3%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>João Miguel, Bianca Comparato, Michel Gomes, R...</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>August 14, 2020</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>4 Seasons</td>\n",
       "      <td>International TV Shows, TV Dramas, TV Sci-Fi &amp;...</td>\n",
       "      <td>In a future where the elite inhabit an island ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>s2</td>\n",
       "      <td>Movie</td>\n",
       "      <td>07:19</td>\n",
       "      <td>Jorge Michel Grau</td>\n",
       "      <td>Demián Bichir, Héctor Bonilla, Oscar Serrano, ...</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>December 23, 2016</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>93 min</td>\n",
       "      <td>Dramas, International Movies</td>\n",
       "      <td>After a devastating earthquake hits Mexico Cit...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>s3</td>\n",
       "      <td>Movie</td>\n",
       "      <td>23:59</td>\n",
       "      <td>Gilbert Chan</td>\n",
       "      <td>Tedd Chan, Stella Chung, Henley Hii, Lawrence ...</td>\n",
       "      <td>Singapore</td>\n",
       "      <td>December 20, 2018</td>\n",
       "      <td>R</td>\n",
       "      <td>78 min</td>\n",
       "      <td>Horror Movies, International Movies</td>\n",
       "      <td>When an army recruit is found dead, his fellow...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>s4</td>\n",
       "      <td>Movie</td>\n",
       "      <td>9</td>\n",
       "      <td>Shane Acker</td>\n",
       "      <td>Elijah Wood, John C. Reilly, Jennifer Connelly...</td>\n",
       "      <td>United States</td>\n",
       "      <td>November 16, 2017</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>80 min</td>\n",
       "      <td>Action &amp; Adventure, Independent Movies, Sci-Fi...</td>\n",
       "      <td>In a postapocalyptic world, rag-doll robots hi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>s5</td>\n",
       "      <td>Movie</td>\n",
       "      <td>21</td>\n",
       "      <td>Robert Luketic</td>\n",
       "      <td>Jim Sturgess, Kevin Spacey, Kate Bosworth, Aar...</td>\n",
       "      <td>United States</td>\n",
       "      <td>January 1, 2020</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>123 min</td>\n",
       "      <td>Dramas</td>\n",
       "      <td>A brilliant group of students become card-coun...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7784</th>\n",
       "      <td>s7783</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Zozo</td>\n",
       "      <td>Josef Fares</td>\n",
       "      <td>Imad Creidi, Antoinette Turk, Elias Gergi, Car...</td>\n",
       "      <td>Sweden, Czech Republic, United Kingdom, Denmar...</td>\n",
       "      <td>October 19, 2020</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>99 min</td>\n",
       "      <td>Dramas, International Movies</td>\n",
       "      <td>When Lebanon's Civil War deprives Zozo of his ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7785</th>\n",
       "      <td>s7784</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Zubaan</td>\n",
       "      <td>Mozez Singh</td>\n",
       "      <td>Vicky Kaushal, Sarah-Jane Dias, Raaghav Chanan...</td>\n",
       "      <td>India</td>\n",
       "      <td>March 2, 2019</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>111 min</td>\n",
       "      <td>Dramas, International Movies, Music &amp; Musicals</td>\n",
       "      <td>A scrappy but poor boy worms his way into a ty...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7786</th>\n",
       "      <td>s7785</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Zulu Man in Japan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nasty C</td>\n",
       "      <td>NaN</td>\n",
       "      <td>September 25, 2020</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>44 min</td>\n",
       "      <td>Documentaries, International Movies, Music &amp; M...</td>\n",
       "      <td>In this documentary, South African rapper Nast...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7787</th>\n",
       "      <td>s7786</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Zumbo's Just Desserts</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Adriano Zumbo, Rachel Khoo</td>\n",
       "      <td>Australia</td>\n",
       "      <td>October 31, 2020</td>\n",
       "      <td>TV-PG</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>International TV Shows, Reality TV</td>\n",
       "      <td>Dessert wizard Adriano Zumbo looks for the nex...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7788</th>\n",
       "      <td>s7787</td>\n",
       "      <td>Movie</td>\n",
       "      <td>ZZ TOP: THAT LITTLE OL' BAND FROM TEXAS</td>\n",
       "      <td>Sam Dunn</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United Kingdom, Canada, United States</td>\n",
       "      <td>March 1, 2020</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>90 min</td>\n",
       "      <td>Documentaries, Music &amp; Musicals</td>\n",
       "      <td>This documentary delves into the mystique behi...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7789 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Show_Id Category                                    Title  \\\n",
       "0         s1  TV Show                                       3%   \n",
       "1         s2    Movie                                    07:19   \n",
       "2         s3    Movie                                    23:59   \n",
       "3         s4    Movie                                        9   \n",
       "4         s5    Movie                                       21   \n",
       "...      ...      ...                                      ...   \n",
       "7784   s7783    Movie                                     Zozo   \n",
       "7785   s7784    Movie                                   Zubaan   \n",
       "7786   s7785    Movie                        Zulu Man in Japan   \n",
       "7787   s7786  TV Show                    Zumbo's Just Desserts   \n",
       "7788   s7787    Movie  ZZ TOP: THAT LITTLE OL' BAND FROM TEXAS   \n",
       "\n",
       "               Director                                               Cast  \\\n",
       "0                   NaN  João Miguel, Bianca Comparato, Michel Gomes, R...   \n",
       "1     Jorge Michel Grau  Demián Bichir, Héctor Bonilla, Oscar Serrano, ...   \n",
       "2          Gilbert Chan  Tedd Chan, Stella Chung, Henley Hii, Lawrence ...   \n",
       "3           Shane Acker  Elijah Wood, John C. Reilly, Jennifer Connelly...   \n",
       "4        Robert Luketic  Jim Sturgess, Kevin Spacey, Kate Bosworth, Aar...   \n",
       "...                 ...                                                ...   \n",
       "7784        Josef Fares  Imad Creidi, Antoinette Turk, Elias Gergi, Car...   \n",
       "7785        Mozez Singh  Vicky Kaushal, Sarah-Jane Dias, Raaghav Chanan...   \n",
       "7786                NaN                                            Nasty C   \n",
       "7787                NaN                         Adriano Zumbo, Rachel Khoo   \n",
       "7788           Sam Dunn                                                NaN   \n",
       "\n",
       "                                                Country        Release_Date  \\\n",
       "0                                                Brazil     August 14, 2020   \n",
       "1                                                Mexico   December 23, 2016   \n",
       "2                                             Singapore   December 20, 2018   \n",
       "3                                         United States   November 16, 2017   \n",
       "4                                         United States     January 1, 2020   \n",
       "...                                                 ...                 ...   \n",
       "7784  Sweden, Czech Republic, United Kingdom, Denmar...    October 19, 2020   \n",
       "7785                                              India       March 2, 2019   \n",
       "7786                                                NaN  September 25, 2020   \n",
       "7787                                          Australia    October 31, 2020   \n",
       "7788              United Kingdom, Canada, United States       March 1, 2020   \n",
       "\n",
       "     Rating   Duration                                               Type  \\\n",
       "0     TV-MA  4 Seasons  International TV Shows, TV Dramas, TV Sci-Fi &...   \n",
       "1     TV-MA     93 min                       Dramas, International Movies   \n",
       "2         R     78 min                Horror Movies, International Movies   \n",
       "3     PG-13     80 min  Action & Adventure, Independent Movies, Sci-Fi...   \n",
       "4     PG-13    123 min                                             Dramas   \n",
       "...     ...        ...                                                ...   \n",
       "7784  TV-MA     99 min                       Dramas, International Movies   \n",
       "7785  TV-14    111 min     Dramas, International Movies, Music & Musicals   \n",
       "7786  TV-MA     44 min  Documentaries, International Movies, Music & M...   \n",
       "7787  TV-PG   1 Season                 International TV Shows, Reality TV   \n",
       "7788  TV-MA     90 min                    Documentaries, Music & Musicals   \n",
       "\n",
       "                                            Description  \n",
       "0     In a future where the elite inhabit an island ...  \n",
       "1     After a devastating earthquake hits Mexico Cit...  \n",
       "2     When an army recruit is found dead, his fellow...  \n",
       "3     In a postapocalyptic world, rag-doll robots hi...  \n",
       "4     A brilliant group of students become card-coun...  \n",
       "...                                                 ...  \n",
       "7784  When Lebanon's Civil War deprives Zozo of his ...  \n",
       "7785  A scrappy but poor boy worms his way into a ty...  \n",
       "7786  In this documentary, South African rapper Nast...  \n",
       "7787  Dessert wizard Adriano Zumbo looks for the nex...  \n",
       "7788  This documentary delves into the mystique behi...  \n",
       "\n",
       "[7789 rows x 11 columns]"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# To remove unicode error we need to write \"r\" before path\n",
    "\n",
    "\n",
    "data=pd.read_csv(r\"C:\\Users\\USER\\Desktop\\jupyter\\8. Netflix_Dataset.csv\")\n",
    "data\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f51e3b45",
   "metadata": {},
   "source": [
    "# Getting some information about our data set\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "18629f67",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Show_Id</th>\n",
       "      <th>Category</th>\n",
       "      <th>Title</th>\n",
       "      <th>Director</th>\n",
       "      <th>Cast</th>\n",
       "      <th>Country</th>\n",
       "      <th>Release_Date</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Duration</th>\n",
       "      <th>Type</th>\n",
       "      <th>Description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>s1</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>3%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>João Miguel, Bianca Comparato, Michel Gomes, R...</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>August 14, 2020</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>4 Seasons</td>\n",
       "      <td>International TV Shows, TV Dramas, TV Sci-Fi &amp;...</td>\n",
       "      <td>In a future where the elite inhabit an island ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>s2</td>\n",
       "      <td>Movie</td>\n",
       "      <td>07:19</td>\n",
       "      <td>Jorge Michel Grau</td>\n",
       "      <td>Demián Bichir, Héctor Bonilla, Oscar Serrano, ...</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>December 23, 2016</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>93 min</td>\n",
       "      <td>Dramas, International Movies</td>\n",
       "      <td>After a devastating earthquake hits Mexico Cit...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>s3</td>\n",
       "      <td>Movie</td>\n",
       "      <td>23:59</td>\n",
       "      <td>Gilbert Chan</td>\n",
       "      <td>Tedd Chan, Stella Chung, Henley Hii, Lawrence ...</td>\n",
       "      <td>Singapore</td>\n",
       "      <td>December 20, 2018</td>\n",
       "      <td>R</td>\n",
       "      <td>78 min</td>\n",
       "      <td>Horror Movies, International Movies</td>\n",
       "      <td>When an army recruit is found dead, his fellow...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>s4</td>\n",
       "      <td>Movie</td>\n",
       "      <td>9</td>\n",
       "      <td>Shane Acker</td>\n",
       "      <td>Elijah Wood, John C. Reilly, Jennifer Connelly...</td>\n",
       "      <td>United States</td>\n",
       "      <td>November 16, 2017</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>80 min</td>\n",
       "      <td>Action &amp; Adventure, Independent Movies, Sci-Fi...</td>\n",
       "      <td>In a postapocalyptic world, rag-doll robots hi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>s5</td>\n",
       "      <td>Movie</td>\n",
       "      <td>21</td>\n",
       "      <td>Robert Luketic</td>\n",
       "      <td>Jim Sturgess, Kevin Spacey, Kate Bosworth, Aar...</td>\n",
       "      <td>United States</td>\n",
       "      <td>January 1, 2020</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>123 min</td>\n",
       "      <td>Dramas</td>\n",
       "      <td>A brilliant group of students become card-coun...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Show_Id Category  Title           Director  \\\n",
       "0      s1  TV Show     3%                NaN   \n",
       "1      s2    Movie  07:19  Jorge Michel Grau   \n",
       "2      s3    Movie  23:59       Gilbert Chan   \n",
       "3      s4    Movie      9        Shane Acker   \n",
       "4      s5    Movie     21     Robert Luketic   \n",
       "\n",
       "                                                Cast        Country  \\\n",
       "0  João Miguel, Bianca Comparato, Michel Gomes, R...         Brazil   \n",
       "1  Demián Bichir, Héctor Bonilla, Oscar Serrano, ...         Mexico   \n",
       "2  Tedd Chan, Stella Chung, Henley Hii, Lawrence ...      Singapore   \n",
       "3  Elijah Wood, John C. Reilly, Jennifer Connelly...  United States   \n",
       "4  Jim Sturgess, Kevin Spacey, Kate Bosworth, Aar...  United States   \n",
       "\n",
       "        Release_Date Rating   Duration  \\\n",
       "0    August 14, 2020  TV-MA  4 Seasons   \n",
       "1  December 23, 2016  TV-MA     93 min   \n",
       "2  December 20, 2018      R     78 min   \n",
       "3  November 16, 2017  PG-13     80 min   \n",
       "4    January 1, 2020  PG-13    123 min   \n",
       "\n",
       "                                                Type  \\\n",
       "0  International TV Shows, TV Dramas, TV Sci-Fi &...   \n",
       "1                       Dramas, International Movies   \n",
       "2                Horror Movies, International Movies   \n",
       "3  Action & Adventure, Independent Movies, Sci-Fi...   \n",
       "4                                             Dramas   \n",
       "\n",
       "                                         Description  \n",
       "0  In a future where the elite inhabit an island ...  \n",
       "1  After a devastating earthquake hits Mexico Cit...  \n",
       "2  When an army recruit is found dead, his fellow...  \n",
       "3  In a postapocalyptic world, rag-doll robots hi...  \n",
       "4  A brilliant group of students become card-coun...  "
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "c442a628",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Show_Id</th>\n",
       "      <th>Category</th>\n",
       "      <th>Title</th>\n",
       "      <th>Director</th>\n",
       "      <th>Cast</th>\n",
       "      <th>Country</th>\n",
       "      <th>Release_Date</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Duration</th>\n",
       "      <th>Type</th>\n",
       "      <th>Description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>7784</th>\n",
       "      <td>s7783</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Zozo</td>\n",
       "      <td>Josef Fares</td>\n",
       "      <td>Imad Creidi, Antoinette Turk, Elias Gergi, Car...</td>\n",
       "      <td>Sweden, Czech Republic, United Kingdom, Denmar...</td>\n",
       "      <td>October 19, 2020</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>99 min</td>\n",
       "      <td>Dramas, International Movies</td>\n",
       "      <td>When Lebanon's Civil War deprives Zozo of his ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7785</th>\n",
       "      <td>s7784</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Zubaan</td>\n",
       "      <td>Mozez Singh</td>\n",
       "      <td>Vicky Kaushal, Sarah-Jane Dias, Raaghav Chanan...</td>\n",
       "      <td>India</td>\n",
       "      <td>March 2, 2019</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>111 min</td>\n",
       "      <td>Dramas, International Movies, Music &amp; Musicals</td>\n",
       "      <td>A scrappy but poor boy worms his way into a ty...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7786</th>\n",
       "      <td>s7785</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Zulu Man in Japan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nasty C</td>\n",
       "      <td>NaN</td>\n",
       "      <td>September 25, 2020</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>44 min</td>\n",
       "      <td>Documentaries, International Movies, Music &amp; M...</td>\n",
       "      <td>In this documentary, South African rapper Nast...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7787</th>\n",
       "      <td>s7786</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Zumbo's Just Desserts</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Adriano Zumbo, Rachel Khoo</td>\n",
       "      <td>Australia</td>\n",
       "      <td>October 31, 2020</td>\n",
       "      <td>TV-PG</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>International TV Shows, Reality TV</td>\n",
       "      <td>Dessert wizard Adriano Zumbo looks for the nex...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7788</th>\n",
       "      <td>s7787</td>\n",
       "      <td>Movie</td>\n",
       "      <td>ZZ TOP: THAT LITTLE OL' BAND FROM TEXAS</td>\n",
       "      <td>Sam Dunn</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United Kingdom, Canada, United States</td>\n",
       "      <td>March 1, 2020</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>90 min</td>\n",
       "      <td>Documentaries, Music &amp; Musicals</td>\n",
       "      <td>This documentary delves into the mystique behi...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Show_Id Category                                    Title     Director  \\\n",
       "7784   s7783    Movie                                     Zozo  Josef Fares   \n",
       "7785   s7784    Movie                                   Zubaan  Mozez Singh   \n",
       "7786   s7785    Movie                        Zulu Man in Japan          NaN   \n",
       "7787   s7786  TV Show                    Zumbo's Just Desserts          NaN   \n",
       "7788   s7787    Movie  ZZ TOP: THAT LITTLE OL' BAND FROM TEXAS     Sam Dunn   \n",
       "\n",
       "                                                   Cast  \\\n",
       "7784  Imad Creidi, Antoinette Turk, Elias Gergi, Car...   \n",
       "7785  Vicky Kaushal, Sarah-Jane Dias, Raaghav Chanan...   \n",
       "7786                                            Nasty C   \n",
       "7787                         Adriano Zumbo, Rachel Khoo   \n",
       "7788                                                NaN   \n",
       "\n",
       "                                                Country        Release_Date  \\\n",
       "7784  Sweden, Czech Republic, United Kingdom, Denmar...    October 19, 2020   \n",
       "7785                                              India       March 2, 2019   \n",
       "7786                                                NaN  September 25, 2020   \n",
       "7787                                          Australia    October 31, 2020   \n",
       "7788              United Kingdom, Canada, United States       March 1, 2020   \n",
       "\n",
       "     Rating  Duration                                               Type  \\\n",
       "7784  TV-MA    99 min                       Dramas, International Movies   \n",
       "7785  TV-14   111 min     Dramas, International Movies, Music & Musicals   \n",
       "7786  TV-MA    44 min  Documentaries, International Movies, Music & M...   \n",
       "7787  TV-PG  1 Season                 International TV Shows, Reality TV   \n",
       "7788  TV-MA    90 min                    Documentaries, Music & Musicals   \n",
       "\n",
       "                                            Description  \n",
       "7784  When Lebanon's Civil War deprives Zozo of his ...  \n",
       "7785  A scrappy but poor boy worms his way into a ty...  \n",
       "7786  In this documentary, South African rapper Nast...  \n",
       "7787  Dessert wizard Adriano Zumbo looks for the nex...  \n",
       "7788  This documentary delves into the mystique behi...  "
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "6af37a8f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(7789, 11)"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "fd7ae00e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "85679"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.size"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "35965558",
   "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": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "a8c64cbf",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 7789 entries, 0 to 7788\n",
      "Data columns (total 11 columns):\n",
      " #   Column        Non-Null Count  Dtype \n",
      "---  ------        --------------  ----- \n",
      " 0   Show_Id       7789 non-null   object\n",
      " 1   Category      7789 non-null   object\n",
      " 2   Title         7789 non-null   object\n",
      " 3   Director      5401 non-null   object\n",
      " 4   Cast          7071 non-null   object\n",
      " 5   Country       7282 non-null   object\n",
      " 6   Release_Date  7779 non-null   object\n",
      " 7   Rating        7782 non-null   object\n",
      " 8   Duration      7789 non-null   object\n",
      " 9   Type          7789 non-null   object\n",
      " 10  Description   7789 non-null   object\n",
      "dtypes: object(11)\n",
      "memory usage: 669.5+ KB\n"
     ]
    }
   ],
   "source": [
    "data.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "ae0152ef",
   "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": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.dtypes"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e1b625a6",
   "metadata": {},
   "source": [
    "# Find Duplicate value if found then remove it !"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "1a766cb3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0       False\n",
       "1       False\n",
       "2       False\n",
       "3       False\n",
       "4       False\n",
       "        ...  \n",
       "7784    False\n",
       "7785    False\n",
       "7786    False\n",
       "7787    False\n",
       "7788    False\n",
       "Length: 7789, dtype: bool"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.duplicated()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "4e1fd382",
   "metadata": {
    "scrolled": true
   },
   "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": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data.duplicated()]   #These rows are duplicate in our dataset "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "id": "9793c2d9",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Show_Id</th>\n",
       "      <th>Category</th>\n",
       "      <th>Title</th>\n",
       "      <th>Director</th>\n",
       "      <th>Cast</th>\n",
       "      <th>Country</th>\n",
       "      <th>Release_Date</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Duration</th>\n",
       "      <th>Type</th>\n",
       "      <th>Description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>s1</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>3%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>João Miguel, Bianca Comparato, Michel Gomes, R...</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>August 14, 2020</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>4 Seasons</td>\n",
       "      <td>International TV Shows, TV Dramas, TV Sci-Fi &amp;...</td>\n",
       "      <td>In a future where the elite inhabit an island ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>s2</td>\n",
       "      <td>Movie</td>\n",
       "      <td>07:19</td>\n",
       "      <td>Jorge Michel Grau</td>\n",
       "      <td>Demián Bichir, Héctor Bonilla, Oscar Serrano, ...</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>December 23, 2016</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>93 min</td>\n",
       "      <td>Dramas, International Movies</td>\n",
       "      <td>After a devastating earthquake hits Mexico Cit...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>s3</td>\n",
       "      <td>Movie</td>\n",
       "      <td>23:59</td>\n",
       "      <td>Gilbert Chan</td>\n",
       "      <td>Tedd Chan, Stella Chung, Henley Hii, Lawrence ...</td>\n",
       "      <td>Singapore</td>\n",
       "      <td>December 20, 2018</td>\n",
       "      <td>R</td>\n",
       "      <td>78 min</td>\n",
       "      <td>Horror Movies, International Movies</td>\n",
       "      <td>When an army recruit is found dead, his fellow...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>s4</td>\n",
       "      <td>Movie</td>\n",
       "      <td>9</td>\n",
       "      <td>Shane Acker</td>\n",
       "      <td>Elijah Wood, John C. Reilly, Jennifer Connelly...</td>\n",
       "      <td>United States</td>\n",
       "      <td>November 16, 2017</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>80 min</td>\n",
       "      <td>Action &amp; Adventure, Independent Movies, Sci-Fi...</td>\n",
       "      <td>In a postapocalyptic world, rag-doll robots hi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>s5</td>\n",
       "      <td>Movie</td>\n",
       "      <td>21</td>\n",
       "      <td>Robert Luketic</td>\n",
       "      <td>Jim Sturgess, Kevin Spacey, Kate Bosworth, Aar...</td>\n",
       "      <td>United States</td>\n",
       "      <td>January 1, 2020</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>123 min</td>\n",
       "      <td>Dramas</td>\n",
       "      <td>A brilliant group of students become card-coun...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7784</th>\n",
       "      <td>s7783</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Zozo</td>\n",
       "      <td>Josef Fares</td>\n",
       "      <td>Imad Creidi, Antoinette Turk, Elias Gergi, Car...</td>\n",
       "      <td>Sweden, Czech Republic, United Kingdom, Denmar...</td>\n",
       "      <td>October 19, 2020</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>99 min</td>\n",
       "      <td>Dramas, International Movies</td>\n",
       "      <td>When Lebanon's Civil War deprives Zozo of his ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7785</th>\n",
       "      <td>s7784</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Zubaan</td>\n",
       "      <td>Mozez Singh</td>\n",
       "      <td>Vicky Kaushal, Sarah-Jane Dias, Raaghav Chanan...</td>\n",
       "      <td>India</td>\n",
       "      <td>March 2, 2019</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>111 min</td>\n",
       "      <td>Dramas, International Movies, Music &amp; Musicals</td>\n",
       "      <td>A scrappy but poor boy worms his way into a ty...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7786</th>\n",
       "      <td>s7785</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Zulu Man in Japan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nasty C</td>\n",
       "      <td>NaN</td>\n",
       "      <td>September 25, 2020</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>44 min</td>\n",
       "      <td>Documentaries, International Movies, Music &amp; M...</td>\n",
       "      <td>In this documentary, South African rapper Nast...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7787</th>\n",
       "      <td>s7786</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Zumbo's Just Desserts</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Adriano Zumbo, Rachel Khoo</td>\n",
       "      <td>Australia</td>\n",
       "      <td>October 31, 2020</td>\n",
       "      <td>TV-PG</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>International TV Shows, Reality TV</td>\n",
       "      <td>Dessert wizard Adriano Zumbo looks for the nex...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7788</th>\n",
       "      <td>s7787</td>\n",
       "      <td>Movie</td>\n",
       "      <td>ZZ TOP: THAT LITTLE OL' BAND FROM TEXAS</td>\n",
       "      <td>Sam Dunn</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United Kingdom, Canada, United States</td>\n",
       "      <td>March 1, 2020</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>90 min</td>\n",
       "      <td>Documentaries, Music &amp; Musicals</td>\n",
       "      <td>This documentary delves into the mystique behi...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7787 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Show_Id Category                                    Title  \\\n",
       "0         s1  TV Show                                       3%   \n",
       "1         s2    Movie                                    07:19   \n",
       "2         s3    Movie                                    23:59   \n",
       "3         s4    Movie                                        9   \n",
       "4         s5    Movie                                       21   \n",
       "...      ...      ...                                      ...   \n",
       "7784   s7783    Movie                                     Zozo   \n",
       "7785   s7784    Movie                                   Zubaan   \n",
       "7786   s7785    Movie                        Zulu Man in Japan   \n",
       "7787   s7786  TV Show                    Zumbo's Just Desserts   \n",
       "7788   s7787    Movie  ZZ TOP: THAT LITTLE OL' BAND FROM TEXAS   \n",
       "\n",
       "               Director                                               Cast  \\\n",
       "0                   NaN  João Miguel, Bianca Comparato, Michel Gomes, R...   \n",
       "1     Jorge Michel Grau  Demián Bichir, Héctor Bonilla, Oscar Serrano, ...   \n",
       "2          Gilbert Chan  Tedd Chan, Stella Chung, Henley Hii, Lawrence ...   \n",
       "3           Shane Acker  Elijah Wood, John C. Reilly, Jennifer Connelly...   \n",
       "4        Robert Luketic  Jim Sturgess, Kevin Spacey, Kate Bosworth, Aar...   \n",
       "...                 ...                                                ...   \n",
       "7784        Josef Fares  Imad Creidi, Antoinette Turk, Elias Gergi, Car...   \n",
       "7785        Mozez Singh  Vicky Kaushal, Sarah-Jane Dias, Raaghav Chanan...   \n",
       "7786                NaN                                            Nasty C   \n",
       "7787                NaN                         Adriano Zumbo, Rachel Khoo   \n",
       "7788           Sam Dunn                                                NaN   \n",
       "\n",
       "                                                Country        Release_Date  \\\n",
       "0                                                Brazil     August 14, 2020   \n",
       "1                                                Mexico   December 23, 2016   \n",
       "2                                             Singapore   December 20, 2018   \n",
       "3                                         United States   November 16, 2017   \n",
       "4                                         United States     January 1, 2020   \n",
       "...                                                 ...                 ...   \n",
       "7784  Sweden, Czech Republic, United Kingdom, Denmar...    October 19, 2020   \n",
       "7785                                              India       March 2, 2019   \n",
       "7786                                                NaN  September 25, 2020   \n",
       "7787                                          Australia    October 31, 2020   \n",
       "7788              United Kingdom, Canada, United States       March 1, 2020   \n",
       "\n",
       "     Rating   Duration                                               Type  \\\n",
       "0     TV-MA  4 Seasons  International TV Shows, TV Dramas, TV Sci-Fi &...   \n",
       "1     TV-MA     93 min                       Dramas, International Movies   \n",
       "2         R     78 min                Horror Movies, International Movies   \n",
       "3     PG-13     80 min  Action & Adventure, Independent Movies, Sci-Fi...   \n",
       "4     PG-13    123 min                                             Dramas   \n",
       "...     ...        ...                                                ...   \n",
       "7784  TV-MA     99 min                       Dramas, International Movies   \n",
       "7785  TV-14    111 min     Dramas, International Movies, Music & Musicals   \n",
       "7786  TV-MA     44 min  Documentaries, International Movies, Music & M...   \n",
       "7787  TV-PG   1 Season                 International TV Shows, Reality TV   \n",
       "7788  TV-MA     90 min                    Documentaries, Music & Musicals   \n",
       "\n",
       "                                            Description  \n",
       "0     In a future where the elite inhabit an island ...  \n",
       "1     After a devastating earthquake hits Mexico Cit...  \n",
       "2     When an army recruit is found dead, his fellow...  \n",
       "3     In a postapocalyptic world, rag-doll robots hi...  \n",
       "4     A brilliant group of students become card-coun...  \n",
       "...                                                 ...  \n",
       "7784  When Lebanon's Civil War deprives Zozo of his ...  \n",
       "7785  A scrappy but poor boy worms his way into a ty...  \n",
       "7786  In this documentary, South African rapper Nast...  \n",
       "7787  Dessert wizard Adriano Zumbo looks for the nex...  \n",
       "7788  This documentary delves into the mystique behi...  \n",
       "\n",
       "[7787 rows x 11 columns]"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.drop_duplicates(inplace=True)                  #to remove duplicate values in dataFrame \n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "331def38",
   "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": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data.duplicated()]        #verify that there are no duplicate values in our dataset"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "fc495e2c",
   "metadata": {},
   "source": [
    "# task-2 to show NaN values with heat map"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "10b204ef",
   "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>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7784</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7785</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7786</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7787</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7788</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7787 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Show_Id  Category  Title  Director   Cast  Country  Release_Date  \\\n",
       "0       False     False  False      True  False    False         False   \n",
       "1       False     False  False     False  False    False         False   \n",
       "2       False     False  False     False  False    False         False   \n",
       "3       False     False  False     False  False    False         False   \n",
       "4       False     False  False     False  False    False         False   \n",
       "...       ...       ...    ...       ...    ...      ...           ...   \n",
       "7784    False     False  False     False  False    False         False   \n",
       "7785    False     False  False     False  False    False         False   \n",
       "7786    False     False  False      True  False     True         False   \n",
       "7787    False     False  False      True  False    False         False   \n",
       "7788    False     False  False     False   True    False         False   \n",
       "\n",
       "      Rating  Duration   Type  Description  \n",
       "0      False     False  False        False  \n",
       "1      False     False  False        False  \n",
       "2      False     False  False        False  \n",
       "3      False     False  False        False  \n",
       "4      False     False  False        False  \n",
       "...      ...       ...    ...          ...  \n",
       "7784   False     False  False        False  \n",
       "7785   False     False  False        False  \n",
       "7786   False     False  False        False  \n",
       "7787   False     False  False        False  \n",
       "7788   False     False  False        False  \n",
       "\n",
       "[7787 rows x 11 columns]"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.isnull()                             #showing boolean only "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "4c86db5e",
   "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": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.isnull().sum()                       #Shows count f all null values in every colums"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "id": "61471d0c",
   "metadata": {},
   "outputs": [],
   "source": [
    "import seaborn as sns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "id": "03f7ffbf",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:>"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAW0AAAE3CAYAAABhFBCzAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjQuMywgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/MnkTPAAAACXBIWXMAAAsTAAALEwEAmpwYAAA+kElEQVR4nO2deZhcVbX2f2/CGCAENXCZBwWUWYboRVQEQeBeQEUFHEDxE0FQhs8BRBQVPxFRQOCCyAVBEWTUIJOAzGMShhAEJMwBJASUUQlJv98fexepVKq7q7tODad6/Z7nPKmzz6m9d3V3Vu2z9nrXkm2CIAiCcjCq0xMIgiAIGieMdhAEQYkIox0EQVAiwmgHQRCUiDDaQRAEJSKMdhAEQYlou9GWtJ2kByVNl3RIu8cPgiAoM2012pJGAycB2wPrALtLWqedcwiCIGgHkk6XNFPStH6uS9Iv8gJ2qqSNG+m33SvtCcB024/Yng2cC+zc5jkEQRC0g18D2w1wfXtgzXzsDZzcSKftNtorAk9Wnc/IbUEQBD2F7RuAFwa4ZWfgLCduA8ZJWn6wfhcqaoINojptC+joJe1N+uZBo5feZNSoJVo9r1Lzr6dvbGn/i6/w/pb2HwRFMWf2U/VsTMO8MeuRhvN6LDL+7V8m26nMqbZPHcJw/S1inxnoTe022jOAlavOVwKerr0pf/BTARZaZMVIjjIIYVSDoCD65jZ8a7WdGiYNLWJrabd7ZBKwpqTVJS0C7AZMbPMcgiAI6uO+xo/maWgRW0tbjbbtOcD+wJXA/cB5tu9r5xyCIAj6pa+v8aN5JgJ75CiS9wIv2h7QNQLtd49g+zLgsnaPGwRBMBguZgUNgKRzgC2Bt0maAXwPWDiN41NIdnAHYDrwGvCFRvptu9EOglpavZEK4fcPGqSYFTQAtncf5LqB/YbabxjtoOOEQQ26hrlvdHoGgzJsn7akxSTdIekeSfdJ+n5u/72ku/PxmKS7c/tbJV0r6RVJJxY0/yAIguJo70bksGhmpf06sJXtVyQtDNwk6XLbu1ZukPQz4MV8+m/gcGC9fARBEHQXBbpHWsWwjXb2x7ySTxfOx5sxhpIEfArYKt//Ksmwv2PYsw2CIGghRW5EtoqmQv4kjc7uj5nAVbZvr7r8fuBZ2w81M0YQBEHbaG/I37Boymjbnmt7I1JQ+ARJ1W6P3YFzhtOvpL0lTZY0ua/v1WamGARB0Dg97tN+E9v/lHQdKaPVNEkLAR8HNhlmfyFjD4Kg/fR49Mh4SePy68WBDwMP5MsfBh6wPaPpGQZBELSLErhHmllpLw+cmQsbjCJJ0v+Ur+1GHdeIpMeAscAikj4KbGv7r03MIQiCoDhKsBHZTPTIVODd/Vz7fD/tqw13vCAIgpbTyyF/QRAEvYbdeGrWTjFsoy1pbeD3VU1rAN+1fVy+/nXgp8B427MkbQMcBSwCzAa+Yfsvwx0/mEcUQQiCgpg7p9MzGJRm3CMPAhvBmwV7nwIuzucrA9sAT1S9ZRawo+2nc2jglUSpsUJotVGNL4VgxNDLPu0atgYetv14Pj8W+Cbwx8oNtu+quv8+YDFJi9p+vaA5jFjakSWvlUSWv6BrGELlmk5RlNF+M1pE0k7AU7bvSUr2uuwC3BUGuxjCIAVBQYyElXYuG7YTcKikMcBhwLYD3L8u8JNB7qku7EsU9g2CoC2MkOiR7YE7bT8raX1gdaCyyl4JuFPSBNt/l7QSye+9h+2H++swFJFDI3zOQVAQI2GlTVWOEdv3AstWLmQxzaY5emQccClwqO2bCxg3yIRRDYKCmNP90SPNZvkbQ4oSuaiB2/cH3gEcXlUkYdnB3hQEQdAu7LkNH52iqZW27deAtw5wfbWq10cCRzYzXhAEQUsZIT7toMOETzsICqIXfNqSTgf+G5hpe73c9kngCOBdwATbk3P7W4ELgM2AX9vev6qfK0hJphYCbgT2cxk0oyUgxDVBUBA9stL+NXAicFZV2zRSvuxf1tw7UB3IT9l+KZchuwD4JHDuMOYctJkwqsGIoRdW2rZvkLRaTdv9ALXimYHqQNp+qWrMRaiqJxk0R6yEg6Agejn3yHCQdCUwAbictNoOCiCMahAURI+4RwrD9kckLQacTarSflU7x+9VYqUdBAURRntBbP9b0kRgZ/ox2iFjHxphVIOgIErg025KXNMokpaUtHx+vRCwA/PqSS6A7VNtb2p70zDYQRC0jV6oESnpHGBL4G2SZgDfA14ATgDGA5dKutv2R/L9j1FTBxJ4HpgoaVFgNPAX4JSiP0wQBEFT9MJGpO3d+7l0cT/3r9bP/Zs1OKdgiIRPOwgKogTukVBEBkEQVIiNyKAdxEo4CAqiBEZ70I1ISadLmilpWp1rX5dkSW/L5wtLOlPSvZLul3RonfdMrNdXEARBx7EbPzpEI9Ejvwa2q23sp3jvJ4FFba8PbAJ8uVpNKenjwCtNzDcIgqB19EL0SD0Ze2aB4r0kafoSOaxvcWA28BKksD/gYFL89XnNTTuopuwbkVHYN+gaeiF6pB4DFO+9gCSaeQYYAxxk+4V87YfAz4DXhj/doB5lN0hln3/QQxS8gpa0HXA8KdT5NNtH1VxfGvgtsArJHh9j+4yB+hyy0R6keO8EYC6wArAMcKOkq0lx2++wfVA/q/baMUIRGQRB+ynQVy1pNHASyY08A5gkaaLtv1bdth/wV9s7ShoPPCjpbNuz++t3OCvtt9NP8V7g08AVtt8AZkq6GdiUVN1mkyy8WQhYVtJ1tresN0AU9g2CoCMUu9KeAEy3/QiApHNJnohqo21gqZyyekmScHFAH82QZey277W9rO3VspBmBrCx7b+TNiW3UmIJ4L3AA7ZPtr1Cvn8L4G/9GewgCIKOMYSNSEl7S5pcdexd09uKwJNV5zNyWzUnkorJPA3cCxxgD6zwaSTk7xzgVmBtSTMkfXGA208ifVtMAyYBZ9ieOtgYQRAEXYH7Gj6qcyTl49Sa3lRvhJrzjwB3k1zKGwEnSho70BSbkbFXrq9W9foVUtjfQPc/xoJVbYIgCDqO5xRaAXEGsHLV+UqkFXU1XwCOsm1guqRHgXcCd/TXaVuy/AVBEJSCIay0G2ASsKak1SUtAuwGTKy55wlgawBJywFrA48M1OmwFJGSNpJ0m6S7sy9nQm5fTdK/cvvdkk6pes91kh6surZsI586CIKgbfS58WMQbM8B9geuBO4HzrN9n6R9JO2Tb/shsLmke4FrgG/ZnjVQv8Mt7Hs08H3bl0vaIZ9vma89bHujfvr6TKVyexBUCHFN0DUUHKdt+zLgspq2U6peP0398Ol+Ga4i0qTYa4ClWdBPEwQNEwY16BpKkDBquFn+DgSulHQMycWyedW11SXdRZKvf8d29TLqDElzgQuBI7PzPWiSssvYg6BrmFvoRmRLGK7R3pckUb9Q0qeA/wU+TJKvr2L7eUmbAH+QtK7tl0iukackLUUy2p9jfpfLm4QicmiEUQ2CgmjAV91phmu09wQOyK/PB04DsP068Hp+PUXSw8BawGTbT+X2lyX9jqQWqmu0QxE5sgifdtA19HDlmqeBDwLXAVsBDwFk7fwLtudKWgNYE3gkZ/0bZ3uWpIWB/waubnbyQW8QBjXoGnphpd1PYd8vAcdnY/xvsisD+ADwA0lzSImj9rH9Qpa0X5kN9miSwf5V0R8mCIKgGdwLG5EDKCI3qXPvhSR/dW37q/XuD4Ig6Cp6YaUdBEEwYihB9EgjisiVJV2baz7eJ+mA3P5TSQ9ImirpYknjcvs2kqbkOpFTJG1V1dcikk6V9Lf83l1a9smCIAiGSgnKjTWSe2QO8H9tv4uUanU/SesAVwHr2d4A+BtQKeI7C9gx14ncE/hNVV+HATNtrwWsA1xfzMcIgiAogAJl7K2iEZ/2M6T460q43v3Airb/XHXbbcAn8j13VbXfBywmadEcDrgXKYMVOWfsgBr7IAiCtlKCkL8hZfnLcvZ3A7fXXNoLuLzOW3YB7rL9esV9AvxQ0p2Szs9ZrYIgCLqDXlhpV8jV1C8EDswKx0r7YSQXytk1968L/IR5yVAWIuWTvdn2wZIOBo4hKSODLiZk8sFIoeB82i2hIaOd46svBM62fVFV+54koczW1XlEJK0EXAzsYfvh3Pw8qRL7xfn8fKBuFZyQsQ+NMKpBUBAlCPlrJHpEpNwi99v+eVX7dsC3gJ1sv1bVPg64FDjU9s2V9mzUL2FeCtetmb/AJVX3vlnGJwx2EARto9giCC1BgyXak7QFcCOp6GRlpt8GfgEsSlpBA9xmex9J3yFFkjxU1c22tmdKWpUUTTIOeA74gu0nBho/co/0PpF7JCiKObOfqleXsWFeOXinhu3Nkj+f2NRYw2VQo91pwmgHQdAozRrtlw/csWF7s9Rxl3TEaIciMgiCoEIJfNphtHuA2IgMgoLohegRSSuT8l7/B8mnfart4yUdQcr291y+9du2L8tVh38JbJrvP8D2dbn4QbV1WQn4re0Di/owI5UwqkFQED2y0q7I2O/MhneKpKvytWNtH1Nz/5cAbK+fK65fLmkz2y8DG1VukjQFuIggCIIuodv3+KAJGfsAb1mHVAqeHDHyT9Kq+47KDZLWBJZl/pV3MEzCPRIEBdEjK+03qZGxvw/YX9IewGTSavwfwD3AzpLOBVYm5dFemSqjDewO/D4K+xZDGNUgKIgSGO2Gc4/UkbGfDLyd5PJ4BvhZvvV0YAbJkB8H3EJysVSzG3DOAGPtLWmypMl9fa82OsUgCIKmcJ8bPjrFsGXstp+tuv4r4E+5fQ5wUNW1W6gS2kjaEFjI9pT+xovCvkEQdIQ53W9uGoke6U/Gvnz2dwN8DJiW28eQRDuvStoGmGO7Wq6+OwOssoMgCDpFJ1fQjdLISvt9pEx890q6O7d9G9hd0kaAgceAL+dry5KK+PYBT7FgFr9PATs0NesgCIJW0AtG2/ZNQD255mX93P8YsPYA/a3R6OSCxojokSAoiO6vgRCKyF4gjGoQFEMZ3CPNFPbdUNKtuYDvJZLGVr1ng3ztvnx9sdy+ez6fKukKSW9r3UcLgiAYGp7jho9O0Uxh39OAQ3IB34uBbwBIWgj4LbCP7XVJ+bPfyO3HAx/KxYCnAvsX/HmCIAiGT98Qjg7RjCJybeCGfNtVwJXA4aTyYlNt35Pf8zy8GTYoYAlJzwNjgemFfpqgJYTPPBgplKCub1OKyGnATsAfgU+SVI8AawGWdCUwHjjX9tG235C0L6mYwquk2O39ivgQQWsJoxqMGEpgtJtRRO5FcpVMAZYCZudbFwK2AD6T//2YpK3zSntfktFfgeQeObSfsUIRGQRB2ylBtbHGjHY/isgHbG9rexOSWKZSwHcGcL3tWbl25GXAxuQMf7YfzjlHzgM2rzde1IgMgqAjFOzTlrSdpAclTZd0SD/3bCnp7hy4cf1gfTajiFw2Z/EbBXwHOCVfuhL4ZlZGzgY+CBxLEtqsI2m87eeAbYD7Bxs/6Dzh0w5GCn21WZKaQNJo4CSSrZsBTJI0sVohnguh/w+wne0ncjrrAWlGEbmmpIpP+iLgDADb/5D0c2ASSS15me1L8wS/D9wg6Q3gceDzDYwfdJgwqsFIoWC3xwRguu1HAHLm052B6rQenwYuqhQ4tz1zsE6bUURCCuGr957fksL+attPYd6KPAiCoLtw47V6Je0N7F3VdGpOdldhReDJqvMZwHtqulkLWFjSdaS9weNtnzXQuKGI7AHCfREExTCUlXZ1NtJ+qPcNUKvKWYhUc2BrYHHgVkm32f5bf5024tNejBSPvWi+/wLb35P0Q9JSvw+YCXze9tOSJlR9EAFH2L4497UrcBgwGrjU9jcHGz8YnLIb1VZ/6UD5f0ZBe3Bf4yvtBpjBvFBoSHVxn65zzyzbrwKvSroB2BAYvtEGXge2sv1KjiK5SdLlwE9tHw4g6WvAd4F9SPHbm9qeI2l54B5JlwBLAz8FNrH9nKQzJW1t+5oG5hAMQKy0g6AYCvZpTyLt/a1OCsTYjeTDruaPwIlZMb4IyX1y7ECdNuLTNvBKPl04H86x2hWWIC/7c5hfhcWY9ziwBvC3HDkCcDWwC7meZBAEQafpm1vcSjsvXPcnRdSNBk63fZ+kffL1U2zfL+kKkm6lDzjN9rSB+lUjZRpz6MoU4B3ASba/ldt/BOwBvEjKKfJcbn8PqezYqsDnbF8saRmSGnIL0iPB74FFbO840NhRuSYIgkaZM/uppqzuk5tt3bC9WXnSNYX6UhqlIXGN7bm2NyL5ZCZIWi+3H2Z7ZeBsqpI/2b49J4vaDDhU0mK56O++JGN9I6lwQoFRkUEQBM1hN350ioZl7AC2/wlcB2xXc+l3JFdH7f33k/KMVIz8JbbfY/s/gQepqh1ZTcjYgyDoBO5Tw0enaCR6ZDzwhu1/Sloc+DDwE0lr2q4Y3Z2AB/L9qwNPZn/OqqRsgI/laxUV5TLAV0ilxxYgCvt2F7HRGYwUOmmMG6WR6JHlgTOzX3sUcJ7tP0m6UNLaJOf546TIEUg+60Oy6rEP+IrtWfna8bkaO8APBopFDBonjGoQFEORG5GtoqGNyE4SK+0gCBql2Y3Ih9f7SMP25u3TruyIhQ9FZDAosZIPRgo9VwQhGJmEUQ1GCn1DyD3SKZqRsf+etMkIMA74p+2NJL0VuIAU7vdr2/tX9bUJ8GuSxv4y4AB3u3+mBJR9JRwy9qBbcC8YbfqRsdvetXKDpJ+RBDYA/ybVilwvH9WcTMqKdRvJaG8HXN7cRwjKbpDKPv+gdyhD9MigcdpOLCBjr1zPRRI+Rapeg+1XczrXf1f3k/OQjLV9a15dnwV8tIgPEQRBUAR9c9Xw0SkaLTc2OhdAmAlcZfv2qsvvB56titnujxVJ8vUKM3JbEARBV9BnNXx0iqZk7JndyavsQWgkt2y6MRSRQRB0AFsNH51iSNEjWRV5HckXPS2nE/w4KYn3YMwgGf0K9XLLVsYJReQQKPtGZBB0C2UIixi2jD1f/jDwgO0Z/XaQsf2MpJclvRe4nZQd8IThTz2oEEY1CIqhJ0L+6EfGnq/tRh3XiKTHgLHAIpI+CmybKxDvy7yQv8uJyJEgCLqIngj5sz0VeHc/1z7fT/tq/bRPZsEwwCAIgq5gbglC/kIRGQRBkCnDSrvhfNo57O8uSX/K52+RdJWkh/K/y+T2hXP9x3sl3S/p0Ko+fiTpSUmv9DdOEARBpyhDyN9QVtoHAPeTfNUAhwDX2D5K0iH5/FvAJ4FFba8vaQzwV0nn2H4MuAQ4kX6KHwTDI6JHgqAYShA80rC4ZiXgv4DTqpp3Bs7Mr89knrrRwBI5HHBxYDbwEoDt22w/0/y0gyAIiqeXVtrHAd8ElqpqW65igHM437K5/QKSQX8GGAMcZPuFYqYb1CNWwkFQDHNL4NNuJE77v4GZtqdI2rKBPicAc4EVgGWAGyVdbfuRRiclaW9SYik0emlGjVqi0beOSNqRJa/sxBdb0AiuK9zuLhpZab8P2EnSDsBiwFhJvwWelbR8XmUvT8pLAvBp4ArbbwAzJd0MbAo0bLRDEdldhMELRgp9JbA2jcRpHwocCpBX2l+3/VlJPwX2BI7K//4xv+UJYKts2McA7yW5V4IWEUY1CIqhrwQr7YZD/upwFLCNpIeAbfI5wEnAksA0YBJwRhboIOloSTOAMZJmSDqiifGDIAgKxajho1NEYd8eoOw+7XhSCIqi2cK+Vy23a8P2Zptnfx+FfYPhEUYvCIphbgncI2G0e4AQ1wRBMZSgGHvjRjtn+ZsMPGX7v6vavw78FBhve5ak1UjKyQfzLbfZ3ierI88H3k4KCbzE9iHFfIyRTRjVICiGXgn5q1ArY0fSyqRNyCdq7n04V7qp5Rjb10paBLhG0va2Iz1rk8RKOwiKoQRJ/hoz2lUy9h8BB1ddOpaklPxjvfdVY/s14Nr8erakO5m/kk0wTMKoBkExlCHkb9gydkk7kVwl96SC7POxuqS7SDlHvmN7vqWgpHHAjsDxw5t20Eu0I/olvtiCRpjb6Qk0wLBk7Nk/fRiwbZ23PAOsYvt5SZsAf5C0ru2X8nsXIlW7+UV/0vaQsY8swqAG3ULfggvQrmNYMnbgN8DqQGWVvRJwp6QJtv8OvA6QDf3DwFqkTUxI8vSHbB/X34AhYx8a4dMOgmIog7EZrox9l+p7ck3ITXP0yHjgBdtzJa0BrEnOOyLpSGBp4P8U+BmCIAgKoQwhf83I2PvjA8BUSfeQ0rTuY/uFvJl5GLAOaVV+t6Qw3kEQdA19avxoBEnbSXpQ0vRcLKa/+zaTNFfSJwbrc0jiGtvXAdfVaV+t6vWFwIV17pkBJdiaLSHhvgiCYigyeiRrW04ihUXPACZJmmj7r3Xu+wlwZSP9tmKlHQRBUErmqvGjASYA020/Yns2cC6pQEwtXyUtdGfWubYAzRT23UjSbdnNMVnShNy+jaQpubDvFElbVfVxhaR7JN0n6ZT8DRMEQdAV9A3hkLR3tn2VY++a7lYEnqw6n5Hb3kTSisDHgFManWMzisijge/bvjxHlhwNbAnMAna0/bSk9UhL/spEP2X7JaWQkwtIRYDPHcIcgg4Q0SnBSGEo0SPVUW79UG89XjvEccC3cuBGQ+M2o4g08wz40sDTALbvqnrrfcBikha1/XolVjuPu0idDxAMgzCqQVAMBcvYZwArV52vRLaTVWwKnJsN9tuAHSTNsf2H/jptprDvgcCVko4huVk2r/O+XYC7bL9eaZB0JcnXczlptR00SRjVICiGgkP+JgFrSlodeArYjVSO8U1sr155LenXwJ8GMtjQgE+7WhFZc2lfUqX1lYGDgP+ted+6pB3RL9dM8iPA8sCiwFbUodpX1Nf36mBTDIIgKISh+LQHw/YcYH+Si/h+4Dzb90naR9I+w53joJVrJP0Y+Bwwh3mKyItIuUPG2Xb2Ub9oe2x+z0rAX4Av2L65n373BDazvf9A44ciMgiCRmm2cs3/rPzZhu3NV578bUdCmAddads+1PZKORZ7N+Avtj9L8s18MN+2FfAQvJkM6lLg0GqDLWnJXLW9kn9kB+CB4j5KEARBcxS50m4VzVSu+RJwfDbA/yYneCI9DrwDOFzS4bltW9JO6kRJiwKjSSvxhsNcgv6JjcggKIYyPNYPWxFp+yZgkzr3HAkc2U8Xmw1tekEQBO2jZ4ogBEEQjATKkDCq0Tjtx4CXSTnC59jeVNIngSOAdwETbE/O9y4C/JIUf9gHHJBX6NX9TQTWsL1eMR8jKDNRBCHoFnqiCEIVH7I9q+p8GvBxkoGu5ksAtteXtCxwuaTNbPcBSPo48EoTcw5qKLtBKvv8g96hp90jtu8HqCO9XAe4Jt8zU9I/SavuOyQtSVJU7g2cN9yxg/mJjcggKIaecY+QNlX/LMnAL7Pmvj/uAXaWdC5JwrlJ/vcO4IfAz4DXhj/loJYwqkFQDL0UPfK+nABqWeAqSQ/YvqGfe08n+bknA48DtwBzJG0EvMP2QZJWa3LeQRAEhdNXArPdkNG2XUkGNVPSxaTcIXWNdpZuHlQ5l3QLSXjzQWCTvKm5ELCspOtsb1nbRxT2DYKgE5TBPdJI7pElJC1VeU0Sykwb4P4x+T4kbUOKNvmr7ZNtr5CVlVsAf6tnsCGlPLS9qe1Nw2AHQdAu5g7h6BSNrLSXAy7OG44LAb+zfYWkjwEnAOOBSyXdnZNBLUvK/tdHymz1udZMPQiCoFh6InrE9iPAhnXaLwYurtP+GLD2IH0+BkSMdhAEXUXP+LSDkU2EFAYjhe432WG0gwYIoxqMFMqwEdmMjP0IkvrxuXzbt21flu/fgKSUHEv6OWxm+9+SriMVQPhXfs+2thuqQBwEQdBqes09UitjBzjW9jHVDTlV62+Bz9m+R9JbgTeqbvlMJU9JEARBN9FruUcaZVtgqu17AGw/34IxgiAICqcMK+1B47QzFRn7lCx8qbC/pKmSTpe0TG5bC7CkKyXdKembNX2dIeluSYer0ZrxQRAEbcBDODrFsGXswMmkXCJmXk6RvXKfW5AKHrwGXCNpiu1rSK6Rp7JY50JSDPdZtYOFInJolD26I1KzBt1Cz2xE1pOxV+cekfQr4E/5dAZwfcX/LekyYGPgGttP5X5elvQ7khx+AaOdE1KdClHYdyQQBjXoFlwC98igRjtL0kdlQ1uRsf9A0vK2n8m3fYx50vYrgW9KGgPMJuUcOTZvUI6zPUvSwsB/A1cX/HlGJGH0gqAY5vSC0aZ/GftvcuY+A48BXwaw/Q9JPwcm5WuX2b40G/wrs8EeTTLYvyr48wRBEAyb7jfZzcnY+80pYvu3pLC/6rZXqVMIOGiesvu0g6BbKEP0SCgie4AwqkFQDD2zEdmPInJD4BRgSZJ75DO2X5I0gbyJCAg4IieXqhT9PRHYkvTzOcz2hYV9mhFKrLSDoBh6YiOyilpF5GnA121fL2kv4BvA4aQNyU1tz5G0PHCPpEtycYTDgJm215I0CnhLQZ8jCIKgaXpmpd0PazOves1VpKiRw21X139cjPl9+3sB7wTI1dlrZfHBMIiVcBAUw9wSrLSbUUROA3bKrz9JKt4LgKT3SLoPuBfYJ6+6x+XLP8xKyfMlLdf8RwiCICiGPrvho1M0o4jcC/iFpO8CE0kx2QDYvh1YV9K7gDMlXZ7HWgm42fbBkg4GjqFOZZtQRA6N8GkHQTF0/zq7wZV2tSKSVK1mgu0HbG9rexPgHODhOu+7H3iVVKXmeZKsvVLt5nySUrLeeFEjMgiCttOHGz46RTOKyGWzrH0U8B1SJAmSVgeezC6RVUm+78dsW9IlpMiRvwBbA39tyacaYZR9JRy5R4JuoVeiR/pTRB4gab98z0XAGfn1FsAhkt4gbcZ+pSrq5FvAbyQdRyqe8IViPkbQSsL9EowUyhA9InfQod4IkTBqcMKoBkFizuynmkr3/IlVd2rY3lzw+MSOpJYORWQPUPbUqfGlEHQLRa+0JW0HHE/Kt3Sa7aNqrn+G5IEAeAXYt1JApj8aVUSOI4lp1iNtsO4F7ADsTPqcM4HPVzYsJR0KfJGkoPya7Stz++7At3MfTwOfrVPCLOgywqgGI4UiPQ+SRgMnAduQUlZPkjTRdvVe3qPAB3Oive1JavL3DNRvo3HaxwNX2H4nKXnU/cBPbW9geyNSLu3v5omuA+wGrAtsB/yPpNE5NevxJGXlBsBUYP8Gxw+CIGg5BUePTACm237E9mzgXNJC901s32L7H/n0NlJY9IA0Ej0yFvgA8Pk8yGyqYrIzSzAvxHFn4FzbrwOPSpqeJz+ZlItkCUnPkyq1Tx9s/GBwwn0RBMUwFPdItZ4kc2ou4FJhReDJqvMZDLyK/iJw+WDjNuIeWYMU6XFGThI1BTjA9quSfgTsAbwIfKhqorfVTHRF27dK2pekknwVeAjYj6BpwqgGQTHMHYLZrq6w1Q/1NirrLtElfYhktLcYbNxG3CMLkUQwJ9t+N8ngHgJg+zDbKwNnM8/VUXeiufjBvsC7gRVI7pFDGxg/CIKgLdhu+GiAGVSl9yC5Pp6uvUnSBqQ9w51tPz9Yp40Y7RnAjCxNB7iABZWMvwN2GWSiGwHYftjpE58HbF5vQEl7S5osaXJf36sNTDEIgqB5+oZwNMAkYE1Jq+e01LuRUn68iaRVSDqXz9n+WyOdNlK55u+SnpS0tu0HyUpGSWvafijfthPwQH49EfhdLjm2ArAmcAdJpLOOpPG2nyPtqN7fz5hR2HcIhE87CIqhSEVkVoXvT8qAOho43fZ9kvbJ108hBXC8lRSwAblewUD9NiSuybUgTwMWAR4hKRlPI0nU+4DHSdn8nsr3H0YKC5wDHGj78ty+D3AA8EZ+z+cHexwIox0EQaM0K6758MofadjeXP3klR0R14QiMgiCnqFZo731Sts2bG+umfHnUEQGwyPcI0FQDEOJHukUYbSDIAgynSxu0CgNKSIljZN0gaQHJN0v6T9z+1clPSjpPklH57aFJZ0p6d5876FV/WyS26dL+oWy5z0IgqAb8BCOTtHoSrsiY/9EDl0Zk4PBdwY2sP16rmoDqfTYorbXlzSGFGlyju3HgJNJCqLbgMtIMvdBFUBBEATtoJPFDRpl2DL2rG48KsvVK1VtIH0JLZFzjSxOkry/lCuzj7V9a+73LOCjhNFumsjyFwTF0BNGm35k7MBawPuzlP3fwNdtTyKJb3YGngHGAAfZfkHSpiThTYUZJMl70CRhVIOgGOa6NzYiKzL2r9q+XdLxJBn7QsAywHuBzYDzJK1BSg41lySsWQa4UdLVDE2HH4V9h0AY1SAohjKUG2tGxj4DuMiJO0gim7cBnyb5v9/ILpObgcoquzrtYF0dPkRh3yAIOkPBuUdawqBG2/bfgSclrZ2bKgV5/wBsBSBpLZJachbwBLCVEkuQVuIP2H4GeFnSe3PUyB7AHwv+PEEQBMOmJ6qxZ74KnJ0jRyoy9leB0yVNI2027pkrrp9EKvI7jeQSOcP21NzPvsCvSRuUlxObkIUQPu0gKIZuV4hDyNiDIOghmpWxb/gfmzdsb+75+y0hYw+GR6y0g6AYeiJ6JPuyf1/VtAYpneBZuX014DHgU7k45WqklKsP5vtvs71P7qtS6WYZ20sW8xGCiNMOgmIoQ/TIkNwjubrwU6Q6Z/sBL9g+StIhJEP8rWy0/2R7vTrvfy8pJetDjRrtcI8EQdAozbpH3rXshIbtzf0z7yiFe2Rr4GHbj0vaGdgyt58JXAd8a6A3274NIFKOFEushIOgGMqw0h6q0d4NOCe/Xi6H8WH7marcIwCrS7oLeAn4ju3WWpURThjVICiGMmT5a9ho53C/nRi8GO8zwCq2n5e0CfAHSevafmkIY4UicgTR6icFiC+2oDF6baW9PXCn7Wfz+bOSls+r7OWBmQA5gVQlidQUSQ+T8pRMbnSgqBE5sgiDGnQLZYgeaSifdmZ35rlGIBXw3TO/3pOsbpQ0Pm9YknORrEkS5ARBEHQ1dl/DR6dotAjCGFL19Iuqmo8CtpH0UL52VG7/ADBV0j2kPCX72H4h93O0pBmkfNwzJB1RzMcIgiBonjLI2EMR2QOUPXokfNpBUTQb8rfKW9Zv2N488cK9pQj5C4LCCYMadAs9UQShP0Wk7ePy9a8DPwXG254lqeIqWYSUSOobtv+SXSznA28n5du+xPYhRX6YkUoYvSAohrl93b8ROajRtv0gsBHMp4i8OJ+vTPJnP1H1llnAjraflrQecCXzKtQcY/vaHD54jaTtbUemvyYpu3skCLqFXgv5gypFZD4/FvgmVXmxbd9Vdf99wGKSFrX9GnBtvme2pDuZvyhCMEzK7nOOL4WgW+j2PT5oQhEpaSfgKdv3DCBL3wW4q1L8t4KkccCOpCrvQZcTRjUYKfSET7tCtSIy+6cPA7Yd4P51gZ/U3pOrtJ8D/MJ2xG8XQKyEg6AYem2l/aYiUtL6wOpAZZW9EnCnpAm2/y5pJZLfew/bD9f0cyopy99x/Q0UMvahEUY1CIqhp3KPUKWItH0v8GaCKEmPAZvm6JFxwKXAobZvru5A0pHA0sD/GWigkLEPjXbEObeS+NIJuoUyyNgbEtdkd8iTwBq2X6xz/THmGe3vkJJKPVR1y7akEMAngQfIuUmAE22fNtDYYbSDIGiUZsU1Y5dYo2F789Krj3REXBOKyB4gfNpBkGjWaC85ZvWG7c0rrz0aishgeIRRDYJi6MU47SAIgp6l1zYigy4l3CNBUAzd7i6GMNo9QRjVICiGvoKjRyRtRxIRjgZOs31UzXXl6zsArwGft33nQH2G0e4BYqUdBMVQ5Eo752o6iZSfaQYwSdJE23+tum17UqGYNYH3ACfnf/sljHYPEEY1CIqhYOfIBGB6Rfkt6VxgZ6DaaO8MnOX0bXGbpHGVMo79ddr1RnuoITyS9s7inJbQ6v7bMUbZ+2/HGGXvvx1jlL3/egzF3lQrtzOn1sx3RZI2pcIMFlxF17tnRVKB9LoMpUZkWdh78Fu6uv92jFH2/tsxRtn7b8cYZe+/KWyfanvTqqP2C6beF0DtYr6Re+ajF412EARBNzADWLnqfCXg6WHcMx9htIMgCFrDJGBNSavnLKm7ARNr7pkI7KHEe4EXB/JnQwl82sOg1T6wdvjYyv4Z4mfU+f7bMUbZ+28ptudI2p9UvWs0cLrt+yTtk6+fAlxGCvebTgr5+8Jg/XZ97pEgCIJgHuEeCYIgKBFhtIMgCEpEGO0gCBpG0uKS1u70PEYyYbQbIMtRW9X3WpKukTQtn2+QC0kUOYYkrTz4nd2LpLd0eg4jHUk7AncDV+TzjSTVRkMELabUG5GD/Ue2/UJB4zwKXACcUZM3oIi+rwe+AfzS9rtz2zTb6xU8zhTbmxTZZ03/19jeerC2Jvp/iGQwzgAud4v+cCWtCqxp+2pJiwML2X65oL4/Xqf5ReBe2zMLGmM88CVgNaqiw2zvVUDfU4CtgOuq/lan2t6g2b5rxhkNLMf883+iyDHKTNlD/qaQ1EMCVgH+kV+PA54gFR8ugg1IMZanSRoFnA6ca/ulAvoeY/uOXCC5wpwC+q3lNkmb2Z5UZKeSFgPGAG+TtAzzFF5jgRUKHGot4MPAXsAJkn4P/Nr234oaQNKXSCq8twBvJwkdTgEK+eIBvgj8J3BtPt8SuA1YS9IPbP+mgDH+CNwIXA3MLaC/aubYfrHmb7VQJH0V+B7wLFBJuWfS/8EAUlarsh+k/1g7VJ1vD/ysRWN9AHgKeBU4E3hHk/1dTjIQd+bzT5BWkkXP+6+kL4OHganAvcDUAvo9AHiUVPfzkfz6UeAeYP8W/Q4+lH8H/wSuB/6zoH7vJtUyvauq7d4C530JsFzV+XLARaQviWlFfYZW/Mxz3/8LfDr//awJnACcUvAY04G3tuoz9MLR8QkU9IueUqdtcoH9jwZ2Ai4G7gIOzv/hPgH8rcm+1yCtil7LhugmYLUW/IxWrXcU2P9XW/w7fmv+gpgMXAp8nPSkuCnwaEFj3J7/vSv/u1ARX2xV/d9bc66Ksa7+omhyjCOrFzAF/w7GAD8iKf0m59eLFTzGtSSXVMv+lsp+lN09UqFSBf63pEepzwLPF9j/Q6Q/pp/avqWq/QJJH2imY6e0jR+WtAQwygX5T+uM87ikDYFKHtcbbd9T4BB/l7SU7Zfz72Jj4EgPktB9CNwK/Ab4qO0ZVe2TJZ1S0BjXS/o2sLikbYCvkFbHRXGjpD8B5+fzXYAb8u/+nwWNcQDwbUmzgTdym22PbbZj268Bh0n6Se6zFX+rjwDXSbqU9PRWGfvnLRirlJR6I7JC3pD8Hsl1AXAD8H0XsBGZN0UOs/2DZvuq6ffgga4X/Ucq6QDSBtVFueljpFSSJxTU/1TbG0jaAvgxcAzwbdsDJnRvsO/RpC/MAX9mBYwziuR33pa0Cr7S9q8K7F8kQ/2+3P9NwIUuyX9CSZuR9nOWyk0vAnvZnlLgGN+r1277+0WNUXZ6wmi3GknX2v5QwX3W/ePMuAVfElNJvt9X8/kSwK0uaOdf0l223y3pxyQ3wO8qbQX1X1gkygBjHGD7+MHauh1JOzFvAXOd7T8V1O9UYD/bN+bzLYD/KepvqGaspUj/D14puu+yU2r3iKRLGCD3rO2dChrqFkknAr8nbUBW+h/2o39l5SDpfbZvrr4m6X3D7XcAxPzRBHOpn8t3uDwl6ZekCI+fSFqUYnUAd+eY4POZ/3dwUf9vGTJ7kur1VfP5Om3DIof8/QRYlvSzFwW5LqrGOArYDDg7Nx0gaQvbhxTQ/csVgw1g+yZJhbpIJK1HcoO9JZ/PAvawfV+R45SZUq+0JX1woOu2ry9onGvrNNv2VgX0faftjQdrK2Ccg0lG6eLc9FHgTNvHFtT/GGA70ir7IUnLA+vb/nNB/Z9Rp9kuJv54d1JUxBakcLkKSwFzbX+42THyONOBHW3fX0R//YwxFdjIThVqs2vpriJWw5KOJW1GnkNaLO1KCrO9EJpbxFSNcQvJHXltPt8S+H+2N2+2716h1CvtRo2ypAtt79LEOIW6RgAk/SewOTC+xr89lhStUii2fy7pOpJhEvAF23cV2P9rwEWSlpW0Sm5+oKj+SZWsW/VEcgupvNPbgJ9Vtb9MCm8rimdbabCrGAdU9nOWLrDfjfK/ta69zUlGvOlFDLBExWAD2L4uu/KCTKmN9hBYo5k3S1qa+Tc6rwd+YPvFJrpdBFiS9DtYqqr9JVIoYaFI+o3tzwF31mkrov+dSAZvBWAmSez0ALBuEf2TYoJrnz7qtQ0Z248Dj5OEL61kchYF/YH5IyOKdPH8GLgrPx2K9Dd7aEF9f9h20YKdWh6RdDjJRQIpEuzRFo9ZKkrtHmmUZt0Nki4EppHENACfAza0XU+WPNS+V81Go6XU/gzyY/O9ttcpqP97SCutq/OG5IeA3W03Veev6onkQKDalTMW+JjtDZvpv2as95K+CN5F+lIdDbxalM+5lS6emnGWJ/m1RYo9/3tB/VbSOZzeqieGrKr9PvOeCG8AjrD9j1aMV0ZGykq7Wd5e4175vqS7m+lQ0om29wdOlLTAN2dRm6iSDgUqsccV2b2A2RRbGeQN289LGiVplO1rczxvs7TzieREUrqC80minT2AdxTVue1Bq5IMF0nvtP2ApMoXcyWWfQVJKxQUL19J5/C/LUjnAEA2zl8rqr9eZKSstJsKPZN0K/AN2zfl8/cBx9ge9uO0pJdsj+1vM7WoTdSq8X5su6jH5Hr9X03a3PwxyTc8E9isqA2kdjyRSJpse1NVJUGSdEuzn0HSN20fLekE6kQ72W7aSEk61fberdg0l7SQ7Tk1bR8gbUiOI62+f2h7ehNjHGf7wP4iwgqMBCs9PbHSlrQVcFveDKvHt5ocYl/gzOzbFmmT5/NN9vkwFG+cB+AOSUtX/PCSxgFb2v5DM51KegdJ0r8z8C/gIOAzJJn8V5vpu4ZFJZ3Kgtnritj8qvCaUgHWuyUdTdqcLGITrOJKmFxAX3WpckNtb/vf1deUkno1wx3Axtml9l+kpF2rkvYwziapbC8jJfUaLhUf9jFN9DEi6ImVtqSzgPeSpOs35uOmov1gksYCFPE4KGkG0K/q0cUrIu+2vVFNW9PiFyVZ9rdtT61p3xT4nu0dm+m/qr97SInBplAVb+5i1XirkrLLLUL68lmaJB4Z9gqypv9P2j5/sLYmxyg8hLTyfkmPkNI5nGb71pp7flHQE8MB7gGBUyvpCaNdQdIKJD/n14EVbBfyJKH6kvMXSYmq7h5mn88AJ9OPwMUFy3ZVJ++xpHttr99kv/3m/i6i/6q+WpoPvGqc8QC2n2tB3y2LyZf0H8CKpPw7n4b5UuSeYvudTfRdWWCMIT1NzWc0ilxg9PMzanpx0Uv0invks6RHtPWBWaQNpRsHfNPQ2DQfleRB/0XKdLaPpPNtHz2MPp9xwVL1QZgs6efASaT/dF8lrVqbZaBH78UL6L/CJZK+QhIHVYfLFZFfRqSQzv1Jxm6UpDnACUX8jiRtD+wArCjpF1WXxlJc7vSPkFx2KzH/E9zLpI3oZhhN2gxW/rdwqgROq2v+ajhLUWzyt9LTEyttJanrw6TH52ttP1Zw/1cCuzjnQZC0JGnz5WOk1faQw+bavXrIAoXDSTJzgD8DP3LORdJEv+cAf3FNYiVJXwS2tb1rM/1X9VcvVte2m4rBz30fRDKqe9t+NLetQXoSusJNqkaVsituBPwA+G7VpZdJf6+FufEk7WL7wqL6y30WrtCtM8aqpKIlPwaqJfcvk9LjtqIwSCnpCaMNIGldkpBgC1KC9gcLFI7cT4rLnp3PFyUlm3/XcI2vpLcUsUocxrhLusAkPJKWI61+ZzNv5b4pyS/8saJihFuJpLuAbWzPqmkfD/y5qC9XSQvbfmPwO5se579IoqY3n4KaeWLowALjP4AJpCfCSWX4G2onveIeGUtS4K1Kii5Ymnmliorgd6RyXX/M5zsC5+TV67BqRrbbYEvaHDiN9Hi7Sl79fdn2V5rp1/azwOZZTFPxbV9q+y9NTbgGSXv0M/5ZBXS/cK3Bzn0/J2nhAvqvsJpSFsR1mN+gNv20UEEpt/gY4EOk3/cnSNEfzdDS7IrV5Ce07wF/IbljTlAqxXZ6u+bQ7fTESlspSc5N+bjB8yfJL2qMTZin0rrJdsvCt1qBpNtJ/4EnuoUFhFtFjnGusBjJkNxpu2mBzUCP/0W6BiTdRDJIx5K++L9A+j84UJreoY5RyWte+XdJ4CLb2xY1RiuR9CCwue3n8/lbgVtsr93ZmXUPPbHSrhJCLMUAqVqbZHHgJdtnSBovafWK/7Ms2H5S8xdlbXUeicKwPV/Md46ZL6IQLsCGmqcWnW8YBt5oHSqL275GkpyEQkdIupEFEzA1QyVG+7UcTfU8xRW4bgczSH7sCi8DT3ZoLl1JTxhtzZ+DV5KeA/a0Pa2g/r9H8tOuDZwBLEwKrWpF3utW8WR2kTgLSL7GPNFHGXmNtHfRNLYbyqooaZkmNw3/rST/fkjS/qSaoMs20V89LsnCqZ+SkoMZKKz6Tht4Crg9uyJNEm3dUQm7LVq/UEZ6wmiTcmgc7Plz8J5KSjRUBB8D3k3OkGf76byqLxP7kJL5r0hazfwZ2K+jMxoCml/ePJqU1Om8Nk/jGprLKnggyd/8NeCHpARbdX31wyF/IVxj+5/AhVn4tJiby0bZbh7OR4XKPlLZ/r+1jF4x2q3OwTvbtpUTOxXcd8vJ8uPjbH+m03Npgmp58xzg8VbsXQxCU5V+bE/KL18BviBpIVIhgdubnVjuv0/Sz8gpZm2/TlVMexkoWlTWixRZDqqTPCLpcEmr5eM7FJuD9zylUlrjJH0JuJq0M18KnHIgj89ukVLilKPlAdKKaxlSiGHbpzGcN0kaK+lQSSdK2laJ/YHpwKeKnSJ/lrSLajYvuh1Jx+V/L5E0sfbo8PS6il6JHml5Dl5J2zB/le6riuq7HeQvnY2BicxfY7EUPkJJnyL5aa8j/Q7eT8q8eEEb5zCsSJLsn/0HcCsp6mUZUhz7AcNNgzDAWC+TklzNIW1KFl6HshVI2sT2FLUp62WZ6Qmj3Wok/cT2twZr62bUT/X3sjyOKiWM2sb2zHw+nlRwobAiCA3MYbhCqjdzsGRX1SxgFduFFsUtO/lnc6btz3Z6Lt1MT/i0Ja1FShK1Gq1J27kNC6Z33b5OW9dSFuM8AKMqBjvzPC1w70naAlizEtoJLFkV2jlckcmbKkjbcyU92iqDrZTnegFs39CK8Yok/2zGS1qkoj4OFqQnjDap0sgpJD9zYbHHkvYFvgKskQU8FZYCbq7/ru5CvZNc/gqlHDDn5PNdSTmcC2Ow0M4mVKzVceBiXhWhVrguvlH1ejGSHHwKxRTdbQePATdnP3bp3HjtoFeM9hzbJ7eg398Bl1MniU0n8oYMk1Inl1cusmD7G5I+zrx9i1tJCfiLpCWhnY3GgReBa/KXS1oZGE4Wyk7xdD5GEWF+dSm1T1vSW/LLr5HKWxWetrNmvGWZP2fEE0X232rUwlzRrUJtKrKQ+7zD9gTNS/q/BHCra/KQl4kcRTLVBeU1DzpP2VfaU0iP/JXwpq/XXC8kEY+kHUk5ilcgfTmsSlITrltE/60k/6dtWa7oNrBarcEGsD1Z0moFj1Ub2rkX5VITVnK0VFZio0gpYe/p2ISGiKSrgE9mgVAlMuxc2x/p6MS6iLIb7V2BJ20/AyBpT2AXkl/siALHOZJUzuxq2+9Wymi3e4H9t5IDST7ZzVyTK1rSQW4yV3QbaFeRBWwfk0M7XyL5tb9bttBO5q9DOQc4x3Yp9l8y4ysGG1J19vyEG2TKLq45hewOybvmPwbOJJUCO7XAcd7IWcdGSRqV1ZcbFdh/K9kD2L06uZXtR4DPUqCEuoVMyqve+VBK4VlYfcjc5xKkgg7fIK2wF1exqVlbju0zSRu0l9k+u2QGG2CupFUqJ0rFEcrrw20BZV9pj67yW+8KnOpUteNCSXcXOM4/lVJc3gCcLWkmxZWJajXtyhXdKg4ELpb0GeoUWSh4rBuA9+dH8qtJq9ZdSdXlu5oecINVOAy4SVJFTPMBYO8B7h9xlN5oS1rIqRTR1sz/y236s1UiF0iZxv5FqtD9GZJP+6sDvLWbGCjetetjYd2mIgsZ2X4tr+JPsH20UlWbMnAg5XaDAWD7Ckkbk9yRAg6qt+gYyZQ9euQwUm2/WaTKNRvnxE7vICmrmkqd2s7IhVYhaS5V8a7Vl0gZ4Mqw2m4L2UB/hVSk4Iu271OBFeVbidpUMq3VSHofqZTfq0oFuzcGjs/5xwNKvtK2/SNJ1wDLk/4wq3fNi1gJtzNyoSW0M0a4BzgAOBS4OBvsNYBrB3lPt1B2N1iFk0lipA1JQqHTgbOAujlJRiKlNtoAtm+r0/a3grpvW+RC0Hmy1PuGqvNHSBqAMlBqN1gVc/LT8s7AL2z/b44KCzKlN9otZpKkL9meL1a3FZELQefJroRvsmAl8zJIwNtVMq3VvCzpUOBzpE3h0aR0AkGm1D7tViNpOZLKcjZ1Ihds/71TcwuKR9Kfgd+TRFr7AHsCz5Upm2PZkfQfwKeBSbZvzOF/W9o+q8NT6xrCaDdATeTCfS2KXAg6jKQptjdRrmSe2663Hf7UNpJjs9e0fbWkMaTQ3khjmwn3SANkMU1ZNqSC4VNJofqMpP8iJS5aqYPzGXFkIdXepCLdbyfVND2F4afF7TnCaAfBPI6UtDTwf4ETgLGk2PygfexHSid7O4Dth0LGPj9htIMgY/tP+eWLwIc6OZcRzOu2ZyuXuFQqfhw+3CrKnnskCApD0lqSrpE0LZ9voFQkOmgf10v6NinvyzakAieXdHhOXUVsRAZBJue7+Abwy4qCUNI02+sN/M6gKCSNAr5IVRFt4DSHoXqTcI8EwTzG2L6j8mieKUtisJ7Adp+kPwB/KFOxjnYS7pEgmMcsSW8n+1AlfQJ4prNTGhkocYSkWcADwIOSnpP03U7PrdsIox0E89gP+CXwTklPkTLn7dvRGY0cDmRelsK32n4L8B7gfZIigqeK8GkHQQ25GMKoEHS0j17JUtgOwqcdjHgkHdxPOwC2f97WCY1MeiVLYcsJox0EsFSnJxD0TJbClhPukSAIOk4U62ic2IgMgkyIazqH7dG2x9Y5lgqDPT9htINgHr8iVa55AyBXLdqtozMKghrCaAfBPMbYvqOmLcQ1QVcRRjsI5hHimqDriY3IIMjkQr6nApsD/wAeBT4TlcCDbiKMdhDUUBHXAP8CdrV9doenFARvEu6RYMQjaaykQyWdmNOBvkaqDzkd+FRnZxcE8xMr7WDEI+mPJHfIraSyVsuQijcfYPvuDk4tCBYgjHYw4pF0r+318+vRwCxglcg9EnQj4R4JgnkFfbE9F3g0DHbQrcRKOxjx1EioBSxO8msLsO2xnZpbENQSRjsIgqBEhHskCIKgRITRDoIgKBFhtIMgCEpEGO0gCIIS8f8BB3otFUCOlDsAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 2 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "sns.heatmap(data.isnull())"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8ef3eea3",
   "metadata": {},
   "source": [
    "import seaborn as sns             #map shows that nan values in colms by heat graph\n",
    "sns.heatmap(data.isnull())"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "fe8ffef8",
   "metadata": {},
   "source": [
    "# Q1- for \"house of Cards\", what is the sow id and director of movie ?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "7e8772c3",
   "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": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data[\"Title\"]==\"House of Cards\"]                           # one method to show the title"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "id": "b49a1723",
   "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": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data[\"Title\"].isin([\"House of Cards\"])]                #isin command is also used to find values in specific colums"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "id": "5b234318",
   "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": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data[\"Title\"].str.contains(\"House of Cards\")]        # used to find out items specific in string colums  "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ea14234b",
   "metadata": {},
   "source": [
    "# Q-2 In which year the highest number of Tv shows and movies realeased Show with the help of bar graph ?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "id": "ec48c040",
   "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": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.dtypes   # this q is related to date and time so our date column should be of date time type!"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "id": "7d98a1a0",
   "metadata": {},
   "outputs": [],
   "source": [
    "data[\"Date_N\"]=pd.to_datetime(data[\"Release_Date\"])            #Data_N column is now of type date and time"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "id": "5660420d",
   "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",
       "    <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",
       "    </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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7785</th>\n",
       "      <td>s7784</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Zubaan</td>\n",
       "      <td>Mozez Singh</td>\n",
       "      <td>Vicky Kaushal, Sarah-Jane Dias, Raaghav Chanan...</td>\n",
       "      <td>India</td>\n",
       "      <td>March 2, 2019</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>111 min</td>\n",
       "      <td>Dramas, International Movies, Music &amp; Musicals</td>\n",
       "      <td>A scrappy but poor boy worms his way into a ty...</td>\n",
       "      <td>2019-03-02</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7787</th>\n",
       "      <td>s7786</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Zumbo's Just Desserts</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Adriano Zumbo, Rachel Khoo</td>\n",
       "      <td>Australia</td>\n",
       "      <td>October 31, 2020</td>\n",
       "      <td>TV-PG</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>International TV Shows, Reality TV</td>\n",
       "      <td>Dessert wizard Adriano Zumbo looks for the nex...</td>\n",
       "      <td>2020-10-31</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",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7787 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Show_Id Category                                    Title  \\\n",
       "0         s1  TV Show                                       3%   \n",
       "1         s2    Movie                                    07:19   \n",
       "2         s3    Movie                                    23:59   \n",
       "3         s4    Movie                                        9   \n",
       "4         s5    Movie                                       21   \n",
       "...      ...      ...                                      ...   \n",
       "7784   s7783    Movie                                     Zozo   \n",
       "7785   s7784    Movie                                   Zubaan   \n",
       "7786   s7785    Movie                        Zulu Man in Japan   \n",
       "7787   s7786  TV Show                    Zumbo's Just Desserts   \n",
       "7788   s7787    Movie  ZZ TOP: THAT LITTLE OL' BAND FROM TEXAS   \n",
       "\n",
       "               Director                                               Cast  \\\n",
       "0                   NaN  João Miguel, Bianca Comparato, Michel Gomes, R...   \n",
       "1     Jorge Michel Grau  Demián Bichir, Héctor Bonilla, Oscar Serrano, ...   \n",
       "2          Gilbert Chan  Tedd Chan, Stella Chung, Henley Hii, Lawrence ...   \n",
       "3           Shane Acker  Elijah Wood, John C. Reilly, Jennifer Connelly...   \n",
       "4        Robert Luketic  Jim Sturgess, Kevin Spacey, Kate Bosworth, Aar...   \n",
       "...                 ...                                                ...   \n",
       "7784        Josef Fares  Imad Creidi, Antoinette Turk, Elias Gergi, Car...   \n",
       "7785        Mozez Singh  Vicky Kaushal, Sarah-Jane Dias, Raaghav Chanan...   \n",
       "7786                NaN                                            Nasty C   \n",
       "7787                NaN                         Adriano Zumbo, Rachel Khoo   \n",
       "7788           Sam Dunn                                                NaN   \n",
       "\n",
       "                                                Country        Release_Date  \\\n",
       "0                                                Brazil     August 14, 2020   \n",
       "1                                                Mexico   December 23, 2016   \n",
       "2                                             Singapore   December 20, 2018   \n",
       "3                                         United States   November 16, 2017   \n",
       "4                                         United States     January 1, 2020   \n",
       "...                                                 ...                 ...   \n",
       "7784  Sweden, Czech Republic, United Kingdom, Denmar...    October 19, 2020   \n",
       "7785                                              India       March 2, 2019   \n",
       "7786                                                NaN  September 25, 2020   \n",
       "7787                                          Australia    October 31, 2020   \n",
       "7788              United Kingdom, Canada, United States       March 1, 2020   \n",
       "\n",
       "     Rating   Duration                                               Type  \\\n",
       "0     TV-MA  4 Seasons  International TV Shows, TV Dramas, TV Sci-Fi &...   \n",
       "1     TV-MA     93 min                       Dramas, International Movies   \n",
       "2         R     78 min                Horror Movies, International Movies   \n",
       "3     PG-13     80 min  Action & Adventure, Independent Movies, Sci-Fi...   \n",
       "4     PG-13    123 min                                             Dramas   \n",
       "...     ...        ...                                                ...   \n",
       "7784  TV-MA     99 min                       Dramas, International Movies   \n",
       "7785  TV-14    111 min     Dramas, International Movies, Music & Musicals   \n",
       "7786  TV-MA     44 min  Documentaries, International Movies, Music & M...   \n",
       "7787  TV-PG   1 Season                 International TV Shows, Reality TV   \n",
       "7788  TV-MA     90 min                    Documentaries, Music & Musicals   \n",
       "\n",
       "                                            Description     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  \n",
       "...                                                 ...        ...  \n",
       "7784  When Lebanon's Civil War deprives Zozo of his ... 2020-10-19  \n",
       "7785  A scrappy but poor boy worms his way into a ty... 2019-03-02  \n",
       "7786  In this documentary, South African rapper Nast... 2020-09-25  \n",
       "7787  Dessert wizard Adriano Zumbo looks for the nex... 2020-10-31  \n",
       "7788  This documentary delves into the mystique behi... 2020-03-01  \n",
       "\n",
       "[7787 rows x 12 columns]"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "id": "cdf53d1c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2019.0    2153\n",
       "2020.0    2009\n",
       "2018.0    1685\n",
       "2017.0    1225\n",
       "2016.0     443\n",
       "2021.0     117\n",
       "2015.0      88\n",
       "2014.0      25\n",
       "2011.0      13\n",
       "2013.0      11\n",
       "2012.0       3\n",
       "2008.0       2\n",
       "2009.0       2\n",
       "2010.0       1\n",
       "Name: Date_N, dtype: int64"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[\"Date_N\"].dt.year.value_counts()                         #shos all vlues in Each years"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "id": "c646d67e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:>"
      ]
     },
     "execution_count": 86,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAX0AAAERCAYAAACXT3dwAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjQuMywgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/MnkTPAAAACXBIWXMAAAsTAAALEwEAmpwYAAAS2ElEQVR4nO3dfbBcd13H8ffHBGqHUmlJWmoSm6pRaFGqxIqiYxkemqFq6ygYVKhaJg6UERlmbCoq+BDM6MhD1dapwNCOQikiNlpQOkVgdMBySyshLbXRpjRNaMOTVJRq6tc/9gR2bje5uXcfbk5/79fMzj3727Of88tJ7ifnnj27N1WFJKkN37DcE5AkzY6lL0kNsfQlqSGWviQ1xNKXpIasXO4JLGTVqlW1fv365Z6GJPXKLbfc8rmqWj1//Jgv/fXr1zM3N7fc05CkXklyz6hxT+9IUkMsfUlqiKUvSQ2x9CWpIZa+JDXE0pekhlj6ktQQS1+SGmLpS1JDjvl35B7O+q03LGr9PdvPn9JMJKk/PNKXpIZY+pLUEEtfkhpi6UtSQyx9SWqIpS9JDbH0Jakhlr4kNcTSl6SGWPqS1JAFSz/JuiT/kOSOJLuSvLIbPznJjUnu6r6eNPScy5LsTnJnkvOGxp+eZGf32OVJMp0/liRplKM50j8IvLqqngI8A7gkyZnAVuCmqtoA3NTdp3tsM3AWsAm4IsmKLutKYAuwobttmuCfRZK0gAU/cK2q9gP7u+UHk9wBrAEuAM7tVrsa+BBwaTd+bVU9BNydZDdwTpI9wIlV9VGAJNcAFwLvn9wfZ3L8QDdJj0aLOqefZD3wPcA/A6d2/yEc+o/hlG61NcC9Q0/b242t6Zbnj4/azpYkc0nmDhw4sJgpSpKO4KhLP8kJwHuAX6mqLx9p1RFjdYTxRw5WXVVVG6tq4+rVq492ipKkBRxV6Sd5DIPC/4uq+qtu+P4kp3WPnwY80I3vBdYNPX0tsK8bXztiXJI0I0dz9U6AtwJ3VNUbhh7aAVzULV8EXD80vjnJcUnOYPCC7c3dKaAHkzyjy3zJ0HMkSTNwNL8565nAi4GdSW7rxn4N2A5cl+Ri4DPACwCqaleS64DbGVz5c0lVPdw972XA24HjGbyAe0y+iCtJj1ZHc/XOPzL6fDzAsw/znG3AthHjc8BTFzNBSdLk+I5cSWqIpS9JDbH0Jakhlr4kNcTSl6SGWPqS1BBLX5IaYulLUkMsfUlqiKUvSQ2x9CWpIZa+JDXE0pekhlj6ktQQS1+SGmLpS1JDLH1JaoilL0kNsfQlqSGWviQ1xNKXpIZY+pLUEEtfkhpi6UtSQyx9SWrIyuWeQKvWb73hqNfds/38Kc5EUks80pekhlj6ktQQS1+SGmLpS1JDLH1JaoilL0kNsfQlqSGWviQ1xNKXpIZY+pLUEEtfkhpi6UtSQyx9SWrIgqWf5G1JHkjyqaGx1yW5L8lt3e35Q49dlmR3kjuTnDc0/vQkO7vHLk+Syf9xJElHcjRH+m8HNo0Yf2NVnd3d3geQ5ExgM3BW95wrkqzo1r8S2AJs6G6jMiVJU7Rg6VfVR4AvHGXeBcC1VfVQVd0N7AbOSXIacGJVfbSqCrgGuHCJc5YkLdE45/RfkeST3emfk7qxNcC9Q+vs7cbWdMvzx0dKsiXJXJK5AwcOjDFFSdKwpZb+lcC3AWcD+4E/7MZHnaevI4yPVFVXVdXGqtq4evXqJU5RkjTfkkq/qu6vqoer6v+APwPO6R7aC6wbWnUtsK8bXztiXJI0Q0sq/e4c/SE/ARy6smcHsDnJcUnOYPCC7c1VtR94MMkzuqt2XgJcP8a8JUlLsOAvRk/yTuBcYFWSvcBrgXOTnM3gFM0e4JcAqmpXkuuA24GDwCVV9XAX9TIGVwIdD7y/u0mSZmjB0q+qF40YfusR1t8GbBsxPgc8dVGzkyRNlO/IlaSGWPqS1BBLX5IaYulLUkMsfUlqiKUvSQ2x9CWpIZa+JDXE0pekhlj6ktQQS1+SGmLpS1JDLH1JaoilL0kNsfQlqSGWviQ1xNKXpIZY+pLUEEtfkhpi6UtSQyx9SWrIyuWegCZv/dYbFrX+nu3nT2kmko41HulLUkMsfUlqiKUvSQ2x9CWpIZa+JDXE0pekhlj6ktQQS1+SGmLpS1JDLH1JaoilL0kNsfQlqSGWviQ1xNKXpIZY+pLUEEtfkhpi6UtSQxYs/SRvS/JAkk8NjZ2c5MYkd3VfTxp67LIku5PcmeS8ofGnJ9nZPXZ5kkz+jyNJOpKjOdJ/O7Bp3thW4Kaq2gDc1N0nyZnAZuCs7jlXJFnRPedKYAuwobvNz5QkTdmCpV9VHwG+MG/4AuDqbvlq4MKh8Wur6qGquhvYDZyT5DTgxKr6aFUVcM3QcyRJM7LUc/qnVtV+gO7rKd34GuDeofX2dmNruuX54yMl2ZJkLsncgQMHljhFSdJ8k34hd9R5+jrC+EhVdVVVbayqjatXr57Y5CSpdUst/fu7UzZ0Xx/oxvcC64bWWwvs68bXjhiXJM3QUkt/B3BRt3wRcP3Q+OYkxyU5g8ELtjd3p4AeTPKM7qqdlww9R5I0IysXWiHJO4FzgVVJ9gKvBbYD1yW5GPgM8AKAqtqV5DrgduAgcElVPdxFvYzBlUDHA+/vbpKkGVqw9KvqRYd56NmHWX8bsG3E+Bzw1EXNTpI0Ub4jV5IaYulLUkMsfUlqiKUvSQ2x9CWpIZa+JDXE0pekhlj6ktQQS1+SGmLpS1JDLH1JaoilL0kNsfQlqSGWviQ1xNKXpIZY+pLUEEtfkhpi6UtSQyx9SWqIpS9JDbH0Jakhlr4kNcTSl6SGWPqS1BBLX5IaYulLUkMsfUlqiKUvSQ2x9CWpIZa+JDXE0pekhlj6ktQQS1+SGmLpS1JDLH1JaoilL0kNsfQlqSGWviQ1xNKXpIZY+pLUkLFKP8meJDuT3JZkrhs7OcmNSe7qvp40tP5lSXYnuTPJeeNOXpK0OJM40n9WVZ1dVRu7+1uBm6pqA3BTd58kZwKbgbOATcAVSVZMYPuSpKM0jdM7FwBXd8tXAxcOjV9bVQ9V1d3AbuCcKWxfknQY45Z+AR9IckuSLd3YqVW1H6D7eko3vga4d+i5e7uxR0iyJclckrkDBw6MOUVJ0iErx3z+M6tqX5JTgBuTfPoI62bEWI1asaquAq4C2Lhx48h1JEmLN9aRflXt674+ALyXwema+5OcBtB9faBbfS+wbujpa4F942xfkrQ4Sy79JI9L8vhDy8DzgE8BO4CLutUuAq7vlncAm5Mcl+QMYANw81K3L0lavHFO75wKvDfJoZx3VNXfJfk4cF2Si4HPAC8AqKpdSa4DbgcOApdU1cNjzV6StChLLv2q+nfgaSPGPw88+zDP2QZsW+o2dWxYv/WGRa2/Z/v5U5qJpMXyHbmS1BBLX5IaYulLUkMsfUlqiKUvSQ2x9CWpIZa+JDXE0pekhlj6ktQQS1+SGmLpS1JDLH1JaoilL0kNsfQlqSGWviQ1xNKXpIZY+pLUEEtfkhpi6UtSQyx9SWqIpS9JDbH0Jakhlr4kNcTSl6SGWPqS1BBLX5IaYulLUkMsfUlqiKUvSQ2x9CWpISuXewLSfOu33rCo9fdsP39KM5EefTzSl6SGWPqS1BBP76g5nj5SyzzSl6SGWPqS1BBLX5IaYulLUkMsfUlqyMyv3kmyCXgzsAJ4S1Vtn/UcpGny6iAdy2Za+klWAH8CPBfYC3w8yY6qun2W85D6zP9UNI5ZH+mfA+yuqn8HSHItcAFg6UvHiGn/p2L+8kpVzW5jyU8Bm6rqpd39FwPfX1WvmLfeFmBLd/c7gTsXsZlVwOcmMN3lyO/z3M033/xjK//0qlo9f3DWR/oZMfaI/3Wq6irgqiVtIJmrqo1Lee5y5/d57uabb34/8md99c5eYN3Q/bXAvhnPQZKaNevS/ziwIckZSR4LbAZ2zHgOktSsmZ7eqaqDSV4B/D2DSzbfVlW7JryZJZ0WOkby+zx38803vwf5M30hV5K0vHxHriQ1xNKXpIZY+pLUEEtfkhrS61+XmCQMPtphDYM3ee0Dbq4JvTptvvnm9zO/z3Ofdn5vr95J8jzgCuAu4L5ueC3w7cDLq+oD5ptvfnv5fZ77LPKpql7egDuA9SPGzwDuMN9889vM7/PcZ5Hf53P6Kxl8rMN89wGPMd9885vN7/Pcp57f53P6b2PwefzXAvd2Y+sYfLTDW8033/xm8/s896nn9/acPkCSpzD4PP41DD7Bcy8wsV/KYr755vczv89zn3Z+r0tfkrQ4fT6nf1hJXme++eabP8vsvuQ/KksfuMV88803f8bZvcj39I4kNaTXR/pJnpXkj5Ncn+Q9SbYn+fYJ5p+X5MokO7ptXJlk04SyT07ym0lemoHXJPnbJH+Q5KQJ5L8hyTMnMdfD5P9EkpO75dVJrkmyM8m7kqyd1na77f3mBDJWzbv/c0kuT7KlezfkxCX54DRyR2xnEvsnSV6Y5AXd8rO7/fPyJBPpje776+Ik6+eN/+KYuVP93uq20d/u6euRfpLtwKnATcCFwN3AvwIvB15fVe8eM/9NwHcA1/D1a2bXAi8B7qqqV46Z/z5gJ3Ai8JRu+TrgucDTquqCMfMPAPcAq4F3Ae+sqlvHyZyXf3tVndktvwv4GPBu4DnAz1bVcye1rRHb/kxVfcuYGZ+oqu/tln8d+GHgHcCPAnur6lVj5n9y/hCDf093AlTVd4+Tv8C2J7F/rgBOAR4LfBk4Dvgb4PnA/RP49/964IeATwA/Brypqv6oe+xrfzdLzJ7291avu2esd3Yt5w3YObS8Evinbvkk4FMTyP/Xw4yn2/Hj5t82lHffqMfGzL+1+7oB+A1gF/Bp4LXAd0wg/86h5VumMP8vH+b2IHBwUvunW/4E8Lhu+THD/7bGyN8B/DnwZOB0YD2Da65PB07vwf7ZObQ/Pg88tru/ckL7Zyewslt+AvA+4I3z/26WmH1b93Va31u97p4+n975v0OnF4BvZvDrF6mqLzLYOeP6apJzRox/H/DVCeR/Q/ej5jrghEM/4iZ5IoOjq3EVQFXdVVW/U1VnAS8EvpHBN9i4PpTkt5Mc3y1fCIMfe4H/mED+l4ANVXXivNvjgf0TyD8+yfckeTqwoqq+AlBV/ws8PG54Vf048B4Gv+LuaVW1B/jfqrqnqu4ZN5/p75+D8LX98fGq+p/u/kEmsH8YFP6hbXyJwdH+iUnezfj//qf9vdXr7unzO3JfD9ya5E4GR1Mvg8H5ZeBfJpD/88CVSR7P13/EWsfgaOrnJ5D/ewyOvAF+EXhLkgLOBH5rAvmP+MdXVZ8EPglcNoH8VwCvoTtdAbwqyVcYnAJ48QTyr2FwVHz/iMfeMYH8/cAbuuUvJDmtqvZ3xXBwAvlU1XuTfAD4nSQvZTKFc8i0989nk5xQVf9ZVV87l5zkScD/TCD/35L8SFV9GKCqHgYuTvK7wE+OmT3t761ed09vz+nD4AUb4FuB3d3RwjS28SSG3hVXVZ+dYPYKBn8HB5OsBM5m8OPo2Edqh75hx805ym19E4Mjt8/PYnvT1P2dHFdV/zXh3KcBP1BVfzrJ3FlL8jgGp8IeGDPneICq+u8Rj62pqvse+axF5U/te6vL72339Lr0DyfJk6vq0wuveVRZj+l+xB0eW1VVn5tE/mG2ObH59z3f/W/+EjN6+3n3C2x37H3T53P6RzLe503ztUuy9gL7knxg3mVlY+cvoPl897/5S5XB59HfBbyOwdVG5zM4rXNX99hYpp2/gLH3fW/P6Se5/HAPMbgaYFy/D5xXVbuS/BRwY5IXV9XHmMCLNdOef9/zcf+bv3RvBp7TvXg+vM0zGFzE8JRjOX/a+763pQ/8AvBq4KERj71oAvmPrapdAFX1l0nuAP4qyVa6K2PGNO359z3f/W/+UvX68+6Z9r4f95rP5boBHwR+8DCP3T2B/DngSfPG1gK3AQ/2YP59z3f/m7/U7MuAW4FLgZ/pbpd2Y5dNYO7Tzp/qvu/tC7ndq+dfrQlfZTGU/xzgQFX9y7zxJwCXVNW2MfOnPf++57v/zR8n/0zgx5ne591PLX/q+6avpS9JWrzeXr2T5Jsy+JCjTyf5fHe7oxt7gvnmm99mfp/nPov83pY+gw9Q+iJwblU9saqeCDyrGxvrA4/MN9/8XucfLvtLE8hezvzJ7PtxXxRYrhtDH/i1mMfMN9/8R3d+n+c+i/w+H+nfk+RXk5x6aCDJqUku5eu/Qd58881vL7/Pc596fp9L/6eBJwIfTvLFJF8APgSczODTJM033/w28/s89+nnj/ujwnLeGHzC3XOAE+aNbzLffPPbze/z3Ke+byYxweW4Ab/M4GN9/xrYA1ww9NgnzDff/Dbz+zz3meSPG7BcNwa/eeeEbnk9g3dwvrK7f6v55pvfZn6f5z6L/D5/9s6K6j4vvqr2JDkX+MskpzOZ315jvvnm9zO/z3Ofen6fX8j9bJKzD93pdtKPAquA7zLffPObze/z3KefP+6PCst1Y/DhW086zGPPNN9889vM7/PcZ5HvZ+9IUkP6fHpHkrRIlr4kNcTSl6SGWPqS1JD/BwDTuHk0I3jAAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "data[\"Date_N\"].dt.year.value_counts().plot(kind=\"bar\")            # shows the numbers of movies and Tv shows released per year"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6a2425b8",
   "metadata": {},
   "source": [
    "# Q-3 Show how many number of movies and Tv shows are present in our data set with graph ?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "id": "dd59d663",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Category  Category\n",
       "Movie     Movie       5377\n",
       "TV Show   TV Show     2410\n",
       "Name: Category, dtype: int64"
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.groupby(\"Category\").Category.value_counts()      # shows the total count of movies and tv shows in data set"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "id": "35961f32",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:xlabel='Category', ylabel='count'>"
      ]
     },
     "execution_count": 63,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYsAAAEGCAYAAACUzrmNAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjQuMywgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/MnkTPAAAACXBIWXMAAAsTAAALEwEAmpwYAAAT/klEQVR4nO3df7Bc5X3f8fcHgYEWEyAIIks4oo7aWBCbGJXQuPnhkBoldiKcmFQe2ygOU6WUZOJO7Qwkbf2jVeKZuJkE15BoUhvJTcFKHIziCXEYueDExcZXNkYITFENAQWCBE5icFtq4W//2EdmfbX3PldYu1fSfb9mzpxzvuc85z7LLPrs+bHPpqqQJGk2x8x3ByRJhz/DQpLUZVhIkroMC0lSl2EhSeo6dr47MC6nn356LV++fL67IUlHlO3btz9RVYun14/asFi+fDlTU1Pz3Q1JOqIk+ctRdS9DSZK6DAtJUpdhIUnqMiwkSV2GhSSpy7CQJHUZFpKkLsNCktRlWEiSuo7ab3BLR7OH3/09890FHYZe/O93jO3YnllIkroMC0lSl2EhSeoyLCRJXYaFJKnLsJAkdRkWkqQuw0KS1GVYSJK6DAtJUtdYwyLJQ0l2JLkryVSrnZbk1iQPtPmpQ/tfnWRXkvuTXDxUP78dZ1eSa5JknP2WJH2zSZxZvKqqzquqVW39KmBbVa0AtrV1kqwE1gLnAKuBa5Msam2uA9YDK9q0egL9liQ183EZag2wqS1vAi4Zqt9YVc9U1YPALuCCJEuAk6vqjqoqYPNQG0nSBIw7LAr4syTbk6xvtTOr6jGANj+j1ZcCjwy13d1qS9vy9PoBkqxPMpVkau/evYfwZUjSwjbuIcpfWVWPJjkDuDXJF2fZd9R9iJqlfmCxaiOwEWDVqlUj95EkHbyxnllU1aNtvge4CbgAeLxdWqLN97TddwNnDTVfBjza6stG1CVJEzK2sEjy95O8cP8y8GrgHmArsK7ttg64uS1vBdYmOT7J2QxuZN/ZLlU9leTC9hTUZUNtJEkTMM7LUGcCN7WnXI8F/ltV/WmSzwJbklwOPAxcClBVO5NsAe4F9gFXVtWz7VhXANcDJwK3tEmSNCFjC4uq+hLw8hH1J4GLZmizAdgwoj4FnHuo+yhJmhu/wS1J6jIsJEldhoUkqcuwkCR1GRaSpC7DQpLUZVhIkroMC0lSl2EhSeoyLCRJXYaFJKnLsJAkdRkWkqQuw0KS1GVYSJK6DAtJUpdhIUnqMiwkSV2GhSSpy7CQJHUZFpKkLsNCktRlWEiSugwLSVKXYSFJ6jIsJEldhoUkqcuwkCR1GRaSpC7DQpLUNfawSLIoyeeTfKytn5bk1iQPtPmpQ/tenWRXkvuTXDxUPz/JjrbtmiQZd78lSc+ZxJnFLwH3Da1fBWyrqhXAtrZOkpXAWuAcYDVwbZJFrc11wHpgRZtWT6DfkqRmrGGRZBnwGuD3hsprgE1teRNwyVD9xqp6pqoeBHYBFyRZApxcVXdUVQGbh9pIkiZg3GcWvwX8MvD1odqZVfUYQJuf0epLgUeG9tvdakvb8vT6AZKsTzKVZGrv3r2H5AVIksYYFkleC+ypqu1zbTKiVrPUDyxWbayqVVW1avHixXP8s5KknmPHeOxXAj+Z5MeBE4CTk/xX4PEkS6rqsXaJaU/bfzdw1lD7ZcCjrb5sRF2SNCFjO7OoqqurallVLWdw4/oTVfUmYCuwru22Dri5LW8F1iY5PsnZDG5k39kuVT2V5ML2FNRlQ20kSRMwzjOLmbwH2JLkcuBh4FKAqtqZZAtwL7APuLKqnm1trgCuB04EbmmTJGlCJhIWVXUbcFtbfhK4aIb9NgAbRtSngHPH10NJ0mz8BrckqcuwkCR1GRaSpC7DQpLUZVhIkroMC0lSl2EhSeoyLCRJXYaFJKnLsJAkdRkWkqQuw0KS1GVYSJK6DAtJUpdhIUnqMiwkSV2GhSSpy7CQJHUZFpKkLsNCktRlWEiSugwLSVKXYSFJ6jIsJEldhoUkqcuwkCR1GRaSpC7DQpLUNaewSLJtLjVJ0tFp1rBIckKS04DTk5ya5LQ2LQdeNIe2dyb5QpKdSd7V6qcluTXJA21+6lCbq5PsSnJ/kouH6ucn2dG2XZMk39KrliQdlN6Zxc8D24HvbvP9083A+zttnwF+pKpeDpwHrE5yIXAVsK2qVgDb2jpJVgJrgXOA1cC1SRa1Y10HrAdWtGn13F+iJOlbNWtYVNVvV9XZwNuq6h9U1dltenlV/edO26qqp9vqcW0qYA2wqdU3AZe05TXAjVX1TFU9COwCLkiyBDi5qu6oqgI2D7WRJE3AsXPZqarel+T7geXDbapq82zt2pnBduC7gPdX1WeSnFlVj7X2jyU5o+2+FPj0UPPdrfa1tjy9PurvrWdwBsKLX/ziubw0SdIczCksknwIeAlwF/BsK+//lD+jqnoWOC/JKcBNSc6d7c+MOsQs9VF/byOwEWDVqlUj95EkHbw5hQWwCljZLgMdtKr62yS3MbjX8HiSJe2sYgmwp+22GzhrqNky4NFWXzaiLkmakLl+z+Ie4DsO5sBJFrczCpKcCPwo8EVgK7Cu7baOwc1yWn1tkuOTnM3gRvad7ZLVU0kubE9BXTbURpI0AXM9szgduDfJnQyecgKgqn5yljZLgE3tvsUxwJaq+liSO4AtSS4HHgYubcfamWQLcC+wD7iyXcYCuAK4HjgRuKVNkqQJmWtYvPNgD1xVdwPfO6L+JHDRDG02ABtG1KeA2e53SJLGaK5PQ90+7o5Ikg5fc30a6imeewLpBQy+M/HVqjp5XB2TJB0+5npm8cLh9SSXABeMo0OSpMPP8xp1tqo+CvzIoe2KJOlwNdfLUD81tHoMg+9d+KU3SVog5vo01E8MLe8DHmIwlpMkaQGY6z2Lt4y7I5Kkw9dcf/xoWZKbkuxJ8niSjyRZ1m8pSToazPUG9wcZDMfxIgYjvv5xq0mSFoC5hsXiqvpgVe1r0/XA4jH2S5J0GJlrWDyR5E1JFrXpTcCT4+yYJOnwMdew+DngZ4C/Bh4DXg9401uSFoi5Pjr7H4B1VfU3AElOA97LIEQkSUe5uZ5ZvGx/UABU1ZcZMaKsJOnoNNewOCbJqftX2pnFXM9KJElHuLn+g/+fgP+R5A8ZDPPxM4z43QlJ0tFprt/g3pxkisHggQF+qqruHWvPJEmHjTlfSmrhsGAC4vy3b57vLugwtP03LpvvLkjz4nkNUS5JWlgMC0lSl2EhSeoyLCRJXYaFJKnLsJAkdRkWkqQuw0KS1GVYSJK6DAtJUpdhIUnqMiwkSV1jC4skZyX570nuS7IzyS+1+mlJbk3yQJsP/07G1Ul2Jbk/ycVD9fOT7GjbrkmScfVbknSgcZ5Z7AP+TVW9FLgQuDLJSuAqYFtVrQC2tXXatrXAOcBq4Noki9qxrgPWAyvatHqM/ZYkTTO2sKiqx6rqc235KeA+YCmwBtjUdtsEXNKW1wA3VtUzVfUgsAu4IMkS4OSquqOqCtg81EaSNAETuWeRZDmD3+z+DHBmVT0Gg0ABzmi7LQUeGWq2u9WWtuXp9VF/Z32SqSRTe/fuPaSvQZIWsrGHRZKTgI8Ab62qr8y264hazVI/sFi1sapWVdWqxYsXH3xnJUkjjTUskhzHICh+v6r+qJUfb5eWaPM9rb4bOGuo+TLg0VZfNqIuSZqQcT4NFeC/APdV1W8ObdoKrGvL64Cbh+prkxyf5GwGN7LvbJeqnkpyYTvmZUNtJEkTMOff4H4eXgm8GdiR5K5W+xXgPcCWJJcDDwOXAlTVziRbGPzO9z7gyqp6trW7ArgeOBG4pU2SpAkZW1hU1V8w+n4DwEUztNkAbBhRnwLOPXS9kyQdDL/BLUnqMiwkSV2GhSSpy7CQJHUZFpKkLsNCktRlWEiSugwLSVKXYSFJ6jIsJEldhoUkqcuwkCR1GRaSpC7DQpLUZVhIkroMC0lSl2EhSeoyLCRJXYaFJKnLsJAkdRkWkqQuw0KS1GVYSJK6DAtJUpdhIUnqMiwkSV2GhSSpy7CQJHUZFpKkrrGFRZIPJNmT5J6h2mlJbk3yQJufOrTt6iS7ktyf5OKh+vlJdrRt1yTJuPosSRptnGcW1wOrp9WuArZV1QpgW1snyUpgLXBOa3NtkkWtzXXAemBFm6YfU5I0ZmMLi6r6JPDlaeU1wKa2vAm4ZKh+Y1U9U1UPAruAC5IsAU6uqjuqqoDNQ20kSRMy6XsWZ1bVYwBtfkarLwUeGdpvd6stbcvT6yMlWZ9kKsnU3r17D2nHJWkhO1xucI+6D1Gz1Eeqqo1VtaqqVi1evPiQdU6SFrpJh8Xj7dISbb6n1XcDZw3ttwx4tNWXjahLkiZo0mGxFVjXltcBNw/V1yY5PsnZDG5k39kuVT2V5ML2FNRlQ20kSRNy7LgOnOQG4IeB05PsBt4BvAfYkuRy4GHgUoCq2plkC3AvsA+4sqqebYe6gsGTVScCt7RJkjRBYwuLqnrDDJsummH/DcCGEfUp4NxD2DVJ0kE6XG5wS5IOY4aFJKnLsJAkdRkWkqQuw0KS1GVYSJK6DAtJUpdhIUnqMiwkSV2GhSSpy7CQJHUZFpKkLsNCktRlWEiSugwLSVKXYSFJ6jIsJEldhoUkqcuwkCR1GRaSpC7DQpLUZVhIkroMC0lSl2EhSeoyLCRJXYaFJKnLsJAkdRkWkqQuw0KS1GVYSJK6jpiwSLI6yf1JdiW5ar77I0kLyRERFkkWAe8HfgxYCbwhycr57ZUkLRxHRFgAFwC7qupLVfX/gBuBNfPcJ0laMI6d7w7M0VLgkaH13cD3Td8pyXpgfVt9Osn9E+jbQnA68MR8d+JwkPeum+8u6EC+P/d7Rw7FUb5zVPFICYtR/wXqgELVRmDj+LuzsCSZqqpV890PaRTfn5NxpFyG2g2cNbS+DHh0nvoiSQvOkRIWnwVWJDk7yQuAtcDWee6TJC0YR8RlqKral+QXgI8Di4APVNXOee7WQuKlPR3OfH9OQKoOuPQvSdI3OVIuQ0mS5pFhIUnqMiyOMkm+PcldbfrrJH81tH7xtH3fmuTaEcf41SQ7k9zd2n1fqz+U5PRJvRYtLEkqyYeG1o9NsjfJx57n8f5lkssOXQ8XtiPiBrfmrqqeBM4DSPJO4Omqem+Sn2fwFNnHh3ZfC7x9uH2SfwK8FnhFVT3TwuEFE+i69FXg3CQnVtX/Af4Z8FfP92BV9TuHrGfyzGIB+UPgtUmOB0iyHHgR8BfT9lsCPFFVzwBU1RNVNfydll9M8rkkO5J8dzvWaUk+2s5EPp3kZa2+I8kpGXhy/6e8JB9K8qNjfbU6Ut0CvKYtvwG4Yf+GUe+zJMe0M95ThvbbleTMJO9M8rZWe0mSP02yPcmf73/vau4MiwWinXHcCaxupbXAh+vAx+H+DDgryf9Mcm2SH5q2/YmqegVwHfC2VnsX8PmqehnwK8DmVv8U8ErgHOBLwA+0+oXApw/NK9NR5kZgbZITgJcBnxnadsD7rKq+DtwMvA6gXTJ9qKoen3bcjcAvVtX5DN63B1x+1ewMi4XlBgYhQZvfMH2HqnoaOJ/BGFt7gQ8n+dmhXf6ozbcDy9vyPwU+1Np/Avj2JN8G/Dnwg226DvieJEuBL7e/I32TqrqbwfvqDcCfTNs80/vsw8A/b/usbevfkOQk4PuBP0hyF/C7DM6gdRAMi4Xlo8BFSV4BnFhVnxu1U1U9W1W3VdU7gF8Afnpo8zNt/izP3fOaaeyuTzI4m/gB4DYG4fN6BiEizWQr8F4O/DAz0/vsDuC7kiwGLuG5DzT7HQP8bVWdNzS99BD3+ahnWCwg7dP8bcAHGHFWAZDkHyVZMVQ6D/jLzqE/Cbyxtf9hBpeqvlJVjzAYEXRFVX2Jwf2Rt2FYaHYfAN5dVTum1Wd6nxVwE/CbwH3tkus3VNVXgAeTXNraJsnLx/sSjj4+DbXw3MDgk9faGbafBLyv3TDcB+ziuWHfZ/JO4INJ7gb+NzA8jvdnGAzRAoOQ+HUOvKkufUNV7QZ+e8SmdzLz++zDDMaQ+9kZDvtG4Lok/xY4jsG9kS8coi4vCA73IUnq8jKUJKnLsJAkdRkWkqQuw0KS1GVYSJK6DAtpFkm+I8mNSf5XknuT/EmSfzjDvqck+VeT7qM0CYaFNIMkYfBlr9uq6iVVtZLBmERnztDkFGDsYZHE70dp4gwLaWavAr42PNR1Vd0FfD7JtqHRd9e0ze8BXtJ+A+Q3AJK8Pcln20ip79p/nCT/LskXk9ya5Iah0VHPayOq3p3kpiSntvptSX4tye3AryZ5MMlxbdvJbeTV4ybxH0ULk59QpJmdy2DAxOn+L/C6qvpK+72PTyfZClwFnFtV5wEkeTWwAriAwbhGW5P8IINvH/808L0M/h/83NDf2cxgdNTbk7wbeAfw1rbtlKr6oXbs5QyG8v4og2/jf6SqvnbIXrk0jWEhHbwAv9b+4f86sJTRl6Ze3abPt/WTGITHC4Gb2w/8kOSP2/zbGATC7W3/TcAfDB1veDTV3wN+mUFYvAX4F9/yq5JmYVhIM9vJYJTc6d4ILAbOr6qvJXkIOGHEfgF+vap+95uKyb9+nv356v6FqvpUkuXt90YWVdU9z/OY0px4z0Ka2SeA45N841N7kn8MfCewpwXFq9o6wFMMzhr2+zjwc+33FEiyNMkZDAZS/IkkJ7RtrwGoqr8D/ibJ/h+JejNwOzPbzGBgyA9+i69T6vLMQppBVVWS1wG/leQqBvcqHmIw+uk1SaaAu4Avtv2fTPKpJPcAt1TV25O8FLhj8GAVTwNvqqrPtnscX2Aw/PsU8Hftz64DfifJ32Pw64JvmaWLvw/8R2YYbl46lBx1VpoHSU6qqqdbKHwSWD/Tj1HNcozXA2uq6s1j6aQ0xDMLaX5sTLKSwb2OTc8jKN4H/Bjw4+PonDSdZxaSpC5vcEuSugwLSVKXYSFJ6jIsJEldhoUkqev/AyyEbmoIbGSuAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "sns.countplot(data[\"Category\"])       # shows the total count of movies and tv shows in data set with count graph"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "da30f115",
   "metadata": {},
   "source": [
    "# Q-4 show all movies that released in 2020 ?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "id": "c021c3e5",
   "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>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",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>s164</td>\n",
       "      <td>Movie</td>\n",
       "      <td>A Cinderella Story</td>\n",
       "      <td>Mark Rosman</td>\n",
       "      <td>Hilary Duff, Chad Michael Murray, Jennifer Coo...</td>\n",
       "      <td>United States, Canada</td>\n",
       "      <td>January 1, 2020</td>\n",
       "      <td>PG</td>\n",
       "      <td>95 min</td>\n",
       "      <td>Children &amp; Family Movies, Comedies</td>\n",
       "      <td>Teen Sam meets the boy of her dreams at a danc...</td>\n",
       "      <td>2020-01-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>433</th>\n",
       "      <td>s434</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Alpha and Omega: The Legend of the Saw Tooth Cave</td>\n",
       "      <td>Richard Rich</td>\n",
       "      <td>Debi Derryberry, Ben Diskin, Kate Higgins, Lin...</td>\n",
       "      <td>United States, India</td>\n",
       "      <td>January 1, 2020</td>\n",
       "      <td>TV-Y7</td>\n",
       "      <td>45 min</td>\n",
       "      <td>Children &amp; Family Movies</td>\n",
       "      <td>When a wolf pup named Runt sneaks off to explo...</td>\n",
       "      <td>2020-01-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>455</th>\n",
       "      <td>s456</td>\n",
       "      <td>Movie</td>\n",
       "      <td>American Beauty</td>\n",
       "      <td>Sam Mendes</td>\n",
       "      <td>Kevin Spacey, Annette Bening, Thora Birch, Wes...</td>\n",
       "      <td>United States</td>\n",
       "      <td>January 1, 2020</td>\n",
       "      <td>R</td>\n",
       "      <td>122 min</td>\n",
       "      <td>Dramas</td>\n",
       "      <td>While struggling to endure his tightly wound w...</td>\n",
       "      <td>2020-01-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>588</th>\n",
       "      <td>s589</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Arthur Christmas</td>\n",
       "      <td>Sarah Smith</td>\n",
       "      <td>James McAvoy, Hugh Laurie, Bill Nighy, Jim Bro...</td>\n",
       "      <td>United Kingdom, United States</td>\n",
       "      <td>January 1, 2020</td>\n",
       "      <td>PG</td>\n",
       "      <td>98 min</td>\n",
       "      <td>Children &amp; Family Movies, Comedies</td>\n",
       "      <td>At Santa Claus's super-secret toy-making facil...</td>\n",
       "      <td>2020-01-01</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7560</th>\n",
       "      <td>s7559</td>\n",
       "      <td>Movie</td>\n",
       "      <td>What Lies Beneath</td>\n",
       "      <td>Robert Zemeckis</td>\n",
       "      <td>Harrison Ford, Michelle Pfeiffer, Diana Scarwi...</td>\n",
       "      <td>United States</td>\n",
       "      <td>January 1, 2020</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>130 min</td>\n",
       "      <td>Horror Movies, Thrillers</td>\n",
       "      <td>When Claire Spencer starts hearing ghostly voi...</td>\n",
       "      <td>2020-01-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7625</th>\n",
       "      <td>s7624</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Wild Wild West</td>\n",
       "      <td>Barry Sonnenfeld</td>\n",
       "      <td>Will Smith, Kevin Kline, Kenneth Branagh, Salm...</td>\n",
       "      <td>United States</td>\n",
       "      <td>January 1, 2020</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>106 min</td>\n",
       "      <td>Action &amp; Adventure, Comedies, Sci-Fi &amp; Fantasy</td>\n",
       "      <td>Armed with an ingenious arsenal, two top-notch...</td>\n",
       "      <td>2020-01-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7630</th>\n",
       "      <td>s7629</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Willy Wonka &amp; the Chocolate Factory</td>\n",
       "      <td>Mel Stuart</td>\n",
       "      <td>Gene Wilder, Jack Albertson, Peter Ostrum, Roy...</td>\n",
       "      <td>United States, East Germany, West Germany</td>\n",
       "      <td>January 1, 2020</td>\n",
       "      <td>G</td>\n",
       "      <td>100 min</td>\n",
       "      <td>Children &amp; Family Movies, Classic Movies, Come...</td>\n",
       "      <td>Zany Willy Wonka causes a stir when he announc...</td>\n",
       "      <td>2020-01-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7683</th>\n",
       "      <td>s7682</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Wyatt Earp</td>\n",
       "      <td>Lawrence Kasdan</td>\n",
       "      <td>Kevin Costner, Dennis Quaid, Gene Hackman, Dav...</td>\n",
       "      <td>United States</td>\n",
       "      <td>January 1, 2020</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>191 min</td>\n",
       "      <td>Action &amp; Adventure</td>\n",
       "      <td>Legendary lawman Wyatt Earp is continually at ...</td>\n",
       "      <td>2020-01-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7707</th>\n",
       "      <td>s7706</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Yes Man</td>\n",
       "      <td>Peyton Reed</td>\n",
       "      <td>Jim Carrey, Zooey Deschanel, Bradley Cooper, J...</td>\n",
       "      <td>United States, United Kingdom</td>\n",
       "      <td>January 1, 2020</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>104 min</td>\n",
       "      <td>Comedies, Romantic Movies</td>\n",
       "      <td>After a bitter divorce, a bank drone falls und...</td>\n",
       "      <td>2020-01-01</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>105 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Show_Id Category                                              Title  \\\n",
       "4         s5    Movie                                                 21   \n",
       "163     s164    Movie                                 A Cinderella Story   \n",
       "433     s434    Movie  Alpha and Omega: The Legend of the Saw Tooth Cave   \n",
       "455     s456    Movie                                    American Beauty   \n",
       "588     s589    Movie                                   Arthur Christmas   \n",
       "...      ...      ...                                                ...   \n",
       "7560   s7559    Movie                                  What Lies Beneath   \n",
       "7625   s7624    Movie                                     Wild Wild West   \n",
       "7630   s7629    Movie                Willy Wonka & the Chocolate Factory   \n",
       "7683   s7682    Movie                                         Wyatt Earp   \n",
       "7707   s7706    Movie                                            Yes Man   \n",
       "\n",
       "              Director                                               Cast  \\\n",
       "4       Robert Luketic  Jim Sturgess, Kevin Spacey, Kate Bosworth, Aar...   \n",
       "163        Mark Rosman  Hilary Duff, Chad Michael Murray, Jennifer Coo...   \n",
       "433       Richard Rich  Debi Derryberry, Ben Diskin, Kate Higgins, Lin...   \n",
       "455         Sam Mendes  Kevin Spacey, Annette Bening, Thora Birch, Wes...   \n",
       "588        Sarah Smith  James McAvoy, Hugh Laurie, Bill Nighy, Jim Bro...   \n",
       "...                ...                                                ...   \n",
       "7560   Robert Zemeckis  Harrison Ford, Michelle Pfeiffer, Diana Scarwi...   \n",
       "7625  Barry Sonnenfeld  Will Smith, Kevin Kline, Kenneth Branagh, Salm...   \n",
       "7630        Mel Stuart  Gene Wilder, Jack Albertson, Peter Ostrum, Roy...   \n",
       "7683   Lawrence Kasdan  Kevin Costner, Dennis Quaid, Gene Hackman, Dav...   \n",
       "7707       Peyton Reed  Jim Carrey, Zooey Deschanel, Bradley Cooper, J...   \n",
       "\n",
       "                                        Country     Release_Date Rating  \\\n",
       "4                                 United States  January 1, 2020  PG-13   \n",
       "163                       United States, Canada  January 1, 2020     PG   \n",
       "433                        United States, India  January 1, 2020  TV-Y7   \n",
       "455                               United States  January 1, 2020      R   \n",
       "588               United Kingdom, United States  January 1, 2020     PG   \n",
       "...                                         ...              ...    ...   \n",
       "7560                              United States  January 1, 2020  PG-13   \n",
       "7625                              United States  January 1, 2020  PG-13   \n",
       "7630  United States, East Germany, West Germany  January 1, 2020      G   \n",
       "7683                              United States  January 1, 2020  PG-13   \n",
       "7707              United States, United Kingdom  January 1, 2020  PG-13   \n",
       "\n",
       "     Duration                                               Type  \\\n",
       "4     123 min                                             Dramas   \n",
       "163    95 min                 Children & Family Movies, Comedies   \n",
       "433    45 min                           Children & Family Movies   \n",
       "455   122 min                                             Dramas   \n",
       "588    98 min                 Children & Family Movies, Comedies   \n",
       "...       ...                                                ...   \n",
       "7560  130 min                           Horror Movies, Thrillers   \n",
       "7625  106 min     Action & Adventure, Comedies, Sci-Fi & Fantasy   \n",
       "7630  100 min  Children & Family Movies, Classic Movies, Come...   \n",
       "7683  191 min                                 Action & Adventure   \n",
       "7707  104 min                          Comedies, Romantic Movies   \n",
       "\n",
       "                                            Description     Date_N  \n",
       "4     A brilliant group of students become card-coun... 2020-01-01  \n",
       "163   Teen Sam meets the boy of her dreams at a danc... 2020-01-01  \n",
       "433   When a wolf pup named Runt sneaks off to explo... 2020-01-01  \n",
       "455   While struggling to endure his tightly wound w... 2020-01-01  \n",
       "588   At Santa Claus's super-secret toy-making facil... 2020-01-01  \n",
       "...                                                 ...        ...  \n",
       "7560  When Claire Spencer starts hearing ghostly voi... 2020-01-01  \n",
       "7625  Armed with an ingenious arsenal, two top-notch... 2020-01-01  \n",
       "7630  Zany Willy Wonka causes a stir when he announc... 2020-01-01  \n",
       "7683  Legendary lawman Wyatt Earp is continually at ... 2020-01-01  \n",
       "7707  After a bitter divorce, a bank drone falls und... 2020-01-01  \n",
       "\n",
       "[105 rows x 12 columns]"
      ]
     },
     "execution_count": 71,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[(data[\"Category\"]==\"Movie\") &(data[\"Date_N\"]==\"2020\")]    "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "dcf1aadc",
   "metadata": {},
   "source": [
    "# Q5- Show all the Tv shows of Unites States"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "id": "8885acb4",
   "metadata": {},
   "outputs": [
    {
     "ename": "SyntaxError",
     "evalue": "invalid syntax (Temp/ipykernel_9600/944183116.py, line 1)",
     "output_type": "error",
     "traceback": [
      "\u001b[1;36m  File \u001b[1;32m\"C:\\Users\\USER\\AppData\\Local\\Temp/ipykernel_9600/944183116.py\"\u001b[1;36m, line \u001b[1;32m1\u001b[0m\n\u001b[1;33m    data[ (data[\"Category\"]==\"TV Show\") & (data[\"Country\"]=\"United States\") ]\u001b[0m\n\u001b[1;37m                                                          ^\u001b[0m\n\u001b[1;31mSyntaxError\u001b[0m\u001b[1;31m:\u001b[0m invalid syntax\n"
     ]
    }
   ],
   "source": [
    "data[ (data[\"Category\"]==\"TV Show\") & (data[\"Country\"]=\"United States\") ]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "110aff7b",
   "metadata": {},
   "source": [
    "# Q-6 Show the top 10 directors who gave the highest number of Tv shows and movies to netflix "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "id": "d86b5f9c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Raúl Campos, Jan Suter    18\n",
       "Marcus Raboy              16\n",
       "Jay Karas                 14\n",
       "Cathy Garcia-Molina       13\n",
       "Jay Chapman               12\n",
       "                          ..\n",
       "Vibhu Virender Puri        1\n",
       "Lucien Jean-Baptiste       1\n",
       "Jason Krawczyk             1\n",
       "Quinn Lasher               1\n",
       "Sam Dunn                   1\n",
       "Name: Director, Length: 4050, dtype: int64"
      ]
     },
     "execution_count": 82,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[\"Director\"].value_counts()                   # gave the lis of all directors and their values count of movies and tv shows"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f18a283d",
   "metadata": {},
   "source": [
    "# Q-7 In how many movies Tom Cruise Was Casted ?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 89,
   "id": "bb36dde1",
   "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",
       "  </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]\n",
       "Index: []"
      ]
     },
     "execution_count": 89,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data[\"Cast\"]==\"Tom Cruise\"]                               #It shows nothing because there are more than one cast in cast colums if there is only one charector in colms hen this command would work to remove this problem we use str.contains() command"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 93,
   "id": "8cf4bf74",
   "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~\\AppData\\Local\\Temp/ipykernel_9600/1760439283.py\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;32mD:\\Users\\USER\\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   3446\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   3447\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[0m\n\u001b[1;32m-> 3448\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   3449\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   3450\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mD:\\Users\\USER\\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    137\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[0m\n\u001b[0;32m    138\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[0m\n\u001b[1;32m--> 139\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    140\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    141\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\")]            #to remove that problem we use .str.contains() command but this command not works on nan values so we must first clear them"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 95,
   "id": "d7cb9fe9",
   "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>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",
       "    <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",
       "      <td>2017-07-01</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Show_Id Category  Title           Director  \\\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",
       "\n",
       "                                                Cast        Country  \\\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",
       "\n",
       "        Release_Date Rating  Duration  \\\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",
       "\n",
       "                                                Type  \\\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",
       "\n",
       "                                         Description     Date_N  \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  \n",
       "5  A genetics professor experiments with a treatm... 2017-07-01  "
      ]
     },
     "execution_count": 95,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_new=data.dropna()                              #in this data frame here is not only a singe nan values \n",
    "data_new.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 99,
   "id": "60be60d1",
   "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>3860</th>\n",
       "      <td>s3861</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Magnolia</td>\n",
       "      <td>Paul Thomas Anderson</td>\n",
       "      <td>Jeremy Blackman, Tom Cruise, Melinda Dillon, A...</td>\n",
       "      <td>United States</td>\n",
       "      <td>January 1, 2020</td>\n",
       "      <td>R</td>\n",
       "      <td>189 min</td>\n",
       "      <td>Dramas, Independent Movies</td>\n",
       "      <td>Through chance, human action, past history and...</td>\n",
       "      <td>2020-01-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5071</th>\n",
       "      <td>s5071</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Rain Man</td>\n",
       "      <td>Barry Levinson</td>\n",
       "      <td>Dustin Hoffman, Tom Cruise, Valeria Golino, Ge...</td>\n",
       "      <td>United States</td>\n",
       "      <td>July 1, 2019</td>\n",
       "      <td>R</td>\n",
       "      <td>134 min</td>\n",
       "      <td>Classic Movies, Dramas</td>\n",
       "      <td>A fast-talking yuppie is forced to slow down w...</td>\n",
       "      <td>2019-07-01</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Show_Id Category     Title              Director  \\\n",
       "3860   s3861    Movie  Magnolia  Paul Thomas Anderson   \n",
       "5071   s5071    Movie  Rain Man        Barry Levinson   \n",
       "\n",
       "                                                   Cast        Country  \\\n",
       "3860  Jeremy Blackman, Tom Cruise, Melinda Dillon, A...  United States   \n",
       "5071  Dustin Hoffman, Tom Cruise, Valeria Golino, Ge...  United States   \n",
       "\n",
       "         Release_Date Rating Duration                        Type  \\\n",
       "3860  January 1, 2020      R  189 min  Dramas, Independent Movies   \n",
       "5071     July 1, 2019      R  134 min      Classic Movies, Dramas   \n",
       "\n",
       "                                            Description     Date_N  \n",
       "3860  Through chance, human action, past history and... 2020-01-01  \n",
       "5071  A fast-talking yuppie is forced to slow down w... 2019-07-01  "
      ]
     },
     "execution_count": 99,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_new[data_new[\"Cast\"].str.contains(\"Tom Cruise\")]                 # only wo movies in which tom cruise casted"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "cbc5704a",
   "metadata": {},
   "source": [
    "# Q-8 How many types of ratings are provided by netflix"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 100,
   "id": "26b7c2e8",
   "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": 100,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[\"Rating\"].unique()                            # These are types of Rating provided by netflix"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 101,
   "id": "8de03c4b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "14"
      ]
     },
     "execution_count": 101,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[\"Rating\"].nunique()                         # The total number od types of Rating provided by netflix"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "eb5adb8b",
   "metadata": {},
   "source": [
    "# Q-9 How many movies got   'TV-14' raitings in canada ?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 104,
   "id": "d6915c0a",
   "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>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",
       "      <td>2020-02-05</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",
       "      <td>2019-04-10</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",
       "      <td>2018-12-27</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",
       "      <td>2018-07-01</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",
       "      <td>2017-11-12</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",
       "      <td>2019-10-14</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",
       "      <td>2017-08-22</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",
       "      <td>2017-12-01</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",
       "      <td>2019-07-01</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",
       "      <td>2019-06-18</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",
       "      <td>2020-03-27</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     Date_N  \n",
       "30    This pawesome documentary explores how our fel... 2020-02-05  \n",
       "34    A teenage hacker with a huge nose helps a cool... 2019-04-10  \n",
       "608   After mysterious lights imbue her with extraor... 2018-12-27  \n",
       "1506  Two teenagers print counterfeit money in their... 2018-07-01  \n",
       "3713  This documentary follows the 2016 tour of belo... 2017-11-12  \n",
       "3956  Quebecois comedy star Martin Matte serves up e... 2019-10-14  \n",
       "5336  High schooler Sadie Mitchell believes the worl... 2017-08-22  \n",
       "5393  When a palatial wedding venue turns out to be ... 2017-12-01  \n",
       "6062  Decades after WWII, a former SS officer stands... 2019-07-01  \n",
       "7025  A widow searches for her missing teenage daugh... 2019-06-18  \n",
       "7041  This documentary spotlights the struggle of mi... 2020-03-27  "
      ]
     },
     "execution_count": 104,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[(data[\"Rating\"]==\"TV-14\")&(data['Country']==\"Canada\")&(data[\"Category\"]==\"Movie\")]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6d8c24b2",
   "metadata": {},
   "source": [
    "# Q-10 How many movies got R Rating after 2018"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 106,
   "id": "db4f60e8",
   "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>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>7</th>\n",
       "      <td>s8</td>\n",
       "      <td>Movie</td>\n",
       "      <td>187</td>\n",
       "      <td>Kevin Reynolds</td>\n",
       "      <td>Samuel L. Jackson, John Heard, Kelly Rowan, Cl...</td>\n",
       "      <td>United States</td>\n",
       "      <td>November 1, 2019</td>\n",
       "      <td>R</td>\n",
       "      <td>119 min</td>\n",
       "      <td>Dramas</td>\n",
       "      <td>After one of his high school students attacks ...</td>\n",
       "      <td>2019-11-01</td>\n",
       "    </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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>s18</td>\n",
       "      <td>Movie</td>\n",
       "      <td>22-Jul</td>\n",
       "      <td>Paul Greengrass</td>\n",
       "      <td>Anders Danielsen Lie, Jon Øigarden, Jonas Stra...</td>\n",
       "      <td>Norway, Iceland, United States</td>\n",
       "      <td>October 10, 2018</td>\n",
       "      <td>R</td>\n",
       "      <td>144 min</td>\n",
       "      <td>Dramas, Thrillers</td>\n",
       "      <td>After devastating terror attacks in Norway, a ...</td>\n",
       "      <td>2018-10-10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>s66</td>\n",
       "      <td>Movie</td>\n",
       "      <td>13 Sins</td>\n",
       "      <td>Daniel Stamm</td>\n",
       "      <td>Mark Webber, Rutina Wesley, Devon Graye, Tom B...</td>\n",
       "      <td>United States</td>\n",
       "      <td>January 13, 2019</td>\n",
       "      <td>R</td>\n",
       "      <td>93 min</td>\n",
       "      <td>Horror Movies, Thrillers</td>\n",
       "      <td>A man agrees to appear on a game show with a $...</td>\n",
       "      <td>2019-01-13</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7712</th>\n",
       "      <td>s7711</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Yes, God, Yes</td>\n",
       "      <td>Karen Maine</td>\n",
       "      <td>Natalia Dyer, Timothy Simons, Wolfgang Novogra...</td>\n",
       "      <td>United States</td>\n",
       "      <td>October 22, 2020</td>\n",
       "      <td>R</td>\n",
       "      <td>78 min</td>\n",
       "      <td>Comedies, Dramas, Independent Movies</td>\n",
       "      <td>A devoutly religious teen grapples with her ow...</td>\n",
       "      <td>2020-10-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7738</th>\n",
       "      <td>s7737</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Young Adult</td>\n",
       "      <td>Jason Reitman</td>\n",
       "      <td>Charlize Theron, Patton Oswalt, Patrick Wilson...</td>\n",
       "      <td>United States</td>\n",
       "      <td>November 20, 2019</td>\n",
       "      <td>R</td>\n",
       "      <td>94 min</td>\n",
       "      <td>Comedies, Dramas, Independent Movies</td>\n",
       "      <td>When a divorced writer gets a letter from an o...</td>\n",
       "      <td>2019-11-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7760</th>\n",
       "      <td>s7759</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Zack and Miri Make a Porno</td>\n",
       "      <td>Kevin Smith</td>\n",
       "      <td>Seth Rogen, Elizabeth Banks, Craig Robinson, J...</td>\n",
       "      <td>United States</td>\n",
       "      <td>October 1, 2018</td>\n",
       "      <td>R</td>\n",
       "      <td>101 min</td>\n",
       "      <td>Comedies, Independent Movies, Romantic Movies</td>\n",
       "      <td>Zack and Miri make and star in an adult film t...</td>\n",
       "      <td>2018-10-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7776</th>\n",
       "      <td>s7775</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Zodiac</td>\n",
       "      <td>David Fincher</td>\n",
       "      <td>Mark Ruffalo, Jake Gyllenhaal, Robert Downey J...</td>\n",
       "      <td>United States</td>\n",
       "      <td>November 20, 2019</td>\n",
       "      <td>R</td>\n",
       "      <td>158 min</td>\n",
       "      <td>Cult Movies, Dramas, Thrillers</td>\n",
       "      <td>A political cartoonist, a crime reporter and a...</td>\n",
       "      <td>2019-11-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7780</th>\n",
       "      <td>s7779</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Zombieland</td>\n",
       "      <td>Ruben Fleischer</td>\n",
       "      <td>Jesse Eisenberg, Woody Harrelson, Emma Stone, ...</td>\n",
       "      <td>United States</td>\n",
       "      <td>November 1, 2019</td>\n",
       "      <td>R</td>\n",
       "      <td>88 min</td>\n",
       "      <td>Comedies, Horror Movies</td>\n",
       "      <td>Looking to survive in a world taken over by zo...</td>\n",
       "      <td>2019-11-01</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>580 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Show_Id Category                       Title         Director  \\\n",
       "2         s3    Movie                       23:59     Gilbert Chan   \n",
       "7         s8    Movie                         187   Kevin Reynolds   \n",
       "14       s15    Movie                        3022       John Suits   \n",
       "17       s18    Movie                      22-Jul  Paul Greengrass   \n",
       "65       s66    Movie                     13 Sins     Daniel Stamm   \n",
       "...      ...      ...                         ...              ...   \n",
       "7712   s7711    Movie               Yes, God, Yes      Karen Maine   \n",
       "7738   s7737    Movie                 Young Adult    Jason Reitman   \n",
       "7760   s7759    Movie  Zack and Miri Make a Porno      Kevin Smith   \n",
       "7776   s7775    Movie                      Zodiac    David Fincher   \n",
       "7780   s7779    Movie                  Zombieland  Ruben Fleischer   \n",
       "\n",
       "                                                   Cast  \\\n",
       "2     Tedd Chan, Stella Chung, Henley Hii, Lawrence ...   \n",
       "7     Samuel L. Jackson, John Heard, Kelly Rowan, Cl...   \n",
       "14    Omar Epps, Kate Walsh, Miranda Cosgrove, Angus...   \n",
       "17    Anders Danielsen Lie, Jon Øigarden, Jonas Stra...   \n",
       "65    Mark Webber, Rutina Wesley, Devon Graye, Tom B...   \n",
       "...                                                 ...   \n",
       "7712  Natalia Dyer, Timothy Simons, Wolfgang Novogra...   \n",
       "7738  Charlize Theron, Patton Oswalt, Patrick Wilson...   \n",
       "7760  Seth Rogen, Elizabeth Banks, Craig Robinson, J...   \n",
       "7776  Mark Ruffalo, Jake Gyllenhaal, Robert Downey J...   \n",
       "7780  Jesse Eisenberg, Woody Harrelson, Emma Stone, ...   \n",
       "\n",
       "                             Country       Release_Date Rating Duration  \\\n",
       "2                          Singapore  December 20, 2018      R   78 min   \n",
       "7                      United States   November 1, 2019      R  119 min   \n",
       "14                     United States     March 19, 2020      R   91 min   \n",
       "17    Norway, Iceland, United States   October 10, 2018      R  144 min   \n",
       "65                     United States   January 13, 2019      R   93 min   \n",
       "...                              ...                ...    ...      ...   \n",
       "7712                   United States   October 22, 2020      R   78 min   \n",
       "7738                   United States  November 20, 2019      R   94 min   \n",
       "7760                   United States    October 1, 2018      R  101 min   \n",
       "7776                   United States  November 20, 2019      R  158 min   \n",
       "7780                   United States   November 1, 2019      R   88 min   \n",
       "\n",
       "                                                 Type  \\\n",
       "2                 Horror Movies, International Movies   \n",
       "7                                              Dramas   \n",
       "14    Independent Movies, Sci-Fi & Fantasy, Thrillers   \n",
       "17                                  Dramas, Thrillers   \n",
       "65                           Horror Movies, Thrillers   \n",
       "...                                               ...   \n",
       "7712             Comedies, Dramas, Independent Movies   \n",
       "7738             Comedies, Dramas, Independent Movies   \n",
       "7760    Comedies, Independent Movies, Romantic Movies   \n",
       "7776                   Cult Movies, Dramas, Thrillers   \n",
       "7780                          Comedies, Horror Movies   \n",
       "\n",
       "                                            Description     Date_N  \n",
       "2     When an army recruit is found dead, his fellow... 2018-12-20  \n",
       "7     After one of his high school students attacks ... 2019-11-01  \n",
       "14    Stranded when the Earth is suddenly destroyed ... 2020-03-19  \n",
       "17    After devastating terror attacks in Norway, a ... 2018-10-10  \n",
       "65    A man agrees to appear on a game show with a $... 2019-01-13  \n",
       "...                                                 ...        ...  \n",
       "7712  A devoutly religious teen grapples with her ow... 2020-10-22  \n",
       "7738  When a divorced writer gets a letter from an o... 2019-11-20  \n",
       "7760  Zack and Miri make and star in an adult film t... 2018-10-01  \n",
       "7776  A political cartoonist, a crime reporter and a... 2019-11-20  \n",
       "7780  Looking to survive in a world taken over by zo... 2019-11-01  \n",
       "\n",
       "[580 rows x 12 columns]"
      ]
     },
     "execution_count": 106,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[(data[\"Rating\"]==\"R\")&(data[\"Date_N\"]>\"2018\")]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d0512e24",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}