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.DataFrame.from_csv('data/titles.csv', index_col=None)
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.DataFrame.from_csv('data/cast.csv', index_col=None)
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



In [ ]:

Using groupby(), plot the number of films that have been released each decade in the history of cinema.



In [ ]:



In [ ]:

Use groupby() to plot the number of "Hamlet" films made each decade.



In [ ]:



In [ ]:

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



In [ ]:



In [ ]:

In the 1950s decade taken as a whole, how many total roles were available to actors, and how many to actresses, for each "n" number 1 through 5?



In [ ]:



In [ ]:

Use groupby() to determine how many roles are listed for each of the Pink Panther movies.



In [ ]:



In [ ]:

List, in order by year, each of the films in which Frank Oz has played more than 1 role.



In [ ]:



In [ ]:

List each of the characters that Frank Oz has portrayed at least twice.



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