Day36 - GroupBy object in Pandas(part2).ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# **GroupBy Attributes and Methods in Pandas**\n",
    "\n",
    "* len - find total number of groups\n",
    "* size - find items in each group\n",
    "* nth item - first()/nth/last items\n",
    "* get_group - vs filtering\n",
    "* groups\n",
    "* describe\n",
    "* sample\n",
    "* nunique\n",
    "* agg method\n",
    "* apply -> builtin function"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "\n",
    "movies = pd.read_csv('Data\\Day35\\imdb-top-1000.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "genres = movies.groupby('Genre')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 1. len"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "14"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(movies.groupby('Genre'))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 2. nunique"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "14"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies['Genre'].nunique()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 3. size"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Genre\n",
       "Action       172\n",
       "Adventure     72\n",
       "Animation     82\n",
       "Biography     88\n",
       "Comedy       155\n",
       "Crime        107\n",
       "Drama        289\n",
       "Family         2\n",
       "Fantasy        2\n",
       "Film-Noir      3\n",
       "Horror        11\n",
       "Mystery       12\n",
       "Thriller       1\n",
       "Western        4\n",
       "dtype: int64"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies.groupby('Genre').size()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 4. nth"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>Series_Title</th>\n",
       "      <th>Released_Year</th>\n",
       "      <th>Runtime</th>\n",
       "      <th>Genre</th>\n",
       "      <th>IMDB_Rating</th>\n",
       "      <th>Director</th>\n",
       "      <th>Star1</th>\n",
       "      <th>No_of_Votes</th>\n",
       "      <th>Gross</th>\n",
       "      <th>Metascore</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Star Wars: Episode V - The Empire Strikes Back</td>\n",
       "      <td>1980</td>\n",
       "      <td>124</td>\n",
       "      <td>Action</td>\n",
       "      <td>8.7</td>\n",
       "      <td>Irvin Kershner</td>\n",
       "      <td>Mark Hamill</td>\n",
       "      <td>1159315</td>\n",
       "      <td>290475067.0</td>\n",
       "      <td>82.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Se7en</td>\n",
       "      <td>1995</td>\n",
       "      <td>127</td>\n",
       "      <td>Crime</td>\n",
       "      <td>8.6</td>\n",
       "      <td>David Fincher</td>\n",
       "      <td>Morgan Freeman</td>\n",
       "      <td>1445096</td>\n",
       "      <td>100125643.0</td>\n",
       "      <td>65.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>It's a Wonderful Life</td>\n",
       "      <td>1946</td>\n",
       "      <td>130</td>\n",
       "      <td>Drama</td>\n",
       "      <td>8.6</td>\n",
       "      <td>Frank Capra</td>\n",
       "      <td>James Stewart</td>\n",
       "      <td>405801</td>\n",
       "      <td>82385199.0</td>\n",
       "      <td>89.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>WALL·E</td>\n",
       "      <td>2008</td>\n",
       "      <td>98</td>\n",
       "      <td>Animation</td>\n",
       "      <td>8.4</td>\n",
       "      <td>Andrew Stanton</td>\n",
       "      <td>Ben Burtt</td>\n",
       "      <td>999790</td>\n",
       "      <td>223808164.0</td>\n",
       "      <td>95.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>The Great Dictator</td>\n",
       "      <td>1940</td>\n",
       "      <td>125</td>\n",
       "      <td>Comedy</td>\n",
       "      <td>8.4</td>\n",
       "      <td>Charles Chaplin</td>\n",
       "      <td>Charles Chaplin</td>\n",
       "      <td>203150</td>\n",
       "      <td>288475.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>Braveheart</td>\n",
       "      <td>1995</td>\n",
       "      <td>178</td>\n",
       "      <td>Biography</td>\n",
       "      <td>8.3</td>\n",
       "      <td>Mel Gibson</td>\n",
       "      <td>Mel Gibson</td>\n",
       "      <td>959181</td>\n",
       "      <td>75600000.0</td>\n",
       "      <td>68.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>North by Northwest</td>\n",
       "      <td>1959</td>\n",
       "      <td>136</td>\n",
       "      <td>Adventure</td>\n",
       "      <td>8.3</td>\n",
       "      <td>Alfred Hitchcock</td>\n",
       "      <td>Cary Grant</td>\n",
       "      <td>299198</td>\n",
       "      <td>13275000.0</td>\n",
       "      <td>98.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>420</th>\n",
       "      <td>Sleuth</td>\n",
       "      <td>1972</td>\n",
       "      <td>138</td>\n",
       "      <td>Mystery</td>\n",
       "      <td>8.0</td>\n",
       "      <td>Joseph L. Mankiewicz</td>\n",
       "      <td>Laurence Olivier</td>\n",
       "      <td>44748</td>\n",
       "      <td>4081254.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>724</th>\n",
       "      <td>Get Out</td>\n",
       "      <td>2017</td>\n",
       "      <td>104</td>\n",
       "      <td>Horror</td>\n",
       "      <td>7.7</td>\n",
       "      <td>Jordan Peele</td>\n",
       "      <td>Daniel Kaluuya</td>\n",
       "      <td>492851</td>\n",
       "      <td>176040665.0</td>\n",
       "      <td>85.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       Series_Title Released_Year  Runtime  \\\n",
       "16   Star Wars: Episode V - The Empire Strikes Back          1980      124   \n",
       "27                                            Se7en          1995      127   \n",
       "32                            It's a Wonderful Life          1946      130   \n",
       "66                                           WALL·E          2008       98   \n",
       "83                               The Great Dictator          1940      125   \n",
       "102                                      Braveheart          1995      178   \n",
       "118                              North by Northwest          1959      136   \n",
       "420                                          Sleuth          1972      138   \n",
       "724                                         Get Out          2017      104   \n",
       "\n",
       "         Genre  IMDB_Rating              Director             Star1  \\\n",
       "16      Action          8.7        Irvin Kershner       Mark Hamill   \n",
       "27       Crime          8.6         David Fincher    Morgan Freeman   \n",
       "32       Drama          8.6           Frank Capra     James Stewart   \n",
       "66   Animation          8.4        Andrew Stanton         Ben Burtt   \n",
       "83      Comedy          8.4       Charles Chaplin   Charles Chaplin   \n",
       "102  Biography          8.3            Mel Gibson        Mel Gibson   \n",
       "118  Adventure          8.3      Alfred Hitchcock        Cary Grant   \n",
       "420    Mystery          8.0  Joseph L. Mankiewicz  Laurence Olivier   \n",
       "724     Horror          7.7          Jordan Peele    Daniel Kaluuya   \n",
       "\n",
       "     No_of_Votes        Gross  Metascore  \n",
       "16       1159315  290475067.0       82.0  \n",
       "27       1445096  100125643.0       65.0  \n",
       "32        405801   82385199.0       89.0  \n",
       "66        999790  223808164.0       95.0  \n",
       "83        203150     288475.0        NaN  \n",
       "102       959181   75600000.0       68.0  \n",
       "118       299198   13275000.0       98.0  \n",
       "420        44748    4081254.0        NaN  \n",
       "724       492851  176040665.0       85.0  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "genres = movies.groupby('Genre')\n",
    "# genres.first()\n",
    "# genres.last()\n",
    "genres.nth(6)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 5. get_group"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>Series_Title</th>\n",
       "      <th>Released_Year</th>\n",
       "      <th>Runtime</th>\n",
       "      <th>Genre</th>\n",
       "      <th>IMDB_Rating</th>\n",
       "      <th>Director</th>\n",
       "      <th>Star1</th>\n",
       "      <th>No_of_Votes</th>\n",
       "      <th>Gross</th>\n",
       "      <th>Metascore</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>321</th>\n",
       "      <td>Das Cabinet des Dr. Caligari</td>\n",
       "      <td>1920</td>\n",
       "      <td>76</td>\n",
       "      <td>Fantasy</td>\n",
       "      <td>8.1</td>\n",
       "      <td>Robert Wiene</td>\n",
       "      <td>Werner Krauss</td>\n",
       "      <td>57428</td>\n",
       "      <td>337574718.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>568</th>\n",
       "      <td>Nosferatu</td>\n",
       "      <td>1922</td>\n",
       "      <td>94</td>\n",
       "      <td>Fantasy</td>\n",
       "      <td>7.9</td>\n",
       "      <td>F.W. Murnau</td>\n",
       "      <td>Max Schreck</td>\n",
       "      <td>88794</td>\n",
       "      <td>445151978.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     Series_Title Released_Year  Runtime    Genre  \\\n",
       "321  Das Cabinet des Dr. Caligari          1920       76  Fantasy   \n",
       "568                     Nosferatu          1922       94  Fantasy   \n",
       "\n",
       "     IMDB_Rating      Director          Star1  No_of_Votes        Gross  \\\n",
       "321          8.1  Robert Wiene  Werner Krauss        57428  337574718.0   \n",
       "568          7.9   F.W. Murnau    Max Schreck        88794  445151978.0   \n",
       "\n",
       "     Metascore  \n",
       "321        NaN  \n",
       "568        NaN  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "genres.get_group('Fantasy')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Series_Title</th>\n",
       "      <th>Released_Year</th>\n",
       "      <th>Runtime</th>\n",
       "      <th>Genre</th>\n",
       "      <th>IMDB_Rating</th>\n",
       "      <th>Director</th>\n",
       "      <th>Star1</th>\n",
       "      <th>No_of_Votes</th>\n",
       "      <th>Gross</th>\n",
       "      <th>Metascore</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>321</th>\n",
       "      <td>Das Cabinet des Dr. Caligari</td>\n",
       "      <td>1920</td>\n",
       "      <td>76</td>\n",
       "      <td>Fantasy</td>\n",
       "      <td>8.1</td>\n",
       "      <td>Robert Wiene</td>\n",
       "      <td>Werner Krauss</td>\n",
       "      <td>57428</td>\n",
       "      <td>337574718.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>568</th>\n",
       "      <td>Nosferatu</td>\n",
       "      <td>1922</td>\n",
       "      <td>94</td>\n",
       "      <td>Fantasy</td>\n",
       "      <td>7.9</td>\n",
       "      <td>F.W. Murnau</td>\n",
       "      <td>Max Schreck</td>\n",
       "      <td>88794</td>\n",
       "      <td>445151978.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     Series_Title Released_Year  Runtime    Genre  \\\n",
       "321  Das Cabinet des Dr. Caligari          1920       76  Fantasy   \n",
       "568                     Nosferatu          1922       94  Fantasy   \n",
       "\n",
       "     IMDB_Rating      Director          Star1  No_of_Votes        Gross  \\\n",
       "321          8.1  Robert Wiene  Werner Krauss        57428  337574718.0   \n",
       "568          7.9   F.W. Murnau    Max Schreck        88794  445151978.0   \n",
       "\n",
       "     Metascore  \n",
       "321        NaN  \n",
       "568        NaN  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# with simple but its slow\n",
    "movies[movies['Genre'] == 'Fantasy']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 6. describe "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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 tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th colspan=\"8\" halign=\"left\">Runtime</th>\n",
       "      <th colspan=\"2\" halign=\"left\">IMDB_Rating</th>\n",
       "      <th>...</th>\n",
       "      <th colspan=\"2\" halign=\"left\">Gross</th>\n",
       "      <th colspan=\"8\" halign=\"left\">Metascore</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>count</th>\n",
       "      <th>mean</th>\n",
       "      <th>std</th>\n",
       "      <th>min</th>\n",
       "      <th>25%</th>\n",
       "      <th>50%</th>\n",
       "      <th>75%</th>\n",
       "      <th>max</th>\n",
       "      <th>count</th>\n",
       "      <th>mean</th>\n",
       "      <th>...</th>\n",
       "      <th>75%</th>\n",
       "      <th>max</th>\n",
       "      <th>count</th>\n",
       "      <th>mean</th>\n",
       "      <th>std</th>\n",
       "      <th>min</th>\n",
       "      <th>25%</th>\n",
       "      <th>50%</th>\n",
       "      <th>75%</th>\n",
       "      <th>max</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Genre</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",
       "      <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>Action</th>\n",
       "      <td>172.0</td>\n",
       "      <td>129.046512</td>\n",
       "      <td>28.500706</td>\n",
       "      <td>45.0</td>\n",
       "      <td>110.75</td>\n",
       "      <td>127.5</td>\n",
       "      <td>143.25</td>\n",
       "      <td>321.0</td>\n",
       "      <td>172.0</td>\n",
       "      <td>7.949419</td>\n",
       "      <td>...</td>\n",
       "      <td>2.674437e+08</td>\n",
       "      <td>936662225.0</td>\n",
       "      <td>143.0</td>\n",
       "      <td>73.419580</td>\n",
       "      <td>12.421252</td>\n",
       "      <td>33.0</td>\n",
       "      <td>65.00</td>\n",
       "      <td>74.0</td>\n",
       "      <td>82.00</td>\n",
       "      <td>98.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Adventure</th>\n",
       "      <td>72.0</td>\n",
       "      <td>134.111111</td>\n",
       "      <td>33.317320</td>\n",
       "      <td>88.0</td>\n",
       "      <td>109.00</td>\n",
       "      <td>127.0</td>\n",
       "      <td>149.00</td>\n",
       "      <td>228.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>7.937500</td>\n",
       "      <td>...</td>\n",
       "      <td>1.998070e+08</td>\n",
       "      <td>874211619.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>78.437500</td>\n",
       "      <td>12.345393</td>\n",
       "      <td>41.0</td>\n",
       "      <td>69.75</td>\n",
       "      <td>80.5</td>\n",
       "      <td>87.25</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Animation</th>\n",
       "      <td>82.0</td>\n",
       "      <td>99.585366</td>\n",
       "      <td>14.530471</td>\n",
       "      <td>71.0</td>\n",
       "      <td>90.00</td>\n",
       "      <td>99.5</td>\n",
       "      <td>106.75</td>\n",
       "      <td>137.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>7.930488</td>\n",
       "      <td>...</td>\n",
       "      <td>2.520612e+08</td>\n",
       "      <td>873839108.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>81.093333</td>\n",
       "      <td>8.813646</td>\n",
       "      <td>61.0</td>\n",
       "      <td>75.00</td>\n",
       "      <td>82.0</td>\n",
       "      <td>87.50</td>\n",
       "      <td>96.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Biography</th>\n",
       "      <td>88.0</td>\n",
       "      <td>136.022727</td>\n",
       "      <td>25.514466</td>\n",
       "      <td>93.0</td>\n",
       "      <td>120.00</td>\n",
       "      <td>129.0</td>\n",
       "      <td>146.25</td>\n",
       "      <td>209.0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>7.938636</td>\n",
       "      <td>...</td>\n",
       "      <td>9.829924e+07</td>\n",
       "      <td>753585104.0</td>\n",
       "      <td>79.0</td>\n",
       "      <td>76.240506</td>\n",
       "      <td>11.028187</td>\n",
       "      <td>48.0</td>\n",
       "      <td>70.50</td>\n",
       "      <td>76.0</td>\n",
       "      <td>84.50</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Comedy</th>\n",
       "      <td>155.0</td>\n",
       "      <td>112.129032</td>\n",
       "      <td>22.946213</td>\n",
       "      <td>68.0</td>\n",
       "      <td>96.00</td>\n",
       "      <td>106.0</td>\n",
       "      <td>124.50</td>\n",
       "      <td>188.0</td>\n",
       "      <td>155.0</td>\n",
       "      <td>7.901290</td>\n",
       "      <td>...</td>\n",
       "      <td>8.107809e+07</td>\n",
       "      <td>886752933.0</td>\n",
       "      <td>125.0</td>\n",
       "      <td>78.720000</td>\n",
       "      <td>11.829160</td>\n",
       "      <td>45.0</td>\n",
       "      <td>72.00</td>\n",
       "      <td>79.0</td>\n",
       "      <td>88.00</td>\n",
       "      <td>99.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Crime</th>\n",
       "      <td>107.0</td>\n",
       "      <td>126.392523</td>\n",
       "      <td>27.689231</td>\n",
       "      <td>80.0</td>\n",
       "      <td>106.50</td>\n",
       "      <td>122.0</td>\n",
       "      <td>141.50</td>\n",
       "      <td>229.0</td>\n",
       "      <td>107.0</td>\n",
       "      <td>8.016822</td>\n",
       "      <td>...</td>\n",
       "      <td>7.102163e+07</td>\n",
       "      <td>790482117.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>77.080460</td>\n",
       "      <td>13.099102</td>\n",
       "      <td>47.0</td>\n",
       "      <td>69.50</td>\n",
       "      <td>77.0</td>\n",
       "      <td>87.00</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Drama</th>\n",
       "      <td>289.0</td>\n",
       "      <td>124.737024</td>\n",
       "      <td>27.740490</td>\n",
       "      <td>64.0</td>\n",
       "      <td>105.00</td>\n",
       "      <td>121.0</td>\n",
       "      <td>137.00</td>\n",
       "      <td>242.0</td>\n",
       "      <td>289.0</td>\n",
       "      <td>7.957439</td>\n",
       "      <td>...</td>\n",
       "      <td>1.164461e+08</td>\n",
       "      <td>924558264.0</td>\n",
       "      <td>241.0</td>\n",
       "      <td>79.701245</td>\n",
       "      <td>12.744687</td>\n",
       "      <td>28.0</td>\n",
       "      <td>72.00</td>\n",
       "      <td>82.0</td>\n",
       "      <td>89.00</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Family</th>\n",
       "      <td>2.0</td>\n",
       "      <td>107.500000</td>\n",
       "      <td>10.606602</td>\n",
       "      <td>100.0</td>\n",
       "      <td>103.75</td>\n",
       "      <td>107.5</td>\n",
       "      <td>111.25</td>\n",
       "      <td>115.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>7.800000</td>\n",
       "      <td>...</td>\n",
       "      <td>3.273329e+08</td>\n",
       "      <td>435110554.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>79.000000</td>\n",
       "      <td>16.970563</td>\n",
       "      <td>67.0</td>\n",
       "      <td>73.00</td>\n",
       "      <td>79.0</td>\n",
       "      <td>85.00</td>\n",
       "      <td>91.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Fantasy</th>\n",
       "      <td>2.0</td>\n",
       "      <td>85.000000</td>\n",
       "      <td>12.727922</td>\n",
       "      <td>76.0</td>\n",
       "      <td>80.50</td>\n",
       "      <td>85.0</td>\n",
       "      <td>89.50</td>\n",
       "      <td>94.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>4.182577e+08</td>\n",
       "      <td>445151978.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Film-Noir</th>\n",
       "      <td>3.0</td>\n",
       "      <td>104.000000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>100.0</td>\n",
       "      <td>102.00</td>\n",
       "      <td>104.0</td>\n",
       "      <td>106.00</td>\n",
       "      <td>108.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>7.966667</td>\n",
       "      <td>...</td>\n",
       "      <td>6.273068e+07</td>\n",
       "      <td>123353292.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>95.666667</td>\n",
       "      <td>1.527525</td>\n",
       "      <td>94.0</td>\n",
       "      <td>95.00</td>\n",
       "      <td>96.0</td>\n",
       "      <td>96.50</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Horror</th>\n",
       "      <td>11.0</td>\n",
       "      <td>102.090909</td>\n",
       "      <td>13.604812</td>\n",
       "      <td>71.0</td>\n",
       "      <td>98.00</td>\n",
       "      <td>103.0</td>\n",
       "      <td>109.00</td>\n",
       "      <td>122.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>7.909091</td>\n",
       "      <td>...</td>\n",
       "      <td>1.362817e+08</td>\n",
       "      <td>298791505.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>15.362291</td>\n",
       "      <td>46.0</td>\n",
       "      <td>77.50</td>\n",
       "      <td>87.0</td>\n",
       "      <td>88.50</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mystery</th>\n",
       "      <td>12.0</td>\n",
       "      <td>119.083333</td>\n",
       "      <td>14.475423</td>\n",
       "      <td>96.0</td>\n",
       "      <td>110.75</td>\n",
       "      <td>117.5</td>\n",
       "      <td>130.25</td>\n",
       "      <td>138.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>7.975000</td>\n",
       "      <td>...</td>\n",
       "      <td>1.310949e+08</td>\n",
       "      <td>474203697.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>79.125000</td>\n",
       "      <td>18.604435</td>\n",
       "      <td>52.0</td>\n",
       "      <td>65.25</td>\n",
       "      <td>77.0</td>\n",
       "      <td>98.50</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Thriller</th>\n",
       "      <td>1.0</td>\n",
       "      <td>108.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>108.0</td>\n",
       "      <td>108.00</td>\n",
       "      <td>108.0</td>\n",
       "      <td>108.00</td>\n",
       "      <td>108.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>7.800000</td>\n",
       "      <td>...</td>\n",
       "      <td>1.755074e+07</td>\n",
       "      <td>17550741.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>81.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>81.0</td>\n",
       "      <td>81.00</td>\n",
       "      <td>81.0</td>\n",
       "      <td>81.00</td>\n",
       "      <td>81.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Western</th>\n",
       "      <td>4.0</td>\n",
       "      <td>148.250000</td>\n",
       "      <td>17.153717</td>\n",
       "      <td>132.0</td>\n",
       "      <td>134.25</td>\n",
       "      <td>148.0</td>\n",
       "      <td>162.00</td>\n",
       "      <td>165.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8.350000</td>\n",
       "      <td>...</td>\n",
       "      <td>1.920000e+07</td>\n",
       "      <td>31800000.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>78.250000</td>\n",
       "      <td>9.032349</td>\n",
       "      <td>69.0</td>\n",
       "      <td>72.75</td>\n",
       "      <td>77.0</td>\n",
       "      <td>82.50</td>\n",
       "      <td>90.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>14 rows × 40 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          Runtime                                                              \\\n",
       "            count        mean        std    min     25%    50%     75%    max   \n",
       "Genre                                                                           \n",
       "Action      172.0  129.046512  28.500706   45.0  110.75  127.5  143.25  321.0   \n",
       "Adventure    72.0  134.111111  33.317320   88.0  109.00  127.0  149.00  228.0   \n",
       "Animation    82.0   99.585366  14.530471   71.0   90.00   99.5  106.75  137.0   \n",
       "Biography    88.0  136.022727  25.514466   93.0  120.00  129.0  146.25  209.0   \n",
       "Comedy      155.0  112.129032  22.946213   68.0   96.00  106.0  124.50  188.0   \n",
       "Crime       107.0  126.392523  27.689231   80.0  106.50  122.0  141.50  229.0   \n",
       "Drama       289.0  124.737024  27.740490   64.0  105.00  121.0  137.00  242.0   \n",
       "Family        2.0  107.500000  10.606602  100.0  103.75  107.5  111.25  115.0   \n",
       "Fantasy       2.0   85.000000  12.727922   76.0   80.50   85.0   89.50   94.0   \n",
       "Film-Noir     3.0  104.000000   4.000000  100.0  102.00  104.0  106.00  108.0   \n",
       "Horror       11.0  102.090909  13.604812   71.0   98.00  103.0  109.00  122.0   \n",
       "Mystery      12.0  119.083333  14.475423   96.0  110.75  117.5  130.25  138.0   \n",
       "Thriller      1.0  108.000000        NaN  108.0  108.00  108.0  108.00  108.0   \n",
       "Western       4.0  148.250000  17.153717  132.0  134.25  148.0  162.00  165.0   \n",
       "\n",
       "          IMDB_Rating            ...         Gross              Metascore  \\\n",
       "                count      mean  ...           75%          max     count   \n",
       "Genre                            ...                                        \n",
       "Action          172.0  7.949419  ...  2.674437e+08  936662225.0     143.0   \n",
       "Adventure        72.0  7.937500  ...  1.998070e+08  874211619.0      64.0   \n",
       "Animation        82.0  7.930488  ...  2.520612e+08  873839108.0      75.0   \n",
       "Biography        88.0  7.938636  ...  9.829924e+07  753585104.0      79.0   \n",
       "Comedy          155.0  7.901290  ...  8.107809e+07  886752933.0     125.0   \n",
       "Crime           107.0  8.016822  ...  7.102163e+07  790482117.0      87.0   \n",
       "Drama           289.0  7.957439  ...  1.164461e+08  924558264.0     241.0   \n",
       "Family            2.0  7.800000  ...  3.273329e+08  435110554.0       2.0   \n",
       "Fantasy           2.0  8.000000  ...  4.182577e+08  445151978.0       0.0   \n",
       "Film-Noir         3.0  7.966667  ...  6.273068e+07  123353292.0       3.0   \n",
       "Horror           11.0  7.909091  ...  1.362817e+08  298791505.0      11.0   \n",
       "Mystery          12.0  7.975000  ...  1.310949e+08  474203697.0       8.0   \n",
       "Thriller          1.0  7.800000  ...  1.755074e+07   17550741.0       1.0   \n",
       "Western           4.0  8.350000  ...  1.920000e+07   31800000.0       4.0   \n",
       "\n",
       "                                                                  \n",
       "                mean        std   min    25%   50%    75%    max  \n",
       "Genre                                                             \n",
       "Action     73.419580  12.421252  33.0  65.00  74.0  82.00   98.0  \n",
       "Adventure  78.437500  12.345393  41.0  69.75  80.5  87.25  100.0  \n",
       "Animation  81.093333   8.813646  61.0  75.00  82.0  87.50   96.0  \n",
       "Biography  76.240506  11.028187  48.0  70.50  76.0  84.50   97.0  \n",
       "Comedy     78.720000  11.829160  45.0  72.00  79.0  88.00   99.0  \n",
       "Crime      77.080460  13.099102  47.0  69.50  77.0  87.00  100.0  \n",
       "Drama      79.701245  12.744687  28.0  72.00  82.0  89.00  100.0  \n",
       "Family     79.000000  16.970563  67.0  73.00  79.0  85.00   91.0  \n",
       "Fantasy          NaN        NaN   NaN    NaN   NaN    NaN    NaN  \n",
       "Film-Noir  95.666667   1.527525  94.0  95.00  96.0  96.50   97.0  \n",
       "Horror     80.000000  15.362291  46.0  77.50  87.0  88.50   97.0  \n",
       "Mystery    79.125000  18.604435  52.0  65.25  77.0  98.50  100.0  \n",
       "Thriller   81.000000        NaN  81.0  81.00  81.0  81.00   81.0  \n",
       "Western    78.250000   9.032349  69.0  72.75  77.0  82.50   90.0  \n",
       "\n",
       "[14 rows x 40 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "genres.describe()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 7. sample"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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>Series_Title</th>\n",
       "      <th>Released_Year</th>\n",
       "      <th>Runtime</th>\n",
       "      <th>Genre</th>\n",
       "      <th>IMDB_Rating</th>\n",
       "      <th>Director</th>\n",
       "      <th>Star1</th>\n",
       "      <th>No_of_Votes</th>\n",
       "      <th>Gross</th>\n",
       "      <th>Metascore</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>648</th>\n",
       "      <td>The Boondock Saints</td>\n",
       "      <td>1999</td>\n",
       "      <td>108</td>\n",
       "      <td>Action</td>\n",
       "      <td>7.8</td>\n",
       "      <td>Troy Duffy</td>\n",
       "      <td>Willem Dafoe</td>\n",
       "      <td>227143</td>\n",
       "      <td>25812.0</td>\n",
       "      <td>44.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>908</th>\n",
       "      <td>Kick-Ass</td>\n",
       "      <td>2010</td>\n",
       "      <td>117</td>\n",
       "      <td>Action</td>\n",
       "      <td>7.6</td>\n",
       "      <td>Matthew Vaughn</td>\n",
       "      <td>Aaron Taylor-Johnson</td>\n",
       "      <td>524081</td>\n",
       "      <td>48071303.0</td>\n",
       "      <td>66.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>193</th>\n",
       "      <td>The Gold Rush</td>\n",
       "      <td>1925</td>\n",
       "      <td>95</td>\n",
       "      <td>Adventure</td>\n",
       "      <td>8.2</td>\n",
       "      <td>Charles Chaplin</td>\n",
       "      <td>Charles Chaplin</td>\n",
       "      <td>101053</td>\n",
       "      <td>5450000.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>361</th>\n",
       "      <td>Blood Diamond</td>\n",
       "      <td>2006</td>\n",
       "      <td>143</td>\n",
       "      <td>Adventure</td>\n",
       "      <td>8.0</td>\n",
       "      <td>Edward Zwick</td>\n",
       "      <td>Leonardo DiCaprio</td>\n",
       "      <td>499439</td>\n",
       "      <td>57366262.0</td>\n",
       "      <td>64.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>Coco</td>\n",
       "      <td>2017</td>\n",
       "      <td>105</td>\n",
       "      <td>Animation</td>\n",
       "      <td>8.4</td>\n",
       "      <td>Lee Unkrich</td>\n",
       "      <td>Adrian Molina</td>\n",
       "      <td>384171</td>\n",
       "      <td>209726015.0</td>\n",
       "      <td>81.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>758</th>\n",
       "      <td>Papurika</td>\n",
       "      <td>2006</td>\n",
       "      <td>90</td>\n",
       "      <td>Animation</td>\n",
       "      <td>7.7</td>\n",
       "      <td>Satoshi Kon</td>\n",
       "      <td>Megumi Hayashibara</td>\n",
       "      <td>71379</td>\n",
       "      <td>881302.0</td>\n",
       "      <td>81.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>328</th>\n",
       "      <td>Lion</td>\n",
       "      <td>2016</td>\n",
       "      <td>118</td>\n",
       "      <td>Biography</td>\n",
       "      <td>8.0</td>\n",
       "      <td>Garth Davis</td>\n",
       "      <td>Dev Patel</td>\n",
       "      <td>213970</td>\n",
       "      <td>51739495.0</td>\n",
       "      <td>69.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>A Beautiful Mind</td>\n",
       "      <td>2001</td>\n",
       "      <td>135</td>\n",
       "      <td>Biography</td>\n",
       "      <td>8.2</td>\n",
       "      <td>Ron Howard</td>\n",
       "      <td>Russell Crowe</td>\n",
       "      <td>848920</td>\n",
       "      <td>170742341.0</td>\n",
       "      <td>72.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256</th>\n",
       "      <td>Underground</td>\n",
       "      <td>1995</td>\n",
       "      <td>170</td>\n",
       "      <td>Comedy</td>\n",
       "      <td>8.1</td>\n",
       "      <td>Emir Kusturica</td>\n",
       "      <td>Predrag 'Miki' Manojlovic</td>\n",
       "      <td>55220</td>\n",
       "      <td>171082.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>667</th>\n",
       "      <td>Night on Earth</td>\n",
       "      <td>1991</td>\n",
       "      <td>129</td>\n",
       "      <td>Comedy</td>\n",
       "      <td>7.8</td>\n",
       "      <td>Jim Jarmusch</td>\n",
       "      <td>Winona Ryder</td>\n",
       "      <td>55362</td>\n",
       "      <td>2015810.0</td>\n",
       "      <td>68.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>441</th>\n",
       "      <td>The Killing</td>\n",
       "      <td>1956</td>\n",
       "      <td>84</td>\n",
       "      <td>Crime</td>\n",
       "      <td>8.0</td>\n",
       "      <td>Stanley Kubrick</td>\n",
       "      <td>Sterling Hayden</td>\n",
       "      <td>81702</td>\n",
       "      <td>309154156.0</td>\n",
       "      <td>91.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>288</th>\n",
       "      <td>Cool Hand Luke</td>\n",
       "      <td>1967</td>\n",
       "      <td>127</td>\n",
       "      <td>Crime</td>\n",
       "      <td>8.1</td>\n",
       "      <td>Stuart Rosenberg</td>\n",
       "      <td>Paul Newman</td>\n",
       "      <td>161984</td>\n",
       "      <td>16217773.0</td>\n",
       "      <td>92.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>773</th>\n",
       "      <td>Brokeback Mountain</td>\n",
       "      <td>2005</td>\n",
       "      <td>134</td>\n",
       "      <td>Drama</td>\n",
       "      <td>7.7</td>\n",
       "      <td>Ang Lee</td>\n",
       "      <td>Jake Gyllenhaal</td>\n",
       "      <td>323103</td>\n",
       "      <td>83043761.0</td>\n",
       "      <td>87.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>515</th>\n",
       "      <td>Mulholland Dr.</td>\n",
       "      <td>2001</td>\n",
       "      <td>147</td>\n",
       "      <td>Drama</td>\n",
       "      <td>7.9</td>\n",
       "      <td>David Lynch</td>\n",
       "      <td>Naomi Watts</td>\n",
       "      <td>322031</td>\n",
       "      <td>7220243.0</td>\n",
       "      <td>85.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>698</th>\n",
       "      <td>Willy Wonka &amp; the Chocolate Factory</td>\n",
       "      <td>1971</td>\n",
       "      <td>100</td>\n",
       "      <td>Family</td>\n",
       "      <td>7.8</td>\n",
       "      <td>Mel Stuart</td>\n",
       "      <td>Gene Wilder</td>\n",
       "      <td>178731</td>\n",
       "      <td>4000000.0</td>\n",
       "      <td>67.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>688</th>\n",
       "      <td>E.T. the Extra-Terrestrial</td>\n",
       "      <td>1982</td>\n",
       "      <td>115</td>\n",
       "      <td>Family</td>\n",
       "      <td>7.8</td>\n",
       "      <td>Steven Spielberg</td>\n",
       "      <td>Henry Thomas</td>\n",
       "      <td>372490</td>\n",
       "      <td>435110554.0</td>\n",
       "      <td>91.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>568</th>\n",
       "      <td>Nosferatu</td>\n",
       "      <td>1922</td>\n",
       "      <td>94</td>\n",
       "      <td>Fantasy</td>\n",
       "      <td>7.9</td>\n",
       "      <td>F.W. Murnau</td>\n",
       "      <td>Max Schreck</td>\n",
       "      <td>88794</td>\n",
       "      <td>445151978.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>321</th>\n",
       "      <td>Das Cabinet des Dr. Caligari</td>\n",
       "      <td>1920</td>\n",
       "      <td>76</td>\n",
       "      <td>Fantasy</td>\n",
       "      <td>8.1</td>\n",
       "      <td>Robert Wiene</td>\n",
       "      <td>Werner Krauss</td>\n",
       "      <td>57428</td>\n",
       "      <td>337574718.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>456</th>\n",
       "      <td>The Maltese Falcon</td>\n",
       "      <td>1941</td>\n",
       "      <td>100</td>\n",
       "      <td>Film-Noir</td>\n",
       "      <td>8.0</td>\n",
       "      <td>John Huston</td>\n",
       "      <td>Humphrey Bogart</td>\n",
       "      <td>148928</td>\n",
       "      <td>2108060.0</td>\n",
       "      <td>96.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>456</th>\n",
       "      <td>The Maltese Falcon</td>\n",
       "      <td>1941</td>\n",
       "      <td>100</td>\n",
       "      <td>Film-Noir</td>\n",
       "      <td>8.0</td>\n",
       "      <td>John Huston</td>\n",
       "      <td>Humphrey Bogart</td>\n",
       "      <td>148928</td>\n",
       "      <td>2108060.0</td>\n",
       "      <td>96.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>932</th>\n",
       "      <td>Saw</td>\n",
       "      <td>2004</td>\n",
       "      <td>103</td>\n",
       "      <td>Horror</td>\n",
       "      <td>7.6</td>\n",
       "      <td>James Wan</td>\n",
       "      <td>Cary Elwes</td>\n",
       "      <td>379020</td>\n",
       "      <td>56000369.0</td>\n",
       "      <td>46.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>876</th>\n",
       "      <td>The Invisible Man</td>\n",
       "      <td>1933</td>\n",
       "      <td>71</td>\n",
       "      <td>Horror</td>\n",
       "      <td>7.7</td>\n",
       "      <td>James Whale</td>\n",
       "      <td>Claude Rains</td>\n",
       "      <td>30683</td>\n",
       "      <td>298791505.0</td>\n",
       "      <td>87.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>420</th>\n",
       "      <td>Sleuth</td>\n",
       "      <td>1972</td>\n",
       "      <td>138</td>\n",
       "      <td>Mystery</td>\n",
       "      <td>8.0</td>\n",
       "      <td>Joseph L. Mankiewicz</td>\n",
       "      <td>Laurence Olivier</td>\n",
       "      <td>44748</td>\n",
       "      <td>4081254.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>Vertigo</td>\n",
       "      <td>1958</td>\n",
       "      <td>128</td>\n",
       "      <td>Mystery</td>\n",
       "      <td>8.3</td>\n",
       "      <td>Alfred Hitchcock</td>\n",
       "      <td>James Stewart</td>\n",
       "      <td>364368</td>\n",
       "      <td>3200000.0</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>700</th>\n",
       "      <td>Wait Until Dark</td>\n",
       "      <td>1967</td>\n",
       "      <td>108</td>\n",
       "      <td>Thriller</td>\n",
       "      <td>7.8</td>\n",
       "      <td>Terence Young</td>\n",
       "      <td>Audrey Hepburn</td>\n",
       "      <td>27733</td>\n",
       "      <td>17550741.0</td>\n",
       "      <td>81.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>700</th>\n",
       "      <td>Wait Until Dark</td>\n",
       "      <td>1967</td>\n",
       "      <td>108</td>\n",
       "      <td>Thriller</td>\n",
       "      <td>7.8</td>\n",
       "      <td>Terence Young</td>\n",
       "      <td>Audrey Hepburn</td>\n",
       "      <td>27733</td>\n",
       "      <td>17550741.0</td>\n",
       "      <td>81.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Il buono, il brutto, il cattivo</td>\n",
       "      <td>1966</td>\n",
       "      <td>161</td>\n",
       "      <td>Western</td>\n",
       "      <td>8.8</td>\n",
       "      <td>Sergio Leone</td>\n",
       "      <td>Clint Eastwood</td>\n",
       "      <td>688390</td>\n",
       "      <td>6100000.0</td>\n",
       "      <td>90.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>691</th>\n",
       "      <td>The Outlaw Josey Wales</td>\n",
       "      <td>1976</td>\n",
       "      <td>135</td>\n",
       "      <td>Western</td>\n",
       "      <td>7.8</td>\n",
       "      <td>Clint Eastwood</td>\n",
       "      <td>Clint Eastwood</td>\n",
       "      <td>65659</td>\n",
       "      <td>31800000.0</td>\n",
       "      <td>69.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                            Series_Title Released_Year  Runtime      Genre  \\\n",
       "648                  The Boondock Saints          1999      108     Action   \n",
       "908                             Kick-Ass          2010      117     Action   \n",
       "193                        The Gold Rush          1925       95  Adventure   \n",
       "361                        Blood Diamond          2006      143  Adventure   \n",
       "61                                  Coco          2017      105  Animation   \n",
       "758                             Papurika          2006       90  Animation   \n",
       "328                                 Lion          2016      118  Biography   \n",
       "159                     A Beautiful Mind          2001      135  Biography   \n",
       "256                          Underground          1995      170     Comedy   \n",
       "667                       Night on Earth          1991      129     Comedy   \n",
       "441                          The Killing          1956       84      Crime   \n",
       "288                       Cool Hand Luke          1967      127      Crime   \n",
       "773                   Brokeback Mountain          2005      134      Drama   \n",
       "515                       Mulholland Dr.          2001      147      Drama   \n",
       "698  Willy Wonka & the Chocolate Factory          1971      100     Family   \n",
       "688           E.T. the Extra-Terrestrial          1982      115     Family   \n",
       "568                            Nosferatu          1922       94    Fantasy   \n",
       "321         Das Cabinet des Dr. Caligari          1920       76    Fantasy   \n",
       "456                   The Maltese Falcon          1941      100  Film-Noir   \n",
       "456                   The Maltese Falcon          1941      100  Film-Noir   \n",
       "932                                  Saw          2004      103     Horror   \n",
       "876                    The Invisible Man          1933       71     Horror   \n",
       "420                               Sleuth          1972      138    Mystery   \n",
       "119                              Vertigo          1958      128    Mystery   \n",
       "700                      Wait Until Dark          1967      108   Thriller   \n",
       "700                      Wait Until Dark          1967      108   Thriller   \n",
       "12       Il buono, il brutto, il cattivo          1966      161    Western   \n",
       "691               The Outlaw Josey Wales          1976      135    Western   \n",
       "\n",
       "     IMDB_Rating              Director                      Star1  \\\n",
       "648          7.8            Troy Duffy               Willem Dafoe   \n",
       "908          7.6        Matthew Vaughn       Aaron Taylor-Johnson   \n",
       "193          8.2       Charles Chaplin            Charles Chaplin   \n",
       "361          8.0          Edward Zwick          Leonardo DiCaprio   \n",
       "61           8.4           Lee Unkrich              Adrian Molina   \n",
       "758          7.7           Satoshi Kon         Megumi Hayashibara   \n",
       "328          8.0           Garth Davis                  Dev Patel   \n",
       "159          8.2            Ron Howard              Russell Crowe   \n",
       "256          8.1        Emir Kusturica  Predrag 'Miki' Manojlovic   \n",
       "667          7.8          Jim Jarmusch               Winona Ryder   \n",
       "441          8.0       Stanley Kubrick            Sterling Hayden   \n",
       "288          8.1      Stuart Rosenberg                Paul Newman   \n",
       "773          7.7               Ang Lee            Jake Gyllenhaal   \n",
       "515          7.9           David Lynch                Naomi Watts   \n",
       "698          7.8            Mel Stuart                Gene Wilder   \n",
       "688          7.8      Steven Spielberg               Henry Thomas   \n",
       "568          7.9           F.W. Murnau                Max Schreck   \n",
       "321          8.1          Robert Wiene              Werner Krauss   \n",
       "456          8.0           John Huston            Humphrey Bogart   \n",
       "456          8.0           John Huston            Humphrey Bogart   \n",
       "932          7.6             James Wan                 Cary Elwes   \n",
       "876          7.7           James Whale               Claude Rains   \n",
       "420          8.0  Joseph L. Mankiewicz           Laurence Olivier   \n",
       "119          8.3      Alfred Hitchcock              James Stewart   \n",
       "700          7.8         Terence Young             Audrey Hepburn   \n",
       "700          7.8         Terence Young             Audrey Hepburn   \n",
       "12           8.8          Sergio Leone             Clint Eastwood   \n",
       "691          7.8        Clint Eastwood             Clint Eastwood   \n",
       "\n",
       "     No_of_Votes        Gross  Metascore  \n",
       "648       227143      25812.0       44.0  \n",
       "908       524081   48071303.0       66.0  \n",
       "193       101053    5450000.0        NaN  \n",
       "361       499439   57366262.0       64.0  \n",
       "61        384171  209726015.0       81.0  \n",
       "758        71379     881302.0       81.0  \n",
       "328       213970   51739495.0       69.0  \n",
       "159       848920  170742341.0       72.0  \n",
       "256        55220     171082.0        NaN  \n",
       "667        55362    2015810.0       68.0  \n",
       "441        81702  309154156.0       91.0  \n",
       "288       161984   16217773.0       92.0  \n",
       "773       323103   83043761.0       87.0  \n",
       "515       322031    7220243.0       85.0  \n",
       "698       178731    4000000.0       67.0  \n",
       "688       372490  435110554.0       91.0  \n",
       "568        88794  445151978.0        NaN  \n",
       "321        57428  337574718.0        NaN  \n",
       "456       148928    2108060.0       96.0  \n",
       "456       148928    2108060.0       96.0  \n",
       "932       379020   56000369.0       46.0  \n",
       "876        30683  298791505.0       87.0  \n",
       "420        44748    4081254.0        NaN  \n",
       "119       364368    3200000.0      100.0  \n",
       "700        27733   17550741.0       81.0  \n",
       "700        27733   17550741.0       81.0  \n",
       "12        688390    6100000.0       90.0  \n",
       "691        65659   31800000.0       69.0  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "genres.sample(2,replace=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 8. nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Series_Title</th>\n",
       "      <th>Released_Year</th>\n",
       "      <th>Runtime</th>\n",
       "      <th>IMDB_Rating</th>\n",
       "      <th>Director</th>\n",
       "      <th>Star1</th>\n",
       "      <th>No_of_Votes</th>\n",
       "      <th>Gross</th>\n",
       "      <th>Metascore</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Genre</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>Action</th>\n",
       "      <td>172</td>\n",
       "      <td>61</td>\n",
       "      <td>78</td>\n",
       "      <td>15</td>\n",
       "      <td>123</td>\n",
       "      <td>121</td>\n",
       "      <td>172</td>\n",
       "      <td>172</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Adventure</th>\n",
       "      <td>72</td>\n",
       "      <td>49</td>\n",
       "      <td>58</td>\n",
       "      <td>10</td>\n",
       "      <td>59</td>\n",
       "      <td>59</td>\n",
       "      <td>72</td>\n",
       "      <td>72</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Animation</th>\n",
       "      <td>82</td>\n",
       "      <td>35</td>\n",
       "      <td>41</td>\n",
       "      <td>11</td>\n",
       "      <td>51</td>\n",
       "      <td>77</td>\n",
       "      <td>82</td>\n",
       "      <td>82</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Biography</th>\n",
       "      <td>88</td>\n",
       "      <td>44</td>\n",
       "      <td>56</td>\n",
       "      <td>13</td>\n",
       "      <td>76</td>\n",
       "      <td>72</td>\n",
       "      <td>88</td>\n",
       "      <td>88</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Comedy</th>\n",
       "      <td>155</td>\n",
       "      <td>72</td>\n",
       "      <td>70</td>\n",
       "      <td>11</td>\n",
       "      <td>113</td>\n",
       "      <td>133</td>\n",
       "      <td>155</td>\n",
       "      <td>155</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Crime</th>\n",
       "      <td>106</td>\n",
       "      <td>56</td>\n",
       "      <td>65</td>\n",
       "      <td>14</td>\n",
       "      <td>86</td>\n",
       "      <td>85</td>\n",
       "      <td>107</td>\n",
       "      <td>107</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Drama</th>\n",
       "      <td>289</td>\n",
       "      <td>83</td>\n",
       "      <td>95</td>\n",
       "      <td>14</td>\n",
       "      <td>211</td>\n",
       "      <td>250</td>\n",
       "      <td>288</td>\n",
       "      <td>287</td>\n",
       "      <td>52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Family</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Fantasy</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Film-Noir</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Horror</th>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>10</td>\n",
       "      <td>8</td>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mystery</th>\n",
       "      <td>12</td>\n",
       "      <td>11</td>\n",
       "      <td>10</td>\n",
       "      <td>8</td>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Thriller</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Western</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           Series_Title  Released_Year  Runtime  IMDB_Rating  Director  Star1  \\\n",
       "Genre                                                                           \n",
       "Action              172             61       78           15       123    121   \n",
       "Adventure            72             49       58           10        59     59   \n",
       "Animation            82             35       41           11        51     77   \n",
       "Biography            88             44       56           13        76     72   \n",
       "Comedy              155             72       70           11       113    133   \n",
       "Crime               106             56       65           14        86     85   \n",
       "Drama               289             83       95           14       211    250   \n",
       "Family                2              2        2            1         2      2   \n",
       "Fantasy               2              2        2            2         2      2   \n",
       "Film-Noir             3              3        3            3         3      3   \n",
       "Horror               11             11       10            8        10     11   \n",
       "Mystery              12             11       10            8        10     11   \n",
       "Thriller              1              1        1            1         1      1   \n",
       "Western               4              4        4            4         2      2   \n",
       "\n",
       "           No_of_Votes  Gross  Metascore  \n",
       "Genre                                     \n",
       "Action             172    172         50  \n",
       "Adventure           72     72         33  \n",
       "Animation           82     82         29  \n",
       "Biography           88     88         40  \n",
       "Comedy             155    155         44  \n",
       "Crime              107    107         39  \n",
       "Drama              288    287         52  \n",
       "Family               2      2          2  \n",
       "Fantasy              2      2          0  \n",
       "Film-Noir            3      3          3  \n",
       "Horror              11     11          9  \n",
       "Mystery             12     12          7  \n",
       "Thriller             1      1          1  \n",
       "Western              4      4          4  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "genres.nunique()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 9. agg method"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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>Runtime</th>\n",
       "      <th>IMDB_Rating</th>\n",
       "      <th>No_of_Votes</th>\n",
       "      <th>Gross</th>\n",
       "      <th>Metascore</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Genre</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>Action</th>\n",
       "      <td>129.046512</td>\n",
       "      <td>7.949419</td>\n",
       "      <td>72282412</td>\n",
       "      <td>3.263226e+10</td>\n",
       "      <td>33.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Adventure</th>\n",
       "      <td>134.111111</td>\n",
       "      <td>7.937500</td>\n",
       "      <td>22576163</td>\n",
       "      <td>9.496922e+09</td>\n",
       "      <td>41.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Animation</th>\n",
       "      <td>99.585366</td>\n",
       "      <td>7.930488</td>\n",
       "      <td>21978630</td>\n",
       "      <td>1.463147e+10</td>\n",
       "      <td>61.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Biography</th>\n",
       "      <td>136.022727</td>\n",
       "      <td>7.938636</td>\n",
       "      <td>24006844</td>\n",
       "      <td>8.276358e+09</td>\n",
       "      <td>48.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Comedy</th>\n",
       "      <td>112.129032</td>\n",
       "      <td>7.901290</td>\n",
       "      <td>27620327</td>\n",
       "      <td>1.566387e+10</td>\n",
       "      <td>45.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Crime</th>\n",
       "      <td>126.392523</td>\n",
       "      <td>8.016822</td>\n",
       "      <td>33533615</td>\n",
       "      <td>8.452632e+09</td>\n",
       "      <td>47.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Drama</th>\n",
       "      <td>124.737024</td>\n",
       "      <td>7.957439</td>\n",
       "      <td>61367304</td>\n",
       "      <td>3.540997e+10</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Family</th>\n",
       "      <td>107.500000</td>\n",
       "      <td>7.800000</td>\n",
       "      <td>551221</td>\n",
       "      <td>4.391106e+08</td>\n",
       "      <td>67.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Fantasy</th>\n",
       "      <td>85.000000</td>\n",
       "      <td>8.000000</td>\n",
       "      <td>146222</td>\n",
       "      <td>7.827267e+08</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Film-Noir</th>\n",
       "      <td>104.000000</td>\n",
       "      <td>7.966667</td>\n",
       "      <td>367215</td>\n",
       "      <td>1.259105e+08</td>\n",
       "      <td>94.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Horror</th>\n",
       "      <td>102.090909</td>\n",
       "      <td>7.909091</td>\n",
       "      <td>3742556</td>\n",
       "      <td>1.034649e+09</td>\n",
       "      <td>46.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mystery</th>\n",
       "      <td>119.083333</td>\n",
       "      <td>7.975000</td>\n",
       "      <td>4203004</td>\n",
       "      <td>1.256417e+09</td>\n",
       "      <td>52.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Thriller</th>\n",
       "      <td>108.000000</td>\n",
       "      <td>7.800000</td>\n",
       "      <td>27733</td>\n",
       "      <td>1.755074e+07</td>\n",
       "      <td>81.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Western</th>\n",
       "      <td>148.250000</td>\n",
       "      <td>8.350000</td>\n",
       "      <td>1289665</td>\n",
       "      <td>5.822151e+07</td>\n",
       "      <td>69.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              Runtime  IMDB_Rating  No_of_Votes         Gross  Metascore\n",
       "Genre                                                                   \n",
       "Action     129.046512     7.949419     72282412  3.263226e+10       33.0\n",
       "Adventure  134.111111     7.937500     22576163  9.496922e+09       41.0\n",
       "Animation   99.585366     7.930488     21978630  1.463147e+10       61.0\n",
       "Biography  136.022727     7.938636     24006844  8.276358e+09       48.0\n",
       "Comedy     112.129032     7.901290     27620327  1.566387e+10       45.0\n",
       "Crime      126.392523     8.016822     33533615  8.452632e+09       47.0\n",
       "Drama      124.737024     7.957439     61367304  3.540997e+10       28.0\n",
       "Family     107.500000     7.800000       551221  4.391106e+08       67.0\n",
       "Fantasy     85.000000     8.000000       146222  7.827267e+08        NaN\n",
       "Film-Noir  104.000000     7.966667       367215  1.259105e+08       94.0\n",
       "Horror     102.090909     7.909091      3742556  1.034649e+09       46.0\n",
       "Mystery    119.083333     7.975000      4203004  1.256417e+09       52.0\n",
       "Thriller   108.000000     7.800000        27733  1.755074e+07       81.0\n",
       "Western    148.250000     8.350000      1289665  5.822151e+07       69.0"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# passing dict\n",
    "genres.agg(\n",
    "    {\n",
    "        'Runtime':'mean',\n",
    "        'IMDB_Rating':'mean',\n",
    "        'No_of_Votes':'sum',\n",
    "        'Gross':'sum',\n",
    "        'Metascore':'min'\n",
    "    }\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "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 tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th colspan=\"2\" halign=\"left\">Runtime</th>\n",
       "      <th>IMDB_Rating</th>\n",
       "      <th colspan=\"2\" halign=\"left\">No_of_Votes</th>\n",
       "      <th>Gross</th>\n",
       "      <th>Metascore</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>min</th>\n",
       "      <th>mean</th>\n",
       "      <th>mean</th>\n",
       "      <th>sum</th>\n",
       "      <th>max</th>\n",
       "      <th>sum</th>\n",
       "      <th>min</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Genre</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>Action</th>\n",
       "      <td>45</td>\n",
       "      <td>129.046512</td>\n",
       "      <td>7.949419</td>\n",
       "      <td>72282412</td>\n",
       "      <td>2303232</td>\n",
       "      <td>3.263226e+10</td>\n",
       "      <td>33.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Adventure</th>\n",
       "      <td>88</td>\n",
       "      <td>134.111111</td>\n",
       "      <td>7.937500</td>\n",
       "      <td>22576163</td>\n",
       "      <td>1512360</td>\n",
       "      <td>9.496922e+09</td>\n",
       "      <td>41.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Animation</th>\n",
       "      <td>71</td>\n",
       "      <td>99.585366</td>\n",
       "      <td>7.930488</td>\n",
       "      <td>21978630</td>\n",
       "      <td>999790</td>\n",
       "      <td>1.463147e+10</td>\n",
       "      <td>61.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Biography</th>\n",
       "      <td>93</td>\n",
       "      <td>136.022727</td>\n",
       "      <td>7.938636</td>\n",
       "      <td>24006844</td>\n",
       "      <td>1213505</td>\n",
       "      <td>8.276358e+09</td>\n",
       "      <td>48.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Comedy</th>\n",
       "      <td>68</td>\n",
       "      <td>112.129032</td>\n",
       "      <td>7.901290</td>\n",
       "      <td>27620327</td>\n",
       "      <td>939631</td>\n",
       "      <td>1.566387e+10</td>\n",
       "      <td>45.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Crime</th>\n",
       "      <td>80</td>\n",
       "      <td>126.392523</td>\n",
       "      <td>8.016822</td>\n",
       "      <td>33533615</td>\n",
       "      <td>1826188</td>\n",
       "      <td>8.452632e+09</td>\n",
       "      <td>47.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Drama</th>\n",
       "      <td>64</td>\n",
       "      <td>124.737024</td>\n",
       "      <td>7.957439</td>\n",
       "      <td>61367304</td>\n",
       "      <td>2343110</td>\n",
       "      <td>3.540997e+10</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Family</th>\n",
       "      <td>100</td>\n",
       "      <td>107.500000</td>\n",
       "      <td>7.800000</td>\n",
       "      <td>551221</td>\n",
       "      <td>372490</td>\n",
       "      <td>4.391106e+08</td>\n",
       "      <td>67.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Fantasy</th>\n",
       "      <td>76</td>\n",
       "      <td>85.000000</td>\n",
       "      <td>8.000000</td>\n",
       "      <td>146222</td>\n",
       "      <td>88794</td>\n",
       "      <td>7.827267e+08</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Film-Noir</th>\n",
       "      <td>100</td>\n",
       "      <td>104.000000</td>\n",
       "      <td>7.966667</td>\n",
       "      <td>367215</td>\n",
       "      <td>158731</td>\n",
       "      <td>1.259105e+08</td>\n",
       "      <td>94.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Horror</th>\n",
       "      <td>71</td>\n",
       "      <td>102.090909</td>\n",
       "      <td>7.909091</td>\n",
       "      <td>3742556</td>\n",
       "      <td>787806</td>\n",
       "      <td>1.034649e+09</td>\n",
       "      <td>46.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mystery</th>\n",
       "      <td>96</td>\n",
       "      <td>119.083333</td>\n",
       "      <td>7.975000</td>\n",
       "      <td>4203004</td>\n",
       "      <td>1129894</td>\n",
       "      <td>1.256417e+09</td>\n",
       "      <td>52.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Thriller</th>\n",
       "      <td>108</td>\n",
       "      <td>108.000000</td>\n",
       "      <td>7.800000</td>\n",
       "      <td>27733</td>\n",
       "      <td>27733</td>\n",
       "      <td>1.755074e+07</td>\n",
       "      <td>81.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Western</th>\n",
       "      <td>132</td>\n",
       "      <td>148.250000</td>\n",
       "      <td>8.350000</td>\n",
       "      <td>1289665</td>\n",
       "      <td>688390</td>\n",
       "      <td>5.822151e+07</td>\n",
       "      <td>69.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Runtime             IMDB_Rating No_of_Votes                  Gross  \\\n",
       "              min        mean        mean         sum      max           sum   \n",
       "Genre                                                                          \n",
       "Action         45  129.046512    7.949419    72282412  2303232  3.263226e+10   \n",
       "Adventure      88  134.111111    7.937500    22576163  1512360  9.496922e+09   \n",
       "Animation      71   99.585366    7.930488    21978630   999790  1.463147e+10   \n",
       "Biography      93  136.022727    7.938636    24006844  1213505  8.276358e+09   \n",
       "Comedy         68  112.129032    7.901290    27620327   939631  1.566387e+10   \n",
       "Crime          80  126.392523    8.016822    33533615  1826188  8.452632e+09   \n",
       "Drama          64  124.737024    7.957439    61367304  2343110  3.540997e+10   \n",
       "Family        100  107.500000    7.800000      551221   372490  4.391106e+08   \n",
       "Fantasy        76   85.000000    8.000000      146222    88794  7.827267e+08   \n",
       "Film-Noir     100  104.000000    7.966667      367215   158731  1.259105e+08   \n",
       "Horror         71  102.090909    7.909091     3742556   787806  1.034649e+09   \n",
       "Mystery        96  119.083333    7.975000     4203004  1129894  1.256417e+09   \n",
       "Thriller      108  108.000000    7.800000       27733    27733  1.755074e+07   \n",
       "Western       132  148.250000    8.350000     1289665   688390  5.822151e+07   \n",
       "\n",
       "          Metascore  \n",
       "                min  \n",
       "Genre                \n",
       "Action         33.0  \n",
       "Adventure      41.0  \n",
       "Animation      61.0  \n",
       "Biography      48.0  \n",
       "Comedy         45.0  \n",
       "Crime          47.0  \n",
       "Drama          28.0  \n",
       "Family         67.0  \n",
       "Fantasy         NaN  \n",
       "Film-Noir      94.0  \n",
       "Horror         46.0  \n",
       "Mystery        52.0  \n",
       "Thriller       81.0  \n",
       "Western        69.0  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "genres.agg(\n",
    "    {\n",
    "        'Runtime':['min','mean'],\n",
    "        'IMDB_Rating':'mean',\n",
    "        'No_of_Votes':['sum','max'],\n",
    "        'Gross':'sum',\n",
    "        'Metascore':'min'\n",
    "    }\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 10. apply -> builtin function"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "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>Series_Title</th>\n",
       "      <th>Released_Year</th>\n",
       "      <th>Runtime</th>\n",
       "      <th>Genre</th>\n",
       "      <th>IMDB_Rating</th>\n",
       "      <th>Director</th>\n",
       "      <th>Star1</th>\n",
       "      <th>No_of_Votes</th>\n",
       "      <th>Gross</th>\n",
       "      <th>Metascore</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Genre</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>Action</th>\n",
       "      <td>300</td>\n",
       "      <td>1924</td>\n",
       "      <td>45</td>\n",
       "      <td>Action</td>\n",
       "      <td>7.6</td>\n",
       "      <td>Abhishek Chaubey</td>\n",
       "      <td>Aamir Khan</td>\n",
       "      <td>25312</td>\n",
       "      <td>3296.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Adventure</th>\n",
       "      <td>2001: A Space Odyssey</td>\n",
       "      <td>1925</td>\n",
       "      <td>88</td>\n",
       "      <td>Adventure</td>\n",
       "      <td>7.6</td>\n",
       "      <td>Akira Kurosawa</td>\n",
       "      <td>Aamir Khan</td>\n",
       "      <td>29999</td>\n",
       "      <td>61001.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Animation</th>\n",
       "      <td>Akira</td>\n",
       "      <td>1940</td>\n",
       "      <td>71</td>\n",
       "      <td>Animation</td>\n",
       "      <td>7.6</td>\n",
       "      <td>Adam Elliot</td>\n",
       "      <td>Adrian Molina</td>\n",
       "      <td>25229</td>\n",
       "      <td>128985.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Biography</th>\n",
       "      <td>12 Years a Slave</td>\n",
       "      <td>1928</td>\n",
       "      <td>93</td>\n",
       "      <td>Biography</td>\n",
       "      <td>7.6</td>\n",
       "      <td>Adam McKay</td>\n",
       "      <td>Adrien Brody</td>\n",
       "      <td>27254</td>\n",
       "      <td>21877.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Comedy</th>\n",
       "      <td>(500) Days of Summer</td>\n",
       "      <td>1921</td>\n",
       "      <td>68</td>\n",
       "      <td>Comedy</td>\n",
       "      <td>7.6</td>\n",
       "      <td>Alejandro G. Iñárritu</td>\n",
       "      <td>Aamir Khan</td>\n",
       "      <td>26337</td>\n",
       "      <td>1305.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Crime</th>\n",
       "      <td>12 Angry Men</td>\n",
       "      <td>1931</td>\n",
       "      <td>80</td>\n",
       "      <td>Crime</td>\n",
       "      <td>7.6</td>\n",
       "      <td>Akira Kurosawa</td>\n",
       "      <td>Ajay Devgn</td>\n",
       "      <td>27712</td>\n",
       "      <td>6013.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Drama</th>\n",
       "      <td>1917</td>\n",
       "      <td>1925</td>\n",
       "      <td>64</td>\n",
       "      <td>Drama</td>\n",
       "      <td>7.6</td>\n",
       "      <td>Aamir Khan</td>\n",
       "      <td>Abhay Deol</td>\n",
       "      <td>25088</td>\n",
       "      <td>3600.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Family</th>\n",
       "      <td>E.T. the Extra-Terrestrial</td>\n",
       "      <td>1971</td>\n",
       "      <td>100</td>\n",
       "      <td>Family</td>\n",
       "      <td>7.8</td>\n",
       "      <td>Mel Stuart</td>\n",
       "      <td>Gene Wilder</td>\n",
       "      <td>178731</td>\n",
       "      <td>4000000.0</td>\n",
       "      <td>67.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Fantasy</th>\n",
       "      <td>Das Cabinet des Dr. Caligari</td>\n",
       "      <td>1920</td>\n",
       "      <td>76</td>\n",
       "      <td>Fantasy</td>\n",
       "      <td>7.9</td>\n",
       "      <td>F.W. Murnau</td>\n",
       "      <td>Max Schreck</td>\n",
       "      <td>57428</td>\n",
       "      <td>337574718.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Film-Noir</th>\n",
       "      <td>Shadow of a Doubt</td>\n",
       "      <td>1941</td>\n",
       "      <td>100</td>\n",
       "      <td>Film-Noir</td>\n",
       "      <td>7.8</td>\n",
       "      <td>Alfred Hitchcock</td>\n",
       "      <td>Humphrey Bogart</td>\n",
       "      <td>59556</td>\n",
       "      <td>449191.0</td>\n",
       "      <td>94.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Horror</th>\n",
       "      <td>Alien</td>\n",
       "      <td>1933</td>\n",
       "      <td>71</td>\n",
       "      <td>Horror</td>\n",
       "      <td>7.6</td>\n",
       "      <td>Alejandro Amenábar</td>\n",
       "      <td>Anthony Perkins</td>\n",
       "      <td>27007</td>\n",
       "      <td>89029.0</td>\n",
       "      <td>46.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mystery</th>\n",
       "      <td>Dark City</td>\n",
       "      <td>1938</td>\n",
       "      <td>96</td>\n",
       "      <td>Mystery</td>\n",
       "      <td>7.6</td>\n",
       "      <td>Alex Proyas</td>\n",
       "      <td>Bernard-Pierre Donnadieu</td>\n",
       "      <td>33982</td>\n",
       "      <td>1035953.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Thriller</th>\n",
       "      <td>Wait Until Dark</td>\n",
       "      <td>1967</td>\n",
       "      <td>108</td>\n",
       "      <td>Thriller</td>\n",
       "      <td>7.8</td>\n",
       "      <td>Terence Young</td>\n",
       "      <td>Audrey Hepburn</td>\n",
       "      <td>27733</td>\n",
       "      <td>17550741.0</td>\n",
       "      <td>81.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Western</th>\n",
       "      <td>Il buono, il brutto, il cattivo</td>\n",
       "      <td>1965</td>\n",
       "      <td>132</td>\n",
       "      <td>Western</td>\n",
       "      <td>7.8</td>\n",
       "      <td>Clint Eastwood</td>\n",
       "      <td>Clint Eastwood</td>\n",
       "      <td>65659</td>\n",
       "      <td>5321508.0</td>\n",
       "      <td>69.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                              Series_Title Released_Year  Runtime      Genre  \\\n",
       "Genre                                                                          \n",
       "Action                                 300          1924       45     Action   \n",
       "Adventure            2001: A Space Odyssey          1925       88  Adventure   \n",
       "Animation                            Akira          1940       71  Animation   \n",
       "Biography                 12 Years a Slave          1928       93  Biography   \n",
       "Comedy                (500) Days of Summer          1921       68     Comedy   \n",
       "Crime                         12 Angry Men          1931       80      Crime   \n",
       "Drama                                 1917          1925       64      Drama   \n",
       "Family          E.T. the Extra-Terrestrial          1971      100     Family   \n",
       "Fantasy       Das Cabinet des Dr. Caligari          1920       76    Fantasy   \n",
       "Film-Noir                Shadow of a Doubt          1941      100  Film-Noir   \n",
       "Horror                               Alien          1933       71     Horror   \n",
       "Mystery                          Dark City          1938       96    Mystery   \n",
       "Thriller                   Wait Until Dark          1967      108   Thriller   \n",
       "Western    Il buono, il brutto, il cattivo          1965      132    Western   \n",
       "\n",
       "           IMDB_Rating               Director                     Star1  \\\n",
       "Genre                                                                     \n",
       "Action             7.6       Abhishek Chaubey                Aamir Khan   \n",
       "Adventure          7.6         Akira Kurosawa                Aamir Khan   \n",
       "Animation          7.6            Adam Elliot             Adrian Molina   \n",
       "Biography          7.6             Adam McKay              Adrien Brody   \n",
       "Comedy             7.6  Alejandro G. Iñárritu                Aamir Khan   \n",
       "Crime              7.6         Akira Kurosawa                Ajay Devgn   \n",
       "Drama              7.6             Aamir Khan                Abhay Deol   \n",
       "Family             7.8             Mel Stuart               Gene Wilder   \n",
       "Fantasy            7.9            F.W. Murnau               Max Schreck   \n",
       "Film-Noir          7.8       Alfred Hitchcock           Humphrey Bogart   \n",
       "Horror             7.6     Alejandro Amenábar           Anthony Perkins   \n",
       "Mystery            7.6            Alex Proyas  Bernard-Pierre Donnadieu   \n",
       "Thriller           7.8          Terence Young            Audrey Hepburn   \n",
       "Western            7.8         Clint Eastwood            Clint Eastwood   \n",
       "\n",
       "           No_of_Votes        Gross  Metascore  \n",
       "Genre                                           \n",
       "Action           25312       3296.0        NaN  \n",
       "Adventure        29999      61001.0        NaN  \n",
       "Animation        25229     128985.0        NaN  \n",
       "Biography        27254      21877.0        NaN  \n",
       "Comedy           26337       1305.0        NaN  \n",
       "Crime            27712       6013.0        NaN  \n",
       "Drama            25088       3600.0        NaN  \n",
       "Family          178731    4000000.0       67.0  \n",
       "Fantasy          57428  337574718.0        NaN  \n",
       "Film-Noir        59556     449191.0       94.0  \n",
       "Horror           27007      89029.0       46.0  \n",
       "Mystery          33982    1035953.0        NaN  \n",
       "Thriller         27733   17550741.0       81.0  \n",
       "Western          65659    5321508.0       69.0  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "genres.apply(min)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "base",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.18"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}