x = 5

x

5

x = 6

import pandas as pd
from pandas import Series, DataFrame
s = Series(["A", "B", "C", "D"])
letters = Series(["x", "y", "z"], index=[1, 0, 3])

s

0    A
1    B
2    C
3    D
dtype: object

letters

1    x
0    y
3    z
dtype: object

s[-2:]

2    C
3    D
dtype: object

s + s

0    AA
1    BB
2    CC
3    DD
dtype: object

s + letters

0     Ay
1     Bx
2    NaN
3     Dz
dtype: object

s[1:] + s[:-1]

0    NaN
1     BB
2     CC
3    NaN
dtype: object

s1 = Series([1,2,3])
s2 = Series(["A", "B", "C"])

s1 + s2

---------------------------------------------------------------------------
TypeError                                 Traceback (most recent call last)
~/anaconda3/lib/python3.7/site-packages/pandas/core/ops.py in na_op(x, y)
   1011         try:
-> 1012             result = expressions.evaluate(op, str_rep, x, y, **eval_kwargs)
   1013         except TypeError:

~/anaconda3/lib/python3.7/site-packages/pandas/core/computation/expressions.py in evaluate(op, op_str, a, b, use_numexpr, **eval_kwargs)
    204     if use_numexpr:
--> 205         return _evaluate(op, op_str, a, b, **eval_kwargs)
    206     return _evaluate_standard(op, op_str, a, b)

~/anaconda3/lib/python3.7/site-packages/pandas/core/computation/expressions.py in _evaluate_numexpr(op, op_str, a, b, truediv, reversed, **eval_kwargs)
    119     if result is None:
--> 120         result = _evaluate_standard(op, op_str, a, b)
    121 

~/anaconda3/lib/python3.7/site-packages/pandas/core/computation/expressions.py in _evaluate_standard(op, op_str, a, b, **eval_kwargs)
     64     with np.errstate(all='ignore'):
---> 65         return op(a, b)
     66 

TypeError: unsupported operand type(s) for +: 'int' and 'str'

During handling of the above exception, another exception occurred:

TypeError                                 Traceback (most recent call last)
<ipython-input-13-07ecabcb1b41> in <module>()
----> 1 s1 + s2

~/anaconda3/lib/python3.7/site-packages/pandas/core/ops.py in wrapper(left, right)
   1067             rvalues = rvalues.values
   1068 
-> 1069         result = safe_na_op(lvalues, rvalues)
   1070         return construct_result(left, result,
   1071                                 index=left.index, name=res_name, dtype=None)

~/anaconda3/lib/python3.7/site-packages/pandas/core/ops.py in safe_na_op(lvalues, rvalues)
   1031         try:
   1032             with np.errstate(all='ignore'):
-> 1033                 return na_op(lvalues, rvalues)
   1034         except Exception:
   1035             if is_object_dtype(lvalues):

~/anaconda3/lib/python3.7/site-packages/pandas/core/ops.py in na_op(x, y)
   1016                 result = np.empty(x.size, dtype=dtype)
   1017                 mask = notna(x) & notna(y)
-> 1018                 result[mask] = op(x[mask], com._values_from_object(y[mask]))
   1019             else:
   1020                 assert isinstance(x, np.ndarray)

TypeError: unsupported operand type(s) for +: 'int' and 'str'

v = Series([-1, 1, 200, 191, 4])

v < 0

0     True
1    False
2    False
3    False
4    False
dtype: bool

v * v == 1

0     True
1     True
2    False
3    False
4    False
dtype: bool

v[v > 100]

2    200
3    191
dtype: int64

v[v % 2 == 0]

2    200
4      4
dtype: int64

v

0     -1
1      1
2    200
3    191
4      4
dtype: int64

v[(v > 0) & (v < 100)]

1    1
4    4
dtype: int64

name_column = Series(["Alice", "Bob", "Cindy", "Dan"])
score_column = Series([100, 150, 160, 120])

table = DataFrame({'name': name_column, 'score': score_column})

table

table["name"]

0    Alice
1      Bob
2    Cindy
3      Dan
Name: name, dtype: object

table["score"]

0    100
1    150
2    160
3    120
Name: score, dtype: int64

table.name

0    Alice
1      Bob
2    Cindy
3      Dan
Name: name, dtype: object

table.score

0    100
1    150
2    160
3    120
Name: score, dtype: int64

table.loc[0]

name     Alice
score      100
Name: 0, dtype: object

table[0]

---------------------------------------------------------------------------
KeyError                                  Traceback (most recent call last)
~/anaconda3/lib/python3.7/site-packages/pandas/core/indexes/base.py in get_loc(self, key, method, tolerance)
   3077             try:
-> 3078                 return self._engine.get_loc(key)
   3079             except KeyError:

pandas/_libs/index.pyx in pandas._libs.index.IndexEngine.get_loc()

pandas/_libs/index.pyx in pandas._libs.index.IndexEngine.get_loc()

pandas/_libs/hashtable_class_helper.pxi in pandas._libs.hashtable.PyObjectHashTable.get_item()

pandas/_libs/hashtable_class_helper.pxi in pandas._libs.hashtable.PyObjectHashTable.get_item()

KeyError: 0

During handling of the above exception, another exception occurred:

KeyError                                  Traceback (most recent call last)
<ipython-input-28-eeff6152b270> in <module>()
----> 1 table[0]

~/anaconda3/lib/python3.7/site-packages/pandas/core/frame.py in __getitem__(self, key)
   2686             return self._getitem_multilevel(key)
   2687         else:
-> 2688             return self._getitem_column(key)
   2689 
   2690     def _getitem_column(self, key):

~/anaconda3/lib/python3.7/site-packages/pandas/core/frame.py in _getitem_column(self, key)
   2693         # get column
   2694         if self.columns.is_unique:
-> 2695             return self._get_item_cache(key)
   2696 
   2697         # duplicate columns & possible reduce dimensionality

~/anaconda3/lib/python3.7/site-packages/pandas/core/generic.py in _get_item_cache(self, item)
   2487         res = cache.get(item)
   2488         if res is None:
-> 2489             values = self._data.get(item)
   2490             res = self._box_item_values(item, values)
   2491             cache[item] = res

~/anaconda3/lib/python3.7/site-packages/pandas/core/internals.py in get(self, item, fastpath)
   4113 
   4114             if not isna(item):
-> 4115                 loc = self.items.get_loc(item)
   4116             else:
   4117                 indexer = np.arange(len(self.items))[isna(self.items)]

~/anaconda3/lib/python3.7/site-packages/pandas/core/indexes/base.py in get_loc(self, key, method, tolerance)
   3078                 return self._engine.get_loc(key)
   3079             except KeyError:
-> 3080                 return self._engine.get_loc(self._maybe_cast_indexer(key))
   3081 
   3082         indexer = self.get_indexer([key], method=method, tolerance=tolerance)

pandas/_libs/index.pyx in pandas._libs.index.IndexEngine.get_loc()

