In [1]:
import pixiedust
import pandas as pd
import numpy as np

from src.my_aws import S3


Pixiedust database opened successfully
Pixiedust version 1.0.11

In [2]:
KEY_FINAL = 'Final_Data.csv'
BUCKET = 'movie-torrents'

s3_obj = S3()
df = s3_obj.get_data(KEY_FINAL, BUCKET)

In [3]:
display(df)


Hey, there's something awesome here! To see it, open this notebook outside GitHub, in a viewer like Jupyter
type: Pandas DataFrame Row
field:
{'type': dtype('O'), 'name': 'Actors'}
{'type': dtype('O'), 'name': 'Awards'}
{'type': dtype('float64'), 'name': 'BoxOffice'}
{'type': dtype('O'), 'name': 'Country'}
{'type': dtype('O'), 'name': 'DVD'}
{'type': dtype('O'), 'name': 'Director'}
{'type': dtype('O'), 'name': 'Genre'}
{'type': dtype('O'), 'name': 'Language'}
{'type': dtype('float64'), 'name': 'Metascore'}
{'type': dtype('O'), 'name': 'Production'}
{'type': dtype('O'), 'name': 'Rated'}
{'type': dtype('O'), 'name': 'Released'}
{'type': dtype('float64'), 'name': 'Runtime'}
{'type': dtype('O'), 'name': 'Title'}
{'type': dtype('O'), 'name': 'Type'}
{'type': dtype('O'), 'name': 'Writer'}
{'type': dtype('O'), 'name': 'imdbID'}
{'type': dtype('float64'), 'name': 'imdbRating'}
{'type': dtype('float64'), 'name': 'imdbVotes'}
{'type': dtype('int64'), 'name': 'Kat_Count'}
{'type': dtype('int64'), 'name': 'Pirate_Count'}
{'type': dtype('int64'), 'name': 'Extra_Count'}
{'type': dtype('int64'), 'name': 'Torrentz_Count'}
{'type': dtype('int64'), 'name': 'Torrentz_Ver_Count'}
{'type': dtype('float64'), 'name': 'Zoogle_Ver_Count'}
{'type': dtype('int64'), 'name': 'ProductionBudget'}
{'type': dtype('int64'), 'name': 'DomesticBudget'}
{'type': dtype('int64'), 'name': 'WorldGross'}
{'type': dtype('float64'), 'name': 'Total_Torrents'}
{'type': dtype('float64'), 'name': 'Runtime_Log'}
Showing 100 of 3828
Actors
Awards
BoxOffice
Country
DVD
Director
Genre
Language
Metascore
Production
Rated
Released
Runtime
Title
Type
Writer
imdbID
imdbRating
imdbVotes
Kat_Count
Pirate_Count
Extra_Count
Torrentz_Count
Torrentz_Ver_Count
Zoogle_Ver_Count
ProductionBudget
DomesticBudget
WorldGross
Total_Torrents
Runtime_Log
Actors
Awards
BoxOffice
Country
DVD
Director
Genre
Language
Metascore
Production
Rated
Released
Runtime
Title
Type
Writer
imdbID
imdbRating
imdbVotes
Kat_Count
Pirate_Count
Extra_Count
Torrentz_Count
Torrentz_Ver_Count
Zoogle_Ver_Count
ProductionBudget
DomesticBudget
WorldGross
Total_Torrents
Runtime_Log
Sam Worthington, Zoe Saldana, Sigourney Weaver, Stephen Lang Won 3 Oscars. Another 85 wins & 128 nominations. 749700000.0 UK, USA 2010-04-22 James Cameron Action, Adventure, Fantasy English, Spanish 83.0 20th Century Fox PG-13 2009-12-18 162.0 Avatar movie James Cameron tt0499549 7.80000019073 944150.0 509 371 140 961 21 118.0 425000000 760507625 2783918982 2120.0 5.08759633523
Daniel Craig, Christoph Waltz, Léa Seydoux, Ralph Fiennes Won 1 Oscar. Another 7 wins & 31 nominations. 208777731.0 UK, USA 2016-02-09 Sam Mendes Action, Adventure, Thriller English, Spanish, Italian, German, French 60.0 Sony Pictures PG-13 2015-11-06 148.0 Spectre movie John Logan (screenplay), Neal Purvis (screenplay), Robert Wade (screenplay), Jez Butterworth (screenplay), John Logan (story by), Neal Purvis (story by), Robert Wade (story by), Ian Fleming (based on characters created by) tt2379713 6.80000019073 313528.0 217 96 152 392 12 159.0 300000000 200074175 879620923 1028.0 4.99721227376
Christian Bale, Gary Oldman, Tom Hardy, Joseph Gordon-Levitt Nominated for 1 BAFTA Film Award. Another 38 wins & 101 nominations. 448130642.0 UK, USA 2012-12-03 Christopher Nolan Action, Thriller English, Arabic 78.0 Warner Bros. Pictures PG-13 2012-07-20 164.0 The Dark Knight Rises movie Jonathan Nolan (screenplay), Christopher Nolan (screenplay), Christopher Nolan (story), David S. Goyer (story), Bob Kane (characters) tt1345836 8.39999961853 1244136.0 415 215 96 623 58 23.0 275000000 448139099 1084439099 1430.0 5.09986642782
Johnny Depp, Armie Hammer, William Fichtner, Tom Wilkinson Nominated for 2 Oscars. Another 4 wins & 17 nominations. 89289910.0 USA 2013-12-17 Gore Verbinski Action, Adventure, Western English, North American Indian 37.0 Walt Disney Pictures PG-13 2013-07-03 150.0 The Lone Ranger movie Justin Haythe (screenplay), Ted Elliott (screenplay), Terry Rossio (screenplay), Ted Elliott (screen story), Terry Rossio (screen story), Justin Haythe (screen story) tt1210819 6.5 193685.0 233 95 120 410 66 15.0 275000000 89302115 260002115 939.0 5.0106352941
Taylor Kitsch, Lynn Collins, Samantha Morton, Willem Dafoe 2 wins & 8 nominations. 73058679.0 USA 2012-06-05 Andrew Stanton Action, Adventure, Sci-Fi English 51.0 Walt Disney Pictures PG-13 2012-03-09 132.0 John Carter movie Andrew Stanton (screenplay), Mark Andrews (screenplay), Michael Chabon (screenplay), Edgar Rice Burroughs (based on the story "A Princess of Mars" by) tt0401729 6.59999990463 222756.0 266 166 144 498 47 59.0 275000000 73058679 282778100 1180.0 4.88280192259
Mandy Moore, Zachary Levi, Donna Murphy, Ron Perlman Nominated for 1 Oscar. Another 9 wins & 40 nominations. 200803309.0 USA 2011-03-29 Nathan Greno, Byron Howard Animation, Adventure, Comedy English 71.0 Walt Disney Pictures PG 2010-11-24 100.0 Tangled movie Dan Fogelman (screenplay), Jacob Grimm (based upon the fairy tale "Rapunzel" by), Wilhelm Grimm (based upon the fairy tale "Rapunzel" by) tt0398286 7.80000019073 321666.0 261 170 89 361 23 32.0 260000000 200821936 586581936 936.0 4.60517018599
Tobey Maguire, Kirsten Dunst, James Franco, Thomas Haden Church Nominated for 1 BAFTA Film Award. Another 3 wins & 32 nominations. 336530303.0 USA 2007-10-30 Sam Raimi Action, Adventure English, French 59.0 Sony Pictures PG-13 2007-05-04 139.0 Spider-Man 3 movie Sam Raimi (screenplay), Ivan Raimi (screenplay), Alvin Sargent (screenplay), Sam Raimi (screen story), Ivan Raimi (screen story), Stan Lee (Marvel comic book), Steve Ditko (Marvel comic book) tt0413300 6.19999980927 413031.0 94 84 43 155 1 35.0 258000000 336530303 894860230 412.0 4.93447393313
Robert Downey Jr., Chris Hemsworth, Mark Ruffalo, Chris Evans 5 wins & 43 nominations. 429113729.0 USA 2015-10-02 Joss Whedon Action, Adventure, Sci-Fi English 66.0 Walt Disney Pictures PG-13 2015-05-01 141.0 Avengers: Age of Ultron movie Joss Whedon, Stan Lee (based on the Marvel comics by), Jack Kirby (based on the Marvel comics by), Joe Simon (character created by: Captain America), Jack Kirby (character created by: Captain America), Jim Starlin (character created by: Thanos) tt2395427 7.40000009537 527195.0 533 115 251 885 37 268.0 250000000 459005868 1408218722 2089.0 4.94875989038
Chris Evans, Robert Downey Jr., Scarlett Johansson, Sebastian Stan 10 wins & 59 nominations. 408080554.0 USA, Germany 2016-09-13 Anthony Russo, Joe Russo Action, Adventure, Sci-Fi English, German, Xhosa, Russian, Romanian, Hindi 75.0 Walt Disney Pictures PG-13 2016-05-06 147.0 Captain America: Civil War movie Christopher Markus (screenplay), Stephen McFeely (screenplay), Joe Simon (based on the Marvel comics by), Jack Kirby (based on the Marvel comics by) tt3498820 7.90000009537 434233.0 191 35 72 291 0 144.0 250000000 408084349 1153304495 733.0 4.99043258678
Ben Affleck, Henry Cavill, Amy Adams, Jesse Eisenberg 12 wins & 29 nominations. 293792936.0 USA 2016-07-19 Zack Snyder Action, Adventure, Sci-Fi English 44.0 Warner Bros. Pictures PG-13 2016-03-25 151.0 Batman v Superman: Dawn of Justice movie Chris Terrio, David S. Goyer, Bob Kane (Batman created by), Bill Finger (Batman created by), Jerry Siegel (Superman created by), Joe Shuster (Superman created by) tt2975590 6.59999990463 491216.0 493 92 217 524 19 448.0 250000000 330360194 868160194 1793.0 5.01727983681
Ian McKellen, Martin Freeman, Richard Armitage, Ken Stott Nominated for 3 Oscars. Another 10 wins & 72 nominations. 303001229.0 USA, New Zealand 2013-03-19 Peter Jackson Adventure, Fantasy English 58.0 Warner Bros. PG-13 2012-12-14 169.0 The Hobbit: An Unexpected Journey movie Fran Walsh (screenplay), Philippa Boyens (screenplay), Peter Jackson (screenplay), Guillermo del Toro (screenplay), J.R.R. Tolkien (novel) tt0903624 7.90000009537 675418.0 491 264 131 726 92 73.0 250000000 303003568 1017003568 1777.0 5.12989871492
Daniel Radcliffe, Michael Gambon, Dave Legeno, Elarica Johnson Nominated for 1 Oscar. Another 8 wins & 35 nominations. 301920409.0 UK, USA 2009-12-08 David Yates Adventure, Family, Fantasy English 78.0 Warner Bros. Pictures PG 2009-07-15 153.0 Harry Potter and the Half-Blood Prince movie Steve Kloves (screenplay), J.K. Rowling (novel) tt0417741 7.5 357718.0 532 101 51 444 6 29.0 250000000 301959197 935083686 1163.0 5.03043792139
Ian McKellen, Martin Freeman, Richard Armitage, Ken Stott Nominated for 3 Oscars. Another 16 wins & 86 nominations. 180443783.0 USA, New Zealand 2014-04-08 Peter Jackson Adventure, Fantasy English 66.0 Warner Bros. PG-13 2013-12-13 161.0 The Hobbit: The Desolation of Smaug movie Fran Walsh (screenplay), Philippa Boyens (screenplay), Peter Jackson (screenplay), Guillermo del Toro (screenplay), J.R.R. Tolkien (novel) tt1170358 7.90000009537 520467.0 399 216 146 597 97 63.0 250000000 258366855 960366855 1518.0 5.08140436498
Ian McKellen, Martin Freeman, Richard Armitage, Ken Stott Nominated for 1 Oscar. Another 7 wins & 47 nominations. 187747747.0 New Zealand, USA 2015-03-24 Peter Jackson Adventure, Fantasy English 59.0 Warner Bros. PG-13 2014-12-17 144.0 The Hobbit: The Battle of the Five Armies movie Fran Walsh (screenplay), Philippa Boyens (screenplay), Peter Jackson (screenplay), Guillermo del Toro (screenplay), J.R.R. Tolkien (novel) tt2310332 7.40000009537 391620.0 439 0 218 502 27 100.0 250000000 255119788 955119788 1286.0 4.96981329958
Johnny Depp, Penélope Cruz, Geoffrey Rush, Ian McShane 2 wins & 31 nominations. 241063875.0 USA, UK 2011-10-18 Rob Marshall Action, Adventure, Fantasy English, Spanish 45.0 Walt Disney Pictures PG-13 2011-05-20 136.0 Pirates of the Caribbean: On Stranger Tides movie Ted Elliott (screenplay), Terry Rossio (screenplay), Ted Elliott (screen story), Terry Rossio (screen story), Ted Elliott (characters), Terry Rossio (characters), Stuart Beattie (characters), Jay Wolpert (characters), Tim Powers (novel) tt1298650 6.69999980927 402755.0 296 193 102 469 27 50.0 250000000 241063875 1045663875 1137.0 4.91265488574
Brandon Routh, Kate Bosworth, Kevin Spacey, James Marsden Nominated for 1 Oscar. Another 12 wins & 40 nominations. 200100000.0 USA 2006-11-28 Bryan Singer Action, Adventure, Sci-Fi English, German, French 72.0 Warner Bros. Pictures PG-13 2006-06-28 154.0 Superman Returns movie Michael Dougherty (screenplay), Dan Harris (screenplay), Bryan Singer (story), Michael Dougherty (story), Dan Harris (story), Jerry Siegel (characters), Joe Shuster (characters) tt0348150 6.09999990463 248417.0 84 41 19 159 8 25.0 232000000 200120000 374085065 336.0 5.03695260241
Daniel Craig, Olga Kurylenko, Mathieu Amalric, Judi Dench Nominated for 2 BAFTA Film Awards. Another 4 wins & 30 nominations. 168400000.0 UK, USA 2009-03-24 Marc Forster Action, Adventure, Thriller English, Spanish, Italian, French, Swiss German, German 58.0 Sony/MGM PG-13 2008-11-14 106.0 Quantum of Solace movie Paul Haggis, Neal Purvis, Robert Wade tt0830515 6.59999990463 350860.0 537 163 166 931 6 47.0 230000000 169368427 591692078 1850.0 4.66343909411
Robert Downey Jr., Chris Evans, Mark Ruffalo, Chris Hemsworth Nominated for 1 Oscar. Another 37 wins & 79 nominations. 623279547.0 USA 2012-09-25 Joss Whedon Action, Sci-Fi English, Russian, Hindi 69.0 Walt Disney Pictures PG-13 2012-05-04 143.0 The Avengers movie Joss Whedon (screenplay), Zak Penn (story), Joss Whedon (story) tt0848228 8.10000038147 1056595.0 709 262 227 960 77 72.0 225000000 623279547 1519479547 2307.0 4.96284463026
Henry Cavill, Amy Adams, Michael Shannon, Diane Lane 7 wins & 46 nominations. 291021565.0 USA, Canada, UK 2013-11-12 Zack Snyder Action, Adventure, Fantasy English 55.0 Warner Bros. Pictures PG-13 2013-06-14 143.0 Man of Steel movie David S. Goyer (screenplay), David S. Goyer (story), Christopher Nolan (story), Jerry Siegel (Superman created by), Joe Shuster (Superman created by) tt0770828 7.09999990463 585763.0 433 153 197 705 118 55.0 225000000 291045518 667999518 1661.0 4.96284463026
Ben Barnes, Georgie Henley, Skandar Keynes, William Moseley 2 wins & 20 nominations. 141614023.0 USA, Poland, Slovenia, Czech Republic 2008-12-02 Andrew Adamson Action, Adventure, Family English 62.0 Walt Disney Pictures PG 2008-05-16 150.0 The Chronicles of Narnia: Prince Caspian movie Andrew Adamson (screenplay), Christopher Markus (screenplay), Stephen McFeely (screenplay), C.S. Lewis (novel) tt0499448 6.59999990463 161734.0 160 65 62 159 7 14.0 225000000 141621490 417341288 467.0 5.0106352941
Andrew Garfield, Emma Stone, Rhys Ifans, Denis Leary 2 wins & 31 nominations. 262030663.0 USA 2012-11-09 Marc Webb Action, Adventure English 66.0 Sony Pictures PG-13 2012-07-03 136.0 The Amazing Spider-Man movie James Vanderbilt (screenplay), Alvin Sargent (screenplay), Steve Kloves (screenplay), James Vanderbilt (story), Stan Lee (based on the Marvel comic book by), Steve Ditko (based on the Marvel comic book by) tt0948470 7.0 480511.0 135 206 121 447 31 40.0 220000000 262030663 757890267 980.0 4.91265488574
Chris Pratt, Bryce Dallas Howard, Irrfan Khan, Vincent D'Onofrio 6 wins & 55 nominations. 528757749.0 USA 2015-10-20 Colin Trevorrow Action, Adventure, Sci-Fi English 59.0 Universal Pictures PG-13 2015-06-12 124.0 Jurassic World movie Rick Jaffa (screenplay), Amanda Silver (screenplay), Colin Trevorrow (screenplay), Derek Connolly (screenplay), Rick Jaffa (story), Amanda Silver (story), Michael Crichton (characters) tt0369610 7.0 461893.0 409 102 191 532 3 179.0 215000000 652198010 1671640593 1416.0 4.82028156561
Will Smith, Tommy Lee Jones, Josh Brolin, Jemaine Clement 1 win & 13 nominations. 179020854.0 USA 2012-11-30 Barry Sonnenfeld Action, Adventure, Comedy English, Ukrainian 58.0 Sony Pictures PG-13 2012-05-25 106.0 Men in Black 3 movie Etan Cohen, Lowell Cunningham (based on the Malibu comic by) tt1409024 6.80000019073 281172.0 52 168 107 370 3 38.0 215000000 179020854 654213485 738.0 4.66343909411
Shia LaBeouf, Megan Fox, Josh Duhamel, Tyrese Gibson Nominated for 1 Oscar. Another 15 wins & 27 nominations. 402076689.0 USA 2009-10-20 Michael Bay Action, Adventure, Sci-Fi English, Spanish 35.0 Paramount/Dreamworks PG-13 2009-06-24 150.0 Transformers: Revenge of the Fallen movie Ehren Kruger, Roberto Orci, Alex Kurtzman tt1055369 6.0 340930.0 869 126 45 848 12 62.0 210000000 402111870 836519699 1962.0 5.0106352941
Mark Wahlberg, Stanley Tucci, Kelsey Grammer, Nicola Peltz 5 wins & 23 nominations. 206755538.0 USA, China 2014-09-30 Michael Bay Action, Adventure, Sci-Fi English 32.0 Paramount Pictures PG-13 2014-06-27 165.0 Transformers: Age of Extinction movie Ehren Kruger tt2109248 5.69999980927 261393.0 546 192 211 743 64 89.0 210000000 245439076 1104039076 1845.0 5.1059454739
Hugh Jackman, Halle Berry, Ian McKellen, Patrick Stewart 7 wins & 37 nominations. 234300000.0 Canada, USA, UK 2006-10-03 Brett Ratner Action, Adventure, Fantasy English 58.0 20th Century Fox PG-13 2006-05-26 104.0 X-Men: The Last Stand movie Simon Kinberg, Zak Penn tt0376994 6.69999980927 412975.0 166 0 60 226 11 53.0 210000000 234362462 459260946 516.0 4.64439089914
Russell Crowe, Cate Blanchett, Max von Sydow, William Hurt 1 win & 14 nominations. 105219735.0 USA, UK 2010-09-21 Ridley Scott Action, Adventure, Drama English, French, Ukrainian 53.0 Universal PG-13 2010-05-14 140.0 Robin Hood movie Brian Helgeland (screenplay), Brian Helgeland (story), Ethan Reiff (story), Cyrus Voris (story) tt0955308 6.69999980927 223344.0 285 137 93 406 12 45.0 210000000 105269730 322241588 978.0 4.94164242261
Taylor Kitsch, Alexander Skarsgård, Rihanna, Brooklyn Decker 4 wins & 15 nominations. 65173160.0 USA 2012-08-28 Peter Berg Action, Adventure, Sci-Fi English, Japanese 41.0 Universal PG-13 2012-05-18 131.0 Battleship movie Jon Hoeber, Erich Hoeber tt1440129 5.80000019073 212450.0 327 161 152 639 62 55.0 209000000 65233400 305218228 1396.0 4.8751973232
Naomi Watts, Jack Black, Adrien Brody, Thomas Kretschmann Won 3 Oscars. Another 43 wins & 100 nominations. 218100000.0 New Zealand, USA, Germany 2006-03-28 Peter Jackson Action, Adventure, Drama English 81.0 Universal Pictures PG-13 2005-12-14 187.0 King Kong movie Fran Walsh (screenplay), Philippa Boyens (screenplay), Peter Jackson (screenplay), Merian C. Cooper (based on a story by), Edgar Wallace (based on a story by) tt0360717 7.19999980927 338465.0 151 0 96 302 8 50.0 207000000 218080025 550517357 607.0 5.23110861685
Nicole Kidman, Daniel Craig, Dakota Blue Richards, Ben Walker Won 1 Oscar. Another 6 wins & 32 nominations. 70100000.0 UK, USA 2008-04-29 Chris Weitz Adventure, Family, Fantasy English, Icelandic, Russian, French 51.0 New Line Cinema PG-13 2007-12-07 113.0 The Golden Compass movie Chris Weitz (screenplay), Philip Pullman (novel) tt0385752 6.09999990463 156268.0 139 64 31 138 6 26.0 205000000 70107728 367262558 404.0 4.72738781871
Leonardo DiCaprio, Kate Winslet, Billy Zane, Kathy Bates Won 11 Oscars. Another 110 wins & 74 nominations. nan USA 2012-09-10 James Cameron Drama, Romance English, Swedish 74.0 Paramount Pictures PG-13 1997-12-19 194.0 Titanic movie James Cameron tt0120338 7.69999980927 856815.0 253 95 75 391 20 86.0 200000000 658672302 2207615668 920.0 5.26785815906
Tom Hanks, Tim Allen, Joan Cusack, Ned Beatty Won 2 Oscars. Another 58 wins & 91 nominations. 414984497.0 USA 2010-11-02 Lee Unkrich Animation, Adventure, Comedy English, Spanish 92.0 Walt Disney Pictures G 2010-06-18 103.0 Toy Story 3 movie John Lasseter (story by), Andrew Stanton (story by), Lee Unkrich (story by), Michael Arndt (screenplay) tt0435761 8.30000019073 598416.0 417 186 101 413 17 29.0 200000000 415004880 1069818229 1163.0 4.63472898823
Robert Downey Jr., Gwyneth Paltrow, Don Cheadle, Guy Pearce Nominated for 1 Oscar. Another 17 wins & 61 nominations. 408992272.0 China, USA 2013-09-24 Shane Black Action, Adventure, Sci-Fi English 62.0 Walt Disney Pictures PG-13 2013-05-03 130.0 Iron Man 3 movie Drew Pearce (screenplay), Shane Black (screenplay), Stan Lee (based on the Marvel comic book by), Don Heck (based on the Marvel comic book by), Larry Lieber (based on the Marvel comic book by), Jack Kirby (based on the Marvel comic book by), Warren Ellis (based on the "Extremis" mini-series written by), Adi Granov (based on the "Extremis" mini-series illustrated by) tt1300854 7.19999980927 597910.0 635 272 222 851 117 65.0 200000000 408992272 1215392272 2162.0 4.86753445046
Tobey Maguire, Kirsten Dunst, James Franco, Alfred Molina Won 1 Oscar. Another 23 wins & 59 nominations. 373377893.0 USA 2004-11-30 Sam Raimi Action, Adventure English, Russian, Chinese 83.0 Sony Pictures PG-13 2004-06-30 127.0 Spider-Man 2 movie Stan Lee (comic book), Steve Ditko (comic book), Alfred Gough (screen story), Miles Millar (screen story), Michael Chabon (screen story), Alvin Sargent (screenplay) tt0316654 7.30000019073 448894.0 24 0 34 89 0 45.0 200000000 373524485 795110670 192.0 4.84418708646
Johnny Depp, Mia Wasikowska, Helena Bonham Carter, Anne Hathaway Won 2 Oscars. Another 32 wins & 63 nominations. 319323000.0 USA 2010-06-01 Tim Burton Adventure, Family, Fantasy English 53.0 Walt Disney Pictures PG 2010-03-05 108.0 Alice in Wonderland movie Linda Woolverton (screenplay), Lewis Carroll (books) tt1014759 6.5 328333.0 390 157 90 387 16 34.0 200000000 334191110 1025491110 1074.0 4.68213122712
Daniel Craig, Judi Dench, Javier Bardem, Ralph Fiennes Won 2 Oscars. Another 65 wins & 119 nominations. 299300000.0 UK, USA 2013-03-11 Sam Mendes Action, Adventure, Thriller English 81.0 MGM PG-13 2012-11-09 143.0 Skyfall movie Neal Purvis, Robert Wade, John Logan tt1074638 7.80000019073 551983.0 464 228 155 742 83 44.0 200000000 304360277 1110526981 1716.0 4.96284463026
Billy Crystal, John Goodman, Steve Buscemi, Helen Mirren Nominated for 1 BAFTA Film Award. Another 9 wins & 56 nominations. 260300000.0 USA 2013-10-29 Dan Scanlon Animation, Adventure, Comedy English 65.0 Walt Disney Pictures G 2013-06-21 104.0 Monsters University movie Dan Scanlon (story by), Daniel Gerson (story by), Robert L. Baird (story by), Daniel Gerson (screenplay), Robert L. Baird (screenplay), Dan Scanlon (screenplay) tt1453405 7.30000019073 256733.0 42 90 132 337 101 36.0 200000000 268488329 743588329 738.0 4.64439089914
James Franco, Mila Kunis, Rachel Weisz, Michelle Williams 5 wins & 31 nominations. 234903076.0 USA 2013-06-11 Sam Raimi Adventure, Family, Fantasy English 44.0 Walt Disney Pictures PG 2013-03-08 130.0 Oz the Great and Powerful movie Mitchell Kapner (screenplay), David Lindsay-Abaire (screenplay), Mitchell Kapner (screen story), L. Frank Baum ("Oz" works) tt1623205 6.30000019073 182589.0 303 126 106 1 0 17.0 200000000 234770996 490359051 553.0 4.86753445046
Hugh Jackman, James McAvoy, Michael Fassbender, Jennifer Lawrence Nominated for 1 Oscar. Another 15 wins & 47 nominations. 199305306.0 USA, UK, Canada 2014-10-14 Bryan Singer Action, Adventure, Sci-Fi English, Vietnamese, French 74.0 20th Century Fox PG-13 2014-05-23 132.0 X-Men: Days of Future Past movie Simon Kinberg (screenplay), Jane Goldman (story by), Simon Kinberg (story by), Matthew Vaughn (story by) tt1877832 8.0 561421.0 231 251 497 905 95 113.0 200000000 233921534 747862775 2092.0 4.88280192259
Andrew Garfield, Emma Stone, Jamie Foxx, Dane DeHaan 3 wins & 29 nominations. 183277573.0 USA 2014-08-19 Marc Webb Action, Adventure, Sci-Fi English 53.0 Sony Pictures PG-13 2014-05-02 142.0 The Amazing Spider-Man 2 movie Alex Kurtzman (screenplay), Roberto Orci (screenplay), Jeff Pinkner (screenplay), Alex Kurtzman (screen story), Roberto Orci (screen story), Jeff Pinkner (screen story), James Vanderbilt (screen story), Stan Lee (Marvel comic book), Steve Ditko (Marvel comic book) tt1872181 6.69999980927 350188.0 20 198 59 348 1 25.0 200000000 202853933 708996336 651.0 4.9558270576
Larry the Cable Guy, Owen Wilson, Michael Caine, Emily Mortimer Nominated for 1 Golden Globe. Another 1 win & 18 nominations. 191450875.0 USA 2011-11-01 John Lasseter, Brad Lewis(co-director) Animation, Adventure, Comedy English, Japanese, Italian, French 57.0 Walt Disney Pictures/PIXAR G 2011-06-24 106.0 Cars 2 movie John Lasseter (original story by), Brad Lewis (original story by), Dan Fogelman (original story by), Ben Queen (screenplay) tt1216475 6.19999980927 115079.0 278 159 108 398 24 35.0 200000000 191450875 560155383 1002.0 4.66343909411
Jeff Bridges, Garrett Hedlund, Olivia Wilde, Bruce Boxleitner Nominated for 1 Oscar. Another 10 wins & 49 nominations. 172051787.0 USA 2011-04-05 Joseph Kosinski Action, Adventure, Sci-Fi English 49.0 Walt Disney Pictures PG 2010-12-17 125.0 TRON: Legacy movie Edward Kitsis (screenplay), Adam Horowitz (screenplay), Edward Kitsis (story), Adam Horowitz (story), Brian Klugman (story), Lee Sternthal (story), Steven Lisberger (characters), Bonnie MacBird (characters) tt1104001 6.80000019073 276848.0 358 206 103 509 25 40.0 200000000 172062763 400062763 1241.0 4.8283137373
John Cusack, Amanda Peet, Chiwetel Ejiofor, Thandie Newton 5 wins & 21 nominations. 166112167.0 USA 2010-03-02 Roland Emmerich Action, Adventure, Sci-Fi English, French, Tibetan, Mandarin, Russian, Hindi, Portuguese, Latin, Italian 49.0 Sony Pictures/Columbia PG-13 2009-11-13 158.0 2012 movie Roland Emmerich, Harald Kloser tt1190080 5.80000019073 301695.0 98 150 115 1101 10 94.0 200000000 166112167 788408539 1568.0 5.06259503303
Christian Bale, Sam Worthington, Moon Bloodgood, Helena Bonham Carter 2 wins & 13 nominations. 125286889.0 USA, Germany, UK, Italy 2009-12-01 McG Action, Adventure, Drama English, Italian 49.0 Warner Bros. Pictures PG-13 2009-05-21 115.0 Terminator Salvation movie John Brancato, Michael Ferris tt0438488 6.59999990463 299277.0 664 131 84 771 7 41.0 200000000 125322469 365491792 1698.0 4.74493212836
Ryan Reynolds, Blake Lively, Peter Sarsgaard, Mark Strong 3 wins & 6 nominations. 116600000.0 USA 2011-10-14 Martin Campbell Action, Adventure, Sci-Fi English 39.0 Warner Bros. Pictures PG-13 2011-06-17 114.0 Green Lantern movie Greg Berlanti (screenplay), Michael Green (screenplay), Marc Guggenheim (screenplay), Michael Goldenberg (screenplay), Greg Berlanti (screen story), Michael Green (screen story), Marc Guggenheim (screen story) tt1133985 5.59999990463 233624.0 283 167 110 542 37 54.0 200000000 116601172 219535492 1193.0 4.73619844839
Shia LaBeouf, Rosie Huntington-Whiteley, Josh Duhamel, John Turturro Nominated for 3 Oscars. Another 10 wins & 39 nominations. 352358779.0 USA 2011-09-30 Michael Bay Action, Adventure, Sci-Fi English 42.0 Paramount Studios PG-13 2011-06-29 154.0 Transformers: Dark of the Moon movie Ehren Kruger tt1399103 6.30000019073 343849.0 433 235 60 666 32 61.0 195000000 352390543 1123790543 1487.0 5.03695260241
Nicholas Hoult, Eleanor Tomlinson, Ewan McGregor, Stanley Tucci 1 win & 4 nominations. 65171860.0 USA 2013-06-18 Bryan Singer Adventure, Fantasy English 51.0 Warner Bros. PG-13 2013-03-01 114.0 Jack the Giant Slayer movie Darren Lemke (screenplay), Christopher McQuarrie (screenplay), Dan Studney (screenplay), Darren Lemke (story), David Dobkin (story) tt1351685 6.30000019073 112914.0 288 136 19 395 54 22.0 195000000 65187603 197687603 914.0 4.73619844839
Vin Diesel, Paul Walker, Jason Statham, Michelle Rodriguez Nominated for 1 Golden Globe. Another 24 wins & 28 nominations. 316986481.0 USA, Japan 2015-09-15 James Wan Action, Crime, Thriller English 67.0 Universal Pictures PG-13 2015-04-03 137.0 Furious 7 movie Chris Morgan, Gary Scott Thompson (characters) tt2820852 7.19999980927 306217.0 59 112 185 225 3 205.0 190000000 351032910 1516748684 789.0 4.91998092583
Chris Pine, Zachary Quinto, Zoe Saldana, Karl Urban Nominated for 1 Oscar. Another 6 wins & 56 nominations. 228756232.0 USA 2013-09-10 J.J. Abrams Action, Adventure, Sci-Fi English, Klingon 72.0 Paramount PG-13 2013-05-16 132.0 Star Trek Into Darkness movie Roberto Orci, Alex Kurtzman, Damon Lindelof, Gene Roddenberry (television series "Star Trek") tt1408101 7.80000019073 421285.0 409 188 80 619 118 51.0 190000000 228778661 467381584 1465.0 4.88280192259
Brad Pitt, Mireille Enos, Daniella Kertesz, James Badge Dale 3 wins & 24 nominations. 202351611.0 USA 2013-09-17 Marc Forster Action, Adventure, Horror English, Spanish, Hebrew, Arabic 63.0 Paramount Pictures PG-13 2013-06-21 116.0 World War Z movie Matthew Michael Carnahan (screenplay), Drew Goddard (screenplay), Damon Lindelof (screenplay), Matthew Michael Carnahan (screen story), J. Michael Straczynski (screen story), Max Brooks (based on the novel by) tt0816711 7.0 500790.0 326 184 95 524 101 60.0 190000000 202359711 531514650 1290.0 4.75359019111
Lisa Adam, Frank Aldridge, Amitabh Bachchan, Steve Bisley Won 2 Oscars. Another 47 wins & 83 nominations. 144812796.0 Australia, USA 2013-08-27 Baz Luhrmann Drama, Romance English 55.0 Warner Bros. Pictures PG-13 2013-05-10 143.0 The Great Gatsby movie Baz Luhrmann (screenplay), Craig Pearce (screenplay), F. Scott Fitzgerald (based on the novel by) tt1343092 7.30000019073 391520.0 197 83 17 282 8 27.0 190000000 144840419 351040419 614.0 4.96284463026
Charlie Hunnam, Diego Klattenhoff, Idris Elba, Rinko Kikuchi Nominated for 1 BAFTA Film Award. Another 6 wins & 47 nominations. 101785482.0 USA 2013-10-15 Guillermo del Toro Action, Adventure, Sci-Fi English, Japanese, Cantonese, Mandarin 64.0 Warner Bros. Pictures PG-13 2013-07-12 131.0 Pacific Rim movie Travis Beacham (screenplay), Guillermo del Toro (screenplay), Travis Beacham (story) tt1663662 7.0 405412.0 409 146 197 647 124 51.0 190000000 101802906 411002906 1574.0 4.8751973232
Jeffrey Wright, Frances McDormand, Maleah Nipay-Padilla, Ryan Teeple Nominated for 1 Golden Globe. Another 7 wins & 39 nominations. 94166454.0 USA 2016-02-23 Peter Sohn Animation, Adventure, Comedy English 66.0 Disney/Pixar PG 2015-11-25 93.0 The Good Dinosaur movie Bob Peterson (original concept & development by), Peter Sohn (story by), Erik Benson (story by), Meg LeFauve (story by), Kelsey Mann (story by), Bob Peterson (story by), Meg LeFauve (screenplay), Peter Hedges (additional screenplay material by), Adrian Molina (additional screenplay material by) tt1979388 6.80000019073 79204.0 191 43 77 189 16 59.0 187500000 123087120 334342692 575.0 4.53259949315
Robert Downey Jr., Terrence Howard, Jeff Bridges, Gwyneth Paltrow Nominated for 2 Oscars. Another 20 wins & 65 nominations. 318298180.0 USA 2008-09-30 Jon Favreau Action, Adventure, Sci-Fi English, Persian, Urdu, Arabic, Hungarian 79.0 Paramount Pictures PG-13 2008-05-02 126.0 Iron Man movie Mark Fergus (screenplay), Hawk Ostby (screenplay), Art Marcum (screenplay), Matt Holloway (screenplay), Stan Lee (characters), Don Heck (characters), Larry Lieber (characters), Jack Kirby (characters) tt0371746 7.90000009537 747405.0 274 152 165 729 14 72.0 186000000 318604126 585171547 1406.0 4.83628190695
Christian Bale, Heath Ledger, Aaron Eckhart, Michael Caine Won 2 Oscars. Another 151 wins & 154 nominations. 533316061.0 USA, UK 2008-12-09 Christopher Nolan Action, Crime, Drama English, Mandarin 82.0 Warner Bros. Pictures/Legendary PG-13 2008-07-18 152.0 The Dark Knight movie Jonathan Nolan (screenplay), Christopher Nolan (screenplay), Christopher Nolan (story), David S. Goyer (story), Bob Kane (characters) tt0468569 9.0 1814804.0 563 230 228 753 14 41.0 185000000 533345358 1001926710 1829.0 5.02388052085
Harrison Ford, Cate Blanchett, Karen Allen, Shia LaBeouf Nominated for 1 BAFTA Film Award. Another 10 wins & 34 nominations. 316957122.0 USA 2008-10-14 Steven Spielberg Action, Adventure, Fantasy English, German, Russian 65.0 Paramount Pictures PG-13 2008-05-22 122.0 Indiana Jones and the Kingdom of the Crystal Skull movie David Koepp (screenplay), George Lucas (story), Jeff Nathanson (story), George Lucas (characters), Philip Kaufman (characters) tt0367882 6.19999980927 354599.0 714 96 41 326 12 33.0 185000000 317023851 786558145 1222.0 4.80402104473
Kelly Macdonald, Billy Connolly, Emma Thompson, Julie Walters Won 1 Oscar. Another 18 wins & 48 nominations. 237282182.0 USA 2012-11-13 Mark Andrews, Brenda Chapman, Steve Purcell(co-director) Animation, Adventure, Comedy English 69.0 Walt Disney Pictures PG 2012-06-22 93.0 Brave movie Brenda Chapman (story by), Mark Andrews (screenplay), Steve Purcell (screenplay), Brenda Chapman (screenplay), Irene Mecchi (screenplay) tt1217209 7.19999980927 299622.0 256 149 115 521 38 42.0 185000000 237282182 554606532 1121.0 4.53259949315
Chris Pine, Zachary Quinto, Karl Urban, Zoe Saldana Nominated for 1 Oscar. Another 2 wins & 25 nominations. 158804470.0 USA, Hong Kong, China 2016-11-01 Justin Lin Action, Adventure, Sci-Fi English 68.0 Paramount Pictures PG-13 2016-07-22 122.0 Star Trek Beyond movie Simon Pegg, Doug Jung, Gene Roddenberry (based upon "Star Trek" created by) tt2660888 7.09999990463 175228.0 1 0 0 6 0 0.0 185000000 158848340 336398312 7.0 4.80402104473
Georgie Henley, Skandar Keynes, William Moseley, Anna Popplewell Won 1 Oscar. Another 14 wins & 46 nominations. 291685219.0 USA, UK 2006-04-04 Andrew Adamson Adventure, Family, Fantasy English, German 75.0 Buena Vista PG 2005-12-09 143.0 The Chronicles of Narnia: The Lion, the Witch and the Wardrobe movie Ann Peacock (screenplay), Andrew Adamson (screenplay), Christopher Markus (screenplay), Stephen McFeely (screenplay), C.S. Lewis (book) tt0363771 6.90000009537 307790.0 87 74 27 87 7 19.0 180000000 291710957 720539572 301.0 4.96284463026
Angelina Jolie, Elle Fanning, Sharlto Copley, Lesley Manville Nominated for 1 Oscar. Another 10 wins & 41 nominations. 190871149.0 USA 2014-11-04 Robert Stromberg Action, Adventure, Family English 56.0 Walt Disney Pictures PG 2014-05-30 97.0 Maleficent movie Linda Woolverton (screenplay), Charles Perrault (based on "La Belle au bois dormant" written by) tt1587310 7.0 272537.0 356 141 154 445 55 48.0 180000000 241407328 758536735 1199.0 4.5747109785
Ben Burtt, Elissa Knight, Jeff Garlin, Fred Willard Won 1 Oscar. Another 89 wins & 90 nominations. 223749872.0 USA 2008-11-18 Andrew Stanton Animation, Adventure, Family English 95.0 Walt Disney Pictures G 2008-06-27 98.0 WALL·E movie Andrew Stanton (original story by), Pete Docter (original story by), Andrew Stanton (screenplay), Jim Reardon (screenplay) tt0910970 8.39999961853 787663.0 314 133 180 453 7 0.0 180000000 223808164 532590994 1087.0 4.58496747867
Chris Tucker, Jackie Chan, Max von Sydow, Hiroyuki Sanada 9 nominations. 140080850.0 USA, Germany 2007-12-18 Brett Ratner Action, Comedy, Crime English, French, Japanese, Mandarin, Latin 44.0 New Line Cinema PG-13 2007-08-10 91.0 Rush Hour 3 movie Jeff Nathanson, Ross LaManna (characters) tt0293564 6.19999980927 129119.0 247 0 81 259 6 28.0 180000000 140125968 256585882 621.0 4.51085950652
Alexander Skarsgård, Rory J. Saper, Christian Stevens, Christoph Waltz 1 win & 4 nominations. 126585313.0 UK, Canada, USA 2016-10-11 David Yates Action, Adventure, Drama English 44.0 Lionsgate Pictures PG-13 2016-07-01 110.0 The Legend of Tarzan movie Adam Cozad (screenplay), Craig Brewer (screenplay), Craig Brewer (story by), Adam Cozad (story by), Edgar Rice Burroughs (based on the "Tarzan" stories created by) tt0918940 6.30000019073 124306.0 50 12 23 50 0 44.0 180000000 126643061 349143061 179.0 4.70048036579
Ben Kingsley, Sacha Baron Cohen, Asa Butterfield, Chloë Grace Moretz Won 5 Oscars. Another 56 wins & 186 nominations. 73820094.0 USA 2012-02-28 Martin Scorsese Adventure, Drama, Family English 83.0 Paramount Studios PG 2011-11-23 126.0 Hugo movie John Logan (screenplay), Brian Selznick (book) tt0970179 7.5 261635.0 72 121 89 314 33 40.0 180000000 73864507 180047784 669.0 4.83628190695
Dane DeHaan, Cara Delevingne, Clive Owen, Rihanna nan 38359317.0 France nan Luc Besson Action, Adventure, Fantasy English, French 51.0 EuropaCorp / STXfilms PG-13 2017-07-21 137.0 Valerian and the City of a Thousand Planets movie Pierre Christin (based on the comic book series "Valerian and Laureline" by), Jean-Claude Mézières (based on the comic book series "Valerian and Laureline" by), Luc Besson (screenplay) tt2239822 6.80000019073 23083.0 0 0 0 0 0 17.0 180000000 39272263 124264863 17.0 4.91998092583
Mila Kunis, Channing Tatum, Sean Bean, Eddie Redmayne 4 wins & 16 nominations. 43733037.0 USA, Australia 2015-06-02 Lana Wachowski, Lilly Wachowski Action, Adventure, Sci-Fi English, Russian 40.0 Warner Bros. Pictures PG-13 2015-02-06 127.0 Jupiter Ascending movie Lilly Wachowski, Lana Wachowski tt1617661 5.30000019073 151887.0 243 57 120 254 29 99.0 179000000 47482519 181982519 802.0 4.84418708646
James McAvoy, Michael Fassbender, Jennifer Lawrence, Nicholas Hoult 13 nominations. 135729385.0 USA 2016-10-04 Bryan Singer Action, Adventure, Sci-Fi English, Polish, German, Arabic, Egyptian (Ancient) 52.0 20th Century Fox PG-13 2016-05-27 144.0 X-Men: Apocalypse movie Simon Kinberg (screenplay), Bryan Singer (story by), Simon Kinberg (story by), Michael Dougherty (story by), Dan Harris (story by) tt3385516 7.0 290362.0 150 26 66 302 0 130.0 178000000 155442489 542742489 674.0 4.96981329958
Tom Cruise, Emily Blunt, Brendan Gleeson, Bill Paxton 11 wins & 36 nominations. 77121429.0 USA, Canada 2014-10-07 Doug Liman Action, Adventure, Sci-Fi English 71.0 Warner Bros. Pictures PG-13 2014-06-06 113.0 Edge of Tomorrow movie Christopher McQuarrie (screenplay), Jez Butterworth (screenplay), John-Henry Butterworth (screenplay), Hiroshi Sakurazaka (based on the novel "All You Need Is Kill" by) tt1631867 7.90000009537 479498.0 569 0 214 604 71 47.0 178000000 100206256 370541256 1505.0 4.72738781871
Neel Sethi, Bill Murray, Ben Kingsley, Idris Elba Won 1 Oscar. Another 28 wins & 44 nominations. 363995937.0 UK, USA 2016-08-30 Jon Favreau Adventure, Drama, Family English 77.0 Walt Disney Pictures PG 2016-04-15 106.0 The Jungle Book movie Justin Marks (screenplay), Rudyard Kipling (based on the books by) tt3040964 7.5 204799.0 122 18 50 152 0 105.0 175000000 364001123 963901123 447.0 4.66343909411
Amy Poehler, Phyllis Smith, Richard Kind, Bill Hader Won 1 Oscar. Another 94 wins & 106 nominations. 264317903.0 USA 2015-11-03 Pete Docter, Ronnie Del Carmen(co-director) Animation, Adventure, Comedy English 94.0 Disney/Pixar PG 2015-06-19 95.0 Inside Out movie Pete Docter (original story by), Ronnie Del Carmen (original story by), Pete Docter (screenplay), Meg LeFauve (screenplay), Josh Cooley (screenplay), Michael Arndt (additional story material by), Bill Hader (additional dialogue by), Amy Poehler (additional dialogue by), Simon Rich (additional story material by) tt2096673 8.19999980927 432713.0 290 78 116 313 32 98.0 175000000 356461711 853707581 927.0 4.5538768916
Edward Asner, Christopher Plummer, Jordan Nagai, Bob Peterson Won 2 Oscars. Another 74 wins & 81 nominations. 292979556.0 USA 2009-11-10 Pete Docter, Bob Peterson Animation, Adventure, Comedy English 88.0 Walt Disney Pictures PG 2009-05-29 96.0 Up movie Pete Docter (story by), Bob Peterson (story by), Tom McCarthy (story by), Bob Peterson (screenplay), Pete Docter (screenplay) tt1049413 8.30000019073 732868.0 411 113 239 2447 34 131.0 175000000 293004164 731542621 3375.0 4.56434819147
Reese Witherspoon, Seth Rogen, Hugh Laurie, Will Arnett 3 wins & 9 nominations. 198332128.0 USA 2009-09-29 Rob Letterman, Conrad Vernon Animation, Action, Adventure English 56.0 Paramount/Dreamworks Animation PG 2009-03-27 94.0 Monsters vs. Aliens movie Maya Forbes (screenplay), Wallace Wolodarsky (screenplay), Rob Letterman (screenplay), Jonathan Aibel (screenplay), Glenn Berger (screenplay), Rob Letterman (story), Conrad Vernon (story) tt0892782 6.5 122884.0 273 64 40 378 4 11.0 175000000 198351526 381687380 770.0 4.54329478227
Adewale Akinnuoye-Agbaje, Christopher Eccleston, Grégory Fitoussi, Joseph Gordon-Levitt 3 wins & 17 nominations. 150167630.0 USA, Czech Republic 2009-11-03 Stephen Sommers Action, Adventure, Sci-Fi English, French, Scottish Gaelic 32.0 Paramount Pictures PG-13 2009-08-07 118.0 G.I. Joe: The Rise of Cobra movie Stuart Beattie (screenplay), David Elliot (screenplay), Paul Lovett (screenplay), Michael B. Gordon (story), Stuart Beattie (story), Stephen Sommers (story) tt1046173 5.80000019073 181588.0 436 102 68 521 8 38.0 175000000 150201498 302469017 1173.0 4.77068462447
Will Smith, Kevin Kline, Kenneth Branagh, Salma Hayek 12 wins & 15 nominations. nan USA 1999-11-30 Barry Sonnenfeld Action, Comedy, Sci-Fi English 38.0 Warner Bros. Pictures PG-13 1999-06-30 106.0 Wild Wild West movie Jim Thomas (story), John Thomas (story), S.S. Wilson (screenplay), Brent Maddock (screenplay), Jeffrey Price (screenplay), Peter S. Seaman (screenplay) tt0120891 4.80000019073 135166.0 40 17 13 72 6 30.0 175000000 113805681 221229335 178.0 4.66343909411
Brendan Fraser, Jet Li, Maria Bello, John Hannah 2 wins & 6 nominations. 101600000.0 USA, Germany, China 2008-12-16 Rob Cohen Action, Adventure, Fantasy English, Mandarin, Sanskrit 31.0 Universal Pictures PG-13 2008-08-01 112.0 The Mummy: Tomb of the Dragon Emperor movie Alfred Gough, Miles Millar tt0859163 5.19999980927 127367.0 301 92 88 363 1 34.0 175000000 102491776 405760225 879.0 4.7184988713
Steve Carell, Morgan Freeman, Lauren Graham, Johnny Simmons 2 wins & 11 nominations. 100289690.0 USA 2007-10-09 Tom Shadyac Comedy, Family, Fantasy English 37.0 Universal Pictures PG 2007-06-22 96.0 Evan Almighty movie Steve Oedekerk (screenplay), Steve Oedekerk (story), Joel Cohen (story), Alec Sokolow (story), Steve Koren (characters), Mark O'Keefe (characters) tt0413099 5.40000009537 120890.0 101 38 33 139 8 21.0 175000000 100289690 174131329 340.0 4.56434819147
Kevin Costner, Chaim Jeraffi, Rick Aviles, R.D. Call Nominated for 1 Oscar. Another 5 wins & 8 nominations. nan USA 1998-11-01 Kevin Reynolds Action, Adventure, Sci-Fi English 56.0 MCA Universal Home Video PG-13 1995-07-28 135.0 Waterworld movie Peter Rader, David Twohy tt0114898 6.09999990463 152791.0 67 38 23 108 2 50.0 175000000 88246220 264246220 288.0 4.90527477844
Keanu Reeves, Hiroyuki Sanada, Ko Shibasaki, Tadanobu Asano 5 nominations. 20518224.0 USA 2014-04-01 Carl Rinsch Action, Adventure, Drama English, Japanese 28.0 Universal Pictures PG-13 2013-12-25 128.0 47 Ronin movie Chris Morgan (screenplay), Hossein Amini (screenplay), Chris Morgan (screen story by), Walter Hamada (screen story by) tt1335975 6.30000019073 124792.0 47 142 139 396 76 49.0 175000000 38362475 151716815 849.0 4.85203026392
Chris Pratt, Zoe Saldana, Dave Bautista, Vin Diesel Nominated for 2 Oscars. Another 50 wins & 96 nominations. 270592504.0 USA, UK 2014-12-09 James Gunn Action, Adventure, Sci-Fi English 76.0 Walt Disney Pictures PG-13 2014-08-01 121.0 Guardians of the Galaxy movie James Gunn, Nicole Perlman, Dan Abnett (based on the Marvel comics by), Andy Lanning (based on the Marvel comics by), Bill Mantlo (character created by: Rocket Raccoon), Keith Giffen (character created by: Rocket Raccoon), Jim Starlin (characters created by: Drax the Destroyer, Gamora & Thanos), Steve Englehart (character created by: Star-Lord), Steve Gan (character created by: Star-Lord), Steve Gerber (character created by: Howard the Duck), Val Mayerik (character created by: Howard the Duck) tt2015381 8.10000038147 777797.0 551 189 220 615 44 131.0 170000000 333172112 771051335 1750.0 4.7957905456
Robert Downey Jr., Gwyneth Paltrow, Don Cheadle, Scarlett Johansson Nominated for 1 Oscar. Another 7 wins & 42 nominations. 312057433.0 USA 2010-09-28 Jon Favreau Action, Adventure, Sci-Fi English, French, Russian 57.0 Paramount Studios PG-13 2010-05-07 124.0 Iron Man 2 movie Justin Theroux (screenplay), Stan Lee (Marvel comic book), Don Heck (Marvel comic book), Larry Lieber (Marvel comic book), Jack Kirby (Marvel comic book) tt1228705 7.0 567330.0 647 0 88 446 23 68.0 170000000 312433331 621156389 1272.0 4.82028156561
Chris Evans, Samuel L. Jackson, Scarlett Johansson, Robert Redford Nominated for 1 Oscar. Another 5 wins & 50 nominations. 228636083.0 USA 2014-09-09 Anthony Russo, Joe Russo Action, Adventure, Sci-Fi English, French 70.0 Walt Disney Pictures PG-13 2014-04-04 136.0 Captain America: The Winter Soldier movie Christopher Markus (screenplay), Stephen McFeely (screenplay), Joe Simon (based on the Marvel comic by), Jack Kirby (based on the Marvel comic by) tt1843866 7.80000019073 551087.0 591 202 249 769 100 44.0 170000000 259746958 714401889 1955.0 4.91265488574
Andy Serkis, Jason Clarke, Gary Oldman, Keri Russell Nominated for 1 Oscar. Another 16 wins & 47 nominations. 183278877.0 USA, UK, Canada 2014-12-02 Matt Reeves Action, Adventure, Drama English, American Sign Language 79.0 20th Century Fox PG-13 2014-07-11 130.0 Dawn of the Planet of the Apes movie Mark Bomback, Rick Jaffa, Amanda Silver, Rick Jaffa (characters), Amanda Silver (characters), Pierre Boulle (novel) tt2103281 7.59999990463 351165.0 477 182 184 524 46 66.0 170000000 208545589 710644566 1479.0 4.86753445046
Tom Hanks, Leslie Zemeckis, Eddie Deezen, Nona Gaye Nominated for 3 Oscars. Another 5 wins & 23 nominations. 162800000.0 USA 2005-11-22 Robert Zemeckis Animation, Adventure, Family English 61.0 Warner Bros. Pictures G 2004-11-10 100.0 The Polar Express movie Chris Van Allsburg (book), Robert Zemeckis (screenplay), William Broyles Jr. (screenplay) tt0338348 6.59999990463 133206.0 116 59 35 123 7 11.0 170000000 194949659 319090241 351.0 4.60517018599
Kristen Stewart, Chris Hemsworth, Charlize Theron, Sam Claflin Nominated for 2 Oscars. Another 13 wins & 31 nominations. 155081785.0 USA 2012-09-11 Rupert Sanders Action, Adventure, Drama English 57.0 Universal Pictures PG-13 2012-06-01 127.0 Snow White and the Huntsman movie Evan Daugherty (screenplay), John Lee Hancock (screenplay), Hossein Amini (screenplay), Evan Daugherty (screen story) tt1735898 6.09999990463 241606.0 230 128 104 361 4 41.0 170000000 155136755 401021746 868.0 4.84418708646
Arnold Schwarzenegger, Nick Stahl, Claire Danes, Kristanna Loken 3 wins & 21 nominations. 150252753.0 USA, Germany, UK 2003-11-11 Jonathan Mostow Action, Sci-Fi English 66.0 Warner Bros. Pictures R 2003-07-02 109.0 Terminator 3: Rise of the Machines movie James Cameron (characters), Gale Anne Hurd (characters), John Brancato (story), Michael Ferris (story), Tedi Sarafian (story), John Brancato (screenplay), Michael Ferris (screenplay) tt0181852 6.30000019073 322978.0 93 43 32 145 6 46.0 170000000 150358296 433058296 365.0 4.69134788223
Hugh Jackman, Kate Beckinsale, Richard Roxburgh, David Wenham 3 wins & 20 nominations. nan USA, Czech Republic 2005-09-20 Stephen Sommers Action, Adventure, Fantasy English, Latin 35.0 nan PG-13 2004-05-07 131.0 Van Helsing movie Stephen Sommers tt0338526 6.0 209742.0 128 62 40 203 9 53.0 170000000 120150546 300150546 495.0 4.8751973232
George Clooney, Hugh Laurie, Britt Robertson, Raffey Cassidy 2 wins & 16 nominations. 71526443.0 USA, Spain 2015-10-13 Brad Bird Action, Adventure, Family English, French, Japanese 60.0 Walt Disney Pictures PG 2015-05-22 130.0 Tomorrowland movie Damon Lindelof (screenplay), Brad Bird (screenplay), Damon Lindelof (story by), Brad Bird (story by), Jeff Jensen (story by) tt1964418 6.5 145468.0 318 84 150 422 20 131.0 170000000 93436322 207283457 1125.0 4.86753445046
Johnny Depp, Mia Wasikowska, Helena Bonham Carter, Anne Hathaway 1 win & 12 nominations. 77037635.0 USA, UK 2016-10-18 James Bobin Adventure, Family, Fantasy English 34.0 Walt Disney Pictures PG 2016-05-27 113.0 Alice Through the Looking Glass movie Linda Woolverton (screenplay), Lewis Carroll (books) tt2567026 6.19999980927 60503.0 71 13 38 76 0 54.0 170000000 77042381 277442381 252.0 4.72738781871
Mike Myers, Eddie Murphy, Cameron Diaz, Antonio Banderas 1 win & 13 nominations. 238319043.0 USA 2010-12-07 Mike Mitchell Animation, Adventure, Comedy English 58.0 Paramount PG 2010-05-21 93.0 Shrek Forever After movie William Steig (book), Josh Klausner, Darren Lemke tt0892791 6.30000019073 149038.0 260 142 46 204 14 16.0 165000000 238736787 756244673 682.0 4.53259949315
Scott Adsit, Ryan Potter, Daniel Henney, T.J. Miller Won 1 Oscar. Another 13 wins & 55 nominations. nan USA 2015-02-24 Don Hall, Chris Williams Animation, Action, Adventure English 74.0 Walt Disney Pictures PG 2014-11-07 102.0 Big Hero 6 movie Jordan Roberts (screenplay), Robert L. Baird (screenplay), Daniel Gerson (screenplay), Man of Action (Big Hero 6 team and characters created by), Steven T. Seagle (characters), Duncan Rouleau (characters), Joe Kelly (characters), Joe Casey (characters) tt2245084 7.80000019073 314756.0 284 49 159 334 33 71.0 165000000 222527828 652127828 930.0 4.62497281328
Jay Baruchel, Gerard Butler, Craig Ferguson, America Ferrera Nominated for 2 Oscars. Another 25 wins & 61 nominations. 216900000.0 USA 2010-10-15 Dean DeBlois, Chris Sanders Animation, Action, Adventure English 74.0 Paramount/DWA PG 2010-03-26 98.0 How to Train Your Dragon movie William Davies (screenplay), Dean DeBlois (screenplay), Chris Sanders (screenplay), Cressida Cowell (book) tt0892769 8.10000038147 532544.0 360 181 82 379 17 23.0 165000000 217581231 494870991 1042.0 4.58496747867
John C. Reilly, Sarah Silverman, Jack McBrayer, Jane Lynch Nominated for 1 Oscar. Another 33 wins & 41 nominations. 189412677.0 USA 2013-03-05 Rich Moore Animation, Adventure, Comedy English 72.0 Walt Disney Pictures PG 2012-11-02 101.0 Wreck-It Ralph movie Rich Moore (story by), Phil Johnston (story by), Jim Reardon (story by), Phil Johnston (screenplay), Jennifer Lee (screenplay), John C. Reilly (additional story material by), Sam Levine (additional story material by), Jared Stern (additional story material by) tt1772341 7.69999980927 294857.0 179 136 101 361 61 37.0 165000000 189412677 496511521 875.0 4.61512051684
Ellen Burstyn, Matthew McConaughey, Mackenzie Foy, John Lithgow Won 1 Oscar. Another 41 wins & 142 nominations. 158737441.0 USA, UK, Canada, Iceland 2015-03-31 Christopher Nolan Adventure, Drama, Sci-Fi English 74.0 Paramount Pictures PG-13 2014-11-07 169.0 Interstellar movie Jonathan Nolan, Christopher Nolan tt0816692 8.60000038147 1068518.0 357 70 151 448 1 58.0 165000000 188017894 668913307 1085.0 5.12989871492
Liam Hemsworth, Jeff Goldblum, Jessie T. Usher, Bill Pullman 2 wins & 14 nominations. 103137295.0 USA 2016-10-18 Roland Emmerich Action, Adventure, Sci-Fi English, Mandarin 32.0 20th Century Fox PG-13 2016-06-24 120.0 Independence Day: Resurgence movie Nicolas Wright (screenplay), James A. Woods (screenplay), Dean Devlin (screenplay), Roland Emmerich (screenplay), James Vanderbilt (screenplay), Dean Devlin (story by), Roland Emmerich (story by), Nicolas Wright (story by), James A. Woods (story by), Dean Devlin (based on characters created by), Roland Emmerich (based on characters created by) tt1628841 5.30000019073 134675.0 45 11 16 90 0 65.0 165000000 103144286 387644286 227.0 4.78749174278
Mike Myers, Eddie Murphy, Cameron Diaz, Antonio Banderas Nominated for 1 BAFTA Film Award. Another 5 wins & 15 nominations. 320706665.0 USA 2007-11-13 Chris Miller, Raman Hui(co-director) Animation, Adventure, Comedy English 58.0 Dreamworks PG 2007-05-18 93.0 Shrek the Third movie Jeffrey Price (screenplay), Peter S. Seaman (screenplay), Chris Miller (screenplay), Aron Warner (screenplay), Andrew Adamson (story by), William Steig (based upon the book by) tt0413267 6.09999990463 228462.0 188 54 37 159 6 17.0 160000000 322719944 807330936 461.0 4.53259949315
Leonardo DiCaprio, Joseph Gordon-Levitt, Ellen Page, Tom Hardy Won 4 Oscars. Another 152 wins & 204 nominations. 292568851.0 USA, UK 2010-12-07 Christopher Nolan Action, Adventure, Sci-Fi English, Japanese, French 74.0 Warner Bros. Pictures PG-13 2010-07-16 148.0 Inception movie Christopher Nolan tt1375666 8.80000019073 1604649.0 565 0 50 621 22 50.0 160000000 292576195 832584416 1308.0 4.99721227376
Jennifer Lawrence, Josh Hutcherson, Liam Hemsworth, Woody Harrelson 15 wins & 28 nominations. 254641329.0 USA, Germany 2016-03-22 Francis Lawrence Action, Adventure, Sci-Fi English 65.0 Lionsgate Films PG-13 2015-11-20 137.0 The Hunger Games: Mockingjay - Part 2 movie Peter Craig (screenplay), Danny Strong (screenplay), Suzanne Collins (adaptation), Suzanne Collins (novel) tt1951266 6.59999990463 208259.0 1 58 116 245 0 231.0 160000000 281723902 650523427 651.0 4.91998092583
Aaron Taylor-Johnson, CJ Adams, Ken Watanabe, Bryan Cranston 6 wins & 31 nominations. 172962996.0 USA, Japan 2014-09-16 Gareth Edwards Action, Adventure, Sci-Fi English, Japanese 62.0 Warner Bros Pictures PG-13 2014-05-16 123.0 Godzilla movie Max Borenstein (screenplay), Dave Callaham (story), Ishirô Honda (based on the character created by), Takeo Murata (based on the character created by), Shigeru Kayama (based on the character created by) tt0831387 6.40000009537 322140.0 399 168 199 658 69 24.0 160000000 200676069 529076069 1517.0 4.81218435537
James McAvoy, Laurence Belcher, Michael Fassbender, Bill Milner 20 wins & 38 nominations. 145300000.0 USA, UK 2011-09-09 Matthew Vaughn Action, Adventure, Sci-Fi English, German, French, Spanish, Russian 65.0 20th Century Fox PG-13 2011-06-03 132.0 X-Men: First Class movie Ashley Miller (screenplay), Zack Stentz (screenplay), Jane Goldman (screenplay), Matthew Vaughn (screenplay), Sheldon Turner (story), Bryan Singer (story) tt1270798 7.80000019073 557715.0 408 198 155 761 48 68.0 160000000 146408305 355408305 1638.0 4.88280192259
Cate Blanchett, Brad Pitt, Julia Ormond, Faune Chambers Watkins Won 3 Oscars. Another 77 wins & 155 nominations. 127490802.0 USA 2009-05-05 David Fincher Drama, Fantasy, Romance English, Russian, French 70.0 Paramount PG-13 2008-12-25 166.0 The Curious Case of Benjamin Button movie Eric Roth (screenplay), Eric Roth (story), Robin Swicord (story), F. Scott Fitzgerald (short story) tt0421715 7.80000019073 491961.0 342 86 33 203 8 0.0 160000000 127509326 329809326 672.0 5.11198778836

