Created
          July 15, 2014 17:50 
        
      - 
      
- 
        Save restrepo/b060a33245da84000c0a to your computer and use it in GitHub Desktop. 
    Asesores Tesis Instituto de Física
  
        
  
    
      This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
      Learn more about bidirectional Unicode characters
    
  
  
    
  | { | |
| "metadata": { | |
| "name": "", | |
| "signature": "sha256:94039565962d0f8184f6e8b9e9d2f1c0ba1e0b4c7a3e8fefc78226ac661d5f65" | |
| }, | |
| "nbformat": 3, | |
| "nbformat_minor": 0, | |
| "worksheets": [ | |
| { | |
| "cells": [ | |
| { | |
| "cell_type": "heading", | |
| "level": 1, | |
| "metadata": {}, | |
| "source": [ | |
| "B\u00fasqueda en Indicadores del Instituto de F\u00edsica con Pandas" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "collapsed": false, | |
| "input": [ | |
| "cd /home/ipython/gssis/utilities/" | |
| ], | |
| "language": "python", | |
| "metadata": {}, | |
| "outputs": [ | |
| { | |
| "output_type": "stream", | |
| "stream": "stdout", | |
| "text": [ | |
| "/home/ipython/gssis/utilities\n" | |
| ] | |
| } | |
| ], | |
| "prompt_number": 1 | |
| }, | |
| { | |
| "cell_type": "code", | |
| "collapsed": false, | |
| "input": [ | |
| "from cvsreader import *\n", | |
| "#also import numpy as np\n", | |
| "pd.set_option('display.max_rows', 500)\n", | |
| "pd.set_option('display.max_columns', 500)\n", | |
| "Indicadores={'Estudiantes':'0AuLa_xuSIEvxdERYSGVQWDBTX1NCN19QMXVpb0lhWXc'}" | |
| ], | |
| "language": "python", | |
| "metadata": {}, | |
| "outputs": [], | |
| "prompt_number": 2 | |
| }, | |
| { | |
| "cell_type": "heading", | |
| "level": 2, | |
| "metadata": {}, | |
| "source": [ | |
| "Cargue datos" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "collapsed": false, | |
| "input": [ | |
| "directores={}\n", | |
| "df={'Doctorado':read_google_cvs(gss_key=Indicadores['Estudiantes'],gss_sheet=2,gss_query='select *')}\n", | |
| "df['Maestr\u00eda']=read_google_cvs(gss_key=Indicadores['Estudiantes'],gss_sheet=1,gss_query='select *')\n", | |
| "for tipo in ['Maestr\u00eda','Doctorado']:\n", | |
| " #Extract Asesores\n", | |
| " profesorestmp=np.sort(df[tipo]['ASESOR'].unique())\n", | |
| " profesorestmp=profesorestmp[profesorestmp!='']\n", | |
| " profesores=[]\n", | |
| " for p in profesorestmp:\n", | |
| " profesores=profesores+p.split(', ')\n", | |
| " \n", | |
| " profesores=np.unique(profesores)\n", | |
| " #get results\n", | |
| " Graduados=[df[tipo][np.logical_and(df[tipo]['ASESOR'].str.contains(p),\n", | |
| " df[tipo]['Estado']=='Graduado')].shape[0] \n", | |
| " for p in profesores]\n", | |
| " Activos=[df[tipo][np.logical_and(df[tipo]['ASESOR'].str.contains(p),\n", | |
| " df[tipo]['Estado']=='Activo')].shape[0] \n", | |
| " for p in profesores]\n", | |
| "\n", | |
| " directores[tipo]=pd.DataFrame({'Directores':profesores,'Estudiantes Activos':Activos,'Estudiantes Graduados':Graduados})" | |
| ], | |
| "language": "python", | |
| "metadata": {}, | |
| "outputs": [], | |
| "prompt_number": 3 | |
| }, | |
| { | |
| "cell_type": "heading", | |
| "level": 3, | |
| "metadata": {}, | |
| "source": [ | |
| "Resultados Asesores Maestr\u00eda" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "collapsed": false, | |
| "input": [ | |
| "directores['Maestr\u00eda']" | |
| ], | |
| "language": "python", | |
| "metadata": {}, | |
| "outputs": [ | |
| { | |
| "html": [ | |
| "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n", | |
| "<table border=\"1\" class=\"dataframe\">\n", | |
| " <thead>\n", | |
| " <tr style=\"text-align: right;\">\n", | |
| " <th></th>\n", | |
| " <th>Directores</th>\n", | |
| " <th>Estudiantes Activos</th>\n", | |
| " <th>Estudiantes Graduados</th>\n", | |
| " </tr>\n", | |
| " </thead>\n", | |
| " <tbody>\n", | |
| " <tr>\n", | |
| " <th>0 </th>\n", | |
| " <td> Adan Silvestre Gallego</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 2</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1 </th>\n", | |
| " <td> Alejandro Mira</td>\n", | |
| " <td> 1</td>\n", | |
| " <td> 0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2 </th>\n", | |
| " <td> Alfonso Cely</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 2</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>3 </th>\n", | |
| " <td> Alonso Sep\u00falveda Soto</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 3</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>4 </th>\n", | |
| " <td> Andrzej Kolodziejczyk</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>5 </th>\n", | |
| " <td> Antonio Enea Romano</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 2</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>6 </th>\n", | |
| " <td> Augusto Montes</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>7 </th>\n", | |
| " <td> Boris Rodriguez</td>\n", | |
| " <td> 1</td>\n", | |
| " <td> 0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>8 </th>\n", | |
| " <td> Boris Rodr\u00edguez R.</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 6</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>9 </th>\n", | |
| " <td> Carlos Duque</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 3</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>10</th>\n", | |
| " <td> C\u00e9sar Augusto Barrero Meneses</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 6</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>11</th>\n", | |
| " <td> Daniel Jaramillo </td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>12</th>\n", | |
| " <td> Diego Restrepo Q.</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 3</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>13</th>\n", | |
| " <td> Doris Amalia Girat\u00e1</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 4</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>14</th>\n", | |
| " <td> Edgar Rueda</td>\n", | |
| " <td> 1</td>\n", | |
| " <td> 0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>15</th>\n", | |
| " <td> Enrico Nardi</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 4</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>16</th>\n", | |
| " <td> Ernesto Reyes Gomez</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>17</th>\n", | |
| " <td> Francisco Fernando Medina</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 5</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>18</th>\n", | |
| " <td> Gladys Quintero</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 2</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>19</th>\n", | |
| " <td> Guillermo Pineda</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>20</th>\n", | |
| " <td> Huanchuan Wu</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 5</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>21</th>\n", | |
| " <td> Humberto M\u00fanera</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>22</th>\n", | |
| " <td> Ignacio Ferr\u00edn</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>23</th>\n", | |
| " <td> Jaime Alberto Osorio V\u00e9lez</td>\n", | |
| " <td> 2</td>\n", | |
| " <td> 2</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>24</th>\n", | |
| " <td> Jes\u00fas Mira Mart\u00ednez</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 2</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25</th>\n", | |
| " <td> Jhon Fredy Barrera</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>26</th>\n", | |
| " <td> Johans Restrepo C\u00e1rdenas</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 3</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>27</th>\n", | |
| " <td> John Fredy Barrera</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>28</th>\n", | |
| " <td> Jorge Mahecha G\u00f3mez</td>\n", | |
| " <td> 1</td>\n", | |
| " <td> 7</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>29</th>\n", | |
| " <td> Jorge Mario Osorio</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>30</th>\n", | |
| " <td> Jorge Tob\u00f3n</td>\n", | |
| " <td> 1</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>31</th>\n", | |
| " <td> Jorge Zuluaga Callejas</td>\n", | |
| " <td> 1</td>\n", | |
| " <td> 2</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>32</th>\n", | |
| " <td> Jos\u00e9 Carlos Moreno</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>33</th>\n", | |
| " <td> Jos\u00e9 Luis Sanz Vicario</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 3</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>34</th>\n", | |
| " <td> Jos\u00e9 Mario Trujillo</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 12</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>35</th>\n", | |
| " <td> Juan Carlos Mu\u00f1oz Cuartas</td>\n", | |
| " <td> 1</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>36</th>\n", | |
| " <td> Leonardo Pach\u00f3n</td>\n", | |
| " <td> 2</td>\n", | |
| " <td> 0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>37</th>\n", | |
| " <td> Lorenzo de la Torre</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 7</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>38</th>\n", | |
| " <td> Luis Castellanos Gomez</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>39</th>\n", | |
| " <td> Manuel Jos\u00e9 Paez Mej\u00eda</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>40</th>\n", | |
| " <td> Marco Antonio Giraldo</td>\n", | |
| " <td> 1</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>41</th>\n", | |
| " <td> Nelson Vanegas</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>42</th>\n", | |
| " <td> Orlando de Jes\u00fas Quintero Arias</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 2</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>43</th>\n", | |
| " <td> Oscar Arnache</td>\n", | |
| " <td> 1</td>\n", | |
| " <td> 0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>44</th>\n", | |
| " <td> Oscar Zapata</td>\n", | |
| " <td> 1</td>\n", | |
| " <td> 0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>45</th>\n", | |
| " <td> Patricio Valencia</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>46</th>\n", | |
| " <td> Peter Barlai</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 2</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>47</th>\n", | |
| " <td> Peter Barlai - Jos\u00e9 Mario Trujillo</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>48</th>\n", | |
| " <td> Ramiro Garc\u00eda Arias</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>49</th>\n", | |
| " <td> Regino Mart\u00ednez</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>50</th>\n", | |
| " <td> Roberto Mart\u00ednez</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 3</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>51</th>\n", | |
| " <td> Rodrigo Henao Henao</td>\n", | |
| " <td> 2</td>\n", | |
| " <td> 3</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>52</th>\n", | |
| " <td> Rom\u00e1n Eduardo Casta\u00f1eda Sep\u00falveda</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 2</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>53</th>\n", | |
| " <td> Segundo Lara</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 2</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>54</th>\n", | |
| " <td> Tom\u00e1s Delgado Paredes</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>55</th>\n", | |
| " <td> William Ponce G.</td>\n", | |
| " <td> 1</td>\n", | |
| " <td> 23</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>56</th>\n", | |
| " <td> \u00c1lvaro Luis Morales Aramburo</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " </tbody>\n", | |
| "</table>\n", | |
| "</div>" | |
| ], | |
| "metadata": {}, | |
| "output_type": "pyout", | |
| "prompt_number": 4, | |
| "text": [ | |
| " Directores Estudiantes Activos \\\n", | |
| "0 Adan Silvestre Gallego 0 \n", | |
| "1 Alejandro Mira 1 \n", | |
| "2 Alfonso Cely 0 \n", | |
| "3 Alonso Sep\u00falveda Soto 0 \n", | |
| "4 Andrzej Kolodziejczyk 0 \n", | |
| "5 Antonio Enea Romano 0 \n", | |
| "6 Augusto Montes 0 \n", | |
| "7 Boris Rodriguez 1 \n", | |
| "8 Boris Rodr\u00edguez R. 0 \n", | |
| "9 Carlos Duque 0 \n", | |
| "10 C\u00e9sar Augusto Barrero Meneses 0 \n", | |
| "11 Daniel Jaramillo 0 \n", | |
| "12 Diego Restrepo Q. 0 \n", | |
| "13 Doris Amalia Girat\u00e1 0 \n", | |
| "14 Edgar Rueda 1 \n", | |
| "15 Enrico Nardi 0 \n", | |
| "16 Ernesto Reyes Gomez 0 \n", | |
| "17 Francisco Fernando Medina 0 \n", | |
| "18 Gladys Quintero 0 \n", | |
| "19 Guillermo Pineda 0 \n", | |
| "20 Huanchuan Wu 0 \n", | |
| "21 Humberto M\u00fanera 0 \n", | |
| "22 Ignacio Ferr\u00edn 0 \n", | |
| "23 Jaime Alberto Osorio V\u00e9lez 2 \n", | |
| "24 Jes\u00fas Mira Mart\u00ednez 0 \n", | |
| "25 Jhon Fredy Barrera 0 \n", | |
| "26 Johans Restrepo C\u00e1rdenas 0 \n", | |
| "27 John Fredy Barrera 0 \n", | |
| "28 Jorge Mahecha G\u00f3mez 1 \n", | |
| "29 Jorge Mario Osorio 0 \n", | |
| "30 Jorge Tob\u00f3n 1 \n", | |
| "31 Jorge Zuluaga Callejas 1 \n", | |
| "32 Jos\u00e9 Carlos Moreno 0 \n", | |
| "33 Jos\u00e9 Luis Sanz Vicario 0 \n", | |
| "34 Jos\u00e9 Mario Trujillo 0 \n", | |
| "35 Juan Carlos Mu\u00f1oz Cuartas 1 \n", | |
| "36 Leonardo Pach\u00f3n 2 \n", | |
| "37 Lorenzo de la Torre 0 \n", | |
| "38 Luis Castellanos Gomez 0 \n", | |
| "39 Manuel Jos\u00e9 Paez Mej\u00eda 0 \n", | |
| "40 Marco Antonio Giraldo 1 \n", | |
| "41 Nelson Vanegas 0 \n", | |
| "42 Orlando de Jes\u00fas Quintero Arias 0 \n", | |
| "43 Oscar Arnache 1 \n", | |
| "44 Oscar Zapata 1 \n", | |
| "45 Patricio Valencia 0 \n", | |
| "46 Peter Barlai 0 \n", | |
| "47 Peter Barlai - Jos\u00e9 Mario Trujillo 0 \n", | |
| "48 Ramiro Garc\u00eda Arias 0 \n", | |
| "49 Regino Mart\u00ednez 0 \n", | |
| "50 Roberto Mart\u00ednez 0 \n", | |
| "51 Rodrigo Henao Henao 2 \n", | |
| "52 Rom\u00e1n Eduardo Casta\u00f1eda Sep\u00falveda 0 \n", | |
| "53 Segundo Lara 0 \n", | |
| "54 Tom\u00e1s Delgado Paredes 0 \n", | |
| "55 William Ponce G. 1 \n", | |
| "56 \u00c1lvaro Luis Morales Aramburo 0 \n", | |
| "\n", | |
| " Estudiantes Graduados \n", | |
| "0 2 \n", | |
| "1 0 \n", | |
| "2 2 \n", | |
| "3 3 \n", | |
| "4 1 \n", | |
| "5 2 \n", | |
| "6 1 \n", | |
| "7 0 \n", | |
| "8 6 \n", | |
| "9 3 \n", | |
| "10 6 \n", | |
| "11 1 \n", | |
| "12 3 \n", | |
| "13 4 \n", | |
| "14 0 \n", | |
| "15 4 \n", | |
| "16 1 \n", | |
| "17 5 \n", | |
| "18 2 \n", | |
| "19 1 \n", | |
| "20 5 \n", | |
| "21 1 \n", | |
| "22 0 \n", | |
| "23 2 \n", | |
| "24 2 \n", | |
| "25 1 \n", | |
| "26 3 \n", | |
| "27 1 \n", | |
| "28 7 \n", | |
| "29 1 \n", | |
| "30 1 \n", | |
| "31 2 \n", | |
| "32 1 \n", | |
| "33 3 \n", | |
| "34 12 \n", | |
| "35 1 \n", | |
| "36 0 \n", | |
| "37 7 \n", | |
| "38 1 \n", | |
| "39 1 \n", | |
| "40 1 \n", | |
| "41 1 \n", | |
| "42 2 \n", | |
| "43 0 \n", | |
| "44 0 \n", | |
| "45 0 \n", | |
| "46 2 \n", | |
| "47 1 \n", | |
| "48 1 \n", | |
| "49 1 \n", | |
| "50 3 \n", | |
| "51 3 \n", | |
| "52 2 \n", | |
| "53 2 \n", | |
| "54 1 \n", | |
| "55 23 \n", | |
| "56 1 " | |
| ] | |
| } | |
| ], | |
| "prompt_number": 4 | |
| }, | |
| { | |
| "cell_type": "heading", | |
| "level": 3, | |
| "metadata": {}, | |
| "source": [ | |
| "Resultados Asesores Doctorado" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "collapsed": false, | |
| "input": [ | |
| "directores['Doctorado']" | |
| ], | |
| "language": "python", | |
| "metadata": {}, | |
| "outputs": [ | |
| { | |
| "html": [ | |
| "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n", | |
| "<table border=\"1\" class=\"dataframe\">\n", | |
| " <thead>\n", | |
| " <tr style=\"text-align: right;\">\n", | |
| " <th></th>\n", | |
| " <th>Directores</th>\n", | |
| " <th>Estudiantes Activos</th>\n", | |
| " <th>Estudiantes Graduados</th>\n", | |
| " </tr>\n", | |
| " </thead>\n", | |
| " <tbody>\n", | |
| " <tr>\n", | |
| " <th>0 </th>\n", | |
| " <td> Alvaro Morales Aramburo</td>\n", | |
| " <td> 1</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1 </th>\n", | |
| " <td> Antonio Enea Romano</td>\n", | |
| " <td> 1</td>\n", | |
| " <td> 0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2 </th>\n", | |
| " <td> Augusto Gonz\u00e1lez</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 3</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>3 </th>\n", | |
| " <td> Boris Rodr\u00edguez R.</td>\n", | |
| " <td> 4</td>\n", | |
| " <td> 0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>4 </th>\n", | |
| " <td> Carlos Alberto Duque Echeverri</td>\n", | |
| " <td> 3</td>\n", | |
| " <td> 2</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>5 </th>\n", | |
| " <td> C\u00e9sar Augusto Barrero Meneses</td>\n", | |
| " <td> 1</td>\n", | |
| " <td> 2</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>6 </th>\n", | |
| " <td> Daniel Jaramillo</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>7 </th>\n", | |
| " <td> Diego Restrepo Q.</td>\n", | |
| " <td> 3</td>\n", | |
| " <td> 2</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>8 </th>\n", | |
| " <td> Doris Amalia Girat\u00e1</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>9 </th>\n", | |
| " <td> Edgar Rueda</td>\n", | |
| " <td> 1</td>\n", | |
| " <td> 0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>10</th>\n", | |
| " <td> Enrico Nardi</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 3</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>11</th>\n", | |
| " <td> Ernesto Reyes</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>12</th>\n", | |
| " <td> Gladys Quintero</td>\n", | |
| " <td> 1</td>\n", | |
| " <td> 0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>13</th>\n", | |
| " <td> Huanchuan Wu</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>14</th>\n", | |
| " <td> Johans Restrepo C\u00e1rdenas</td>\n", | |
| " <td> 3</td>\n", | |
| " <td> 2</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>15</th>\n", | |
| " <td> John Fredy Barrera</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>16</th>\n", | |
| " <td> Jorge Mahecha G\u00f3mez</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 2</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>17</th>\n", | |
| " <td> Jorge Mario Osorio Guillen</td>\n", | |
| " <td> 1</td>\n", | |
| " <td> 2</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>18</th>\n", | |
| " <td> Jorge Zuluaga C.</td>\n", | |
| " <td> 1</td>\n", | |
| " <td> 0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>19</th>\n", | |
| " <td> Jos\u00e9 Luis Sanz Vicario</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>20</th>\n", | |
| " <td> Juan Carlos Mu\u00f1oz Cuartas</td>\n", | |
| " <td> 1</td>\n", | |
| " <td> 0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>21</th>\n", | |
| " <td> Leonardo Pach\u00f3n</td>\n", | |
| " <td> 1</td>\n", | |
| " <td> 0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>22</th>\n", | |
| " <td> Oscar Zapata</td>\n", | |
| " <td> 1</td>\n", | |
| " <td> 0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>23</th>\n", | |
| " <td> Rodrigo Henao Henao</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 4</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>24</th>\n", | |
| " <td> Rom\u00e1n Eduardo Casta\u00f1eda Sep\u00falveda</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25</th>\n", | |
| " <td> William Ponce G.</td>\n", | |
| " <td> 0</td>\n", | |
| " <td> 4</td>\n", | |
| " </tr>\n", | |
| " </tbody>\n", | |
| "</table>\n", | |
| "</div>" | |
| ], | |
| "metadata": {}, | |
| "output_type": "pyout", | |
| "prompt_number": 157, | |
| "text": [ | |
| " Directores Estudiantes Activos \\\n", | |
| "0 Alvaro Morales Aramburo 1 \n", | |
| "1 Antonio Enea Romano 1 \n", | |
| "2 Augusto Gonz\u00e1lez 0 \n", | |
| "3 Boris Rodr\u00edguez R. 4 \n", | |
| "4 Carlos Alberto Duque Echeverri 3 \n", | |
| "5 C\u00e9sar Augusto Barrero Meneses 1 \n", | |
| "6 Daniel Jaramillo 0 \n", | |
| "7 Diego Restrepo Q. 3 \n", | |
| "8 Doris Amalia Girat\u00e1 0 \n", | |
| "9 Edgar Rueda 1 \n", | |
| "10 Enrico Nardi 0 \n", | |
| "11 Ernesto Reyes 0 \n", | |
| "12 Gladys Quintero 1 \n", | |
| "13 Huanchuan Wu 0 \n", | |
| "14 Johans Restrepo C\u00e1rdenas 3 \n", | |
| "15 John Fredy Barrera 0 \n", | |
| "16 Jorge Mahecha G\u00f3mez 0 \n", | |
| "17 Jorge Mario Osorio Guillen 1 \n", | |
| "18 Jorge Zuluaga C. 1 \n", | |
| "19 Jos\u00e9 Luis Sanz Vicario 0 \n", | |
| "20 Juan Carlos Mu\u00f1oz Cuartas 1 \n", | |
| "21 Leonardo Pach\u00f3n 1 \n", | |
| "22 Oscar Zapata 1 \n", | |
| "23 Rodrigo Henao Henao 0 \n", | |
| "24 Rom\u00e1n Eduardo Casta\u00f1eda Sep\u00falveda 0 \n", | |
| "25 William Ponce G. 0 \n", | |
| "\n", | |
| " Estudiantes Graduados \n", | |
| "0 1 \n", | |
| "1 0 \n", | |
| "2 3 \n", | |
| "3 0 \n", | |
| "4 2 \n", | |
| "5 2 \n", | |
| "6 1 \n", | |
| "7 2 \n", | |
| "8 1 \n", | |
| "9 0 \n", | |
| "10 3 \n", | |
| "11 1 \n", | |
| "12 0 \n", | |
| "13 1 \n", | |
| "14 2 \n", | |
| "15 0 \n", | |
| "16 2 \n", | |
| "17 2 \n", | |
| "18 0 \n", | |
| "19 1 \n", | |
| "20 0 \n", | |
| "21 0 \n", | |
| "22 0 \n", | |
| "23 4 \n", | |
| "24 1 \n", | |
| "25 4 " | |
| ] | |
| } | |
| ], | |
| "prompt_number": 157 | |
| } | |
| ], | |
| "metadata": {} | |
| } | |
| ] | |
| } | 
  
    Sign up for free
    to join this conversation on GitHub.
    Already have an account?
    Sign in to comment