pandas/_libs/index.pyx in pandas._libs.index.IndexEngine.get_loc()

pandas/_libs/hashtable_class_helper.pxi in pandas._libs.hashtable.PyObjectHashTable.get_item()

pandas/_libs/hashtable_class_helper.pxi in pandas._libs.hashtable.PyObjectHashTable.get_item()

KeyError: 0

table.loc[1]

name     Bob
score    150
Name: 1, dtype: object

table

table.loc[1, "score"]

150

table.loc[1, "name"]

'Bob'

table.loc[1, "score"] = 200

table

movies = pd.read_csv("IMDB-Movie-Data.csv")
movies

len(movies)

998

movies.head()

movies.head(10)

titles = movies["Title"]
titles

0                      Guardians of the Galaxy
1                                   Prometheus
2                                        Split
3                                         Sing
4                                Suicide Squad
5                               The Great Wall
6                                   La La Land
7                                     Mindhorn
8                           The Lost City of Z
9                                   Passengers
10     Fantastic Beasts and Where to Find Them
11                              Hidden Figures
12                                   Rogue One
13                                       Moana
14                                    Colossal
15                     The Secret Life of Pets
16                               Hacksaw Ridge
17                                Jason Bourne
18                                        Lion
19                                     Arrival
20                                        Gold
21                       Manchester by the Sea
22                              Hounds of Love
23                                      Trolls
24                Independence Day: Resurgence
25                             Paris pieds nus
26                     Bahubali: The Beginning
27                                  Dead Awake
28                                    Bad Moms
29                            Assassin's Creed
                        ...                   
968                          Texas Chainsaw 3D
969                                  Disturbia
970                               Rock of Ages
971                                   Scream 4
972                             Queen of Katwe
973                 My Big Fat Greek Wedding 2
974                                Dark Places
975                              Amateur Night
976             It's Only the End of the World
977                         The Skin I Live In
978                       Miracles from Heaven
979                                      Annie
980                        Across the Universe
981                              Let's Be Cops
982                                        Max
983                              Your Highness
984                        Final Destination 5
985                               Endless Love
986                                    Martyrs
987                                      Selma
988             Underworld: Rise of the Lycans
989                           Taare Zameen Par
990                       Take Me Home Tonight
991                   Resident Evil: Afterlife
992                                  Project X
993                       Secret in Their Eyes
994                            Hostel: Part II
995                     Step Up 2: The Streets
996                               Search Party
997                                 Nine Lives
Name: Title, Length: 998, dtype: object

titles.head()

0    Guardians of the Galaxy
1                 Prometheus
2                      Split
3                       Sing
4              Suicide Squad
Name: Title, dtype: object

title_list = list(titles)
title_list

