notebook.community

Edit and run



In [1]:

    
%matplotlib inline
import pandas as pd



In [2]:

    
from IPython.core.display import HTML
css = open('style-table.css').read() + open('style-notebook.css').read()
HTML('<style>{}</style>'.format(css))









    Out[2]:



In [3]:

    
titles = pd.read_csv('data/titles.csv')
titles.head()









    Out[3]:






  
    
      
      title
      year
    
  
  
    
      0
      A Lélek órása
      1923
    
    
      1
      Aizaugusa gravi viegli krist
      1986
    
    
      2
      Agliyorum
      1988
    
    
      3
      0_1_0
      2008
    
    
      4
      97 fung lau mung
      1994



In [4]:

    
cast = pd.read_csv('data/cast.csv')
cast.head()









    Out[4]:






  
    
      
      title
      year
      name
      type
      character
      n
    
  
  
    
      0
      The Core
      2003
      Alejandro Abellan
      actor
      U.S.S. Soldier
      NaN
    
    
      1
      Il momento di uccidere
      1968
      Remo De Angelis
      actor
      Dago
      9
    
    
      2
      Across the Divide
      1921
      Thomas Delmar
      actor
      Dago
      4
    
    
      3
      Revan
      2012
      Diego James
      actor
      Dago
      NaN
    
    
      4
      Un homme marche dans la ville
      1950
      Fabien Loris
      actor
      Dago
      12

What are the ten most common movie names of all time?



In [ ]:



In [ ]:

Which three years of the 1930s saw the most films released?



In [ ]:



In [ ]:

Plot the number of films that have been released each decade over the history of cinema.



In [ ]:



In [ ]:

Plot the number of "Hamlet" films made each decade.



In [ ]:



In [ ]:

Plot the number of "Rustler" characters in each decade of the history of film.



In [ ]:



In [ ]:

Plot the number of "Hamlet" characters each decade.



In [ ]:



In [ ]:

What are the 11 most common character names in movie history?



In [ ]:



In [ ]:

Who are the 10 people most often credited as "Herself" in film history?



In [ ]:



In [ ]:

Who are the 10 people most often credited as "Himself" in film history?



In [ ]:



In [ ]:

Which actors or actresses appeared in the most movies in the year 1945?



In [ ]:



In [ ]:

Which actors or actresses appeared in the most movies in the year 1985?



In [ ]:



In [ ]:

Plot how many roles Mammootty has played in each year of his career.



In [ ]:



In [ ]:

What are the 10 most frequent roles that start with the phrase "Patron in"?



In [ ]:



In [ ]:

What are the 10 most frequent roles that start with the word "Science"?



In [ ]:



In [ ]:

Plot the n-values of the roles that Judi Dench has played over her career.



In [ ]:



In [ ]:

Plot the n-values of Cary Grant's roles through his career.



In [ ]:



In [ ]:

Plot the n-value of the roles that Sidney Poitier has acted over the years.



In [ ]:



In [ ]:

How many leading (n=1) roles were available to actors, and how many to actresses, in the 1950s?



In [ ]:



In [ ]:

How many supporting (n=2) roles were available to actors, and how many to actresses, in the 1950s?



In [ ]:



In [ ]:

	title	year
0	A Lélek órása	1923
1	Aizaugusa gravi viegli krist	1986
2	Agliyorum	1988
3	0_1_0	2008
4	97 fung lau mung	1994

	title	year	name	type	character	n
0	The Core	2003	Alejandro Abellan	actor	U.S.S. Soldier	NaN
1	Il momento di uccidere	1968	Remo De Angelis	actor	Dago	9
2	Across the Divide	1921	Thomas Delmar	actor	Dago	4
3	Revan	2012	Diego James	actor	Dago	NaN
4	Un homme marche dans la ville	1950	Fabien Loris	actor	Dago	12