Programming for Data Science

Pandas - DataFrame

Dr. Bhargavi R

SCOPE, VIT Chennai

import numpy as np
import pandas as pd

# `read_csv` has a number of optional parameters. Check the documnet 
#  you can see in this dataset that the CSV file has a built-in index, which pandas did not pick up on automatically.
# To make pandas use that column for the index we can specify an index_col



movies_df = pd.read_csv('/Volumes/Bhargavi\'s Drive/C Backup/documents/datascience/moviesData.csv', index_col = 0)
movies_df.head()

	title	title_type	genre	runtime	mpaa_rating	studio	thtr_rel_year	thtr_rel_month	thtr_rel_day	dvd_rel_year	...	best_actor_win	best_actress_win	best_dir_win	top200_box	director	actor1	actor2	actor3	actor4	actor5
1	Filly Brown	Feature Film	Drama	80.0	R	Indomina Media Inc.	2013	4	19	2013.0	...	no	no	no	no	Michael D. Olmos	Gina Rodriguez	Jenni Rivera	Lou Diamond Phillips	Emilio Rivera	Joseph Julian Soria
2	The Dish	Feature Film	Drama	101.0	PG-13	Warner Bros. Pictures	2001	3	14	2001.0	...	no	no	no	no	Rob Sitch	Sam Neill	Kevin Harrington	Patrick Warburton	Tom Long	Genevieve Mooy
3	Waiting for Guffman	Feature Film	Comedy	84.0	R	Sony Pictures Classics	1996	8	21	2001.0	...	no	no	no	no	Christopher Guest	Christopher Guest	Catherine O'Hara	Parker Posey	Eugene Levy	Bob Balaban
4	The Age of Innocence	Feature Film	Drama	139.0	PG	Columbia Pictures	1993	10	1	2001.0	...	yes	no	yes	no	Martin Scorsese	Daniel Day-Lewis	Michelle Pfeiffer	Winona Ryder	Richard E. Grant	Alec McCowen
5	Malevolence	Feature Film	Horror	90.0	R	Anchor Bay Entertainment	2004	9	10	2005.0	...	no	no	no	no	Stevan Mena	Samantha Dark	R. Brandon Johnson	Brandon Johnson	Heather Magee	Richard Glover

5 rows × 30 columns

Conditional Selection

# Let us now see how to select a subset of data which satisfies some conditions

# Let us ddescribe 'title_type'

movies_df['title_type'].describe()

count              600
unique               3
top       Feature Film
freq               545
Name: title_type, dtype: object

# See the unique values that title_type has
movies_df['title_type'].unique()

array(['Feature Film', 'Documentary', 'TV Movie'], dtype=object)

# Select the titles & genre and Directors of all the Documentary titles

# First let us create boolean index / mask

mask1 = movies_df['title_type'] == 'Documentary'
mask1.shape

(600,)

mask1.head(10)

1     False
2     False
3     False
4     False
5     False
6      True
7     False
8     False
9      True
10    False
Name: title_type, dtype: bool

# Now use the mask1 to select the data

df = movies_df[mask1]
print(df.shape)
df.head()

(51, 30)

	title	title_type	genre	runtime	mpaa_rating	studio	thtr_rel_year	thtr_rel_month	thtr_rel_day	dvd_rel_year	...	best_actor_win	best_actress_win	best_dir_win	top200_box	director	actor1	actor2	actor3	actor4	actor5
6	Old Partner	Documentary	Documentary	78.0	Unrated	Shcalo Media Group	2009	1	15	2010.0	...	no	no	no	no	Chung-ryoul Lee	Choi Won-kyun	Lee Sam-soon	Moo	NaN	NaN
9	Beauty Is Embarrassing	Documentary	Documentary	88.0	Unrated	Independent Pictures	2012	9	7	2013.0	...	no	no	no	no	Neil Berkeley	Paul Reubens	Matt Groening	Todd Oldham	Jonathan Dayton	Cliff Benjamin
22	The Gleaners and I	Documentary	Documentary	82.0	Unrated	Zeitgeist Films	2001	4	6	2002.0	...	no	no	no	no	Agnes Varda	Bodan Litnanski	Francois Wertheimer	Agnes Varda	Margaret Dumont	Virginia Grey
25	The Yes Men Fix the World	Documentary	Documentary	87.0	Unrated	Cinetic Media	2009	1	18	2010.0	...	no	no	no	no	Andy Bichlbaum	Andy Bichlbaum	Reggie Waits	Mike Bonanno	NaN	NaN
48	Mojados: Through the Night	Documentary	Documentary	65.0	Unrated	Diva	2004	3	12	2005.0	...	no	no	no	no	Tommy Davis	Tommy Davis	Guapo	Oso	Tigre	Viejo

5 rows × 30 columns

# Now select the Documentary titles and the corresponding Directors

df = df.loc[ : , ['title', 'director']]
df

	title	director
6	Old Partner	Chung-ryoul Lee
9	Beauty Is Embarrassing	Neil Berkeley
22	The Gleaners and I	Agnes Varda
25	The Yes Men Fix the World	Andy Bichlbaum
48	Mojados: Through the Night	Tommy Davis
60	Promises	B.Z. Goldberg
61	Most Dangerous Man in America: Daniel Ellsberg...	Judith Ehrlich
63	The Thin Blue Line	Errol Morris
88	Dirty Sanchez: The Movie	Jim Hickey
94	Charlie: The Life and Art of Charles Chaplin	Richard Schickel
112	Bhutto	Duane Baughman
123	Africa: The Serengeti	George Casey
126	Sherman's March	Ross McElwee
156	Blind Spot: Hitler's Secretary	Andre Heller
164	Kicking It	Jeff Werner
187	Gaza Strip	James Longley
190	Orwell Rolls in His Grave	Robert Kane Pappas
193	Better This World	Kelly Duane
214	Nostalgia for the Light	Patricio Guzman
218	Hotel Terminus: The Life and Times of Klaus Ba...	Marcel Ophuls
229	Man on Wire	James Marsh
245	Surviving Progress	Mathieu Roy
262	Love the Beast	Eric Bana
312	The End of America	Anne Sundberg
324	Man on Wire	James Marsh
333	49 Up	Michael Apted
353	Tabloid	Errol Morris
355	Benda Bilili!	Florent de la Tullaye
358	Jonestown: The Life and Death of Peoples Temple	Stanley Nelson
360	Ziggy Stardust and the Spiders from Mars	D.A. Pennebaker
371	The Last Lions	Dereck Joubert
383	After Innocence	Jessica Sanders
386	My Flesh and Blood	Jonathan Karsh
391	Into The Arms Of Strangers - Stories Of The Ki...	Mark Jonathan Harris
415	Cameraman: The Life And Work Of Jack Cardiff	Craig McCall
416	I Am Bruce Lee	Pete McCormack
417	Let It Be	Michael Lindsay-Hogg
453	Sans Soleil	Chris Marker
461	Grizzly Man	Werner Herzog
471	Theremin: An Electronic Odyssey	Steven M. Martin
490	Countdown to Zero	Lucy Walker
491	The Imposter	Bart Layton
501	Ghosts of Abu Ghraib	Rory Kennedy
510	Saint of 9/11	Glenn Holsten
531	Sea Monsters: A Prehistoric Adventure	Sean MacLeod Phillips
541	Crumb	Terry Zwigoff
547	Bright Leaves	Ross McElwee
548	Teenage Paparazzo	Adrian Grenier
555	Pete Seeger: The Power of Song	Jim Brown
563	The Tillman Story	Amir Bar-Lev
567	F for Fake	Orson Welles

# We can do all the above steps in one line also as follows
df = movies_df[movies_df['title_type'] == 'Documentary'].loc[ : , ['title', 'director']]
df

	title	director
6	Old Partner	Chung-ryoul Lee
9	Beauty Is Embarrassing	Neil Berkeley
22	The Gleaners and I	Agnes Varda
25	The Yes Men Fix the World	Andy Bichlbaum
48	Mojados: Through the Night	Tommy Davis
60	Promises	B.Z. Goldberg
61	Most Dangerous Man in America: Daniel Ellsberg...	Judith Ehrlich
63	The Thin Blue Line	Errol Morris
88	Dirty Sanchez: The Movie	Jim Hickey
94	Charlie: The Life and Art of Charles Chaplin	Richard Schickel
112	Bhutto	Duane Baughman
123	Africa: The Serengeti	George Casey
126	Sherman's March	Ross McElwee
156	Blind Spot: Hitler's Secretary	Andre Heller
164	Kicking It	Jeff Werner
187	Gaza Strip	James Longley
190	Orwell Rolls in His Grave	Robert Kane Pappas
193	Better This World	Kelly Duane
214	Nostalgia for the Light	Patricio Guzman
218	Hotel Terminus: The Life and Times of Klaus Ba...	Marcel Ophuls
229	Man on Wire	James Marsh
245	Surviving Progress	Mathieu Roy
262	Love the Beast	Eric Bana
312	The End of America	Anne Sundberg
324	Man on Wire	James Marsh
333	49 Up	Michael Apted
353	Tabloid	Errol Morris
355	Benda Bilili!	Florent de la Tullaye
358	Jonestown: The Life and Death of Peoples Temple	Stanley Nelson
360	Ziggy Stardust and the Spiders from Mars	D.A. Pennebaker
371	The Last Lions	Dereck Joubert
383	After Innocence	Jessica Sanders
386	My Flesh and Blood	Jonathan Karsh
391	Into The Arms Of Strangers - Stories Of The Ki...	Mark Jonathan Harris
415	Cameraman: The Life And Work Of Jack Cardiff	Craig McCall
416	I Am Bruce Lee	Pete McCormack
417	Let It Be	Michael Lindsay-Hogg
453	Sans Soleil	Chris Marker
461	Grizzly Man	Werner Herzog
471	Theremin: An Electronic Odyssey	Steven M. Martin
490	Countdown to Zero	Lucy Walker
491	The Imposter	Bart Layton
501	Ghosts of Abu Ghraib	Rory Kennedy
510	Saint of 9/11	Glenn Holsten
531	Sea Monsters: A Prehistoric Adventure	Sean MacLeod Phillips
541	Crumb	Terry Zwigoff
547	Bright Leaves	Ross McElwee
548	Teenage Paparazzo	Adrian Grenier
555	Pete Seeger: The Power of Song	Jim Brown
563	The Tillman Story	Amir Bar-Lev
567	F for Fake	Orson Welles

# We can even have multiple conditions 

movies_df[ (movies_df['title_type'] == 'Feature Film') & (movies_df['genre'] == 'Comedy') ]

	title	title_type	genre	runtime	mpaa_rating	studio	thtr_rel_year	thtr_rel_month	thtr_rel_day	dvd_rel_year	...	best_actor_win	best_actress_win	best_dir_win	top200_box	director	actor1	actor2	actor3	actor4	actor5
3	Waiting for Guffman	Feature Film	Comedy	84.0	R	Sony Pictures Classics	1996	8	21	2001.0	...	no	no	no	no	Christopher Guest	Christopher Guest	Catherine O'Hara	Parker Posey	Eugene Levy	Bob Balaban
13	The Royal Tenenbaums	Feature Film	Comedy	110.0	R	Buena Vista Distribution Compa	2002	1	4	2002.0	...	yes	yes	no	no	Wes Anderson	Gene Hackman	Anjelica Huston	Gwyneth Paltrow	Ben Stiller	Luke Wilson
14	School for Scoundrels	Feature Film	Comedy	100.0	PG-13	MGM	2006	9	23	2007.0	...	no	no	no	no	Todd Phillips	Billy Bob Thornton	Jon Heder	Jacinda Barrett	Michael Clarke Duncan	Horatio Sanz
15	Rhinestone	Feature Film	Comedy	111.0	PG	20th Century Fox	1984	6	20	2005.0	...	no	no	no	no	Bob Clark (III)	Dolly Parton	Sylvester Stallone	Richard Farnsworth	Ron Leibman	Tim Thomerson
26	Oh, God! You Devil	Feature Film	Comedy	97.0	PG	WARNER BROTHERS PICTURES	1984	11	9	2005.0	...	no	no	no	no	Paul Bogart	George Burns	Ted Wass	Roxanne Hart	Eugene Roche	John Doolittle
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
569	The Jerky Boys	Feature Film	Comedy	82.0	R	Buena Vista	1995	2	3	1995.0	...	no	no	no	no	James Melkonian	John G. Brennan	Johnny Brennan	Kamal Ahmed	Alan Arkin	William Hickey
574	Man of the House	Feature Film	Comedy	96.0	PG	All Girl Productions	1995	3	3	2003.0	...	no	no	no	no	James Orr	Jonathan Taylor Thomas	Chevy Chase	Farrah Fawcett	George Wendt	David Shiner
577	Mighty Aphrodite	Feature Film	Comedy	95.0	R	Miramax Films	1995	10	27	1999.0	...	no	no	yes	no	Woody Allen	Woody Allen	Mira Sorvino	Helena Bonham Carter	Olympia Dukakis	Michael Rapaport
597	Half Baked	Feature Film	Comedy	82.0	R	Universal Pictures	1998	1	16	1998.0	...	no	no	no	no	Tamra Davis	Dave Chappelle	Guillermo Diaz	Jim Breuer	Harland Williams	Rachel True
600	LOL	Feature Film	Comedy	97.0	PG-13	Lionsgate Films	2012	5	4	2012.0	...	no	no	no	no	Liza Azuelos	Miley Cyrus	Demi Moore	Ashley Greene	Douglas Booth	Adam G. Sevani

85 rows × 30 columns

# Select all the details of the movies for which genre is Horror or Comedy
movies_df[movies_df.genre.isin (['Horror', 'Comedy'])].head()

	title	title_type	genre	runtime	mpaa_rating	studio	thtr_rel_year	thtr_rel_month	thtr_rel_day	dvd_rel_year	...	best_actor_win	best_actress_win	best_dir_win	top200_box	director	actor1	actor2	actor3	actor4	actor5
3	Waiting for Guffman	Feature Film	Comedy	84.0	R	Sony Pictures Classics	1996	8	21	2001.0	...	no	no	no	no	Christopher Guest	Christopher Guest	Catherine O'Hara	Parker Posey	Eugene Levy	Bob Balaban
5	Malevolence	Feature Film	Horror	90.0	R	Anchor Bay Entertainment	2004	9	10	2005.0	...	no	no	no	no	Stevan Mena	Samantha Dark	R. Brandon Johnson	Brandon Johnson	Heather Magee	Richard Glover
13	The Royal Tenenbaums	Feature Film	Comedy	110.0	R	Buena Vista Distribution Compa	2002	1	4	2002.0	...	yes	yes	no	no	Wes Anderson	Gene Hackman	Anjelica Huston	Gwyneth Paltrow	Ben Stiller	Luke Wilson
14	School for Scoundrels	Feature Film	Comedy	100.0	PG-13	MGM	2006	9	23	2007.0	...	no	no	no	no	Todd Phillips	Billy Bob Thornton	Jon Heder	Jacinda Barrett	Michael Clarke Duncan	Horatio Sanz
15	Rhinestone	Feature Film	Comedy	111.0	PG	20th Century Fox	1984	6	20	2005.0	...	no	no	no	no	Bob Clark (III)	Dolly Parton	Sylvester Stallone	Richard Farnsworth	Ron Leibman	Tim Thomerson

5 rows × 30 columns

# How many movies are of the genre 'Horror'
Horror_count = movies_df[movies_df['genre'] == 'Horror'].shape[0] 
print(Horror_count)

23

# What is the average runtime of the movies

print(movies_df.runtime.mean())

105.8848080133556

# value_counts() can be used to see a list of unique values and how often they occur in the dataset

print(movies_df.title_type.value_counts())

Feature Film    545
Documentary      51
TV Movie          4
Name: title_type, dtype: int64

# Check the type of the datastructure the above query returns 

print(type(movies_df.title_type.value_counts()))

<class 'pandas.core.series.Series'>

# selecting a subset
columns_to_keep = ['title',
                   'title_type',
                   'genre',
                   'runtime',
                   'mpaa_rating']
df = movies_df[columns_to_keep]
print(df.shape)
df.head()

(600, 5)

	title	title_type	genre	runtime	mpaa_rating
1	Filly Brown	Feature Film	Drama	80.0	R
2	The Dish	Feature Film	Drama	101.0	PG-13
3	Waiting for Guffman	Feature Film	Comedy	84.0	R
4	The Age of Innocence	Feature Film	Drama	139.0	PG
5	Malevolence	Feature Film	Horror	90.0	R

# Delete/Drop columns
df = movies_df[columns_to_keep]
df = df.drop(columns = ['genre'])

# Alternatively df.drop(columns = ['genre'], inplace = True)

print(df.columns)

Index(['title', 'title_type', 'runtime', 'mpaa_rating'], dtype='object')

# Delete/Drop Rows

print(movies_df.shape)
print(movies_df.index)
rows_to_drop = [i for i in range(1, 600, 2)]
df_after_dropping_row = movies_df.drop(rows_to_drop)

print(df_after_dropping_row.shape)
df_after_dropping_row.head(10)

(600, 30)
Int64Index([  1,   2,   3,   4,   5,   6,   7,   8,   9,  10,
            ...
            591, 592, 593, 594, 595, 596, 597, 598, 599, 600],
           dtype='int64', length=600)
(300, 30)

	title	title_type	genre	runtime	mpaa_rating	studio	thtr_rel_year	thtr_rel_month	thtr_rel_day	dvd_rel_year	...	best_actor_win	best_actress_win	best_dir_win	top200_box	director	actor1	actor2	actor3	actor4	actor5
2	The Dish	Feature Film	Drama	101.0	PG-13	Warner Bros. Pictures	2001	3	14	2001.0	...	no	no	no	no	Rob Sitch	Sam Neill	Kevin Harrington	Patrick Warburton	Tom Long	Genevieve Mooy
4	The Age of Innocence	Feature Film	Drama	139.0	PG	Columbia Pictures	1993	10	1	2001.0	...	yes	no	yes	no	Martin Scorsese	Daniel Day-Lewis	Michelle Pfeiffer	Winona Ryder	Richard E. Grant	Alec McCowen
6	Old Partner	Documentary	Documentary	78.0	Unrated	Shcalo Media Group	2009	1	15	2010.0	...	no	no	no	no	Chung-ryoul Lee	Choi Won-kyun	Lee Sam-soon	Moo	NaN	NaN
8	Mad Dog Time	Feature Film	Drama	93.0	R	MGM/United Artists	1996	11	8	2004.0	...	yes	no	no	no	Larry Bishop	Richard Dreyfuss	Jeff Goldblum	Gabriel Byrne	Ellen Barkin	Diane Lane
10	The Snowtown Murders	Feature Film	Drama	119.0	Unrated	IFC Films	2012	3	2	2012.0	...	no	no	no	no	Justin Kurzel	Lucas Pittaway	Daniel Henshall	Louise Harris	Craig Coyne	Richard Green
12	Leap of Faith	Feature Film	Drama	108.0	PG-13	Paramount Home Video	1992	12	18	2003.0	...	no	no	no	no	Richard Pearce	Steve Martin	Debra Winger	Lolita Davidovich	Liam Neeson	Lukas Haas
14	School for Scoundrels	Feature Film	Comedy	100.0	PG-13	MGM	2006	9	23	2007.0	...	no	no	no	no	Todd Phillips	Billy Bob Thornton	Jon Heder	Jacinda Barrett	Michael Clarke Duncan	Horatio Sanz
16	Burn After Reading	Feature Film	Drama	96.0	R	Focus Features	2008	8	27	2008.0	...	no	yes	yes	no	Joel Coen	George Clooney	Frances McDormand	John Malkovich	Brad Pitt	Tilda Swinton
18	The Wood	Feature Film	Drama	106.0	R	Paramount Pictures	1999	7	16	2000.0	...	no	no	no	no	Rick Famuyiwa	Omar Epps	Sean Nelson	Taye Diggs	Trent Cameron	Richard T. Jones
20	Dragon Wars	Feature Film	Drama	90.0	PG-13	Sony Pictures Home Entertainment	2007	9	13	2008.0	...	no	no	no	no	Hyung-rae Shim	Jason Behr	Amanda Brooks	Robert Forster	Aimee Garcia	Craig Robinson

10 rows × 30 columns

# find the absolute deviation of runtime from the mean runtime of all the titles.
# Map can be used to transform a Series
# apply can be used to trnsfom a DataFrame

df = movies_df[['title', 'runtime']]
mean_runtime = movies_df.runtime.mean()
df2 = df.runtime.map(lambda x : abs(x - mean_runtime))
print('Mean runtime =',mean_runtime)
print(df2.head(20))

Mean runtime = 105.8848080133556
1     25.884808
2      4.884808
3     21.884808
4     33.115192
5     15.884808
6     27.884808
7     36.115192
8     12.884808
9     17.884808
10    13.115192
11    21.115192
12     2.115192
13     4.115192
14     5.884808
15     5.115192
16     9.884808
17    34.115192
18     0.115192
19    14.884808
20    15.884808
Name: runtime, dtype: float64

Aggregation and groupby

• We have already used couple of Aggregation functions
• Here is the list of aggregation functions
• count() Total number of items
• first(), last() - First and last item respectively
• mean(), median() - Mean and median respectively
• min(), max() - Minimum and maximum respectively
• std(), var() - Standard deviation and variance respectively
• mad() Mean absolute deviation
• prod() Product of all items
• sum() Sum of all items

print(movies_df.groupby('thtr_rel_year'))
for group_name,group_df in movies_df.groupby('thtr_rel_year'):
    print(10*'-',group_name,10*'-')
    print(group_df)
# movies_df.groupby('thtr_rel_year').groups

<pandas.core.groupby.generic.DataFrameGroupBy object at 0x117a65f90>
---------- 1970 ----------
         title   title_type        genre  runtime mpaa_rating          studio  \
417  Let It Be  Documentary  Documentary     81.0           G  United Artists   

     thtr_rel_year  thtr_rel_month  thtr_rel_day  dvd_rel_year  ...  \
417           1970               5            20           NaN  ...   

     best_actor_win  best_actress_win  best_dir_win  top200_box  \
417              no                no            no          no   

                 director       actor1          actor2       actor3  \
417  Michael Lindsay-Hogg  Beatles The  Paul McCartney  Ringo Starr   

              actor4       actor5  
417  George Harrison  John Lennon  

[1 rows x 30 columns]
---------- 1972 ----------
                                                 title    title_type   genre  \