['Guardians of the Galaxy',
 'Prometheus',
 'Split',
 'Sing',
 'Suicide Squad',
 'The Great Wall',
 'La La Land',
 'Mindhorn',
 'The Lost City of Z',
 'Passengers',
 'Fantastic Beasts and Where to Find Them',
 'Hidden Figures',
 'Rogue One',
 'Moana',
 'Colossal',
 'The Secret Life of Pets',
 'Hacksaw Ridge',
 'Jason Bourne',
 'Lion',
 'Arrival',
 'Gold',
 'Manchester by the Sea',
 'Hounds of Love',
 'Trolls',
 'Independence Day: Resurgence',
 'Paris pieds nus',
 'Bahubali: The Beginning',
 'Dead Awake',
 'Bad Moms',
 "Assassin's Creed",
 'Why Him?',
 'Nocturnal Animals',
 'X-Men: Apocalypse',
 'Deadpool',
 'Resident Evil: The Final Chapter',
 'Captain America: Civil War',
 'Interstellar',
 'Doctor Strange',
 'The Magnificent Seven',
 '5/25/1977',
 'Sausage Party',
 'Moonlight',
 "Don't Fuck in the Woods",
 'The Founder',
 'Lowriders',
 'Pirates of the Caribbean: On Stranger Tides',
 'Miss Sloane',
 'Fallen',
 'Star Trek Beyond',
 'The Last Face',
 'Star Wars: Episode VII - The Force Awakens',
 'Underworld: Blood Wars',
 "Mother's Day",
 'John Wick',
 'The Dark Knight',
 'Silence',
 "Don't Breathe",
 'Me Before You',
 'Their Finest',
 'Sully',
 'Batman v Superman: Dawn of Justice',
 'The Autopsy of Jane Doe',
 'The Girl on the Train',
 'Fifty Shades of Grey',
 'The Prestige',
 'Kingsman: The Secret Service',
 'Patriots Day',
 'Mad Max: Fury Road',
 'Wakefield',
 'Deepwater Horizon',
 'The Promise',
 'Allied',
 'A Monster Calls',
 'Collateral Beauty',
 'Zootopia',
 "Pirates of the Caribbean: At World's End",
 'The Avengers',
 'Inglourious Basterds',
 "Pirates of the Caribbean: Dead Man's Chest",
 'Ghostbusters',
 'Inception',
 'Captain Fantastic',
 'The Wolf of Wall Street',
 'Gone Girl',
 'Furious Seven',
 'Jurassic World',
 'Live by Night',
 'Avatar',
 'The Hateful Eight',
 'The Accountant',
 'Prisoners',
 'Warcraft',
 'The Help',
 'War Dogs',
 'Avengers: Age of Ultron',
 'The Nice Guys',
 'Kimi no na wa',
 'The Void',
 'Personal Shopper',
 'The Departed',
 'Legend',
 'Thor',
 'The Martian',
 'Contratiempo',
 'The Man from U.N.C.L.E.',
 'Hell or High Water',
 'The Comedian',
 'The Legend of Tarzan',
 'All We Had',
 'Ex Machina',
 'The Belko Experiment',
 '12 Years a Slave',
 'The Bad Batch',
 '300',
 'Harry Potter and the Deathly Hallows: Part 2',
 'Office Christmas Party',
 'The Neon Demon',
 'Dangal',
 '10 Cloverfield Lane',
 'Finding Dory',
 "Miss Peregrine's Home for Peculiar Children",
 'Divergent',
 'Mike and Dave Need Wedding Dates',
 'Boyka: Undisputed IV',
 'The Dark Knight Rises',
 'The Jungle Book',
 'Transformers: Age of Extinction',
 'Nerve',
 'Mamma Mia!',
 'The Revenant',
 'Fences',
 'Into the Woods',
 'The Shallows',
 'Whiplash',
 'Furious 6',
 'The Place Beyond the Pines',
 'No Country for Old Men',
 'The Great Gatsby',
 'Shutter Island',
 'Brimstone',
 'Star Trek',
 'Diary of a Wimpy Kid',
 'The Big Short',
 'Room',
 'Django Unchained',
 'Ah-ga-ssi',
 'The Edge of Seventeen',
 'Watchmen',
 'Superbad',
 'Inferno',
 'The BFG',
 'The Hunger Games',
 'White Girl',
 'Sicario',
 'Twin Peaks: The Missing Pieces',
 'Aliens vs Predator - Requiem',
 'Pacific Rim',
 'Crazy, Stupid, Love.',
 'Scott Pilgrim vs. the World',
 'Hot Fuzz',
 'Mine',
 'Free Fire',
 'X-Men: Days of Future Past',
 'Jack Reacher: Never Go Back',
 'Casino Royale',
 'Twilight',
 'Now You See Me 2',
 'Woman in Gold',
 '13 Hours',
 'Spectre',
 'Nightcrawler',
 'Kubo and the Two Strings',
 'Beyond the Gates',
 'Her',
 'Frozen',
 'Tomorrowland',
 'Dawn of the Planet of the Apes',
 'Tropic Thunder',
 'The Conjuring 2',
 'Ant-Man',
 "Bridget Jones's Baby",
 'The VVitch: A New-England Folktale',
 'Cinderella',
 'Realive',
 'Forushande',
 'Love',
 "Billy Lynn's Long Halftime Walk",
 'Crimson Peak',
 'Drive',
 'Trainwreck',
 'The Light Between Oceans',
 'Below Her Mouth',
 'Spotlight',
 'Morgan',
 'Warrior',
 'Captain America: The First Avenger',
 'Hacker',
 'Into the Wild',
 'The Imitation Game',
 'Central Intelligence',
 'Edge of Tomorrow',
 'A Cure for Wellness',
 'Snowden',
 'Iron Man',
 'Allegiant',
 'X: First Class',
 'Raw (II)',
 'Paterson',
 'Bridesmaids',
 'The Girl with All the Gifts',
 'San Andreas',
 'Spring Breakers',
 'Transformers',
 'Old Boy',
 'Thor: The Dark World',
 'Gods of Egypt',
 'Captain America: The Winter Soldier',
 'Monster Trucks',
 'A Dark Song',
 'Kick-Ass',
 'Hardcore Henry',
 'Cars',
 'It Follows',
 'The Girl with the Dragon Tattoo',
 "We're the Millers",
 'American Honey',
 'The Lobster',
 'Predators',
 'Maleficent',
 'Rupture',
 "Pan's Labyrinth",
 'A Kind of Murder',
 'Apocalypto',
 'Mission: Impossible - Rogue Nation',
 "The Huntsman: Winter's War",
 'The Perks of Being a Wallflower',
 'Jackie',
 'The Disappointments Room',
 'The Grand Budapest Hotel',
 'The Host ',
 'Fury',
 'Inside Out',
 'Rock Dog',
 'Terminator Genisys',
 'Percy Jackson & the Olympians: The Lightning Thief',
 'Les Misérables',
 'Children of Men',
 '20th Century Women',
 'Spy',
 'The Intouchables',
 'Bonjour Anne',
 'Kynodontas',
 'Straight Outta Compton',
 'The Amazing Spider-Man 2',
 'The Conjuring',
 'The Hangover',
 'Battleship',
 'Rise of the Planet of the Apes',
 'Lights Out',
 'Norman: The Moderate Rise and Tragic Fall of a New York Fixer',
 'Birdman or (The Unexpected Virtue of Ignorance)',
 'Black Swan',
 'Dear White People',
 'Nymphomaniac: Vol. I',
 'Teenage Mutant Ninja Turtles: Out of the Shadows',
 'Knock Knock',
 'Dirty Grandpa',
 'Cloud Atlas',
 'X-Men Origins: Wolverine',
 'Satanic',
 'Skyfall',
 'The Hobbit: An Unexpected Journey',
 '21 Jump Street',
 'Sing Street',
 'Ballerina',
 'Oblivion',
 '22 Jump Street',
 'Zodiac',
 'Everybody Wants Some!!',
 'Iron Man Three',
 'Now You See Me',
 'Sherlock Holmes',
 'Death Proof',
 'The Danish Girl',
 'Hercules',
 'Sucker Punch',
 'Keeping Up with the Joneses',
 'Jupiter Ascending',
 'Masterminds',
 'Iris',
 'Busanhaeng',
 'Pitch Perfect',
 'Neighbors 2: Sorority Rising',
 'The Exception',
 'Man of Steel',
 'The Choice',
 'Ice Age: Collision Course',
 'The Devil Wears Prada',
 'The Infiltrator',
 'There Will Be Blood',
 'The Equalizer',
 'Lone Survivor',
 'The Cabin in the Woods',
 'The House Bunny',
 "She's Out of My League",
 'Inherent Vice',
 'Alice Through the Looking Glass',
 'Vincent N Roxxy',
 'The Fast and the Furious: Tokyo Drift',
 'How to Be Single',
 'The Blind Side',
 "La vie d'Adèle",
 'The Babadook',
 'The Hobbit: The Battle of the Five Armies',
 'Harry Potter and the Order of the Phoenix',
 'Snowpiercer',
 'The 5th Wave',
 'The Stakelander',
 'The Visit',
 'Fast Five',
 'Step Up',
 'Lovesong',
 'RocknRolla',
 'In Time',
 'The Social Network',
 'The Last Witch Hunter',
 'Victor Frankenstein',
 'A Street Cat Named Bob',
 'Green Room',
 'Blackhat',
 'Storks',
 'American Sniper',
 'Dallas Buyers Club',
 'Lincoln',
 'Rush',
 'Before I Wake',
 'Silver Linings Playbook',
 'Tracktown',
 'The Fault in Our Stars',
 'Blended',
 'Fast & Furious',
 'Looper',
 'White House Down',
 "Pete's Dragon",
 'Spider-Man 3',
 'The Three Musketeers',
 'Stardust',
 'American Hustle',
 "Jennifer's Body",
 'Midnight in Paris',
 'Lady Macbeth',
 'Joy',
 'The Dressmaker',
 'Café Society',
 'Insurgent',
 'Seventh Son',
 'The Theory of Everything',
 'This Is the End',
 'About Time',
 'Step Brothers',
 'Clown',
 'Star Trek Into Darkness',
 'Zombieland',
 'Hail, Caesar!',
 'Slumdog Millionaire',
 'The Twilight Saga: Breaking Dawn - Part 2',
 'American Wrestler: The Wizard',
 'The Amazing Spider-Man',
 'Ben-Hur',
 'Sleight',
 'The Maze Runner',
 'Criminal',
 'Wanted',
 'Florence Foster Jenkins',
 'Collide',
 'Black Mass',
 'Creed',
 'Swiss Army Man',
 'The Expendables 3',
 'What We Do in the Shadows',
 'Southpaw',
 'Hush',
 'Bridge of Spies',
 'The Lego Movie',
 'Everest',
 'Pixels',
 'Robin Hood',
 'The Wolverine',
 'John Carter',
 'Keanu',
 'The Gunman',
 'Steve Jobs',
 'Whisky Galore',
 'Grown Ups 2',
 'The Age of Adaline',
 'The Incredible Hulk',
 'Couples Retreat',
 'Absolutely Anything',
 'Magic Mike',
 'Minions',
 'The Black Room',
 'Bronson',
 'Despicable Me',
 'The Best of Me',
 'The Invitation',
 'Zero Dark Thirty',
 'Tangled',
 'The Hunger Games: Mockingjay - Part 2',
 'Vacation',
 'Taken',
 'Pitch Perfect 2',
 'Monsters University',
 'Elle',
 'Mechanic: Resurrection',
 'Tusk',
 "The Headhunter's Calling",
 'Atonement',
 'Harry Potter and the Deathly Hallows: Part 1',
 'Shame',
 'Hanna',
 'The Babysitters',
 'Pride and Prejudice and Zombies',
 '300: Rise of an Empire',
 'London Has Fallen',
 'The Curious Case of Benjamin Button',
 'Sin City: A Dame to Kill For',
 'The Bourne Ultimatum',
 'Srpski film',
 'The Purge: Election Year',
 '3 Idiots',
 'Zoolander 2',
 'World War Z',
 'Mission: Impossible - Ghost Protocol',
 'Let Me Make You a Martyr',
 'Filth',
 'The Longest Ride',
 'The imposible',
 'Kick-Ass 2',
 'Folk Hero & Funny Guy',
 'Oz the Great and Powerful',
 'Brooklyn',
 'Coraline',
 'Blue Valentine',
 'The Thinning',
 'Silent Hill',
 'Dredd',
 'Hunt for the Wilderpeople',
 'Big Hero 6',
 'Carrie',
 'Iron Man 2',
 'Demolition',
 'Pandorum',
 'Olympus Has Fallen',
 'I Am Number Four',
 'Jagten',
 'The Proposal',
 'Get Hard',
 'Just Go with It',
 'Revolutionary Road',
 'The Town',
 'The Boy',
 'Denial',
 'Predestination',
 'Goosebumps',
 'Sherlock Holmes: A Game of Shadows',
 'Salt',
 'Enemy',
 'District 9',
 'The Other Guys',
 'American Gangster',
 'Marie Antoinette',
 '2012',
 'Harry Potter and the Half-Blood Prince',
 'Argo',
 'Eddie the Eagle',
 'The Lives of Others',
 'Pet',
 'Paint It Black',
 'Macbeth',
 'Forgetting Sarah Marshall',
 'The Giver',
 'Triple 9',
 'Perfetti sconosciuti',
 'Angry Birds',
 'Moonrise Kingdom',
 'Hairspray',
 'Safe Haven',
 'Focus',
 'Ratatouille',
 'Stake Land',
 'The Book of Eli',
 'Cloverfield',
 'Point Break',
 'Under the Skin',
 'I Am Legend',
 'Men in Black 3',
 'Super 8',
 'Law Abiding Citizen',
 'Up',
 'Maze Runner: The Scorch Trials',
 'Carol',
 'Imperium',
 'Youth',
 'Mr. Nobody',
 'City of Tiny Lights',
 'Savages',
 '(500) Days of Summer',
 'Movie 43',
 'Gravity',
 'The Boy in the Striped Pyjamas',
 'Shooter',
 'The Happening',
 'Bone Tomahawk',
 'Magic Mike XXL',
 'Easy A',
 'Exodus: Gods and Kings',
 'Chappie',
 'The Hobbit: The Desolation of Smaug',
 'Half of a Yellow Sun',
 'Anthropoid',
 'The Counselor',
 'Viking',
 'Whiskey Tango Foxtrot',
 'Trust',
 'Birth of the Dragon',
 'Elysium',
 'The Green Inferno',
 'Godzilla',
 'The Bourne Legacy',
 'A Good Year',
 'Friend Request',
 'Deja Vu',
 'Lucy',
 'A Quiet Passion',
 'Need for Speed',
 'Jack Reacher',
 'The Do-Over',
 'True Crimes',
 'American Pastoral',
 'The Ghost Writer',
 'Limitless',
 'Spectral',
 'P.S. I Love You',
 'Zipper',
 'Midnight Special',
 "Don't Think Twice",
 'Alice in Wonderland',
 'Chuck',
 'I, Daniel Blake',
 'The Break-Up',
 'Loving',
 'Fantastic Four',
 'The Survivalist',
 'Colonia',
 'The Boy Next Door',
 'The Gift',
 'Dracula Untold',
 'In the Heart of the Sea',
 'Idiocracy',
 'The Expendables',
 'Evil Dead',
 'Sinister',
 'Wreck-It Ralph',
 'Snow White and the Huntsman',
 'Pan',
 'Transformers: Dark of the Moon',
 'Juno',
 'A Hologram for the King',
 'Money Monster',
 'The Other Woman',
 'Enchanted',
 'The Intern',
 'Little Miss Sunshine',
 'Bleed for This',
 'Clash of the Titans',
 'The Finest Hours',
 'Tron',
 'The Hunger Games: Catching Fire',
 'All Good Things',
 'Kickboxer: Vengeance',
 'The Last Airbender',
 'Sex Tape',
 "What to Expect When You're Expecting",
 'Moneyball',
 'Ghost Rider',
 'Unbroken',
 'Immortals',
 'Sunshine',
 'Brave',
 'Män som hatar kvinnor',
 'Adoration',
 'The Drop',
 "She's the Man",
 "Daddy's Home",
 'Let Me In',
 'Never Back Down',
 'Grimsby',
 'Moon',
 'Megamind',
 'Gangster Squad',
 'Blood Father',
 "He's Just Not That Into You",
 'Kung Fu Panda 3',
 'The Rise of the Krays',
 'Handsome Devil',
 "Winter's Bone",
 'Horrible Bosses',
 'Mommy',
 'Hellboy II: The Golden Army',
 'Beautiful Creatures',
 'Toni Erdmann',
 'The Lovely Bones',
 'The Assassination of Jesse James by the Coward Robert Ford',
 'Don Jon',
 'Bastille Day',
 "2307: Winter's Dream",
 'Free State of Jones',
 'Mr. Right',
 'The Secret Life of Walter Mitty',
 'Dope',
 'Underworld Awakening',
 'Antichrist',
 'Friday the 13th',
 'Taken 3',
 'Total Recall',
 'X-Men: The Last Stand',
 'The Escort',
 'The Whole Truth',
 'Night at the Museum: Secret of the Tomb',
 'Love & Other Drugs',
 'The Interview',
 'The Host',
 'Megan Is Missing',
 'WALL·E',
 'Knocked Up',
 'Source Code',
 'Lawless',
 'Unfriended',
 'American Reunion',
 'The Pursuit of Happyness',
 'Relatos salvajes',
 'The Ridiculous 6',
 'Frantz',
 'Viral',
 'Gran Torino',
 'Burnt',
 'Tall Men',
 'Sleeping Beauty',
 'Vampire Academy',
 'Sweeney Todd: The Demon Barber of Fleet Street',
 'Solace',
 'Insidious',
 'Popstar: Never Stop Never Stopping',
 'The Levelling',
 'Public Enemies',
 'Boyhood',
 'Teenage Mutant Ninja Turtles',
 'Eastern Promises',
 'The Daughter',
 'Pineapple Express',
 'The First Time',
 'Gone Baby Gone',
 'The Heat',
 "L'avenir",
 'Anna Karenina',
 'Regression',
 'Ted 2',
 'Pain & Gain',
 'Blood Diamond',
 "Devil's Knot",
 'Child 44',
 'The Hurt Locker',
 'Green Lantern',
 'War on Everyone',
 'The Mist',
 'Escape Plan',
 'Love, Rosie',
 'The DUFF',
 'The Age of Shadows',
 'The Hunger Games: Mockingjay - Part 1',
 'We Need to Talk About Kevin',
 'Love & Friendship',
 'The Mortal Instruments: City of Bones',
 'Seven Pounds',
 "The King's Speech",
 'Hunger',
 'Jumper',
 'Toy Story 3',
 'Tinker Tailor Soldier Spy',
 'Resident Evil: Retribution',
 'Dear Zindagi',
 'Genius',
 'Pompeii',
 'Life of Pi',
 "Hachi: A Dog's Tale",
 '10 Years',
 'I Origins',
 'Live Free or Die Hard',
 'The Matchbreaker',
 'Funny Games',
 'Ted',
 'RED',
 'Australia',
 'Faster',
 'The Neighbor',
 'The Adjustment Bureau',
 'The Hollars',
 'The Judge',
 'Closed Circuit',
 'Transformers: Revenge of the Fallen',
 'La tortue rouge',
 'The Book of Life',
 'Incendies',
 'The Heartbreak Kid',
 'Happy Feet',
 'Entourage',
 'The Strangers',
 'Noah',
 'Neighbors',
 'Nymphomaniac: Vol. II',
 'Wild',
 'Grown Ups',
 'Blair Witch',
 'The Karate Kid',
 'Dark Shadows',
 'Friends with Benefits',
 'The Illusionist',
 'The A-Team',
 'The Guest',
 'The Internship',
 'Paul',
 'This Beautiful Fantastic',
 'The Da Vinci Code',
 'Mr. Church',
 'Hugo',
 "The Blackcoat's Daughter",
 'Body of Lies',
 'Knight of Cups',
 'The Mummy: Tomb of the Dragon Emperor',
 'The Boss',
 'Hands of Stone',
 'El secreto de sus ojos',
 'True Grit',
 'We Are Your Friends',
 'A Million Ways to Die in the West',
 'Only for One Night',
 "Rules Don't Apply",
 'Ouija: Origin of Evil',
 'Percy Jackson: Sea of Monsters',
 'Fracture',
 'Oculus',
 'In Bruges',
 'This Means War',
 'Lída Baarová',
 'The Road',
 'Lavender',
 'Deuces',
 'Conan the Barbarian',
 'The Fighter',
 'August Rush',
 'Chef',
 'Eye in the Sky',
 'Eagle Eye',
 'The Purge',
 'PK',
 "Ender's Game",
 'Indiana Jones and the Kingdom of the Crystal Skull',
 'Paper Towns',
 'High-Rise',
 'Quantum of Solace',
 'The Assignment',
 'How to Train Your Dragon',
 'Lady in the Water',
 'The Fountain',
 'Cars 2',
 '31',
 'Final Girl',
 'Chalk It Up',
 'The Man Who Knew Infinity',
 'Unknown',
 'Self/less',
 'Mr. Brooks',
 'Tramps',
 'Before We Go',
 'Captain Phillips',
 'The Secret Scripture',
 'Max Steel',
 'Hotel Transylvania 2',
 'Hancock',
 'Sisters',
 'The Family',
 'Zack and Miri Make a Porno',
 'Ma vie de Courgette',
 'Man on a Ledge',
 'No Strings Attached',
 'Rescue Dawn',
 'Despicable Me 2',
 'A Walk Among the Tombstones',
 "The World's End",
 'Yoga Hosers',
 'Seven Psychopaths',
 'Beowulf',
 'Jack Ryan: Shadow Recruit',
 '1408',
 'The Gambler',
 'Prince of Persia: The Sands of Time',
 'The Spectacular Now',
 'A United Kingdom',
 'USS Indianapolis: Men of Courage',
 'Turbo Kid',
 'Mama',
 'Orphan',
 'To Rome with Love',
 'Fantastic Mr. Fox',
 'Inside Man',
 'I.T.',
 '127 Hours',
 'Annabelle',
 'Wolves at the Door',
 'Suite Française',
 'The Imaginarium of Doctor Parnassus',
 'G.I. Joe: The Rise of Cobra',
 'Christine',
 'Man Down',
 'Crawlspace',
 'Shut In',
 'The Warriors Gate',
 'Grindhouse',
 'Disaster Movie',
 'Rocky Balboa',
 'Diary of a Wimpy Kid: Dog Days',
 'Jane Eyre',
 "Fool's Gold",
 'The Dictator',
 'The Loft',
 'Bacalaureat',
 "You Don't Mess with the Zohan",
 'Exposed',
 'Maudie',
 'Horrible Bosses 2',
 'A Bigger Splash',
 'Melancholia',
 'The Princess and the Frog',
 'Unstoppable',
 'Flight',
 'Home',
 'La migliore offerta',
 'Mean Dreams',
 '42',
 '21',
 'Begin Again',
 'Out of the Furnace',
 'Vicky Cristina Barcelona',
 'Kung Fu Panda',
 'Barbershop: The Next Cut',
 'Terminator Salvation',
 'Freedom Writers',
 'The Hills Have Eyes',
 'Changeling',
 'Remember Me',
 'Koe no katachi',
 'Alexander and the Terrible, Horrible, No Good, Very Bad Day',
 'Locke',
 'The 9th Life of Louis Drax',
 'Horns',
 'Indignation',
 'The Stanford Prison Experiment',
 'Diary of a Wimpy Kid: Rodrick Rules',
 'Mission: Impossible III',
 'En man som heter Ove',
 'Dragonball Evolution',
 'Red Dawn',
 'One Day',
 'Life as We Know It',
 '28 Weeks Later',
 'Warm Bodies',
 'Blue Jasmine',
 'Wrath of the Titans',
 'Shin Gojira',
 'Saving Mr. Banks',
 'Transcendence',
 'Rio',
 'Equals',
 'Babel',
 'The Tree of Life',
 'The Lucky One',
 'Piranha 3D',
 '50/50',
 'The Intent',
 'This Is 40',
 'Real Steel',
 'Sex and the City',
 'Rambo',
 'Planet Terror',
 'Concussion',
 'The Fall',
 'The Ugly Truth',
 'Bride Wars',
 'Sleeping with Other People',
 'Snakes on a Plane',
 'What If',
 'How to Train Your Dragon 2',
 'RoboCop',
 'In Dubious Battle',
 'Hello, My Name Is Doris',
 "Ocean's Thirteen",
 'Slither',
 'Contagion',
 'Il racconto dei racconti - Tale of Tales',
 'I Am the Pretty Thing That Lives in the House',
 'Bridge to Terabithia',
 'Coherence',
 'Notorious',
 'Goksung',
 'The Expendables 2',
 'The Girl Next Door',
 'Perfume: The Story of a Murderer',
 'The Golden Compass',
 'Centurion',
 'Scouts Guide to the Zombie Apocalypse',
 '17 Again',
 'No Escape',
 'Superman Returns',
 'The Twilight Saga: Breaking Dawn - Part 1',
 'Precious',
 'The Sea of Trees',
 'Good Kids',
 'The Master',
 'Footloose',
 'If I Stay',
 'The Ticket',
 'Detour',
 'The Love Witch',
 'Talladega Nights: The Ballad of Ricky Bobby',
 'The Human Centipede (First Sequence)',
 'Super',
 'The Siege of Jadotville',
 'Up in the Air',
 'The Midnight Meat Train',
 'The Twilight Saga: Eclipse',
 'Transpecos',
 "What's Your Number?",
 'Riddick',
 'Triangle',
 'The Butler',
 'King Cobra',
 'After Earth',
 'Kicks',
 'Me and Earl and the Dying Girl',
 'The Descendants',
 'Sex and the City 2',
 'The Kings of Summer',
 'Death Race',
 'That Awkward Moment',
 'Legion',
 'End of Watch',
 '3 Days to Kill',
 'Lucky Number Slevin',
 'Trance',
 'Into the Forest',
 'The Other Boleyn Girl',
 'I Spit on Your Grave',
 'Custody',
 'Inland Empire',
 "L'odyssée",
 'The Walk',
 'Wrecker',
 'The Lone Ranger',
 'Texas Chainsaw 3D',
 'Disturbia',
 'Rock of Ages',
 'Scream 4',
 'Queen of Katwe',
 'My Big Fat Greek Wedding 2',
 'Dark Places',
 'Amateur Night',
 "It's Only the End of the World",
 'The Skin I Live In',
 'Miracles from Heaven',
 'Annie',
 'Across the Universe',
 "Let's Be Cops",
 'Max',
 'Your Highness',
 'Final Destination 5',
 'Endless Love',
 'Martyrs',
 'Selma',
 'Underworld: Rise of the Lycans',
 'Taare Zameen Par',
 'Take Me Home Tonight',
 'Resident Evil: Afterlife',
 'Project X',
 'Secret in Their Eyes',
 'Hostel: Part II',
 'Step Up 2: The Streets',
 'Search Party',
 'Nine Lives']

