ex_02_add.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Exercises list 02"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import seaborn as sns\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "b'Skipping line 31: expected 24 fields, saw 25\\n'\n"
     ]
    }
   ],
   "source": [
    "# Loading IMD database (skipping lines with incorrect formatting)\n",
    "df = pd.read_csv(\"http://www.ppgia.pucpr.br/~jean.barddal/datascience/movies_metadata.csv\", error_bad_lines=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 49 entries, 0 to 48\n",
      "Data columns (total 24 columns):\n",
      " #   Column                 Non-Null Count  Dtype  \n",
      "---  ------                 --------------  -----  \n",
      " 0   adult                  49 non-null     bool   \n",
      " 1   belongs_to_collection  10 non-null     object \n",
      " 2   budget                 49 non-null     int64  \n",
      " 3   genres                 49 non-null     object \n",
      " 4   homepage               5 non-null      object \n",
      " 5   id                     49 non-null     int64  \n",
      " 6   imdb_id                49 non-null     object \n",
      " 7   original_language      49 non-null     object \n",
      " 8   original_title         49 non-null     object \n",
      " 9   overview               48 non-null     object \n",
      " 10  popularity             49 non-null     float64\n",
      " 11  poster_path            49 non-null     object \n",
      " 12  production_companies   49 non-null     object \n",
      " 13  production_countries   49 non-null     object \n",
      " 14  release_date           49 non-null     object \n",
      " 15  revenue                49 non-null     int64  \n",
      " 16  runtime                49 non-null     float64\n",
      " 17  spoken_languages       49 non-null     object \n",
      " 18  status                 49 non-null     object \n",
      " 19  tagline                40 non-null     object \n",
      " 20  title                  49 non-null     object \n",
      " 21  video                  49 non-null     bool   \n",
      " 22  vote_average           49 non-null     float64\n",
      " 23  vote_count             49 non-null     int64  \n",
      "dtypes: bool(2), float64(3), int64(4), object(15)\n",
      "memory usage: 8.6+ KB\n"
     ]
    }
   ],
   "source": [
    "# Number of rows and columns\n",
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "adult                                                                False\n",
       "belongs_to_collection    {'id': 119050, 'name': 'Grumpy Old Men Collect...\n",
       "budget                                                                   0\n",
       "genres                   [{'id': 10749, 'name': 'Romance'}, {'id': 35, ...\n",
       "homepage                                                               NaN\n",
       "id                                                                   15602\n",
       "imdb_id                                                          tt0113228\n",
       "original_language                                                       en\n",
       "original_title                                            Grumpier Old Men\n",
       "overview                 A family wedding reignites the ancient feud be...\n",
       "popularity                                                         11.7129\n",
       "poster_path                               /6ksm1sjKMFLbO7UY2i6G1ju9SML.jpg\n",
       "production_companies     [{'name': 'Warner Bros.', 'id': 6194}, {'name'...\n",
       "production_countries     [{'iso_3166_1': 'US', 'name': 'United States o...\n",
       "release_date                                                    1995-12-22\n",
       "revenue                                                                  0\n",
       "runtime                                                                101\n",
       "spoken_languages                  [{'iso_639_1': 'en', 'name': 'English'}]\n",
       "status                                                            Released\n",
       "tagline                  Still Yelling. Still Fighting. Still Ready for...\n",
       "title                                                     Grumpier Old Men\n",
       "video                                                                False\n",
       "vote_average                                                           6.5\n",
       "vote_count                                                              92\n",
       "Name: 2, dtype: object"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Data from the third film\n",
    "df.iloc(0)[2]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>adult</th>\n",
       "      <th>belongs_to_collection</th>\n",
       "      <th>budget</th>\n",
       "      <th>genres</th>\n",
       "      <th>homepage</th>\n",
       "      <th>id</th>\n",
       "      <th>imdb_id</th>\n",
       "      <th>original_language</th>\n",
       "      <th>original_title</th>\n",
       "      <th>overview</th>\n",
       "      <th>...</th>\n",
       "      <th>release_date</th>\n",
       "      <th>revenue</th>\n",
       "      <th>runtime</th>\n",
       "      <th>spoken_languages</th>\n",
       "      <th>status</th>\n",
       "      <th>tagline</th>\n",
       "      <th>title</th>\n",
       "      <th>video</th>\n",
       "      <th>vote_average</th>\n",
       "      <th>vote_count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>False</td>\n",
       "      <td>{'id': 119050, 'name': 'Grumpy Old Men Collect...</td>\n",
       "      <td>0</td>\n",
       "      <td>[{'id': 10749, 'name': 'Romance'}, {'id': 35, ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15602</td>\n",
       "      <td>tt0113228</td>\n",
       "      <td>en</td>\n",
       "      <td>Grumpier Old Men</td>\n",
       "      <td>A family wedding reignites the ancient feud be...</td>\n",
       "      <td>...</td>\n",
       "      <td>1995-12-22</td>\n",
       "      <td>0</td>\n",
       "      <td>101.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
       "      <td>Released</td>\n",
       "      <td>Still Yelling. Still Fighting. Still Ready for...</td>\n",
       "      <td>Grumpier Old Men</td>\n",
       "      <td>False</td>\n",
       "      <td>6.5</td>\n",
       "      <td>92</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   adult                              belongs_to_collection  budget  \\\n",
       "2  False  {'id': 119050, 'name': 'Grumpy Old Men Collect...       0   \n",
       "\n",
       "                                              genres homepage     id  \\\n",
       "2  [{'id': 10749, 'name': 'Romance'}, {'id': 35, ...      NaN  15602   \n",
       "\n",
       "     imdb_id original_language    original_title  \\\n",
       "2  tt0113228                en  Grumpier Old Men   \n",
       "\n",
       "                                            overview  ...  release_date  \\\n",
       "2  A family wedding reignites the ancient feud be...  ...    1995-12-22   \n",
       "\n",
       "  revenue runtime                          spoken_languages    status  \\\n",
       "2       0   101.0  [{'iso_639_1': 'en', 'name': 'English'}]  Released   \n",
       "\n",
       "                                             tagline             title  video  \\\n",
       "2  Still Yelling. Still Fighting. Still Ready for...  Grumpier Old Men  False   \n",
       "\n",
       "  vote_average vote_count  \n",
       "2          6.5         92  \n",
       "\n",
       "[1 rows x 24 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Data from the movie \"Grumpier Old Men\"\n",
    "df[df['original_title'] == 'Grumpier Old Men']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>adult</th>\n",
       "      <th>belongs_to_collection</th>\n",
       "      <th>budget</th>\n",
       "      <th>genres</th>\n",
       "      <th>homepage</th>\n",
       "      <th>id</th>\n",
       "      <th>imdb_id</th>\n",
       "      <th>original_language</th>\n",
       "      <th>original_title</th>\n",
       "      <th>overview</th>\n",
       "      <th>...</th>\n",
       "      <th>revenue</th>\n",
       "      <th>runtime</th>\n",
       "      <th>spoken_languages</th>\n",
       "      <th>status</th>\n",
       "      <th>tagline</th>\n",
       "      <th>title</th>\n",
       "      <th>video</th>\n",
       "      <th>vote_average</th>\n",
       "      <th>vote_count</th>\n",
       "      <th>lancamento</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>False</td>\n",
       "      <td>{'id': 10194, 'name': 'Toy Story Collection', ...</td>\n",
       "      <td>30000000</td>\n",
       "      <td>[{'id': 16, 'name': 'Animation'}, {'id': 35, '...</td>\n",
       "      <td>http://toystory.disney.com/toy-story</td>\n",
       "      <td>862</td>\n",
       "      <td>tt0114709</td>\n",
       "      <td>en</td>\n",
       "      <td>Toy Story</td>\n",
       "      <td>Led by Woody, Andy's toys live happily in his ...</td>\n",
       "      <td>...</td>\n",
       "      <td>373554033</td>\n",
       "      <td>81.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
       "      <td>Released</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Toy Story</td>\n",
       "      <td>False</td>\n",
       "      <td>7.7</td>\n",
       "      <td>5415</td>\n",
       "      <td>1995-10-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>65000000</td>\n",
       "      <td>[{'id': 12, 'name': 'Adventure'}, {'id': 14, '...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8844</td>\n",
       "      <td>tt0113497</td>\n",
       "      <td>en</td>\n",
       "      <td>Jumanji</td>\n",
       "      <td>When siblings Judy and Peter discover an encha...</td>\n",
       "      <td>...</td>\n",
       "      <td>262797249</td>\n",
       "      <td>104.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}, {'iso...</td>\n",
       "      <td>Released</td>\n",
       "      <td>Roll the dice and unleash the excitement!</td>\n",
       "      <td>Jumanji</td>\n",
       "      <td>False</td>\n",
       "      <td>6.9</td>\n",
       "      <td>2413</td>\n",
       "      <td>1995-12-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>False</td>\n",
       "      <td>{'id': 119050, 'name': 'Grumpy Old Men Collect...</td>\n",
       "      <td>0</td>\n",
       "      <td>[{'id': 10749, 'name': 'Romance'}, {'id': 35, ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15602</td>\n",
       "      <td>tt0113228</td>\n",
       "      <td>en</td>\n",
       "      <td>Grumpier Old Men</td>\n",
       "      <td>A family wedding reignites the ancient feud be...</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>101.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
       "      <td>Released</td>\n",
       "      <td>Still Yelling. Still Fighting. Still Ready for...</td>\n",
       "      <td>Grumpier Old Men</td>\n",
       "      <td>False</td>\n",
       "      <td>6.5</td>\n",
       "      <td>92</td>\n",
       "      <td>1995-12-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16000000</td>\n",
       "      <td>[{'id': 35, 'name': 'Comedy'}, {'id': 18, 'nam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>31357</td>\n",
       "      <td>tt0114885</td>\n",
       "      <td>en</td>\n",
       "      <td>Waiting to Exhale</td>\n",
       "      <td>Cheated on, mistreated and stepped on, the wom...</td>\n",
       "      <td>...</td>\n",
       "      <td>81452156</td>\n",
       "      <td>127.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
       "      <td>Released</td>\n",
       "      <td>Friends are the people who let you be yourself...</td>\n",
       "      <td>Waiting to Exhale</td>\n",
       "      <td>False</td>\n",
       "      <td>6.1</td>\n",
       "      <td>34</td>\n",
       "      <td>1995-12-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>False</td>\n",
       "      <td>{'id': 96871, 'name': 'Father of the Bride Col...</td>\n",
       "      <td>0</td>\n",
       "      <td>[{'id': 35, 'name': 'Comedy'}]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11862</td>\n",
       "      <td>tt0113041</td>\n",
       "      <td>en</td>\n",
       "      <td>Father of the Bride Part II</td>\n",
       "      <td>Just when George Banks has recovered from his ...</td>\n",
       "      <td>...</td>\n",
       "      <td>76578911</td>\n",
       "      <td>106.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
       "      <td>Released</td>\n",
       "      <td>Just When His World Is Back To Normal... He's ...</td>\n",
       "      <td>Father of the Bride Part II</td>\n",
       "      <td>False</td>\n",
       "      <td>5.7</td>\n",
       "      <td>173</td>\n",
       "      <td>1995-02-10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>60000000</td>\n",
       "      <td>[{'id': 28, 'name': 'Action'}, {'id': 80, 'nam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>949</td>\n",
       "      <td>tt0113277</td>\n",
       "      <td>en</td>\n",
       "      <td>Heat</td>\n",
       "      <td>Obsessive master thief, Neil McCauley leads a ...</td>\n",
       "      <td>...</td>\n",
       "      <td>187436818</td>\n",
       "      <td>170.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}, {'iso...</td>\n",
       "      <td>Released</td>\n",
       "      <td>A Los Angeles Crime Saga</td>\n",
       "      <td>Heat</td>\n",
       "      <td>False</td>\n",
       "      <td>7.7</td>\n",
       "      <td>1886</td>\n",
       "      <td>1995-12-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>58000000</td>\n",
       "      <td>[{'id': 35, 'name': 'Comedy'}, {'id': 10749, '...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11860</td>\n",
       "      <td>tt0114319</td>\n",
       "      <td>en</td>\n",
       "      <td>Sabrina</td>\n",
       "      <td>An ugly duckling having undergone a remarkable...</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>127.0</td>\n",
       "      <td>[{'iso_639_1': 'fr', 'name': 'Français'}, {'is...</td>\n",
       "      <td>Released</td>\n",
       "      <td>You are cordially invited to the most surprisi...</td>\n",
       "      <td>Sabrina</td>\n",
       "      <td>False</td>\n",
       "      <td>6.2</td>\n",
       "      <td>141</td>\n",
       "      <td>1995-12-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>[{'id': 28, 'name': 'Action'}, {'id': 12, 'nam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>45325</td>\n",
       "      <td>tt0112302</td>\n",
       "      <td>en</td>\n",
       "      <td>Tom and Huck</td>\n",
       "      <td>A mischievous young boy, Tom Sawyer, witnesses...</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}, {'iso...</td>\n",
       "      <td>Released</td>\n",
       "      <td>The Original Bad Boys.</td>\n",
       "      <td>Tom and Huck</td>\n",
       "      <td>False</td>\n",
       "      <td>5.4</td>\n",
       "      <td>45</td>\n",
       "      <td>1995-12-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35000000</td>\n",
       "      <td>[{'id': 28, 'name': 'Action'}, {'id': 12, 'nam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9091</td>\n",
       "      <td>tt0114576</td>\n",
       "      <td>en</td>\n",
       "      <td>Sudden Death</td>\n",
       "      <td>International action superstar Jean Claude Van...</td>\n",
       "      <td>...</td>\n",
       "      <td>64350171</td>\n",
       "      <td>106.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
       "      <td>Released</td>\n",
       "      <td>Terror goes into overtime.</td>\n",
       "      <td>Sudden Death</td>\n",
       "      <td>False</td>\n",
       "      <td>5.5</td>\n",
       "      <td>174</td>\n",
       "      <td>1995-12-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>False</td>\n",
       "      <td>{'id': 645, 'name': 'James Bond Collection', '...</td>\n",
       "      <td>58000000</td>\n",
       "      <td>[{'id': 12, 'name': 'Adventure'}, {'id': 28, '...</td>\n",
       "      <td>http://www.mgm.com/view/movie/757/Goldeneye/</td>\n",
       "      <td>710</td>\n",
       "      <td>tt0113189</td>\n",
       "      <td>en</td>\n",
       "      <td>GoldenEye</td>\n",
       "      <td>James Bond must unmask the mysterious head of ...</td>\n",
       "      <td>...</td>\n",
       "      <td>352194034</td>\n",
       "      <td>130.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}, {'iso...</td>\n",
       "      <td>Released</td>\n",
       "      <td>No limits. No fears. No substitutes.</td>\n",
       "      <td>GoldenEye</td>\n",
       "      <td>False</td>\n",
       "      <td>6.6</td>\n",
       "      <td>1194</td>\n",
       "      <td>1995-11-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62000000</td>\n",
       "      <td>[{'id': 35, 'name': 'Comedy'}, {'id': 18, 'nam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9087</td>\n",
       "      <td>tt0112346</td>\n",
       "      <td>en</td>\n",
       "      <td>The American President</td>\n",
       "      <td>Widowed U.S. president Andrew Shepherd, one of...</td>\n",
       "      <td>...</td>\n",
       "      <td>107879496</td>\n",
       "      <td>106.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
       "      <td>Released</td>\n",
       "      <td>Why can't the most powerful man in the world h...</td>\n",
       "      <td>The American President</td>\n",
       "      <td>False</td>\n",
       "      <td>6.5</td>\n",
       "      <td>199</td>\n",
       "      <td>1995-11-17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>[{'id': 35, 'name': 'Comedy'}, {'id': 27, 'nam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12110</td>\n",
       "      <td>tt0112896</td>\n",
       "      <td>en</td>\n",
       "      <td>Dracula: Dead and Loving It</td>\n",
       "      <td>When a lawyer shows up at the vampire's doorst...</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}, {'iso...</td>\n",
       "      <td>Released</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dracula: Dead and Loving It</td>\n",
       "      <td>False</td>\n",
       "      <td>5.7</td>\n",
       "      <td>210</td>\n",
       "      <td>1995-12-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>False</td>\n",
       "      <td>{'id': 117693, 'name': 'Balto Collection', 'po...</td>\n",
       "      <td>0</td>\n",
       "      <td>[{'id': 10751, 'name': 'Family'}, {'id': 16, '...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21032</td>\n",
       "      <td>tt0112453</td>\n",
       "      <td>en</td>\n",
       "      <td>Balto</td>\n",
       "      <td>An outcast half-wolf risks his life to prevent...</td>\n",
       "      <td>...</td>\n",
       "      <td>11348324</td>\n",
       "      <td>78.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
       "      <td>Released</td>\n",
       "      <td>Part Dog. Part Wolf. All Hero.</td>\n",
       "      <td>Balto</td>\n",
       "      <td>False</td>\n",
       "      <td>7.1</td>\n",
       "      <td>423</td>\n",
       "      <td>1995-12-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>44000000</td>\n",
       "      <td>[{'id': 36, 'name': 'History'}, {'id': 18, 'na...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10858</td>\n",
       "      <td>tt0113987</td>\n",
       "      <td>en</td>\n",
       "      <td>Nixon</td>\n",
       "      <td>An all-star cast powers this epic look at Amer...</td>\n",
       "      <td>...</td>\n",
       "      <td>13681765</td>\n",
       "      <td>192.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
       "      <td>Released</td>\n",
       "      <td>Triumphant in Victory, Bitter in Defeat. He Ch...</td>\n",
       "      <td>Nixon</td>\n",
       "      <td>False</td>\n",
       "      <td>7.1</td>\n",
       "      <td>72</td>\n",
       "      <td>1995-12-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>98000000</td>\n",
       "      <td>[{'id': 28, 'name': 'Action'}, {'id': 12, 'nam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1408</td>\n",
       "      <td>tt0112760</td>\n",
       "      <td>en</td>\n",
       "      <td>Cutthroat Island</td>\n",
       "      <td>Morgan Adams and her slave, William Shaw, are ...</td>\n",
       "      <td>...</td>\n",
       "      <td>10017322</td>\n",
       "      <td>119.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}, {'iso...</td>\n",
       "      <td>Released</td>\n",
       "      <td>The Course Has Been Set. There Is No Turning B...</td>\n",
       "      <td>Cutthroat Island</td>\n",
       "      <td>False</td>\n",
       "      <td>5.7</td>\n",
       "      <td>137</td>\n",
       "      <td>1995-12-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>52000000</td>\n",
       "      <td>[{'id': 18, 'name': 'Drama'}, {'id': 80, 'name...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>524</td>\n",
       "      <td>tt0112641</td>\n",
       "      <td>en</td>\n",
       "      <td>Casino</td>\n",
       "      <td>The life of the gambling paradise – Las Vegas ...</td>\n",
       "      <td>...</td>\n",
       "      <td>116112375</td>\n",
       "      <td>178.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
       "      <td>Released</td>\n",
       "      <td>No one stays at the top forever.</td>\n",
       "      <td>Casino</td>\n",
       "      <td>False</td>\n",
       "      <td>7.8</td>\n",
       "      <td>1343</td>\n",
       "      <td>1995-11-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16500000</td>\n",
       "      <td>[{'id': 18, 'name': 'Drama'}, {'id': 10749, 'n...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4584</td>\n",
       "      <td>tt0114388</td>\n",
       "      <td>en</td>\n",
       "      <td>Sense and Sensibility</td>\n",
       "      <td>Rich Mr. Dashwood dies, leaving his second wif...</td>\n",
       "      <td>...</td>\n",
       "      <td>135000000</td>\n",
       "      <td>136.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
       "      <td>Released</td>\n",
       "      <td>Lose your heart and come to your senses.</td>\n",
       "      <td>Sense and Sensibility</td>\n",
       "      <td>False</td>\n",
       "      <td>7.2</td>\n",
       "      <td>364</td>\n",
       "      <td>1995-12-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4000000</td>\n",
       "      <td>[{'id': 80, 'name': 'Crime'}, {'id': 35, 'name...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5</td>\n",
       "      <td>tt0113101</td>\n",
       "      <td>en</td>\n",
       "      <td>Four Rooms</td>\n",
       "      <td>It's Ted the Bellhop's first night on the job....</td>\n",
       "      <td>...</td>\n",
       "      <td>4300000</td>\n",
       "      <td>98.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
       "      <td>Released</td>\n",
       "      <td>Twelve outrageous guests. Four scandalous requ...</td>\n",
       "      <td>Four Rooms</td>\n",
       "      <td>False</td>\n",
       "      <td>6.5</td>\n",
       "      <td>539</td>\n",
       "      <td>1995-12-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>False</td>\n",
       "      <td>{'id': 3167, 'name': 'Ace Ventura Collection',...</td>\n",
       "      <td>30000000</td>\n",
       "      <td>[{'id': 80, 'name': 'Crime'}, {'id': 35, 'name...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9273</td>\n",
       "      <td>tt0112281</td>\n",
       "      <td>en</td>\n",
       "      <td>Ace Ventura: When Nature Calls</td>\n",
       "      <td>Summoned from an ashram in Tibet, Ace finds hi...</td>\n",
       "      <td>...</td>\n",
       "      <td>212385533</td>\n",
       "      <td>90.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
       "      <td>Released</td>\n",
       "      <td>New animals. New adventures. Same hair.</td>\n",
       "      <td>Ace Ventura: When Nature Calls</td>\n",
       "      <td>False</td>\n",
       "      <td>6.1</td>\n",
       "      <td>1128</td>\n",
       "      <td>1995-11-10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>60000000</td>\n",
       "      <td>[{'id': 28, 'name': 'Action'}, {'id': 35, 'nam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11517</td>\n",
       "      <td>tt0113845</td>\n",
       "      <td>en</td>\n",
       "      <td>Money Train</td>\n",
       "      <td>A vengeful New York transit cop decides to ste...</td>\n",
       "      <td>...</td>\n",
       "      <td>35431113</td>\n",
       "      <td>103.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
       "      <td>Released</td>\n",
       "      <td>Get on, or GET OUT THE WAY!</td>\n",
       "      <td>Money Train</td>\n",
       "      <td>False</td>\n",
       "      <td>5.4</td>\n",
       "      <td>224</td>\n",
       "      <td>1995-11-21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>False</td>\n",
       "      <td>{'id': 91698, 'name': 'Chili Palmer Collection...</td>\n",
       "      <td>30250000</td>\n",
       "      <td>[{'id': 35, 'name': 'Comedy'}, {'id': 53, 'nam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8012</td>\n",
       "      <td>tt0113161</td>\n",
       "      <td>en</td>\n",
       "      <td>Get Shorty</td>\n",
       "      <td>Chili Palmer is a Miami mobster who gets sent ...</td>\n",
       "      <td>...</td>\n",
       "      <td>115101622</td>\n",
       "      <td>105.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
       "      <td>Released</td>\n",
       "      <td>The mob is tough, but it’s nothing like show b...</td>\n",
       "      <td>Get Shorty</td>\n",
       "      <td>False</td>\n",
       "      <td>6.4</td>\n",
       "      <td>305</td>\n",
       "      <td>1995-10-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>[{'id': 18, 'name': 'Drama'}, {'id': 53, 'name...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1710</td>\n",
       "      <td>tt0112722</td>\n",
       "      <td>en</td>\n",
       "      <td>Copycat</td>\n",
       "      <td>An agoraphobic psychologist and a female detec...</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>124.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}, {'iso...</td>\n",
       "      <td>Released</td>\n",
       "      <td>One man is copying the most notorious killers ...</td>\n",
       "      <td>Copycat</td>\n",
       "      <td>False</td>\n",
       "      <td>6.5</td>\n",
       "      <td>199</td>\n",
       "      <td>1995-10-27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>50000000</td>\n",
       "      <td>[{'id': 28, 'name': 'Action'}, {'id': 12, 'nam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9691</td>\n",
       "      <td>tt0112401</td>\n",
       "      <td>en</td>\n",
       "      <td>Assassins</td>\n",
       "      <td>Assassin Robert Rath arrives at a funeral to k...</td>\n",
       "      <td>...</td>\n",
       "      <td>30303072</td>\n",
       "      <td>132.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}, {'iso...</td>\n",
       "      <td>Released</td>\n",
       "      <td>In the shadows of life, In the business of dea...</td>\n",
       "      <td>Assassins</td>\n",
       "      <td>False</td>\n",
       "      <td>6.0</td>\n",
       "      <td>394</td>\n",
       "      <td>1995-10-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>[{'id': 18, 'name': 'Drama'}, {'id': 14, 'name...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12665</td>\n",
       "      <td>tt0114168</td>\n",
       "      <td>en</td>\n",
       "      <td>Powder</td>\n",
       "      <td>Harassed by classmates who won't accept his sh...</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>111.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
       "      <td>Released</td>\n",
       "      <td>An extraordinary encounter with another human ...</td>\n",
       "      <td>Powder</td>\n",
       "      <td>False</td>\n",
       "      <td>6.3</td>\n",
       "      <td>143</td>\n",
       "      <td>1995-10-27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3600000</td>\n",
       "      <td>[{'id': 18, 'name': 'Drama'}, {'id': 10749, 'n...</td>\n",
       "      <td>http://www.mgm.com/title_title.do?title_star=L...</td>\n",
       "      <td>451</td>\n",
       "      <td>tt0113627</td>\n",
       "      <td>en</td>\n",
       "      <td>Leaving Las Vegas</td>\n",
       "      <td>Ben Sanderson, an alcoholic Hollywood screenwr...</td>\n",
       "      <td>...</td>\n",
       "      <td>49800000</td>\n",
       "      <td>112.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
       "      <td>Released</td>\n",
       "      <td>I Love You... The Way You Are.</td>\n",
       "      <td>Leaving Las Vegas</td>\n",
       "      <td>False</td>\n",
       "      <td>7.1</td>\n",
       "      <td>365</td>\n",
       "      <td>1995-10-27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>[{'id': 18, 'name': 'Drama'}]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16420</td>\n",
       "      <td>tt0114057</td>\n",
       "      <td>en</td>\n",
       "      <td>Othello</td>\n",
       "      <td>The evil Iago pretends to be friend of Othello...</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>123.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
       "      <td>Released</td>\n",
       "      <td>Envy, greed, jealousy and love.</td>\n",
       "      <td>Othello</td>\n",
       "      <td>False</td>\n",
       "      <td>7.0</td>\n",
       "      <td>33</td>\n",
       "      <td>1995-12-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12000000</td>\n",
       "      <td>[{'id': 35, 'name': 'Comedy'}, {'id': 18, 'nam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9263</td>\n",
       "      <td>tt0114011</td>\n",
       "      <td>en</td>\n",
       "      <td>Now and Then</td>\n",
       "      <td>Waxing nostalgic about the bittersweet passage...</td>\n",
       "      <td>...</td>\n",
       "      <td>27400000</td>\n",
       "      <td>100.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
       "      <td>Released</td>\n",
       "      <td>In every woman there is the girl she left behind.</td>\n",
       "      <td>Now and Then</td>\n",
       "      <td>False</td>\n",
       "      <td>6.6</td>\n",
       "      <td>91</td>\n",
       "      <td>1995-10-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>[{'id': 18, 'name': 'Drama'}, {'id': 10749, 'n...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17015</td>\n",
       "      <td>tt0114117</td>\n",
       "      <td>en</td>\n",
       "      <td>Persuasion</td>\n",
       "      <td>This film adaptation of Jane Austen's last nov...</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>104.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
       "      <td>Released</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Persuasion</td>\n",
       "      <td>False</td>\n",
       "      <td>7.4</td>\n",
       "      <td>36</td>\n",
       "      <td>1995-09-27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18000000</td>\n",
       "      <td>[{'id': 14, 'name': 'Fantasy'}, {'id': 878, 'n...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>902</td>\n",
       "      <td>tt0112682</td>\n",
       "      <td>fr</td>\n",
       "      <td>La Cité des Enfants Perdus</td>\n",
       "      <td>A scientist in a surrealist society kidnaps ch...</td>\n",
       "      <td>...</td>\n",
       "      <td>1738611</td>\n",
       "      <td>108.0</td>\n",
       "      <td>[{'iso_639_1': 'cn', 'name': '??? / ???'}, {'i...</td>\n",
       "      <td>Released</td>\n",
       "      <td>Where happily ever after is just a dream.</td>\n",
       "      <td>The City of Lost Children</td>\n",
       "      <td>False</td>\n",
       "      <td>7.6</td>\n",
       "      <td>308</td>\n",
       "      <td>1995-05-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>[{'id': 18, 'name': 'Drama'}, {'id': 80, 'name...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9909</td>\n",
       "      <td>tt0112792</td>\n",
       "      <td>en</td>\n",
       "      <td>Dangerous Minds</td>\n",
       "      <td>Former Marine Louanne Johnson lands a gig teac...</td>\n",
       "      <td>...</td>\n",
       "      <td>180000000</td>\n",
       "      <td>99.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
       "      <td>Released</td>\n",
       "      <td>She broke the rules... and changed their lives.</td>\n",
       "      <td>Dangerous Minds</td>\n",
       "      <td>False</td>\n",
       "      <td>6.4</td>\n",
       "      <td>249</td>\n",
       "      <td>1995-08-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29500000</td>\n",
       "      <td>[{'id': 878, 'name': 'Science Fiction'}, {'id'...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>63</td>\n",
       "      <td>tt0114746</td>\n",
       "      <td>en</td>\n",
       "      <td>Twelve Monkeys</td>\n",
       "      <td>In the year 2035, convict James Cole reluctant...</td>\n",
       "      <td>...</td>\n",
       "      <td>168840000</td>\n",
       "      <td>129.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}, {'iso...</td>\n",
       "      <td>Released</td>\n",
       "      <td>The future is history.</td>\n",
       "      <td>Twelve Monkeys</td>\n",
       "      <td>False</td>\n",
       "      <td>7.4</td>\n",
       "      <td>2470</td>\n",
       "      <td>1995-12-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>[{'id': 10749, 'name': 'Romance'}, {'id': 12, ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>78802</td>\n",
       "      <td>tt0114952</td>\n",
       "      <td>fr</td>\n",
       "      <td>Guillaumet, les ailes du courage</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
       "      <td>Released</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Wings of Courage</td>\n",
       "      <td>False</td>\n",
       "      <td>6.8</td>\n",
       "      <td>4</td>\n",
       "      <td>1996-09-18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>False</td>\n",
       "      <td>{'id': 9435, 'name': 'Babe Collection', 'poste...</td>\n",
       "      <td>30000000</td>\n",
       "      <td>[{'id': 14, 'name': 'Fantasy'}, {'id': 18, 'na...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9598</td>\n",
       "      <td>tt0112431</td>\n",
       "      <td>en</td>\n",
       "      <td>Babe</td>\n",
       "      <td>Babe is a little pig who doesn't quite know hi...</td>\n",
       "      <td>...</td>\n",
       "      <td>254134910</td>\n",
       "      <td>89.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
       "      <td>Released</td>\n",
       "      <td>A little pig goes a long way.</td>\n",
       "      <td>Babe</td>\n",
       "      <td>False</td>\n",
       "      <td>6.0</td>\n",
       "      <td>756</td>\n",
       "      <td>1995-07-18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>[{'id': 36, 'name': 'History'}, {'id': 18, 'na...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>47018</td>\n",
       "      <td>tt0112637</td>\n",
       "      <td>en</td>\n",
       "      <td>Carrington</td>\n",
       "      <td>The story of the relationship between painter ...</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>121.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
       "      <td>Released</td>\n",
       "      <td>A Love so Unusual it has to be True</td>\n",
       "      <td>Carrington</td>\n",
       "      <td>False</td>\n",
       "      <td>6.4</td>\n",
       "      <td>16</td>\n",
       "      <td>1995-11-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11000000</td>\n",
       "      <td>[{'id': 18, 'name': 'Drama'}]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>687</td>\n",
       "      <td>tt0112818</td>\n",
       "      <td>en</td>\n",
       "      <td>Dead Man Walking</td>\n",
       "      <td>A justice drama based on a true story about a ...</td>\n",
       "      <td>...</td>\n",
       "      <td>39363635</td>\n",
       "      <td>122.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
       "      <td>Released</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Man Walking</td>\n",
       "      <td>False</td>\n",
       "      <td>7.3</td>\n",
       "      <td>350</td>\n",
       "      <td>1995-12-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>[{'id': 12, 'name': 'Adventure'}, {'id': 36, '...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>139405</td>\n",
       "      <td>tt0112286</td>\n",
       "      <td>en</td>\n",
       "      <td>Across the Sea of Time</td>\n",
       "      <td>A young Russian boy, Thomas Minton, travels to...</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>[{'iso_639_1': 'ru', 'name': 'P??????'}, {'iso...</td>\n",
       "      <td>Released</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Across the Sea of Time</td>\n",
       "      <td>False</td>\n",
       "      <td>3.5</td>\n",
       "      <td>2</td>\n",
       "      <td>1995-10-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>[{'id': 35, 'name': 'Comedy'}, {'id': 10751, '...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>33689</td>\n",
       "      <td>tt0113442</td>\n",
       "      <td>en</td>\n",
       "      <td>It Takes Two</td>\n",
       "      <td>Identical 9-year-olds from very different back...</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>101.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
       "      <td>Released</td>\n",
       "      <td>Two identical strangers. Two different worlds....</td>\n",
       "      <td>It Takes Two</td>\n",
       "      <td>False</td>\n",
       "      <td>6.1</td>\n",
       "      <td>149</td>\n",
       "      <td>1995-11-17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12000000</td>\n",
       "      <td>[{'id': 35, 'name': 'Comedy'}, {'id': 18, 'nam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9603</td>\n",
       "      <td>tt0112697</td>\n",
       "      <td>en</td>\n",
       "      <td>Clueless</td>\n",
       "      <td>Shallow, rich and socially successful Cher is ...</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>[{'iso_639_1': 'es', 'name': 'Español'}, {'iso...</td>\n",
       "      <td>Released</td>\n",
       "      <td>Sex. Clothes. Popularity. Is there a problem h...</td>\n",
       "      <td>Clueless</td>\n",
       "      <td>False</td>\n",
       "      <td>6.9</td>\n",
       "      <td>828</td>\n",
       "      <td>1995-07-19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>[{'id': 18, 'name': 'Drama'}]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34615</td>\n",
       "      <td>tt0112749</td>\n",
       "      <td>en</td>\n",
       "      <td>Cry, the Beloved Country</td>\n",
       "      <td>A South-African preacher goes to search for hi...</td>\n",
       "      <td>...</td>\n",
       "      <td>676525</td>\n",
       "      <td>106.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
       "      <td>Released</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cry, the Beloved Country</td>\n",
       "      <td>False</td>\n",
       "      <td>6.7</td>\n",
       "      <td>13</td>\n",
       "      <td>1995-12-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>[{'id': 18, 'name': 'Drama'}, {'id': 10752, 'n...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>31174</td>\n",
       "      <td>tt0114279</td>\n",
       "      <td>en</td>\n",
       "      <td>Richard III</td>\n",
       "      <td>Shakespeare's Play transplanted into a 1930s s...</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>104.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
       "      <td>Released</td>\n",
       "      <td>I can smile, and murder while I smile</td>\n",
       "      <td>Richard III</td>\n",
       "      <td>False</td>\n",
       "      <td>6.9</td>\n",
       "      <td>50</td>\n",
       "      <td>1995-12-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10000000</td>\n",
       "      <td>[{'id': 28, 'name': 'Action'}, {'id': 80, 'nam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11443</td>\n",
       "      <td>tt0112819</td>\n",
       "      <td>en</td>\n",
       "      <td>Dead Presidents</td>\n",
       "      <td>Depicts a heist of old bills, retired from cir...</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>119.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
       "      <td>Released</td>\n",
       "      <td>In this daring heist, the only color that coun...</td>\n",
       "      <td>Dead Presidents</td>\n",
       "      <td>False</td>\n",
       "      <td>6.6</td>\n",
       "      <td>80</td>\n",
       "      <td>1995-10-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19000000</td>\n",
       "      <td>[{'id': 18, 'name': 'Drama'}, {'id': 10749, 'n...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35196</td>\n",
       "      <td>tt0114272</td>\n",
       "      <td>en</td>\n",
       "      <td>Restoration</td>\n",
       "      <td>An aspiring young physician, Robert Merivel fo...</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>117.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}, {'iso...</td>\n",
       "      <td>Released</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Restoration</td>\n",
       "      <td>False</td>\n",
       "      <td>6.3</td>\n",
       "      <td>30</td>\n",
       "      <td>1995-12-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>False</td>\n",
       "      <td>{'id': 9818, 'name': 'Mortal Kombat Collection...</td>\n",
       "      <td>18000000</td>\n",
       "      <td>[{'id': 28, 'name': 'Action'}, {'id': 14, 'nam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9312</td>\n",
       "      <td>tt0113855</td>\n",
       "      <td>en</td>\n",
       "      <td>Mortal Kombat</td>\n",
       "      <td>For nine generations an evil sorcerer has been...</td>\n",
       "      <td>...</td>\n",
       "      <td>122195920</td>\n",
       "      <td>101.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
       "      <td>Released</td>\n",
       "      <td>Nothing In This World Has Prepared You For This.</td>\n",
       "      <td>Mortal Kombat</td>\n",
       "      <td>False</td>\n",
       "      <td>5.4</td>\n",
       "      <td>452</td>\n",
       "      <td>1995-08-18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20000000</td>\n",
       "      <td>[{'id': 14, 'name': 'Fantasy'}, {'id': 18, 'na...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>577</td>\n",
       "      <td>tt0114681</td>\n",
       "      <td>en</td>\n",
       "      <td>To Die For</td>\n",
       "      <td>Susan wants to work in television and will the...</td>\n",
       "      <td>...</td>\n",
       "      <td>21284514</td>\n",
       "      <td>106.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
       "      <td>Released</td>\n",
       "      <td>All she wanted was a little attention.</td>\n",
       "      <td>To Die For</td>\n",
       "      <td>False</td>\n",
       "      <td>6.7</td>\n",
       "      <td>177</td>\n",
       "      <td>1995-05-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10000000</td>\n",
       "      <td>[{'id': 18, 'name': 'Drama'}, {'id': 10749, 'n...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11861</td>\n",
       "      <td>tt0113347</td>\n",
       "      <td>en</td>\n",
       "      <td>How To Make An American Quilt</td>\n",
       "      <td>Soon-to-be-wed graduate student Finn Dodd deve...</td>\n",
       "      <td>...</td>\n",
       "      <td>23574130</td>\n",
       "      <td>116.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
       "      <td>Released</td>\n",
       "      <td>There's beauty in the patterns of life.</td>\n",
       "      <td>How To Make An American Quilt</td>\n",
       "      <td>False</td>\n",
       "      <td>6.5</td>\n",
       "      <td>38</td>\n",
       "      <td>1995-10-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>33000000</td>\n",
       "      <td>[{'id': 80, 'name': 'Crime'}, {'id': 9648, 'na...</td>\n",
       "      <td>http://www.sevenmovie.com/</td>\n",
       "      <td>807</td>\n",
       "      <td>tt0114369</td>\n",
       "      <td>en</td>\n",
       "      <td>Se7en</td>\n",
       "      <td>Two homicide detectives are on a desperate hun...</td>\n",
       "      <td>...</td>\n",
       "      <td>327311859</td>\n",
       "      <td>127.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
       "      <td>Released</td>\n",
       "      <td>Seven deadly sins. Seven ways to die.</td>\n",
       "      <td>Se7en</td>\n",
       "      <td>False</td>\n",
       "      <td>8.1</td>\n",
       "      <td>5915</td>\n",
       "      <td>1995-09-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>False</td>\n",
       "      <td>{'id': 136214, 'name': 'Pocahontas Collection'...</td>\n",
       "      <td>55000000</td>\n",
       "      <td>[{'id': 12, 'name': 'Adventure'}, {'id': 16, '...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10530</td>\n",
       "      <td>tt0114148</td>\n",
       "      <td>en</td>\n",
       "      <td>Pocahontas</td>\n",
       "      <td>History comes gloriously to life in Disney's e...</td>\n",
       "      <td>...</td>\n",
       "      <td>346079773</td>\n",
       "      <td>81.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
       "      <td>Released</td>\n",
       "      <td>An American legend comes to life.</td>\n",
       "      <td>Pocahontas</td>\n",
       "      <td>False</td>\n",
       "      <td>6.7</td>\n",
       "      <td>1509</td>\n",
       "      <td>1995-06-14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>[{'id': 18, 'name': 'Drama'}, {'id': 10749, 'n...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8391</td>\n",
       "      <td>tt0114916</td>\n",
       "      <td>en</td>\n",
       "      <td>When Night Is Falling</td>\n",
       "      <td>A prudish woman, working on tenure as a litera...</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
       "      <td>Released</td>\n",
       "      <td>NaN</td>\n",
       "      <td>When Night Is Falling</td>\n",
       "      <td>False</td>\n",
       "      <td>5.9</td>\n",
       "      <td>10</td>\n",
       "      <td>1995-05-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6000000</td>\n",
       "      <td>[{'id': 18, 'name': 'Drama'}, {'id': 80, 'name...</td>\n",
       "      <td>http://www.mgm.com/#/our-titles/2083/The-Usual...</td>\n",
       "      <td>629</td>\n",
       "      <td>tt0114814</td>\n",
       "      <td>en</td>\n",
       "      <td>The Usual Suspects</td>\n",
       "      <td>Held in an L.A. interrogation room, Verbal Kin...</td>\n",
       "      <td>...</td>\n",
       "      <td>23341568</td>\n",
       "      <td>106.0</td>\n",
       "      <td>[{'iso_639_1': 'es', 'name': 'Español'}, {'iso...</td>\n",
       "      <td>Released</td>\n",
       "      <td>Five Criminals. One Line Up. No Coincidence.</td>\n",
       "      <td>The Usual Suspects</td>\n",
       "      <td>False</td>\n",
       "      <td>8.1</td>\n",
       "      <td>3334</td>\n",
       "      <td>1995-07-19</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>49 rows × 25 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    adult                              belongs_to_collection    budget  \\\n",
       "0   False  {'id': 10194, 'name': 'Toy Story Collection', ...  30000000   \n",
       "1   False                                                NaN  65000000   \n",
       "2   False  {'id': 119050, 'name': 'Grumpy Old Men Collect...         0   \n",
       "3   False                                                NaN  16000000   \n",
       "4   False  {'id': 96871, 'name': 'Father of the Bride Col...         0   \n",
       "5   False                                                NaN  60000000   \n",
       "6   False                                                NaN  58000000   \n",
       "7   False                                                NaN         0   \n",
       "8   False                                                NaN  35000000   \n",
       "9   False  {'id': 645, 'name': 'James Bond Collection', '...  58000000   \n",
       "10  False                                                NaN  62000000   \n",
       "11  False                                                NaN         0   \n",
       "12  False  {'id': 117693, 'name': 'Balto Collection', 'po...         0   \n",
       "13  False                                                NaN  44000000   \n",
       "14  False                                                NaN  98000000   \n",
       "15  False                                                NaN  52000000   \n",
       "16  False                                                NaN  16500000   \n",
       "17  False                                                NaN   4000000   \n",
       "18  False  {'id': 3167, 'name': 'Ace Ventura Collection',...  30000000   \n",
       "19  False                                                NaN  60000000   \n",
       "20  False  {'id': 91698, 'name': 'Chili Palmer Collection...  30250000   \n",
       "21  False                                                NaN         0   \n",
       "22  False                                                NaN  50000000   \n",
       "23  False                                                NaN         0   \n",
       "24  False                                                NaN   3600000   \n",
       "25  False                                                NaN         0   \n",
       "26  False                                                NaN  12000000   \n",
       "27  False                                                NaN         0   \n",
       "28  False                                                NaN  18000000   \n",
       "29  False                                                NaN         0   \n",
       "30  False                                                NaN  29500000   \n",
       "31  False                                                NaN         0   \n",
       "32  False  {'id': 9435, 'name': 'Babe Collection', 'poste...  30000000   \n",
       "33  False                                                NaN         0   \n",
       "34  False                                                NaN  11000000   \n",
       "35  False                                                NaN         0   \n",
       "36  False                                                NaN         0   \n",
       "37  False                                                NaN  12000000   \n",
       "38  False                                                NaN         0   \n",
       "39  False                                                NaN         0   \n",
       "40  False                                                NaN  10000000   \n",
       "41  False                                                NaN  19000000   \n",
       "42  False  {'id': 9818, 'name': 'Mortal Kombat Collection...  18000000   \n",
       "43  False                                                NaN  20000000   \n",
       "44  False                                                NaN  10000000   \n",
       "45  False                                                NaN  33000000   \n",
       "46  False  {'id': 136214, 'name': 'Pocahontas Collection'...  55000000   \n",
       "47  False                                                NaN         0   \n",
       "48  False                                                NaN   6000000   \n",
       "\n",
       "                                               genres  \\\n",
       "0   [{'id': 16, 'name': 'Animation'}, {'id': 35, '...   \n",
       "1   [{'id': 12, 'name': 'Adventure'}, {'id': 14, '...   \n",
       "2   [{'id': 10749, 'name': 'Romance'}, {'id': 35, ...   \n",
       "3   [{'id': 35, 'name': 'Comedy'}, {'id': 18, 'nam...   \n",
       "4                      [{'id': 35, 'name': 'Comedy'}]   \n",
       "5   [{'id': 28, 'name': 'Action'}, {'id': 80, 'nam...   \n",
       "6   [{'id': 35, 'name': 'Comedy'}, {'id': 10749, '...   \n",
       "7   [{'id': 28, 'name': 'Action'}, {'id': 12, 'nam...   \n",
       "8   [{'id': 28, 'name': 'Action'}, {'id': 12, 'nam...   \n",
       "9   [{'id': 12, 'name': 'Adventure'}, {'id': 28, '...   \n",
       "10  [{'id': 35, 'name': 'Comedy'}, {'id': 18, 'nam...   \n",
       "11  [{'id': 35, 'name': 'Comedy'}, {'id': 27, 'nam...   \n",
       "12  [{'id': 10751, 'name': 'Family'}, {'id': 16, '...   \n",
       "13  [{'id': 36, 'name': 'History'}, {'id': 18, 'na...   \n",
       "14  [{'id': 28, 'name': 'Action'}, {'id': 12, 'nam...   \n",
       "15  [{'id': 18, 'name': 'Drama'}, {'id': 80, 'name...   \n",
       "16  [{'id': 18, 'name': 'Drama'}, {'id': 10749, 'n...   \n",
       "17  [{'id': 80, 'name': 'Crime'}, {'id': 35, 'name...   \n",
       "18  [{'id': 80, 'name': 'Crime'}, {'id': 35, 'name...   \n",
       "19  [{'id': 28, 'name': 'Action'}, {'id': 35, 'nam...   \n",
       "20  [{'id': 35, 'name': 'Comedy'}, {'id': 53, 'nam...   \n",
       "21  [{'id': 18, 'name': 'Drama'}, {'id': 53, 'name...   \n",
       "22  [{'id': 28, 'name': 'Action'}, {'id': 12, 'nam...   \n",
       "23  [{'id': 18, 'name': 'Drama'}, {'id': 14, 'name...   \n",
       "24  [{'id': 18, 'name': 'Drama'}, {'id': 10749, 'n...   \n",
       "25                      [{'id': 18, 'name': 'Drama'}]   \n",
       "26  [{'id': 35, 'name': 'Comedy'}, {'id': 18, 'nam...   \n",
       "27  [{'id': 18, 'name': 'Drama'}, {'id': 10749, 'n...   \n",
       "28  [{'id': 14, 'name': 'Fantasy'}, {'id': 878, 'n...   \n",
       "29  [{'id': 18, 'name': 'Drama'}, {'id': 80, 'name...   \n",
       "30  [{'id': 878, 'name': 'Science Fiction'}, {'id'...   \n",
       "31  [{'id': 10749, 'name': 'Romance'}, {'id': 12, ...   \n",
       "32  [{'id': 14, 'name': 'Fantasy'}, {'id': 18, 'na...   \n",
       "33  [{'id': 36, 'name': 'History'}, {'id': 18, 'na...   \n",
       "34                      [{'id': 18, 'name': 'Drama'}]   \n",
       "35  [{'id': 12, 'name': 'Adventure'}, {'id': 36, '...   \n",
       "36  [{'id': 35, 'name': 'Comedy'}, {'id': 10751, '...   \n",
       "37  [{'id': 35, 'name': 'Comedy'}, {'id': 18, 'nam...   \n",
       "38                      [{'id': 18, 'name': 'Drama'}]   \n",
       "39  [{'id': 18, 'name': 'Drama'}, {'id': 10752, 'n...   \n",
       "40  [{'id': 28, 'name': 'Action'}, {'id': 80, 'nam...   \n",
       "41  [{'id': 18, 'name': 'Drama'}, {'id': 10749, 'n...   \n",
       "42  [{'id': 28, 'name': 'Action'}, {'id': 14, 'nam...   \n",
       "43  [{'id': 14, 'name': 'Fantasy'}, {'id': 18, 'na...   \n",
       "44  [{'id': 18, 'name': 'Drama'}, {'id': 10749, 'n...   \n",
       "45  [{'id': 80, 'name': 'Crime'}, {'id': 9648, 'na...   \n",
       "46  [{'id': 12, 'name': 'Adventure'}, {'id': 16, '...   \n",
       "47  [{'id': 18, 'name': 'Drama'}, {'id': 10749, 'n...   \n",
       "48  [{'id': 18, 'name': 'Drama'}, {'id': 80, 'name...   \n",
       "\n",
       "                                             homepage      id    imdb_id  \\\n",
       "0                http://toystory.disney.com/toy-story     862  tt0114709   \n",
       "1                                                 NaN    8844  tt0113497   \n",
       "2                                                 NaN   15602  tt0113228   \n",
       "3                                                 NaN   31357  tt0114885   \n",
       "4                                                 NaN   11862  tt0113041   \n",
       "5                                                 NaN     949  tt0113277   \n",
       "6                                                 NaN   11860  tt0114319   \n",
       "7                                                 NaN   45325  tt0112302   \n",
       "8                                                 NaN    9091  tt0114576   \n",
       "9        http://www.mgm.com/view/movie/757/Goldeneye/     710  tt0113189   \n",
       "10                                                NaN    9087  tt0112346   \n",
       "11                                                NaN   12110  tt0112896   \n",
       "12                                                NaN   21032  tt0112453   \n",
       "13                                                NaN   10858  tt0113987   \n",
       "14                                                NaN    1408  tt0112760   \n",
       "15                                                NaN     524  tt0112641   \n",
       "16                                                NaN    4584  tt0114388   \n",
       "17                                                NaN       5  tt0113101   \n",
       "18                                                NaN    9273  tt0112281   \n",
       "19                                                NaN   11517  tt0113845   \n",
       "20                                                NaN    8012  tt0113161   \n",
       "21                                                NaN    1710  tt0112722   \n",
       "22                                                NaN    9691  tt0112401   \n",
       "23                                                NaN   12665  tt0114168   \n",
       "24  http://www.mgm.com/title_title.do?title_star=L...     451  tt0113627   \n",
       "25                                                NaN   16420  tt0114057   \n",
       "26                                                NaN    9263  tt0114011   \n",
       "27                                                NaN   17015  tt0114117   \n",
       "28                                                NaN     902  tt0112682   \n",
       "29                                                NaN    9909  tt0112792   \n",
       "30                                                NaN      63  tt0114746   \n",
       "31                                                NaN   78802  tt0114952   \n",
       "32                                                NaN    9598  tt0112431   \n",
       "33                                                NaN   47018  tt0112637   \n",
       "34                                                NaN     687  tt0112818   \n",
       "35                                                NaN  139405  tt0112286   \n",
       "36                                                NaN   33689  tt0113442   \n",
       "37                                                NaN    9603  tt0112697   \n",
       "38                                                NaN   34615  tt0112749   \n",
       "39                                                NaN   31174  tt0114279   \n",
       "40                                                NaN   11443  tt0112819   \n",
       "41                                                NaN   35196  tt0114272   \n",
       "42                                                NaN    9312  tt0113855   \n",
       "43                                                NaN     577  tt0114681   \n",
       "44                                                NaN   11861  tt0113347   \n",
       "45                         http://www.sevenmovie.com/     807  tt0114369   \n",
       "46                                                NaN   10530  tt0114148   \n",
       "47                                                NaN    8391  tt0114916   \n",
       "48  http://www.mgm.com/#/our-titles/2083/The-Usual...     629  tt0114814   \n",
       "\n",
       "   original_language                    original_title  \\\n",
       "0                 en                         Toy Story   \n",
       "1                 en                           Jumanji   \n",
       "2                 en                  Grumpier Old Men   \n",
       "3                 en                 Waiting to Exhale   \n",
       "4                 en       Father of the Bride Part II   \n",
       "5                 en                              Heat   \n",
       "6                 en                           Sabrina   \n",
       "7                 en                      Tom and Huck   \n",
       "8                 en                      Sudden Death   \n",
       "9                 en                         GoldenEye   \n",
       "10                en            The American President   \n",
       "11                en       Dracula: Dead and Loving It   \n",
       "12                en                             Balto   \n",
       "13                en                             Nixon   \n",
       "14                en                  Cutthroat Island   \n",
       "15                en                            Casino   \n",
       "16                en             Sense and Sensibility   \n",
       "17                en                        Four Rooms   \n",
       "18                en    Ace Ventura: When Nature Calls   \n",
       "19                en                       Money Train   \n",
       "20                en                        Get Shorty   \n",
       "21                en                           Copycat   \n",
       "22                en                         Assassins   \n",
       "23                en                            Powder   \n",
       "24                en                 Leaving Las Vegas   \n",
       "25                en                           Othello   \n",
       "26                en                      Now and Then   \n",
       "27                en                        Persuasion   \n",
       "28                fr        La Cité des Enfants Perdus   \n",
       "29                en                   Dangerous Minds   \n",
       "30                en                    Twelve Monkeys   \n",
       "31                fr  Guillaumet, les ailes du courage   \n",
       "32                en                              Babe   \n",
       "33                en                        Carrington   \n",
       "34                en                  Dead Man Walking   \n",
       "35                en            Across the Sea of Time   \n",
       "36                en                      It Takes Two   \n",
       "37                en                          Clueless   \n",
       "38                en          Cry, the Beloved Country   \n",
       "39                en                       Richard III   \n",
       "40                en                   Dead Presidents   \n",
       "41                en                       Restoration   \n",
       "42                en                     Mortal Kombat   \n",
       "43                en                        To Die For   \n",
       "44                en     How To Make An American Quilt   \n",
       "45                en                             Se7en   \n",
       "46                en                        Pocahontas   \n",
       "47                en             When Night Is Falling   \n",
       "48                en                The Usual Suspects   \n",
       "\n",
       "                                             overview  ...    revenue runtime  \\\n",
       "0   Led by Woody, Andy's toys live happily in his ...  ...  373554033    81.0   \n",
       "1   When siblings Judy and Peter discover an encha...  ...  262797249   104.0   \n",
       "2   A family wedding reignites the ancient feud be...  ...          0   101.0   \n",
       "3   Cheated on, mistreated and stepped on, the wom...  ...   81452156   127.0   \n",
       "4   Just when George Banks has recovered from his ...  ...   76578911   106.0   \n",
       "5   Obsessive master thief, Neil McCauley leads a ...  ...  187436818   170.0   \n",
       "6   An ugly duckling having undergone a remarkable...  ...          0   127.0   \n",
       "7   A mischievous young boy, Tom Sawyer, witnesses...  ...          0    97.0   \n",
       "8   International action superstar Jean Claude Van...  ...   64350171   106.0   \n",
       "9   James Bond must unmask the mysterious head of ...  ...  352194034   130.0   \n",
       "10  Widowed U.S. president Andrew Shepherd, one of...  ...  107879496   106.0   \n",
       "11  When a lawyer shows up at the vampire's doorst...  ...          0    88.0   \n",
       "12  An outcast half-wolf risks his life to prevent...  ...   11348324    78.0   \n",
       "13  An all-star cast powers this epic look at Amer...  ...   13681765   192.0   \n",
       "14  Morgan Adams and her slave, William Shaw, are ...  ...   10017322   119.0   \n",
       "15  The life of the gambling paradise – Las Vegas ...  ...  116112375   178.0   \n",
       "16  Rich Mr. Dashwood dies, leaving his second wif...  ...  135000000   136.0   \n",
       "17  It's Ted the Bellhop's first night on the job....  ...    4300000    98.0   \n",
       "18  Summoned from an ashram in Tibet, Ace finds hi...  ...  212385533    90.0   \n",
       "19  A vengeful New York transit cop decides to ste...  ...   35431113   103.0   \n",
       "20  Chili Palmer is a Miami mobster who gets sent ...  ...  115101622   105.0   \n",
       "21  An agoraphobic psychologist and a female detec...  ...          0   124.0   \n",
       "22  Assassin Robert Rath arrives at a funeral to k...  ...   30303072   132.0   \n",
       "23  Harassed by classmates who won't accept his sh...  ...          0   111.0   \n",
       "24  Ben Sanderson, an alcoholic Hollywood screenwr...  ...   49800000   112.0   \n",
       "25  The evil Iago pretends to be friend of Othello...  ...          0   123.0   \n",
       "26  Waxing nostalgic about the bittersweet passage...  ...   27400000   100.0   \n",
       "27  This film adaptation of Jane Austen's last nov...  ...          0   104.0   \n",
       "28  A scientist in a surrealist society kidnaps ch...  ...    1738611   108.0   \n",
       "29  Former Marine Louanne Johnson lands a gig teac...  ...  180000000    99.0   \n",
       "30  In the year 2035, convict James Cole reluctant...  ...  168840000   129.0   \n",
       "31                                                NaN  ...          0    50.0   \n",
       "32  Babe is a little pig who doesn't quite know hi...  ...  254134910    89.0   \n",
       "33  The story of the relationship between painter ...  ...          0   121.0   \n",
       "34  A justice drama based on a true story about a ...  ...   39363635   122.0   \n",
       "35  A young Russian boy, Thomas Minton, travels to...  ...          0    51.0   \n",
       "36  Identical 9-year-olds from very different back...  ...          0   101.0   \n",
       "37  Shallow, rich and socially successful Cher is ...  ...          0    97.0   \n",
       "38  A South-African preacher goes to search for hi...  ...     676525   106.0   \n",
       "39  Shakespeare's Play transplanted into a 1930s s...  ...          0   104.0   \n",
       "40  Depicts a heist of old bills, retired from cir...  ...          0   119.0   \n",
       "41  An aspiring young physician, Robert Merivel fo...  ...          0   117.0   \n",
       "42  For nine generations an evil sorcerer has been...  ...  122195920   101.0   \n",
       "43  Susan wants to work in television and will the...  ...   21284514   106.0   \n",
       "44  Soon-to-be-wed graduate student Finn Dodd deve...  ...   23574130   116.0   \n",
       "45  Two homicide detectives are on a desperate hun...  ...  327311859   127.0   \n",
       "46  History comes gloriously to life in Disney's e...  ...  346079773    81.0   \n",
       "47  A prudish woman, working on tenure as a litera...  ...          0    96.0   \n",
       "48  Held in an L.A. interrogation room, Verbal Kin...  ...   23341568   106.0   \n",
       "\n",
       "                                     spoken_languages    status  \\\n",
       "0            [{'iso_639_1': 'en', 'name': 'English'}]  Released   \n",
       "1   [{'iso_639_1': 'en', 'name': 'English'}, {'iso...  Released   \n",
       "2            [{'iso_639_1': 'en', 'name': 'English'}]  Released   \n",
       "3            [{'iso_639_1': 'en', 'name': 'English'}]  Released   \n",
       "4            [{'iso_639_1': 'en', 'name': 'English'}]  Released   \n",
       "5   [{'iso_639_1': 'en', 'name': 'English'}, {'iso...  Released   \n",
       "6   [{'iso_639_1': 'fr', 'name': 'Français'}, {'is...  Released   \n",
       "7   [{'iso_639_1': 'en', 'name': 'English'}, {'iso...  Released   \n",
       "8            [{'iso_639_1': 'en', 'name': 'English'}]  Released   \n",
       "9   [{'iso_639_1': 'en', 'name': 'English'}, {'iso...  Released   \n",
       "10           [{'iso_639_1': 'en', 'name': 'English'}]  Released   \n",
       "11  [{'iso_639_1': 'en', 'name': 'English'}, {'iso...  Released   \n",
       "12           [{'iso_639_1': 'en', 'name': 'English'}]  Released   \n",
       "13           [{'iso_639_1': 'en', 'name': 'English'}]  Released   \n",
       "14  [{'iso_639_1': 'en', 'name': 'English'}, {'iso...  Released   \n",
       "15           [{'iso_639_1': 'en', 'name': 'English'}]  Released   \n",
       "16           [{'iso_639_1': 'en', 'name': 'English'}]  Released   \n",
       "17           [{'iso_639_1': 'en', 'name': 'English'}]  Released   \n",
       "18           [{'iso_639_1': 'en', 'name': 'English'}]  Released   \n",
       "19           [{'iso_639_1': 'en', 'name': 'English'}]  Released   \n",
       "20           [{'iso_639_1': 'en', 'name': 'English'}]  Released   \n",
       "21  [{'iso_639_1': 'en', 'name': 'English'}, {'iso...  Released   \n",
       "22  [{'iso_639_1': 'en', 'name': 'English'}, {'iso...  Released   \n",
       "23           [{'iso_639_1': 'en', 'name': 'English'}]  Released   \n",
       "24           [{'iso_639_1': 'en', 'name': 'English'}]  Released   \n",
       "25           [{'iso_639_1': 'en', 'name': 'English'}]  Released   \n",
       "26           [{'iso_639_1': 'en', 'name': 'English'}]  Released   \n",
       "27           [{'iso_639_1': 'en', 'name': 'English'}]  Released   \n",
       "28  [{'iso_639_1': 'cn', 'name': '??? / ???'}, {'i...  Released   \n",
       "29           [{'iso_639_1': 'en', 'name': 'English'}]  Released   \n",
       "30  [{'iso_639_1': 'en', 'name': 'English'}, {'iso...  Released   \n",
       "31           [{'iso_639_1': 'en', 'name': 'English'}]  Released   \n",
       "32           [{'iso_639_1': 'en', 'name': 'English'}]  Released   \n",
       "33           [{'iso_639_1': 'en', 'name': 'English'}]  Released   \n",
       "34           [{'iso_639_1': 'en', 'name': 'English'}]  Released   \n",
       "35  [{'iso_639_1': 'ru', 'name': 'P??????'}, {'iso...  Released   \n",
       "36           [{'iso_639_1': 'en', 'name': 'English'}]  Released   \n",
       "37  [{'iso_639_1': 'es', 'name': 'Español'}, {'iso...  Released   \n",
       "38           [{'iso_639_1': 'en', 'name': 'English'}]  Released   \n",
       "39           [{'iso_639_1': 'en', 'name': 'English'}]  Released   \n",
       "40           [{'iso_639_1': 'en', 'name': 'English'}]  Released   \n",
       "41  [{'iso_639_1': 'en', 'name': 'English'}, {'iso...  Released   \n",
       "42           [{'iso_639_1': 'en', 'name': 'English'}]  Released   \n",
       "43           [{'iso_639_1': 'en', 'name': 'English'}]  Released   \n",
       "44           [{'iso_639_1': 'en', 'name': 'English'}]  Released   \n",
       "45           [{'iso_639_1': 'en', 'name': 'English'}]  Released   \n",
       "46           [{'iso_639_1': 'en', 'name': 'English'}]  Released   \n",
       "47           [{'iso_639_1': 'en', 'name': 'English'}]  Released   \n",
       "48  [{'iso_639_1': 'es', 'name': 'Español'}, {'iso...  Released   \n",
       "\n",
       "                                              tagline  \\\n",
       "0                                                 NaN   \n",
       "1           Roll the dice and unleash the excitement!   \n",
       "2   Still Yelling. Still Fighting. Still Ready for...   \n",
       "3   Friends are the people who let you be yourself...   \n",
       "4   Just When His World Is Back To Normal... He's ...   \n",
       "5                            A Los Angeles Crime Saga   \n",
       "6   You are cordially invited to the most surprisi...   \n",
       "7                              The Original Bad Boys.   \n",
       "8                          Terror goes into overtime.   \n",
       "9                No limits. No fears. No substitutes.   \n",
       "10  Why can't the most powerful man in the world h...   \n",
       "11                                                NaN   \n",
       "12                     Part Dog. Part Wolf. All Hero.   \n",
       "13  Triumphant in Victory, Bitter in Defeat. He Ch...   \n",
       "14  The Course Has Been Set. There Is No Turning B...   \n",
       "15                   No one stays at the top forever.   \n",
       "16           Lose your heart and come to your senses.   \n",
       "17  Twelve outrageous guests. Four scandalous requ...   \n",
       "18            New animals. New adventures. Same hair.   \n",
       "19                        Get on, or GET OUT THE WAY!   \n",
       "20  The mob is tough, but it’s nothing like show b...   \n",
       "21  One man is copying the most notorious killers ...   \n",
       "22  In the shadows of life, In the business of dea...   \n",
       "23  An extraordinary encounter with another human ...   \n",
       "24                     I Love You... The Way You Are.   \n",
       "25                    Envy, greed, jealousy and love.   \n",
       "26  In every woman there is the girl she left behind.   \n",
       "27                                                NaN   \n",
       "28          Where happily ever after is just a dream.   \n",
       "29    She broke the rules... and changed their lives.   \n",
       "30                             The future is history.   \n",
       "31                                                NaN   \n",
       "32                      A little pig goes a long way.   \n",
       "33                A Love so Unusual it has to be True   \n",
       "34                                                NaN   \n",
       "35                                                NaN   \n",
       "36  Two identical strangers. Two different worlds....   \n",
       "37  Sex. Clothes. Popularity. Is there a problem h...   \n",
       "38                                                NaN   \n",
       "39              I can smile, and murder while I smile   \n",
       "40  In this daring heist, the only color that coun...   \n",
       "41                                                NaN   \n",
       "42   Nothing In This World Has Prepared You For This.   \n",
       "43             All she wanted was a little attention.   \n",
       "44            There's beauty in the patterns of life.   \n",
       "45              Seven deadly sins. Seven ways to die.   \n",
       "46                  An American legend comes to life.   \n",
       "47                                                NaN   \n",
       "48       Five Criminals. One Line Up. No Coincidence.   \n",
       "\n",
       "                             title  video vote_average vote_count lancamento  \n",
       "0                        Toy Story  False          7.7       5415 1995-10-30  \n",
       "1                          Jumanji  False          6.9       2413 1995-12-15  \n",
       "2                 Grumpier Old Men  False          6.5         92 1995-12-22  \n",
       "3                Waiting to Exhale  False          6.1         34 1995-12-22  \n",
       "4      Father of the Bride Part II  False          5.7        173 1995-02-10  \n",
       "5                             Heat  False          7.7       1886 1995-12-15  \n",
       "6                          Sabrina  False          6.2        141 1995-12-15  \n",
       "7                     Tom and Huck  False          5.4         45 1995-12-22  \n",
       "8                     Sudden Death  False          5.5        174 1995-12-22  \n",
       "9                        GoldenEye  False          6.6       1194 1995-11-16  \n",
       "10          The American President  False          6.5        199 1995-11-17  \n",
       "11     Dracula: Dead and Loving It  False          5.7        210 1995-12-22  \n",
       "12                           Balto  False          7.1        423 1995-12-22  \n",
       "13                           Nixon  False          7.1         72 1995-12-22  \n",
       "14                Cutthroat Island  False          5.7        137 1995-12-22  \n",
       "15                          Casino  False          7.8       1343 1995-11-22  \n",
       "16           Sense and Sensibility  False          7.2        364 1995-12-13  \n",
       "17                      Four Rooms  False          6.5        539 1995-12-09  \n",
       "18  Ace Ventura: When Nature Calls  False          6.1       1128 1995-11-10  \n",
       "19                     Money Train  False          5.4        224 1995-11-21  \n",
       "20                      Get Shorty  False          6.4        305 1995-10-20  \n",
       "21                         Copycat  False          6.5        199 1995-10-27  \n",
       "22                       Assassins  False          6.0        394 1995-10-06  \n",
       "23                          Powder  False          6.3        143 1995-10-27  \n",
       "24               Leaving Las Vegas  False          7.1        365 1995-10-27  \n",
       "25                         Othello  False          7.0         33 1995-12-15  \n",
       "26                    Now and Then  False          6.6         91 1995-10-20  \n",
       "27                      Persuasion  False          7.4         36 1995-09-27  \n",
       "28       The City of Lost Children  False          7.6        308 1995-05-16  \n",
       "29                 Dangerous Minds  False          6.4        249 1995-08-11  \n",
       "30                  Twelve Monkeys  False          7.4       2470 1995-12-29  \n",
       "31                Wings of Courage  False          6.8          4 1996-09-18  \n",
       "32                            Babe  False          6.0        756 1995-07-18  \n",
       "33                      Carrington  False          6.4         16 1995-11-08  \n",
       "34                Dead Man Walking  False          7.3        350 1995-12-29  \n",
       "35          Across the Sea of Time  False          3.5          2 1995-10-20  \n",
       "36                    It Takes Two  False          6.1        149 1995-11-17  \n",
       "37                        Clueless  False          6.9        828 1995-07-19  \n",
       "38        Cry, the Beloved Country  False          6.7         13 1995-12-15  \n",
       "39                     Richard III  False          6.9         50 1995-12-29  \n",
       "40                 Dead Presidents  False          6.6         80 1995-10-06  \n",
       "41                     Restoration  False          6.3         30 1995-12-29  \n",
       "42                   Mortal Kombat  False          5.4        452 1995-08-18  \n",
       "43                      To Die For  False          6.7        177 1995-05-20  \n",
       "44   How To Make An American Quilt  False          6.5         38 1995-10-06  \n",
       "45                           Se7en  False          8.1       5915 1995-09-22  \n",
       "46                      Pocahontas  False          6.7       1509 1995-06-14  \n",
       "47           When Night Is Falling  False          5.9         10 1995-05-05  \n",
       "48              The Usual Suspects  False          8.1       3334 1995-07-19  \n",
       "\n",
       "[49 rows x 25 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Movies released after 1995-01-01\n",
    "# Transforming the release_date string into a python date variable:\n",
    "df['lancamento'] = pd.to_datetime(df['release_date'])\n",
    "df[df['lancamento'] > '1995-01-01']\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Part 02"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv('http://www.ppgia.pucpr.br/~jean.barddal/datascience/kobe_shots.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 30697 entries, 0 to 30696\n",
      "Data columns (total 25 columns):\n",
      " #   Column              Non-Null Count  Dtype  \n",
      "---  ------              --------------  -----  \n",
      " 0   action_type         30697 non-null  object \n",
      " 1   combined_shot_type  30697 non-null  object \n",
      " 2   game_event_id       30697 non-null  int64  \n",
      " 3   game_id             30697 non-null  int64  \n",
      " 4   lat                 30697 non-null  float64\n",
      " 5   loc_x               30697 non-null  int64  \n",
      " 6   loc_y               30697 non-null  int64  \n",
      " 7   lon                 30697 non-null  float64\n",
      " 8   minutes_remaining   30697 non-null  int64  \n",
      " 9   period              30697 non-null  int64  \n",
      " 10  playoffs            30697 non-null  int64  \n",
      " 11  season              30697 non-null  object \n",
      " 12  seconds_remaining   30697 non-null  int64  \n",
      " 13  shot_distance       30697 non-null  int64  \n",
      " 14  shot_made_flag      25697 non-null  float64\n",
      " 15  shot_type           30697 non-null  object \n",
      " 16  shot_zone_area      30697 non-null  object \n",
      " 17  shot_zone_basic     30697 non-null  object \n",
      " 18  shot_zone_range     30697 non-null  object \n",
      " 19  team_id             30697 non-null  int64  \n",
      " 20  team_name           30697 non-null  object \n",
      " 21  game_date           30697 non-null  object \n",
      " 22  matchup             30697 non-null  object \n",
      " 23  opponent            30697 non-null  object \n",
      " 24  shot_id             30697 non-null  int64  \n",
      "dtypes: float64(3), int64(11), object(11)\n",
      "memory usage: 5.9+ MB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Removing lines whose shot_made_flag variable is missing\n",
    "df = df[~df['shot_made_flag'].isna()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "action_type                       Jump Shot\n",
       "combined_shot_type                Jump Shot\n",
       "game_event_id                            43\n",
       "game_id                            20000012\n",
       "lat                                 33.8693\n",
       "loc_x                                   138\n",
       "loc_y                                   175\n",
       "lon                                -118.132\n",
       "minutes_remaining                         6\n",
       "period                                    1\n",
       "playoffs                                  0\n",
       "season                              2000-01\n",
       "seconds_remaining                        52\n",
       "shot_distance                            22\n",
       "shot_made_flag                            0\n",
       "shot_type                    2PT Field Goal\n",
       "shot_zone_area        Right Side Center(RC)\n",
       "shot_zone_basic                   Mid-Range\n",
       "shot_zone_range                   16-24 ft.\n",
       "team_id                          1610612747\n",
       "team_name                Los Angeles Lakers\n",
       "game_date                        2000-10-31\n",
       "matchup                           LAL @ POR\n",
       "opponent                                POR\n",
       "shot_id                                   4\n",
       "Name: 3, dtype: object"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.iloc(0)[2]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Looking for factors that caused the player to hit / miss his shots\n",
    "df[df['shot_made_flag'] == 1]\n",
    "df['data_jogo'] = pd.to_datetime(df['game_date'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "opponent  shot_type     \n",
       "ATL       2PT Field Goal    345\n",
       "          3PT Field Goal     93\n",
       "BKN       2PT Field Goal     36\n",
       "          3PT Field Goal      9\n",
       "BOS       2PT Field Goal    601\n",
       "                           ... \n",
       "UTA       3PT Field Goal    279\n",
       "VAN       2PT Field Goal    168\n",
       "          3PT Field Goal     36\n",
       "WAS       2PT Field Goal    374\n",
       "          3PT Field Goal    127\n",
       "Name: shot_type, Length: 66, dtype: int64"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# What types of shots resulted in points against each opponent?\n",
    "df[df['shot_made_flag'] == 1]\n",
    "df.groupby(['opponent'])['shot_type'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "shot_made_flag  shot_type     \n",
       "0.0             2PT Field Goal    10602\n",
       "                3PT Field Goal     3630\n",
       "1.0             2PT Field Goal     9683\n",
       "                3PT Field Goal     1782\n",
       "Name: shot_type, dtype: int64"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# What type of launch resulted in the most points overall?\n",
    "df.groupby(['shot_made_flag'])['shot_type'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Timestamp('2016-04-13 00:00:00')"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# First and last game\n",
    "df['data_jogo'].min() # 1996-11-03\n",
    "df['data_jogo'].max() # 2016-04-13"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "shot_type\n",
       "2PT Field Goal    0.477348\n",
       "3PT Field Goal    0.329268\n",
       "Name: shot_made_flag, dtype: float64"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Average hits by type\n",
    "df.groupby(['shot_type'])['shot_made_flag'].mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "# How to use the apply function to calculate a new column from the condition of 2 or more existing columns?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>action_type</th>\n",
       "      <th>combined_shot_type</th>\n",
       "      <th>game_event_id</th>\n",
       "      <th>game_id</th>\n",
       "      <th>lat</th>\n",
       "      <th>loc_x</th>\n",
       "      <th>loc_y</th>\n",
       "      <th>lon</th>\n",
       "      <th>minutes_remaining</th>\n",
       "      <th>period</th>\n",
       "      <th>...</th>\n",
       "      <th>shot_zone_basic</th>\n",
       "      <th>shot_zone_range</th>\n",
       "      <th>team_id</th>\n",
       "      <th>team_name</th>\n",
       "      <th>game_date</th>\n",
       "      <th>matchup</th>\n",
       "      <th>opponent</th>\n",
       "      <th>shot_id</th>\n",
       "      <th>data_jogo</th>\n",
       "      <th>end_game</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Jump Shot</td>\n",
       "      <td>Jump Shot</td>\n",
       "      <td>12</td>\n",
       "      <td>20000012</td>\n",
       "      <td>34.0443</td>\n",
       "      <td>-157</td>\n",
       "      <td>0</td>\n",
       "      <td>-118.4268</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>Mid-Range</td>\n",
       "      <td>8-16 ft.</td>\n",
       "      <td>1610612747</td>\n",
       "      <td>Los Angeles Lakers</td>\n",
       "      <td>2000-10-31</td>\n",
       "      <td>LAL @ POR</td>\n",
       "      <td>POR</td>\n",
       "      <td>2</td>\n",
       "      <td>2000-10-31</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Jump Shot</td>\n",
       "      <td>Jump Shot</td>\n",
       "      <td>35</td>\n",
       "      <td>20000012</td>\n",
       "      <td>33.9093</td>\n",
       "      <td>-101</td>\n",
       "      <td>135</td>\n",
       "      <td>-118.3708</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>Mid-Range</td>\n",
       "      <td>16-24 ft.</td>\n",
       "      <td>1610612747</td>\n",
       "      <td>Los Angeles Lakers</td>\n",
       "      <td>2000-10-31</td>\n",
       "      <td>LAL @ POR</td>\n",
       "      <td>POR</td>\n",
       "      <td>3</td>\n",
       "      <td>2000-10-31</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Jump Shot</td>\n",
       "      <td>Jump Shot</td>\n",
       "      <td>43</td>\n",
       "      <td>20000012</td>\n",
       "      <td>33.8693</td>\n",
       "      <td>138</td>\n",
       "      <td>175</td>\n",
       "      <td>-118.1318</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>Mid-Range</td>\n",
       "      <td>16-24 ft.</td>\n",
       "      <td>1610612747</td>\n",
       "      <td>Los Angeles Lakers</td>\n",
       "      <td>2000-10-31</td>\n",
       "      <td>LAL @ POR</td>\n",
       "      <td>POR</td>\n",
       "      <td>4</td>\n",
       "      <td>2000-10-31</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Driving Dunk Shot</td>\n",
       "      <td>Dunk</td>\n",
       "      <td>155</td>\n",
       "      <td>20000012</td>\n",
       "      <td>34.0443</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-118.2698</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>Restricted Area</td>\n",
       "      <td>Less Than 8 ft.</td>\n",
       "      <td>1610612747</td>\n",
       "      <td>Los Angeles Lakers</td>\n",
       "      <td>2000-10-31</td>\n",
       "      <td>LAL @ POR</td>\n",
       "      <td>POR</td>\n",
       "      <td>5</td>\n",
       "      <td>2000-10-31</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Jump Shot</td>\n",
       "      <td>Jump Shot</td>\n",
       "      <td>244</td>\n",
       "      <td>20000012</td>\n",
       "      <td>34.0553</td>\n",
       "      <td>-145</td>\n",
       "      <td>-11</td>\n",
       "      <td>-118.4148</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>Mid-Range</td>\n",
       "      <td>8-16 ft.</td>\n",
       "      <td>1610612747</td>\n",
       "      <td>Los Angeles Lakers</td>\n",
       "      <td>2000-10-31</td>\n",
       "      <td>LAL @ POR</td>\n",
       "      <td>POR</td>\n",
       "      <td>6</td>\n",
       "      <td>2000-10-31</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 27 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         action_type combined_shot_type  game_event_id   game_id      lat  \\\n",
       "1          Jump Shot          Jump Shot             12  20000012  34.0443   \n",
       "2          Jump Shot          Jump Shot             35  20000012  33.9093   \n",
       "3          Jump Shot          Jump Shot             43  20000012  33.8693   \n",
       "4  Driving Dunk Shot               Dunk            155  20000012  34.0443   \n",
       "5          Jump Shot          Jump Shot            244  20000012  34.0553   \n",
       "\n",
       "   loc_x  loc_y       lon  minutes_remaining  period  ...  shot_zone_basic  \\\n",
       "1   -157      0 -118.4268                 10       1  ...        Mid-Range   \n",
       "2   -101    135 -118.3708                  7       1  ...        Mid-Range   \n",
       "3    138    175 -118.1318                  6       1  ...        Mid-Range   \n",
       "4      0      0 -118.2698                  6       2  ...  Restricted Area   \n",
       "5   -145    -11 -118.4148                  9       3  ...        Mid-Range   \n",
       "\n",
       "   shot_zone_range     team_id           team_name   game_date    matchup  \\\n",
       "1         8-16 ft.  1610612747  Los Angeles Lakers  2000-10-31  LAL @ POR   \n",
       "2        16-24 ft.  1610612747  Los Angeles Lakers  2000-10-31  LAL @ POR   \n",
       "3        16-24 ft.  1610612747  Los Angeles Lakers  2000-10-31  LAL @ POR   \n",
       "4  Less Than 8 ft.  1610612747  Los Angeles Lakers  2000-10-31  LAL @ POR   \n",
       "5         8-16 ft.  1610612747  Los Angeles Lakers  2000-10-31  LAL @ POR   \n",
       "\n",
       "  opponent shot_id  data_jogo  end_game  \n",
       "1      POR       2 2000-10-31     False  \n",
       "2      POR       3 2000-10-31     False  \n",
       "3      POR       4 2000-10-31     False  \n",
       "4      POR       5 2000-10-31     False  \n",
       "5      POR       6 2000-10-31     False  \n",
       "\n",
       "[5 rows x 27 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def end_game(info): \n",
    "    return int(info.period) == 4 and int(info.minutes_remaining) <= 5\n",
    "    \n",
    "df['end_game'] = df[['period', 'minutes_remaining']].apply(end_game, axis = 1)\n",
    "df.head(5)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}