Applying multiple filter criter to a pandas DataFrame
Multiple Criteria Filtering

This introduction to pandas is derived from Data School's pandas Q&A with my own notes and code.

Applying multiple filter criter to a pandas DataFrame

In [1]:
import pandas as pd
In [2]:
url = 'http://bit.ly/imdbratings'

# Create movies DataFrame
movies = pd.read_csv(url)
In [3]:
movies.head()
Out[3]:
star_rating title content_rating genre duration actors_list
0 9.3 The Shawshank Redemption R Crime 142 [u'Tim Robbins', u'Morgan Freeman', u'Bob Gunt...
1 9.2 The Godfather R Crime 175 [u'Marlon Brando', u'Al Pacino', u'James Caan']
2 9.1 The Godfather: Part II R Crime 200 [u'Al Pacino', u'Robert De Niro', u'Robert Duv...
3 9.0 The Dark Knight PG-13 Action 152 [u'Christian Bale', u'Heath Ledger', u'Aaron E...
4 8.9 Pulp Fiction R Crime 154 [u'John Travolta', u'Uma Thurman', u'Samuel L....
In [8]:
movies[movies.duration >= 200]
Out[8]:
star_rating title content_rating genre duration actors_list
2 9.1 The Godfather: Part II R Crime 200 [u'Al Pacino', u'Robert De Niro', u'Robert Duv...
7 8.9 The Lord of the Rings: The Return of the King PG-13 Adventure 201 [u'Elijah Wood', u'Viggo Mortensen', u'Ian McK...
17 8.7 Seven Samurai UNRATED Drama 207 [u'Toshir\xf4 Mifune', u'Takashi Shimura', u'K...
78 8.4 Once Upon a Time in America R Crime 229 [u'Robert De Niro', u'James Woods', u'Elizabet...
85 8.4 Lawrence of Arabia PG Adventure 216 [u"Peter O'Toole", u'Alec Guinness', u'Anthony...
142 8.3 Lagaan: Once Upon a Time in India PG Adventure 224 [u'Aamir Khan', u'Gracy Singh', u'Rachel Shell...
157 8.2 Gone with the Wind G Drama 238 [u'Clark Gable', u'Vivien Leigh', u'Thomas Mit...
204 8.1 Ben-Hur G Adventure 212 [u'Charlton Heston', u'Jack Hawkins', u'Stephe...
445 7.9 The Ten Commandments APPROVED Adventure 220 [u'Charlton Heston', u'Yul Brynner', u'Anne Ba...
476 7.8 Hamlet PG-13 Drama 242 [u'Kenneth Branagh', u'Julie Christie', u'Dere...
630 7.7 Malcolm X PG-13 Biography 202 [u'Denzel Washington', u'Angela Bassett', u'De...
767 7.6 It's a Mad, Mad, Mad, Mad World APPROVED Action 205 [u'Spencer Tracy', u'Milton Berle', u'Ethel Me...

2 conditions

  • duration > 200
  • genre only Drama
In [13]:
True or False
Out[13]:
True
In [10]:
True or True
Out[10]:
True
In [11]:
False or False
Out[11]:
False
In [14]:
True and True
Out[14]:
True
In [16]:
True and False
Out[16]:
False
In [18]:
# when you wrap conditions in parantheses, you give order
# you do those in brackets first before 'and'
# AND
movies[(movies.duration >= 200) & (movies.genre == 'Drama')]
Out[18]:
star_rating title content_rating genre duration actors_list
17 8.7 Seven Samurai UNRATED Drama 207 [u'Toshir\xf4 Mifune', u'Takashi Shimura', u'K...
157 8.2 Gone with the Wind G Drama 238 [u'Clark Gable', u'Vivien Leigh', u'Thomas Mit...
476 7.8 Hamlet PG-13 Drama 242 [u'Kenneth Branagh', u'Julie Christie', u'Dere...
In [20]:
# OR 
movies[(movies.duration >= 200) | (movies.genre == 'Drama')]
Out[20]:
star_rating title content_rating genre duration actors_list
2 9.1 The Godfather: Part II R Crime 200 [u'Al Pacino', u'Robert De Niro', u'Robert Duv...
5 8.9 12 Angry Men NOT RATED Drama 96 [u'Henry Fonda', u'Lee J. Cobb', u'Martin Bals...
7 8.9 The Lord of the Rings: The Return of the King PG-13 Adventure 201 [u'Elijah Wood', u'Viggo Mortensen', u'Ian McK...
9 8.9 Fight Club R Drama 139 [u'Brad Pitt', u'Edward Norton', u'Helena Bonh...
13 8.8 Forrest Gump PG-13 Drama 142 [u'Tom Hanks', u'Robin Wright', u'Gary Sinise']
16 8.7 One Flew Over the Cuckoo's Nest R Drama 133 [u'Jack Nicholson', u'Louise Fletcher', u'Mich...
17 8.7 Seven Samurai UNRATED Drama 207 [u'Toshir\xf4 Mifune', u'Takashi Shimura', u'K...
22 8.7 It's a Wonderful Life APPROVED Drama 130 [u'James Stewart', u'Donna Reed', u'Lionel Bar...
24 8.7 Se7en R Drama 127 [u'Morgan Freeman', u'Brad Pitt', u'Kevin Spac...
27 8.6 The Silence of the Lambs R Drama 118 [u'Jodie Foster', u'Anthony Hopkins', u'Lawren...
32 8.6 Casablanca PG Drama 102 [u'Humphrey Bogart', u'Ingrid Bergman', u'Paul...
33 8.6 Whiplash R Drama 107 [u'Miles Teller', u'J.K. Simmons', u'Melissa B...
41 8.5 Sunset Blvd. NOT RATED Drama 110 [u'William Holden', u'Gloria Swanson', u'Erich...
47 8.5 Taare Zameen Par PG Drama 165 [u'Darsheel Safary', u'Aamir Khan', u'Tanay Ch...
50 8.5 Cinema Paradiso R Drama 155 [u'Philippe Noiret', u'Enzo Cannavale', u'Anto...
51 8.5 Apocalypse Now R Drama 153 [u'Martin Sheen', u'Marlon Brando', u'Robert D...
53 8.5 The Prestige PG-13 Drama 130 [u'Christian Bale', u'Hugh Jackman', u'Scarlet...
56 8.5 The Lives of Others R Drama 137 [u'Ulrich M\xfche', u'Martina Gedeck', u'Sebas...
58 8.5 Paths of Glory APPROVED Drama 88 [u'Kirk Douglas', u'Ralph Meeker', u'Adolphe M...
67 8.4 American Beauty R Drama 122 [u'Kevin Spacey', u'Annette Bening', u'Thora B...
72 8.4 Rang De Basanti NOT RATED Drama 157 [u'Aamir Khan', u'Soha Ali Khan', u'Siddharth']
73 8.4 Jodaeiye Nader az Simin PG-13 Drama 123 [u'Peyman Moaadi', u'Leila Hatami', u'Sareh Ba...
74 8.4 Citizen Kane APPROVED Drama 119 [u'Orson Welles', u'Joseph Cotten', u'Dorothy ...
77 8.4 Oldeuboi R Drama 120 [u'Min-sik Choi', u'Ji-tae Yu', u'Hye-jeong Ka...
78 8.4 Once Upon a Time in America R Crime 229 [u'Robert De Niro', u'James Woods', u'Elizabet...
83 8.4 To Kill a Mockingbird NOT RATED Drama 129 [u'Gregory Peck', u'John Megna', u'Frank Overt...
84 8.4 Requiem for a Dream R Drama 102 [u'Ellen Burstyn', u'Jared Leto', u'Jennifer C...
85 8.4 Lawrence of Arabia PG Adventure 216 [u"Peter O'Toole", u'Alec Guinness', u'Anthony...
87 8.4 Bicycle Thieves NOT RATED Drama 93 [u'Lamberto Maggiorani', u'Enzo Staiola', u'Li...
89 8.4 Swades NOT RATED Drama 189 [u'Shah Rukh Khan', u'Gayatri Joshi', u'Kishor...
... ... ... ... ... ... ...
875 7.5 Rust and Bone R Drama 120 [u'Marion Cotillard', u'Matthias Schoenaerts',...
877 7.5 Legends of the Fall R Drama 133 [u'Brad Pitt', u'Anthony Hopkins', u'Aidan Qui...
879 7.5 The Constant Gardener R Drama 129 [u'Ralph Fiennes', u'Rachel Weisz', u'Hubert K...
886 7.5 Pi R Drama 84 [u'Sean Gullette', u'Mark Margolis', u'Ben She...
887 7.5 The Devil's Backbone R Drama 106 [u'Marisa Paredes', u'Eduardo Noriega', u'Fede...
889 7.5 Devil's Advocate R Drama 144 [u'Keanu Reeves', u'Al Pacino', u'Charlize The...
895 7.5 Biutiful R Drama 148 [u'Javier Bardem', u'Maricel \xc1lvarez', u'Ha...
897 7.5 Calvary R Drama 102 [u'Brendan Gleeson', u"Chris O'Dowd", u'Kelly ...
901 7.5 Babel R Drama 143 [u'Brad Pitt', u'Cate Blanchett', u'Gael Garc\...
904 7.5 Sweeney Todd: The Demon Barber of Fleet Street R Drama 116 [u'Johnny Depp', u'Helena Bonham Carter', u'Al...
910 7.5 2046 R Drama 129 [u'Tony Chiu Wai Leung', u'Ziyi Zhang', u'Faye...
914 7.5 The Judge R Drama 141 [u'Robert Downey Jr.', u'Robert Duvall', u'Ver...
916 7.5 Up in the Air R Drama 109 [u'George Clooney', u'Vera Farmiga', u'Anna Ke...
917 7.5 Begin Again R Drama 104 [u'Keira Knightley', u'Mark Ruffalo', u'Adam L...
922 7.5 Mud PG-13 Drama 130 [u'Matthew McConaughey', u'Tye Sheridan', u'Ja...
923 7.5 Across the Universe PG-13 Drama 133 [u'Evan Rachel Wood', u'Jim Sturgess', u'Joe A...
925 7.5 Notes on a Scandal R Drama 92 [u'Cate Blanchett', u'Judi Dench', u'Andrew Si...
926 7.5 Inside Llewyn Davis R Drama 104 [u'Oscar Isaac', u'Carey Mulligan', u'John Goo...
939 7.4 Predestination R Drama 97 [u'Ethan Hawke', u'Sarah Snook', u'Noah Taylor']
941 7.4 A Bridge Too Far PG Drama 175 [u'Sean Connery', u"Ryan O'Neal", u'Michael Ca...
945 7.4 Take Shelter R Drama 120 [u'Michael Shannon', u'Jessica Chastain', u'Sh...
946 7.4 Far from Heaven PG-13 Drama 107 [u'Julianne Moore', u'Dennis Quaid', u'Dennis ...
947 7.4 Eraserhead UNRATED Drama 89 [u'Jack Nance', u'Charlotte Stewart', u'Allen ...
951 7.4 Sleepy Hollow R Drama 105 [u'Johnny Depp', u'Christina Ricci', u'Miranda...
955 7.4 Zero Dark Thirty R Drama 157 [u'Jessica Chastain', u'Joel Edgerton', u'Chri...
958 7.4 My Sister's Keeper PG-13 Drama 109 [u'Cameron Diaz', u'Abigail Breslin', u'Alec B...
968 7.4 The English Patient R Drama 162 [u'Ralph Fiennes', u'Juliette Binoche', u'Will...
970 7.4 Wonder Boys R Drama 107 [u'Michael Douglas', u'Tobey Maguire', u'Franc...
972 7.4 Blue Valentine NC-17 Drama 112 [u'Ryan Gosling', u'Michelle Williams', u'John...
973 7.4 The Cider House Rules PG-13 Drama 126 [u'Tobey Maguire', u'Charlize Theron', u'Micha...

287 rows × 6 columns

In [21]:
(movies.duration >= 200) | (movies.genre == 'Drama')
Out[21]:
0      False
1      False
2       True
3      False
4      False
5       True
6      False
7       True
8      False
9       True
10     False
11     False
12     False
13      True
14     False
15     False
16      True
17      True
18     False
19     False
20     False
21     False
22      True
23     False
24      True
25     False
26     False
27      True
28     False
29     False
       ...  
949    False
950    False
951     True
952    False
953    False
954    False
955     True
956    False
957    False
958     True
959    False
960    False
961    False
962    False
963    False
964    False
965    False
966    False
967    False
968     True
969    False
970     True
971    False
972     True
973     True
974    False
975    False
976    False
977    False
978    False
dtype: bool
In [22]:
(movies.duration >= 200) & (movies.genre == 'Drama')
Out[22]:
0      False
1      False
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      True
18     False
19     False
20     False
21     False
22     False
23     False
24     False
25     False
26     False
27     False
28     False
29     False
       ...  
949    False
950    False
951    False
952    False
953    False
954    False
955    False
956    False
957    False
958    False
959    False
960    False
961    False
962    False
963    False
964    False
965    False
966    False
967    False
968    False
969    False
970    False
971    False
972    False
973    False
974    False
975    False
976    False
977    False
978    False
dtype: bool

What if you want genres crime, drama, and action?

In [23]:
# slow method
movies[(movies.genre == 'Crime') | (movies.genre == 'Drama') | (movies.genre == 'Action')]
Out[23]:
star_rating title content_rating genre duration actors_list
0 9.3 The Shawshank Redemption R Crime 142 [u'Tim Robbins', u'Morgan Freeman', u'Bob Gunt...
1 9.2 The Godfather R Crime 175 [u'Marlon Brando', u'Al Pacino', u'James Caan']
2 9.1 The Godfather: Part II R Crime 200 [u'Al Pacino', u'Robert De Niro', u'Robert Duv...
3 9.0 The Dark Knight PG-13 Action 152 [u'Christian Bale', u'Heath Ledger', u'Aaron E...
4 8.9 Pulp Fiction R Crime 154 [u'John Travolta', u'Uma Thurman', u'Samuel L....
5 8.9 12 Angry Men NOT RATED Drama 96 [u'Henry Fonda', u'Lee J. Cobb', u'Martin Bals...
9 8.9 Fight Club R Drama 139 [u'Brad Pitt', u'Edward Norton', u'Helena Bonh...
11 8.8 Inception PG-13 Action 148 [u'Leonardo DiCaprio', u'Joseph Gordon-Levitt'...
12 8.8 Star Wars: Episode V - The Empire Strikes Back PG Action 124 [u'Mark Hamill', u'Harrison Ford', u'Carrie Fi...
13 8.8 Forrest Gump PG-13 Drama 142 [u'Tom Hanks', u'Robin Wright', u'Gary Sinise']
16 8.7 One Flew Over the Cuckoo's Nest R Drama 133 [u'Jack Nicholson', u'Louise Fletcher', u'Mich...
17 8.7 Seven Samurai UNRATED Drama 207 [u'Toshir\xf4 Mifune', u'Takashi Shimura', u'K...
19 8.7 Star Wars PG Action 121 [u'Mark Hamill', u'Harrison Ford', u'Carrie Fi...
20 8.7 The Matrix R Action 136 [u'Keanu Reeves', u'Laurence Fishburne', u'Car...
21 8.7 City of God R Crime 130 [u'Alexandre Rodrigues', u'Matheus Nachtergael...
22 8.7 It's a Wonderful Life APPROVED Drama 130 [u'James Stewart', u'Donna Reed', u'Lionel Bar...
23 8.7 The Usual Suspects R Crime 106 [u'Kevin Spacey', u'Gabriel Byrne', u'Chazz Pa...
24 8.7 Se7en R Drama 127 [u'Morgan Freeman', u'Brad Pitt', u'Kevin Spac...
27 8.6 The Silence of the Lambs R Drama 118 [u'Jodie Foster', u'Anthony Hopkins', u'Lawren...
28 8.6 Leon: The Professional R Crime 110 [u'Jean Reno', u'Gary Oldman', u'Natalie Portm...
32 8.6 Casablanca PG Drama 102 [u'Humphrey Bogart', u'Ingrid Bergman', u'Paul...
33 8.6 Whiplash R Drama 107 [u'Miles Teller', u'J.K. Simmons', u'Melissa B...
34 8.6 American History X R Crime 119 [u'Edward Norton', u'Edward Furlong', u"Beverl...
36 8.6 Saving Private Ryan R Action 169 [u'Tom Hanks', u'Matt Damon', u'Tom Sizemore']
37 8.6 Raiders of the Lost Ark PG Action 115 [u'Harrison Ford', u'Karen Allen', u'Paul Free...
40 8.5 The Green Mile R Crime 189 [u'Tom Hanks', u'Michael Clarke Duncan', u'Dav...
41 8.5 Sunset Blvd. NOT RATED Drama 110 [u'William Holden', u'Gloria Swanson', u'Erich...
43 8.5 The Dark Knight Rises PG-13 Action 165 [u'Christian Bale', u'Tom Hardy', u'Anne Hatha...
44 8.5 Gladiator R Action 155 [u'Russell Crowe', u'Joaquin Phoenix', u'Conni...
45 8.5 Terminator 2: Judgment Day R Action 137 [u'Arnold Schwarzenegger', u'Linda Hamilton', ...
... ... ... ... ... ... ...
916 7.5 Up in the Air R Drama 109 [u'George Clooney', u'Vera Farmiga', u'Anna Ke...
917 7.5 Begin Again R Drama 104 [u'Keira Knightley', u'Mark Ruffalo', u'Adam L...
918 7.5 Running Scared R Action 122 [u'Paul Walker', u'Cameron Bright', u'Chazz Pa...
920 7.5 Witness R Crime 112 [u'Harrison Ford', u'Kelly McGillis', u'Lukas ...
922 7.5 Mud PG-13 Drama 130 [u'Matthew McConaughey', u'Tye Sheridan', u'Ja...
923 7.5 Across the Universe PG-13 Drama 133 [u'Evan Rachel Wood', u'Jim Sturgess', u'Joe A...
924 7.5 Les Miserables PG-13 Crime 134 [u'Liam Neeson', u'Geoffrey Rush', u'Uma Thurm...
925 7.5 Notes on a Scandal R Drama 92 [u'Cate Blanchett', u'Judi Dench', u'Andrew Si...
926 7.5 Inside Llewyn Davis R Drama 104 [u'Oscar Isaac', u'Carey Mulligan', u'John Goo...
927 7.5 Brick R Crime 110 [u'Joseph Gordon-Levitt', u'Lukas Haas', u'Emi...
931 7.4 Mean Streets R Crime 112 [u'Robert De Niro', u'Harvey Keitel', u'David ...
939 7.4 Predestination R Drama 97 [u'Ethan Hawke', u'Sarah Snook', u'Noah Taylor']
941 7.4 A Bridge Too Far PG Drama 175 [u'Sean Connery', u"Ryan O'Neal", u'Michael Ca...
945 7.4 Take Shelter R Drama 120 [u'Michael Shannon', u'Jessica Chastain', u'Sh...
946 7.4 Far from Heaven PG-13 Drama 107 [u'Julianne Moore', u'Dennis Quaid', u'Dennis ...
947 7.4 Eraserhead UNRATED Drama 89 [u'Jack Nance', u'Charlotte Stewart', u'Allen ...
950 7.4 Bound R Crime 108 [u'Jennifer Tilly', u'Gina Gershon', u'Joe Pan...
951 7.4 Sleepy Hollow R Drama 105 [u'Johnny Depp', u'Christina Ricci', u'Miranda...
954 7.4 X-Men PG-13 Action 104 [u'Patrick Stewart', u'Hugh Jackman', u'Ian Mc...
955 7.4 Zero Dark Thirty R Drama 157 [u'Jessica Chastain', u'Joel Edgerton', u'Chri...
958 7.4 My Sister's Keeper PG-13 Drama 109 [u'Cameron Diaz', u'Abigail Breslin', u'Alec B...
963 7.4 La Femme Nikita R Action 118 [u'Anne Parillaud', u'Marc Duret', u'Patrick F...
967 7.4 The Rock R Action 136 [u'Sean Connery', u'Nicolas Cage', u'Ed Harris']
968 7.4 The English Patient R Drama 162 [u'Ralph Fiennes', u'Juliette Binoche', u'Will...
969 7.4 Law Abiding Citizen R Crime 109 [u'Gerard Butler', u'Jamie Foxx', u'Leslie Bibb']
970 7.4 Wonder Boys R Drama 107 [u'Michael Douglas', u'Tobey Maguire', u'Franc...
972 7.4 Blue Valentine NC-17 Drama 112 [u'Ryan Gosling', u'Michelle Williams', u'John...
973 7.4 The Cider House Rules PG-13 Drama 126 [u'Tobey Maguire', u'Charlize Theron', u'Micha...
976 7.4 Master and Commander: The Far Side of the World PG-13 Action 138 [u'Russell Crowe', u'Paul Bettany', u'Billy Bo...
978 7.4 Wall Street R Crime 126 [u'Charlie Sheen', u'Michael Douglas', u'Tamar...

538 rows × 6 columns

In [25]:
# fast method
filter_list = ['Crime', 'Drama', 'Action']
movies[movies.genre.isin(filter_list)]
Out[25]:
star_rating title content_rating genre duration actors_list
0 9.3 The Shawshank Redemption R Crime 142 [u'Tim Robbins', u'Morgan Freeman', u'Bob Gunt...
1 9.2 The Godfather R Crime 175 [u'Marlon Brando', u'Al Pacino', u'James Caan']
2 9.1 The Godfather: Part II R Crime 200 [u'Al Pacino', u'Robert De Niro', u'Robert Duv...
3 9.0 The Dark Knight PG-13 Action 152 [u'Christian Bale', u'Heath Ledger', u'Aaron E...
4 8.9 Pulp Fiction R Crime 154 [u'John Travolta', u'Uma Thurman', u'Samuel L....
5 8.9 12 Angry Men NOT RATED Drama 96 [u'Henry Fonda', u'Lee J. Cobb', u'Martin Bals...
9 8.9 Fight Club R Drama 139 [u'Brad Pitt', u'Edward Norton', u'Helena Bonh...
11 8.8 Inception PG-13 Action 148 [u'Leonardo DiCaprio', u'Joseph Gordon-Levitt'...
12 8.8 Star Wars: Episode V - The Empire Strikes Back PG Action 124 [u'Mark Hamill', u'Harrison Ford', u'Carrie Fi...
13 8.8 Forrest Gump PG-13 Drama 142 [u'Tom Hanks', u'Robin Wright', u'Gary Sinise']
16 8.7 One Flew Over the Cuckoo's Nest R Drama 133 [u'Jack Nicholson', u'Louise Fletcher', u'Mich...
17 8.7 Seven Samurai UNRATED Drama 207 [u'Toshir\xf4 Mifune', u'Takashi Shimura', u'K...
19 8.7 Star Wars PG Action 121 [u'Mark Hamill', u'Harrison Ford', u'Carrie Fi...
20 8.7 The Matrix R Action 136 [u'Keanu Reeves', u'Laurence Fishburne', u'Car...
21 8.7 City of God R Crime 130 [u'Alexandre Rodrigues', u'Matheus Nachtergael...
22 8.7 It's a Wonderful Life APPROVED Drama 130 [u'James Stewart', u'Donna Reed', u'Lionel Bar...
23 8.7 The Usual Suspects R Crime 106 [u'Kevin Spacey', u'Gabriel Byrne', u'Chazz Pa...
24 8.7 Se7en R Drama 127 [u'Morgan Freeman', u'Brad Pitt', u'Kevin Spac...
27 8.6 The Silence of the Lambs R Drama 118 [u'Jodie Foster', u'Anthony Hopkins', u'Lawren...
28 8.6 Leon: The Professional R Crime 110 [u'Jean Reno', u'Gary Oldman', u'Natalie Portm...
32 8.6 Casablanca PG Drama 102 [u'Humphrey Bogart', u'Ingrid Bergman', u'Paul...
33 8.6 Whiplash R Drama 107 [u'Miles Teller', u'J.K. Simmons', u'Melissa B...
34 8.6 American History X R Crime 119 [u'Edward Norton', u'Edward Furlong', u"Beverl...
36 8.6 Saving Private Ryan R Action 169 [u'Tom Hanks', u'Matt Damon', u'Tom Sizemore']
37 8.6 Raiders of the Lost Ark PG Action 115 [u'Harrison Ford', u'Karen Allen', u'Paul Free...
40 8.5 The Green Mile R Crime 189 [u'Tom Hanks', u'Michael Clarke Duncan', u'Dav...
41 8.5 Sunset Blvd. NOT RATED Drama 110 [u'William Holden', u'Gloria Swanson', u'Erich...
43 8.5 The Dark Knight Rises PG-13 Action 165 [u'Christian Bale', u'Tom Hardy', u'Anne Hatha...
44 8.5 Gladiator R Action 155 [u'Russell Crowe', u'Joaquin Phoenix', u'Conni...
45 8.5 Terminator 2: Judgment Day R Action 137 [u'Arnold Schwarzenegger', u'Linda Hamilton', ...
... ... ... ... ... ... ...
916 7.5 Up in the Air R Drama 109 [u'George Clooney', u'Vera Farmiga', u'Anna Ke...
917 7.5 Begin Again R Drama 104 [u'Keira Knightley', u'Mark Ruffalo', u'Adam L...
918 7.5 Running Scared R Action 122 [u'Paul Walker', u'Cameron Bright', u'Chazz Pa...
920 7.5 Witness R Crime 112 [u'Harrison Ford', u'Kelly McGillis', u'Lukas ...
922 7.5 Mud PG-13 Drama 130 [u'Matthew McConaughey', u'Tye Sheridan', u'Ja...
923 7.5 Across the Universe PG-13 Drama 133 [u'Evan Rachel Wood', u'Jim Sturgess', u'Joe A...
924 7.5 Les Miserables PG-13 Crime 134 [u'Liam Neeson', u'Geoffrey Rush', u'Uma Thurm...
925 7.5 Notes on a Scandal R Drama 92 [u'Cate Blanchett', u'Judi Dench', u'Andrew Si...
926 7.5 Inside Llewyn Davis R Drama 104 [u'Oscar Isaac', u'Carey Mulligan', u'John Goo...
927 7.5 Brick R Crime 110 [u'Joseph Gordon-Levitt', u'Lukas Haas', u'Emi...
931 7.4 Mean Streets R Crime 112 [u'Robert De Niro', u'Harvey Keitel', u'David ...
939 7.4 Predestination R Drama 97 [u'Ethan Hawke', u'Sarah Snook', u'Noah Taylor']
941 7.4 A Bridge Too Far PG Drama 175 [u'Sean Connery', u"Ryan O'Neal", u'Michael Ca...
945 7.4 Take Shelter R Drama 120 [u'Michael Shannon', u'Jessica Chastain', u'Sh...
946 7.4 Far from Heaven PG-13 Drama 107 [u'Julianne Moore', u'Dennis Quaid', u'Dennis ...
947 7.4 Eraserhead UNRATED Drama 89 [u'Jack Nance', u'Charlotte Stewart', u'Allen ...
950 7.4 Bound R Crime 108 [u'Jennifer Tilly', u'Gina Gershon', u'Joe Pan...
951 7.4 Sleepy Hollow R Drama 105 [u'Johnny Depp', u'Christina Ricci', u'Miranda...
954 7.4 X-Men PG-13 Action 104 [u'Patrick Stewart', u'Hugh Jackman', u'Ian Mc...
955 7.4 Zero Dark Thirty R Drama 157 [u'Jessica Chastain', u'Joel Edgerton', u'Chri...
958 7.4 My Sister's Keeper PG-13 Drama 109 [u'Cameron Diaz', u'Abigail Breslin', u'Alec B...
963 7.4 La Femme Nikita R Action 118 [u'Anne Parillaud', u'Marc Duret', u'Patrick F...
967 7.4 The Rock R Action 136 [u'Sean Connery', u'Nicolas Cage', u'Ed Harris']
968 7.4 The English Patient R Drama 162 [u'Ralph Fiennes', u'Juliette Binoche', u'Will...
969 7.4 Law Abiding Citizen R Crime 109 [u'Gerard Butler', u'Jamie Foxx', u'Leslie Bibb']
970 7.4 Wonder Boys R Drama 107 [u'Michael Douglas', u'Tobey Maguire', u'Franc...
972 7.4 Blue Valentine NC-17 Drama 112 [u'Ryan Gosling', u'Michelle Williams', u'John...
973 7.4 The Cider House Rules PG-13 Drama 126 [u'Tobey Maguire', u'Charlize Theron', u'Micha...
976 7.4 Master and Commander: The Far Side of the World PG-13 Action 138 [u'Russell Crowe', u'Paul Bettany', u'Billy Bo...
978 7.4 Wall Street R Crime 126 [u'Charlie Sheen', u'Michael Douglas', u'Tamar...

538 rows × 6 columns

Tags: pandas