movies.head()

movies["Year"] == 2012

0      False
1       True
2      False
3      False
4      False
5      False
6      False
7      False
8      False
9      False
10     False
11     False
12     False
13     False
14     False
15     False
16     False
17     False
18     False
19     False
20     False
21     False
22     False
23     False
24     False
25     False
26     False
27     False
28     False
29     False
       ...  
968    False
969    False
970     True
971    False
972    False
973    False
974    False
975    False
976    False
977    False
978    False
979    False
980    False
981    False
982    False
983    False
984    False
985    False
986    False
987    False
988    False
989    False
990    False
991    False
992     True
993    False
994    False
995    False
996    False
997    False
Name: Year, Length: 998, dtype: bool

movies[movies["Year"] == 2012]

movies[movies["Year"] == 2012].head()

movies[movies["Year"] == 2012]["Rating"]

1      7.0
76     8.1
124    8.5
135    7.3
144    8.4
151    7.2
211    5.3
235    8.0
245    7.6
256    5.8
267    7.5
270    7.8
271    7.9
272    7.2
291    7.2
302    7.0
333    7.4
336    7.8
341    7.4
365    5.5
367    7.0
388    6.6
398    6.1
405    7.4
436    7.6
445    7.1
454    8.3
473    7.7
484    7.8
495    6.8
      ... 
562    7.8
563    6.1
582    5.7
588    7.2
620    6.4
624    6.3
636    7.3
638    6.7
660    6.9
664    6.6
689    5.4
693    7.9
700    7.0
724    6.2
752    6.3
793    6.6
800    7.2
812    6.3
830    6.4
833    6.4
844    7.3
871    5.4
877    5.8
885    6.5
889    6.2
914    6.6
927    7.1
955    7.7
970    5.9
992    6.7
Name: Rating, Length: 64, dtype: float64

movies[movies["Year"] == 2012]["Rating"].describe()

count    64.000000
mean      6.925000
std       0.775006
min       5.300000
25%       6.400000
50%       7.000000
75%       7.425000
max       8.500000
Name: Rating, dtype: float64

movies.describe()

movies[movies["Year"] == 2012].describe()

movies.loc[0, "Title"]

'Guardians of the Galaxy'

movies.head()

movies.Rating.mean()

6.723446893787578

	Index	Title	Genre	Director	Cast	Year	Runtime	Rating	Revenue
0	0	Guardians of the Galaxy	Action,Adventure,Sci-Fi	James Gunn	Chris Pratt, Vin Diesel, Bradley Cooper, Zoe S...	2014	121	8.1	333.13
1	1	Prometheus	Adventure,Mystery,Sci-Fi	Ridley Scott	Noomi Rapace, Logan Marshall-Green, Michael ...	2012	124	7.0	126.46M
2	2	Split	Horror,Thriller	M. Night Shyamalan	James McAvoy, Anya Taylor-Joy, Haley Lu Richar...	2016	117	7.3	138.12M
3	3	Sing	Animation,Comedy,Family	Christophe Lourdelet	Matthew McConaughey,Reese Witherspoon, Seth Ma...	2016	108	7.2	270.32
4	4	Suicide Squad	Action,Adventure,Fantasy	David Ayer	Will Smith, Jared Leto, Margot Robbie, Viola D...	2016	123	6.2	325.02
5	5	The Great Wall	Action,Adventure,Fantasy	Yimou Zhang	Matt Damon, Tian Jing, Willem Dafoe, Andy Lau	2016	103	6.1	45.13
6	6	La La Land	Comedy,Drama,Music	Damien Chazelle	Ryan Gosling, Emma Stone, Rosemarie DeWitt, J....	2016	128	8.3	151.06M
7	7	Mindhorn	Comedy	Sean Foley	Essie Davis, Andrea Riseborough, Julian Barrat...	2016	89	6.4	0
8	8	The Lost City of Z	Action,Adventure,Biography	James Gray	Charlie Hunnam, Robert Pattinson, Sienna Mille...	2016	141	7.1	8.01
9	9	Passengers	Adventure,Drama,Romance	Morten Tyldum	Jennifer Lawrence, Chris Pratt, Michael Sheen,...	2016	116	7.0	100.01M
10	10	Fantastic Beasts and Where to Find Them	Adventure,Family,Fantasy	David Yates	Eddie Redmayne, Katherine Waterston, Alison Su...	2016	133	7.5	234.02
11	11	Hidden Figures	Biography,Drama,History	Theodore Melfi	Taraji P. Henson, Octavia Spencer, Janelle Mon...	2016	127	7.8	169.27M
12	12	Rogue One	Action,Adventure,Sci-Fi	Gareth Edwards	Felicity Jones, Diego Luna, Alan Tudyk, Donnie...	2016	133	7.9	532.17
13	13	Moana	Animation,Adventure,Comedy	Ron Clements	Auli'i Cravalho, Dwayne Johnson, Rachel House,...	2016	107	7.7	248.75
14	14	Colossal	Action,Comedy,Drama	Nacho Vigalondo	Anne Hathaway, Jason Sudeikis, Austin Stowell,...	2016	109	6.4	2.87
15	15	The Secret Life of Pets	Animation,Adventure,Comedy	Chris Renaud	Louis C.K., Eric Stonestreet, Kevin Hart, Lake...	2016	87	6.6	368.31
16	16	Hacksaw Ridge	Biography,Drama,History	Mel Gibson	Andrew Garfield, Sam Worthington, Luke Bracey,...	2016	139	8.2	67.12
17	17	Jason Bourne	Action,Thriller	Paul Greengrass	Matt Damon, Tommy Lee Jones, Alicia Vikander,V...	2016	123	6.7	162.16M
18	18	Lion	Biography,Drama	Garth Davis	Dev Patel, Nicole Kidman, Rooney Mara, Sunny P...	2016	118	8.1	51.69
19	19	Arrival	Drama,Mystery,Sci-Fi	Denis Villeneuve	Amy Adams, Jeremy Renner, Forest Whitaker,Mich...	2016	116	8.0	100.5M
20	20	Gold	Adventure,Drama,Thriller	Stephen Gaghan	Matthew McConaughey, Edgar Ramírez, Bryce Dall...	2016	120	6.7	7.22
21	21	Manchester by the Sea	Drama	Kenneth Lonergan	Casey Affleck, Michelle Williams, Kyle Chandle...	2016	137	7.9	47.7
22	22	Hounds of Love	Crime,Drama,Horror	Ben Young	Emma Booth, Ashleigh Cummings, Stephen Curry,S...	2016	108	6.7	0
23	23	Trolls	Animation,Adventure,Comedy	Walt Dohrn	Anna Kendrick, Justin Timberlake,Zooey Deschan...	2016	92	6.5	153.69M
24	24	Independence Day: Resurgence	Action,Adventure,Sci-Fi	Roland Emmerich	Liam Hemsworth, Jeff Goldblum, Bill Pullman,Ma...	2016	120	5.3	103.14M
25	25	Paris pieds nus	Comedy	Dominique Abel	Fiona Gordon, Dominique Abel,Emmanuelle Riva, ...	2016	83	6.8	0
26	26	Bahubali: The Beginning	Action,Adventure,Drama	S.S. Rajamouli	Prabhas, Rana Daggubati, Anushka Shetty,Tamann...	2015	159	8.3	6.5
27	27	Dead Awake	Horror,Thriller	Phillip Guzman	Jocelin Donahue, Jesse Bradford, Jesse Borrego...	2016	99	4.7	0.01
28	28	Bad Moms	Comedy	Jon Lucas	Mila Kunis, Kathryn Hahn, Kristen Bell,Christi...	2016	100	6.2	113.08M
29	29	Assassin's Creed	Action,Adventure,Drama	Justin Kurzel	Michael Fassbender, Marion Cotillard, Jer...	2016	115	5.9	54.65
...	...	...	...	...	...	...	...	...	...
968	968	Texas Chainsaw 3D	Horror,Thriller	John Luessenhop	Alexandra Daddario, Tania Raymonde, Scott East...	2013	92	4.8	34.33M
969	969	Disturbia	Drama,Mystery,Thriller	D.J. Caruso	Shia LaBeouf, David Morse, Carrie-Anne Moss, S...	2007	105	6.9	80.05
970	970	Rock of Ages	Comedy,Drama,Musical	Adam Shankman	Julianne Hough, Diego Boneta, Tom Cruise, Alec...	2012	123	5.9	38.51
971	971	Scream 4	Horror,Mystery	Wes Craven	Neve Campbell, Courteney Cox, David Arquette, ...	2011	111	6.2	38.18
972	972	Queen of Katwe	Biography,Drama,Sport	Mira Nair	Madina Nalwanga, David Oyelowo, Lupita Nyong'o...	2016	124	7.4	8.81
973	973	My Big Fat Greek Wedding 2	Comedy,Family,Romance	Kirk Jones	Nia Vardalos, John Corbett, Michael Constantin...	2016	94	6.0	59.57
974	974	Dark Places	Drama,Mystery,Thriller	Gilles Paquet-Brenner	Charlize Theron, Nicholas Hoult, Christina Hen...	2015	113	6.2	0
975	975	Amateur Night	Comedy	Lisa Addario	Jason Biggs, Janet Montgomery,Ashley Tisdale, ...	2016	92	5.0	0
976	976	It's Only the End of the World	Drama	Xavier Dolan	Nathalie Baye, Vincent Cassel, Marion Cotillar...	2016	97	7.0	0
977	977	The Skin I Live In	Drama,Thriller	Pedro Almodóvar	Antonio Banderas, Elena Anaya, Jan Cornet,Mari...	2011	120	7.6	3.19
978	978	Miracles from Heaven	Biography,Drama,Family	Patricia Riggen	Jennifer Garner, Kylie Rogers, Martin Henderso...	2016	109	7.0	61.69
979	979	Annie	Comedy,Drama,Family	Will Gluck	Quvenzhané Wallis, Cameron Diaz, Jamie Foxx, R...	2014	118	5.3	85.91
980	980	Across the Universe	Drama,Fantasy,Musical	Julie Taymor	Evan Rachel Wood, Jim Sturgess, Joe Anderson, ...	2007	133	7.4	24.34
981	981	Let's Be Cops	Comedy	Luke Greenfield	Jake Johnson, Damon Wayans Jr., Rob Riggle, Ni...	2014	104	6.5	82.39
982	982	Max	Adventure,Family	Boaz Yakin	Thomas Haden Church, Josh Wiggins, Luke Kleint...	2015	111	6.8	42.65
983	983	Your Highness	Adventure,Comedy,Fantasy	David Gordon Green	Danny McBride, Natalie Portman, James Franco, ...	2011	102	5.6	21.56
984	984	Final Destination 5	Horror,Thriller	Steven Quale	Nicholas D'Agosto, Emma Bell, Arlen Escarpeta,...	2011	92	5.9	42.58
985	985	Endless Love	Drama,Romance	Shana Feste	Gabriella Wilde, Alex Pettyfer, Bruce Greenwoo...	2014	104	6.3	23.39
986	986	Martyrs	Horror	Pascal Laugier	Morjana Alaoui, Mylène Jampanoï, Catherine Bég...	2008	99	7.1	0
987	987	Selma	Biography,Drama,History	Ava DuVernay	David Oyelowo, Carmen Ejogo, Tim Roth, Lorrain...	2014	128	7.5	52.07
988	988	Underworld: Rise of the Lycans	Action,Adventure,Fantasy	Patrick Tatopoulos	Rhona Mitra, Michael Sheen, Bill Nighy, Steven...	2009	92	6.6	45.8
989	989	Taare Zameen Par	Drama,Family,Music	Aamir Khan	Darsheel Safary, Aamir Khan, Tanay Chheda, Sac...	2007	165	8.5	1.2
990	990	Take Me Home Tonight	Comedy,Drama,Romance	Michael Dowse	Topher Grace, Anna Faris, Dan Fogler, Teresa P...	2011	97	6.3	6.92
991	991	Resident Evil: Afterlife	Action,Adventure,Horror	Paul W.S. Anderson	Milla Jovovich, Ali Larter, Wentworth Miller,K...	2010	97	5.9	60.13
992	992	Project X	Comedy	Nima Nourizadeh	Thomas Mann, Oliver Cooper, Jonathan Daniel Br...	2012	88	6.7	54.72
993	993	Secret in Their Eyes	Crime,Drama,Mystery	Billy Ray	Chiwetel Ejiofor, Nicole Kidman, Julia Roberts...	2015	111	6.2	0
994	994	Hostel: Part II	Horror	Eli Roth	Lauren German, Heather Matarazzo, Bijou Philli...	2007	94	5.5	17.54
995	995	Step Up 2: The Streets	Drama,Music,Romance	Jon M. Chu	Robert Hoffman, Briana Evigan, Cassie Ventura,...	2008	98	6.2	58.01
996	996	Search Party	Adventure,Comedy	Scot Armstrong	Adam Pally, T.J. Miller, Thomas Middleditch,Sh...	2014	93	5.6	0
997	997	Nine Lives	Comedy,Family,Fantasy	Barry Sonnenfeld	Kevin Spacey, Jennifer Garner, Robbie Amell,Ch...	2016	87	5.3	19.64

	Index	Title	Genre	Director	Cast	Year	Runtime	Rating	Revenue
