1.7_week7_assignment.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "a313129b",
   "metadata": {},
   "source": [
    "# Pandas data manipulation and transformation"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "17aa7cf8",
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import os"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "84471294",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(1000, 11)"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "path = 'C://Users//hussainsarfraz//0_Oxford_Course'\n",
    "os. chdir(path) #path would be the new working directory\n",
    "os. getcwd() #getting current working directory\n",
    "imdb_movies = pd.read_csv(\"1.7_excel_imdb-movies.csv\")\n",
    "imdb_movies.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "ac05e159",
   "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>Rank</th>\n",
       "      <th>Title</th>\n",
       "      <th>Genre</th>\n",
       "      <th>Director</th>\n",
       "      <th>Year</th>\n",
       "      <th>Runtime (Minutes)</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Votes</th>\n",
       "      <th>Revenue (Millions)</th>\n",
       "      <th>Metascore</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Guardians of the Galaxy</td>\n",
       "      <td>Action,Adventure,Sci-Fi</td>\n",
       "      <td>James Gunn</td>\n",
       "      <td>2014</td>\n",
       "      <td>121</td>\n",
       "      <td>8.1</td>\n",
       "      <td>757074</td>\n",
       "      <td>333.13</td>\n",
       "      <td>76.0</td>\n",
       "      <td>Chris Pratt, Vin Diesel, Bradley Cooper, Zoe S...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Prometheus</td>\n",
       "      <td>Adventure,Mystery,Sci-Fi</td>\n",
       "      <td>Ridley Scott</td>\n",
       "      <td>2012</td>\n",
       "      <td>124</td>\n",
       "      <td>7.0</td>\n",
       "      <td>485820</td>\n",
       "      <td>126.46</td>\n",
       "      <td>65.0</td>\n",
       "      <td>Noomi Rapace, Logan Marshall-Green, Michael Fa...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Split</td>\n",
       "      <td>Horror,Thriller</td>\n",
       "      <td>M. Night Shyamalan</td>\n",
       "      <td>2016</td>\n",
       "      <td>117</td>\n",
       "      <td>7.3</td>\n",
       "      <td>157606</td>\n",
       "      <td>138.12</td>\n",
       "      <td>62.0</td>\n",
       "      <td>James McAvoy, Anya Taylor-Joy, Haley Lu Richar...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Sing</td>\n",
       "      <td>Animation,Comedy,Family</td>\n",
       "      <td>Christophe Lourdelet</td>\n",
       "      <td>2016</td>\n",
       "      <td>108</td>\n",
       "      <td>7.2</td>\n",
       "      <td>60545</td>\n",
       "      <td>270.32</td>\n",
       "      <td>59.0</td>\n",
       "      <td>Matthew McConaughey,Reese Witherspoon, Seth Ma...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Suicide Squad</td>\n",
       "      <td>Action,Adventure,Fantasy</td>\n",
       "      <td>David Ayer</td>\n",
       "      <td>2016</td>\n",
       "      <td>123</td>\n",
       "      <td>6.2</td>\n",
       "      <td>393727</td>\n",
       "      <td>325.02</td>\n",
       "      <td>40.0</td>\n",
       "      <td>Will Smith, Jared Leto, Margot Robbie, Viola D...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Rank                    Title                     Genre  \\\n",
       "0     1  Guardians of the Galaxy   Action,Adventure,Sci-Fi   \n",
       "1     2               Prometheus  Adventure,Mystery,Sci-Fi   \n",
       "2     3                    Split           Horror,Thriller   \n",
       "3     4                     Sing   Animation,Comedy,Family   \n",
       "4     5            Suicide Squad  Action,Adventure,Fantasy   \n",
       "\n",
       "               Director  Year  Runtime (Minutes)  Rating   Votes  \\\n",
       "0            James Gunn  2014                121     8.1  757074   \n",
       "1          Ridley Scott  2012                124     7.0  485820   \n",
       "2    M. Night Shyamalan  2016                117     7.3  157606   \n",
       "3  Christophe Lourdelet  2016                108     7.2   60545   \n",
       "4            David Ayer  2016                123     6.2  393727   \n",
       "\n",
       "   Revenue (Millions)  Metascore  \\\n",
       "0              333.13       76.0   \n",
       "1              126.46       65.0   \n",
       "2              138.12       62.0   \n",
       "3              270.32       59.0   \n",
       "4              325.02       40.0   \n",
       "\n",
       "                                              Actors  \n",
       "0  Chris Pratt, Vin Diesel, Bradley Cooper, Zoe S...  \n",
       "1  Noomi Rapace, Logan Marshall-Green, Michael Fa...  \n",
       "2  James McAvoy, Anya Taylor-Joy, Haley Lu Richar...  \n",
       "3  Matthew McConaughey,Reese Witherspoon, Seth Ma...  \n",
       "4  Will Smith, Jared Leto, Margot Robbie, Viola D...  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "imdb_movies.head(5) #we need to assign the dataframe index to the rank column"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "fa79f23f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(1000, 10)"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "imdb_movies.set_index('Rank', inplace=True) #setting the dataframe index with the rank column\n",
    "imdb_movies.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "6175e2e4",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Genre</th>\n",
       "      <th>Director</th>\n",
       "      <th>Year</th>\n",
       "      <th>Runtime (Minutes)</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Votes</th>\n",
       "      <th>Revenue (Millions)</th>\n",
       "      <th>Metascore</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rank</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Guardians of the Galaxy</td>\n",
       "      <td>Action,Adventure,Sci-Fi</td>\n",
       "      <td>James Gunn</td>\n",
       "      <td>2014</td>\n",
       "      <td>121</td>\n",
       "      <td>8.1</td>\n",
       "      <td>757074</td>\n",
       "      <td>333.13</td>\n",
       "      <td>76.0</td>\n",
       "      <td>Chris Pratt, Vin Diesel, Bradley Cooper, Zoe S...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Prometheus</td>\n",
       "      <td>Adventure,Mystery,Sci-Fi</td>\n",
       "      <td>Ridley Scott</td>\n",
       "      <td>2012</td>\n",
       "      <td>124</td>\n",
       "      <td>7.0</td>\n",
       "      <td>485820</td>\n",
       "      <td>126.46</td>\n",
       "      <td>65.0</td>\n",
       "      <td>Noomi Rapace, Logan Marshall-Green, Michael Fa...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Split</td>\n",
       "      <td>Horror,Thriller</td>\n",
       "      <td>M. Night Shyamalan</td>\n",
       "      <td>2016</td>\n",
       "      <td>117</td>\n",
       "      <td>7.3</td>\n",
       "      <td>157606</td>\n",
       "      <td>138.12</td>\n",
       "      <td>62.0</td>\n",
       "      <td>James McAvoy, Anya Taylor-Joy, Haley Lu Richar...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Sing</td>\n",
       "      <td>Animation,Comedy,Family</td>\n",
       "      <td>Christophe Lourdelet</td>\n",
       "      <td>2016</td>\n",
       "      <td>108</td>\n",
       "      <td>7.2</td>\n",
       "      <td>60545</td>\n",
       "      <td>270.32</td>\n",
       "      <td>59.0</td>\n",
       "      <td>Matthew McConaughey,Reese Witherspoon, Seth Ma...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Suicide Squad</td>\n",
       "      <td>Action,Adventure,Fantasy</td>\n",
       "      <td>David Ayer</td>\n",
       "      <td>2016</td>\n",
       "      <td>123</td>\n",
       "      <td>6.2</td>\n",
       "      <td>393727</td>\n",
       "      <td>325.02</td>\n",
       "      <td>40.0</td>\n",
       "      <td>Will Smith, Jared Leto, Margot Robbie, Viola D...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        Title                     Genre              Director  \\\n",
       "Rank                                                                            \n",
       "1     Guardians of the Galaxy   Action,Adventure,Sci-Fi            James Gunn   \n",
       "2                  Prometheus  Adventure,Mystery,Sci-Fi          Ridley Scott   \n",
       "3                       Split           Horror,Thriller    M. Night Shyamalan   \n",
       "4                        Sing   Animation,Comedy,Family  Christophe Lourdelet   \n",
       "5               Suicide Squad  Action,Adventure,Fantasy            David Ayer   \n",
       "\n",
       "      Year  Runtime (Minutes)  Rating   Votes  Revenue (Millions)  Metascore  \\\n",
       "Rank                                                                           \n",
       "1     2014                121     8.1  757074              333.13       76.0   \n",
       "2     2012                124     7.0  485820              126.46       65.0   \n",
       "3     2016                117     7.3  157606              138.12       62.0   \n",
       "4     2016                108     7.2   60545              270.32       59.0   \n",
       "5     2016                123     6.2  393727              325.02       40.0   \n",
       "\n",
       "                                                 Actors  \n",
       "Rank                                                     \n",
       "1     Chris Pratt, Vin Diesel, Bradley Cooper, Zoe S...  \n",
       "2     Noomi Rapace, Logan Marshall-Green, Michael Fa...  \n",
       "3     James McAvoy, Anya Taylor-Joy, Haley Lu Richar...  \n",
       "4     Matthew McConaughey,Reese Witherspoon, Seth Ma...  \n",
       "5     Will Smith, Jared Leto, Margot Robbie, Viola D...  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "imdb_movies.head(5) #the index is now replaced with the rank column"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "c7b4ba8c",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Index: 1000 entries, 1 to 1000\n",
      "Data columns (total 10 columns):\n",
      " #   Column              Non-Null Count  Dtype  \n",
      "---  ------              --------------  -----  \n",
      " 0   Title               1000 non-null   object \n",
      " 1   Genre               1000 non-null   object \n",
      " 2   Director            1000 non-null   object \n",
      " 3   Year                1000 non-null   int64  \n",
      " 4   Runtime (Minutes)   1000 non-null   int64  \n",
      " 5   Rating              1000 non-null   float64\n",
      " 6   Votes               1000 non-null   int64  \n",
      " 7   Revenue (Millions)  872 non-null    float64\n",
      " 8   Metascore           936 non-null    float64\n",
      " 9   Actors              1000 non-null   object \n",
      "dtypes: float64(3), int64(3), object(4)\n",
      "memory usage: 85.9+ KB\n"
     ]
    }
   ],
   "source": [
    "imdb_movies.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "dbce2375",
   "metadata": {},
   "source": [
    "### Question 1A: Do movies longer than 2h45 get better scores than movies shorter than 100 mins?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "c1fa133a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "np.float64(6.2830645161290315)"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "imdb_movies[imdb_movies['Runtime (Minutes)'] < 100]['Rating'].mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "9c6ecca2",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "np.float64(7.790909090909091)"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "imdb_movies[imdb_movies['Runtime (Minutes)'] > 165]['Rating'].mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "c22aa71d",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Mean rating of movies less than 100 min: 55.86784140969163 \n",
      " Mean rating of movies more than 2hr 45min: 67.22222222222223\n"
     ]
    }
   ],
   "source": [
    "print('Mean rating of movies less than 100 min:', imdb_movies[imdb_movies['Runtime (Minutes)'] < 100]['Metascore'].mean(),\n",
    "      '\\n',\n",
    "     'Mean rating of movies more than 2hr 45min:', imdb_movies[imdb_movies['Runtime (Minutes)'] > 165]['Metascore'].mean())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "02fe059c",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Mean rating of movies less than 100 min: 6.316304347826087 \n",
      " Mean rating of movies more than 2hr 45min: 7.675\n"
     ]
    }
   ],
   "source": [
    "print('Mean rating of movies less than 100 min:', imdb_movies[imdb_movies['Runtime (Minutes)'] <= 100]['Rating'].mean(),\n",
    "      '\\n',\n",
    "     'Mean rating of movies more than 2hr 45min:', imdb_movies[imdb_movies['Runtime (Minutes)'] >= 165]['Rating'].mean())"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "53ff8167",
   "metadata": {},
   "source": [
    "### Question 1B: Visualise the response to 1A with an appropriate plot (matplotlib)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "3342e508",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAkIAAAHVCAYAAAAdLJRmAAAAOnRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjEwLjAsIGh0dHBzOi8vbWF0cGxvdGxpYi5vcmcvlHJYcgAAAAlwSFlzAAAPYQAAD2EBqD+naQAAQQdJREFUeJzt3Xl8TXf+x/H3TWST5SaxJFQkSisoSqoELdUQRtWStqpatAY1RDEdZUZt7dBqleqgy6ilU4NOUUq1qmgRe+miQixNkISWJNYE+f7+6MP99UpiSRM3cl7Px+M8Hu73+z3nfM4lxzvnfM+9NmOMEQAAgAW5uboAAAAAVyEIAQAAyyIIAQAAyyIIAQAAyyIIAQAAyyIIAQAAyyIIAQAAyyIIAQAAyyIIAQAAyyIIASi1xowZI5vN5tQWERGhXr16uaagW8ChQ4dks9n0+uuvu7oU4KYgCAElzPfff69HHnlE4eHh8vb21m233abWrVvrrbfecnVpJU7Lli1ls9nyXfbs2ePy2u666y6X1nA1K1as0JgxY1xdBuByZVxdAID/t3HjRj3wwAOqWrWq+vTpo9DQUKWkpGjTpk168803FR8f7+oSS5wqVapowoQJedorV66skSNHavjw4S6oquRbsWKFpk2bRhiC5RGEgBLkn//8p+x2u7Zu3arAwECnvmPHjt3UWs6ePauyZcve1H0Wht1u15NPPllgf5kynOYAFIxbY0AJsn//ftWpUydPCJKkihUr5mn7z3/+o3vvvVdly5ZVUFCQ7r//fn3xxRdOY6ZPn646derIy8tLlStX1oABA5SRkeE05vJtnO3bt+v+++9X2bJl9fe//12SlJ2drdGjR6tGjRry8vJSWFiYhg0bpuzs7Ksey8CBA+Xn56ezZ8/m6evWrZtCQ0N16dIlSdK2bdsUGxur8uXLy8fHR9WqVdMzzzxz1e1fj/zmCF1p9uzZstlsWr9+vQYNGqQKFSooMDBQ/fr1U05OjjIyMtSjRw8FBQUpKChIw4YNkzHmD9d22Weffab77rtPvr6+8vf3V/v27fXjjz86jenVq5f8/Px05MgRderUSX5+fqpQoYKef/55x3t42a+//qqnnnpKAQEBCgwMVM+ePbVr1y7ZbDbNnj3bsb1p06ZJktPtxCu9++67ql69ury8vNSoUSNt3bq1yI4bKCn4VQkoQcLDw5WQkKAffvjhmvNLxo4dqzFjxqhp06YaN26cPD09tXnzZn311Vdq06aNpN+CwNixYxUTE6P+/fsrMTFRM2bM0NatW7VhwwZ5eHg4tvfrr7+qXbt2evzxx/Xkk08qJCREubm5evjhh7V+/Xr17dtXtWrV0vfff6/Jkydr7969WrJkSYH1de3aVdOmTdPy5cv16KOPOtrPnj2rZcuWqVevXnJ3d9exY8fUpk0bVahQQcOHD1dgYKAOHTqkRYsWXdd7dunSJf3yyy9Obd7e3vLz87uu9S+Lj49XaGioxo4dq02bNundd99VYGCgNm7cqKpVq2r8+PFasWKFXnvtNd11113q0aPHDW0/Px988IF69uyp2NhYvfrqqzp79qxmzJih5s2b69tvv1VERITTccbGxqpx48Z6/fXX9eWXX2rSpEmqXr26+vfvL0nKzc1Vhw4dtGXLFvXv31+RkZH65JNP1LNnT6f99uvXT0ePHtWqVav0wQcf5FvbvHnzdOrUKfXr1082m00TJ05Uly5ddODAAad/N8AtzwAoMb744gvj7u5u3N3dTXR0tBk2bJj5/PPPTU5OjtO4ffv2GTc3N9O5c2dz6dIlp77c3FxjjDHHjh0znp6epk2bNk5j/vWvfxlJ5v3333e0tWjRwkgyb7/9ttO2PvjgA+Pm5ma++eYbp/a3337bSDIbNmwo8Fhyc3PNbbfdZuLi4pzaFy5caCSZr7/+2hhjzOLFi40ks3Xr1mu9PXlcrvvKpWfPnsYYY0aPHm2uPM2Fh4c7+o0xZtasWUaSiY2Ndbx3xhgTHR1tbDabefbZZx1tFy9eNFWqVDEtWrS4rtrq1KlTYP+pU6dMYGCg6dOnj1N7WlqasdvtTu09e/Y0ksy4ceOcxjZo0MBERUU5Xn/88cdGkpkyZYqj7dKlS6ZVq1ZGkpk1a5ajfcCAAXneG2OMOXjwoJFkypUrZ06cOOFo/+STT4wks2zZsmseO3Ar4dYYUIK0bt1aCQkJevjhh7Vr1y5NnDhRsbGxuu2227R06VLHuCVLlig3N1ejRo2Sm5vzj/HlWxxffvmlcnJyNHjwYKcxffr0UUBAgJYvX+60npeXl55++mmnto8++ki1atVSZGSkfvnlF8fSqlUrSdKaNWsKPBabzaZHH31UK1as0OnTpx3tCxYs0G233abmzZtLkuM24KeffqoLFy5c71vlEBERoVWrVjktw4YNu+Ht9O7d2+n2UOPGjWWMUe/evR1t7u7uuueee3TgwIEb3v6VVq1apYyMDHXr1s3pvXV3d1fjxo3zfW+fffZZp9f33XefUy0rV66Uh4eH+vTp42hzc3PTgAEDbri+rl27KigoyGlfkork2IGShFtjQAnTqFEjLVq0SDk5Odq1a5cWL16syZMn65FHHtHOnTtVu3Zt7d+/X25ubqpdu3aB2/n5558lSTVr1nRq9/T01O233+7ov+y2226Tp6enU9u+ffv0008/qUKFCvnu41oTuLt27aopU6Zo6dKleuKJJ3T69GmtWLHCcbtFklq0aKG4uDiNHTtWkydPVsuWLdWpUyc98cQT8vLyuur2JcnX11cxMTHXHHctVatWdXptt9slSWFhYXnaT548+Yf3t2/fPklyhMorBQQEOL329vbO8/cQFBTkVMvPP/+sSpUq5ZnkXqNGjRuu78r343IoKopjB0oSghBQQnl6eqpRo0Zq1KiR7rzzTj399NP66KOPNHr06GLZn4+PT5623Nxc1a1bV2+88Ua+61wZEq7UpEkTRUREaOHChXriiSe0bNkynTt3Tl27dnWMsdls+t///qdNmzZp2bJl+vzzz/XMM89o0qRJ2rRp0w3P9Sksd3f36243RTBZOjc3V9Jv84RCQ0Pz9F/5tFtB9RWXgvZXFMcOlCQEIeAWcM8990iSUlNTJUnVq1dXbm6udu/erbvvvjvfdcLDwyVJiYmJuv322x3tOTk5Onjw4HVdRalevbp27dqlBx988JpPXxXkscce05tvvqmsrCwtWLBAERERatKkSZ5xTZo0UZMmTfTPf/5T8+bNU/fu3TV//nz9+c9/LtR+S7rq1atL+u1pwKK4oiX99ne+Zs2aPB99kJSUlGdsYf8+gdKGOUJACbJmzZp8f+NesWKFpP+/zdWpUye5ublp3LhxjisLl11ePyYmRp6enpo6darTNmfOnKnMzEy1b9/+mvU89thjOnLkiN577708fefOndOZM2euuY2uXbsqOztbc+bM0cqVK/XYY4859Z88eTLPMV8Od9d6RP9WFhsbq4CAAI0fPz7fuVHHjx8v1DYvXLjg9PeVm5vreFT+93x9fSUpz0cpAFbDFSGgBImPj9fZs2fVuXNnRUZGKicnRxs3bnRcSbk8mblGjRr6xz/+oZdeekn33XefunTpIi8vL23dulWVK1fWhAkTVKFCBY0YMUJjx45V27Zt9fDDDysxMVHTp09Xo0aNrvohhJc99dRTWrhwoZ599lmtWbNGzZo106VLl7Rnzx4tXLhQn3/+ueNqVUEaNmzoqDc7O9vptpgkzZkzR9OnT1fnzp1VvXp1nTp1Su+9954CAgL0pz/9qfBvZglw/Phxvfzyy3naq1Wrpu7du2vGjBl66qmn1LBhQz3++OOqUKGCkpOTtXz5cjVr1kz/+te/bmh/nTp10r333qu//vWvSkpKUmRkpJYuXaoTJ05Icr4KFBUVJUkaNGiQYmNj5e7urscff/wPHC1wi3LhE2sArvDZZ5+ZZ555xkRGRho/Pz/j6elpatSoYeLj4016enqe8e+//75p0KCB8fLyMkFBQaZFixZm1apVTmP+9a9/mcjISOPh4WFCQkJM//79zcmTJ53GXO1R75ycHPPqq6+aOnXqOPYTFRVlxo4dazIzM6/ruP7xj38YSaZGjRp5+nbs2GG6detmqlatary8vEzFihXNQw89ZLZt23bN7V7rEfUbeXz+ysf3L697/Phxp/aePXsaX1/f66pN+TzaL8k8+OCDjnFr1qwxsbGxxm63G29vb1O9enXTq1cvp+MvaJ/5Hd/x48fNE088Yfz9/Y3dbje9evUyGzZsMJLM/PnzHeMuXrxo4uPjTYUKFYzNZnNs5/Lj86+99lqe/Ukyo0ePvuaxA7cSmzHMfAOA0mzJkiXq3Lmz1q9fr2bNmrm6HKBEIQgBQCly7tw5pycAL126pDZt2mjbtm1KS0vL9+lAwMqYIwQApUh8fLzOnTun6OhoZWdna9GiRdq4caPGjx9PCALywRUhAChF5s2bp0mTJikpKUnnz59XjRo11L9/fw0cONDVpQElEkEIAABYFp8jBAAALIsgBAAALMulk6UjIiLyfPGjJP3lL3/RtGnTdP78ef31r3/V/PnzlZ2drdjYWE2fPl0hISHXvY/c3FwdPXpU/v7+fKQ8AAAWYYzRqVOnVLlyZbm5FXzdx6VzhI4fP65Lly45Xv/www9q3bq11qxZo5YtW6p///5avny5Zs+eLbvdroEDB8rNzU0bNmy47n0cPnz4ml8MCQAASqeUlBRVqVKlwP4SNVl68ODB+vTTT7Vv3z5lZWWpQoUKmjdvnh555BFJ0p49e1SrVi0lJCTk+6WN+cnMzFRgYKBSUlIUEBBQnOUDAIASIisrS2FhYcrIyJDdbi9wXIn5HKGcnBz95z//0dChQ2Wz2bR9+3ZduHDB6VuZIyMjVbVq1asGoezsbKcvajx16pQkKSAggCAEAIDFXGtaTImZLL1kyRJlZGSoV69ekqS0tDR5enoqMDDQaVxISIjS0tIK3M6ECRNkt9sdC7fFAABAQUpMEJo5c6batWunypUr/6HtjBgxQpmZmY4lJSWliCoEAAClTYm4Nfbzzz/ryy+/1KJFixxtoaGhysnJUUZGhtNVofT0dIWGhha4LS8vL3l5eRVnuQAAoJQoEVeEZs2apYoVK6p9+/aOtqioKHl4eGj16tWOtsTERCUnJys6OtoVZQIAgFLG5VeEcnNzNWvWLPXs2VNlyvx/OXa7Xb1799bQoUMVHBysgIAAxcfHKzo6+rqfGAMAALgalwehL7/8UsnJyXrmmWfy9E2ePFlubm6Ki4tz+kBFAACAolCiPkeoOGRlZclutyszM5PH5wEAsIjr/f+/RMwRAgAAcAWCEAAAsCyCEAAAsCyCEAAAsCyCEAAAsCyCEAAAsCyCEAAAsCyCEAAAsCyXf7I0AJQGEcOXu7oE4JZ06JX21x5UjLgiBAAALIsgBAAALIsgBAAALIsgBAAALIsgBAAALIsgBAAALIsgBAAALIsgBAAALIsgBAAALIsgBAAALIsgBAAALIsgBAAALIsgBAAALIsgBAAALIsgBAAALIsgBAAALIsgBAAALIsgBAAALIsgBAAALIsgBAAALIsgBAAALIsgBAAALIsgBAAALIsgBAAALIsgBAAALIsgBAAALIsgBAAALIsgBAAALIsgBAAALIsgBAAALIsgBAAALIsgBAAALIsgBAAALIsgBAAALMvlQejIkSN68sknVa5cOfn4+Khu3bratm2bo98Yo1GjRqlSpUry8fFRTEyM9u3b58KKAQBAaeHSIHTy5Ek1a9ZMHh4e+uyzz7R7925NmjRJQUFBjjETJ07U1KlT9fbbb2vz5s3y9fVVbGyszp8/78LKAQBAaVDGlTt/9dVXFRYWplmzZjnaqlWr5vizMUZTpkzRyJEj1bFjR0nS3LlzFRISoiVLlujxxx+/6TUDAIDSw6VXhJYuXap77rlHjz76qCpWrKgGDRrovffec/QfPHhQaWlpiomJcbTZ7XY1btxYCQkJ+W4zOztbWVlZTgsAAEB+XBqEDhw4oBkzZuiOO+7Q559/rv79+2vQoEGaM2eOJCktLU2SFBIS4rReSEiIo+9KEyZMkN1udyxhYWHFexAAAOCW5dIglJubq4YNG2r8+PFq0KCB+vbtqz59+ujtt98u9DZHjBihzMxMx5KSklKEFQMAgNLEpUGoUqVKql27tlNbrVq1lJycLEkKDQ2VJKWnpzuNSU9Pd/RdycvLSwEBAU4LAABAflwahJo1a6bExESntr179yo8PFzSbxOnQ0NDtXr1akd/VlaWNm/erOjo6JtaKwAAKH1c+tTYkCFD1LRpU40fP16PPfaYtmzZonfffVfvvvuuJMlms2nw4MF6+eWXdccdd6hatWp68cUXVblyZXXq1MmVpQMAgFLApUGoUaNGWrx4sUaMGKFx48apWrVqmjJlirp37+4YM2zYMJ05c0Z9+/ZVRkaGmjdvrpUrV8rb29uFlQMAgNLAZowxri6iOGVlZclutyszM5P5QgCKTcTw5a4uAbglHXqlfbFs93r//3f5V2wAAAC4CkEIAABYFkEIAABYFkEIAABYFkEIAABYFkEIAABYFkEIAABYFkEIAABYFkEIAABYFkEIAABYFkEIAABYFkEIAABYFkEIAABYFkEIAABYFkEIAABYFkEIAABYVhlXF3Crixi+3NUlALekQ6+0d3UJAMAVIQAAYF0EIQAAYFkEIQAAYFkEIQAAYFkEIQAAYFkEIQAAYFkEIQAAYFkEIQAAYFkEIQAAYFkEIQAAYFkEIQAAYFkEIQAAYFkEIQAAYFkEIQAAYFkEIQAAYFkEIQAAYFkEIQAAYFkEIQAAYFkEIQAAYFkEIQAAYFkEIQAAYFkEIQAAYFkEIQAAYFkEIQAAYFkEIQAAYFkEIQAAYFkEIQAAYFkuDUJjxoyRzWZzWiIjIx3958+f14ABA1SuXDn5+fkpLi5O6enpLqwYAACUJi6/IlSnTh2lpqY6lvXr1zv6hgwZomXLlumjjz7SunXrdPToUXXp0sWF1QIAgNKkjMsLKFNGoaGhedozMzM1c+ZMzZs3T61atZIkzZo1S7Vq1dKmTZvUpEmTm10qAAAoZVx+RWjfvn2qXLmybr/9dnXv3l3JycmSpO3bt+vChQuKiYlxjI2MjFTVqlWVkJBQ4Pays7OVlZXltAAAAOTHpUGocePGmj17tlauXKkZM2bo4MGDuu+++3Tq1CmlpaXJ09NTgYGBTuuEhIQoLS2twG1OmDBBdrvdsYSFhRXzUQAAgFuVS2+NtWvXzvHnevXqqXHjxgoPD9fChQvl4+NTqG2OGDFCQ4cOdbzOysoiDAEAgHy5/NbY7wUGBurOO+9UUlKSQkNDlZOTo4yMDKcx6enp+c4puszLy0sBAQFOCwAAQH5KVBA6ffq09u/fr0qVKikqKkoeHh5avXq1oz8xMVHJycmKjo52YZUAAKC0cOmtseeff14dOnRQeHi4jh49qtGjR8vd3V3dunWT3W5X7969NXToUAUHBysgIEDx8fGKjo7miTEAAFAkXBqEDh8+rG7duunXX39VhQoV1Lx5c23atEkVKlSQJE2ePFlubm6Ki4tTdna2YmNjNX36dFeWDAAAShGXBqH58+dftd/b21vTpk3TtGnTblJFAADASkrUHCEAAICbiSAEAAAsiyAEAAAsiyAEAAAsiyAEAAAsiyAEAAAsiyAEAAAsiyAEAAAsiyAEAAAsiyAEAAAsiyAEAAAsiyAEAAAsiyAEAAAsiyAEAAAsiyAEAAAsiyAEAAAsiyAEAAAsiyAEAAAsiyAEAAAsiyAEAAAsiyAEAAAsiyAEAAAsiyAEAAAsiyAEAAAsiyAEAAAsiyAEAAAsiyAEAAAsiyAEAAAsiyAEAAAsiyAEAAAsiyAEAAAsiyAEAAAsiyAEAAAsiyAEAAAsiyAEAAAsiyAEAAAsiyAEAAAsiyAEAAAsiyAEAAAsiyAEAAAsiyAEAAAsiyAEAAAsiyAEAAAsq8QEoVdeeUU2m02DBw92tJ0/f14DBgxQuXLl5Ofnp7i4OKWnp7uuSAAAUKqUiCC0detWvfPOO6pXr55T+5AhQ7Rs2TJ99NFHWrdunY4ePaouXbq4qEoAAFDauDwInT59Wt27d9d7772noKAgR3tmZqZmzpypN954Q61atVJUVJRmzZqljRs3atOmTS6sGAAAlBYuD0IDBgxQ+/btFRMT49S+fft2Xbhwwak9MjJSVatWVUJCQoHby87OVlZWltMCAACQnzKu3Pn8+fO1Y8cObd26NU9fWlqaPD09FRgY6NQeEhKitLS0Arc5YcIEjR07tqhLBQAApZDLrgilpKToueee04cffihvb+8i2+6IESOUmZnpWFJSUops2wAAoHRxWRDavn27jh07poYNG6pMmTIqU6aM1q1bp6lTp6pMmTIKCQlRTk6OMjIynNZLT09XaGhogdv18vJSQECA0wIAAJAfl90ae/DBB/X99987tT399NOKjIzUCy+8oLCwMHl4eGj16tWKi4uTJCUmJio5OVnR0dGuKBkAAJQyLgtC/v7+uuuuu5zafH19Va5cOUd77969NXToUAUHBysgIEDx8fGKjo5WkyZNXFEyAAAoZVw6WfpaJk+eLDc3N8XFxSk7O1uxsbGaPn26q8sCAAClRIkKQmvXrnV67e3trWnTpmnatGmuKQgAAJRqLv8cIQAAAFchCAEAAMv6Q0EoJydHiYmJunjxYlHVAwAAcNMUKgidPXtWvXv3VtmyZVWnTh0lJydLkuLj4/XKK68UaYEAAADFpVBBaMSIEdq1a5fWrl3r9KnQMTExWrBgQZEVBwAAUJwK9dTYkiVLtGDBAjVp0kQ2m83RXqdOHe3fv7/IigMAAChOhboidPz4cVWsWDFP+5kzZ5yCEQAAQElWqCB0zz33aPny5Y7Xl8PPv//9b77+AgAA3DIKdWts/PjxateunXbv3q2LFy/qzTff1O7du7Vx40atW7euqGsEAAAoFoW6ItS8eXPt2rVLFy9eVN26dfXFF1+oYsWKSkhIUFRUVFHXCAAAUCxu+IrQhQsX1K9fP7344ot67733iqMmAACAm+KGrwh5eHjo448/Lo5aAAAAbqpC3Rrr1KmTlixZUsSlAAAA3FyFmix9xx13aNy4cdqwYYOioqLk6+vr1D9o0KAiKQ4AAKA4FSoIzZw5U4GBgdq+fbu2b9/u1Gez2QhCAADgllCoIHTw4MGirgMAAOCm+0PfPi9JxhgZY4qiFgAAgJuq0EFo7ty5qlu3rnx8fOTj46N69erpgw8+KMraAAAAilWhbo298cYbevHFFzVw4EA1a9ZMkrR+/Xo9++yz+uWXXzRkyJAiLRIAAKA4FCoIvfXWW5oxY4Z69OjhaHv44YdVp04djRkzhiAEAABuCYW6NZaamqqmTZvmaW/atKlSU1P/cFEAAAA3Q6GCUI0aNbRw4cI87QsWLNAdd9zxh4sCAAC4GQp1a2zs2LHq2rWrvv76a8ccoQ0bNmj16tX5BiQAAICSqFBXhOLi4rR582aVL19eS5Ys0ZIlS1S+fHlt2bJFnTt3LuoaAQAAikWhrghJUlRUlP7zn/8UZS0AAAA3VaGuCK1YsUKff/55nvbPP/9cn3322R8uCgAA4GYoVBAaPny4Ll26lKfdGKPhw4f/4aIAAABuhkIFoX379ql27dp52iMjI5WUlPSHiwIAALgZChWE7Ha7Dhw4kKc9KSlJvr6+f7goAACAm6FQQahjx44aPHiw9u/f72hLSkrSX//6Vz388MNFVhwAAEBxKlQQmjhxonx9fRUZGalq1aqpWrVqioyMVLly5fT6668XdY0AAADFolCPz9vtdm3cuFGrVq3Srl275OPjo/r16+u+++4r6voAAACKzQ1dEUpISNCnn34qSbLZbGrTpo0qVqyo119/XXFxcerbt6+ys7OLpVAAAICidkNBaNy4cfrxxx8dr7///nv16dNHrVu31vDhw7Vs2TJNmDChyIsEAAAoDjcUhHbu3KkHH3zQ8Xr+/Pm699579d5772no0KGaOnUq3zUGAABuGTcUhE6ePKmQkBDH63Xr1qldu3aO140aNVJKSkrRVQcAAFCMbigIhYSE6ODBg5KknJwc7dixQ02aNHH0nzp1Sh4eHkVbIQAAQDG5oSD0pz/9ScOHD9c333yjESNGqGzZsk5Pin333XeqXr16kRcJAABQHG7o8fmXXnpJXbp0UYsWLeTn56c5c+bI09PT0f/++++rTZs2RV4kAABAcbihIFS+fHl9/fXXyszMlJ+fn9zd3Z36P/roI/n5+RVpgQAAAMWl0B+omJ/g4OA/VAwAAMDNVKiv2AAAACgNCEIAAMCyCEIAAMCyXBqEZsyYoXr16ikgIEABAQGKjo7WZ5995ug/f/68BgwYoHLlysnPz09xcXFKT093YcUAAKA0cWkQqlKlil555RVt375d27ZtU6tWrdSxY0fH95kNGTJEy5Yt00cffaR169bp6NGj6tKliytLBgAApUihnhorKh06dHB6/c9//lMzZszQpk2bVKVKFc2cOVPz5s1Tq1atJEmzZs1SrVq1tGnTJqdPtAYAACiMEjNH6NKlS5o/f77OnDmj6Ohobd++XRcuXFBMTIxjTGRkpKpWraqEhIQCt5Odna2srCynBQAAID8uD0Lff/+9/Pz85OXlpWeffVaLFy9W7dq1lZaWJk9PTwUGBjqNDwkJUVpaWoHbmzBhgux2u2MJCwsr5iMAAAC3KpcHoZo1a2rnzp3avHmz+vfvr549e2r37t2F3t6IESOUmZnpWFJSUoqwWgAAUJq4dI6QJHl6eqpGjRqSpKioKG3dulVvvvmmunbtqpycHGVkZDhdFUpPT1doaGiB2/Py8pKXl1dxlw0AAEoBl18RulJubq6ys7MVFRUlDw8PrV692tGXmJio5ORkRUdHu7BCAABQWrj0itCIESPUrl07Va1aVadOndK8efO0du1aff7557Lb7erdu7eGDh2q4OBgBQQEKD4+XtHR0TwxBgAAioRLg9CxY8fUo0cPpaamym63q169evr888/VunVrSdLkyZPl5uamuLg4ZWdnKzY2VtOnT3dlyQAAoBRxaRCaOXPmVfu9vb01bdo0TZs27SZVBAAArKTEzRECAAC4WQhCAADAsghCAADAsghCAADAsghCAADAsghCAADAsghCAADAsghCAADAsghCAADAsghCAADAsghCAADAsghCAADAsghCAADAsghCAADAsghCAADAsghCAADAsghCAADAsghCAADAsghCAADAsghCAADAsghCAADAsghCAADAsghCAADAsghCAADAsghCAADAsghCAADAsghCAADAsghCAADAsghCAADAsghCAADAsghCAADAsghCAADAsghCAADAsghCAADAsghCAADAsghCAADAsghCAADAsghCAADAsghCAADAsghCAADAsghCAADAsghCAADAsghCAADAslwahCZMmKBGjRrJ399fFStWVKdOnZSYmOg05vz58xowYIDKlSsnPz8/xcXFKT093UUVAwCA0sSlQWjdunUaMGCANm3apFWrVunChQtq06aNzpw54xgzZMgQLVu2TB999JHWrVuno0ePqkuXLi6sGgAAlBZlXLnzlStXOr2ePXu2KlasqO3bt+v+++9XZmamZs6cqXnz5qlVq1aSpFmzZqlWrVratGmTmjRp4oqyAQBAKVGi5ghlZmZKkoKDgyVJ27dv14ULFxQTE+MYExkZqapVqyohISHfbWRnZysrK8tpAQAAyE+JCUK5ubkaPHiwmjVrprvuukuSlJaWJk9PTwUGBjqNDQkJUVpaWr7bmTBhgux2u2MJCwsr7tIBAMAtqsQEoQEDBuiHH37Q/Pnz/9B2RowYoczMTMeSkpJSRBUCAIDSxqVzhC4bOHCgPv30U3399deqUqWKoz00NFQ5OTnKyMhwuiqUnp6u0NDQfLfl5eUlLy+v4i4ZAACUAi69ImSM0cCBA7V48WJ99dVXqlatmlN/VFSUPDw8tHr1akdbYmKikpOTFR0dfbPLBQAApYxLrwgNGDBA8+bN0yeffCJ/f3/HvB+73S4fHx/Z7Xb17t1bQ4cOVXBwsAICAhQfH6/o6GieGAMAAH+YS4PQjBkzJEktW7Z0ap81a5Z69eolSZo8ebLc3NwUFxen7OxsxcbGavr06Te5UgAAUBq5NAgZY645xtvbW9OmTdO0adNuQkUAAMBKSsxTYwAAADcbQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFiWS4PQ119/rQ4dOqhy5cqy2WxasmSJU78xRqNGjVKlSpXk4+OjmJgY7du3zzXFAgCAUselQejMmTOqX7++pk2blm//xIkTNXXqVL399tvavHmzfH19FRsbq/Pnz9/kSgEAQGlUxpU7b9eundq1a5dvnzFGU6ZM0ciRI9WxY0dJ0ty5cxUSEqIlS5bo8ccfv5mlAgCAUqjEzhE6ePCg0tLSFBMT42iz2+1q3LixEhISClwvOztbWVlZTgsAAEB+SmwQSktLkySFhIQ4tYeEhDj68jNhwgTZ7XbHEhYWVqx1AgCAW1eJDUKFNWLECGVmZjqWlJQUV5cEAABKqBIbhEJDQyVJ6enpTu3p6emOvvx4eXkpICDAaQEAAMhPiQ1C1apVU2hoqFavXu1oy8rK0ubNmxUdHe3CygAAQGnh0qfGTp8+raSkJMfrgwcPaufOnQoODlbVqlU1ePBgvfzyy7rjjjtUrVo1vfjii6pcubI6derkuqIBAECp4dIgtG3bNj3wwAOO10OHDpUk9ezZU7Nnz9awYcN05swZ9e3bVxkZGWrevLlWrlwpb29vV5UMAABKEZcGoZYtW8oYU2C/zWbTuHHjNG7cuJtYFQAAsIoSO0cIAACguBGEAACAZRGEAACAZRGEAACAZRGEAACAZRGEAACAZRGEAACAZRGEAACAZRGEAACAZRGEAACAZRGEAACAZRGEAACAZRGEAACAZRGEAACAZRGEAACAZRGEAACAZRGEAACAZRGEAACAZRGEAACAZRGEAACAZRGEAACAZRGEAACAZRGEAACAZRGEAACAZRGEAACAZRGEAACAZRGEAACAZRGEAACAZRGEAACAZRGEAACAZRGEAACAZRGEAACAZRGEAACAZRGEAACAZRGEAACAZRGEAACAZRGEAACAZRGEAACAZRGEAACAZRGEAACAZRGEAACAZRGEAACAZRGEAACAZRGEAACAZd0SQWjatGmKiIiQt7e3GjdurC1btri6JAAAUAqU+CC0YMECDR06VKNHj9aOHTtUv359xcbG6tixY64uDQAA3OJKfBB644031KdPHz399NOqXbu23n77bZUtW1bvv/++q0sDAAC3uDKuLuBqcnJytH37do0YMcLR5ubmppiYGCUkJOS7TnZ2trKzsx2vMzMzJUlZWVnFUmNu9tli2S5Q2hXXz6SrcC4ACqe4zgWXt2uMueq4Eh2EfvnlF126dEkhISFO7SEhIdqzZ0++60yYMEFjx47N0x4WFlYsNQIoHPsUV1cAoCQo7nPBqVOnZLfbC+wv0UGoMEaMGKGhQ4c6Xufm5urEiRMqV66cbDabCyvDzZaVlaWwsDClpKQoICDA1eUAcAHOA9ZljNGpU6dUuXLlq44r0UGofPnycnd3V3p6ulN7enq6QkND813Hy8tLXl5eTm2BgYHFVSJuAQEBAZwAAYvjPGBNV7sSdFmJnizt6empqKgorV692tGWm5ur1atXKzo62oWVAQCA0qBEXxGSpKFDh6pnz5665557dO+992rKlCk6c+aMnn76aVeXBgAAbnElPgh17dpVx48f16hRo5SWlqa7775bK1euzDOBGriSl5eXRo8enedWKQDr4DyAa7GZaz1XBgAAUEqV6DlCAAAAxYkgBAAALIsgBAAALIsgBABwOWOM+vbtq+DgYNlsNu3cuVMtW7bU4MGDHWMiIiI0ZcqUm17b6tWrVatWLV26dOmm7/tGrFy5Unfffbdyc3NdXcothSAE2Ww2LVmyxKU17NmzR02aNJG3t7fuvvtuHTp0yHEylKS1a9fKZrMpIyPjptf21FNPafz48Td9vzeqSZMm+vjjj11dBkq4Xr16qVOnTq4uI4+VK1dq9uzZ+vTTT5Wamqq77rpLixYt0ksvveTq0jRs2DCNHDlS7u7uhVp/0aJFatOmjeMbDi6f166UkJCgVq1aydfXVwEBAbr//vt17tw5R39ERIRsNpvT8sorrzj627ZtKw8PD3344YeFqtOqCEKl3PHjx9W/f39VrVpVXl5eCg0NVWxsrDZs2HBT9n+9IWv06NHy9fVVYmKiVq9erbCwMMfJ0JV27dqlFStWaNCgQYXexqBBgxQVFSUvLy/dfffd+Y757rvvdN9998nb21thYWGaOHFinjEfffSRIiMj5e3trbp162rFihVO/SNHjtTw4cP5bRC3pP3796tSpUpq2rSpQkNDVaZMGQUHB8vf39+lda1fv1779+9XXFycoy0jI+OGvij0zJkzat68uV599dUCxyQkJKht27Zq06aNtmzZoq1bt2rgwIFyc3P+b3rcuHFKTU11LPHx8U79vXr10tSpU6+7NhCESr24uDh9++23mjNnjvbu3aulS5eqZcuW+vXXX4t1vzk5OTc0fv/+/WrevLnCw8NVrlw5ubu7O06GrvTWW2/p0UcflZ+f33Wvk5qaqosXLzq1PfPMM+ratWu+47OystSmTRuFh4dr+/bteu211zRmzBi9++67jjEbN25Ut27d1Lt3b3377bfq1KmTOnXqpB9++MExpl27djp16pQ+++yzGzxK4P+tW7dO9957r7y8vFSpUiUNHz7c6d9zy5YtNWjQIA0bNkzBwcEKDQ3VmDFjnLaxZ88eNW/eXN7e3qpdu7a+/PLLq/5S1KtXL8XHxys5OVk2m00RERGOff3+1tiVbDab3nnnHT300EMqW7asatWqpYSEBCUlJally5by9fVV06ZNtX//fsc6u3bt0gMPPCB/f38FBAQoKipK27ZtK3Af8+fPV+vWreXt7e20jdDQUD355JNatWrVNX/5eOqppzRq1CjFxMQUOGbIkCEaNGiQhg8frjp16qhmzZp67LHH8nz+kb+/v0JDQx2Lr6+vU3+HDh20bds2p2PGNRiUWidPnjSSzNq1a686TpJ57733TKdOnYyPj4+pUaOG+eSTT5zGrF271jRq1Mh4enqa0NBQ88ILL5gLFy44+lu0aGEGDBhgnnvuOVOuXDnTsmVLEx4ebiQ5lvDw8AL3//tl9OjR5uDBg0aS+fbbb40xxqxZs8ZIMidPnjTGGDNr1ixjt9vNsmXLzJ133ml8fHxMXFycOXPmjJk9e7YJDw83gYGBJj4+3ly8eNGxr2nTppkaNWoYLy8vU7FiRRMXF1fg+3Lx4kVjt9vNp59+etX3zxhjzp07Z+bPn2/atm1r3N3dTUZGRp4xo0ePNvXr18/TPn36dBMUFGSys7MdbS+88IKpWbOm4/Vjjz1m2rdv77Re48aNTb9+/Zzann76afPkk09es15YV8+ePU3Hjh3z7Tt8+LApW7as+ctf/mJ++ukns3jxYlO+fHkzevRox5gWLVqYgIAAM2bMGLN3714zZ84cY7PZzBdffGGM+e3npmbNmqZ169Zm586d5ptvvjH33nuvkWQWL16c734zMjLMuHHjTJUqVUxqaqo5duyYY1/PPfecY1x4eLiZPHmy47Ukc9ttt5kFCxaYxMRE06lTJxMREWFatWplVq5caXbv3m2aNGli2rZt61inTp065sknnzQ//fST2bt3r1m4cKHZuXNnge9XvXr1zCuvvOLUlpuba9auXWueeeYZExAQYKpUqWJGjBhh9uzZU+B2jDF5zmuXpaenG0lm6tSpJjo62lSsWNHcf//95ptvvnEaFx4ebkJCQkxwcLC5++67zcSJE53Ow5eFhISYWbNmXbUW/D+CUCl24cIF4+fnZwYPHmzOnz9f4DhJpkqVKmbevHlm3759ZtCgQcbPz8/8+uuvxpjrPzn6+fmZv/3tb2bPnj1mz5495tixY0aSmTVrltPJ7UqpqammTp065q9//atJTU01p06duq4g5OHhYVq3bm127Nhh1q1bZ8qVK2fatGljHnvsMfPjjz+aZcuWGU9PTzN//nxjjDFbt2417u7uZt68eebQoUNmx44d5s033yzwfdmxY4eRZNLS0gocs3HjRtOvXz8TGBhoKleubJ5//nnz/fff5zu2oCD01FNP5fmP6auvvjKSzIkTJ4wxxoSFhTn9B2CMMaNGjTL16tVzapsxY0aBgRMw5upB6O9//7upWbOmyc3NdbRNmzbN+Pn5mUuXLhljfvtZb968udN6jRo1Mi+88IIxxpjPPvvMlClTxqSmpjr6V61addUgZIwxkydPzvNv93qC0MiRIx2vExISjCQzc+ZMR9t///tf4+3t7Xjt7+9vZs+eXWAdV7Lb7Wbu3LkF9p89e9bMmzfPtG3b1pQpU8Y0btzYzJgxI99fhgoKQpfrDg4ONu+//77ZsWOHGTx4sPH09DR79+51jJs0aZJZs2aN2bVrl5kxY4YJDAw0Q4YMybOfBg0amDFjxlz3MVpdif+KDRRemTJlNHv2bPXp00dvv/22GjZsqBYtWujxxx9XvXr1nMb26tVL3bp1kySNHz9eU6dO1ZYtW9S2bVtNnz5dYWFh+te//iWbzabIyEgdPXpUL7zwgkaNGuW4h33HHXfkO7clMDBQoaGhBdZ5+RaYn5+fY9wvv/xyzeO7cOGCZsyYoerVq0uSHnnkEX3wwQdKT0+Xn5+fateurQceeEBr1qxR165dlZycLF9fXz300EPy9/dXeHi4GjRoUOD2f/75Z7m7u6tixYpO7YcPH9acOXM0Z84cHTlyRJ07d9aCBQsUExOT537+9UhLS1O1atWc2i5/hUxaWpqCgoKUlpaW52tlQkJClJaW5tRWuXJlpaSkKDc3t1C1wNp++uknRUdHy2azOdqaNWum06dP6/Dhw6pataok5Tl/VKpUSceOHZMkJSYmKiwszOln/t577y22mn9fy+Wfkbp16zq1nT9/XllZWQoICNDQoUP15z//WR988IFiYmL06KOPOs4h+Tl37pzTbbEr+fj4qFu3burWrZv27t2rbt26qX///jp//vxVb+v93uVba/369XN8j2aDBg20evVqvf/++5owYYKk37578/fH7enpqX79+mnChAlOt9B8fHx09uzZ69o3mCNU6sXFxeno0aNaunSp2rZtq7Vr16phw4aaPXu207jfn0wuP7Fw+cR2rZPjZVFRUcV7MFcoW7as0wksJCREERERTvN5QkJCHMfRunVrhYeH6/bbb9dTTz2lDz/88Koni3PnzsnLy8vpuKXfJiWPHDlSdevWVUpKiv7zn/+oTZs2JSJ4+Pj4KDc3V9nZ2a4uBaWYh4eH02ubzeaySfq/r+Xyz2p+bZfrGzNmjH788Ue1b99eX331lWrXrq3FixcXuP3y5cvr5MmTBfZfvHhRK1asULdu3XT33XcrOztbEydOVPfu3a/7GCpVqiRJql27tlN7rVq1lJycXOB6jRs31sWLF3Xo0CGn9hMnTqhChQrXvX+rc/2ZG8XO29tbrVu31osvvqiNGzeqV69eGj16tNOYojixXTlpr7jlV/PVjsPf3187duzQf//7X1WqVEmjRo1S/fr1C3wkv3z58jp79myeid+Xn87avHmz7rzzTg0cOFCbN28u9HGEhoYqPT3dqe3y68u/VRc05sorbSdOnJCvr698fHwKXQ+s6/JkY/O7r6DcsGGD/P39VaVKlevaRs2aNZWSkuL073Xr1q1FXusfceedd2rIkCH64osv1KVLF82aNavAsQ0aNNDu3bvztO/YsUNDhgxRlSpV1KNHD5UvX15ff/21fvjhB/3tb3+7oSASERGhypUrKzEx0al97969Cg8PL3C9nTt3ys3Nzemq9fnz57V///6rXu2GM4KQBdWuXVtnzpy57vF/5OTo4eFRoj6ErEyZMoqJidHEiRP13Xff6dChQ/rqq6/yHXv5UfcrT4I1atTQhAkTlJycrHnz5unkyZN64IEHdOedd+qll17SwYMHb6im6Ohoff3117pw4YKjbdWqVapZs6aCgoIcY1avXu203qpVqxQdHe3U9sMPP3ACxDVlZmZq586dTktKSor+8pe/KCUlRfHx8dqzZ48++eQTjR49WkOHDr3uK56tW7dW9erV1bNnT3333XfasGGDRo4cKUl5rq7ebOfOndPAgQO1du1a/fzzz9qwYYO2bt2qWrVqFbhObGys1q9f79T2zTffqEmTJjpw4ICmT5+uo0eP6q233tI999yT7zZOnDihnTt3Os4liYmJ2rlzp+PWts1m09/+9jdNnTpV//vf/5SUlKQXX3xRe/bsUe/evSX99nj9lClTtGvXLh04cEAffvihhgwZoieffNJxnpCkTZs2ycvLK8+5AQVjjlAp9uuvv+rRRx/VM888o3r16snf31/btm3TxIkT1bFjx+vezl/+8hdNmTJF8fHxGjhwoBITE6/75BgREaHVq1erWbNm8vLycvqBvdk+/fRTHThwQPfff7+CgoK0YsUK5ebmqmbNmvmOr1Chgho2bKj169fn+/k/bm5uatOmjdq0aaOsrCwtXLhQc+bM0ZgxY3Ty5EkFBARIkpKSknT69GmlpaXp3Llzjg9Tq127tjw9PfXEE09o7Nix6t27t1544QX98MMPevPNNzV58mTHvp577jm1aNFCkyZNUvv27TV//nxt27bN6RF76bcTdJs2bYrmDUOptXbt2jyBuXfv3vr3v/+tFStW6G9/+5vq16+v4OBg9e7d2xFkroe7u7uWLFmiP//5z2rUqJFuv/12vfbaa+rQocNV59rcDO7u7vr111/Vo0cPpaenq3z58urSpYvGjh1b4Drdu3fXsGHDlJiY6DhX1K5dW0eOHLnuqz5Lly51zP2RpMcff1zSb5+fdvmjBwYPHqzz589ryJAhOnHihOrXr69Vq1Y5bv97eXlp/vz5GjNmjLKzs1WtWjUNGTLEad6QJP33v/9V9+7dVbZs2et+XyzP1bO1UXzOnz9vhg8fbho2bGjsdrspW7asqVmzphk5cqQ5e/asY5zyeZrDbrc7PX55PY/P//7pjsuWLl1qatSoYcqUKXPVp5nq16/v9BTa9T4+/3v5PZX1+ydkvvnmG9OiRQsTFBRkfHx8TL169cyCBQsKrMmY3x5tb9KkyVXHXCkpKcnk5OQ4Xrdo0SLPRwRIMgcPHnSM2bVrl2nevLnx8vIyt912W57HdY0xZuHChebOO+80np6epk6dOmb58uVO/YcPHzYeHh4mJSXlhuoFitv69euNJJOUlOTqUgrl+eefN3379nV1Gdd0/PhxExwcbA4cOODqUm4pNmN+d78DgJNz586pZs2aWrBgQYm/1PzCCy/o5MmTea4SATfb4sWL5efnpzvuuENJSUl67rnnFBQUlOcW060iIyND06dP1/Dhw0vEQxEFufxBigV9eCvyRxACrmHt2rU6deqUOnTo4OpSrmrSpEl68skn8zxmD9xsc+fO1csvv6zk5GSVL19eMTExmjRpksqVK+fq0oA8CEIAAMCySu41PgAAgGJGEAIAAJZFEAIAAJZFEAIAAJZFEAIAAJZFEALwh7Vs2dLpm7YjIiI0ZcoUl9UDANeLIATguvTq1Us2my3PkpSUpEWLFumll15ydYnXREADcCW+awzAdWvbtm2eb+quUKGC3N3dXVTRrSsnJ0eenp6uLgOwPK4IAbhuXl5eCg0NdVrc3d3z3Bq7ks1m0zvvvKOHHnpIZcuWVa1atZSQkKCkpCS1bNlSvr6+atq0qfbv33/V/R8+fFjdunVTcHCwfH19dc8992jz5s2SpP3796tjx44KCQmRn5+fGjVqpC+//NKxbsuWLfXzzz9ryJAhjqtZl61fv1733XeffHx8FBYWpkGDBunMmTOO/tTUVLVv314+Pj6qVq2a5s2bl+fqUnJysjp27Cg/Pz8FBAToscceU3p6uqN/zJgxuvvuu/Xvf/9b1apVk7e3t+bOnaty5copOzvb6Tg7deqkp5566qrvBYCiQRACcFO89NJL6tGjh3bu3KnIyEg98cQT6tevn0aMGKFt27bJGKOBAwcWuP7p06fVokULHTlyREuXLtWuXbs0bNgw5ebmOvr/9Kc/afXq1fr222/Vtm1bdejQQcnJyZKkRYsWqUqVKho3bpxSU1OVmpoq6bcA1bZtW8XFxem7777TggULtH79eqdaevTooaNHj2rt2rX6+OOP9e677+rYsWOO/tzcXHXs2FEnTpzQunXrtGrVKh04cCDPdz4lJSXp448/1qJFi7Rz5049+uijunTpkpYuXeoYc+zYMS1fvlzPPPPMH3/TAVybC7/wFcAtpGfPnsbd3d34+vo6lkceecQYY0yLFi3Mc8895xgbHh5uJk+e7HgtyYwcOdLxOiEhwUgyM2fOdLT997//Nd7e3gXu/5133jH+/v7m119/ve6a69SpY956660C6zLGmN69e+f5ZvFvvvnGuLm5mXPnzpmffvrJSDJbt2519O/bt89Icmzriy++MO7u7iY5Odkx5scffzSSzJYtW4wxxowePdp4eHiYY8eOOe2rf//+pl27do7XkyZNMrfffrvJzc297uMEUHjMEQJw3R544AHNmDHD8drX1/e6161Xr57jz5e/GLZu3bpObefPn1dWVpYCAgLyrL9z5041aNBAwcHB+W7/9OnTGjNmjJYvX67U1FRdvHhR586dc1wRKsiuXbv03Xff6cMPP3S0GWOUm5urgwcPau/evSpTpowaNmzo6K9Ro4aCgoIcr3/66SeFhYUpLCzM0Va7dm0FBgbqp59+UqNGjSRJ4eHhqlChgtP++/Tpo0aNGunIkSO67bbbNHv2bMfEdADFjyAE4Lr5+vqqRo0ahVrXw8PD8efL/8nn13b5VteVfHx8rrr9559/XqtWrdLrr7+uGjVqyMfHR4888ohycnKuut7p06fVr18/DRo0KE9f1apVtXfv3quufyPyC44NGjRQ/fr1NXfuXLVp00Y//vijli9fXmT7BHB1BCEAt4R69erp3//+t06cOJHvVaENGzaoV69e6ty5s6TfAs6hQ4ecxnh6eurSpUtObQ0bNtTu3bsLDHg1a9bUxYsX9e233yoqKkrSb3N9Tp486RhTq1YtpaSkKCUlxXFVaPfu3crIyFDt2rWveWx//vOfNWXKFB05ckQxMTFOV5YAFC8mSwO4JXTr1k2hoaHq1KmTNmzYoAMHDujjjz9WQkKCJOmOO+5wTELetWuXnnjiiTxXlyIiIvT111/ryJEj+uWXXyRJL7zwgjZu3KiBAwdq586d2rdvnz755BPHZOnIyEjFxMSob9++2rJli7799lv17dtXPj4+jqtYMTExqlu3rrp3764dO3Zoy5Yt6tGjh1q0aKF77rnnmsf2xBNP6PDhw3rvvfeYJA3cZAQhALcET09PffHFF6pYsaL+9Kc/qW7dunrllVccn2H0xhtvKCgoSE2bNlWHDh0UGxvrNK9HksaNG6dDhw6pevXqjrk69erV07p167R3717dd999atCggUaNGqXKlSs71ps7d65CQkJ0//33q3PnzurTp4/8/f3l7e0t6bfbep988omCgoJ0//33KyYmRrfffrsWLFhwXcdmt9sVFxcnPz8/derUqQjeLQDXy2aMMa4uAgBuJYcPH1ZYWJi+/PJLPfjgg0WyzQcffFB16tTR1KlTi2R7AK4PQQgAruGrr77S6dOnVbduXaWmpmrYsGE6cuSI9u7d6zThuzBOnjyptWvX6pFHHtHu3btVs2bNIqoawPVgsjQAXMOFCxf097//XQcOHJC/v7+aNm2qDz/88A+HIOm3p8ZOnjypV199lRAEuABXhAAAgGUxWRoAAFgWQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFgWQQgAAFjW/wGtwDEL4IeajQAAAABJRU5ErkJggg==",
      "text/plain": [
       "<Figure size 640x480 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "fig = plt.figure()\n",
    "ax = fig.add_axes([0.1,0.1,0.8,0.8])    \n",
    "\n",
    "labels = ['Short films (<100)', 'Long films (>165)']\n",
    "scores = [imdb_movies[imdb_movies['Runtime (Minutes)'] < 100]['Metascore'].mean(), #mean of movie rating less than 100 min\n",
    "          imdb_movies[imdb_movies['Runtime (Minutes)'] > 165]['Metascore'].mean()] #mean of movie ratings more that 2hr 45min\n",
    "\n",
    "ax.set_xlabel('Film category')\n",
    "ax.set_ylabel('Score')\n",
    "ax.set_title('Score vs Film Length')\n",
    "\n",
    "ax.bar(labels,scores)\n",
    "\n",
    "plt.show()\n",
    "#plt.savefig('bar1.png', dpi=200)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "8274668b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<Axes: xlabel='Runtime (Minutes)', ylabel='Rating'>"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAioAAAGwCAYAAACHJU4LAAAAOnRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjEwLjAsIGh0dHBzOi8vbWF0cGxvdGxpYi5vcmcvlHJYcgAAAAlwSFlzAAAPYQAAD2EBqD+naQAASYVJREFUeJzt3Xt4FPXZP/735kCOZAk5EAKBhBAQEDAWsBABtTyKRUWwaDFyzNNqDSL4xULqo621glpREBGlIoIHRFvA1P6sokCAcAgYIqAYAjmBAtkEkpAEQkjm94fuuruZncNmd2d29/26rlxXmcNn7p2a2TufuecegyAIAoiIiIh0KEDrAIiIiIgcYaJCREREusVEhYiIiHSLiQoRERHpFhMVIiIi0i0mKkRERKRbTFSIiIhIt4K0DqAj2tra8MMPP6Bz584wGAxah0NEREQKCIKAixcvIjExEQEB0nMmXp2o/PDDD0hKStI6DCIiInLCqVOn0LNnT8ltvDpR6dy5M4AfP2hUVJTG0RAREZES9fX1SEpKsnyPS/HqRMV8uycqKoqJChERkZdRUrbBYloiIiLSLSYqREREpFtMVIiIiEi3mKgQERGRbjFRISIiIt1iokJERES6xUSFiIiIdIuJChEREekWExUiIiLSLSYqREREpFte3UKfiIhISqmpARXnm5AcE4GU2AitwyEnMFEhIiKfU9t0BXM3FGFnicmybExaHFZMTYcxPFjDyEgt3vohIiKfM3dDEfJPVNssyz9RjUc2HNIoInIWExUiIvIppaYG7CwxoVUQbJa3CgJ2lphQVt2oUWTkDCYqRETkUyrON0muL69houJNWKNCRES6p6YotnfXcMn1yTEsqvUmTFSIiEi3nCmK7RMXiTFpccg/UW1z+yfQYEBG31g+/eNleOuHiIh0y9mi2BVT05HRN9ZmWUbfWKyYmu7yGMm9OKNCRES6ZC6KtWddFOtodsQYHoz1WSNQVt2I8ppG9lHxYkxUiIhIl5QUxcolHymxTFC8HRMV8nnsTEnkndxRFMvrgfdhokI+i50pibxbn7hIjEqNwZ6TNe3WjUqNUZVo8HrgvVhMSz6LnSmJvJ9dzzbZ5Y7weuC9mKiQT2JnSiLvV2pqwN7S9rMpALC3tEbx7zGvB96NiQr5JHamJPJ+rvo95vXAu7FGhXxCXnEVik7X4vpe0RidFsfOlEQ+wFW/x7weeDcmKuTVKmoacffKfFxoarEsiw4PRm72jexMSeTlXNVhlp1qvRtv/ZBXs09SAOBCUwvuWrmbnSmJfICrfo95PfBenFEhr5VXXNUuSTG70NSCw9/XsjMlkZdzVYdZdqr1XkxUyGsVna6VXF9YeQGj0+LYmZLIB7jq95jXA+/DRIW8UqmpAQYYJLe5vle0h6IhInIOO+XKY6JCXkWsu6SY6PBgjE6L81BURETqsFOuciymJa8i1l3SnvmpHyIivWKnXOU4o0Jew9Er381mjUrGLQPiOZNCRLrm6Fpm3SmXt4F+xhkV8hpy3SXH9I9jkkJEusdOuepwRoU0JVVIZr/O2e6S9uOweI2ItMROueowUSFNSBWSCRAcrlPTXVLsGNHhwTa9V1i8RkSexk656hgEQe3LsvWjvr4eRqMRdXV1iIqK0jocUmH6mgKHv6QAHK5bMTUdj2w4pKhSXuwY9szjrs8a4aqPRkQkq66pRfG1zBep+f7mjAp5nFwhmRjzuvNNVxR1l5QrvLUfl8VrRORJ7JSrHBMV8ji5QjIp5TWNls6SUr/Uao9hHpeIyJPYKVeepk/9tLa24sknn0RKSgrCwsKQmpqKZ555Bl58N4oUkCskk+Kq17o7Oy4REXmWpjMqzz//PFatWoV169Zh0KBBOHjwIGbNmgWj0Yi5c+dqGRq5kVwhGeC4RqWjr3W3x+I1IiJ903RGZc+ePZg4cSImTJiA5ORk/OY3v8Gtt96KgoICLcMiD5B65bo7X+sebVekxte8ExHpm6YzKqNGjcLq1atx/Phx9OvXD19//TV2796Nl156SXT75uZmNDc3W/5dX1/vqVDJxeQKydz5WncWrxEReQ9NE5VFixahvr4e11xzDQIDA9Ha2opnn30WmZmZotsvWbIETz/9tIejJHeSKiRz12vdWbxGROQ9NL318+GHH+K9997D+++/j8LCQqxbtw4vvvgi1q1bJ7p9Tk4O6urqLD+nTp3ycMTkLUpNDdheXIWyaulW1Eq3IyJtOfu7yt9x76dpw7ekpCQsWrQI2dnZlmV/+9vf8O677+K7776T3Z8N38ie0len8xXrRN7B2d9V/o7rm5rvb01nVJqamhAQYBtCYGAg2traNIqIvJ3SV6fzFetE3sHZ31X+jvsOTROVO++8E88++yz+85//oLy8HJs3b8ZLL72ESZMmaRkWeSlzN1r7x5Gtu8+q2Y6ItOXs7yp/x32LponKihUr8Jvf/AYPP/wwBgwYgAULFuDBBx/EM888o2VY5KWUvjqdr1gn8g7O/q7yd9y3aPrUT+fOnbFs2TIsW7ZMyzBElZoaUHG+iY+wKtCRcyW1r/26vOIqFJ2uxfW9ojE6La7dWEpfnc5XrBN5B7nf1aAAg1P76el33BPfNd7+fcZ3/dhhAZZyHTlXUvsKENqtCwow4Grbz9O40eHByM2+EUkxP1+QlL46vU9cJIb0jMLh0+378AztafTKX2QiXyTXYXramgLRa47Sa4GWPPFd4yvfZ5re+tEjFmAp15FzJbWv2DrrJAUALjS14K6Vu9uNq7SrrViSAgBfn66TjZ2IPEfsd9qao2uOqzpcu4snvmt85fuMMypWzAVY9qwLsPSQietBR86V3L5KXWhqwa4Sk81tICWvTn/1yxLJcV/bfgIP39xXcRxE5D7m3+mdx6sw/a0D7dY7uuYouRZoxRPfNb70fcYZFSsswFKuI+dKbl81CisviC5PiY3Azf3jRX8R809Wi+zxs10qkiUi8oxWmY5fjq45UtcCrXjiu8aXvs+YqFjxpgIsrcmdq7N1lx0+Aii3rxrBAeL/CUt1o8xIdTyNDEC0UJeItOVL12dPfBZfOl9MVKyYC7ACDbaV5IEGA8akxekqI9eao3NllrPpCG5+cQemrylAXVOLon3N51lqXHsvfFaM9L9+jlM1P/71UNt0BdPXFOCWpXmYtfaAaAxzfpUmOSZv+xDpjy9dnz3xWXzpfDFRsaP3Aiw9kStyA5wrdFMyrjXrwlqlxWOBDvIgR8uJSHu+dH32xGfxlfOl6bt+Osqd7/rRYwGWXpVVN2JfaTVyNh11uM32BTeJnkep86xkXGsv3DMEf/zXYdkYNhZUYuGmIw63+/tvhmDKsCRFxyQiz/Ol67MnPosez5ea728+9eNASqx+/g/Vu5TYCNnCrPIa8QpzqfOsZFxre0qli2TNMewtq5HcLv9kNRMVIh3zpeuzJz6Lt58v3vrxce56xbn9uK4o3BKLVU3hbdfwTopiGJkSI7mdXLEtEZG/cNd3iBqcUfFR7upIKDWus50gpcbsExeJkX1isLdUehYEAN7KLxddbh/DfSN64YktR9s1kQN+7IDL2RQi8nd66mrLGRUf5a6OhFLjOlu4JRerwgeAHBKLITc7o917QoICDMjNzujYwYiIfICeutpyRsUHuasjody455uuqO4EKTfmzuNV2HNSfjZFzJLJg/HLPjGiMQzsYcSJxb/GRwdPIf9kNTJSYzmTQkQE/XW1ZaLig5R0JHTmPzKl46op3JIb89CpWqXhtZNgDJWNY8qwJCYoRERW3PUd4ize+vFB7upI6I5x5cYM6MB9H0fdcfVQHEZE+sNrw4/01tWWMyo+yF2vOHfHuHKvcV/6+XHR/czHvNxyFQXl4u/7yfmpV4q5AEyAoJviMCLSDz0VjuqBu75DnMUZFR/lro6E7hhXbSda62MWn7sou625AExPxWFEpB+8NrSnp6627Ezr49zVkdAd4yrpRPvc5MG44acC2bziKsxY2/61785w1DmXiHxbqakBtyzNc7je368N7voOYWdasnBXR0J3jKukE203qwLZotO1Lju2p4vDiEgf9FY4qjd66GrLRIWcUmpqQMX5Jpdn2UqLuEpNDXDl+wO96ZXnROQ6eiscpfaYqJAq7i46kyviig4PxvQ1BaLP+DtDq+IwItIHvRWOUnsspiVVPFF0JlXEJXb8jvDGV54TkWvpqXCU2uOMCinmqW6FxvBg0Q63jo5vNjm9BzYd+l7RMaS61hKRf3F0zSF9YKJCinm66My+iEvu+L1jlb9pWUnXWiLyL3ooHKX2mKiQYs4WnSktvJXbTu4+pZr7mCyQIyLyDkxUSDG1RWdKC2/lthNbL2bp1hJFn2Mkb/kQEXkNFtOSKmqKzpQW3spt5+oC2g68PoiIiDyMMyqkitKiM6WFt3Lb7Txe5bJHkc32nKzx+GvKiYjIOZxRIaekxEbg5v7xDr/slRTeKtnu0Klap+KTI9cBl4iI9IEzKuRypaYGnK27LLmNuZhVrkDXXZm0dYdbd3TYJSIi12CiQi6jtOjVupjVUYGumdICWbFjBAcGqOpw68+vdSci0ive+iGXUVr0al/MKlag21EGg/oOt/7+WnciIj3ijAq5hFzXWGv2xazWBbr7SmuQs+lIh+PZc7IG55uuqOpw6+oOu0RE1HGcUSGXkCuKtSdWzJoSG4EEY6irQrIcw77wV2mhLxERaY8zKqSIXNGpXFGsPbHOsBsLKrH12DmnY7T33r4KVF9sxpRhSTbL5bJzdq0l8h0smPd+TFRIktLusnJFsWZiXWyPnK7FpNf24Gqb/H5Fpy6g/vJVRbF/cawKXxyrQs6mI8jNzkBidJhksS9f607kO5Reu0j/eOuHJKkpOhUrXo22uyCIdbGVS1Ic7afU1TYBd63Mly325WvdiXwHC+Z9B2dUyCG1RaeOutZKdbHdWFApmaRkZSTjgZHJSImNQF5xleLZFHtX2wTJYt93skZgdFqcU2MTkb6wYN63MFEhh5QUnYr9stu/Kl3q1el7y2okj1HTdMWyb9HpWpmInSc3o0NE3sPZaxfpE2/9kENyBbLOFJ2WmhqwvbgKZdU/PlkzMiVGcvuM1J9vJV3Xs4vq4ykVFMA3FRL5Cndcu9zF/ppI7Wk6o5KcnIyKiop2yx9++GGsXLlSg4jIWp+4SIxKjcGek+1nPUalxqj6i0SqsO2JLUdFZzSCAgw2T+yM7R+PqNAgp27/BBqAjL6Oi32nrSlgoR2Rj3BU3K+ngnkW+yqn6YzKgQMHcObMGcvP1q1bAQBTpkzRMiyy4ugBHokHe0RJFbblZme0m9EICjAgNztD7MjqDvyT8E5Bsh1wWWhH5DukOlPrAYt9ldN0RiUuzrZ48bnnnkNqairGjh0run1zczOam5st/66vr3drfP6u1NSAvaXiNSR7S2sUF6TJFbY9PXEQTiz+NT46eAr5J6uRkRrbrvcJgJ+KaVsdHuee63vgX4Xfi6672HwVh7+vxfqsEdh5vArT3zrgMB4W2hF5P0fF/XrAYl91dFOjcuXKFbz77ruYPXs2DPYvg/nJkiVLYDQaLT9JSe2/zMh1XNXBVek4U4YlYdl96aJJCiBfTPtD7SXJ9YWVFwAArTKTMuxMS+Q77DtT6wG7Y6ujm0Rly5YtqK2txcyZMx1uk5OTg7q6OsvPqVOnPBegH1JakCZXDCY3zrm6y4oKyeSKaRO7hEmuv3jpx9oWdqYlIi15U7GvHujm8eQ1a9bg9ttvR2JiosNtQkJCEBIS4sGo/JtcQVp0eDCmrynocNfaRT+9hFCukGxs/3h0Dg3ERQe3fxzd9jF7c3cZ3txdJrnNiOSuuvrLi4h8jzcU++qJLmZUKioq8MUXX+B///d/tQ6F7EgVpHW0a609JYVkBrj3MeLic6x7IiL303uxr57oYkZl7dq1iI+Px4QJE7QOhew4KkjrSNfafaU1yPlpFkXJvmYd6UyrVN2lq9hVYmKXWiJyKz0X++qN5jMqbW1tWLt2LWbMmIGgIF3kTSTCviDN2WKwlNgIJBhDndrXnZ1prZmLbomI3E2Pxb56o3lm8MUXX6CyshKzZ8/WOhS/p+Z16GoKUu3HlSskq77YLLqfOzvTWru+V7RHjkNERPI0T1RuvfVWCGq7h5FLqemQKLatNetiMKlxpYprH//nYeRsOmLTrda8X3R4MC40tXT0IztkDAvmbR8iIh3R/NYPaU9NUazYttasi8GkxpUrrrVvqf9zF9sbEe3G9tL9u0W6bWwiIlKPiYqfMxfF2s9sWBe2ym1r9k7WCKzPGgFjeLDsuOebrmB91gg8f89gRXGa97sqCDj01K14J2sEZo7qrfLTyisov8CXgxER6QgTFT+npihWblvrWRCl456tvywXouh+o9PiMLZ/vKp91R6DiIi0p3mNCmlLTYdEuW3NLxYsNTXgbJ10O3vzuAmdpZ8AsmfuYisIAs7WqUtylGJXSCIi/WCi4ufUdEiU6zA7bU2BomLXkX1iRLvaKrFIpP+KWkEBBlyX1AUHK9o/hjy8dzQfEyQi0hHe+iFVHRLlimCVPJFjMMgX5bpLUIABudkZOFHVILq+xMFyIiLShkHw4meD6+vrYTQaUVdXh6ioKK3D8XpqOiTuPG7C9LcKPBSZc2ZnJGPayGQcLD+P/JPVyEiNxZRhScgrrsKMtQcc7vdO1gg+okxE5EZqvr9564csUmKVt3B29OSPnpxvumL5TFOGJVmWy3W4Lay8wESFiEgnmKj4GTXdZ6W2lSus1YOMVPFbVHIFvOxMS6Q/aq5d5FuYqPiJjnaftd+2T1wkhidH40C5Pt+LExRgsJlFAeS76gJAdDg70xLpiZprF/kmFtP6iY52nxXb9vg5+cJTV3WRVTvO4MT29zzlCnijw4ORm32j6tiIyH3UXLvIN3FGxQ+Yu8Tas+4+a55KVbptXnEV6i45fsJnwa39MGFIIlJiI7DzeBWmv+W4eFXKksmD8cs+MUiJjbAp9gWAfaXVyNl0VHS/Q6frFH0us7//Zki7GRgi0paaaxf5Ls6o+AFXdp81bytXkNoqCJYLSGsH6m4TjKGWcaxfh54SG4EEY5iiWAH5zxXbOcT5IInILdRcu8h3cUbFDyjtKKtkW/NsxnU9u0huF2gwWP7a6UjhraMusUq635q72BaU1mDrsXNOHYeItKOmczb5LiYqfkBJR1lzcZrSTrVj+8dLdqF98fPjePHz45ZxR/aJwd7SGlVxj0qNaTetq6Qg1kxJF1uxDrxEpA9qOmeT7+KtHz8h11HWujhNaafa3OwbZYtczeMaDJKbiRJr1eLqjraOOvASkT6o6ZxNvomdaf2MXEfZ7QtusvyVorRT7a4SE748VoW395S7OlybeEpNDbhlaZ5Lxs3KSMYDI5P5FxmRl1DTOZv0j51pySG5jrLlNY02xatKLgij0+JwtU1wS6JiHY9cYZ0aNT91rSUi76Cmczb5FiYqfkbuXl9esQlBAQaMTouT7ARpv85dnWqti+VceZ/S3LWW3S6JiPSNiYqfUFqE+vaecry9pxxBAQZcbft59sVcFCtAcNglckRyNApc2Kl25E/9U9QU0CoRFGDA/wzshulrCtjtkohI51hM6yfUFqFaJynAz0WxUl0ii89ddEmsZuYCXCUdZZUKCjAgNzuD3S6JiLwEZ1T8gFxXViXMnSDVruuIPSdrsPO4SXLsd7JGYHRaHMqqG/Hvr7/HS1tLHG77vzem4P/uGMhul0REXoQzKn7AlUWonnbolPStJPPMT0psBOQeX+sc9mNezm6XRETeg4mKH3BXoasnBEC6AUv1xWbL/5brlnt9r+ifxpTGbpdERPrBRMUPmLs7Btp1XQs0GDAmLU5RjYd5246OAwBRoUGi44hZuvW45PrH/3kY6X/9HKdqmjC2fzw6hwSKbtc5JBCDexgxfU0BZqx1/IJEsW64RESkHSYqfkKqu6NYh1nr9/9Yb6t2HDXxOOtCUwvuWrkbANDU0iq6TVNLq6KCYu9tf0hE5JvYmdbPSHV33FViQmHlBVzfK9pSoOpoW7lxNhWexuZDPziMw1wEu/FAJRb+S/6dPEpkZaRgTX5Zh8ex7oZLRESux8605JBUd8fRaXEYnRanaFu5cQorpYtgCysvYHRaHM7WX1YYubz8k6558si6Gy4REWmLiYqfUdNt1tlxAOWFrXLbqREWLF6fohaLaYmI9IOJip8Q6+6qpNusfZdWqXGstx3bPx7R4cG40NTSLpbo8GDLzI3UdmodOlXX4TFGJEdzNoWISEdYTOsnpDqxqunSqmZbseLa6PBg5GbfKLudfTGvpxSfa9DkuEREJI4zKn5ArhOrGLEurWo7uibFhOPQU7e2K9K152i7supGrN9ThrV7Kpz96KrVXWrBrhKTaJxEROR5TFT8QEc601oXlirp6Cp228S+SNcRsWLeC5c6fktILXOhLxERaY+Jio8rNTXgbN0lp/e3LiyV63Br3lZNUa6UUlMDosM8/yZjc6EvERFpj4mKjxIrerUXaDBYmq7ln6hGq1VLHfM660SjT1wkRvaJwd7SmnZjjewTg+jwYExfU6CoKLejsQM/1rFEhgSh1oWzLlGhQZxNISLSERbT+iglXViVdJu156jrvcGgrtC2o7EHBRiQm52BtPhIVWMTEZF34YyKD3JU9Gq2ZPJg/LKP7Ttt1meNkOw2ax53z8n2sykAHC53VGjrbOzjBsTjtkEJmDIsCaWmBhyokG4sp1b95asspiUi0hHOqPgguaLXBGOoaNKQEhuBm/vHO0woOlqUq4TcMTJ/2RtThiV1OB4pcl11iYjIc5io+CC5otezdZdRVq0scTD7sSjX+Xb3So8pF/s5q3HktnUWi2mJiPRD80Tl+++/xwMPPICYmBiEhYVh8ODBOHjwoNZhebU+cZEYkxaHQAcFJTmbjuDmF3dg+poC1Ml0hK1tuoLpawpwy9I85GwSf3lgoMGAMWlxGJUa43AcpceUi32R1TgxESGS2zrDGBbM2z5ERDqiaaJy4cIFZGRkIDg4GJ9++im+/fZbLF26FNHR/Iu2o8QKZO0pKXRVU5Sr5D3cSo6pJnYl26rRvxuLc4mI9ETTYtrnn38eSUlJWLt2rWVZSkqKw+2bm5vR3Nxs+Xd9fb1b4/NmxvBgS4HsvtJq5Gw62m4buUJXucLW5yYPxg0/FeWWmhpEH1tWe8z2sdeIzuSYxznfdEX2c6pRUH5BceEvERG5n6YzKrm5uRg2bBimTJmC+Ph4pKen4x//+IfD7ZcsWQKj0Wj5SUpK8mC03iklNgIJxjDJbRwVusoVq3azKspVW9iqpLj2x9hDFY2j5HO6MjYiIvIMTROV0tJSrFq1Cmlpafjss8/whz/8AXPnzsW6detEt8/JyUFdXZ3l59SpUx6O2Dsp7Sjbkf3UFraKHbPU1IDtxVU2RbfujEFNbEREpA1Nb/20tbVh2LBhWLx4MQAgPT0dR48exeuvv44ZM2a02z4kJAQhISGeDtPrmQtUlXSfdXa/PnGRGJUa47CfitS+Yp1ozR1t1cbgqHOuUqNSY3jbh4hIRzSdUenevTsGDhxos2zAgAGorKzUKCLfpab7rLP7KSmmFdtXrqOtKzrnKqXkMxARkedoOqOSkZGB4uJim2XHjx9H7969NYrId1kXqEp1n3V2P7liWuvCW/v9xAp27YtuO9o5V6m9pTUspiUi0hFNE5X58+dj1KhRWLx4Me69914UFBRg9erVWL16tZZh+bSUWOfeaCy3n5rCWzX7ldf8nDR0NAalrI9JRETa0jRRGT58ODZv3oycnBz89a9/RUpKCpYtW4bMzEwtwyIFSk0NqDjfhOSYCAiCgLN1lyS3NxeobiyoxN6yGmSkxmLKsCTZe4+OClutj29OKlhMS0TkezR/KeEdd9yBO+64Q+swSCGxwlc5o1Jj0HC5BX3/9P/hatuPRSBbDv2Ax/95WHY/+5kNZwpvlZIrLiYiIs/TvIU+eRclnWrtCQIw6bU9liRFzX5Kji9XeKuUkuJiIiLyLM1nVMh7yHWqdcTZx4XtC1udLbwF4LDDrdk7WSP4jh8iIh1iokKKuapYVQ3rwtaOFN7KdZtVO9tDRESewUSFFCk1NeBs3WWPH9e6sLVK5vhSRbByhbZBAa57AzMRuZ5YAT35ByYqJMmZ4ll7I/vE4ED5edWzFiN/6rtSUdOIu1fm40JTi+h2Sopg5TrnTltTYCnKNYYHq4qTiNxHqoCev6v+gcW0JMmZ4ll7BgOQm52hetbC3GVWKkkBlBfByj0IZF2US0T6IFdAT76PMyrkkFzxrLnbLADsK61GzqajotvtOVmDsJAgnFj8a3x08BTyT1Zb+qjsPG7C9LcKHO638UClZJLy998MwZRh8m/RluucC7QvyiUibSktoCffxkSFHFLTbVauWNVc6DplWJJNYiHX70QuufhBptGcmZpCYHamJdIHNQX05LuYqJCFfbGaXAGqdfGqmm2tyRXINjZflVx/fa9o0eVqO+daY2daIn1w9rpCvoWJCkkWq4l1ehUrXu0TF4mRfWJEZ0BGiryMUK5A1mzrt1UO13UJC27X+6Qjxb/sTEukL466TfN31b+wmJYki9XEOr06Kl41OKiVFVuuJEmRkxYf2W5ZR4p/2ZmWSH/UXIPIN3FGxc/JFaudb7rSrtOr2F8xpaYGh4/+7jlp22E2r7iqw0kKAByouKCoc62YJZMH45c/FQJLfS4i0pYxPFjRNYh8l1OJyqRJk2AQ+TPZYDAgNDQUffv2xf3334/+/ft3OEByL6XFavadXp0dBwCKTteqjlPJuGoKZhOsCoF50SPSP7lrEPkup279GI1GbNu2DYWFhTAYDDAYDDh06BC2bduGq1evYuPGjRg6dCjy8/NdHS+5mNJitVJTA7YXV6GsWvzpHrlxztVdtux7Xc8u6gOViU9JDI72IyIi/XJqRiUhIQH3338/Xn31VQQE/JjrtLW14dFHH0Xnzp3xwQcf4KGHHsLChQuxe/dulwZMriVXrBYdHozpawpku0JKFdMCwKKfXgho3jc6PFj09k/0T2MquTU0vHd0u4Jeqe6z1p+Lf5kREXkHp2ZU1qxZg3nz5lmSFAAICAjAI488gtWrV8NgMGDOnDk4elS8ARjpi1SxmpqukI6KacX2zc2+0ZKUmEWHByM3+0bRdWJKqhraLZPrPssiPCIi7+LUjMrVq1fx3XffoV+/fjbLv/vuO7S2tgIAQkNDRetYSH8cFaup6QopVUwrtu9VQcChp27FrhITCisv4Ppe0TaPGpvXbSo8jc2HfhAdq/ZSC3aVmCz7yXWffSdrRLvHmYmISN+cSlSmTZuGrKws/OlPf8Lw4cMBAAcOHMDixYsxffp0AEBeXh4GDRrkukjJ7eyL1dQUyKopZLXed3RanMPkYXRaHAorL0iOU1h5wbK/XAxqX4pIRETacypRefnll9GtWze88MILOHfuHACgW7dumD9/PhYuXAgAuPXWWzF+/HjXRUoe58rOtFL7mtl3xi01NUBuTi7RGGbZV677rPmYecVVKDpdi+t7RaNHlzC+Op6ISMcMgiB3V19afX09ACAqKsolAak9ttFoRF1dnSbH9wfT1xQ4LLRdnzVCdlt7YvuKdZN1VGwrRsm2I/vE4Ll7Bks2muOr44mIPEPN93eHO9NGRUUxSfBharpCim1rXxQrtq9Ywa6ahnBKtjUY5Lvh8tXxRET649SMyrlz57BgwQJ8+eWXqKqqgv0Q5oJad+OMiueo6Qppv63UvqWmBtyyNM+doau2fcFNvA1ERORGar6/napRmTlzJiorK/Hkk0+ie/fufLrHD6jpCmm/rdS+aotwPYGvjici0g+nEpXdu3dj165duO6661wcDrmbfcGqO8ZUcwy1RbiewK61RET64VSikpSU1O52D+mbWMFqR4tHlRTByh3DUWdcVzIX8B75vlayRoVda4mI9MepYtply5Zh0aJFKC8vd3E45C5qOsx2ZEz7REDJMZQU4UoR63BrzVzAK9fxll1riYj0x6li2ujoaDQ1NeHq1asIDw9HcLDtxf/8+fMuC1AKi2mVkStYdaZ4VG0RrJJjiBXh7iutRs4mx69iMHebVVPAa90Nt2d0OF8dT0TkYW4vpl22bJkzu5FG1HSYddWYzhxDrAi3vEb8bc1m5m6zagp47bvhMkEhItIvpxKVGTNmuDoOciM1HWatSRXFuqITrZLjyR0nKKBjT5y5o7iYiIhcR3GiUl9fb5meMXejdYS3YfTFUcGqo+JRJYW3SotglRSoSh1P7jjT1hQ4VRTsjuJiIiJyPcXFtNHR0aiqqgIAdOnSBdHR0e1+zMtJf9R0mFVaeOtsJ1q1xxM7jlxsctxRXExERK6neEZl27Zt6Nq1KwBg+/btbguI3MMYHoz1WSNkO8yWmhpsZhnMWgUBO0tMKKv+udbE0ZhqutgqPd76rBHYedyE6W8VKIrNFcckIiLtKU5Uxo4da/nfKSkpSEpKateRVhAEnDp1ynXRkcvJdZh1pvBWTSFrR44n12dFaVGwO4qLiYjIPZzqo5KSkgKTqf1fpOfPn0dKSkqHgyLtOFt4K6XU1IDtxVUoq27/BI+a48n9x6o0Nnd8RiIicg+nnvoRBEH0/T4NDQ0IDQ3tcFCkHbWFt1I6UpRrfTyxcaypjc2Vn5GIiNxLVcO3xx57DACwfPly/O53v0N4+M9/mba2tmL//v0IDAxEfn6+6yMVwYZv7lHX1IJHNhzq8BMx09cUOEwG1meNUHw8sXGsORObqz4jERGp57aGb4cO/fhEhCAIOHLkCDp16mRZ16lTJwwdOhQLFixwImTSE6WFt1JcUZQrNY6ZuTOtWq74jERE5H6qEhXz0z6zZs3C8uXLOYvh49QUxdpzRVGuknHMnWmd1ZHPSERE7udUjcratWtdHQf5GKUFq9adYQVBUN2Z1tmOt0RE5B2cSlQA4ODBg/jwww9RWVmJK1eu2KzbtGmTojH+8pe/4Omnn7ZZ1r9/f3z33XfOhkU6IVewGv1T7Ymj2zpynWk72vGWdShERN7BqceTP/jgA4waNQrHjh3D5s2b0dLSgm+++Qbbtm2D0WhUNdagQYNw5swZy8/u3budCYl0SKobrlhnWGtynWld0fGWiIj0z6kZlcWLF+Pll19GdnY2OnfujOXLlyMlJQUPPvggunfvri6AoCAkJCQo2ra5uRnNzc2Wf8u9c4i05ahgVa5AFhDvTOuOjrdERKRvTs2onDx5EhMmTADw49M+jY2NMBgMmD9/PlavXq1qrJKSEiQmJqJPnz7IzMxEZWWlw22XLFkCo9Fo+UlKSnImfPKwlNgI3Nw/3pIYyBXIWiuv+blJnP04UpQU8xIRkf45lahER0fj4sWLAIAePXrg6NGjAIDa2lo0NSn/Errhhhvw9ttv47///S9WrVqFsrIyjB492jK2vZycHNTV1Vl+2K7fc6S6y6od52zdJcXbO9slVq4I92zdZZRVN7rscxERkXs4detnzJgx2Lp1KwYPHowpU6bg0UcfxbZt27B161bccsstise5/fbbLf97yJAhuOGGG9C7d298+OGHyMrKard9SEgIQkJCnAmZnOSqglS57rJiRqXGOH17xlERrlnOpiPtlrHQlohIf5yaUXn11Vfx29/+FgDwxBNP4LHHHsO5c+dwzz334LXXXnM6mC5duqBfv344ceKE02OQa7mqIFWueFaM8p7J4sSKcKWw0JaISH+cSlS6du2KxMTEHwcICMCiRYvw4YcfIjExEenp0k9iSGloaMDJkydVF+SSe5gLUu1nJKwLUjsyjpy9pTUduiVjLubdvuAmLJl8rez2aj8XERG5n6pEpbm5GTk5ORg2bBhGjRqFLVu2APixAVxqaiqWL1+O+fPnKx5vwYIFyMvLQ3l5Ofbs2YNJkyYhMDAQU6dOVfUhyD1cVZCqpnjW2WNISYmNQIIxzKPHJCIi11BVo/LUU0/hjTfewLhx47Bnzx5MmTIFs2bNwr59+7B06VJMmTIFgYGBisc7ffo0pk6dipqaGsTFxeHGG2/Evn37EBen/t0t5Hqu6AqrZBxXHMOVMbjqmERE1HGqEpWPPvoI69evx1133YWjR49iyJAhuHr1Kr7++msYDAbVB//ggw9U70Oe05GusPbjjOwTg72lNe3WjewTAwAO17mq14lccS2g/nMREZH7qbr1c/r0afziF78AAFx77bUICQnB/PnznUpSyDs42xXWnqP/RAwG6XWuJFdc68znIiIi91I1o9La2opOnTr9vHNQECIjI10eFOmHo+6yapSaGrDnZPsZEwAOl5vXubKDrNhnAeD05yIiIvdTlagIgoCZM2daeplcvnwZDz30ECIibC/wSl9KSN4jJdb5L/KOFtO6OoGw/yxMUIiI9EtVojJjxgybfz/wwAMuDYZ8kx6KaYmIyDupSlTWrl3rrjjIi5WaGlBxvsnh7RO5olwAigp25Y7jqniJiEg/nGqhTwSoa6//t7sHYeLKfFxoarEsiwoLwrN3X4uosGA8suGQzTjWha3ubOPPtvlERPpmEISONirXTn19PYxGI+rq6hAVFaV1OH5n+poChzMh67NGqN7WUcGumuO4Kl4iInIfNd/fTrXQJ1LTXl/ptimxEbi5f3y72z3ubOPPtvlERPrGRIWcoqa9fkda8XuqjT/b5hMR6RNrVDTkzUWdchmu9dM6ck/95BWbEBRgQI8uYe3Oh6fa+PPpIiIifWKiogFvLuoUi92a2NM6cu3r395Tjrf3lNssM58PV7bxd8U4RETkWbz1o4G5G4qQf6LaZln+iWo8suGQRhEpJxa7NUdt6OXa19uzPh+uauPvqnGIiMhz+NSPh5WaGnDL0jyH67cvuEm3f93Lxf5O1giMTpN+83VZdSP+/fX3eGlriaJjWp+PjrTxt4+BbfOJiLSj5vubt348TElRp16/POViv9omn/OmxEZATWZsfT460sbfPga9nmMiIrLFRMXDvLmo01WxX9ezi+JjOhrTmwuRiYhIOSYqHubNRZ2uin1s/3hEhwfbdKm152hMby5EJiIi9VhMqwFvLup0Vey52TciWiKxcDSmNxciExGReiym1ZA3F3W6KvZdJSYUVl7A9b2i0TM6XHJMby5EJiKin7GY1kt4c1Gnq2IfnRZn86SQ1JjeXIhMRETOYaJCuiFXIOvNhchEROQcJiqkOaUFst5ciExERM5hMS1pTk2BrDcXIhMRkXqcUSFNlZoaRN8b1CoI2FliQlm1bd2JMTwY67NGeHUhMhERKcdEhTTlbIGsNxciExGRckxUyOXUdI1VUyDrjm607HBLRKRvTFTIZZzpGqukQNYd3WjZ4ZaIyDuwmJZcxtmusXIFsu7oRssOt0RE3oEzKuQSaotirUkVyHZkXHfESkREnsUZFXIJJUWxclJiI3Bz/3ibJMEV49pzx5hEROQeTFTIJdzVNdYd47LDLRGR92CiQi5hLooNNBhslgcaDBiTFuf0rRR3jOuuWImIyPWYqJDLuKtrrDvGZYdbIiLvYBAEq2dCvYya10ST57ira6w7xmWHWyIiz1Pz/c1EhYiIiDxKzfc3b/0QERGRbjFRISIiIt1iokJERES6xUSFiIiIdIuJChEREemWbhKV5557DgaDAfPmzdM6FCIiItIJXSQqBw4cwBtvvIEhQ4ZoHQoRERHpiOaJSkNDAzIzM/GPf/wD0dHRWodDREREOqJ5opKdnY0JEyZg3Lhxsts2Nzejvr7e5oeIiIh8V5CWB//ggw9QWFiIAwcOKNp+yZIlePrpp90cFREREemFZjMqp06dwqOPPor33nsPoaGhivbJyclBXV2d5efUqVNujpLMSk0N2F5chbLqRq8Yl4iIfINm7/rZsmULJk2ahMDAQMuy1tZWGAwGBAQEoLm52WadGL7rx/1qm65g7oYi7CwxWZaNSYvDiqnpMIYH625cIiLSP69418+vfvUrHDlyBEVFRZafYcOGITMzE0VFRbJJCnnG3A1FyD9RbbMs/0Q1HtlwSJfjEhGRb9GsRqVz58649tprbZZFREQgJiam3XLSRqmpwWbGw6xVELCzxISy6kakxEboZlwiIvI9mj/1Q/pVcb5Jcn15jXN1Je4al4iIfI+mT/3Y27Fjh9YhkJXeXcMl1yfHODfr4a5xiYjI93BGhRzqExeJMWlxCDQYbJYHGgwYkxbn9O0Zd41LRES+h4kKSVoxNR0ZfWNtlmX0jcWKqem6HJeIiHyLZo8nuwIfT/acsupGlNc0IjkmwqUzHu4al4iI9EvN97eualRIv1Ji3ZNIuGtcIiLyDUxUSJFSUwMqzjdx5oOIiDyKiQpJYgdZIiLSEotpSRI7yBIRkZaYqJBD5g6yrXb11tYdZImIiNyJiQo5xA6yRESkNSYq5BA7yBIRkdaYqJBD7CBLRERaY6JCkthBloiItMTHk0mSMTwY67NGsIMsERFpgokKKcIOskREpAUmKmTB7rNERKQ3TFSI3WeJiEi3WExL7D5LRES6xUTFz7H7LBER6RkTFT/H7rNERKRnTFT8HLvPEhGRnjFR8XPsPktERHrGRIXYfZaIiHSLjycTu88SEZFuMVEhC3afJSIiveGtHyIiItItJipERESkW0xUiIiISLeYqBAREZFuMVEhIiIi3WKiQkRERLrFRIWIiIh0i4kKERER6RYTFSIiItItJipERESkW0xUiIiISLeYqBAREZFuMVEhIiIi3WKiQkRERLrFRIWIiIh0S9NEZdWqVRgyZAiioqIQFRWFkSNH4tNPP9UyJCIiItIRTROVnj174rnnnsNXX32FgwcP4pZbbsHEiRPxzTffaBkWERER6YRBEARB6yCsde3aFX//+9+RlZUlu219fT2MRiPq6uoQFRXlgeiIiIioo9R8fwd5KCZZra2t+Oijj9DY2IiRI0eKbtPc3Izm5mbLv+vr6z0VHhEREWlA82LaI0eOIDIyEiEhIXjooYewefNmDBw4UHTbJUuWwGg0Wn6SkpI8HC0RERF5kua3fq5cuYLKykrU1dXhn//8J958803k5eWJJitiMypJSUm89UNERORF1Nz60TxRsTdu3DikpqbijTfekN2WNSpERETeR833t+a3fuy1tbXZzJoQERGR/9K0mDYnJwe33347evXqhYsXL+L999/Hjh078Nlnn2kZFhEREemEpolKVVUVpk+fjjNnzsBoNGLIkCH47LPP8D//8z9ahkVEREQ6oWmismbNGi0PT0RERDqnuxoVIiIiIjMmKkRERKRbTFSIiIhIt5ioEBERkW7p5l0//qjU1ICK801IjolASmyE1uFI8qZYiYjIdzBR0UBt0xXM3VCEnSUmy7IxaXFYMTUdxvBgDSNrz5tiJSIi38NbPxqYu6EI+SeqbZbln6jGIxsOaRSRY94UKxER+R4mKh5WamrAzhITWu1esdQqCNhZYkJZdaNGkbXnTbESEZFvYqLiYRXnmyTXl9fo58vfm2IlIiLfxETFw3p3DZdcnxyjn0JVb4qViIh8ExMVD+sTF4kxaXEINBhslgcaDBiTFqerJ2q8KVYiIvJNTFQ0sGJqOjL6xtosy+gbixVT0zWKyDFvipWIiHyPQRDsKiW9SH19PYxGI+rq6hAVFaV1OKqVVTeivKbRK3qTeFOsRESkb2q+v9lHRUMpsd7zpe9NsRIRke/grR8iIiLSLSYqREREpFtMVIiIiEi3mKgQERGRbjFRISIiIt1iokJERES6xUSFiIiIdIuJChEREekWExUiIiLSLSYqREREpFtMVIiIiEi3mKgQERGRbjFRISIiIt1iokJERES6xUSFiIiIdIuJChEREekWExUiIiLSLSYqREREpFtMVIiIiEi3mKgQERGRbjFRISIiIt1iokJERES6xUSFiIiIdIuJChEREekWExUiIiLSLU0TlSVLlmD48OHo3Lkz4uPjcffdd6O4uFjLkIiIiEhHNE1U8vLykJ2djX379mHr1q1oaWnBrbfeisbGRi3DIiIiIp0wCIIgaB2EmclkQnx8PPLy8jBmzBjZ7evr62E0GlFXV4eoqCgPREhEREQdpeb7O8hDMSlSV1cHAOjatavo+ubmZjQ3N1v+XV9f75G4iIiISBu6KaZta2vDvHnzkJGRgWuvvVZ0myVLlsBoNFp+kpKSPBwlEREReZJubv384Q9/wKeffordu3ejZ8+eotuIzagkJSXx1o/GSk0NqDjfhOSYCKTERmgdDhER6ZzX3fqZM2cOPvnkE+zcudNhkgIAISEhCAkJ8WBkJKW26QrmbijCzhKTZdmYtDismJoOY3iwhpEREZGv0PTWjyAImDNnDjZv3oxt27YhJSVFy3BIpbkbipB/otpmWf6Jajyy4ZBGERERka/RdEYlOzsb77//Pj7++GN07twZZ8+eBQAYjUaEhYVpGRrJKDU12MykmLUKAnaWmFBW3cjbQERE1GGazqisWrUKdXV1uOmmm9C9e3fLz8aNG7UMixSoON8kub68hr1wiIio4zSdUdFJHS85oXfXcMn1yTGcTSEioo7TzePJ5F36xEViTFocAg0Gm+WBBgPGpMXxtg8REbkEExVy2oqp6cjoG2uzLKNvLFZMTdcoIiIi8jW6eDyZvJMxPBjrs0agrLoR5TWN7KNCREQux0SFOiwllgkKERG5B2/9EBERkW4xUSEiIiLdYqJCREREusVEhYiIiHSLiQoRERHpFhMVIiIi0i0mKkRERKRbTFSIiIhIt5ioEBERkW4xUSEiIiLd8uoW+oIgAADq6+s1joSIiIiUMn9vm7/HpXh1onLx4kUAQFJSksaREBERkVoXL16E0WiU3MYgKElndKqtrQ3FxcUYOHAgTp06haioKK1D0p36+nokJSXx/DjA8yON50cez5E0nh9p/np+BEHAxYsXkZiYiIAA6SoUr55RCQgIQI8ePQAAUVFRfvV/slo8P9J4fqTx/MjjOZLG8yPNH8+P3EyKGYtpiYiISLeYqBAREZFueX2iEhISgj//+c8ICQnROhRd4vmRxvMjjedHHs+RNJ4faTw/8ry6mJaIiIh8m9fPqBAREZHvYqJCREREusVEhYiIiHSLiQoRERHpltckKt9//z0eeOABxMTEICwsDIMHD8bBgwct6wVBwFNPPYXu3bsjLCwM48aNQ0lJiYYRe05rayuefPJJpKSkICwsDKmpqXjmmWds3qHgb+dn586duPPOO5GYmAiDwYAtW7bYrFdyPs6fP4/MzExERUWhS5cuyMrKQkNDgwc/hftInZ+WlhYsXLgQgwcPRkREBBITEzF9+nT88MMPNmP46/mx99BDD8FgMGDZsmU2y/39/Bw7dgx33XUXjEYjIiIiMHz4cFRWVlrWX758GdnZ2YiJiUFkZCTuuecenDt3zoOfwn3kzk9DQwPmzJmDnj17IiwsDAMHDsTrr79us40vnx+1vCJRuXDhAjIyMhAcHIxPP/0U3377LZYuXYro6GjLNi+88AJeeeUVvP7669i/fz8iIiJw22234fLlyxpG7hnPP/88Vq1ahVdffRXHjh3D888/jxdeeAErVqywbONv56exsRFDhw7FypUrRdcrOR+ZmZn45ptvsHXrVnzyySfYuXMnfv/733vqI7iV1PlpampCYWEhnnzySRQWFmLTpk0oLi7GXXfdZbOdv54fa5s3b8a+ffuQmJjYbp0/n5+TJ0/ixhtvxDXXXIMdO3bg8OHDePLJJxEaGmrZZv78+fj3v/+Njz76CHl5efjhhx8wefJkT30Et5I7P4899hj++9//4t1338WxY8cwb948zJkzB7m5uZZtfPn8qCZ4gYULFwo33nijw/VtbW1CQkKC8Pe//92yrLa2VggJCRE2bNjgiRA1NWHCBGH27Nk2yyZPnixkZmYKgsDzA0DYvHmz5d9Kzse3334rABAOHDhg2ebTTz8VDAaD8P3333ssdk+wPz9iCgoKBABCRUWFIAg8P4IgCKdPnxZ69OghHD16VOjdu7fw8ssvW9b5+/m57777hAceeMDhPrW1tUJwcLDw0UcfWZYdO3ZMACDs3bvXXaFqQuz8DBo0SPjrX/9qs+z6668XnnjiCUEQ/Ov8KOEVMyq5ubkYNmwYpkyZgvj4eKSnp+Mf//iHZX1ZWRnOnj2LcePGWZYZjUbccMMN2Lt3rxYhe9SoUaPw5Zdf4vjx4wCAr7/+Grt378btt98OgOfHnpLzsXfvXnTp0gXDhg2zbDNu3DgEBARg//79Ho9Za3V1dTAYDOjSpQsAnp+2tjZMmzYNjz/+OAYNGtRuvT+fn7a2NvznP/9Bv379cNtttyE+Ph433HCDze2Pr776Ci0tLTa/g9dccw169erlF9ekUaNGITc3F99//z0EQcD27dtx/Phx3HrrrQB4fux5RaJSWlqKVatWIS0tDZ999hn+8Ic/YO7cuVi3bh0A4OzZswCAbt262ezXrVs3yzpftmjRIvz2t7/FNddcg+DgYKSnp2PevHnIzMwEwPNjT8n5OHv2LOLj423WBwUFoWvXrn53zi5fvoyFCxdi6tSplpem+fv5ef755xEUFIS5c+eKrvfn81NVVYWGhgY899xzGD9+PD7//HNMmjQJkydPRl5eHoAfz0+nTp0sia+Zv1yTVqxYgYEDB6Jnz57o1KkTxo8fj5UrV2LMmDEAeH7secXbk9va2jBs2DAsXrwYAJCeno6jR4/i9ddfx4wZMzSOTnsffvgh3nvvPbz//vsYNGgQioqKMG/ePCQmJvL8UIe0tLTg3nvvhSAIWLVqldbh6MJXX32F5cuXo7CwEAaDQetwdKetrQ0AMHHiRMyfPx8AcN1112HPnj14/fXXMXbsWC3D04UVK1Zg3759yM3NRe/evbFz505kZ2cjMTHRZhaFfuQVMyrdu3fHwIEDbZYNGDDAUkGekJAAAO0qos+dO2dZ58sef/xxy6zK4MGDMW3aNMyfPx9LliwBwPNjT8n5SEhIQFVVlc36q1ev4vz5835zzsxJSkVFBbZu3WrzCnp/Pj+7du1CVVUVevXqhaCgIAQFBaGiogL/7//9PyQnJwPw7/MTGxuLoKAg2Wv2lStXUFtba7ONP1yTLl26hD/96U946aWXcOedd2LIkCGYM2cO7rvvPrz44osA/Pv8iPGKRCUjIwPFxcU2y44fP47evXsDAFJSUpCQkIAvv/zSsr6+vh779+/HyJEjPRqrFpqamhAQYPt/ZWBgoOUvG38/P/aUnI+RI0eitrYWX331lWWbbdu2oa2tDTfccIPHY/Y0c5JSUlKCL774AjExMTbr/fn8TJs2DYcPH0ZRUZHlJzExEY8//jg+++wzAP59fjp16oThw4dLXrN/8YtfIDg42OZ3sLi4GJWVlT5/TWppaUFLS4vkNdufz48orat5lSgoKBCCgoKEZ599VigpKRHee+89ITw8XHj33Xct2zz33HNCly5dhI8//lg4fPiwMHHiRCElJUW4dOmShpF7xowZM4QePXoIn3zyiVBWViZs2rRJiI2NFf74xz9atvG383Px4kXh0KFDwqFDhwQAwksvvSQcOnTI8tSKkvMxfvx4IT09Xdi/f7+we/duIS0tTZg6dapWH8mlpM7PlStXhLvuukvo2bOnUFRUJJw5c8by09zcbBnDX8+PGPunfgTBv8/Ppk2bhODgYGH16tVCSUmJsGLFCiEwMFDYtWuXZYyHHnpI6NWrl7Bt2zbh4MGDwsiRI4WRI0dq9ZFcSu78jB07Vhg0aJCwfft2obS0VFi7dq0QGhoqvPbaa5YxfPn8qOUViYogCMK///1v4dprrxVCQkKEa665Rli9erXN+ra2NuHJJ58UunXrJoSEhAi/+tWvhOLiYo2i9az6+nrh0UcfFXr16iWEhoYKffr0EZ544gmbLxV/Oz/bt28XALT7mTFjhiAIys5HTU2NMHXqVCEyMlKIiooSZs2aJVy8eFGDT+N6UuenrKxMdB0AYfv27ZYx/PX8iBFLVPz9/KxZs0bo27evEBoaKgwdOlTYsmWLzRiXLl0SHn74YSE6OloIDw8XJk2aJJw5c8bDn8Q95M7PmTNnhJkzZwqJiYlCaGio0L9/f2Hp0qVCW1ubZQxfPj9qGQTBqn0pERERkY54RY0KERER+ScmKkRERKRbTFSIiIhIt5ioEBERkW4xUSEiIiLdYqJCREREusVEhYiIiHSLiQoRERHpFhMVIpJ00003Yd68eZodf8yYMXj//fed3t9gMGDLli2uC8hNXn/9ddx5551ah0GkO0xUiHRu5syZMBgMMBgMCA4ORkpKCv74xz/i8uXLLj3Ojh07YDAY2r2xddOmTXjmmWdceiylcnNzce7cOfz2t7+1LEtOTobBYMAHH3zQbvtBgwbBYDDg7bfftiw7c+YMbr/9dpfGNXPmTNx9990uHXP27NkoLCzErl27XDoukbdjokLkBcaPH48zZ86gtLQUL7/8Mt544w38+c9/9sixu3btis6dO3vkWPZeeeUVzJo1q92bZpOSkrB27VqbZfv27cPZs2cRERFhszwhIQEhISFuj7WjOnXqhPvvvx+vvPKK1qEQ6QoTFSIvEBISgoSEBCQlJeHuu+/GuHHjsHXrVsv65ORkLFu2zGaf6667Dn/5y18s/zYYDHjzzTcxadIkhIeHIy0tDbm5uQCA8vJy3HzzzQCA6OhoGAwGzJw5E0D7Wz/Jycn429/+hunTpyMyMhK9e/dGbm4uTCYTJk6ciMjISAwZMgQHDx60iWf37t0YPXo0wsLCkJSUhLlz56KxsdHhZzaZTNi2bZvo7ZDMzEzk5eXh1KlTlmVvvfUWMjMzERQUZLOt9a2f8vJyGAwGbNq0CTfffDPCw8MxdOhQ7N2717L9X/7yF1x33XU2YyxbtgzJycmW9evWrcPHH39smenasWMHAODUqVO499570aVLF3Tt2hUTJ05EeXm5ZZwdO3ZgxIgRiIiIQJcuXZCRkYGKigrL+jvvvBO5ubm4dOmSw/NC5G+YqBB5maNHj2LPnj3o1KmT6n2ffvpp3HvvvTh8+DB+/etfIzMzE+fPn0dSUhL+9a9/AQCKi4tx5swZLF++3OE4L7/8MjIyMnDo0CFMmDAB06ZNw/Tp0/HAAw+gsLAQqampmD59OszvPD158iTGjx+Pe+65B4cPH8bGjRuxe/duzJkzx+Exdu/ejfDwcAwYMKDdum7duuG2227DunXrAABNTU3YuHEjZs+ereg8PPHEE1iwYAGKiorQr18/TJ06FVevXlW074IFC3DvvfdaZrnOnDmDUaNGoaWlBbfddhs6d+6MXbt2IT8/H5GRkRg/fjyuXLmCq1ev4u6778bYsWNx+PBh7N27F7///e9hMBgsYw8bNgxXr17F/v37FcVC5A+YqBB5gU8++QSRkZEIDQ3F4MGDUVVVhccff1z1ODNnzsTUqVPRt29fLF68GA0NDSgoKEBgYCC6du0KAIiPj0dCQgKMRqPDcX7961/jwQcfRFpaGp566inU19dj+PDhmDJlCvr164eFCxfi2LFjOHfuHABgyZIlyMzMxLx585CWloZRo0bhlVdewfr16x3W2lRUVKBbt27tbvuYzZ49G2+//TYEQcA///lPpKamtpsJcWTBggWYMGEC+vXrh6effhoVFRU4ceKEon0jIyMRFhZmmeVKSEhAp06dsHHjRrS1teHNN9/E4MGDMWDAAKxduxaVlZXYsWMH6uvrUVdXhzvuuAOpqakYMGAAZsyYgV69elnGDg8Ph9FotJllIfJ3TFSIvMDNN9+MoqIi7N+/HzNmzMCsWbNwzz33qB5nyJAhlv8dERGBqKgoVFVVdWicbt26AQAGDx7cbpl57K+//hpvv/02IiMjLT+33XYb2traUFZWJnqMS5cuITQ01GEMEyZMQENDA3bu3Im33npL8WyKffzdu3e3idVZX3/9NU6cOIHOnTtbPmPXrl1x+fJlnDx5El27dsXMmTNx22234c4778Ty5ctx5syZduOEhYWhqampQ7EQ+ZIg+U2ISGsRERHo27cvgB9rMYYOHYo1a9YgKysLABAQEGC5zWLW0tLSbpzg4GCbfxsMBrS1tamOx3oc860LsWXmsRsaGvDggw9i7ty57caynlGwFhsbiwsXLjiMISgoCNOmTcOf//xn7N+/H5s3b+5Q/OZYlZ5Lew0NDfjFL36B9957r926uLg4AMDatWsxd+5c/Pe//8XGjRvxf//3f9i6dSt++ctfWrY9f/68ZXsiYqJC5HUCAgLwpz/9CY899hjuv/9+hIWFIS4uzuav8/r6eoczFY6Ya15aW1tdGi8AXH/99fj2228tyZYS6enpOHv2LC5cuIDo6GjRbWbPno0XX3wR9913n8Nt1IqLi8PZs2chCIIliSkqKrLZplOnTu3O0/XXX4+NGzciPj4eUVFRDsdPT09Heno6cnJyMHLkSLz//vuWROXkyZO4fPky0tPTXfJZiHwBb/0QeaEpU6YgMDAQK1euBADccssteOedd7Br1y4cOXIEM2bMQGBgoKoxe/fuDYPBgE8++QQmkwkNDQ0ui3fhwoXYs2cP5syZg6KiIpSUlODjjz+WLKZNT09HbGws8vPzHW4zYMAAVFdXt3tUuSNuuukmmEwmvPDCCzh58iRWrlyJTz/91Gab5ORkHD58GMXFxaiurkZLSwsyMzMRGxuLiRMnYteuXSgrK8OOHTswd+5cnD59GmVlZcjJycHevXtRUVGBzz//HCUlJTbFwrt27UKfPn2Qmprqss9D5O2YqBB5oaCgIMyZMwcvvPACGhsbkZOTg7Fjx+KOO+7AhAkTcPfdd6v+suvRoweefvppLFq0CN26dZNMItQaMmQI8vLycPz4cYwePRrp6el46qmnkJiY6HCfwMBAzJo1S/RWirWYmBiEhYW5LNYBAwbgtddew8qVKzF06FAUFBRgwYIFNtv87ne/Q//+/TFs2DDExcUhPz8f4eHh2LlzJ3r16oXJkydjwIAByMrKwuXLlxEVFYXw8HB89913uOeee9CvXz/8/ve/R3Z2Nh588EHLuBs2bMDvfvc7l30WIl9gEOxvxhIR6cTZs2cxaNAgFBYWonfv3lqH41bffPMNbrnlFhw/flzyiSsif8MZFSLSrYSEBKxZswaVlZVah+J2Z86cwfr165mkENnhjAoRERHpFmdUiIiISLeYqBAREZFuMVEhIiIi3WKiQkRERLrFRIWIiIh0i4kKERER6RYTFSIiItItJipERESkW0xUiIiISLf+f/RU4s8Z1Q8PAAAAAElFTkSuQmCC",
      "text/plain": [
       "<Figure size 640x480 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "movies_between = imdb_movies[(imdb_movies['Runtime (Minutes)'] >= 165) | (imdb_movies['Runtime (Minutes)'] <= 100)]\n",
    "movies_between.plot.scatter(x='Runtime (Minutes)', y='Rating')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c1dddd4c",
   "metadata": {},
   "source": [
    "### Question 2: which is the director with highest revenue per minute of runtime?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "337fff5c",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Genre</th>\n",
       "      <th>Director</th>\n",
       "      <th>Year</th>\n",
       "      <th>Runtime (Minutes)</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Votes</th>\n",
       "      <th>Revenue (Millions)</th>\n",
       "      <th>Metascore</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rank</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Guardians of the Galaxy</td>\n",
       "      <td>Action,Adventure,Sci-Fi</td>\n",
       "      <td>James Gunn</td>\n",
       "      <td>2014</td>\n",
       "      <td>121</td>\n",
       "      <td>8.1</td>\n",
       "      <td>757074</td>\n",
       "      <td>333.13</td>\n",
       "      <td>76.0</td>\n",
       "      <td>Chris Pratt, Vin Diesel, Bradley Cooper, Zoe S...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Prometheus</td>\n",
       "      <td>Adventure,Mystery,Sci-Fi</td>\n",
       "      <td>Ridley Scott</td>\n",
       "      <td>2012</td>\n",
       "      <td>124</td>\n",
       "      <td>7.0</td>\n",
       "      <td>485820</td>\n",
       "      <td>126.46</td>\n",
       "      <td>65.0</td>\n",
       "      <td>Noomi Rapace, Logan Marshall-Green, Michael Fa...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Split</td>\n",
       "      <td>Horror,Thriller</td>\n",
       "      <td>M. Night Shyamalan</td>\n",
       "      <td>2016</td>\n",
       "      <td>117</td>\n",
       "      <td>7.3</td>\n",
       "      <td>157606</td>\n",
       "      <td>138.12</td>\n",
       "      <td>62.0</td>\n",
       "      <td>James McAvoy, Anya Taylor-Joy, Haley Lu Richar...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Sing</td>\n",
       "      <td>Animation,Comedy,Family</td>\n",
       "      <td>Christophe Lourdelet</td>\n",
       "      <td>2016</td>\n",
       "      <td>108</td>\n",
       "      <td>7.2</td>\n",
       "      <td>60545</td>\n",
       "      <td>270.32</td>\n",
       "      <td>59.0</td>\n",
       "      <td>Matthew McConaughey,Reese Witherspoon, Seth Ma...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Suicide Squad</td>\n",
       "      <td>Action,Adventure,Fantasy</td>\n",
       "      <td>David Ayer</td>\n",
       "      <td>2016</td>\n",
       "      <td>123</td>\n",
       "      <td>6.2</td>\n",
       "      <td>393727</td>\n",
       "      <td>325.02</td>\n",
       "      <td>40.0</td>\n",
       "      <td>Will Smith, Jared Leto, Margot Robbie, Viola D...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        Title                     Genre              Director  \\\n",
       "Rank                                                                            \n",
       "1     Guardians of the Galaxy   Action,Adventure,Sci-Fi            James Gunn   \n",
       "2                  Prometheus  Adventure,Mystery,Sci-Fi          Ridley Scott   \n",
       "3                       Split           Horror,Thriller    M. Night Shyamalan   \n",
       "4                        Sing   Animation,Comedy,Family  Christophe Lourdelet   \n",
       "5               Suicide Squad  Action,Adventure,Fantasy            David Ayer   \n",
       "\n",
       "      Year  Runtime (Minutes)  Rating   Votes  Revenue (Millions)  Metascore  \\\n",
       "Rank                                                                           \n",
       "1     2014                121     8.1  757074              333.13       76.0   \n",
       "2     2012                124     7.0  485820              126.46       65.0   \n",
       "3     2016                117     7.3  157606              138.12       62.0   \n",
       "4     2016                108     7.2   60545              270.32       59.0   \n",
       "5     2016                123     6.2  393727              325.02       40.0   \n",
       "\n",
       "                                                 Actors  \n",
       "Rank                                                     \n",
       "1     Chris Pratt, Vin Diesel, Bradley Cooper, Zoe S...  \n",
       "2     Noomi Rapace, Logan Marshall-Green, Michael Fa...  \n",
       "3     James McAvoy, Anya Taylor-Joy, Haley Lu Richar...  \n",
       "4     Matthew McConaughey,Reese Witherspoon, Seth Ma...  \n",
       "5     Will Smith, Jared Leto, Margot Robbie, Viola D...  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "imdb_movies.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "bddd6e83",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Director\n",
       "J.J. Abrams          12.841471\n",
       "David Yates          11.950776\n",
       "Francis Lawrence     10.243712\n",
       "Christopher Nolan     9.738683\n",
       "Michael Bay           9.423046\n",
       "                       ...    \n",
       "Ben Young             0.000000\n",
       "Will Slocombe         0.000000\n",
       "William Oldroyd       0.000000\n",
       "Terry George          0.000000\n",
       "Terry Jones           0.000000\n",
       "Name: Revenue by minute, Length: 644, dtype: float64"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Divide revenue by runtime (unfiltered/not cleaned) \n",
    "\n",
    "imdb_movies.loc[imdb_movies['Runtime (Minutes)'] > 0,'Revenue by minute'] = imdb_movies['Revenue (Millions)'] / imdb_movies['Runtime (Minutes)']\n",
    "\n",
    "                                                                        #row   #descending order\n",
    "imdb_movies.groupby(['Director']).sum()['Revenue by minute'].sort_values(ascending = False)\n",
    "#notice how some values are zero. this means that there are some NA values in the Revenue (Millions column)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "c4004256",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Index: 872 entries, 1 to 1000\n",
      "Data columns (total 11 columns):\n",
      " #   Column              Non-Null Count  Dtype  \n",
      "---  ------              --------------  -----  \n",
      " 0   Title               872 non-null    object \n",
      " 1   Genre               872 non-null    object \n",
      " 2   Director            872 non-null    object \n",
      " 3   Year                872 non-null    int64  \n",
      " 4   Runtime (Minutes)   872 non-null    int64  \n",
      " 5   Rating              872 non-null    float64\n",
      " 6   Votes               872 non-null    int64  \n",
      " 7   Revenue (Millions)  872 non-null    float64\n",
      " 8   Metascore           838 non-null    float64\n",
      " 9   Actors              872 non-null    object \n",
      " 10  Revenue by minute   872 non-null    float64\n",
      "dtypes: float64(4), int64(3), object(4)\n",
      "memory usage: 81.8+ KB\n"
     ]
    }
   ],
   "source": [
    "imdb_movies_clean_revenue = imdb_movies[imdb_movies['Revenue (Millions)'].notna()]\n",
    "imdb_movies_clean_revenue.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "1f968579",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\hussainsarfraz\\AppData\\Local\\Temp\\ipykernel_756\\352294999.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  imdb_movies_clean_revenue['revenue_per_min']=imdb_movies_clean_revenue['Revenue (Millions)'] / imdb_movies_clean_revenue['Runtime (Minutes)']\n"
     ]
    }
   ],
   "source": [
    "imdb_movies_clean_revenue['revenue_per_min']=imdb_movies_clean_revenue['Revenue (Millions)'] / imdb_movies_clean_revenue['Runtime (Minutes)']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "79f05529",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Rank\n",
       "1       2.753140\n",
       "2       1.019839\n",
       "3       1.180513\n",
       "4       2.502963\n",
       "5       2.642439\n",
       "          ...   \n",
       "994     0.619897\n",
       "995     0.621818\n",
       "997     0.186596\n",
       "998     0.591939\n",
       "1000    0.225747\n",
       "Name: revenue_per_min, Length: 872, dtype: float64"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "imdb_movies_clean_revenue['revenue_per_min']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "e81dd9e4",
   "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>Rating</th>\n",
       "      <th>revenue_per_min</th>\n",
       "      <th>Runtime (Minutes)</th>\n",
       "      <th>Revenue (Millions)</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Director</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Colin Trevorrow</th>\n",
       "      <td>7.0</td>\n",
       "      <td>5.259516</td>\n",
       "      <td>124.0</td>\n",
       "      <td>652.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>James Cameron</th>\n",
       "      <td>7.8</td>\n",
       "      <td>4.694506</td>\n",
       "      <td>162.0</td>\n",
       "      <td>760.51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Chris Renaud</th>\n",
       "      <td>6.6</td>\n",
       "      <td>4.233448</td>\n",
       "      <td>87.0</td>\n",
       "      <td>368.31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lee Unkrich</th>\n",
       "      <td>8.3</td>\n",
       "      <td>4.028932</td>\n",
       "      <td>103.0</td>\n",
       "      <td>414.98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Chris Buck</th>\n",
       "      <td>7.5</td>\n",
       "      <td>3.928824</td>\n",
       "      <td>102.0</td>\n",
       "      <td>400.74</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>So Yong Kim</th>\n",
       "      <td>6.4</td>\n",
       "      <td>0.000119</td>\n",
       "      <td>84.0</td>\n",
       "      <td>0.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Phillip Guzman</th>\n",
       "      <td>4.7</td>\n",
       "      <td>0.000101</td>\n",
       "      <td>99.0</td>\n",
       "      <td>0.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Patricia Rozema</th>\n",
       "      <td>5.9</td>\n",
       "      <td>0.000099</td>\n",
       "      <td>101.0</td>\n",
       "      <td>0.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Robin Swicord</th>\n",
       "      <td>7.5</td>\n",
       "      <td>0.000094</td>\n",
       "      <td>106.0</td>\n",
       "      <td>0.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Andy Goddard</th>\n",
       "      <td>5.2</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>95.0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>540 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Rating  revenue_per_min  Runtime (Minutes)  \\\n",
       "Director                                                      \n",
       "Colin Trevorrow     7.0         5.259516              124.0   \n",
       "James Cameron       7.8         4.694506              162.0   \n",
       "Chris Renaud        6.6         4.233448               87.0   \n",
       "Lee Unkrich         8.3         4.028932              103.0   \n",
       "Chris Buck          7.5         3.928824              102.0   \n",
       "...                 ...              ...                ...   \n",
       "So Yong Kim         6.4         0.000119               84.0   \n",
       "Phillip Guzman      4.7         0.000101               99.0   \n",
       "Patricia Rozema     5.9         0.000099              101.0   \n",
       "Robin Swicord       7.5         0.000094              106.0   \n",
       "Andy Goddard        5.2         0.000000               95.0   \n",
       "\n",
       "                 Revenue (Millions)  \n",
       "Director                             \n",
       "Colin Trevorrow              652.18  \n",
       "James Cameron                760.51  \n",
       "Chris Renaud                 368.31  \n",
       "Lee Unkrich                  414.98  \n",
       "Chris Buck                   400.74  \n",
       "...                             ...  \n",
       "So Yong Kim                    0.01  \n",
       "Phillip Guzman                 0.01  \n",
       "Patricia Rozema                0.01  \n",
       "Robin Swicord                  0.01  \n",
       "Andy Goddard                   0.00  \n",
       "\n",
       "[540 rows x 4 columns]"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "attr =[ \"Director\", \"Rating\", \"revenue_per_min\", 'Runtime (Minutes)', 'Revenue (Millions)']\n",
    "grouped_by_director = imdb_movies_clean_revenue[attr].groupby('Director')\n",
    "grouped_by_director.mean().sort_values(by=\"revenue_per_min\", ascending=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "aae97230",
   "metadata": {},
   "source": [
    "### Question 3: which is the most common movie genre in our dataset between 2007 and 2014?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "e2653552",
   "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>Title</th>\n",
       "      <th>Genre</th>\n",
       "      <th>Director</th>\n",
       "      <th>Year</th>\n",
       "      <th>Runtime (Minutes)</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Votes</th>\n",
       "      <th>Revenue (Millions)</th>\n",
       "      <th>Metascore</th>\n",
       "      <th>Actors</th>\n",
       "      <th>Revenue by minute</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rank</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Guardians of the Galaxy</td>\n",
       "      <td>Action,Adventure,Sci-Fi</td>\n",
       "      <td>James Gunn</td>\n",
       "      <td>2014</td>\n",
       "      <td>121</td>\n",
       "      <td>8.1</td>\n",
       "      <td>757074</td>\n",
       "      <td>333.13</td>\n",
       "      <td>76.0</td>\n",
       "      <td>Chris Pratt, Vin Diesel, Bradley Cooper, Zoe S...</td>\n",
       "      <td>2.753140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Prometheus</td>\n",
       "      <td>Adventure,Mystery,Sci-Fi</td>\n",
       "      <td>Ridley Scott</td>\n",
       "      <td>2012</td>\n",
       "      <td>124</td>\n",
       "      <td>7.0</td>\n",
       "      <td>485820</td>\n",
       "      <td>126.46</td>\n",
       "      <td>65.0</td>\n",
       "      <td>Noomi Rapace, Logan Marshall-Green, Michael Fa...</td>\n",
       "      <td>1.019839</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Split</td>\n",
       "      <td>Horror,Thriller</td>\n",
       "      <td>M. Night Shyamalan</td>\n",
       "      <td>2016</td>\n",
       "      <td>117</td>\n",
       "      <td>7.3</td>\n",
       "      <td>157606</td>\n",
       "      <td>138.12</td>\n",
       "      <td>62.0</td>\n",
       "      <td>James McAvoy, Anya Taylor-Joy, Haley Lu Richar...</td>\n",
       "      <td>1.180513</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Sing</td>\n",
       "      <td>Animation,Comedy,Family</td>\n",
       "      <td>Christophe Lourdelet</td>\n",
       "      <td>2016</td>\n",
       "      <td>108</td>\n",
       "      <td>7.2</td>\n",
       "      <td>60545</td>\n",
       "      <td>270.32</td>\n",
       "      <td>59.0</td>\n",
       "      <td>Matthew McConaughey,Reese Witherspoon, Seth Ma...</td>\n",
       "      <td>2.502963</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Suicide Squad</td>\n",
       "      <td>Action,Adventure,Fantasy</td>\n",
       "      <td>David Ayer</td>\n",
       "      <td>2016</td>\n",
       "      <td>123</td>\n",
       "      <td>6.2</td>\n",
       "      <td>393727</td>\n",
       "      <td>325.02</td>\n",
       "      <td>40.0</td>\n",
       "      <td>Will Smith, Jared Leto, Margot Robbie, Viola D...</td>\n",
       "      <td>2.642439</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        Title                     Genre              Director  \\\n",
       "Rank                                                                            \n",
       "1     Guardians of the Galaxy   Action,Adventure,Sci-Fi            James Gunn   \n",
       "2                  Prometheus  Adventure,Mystery,Sci-Fi          Ridley Scott   \n",
       "3                       Split           Horror,Thriller    M. Night Shyamalan   \n",
       "4                        Sing   Animation,Comedy,Family  Christophe Lourdelet   \n",
       "5               Suicide Squad  Action,Adventure,Fantasy            David Ayer   \n",
       "\n",
       "      Year  Runtime (Minutes)  Rating   Votes  Revenue (Millions)  Metascore  \\\n",
       "Rank                                                                           \n",
       "1     2014                121     8.1  757074              333.13       76.0   \n",
       "2     2012                124     7.0  485820              126.46       65.0   \n",
       "3     2016                117     7.3  157606              138.12       62.0   \n",
       "4     2016                108     7.2   60545              270.32       59.0   \n",
       "5     2016                123     6.2  393727              325.02       40.0   \n",
       "\n",
       "                                                 Actors  Revenue by minute  \n",
       "Rank                                                                        \n",
       "1     Chris Pratt, Vin Diesel, Bradley Cooper, Zoe S...           2.753140  \n",
       "2     Noomi Rapace, Logan Marshall-Green, Michael Fa...           1.019839  \n",
       "3     James McAvoy, Anya Taylor-Joy, Haley Lu Richar...           1.180513  \n",
       "4     Matthew McConaughey,Reese Witherspoon, Seth Ma...           2.502963  \n",
       "5     Will Smith, Jared Leto, Margot Robbie, Viola D...           2.642439  "
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "imdb_movies.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "id": "4dcbde79",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2007                   Thriller\n",
      "2008            Sci-Fi,Thriller\n",
      "2009    Horror,Mystery,Thriller\n",
      "2010           Mystery,Thriller\n",
      "2011    Romance,Sci-Fi,Thriller\n",
      "2012             Horror,Mystery\n",
      "2013           Mystery,Thriller\n",
      "2014                   Thriller\n",
      "Name: Genre, dtype: object\n",
      "\n",
      "Most common genre between 2007 and 2014 is: Thriller\n"
     ]
    }
   ],
   "source": [
    "# filter by year >= 2007 and year <=2014\n",
    "\n",
    "YEARS = np.arange(2007, 2015)\n",
    "\n",
    "print(imdb_movies.groupby(['Year']).max()['Genre'].filter(YEARS)) #the max function calculated the most occured genre\n",
    "\n",
    "print()\n",
    "print(\"Most common genre between 2007 and 2014 is:\", imdb_movies.groupby(['Year']).max()['Genre'].filter(YEARS).max() )"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0d4f8a69",
   "metadata": {},
   "source": [
    "### Question 4: which is the actor who has appeared in more movies between 2009 and 2015?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "id": "0558e60d",
   "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>Title</th>\n",
       "      <th>Genre</th>\n",
       "      <th>Director</th>\n",
       "      <th>Year</th>\n",
       "      <th>Runtime (Minutes)</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Votes</th>\n",
       "      <th>Revenue (Millions)</th>\n",
       "      <th>Metascore</th>\n",
       "      <th>Actors</th>\n",
       "      <th>Revenue by minute</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rank</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Guardians of the Galaxy</td>\n",
       "      <td>Action,Adventure,Sci-Fi</td>\n",
       "      <td>James Gunn</td>\n",
       "      <td>2014</td>\n",
       "      <td>121</td>\n",
       "      <td>8.1</td>\n",
       "      <td>757074</td>\n",
       "      <td>333.13</td>\n",
       "      <td>76.0</td>\n",
       "      <td>Chris Pratt, Vin Diesel, Bradley Cooper, Zoe S...</td>\n",
       "      <td>2.753140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Prometheus</td>\n",
       "      <td>Adventure,Mystery,Sci-Fi</td>\n",
       "      <td>Ridley Scott</td>\n",
       "      <td>2012</td>\n",
       "      <td>124</td>\n",
       "      <td>7.0</td>\n",
       "      <td>485820</td>\n",
       "      <td>126.46</td>\n",
       "      <td>65.0</td>\n",
       "      <td>Noomi Rapace, Logan Marshall-Green, Michael Fa...</td>\n",
       "      <td>1.019839</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Split</td>\n",
       "      <td>Horror,Thriller</td>\n",
       "      <td>M. Night Shyamalan</td>\n",
       "      <td>2016</td>\n",
       "      <td>117</td>\n",
       "      <td>7.3</td>\n",
       "      <td>157606</td>\n",
       "      <td>138.12</td>\n",
       "      <td>62.0</td>\n",
       "      <td>James McAvoy, Anya Taylor-Joy, Haley Lu Richar...</td>\n",
       "      <td>1.180513</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Sing</td>\n",
       "      <td>Animation,Comedy,Family</td>\n",
       "      <td>Christophe Lourdelet</td>\n",
       "      <td>2016</td>\n",
       "      <td>108</td>\n",
       "      <td>7.2</td>\n",
       "      <td>60545</td>\n",
       "      <td>270.32</td>\n",
       "      <td>59.0</td>\n",
       "      <td>Matthew McConaughey,Reese Witherspoon, Seth Ma...</td>\n",
       "      <td>2.502963</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Suicide Squad</td>\n",
       "      <td>Action,Adventure,Fantasy</td>\n",
       "      <td>David Ayer</td>\n",
       "      <td>2016</td>\n",
       "      <td>123</td>\n",
       "      <td>6.2</td>\n",
       "      <td>393727</td>\n",
       "      <td>325.02</td>\n",
       "      <td>40.0</td>\n",
       "      <td>Will Smith, Jared Leto, Margot Robbie, Viola D...</td>\n",
       "      <td>2.642439</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        Title                     Genre              Director  \\\n",
       "Rank                                                                            \n",
       "1     Guardians of the Galaxy   Action,Adventure,Sci-Fi            James Gunn   \n",
       "2                  Prometheus  Adventure,Mystery,Sci-Fi          Ridley Scott   \n",
       "3                       Split           Horror,Thriller    M. Night Shyamalan   \n",
       "4                        Sing   Animation,Comedy,Family  Christophe Lourdelet   \n",
       "5               Suicide Squad  Action,Adventure,Fantasy            David Ayer   \n",
       "\n",
       "      Year  Runtime (Minutes)  Rating   Votes  Revenue (Millions)  Metascore  \\\n",
       "Rank                                                                           \n",
       "1     2014                121     8.1  757074              333.13       76.0   \n",
       "2     2012                124     7.0  485820              126.46       65.0   \n",
       "3     2016                117     7.3  157606              138.12       62.0   \n",
       "4     2016                108     7.2   60545              270.32       59.0   \n",
       "5     2016                123     6.2  393727              325.02       40.0   \n",
       "\n",
       "                                                 Actors  Revenue by minute  \n",
       "Rank                                                                        \n",
       "1     Chris Pratt, Vin Diesel, Bradley Cooper, Zoe S...           2.753140  \n",
       "2     Noomi Rapace, Logan Marshall-Green, Michael Fa...           1.019839  \n",
       "3     James McAvoy, Anya Taylor-Joy, Haley Lu Richar...           1.180513  \n",
       "4     Matthew McConaughey,Reese Witherspoon, Seth Ma...           2.502963  \n",
       "5     Will Smith, Jared Leto, Margot Robbie, Viola D...           2.642439  "
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "imdb_movies.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "id": "730a2454",
   "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>Actor1</th>\n",
       "      <th>Actor2</th>\n",
       "      <th>Actor3</th>\n",
       "      <th>Actor4</th>\n",
       "      <th>Year</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rank</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Chris Pratt</td>\n",
       "      <td>Vin Diesel</td>\n",
       "      <td>Bradley Cooper</td>\n",
       "      <td>Zoe Saldana</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Noomi Rapace</td>\n",
       "      <td>Logan Marshall-Green</td>\n",
       "      <td>Michael Fassbender</td>\n",
       "      <td>Charlize Theron</td>\n",
       "      <td>2012</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Prabhas</td>\n",
       "      <td>Rana Daggubati</td>\n",
       "      <td>Anushka Shetty</td>\n",
       "      <td>Tamannaah Bhatia</td>\n",
       "      <td>2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Matthew McConaughey</td>\n",
       "      <td>Anne Hathaway</td>\n",
       "      <td>Jessica Chastain</td>\n",
       "      <td>Mackenzie Foy</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>Johnny Depp</td>\n",
       "      <td>Penélope Cruz</td>\n",
       "      <td>Ian McShane</td>\n",
       "      <td>Geoffrey Rush</td>\n",
       "      <td>2011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>993</th>\n",
       "      <td>Topher Grace</td>\n",
       "      <td>Anna Faris</td>\n",
       "      <td>Dan Fogler</td>\n",
       "      <td>Teresa Palmer</td>\n",
       "      <td>2011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>994</th>\n",
       "      <td>Milla Jovovich</td>\n",
       "      <td>Ali Larter</td>\n",
       "      <td>Wentworth Miller</td>\n",
       "      <td>Kim Coates</td>\n",
       "      <td>2010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>995</th>\n",
       "      <td>Thomas Mann</td>\n",
       "      <td>Oliver Cooper</td>\n",
       "      <td>Jonathan Daniel Brown</td>\n",
       "      <td>Dax Flame</td>\n",
       "      <td>2012</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>Chiwetel Ejiofor</td>\n",
       "      <td>Nicole Kidman</td>\n",
       "      <td>Julia Roberts</td>\n",
       "      <td>Dean Norris</td>\n",
       "      <td>2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999</th>\n",
       "      <td>Adam Pally</td>\n",
       "      <td>T.J. Miller</td>\n",
       "      <td>Thomas Middleditch</td>\n",
       "      <td>Shannon Woodward</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>554 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   Actor1                 Actor2                  Actor3  \\\n",
       "Rank                                                                       \n",
       "1             Chris Pratt             Vin Diesel          Bradley Cooper   \n",
       "2            Noomi Rapace   Logan Marshall-Green      Michael Fassbender   \n",
       "27                Prabhas         Rana Daggubati          Anushka Shetty   \n",
       "37    Matthew McConaughey          Anne Hathaway        Jessica Chastain   \n",
       "46            Johnny Depp          Penélope Cruz             Ian McShane   \n",
       "...                   ...                    ...                     ...   \n",
       "993          Topher Grace             Anna Faris              Dan Fogler   \n",
       "994        Milla Jovovich             Ali Larter        Wentworth Miller   \n",
       "995           Thomas Mann          Oliver Cooper   Jonathan Daniel Brown   \n",
       "996      Chiwetel Ejiofor          Nicole Kidman           Julia Roberts   \n",
       "999            Adam Pally            T.J. Miller      Thomas Middleditch   \n",
       "\n",
       "                Actor4  Year  \n",
       "Rank                          \n",
       "1          Zoe Saldana  2014  \n",
       "2      Charlize Theron  2012  \n",
       "27    Tamannaah Bhatia  2015  \n",
       "37       Mackenzie Foy  2014  \n",
       "46       Geoffrey Rush  2011  \n",
       "...                ...   ...  \n",
       "993      Teresa Palmer  2011  \n",
       "994         Kim Coates  2010  \n",
       "995          Dax Flame  2012  \n",
       "996        Dean Norris  2015  \n",
       "999   Shannon Woodward  2014  \n",
       "\n",
       "[554 rows x 5 columns]"
      ]
     },
     "execution_count": 62,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#split the Actors column into separate columns (one per actor)\n",
    "actors_df = imdb_movies['Actors'].str.split(\",\",expand=True,)\n",
    "\n",
    "#add year column from original df\n",
    "actors_df['Year']= imdb_movies['Year']\n",
    "\n",
    "# rename columns for access\n",
    "actors_df.columns = ['Actor1', 'Actor2', 'Actor3', 'Actor4', 'Year']\n",
    "\n",
    "#drop rows if year < 2009 or year > 2015\n",
    "actors_df = actors_df.drop(actors_df[(actors_df['Year'] < 2009) | (actors_df['Year'] > 2015)].index)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "id": "f9379684",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Max of 1st Actor col: Zooey Deschanel\n",
      "Max of 2nd Actor col: Billy Connolly\n",
      "Max of 3rd Actor col: Seann William Scott\n",
      "Max of 4th Actor col: Xavier Samuel\n"
     ]
    }
   ],
   "source": [
    "print(\"Max of 1st Actor col:\",actors_df['Actor1'].dropna().max())\n",
    "print(\"Max of 2nd Actor col:\",actors_df['Actor2'].dropna().max())\n",
    "print(\"Max of 3rd Actor col:\",actors_df['Actor3'].dropna().max())\n",
    "print(\"Max of 4th Actor col:\",actors_df['Actor4'].dropna().max())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "id": "e09d435e",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "Now merging the four actor columns into one column...\n",
      "\n",
      "Length of the merged actor cols:  2216\n",
      "Most popular actor between years 2009-2015 is:  Zooey Deschanel\n"
     ]
    }
   ],
   "source": [
    "# Merge the four actor columns into a list, then find the most frequent\n",
    "\n",
    "print()\n",
    "print(\"Now merging the four actor columns into one column...\")\n",
    "merged_list = pd.concat( [ actors_df['Actor1'], actors_df['Actor2'], actors_df['Actor3'], actors_df['Actor4']])\n",
    "print()\n",
    "print(\"Length of the merged actor cols: \",len(merged_list))\n",
    "print(\"Most popular actor between years 2009-2015 is: \",merged_list.dropna().max())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "id": "c42e8c0b",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Rank\n",
       "1              Chris Pratt\n",
       "2             Noomi Rapace\n",
       "27                 Prabhas\n",
       "37     Matthew McConaughey\n",
       "46             Johnny Depp\n",
       "              ...         \n",
       "993          Teresa Palmer\n",
       "994             Kim Coates\n",
       "995              Dax Flame\n",
       "996            Dean Norris\n",
       "999       Shannon Woodward\n",
       "Length: 2216, dtype: object"
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged_list #stacks all of the columns on top of each other"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}