In [4]:
_min = 50
_max = 200
res = len(df) - len(df[(df['Runtime'] >= _min) & (df['Runtime'] <= _max)])
print('{0} records dropped if dataset is limited to a runtime length between {1}-{2} minutes'.format(res, _min, _max))

# Drop records stated above (runtime length)
df = df[(df['Runtime'] >= _min) & (df['Runtime'] <= _max)]

# Log transform
df['Runtime_Log'] = np.log(df['Runtime'])


71 records dropped if dataset is limited to a runtime length between 50-200 minutes

In [5]:
display(df)


Hey, there's something awesome here! To see it, open this notebook outside GitHub, in a viewer like Jupyter
Log Transform of Runtime Distribution
Warning: While great, D3 rendering is using MPLD3 library which has limitations that have not yet been fixed

- Remove movies where runtime is less than 50 (and greater than 200) minutes?



In [6]:
display(df)


Hey, there's something awesome here! To see it, open this notebook outside GitHub, in a viewer like Jupyter
Production Budget Distribution
Warning: While great, D3 rendering is using MPLD3 library which has limitations that have not yet been fixed

In [7]:
ct = len(df[df['DomesticBudget'] <= 0])
print('''{0} records dropped due to Domestic Budget of 0 or less -
         majority of these films are low torrent count/indie style films'''.format(ct))

