week-6.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "756cb78f-ce59-437d-97e9-318545e8d003",
   "metadata": {},
   "source": [
    "# AS35 - TRABAJEMOS CON PANDAS "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d7487a32-1708-4a69-8ee3-1c85e6b83ef3",
   "metadata": {},
   "source": [
    "- Importa pandas y usa un alias para poder utilizar sus recursos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "4dd5b73b-2346-4362-a60c-e73900af9fd6",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "e90bd76f-23cf-4a98-bae0-59eacac4216e",
   "metadata": {
    "editable": true,
    "slideshow": {
     "slide_type": ""
    },
    "tags": []
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "pandas: 2.1.4\n"
     ]
    }
   ],
   "source": [
    "# pandas\n",
    "import pandas\n",
    "print('pandas: {}'.format(pandas.__version__))"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c40b5e24-8d66-4924-932f-08e01d52e33d",
   "metadata": {},
   "source": [
    "- Cargar como dataframe de pandas el csv imdb_titulos.csv y mostrar sus 5 primeros registros"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "4a0d399e-7f86-4ba3-9a70-fc4fcddb9204",
   "metadata": {
    "editable": true,
    "slideshow": {
     "slide_type": ""
    },
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Mahler</td>\n",
       "      <td>1974</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Ogon, voda i... mednye truby</td>\n",
       "      <td>1968</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Ana Nojoom bent alasherah wamotalagah</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Malu de Bicicleta</td>\n",
       "      <td>2010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Nazareno Apostol: Boy Ahas</td>\n",
       "      <td>1989</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                   title  year\n",
       "0                                 Mahler  1974\n",
       "1           Ogon, voda i... mednye truby  1968\n",
       "2  Ana Nojoom bent alasherah wamotalagah  2014\n",
       "3                      Malu de Bicicleta  2010\n",
       "4             Nazareno Apostol: Boy Ahas  1989"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#ruta_titulos = \"./imdb_titulos.csv\" # Esto es una ruta relativa. \n",
    "#df_titulos = pd.read_csv(ruta_titulos, delimiter=\",\")\n",
    "df_titulos.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d313a6de-e6e9-46e9-a896-1aaac5928caf",
   "metadata": {},
   "source": [
    "- Cargar como dataframe de pandas el csv imdb_elenco.csv y mostrar sus 5 primeros registros"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "e4222662-933a-475b-ac5c-77a9b3ad3578",
   "metadata": {
    "editable": true,
    "slideshow": {
     "slide_type": ""
    },
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\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": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#ruta_elenco = \"./imdb_elenco.csv\" # Esto es una ruta relativa. \n",
    "#df_elenco = pd.read_csv(ruta_elenco, delimiter=\",\")\n",
    "df_elenco.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b4eaa06e-696f-4252-b0c7-c32f07f2fac3",
   "metadata": {},
   "source": [
    "- Mostrar el número de registros del dataframe de títulos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "b78e72d6-c74c-4537-913d-b90cabe62928",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 230407 entries, 0 to 230406\n",
      "Data columns (total 2 columns):\n",
      " #   Column  Non-Null Count   Dtype \n",
      "---  ------  --------------   ----- \n",
      " 0   title   230406 non-null  object\n",
      " 1   year    230407 non-null  int64 \n",
      "dtypes: int64(1), object(1)\n",
      "memory usage: 3.5+ MB\n"
     ]
    }
   ],
   "source": [
    "df_titulos.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "dde48af9-dfbd-4adc-bef7-7b8df88df232",
   "metadata": {},
   "source": [
    "- Mostrar el número de registros del dataframe de elenco"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "bcd425d4-a8a0-46db-8186-bb6205d3844a",
   "metadata": {
    "editable": true,
    "slideshow": {
     "slide_type": ""
    },
    "tags": []
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 3564650 entries, 0 to 3564649\n",
      "Data columns (total 6 columns):\n",
      " #   Column     Dtype  \n",
      "---  ------     -----  \n",
      " 0   title      object \n",
      " 1   year       int64  \n",
      " 2   name       object \n",
      " 3   type       object \n",
      " 4   character  object \n",
      " 5   n          float64\n",
      "dtypes: float64(1), int64(1), object(4)\n",
      "memory usage: 163.2+ MB\n"
     ]
    }
   ],
   "source": [
    "df_elenco.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "7aaa52b0-962b-477a-8816-d5de24c9fb58",
   "metadata": {},
   "source": [
    "- Mostrar las 5 películas más antiguas del listado de títulos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 169,
   "id": "5313b44c-ad99-4902-9d90-21ea418520b4",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>13229</th>\n",
       "      <td>Miss Jerry</td>\n",
       "      <td>1894</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103233</th>\n",
       "      <td>The Startled Lover</td>\n",
       "      <td>1898</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133020</th>\n",
       "      <td>Reproduction of the Corbett and Jeffries Fight</td>\n",
       "      <td>1899</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51528</th>\n",
       "      <td>Family Troubles (II)</td>\n",
       "      <td>1900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195127</th>\n",
       "      <td>Pierrot's Problem, or How to Make a Fat Wife O...</td>\n",
       "      <td>1900</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    title  year\n",
       "13229                                          Miss Jerry  1894\n",
       "103233                                 The Startled Lover  1898\n",
       "133020     Reproduction of the Corbett and Jeffries Fight  1899\n",
       "51528                                Family Troubles (II)  1900\n",
       "195127  Pierrot's Problem, or How to Make a Fat Wife O...  1900"
      ]
     },
     "execution_count": 169,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_titulos_ordenado = df_titulos.sort_values(by=[\"year\"], ascending=True)\n",
    "df_titulos_ordenado.head() "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a154b654-7551-4a6f-ac71-814460726520",
   "metadata": {},
   "source": [
    "- Mostrar las películas que en el titulo tienen la palabra \"Dracula\". También mostrar el número total de películas que coincidan con este requisito"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 193,
   "id": "abe8628b-062f-4afe-8685-7db5ee6e4708",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Bonnie &amp; Clyde vs. Dracula</td>\n",
       "      <td>2008</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>House of Dracula</td>\n",
       "      <td>1945</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Batman Dracula</td>\n",
       "      <td>1964</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Terror of Dracula</td>\n",
       "      <td>2012</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Dracula Rising</td>\n",
       "      <td>1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>Dracula's Dog</td>\n",
       "      <td>1978</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>Dracula Now</td>\n",
       "      <td>2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>The Satanic Rites of Dracula</td>\n",
       "      <td>1973</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>Son of Dracula</td>\n",
       "      <td>1974</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>Dracula and Stoker</td>\n",
       "      <td>2012</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>83 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                           title  year\n",
       "0     Bonnie & Clyde vs. Dracula  2008\n",
       "1               House of Dracula  1945\n",
       "2                 Batman Dracula  1964\n",
       "3              Terror of Dracula  2012\n",
       "4                 Dracula Rising  1993\n",
       "..                           ...   ...\n",
       "78                 Dracula's Dog  1978\n",
       "79                   Dracula Now  2015\n",
       "80  The Satanic Rites of Dracula  1973\n",
       "81                Son of Dracula  1974\n",
       "82            Dracula and Stoker  2012\n",
       "\n",
       "[83 rows x 2 columns]"
      ]
     },
     "execution_count": 193,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_titulos_sNA = df_titulos.fillna(0)\n",
    "dracula = df_titulos_sNA[df_titulos_sNA['title'].str.contains('Dracula', na=False)]\n",
    "dracula.reset_index(drop=True)\n",
    "# Son 83 peliculas que contienen la palabra Dracula "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "dd3e2df5-0557-49ff-9483-18c161841583",
   "metadata": {},
   "source": [
    "- Mostrar los 10 títulos más comunes (que más se repiten)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 165,
   "id": "9061c9c0-50e1-49a4-b5de-24ae1ae1d2b6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "title\n",
       "Hamlet                  19\n",
       "Carmen                  16\n",
       "Macbeth                 15\n",
       "The Outsider            11\n",
       "Hero                    11\n",
       "The Three Musketeers    11\n",
       "Othello                 11\n",
       "Maya                    11\n",
       "Kismet                  10\n",
       "Temptation              10\n",
       "Name: count, dtype: int64"
      ]
     },
     "execution_count": 165,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "conteo_titulos = df_titulos['title'].value_counts()\n",
    "conteo_titulos.head(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "01d00cb8-09ac-4edb-b41c-0df0be631402",
   "metadata": {},
   "source": [
    "- Mostrar cual fue la primera película hecha titulada \"Romeo and Juliet\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 191,
   "id": "fe357cfa-0ef7-45af-b04e-a0eda679256e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>124702</th>\n",
       "      <td>Romeo and Juliet</td>\n",
       "      <td>1916</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   title  year\n",
       "124702  Romeo and Juliet  1916"
      ]
     },
     "execution_count": 191,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "romeo_and_juliet = df_titulos[ df_titulos [\"title\"] == \"Romeo and Juliet\"]\n",
    "romeo_and_juliet_ordenado = romeo_and_juliet.sort_values(by = [\"year\"], ascending= True)\n",
    "romeo_and_juliet_ordenado.head(1)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0f23e026-142f-4c9a-9079-a9c1d1be8301",
   "metadata": {},
   "source": [
    "- Listar todas las películas que contengan la palabra \"Exorcist\" ordenadas de la más vieja a la más reciente"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 183,
   "id": "4aa885c5-394c-4049-b480-96515d8b9858",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>The Exorcist</td>\n",
       "      <td>1973</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>O Exorcista de Mulheres</td>\n",
       "      <td>1974</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Exorcist II: The Heretic</td>\n",
       "      <td>1977</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Kung Fu Exorcist</td>\n",
       "      <td>1978</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>The Exorcist III</td>\n",
       "      <td>1990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Teenage Exorcist</td>\n",
       "      <td>1991</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Exorcist: The Beginning</td>\n",
       "      <td>2004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Dominion: Prequel to the Exorcist</td>\n",
       "      <td>2005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Costa Chica: Confession of an Exorcist</td>\n",
       "      <td>2006</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Exorcist Chronicles</td>\n",
       "      <td>2007</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>The Disco Exorcist</td>\n",
       "      <td>2011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Exorcist Chronicles</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Shark Exorcist</td>\n",
       "      <td>2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Bad Exorcists</td>\n",
       "      <td>2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Exorcistas</td>\n",
       "      <td>2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Accidental Exorcist</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>American Exorcist</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Diary of an Exorcist</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Exorcist House of Evil</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                     title  year\n",
       "0                             The Exorcist  1973\n",
       "1                  O Exorcista de Mulheres  1974\n",
       "2                 Exorcist II: The Heretic  1977\n",
       "3                         Kung Fu Exorcist  1978\n",
       "4                         The Exorcist III  1990\n",
       "5                         Teenage Exorcist  1991\n",
       "6                  Exorcist: The Beginning  2004\n",
       "7        Dominion: Prequel to the Exorcist  2005\n",
       "8   Costa Chica: Confession of an Exorcist  2006\n",
       "9                      Exorcist Chronicles  2007\n",
       "10                      The Disco Exorcist  2011\n",
       "11                     Exorcist Chronicles  2013\n",
       "12                          Shark Exorcist  2015\n",
       "13                           Bad Exorcists  2015\n",
       "14                              Exorcistas  2015\n",
       "15                     Accidental Exorcist  2016\n",
       "16                       American Exorcist  2016\n",
       "17                    Diary of an Exorcist  2016\n",
       "18                  Exorcist House of Evil  2016"
      ]
     },
     "execution_count": 183,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "exorcist = df_titulos[df_titulos['title'].str.contains('Exorcist', na=False)]\n",
    "exorcist_ordenados = exorcist.sort_values('year')\n",
    "exorcist_ordenados.reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5de96365-73a0-4b10-94ec-fc1667dfeb31",
   "metadata": {},
   "source": [
    "- Mostrar cuantas películas fueron hechas en el año 1950"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 185,
   "id": "907fe1ae-217d-4247-b618-306bf78512cc",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Emei fei jian xia</td>\n",
       "      <td>1950</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Hua jie</td>\n",
       "      <td>1950</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Spy Hunt</td>\n",
       "      <td>1950</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Sarumba</td>\n",
       "      <td>1950</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Onu affettim</td>\n",
       "      <td>1950</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1076</th>\n",
       "      <td>Deadly Is the Female</td>\n",
       "      <td>1950</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1077</th>\n",
       "      <td>Magkumpareng Putik</td>\n",
       "      <td>1950</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1078</th>\n",
       "      <td>Kanske en gentleman</td>\n",
       "      <td>1950</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1079</th>\n",
       "      <td>Dick Barton at Bay</td>\n",
       "      <td>1950</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1080</th>\n",
       "      <td>Alakh Niranjan</td>\n",
       "      <td>1950</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1081 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     title  year\n",
       "0        Emei fei jian xia  1950\n",
       "1                  Hua jie  1950\n",
       "2                 Spy Hunt  1950\n",
       "3                  Sarumba  1950\n",
       "4             Onu affettim  1950\n",
       "...                    ...   ...\n",
       "1076  Deadly Is the Female  1950\n",
       "1077    Magkumpareng Putik  1950\n",
       "1078   Kanske en gentleman  1950\n",
       "1079    Dick Barton at Bay  1950\n",
       "1080        Alakh Niranjan  1950\n",
       "\n",
       "[1081 rows x 2 columns]"
      ]
     },
     "execution_count": 185,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "peliculas1950 = df_titulos[df_titulos [\"year\"] == 1950]\n",
    "peliculas1950.reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "34a3da12-4392-42cb-ad59-4f4b81d3e6f1",
   "metadata": {},
   "source": [
    "- Mostrar cuantas películas fueron hechas de 1950 a 1959"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 192,
   "id": "6480de86-4971-4aa2-af52-c1fecc207e69",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>For Heaven's Sake</td>\n",
       "      <td>1950</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Guilty Bystander</td>\n",
       "      <td>1950</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Der keusche Adam</td>\n",
       "      <td>1950</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Huramentado</td>\n",
       "      <td>1950</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Lockende Gefahr</td>\n",
       "      <td>1950</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12601</th>\n",
       "      <td>Jiang shi fu chou</td>\n",
       "      <td>1959</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12602</th>\n",
       "      <td>Sa Libis ng Nayon</td>\n",
       "      <td>1959</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12603</th>\n",
       "      <td>Menschen im Hotel</td>\n",
       "      <td>1959</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12604</th>\n",
       "      <td>Danger Within</td>\n",
       "      <td>1959</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12605</th>\n",
       "      <td>Never Steal Anything Small</td>\n",
       "      <td>1959</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>12606 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                            title  year\n",
       "0               For Heaven's Sake  1950\n",
       "1                Guilty Bystander  1950\n",
       "2                Der keusche Adam  1950\n",
       "3                     Huramentado  1950\n",
       "4                 Lockende Gefahr  1950\n",
       "...                           ...   ...\n",
       "12601           Jiang shi fu chou  1959\n",
       "12602           Sa Libis ng Nayon  1959\n",
       "12603           Menschen im Hotel  1959\n",
       "12604               Danger Within  1959\n",
       "12605  Never Steal Anything Small  1959\n",
       "\n",
       "[12606 rows x 2 columns]"
      ]
     },
     "execution_count": 192,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "condicion_1950_1959 = (df_titulos[\"year\"] >= 1950) & (df_titulos[\"year\"] <= 1959)\n",
    "peliculas1950_1959 = df_titulos.loc[condicion_1950_1959]\n",
    "peliculas1950_1959_ordenadas = peliculas1950_1959.sort_values(by = [\"year\"], ascending = True)\n",
    "peliculas1950_1959_ordenadas.reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "38624710-1d1a-4df6-ae56-40b89e7e92ce",
   "metadata": {},
   "source": [
    "- Mostrar todos los roles o papeles que hubo en la película \"The Godfather\". También mostrar el número total de coincidencias"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 179,
   "id": "d6a8f5e4-9514-4f01-8616-c58e37ac603e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\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>51214</th>\n",
       "      <td>The Godfather</td>\n",
       "      <td>1972</td>\n",
       "      <td>Chris Anastasio</td>\n",
       "      <td>actor</td>\n",
       "      <td>Policeman</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102809</th>\n",
       "      <td>The Godfather</td>\n",
       "      <td>1972</td>\n",
       "      <td>Norm Bacchiocchi</td>\n",
       "      <td>actor</td>\n",
       "      <td>Luca Brasi's Assassin</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>220852</th>\n",
       "      <td>The Godfather</td>\n",
       "      <td>1972</td>\n",
       "      <td>Rudy Bond</td>\n",
       "      <td>actor</td>\n",
       "      <td>Cuneo</td>\n",
       "      <td>15.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>248000</th>\n",
       "      <td>The Godfather</td>\n",
       "      <td>1972</td>\n",
       "      <td>Marlon Brando</td>\n",
       "      <td>actor</td>\n",
       "      <td>Don Vito Corleone</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>248738</th>\n",
       "      <td>The Godfather</td>\n",
       "      <td>1972</td>\n",
       "      <td>Max Brandt</td>\n",
       "      <td>actor</td>\n",
       "      <td>Extra in Furniture-Moving Scene</td>\n",
       "      <td>NaN</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3137607</th>\n",
       "      <td>The Godfather</td>\n",
       "      <td>1972</td>\n",
       "      <td>Carol Morley</td>\n",
       "      <td>actress</td>\n",
       "      <td>Night Nurse</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3360381</th>\n",
       "      <td>The Godfather</td>\n",
       "      <td>1972</td>\n",
       "      <td>Ardell Sheridan</td>\n",
       "      <td>actress</td>\n",
       "      <td>Mrs. Clemenza</td>\n",
       "      <td>29.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3363276</th>\n",
       "      <td>The Godfather</td>\n",
       "      <td>1972</td>\n",
       "      <td>Talia Shire</td>\n",
       "      <td>actress</td>\n",
       "      <td>Connie</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3390198</th>\n",
       "      <td>The Godfather</td>\n",
       "      <td>1972</td>\n",
       "      <td>Filomena Spagnuolo</td>\n",
       "      <td>actress</td>\n",
       "      <td>Extra in Wedding Scene</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3399922</th>\n",
       "      <td>The Godfather</td>\n",
       "      <td>1972</td>\n",
       "      <td>Simonetta Stefanelli</td>\n",
       "      <td>actress</td>\n",
       "      <td>Apollonia - Sicilian Sequence</td>\n",
       "      <td>30.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>76 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 title  year                  name     type  \\\n",
       "51214    The Godfather  1972       Chris Anastasio    actor   \n",
       "102809   The Godfather  1972      Norm Bacchiocchi    actor   \n",
       "220852   The Godfather  1972             Rudy Bond    actor   \n",
       "248000   The Godfather  1972         Marlon Brando    actor   \n",
       "248738   The Godfather  1972            Max Brandt    actor   \n",
       "...                ...   ...                   ...      ...   \n",
       "3137607  The Godfather  1972          Carol Morley  actress   \n",
       "3360381  The Godfather  1972       Ardell Sheridan  actress   \n",
       "3363276  The Godfather  1972           Talia Shire  actress   \n",
       "3390198  The Godfather  1972    Filomena Spagnuolo  actress   \n",
       "3399922  The Godfather  1972  Simonetta Stefanelli  actress   \n",
       "\n",
       "                               character     n  \n",
       "51214                          Policeman   NaN  \n",
       "102809             Luca Brasi's Assassin   NaN  \n",
       "220852                             Cuneo  15.0  \n",
       "248000                 Don Vito Corleone   1.0  \n",
       "248738   Extra in Furniture-Moving Scene   NaN  \n",
       "...                                  ...   ...  \n",
       "3137607                      Night Nurse   NaN  \n",
       "3360381                    Mrs. Clemenza  29.0  \n",
       "3363276                           Connie  12.0  \n",
       "3390198           Extra in Wedding Scene   NaN  \n",
       "3399922    Apollonia - Sicilian Sequence  30.0  \n",
       "\n",
       "[76 rows x 6 columns]"
      ]
     },
     "execution_count": 179,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_godfather = df_elenco.loc[df_elenco[\"title\"] == \"The Godfather\"]\n",
    "df_godfather"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "92711e57-8ec6-45fe-b7c4-abf2d7a35240",
   "metadata": {},
   "source": [
    "- Mostrar el elenco completo ordenado por la clasificación \"n\" de la película \"Dracula\" de 1958"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 102,
   "id": "2d45000a-00f2-4e52-a9a0-dc6e0c83c3b8",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\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>1475047</th>\n",
       "      <td>Dracula</td>\n",
       "      <td>1958</td>\n",
       "      <td>Guy Mills</td>\n",
       "      <td>actor</td>\n",
       "      <td>Coach Driver</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1524497</th>\n",
       "      <td>Dracula</td>\n",
       "      <td>1958</td>\n",
       "      <td>John (II) Mossman</td>\n",
       "      <td>actor</td>\n",
       "      <td>Hearse Driver</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1513434</th>\n",
       "      <td>Dracula</td>\n",
       "      <td>1958</td>\n",
       "      <td>Richard (VIII) Morgan</td>\n",
       "      <td>actor</td>\n",
       "      <td>Coach Driver's Companion</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>485197</th>\n",
       "      <td>Dracula</td>\n",
       "      <td>1958</td>\n",
       "      <td>Peter Cushing</td>\n",
       "      <td>actor</td>\n",
       "      <td>Doctor Van Helsing</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1242307</th>\n",
       "      <td>Dracula</td>\n",
       "      <td>1958</td>\n",
       "      <td>Christopher Lee</td>\n",
       "      <td>actor</td>\n",
       "      <td>Dracula</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1242308</th>\n",
       "      <td>Dracula</td>\n",
       "      <td>1958</td>\n",
       "      <td>Christopher Lee</td>\n",
       "      <td>actor</td>\n",
       "      <td>Count Dracula</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>822398</th>\n",
       "      <td>Dracula</td>\n",
       "      <td>1958</td>\n",
       "      <td>Michael Gough</td>\n",
       "      <td>actor</td>\n",
       "      <td>Arthur</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3410427</th>\n",
       "      <td>Dracula</td>\n",
       "      <td>1958</td>\n",
       "      <td>Melissa Stribling</td>\n",
       "      <td>actress</td>\n",
       "      <td>Mina</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3069196</th>\n",
       "      <td>Dracula</td>\n",
       "      <td>1958</td>\n",
       "      <td>Carol Marsh</td>\n",
       "      <td>actress</td>\n",
       "      <td>Lucy</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2677557</th>\n",
       "      <td>Dracula</td>\n",
       "      <td>1958</td>\n",
       "      <td>Olga Dickie</td>\n",
       "      <td>actress</td>\n",
       "      <td>Gerda</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2220986</th>\n",
       "      <td>Dracula</td>\n",
       "      <td>1958</td>\n",
       "      <td>John Van Eyssen</td>\n",
       "      <td>actor</td>\n",
       "      <td>Jonathan</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2777216</th>\n",
       "      <td>Dracula</td>\n",
       "      <td>1958</td>\n",
       "      <td>Valerie Gaunt</td>\n",
       "      <td>actress</td>\n",
       "      <td>Vampire Woman</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2731182</th>\n",
       "      <td>Dracula</td>\n",
       "      <td>1958</td>\n",
       "      <td>Janina Faye</td>\n",
       "      <td>actress</td>\n",
       "      <td>Tania</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2444220</th>\n",
       "      <td>Dracula</td>\n",
       "      <td>1958</td>\n",
       "      <td>Barbara Archer</td>\n",
       "      <td>actress</td>\n",
       "      <td>Inga</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1285506</th>\n",
       "      <td>Dracula</td>\n",
       "      <td>1958</td>\n",
       "      <td>Charles Lloyd Pack</td>\n",
       "      <td>actor</td>\n",
       "      <td>Doctor Seward</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1453367</th>\n",
       "      <td>Dracula</td>\n",
       "      <td>1958</td>\n",
       "      <td>George Merritt</td>\n",
       "      <td>actor</td>\n",
       "      <td>Policeman</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2357769</th>\n",
       "      <td>Dracula</td>\n",
       "      <td>1958</td>\n",
       "      <td>George Woodbridge</td>\n",
       "      <td>actor</td>\n",
       "      <td>Landlord</td>\n",
       "      <td>13.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171732</th>\n",
       "      <td>Dracula</td>\n",
       "      <td>1958</td>\n",
       "      <td>George Benson</td>\n",
       "      <td>actor</td>\n",
       "      <td>Official</td>\n",
       "      <td>14.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1347640</th>\n",
       "      <td>Dracula</td>\n",
       "      <td>1958</td>\n",
       "      <td>Miles Malleson</td>\n",
       "      <td>actor</td>\n",
       "      <td>Undertaker</td>\n",
       "      <td>15.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148496</th>\n",
       "      <td>Dracula</td>\n",
       "      <td>1958</td>\n",
       "      <td>Geoffrey Bayldon</td>\n",
       "      <td>actor</td>\n",
       "      <td>Porter</td>\n",
       "      <td>16.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>423307</th>\n",
       "      <td>Dracula</td>\n",
       "      <td>1958</td>\n",
       "      <td>Paul Cole</td>\n",
       "      <td>actor</td>\n",
       "      <td>Lad</td>\n",
       "      <td>17.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           title  year                   name     type  \\\n",
       "1475047  Dracula  1958              Guy Mills    actor   \n",
       "1524497  Dracula  1958      John (II) Mossman    actor   \n",
       "1513434  Dracula  1958  Richard (VIII) Morgan    actor   \n",
       "485197   Dracula  1958          Peter Cushing    actor   \n",
       "1242307  Dracula  1958        Christopher Lee    actor   \n",
       "1242308  Dracula  1958        Christopher Lee    actor   \n",
       "822398   Dracula  1958          Michael Gough    actor   \n",
       "3410427  Dracula  1958      Melissa Stribling  actress   \n",
       "3069196  Dracula  1958            Carol Marsh  actress   \n",
       "2677557  Dracula  1958            Olga Dickie  actress   \n",
       "2220986  Dracula  1958        John Van Eyssen    actor   \n",
       "2777216  Dracula  1958          Valerie Gaunt  actress   \n",
       "2731182  Dracula  1958            Janina Faye  actress   \n",
       "2444220  Dracula  1958         Barbara Archer  actress   \n",
       "1285506  Dracula  1958     Charles Lloyd Pack    actor   \n",
       "1453367  Dracula  1958         George Merritt    actor   \n",
       "2357769  Dracula  1958      George Woodbridge    actor   \n",
       "171732   Dracula  1958          George Benson    actor   \n",
       "1347640  Dracula  1958         Miles Malleson    actor   \n",
       "148496   Dracula  1958       Geoffrey Bayldon    actor   \n",
       "423307   Dracula  1958              Paul Cole    actor   \n",
       "\n",
       "                        character     n  \n",
       "1475047              Coach Driver   0.0  \n",
       "1524497             Hearse Driver   0.0  \n",
       "1513434  Coach Driver's Companion   0.0  \n",
       "485197         Doctor Van Helsing   1.0  \n",
       "1242307                   Dracula   2.0  \n",
       "1242308             Count Dracula   2.0  \n",
       "822398                     Arthur   3.0  \n",
       "3410427                      Mina   4.0  \n",
       "3069196                      Lucy   5.0  \n",
       "2677557                     Gerda   6.0  \n",
       "2220986                  Jonathan   7.0  \n",
       "2777216             Vampire Woman   8.0  \n",
       "2731182                     Tania   9.0  \n",
       "2444220                      Inga  10.0  \n",
       "1285506             Doctor Seward  11.0  \n",
       "1453367                 Policeman  12.0  \n",
       "2357769                  Landlord  13.0  \n",
       "171732                   Official  14.0  \n",
       "1347640                Undertaker  15.0  \n",
       "148496                     Porter  16.0  \n",
       "423307                        Lad  17.0  "
      ]
     },
     "execution_count": 102,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dracula = df_elenco.loc[df_elenco[\"title\"] == \"Dracula\"] # Todas las peliculas de dracula\n",
    "dracula = dracula.fillna(0) # Relleno Nan con 0 \n",
    "dracula_1958 = dracula.loc[dracula[\"year\"] == 1958] # Dracula de 1958\n",
    "dracula_1958.sort_values(by = [\"n\"], ascending = True) # Ordeno de menor a mayor por n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "95e13a85-62e6-4a7d-bad2-b33b86246531",
   "metadata": {},
   "source": [
    "- Mostrar cuantos papeles de \"Bruce Wayne\" han sido hechos en la historia de las películas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 108,
   "id": "c0fcb23e-6beb-4178-a402-653c339160b1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\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>2341434</th>\n",
       "      <td>Batman</td>\n",
       "      <td>1943</td>\n",
       "      <td>Lewis Wilson</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bruce Wayne</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1304815</th>\n",
       "      <td>Batman and Robin</td>\n",
       "      <td>1949</td>\n",
       "      <td>Robert Lowery</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bruce Wayne</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2307987</th>\n",
       "      <td>Batman: The Movie</td>\n",
       "      <td>1966</td>\n",
       "      <td>Adam West</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bruce Wayne</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1001</th>\n",
       "      <td>Batman Fights Dracula</td>\n",
       "      <td>1967</td>\n",
       "      <td>Jing Abalos</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bruce Wayne</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2341445</th>\n",
       "      <td>The Three Stooges Follies</td>\n",
       "      <td>1974</td>\n",
       "      <td>Lewis Wilson</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bruce Wayne</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1111067</th>\n",
       "      <td>Batman</td>\n",
       "      <td>1989</td>\n",
       "      <td>Michael Keaton</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bruce Wayne</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1111069</th>\n",
       "      <td>Batman Returns</td>\n",
       "      <td>1992</td>\n",
       "      <td>Michael Keaton</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bruce Wayne</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>436781</th>\n",
       "      <td>Batman: Mask of the Phantasm</td>\n",
       "      <td>1993</td>\n",
       "      <td>Kevin Conroy</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bruce Wayne</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1140283</th>\n",
       "      <td>Batman Forever</td>\n",
       "      <td>1995</td>\n",
       "      <td>Val Kilmer</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bruce Wayne</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>414272</th>\n",
       "      <td>Batman &amp; Robin</td>\n",
       "      <td>1997</td>\n",
       "      <td>George Clooney</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bruce Wayne</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117412</th>\n",
       "      <td>Batman Begins</td>\n",
       "      <td>2005</td>\n",
       "      <td>Christian Bale</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bruce Wayne</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117443</th>\n",
       "      <td>The Dark Knight</td>\n",
       "      <td>2008</td>\n",
       "      <td>Christian Bale</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bruce Wayne</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>932275</th>\n",
       "      <td>The Dark Knight: Not So Serious</td>\n",
       "      <td>2009</td>\n",
       "      <td>Mark Hendricks</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bruce Wayne</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>932271</th>\n",
       "      <td>Batman Reboots</td>\n",
       "      <td>2010</td>\n",
       "      <td>Mark Hendricks</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bruce Wayne</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1748590</th>\n",
       "      <td>Gotham</td>\n",
       "      <td>2011</td>\n",
       "      <td>Josh Prevatte</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bruce Wayne</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>687004</th>\n",
       "      <td>Bats in the Clocktower</td>\n",
       "      <td>2011</td>\n",
       "      <td>Doug Fesler</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bruce Wayne</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>463594</th>\n",
       "      <td>Le Squatch: Master Criminal</td>\n",
       "      <td>2011</td>\n",
       "      <td>William (III) Craft</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bruce Wayne</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2077555</th>\n",
       "      <td>Batman Revealed</td>\n",
       "      <td>2012</td>\n",
       "      <td>David B. Stewart III</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bruce Wayne</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117444</th>\n",
       "      <td>The Dark Knight Rises</td>\n",
       "      <td>2012</td>\n",
       "      <td>Christian Bale</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bruce Wayne</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77679</th>\n",
       "      <td>The Lego Movie</td>\n",
       "      <td>2014</td>\n",
       "      <td>Will Arnett</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bruce Wayne</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2250242</th>\n",
       "      <td>Batman: Crusader</td>\n",
       "      <td>2014</td>\n",
       "      <td>Andrew Vinogradsky</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bruce Wayne</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2033963</th>\n",
       "      <td>Batman Beyond: Rising Knight</td>\n",
       "      <td>2014</td>\n",
       "      <td>Joe Sobalo Jr.</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bruce Wayne</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1364945</th>\n",
       "      <td>Caped Crusader: The Dark Hours</td>\n",
       "      <td>2014</td>\n",
       "      <td>Tom Mariano</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bruce Wayne</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>463596</th>\n",
       "      <td>Le Squatch: Master Criminal 2.0</td>\n",
       "      <td>2014</td>\n",
       "      <td>William (III) Craft</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bruce Wayne</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1183764</th>\n",
       "      <td>I Had Fun</td>\n",
       "      <td>2015</td>\n",
       "      <td>Miles Krofcheck</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bruce Wayne</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>932273</th>\n",
       "      <td>The Dark Knight Falls</td>\n",
       "      <td>2015</td>\n",
       "      <td>Mark Hendricks</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bruce Wayne</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222593</th>\n",
       "      <td>She Kills</td>\n",
       "      <td>2016</td>\n",
       "      <td>Nathan Bonk</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bruce Wayne</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>436782</th>\n",
       "      <td>Batman: The Killing Joke</td>\n",
       "      <td>2016</td>\n",
       "      <td>Kevin Conroy</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bruce Wayne</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1364943</th>\n",
       "      <td>Caped Crusader: Gotham Underground</td>\n",
       "      <td>2016</td>\n",
       "      <td>Tom Mariano</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bruce Wayne</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1003771</th>\n",
       "      <td>Batman: The Shattered Cowl</td>\n",
       "      <td>2016</td>\n",
       "      <td>George (III) Hutchinson</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bruce Wayne</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15825</th>\n",
       "      <td>Suicide Squad</td>\n",
       "      <td>2016</td>\n",
       "      <td>Ben Affleck</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bruce Wayne</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2307985</th>\n",
       "      <td>Batman: Return of the Caped Crusaders</td>\n",
       "      <td>2016</td>\n",
       "      <td>Adam West</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bruce Wayne</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15783</th>\n",
       "      <td>Batman v Superman: Dawn of Justice</td>\n",
       "      <td>2016</td>\n",
       "      <td>Ben Affleck</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bruce Wayne</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>313015</th>\n",
       "      <td>B@ (Batman Parody Film)</td>\n",
       "      <td>2016</td>\n",
       "      <td>Tony Calkins</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bruce Wayne</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>463599</th>\n",
       "      <td>The Adventures of the Fatbat Episode II, the I...</td>\n",
       "      <td>2016</td>\n",
       "      <td>William (III) Craft</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bruce Wayne</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15809</th>\n",
       "      <td>Justice League</td>\n",
       "      <td>2017</td>\n",
       "      <td>Ben Affleck</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bruce Wayne</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77677</th>\n",
       "      <td>The Lego Batman Movie</td>\n",
       "      <td>2017</td>\n",
       "      <td>Will Arnett</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bruce Wayne</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>463601</th>\n",
       "      <td>The Adventures of the Fatbat Episode III, Quee...</td>\n",
       "      <td>2017</td>\n",
       "      <td>William (III) Craft</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bruce Wayne</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                     title  year  \\\n",
       "2341434                                             Batman  1943   \n",
       "1304815                                   Batman and Robin  1949   \n",
       "2307987                                  Batman: The Movie  1966   \n",
       "1001                                 Batman Fights Dracula  1967   \n",
       "2341445                          The Three Stooges Follies  1974   \n",
       "1111067                                             Batman  1989   \n",
       "1111069                                     Batman Returns  1992   \n",
       "436781                        Batman: Mask of the Phantasm  1993   \n",
       "1140283                                     Batman Forever  1995   \n",
       "414272                                      Batman & Robin  1997   \n",
       "117412                                       Batman Begins  2005   \n",
       "117443                                     The Dark Knight  2008   \n",
       "932275                     The Dark Knight: Not So Serious  2009   \n",
       "932271                                      Batman Reboots  2010   \n",
       "1748590                                             Gotham  2011   \n",
       "687004                              Bats in the Clocktower  2011   \n",
       "463594                         Le Squatch: Master Criminal  2011   \n",
       "2077555                                    Batman Revealed  2012   \n",
       "117444                               The Dark Knight Rises  2012   \n",
       "77679                                       The Lego Movie  2014   \n",
       "2250242                                   Batman: Crusader  2014   \n",
       "2033963                       Batman Beyond: Rising Knight  2014   \n",
       "1364945                     Caped Crusader: The Dark Hours  2014   \n",
       "463596                     Le Squatch: Master Criminal 2.0  2014   \n",
       "1183764                                          I Had Fun  2015   \n",
       "932273                               The Dark Knight Falls  2015   \n",
       "222593                                           She Kills  2016   \n",
       "436782                            Batman: The Killing Joke  2016   \n",
       "1364943                 Caped Crusader: Gotham Underground  2016   \n",
       "1003771                         Batman: The Shattered Cowl  2016   \n",
       "15825                                        Suicide Squad  2016   \n",
       "2307985              Batman: Return of the Caped Crusaders  2016   \n",
       "15783                   Batman v Superman: Dawn of Justice  2016   \n",
       "313015                             B@ (Batman Parody Film)  2016   \n",
       "463599   The Adventures of the Fatbat Episode II, the I...  2016   \n",
       "15809                                       Justice League  2017   \n",
       "77677                                The Lego Batman Movie  2017   \n",
       "463601   The Adventures of the Fatbat Episode III, Quee...  2017   \n",
       "\n",
       "                            name   type    character     n  \n",
       "2341434             Lewis Wilson  actor  Bruce Wayne   1.0  \n",
       "1304815            Robert Lowery  actor  Bruce Wayne   1.0  \n",
       "2307987                Adam West  actor  Bruce Wayne   1.0  \n",
       "1001                 Jing Abalos  actor  Bruce Wayne   1.0  \n",
       "2341445             Lewis Wilson  actor  Bruce Wayne   NaN  \n",
       "1111067           Michael Keaton  actor  Bruce Wayne   1.0  \n",
       "1111069           Michael Keaton  actor  Bruce Wayne   1.0  \n",
       "436781              Kevin Conroy  actor  Bruce Wayne   1.0  \n",
       "1140283               Val Kilmer  actor  Bruce Wayne   1.0  \n",
       "414272            George Clooney  actor  Bruce Wayne   2.0  \n",
       "117412            Christian Bale  actor  Bruce Wayne   1.0  \n",
       "117443            Christian Bale  actor  Bruce Wayne   1.0  \n",
       "932275            Mark Hendricks  actor  Bruce Wayne   2.0  \n",
       "932271            Mark Hendricks  actor  Bruce Wayne   1.0  \n",
       "1748590            Josh Prevatte  actor  Bruce Wayne   2.0  \n",
       "687004               Doug Fesler  actor  Bruce Wayne   3.0  \n",
       "463594       William (III) Craft  actor  Bruce Wayne   NaN  \n",
       "2077555     David B. Stewart III  actor  Bruce Wayne   1.0  \n",
       "117444            Christian Bale  actor  Bruce Wayne   1.0  \n",
       "77679                Will Arnett  actor  Bruce Wayne   1.0  \n",
       "2250242       Andrew Vinogradsky  actor  Bruce Wayne   NaN  \n",
       "2033963           Joe Sobalo Jr.  actor  Bruce Wayne   NaN  \n",
       "1364945              Tom Mariano  actor  Bruce Wayne   1.0  \n",
       "463596       William (III) Craft  actor  Bruce Wayne   4.0  \n",
       "1183764          Miles Krofcheck  actor  Bruce Wayne   NaN  \n",
       "932273            Mark Hendricks  actor  Bruce Wayne   1.0  \n",
       "222593               Nathan Bonk  actor  Bruce Wayne  11.0  \n",
       "436782              Kevin Conroy  actor  Bruce Wayne   1.0  \n",
       "1364943              Tom Mariano  actor  Bruce Wayne   NaN  \n",
       "1003771  George (III) Hutchinson  actor  Bruce Wayne   1.0  \n",
       "15825                Ben Affleck  actor  Bruce Wayne   NaN  \n",
       "2307985                Adam West  actor  Bruce Wayne   1.0  \n",
       "15783                Ben Affleck  actor  Bruce Wayne   1.0  \n",
       "313015              Tony Calkins  actor  Bruce Wayne   NaN  \n",
       "463599       William (III) Craft  actor  Bruce Wayne   NaN  \n",
       "15809                Ben Affleck  actor  Bruce Wayne   NaN  \n",
       "77677                Will Arnett  actor  Bruce Wayne   NaN  \n",
       "463601       William (III) Craft  actor  Bruce Wayne   NaN  "
      ]
     },
     "execution_count": 108,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bruce_wayne = df_elenco.loc[df_elenco[\"character\"] == \"Bruce Wayne\"]\n",
    "bruce_wayne.sort_values(by = [\"year\"])"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6b39d849-c75a-4323-98fd-a4c98f47fc87",
   "metadata": {},
   "source": [
    "- Mostrar cuantos papeles ha hecho \"Robert De Niro\" en su carrera"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 120,
   "id": "19c92769-2b8f-460d-a111-70ecb4ee7849",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\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>Greetings</th>\n",
       "      <td>1968</td>\n",
       "      <td>Robert De Niro</td>\n",
       "      <td>actor</td>\n",
       "      <td>Jon Rubin</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Les jeunes loups</th>\n",
       "      <td>1968</td>\n",
       "      <td>Robert De Niro</td>\n",
       "      <td>actor</td>\n",
       "      <td>Un hippie chez Popov</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The Wedding Party</th>\n",
       "      <td>1969</td>\n",
       "      <td>Robert De Niro</td>\n",
       "      <td>actor</td>\n",
       "      <td>Cecil</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sam's Song</th>\n",
       "      <td>1969</td>\n",
       "      <td>Robert De Niro</td>\n",
       "      <td>actor</td>\n",
       "      <td>Sam Nicoletti</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hi, Mom!</th>\n",
       "      <td>1970</td>\n",
       "      <td>Robert De Niro</td>\n",
       "      <td>actor</td>\n",
       "      <td>Jon Rubin</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The Intern</th>\n",
       "      <td>2015</td>\n",
       "      <td>Robert De Niro</td>\n",
       "      <td>actor</td>\n",
       "      <td>Ben</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hands of Stone</th>\n",
       "      <td>2016</td>\n",
       "      <td>Robert De Niro</td>\n",
       "      <td>actor</td>\n",
       "      <td>Ray Arcel</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Dirty Grandpa</th>\n",
       "      <td>2016</td>\n",
       "      <td>Robert De Niro</td>\n",
       "      <td>actor</td>\n",
       "      <td>Dick Kelly</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Untitled De Niro - Ramirez - Jakubowicz Project</th>\n",
       "      <td>2017</td>\n",
       "      <td>Robert De Niro</td>\n",
       "      <td>actor</td>\n",
       "      <td>G.B.</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The Comedian</th>\n",
       "      <td>2017</td>\n",
       "      <td>Robert De Niro</td>\n",
       "      <td>actor</td>\n",
       "      <td>Jackie</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>101 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                 year            name   type  \\\n",
       "title                                                                          \n",
       "Greetings                                        1968  Robert De Niro  actor   \n",
       "Les jeunes loups                                 1968  Robert De Niro  actor   \n",
       "The Wedding Party                                1969  Robert De Niro  actor   \n",
       "Sam's Song                                       1969  Robert De Niro  actor   \n",
       "Hi, Mom!                                         1970  Robert De Niro  actor   \n",
       "...                                               ...             ...    ...   \n",
       "The Intern                                       2015  Robert De Niro  actor   \n",
       "Hands of Stone                                   2016  Robert De Niro  actor   \n",
       "Dirty Grandpa                                    2016  Robert De Niro  actor   \n",
       "Untitled De Niro - Ramirez - Jakubowicz Project  2017  Robert De Niro  actor   \n",
       "The Comedian                                     2017  Robert De Niro  actor   \n",
       "\n",
       "                                                            character    n  \n",
       "title                                                                       \n",
       "Greetings                                                   Jon Rubin  2.0  \n",
       "Les jeunes loups                                 Un hippie chez Popov  NaN  \n",
       "The Wedding Party                                               Cecil  7.0  \n",
       "Sam's Song                                              Sam Nicoletti  1.0  \n",
       "Hi, Mom!                                                    Jon Rubin  2.0  \n",
       "...                                                               ...  ...  \n",
       "The Intern                                                        Ben  1.0  \n",
       "Hands of Stone                                              Ray Arcel  2.0  \n",
       "Dirty Grandpa                                              Dick Kelly  1.0  \n",
       "Untitled De Niro - Ramirez - Jakubowicz Project                  G.B.  NaN  \n",
       "The Comedian                                                   Jackie  NaN  \n",
       "\n",
       "[101 rows x 5 columns]"
      ]
     },
     "execution_count": 120,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "de_niro = df_elenco[df_elenco[\"name\"] == 'Robert De Niro']\n",
    "de_niro_gb = de_niro.groupby(\"title\")\n",
    "de_niro_gb_first = de_niro_gb.first()\n",
    "de_niro_gb_first.sort_values(\"year\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f9c4e597-f00d-40fe-8667-b95f4bd6cc04",
   "metadata": {},
   "source": [
    "- Listado de papeles como protagonista (n=1) que tuvo el actor \"Charlton Heston\" en la década de los 60's, ordenado por año de forma descendente"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 125,
   "id": "3110d636-a142-40bd-9e4e-4db68e041278",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\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>944054</th>\n",
       "      <td>El Cid</td>\n",
       "      <td>1961</td>\n",
       "      <td>Charlton Heston</td>\n",
       "      <td>actor</td>\n",
       "      <td>El Cid Rodrigo de Vivar</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>944052</th>\n",
       "      <td>Diamond Head</td>\n",
       "      <td>1962</td>\n",
       "      <td>Charlton Heston</td>\n",
       "      <td>actor</td>\n",
       "      <td>Richard 'King' Howland</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>944101</th>\n",
       "      <td>The Pigeon That Took Rome</td>\n",
       "      <td>1962</td>\n",
       "      <td>Charlton Heston</td>\n",
       "      <td>actor</td>\n",
       "      <td>Captain Paul MacDougall</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>944102</th>\n",
       "      <td>The Pigeon That Took Rome</td>\n",
       "      <td>1962</td>\n",
       "      <td>Charlton Heston</td>\n",
       "      <td>actor</td>\n",
       "      <td>Benny the Snatch</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>944103</th>\n",
       "      <td>The Pigeon That Took Rome</td>\n",
       "      <td>1962</td>\n",
       "      <td>Charlton Heston</td>\n",
       "      <td>actor</td>\n",
       "      <td>Narrator</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>944038</th>\n",
       "      <td>55 Days at Peking</td>\n",
       "      <td>1963</td>\n",
       "      <td>Charlton Heston</td>\n",
       "      <td>actor</td>\n",
       "      <td>Maj. Matt Lewis</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>944068</th>\n",
       "      <td>Major Dundee</td>\n",
       "      <td>1965</td>\n",
       "      <td>Charlton Heston</td>\n",
       "      <td>actor</td>\n",
       "      <td>Major Amos Charles Dundee</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>944085</th>\n",
       "      <td>The Agony and the Ecstasy</td>\n",
       "      <td>1965</td>\n",
       "      <td>Charlton Heston</td>\n",
       "      <td>actor</td>\n",
       "      <td>Michelangelo</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>944111</th>\n",
       "      <td>The War Lord</td>\n",
       "      <td>1965</td>\n",
       "      <td>Charlton Heston</td>\n",
       "      <td>actor</td>\n",
       "      <td>Chrysagon</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>944066</th>\n",
       "      <td>Khartoum</td>\n",
       "      <td>1966</td>\n",
       "      <td>Charlton Heston</td>\n",
       "      <td>actor</td>\n",
       "      <td>Gen. Charles 'Chinese' Gordon</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>944050</th>\n",
       "      <td>Counterpoint</td>\n",
       "      <td>1967</td>\n",
       "      <td>Charlton Heston</td>\n",
       "      <td>actor</td>\n",
       "      <td>Lionel Evans</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>944120</th>\n",
       "      <td>Will Penny</td>\n",
       "      <td>1967</td>\n",
       "      <td>Charlton Heston</td>\n",
       "      <td>actor</td>\n",
       "      <td>Will Penny</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>944077</th>\n",
       "      <td>Planet of the Apes</td>\n",
       "      <td>1968</td>\n",
       "      <td>Charlton Heston</td>\n",
       "      <td>actor</td>\n",
       "      <td>George Taylor</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>944074</th>\n",
       "      <td>Number One</td>\n",
       "      <td>1969</td>\n",
       "      <td>Charlton Heston</td>\n",
       "      <td>actor</td>\n",
       "      <td>Ron 'Cat' Catlan</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                            title  year             name   type  \\\n",
       "944054                     El Cid  1961  Charlton Heston  actor   \n",
       "944052               Diamond Head  1962  Charlton Heston  actor   \n",
       "944101  The Pigeon That Took Rome  1962  Charlton Heston  actor   \n",
       "944102  The Pigeon That Took Rome  1962  Charlton Heston  actor   \n",
       "944103  The Pigeon That Took Rome  1962  Charlton Heston  actor   \n",
       "944038          55 Days at Peking  1963  Charlton Heston  actor   \n",
       "944068               Major Dundee  1965  Charlton Heston  actor   \n",
       "944085  The Agony and the Ecstasy  1965  Charlton Heston  actor   \n",
       "944111               The War Lord  1965  Charlton Heston  actor   \n",
       "944066                   Khartoum  1966  Charlton Heston  actor   \n",
       "944050               Counterpoint  1967  Charlton Heston  actor   \n",
       "944120                 Will Penny  1967  Charlton Heston  actor   \n",
       "944077         Planet of the Apes  1968  Charlton Heston  actor   \n",
       "944074                 Number One  1969  Charlton Heston  actor   \n",
       "\n",
       "                            character    n  \n",
       "944054        El Cid Rodrigo de Vivar  1.0  \n",
       "944052         Richard 'King' Howland  1.0  \n",
       "944101        Captain Paul MacDougall  1.0  \n",
       "944102               Benny the Snatch  1.0  \n",
       "944103                       Narrator  1.0  \n",
       "944038                Maj. Matt Lewis  1.0  \n",
       "944068      Major Amos Charles Dundee  1.0  \n",
       "944085                   Michelangelo  1.0  \n",
       "944111                      Chrysagon  1.0  \n",
       "944066  Gen. Charles 'Chinese' Gordon  1.0  \n",
       "944050                   Lionel Evans  1.0  \n",
       "944120                     Will Penny  1.0  \n",
       "944077                  George Taylor  1.0  \n",
       "944074               Ron 'Cat' Catlan  1.0  "
      ]
     },
     "execution_count": 125,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "n1 = df_elenco[df_elenco[\"n\"] == 1]\n",
    "charlton_heston_n1 = n1.loc[n1[\"name\"] == \"Charlton Heston\"]\n",
    "condicion_60 = (charlton_heston_n1[\"year\"] >= 1960) & (charlton_heston_n1[\"year\"] <= 1969)\n",
    "charlton_heston_n1_60 = charlton_heston_n1[condicion_60]\n",
    "charlton_heston_n1_60.sort_values(\"year\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d0127e8b-1733-4096-90a5-c5d81ce7b83c",
   "metadata": {},
   "source": [
    "- Mostrar cuántos papeles para actores hubo en la década de los 50's"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 134,
   "id": "4e978b14-3d2e-4c08-b9ac-c81b2e58534e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\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>63</th>\n",
       "      <td>Fire Down Below</td>\n",
       "      <td>1957</td>\n",
       "      <td>'Stretch' Cox Troupe</td>\n",
       "      <td>actor</td>\n",
       "      <td>Limbo Dance by</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>Dorp aan de rivier</td>\n",
       "      <td>1958</td>\n",
       "      <td>Frans 't Hoen</td>\n",
       "      <td>actor</td>\n",
       "      <td>Dirk Jan</td>\n",
       "      <td>15.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>Die Todesarena</td>\n",
       "      <td>1953</td>\n",
       "      <td>Die 3 Motorellos</td>\n",
       "      <td>actor</td>\n",
       "      <td>Themselves</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>252</th>\n",
       "      <td>Palletoori Pilla</td>\n",
       "      <td>1950</td>\n",
       "      <td>Subba Rao A.V.</td>\n",
       "      <td>actor</td>\n",
       "      <td>Kampanna Dora</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>253</th>\n",
       "      <td>Sri Kalahastiswara Mahatyam</td>\n",
       "      <td>1954</td>\n",
       "      <td>Subba Rao A.V.</td>\n",
       "      <td>actor</td>\n",
       "      <td>Basavareddy</td>\n",
       "      <td>12.0</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2409050</th>\n",
       "      <td>Salve sauegjeter</td>\n",
       "      <td>1958</td>\n",
       "      <td>?yvind ?yen</td>\n",
       "      <td>actor</td>\n",
       "      <td>Asbj?rn, sauegjeter</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2409058</th>\n",
       "      <td>La noche avanza</td>\n",
       "      <td>1952</td>\n",
       "      <td>Francisco ?beda</td>\n",
       "      <td>actor</td>\n",
       "      <td>Pelotari</td>\n",
       "      <td>21.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2409120</th>\n",
       "      <td>Yaban kiz</td>\n",
       "      <td>1954</td>\n",
       "      <td>Memduh ?n</td>\n",
       "      <td>actor</td>\n",
       "      <td>Mehmet</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2409228</th>\n",
       "      <td>Barbaros Hayrettin Pasa</td>\n",
       "      <td>1951</td>\n",
       "      <td>Ali ?st?ntas</td>\n",
       "      <td>actor</td>\n",
       "      <td>Levend</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2409229</th>\n",
       "      <td>Kara Efe</td>\n",
       "      <td>1952</td>\n",
       "      <td>Ali ?st?ntas</td>\n",
       "      <td>actor</td>\n",
       "      <td>Kara Efe</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>153998 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                               title  year                  name   type  \\\n",
       "63                   Fire Down Below  1957  'Stretch' Cox Troupe  actor   \n",
       "65                Dorp aan de rivier  1958         Frans 't Hoen  actor   \n",
       "112                   Die Todesarena  1953      Die 3 Motorellos  actor   \n",
       "252                 Palletoori Pilla  1950        Subba Rao A.V.  actor   \n",
       "253      Sri Kalahastiswara Mahatyam  1954        Subba Rao A.V.  actor   \n",
       "...                              ...   ...                   ...    ...   \n",
       "2409050             Salve sauegjeter  1958           ?yvind ?yen  actor   \n",
       "2409058              La noche avanza  1952       Francisco ?beda  actor   \n",
       "2409120                    Yaban kiz  1954             Memduh ?n  actor   \n",
       "2409228      Barbaros Hayrettin Pasa  1951          Ali ?st?ntas  actor   \n",
       "2409229                     Kara Efe  1952          Ali ?st?ntas  actor   \n",
       "\n",
       "                   character     n  \n",
       "63            Limbo Dance by  20.0  \n",
       "65                  Dirk Jan  15.0  \n",
       "112               Themselves   NaN  \n",
       "252            Kampanna Dora   4.0  \n",
       "253              Basavareddy  12.0  \n",
       "...                      ...   ...  \n",
       "2409050  Asbj?rn, sauegjeter   2.0  \n",
       "2409058             Pelotari  21.0  \n",
       "2409120               Mehmet   4.0  \n",
       "2409228               Levend   NaN  \n",
       "2409229             Kara Efe   1.0  \n",
       "\n",
       "[153998 rows x 6 columns]"
      ]
     },
     "execution_count": 134,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "condicion_50 = (df_elenco[\"year\"] >= 1950) & (df_elenco[\"year\"] <= 1959)\n",
    "decada50 = df_elenco[condicion_50]\n",
    "decada50_actor = decada50.loc[decada50[\"type\"] == \"actor\"]\n",
    "decada50_actor"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "16a28f66-dd97-41a3-82b2-dbec96c0a3aa",
   "metadata": {},
   "source": [
    "- Mostrar cuántos papeles para actrices hubo en la década de los 50's"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 136,
   "id": "1d535aeb-3fac-46ca-873f-8c1b115b5bca",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\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>2409266</th>\n",
       "      <td>A Woman of Distinction</td>\n",
       "      <td>1950</td>\n",
       "      <td>Lucienne &amp; Ashour</td>\n",
       "      <td>actress</td>\n",
       "      <td>Apache Dancers</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2409268</th>\n",
       "      <td>Chain Lightning</td>\n",
       "      <td>1950</td>\n",
       "      <td>Lucienne &amp; Ashour</td>\n",
       "      <td>actress</td>\n",
       "      <td>Apache Dancers</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2409274</th>\n",
       "      <td>De moedige bruidegom</td>\n",
       "      <td>1952</td>\n",
       "      <td>Hilda 't Seyen</td>\n",
       "      <td>actress</td>\n",
       "      <td>De moeder van Tinneke</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2409303</th>\n",
       "      <td>Cuban Rebel Girls</td>\n",
       "      <td>1959</td>\n",
       "      <td>Beverly Aadland</td>\n",
       "      <td>actress</td>\n",
       "      <td>Beverly Woods</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2409304</th>\n",
       "      <td>Death of a Salesman</td>\n",
       "      <td>1951</td>\n",
       "      <td>Beverly Aadland</td>\n",
       "      <td>actress</td>\n",
       "      <td>Girl</td>\n",
       "      <td>NaN</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3564542</th>\n",
       "      <td>Styrmand Karlsen</td>\n",
       "      <td>1958</td>\n",
       "      <td>Clara ?st?</td>\n",
       "      <td>actress</td>\n",
       "      <td>Dronning Viktoria</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3564543</th>\n",
       "      <td>Styrmand Karlsen</td>\n",
       "      <td>1958</td>\n",
       "      <td>Clara ?st?</td>\n",
       "      <td>actress</td>\n",
       "      <td>The Queen</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3564545</th>\n",
       "      <td>Tre piger fra Jylland</td>\n",
       "      <td>1957</td>\n",
       "      <td>Clara ?st?</td>\n",
       "      <td>actress</td>\n",
       "      <td>Frk. Lind</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3564559</th>\n",
       "      <td>Toya</td>\n",
       "      <td>1956</td>\n",
       "      <td>Aslaug ?ye</td>\n",
       "      <td>actress</td>\n",
       "      <td>moren til Trygve</td>\n",
       "      <td>19.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3564577</th>\n",
       "      <td>Akdeniz korsanlari</td>\n",
       "      <td>1950</td>\n",
       "      <td>Muazzez ?lkerer</td>\n",
       "      <td>actress</td>\n",
       "      <td>Maria</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>56004 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                          title  year               name     type  \\\n",
       "2409266  A Woman of Distinction  1950  Lucienne & Ashour  actress   \n",
       "2409268         Chain Lightning  1950  Lucienne & Ashour  actress   \n",
       "2409274    De moedige bruidegom  1952     Hilda 't Seyen  actress   \n",
       "2409303       Cuban Rebel Girls  1959    Beverly Aadland  actress   \n",
       "2409304     Death of a Salesman  1951    Beverly Aadland  actress   \n",
       "...                         ...   ...                ...      ...   \n",
       "3564542        Styrmand Karlsen  1958         Clara ?st?  actress   \n",
       "3564543        Styrmand Karlsen  1958         Clara ?st?  actress   \n",
       "3564545   Tre piger fra Jylland  1957         Clara ?st?  actress   \n",
       "3564559                    Toya  1956         Aslaug ?ye  actress   \n",
       "3564577      Akdeniz korsanlari  1950    Muazzez ?lkerer  actress   \n",
       "\n",
       "                     character     n  \n",
       "2409266         Apache Dancers   NaN  \n",
       "2409268         Apache Dancers   NaN  \n",
       "2409274  De moeder van Tinneke   NaN  \n",
       "2409303          Beverly Woods   2.0  \n",
       "2409304                   Girl   NaN  \n",
       "...                        ...   ...  \n",
       "3564542      Dronning Viktoria   9.0  \n",
       "3564543              The Queen   9.0  \n",
       "3564545              Frk. Lind   9.0  \n",
       "3564559       moren til Trygve  19.0  \n",
       "3564577                  Maria   2.0  \n",
       "\n",
       "[56004 rows x 6 columns]"
      ]
     },
     "execution_count": 136,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "condicion_50 = (df_elenco[\"year\"] >= 1950) & (df_elenco[\"year\"] <= 1959)\n",
    "decada50 = df_elenco[condicion_50]\n",
    "decada50_actress = decada50.loc[decada50[\"type\"] == \"actress\"]\n",
    "decada50_actress"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "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.11.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}