0	0	Guardians of the Galaxy	Action,Adventure,Sci-Fi	James Gunn	Chris Pratt, Vin Diesel, Bradley Cooper, Zoe S...	2014	121	8.1	333.13
1	1	Prometheus	Adventure,Mystery,Sci-Fi	Ridley Scott	Noomi Rapace, Logan Marshall-Green, Michael ...	2012	124	7.0	126.46M
2	2	Split	Horror,Thriller	M. Night Shyamalan	James McAvoy, Anya Taylor-Joy, Haley Lu Richar...	2016	117	7.3	138.12M
3	3	Sing	Animation,Comedy,Family	Christophe Lourdelet	Matthew McConaughey,Reese Witherspoon, Seth Ma...	2016	108	7.2	270.32
4	4	Suicide Squad	Action,Adventure,Fantasy	David Ayer	Will Smith, Jared Leto, Margot Robbie, Viola D...	2016	123	6.2	325.02

	Index	Title	Genre	Director	Cast	Year	Runtime	Rating	Revenue
0	0	Guardians of the Galaxy	Action,Adventure,Sci-Fi	James Gunn	Chris Pratt, Vin Diesel, Bradley Cooper, Zoe S...	2014	121	8.1	333.13
1	1	Prometheus	Adventure,Mystery,Sci-Fi	Ridley Scott	Noomi Rapace, Logan Marshall-Green, Michael ...	2012	124	7.0	126.46M
2	2	Split	Horror,Thriller	M. Night Shyamalan	James McAvoy, Anya Taylor-Joy, Haley Lu Richar...	2016	117	7.3	138.12M
3	3	Sing	Animation,Comedy,Family	Christophe Lourdelet	Matthew McConaughey,Reese Witherspoon, Seth Ma...	2016	108	7.2	270.32
4	4	Suicide Squad	Action,Adventure,Fantasy	David Ayer	Will Smith, Jared Leto, Margot Robbie, Viola D...	2016	123	6.2	325.02
5	5	The Great Wall	Action,Adventure,Fantasy	Yimou Zhang	Matt Damon, Tian Jing, Willem Dafoe, Andy Lau	2016	103	6.1	45.13
6	6	La La Land	Comedy,Drama,Music	Damien Chazelle	Ryan Gosling, Emma Stone, Rosemarie DeWitt, J....	2016	128	8.3	151.06M
7	7	Mindhorn	Comedy	Sean Foley	Essie Davis, Andrea Riseborough, Julian Barrat...	2016	89	6.4	0
8	8	The Lost City of Z	Action,Adventure,Biography	James Gray	Charlie Hunnam, Robert Pattinson, Sienna Mille...	2016	141	7.1	8.01
9	9	Passengers	Adventure,Drama,Romance	Morten Tyldum	Jennifer Lawrence, Chris Pratt, Michael Sheen,...	2016	116	7.0	100.01M

	Index	Title	Genre	Director	Cast	Year	Runtime	Rating	Revenue