df = df[df['DomesticBudget'] > 0]

df['ProductionBudget_Log'] = np.log(df['ProductionBudget'])
df['DomesticBudget_Log'] = np.log(df['DomesticBudget'])
df['WorldGross_Log'] = np.log(df['WorldGross'])


218 records dropped due to Domestic Budget of 0 or less -
         majority of these films are low torrent count/indie style films

In [8]:
display(df)


Hey, there's something awesome here! To see it, open this notebook outside GitHub, in a viewer like Jupyter
Log Transform - Production Budget Distribution
Warning: While great, D3 rendering is using MPLD3 library which has limitations that have not yet been fixed

- Try taking log-transform of * Budget values



In [9]:
# Extract DVD release month and year
df['DVD_Month'] = pd.to_numeric(pd.to_datetime(df['DVD']).apply(lambda x: x.month), errors='coerce')
df['DVD_Year'] = pd.to_numeric(pd.to_datetime(df['DVD']).apply(lambda x: x.year), errors='coerce')

# Extract theaters release month and year
df['Release_Month'] = pd.to_numeric(pd.to_datetime(df['Released']).apply(lambda x: x.month), errors='coerce')
df['Release_Year'] = pd.to_numeric(pd.to_datetime(df['Released']).apply(lambda x: x.year), errors='coerce')

