问题1：电影类型是如何随着时代变化而变化的? 问题2：环球影业和派拉蒙影业的电影之间的数据指标有什么区别? 问题3：和非小说改编的电影相比，基于小说改编的电影表现得怎么样?
In [34]:
import numpy as np
import pandas as pd
filename = './movies.csv'
movies_df = pd.read_csv(filename)
movies_df.describe()
Out[34]:
id
popularity
budget
revenue
runtime
vote_count
vote_average
release_year
budget_adj
revenue_adj
count
10866.000000
10866.000000
1.086600e+04
1.086600e+04
10866.000000
10866.000000
10866.000000
10866.000000
1.086600e+04
1.086600e+04
mean
66064.177434
0.646441
1.462570e+07
3.982332e+07
102.070863
217.389748
5.974922
2001.322658
1.755104e+07
5.136436e+07
std
92130.136561
1.000185
3.091321e+07
1.170035e+08
31.381405
575.619058
0.935142
12.812941
3.430616e+07
1.446325e+08
min
5.000000
0.000065
0.000000e+00
0.000000e+00
0.000000
10.000000
1.500000
1960.000000
0.000000e+00
0.000000e+00
25%
10596.250000
0.207583
0.000000e+00
0.000000e+00
90.000000
17.000000
5.400000
1995.000000
0.000000e+00
0.000000e+00
50%
20669.000000
0.383856
0.000000e+00
0.000000e+00
99.000000
38.000000
6.000000
2006.000000
0.000000e+00
0.000000e+00
75%
75610.000000
0.713817
1.500000e+07
2.400000e+07
111.000000
145.750000
6.600000
2011.000000
2.085325e+07
3.369710e+07
max
417859.000000
32.985763
4.250000e+08
2.781506e+09
900.000000
9767.000000
9.200000
2015.000000
4.250000e+08
2.827124e+09
In [35]:
movies_df.dropna()
Out[35]:
id
imdb_id
popularity
budget
revenue
original_title
cast
homepage
director
tagline
...
overview
runtime
genres
production_companies
release_date
vote_count
vote_average
release_year
budget_adj
revenue_adj
0
135397
tt0369610
32.985763
150000000
1513528810
Jurassic World
Chris Pratt|Bryce Dallas Howard|Irrfan Khan|Vi...
http://www.jurassicworld.com/
Colin Trevorrow
The park is open.
...
Twenty-two years after the events of Jurassic ...
124
Action|Adventure|Science Fiction|Thriller
Universal Studios|Amblin Entertainment|Legenda...
2015-06-09
5562
6.5
2015
1.379999e+08
1.392446e+09
1
76341
tt1392190
28.419936
150000000
378436354
Mad Max: Fury Road
Tom Hardy|Charlize Theron|Hugh Keays-Byrne|Nic...
http://www.madmaxmovie.com/
George Miller
What a Lovely Day.
...
An apocalyptic story set in the furthest reach...
120
Action|Adventure|Science Fiction|Thriller
Village Roadshow Pictures|Kennedy Miller Produ...
2015-05-13
6185
7.1
2015
1.379999e+08
3.481613e+08
2
262500
tt2908446
13.112507
110000000
295238201
Insurgent
Shailene Woodley|Theo James|Kate Winslet|Ansel...
http://www.thedivergentseries.movie/#insurgent
Robert Schwentke
One Choice Can Destroy You
...
Beatrice Prior must confront her inner demons ...
119
Adventure|Science Fiction|Thriller
Summit Entertainment|Mandeville Films|Red Wago...
2015-03-18
2480
6.3
2015
1.012000e+08
2.716190e+08
3
140607
tt2488496
11.173104
200000000
2068178225
Star Wars: The Force Awakens
Harrison Ford|Mark Hamill|Carrie Fisher|Adam D...
http://www.starwars.com/films/star-wars-episod...
J.J. Abrams
Every generation has a story.
...
Thirty years after defeating the Galactic Empi...
136
Action|Adventure|Science Fiction|Fantasy
Lucasfilm|Truenorth Productions|Bad Robot
2015-12-15
5292
7.5
2015
1.839999e+08
1.902723e+09
4
168259
tt2820852
9.335014
190000000
1506249360
Furious 7
Vin Diesel|Paul Walker|Jason Statham|Michelle ...
http://www.furious7.com/
James Wan
Vengeance Hits Home
...
Deckard Shaw seeks revenge against Dominic Tor...
137
Action|Crime|Thriller
Universal Pictures|Original Film|Media Rights ...
2015-04-01
2947
7.3
2015
1.747999e+08
1.385749e+09
5
281957
tt1663202
9.110700
135000000
532950503
The Revenant
Leonardo DiCaprio|Tom Hardy|Will Poulter|Domhn...
http://www.foxmovies.com/movies/the-revenant
Alejandro González Iñárritu
(n. One who has returned, as if from the dead.)
...
In the 1820s, a frontiersman, Hugh Glass, sets...
156
Western|Drama|Adventure|Thriller
Regency Enterprises|Appian Way|CatchPlay|Anony...
2015-12-25
3929
7.2
2015
1.241999e+08
4.903142e+08
6
87101
tt1340138
8.654359
155000000
440603537
Terminator Genisys
Arnold Schwarzenegger|Jason Clarke|Emilia Clar...
http://www.terminatormovie.com/
Alan Taylor
Reset the future
...
The year is 2029. John Connor, leader of the r...
125
Science Fiction|Action|Thriller|Adventure
Paramount Pictures|Skydance Productions
2015-06-23
2598
5.8
2015
1.425999e+08
4.053551e+08
7
286217
tt3659388
7.667400
108000000
595380321
The Martian
Matt Damon|Jessica Chastain|Kristen Wiig|Jeff ...
http://www.foxmovies.com/movies/the-martian
Ridley Scott
Bring Him Home
...
During a manned mission to Mars, Astronaut Mar...
141
Drama|Adventure|Science Fiction
Twentieth Century Fox Film Corporation|Scott F...
2015-09-30
4572
7.6
2015
9.935996e+07
5.477497e+08
8
211672
tt2293640
7.404165
74000000
1156730962
Minions
Sandra Bullock|Jon Hamm|Michael Keaton|Allison...
http://www.minionsmovie.com/
Kyle Balda|Pierre Coffin
Before Gru, they had a history of bad bosses
...
Minions Stuart, Kevin and Bob are recruited by...
91
Family|Animation|Adventure|Comedy
Universal Pictures|Illumination Entertainment
2015-06-17
2893
6.5
2015
6.807997e+07
1.064192e+09
9
150540
tt2096673
6.326804
175000000
853708609
Inside Out
Amy Poehler|Phyllis Smith|Richard Kind|Bill Ha...
http://movies.disney.com/inside-out
Pete Docter
Meet the little voices inside your head.
...
Growing up can be a bumpy road, and it's no ex...
94
Comedy|Animation|Family
Walt Disney Pictures|Pixar Animation Studios|W...
2015-06-09
3935
8.0
2015
1.609999e+08
7.854116e+08
10
206647
tt2379713
6.200282
245000000
880674609
Spectre
Daniel Craig|Christoph Waltz|Léa Seydoux|Ralph...
http://www.sonypictures.com/movies/spectre/
Sam Mendes
A Plan No One Escapes
...
A cryptic message from Bond’s past sends him o...
148
Action|Adventure|Crime
Columbia Pictures|Danjaq|B24
2015-10-26
3254
6.2
2015
2.253999e+08
8.102203e+08
11
76757
tt1617661
6.189369
176000003
183987723
Jupiter Ascending
Mila Kunis|Channing Tatum|Sean Bean|Eddie Redm...
http://www.jupiterascending.com
Lana Wachowski|Lilly Wachowski
Expand your universe.
...
In a universe where human genetic material is ...
124
Science Fiction|Fantasy|Action|Adventure
Village Roadshow Pictures|Dune Entertainment|A...
2015-02-04
1937
5.2
2015
1.619199e+08
1.692686e+08
12
264660
tt0470752
6.118847
15000000
36869414
Ex Machina
Domhnall Gleeson|Alicia Vikander|Oscar Isaac|S...
http://exmachina-movie.com/
Alex Garland
There is nothing more human than the will to s...
...
Caleb, a 26 year old coder at the world's larg...
108
Drama|Science Fiction
DNA Films|Universal Pictures International (UP...
2015-01-21
2854
7.6
2015
1.379999e+07
3.391985e+07
13
257344
tt2120120
5.984995
88000000
243637091
Pixels
Adam Sandler|Michelle Monaghan|Peter Dinklage|...
http://www.pixels-movie.com/
Chris Columbus
Game On.
...
Video game experts are recruited by the milita...
105
Action|Comedy|Science Fiction
Columbia Pictures|Happy Madison Productions
2015-07-16
1575
5.8
2015
8.095996e+07
2.241460e+08
14
99861
tt2395427
5.944927
280000000
1405035767
Avengers: Age of Ultron
Robert Downey Jr.|Chris Hemsworth|Mark Ruffalo...
http://marvel.com/movies/movie/193/avengers_ag...
Joss Whedon
A New Age Has Come.
...
When Tony Stark tries to jumpstart a dormant p...
141
Action|Adventure|Science Fiction
Marvel Studios|Prime Focus|Revolution Sun Studios
2015-04-22
4304
7.4
2015
2.575999e+08
1.292632e+09
15
273248
tt3460252
5.898400
44000000
155760117
The Hateful Eight
Samuel L. Jackson|Kurt Russell|Jennifer Jason ...
http://thehatefuleight.com/
Quentin Tarantino
No one comes up here without a damn good reason.
...
Bounty hunters seek shelter from a raging bliz...
167
Crime|Drama|Mystery|Western
Double Feature Films|The Weinstein Company|Fil...
2015-12-25
2389
7.4
2015
4.047998e+07
1.432992e+08
16
260346
tt2446042
5.749758
48000000
325771424
Taken 3
Liam Neeson|Forest Whitaker|Maggie Grace|Famke...
http://www.taken3movie.com/
Olivier Megaton
It Ends Here
...
Ex-government operative Bryan Mills finds his ...
109
Crime|Action|Thriller
Twentieth Century Fox Film Corporation|M6 Film...
2015-01-01
1578
6.1
2015
4.415998e+07
2.997096e+08
17
102899
tt0478970
5.573184
130000000
518602163
Ant-Man
Paul Rudd|Michael Douglas|Evangeline Lilly|Cor...
http://marvel.com/movies/movie/180/ant-man
Peyton Reed
Heroes Don't Get Any Bigger
...
Armed with the astonishing ability to shrink i...
115
Science Fiction|Action|Adventure
Marvel Studios
2015-07-14
3779
7.0
2015
1.195999e+08
4.771138e+08
19
131634
tt1951266
5.476958
160000000
650523427
The Hunger Games: Mockingjay - Part 2
Jennifer Lawrence|Josh Hutcherson|Liam Hemswor...
http://www.thehungergames.movie/
Francis Lawrence
The fire will burn forever.
...
With the nation of Panem in a full scale war, ...
136
War|Adventure|Science Fiction
Studio Babelsberg|StudioCanal|Lionsgate|Walt D...
2015-11-18
2380
6.5
2015
1.471999e+08
5.984813e+08
20
158852
tt1964418
5.462138
190000000
209035668
Tomorrowland
Britt Robertson|George Clooney|Raffey Cassidy|...
http://movies.disney.com/tomorrowland
Brad Bird
Imagine a world where nothing is impossible.
...
Bound by a shared destiny, a bright, optimisti...
130
Action|Family|Science Fiction|Adventure|Mystery
Walt Disney Pictures|Babieka|A113
2015-05-19
1899
6.2
2015
1.747999e+08
1.923127e+08
22
254128
tt2126355
4.907832
110000000
470490832
San Andreas
Dwayne Johnson|Alexandra Daddario|Carla Gugino...
http://www.sanandreasmovie.com/
Brad Peyton
A rescue pilot survived an earthquake, this is...
...
In the aftermath of a massive earthquake in Ca...
114
Action|Drama|Thriller
New Line Cinema|Village Roadshow Pictures|Warn...
2015-05-27
2060
6.1
2015
1.012000e+08
4.328514e+08
23
216015
tt2322441
4.710402
40000000
569651467
Fifty Shades of Grey
Dakota Johnson|Jamie Dornan|Jennifer Ehle|Eloi...
https://www.facebook.com/fiftyshadesofgreymovie
Sam Taylor-Johnson
Are you curious?
...
When college senior Anastasia Steele steps in ...
125
Drama|Romance
Focus Features|Trigger Street Productions|Mich...
2015-02-11
1865
5.3
2015
3.679998e+07
5.240791e+08
24
318846
tt1596363
4.648046
28000000
133346506
The Big Short
Christian Bale|Steve Carell|Ryan Gosling|Brad ...
http://www.thebigshortmovie.com/
Adam McKay
This is a true story.
...
The men who made millions from a global econom...
130
Comedy|Drama
Paramount Pictures|Plan B Entertainment|Regenc...
2015-12-11
1545
7.3
2015
2.575999e+07
1.226787e+08
25
177677
tt2381249
4.566713
150000000
682330139
Mission: Impossible - Rogue Nation
Tom Cruise|Jeremy Renner|Simon Pegg|Rebecca Fe...
http://www.missionimpossible.com
Christopher McQuarrie
Desperate Times. Desperate Measures.
...
Ethan and team take on their most impossible m...
131
Action
Paramount Pictures|Skydance Productions|China ...
2015-07-23
2349
7.1
2015
1.379999e+08
6.277435e+08
27
207703
tt2802144
4.503789
81000000
403802136
Kingsman: The Secret Service
Taron Egerton|Colin Firth|Samuel L. Jackson|Mi...
http://www.kingsmanmovie.com/
Matthew Vaughn
Manners maketh man.
...
The story of a super-secret spy organization t...
130
Crime|Comedy|Action|Adventure
Twentieth Century Fox Film Corporation|Marv Fi...
2015-01-24
3833
7.6
2015
7.451997e+07
3.714978e+08
28
314365
tt1895587
4.062293
20000000
88346473
Spotlight
Mark Ruffalo|Michael Keaton|Rachel McAdams|Lie...
http://www.spotlightthefilm.com
Tom McCarthy
Break the story. Break the silence.
...
The true story of how The Boston Globe uncover...
128
Drama|Thriller|History
Participant Media|Open Road Films|Anonymous Co...
2015-11-06
1559
7.8
2015
1.839999e+07
8.127872e+07
29
294254
tt4046784
3.968891
61000000
311256926
Maze Runner: The Scorch Trials
Dylan O'Brien|Kaya Scodelario|Thomas Brodie-Sa...
http://mazerunnermovies.com
Wes Ball
The Maze Was Just the Beginning.
...
Thomas and his fellow Gladers face their great...
132
Action|Science Fiction|Thriller
Gotham Group|Temple Hill Entertainment|TSG Ent...
2015-09-09
1849
6.4
2015
5.611998e+07
2.863562e+08
30
280996
tt3168230
3.927333
0
29355203
Mr. Holmes
Ian McKellen|Milo Parker|Laura Linney|Hattie M...
http://www.mrholmesfilm.com/
Bill Condon
The man behind the myth
...
The story is set in 1947, following a long-ret...
103
Mystery|Drama
BBC Films|See-Saw Films|FilmNation Entertainme...
2015-06-19
425
6.4
2015
0.000000e+00
2.700677e+07
31
198184
tt1823672
3.899557
49000000
102069268
Chappie
Sharlto Copley|Dev Patel|Ninja|Yolandi Visser|...
http://www.chappie-movie.com
Neill Blomkamp
I am consciousness. I am alive. I am Chappie.
...
Every child comes into the world full of promi...
120
Crime|Action|Science Fiction
Columbia Pictures|Media Rights Capital|Sony Pi...
2015-03-04
1990
6.6
2015
4.507998e+07
9.390369e+07
34
257445
tt1051904
3.644541
58000000
150170815
Goosebumps
Jack Black|Dylan Minnette|Odeya Rush|Amy Ryan|...
http://www.goosebumps-movie.com/
Rob Letterman
The stories are alive.
...
A teenager teams up with the daughter of young...
103
Adventure|Horror|Comedy
Columbia Pictures|Original Film|Scholastic Ent...
2015-08-05
600
6.2
2015
5.335998e+07
1.381571e+08
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
9992
1669
tt0099810
1.072912
30
200
The Hunt for Red October
Alec Baldwin|Sean Connery|Scott Glenn|Sam Neil...
http://www.paramount.com/movies/hunt-red-october
John McTiernan
Invisible. Silent. Stolen.
...
A new Soviet nuclear missile sub (a Boomer) he...
134
Action|Adventure|Thriller
Paramount Pictures|Nina Saxon Film Design|Mace...
1990-03-02
615
6.9
1990
5.006696e+01
3.337797e+02
10012
530
tt0104361
0.519773
0
0
A Grand Day Out
Peter Sallis
http://www.wallaceandgromit.com/films/a-grand-...
Nick Park
Join the ultimate human-canine team as they bl...
...
Wallace and Gromit have run out of cheese and ...
23
Adventure|Animation|Comedy|Science Fiction|Family
Aardman Animations
1990-05-18
103
7.3
1990
0.000000e+00
0.000000e+00
10078
12651
tt0100133
0.747549
23000000
0
Memphis Belle
Matthew Modine|Eric Stoltz|Tate Donovan|D. B. ...
http://www.imdb.com/title/tt0100133/
Michael Caton-Jones
Brave young men who rode on the wings of victory.
...
The "Memphis Belle" is a World War II bomber, ...
107
Drama|War|Action
Warner Bros.|Enigma Productions|Fujisankei Com...
1990-09-07
65
6.0
1990
3.838467e+07
0.000000e+00
10094
771
tt0099785
0.142486
18000000
476684675
Home Alone
Macaulay Culkin|Joe Pesci|Daniel Stern|John He...
https://www.foxconnect.com/home-alone-4.html
Chris Columbus
A Family Comedy Without the Family.
...
Eight-year-old Kevin McCallister makes the mos...
103
Comedy|Family
Twentieth Century Fox Film Corporation|Hughes ...
1990-11-09
1393
7.0
1990
3.004017e+07
7.955384e+08
10131
430
tt0055256
0.303783
3000000
4000000
One, Two, Three
James Cagney|Liselotte Pulver|Horst Buchholz|P...
http://en.wikipedia.org/wiki/One,_Two,_Three
Billy Wilder
Billy Wilder's Explosive New Comedy
...
One, Two, Three – A scorching business comedy ...
115
Comedy|Family
The Mirisch Corporation
1961-12-15
30
7.5
1961
2.188458e+07
2.917944e+07
10190
17814
tt0074156
0.374631
150000
0
Assault on Precinct 13
Austin Stoker|Darwin Joston|Laurie Zimmer|Mart...
http://www.theofficialjohncarpenter.com/assaul...
John Carpenter
L.A.'s deadliest street gang just declared war...
...
The lone inhabitants of an abandoned police st...
91
Action|Crime
Overseas FilmGroup|The CKK Corporation
1976-11-05
80
7.0
1976
5.747547e+05
0.000000e+00
10213
40440
tt0075244
0.126140
0
0
The Song Remains the Same
Robert Plant|Jimmy Page|John Bonham|John Paul ...
http://www.ledzeppelin.com/
Peter Clifton|Joe Massot
In Concert And Beyond
...
The best of Led Zeppelin's legendary 1973 appe...
137
Documentary|Music
Warner Bros.|Swan Song
1976-11-05
14
7.0
1976
0.000000e+00
0.000000e+00
10222
424
tt0108052
2.377288
22000000
321265768
Schindler's List
Liam Neeson|Ben Kingsley|Ralph Fiennes|Carolin...
http://www.schindlerslist.com/
Steven Spielberg
Whoever saves one life, saves the world entire.
...
The true story of how businessman Oskar Schind...
195
Drama|History|War
Universal Pictures|Amblin Entertainment
1993-11-29
2632
8.1
1993
3.320834e+07
4.849410e+08
10223
329
tt0107290
2.204926
63000000
920100000
Jurassic Park
Sam Neill|Laura Dern|Jeff Goldblum|Richard Att...
http://www.jurassicpark.com/
Steven Spielberg
An adventure 65 million years in the making.
...
A wealthy entrepreneur secretly creates a them...
127
Adventure|Science Fiction
Universal Pictures|Amblin Entertainment
1993-06-11
3169
7.4
1993
9.509661e+07
1.388863e+09
10224
9739
tt0106697
1.960217
57000000
159055768
Demolition Man
Sylvester Stallone|Wesley Snipes|Sandra Bulloc...
http://www.warnerbros.com/demolition-man
Marco Brambilla
The 21st Century's most dangerous cop. The 21s...
...
Simon Phoenix, a violent criminal cryogenicall...
115
Action|Adventure|Comedy|Science Fiction
Silver Pictures|Warner Bros.
1993-10-08
580
6.1
1993
8.603979e+07
2.400899e+08
10238
531
tt0108598
0.996113
0
0
The Wrong Trousers
Peter Sallis
http://www.wallaceandgromit.com/films/the-wron...
Nick Park
Winner of the 1993 Academy Award for Best Anim...
...
Gromit finds himself being pushed out of his r...
30
Animation|Comedy|Family
Aardman Animations
1993-12-17
146
7.4
1993
0.000000e+00
0.000000e+00
10251
10057
tt0108333
0.794564
30000000
53898845
The Three Musketeers
Charlie Sheen|Kiefer Sutherland|Chris O'Donnel...
http://movies.disney.com/the-three-musketeers
Stephen Herek
All for one and one for all!
...
D'Artagnan travels to Paris hoping to become a...
105
Action|Adventure|Comedy
Walt Disney Pictures|Caravan Pictures
1993-11-11
112
5.9
1993
4.528410e+07
8.135869e+07
10255
10909
tt0107302
0.761510
9000000
2395231
Kalifornia
Brad Pitt|David Duchovny|Juliette Lewis|Michel...
http://www.mgm.com/#/our-titles/1024/Kalifornia
Dominic Sena
Fear never travels alone.
...
A journalist duo go on a tour of serial killer...
117
Thriller|Crime
Propaganda Films|Kouf/Bigelow Productions
1993-09-01
96
6.3
1993
1.358523e+07
3.615529e+06
10317
2149
tt0106453
0.394817
30000000
13273595
Body of Evidence
Madonna|Willem Dafoe|Julianne Moore|Anne Arche...
http://www.mgm.com/#/our-titles/226/Body-Of-Ev...
Uli Edel
An act of love, or an act of murder?
...
Sizzingly sexy Madonna leads a star-filled cas...
99
Drama|Thriller|Romance
Metro-Goldwyn-Mayer (MGM)
1993-01-15
25
4.4
1993
4.528410e+07
2.003609e+07
10328
31578
tt0106449
0.238862
0
0
Body Bags
John Carpenter|Robert Carradine|Alex Datcher|D...
http://www.theofficialjohncarpenter.com/body-b...
John Carpenter|Tobe Hooper|Larry Sulkis
Zip yourself in tight!
...
Three tales are told, each one increasingly te...
94
Horror
Showtime Networks
1993-08-07
21
5.3
1993
0.000000e+00
0.000000e+00
10338
8291
tt0107840
0.313792
14000000
27515786
Poetic Justice
Janet Jackson|Tupac Shakur|Regina King|Joe Tor...
http://www.janetjackson.com
John Singleton
A Street Romance.
...
In this film, we see the world through the eye...
109
Drama|Romance
Columbia Pictures
1993-07-23
24
6.8
1993
2.113258e+07
4.153425e+07
10372
13063
tt0115819
0.181665
125000
0
Cannibal! The Musical
Trey Parker|Dian Bachar|Ian Hardin|Jon Hegel|M...
http://www.cannibalthemusical.net/index.shtml
Trey Parker
All Singing! All Dancing! All Flesh Eating!
...
Heading through Colorado Territory in search o...
97
Comedy|History|Horror
Avenging Conscience|Troma Entertainment|Cannib...
1993-10-01
19
6.7
1993
1.886837e+05
0.000000e+00
10401
667
tt0062512
1.554808
9500000
111584787
You Only Live Twice
Sean Connery|Akiko Wakabayashi|Karin Dor|Mie H...
http://www.mgm.com/view/movie/2347/You-Only-Li...
Lewis Gilbert
You Only Live Twice...and Twice is the only wa...
...
A mysterious space craft kidnaps a Russian and...
117
Action|Thriller|Adventure
Eon Productions
1967-06-12
301
6.2
1967
6.209926e+07
7.294034e+08
10438
657
tt0057076
2.508235
2500000
78898765
From Russia With Love
Sean Connery|Daniela Bianchi|Lotte Lenya|Rober...
http://www.mgm.com/view/movie/717/From-Russia-...
Terence Young
The world's masters of murder pull out all the...
...
Agent 007 is back in the second installment of...
115
Action|Thriller|Adventure
Eon Productions|Metro-Goldwyn-Mayer (MGM)|Danjaq
1963-10-11
458
6.7
1963
1.780045e+07
5.617734e+08
10489
6978
tt0090728
0.960984
25000000
11000000
Big Trouble in Little China
Kurt Russell|Kim Cattrall|Dennis Dun|James Hon...
http://www.theofficialjohncarpenter.com/big-tr...
John Carpenter
Adventure doesn't come any bigger!
...
When trucker Jack Burton agreed to take his fr...
99
Adventure|Fantasy|Action|Comedy
Twentieth Century Fox Film Corporation|TAFT En...
1986-05-30
347
6.7
1986
4.973516e+07
2.188347e+07
10567
20537
tt0090798
0.227370
0
0
Caravaggio
Nigel Terry|Tilda Swinton|Sean Bean|Robbie Col...
http://www.zeitgeistfilms.com/film.php?directo...
Derek Jarman
His passion came with a price.
...
As influential Italian artist Caravaggio dies ...
93
Drama|History
British Film Institute (BFI)
1986-08-29
13
4.7
1986
0.000000e+00
0.000000e+00
10594
9552
tt0070047
2.010733
8000000
441306145
The Exorcist
Linda Blair|Max von Sydow|Ellen Burstyn|Jason ...
http://theexorcist.warnerbros.com/
William Friedkin
Something almost beyond comprehension is happe...
...
12-year-old Regan MacNeil begins to adapt an e...
122
Drama|Horror|Thriller
Warner Bros.|Hoya Productions
1973-12-26
1113
7.2
1973
3.928928e+07
2.167325e+09
10595
253
tt0070328
1.549139
7000000
161777836
Live and Let Die
Roger Moore|Yaphet Kotto|Jane Seymour|Clifton ...
http://www.mgm.com/view/movie/1130/Live-and-Le...
Guy Hamilton
Roger Moore is James Bond.
...
James Bond must investigate a mysterious murde...
121
Adventure|Action|Thriller
Eon Productions|Metro-Goldwyn-Mayer (MGM)
1973-07-05
293
6.1
1973
3.437812e+07
7.945168e+08
10657
5722
tt0065466
0.374514
0
0
Beyond the Valley of the Dolls
Dolly Read|Cynthia Myers|Marcia McBroom|John L...
http://www.beyondthevalleyofthedolls.com/home....
Russ Meyer
This Is Not A Sequel. There Has Never Been Any...
...
A hip and happenin' all girl rock group head t...
109
Comedy|Drama|Thriller
Twentieth Century Fox Film Corporation
1970-07-17
19
6.2
1970
0.000000e+00
0.000000e+00
10689
660
tt0059800
1.910465
11000000
141195658
Thunderball
Sean Connery|Claudine Auger|Adolfo Celi|Lucian...
http://www.mgm.com/view/movie/2009/Thunderball/
Terence Young
Look up! Look down! Look out!
...
A criminal organization has obtained two nucle...
130
Adventure|Action|Thriller
Eon Productions|Metro-Goldwyn-Mayer (MGM)
1965-12-16
331
6.3
1965
7.612620e+07
9.771535e+08
10724
668
tt0064757
1.778746
7000000
81974493
On Her Majesty's Secret Service
George Lazenby|Diana Rigg|Telly Savalas|Gabrie...
http://www.mgm.com/view/movie/1411/On-Her-Maje...
Peter R. Hunt
Far up! Far out! Far more! James Bond 007 is b...
...
James Bond tracks archnemesis Ernst Blofeld to...
142
Adventure|Action|Thriller
Eon Productions|Metro-Goldwyn-Mayer (MGM)|Danjaq
1969-12-12
258
6.4
1969
4.160985e+07
4.872780e+08
10759
948
tt0077651
1.198849
300000
70000000
Halloween
Donald Pleasence|Jamie Lee Curtis|P.J. Soles|N...
http://www.theofficialjohncarpenter.com/hallow...
John Carpenter
The Night HE Came Home!
...
A psychotic murderer, institutionalized since ...
91
Horror|Thriller
Compass International Pictures|Falcon Internat...
1978-10-25
522
7.3
1978
1.002810e+06
2.339890e+08
10760
8469
tt0077975
1.157930
2700000
141000000
Animal House
John Belushi|Tim Matheson|John Vernon|Verna Bl...
http://www.animalhouse.com/
John Landis
It was the Deltas against the rules... the rul...
...
At a 1962 College, Dean Vernon Wormer is deter...
109
Comedy
Universal Pictures|Oregon Film Factory|Stage I...
1978-07-27
230
6.7
1978
9.025292e+06
4.713208e+08
10817
13963
tt0077838
0.064029
0
321952
The Last Waltz
Robbie Robertson|Rick Danko|Levon Helm|Richard...
http://www.mgm.com/#/our-titles/1092/The-Last-...
Martin Scorsese
It Started as a Concert. It Became a Celebration.
...
Martin Scorsese's rockumentary intertwines foo...
117
Documentary|Music
FM Productions|Last Waltz Inc.
1978-05-01
33
8.0
1978
0.000000e+00
1.076189e+06
10819
16214
tt0077696
0.044675
0
78000000
Hooper
Burt Reynolds|Robert Klein|Adam West|Jan-Micha...
http://en.wikipedia.org/wiki/Hooper_(film)
Hal Needham
The greatest stuntman alive!
...
Burt Reynolds plays a legendary stunt man know...
107
Action|Comedy
Warner Bros.
1978-07-28
13
6.0
1978
0.000000e+00
2.607307e+08
1993 rows × 21 columns
In [36]:
movies_df.to_csv('new_movies.csv')
In [37]:
#将csv文件导出为excel文件
def csv_to_xlsx_pd():
csv = pd.read_csv('new_movies.csv', encoding='utf-8')
csv.to_excel('new_movies.xlsx', sheet_name='data')
if __name__ == '__main__':
csv_to_xlsx_pd()
In [ ]:
# 由于一个电影由多个电影公司所制作，所以对电影公司这一列进行拆分。
split_genres = movies_df['genres'].str.split('|', expand=True)
split_genres['id'] = movies_df['id']
merged_back = movies_df.merge(split_genres)
melted = pd.melt(
merged_back, id_vars=['id', 'release_year'],
value_vars=[0, 1, 2, 3, 4], value_name='genre'
).drop('variable', axis = 1
).dropna()
melted.to_csv('id_year_genre.csv', index=False)
In [ ]:
#将csv文件导出为excel文件
def csv_to_xlsx_pd():
csv = pd.read_csv('id_year_genre.csv', encoding='utf-8')
csv.to_excel('id_year_genre.xlsx', sheet_name='data')
if __name__ == '__main__':
csv_to_xlsx_pd()
In [ ]:
# 将电影公司进行拆分，仅留下环球影业和派拉蒙影业
movies = pd.read_csv('movies.csv')
s = movies['production_companies'].str.split('|').apply(pd.Series, 1).stack()
s.index = s.index.droplevel(-1)
s.name = 'production'
movies = movies.join(s)
movies = movies[movies['production'].isin(["Universal Pictures", "Paramount Pictures"])]
movies.to_csv('only_companies.csv')
In [ ]:
#将csv文件导出为excel文件
def csv_to_xlsx_pd():
csv = pd.read_csv('only_companies.csv', encoding='utf-8')
csv.to_excel('only_companies.xlsx', sheet_name='data')
if __name__ == '__main__':
csv_to_xlsx_pd()
In [18]:
In [ ]:
In [ ]:
In [ ]:
Content source: maibkey/udacity
Similar notebooks: