nb07-pandas-demo-ejercicios.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Tercera parte pandas \n",
    "- Operaciones con fechas\n",
    "- Combinar dataframes\n",
    "- Reacomodar datos "
   ]
  },
  {
   "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": 2,
   "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": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Cargar nuestra base de datos de elencos\n",
    "elenco = pd.read_csv('data/cast.csv', encoding='utf-8')\n",
    "elenco.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>country</th>\n",
       "      <th>date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>#73, Shaanthi Nivaasa</td>\n",
       "      <td>2007</td>\n",
       "      <td>India</td>\n",
       "      <td>2007-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>#Beings</td>\n",
       "      <td>2015</td>\n",
       "      <td>Romania</td>\n",
       "      <td>2015-01-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>#Ewankosau saranghaeyo</td>\n",
       "      <td>2015</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>2015-01-21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>#Horror</td>\n",
       "      <td>2015</td>\n",
       "      <td>USA</td>\n",
       "      <td>2015-11-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>#Horror</td>\n",
       "      <td>2015</td>\n",
       "      <td>UK</td>\n",
       "      <td>2016-05-16</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    title  year      country        date\n",
       "0   #73, Shaanthi Nivaasa  2007        India  2007-06-15\n",
       "1                 #Beings  2015      Romania  2015-01-29\n",
       "2  #Ewankosau saranghaeyo  2015  Philippines  2015-01-21\n",
       "3                 #Horror  2015          USA  2015-11-20\n",
       "4                 #Horror  2015           UK  2016-05-16"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Ahora tambien cargaremos datos de otra base de datos\n",
    "# \n",
    "fecha_lanz = pd.read_csv('data/release_dates.csv', encoding='utf-8')\n",
    "fecha_lanz.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "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>country</th>\n",
       "      <th>date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>#73, Shaanthi Nivaasa</td>\n",
       "      <td>2007</td>\n",
       "      <td>India</td>\n",
       "      <td>2007-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>#Beings</td>\n",
       "      <td>2015</td>\n",
       "      <td>Romania</td>\n",
       "      <td>2015-01-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>#Ewankosau saranghaeyo</td>\n",
       "      <td>2015</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>2015-01-21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>#Horror</td>\n",
       "      <td>2015</td>\n",
       "      <td>USA</td>\n",
       "      <td>2015-11-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>#Horror</td>\n",
       "      <td>2015</td>\n",
       "      <td>UK</td>\n",
       "      <td>2016-05-16</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    title  year      country       date\n",
       "0   #73, Shaanthi Nivaasa  2007        India 2007-06-15\n",
       "1                 #Beings  2015      Romania 2015-01-29\n",
       "2  #Ewankosau saranghaeyo  2015  Philippines 2015-01-21\n",
       "3                 #Horror  2015          USA 2015-11-20\n",
       "4                 #Horror  2015           UK 2016-05-16"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Que tal si cargamos esta base de datos pero la columna date la convertirmos a un \n",
    "# formato datetime que tiene metodos para hacer operaciones sobre fechas.. Mejor!\n",
    "\n",
    "fecha_lanz = pd.read_csv('data/release_dates.csv' , parse_dates=['date'], infer_datetime_format=True)\n",
    "fecha_lanz.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# Podemos acceder a los metodos del namespace datetime, en pandas \"dt\"\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# Con esto que podemos hacer un listado categorizando por algun elemento de la \n",
    "# fecha como por ejemplo:\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 196,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x7f9f75cf1588>"
      ]
     },
     "execution_count": 196,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAWcAAAEDCAYAAADp3cXBAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAADk1JREFUeJzt3H+MZXV9xvHn2R0hrLjQRDpLpd01psRojJQqmNCEa/m1\n/oittf0D2qgY/csGEhoiqW0Y/mgLTVNjavuH6XajFmuFCoLRdjH02oBNAdkVhEWJdvmR7kygUg2s\nsSBP/zgHlg4zc8/O3nPvZ/a+X8lkzpxz7nm+Z3b2ued+75lxEgEAatk07QEAAF6OcgaAgihnACiI\ncgaAgihnACiIcgaAgjqVs+2TbN9ge7/tB2yf3ffAAGCWzXXc75OSvprkd2zPSdrS45gAYOZ51C+h\n2N4qaW+S101mSACALtMar5X0pO3dtu+1/WnbJ/Q9MACYZV3KeU7SmZL+OsmZkg5JuqrXUQHAjOsy\n5/y4pMeS3NN+faOkjy3fyTZ/pAMAjlASr7R+5JVzkiVJj9k+vV11nqQHV9l3XR9XX331uh97NB/T\nyuWcyd3I2e3/9lU+rl5jW46qJ6p+v48mdy1d79a4TNL1tl8h6QeSLu34OADAOnQq5yTflvTWnscC\nAGiV+A3BwWAwU7nTzOacj/3c6WZPK/fY+3ceeZ9z5wPZGdexANRlWy/MH6/j0SPnWmeJbWW9bwgC\nACaPcgaAgihnACiIcgaAgihnACiIcgaAgihnACiIcgaAgihnACiIcgaAgihnACiIcgaAgihnACiI\ncgaAgihnACiIcgaAgihnACiIcgaAgihnACiIcgaAgihnACiIcgaAgihnACiIcgaAgihnACiIcgaA\ngua67GT7gKQfSXpe0rNJzupzUAAw6zqVs5pSHiR5qs/BAAAaXac1fAT7AgCOUtfCjaTbbN9t+yN9\nDggA0H1a45wkB22foqak9ye5o8+BAcAs61TOSQ62n5+wfZOksyS9rJwXFhZeXB4MBhoMBmMZJAAc\nC4bDoYbDYad9nWTtHewtkjYledr2KyXtkXRNkj3L9suoYwHY+Gyrmelc16NFTxxmW0m80rYuV87z\nkm6ynXb/65cXMwBgvEZeOXc+EFfOwEzgynl81rpy5vY4ACiIcgaAgihnACiIcgaAgihnACiIcgaA\ngihnACiIcgaAgihnACiIcgaAgihnACiIcgaAgihnACiIcgaAgihnACiIcgaAgihnACiIcgaAgihn\nACiIcgaAgihnACiIcgaAgihnACiIcgaAgihnACiIcgaAgihnACiIcgaAgihnACiocznb3mT7Xtu3\n9DkgAMCRXTlfLunBvgYCADisUznbPk3SOyX9bb/DAQBI3a+cPyHpSknpcSwAgNbcqB1sv0vSUpJ9\ntgeSvNq+CwsLLy4PBgMNBoOjH+FR2rZth5aWHlnXY+fnt2tx8cB4B9SzozlfiXPeKGbt5/pYMRwO\nNRwOO+3rZO2LYdt/Kun3JD0n6QRJr5L0pSTvX7ZfRh1rGmxr/Rf8VsVzWsvRna/EOW8M0/y5nrX/\nU32yrSQrXvCOLOdlBzpX0h8kec8K2yjnAiiqdR1hxs6Zcq5irXLmPmcAKOiIrpzXPBBXziVwFbmu\nI8zYOXPlXAVXzgCwwVDOAFAQ5QwABVHOAFAQ5QwABVHOAFAQ5QwABVHOAFAQ5QwABVHOAFAQ5QwA\nBVHOAFAQ5QwABVHOAFAQ5QwABVHOAFAQ5QwABVHOAFAQ5QwABVHOAFAQ5QwABVHOAFAQ5QwABVHO\nAFAQ5QwABVHOAFAQ5QwABVHOAFDQ3KgdbB8v6d8kHdfuf2OSa/oeGADMspHlnOSntt+e5JDtzZLu\ntP21JHdNYHwAMJM6TWskOdQuHq+m0NPbiAAA3crZ9ibbeyUtSrotyd39DgsAZtvIaQ1JSvK8pF+x\nvVXSzbbfkOTB5fstLCy8uDwYDDQYDMY0zI1n27YdWlp6ZF2PnZ/frsXFA+Md0ARwzkdmo57ztBwL\n3+vhcKjhcNhpXydHNkNh+48lPZPkL5etz5EeaxJsa/2zMNZ6z2lj5k4zm3PeCLnTzJ7mOffFtpJ4\npW0jpzVsv9r2Se3yCZIukPTQeIcIAHipLtMap0r6jO1Nasr8H5N8td9hAcBsO+JpjVUPxLTGMZA7\nzWzOeSPkTjObaQ0AwNRRzgBQEOUMAAVRzgBQEOUMAAVRzgBQEOUMAAVRzgBQEOUMAAVRzgBQEOUM\nAAVRzgBQEOUMAAVRzgBQEOUMAAVRzgBQEOUMAAVRzgBQEOUMAAVRzgBQEOUMAAVRzgBQEOUMAAVR\nzgBQEOUMAAVRzgBQEOUMAAVRzgBQ0Mhytn2a7dttP2D7ftuXTWJgADDL5jrs85ykK5Lss32ipG/Z\n3pPkoZ7HBgAza+SVc5LFJPva5acl7Zf0mr4HBgCz7IjmnG3vkHSGpP/oYzAAgEbncm6nNG6UdHl7\nBQ0A6EmXOWfZnlNTzJ9L8uXV9ltYWHhxeTAYaDAYSJK2bduhpaVH1jXA+fntWlw8sK7HAkAlw+FQ\nw+Gw075OMnon+7OSnkxyxRr7ZLVj2ZY0OmeVI6vLGNcY11SyN2buNLM5542QO83saZ5zX2wriVfa\n1uVWunMk/a6kX7e91/a9tneOe5AAgMNGTmskuVPS5gmMBQDQ4jcEAaAgyhkACqKcAaAgyhkACqKc\nAaAgyhkACqKcAaAgyhkACqKcAaAgyhkACqKcAaAgyhkACqKcAaAgyhkACqKcAaAgyhkACqKcAaAg\nyhkACqKcAaAgyhkACqKcAaAgyhkACqKcAaAgyhkACqKcAaAgyhkACqKcAaAgyhkAChpZzrZ32V6y\nfd8kBgQA6HblvFvSRX0PBABw2MhyTnKHpKcmMBYAQIs5ZwAoiHIGgILmxnmwhYWFF5cHg4EGg8E4\nDw8AU7Ft2w4tLT2yrsfOz2/X4uIBSdJwONRwOOz0OCcZvZO9Q9KtSd60xj5Z7Vi2JY3OWeXI6jLG\nNcY1leyNmTvNbM55I+ROM/tYPGfbSuKVtnW5le7zkr4p6XTbj9q+dJ0jBAB0NHJaI8klkxgIAOAw\n3hAEgIIoZwAoiHIGgIIoZwAoiHIGgIIoZwAoiHIGgIIoZwAoiHIGgIIoZwAoiHIGgIIoZwAoiHIG\ngIIoZwAoiHIGgIIoZwAoiHIGgIIoZwAoiHIGgIIoZwAoiHIGgIIoZwAoiHIGgIIoZwAoiHIGgIIo\nZwAoiHIGgIIoZwAoqFM5295p+yHb37P9sb4HBQCzbmQ5294k6VOSLpL0RkkX2379eIcxHO/hyudO\nM3taudPMnrXcaWZPK3ea2f3kdrlyPkvSw0keSfKspC9I+o3xDmM43sOVz51m9rRyp5k9a7nTzJ5W\n7jSz+8ntUs6vkfTYS75+vF0HAOgJbwgCQEFOsvYO9tskLSTZ2X59laQkuW7ZfmsfCADwMkm80vou\n5bxZ0nclnSfpoKS7JF2cZP+4BwkAaMyN2iHJz2z/vqQ9aqZBdlHMANCvkVfOAIDJ4w1BACiIcgaA\ngmaqnG2/3vZ5tk9ctn5nz7ln2X5ru/wG21fYfmefmWuM5bNTyPy19pwvnEDW2ba3tssn2L7G9q22\nr7N9Uo+5l9n+xb6Ov0bucbbfb/v89utLbH/K9kdtv2LS48H4lJpztn1pkt09HfsySR+VtF/SGZIu\nT/Lldtu9Sc7sKfdqSe9Q8+brbZLOlvSvki6Q9C9J/qSP3Db7luWrJL1d0u2SlOQ9PeXeleSsdvkj\nar7vN0m6UNKtSa7tI7fNe0DSm5M8Z/vTkg5JulHN3UZvTvJbPeX+SNIzkr4v6R8k3ZDkiT6yluVe\nr+Zna4uk/5F0oqQvqTlfJ/lA32NAT5KU+ZD0aI/Hvl/Sie3yDkn3qCloSdrbc+5mNf95fixpa7v+\nBEn39fz9vFfS30saSDq3/XywXT63x9y9L1m+W9Ip7fIrJd3f8znvf+n5L9u2r89zVvNK9EJJuyQ9\nIemfJX1A0qt6zL2v/TwnaUnS5vZrT+Dn6yRJ10p6SNIPJf23moufayWd3Gf2iHF9rcdjb5X0Z5I+\nJ+mSZdv+ZpxZI2+lGzfb9622SdJ8j9GbkjwtSUkO2B5IutH29ja7L88l+ZmkQ7a/n+TH7Rh+Yvv5\nHnMl6S2SLpf0cUlXJtln+ydJvtFz7ibbP6emrDanvYJM8ozt53rO/s5LXoF92/Zbktxj+3RJz/aY\nmyTPq7nldE87pfAOSRdL+gtJp/SUu8n2cWqe+LaoKcwfSjpeUt/TGl9U8ypskGRRkmxvU/OE9EU1\nT1S9sL3aK12reWXcl92SHpb0T5I+ZPt9akr6p5LeNs6giZezmgK+SNJTy9Zb0jd7zF2yfUaSfZKU\n5Gnb75b0d5Le1GPu/9rekuSQpF99YWU7/9lrObdl8QnbN7SflzSZf/OTJH1Lzb9pbJ+a5GA719/n\nE6EkfVjSJ23/kaQnJf277cfU/H2YD/eY+//OK80fCbtF0i22t/SYu0vNletmNU/CN9j+gZqi+EKP\nuZK0I8t+U7gt6etsf6jn7LslfUMr/zyd3GPu65K8r12+2fbHJd1ue+xThBOfc7a9S9LuJHessO3z\nSS7pKfc0NVexiytsOyfJnT3lHt8+qy5f/2pJpya5v4/cVcbyLknnJPnDSWUuy98iaT7Jf04ga6uk\n16p5Mno8yVLPeacn+V6fGWtk/4IkJfkv2ydLOl/NFOFdPefukfR1SZ954ftre17SByVdkOT8HrO/\nI+m9SR5eYdtjSXp5c9b2fklvbC98Xlj3QUlXqpk23T62rEmXM4BjQzt1dZWaPyH88+3qJTWvGK5N\nsvzV8Tizf1vN+xffXWHbbya5uafcP5e0J8nXl63fKemvkvzy2LIoZwDj1uedV1Wzx51LOQMYO9uP\nJvmlWcoed+403hAEcAyY4p1XU8ueZC7lDGC9pnXn1TSzJ5ZLOQNYr6+ouUNh3/INtofHaPbEcplz\nBoCCZuoPHwHARkE5A0BBlDMAFEQ5A0BBlDMAFPR/AQ24OV1eEPsAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x7f9f88d5c550>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# En que meses se lanzan mas comunmente peliculas que contienen la palabra\n",
    "# \"horror\"\n",
    "fl = fecha_lanz \n",
    "fl = fl[(fl.title.str.contains('horror',case=False)) & (fl.country == 'USA')]\n",
    "fl.date.dt.month.value_counts().sort_index().plot(kind='bar')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 95,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# Exploremos la funcionalidad para unir dataframes con el metodo \"merge\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 100,
   "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>2288261</th>\n",
       "      <td>2 Guns</td>\n",
       "      <td>2013</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bobby</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2288262</th>\n",
       "      <td>A Soldier's Story</td>\n",
       "      <td>1984</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Private First Class Peterson</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2288263</th>\n",
       "      <td>American Gangster</td>\n",
       "      <td>2007</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Frank Lucas</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2288264</th>\n",
       "      <td>Antwone Fisher</td>\n",
       "      <td>2002</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Dr. Jerome Davenport</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2288265</th>\n",
       "      <td>Carbon Copy</td>\n",
       "      <td>1981</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Roger Porter</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     title  year               name   type  \\\n",
       "2288261             2 Guns  2013  Denzel Washington  actor   \n",
       "2288262  A Soldier's Story  1984  Denzel Washington  actor   \n",
       "2288263  American Gangster  2007  Denzel Washington  actor   \n",
       "2288264     Antwone Fisher  2002  Denzel Washington  actor   \n",
       "2288265        Carbon Copy  1981  Denzel Washington  actor   \n",
       "\n",
       "                            character    n  \n",
       "2288261                         Bobby  1.0  \n",
       "2288262  Private First Class Peterson  9.0  \n",
       "2288263                   Frank Lucas  1.0  \n",
       "2288264          Dr. Jerome Davenport  4.0  \n",
       "2288265                  Roger Porter  5.0  "
      ]
     },
     "execution_count": 100,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "e = elenco\n",
    "e = e[e.name == \"Denzel Washington\"]\n",
    "e.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 101,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# Nos interesa conocer la fecha de lanzamiento de las peliculas en la que ah participado \n",
    "# Denzel Washington.. Pero esa información esta en otro dataframe!!"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 102,
   "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>country</th>\n",
       "      <th>date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>#73, Shaanthi Nivaasa</td>\n",
       "      <td>2007</td>\n",
       "      <td>India</td>\n",
       "      <td>2007-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>#Beings</td>\n",
       "      <td>2015</td>\n",
       "      <td>Romania</td>\n",
       "      <td>2015-01-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>#Ewankosau saranghaeyo</td>\n",
       "      <td>2015</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>2015-01-21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>#Horror</td>\n",
       "      <td>2015</td>\n",
       "      <td>USA</td>\n",
       "      <td>2015-11-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>#Horror</td>\n",
       "      <td>2015</td>\n",
       "      <td>UK</td>\n",
       "      <td>2016-05-16</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    title  year      country       date\n",
       "0   #73, Shaanthi Nivaasa  2007        India 2007-06-15\n",
       "1                 #Beings  2015      Romania 2015-01-29\n",
       "2  #Ewankosau saranghaeyo  2015  Philippines 2015-01-21\n",
       "3                 #Horror  2015          USA 2015-11-20\n",
       "4                 #Horror  2015           UK 2016-05-16"
      ]
     },
     "execution_count": 102,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fl = fecha_lanz\n",
    "fl.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 109,
   "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",
       "      <th>country</th>\n",
       "      <th>date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2 Guns</td>\n",
       "      <td>2013</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bobby</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Thailand</td>\n",
       "      <td>2013-08-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2 Guns</td>\n",
       "      <td>2013</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bobby</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Canada</td>\n",
       "      <td>2013-08-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2 Guns</td>\n",
       "      <td>2013</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bobby</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Turkey</td>\n",
       "      <td>2013-08-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2 Guns</td>\n",
       "      <td>2013</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bobby</td>\n",
       "      <td>1.0</td>\n",
       "      <td>USA</td>\n",
       "      <td>2013-08-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2 Guns</td>\n",
       "      <td>2013</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bobby</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Iceland</td>\n",
       "      <td>2013-08-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2 Guns</td>\n",
       "      <td>2013</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bobby</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Bolivia</td>\n",
       "      <td>2013-08-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2 Guns</td>\n",
       "      <td>2013</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bobby</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Bosnia and Herzegovina</td>\n",
       "      <td>2013-08-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2 Guns</td>\n",
       "      <td>2013</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bobby</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Croatia</td>\n",
       "      <td>2013-08-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2 Guns</td>\n",
       "      <td>2013</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bobby</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Ireland</td>\n",
       "      <td>2013-08-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2 Guns</td>\n",
       "      <td>2013</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bobby</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Kenya</td>\n",
       "      <td>2013-08-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2 Guns</td>\n",
       "      <td>2013</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bobby</td>\n",
       "      <td>1.0</td>\n",
       "      <td>UK</td>\n",
       "      <td>2013-08-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2 Guns</td>\n",
       "      <td>2013</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bobby</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Israel</td>\n",
       "      <td>2013-08-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2 Guns</td>\n",
       "      <td>2013</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bobby</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Russia</td>\n",
       "      <td>2013-08-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2 Guns</td>\n",
       "      <td>2013</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bobby</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Lebanon</td>\n",
       "      <td>2013-08-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2 Guns</td>\n",
       "      <td>2013</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bobby</td>\n",
       "      <td>1.0</td>\n",
       "      <td>United Arab Emirates</td>\n",
       "      <td>2013-08-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2 Guns</td>\n",
       "      <td>2013</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bobby</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Estonia</td>\n",
       "      <td>2013-08-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2 Guns</td>\n",
       "      <td>2013</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bobby</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Ethiopia</td>\n",
       "      <td>2013-08-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2 Guns</td>\n",
       "      <td>2013</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bobby</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Ghana</td>\n",
       "      <td>2013-08-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2 Guns</td>\n",
       "      <td>2013</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bobby</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Latvia</td>\n",
       "      <td>2013-08-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2 Guns</td>\n",
       "      <td>2013</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bobby</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Lithuania</td>\n",
       "      <td>2013-08-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2 Guns</td>\n",
       "      <td>2013</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bobby</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Nigeria</td>\n",
       "      <td>2013-08-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2 Guns</td>\n",
       "      <td>2013</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bobby</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Romania</td>\n",
       "      <td>2013-08-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2 Guns</td>\n",
       "      <td>2013</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bobby</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Kazakhstan</td>\n",
       "      <td>2013-09-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2 Guns</td>\n",
       "      <td>2013</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bobby</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Kuwait</td>\n",
       "      <td>2013-09-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2 Guns</td>\n",
       "      <td>2013</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bobby</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Ukraine</td>\n",
       "      <td>2013-09-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2 Guns</td>\n",
       "      <td>2013</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bobby</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Cambodia</td>\n",
       "      <td>2013-09-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2 Guns</td>\n",
       "      <td>2013</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bobby</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Hong Kong</td>\n",
       "      <td>2013-09-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2 Guns</td>\n",
       "      <td>2013</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bobby</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Hungary</td>\n",
       "      <td>2013-09-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2 Guns</td>\n",
       "      <td>2013</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bobby</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Macao</td>\n",
       "      <td>2013-09-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2 Guns</td>\n",
       "      <td>2013</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bobby</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Republic of Macedonia</td>\n",
       "      <td>2013-09-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1355</th>\n",
       "      <td>Unstoppable</td>\n",
       "      <td>2010</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Frank</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>2010-11-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1356</th>\n",
       "      <td>Unstoppable</td>\n",
       "      <td>2010</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Frank</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Slovenia</td>\n",
       "      <td>2010-11-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1357</th>\n",
       "      <td>Unstoppable</td>\n",
       "      <td>2010</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Frank</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Ukraine</td>\n",
       "      <td>2010-11-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1358</th>\n",
       "      <td>Unstoppable</td>\n",
       "      <td>2010</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Frank</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Pakistan</td>\n",
       "      <td>2010-11-26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1359</th>\n",
       "      <td>Unstoppable</td>\n",
       "      <td>2010</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Frank</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Netherlands</td>\n",
       "      <td>2010-12-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1360</th>\n",
       "      <td>Unstoppable</td>\n",
       "      <td>2010</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Frank</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Czech Republic</td>\n",
       "      <td>2010-12-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1361</th>\n",
       "      <td>Unstoppable</td>\n",
       "      <td>2010</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Frank</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Slovakia</td>\n",
       "      <td>2010-12-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1362</th>\n",
       "      <td>Unstoppable</td>\n",
       "      <td>2010</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Frank</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Uruguay</td>\n",
       "      <td>2010-12-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1363</th>\n",
       "      <td>Unstoppable</td>\n",
       "      <td>2010</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Frank</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Australia</td>\n",
       "      <td>2011-01-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1364</th>\n",
       "      <td>Unstoppable</td>\n",
       "      <td>2010</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Frank</td>\n",
       "      <td>1.0</td>\n",
       "      <td>New Zealand</td>\n",
       "      <td>2011-01-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1365</th>\n",
       "      <td>Unstoppable</td>\n",
       "      <td>2010</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Frank</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>2011-01-07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1366</th>\n",
       "      <td>Unstoppable</td>\n",
       "      <td>2010</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Frank</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Japan</td>\n",
       "      <td>2011-01-07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1367</th>\n",
       "      <td>Unstoppable</td>\n",
       "      <td>2010</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Frank</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>2011-01-07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1368</th>\n",
       "      <td>Unstoppable</td>\n",
       "      <td>2010</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Frank</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Argentina</td>\n",
       "      <td>2011-01-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1369</th>\n",
       "      <td>Unstoppable</td>\n",
       "      <td>2010</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Frank</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Panama</td>\n",
       "      <td>2011-01-14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1370</th>\n",
       "      <td>Unstoppable</td>\n",
       "      <td>2010</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Frank</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Peru</td>\n",
       "      <td>2011-01-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1371</th>\n",
       "      <td>Virtuosity</td>\n",
       "      <td>1995</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Lt. Parker Barnes</td>\n",
       "      <td>1.0</td>\n",
       "      <td>USA</td>\n",
       "      <td>1995-08-04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1372</th>\n",
       "      <td>Virtuosity</td>\n",
       "      <td>1995</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Lt. Parker Barnes</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Spain</td>\n",
       "      <td>1995-10-18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1373</th>\n",
       "      <td>Virtuosity</td>\n",
       "      <td>1995</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Lt. Parker Barnes</td>\n",
       "      <td>1.0</td>\n",
       "      <td>South Korea</td>\n",
       "      <td>1995-11-04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1374</th>\n",
       "      <td>Virtuosity</td>\n",
       "      <td>1995</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Lt. Parker Barnes</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Argentina</td>\n",
       "      <td>1995-11-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1375</th>\n",
       "      <td>Virtuosity</td>\n",
       "      <td>1995</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Lt. Parker Barnes</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>1995-11-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1376</th>\n",
       "      <td>Virtuosity</td>\n",
       "      <td>1995</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Lt. Parker Barnes</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Taiwan</td>\n",
       "      <td>1995-11-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1377</th>\n",
       "      <td>Virtuosity</td>\n",
       "      <td>1995</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Lt. Parker Barnes</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Australia</td>\n",
       "      <td>1995-11-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1378</th>\n",
       "      <td>Virtuosity</td>\n",
       "      <td>1995</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Lt. Parker Barnes</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Belgium</td>\n",
       "      <td>1996-01-03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1379</th>\n",
       "      <td>Virtuosity</td>\n",
       "      <td>1995</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Lt. Parker Barnes</td>\n",
       "      <td>1.0</td>\n",
       "      <td>France</td>\n",
       "      <td>1996-01-03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1380</th>\n",
       "      <td>Virtuosity</td>\n",
       "      <td>1995</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Lt. Parker Barnes</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Greece</td>\n",
       "      <td>1996-01-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1381</th>\n",
       "      <td>Virtuosity</td>\n",
       "      <td>1995</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Lt. Parker Barnes</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>1996-02-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1382</th>\n",
       "      <td>Virtuosity</td>\n",
       "      <td>1995</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Lt. Parker Barnes</td>\n",
       "      <td>1.0</td>\n",
       "      <td>UK</td>\n",
       "      <td>1996-05-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1383</th>\n",
       "      <td>Virtuosity</td>\n",
       "      <td>1995</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Lt. Parker Barnes</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Japan</td>\n",
       "      <td>1996-06-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1384</th>\n",
       "      <td>Virtuosity</td>\n",
       "      <td>1995</td>\n",
       "      <td>Denzel Washington</td>\n",
       "      <td>actor</td>\n",
       "      <td>Lt. Parker Barnes</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Finland</td>\n",
       "      <td>1996-07-05</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1385 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            title  year               name   type          character    n  \\\n",
       "0          2 Guns  2013  Denzel Washington  actor              Bobby  1.0   \n",
       "1          2 Guns  2013  Denzel Washington  actor              Bobby  1.0   \n",
       "2          2 Guns  2013  Denzel Washington  actor              Bobby  1.0   \n",
       "3          2 Guns  2013  Denzel Washington  actor              Bobby  1.0   \n",
       "4          2 Guns  2013  Denzel Washington  actor              Bobby  1.0   \n",
       "5          2 Guns  2013  Denzel Washington  actor              Bobby  1.0   \n",
       "6          2 Guns  2013  Denzel Washington  actor              Bobby  1.0   \n",
       "7          2 Guns  2013  Denzel Washington  actor              Bobby  1.0   \n",
       "8          2 Guns  2013  Denzel Washington  actor              Bobby  1.0   \n",
       "9          2 Guns  2013  Denzel Washington  actor              Bobby  1.0   \n",
       "10         2 Guns  2013  Denzel Washington  actor              Bobby  1.0   \n",
       "11         2 Guns  2013  Denzel Washington  actor              Bobby  1.0   \n",
       "12         2 Guns  2013  Denzel Washington  actor              Bobby  1.0   \n",
       "13         2 Guns  2013  Denzel Washington  actor              Bobby  1.0   \n",
       "14         2 Guns  2013  Denzel Washington  actor              Bobby  1.0   \n",
       "15         2 Guns  2013  Denzel Washington  actor              Bobby  1.0   \n",
       "16         2 Guns  2013  Denzel Washington  actor              Bobby  1.0   \n",
       "17         2 Guns  2013  Denzel Washington  actor              Bobby  1.0   \n",
       "18         2 Guns  2013  Denzel Washington  actor              Bobby  1.0   \n",
       "19         2 Guns  2013  Denzel Washington  actor              Bobby  1.0   \n",
       "20         2 Guns  2013  Denzel Washington  actor              Bobby  1.0   \n",
       "21         2 Guns  2013  Denzel Washington  actor              Bobby  1.0   \n",
       "22         2 Guns  2013  Denzel Washington  actor              Bobby  1.0   \n",
       "23         2 Guns  2013  Denzel Washington  actor              Bobby  1.0   \n",
       "24         2 Guns  2013  Denzel Washington  actor              Bobby  1.0   \n",
       "25         2 Guns  2013  Denzel Washington  actor              Bobby  1.0   \n",
       "26         2 Guns  2013  Denzel Washington  actor              Bobby  1.0   \n",
       "27         2 Guns  2013  Denzel Washington  actor              Bobby  1.0   \n",
       "28         2 Guns  2013  Denzel Washington  actor              Bobby  1.0   \n",
       "29         2 Guns  2013  Denzel Washington  actor              Bobby  1.0   \n",
       "...           ...   ...                ...    ...                ...  ...   \n",
       "1355  Unstoppable  2010  Denzel Washington  actor              Frank  1.0   \n",
       "1356  Unstoppable  2010  Denzel Washington  actor              Frank  1.0   \n",
       "1357  Unstoppable  2010  Denzel Washington  actor              Frank  1.0   \n",
       "1358  Unstoppable  2010  Denzel Washington  actor              Frank  1.0   \n",
       "1359  Unstoppable  2010  Denzel Washington  actor              Frank  1.0   \n",
       "1360  Unstoppable  2010  Denzel Washington  actor              Frank  1.0   \n",
       "1361  Unstoppable  2010  Denzel Washington  actor              Frank  1.0   \n",
       "1362  Unstoppable  2010  Denzel Washington  actor              Frank  1.0   \n",
       "1363  Unstoppable  2010  Denzel Washington  actor              Frank  1.0   \n",
       "1364  Unstoppable  2010  Denzel Washington  actor              Frank  1.0   \n",
       "1365  Unstoppable  2010  Denzel Washington  actor              Frank  1.0   \n",
       "1366  Unstoppable  2010  Denzel Washington  actor              Frank  1.0   \n",
       "1367  Unstoppable  2010  Denzel Washington  actor              Frank  1.0   \n",
       "1368  Unstoppable  2010  Denzel Washington  actor              Frank  1.0   \n",
       "1369  Unstoppable  2010  Denzel Washington  actor              Frank  1.0   \n",
       "1370  Unstoppable  2010  Denzel Washington  actor              Frank  1.0   \n",
       "1371   Virtuosity  1995  Denzel Washington  actor  Lt. Parker Barnes  1.0   \n",
       "1372   Virtuosity  1995  Denzel Washington  actor  Lt. Parker Barnes  1.0   \n",
       "1373   Virtuosity  1995  Denzel Washington  actor  Lt. Parker Barnes  1.0   \n",
       "1374   Virtuosity  1995  Denzel Washington  actor  Lt. Parker Barnes  1.0   \n",
       "1375   Virtuosity  1995  Denzel Washington  actor  Lt. Parker Barnes  1.0   \n",
       "1376   Virtuosity  1995  Denzel Washington  actor  Lt. Parker Barnes  1.0   \n",
       "1377   Virtuosity  1995  Denzel Washington  actor  Lt. Parker Barnes  1.0   \n",
       "1378   Virtuosity  1995  Denzel Washington  actor  Lt. Parker Barnes  1.0   \n",
       "1379   Virtuosity  1995  Denzel Washington  actor  Lt. Parker Barnes  1.0   \n",
       "1380   Virtuosity  1995  Denzel Washington  actor  Lt. Parker Barnes  1.0   \n",
       "1381   Virtuosity  1995  Denzel Washington  actor  Lt. Parker Barnes  1.0   \n",
       "1382   Virtuosity  1995  Denzel Washington  actor  Lt. Parker Barnes  1.0   \n",
       "1383   Virtuosity  1995  Denzel Washington  actor  Lt. Parker Barnes  1.0   \n",
       "1384   Virtuosity  1995  Denzel Washington  actor  Lt. Parker Barnes  1.0   \n",
       "\n",
       "                     country       date  \n",
       "0                   Thailand 2013-08-01  \n",
       "1                     Canada 2013-08-02  \n",
       "2                     Turkey 2013-08-02  \n",
       "3                        USA 2013-08-02  \n",
       "4                    Iceland 2013-08-08  \n",
       "5                    Bolivia 2013-08-09  \n",
       "6     Bosnia and Herzegovina 2013-08-09  \n",
       "7                    Croatia 2013-08-09  \n",
       "8                    Ireland 2013-08-16  \n",
       "9                      Kenya 2013-08-16  \n",
       "10                        UK 2013-08-16  \n",
       "11                    Israel 2013-08-22  \n",
       "12                    Russia 2013-08-22  \n",
       "13                   Lebanon 2013-08-29  \n",
       "14      United Arab Emirates 2013-08-29  \n",
       "15                   Estonia 2013-08-30  \n",
       "16                  Ethiopia 2013-08-30  \n",
       "17                     Ghana 2013-08-30  \n",
       "18                    Latvia 2013-08-30  \n",
       "19                 Lithuania 2013-08-30  \n",
       "20                   Nigeria 2013-08-30  \n",
       "21                   Romania 2013-08-30  \n",
       "22                Kazakhstan 2013-09-05  \n",
       "23                    Kuwait 2013-09-05  \n",
       "24                   Ukraine 2013-09-05  \n",
       "25                  Cambodia 2013-09-12  \n",
       "26                 Hong Kong 2013-09-12  \n",
       "27                   Hungary 2013-09-12  \n",
       "28                     Macao 2013-09-12  \n",
       "29     Republic of Macedonia 2013-09-12  \n",
       "...                      ...        ...  \n",
       "1355                Portugal 2010-11-25  \n",
       "1356                Slovenia 2010-11-25  \n",
       "1357                 Ukraine 2010-11-25  \n",
       "1358                Pakistan 2010-11-26  \n",
       "1359             Netherlands 2010-12-02  \n",
       "1360          Czech Republic 2010-12-16  \n",
       "1361                Slovakia 2010-12-16  \n",
       "1362                 Uruguay 2010-12-25  \n",
       "1363               Australia 2011-01-06  \n",
       "1364             New Zealand 2011-01-06  \n",
       "1365                  Brazil 2011-01-07  \n",
       "1366                   Japan 2011-01-07  \n",
       "1367                  Mexico 2011-01-07  \n",
       "1368               Argentina 2011-01-13  \n",
       "1369                  Panama 2011-01-14  \n",
       "1370                    Peru 2011-01-20  \n",
       "1371                     USA 1995-08-04  \n",
       "1372                   Spain 1995-10-18  \n",
       "1373             South Korea 1995-11-04  \n",
       "1374               Argentina 1995-11-16  \n",
       "1375             Philippines 1995-11-22  \n",
       "1376                  Taiwan 1995-11-25  \n",
       "1377               Australia 1995-11-30  \n",
       "1378                 Belgium 1996-01-03  \n",
       "1379                  France 1996-01-03  \n",
       "1380                  Greece 1996-01-05  \n",
       "1381                  Brazil 1996-02-16  \n",
       "1382                      UK 1996-05-31  \n",
       "1383                   Japan 1996-06-08  \n",
       "1384                 Finland 1996-07-05  \n",
       "\n",
       "[1385 rows x 8 columns]"
      ]
     },
     "execution_count": 109,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Es realmente sencillo con pandas y su poderoso comando \"merge\"\n",
    "e = elenco\n",
    "e = e[e.name == \"Denzel Washington\"]\n",
    "e = e.merge(fecha_lanz)\n",
    "e"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 108,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# Pero como funciona? \n",
    "# Empata para ambas dimensiones --> keys e indices las coincidencias y \n",
    "# agrega las entradas que no estan disponibles en el primer dataframe\n",
    "\n",
    "# Por default nos funciono, pero el comando es muy flexible.\n",
    "# Mas información: http://pandas.pydata.org/pandas-docs/stable/merging.html"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Otro concepto: Pivot"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 151,
   "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>country</th>\n",
       "      <th>date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>138430</th>\n",
       "      <td>Harry Potter and the Chamber of Secrets</td>\n",
       "      <td>2002</td>\n",
       "      <td>Canada</td>\n",
       "      <td>2002-11-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138434</th>\n",
       "      <td>Harry Potter and the Chamber of Secrets</td>\n",
       "      <td>2002</td>\n",
       "      <td>USA</td>\n",
       "      <td>2002-11-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138452</th>\n",
       "      <td>Harry Potter and the Chamber of Secrets</td>\n",
       "      <td>2002</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>2002-11-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138499</th>\n",
       "      <td>Harry Potter and the Deathly Hallows: Part 1</td>\n",
       "      <td>2010</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>2010-11-18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138511</th>\n",
       "      <td>Harry Potter and the Deathly Hallows: Part 1</td>\n",
       "      <td>2010</td>\n",
       "      <td>Canada</td>\n",
       "      <td>2010-11-19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138529</th>\n",
       "      <td>Harry Potter and the Deathly Hallows: Part 1</td>\n",
       "      <td>2010</td>\n",
       "      <td>USA</td>\n",
       "      <td>2010-11-19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138584</th>\n",
       "      <td>Harry Potter and the Deathly Hallows: Part 2</td>\n",
       "      <td>2011</td>\n",
       "      <td>Canada</td>\n",
       "      <td>2011-07-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138592</th>\n",
       "      <td>Harry Potter and the Deathly Hallows: Part 2</td>\n",
       "      <td>2011</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>2011-07-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138600</th>\n",
       "      <td>Harry Potter and the Deathly Hallows: Part 2</td>\n",
       "      <td>2011</td>\n",
       "      <td>USA</td>\n",
       "      <td>2011-07-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138616</th>\n",
       "      <td>Harry Potter and the Goblet of Fire</td>\n",
       "      <td>2005</td>\n",
       "      <td>Canada</td>\n",
       "      <td>2005-11-18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138623</th>\n",
       "      <td>Harry Potter and the Goblet of Fire</td>\n",
       "      <td>2005</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>2005-11-18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138629</th>\n",
       "      <td>Harry Potter and the Goblet of Fire</td>\n",
       "      <td>2005</td>\n",
       "      <td>USA</td>\n",
       "      <td>2005-11-18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138676</th>\n",
       "      <td>Harry Potter and the Half-Blood Prince</td>\n",
       "      <td>2009</td>\n",
       "      <td>Canada</td>\n",
       "      <td>2009-07-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138686</th>\n",
       "      <td>Harry Potter and the Half-Blood Prince</td>\n",
       "      <td>2009</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>2009-07-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138695</th>\n",
       "      <td>Harry Potter and the Half-Blood Prince</td>\n",
       "      <td>2009</td>\n",
       "      <td>USA</td>\n",
       "      <td>2009-07-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138744</th>\n",
       "      <td>Harry Potter and the Order of the Phoenix</td>\n",
       "      <td>2007</td>\n",
       "      <td>Canada</td>\n",
       "      <td>2007-07-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138759</th>\n",
       "      <td>Harry Potter and the Order of the Phoenix</td>\n",
       "      <td>2007</td>\n",
       "      <td>USA</td>\n",
       "      <td>2007-07-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138765</th>\n",
       "      <td>Harry Potter and the Order of the Phoenix</td>\n",
       "      <td>2007</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>2007-07-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138815</th>\n",
       "      <td>Harry Potter and the Prisoner of Azkaban</td>\n",
       "      <td>2004</td>\n",
       "      <td>Canada</td>\n",
       "      <td>2004-06-04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138820</th>\n",
       "      <td>Harry Potter and the Prisoner of Azkaban</td>\n",
       "      <td>2004</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>2004-06-04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138826</th>\n",
       "      <td>Harry Potter and the Prisoner of Azkaban</td>\n",
       "      <td>2004</td>\n",
       "      <td>USA</td>\n",
       "      <td>2004-06-04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138855</th>\n",
       "      <td>Harry Potter and the Sorcerer's Stone</td>\n",
       "      <td>2001</td>\n",
       "      <td>Canada</td>\n",
       "      <td>2001-11-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138860</th>\n",
       "      <td>Harry Potter and the Sorcerer's Stone</td>\n",
       "      <td>2001</td>\n",
       "      <td>USA</td>\n",
       "      <td>2001-11-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138883</th>\n",
       "      <td>Harry Potter and the Sorcerer's Stone</td>\n",
       "      <td>2001</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>2001-11-30</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               title  year country       date\n",
       "138430       Harry Potter and the Chamber of Secrets  2002  Canada 2002-11-15\n",
       "138434       Harry Potter and the Chamber of Secrets  2002     USA 2002-11-15\n",
       "138452       Harry Potter and the Chamber of Secrets  2002  Mexico 2002-11-29\n",
       "138499  Harry Potter and the Deathly Hallows: Part 1  2010  Mexico 2010-11-18\n",
       "138511  Harry Potter and the Deathly Hallows: Part 1  2010  Canada 2010-11-19\n",
       "138529  Harry Potter and the Deathly Hallows: Part 1  2010     USA 2010-11-19\n",
       "138584  Harry Potter and the Deathly Hallows: Part 2  2011  Canada 2011-07-15\n",
       "138592  Harry Potter and the Deathly Hallows: Part 2  2011  Mexico 2011-07-15\n",
       "138600  Harry Potter and the Deathly Hallows: Part 2  2011     USA 2011-07-15\n",
       "138616           Harry Potter and the Goblet of Fire  2005  Canada 2005-11-18\n",
       "138623           Harry Potter and the Goblet of Fire  2005  Mexico 2005-11-18\n",
       "138629           Harry Potter and the Goblet of Fire  2005     USA 2005-11-18\n",
       "138676        Harry Potter and the Half-Blood Prince  2009  Canada 2009-07-15\n",
       "138686        Harry Potter and the Half-Blood Prince  2009  Mexico 2009-07-15\n",
       "138695        Harry Potter and the Half-Blood Prince  2009     USA 2009-07-15\n",
       "138744     Harry Potter and the Order of the Phoenix  2007  Canada 2007-07-11\n",
       "138759     Harry Potter and the Order of the Phoenix  2007     USA 2007-07-11\n",
       "138765     Harry Potter and the Order of the Phoenix  2007  Mexico 2007-07-12\n",
       "138815      Harry Potter and the Prisoner of Azkaban  2004  Canada 2004-06-04\n",
       "138820      Harry Potter and the Prisoner of Azkaban  2004  Mexico 2004-06-04\n",
       "138826      Harry Potter and the Prisoner of Azkaban  2004     USA 2004-06-04\n",
       "138855         Harry Potter and the Sorcerer's Stone  2001  Canada 2001-11-16\n",
       "138860         Harry Potter and the Sorcerer's Stone  2001     USA 2001-11-16\n",
       "138883         Harry Potter and the Sorcerer's Stone  2001  Mexico 2001-11-30"
      ]
     },
     "execution_count": 151,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Pivot permite el reacomodo de los valores del dataframe, moviendo una columna como \n",
    "# indice, otra como llave de datos y otra para los valores\n",
    "\n",
    "# Ejemplo fechas de lanzamiento de peliculas Harry Potter en Mexico, USA y Canada\n",
    "fl = fecha_lanz \n",
    "fl = fl[fl.title.str.startswith(\"Harry Potter\")]\n",
    "fl = fl[(fl.country == \"Mexico\") | (fl.country == \"USA\") | (fl.country == \"Canada\")]\n",
    "fl "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 158,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th>country</th>\n",
       "      <th>Canada</th>\n",
       "      <th>Mexico</th>\n",
       "      <th>USA</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>title</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Harry Potter and the Chamber of Secrets</th>\n",
       "      <td>2002-11-15</td>\n",
       "      <td>2002-11-29</td>\n",
       "      <td>2002-11-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Harry Potter and the Deathly Hallows: Part 1</th>\n",
       "      <td>2010-11-19</td>\n",
       "      <td>2010-11-18</td>\n",
       "      <td>2010-11-19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Harry Potter and the Deathly Hallows: Part 2</th>\n",
       "      <td>2011-07-15</td>\n",
       "      <td>2011-07-15</td>\n",
       "      <td>2011-07-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Harry Potter and the Goblet of Fire</th>\n",
       "      <td>2005-11-18</td>\n",
       "      <td>2005-11-18</td>\n",
       "      <td>2005-11-18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Harry Potter and the Half-Blood Prince</th>\n",
       "      <td>2009-07-15</td>\n",
       "      <td>2009-07-15</td>\n",
       "      <td>2009-07-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Harry Potter and the Order of the Phoenix</th>\n",
       "      <td>2007-07-11</td>\n",
       "      <td>2007-07-12</td>\n",
       "      <td>2007-07-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Harry Potter and the Prisoner of Azkaban</th>\n",
       "      <td>2004-06-04</td>\n",
       "      <td>2004-06-04</td>\n",
       "      <td>2004-06-04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Harry Potter and the Sorcerer's Stone</th>\n",
       "      <td>2001-11-16</td>\n",
       "      <td>2001-11-30</td>\n",
       "      <td>2001-11-16</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "country                                          Canada     Mexico        USA\n",
       "title                                                                        \n",
       "Harry Potter and the Chamber of Secrets      2002-11-15 2002-11-29 2002-11-15\n",
       "Harry Potter and the Deathly Hallows: Part 1 2010-11-19 2010-11-18 2010-11-19\n",
       "Harry Potter and the Deathly Hallows: Part 2 2011-07-15 2011-07-15 2011-07-15\n",
       "Harry Potter and the Goblet of Fire          2005-11-18 2005-11-18 2005-11-18\n",
       "Harry Potter and the Half-Blood Prince       2009-07-15 2009-07-15 2009-07-15\n",
       "Harry Potter and the Order of the Phoenix    2007-07-11 2007-07-12 2007-07-11\n",
       "Harry Potter and the Prisoner of Azkaban     2004-06-04 2004-06-04 2004-06-04\n",
       "Harry Potter and the Sorcerer's Stone        2001-11-16 2001-11-30 2001-11-16"
      ]
     },
     "execution_count": 158,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Reacomodemos los datos, \n",
    "# : title como indice\n",
    "# : country como columnas\n",
    "# : date como valores\n",
    "fl = fecha_lanz \n",
    "fl = fl[fl.title.str.startswith(\"Harry Potter\")]\n",
    "fl = fl[(fl.country == \"Mexico\") | (fl.country == \"USA\") | (fl.country == \"Canada\")]\n",
    "fl = fl.pivot('title','country','date')\n",
    "fl\n",
    "\n",
    "# Extra\n",
    "#fl.apply(lambda x : x.dt.month)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 149,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Ejercicios\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# En que fechas fue lanzada cada pelicula de \"Salma Hayek\"\n",
    "# dentro de un periodo de 1990 al presente en Mexico\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# En que dia de la semana se han lanzado en USA las peliculas de \n",
    "# donde aparece Tom Cuise.. Incluir un grafico \n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# Que peliculas han sido lanzadas en la mayor cantidad de \n",
    "# paises , incluir en un grafico las 5 mayores\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# Quien tiende a ser el actor si clasificado (n > 1) que mas a \n",
    "# participado en peliculas donde el protagonista es\n",
    "# Leonardo DiCaprio \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": []
  },
  {
   "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": {
  "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
}