Slides-02.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {
    "editable": true,
    "slideshow": {
     "slide_type": "slide"
    },
    "tags": []
   },
   "source": [
    "# Importando datos con __Pandas__"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "source": [
    "La librería __Pandas__ nos permite importar con mucha facilidad diferentes formatos:\n",
    "\n",
    "|Format Type |\tData  Description |\tReader | Writer |\n",
    "|---|---|---|---|\n",
    "|text | CSV | read_csv | to_csv |\n",
    "|text |JSON |read_json |to_json|\n",
    "|text |HTML |read_html |to_html|\n",
    "|text |Local clipboard |read_clipboard |to_clipboard|\n",
    "|binary |MS Excel |read_excel |to_excel|\n",
    "|binary |HDF5 Format |read_hdf |to_hdf|\n",
    "|binary |Feather Format |read_feather |to_feather|\n",
    "|binary |Msgpack |read_msgpack |to_msgpack|\n",
    "|binary |Stata |read_stata |to_stata|\n",
    "|binary |SAS |read_sas | | \n",
    "|binary |Python Pickle Format |read_pickle |to_pickle|\n",
    "|SQL |SQL |read_sql |to_sql|\n",
    "|SQL |Google Big Query |read_gbq |to_gbq|\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "source": [
    "Para desarrollar algunos ejemplos descargaremos algunos datos:\n",
    "\n",
    "https://github.com/ochoadavid/Pandas-Salta22/raw/main/ListaAlumnos.csv"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "source": [
    "Empezamos importando la librería:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "slideshow": {
     "slide_type": "fragment"
    }
   },
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "source": [
    "Y cargamos los datos:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>Expediente</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",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>297613</td>\n",
       "      <td>Margarita</td>\n",
       "      <td>Duarte</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100</td>\n",
       "      <td>75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>261301</td>\n",
       "      <td>Manolo</td>\n",
       "      <td>Garcia</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100</td>\n",
       "      <td>27</td>\n",
       "      <td>100</td>\n",
       "      <td>60.0</td>\n",
       "      <td>50</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>262979</td>\n",
       "      <td>Tomas</td>\n",
       "      <td>Gomez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>67</td>\n",
       "      <td>57</td>\n",
       "      <td>100</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>223867</td>\n",
       "      <td>Susana</td>\n",
       "      <td>Gonzalez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100</td>\n",
       "      <td>60</td>\n",
       "      <td>33</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>200389</td>\n",
       "      <td>Itzel</td>\n",
       "      <td>Hernandez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100</td>\n",
       "      <td>75</td>\n",
       "      <td>67</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>270819</td>\n",
       "      <td>David</td>\n",
       "      <td>Hernandez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100</td>\n",
       "      <td>63</td>\n",
       "      <td>100</td>\n",
       "      <td>95.0</td>\n",
       "      <td>100</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>203004</td>\n",
       "      <td>Francisco</td>\n",
       "      <td>Jimenez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>33</td>\n",
       "      <td>23</td>\n",
       "      <td>100</td>\n",
       "      <td>60.0</td>\n",
       "      <td>50</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>297471</td>\n",
       "      <td>Juan</td>\n",
       "      <td>Nuñez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>67</td>\n",
       "      <td>77</td>\n",
       "      <td>67</td>\n",
       "      <td>97.5</td>\n",
       "      <td>100</td>\n",
       "      <td>75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>276809</td>\n",
       "      <td>Helena</td>\n",
       "      <td>Perez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100</td>\n",
       "      <td>95</td>\n",
       "      <td>100</td>\n",
       "      <td>90.0</td>\n",
       "      <td>100</td>\n",
       "      <td>88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>262959</td>\n",
       "      <td>Gustavo</td>\n",
       "      <td>Ramirez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100</td>\n",
       "      <td>87</td>\n",
       "      <td>100</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>273339</td>\n",
       "      <td>Pedro</td>\n",
       "      <td>Romero</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>67</td>\n",
       "      <td>67</td>\n",
       "      <td>100</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>226660</td>\n",
       "      <td>Hector</td>\n",
       "      <td>Sanchez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100</td>\n",
       "      <td>69</td>\n",
       "      <td>100</td>\n",
       "      <td>95.0</td>\n",
       "      <td>100</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>293143</td>\n",
       "      <td>Amanda</td>\n",
       "      <td>Sosa</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>33</td>\n",
       "      <td>69</td>\n",
       "      <td>100</td>\n",
       "      <td>95.0</td>\n",
       "      <td>100</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14</td>\n",
       "      <td>254011</td>\n",
       "      <td>Miguel</td>\n",
       "      <td>Torres</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>67</td>\n",
       "      <td>72</td>\n",
       "      <td>67</td>\n",
       "      <td>90.0</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15</td>\n",
       "      <td>276772</td>\n",
       "      <td>Alberto</td>\n",
       "      <td>Vazquez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100</td>\n",
       "      <td>69</td>\n",
       "      <td>100</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16</td>\n",
       "      <td>252165</td>\n",
       "      <td>Carlos</td>\n",
       "      <td>Vera</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100</td>\n",
       "      <td>84</td>\n",
       "      <td>67</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Numero  Expediente     Nombre   Apellido     Plan  Tarea1  Examen1  \\\n",
       "0        1      297613  Margarita     Duarte  LIM2014     100      100   \n",
       "1        2      261301     Manolo     Garcia  LIM2014     100       27   \n",
       "2        3      262979      Tomas      Gomez  LIM2014      67       57   \n",
       "3        4      223867     Susana   Gonzalez  LIM2014     100       60   \n",
       "4        5      200389      Itzel  Hernandez  LIM2014     100       75   \n",
       "5        6      270819      David  Hernandez  LIM2014     100       63   \n",
       "6        7      203004  Francisco    Jimenez  LIM2014      33       23   \n",
       "7        8      297471       Juan      Nuñez  LIM2014      67       77   \n",
       "8        9      276809     Helena      Perez  LIM2014     100       95   \n",
       "9       10      262959    Gustavo    Ramirez  LIM2014     100       87   \n",
       "10      11      273339      Pedro     Romero  LIM2014      67       67   \n",
       "11      12      226660     Hector    Sanchez  LIM2014     100       69   \n",
       "12      13      293143     Amanda       Sosa  LIM2014      33       69   \n",
       "13      14      254011     Miguel     Torres  LIM2014      67       72   \n",
       "14      15      276772    Alberto    Vazquez  LIM2014     100       69   \n",
       "15      16      252165     Carlos       Vera  LIM2014     100       84   \n",
       "\n",
       "    Tarea2  Examen2  Tarea3  Examen3  \n",
       "0      100    100.0     100       75  \n",
       "1      100     60.0      50       13  \n",
       "2      100    100.0     100       50  \n",
       "3       33    100.0     100       38  \n",
       "4       67    100.0     100       50  \n",
       "5      100     95.0     100       50  \n",
       "6      100     60.0      50        0  \n",
       "7       67     97.5     100       75  \n",
       "8      100     90.0     100       88  \n",
       "9      100    100.0     100      100  \n",
       "10     100    100.0      50       25  \n",
       "11     100     95.0     100       13  \n",
       "12     100     95.0     100       50  \n",
       "13      67     90.0     100      100  \n",
       "14     100    100.0     100        0  \n",
       "15      67    100.0     100       25  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "alumnos = pd.read_csv('ListaAlumnos.csv')\n",
    "alumnos"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "source": [
    "Pandas no selecciona ninguna columna como índice automáticamente, sin embargo nosotros podemos hacerlo después de cargar los datos:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100</td>\n",
       "      <td>75</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</td>\n",
       "      <td>27</td>\n",
       "      <td>100</td>\n",
       "      <td>60.0</td>\n",
       "      <td>50</td>\n",
       "      <td>13</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</td>\n",
       "      <td>57</td>\n",
       "      <td>100</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100</td>\n",
       "      <td>50</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</td>\n",
       "      <td>60</td>\n",
       "      <td>33</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100</td>\n",
       "      <td>38</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</td>\n",
       "      <td>75</td>\n",
       "      <td>67</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100</td>\n",
       "      <td>50</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</td>\n",
       "      <td>63</td>\n",
       "      <td>100</td>\n",
       "      <td>95.0</td>\n",
       "      <td>100</td>\n",
       "      <td>50</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</td>\n",
       "      <td>23</td>\n",
       "      <td>100</td>\n",
       "      <td>60.0</td>\n",
       "      <td>50</td>\n",
       "      <td>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</td>\n",
       "      <td>77</td>\n",
       "      <td>67</td>\n",
       "      <td>97.5</td>\n",
       "      <td>100</td>\n",
       "      <td>75</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</td>\n",
       "      <td>95</td>\n",
       "      <td>100</td>\n",
       "      <td>90.0</td>\n",
       "      <td>100</td>\n",
       "      <td>88</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</td>\n",
       "      <td>87</td>\n",
       "      <td>100</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100</td>\n",
       "      <td>100</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</td>\n",
       "      <td>67</td>\n",
       "      <td>100</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50</td>\n",
       "      <td>25</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</td>\n",
       "      <td>69</td>\n",
       "      <td>100</td>\n",
       "      <td>95.0</td>\n",
       "      <td>100</td>\n",
       "      <td>13</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</td>\n",
       "      <td>69</td>\n",
       "      <td>100</td>\n",
       "      <td>95.0</td>\n",
       "      <td>100</td>\n",
       "      <td>50</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</td>\n",
       "      <td>72</td>\n",
       "      <td>67</td>\n",
       "      <td>90.0</td>\n",
       "      <td>100</td>\n",
       "      <td>100</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</td>\n",
       "      <td>69</td>\n",
       "      <td>100</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100</td>\n",
       "      <td>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</td>\n",
       "      <td>84</td>\n",
       "      <td>67</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100</td>\n",
       "      <td>25</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      100     100   \n",
       "261301           2     Manolo     Garcia  LIM2014     100       27     100   \n",
       "262979           3      Tomas      Gomez  LIM2014      67       57     100   \n",
       "223867           4     Susana   Gonzalez  LIM2014     100       60      33   \n",
       "200389           5      Itzel  Hernandez  LIM2014     100       75      67   \n",
       "270819           6      David  Hernandez  LIM2014     100       63     100   \n",
       "203004           7  Francisco    Jimenez  LIM2014      33       23     100   \n",
       "297471           8       Juan      Nuñez  LIM2014      67       77      67   \n",
       "276809           9     Helena      Perez  LIM2014     100       95     100   \n",
       "262959          10    Gustavo    Ramirez  LIM2014     100       87     100   \n",
       "273339          11      Pedro     Romero  LIM2014      67       67     100   \n",
       "226660          12     Hector    Sanchez  LIM2014     100       69     100   \n",
       "293143          13     Amanda       Sosa  LIM2014      33       69     100   \n",
       "254011          14     Miguel     Torres  LIM2014      67       72      67   \n",
       "276772          15    Alberto    Vazquez  LIM2014     100       69     100   \n",
       "252165          16     Carlos       Vera  LIM2014     100       84      67   \n",
       "\n",
       "            Examen2  Tarea3  Examen3  \n",
       "Expediente                            \n",
       "297613        100.0     100       75  \n",
       "261301         60.0      50       13  \n",
       "262979        100.0     100       50  \n",
       "223867        100.0     100       38  \n",
       "200389        100.0     100       50  \n",
       "270819         95.0     100       50  \n",
       "203004         60.0      50        0  \n",
       "297471         97.5     100       75  \n",
       "276809         90.0     100       88  \n",
       "262959        100.0     100      100  \n",
       "273339        100.0      50       25  \n",
       "226660         95.0     100       13  \n",
       "293143         95.0     100       50  \n",
       "254011         90.0     100      100  \n",
       "276772        100.0     100        0  \n",
       "252165        100.0     100       25  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "alumnos.set_index('Expediente')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "source": [
    "Nótese que el comando anterior no modifica el _dataframe_ original."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>Expediente</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",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>297613</td>\n",
       "      <td>Margarita</td>\n",
       "      <td>Duarte</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100</td>\n",
       "      <td>75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>261301</td>\n",
       "      <td>Manolo</td>\n",
       "      <td>Garcia</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100</td>\n",
       "      <td>27</td>\n",
       "      <td>100</td>\n",
       "      <td>60.0</td>\n",
       "      <td>50</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>262979</td>\n",
       "      <td>Tomas</td>\n",
       "      <td>Gomez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>67</td>\n",
       "      <td>57</td>\n",
       "      <td>100</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>223867</td>\n",
       "      <td>Susana</td>\n",
       "      <td>Gonzalez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100</td>\n",
       "      <td>60</td>\n",
       "      <td>33</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>200389</td>\n",
       "      <td>Itzel</td>\n",
       "      <td>Hernandez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100</td>\n",
       "      <td>75</td>\n",
       "      <td>67</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>270819</td>\n",
       "      <td>David</td>\n",
       "      <td>Hernandez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100</td>\n",
       "      <td>63</td>\n",
       "      <td>100</td>\n",
       "      <td>95.0</td>\n",
       "      <td>100</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>203004</td>\n",
       "      <td>Francisco</td>\n",
       "      <td>Jimenez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>33</td>\n",
       "      <td>23</td>\n",
       "      <td>100</td>\n",
       "      <td>60.0</td>\n",
       "      <td>50</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>297471</td>\n",
       "      <td>Juan</td>\n",
       "      <td>Nuñez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>67</td>\n",
       "      <td>77</td>\n",
       "      <td>67</td>\n",
       "      <td>97.5</td>\n",
       "      <td>100</td>\n",
       "      <td>75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>276809</td>\n",
       "      <td>Helena</td>\n",
       "      <td>Perez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100</td>\n",
       "      <td>95</td>\n",
       "      <td>100</td>\n",
       "      <td>90.0</td>\n",
       "      <td>100</td>\n",
       "      <td>88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>262959</td>\n",
       "      <td>Gustavo</td>\n",
       "      <td>Ramirez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100</td>\n",
       "      <td>87</td>\n",
       "      <td>100</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>273339</td>\n",
       "      <td>Pedro</td>\n",
       "      <td>Romero</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>67</td>\n",
       "      <td>67</td>\n",
       "      <td>100</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>226660</td>\n",
       "      <td>Hector</td>\n",
       "      <td>Sanchez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100</td>\n",
       "      <td>69</td>\n",
       "      <td>100</td>\n",
       "      <td>95.0</td>\n",
       "      <td>100</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>293143</td>\n",
       "      <td>Amanda</td>\n",
       "      <td>Sosa</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>33</td>\n",
       "      <td>69</td>\n",
       "      <td>100</td>\n",
       "      <td>95.0</td>\n",
       "      <td>100</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14</td>\n",
       "      <td>254011</td>\n",
       "      <td>Miguel</td>\n",
       "      <td>Torres</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>67</td>\n",
       "      <td>72</td>\n",
       "      <td>67</td>\n",
       "      <td>90.0</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15</td>\n",
       "      <td>276772</td>\n",
       "      <td>Alberto</td>\n",
       "      <td>Vazquez</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100</td>\n",
       "      <td>69</td>\n",
       "      <td>100</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16</td>\n",
       "      <td>252165</td>\n",
       "      <td>Carlos</td>\n",
       "      <td>Vera</td>\n",
       "      <td>LIM2014</td>\n",
       "      <td>100</td>\n",
       "      <td>84</td>\n",
       "      <td>67</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Numero  Expediente     Nombre   Apellido     Plan  Tarea1  Examen1  \\\n",
       "0        1      297613  Margarita     Duarte  LIM2014     100      100   \n",
       "1        2      261301     Manolo     Garcia  LIM2014     100       27   \n",
       "2        3      262979      Tomas      Gomez  LIM2014      67       57   \n",
       "3        4      223867     Susana   Gonzalez  LIM2014     100       60   \n",
       "4        5      200389      Itzel  Hernandez  LIM2014     100       75   \n",
       "5        6      270819      David  Hernandez  LIM2014     100       63   \n",
       "6        7      203004  Francisco    Jimenez  LIM2014      33       23   \n",
       "7        8      297471       Juan      Nuñez  LIM2014      67       77   \n",
       "8        9      276809     Helena      Perez  LIM2014     100       95   \n",
       "9       10      262959    Gustavo    Ramirez  LIM2014     100       87   \n",
       "10      11      273339      Pedro     Romero  LIM2014      67       67   \n",
       "11      12      226660     Hector    Sanchez  LIM2014     100       69   \n",
       "12      13      293143     Amanda       Sosa  LIM2014      33       69   \n",
       "13      14      254011     Miguel     Torres  LIM2014      67       72   \n",
       "14      15      276772    Alberto    Vazquez  LIM2014     100       69   \n",
       "15      16      252165     Carlos       Vera  LIM2014     100       84   \n",
       "\n",
       "    Tarea2  Examen2  Tarea3  Examen3  \n",
       "0      100    100.0     100       75  \n",
       "1      100     60.0      50       13  \n",
       "2      100    100.0     100       50  \n",
       "3       33    100.0     100       38  \n",
       "4       67    100.0     100       50  \n",
       "5      100     95.0     100       50  \n",
       "6      100     60.0      50        0  \n",
       "7       67     97.5     100       75  \n",
       "8      100     90.0     100       88  \n",
       "9      100    100.0     100      100  \n",
       "10     100    100.0      50       25  \n",
       "11     100     95.0     100       13  \n",
       "12     100     95.0     100       50  \n",
       "13      67     90.0     100      100  \n",
       "14     100    100.0     100        0  \n",
       "15      67    100.0     100       25  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "alumnos"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "source": [
    "Para que sea modificado debemos de usar:\n",
    "    \n",
    "    alumnos = alumnos.set_index('Expediente')\n",
    "    \n",
    "o\n",
    "\n",
    "    alumnos.set_index('Expediente', inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100</td>\n",
       "      <td>75</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</td>\n",
       "      <td>27</td>\n",
       "      <td>100</td>\n",
       "      <td>60.0</td>\n",
       "      <td>50</td>\n",
       "      <td>13</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</td>\n",
       "      <td>57</td>\n",
       "      <td>100</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100</td>\n",
       "      <td>50</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</td>\n",
       "      <td>60</td>\n",
       "      <td>33</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100</td>\n",
       "      <td>38</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</td>\n",
       "      <td>75</td>\n",
       "      <td>67</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100</td>\n",
       "      <td>50</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</td>\n",
       "      <td>63</td>\n",
       "      <td>100</td>\n",
       "      <td>95.0</td>\n",
       "      <td>100</td>\n",
       "      <td>50</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</td>\n",
       "      <td>23</td>\n",
       "      <td>100</td>\n",
       "      <td>60.0</td>\n",
       "      <td>50</td>\n",
       "      <td>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</td>\n",
       "      <td>77</td>\n",
       "      <td>67</td>\n",
       "      <td>97.5</td>\n",
       "      <td>100</td>\n",
       "      <td>75</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</td>\n",
       "      <td>95</td>\n",
       "      <td>100</td>\n",
       "      <td>90.0</td>\n",
       "      <td>100</td>\n",
       "      <td>88</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</td>\n",
       "      <td>87</td>\n",
       "      <td>100</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100</td>\n",
       "      <td>100</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</td>\n",
       "      <td>67</td>\n",
       "      <td>100</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50</td>\n",
       "      <td>25</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</td>\n",
       "      <td>69</td>\n",
       "      <td>100</td>\n",
       "      <td>95.0</td>\n",
       "      <td>100</td>\n",
       "      <td>13</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</td>\n",
       "      <td>69</td>\n",
       "      <td>100</td>\n",
       "      <td>95.0</td>\n",
       "      <td>100</td>\n",
       "      <td>50</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</td>\n",
       "      <td>72</td>\n",
       "      <td>67</td>\n",
       "      <td>90.0</td>\n",
       "      <td>100</td>\n",
       "      <td>100</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</td>\n",
       "      <td>69</td>\n",
       "      <td>100</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100</td>\n",
       "      <td>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</td>\n",
       "      <td>84</td>\n",
       "      <td>67</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100</td>\n",
       "      <td>25</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      100     100   \n",
       "261301           2     Manolo     Garcia  LIM2014     100       27     100   \n",
       "262979           3      Tomas      Gomez  LIM2014      67       57     100   \n",
       "223867           4     Susana   Gonzalez  LIM2014     100       60      33   \n",
       "200389           5      Itzel  Hernandez  LIM2014     100       75      67   \n",
       "270819           6      David  Hernandez  LIM2014     100       63     100   \n",
       "203004           7  Francisco    Jimenez  LIM2014      33       23     100   \n",
       "297471           8       Juan      Nuñez  LIM2014      67       77      67   \n",
       "276809           9     Helena      Perez  LIM2014     100       95     100   \n",
       "262959          10    Gustavo    Ramirez  LIM2014     100       87     100   \n",
       "273339          11      Pedro     Romero  LIM2014      67       67     100   \n",
       "226660          12     Hector    Sanchez  LIM2014     100       69     100   \n",
       "293143          13     Amanda       Sosa  LIM2014      33       69     100   \n",
       "254011          14     Miguel     Torres  LIM2014      67       72      67   \n",
       "276772          15    Alberto    Vazquez  LIM2014     100       69     100   \n",
       "252165          16     Carlos       Vera  LIM2014     100       84      67   \n",
       "\n",
       "            Examen2  Tarea3  Examen3  \n",
       "Expediente                            \n",
       "297613        100.0     100       75  \n",
       "261301         60.0      50       13  \n",
       "262979        100.0     100       50  \n",
       "223867        100.0     100       38  \n",
       "200389        100.0     100       50  \n",
       "270819         95.0     100       50  \n",
       "203004         60.0      50        0  \n",
       "297471         97.5     100       75  \n",
       "276809         90.0     100       88  \n",
       "262959        100.0     100      100  \n",
       "273339        100.0      50       25  \n",
       "226660         95.0     100       13  \n",
       "293143         95.0     100       50  \n",
       "254011         90.0     100      100  \n",
       "276772        100.0     100        0  \n",
       "252165        100.0     100       25  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "alumnos = pd.read_csv('ListaAlumnos.csv')\n",
    "alumnos = alumnos.set_index('Expediente')\n",
    "alumnos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100</td>\n",
       "      <td>75</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</td>\n",
       "      <td>27</td>\n",
       "      <td>100</td>\n",
       "      <td>60.0</td>\n",
       "      <td>50</td>\n",
       "      <td>13</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</td>\n",
       "      <td>57</td>\n",
       "      <td>100</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100</td>\n",
       "      <td>50</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</td>\n",
       "      <td>60</td>\n",
       "      <td>33</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100</td>\n",
       "      <td>38</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</td>\n",
       "      <td>75</td>\n",
       "      <td>67</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100</td>\n",
       "      <td>50</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</td>\n",
       "      <td>63</td>\n",
       "      <td>100</td>\n",
       "      <td>95.0</td>\n",
       "      <td>100</td>\n",
       "      <td>50</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</td>\n",
       "      <td>23</td>\n",
       "      <td>100</td>\n",
       "      <td>60.0</td>\n",
       "      <td>50</td>\n",
       "      <td>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</td>\n",
       "      <td>77</td>\n",
       "      <td>67</td>\n",
       "      <td>97.5</td>\n",
       "      <td>100</td>\n",
       "      <td>75</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</td>\n",
       "      <td>95</td>\n",
       "      <td>100</td>\n",
       "      <td>90.0</td>\n",
       "      <td>100</td>\n",
       "      <td>88</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</td>\n",
       "      <td>87</td>\n",
       "      <td>100</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100</td>\n",
       "      <td>100</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</td>\n",
       "      <td>67</td>\n",
       "      <td>100</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50</td>\n",
       "      <td>25</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</td>\n",
       "      <td>69</td>\n",
       "      <td>100</td>\n",
       "      <td>95.0</td>\n",
       "      <td>100</td>\n",
       "      <td>13</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</td>\n",
       "      <td>69</td>\n",
       "      <td>100</td>\n",
       "      <td>95.0</td>\n",
       "      <td>100</td>\n",
       "      <td>50</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</td>\n",
       "      <td>72</td>\n",
       "      <td>67</td>\n",
       "      <td>90.0</td>\n",
       "      <td>100</td>\n",
       "      <td>100</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</td>\n",
       "      <td>69</td>\n",
       "      <td>100</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100</td>\n",
       "      <td>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</td>\n",
       "      <td>84</td>\n",
       "      <td>67</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100</td>\n",
       "      <td>25</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      100     100   \n",
       "261301           2     Manolo     Garcia  LIM2014     100       27     100   \n",
       "262979           3      Tomas      Gomez  LIM2014      67       57     100   \n",
       "223867           4     Susana   Gonzalez  LIM2014     100       60      33   \n",
       "200389           5      Itzel  Hernandez  LIM2014     100       75      67   \n",
       "270819           6      David  Hernandez  LIM2014     100       63     100   \n",
       "203004           7  Francisco    Jimenez  LIM2014      33       23     100   \n",
       "297471           8       Juan      Nuñez  LIM2014      67       77      67   \n",
       "276809           9     Helena      Perez  LIM2014     100       95     100   \n",
       "262959          10    Gustavo    Ramirez  LIM2014     100       87     100   \n",
       "273339          11      Pedro     Romero  LIM2014      67       67     100   \n",
       "226660          12     Hector    Sanchez  LIM2014     100       69     100   \n",
       "293143          13     Amanda       Sosa  LIM2014      33       69     100   \n",
       "254011          14     Miguel     Torres  LIM2014      67       72      67   \n",
       "276772          15    Alberto    Vazquez  LIM2014     100       69     100   \n",
       "252165          16     Carlos       Vera  LIM2014     100       84      67   \n",
       "\n",
       "            Examen2  Tarea3  Examen3  \n",
       "Expediente                            \n",
       "297613        100.0     100       75  \n",
       "261301         60.0      50       13  \n",
       "262979        100.0     100       50  \n",
       "223867        100.0     100       38  \n",
       "200389        100.0     100       50  \n",
       "270819         95.0     100       50  \n",
       "203004         60.0      50        0  \n",
       "297471         97.5     100       75  \n",
       "276809         90.0     100       88  \n",
       "262959        100.0     100      100  \n",
       "273339        100.0      50       25  \n",
       "226660         95.0     100       13  \n",
       "293143         95.0     100       50  \n",
       "254011         90.0     100      100  \n",
       "276772        100.0     100        0  \n",
       "252165        100.0     100       25  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "alumnos = pd.read_csv('ListaAlumnos.csv')\n",
    "alumnos.set_index('Expediente', inplace=True)\n",
    "alumnos"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "source": [
    "También se puede identificar desde el momento de la lectura el índice:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100</td>\n",
       "      <td>75</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</td>\n",
       "      <td>27</td>\n",
       "      <td>100</td>\n",
       "      <td>60.0</td>\n",
       "      <td>50</td>\n",
       "      <td>13</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</td>\n",
       "      <td>57</td>\n",
       "      <td>100</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100</td>\n",
       "      <td>50</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</td>\n",
       "      <td>60</td>\n",
       "      <td>33</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100</td>\n",
       "      <td>38</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</td>\n",
       "      <td>75</td>\n",
       "      <td>67</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100</td>\n",
       "      <td>50</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</td>\n",
       "      <td>63</td>\n",
       "      <td>100</td>\n",
       "      <td>95.0</td>\n",
       "      <td>100</td>\n",
       "      <td>50</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</td>\n",
       "      <td>23</td>\n",
       "      <td>100</td>\n",
       "      <td>60.0</td>\n",
       "      <td>50</td>\n",
       "      <td>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</td>\n",
       "      <td>77</td>\n",
       "      <td>67</td>\n",
       "      <td>97.5</td>\n",
       "      <td>100</td>\n",
       "      <td>75</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</td>\n",
       "      <td>95</td>\n",
       "      <td>100</td>\n",
       "      <td>90.0</td>\n",
       "      <td>100</td>\n",
       "      <td>88</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</td>\n",
       "      <td>87</td>\n",
       "      <td>100</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100</td>\n",
       "      <td>100</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</td>\n",
       "      <td>67</td>\n",
       "      <td>100</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50</td>\n",
       "      <td>25</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</td>\n",
       "      <td>69</td>\n",
       "      <td>100</td>\n",
       "      <td>95.0</td>\n",
       "      <td>100</td>\n",
       "      <td>13</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</td>\n",
       "      <td>69</td>\n",
       "      <td>100</td>\n",
       "      <td>95.0</td>\n",
       "      <td>100</td>\n",
       "      <td>50</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</td>\n",
       "      <td>72</td>\n",
       "      <td>67</td>\n",
       "      <td>90.0</td>\n",
       "      <td>100</td>\n",
       "      <td>100</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</td>\n",
       "      <td>69</td>\n",
       "      <td>100</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100</td>\n",
       "      <td>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</td>\n",
       "      <td>84</td>\n",
       "      <td>67</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100</td>\n",
       "      <td>25</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      100     100   \n",
       "261301           2     Manolo     Garcia  LIM2014     100       27     100   \n",
       "262979           3      Tomas      Gomez  LIM2014      67       57     100   \n",
       "223867           4     Susana   Gonzalez  LIM2014     100       60      33   \n",
       "200389           5      Itzel  Hernandez  LIM2014     100       75      67   \n",
       "270819           6      David  Hernandez  LIM2014     100       63     100   \n",
       "203004           7  Francisco    Jimenez  LIM2014      33       23     100   \n",
       "297471           8       Juan      Nuñez  LIM2014      67       77      67   \n",
       "276809           9     Helena      Perez  LIM2014     100       95     100   \n",
       "262959          10    Gustavo    Ramirez  LIM2014     100       87     100   \n",
       "273339          11      Pedro     Romero  LIM2014      67       67     100   \n",
       "226660          12     Hector    Sanchez  LIM2014     100       69     100   \n",
       "293143          13     Amanda       Sosa  LIM2014      33       69     100   \n",
       "254011          14     Miguel     Torres  LIM2014      67       72      67   \n",
       "276772          15    Alberto    Vazquez  LIM2014     100       69     100   \n",
       "252165          16     Carlos       Vera  LIM2014     100       84      67   \n",
       "\n",
       "            Examen2  Tarea3  Examen3  \n",
       "Expediente                            \n",
       "297613        100.0     100       75  \n",
       "261301         60.0      50       13  \n",
       "262979        100.0     100       50  \n",
       "223867        100.0     100       38  \n",
       "200389        100.0     100       50  \n",
       "270819         95.0     100       50  \n",
       "203004         60.0      50        0  \n",
       "297471         97.5     100       75  \n",
       "276809         90.0     100       88  \n",
       "262959        100.0     100      100  \n",
       "273339        100.0      50       25  \n",
       "226660         95.0     100       13  \n",
       "293143         95.0     100       50  \n",
       "254011         90.0     100      100  \n",
       "276772        100.0     100        0  \n",
       "252165        100.0     100       25  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "alumnos = pd.read_csv('ListaAlumnos.csv', index_col='Expediente')\n",
    "alumnos"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "source": [
    "_Pandas_ automáticamente hace su mejor esfuerzo para:\n",
    "\n",
    "* Identificar nombres de columnas\n",
    "* Identificar el tipo de datos que hay en cada columna"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Expediente\n",
       "297613    100\n",
       "261301     27\n",
       "262979     57\n",
       "223867     60\n",
       "200389     75\n",
       "270819     63\n",
       "203004     23\n",
       "297471     77\n",
       "276809     95\n",
       "262959     87\n",
       "273339     67\n",
       "226660     69\n",
       "293143     69\n",
       "254011     72\n",
       "276772     69\n",
       "252165     84\n",
       "Name: Examen1, dtype: int64"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "alumnos.Examen1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Expediente\n",
       "297613    100.0\n",
       "261301     60.0\n",
       "262979    100.0\n",
       "223867    100.0\n",
       "200389    100.0\n",
       "270819     95.0\n",
       "203004     60.0\n",
       "297471     97.5\n",
       "276809     90.0\n",
       "262959    100.0\n",
       "273339    100.0\n",
       "226660     95.0\n",
       "293143     95.0\n",
       "254011     90.0\n",
       "276772    100.0\n",
       "252165    100.0\n",
       "Name: Examen2, dtype: float64"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "alumnos.Examen2"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "source": [
    "Las columnas se pueden convertir usando:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "slideshow": {
     "slide_type": "fragment"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Expediente\n",
       "297613    100.0\n",
       "261301     27.0\n",
       "262979     57.0\n",
       "223867     60.0\n",
       "200389     75.0\n",
       "270819     63.0\n",
       "203004     23.0\n",
       "297471     77.0\n",
       "276809     95.0\n",
       "262959     87.0\n",
       "273339     67.0\n",
       "226660     69.0\n",
       "293143     69.0\n",
       "254011     72.0\n",
       "276772     69.0\n",
       "252165     84.0\n",
       "Name: Examen1, dtype: float64"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "alumnos.Examen1 = alumnos.Examen1.astype('float64')\n",
    "alumnos.Examen1"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "source": [
    "También podemos identificar nosotros mismos los tipos que deberán de ser usados.\n",
    "\n",
    "Hay varias maneras de hacer esto, pero una relativamente sencilla es pasar un diccionario con esta información, donde las **llaves** son los nombres de las columnas y los **valores** el tipo de dato y pasándolo al `read_csv` con el nombre `dtype`:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "slideshow": {
     "slide_type": "fragment"
    }
   },
   "outputs": [],
   "source": [
    "tipos = {'Numero':'int',\n",
    "         'Expediente':'str',\n",
    "         'Nombre':'str',\n",
    "         'Apellido':'str',\n",
    "         'Plan':'str',\n",
    "         'Tarea1':'float',\n",
    "         'Examen1':'float',\n",
    "         'Tarea2':'float',\n",
    "         'Examen2':'float',\n",
    "         'Tarea3':'float',\n",
    "         'Examen3':'float'}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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>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>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     23.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": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "alumnos = pd.read_csv('ListaAlumnos.csv', index_col='Expediente', dtype=tipos)\n",
    "alumnos"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "source": [
    "Para bases de datos muy grandes es posible que alguna vez no necesitemos todas las columnas y cargar sólo aquellas necesarias hará más eficiente nuestro análisis. Podemos seleccionar algunas usando `usecols`:"
   ]
  },
  {
   "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>Examen1</th>\n",
       "      <th>Examen2</th>\n",
       "      <th>Examen3</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>75.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>261301</th>\n",
       "      <td>27.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>13.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>262979</th>\n",
       "      <td>57.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223867</th>\n",
       "      <td>60.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>38.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>200389</th>\n",
       "      <td>75.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>270819</th>\n",
       "      <td>63.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203004</th>\n",
       "      <td>23.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>297471</th>\n",
       "      <td>77.0</td>\n",
       "      <td>97.5</td>\n",
       "      <td>75.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276809</th>\n",
       "      <td>95.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>88.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>262959</th>\n",
       "      <td>87.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>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>226660</th>\n",
       "      <td>69.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>13.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>293143</th>\n",
       "      <td>69.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>254011</th>\n",
       "      <td>72.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276772</th>\n",
       "      <td>69.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>252165</th>\n",
       "      <td>84.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Examen1  Examen2  Examen3\n",
       "Expediente                           \n",
       "297613        100.0    100.0     75.0\n",
       "261301         27.0     60.0     13.0\n",
       "262979         57.0    100.0     50.0\n",
       "223867         60.0    100.0     38.0\n",
       "200389         75.0    100.0     50.0\n",
       "270819         63.0     95.0     50.0\n",
       "203004         23.0     60.0      0.0\n",
       "297471         77.0     97.5     75.0\n",
       "276809         95.0     90.0     88.0\n",
       "262959         87.0    100.0    100.0\n",
       "273339         67.0    100.0     25.0\n",
       "226660         69.0     95.0     13.0\n",
       "293143         69.0     95.0     50.0\n",
       "254011         72.0     90.0    100.0\n",
       "276772         69.0    100.0      0.0\n",
       "252165         84.0    100.0     25.0"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "alumnos = pd.read_csv('ListaAlumnos.csv', index_col='Expediente', dtype=tipos, \n",
    "                      usecols=['Expediente', 'Examen1', 'Examen2','Examen3'])\n",
    "alumnos"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "source": [
    "A continuación, para hacer algunos ejercicios trabajaremos con los datos de:\n",
    "\n",
    "https://www.inegi.org.mx/temas/natalidad/default.html#Tabulados"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "source": [
    "Ejercicio:\n",
    "\n",
    "Cargar los datos de natalidad total por entidad de los años recientes a pandas."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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>2010 Total</th>\n",
       "      <th>2011 Total</th>\n",
       "      <th>2012 Total</th>\n",
       "      <th>2013 Total</th>\n",
       "      <th>2014 Total</th>\n",
       "      <th>2015 Total</th>\n",
       "      <th>2016 Total</th>\n",
       "      <th>2017 Total</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Entidad federativa de residencia habitual de la madre</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>Total</th>\n",
       "      <td>2643908.0</td>\n",
       "      <td>2586287.0</td>\n",
       "      <td>2498880.0</td>\n",
       "      <td>2478889.0</td>\n",
       "      <td>2463420.0</td>\n",
       "      <td>2353596.0</td>\n",
       "      <td>2293708.0</td>\n",
       "      <td>2234039.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Aguascalientes</th>\n",
       "      <td>26583.0</td>\n",
       "      <td>27427.0</td>\n",
       "      <td>26933.0</td>\n",
       "      <td>26434.0</td>\n",
       "      <td>27080.0</td>\n",
       "      <td>26486.0</td>\n",
       "      <td>26388.0</td>\n",
       "      <td>26955.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Baja California</th>\n",
       "      <td>63559.0</td>\n",
       "      <td>65631.0</td>\n",
       "      <td>62871.0</td>\n",
       "      <td>61840.0</td>\n",
       "      <td>63183.0</td>\n",
       "      <td>63805.0</td>\n",
       "      <td>62608.0</td>\n",
       "      <td>61840.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Baja California Sur</th>\n",
       "      <td>13988.0</td>\n",
       "      <td>13412.0</td>\n",
       "      <td>12864.0</td>\n",
       "      <td>12489.0</td>\n",
       "      <td>12667.0</td>\n",
       "      <td>12526.0</td>\n",
       "      <td>12545.0</td>\n",
       "      <td>12573.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Campeche</th>\n",
       "      <td>20380.0</td>\n",
       "      <td>22138.0</td>\n",
       "      <td>18343.0</td>\n",
       "      <td>18998.0</td>\n",
       "      <td>19304.0</td>\n",
       "      <td>17862.0</td>\n",
       "      <td>17361.0</td>\n",
       "      <td>17034.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Coahuila de Zaragoza</th>\n",
       "      <td>56972.0</td>\n",
       "      <td>58882.0</td>\n",
       "      <td>59966.0</td>\n",
       "      <td>62490.0</td>\n",
       "      <td>62966.0</td>\n",
       "      <td>62807.0</td>\n",
       "      <td>62011.0</td>\n",
       "      <td>58393.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Colima</th>\n",
       "      <td>13796.0</td>\n",
       "      <td>14054.0</td>\n",
       "      <td>13422.0</td>\n",
       "      <td>13287.0</td>\n",
       "      <td>13303.0</td>\n",
       "      <td>12344.0</td>\n",
       "      <td>11867.0</td>\n",
       "      <td>11756.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Chiapas</th>\n",
       "      <td>175382.0</td>\n",
       "      <td>168256.0</td>\n",
       "      <td>144423.0</td>\n",
       "      <td>164102.0</td>\n",
       "      <td>164912.0</td>\n",
       "      <td>145526.0</td>\n",
       "      <td>140356.0</td>\n",
       "      <td>131638.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Chihuahua</th>\n",
       "      <td>74063.0</td>\n",
       "      <td>69376.0</td>\n",
       "      <td>69735.0</td>\n",
       "      <td>66516.0</td>\n",
       "      <td>66110.0</td>\n",
       "      <td>63395.0</td>\n",
       "      <td>62313.0</td>\n",
       "      <td>63475.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ciudad de México</th>\n",
       "      <td>160057.0</td>\n",
       "      <td>156549.0</td>\n",
       "      <td>153631.0</td>\n",
       "      <td>145302.0</td>\n",
       "      <td>145609.0</td>\n",
       "      <td>135828.0</td>\n",
       "      <td>128227.0</td>\n",
       "      <td>119227.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Durango</th>\n",
       "      <td>42514.0</td>\n",
       "      <td>41922.0</td>\n",
       "      <td>40269.0</td>\n",
       "      <td>39298.0</td>\n",
       "      <td>40337.0</td>\n",
       "      <td>39738.0</td>\n",
       "      <td>37801.0</td>\n",
       "      <td>37897.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Guanajuato</th>\n",
       "      <td>126741.0</td>\n",
       "      <td>124003.0</td>\n",
       "      <td>122412.0</td>\n",
       "      <td>119083.0</td>\n",
       "      <td>114890.0</td>\n",
       "      <td>114269.0</td>\n",
       "      <td>117281.0</td>\n",
       "      <td>116531.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Guerrero</th>\n",
       "      <td>119780.0</td>\n",
       "      <td>113692.0</td>\n",
       "      <td>98285.0</td>\n",
       "      <td>102077.0</td>\n",
       "      <td>90352.0</td>\n",
       "      <td>80336.0</td>\n",
       "      <td>87127.0</td>\n",
       "      <td>79244.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hidalgo</th>\n",
       "      <td>62185.0</td>\n",
       "      <td>63380.0</td>\n",
       "      <td>59924.0</td>\n",
       "      <td>59045.0</td>\n",
       "      <td>54108.0</td>\n",
       "      <td>54124.0</td>\n",
       "      <td>52629.0</td>\n",
       "      <td>50255.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Jalisco</th>\n",
       "      <td>161543.0</td>\n",
       "      <td>163123.0</td>\n",
       "      <td>161217.0</td>\n",
       "      <td>159748.0</td>\n",
       "      <td>158592.0</td>\n",
       "      <td>151578.0</td>\n",
       "      <td>148377.0</td>\n",
       "      <td>151950.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>México</th>\n",
       "      <td>335898.0</td>\n",
       "      <td>327165.0</td>\n",
       "      <td>326412.0</td>\n",
       "      <td>317834.0</td>\n",
       "      <td>316088.0</td>\n",
       "      <td>303778.0</td>\n",
       "      <td>295635.0</td>\n",
       "      <td>286204.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Michoacán de Ocampo</th>\n",
       "      <td>116260.0</td>\n",
       "      <td>111362.0</td>\n",
       "      <td>104885.0</td>\n",
       "      <td>105158.0</td>\n",
       "      <td>104370.0</td>\n",
       "      <td>98543.0</td>\n",
       "      <td>96217.0</td>\n",
       "      <td>95287.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Morelos</th>\n",
       "      <td>40210.0</td>\n",
       "      <td>40230.0</td>\n",
       "      <td>37446.0</td>\n",
       "      <td>37335.0</td>\n",
       "      <td>36666.0</td>\n",
       "      <td>37089.0</td>\n",
       "      <td>35632.0</td>\n",
       "      <td>33159.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nayarit</th>\n",
       "      <td>24639.0</td>\n",
       "      <td>24949.0</td>\n",
       "      <td>25731.0</td>\n",
       "      <td>24163.0</td>\n",
       "      <td>22930.0</td>\n",
       "      <td>23663.0</td>\n",
       "      <td>21714.0</td>\n",
       "      <td>21688.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nuevo León</th>\n",
       "      <td>94119.0</td>\n",
       "      <td>93747.0</td>\n",
       "      <td>94440.0</td>\n",
       "      <td>93710.0</td>\n",
       "      <td>93225.0</td>\n",
       "      <td>93123.0</td>\n",
       "      <td>92978.0</td>\n",
       "      <td>89115.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Oaxaca</th>\n",
       "      <td>109624.0</td>\n",
       "      <td>98888.0</td>\n",
       "      <td>95505.0</td>\n",
       "      <td>92503.0</td>\n",
       "      <td>88364.0</td>\n",
       "      <td>85492.0</td>\n",
       "      <td>83564.0</td>\n",
       "      <td>78673.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Puebla</th>\n",
       "      <td>160571.0</td>\n",
       "      <td>146865.0</td>\n",
       "      <td>147296.0</td>\n",
       "      <td>140507.0</td>\n",
       "      <td>150633.0</td>\n",
       "      <td>141121.0</td>\n",
       "      <td>132823.0</td>\n",
       "      <td>136271.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Querétaro</th>\n",
       "      <td>40863.0</td>\n",
       "      <td>41714.0</td>\n",
       "      <td>41567.0</td>\n",
       "      <td>41817.0</td>\n",
       "      <td>42231.0</td>\n",
       "      <td>41904.0</td>\n",
       "      <td>39634.0</td>\n",
       "      <td>39400.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Quintana Roo</th>\n",
       "      <td>28999.0</td>\n",
       "      <td>28848.0</td>\n",
       "      <td>28736.0</td>\n",
       "      <td>28103.0</td>\n",
       "      <td>30563.0</td>\n",
       "      <td>30841.0</td>\n",
       "      <td>30367.0</td>\n",
       "      <td>29442.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>San Luis Potosí</th>\n",
       "      <td>58583.0</td>\n",
       "      <td>57549.0</td>\n",
       "      <td>55847.0</td>\n",
       "      <td>54488.0</td>\n",
       "      <td>54112.0</td>\n",
       "      <td>52250.0</td>\n",
       "      <td>49688.0</td>\n",
       "      <td>48693.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sinaloa</th>\n",
       "      <td>61233.0</td>\n",
       "      <td>60208.0</td>\n",
       "      <td>57543.0</td>\n",
       "      <td>56267.0</td>\n",
       "      <td>55371.0</td>\n",
       "      <td>53461.0</td>\n",
       "      <td>53247.0</td>\n",
       "      <td>51850.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sonora</th>\n",
       "      <td>54110.0</td>\n",
       "      <td>54756.0</td>\n",
       "      <td>53768.0</td>\n",
       "      <td>52825.0</td>\n",
       "      <td>51894.0</td>\n",
       "      <td>48925.0</td>\n",
       "      <td>46785.0</td>\n",
       "      <td>45951.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tabasco</th>\n",
       "      <td>49844.0</td>\n",
       "      <td>49575.0</td>\n",
       "      <td>48806.0</td>\n",
       "      <td>52478.0</td>\n",
       "      <td>52508.0</td>\n",
       "      <td>49785.0</td>\n",
       "      <td>50310.0</td>\n",
       "      <td>48725.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tamaulipas</th>\n",
       "      <td>69211.0</td>\n",
       "      <td>66892.0</td>\n",
       "      <td>63263.0</td>\n",
       "      <td>59933.0</td>\n",
       "      <td>62358.0</td>\n",
       "      <td>60263.0</td>\n",
       "      <td>58914.0</td>\n",
       "      <td>57282.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tlaxcala</th>\n",
       "      <td>27076.0</td>\n",
       "      <td>27867.0</td>\n",
       "      <td>28203.0</td>\n",
       "      <td>27060.0</td>\n",
       "      <td>25832.0</td>\n",
       "      <td>26166.0</td>\n",
       "      <td>25057.0</td>\n",
       "      <td>26589.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Veracruz de Ignacio de la Llave</th>\n",
       "      <td>174086.0</td>\n",
       "      <td>171417.0</td>\n",
       "      <td>164174.0</td>\n",
       "      <td>161019.0</td>\n",
       "      <td>162156.0</td>\n",
       "      <td>144842.0</td>\n",
       "      <td>137338.0</td>\n",
       "      <td>126623.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Yucatán</th>\n",
       "      <td>37703.0</td>\n",
       "      <td>36860.0</td>\n",
       "      <td>36427.0</td>\n",
       "      <td>38588.0</td>\n",
       "      <td>37579.0</td>\n",
       "      <td>37117.0</td>\n",
       "      <td>35381.0</td>\n",
       "      <td>35017.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zacatecas</th>\n",
       "      <td>35974.0</td>\n",
       "      <td>36629.0</td>\n",
       "      <td>35625.0</td>\n",
       "      <td>35089.0</td>\n",
       "      <td>34031.0</td>\n",
       "      <td>33833.0</td>\n",
       "      <td>33677.0</td>\n",
       "      <td>34460.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Extranjero</th>\n",
       "      <td>7362.0</td>\n",
       "      <td>8921.0</td>\n",
       "      <td>8911.0</td>\n",
       "      <td>9303.0</td>\n",
       "      <td>9096.0</td>\n",
       "      <td>10776.0</td>\n",
       "      <td>7856.0</td>\n",
       "      <td>10842.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    2010 Total  2011 Total  \\\n",
       "Entidad federativa de residencia habitual de la...                           \n",
       "Total                                                2643908.0   2586287.0   \n",
       "Aguascalientes                                         26583.0     27427.0   \n",
       "Baja California                                        63559.0     65631.0   \n",
       "Baja California Sur                                    13988.0     13412.0   \n",
       "Campeche                                               20380.0     22138.0   \n",
       "Coahuila de Zaragoza                                   56972.0     58882.0   \n",
       "Colima                                                 13796.0     14054.0   \n",
       "Chiapas                                               175382.0    168256.0   \n",
       "Chihuahua                                              74063.0     69376.0   \n",
       "Ciudad de México                                      160057.0    156549.0   \n",
       "Durango                                                42514.0     41922.0   \n",
       "Guanajuato                                            126741.0    124003.0   \n",
       "Guerrero                                              119780.0    113692.0   \n",
       "Hidalgo                                                62185.0     63380.0   \n",
       "Jalisco                                               161543.0    163123.0   \n",
       "México                                                335898.0    327165.0   \n",
       "Michoacán de Ocampo                                   116260.0    111362.0   \n",
       "Morelos                                                40210.0     40230.0   \n",
       "Nayarit                                                24639.0     24949.0   \n",
       "Nuevo León                                             94119.0     93747.0   \n",
       "Oaxaca                                                109624.0     98888.0   \n",
       "Puebla                                                160571.0    146865.0   \n",
       "Querétaro                                              40863.0     41714.0   \n",
       "Quintana Roo                                           28999.0     28848.0   \n",
       "San Luis Potosí                                        58583.0     57549.0   \n",
       "Sinaloa                                                61233.0     60208.0   \n",
       "Sonora                                                 54110.0     54756.0   \n",
       "Tabasco                                                49844.0     49575.0   \n",
       "Tamaulipas                                             69211.0     66892.0   \n",
       "Tlaxcala                                               27076.0     27867.0   \n",
       "Veracruz de Ignacio de la Llave                       174086.0    171417.0   \n",
       "Yucatán                                                37703.0     36860.0   \n",
       "Zacatecas                                              35974.0     36629.0   \n",
       "Extranjero                                              7362.0      8921.0   \n",
       "NaN                                                        NaN         NaN   \n",
       "\n",
       "                                                    2012 Total  2013 Total  \\\n",
       "Entidad federativa de residencia habitual de la...                           \n",
       "Total                                                2498880.0   2478889.0   \n",
       "Aguascalientes                                         26933.0     26434.0   \n",
       "Baja California                                        62871.0     61840.0   \n",
       "Baja California Sur                                    12864.0     12489.0   \n",
       "Campeche                                               18343.0     18998.0   \n",
       "Coahuila de Zaragoza                                   59966.0     62490.0   \n",
       "Colima                                                 13422.0     13287.0   \n",
       "Chiapas                                               144423.0    164102.0   \n",
       "Chihuahua                                              69735.0     66516.0   \n",
       "Ciudad de México                                      153631.0    145302.0   \n",
       "Durango                                                40269.0     39298.0   \n",
       "Guanajuato                                            122412.0    119083.0   \n",
       "Guerrero                                               98285.0    102077.0   \n",
       "Hidalgo                                                59924.0     59045.0   \n",
       "Jalisco                                               161217.0    159748.0   \n",
       "México                                                326412.0    317834.0   \n",
       "Michoacán de Ocampo                                   104885.0    105158.0   \n",
       "Morelos                                                37446.0     37335.0   \n",
       "Nayarit                                                25731.0     24163.0   \n",
       "Nuevo León                                             94440.0     93710.0   \n",
       "Oaxaca                                                 95505.0     92503.0   \n",
       "Puebla                                                147296.0    140507.0   \n",
       "Querétaro                                              41567.0     41817.0   \n",
       "Quintana Roo                                           28736.0     28103.0   \n",
       "San Luis Potosí                                        55847.0     54488.0   \n",
       "Sinaloa                                                57543.0     56267.0   \n",
       "Sonora                                                 53768.0     52825.0   \n",
       "Tabasco                                                48806.0     52478.0   \n",
       "Tamaulipas                                             63263.0     59933.0   \n",
       "Tlaxcala                                               28203.0     27060.0   \n",
       "Veracruz de Ignacio de la Llave                       164174.0    161019.0   \n",
       "Yucatán                                                36427.0     38588.0   \n",
       "Zacatecas                                              35625.0     35089.0   \n",
       "Extranjero                                              8911.0      9303.0   \n",
       "NaN                                                        NaN         NaN   \n",
       "\n",
       "                                                    2014 Total  2015 Total  \\\n",
       "Entidad federativa de residencia habitual de la...                           \n",
       "Total                                                2463420.0   2353596.0   \n",
       "Aguascalientes                                         27080.0     26486.0   \n",
       "Baja California                                        63183.0     63805.0   \n",
       "Baja California Sur                                    12667.0     12526.0   \n",
       "Campeche                                               19304.0     17862.0   \n",
       "Coahuila de Zaragoza                                   62966.0     62807.0   \n",
       "Colima                                                 13303.0     12344.0   \n",
       "Chiapas                                               164912.0    145526.0   \n",
       "Chihuahua                                              66110.0     63395.0   \n",
       "Ciudad de México                                      145609.0    135828.0   \n",
       "Durango                                                40337.0     39738.0   \n",
       "Guanajuato                                            114890.0    114269.0   \n",
       "Guerrero                                               90352.0     80336.0   \n",
       "Hidalgo                                                54108.0     54124.0   \n",
       "Jalisco                                               158592.0    151578.0   \n",
       "México                                                316088.0    303778.0   \n",
       "Michoacán de Ocampo                                   104370.0     98543.0   \n",
       "Morelos                                                36666.0     37089.0   \n",
       "Nayarit                                                22930.0     23663.0   \n",
       "Nuevo León                                             93225.0     93123.0   \n",
       "Oaxaca                                                 88364.0     85492.0   \n",
       "Puebla                                                150633.0    141121.0   \n",
       "Querétaro                                              42231.0     41904.0   \n",
       "Quintana Roo                                           30563.0     30841.0   \n",
       "San Luis Potosí                                        54112.0     52250.0   \n",
       "Sinaloa                                                55371.0     53461.0   \n",
       "Sonora                                                 51894.0     48925.0   \n",
       "Tabasco                                                52508.0     49785.0   \n",
       "Tamaulipas                                             62358.0     60263.0   \n",
       "Tlaxcala                                               25832.0     26166.0   \n",
       "Veracruz de Ignacio de la Llave                       162156.0    144842.0   \n",
       "Yucatán                                                37579.0     37117.0   \n",
       "Zacatecas                                              34031.0     33833.0   \n",
       "Extranjero                                              9096.0     10776.0   \n",
       "NaN                                                        NaN         NaN   \n",
       "\n",
       "                                                    2016 Total  2017 Total  \n",
       "Entidad federativa de residencia habitual de la...                          \n",
       "Total                                                2293708.0   2234039.0  \n",
       "Aguascalientes                                         26388.0     26955.0  \n",
       "Baja California                                        62608.0     61840.0  \n",
       "Baja California Sur                                    12545.0     12573.0  \n",
       "Campeche                                               17361.0     17034.0  \n",
       "Coahuila de Zaragoza                                   62011.0     58393.0  \n",
       "Colima                                                 11867.0     11756.0  \n",
       "Chiapas                                               140356.0    131638.0  \n",
       "Chihuahua                                              62313.0     63475.0  \n",
       "Ciudad de México                                      128227.0    119227.0  \n",
       "Durango                                                37801.0     37897.0  \n",
       "Guanajuato                                            117281.0    116531.0  \n",
       "Guerrero                                               87127.0     79244.0  \n",
       "Hidalgo                                                52629.0     50255.0  \n",
       "Jalisco                                               148377.0    151950.0  \n",
       "México                                                295635.0    286204.0  \n",
       "Michoacán de Ocampo                                    96217.0     95287.0  \n",
       "Morelos                                                35632.0     33159.0  \n",
       "Nayarit                                                21714.0     21688.0  \n",
       "Nuevo León                                             92978.0     89115.0  \n",
       "Oaxaca                                                 83564.0     78673.0  \n",
       "Puebla                                                132823.0    136271.0  \n",
       "Querétaro                                              39634.0     39400.0  \n",
       "Quintana Roo                                           30367.0     29442.0  \n",
       "San Luis Potosí                                        49688.0     48693.0  \n",
       "Sinaloa                                                53247.0     51850.0  \n",
       "Sonora                                                 46785.0     45951.0  \n",
       "Tabasco                                                50310.0     48725.0  \n",
       "Tamaulipas                                             58914.0     57282.0  \n",
       "Tlaxcala                                               25057.0     26589.0  \n",
       "Veracruz de Ignacio de la Llave                       137338.0    126623.0  \n",
       "Yucatán                                                35381.0     35017.0  \n",
       "Zacatecas                                              33677.0     34460.0  \n",
       "Extranjero                                              7856.0     10842.0  \n",
       "NaN                                                        NaN         NaN  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "natalidad = pd.read_csv('Natalidad_01.csv', skiprows=2, index_col='Entidad federativa de residencia habitual de la madre')\n",
    "natalidad"
   ]
  }
 ],
 "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
}