EDA, Netflix Data Analysis using python.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {
    "id": "XBto1iw5XphZ"
   },
   "source": [
    "## Data Description\n",
    "\n",
    "This dataset consists of tv shows and movies available on Netflix as of 2019. The dataset is collected from Flixable which is a third-party Netflix search engine.\n",
    "\n",
    "See Kaggle page for more info: https://www.kaggle.com/shivamb/netflix-shows\n",
    "\n",
    "\n",
    "Load this data into `pandas` and use `index_col='show_id'`\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {
    "id": "0qQ0Yui-KX_e"
   },
   "outputs": [],
   "source": [
    "# Write code to load data below\n",
    "import pandas as pd\n",
    "import seaborn as sns\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {
    "id": "U1L4rRY9Ypuw"
   },
   "outputs": [],
   "source": [
    "file_path = \"/Users/mo/Desktop/Desktop/Work/Github/Data_Science/Data/netflix_titles.csv\"\n",
    "netflix = pd.read_csv(file_path)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/"
    },
    "id": "dxHH5SItYzoA",
    "outputId": "e3f1e653-c82c-4929-94bb-0679fa4e67b0"
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {
    "id": "tQOpHMmZZpCg"
   },
   "outputs": [],
   "source": [
    "index_col ='show_id'\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "id": "R0rq7c8vPTr1"
   },
   "source": [
    "## Section 1: Dataset Overview\n",
    "\n",
    "Let's get an initial understanding of the data we are working with. Provide answers and code below.\n",
    "\n",
    "1.  How many rows and columns are in this dataset?\n",
    "2.  Provide a list of the columns\n",
    "3.  Print the **first 10 rows** of this dataset\n",
    "4.  Use `.info()` to understand where there may be null values in the data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/"
    },
    "id": "S_piilRyQBkN",
    "outputId": "fb7d62b8-27d3-4033-f51b-3960b61b36a0"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(6234, 12)"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Write code below\n",
    "#1\n",
    "netflix.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/"
    },
    "id": "MzQljVULaHxx",
    "outputId": "128d7fd0-b5cb-4c04-f23f-2d7e364a1ace"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['show_id', 'type', 'title', 'director', 'cast', 'country', 'date_added',\n",
       "       'release_year', 'rating', 'duration', 'listed_in', 'description'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#2\n",
    "netflix.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 517
    },
    "id": "oomcaGQIarrP",
    "outputId": "8fed0612-27d2-4f28-e6c6-864d887a56b2"
   },
   "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>type</th>\n",
       "      <th>title</th>\n",
       "      <th>director</th>\n",
       "      <th>cast</th>\n",
       "      <th>country</th>\n",
       "      <th>date_added</th>\n",
       "      <th>release_year</th>\n",
       "      <th>rating</th>\n",
       "      <th>duration</th>\n",
       "      <th>listed_in</th>\n",
       "      <th>description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>81145628</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Norm of the North: King Sized Adventure</td>\n",
       "      <td>Richard Finn, Tim Maltby</td>\n",
       "      <td>Alan Marriott, Andrew Toth, Brian Dobson, Cole...</td>\n",
       "      <td>United States, India, South Korea, China</td>\n",
       "      <td>September 9, 2019</td>\n",
       "      <td>2019</td>\n",
       "      <td>TV-PG</td>\n",
       "      <td>90 min</td>\n",
       "      <td>Children &amp; Family Movies, Comedies</td>\n",
       "      <td>Before planning an awesome wedding for his gra...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>80117401</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Jandino: Whatever it Takes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Jandino Asporaat</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>September 9, 2016</td>\n",
       "      <td>2016</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>94 min</td>\n",
       "      <td>Stand-Up Comedy</td>\n",
       "      <td>Jandino Asporaat riffs on the challenges of ra...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>70234439</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Transformers Prime</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Peter Cullen, Sumalee Montano, Frank Welker, J...</td>\n",
       "      <td>United States</td>\n",
       "      <td>September 8, 2018</td>\n",
       "      <td>2013</td>\n",
       "      <td>TV-Y7-FV</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>Kids' TV</td>\n",
       "      <td>With the help of three human allies, the Autob...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>80058654</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Transformers: Robots in Disguise</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Will Friedle, Darren Criss, Constance Zimmer, ...</td>\n",
       "      <td>United States</td>\n",
       "      <td>September 8, 2018</td>\n",
       "      <td>2016</td>\n",
       "      <td>TV-Y7</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>Kids' TV</td>\n",
       "      <td>When a prison ship crash unleashes hundreds of...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>80125979</td>\n",
       "      <td>Movie</td>\n",
       "      <td>#realityhigh</td>\n",
       "      <td>Fernando Lebrija</td>\n",
       "      <td>Nesta Cooper, Kate Walsh, John Michael Higgins...</td>\n",
       "      <td>United States</td>\n",
       "      <td>September 8, 2017</td>\n",
       "      <td>2017</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>99 min</td>\n",
       "      <td>Comedies</td>\n",
       "      <td>When nerdy high schooler Dani finally attracts...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>80163890</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Apaches</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Alberto Ammann, Eloy Azorín, Verónica Echegui,...</td>\n",
       "      <td>Spain</td>\n",
       "      <td>September 8, 2017</td>\n",
       "      <td>2016</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>Crime TV Shows, International TV Shows, Spanis...</td>\n",
       "      <td>A young journalist is forced into a life of cr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>70304989</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Automata</td>\n",
       "      <td>Gabe Ibáñez</td>\n",
       "      <td>Antonio Banderas, Dylan McDermott, Melanie Gri...</td>\n",
       "      <td>Bulgaria, United States, Spain, Canada</td>\n",
       "      <td>September 8, 2017</td>\n",
       "      <td>2014</td>\n",
       "      <td>R</td>\n",
       "      <td>110 min</td>\n",
       "      <td>International Movies, Sci-Fi &amp; Fantasy, Thrillers</td>\n",
       "      <td>In a dystopian future, an insurance adjuster f...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>80164077</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Fabrizio Copano: Solo pienso en mi</td>\n",
       "      <td>Rodrigo Toro, Francisco Schultz</td>\n",
       "      <td>Fabrizio Copano</td>\n",
       "      <td>Chile</td>\n",
       "      <td>September 8, 2017</td>\n",
       "      <td>2017</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>60 min</td>\n",
       "      <td>Stand-Up Comedy</td>\n",
       "      <td>Fabrizio Copano takes audience participation t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>80117902</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Fire Chasers</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States</td>\n",
       "      <td>September 8, 2017</td>\n",
       "      <td>2017</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>Docuseries, Science &amp; Nature TV</td>\n",
       "      <td>As California's 2016 fire season rages, brave ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>70304990</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Good People</td>\n",
       "      <td>Henrik Ruben Genz</td>\n",
       "      <td>James Franco, Kate Hudson, Tom Wilkinson, Omar...</td>\n",
       "      <td>United States, United Kingdom, Denmark, Sweden</td>\n",
       "      <td>September 8, 2017</td>\n",
       "      <td>2014</td>\n",
       "      <td>R</td>\n",
       "      <td>90 min</td>\n",
       "      <td>Action &amp; Adventure, Thrillers</td>\n",
       "      <td>A struggling couple can't believe their luck w...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    show_id     type                                    title  \\\n",
       "0  81145628    Movie  Norm of the North: King Sized Adventure   \n",
       "1  80117401    Movie               Jandino: Whatever it Takes   \n",
       "2  70234439  TV Show                       Transformers Prime   \n",
       "3  80058654  TV Show         Transformers: Robots in Disguise   \n",
       "4  80125979    Movie                             #realityhigh   \n",
       "5  80163890  TV Show                                  Apaches   \n",
       "6  70304989    Movie                                 Automata   \n",
       "7  80164077    Movie       Fabrizio Copano: Solo pienso en mi   \n",
       "8  80117902  TV Show                             Fire Chasers   \n",
       "9  70304990    Movie                              Good People   \n",
       "\n",
       "                          director  \\\n",
       "0         Richard Finn, Tim Maltby   \n",
       "1                              NaN   \n",
       "2                              NaN   \n",
       "3                              NaN   \n",
       "4                 Fernando Lebrija   \n",
       "5                              NaN   \n",
       "6                      Gabe Ibáñez   \n",
       "7  Rodrigo Toro, Francisco Schultz   \n",
       "8                              NaN   \n",
       "9                Henrik Ruben Genz   \n",
       "\n",
       "                                                cast  \\\n",
       "0  Alan Marriott, Andrew Toth, Brian Dobson, Cole...   \n",
       "1                                   Jandino Asporaat   \n",
       "2  Peter Cullen, Sumalee Montano, Frank Welker, J...   \n",
       "3  Will Friedle, Darren Criss, Constance Zimmer, ...   \n",
       "4  Nesta Cooper, Kate Walsh, John Michael Higgins...   \n",
       "5  Alberto Ammann, Eloy Azorín, Verónica Echegui,...   \n",
       "6  Antonio Banderas, Dylan McDermott, Melanie Gri...   \n",
       "7                                    Fabrizio Copano   \n",
       "8                                                NaN   \n",
       "9  James Franco, Kate Hudson, Tom Wilkinson, Omar...   \n",
       "\n",
       "                                          country         date_added  \\\n",
       "0        United States, India, South Korea, China  September 9, 2019   \n",
       "1                                  United Kingdom  September 9, 2016   \n",
       "2                                   United States  September 8, 2018   \n",
       "3                                   United States  September 8, 2018   \n",
       "4                                   United States  September 8, 2017   \n",
       "5                                           Spain  September 8, 2017   \n",
       "6          Bulgaria, United States, Spain, Canada  September 8, 2017   \n",
       "7                                           Chile  September 8, 2017   \n",
       "8                                   United States  September 8, 2017   \n",
       "9  United States, United Kingdom, Denmark, Sweden  September 8, 2017   \n",
       "\n",
       "   release_year    rating  duration  \\\n",
       "0          2019     TV-PG    90 min   \n",
       "1          2016     TV-MA    94 min   \n",
       "2          2013  TV-Y7-FV  1 Season   \n",
       "3          2016     TV-Y7  1 Season   \n",
       "4          2017     TV-14    99 min   \n",
       "5          2016     TV-MA  1 Season   \n",
       "6          2014         R   110 min   \n",
       "7          2017     TV-MA    60 min   \n",
       "8          2017     TV-MA  1 Season   \n",
       "9          2014         R    90 min   \n",
       "\n",
       "                                           listed_in  \\\n",
       "0                 Children & Family Movies, Comedies   \n",
       "1                                    Stand-Up Comedy   \n",
       "2                                           Kids' TV   \n",
       "3                                           Kids' TV   \n",
       "4                                           Comedies   \n",
       "5  Crime TV Shows, International TV Shows, Spanis...   \n",
       "6  International Movies, Sci-Fi & Fantasy, Thrillers   \n",
       "7                                    Stand-Up Comedy   \n",
       "8                    Docuseries, Science & Nature TV   \n",
       "9                      Action & Adventure, Thrillers   \n",
       "\n",
       "                                         description  \n",
       "0  Before planning an awesome wedding for his gra...  \n",
       "1  Jandino Asporaat riffs on the challenges of ra...  \n",
       "2  With the help of three human allies, the Autob...  \n",
       "3  When a prison ship crash unleashes hundreds of...  \n",
       "4  When nerdy high schooler Dani finally attracts...  \n",
       "5  A young journalist is forced into a life of cr...  \n",
       "6  In a dystopian future, an insurance adjuster f...  \n",
       "7  Fabrizio Copano takes audience participation t...  \n",
       "8  As California's 2016 fire season rages, brave ...  \n",
       "9  A struggling couple can't believe their luck w...  "
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#3\n",
    "netflix.head(n=10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/"
    },
    "id": "uAf6jZPKa4aB",
    "outputId": "74940e86-735a-4c0c-afa9-6afc4c8b9dec"
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 6234 entries, 0 to 6233\n",
      "Data columns (total 12 columns):\n",
      " #   Column        Non-Null Count  Dtype \n",
      "---  ------        --------------  ----- \n",
      " 0   show_id       6234 non-null   int64 \n",
      " 1   type          6234 non-null   object\n",
      " 2   title         6234 non-null   object\n",
      " 3   director      4265 non-null   object\n",
      " 4   cast          5664 non-null   object\n",
      " 5   country       5758 non-null   object\n",
      " 6   date_added    6223 non-null   object\n",
      " 7   release_year  6234 non-null   int64 \n",
      " 8   rating        6224 non-null   object\n",
      " 9   duration      6234 non-null   object\n",
      " 10  listed_in     6234 non-null   object\n",
      " 11  description   6234 non-null   object\n",
      "dtypes: int64(2), object(10)\n",
      "memory usage: 584.6+ KB\n"
     ]
    }
   ],
   "source": [
    "#4\n",
    "netflix.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "id": "1KHOUpc8KURA"
   },
   "source": [
    "## Section 2:  Data Cleaning\n",
    "\n",
    "Let's take some steps to improve the data set for analysis purposes.\n",
    "\n",
    "\n",
    "1.   There are NA/NaN values in `director`, `cast`, and `country`.  Let's replace these with the value `\"Unknown\"`\n",
    "2.   Create a new column `is_available_in_usa` which is True if `country` contains the word `United States` and False otherwise.  (Hint: Sometimes `country` contains multiple countries separated by commas.  We want to be able to catch `United States` if it's in this list also.\n",
    "\n",
    "Make a new column called `duration_bucket`.  This column will bucket the values found in `duration`, similar to how we grouped values in HW1.  Examples of buckets might be `61-90 minutes`, `91-120 minutes`, `120+ minutes`, or `3+ seasons`.  To do this, I recommend creating a function that converts the value in `duration` to the `bucket_name`, then using the `pandas` `.apply()` function to the `duration` column to create a transformed column, which you can then insert into the dataframe.\n",
    "\n",
    "Reference: https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.Series.apply.html"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {
    "id": "fKxlceaKcEbP"
   },
   "outputs": [],
   "source": [
    "#1 \n",
    "# to replace all nan with Unknown\n",
    "netflix['director'].fillna('Unknown', inplace =True)\n",
    "netflix['cast'].fillna('Unknown', inplace =True)\n",
    "netflix['country'].fillna('Unknown', inplace =True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 411
    },
    "id": "rfPeoCMHpkYA",
    "outputId": "3c4012c6-ef88-4bb1-99ae-c5a0a2badaa3"
   },
   "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>country</th>\n",
       "      <th>cast</th>\n",
       "      <th>country</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>United States, India, South Korea, China</td>\n",
       "      <td>Alan Marriott, Andrew Toth, Brian Dobson, Cole...</td>\n",
       "      <td>United States, India, South Korea, China</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>Jandino Asporaat</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>United States</td>\n",
       "      <td>Peter Cullen, Sumalee Montano, Frank Welker, J...</td>\n",
       "      <td>United States</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>United States</td>\n",
       "      <td>Will Friedle, Darren Criss, Constance Zimmer, ...</td>\n",
       "      <td>United States</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>United States</td>\n",
       "      <td>Nesta Cooper, Kate Walsh, John Michael Higgins...</td>\n",
       "      <td>United States</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6229</th>\n",
       "      <td>United States</td>\n",
       "      <td>Burnie Burns, Jason Saldaña, Gustavo Sorola, G...</td>\n",
       "      <td>United States</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6230</th>\n",
       "      <td>United States</td>\n",
       "      <td>Marc Maron, Judd Hirsch, Josh Brener, Nora Zeh...</td>\n",
       "      <td>United States</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6231</th>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6232</th>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>Daniel Radcliffe, Jon Hamm, Adam Godley, Chris...</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6233</th>\n",
       "      <td>United States</td>\n",
       "      <td>Jennifer Aniston, Courteney Cox, Lisa Kudrow, ...</td>\n",
       "      <td>United States</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>6234 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       country  \\\n",
       "0     United States, India, South Korea, China   \n",
       "1                               United Kingdom   \n",
       "2                                United States   \n",
       "3                                United States   \n",
       "4                                United States   \n",
       "...                                        ...   \n",
       "6229                             United States   \n",
       "6230                             United States   \n",
       "6231                                   Unknown   \n",
       "6232                            United Kingdom   \n",
       "6233                             United States   \n",
       "\n",
       "                                                   cast  \\\n",
       "0     Alan Marriott, Andrew Toth, Brian Dobson, Cole...   \n",
       "1                                      Jandino Asporaat   \n",
       "2     Peter Cullen, Sumalee Montano, Frank Welker, J...   \n",
       "3     Will Friedle, Darren Criss, Constance Zimmer, ...   \n",
       "4     Nesta Cooper, Kate Walsh, John Michael Higgins...   \n",
       "...                                                 ...   \n",
       "6229  Burnie Burns, Jason Saldaña, Gustavo Sorola, G...   \n",
       "6230  Marc Maron, Judd Hirsch, Josh Brener, Nora Zeh...   \n",
       "6231                                            Unknown   \n",
       "6232  Daniel Radcliffe, Jon Hamm, Adam Godley, Chris...   \n",
       "6233  Jennifer Aniston, Courteney Cox, Lisa Kudrow, ...   \n",
       "\n",
       "                                       country  \n",
       "0     United States, India, South Korea, China  \n",
       "1                               United Kingdom  \n",
       "2                                United States  \n",
       "3                                United States  \n",
       "4                                United States  \n",
       "...                                        ...  \n",
       "6229                             United States  \n",
       "6230                             United States  \n",
       "6231                                   Unknown  \n",
       "6232                            United Kingdom  \n",
       "6233                             United States  \n",
       "\n",
       "[6234 rows x 3 columns]"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# to check if \"nan\" is replaced with \"Unknown\"\n",
    "netflix.loc[:,['country','cast', 'country']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {
    "id": "DPUHIRF_tda8"
   },
   "outputs": [],
   "source": [
    "#2\n",
    "# look for united states using str and contains \n",
    "is_available_in_usa = netflix.loc[:, 'country'].str.contains('United States')\n",
    "is_available_in_usa\n",
    "\n",
    "# insert new colmun next to countries in index 6 show that index 5 is True\n",
    "netflix.insert(6, \"available_in_usa\", is_available_in_usa)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 592
    },
    "id": "uB7y_zX1yO10",
    "outputId": "a8a76e2d-03c6-40e5-baf5-840749a6b083"
   },
   "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>type</th>\n",
       "      <th>title</th>\n",
       "      <th>director</th>\n",
       "      <th>cast</th>\n",
       "      <th>country</th>\n",
       "      <th>available_in_usa</th>\n",
       "      <th>date_added</th>\n",
       "      <th>release_year</th>\n",
       "      <th>rating</th>\n",
       "      <th>duration</th>\n",
       "      <th>listed_in</th>\n",
       "      <th>description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>81145628</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Norm of the North: King Sized Adventure</td>\n",
       "      <td>Richard Finn, Tim Maltby</td>\n",
       "      <td>Alan Marriott, Andrew Toth, Brian Dobson, Cole...</td>\n",
       "      <td>United States, India, South Korea, China</td>\n",
       "      <td>True</td>\n",
       "      <td>September 9, 2019</td>\n",
       "      <td>2019</td>\n",
       "      <td>TV-PG</td>\n",
       "      <td>90 min</td>\n",
       "      <td>Children &amp; Family Movies, Comedies</td>\n",
       "      <td>Before planning an awesome wedding for his gra...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>80117401</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Jandino: Whatever it Takes</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Jandino Asporaat</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>False</td>\n",
       "      <td>September 9, 2016</td>\n",
       "      <td>2016</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>94 min</td>\n",
       "      <td>Stand-Up Comedy</td>\n",
       "      <td>Jandino Asporaat riffs on the challenges of ra...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>70234439</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Transformers Prime</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Peter Cullen, Sumalee Montano, Frank Welker, J...</td>\n",
       "      <td>United States</td>\n",
       "      <td>True</td>\n",
       "      <td>September 8, 2018</td>\n",
       "      <td>2013</td>\n",
       "      <td>TV-Y7-FV</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>Kids' TV</td>\n",
       "      <td>With the help of three human allies, the Autob...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>80058654</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Transformers: Robots in Disguise</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Will Friedle, Darren Criss, Constance Zimmer, ...</td>\n",
       "      <td>United States</td>\n",
       "      <td>True</td>\n",
       "      <td>September 8, 2018</td>\n",
       "      <td>2016</td>\n",
       "      <td>TV-Y7</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>Kids' TV</td>\n",
       "      <td>When a prison ship crash unleashes hundreds of...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>80125979</td>\n",
       "      <td>Movie</td>\n",
       "      <td>#realityhigh</td>\n",
       "      <td>Fernando Lebrija</td>\n",
       "      <td>Nesta Cooper, Kate Walsh, John Michael Higgins...</td>\n",
       "      <td>United States</td>\n",
       "      <td>True</td>\n",
       "      <td>September 8, 2017</td>\n",
       "      <td>2017</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>99 min</td>\n",
       "      <td>Comedies</td>\n",
       "      <td>When nerdy high schooler Dani finally attracts...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6229</th>\n",
       "      <td>80000063</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Red vs. Blue</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Burnie Burns, Jason Saldaña, Gustavo Sorola, G...</td>\n",
       "      <td>United States</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015</td>\n",
       "      <td>NR</td>\n",
       "      <td>13 Seasons</td>\n",
       "      <td>TV Action &amp; Adventure, TV Comedies, TV Sci-Fi ...</td>\n",
       "      <td>This parody of first-person shooter games, mil...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6230</th>\n",
       "      <td>70286564</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Maron</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Marc Maron, Judd Hirsch, Josh Brener, Nora Zeh...</td>\n",
       "      <td>United States</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>4 Seasons</td>\n",
       "      <td>TV Comedies</td>\n",
       "      <td>Marc Maron stars as Marc Maron, who interviews...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6231</th>\n",
       "      <td>80116008</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Little Baby Bum: Nursery Rhyme Friends</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016</td>\n",
       "      <td>NaN</td>\n",
       "      <td>60 min</td>\n",
       "      <td>Movies</td>\n",
       "      <td>Nursery rhymes and original music for children...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6232</th>\n",
       "      <td>70281022</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>A Young Doctor's Notebook and Other Stories</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Daniel Radcliffe, Jon Hamm, Adam Godley, Chris...</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2013</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>2 Seasons</td>\n",
       "      <td>British TV Shows, TV Comedies, TV Dramas</td>\n",
       "      <td>Set during the Russian Revolution, this comic ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6233</th>\n",
       "      <td>70153404</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Friends</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Jennifer Aniston, Courteney Cox, Lisa Kudrow, ...</td>\n",
       "      <td>United States</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2003</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>10 Seasons</td>\n",
       "      <td>Classic &amp; Cult TV, TV Comedies</td>\n",
       "      <td>This hit sitcom follows the merry misadventure...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>6234 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       show_id     type                                        title  \\\n",
       "0     81145628    Movie      Norm of the North: King Sized Adventure   \n",
       "1     80117401    Movie                   Jandino: Whatever it Takes   \n",
       "2     70234439  TV Show                           Transformers Prime   \n",
       "3     80058654  TV Show             Transformers: Robots in Disguise   \n",
       "4     80125979    Movie                                 #realityhigh   \n",
       "...        ...      ...                                          ...   \n",
       "6229  80000063  TV Show                                 Red vs. Blue   \n",
       "6230  70286564  TV Show                                        Maron   \n",
       "6231  80116008    Movie       Little Baby Bum: Nursery Rhyme Friends   \n",
       "6232  70281022  TV Show  A Young Doctor's Notebook and Other Stories   \n",
       "6233  70153404  TV Show                                      Friends   \n",
       "\n",
       "                      director  \\\n",
       "0     Richard Finn, Tim Maltby   \n",
       "1                      Unknown   \n",
       "2                      Unknown   \n",
       "3                      Unknown   \n",
       "4             Fernando Lebrija   \n",
       "...                        ...   \n",
       "6229                   Unknown   \n",
       "6230                   Unknown   \n",
       "6231                   Unknown   \n",
       "6232                   Unknown   \n",
       "6233                   Unknown   \n",
       "\n",
       "                                                   cast  \\\n",
       "0     Alan Marriott, Andrew Toth, Brian Dobson, Cole...   \n",
       "1                                      Jandino Asporaat   \n",
       "2     Peter Cullen, Sumalee Montano, Frank Welker, J...   \n",
       "3     Will Friedle, Darren Criss, Constance Zimmer, ...   \n",
       "4     Nesta Cooper, Kate Walsh, John Michael Higgins...   \n",
       "...                                                 ...   \n",
       "6229  Burnie Burns, Jason Saldaña, Gustavo Sorola, G...   \n",
       "6230  Marc Maron, Judd Hirsch, Josh Brener, Nora Zeh...   \n",
       "6231                                            Unknown   \n",
       "6232  Daniel Radcliffe, Jon Hamm, Adam Godley, Chris...   \n",
       "6233  Jennifer Aniston, Courteney Cox, Lisa Kudrow, ...   \n",
       "\n",
       "                                       country  available_in_usa  \\\n",
       "0     United States, India, South Korea, China              True   \n",
       "1                               United Kingdom             False   \n",
       "2                                United States              True   \n",
       "3                                United States              True   \n",
       "4                                United States              True   \n",
       "...                                        ...               ...   \n",
       "6229                             United States              True   \n",
       "6230                             United States              True   \n",
       "6231                                   Unknown             False   \n",
       "6232                            United Kingdom             False   \n",
       "6233                             United States              True   \n",
       "\n",
       "             date_added  release_year    rating    duration  \\\n",
       "0     September 9, 2019          2019     TV-PG      90 min   \n",
       "1     September 9, 2016          2016     TV-MA      94 min   \n",
       "2     September 8, 2018          2013  TV-Y7-FV    1 Season   \n",
       "3     September 8, 2018          2016     TV-Y7    1 Season   \n",
       "4     September 8, 2017          2017     TV-14      99 min   \n",
       "...                 ...           ...       ...         ...   \n",
       "6229                NaN          2015        NR  13 Seasons   \n",
       "6230                NaN          2016     TV-MA   4 Seasons   \n",
       "6231                NaN          2016       NaN      60 min   \n",
       "6232                NaN          2013     TV-MA   2 Seasons   \n",
       "6233                NaN          2003     TV-14  10 Seasons   \n",
       "\n",
       "                                              listed_in  \\\n",
       "0                    Children & Family Movies, Comedies   \n",
       "1                                       Stand-Up Comedy   \n",
       "2                                              Kids' TV   \n",
       "3                                              Kids' TV   \n",
       "4                                              Comedies   \n",
       "...                                                 ...   \n",
       "6229  TV Action & Adventure, TV Comedies, TV Sci-Fi ...   \n",
       "6230                                        TV Comedies   \n",
       "6231                                             Movies   \n",
       "6232           British TV Shows, TV Comedies, TV Dramas   \n",
       "6233                     Classic & Cult TV, TV Comedies   \n",
       "\n",
       "                                            description  \n",
       "0     Before planning an awesome wedding for his gra...  \n",
       "1     Jandino Asporaat riffs on the challenges of ra...  \n",
       "2     With the help of three human allies, the Autob...  \n",
       "3     When a prison ship crash unleashes hundreds of...  \n",
       "4     When nerdy high schooler Dani finally attracts...  \n",
       "...                                                 ...  \n",
       "6229  This parody of first-person shooter games, mil...  \n",
       "6230  Marc Maron stars as Marc Maron, who interviews...  \n",
       "6231  Nursery rhymes and original music for children...  \n",
       "6232  Set during the Russian Revolution, this comic ...  \n",
       "6233  This hit sitcom follows the merry misadventure...  \n",
       "\n",
       "[6234 rows x 13 columns]"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# print to see new column added\n",
    "netflix"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "id": "jmV9J2N-xjAW"
   },
   "source": [
    "## Section 3: Data Questions\n",
    "\n",
    "Explore the data set to answer the questions below.  In addition to providing the answer, please provide the code you used to answer each question.\n",
    "\n",
    "1.   What % of Netflix content is available in the USA?  You can calculate the numerator and denominator separately.  (Hint: Use the new column you created in Section 1)\n",
    "2.   List all the **movies** directed by **M. Night Shyamalan** that are available on Netflix.\n",
    "3.   Which **Japanese** **TV Shows** released in **2006** are available on Netflix?\n",
    "4.   How many **movies** and how many **TV shows** (reported separately) did Netflix add in the **month of July 2019**?\n",
    "5.   List the Netflix content (movies/TV shows) about the FBI (`description` contains \"FBI\") chronologically by release year (most recent first)\n",
    "\n",
    "\n",
    "What % of content on Netflix is added in the same year as it is released? Does this differ by movie vs TV show?\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/"
    },
    "id": "waBZlXwXOwOE",
    "outputId": "59c135f4-8f0f-45cf-ef8b-50b9f29d2049"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "False    58.13282\n",
       "True     41.86718\n",
       "Name: available_in_usa, dtype: float64"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#1\n",
    "# used value_counts to get false and true values, then divided it with of the total available_in_usa, then multiply with 100\n",
    "usa_percentages = (netflix.available_in_usa.value_counts() / netflix.available_in_usa.count() ) * 100\n",
    "usa_percentages"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/"
    },
    "id": "jq_aK_AY-pIZ",
    "outputId": "e0de5a82-d4f5-44ae-dab7-ef2459aad793"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "False    6233\n",
       "True        1\n",
       "Name: director, dtype: int64"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#2 to create a condition statement for director \"M. Night Shyamalan\"\n",
    "is_director = netflix.loc[:, 'director'].str.contains('M. Night Shyamalan')\n",
    "is_director.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 95
    },
    "id": "qPgNFzKVB3F7",
    "outputId": "06279e4d-6f7e-49a6-c243-126b7b7b5a53"
   },
   "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>type</th>\n",
       "      <th>title</th>\n",
       "      <th>director</th>\n",
       "      <th>cast</th>\n",
       "      <th>country</th>\n",
       "      <th>available_in_usa</th>\n",
       "      <th>date_added</th>\n",
       "      <th>release_year</th>\n",
       "      <th>rating</th>\n",
       "      <th>duration</th>\n",
       "      <th>listed_in</th>\n",
       "      <th>description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3040</th>\n",
       "      <td>70044688</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Lady in the Water</td>\n",
       "      <td>M. Night Shyamalan</td>\n",
       "      <td>Paul Giamatti, Bryce Dallas Howard, Jeffrey Wr...</td>\n",
       "      <td>United States</td>\n",
       "      <td>True</td>\n",
       "      <td>July 1, 2019</td>\n",
       "      <td>2006</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>110 min</td>\n",
       "      <td>Sci-Fi &amp; Fantasy, Thrillers</td>\n",
       "      <td>When an apartment building manager discovers a...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       show_id   type              title            director  \\\n",
       "3040  70044688  Movie  Lady in the Water  M. Night Shyamalan   \n",
       "\n",
       "                                                   cast        country  \\\n",
       "3040  Paul Giamatti, Bryce Dallas Howard, Jeffrey Wr...  United States   \n",
       "\n",
       "      available_in_usa    date_added  release_year rating duration  \\\n",
       "3040              True  July 1, 2019          2006  PG-13  110 min   \n",
       "\n",
       "                        listed_in  \\\n",
       "3040  Sci-Fi & Fantasy, Thrillers   \n",
       "\n",
       "                                            description  \n",
       "3040  When an apartment building manager discovers a...  "
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# print the condition statement of only true variable\n",
    "netflix[is_director].head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 189
    },
    "id": "K19jayy6BhXz",
    "outputId": "9b6b2f27-d94f-4310-a3c7-89362dc8009b"
   },
   "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>type</th>\n",
       "      <th>title</th>\n",
       "      <th>director</th>\n",
       "      <th>cast</th>\n",
       "      <th>country</th>\n",
       "      <th>available_in_usa</th>\n",
       "      <th>date_added</th>\n",
       "      <th>release_year</th>\n",
       "      <th>rating</th>\n",
       "      <th>duration</th>\n",
       "      <th>listed_in</th>\n",
       "      <th>description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>721</th>\n",
       "      <td>70204970</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>DEATH NOTE</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Kappei Yamaguchi, Alessandro Juliani, Mamoru M...</td>\n",
       "      <td>Japan</td>\n",
       "      <td>False</td>\n",
       "      <td>October 15, 2016</td>\n",
       "      <td>2006</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>Anime Series, Crime TV Shows, International TV...</td>\n",
       "      <td>When a Japanese high schooler comes into posse...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5566</th>\n",
       "      <td>70205014</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Ouran High School Host Club</td>\n",
       "      <td>Takuya Igarashi</td>\n",
       "      <td>Maaya Sakamoto, Monica Rial, Vic Mignogna, Luc...</td>\n",
       "      <td>Japan</td>\n",
       "      <td>False</td>\n",
       "      <td>April 1, 2017</td>\n",
       "      <td>2006</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>Anime Series, Romantic TV Shows, Teen TV Shows</td>\n",
       "      <td>New student Haruhi stumbles on the Ouran High ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5724</th>\n",
       "      <td>70204957</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Bleach</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Masakazu Morita, Fumiko Orikasa, Yuki Matsuoka...</td>\n",
       "      <td>Japan</td>\n",
       "      <td>False</td>\n",
       "      <td>November 3, 2018</td>\n",
       "      <td>2006</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>3 Seasons</td>\n",
       "      <td>Anime Series, International TV Shows</td>\n",
       "      <td>After teenager Ichigo Kurosaki acquires superp...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       show_id     type                        title         director  \\\n",
       "721   70204970  TV Show                   DEATH NOTE          Unknown   \n",
       "5566  70205014  TV Show  Ouran High School Host Club  Takuya Igarashi   \n",
       "5724  70204957  TV Show                       Bleach          Unknown   \n",
       "\n",
       "                                                   cast country  \\\n",
       "721   Kappei Yamaguchi, Alessandro Juliani, Mamoru M...   Japan   \n",
       "5566  Maaya Sakamoto, Monica Rial, Vic Mignogna, Luc...   Japan   \n",
       "5724  Masakazu Morita, Fumiko Orikasa, Yuki Matsuoka...   Japan   \n",
       "\n",
       "      available_in_usa         date_added  release_year rating   duration  \\\n",
       "721              False   October 15, 2016          2006  TV-14   1 Season   \n",
       "5566             False      April 1, 2017          2006  TV-14   1 Season   \n",
       "5724             False   November 3, 2018          2006  TV-14  3 Seasons   \n",
       "\n",
       "                                              listed_in  \\\n",
       "721   Anime Series, Crime TV Shows, International TV...   \n",
       "5566     Anime Series, Romantic TV Shows, Teen TV Shows   \n",
       "5724               Anime Series, International TV Shows   \n",
       "\n",
       "                                            description  \n",
       "721   When a Japanese high schooler comes into posse...  \n",
       "5566  New student Haruhi stumbles on the Ouran High ...  \n",
       "5724  After teenager Ichigo Kurosaki acquires superp...  "
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#3\n",
    "# create 3 variables to use condition statements for results on specify resutls\n",
    "is_jp_movies = netflix.loc[:, 'country'].str.contains('Japan') \n",
    "is_2006 = netflix.loc[:, 'release_year'] == 2006 \n",
    "is_tvshow = netflix.loc[:, 'type'].str.contains(\"TV Show\")\n",
    "#jp_movies.value_counts()\n",
    "\n",
    "netflix[is_jp_movies & is_2006 & is_tvshow]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {
    "id": "HMNw59I5GSGp"
   },
   "outputs": [],
   "source": [
    "#4\n",
    "# create 3 variable to solve two results\n",
    "is_movies = netflix.loc[:, 'type'].str.contains(\"Movie\")\n",
    "is_tvshow = netflix.loc[:, 'type'].str.contains(\"TV Show\")\n",
    "is_jul_19 = netflix.loc[:, 'date_added'].str.contains(\"July\") & netflix.loc[:, 'date_added'].str.contains(\"2019\")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/"
    },
    "id": "EsbmhqHKWxHL",
    "outputId": "106e8668-3a6d-4c5e-89ef-00e0253f66b8"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "False    6048\n",
       "True      186\n",
       "Name: date_added, dtype: int64"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# to show total of movies and TV shows in july 2019 adedd\n",
    "is_jul_19.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {
    "id": "j-vM_x7zJfSY"
   },
   "outputs": [],
   "source": [
    "# create a condition statement variable for movies and tv show sepretaly with july 2019\n",
    "july_movies = netflix[is_jul_19 & is_movies]\n",
    "july_tv_shows = netflix[is_jul_19 & is_tvshow]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 576
    },
    "id": "DdhiiGm1SWu-",
    "outputId": "d7ac47c2-2269-4daf-ab63-e429bafc8dba"
   },
   "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>type</th>\n",
       "      <th>title</th>\n",
       "      <th>director</th>\n",
       "      <th>cast</th>\n",
       "      <th>country</th>\n",
       "      <th>available_in_usa</th>\n",
       "      <th>date_added</th>\n",
       "      <th>release_year</th>\n",
       "      <th>rating</th>\n",
       "      <th>duration</th>\n",
       "      <th>listed_in</th>\n",
       "      <th>description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2769</th>\n",
       "      <td>81088333</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Krishna Balram</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Vatsal Dubey, Julie Tejwani, Rupa Bhimani, Jig...</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>False</td>\n",
       "      <td>July 8, 2019</td>\n",
       "      <td>2019</td>\n",
       "      <td>TV-Y7-FV</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>Kids' TV</td>\n",
       "      <td>From playing pranks to destroying demons, Lord...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2790</th>\n",
       "      <td>81078217</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>In The Dark</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Perry Mattfeld, Brooke Markham, Casey Deidrick...</td>\n",
       "      <td>United States</td>\n",
       "      <td>True</td>\n",
       "      <td>July 5, 2019</td>\n",
       "      <td>2019</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>Crime TV Shows, TV Dramas</td>\n",
       "      <td>A blind woman with vices finds herself in the ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2792</th>\n",
       "      <td>81108281</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>The Legend of White Snake</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Yu Menglong, Ju Jingyi, Pei Zitian, Xiao Yan, ...</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>False</td>\n",
       "      <td>July 5, 2019</td>\n",
       "      <td>2019</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>International TV Shows, Romantic TV Shows, TV ...</td>\n",
       "      <td>In this new take on a classic tale, an ancient...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2801</th>\n",
       "      <td>80236408</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Bangkok Love Stories: Innocence</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Nida Patcharaveerapong, Nicole Theriault, Natt...</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>False</td>\n",
       "      <td>July 31, 2019</td>\n",
       "      <td>2018</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>International TV Shows, Romantic TV Shows, TV ...</td>\n",
       "      <td>From a teenage parkour enthusiast to a bawdy r...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2808</th>\n",
       "      <td>81151899</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>7 (Seven)</td>\n",
       "      <td>Nizar Shafi</td>\n",
       "      <td>Rahman, Havish, Regina Cassandra, Nandita Swet...</td>\n",
       "      <td>India</td>\n",
       "      <td>False</td>\n",
       "      <td>July 30, 2019</td>\n",
       "      <td>2019</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>TV Shows</td>\n",
       "      <td>Multiple women report their husbands as missin...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5966</th>\n",
       "      <td>80141270</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Bonus Family</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Vera Vitali, Erik Johansson, Fredrik Hallgren,...</td>\n",
       "      <td>Sweden</td>\n",
       "      <td>False</td>\n",
       "      <td>July 12, 2019</td>\n",
       "      <td>2019</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>3 Seasons</td>\n",
       "      <td>International TV Shows, TV Dramas</td>\n",
       "      <td>A new couple, their exes and their children na...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5967</th>\n",
       "      <td>80224279</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Nightmare Tenants, Slum Landlords</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Wendi Peters</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>False</td>\n",
       "      <td>July 12, 2019</td>\n",
       "      <td>2016</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>2 Seasons</td>\n",
       "      <td>British TV Shows, International TV Shows, Real...</td>\n",
       "      <td>The ongoing housing crisis in Britain has led ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5971</th>\n",
       "      <td>81064394</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Hatchimals | Adventures in Hatchtopia</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Sam Vincent, Kira Tozer, Andrea Libman</td>\n",
       "      <td>United States</td>\n",
       "      <td>True</td>\n",
       "      <td>July 1, 2019</td>\n",
       "      <td>2018</td>\n",
       "      <td>TV-Y</td>\n",
       "      <td>2 Seasons</td>\n",
       "      <td>Kids' TV</td>\n",
       "      <td>These fun-loving creatures hatch from their sh...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5972</th>\n",
       "      <td>80142000</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Tayo the Little Bus</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Robyn Slade, Kami Desilets</td>\n",
       "      <td>South Korea</td>\n",
       "      <td>False</td>\n",
       "      <td>July 1, 2019</td>\n",
       "      <td>2014</td>\n",
       "      <td>TV-Y</td>\n",
       "      <td>2 Seasons</td>\n",
       "      <td>Kids' TV, Korean TV Shows</td>\n",
       "      <td>As they learn their routes around the busy cit...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5973</th>\n",
       "      <td>81100135</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Zombie Dumb</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>False</td>\n",
       "      <td>July 1, 2019</td>\n",
       "      <td>2018</td>\n",
       "      <td>TV-Y7</td>\n",
       "      <td>2 Seasons</td>\n",
       "      <td>Kids' TV, Korean TV Shows, TV Comedies</td>\n",
       "      <td>While living alone in a spooky town, a young g...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>78 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       show_id     type                                  title     director  \\\n",
       "2769  81088333  TV Show                         Krishna Balram      Unknown   \n",
       "2790  81078217  TV Show                            In The Dark      Unknown   \n",
       "2792  81108281  TV Show              The Legend of White Snake      Unknown   \n",
       "2801  80236408  TV Show        Bangkok Love Stories: Innocence      Unknown   \n",
       "2808  81151899  TV Show                              7 (Seven)  Nizar Shafi   \n",
       "...        ...      ...                                    ...          ...   \n",
       "5966  80141270  TV Show                           Bonus Family      Unknown   \n",
       "5967  80224279  TV Show      Nightmare Tenants, Slum Landlords      Unknown   \n",
       "5971  81064394  TV Show  Hatchimals | Adventures in Hatchtopia      Unknown   \n",
       "5972  80142000  TV Show                    Tayo the Little Bus      Unknown   \n",
       "5973  81100135  TV Show                            Zombie Dumb      Unknown   \n",
       "\n",
       "                                                   cast        country  \\\n",
       "2769  Vatsal Dubey, Julie Tejwani, Rupa Bhimani, Jig...        Unknown   \n",
       "2790  Perry Mattfeld, Brooke Markham, Casey Deidrick...  United States   \n",
       "2792  Yu Menglong, Ju Jingyi, Pei Zitian, Xiao Yan, ...        Unknown   \n",
       "2801  Nida Patcharaveerapong, Nicole Theriault, Natt...        Unknown   \n",
       "2808  Rahman, Havish, Regina Cassandra, Nandita Swet...          India   \n",
       "...                                                 ...            ...   \n",
       "5966  Vera Vitali, Erik Johansson, Fredrik Hallgren,...         Sweden   \n",
       "5967                                       Wendi Peters        Unknown   \n",
       "5971             Sam Vincent, Kira Tozer, Andrea Libman  United States   \n",
       "5972                         Robyn Slade, Kami Desilets    South Korea   \n",
       "5973                                            Unknown        Unknown   \n",
       "\n",
       "      available_in_usa      date_added  release_year    rating   duration  \\\n",
       "2769             False    July 8, 2019          2019  TV-Y7-FV   1 Season   \n",
       "2790              True    July 5, 2019          2019     TV-14   1 Season   \n",
       "2792             False    July 5, 2019          2019     TV-14   1 Season   \n",
       "2801             False   July 31, 2019          2018     TV-14   1 Season   \n",
       "2808             False   July 30, 2019          2019     TV-14   1 Season   \n",
       "...                ...             ...           ...       ...        ...   \n",
       "5966             False   July 12, 2019          2019     TV-MA  3 Seasons   \n",
       "5967             False   July 12, 2019          2016     TV-MA  2 Seasons   \n",
       "5971              True    July 1, 2019          2018      TV-Y  2 Seasons   \n",
       "5972             False    July 1, 2019          2014      TV-Y  2 Seasons   \n",
       "5973             False    July 1, 2019          2018     TV-Y7  2 Seasons   \n",
       "\n",
       "                                              listed_in  \\\n",
       "2769                                           Kids' TV   \n",
       "2790                          Crime TV Shows, TV Dramas   \n",
       "2792  International TV Shows, Romantic TV Shows, TV ...   \n",
       "2801  International TV Shows, Romantic TV Shows, TV ...   \n",
       "2808                                           TV Shows   \n",
       "...                                                 ...   \n",
       "5966                  International TV Shows, TV Dramas   \n",
       "5967  British TV Shows, International TV Shows, Real...   \n",
       "5971                                           Kids' TV   \n",
       "5972                          Kids' TV, Korean TV Shows   \n",
       "5973             Kids' TV, Korean TV Shows, TV Comedies   \n",
       "\n",
       "                                            description  \n",
       "2769  From playing pranks to destroying demons, Lord...  \n",
       "2790  A blind woman with vices finds herself in the ...  \n",
       "2792  In this new take on a classic tale, an ancient...  \n",
       "2801  From a teenage parkour enthusiast to a bawdy r...  \n",
       "2808  Multiple women report their husbands as missin...  \n",
       "...                                                 ...  \n",
       "5966  A new couple, their exes and their children na...  \n",
       "5967  The ongoing housing crisis in Britain has led ...  \n",
       "5971  These fun-loving creatures hatch from their sh...  \n",
       "5972  As they learn their routes around the busy cit...  \n",
       "5973  While living alone in a spooky town, a young g...  \n",
       "\n",
       "[78 rows x 13 columns]"
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# prints all the tv shows that were added in july 2019\n",
    "july_tv_shows"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 642
    },
    "id": "_GYb1pm3eep9",
    "outputId": "a1d8c6db-7a15-4a86-da2a-0eb07737bbde"
   },
   "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>type</th>\n",
       "      <th>title</th>\n",
       "      <th>director</th>\n",
       "      <th>cast</th>\n",
       "      <th>country</th>\n",
       "      <th>available_in_usa</th>\n",
       "      <th>date_added</th>\n",
       "      <th>release_year</th>\n",
       "      <th>rating</th>\n",
       "      <th>duration</th>\n",
       "      <th>listed_in</th>\n",
       "      <th>description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2767</th>\n",
       "      <td>81098589</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Aziz Ansari: RIGHT NOW</td>\n",
       "      <td>Spike Jonze</td>\n",
       "      <td>Aziz Ansari</td>\n",
       "      <td>United States</td>\n",
       "      <td>True</td>\n",
       "      <td>July 9, 2019</td>\n",
       "      <td>2019</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>65 min</td>\n",
       "      <td>Stand-Up Comedy</td>\n",
       "      <td>In a comedy special directed by Spike Jonze, A...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2768</th>\n",
       "      <td>80221446</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Mary Poppins Returns</td>\n",
       "      <td>Rob Marshall</td>\n",
       "      <td>Emily Blunt, Lin-Manuel Miranda, Ben Whishaw, ...</td>\n",
       "      <td>United States, United Kingdom</td>\n",
       "      <td>True</td>\n",
       "      <td>July 9, 2019</td>\n",
       "      <td>2018</td>\n",
       "      <td>PG</td>\n",
       "      <td>131 min</td>\n",
       "      <td>Children &amp; Family Movies, Music &amp; Musicals</td>\n",
       "      <td>In 1930s London, Michael Banks and his three c...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2772</th>\n",
       "      <td>70189282</td>\n",
       "      <td>Movie</td>\n",
       "      <td>The Iron Lady</td>\n",
       "      <td>Phyllida Lloyd</td>\n",
       "      <td>Meryl Streep, Jim Broadbent, Alexandra Roach, ...</td>\n",
       "      <td>United Kingdom, France</td>\n",
       "      <td>False</td>\n",
       "      <td>July 7, 2019</td>\n",
       "      <td>2011</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>105 min</td>\n",
       "      <td>Dramas, International Movies</td>\n",
       "      <td>Margaret Thatcher, the first female prime mini...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2781</th>\n",
       "      <td>81039323</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Sicilian Ghost Story</td>\n",
       "      <td>Fabio Grassadonia, Antonio Piazza</td>\n",
       "      <td>Julia Jedlikowska, Gaetano Fernandez, Corinne ...</td>\n",
       "      <td>Italy, France, Switzerland</td>\n",
       "      <td>False</td>\n",
       "      <td>July 6, 2019</td>\n",
       "      <td>2017</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>119 min</td>\n",
       "      <td>Dramas, International Movies, Thrillers</td>\n",
       "      <td>When officials are slow to investigate a myste...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2791</th>\n",
       "      <td>80223153</td>\n",
       "      <td>Movie</td>\n",
       "      <td>River, el más grande siempre</td>\n",
       "      <td>Marcelo Altmark, Mariano Mucci, Luis A. Scalella</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Argentina</td>\n",
       "      <td>False</td>\n",
       "      <td>July 5, 2019</td>\n",
       "      <td>2019</td>\n",
       "      <td>TV-G</td>\n",
       "      <td>105 min</td>\n",
       "      <td>Documentaries, International Movies, Sports Mo...</td>\n",
       "      <td>Experience the highlights of Argentine soccer ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3086</th>\n",
       "      <td>70084795</td>\n",
       "      <td>Movie</td>\n",
       "      <td>The Forbidden Kingdom</td>\n",
       "      <td>Rob Minkoff</td>\n",
       "      <td>Jackie Chan, Jet Li, Collin Chou, Liu Yifei, L...</td>\n",
       "      <td>United States, China</td>\n",
       "      <td>True</td>\n",
       "      <td>July 1, 2019</td>\n",
       "      <td>2008</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>104 min</td>\n",
       "      <td>Action &amp; Adventure, Sci-Fi &amp; Fantasy</td>\n",
       "      <td>Jackie Chan and Jet Li star in this rousing ad...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3087</th>\n",
       "      <td>60027701</td>\n",
       "      <td>Movie</td>\n",
       "      <td>The In-Laws</td>\n",
       "      <td>Andrew Fleming</td>\n",
       "      <td>Michael Douglas, Albert Brooks, Robin Tunney, ...</td>\n",
       "      <td>United States, Germany, Canada</td>\n",
       "      <td>True</td>\n",
       "      <td>July 1, 2019</td>\n",
       "      <td>2003</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>98 min</td>\n",
       "      <td>Action &amp; Adventure, Comedies</td>\n",
       "      <td>Daredevil secret agent and father of the groom...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3088</th>\n",
       "      <td>70021654</td>\n",
       "      <td>Movie</td>\n",
       "      <td>The Pink Panther</td>\n",
       "      <td>Shawn Levy</td>\n",
       "      <td>Steve Martin, Kevin Kline, Beyoncé Knowles-Car...</td>\n",
       "      <td>United States, Czech Republic</td>\n",
       "      <td>True</td>\n",
       "      <td>July 1, 2019</td>\n",
       "      <td>2006</td>\n",
       "      <td>PG</td>\n",
       "      <td>93 min</td>\n",
       "      <td>Children &amp; Family Movies, Comedies</td>\n",
       "      <td>Bumbling Inspector Clouseau must solve the mur...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3090</th>\n",
       "      <td>81077862</td>\n",
       "      <td>Movie</td>\n",
       "      <td>War Against Women</td>\n",
       "      <td>Hernán Zin</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>United States, Spain</td>\n",
       "      <td>True</td>\n",
       "      <td>July 1, 2019</td>\n",
       "      <td>2013</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>61 min</td>\n",
       "      <td>Documentaries, International Movies</td>\n",
       "      <td>Filmed over three years in 10 countries, this ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3091</th>\n",
       "      <td>70001777</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Who's That Knocking at My Door?</td>\n",
       "      <td>Martin Scorsese</td>\n",
       "      <td>Zina Bethune, Harvey Keitel, Anne Collette, Le...</td>\n",
       "      <td>United States</td>\n",
       "      <td>True</td>\n",
       "      <td>July 1, 2019</td>\n",
       "      <td>1967</td>\n",
       "      <td>R</td>\n",
       "      <td>90 min</td>\n",
       "      <td>Classic Movies, Dramas, Independent Movies</td>\n",
       "      <td>A woman's revelation that she was once raped s...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>108 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       show_id   type                            title  \\\n",
       "2767  81098589  Movie           Aziz Ansari: RIGHT NOW   \n",
       "2768  80221446  Movie             Mary Poppins Returns   \n",
       "2772  70189282  Movie                    The Iron Lady   \n",
       "2781  81039323  Movie             Sicilian Ghost Story   \n",
       "2791  80223153  Movie     River, el más grande siempre   \n",
       "...        ...    ...                              ...   \n",
       "3086  70084795  Movie            The Forbidden Kingdom   \n",
       "3087  60027701  Movie                      The In-Laws   \n",
       "3088  70021654  Movie                 The Pink Panther   \n",
       "3090  81077862  Movie                War Against Women   \n",
       "3091  70001777  Movie  Who's That Knocking at My Door?   \n",
       "\n",
       "                                              director  \\\n",
       "2767                                       Spike Jonze   \n",
       "2768                                      Rob Marshall   \n",
       "2772                                    Phyllida Lloyd   \n",
       "2781                 Fabio Grassadonia, Antonio Piazza   \n",
       "2791  Marcelo Altmark, Mariano Mucci, Luis A. Scalella   \n",
       "...                                                ...   \n",
       "3086                                       Rob Minkoff   \n",
       "3087                                    Andrew Fleming   \n",
       "3088                                        Shawn Levy   \n",
       "3090                                        Hernán Zin   \n",
       "3091                                   Martin Scorsese   \n",
       "\n",
       "                                                   cast  \\\n",
       "2767                                        Aziz Ansari   \n",
       "2768  Emily Blunt, Lin-Manuel Miranda, Ben Whishaw, ...   \n",
       "2772  Meryl Streep, Jim Broadbent, Alexandra Roach, ...   \n",
       "2781  Julia Jedlikowska, Gaetano Fernandez, Corinne ...   \n",
       "2791                                            Unknown   \n",
       "...                                                 ...   \n",
       "3086  Jackie Chan, Jet Li, Collin Chou, Liu Yifei, L...   \n",
       "3087  Michael Douglas, Albert Brooks, Robin Tunney, ...   \n",
       "3088  Steve Martin, Kevin Kline, Beyoncé Knowles-Car...   \n",
       "3090                                            Unknown   \n",
       "3091  Zina Bethune, Harvey Keitel, Anne Collette, Le...   \n",
       "\n",
       "                             country  available_in_usa    date_added  \\\n",
       "2767                   United States              True  July 9, 2019   \n",
       "2768   United States, United Kingdom              True  July 9, 2019   \n",
       "2772          United Kingdom, France             False  July 7, 2019   \n",
       "2781      Italy, France, Switzerland             False  July 6, 2019   \n",
       "2791                       Argentina             False  July 5, 2019   \n",
       "...                              ...               ...           ...   \n",
       "3086            United States, China              True  July 1, 2019   \n",
       "3087  United States, Germany, Canada              True  July 1, 2019   \n",
       "3088   United States, Czech Republic              True  July 1, 2019   \n",
       "3090            United States, Spain              True  July 1, 2019   \n",
       "3091                   United States              True  July 1, 2019   \n",
       "\n",
       "      release_year rating duration  \\\n",
       "2767          2019  TV-MA   65 min   \n",
       "2768          2018     PG  131 min   \n",
       "2772          2011  PG-13  105 min   \n",
       "2781          2017  TV-MA  119 min   \n",
       "2791          2019   TV-G  105 min   \n",
       "...            ...    ...      ...   \n",
       "3086          2008  PG-13  104 min   \n",
       "3087          2003  PG-13   98 min   \n",
       "3088          2006     PG   93 min   \n",
       "3090          2013  TV-14   61 min   \n",
       "3091          1967      R   90 min   \n",
       "\n",
       "                                              listed_in  \\\n",
       "2767                                    Stand-Up Comedy   \n",
       "2768         Children & Family Movies, Music & Musicals   \n",
       "2772                       Dramas, International Movies   \n",
       "2781            Dramas, International Movies, Thrillers   \n",
       "2791  Documentaries, International Movies, Sports Mo...   \n",
       "...                                                 ...   \n",
       "3086               Action & Adventure, Sci-Fi & Fantasy   \n",
       "3087                       Action & Adventure, Comedies   \n",
       "3088                 Children & Family Movies, Comedies   \n",
       "3090                Documentaries, International Movies   \n",
       "3091         Classic Movies, Dramas, Independent Movies   \n",
       "\n",
       "                                            description  \n",
       "2767  In a comedy special directed by Spike Jonze, A...  \n",
       "2768  In 1930s London, Michael Banks and his three c...  \n",
       "2772  Margaret Thatcher, the first female prime mini...  \n",
       "2781  When officials are slow to investigate a myste...  \n",
       "2791  Experience the highlights of Argentine soccer ...  \n",
       "...                                                 ...  \n",
       "3086  Jackie Chan and Jet Li star in this rousing ad...  \n",
       "3087  Daredevil secret agent and father of the groom...  \n",
       "3088  Bumbling Inspector Clouseau must solve the mur...  \n",
       "3090  Filmed over three years in 10 countries, this ...  \n",
       "3091  A woman's revelation that she was once raped s...  \n",
       "\n",
       "[108 rows x 13 columns]"
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# prints all the Movies that were added in july 2019\n",
    "july_movies"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "id": "ziEIqkbkIUQr"
   },
   "source": [
    "## Section 4: Exploration\n",
    "\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "id": "RLTZrnbfiH2o"
   },
   "source": [
    "1- Show all the TV shows with more than 2 seasons and it is \"TV-14\". Show only 4 columns **(title, type, ratings, duration**)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 411
    },
    "id": "6mg-kCGVO4bd",
    "outputId": "ea626509-5106-430f-a70c-7408e8c3b61e"
   },
   "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>title</th>\n",
       "      <th>type</th>\n",
       "      <th>rating</th>\n",
       "      <th>duration</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>5583</th>\n",
       "      <td>Show Me the Money</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>2 Seasons</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5585</th>\n",
       "      <td>Haven</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>5 Seasons</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5592</th>\n",
       "      <td>Reign</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>4 Seasons</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5593</th>\n",
       "      <td>The Vampire Diaries</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>8 Seasons</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5594</th>\n",
       "      <td>Gotham</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>5 Seasons</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6217</th>\n",
       "      <td>New Girl</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>7 Seasons</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6221</th>\n",
       "      <td>Terrace House: Boys &amp; Girls in the City</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>2 Seasons</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6223</th>\n",
       "      <td>Gunslinger Girl</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>2 Seasons</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6226</th>\n",
       "      <td>La Familia P. Luche</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>3 Seasons</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6233</th>\n",
       "      <td>Friends</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>10 Seasons</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>188 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        title     type rating    duration\n",
       "5583                        Show Me the Money  TV Show  TV-14   2 Seasons\n",
       "5585                                    Haven  TV Show  TV-14   5 Seasons\n",
       "5592                                    Reign  TV Show  TV-14   4 Seasons\n",
       "5593                      The Vampire Diaries  TV Show  TV-14   8 Seasons\n",
       "5594                                   Gotham  TV Show  TV-14   5 Seasons\n",
       "...                                       ...      ...    ...         ...\n",
       "6217                                 New Girl  TV Show  TV-14   7 Seasons\n",
       "6221  Terrace House: Boys & Girls in the City  TV Show  TV-14   2 Seasons\n",
       "6223                          Gunslinger Girl  TV Show  TV-14   2 Seasons\n",
       "6226                      La Familia P. Luche  TV Show  TV-14   3 Seasons\n",
       "6233                                  Friends  TV Show  TV-14  10 Seasons\n",
       "\n",
       "[188 rows x 4 columns]"
      ]
     },
     "execution_count": 62,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Write code below\n",
    "#1\n",
    "# create a condtion for only TV shows\n",
    "is_tvshows = netflix.loc[:,'type'] == \"TV Show\"\n",
    "#create a condtion to show seasons by specifying plural to only get multiple seasons\n",
    "is_seasons = netflix.duration.str.contains(\"Seasons\")\n",
    "# craete a condtion for rating TV-14\n",
    "is_adult = netflix.rating.str.contains(\"TV-14\")\n",
    "\n",
    "# add all condtions in one variable \n",
    "tv_seasons = netflix[is_tvshows & is_seasons & is_adult].loc[:,['title', 'type', 'rating', 'duration']]\n",
    "\n",
    "tv_seasons\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "id": "1_JE0xMj3dut"
   },
   "source": [
    "What is the highest release_year of Movies in netflix"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/"
    },
    "id": "G3ukQk9JAi3w",
    "outputId": "61cbf21c-e0f5-4797-fde6-406e10628e16"
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "the Highest release_year in Netflix is 2017 with a total of 682 Movies\n"
     ]
    }
   ],
   "source": [
    "#2\n",
    "# created a variable to print only movies\n",
    "all_movies = netflix[is_movies]\n",
    "# created a variable to count number of movies by release_year\n",
    "movies_by_years = all_movies[\"release_year\"].value_counts()\n",
    "\n",
    "# print the max index in movies_by_years + the value of movies_by_years\n",
    "print(\"the Highest release_year in Netflix is \" + str(movies_by_years.idxmax()) + \" with a total of \" + str(movies_by_years.max())+ \" Movies\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "id": "NLw9bfIdDi--"
   },
   "source": [
    "Show all of the Comedy TV shows from 2015 to recent in netflix.  \n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 576
    },
    "id": "Ltod_vSH3JCx",
    "outputId": "d84893bd-e7d5-48d0-df62-2649100b2f16"
   },
   "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>type</th>\n",
       "      <th>title</th>\n",
       "      <th>director</th>\n",
       "      <th>cast</th>\n",
       "      <th>country</th>\n",
       "      <th>available_in_usa</th>\n",
       "      <th>date_added</th>\n",
       "      <th>release_year</th>\n",
       "      <th>rating</th>\n",
       "      <th>duration</th>\n",
       "      <th>listed_in</th>\n",
       "      <th>description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>80244601</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Castle of Stars</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Chaiyapol Pupart, Jintanutda Lummakanon, Worra...</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>False</td>\n",
       "      <td>September 7, 2018</td>\n",
       "      <td>2015</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>International TV Shows, Romantic TV Shows, TV ...</td>\n",
       "      <td>As four couples with different lifestyles go t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>80221550</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Archibald's Next Big Thing</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Tony Hale, Rosamund Pike, Jordan Fisher, Chels...</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>False</td>\n",
       "      <td>September 6, 2019</td>\n",
       "      <td>2019</td>\n",
       "      <td>TV-Y7</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>Kids' TV, TV Comedies</td>\n",
       "      <td>Happy-go-lucky chicken Archibald may not remem...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>80113482</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>No Tomorrow</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Joshua Sasse, Tori Anderson, Jonathan Langdon,...</td>\n",
       "      <td>United States</td>\n",
       "      <td>True</td>\n",
       "      <td>September 5, 2017</td>\n",
       "      <td>2016</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>Romantic TV Shows, TV Comedies, TV Dramas</td>\n",
       "      <td>Her straitjacketed life turned topsy-turvy by ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>80996949</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Adam Ruins Everything</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Adam Conover, Adam Lustick, Emily Axford</td>\n",
       "      <td>United States</td>\n",
       "      <td>True</td>\n",
       "      <td>September 30, 2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>TV Comedies</td>\n",
       "      <td>Education can be fun – and funny. Comedian Ada...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>80116921</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>We Bare Bears</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Eric Edelstein, Demetri Martin, Bobby Moynihan</td>\n",
       "      <td>United States</td>\n",
       "      <td>True</td>\n",
       "      <td>September 30, 2018</td>\n",
       "      <td>2017</td>\n",
       "      <td>TV-Y7</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>Kids' TV, TV Comedies</td>\n",
       "      <td>Grizzly, Panda and Ice Bear are three adopted ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6217</th>\n",
       "      <td>70196145</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>New Girl</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Zooey Deschanel, Jake Johnson, Max Greenfield,...</td>\n",
       "      <td>United States</td>\n",
       "      <td>True</td>\n",
       "      <td>April 11, 2019</td>\n",
       "      <td>2017</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>7 Seasons</td>\n",
       "      <td>Romantic TV Shows, TV Comedies</td>\n",
       "      <td>Still rebounding from a breakup, Jessica Day m...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6218</th>\n",
       "      <td>80162994</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Talking Tom and Friends</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Colin Hanks, Tom Kenny, James Adomian, Lisa Sc...</td>\n",
       "      <td>Cyprus, Austria, Thailand</td>\n",
       "      <td>False</td>\n",
       "      <td>April 10, 2019</td>\n",
       "      <td>2017</td>\n",
       "      <td>TV-G</td>\n",
       "      <td>2 Seasons</td>\n",
       "      <td>Kids' TV, TV Comedies</td>\n",
       "      <td>Full of funny one-liners and always ready for ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6227</th>\n",
       "      <td>80005756</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>The Adventures of Figaro Pho</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Luke Jurevicius, Craig Behenna, Charlotte Haml...</td>\n",
       "      <td>Australia</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015</td>\n",
       "      <td>TV-Y7</td>\n",
       "      <td>2 Seasons</td>\n",
       "      <td>Kids' TV, TV Comedies</td>\n",
       "      <td>Imagine your worst fears, then multiply them: ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6229</th>\n",
       "      <td>80000063</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Red vs. Blue</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Burnie Burns, Jason Saldaña, Gustavo Sorola, G...</td>\n",
       "      <td>United States</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015</td>\n",
       "      <td>NR</td>\n",
       "      <td>13 Seasons</td>\n",
       "      <td>TV Action &amp; Adventure, TV Comedies, TV Sci-Fi ...</td>\n",
       "      <td>This parody of first-person shooter games, mil...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6230</th>\n",
       "      <td>70286564</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Maron</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Marc Maron, Judd Hirsch, Josh Brener, Nora Zeh...</td>\n",
       "      <td>United States</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>4 Seasons</td>\n",
       "      <td>TV Comedies</td>\n",
       "      <td>Marc Maron stars as Marc Maron, who interviews...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>347 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       show_id     type                         title director  \\\n",
       "26    80244601  TV Show               Castle of Stars  Unknown   \n",
       "34    80221550  TV Show    Archibald's Next Big Thing  Unknown   \n",
       "54    80113482  TV Show                   No Tomorrow  Unknown   \n",
       "63    80996949  TV Show         Adam Ruins Everything  Unknown   \n",
       "70    80116921  TV Show                 We Bare Bears  Unknown   \n",
       "...        ...      ...                           ...      ...   \n",
       "6217  70196145  TV Show                      New Girl  Unknown   \n",
       "6218  80162994  TV Show       Talking Tom and Friends  Unknown   \n",
       "6227  80005756  TV Show  The Adventures of Figaro Pho  Unknown   \n",
       "6229  80000063  TV Show                  Red vs. Blue  Unknown   \n",
       "6230  70286564  TV Show                         Maron  Unknown   \n",
       "\n",
       "                                                   cast  \\\n",
       "26    Chaiyapol Pupart, Jintanutda Lummakanon, Worra...   \n",
       "34    Tony Hale, Rosamund Pike, Jordan Fisher, Chels...   \n",
       "54    Joshua Sasse, Tori Anderson, Jonathan Langdon,...   \n",
       "63             Adam Conover, Adam Lustick, Emily Axford   \n",
       "70       Eric Edelstein, Demetri Martin, Bobby Moynihan   \n",
       "...                                                 ...   \n",
       "6217  Zooey Deschanel, Jake Johnson, Max Greenfield,...   \n",
       "6218  Colin Hanks, Tom Kenny, James Adomian, Lisa Sc...   \n",
       "6227  Luke Jurevicius, Craig Behenna, Charlotte Haml...   \n",
       "6229  Burnie Burns, Jason Saldaña, Gustavo Sorola, G...   \n",
       "6230  Marc Maron, Judd Hirsch, Josh Brener, Nora Zeh...   \n",
       "\n",
       "                        country  available_in_usa          date_added  \\\n",
       "26                      Unknown             False   September 7, 2018   \n",
       "34                      Unknown             False   September 6, 2019   \n",
       "54                United States              True   September 5, 2017   \n",
       "63                United States              True  September 30, 2018   \n",
       "70                United States              True  September 30, 2018   \n",
       "...                         ...               ...                 ...   \n",
       "6217              United States              True      April 11, 2019   \n",
       "6218  Cyprus, Austria, Thailand             False      April 10, 2019   \n",
       "6227                  Australia             False                 NaN   \n",
       "6229              United States              True                 NaN   \n",
       "6230              United States              True                 NaN   \n",
       "\n",
       "      release_year rating    duration  \\\n",
       "26            2015  TV-14    1 Season   \n",
       "34            2019  TV-Y7    1 Season   \n",
       "54            2016  TV-14    1 Season   \n",
       "63            2018  TV-14    1 Season   \n",
       "70            2017  TV-Y7    1 Season   \n",
       "...            ...    ...         ...   \n",
       "6217          2017  TV-14   7 Seasons   \n",
       "6218          2017   TV-G   2 Seasons   \n",
       "6227          2015  TV-Y7   2 Seasons   \n",
       "6229          2015     NR  13 Seasons   \n",
       "6230          2016  TV-MA   4 Seasons   \n",
       "\n",
       "                                              listed_in  \\\n",
       "26    International TV Shows, Romantic TV Shows, TV ...   \n",
       "34                                Kids' TV, TV Comedies   \n",
       "54            Romantic TV Shows, TV Comedies, TV Dramas   \n",
       "63                                          TV Comedies   \n",
       "70                                Kids' TV, TV Comedies   \n",
       "...                                                 ...   \n",
       "6217                     Romantic TV Shows, TV Comedies   \n",
       "6218                              Kids' TV, TV Comedies   \n",
       "6227                              Kids' TV, TV Comedies   \n",
       "6229  TV Action & Adventure, TV Comedies, TV Sci-Fi ...   \n",
       "6230                                        TV Comedies   \n",
       "\n",
       "                                            description  \n",
       "26    As four couples with different lifestyles go t...  \n",
       "34    Happy-go-lucky chicken Archibald may not remem...  \n",
       "54    Her straitjacketed life turned topsy-turvy by ...  \n",
       "63    Education can be fun – and funny. Comedian Ada...  \n",
       "70    Grizzly, Panda and Ice Bear are three adopted ...  \n",
       "...                                                 ...  \n",
       "6217  Still rebounding from a breakup, Jessica Day m...  \n",
       "6218  Full of funny one-liners and always ready for ...  \n",
       "6227  Imagine your worst fears, then multiply them: ...  \n",
       "6229  This parody of first-person shooter games, mil...  \n",
       "6230  Marc Maron stars as Marc Maron, who interviews...  \n",
       "\n",
       "[347 rows x 13 columns]"
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#3\n",
    "# create 3 variables and use conditions to show specific resutls\n",
    "is_tvshow = netflix.loc[:, 'type'].str.contains(\"TV Show\")\n",
    "# Pull all comedies in listed_in. \n",
    "is_comedies = netflix.loc[:, 'listed_in'].str.contains(\"Comedies\")\n",
    "# this is to show only years from 2015 to recent\n",
    "is_year = netflix.loc[:, \"release_year\"] >= 2015 \n",
    "# use boolean logic, all True store them in new variable\n",
    "all_comedy = netflix[is_tvshow & is_comedies & is_year]\n",
    "all_comedy\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/"
    },
    "id": "RHjSyzcJMzv-",
    "outputId": "3f214f77-27d1-4990-9f27-6eb309b30af5"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Kids' TV, TV Comedies                                                59\n",
       "TV Comedies                                                          48\n",
       "International TV Shows, Romantic TV Shows, TV Comedies               39\n",
       "International TV Shows, TV Comedies, TV Dramas                       25\n",
       "Stand-Up Comedy & Talk Shows, TV Comedies                            21\n",
       "International TV Shows, TV Comedies                                  20\n",
       "TV Comedies, TV Dramas                                               20\n",
       "British TV Shows, International TV Shows, TV Comedies                12\n",
       "International TV Shows, Spanish-Language TV Shows, TV Comedies       10\n",
       "Crime TV Shows, International TV Shows, TV Comedies                   8\n",
       "British TV Shows, TV Comedies                                         7\n",
       "International TV Shows, Korean TV Shows, TV Comedies                  6\n",
       "Romantic TV Shows, TV Comedies, TV Dramas                             6\n",
       "TV Comedies, TV Dramas, Teen TV Shows                                 6\n",
       "Crime TV Shows, TV Comedies, TV Dramas                                6\n",
       "Romantic TV Shows, TV Comedies                                        4\n",
       "Kids' TV, Korean TV Shows, TV Comedies                                4\n",
       "Kids' TV, TV Action & Adventure, TV Comedies                          4\n",
       "Kids' TV, TV Comedies, TV Dramas                                      3\n",
       "TV Action & Adventure, TV Comedies, TV Horror                         3\n",
       "International TV Shows, Stand-Up Comedy & Talk Shows, TV Comedies     3\n",
       "British TV Shows, Kids' TV, TV Comedies                               2\n",
       "TV Action & Adventure, TV Comedies, TV Sci-Fi & Fantasy               2\n",
       "British TV Shows, Classic & Cult TV, TV Comedies                      2\n",
       "Crime TV Shows, TV Action & Adventure, TV Comedies                    2\n",
       "Crime TV Shows, Kids' TV, TV Comedies                                 2\n",
       "Docuseries, TV Comedies                                               2\n",
       "International TV Shows, TV Action & Adventure, TV Comedies            2\n",
       "International TV Shows, Reality TV, TV Comedies                       2\n",
       "International TV Shows, TV Comedies, TV Sci-Fi & Fantasy              2\n",
       "Crime TV Shows, TV Comedies                                           1\n",
       "TV Action & Adventure, TV Comedies                                    1\n",
       "Classic & Cult TV, TV Comedies                                        1\n",
       "TV Comedies, TV Dramas, TV Horror                                     1\n",
       "TV Comedies, TV Mysteries                                             1\n",
       "TV Comedies, Teen TV Shows                                            1\n",
       "Romantic TV Shows, Spanish-Language TV Shows, TV Comedies             1\n",
       "British TV Shows, TV Comedies, TV Dramas                              1\n",
       "TV Comedies, TV Sci-Fi & Fantasy, Teen TV Shows                       1\n",
       "Reality TV, TV Comedies                                               1\n",
       "TV Comedies, TV Dramas, TV Mysteries                                  1\n",
       "Crime TV Shows, TV Comedies, Teen TV Shows                            1\n",
       "TV Comedies, TV Horror, TV Thrillers                                  1\n",
       "TV Comedies, TV Sci-Fi & Fantasy                                      1\n",
       "Reality TV, TV Comedies, TV Horror                                    1\n",
       "Name: listed_in, dtype: int64"
      ]
     },
     "execution_count": 65,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# this is to show the TV shows under their catagory\n",
    "all_comedy['listed_in'].value_counts()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "id": "UvQT539tM6dr"
   },
   "source": [
    "# Visualizing TV shows vs Movies over Time (2011-2019)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "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>release_year</th>\n",
       "      <th>type</th>\n",
       "      <th>title</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>2011</td>\n",
       "      <td>Movie</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>2011</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>2012</td>\n",
       "      <td>Movie</td>\n",
       "      <td>125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>2012</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>2013</td>\n",
       "      <td>Movie</td>\n",
       "      <td>177</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    release_year     type  title\n",
       "95          2011    Movie    100\n",
       "96          2011  TV Show     36\n",
       "97          2012    Movie    125\n",
       "98          2012  TV Show     58\n",
       "99          2013    Movie    177"
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# get count of title for each year per type\n",
    "type_release = netflix.groupby(by=['release_year', 'type'], as_index=False)['title'].count()\n",
    "is_yaers = type_release.release_year > 2010 \n",
    "release_movie_tv = type_release[is_yaers].sort_values(by='release_year', ascending=True)\n",
    "release_movie_tv.head()\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<seaborn.axisgrid.FacetGrid at 0x7fd7233caf40>"
      ]
     },
     "execution_count": 68,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAxsAAAFqCAYAAAByP0eEAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjMsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+AADFEAAAgAElEQVR4nOzdd1zU9/0H8NdxHMdeynIRNW4UVFAQEBFRUIYsUZMYjW1WmyY2aZvmZ5Jm1aQ1MTaJadLMmjQKiGgcaMSRAxyoiAtHjMqQKcIxj+Pu+/vDepVwx1D4sl7PxyOPyOf9+d69v5zCve+zJIIgCCAiIiIiIupkRt2dABERERER9U0sNoiIiIiIqEuw2CAiIiIioi7BYoOIiIiIiLoEiw0iIiIiIuoSLDaIiIiIiKhLsNgg6uHefPNNREZGIjIyEm5ubpg3b57u64aGBoPXVVVVYfny5W0+fmJiIp5++ulWr9doNIiMjERNTU2z9qamJowZMwZKpfJebq3dCgsLsWDBAkRGRuL06dO6doVCofte+Pr6wtvbW/f1559/Djc3N5SVlbV4vPnz5yMtLa1F+4kTJ/DII48gIiICYWFhePzxx3HlyhUAQGZmJiIjI7vuJrvQunXrMGbMGKSkpDRrr6mpgYeHh97Xvz3u/nvRGVavXo2goCCsX7++Ux6vNVevXsXy5csRERGB+fPn46uvvtLFTp48iejoaISEhGDFihUoLy9vdm1VVRXCwsKQm5vb4nEPHTqE6OjoVp9769atCA8PR2RkJBYvXoxz587pYh999BFCQkIQHByMDz/8sF2P//XXX+t+Ljz//PNd/u+RiKhDBCLqNQIDA4XTp0+3q++1a9eEqVOnttkvISFBeOqpp9p9/d3tarVaGD16tFBVVdWunO5VYmKi8Nhjj7Xa57333hPefPPNZm2PPfaY8MknnzRry8rKEgIDAwWNRtOsvb6+Xpg2bZqQm5ura9uyZYuub0ZGhhAREXGfd9I93nvvPWHWrFnCihUrmrUnJiYKM2bM0Pv6i02j0QijR48WSktLRXm+uLg4YcuWLYIgCEJlZaUQFBQkHDt2TFCpVIK/v7+QnZ0tCIIg/Pvf/xaeeOIJ3XVpaWlCcHCwMGHCBOH8+fO69rq6OmHt2rXClClTWv17cvnyZcHX11d3n/v27RNmz56t+3NUVJRQV1cn1NfXC4sXLxb27NnT6uOnp6cLAQEBQnFxsSAIgpCUlCQ899xznfEtIiLqFBzZIOrljh07hri4OERERCAmJgbp6ekAgD//+c+ora3VfRqfkJCAuLg4LFy4EIGBgdi8eXOrj3v39XePYPzyce+2efNmREdHY+HChXjsscdw9epVXY4xMTGIjo5GdHQ09u3bp/c5//Of/yAsLAwRERFYuXIlrl+/jszMTHz44Yc4depUu0Zq7rZ06VIkJye3yHHx4sUwMmr+46+urg41NTWora3VtS1cuBAvvfQSNBoNgNsjAc8++ywiIyMRGhqKkydPAgCUSiWef/55hIWFISwsDGvXrkVTUxPeeOMNfPDBBwCA4uJijBkzBllZWQBuf7r9/PPPo6SkBMuXL0dUVBSioqJ0/e/27bffNht9uHTpEmbNmgWtVot169YhPDwc0dHRWLlyZYtP4e8ICAjA+fPnUVpaqmtLSUlBRESE7mtD92Ho+RsbG5uNbN3P679kyRIAwGOPPYaTJ09i5syZWLVqFUJDQ7F//35cvHgRjzzyCMLDwxEREYHt27cDuD3itGTJEjz99NOYN28eoqOjkZaWhuXLl2PWrFl455139H4/Fi1ahPnz5wMAbGxsMGzYMBQWFuLUqVOwtbWFh4cHACA+Ph4KhQLV1dUAgG+++QZ///vfYW9v3+zxfvzxR6jVarz55pt6n+8OuVyOt956Cw4ODgAANzc3lJSUoKmpCfv27UNERATMzMxgamqK6Oho3X0aevxz587B19cXTk5OAIC5c+di3759aGpqajUPIiLRdHe1Q0Tt98uRjZs3bwo+Pj66tgsXLgjTpk0TCgsLm41AVFdXC/Hx8cKtW7cEQbj96b6np6cgCO0b2bh7BMNQe2ZmpvDwww8L9fX1giAIwsGDB4WwsDBBEAThoYceEnbv3i0IgiCcO3dOeOONN1o8n0KhEObOnSvcvHlTl9ed6w3leDd9IxsajUYIDAwUsrKyBEG4/Qm2p6enUFFRofcx/vWvfwkTJ04UgoKChD/84Q9CUlKS7n4yMjKECRMmCDk5Obq+d0Zbfv/73wtr1qwRBEEQGhoahEcffVT47LPPhMzMTCEuLk53D76+vsL7778vCIIg/OY3vxH27NkjrF+/XnjttdcEQRCEmpoa4Xe/+51QXV3dLC+lUilMnTpV971Zs2aN8I9//EPIy8sTvLy8BJVKJQiCIHz66adCWlqawe/NK6+8Inz++eeCIAhCXl6eEB8f3+x7a+g+DD1/Z77+vxwl8/f3F/75z38KgiAIjY2NQmBgoLBv3z5BEAShqKhI8PX1FXJycoSMjAxh/PjxuhGp5cuXC0uWLBEaGxuF8vJyYdy4cUJ5ebne1/uO/fv3C56enkJZWZmQkpIiPP74483iM2bMEC5fvtyszd/fv9nIxh0dGQHTaDTCc889pxuJePTRR3XfJ0EQhEOHDgkxMTGtPv7hw4eFwMBAobCwUBAEQfjyyy+F0aNH614rIqLuxpENol4sOzsbI0aMwMSJEwEAY8aMgbu7O44dO9asn6WlJTZs2IADBw5g3bp1+PTTT1FXV9epuRw8eBBXr15FfHw8IiMj8d577+HWrVuorq5GaGgoXn31Vbzwwgu4cOECnnvuuRbXKxQKLFiwQPeJcVxcHAoKClBUVHTPORkZGSE+Ph5btmwBcPuT/KCgINjZ2ent/6tf/QqZmZl46aWXMGDAAHz66aeIiorSrUlwdXXFpEmTAADjxo3DzZs3AQDp6el46KGHANz+5Do+Ph4//vgjvLy8kJ+fj1u3bkGhUOCpp55CZmYmVCoVTpw4AX9/f8ycORM7d+7E448/jsTERPzxj3+EpaVls7ysrKwwZ84cbN++HU1NTdixYwdiYmLg4uKCkSNHIjo6Gu+88w4mTpyI2bNnG/x+LFy4UPdJ+bZt21qMThm6D0PPf7f7ff31mTp1KgDgypUrEAQBQUFBAABnZ2cEBwdDoVAAAIYNG4axY8cCAIYOHQpvb2/IZDIMGDAA5ubmqKysNPgcSUlJePHFF/GPf/wDAwcOhCAIevv9ciTsftXW1uJ3v/sdioqK8PrrrwMAtFpti35SqbTVx/H29sYTTzyBp59+GjExMTA1NYWlpSVkMlmn5ktEdK9YbBD1YvreGGm12hZTKAoLCxEVFYXi4mJ4enri2WefNfim6l5pNBrExMRg27Zt2LZtG5KTk5GUlAQrKys89NBD2L59O3x8fPDjjz8iIiKixaLiX77REgQBgiDc93SQuLg47N+/H7W1tUhMTNS9mf6lrKwsfPnll7C0tMTs2bPxpz/9CTt27IBGo8GRI0cAAMbGxrr+EolE9z28M83q7tybmppgbGyMWbNm4dChQzh79iwWLVqEwsJCpKamwsvLC2ZmZvDw8EBaWhri4uKQn5+P2NhY5OTktMgvNjYW27Ztw8GDBzF27FgMGjQIxsbG+M9//oO//vWvsLGxwZtvvom3337b4Pdi8uTJqK+vx6VLl5CamooFCxY0ixu6D0PP/8tr7+f118fCwkKXxy/d/ffcxMSkWezu18kQrVaLN998Exs2bMDXX38NHx8fAICLi0uzTQUaGxtRVVUFR0fHNh9Tn3Xr1uk2Lbiz4LugoACLFy+GXC7H119/DSsrKwDAoEGDmj13SUmJbnqUITU1NfD29kZKSgq2bNmCwMBAmJiY6B6TiKi7sdgg6sU8PDxw+fJlnDlzBgBw8eJFnDx5EtOnT4dUKoVGo4EgCDhz5gwcHBzw5JNPwt/fHwcOHND7Kerd7r6+Pe3+/v74/vvvdWsGvv32Wzz22GMAbr9RvXTpEmJiYvDGG2/oPvG+m5+fH3bu3Ilbt24BuL1LlqOjI4YMGXLv3yAA9vb28Pf3x/r162FmZqYbBdLX76OPPtKtwwCA0tJSqFQqjB49utXn8PPzw7fffgsAUKlUSEhIwIwZMwAAc+bMwSeffIJx48ZBJpNh+vTpWLduHebNmwcAeOedd/Cvf/0LwcHBWL16NYYPH45r1661eA5PT0+oVCp88sknWLRoEYDb8/UjIiLw4IMP4sknn8SyZctw4cKFVnONiIjAG2+8gVGjRsHa2rrd96Hv+e92v69/a0aOHAlBEHQ7iBUXF2Pfvn263O7F66+/jtOnT2PLli26URHgdkFWWlqqK/gSExPh5eXVYrSpvVatWqUrwH7729+ioqICjzzyCEJDQ/Huu+9CLpfr+gYFBWH79u2or6+HSqVCSkoK5syZ0+rjFxUV4dFHH9UVbx999BHCwsLuKVcioq7Q9sc/RNRjDRw4EO+//z7+8pe/oLGxEUZGRvjb3/6GoUOHQq1WY/To0Zg/fz4SEhKQnJyMkJAQmJmZwd3dHTY2NsjLyzP42E5OTs2ub6s9ICAAy5cvx/LlyyGRSGBtba1b7PynP/0Jf/3rX/Huu+/CyMgIzz33HFxcXJo9X0BAAK5du4ZHHnkEgiDA3t4eH3/8MSQSyX1/nx566CEsWbKk1U/9R44ciQ8++ABr165FSUkJ5HI5rK2t8dZbb2HYsGEoKCgweO0rr7yCN954A2FhYVCr1Zg5cyZ+/etfA7j9Bv6FF17Aww8/rPt67969CAgIAAAsX74cL774IsLCwmBiYoJx48YhNDRU7/PExcXhs88+Q2BgIABgwoQJmDNnDqKjo2Fubg4zMzO8/PLLrX4vIiMj8cEHH+DTTz/t0H3oe/673e/r3xoTExNs2LABb731Ft5//31otVo8++yz8PLyQmZmZrsf546CggJ89913GDJkSLNNB1asWIGFCxfigw8+wOuvv46GhgbY29sbXGR+L/7zn/+gpKQEe/bswZ49e3TtGzduRHBwMC5duoTY2Fio1WoEBwcjPDy81ccbNWoUVqxYgbi4OGi1WkybNg0vvPBCp+VLRHS/JEJnz6UgIiIiIiICp1EREREREVEXaXMaVWJiIr755hvd1wUFBYiMjMScOXOwZs0aqFQqhIaGYtWqVQCA3NxcrF69GjU1NfD09MRrr73WrsV6RERERETUt3RoGtXly5fxm9/8Bl9//TWWLFmCjRs3wsXFBU888QSWLVuGgIAAhIWF4c0334SHhwdeeukluLm5YenSpV15D0RERERE1AN1aBrVX/7yF6xatQr5+flwdXXF0KFDYWxsjPDwcKSmpqKwsBANDQ26k1ejo6ORmpraJYkTEREREVHP1u5iIzMzEw0NDQgNDUVpaSkcHBx0MUdHR5SUlLRod3BwQElJSbsev6mpCQUFBfe9pz4REREREfUM7S42Nm3ahBUrVgDQf8DS3Qdc/bK9PYqLixEUFITi4uL2pkRERERERD1Yu4qNxsZGZGVlYfbs2QBu77N/5+Am4PbBV46Oji3ay8rK7vnUVSIiIiIi6t3aVWxcvHgRDzzwAMzNzQEA7u7uuHr1Kq5fvw6NRoMdO3Zg5syZGDx4MORyOU6cOAEASElJwcyZM7sueyIiIiIi6rHatSdtfn4+nJ2ddV/L5XK8/fbbeOaZZ6BSqRAQEICQkBAAwNq1a7F69WrU1tZi/PjxWLZsWddkTkRERD2KWq1GQ0MDNBoNpFIpTE1NIZPJujstIupGPeYE8YKCAgQFBSEtLQ1Dhgzp7nSIiIioA5RKJRQKBXJycqBWqyGTyeDu7g5/f39YW1t3d3pE1E142h4RERHdF6VSic8//xxKpVLXplarcfz4cVy6dEk3y8He3r7dG8cQUd/AYoOIiIjuiVqtRl5eHs6dO9es0LibUqlEZmYmpFIpcnJy4OzsDGdnZ7i4uMDFxQUDBw6EVCoVOXMiEguLDSIiIuqQhoYGZGVl4ciRI4iNjcXZs2db7X/mzBksWbIEWVlZyMvLQ15eni4mlUrh5OTUrABxcnKCsTHfohD1BfyXTERERO1SV1eHI0eO4NixY1CpVABun6elVqtbvU6tVhucPqXRaHDjxg3cuHFD1yaRSODg4AAXFxddEeLs7Ay5XN55N0NEomCxQURERK2qrq5GZmYmTpw40aKwEAQBMpms1YJDJpPpPfjXEEEQUFpaitLSUuTk5OjaBwwY0GwExNnZWbctPxH1TCw2iIiISK9bt24hIyMDp06dgkaj0dvnwoULcHNzQ3Z2tsHHmThxInJzc+87n5s3b+LmzZs4d+6crs3GxqbZCIiLiwssLS25EJ2oh2CxQURERM2Ul5cjPT0dp0+fbnNEIicnBw8//DCuXLmid5G4tbU1vLy88M0333RJrlVVVaiqqsKFCxd0bRYWFi0KEFtbWxYgRN2A52wQERERAKCoqAjp6ek4f/58h67z8PCAv78/jhw5glOnTunO2fDw8ICfnx+sra2h1WpRUVGBoqIi3X/FxcVoaGjoortpztTUtFnx4eLiAnt7exgZGYny/ET9FYsNIiKifi4vLw8KhQI//fRTh64bNWoU/P39MXToUAAdP0FcEARUVlbqCo87RUhtbe193U97yWSyFlvxOjg4cCteok7EaVRERET9kCAI+Pnnn6FQKHD9+vUOXTt+/Hj4+fnBxcWlWbtMJmu1uPgliUQCOzs72NnZYfz48bq8ampqmo1+FBUVoaqqqkM5todarUZ+fj7y8/N1bVKpFI6Ojs2mYTk5OXXovojof1hsEBER9SOCIODixYtQKBTNtptti0QiwaRJk+Dn54eBAwd2WX4SiQRWVlawsrLC6NGjde11dXW6wuPO/2/evNnpz6/RaHSFzt05OTg4tNgJi1vxErWNxQYREVE/oNVqce7cOaSnp6O0tLTd10mlUkyePBm+vr6wtbXtwgxbZ25ujhEjRmDEiBG6NpVKheLi4mZTsMrKyjq0zW573L0V7+nTp3Xt9vb2LRaicyteouZYbBAREfVhGo0GOTk5yMjIQEVFRbuvk8lk8PT0hI+PD6ysrLoww3snl8vh6uoKV1dXXZtarUZpaWmzaVglJSUGt+69HxUVFaioqGi2Fa+1tXWLAsTKyoo7YVG/xWKDiIioD1Kr1Th58iQyMzP1bklriKmpKaZNm4bp06f3yk/pZTIZBg8ejMGDB+vaNBoNysvLW6wDaevk83uhVCqhVCpx8eJFXZuFhUWLnbC4FS/1Fyw2iIiI+hCVSoWsrCwcOXKkQ7s6mZubw8fHB15eXn1uLYJUKoWTkxOcnJzg4eEB4PbUKH1b8dbX13f689fW1uLKlSu4cuWKrk0ul7cYARkwYIBuK96O7uxF1FOx2CAiIuoD6urqcPToURw7dqxDZ1dYW1tjxowZmDJlSr96MyuRSDBgwAAMGDAAbm5uAG4XIFVVVS1GQGpqajr9+VUqFa5du4Zr167p2mQyGcaOHQs/Pz8cO3YMp0+f1p1Z4u7uDn9/f1hbW3d6LkRdicUGERFRL1ZdXY3Dhw/j+PHjHZoWZGdnBz8/P7i7u/Ncif+SSCSwtbWFra0txo0bp2vXtxVvZWVlpz+/kZERpk2bhm+//bbZ1De1Wo3jx4/j0qVLWLlyJQsO6lVYbBAREfVClZWVyMjIQHZ2docWPzs4OMDf3x8TJkzg6dntZGlpiVGjRmHUqFG6tvr6+ma7YBUXF6O8vPy+nsfd3R0nT540uMZGqVQiPT0dwcHB/WoUino3FhtERES9SHl5OdLT03HmzBlotdp2Xzdo0CD4+/tjzJgxXJjcCczMzDB8+HAMHz5c19bY2Kh3K972vk5jx47Fd99912qfU6dOwd/fn8UG9RosNoiIiHqB4uJiKBQKnD9/vkPXubq6wt/fHyNGjGCR0cVMTEwwbNgwDBs2TNfW1NSkdyvepqamFtdLJJI2p8Kp1eou2caXqKuw2CAiIurB8vPzoVAocPny5Q5d9+CDD8Lf37/ZG18Sn7GxMQYNGoRBgwbp2rRard6teAVBgEwma7XgkMlkLBqpV2GxQURE1MMIgoCrV69CoVA0262oPcaNGwd/f3+4uLh0TXJ034yMjODo6AhHR0e4u7sDuP2aK5VKTJo0CSdOnDB47cSJE3Hu3Dl4e3tzzQ31Ciw2iIiIeghBEHDp0iUoFAoUFha2+zqJRIKJEyfCz88PDg4OXZghdRWJRAIbGxvMnDkTly9f1rtI3NraGpMnT8bGjRtRX1+PoKCgbsiUqGNYbBAREXUzrVaL8+fPIz09HSUlJe2+TiqVwsPDA76+vrCzs+vCDEks1tbWWLlyJdLT03Hq1CndORsTJ07E5MmTsX37djQ2NiI9PR3Dhg1rtkMWUU8kEQRB6O4kAKCgoABBQUFIS0vDkCFDujsdIiKiLqfRaHD69Gmkp6ejoqKi3dfJZDJMnToVPj4+PHOhj7pzgnhtbS3q6+uRm5uLnJwcNDY26vqYmZnhiSeegI2NTTdmStQ6jmwQERGJTK1WIzs7G5mZmaiqqmr3dXK5HNOmTcP06dNhYWHRhRlSd5PJZJDJZLC0tMS3336LK1eutOhTX1+PLVu24NFHH+XBjNRjsdggIiISiUqlwvHjx3H48GHU1ta2+zpzc3N4e3vDy8sLpqamXZgh9TQSiQRRUVH45JNPUF1d3SKen5+P/fv3Izg4uBuyI2obiw0iIqIuVl9fj6NHj+Lo0aNoaGho93VWVlaYMWMGpkyZAhMTky7MkHoyCwsLxMTE4Ouvv4a+2e+ZmZlwdXXF6NGjuyE7otax2CAiIuoiNTU1OHz4MI4fP95srn1b7Ozs4OvrC3d3dxgb81c13T6ccfbs2UhLS9MbT0lJ4foN6pH4E4yIiKiTVVVVISMjA9nZ2XpPijbEwcEBfn5+cHNz4xkK1IKvry/y8vL0HvBYX1+PpKQkLF++nOs3qEdhsUFERNRJbt68ifT0dJw+fRparbbd17m4uMDf3x9jx47l6dBkkEQiwcKFC/HJJ5/oPYejoKAA+/btw7x587ohOyL9WGwQERHdp5KSEigUCpw/f17vnHpDhg0bBn9/f4wcOZJFBrWLubk5YmNj8dVXX+ktaI8cOQJXV1eMHTu2G7IjaonFBhER0T0qKCiAQqHApUuXOnTdyJEj4e/vD1dX1y7KjPqyoUOHIigoCD/88IPe+LZt2+Ds7AxbW1uRMyNqicUGERFRBwiCgGvXrkGhUODq1asdunbs2LHw9/fHoEGDuig76i98fHxw/fp1vYVuQ0MDkpKSsGLFCq7foG7HYoOIiKgdBEHA5cuXoVAoUFBQ0O7rJBIJ3Nzc4OfnB0dHxy7MkPqTu9dv6DsYsrCwED/88ANCQkK6ITui/2GxQURE1AqtVovc3FwoFAqUlJS0+zojIyN4eHjA19cX9vb2XZgh9VdmZmaIjY3Fl19+qXf9xtGjR+Hq6opx48Z1Q3ZEt7Wr2Ni/fz8+/PBD1NXVwc/PD6tXr0ZmZibWrFkDlUqF0NBQrFq1CgCQm5uL1atXo6amBp6ennjttde4RzgREfU6Go0GZ86cQXp6Om7evNnu64yNjTF16lTMmDED1tbWXZghETBkyBDMmTMHe/fu1Ru/s37Dzs5O5MyIbmtzE+/8/Hy8+uqr2LBhA77//nucP38ehw4dwksvvYQNGzZg165dOHv2LA4dOgQA+MMf/oCXX34Ze/bsgSAISEhI6PKbICIi6ixNTU3IysrCBx98gG3btrW70JDL5fDz88Nzzz2HkJAQFhokGm9vb4O7T6lUKiQmJnbovBeiztRmsfHDDz9g/vz5cHZ2hkwmw7p162BmZgZXV1cMHToUxsbGCA8PR2pqKgoLC9HQ0AAPDw8AQHR0NFJTU7v8JoiIiO6VWq1GdXU1KisrUVpaikOHDiEtLU3vPHh9zMzMEBgYiOeeew5BQUGwsLDo4oyJmpNIJIiIiDC4+1RRUZHBkQ+irtbm/Kbr169DJpNh5cqVKCsrQ2BgIEaNGgUHBwddH0dHR5SUlKC0tLRZu4ODQ4fmtxIREYlJqVRCoVAgJycHarUaMpkMbm5uePjhh7F9+3aUlZUZvNbKygo+Pj6YOnUqTExMRMyaqKU76ze++OILves3srKy4OrqigkTJnRDdtSftVlsaDQaHD9+HBs3boS5uTmefvppmJmZtegnkUj0HmTEQ4qIiKgnUiqV+Pzzz5udxKxWq5GdnY0rV64gLi4OGzduRGNjY7PrbG1t4evrCw8PD65JpB5l8ODBmDt3rsFZJdu3b4eLiws3LCBRtTmNauDAgfDx8YG9vT1MTU0RFBSEjIwMlJeX6/qUlpbC0dERTk5OzdrLysq4zR8REfU4arUaCoWiWaFxN6VSiezsbLi7u+vaBg4ciIULF+KZZ56Bp6cnCw3qkaZNm2Zw96nGxkau3yDRtVlsBAYGIj09HUqlEhqNBgqFAiEhIbh69SquX78OjUaDHTt2YObMmRg8eDDkcjlOnDgBAEhJScHMmTO7/CaIiIg6ora2Fjk5Oa32OXPmDMaNGwdnZ2fExcXh6aefhru7O4yM2vzVSdRt7qzfMLT7VHFxMdfTkqja/FjG3d0dv/rVr7B06VKo1Wr4+vpiyZIlGDFiBJ555hmoVCoEBAToDo1Zu3YtVq9ejdraWowfPx7Lli3r8psgIiJqrzsLwtVqdZv9rKys8Pjjj3NKMPUqpqamuvUbGo2mRfzEiRNwdXXFxIkTuyE76m8kgr6FFt2goKAAQUFBSEtLw5AhQ7o7HSIi6oMEQUBycjKmTJmC7777rtWCQyaT4ZlnnoGVlZWIGRJ1nmPHjmH37t16YyYmJnj88ccxYMAAkbOi/oZjwURE1G8cPnwYZ8+exYULF+Dm5tZqXw8PD5iamoqUGVHn8/Lywvjx4/XG7qzfaGuEj+h+sdggIqJ+4cqVK9i3bx8AICcnB1OmTDF48J61tTX8/Pwgk8nETJGoU91Zv2Fo96mSkhKu36Aux2KDiIj6vIqKCiQlJem2aFepVNi+fTvi4uIwZcoUXVEhk8ng5eWFlStX8gRw6hPkctPWGVUAACAASURBVDni4uIglUr1xk+ePInTp0+LnBX1J9y3j4iI+rTGxkZs3rwZDQ0NzdrLysqwceNG+Pn54be//S20Wi2kUilMTU05okF9irOzM0JCQrBz50698R07dmDQoEEYOHCgyJlRf8CRDSIi6rMEQUBKSgpKS0v1xo2NjTFp0iRYW1vD1tYWVlZWLDSoT5o6darBdUpqtZrrN6jLsNggIqI+S6FQIDc3V2/MyMgIcXFxsLGxETkrIvFJJBKEhYUZ3H2qtLQUu3btEjkr6g9YbBARUZ906dIlHDhwwGB83rx5eOCBB8RLiKib3Vm/YWysfxb9qVOn2jzskqijWGwQEVGfU15ejuTkZINxDw8PeHl5iZgRUc/g5OSE0NBQg/GdO3eirKxMxIyor2OxQUREfUpDQwM2bdoElUqlNz548GAsWLCAp4JTvzV58mRMmjRJb+zO+o3GxkaRs6K+isUGERH1GYIgYOvWrbh586beuKWlJeLj4w1OIyHqDyQSCRYsWGBw96mysjLs2rVLt1U00f1gsUFERH3GwYMHcenSJb0xIyMjLFq0CFZWViJnRdTzmJiYtLp+IycnB6dOnRI5K+qLWGwQEVGfkJubix9//NFgfMGCBRg6dKiIGRH1bI6Ojpg/f77B+K5du1BSUiJiRtQXsdggIqJer7S0FFu3bjUY9/T0xJQpU0TMiKh3mDx5Mtzd3fXGmpqakJSUxPUbdF9YbBARUa9WX1+PTZs2GTyQbNiwYQgJCRE5K6LeY/78+XBwcNAbKy8vx44dO7h+g+4Ziw0iIuq1tFottmzZglu3bumNW1tbIy4uDlKpVOTMiHqPO+s3ZDKZ3viZM2dw8uRJkbOivoLFBhER9VppaWm4cuWK3phUKkV8fDwsLS1Fzoqo93FwcMCCBQsMxnfv3o3i4mIRM6K+gsUGERH1SmfOnEFmZqbBeHh4OAYNGiRiRkS9m7u7OyZPnqw3ptFokJiYaPD8GiJDWGwQEVGvU1RUhO3btxuMT58+3eCiVyIyLDQ0FI6OjnpjFRUV+P7777l+gzqExQYREfUqtbW12Lx5M5qamvTGhw8fjrlz54qcFVHfIJPJWl2/ce7cOZw4cULkrKg3Y7FBRES9hkajQVJSEqqqqvTGbW1tERsbCyMj/nojulcDBw5EeHi4wXhqaiqKiopEzIh6M/40JiKiXmPv3r24du2a3pixsTHi4+Nhbm4ublJEfdDEiRMNnk1zZ/1GQ0ODyFlRb8Rig4iIeoVTp07h2LFjBuORkZFwdnYWMSOivi0kJAROTk56Y7du3eL6DWoXFhtERNTjFRYWYseOHQbjvr6+cHNzEzEjor7vzvoNExMTvfHz588jKytL5Kyot2GxQUREPVpNTQ02b94MjUajN/7ggw9i9uzZImdF1D8MGDCg1fUbe/fuxY0bN0TMiHobFhtERNRjaTQaJCQkoLq6Wm/c3t4e0dHRXBBO1IXc3Nzg6empN8b1G9QW/nQmIqIea/fu3cjPz9cbMzExQXx8PMzMzETOiqj/mTdvnsE1UZWVldi2bRvXb5BeLDaIiKhHOn78eKv7+UdFRRk8fIyIOpexsTHi4uIgl8v1xi9cuICjR4+KnBX1Biw2iIiox8nLy8Pu3bsNxgMCAjB27FgRMyIie3t7REREGIz/8MMPKCwsFDEj6g1YbBARUY+iVCqRkJAArVarNz5mzBgEBASInBURAcD48eMxbdo0vTGtVovExETU19eLnBX1ZCw2iIiox2hqasLmzZtRW1urNz5w4EBERUVBIpGInBkR3REcHIxBgwbpjVVVVXH9BjXDYoOIiHoEQRCwY8cOg9toyuVyLF682OCccSISh7GxMWJjYw3+W7x48SKOHDkiclbUU7HYICKiHuHYsWPIyckxGI+JicGAAQNEzIiIDLGzs0NkZKTB+L59+1BQUCBiRtRTsdggIqJud/XqVezZs8dgfPbs2Rg1apSIGRFRW8aNG4fp06frjd1Zv1FXVydyVtTTsNggIqJuVVlZicTERINzvMePHw8/Pz+RsyKi9ggODsbgwYP1xpRKJVJSUrh+o59jsUFERN1GrVZj8+bNBnevcXR0RGRkJBeEE/VQUqkUsbGxMDU11Ru/fPkyMjMzRc6KehIWG0RE1C0EQcD27dtRXFysN25mZobFixfDxMRE5MyIqCNsbW2xcOFCg/G0tDTk5eWJmBH1JO0qNpYtW4YFCxYgMjISkZGRyMnJwffff4/58+cjODgY3377ra5vZmYmwsPDMXfuXKxbt67LEiciot4tMzMTZ8+e1RuTSCSIjY2FnZ2dyFkR0b0YM2YMfHx89MYEQUBSUhLXb/RTxm11EAQBP//8Mw4ePAhj49vdS0pKsGrVKiQnJ8PExASLFy/G9OnTMWTIELz00kvYuHEjXFxc8MQTT+DQoUM8fImIiJr56aefkJaWZjAeHByMESNGiJgREd2voKAg5Ofn692Fqrq6Glu3bsXSpUs5LbKfaXNk4+eff4ZEIsGvf/1rRERE4JtvvkFmZia8vb1ha2sLc3NzzJs3D6mpqTh9+jRcXV0xdOhQGBsbIzw8HKmpqWLcBxER9RIVFRXYsmWLwUWjkyZNgre3t8hZEdH9urN+w8zMTG/8p59+Qnp6ushZUXdrs9hQKpXw8fHBRx99hK+++gqbNm3CjRs34ODgoOvj6OiIkpISlJaW6m0nIiICAJVKhU2bNqGhoUFv3MXFBWFhYfzkk6iXsrGxQVRUlMH4gQMHcP36dREzou7WZrExefJk/O1vf4O5uTns7e0RGxuLf/zjHy36SSQSvZ9S8RcGEREBt6flpqSkoKysTG/c3Nwc8fHxkMlkImdGRJ1p1KhR8PX11Ru7s36jtrZW5Kyou7RZbBw/fhyHDx/WfS0IAgYPHozy8nJdW2lpKRwdHeHk5KS3nYiISKFQ4MKFC3pjRkZGWLRoEWxsbETOioi6QmBgIIYOHao3VlNTg+TkZJ6/0U+0WWxUV1fjb3/7G1QqFWpqarB161b8/e9/x+HDh1FRUYH6+nrs3bsXM2fOhLu7O65evYrr169Do9Fgx44dmDlzphj3QUREPdjFixdx4MABg/F58+bB1dVVxIyIqCvdWb9hbm6uN/7zzz9DoVCInBV1hzZ3owoMDEROTg4WLlwIrVaLpUuXYurUqVi1ahWWLVsGtVqN2NhYTJo0CQDw9ttv45lnnoFKpUJAQABCQkK6/CaIiKjnKi8vR3JyssH45MmT4eXlJWJGRCQGa2trREVFNTsi4W4HDx7E0KFDMXz4cJEzIzFJhB4yhlVQUICgoCCkpaVhyJAh3Z0OERF1goaGBnz22We4efOm3viQIUPw6KOP6rZWJ6K+Jy0tzeAuVJaWlnjiiSdgaWkpclYkFp4gTkREXUIQBCQnJxssNCwtLbFo0SIWGkR9XGBgoMFpknfWb2i1WpGzIrGw2CAioi5x4MABXL58WW9MKpVi0aJFsLKyEjkrIhKbkZERYmJiDK7fuHr1Kn788UeRsyKxsNggIqJOd/78+VYXf86fP9/gTjVE1PdYWVkhOjraYPzQoUP4+eefRcyIxMJig4iIOlVJSQlSUlIMxj09PTFlyhQRMyKinmDkyJGt7lKanJyM6upqETMiMbDYICKiTlNfX4/NmzdDrVbrjQ8bNoy7FBL1YwEBAXjggQf0xmpra7l+ow9isUFERJ1Cq9UiKSkJt27d0hu3trZGXFwcpFKpyJkRUU9xZ/2GhYWF3vi1a9dw8OBBcZOiLsVig4iIOsW+ffsMzrk2NjZGfHw8t7ckIlhaWiImJsZgXKFQ4MqVKyJmRF2JxQYREd23M2fO4PDhwwbjYWFhGDRokIgZEVFPNnz4cAQEBBiMJycnQ6lUipgRdRUWG0REdF+Kioqwfft2g3Fvb2+4u7uLmBER9QYzZ87EiBEj9Mbq6uqwZcsWrt/oA1hsEBHRPautrcXmzZvR1NSkNz58+HAEBweLnBUR9QZGRkaIiooyOL0yLy8PBw4cEDkr6mwsNoiI6J5oNBokJiaiqqpKb9zW1haxsbEwMuKvGiLS7876DYlEojeenp5u8HBQ6h34G4CIiO7J3r17cf36db0xmUyG+Ph4gycGExHd8cADD2DWrFkG41u3bjX4oQb1fCw2iIiow7Kzs3Hs2DGD8cjISDg7O4uYERH1Zv7+/hg5cqTeWH19PbZs2QKNRiNyVtQZWGwQEVGHFBQUYOfOnQbjvr6+mDBhgogZEVFvJ5FIEBUVBSsrK73x/Px87N+/X+SsqDOw2CAionarrq5GQkKCwU8YH3zwQcyePVvkrIioL7CwsGh1/UZmZiYuXbokclZ0v1hsEBFRuzQ1NSEhIQHV1dV64/b29oiJieGCcCK6Z66urq1+YJGSktLh9RsqjRoV9TUoq+O5Hd2BvxGIiKhddu/ejYKCAr0xExMTLF68GKampiJnRUR9ja+vL0aNGqU3Vl9fj6SkpHav36ior8G/T/+I3+79Ak+mftaZaVI7sdggIqI2HT9+HCdPnjQYj4qKgoODg4gZEVFfJZFIsHDhQlhbW+uNFxQUYN++fQav1whalNZWobimEn8++B1Sr+ZApdF/FhB1PePuToCIiHq2vLw87N6922A8ICAAY8eOFTEjIurrzM3NERsbiy+//BKCILSIHz5yBBbOA2HuZI/i2koU1VSiuKYSxbWVKK2tQvDwSWjUNqG8Xv+0TxIPiw0iIjJIqVQiISEBWq1Wb3zMmDEICAgQOSsi6g+cBrnAI8AHB08cRaPcCI0mRlCZ3P5/o4kEZ64cAq7ov9Z78Cj8NXOruAmTXiw2iIhIr6amJmzevBm1tbV64wMHDkRUVJTBnWOIiNrS0KRGce3/RiWK/vv/4ppK3KyvhgAAD3T8cFAJJJw61UOw2CAiohYEQcCOHTtw48YNvXG5XI7FixdDLpeLnBkR9Ta1alXzYuKuP1eq9H+Ycb8ECJBLjVlw9AAsNoiIqIWjR48iJyfHYDwmJgYDBgwQMSMi6qkEQUB1YwOKa2+huKaqxQiFsrFe9JyOFF6G39CxSLt2VvTnpuZYbBARUTNXr17F3r17DcaDgoIMbktJRH2TIAioVNWhuKYSRXdNe7rzdZ1a1d0pNpNVdAV/8olATsl1LhLvZiw2iIhIp7KyEomJiXp3fwGA8ePHw9fXV+SsiEgMWkFARX0Nimpv3VVMVOmKigaNurtTbEbapIVcJcCkUQt5oxaO5tZYPD8Sg20GwMrEDADw11lLkHzxKA5cP8cpVd2ExQYREQEA1Go1Nm3ahPp6/VMeHB0dERkZyQXhRL2YRqtFeX11ixGKoppKlNRWQq1t32F5YrE3tYCzpS2cLWzhYmkHO5kZMlLT0HizCtIWm+SV4+es0xg7f76uZYCZJR6dOBNzHpgISxMeOtodWGwQEREEQcC2bdtQUlKiN25mZobFixfDxMRE5MyIqKPUWg3KapXNRijurKEoq1WiSdC/lXV3kAAYYGYFl/8WFM6WtnD57/+dLGxhaixrcc3oSHt88cUX0KLlfWRlZcHV1RUTJkzQtZlIZTA1lsHBXP8hgdS1WGwQEREyMzNx7tw5vTGJRILY2FjY2dmJnBVR/6XSqFHbqIJG0EIqMYKFiRxyqaxZvLRWqXeEorxOCS30T4XsDkYSCRzNrf9XTFja3f6zhQ0cLWxgIu3Y29HBgwdj7ty5SE1N1Rvfvn07XFxcYG9vr2tzseTPr+7CYoOIqJ/76aefsG/fPoPx4OBgjBgxQsSMiPq3ivoabLlwFAfybq8zkEuNETBsHEJHTMb2y8dxuiwPN+trujvNZoyNpHCysIGzhU2LEQoHc2sYG0k79fmmTZuG69evIzc3t0WssbERiYmJWLlyJYyN+Va3u/EVICLqxyoqKrBlyxaD8UmTJsHb21vEjIj6t4r6Gvz54HfNdlBSaZqw9+oZnCy+huenh+HIjZ+6JTcTqfEvigm72+spLG0xwMwSUomRaLlIJBJERESguLgYt27dahEvLi5GamoqwsLCRMuJ9GOxQUTUT6lUKmzatAkNDQ164y4uLggLC+OCcCKRqDRqJF04anCr1vL6aqRdO4tZw8Zj98+nuiQHM2OTFiMTzhY2cLa0hZ2pJYx60M8DU1NTxMbG4osvvoBG03Jh+4kTJ+Dq6oqJEyd2Q3Z0B4sNIqJ+SBAEpKSkoKysTG/c3Nwc8fHxkMlaLs4koq5RVleNg3n6107docjPxZ99Ft5XsWFpYqp3hMLFwhbWcrNe9QHDoEGDMHfuXOzevVtvfMeOHXBxccHAgQNFzozuYLFBRNQP/fjjj7hw4YLemJGRERYtWgQbGxuRsyLqn1RNanyWsx+zhk1o8ywIlaYJRu2YrmQjN//vdrHNd3lysrTRnUHRV3h5eeH69es4f/58i1hjYyOSkpKwcuVKfnjSTVhsEBH1MxcvXsTBgwcNxkNCQuDq6ipeQkT9WGF1BdYe/R55ypsIGDYecqlxqwWHXGoM7X+3rrU3tWxWTDjfNe3JXCYX6xa63d3rNyoqKlrES0pKkJqaivDw8G7IjlhsEBH1I2VlZUhOTjYYnzx5Mjw9PUXMiKj/UuTn4p8n9+lO5j5SeBl+Q8ci7dpZg9fMGjYeThbW+E/EM5DrOYOiv5LL5YiLi8Nnn32md/3GyZMnWWx0E/G2DSAiom7V0NCATZs2obGxUW98yJAhmD9/fq+ar03UGzVqmvBJ9j68n7VbV2gAwKG885jzwEQMNLPSe91AMyvEjvWGo4UtCw09nJ2dERIS0qxNLpdj2rRpWLZsGSorK7sps/6t3cXGO++8gxdffBEAkJubi5iYGMybNw//93//h6am28N9N27cwEMPPYSQkBA89dRTqK2t7ZqsiYioQ7RaLZKTk/VOMQAAS0tLLFq0iHvSE3WxoppbeOngJuy9erpFrK6pERtO7sXz08MQ/MBEyP972J1caozQER5YM2sJ7M0sxU65V5k6dSrc3NwAAA4ODnj44YehVqvx3XffYf369d2cXf/UrmLj8OHD2Lp1q+7rP/zhD3j55ZexZ88eCIKAhIQEAMBrr72GpUuXIjU1FW5ubtiwYUPXZE1ERB1y8OBBXL58WW9MKpUiPj4eVlb6P00los5xuPAS/rj/W1ytKjXYJ195E2lXz+ARt5n4cO5j+GfIr/Dh3MewbKI/C412kEgkCAsLg4uLCyIiIpCYmIjs7Gyo1eq2L6Yu0WaxUVlZiXXr1uHJJ58EABQWFqKhoQEeHh4AgOjoaKSmpkKtViMrKwvz5s1r1k5ERN3r/PnzUCgUBuPz58/HkCFDRMyIqH9Ra5rwec5+rD26A3VN+qcxAoDMSIonJ8/Bk1OCYWEih72ZJRzMrWFvZgkTKadNtZdcLkdsbCxOnjwJpVLZ3en0e22Ol7/yyitYtWoVioqKAAClpaVwcHDQxR0cHFBSUoJbt27B0tJSNwR/p52IiLpPSUkJUlJSDMY9PT0xZcoUETMi6l9Kaqvw3rEd+OlW6++JnC1s8cL0MAy3dRQps75NJpPh7FnDC+1JPK2ObCQmJsLFxQU+Pj66NkEQWvSTSCQG24mIqHvU19dj06ZNBqcPuLq6tlhMSUSd59iNn/CH/d+0WWj4DB6Nv89+iIVGJ9JoNJw61UO0OrKxa9culJWVITIyElVVVairq4NEIkF5ebmuT1lZGRwdHWFvb4+amhpoNBpIpVJdOxERiU+r1SIpKcng7ivW1taIi4uDVCoVOTOivq9Jq8E3Z9Px/U8nWu1nbCTF8okBCBnhzg9oO5lUKoVMJmPB0QO0Wmx8+eWXuj8nJyfj2LFjWLNmDcLCwnDixAlMnToVKSkpmDlzJmQyGTw9PbFr1y6Eh4fr2omISHz79u3Dzz//rDdmbGyM+Ph4WFhYiJwVUd9XXleN947twMWKolb7OZrb4PnpC/CgnbNImfUvpqamcHd3x/Hjx7s7lX7vnvY4XLt2LVavXo3a2lqMHz8ey5YtAwC8+uqrePHFF/Hxxx/DxcUF7733XqcmS0REbTt9+jQOHz5sMB4eHo5BgwaJmBFR/3Cy+Cr+cXw3qhsbWu03zWUkfjt1HixMTEXKrP+RyWTw9/fHpUuXuEi8m0kEfYstukFBQQGCgoKQlpbGXVGIiO5RUVERvvjiC935R7/k7e2t2zWQiDqHRqvFd+czsPVSVqv9pBIjLJs4EwtGTua0KZEolUqkp6fj1KlTUKvVePXVV7s7pX6HpzcREfURtbW12LRpk8FCY/jw4QgODhY5K6K+raK+BuuyduJ8eWGr/QaaWeH56Qsw2p6jimKytrZGcHAwZsyY0d2p6PXYY49h7dq1sLe37+5UugyLDSKiPkCj0SAxMdHgdAFbW1vExsbCyKhdZ7kSUTvklFzH+8d3Qamqb7XfVOfheGZqCKzkZiJlRneTyWSwtbXt7jT0ysjI6O4UuhyLDSKiPmDPnj24fv263phMJsPixYthbm4uclZEfZNG0CIx9wiSLhxBa3PRjSQSPDTBDxGjPGHEaVP0C3/+858BAP7+/mhqakJubi6MjIxQX1+P2bNnY8eOHYiLi8OcOXNw/PhxVFdXY8WKFVi6dCkAYP/+/fj444+hVqthamqKP/3pT5g8eXJ33pJeLDaIiHq57OxsZGUZniseGRkJJycnETMi6rtuNdRifdYunCnLb7WfvakFfj8tDOMGDhYpM+pt1qxZg+TkZCgUCqxYsQIKhQIBAQHYuXMnfHx8MGDAAABAQ0MDtmzZgpKSEixcuBBTp06FXC7HunXr8O9//xt2dna4fPkyVqxYgb179/a4D5ZYbBAR9WIFBQXYuXOnwbifnx8mTJggYkZEfdfZsnysO7YLlaraVvu5O7riWa9Q2Mh71ps+6rkeeughJCQkICAgAJs3b8Yf//hHXWzp0qWQSCRwdnaGv78/MjIyIJfLUVpaiuXLl+v6SSQS5OXlYezYsd1wB4ax2CAi6qWqq6uRkJAAjUajN/7ggw8iMDBQ5KyI+h6tICD54jFsPp8JbSsTp4wgQfx4H0SPmc5pU9Qh4eHheO+993DkyBHU1dXBy8tLFzM2/t/bda1WCyMjI2i1Wvj4+OD999/XxYqKinrkgdpcKUhE1Muo1WoolUpUVVUhKioK06ZNg1wub9bH3t4eMTExXBBOdJ+qVHV4KyMZ353PaLXQsJWb4xX/GMSO9WahQe0mlUrR1NQEMzMzRERE4KWXXsLixYub9UlJSQEA3LhxAxkZGZg5cya8vb2RkZGBK1euAAAOHTqEiIgIqFQq0e+hLRzZICLqRZRKJRQKBXJycqBWqyGTyeDm5oaHH34Y27dvR1lZGUxMTLB48WKYmvLAMKL7kVteiPeO7URFQ02r/dwchuI5r/mwM7UQKTPqK4KDg7F06VJs2LAB0dHRSEhIwMKFC5v1KSgoQHR0NBoaGrB69WqMGDECAPD666/j97//PQRBgLGxMT7++OMet14DYLFBRNRrKJVKfP755822t1Wr1cjOzsaVK1cQFxeHjRs3IioqCg4ODt2YKVHvphUEbL98HN+eS4e2lbOPJQBixk7HonE+kEo4ikgdt379egCAIAj417/+hcjISFhZWTXrs3LlSkycOLHFtaGhoQgNDRUlz/vBYoOIqBdQq9VQKBQGz9FQKpXIzs5GVFRUj1scSNSbVKvq8cGJVJwovtpqP2u5GZ71DIWH0wPiJEZ9WlBQEOzt7fHxxx93dyqdjsUGEVEvUF9fj5ycnFb7nDlzBrNmzRInIaI+6FLFDbx7dCfK66tb7TduwGCsmjYfA8ysWu1H1F779+/vUHtvwmKDiKiHq66uhlKphFqtbrWfWq02uDMVERkmCAJ2XsnGv8/8CI2gbbVv1GgvLBnvCyk3XyBqFxYbREQ9WH5+PhISEhAdHQ2ZTNZqwSGTySCVSkXMjqj3q21swEcn9+LojZ9a7WdpYorfeYZgqvMIkTIj6htYbBAR9VAnT57Erl27oNFocOHCBbi5uSE7O9tgfw8PD+5ARdQBV26VYO3RHSitq2q132h7F/x+2gI4mFuLlBlR38Fig4ioh9FoNNizZw+ysrJ0bTk5OXj44Ydx5coVvYvEra2t4efnB5lMJmaqRL2SIAhI/TkHX505hCZt61MPwx+ciofc/CAz4qgh0b3ghEMioh6ktrYW33zzTbNCAwBUKhW2b9+OuLg4TJkyRVdUyGQyeHl5YeXKlbC25qeuRG2pU6vw3rGd+Cxnf6uFhrlMjj96R2D5pAAWGiSagoICjBkzBq+88kqz9tzcXIwZMwbJyckdery0tDTd9rrdhSMbREQ9RHFxMTZt2oSqKv1TOsrKyrBx40ZER0dj1qxZ0Gg0kEqlMDU15YgGUTtcqyzD2mPfo6imstV+I22d8Pz0MDhZ2IiUGdH/2NraQqFQ6H7GA8CuXbtgb2/f4ccKCgpCUFBQZ6fYISw2iIh6gLNnz2Lbtm1oamoy2MfExATR0dEYM2aMiJkR9X6CIGDftTP4POcA1G1Mm5o/0gPL3GZCJuVbJOoeFhYWGDt2LLKysuDt7Q0AyMjIwIwZMwAABw4cwPvvvw+tVouhQ4fi9ddfR05ODhISEvDJJ58AAL755htcu3YN48ePx7Fjx/D222/j9OnTWLNmDRoaGmBnZ4fXXnsNQ4cO7fL74b8kIqJupNVqsX//fmRkZLTaz97eHosXL+bJ4EQdVN/UiE+z0/Bjfm6r/cyMTfD0lLmYMWS0SJlRT5OTk9PqJhz3Y/LkyXB3d293/9DQUOzZswfe3t44ffo0xowZA0EQcPPmTaxbtw7fffcdhgwZgs8++wyvv/463n33Xbz66quoqqqCjY0NduzYgZdeegk//XR7l7XGxkasXr0a//znPzFo0CAoFAq8/PLL+Oqrr7rkfu/GYoOIqJs0NDRgy5Ytul8Ghjz44IOIiYnhTlNEHSrXUAAAIABJREFUHZSnLMfaoztQWF3Rar/hNg74/fQwDLK0EykzotYFBgbqRi92796N0NBQ7Nq1C2ZmZpg0aRKGDBkCAIiPj8enn34KmUyGuXPnYu/evZgxYwYqKysxadIk3e+Xa9euIT8/H0899ZTuOWpqakS5FxYbRETdoLy8HJs2bcLNmzdb7efr64vZs2fDiAeIEXXIgevn8OmpNDRqDE9NBIC5wydhxaRZMOG0qX7P3d29Q6MPXcnS0hJjx47FiRMncOTIETz//PPYtWsXtNrmh04KgqCbfhsREYH169ejqqoKYWFhzfpptVoMGTIE27ZtA3B718Py8nJR7oW/vYiIRHbp0iV89tlnrRYaxsbGiImJwZw5c1hoEHWAqkmNj07swYcn9rRaaJhKZXjOKxRPTJ7DQoN6pNDQULz77rtwc3ODsfHtv6MNDQ3IyclBQUEBAGDz5s2YPn06gNtnLZWWlmLbtm2IjIxs9lgjRoxAVVUVjh8/DgDYsmULXnjhBVHug/+6iIhEIggCFAoFDhw40Go/GxsbxMfHw8XFRaTMiPqGguoKvHv0e+QpWx8xHGY9AM9PD8cQq47v7kMklsDAQPzf//0fnn32WV3bwIED8frrr+O3v/0t1Go1Bg0ahLfeeksXDw0NRXp6eouF3yYmJli/fj3eeustqFQqWFpa4p133hHlPiSCIAiiPFMbCgoKEBQUhLS0NN08NCKivqKxsRHbtm3D+fPnW+3n6uqKuLg4WFhYiJQZUd+gyM/FP0/uQ4NG3Wq/2a4T8Cv32ZAbc7toIjFwZIOIqIvdunULmzdvRklJSav9vLy8MG/ePN2+6kTUtkZNE77IOYAfrp1ptZ+J1Bi/9gjCbNcJImX2/+3deVhU970/8PfszLAjDLsoi6hBwSVoGpVoXEHEQIwkbWyam9T0ZmsesxqzNk3sbdo0Xm9ze9vm9hdvGqPRuOGSBo1xSdQgYIga2QVk35fZ5/z+QEcRGBmdGQZ4v57HR2f4njOfc2SZN9+NiACGDSIihyotLcXWrVuh0Wj6bSMWi5GSkoKpU6c6sTKioa+6oxl/OLEHpa31VtuFevrh2cSlGO3t76TKiOgKhg0iIgcQBAEnTpzAF198AWujVT08PHDfffc5ZWMlouHkeOUF/Pn0F9AY9VbbzQkfj19OmQ+lVO6kyojoWgwbRER2ZjQasWfPHuTn51ttFxISgpUrV8LLy8tJlRENfQaTEf/v+6+xryTPajuZWIJ/i5+L+WMmQSQSOak6IroewwYRkR21t7fj008/RVVVldV28fHxWLp0qWU5QyK6sdrOVvzhxB4Ut1if/xTk7oNnZyzFWB+1kyojov7wpxwRkZ1UVFRgy5YtVndlFYlEWLhwIWbMmMHfthLZ4OSlImzMOYBOg85qu5+EjsOvpi6ASqZwUmVEZA3DBhGRHeTm5iIrKwsmk6nfNkqlEvfeey8iIyOdWBnR0GY0m/B/BUexuyjHajupWIJfTErCosh4BnkiF8KwQUR0C0wmEw4cOIBTp05ZbadWq5GZmQlfX18nVUY09NV3teGPJ7Nwoanaaju1yhtrZqQg2jfISZUR2d8bb7yB06dPw2Aw4OLFi4iKigIApKen409/+hP279+PwMBAS/uTJ0/inXfeweeff97jPCdOnMAf//hHaDQamEwmJCUlYc2aNZBIJHjwwQfxxBNPWHYddwaGDSKim9TZ2YnPPvsMZWVlVttNnDgRaWlpkMu5Gg7RQOVUl2BDzn506LVW2yUGR+GJaYvgLndzUmVEjvHaa68B6N7oetWqVdi5c6flYz/88AOysrLw8MMPW57bsWMHMjIyepxDr9djzZo1+OSTTxAeHg69Xo+nnnoKH3/8MVatWuWcC7kOwwYR0U2oqanB5s2b0draarXd3LlzMXv2bA7rIBogk9mMT84ew+cXrPcWSkRirJo0BylRU/j1RXbxVflZHCwvcMi550XE4a6IiTd9fEZGBn73u99ZwoZOp8NXX32FF154oUc7jUaDjo4Oy95OcrkcL7/8Mjo7Oy1ttm7dit/97ndobW3Fyy+/jHnz5qGhoQEvv/wyLl26BKlUimeeeQZxcXFYtmwZjh49CgCYPXs2XnrpJSQnJ+N//ud/IBKJ8Oijj96wdoYNIiIbFRQUYOfOnTAajf22kcvlSE9PR2xsrBMrIxraGjXteO/kXpxrtL6am7/SE2tmpGCcX4iTKiMaXImJiWhra0NJSQkiIyPx5ZdfYubMmfD29u7RztvbG6tXr0Z6ejrGjh2LGTNmYPHixZg+fbqljZeXF7Zv345Dhw5h48aNmDdvHn7zm99g5syZ+MUvfoGKigrcf//92LFjB0JCQnDhwgVIJBKYTCacPHkSycnJ+Prrr/H6668PqHaGDSKiATKbzTh48CCOHTtmtZ2fnx8yMzMREBDgpMqIhr682jK8/90+tOk0VttNC4rEk9MXwVOudFJlNFLcFTHxlnofHEkkEuGee+7Bnj178NRTT2Hnzp146KGH+mz7q1/9CitXrsTx48dx7NgxPProo3j66act7efPnw8AiI6ORnNzMwDg22+/xVtvvQUACA8PR3x8PPLz85GUlIRvvvkGUqkUq1atQlZWFtrb21FfX4/o6OgB1S4eSKP3338fycnJSElJwf/+7/8CAI4fP47U1FQsXLgQ7733nqXtuXPnkJGRgUWLFuHll1+2+ps/IqKhQqvV4pNPPrlh0IiOjsajjz7KoEE0QCahe9jUW8e2Ww0aYpEID8bNxot3pDFo0Ih0zz33YO/evWhoaEBpaSnuuOOOXm3y8vLw8ccfw8/PD0uXLsU777yDjRs3YuvWrZY2EokEAHoMPxQEocd5BEGwTC7/5ptvcOLECSxYsABisRi7d+/G7NmzB1z3DcPGyZMn8e2332LXrl3Ytm0bNm3ahPPnz2Pt2rX485//jL1796KgoACHDx8GADz33HN45ZVXcODAAQiCgC1btgy4GCIiV9TQ0IC//e1vKCoqstruzjvvxP333w83N05UJRqIZm0n3jy6DZ+dPwHBSjs/N3e8Ofs+LB93O8Scn0EjVEhICEJCQrBhwwakpaX1OVfJ29sbGzduxPnz5y3PFRYWYsKECVbPPXPmTHz22WcAuveMOn36NBISEnDbbbehtLQUZWVliIqKwowZM/DBBx/grrvuGnDdNxxGlZiYiI8++ghSqRS1tbUwmUxoa2tDREQEwsPDAQCpqanYv38/oqOjodVqkZCQAKB7qa4NGzbggQceGHBBRESu5MKFC9i+fTt0uv43EpNKpUhLS0NcXJwTKyMa2r6vv4g/ndyLFl2X1Xbx6gg8ffsSeCtUTqqMyHWlp6fj+eefx7/+9a8+Pz527FisX78ea9euRUdHB0QiEeLj4/Hqq69aPe/LL7+MV199Fdu3bwcAvPXWW1Cr1QCAadOmWSacz5w5E1u3bkViYuKAax7QnA2ZTIYNGzbgww8/xOLFi1FXV9djiIBarUZtbW2v5wMCAlBbWzvgYoiIXIUgCDhy5AgOHTpktZ23tzdWrlyJ4OBgJ1VGNLSZBQHbzp/AlnPfwGylP0MMEVZOvAPpsTPYm0EjSlhYGA4ePNjnx5YuXYqlS5daPT4pKQlJSUl9fmzTpk19vk5gYCD+8pe/9HnM22+/bfn3vHnzkJuba/X1rzfgCeJPPfUUHn30UTz22GN9rikvEol6jfe68jwR0VCi1+uxc+dOnD171mq7iIgIrFixAu7u7k6qjGhoa9V14f1T+5BfV261nY/CHb9OXIJJAaOdVBkROcoNw0ZxcTH0ej0mTJgApVKJhQsXYv/+/ZbJJQBQV1cHtVqNwMBANDQ0WJ6vr6+3dMEQEQ0Fzc3N+PTTT2/YK3v77bdj0aJFPb4XElH/zjVU4Y8ns9Ck7bDaLi4gHL++PRm+bgzxRMPBDSeIV1ZWYt26ddDr9dDr9cjOzkZmZiZKS0tRXl4Ok8mEPXv2YM6cOQgNDYVCoUBOTg6A7p0N58yZ4/CLICKyh9LSUvz1r3+1GjTEYjFSU1ORnJzMoEE0AGZBwOc/nsSrR7ZYDRoiACvGz8SrszIYNIiGkRv2bCQlJSE/Px/Lly+HRCLBwoULkZKSAj8/Pzz55JPQ6XRISkrC4sWLAQDvvvsu1q1bh87OTkycOHHQtkYnIhooQRBw8uRJyyp6/fHw8MB9991nWRyDiKxr12nwnzn7kVNTarWdl0KJX09PRnxghJMqIyJnEQnWfrI6UWVlJe6++25kZ2cjLCxssMshohHCaDQiKysLeXl5VtuFhobivvvug5eXl5MqIxraLjRdwh9OZKFB02613YRRoXgmMRmjlJ5OqoyInIk7iBPRiNXe3o5PP/0UVVVVVtvFx8dj6dKlkEr5LZPIGp3JgE69Du16DfQmE24PjsLhi2fRZdT32f6ecbfj/ol3QiIe0B7DRDQE8ScnEY1IFRUV2LJlCzo6rIwhF4mwcOFCzJgxgyvrEd1Ak6YDn50/ga8u/gCdyQiFRIpZ4ePxyqwM/Pn0F6hoa7S09ZC74anpizEtKHIQKyYiZ2DYIKIRJzc3F1lZWTCZTP22USqVuPfeexEZyTdDRP1p0nSguLkWQR4+eOvY9h5DpnQmI7LLCpBfW441M5bizaPboDHqEesXjGcSUxCg4pBEopGAYYOIRgyTyYQDBw7g1KlTVtup1WpkZmbC19fXSZURuT6d0YDillpcaKpGYVMNCpur0ajpwJLIBJyqKe53bkaDph3ZZQW4a/REyCQS/PS2WZCKuZIb0UjBsEFEI0JnZyc+++yzPjclvdbEiRORlpYGuVzunMKIXJBZEHCpvQkXmmtQ2FSNwqZqlLc1wNzHmjIzQ2Pw9vHPrZ7vSMU5vDvvQYR4MsATjTQMG0Q07NXU1GDz5s1obW212m7u3LmYPXs252fQiNOq6+rurWiqRmFzDQqba9Bl0A3oWBFE0JmMVtvoTEbIuC8N0YjEsEFEw1pBQQF27twJo7H/N0NyuRzp6emIjY11YmVEg8NgMqK0tf7ycKjucFHbaT2IWyNAgEIitRo4FBIpJCKuOEU0EjFsENGwZDabcfDgQRw7dsxqOz8/P2RmZiIgIMBJlRE5jyAIqO1sRWFztWWuRWlrPYzm/hdHsNW3VYWYFT4e2WUF/baZFxEHD7nCbq9JREMHwwYRDTtarRbbtm1DUVGR1XbR0dHIyMiAm5ubkyojcqxOvbZ7GFRTDS40VaOouQZteo3DXk8EoLi5Br+auhD5teV9ThL3V3oiPTYRconMYXUQketi2CCiYaWhoQGbN29GY2Oj1XZ33nkn5s2bBzE3E6Mhymg24WJrg2US94WmalzqaHboa/oo3BHjF4RxfsGI8QtCtE8QlLLuxRTevut+fP7jSRwsL7DsszEvIg7psYnwU3o4tC4icl0MG0Q0bFy4cAHbt2+HTtf/xFapVIq0tDTExcU5sTKiWyMIAho07ZYlZwubalDcUgv9DSZm3wq5WIJI30DE+HYHixi/YAQoPftdQGGU0gOrJs1GemwiTIIZEpEYHnIFezSIRjiGDSIa8gRBwJEjR3Do0CGr7by9vbFy5UoEBwc7qTKim6Mx6FHUUtNjhahmbadDXzPEw7e7x8K3O1hEePvbvB+GXCKDn5LhgoiuYtggoiFNr9dj586dOHv2rNV2ERERWLFiBdzd3Z1UGdHAmAQzqtqauidwN1fjQlMNKtsaYUbvPS3sxUPuhhjfK8OhugOGh5xzl4jI/hg2iGjIam5uxqeffora2lqr7W6//XYsWrQIEq7zTy6gWdt5eaO8Glxo7p7ErTUaHPZ6UpEYY3wCEOMbbJlrEeTuw/1kiMgpGDaIaEgqLS3F1q1bodH0v9KOWCxGSkoKpk6d6sTKiK7SmQwobanDhaark7j7WrHJntQq76uTuH2DMNZHDbmEP+6JaHDwuw8RDSmCIODkyZM4cOAABKH/YSYeHh647777EB4e7sTqaCQzCwKqO5p7TOIua62HSTA77DVVUjmi/YIsk7jH+QbD203lsNcjIrIVwwYRDRlGoxFZWVnIy8uz2i40NBT33XcfvLy8nFQZjUTtOg0uXA4VhZf3tOgw9L8S2q0SQ4TR3v49JnGHevpBzOFQROTCGDaIaEhob2/Hp59+iqqqKqvt4uPjsXTpUkil/PZG9mMwm1DeUn85XHRP4q7pbHHoa/q5eVyzp0UwonwC4SblSk9ENLTwpzERubyKigps2bIFHR0d/bYRiURYuHAhZsyYwYmvZBOdyYBOvc6yN4S7TIFWXdfl1aG6d+IubamDwWxyWA0KiRRR1+xpMc43GKNUng57PSIiZ2HYICKXlpubi6ysLJhM/b/RUyqVWLFiBcaOHevEymg4aNJ04LPzJ/DVxR8su17PCh+P+WMm4bMfT6CizfpO9DdDBCDUcxTGXTPXYrSXPyTczZ6IhiGGDSJySSaTCQcOHMCpU6estgsMDMTKlSvh6+vrpMpouKjvasO6w5/2WB1KZzIiu6wA+bXlWDNjKd48ug0ao/6WXsdLocQ438v7WfgFIdo3CO4yxa2WT0Q0JDBsEJHL6ezsxGeffYaysjKr7SZOnIi0tDTI5XLnFEbDwvnGS7jYWo+iltp+l6Ft0LQju6wAd42eiH0l1hckuJZMLMFYH3WPSdxqlReH9hHRiMWwQUQupaamBps3b0Zra6vVdnPnzsXs2bP5Jo4GxGQ242R1EXYV5uBCUzXemL0C//j+sNVjjlScw0t3LLcaNoLcfbqHQ/kFY5xvMCJ8AiATc/NIIqIrGDaIyGUUFBRg586dMBqN/baRy+XIyMjAuHHjnFgZDVUagx7Z5QXIKjqNuq42y/MiiKAz9f95BnQPqRKLrs6j8JApEH25t+JKz4WnQumw2omIhgOGDSIadGazGQcPHsSxY8esths1ahQyMzPh7+/vpMpoqGrsakdWcS7+VfY9uvrY+0KAAIVEajVwKCRSKGUyPDltMWL8ghDs4cs9LYiIbMSwQUSDSqvVYtu2bSgqKrLaLjo6GhkZGXBzc3NSZTQUlTTXYldRDo5XXrC6c/e3VYWYFT4e2WUF/baZFxGHME8/RPoEOqJUIqIRgWGDiAZNQ0MDNm/ejMZG68uL3nnnnZg3bx7EXBqU+mAWBJyuKcWuwu/wQ0PlgI45fPEsXpmVgfza8j4nifsrPZEemwi5hJvoERHdCoYNIhoUFy5cwPbt26HT9R7icoVUKkVaWhri4uKcWBkNFTqjAYcvnsPuohxc6mi26VilTI6Ktkb8Nmkldlz4DgfLCyz7bMyLiEN6bCL8lB4OqpyIaORg2CAipxIEAUePHsXBgwettvP29kZmZiaCgoKcVBkNFS3aTuwrycOBkny067U2HRvpo8aymGm4I3QcpJdXjVo1aTbSYxMtO4h7yBXs0SAishOGDSJyCoPBAI1Gg/b2doSFhSExMRH5+fl99mxERERgxYoVcHd3H4RKyVVdbGvA7sIcfF1xHkZz/zvK92V6UCSWxUzDRP+wXsslyyUy+CkZLoiIHIFhg4gcrq2tDUeOHEF+fj4MBgNkMhni4uLws5/9DLt27UJ9fb2l7e23345FixZBIuFeBdTdE3am7iJ2F+Ugt7bMpmPlYgnuirgNS6OnItTTzzEFEhGRVQwbRGRXBoMBdXV1qK6uRn19PRISErB582a0tbX1aJObm4vi4mKsWLECmzZtgslkQkpKCqZMmTKI1ZOrMJiMOFr5I3YX5aC8tcGmY70VKiyJTMCiyHh4cR8MIqJBxbBBRDdNp9OhpqYG1dXVlr/r6+shCAIAIDExEadOneoRNK7V1taG3NxcJCYmYty4cQgPD3dm+eSC2vUafFFyBvtK8tCs7bTp2HCvUUiNnobZ4eMhl/DHGxGRK+B3YyIakK6uLlRXV/cIFk1NTVaPGT9+PD755BOrbb7//ns8/vjj8Pb2tme5NMRUdzRjT9FpHCr/4YY7e18vXh2B1JhpSFBH9JqPQUREg4thg4h6EAQBHR0dlmBxJVy0trbafC6RSASDwWC1jcFgsPSE0MgiCALONVZhd2EOTlUXw5bPAqlIjNnhE7A0ZirGeAc4rEYiIro1DBtEI5ggCGhpaenVY9HZadvwFWvnl8lkVgOHTCbjZPARxmQ249tLhdhV+B2KmmttOtZD7oZFY+OxJDIevtwHg4jI5Q0obGzcuBH79u0DACQlJeH555/H8ePH8c4770Cn02HJkiV45plnAADnzp3DunXr0NHRgenTp+ONN96AVMpMQzTYzGYzGhsbewSLmpoaaLW27VNgi/PnzyMuLg65ubn9tklISICbm5vDaiDX0WXQ4cuyAmQVne5z125rgtx9kBo9FXdF3AY3KZepJSIaKm6YAo4fP46jR4/i888/h0gkwiOPPII9e/bg3XffxaZNmxAcHIzVq1fj8OHDSEpKwnPPPYe33noLCQkJWLt2LbZs2YIHHnjAGddCRJeZTCbU19f3GApVW1t7wyFN9uLh4YHg4GCoVCpMmjQJxcXFfU4S9/LywqxZsyCT8c3jcFbf1Ya9xbn4svR7dBn1Nh07YVQolsVMw7TgSEhEYgdVSEREjnLDsBEQEIAXX3wRcrkcABAVFYWysjJERERYVo5JTU3F/v37ER0dDa1Wi4SEBABAeno6NmzYwLBB5EAGgwG1tbU9eizq6upgMtm26dnN8vHxQXBwMIKCgix/e3p69mjzb//2bzh69Cjy8vIs+2wkJCRg1qxZ8PLyckqd5HxFzTXYVZiDb6ouwGzDvByxSIQ7QsdhWfQ0RPtxB3kioqHshmEjJibG8u+ysjLs3bsXDz74IAICrk7IU6vVqK2tRV1dXY/nAwICUFtr23hcIuqfVqvttdRsQ0OD0yZYjxo1CsHBwT3ChVJ5430MvLy8sGDBAsyePRsmkwkSiQRubm7s0RiGTIIZOdUl2FWYg3ONVTYdq5TKsWDsJCyJmgK1iiGUiGg4GPBkisLCQqxevRovvPACpFIpSktLe3xcJBL1+YaHyxAS3ZzOzk5LoLjyp7m52SmvLRaLERAQ0KvH4koP582QyWQMF8OYzmjAofIfsLvoNGo6W2w61l/piZToqZg/Jg4qmcJBFRIR0WAYUNjIycnBU089hbVr1yIlJQUnT55EQ8PVHV3r6uqgVqsRGBjY4/n6+nqo1Wr7V000jAiCgPb29l4rQvW3EZ69SSQSBAUFWUJFcHAw1Go1F3agAWnWdGBfST4OlOajQ2/bYgPRvoFYFjMdM0NiIBFzPgYR0XB0w3cT1dXVePzxx/Hee+/hjjvuAADEx8ejtLQU5eXlCAsLw549e5CRkYHQ0FAoFArk5ORg2rRp2LFjB+bMmePwiyAaKgRBQHNzc69g0dXV5ZTXl8vlPUJFUFAQ/P39ufQs2aystR57Ck/jSOV5GM0Dnx8kAnB7cBSWxUzH+FEh7P0mIhrmbhg2/v73v0On02H9+vWW5zIzM7F+/Xo8+eST0Ol0SEpKwuLFiwEA7777LtatW4fOzk5MnDgRq1atclz1RC7MbDajoaGhx1Compoa6HQ6p7y+UqnsMQwqODgYfn5+fHNHN00QBOTVlWN3YQ7y68ptOlYhkWJuxG1IiZ6KEA9fB1VIRESuRiS4yNa9lZWVuPvuu5GdnY2wsLDBLofIJkajscdSs1f2sDAajU55fU9Pz17BwsvLi8GC7MJgMuLrivPYXZSDirZGm471UbgjOSoBCyMnw1N+48UEiIhoeOGgbCIb6fX6PpeaNZvNTnn9K0vNXhsuPDy4kzLZX5tOgwMl+dhfkocWnW1D/UZ7+WNZzDTMCouFTMIfNUREIxV/AhBZodfrUVVV1WMoVGNjo9OWmvX39++1ItRAlpoluhVV7U3YU3QaX108C73Jtt65KYFjkBozDZMDRrNnjYiIGDaIriUIAurr61FUVITi4mKUl5c7ZXM8sVgMtVrdYxhUYGDgLS01S2QLQRBwtqESuwpz8F1NiU3HSsUSJIVPwNKYqRjt5e+gComIaChi2KART6vVoqSkxBIwHL3krFQqRWBgYI+hUFxqlgaL0WzCN1UXsLvwNIpbbNuE1VPuhkWR8VgSmQAfN3cHVUhEREMZ393QiCMIAqqrq1FUVISioiJUVlY6bFiUQqHotYeFv78/xNxTgAZZp0GHf5Wewd7iXDRqOmw6NsTDF6nR05AUMQEKCTdqJCKi/jFs0IjQ0dGB4uJiyx9H7GuhUql6rQjl6+vLcevkUuo6W5FVnIsvy76H1miw6djb/MOwLGY6pgaNhZif10RENAAMGzQsmUwmVFZWWoZGVVdX2/X8V5aavXYoFJeaJVd2oakauwpzcKKqEGYMvCdPIhLjzrBxSI2ehkjfQAdWSEREwxHDBg0bLS0tKC4uRlFREUpLS+22eZ6bmxvGjBmDkJAQS7hwd+f4dHJ9JsGMU5eKsbsoB+cbL9l0rEqmwIIxk5ASNQWjVJ4OqpCIiIY7hg0asgwGAy5evGiZe9HQ0GC3c4eGhiIqKgrR0dEIDQ3lHAsaUjRGPQ6V/4CsotOo6Wy16Vi1ygsp0VNxd0QclDKuhkZERLeGYYOGDEEQ0NjYaBkaVVZWZrcdut3d3REdHY3o6GhERkZCpVLZ5bxEztSk6cDe4lz8q/QMOgy29eyN8wvGsphpSAyOhoThmoiI7IRhg1yaTqdDaWmpJWC0tLTY5bxisRijR4+29F4EBgZyvgUNGTqTAZ16HUyCGRKRGHqTETsKT+FQ2Q8wCgPfyV4MERJDopEaMw3jR4U4sGIiIhqpGDbIpQiCgNraWsvQqIqKCpjNA3/zZI2Pj48lXIwdOxYKhcIu5yVypiZNB7adP4FDF3+AzmSEQiLFrPDxmD9mEs43XkJFW+MNz+EmkWHemDikRE9BkLuPE6omIqKRimGDBl1XV1ePZWk7Omxb878/UqkUY8amrlTiAAAaFklEQVSMQXR0NKKiojBq1Cj2XtCQ1qTpwEtffYIGTbvlOZ3JiOyyAuTXlmPNjKV48+g2aIz6Po/3c3NHctQULBg7GR5yN2eVTUREIxjDBjmd2WxGVVWVZWhUVVWV3c4dEBBg6b0YPXo0ZDJuOEbDQ2NXO7ae/7ZH0LhWg6Yd2WUFuGv0ROwryevxsbHeAUiNmYafhMVCJpY4o1wiIiIADBvkJG1tbZZlaUtKSqDVau1yXoVCgcjISEvA8Pb2tst5iVyBIAjIryvH3uI8LIuZhq8rzlltf6TiHF66Y7klbEwLGovUmGmI8w9nrx4REQ0Khg1yCKPRaFmWtri4GHV1dXY7d3BwsGXlqNDQUEgk/E0tDS8agx6HLv6AfcV5uNTRDABIi5kOncn66ms6kxESsRgLxkzC0uipCPMa5YxyiYiI+sWwQXbT1NRkCRelpaUwGAx2Oa9KpbL0XERFRXFDPRq2LrU3Y19JLg6Vn+0170KAAIVEajVwKCRSqFXeeGzqAkeXSkRENCAMG3TT9Ho9ysrKLCtHNTc32+W8IpEI4eHhloARHBzMISA0bJkFAbm1pdhXnIfc2rJ+231bVYhZ4eORXVbQb5t5EXHwUnDiNxERuQ6GDRowQRBQV1dnmXtx8eJFmEwmu5zby8vLEi4iIyPh5sY3TDS8dRp0OFTePVSqpvPG+8ccvngWr8zKQH5teZ+TxP2VnkiPTYRcwkURiIjIdTBskFUajQYlJSWW4VHt7X2vhGMriUSCiIgIy9wLf39/9l7QiFDR1oh9xXk4fPEstKaBDzXsMurxv2e+wst33oMDJfk4VH51n415EXFIj02En9LDgZUTERHZjmGDejCbzaiurraEi8rKSgiCYJdzjxo1ytJ7ERERAblcbpfzErk6k2DG6epS7C3JxZm6izYfP9prFJKjpmBO+AQopDL8fNIcZMTOsOwg7iFXsEeDiIhcEsMGoaOjwzI0qri4GBqNxi7nlclkPZal9fX1tct5iYaKDr0W2WUF2F+Sj7quVpuOFUOE20OikBw1Bbf5h/Xo+ZNLZPBTMlwQEZHrY9gYgUwmEyoqKizhoqamxm7nDgwMtAyNCg8P57K0NCKVt9Zjb3Eevq44B/0Nlqu9nqfcDfPHTMKiyHgEqLwcVCEREZFzMGyMEC0tLZZwUVJSAr1ef+ODBkCpVCIqKsryx9PT0y7nJRpqTGYzTlUXY29xLn5oqLT5+LHeAVgSNQWzwmOh4JAoIiIaJhg2himDwYDy8nLLsrSNjY12Oa9IJEJoaKhlaFRISAjEYrFdzk00FLXpNPiy7HscKMnvc5Uoa8QiEWaGxCA5agrGjwrhIglERDTsMGwMYYIgoKOjA83NzWhqakJzc7PlT01NDYxG24Zv9MfDw8OyoV5kZCRUKpVdzks0lJW01GFfcS6OVpyH3mzbEtBeCiUWjpmMhZGTMUrJ3kAiIhq+GDZcnNFoREtLS5+Borm52W6B4lpisRijR4+2zL1Qq9X8jSsRAKPZhBOXirCvOA/nGqtsPj7KJxDJUVPwk7BxkEv47ZeIiIY//rQbZIIgQKPRWMLD9YGira3NKXX4+PhYwsXYsWO5LC3RNVq1XfhX2RkcKDmDJm2HTcdKRWLcETYOyVEJiPENZnAnIqIRhWHDCcxmM1pbW/vtndDpdE6vSSqVYuzYsZbhUX5+fnwTRHSdoqYa7C3JxbHKCzDaOFTKR+GORZGTsWDMJPhysz0iIhqhGDbsRKfT9ds70dLSYreN8W5FQECApfdi9OjRkEr53090PYPZhG+rLmBvcR4uNFXbfPw4v2AkR03BzNAYyMRc+pmIiEY2vtscIEEQ0N7e3m/vRFdX12CX2ItCoeixLK23t/dgl0Tkspo1Hfii9Ay+KP0eLbpOm46ViiWYFRaLJVEJiPYNclCFREREQw/DxjUMBoPVydgmk23DKJxBJpPB19e3xx8/Pz/Lv7ksLVH/BEFAYXM1sopy8W1VIYyC2abj/dzcsSgyHgvGTIa3G1dpIyIiut6IChuCIKCrq6vfMNHebtsa+c7i4eHRb5hwd3fnXAsiGxlMRhyrvIC9xbkobqm1+fgJo0KxJCoBM0KiIeVQKSIion4Nu7BhMpmsTsa2187Z9iSRSODj49NnoPDx8eHKUER20qhpx4GSM/hX2Rm06TQ2HSsXSzArfDyWRE1BpI/aQRUSERENL0MybGi12n7DRGtrq0tMxr6eUqnsd7iTp6cnhzsROYggCDjXWIW9xXk4cakQZhu/P/grPbE4Mh7zx0yCp0LpoCqJiIiGJ5cMG2az2epkbI3Gtt9IOoNIJIK3t3e/w53c3NwGu0SiEUVnMuBoxY/YV5yL0tZ6m4+/zT8MyVFTcHtwFCT8ZQAREdFNGXDY6OjoQGZmJv77v/8bYWFhOH78ON555x3odDosWbIEzzzzDADg3LlzWLduHTo6OjB9+nS88cYbNi2x+tFHH8FsNrvkZGy5XN5v74S3tzckEo7dJhps9V1t2F+Sj+yy79Gu19p0rFwiRVL4BCyJSkCEd4CDKiQiIho5BpQC8vPzsW7dOpSVlQHoHsa0du1abNq0CcHBwVi9ejUOHz6MpKQkPPfcc3jrrbeQkJCAtWvXYsuWLXjggQcGXFBzczM8PAZvAyxPT09LiPDx8enRO6FSqTgZm8gFCYKAHxoqsbc4F6cuFcMM24ZKqVVeWByZgHljboOnnEOliIiI7GVAYWPLli147bXX8PzzzwMAzpw5g4iICISHhwMAUlNTsX//fkRHR0Or1SIhIQEAkJ6ejg0bNtgUNhxNIpH02zvh4+MDmUw22CUS0QBpjQZ8XXEO+4pzcbGt0ebjJ6tHIzlyCqYGj4VExKFSRERE9jagsPHb3/62x+O6ujoEBFwdYqBWq1FbW9vr+YCAANTW2r6s5K1SqVT99k54enqyd4JoiKvtbMX+kjxklxWg06Cz6Vg3iQx3RUzEksgEhHmNclCFREREBNzkBPG+VnsSiUT9Pm9vYrHY6mRshUJh99ckosElCALO1F3E3uJc5NSU2DhQCghy98GSqATMjbgN7jJ+jyAiInKGmwobgYGBaGhosDyuq6uDWq3u9Xx9fT3U6ptbj16hUPQbJry9vblULNEIoTHqcbj8LPaV5KGyvcnm46cEjsGSqARMCRwLMXs1iYiInOqmwkZ8fDxKS0tRXl6OsLAw7NmzBxkZGQgNDYVCoUBOTg6mTZuGHTt2YM6cOTadOzMzExMmTIBSqeRwJ6IR7FJHM/YX5+FQ+Q/oMtq2GadSKsfciNuwJDIBIZ6+DqqQiIiIbuSmwoZCocD69evx5JNPQqfTISkpCYsXLwYAvPvuu1i3bh06OzsxceJErFq1yqZzBwYGQqVS3UxZRDTEmQUBebVl2Fuci9zaMpuPD/HwRXLUFNw1eiKUMrn9CyQiIiKbiAQX2W67srISd999N7KzsxEWFjbY5RCRE3UZdDhU/gP2leShuqPFpmNFAKYGRSI5KgGT1REcKkVERORCXHIHcSIaGSrbm7CvOBdfXTwLrdFg07EqmQJ3R8RhcWQ8gjx8HFQhERER3QqGDSJyCp3JgE69DkazGUazCXm1Zfjk7DGb52OEeY5CclQC5oyeAKWUQ6WIiIhcGcMGETmEIAjQGg3oNGhhEgTsuHAKhy+ehc5khEIixazw8XhlVgb+fPoLVNxgQz4xRJgeHInkqCmICwjn4hFERERDBMMGEQ2ISTCjQ69Fu06DVr0GbboutOu0aNN3oVV3+bFeizZd9+N2vQYysQSvzMrAH07sQYOm3XIuncmI7LIC5NeWY82MpXjz6DZo+ujh8JApMH/sJCwaGw+1u7czL5eIiIjsgGGDaIQymIxouxwc2nWaa0JDd1Bo1XVZ/t2m06BDr4XZxq305o+ZhC/Lvu8RNK7VoGlHdlkB7ho9EftK8izPR3j7IzlyCmaHj4dCKrul6yQiIqLBw7BBNAwIgoAuo35AoaH1chtbJ2TfjJmhMXj7+OdW2xypOIeX7liOA6X5mBESjSVRUzBxVCiHShEREQ0DDBtELsgkmNGh06JV33VNaLgyVEljCRNt+q7LAUMLo9k02GX3IoIIOpPRahudyQgPuRs+WPQI/FWeTqqMiIiInIFhg8gJdCZD9/wGXdfV+Q56bR+9Dl1o02vQqdfaOGDJNQkQoJBIrQYOhUQKb4UKfkoPJ1ZGREREzsCwQWQjQRDQZdBdDg2ayxOm+wgN1zzWmhw/ZMkVnbxUhFnh45FdVtBvm3kRcfCQK5xYFRERETkLwwbZxCwIMAtmCIJw+d/dj8247rEg3LDNzZxDgACTlXMIgOXYa89z/TmsfdwsCD3amMxmdBq0PeZBmATzYP9XDAqVVA5PhRJeciW8FCp4K5TwlCvhpbj8WK7s/rhCCW+5Cm5SGZq1ncivLe9zkri/0hPpsYmQSzgJnIiIaDhi2BjCBEFAm16Dhq521He1oUHT/Xd9VxvadBoYzabr3jhf/8a6/zffwvVvxi+3oeFDDBE8FG7wkqvgZfn7cnC4HCauhAZPhRu85ErIJLZ/y/BTeuDtu+7H5z+exMHyAss+G/Mi4pAem8jhU0RERMMYw4YLM5hNaNS0Xw0TXe1o0LSh/ppwob/B5FsaOWRiyeWgcDkkWHodVNcEiKs9ECq5AhKR2Cm1jVJ6YNWk2UiPTYRJMEMiEsNDrmCPBhER0TDHsDFIroz7r9dcDRJXAkTD5d6JZm3nsJgkTDdHJVNcDQjXBIWr/+7ZA+Emkbn0crFyiQx+SoYLIiKikYRhw0FMghnNms7LPRHdvRFXA0X34752TKbhSQyRZS7D1QDR97Alr8vzHmRiyWCXTURERHRLGDZuksao7x7W1NXWZ+9Eo6adcxyGMblYct3wpN5Dla7tgXCXuUHswr0ORERERI7AsNEHsyCgVdd1eThTe+/eCU0bOvTawS5z0Ighglh05Y8YItF1j6/7uFiEy393PycSiSCG+Lo215+jj2MuP5b0cQ5Rf+fq1ab3a3W3s3IOkRhKqbxHsHCTcjgQERER0Y2MyLChNxkvz4240iNx7UpO3b0SBhfcjbkvcrEE/iovBKi84K/0hL/KEwEqL4xSekIukfZ8U90rBIh6BYUbBwm49LwAIiIiInIdwy5sCIKADr22OzhYJltf7Z1o6GpHi65rsMscMC+FEgFKL0uI8Fde/lvliQClF7wUSr75JyIiIiKXNOTChtFsQpOmo/c8CctKTu1DZrdmqUiMUSrPXgHiyr/9lZ5QcLgOEREREQ1RLhc2tEY9ylvrLSHi+t6JZk0nzENkQVh3mcISIK70TFzbO+HtpnLaPgdERERERM7mcmHjmexNkPt6DnYZNySGCH5Kj36HN/mrPKGSKQa7TCIiIiKiQeNyYcNVuElklydee/aafO2v8sIoNw9IxOyVICIiIiLqz4gNGz4KdwSoPHsFiiu9Ex4yN068JiIiIiK6BcMybMjEkj6GN3kh4HLvhL/SEzLJsLx0IiIiIiKXMSTfcXvJlZbQYAkS18yV8Fao2CtBRERERDTIXC5sSCCCWuXVa7L1tRvXcfdmIiIiIiLX53JhY8PCX2B0ePhgl0FERERERLfI5ZZTEnP4ExERERHRsOByYYOIiIiIiIYHhg0iIiIiInIIhg0iIiIiInIIhg0iIiIiInIIhg0iIiIiInIIhg0iIiIiInIIhg0iIiIiInIIhg0iIiIiInIIh4SN3bt3Izk5GQsWLMDHH3/siJcgIiIiIiIXJ7X3CWtra/Hee+9h+/btkMvlyMzMxIwZMxAdHW3vlyIiIiIiIhdm97Bx/PhxzJw5Ez4+PgCARYsWYf/+/XjiiSesHmcymQAANTU19i6JiIiIiAhBQUGQSu3+9pessPvdrqurQ0BAgOWxWq3GmTNnbnhcfX09AOCnP/2pvUsiIiIiIkJ2djbCwsIGu4wRxe5hQxCEXs+JRKIbHhcXF4ePP/4YAQEBkEgk9i6LiIiIiEa4oKCgwS5hxLF72AgMDMR3331neVxXVwe1Wn3D49zc3DB9+nR7l0NERERERIPE7qtR/eQnP8E333yDpqYmaDQafPHFF5gzZ469X4aIiIiIiFycQ3o2nnnmGaxatQoGgwH33nsvJk+ebO+XISIiIiIiFycS+ppkQUREREREdIu4gzgRERERETkEwwYRERERETkEwwYRERERETkEwwYRERERETmEw8PGxo0bkZKSgpSUFPzHf/wHAOD48eNITU3FwoUL8d577/U65oUXXsD27dt7Pf/+++/jP//zPx1dskuzx/3MyclBRkYG0tLS8POf/xxVVVVOq9+V2ONefvfdd0hPT0dqaioee+wxtLa2Oq1+V2LPr/OzZ88iLi7O4TW7Knvcyx07dmDWrFlIS0tDWlpan8eMFPa4n3V1dfjlL3+J5cuXIzMzE5WVlU6r35Xc6r1sbGy0fE6mpaVh3rx5mDJlilOvwVXY4/OysrISP/3pT5GWloYHH3yQP8tv4V6eOXMGGRkZSE1NxerVq1FfX++0+kcEwYGOHTsmrFy5UtDpdIJerxdWrVol7N69W0hKShIuXrwoGAwG4eGHHxa++uorQRAEoaamRli9erUwefJkYdu2bZbztLW1CS+99JIwefJkYcOGDY4s2aXZ637OnTtXOHfunCAIgrB161bhscceG5TrGUz2upfz588XCgsLBUEQhN///vfCH/7wh0G5nsFkr3spCILQ1dUlrFy5Uhg3btxgXMqgs9e9fPPNN4Xdu3cP1mW4DHvdz5///OfCP//5T0EQBOGf//yn8PTTTw/K9Qwme36dC4IgmEwm4Wc/+5mwa9cuZ1/KoLPXvXz22WeFjz/+WBAEQfjoo4+ENWvWDMr1DCZ73Euz2SwkJSUJ33zzjSAIgpCVlSWsXr160K5pOHJoz0ZAQABefPFFyOVyyGQyREVFoaysDBEREQgPD4dUKkVqair2798PANi9ezfuvvtuLFmypMd5srOzMWbMGPziF79wZLkuzx73U6/X4+mnn8b48eMBALGxsaiurh6U6xlM9vrc3Lt3L6Kjo2EwGFBbWwsvL6/BuJxBZa97CQDr16/HQw895OQrcB32upfff/89duzYgWXLluHZZ58dsT1u9rifTU1NOH/+PDIzMwEAGRkZ+PWvfz0o1zOY7Pl1DgDbtm2DUqlEamqqMy/DJdjrXprNZnR0dAAANBoN3NzcnH4tg80e97K5uRlarRYzZ84EAMydOxdHjx6FXq8flGsajhwaNmJiYpCQkAAAKCsrw969eyESiRAQEGBpo1arUVtbCwB45JFHsGLFil7nWb58OX75y19CIpE4slyXZ4/7KZfLkZaWBqD7G9XGjRsxf/58J12B67DX56ZMJsOPP/6IpKQknDhxAikpKc65ABdir3uZnZ0NrVaLxYsXO6dwF2SvexkQEIAnn3wSO3fuRHBwMN58803nXICLscf9rKioQEhICN5++20sW7YMTz31FGQymfMuwkXY63MTAEwmEz744AOsWbPG8YW7IHvdy6effhr/+Mc/MHv2bHz44Yd49NFHnXMBLsQe99LX1xcqlQpHjx4FAGRlZcFgMKC5udlJVzH8OWWCeGFhIR5++GG88MILGD16dK+Pi0QiZ5QxbNjjfur1ejz77LMwGo1YvXq1I8ocEuxxL2NjY3H8+HH8+7//O5555hlHlDkk3Mq9rK+vxwcffIBXXnnFkSUOGbf6eflf//VfiI+Ph0gkwiOPPIKvv/7aUaUOCbdyP41GI86ePYuf/OQn2LVrF+6++268+OKLjizXpdnje+aRI0cwduxYxMbGOqLEIeNW7+ULL7yAN998E0eOHMEbb7yBJ554AsII3af5Vu6lSCTChg0b8Je//AXLly9He3s7fHx8RuQvFRzF4WEjJycHDz30ENasWYN77rkHgYGBaGhosHy8rq4OarXa0WUMG/a4n52dnXjkkUdgNBrxwQcfjNgvqFu9lzqdDl9++aXl8bJly/Djjz86tGZXdav38quvvkJLS4tlsiMApKWlWYYIjCS3ei/b29vxj3/8w/JYEARIpVJHluzSbvV+BgQEwN3dHXPnzgUALF26FGfOnHF43a7IXj/Pv/zySyQnJzuyVJd3q/eyqakJJSUllpEJixYtQn19/Yj8bbw9Pi+lUik2bdqEHTt24J577oHZbIaPj4+jSx8xHBo2qqur8fjjj+Pdd9+1DC+Jj49HaWkpysvLYTKZsGfPHsyZM8eRZQwb9rqfzz33HCIiIvD+++9DLpc7o3SXY497KZVK8cYbb6CgoAAAsG/fPkydOtUp9bsSe9zLFStW4Msvv8TOnTuxc+dOAMDOnTvh4eHhlGtwFfa4lyqVCn/729+Qn58PAPi///s/LFiwwCn1uxp73M/Ro0cjMDAQhw8fBgAcOnQIt912m1PqdyX2/Hmel5eH6dOnO7pkl2WPe+nr6wuFQoHvvvsOQPcbbnd3d/j5+TnlGlyFvT4v165da/klwocffojFixdDLObuEPbi0F93/f3vf4dOp8P69estz2VmZmL9+vV48sknodPpkJSUNKLHaNvCHvfz7NmzyM7ORnR0NJYvXw6gezzjX//6V4fX70rscS8lEgnee+89vPrqqzCZTAgMDMRvf/tbZ5TvUvh1bj/2+rz805/+hNdffx1arRZjxoyxLAc50tjrc3Pjxo147bXX8Pvf/x4eHh49zjdS2PPrvKKiAkFBQY4s16XZ416KRCJs3LgRv/nNb6DVauHu7j4itwaw1+fl66+/jtdeew0ajQaxsbEj8me5I4mEkTrAj4iIiIiIHIp9RERERERE5BAMG0RERERE5BAMG0RERERE5BAMG0RERERE5BAMG0RERERE5BAMG0RERERE5BAMG0RERERE5BAMG0RERERE5BD/HwBudwKEo0s/AAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 804.35x360 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "sns.set_theme(style=\"white\")\n",
    "movies = 'grey'\n",
    "tv_show = '#52ad8d'\n",
    "chart = sns.relplot(\n",
    "    kind='line', \n",
    "    data=release_movie_tv, \n",
    "    x=\"release_year\", \n",
    "    y=\"title\",\n",
    "    hue=\"type\",\n",
    "    height = 5,\n",
    "    aspect = 2,\n",
    "    linewidth=6,\n",
    "    legend= True,\n",
    "    marker='o',\n",
    "    markersize=10,\n",
    "    markevery=(3,1),\n",
    "    palette={\n",
    "        'Movie': movies,\n",
    "        'TV Show': tv_show\n",
    "    },\n",
    "    \n",
    ")\n",
    "sns.set()\n",
    "chart.set(ylim=(0,700), \n",
    "          xlim=(2011,2019), \n",
    "          ylabel=None, \n",
    "          xlabel=None,\n",
    "          title = \"Total titles of TV Shows vs Movies from 2011-2019\")\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "colab": {
   "collapsed_sections": [],
   "name": "Netflix_movie_titles_analysis",
   "provenance": [],
   "toc_visible": true
  },
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}