df.dropna(subset=['DVD_Month','DVD_Year','Release_Month','Release_Year'], inplace=True)

In [10]:
display(df)


Hey, there's something awesome here! To see it, open this notebook outside GitHub, in a viewer like Jupyter
DVD Release Month Distribution
Warning: While great, D3 rendering is using MPLD3 library which has limitations that have not yet been fixed

- Change bin count to 4 for seasonal (spring, summer, fall, winter) and to 12 for monthly



In [ ]:
display(df)


Hey, there's something awesome here! To see it, open this notebook outside GitHub, in a viewer like Jupyter
Movie Release Month Distribution
Warning: While great, D3 rendering is using MPLD3 library which has limitations that have not yet been fixed

- Change bin count to 4 for seasonal (spring, summer, fall, winter) and to 12 for monthly



In [12]:
def month_encode(df, col):
    # One hot encode months
    months = (1,2,3),(4,5,6),(7,8,9),(10,11,12)
    seasons = ['Spring','Summer','Winter','Fall']

    for mon, sea in list(zip(months, seasons)):
        _col = '{0}_{1}'.format(col.split('_')[0], sea)
        if _col in df.columns:
            del df[_col]
            
        df[_col] = 0
        df.loc[df[col].isin(mon), _col] = 1
    
    return df

