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
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
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
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
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')
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
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
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 [ ]:
Content source: bryantbiggs/movie_torrents
Similar notebooks: