nb06-pandas-demo-ejercicios.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Pandas demo segunda parte"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Populating the interactive namespace from numpy and matplotlib\n"
     ]
    }
   ],
   "source": [
    "%pylab inline\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>title</th>\n",
       "      <th>year</th>\n",
       "      <th>name</th>\n",
       "      <th>type</th>\n",
       "      <th>character</th>\n",
       "      <th>n</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Closet Monster</td>\n",
       "      <td>2015</td>\n",
       "      <td>Buffy #1</td>\n",
       "      <td>actor</td>\n",
       "      <td>Buffy 4</td>\n",
       "      <td>31.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Suuri illusioni</td>\n",
       "      <td>1985</td>\n",
       "      <td>Homo $</td>\n",
       "      <td>actor</td>\n",
       "      <td>Guests</td>\n",
       "      <td>22.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Battle of the Sexes</td>\n",
       "      <td>2017</td>\n",
       "      <td>$hutter</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bobby Riggs Fan</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Secret in Their Eyes</td>\n",
       "      <td>2015</td>\n",
       "      <td>$hutter</td>\n",
       "      <td>actor</td>\n",
       "      <td>2002 Dodger Fan</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Steve Jobs</td>\n",
       "      <td>2015</td>\n",
       "      <td>$hutter</td>\n",
       "      <td>actor</td>\n",
       "      <td>1988 Opera House Patron</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  title  year      name   type                character     n\n",
       "0        Closet Monster  2015  Buffy #1  actor                  Buffy 4  31.0\n",
       "1       Suuri illusioni  1985    Homo $  actor                   Guests  22.0\n",
       "2   Battle of the Sexes  2017   $hutter  actor          Bobby Riggs Fan  10.0\n",
       "3  Secret in Their Eyes  2015   $hutter  actor          2002 Dodger Fan   NaN\n",
       "4            Steve Jobs  2015   $hutter  actor  1988 Opera House Patron   NaN"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "elenco = pd.read_csv('data/cast.csv', encoding='utf-8')\n",
    "elenco.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>year</th>\n",
       "      <th>name</th>\n",
       "      <th>type</th>\n",
       "      <th>character</th>\n",
       "      <th>n</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>title</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Closet Monster</th>\n",
       "      <td>2015</td>\n",
       "      <td>Buffy #1</td>\n",
       "      <td>actor</td>\n",
       "      <td>Buffy 4</td>\n",
       "      <td>31.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Suuri illusioni</th>\n",
       "      <td>1985</td>\n",
       "      <td>Homo $</td>\n",
       "      <td>actor</td>\n",
       "      <td>Guests</td>\n",
       "      <td>22.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Battle of the Sexes</th>\n",
       "      <td>2017</td>\n",
       "      <td>$hutter</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bobby Riggs Fan</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Secret in Their Eyes</th>\n",
       "      <td>2015</td>\n",
       "      <td>$hutter</td>\n",
       "      <td>actor</td>\n",
       "      <td>2002 Dodger Fan</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Steve Jobs</th>\n",
       "      <td>2015</td>\n",
       "      <td>$hutter</td>\n",
       "      <td>actor</td>\n",
       "      <td>1988 Opera House Patron</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                      year      name   type                character     n\n",
       "title                                                                     \n",
       "Closet Monster        2015  Buffy #1  actor                  Buffy 4  31.0\n",
       "Suuri illusioni       1985    Homo $  actor                   Guests  22.0\n",
       "Battle of the Sexes   2017   $hutter  actor          Bobby Riggs Fan  10.0\n",
       "Secret in Their Eyes  2015   $hutter  actor          2002 Dodger Fan   NaN\n",
       "Steve Jobs            2015   $hutter  actor  1988 Opera House Patron   NaN"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "e = elenco\n",
    "e = e.set_index('title')\n",
    "e.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "CPU times: user 108 ms, sys: 0 ns, total: 108 ms\n",
      "Wall time: 103 ms\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>year</th>\n",
       "      <th>name</th>\n",
       "      <th>type</th>\n",
       "      <th>character</th>\n",
       "      <th>n</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>title</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Steve Jobs</th>\n",
       "      <td>2015</td>\n",
       "      <td>$hutter</td>\n",
       "      <td>actor</td>\n",
       "      <td>1988 Opera House Patron</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Steve Jobs</th>\n",
       "      <td>2015</td>\n",
       "      <td>Derek W. Adam</td>\n",
       "      <td>actor</td>\n",
       "      <td>Cameraman</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Steve Jobs</th>\n",
       "      <td>2015</td>\n",
       "      <td>Alister Albert</td>\n",
       "      <td>actor</td>\n",
       "      <td>Man with Folder</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Steve Jobs</th>\n",
       "      <td>2015</td>\n",
       "      <td>Chris (III) Amato</td>\n",
       "      <td>actor</td>\n",
       "      <td>Steve Capps</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Steve Jobs</th>\n",
       "      <td>2015</td>\n",
       "      <td>Moises Amaya</td>\n",
       "      <td>actor</td>\n",
       "      <td>Generation X Engineer 1998</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            year               name   type                   character   n\n",
       "title                                                                     \n",
       "Steve Jobs  2015            $hutter  actor     1988 Opera House Patron NaN\n",
       "Steve Jobs  2015      Derek W. Adam  actor                   Cameraman NaN\n",
       "Steve Jobs  2015     Alister Albert  actor             Man with Folder NaN\n",
       "Steve Jobs  2015  Chris (III) Amato  actor                 Steve Capps NaN\n",
       "Steve Jobs  2015       Moises Amaya  actor  Generation X Engineer 1998 NaN"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%time e.loc['Steve Jobs'].head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>year</th>\n",
       "      <th>name</th>\n",
       "      <th>type</th>\n",
       "      <th>character</th>\n",
       "      <th>n</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>title</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>#1 Serial Killer</th>\n",
       "      <td>2013</td>\n",
       "      <td>Matthias Chrans</td>\n",
       "      <td>actor</td>\n",
       "      <td>Brian Bennett</td>\n",
       "      <td>13.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#1 Serial Killer</th>\n",
       "      <td>2013</td>\n",
       "      <td>Yvis Cannavale</td>\n",
       "      <td>actor</td>\n",
       "      <td>Homeless Man</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#1 Serial Killer</th>\n",
       "      <td>2013</td>\n",
       "      <td>Jesse Wang</td>\n",
       "      <td>actor</td>\n",
       "      <td>Mr. Tsai</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#1 Serial Killer</th>\n",
       "      <td>2013</td>\n",
       "      <td>Shoshana Bush</td>\n",
       "      <td>actress</td>\n",
       "      <td>Tricia Arnold</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#1 Serial Killer</th>\n",
       "      <td>2013</td>\n",
       "      <td>Tiley Chao</td>\n",
       "      <td>actress</td>\n",
       "      <td>Mrs. Chang</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  year             name     type      character     n\n",
       "title                                                                \n",
       "#1 Serial Killer  2013  Matthias Chrans    actor  Brian Bennett  13.0\n",
       "#1 Serial Killer  2013   Yvis Cannavale    actor   Homeless Man  25.0\n",
       "#1 Serial Killer  2013       Jesse Wang    actor       Mr. Tsai  11.0\n",
       "#1 Serial Killer  2013    Shoshana Bush  actress  Tricia Arnold   4.0\n",
       "#1 Serial Killer  2013       Tiley Chao  actress     Mrs. Chang  12.0"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "e = elenco\n",
    "e = e.set_index('title').sort_index()\n",
    "e.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "CPU times: user 4 ms, sys: 0 ns, total: 4 ms\n",
      "Wall time: 1.26 ms\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>year</th>\n",
       "      <th>name</th>\n",
       "      <th>type</th>\n",
       "      <th>character</th>\n",
       "      <th>n</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>title</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Steve Jobs</th>\n",
       "      <td>2015</td>\n",
       "      <td>Darlene Nesson</td>\n",
       "      <td>actress</td>\n",
       "      <td>VIP Investor</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Steve Jobs</th>\n",
       "      <td>2015</td>\n",
       "      <td>Dan (XXVIII) Anderson</td>\n",
       "      <td>actor</td>\n",
       "      <td>1998 Launch Attendee</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Steve Jobs</th>\n",
       "      <td>2015</td>\n",
       "      <td>Alec Boyle</td>\n",
       "      <td>actor</td>\n",
       "      <td>P. Freeze</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Steve Jobs</th>\n",
       "      <td>2015</td>\n",
       "      <td>Demond Stone</td>\n",
       "      <td>actor</td>\n",
       "      <td>VIP Investor</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Steve Jobs</th>\n",
       "      <td>2015</td>\n",
       "      <td>Andrew Koponen</td>\n",
       "      <td>actor</td>\n",
       "      <td>Chef</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            year                   name     type             character   n\n",
       "title                                                                     \n",
       "Steve Jobs  2015         Darlene Nesson  actress          VIP Investor NaN\n",
       "Steve Jobs  2015  Dan (XXVIII) Anderson    actor  1998 Launch Attendee NaN\n",
       "Steve Jobs  2015             Alec Boyle    actor             P. Freeze NaN\n",
       "Steve Jobs  2015           Demond Stone    actor          VIP Investor NaN\n",
       "Steve Jobs  2015         Andrew Koponen    actor                  Chef NaN"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%time e.loc['Steve Jobs'].head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>type</th>\n",
       "      <th>character</th>\n",
       "      <th>n</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>title</th>\n",
       "      <th>year</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"20\" valign=\"top\">#1 Serial Killer</th>\n",
       "      <th>2013</th>\n",
       "      <td>Michael Alton</td>\n",
       "      <td>actor</td>\n",
       "      <td>Detective Roberts</td>\n",
       "      <td>17.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013</th>\n",
       "      <td>Aaron Aoki</td>\n",
       "      <td>actor</td>\n",
       "      <td>Plastic Bag Victim</td>\n",
       "      <td>21.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013</th>\n",
       "      <td>Zachary (X) Brown</td>\n",
       "      <td>actor</td>\n",
       "      <td>Africian American Teen</td>\n",
       "      <td>18.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013</th>\n",
       "      <td>Yvis Cannavale</td>\n",
       "      <td>actor</td>\n",
       "      <td>Homeless Man</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013</th>\n",
       "      <td>Patrick Chien</td>\n",
       "      <td>actor</td>\n",
       "      <td>Cleaver Victim</td>\n",
       "      <td>22.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013</th>\n",
       "      <td>Matthias Chrans</td>\n",
       "      <td>actor</td>\n",
       "      <td>Brian Bennett</td>\n",
       "      <td>13.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013</th>\n",
       "      <td>Robert Cicchini</td>\n",
       "      <td>actor</td>\n",
       "      <td>Detective Phillips</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013</th>\n",
       "      <td>Scott Eriksson</td>\n",
       "      <td>actor</td>\n",
       "      <td>Party Guest</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013</th>\n",
       "      <td>Rane Jameson</td>\n",
       "      <td>actor</td>\n",
       "      <td>Micah Betancourt</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013</th>\n",
       "      <td>Tzi Ma</td>\n",
       "      <td>actor</td>\n",
       "      <td>Mr. Chang</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013</th>\n",
       "      <td>Thomas McCurdy</td>\n",
       "      <td>actor</td>\n",
       "      <td>Golf Club Victim</td>\n",
       "      <td>23.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013</th>\n",
       "      <td>Thomas Isao Morinaka</td>\n",
       "      <td>actor</td>\n",
       "      <td>Policeman #1</td>\n",
       "      <td>19.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013</th>\n",
       "      <td>Parry Shen</td>\n",
       "      <td>actor</td>\n",
       "      <td>Murder Victim</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013</th>\n",
       "      <td>Eric (II) St. John</td>\n",
       "      <td>actor</td>\n",
       "      <td>Officer Williams</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013</th>\n",
       "      <td>Brian Takahashi</td>\n",
       "      <td>actor</td>\n",
       "      <td>Stabbing Victim</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013</th>\n",
       "      <td>Timothy Tau</td>\n",
       "      <td>actor</td>\n",
       "      <td>Police Officer</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013</th>\n",
       "      <td>Jason Tobin</td>\n",
       "      <td>actor</td>\n",
       "      <td>Eddy Tsai</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013</th>\n",
       "      <td>Jesse Wang</td>\n",
       "      <td>actor</td>\n",
       "      <td>Mr. Tsai</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013</th>\n",
       "      <td>Romina Bovolini</td>\n",
       "      <td>actress</td>\n",
       "      <td>Lisa Simpson</td>\n",
       "      <td>14.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013</th>\n",
       "      <td>Shoshana Bush</td>\n",
       "      <td>actress</td>\n",
       "      <td>Tricia Arnold</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       name     type               character  \\\n",
       "title            year                                                          \n",
       "#1 Serial Killer 2013         Michael Alton    actor       Detective Roberts   \n",
       "                 2013            Aaron Aoki    actor      Plastic Bag Victim   \n",
       "                 2013     Zachary (X) Brown    actor  Africian American Teen   \n",
       "                 2013        Yvis Cannavale    actor            Homeless Man   \n",
       "                 2013         Patrick Chien    actor          Cleaver Victim   \n",
       "                 2013       Matthias Chrans    actor           Brian Bennett   \n",
       "                 2013       Robert Cicchini    actor      Detective Phillips   \n",
       "                 2013        Scott Eriksson    actor             Party Guest   \n",
       "                 2013          Rane Jameson    actor        Micah Betancourt   \n",
       "                 2013                Tzi Ma    actor               Mr. Chang   \n",
       "                 2013        Thomas McCurdy    actor        Golf Club Victim   \n",
       "                 2013  Thomas Isao Morinaka    actor            Policeman #1   \n",
       "                 2013            Parry Shen    actor           Murder Victim   \n",
       "                 2013    Eric (II) St. John    actor        Officer Williams   \n",
       "                 2013       Brian Takahashi    actor         Stabbing Victim   \n",
       "                 2013           Timothy Tau    actor          Police Officer   \n",
       "                 2013           Jason Tobin    actor               Eddy Tsai   \n",
       "                 2013            Jesse Wang    actor                Mr. Tsai   \n",
       "                 2013       Romina Bovolini  actress            Lisa Simpson   \n",
       "                 2013         Shoshana Bush  actress           Tricia Arnold   \n",
       "\n",
       "                          n  \n",
       "title            year        \n",
       "#1 Serial Killer 2013  17.0  \n",
       "                 2013  21.0  \n",
       "                 2013  18.0  \n",
       "                 2013  25.0  \n",
       "                 2013  22.0  \n",
       "                 2013  13.0  \n",
       "                 2013   9.0  \n",
       "                 2013   NaN  \n",
       "                 2013   6.0  \n",
       "                 2013   3.0  \n",
       "                 2013  23.0  \n",
       "                 2013  19.0  \n",
       "                 2013   NaN  \n",
       "                 2013   NaN  \n",
       "                 2013  20.0  \n",
       "                 2013   NaN  \n",
       "                 2013   1.0  \n",
       "                 2013  11.0  \n",
       "                 2013  14.0  \n",
       "                 2013   4.0  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "e = elenco\n",
    "e = e.set_index( ['title','year'] ).sort_index()\n",
    "e.head(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "CPU times: user 0 ns, sys: 0 ns, total: 0 ns\n",
      "Wall time: 4.05 µs\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>type</th>\n",
       "      <th>character</th>\n",
       "      <th>n</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>title</th>\n",
       "      <th>year</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">Batman</th>\n",
       "      <th>1989</th>\n",
       "      <td>Del Baker</td>\n",
       "      <td>actor</td>\n",
       "      <td>Napier Hood</td>\n",
       "      <td>31.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1989</th>\n",
       "      <td>Michael Balfour</td>\n",
       "      <td>actor</td>\n",
       "      <td>Scientist</td>\n",
       "      <td>44.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1989</th>\n",
       "      <td>David Baxt</td>\n",
       "      <td>actor</td>\n",
       "      <td>Dr. Thomas Wayne</td>\n",
       "      <td>48.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1989</th>\n",
       "      <td>Paul Birchard</td>\n",
       "      <td>actor</td>\n",
       "      <td>Another Reporter</td>\n",
       "      <td>55.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1989</th>\n",
       "      <td>Hugo Blick</td>\n",
       "      <td>actor</td>\n",
       "      <td>Young Jack Napier</td>\n",
       "      <td>41.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        name   type          character     n\n",
       "title  year                                                 \n",
       "Batman 1989        Del Baker  actor        Napier Hood  31.0\n",
       "       1989  Michael Balfour  actor          Scientist  44.0\n",
       "       1989       David Baxt  actor   Dr. Thomas Wayne  48.0\n",
       "       1989    Paul Birchard  actor   Another Reporter  55.0\n",
       "       1989       Hugo Blick  actor  Young Jack Napier  41.0"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%time \n",
    "e.loc[\"Batman\",1989].head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "pandas.core.frame.DataFrame"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "e = e.reset_index('year')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "43"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "e = elenco\n",
    "e = e[e.name == \"Christian Bale\"]\n",
    "len( e.groupby(['title','year']).size() )\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x7fa8f045a7f0>"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXEAAAEfCAYAAAC3efaOAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAGGFJREFUeJzt3X20ZXV93/H3B1CKkKKoGSwDTFRcSFciROVhYRejicpD\nC3FFJVZjxKYhPlQaktYua8NNVlbUxCpBi4QIVtJlBW0KJIJCgleXVIEwTBx5UEgr4ChTDaDyEIv6\n7R97jzme2eeeM8O5c+9veL/W2mv2w+f+9u+cs+93fnefc/ZOVSFJatNuK90BSdKOs4hLUsMs4pLU\nMIu4JDXMIi5JDbOIS1LDZi7iSXZLsiHJ5RO2n5Pk9iQbkxw+vy5KkibZnpH4GcAtQxuSnAA8o6oO\nAU4HzptD3yRJU8xUxJOsBU4EPjghcgpwEUBVXQfsm2TNXHooSZpo1pH4e4F/B0z6eucBwN0jy5v7\ndZKkZTS1iCc5CdhSVRuB9JMkaRXYY4bMscDJSU4E9gJ+IslFVfXakcxm4MCR5bX9uh+TxAu1SNIO\nqKrBAfTUkXhVva2qDqqqpwO/BFwzVsABLgdeC5DkaOD+qtoyob1tprPOOmtw/aTJvPnlzvdHaz+d\nNTI/fAzvaH9Ww2M1v/rzS5llJD4oyend8VznV9UVSU5McgfwIHDajrYrSZrddhXxqvoM8Jl+/o/H\ntr15jv2SJM1gVXxjc/369ebNr9o8LF/7q+2xmm8rD5Bp51vmKUntzP1JOyoJw5+ozdRzlNK8JaF2\n9I1NSdLqZRGXpIZZxCWpYRZxSWqYRVySGmYRl6SGWcQlqWEWcUlqmEVckhpmEZekhlnEJalhFnFJ\naphFXJIaZhGXpIZZxCWpYRZxSWqYRVySGja1iCfZM8l1SW5KsinJWQOZ45Lcn2RDP719eborSRo1\n9UbJVfW9JC+sqoeS7A5cm+TKqrp+LPrZqjp5ebopSRoy0+mUqnqon92TrvAP33xQkrRTzVTEk+yW\n5CbgHuDqqrphIHZMko1JPpHksLn2UpI0aNaR+A+r6ghgLXDUQJG+ETioqg4H3g9cOt9uSpKGTD0n\nPqqqvpPk08DxwC0j6x8Ymb8yyblJ9quqe8fbWFhY+NH8+vXrWb9+/Q50W5J2XYuLiywuLs6UTdXQ\n6e2RQPIU4JGq+naSvYBPAe+sqitGMmuqaks/fyRwSVWtG2irpu1PWg2SMOmtH49h7WxJqKrB9x1n\nGYk/Dfhwkt3oTr9cXFVXJDkdqKo6H3h5kjcAjwAPA6fOqe+SpCVMHYnPdWeOxNUIR+JaTZYaifuN\nTUlqmEVckhpmEZekhlnEJalhFnFJaphFXJIaZhGXpIZZxCWpYRZxSWqYRVySGmYRl6SGWcQlqWEW\ncUlqmEVckhpmEZekhlnEJalhFnFJaphFXJIaZhGXpIZNLeJJ9kxyXZKbkmxKctaE3DlJbk+yMcnh\n8++qJGnc1LvdV9X3krywqh5KsjtwbZIrq+r6rZkkJwDPqKpDkhwFnAccvXzdliTBjKdTquqhfnZP\nusI/frvvU4CL+ux1wL5J1syrk5KkYTMV8SS7JbkJuAe4uqpuGIscANw9sry5XydJWkazjsR/WFVH\nAGuBo5IctrzdkiTNYuo58VFV9Z0knwaOB24Z2bQZOHBkeW2/bhsLCwsAvPvdZ/Pgg9/eZvuaNQdz\nzz1f3Z5u6TFo//3XsWXLndusb+X4Gep/K33X8ltcXGRxcXGmbKrGT2+PBZKnAI9U1beT7AV8Cnhn\nVV0xkjkReFNVnZTkaODsqtrmjc0ktXV/Sdj21DpAmNYnabmPn5Vp32Nfw5JQVRnaNstI/GnAh5Ps\nRnf65eKquiLJ6UBV1fn98olJ7gAeBE6bW+8lSRNNHYnPdWeOxDUnjsT1WLLUSNxvbEpSwyziktQw\ni7gkNcwiLkkNs4hLUsMs4pLUMIu4JDXMIi5JDbOIS1LDLOKS1DCLuCQ1zCIuSQ2ziEtSwyziktQw\ni7gkNcwiLkkNs4hLUsMs4pLUMIu4JDVsahFPsjbJNUluTrIpyVsGMscluT/Jhn56+/J0V5I0apa7\n3X8fOLOqNibZB7gxyVVVddtY7rNVdfL8uyhJmmTqSLyq7qmqjf38A8CtwAED0cE7MUuSls92nRNP\nsg44HLhuYPMxSTYm+USSw+bQN0nSFLOcTgGgP5XyceCMfkQ+6kbgoKp6KMkJwKXAs+bXTUnSkJmK\neJI96Ar4n1bVZePbR4t6VV2Z5Nwk+1XVvePZhYWFkaVFYP12dlmSdm2Li4ssLi7OlE1VTQ8lFwHf\nqqozJ2xfU1Vb+vkjgUuqat1ArrbuLwkwtO8wS5/02Lbcx8/KtO+xr2FJqKrB9x2njsSTHAu8GtiU\n5Ca6I+9twMFAVdX5wMuTvAF4BHgYOHVenZckTTbTSHxuO3MkrjlxJK7HkqVG4n5jU5IaZhGXpIZZ\nxCWpYRZxSWqYRVySGmYRl6SGWcQlqWEWcUlqmEVckhpmEZekhlnEJalhFnFJaphFXJIaZhGXpIZZ\nxCWpYRZxSWqYRVySGmYRl6SGWcQlqWFTi3iStUmuSXJzkk1J3jIhd06S25NsTHL4/LsqSRo39W73\nwPeBM6tqY5J9gBuTXFVVt20NJDkBeEZVHZLkKOA84Ojl6bIkaaupI/GquqeqNvbzDwC3AgeMxU4B\nLuoz1wH7Jlkz575KksZs1znxJOuAw4HrxjYdANw9sryZbQu9JGnOZi7i/amUjwNn9CNySdIKm+Wc\nOEn2oCvgf1pVlw1ENgMHjiyv7ddtY2FhYWRpEVg/SxdWnf33X8eWLXdus37NmoO5556v2v4yt7/a\n+rOaHu9q6suOeCy9VpMsLi6yuLg4UzZVNT2UXAR8q6rOnLD9ROBNVXVSkqOBs6tqmzc2k9TW/SUB\nhvYdZunTSlvu/tv+fNtvI9/Gc7/cVtuxsxokoaoytG3qSDzJscCrgU1JbqJ79G8DDgaqqs6vqiuS\nnJjkDuBB4LT5dV+SNMlMI/G57cyRuO07El8i38Zzv9xW27GzGiw1Evcbm5LUMIu4JDXMIi5JDbOI\nS1LDLOKS1DCLuCQ1zCIuSQ2ziEtSwyziktQwi7gkNcwiLkkNs4hLUsMs4pLUMIu4JDXMIi5JDbOI\nS1LDLOKS1DCLuCQ1zCIuSQ2bWsSTXJBkS5IvTth+XJL7k2zop7fPv5uSpCFT73YPfAh4H3DREpnP\nVtXJ8+mSJGlWU0fiVfU54L4pscG7MEuSlte8zokfk2Rjkk8kOWxObUqSppjldMo0NwIHVdVDSU4A\nLgWeNYd2JUlTPOoiXlUPjMxfmeTcJPtV1b1D+YWFhZGlRWD9o+2CJO1SFhcXWVxcnCmbqpoeStYB\nf15VPz2wbU1VbennjwQuqap1E9qprftLAgztO8zSp5W23P23/fm230a+jed+ua22Y2c1SEJVDb73\nOHUknuQjdMPlJye5CzgLeDxQVXU+8PIkbwAeAR4GTp1XxyVJS5tpJD63nTkSt31H4kvk23jul9tq\nO3ZWg6VG4n5jU5IaZhGXpIZZxCWpYRZxSWqYRVySGmYRl6SGWcQlqWEWcUlqmEVckhpmEZekhlnE\nJalhFnFJaphFXJIaZhGXpIZZxCWpYRZxSWqYRVySGmYRl6SGWcQlqWFTi3iSC5JsSfLFJTLnJLk9\nycYkh8+3i5KkSWYZiX8IeOmkjUlOAJ5RVYcApwPnzalvkqQpphbxqvoccN8SkVOAi/rsdcC+SdbM\np3uSpKXM45z4AcDdI8ub+3WSpGXmG5uS1LB5FPHNwIEjy2v7dYMWFhZYWFjolxZn3sn++68jyTbT\n/vuvW5H89rL9lW2/Zavtufd3a+c8P/vs88SxejksVTX1QSRZB/x5Vf30wLYTgTdV1UlJjgbOrqqj\nJ7RTW/eXBBjadxjqk3nzu35+NfXF/GrKJ6GqMhBij6GVYzv4CLAeeHKSu4CzgMcDVVXnV9UVSU5M\ncgfwIHDatDYlSfMxtYhX1b+cIfPm+XRHkrQ9fGNTkhpmEZekhlnEJalhFnFJaphFXJIaZhGXpIZZ\nxCWpYRZxSWqYRVySGmYRl6SGWcQlqWEWcUlqmEVckhpmEZekhlnEJalhFnFJaphFXJIaZhGXpIbN\nVMSTHJ/ktiRfSfLWge3HJbk/yYZ+evv8uypJGjfLjZJ3A94P/BzwdeCGJJdV1W1j0c9W1cnL0EdJ\n0gSzjMSPBG6vqjur6hHgo8ApA7nMtWeSpKlmKeIHAHePLH+tXzfumCQbk3wiyWFz6Z0kaUlTT6fM\n6EbgoKp6KMkJwKXAs+bUtiRpglmK+GbgoJHltf26H6mqB0bmr0xybpL9qure8cYWFhZGlhaB9dvR\nXUl6LFgExuvlsFTV0oFkd+DLdG9sfgO4HnhVVd06kllTVVv6+SOBS6pq3UBbtXV/SYChfYehPpk3\nv+vnV1NfzK+mfBKqavB9x6kj8ar6QZI3A1fRnUO/oKpuTXJ6t7nOB16e5A3AI8DDwKnT2pUkPXpT\nR+Jz3ZkjcfPml8ivpr6YX035pUbifmNTkhpmEZekhlnEJalhFnFJaphFXJIaZhGXpIZZxCWpYRZx\nSWqYRVySGmYRl6SGWcQlqWEWcUlqmEVckhpmEZekhlnEJalhFnFJaphFXJIaZhGXpIZZxCWpYTMV\n8STHJ7ktyVeSvHVC5pwktyfZmOTw+XZTkjRkahFPshvwfuClwD8FXpXk0LHMCcAzquoQ4HTgvO3r\nxuL2xc2b32Xyy9m2+V0/P9tI/Ejg9qq6s6oeAT4KnDKWOQW4CKCqrgP2TbJm9m4szh41b36Xyi9n\n2+Z3/fxsRfwA4O6R5a/165bKbB7ISJLmzDc2JalhqaqlA8nRwEJVHd8v/wegqupdI5nzgE9X1cX9\n8m3AcVW1ZaytpXcmSRpUVRlav8cMP3sD8MwkBwPfAH4JeNVY5nLgTcDFfdG/f7yAL9UJSdKOmVrE\nq+oHSd4MXEV3+uWCqro1yend5jq/qq5IcmKSO4AHgdOWt9uSJJjhdIokafXyjU1JaphFXJIaZhGX\npIZZxDVXSV6a5ANJLu+nDyQ5fgfa+e0l2v9XSdaNrX/9jO1es8S2p4wtv6a/JtCvJdnmk1VJXpZk\nv37+qUkuSrIpycVJ1g7k35Pk2Fn62ef3S/LbSX41nf+Y5C+S/GGSJ034mRcmeX+Sy5L8WZJ3Jnnm\nEvtYNa9X/xhfmeQV/fzP9c//G/vLf8zSj1369R1sZ2e/sZnkPcD/qKprt+NnXgj8InAg8APgK8AH\nq+qOCfmXAmuBv6qqr46sf31VXTiWDfAKoICPAy+iu4zAbcB5VfXDGfp3TVW9aMK2p1TVt0aWX0N3\nKYMvAX9SYy9AkpcBn6mqe5M8FfjPwBHALcBvVtXXxvLb9Xz2B+Wbga8DFwBvA44BbgV+v6ruG/iZ\nmZ7/JGcDz6K7BMPWfq4FXkt36YYzZulj39ZdVXXQ2LrfB14AbAD+BXB2Vb2v37ahqn52LP/F8Wb7\n/n0ZoKp+Ziz/ozaSvB34Z8BHgH8OfK2qfmMsf0tVHdbPXwx8AfgY8PPAq6vqxWP5bwJ3Ak8FLgb+\ne1XdtMRzcAWwCfjHwLP7+UuAFwPPqapTxvLvAPYH/gr4BeD/0L1Wb6R7bT82ll9tr9e5wE8Cjwe+\nA+xJ9/Hlk4At4/15rL2+E1XVTp2AbwJ/3T/YPwCOmJJ/B/Ah4DV0RfYPgX8N3AS8YiD/+8BngbOB\nvwX+zci2DQP5c/t2Lwf+W/8i/TLdNWL+aCD/xbFpE/C9rcsD+Q0j828HPgX8Sr+f9w7kbxmZvxj4\nDbpfrNcBV8/h+bwCeBfwAboLNbyP7mD+XeCyR/P8A1+ZsM/QFYXx9d+ZMH0X+P5AfhOwRz//xP6x\nvLdfvmkgv/U1PRQ4GFhHd3mIg4GDB/I3jcxvAPbu5x8HbBrIf3lk/saxbRsntU9XaP4TcDPdYOEs\n4FkD+Y0jz9/mGdrfNDK/B3BtP/8k4EsD+dX2em0aeb7/Dnj8yGMZ+t16TL2+k6aZQvOcduCBbu+B\n6YGzQoWB7j+y5w+0ceSEx3oXsGbCcXL3wLpbx5Z3p/tr4mPAzRPaeRndf+on98v/e4lj8za6v3qe\nO97fCc/NH9P957cX3V9ML+vXv5Dur6nx/NAg4mfo/qO8Y2DbF/vn+SDg28C6fv2TGfnPfiT/N8B+\n/fxBwBdGtm3z/Ky212vsd+WT057/x9rrO/FxzRqc17QDD3R7D0wPnBUqDMDPAtfRnfq5qp9upfsz\n9LkDbf8ecOSE5+1dA+v+gu5yDkPt/HCJ12Bv4D3AZXR/Nk/KfXpsetrIc/PXA/nHAQt0xe0u4Id0\no9KPAActdazN+LvyKmBLP/0i8JfA1XQXmPu1gfypdH+RXd3356R+/VOBjwzkV9XrBVwJ7DOwfn/g\n+sf66zuxne3Z6TymHXig23tgeuDM8cDZ3ud/5Ll7bj/tP8djZy9grwnbDpjh558D/PoO7Hd34AlT\nMvsCT56S2eY4m3HfW/+y3AN43tZjaEJ+vz7zxO3Yx6p8vUayewM/6es7PK3EG5v7VNUD2/kz+wFP\npxtZ3j8luxdAVT08sO2Aqto84z73pjv18X+n5J4DHFNV23UjjCS7A3tW1UNLZPale4H/bonMjjyf\nu9O9qf39JHsAh9OdWvnGhPz2PP+h+3N866WIN9P9Zzh4oJlf2fwkSQ6tqtvMr/78inztPslBwHeq\n6v7+o0fPA26rqi/NI9//zPMY+TTFtCfE/KPPJ3kJ3RvFt9MVD+jelH0m8Maqusr86skvZejTJuZX\nZ36WqxjOVbpL2Z4OfC/Ju4HfAq4FfifJBVX1nkeZP47uXPL9dH8eXgs8KckjwC9X1d3mly3/R8DP\n18jHOvs2foruDeZn8+PMr2A+yTkMC92HAn58pfkVzU+y04s43cf3DgOeAHwVeHpVfbM/fXEd3Xnm\nR5M/G3hJn/kp4D1VdWySF9O9wfkS88uW34N/+LzxqM105/rHmV/Z/GnAb9J9RHbc+OWmza98ftBK\nFPEfVNXDSf4f8DDdx/qoqgez7ZemdiS/e1V9s5+/i+6jf1TV1em+3GB++fIXAjck+Sj/cLu+A+mu\nQX/BQNvmVzZ/A93HRP/X+IYkC+ZXXX7QSryx+V/pvpG1N/AQ8H3gk3TflPyJqnrlo8xfSPfty2uA\nk+nesDszyRPoPo53qPllzR/W50bfWLu8qm5hgPmVy6d7w/rva4k3182vnvzEdlagiO/Bj3/N/Si6\nPx3uAv5LVT34KPOPo/tG4WF0n3G+sLobW+xF9zGlO80vX17STlZz+kyokxPdZ2nfSfcFp3vpTn3d\n2q/b5nPL5s2bnz0/adrpVzFMsk+S301yc5JvJ/lmki8k+ZU55780ln+d+WXPXwLcB6yvqv2q6sl0\n3zS9r99m3rz5Hc8P29FR145OdN9wfB3d51fPpLvexyHAh+mutGa+0Twj130ZaGebbebNm589PzE7\na3BeE/A3Y8s39P/uRvcFHvON5umuvfHvGblIErAGeCvwlwNtmzdvfsb8pGklbgrxYJIXACQ5me5c\nENVdt3voM4Pm28mfSndNmM8kuS/JvXSXu90PeCXbMm/e/Oz5YbNW+3lNdFfYu57uvM/n6C+XSndB\npbeYbz5/KN1F8/cZW3/8hOPBvHnzM+YH25g1uDMm4DTz7eaBt9DdVeVSum/XnjKybeiSuebNm58x\nP/H3cHt+aZd7Au4y326e7oYc+/Tz6+juOHRGvzx4Qw7z5s3Plp80rcQFsMbvi/ejTXQn9c23m9+t\n+sviVtVXk6wHPp7kYIbPt5s3b372/LBZq/28JrqbERxOfzuzkWkd8HXz7ebpvpp/+Ni6PehuxPuD\ngbbNmzc/Y37SNFNonhPdhXheMGHb0J16zDeSp/ss+eCdYYBjB9aZN29+xvykaUVuCiFJmo+V+Jy4\nJGlOLOKS1DCLuCQ1zCIuSQ2ziEvbKYm/N1o1PBi1S0vyO0nOGFn+vSRvSfJbSa5PsjHJWSPb/2eS\nG5JsSvKrI+u/m+TdSW4Cjt7JD0OayCKuXd2FwGsBkoTupsHfAA6pqiOBI4Dnbb1SI931YJ4PPB84\nI8mT+vV7A5+vqiNq4Ma20kpZibvdSztNVd2Z5FtJngPsD2wAjgRenGQD3deb96a70cXngH+b5Bf6\nH1/br7+e7gbdf7az+y9NYxHXY8EHgdPoiviFdJf+fEdV/cloKMlxwIuAo6rqe0k+DfyjfvPfl9+M\n0yrk6RQ9FlwKHA88D/hUP70+yd4ASf5JkqfS3bj2vr6AH8qPn/ue/YJE0k7kSFy7vKp6pB9V39eP\npq/ui/Tnu9PkfBd4DfBJ4NeT3Ex3nefPjzazk7stzcRrp2iX138k8Ebg5VX1tyvdH2mePJ2iXVqS\nZwO3A1dbwLUrciQuSQ1zJC5JDbOIS1LDLOKS1DCLuCQ1zCIuSQ2ziEtSw/4/fpgePmTYhVAAAAAA\nSUVORK5CYII=\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x7fa8f03e6630>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "e = elenco\n",
    "e = e[e.name == \"Christian Bale\"]\n",
    "e.groupby('year').size().plot(kind='bar')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x7fa8e3893c50>"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAW0AAAEfCAYAAACK65foAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAD05JREFUeJzt3X+M5HV9x/HnC6+mFS05qLBpUU8jilYrWkAbmzhaFdo0\nSpOWSn8omBqbaqQ/bETT5M6mSUujpDatxihYamqoJUW0afAwdppgtRARRUQgTUBt4KRyWFGxqO/+\nMQOuy+7t3e7sfvc983wkG3e/M7Pz9rOzT773nfnOpqqQJPVw1NADSJIOn9GWpEaMtiQ1YrQlqRGj\nLUmNGG1JamTdaCc5McnHk9yU5MYkb5hu351kf5Jbknw0yTFbP64kLbas9zrtJEvAUlXdkOTRwKeB\nlwPnAV+rqr9M8iZgd1VdsOUTS9ICW3dPu6ruqqobpp/fB9wMnMgk3JdOr3YpcNZWDSlJmlh3T/uH\nrpzsAcbAM4AvV9XuZZfdU1XHzng+SdIyh/1E5PTQyOXA+dM97pW193x4Sdpiuw7nSkl2MQn2+6vq\nyunmA0lOqKoD0+PeX13jtsZckjagqrJy2+HuaV8CfKGq3rFs24eBc6efvwq4cuWNlt3xjv/Yu3fv\n4DPM08eiruf0ET/jj71b8D17/F4u8mNzLevuaSd5PvCbwI1JPjP9ib8FuBD4YJJXA3cAZ6/3vSRJ\nm7NutKvqE8Aj1rj4xbMdR5J0KJ4ROTUajYYeYa64nrM0GnqAudL9sXlEL/nb0B0ktdX3Ie0USejx\nQqoc8riphpeE2sQTkZKkHcBoS1IjRluSGjHaktSI0ZakRoy2JDVitCWpEaMtSY0YbUlqxGhLUiNG\nW5IaMdqS1IjRlqRGjLYkNWK0JakRoy1JjRhtSWrEaEtSI0Zbkhox2pLUiNGWpEaMtiQ1YrQlqRGj\nLUmNGG1JasRoS1IjRluSGjHaktSI0ZakRoy2JDVitCWpEaMtSY0YbUlqxGhLUiNGW5IaMdqS1IjR\nlqRGjLYkNWK0JakRoy1JjRhtSWrEaEtSI0Zbkhox2pLUiNGWpEbWjXaSi5McSPK5Zdv2JvlKkuun\nH2du7ZiSJDi8Pe33AWessv2iqnrO9OOqGc8lSVrFutGuqmuAg6tclNmPI0k6lM0c0359khuSvDfJ\nMTObSJK0po1G+53Ak6rqFOAu4KLZjSRJWsuujdyoqu5e9uV7gI8c6vr79u176PPRaMRoNNrI3UrS\n3BqPx4zH43Wvl6pa/0rJHuAjVfXM6ddLVXXX9PM/AE6rqt9Y47Z1OPchzYMkQIfHe/D3cmdLQlU9\n7LnDdfe0k3wAGAHHJfkSsBd4YZJTgO8DtwOvnem0kqRVHdae9qbuwD1tLRD3tDUra+1pe0akJDVi\ntCWpEaMtSY0YbUlqxGhLUiNGW5IaMdqS1IjRlqRGjLYkNWK0JakRoy1JjRhtSWrEaEtSI0Zbkhox\n2pLUiNGWpEaMtiQ1YrQlqRGjLUmNGG1JasRoS1IjRluSGjHaktSI0ZakRoy2JDVitCWpEaMtSY0Y\nbUlqxGhLUiNGW5IaMdqS1IjRlqRGjLYkNWK0JakRoy1JjRhtSWrEaEtSI0Zbkhox2pLUiNGWpEaM\ntiQ1YrTF0tIekuzoj6WlPUMvkwbQ4bG53Y/PVNXW3kFSW30f2pwkwE7/GYUOj6Meawmu56zNfj2T\nUFVZud09bUlqxGhLUiNGW5IaMdqS1Mi60U5ycZIDST63bNvuJPuT3JLko0mO2doxJUlweHva7wPO\nWLHtAuBjVfVU4OPAm2c9mCTp4daNdlVdAxxcsfnlwKXTzy8FzprxXJKkVWz0mPbxVXUAoKruAo6f\n3UiSpLXM6onIDq9+l6T2dm3wdgeSnFBVB5IsAV891JX37dv30Oej0YjRaLTBu5Wk+TQejxmPx+te\n77BOY0+yB/hIVT1z+vWFwD1VdWGSNwG7q+qCNW7raew7XI9ThT3terZcz9navtPY1412kg8AI+A4\n4ACwF/gQ8E/A44A7gLOr6t41bm+0d7gevxhGZrZcz9naQdGewR0b7R2uxy+GkZkt13O2fMMoSdIq\njLYkNWK0JakRoy1JjRhtSWrEaEtSI0Zbkhox2pLUiNGWpEaMtiQ1YrQlqRGjLUmNGG1JasRoS1Ij\nRluSGjHaktSI0ZakRoy2JDVitCWpEaMtSY0YbUlqxGhLUiNGW5IaMdqS1IjRlqRGjLYkNWK0JakR\noy1JjRhtSWrEaEtSI0Zbkhox2pLUiNGWpEaMtiQ1YrQlqRGjLUmNGG1JasRoS1IjRluSGjHaktSI\n0ZakRoy2JDVitCWpEaMtSY0YbUlqxGhLUiNGW5Ia2bWZGye5Hfg68H3ggao6fRZDSZJWt6loM4n1\nqKoOzmIYSdKhbfbwSGbwPSRJh2mzwS3g6iTXJXnNLAaSJK1ts4dHnl9VdyZ5LJN431xV18xiMEnS\nw20q2lV15/R/705yBXA68LBo79u376HPR6MRo9FoM3crSXNnPB4zHo/XvV6qakN3kORRwFFVdV+S\no4H9wFurav+K69VG70PbIwmTI107WejwOOqxluB6ztrs1zMJVZWV2zezp30CcEWSmn6ff1gZbEnS\nbG14T/uw78A97R2vx96Me4az5XrO1vbtaftyPUlqxGhLUiNGW5IaMdqS1IjRlqRGjLYkNWK0JamR\nltFeWtpDkh3/sbS0Z+ilkjRnWp5cs8gvuN8KPdbTtZwt13O2PLlGkrQKoy1JjRhtSWrEaEtSI0Zb\nkhox2pLUiNGWpEaMtiQ1YrQlqRGjLUmNGG1JasRoS1IjRluSGjHaktSI0ZakRoy2JDVitCWpEaMt\nSY0YbUlqxGhLUiNGW5IaMdqS1IjRlqRGjLYkNWK0JakRoy1JjRhtSWrEaEtSI0Zbkhox2pLUiNGW\npEaMtiQ1YrQlqRGjLUmNGG1JasRoS1IjRluSGtlUtJOcmeSLSW5N8qZZDSVJWt2Go53kKOBvgDOA\nnwbOSXLyrAbbfuOhB5gz46EHmCPjoQeYM+OhB9iUzexpnw7cVlV3VNUDwGXAy2cz1hDGQw8wZ8ZD\nDzBHxkMPMGfGQw+wKZuJ9k8BX1729Vem2yRJW8QnIiWpkVTVxm6YPA/YV1VnTr++AKiqunDF9TZ2\nB5K04KoqK7dtJtqPAG4BfgG4E7gWOKeqbt7MkJKkte3a6A2r6ntJXg/sZ3KY5WKDLUlba8N72pKk\n7ecTkZLUiNGWpEaMtiQ1suEnIiVtjSRnAGfxg5PV/hu4sqquGm6qvuZtPRf2ich5+0EOzfWcjSR/\nBTwF+HsmZxkDnAi8ksnbRpw/1GwdzeN6LmS05/EHOSTXc3aS3FpVT1lle4Bbq+qkAcZqax7Xc1EP\nj/zSGj/IfwRuBYzMkXE9Z+f+JKdV1XUrtp8G3D/EQM3N3XouarTn7gc5MNdzds4F3pXkMfzgXy2P\nA74+vUxH5lzmbD0X9fDIc4B3Aav9IF9XVZ8earaOXM/ZS7LEsucHququIefpbp7WcyGj/aB5+kHu\nBK7nbEyPt57ODz+pe20t8i/rFkhyclV9ceg5jtTCRjvJ44H/rap7k+wBTgVurqqbBh2ssSSnMtnD\n/h6TJ3na/UIMLclLgXcCtzGJNUye1H0y8HtVtX+o2eZNki9V1eOHnuNILWS0p28j+1rgO8DbgDcC\nnwCex+SNry4acLx2krwAeDtwL/CzTNZyN/AA8NtV9eVD3FzLJLkZ+MWqun3F9icC/1pVTxtksKaS\n/PVaFwGvqqof3855ZmFRo30Tkz3rRwG3A0+qqruTHA38Z1U9Y8j5uknyGeCl0zV8InBRVf1KkpcA\nf1xVLx14xDaS3AY8raq+u2L7I4EvVNWTh5mspyTfAP6IyQ7aSm+vqp/Y5pE2bVFfPfK9qvp2kv8D\nvg18DaCqvjk5nKgj9Iiqunv6+ZeAJwBU1dXT13Dr8F0CXJfkMn7w5/weB7wCuHiwqfq6Dvh8Vf3H\nyguS7Nv+cTZvUfe0/w54JHA08C3gu8BVwIuAx1TV2cNN10+SS4ACPg68jMmTkH+Y5FHA9VV18qAD\nNpPk6UzWcfkTkR+uqi8MN1VPSY4F7q+qbw09y6wsarR3Ab/GJDSXA88FzmGyl/i3VfXNAcdrJ8mP\nAK8Bng58Frhk+kcyfgw4vqruGHRAaY4sZLSlnSrJMcCbmbyPy/FMdiy+ClwJ/EVV3TvgeO3M43ou\n5FuzJnl0kj9NclOSrye5O8mnkrxq6Nk6Wraen1+xnucOPVtDHwQOAqOqOraqjgNeON32wUEn62nu\n1nMh97STXAlcAXwMOJvJse3LgD9hcjz2LQOO147rOTtJbqmqpx7pZVrdPK7nokb7s1X1rGVfX1dV\npyU5isnLqnzi7Ai4nrOTZD+T//hdWlUHpttOYPI+GS+pqhcPOF4787ieC3l4BPhmkp8HSPIy4B6A\nqvo+kxfd68i4nrPz68BxwL8nOZjkHmAMHMvkXzE6MnO3nou6p/0zwHuBk4CbgFdX1a1JHgucU1Vr\nnUWlVbies5XkZCanrn+qqu5btv1M/6jEkZu39VzIaB9KkvOq6n1DzzEvXM8jk+QNwOuAm4FTgPOr\n6srpZddX1XOGnK+beVxPo71C1zeR2alczyOT5Ebg56rqvukbmV0OvL+q3pHkM1X17EEHbGYe13Mh\nT2NP8rm1LgJO2M5Z5oHrOVNHPfhP+Kq6PckIuDzJE/D5gY2Yu/VcyGgzCckZTF6ruVyAh71Hgdbl\nes7OgSSnVNUNANM9xF9m8p4kzxx2tJbmbj0XNdr/Ajz6wR/kcknG2z9Oe67n7LySyXvhPGT6jn+v\nTPLuYUZqbe7W02PaktTIor5OW5JaMtqS1IjRlqRGjLYkNWK0pcMwffMraXA+EDV3krw1yfnLvv6z\nJG9I8sYk1ya5IcneZZdfkeS6JDcm+Z1l27+R5G3TP1z8vG3+vyGtymhrHl3C5PW5ZPKXml8B3Amc\nVFWnA88GTn3wnQmB86rqNOA04Pwku6fbjwY+WVXPXu0Pw0pDWNSTazTHquqOJP+T5FnAEnA9cDrw\nkiTXMzlT82gm70p4DfD7Sc6a3vzE6fZrmZyU8c/bPb90KEZb8+q9wHlMon0J8GLgz6vqPcuvlOQF\nwIuA51bVd5L8G/Cj04vvL88+0w7j4RHNqw8BZwKnAh+dfrw6ydEASX5y+n7fxwAHp8E+mR8+dt3y\nDYU039zT1lyqqgeme80Hp3vLV0+j/MnJYW6+AfwWcBXwu0luAm4BPrn822zz2NK6fO8RzaXpS/Q+\nDfxqVf3X0PNIs+LhEc2dJE8DbgOuNtiaN+5pS1Ij7mlLUiNGW5IaMdqS1IjRlqRGjLYkNWK0JamR\n/we1R7NU9z1h8wAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x7fa8e37d4d68>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "e = elenco\n",
    "e = e[e.name == \"Christian Bale\"]\n",
    "e.groupby( e.year // 10 * 10 ).size().plot(kind='bar')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>title</th>\n",
       "      <th>year</th>\n",
       "      <th>name</th>\n",
       "      <th>type</th>\n",
       "      <th>character</th>\n",
       "      <th>n</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>47507</th>\n",
       "      <td>The Three Musketeers</td>\n",
       "      <td>1939</td>\n",
       "      <td>Don Ameche</td>\n",
       "      <td>actor</td>\n",
       "      <td>D'Artagnan</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129535</th>\n",
       "      <td>Robin Hood e i pirati</td>\n",
       "      <td>1960</td>\n",
       "      <td>Lex Barker</td>\n",
       "      <td>actor</td>\n",
       "      <td>Robin Hood</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133752</th>\n",
       "      <td>Les trois mousquetaires: La vengeance de Milady</td>\n",
       "      <td>1961</td>\n",
       "      <td>G?rard Barray</td>\n",
       "      <td>actor</td>\n",
       "      <td>D'Artagnan</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176174</th>\n",
       "      <td>Robin Hood</td>\n",
       "      <td>1991</td>\n",
       "      <td>Patrick Bergin</td>\n",
       "      <td>actor</td>\n",
       "      <td>Robin Hood</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>207693</th>\n",
       "      <td>Robin Hood: Ghosts of Sherwood</td>\n",
       "      <td>2012</td>\n",
       "      <td>Ben Bledsoe</td>\n",
       "      <td>actor</td>\n",
       "      <td>Robin Hood</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                  title  year            name  \\\n",
       "47507                              The Three Musketeers  1939      Don Ameche   \n",
       "129535                            Robin Hood e i pirati  1960      Lex Barker   \n",
       "133752  Les trois mousquetaires: La vengeance de Milady  1961   G?rard Barray   \n",
       "176174                                       Robin Hood  1991  Patrick Bergin   \n",
       "207693                   Robin Hood: Ghosts of Sherwood  2012     Ben Bledsoe   \n",
       "\n",
       "         type   character    n  \n",
       "47507   actor  D'Artagnan  1.0  \n",
       "129535  actor  Robin Hood  1.0  \n",
       "133752  actor  D'Artagnan  1.0  \n",
       "176174  actor  Robin Hood  1.0  \n",
       "207693  actor  Robin Hood  NaN  "
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "e = elenco\n",
    "e = e[(e.character == \"D'Artagnan\") | (e.character == 'Robin Hood')]\n",
    "e.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "e."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# Graficar la diferencia entre el numero de papeles \n",
    "# para actores cada año y el numero de papeles para actrices\n",
    "# cada año en la historia de la filmografia"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# Graficar en numero de papeles de actores cada año\n",
    "# y el numero de papeles para actrices cada año\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# El mismo grafico anterior pero categorizado por decada y\n",
    "# con un grafico de area\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# Graficar el porcentaje de papeles que han sido \n",
    "# actores cada año en la historia de la filmografia\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# Graficar el porcentaje de papeles que han sido \n",
    "# actores cada año en la historia de la filmografia\n",
    "# junto al mismo porcentaje pero de actrices\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# Graficar 3 lines con clasificacion \"n\" de 1 al 3 donde cada \n",
    "# linea represente el porcentaje de la clasificacion para \n",
    "# los papeles de actores en cada año.\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# Encontrar las 5 peliculas de la historia tengan mas\n",
    "# actrices que actores\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "anaconda-cloud": {},
  "kernelspec": {
   "display_name": "Python [Root]",
   "language": "python",
   "name": "Python [Root]"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.5.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}