In [13]:
df = month_encode(df, 'Release_Month')
df = month_encode(df, 'DVD_Month')

Transform Genres to Select Groups


In [14]:
df['Rated_Trans'] = df['Rated'].copy()
df['Rated_Trans'].fillna(value='NR', inplace=True)
df.loc[df['Rated_Trans'].isin(['NOT RATED','UNRATED']), 'Rated_Trans'] = 'NR'
df.loc[df['Rated_Trans'].isin(['GP','TV-PG','M','M/PG','APPROVED','PASSED']), 'Rated_Trans'] = 'PG'
df.loc[df['Rated_Trans'].isin(['TV-G']), 'Rated_Trans'] = 'G'
df.loc[df['Rated_Trans'].isin(['TV-14','NC-17']), 'Rated_Trans'] = 'PG-13'
df.loc[df['Rated_Trans'].isin(['X']), 'Rated_Trans'] = 'R'
df['Rated_Trans'].unique().tolist()


Out[14]:
['PG-13', 'PG', 'G', 'R', 'NR']

In [15]:
# Encode ratings
for rate in df['Rated_Trans'].unique():
    _col = 'Rated_{0}'.format(rate.replace('-',''))
    if _col in df.columns:
        del df[_col]
    df[_col] = 0
    df.loc[df['Rated_Trans'] == rate, _col] = 1

