video10.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "movies = pd.read_csv(\"data/imdb_1000.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>star_rating</th>\n",
       "      <th>title</th>\n",
       "      <th>content_rating</th>\n",
       "      <th>genre</th>\n",
       "      <th>duration</th>\n",
       "      <th>actors_list</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>9.3</td>\n",
       "      <td>The Shawshank Redemption</td>\n",
       "      <td>R</td>\n",
       "      <td>Crime</td>\n",
       "      <td>142</td>\n",
       "      <td>[u'Tim Robbins', u'Morgan Freeman', u'Bob Gunt...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>9.2</td>\n",
       "      <td>The Godfather</td>\n",
       "      <td>R</td>\n",
       "      <td>Crime</td>\n",
       "      <td>175</td>\n",
       "      <td>[u'Marlon Brando', u'Al Pacino', u'James Caan']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>9.1</td>\n",
       "      <td>The Godfather: Part II</td>\n",
       "      <td>R</td>\n",
       "      <td>Crime</td>\n",
       "      <td>200</td>\n",
       "      <td>[u'Al Pacino', u'Robert De Niro', u'Robert Duv...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>9.0</td>\n",
       "      <td>The Dark Knight</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Action</td>\n",
       "      <td>152</td>\n",
       "      <td>[u'Christian Bale', u'Heath Ledger', u'Aaron E...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>8.9</td>\n",
       "      <td>Pulp Fiction</td>\n",
       "      <td>R</td>\n",
       "      <td>Crime</td>\n",
       "      <td>154</td>\n",
       "      <td>[u'John Travolta', u'Uma Thurman', u'Samuel L....</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   star_rating                     title content_rating   genre  duration  \\\n",
       "0          9.3  The Shawshank Redemption              R   Crime       142   \n",
       "1          9.2             The Godfather              R   Crime       175   \n",
       "2          9.1    The Godfather: Part II              R   Crime       200   \n",
       "3          9.0           The Dark Knight          PG-13  Action       152   \n",
       "4          8.9              Pulp Fiction              R   Crime       154   \n",
       "\n",
       "                                         actors_list  \n",
       "0  [u'Tim Robbins', u'Morgan Freeman', u'Bob Gunt...  \n",
       "1    [u'Marlon Brando', u'Al Pacino', u'James Caan']  \n",
       "2  [u'Al Pacino', u'Robert De Niro', u'Robert Duv...  \n",
       "3  [u'Christian Bale', u'Heath Ledger', u'Aaron E...  \n",
       "4  [u'John Travolta', u'Uma Thurman', u'Samuel L....  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>star_rating</th>\n",
       "      <th>title</th>\n",
       "      <th>content_rating</th>\n",
       "      <th>genre</th>\n",
       "      <th>duration</th>\n",
       "      <th>actors_list</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>8.7</td>\n",
       "      <td>Seven Samurai</td>\n",
       "      <td>UNRATED</td>\n",
       "      <td>Drama</td>\n",
       "      <td>207</td>\n",
       "      <td>[u'Toshir\\xf4 Mifune', u'Takashi Shimura', u'K...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>8.2</td>\n",
       "      <td>Gone with the Wind</td>\n",
       "      <td>G</td>\n",
       "      <td>Drama</td>\n",
       "      <td>238</td>\n",
       "      <td>[u'Clark Gable', u'Vivien Leigh', u'Thomas Mit...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476</th>\n",
       "      <td>7.8</td>\n",
       "      <td>Hamlet</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Drama</td>\n",
       "      <td>242</td>\n",
       "      <td>[u'Kenneth Branagh', u'Julie Christie', u'Dere...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     star_rating               title content_rating  genre  duration  \\\n",
       "17           8.7       Seven Samurai        UNRATED  Drama       207   \n",
       "157          8.2  Gone with the Wind              G  Drama       238   \n",
       "476          7.8              Hamlet          PG-13  Drama       242   \n",
       "\n",
       "                                           actors_list  \n",
       "17   [u'Toshir\\xf4 Mifune', u'Takashi Shimura', u'K...  \n",
       "157  [u'Clark Gable', u'Vivien Leigh', u'Thomas Mit...  \n",
       "476  [u'Kenneth Branagh', u'Julie Christie', u'Dere...  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies[(movies.duration >=200) & (movies.genre == \"Drama\")]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>star_rating</th>\n",
       "      <th>title</th>\n",
       "      <th>content_rating</th>\n",
       "      <th>genre</th>\n",
       "      <th>duration</th>\n",
       "      <th>actors_list</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>9.1</td>\n",
       "      <td>The Godfather: Part II</td>\n",
       "      <td>R</td>\n",
       "      <td>Crime</td>\n",
       "      <td>200</td>\n",
       "      <td>[u'Al Pacino', u'Robert De Niro', u'Robert Duv...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>8.9</td>\n",
       "      <td>12 Angry Men</td>\n",
       "      <td>NOT RATED</td>\n",
       "      <td>Drama</td>\n",
       "      <td>96</td>\n",
       "      <td>[u'Henry Fonda', u'Lee J. Cobb', u'Martin Bals...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8.9</td>\n",
       "      <td>The Lord of the Rings: The Return of the King</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Adventure</td>\n",
       "      <td>201</td>\n",
       "      <td>[u'Elijah Wood', u'Viggo Mortensen', u'Ian McK...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>8.9</td>\n",
       "      <td>Fight Club</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>139</td>\n",
       "      <td>[u'Brad Pitt', u'Edward Norton', u'Helena Bonh...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>8.8</td>\n",
       "      <td>Forrest Gump</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Drama</td>\n",
       "      <td>142</td>\n",
       "      <td>[u'Tom Hanks', u'Robin Wright', u'Gary Sinise']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>8.7</td>\n",
       "      <td>One Flew Over the Cuckoo's Nest</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>133</td>\n",
       "      <td>[u'Jack Nicholson', u'Louise Fletcher', u'Mich...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>8.7</td>\n",
       "      <td>Seven Samurai</td>\n",
       "      <td>UNRATED</td>\n",
       "      <td>Drama</td>\n",
       "      <td>207</td>\n",
       "      <td>[u'Toshir\\xf4 Mifune', u'Takashi Shimura', u'K...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>8.7</td>\n",
       "      <td>It's a Wonderful Life</td>\n",
       "      <td>APPROVED</td>\n",
       "      <td>Drama</td>\n",
       "      <td>130</td>\n",
       "      <td>[u'James Stewart', u'Donna Reed', u'Lionel Bar...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>8.7</td>\n",
       "      <td>Se7en</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>127</td>\n",
       "      <td>[u'Morgan Freeman', u'Brad Pitt', u'Kevin Spac...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>8.6</td>\n",
       "      <td>The Silence of the Lambs</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>118</td>\n",
       "      <td>[u'Jodie Foster', u'Anthony Hopkins', u'Lawren...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>8.6</td>\n",
       "      <td>Casablanca</td>\n",
       "      <td>PG</td>\n",
       "      <td>Drama</td>\n",
       "      <td>102</td>\n",
       "      <td>[u'Humphrey Bogart', u'Ingrid Bergman', u'Paul...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>8.6</td>\n",
       "      <td>Whiplash</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>107</td>\n",
       "      <td>[u'Miles Teller', u'J.K. Simmons', u'Melissa B...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>8.5</td>\n",
       "      <td>Sunset Blvd.</td>\n",
       "      <td>NOT RATED</td>\n",
       "      <td>Drama</td>\n",
       "      <td>110</td>\n",
       "      <td>[u'William Holden', u'Gloria Swanson', u'Erich...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>8.5</td>\n",
       "      <td>Taare Zameen Par</td>\n",
       "      <td>PG</td>\n",
       "      <td>Drama</td>\n",
       "      <td>165</td>\n",
       "      <td>[u'Darsheel Safary', u'Aamir Khan', u'Tanay Ch...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>8.5</td>\n",
       "      <td>Cinema Paradiso</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>155</td>\n",
       "      <td>[u'Philippe Noiret', u'Enzo Cannavale', u'Anto...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>8.5</td>\n",
       "      <td>Apocalypse Now</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>153</td>\n",
       "      <td>[u'Martin Sheen', u'Marlon Brando', u'Robert D...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>8.5</td>\n",
       "      <td>The Prestige</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Drama</td>\n",
       "      <td>130</td>\n",
       "      <td>[u'Christian Bale', u'Hugh Jackman', u'Scarlet...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>8.5</td>\n",
       "      <td>The Lives of Others</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>137</td>\n",
       "      <td>[u'Ulrich M\\xfche', u'Martina Gedeck', u'Sebas...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>8.5</td>\n",
       "      <td>Paths of Glory</td>\n",
       "      <td>APPROVED</td>\n",
       "      <td>Drama</td>\n",
       "      <td>88</td>\n",
       "      <td>[u'Kirk Douglas', u'Ralph Meeker', u'Adolphe M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>8.4</td>\n",
       "      <td>American Beauty</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>122</td>\n",
       "      <td>[u'Kevin Spacey', u'Annette Bening', u'Thora B...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>8.4</td>\n",
       "      <td>Rang De Basanti</td>\n",
       "      <td>NOT RATED</td>\n",
       "      <td>Drama</td>\n",
       "      <td>157</td>\n",
       "      <td>[u'Aamir Khan', u'Soha Ali Khan', u'Siddharth']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>8.4</td>\n",
       "      <td>Jodaeiye Nader az Simin</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Drama</td>\n",
       "      <td>123</td>\n",
       "      <td>[u'Peyman Moaadi', u'Leila Hatami', u'Sareh Ba...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>8.4</td>\n",
       "      <td>Citizen Kane</td>\n",
       "      <td>APPROVED</td>\n",
       "      <td>Drama</td>\n",
       "      <td>119</td>\n",
       "      <td>[u'Orson Welles', u'Joseph Cotten', u'Dorothy ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>8.4</td>\n",
       "      <td>Oldeuboi</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>120</td>\n",
       "      <td>[u'Min-sik Choi', u'Ji-tae Yu', u'Hye-jeong Ka...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>8.4</td>\n",
       "      <td>Once Upon a Time in America</td>\n",
       "      <td>R</td>\n",
       "      <td>Crime</td>\n",
       "      <td>229</td>\n",
       "      <td>[u'Robert De Niro', u'James Woods', u'Elizabet...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>8.4</td>\n",
       "      <td>To Kill a Mockingbird</td>\n",
       "      <td>NOT RATED</td>\n",
       "      <td>Drama</td>\n",
       "      <td>129</td>\n",
       "      <td>[u'Gregory Peck', u'John Megna', u'Frank Overt...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>8.4</td>\n",
       "      <td>Requiem for a Dream</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>102</td>\n",
       "      <td>[u'Ellen Burstyn', u'Jared Leto', u'Jennifer C...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>8.4</td>\n",
       "      <td>Lawrence of Arabia</td>\n",
       "      <td>PG</td>\n",
       "      <td>Adventure</td>\n",
       "      <td>216</td>\n",
       "      <td>[u\"Peter O'Toole\", u'Alec Guinness', u'Anthony...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>8.4</td>\n",
       "      <td>Bicycle Thieves</td>\n",
       "      <td>NOT RATED</td>\n",
       "      <td>Drama</td>\n",
       "      <td>93</td>\n",
       "      <td>[u'Lamberto Maggiorani', u'Enzo Staiola', u'Li...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>8.4</td>\n",
       "      <td>Swades</td>\n",
       "      <td>NOT RATED</td>\n",
       "      <td>Drama</td>\n",
       "      <td>189</td>\n",
       "      <td>[u'Shah Rukh Khan', u'Gayatri Joshi', u'Kishor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>875</th>\n",
       "      <td>7.5</td>\n",
       "      <td>Rust and Bone</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>120</td>\n",
       "      <td>[u'Marion Cotillard', u'Matthias Schoenaerts',...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>877</th>\n",
       "      <td>7.5</td>\n",
       "      <td>Legends of the Fall</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>133</td>\n",
       "      <td>[u'Brad Pitt', u'Anthony Hopkins', u'Aidan Qui...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>879</th>\n",
       "      <td>7.5</td>\n",
       "      <td>The Constant Gardener</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>129</td>\n",
       "      <td>[u'Ralph Fiennes', u'Rachel Weisz', u'Hubert K...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>886</th>\n",
       "      <td>7.5</td>\n",
       "      <td>Pi</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>84</td>\n",
       "      <td>[u'Sean Gullette', u'Mark Margolis', u'Ben She...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>887</th>\n",
       "      <td>7.5</td>\n",
       "      <td>The Devil's Backbone</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>106</td>\n",
       "      <td>[u'Marisa Paredes', u'Eduardo Noriega', u'Fede...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>889</th>\n",
       "      <td>7.5</td>\n",
       "      <td>Devil's Advocate</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>144</td>\n",
       "      <td>[u'Keanu Reeves', u'Al Pacino', u'Charlize The...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>895</th>\n",
       "      <td>7.5</td>\n",
       "      <td>Biutiful</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>148</td>\n",
       "      <td>[u'Javier Bardem', u'Maricel \\xc1lvarez', u'Ha...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>897</th>\n",
       "      <td>7.5</td>\n",
       "      <td>Calvary</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>102</td>\n",
       "      <td>[u'Brendan Gleeson', u\"Chris O'Dowd\", u'Kelly ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>901</th>\n",
       "      <td>7.5</td>\n",
       "      <td>Babel</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>143</td>\n",
       "      <td>[u'Brad Pitt', u'Cate Blanchett', u'Gael Garc\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>904</th>\n",
       "      <td>7.5</td>\n",
       "      <td>Sweeney Todd: The Demon Barber of Fleet Street</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>116</td>\n",
       "      <td>[u'Johnny Depp', u'Helena Bonham Carter', u'Al...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>910</th>\n",
       "      <td>7.5</td>\n",
       "      <td>2046</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>129</td>\n",
       "      <td>[u'Tony Chiu Wai Leung', u'Ziyi Zhang', u'Faye...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>914</th>\n",
       "      <td>7.5</td>\n",
       "      <td>The Judge</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>141</td>\n",
       "      <td>[u'Robert Downey Jr.', u'Robert Duvall', u'Ver...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>916</th>\n",
       "      <td>7.5</td>\n",
       "      <td>Up in the Air</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>109</td>\n",
       "      <td>[u'George Clooney', u'Vera Farmiga', u'Anna Ke...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>917</th>\n",
       "      <td>7.5</td>\n",
       "      <td>Begin Again</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>104</td>\n",
       "      <td>[u'Keira Knightley', u'Mark Ruffalo', u'Adam L...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>922</th>\n",
       "      <td>7.5</td>\n",
       "      <td>Mud</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Drama</td>\n",
       "      <td>130</td>\n",
       "      <td>[u'Matthew McConaughey', u'Tye Sheridan', u'Ja...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>923</th>\n",
       "      <td>7.5</td>\n",
       "      <td>Across the Universe</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Drama</td>\n",
       "      <td>133</td>\n",
       "      <td>[u'Evan Rachel Wood', u'Jim Sturgess', u'Joe A...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>925</th>\n",
       "      <td>7.5</td>\n",
       "      <td>Notes on a Scandal</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>92</td>\n",
       "      <td>[u'Cate Blanchett', u'Judi Dench', u'Andrew Si...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>926</th>\n",
       "      <td>7.5</td>\n",
       "      <td>Inside Llewyn Davis</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>104</td>\n",
       "      <td>[u'Oscar Isaac', u'Carey Mulligan', u'John Goo...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>939</th>\n",
       "      <td>7.4</td>\n",
       "      <td>Predestination</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>97</td>\n",
       "      <td>[u'Ethan Hawke', u'Sarah Snook', u'Noah Taylor']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>941</th>\n",
       "      <td>7.4</td>\n",
       "      <td>A Bridge Too Far</td>\n",
       "      <td>PG</td>\n",
       "      <td>Drama</td>\n",
       "      <td>175</td>\n",
       "      <td>[u'Sean Connery', u\"Ryan O'Neal\", u'Michael Ca...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>945</th>\n",
       "      <td>7.4</td>\n",
       "      <td>Take Shelter</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>120</td>\n",
       "      <td>[u'Michael Shannon', u'Jessica Chastain', u'Sh...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>946</th>\n",
       "      <td>7.4</td>\n",
       "      <td>Far from Heaven</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Drama</td>\n",
       "      <td>107</td>\n",
       "      <td>[u'Julianne Moore', u'Dennis Quaid', u'Dennis ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>947</th>\n",
       "      <td>7.4</td>\n",
       "      <td>Eraserhead</td>\n",
       "      <td>UNRATED</td>\n",
       "      <td>Drama</td>\n",
       "      <td>89</td>\n",
       "      <td>[u'Jack Nance', u'Charlotte Stewart', u'Allen ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>951</th>\n",
       "      <td>7.4</td>\n",
       "      <td>Sleepy Hollow</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>105</td>\n",
       "      <td>[u'Johnny Depp', u'Christina Ricci', u'Miranda...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>955</th>\n",
       "      <td>7.4</td>\n",
       "      <td>Zero Dark Thirty</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>157</td>\n",
       "      <td>[u'Jessica Chastain', u'Joel Edgerton', u'Chri...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>958</th>\n",
       "      <td>7.4</td>\n",
       "      <td>My Sister's Keeper</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Drama</td>\n",
       "      <td>109</td>\n",
       "      <td>[u'Cameron Diaz', u'Abigail Breslin', u'Alec B...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>968</th>\n",
       "      <td>7.4</td>\n",
       "      <td>The English Patient</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>162</td>\n",
       "      <td>[u'Ralph Fiennes', u'Juliette Binoche', u'Will...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>970</th>\n",
       "      <td>7.4</td>\n",
       "      <td>Wonder Boys</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>107</td>\n",
       "      <td>[u'Michael Douglas', u'Tobey Maguire', u'Franc...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>972</th>\n",
       "      <td>7.4</td>\n",
       "      <td>Blue Valentine</td>\n",
       "      <td>NC-17</td>\n",
       "      <td>Drama</td>\n",
       "      <td>112</td>\n",
       "      <td>[u'Ryan Gosling', u'Michelle Williams', u'John...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>973</th>\n",
       "      <td>7.4</td>\n",
       "      <td>The Cider House Rules</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Drama</td>\n",
       "      <td>126</td>\n",
       "      <td>[u'Tobey Maguire', u'Charlize Theron', u'Micha...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>287 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     star_rating                                           title  \\\n",
       "2            9.1                          The Godfather: Part II   \n",
       "5            8.9                                    12 Angry Men   \n",
       "7            8.9   The Lord of the Rings: The Return of the King   \n",
       "9            8.9                                      Fight Club   \n",
       "13           8.8                                    Forrest Gump   \n",
       "16           8.7                 One Flew Over the Cuckoo's Nest   \n",
       "17           8.7                                   Seven Samurai   \n",
       "22           8.7                           It's a Wonderful Life   \n",
       "24           8.7                                           Se7en   \n",
       "27           8.6                        The Silence of the Lambs   \n",
       "32           8.6                                      Casablanca   \n",
       "33           8.6                                        Whiplash   \n",
       "41           8.5                                    Sunset Blvd.   \n",
       "47           8.5                                Taare Zameen Par   \n",
       "50           8.5                                 Cinema Paradiso   \n",
       "51           8.5                                  Apocalypse Now   \n",
       "53           8.5                                    The Prestige   \n",
       "56           8.5                             The Lives of Others   \n",
       "58           8.5                                  Paths of Glory   \n",
       "67           8.4                                 American Beauty   \n",
       "72           8.4                                 Rang De Basanti   \n",
       "73           8.4                         Jodaeiye Nader az Simin   \n",
       "74           8.4                                    Citizen Kane   \n",
       "77           8.4                                        Oldeuboi   \n",
       "78           8.4                     Once Upon a Time in America   \n",
       "83           8.4                           To Kill a Mockingbird   \n",
       "84           8.4                             Requiem for a Dream   \n",
       "85           8.4                              Lawrence of Arabia   \n",
       "87           8.4                                 Bicycle Thieves   \n",
       "89           8.4                                          Swades   \n",
       "..           ...                                             ...   \n",
       "875          7.5                                   Rust and Bone   \n",
       "877          7.5                             Legends of the Fall   \n",
       "879          7.5                           The Constant Gardener   \n",
       "886          7.5                                              Pi   \n",
       "887          7.5                            The Devil's Backbone   \n",
       "889          7.5                                Devil's Advocate   \n",
       "895          7.5                                        Biutiful   \n",
       "897          7.5                                         Calvary   \n",
       "901          7.5                                           Babel   \n",
       "904          7.5  Sweeney Todd: The Demon Barber of Fleet Street   \n",
       "910          7.5                                            2046   \n",
       "914          7.5                                       The Judge   \n",
       "916          7.5                                   Up in the Air   \n",
       "917          7.5                                     Begin Again   \n",
       "922          7.5                                             Mud   \n",
       "923          7.5                             Across the Universe   \n",
       "925          7.5                              Notes on a Scandal   \n",
       "926          7.5                             Inside Llewyn Davis   \n",
       "939          7.4                                  Predestination   \n",
       "941          7.4                                A Bridge Too Far   \n",
       "945          7.4                                    Take Shelter   \n",
       "946          7.4                                 Far from Heaven   \n",
       "947          7.4                                      Eraserhead   \n",
       "951          7.4                                   Sleepy Hollow   \n",
       "955          7.4                                Zero Dark Thirty   \n",
       "958          7.4                              My Sister's Keeper   \n",
       "968          7.4                             The English Patient   \n",
       "970          7.4                                     Wonder Boys   \n",
       "972          7.4                                  Blue Valentine   \n",
       "973          7.4                           The Cider House Rules   \n",
       "\n",
       "    content_rating      genre  duration  \\\n",
       "2                R      Crime       200   \n",
       "5        NOT RATED      Drama        96   \n",
       "7            PG-13  Adventure       201   \n",
       "9                R      Drama       139   \n",
       "13           PG-13      Drama       142   \n",
       "16               R      Drama       133   \n",
       "17         UNRATED      Drama       207   \n",
       "22        APPROVED      Drama       130   \n",
       "24               R      Drama       127   \n",
       "27               R      Drama       118   \n",
       "32              PG      Drama       102   \n",
       "33               R      Drama       107   \n",
       "41       NOT RATED      Drama       110   \n",
       "47              PG      Drama       165   \n",
       "50               R      Drama       155   \n",
       "51               R      Drama       153   \n",
       "53           PG-13      Drama       130   \n",
       "56               R      Drama       137   \n",
       "58        APPROVED      Drama        88   \n",
       "67               R      Drama       122   \n",
       "72       NOT RATED      Drama       157   \n",
       "73           PG-13      Drama       123   \n",
       "74        APPROVED      Drama       119   \n",
       "77               R      Drama       120   \n",
       "78               R      Crime       229   \n",
       "83       NOT RATED      Drama       129   \n",
       "84               R      Drama       102   \n",
       "85              PG  Adventure       216   \n",
       "87       NOT RATED      Drama        93   \n",
       "89       NOT RATED      Drama       189   \n",
       "..             ...        ...       ...   \n",
       "875              R      Drama       120   \n",
       "877              R      Drama       133   \n",
       "879              R      Drama       129   \n",
       "886              R      Drama        84   \n",
       "887              R      Drama       106   \n",
       "889              R      Drama       144   \n",
       "895              R      Drama       148   \n",
       "897              R      Drama       102   \n",
       "901              R      Drama       143   \n",
       "904              R      Drama       116   \n",
       "910              R      Drama       129   \n",
       "914              R      Drama       141   \n",
       "916              R      Drama       109   \n",
       "917              R      Drama       104   \n",
       "922          PG-13      Drama       130   \n",
       "923          PG-13      Drama       133   \n",
       "925              R      Drama        92   \n",
       "926              R      Drama       104   \n",
       "939              R      Drama        97   \n",
       "941             PG      Drama       175   \n",
       "945              R      Drama       120   \n",
       "946          PG-13      Drama       107   \n",
       "947        UNRATED      Drama        89   \n",
       "951              R      Drama       105   \n",
       "955              R      Drama       157   \n",
       "958          PG-13      Drama       109   \n",
       "968              R      Drama       162   \n",
       "970              R      Drama       107   \n",
       "972          NC-17      Drama       112   \n",
       "973          PG-13      Drama       126   \n",
       "\n",
       "                                           actors_list  \n",
       "2    [u'Al Pacino', u'Robert De Niro', u'Robert Duv...  \n",
       "5    [u'Henry Fonda', u'Lee J. Cobb', u'Martin Bals...  \n",
       "7    [u'Elijah Wood', u'Viggo Mortensen', u'Ian McK...  \n",
       "9    [u'Brad Pitt', u'Edward Norton', u'Helena Bonh...  \n",
       "13     [u'Tom Hanks', u'Robin Wright', u'Gary Sinise']  \n",
       "16   [u'Jack Nicholson', u'Louise Fletcher', u'Mich...  \n",
       "17   [u'Toshir\\xf4 Mifune', u'Takashi Shimura', u'K...  \n",
       "22   [u'James Stewart', u'Donna Reed', u'Lionel Bar...  \n",
       "24   [u'Morgan Freeman', u'Brad Pitt', u'Kevin Spac...  \n",
       "27   [u'Jodie Foster', u'Anthony Hopkins', u'Lawren...  \n",
       "32   [u'Humphrey Bogart', u'Ingrid Bergman', u'Paul...  \n",
       "33   [u'Miles Teller', u'J.K. Simmons', u'Melissa B...  \n",
       "41   [u'William Holden', u'Gloria Swanson', u'Erich...  \n",
       "47   [u'Darsheel Safary', u'Aamir Khan', u'Tanay Ch...  \n",
       "50   [u'Philippe Noiret', u'Enzo Cannavale', u'Anto...  \n",
       "51   [u'Martin Sheen', u'Marlon Brando', u'Robert D...  \n",
       "53   [u'Christian Bale', u'Hugh Jackman', u'Scarlet...  \n",
       "56   [u'Ulrich M\\xfche', u'Martina Gedeck', u'Sebas...  \n",
       "58   [u'Kirk Douglas', u'Ralph Meeker', u'Adolphe M...  \n",
       "67   [u'Kevin Spacey', u'Annette Bening', u'Thora B...  \n",
       "72     [u'Aamir Khan', u'Soha Ali Khan', u'Siddharth']  \n",
       "73   [u'Peyman Moaadi', u'Leila Hatami', u'Sareh Ba...  \n",
       "74   [u'Orson Welles', u'Joseph Cotten', u'Dorothy ...  \n",
       "77   [u'Min-sik Choi', u'Ji-tae Yu', u'Hye-jeong Ka...  \n",
       "78   [u'Robert De Niro', u'James Woods', u'Elizabet...  \n",
       "83   [u'Gregory Peck', u'John Megna', u'Frank Overt...  \n",
       "84   [u'Ellen Burstyn', u'Jared Leto', u'Jennifer C...  \n",
       "85   [u\"Peter O'Toole\", u'Alec Guinness', u'Anthony...  \n",
       "87   [u'Lamberto Maggiorani', u'Enzo Staiola', u'Li...  \n",
       "89   [u'Shah Rukh Khan', u'Gayatri Joshi', u'Kishor...  \n",
       "..                                                 ...  \n",
       "875  [u'Marion Cotillard', u'Matthias Schoenaerts',...  \n",
       "877  [u'Brad Pitt', u'Anthony Hopkins', u'Aidan Qui...  \n",
       "879  [u'Ralph Fiennes', u'Rachel Weisz', u'Hubert K...  \n",
       "886  [u'Sean Gullette', u'Mark Margolis', u'Ben She...  \n",
       "887  [u'Marisa Paredes', u'Eduardo Noriega', u'Fede...  \n",
       "889  [u'Keanu Reeves', u'Al Pacino', u'Charlize The...  \n",
       "895  [u'Javier Bardem', u'Maricel \\xc1lvarez', u'Ha...  \n",
       "897  [u'Brendan Gleeson', u\"Chris O'Dowd\", u'Kelly ...  \n",
       "901  [u'Brad Pitt', u'Cate Blanchett', u'Gael Garc\\...  \n",
       "904  [u'Johnny Depp', u'Helena Bonham Carter', u'Al...  \n",
       "910  [u'Tony Chiu Wai Leung', u'Ziyi Zhang', u'Faye...  \n",
       "914  [u'Robert Downey Jr.', u'Robert Duvall', u'Ver...  \n",
       "916  [u'George Clooney', u'Vera Farmiga', u'Anna Ke...  \n",
       "917  [u'Keira Knightley', u'Mark Ruffalo', u'Adam L...  \n",
       "922  [u'Matthew McConaughey', u'Tye Sheridan', u'Ja...  \n",
       "923  [u'Evan Rachel Wood', u'Jim Sturgess', u'Joe A...  \n",
       "925  [u'Cate Blanchett', u'Judi Dench', u'Andrew Si...  \n",
       "926  [u'Oscar Isaac', u'Carey Mulligan', u'John Goo...  \n",
       "939   [u'Ethan Hawke', u'Sarah Snook', u'Noah Taylor']  \n",
       "941  [u'Sean Connery', u\"Ryan O'Neal\", u'Michael Ca...  \n",
       "945  [u'Michael Shannon', u'Jessica Chastain', u'Sh...  \n",
       "946  [u'Julianne Moore', u'Dennis Quaid', u'Dennis ...  \n",
       "947  [u'Jack Nance', u'Charlotte Stewart', u'Allen ...  \n",
       "951  [u'Johnny Depp', u'Christina Ricci', u'Miranda...  \n",
       "955  [u'Jessica Chastain', u'Joel Edgerton', u'Chri...  \n",
       "958  [u'Cameron Diaz', u'Abigail Breslin', u'Alec B...  \n",
       "968  [u'Ralph Fiennes', u'Juliette Binoche', u'Will...  \n",
       "970  [u'Michael Douglas', u'Tobey Maguire', u'Franc...  \n",
       "972  [u'Ryan Gosling', u'Michelle Williams', u'John...  \n",
       "973  [u'Tobey Maguire', u'Charlize Theron', u'Micha...  \n",
       "\n",
       "[287 rows x 6 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies[(movies.duration >=200) | (movies.genre == \"Drama\")]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0      False\n",
       "1      False\n",
       "2       True\n",
       "3      False\n",
       "4      False\n",
       "5       True\n",
       "6      False\n",
       "7       True\n",
       "8      False\n",
       "9       True\n",
       "10     False\n",
       "11     False\n",
       "12     False\n",
       "13      True\n",
       "14     False\n",
       "15     False\n",
       "16      True\n",
       "17      True\n",
       "18     False\n",
       "19     False\n",
       "20     False\n",
       "21     False\n",
       "22      True\n",
       "23     False\n",
       "24      True\n",
       "25     False\n",
       "26     False\n",
       "27      True\n",
       "28     False\n",
       "29     False\n",
       "       ...  \n",
       "949    False\n",
       "950    False\n",
       "951     True\n",
       "952    False\n",
       "953    False\n",
       "954    False\n",
       "955     True\n",
       "956    False\n",
       "957    False\n",
       "958     True\n",
       "959    False\n",
       "960    False\n",
       "961    False\n",
       "962    False\n",
       "963    False\n",
       "964    False\n",
       "965    False\n",
       "966    False\n",
       "967    False\n",
       "968     True\n",
       "969    False\n",
       "970     True\n",
       "971    False\n",
       "972     True\n",
       "973     True\n",
       "974    False\n",
       "975    False\n",
       "976    False\n",
       "977    False\n",
       "978    False\n",
       "Length: 979, dtype: bool"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "(movies.duration >=200) | (movies.genre == \"Drama\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>star_rating</th>\n",
       "      <th>title</th>\n",
       "      <th>content_rating</th>\n",
       "      <th>genre</th>\n",
       "      <th>duration</th>\n",
       "      <th>actors_list</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>684</th>\n",
       "      <td>7.7</td>\n",
       "      <td>The Big Blue</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Action</td>\n",
       "      <td>168</td>\n",
       "      <td>[u'Jean-Marc Barr', u'Jean Reno', u'Rosanna Ar...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>649</th>\n",
       "      <td>7.7</td>\n",
       "      <td>Where Eagles Dare</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Action</td>\n",
       "      <td>158</td>\n",
       "      <td>[u'Richard Burton', u'Clint Eastwood', u'Mary ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>633</th>\n",
       "      <td>7.7</td>\n",
       "      <td>The Warriors</td>\n",
       "      <td>R</td>\n",
       "      <td>Action</td>\n",
       "      <td>92</td>\n",
       "      <td>[u'Michael Beck', u'James Remar', u'Dorsey Wri...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>623</th>\n",
       "      <td>7.7</td>\n",
       "      <td>Dawn of the Planet of the Apes</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Action</td>\n",
       "      <td>130</td>\n",
       "      <td>[u'Gary Oldman', u'Keri Russell', u'Andy Serkis']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>619</th>\n",
       "      <td>7.7</td>\n",
       "      <td>Forbidden Planet</td>\n",
       "      <td>PASSED</td>\n",
       "      <td>Action</td>\n",
       "      <td>98</td>\n",
       "      <td>[u'Walter Pidgeon', u'Anne Francis', u'Leslie ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>613</th>\n",
       "      <td>7.7</td>\n",
       "      <td>The Last Samurai</td>\n",
       "      <td>R</td>\n",
       "      <td>Action</td>\n",
       "      <td>154</td>\n",
       "      <td>[u'Tom Cruise', u'Ken Watanabe', u'Billy Conno...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>610</th>\n",
       "      <td>7.7</td>\n",
       "      <td>Enter the Dragon</td>\n",
       "      <td>R</td>\n",
       "      <td>Action</td>\n",
       "      <td>102</td>\n",
       "      <td>[u'Bruce Lee', u'John Saxon', u'Jim Kelly']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>598</th>\n",
       "      <td>7.7</td>\n",
       "      <td>Kick-Ass</td>\n",
       "      <td>R</td>\n",
       "      <td>Action</td>\n",
       "      <td>117</td>\n",
       "      <td>[u'Aaron Taylor-Johnson', u'Nicolas Cage', u'C...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>591</th>\n",
       "      <td>7.7</td>\n",
       "      <td>The Count of Monte Cristo</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Action</td>\n",
       "      <td>131</td>\n",
       "      <td>[u'Jim Caviezel', u'Guy Pearce', u'Richard Har...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>586</th>\n",
       "      <td>7.7</td>\n",
       "      <td>Star Trek II: The Wrath of Khan</td>\n",
       "      <td>PG</td>\n",
       "      <td>Action</td>\n",
       "      <td>113</td>\n",
       "      <td>[u'William Shatner', u'Leonard Nimoy', u'DeFor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>581</th>\n",
       "      <td>7.8</td>\n",
       "      <td>Man on Fire</td>\n",
       "      <td>R</td>\n",
       "      <td>Action</td>\n",
       "      <td>146</td>\n",
       "      <td>[u'Denzel Washington', u'Christopher Walken', ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>235</th>\n",
       "      <td>8.1</td>\n",
       "      <td>Yip Man</td>\n",
       "      <td>R</td>\n",
       "      <td>Action</td>\n",
       "      <td>106</td>\n",
       "      <td>[u'Donnie Yen', u'Simon Yam', u'Siu-Wong Fan']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>573</th>\n",
       "      <td>7.8</td>\n",
       "      <td>Battle Royale</td>\n",
       "      <td>NOT RATED</td>\n",
       "      <td>Action</td>\n",
       "      <td>114</td>\n",
       "      <td>[u'Tatsuya Fujiwara', u'Aki Maeda', u'Tar\\xf4 ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239</th>\n",
       "      <td>8.1</td>\n",
       "      <td>Elite Squad: The Enemy Within</td>\n",
       "      <td>UNRATED</td>\n",
       "      <td>Action</td>\n",
       "      <td>115</td>\n",
       "      <td>[u'Wagner Moura', u'Irandhir Santos', u'Andr\\x...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>240</th>\n",
       "      <td>8.1</td>\n",
       "      <td>The Bourne Ultimatum</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Action</td>\n",
       "      <td>115</td>\n",
       "      <td>[u'Matt Damon', u'\\xc9dgar Ram\\xedrez', u'Joan...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>570</th>\n",
       "      <td>7.8</td>\n",
       "      <td>300</td>\n",
       "      <td>R</td>\n",
       "      <td>Action</td>\n",
       "      <td>117</td>\n",
       "      <td>[u'Gerard Butler', u'Lena Headey', u'David Wen...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>568</th>\n",
       "      <td>7.8</td>\n",
       "      <td>Skyfall</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Action</td>\n",
       "      <td>143</td>\n",
       "      <td>[u'Daniel Craig', u'Javier Bardem', u'Naomie H...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>567</th>\n",
       "      <td>7.8</td>\n",
       "      <td>The Bourne Supremacy</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Action</td>\n",
       "      <td>108</td>\n",
       "      <td>[u'Matt Damon', u'Franka Potente', u'Joan Allen']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>653</th>\n",
       "      <td>7.7</td>\n",
       "      <td>Fearless</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Action</td>\n",
       "      <td>104</td>\n",
       "      <td>[u'Jet Li', u'Li Sun', u'Yong Dong']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>248</th>\n",
       "      <td>8.1</td>\n",
       "      <td>X-Men: Days of Future Past</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Action</td>\n",
       "      <td>131</td>\n",
       "      <td>[u'Patrick Stewart', u'Ian McKellen', u'Hugh J...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>661</th>\n",
       "      <td>7.7</td>\n",
       "      <td>Star Wars: Episode III - Revenge of the Sith</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Action</td>\n",
       "      <td>140</td>\n",
       "      <td>[u'Hayden Christensen', u'Natalie Portman', u'...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>8.1</td>\n",
       "      <td>Kill Bill: Vol. 1</td>\n",
       "      <td>R</td>\n",
       "      <td>Action</td>\n",
       "      <td>111</td>\n",
       "      <td>[u'Uma Thurman', u'David Carradine', u'Daryl H...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>729</th>\n",
       "      <td>7.6</td>\n",
       "      <td>The Crow</td>\n",
       "      <td>R</td>\n",
       "      <td>Action</td>\n",
       "      <td>102</td>\n",
       "      <td>[u'Brandon Lee', u'Michael Wincott', u'Rochell...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>726</th>\n",
       "      <td>7.6</td>\n",
       "      <td>Sherlock Holmes</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Action</td>\n",
       "      <td>128</td>\n",
       "      <td>[u'Robert Downey Jr.', u'Jude Law', u'Rachel M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>8.2</td>\n",
       "      <td>Rush</td>\n",
       "      <td>R</td>\n",
       "      <td>Action</td>\n",
       "      <td>123</td>\n",
       "      <td>[u'Daniel Br\\xfchl', u'Chris Hemsworth', u'Oli...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>722</th>\n",
       "      <td>7.6</td>\n",
       "      <td>Lethal Weapon</td>\n",
       "      <td>R</td>\n",
       "      <td>Action</td>\n",
       "      <td>110</td>\n",
       "      <td>[u'Mel Gibson', u'Danny Glover', u'Gary Busey']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>717</th>\n",
       "      <td>7.6</td>\n",
       "      <td>The Legend of Drunken Master</td>\n",
       "      <td>R</td>\n",
       "      <td>Action</td>\n",
       "      <td>102</td>\n",
       "      <td>[u'Jackie Chan', u'Ho-Sung Pak', u'Lung Ti']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>707</th>\n",
       "      <td>7.6</td>\n",
       "      <td>Watchmen</td>\n",
       "      <td>R</td>\n",
       "      <td>Action</td>\n",
       "      <td>162</td>\n",
       "      <td>[u'Jackie Earle Haley', u'Patrick Wilson', u'C...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>8.2</td>\n",
       "      <td>Tae Guk Gi: The Brotherhood of War</td>\n",
       "      <td>R</td>\n",
       "      <td>Action</td>\n",
       "      <td>140</td>\n",
       "      <td>[u'Dong-gun Jang', u'Bin Won', u'Eun-ju Lee']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>701</th>\n",
       "      <td>7.6</td>\n",
       "      <td>United 93</td>\n",
       "      <td>R</td>\n",
       "      <td>Action</td>\n",
       "      <td>111</td>\n",
       "      <td>[u'David Alan Basche', u'Olivia Thirlby', u'Li...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>543</th>\n",
       "      <td>7.8</td>\n",
       "      <td>Lost in Translation</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>101</td>\n",
       "      <td>[u'Bill Murray', u'Scarlett Johansson', u'Giov...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>540</th>\n",
       "      <td>7.8</td>\n",
       "      <td>The Color Purple</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Drama</td>\n",
       "      <td>154</td>\n",
       "      <td>[u'Danny Glover', u'Whoopi Goldberg', u'Oprah ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>259</th>\n",
       "      <td>8.1</td>\n",
       "      <td>The Help</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Drama</td>\n",
       "      <td>146</td>\n",
       "      <td>[u'Emma Stone', u'Viola Davis', u'Octavia Spen...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>538</th>\n",
       "      <td>7.8</td>\n",
       "      <td>The White Ribbon</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>144</td>\n",
       "      <td>[u'Christian Friedel', u'Ernst Jacobi', u'Leon...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>262</th>\n",
       "      <td>8.1</td>\n",
       "      <td>The Hustler</td>\n",
       "      <td>UNRATED</td>\n",
       "      <td>Drama</td>\n",
       "      <td>134</td>\n",
       "      <td>[u'Paul Newman', u'Jackie Gleason', u'Piper La...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>267</th>\n",
       "      <td>8.1</td>\n",
       "      <td>Jaws</td>\n",
       "      <td>PG</td>\n",
       "      <td>Drama</td>\n",
       "      <td>124</td>\n",
       "      <td>[u'Roy Scheider', u'Robert Shaw', u'Richard Dr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>269</th>\n",
       "      <td>8.1</td>\n",
       "      <td>Rocky</td>\n",
       "      <td>PG</td>\n",
       "      <td>Drama</td>\n",
       "      <td>119</td>\n",
       "      <td>[u'Sylvester Stallone', u'Talia Shire', u'Burt...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>270</th>\n",
       "      <td>8.1</td>\n",
       "      <td>Wings of Desire</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Drama</td>\n",
       "      <td>128</td>\n",
       "      <td>[u'Bruno Ganz', u'Solveig Dommartin', u'Otto S...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>530</th>\n",
       "      <td>7.8</td>\n",
       "      <td>Atonement</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>123</td>\n",
       "      <td>[u'Keira Knightley', u'James McAvoy', u'Brenda...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>250</th>\n",
       "      <td>8.1</td>\n",
       "      <td>In the Mood for Love</td>\n",
       "      <td>PG</td>\n",
       "      <td>Drama</td>\n",
       "      <td>98</td>\n",
       "      <td>[u'Tony Chiu Wai Leung', u'Maggie Cheung', u'P...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223</th>\n",
       "      <td>8.1</td>\n",
       "      <td>Paris, Texas</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>147</td>\n",
       "      <td>[u'Harry Dean Stanton', u'Nastassja Kinski', u...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>247</th>\n",
       "      <td>8.1</td>\n",
       "      <td>Three Colors: Red</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>99</td>\n",
       "      <td>[u'Ir\\xe8ne Jacob', u'Jean-Louis Trintignant',...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>242</th>\n",
       "      <td>8.1</td>\n",
       "      <td>The Celebration</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>105</td>\n",
       "      <td>[u'Ulrich Thomsen', u'Henning Moritzen', u'Tho...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>609</th>\n",
       "      <td>7.7</td>\n",
       "      <td>Frost/Nixon</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>122</td>\n",
       "      <td>[u'Frank Langella', u'Michael Sheen', u'Kevin ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>606</th>\n",
       "      <td>7.7</td>\n",
       "      <td>Black Hawk Down</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>144</td>\n",
       "      <td>[u'Josh Hartnett', u'Ewan McGregor', u'Tom Siz...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>604</th>\n",
       "      <td>7.7</td>\n",
       "      <td>Mysterious Skin</td>\n",
       "      <td>NC-17</td>\n",
       "      <td>Drama</td>\n",
       "      <td>105</td>\n",
       "      <td>[u'Brady Corbet', u'Joseph Gordon-Levitt', u'E...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603</th>\n",
       "      <td>7.7</td>\n",
       "      <td>A Very Long Engagement</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>133</td>\n",
       "      <td>[u'Audrey Tautou', u'Gaspard Ulliel', u'Jodie ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600</th>\n",
       "      <td>7.7</td>\n",
       "      <td>Barton Fink</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>116</td>\n",
       "      <td>[u'John Turturro', u'John Goodman', u'Judy Dav...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>227</th>\n",
       "      <td>8.1</td>\n",
       "      <td>Million Dollar Baby</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Drama</td>\n",
       "      <td>132</td>\n",
       "      <td>[u'Hilary Swank', u'Clint Eastwood', u'Morgan ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>228</th>\n",
       "      <td>8.1</td>\n",
       "      <td>The Last Picture Show</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>118</td>\n",
       "      <td>[u'Timothy Bottoms', u'Jeff Bridges', u'Cybill...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>594</th>\n",
       "      <td>7.7</td>\n",
       "      <td>Dead Man</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>121</td>\n",
       "      <td>[u'Johnny Depp', u'Gary Farmer', u'Crispin Glo...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>592</th>\n",
       "      <td>7.7</td>\n",
       "      <td>Detachment</td>\n",
       "      <td>NOT RATED</td>\n",
       "      <td>Drama</td>\n",
       "      <td>98</td>\n",
       "      <td>[u'Adrien Brody', u'Christina Hendricks', u'Ma...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>589</th>\n",
       "      <td>7.7</td>\n",
       "      <td>The Machinist</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>101</td>\n",
       "      <td>[u'Christian Bale', u'Jennifer Jason Leigh', u...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>230</th>\n",
       "      <td>8.1</td>\n",
       "      <td>Cat on a Hot Tin Roof</td>\n",
       "      <td>APPROVED</td>\n",
       "      <td>Drama</td>\n",
       "      <td>108</td>\n",
       "      <td>[u'Elizabeth Taylor', u'Paul Newman', u'Burl I...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>232</th>\n",
       "      <td>8.1</td>\n",
       "      <td>Chungking Express</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Drama</td>\n",
       "      <td>98</td>\n",
       "      <td>[u'Brigitte Lin', u'Takeshi Kaneshiro', u'Tony...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>575</th>\n",
       "      <td>7.8</td>\n",
       "      <td>Kramer vs. Kramer</td>\n",
       "      <td>APPROVED</td>\n",
       "      <td>Drama</td>\n",
       "      <td>105</td>\n",
       "      <td>[u'Dustin Hoffman', u'Meryl Streep', u'Jane Al...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>237</th>\n",
       "      <td>8.1</td>\n",
       "      <td>Notorious</td>\n",
       "      <td>APPROVED</td>\n",
       "      <td>Drama</td>\n",
       "      <td>101</td>\n",
       "      <td>[u'Cary Grant', u'Ingrid Bergman', u'Claude Ra...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238</th>\n",
       "      <td>8.1</td>\n",
       "      <td>Before Sunrise</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>105</td>\n",
       "      <td>[u'Ethan Hawke', u'Julie Delpy', u'Andrea Ecke...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243</th>\n",
       "      <td>8.1</td>\n",
       "      <td>Spring, Summer, Fall, Winter... and Spring</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>103</td>\n",
       "      <td>[u'Ki-duk Kim', u'Yeong-su Oh', u'Jong-ho Kim']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>477</th>\n",
       "      <td>7.8</td>\n",
       "      <td>Amour</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Drama</td>\n",
       "      <td>127</td>\n",
       "      <td>[u'Jean-Louis Trintignant', u'Emmanuelle Riva'...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>538 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     star_rating                                         title content_rating  \\\n",
       "684          7.7                                  The Big Blue          PG-13   \n",
       "649          7.7                             Where Eagles Dare            NaN   \n",
       "633          7.7                                  The Warriors              R   \n",
       "623          7.7                Dawn of the Planet of the Apes          PG-13   \n",
       "619          7.7                              Forbidden Planet         PASSED   \n",
       "613          7.7                              The Last Samurai              R   \n",
       "610          7.7                              Enter the Dragon              R   \n",
       "598          7.7                                      Kick-Ass              R   \n",
       "591          7.7                     The Count of Monte Cristo          PG-13   \n",
       "586          7.7               Star Trek II: The Wrath of Khan             PG   \n",
       "581          7.8                                   Man on Fire              R   \n",
       "235          8.1                                       Yip Man              R   \n",
       "573          7.8                                 Battle Royale      NOT RATED   \n",
       "239          8.1                 Elite Squad: The Enemy Within        UNRATED   \n",
       "240          8.1                          The Bourne Ultimatum          PG-13   \n",
       "570          7.8                                           300              R   \n",
       "568          7.8                                       Skyfall          PG-13   \n",
       "567          7.8                          The Bourne Supremacy          PG-13   \n",
       "653          7.7                                      Fearless          PG-13   \n",
       "248          8.1                    X-Men: Days of Future Past          PG-13   \n",
       "661          7.7  Star Wars: Episode III - Revenge of the Sith          PG-13   \n",
       "198          8.1                             Kill Bill: Vol. 1              R   \n",
       "729          7.6                                      The Crow              R   \n",
       "726          7.6                               Sherlock Holmes          PG-13   \n",
       "163          8.2                                          Rush              R   \n",
       "722          7.6                                 Lethal Weapon              R   \n",
       "717          7.6                  The Legend of Drunken Master              R   \n",
       "707          7.6                                      Watchmen              R   \n",
       "173          8.2            Tae Guk Gi: The Brotherhood of War              R   \n",
       "701          7.6                                     United 93              R   \n",
       "..           ...                                           ...            ...   \n",
       "543          7.8                           Lost in Translation              R   \n",
       "540          7.8                              The Color Purple          PG-13   \n",
       "259          8.1                                      The Help          PG-13   \n",
       "538          7.8                              The White Ribbon              R   \n",
       "262          8.1                                   The Hustler        UNRATED   \n",
       "267          8.1                                          Jaws             PG   \n",
       "269          8.1                                         Rocky             PG   \n",
       "270          8.1                               Wings of Desire          PG-13   \n",
       "530          7.8                                     Atonement              R   \n",
       "250          8.1                          In the Mood for Love             PG   \n",
       "223          8.1                                  Paris, Texas              R   \n",
       "247          8.1                             Three Colors: Red              R   \n",
       "242          8.1                               The Celebration              R   \n",
       "609          7.7                                   Frost/Nixon              R   \n",
       "606          7.7                               Black Hawk Down              R   \n",
       "604          7.7                               Mysterious Skin          NC-17   \n",
       "603          7.7                        A Very Long Engagement              R   \n",
       "600          7.7                                   Barton Fink              R   \n",
       "227          8.1                           Million Dollar Baby          PG-13   \n",
       "228          8.1                         The Last Picture Show              R   \n",
       "594          7.7                                      Dead Man              R   \n",
       "592          7.7                                    Detachment      NOT RATED   \n",
       "589          7.7                                 The Machinist              R   \n",
       "230          8.1                         Cat on a Hot Tin Roof       APPROVED   \n",
       "232          8.1                             Chungking Express          PG-13   \n",
       "575          7.8                             Kramer vs. Kramer       APPROVED   \n",
       "237          8.1                                     Notorious       APPROVED   \n",
       "238          8.1                                Before Sunrise              R   \n",
       "243          8.1    Spring, Summer, Fall, Winter... and Spring              R   \n",
       "477          7.8                                         Amour          PG-13   \n",
       "\n",
       "      genre  duration                                        actors_list  \n",
       "684  Action       168  [u'Jean-Marc Barr', u'Jean Reno', u'Rosanna Ar...  \n",
       "649  Action       158  [u'Richard Burton', u'Clint Eastwood', u'Mary ...  \n",
       "633  Action        92  [u'Michael Beck', u'James Remar', u'Dorsey Wri...  \n",
       "623  Action       130  [u'Gary Oldman', u'Keri Russell', u'Andy Serkis']  \n",
       "619  Action        98  [u'Walter Pidgeon', u'Anne Francis', u'Leslie ...  \n",
       "613  Action       154  [u'Tom Cruise', u'Ken Watanabe', u'Billy Conno...  \n",
       "610  Action       102        [u'Bruce Lee', u'John Saxon', u'Jim Kelly']  \n",
       "598  Action       117  [u'Aaron Taylor-Johnson', u'Nicolas Cage', u'C...  \n",
       "591  Action       131  [u'Jim Caviezel', u'Guy Pearce', u'Richard Har...  \n",
       "586  Action       113  [u'William Shatner', u'Leonard Nimoy', u'DeFor...  \n",
       "581  Action       146  [u'Denzel Washington', u'Christopher Walken', ...  \n",
       "235  Action       106     [u'Donnie Yen', u'Simon Yam', u'Siu-Wong Fan']  \n",
       "573  Action       114  [u'Tatsuya Fujiwara', u'Aki Maeda', u'Tar\\xf4 ...  \n",
       "239  Action       115  [u'Wagner Moura', u'Irandhir Santos', u'Andr\\x...  \n",
       "240  Action       115  [u'Matt Damon', u'\\xc9dgar Ram\\xedrez', u'Joan...  \n",
       "570  Action       117  [u'Gerard Butler', u'Lena Headey', u'David Wen...  \n",
       "568  Action       143  [u'Daniel Craig', u'Javier Bardem', u'Naomie H...  \n",
       "567  Action       108  [u'Matt Damon', u'Franka Potente', u'Joan Allen']  \n",
       "653  Action       104               [u'Jet Li', u'Li Sun', u'Yong Dong']  \n",
       "248  Action       131  [u'Patrick Stewart', u'Ian McKellen', u'Hugh J...  \n",
       "661  Action       140  [u'Hayden Christensen', u'Natalie Portman', u'...  \n",
       "198  Action       111  [u'Uma Thurman', u'David Carradine', u'Daryl H...  \n",
       "729  Action       102  [u'Brandon Lee', u'Michael Wincott', u'Rochell...  \n",
       "726  Action       128  [u'Robert Downey Jr.', u'Jude Law', u'Rachel M...  \n",
       "163  Action       123  [u'Daniel Br\\xfchl', u'Chris Hemsworth', u'Oli...  \n",
       "722  Action       110    [u'Mel Gibson', u'Danny Glover', u'Gary Busey']  \n",
       "717  Action       102       [u'Jackie Chan', u'Ho-Sung Pak', u'Lung Ti']  \n",
       "707  Action       162  [u'Jackie Earle Haley', u'Patrick Wilson', u'C...  \n",
       "173  Action       140      [u'Dong-gun Jang', u'Bin Won', u'Eun-ju Lee']  \n",
       "701  Action       111  [u'David Alan Basche', u'Olivia Thirlby', u'Li...  \n",
       "..      ...       ...                                                ...  \n",
       "543   Drama       101  [u'Bill Murray', u'Scarlett Johansson', u'Giov...  \n",
       "540   Drama       154  [u'Danny Glover', u'Whoopi Goldberg', u'Oprah ...  \n",
       "259   Drama       146  [u'Emma Stone', u'Viola Davis', u'Octavia Spen...  \n",
       "538   Drama       144  [u'Christian Friedel', u'Ernst Jacobi', u'Leon...  \n",
       "262   Drama       134  [u'Paul Newman', u'Jackie Gleason', u'Piper La...  \n",
       "267   Drama       124  [u'Roy Scheider', u'Robert Shaw', u'Richard Dr...  \n",
       "269   Drama       119  [u'Sylvester Stallone', u'Talia Shire', u'Burt...  \n",
       "270   Drama       128  [u'Bruno Ganz', u'Solveig Dommartin', u'Otto S...  \n",
       "530   Drama       123  [u'Keira Knightley', u'James McAvoy', u'Brenda...  \n",
       "250   Drama        98  [u'Tony Chiu Wai Leung', u'Maggie Cheung', u'P...  \n",
       "223   Drama       147  [u'Harry Dean Stanton', u'Nastassja Kinski', u...  \n",
       "247   Drama        99  [u'Ir\\xe8ne Jacob', u'Jean-Louis Trintignant',...  \n",
       "242   Drama       105  [u'Ulrich Thomsen', u'Henning Moritzen', u'Tho...  \n",
       "609   Drama       122  [u'Frank Langella', u'Michael Sheen', u'Kevin ...  \n",
       "606   Drama       144  [u'Josh Hartnett', u'Ewan McGregor', u'Tom Siz...  \n",
       "604   Drama       105  [u'Brady Corbet', u'Joseph Gordon-Levitt', u'E...  \n",
       "603   Drama       133  [u'Audrey Tautou', u'Gaspard Ulliel', u'Jodie ...  \n",
       "600   Drama       116  [u'John Turturro', u'John Goodman', u'Judy Dav...  \n",
       "227   Drama       132  [u'Hilary Swank', u'Clint Eastwood', u'Morgan ...  \n",
       "228   Drama       118  [u'Timothy Bottoms', u'Jeff Bridges', u'Cybill...  \n",
       "594   Drama       121  [u'Johnny Depp', u'Gary Farmer', u'Crispin Glo...  \n",
       "592   Drama        98  [u'Adrien Brody', u'Christina Hendricks', u'Ma...  \n",
       "589   Drama       101  [u'Christian Bale', u'Jennifer Jason Leigh', u...  \n",
       "230   Drama       108  [u'Elizabeth Taylor', u'Paul Newman', u'Burl I...  \n",
       "232   Drama        98  [u'Brigitte Lin', u'Takeshi Kaneshiro', u'Tony...  \n",
       "575   Drama       105  [u'Dustin Hoffman', u'Meryl Streep', u'Jane Al...  \n",
       "237   Drama       101  [u'Cary Grant', u'Ingrid Bergman', u'Claude Ra...  \n",
       "238   Drama       105  [u'Ethan Hawke', u'Julie Delpy', u'Andrea Ecke...  \n",
       "243   Drama       103    [u'Ki-duk Kim', u'Yeong-su Oh', u'Jong-ho Kim']  \n",
       "477   Drama       127  [u'Jean-Louis Trintignant', u'Emmanuelle Riva'...  \n",
       "\n",
       "[538 rows x 6 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies[(movies.genre == \"Drama\") | (movies.genre == \"Crime\") | (movies.genre == \"Action\")].sort_values(\"genre\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>star_rating</th>\n",
       "      <th>title</th>\n",
       "      <th>content_rating</th>\n",
       "      <th>genre</th>\n",
       "      <th>duration</th>\n",
       "      <th>actors_list</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>684</th>\n",
       "      <td>7.7</td>\n",
       "      <td>The Big Blue</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Action</td>\n",
       "      <td>168</td>\n",
       "      <td>[u'Jean-Marc Barr', u'Jean Reno', u'Rosanna Ar...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>649</th>\n",
       "      <td>7.7</td>\n",
       "      <td>Where Eagles Dare</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Action</td>\n",
       "      <td>158</td>\n",
       "      <td>[u'Richard Burton', u'Clint Eastwood', u'Mary ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>633</th>\n",
       "      <td>7.7</td>\n",
       "      <td>The Warriors</td>\n",
       "      <td>R</td>\n",
       "      <td>Action</td>\n",
       "      <td>92</td>\n",
       "      <td>[u'Michael Beck', u'James Remar', u'Dorsey Wri...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>623</th>\n",
       "      <td>7.7</td>\n",
       "      <td>Dawn of the Planet of the Apes</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Action</td>\n",
       "      <td>130</td>\n",
       "      <td>[u'Gary Oldman', u'Keri Russell', u'Andy Serkis']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>619</th>\n",
       "      <td>7.7</td>\n",
       "      <td>Forbidden Planet</td>\n",
       "      <td>PASSED</td>\n",
       "      <td>Action</td>\n",
       "      <td>98</td>\n",
       "      <td>[u'Walter Pidgeon', u'Anne Francis', u'Leslie ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>613</th>\n",
       "      <td>7.7</td>\n",
       "      <td>The Last Samurai</td>\n",
       "      <td>R</td>\n",
       "      <td>Action</td>\n",
       "      <td>154</td>\n",
       "      <td>[u'Tom Cruise', u'Ken Watanabe', u'Billy Conno...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>610</th>\n",
       "      <td>7.7</td>\n",
       "      <td>Enter the Dragon</td>\n",
       "      <td>R</td>\n",
       "      <td>Action</td>\n",
       "      <td>102</td>\n",
       "      <td>[u'Bruce Lee', u'John Saxon', u'Jim Kelly']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>598</th>\n",
       "      <td>7.7</td>\n",
       "      <td>Kick-Ass</td>\n",
       "      <td>R</td>\n",
       "      <td>Action</td>\n",
       "      <td>117</td>\n",
       "      <td>[u'Aaron Taylor-Johnson', u'Nicolas Cage', u'C...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>591</th>\n",
       "      <td>7.7</td>\n",
       "      <td>The Count of Monte Cristo</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Action</td>\n",
       "      <td>131</td>\n",
       "      <td>[u'Jim Caviezel', u'Guy Pearce', u'Richard Har...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>586</th>\n",
       "      <td>7.7</td>\n",
       "      <td>Star Trek II: The Wrath of Khan</td>\n",
       "      <td>PG</td>\n",
       "      <td>Action</td>\n",
       "      <td>113</td>\n",
       "      <td>[u'William Shatner', u'Leonard Nimoy', u'DeFor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>581</th>\n",
       "      <td>7.8</td>\n",
       "      <td>Man on Fire</td>\n",
       "      <td>R</td>\n",
       "      <td>Action</td>\n",
       "      <td>146</td>\n",
       "      <td>[u'Denzel Washington', u'Christopher Walken', ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>235</th>\n",
       "      <td>8.1</td>\n",
       "      <td>Yip Man</td>\n",
       "      <td>R</td>\n",
       "      <td>Action</td>\n",
       "      <td>106</td>\n",
       "      <td>[u'Donnie Yen', u'Simon Yam', u'Siu-Wong Fan']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>573</th>\n",
       "      <td>7.8</td>\n",
       "      <td>Battle Royale</td>\n",
       "      <td>NOT RATED</td>\n",
       "      <td>Action</td>\n",
       "      <td>114</td>\n",
       "      <td>[u'Tatsuya Fujiwara', u'Aki Maeda', u'Tar\\xf4 ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239</th>\n",
       "      <td>8.1</td>\n",
       "      <td>Elite Squad: The Enemy Within</td>\n",
       "      <td>UNRATED</td>\n",
       "      <td>Action</td>\n",
       "      <td>115</td>\n",
       "      <td>[u'Wagner Moura', u'Irandhir Santos', u'Andr\\x...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>240</th>\n",
       "      <td>8.1</td>\n",
       "      <td>The Bourne Ultimatum</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Action</td>\n",
       "      <td>115</td>\n",
       "      <td>[u'Matt Damon', u'\\xc9dgar Ram\\xedrez', u'Joan...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>570</th>\n",
       "      <td>7.8</td>\n",
       "      <td>300</td>\n",
       "      <td>R</td>\n",
       "      <td>Action</td>\n",
       "      <td>117</td>\n",
       "      <td>[u'Gerard Butler', u'Lena Headey', u'David Wen...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>568</th>\n",
       "      <td>7.8</td>\n",
       "      <td>Skyfall</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Action</td>\n",
       "      <td>143</td>\n",
       "      <td>[u'Daniel Craig', u'Javier Bardem', u'Naomie H...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>567</th>\n",
       "      <td>7.8</td>\n",
       "      <td>The Bourne Supremacy</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Action</td>\n",
       "      <td>108</td>\n",
       "      <td>[u'Matt Damon', u'Franka Potente', u'Joan Allen']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>653</th>\n",
       "      <td>7.7</td>\n",
       "      <td>Fearless</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Action</td>\n",
       "      <td>104</td>\n",
       "      <td>[u'Jet Li', u'Li Sun', u'Yong Dong']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>248</th>\n",
       "      <td>8.1</td>\n",
       "      <td>X-Men: Days of Future Past</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Action</td>\n",
       "      <td>131</td>\n",
       "      <td>[u'Patrick Stewart', u'Ian McKellen', u'Hugh J...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>661</th>\n",
       "      <td>7.7</td>\n",
       "      <td>Star Wars: Episode III - Revenge of the Sith</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Action</td>\n",
       "      <td>140</td>\n",
       "      <td>[u'Hayden Christensen', u'Natalie Portman', u'...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>8.1</td>\n",
       "      <td>Kill Bill: Vol. 1</td>\n",
       "      <td>R</td>\n",
       "      <td>Action</td>\n",
       "      <td>111</td>\n",
       "      <td>[u'Uma Thurman', u'David Carradine', u'Daryl H...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>729</th>\n",
       "      <td>7.6</td>\n",
       "      <td>The Crow</td>\n",
       "      <td>R</td>\n",
       "      <td>Action</td>\n",
       "      <td>102</td>\n",
       "      <td>[u'Brandon Lee', u'Michael Wincott', u'Rochell...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>726</th>\n",
       "      <td>7.6</td>\n",
       "      <td>Sherlock Holmes</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Action</td>\n",
       "      <td>128</td>\n",
       "      <td>[u'Robert Downey Jr.', u'Jude Law', u'Rachel M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>8.2</td>\n",
       "      <td>Rush</td>\n",
       "      <td>R</td>\n",
       "      <td>Action</td>\n",
       "      <td>123</td>\n",
       "      <td>[u'Daniel Br\\xfchl', u'Chris Hemsworth', u'Oli...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>722</th>\n",
       "      <td>7.6</td>\n",
       "      <td>Lethal Weapon</td>\n",
       "      <td>R</td>\n",
       "      <td>Action</td>\n",
       "      <td>110</td>\n",
       "      <td>[u'Mel Gibson', u'Danny Glover', u'Gary Busey']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>717</th>\n",
       "      <td>7.6</td>\n",
       "      <td>The Legend of Drunken Master</td>\n",
       "      <td>R</td>\n",
       "      <td>Action</td>\n",
       "      <td>102</td>\n",
       "      <td>[u'Jackie Chan', u'Ho-Sung Pak', u'Lung Ti']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>707</th>\n",
       "      <td>7.6</td>\n",
       "      <td>Watchmen</td>\n",
       "      <td>R</td>\n",
       "      <td>Action</td>\n",
       "      <td>162</td>\n",
       "      <td>[u'Jackie Earle Haley', u'Patrick Wilson', u'C...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>8.2</td>\n",
       "      <td>Tae Guk Gi: The Brotherhood of War</td>\n",
       "      <td>R</td>\n",
       "      <td>Action</td>\n",
       "      <td>140</td>\n",
       "      <td>[u'Dong-gun Jang', u'Bin Won', u'Eun-ju Lee']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>701</th>\n",
       "      <td>7.6</td>\n",
       "      <td>United 93</td>\n",
       "      <td>R</td>\n",
       "      <td>Action</td>\n",
       "      <td>111</td>\n",
       "      <td>[u'David Alan Basche', u'Olivia Thirlby', u'Li...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>543</th>\n",
       "      <td>7.8</td>\n",
       "      <td>Lost in Translation</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>101</td>\n",
       "      <td>[u'Bill Murray', u'Scarlett Johansson', u'Giov...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>540</th>\n",
       "      <td>7.8</td>\n",
       "      <td>The Color Purple</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Drama</td>\n",
       "      <td>154</td>\n",
       "      <td>[u'Danny Glover', u'Whoopi Goldberg', u'Oprah ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>259</th>\n",
       "      <td>8.1</td>\n",
       "      <td>The Help</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Drama</td>\n",
       "      <td>146</td>\n",
       "      <td>[u'Emma Stone', u'Viola Davis', u'Octavia Spen...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>538</th>\n",
       "      <td>7.8</td>\n",
       "      <td>The White Ribbon</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>144</td>\n",
       "      <td>[u'Christian Friedel', u'Ernst Jacobi', u'Leon...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>262</th>\n",
       "      <td>8.1</td>\n",
       "      <td>The Hustler</td>\n",
       "      <td>UNRATED</td>\n",
       "      <td>Drama</td>\n",
       "      <td>134</td>\n",
       "      <td>[u'Paul Newman', u'Jackie Gleason', u'Piper La...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>267</th>\n",
       "      <td>8.1</td>\n",
       "      <td>Jaws</td>\n",
       "      <td>PG</td>\n",
       "      <td>Drama</td>\n",
       "      <td>124</td>\n",
       "      <td>[u'Roy Scheider', u'Robert Shaw', u'Richard Dr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>269</th>\n",
       "      <td>8.1</td>\n",
       "      <td>Rocky</td>\n",
       "      <td>PG</td>\n",
       "      <td>Drama</td>\n",
       "      <td>119</td>\n",
       "      <td>[u'Sylvester Stallone', u'Talia Shire', u'Burt...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>270</th>\n",
       "      <td>8.1</td>\n",
       "      <td>Wings of Desire</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Drama</td>\n",
       "      <td>128</td>\n",
       "      <td>[u'Bruno Ganz', u'Solveig Dommartin', u'Otto S...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>530</th>\n",
       "      <td>7.8</td>\n",
       "      <td>Atonement</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>123</td>\n",
       "      <td>[u'Keira Knightley', u'James McAvoy', u'Brenda...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>250</th>\n",
       "      <td>8.1</td>\n",
       "      <td>In the Mood for Love</td>\n",
       "      <td>PG</td>\n",
       "      <td>Drama</td>\n",
       "      <td>98</td>\n",
       "      <td>[u'Tony Chiu Wai Leung', u'Maggie Cheung', u'P...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223</th>\n",
       "      <td>8.1</td>\n",
       "      <td>Paris, Texas</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>147</td>\n",
       "      <td>[u'Harry Dean Stanton', u'Nastassja Kinski', u...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>247</th>\n",
       "      <td>8.1</td>\n",
       "      <td>Three Colors: Red</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>99</td>\n",
       "      <td>[u'Ir\\xe8ne Jacob', u'Jean-Louis Trintignant',...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>242</th>\n",
       "      <td>8.1</td>\n",
       "      <td>The Celebration</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>105</td>\n",
       "      <td>[u'Ulrich Thomsen', u'Henning Moritzen', u'Tho...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>609</th>\n",
       "      <td>7.7</td>\n",
       "      <td>Frost/Nixon</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>122</td>\n",
       "      <td>[u'Frank Langella', u'Michael Sheen', u'Kevin ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>606</th>\n",
       "      <td>7.7</td>\n",
       "      <td>Black Hawk Down</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>144</td>\n",
       "      <td>[u'Josh Hartnett', u'Ewan McGregor', u'Tom Siz...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>604</th>\n",
       "      <td>7.7</td>\n",
       "      <td>Mysterious Skin</td>\n",
       "      <td>NC-17</td>\n",
       "      <td>Drama</td>\n",
       "      <td>105</td>\n",
       "      <td>[u'Brady Corbet', u'Joseph Gordon-Levitt', u'E...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603</th>\n",
       "      <td>7.7</td>\n",
       "      <td>A Very Long Engagement</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>133</td>\n",
       "      <td>[u'Audrey Tautou', u'Gaspard Ulliel', u'Jodie ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600</th>\n",
       "      <td>7.7</td>\n",
       "      <td>Barton Fink</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>116</td>\n",
       "      <td>[u'John Turturro', u'John Goodman', u'Judy Dav...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>227</th>\n",
       "      <td>8.1</td>\n",
       "      <td>Million Dollar Baby</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Drama</td>\n",
       "      <td>132</td>\n",
       "      <td>[u'Hilary Swank', u'Clint Eastwood', u'Morgan ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>228</th>\n",
       "      <td>8.1</td>\n",
       "      <td>The Last Picture Show</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>118</td>\n",
       "      <td>[u'Timothy Bottoms', u'Jeff Bridges', u'Cybill...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>594</th>\n",
       "      <td>7.7</td>\n",
       "      <td>Dead Man</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>121</td>\n",
       "      <td>[u'Johnny Depp', u'Gary Farmer', u'Crispin Glo...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>592</th>\n",
       "      <td>7.7</td>\n",
       "      <td>Detachment</td>\n",
       "      <td>NOT RATED</td>\n",
       "      <td>Drama</td>\n",
       "      <td>98</td>\n",
       "      <td>[u'Adrien Brody', u'Christina Hendricks', u'Ma...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>589</th>\n",
       "      <td>7.7</td>\n",
       "      <td>The Machinist</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>101</td>\n",
       "      <td>[u'Christian Bale', u'Jennifer Jason Leigh', u...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>230</th>\n",
       "      <td>8.1</td>\n",
       "      <td>Cat on a Hot Tin Roof</td>\n",
       "      <td>APPROVED</td>\n",
       "      <td>Drama</td>\n",
       "      <td>108</td>\n",
       "      <td>[u'Elizabeth Taylor', u'Paul Newman', u'Burl I...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>232</th>\n",
       "      <td>8.1</td>\n",
       "      <td>Chungking Express</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Drama</td>\n",
       "      <td>98</td>\n",
       "      <td>[u'Brigitte Lin', u'Takeshi Kaneshiro', u'Tony...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>575</th>\n",
       "      <td>7.8</td>\n",
       "      <td>Kramer vs. Kramer</td>\n",
       "      <td>APPROVED</td>\n",
       "      <td>Drama</td>\n",
       "      <td>105</td>\n",
       "      <td>[u'Dustin Hoffman', u'Meryl Streep', u'Jane Al...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>237</th>\n",
       "      <td>8.1</td>\n",
       "      <td>Notorious</td>\n",
       "      <td>APPROVED</td>\n",
       "      <td>Drama</td>\n",
       "      <td>101</td>\n",
       "      <td>[u'Cary Grant', u'Ingrid Bergman', u'Claude Ra...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238</th>\n",
       "      <td>8.1</td>\n",
       "      <td>Before Sunrise</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>105</td>\n",
       "      <td>[u'Ethan Hawke', u'Julie Delpy', u'Andrea Ecke...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243</th>\n",
       "      <td>8.1</td>\n",
       "      <td>Spring, Summer, Fall, Winter... and Spring</td>\n",
       "      <td>R</td>\n",
       "      <td>Drama</td>\n",
       "      <td>103</td>\n",
       "      <td>[u'Ki-duk Kim', u'Yeong-su Oh', u'Jong-ho Kim']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>477</th>\n",
       "      <td>7.8</td>\n",
       "      <td>Amour</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>Drama</td>\n",
       "      <td>127</td>\n",
       "      <td>[u'Jean-Louis Trintignant', u'Emmanuelle Riva'...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>538 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     star_rating                                         title content_rating  \\\n",
       "684          7.7                                  The Big Blue          PG-13   \n",
       "649          7.7                             Where Eagles Dare            NaN   \n",
       "633          7.7                                  The Warriors              R   \n",
       "623          7.7                Dawn of the Planet of the Apes          PG-13   \n",
       "619          7.7                              Forbidden Planet         PASSED   \n",
       "613          7.7                              The Last Samurai              R   \n",
       "610          7.7                              Enter the Dragon              R   \n",
       "598          7.7                                      Kick-Ass              R   \n",
       "591          7.7                     The Count of Monte Cristo          PG-13   \n",
       "586          7.7               Star Trek II: The Wrath of Khan             PG   \n",
       "581          7.8                                   Man on Fire              R   \n",
       "235          8.1                                       Yip Man              R   \n",
       "573          7.8                                 Battle Royale      NOT RATED   \n",
       "239          8.1                 Elite Squad: The Enemy Within        UNRATED   \n",
       "240          8.1                          The Bourne Ultimatum          PG-13   \n",
       "570          7.8                                           300              R   \n",
       "568          7.8                                       Skyfall          PG-13   \n",
       "567          7.8                          The Bourne Supremacy          PG-13   \n",
       "653          7.7                                      Fearless          PG-13   \n",
       "248          8.1                    X-Men: Days of Future Past          PG-13   \n",
       "661          7.7  Star Wars: Episode III - Revenge of the Sith          PG-13   \n",
       "198          8.1                             Kill Bill: Vol. 1              R   \n",
       "729          7.6                                      The Crow              R   \n",
       "726          7.6                               Sherlock Holmes          PG-13   \n",
       "163          8.2                                          Rush              R   \n",
       "722          7.6                                 Lethal Weapon              R   \n",
       "717          7.6                  The Legend of Drunken Master              R   \n",
       "707          7.6                                      Watchmen              R   \n",
       "173          8.2            Tae Guk Gi: The Brotherhood of War              R   \n",
       "701          7.6                                     United 93              R   \n",
       "..           ...                                           ...            ...   \n",
       "543          7.8                           Lost in Translation              R   \n",
       "540          7.8                              The Color Purple          PG-13   \n",
       "259          8.1                                      The Help          PG-13   \n",
       "538          7.8                              The White Ribbon              R   \n",
       "262          8.1                                   The Hustler        UNRATED   \n",
       "267          8.1                                          Jaws             PG   \n",
       "269          8.1                                         Rocky             PG   \n",
       "270          8.1                               Wings of Desire          PG-13   \n",
       "530          7.8                                     Atonement              R   \n",
       "250          8.1                          In the Mood for Love             PG   \n",
       "223          8.1                                  Paris, Texas              R   \n",
       "247          8.1                             Three Colors: Red              R   \n",
       "242          8.1                               The Celebration              R   \n",
       "609          7.7                                   Frost/Nixon              R   \n",
       "606          7.7                               Black Hawk Down              R   \n",
       "604          7.7                               Mysterious Skin          NC-17   \n",
       "603          7.7                        A Very Long Engagement              R   \n",
       "600          7.7                                   Barton Fink              R   \n",
       "227          8.1                           Million Dollar Baby          PG-13   \n",
       "228          8.1                         The Last Picture Show              R   \n",
       "594          7.7                                      Dead Man              R   \n",
       "592          7.7                                    Detachment      NOT RATED   \n",
       "589          7.7                                 The Machinist              R   \n",
       "230          8.1                         Cat on a Hot Tin Roof       APPROVED   \n",
       "232          8.1                             Chungking Express          PG-13   \n",
       "575          7.8                             Kramer vs. Kramer       APPROVED   \n",
       "237          8.1                                     Notorious       APPROVED   \n",
       "238          8.1                                Before Sunrise              R   \n",
       "243          8.1    Spring, Summer, Fall, Winter... and Spring              R   \n",
       "477          7.8                                         Amour          PG-13   \n",
       "\n",
       "      genre  duration                                        actors_list  \n",
       "684  Action       168  [u'Jean-Marc Barr', u'Jean Reno', u'Rosanna Ar...  \n",
       "649  Action       158  [u'Richard Burton', u'Clint Eastwood', u'Mary ...  \n",
       "633  Action        92  [u'Michael Beck', u'James Remar', u'Dorsey Wri...  \n",
       "623  Action       130  [u'Gary Oldman', u'Keri Russell', u'Andy Serkis']  \n",
       "619  Action        98  [u'Walter Pidgeon', u'Anne Francis', u'Leslie ...  \n",
       "613  Action       154  [u'Tom Cruise', u'Ken Watanabe', u'Billy Conno...  \n",
       "610  Action       102        [u'Bruce Lee', u'John Saxon', u'Jim Kelly']  \n",
       "598  Action       117  [u'Aaron Taylor-Johnson', u'Nicolas Cage', u'C...  \n",
       "591  Action       131  [u'Jim Caviezel', u'Guy Pearce', u'Richard Har...  \n",
       "586  Action       113  [u'William Shatner', u'Leonard Nimoy', u'DeFor...  \n",
       "581  Action       146  [u'Denzel Washington', u'Christopher Walken', ...  \n",
       "235  Action       106     [u'Donnie Yen', u'Simon Yam', u'Siu-Wong Fan']  \n",
       "573  Action       114  [u'Tatsuya Fujiwara', u'Aki Maeda', u'Tar\\xf4 ...  \n",
       "239  Action       115  [u'Wagner Moura', u'Irandhir Santos', u'Andr\\x...  \n",
       "240  Action       115  [u'Matt Damon', u'\\xc9dgar Ram\\xedrez', u'Joan...  \n",
       "570  Action       117  [u'Gerard Butler', u'Lena Headey', u'David Wen...  \n",
       "568  Action       143  [u'Daniel Craig', u'Javier Bardem', u'Naomie H...  \n",
       "567  Action       108  [u'Matt Damon', u'Franka Potente', u'Joan Allen']  \n",
       "653  Action       104               [u'Jet Li', u'Li Sun', u'Yong Dong']  \n",
       "248  Action       131  [u'Patrick Stewart', u'Ian McKellen', u'Hugh J...  \n",
       "661  Action       140  [u'Hayden Christensen', u'Natalie Portman', u'...  \n",
       "198  Action       111  [u'Uma Thurman', u'David Carradine', u'Daryl H...  \n",
       "729  Action       102  [u'Brandon Lee', u'Michael Wincott', u'Rochell...  \n",
       "726  Action       128  [u'Robert Downey Jr.', u'Jude Law', u'Rachel M...  \n",
       "163  Action       123  [u'Daniel Br\\xfchl', u'Chris Hemsworth', u'Oli...  \n",
       "722  Action       110    [u'Mel Gibson', u'Danny Glover', u'Gary Busey']  \n",
       "717  Action       102       [u'Jackie Chan', u'Ho-Sung Pak', u'Lung Ti']  \n",
       "707  Action       162  [u'Jackie Earle Haley', u'Patrick Wilson', u'C...  \n",
       "173  Action       140      [u'Dong-gun Jang', u'Bin Won', u'Eun-ju Lee']  \n",
       "701  Action       111  [u'David Alan Basche', u'Olivia Thirlby', u'Li...  \n",
       "..      ...       ...                                                ...  \n",
       "543   Drama       101  [u'Bill Murray', u'Scarlett Johansson', u'Giov...  \n",
       "540   Drama       154  [u'Danny Glover', u'Whoopi Goldberg', u'Oprah ...  \n",
       "259   Drama       146  [u'Emma Stone', u'Viola Davis', u'Octavia Spen...  \n",
       "538   Drama       144  [u'Christian Friedel', u'Ernst Jacobi', u'Leon...  \n",
       "262   Drama       134  [u'Paul Newman', u'Jackie Gleason', u'Piper La...  \n",
       "267   Drama       124  [u'Roy Scheider', u'Robert Shaw', u'Richard Dr...  \n",
       "269   Drama       119  [u'Sylvester Stallone', u'Talia Shire', u'Burt...  \n",
       "270   Drama       128  [u'Bruno Ganz', u'Solveig Dommartin', u'Otto S...  \n",
       "530   Drama       123  [u'Keira Knightley', u'James McAvoy', u'Brenda...  \n",
       "250   Drama        98  [u'Tony Chiu Wai Leung', u'Maggie Cheung', u'P...  \n",
       "223   Drama       147  [u'Harry Dean Stanton', u'Nastassja Kinski', u...  \n",
       "247   Drama        99  [u'Ir\\xe8ne Jacob', u'Jean-Louis Trintignant',...  \n",
       "242   Drama       105  [u'Ulrich Thomsen', u'Henning Moritzen', u'Tho...  \n",
       "609   Drama       122  [u'Frank Langella', u'Michael Sheen', u'Kevin ...  \n",
       "606   Drama       144  [u'Josh Hartnett', u'Ewan McGregor', u'Tom Siz...  \n",
       "604   Drama       105  [u'Brady Corbet', u'Joseph Gordon-Levitt', u'E...  \n",
       "603   Drama       133  [u'Audrey Tautou', u'Gaspard Ulliel', u'Jodie ...  \n",
       "600   Drama       116  [u'John Turturro', u'John Goodman', u'Judy Dav...  \n",
       "227   Drama       132  [u'Hilary Swank', u'Clint Eastwood', u'Morgan ...  \n",
       "228   Drama       118  [u'Timothy Bottoms', u'Jeff Bridges', u'Cybill...  \n",
       "594   Drama       121  [u'Johnny Depp', u'Gary Farmer', u'Crispin Glo...  \n",
       "592   Drama        98  [u'Adrien Brody', u'Christina Hendricks', u'Ma...  \n",
       "589   Drama       101  [u'Christian Bale', u'Jennifer Jason Leigh', u...  \n",
       "230   Drama       108  [u'Elizabeth Taylor', u'Paul Newman', u'Burl I...  \n",
       "232   Drama        98  [u'Brigitte Lin', u'Takeshi Kaneshiro', u'Tony...  \n",
       "575   Drama       105  [u'Dustin Hoffman', u'Meryl Streep', u'Jane Al...  \n",
       "237   Drama       101  [u'Cary Grant', u'Ingrid Bergman', u'Claude Ra...  \n",
       "238   Drama       105  [u'Ethan Hawke', u'Julie Delpy', u'Andrea Ecke...  \n",
       "243   Drama       103    [u'Ki-duk Kim', u'Yeong-su Oh', u'Jong-ho Kim']  \n",
       "477   Drama       127  [u'Jean-Louis Trintignant', u'Emmanuelle Riva'...  \n",
       "\n",
       "[538 rows x 6 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies[movies.genre.isin([\"Drama\", \"Crime\", \"Action\"])].sort_values(\"genre\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}