{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Project: Investigate The Movie Database (TMDb) \n", "\n", "--by Lu Tang\n", "\n", "## Table of Contents\n", "
| \n", " | id | \n", "imdb_id | \n", "popularity | \n", "budget | \n", "revenue | \n", "original_title | \n", "cast | \n", "homepage | \n", "director | \n", "tagline | \n", "keywords | \n", "overview | \n", "runtime | \n", "genres | \n", "production_companies | \n", "release_date | \n", "vote_count | \n", "vote_average | \n", "release_year | \n", "budget_adj | \n", "revenue_adj | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "135397 | \n", "tt0369610 | \n", "32.985763 | \n", "150000000 | \n", "1513528810 | \n", "Jurassic World | \n", "Chris Pratt|Bryce Dallas Howard|Irrfan Khan|Vi... | \n", "http://www.jurassicworld.com/ | \n", "Colin Trevorrow | \n", "The park is open. | \n", "monster|dna|tyrannosaurus rex|velociraptor|island | \n", "Twenty-two years after the events of Jurassic ... | \n", "124 | \n", "Action|Adventure|Science Fiction|Thriller | \n", "Universal Studios|Amblin Entertainment|Legenda... | \n", "6/9/15 | \n", "5562 | \n", "6.5 | \n", "2015 | \n", "1.379999e+08 | \n", "1.392446e+09 | \n", "
| 1 | \n", "76341 | \n", "tt1392190 | \n", "28.419936 | \n", "150000000 | \n", "378436354 | \n", "Mad Max: Fury Road | \n", "Tom Hardy|Charlize Theron|Hugh Keays-Byrne|Nic... | \n", "http://www.madmaxmovie.com/ | \n", "George Miller | \n", "What a Lovely Day. | \n", "future|chase|post-apocalyptic|dystopia|australia | \n", "An apocalyptic story set in the furthest reach... | \n", "120 | \n", "Action|Adventure|Science Fiction|Thriller | \n", "Village Roadshow Pictures|Kennedy Miller Produ... | \n", "5/13/15 | \n", "6185 | \n", "7.1 | \n", "2015 | \n", "1.379999e+08 | \n", "3.481613e+08 | \n", "
| \n", " | popularity | \n", "original_title | \n", "cast | \n", "director | \n", "runtime | \n", "genres | \n", "vote_count | \n", "vote_average | \n", "release_year | \n", "budget_adj | \n", "revenue_adj | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "32.985763 | \n", "Jurassic World | \n", "Chris Pratt|Bryce Dallas Howard|Irrfan Khan|Vi... | \n", "Colin Trevorrow | \n", "124 | \n", "Action|Adventure|Science Fiction|Thriller | \n", "5562 | \n", "6.5 | \n", "2015 | \n", "1.379999e+08 | \n", "1.392446e+09 | \n", "
| \n", " | popularity | \n", "original_title | \n", "cast | \n", "director | \n", "runtime | \n", "genres | \n", "vote_count | \n", "vote_average | \n", "release_year | \n", "budget_adj | \n", "revenue_adj | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|
| count | \n", "10866.000000 | \n", "10866 | \n", "10790 | \n", "10822 | \n", "10866.000000 | \n", "10843 | \n", "10866.000000 | \n", "10866.000000 | \n", "10866.000000 | \n", "1.086600e+04 | \n", "1.086600e+04 | \n", "
| unique | \n", "NaN | \n", "10571 | \n", "10719 | \n", "5067 | \n", "NaN | \n", "2039 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| top | \n", "NaN | \n", "Hamlet | \n", "Louis C.K. | \n", "Woody Allen | \n", "NaN | \n", "Drama | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| freq | \n", "NaN | \n", "4 | \n", "6 | \n", "45 | \n", "NaN | \n", "712 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| mean | \n", "0.646441 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "102.070863 | \n", "NaN | \n", "217.389748 | \n", "5.974922 | \n", "2001.322658 | \n", "1.755104e+07 | \n", "5.136436e+07 | \n", "
| std | \n", "1.000185 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "31.381405 | \n", "NaN | \n", "575.619058 | \n", "0.935142 | \n", "12.812941 | \n", "3.430616e+07 | \n", "1.446325e+08 | \n", "
| min | \n", "0.000065 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "0.000000 | \n", "NaN | \n", "10.000000 | \n", "1.500000 | \n", "1960.000000 | \n", "0.000000e+00 | \n", "0.000000e+00 | \n", "
| 25% | \n", "0.207583 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "90.000000 | \n", "NaN | \n", "17.000000 | \n", "5.400000 | \n", "1995.000000 | \n", "0.000000e+00 | \n", "0.000000e+00 | \n", "
| 50% | \n", "0.383856 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "99.000000 | \n", "NaN | \n", "38.000000 | \n", "6.000000 | \n", "2006.000000 | \n", "0.000000e+00 | \n", "0.000000e+00 | \n", "
| 75% | \n", "0.713817 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "111.000000 | \n", "NaN | \n", "145.750000 | \n", "6.600000 | \n", "2011.000000 | \n", "2.085325e+07 | \n", "3.369710e+07 | \n", "
| max | \n", "32.985763 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "900.000000 | \n", "NaN | \n", "9767.000000 | \n", "9.200000 | \n", "2015.000000 | \n", "4.250000e+08 | \n", "2.827124e+09 | \n", "
| \n", " | popularity | \n", "original_title | \n", "cast | \n", "director | \n", "runtime | \n", "genres | \n", "vote_count | \n", "vote_average | \n", "release_year | \n", "budget_adj | \n", "revenue_adj | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "32.985763 | \n", "Jurassic World | \n", "Chris Pratt|Bryce Dallas Howard|Irrfan Khan|Vi... | \n", "Colin Trevorrow | \n", "124 | \n", "Action|Adventure|Science Fiction|Thriller | \n", "5562 | \n", "6.5 | \n", "2015 | \n", "1.379999e+08 | \n", "1.392446e+09 | \n", "
| \n", " | popularity | \n", "runtime | \n", "vote_count | \n", "vote_average | \n", "budget_adj | \n", "revenue_adj | \n", "profit | \n", "
|---|---|---|---|---|---|---|---|
| release_year | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
| 1960 | \n", "1.324513 | \n", "130.0 | \n", "372.6 | \n", "7.40 | \n", "3.068179e+07 | \n", "1.902299e+08 | \n", "1.595481e+08 | \n", "
| 1961 | \n", "0.787718 | \n", "132.5 | \n", "191.4 | \n", "6.62 | \n", "2.818516e+07 | \n", "2.463622e+08 | \n", "2.181770e+08 | \n", "
| \n", " | popularity | \n", "original_title | \n", "cast | \n", "director | \n", "runtime | \n", "genres | \n", "vote_count | \n", "vote_average | \n", "release_year | \n", "budget_adj | \n", "revenue_adj | \n", "profit | \n", "revenue_level | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "32.985763 | \n", "Jurassic World | \n", "Chris Pratt|Bryce Dallas Howard|Irrfan Khan|Vi... | \n", "Colin Trevorrow | \n", "124 | \n", "Action|Adventure|Science Fiction|Thriller | \n", "5562 | \n", "6.5 | \n", "2015 | \n", "1.379999e+08 | \n", "1.392446e+09 | \n", "1.254446e+09 | \n", "very_high | \n", "
| 1 | \n", "28.419936 | \n", "Mad Max: Fury Road | \n", "Tom Hardy|Charlize Theron|Hugh Keays-Byrne|Nic... | \n", "George Miller | \n", "120 | \n", "Action|Adventure|Science Fiction|Thriller | \n", "6185 | \n", "7.1 | \n", "2015 | \n", "1.379999e+08 | \n", "3.481613e+08 | \n", "2.101614e+08 | \n", "very_high | \n", "
| 3 | \n", "11.173104 | \n", "Star Wars: The Force Awakens | \n", "Harrison Ford|Mark Hamill|Carrie Fisher|Adam D... | \n", "J.J. Abrams | \n", "136 | \n", "Action|Adventure|Science Fiction|Fantasy | \n", "5292 | \n", "7.5 | \n", "2015 | \n", "1.839999e+08 | \n", "1.902723e+09 | \n", "1.718723e+09 | \n", "very_high | \n", "
| 4 | \n", "9.335014 | \n", "Furious 7 | \n", "Vin Diesel|Paul Walker|Jason Statham|Michelle ... | \n", "James Wan | \n", "137 | \n", "Action|Crime|Thriller | \n", "2947 | \n", "7.3 | \n", "2015 | \n", "1.747999e+08 | \n", "1.385749e+09 | \n", "1.210949e+09 | \n", "very_high | \n", "
| 5 | \n", "9.110700 | \n", "The Revenant | \n", "Leonardo DiCaprio|Tom Hardy|Will Poulter|Domhn... | \n", "Alejandro González Iñárritu | \n", "156 | \n", "Western|Drama|Adventure|Thriller | \n", "3929 | \n", "7.2 | \n", "2015 | \n", "1.241999e+08 | \n", "4.903142e+08 | \n", "3.661143e+08 | \n", "very_high | \n", "
| \n", " | 0 | \n", "1 | \n", "2 | \n", "3 | \n", "4 | \n", "
|---|---|---|---|---|---|
| 0 | \n", "Action | \n", "Adventure | \n", "Science Fiction | \n", "Thriller | \n", "None | \n", "
| 1 | \n", "Action | \n", "Adventure | \n", "Science Fiction | \n", "Thriller | \n", "None | \n", "
| 3 | \n", "Action | \n", "Adventure | \n", "Science Fiction | \n", "Fantasy | \n", "None | \n", "
| 4 | \n", "Action | \n", "Crime | \n", "Thriller | \n", "None | \n", "None | \n", "
| 5 | \n", "Western | \n", "Drama | \n", "Adventure | \n", "Thriller | \n", "None | \n", "
| \n", " | 0 | \n", "
|---|---|
| Action | \n", "121 | \n", "
| Adventure | \n", "116 | \n", "
| Animation | \n", "44 | \n", "
| Comedy | \n", "63 | \n", "
| Crime | \n", "12 | \n", "
| Drama | \n", "61 | \n", "
| Family | \n", "12 | \n", "
| Fantasy | \n", "26 | \n", "
| History | \n", "3 | \n", "
| Horror | \n", "9 | \n", "
| Music | \n", "6 | \n", "
| Mystery | \n", "3 | \n", "
| Romance | \n", "6 | \n", "
| Science Fiction | \n", "21 | \n", "
| Thriller | \n", "9 | \n", "
| War | \n", "3 | \n", "
| Western | \n", "2 | \n", "
| \n", " | 0 | \n", "1 | \n", "2 | \n", "3 | \n", "4 | \n", "
|---|---|---|---|---|---|
| Action | \n", "121 | \n", "79 | \n", "33 | \n", "3.0 | \n", "4.0 | \n", "
| Adventure | \n", "116 | \n", "74 | \n", "36 | \n", "14.0 | \n", "1.0 | \n", "
| Animation | \n", "44 | \n", "23 | \n", "9 | \n", "3.0 | \n", "2.0 | \n", "
| Comedy | \n", "63 | \n", "44 | \n", "37 | \n", "13.0 | \n", "5.0 | \n", "
| Crime | \n", "12 | \n", "16 | \n", "19 | \n", "11.0 | \n", "2.0 | \n", "
| Drama | \n", "61 | \n", "52 | \n", "32 | \n", "5.0 | \n", "1.0 | \n", "
| Family | \n", "12 | \n", "36 | \n", "40 | \n", "28.0 | \n", "9.0 | \n", "
| Fantasy | \n", "26 | \n", "42 | \n", "23 | \n", "15.0 | \n", "10.0 | \n", "
| History | \n", "3 | \n", "5 | \n", "4 | \n", "1.0 | \n", "NaN | \n", "
| Horror | \n", "9 | \n", "5 | \n", "3 | \n", "1.0 | \n", "1.0 | \n", "
| Music | \n", "6 | \n", "6 | \n", "3 | \n", "2.0 | \n", "4.0 | \n", "
| Mystery | \n", "3 | \n", "13 | \n", "7 | \n", "10.0 | \n", "2.0 | \n", "
| Romance | \n", "6 | \n", "29 | \n", "20 | \n", "10.0 | \n", "5.0 | \n", "
| Science Fiction | \n", "21 | \n", "18 | \n", "37 | \n", "32.0 | \n", "6.0 | \n", "
| Thriller | \n", "9 | \n", "38 | \n", "66 | \n", "28.0 | \n", "7.0 | \n", "
| War | \n", "3 | \n", "1 | \n", "11 | \n", "4.0 | \n", "1.0 | \n", "
| Western | \n", "2 | \n", "2 | \n", "3 | \n", "NaN | \n", "NaN | \n", "
| \n", " | 0 | \n", "1 | \n", "2 | \n", "3 | \n", "4 | \n", "
|---|---|---|---|---|---|
| Action | \n", "121 | \n", "79 | \n", "33 | \n", "3.0 | \n", "4.0 | \n", "
| Adventure | \n", "116 | \n", "74 | \n", "36 | \n", "14.0 | \n", "1.0 | \n", "
| Animation | \n", "44 | \n", "23 | \n", "9 | \n", "3.0 | \n", "2.0 | \n", "
| Comedy | \n", "63 | \n", "44 | \n", "37 | \n", "13.0 | \n", "5.0 | \n", "
| Crime | \n", "12 | \n", "16 | \n", "19 | \n", "11.0 | \n", "2.0 | \n", "
| Drama | \n", "61 | \n", "52 | \n", "32 | \n", "5.0 | \n", "1.0 | \n", "
| Family | \n", "12 | \n", "36 | \n", "40 | \n", "28.0 | \n", "9.0 | \n", "
| Fantasy | \n", "26 | \n", "42 | \n", "23 | \n", "15.0 | \n", "10.0 | \n", "
| History | \n", "3 | \n", "5 | \n", "4 | \n", "1.0 | \n", "0.0 | \n", "
| Horror | \n", "9 | \n", "5 | \n", "3 | \n", "1.0 | \n", "1.0 | \n", "
| Music | \n", "6 | \n", "6 | \n", "3 | \n", "2.0 | \n", "4.0 | \n", "
| Mystery | \n", "3 | \n", "13 | \n", "7 | \n", "10.0 | \n", "2.0 | \n", "
| Romance | \n", "6 | \n", "29 | \n", "20 | \n", "10.0 | \n", "5.0 | \n", "
| Science Fiction | \n", "21 | \n", "18 | \n", "37 | \n", "32.0 | \n", "6.0 | \n", "
| Thriller | \n", "9 | \n", "38 | \n", "66 | \n", "28.0 | \n", "7.0 | \n", "
| War | \n", "3 | \n", "1 | \n", "11 | \n", "4.0 | \n", "1.0 | \n", "
| Western | \n", "2 | \n", "2 | \n", "3 | \n", "0.0 | \n", "0.0 | \n", "
| \n", " | 0 | \n", "1 | \n", "2 | \n", "3 | \n", "4 | \n", "sum_generes | \n", "
|---|---|---|---|---|---|---|
| Adventure | \n", "116 | \n", "74 | \n", "36 | \n", "14.0 | \n", "1.0 | \n", "241.0 | \n", "
| Action | \n", "121 | \n", "79 | \n", "33 | \n", "3.0 | \n", "4.0 | \n", "240.0 | \n", "
| Comedy | \n", "63 | \n", "44 | \n", "37 | \n", "13.0 | \n", "5.0 | \n", "162.0 | \n", "
| Drama | \n", "61 | \n", "52 | \n", "32 | \n", "5.0 | \n", "1.0 | \n", "151.0 | \n", "
| Thriller | \n", "9 | \n", "38 | \n", "66 | \n", "28.0 | \n", "7.0 | \n", "148.0 | \n", "
| \n", " | popularity | \n", "original_title | \n", "cast | \n", "director | \n", "runtime | \n", "genres | \n", "vote_count | \n", "vote_average | \n", "release_year | \n", "budget_adj | \n", "revenue_adj | \n", "profit | \n", "revenue_level | \n", "score | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2912 | \n", "1.499784 | \n", "Cloverfield | \n", "Lizzy Caplan|Jessica Lucas|Odette Annable|Mich... | \n", "Matt Reeves | \n", "85 | \n", "Action|Thriller|Science Fiction | \n", "1373 | \n", "6.4 | \n", "2008 | \n", "2.531967e+07 | \n", "1.729475e+08 | \n", "1.476279e+08 | \n", "high | \n", "266.936686 | \n", "
| 2643 | \n", "2.449323 | \n", "The Mummy Returns | \n", "Brendan Fraser|Rachel Weisz|John Hannah|Arnold... | \n", "Stephen Sommers | \n", "130 | \n", "Action|Adventure|Drama|Fantasy|Horror | \n", "1372 | \n", "5.8 | \n", "2001 | \n", "1.206858e+08 | \n", "5.332507e+08 | \n", "4.125649e+08 | \n", "very_high | \n", "266.731612 | \n", "
| 6980 | \n", "2.175284 | \n", "Ocean's Twelve | \n", "George Clooney|Brad Pitt|Catherine Zeta-Jones|... | \n", "Steven Soderbergh | \n", "125 | \n", "Thriller|Crime | \n", "1376 | \n", "6.4 | \n", "2004 | \n", "1.269890e+08 | \n", "4.187685e+08 | \n", "2.917795e+08 | \n", "very_high | \n", "266.652226 | \n", "
| 7884 | \n", "2.484654 | \n", "Ghostbusters | \n", "Bill Murray|Dan Aykroyd|Sigourney Weaver|Harol... | \n", "Ivan Reitman | \n", "107 | \n", "Fantasy|Action|Comedy|Science Fiction|Family | \n", "1383 | \n", "7.2 | \n", "1984 | \n", "6.297126e+07 | \n", "6.196634e+08 | \n", "5.566921e+08 | \n", "very_high | \n", "266.392537 | \n", "
| 21 | \n", "5.337064 | \n", "Southpaw | \n", "Jake Gyllenhaal|Rachel McAdams|Forest Whitaker... | \n", "Antoine Fuqua | \n", "123 | \n", "Action|Drama | \n", "1386 | \n", "7.3 | \n", "2015 | \n", "2.759999e+07 | \n", "8.437300e+07 | \n", "5.677302e+07 | \n", "low | \n", "266.160831 | \n", "
| 658 | \n", "3.813740 | \n", "Exodus: Gods and Kings | \n", "Christian Bale|Joel Edgerton|John Turturro|Aar... | \n", "Ridley Scott | \n", "153 | \n", "Adventure|Drama|Action | \n", "1377 | \n", "5.6 | \n", "2014 | \n", "1.289527e+08 | \n", "2.468817e+08 | \n", "1.179290e+08 | \n", "high | \n", "266.156773 | \n", "
| 3416 | \n", "1.499109 | \n", "Rango | \n", "Johnny Depp|Isla Fisher|Ned Beatty|Bill Nighy|... | \n", "Gore Verbinski | \n", "107 | \n", "Animation|Comedy|Family|Western|Adventure | \n", "1385 | \n", "6.5 | \n", "2011 | \n", "1.308687e+08 | \n", "2.382049e+08 | \n", "1.073362e+08 | \n", "high | \n", "265.852803 | \n", "
| 6631 | \n", "0.890909 | \n", "The Pursuit of Happyness | \n", "Will Smith|Jaden Smith|Thandie Newton|Brian Ho... | \n", "Gabriele Muccino | \n", "117 | \n", "Drama | \n", "1392 | \n", "7.5 | \n", "2006 | \n", "5.949180e+07 | \n", "3.321560e+08 | \n", "2.726642e+08 | \n", "very_high | \n", "265.699578 | \n", "
| 6578 | \n", "1.603140 | \n", "Blood Diamond | \n", "Leonardo DiCaprio|Djimon Hounsou|Jennifer Conn... | \n", "Edward Zwick | \n", "143 | \n", "Drama|Thriller|Action | \n", "1394 | \n", "7.2 | \n", "2006 | \n", "1.081669e+08 | \n", "1.848334e+08 | \n", "7.666646e+07 | \n", "high | \n", "265.361653 | \n", "
| 10094 | \n", "0.142486 | \n", "Home Alone | \n", "Macaulay Culkin|Joe Pesci|Daniel Stern|John He... | \n", "Chris Columbus | \n", "103 | \n", "Comedy|Family | \n", "1393 | \n", "7.0 | \n", "1990 | \n", "3.004017e+07 | \n", "7.955384e+08 | \n", "7.654982e+08 | \n", "very_high | \n", "265.354260 | \n", "