waylon/pyDataVizDay
1
0
Fork 0
Code Issues Pull requests Projects Releases Packages Wiki Activity Actions
pyDataVizDay/notebooks/suresh_template.ipynb
Walker Waylon Scott bb3b70df6a added a notebook template for suresh
2017-07-03 16:54:10 -05:00

2907 lines
108 KiB
Text
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Title"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"2017-07-03 16:52:06 \n",
"\n",
"CPython 3.6.1\n",
"IPython 6.1.0\n",
"\n",
"pea 0.0.7\n",
"pandas 0.20.2\n",
"\n",
"compiler : MSC v.1900 64 bit (AMD64)\n",
"system : Windows\n",
"release : 7\n",
"machine : AMD64\n",
"processor : Intel64 Family 6 Model 42 Stepping 7, GenuineIntel\n",
"CPU cores : 8\n",
"interpreter: 64bit\n"
]
}
],
"source": [
"import os\n",
"import pandas as pd\n",
"import settings\n",
"import etl\n",
"\n",
"%matplotlib inline\n",
"\n",
"%load_ext watermark\n",
"%watermark -d -t -v -m -p pea,pandas"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"data = etl.Data()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Available DataFrames\n",
"\n",
"the Data object has 3 DataFrames available movie, keyword, and genre. keyword and genre can be linked back to movie by the index column and the index of movie"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style>\n",
" .dataframe thead tr:only-child th {\n",
" text-align: right;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: left;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>color</th>\n",
" <th>director_name</th>\n",
" <th>num_critic_for_reviews</th>\n",
" <th>duration</th>\n",
" <th>director_facebook_likes</th>\n",
" <th>actor_3_facebook_likes</th>\n",
" <th>actor_2_name</th>\n",
" <th>actor_1_facebook_likes</th>\n",
" <th>gross</th>\n",
" <th>genres</th>\n",
" <th>...</th>\n",
" <th>country</th>\n",
" <th>content_rating</th>\n",
" <th>budget</th>\n",
" <th>title_year</th>\n",
" <th>actor_2_facebook_likes</th>\n",
" <th>imdb_score</th>\n",
" <th>aspect_ratio</th>\n",
" <th>movie_facebook_likes</th>\n",
" <th>net</th>\n",
" <th>profitable</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>Color</td>\n",
" <td>James Cameron</td>\n",
" <td>723.0</td>\n",
" <td>178.0</td>\n",
" <td>0.0</td>\n",
" <td>855.0</td>\n",
" <td>Joel David Moore</td>\n",
" <td>1000.0</td>\n",
" <td>760505847.0</td>\n",
" <td>Action|Adventure|Fantasy|Sci-Fi</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>PG-13</td>\n",
" <td>237000000.0</td>\n",
" <td>2009-01-01</td>\n",
" <td>936.0</td>\n",
" <td>7.9</td>\n",
" <td>1.78</td>\n",
" <td>33000</td>\n",
" <td>523505847.0</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>Color</td>\n",
" <td>Gore Verbinski</td>\n",
" <td>302.0</td>\n",
" <td>169.0</td>\n",
" <td>563.0</td>\n",
" <td>1000.0</td>\n",
" <td>Orlando Bloom</td>\n",
" <td>40000.0</td>\n",
" <td>309404152.0</td>\n",
" <td>Action|Adventure|Fantasy</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>PG-13</td>\n",
" <td>300000000.0</td>\n",
" <td>2007-01-01</td>\n",
" <td>5000.0</td>\n",
" <td>7.1</td>\n",
" <td>2.35</td>\n",
" <td>0</td>\n",
" <td>9404152.0</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>Color</td>\n",
" <td>Sam Mendes</td>\n",
" <td>602.0</td>\n",
" <td>148.0</td>\n",
" <td>0.0</td>\n",
" <td>161.0</td>\n",
" <td>Rory Kinnear</td>\n",
" <td>11000.0</td>\n",
" <td>200074175.0</td>\n",
" <td>Action|Adventure|Thriller</td>\n",
" <td>...</td>\n",
" <td>UK</td>\n",
" <td>PG-13</td>\n",
" <td>245000000.0</td>\n",
" <td>2015-01-01</td>\n",
" <td>393.0</td>\n",
" <td>6.8</td>\n",
" <td>2.35</td>\n",
" <td>85000</td>\n",
" <td>-44925825.0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>Color</td>\n",
" <td>Christopher Nolan</td>\n",
" <td>813.0</td>\n",
" <td>164.0</td>\n",
" <td>22000.0</td>\n",
" <td>23000.0</td>\n",
" <td>Christian Bale</td>\n",
" <td>27000.0</td>\n",
" <td>448130642.0</td>\n",
" <td>Action|Thriller</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>PG-13</td>\n",
" <td>250000000.0</td>\n",
" <td>2012-01-01</td>\n",
" <td>23000.0</td>\n",
" <td>8.5</td>\n",
" <td>2.35</td>\n",
" <td>164000</td>\n",
" <td>198130642.0</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>NaN</td>\n",
" <td>Doug Walker</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>131.0</td>\n",
" <td>NaN</td>\n",
" <td>Rob Walker</td>\n",
" <td>131.0</td>\n",
" <td>NaN</td>\n",
" <td>Documentary</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaT</td>\n",
" <td>12.0</td>\n",
" <td>7.1</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>Color</td>\n",
" <td>Andrew Stanton</td>\n",
" <td>462.0</td>\n",
" <td>132.0</td>\n",
" <td>475.0</td>\n",
" <td>530.0</td>\n",
" <td>Samantha Morton</td>\n",
" <td>640.0</td>\n",
" <td>73058679.0</td>\n",
" <td>Action|Adventure|Sci-Fi</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>PG-13</td>\n",
" <td>263700000.0</td>\n",
" <td>2012-01-01</td>\n",
" <td>632.0</td>\n",
" <td>6.6</td>\n",
" <td>2.35</td>\n",
" <td>24000</td>\n",
" <td>-190641321.0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>Color</td>\n",
" <td>Sam Raimi</td>\n",
" <td>392.0</td>\n",
" <td>156.0</td>\n",
" <td>0.0</td>\n",
" <td>4000.0</td>\n",
" <td>James Franco</td>\n",
" <td>24000.0</td>\n",
" <td>336530303.0</td>\n",
" <td>Action|Adventure|Romance</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>PG-13</td>\n",
" <td>258000000.0</td>\n",
" <td>2007-01-01</td>\n",
" <td>11000.0</td>\n",
" <td>6.2</td>\n",
" <td>2.35</td>\n",
" <td>0</td>\n",
" <td>78530303.0</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>Color</td>\n",
" <td>Nathan Greno</td>\n",
" <td>324.0</td>\n",
" <td>100.0</td>\n",
" <td>15.0</td>\n",
" <td>284.0</td>\n",
" <td>Donna Murphy</td>\n",
" <td>799.0</td>\n",
" <td>200807262.0</td>\n",
" <td>Adventure|Animation|Comedy|Family|Fantasy|Musi...</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>PG</td>\n",
" <td>260000000.0</td>\n",
" <td>2010-01-01</td>\n",
" <td>553.0</td>\n",
" <td>7.8</td>\n",
" <td>1.85</td>\n",
" <td>29000</td>\n",
" <td>-59192738.0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>Color</td>\n",
" <td>Joss Whedon</td>\n",
" <td>635.0</td>\n",
" <td>141.0</td>\n",
" <td>0.0</td>\n",
" <td>19000.0</td>\n",
" <td>Robert Downey Jr.</td>\n",
" <td>26000.0</td>\n",
" <td>458991599.0</td>\n",
" <td>Action|Adventure|Sci-Fi</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>PG-13</td>\n",
" <td>250000000.0</td>\n",
" <td>2015-01-01</td>\n",
" <td>21000.0</td>\n",
" <td>7.5</td>\n",
" <td>2.35</td>\n",
" <td>118000</td>\n",
" <td>208991599.0</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>Color</td>\n",
" <td>David Yates</td>\n",
" <td>375.0</td>\n",
" <td>153.0</td>\n",
" <td>282.0</td>\n",
" <td>10000.0</td>\n",
" <td>Daniel Radcliffe</td>\n",
" <td>25000.0</td>\n",
" <td>301956980.0</td>\n",
" <td>Adventure|Family|Fantasy|Mystery</td>\n",
" <td>...</td>\n",
" <td>UK</td>\n",
" <td>PG</td>\n",
" <td>250000000.0</td>\n",
" <td>2009-01-01</td>\n",
" <td>11000.0</td>\n",
" <td>7.5</td>\n",
" <td>2.35</td>\n",
" <td>10000</td>\n",
" <td>51956980.0</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>Color</td>\n",
" <td>Zack Snyder</td>\n",
" <td>673.0</td>\n",
" <td>183.0</td>\n",
" <td>0.0</td>\n",
" <td>2000.0</td>\n",
" <td>Lauren Cohan</td>\n",
" <td>15000.0</td>\n",
" <td>330249062.0</td>\n",
" <td>Action|Adventure|Sci-Fi</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>PG-13</td>\n",
" <td>250000000.0</td>\n",
" <td>2016-01-01</td>\n",
" <td>4000.0</td>\n",
" <td>6.9</td>\n",
" <td>2.35</td>\n",
" <td>197000</td>\n",
" <td>80249062.0</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>Color</td>\n",
" <td>Bryan Singer</td>\n",
" <td>434.0</td>\n",
" <td>169.0</td>\n",
" <td>0.0</td>\n",
" <td>903.0</td>\n",
" <td>Marlon Brando</td>\n",
" <td>18000.0</td>\n",
" <td>200069408.0</td>\n",
" <td>Action|Adventure|Sci-Fi</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>PG-13</td>\n",
" <td>209000000.0</td>\n",
" <td>2006-01-01</td>\n",
" <td>10000.0</td>\n",
" <td>6.1</td>\n",
" <td>2.35</td>\n",
" <td>0</td>\n",
" <td>-8930592.0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>Color</td>\n",
" <td>Marc Forster</td>\n",
" <td>403.0</td>\n",
" <td>106.0</td>\n",
" <td>395.0</td>\n",
" <td>393.0</td>\n",
" <td>Mathieu Amalric</td>\n",
" <td>451.0</td>\n",
" <td>168368427.0</td>\n",
" <td>Action|Adventure</td>\n",
" <td>...</td>\n",
" <td>UK</td>\n",
" <td>PG-13</td>\n",
" <td>200000000.0</td>\n",
" <td>2008-01-01</td>\n",
" <td>412.0</td>\n",
" <td>6.7</td>\n",
" <td>2.35</td>\n",
" <td>0</td>\n",
" <td>-31631573.0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>Color</td>\n",
" <td>Gore Verbinski</td>\n",
" <td>313.0</td>\n",
" <td>151.0</td>\n",
" <td>563.0</td>\n",
" <td>1000.0</td>\n",
" <td>Orlando Bloom</td>\n",
" <td>40000.0</td>\n",
" <td>423032628.0</td>\n",
" <td>Action|Adventure|Fantasy</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>PG-13</td>\n",
" <td>225000000.0</td>\n",
" <td>2006-01-01</td>\n",
" <td>5000.0</td>\n",
" <td>7.3</td>\n",
" <td>2.35</td>\n",
" <td>5000</td>\n",
" <td>198032628.0</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>Color</td>\n",
" <td>Gore Verbinski</td>\n",
" <td>450.0</td>\n",
" <td>150.0</td>\n",
" <td>563.0</td>\n",
" <td>1000.0</td>\n",
" <td>Ruth Wilson</td>\n",
" <td>40000.0</td>\n",
" <td>89289910.0</td>\n",
" <td>Action|Adventure|Western</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>PG-13</td>\n",
" <td>215000000.0</td>\n",
" <td>2013-01-01</td>\n",
" <td>2000.0</td>\n",
" <td>6.5</td>\n",
" <td>2.35</td>\n",
" <td>48000</td>\n",
" <td>-125710090.0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>Color</td>\n",
" <td>Zack Snyder</td>\n",
" <td>733.0</td>\n",
" <td>143.0</td>\n",
" <td>0.0</td>\n",
" <td>748.0</td>\n",
" <td>Christopher Meloni</td>\n",
" <td>15000.0</td>\n",
" <td>291021565.0</td>\n",
" <td>Action|Adventure|Fantasy|Sci-Fi</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>PG-13</td>\n",
" <td>225000000.0</td>\n",
" <td>2013-01-01</td>\n",
" <td>3000.0</td>\n",
" <td>7.2</td>\n",
" <td>2.35</td>\n",
" <td>118000</td>\n",
" <td>66021565.0</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>Color</td>\n",
" <td>Andrew Adamson</td>\n",
" <td>258.0</td>\n",
" <td>150.0</td>\n",
" <td>80.0</td>\n",
" <td>201.0</td>\n",
" <td>Pierfrancesco Favino</td>\n",
" <td>22000.0</td>\n",
" <td>141614023.0</td>\n",
" <td>Action|Adventure|Family|Fantasy</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>PG</td>\n",
" <td>225000000.0</td>\n",
" <td>2008-01-01</td>\n",
" <td>216.0</td>\n",
" <td>6.6</td>\n",
" <td>2.35</td>\n",
" <td>0</td>\n",
" <td>-83385977.0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>Color</td>\n",
" <td>Joss Whedon</td>\n",
" <td>703.0</td>\n",
" <td>173.0</td>\n",
" <td>0.0</td>\n",
" <td>19000.0</td>\n",
" <td>Robert Downey Jr.</td>\n",
" <td>26000.0</td>\n",
" <td>623279547.0</td>\n",
" <td>Action|Adventure|Sci-Fi</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>PG-13</td>\n",
" <td>220000000.0</td>\n",
" <td>2012-01-01</td>\n",
" <td>21000.0</td>\n",
" <td>8.1</td>\n",
" <td>1.85</td>\n",
" <td>123000</td>\n",
" <td>403279547.0</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>Color</td>\n",
" <td>Rob Marshall</td>\n",
" <td>448.0</td>\n",
" <td>136.0</td>\n",
" <td>252.0</td>\n",
" <td>1000.0</td>\n",
" <td>Sam Claflin</td>\n",
" <td>40000.0</td>\n",
" <td>241063875.0</td>\n",
" <td>Action|Adventure|Fantasy</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>PG-13</td>\n",
" <td>250000000.0</td>\n",
" <td>2011-01-01</td>\n",
" <td>11000.0</td>\n",
" <td>6.7</td>\n",
" <td>2.35</td>\n",
" <td>58000</td>\n",
" <td>-8936125.0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>Color</td>\n",
" <td>Barry Sonnenfeld</td>\n",
" <td>451.0</td>\n",
" <td>106.0</td>\n",
" <td>188.0</td>\n",
" <td>718.0</td>\n",
" <td>Michael Stuhlbarg</td>\n",
" <td>10000.0</td>\n",
" <td>179020854.0</td>\n",
" <td>Action|Adventure|Comedy|Family|Fantasy|Sci-Fi</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>PG-13</td>\n",
" <td>225000000.0</td>\n",
" <td>2012-01-01</td>\n",
" <td>816.0</td>\n",
" <td>6.8</td>\n",
" <td>1.85</td>\n",
" <td>40000</td>\n",
" <td>-45979146.0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>Color</td>\n",
" <td>Peter Jackson</td>\n",
" <td>422.0</td>\n",
" <td>164.0</td>\n",
" <td>0.0</td>\n",
" <td>773.0</td>\n",
" <td>Adam Brown</td>\n",
" <td>5000.0</td>\n",
" <td>255108370.0</td>\n",
" <td>Adventure|Fantasy</td>\n",
" <td>...</td>\n",
" <td>New Zealand</td>\n",
" <td>PG-13</td>\n",
" <td>250000000.0</td>\n",
" <td>2014-01-01</td>\n",
" <td>972.0</td>\n",
" <td>7.5</td>\n",
" <td>2.35</td>\n",
" <td>65000</td>\n",
" <td>5108370.0</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>Color</td>\n",
" <td>Marc Webb</td>\n",
" <td>599.0</td>\n",
" <td>153.0</td>\n",
" <td>464.0</td>\n",
" <td>963.0</td>\n",
" <td>Andrew Garfield</td>\n",
" <td>15000.0</td>\n",
" <td>262030663.0</td>\n",
" <td>Action|Adventure|Fantasy</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>PG-13</td>\n",
" <td>230000000.0</td>\n",
" <td>2012-01-01</td>\n",
" <td>10000.0</td>\n",
" <td>7.0</td>\n",
" <td>2.35</td>\n",
" <td>56000</td>\n",
" <td>32030663.0</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>Color</td>\n",
" <td>Ridley Scott</td>\n",
" <td>343.0</td>\n",
" <td>156.0</td>\n",
" <td>0.0</td>\n",
" <td>738.0</td>\n",
" <td>William Hurt</td>\n",
" <td>891.0</td>\n",
" <td>105219735.0</td>\n",
" <td>Action|Adventure|Drama|History</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>PG-13</td>\n",
" <td>200000000.0</td>\n",
" <td>2010-01-01</td>\n",
" <td>882.0</td>\n",
" <td>6.7</td>\n",
" <td>2.35</td>\n",
" <td>17000</td>\n",
" <td>-94780265.0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>Color</td>\n",
" <td>Peter Jackson</td>\n",
" <td>509.0</td>\n",
" <td>186.0</td>\n",
" <td>0.0</td>\n",
" <td>773.0</td>\n",
" <td>Adam Brown</td>\n",
" <td>5000.0</td>\n",
" <td>258355354.0</td>\n",
" <td>Adventure|Fantasy</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>PG-13</td>\n",
" <td>225000000.0</td>\n",
" <td>2013-01-01</td>\n",
" <td>972.0</td>\n",
" <td>7.9</td>\n",
" <td>2.35</td>\n",
" <td>83000</td>\n",
" <td>33355354.0</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>Color</td>\n",
" <td>Chris Weitz</td>\n",
" <td>251.0</td>\n",
" <td>113.0</td>\n",
" <td>129.0</td>\n",
" <td>1000.0</td>\n",
" <td>Eva Green</td>\n",
" <td>16000.0</td>\n",
" <td>70083519.0</td>\n",
" <td>Adventure|Family|Fantasy</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>PG-13</td>\n",
" <td>180000000.0</td>\n",
" <td>2007-01-01</td>\n",
" <td>6000.0</td>\n",
" <td>6.1</td>\n",
" <td>2.35</td>\n",
" <td>0</td>\n",
" <td>-109916481.0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>Color</td>\n",
" <td>Peter Jackson</td>\n",
" <td>446.0</td>\n",
" <td>201.0</td>\n",
" <td>0.0</td>\n",
" <td>84.0</td>\n",
" <td>Thomas Kretschmann</td>\n",
" <td>6000.0</td>\n",
" <td>218051260.0</td>\n",
" <td>Action|Adventure|Drama|Romance</td>\n",
" <td>...</td>\n",
" <td>New Zealand</td>\n",
" <td>PG-13</td>\n",
" <td>207000000.0</td>\n",
" <td>2005-01-01</td>\n",
" <td>919.0</td>\n",
" <td>7.2</td>\n",
" <td>2.35</td>\n",
" <td>0</td>\n",
" <td>11051260.0</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>Color</td>\n",
" <td>James Cameron</td>\n",
" <td>315.0</td>\n",
" <td>194.0</td>\n",
" <td>0.0</td>\n",
" <td>794.0</td>\n",
" <td>Kate Winslet</td>\n",
" <td>29000.0</td>\n",
" <td>658672302.0</td>\n",
" <td>Drama|Romance</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>PG-13</td>\n",
" <td>200000000.0</td>\n",
" <td>1997-01-01</td>\n",
" <td>14000.0</td>\n",
" <td>7.7</td>\n",
" <td>2.35</td>\n",
" <td>26000</td>\n",
" <td>458672302.0</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>Color</td>\n",
" <td>Anthony Russo</td>\n",
" <td>516.0</td>\n",
" <td>147.0</td>\n",
" <td>94.0</td>\n",
" <td>11000.0</td>\n",
" <td>Scarlett Johansson</td>\n",
" <td>21000.0</td>\n",
" <td>407197282.0</td>\n",
" <td>Action|Adventure|Sci-Fi</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>PG-13</td>\n",
" <td>250000000.0</td>\n",
" <td>2016-01-01</td>\n",
" <td>19000.0</td>\n",
" <td>8.2</td>\n",
" <td>2.35</td>\n",
" <td>72000</td>\n",
" <td>157197282.0</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>Color</td>\n",
" <td>Peter Berg</td>\n",
" <td>377.0</td>\n",
" <td>131.0</td>\n",
" <td>532.0</td>\n",
" <td>627.0</td>\n",
" <td>Alexander Skarsgård</td>\n",
" <td>14000.0</td>\n",
" <td>65173160.0</td>\n",
" <td>Action|Adventure|Sci-Fi|Thriller</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>PG-13</td>\n",
" <td>209000000.0</td>\n",
" <td>2012-01-01</td>\n",
" <td>10000.0</td>\n",
" <td>5.9</td>\n",
" <td>2.35</td>\n",
" <td>44000</td>\n",
" <td>-143826840.0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>Color</td>\n",
" <td>Colin Trevorrow</td>\n",
" <td>644.0</td>\n",
" <td>124.0</td>\n",
" <td>365.0</td>\n",
" <td>1000.0</td>\n",
" <td>Judy Greer</td>\n",
" <td>3000.0</td>\n",
" <td>652177271.0</td>\n",
" <td>Action|Adventure|Sci-Fi|Thriller</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>PG-13</td>\n",
" <td>150000000.0</td>\n",
" <td>2015-01-01</td>\n",
" <td>2000.0</td>\n",
" <td>7.0</td>\n",
" <td>2.00</td>\n",
" <td>150000</td>\n",
" <td>502177271.0</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5013</th>\n",
" <td>Color</td>\n",
" <td>Eric Eason</td>\n",
" <td>28.0</td>\n",
" <td>79.0</td>\n",
" <td>3.0</td>\n",
" <td>42.0</td>\n",
" <td>Panchito Gómez</td>\n",
" <td>93.0</td>\n",
" <td>NaN</td>\n",
" <td>Drama|Family</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>NaN</td>\n",
" <td>24000.0</td>\n",
" <td>2002-01-01</td>\n",
" <td>46.0</td>\n",
" <td>7.0</td>\n",
" <td>1.78</td>\n",
" <td>61</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5014</th>\n",
" <td>Color</td>\n",
" <td>Uwe Boll</td>\n",
" <td>58.0</td>\n",
" <td>80.0</td>\n",
" <td>892.0</td>\n",
" <td>492.0</td>\n",
" <td>Katharine Isabelle</td>\n",
" <td>986.0</td>\n",
" <td>NaN</td>\n",
" <td>Action|Crime|Thriller</td>\n",
" <td>...</td>\n",
" <td>Canada</td>\n",
" <td>R</td>\n",
" <td>NaN</td>\n",
" <td>2009-01-01</td>\n",
" <td>918.0</td>\n",
" <td>6.3</td>\n",
" <td>2.35</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5015</th>\n",
" <td>Black and White</td>\n",
" <td>Richard Linklater</td>\n",
" <td>61.0</td>\n",
" <td>100.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>Richard Linklater</td>\n",
" <td>5.0</td>\n",
" <td>1227508.0</td>\n",
" <td>Comedy|Drama</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>R</td>\n",
" <td>23000.0</td>\n",
" <td>1991-01-01</td>\n",
" <td>0.0</td>\n",
" <td>7.1</td>\n",
" <td>1.37</td>\n",
" <td>2000</td>\n",
" <td>1204508.0</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5016</th>\n",
" <td>Color</td>\n",
" <td>Joseph Mazzella</td>\n",
" <td>NaN</td>\n",
" <td>90.0</td>\n",
" <td>0.0</td>\n",
" <td>9.0</td>\n",
" <td>Mikaal Bates</td>\n",
" <td>313.0</td>\n",
" <td>NaN</td>\n",
" <td>Crime|Drama|Thriller</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>NaN</td>\n",
" <td>25000.0</td>\n",
" <td>2015-01-01</td>\n",
" <td>25.0</td>\n",
" <td>4.8</td>\n",
" <td>NaN</td>\n",
" <td>33</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5017</th>\n",
" <td>Color</td>\n",
" <td>Travis Legge</td>\n",
" <td>1.0</td>\n",
" <td>90.0</td>\n",
" <td>138.0</td>\n",
" <td>138.0</td>\n",
" <td>Suzi Lorraine</td>\n",
" <td>370.0</td>\n",
" <td>NaN</td>\n",
" <td>Comedy|Romance</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>NaN</td>\n",
" <td>22000.0</td>\n",
" <td>2013-01-01</td>\n",
" <td>184.0</td>\n",
" <td>3.3</td>\n",
" <td>1.78</td>\n",
" <td>200</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5018</th>\n",
" <td>Color</td>\n",
" <td>Alex Kendrick</td>\n",
" <td>5.0</td>\n",
" <td>120.0</td>\n",
" <td>589.0</td>\n",
" <td>4.0</td>\n",
" <td>Lisa Arnold</td>\n",
" <td>51.0</td>\n",
" <td>NaN</td>\n",
" <td>Drama</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>NaN</td>\n",
" <td>20000.0</td>\n",
" <td>2003-01-01</td>\n",
" <td>49.0</td>\n",
" <td>6.9</td>\n",
" <td>1.85</td>\n",
" <td>725</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5019</th>\n",
" <td>Color</td>\n",
" <td>Marcus Nispel</td>\n",
" <td>43.0</td>\n",
" <td>91.0</td>\n",
" <td>158.0</td>\n",
" <td>265.0</td>\n",
" <td>Brittany Curran</td>\n",
" <td>630.0</td>\n",
" <td>NaN</td>\n",
" <td>Horror|Mystery|Thriller</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>R</td>\n",
" <td>NaN</td>\n",
" <td>2015-01-01</td>\n",
" <td>512.0</td>\n",
" <td>4.6</td>\n",
" <td>1.85</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5020</th>\n",
" <td>NaN</td>\n",
" <td>Brandon Landers</td>\n",
" <td>NaN</td>\n",
" <td>143.0</td>\n",
" <td>8.0</td>\n",
" <td>8.0</td>\n",
" <td>Alana Kaniewski</td>\n",
" <td>720.0</td>\n",
" <td>NaN</td>\n",
" <td>Drama|Horror|Thriller</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>NaN</td>\n",
" <td>17350.0</td>\n",
" <td>2011-01-01</td>\n",
" <td>19.0</td>\n",
" <td>3.0</td>\n",
" <td>NaN</td>\n",
" <td>33</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5021</th>\n",
" <td>Color</td>\n",
" <td>Jay Duplass</td>\n",
" <td>51.0</td>\n",
" <td>85.0</td>\n",
" <td>157.0</td>\n",
" <td>10.0</td>\n",
" <td>Katie Aselton</td>\n",
" <td>830.0</td>\n",
" <td>192467.0</td>\n",
" <td>Comedy|Drama|Romance</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>R</td>\n",
" <td>15000.0</td>\n",
" <td>2005-01-01</td>\n",
" <td>224.0</td>\n",
" <td>6.6</td>\n",
" <td>NaN</td>\n",
" <td>297</td>\n",
" <td>177467.0</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5022</th>\n",
" <td>Black and White</td>\n",
" <td>Jim Chuchu</td>\n",
" <td>6.0</td>\n",
" <td>60.0</td>\n",
" <td>0.0</td>\n",
" <td>4.0</td>\n",
" <td>Olwenya Maina</td>\n",
" <td>147.0</td>\n",
" <td>NaN</td>\n",
" <td>Drama</td>\n",
" <td>...</td>\n",
" <td>Kenya</td>\n",
" <td>NaN</td>\n",
" <td>15000.0</td>\n",
" <td>2014-01-01</td>\n",
" <td>19.0</td>\n",
" <td>7.4</td>\n",
" <td>NaN</td>\n",
" <td>45</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5023</th>\n",
" <td>Color</td>\n",
" <td>Daryl Wein</td>\n",
" <td>22.0</td>\n",
" <td>88.0</td>\n",
" <td>38.0</td>\n",
" <td>211.0</td>\n",
" <td>Heather Burns</td>\n",
" <td>331.0</td>\n",
" <td>76382.0</td>\n",
" <td>Romance</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>NaN</td>\n",
" <td>15000.0</td>\n",
" <td>2009-01-01</td>\n",
" <td>212.0</td>\n",
" <td>6.2</td>\n",
" <td>2.35</td>\n",
" <td>324</td>\n",
" <td>61382.0</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5024</th>\n",
" <td>Color</td>\n",
" <td>Jason Trost</td>\n",
" <td>42.0</td>\n",
" <td>78.0</td>\n",
" <td>91.0</td>\n",
" <td>86.0</td>\n",
" <td>Jason Trost</td>\n",
" <td>407.0</td>\n",
" <td>NaN</td>\n",
" <td>Sci-Fi|Thriller</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>Unrated</td>\n",
" <td>20000.0</td>\n",
" <td>2011-01-01</td>\n",
" <td>91.0</td>\n",
" <td>4.0</td>\n",
" <td>2.35</td>\n",
" <td>835</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5025</th>\n",
" <td>Color</td>\n",
" <td>John Waters</td>\n",
" <td>73.0</td>\n",
" <td>108.0</td>\n",
" <td>0.0</td>\n",
" <td>105.0</td>\n",
" <td>Mink Stole</td>\n",
" <td>462.0</td>\n",
" <td>180483.0</td>\n",
" <td>Comedy|Crime|Horror</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>NC-17</td>\n",
" <td>10000.0</td>\n",
" <td>1972-01-01</td>\n",
" <td>143.0</td>\n",
" <td>6.1</td>\n",
" <td>1.37</td>\n",
" <td>0</td>\n",
" <td>170483.0</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5026</th>\n",
" <td>Color</td>\n",
" <td>Olivier Assayas</td>\n",
" <td>81.0</td>\n",
" <td>110.0</td>\n",
" <td>107.0</td>\n",
" <td>45.0</td>\n",
" <td>Béatrice Dalle</td>\n",
" <td>576.0</td>\n",
" <td>136007.0</td>\n",
" <td>Drama|Music|Romance</td>\n",
" <td>...</td>\n",
" <td>France</td>\n",
" <td>R</td>\n",
" <td>4500.0</td>\n",
" <td>2004-01-01</td>\n",
" <td>133.0</td>\n",
" <td>6.9</td>\n",
" <td>2.35</td>\n",
" <td>171</td>\n",
" <td>131507.0</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5027</th>\n",
" <td>Color</td>\n",
" <td>Jafar Panahi</td>\n",
" <td>64.0</td>\n",
" <td>90.0</td>\n",
" <td>397.0</td>\n",
" <td>0.0</td>\n",
" <td>Nargess Mamizadeh</td>\n",
" <td>5.0</td>\n",
" <td>673780.0</td>\n",
" <td>Drama</td>\n",
" <td>...</td>\n",
" <td>Iran</td>\n",
" <td>Not Rated</td>\n",
" <td>10000.0</td>\n",
" <td>2000-01-01</td>\n",
" <td>0.0</td>\n",
" <td>7.5</td>\n",
" <td>1.85</td>\n",
" <td>697</td>\n",
" <td>663780.0</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5028</th>\n",
" <td>Black and White</td>\n",
" <td>Ivan Kavanagh</td>\n",
" <td>12.0</td>\n",
" <td>83.0</td>\n",
" <td>18.0</td>\n",
" <td>0.0</td>\n",
" <td>Michael Parle</td>\n",
" <td>10.0</td>\n",
" <td>NaN</td>\n",
" <td>Horror</td>\n",
" <td>...</td>\n",
" <td>Ireland</td>\n",
" <td>NaN</td>\n",
" <td>10000.0</td>\n",
" <td>2007-01-01</td>\n",
" <td>5.0</td>\n",
" <td>6.7</td>\n",
" <td>1.33</td>\n",
" <td>105</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5029</th>\n",
" <td>Color</td>\n",
" <td>Kiyoshi Kurosawa</td>\n",
" <td>78.0</td>\n",
" <td>111.0</td>\n",
" <td>62.0</td>\n",
" <td>6.0</td>\n",
" <td>Anna Nakagawa</td>\n",
" <td>89.0</td>\n",
" <td>94596.0</td>\n",
" <td>Crime|Horror|Mystery|Thriller</td>\n",
" <td>...</td>\n",
" <td>Japan</td>\n",
" <td>NaN</td>\n",
" <td>1000000.0</td>\n",
" <td>1997-01-01</td>\n",
" <td>13.0</td>\n",
" <td>7.4</td>\n",
" <td>1.85</td>\n",
" <td>817</td>\n",
" <td>-905404.0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5030</th>\n",
" <td>Color</td>\n",
" <td>Tadeo Garcia</td>\n",
" <td>NaN</td>\n",
" <td>84.0</td>\n",
" <td>5.0</td>\n",
" <td>12.0</td>\n",
" <td>Michael Cortez</td>\n",
" <td>21.0</td>\n",
" <td>NaN</td>\n",
" <td>Drama</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2004-01-01</td>\n",
" <td>20.0</td>\n",
" <td>6.1</td>\n",
" <td>NaN</td>\n",
" <td>22</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5031</th>\n",
" <td>Color</td>\n",
" <td>Thomas L. Phillips</td>\n",
" <td>13.0</td>\n",
" <td>82.0</td>\n",
" <td>120.0</td>\n",
" <td>84.0</td>\n",
" <td>Joe Coffey</td>\n",
" <td>785.0</td>\n",
" <td>NaN</td>\n",
" <td>Comedy|Horror|Thriller</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>NaN</td>\n",
" <td>200000.0</td>\n",
" <td>2012-01-01</td>\n",
" <td>98.0</td>\n",
" <td>5.4</td>\n",
" <td>16.00</td>\n",
" <td>424</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5032</th>\n",
" <td>Color</td>\n",
" <td>Ash Baron-Cohen</td>\n",
" <td>10.0</td>\n",
" <td>98.0</td>\n",
" <td>3.0</td>\n",
" <td>152.0</td>\n",
" <td>Stanley B. Herman</td>\n",
" <td>789.0</td>\n",
" <td>NaN</td>\n",
" <td>Crime|Drama</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>1995-01-01</td>\n",
" <td>194.0</td>\n",
" <td>6.4</td>\n",
" <td>NaN</td>\n",
" <td>20</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5033</th>\n",
" <td>Color</td>\n",
" <td>Shane Carruth</td>\n",
" <td>143.0</td>\n",
" <td>77.0</td>\n",
" <td>291.0</td>\n",
" <td>8.0</td>\n",
" <td>David Sullivan</td>\n",
" <td>291.0</td>\n",
" <td>424760.0</td>\n",
" <td>Drama|Sci-Fi|Thriller</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>PG-13</td>\n",
" <td>7000.0</td>\n",
" <td>2004-01-01</td>\n",
" <td>45.0</td>\n",
" <td>7.0</td>\n",
" <td>1.85</td>\n",
" <td>19000</td>\n",
" <td>417760.0</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5034</th>\n",
" <td>Color</td>\n",
" <td>Neill Dela Llana</td>\n",
" <td>35.0</td>\n",
" <td>80.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>Edgar Tancangco</td>\n",
" <td>0.0</td>\n",
" <td>70071.0</td>\n",
" <td>Thriller</td>\n",
" <td>...</td>\n",
" <td>Philippines</td>\n",
" <td>Not Rated</td>\n",
" <td>7000.0</td>\n",
" <td>2005-01-01</td>\n",
" <td>0.0</td>\n",
" <td>6.3</td>\n",
" <td>NaN</td>\n",
" <td>74</td>\n",
" <td>63071.0</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5035</th>\n",
" <td>Color</td>\n",
" <td>Robert Rodriguez</td>\n",
" <td>56.0</td>\n",
" <td>81.0</td>\n",
" <td>0.0</td>\n",
" <td>6.0</td>\n",
" <td>Peter Marquardt</td>\n",
" <td>121.0</td>\n",
" <td>2040920.0</td>\n",
" <td>Action|Crime|Drama|Romance|Thriller</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>R</td>\n",
" <td>7000.0</td>\n",
" <td>1992-01-01</td>\n",
" <td>20.0</td>\n",
" <td>6.9</td>\n",
" <td>1.37</td>\n",
" <td>0</td>\n",
" <td>2033920.0</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5036</th>\n",
" <td>Color</td>\n",
" <td>Anthony Vallone</td>\n",
" <td>NaN</td>\n",
" <td>84.0</td>\n",
" <td>2.0</td>\n",
" <td>2.0</td>\n",
" <td>John Considine</td>\n",
" <td>45.0</td>\n",
" <td>NaN</td>\n",
" <td>Crime|Drama</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>PG-13</td>\n",
" <td>3250.0</td>\n",
" <td>2005-01-01</td>\n",
" <td>44.0</td>\n",
" <td>7.8</td>\n",
" <td>NaN</td>\n",
" <td>4</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5037</th>\n",
" <td>Color</td>\n",
" <td>Edward Burns</td>\n",
" <td>14.0</td>\n",
" <td>95.0</td>\n",
" <td>0.0</td>\n",
" <td>133.0</td>\n",
" <td>Caitlin FitzGerald</td>\n",
" <td>296.0</td>\n",
" <td>4584.0</td>\n",
" <td>Comedy|Drama</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>Not Rated</td>\n",
" <td>9000.0</td>\n",
" <td>2011-01-01</td>\n",
" <td>205.0</td>\n",
" <td>6.4</td>\n",
" <td>NaN</td>\n",
" <td>413</td>\n",
" <td>-4416.0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5038</th>\n",
" <td>Color</td>\n",
" <td>Scott Smith</td>\n",
" <td>1.0</td>\n",
" <td>87.0</td>\n",
" <td>2.0</td>\n",
" <td>318.0</td>\n",
" <td>Daphne Zuniga</td>\n",
" <td>637.0</td>\n",
" <td>NaN</td>\n",
" <td>Comedy|Drama</td>\n",
" <td>...</td>\n",
" <td>Canada</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2013-01-01</td>\n",
" <td>470.0</td>\n",
" <td>7.7</td>\n",
" <td>NaN</td>\n",
" <td>84</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5039</th>\n",
" <td>Color</td>\n",
" <td>NaN</td>\n",
" <td>43.0</td>\n",
" <td>43.0</td>\n",
" <td>NaN</td>\n",
" <td>319.0</td>\n",
" <td>Valorie Curry</td>\n",
" <td>841.0</td>\n",
" <td>NaN</td>\n",
" <td>Crime|Drama|Mystery|Thriller</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>TV-14</td>\n",
" <td>NaN</td>\n",
" <td>NaT</td>\n",
" <td>593.0</td>\n",
" <td>7.5</td>\n",
" <td>16.00</td>\n",
" <td>32000</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5040</th>\n",
" <td>Color</td>\n",
" <td>Benjamin Roberds</td>\n",
" <td>13.0</td>\n",
" <td>76.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>Maxwell Moody</td>\n",
" <td>0.0</td>\n",
" <td>NaN</td>\n",
" <td>Drama|Horror|Thriller</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>NaN</td>\n",
" <td>1400.0</td>\n",
" <td>2013-01-01</td>\n",
" <td>0.0</td>\n",
" <td>6.3</td>\n",
" <td>NaN</td>\n",
" <td>16</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5041</th>\n",
" <td>Color</td>\n",
" <td>Daniel Hsia</td>\n",
" <td>14.0</td>\n",
" <td>100.0</td>\n",
" <td>0.0</td>\n",
" <td>489.0</td>\n",
" <td>Daniel Henney</td>\n",
" <td>946.0</td>\n",
" <td>10443.0</td>\n",
" <td>Comedy|Drama|Romance</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>PG-13</td>\n",
" <td>NaN</td>\n",
" <td>2012-01-01</td>\n",
" <td>719.0</td>\n",
" <td>6.3</td>\n",
" <td>2.35</td>\n",
" <td>660</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5042</th>\n",
" <td>Color</td>\n",
" <td>Jon Gunn</td>\n",
" <td>43.0</td>\n",
" <td>90.0</td>\n",
" <td>16.0</td>\n",
" <td>16.0</td>\n",
" <td>Brian Herzlinger</td>\n",
" <td>86.0</td>\n",
" <td>85222.0</td>\n",
" <td>Documentary</td>\n",
" <td>...</td>\n",
" <td>USA</td>\n",
" <td>PG</td>\n",
" <td>1100.0</td>\n",
" <td>2004-01-01</td>\n",
" <td>23.0</td>\n",
" <td>6.6</td>\n",
" <td>1.85</td>\n",
" <td>456</td>\n",
" <td>84122.0</td>\n",
" <td>1</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>5043 rows × 30 columns</p>\n",
"</div>"
],
"text/plain": [
" color director_name num_critic_for_reviews duration \\\n",
"0 Color James Cameron 723.0 178.0 \n",
"1 Color Gore Verbinski 302.0 169.0 \n",
"2 Color Sam Mendes 602.0 148.0 \n",
"3 Color Christopher Nolan 813.0 164.0 \n",
"4 NaN Doug Walker NaN NaN \n",
"5 Color Andrew Stanton 462.0 132.0 \n",
"6 Color Sam Raimi 392.0 156.0 \n",
"7 Color Nathan Greno 324.0 100.0 \n",
"8 Color Joss Whedon 635.0 141.0 \n",
"9 Color David Yates 375.0 153.0 \n",
"10 Color Zack Snyder 673.0 183.0 \n",
"11 Color Bryan Singer 434.0 169.0 \n",
"12 Color Marc Forster 403.0 106.0 \n",
"13 Color Gore Verbinski 313.0 151.0 \n",
"14 Color Gore Verbinski 450.0 150.0 \n",
"15 Color Zack Snyder 733.0 143.0 \n",
"16 Color Andrew Adamson 258.0 150.0 \n",
"17 Color Joss Whedon 703.0 173.0 \n",
"18 Color Rob Marshall 448.0 136.0 \n",
"19 Color Barry Sonnenfeld 451.0 106.0 \n",
"20 Color Peter Jackson 422.0 164.0 \n",
"21 Color Marc Webb 599.0 153.0 \n",
"22 Color Ridley Scott 343.0 156.0 \n",
"23 Color Peter Jackson 509.0 186.0 \n",
"24 Color Chris Weitz 251.0 113.0 \n",
"25 Color Peter Jackson 446.0 201.0 \n",
"26 Color James Cameron 315.0 194.0 \n",
"27 Color Anthony Russo 516.0 147.0 \n",
"28 Color Peter Berg 377.0 131.0 \n",
"29 Color Colin Trevorrow 644.0 124.0 \n",
"... ... ... ... ... \n",
"5013 Color Eric Eason 28.0 79.0 \n",
"5014 Color Uwe Boll 58.0 80.0 \n",
"5015 Black and White Richard Linklater 61.0 100.0 \n",
"5016 Color Joseph Mazzella NaN 90.0 \n",
"5017 Color Travis Legge 1.0 90.0 \n",
"5018 Color Alex Kendrick 5.0 120.0 \n",
"5019 Color Marcus Nispel 43.0 91.0 \n",
"5020 NaN Brandon Landers NaN 143.0 \n",
"5021 Color Jay Duplass 51.0 85.0 \n",
"5022 Black and White Jim Chuchu 6.0 60.0 \n",
"5023 Color Daryl Wein 22.0 88.0 \n",
"5024 Color Jason Trost 42.0 78.0 \n",
"5025 Color John Waters 73.0 108.0 \n",
"5026 Color Olivier Assayas 81.0 110.0 \n",
"5027 Color Jafar Panahi 64.0 90.0 \n",
"5028 Black and White Ivan Kavanagh 12.0 83.0 \n",
"5029 Color Kiyoshi Kurosawa 78.0 111.0 \n",
"5030 Color Tadeo Garcia NaN 84.0 \n",
"5031 Color Thomas L. Phillips 13.0 82.0 \n",
"5032 Color Ash Baron-Cohen 10.0 98.0 \n",
"5033 Color Shane Carruth 143.0 77.0 \n",
"5034 Color Neill Dela Llana 35.0 80.0 \n",
"5035 Color Robert Rodriguez 56.0 81.0 \n",
"5036 Color Anthony Vallone NaN 84.0 \n",
"5037 Color Edward Burns 14.0 95.0 \n",
"5038 Color Scott Smith 1.0 87.0 \n",
"5039 Color NaN 43.0 43.0 \n",
"5040 Color Benjamin Roberds 13.0 76.0 \n",
"5041 Color Daniel Hsia 14.0 100.0 \n",
"5042 Color Jon Gunn 43.0 90.0 \n",
"\n",
" director_facebook_likes actor_3_facebook_likes actor_2_name \\\n",
"0 0.0 855.0 Joel David Moore \n",
"1 563.0 1000.0 Orlando Bloom \n",
"2 0.0 161.0 Rory Kinnear \n",
"3 22000.0 23000.0 Christian Bale \n",
"4 131.0 NaN Rob Walker \n",
"5 475.0 530.0 Samantha Morton \n",
"6 0.0 4000.0 James Franco \n",
"7 15.0 284.0 Donna Murphy \n",
"8 0.0 19000.0 Robert Downey Jr. \n",
"9 282.0 10000.0 Daniel Radcliffe \n",
"10 0.0 2000.0 Lauren Cohan \n",
"11 0.0 903.0 Marlon Brando \n",
"12 395.0 393.0 Mathieu Amalric \n",
"13 563.0 1000.0 Orlando Bloom \n",
"14 563.0 1000.0 Ruth Wilson \n",
"15 0.0 748.0 Christopher Meloni \n",
"16 80.0 201.0 Pierfrancesco Favino \n",
"17 0.0 19000.0 Robert Downey Jr. \n",
"18 252.0 1000.0 Sam Claflin \n",
"19 188.0 718.0 Michael Stuhlbarg \n",
"20 0.0 773.0 Adam Brown \n",
"21 464.0 963.0 Andrew Garfield \n",
"22 0.0 738.0 William Hurt \n",
"23 0.0 773.0 Adam Brown \n",
"24 129.0 1000.0 Eva Green \n",
"25 0.0 84.0 Thomas Kretschmann \n",
"26 0.0 794.0 Kate Winslet \n",
"27 94.0 11000.0 Scarlett Johansson \n",
"28 532.0 627.0 Alexander Skarsgård \n",
"29 365.0 1000.0 Judy Greer \n",
"... ... ... ... \n",
"5013 3.0 42.0 Panchito Gómez \n",
"5014 892.0 492.0 Katharine Isabelle \n",
"5015 0.0 0.0 Richard Linklater \n",
"5016 0.0 9.0 Mikaal Bates \n",
"5017 138.0 138.0 Suzi Lorraine \n",
"5018 589.0 4.0 Lisa Arnold \n",
"5019 158.0 265.0 Brittany Curran \n",
"5020 8.0 8.0 Alana Kaniewski \n",
"5021 157.0 10.0 Katie Aselton \n",
"5022 0.0 4.0 Olwenya Maina \n",
"5023 38.0 211.0 Heather Burns \n",
"5024 91.0 86.0 Jason Trost \n",
"5025 0.0 105.0 Mink Stole \n",
"5026 107.0 45.0 Béatrice Dalle \n",
"5027 397.0 0.0 Nargess Mamizadeh \n",
"5028 18.0 0.0 Michael Parle \n",
"5029 62.0 6.0 Anna Nakagawa \n",
"5030 5.0 12.0 Michael Cortez \n",
"5031 120.0 84.0 Joe Coffey \n",
"5032 3.0 152.0 Stanley B. Herman \n",
"5033 291.0 8.0 David Sullivan \n",
"5034 0.0 0.0 Edgar Tancangco \n",
"5035 0.0 6.0 Peter Marquardt \n",
"5036 2.0 2.0 John Considine \n",
"5037 0.0 133.0 Caitlin FitzGerald \n",
"5038 2.0 318.0 Daphne Zuniga \n",
"5039 NaN 319.0 Valorie Curry \n",
"5040 0.0 0.0 Maxwell Moody \n",
"5041 0.0 489.0 Daniel Henney \n",
"5042 16.0 16.0 Brian Herzlinger \n",
"\n",
" actor_1_facebook_likes gross \\\n",
"0 1000.0 760505847.0 \n",
"1 40000.0 309404152.0 \n",
"2 11000.0 200074175.0 \n",
"3 27000.0 448130642.0 \n",
"4 131.0 NaN \n",
"5 640.0 73058679.0 \n",
"6 24000.0 336530303.0 \n",
"7 799.0 200807262.0 \n",
"8 26000.0 458991599.0 \n",
"9 25000.0 301956980.0 \n",
"10 15000.0 330249062.0 \n",
"11 18000.0 200069408.0 \n",
"12 451.0 168368427.0 \n",
"13 40000.0 423032628.0 \n",
"14 40000.0 89289910.0 \n",
"15 15000.0 291021565.0 \n",
"16 22000.0 141614023.0 \n",
"17 26000.0 623279547.0 \n",
"18 40000.0 241063875.0 \n",
"19 10000.0 179020854.0 \n",
"20 5000.0 255108370.0 \n",
"21 15000.0 262030663.0 \n",
"22 891.0 105219735.0 \n",
"23 5000.0 258355354.0 \n",
"24 16000.0 70083519.0 \n",
"25 6000.0 218051260.0 \n",
"26 29000.0 658672302.0 \n",
"27 21000.0 407197282.0 \n",
"28 14000.0 65173160.0 \n",
"29 3000.0 652177271.0 \n",
"... ... ... \n",
"5013 93.0 NaN \n",
"5014 986.0 NaN \n",
"5015 5.0 1227508.0 \n",
"5016 313.0 NaN \n",
"5017 370.0 NaN \n",
"5018 51.0 NaN \n",
"5019 630.0 NaN \n",
"5020 720.0 NaN \n",
"5021 830.0 192467.0 \n",
"5022 147.0 NaN \n",
"5023 331.0 76382.0 \n",
"5024 407.0 NaN \n",
"5025 462.0 180483.0 \n",
"5026 576.0 136007.0 \n",
"5027 5.0 673780.0 \n",
"5028 10.0 NaN \n",
"5029 89.0 94596.0 \n",
"5030 21.0 NaN \n",
"5031 785.0 NaN \n",
"5032 789.0 NaN \n",
"5033 291.0 424760.0 \n",
"5034 0.0 70071.0 \n",
"5035 121.0 2040920.0 \n",
"5036 45.0 NaN \n",
"5037 296.0 4584.0 \n",
"5038 637.0 NaN \n",
"5039 841.0 NaN \n",
"5040 0.0 NaN \n",
"5041 946.0 10443.0 \n",
"5042 86.0 85222.0 \n",
"\n",
" genres ... \\\n",
"0 Action|Adventure|Fantasy|Sci-Fi ... \n",
"1 Action|Adventure|Fantasy ... \n",
"2 Action|Adventure|Thriller ... \n",
"3 Action|Thriller ... \n",
"4 Documentary ... \n",
"5 Action|Adventure|Sci-Fi ... \n",
"6 Action|Adventure|Romance ... \n",
"7 Adventure|Animation|Comedy|Family|Fantasy|Musi... ... \n",
"8 Action|Adventure|Sci-Fi ... \n",
"9 Adventure|Family|Fantasy|Mystery ... \n",
"10 Action|Adventure|Sci-Fi ... \n",
"11 Action|Adventure|Sci-Fi ... \n",
"12 Action|Adventure ... \n",
"13 Action|Adventure|Fantasy ... \n",
"14 Action|Adventure|Western ... \n",
"15 Action|Adventure|Fantasy|Sci-Fi ... \n",
"16 Action|Adventure|Family|Fantasy ... \n",
"17 Action|Adventure|Sci-Fi ... \n",
"18 Action|Adventure|Fantasy ... \n",
"19 Action|Adventure|Comedy|Family|Fantasy|Sci-Fi ... \n",
"20 Adventure|Fantasy ... \n",
"21 Action|Adventure|Fantasy ... \n",
"22 Action|Adventure|Drama|History ... \n",
"23 Adventure|Fantasy ... \n",
"24 Adventure|Family|Fantasy ... \n",
"25 Action|Adventure|Drama|Romance ... \n",
"26 Drama|Romance ... \n",
"27 Action|Adventure|Sci-Fi ... \n",
"28 Action|Adventure|Sci-Fi|Thriller ... \n",
"29 Action|Adventure|Sci-Fi|Thriller ... \n",
"... ... ... \n",
"5013 Drama|Family ... \n",
"5014 Action|Crime|Thriller ... \n",
"5015 Comedy|Drama ... \n",
"5016 Crime|Drama|Thriller ... \n",
"5017 Comedy|Romance ... \n",
"5018 Drama ... \n",
"5019 Horror|Mystery|Thriller ... \n",
"5020 Drama|Horror|Thriller ... \n",
"5021 Comedy|Drama|Romance ... \n",
"5022 Drama ... \n",
"5023 Romance ... \n",
"5024 Sci-Fi|Thriller ... \n",
"5025 Comedy|Crime|Horror ... \n",
"5026 Drama|Music|Romance ... \n",
"5027 Drama ... \n",
"5028 Horror ... \n",
"5029 Crime|Horror|Mystery|Thriller ... \n",
"5030 Drama ... \n",
"5031 Comedy|Horror|Thriller ... \n",
"5032 Crime|Drama ... \n",
"5033 Drama|Sci-Fi|Thriller ... \n",
"5034 Thriller ... \n",
"5035 Action|Crime|Drama|Romance|Thriller ... \n",
"5036 Crime|Drama ... \n",
"5037 Comedy|Drama ... \n",
"5038 Comedy|Drama ... \n",
"5039 Crime|Drama|Mystery|Thriller ... \n",
"5040 Drama|Horror|Thriller ... \n",
"5041 Comedy|Drama|Romance ... \n",
"5042 Documentary ... \n",
"\n",
" country content_rating budget title_year \\\n",
"0 USA PG-13 237000000.0 2009-01-01 \n",
"1 USA PG-13 300000000.0 2007-01-01 \n",
"2 UK PG-13 245000000.0 2015-01-01 \n",
"3 USA PG-13 250000000.0 2012-01-01 \n",
"4 NaN NaN NaN NaT \n",
"5 USA PG-13 263700000.0 2012-01-01 \n",
"6 USA PG-13 258000000.0 2007-01-01 \n",
"7 USA PG 260000000.0 2010-01-01 \n",
"8 USA PG-13 250000000.0 2015-01-01 \n",
"9 UK PG 250000000.0 2009-01-01 \n",
"10 USA PG-13 250000000.0 2016-01-01 \n",
"11 USA PG-13 209000000.0 2006-01-01 \n",
"12 UK PG-13 200000000.0 2008-01-01 \n",
"13 USA PG-13 225000000.0 2006-01-01 \n",
"14 USA PG-13 215000000.0 2013-01-01 \n",
"15 USA PG-13 225000000.0 2013-01-01 \n",
"16 USA PG 225000000.0 2008-01-01 \n",
"17 USA PG-13 220000000.0 2012-01-01 \n",
"18 USA PG-13 250000000.0 2011-01-01 \n",
"19 USA PG-13 225000000.0 2012-01-01 \n",
"20 New Zealand PG-13 250000000.0 2014-01-01 \n",
"21 USA PG-13 230000000.0 2012-01-01 \n",
"22 USA PG-13 200000000.0 2010-01-01 \n",
"23 USA PG-13 225000000.0 2013-01-01 \n",
"24 USA PG-13 180000000.0 2007-01-01 \n",
"25 New Zealand PG-13 207000000.0 2005-01-01 \n",
"26 USA PG-13 200000000.0 1997-01-01 \n",
"27 USA PG-13 250000000.0 2016-01-01 \n",
"28 USA PG-13 209000000.0 2012-01-01 \n",
"29 USA PG-13 150000000.0 2015-01-01 \n",
"... ... ... ... ... \n",
"5013 USA NaN 24000.0 2002-01-01 \n",
"5014 Canada R NaN 2009-01-01 \n",
"5015 USA R 23000.0 1991-01-01 \n",
"5016 USA NaN 25000.0 2015-01-01 \n",
"5017 USA NaN 22000.0 2013-01-01 \n",
"5018 USA NaN 20000.0 2003-01-01 \n",
"5019 USA R NaN 2015-01-01 \n",
"5020 USA NaN 17350.0 2011-01-01 \n",
"5021 USA R 15000.0 2005-01-01 \n",
"5022 Kenya NaN 15000.0 2014-01-01 \n",
"5023 USA NaN 15000.0 2009-01-01 \n",
"5024 USA Unrated 20000.0 2011-01-01 \n",
"5025 USA NC-17 10000.0 1972-01-01 \n",
"5026 France R 4500.0 2004-01-01 \n",
"5027 Iran Not Rated 10000.0 2000-01-01 \n",
"5028 Ireland NaN 10000.0 2007-01-01 \n",
"5029 Japan NaN 1000000.0 1997-01-01 \n",
"5030 USA NaN NaN 2004-01-01 \n",
"5031 USA NaN 200000.0 2012-01-01 \n",
"5032 USA NaN NaN 1995-01-01 \n",
"5033 USA PG-13 7000.0 2004-01-01 \n",
"5034 Philippines Not Rated 7000.0 2005-01-01 \n",
"5035 USA R 7000.0 1992-01-01 \n",
"5036 USA PG-13 3250.0 2005-01-01 \n",
"5037 USA Not Rated 9000.0 2011-01-01 \n",
"5038 Canada NaN NaN 2013-01-01 \n",
"5039 USA TV-14 NaN NaT \n",
"5040 USA NaN 1400.0 2013-01-01 \n",
"5041 USA PG-13 NaN 2012-01-01 \n",
"5042 USA PG 1100.0 2004-01-01 \n",
"\n",
" actor_2_facebook_likes imdb_score aspect_ratio movie_facebook_likes \\\n",
"0 936.0 7.9 1.78 33000 \n",
"1 5000.0 7.1 2.35 0 \n",
"2 393.0 6.8 2.35 85000 \n",
"3 23000.0 8.5 2.35 164000 \n",
"4 12.0 7.1 NaN 0 \n",
"5 632.0 6.6 2.35 24000 \n",
"6 11000.0 6.2 2.35 0 \n",
"7 553.0 7.8 1.85 29000 \n",
"8 21000.0 7.5 2.35 118000 \n",
"9 11000.0 7.5 2.35 10000 \n",
"10 4000.0 6.9 2.35 197000 \n",
"11 10000.0 6.1 2.35 0 \n",
"12 412.0 6.7 2.35 0 \n",
"13 5000.0 7.3 2.35 5000 \n",
"14 2000.0 6.5 2.35 48000 \n",
"15 3000.0 7.2 2.35 118000 \n",
"16 216.0 6.6 2.35 0 \n",
"17 21000.0 8.1 1.85 123000 \n",
"18 11000.0 6.7 2.35 58000 \n",
"19 816.0 6.8 1.85 40000 \n",
"20 972.0 7.5 2.35 65000 \n",
"21 10000.0 7.0 2.35 56000 \n",
"22 882.0 6.7 2.35 17000 \n",
"23 972.0 7.9 2.35 83000 \n",
"24 6000.0 6.1 2.35 0 \n",
"25 919.0 7.2 2.35 0 \n",
"26 14000.0 7.7 2.35 26000 \n",
"27 19000.0 8.2 2.35 72000 \n",
"28 10000.0 5.9 2.35 44000 \n",
"29 2000.0 7.0 2.00 150000 \n",
"... ... ... ... ... \n",
"5013 46.0 7.0 1.78 61 \n",
"5014 918.0 6.3 2.35 0 \n",
"5015 0.0 7.1 1.37 2000 \n",
"5016 25.0 4.8 NaN 33 \n",
"5017 184.0 3.3 1.78 200 \n",
"5018 49.0 6.9 1.85 725 \n",
"5019 512.0 4.6 1.85 0 \n",
"5020 19.0 3.0 NaN 33 \n",
"5021 224.0 6.6 NaN 297 \n",
"5022 19.0 7.4 NaN 45 \n",
"5023 212.0 6.2 2.35 324 \n",
"5024 91.0 4.0 2.35 835 \n",
"5025 143.0 6.1 1.37 0 \n",
"5026 133.0 6.9 2.35 171 \n",
"5027 0.0 7.5 1.85 697 \n",
"5028 5.0 6.7 1.33 105 \n",
"5029 13.0 7.4 1.85 817 \n",
"5030 20.0 6.1 NaN 22 \n",
"5031 98.0 5.4 16.00 424 \n",
"5032 194.0 6.4 NaN 20 \n",
"5033 45.0 7.0 1.85 19000 \n",
"5034 0.0 6.3 NaN 74 \n",
"5035 20.0 6.9 1.37 0 \n",
"5036 44.0 7.8 NaN 4 \n",
"5037 205.0 6.4 NaN 413 \n",
"5038 470.0 7.7 NaN 84 \n",
"5039 593.0 7.5 16.00 32000 \n",
"5040 0.0 6.3 NaN 16 \n",
"5041 719.0 6.3 2.35 660 \n",
"5042 23.0 6.6 1.85 456 \n",
"\n",
" net profitable \n",
"0 523505847.0 1 \n",
"1 9404152.0 1 \n",
"2 -44925825.0 0 \n",
"3 198130642.0 1 \n",
"4 NaN 0 \n",
"5 -190641321.0 0 \n",
"6 78530303.0 1 \n",
"7 -59192738.0 0 \n",
"8 208991599.0 1 \n",
"9 51956980.0 1 \n",
"10 80249062.0 1 \n",
"11 -8930592.0 0 \n",
"12 -31631573.0 0 \n",
"13 198032628.0 1 \n",
"14 -125710090.0 0 \n",
"15 66021565.0 1 \n",
"16 -83385977.0 0 \n",
"17 403279547.0 1 \n",
"18 -8936125.0 0 \n",
"19 -45979146.0 0 \n",
"20 5108370.0 1 \n",
"21 32030663.0 1 \n",
"22 -94780265.0 0 \n",
"23 33355354.0 1 \n",
"24 -109916481.0 0 \n",
"25 11051260.0 1 \n",
"26 458672302.0 1 \n",
"27 157197282.0 1 \n",
"28 -143826840.0 0 \n",
"29 502177271.0 1 \n",
"... ... ... \n",
"5013 NaN 0 \n",
"5014 NaN 0 \n",
"5015 1204508.0 1 \n",
"5016 NaN 0 \n",
"5017 NaN 0 \n",
"5018 NaN 0 \n",
"5019 NaN 0 \n",
"5020 NaN 0 \n",
"5021 177467.0 1 \n",
"5022 NaN 0 \n",
"5023 61382.0 1 \n",
"5024 NaN 0 \n",
"5025 170483.0 1 \n",
"5026 131507.0 1 \n",
"5027 663780.0 1 \n",
"5028 NaN 0 \n",
"5029 -905404.0 0 \n",
"5030 NaN 0 \n",
"5031 NaN 0 \n",
"5032 NaN 0 \n",
"5033 417760.0 1 \n",
"5034 63071.0 1 \n",
"5035 2033920.0 1 \n",
"5036 NaN 0 \n",
"5037 -4416.0 0 \n",
"5038 NaN 0 \n",
"5039 NaN 0 \n",
"5040 NaN 0 \n",
"5041 NaN 0 \n",
"5042 84122.0 1 \n",
"\n",
"[5043 rows x 30 columns]"
]
},
"execution_count": 4,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data.movie"
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style>\n",
" .dataframe thead tr:only-child th {\n",
" text-align: right;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: left;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>index</th>\n",
" <th>plot_keywords</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>0</td>\n",
" <td>avatar</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>0</td>\n",
" <td>future</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>0</td>\n",
" <td>marine</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>0</td>\n",
" <td>native</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>0</td>\n",
" <td>paraplegic</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>1</td>\n",
" <td>goddess</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>1</td>\n",
" <td>marriage ceremony</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>1</td>\n",
" <td>marriage proposal</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>1</td>\n",
" <td>pirate</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>1</td>\n",
" <td>singapore</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>2</td>\n",
" <td>bomb</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>2</td>\n",
" <td>espionage</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>2</td>\n",
" <td>sequel</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>2</td>\n",
" <td>spy</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>2</td>\n",
" <td>terrorist</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>3</td>\n",
" <td>deception</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>3</td>\n",
" <td>imprisonment</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>3</td>\n",
" <td>lawlessness</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>3</td>\n",
" <td>police officer</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>3</td>\n",
" <td>terrorist plot</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>4</td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>5</td>\n",
" <td>alien</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>5</td>\n",
" <td>american civil war</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>5</td>\n",
" <td>male nipple</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>5</td>\n",
" <td>mars</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>5</td>\n",
" <td>princess</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>6</td>\n",
" <td>sandman</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>6</td>\n",
" <td>spider man</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>6</td>\n",
" <td>symbiote</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>6</td>\n",
" <td>venom</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24220</th>\n",
" <td>5034</td>\n",
" <td>security guard</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24221</th>\n",
" <td>5034</td>\n",
" <td>squatter</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24222</th>\n",
" <td>5035</td>\n",
" <td>assassin</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24223</th>\n",
" <td>5035</td>\n",
" <td>death</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24224</th>\n",
" <td>5035</td>\n",
" <td>guitar</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24225</th>\n",
" <td>5035</td>\n",
" <td>gun</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24226</th>\n",
" <td>5035</td>\n",
" <td>mariachi</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24227</th>\n",
" <td>5036</td>\n",
" <td>jewell</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24228</th>\n",
" <td>5036</td>\n",
" <td>mongol</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24229</th>\n",
" <td>5036</td>\n",
" <td>nostradamus</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24230</th>\n",
" <td>5036</td>\n",
" <td>stepnicka</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24231</th>\n",
" <td>5036</td>\n",
" <td>vallone</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24232</th>\n",
" <td>5037</td>\n",
" <td>written and directed by cast member</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24233</th>\n",
" <td>5038</td>\n",
" <td>fraud</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24234</th>\n",
" <td>5038</td>\n",
" <td>postal worker</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24235</th>\n",
" <td>5038</td>\n",
" <td>prison</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24236</th>\n",
" <td>5038</td>\n",
" <td>theft</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24237</th>\n",
" <td>5038</td>\n",
" <td>trial</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24238</th>\n",
" <td>5039</td>\n",
" <td>cult</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24239</th>\n",
" <td>5039</td>\n",
" <td>fbi</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24240</th>\n",
" <td>5039</td>\n",
" <td>hideout</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24241</th>\n",
" <td>5039</td>\n",
" <td>prison escape</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24242</th>\n",
" <td>5039</td>\n",
" <td>serial killer</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24243</th>\n",
" <td>5040</td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>24244</th>\n",
" <td>5041</td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>24245</th>\n",
" <td>5042</td>\n",
" <td>actress name in title</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24246</th>\n",
" <td>5042</td>\n",
" <td>crush</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24247</th>\n",
" <td>5042</td>\n",
" <td>date</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24248</th>\n",
" <td>5042</td>\n",
" <td>four word title</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24249</th>\n",
" <td>5042</td>\n",
" <td>video camera</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>24250 rows × 2 columns</p>\n",
"</div>"
],
"text/plain": [
" index plot_keywords\n",
"0 0 avatar\n",
"1 0 future\n",
"2 0 marine\n",
"3 0 native\n",
"4 0 paraplegic\n",
"5 1 goddess\n",
"6 1 marriage ceremony\n",
"7 1 marriage proposal\n",
"8 1 pirate\n",
"9 1 singapore\n",
"10 2 bomb\n",
"11 2 espionage\n",
"12 2 sequel\n",
"13 2 spy\n",
"14 2 terrorist\n",
"15 3 deception\n",
"16 3 imprisonment\n",
"17 3 lawlessness\n",
"18 3 police officer\n",
"19 3 terrorist plot\n",
"20 4 \n",
"21 5 alien\n",
"22 5 american civil war\n",
"23 5 male nipple\n",
"24 5 mars\n",
"25 5 princess\n",
"26 6 sandman\n",
"27 6 spider man\n",
"28 6 symbiote\n",
"29 6 venom\n",
"... ... ...\n",
"24220 5034 security guard\n",
"24221 5034 squatter\n",
"24222 5035 assassin\n",
"24223 5035 death\n",
"24224 5035 guitar\n",
"24225 5035 gun\n",
"24226 5035 mariachi\n",
"24227 5036 jewell\n",
"24228 5036 mongol\n",
"24229 5036 nostradamus\n",
"24230 5036 stepnicka\n",
"24231 5036 vallone\n",
"24232 5037 written and directed by cast member\n",
"24233 5038 fraud\n",
"24234 5038 postal worker\n",
"24235 5038 prison\n",
"24236 5038 theft\n",
"24237 5038 trial\n",
"24238 5039 cult\n",
"24239 5039 fbi\n",
"24240 5039 hideout\n",
"24241 5039 prison escape\n",
"24242 5039 serial killer\n",
"24243 5040 \n",
"24244 5041 \n",
"24245 5042 actress name in title\n",
"24246 5042 crush\n",
"24247 5042 date\n",
"24248 5042 four word title\n",
"24249 5042 video camera\n",
"\n",
"[24250 rows x 2 columns]"
]
},
"execution_count": 5,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data.keyword"
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style>\n",
" .dataframe thead tr:only-child th {\n",
" text-align: right;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: left;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>index</th>\n",
" <th>genres</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>0</td>\n",
" <td>Action</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>0</td>\n",
" <td>Adventure</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>0</td>\n",
" <td>Fantasy</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>0</td>\n",
" <td>Sci-Fi</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>1</td>\n",
" <td>Action</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>1</td>\n",
" <td>Adventure</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>1</td>\n",
" <td>Fantasy</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>2</td>\n",
" <td>Action</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>2</td>\n",
" <td>Adventure</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>2</td>\n",
" <td>Thriller</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>3</td>\n",
" <td>Action</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>3</td>\n",
" <td>Thriller</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>4</td>\n",
" <td>Documentary</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>5</td>\n",
" <td>Action</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>5</td>\n",
" <td>Adventure</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>5</td>\n",
" <td>Sci-Fi</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>6</td>\n",
" <td>Action</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>6</td>\n",
" <td>Adventure</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>6</td>\n",
" <td>Romance</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>7</td>\n",
" <td>Adventure</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>7</td>\n",
" <td>Animation</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>7</td>\n",
" <td>Comedy</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>7</td>\n",
" <td>Family</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>7</td>\n",
" <td>Fantasy</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>7</td>\n",
" <td>Musical</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>7</td>\n",
" <td>Romance</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>8</td>\n",
" <td>Action</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>8</td>\n",
" <td>Adventure</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>8</td>\n",
" <td>Sci-Fi</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>9</td>\n",
" <td>Adventure</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14474</th>\n",
" <td>5031</td>\n",
" <td>Horror</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14475</th>\n",
" <td>5031</td>\n",
" <td>Thriller</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14476</th>\n",
" <td>5032</td>\n",
" <td>Crime</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14477</th>\n",
" <td>5032</td>\n",
" <td>Drama</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14478</th>\n",
" <td>5033</td>\n",
" <td>Drama</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14479</th>\n",
" <td>5033</td>\n",
" <td>Sci-Fi</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14480</th>\n",
" <td>5033</td>\n",
" <td>Thriller</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14481</th>\n",
" <td>5034</td>\n",
" <td>Thriller</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14482</th>\n",
" <td>5035</td>\n",
" <td>Action</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14483</th>\n",
" <td>5035</td>\n",
" <td>Crime</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14484</th>\n",
" <td>5035</td>\n",
" <td>Drama</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14485</th>\n",
" <td>5035</td>\n",
" <td>Romance</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14486</th>\n",
" <td>5035</td>\n",
" <td>Thriller</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14487</th>\n",
" <td>5036</td>\n",
" <td>Crime</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14488</th>\n",
" <td>5036</td>\n",
" <td>Drama</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14489</th>\n",
" <td>5037</td>\n",
" <td>Comedy</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14490</th>\n",
" <td>5037</td>\n",
" <td>Drama</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14491</th>\n",
" <td>5038</td>\n",
" <td>Comedy</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14492</th>\n",
" <td>5038</td>\n",
" <td>Drama</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14493</th>\n",
" <td>5039</td>\n",
" <td>Crime</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14494</th>\n",
" <td>5039</td>\n",
" <td>Drama</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14495</th>\n",
" <td>5039</td>\n",
" <td>Mystery</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14496</th>\n",
" <td>5039</td>\n",
" <td>Thriller</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14497</th>\n",
" <td>5040</td>\n",
" <td>Drama</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14498</th>\n",
" <td>5040</td>\n",
" <td>Horror</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14499</th>\n",
" <td>5040</td>\n",
" <td>Thriller</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14500</th>\n",
" <td>5041</td>\n",
" <td>Comedy</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14501</th>\n",
" <td>5041</td>\n",
" <td>Drama</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14502</th>\n",
" <td>5041</td>\n",
" <td>Romance</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14503</th>\n",
" <td>5042</td>\n",
" <td>Documentary</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>14504 rows × 2 columns</p>\n",
"</div>"
],
"text/plain": [
" index genres\n",
"0 0 Action\n",
"1 0 Adventure\n",
"2 0 Fantasy\n",
"3 0 Sci-Fi\n",
"4 1 Action\n",
"5 1 Adventure\n",
"6 1 Fantasy\n",
"7 2 Action\n",
"8 2 Adventure\n",
"9 2 Thriller\n",
"10 3 Action\n",
"11 3 Thriller\n",
"12 4 Documentary\n",
"13 5 Action\n",
"14 5 Adventure\n",
"15 5 Sci-Fi\n",
"16 6 Action\n",
"17 6 Adventure\n",
"18 6 Romance\n",
"19 7 Adventure\n",
"20 7 Animation\n",
"21 7 Comedy\n",
"22 7 Family\n",
"23 7 Fantasy\n",
"24 7 Musical\n",
"25 7 Romance\n",
"26 8 Action\n",
"27 8 Adventure\n",
"28 8 Sci-Fi\n",
"29 9 Adventure\n",
"... ... ...\n",
"14474 5031 Horror\n",
"14475 5031 Thriller\n",
"14476 5032 Crime\n",
"14477 5032 Drama\n",
"14478 5033 Drama\n",
"14479 5033 Sci-Fi\n",
"14480 5033 Thriller\n",
"14481 5034 Thriller\n",
"14482 5035 Action\n",
"14483 5035 Crime\n",
"14484 5035 Drama\n",
"14485 5035 Romance\n",
"14486 5035 Thriller\n",
"14487 5036 Crime\n",
"14488 5036 Drama\n",
"14489 5037 Comedy\n",
"14490 5037 Drama\n",
"14491 5038 Comedy\n",
"14492 5038 Drama\n",
"14493 5039 Crime\n",
"14494 5039 Drama\n",
"14495 5039 Mystery\n",
"14496 5039 Thriller\n",
"14497 5040 Drama\n",
"14498 5040 Horror\n",
"14499 5040 Thriller\n",
"14500 5041 Comedy\n",
"14501 5041 Drama\n",
"14502 5041 Romance\n",
"14503 5042 Documentary\n",
"\n",
"[14504 rows x 2 columns]"
]
},
"execution_count": 6,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data.genre"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": []
}
],
"metadata": {
"kernelspec": {
"display_name": "Python [default]",
"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.6.1"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
Reference in a new issue View git blame Copy permalink