Slides-03.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {
    "editable": true,
    "slideshow": {
     "slide_type": "slide"
    },
    "tags": []
   },
   "source": [
    "# Seleccionando y consultando datos\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "source": [
    "Hay varias maneras de consultar los valores de un **df**. En general se agrupan en selección por **linea**, por **columna** o indicaciones para acceder una **celda**."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "source": [
    "Comenzamos cargando algunos datos como ejemplo:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "slideshow": {
     "slide_type": "fragment"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "16"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "tipos = {'Numero':'int', 'Expediente':'str', 'Nombre':'str', 'Apellido':'str',\n",
    "         'Plan':'str', 'Tarea1':'float', 'Examen1':'float', 'Tarea2':'float',\n",
    "         'Examen2':'float', 'Tarea3':'float', 'Examen3':'float'}\n",
    "\n",
    "df = pd.read_csv('ListaAlumnos.csv', index_col='Expediente', dtype=tipos)\n",
    "len(df)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "source": [
    "### Consultas por línea (observación)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "source": [
    "Es muy común, para poder verificar los datos, que queramos visualizar las primeras o últimas filas de un _dataframe_. El objeto _dataframe_ tiene los métodos `head()` y `tail()`. Estos _métodos_ por defecto regresan 5 registros, pero si pasamos un argumento `int` nos regresarán ese número de registros."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "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>Numero</th>\n",
       "      <th>Nombre</th>\n",
       "      <th>Apellido</th>\n",
       "      <th>Plan</th>\n",
       "      <th>Tarea1</th>\n",
       "      <th>Examen1</th>\n",
       "      <th>Tarea2</th>\n",
       "      <th>Examen2</th>\n",
       "      <th>Tarea3</th>\n",
       "      <th>Examen3</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Expediente</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></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>297613</th>\n",
       "      <td>1</td>\n",
       "      <td>Margarita</td>\n",
       "      <td>Duarte</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>75.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>261301</th>\n",
       "      <td>2</td>\n",
       "      <td>Manolo</td>\n",
       "      <td>Garcia</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>13.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>262979</th>\n",
       "      <td>3</td>\n",
       "      <td>Tomas</td>\n",
       "      <td>Gomez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>67.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223867</th>\n",
       "      <td>4</td>\n",
       "      <td>Susana</td>\n",
       "      <td>Gonzalez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>38.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>200389</th>\n",
       "      <td>5</td>\n",
       "      <td>Itzel</td>\n",
       "      <td>Hernandez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Numero     Nombre   Apellido     Plan  Tarea1  Examen1  Tarea2   \n",
       "Expediente                                                                   \n",
       "297613           1  Margarita     Duarte  LIM2014   100.0    100.0   100.0  \\\n",
       "261301           2     Manolo     Garcia  LIM2014   100.0     27.0   100.0   \n",
       "262979           3      Tomas      Gomez  LIM2014    67.0     57.0   100.0   \n",
       "223867           4     Susana   Gonzalez  LIM2014   100.0     60.0    33.0   \n",
       "200389           5      Itzel  Hernandez  LIM2014   100.0     75.0    67.0   \n",
       "\n",
       "            Examen2  Tarea3  Examen3  \n",
       "Expediente                            \n",
       "297613        100.0   100.0     75.0  \n",
       "261301         60.0    50.0     13.0  \n",
       "262979        100.0   100.0     50.0  \n",
       "223867        100.0   100.0     38.0  \n",
       "200389        100.0   100.0     50.0  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "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>Numero</th>\n",
       "      <th>Nombre</th>\n",
       "      <th>Apellido</th>\n",
       "      <th>Plan</th>\n",
       "      <th>Tarea1</th>\n",
       "      <th>Examen1</th>\n",
       "      <th>Tarea2</th>\n",
       "      <th>Examen2</th>\n",
       "      <th>Tarea3</th>\n",
       "      <th>Examen3</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Expediente</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></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>262959</th>\n",
       "      <td>10</td>\n",
       "      <td>Gustavo</td>\n",
       "      <td>Ramirez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>273339</th>\n",
       "      <td>11</td>\n",
       "      <td>Pedro</td>\n",
       "      <td>Romero</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>67.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>226660</th>\n",
       "      <td>12</td>\n",
       "      <td>Hector</td>\n",
       "      <td>Sanchez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>13.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>293143</th>\n",
       "      <td>13</td>\n",
       "      <td>Amanda</td>\n",
       "      <td>Sosa</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>33.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>254011</th>\n",
       "      <td>14</td>\n",
       "      <td>Miguel</td>\n",
       "      <td>Torres</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>67.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276772</th>\n",
       "      <td>15</td>\n",
       "      <td>Alberto</td>\n",
       "      <td>Vazquez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>252165</th>\n",
       "      <td>16</td>\n",
       "      <td>Carlos</td>\n",
       "      <td>Vera</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Numero   Nombre Apellido     Plan  Tarea1  Examen1  Tarea2   \n",
       "Expediente                                                               \n",
       "262959          10  Gustavo  Ramirez  LIM2014   100.0     87.0   100.0  \\\n",
       "273339          11    Pedro   Romero  LIM2014    67.0     67.0   100.0   \n",
       "226660          12   Hector  Sanchez  LIM2014   100.0     69.0   100.0   \n",
       "293143          13   Amanda     Sosa  LIM2014    33.0     69.0   100.0   \n",
       "254011          14   Miguel   Torres  LIM2014    67.0     72.0    67.0   \n",
       "276772          15  Alberto  Vazquez  LIM2014   100.0     69.0   100.0   \n",
       "252165          16   Carlos     Vera  LIM2014   100.0     84.0    67.0   \n",
       "\n",
       "            Examen2  Tarea3  Examen3  \n",
       "Expediente                            \n",
       "262959        100.0   100.0    100.0  \n",
       "273339        100.0    50.0     25.0  \n",
       "226660         95.0   100.0     13.0  \n",
       "293143         95.0   100.0     50.0  \n",
       "254011         90.0   100.0    100.0  \n",
       "276772        100.0   100.0      0.0  \n",
       "252165        100.0   100.0     25.0  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.tail(7)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "source": [
    "Para acceder a una **linea** de nuestro _dataframe_ usamos `iloc` (de localizar por número consecutivo):"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "slideshow": {
     "slide_type": "fragment"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Numero            2\n",
       "Nombre       Manolo\n",
       "Apellido     Garcia\n",
       "Plan        LIM2014\n",
       "Tarea1        100.0\n",
       "Examen1        27.0\n",
       "Tarea2        100.0\n",
       "Examen2        60.0\n",
       "Tarea3         50.0\n",
       "Examen3        13.0\n",
       "Name: 261301, dtype: object"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.iloc[1]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "slideshow": {
     "slide_type": "fragment"
    }
   },
   "source": [
    "Obsérvese que el resultado también es una serie, donde los índices son los nombres de las columnas"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "source": [
    "`iloc` permite diversos tipos de entrada entre los que se encuentran:\n",
    "\n",
    "* _Slices_:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "slideshow": {
     "slide_type": "fragment"
    }
   },
   "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>Numero</th>\n",
       "      <th>Nombre</th>\n",
       "      <th>Apellido</th>\n",
       "      <th>Plan</th>\n",
       "      <th>Tarea1</th>\n",
       "      <th>Examen1</th>\n",
       "      <th>Tarea2</th>\n",
       "      <th>Examen2</th>\n",
       "      <th>Tarea3</th>\n",
       "      <th>Examen3</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Expediente</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></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>200389</th>\n",
       "      <td>5</td>\n",
       "      <td>Itzel</td>\n",
       "      <td>Hernandez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>270819</th>\n",
       "      <td>6</td>\n",
       "      <td>David</td>\n",
       "      <td>Hernandez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203004</th>\n",
       "      <td>7</td>\n",
       "      <td>Francisco</td>\n",
       "      <td>Jimenez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>33.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Numero     Nombre   Apellido     Plan  Tarea1  Examen1  Tarea2   \n",
       "Expediente                                                                   \n",
       "200389           5      Itzel  Hernandez  LIM2014   100.0     75.0    67.0  \\\n",
       "270819           6      David  Hernandez  LIM2014   100.0     63.0   100.0   \n",
       "203004           7  Francisco    Jimenez  LIM2014    33.0     23.0   100.0   \n",
       "\n",
       "            Examen2  Tarea3  Examen3  \n",
       "Expediente                            \n",
       "200389        100.0   100.0     50.0  \n",
       "270819         95.0   100.0     50.0  \n",
       "203004         60.0    50.0      0.0  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.iloc[4:7]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "source": [
    "* Listas con los índices."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "slideshow": {
     "slide_type": "fragment"
    }
   },
   "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>Numero</th>\n",
       "      <th>Nombre</th>\n",
       "      <th>Apellido</th>\n",
       "      <th>Plan</th>\n",
       "      <th>Tarea1</th>\n",
       "      <th>Examen1</th>\n",
       "      <th>Tarea2</th>\n",
       "      <th>Examen2</th>\n",
       "      <th>Tarea3</th>\n",
       "      <th>Examen3</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Expediente</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></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>297613</th>\n",
       "      <td>1</td>\n",
       "      <td>Margarita</td>\n",
       "      <td>Duarte</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>75.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>262979</th>\n",
       "      <td>3</td>\n",
       "      <td>Tomas</td>\n",
       "      <td>Gomez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>67.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223867</th>\n",
       "      <td>4</td>\n",
       "      <td>Susana</td>\n",
       "      <td>Gonzalez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>38.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>262959</th>\n",
       "      <td>10</td>\n",
       "      <td>Gustavo</td>\n",
       "      <td>Ramirez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Numero     Nombre  Apellido     Plan  Tarea1  Examen1  Tarea2   \n",
       "Expediente                                                                  \n",
       "297613           1  Margarita    Duarte  LIM2014   100.0    100.0   100.0  \\\n",
       "262979           3      Tomas     Gomez  LIM2014    67.0     57.0   100.0   \n",
       "223867           4     Susana  Gonzalez  LIM2014   100.0     60.0    33.0   \n",
       "262959          10    Gustavo   Ramirez  LIM2014   100.0     87.0   100.0   \n",
       "\n",
       "            Examen2  Tarea3  Examen3  \n",
       "Expediente                            \n",
       "297613        100.0   100.0     75.0  \n",
       "262979        100.0   100.0     50.0  \n",
       "223867        100.0   100.0     38.0  \n",
       "262959        100.0   100.0    100.0  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.iloc[[0,2,3,9]]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "source": [
    "* Lista con valores binarios"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "slideshow": {
     "slide_type": "fragment"
    }
   },
   "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>Numero</th>\n",
       "      <th>Nombre</th>\n",
       "      <th>Apellido</th>\n",
       "      <th>Plan</th>\n",
       "      <th>Tarea1</th>\n",
       "      <th>Examen1</th>\n",
       "      <th>Tarea2</th>\n",
       "      <th>Examen2</th>\n",
       "      <th>Tarea3</th>\n",
       "      <th>Examen3</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Expediente</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></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>261301</th>\n",
       "      <td>2</td>\n",
       "      <td>Manolo</td>\n",
       "      <td>Garcia</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>13.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>262979</th>\n",
       "      <td>3</td>\n",
       "      <td>Tomas</td>\n",
       "      <td>Gomez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>67.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203004</th>\n",
       "      <td>7</td>\n",
       "      <td>Francisco</td>\n",
       "      <td>Jimenez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>33.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276809</th>\n",
       "      <td>9</td>\n",
       "      <td>Helena</td>\n",
       "      <td>Perez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>88.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>262959</th>\n",
       "      <td>10</td>\n",
       "      <td>Gustavo</td>\n",
       "      <td>Ramirez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Numero     Nombre Apellido     Plan  Tarea1  Examen1  Tarea2   \n",
       "Expediente                                                                 \n",
       "261301           2     Manolo   Garcia  LIM2014   100.0     27.0   100.0  \\\n",
       "262979           3      Tomas    Gomez  LIM2014    67.0     57.0   100.0   \n",
       "203004           7  Francisco  Jimenez  LIM2014    33.0     23.0   100.0   \n",
       "276809           9     Helena    Perez  LIM2014   100.0     95.0   100.0   \n",
       "262959          10    Gustavo  Ramirez  LIM2014   100.0     87.0   100.0   \n",
       "\n",
       "            Examen2  Tarea3  Examen3  \n",
       "Expediente                            \n",
       "261301         60.0    50.0     13.0  \n",
       "262979        100.0   100.0     50.0  \n",
       "203004         60.0    50.0      0.0  \n",
       "276809         90.0   100.0     88.0  \n",
       "262959        100.0   100.0    100.0  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.iloc[[False, True, True, False, False, False, True, False,\n",
    "         True, True, False, False, False, False, False, False]]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "source": [
    "* Funciones"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "slideshow": {
     "slide_type": "fragment"
    }
   },
   "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>Numero</th>\n",
       "      <th>Nombre</th>\n",
       "      <th>Apellido</th>\n",
       "      <th>Plan</th>\n",
       "      <th>Tarea1</th>\n",
       "      <th>Examen1</th>\n",
       "      <th>Tarea2</th>\n",
       "      <th>Examen2</th>\n",
       "      <th>Tarea3</th>\n",
       "      <th>Examen3</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Expediente</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></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>297613</th>\n",
       "      <td>1</td>\n",
       "      <td>Margarita</td>\n",
       "      <td>Duarte</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>75.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276809</th>\n",
       "      <td>9</td>\n",
       "      <td>Helena</td>\n",
       "      <td>Perez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>88.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Numero     Nombre Apellido     Plan  Tarea1  Examen1  Tarea2   \n",
       "Expediente                                                                 \n",
       "297613           1  Margarita   Duarte  LIM2014   100.0    100.0   100.0  \\\n",
       "276809           9     Helena    Perez  LIM2014   100.0     95.0   100.0   \n",
       "\n",
       "            Examen2  Tarea3  Examen3  \n",
       "Expediente                            \n",
       "297613        100.0   100.0     75.0  \n",
       "276809         90.0   100.0     88.0  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.iloc[lambda x: x.Examen1.array >= 90.0]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "slideshow": {
     "slide_type": "fragment"
    }
   },
   "source": [
    " (__Nota__: esta no es la manera más común de hacer este tipo de filtro)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "source": [
    "### Filtrado de __lineas__ según ciertas características.\n",
    "\n",
    "La manera más común de hacer una selección de las lineas según sus características es usando `[]`, donde en el interior se coloca(n) la(s) condición(es) correspondientes:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "slideshow": {
     "slide_type": "fragment"
    }
   },
   "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>Numero</th>\n",
       "      <th>Nombre</th>\n",
       "      <th>Apellido</th>\n",
       "      <th>Plan</th>\n",
       "      <th>Tarea1</th>\n",
       "      <th>Examen1</th>\n",
       "      <th>Tarea2</th>\n",
       "      <th>Examen2</th>\n",
       "      <th>Tarea3</th>\n",
       "      <th>Examen3</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Expediente</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></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>297613</th>\n",
       "      <td>1</td>\n",
       "      <td>Margarita</td>\n",
       "      <td>Duarte</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>75.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276809</th>\n",
       "      <td>9</td>\n",
       "      <td>Helena</td>\n",
       "      <td>Perez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>88.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Numero     Nombre Apellido     Plan  Tarea1  Examen1  Tarea2   \n",
       "Expediente                                                                 \n",
       "297613           1  Margarita   Duarte  LIM2014   100.0    100.0   100.0  \\\n",
       "276809           9     Helena    Perez  LIM2014   100.0     95.0   100.0   \n",
       "\n",
       "            Examen2  Tarea3  Examen3  \n",
       "Expediente                            \n",
       "297613        100.0   100.0     75.0  \n",
       "276809         90.0   100.0     88.0  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df.Examen1 >= 90.0]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "source": [
    "Para incluir varias condiciones cada una se debe de colocar dentro de un paréntesis `()`, utilizando los operadores lógicos `&` y `|`:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "slideshow": {
     "slide_type": "fragment"
    }
   },
   "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>Numero</th>\n",
       "      <th>Nombre</th>\n",
       "      <th>Apellido</th>\n",
       "      <th>Plan</th>\n",
       "      <th>Tarea1</th>\n",
       "      <th>Examen1</th>\n",
       "      <th>Tarea2</th>\n",
       "      <th>Examen2</th>\n",
       "      <th>Tarea3</th>\n",
       "      <th>Examen3</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Expediente</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></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>262979</th>\n",
       "      <td>3</td>\n",
       "      <td>Tomas</td>\n",
       "      <td>Gomez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>67.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223867</th>\n",
       "      <td>4</td>\n",
       "      <td>Susana</td>\n",
       "      <td>Gonzalez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>38.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>270819</th>\n",
       "      <td>6</td>\n",
       "      <td>David</td>\n",
       "      <td>Hernandez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>273339</th>\n",
       "      <td>11</td>\n",
       "      <td>Pedro</td>\n",
       "      <td>Romero</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>67.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>226660</th>\n",
       "      <td>12</td>\n",
       "      <td>Hector</td>\n",
       "      <td>Sanchez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>13.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>293143</th>\n",
       "      <td>13</td>\n",
       "      <td>Amanda</td>\n",
       "      <td>Sosa</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>33.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276772</th>\n",
       "      <td>15</td>\n",
       "      <td>Alberto</td>\n",
       "      <td>Vazquez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Numero   Nombre   Apellido     Plan  Tarea1  Examen1  Tarea2   \n",
       "Expediente                                                                 \n",
       "262979           3    Tomas      Gomez  LIM2014    67.0     57.0   100.0  \\\n",
       "223867           4   Susana   Gonzalez  LIM2014   100.0     60.0    33.0   \n",
       "270819           6    David  Hernandez  LIM2014   100.0     63.0   100.0   \n",
       "273339          11    Pedro     Romero  LIM2014    67.0     67.0   100.0   \n",
       "226660          12   Hector    Sanchez  LIM2014   100.0     69.0   100.0   \n",
       "293143          13   Amanda       Sosa  LIM2014    33.0     69.0   100.0   \n",
       "276772          15  Alberto    Vazquez  LIM2014   100.0     69.0   100.0   \n",
       "\n",
       "            Examen2  Tarea3  Examen3  \n",
       "Expediente                            \n",
       "262979        100.0   100.0     50.0  \n",
       "223867        100.0   100.0     38.0  \n",
       "270819         95.0   100.0     50.0  \n",
       "273339        100.0    50.0     25.0  \n",
       "226660         95.0   100.0     13.0  \n",
       "293143         95.0   100.0     50.0  \n",
       "276772        100.0   100.0      0.0  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[(df.Examen1 <= 70.0) & (df.Examen2 >= 90.0)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "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>Numero</th>\n",
       "      <th>Nombre</th>\n",
       "      <th>Apellido</th>\n",
       "      <th>Plan</th>\n",
       "      <th>Tarea1</th>\n",
       "      <th>Examen1</th>\n",
       "      <th>Tarea2</th>\n",
       "      <th>Examen2</th>\n",
       "      <th>Tarea3</th>\n",
       "      <th>Examen3</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Expediente</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></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>261301</th>\n",
       "      <td>2</td>\n",
       "      <td>Manolo</td>\n",
       "      <td>Garcia</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>13.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>262979</th>\n",
       "      <td>3</td>\n",
       "      <td>Tomas</td>\n",
       "      <td>Gomez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>67.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223867</th>\n",
       "      <td>4</td>\n",
       "      <td>Susana</td>\n",
       "      <td>Gonzalez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>38.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>200389</th>\n",
       "      <td>5</td>\n",
       "      <td>Itzel</td>\n",
       "      <td>Hernandez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>270819</th>\n",
       "      <td>6</td>\n",
       "      <td>David</td>\n",
       "      <td>Hernandez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203004</th>\n",
       "      <td>7</td>\n",
       "      <td>Francisco</td>\n",
       "      <td>Jimenez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>33.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>273339</th>\n",
       "      <td>11</td>\n",
       "      <td>Pedro</td>\n",
       "      <td>Romero</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>67.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>226660</th>\n",
       "      <td>12</td>\n",
       "      <td>Hector</td>\n",
       "      <td>Sanchez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>13.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>293143</th>\n",
       "      <td>13</td>\n",
       "      <td>Amanda</td>\n",
       "      <td>Sosa</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>33.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276772</th>\n",
       "      <td>15</td>\n",
       "      <td>Alberto</td>\n",
       "      <td>Vazquez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>252165</th>\n",
       "      <td>16</td>\n",
       "      <td>Carlos</td>\n",
       "      <td>Vera</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Numero     Nombre   Apellido     Plan  Tarea1  Examen1  Tarea2   \n",
       "Expediente                                                                   \n",
       "261301           2     Manolo     Garcia  LIM2014   100.0     27.0   100.0  \\\n",
       "262979           3      Tomas      Gomez  LIM2014    67.0     57.0   100.0   \n",
       "223867           4     Susana   Gonzalez  LIM2014   100.0     60.0    33.0   \n",
       "200389           5      Itzel  Hernandez  LIM2014   100.0     75.0    67.0   \n",
       "270819           6      David  Hernandez  LIM2014   100.0     63.0   100.0   \n",
       "203004           7  Francisco    Jimenez  LIM2014    33.0     23.0   100.0   \n",
       "273339          11      Pedro     Romero  LIM2014    67.0     67.0   100.0   \n",
       "226660          12     Hector    Sanchez  LIM2014   100.0     69.0   100.0   \n",
       "293143          13     Amanda       Sosa  LIM2014    33.0     69.0   100.0   \n",
       "276772          15    Alberto    Vazquez  LIM2014   100.0     69.0   100.0   \n",
       "252165          16     Carlos       Vera  LIM2014   100.0     84.0    67.0   \n",
       "\n",
       "            Examen2  Tarea3  Examen3  \n",
       "Expediente                            \n",
       "261301         60.0    50.0     13.0  \n",
       "262979        100.0   100.0     50.0  \n",
       "223867        100.0   100.0     38.0  \n",
       "200389        100.0   100.0     50.0  \n",
       "270819         95.0   100.0     50.0  \n",
       "203004         60.0    50.0      0.0  \n",
       "273339        100.0    50.0     25.0  \n",
       "226660         95.0   100.0     13.0  \n",
       "293143         95.0   100.0     50.0  \n",
       "276772        100.0   100.0      0.0  \n",
       "252165        100.0   100.0     25.0  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[(df.Examen1 < 60.0) | (df.Examen2 < 60) | (df.Examen3 < 60)]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "source": [
    "### Muestreo aleatorio:\n",
    "\n",
    "Pandas nos permite hacer un muestreo aleatorio, ya sea diciendo el número (`n=`) o la fracción (`frac=`):"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "slideshow": {
     "slide_type": "fragment"
    }
   },
   "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>Numero</th>\n",
       "      <th>Nombre</th>\n",
       "      <th>Apellido</th>\n",
       "      <th>Plan</th>\n",
       "      <th>Tarea1</th>\n",
       "      <th>Examen1</th>\n",
       "      <th>Tarea2</th>\n",
       "      <th>Examen2</th>\n",
       "      <th>Tarea3</th>\n",
       "      <th>Examen3</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Expediente</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></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>276809</th>\n",
       "      <td>9</td>\n",
       "      <td>Helena</td>\n",
       "      <td>Perez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>88.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>200389</th>\n",
       "      <td>5</td>\n",
       "      <td>Itzel</td>\n",
       "      <td>Hernandez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>293143</th>\n",
       "      <td>13</td>\n",
       "      <td>Amanda</td>\n",
       "      <td>Sosa</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>33.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Numero  Nombre   Apellido     Plan  Tarea1  Examen1  Tarea2   \n",
       "Expediente                                                                \n",
       "276809           9  Helena      Perez  LIM2014   100.0     95.0   100.0  \\\n",
       "200389           5   Itzel  Hernandez  LIM2014   100.0     75.0    67.0   \n",
       "293143          13  Amanda       Sosa  LIM2014    33.0     69.0   100.0   \n",
       "\n",
       "            Examen2  Tarea3  Examen3  \n",
       "Expediente                            \n",
       "276809         90.0   100.0     88.0  \n",
       "200389        100.0   100.0     50.0  \n",
       "293143         95.0   100.0     50.0  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.sample(n=3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "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>Numero</th>\n",
       "      <th>Nombre</th>\n",
       "      <th>Apellido</th>\n",
       "      <th>Plan</th>\n",
       "      <th>Tarea1</th>\n",
       "      <th>Examen1</th>\n",
       "      <th>Tarea2</th>\n",
       "      <th>Examen2</th>\n",
       "      <th>Tarea3</th>\n",
       "      <th>Examen3</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Expediente</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></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>273339</th>\n",
       "      <td>11</td>\n",
       "      <td>Pedro</td>\n",
       "      <td>Romero</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>67.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>297471</th>\n",
       "      <td>8</td>\n",
       "      <td>Juan</td>\n",
       "      <td>Nuñez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>67.0</td>\n",
       "      <td>77.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>97.5</td>\n",
       "      <td>100.0</td>\n",
       "      <td>75.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>226660</th>\n",
       "      <td>12</td>\n",
       "      <td>Hector</td>\n",
       "      <td>Sanchez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>13.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>262979</th>\n",
       "      <td>3</td>\n",
       "      <td>Tomas</td>\n",
       "      <td>Gomez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>67.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Numero  Nombre Apellido     Plan  Tarea1  Examen1  Tarea2   \n",
       "Expediente                                                              \n",
       "273339          11   Pedro   Romero  LIM2014    67.0     67.0   100.0  \\\n",
       "297471           8    Juan    Nuñez  LIM2014    67.0     77.0    67.0   \n",
       "226660          12  Hector  Sanchez  LIM2014   100.0     69.0   100.0   \n",
       "262979           3   Tomas    Gomez  LIM2014    67.0     57.0   100.0   \n",
       "\n",
       "            Examen2  Tarea3  Examen3  \n",
       "Expediente                            \n",
       "273339        100.0    50.0     25.0  \n",
       "297471         97.5   100.0     75.0  \n",
       "226660         95.0   100.0     13.0  \n",
       "262979        100.0   100.0     50.0  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.sample(frac=0.25) # 25%"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "source": [
    "### Mayores y menores\n",
    "\n",
    "También es posible revisar las líneas con los __mayores__ o __menores__ valores en una columna con `nlargest()` y `nsmallest()`:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "slideshow": {
     "slide_type": "fragment"
    }
   },
   "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>Numero</th>\n",
       "      <th>Nombre</th>\n",
       "      <th>Apellido</th>\n",
       "      <th>Plan</th>\n",
       "      <th>Tarea1</th>\n",
       "      <th>Examen1</th>\n",
       "      <th>Tarea2</th>\n",
       "      <th>Examen2</th>\n",
       "      <th>Tarea3</th>\n",
       "      <th>Examen3</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Expediente</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></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>297613</th>\n",
       "      <td>1</td>\n",
       "      <td>Margarita</td>\n",
       "      <td>Duarte</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>75.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276809</th>\n",
       "      <td>9</td>\n",
       "      <td>Helena</td>\n",
       "      <td>Perez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>88.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>262959</th>\n",
       "      <td>10</td>\n",
       "      <td>Gustavo</td>\n",
       "      <td>Ramirez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>252165</th>\n",
       "      <td>16</td>\n",
       "      <td>Carlos</td>\n",
       "      <td>Vera</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>297471</th>\n",
       "      <td>8</td>\n",
       "      <td>Juan</td>\n",
       "      <td>Nuñez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>67.0</td>\n",
       "      <td>77.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>97.5</td>\n",
       "      <td>100.0</td>\n",
       "      <td>75.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Numero     Nombre Apellido     Plan  Tarea1  Examen1  Tarea2   \n",
       "Expediente                                                                 \n",
       "297613           1  Margarita   Duarte  LIM2014   100.0    100.0   100.0  \\\n",
       "276809           9     Helena    Perez  LIM2014   100.0     95.0   100.0   \n",
       "262959          10    Gustavo  Ramirez  LIM2014   100.0     87.0   100.0   \n",
       "252165          16     Carlos     Vera  LIM2014   100.0     84.0    67.0   \n",
       "297471           8       Juan    Nuñez  LIM2014    67.0     77.0    67.0   \n",
       "\n",
       "            Examen2  Tarea3  Examen3  \n",
       "Expediente                            \n",
       "297613        100.0   100.0     75.0  \n",
       "276809         90.0   100.0     88.0  \n",
       "262959        100.0   100.0    100.0  \n",
       "252165        100.0   100.0     25.0  \n",
       "297471         97.5   100.0     75.0  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.nlargest(5, 'Examen1')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "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>Numero</th>\n",
       "      <th>Nombre</th>\n",
       "      <th>Apellido</th>\n",
       "      <th>Plan</th>\n",
       "      <th>Tarea1</th>\n",
       "      <th>Examen1</th>\n",
       "      <th>Tarea2</th>\n",
       "      <th>Examen2</th>\n",
       "      <th>Tarea3</th>\n",
       "      <th>Examen3</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Expediente</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></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>203004</th>\n",
       "      <td>7</td>\n",
       "      <td>Francisco</td>\n",
       "      <td>Jimenez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>33.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>293143</th>\n",
       "      <td>13</td>\n",
       "      <td>Amanda</td>\n",
       "      <td>Sosa</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>33.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>262979</th>\n",
       "      <td>3</td>\n",
       "      <td>Tomas</td>\n",
       "      <td>Gomez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>67.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Numero     Nombre Apellido     Plan  Tarea1  Examen1  Tarea2   \n",
       "Expediente                                                                 \n",
       "203004           7  Francisco  Jimenez  LIM2014    33.0     23.0   100.0  \\\n",
       "293143          13     Amanda     Sosa  LIM2014    33.0     69.0   100.0   \n",
       "262979           3      Tomas    Gomez  LIM2014    67.0     57.0   100.0   \n",
       "\n",
       "            Examen2  Tarea3  Examen3  \n",
       "Expediente                            \n",
       "203004         60.0    50.0      0.0  \n",
       "293143         95.0   100.0     50.0  \n",
       "262979        100.0   100.0     50.0  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.nsmallest(3, 'Tarea1')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "source": [
    "### Cálculos estadísticos\n",
    "\n",
    "El objeto _dataframe_ incluye el cálculo automático de los descriptores estadísticos, usando `describe()`"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "slideshow": {
     "slide_type": "fragment"
    }
   },
   "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>Numero</th>\n",
       "      <th>Tarea1</th>\n",
       "      <th>Examen1</th>\n",
       "      <th>Tarea2</th>\n",
       "      <th>Examen2</th>\n",
       "      <th>Tarea3</th>\n",
       "      <th>Examen3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>16.000000</td>\n",
       "      <td>16.000000</td>\n",
       "      <td>16.000000</td>\n",
       "      <td>16.000000</td>\n",
       "      <td>16.000000</td>\n",
       "      <td>16.000000</td>\n",
       "      <td>16.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>8.500000</td>\n",
       "      <td>83.375000</td>\n",
       "      <td>68.375000</td>\n",
       "      <td>87.562500</td>\n",
       "      <td>92.656250</td>\n",
       "      <td>90.625000</td>\n",
       "      <td>47.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>4.760952</td>\n",
       "      <td>24.374509</td>\n",
       "      <td>20.710303</td>\n",
       "      <td>20.607341</td>\n",
       "      <td>13.212013</td>\n",
       "      <td>20.155644</td>\n",
       "      <td>33.348663</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>33.000000</td>\n",
       "      <td>23.000000</td>\n",
       "      <td>33.000000</td>\n",
       "      <td>60.000000</td>\n",
       "      <td>50.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>4.750000</td>\n",
       "      <td>67.000000</td>\n",
       "      <td>62.250000</td>\n",
       "      <td>67.000000</td>\n",
       "      <td>93.750000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>22.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>8.500000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>69.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>98.750000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>50.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>12.250000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>78.750000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>75.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>16.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Numero      Tarea1     Examen1      Tarea2     Examen2      Tarea3   \n",
       "count  16.000000   16.000000   16.000000   16.000000   16.000000   16.000000  \\\n",
       "mean    8.500000   83.375000   68.375000   87.562500   92.656250   90.625000   \n",
       "std     4.760952   24.374509   20.710303   20.607341   13.212013   20.155644   \n",
       "min     1.000000   33.000000   23.000000   33.000000   60.000000   50.000000   \n",
       "25%     4.750000   67.000000   62.250000   67.000000   93.750000  100.000000   \n",
       "50%     8.500000  100.000000   69.000000  100.000000   98.750000  100.000000   \n",
       "75%    12.250000  100.000000   78.750000  100.000000  100.000000  100.000000   \n",
       "max    16.000000  100.000000  100.000000  100.000000  100.000000  100.000000   \n",
       "\n",
       "          Examen3  \n",
       "count   16.000000  \n",
       "mean    47.000000  \n",
       "std     33.348663  \n",
       "min      0.000000  \n",
       "25%     22.000000  \n",
       "50%     50.000000  \n",
       "75%     75.000000  \n",
       "max    100.000000  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.describe()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "source": [
    "También hace, usando `corr()`, un cálculo de la correlación de las variables numéricas:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "slideshow": {
     "slide_type": "fragment"
    }
   },
   "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>Numero</th>\n",
       "      <th>Tarea1</th>\n",
       "      <th>Examen1</th>\n",
       "      <th>Tarea2</th>\n",
       "      <th>Examen2</th>\n",
       "      <th>Tarea3</th>\n",
       "      <th>Examen3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Numero</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>-0.153388</td>\n",
       "      <td>0.250167</td>\n",
       "      <td>0.003058</td>\n",
       "      <td>0.247741</td>\n",
       "      <td>0.191052</td>\n",
       "      <td>-0.069702</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tarea1</th>\n",
       "      <td>-0.153388</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.398142</td>\n",
       "      <td>-0.150028</td>\n",
       "      <td>0.305154</td>\n",
       "      <td>0.340095</td>\n",
       "      <td>0.073978</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Examen1</th>\n",
       "      <td>0.250167</td>\n",
       "      <td>0.398142</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>-0.090190</td>\n",
       "      <td>0.771510</td>\n",
       "      <td>0.703712</td>\n",
       "      <td>0.639001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tarea2</th>\n",
       "      <td>0.003058</td>\n",
       "      <td>-0.150028</td>\n",
       "      <td>-0.090190</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>-0.256835</td>\n",
       "      <td>-0.299443</td>\n",
       "      <td>-0.139983</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Examen2</th>\n",
       "      <td>0.247741</td>\n",
       "      <td>0.305154</td>\n",
       "      <td>0.771510</td>\n",
       "      <td>-0.256835</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.725616</td>\n",
       "      <td>0.358599</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tarea3</th>\n",
       "      <td>0.191052</td>\n",
       "      <td>0.340095</td>\n",
       "      <td>0.703712</td>\n",
       "      <td>-0.299443</td>\n",
       "      <td>0.725616</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.510788</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Examen3</th>\n",
       "      <td>-0.069702</td>\n",
       "      <td>0.073978</td>\n",
       "      <td>0.639001</td>\n",
       "      <td>-0.139983</td>\n",
       "      <td>0.358599</td>\n",
       "      <td>0.510788</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           Numero    Tarea1   Examen1    Tarea2   Examen2    Tarea3   Examen3\n",
       "Numero   1.000000 -0.153388  0.250167  0.003058  0.247741  0.191052 -0.069702\n",
       "Tarea1  -0.153388  1.000000  0.398142 -0.150028  0.305154  0.340095  0.073978\n",
       "Examen1  0.250167  0.398142  1.000000 -0.090190  0.771510  0.703712  0.639001\n",
       "Tarea2   0.003058 -0.150028 -0.090190  1.000000 -0.256835 -0.299443 -0.139983\n",
       "Examen2  0.247741  0.305154  0.771510 -0.256835  1.000000  0.725616  0.358599\n",
       "Tarea3   0.191052  0.340095  0.703712 -0.299443  0.725616  1.000000  0.510788\n",
       "Examen3 -0.069702  0.073978  0.639001 -0.139983  0.358599  0.510788  1.000000"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.corr(numeric_only=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "source": [
    "### Selección por Columna"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "source": [
    "Para hacer una selección por __columna__ se puede usar el modo simplificado:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "slideshow": {
     "slide_type": "fragment"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Expediente\n",
       "297613     75.0\n",
       "261301     13.0\n",
       "262979     50.0\n",
       "223867     38.0\n",
       "200389     50.0\n",
       "270819     50.0\n",
       "203004      0.0\n",
       "297471     75.0\n",
       "276809     88.0\n",
       "262959    100.0\n",
       "273339     25.0\n",
       "226660     13.0\n",
       "293143     50.0\n",
       "254011    100.0\n",
       "276772      0.0\n",
       "252165     25.0\n",
       "Name: Examen3, dtype: float64"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.Examen3"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "source": [
    "Este modo está limitado a la selección de __una sola columna__ y para columnas que __no tienen espacios en sus nombres__. Para los otros casos podemos usar la notación de `[]` utilizada en Python para acceder un elemento:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "slideshow": {
     "slide_type": "fragment"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Expediente\n",
       "297613     75.0\n",
       "261301     13.0\n",
       "262979     50.0\n",
       "223867     38.0\n",
       "200389     50.0\n",
       "270819     50.0\n",
       "203004      0.0\n",
       "297471     75.0\n",
       "276809     88.0\n",
       "262959    100.0\n",
       "273339     25.0\n",
       "226660     13.0\n",
       "293143     50.0\n",
       "254011    100.0\n",
       "276772      0.0\n",
       "252165     25.0\n",
       "Name: Examen3, dtype: float64"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Examen3']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "source": [
    "Para extraer **más de una columna** (como _dataframe_) utilizamos la notación con doble `[[]]`. De esta forma los nombres de las columnas son pasados como una lista a nuestro _dataframe_"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {
    "slideshow": {
     "slide_type": "fragment"
    }
   },
   "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>Tarea1</th>\n",
       "      <th>Tarea2</th>\n",
       "      <th>Tarea3</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Expediente</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>297613</th>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>261301</th>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>262979</th>\n",
       "      <td>67.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223867</th>\n",
       "      <td>100.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>200389</th>\n",
       "      <td>100.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>270819</th>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203004</th>\n",
       "      <td>33.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>297471</th>\n",
       "      <td>67.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276809</th>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>262959</th>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>273339</th>\n",
       "      <td>67.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>226660</th>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>293143</th>\n",
       "      <td>33.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>254011</th>\n",
       "      <td>67.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276772</th>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>252165</th>\n",
       "      <td>100.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Tarea1  Tarea2  Tarea3\n",
       "Expediente                        \n",
       "297613       100.0   100.0   100.0\n",
       "261301       100.0   100.0    50.0\n",
       "262979        67.0   100.0   100.0\n",
       "223867       100.0    33.0   100.0\n",
       "200389       100.0    67.0   100.0\n",
       "270819       100.0   100.0   100.0\n",
       "203004        33.0   100.0    50.0\n",
       "297471        67.0    67.0   100.0\n",
       "276809       100.0   100.0   100.0\n",
       "262959       100.0   100.0   100.0\n",
       "273339        67.0   100.0    50.0\n",
       "226660       100.0   100.0   100.0\n",
       "293143        33.0   100.0   100.0\n",
       "254011        67.0    67.0   100.0\n",
       "276772       100.0   100.0   100.0\n",
       "252165       100.0    67.0   100.0"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[['Tarea1','Tarea2', 'Tarea3']]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "source": [
    "### Acceso de datos puntuales\n",
    "\n",
    "__Pandas__ nos permite acceder (leer y modificar) un dato puntual usando:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {
    "slideshow": {
     "slide_type": "fragment"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "23.0"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc['203004','Examen1']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "outputs": [],
   "source": [
    "df.loc['203004','Examen1'] = 35"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {
    "slideshow": {
     "slide_type": "fragment"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "35.0"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc['203004','Examen1']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "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>Numero</th>\n",
       "      <th>Nombre</th>\n",
       "      <th>Apellido</th>\n",
       "      <th>Plan</th>\n",
       "      <th>Tarea1</th>\n",
       "      <th>Examen1</th>\n",
       "      <th>Tarea2</th>\n",
       "      <th>Examen2</th>\n",
       "      <th>Tarea3</th>\n",
       "      <th>Examen3</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Expediente</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></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>297613</th>\n",
       "      <td>1</td>\n",
       "      <td>Margarita</td>\n",
       "      <td>Duarte</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>75.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>261301</th>\n",
       "      <td>2</td>\n",
       "      <td>Manolo</td>\n",
       "      <td>Garcia</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>13.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>262979</th>\n",
       "      <td>3</td>\n",
       "      <td>Tomas</td>\n",
       "      <td>Gomez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>67.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223867</th>\n",
       "      <td>4</td>\n",
       "      <td>Susana</td>\n",
       "      <td>Gonzalez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>38.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>200389</th>\n",
       "      <td>5</td>\n",
       "      <td>Itzel</td>\n",
       "      <td>Hernandez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>270819</th>\n",
       "      <td>6</td>\n",
       "      <td>David</td>\n",
       "      <td>Hernandez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203004</th>\n",
       "      <td>7</td>\n",
       "      <td>Francisco</td>\n",
       "      <td>Jimenez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>33.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>297471</th>\n",
       "      <td>8</td>\n",
       "      <td>Juan</td>\n",
       "      <td>Nuñez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>67.0</td>\n",
       "      <td>77.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>97.5</td>\n",
       "      <td>100.0</td>\n",
       "      <td>75.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276809</th>\n",
       "      <td>9</td>\n",
       "      <td>Helena</td>\n",
       "      <td>Perez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>88.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>262959</th>\n",
       "      <td>10</td>\n",
       "      <td>Gustavo</td>\n",
       "      <td>Ramirez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>273339</th>\n",
       "      <td>11</td>\n",
       "      <td>Pedro</td>\n",
       "      <td>Romero</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>67.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>226660</th>\n",
       "      <td>12</td>\n",
       "      <td>Hector</td>\n",
       "      <td>Sanchez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>13.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>293143</th>\n",
       "      <td>13</td>\n",
       "      <td>Amanda</td>\n",
       "      <td>Sosa</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>33.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>254011</th>\n",
       "      <td>14</td>\n",
       "      <td>Miguel</td>\n",
       "      <td>Torres</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>67.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276772</th>\n",
       "      <td>15</td>\n",
       "      <td>Alberto</td>\n",
       "      <td>Vazquez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>252165</th>\n",
       "      <td>16</td>\n",
       "      <td>Carlos</td>\n",
       "      <td>Vera</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Numero     Nombre   Apellido     Plan  Tarea1  Examen1  Tarea2   \n",
       "Expediente                                                                   \n",
       "297613           1  Margarita     Duarte  LIM2014   100.0    100.0   100.0  \\\n",
       "261301           2     Manolo     Garcia  LIM2014   100.0     27.0   100.0   \n",
       "262979           3      Tomas      Gomez  LIM2014    67.0     57.0   100.0   \n",
       "223867           4     Susana   Gonzalez  LIM2014   100.0     60.0    33.0   \n",
       "200389           5      Itzel  Hernandez  LIM2014   100.0     75.0    67.0   \n",
       "270819           6      David  Hernandez  LIM2014   100.0     63.0   100.0   \n",
       "203004           7  Francisco    Jimenez  LIM2014    33.0     35.0   100.0   \n",
       "297471           8       Juan      Nuñez  LIM2014    67.0     77.0    67.0   \n",
       "276809           9     Helena      Perez  LIM2014   100.0     95.0   100.0   \n",
       "262959          10    Gustavo    Ramirez  LIM2014   100.0     87.0   100.0   \n",
       "273339          11      Pedro     Romero  LIM2014    67.0     67.0   100.0   \n",
       "226660          12     Hector    Sanchez  LIM2014   100.0     69.0   100.0   \n",
       "293143          13     Amanda       Sosa  LIM2014    33.0     69.0   100.0   \n",
       "254011          14     Miguel     Torres  LIM2014    67.0     72.0    67.0   \n",
       "276772          15    Alberto    Vazquez  LIM2014   100.0     69.0   100.0   \n",
       "252165          16     Carlos       Vera  LIM2014   100.0     84.0    67.0   \n",
       "\n",
       "            Examen2  Tarea3  Examen3  \n",
       "Expediente                            \n",
       "297613        100.0   100.0     75.0  \n",
       "261301         60.0    50.0     13.0  \n",
       "262979        100.0   100.0     50.0  \n",
       "223867        100.0   100.0     38.0  \n",
       "200389        100.0   100.0     50.0  \n",
       "270819         95.0   100.0     50.0  \n",
       "203004         60.0    50.0      0.0  \n",
       "297471         97.5   100.0     75.0  \n",
       "276809         90.0   100.0     88.0  \n",
       "262959        100.0   100.0    100.0  \n",
       "273339        100.0    50.0     25.0  \n",
       "226660         95.0   100.0     13.0  \n",
       "293143         95.0   100.0     50.0  \n",
       "254011         90.0   100.0    100.0  \n",
       "276772        100.0   100.0      0.0  \n",
       "252165        100.0   100.0     25.0  "
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  }
 ],
 "metadata": {
  "celltoolbar": "Slideshow",
  "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.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}