In [16]:
display(df)


Hey, there's something awesome here! To see it, open this notebook outside GitHub, in a viewer like Jupyter
(Transformed) Genre Counts
Warning: While great, D3 rendering is using MPLD3 library which has limitations that have not yet been fixed

Group by Size of Production Company


In [17]:
df['Production_Trans'] = df['Production']
df['Production_Trans'].fillna('', inplace=True)
df['Production_Trans'] = df['Production'].str.lower().apply(lambda x: str(str(x).split('/')[0]))

In [18]:
df.loc[df['Production_Trans'].str.contains('century fox'), 'Production_Trans'] = '20th century fox'
df.loc[df['Production_Trans'].str.contains('20th century'), 'Production_Trans'] = '20th century fox'
df.loc[df['Production_Trans'].isin(['fox']), 'Production_Trans'] = '20th century fox'
df.loc[df['Production_Trans'].isin(['foxfaith']), 'Production_Trans'] = 'fox faith films'
df.loc[df['Production_Trans'].str.contains('lions'), 'Production_Trans'] = 'lionsgate'
df.loc[df['Production_Trans'].str.contains('dream'), 'Production_Trans'] = 'dreamworks'
df.loc[df['Production_Trans'].str.contains('destination'), 'Production_Trans'] = 'destination films'
df.loc[df['Production_Trans'].str.contains('yari'), 'Production_Trans'] = 'yari film group'
df.loc[df['Production_Trans'].str.contains('yash'), 'Production_Trans'] = 'yash raj films'