0	0	Guardians of the Galaxy	Action,Adventure,Sci-Fi	James Gunn	Chris Pratt, Vin Diesel, Bradley Cooper, Zoe S...	2014	121	8.1	333.13
1	1	Prometheus	Adventure,Mystery,Sci-Fi	Ridley Scott	Noomi Rapace, Logan Marshall-Green, Michael ...	2012	124	7.0	126.46M
2	2	Split	Horror,Thriller	M. Night Shyamalan	James McAvoy, Anya Taylor-Joy, Haley Lu Richar...	2016	117	7.3	138.12M
3	3	Sing	Animation,Comedy,Family	Christophe Lourdelet	Matthew McConaughey,Reese Witherspoon, Seth Ma...	2016	108	7.2	270.32
4	4	Suicide Squad	Action,Adventure,Fantasy	David Ayer	Will Smith, Jared Leto, Margot Robbie, Viola D...	2016	123	6.2	325.02

	Index	Year	Runtime	Rating
count	998.000000	998.000000	998.000000	998.000000
mean	498.500000	2012.779559	113.170341	6.723447
std	288.242086	3.207549	18.828877	0.945682
min	0.000000	2006.000000	66.000000	1.900000
25%	249.250000	2010.000000	100.000000	6.200000
50%	498.500000	2014.000000	111.000000	6.800000
75%	747.750000	2016.000000	123.000000	7.400000
max	997.000000	2016.000000	191.000000	9.000000

	Index	Year	Runtime	Rating
count	64.000000	64.0	64.000000	64.000000
mean	531.046875	2012.0	119.109375	6.925000
std	258.508446	0.0	21.832782	0.775006
min	1.000000	2012.0	83.000000	5.300000
25%	325.250000	2012.0	102.000000	6.400000
50%	531.500000	2012.0	114.500000	7.000000
75%	731.000000	2012.0	132.500000	7.425000
max	992.000000	2012.0	172.000000	8.500000