135  Tang shan da xiong (Fists of Fury) (The Big Boss)  Feature Film   Drama   
372  Aguirre, der Zorn Gottes (Aguirre, the Wrath o...  Feature Film   Drama   
494                              Death Line (Raw Meat)  Feature Film  Horror   

     runtime mpaa_rating                     studio  thtr_rel_year  \
135    100.0           R  National General Pictures           1972   
372     93.0           R           New Yorker Films           1972   
494     87.0           R                        NaN           1972   

     thtr_rel_month  thtr_rel_day  dvd_rel_year  ...  best_actor_win  \
135               4             1        2005.0  ...              no   
372              12            29        2000.0  ...              no   
494               1             1        2003.0  ...              no   

     best_actress_win  best_dir_win  top200_box       director  \
135                no            no          no         Wei Lo   
372                no            no          no  Werner Herzog   
494                no            no          no   Gary Sherman   

             actor1         actor2         actor3      actor4           actor5  
135       Bruce Lee       Maria Yi      Nora Miao  James Tien     Mao Ker Hsiu  
372    Klaus Kinski     Ruy Guerra     Ruy Guerra   Del Negro        Del Negro  
494  Hugh Armstrong  James Cossins  Sharon Gurney  David Ladd  Christopher Lee  

[3 rows x 30 columns]
---------- 1973 ----------
                                        title    title_type  \
39                                    Serpico  Feature Film   
360  Ziggy Stardust and the Spiders from Mars   Documentary   
468                                Robin Hood  Feature Film   
482                          Live and Let Die  Feature Film   

                  genre  runtime mpaa_rating                          studio  \
39                Drama    130.0           R              Paramount Pictures   
360         Documentary     90.0          PG  20th Century Fox Film Corporat   
468  Action & Adventure     83.0           G            Buena Vista Pictures   
482  Mystery & Suspense    121.0          PG          MGM Home Entertainment   

     thtr_rel_year  thtr_rel_month  thtr_rel_day  dvd_rel_year  ...  \
39            1973              12             5        2002.0  ...   
360           1973              12             1        2003.0  ...   
468           1973              11             8        2000.0  ...   
482           1973               6            27        1999.0  ...   

     best_actor_win  best_actress_win  best_dir_win  top200_box  \
39              yes                no            no          no   
360              no                no            no          no   
468              no                no            no          no   
482              no                no            no          no   

                director         actor1         actor2         actor3  \
39          Sidney Lumet      Al Pacino  John Randolph     Jack Kehoe   
360      D.A. Pennebaker    David Bowie    Mick Ronson  Trevor Bolder   
468  Wolfgang Reitherman  Brian Bedford    Phil Harris   Monica Evans   
482         Guy Hamilton    Roger Moore   Yaphet Kotto   Jane Seymour   

               actor4         actor5  
39       Tony Roberts   Biff McGuire  
360    Mick Woodmansy   Angela Bowie  
468     Peter Ustinov   Terry-Thomas  
482  Julius W. Harris  Clifton James  

[4 rows x 30 columns]
---------- 1974 ----------
                           title    title_type               genre  runtime  \
117             The Longest Yard  Feature Film               Drama    121.0   
329       The Godfather, Part II  Feature Film  Mystery & Suspense    202.0   
330      Phantom of the Paradise  Feature Film              Horror     92.0   
408  The Man with the Golden Gun  Feature Film               Drama    125.0   
527              Thieves Like Us  Feature Film               Drama    123.0   
567                   F for Fake   Documentary         Documentary     89.0   

    mpaa_rating                  studio  thtr_rel_year  thtr_rel_month  \
117           R    Paramount Home Video           1974               8   
329           R      Paramount Pictures           1974              12   
330          PG                     Fox           1974              10   
408          PG  MGM Home Entertainment           1974              12   
527           R          United Artists           1974               2   
567     Unrated          Saguenay Films           1974               9   

     thtr_rel_day  dvd_rel_year  ...  best_actor_win  best_actress_win  \
117            30        2001.0  ...              no                no   
329            20        2005.0  ...             yes               yes   
330            31        2001.0  ...              no                no   
408            18        2002.0  ...              no                no   
527            11        2007.0  ...              no               yes   
567             1        2005.0  ...              no                no   

     best_dir_win  top200_box              director           actor1  \
117            no          no        Robert Aldrich    Burt Reynolds   
329           yes          no  Francis Ford Coppola        Al Pacino   
330            no          no         Brian DePalma   William Finley   
408            no          no          Guy Hamilton      Roger Moore   
527            no          no         Robert Altman  Keith Carradine   
567            no          no          Orson Welles     Orson Welles   

              actor2          actor3                actor4             actor5  
117     Eddie Albert       Ed Lauter        Michael Conrad  Malcolm Atterbury  
329   Robert De Niro   Robert Duvall          Diane Keaton        Talia Shire  
330    Paul Williams  Jessica Harper        George Memmoli      Gerrit Graham  
408  Christopher Lee    Britt Ekland            Maud Adams  Herve Villechaize  
527   Shelley Duvall     John Schuck           Bert Remsen    Louise Fletcher  
567        Oja Kodar   Joseph Cotten  Francois Reichenbach     Richard Wilson  

[6 rows x 30 columns]
---------- 1975 ----------
                              title    title_type               genre  \
159               A Boy and His Dog  Feature Film               Drama   
249                  Love and Death  Feature Film               Drama   
261  The Return of the Pink Panther  Feature Film  Mystery & Suspense   
373                         Inserts  Feature Film               Drama   
591                      Funny Lady  Feature Film               Drama   

     runtime mpaa_rating             studio  thtr_rel_year  thtr_rel_month  \
159     91.0           R           eRealBiz           1975               3   
249     85.0          PG     United Artists           1975               6   
261    113.0           G     United Artists           1975               5   
373    117.0       NC-17                NaN           1975               1   
591    136.0          PG  Columbia Pictures           1975               3   

     thtr_rel_day  dvd_rel_year  ...  best_actor_win  best_actress_win  \
159             1        2003.0  ...              no                no   
249            10        2000.0  ...              no               yes   
261            21        2001.0  ...              no                no   
373             1        2005.0  ...             yes                no   
591             7        2002.0  ...              no               yes   

     best_dir_win  top200_box       director            actor1  \
159            no          no     L.Q. Jones       Don Johnson   
249           yes          no    Woody Allen       Woody Allen   
261            no          no  Blake Edwards     Peter Sellers   
373            no          no     John Byrum  Richard Dreyfuss   
591            no          no   Herbert Ross  Barbra Streisand   

                  actor2            actor3               actor4  \
159       Susanne Benton     Jason Robards                Tiger   
249         Diane Keaton      Harold Gould    Despo Diamantidou   
261  Christopher Plummer  Catherine Schell          Herbert Lom   
373       Jessica Harper    Stephen Davies  Veronica Cartwright   
591           James Caan       Omar Sharif       Roddy McDowall   

              actor5  
159   Charles McGraw  
249  Edmond Ardisson  
261       Peter Arne  
373      Bob Hoskins  
591       Ben Vereen  

[5 rows x 30 columns]
---------- 1976 ----------
                            title    title_type   genre  runtime mpaa_rating  \
133               The Shaggy D.A.  Feature Film  Comedy     91.0           G   
363  Next Stop, Greenwich Village  Feature Film   Drama    111.0           R   
393                A Star is Born  Feature Film   Drama    139.0           R   

                                studio  thtr_rel_year  thtr_rel_month  \
133            Walt Disney Productions           1976              12   
363  20th Century Fox Film Corporation           1976               2   
393              Warner Bros. Pictures           1976              12   

     thtr_rel_day  dvd_rel_year  ...  best_actor_win  best_actress_win  \
133            17        2006.0  ...              no                no   
363             4        2005.0  ...              no                no   
393            17        2004.0  ...              no               yes   

     best_dir_win  top200_box          director            actor1  \
133            no          no  Robert Stevenson        Dean Jones   
363            no          no     Paul Mazursky       Lenny Baker   
393            no          no  Frank R. Pierson  Barbra Streisand   

                 actor2              actor3             actor4          actor5  
133         Keenan Wynn          Tim Conway  Suzanne Pleshette   Jo Ann Worley  
363     Shelley Winters  Christopher Walken       Ellen Greene      Lois Smith  
393  Kris Kristofferson          Gary Busey       Oliver Clark  Vanetta Fields  

[3 rows x 30 columns]
---------- 1977 ----------
                                       title    title_type  \
46                             Viva Knievel!  Feature Film   
93                                Annie Hall  Feature Film   
134                  Orca - The Killer Whale  Feature Film   
137                       New York, New York  Feature Film   
138          Sinbad and the Eye of the Tiger  Feature Film   
172  The Bad News Bears in Breaking Training  Feature Film   
198                               One on One  Feature Film   
254                             Winter Kills  Feature Film   
405            The Last Remake of Beau Geste  Feature Film   
480                                 Oh, God!  Feature Film   
535                     Saturday Night Fever  Feature Film   
549                             The Gauntlet  Feature Film   

                         genre  runtime mpaa_rating                    studio  \
46                       Drama    106.0          PG  WARNER BROTHERS PICTURES   
93                      Comedy     93.0          PG            United Artists   
134                      Drama     92.0          PG        Paramount Pictures   
137                      Drama    155.0          PG    MGM Home Entertainment   
138         Action & Adventure    113.0           G         Columbia Pictures   
172                     Comedy    100.0          PG        Paramount Pictures   
198                      Drama     98.0          PG              Warner Bros.   
254         Mystery & Suspense     97.0           R     AVCO Embassy Pictures   
405         Action & Adventure     85.0          PG  MCA Universal Home Video   
480  Science Fiction & Fantasy     98.0          PG         Warner Home Video   
535                      Drama    118.0           R        Paramount Pictures   
549         Mystery & Suspense    109.0           R         Warner Home Video   

     thtr_rel_year  thtr_rel_month  thtr_rel_day  dvd_rel_year  ...  \
46            1977               7            15        2005.0  ...   
93            1977               4            20        1998.0  ...   
134           1977               7            15        2004.0  ...   
137           1977               6            22        2005.0  ...   
138           1977               1             1        2000.0  ...   
172           1977               7             8        2002.0  ...   
198           1977               6            28        2009.0  ...   
254           1977               1             1        2003.0  ...   
405           1977               7            15           NaN  ...   
480           1977              10             7        2002.0  ...   
535           1977              12            19        2002.0  ...   
549           1977               1             1        2001.0  ...   

     best_actor_win  best_actress_win  best_dir_win  top200_box  \
46               no                no            no          no   
93               no               yes           yes          no   
134              no                no            no          no   
137             yes               yes           yes          no   
138              no                no            no          no   
172              no                no            no          no   
198              no                no            no          no   
254             yes                no            no          no   
405              no                no            no          no   
480              no                no            no          no   
535              no                no            no         yes   
549              no                no           yes          no   

             director          actor1              actor2            actor3  \
46     Gordon Douglas    Evel Knievel       Lauren Hutton        Gene Kelly   
93        Woody Allen     Woody Allen        Diane Keaton      Tony Roberts   
134  Michael Anderson  Richard Harris  Charlotte Rampling       Keenan Wynn   
137   Martin Scorsese   Liza Minnelli      Robert De Niro    Lionel Stander   
138     Sam Wanamaker   Patrick Wayne         Taryn Power  Margaret Whiting   
172  Michael Pressman  William Devane  Jackie Earle Haley     Clifton James   
198    Lamont Johnson    Robby Benson     Annette O'Toole     G.D. Spradlin   
254   William Richert    Jeff Bridges         John Huston   Anthony Perkins   
405     Marty Feldman   Marty Feldman         Ann-Margret      Michael York   
480       Carl Reiner    George Burns         John Denver         Teri Garr   
535       John Badham   John Travolta   Karen Lynn Gorney      Donna Pescow   
549    Clint Eastwood  Clint Eastwood        Sondra Locke        Pat Hingle   

               actor4             actor5  
46        Red Buttons     Leslie Nielsen  
93         Paul Simon         Carol Kane  
134      Will Sampson           Bo Derek  
137      Barry Primus     Mary Kay Place  
138      Jane Seymour  Patrick Troughton  
172        Jimmy Baio       Chris Barnes  
198   Gail Strickland   Melanie Griffith  
254       Eli Wallach    Sterling Hayden  
405     Peter Ustinov   James Earl Jones  
480  Donald Pleasence      Ralph Bellamy  
535      Barry Miller        Joseph Cali  
549    William Prince      Bill McKinney  

[12 rows x 30 columns]
---------- 1978 ----------
                         title    title_type               genre  runtime  \
65        Same Time, Next Year  Feature Film               Drama    119.0   
205  Every Which Way But Loose  Feature Film  Action & Adventure    114.0   
264             The Wild Geese  Feature Film               Drama    134.0   
488     I Wanna Hold Your Hand  Feature Film               Drama    104.0   
557                     Jaws 2  Feature Film  Action & Adventure    116.0   

    mpaa_rating                    studio  thtr_rel_year  thtr_rel_month  \
65           PG        Universal Pictures           1978              11   
205          PG     Warner Bros. Pictures           1978              12   
264           R       Tango Entertainment           1978              11   
488          PG                 Universal           1978               1   
557          PG  MCA Universal Home Video           1978               6   

     thtr_rel_day  dvd_rel_year  ...  best_actor_win  best_actress_win  \
65             22        2004.0  ...              no               yes   
205            20        2002.0  ...              no                no   
264            11        2005.0  ...              no                no   
488             1        2004.0  ...              no                no   
557            16        2001.0  ...              no                no   

     best_dir_win  top200_box            director          actor1  \
65             no          no     Robert Mulligan   Ellen Burstyn   
205            no          no         James Fargo  Clint Eastwood   
264            no          no  Andrew V. McLaglen  Richard Burton   
488           yes          no     Robert Zemeckis     Nancy Allen   
557            no          no      Jeannot Szwarc    Roy Scheider   

             actor2           actor3                actor4             actor5  
65        Alan Alda       Ivan Bonar           Bernie Kuby        Cosmo Sardo  
205    Sondra Locke   Geoffrey Lewis      Beverly D'Angelo        Ruth Gordon  
264  Richard Harris      Roger Moore          Hardy Kruger    Stewart Granger  
488  Bobby Di Cicco     Marc McClure  Susan Kendall Newman  Wendie Jo Sperber  
557   Lorraine Gary  Murray Hamilton        Joseph Mascolo        Joe Mascolo  

[5 rows x 30 columns]
---------- 1979 ----------
                         title    title_type               genre  runtime  \
69   Rock 'n' Roll High School  Feature Film              Comedy     93.0   
237         The Black Stallion  Feature Film  Action & Adventure    118.0   
351           A Little Romance  Feature Film               Drama    110.0   
378                     Meteor  Feature Film               Drama    108.0   
381                       1941  Feature Film  Action & Adventure    118.0   
543              Over the Edge  Feature Film               Drama     95.0   

    mpaa_rating                                    studio  thtr_rel_year  \
69           PG                        New World Pictures           1979   
237           G  Twentieth Century Fox Home Entertainment           1979   
351          PG                  WARNER BROTHERS PICTURES           1979   
378          PG           American International Pictures           1979   
381          PG                  MCA Universal Home Video           1979   
543          PG                  WARNER BROTHERS PICTURES           1979   

     thtr_rel_month  thtr_rel_day  dvd_rel_year  ...  best_actor_win  \
69                8             4        1999.0  ...              no   
237              10            17        1997.0  ...              no   
351               4            27        2003.0  ...             yes   
378              10            19        2000.0  ...              no   
381              12            14        1999.0  ...              no   
543               1             1        2005.0  ...              no   

     best_actress_win  best_dir_win  top200_box          director  \
69                 no            no          no      Allan Arkush   
237                no            no          no   Carroll Ballard   
351                no           yes          no   George Roy Hill   
378                no            no          no      Ronald Neame   
381                no           yes          no  Steven Spielberg   
543                no            no          no   Jonathan Kaplan   

                  actor1              actor2              actor3  \
69            P.J. Soles  Vincent Van Patten        Clint Howard   
237           Kelly Reno       Mickey Rooney           Teri Garr   
351     Laurence Olivier          Diane Lane  Thelonious Bernard   
378         Sean Connery        Natalie Wood         Karl Malden   
381          Dan Aykroyd          Ned Beatty        John Belushi   
543  Michael Eric Kramer       Pamela Ludwig         Matt Dillon   

                actor4           actor5  
69           Dey Young     Loren Lester  
237      Clarence Muse       Hoyt Axton  
351  Thelonius Bernard      Arthur Hill  
378        Brian Keith    Martin Landau  
381      Lorraine Gary  Murray Hamilton  
543      Vincent Spano     Debbie James  

[6 rows x 30 columns]
---------- 1980 ----------
                                                 title    title_type  \
127  The Ninth Configuration (Twinkle, Twinkle, Kil...  Feature Film   
146         North Sea Hijack (ffolkes) (Assault Force)  Feature Film   
160                                       Terror Train  Feature Film   
289                                             Maniac  Feature Film   
294                                          Alligator  Feature Film   
403                                           Brubaker  Feature Film   
462                                           Galaxina  Feature Film   
463                                   Oh, God! Book II  Feature Film   
556                                            Zombi 2  Feature Film   
576                                    The Big Red One  Feature Film   

                         genre  runtime mpaa_rating  \
127                      Drama    118.0           R   
146         Action & Adventure    100.0          PG   
160                     Horror     97.0           R   
289                      Drama     87.0           R   
294  Science Fiction & Fantasy     91.0           R   
403                      Drama    131.0           R   
462  Science Fiction & Fantasy     95.0           R   
463                     Comedy     94.0          PG   
556                     Horror     91.0           R   
576                      Drama    113.0          PG   

                                studio  thtr_rel_year  thtr_rel_month  \
127                       Warner Bros.           1980               2   
146       Cinema Seven Productions Ltd           1980               4   
160  20th Century Fox Film Corporation           1980               1   
289                           Analysis           1980               1   
294                            Group 1           1980               1   
403  20th Century Fox Film Corporation           1980               6   
462       Crown International Pictures           1980               6   
463           WARNER BROTHERS PICTURES           1980              10   
556       The Jerry Gross Organization           1980               7   
576                     United Artists           1980               5   

     thtr_rel_day  dvd_rel_year  ...  best_actor_win  best_actress_win  \
127            29        2002.0  ...              no                no   
146            18        2003.0  ...              no                no   
160             1        2004.0  ...              no                no   
289             1        1998.0  ...              no                no   
294             1        2007.0  ...              no                no   
403            20        2003.0  ...              no                no   
462             6        2000.0  ...              no                no   
463             3        2005.0  ...              no                no   
556            18        1998.0  ...              no                no   
576            28        1999.0  ...             yes                no   

     best_dir_win  top200_box              director          actor1  \
127            no          no  William Peter Blatty     Stacy Keach   
146            no          no    Andrew V. McLaglen     Roger Moore   
160            no          no    Roger Spottiswoode     Ben Johnson   
289            no          no        William Lustig     Joe Spinell   
294            no          no          Lewis Teague  Robert Forster   
403            no          no      Stuart Rosenberg  Robert Redford   
462            no          no         William Sachs   Stephen Macht   
463            no          no         Gilbert Cates    George Burns   
556            no          no           Lucio Fulci     Tisa Farrow   
576            no          no         Samuel Fuller      Lee Marvin   

                actor2                  actor3              actor4  \
127       Scott Wilson            Jason Miller         Ed Flanders   
146        James Mason         Anthony Perkins       Michael Parks   
160   Jamie Lee Curtis       David Copperfield        Hart Bochner   
289     Caroline Munro           Gail Lawrence         Kelly Piper   
294        Robin Riker  Michael Vincente Gazzo          Perry Lang   
403       Yaphet Kotto          Jane Alexander     Murray Hamilton   
462   Dorothy Stratten         Avery Schreiber  James David Hinton   
463  Suzanne Pleshette          Tracy Richards        David Birney   
556      Ian McCulloch         Richard Johnson           Al Cliver   
576        Mark Hamill        Robert Carradine      Bobby Di Cicco   

               actor5  
127     Neville Brand  
146     David Hedison  
160    Derek McKinnon  
289      Rita Montone  
294       Jack Carter  
403       David Keith  
462  Ronald J. Knight  
463           Louanne  
556       Arnette Gay  
576        Kelly Ward  

[10 rows x 30 columns]
---------- 1981 ----------
                              title    title_type               genre  \
11                      Superman II  Feature Film  Action & Adventure   
196                         Caveman  Feature Film  Action & Adventure   
202                    Knightriders  Feature Film               Drama   
412                         Ragtime  Feature Film               Drama   
466            My Dinner with Andre  Feature Film               Drama   
496     Mad Max 2: The Road Warrior  Feature Film  Action & Adventure   
513                            Taps  Feature Film               Drama   
545  The Postman Always Rings Twice  Feature Film  Mystery & Suspense   
552                  On Golden Pond  Feature Film               Drama   
573                       Condorman  Feature Film  Action & Adventure   
590               Eye of the Needle  Feature Film               Drama   

     runtime mpaa_rating                                    studio  \
11     127.0          PG                     Warner Bros. Pictures   
196     91.0          PG                                       NaN   
202    146.0           R                      Laurel Entertainment   
412    155.0          PG                        Paramount Pictures   
466    110.0          PG                          New Yorker Films   
496     95.0           R                     Warner Bros. Pictures   
513    126.0          PG         20th Century Fox Film Corporation   
545    122.0          PG                         Warner Home Video   
552    109.0          PG  Twentieth Century Fox Home Entertainment   
573     90.0          PG                   Walt Disney Productions   
590    112.0           R                    MGM Home Entertainment   

     thtr_rel_year  thtr_rel_month  thtr_rel_day  dvd_rel_year  ...  \
11            1981               6            19        2001.0  ...   
196           1981               4            17        2002.0  ...   
202           1981               1             1        2000.0  ...   
412           1981              11            20        2004.0  ...   
466           1981              10            11        2001.0  ...   
496           1981              12            24        1997.0  ...   
513           1981              12             9        2002.0  ...   
545           1981               3            20        1997.0  ...   
552           1981              12             4        2001.0  ...   
573           1981               8             7        1999.0  ...   
590           1981               7            24        2001.0  ...   

     best_actor_win  best_actress_win  best_dir_win  top200_box  \
11              yes                no            no         yes   
196              no                no            no          no   
202              no                no            no          no   
412             yes                no            no          no   
466              no                no            no          no   
496              no                no            no          no   
513             yes                no            no          no   
545             yes               yes            no          no   
552             yes               yes            no         yes   
573              no                no            no          no   
590              no                no            no          no   

             director             actor1              actor2           actor3  \
11     Richard Lester  Christopher Reeve        Gene Hackman    Margot Kidder   
196     Carl Gottlieb        Ringo Starr        Dennis Quaid     Shelley Long   
202  George A. Romero          Ed Harris          Gary Lahti       Tom Savini   
412      Milos Forman       James Cagney  Elizabeth McGovern      Brad Dourif   
466       Louis Malle       Jean Lenauer          Roy Butler    Andre Gregory   
496     George Miller         Mel Gibson        Bruce Spence     Vernon Wells   
513     Harold Becker     Timothy Hutton     George C. Scott        Ronny Cox   
545      Bob Rafelson     Jack Nicholson       Jessica Lange     John Colicos   
552       Mark Rydell        Henry Fonda   Katharine Hepburn       Jane Fonda   
573   Charles Jarrott   Michael Crawford         Oliver Reed  Barbara Carrera   
590  Richard Marquand  Donald Sutherland       Kate Nelligan       Ian Bannen   

             actor4              actor5  
11       Ned Beatty       Jackie Cooper  
196    Jack Gilford       John Matuszak  
202   Amy Ingersoll    Patricia Tallman  
412      Moses Gunn    Kenneth McMillan  
466   Wallace Shawn                 NaN  
496      Emil Minty        Mike Preston  
513       Sean Penn          Tom Cruise  
545    John P. Ryan      Michael Lerner  
552  Dabney Coleman         Doug McKeon  
573   James Hampton  Jean-Pierre Kalfon  
590   George Belbin    Stephen MacKenna  

[11 rows x 30 columns]
---------- 1982 ----------
                             title    title_type               genre  runtime  \
265     The Slumber Party Massacre  Feature Film              Horror     77.0   
342                        Missing  Feature Film  Mystery & Suspense    122.0   
410                          Diner  Feature Film               Drama    110.0   
579  Amityville II: The Possession  Feature Film              Horror    104.0   
593      Dead Men Don't Wear Plaid  Feature Film  Mystery & Suspense     88.0   

    mpaa_rating                           studio  thtr_rel_year  \
265           R  New Concorde Home Entertainment           1982   
342          PG               Universal Pictures           1982   
410           R           MGM Home Entertainment           1982   
579           R                              MGM           1982   
593          PG               Universal Pictures           1982   

     thtr_rel_month  thtr_rel_day  dvd_rel_year  ...  best_actor_win  \
265              11            12        2000.0  ...              no   
342               2            12        2004.0  ...             yes   
410               4             2        2000.0  ...              no   
579               9            24        2005.0  ...              no   
593               5            21        1999.0  ...              no   

     best_actress_win  best_dir_win  top200_box          director  \
265                no            no          no  Amy Holden Jones   
342               yes            no          no      Costa-Gavras   
410                no           yes          no    Barry Levinson   
579                no            no          no   Damiano Damiani   
593                no            no          no       Carl Reiner   

               actor1        actor2           actor3          actor4  \
265  Michele Michaels  Robin Stille  Michael Villela    Andre Honore   
342       Jack Lemmon  Sissy Spacek        John Shea  Melanie Mayron   
410  Steve Guttenberg  Daniel Stern    Mickey Rourke     Kevin Bacon   
579        Burt Young  Rutanya Alda      James Olson     Jack Magner   
593      Steve Martin   Rachel Ward     Reni Santoni     Carl Reiner   

             actor5  
265       Joe Dante  
342  Charles Cioffi  
410        Tim Daly  
579  Diane Franklin  
593   George Gaynes  

[5 rows x 30 columns]
---------- 1983 ----------
                         title    title_type               genre  runtime  \
70   Twilight Zone---The Movie  Feature Film              Horror    101.0   
76                Strange Brew  Feature Film              Comedy     90.0   
178             Never Cry Wolf  Feature Film               Drama    105.0   
319         The King of Comedy  Feature Film               Drama    109.0   
453                Sans Soleil   Documentary         Documentary    100.0   
478                 Breathless  Feature Film               Drama    100.0   
537                 Under Fire  Feature Film  Mystery & Suspense    128.0   

    mpaa_rating                      studio  thtr_rel_year  thtr_rel_month  \
70           PG       Warner Bros. Pictures           1983               6   
76            R    WARNER BROTHERS PICTURES           1983               8   
178          PG                      Disney           1983               1   
319          PG                         Fox           1983               1   
453           R        Criterion Collection           1983               2   
478           R  Orion Pictures Corporation           1983               5   
537           R               Vestron Video           1983              10   

     thtr_rel_day  dvd_rel_year  ...  best_actor_win  best_actress_win  \
70             24        2007.0  ...              no                no   
76             19        2002.0  ...              no                no   
178             1        2000.0  ...              no                no   
319             1        2002.0  ...             yes                no   
453             1        1993.0  ...              no                no   
478            13        2001.0  ...              no                no   
537            21        2001.0  ...             yes                no   

     best_dir_win  top200_box            director                actor1  \
70             no          no           Joe Dante           Dan Aykroyd   
76             no          no         Dave Thomas         Max von Sydow   
178            no          no     Carroll Ballard  Charles Martin Smith   
319           yes          no     Martin Scorsese        Robert De Niro   
453            no          no        Chris Marker        Florence Delay   
478            no          no         Jim McBride          Richard Gere   
537            no          no  Roger Spottiswoode            Nick Nolte   

                actor2               actor3          actor4  \
70        John Lithgow     Nancy Cartwright   Albert Brooks   
76         Paul Dooley        Lynne Griffin  Angus MacInnes   
178      Brian Dennehy  Zachary Ittimangnaq    Samson Jorah   
319        Jerry Lewis      Sandra Bernhard      Ed Herlihy   
453  Alexandra Stewart      Kazuko Kawakita   Hayao Shibata   
478   Valerie Kaprisky          Art Metrano    John P. Ryan   
537     Joanna Cassidy         Gene Hackman       Ed Harris   

                   actor5  
70             Vic Morrow  
76             Tom Harvey  
178          Hugh Webster  
319  Louis Polliman Brown  
453       Ichiro Hagiwara  
478        William Tepper  
537         Richard Masur  

[7 rows x 30 columns]
---------- 1984 ----------
                               title    title_type               genre  \
15                        Rhinestone  Feature Film              Comedy   
26                Oh, God! You Devil  Feature Film              Comedy   
83   The Brother from Another Planet  Feature Film               Drama   
84                   Blame It on Rio  Feature Film              Comedy   
153                         Red Dawn  Feature Film  Action & Adventure   
186                      Top Secret!  Feature Film              Comedy   
207                Beverly Hills Cop  Feature Film  Action & Adventure   
322                  Electric Dreams  Feature Film               Drama   
464                    Micki + Maude  Feature Film              Comedy   

     runtime mpaa_rating                                    studio  \
15     111.0          PG                          20th Century Fox   
26      97.0          PG                  WARNER BROTHERS PICTURES   
83     108.0           R  Twentieth Century Fox Home Entertainment   
84     100.0           R                                       MGM   
153    114.0       PG-13                                    MGM/UA   
186     90.0          PG                      Paramount Home Video   
207    105.0           R                        Paramount Pictures   
322     95.0          PG                                       MGM   
464    118.0       PG-13               Sony Pictures Entertainment   

     thtr_rel_year  thtr_rel_month  thtr_rel_day  dvd_rel_year  ...  \
15            1984               6            20        2005.0  ...   
26            1984              11             9        2005.0  ...   
83            1984               9             7        2003.0  ...   
84            1984               2            17        2001.0  ...   
153           1984               8            10        2001.0  ...   
186           1984               6             8        2002.0  ...   
207           1984              12             1        2002.0  ...   
322           1984               7            20           NaN  ...   
464           1984              12            21        2003.0  ...   

     best_actor_win  best_actress_win  best_dir_win  top200_box  \
15               no                no            no          no   
26               no                no            no          no   
83               no                no            no          no   
84               no                no            no          no   
153              no                no            no          no   
186              no                no            no          no   
207              no                no            no         yes   
322              no                no            no          no   
464              no                no            no          no   

            director            actor1              actor2  \
15   Bob Clark (III)      Dolly Parton  Sylvester Stallone   
26       Paul Bogart      George Burns            Ted Wass   
83       John Sayles        Joe Morton      Darryl Edwards   
84     Stanley Donen     Michael Caine    Michelle Johnson   
153      John Milius    Patrick Swayze    C. Thomas Howell   
186     David Zucker        Val Kilmer         Omar Sharif   
207     Martin Brest      Eddie Murphy      Judge Reinhold   
322     Steve Barron  Lenny Von Dohlen     Virginia Madsen   
464    Blake Edwards      Dudley Moore          Amy Irving   

                 actor3                actor4          actor5  
15   Richard Farnsworth           Ron Leibman   Tim Thomerson  
26         Roxanne Hart          Eugene Roche  John Doolittle  
83          Steve James       Leonard Jackson      Bill Cobbs  
84       Joseph Bologna        Valerie Harper      Demi Moore  
153          Ron O'Neal          Lea Thompson   Jennifer Grey  
186     Lucy Gutteridge  Christopher Villiers   Peter Cushing  
207         John Ashton        Lisa Eilbacher   Lisa Eichhorn  
322   Maxwell Caulfield              Bud Cort     Don Fellows  
464        Ann Reinking      Richard Mulligan   George Gaynes  

[9 rows x 30 columns]
---------- 1985 ----------
                                                 title    title_type  \
42                                    The Color Purple  Feature Film   
151  Flesh & Blood (Flesh+Blood) (The Rose and the ...  Feature Film   
281                                   The Heavenly Kid  Feature Film   
299                                     The Sure Thing  Feature Film   
404                                        Jagged Edge  Feature Film   

                  genre  runtime mpaa_rating             studio  \
42                Drama    154.0       PG-13  Warner Home Video   
151               Drama    126.0           R                MGM   
281               Drama     90.0       PG-13              Orion   
299              Comedy    100.0       PG-13            Embassy   
404  Mystery & Suspense    108.0           R  Columbia Pictures   

     thtr_rel_year  thtr_rel_month  thtr_rel_day  dvd_rel_year  ...  \
42            1985              12            16        2003.0  ...   
151           1985               8            30        2004.0  ...   
281           1985               7            26        2005.0  ...   
299           1985               3             1        2003.0  ...   
404           1985              10             4        2000.0  ...   

     best_actor_win  best_actress_win  best_dir_win  top200_box  \
42               no                no           yes          no   
151              no                no            no          no   
281              no                no            no          no   
299              no                no            no          no   
404             yes                no            no          no   

             director           actor1                actor2           actor3  \
42   Steven Spielberg  Whoopi Goldberg          Danny Glover   Margaret Avery   
151    Paul Verhoeven     Rutger Hauer  Jennifer Jason Leigh    Tom Burlinson   
281      Cary Medoway      Lewis Smith      Richard Mulligan    Jason Gedrick   
299        Rob Reiner      John Cusack         Daphne Zuniga  Anthony Edwards   
404  Richard Marquand      Glenn Close          Jeff Bridges     Peter Coyote   

             actor4            actor5  
42    Oprah Winfrey   Willard E. Pugh  
151   Jack Thompson     Susan Tyrrell  
281  Jane Kaczmarek      Mark Metcalf  
299     Boyd Gaines  Lisa Jane Persky  
404   Robert Loggia       John Dehner  

[5 rows x 30 columns]
---------- 1986 ----------
                                  title    title_type               genre  \
7                             Lady Jane  Feature Film               Drama   
36                               Aliens  Feature Film  Action & Adventure   
126                     Sherman's March   Documentary         Documentary   
170                             Top Gun  Feature Film               Drama   
173                     Streets of Gold  Feature Film               Drama   
266                            No Mercy  Feature Film               Drama   
270  Henry: Portrait of a Serial Killer  Feature Film               Drama   
310                              Nomads  Feature Film               Drama   
539                       Sweet Liberty  Feature Film              Comedy   

     runtime mpaa_rating                            studio  thtr_rel_year  \
7      142.0       PG-13              Paramount Home Video           1986   
36     137.0           R    20th Century Fox Film Corporat           1986   
126    157.0     Unrated                First Run Features           1986   
170    110.0          PG                Paramount Pictures           1986   
173     95.0           R                   Live Home Video           1986   
266    106.0           R  Sony Pictures Home Entertainment           1986   
270     83.0       NC-17                     GreyCat Films           1986   
310     91.0           R              Paramount Home Video           1986   
539    106.0          PG          MCA Universal Home Video           1986   

     thtr_rel_month  thtr_rel_day  dvd_rel_year  ...  best_actor_win  \
7                 1             1        2003.0  ...              no   
36                7            18        1999.0  ...              no   
126               9             5        2004.0  ...              no   
170               5            16        1998.0  ...              no   
173              11            14           NaN  ...              no   
266              12            19        2001.0  ...              no   
270               9            24        1998.0  ...              no   
310               3             7        2002.0  ...              no   
539               5            14        2004.0  ...              no   

     best_actress_win  best_dir_win  top200_box         director  \
7                  no            no          no      Trevor Nunn   
36                 no           yes          no    James Cameron   
126                no            no          no     Ross McElwee   
170                no            no         yes       Tony Scott   
173                no            no          no         Joe Roth   
266                no            no          no   Richard Pearce   
270                no            no          no  John McNaughton   
310                no            no          no   John McTiernan   
539                no            no          no        Alan Alda   

                    actor1            actor2                 actor3  \
7               Cary Elwes         John Wood        Michael Hordern   
36        Sigourney Weaver       Carrie Henn          Michael Biehn   
126       Charleen Swansea   Richard Leacock          Burt Reynolds   
170             Tom Cruise    Kelly McGillis        Anthony Edwards   
173  Klaus Maria Brandauer     Adrian Pasdar         Richard Pasdar   
266           Richard Gere      Kim Basinger          Jeroen Krabbe   
270         Michael Rooker        Tom Towles           Tracy Arnold   
310         Pierce Brosnan  Lesley-Anne Down  Anna Maria Monticelli   
539              Alan Alda     Michael Caine      Michelle Pfeiffer   

               actor4                actor5  
7     Jill Bennett II  Helena Bonham Carter  
36        Paul Reiser           Bill Paxton  
126  Charleen Swansea          Ross McElwee  
170        Val Kilmer          Tom Skerritt  
173     Wesley Snipes         Angela Molina  
266    George Dzundza         Gary Basaraba  
270     Tracey Arnold            Mary Demas  
310          Adam Ant        Hector Mercado  
539       Bob Hoskins         Lise Hilboldt  

[9 rows x 30 columns]
---------- 1987 ----------
                                          title    title_type  \
86                                     Predator  Feature Film   
90                                The Principal  Feature Film   
220                               Lethal Weapon  Feature Film   
246                                 The Squeeze  Feature Film   
271                    Someone to Watch over Me  Feature Film   
292                                     Maurice  Feature Film   
296                                     RoboCop  Feature Film   
350                               Teen Wolf Too  Feature Film   
357                      A Prayer for the Dying  Feature Film   
387  Revenge of the Nerds II: Nerds in Paradise  Feature Film   
394                   The Belly of an Architect  Feature Film   
445                                  Moonstruck  Feature Film   
508                                River's Edge  Feature Film   
514              Planes, Trains and Automobiles  Feature Film   

                         genre  runtime mpaa_rating  \
86          Action & Adventure    107.0           R   
90                       Drama    109.0           R   
220                      Drama    110.0           R   
246         Action & Adventure    101.0       PG-13   
271                      Drama    106.0           R   
292                      Drama    140.0           R   
296                      Drama    102.0           R   
350  Science Fiction & Fantasy     95.0          PG   
357                      Drama    107.0           R   
387                     Comedy     88.0       PG-13   
394                      Drama    119.0           R   
445                      Drama    102.0          PG   
508                      Drama     99.0           R   
514                     Comedy     93.0           R   

                                       studio  thtr_rel_year  thtr_rel_month  \
86                           20th Century Fox           1987               6   
90           Sony Pictures Home Entertainment           1987               9   
220                     Warner Bros. Pictures           1987               3   
246                                 HBO Video           1987               7   
271          Sony Pictures Home Entertainment           1987              10   
292                        Lorimar Home Video           1987               9   
296                Orion Pictures Corporation           1987               7   
350                      Paramount Home Video           1987              11   
357                             Virgin Vision           1987               9   
387  Twentieth Century Fox Home Entertainment           1987               7   
394                                   Hemdale           1987               1   
445                    MGM Home Entertainment           1987              12   
508                                    Island           1987               5   
514                        Paramount Pictures           1987              11   

     thtr_rel_day  dvd_rel_year  ...  best_actor_win  best_actress_win  \
86             12        2000.0  ...              no                no   
90             18        2002.0  ...              no                no   
220             6        2000.0  ...              no                no   
246            10           NaN  ...              no                no   
271             9        2001.0  ...              no                no   
292             1        2004.0  ...              no                no   
296            17        2001.0  ...              no                no   
350            20           NaN  ...              no                no   
357             1        2003.0  ...              no                no   
387            10        2007.0  ...              no                no   
394             1        2004.0  ...              no                no   
445            18        1998.0  ...             yes               yes   
508             8        2001.0  ...              no                no   
514            25        2000.0  ...              no                no   

     best_dir_win  top200_box            director                 actor1  \
86             no          no         Shane Black  Arnold Schwarzenegger   
90             no          no    Christopher Cain          James Belushi   
220            no          no      Richard Donner             Mel Gibson   
246            no          no         Roger Young         Michael Keaton   
271            no          no        Ridley Scott           Tom Berenger   
292            no          no         James Ivory            James Wilby   
296            no          no      Paul Verhoeven           Peter Weller   
350            no          no  Christopher Leitch          Jason Bateman   
357            no          no         Mike Hodges          Mickey Rourke   
387            no          no            Joe Roth       Robert Carradine   
394            no          no     Peter Greenaway          Brian Dennehy   
445            no          no      Norman Jewison                   Cher   
508            no          no          Tim Hunter         Crispin Glover   
514            no          no         John Hughes           Steve Martin   

                    actor2            actor3            actor4  \
86           Carl Weathers  Elpidia Carrillo         Bill Duke   
90          Michael Wright  Louis Gossett Jr    Rae Dawn Chong   
220           Danny Glover        Gary Busey      Darlene Love   
246         Rae Dawn Chong         Meat Loaf     John Davidson   
271            Mimi Rogers   Lorraine Bracco      Jerry Orbach   
292             Hugh Grant     Rupert Graves   Denholm Elliott   
296            Nancy Allen         Ronny Cox    Kurtwood Smith   
350              Kim Darby        John Astin    Estee Chandler   
357            Bob Hoskins        Alan Bates       Sammi Davis   
387  Courtney Thorne-Smith  Curtis Armstrong    Larry B. Scott   
394             Chloe Webb    Lambert Wilson    Sergio Fantoni   
445           Nicolas Cage   Olympia Dukakis  Fyodor Chaliapin   
508          Dennis Hopper      Keanu Reeves    Daniel Roebuck   
514             John Candy    William Windom    Michael McKean   

                  actor5  
86         Jesse Ventura  
90          Esai Morales  
220        Mitchell Ryan  
246        Ric Abernathy  
271      John Rubinstein  
292         Simon Callow  
296        Miguel Ferrer  
350            Paul Sand  
357  Christopher Fulford  
387     Timothy Busfield  
394     Vanni Corbellini  
445     Vincent Gardenia  
508            Ione Skye  
514         Edie McClurg  

[14 rows x 30 columns]
---------- 1988 ----------
                                                 title    title_type  \
63                                  The Thin Blue Line   Documentary   
89                                           Shakedown  Feature Film   
91                                          A New Life  Feature Film   
96                                              Prison  Feature Film   
218  Hotel Terminus: The Life and Times of Klaus Ba...   Documentary   
253                                         Funny Farm  Feature Film   
323                                        Bull Durham  Feature Film   
502                                          Punchline  Feature Film   
538                                          Hairspray  Feature Film   
595                                 Cocoon: The Return  Feature Film   

           genre  runtime mpaa_rating                            studio  \
63   Documentary    103.0     Unrated                         HBO Video   
89         Drama     97.0           R          MCA Universal Home Video   
91         Drama    104.0       PG-13                Paramount Pictures   
96         Drama    102.0           R                   New World Video   
218  Documentary    267.0     Unrated                         SnagFilms   
253       Comedy    101.0          PG                 Warner Home Video   
323        Drama    108.0           R                    Orion Pictures   
502        Drama    128.0           R  Sony Pictures Home Entertainment   
538        Drama     92.0          PG       New Line Home Entertainment   
595        Drama    116.0          PG                               Fox   

     thtr_rel_year  thtr_rel_month  thtr_rel_day  dvd_rel_year  ...  \
63            1988               8            25        2005.0  ...   
89            1988               5             6        1998.0  ...   
91            1988               3            25        2013.0  ...   
96            1988               3             4        2013.0  ...   
218           1988              11             1        2010.0  ...   
253           1988               6             3        1999.0  ...   
323           1988               6            15        1998.0  ...   
502           1988               9            30        2002.0  ...   
538           1988               2            26        2002.0  ...   
595           1988              11            23        2004.0  ...   

     best_actor_win  best_actress_win  best_dir_win  top200_box  \
63               no                no            no          no   
89               no                no            no          no   
91               no                no            no          no   
96               no                no            no          no   
218              no                no            no          no   
253              no                no           yes          no   
323              no               yes            no          no   
502             yes               yes            no          no   
538              no                no            no          no   
595              no                no            no          no   

              director           actor1                 actor2  \
63        Errol Morris     Derek Horton          Ron Thornhill   
89   James Glickenhaus      Sam Elliott           Peter Weller   
91           Alan Alda        Alan Alda            Ann-Margret   
96        Renny Harlin       Lane Smith        Viggo Mortensen   
218      Marcel Ophuls  Claude Lanzmann          Jeanne Moreau   
253    George Roy Hill      Chevy Chase  Madolyn Smith Osborne   
323        Ron Shelton    Kevin Costner         Susan Sarandon   
502      David Seltzer        Tom Hanks            Sally Field   
538        John Waters           Divine             Ricki Lake   
595      Daniel Petrie       Don Ameche        Wilford Brimley   

                       actor3            actor4               actor5  
63             Marianne Leone     Amanda Caprio       Michael Nicoll  
89       Patricia Charbonneau     Blanche Baker  Richard Brooks (VI)  
91             Mary Kay Place         John Shea           Hal Linden  
96              Chelsea Field  Andre De Shields   Lincoln Kilpatrick  
218  Johannes Schneider-Merck      Klaus Barbie         Marcel Cruat  
253          Kevin O'Morrison      Joseph Maher          Jack Gilpin  
323               Tim Robbins       Trey Wilson          Robert Wuhl  
502              John Goodman       Mark Rydell        Paul Mazursky  
538                Sonny Bono        Ruth Brown            Vitamin C  
595               Hume Cronyn      Jack Gilford     Steve Guttenberg  

[10 rows x 30 columns]
---------- 1989 ----------
                                title    title_type               genre  \
37                 Driving Miss Daisy  Feature Film               Drama   
43                     The Dream Team  Feature Film              Comedy   
57                        The Package  Feature Film  Mystery & Suspense   
64                  Lord of the Flies  Feature Film               Drama   
103  Star Trek V - The Final Frontier  Feature Film  Action & Adventure   
105                           Cousins  Feature Film               Drama   
305                        Clownhouse  Feature Film              Horror   
375                           Valmont  Feature Film               Drama   
423                             Glory  Feature Film               Drama   
441         See No Evil, Hear No Evil  Feature Film  Action & Adventure   
572               Great Balls of Fire  Feature Film               Drama   

     runtime mpaa_rating                            studio  thtr_rel_year  \
37      99.0          PG                     Fathom Events           1989   
43     113.0       PG-13          MCA Universal Home Video           1989   
57     108.0           R                  Orion Home Video           1989   
64      90.0           R              Nelson Entertainment           1989   
103    107.0          PG                Paramount Pictures           1989   
105    109.0       PG-13              Paramount Home Video           1989   
305     81.0           R  Sony Pictures Home Entertainment           1989   
375    137.0           R                  Orion Home Video           1989   
423    122.0           R                           TriStar           1989   
441    103.0           R  Sony Pictures Home Entertainment           1989   
572    108.0       PG-13        Orion Pictures Corporation           1989   

     thtr_rel_month  thtr_rel_day  dvd_rel_year  ...  best_actor_win  \
37                6             1        1997.0  ...              no   
43                4             7        2003.0  ...              no   
57                8            25        2001.0  ...             yes   
64                1             1        2001.0  ...              no   
103               6             9        1999.0  ...              no   
105               1             1        2002.0  ...              no   
305               6             1        2003.0  ...              no   
375              11             1        2002.0  ...             yes   
423              12            15        1998.0  ...             yes   
441               5            12        2001.0  ...             yes   
572               6            30        2002.0  ...              no   

     best_actress_win  best_dir_win  top200_box         director  \
37                yes            no          no  Bruce Beresford   
43                 no            no          no     Howard Zieff   
57                 no            no          no     Andrew Davis   
64                 no            no          no       Harry Hook   
103                no            no          no  William Shatner   
105                no            no          no  Joel Schumacher   
305                no            no          no     Victor Salva   
375                no            no          no     Milos Forman   
423                no            no          no     Edward Zwick   
441                no            no          no    Arthur Hiller   
572                no            no          no      Jim McBride   

                     actor1                 actor2           actor3  \
37            Jessica Tandy         Morgan Freeman      Dan Aykroyd   
43           Michael Keaton      Christopher Lloyd      Peter Boyle   
57             Gene Hackman         Joanna Cassidy  Tommy Lee Jones   
64          Balthazar Getty            Chris Furrh    Danuel Pipoly   
103         William Shatner          Leonard Nimoy  DeForest Kelley   
105              Ted Danson    Isabella Rossellini       Sean Young   
305  Nathan Forrest Winters  Nathan Forest Winters     Brian McHugh   
375             Colin Firth         Annette Bening        Meg Tilly   
423       Matthew Broderick      Denzel Washington       Cary Elwes   
441           Richard Pryor            Gene Wilder   Joan Severance   
572            Dennis Quaid           Winona Ryder         John Doe   

                  actor4              actor5  
37          Patti LuPone        Esther Rolle  
43         Stephen Furst  Dennis Boutsikaris  
57            John Heard       Kevin Crowley  
64      James Badge Dale           Gary Rule  
103         James Doohan       Walter Koenig  
105  William L. Petersen       Lloyd Bridges  
305         Sam Rockwell                Tree  
375         Fairuza Balk       Sian Phillips  
423       Morgan Freeman      Andre Braugher  
441         Kevin Spacey          Alan North  
572   Stephen Tobolowsky        Alec Baldwin  

[11 rows x 30 columns]
---------- 1990 ----------
                                            title    title_type  \
31                                     Die Hard 2  Feature Film   
77                                      Robocop 2  Feature Film   
128                             Mr. & Mrs. Bridge  Feature Film   
144                                  The Freshman  Feature Film   
161  Leatherface: The Texas Chainsaw Massacre III  Feature Film   
168                                  Santa Sangre  Feature Film   
175                            Where the Heart Is  Feature Film   
247                              Kindergarten Cop  Feature Film   
370                            Longtime Companion  Feature Film   
570                        The Unbelievable Truth  Feature Film   

                  genre  runtime mpaa_rating  \
31   Mystery & Suspense    124.0           R   
77   Action & Adventure    117.0           R   
128               Drama    126.0       PG-13   
144               Drama    102.0          PG   
161              Horror     85.0           R   
168               Drama    123.0           R   
175               Drama    107.0           R   
247  Action & Adventure    111.0       PG-13   
370               Drama     96.0           R   
570               Drama     90.0           R   

                               studio  thtr_rel_year  thtr_rel_month  \
31                   20th Century Fox           1990               7   
77                                MGM           1990               6   
128                     Miramax Films           1990              11   
144  Sony Pictures Home Entertainment           1990               7   
161  Sony Pictures Home Entertainment           1990               1   
168      Republic Pictures Home Video           1990               6   
175               Touchstone Pictures           1990               1   
247          MCA Universal Home Video           1990              12   
370            Samuel Goldwyn Company           1990               5   
570                           Trimark           1990               6   

     thtr_rel_day  dvd_rel_year  ...  best_actor_win  best_actress_win  \
31              2        1999.0  ...              no                no   
77             22        1997.0  ...              no                no   
128            23        2001.0  ...             yes               yes   
144            20        1998.0  ...             yes                no   
161            12        2003.0  ...              no                no   
168             1        1991.0  ...              no                no   
175             1        2003.0  ...              no                no   
247            21        1998.0  ...              no                no   
370            11        2001.0  ...              no                no   
570             1        2001.0  ...              no                no   

     best_dir_win  top200_box              director                 actor1  \
31             no          no          Renny Harlin           Bruce Willis   
77             no          no        Irvin Kershner           Peter Weller   
128            no          no           James Ivory            Paul Newman   
144            no          no        Andrew Bergman          Marlon Brando   
161            no          no             Jeff Burr             Kate Hodge   
168            no          no  Alejandro Jodorowsky      Sergio Bustamante   
175            no          no          John Boorman         Dabney Coleman   
247            no          no          Ivan Reitman  Arnold Schwarzenegger   
370            no          no           Norman Rene          Bruce Davison   
570            no          no           Hal Hartley        Adrienne Shelly   

                  actor2            actor3               actor4  \
31        Bonnie Bedelia  William Atherton  Reginald VelJohnson   
77         Dan O'Herlihy       Nancy Allen         Felton Perry   
128      Joanne Woodward     Blythe Danner  Robert Sean Leonard   
144    Matthew Broderick       Bruno Kirby  Penelope Ann Miller   
161            Ken Foree   Viggo Mortensen       R.A. Mihailoff   
168      Adan Jodorowsky      Jesus Juarez      Axel Jodorowsky   
175          Uma Thurman    Joanna Cassidy       Crispin Glover   
247  Penelope Ann Miller       Pamela Reed           Linda Hunt   
370           Mark Lamos    Campbell Scott      Stephen Caffrey   
570    Robert John Burke       Chris Cooke    Christopher Cooke   

                  actor5  
31           Franco Nero  
77         Belinda Bauer  
128        Kyra Sedgwick  
144         Frank Whaley  
161  Miriam Byrd-Nethery  
168        Guy Stockwell  
175            Suzy Amis  
247        Richard Tyson  
370      Patrick Cassidy  
570         Julia McNeal  

[10 rows x 30 columns]
---------- 1991 ----------
                        title    title_type               genre  runtime  \
17                  The Doors  Feature Film               Drama    140.0   
24    Not Without My Daughter  Feature Film               Drama    116.0   
147                Texasville  Feature Film               Drama    123.0   
206         Strictly Business  Feature Film               Drama     83.0   
221               Closet Land  Feature Film  Mystery & Suspense     89.0   
227              Class Action  Feature Film  Mystery & Suspense    110.0   
228  The Pit and the Pendulum  Feature Film              Horror     97.0   
293        The Last Boy Scout  Feature Film               Drama    105.0   
343               Point Break  Feature Film  Mystery & Suspense    122.0   
414             Rambling Rose  Feature Film               Drama    112.0   
422           V.I. Warshawski  Feature Film               Drama     89.0   
470               Naked Lunch  Feature Film               Drama    115.0   
522           What About Bob?  Feature Film               Drama     99.0   

    mpaa_rating                                    studio  thtr_rel_year  \
17            R          Sony Pictures Home Entertainment           1991   
24        PG-13                    MGM Home Entertainment           1991   
147           R                               Cine-Source           1991   
206       PG-13                         Warner Home Video           1991   
221           R                  Media Home Entertainment           1991   
227           R  Twentieth Century Fox Home Entertainment           1991   
228           R                                       MGM           1991   
293           R                         Warner Home Video           1991   
343           R  Twentieth Century Fox Home Entertainment           1991   
414           R                           Live Home Video           1991   
422           R                        Hollywood Pictures           1991   
470           R  Twentieth Century Fox Home Entertainment           1991   
522          PG             Touchstone Home Entertainment           1991   

     thtr_rel_month  thtr_rel_day  dvd_rel_year  ...  best_actor_win  \
17                3             1        1997.0  ...              no   
24                1            11        2001.0  ...              no   
147               1             1        2002.0  ...             yes   
206              11             8        2007.0  ...              no   
221               3             6        1991.0  ...              no   
227               3            15        2005.0  ...             yes   
228               6            27        2000.0  ...              no   
293              12            13        1998.0  ...              no   
343               7            12        2001.0  ...              no   
414               9            10        1999.0  ...             yes   
422               7            26        2002.0  ...              no   
470              12            27        2003.0  ...              no   
522               1             1        2000.0  ...             yes   

     best_actress_win  best_dir_win  top200_box           director  \
17                 no           yes          no       Oliver Stone   
24                yes            no          no      Brian Gilbert   
147                no            no          no  Peter Bogdanovich   
206                no            no          no     Rolando Hudson   
221                no            no          no    Radha Bharadwaj   
227                no            no          no      Michael Apted   
228                no            no          no      Stuart Gordon   
293                no            no          no         Tony Scott   
343                no           yes          no    Kathryn Bigelow   
414                no            no          no    Martha Coolidge   
422                no            no          no         Jeff Kanew   
470                no            no          no   David Cronenberg   
522                no            no          no           Frank Oz   

              actor1                       actor2              actor3  \
17        Val Kilmer                     Meg Ryan        Kevin Dillon   
24       Sally Field                Alfred Molina    Sheila Rosenthal   
147     Jeff Bridges              Cybill Shepherd         Annie Potts   
206   Tommy Davidson           Joseph C. Phillips  Anne-Marie Johnson   
221  Madeleine Stowe                 Alan Rickman                 NaN   
227     Gene Hackman  Mary Elizabeth Mastrantonio        Colin Friels   
228  Lance Henriksen                Rona De Ricci     Jonathan Fuller   
293     Bruce Willis                 Damon Wayans       Chelsea Field   
343     Keanu Reeves               Patrick Swayze          Gary Busey   
414       Laura Dern                Robert Duvall          Diane Ladd   
422  Kathleen Turner                Jay O Sanders     Charles Durning   
470     Peter Weller                   Judy Davis            Ian Holm   
522      Bill Murray             Richard Dreyfuss       Julie Hagerty   

                   actor4              actor5  
17        Kyle MacLachlan        Frank Whaley  
24            Roshan Seth         Sarah Badel  
147       Timothy Bottoms     Cloris Leachman  
206  David Marshall Grant          Jon Cypher  
221                   NaN                 NaN  
227         Joanna Merlin  Laurence Fishburne  
228           Frances Bay       Jeffrey Combs  
293      Noble Willingham       Taylor Negron  
343            Lori Petty    John C. McGinley  
414            Lukas Haas          John Heard  
422       Angela Goethals          Nancy Paul  
470          Julian Davis        Roy Scheider  
522        Charlie Korsmo        Kathryn Erbe  

[13 rows x 30 columns]
---------- 1992 ----------
                           title    title_type                      genre  \
12                 Leap of Faith  Feature Film                      Drama   
30    The Muppet Christmas Carol  Feature Film  Science Fiction & Fantasy   
141              Of Mice and Men  Feature Film                      Drama   
162                Lorenzo's Oil  Feature Film                      Drama   
188           Night and the City  Feature Film                      Drama   
224                     Motorama  Feature Film                      Drama   
233          A Stranger Among Us  Feature Film                      Drama   
295                   Jennifer 8  Feature Film         Mystery & Suspense   
318                      Aladdin  Feature Film         Action & Adventure   
401                 Thunderheart  Feature Film                      Drama   
407                    Boomerang  Feature Film                     Comedy   
434                 The Adjuster  Feature Film                      Drama   
476  The Distinguished Gentleman  Feature Film                     Comedy   
530                 Medicine Man  Feature Film                      Drama   
571                   Article 99  Feature Film                      Drama   
583             Body of Evidence  Feature Film         Mystery & Suspense   

     runtime mpaa_rating                                    studio  \
12     108.0       PG-13                      Paramount Home Video   
30      85.0           G            Walt Disney Home Entertainment   
141    115.0       PG-13              Metro-Goldwyn-Mayer Pictures   
162    129.0       PG-13                  MCA Universal Home Video   
188    105.0           R  Twentieth Century Fox Home Entertainment   
224     90.0           R          Sony Pictures Home Entertainment   
233    110.0       PG-13                      Buena Vista Pictures   
295    124.0           R                      Paramount Home Video   
318     90.0           G            Buena Vista Distribution Compa   
401    119.0           R          Sony Pictures Home Entertainment   
407    117.0           R                        Paramount Pictures   
434    102.0           R          Alliance Atlantis Communications   
476    112.0           R                        Hollywood Pictures   
530    106.0       PG-13                        Hollywood Pictures   
571    100.0           R                          Orion Home Video   
583     99.0           R                                       MGM   

     thtr_rel_year  thtr_rel_month  thtr_rel_day  dvd_rel_year  ...  \
12            1992              12            18        2003.0  ...   
30            1992               1             1        2002.0  ...   
141           1992              10             2        2001.0  ...   
162           1992              12            30        2004.0  ...   
188           1992              10            11        1993.0  ...   
224           1992               3            28        2001.0  ...   
233           1992               1             1        2003.0  ...   
295           1992              11             6        2000.0  ...   
318           1992              11            11        2004.0  ...   
401           1992               4             1        2000.0  ...   
407           1992               7             1        2002.0  ...   
434           1992               5            29        2001.0  ...   
476           1992              12             4        1999.0  ...   
530           1992               2             7        1999.0  ...   
571           1992               3            13        2003.0  ...   
583           1992               6             1        2002.0  ...   

     best_actor_win  best_actress_win  best_dir_win  top200_box  \
12               no                no            no          no   
30               no                no            no          no   
141              no                no            no          no   
162              no               yes            no          no   
188             yes               yes            no          no   
224              no                no            no          no   
233              no                no            no          no   
295              no                no            no          no   
318              no                no            no         yes   
401              no                no            no          no   
407              no               yes            no          no   
434              no                no            no          no   
476              no                no            no          no   
530              no                no            no          no   
571             yes                no            no          no   
583              no               yes            no          no   

            director                      actor1             actor2  \
12    Richard Pearce                Steve Martin       Debra Winger   
30      Brian Henson               Michael Caine     Steve Whitmire   
141      Gary Sinise              John Malkovich        Gary Sinise   
162              NaN                  Nick Nolte     Susan Sarandon   
188    Irwin Winkler              Robert De Niro      Jessica Lange   
224      Barry Shils  Jordan Christopher Michael        Sandy Baron   
233     Sidney Lumet            Melanie Griffith          Eric Thal   
295   Bruce Robinson                 Andy Garcia        Uma Thurman   
318      John Musker              Robin Williams       Linda Larkin   
401    Michael Apted                  Val Kilmer        Sam Shepard   
407  Reginald Hudlin                Eddie Murphy       Robin Givens   
434      Atom Egoyan                Elias Koteas   Arsinee Khanjian   
476    Jonathan Lynn                Eddie Murphy         Lane Smith   
530   John McTiernan             Lorraine Bracco        Jose Wilker   
571    Howard Deutch                  Ray Liotta  Kiefer Sutherland   
583         Uli Edel                     Madonna       Willem Dafoe   

                   actor3                actor4                   actor5  
12      Lolita Davidovich           Liam Neeson               Lukas Haas  
30               Frank Oz            Dave Goelz             Jerry Nelson  
141           Ray Walston       Casey Siemaszko            Sherilyn Fenn  
162         Peter Ustinov     Kathleen Wilhoite             Gerry Bamman  
188          Cliff Gorman             Alan King              Eli Wallach  
224          Mary Woronov             Meat Loaf           Drew Barrymore  
233           John Pankow          Tracy Pollan           Lee Richardson  
295       Lance Henriksen           Kathy Baker            Graham Beckel  
318           Lea Salonga         Scott Weinger             John Freeman  
401    Graham Greene (II)             Fred Ward     Fred Dalton Thompson  
407           Halle Berry      David Alan Grier          Martin Lawrence  
434         Maury Chaykin        Gabrielle Rose            Jennifer Dale  
476      Sheryl Lee Ralph         Joe Don Baker          Victoria Rowell  
530  Rodolfo De Alexandre  Rodolfo de Alexandra  Elias Monteiro Da Silva  
571       Forest Whitaker          Lea Thompson             John Mahoney  
583          Joe Mantegna           Anne Archer           Julianne Moore  

[16 rows x 30 columns]
---------- 1993 ----------
                            title    title_type               genre  runtime  \
4            The Age of Innocence  Feature Film               Drama    139.0   
44         The Man Without a Face  Feature Film               Drama    115.0   
47                     Rising Sun  Feature Film               Drama    125.0   
55                Three of Hearts  Feature Film               Drama    102.0   
74   The Wedding Banquet (Xi yan)  Feature Film               Drama    106.0   
104                     Cop & 1/2  Feature Film              Comedy     97.0   
108             Striking Distance  Feature Film  Mystery & Suspense    102.0   
140   What's Eating Gilbert Grape  Feature Film               Drama    118.0   
182                 Married to It  Feature Film               Drama    112.0   
199                Flesh And Bone  Feature Film               Drama    126.0   
309                 Aspen Extreme  Feature Film               Drama    113.0   
313          Hot Shots! Part Deux  Feature Film  Action & Adventure     86.0   
331                  Twenty Bucks  Feature Film               Drama     91.0   
359  So I Married an Axe Murderer  Feature Film              Comedy     93.0   
385                     Mr. Jones  Feature Film               Drama    114.0   
424                     Carnosaur  Feature Film              Horror     83.0   
467                 Mother's Boys  Feature Film  Mystery & Suspense     96.0   
499             The Secret Garden  Feature Film               Drama    101.0   
553              Army of Darkness  Feature Film  Action & Adventure     81.0   
587     In the Name of the Father  Feature Film               Drama    133.0   

    mpaa_rating                                    studio  thtr_rel_year  \
4            PG                         Columbia Pictures           1993   
44        PG-13                         Warner Home Video           1993   
47            R  Twentieth Century Fox Home Entertainment           1993   
55            R          Sony Pictures Home Entertainment           1993   
74            R                              Good Machine           1993   
104          PG                  MCA Universal Home Video           1993   
108           R          Sony Pictures Home Entertainment           1993   
140       PG-13                        Paramount Pictures           1993   
182           R                          Orion Home Video           1993   
199           R                      Paramount Home Video           1993   
309       PG-13                               Buena Vista           1993   
313       PG-13  Twentieth Century Fox Home Entertainment           1993   
331           R          Sony Pictures Home Entertainment           1993   
359       PG-13                          TriStar Pictures           1993   
385           R          Sony Pictures Home Entertainment           1993   
424           R          Concorde/New Horizons Home Video           1993   
467           R                                   Miramax           1993   
499           G                  WARNER BROTHERS PICTURES           1993   
553           R                        Universal Pictures           1993   
587           R                        Universal Pictures           1993   

     thtr_rel_month  thtr_rel_day  dvd_rel_year  ...  best_actor_win  \
4                10             1        2001.0  ...             yes   
44                8            25        2004.0  ...              no   
47                7            30        2000.0  ...              no   
55                4            30        2004.0  ...              no   
74                8             4        2004.0  ...              no   
104               4             2        1999.0  ...              no   
108               9            17        2001.0  ...              no   
140              12            25        2001.0  ...              no   
182               3            26        2003.0  ...              no   
199              11             5        2002.0  ...              no   
309               1            22        2002.0  ...              no   
313               5            21        2002.0  ...              no   
331               1             1        2005.0  ...              no   
359               7            30        1999.0  ...              no   
385              10             8        2000.0  ...              no   
424               5            21        2000.0  ...              no   
467               1             1        2001.0  ...              no   
499               3            18        2000.0  ...              no   
553               2            19        2002.0  ...              no   
587              12            29        1998.0  ...             yes   

     best_actress_win  best_dir_win  top200_box           director  \
4                  no           yes          no    Martin Scorsese   
44                 no           yes          no         Mel Gibson   
47                 no            no          no     Philip Kaufman   
55                 no            no          no   Yurek Bogayevicz   
74                 no           yes          no            Ang Lee   
104                no            no          no      Henry Winkler   
108                no            no          no   Rowdy Herrington   
140                no            no          no    Lasse Hallstrom   
182                no            no          no      Arthur Hiller   
199               yes            no          no       Steve Kloves   
309                no            no          no   Patrick Hasburgh   
313                no            no          no       Jim Abrahams   
331                no            no          no     Keva Rosenfeld   
359                no            no          no    Thomas Schlamme   
385               yes            no          no        Mike Figgis   
424                no            no          no         Adam Simon   
467                no            no          no      Yves Simoneau   
499               yes            no          no  Agnieszka Holland   
553                no            no          no          Sam Raimi   
587               yes            no          no       Jim Sheridan   

               actor1               actor2                 actor3  \
4    Daniel Day-Lewis    Michelle Pfeiffer           Winona Ryder   
44         Mel Gibson           Nick Stahl       Margaret Whitton   
47       Sean Connery        Wesley Snipes          Harvey Keitel   
55    William Baldwin          Kelly Lynch          Sherilyn Fenn   
74       Winston Chao             May Chin  Mitchell Lichtenstein   
104     Burt Reynolds  Norman D. Golden II               Ruby Dee   
108      Bruce Willis         Tom Sizemore   Sarah Jessica Parker   
140       Johnny Depp    Leonardo DiCaprio         Juliette Lewis   
182      Beau Bridges    Stockard Channing    Robert Sean Leonard   
199      Dennis Quaid             Meg Ryan             James Caan   
309        Paul Gross           Peter Berg          Finola Hughes   
313     Charlie Sheen        Lloyd Bridges         Valeria Golino   
331        Linda Hunt       Brendan Fraser          Gladys Knight   
359        Mike Myers         Nancy Travis       Anthony LaPaglia   
385      Richard Gere            Lena Olin          Anne Bancroft   
424        Diane Ladd       Raphael Sbarge        Jennifer Runyon   
467  Jamie Lee Curtis      Peter Gallagher         Joanne Whalley   
499      Kate Maberly         Maggie Smith          Heydon Prowse   
553    Bruce Campbell       Embeth Davidtz         Marcus Gilbert   
587  Daniel Day-Lewis   Pete Postlethwaite          Emma Thompson   

                    actor4           actor5  
4         Richard E. Grant     Alec McCowen  
44           Fay Masterson    Gaby Hoffmann  
47          Kevin Anderson             Mako  
55          Joe Pantoliano  Gail Strickland  
74             Sihung Lung       Ah-Leh Gua  
104         Holland Taylor      Ray Sharkey  
108            Brion James    Dennis Farina  
140       Mary Steenburgen    Darlene Cates  
182  Mary Stuart Masterson  Cybill Shepherd  
199        Gwyneth Paltrow   Jerry Swindall  
309              Teri Polo     William Russ  
313         Richard Crenna     Brenda Bakke  
331         Elisabeth Shue     David Rasche  
359         Amanda Plummer   Brenda Fricker  
385           Delroy Lindo        Tom Irwin  
424            David Rupel   Raphael Searge  
467       Vanessa Redgrave     Luke Edwards  
499           Andrew Knott   Laura Crossley  
553        Ian Abercrombie    Richard Grove  
587         Corin Redgrave       John Lynch  

[20 rows x 30 columns]
---------- 1994 ----------
                               title    title_type               genre  \
53                    Heaven & Earth  Feature Film               Drama   
68                       Silent Fall  Feature Film  Mystery & Suspense   
123            Africa: The Serengeti   Documentary         Documentary   
268                            Speed  Feature Film  Mystery & Suspense   
314                           Lassie  Feature Film  Action & Adventure   
444               The Little Rascals  Feature Film              Comedy   
449                       Mixed Nuts  Feature Film              Comedy   
471  Theremin: An Electronic Odyssey   Documentary         Documentary   

     runtime mpaa_rating                            studio  thtr_rel_year  \
53     140.0           R                 Warner Home Video           1994   
68     101.0           R                 Warner Home Video           1994   
123     39.0     Unrated    Houston Museum of Natural Scie           1994   
268    116.0           R                  20th Century Fox           1994   
314     94.0          PG                Paramount Pictures           1994   
444     82.0          PG          MCA Universal Home Video           1994   
449     97.0       PG-13  Sony Pictures Home Entertainment           1994   
471     83.0          PG                          Kaga Bay           1994   

     thtr_rel_month  thtr_rel_day  dvd_rel_year  ...  best_actor_win  \
53                6             1        2004.0  ...              no   
68               10            28        2000.0  ...             yes   
123               4             8        1998.0  ...              no   
268               6            10        1998.0  ...              no   
314               7            22        2002.0  ...              no   
444               8             5        1999.0  ...              no   
449              12            21        2001.0  ...              no   
471               1            29        2006.0  ...              no   

     best_actress_win  best_dir_win  top200_box           director  \
53                 no           yes          no       Oliver Stone   
68                 no            no          no    Bruce Beresford   
123                no            no          no       George Casey   
268               yes            no          no        Jan de Bont   
314                no            no          no      Daniel Petrie   
444                no            no          no  Penelope Spheeris   
449                no            no          no        Nora Ephron   
471                no            no          no   Steven M. Martin   

               actor1          actor2                  actor3  \
53    Tommy Lee Jones     Hiep Thi Le               Joan Chen   
68   Richard Dreyfuss    Ben Faulkner          Linda Hamilton   
123  James Earl Jones             NaN                     NaN   
268      Keanu Reeves   Dennis Hopper          Sandra Bullock   
314         Tom Guiry    Thomas Guiry            Helen Slater   
444    Travis Tedford        Bug Hall  Brittany Ashton Holmes   
449      Steve Martin   Madeline Kahn             Rita Wilson   
471     Leon Theremin  Clara Rockmore           Todd Rundgren   

                actor4            actor5  
53   Dr. Haing S. Ngor   Debbie Reynolds  
68        John Lithgow        J.T. Walsh  
123                NaN               NaN  
268         Joe Morton      Jeff Daniels  
314         Jon Tenney  Frederic Forrest  
444  Kevin Jamal Woods     Zachary Mabry  
449   Anthony LaPaglia    Juliette Lewis  
471       Brian Wilson       Robert Moog  

[8 rows x 30 columns]
---------- 1995 ----------
                                         title    title_type  \
35                                Three Wishes  Feature Film   
97                               Kiss of Death  Feature Film   
98                                   Citizen X      TV Movie   
219                                       Jade  Feature Film   
341                                  Tank Girl  Feature Film   
352                               First Knight  Feature Film   
389                        Vampire in Brooklyn  Feature Film   
450                    While You Were Sleeping  Feature Film   
495  Things to Do in Denver...When You're Dead  Feature Film   
509                             The Babysitter  Feature Film   
529                                   Mallrats  Feature Film   
541                                      Crumb   Documentary   
544                       Operation Dumbo Drop  Feature Film   
569                             The Jerky Boys  Feature Film   
574                           Man of the House  Feature Film   
577                           Mighty Aphrodite  Feature Film   

                  genre  runtime mpaa_rating  \
35                Drama    115.0          PG   
97                Drama    101.0           R   
98                Drama    105.0           R   
219               Drama     95.0           R   
341  Action & Adventure    104.0           R   
352               Drama    134.0       PG-13   
389              Horror    100.0           R   
450               Drama    103.0          PG   
495               Drama    115.0           R   
509  Mystery & Suspense     90.0           R   
529              Comedy     94.0           R   
541              Comedy    119.0           R   
544              Comedy    107.0          PG   
569              Comedy     82.0           R   
574              Comedy     96.0          PG   
577              Comedy     95.0           R   

                                       studio  thtr_rel_year  thtr_rel_month  \
35                                  HBO Video           1995              11   
97   Twentieth Century Fox Home Entertainment           1995               5   
98                                  HBO Video           1995               2   
219                                 Paramount           1995              10   
341                    MGM Home Entertainment           1995               3   
352          Sony Pictures Home Entertainment           1995               7   
389                                 Paramount           1995              10   
450                      Buena Vista Pictures           1995               4   
495                                   Miramax           1995              12   
509                                 Paramount           1995              10   
529                  MCA Universal Home Video           1995              10   
541          Sony Pictures Home Entertainment           1995               5   
544                               Buena Vista           1995               7   
569                               Buena Vista           1995               2   
574                      All Girl Productions           1995               3   
577                             Miramax Films           1995              10   

     thtr_rel_day  dvd_rel_year  ...  best_actor_win  best_actress_win  \
35              3        2001.0  ...              no                no   
97             19        2004.0  ...             yes               yes   
98             25        2000.0  ...              no                no   
219            13        1999.0  ...              no                no   
341             1        2001.0  ...              no                no   
352             7        1997.0  ...              no                no   
389            27        2002.0  ...              no                no   
450            21        1998.0  ...              no               yes   
495             1        1999.0  ...              no                no   
509            17        2002.0  ...              no                no   
529            20        2000.0  ...              no                no   
541            19        1999.0  ...              no                no   
544            28        2003.0  ...              no                no   
569             3        1995.0  ...              no                no   
574             3        2003.0  ...              no                no   
577            27        1999.0  ...              no                no   

     best_dir_win  top200_box          director                  actor1  \
35             no          no   Martha Coolidge          Patrick Swayze   
97             no          no  Barbet Schroeder            David Caruso   
98             no          no     Chris Gerolmo             Stephen Rea   
219           yes          no  William Friedkin            David Caruso   
341            no          no    Rachel Talalay              Lori Petty   
352            no          no      Jerry Zucker            Sean Connery   
389            no          no        Wes Craven            Eddie Murphy   
450            no          no    Jon Turteltaub          Sandra Bullock   
495            no          no       Gary Fleder             Andy Garcia   
509            no          no       Guy Ferland      Alicia Silverstone   
529            no          no       Kevin Smith         Shannen Doherty   
541            no          no     Terry Zwigoff          Aline Kominsky   
544            no          no      Simon Wincer            Danny Glover   
569            no          no   James Melkonian         John G. Brennan   
574            no          no         James Orr  Jonathan Taylor Thomas   
577           yes          no       Woody Allen             Woody Allen   

                          actor2                actor3           actor4  \
35   Mary Elizabeth Mastrantonio          Joe Mazzello        Seth Mumy   
97             Samuel L. Jackson            Helen Hunt     Kathryn Erbe   
98             Donald Sutherland        Jeffrey DeMunn    Max von Sydow   
219             Linda Fiorentino      Chazz Palminteri    Michael Biehn   
341             Malcolm McDowell                 Ice-T      Naomi Watts   
352                 Richard Gere          Julia Ormond        Ben Cross   
389               Angela Bassett           Allen Payne  Kadeem Hardison   
450                 Bill Pullman       Peter Gallagher      Peter Boyle   
495            Christopher Lloyd      William Forsythe        Bill Nunn   
509                   J.T. Walsh        Lee Garlington       Nicky Katt   
529                Jeremy London             Jason Lee   Claire Forlani   
541                Charles Crumb           Maxon Crumb        Max Crumb   
544                   Ray Liotta           Denis Leary     Doug E. Doug   
569               Johnny Brennan           Kamal Ahmed       Alan Arkin   
574                  Chevy Chase        Farrah Fawcett     George Wendt   
577                 Mira Sorvino  Helena Bonham Carter  Olympia Dukakis   

                   actor5  
35   David Marshall Grant  
97           Nicolas Cage  
98           Joss Ackland  
219        Richard Crenna  
341            Don Harvey  
352       Liam Cunningham  
389      John Witherspoon  
450           Jack Warden  
495        Treat Williams  
509         Jeremy London  
529        Michael Rooker  
541         Robert Hughes  
544           Corin Nemec  
569        William Hickey  
574          David Shiner  
577      Michael Rapaport  

[16 rows x 30 columns]
---------- 1996 ----------
                       title    title_type                      genre  \
3        Waiting for Guffman  Feature Film                     Comedy   
8               Mad Dog Time  Feature Film                      Drama   
52       The English Patient  Feature Film                      Drama   
75                     Gotti      TV Movie                      Drama   
111           101 Dalmatians  Feature Film         Action & Adventure   
129                Space Jam  Feature Film                     Comedy   
152  Bastard out of Carolina  Feature Film                      Drama   
181     2 Days in the Valley  Feature Film                      Drama   
192              The Stupids  Feature Film                     Comedy   
200      Mission: Impossible  Feature Film         Mystery & Suspense   
201           A Time to Kill  Feature Film         Mystery & Suspense   
240            Bottle Rocket  Feature Film                      Drama   
250            Happy Gilmore  Feature Film                     Comedy   
320                    Bound  Feature Film         Mystery & Suspense   
332                   Alaska  Feature Film         Action & Adventure   
338                  Curdled  Feature Film                      Drama   
346         The Evening Star  Feature Film                      Drama   
409   Hellraiser - Bloodline  Feature Film  Science Fiction & Fantasy   
420               Sgt. Bilko  Feature Film                     Comedy   
447   The Portrait of a Lady  Feature Film                      Drama   
472     The Whole Wide World  Feature Film                      Drama   
484              The Funeral  Feature Film                      Drama   
487            Trainspotting  Feature Film                      Drama   
497                My Girl 2  Feature Film                      Drama   
500           Get on the Bus  Feature Film                      Drama   
550            Jerry Maguire  Feature Film                      Drama   
580  The Long Kiss Goodnight  Feature Film         Mystery & Suspense   

     runtime mpaa_rating                            studio  thtr_rel_year  \
3       84.0           R            Sony Pictures Classics           1996   
8       93.0           R                MGM/United Artists           1996   
52     162.0           R                     Miramax Films           1996   
75     116.0           R                         HBO Video           1996   
111    103.0           G              Buena Vista Pictures           1996   
129     88.0          PG                 Warner Home Video           1996   
152     97.0           R                           Winstar           1996   
181    104.0           R                         HBO Video           1996   
192     94.0          PG       New Line Home Entertainment           1996   
200    110.0       PG-13                Paramount Pictures           1996   
201    149.0           R                 Warner Home Video           1996   
240     91.0           R                 Columbia Pictures           1996   
250     92.0       PG-13          MCA Universal Home Video           1996   
320    108.0           R      Republic Pictures Home Video           1996   
332    109.0          PG  Sony Pictures Home Entertainment           1996   
338     88.0           R                           Miramax           1996   
346    129.0       PG-13              Paramount Home Video           1996   
409     85.0           R                     Miramax Films           1996   
420     93.0          PG          MCA Universal Home Video           1996   
447    144.0       PG-13                    PolyGram Video           1996   
472    111.0          PG                Sony Entertainment           1996   
484     99.0           R    Echo Bridge Home Entertainment           1996   
487     94.0           R                     Miramax Films           1996   
497     99.0          PG  Sony Pictures Home Entertainment           1996   
500    120.0           R  Sony Pictures Home Entertainment           1996   
550    139.0           R                  TriStar Pictures           1996   
580    121.0           R       New Line Home Entertainment           1996   

     thtr_rel_month  thtr_rel_day  dvd_rel_year  ...  best_actor_win  \
3                 8            21        2001.0  ...              no   
8                11             8        2004.0  ...             yes   
52               11            15        1998.0  ...             yes   
75                8            17        2000.0  ...              no   
111              11            29        1998.0  ...              no   
129              11            15        1997.0  ...              no   
152              12            15        2000.0  ...              no   
181               9            27        2001.0  ...              no   
192               9             6        2004.0  ...              no   
200               5            22        1998.0  ...             yes   
201               7            24        1997.0  ...             yes   
240               2            23        1998.0  ...              no   
250               2            16        1998.0  ...              no   
320              10             4        2001.0  ...              no   
332               8            14        2002.0  ...             yes   
338               9             6        2004.0  ...              no   
346               6             1        2001.0  ...              no   
409               3             8        2000.0  ...              no   
420               3            29        1998.0  ...              no   
447              12            24        1999.0  ...              no   
472              12             1        2003.0  ...              no   
484              11             1        2000.0  ...              no   
487               7            19        1998.0  ...              no   
497               6             1        2002.0  ...              no   
500              10            16        2001.0  ...              no   
550              12            13        1997.0  ...              no   
580              10            11        2001.0  ...              no   

     best_actress_win  best_dir_win  top200_box              director  \
3                  no            no          no     Christopher Guest   
8                  no            no          no          Larry Bishop   
52                 no           yes          no     Anthony Minghella   
75                 no            no          no         Robert Harmon   
111                no            no         yes         Stephen Herek   
129                no            no          no             Joe Pytka   
152                no            no          no       Anjelica Huston   
181               yes            no          no         John Herzfeld   
192                no            no          no           John Landis   
200                no            no         yes         Brian DePalma   
201               yes            no          no       Joel Schumacher   
240                no            no          no          Wes Anderson   
250                no            no          no          Dennis Dugan   
320                no            no          no       Larry Wachowski   
332                no            no          no  Fraser Clarke Heston   
338                no            no          no          Reb Braddock   
346               yes            no          no        Robert Harling   
409                no            no          no         Joe Chappelle   
420                no            no          no         Jonathan Lynn   
447               yes            no          no          Jane Campion   
472                no            no          no           Dan Ireland   
484                no            no          no          Abel Ferrara   
487                no           yes          no           Danny Boyle   
497                no            no          no          Howard Zieff   
500                no            no          no             Spike Lee   
550                no            no          no         Cameron Crowe   
580                no            no          no          Renny Harlin   

                   actor1                actor2            actor3  \
3       Christopher Guest      Catherine O'Hara      Parker Posey   
8        Richard Dreyfuss         Jeff Goldblum     Gabriel Byrne   
52          Ralph Fiennes      Juliette Binoche      Willem Dafoe   
75         Armand Assante      William Forsythe     Anthony Quinn   
111           Glenn Close          Jeff Daniels  Joely Richardson   
129        Michael Jordan       Charles Barkley     Patrick Ewing   
152  Jennifer Jason Leigh           Jena Malone        Ron Eldard   
181          Danny Aiello        Greg Cruttwell      James Spader   
192            Tom Arnold         Jessica Lundy          Bug Hall   
200            Tom Cruise            Jon Voight      Henry Czerny   
201   Matthew McConaughey     Samuel L. Jackson    Sandra Bullock   
240           Owen Wilson           Luke Wilson   Robert Musgrave   
250          Adam Sandler  Christopher McDonald       Julie Bowen   
320        Jennifer Tilly          Gina Gershon    Joe Pantoliano   
332           Thora Birch    Vincent Kartheiser     Dirk Benedict   
338          Angela Jones       William Baldwin      Bruce Ramsay   
346      Shirley MacLaine           Bill Paxton    Juliette Lewis   
409          Doug Bradley          Bruce Ramsay  Valentina Vargas   
420          Steve Martin           Dan Aykroyd      Phil Hartman   
447         Nicole Kidman        John Malkovich   Barbara Hershey   
472     Vincent D'Onofrio       Renee Zellweger    Ann Wedgeworth   
484    Christopher Walken            Chris Penn     Vincent Gallo   
487         Ewan McGregor          Ewen Bremner  Jonny Lee Miller   
497         Anna Chlumsky           Dan Aykroyd  Jamie Lee Curtis   
500           Ossie Davis     Charles S. Dutton    Andre Braugher   
550            Tom Cruise      Cuba Gooding Jr.   Renee Zellweger   
580           Geena Davis     Samuel L. Jackson  Patrick Malahide   

                   actor4                  actor5  
3             Eugene Levy             Bob Balaban  
8            Ellen Barkin              Diane Lane  
52   Kristin Scott Thomas             Colin Firth  
75        Vincent Pastore     Richard C. Sarafian  
111        Joan Plowright             Hugh Laurie  
129         Muggsy Bogues           Patrick Ewing  
152       Dermot Mulroney           Glenne Headly  
181          Teri Hatcher         Charlize Theron  
192          Alex McKenna            Mark Metcalf  
200             Jean Reno             Ving Rhames  
201          Kevin Spacey          Brenda Fricker  
240              Ned Dowd              James Caan  
250           Frances Bay           Carl Weathers  
320          John P. Ryan      Christopher Meloni  
332       Charlton Heston        Gordon Tootoosis  
338            Mel Gorham             Lois Chiles  
346    Miranda Richardson             Ben Johnson  
409             Kim Myers        Christine Harnos  
420         Glenne Headly  Daryl 'Chill' Mitchell  
447    Mary-Louise Parker          Martin Donovan  
472        Harve Presnell         Benjamin Mouton  
484      Benicio Del Toro       Annabella Sciorra  
487          Kevin Mckidd          Robert Carlyle  
497         Richard Masur          Austin O'Brien  
500        Richard Belzer         De'aundre Bonds  
550         Kelly Preston         Jerry O'Connell  
580          Craig Bierko               Brian Cox  

[27 rows x 30 columns]
---------- 1997 ----------
                       title    title_type               genre  runtime  \
21                    Fallen  Feature Film               Drama    124.0   
124      Grosse Pointe Blank  Feature Film               Drama    107.0   
157                   U-Turn  Feature Film               Drama    125.0   
213                  Volcano  Feature Film               Drama    104.0   
283                  Hoodlum  Feature Film               Drama    130.0   
311     Deconstructing Harry  Feature Film              Comedy     96.0   
348          Fire Down Below  Feature Film  Action & Adventure    105.0   
377  8 Heads in a Duffel Bag  Feature Film              Comedy     95.0   
430        Good Will Hunting  Feature Film               Drama    126.0   
448              The Postman  Feature Film  Action & Adventure    177.0   
456        The Fifth Element  Feature Film               Drama    126.0   
562                  Titanic  Feature Film               Drama    194.0   
588       Desperate Measures  Feature Film               Drama    100.0   

    mpaa_rating                                    studio  thtr_rel_year  \
21            R                         Warner Home Video           1997   
124           R                  Buena Vista Internationa           1997   
157           R          Sony Pictures Home Entertainment           1997   
213       PG-13  Twentieth Century Fox Home Entertainment           1997   
283           R                           905 Corporation           1997   
311           R               New Line Home Entertainment           1997   
348           R                         Warner Home Video           1997   
377           R                          Orion Home Video           1997   
430           R                             Miramax Films           1997   
448           R                         Warner Home Video           1997   
456       PG-13          Sony Pictures Home Entertainment           1997   
562       PG-13                        Paramount Pictures           1997   
588           R          Sony Pictures Home Entertainment           1997   

     thtr_rel_month  thtr_rel_day  dvd_rel_year  ...  best_actor_win  \
21                6             1        1998.0  ...             yes   
124               4            11        1998.0  ...              no   
157              10             3        1998.0  ...             yes   
213               4            25        2001.0  ...              no   
283               8            27        2001.0  ...              no   
311              12            12        1998.0  ...              no   
348               9             5        2001.0  ...              no   
377               4            18        2002.0  ...              no   
430              12             5        1998.0  ...              no   
448              12            25        1998.0  ...              no   
456               5             9        1997.0  ...              no   
562              12            19        2012.0  ...              no   
588               6             1        1998.0  ...              no   

     best_actress_win  best_dir_win  top200_box            director  \
21                 no            no          no      Gregory Hoblit   
124                no            no          no     George Armitage   
157                no           yes          no        Oliver Stone   
213                no            no          no        Mick Jackson   
283                no            no          no           Bill Duke   
311                no           yes          no         Woody Allen   
348                no            no          no  Harry Dean Stanton   
377                no            no          no        Tom Schulman   
430                no            no          no        Gus Van Sant   
448                no           yes          no       Kevin Costner   
456                no            no          no          Luc Besson   
562               yes           yes         yes       James Cameron   
588                no            no          no    Barbet Schroeder   

                 actor1             actor2               actor3  \
21    Denzel Washington       John Goodman    Donald Sutherland   
124         John Cusack      Minnie Driver          Dan Aykroyd   
157           Sean Penn         Nick Nolte       Jennifer Lopez   
213     Tommy Lee Jones         Anne Heche          Don Cheadle   
283  Laurence Fishburne           Tim Roth  Vanessa L. Williams   
311       Kirstie Alley     Caroline Aaron          Bob Balaban   
348       Steven Seagal  Marg Helgenberger   Harry Dean Stanton   
377           Joe Pesci        Andy Comeau       Kristy Swanson   
430          Matt Damon     Robin Williams          Ben Affleck   
448         Will Patton        Larenz Tate      Olivia Williams   
456        Bruce Willis           Ian Holm          Gary Oldman   
562   Leonardo DiCaprio       Kate Winslet           Billy Zane   
588      Michael Keaton        Andy Garcia            Brian Cox   

                actor4              actor5  
21      Embeth Davidtz    James Gandolfini  
124         Alan Arkin         Joan Cusack  
157      Powers Boothe        Claire Danes  
213     Jacqueline Kim         Keith David  
283        Andy Garcia        Cicely Tyson  
311   Richard Benjamin       Eric Bogosian  
348       Stephen Lang  Kris Kristofferson  
377        David Spade     George Hamilton  
430      Minnie Driver       Casey Affleck  
448        James Russo   Daniel von Bargen  
456       Chris Tucker          Luke Perry  
562        Kathy Bates      Frances Fisher  
588  Marcia Gay Harden           Erik King  

[13 rows x 30 columns]
---------- 1998 ----------
                                title    title_type               genre  \
27                     Meet Joe Black  Feature Film               Drama   
73   Major League: Back to the Minors  Feature Film              Comedy   
110                   Lethal Weapon 4  Feature Film  Action & Adventure   
113                       Deep Impact  Feature Film               Drama   
236                               Woo  Feature Film              Comedy   
238                            Savior  Feature Film               Drama   
279                       Patch Adams  Feature Film               Drama   
290                          Dog Park  Feature Film              Comedy   
340            A Night at the Roxbury  Feature Film              Comedy   
374           Star Trek: Insurrection  Feature Film  Action & Adventure   
520                        Snake Eyes  Feature Film               Drama   
566                     Mrs. Dalloway  Feature Film               Drama   
597                        Half Baked  Feature Film              Comedy   

     runtime mpaa_rating                            studio  thtr_rel_year  \
27     178.0       PG-13                Universal Pictures           1998   
73     100.0       PG-13                 Warner Home Video           1998   
110    127.0           R                 Warner Home Video           1998   
113    120.0       PG-13                Paramount Pictures           1998   
236     84.0           R       New Line Home Entertainment           1998   
238    103.0           R  Sony Pictures Home Entertainment           1998   
279    115.0       PG-13                 Universal Studios           1998   
290     91.0           R       New Line Home Entertainment           1998   
340     82.0       PG-13                Paramount Pictures           1998   
374    103.0          PG                Paramount Pictures           1998   
520     98.0           R                Paramount Pictures           1998   
566     97.0       PG-13                               BMG           1998   
597     82.0           R                Universal Pictures           1998   

     thtr_rel_month  thtr_rel_day  dvd_rel_year  ...  best_actor_win  \
27               11            13        1999.0  ...             yes   
73                4            17        2000.0  ...              no   
110               7            10        2001.0  ...              no   
113               5             8        1998.0  ...             yes   
236               5             8        2004.0  ...              no   
238              11            20        1999.0  ...              no   
279              12            25        1999.0  ...             yes   
290               6             1        2004.0  ...              no   
340              10             2        1999.0  ...              no   
374              12            11        1999.0  ...              no   
520               8             7        1999.0  ...             yes   
566               2            20        1999.0  ...              no   
597               1            16        1998.0  ...              no   

     best_actress_win  best_dir_win  top200_box             director  \
27                 no            no          no         Martin Brest   
73                 no            no          no          John Warren   
110                no            no          no       Richard Donner   
113                no            no          no           Mimi Leder   
236                no            no          no       Tommy Davidson   
238                no            no          no  Predrag Antonijevic   
279                no            no          no          Tom Shadyac   
290                no            no          no      Bruce McCulloch   
340                no            no          no       Amy Heckerling   
374                no            no          no      Jonathan Frakes   
520                no            no          no        Brian DePalma   
566                no            no          no       Marleen Gorris   
597                no            no          no          Tamra Davis   

                 actor1            actor2             actor3  \
27            Brad Pitt   Anthony Hopkins     Claire Forlani   
73         Scott Bakula    Corbin Bernsen    Dennis Haysbert   
110        Danny Glover        Mel Gibson         Chris Rock   
113       Robert Duvall         Tea Leoni        Elijah Wood   
236  Jada Pinkett Smith    Tommy Davidson            Girlina   
238        Dennis Quaid  Nastassja Kinski    Natasa Ninkovic   
279      Robin Williams     Daniel London      Monica Potter   
290  Natasha Henstridge  Janeane Garofalo        Luke Wilson   
340        Chris Kattan      Will Ferrell      Loni Anderson   
374        Brent Spiner      Michael Dorn       LeVar Burton   
520        Nicolas Cage       Gary Sinise         John Heard   
566    Vanessa Redgrave   Michael Kitchen  Natascha McElhone   
597      Dave Chappelle    Guillermo Diaz         Jim Breuer   

                     actor4             actor5  
27               Jake Weber  Marcia Gay Harden  
73        Takaaki Ishibashi     Jensen Daggett  
110                  Jet Li          Joe Pesci  
113        Vanessa Redgrave  Maximilian Schell  
236          Dave Chappelle   Paula Jai Parker  
238       Sergej Trifunovic   Nebojsa Glogovac  
279  Philip Seymour Hoffman         Bob Gunton  
290      Kathleen Robertson    Bruce McCulloch  
340              Dan Hedaya     Dwayne Hickman  
374        F Murray Abraham       Donna Murphy  
520            Carla Gugino          Stan Shaw  
566                Alan Cox      John Standing  
597        Harland Williams        Rachel True  

[13 rows x 30 columns]
---------- 1999 ----------
                     title    title_type               genre  runtime  \
18                The Wood  Feature Film               Drama    106.0   
58            Happy, Texas  Feature Film              Comedy     98.0   
82                    Bats  Feature Film               Drama     91.0   
92          Arlington Road  Feature Film  Mystery & Suspense    117.0   
174          The Mod Squad  Feature Film               Drama     92.0   
184            Topsy-Turvy  Feature Film               Drama    154.0   
195              B. Monkey  Feature Film               Drama     92.0   
241         At First Sight  Feature Film               Drama    128.0   
252           Run Lola Run  Feature Film               Drama     81.0   
256       An Ideal Husband  Feature Film              Comedy     97.0   
257   Being John Malkovich  Feature Film               Drama    112.0   
263         200 Cigarettes  Feature Film               Drama    101.0   
278  House on Haunted Hill  Feature Film  Mystery & Suspense     93.0   
425         The Ninth Gate  Feature Film  Mystery & Suspense    133.0   
428       The Other Sister  Feature Film               Drama    129.0   
528              In Dreams  Feature Film  Mystery & Suspense    100.0   
585  Hell's Kitchen N.Y.C.  Feature Film               Drama     95.0   
594                 Tarzan  Feature Film               Drama     88.0   

    mpaa_rating                            studio  thtr_rel_year  \
18            R                Paramount Pictures           1999   
58        PG-13                     Miramax Films           1999   
82            R                 Destination Films           1999   
92            R  Sony Pictures Home Entertainment           1999   
174           R                               MGM           1999   
184           R                     October Films           1999   
195           R                           Miramax           1999   
241       PG-13                               MGM           1999   
252           R            Sony Pictures Classics           1999   
256       PG-13                     Miramax Films           1999   
257           R                 Gramercy Pictures           1999   
263           R                Paramount Pictures           1999   
278           R                 Warner Home Video           1999   
425           R             Artisan Entertainment           1999   
428       PG-13                       Buena Vista           1999   
528           R                        Dreamworks           1999   
585           R               HK Film Corporation           1999   
594           G              Buena Vista Pictures           1999   

     thtr_rel_month  thtr_rel_day  dvd_rel_year  ...  best_actor_win  \
18                7            16        2000.0  ...              no   
58               10             1        2001.0  ...              no   
82               10            22        2001.0  ...              no   
92                7             9        2001.0  ...             yes   
174               3            26        1999.0  ...              no   
184              12            17        2000.0  ...              no   
195               9            10        2000.0  ...              no   
241               1            15        1999.0  ...              no   
252               6            18        1999.0  ...              no   
256               6            18        2000.0  ...              no   
257              10            29        2000.0  ...              no   
263               2            26        1999.0  ...              no   
278              10            29        2000.0  ...             yes   
425              12            24        2000.0  ...              no   
428               2            26        2001.0  ...              no   
528               1            15        1999.0  ...              no   
585              12            31        2004.0  ...              no   
594               6            16        2000.0  ...              no   

     best_actress_win  best_dir_win  top200_box            director  \
18                 no            no          no       Rick Famuyiwa   
58                 no            no          no        Mark Illsley   
82                 no            no          no       Louis Morneau   
92                 no            no          no     Mark Pellington   
174                no            no          no        Scott Silver   
184                no            no          no          Mike Leigh   
195                no            no          no     Michael Radford   
241                no            no          no       Irwin Winkler   
252                no            no          no          Tom Tykwer   
256               yes            no          no       Oliver Parker   
257                no            no          no         Spike Jonze   
263                no            no          no  Risa Bramon Garcia   
278                no            no          no      William Malone   
425                no            no          no                 NaN   
428               yes            no          no      Garry Marshall   
528                no            no          no         Neil Jordan   
585                no            no          no    Tony Cinciripini   
594                no            no          no          Chris Buck   

                   actor1             actor2            actor3  \
18              Omar Epps        Sean Nelson        Taye Diggs   
58         Jeremy Northam         Steve Zahn       Ally Walker   
82   Lou Diamond Phillips         Dina Meyer        Bob Gunton   
92           Jeff Bridges        Tim Robbins        Hope Davis   
174          Claire Danes    Giovanni Ribisi         Omar Epps   
184         Jim Broadbent     Allan Corduner     Alan Corduner   
195          Asia Argento       Jared Harris    Rupert Everett   
241            Val Kilmer       Mira Sorvino    Kelly McGillis   
252        Franka Potente   Moritz Bleibtreu     Herbert Knaup   
256        Rupert Everett     Julianne Moore    Jeremy Northam   
257           John Cusack       Cameron Diaz  Catherine Keener   
263           Ben Affleck    Martha Plimpton         Paul Rudd   
278         Geoffrey Rush      Famke Janssen        Taye Diggs   
425           Johnny Depp     Frank Langella         Lena Olin   
428        Juliette Lewis       Diane Keaton      Tom Skerritt   
528        Annette Bening  Robert Downey Jr.       Aidan Quinn   
585          Mekhi Phifer   Rosanna Arquette  William Forsythe   
594          Tony Goldwyn        Glenn Close     Minnie Driver   

                   actor4              actor5  
18          Trent Cameron    Richard T. Jones  
58        Illeana Douglas     William H. Macy  
82                   Leon       Carlos Jacott  
92            Joan Cusack      Robert Gossett  
174           Josh Brolin       Dennis Farina  
184         Timothy Spall     Lesley Manville  
195  Jonathan Rhys Meyers    Julie T. Wallace  
241          Steven Weber       Bruce Davison  
252            Nina Petri         Armin Rohde  
256        Cate Blanchett       Minnie Driver  
257        John Malkovich          Orson Bean  
263      Janeane Garofalo       Courtney Love  
278       Peter Gallagher          Ali Larter  
425    Emmanuelle Seigner     Barbara Jefford  
428       Giovanni Ribisi    Poppy Montgomery  
528           Stephen Rea  Dennis Boutsikaris  
585        Angelina Jolie    Johnny Whitworth  
594       Rosie O'Donnell     Lance Henriksen  

[18 rows x 30 columns]
---------- 2000 ----------
                                                 title    title_type  \
66                                       Proof of Life  Feature Film   
71                                     The Golden Bowl  Feature Film   
107                                            Held Up  Feature Film   
166                                             Bounce  Feature Film   
176                                  Battlefield Earth  Feature Film   
183                                     Pay It Forward  Feature Film   
215                                 Where the Heart Is  Feature Film   
222                                          Cast Away  Feature Film   
298                                         Bamboozled  Feature Film   
356                                            Memento  Feature Film   
391  Into The Arms Of Strangers - Stories Of The Ki...   Documentary   
411                                  Cecil B. Demented  Feature Film   
431                                     Town & Country  Feature Film   
465                                            Bootmen  Feature Film   
483                                    What's Cooking?  Feature Film   
521                                           Croupier  Feature Film   
582                                               Bait  Feature Film   

                  genre  runtime mpaa_rating  \
66                Drama    135.0           R   
71                Drama    130.0           R   
107              Comedy     89.0       PG-13   
166               Drama    106.0       PG-13   
176  Action & Adventure    118.0       PG-13   
183               Drama    123.0       PG-13   
215               Drama    120.0       PG-13   
222               Drama    143.0       PG-13   
298               Drama    135.0           R   
356  Mystery & Suspense    113.0           R   
391         Documentary    122.0          PG   
411              Comedy     87.0           R   
431               Drama    104.0           R   
465               Drama     95.0           R   
483               Drama    109.0       PG-13   
521  Mystery & Suspense     94.0           R   
582               Drama    119.0           R   

                                       studio  thtr_rel_year  thtr_rel_month  \
66                      Warner Bros. Pictures           2000              12   
71                           Lions Gate Films           2000               5   
107                                   Trimark           2000               5   
166                             Miramax Films           2000              11   
176                     Warner Bros. Pictures           2000               5   
183                     Warner Bros. Pictures           2000              10   
215  Twentieth Century Fox Home Entertainment           2000               4   
222                          20th Century Fox           2000              12   
298                           New Line Cinema           2000              10   
356                           Newmarket Films           2000               9   
391                     Warner Bros. Pictures           2000               9   
411                     Artisan Entertainment           2000               8   
431                           New Line Cinema           2000               9   
465  Twentieth Century Fox Home Entertainment           2000              10   
483                          Trimark Pictures           2000               1   
521                      The Shooting Gallery           2000               4   
582                     Warner Bros. Pictures           2000               9   

     thtr_rel_day  dvd_rel_year  ...  best_actor_win  best_actress_win  \
66              8        2001.0  ...             yes                no   
71             14        2001.0  ...              no                no   
107            12        2000.0  ...             yes                no   
166            17        2001.0  ...              no               yes   
176            12        2001.0  ...             yes                no   
183            20        2001.0  ...             yes               yes   
215            28        2000.0  ...              no               yes   
222            22        2001.0  ...             yes               yes   
298             6        2001.0  ...              no                no   
356             5        2001.0  ...              no                no   
391            15        2001.0  ...              no                no   
411            11        2001.0  ...              no                no   
431             1        2001.0  ...              no               yes   
465             6        2004.0  ...              no                no   
483            20        2001.0  ...              no                no   
521            21        2001.0  ...              no                no   
582            15        2001.0  ...             yes                no   

     best_dir_win  top200_box              director           actor1  \
66             no          no       Taylor Hackford         Meg Ryan   
71             no          no           James Ivory      Uma Thurman   
107            no          no            Steve Rash       Jamie Foxx   
166            no          no              Don Roos      Ben Affleck   
176            no          no       Roger Christian    John Travolta   
183            no          no            Mimi Leder     Kevin Spacey   
215            no          no         Matt Williams  Natalie Portman   
222           yes         yes       Robert Zemeckis        Tom Hanks   
298            no          no             Spike Lee     Damon Wayans   
356            no          no     Christopher Nolan       Guy Pearce   
391            no          no  Mark Jonathan Harris  Lorraine Allard   
411            no          no           John Waters    Stephen Dorff   
431            no          no          Boris Damast    Warren Beatty   
465            no          no            Dein Perry      Adam Garcia   
483            no          no       Gurinder Chadha    Kyra Sedgwick   
521            no          no           Mike Hodges       Clive Owen   
582            no          no         Antoine Fuqua       Jamie Foxx   

               actor2              actor3              actor4  \
66      Russell Crowe         David Morse        David Caruso   
71    Kate Beckinsale      Jeremy Northam          Nick Nolte   
107          Nia Long        Barry Corbin         John Cullum   
166   Gwyneth Paltrow        Tony Goldwyn        Alex D. Linz   
176      Barry Pepper     Forest Whitaker          Kim Coates   
183        Helen Hunt   Haley Joel Osment     Angie Dickinson   
215       Ashley Judd         Sally Field   Stockard Channing   
222        Helen Hunt         Nick Searcy          Chris Noth   
298     Savion Glover      Tommy Davidson    Michael Rapaport   
356    Joe Pantoliano    Carrie-Anne Moss  Stephen Tobolowsky   
391         Lory Cahn        Hedy Epstein         Kurt Fuchel   
411  Melanie Griffith      Adrian Grenier         Alicia Witt   
431      Diane Keaton         Goldie Hawn     Garry Shandling   
465        Sophie Lee     Sam Worthington       William Zappa   
483    Mercedes Ruehl  Julianna Margulies       Alfre Woodard   
521     Alex Kingston         Kate Hardie          Gina McKee   
582       David Morse   Robert Pastorelli      Doug Hutchison   

                    actor5  
66             Pamela Reed  
71         Anjelica Huston  
107             Jake Busey  
166          David Dorfman  
176          Richard Tyson  
183               Jay Mohr  
215            Joan Cusack  
222             Lari White  
298  Thomas Jefferson Byrd  
356         Mark Boone Jr.  
391       Gordon Alexander  
411  Lawrence Gilliard Jr.  
431        Andie MacDowell  
465         Richard Carter  
483              Joan Chen  
521          Nicholas Ball  
582         Kimberly Elise  

[17 rows x 30 columns]
---------- 2001 ----------
                               title    title_type               genre  \
2                           The Dish  Feature Film               Drama   
22                The Gleaners and I   Documentary         Documentary   
106                         Spy Game  Feature Film               Drama   
165      Vampire Hunter D: Bloodlust  Feature Film  Action & Adventure   
177                    Osmosis Jones  Feature Film              Comedy   
223  Crocodile Dundee in Los Angeles  Feature Film  Action & Adventure   
225               Lost and Delirious  Feature Film               Drama   
242                        Session 9  Feature Film               Drama   
255                      Waking Life  Feature Film               Drama   
286             The Man Who Sued God  Feature Film               Drama   
421            One Night at McCool's  Feature Film              Comedy   
442            The Safety of Objects  Feature Film  Mystery & Suspense   
452                      Pootie Tang  Feature Film              Comedy   
474                        Swordfish  Feature Film               Drama   
507                  What Women Want  Feature Film              Comedy   
516                  A Shot at Glory  Feature Film               Drama   
534                     Training Day  Feature Film               Drama   

     runtime mpaa_rating                      studio  thtr_rel_year  \
2      101.0       PG-13       Warner Bros. Pictures           2001   
22      82.0     Unrated             Zeitgeist Films           2001   
106    126.0           R          Universal Pictures           2001   
165    103.0           R  Urban Vision Entertainment           2001   
177     95.0          PG       Warner Bros. Pictures           2001   
223     92.0          PG                   Paramount           2001   
225    103.0           R        Lions Gate Releasing           2001   
242    100.0           R                   USA Films           2001   
255     99.0           R             Fox Searchlight           2001   
286     97.0           R                         NaN           2001   
421     93.0           R                   USA Films           2001   
442    121.0           R                   IFC Films           2001   
452     81.0       PG-13          Paramount Pictures           2001   
474     99.0           R       Warner Bros. Pictures           2001   
507    127.0       PG-13          Paramount Pictures           2001   
516    114.0           R          Fireworks Pictures           2001   
534    122.0           R       Warner Bros. Pictures           2001   

     thtr_rel_month  thtr_rel_day  dvd_rel_year  ...  best_actor_win  \
2                 3            14        2001.0  ...              no   
22                4             6        2002.0  ...              no   
106              11            21        2002.0  ...              no   
165               9            21        2002.0  ...              no   
177               8            10        2001.0  ...              no   
223               4            20        2001.0  ...              no   
225               7            20        2001.0  ...              no   
242               8            10        2002.0  ...              no   
255               1            19        2002.0  ...              no   
286              10            25        2007.0  ...              no   
421               4            27        2001.0  ...             yes   
442               1             1        2003.0  ...              no   
452               6            29        2001.0  ...              no   
474               6             8        2001.0  ...              no   
507               5             1        2001.0  ...              no   
516               6             8        2002.0  ...              no   
534              10             5        2004.0  ...             yes   

     best_actress_win  best_dir_win  top200_box           director  \
2                  no            no          no          Rob Sitch   
22                 no            no          no        Agnes Varda   
106                no            no          no         Tony Scott   
165                no            no          no  Yoshiaki Kawajiri   
177                no            no          no        Bill Murray   
223                no            no          no       Simon Wincer   
225                no            no          no           Lea Pool   
242                no            no          no      Brad Anderson   
255                no            no          no  Richard Linklater   
286                no            no          no         Mark Joffe   
421                no            no          no       Harald Zwart   
442                no            no          no        Rose Troche   
452                no            no          no         Louis C.K.   
474               yes            no          no       Dominic Sena   
507               yes            no          no       Nancy Meyers   
516                no            no          no   Michael Corrente   
534                no            no          no      Antoine Fuqua   

                actor1               actor2               actor3  \
2            Sam Neill     Kevin Harrington    Patrick Warburton   
22     Bodan Litnanski  Francois Wertheimer          Agnes Varda   
106     Robert Redford            Brad Pitt  Catherine McCormack   
165         Wendee Lee       Andrew Philpot        Pamela Segall   
177        Bill Murray           Chris Rock   Laurence Fishburne   
223         Paul Hogan      Linda Kozlowski           Jere Burns   
225       Piper Perabo         Jessica Pare        Mischa Barton   
242       David Caruso      Stephen Gevedon       Paul Guilfoyle   
255  Lorelei Linklater   Trevor Jack Brooks          Glover Gill   
286     Billy Connolly           Judy Davis         Colin Friels   
421          Liv Tyler          Matt Dillon          Paul Reiser   
442        Glenn Close      Dermot Mulroney     Jessica Campbell   
452     Lance Crouther    Jennifer Coolidge          Wanda Sykes   
474      John Travolta         Hugh Jackman          Halle Berry   
507         Helen Hunt           Mel Gibson         Marisa Tomei   
516     Michael Keaton         Ally McCoist      Kirsty Mitchell   
534  Denzel Washington          Ethan Hawke          Scott Glenn   

                      actor4              actor5  
2                   Tom Long      Genevieve Mooy  
22           Margaret Dumont       Virginia Grey  
106          Stephen Dillane      Larry Bryggman  
165           Toshihiko Seki  Megumi Hayashibara  
177        David Hyde Pierce     William Shatner  
223              Alec Wilson       Gerry Skilton  
225         Jackie Burroughs      Eleanor Bannet  
242               Josh Lucas        Peter Mullan  
255  Timothy 'Speed' Levitch         Laura Hicks  
286              Bille Brown        Wendy Hughes  
421             John Goodman     Michael Douglas  
442        Patricia Clarkson      Joshua Jackson  
452            Robert Vaughn          Chris Rock  
474              Don Cheadle        Vinnie Jones  
507                Alan Alda      Ashley Johnson  
516                Brian Cox         Cole Hauser  
534             Tom Berenger        Harris Yulin  

[17 rows x 30 columns]
---------- 2002 ----------
                                       title    title_type  \
13                      The Royal Tenenbaums  Feature Film   
19                                   Jason X  Feature Film   
38                                       Max  Feature Film   
41                                  The Guru  Feature Film   
50                    The Mothman Prophecies  Feature Film   
60                                  Promises   Documentary   
67                         Waking Up in Reno  Feature Film   
78                            Riders (Steal)  Feature Film   
139                     K-19: The Widowmaker  Feature Film   
156           Blind Spot: Hitler's Secretary   Documentary   
169                            Resident Evil  Feature Film   
187                               Gaza Strip   Documentary   
210                     The Sum of All Fears  Feature Film   
248                                   Cypher  Feature Film   
280  Harry Potter and the Chamber of Secrets  Feature Film   
300                       The Slaughter Rule  Feature Film   
304                 11'09''01 - September 11  Feature Film   
326                                    Below  Feature Film   
380                            Stolen Summer  Feature Film   
397                               Ghost Ship  Feature Film   
433                                   Simone  Feature Film   
455                               Formula 51  Feature Film   
459                                 Showtime  Feature Film   

                         genre  runtime mpaa_rating  \
13                      Comedy    110.0           R   
19                      Horror     91.0           R   
38                       Drama    106.0           R   
41                      Comedy     94.0           R   
50          Mystery & Suspense    119.0       PG-13   
60                 Documentary    106.0     Unrated   
67                      Comedy     91.0           R   
78          Action & Adventure     83.0           R   
139                      Drama    138.0       PG-13   
156                Documentary     90.0          PG   
169         Action & Adventure    100.0           R   
187                Documentary     74.0     Unrated   
210                      Drama    124.0       PG-13   
248         Action & Adventure     95.0           R   
280  Science Fiction & Fantasy    161.0          PG   
300                      Drama    112.0           R   
304                      Drama    134.0     Unrated   
326         Mystery & Suspense    105.0           R   
380                      Drama     91.0          PG   
397                     Horror     91.0           R   
433                      Drama    117.0       PG-13   
455         Action & Adventure     93.0           R   
459                     Comedy     95.0       PG-13   

                             studio  thtr_rel_year  thtr_rel_month  \
13   Buena Vista Distribution Compa           2002               1   
19                  New Line Cinema           2002               4   
38                 Lions Gate Films           2002              12   
41               Universal Pictures           2002               1   
50                      Screen Gems           2002               1   
60                  Cowboy Pictures           2002               3   
67                    Miramax Films           2002              10   
78                          Miramax           2002               8   
139              Paramount Pictures           2002               7   
156          Sony Pictures Classics           2002              10   
169       Columbia Tristar Pictures           2002               3   
187          Arab Film Distribution           2002               1   
210              Paramount Pictures           2002               5   
248                         Miramax           2002              10   
280           Warner Bros. Pictures           2002              11   
300                 Cowboy Pictures           2002               1   
304                 Empire Pictures           2002               9   
326                 Dimension Films           2002              10   
380                   Miramax Films           2002               3   
397           Warner Bros. Pictures           2002              10   
433                 New Line Cinema           2002               8   
455                     Screen Gems           2002              10   
459           Warner Bros. Pictures           2002               3   

     thtr_rel_day  dvd_rel_year  ...  best_actor_win  best_actress_win  \
13              4        2002.0  ...             yes               yes   
19             26        2004.0  ...              no                no   
38             27        2003.0  ...              no                no   
41             31        2003.0  ...              no                no   
50             25        2002.0  ...              no                no   
60             22        2004.0  ...              no                no   
67             25        2003.0  ...              no               yes   
78              5        2005.0  ...              no                no   
139            19        2002.0  ...              no                no   
156            10        2003.0  ...              no                no   
169            15        2002.0  ...              no                no   
187             1        2003.0  ...              no                no   
210            31        2002.0  ...              no                no   
248             7        2005.0  ...              no                no   
280            15        2003.0  ...              no                no   
300            11        2003.0  ...              no                no   
304            11        2004.0  ...             yes                no   
326            11        2003.0  ...              no                no   
380            22        2002.0  ...              no                no   
397            25        2003.0  ...              no                no   
433            23        2003.0  ...             yes                no   
455            18        2003.0  ...              no                no   
459            15        2002.0  ...             yes                no   

     best_dir_win  top200_box                  director              actor1  \
13             no          no              Wes Anderson        Gene Hackman   
19             no          no               James Isaac         Kane Hodder   
38             no          no              Menno Meyjes         John Cusack   
41             no          no  Daisy von Scherler Mayer         Jimi Mistry   
50             no          no           Mark Pellington        Richard Gere   
60             no          no             B.Z. Goldberg               Yarko   
67             no          no              Jordan Brady     Charlize Theron   
78             no          no              Gerard Pires  Natasha Henstridge   
139           yes          no           Kathryn Bigelow       Harrison Ford   
156            no          no              Andre Heller        Traudl Junge   
169            no          no        Paul W.S. Anderson      Milla Jovovich   
187            no          no             James Longley                 NaN   
210            no          no       Phil Alden Robinson         Ben Affleck   
248            no          no           Vincenzo Natali      Jeremy Northam   
280            no         yes            Chris Columbus    Daniel Radcliffe   
300            no          no                Alex Smith        Ryan Gosling   
304            no          no         Samira Makhmalbaf           Sean Penn   
326            no          no               David Twohy       Matthew Davis   
380            no          no                Pete Jones         Aidan Quinn   
397            no          no                Steve Beck       Gabriel Byrne   
433            no          no             Andrew Niccol           Al Pacino   
455            no          no                  Ronny Yu   Samuel L. Jackson   
459            no          no                   Tom Dey      Robert De Niro   

                 actor2              actor3              actor4  \
13      Anjelica Huston     Gwyneth Paltrow         Ben Stiller   
19            Lexa Doig          Lisa Ryder      Chuck Campbell   
38          Noah Taylor     Leelee Sobieski        Molly Parker   
41       Heather Graham        Marisa Tomei      Michael McKean   
50         Laura Linney       Debra Messing         Will Patton   
60               Daniel             Mahmoud              Shlomo   
67       Patrick Swayze  Natasha Richardson  Billy Bob Thornton   
78        Stephen Dorff         Bruce Payne        Karen Cliche   
139         Liam Neeson     Peter Sarsgaard   Christian Camargo   
156        Traudl Junge        James Franco    Shawn Montgomery   
169  Michelle Rodriguez         Eric Mabius       James Purefoy   
187                 NaN                 NaN                 NaN   
210      Morgan Freeman      James Cromwell      Liev Schreiber   
248            Lucy Liu       Nigel Bennett      Timothy Webber   
280         Emma Watson        Rupert Grint        Jason Isaacs   
300         David Morse         Clea DuVall        Eddie Spears   
304       Maryam Karimi      Mohamad Dolati       Agelem Habibi   
326     Bruce Greenwood     Olivia Williams         Scott Foley   
380         Bonnie Hunt         Adiel Stein        Kevin Pollak   
397  Julianna Margulies          Ron Eldard  Desmond Harrington   
433    Catherine Keener      Rachel Roberts    Evan Rachel Wood   
455      Robert Carlyle      Emily Mortimer          Rhys Ifans   
459        Eddie Murphy          Rene Russo        Pedro Damien   

                actor5  
13         Luke Wilson  
19      Jonathan Potts  
38      Ulrich Thomsen  
41          Dash Mihok  
50      Lucinda Jenney  
60   Sanabel Cherqaoui  
67        Chelcie Ross  
78         Cle Bennett  
139       Joss Ackland  
156       Mark Gleason  
169      Martin Crewes  
187                NaN  
210   Bridget Moynahan  
248      David Hewlett  
280       Alan Rickman  
300        Kelly Lynch  
304       Esmat Vahedi  
326     Holt McCallany  
380          Adi Stein  
397  Isaiah Washington  
433           Jay Mohr  
455       Sean Pertwee  
459       Pedro Damian  

[23 rows x 30 columns]
---------- 2003 ----------
                                       title    title_type  \
40                                     Basic  Feature Film   
62                               The Recruit  Feature Film   
115                                 The Room  Feature Film   
121                                      May  Feature Film   
158                   Something's Gotta Give  Feature Film   
171                                25th Hour  Feature Film   
190                Orwell Rolls in His Grave   Documentary   
235                          The Human Stain  Feature Film   
258                         Secondhand Lions  Feature Film   
259      Politiki Kouzina (A Touch of Spice)  Feature Film   
267                                Good Boy!  Feature Film   
272                            28 Days Later  Feature Film   
273                                   Normal      TV Movie   
284                        National Security  Feature Film   
302                       Hollywood Homicide  Feature Film   
345                     Malibu's Most Wanted  Feature Film   
386                       My Flesh and Blood   Documentary   
388                                     Hulk  Feature Film   
398                                 21 Grams  Feature Film   
443  Dumb and Dumberer: When Harry Met Lloyd  Feature Film   
479                            Love Actually  Feature Film   
506                    House of 1000 Corpses  Feature Film   
518                            Sweet Sixteen  Feature Film   
519                         Cold Creek Manor  Feature Film   
559                        Undertaking Betty  Feature Film   

                         genre  runtime mpaa_rating  \
40                       Drama     98.0           R   
62          Mystery & Suspense    115.0       PG-13   
115                      Drama     99.0           R   
121                      Drama     93.0           R   
158                     Comedy    128.0       PG-13   
171                      Drama    135.0           R   
190                Documentary     84.0     Unrated   
235         Mystery & Suspense    106.0           R   
258                      Drama    111.0          PG   
259                      Drama    108.0     Unrated   
267                     Comedy     87.0          PG   
272  Science Fiction & Fantasy    113.0           R   
273                      Drama    110.0     Unrated   
284                      Drama     88.0       PG-13   
302         Action & Adventure    116.0       PG-13   
345                     Comedy     86.0       PG-13   
386                Documentary     83.0     Unrated   
388         Action & Adventure    138.0       PG-13   
398                      Drama    124.0           R   
443                     Comedy     85.0       PG-13   
479                     Comedy    135.0           R   
506                     Horror     89.0           R   
518                      Drama    106.0           R   
519         Mystery & Suspense    118.0           R   
559                      Drama     94.0       PG-13   

                           studio  thtr_rel_year  thtr_rel_month  \
40    Sony Pictures Entertainment           2003               3   
62            Touchstone Pictures           2003               1   
115             Chloe Productions           2003               6   
121           Lionsgate Releasing           2003               6   
158                 Sony Pictures           2003              12   
171           Touchstone Pictures           2003               1   
190  Sag Harbor-Basement Pictures           2003              10   
235                 Miramax Films           2003              10   
258               New Line Cinema           2003               9   
259              Brainstorm Media           2003              10   
267                           MGM           2003              10   
272      Fox Searchlight Pictures           2003               6   
273                Bankside Films           2003               1   
284                 Sony Pictures           2003               1   
302             Columbia Pictures           2003               6   
345                  Warner Bros.           2003               4   
386              Strand Releasing           2003              11   
388            Universal Pictures           2003               6   
398            Universal Pictures           2003              11   
443               New Line Cinema           2003               6   
479            Universal Pictures           2003              11   
506         Lions Gate Films Inc.           2003               4   
518              Lions Gate Films           2003               5   
519          Buena Vista Pictures           2003               9   
559                 Miramax Films           2003               1   

     thtr_rel_day  dvd_rel_year  ...  best_actor_win  best_actress_win  \
40             28        2003.0  ...              no                no   
62             31        2003.0  ...             yes                no   
115            27        2005.0  ...              no                no   
121             6        2003.0  ...              no                no   
158            12        2004.0  ...             yes               yes   
171            10        2003.0  ...             yes                no   
190            23        2005.0  ...              no                no   
235            21        2004.0  ...             yes               yes   
258            19        2004.0  ...             yes                no   
259            24        2010.0  ...              no                no   
267            10        2004.0  ...              no                no   
272            27        2003.0  ...              no                no   
273            21        2003.0  ...              no               yes   
284            17        2003.0  ...              no                no   
302            13        2003.0  ...              no                no   
345            18        2003.0  ...              no                no   
386            28        2004.0  ...              no                no   
388            20        2003.0  ...              no                no   
398            21        2004.0  ...             yes                no   
443            13        2004.0  ...              no                no   
479             7        2004.0  ...             yes               yes   
506            11        2003.0  ...              no                no   
518            16        2003.0  ...              no                no   
519            19        2004.0  ...              no                no   
559             1        2006.0  ...              no                no   

     best_dir_win  top200_box                     director  \
40             no          no               John McTiernan   
62             no          no              Roger Donaldson   
115            no          no                 Tommy Wiseau   
121            no          no                  Lucky McKee   
158            no          no                 Nancy Meyers   
171            no          no                    Spike Lee   
190            no          no           Robert Kane Pappas   
235           yes          no                Robert Benton   
258            no          no                Tim McCanlies   
259            no          no             Tassos Boulmetis   
267            no          no          John Robert Hoffman   
272           yes          no                  Danny Boyle   
273            no          no                Jane Anderson   
284            no          no                 Dennis Dugan   
302            no          no                  Ron Shelton   
345            no          no               John Whitesell   
386            no          no               Jonathan Karsh   
388           yes          no                      Ang Lee   
398           yes          no  Alejandro Gonzalez Inarritu   
443            no          no                  Troy Miller   
479            no          no               Richard Curtis   
506            no          no                   Rob Zombie   
518            no          no                    Ken Loach   
519            no          no                  Mike Figgis   
559            no          no                  Nich Hurran   

                   actor1                actor2                  actor3  \
40          John Travolta        Connie Nielsen       Samuel L. Jackson   
62              Al Pacino         Colin Farrell        Bridget Moynahan   
115          Tommy Wiseau     Juliette Danielle            Greg Sestero   
121         Angela Bettis          Jeremy Sisto              Anna Faris   
158        Jack Nicholson          Diane Keaton       Frances McDormand   
171         Edward Norton          Barry Pepper  Philip Seymour Hoffman   
190    Robert Kane Pappas       Danny Schechter           Charles Lewis   
235       Anthony Hopkins         Nicole Kidman               Ed Harris   
258         Michael Caine         Robert Duvall       Haley Joel Osment   
259     Georges Corraface  Ieroklis Michaelidis     Ieroklis Mihailidis   
267            Liam Aiken         Molly Shannon            Kevin Nealon   
272        Cillian Murphy         Naomie Harris         Brendan Gleeson   
273         Tom Wilkinson         Jessica Lange           Randall Arney   
284       Martin Lawrence            Steve Zahn              Colm Feore   
302         Harrison Ford         Josh Hartnett               Lena Olin   
345            Taye Diggs      Anthony Anderson             Regina Hall   
386             Susan Tom               Joe Tom               Chloe Tom   
388             Eric Bana     Jennifer Connelly             Sam Elliott   
398             Sean Penn           Naomi Watts        Benicio Del Toro   
443  Eric Christian Olsen      Derek Richardson          Rachel Nichols   
479            Bill Nighy            Hugh Grant             Liam Neeson   
506              Sid Haig          Bill Moseley          Chris Hardwick   
518       Martin Compston       Annmarie Fulton           William Ruane   
519          Dennis Quaid          Sharon Stone           Stephen Dorff   
559        Brenda Blethyn         Alfred Molina      Christopher Walken   

                   actor4                 actor5  
40               Tim Daly             Taye Diggs  
62          Gabriel Macht            Mike Realba  
115       Philip Haldiman        Carolyn Minnott  
121           James Duval       Nichole M. Hiltz  
158          Keanu Reeves            Amanda Peet  
171        Rosario Dawson            Anna Paquin  
190      Vincent Bugliosi          Michael Moore  
235           Gary Sinise       Wentworth Miller  
258         Kyra Sedgwick             Nicky Katt  
259       Renia Louizidou        Basak Koklukaya  
267     Brittany Moldowan       George Touliatos  
272           Megan Burns  Christopher Eccleston  
273     Hayden Panettiere             Joe Sikora  
284             Bill Duke           Eric Roberts  
302       Bruce Greenwood      Isaiah Washington  
345           Ryan O'Neal               Bo Derek  
386           Anthony Tom              Xenia Tom  
388            Nick Nolte             Josh Lucas  
398  Charlotte Gainsbourg            Melissa Leo  
443           Cheri Oteri            Luis Guzman  
479         Emma Thompson            Colin Firth  
506          Erin Daniels          Dennis Fimple  
518   Michelle Abercromby       Michelle Coulter  
519        Juliette Lewis        Kristen Stewart  
559           Naomi Watts            Robert Pugh  

[25 rows x 30 columns]
---------- 2004 ----------
                                            title    title_type  \
5                                     Malevolence  Feature Film   
32                                  The Reckoning  Feature Film   
48                     Mojados: Through the Night   Documentary   
72                                           Easy  Feature Film   
94   Charlie: The Life and Art of Charles Chaplin   Documentary   
148                               My Baby's Daddy  Feature Film   
194                                     Wimbledon  Feature Film   
276                                     Sleepover  Feature Film   
297                          The Football Factory  Feature Film   
328                The Saddest Music in the World  Feature Film   
344                                Shall We Dance  Feature Film   
376                           Kill Bill: Volume 2  Feature Film   
390        Agent Cody Banks 2: Destination London  Feature Film   
396                           Kaena: The Prophecy  Feature Film   
426                               New York Minute  Feature Film   
481                                       Bookies  Feature Film   
486                          Welcome to Mooseport  Feature Film   
492                             The Perfect Score  Feature Film   
503            Bridget Jones - The Edge of Reason  Feature Film   
532                                           Ray  Feature Film   
536                                    The Mother  Feature Film   
546                                       Monster  Feature Film   
547                                 Bright Leaves   Documentary   
560                                  Taking Lives  Feature Film   
599                   Around the World in 80 Days  Feature Film   

                  genre  runtime mpaa_rating                    studio  \
5                Horror     90.0           R  Anchor Bay Entertainment   
32          Documentary    112.0           R        Paramount Classics   
48          Documentary     65.0     Unrated                      Diva   
72                Drama     99.0           R      Magic Lamp Releasing   
94          Documentary    132.0     Unrated              Warner Bros.   
148              Comedy     86.0       PG-13             Miramax Films   
194               Drama     98.0       PG-13        Universal Pictures   
276              Comedy     89.0          PG                       MGM   
297         Documentary     91.0           R       Image Entertainment   
328               Drama    100.0           R                 IFC Films   
344               Drama    106.0       PG-13             Miramax Films   
376               Drama    137.0           R             Miramax Films   
390  Action & Adventure    100.0          PG                       MGM   
396  Action & Adventure     85.0       PG-13      Samuel Goldwyn Films   
426  Action & Adventure     91.0          PG              Warner Bros.   
481               Drama     88.0           R    MGM Home Entertainment   
486              Comedy    110.0       PG-13          20th Century Fox   
492               Drama     93.0       PG-13        Paramount Pictures   
503               Drama    108.0           R             Miramax Films   
532               Drama    152.0       PG-13        Universal Pictures   
536               Drama    112.0           R    Sony Pictures Classics   
546               Drama    109.0           R      Newmarket Film Group   
547         Documentary    107.0     Unrated        First Run Features   
560               Drama    103.0           R              Warner Bros.   
599  Action & Adventure    120.0          PG      Buena Vista Pictures   

     thtr_rel_year  thtr_rel_month  thtr_rel_day  dvd_rel_year  ...  \
5             2004               9            10        2005.0  ...   
32            2004               3             5        2004.0  ...   
48            2004               3            12        2005.0  ...   
72            2004              11            26        2005.0  ...   
94            2004               2            13           NaN  ...   
148           2004               1             9        2004.0  ...   
194           2004               9            17        2004.0  ...   
276           2004               7             9        2004.0  ...   
297           2004               5            14        2005.0  ...   
328           2004               4            30        2004.0  ...   
344           2004              10            15        2005.0  ...   
376           2004               4            16        2004.0  ...   
390           2004               3            12        2004.0  ...   
396           2004               7             9        2004.0  ...   
426           2004               5             7        2004.0  ...   
481           2004               9             1        2004.0  ...   
486           2004               2            20        2004.0  ...   
492           2004               1            30        2004.0  ...   
503           2004              11            12        2005.0  ...   
532           2004              10            29        2005.0  ...   
536           2004               5            28        2004.0  ...   
546           2004               1             9        2004.0  ...   
547           2004               8            25        2005.0  ...   
560           2004               3            19        2004.0  ...   
599           2004               6            16        2004.0  ...   

     best_actor_win  best_actress_win  best_dir_win  top200_box  \
5                no                no            no          no   
32               no                no            no          no   
48               no                no            no          no   
72               no                no            no          no   
94               no                no            no          no   
148              no                no            no          no   
194              no                no            no          no   
276              no                no            no          no   
297              no                no            no          no   
328              no                no            no          no   
344              no               yes            no          no   
376              no                no            no          no   
390              no                no            no          no   
396              no                no            no          no   
426              no                no            no          no   
481              no                no            no          no   
486             yes                no            no          no   
492              no                no            no          no   
503             yes                no            no          no   
532             yes                no            no          no   
536              no                no            no          no   
546              no               yes            no          no   
547              no               yes            no          no   
560              no                no            no          no   
599              no                no            no         yes   

              director               actor1              actor2  \
5          Stevan Mena        Samantha Dark  R. Brandon Johnson   
32        Pamela Yates         Paul Bettany        Willem Dafoe   
48         Tommy Davis          Tommy Davis               Guapo   
72      Jane Weinstock    Marguerite Moreau      Naveen Andrews   
94    Richard Schickel          Woody Allen         Johnny Depp   
148       Cheryl Dunye     Anthony Anderson   Michael Imperioli   
194  Richard Loncraine        Kirsten Dunst        Paul Bettany   
276       Joe Nussbaum           Alexa Vega         Mika Boorem   
297          Nick Love           Danny Dyer        Frank Harper   
328         Guy Maddin  Isabella Rossellini       Mark McKinney   
344      Peter Chelsom         Richard Gere      Jennifer Lopez   
376  Quentin Tarantino          Uma Thurman     David Carradine   
390        Kevin Allen        Frankie Muniz    Anthony Anderson   
396    Chris Delaporte        Kirsten Dunst      Richard Harris   
426      Dennie Gordon          Eugene Levy        Andy Richter   
481       Mark Illsley           Nick Stahl          Lukas Haas   
486      Donald Petrie           Ray Romano        Gene Hackman   
492      Brian Robbins    Erika Christensen  Scarlett Johansson   
503      Beeban Kidron          Colin Firth     Renee Zellweger   
532    Taylor Hackford           Jamie Foxx    Kerry Washington   
536      Roger Michell            Anne Reid        Daniel Craig   
546      Patty Jenkins      Charlize Theron     Christina Ricci   
547       Ross McElwee         Ross McElwee    Charleen Swansea   
560        D.J. Caruso       Angelina Jolie         Ethan Hawke   
599       Frank Coraci          Jackie Chan        Steve Coogan   

                actor3              actor4                 actor5  
5      Brandon Johnson       Heather Magee         Richard Glover  
32      Simon McBurney        Ewen Bremner             Gina McKee  
48                 Oso               Tigre                  Viejo  
72     Emily Deschanel      Jordan Garrett       Caroline Goodall  
94      Sydney Pollack        Milos Forman         Marcel Marceau  
148   Paula Jai Parker      Joanna Bacalso               Ling Bai  
194          Sam Neill        James McAvoy           Bernard Hill  
276         Jane Lynch      Sam Huntington  Kalli Flynn Childress  
297      Dudley Sutton        Tamer Hassan       Roland Monookian  
328  Maria de Medeiros       Ross McMillan              David Fox  
344     Susan Sarandon       Stanley Tucci        Bobby Cannavale  
376     Michael Madsen        Daryl Hannah             Gordon Liu  
390   Hannah Spearritt   Cynthia Stevenson         Daniel Roebuck  
396    Anjelica Huston         Keith David        Michael McShane  
426        Riley Smith     Jared Padalecki            Drew Pinsky  
481     Johnny Galecki  Rachael Leigh Cook           David Proval  
486  Marcia Gay Harden       Maura Tierney     Christine Baranski  
492        Chris Evans     Bryan Greenberg           Darius Miles  
503         Hugh Grant       Jim Broadbent            Gemma Jones  
532        Regina King      Clifton Powell           Harry Lennix  
536   Cathryn Bradshaw   Steven Mackintosh          Peter Vaughan  
546         Bruce Dern        Scott Wilson    Pruitt Taylor Vince  
547      Patricia Neal      Adrian McElwee         Allan Gurganus  
560  Kiefer Sutherland       Gena Rowlands       Olivier Martinez  
599       Ewen Bremner         Robert Fyfe            Ian McNeice  

[25 rows x 30 columns]
---------- 2005 ----------
                                  title    title_type        genre  runtime  \
45                   The White Countess  Feature Film        Drama    135.0   
101  Pusher III: I'm the Angel of Death  Feature Film        Drama     90.0   
102                   Two for the Money  Feature Film        Drama    122.0   
118                          Dirty Love  Feature Film       Comedy     91.0   
185                    Beyond the Gates  Feature Film        Drama    115.0   
244                 The Devil's Rejects  Feature Film       Horror    107.0   
269     Me and You and Everyone We Know  Feature Film        Drama     91.0   
383                     After Innocence   Documentary  Documentary     95.0   
402                           Guess Who  Feature Film       Comedy    105.0   
460       The Greatest Game Ever Played  Feature Film        Drama    120.0   
461                         Grizzly Man   Documentary  Documentary    103.0   
512                    Little Manhattan  Feature Film        Drama     84.0   
533                        Coach Carter  Feature Film        Drama    136.0   
542                        Just Friends  Feature Film        Drama     96.0   
568                         Saving Face  Feature Film        Drama     91.0   
592                              Capote  Feature Film        Drama    114.0   

    mpaa_rating                          studio  thtr_rel_year  \
45        PG-13          Sony Pictures Classics           2005   
101           R  Nordisk Film Biografdistributi           2005   
102           R              Universal Pictures           2005   
118           R                      First Look           2005   
185           R                  IFC First Take           2005   
244           R                Lions Gate Films           2005   
269           R                       IFC Films           2005   
383     Unrated                New Yorker Films           2005   
402       PG-13                   Sony Pictures           2005   
460          PG            Buena Vista Pictures           2005   
461           R            Lions Gate Releasing           2005   
512          PG                20th Century Fox           2005   
533       PG-13              Paramount Pictures           2005   
542       PG-13                 New Line Cinema           2005   
568           R          Sony Pictures Classics           2005   
592           R          Sony Pictures Classics           2005   

     thtr_rel_month  thtr_rel_day  dvd_rel_year  ...  best_actor_win  \
45               12            21        2006.0  ...              no   
101               9             2        2006.0  ...              no   
102              10             7        2006.0  ...             yes   
118               9            23        2005.0  ...              no   
185              12             8        2007.0  ...              no   
244               7            22        2005.0  ...              no   
269               6            24        2005.0  ...              no   
383              10            21        2007.0  ...              no   
402               3            25        2005.0  ...              no   
460               9            30        2006.0  ...              no   
461               8            12        2005.0  ...              no   
512               9            30        2006.0  ...              no   
533               1            14        2005.0  ...              no   
542              11            23        2006.0  ...              no   
568               5            27        2005.0  ...              no   
592               9            30        2006.0  ...             yes   

     best_actress_win  best_dir_win  top200_box              director  \
45                 no            no          no           James Ivory   
101                no            no          no  Nicolas Winding Refn   
102                no            no          no           D.J. Caruso   
118                no            no          no    John Mallory Asher   
185                no            no          no   Michael Caton-Jones   
244                no            no          no            Rob Zombie   
269                no            no          no          Miranda July   
383                no            no          no       Jessica Sanders   
402                no            no          no        Ashton Kutcher   
460                no            no          no           Bill Paxton   
461                no            no          no         Werner Herzog   
512                no            no          no            Mark Levin   
533                no            no          no         Thomas Carter   
542                no            no          no         Roger  Kumble   
568                no            no          no              Alice Wu   
592                no            no          no        Bennett Miller   

                     actor1               actor2             actor3  \
45            Ralph Fiennes   Natasha Richardson   Vanessa Redgrave   
101            Zlatko Buric         Zlatko Burik     Marinela Dekic   
102               Al Pacino  Matthew McConaughey         Rene Russo   
118          Jenny McCarthy       Carmen Electra  Eddie Kaye Thomas   
185               John Hurt           Hugh Dancy  Dominique Horwitz   
244                Sid Haig         Bill Moseley   William Forsythe   
269             John Hawkes         Miranda July     Miles Thompson   
383           Herman Atkins         Wilton Dedge      Scott Hornoff   
402              Bernie Mac       Ashton Kutcher        Zoe Saldana   
460            Shia LaBeouf      Stephen Dillane       Elias Koteas   
461       Timothy Treadwell    Timothy Treadwell     Amie Huguenard   
512         Josh Hutcherson     Bradley Whitford      Cynthia Nixon   
533       Samuel L. Jackson       Rob Brown (VI)    Robert Ri'chard   
542           Ryan Reynolds            Amy Smart         Anna Faris   
568        Michelle Krusiec            Joan Chen          Lynn Chen   
592  Philip Seymour Hoffman     Catherine Keener       Chris Cooper   

               actor4                        actor5  
45      Lynn Redgrave              Madeleine Potter  
101        Ilyas Agac                Slavko Labovic  
102    Armand Assante                  Jeremy Piven  
118     Kathy Griffin                    Kam Heskin  
185     Louis Mahoney                 Nicola Walker  
244         Ken Foree               Matthew McGrory  
269  Brandon Ratcliff              Carlie Westerman  
383      Dennis Maher                  Vincent Moto  
402      Judith Scott                  Hal Williams  
460      Josh Flitter                   Peyton List  
461    Warren Queeney                  Franc Falico  
512       Charlie Ray                 Willie Garson  
533     Rick Gonzalez                 Nana Gbewonyo  
542       Chris Klein  Christopher George Marquette  
568          Jin Wang                      Li Zhiyu  
592   Bruce Greenwood                   Bob Balaban  

[16 rows x 30 columns]
---------- 2006 ----------
                                               title    title_type  \
14                             School for Scoundrels  Feature Film   
54                                     The Last Kiss  Feature Film   
109                          One Night With the King  Feature Film   
142    In the Name of the King: A Dungeon Siege Tale  Feature Film   
149                                        Clerks II  Feature Film   
179                                     A Good Woman  Feature Film   
197                                   V for Vendetta  Feature Film   
216                                The Darwin Awards  Feature Film   
231                                Failure to Launch  Feature Film   
234       Van Wilder: The Rise of Taj (Van Wilder 2)  Feature Film   
251                                     Catch a Fire  Feature Film   
333                                            49 Up   Documentary   
339                                         The Omen  Feature Film   
358  Jonestown: The Life and Death of Peoples Temple   Documentary   
361                   Conversations With Other Women  Feature Film   
367                                 A Scanner Darkly  Feature Film   
368                                       Hard Candy  Feature Film   
429                             The Astronaut Farmer  Feature Film   
432                                   Deck the Halls  Feature Film   
435                         Turistas (Paradise Lost)  Feature Film   
437                                     The Prestige  Feature Film   
438                                       Waist Deep  Feature Film   
439                             The Science of Sleep  Feature Film   
446                               World Trade Center  Feature Film   
473                                           Hostel  Feature Film   
498                                            Candy  Feature Film   
510                                    Saint of 9/11   Documentary   
586                                   The Lake House  Feature Film   

                  genre  runtime mpaa_rating                       studio  \
14               Comedy    100.0       PG-13                          MGM   
54                Drama    115.0           R                    Paramount   
109               Drama    123.0          PG     Gener8Xion Entertainment   
142  Action & Adventure    127.0       PG-13          Freestyle Releasing   
149               Drama     97.0           R                          MGM   
179               Drama     93.0          PG             Lions Gate Films   
197               Drama    132.0           R        Warner Bros. Pictures   
216               Drama     94.0           R                    Blumhouse   
231               Drama     97.0       PG-13           Paramount Pictures   
234              Comedy     97.0           R                          MGM   
251               Drama    101.0       PG-13               Focus Features   
333         Documentary    180.0     Unrated           First Run Features   
339  Mystery & Suspense    110.0           R             20th Century Fox   
358         Documentary     86.0     Unrated                      7th art   
361               Drama     84.0           R            Fabrication Films   
367               Drama    100.0           R  Warner Independent Pictures   
368               Drama    104.0           R             Lions Gate Films   
429               Drama    104.0          PG  Warner Independent Pictures   
432              Comedy     93.0          PG             20th Century Fox   
435               Drama     93.0           R                   Fox Atomic   
437               Drama    130.0       PG-13         Buena Vista Pictures   
438               Drama     97.0           R               Focus Features   
439               Drama    105.0           R  Warner Independent Pictures   
446               Drama    129.0       PG-13           Paramount Pictures   
473              Horror     94.0           R             Lions Gate Films   
498               Drama    116.0           R                    ThinkFilm   
510         Documentary     90.0     Unrated                          IFC   
586               Drama     99.0          PG        Warner Bros. Pictures   

     thtr_rel_year  thtr_rel_month  thtr_rel_day  dvd_rel_year  ...  \
14            2006               9            23        2007.0  ...   
54            2006               9            15        2006.0  ...   
109           2006              10            13        2007.0  ...   
142           2006              11             3        2008.0  ...   
149           2006               7            21        2006.0  ...   
179           2006               2             3        2006.0  ...   
197           2006               3            17        2006.0  ...   
216           2006               7             5        2007.0  ...   
231           2006               3            10        2006.0  ...   
234           2006              12             1        2007.0  ...   
251           2006              10            27        2007.0  ...   
333           2006              10             6        2006.0  ...   
339           2006               6             6        2006.0  ...   
358           2006              10            20        2007.0  ...   
361           2006               8            11        2007.0  ...   
367           2006               7            28        2006.0  ...   
368           2006               4            14        2006.0  ...   
429           2006              10            15        2007.0  ...   
432           2006              11            22        2007.0  ...   
435           2006              12             1        2007.0  ...   
437           2006              10            20        2007.0  ...   
438           2006               6            23        2006.0  ...   
439           2006               6            18        2007.0  ...   
446           2006               8             9        2007.0  ...   
473           2006               1             6        2006.0  ...   
498           2006              11            17        2007.0  ...   
510           2006               9             6        2006.0  ...   
586           2006               6            16        2006.0  ...   

     best_actor_win  best_actress_win  best_dir_win  top200_box  \
14               no                no            no          no   
54               no                no            no          no   
109              no                no            no          no   
142              no                no            no          no   
149              no                no            no          no   
179              no               yes            no          no   
197              no               yes            no          no   
216              no                no            no          no   
231             yes                no            no          no   
234              no                no            no          no   
251              no                no            no          no   
333              no                no            no          no   
339              no                no            no          no   
358              no                no            no          no   
361              no                no            no          no   
367              no                no            no          no   
368              no                no            no          no   
429              no                no            no          no   
432              no                no            no          no   
435              no                no            no          no   
437              no                no            no          no   
438              no                no            no          no   
439              no                no            no          no   
446             yes                no           yes          no   
473              no                no            no          no   
498             yes                no            no          no   
510              no                no            no          no   
586              no               yes            no          no   

              director               actor1                actor2  \
14       Todd Phillips   Billy Bob Thornton             Jon Heder   
54        Tony Goldwyn           Zach Braff       Jacinda Barrett   
109  Michael O. Sajbel        Peter O'Toole        Tiffany Dupont   
142           Uwe Boll        Jason Statham       Leelee Sobieski   
149        Kevin Smith     Brian O'Halloran         Jeff Anderson   
179        Mike Barker           Helen Hunt    Scarlett Johansson   
197     James McTeigue      Natalie Portman          Hugo Weaving   
216        Finn Taylor       Joseph Fiennes          Winona Ryder   
231            Tom Dey  Matthew McConaughey  Sarah Jessica Parker   
234        Mort Nathan             Kal Penn          Lauren Cohan   
251      Phillip Noyce          Tim Robbins            Derek Luke   
333      Michael Apted         Bruce Balden    Jacqueline Bassett   
339         John Moore         Julia Stiles        Liev Schreiber   
358     Stanley Nelson                  NaN                   NaN   
361        Hans Canosa        Aaron Eckhart        Brian Geraghty   
367  Richard Linklater         Keanu Reeves     Robert Downey Jr.   
368        David Slade           Ellen Page        Patrick Wilson   
429     Michael Polish      Virginia Madsen            Bruce Dern   
432     John Whitesell         Danny DeVito     Matthew Broderick   
435     John Stockwell       Melissa George          Josh Duhamel   
437  Christopher Nolan         Hugh Jackman        Christian Bale   
438        Stan Lathan        Tyrese Gibson           Meagan Good   
439      Michel Gondry   Gael Garcia Bernal             Miou Miou   
446       Oliver Stone         Nicolas Cage          Michael Pena   
473           Eli Roth        Jay Hernandez      Derek Richardson   
498      Neil Armfield         Heath Ledger         Abbie Cornish   
510      Glenn Holsten         Ian McKellen                   NaN   
586  Alejandro Agresti         Keanu Reeves        Sandra Bullock   

                   actor3                  actor4               actor5  
14        Jacinda Barrett   Michael Clarke Duncan         Horatio Sanz  
54          Casey Affleck           Rachel Bilson       Michael Weston  
109           Omar Sharif               Luke Goss     John Rhys-Davies  
142      John Rhys-Davies             Ron Perlman       Claire Forlani  
149        Rosario Dawson             Jason Mewes       Trevor Fehrman  
179         Tom Wilkinson  Stephen Campbell Moore          Mark Umbers  
197           Stephen Rea               John Hurt          Stephen Fry  
216            Chris Penn       Wilmer Valderrama     Tim Blake Nelson  
231       Zooey Deschanel           Justin Bartha       Bradley Cooper  
234          Dan Percival         Daniel Percival           Glen Barry  
251          Bonnie Henna       Mncedisi Shabangu     Tumisho K. Masha  
333     Symon Basterfield       Andrew Brackfield          John Brisby  
339            Mia Farrow           David Thewlis   Pete Postlethwaite  
358                   NaN                     NaN                  NaN  
361         Brianna Brown            Olivia Wilde        Thomas Lennon  
367       Woody Harrelson            Winona Ryder        Rory Cochrane  
368             Sandra Oh         Jennifer Holmes     G.J. Echternkamp  
429      Tim Blake Nelson           Jasper Polish         Logan Polish  
432         Kristin Davis       Kristin Chenoweth         Alia Shawkat  
435          Olivia Wilde           Desmond Askew         Beau Garrett  
437         Michael Caine            Piper Perabo         Rebecca Hall  
438              The Game     Paul Terrel Clayton          Darris Love  
439  Charlotte Gainsbourg            Alain Chabat            Miou-Miou  
446     Maggie Gyllenhaal             Maria Bello        Stephen Dorff  
473     Eythor Gudjonsson              Shane Daly  Barbara Nedeljakova  
498         Geoffrey Rush             Tony Martin      Noni Hazelhurst  
510                   NaN                     NaN                  NaN  
586    Shohreh Aghdashloo             Dylan Walsh  Christopher Plummer  

[28 rows x 30 columns]
---------- 2007 ----------
                                         title    title_type  \
20                                 Dragon Wars  Feature Film   
34                               I'm Not There  Feature Film   
51                       Breaking and Entering  Feature Film   
59                           Then She Found Me  Feature Film   
88                    Dirty Sanchez: The Movie   Documentary   
99                               The Comebacks  Feature Film   
114                               Shoot 'Em Up  Feature Film   
131  Fantastic Four: Rise of the Silver Surfer  Feature Film   
154                                Rescue Dawn  Feature Film   
167                             A Mighty Heart  Feature Film   
277                                The Kingdom  Feature Film   
291                       The Brothers Solomon  Feature Film   
301                    Rise of the Footsoldier  Feature Film   
307                                   Cashback  Feature Film   
308                                   The Host  Feature Film   
325                                 Epic Movie  Feature Film   
365                     Resurrecting the Champ  Feature Film   
392                                   The Take  Feature Film   
440                                     Gracie  Feature Film   
451                     No Country for Old Men  Feature Film   
501                       Ghosts of Abu Ghraib   Documentary   
504                     Code Name: The Cleaner  Feature Film   
523                                     The Ex  Feature Film   
531      Sea Monsters: A Prehistoric Adventure   Documentary   
540                                    Shooter  Feature Film   
555             Pete Seeger: The Power of Song   Documentary   
565                                Snow Angels  Feature Film   
589                               The Invasion  Feature Film   

                  genre  runtime mpaa_rating  \
20                Drama     90.0       PG-13   
34                Drama    135.0           R   
51                Drama    120.0           R   
59                Drama    100.0           R   
88               Comedy     94.0           R   
99               Comedy     84.0       PG-13   
114               Drama     86.0           R   
131  Action & Adventure     92.0          PG   
154               Drama    120.0       PG-13   
167               Drama    108.0           R   
277               Drama    110.0           R   
291              Comedy     93.0           R   
301  Action & Adventure    119.0           R   
307               Drama    102.0           R   
308               Drama    120.0           R   
325  Action & Adventure     86.0           R   
365               Drama    112.0       PG-13   
392               Drama     96.0           R   
440               Drama     95.0       PG-13   
451               Drama    122.0           R   
501         Documentary     78.0     Unrated   
504  Action & Adventure     84.0       PG-13   
523              Comedy     89.0       PG-13   
531         Documentary     40.0           G   
540               Drama    124.0           R   
555         Documentary     93.0          PG   
565               Drama    107.0           R   
589  Mystery & Suspense     99.0       PG-13   

                               studio  thtr_rel_year  thtr_rel_month  \
20   Sony Pictures Home Entertainment           2007               9   
34                  The Weinstein Co.           2007              11   
51              The Weinstein Company           2007               2   
59                          ThinkFilm           2007               9   
88                                NaN           2007               9   
99                         Fox Atomic           2007              10   
114                   New Line Cinema           2007               9   
131                  20th Century Fox           2007               6   
154                               MGM           2007               7   
167                 Paramount Vantage           2007               6   
277                Universal Pictures           2007               9   
291                       Screen Gems           2007               9   
301             Carnaby International           2007               9   
307                 Magnolia Pictures           2007               4   
308                 Magnolia Pictures           2007               3   
325                  20th Century Fox           2007               1   
365         Yari Film Group Releasing           2007               8   
392                     Hatchet Films           2007               4   
440                      Picturehouse           2007               6   
451                     Miramax Films           2007              11   
501                         HBO Video           2007               6   
504                   New Line Cinema           2007               1   
523                 The Weinstein Co.           2007               5   
531               National Geographic           2007              10   
540                Paramount Pictures           2007               3   
555             The Weinstein Company           2007               4   
565                Warner Independent           2007               1   
589            Warners Bros. Pictures           2007               8   

     thtr_rel_day  dvd_rel_year  ...  best_actor_win  best_actress_win  \
20             13        2008.0  ...              no                no   
34             21        2008.0  ...              no               yes   
51             16        2007.0  ...              no                no   
59              7        2008.0  ...             yes               yes   
88             11        2007.0  ...              no                no   
99             19        2008.0  ...              no                no   
114             7        2008.0  ...              no                no   
131            15        2007.0  ...              no                no   
154            27        2007.0  ...              no                no   
167            22        2007.0  ...              no                no   
277            28        2007.0  ...             yes                no   
291             7        2007.0  ...              no                no   
301             7        2008.0  ...              no                no   
307            20        2007.0  ...              no                no   
308             9        2007.0  ...              no                no   
325            26        2007.0  ...              no                no   
365            24        2008.0  ...              no                no   
392            11        2008.0  ...              no                no   
440             1        2007.0  ...              no                no   
451            21        2009.0  ...              no                no   
501             1        2007.0  ...              no                no   
504             5        2007.0  ...              no                no   
523            11        2007.0  ...              no                no   
531             5        2008.0  ...              no                no   
540            23        2007.0  ...              no                no   
555            29        2008.0  ...              no                no   
565            19        2008.0  ...              no                no   
589            17        2008.0  ...              no               yes   

     best_dir_win  top200_box               director             actor1  \
20             no          no         Hyung-rae Shim         Jason Behr   
34             no          no            Todd Haynes     Cate Blanchett   
51            yes          no      Anthony Minghella           Jude Law   
59             no          no             Helen Hunt         Helen Hunt   
88             no          no             Jim Hickey        Lee Dainton   
99             no          no              Tom Brady     David Koechner   
114            no          no          Michael Davis         Clive Owen   
131            no          no              Tim Story      Ioan Gruffudd   
154            no          no          Werner Herzog     Christian Bale   
167            no          no   Michael Winterbottom     Angelina Jolie   
277            no          no             Peter Berg         Jamie Foxx   
291            no          no           Bob Odenkirk        Will Arnett   
301            no          no          Julian Gilbey      Ricci Harnett   
307            no          no             Sean Ellis   Sean Biggerstaff   
308            no          no           Bong Joon-ho       Song Kang-ho   
325            no          no          Aaron Seltzer           Kal Penn   
365            no          no              Rod Lurie  Samuel L. Jackson   
392            no          no            Brad Furman     John Leguizamo   
440            no          no       Davis Guggenheim    Carly Schroeder   
451           yes          no              Joel Coen    Tommy Lee Jones   
501            no          no           Rory Kennedy       Alberto Mora   
504            no          no           Les Mayfield           Lucy Liu   
523            no          no           Jesse Peretz         Zach Braff   
531            no          no  Sean MacLeod Phillips     Liev Schreiber   
540            no          no          Antoine Fuqua      Mark Wahlberg   
555            no          no              Jim Brown       Pete  Seeger   
565            no          no     David Gordon Green    Kate Beckinsale   
589            no          no    Oliver Hirschbiegel      Nicole Kidman   

                     actor2                actor3             actor4  \
20            Amanda Brooks        Robert Forster       Aimee Garcia   
34           Christian Bale          Richard Gere       Heath Ledger   
51         Juliette Binoche          Robin Wright     Martin Freeman   
59             Bette Midler           Colin Firth  Matthew Broderick   
88                Dan Joyce  Michael Pancho Locke     Matt Pritchard   
99            Carl Weathers         Melora Hardin   Matthew Lawrence   
114           Paul Giamatti       Monica Bellucci   Stephen McHattie   
131            Jessica Alba           Chris Evans    Michael Chiklis   
154              Steve Zahn         Jeremy Davies      Marshall Bell   
167           Dan Futterman        Archie Panjabi         Irfan Khan   
277            Chris Cooper       Jennifer Garner      Jason Bateman   
291              Will Forte           Chi McBride       Kristen Wiig   
301         Craig Fairbrass           Terry Stone   Roland Manookian   
307              Emilia Fox           Shaun Evans      Michelle Ryan   
308             Park Hae-il        Byeon Hie-bong          Du-na Bae   
325           Adam Campbell            Jayma Mays  Faune A. Chambers   
365           Josh Hartnett        Kathryn Morris          Alan Alda   
392           Tyrese Gibson           Rosie Perez    Bobby Cannavale   
440          Elisabeth Shue       Dermot Mulroney        Andrew Shue   
451           Javier Bardem           Josh Brolin    Woody Harrelson   
501                John Yoo          Scott Horton        Mark Danner   
504  Cedric the Entertainer   Nicollette Sheridan      Mark Dacascos   
523             Amanda Peet         Jason Bateman     Charles Grodin   
531                     NaN                   NaN                NaN   
540            Michael Pena          Danny Glover          Kate Mara   
555       Bruce Springsteen        Natalie Maines         Tom Paxton   
565            Sam Rockwell      Michael Angarano         Nicky Katt   
589            Daniel Craig        Jeremy Northam     Jeffrey Wright   

                   actor5  
20         Craig Robinson  
34   Marcus Carl Franklin  
51           Ray Winstone  
59           Ben Shenkman  
88           Howard Marks  
99           Brooke Nevin  
114             Greg Bryk  
131        Julian McMahon  
154     Teerawat Mulvilai  
167           Will Patton  
277         Ashraf Barhom  
291         Malin Akerman  
301          Coralie Rose  
307        Stuart Goodwin  
308            Ko Ah-sung  
325        Crispin Glover  
365        Rachel Nichols  
392           Yul Vazquez  
440          Joshua Caras  
451       Kelly Macdonald  
501          Alfred McCoy  
504   Callum Keith Rennie  
523            Mia Farrow  
531                   NaN  
540          Elias Koteas  
555         David Dunaway  
565      Jeanetta Arnette  
589          Jackson Bond  

[28 rows x 30 columns]
---------- 2008 ----------
                                       title    title_type  \
16                        Burn After Reading  Feature Film   
49                              Seven Pounds  Feature Film   
81                                Visioneers  Feature Film   
116                            Made of Honor  Feature Film   
155                            The Longshots  Feature Film   
164                               Kicking It   Documentary   
209       Nick and Norah's Infinite Playlist  Feature Film   
212                     Let the Right One In  Feature Film   
229                              Man on Wire   Documentary   
230              Madagascar: Escape 2 Africa  Feature Film   
232                       London to Brighton  Feature Film   
260  Hellboy II: The Golden Army (Hellboy 2)  Feature Film   
312                       The End of America   Documentary   
324                              Man on Wire   Documentary   
349                           Disaster Movie  Feature Film   
362                             Sleepwalking  Feature Film   
515                                  Mirrors  Feature Film   
526                                   Wanted  Feature Film   
551                                    Felon  Feature Film   
581                              Fool's Gold  Feature Film   
596                       Death Defying Acts  Feature Film   
598                        Dance of the Dead  Feature Film   

                  genre  runtime mpaa_rating                       studio  \
16                Drama     96.0           R               Focus Features   
49                Drama    123.0       PG-13                Sony Pictures   
81                Drama     94.0           R                     Gravitas   
116              Comedy    101.0       PG-13       Sony Pictures/Columbia   
155               Drama     94.0          PG        The Weinstein Company   
164         Documentary     98.0     Unrated     Liberation Entertainment   
209              Comedy     90.0       PG-13    Sony Pictures/Screen Gems   
212               Drama    115.0           R     Magnet/Magnolia Pictures   
229         Documentary     94.0       PG-13            Magnolia Pictures   
230  Action & Adventure     89.0          PG            Paramount Studios   
232  Mystery & Suspense     85.0           R               Outsider Films   
260  Action & Adventure    120.0       PG-13           Universal Pictures   
312         Documentary      NaN     Unrated                      Indipix   
324         Documentary     94.0       PG-13            Magnolia Pictures   
349              Comedy     87.0       PG-13                    Lionsgate   
362               Drama    101.0           R               Overture Films   
515  Mystery & Suspense    110.0           R                  Buena Vista   
526  Action & Adventure    110.0           R           Universal Pictures   
551               Drama    104.0           R  Sony Pictures Entertainment   
581  Action & Adventure    112.0       PG-13        Warner Bros. Pictures   
596               Drama     97.0          PG           Genius Productions   
598  Action & Adventure     87.0           R     Grindhouse Entertainment   

     thtr_rel_year  thtr_rel_month  thtr_rel_day  dvd_rel_year  ...  \
16            2008               8            27        2008.0  ...   
49            2008              12            19        2009.0  ...   
81            2008               6            12        2009.0  ...   
116           2008               5             2        2008.0  ...   
155           2008               8            22        2008.0  ...   
164           2008               6            13        2008.0  ...   
209           2008              10             3        2009.0  ...   
212           2008               1            26        2009.0  ...   
229           2008               1            22        2008.0  ...   
230           2008              11             7        2009.0  ...   
232           2008               2             8        2005.0  ...   
260           2008               6            28        2008.0  ...   
312           2008              10             1        2009.0  ...   
324           2008               1            22        2008.0  ...   
349           2008               8            29        2009.0  ...   
362           2008               1            22        2008.0  ...   
515           2008               8            15        2009.0  ...   
526           2008               6            12        2008.0  ...   
551           2008               7            17        2008.0  ...   
581           2008               2             8        2008.0  ...   
596           2008               7            11        2008.0  ...   
598           2008               3             9        2008.0  ...   

     best_actor_win  best_actress_win  best_dir_win  top200_box  \
16               no               yes           yes          no   
49               no                no            no          no   
81               no                no            no          no   
116              no                no            no          no   
155              no                no            no          no   
164              no                no            no          no   
209              no                no            no          no   
212              no                no            no          no   
229              no                no            no          no   
230              no                no            no          no   
232              no                no            no          no   
260              no                no            no          no   
312              no                no            no          no   
324              no                no            no          no   
349              no                no            no          no   
362              no               yes            no          no   
515              no                no            no          no   
526              no                no            no          no   
551              no                no            no          no   
581             yes                no            no          no   
596              no                no            no          no   
598              no                no            no          no   

                 director               actor1                actor2  \
16              Joel Coen       George Clooney     Frances McDormand   
49       Gabriele Muccino       Rosario Dawson       Woody Harrelson   
81            Jared Drake    Zach Galifianakis            Judy Greer   
116          Paul Weiland      Patrick Dempsey     Michelle Monaghan   
155            Fred Durst             Ice Cube           Keke Palmer   
164           Jeff Werner        Colin Farrell       Brandon Francis   
209         Peter Sollett         Michael Cera          Kat Dennings   
212       Tomas Alfredson       Kare Hedebrant      Lina Leandersson   
229           James Marsh       Philippe Petit           Alan Welner   
230           Tom McGrath          Ben Stiller            Chris Rock   
232  Paul Andrew Williams     Lorraine Stanley        Georgia Groome   
260    Guillermo del Toro          Ron Perlman           Selma Blair   
312         Anne Sundberg           Naomi Wolf                   NaN   
324           James Marsh       Philippe Petit           Alan Welner   
349         Aaron Seltzer          Matt Lanter        Kim Kardashian   
362            Bill Maher      Charlize Theron            Nick Stahl   
515         Alexandre Aja    Kiefer Sutherland          Paula Patton   
526     Timur Bekmambetov         James McAvoy        Morgan Freeman   
551       Ric Roman Waugh           Val Kilmer  Harold Perrineau Jr.   
581          Andy Tennant  Matthew McConaughey           Kate Hudson   
596     Gillian Armstrong           Guy Pearce  Catherine Zeta-Jones   
598          Gregg Bishop        Jared Kusnitz      Greyson Chadwick   

                actor3              actor4                actor5  
16      John Malkovich           Brad Pitt         Tilda Swinton  
49        Michael Ealy        Barry Pepper      Elpidia Carrillo  
81         Mia Maestro          Missi Pyle         Aubrey Morris  
116       Kevin Mckidd    Kathleen Quinlan        Sydney Pollack  
155        Tasha Smith    Jill Marie Jones            Dash Mihok  
164                NaN                 NaN                   NaN  
209      Alexis Dziena         Ari Graynor             Aaron Yoo  
212         Per Ragnar         Henrik Dahl       Karin Bergquist  
229        Annie Allix           Jim Moore  Jean Francois Heckel  
230    David Schwimmer  Jada Pinkett Smith     Sacha Baron Cohen  
232      Johnny Harris    Nathan Constance           Sam Spruell  
260     Jeffrey Tambor           Luke Goss        John Alexander  
312                NaN                 NaN                   NaN  
324        Annie Allix           Jim Moore  Jean Francois Heckel  
349     Vanessa Lachey      Carmen Electra               G-Thang  
362    Annasophia Robb       Dennis Hopper       Woody Harrelson  
515        Erica Gluck       Cameron Boyce       Ezra Buzzington  
526     Angelina Jolie       Terence Stamp    Thomas Kretschmann  
551        Sam Shepard       Nick Chinlund       Marisol Nichols  
581  Donald Sutherland       Alexis Dziena          Ewen Bremner  
596      Timothy Spall       Saoirse Ronan           Jack Bailey  
598     Chandler Darby  Carissa Capobianco        Randy McDowell  

[22 rows x 30 columns]
---------- 2009 ----------
                                                 title    title_type  \
6                                          Old Partner   Documentary   
25                           The Yes Men Fix the World   Documentary   
61   Most Dangerous Man in America: Daniel Ellsberg...   Documentary   
132                                       The Hangover  Feature Film   
191                                  Sunshine Cleaning  Feature Film   
204                                 Madea Goes to Jail  Feature Film   
262                                     Love the Beast   Documentary   
354                                    The Hurt Locker  Feature Film   
379                                        Dance Flick  Feature Film   
382                 Underworld: The Rise of the Lycans  Feature Film   
436                                        New In Town  Feature Film   
454                                               Dare  Feature Film   
477                           The Time Traveler's Wife  Feature Film   
493                                  A Perfect Getaway  Feature Film   
505                                     Fast & Furious  Feature Film   
554                               Astro Boy (AstroBoy)  Feature Film   

                  genre  runtime mpaa_rating                     studio  \
6           Documentary     78.0     Unrated         Shcalo Media Group   
25          Documentary     87.0     Unrated              Cinetic Media   
61          Documentary     92.0     Unrated         First Run Features   
132              Comedy    100.0           R      Warner Bros. Pictures   
191              Comedy     91.0           R             Overture Films   
204               Drama    103.0       PG-13                  Lionsgate   
262         Documentary     92.0           R       Madman Entertainment   
354               Drama    131.0           R       Summit Entertainment   
379  Action & Adventure     83.0       PG-13          Paramount Studios   
382  Action & Adventure     92.0           R  Sony Pictures/Screen Gems   
436              Comedy     97.0          PG            Lionsgate Films   
454               Drama     92.0           R        Image Entertainment   
477               Drama    107.0       PG-13      Warner Bros. Pictures   
493  Mystery & Suspense     98.0           R         Universal Pictures   
505  Mystery & Suspense    107.0       PG-13         Universal Pictures   
554  Action & Adventure     94.0          PG       Summit Entertainment   

     thtr_rel_year  thtr_rel_month  thtr_rel_day  dvd_rel_year  ...  \
6             2009               1            15        2010.0  ...   
25            2009               1            18        2010.0  ...   
61            2009               6             1        2010.0  ...   
132           2009               6             5        2009.0  ...   
191           2009               3            13        2009.0  ...   
204           2009               2            20        2009.0  ...   
262           2009               3            12        2010.0  ...   
354           2009               6            26        2010.0  ...   
379           2009               5            22        2009.0  ...   
382           2009               1            23        2009.0  ...   
436           2009               1            30        2009.0  ...   
454           2009              11            13        2010.0  ...   
477           2009               8            14        2010.0  ...   
493           2009               8             7        2009.0  ...   
505           2009               4             3        2009.0  ...   
554           2009              10            23        2010.0  ...   

     best_actor_win  best_actress_win  best_dir_win  top200_box  \
6                no                no            no          no   
25               no                no            no          no   
61               no                no            no          no   
132              no                no            no         yes   
191              no                no            no          no   
204              no                no            no          no   
262              no                no            no          no   
354              no                no           yes          no   
379              no                no            no          no   
382              no                no            no          no   
436              no                no            no          no   
454              no                no            no          no   
477              no                no            no          no   
493              no                no            no          no   
505              no                no            no          no   
554             yes                no            no          no   

               director             actor1                  actor2  \
6       Chung-ryoul Lee      Choi Won-kyun            Lee Sam-soon   
25       Andy Bichlbaum     Andy Bichlbaum            Reggie Waits   
61       Judith Ehrlich    Daniel Ellsberg  Patricia Marx Ellsberg   
132       Todd Phillips     Bradley Cooper                Ed Helms   
191     Christine Jeffs          Amy Adams             Emily Blunt   
204         Tyler Perry        Tyler Perry              Derek Luke   
262           Eric Bana          Eric Bana                Jay Leno   
354     Kathryn Bigelow      Jeremy Renner          Anthony Mackie   
379       Damien Wayans     Essence Atkins            Shawn Wayans   
382  Patrick Tatopoulos         Bill Nighy           Michael Sheen   
436         Jonas Elmer  Harry Connick Jr.           Rashida Jones   
454          Adam Salky        Emmy Rossum            Zach Gilford   
477    Robert Schwentke     Rachel McAdams               Eric Bana   
493         David Twohy         Steve Zahn        Timothy Olyphant   
505          Justin Lin         Vin Diesel             Paul Walker   
554        David Bowers   Freddie Highmore            Nicolas Cage   

                    actor3             actor4              actor5  
6                      Moo                NaN                 NaN  
25            Mike Bonanno                NaN                 NaN  
61            Richard Falk   Thomas Schelling     Thomas Oliphant  
132      Zach Galifianakis      Justin Bartha      Heather Graham  
191             Alan Arkin      Jason Spevack          Steve Zahn  
204  Keshia Knight Pulliam        Ion Overman       Sofia Vergara  
262            Phil McGraw    Jeremy Clarkson        Barry Oliver  
354         Brian Geraghty         Guy Pearce       Ralph Fiennes  
379         Shoshanna Bush      Marlon Wayans    Damon Wayans Jr.  
382            Rhona Mitra  Steven Mackintosh      Kevin Grevioux  
436         Siobhan Fallon       J.K. Simmons      Frances Conroy  
454        Ashley Springer       Ana Gasteyer        Alan Cumming  
477          Arliss Howard     Ron Livingston  Stephen Tobolowsky  
493         Milla Jovovich      Kiele Sanchez      Marley Shelton  
505     Michelle Rodriguez         John Ortiz    Jordana Brewster  
554           Kristen Bell        Nathan Lane         Eugene Levy  

[16 rows x 30 columns]
---------- 2010 ----------
                                 title    title_type               genre  \
23                        Tamara Drewe  Feature Film               Drama   
33                 Alice in Wonderland  Feature Film  Action & Adventure   
85               North Face (Nordwand)  Feature Film               Drama   
87                            The Reef  Feature Film  Mystery & Suspense   
112                             Bhutto   Documentary         Documentary   
163                         Conviction  Feature Film               Drama   
274                      Winter's Bone  Feature Film               Drama   
288               I Spit On Your Grave  Feature Film              Horror   
303                      Morning Glory  Feature Film              Comedy   
317                          Hereafter  Feature Film  Mystery & Suspense   
335                          Fair Game  Feature Film               Drama   
337              Max Manus: Man of War  Feature Film               Drama   
399                         Date Night  Feature Film              Comedy   
419   The Disappearance of Alice Creed  Feature Film  Mystery & Suspense   
427                     Blue Valentine  Feature Film               Drama   
490                  Countdown to Zero   Documentary         Documentary   
517                            Flipped  Feature Film               Drama   
548                  Teenage Paparazzo   Documentary         Documentary   
561  The Illusionist (L'illusionniste)  Feature Film               Drama   
563                  The Tillman Story   Documentary         Documentary   

     runtime mpaa_rating                             studio  thtr_rel_year  \
23     107.0           R             Sony Pictures Classics           2010   
33     108.0          PG               Walt Disney Pictures           2010   
85     126.0     Unrated                    Music Box Films           2010   
87      94.0           R                Image Entertainment           2010   
112    111.0     Unrated            First Run Entertainment           2010   
163    107.0           R                    Fox Searchlight           2010   
274    100.0           R               Roadside Attractions           2010   
288    108.0           R                   Anchor Bay Films           2010   
303    107.0       PG-13                  Paramount Studios           2010   
317    129.0       PG-13              Warner Bros. Pictures           2010   
335    108.0       PG-13               Summit Entertainment           2010   
337    118.0     Unrated  Nordisk Film Biograf Distribution           2010   
399     88.0       PG-13                   20th Century Fox           2010   
419     96.0           R           Anchor Bay Entertainment           2010   
427    112.0           R                  Weinstein Company           2010   
490     89.0          PG                  Magnolia Pictures           2010   
517     90.0          PG              Warner Bros. Pictures           2010   
548     94.0     Unrated                    HBO Documentary           2010   
561     80.0          PG             Sony Pictures Classics           2010   
563     94.0           R              The Weinstein Company           2010   

     thtr_rel_month  thtr_rel_day  dvd_rel_year  ...  best_actor_win  \
23               10             8        2011.0  ...              no   
33                3             5        2010.0  ...              no   
85                1            29        2010.0  ...              no   
87                5            15        2011.0  ...              no   
112              12             3        2011.0  ...              no   
163              10            15        2011.0  ...              no   
274               6            11        2010.0  ...              no   
288              10             8        2011.0  ...              no   
303              11            10        2011.0  ...              no   
317              10            22        2011.0  ...              no   
335              11             5        2011.0  ...             yes   
337               9             3        2011.0  ...              no   
399               4             9        2010.0  ...              no   
419               8             6        2010.0  ...              no   
427              12            29        2011.0  ...              no   
490               7            23        2010.0  ...              no   
517               8             6        2010.0  ...              no   
548              12            31        2011.0  ...              no   
561              12            25        2011.0  ...              no   
563               8            20        2011.0  ...              no   

     best_actress_win  best_dir_win  top200_box          director  \
23                 no            no          no    Stephen Frears   
33                 no            no          no        Tim Burton   
85                 no            no          no    Philipp Stolzl   
87                 no            no          no    Andrew Traucki   
112                no            no          no    Duane Baughman   
163                no            no          no      Tony Goldwyn   
274               yes            no          no      Debra Granik   
288                no            no          no  Steven R. Monroe   
303               yes            no          no     Roger Michell   
317                no           yes          no    Clint Eastwood   
335                no            no          no        Doug Liman   
337                no            no          no  Joachim Roenning   
399                no            no          no        Shawn Levy   
419                no            no          no        J Blakeson   
427                no            no          no     Andrij Parekh   
490                no            no          no       Lucy Walker   
517                no            no          no        Rob Reiner   
548                no            no          no    Adrian Grenier   
561                no            no          no    Sylvain Chomet   
563                no            no          no      Amir Bar-Lev   

                    actor1                 actor2               actor3  \
23          Gemma Arterton            Roger Allam            Bill Camp   
33             Johnny Depp         Mia Wasikowska        Anne Hathaway   
85           Benno Furmann          Florian Lukas      Johanna Wokalek   
87   Damian Walshe-Howling             Zoe Naylor   Adrienne Pickering   
112              Tariq Ali             Reza Aslan          Diana Aveni   
163           Sam Rockwell          Minnie Driver          Melissa Leo   
274      Jennifer Lawrence            John Hawkes      Kevin Breznahan   
288           Sarah Butler           Jeff Branson        Andrew Howard   
303         Rachel McAdams          Harrison Ford         Diane Keaton   
317             Matt Damon    Bryce Dallas Howard             Jay Mohr   
335            Naomi Watts              Sean Penn         Bruce McGill   
337           Askel Hennie           Aksel Hennie      Agnes Kittelsen   
399           Steve Carell               Tina Fey        Mark Wahlberg   
419         Gemma Arterton        Martin Compston         Eddie Marsan   
427           Ryan Gosling      Michelle Williams        Faith Wladyka   
490   Valerie Plame Wilson  Valerine Plame Wilson  Rolf Mowatt-Larssen   
517       Madeline Carroll       Callan McAuliffe    Rebecca De Mornay   
548        Alwy Visschedyk          Henry Jenkins    Austin Visschedyk   
561      Jean-Claude Donda          Eilidh Rankin       Duncan MacNeil   
563            Josh Brolin         Dannie Tillman      Richard Tillman   

                    actor4              actor5  
23          Dominic Cooper          Luke Evans  
33    Helena Bonham Carter          Matt Lucas  
85         Georg Friedrich       Simon Schwarz  
87          Gyton Grantley  Kieran Darcy-Smith  
112         Benazir Bhutto       Fatima Bhutto  
163        Peter Gallagher         Ari Graynor  
274            Dale Dickey    Garret Dillahunt  
288        Daniel Franzese      Rodney Eastman  
303         Patrick Wilson       Jeff Goldblum  
317           Richard Kind     Frankie McLaren  
335          Michael Kelly          Ty Burrell  
337    Nicolai Cleve Broch           Ken Duken  
399       Taraji P. Henson       Jimmi Simpson  
419                    NaN                 NaN  
427             John Doman          Mike Vogel  
490  Lawrence Scott Sheets            Zia Mian  
517        Anthony Edwards        John Mahoney  
548           Jake Halpern      Adrian Grenier  
561         Raymond Mearns                 NaN  
563   Patrick Tillman, Sr.       Marie Tillman  

[20 rows x 30 columns]
---------- 2011 ----------
                                            title    title_type  \
79                                        Warrior  Feature Film   
100                               The Other Woman  Feature Film   
120                     A Good Old Fashioned Orgy  Feature Film   
125                                 Jack and Jill  Feature Film   
180                                         Drive  Feature Film   
193                             Better This World   Documentary   
214                       Nostalgia for the Light   Documentary   
282                                     Apollo 18  Feature Film   
285                                   Young Adult  Feature Film   
353                                       Tabloid   Documentary   
355                                 Benda Bilili!   Documentary   
364                                   Dream House  Feature Film   
366                                      The Help  Feature Film   
371                                The Last Lions   Documentary   
406                                   Melancholia  Feature Film   
413                                       One Day  Feature Film   
415  Cameraman: The Life And Work Of Jack Cardiff   Documentary   
418                                 Brighton Rock  Feature Film   
511                                   Black Death  Feature Film   
525                                    Real Steel  Feature Film   

                         genre  runtime mpaa_rating  \
79                       Drama    140.0       PG-13   
100                      Drama    102.0           R   
120                     Comedy     95.0           R   
125                     Comedy     91.0          PG   
180                      Drama    100.0           R   
193                Documentary     82.0     Unrated   
214                Documentary     90.0     Unrated   
282  Science Fiction & Fantasy     86.0       PG-13   
285                      Drama     94.0           R   
353                Documentary     87.0           R   
355                Documentary     85.0       PG-13   
364         Mystery & Suspense     92.0       PG-13   
366                      Drama    146.0       PG-13   
371                Documentary     88.0          PG   
406                      Drama    130.0           R   
413                      Drama    107.0       PG-13   
415                Documentary     86.0     Unrated   
418         Mystery & Suspense    111.0           R   
511                      Drama    102.0           R   
525                      Drama    127.0       PG-13   

                                studio  thtr_rel_year  thtr_rel_month  \
79                           Lionsgate           2011               9   
100                          IFC Films           2011               2   
120               Samuel Goldwyn Films           2011               9   
125                      Sony Pictures           2011              11   
180                       FilmDistrict           2011               9   
193               Independent Pictures           2011               9   
214                       Icarus Films           2011               3   
282              The Weinstein Company           2011               9   
285                  Paramount Studios           2011              12   
353                          IFC Films           2011               7   
355  National Geographic Entertainment           2011               9   
364                 Universal Pictures           2011               9   
366                 DreamWorks Studios           2011               8   
371  National Geographic Entertainment           2011               2   
406                  Magnolia Pictures           2011              11   
413                     Focus Features           2011               8   
415               Independent Pictures           2011               5   
418                          IFC Films           2011               8   
511                   Magnet Releasing           2011               3   
525               Walt Disney Pictures           2011              10   

     thtr_rel_day  dvd_rel_year  ...  best_actor_win  best_actress_win  \
79              9        2011.0  ...              no                no   
100             4        2011.0  ...              no               yes   
120             2        2011.0  ...              no                no   
125            11        2012.0  ...             yes                no   
180            16        2012.0  ...              no                no   
193            16        2012.0  ...              no                no   
214            18        2011.0  ...              no                no   
282             2        2011.0  ...              no                no   
285            16        2012.0  ...              no               yes   
353            15        2011.0  ...              no                no   
355            30        2012.0  ...              no                no   
364            30        2012.0  ...              no                no   
366            10        2011.0  ...              no                no   
371            18        2012.0  ...             yes                no   
406            11        2012.0  ...              no                no   
413            19        2011.0  ...              no                no   
415            13        2011.0  ...             yes                no   
418            26        2011.0  ...              no               yes   
511            11        2011.0  ...             yes                no   
525             7        2012.0  ...              no                no   

     best_dir_win  top200_box               director           actor1  \
79             no          no         Gavin O'Connor    Joel Edgerton   
100            no          no               Don Roos  Natalie Portman   
120            no          no           Alex Gregory   Jason Sudeikis   
125            no          no           Dennis Dugan     Adam Sandler   
180            no          no   Nicolas Winding Refn     Ryan Gosling   
193            no          no            Kelly Duane     Brad Crowder   
214            no          no        Patricio Guzman     Gaspar Galaz   
282            no          no  Gonzalo Lopez-Gallego  Warren Christie   
285            no          no          Jason Reitman  Charlize Theron   
353            no          no           Errol Morris   Joyce McKinney   
355            no          no  Florent de la Tullaye     Makemo Nzale   
364            no          no           Jim Sheridan     Daniel Craig   
366            no          no            Tate Taylor       Emma Stone   
371            no          no         Dereck Joubert     Jeremy Irons   
406            no          no         Lars von Trier    Kirsten Dunst   
413            no          no          Lone Scherfig    Anne Hathaway   
415            no          no           Craig McCall  Martin Scorsese   
418            no          no            Rowan Joffe        Sam Riley   
511            no          no      Christopher Smith        Sean Bean   
525            no          no             Shawn Levy     Hugh Jackman   

                      actor2               actor3                  actor4  \
79                 Tom Hardy           Nick Nolte  Jennifer Morrison (II)   
100              Lisa Kudrow          Scott Cohen           Charlie Tahan   
120              Leslie Bibb            Lake Bell          Michelle Borth   
125                Al Pacino         Katie Holmes           Elodie Tougne   
180           Carey Mulligan        Albert Brooks          Bryan Cranston   
193              David McKay        Brandon Darby             E.K. Wilson   
214    Lautaro Nunez de Arco       Luis Henriquez           Miguel Lawner   
282               Lloyd Owen         Ryan Robbins           Michael Kopsa   
285            Patton Oswalt       Patrick Wilson        Elizabeth Reaser   
353             Jackson Shaw           Peter Tory           Troy Williams   
355  Theo "Coude" Nsituvuidi   Zadis Mbulu Nzungu     Djunana Tanga-Suele   
364             Rachel Weisz          Naomi Watts            Elias Koteas   
366              Viola Davis  Bryce Dallas Howard         Octavia Spencer   
371                      NaN                  NaN                     NaN   
406     Charlotte Gainsbourg    Kiefer Sutherland               John Hurt   
413             Jim Sturgess            Tom Mison         Jodie Whittaker   
415             Kirk Douglas        Lauren Bacall         Charlton Heston   
418       Andrea Riseborough         Helen Mirren               John Hurt   
511           Eddie Redmayne    Carice van Houten              John Lynch   
525              Dakota Goyo       Anthony Mackie        Evangeline Lilly   

                   actor5  
79           Frank Grillo  
100        Lauren Ambrose  
120            Nick Kroll  
125           Rohan Chand  
180   Christina Hendricks  
193   Christopher Langert  
214       Victor Gonzalez  
282         Andrew Airlie  
285        Collette Wolfe  
353            Kent Gavin  
355  Coco Ngambali Yakala  
364         Marton Csokas  
366      Jessica Chastain  
371                   NaN  
406   Alexander Skarsgard  
413            Rafe Spall  
415            Kim Hunter  
418           Andy Serkis  
511         Tim McInnerny  
525          Kevin Durand  

[20 rows x 30 columns]
---------- 2012 ----------
                                   title    title_type               genre  \
9                 Beauty Is Embarrassing   Documentary         Documentary   
10                  The Snowtown Murders  Feature Film               Drama   
28                               The Bay  Feature Film              Horror   
56                          The Tortured  Feature Film  Mystery & Suspense   
95                          The Sessions  Feature Film               Drama   
122                          Any Day Now  Feature Film               Drama   
189                    Lockout (Unrated)  Feature Film  Action & Adventure   
208                            The Raven  Feature Film  Mystery & Suspense   
239                            Project X  Feature Film               Drama   
243                           Liz & Dick      TV Movie               Drama   
245                   Surviving Progress   Documentary         Documentary   
275                 Your Sister's Sister  Feature Film               Drama   
287                           Compliance  Feature Film               Drama   
306                              Rampart  Feature Film               Drama   
321                             The Pact  Feature Film              Horror   
334                           This is 40  Feature Film              Comedy   
347                          Cloud Atlas  Feature Film               Drama   
384  Tim and Eric's Billion Dollar Movie  Feature Film              Comedy   
416                       I Am Bruce Lee   Documentary         Documentary   
458           Ice Age: Continental Drift  Feature Film  Action & Adventure   
469     Ghost Rider: Spirit of Vengeance  Feature Film  Action & Adventure   
485                           Safe House  Feature Film  Mystery & Suspense   
489                          Lola Versus  Feature Film              Comedy   
491                         The Imposter   Documentary         Documentary   
584                     The Hunger Games  Feature Film               Drama   
600                                  LOL  Feature Film              Comedy   

     runtime mpaa_rating                    studio  thtr_rel_year  \
9       88.0     Unrated      Independent Pictures           2012   
10     119.0     Unrated                 IFC Films           2012   
28      84.0           R       Roadside Attraction           2012   
56      79.0           R                 IFC Films           2012   
95      95.0           R  Fox Searchlight Pictures           2012   
122     98.0           R           Music Box Films           2012   
189     95.0       PG-13              FilmDistrict           2012   
208    110.0           R          Relativity Media           2012   
239     88.0           R     Warner Bros. Pictures           2012   
243     88.0     Unrated          E1 Entertainment           2012   
245     86.0           G        First Run Features           2012   
275     90.0           R                 IFC Films           2012   
287     90.0           R         Magnolia Pictures           2012   
306    108.0           R   Millenium Entertainment           2012   
321     89.0           R                 IFC Films           2012   
334    134.0           R         Universal Studios           2012   
347    172.0           R     Warner Bros. Pictures           2012   
384     93.0           R         Magnolia Pictures           2012   
416     94.0     Unrated         D&E Entertainment           2012   
458     88.0          PG          20th Century Fox           2012   
469     96.0       PG-13             Sony Pictures           2012   
485    115.0           R        Universal Pictures           2012   
489     87.0           R  Fox Searchlight Pictures           2012   
491     99.0           R            Indomina Films           2012   
584    142.0       PG-13                 Lionsgate           2012   
600     97.0       PG-13           Lionsgate Films           2012   

     thtr_rel_month  thtr_rel_day  dvd_rel_year  ...  best_actor_win  \
9                 9             7        2013.0  ...              no   
10                3             2        2012.0  ...              no   
28               11             2        2013.0  ...              no   
56                6            15        2012.0  ...              no   
95               10            19        2013.0  ...              no   
122              12            14        2013.0  ...              no   
189               4            13        2012.0  ...              no   
208               4            27        2012.0  ...              no   
239               3             2        2012.0  ...              no   
243               1             1        2013.0  ...              no   
245               4             6        2012.0  ...              no   
275               6            15        2012.0  ...              no   
287               8            17        2013.0  ...              no   
306               2            10        2012.0  ...              no   
321               7             6        2012.0  ...              no   
334              12            21        2013.0  ...              no   
347              10            26        2013.0  ...             yes   
384               3             2        2012.0  ...              no   
416               2             9        2013.0  ...              no   
458               7            13        2012.0  ...              no   
469               2            17        2012.0  ...             yes   
485               2            10        2012.0  ...              no   
489               6             8        2012.0  ...              no   
491               7            13        2013.0  ...              no   
584               3            23        2012.0  ...              no   
600               5             4        2012.0  ...              no   

     best_actress_win  best_dir_win  top200_box           director  \
9                  no            no          no      Neil Berkeley   
10                 no            no          no      Justin Kurzel   
28                 no           yes          no     Barry Levinson   
56                 no            no          no   Robert Lieberman   
95                yes            no          no          Ben Lewin   
122                no            no          no        Travis Fine   
189                no            no          no  Stephen St. Leger   
208                no            no          no     James McTeigue   
239                no            no          no    Jonathan Kaplan   
243                no            no          no       Lloyd Kramer   
245                no            no          no        Mathieu Roy   
275                no            no          no       Lynn Shelton   
287                no            no          no        Craig Zobel   
306                no            no          no      Oren Moverman   
321                no            no          no  Nicholas McCarthy   
334                no            no          no        Judd Apatow   
347               yes            no          no         Tom Tykwer   
384                no            no          no      Tim Heidecker   
416                no            no          no     Pete McCormack   
458                no            no          no  Michael Thurmeier   
469                no            no          no       Brian Taylor   
485                no            no          no    Daniel Espinosa   
489                no            no          no         Daryl Wein   
491                no            no          no        Bart Layton   
584               yes            no         yes          Gary Ross   
600                no            no          no       Liza Azuelos   

                actor1            actor2              actor3  \
9         Paul Reubens     Matt Groening         Todd Oldham   
10      Lucas Pittaway   Daniel Henshall       Louise Harris   
28    Kristen Connolly  Will Rogers (IV)      Kether Donohue   
56   Erika Christensen    Jesse Metcalfe        Bill Moseley   
95         John Hawkes        Helen Hunt     William H. Macy   
122       Alan Cumming  Garret Dillahunt         Isaac Leyva   
189         Guy Pearce      Maggie Grace       Vincent Regan   
208         Luke Evans       John Cusack     Brendan Gleeson   
239        Thomas Mann     Oliver Cooper           Dax Flame   
243      Lindsay Lohan     Grant  Bowler     Theresa Russell   
245         Enio Beata      Colin Beavan        Jane Goodall   
275        Emily Blunt  Rosemarie DeWitt        Mark Duplass   
287           Ann Dowd     Dreama Walker           Pat Healy   
306    Woody Harrelson  Sigourney Weaver        Robin Wright   
321         Caity Lotz      Jewel Staite     Casper Van Dien   
334        Leslie Mann         Paul Rudd        John Lithgow   
347          Tom Hanks       Halle Berry       Jim Broadbent   
384      Tim Heidecker     Eric Wareheim    William Atherton   
416         Dana White        Ed O'Neill         Kobe Bryant   
458         Ray Romano    John Leguizamo         Denis Leary   
469       Nicolas Cage      Ciaran Hinds    Violante Placido   
485      Ryan Reynolds      Vera Farmiga     Brendan Gleeson   
489       Greta Gerwig     Joel Kinnaman    Zoe Lister Jones   
491   Frederic Bourdin      Carey Gibson  Beverly Dollarhide   
584  Jennifer Lawrence   Josh Hutcherson      Liam Hemsworth   
600        Miley Cyrus        Demi Moore       Ashley Greene   

                  actor4                actor5  
9        Jonathan Dayton        Cliff Benjamin  
10           Craig Coyne         Richard Green  
28            Frank Deal        Stephen Kunken  
56         Fulvio Cecere       Bill Lippincott  
95          Annika Marks        Moon Bloodgood  
122          Gregg Henry        Frances Fisher  
189       Peter Stormare          Lennie James  
208            Alice Eve  Oliver Jackson-Cohen  
239  Kirby Bliss Blanton        Jonathan Brown  
243           David Hunt          Bruce Nozick  
245      Margaret Atwood         Robert Wright  
275       Mike Birbiglia          Mike Harring  
287            Bill Camp       Philip Ettinger  
306           Ned Beatty            Ben Foster  
321          Samuel Ball          Haley Hudson  
334            Megan Fox         Albert Brooks  
347         Hugo Weaving          Jim Sturgess  
384        Jeff Goldblum         Robert Loggia  
416    Linda Lee Cadwell        Manny Pacquiao  
458        Queen Latifah   Seann William Scott  
469           Idris Elba      Johnny Whitworth  
485          Sam Shepard          Ruben Blades  
489     Hamish Linklater          Bill Pullman  
491         Nancy Fisher           Bruce Perry  
584      Woody Harrelson       Elizabeth Banks  
600        Douglas Booth        Adam G. Sevani  

[26 rows x 30 columns]
---------- 2013 ----------
                                 title    title_type               genre  \
1                          Filly Brown  Feature Film               Drama   
80      Percy Jackson: Sea of Monsters  Feature Film               Drama   
119             Berberian Sound Studio  Feature Film              Horror   
130                    Spring Breakers  Feature Film               Drama   
136                  The Story Of Luke  Feature Film               Drama   
150                   White House Down  Feature Film               Drama   
203               The Company You Keep  Feature Film  Mystery & Suspense   
217                         Kick-Ass 2  Feature Film  Action & Adventure   
226                          Antiviral  Feature Film               Drama   
315                   What Richard Did  Feature Film               Drama   
316                            Emperor  Feature Film  Mystery & Suspense   
369                    This Is the End  Feature Film               Drama   
400  Anchorman 2: The Legend Continues  Feature Film              Comedy   
457                  The Frozen Ground  Feature Film  Mystery & Suspense   
475                         Dark Skies  Feature Film  Mystery & Suspense   
558                             Maniac  Feature Film              Horror   
564                      To The Wonder  Feature Film               Drama   
575                             Broken  Feature Film         Documentary   
578                   Captain Phillips  Feature Film               Drama   

     runtime mpaa_rating                  studio  thtr_rel_year  \
1       80.0           R     Indomina Media Inc.           2013   
80     106.0          PG        20th Century Fox           2013   
119     92.0     Unrated               IFC Films           2013   
130     94.0           R               A24 Films           2013   
136     96.0     Unrated       Gravitas Ventures           2013   
150    131.0       PG-13           Sony Pictures           2013   
203    125.0           R  Sony Pictures Classics           2013   
217    103.0           R      Universal Pictures           2013   
226    108.0     Unrated                     IFC           2013   
315     88.0     Unrated           Tribeca Films           2013   
316    105.0       PG-13    Roadside Attractions           2013   
369    107.0           R           Sony Pictures           2013   
400    119.0       PG-13      Paramount Pictures           2013   
457    105.0           R         The Film Arcade           2013   
475     97.0       PG-13   The Weinstein Company           2013   
558     89.0     Unrated            IFC Midnight           2013   
564    112.0           R       Magnolia Pictures           2013   
575     91.0     Unrated           Film Movement           2013   
578    134.0       PG-13           Sony Pictures           2013   

     thtr_rel_month  thtr_rel_day  dvd_rel_year  ...  best_actor_win  \
1                 4            19        2013.0  ...              no   
80                8             7        2013.0  ...              no   
119               6            14        2013.0  ...              no   
130               3            22        2013.0  ...              no   
136               4             5        2013.0  ...              no   
150               6            28        2013.0  ...             yes   
203               4             5        2013.0  ...              no   
217               8            16        2013.0  ...              no   
226               4            12        2013.0  ...              no   
315               5            10        2014.0  ...              no   
316               3             8        2013.0  ...              no   
369               6            12        2013.0  ...              no   
400              12            18        2014.0  ...              no   
457               8            23        2013.0  ...             yes   
475               2            22        2013.0  ...              no   
558               6            21        2013.0  ...              no   
564               4            12        2013.0  ...              no   
575               7            19        2013.0  ...              no   
578              10            11        2014.0  ...             yes   

     best_actress_win  best_dir_win  top200_box            director  \
1                  no            no          no    Michael D. Olmos   
80                 no            no          no    Thor Freudenthal   
119                no            no          no    Peter Strickland   
130                no            no          no      Harmony Korine   
136                no            no          no         Alonso Mayo   
150                no            no          no     Roland Emmerich   
203               yes           yes          no      Robert Redford   
217                no            no          no         Jeff Wadlow   
226                no            no          no  Brandon Cronenberg   
315                no            no          no    Lenny Abrahamson   
316                no            no          no        Peter Webber   
369                no            no          no          Seth Rogen   
400                no            no          no          Adam McKay   
457                no            no          no        Scott Walker   
475                no            no          no       Scott Stewart   
558                no            no          no     Franck Khalfoun   
564                no            no          no     Terrence Malick   
575                no            no          no        Billy Corben   
578                no            no          no     Paul Greengrass   

                   actor1                    actor2                actor3  \
1          Gina Rodriguez              Jenni Rivera  Lou Diamond Phillips   
80           Logan Lerman        Brandon T. Jackson    Alexandra Daddario   
119            Toby Jones              Cosimo Fusco          Guido Adorni   
130          Selena Gomez              James Franco         Ashley Benson   
136      Lou Taylor Pucci                Seth Green            Cary Elwes   
150        Channing Tatum                Jamie Foxx     Maggie Gyllenhaal   
203        Robert Redford              Shia LaBeouf        Julie Christie   
217  Aaron Taylor-Johnson  Christopher Mintz-Plasse    Chloe Grace Moretz   
226    Caleb Landry Jones               Sarah Gadon         Douglas Smith   
315           Jack Reynor             Roisin Murphy            Sam Keeley   
316           Matthew Fox           Tommy Lee Jones         Eriko Hatsune   
369          James Franco                Jonah Hill         Danny McBride   
400          Will Ferrell                 Paul Rudd          Steve Carell   
457          Nicolas Cage               John Cusack       Vanessa Hudgens   
475          Keri Russell             Josh Hamilton           Dakota Goyo   
558           Elijah Wood            Nora Arnezeder   Genevieve Alexandra   
564           Ben Affleck            Olga Kurylenko        Rachel McAdams   
575         Keith McCants              Bernie Kosar           Andre Rison   
578             Tom Hanks          Catherine Keener          Barkhad Abdi   

                        actor4               actor5  
1                Emilio Rivera  Joseph Julian Soria  
80              Nathan Fillion            Jake Abel  
119              Fatma Mohamed       Eugenia Caruso  
130              Rachel Korine      Vanessa Hudgens  
136  Kristin Bauer van Straten        Kenneth Welsh  
150               Jason Clarke      Richard Jenkins  
203             Susan Sarandon           Nick Nolte  
217             John Leguizamo        Donald Faison  
226                 Joe Pingue     Malcolm McDowell  
315             Lars Mikkelsen         Fionn Walton  
316          Toshiyuki Nishida     Masayoshi Haneda  
369             Craig Robinson         Michael Cera  
400             David Koechner  Christina Applegate  
457                Dean Norris              50 Cent  
475              Kadan Rockett         J.K. Simmons  
558                Megan Duffy          Jan B. Felt  
564              Javier Bardem          Greg Elliot  
575               Leon Searchy         Herm Edwards  
578            Michael Chernus        Corey Johnson  

[19 rows x 30 columns]
---------- 2014 ----------
                      title    title_type               genre  runtime  \
29                    Locke  Feature Film  Mystery & Suspense     85.0   
143                Godzilla  Feature Film  Mystery & Suspense    123.0   
145  The Legend of Hercules  Feature Film  Action & Adventure     99.0   
211           The Interview  Feature Film              Comedy    112.0   
327             The Captive  Feature Film  Mystery & Suspense    112.0   
336                Hercules  Feature Film  Action & Adventure     98.0   
395           Veronica Mars  Feature Film               Drama    107.0   
524       A Haunted House 2  Feature Film              Comedy     86.0   

    mpaa_rating                studio  thtr_rel_year  thtr_rel_month  \
29            R             A24 Films           2014               4   
143       PG-13  Warner Bros Pictures           2014               5   
145       PG-13       Lionsgate Films           2014               1   
211           R         Sony Pictures           2014              12   
327           R                   A24           2014              12   
336       PG-13    Paramount Pictures           2014               7   
395       PG-13          Warner Bros.           2014               3   
524           R       Open Road Films           2014               4   

     thtr_rel_day  dvd_rel_year  ...  best_actor_win  best_actress_win  \
29             25        2014.0  ...              no                no   
143            16        2014.0  ...              no                no   
145            10        2014.0  ...              no                no   
211            25        2015.0  ...              no                no   
327             9        2015.0  ...              no                no   
336            25        2014.0  ...              no                no   
395            14        2014.0  ...              no                no   
524            18        2014.0  ...              no                no   

     best_dir_win  top200_box          director                     actor1  \
29             no          no     Steven Knight                  Tom Hardy   
143            no          no    Gareth Edwards       Aaron Taylor-Johnson   
145            no          no      Renny Harlin                Kellan Lutz   
211            no          no        Seth Rogen               James Franco   
327            no          no       Atom Egoyan              Ryan Reynolds   
336            no          no      Brett Ratner  Dwayne "The Rock" Johnson   
395            no          no  Rob Thomas (III)               Kristen Bell   
524            no          no    Michael Tiddes              Marlon Wayans   

              actor2          actor3               actor4             actor5  
29   Tom Holland (X)     Bill Milner         Andrew Scott        Ruth Wilson  
143  Elizabeth Olsen  Bryan Cranston     David Strathairn       Ken Watanabe  
145    Liam McIntyre    Scott Adkins        Liam Garrigan  Johnathon Schaech  
211       Seth Rogen    Lizzy Caplan         Randall Park         Diana Bang  
327    Mireille Enos  Scott Speedman       Rosario Dawson       Kevin Durand  
336      Ian McShane    Rufus Sewell  Ingrid Bolso Berdal          John Hurt  
395      Ryan Hansen   Jason Dohring         Chris Lowell      Tina Majorino  
524    Jaime Pressly  Essence Atkins     Gabriel Iglesias      Dave Sheridan  

[8 rows x 30 columns]

# In the movies data set count the number of movies released (thtr_rel_year) year wise
# We can use the aggregate functions on each group of the groupby result

movies_df.groupby('thtr_rel_year').thtr_rel_year.count()

thtr_rel_year
1970     1
1972     3
1973     4
1974     6
1975     5
1976     3
1977    12
1978     5
1979     6
1980    10
1981    11
1982     5
1983     7
1984     9
1985     5
1986     9
1987    14
1988    10
1989    11
1990    10
1991    13
1992    16
1993    20
1994     8
1995    16
1996    27
1997    13
1998    13
1999    18
2000    17
2001    17
2002    23
2003    25
2004    25
2005    16
2006    28
2007    28
2008    22
2009    16
2010    20
2011    20
2012    26
2013    19
2014     8
Name: thtr_rel_year, dtype: int64

# Find the min run_time among every genre group

print(movies_df.groupby('genre').runtime.min())

genre
Action & Adventure           81.0
Comedy                       81.0
Documentary                  39.0
Drama                        80.0
Horror                       77.0
Mystery & Suspense           79.0
Science Fiction & Fantasy    85.0
Name: runtime, dtype: float64

# agg can be used to apply multiple aggregation functions 

# Find min, max, length, sum of runtime of every uique genre group

print(movies_df.groupby('genre').runtime.agg([min, max, len, sum]))

                            min    max  len      sum
genre                                               
Action & Adventure         81.0  177.0   65   6747.0
Comedy                     81.0  135.0   87   8434.0
Documentary                39.0  267.0   52   4921.0
Drama                      80.0  194.0  305  33795.0
Horror                     77.0  108.0   23   2119.0
Mystery & Suspense         79.0  202.0   59   6500.0
Science Fiction & Fantasy  85.0  161.0    9    909.0

# print the title and runtime of the movies in the descending order of their runtime

movies_df.sort_values(by = 'runtime',ascending = False)[['title','runtime']]

	title	runtime
218	Hotel Terminus: The Life and Times of Klaus Ba...	267.0
329	The Godfather, Part II	202.0
562	Titanic	194.0
333	49 Up	180.0
27	Meet Joe Black	178.0
...	...	...
187	Gaza Strip	74.0
48	Mojados: Through the Night	65.0
531	Sea Monsters: A Prehistoric Adventure	40.0
123	Africa: The Serengeti	39.0
312	The End of America	NaN

600 rows × 2 columns

Multi-indexing

df = movies_df.set_index(['title', 'genre'])
df

		title_type	runtime	mpaa_rating	studio	thtr_rel_year	thtr_rel_month	thtr_rel_day	dvd_rel_year	dvd_rel_month	dvd_rel_day	...	best_actor_win	best_actress_win	best_dir_win	top200_box	director	actor1	actor2	actor3	actor4	actor5
title	genre
Filly Brown	Drama	Feature Film	80.0	R	Indomina Media Inc.	2013	4	19	2013.0	7.0	30.0	...	no	no	no	no	Michael D. Olmos	Gina Rodriguez	Jenni Rivera	Lou Diamond Phillips	Emilio Rivera	Joseph Julian Soria
The Dish	Drama	Feature Film	101.0	PG-13	Warner Bros. Pictures	2001	3	14	2001.0	8.0	28.0	...	no	no	no	no	Rob Sitch	Sam Neill	Kevin Harrington	Patrick Warburton	Tom Long	Genevieve Mooy
Waiting for Guffman	Comedy	Feature Film	84.0	R	Sony Pictures Classics	1996	8	21	2001.0	8.0	21.0	...	no	no	no	no	Christopher Guest	Christopher Guest	Catherine O'Hara	Parker Posey	Eugene Levy	Bob Balaban
The Age of Innocence	Drama	Feature Film	139.0	PG	Columbia Pictures	1993	10	1	2001.0	11.0	6.0	...	yes	no	yes	no	Martin Scorsese	Daniel Day-Lewis	Michelle Pfeiffer	Winona Ryder	Richard E. Grant	Alec McCowen
Malevolence	Horror	Feature Film	90.0	R	Anchor Bay Entertainment	2004	9	10	2005.0	4.0	19.0	...	no	no	no	no	Stevan Mena	Samantha Dark	R. Brandon Johnson	Brandon Johnson	Heather Magee	Richard Glover
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
Death Defying Acts	Drama	Feature Film	97.0	PG	Genius Productions	2008	7	11	2008.0	10.0	28.0	...	no	no	no	no	Gillian Armstrong	Guy Pearce	Catherine Zeta-Jones	Timothy Spall	Saoirse Ronan	Jack Bailey
Half Baked	Comedy	Feature Film	82.0	R	Universal Pictures	1998	1	16	1998.0	6.0	30.0	...	no	no	no	no	Tamra Davis	Dave Chappelle	Guillermo Diaz	Jim Breuer	Harland Williams	Rachel True
Dance of the Dead	Action & Adventure	Feature Film	87.0	R	Grindhouse Entertainment	2008	3	9	2008.0	10.0	14.0	...	no	no	no	no	Gregg Bishop	Jared Kusnitz	Greyson Chadwick	Chandler Darby	Carissa Capobianco	Randy McDowell
Around the World in 80 Days	Action & Adventure	Feature Film	120.0	PG	Buena Vista Pictures	2004	6	16	2004.0	11.0	2.0	...	no	no	no	yes	Frank Coraci	Jackie Chan	Steve Coogan	Ewen Bremner	Robert Fyfe	Ian McNeice
LOL	Comedy	Feature Film	97.0	PG-13	Lionsgate Films	2012	5	4	2012.0	7.0	31.0	...	no	no	no	no	Liza Azuelos	Miley Cyrus	Demi Moore	Ashley Greene	Douglas Booth	Adam G. Sevani

600 rows × 28 columns

# Deleting rows

# initialize list of lists 
data = [['tom', 10], ['nick', 15], ['juli', 14], ['Harry', 20]] 

# Create the pandas DataFrame 
df = pd.DataFrame(data, columns = ['Name', 'Age']) 

# print dataframe. 
df 

	Name	Age
0	tom	10
1	nick	15
2	juli	14
3	Harry	20

df.drop([df.index[1], df.index[3]], inplace = True)
df

	Name	Age
0	tom	10
2	juli	14

• rename() function lets you change index names and/or column names.

# let's rename the Name column in the above DataFrame to student

df.rename(columns = {'Name': 'student'})

	student	Age
0	tom	10
2	juli	14

# rename the rows as s1, s2, s3, s4
df.rename(index = {0 : 's1',
                  1 : 's2',
                  2 : 's3',
                  3 : 's4'}, inplace = True)
df

	Name	Age
s1	tom	10
s3	juli	14