names = ['warner','mca','universal','paramount','sony','columbia','new line','mgm','miramax',
         'disney','buena vista','united artists','weinstein','touchstone','fox searchlight','summit',
         'relativity','magnolia','tristar','anchor bay','gramercy','open road','ifc','hollywood', 'district']

for name in names:
    df.loc[df['Production_Trans'].str.contains(name), 'Production_Trans'] = name

In [19]:
prod = df.groupby('Production_Trans').count().sort_values('Actors',ascending=False)['Actors'].reset_index()
prod.columns = [['Production_Trans', 'Prod_Count']]
# xtreme > 400
# large <= 400 x > 300
# medium <= 300 x > 100
# small <= 100 x > 20
# tiny <= 20

a = 400
b = 300
c = 100
d = 20

prod['Prod_Size'] = 'Tiny'
prod.loc[prod['Prod_Count'] > a, 'Prod_Size'] = 'Xtreme'
prod.loc[(prod['Prod_Count'] <= a) & (prod['Prod_Count'] > b), 'Prod_Size'] = 'Large'
prod.loc[(prod['Prod_Count'] <= b) & (prod['Prod_Count'] > c), 'Prod_Size'] = 'Medium'
prod.loc[(prod['Prod_Count'] <= c) & (prod['Prod_Count'] > d), 'Prod_Size'] = 'Small'

In [20]:
# Bring results into main dataframe
df = pd.merge(df, prod)

In [21]:
# One hot encode production size
for _size in df['Prod_Size'].unique().tolist():
    _col = 'Prod_Size_{0}'.format(_size)
    df[_col] = 0
    df.loc[df['Prod_Size'] == _size, _col] = 1

Make Genres into individual features with cutoff


In [22]:
# split strings into a numpy array
def split_to_array(ser):
    split_array = np.array(ser.strip().split(','))
    return pd.Series(split_array).apply(lambda x: x.strip())

In [23]:
def expand_as_matrix(df, col, limit):
    df[col].fillna('', inplace=True)
    df[col] = df[col].apply(lambda x: str(x))
    
    # turn numpy array into count of occurances
    ser = df[col].apply(split_to_array)
    ser = pd.Series(ser.values.ravel()).dropna()
    ser = ser.value_counts().sort_values(ascending=False)

    # convert series to dataframe
    ser = ser.reset_index()
    ser.columns = [col, 'Count']

    # Flag top features that film is listed under having
    top_features = ser[col][:limit].tolist()
    other_features = ser[col][limit:].tolist()

    for feat in top_features:
        i = '{0}_{1}'.format(col, feat)
        if i in df.columns:
            del df[i]
            
        df[feat] = 0
        df.loc[df[col].str.contains(feat), feat] = 1

    # For remaining features - flage under `Other`
    col_other = '{0}_Other'.format(col)
    
    if col_other in df.columns:
        del df[col_other]
        
    df[col_other] = 0
    for o_feat in other_features:

        df.loc[df[col].str.contains(o_feat), col_other] = 1

    # Rename columns to better explain purpose 
    rename_cols = {x: '{0}_{1}'.format(col, x) for x in top_features}

    df = df.rename(columns = rename_cols)
    return df

In [24]:
df = expand_as_matrix(df, 'Genre', 12)
df = expand_as_matrix(df, 'Country', 5)
df = expand_as_matrix(df, 'Language', 5)


/Users/bryant/anaconda/lib/python3.6/site-packages/ipykernel/__main__.py:35: UserWarning: This pattern has match groups. To actually get the groups, use str.extract.

In [25]:
df = df[[
 'imdbID',
 'Country_Canada',
 'Country_France',
 'Country_Germany',
 'Country_Other',
 'Country_UK',
 'Country_USA',
 'DVD_Fall',
 'DVD_Month',
 'DVD_Spring',
 'DVD_Summer',
 'DVD_Winter',
 'DVD_Year',
 'DomesticBudget',
 'DomesticBudget_Log',
 'Extra_Count',
 'Genre_Action',
 'Genre_Adventure',
 'Genre_Comedy',
 'Genre_Crime',
 'Genre_Drama',
 'Genre_Family',
 'Genre_Fantasy',
 'Genre_Horror',
 'Genre_Mystery',
 'Genre_Other',
 'Genre_Romance',
 'Genre_Sci-Fi',
 'Genre_Thriller',
 'Kat_Count',
 'Language_English',
 'Language_French',
 'Language_German',
 'Language_Italian',
 'Language_Other',
 'Language_Spanish',
 'Pirate_Count',
 'Prod_Size_Large',
 'Prod_Size_Medium',
 'Prod_Size_Small',
 'Prod_Size_Tiny',
 'Prod_Size_Xtreme',
 'ProductionBudget',
 'ProductionBudget_Log',
 'Rated_G',
 'Rated_NR',
 'Rated_PG',
 'Rated_PG13',
 'Rated_R',
 'Release_Fall',
 'Release_Month',
 'Release_Spring',
 'Release_Summer',
 'Release_Winter',
 'Release_Year',
 'Runtime',
 'Runtime_Log',
 'Torrentz_Count',
 'Torrentz_Ver_Count',
 'Total_Torrents',
 'WorldGross',
 'WorldGross_Log',
 'Zoogle_Ver_Count']]

In [26]:
df.info()


<class 'pandas.core.frame.DataFrame'>
Int64Index: 3549 entries, 0 to 3548
Data columns (total 63 columns):
imdbID                  3549 non-null object
Country_Canada          3549 non-null int64
Country_France          3549 non-null int64
Country_Germany         3549 non-null int64
Country_Other           3549 non-null int64
Country_UK              3549 non-null int64
Country_USA             3549 non-null int64
DVD_Fall                3549 non-null int64
DVD_Month               3549 non-null float64
DVD_Spring              3549 non-null int64
DVD_Summer              3549 non-null int64
DVD_Winter              3549 non-null int64
DVD_Year                3549 non-null float64
DomesticBudget          3549 non-null int64
DomesticBudget_Log      3549 non-null float64
Extra_Count             3549 non-null int64
Genre_Action            3549 non-null int64
Genre_Adventure         3549 non-null int64
Genre_Comedy            3549 non-null int64
Genre_Crime             3549 non-null int64
Genre_Drama             3549 non-null int64
Genre_Family            3549 non-null int64
Genre_Fantasy           3549 non-null int64
Genre_Horror            3549 non-null int64
Genre_Mystery           3549 non-null int64
Genre_Other             3549 non-null int64
Genre_Romance           3549 non-null int64
Genre_Sci-Fi            3549 non-null int64
Genre_Thriller          3549 non-null int64
Kat_Count               3549 non-null int64
Language_English        3549 non-null int64
Language_French         3549 non-null int64
Language_German         3549 non-null int64
Language_Italian        3549 non-null int64
Language_Other          3549 non-null int64
Language_Spanish        3549 non-null int64
Pirate_Count            3549 non-null int64
Prod_Size_Large         3549 non-null int64
Prod_Size_Medium        3549 non-null int64
Prod_Size_Small         3549 non-null int64
Prod_Size_Tiny          3549 non-null int64
Prod_Size_Xtreme        3549 non-null int64
ProductionBudget        3549 non-null int64
ProductionBudget_Log    3549 non-null float64
Rated_G                 3549 non-null int64
Rated_NR                3549 non-null int64
Rated_PG                3549 non-null int64
Rated_PG13              3549 non-null int64
Rated_R                 3549 non-null int64
Release_Fall            3549 non-null int64
Release_Month           3549 non-null int64
Release_Spring          3549 non-null int64
Release_Summer          3549 non-null int64
Release_Winter          3549 non-null int64
Release_Year            3549 non-null int64
Runtime                 3549 non-null float64
Runtime_Log             3549 non-null float64
Torrentz_Count          3549 non-null int64
Torrentz_Ver_Count      3549 non-null int64
Total_Torrents          3549 non-null float64
WorldGross              3549 non-null int64
WorldGross_Log          3549 non-null float64
Zoogle_Ver_Count        3549 non-null float64
dtypes: float64(9), int64(53), object(1)
memory usage: 1.7+ MB

In [27]:
df.to_csv('EDA.csv')

In [ ]: