Skip to content

Instantly share code, notes, and snippets.

@mgaitan

mgaitan/stafe.ipynb

Last active August 29, 2015 14:23
Show Gist options
  • Save mgaitan/15c6c96bc5670622f1dc to your computer and use it in GitHub Desktop.
Save mgaitan/15c6c96bc5670622f1dc to your computer and use it in GitHub Desktop.
Download ZIP
promedio de voto por mesa en cada seccion - elecciones santa fe
Display the source blob
Display the rendered blob
Raw
stafe.ipynb
{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Datos de http://elecciones.santafe.gov.ar/descargas#"
]
},
{
"cell_type": "code",
"execution_count": 1,
"metadata": {
"collapsed": false
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"--2015-06-15 20:18:51-- http://elecciones.santafe.gov.ar/bundles/escrutinio/descargas/csv.zip\n",
"Resolviendo elecciones.santafe.gov.ar (elecciones.santafe.gov.ar)... 200.12.192.183\n",
"Conectando con elecciones.santafe.gov.ar (elecciones.santafe.gov.ar)[200.12.192.183]:80... conectado.\n",
"Petición HTTP enviada, esperando respuesta... 200 OK\n",
"Longitud: 865821 (846K) [application/zip]\n",
"Grabando a: “csv.zip”\n",
"\n",
"100%[======================================>] 865.821 1,12MB/s en 0,7s \n",
"\n",
"2015-06-15 20:18:52 (1,12 MB/s) - “csv.zip” guardado [865821/865821]\n",
"\n"
]
}
],
"source": [
"!wget http://elecciones.santafe.gov.ar/bundles/escrutinio/descargas/csv.zip"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {
"collapsed": false
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Archive: csv.zip\n",
" inflating: desestimados.csv \n",
" inflating: pendientes.csv \n",
" inflating: computados.csv \n"
]
}
],
"source": [
"!unzip csv.zip"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"import pandas as pd"
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {
"collapsed": false
},
"outputs": [
{
"name": "stderr",
"output_type": "stream",
"text": [
"/home/tin/.virtualenvs/curso/lib/python3.4/site-packages/pandas/io/parsers.py:1164: DtypeWarning: Columns (6) have mixed types. Specify dtype option on import or set low_memory=False.\n",
" data = self._reader.read(nrows)\n"
]
}
],
"source": [
"computados = pd.read_csv('computados.csv')"
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/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>nroSeccion</th>\n",
" <th>nombreSeccion</th>\n",
" <th>nroCircuito</th>\n",
" <th>letraCircuito</th>\n",
" <th>nombreCircuito</th>\n",
" <th>nroCircuitoMadre</th>\n",
" <th>letraCircuitoMadre</th>\n",
" <th>letraMesa</th>\n",
" <th>nroMesa</th>\n",
" <th>nroPartido</th>\n",
" <th>nombrePartido</th>\n",
" <th>votosGob</th>\n",
" <th>votosDip</th>\n",
" <th>votosSen</th>\n",
" <th>votosInt</th>\n",
" <th>votosCon</th>\n",
" <th>votosCco</th>\n",
" <th>fechaIngreso</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>1</td>\n",
" <td>BELGRANO</td>\n",
" <td>402</td>\n",
" <td>NaN</td>\n",
" <td>ARMSTRONG</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>1</td>\n",
" <td>0001</td>\n",
" <td>FRENTE DE IZQUIERDA Y DE LOS TRABAJADORES</td>\n",
" <td>3</td>\n",
" <td>8</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>2015-06-14 22:27:49</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>1</td>\n",
" <td>BELGRANO</td>\n",
" <td>402</td>\n",
" <td>NaN</td>\n",
" <td>ARMSTRONG</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>1</td>\n",
" <td>0003</td>\n",
" <td>FRENTE SOCIAL Y POPULAR</td>\n",
" <td>0</td>\n",
" <td>3</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>2015-06-14 22:27:49</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>1</td>\n",
" <td>BELGRANO</td>\n",
" <td>402</td>\n",
" <td>NaN</td>\n",
" <td>ARMSTRONG</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>1</td>\n",
" <td>0004</td>\n",
" <td>FRENTE JUSTICIALISTA PARA LA VICTORIA</td>\n",
" <td>45</td>\n",
" <td>43</td>\n",
" <td>72</td>\n",
" <td>0</td>\n",
" <td>91</td>\n",
" <td>0</td>\n",
" <td>2015-06-14 22:27:49</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>1</td>\n",
" <td>BELGRANO</td>\n",
" <td>402</td>\n",
" <td>NaN</td>\n",
" <td>ARMSTRONG</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>1</td>\n",
" <td>0005</td>\n",
" <td>UNION PRO FEDERAL</td>\n",
" <td>122</td>\n",
" <td>34</td>\n",
" <td>43</td>\n",
" <td>0</td>\n",
" <td>4</td>\n",
" <td>0</td>\n",
" <td>2015-06-14 22:27:49</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>1</td>\n",
" <td>BELGRANO</td>\n",
" <td>402</td>\n",
" <td>NaN</td>\n",
" <td>ARMSTRONG</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>1</td>\n",
" <td>0006</td>\n",
" <td>FRENTE PROGRESISTA CIVICO Y SOCIAL</td>\n",
" <td>84</td>\n",
" <td>138</td>\n",
" <td>126</td>\n",
" <td>0</td>\n",
" <td>83</td>\n",
" <td>0</td>\n",
" <td>2015-06-14 22:27:49</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" nroSeccion nombreSeccion nroCircuito letraCircuito nombreCircuito \\\n",
"0 1 BELGRANO 402 NaN ARMSTRONG \n",
"1 1 BELGRANO 402 NaN ARMSTRONG \n",
"2 1 BELGRANO 402 NaN ARMSTRONG \n",
"3 1 BELGRANO 402 NaN ARMSTRONG \n",
"4 1 BELGRANO 402 NaN ARMSTRONG \n",
"\n",
" nroCircuitoMadre letraCircuitoMadre letraMesa nroMesa nroPartido \\\n",
"0 NaN NaN NaN 1 0001 \n",
"1 NaN NaN NaN 1 0003 \n",
"2 NaN NaN NaN 1 0004 \n",
"3 NaN NaN NaN 1 0005 \n",
"4 NaN NaN NaN 1 0006 \n",
"\n",
" nombrePartido votosGob votosDip votosSen \\\n",
"0 FRENTE DE IZQUIERDA Y DE LOS TRABAJADORES 3 8 0 \n",
"1 FRENTE SOCIAL Y POPULAR 0 3 0 \n",
"2 FRENTE JUSTICIALISTA PARA LA VICTORIA 45 43 72 \n",
"3 UNION PRO FEDERAL 122 34 43 \n",
"4 FRENTE PROGRESISTA CIVICO Y SOCIAL 84 138 126 \n",
"\n",
" votosInt votosCon votosCco fechaIngreso \n",
"0 0 0 0 2015-06-14 22:27:49 \n",
"1 0 0 0 2015-06-14 22:27:49 \n",
"2 0 91 0 2015-06-14 22:27:49 \n",
"3 0 4 0 2015-06-14 22:27:49 \n",
"4 0 83 0 2015-06-14 22:27:49 "
]
},
"execution_count": 6,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"computados.head()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"\n",
"### Votos promedio por seccion y partido \n",
"\n",
"sólo aquellos que tienen más de 5 votos promedio)"
]
},
{
"cell_type": "code",
"execution_count": 19,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/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></th>\n",
" <th>votosGob</th>\n",
" </tr>\n",
" <tr>\n",
" <th>nombreSeccion</th>\n",
" <th>nombrePartido</th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th rowspan=\"5\" valign=\"top\">9 DE JULIO</th>\n",
" <th>FRENTE JUSTICIALISTA PARA LA VICTORIA</th>\n",
" <td>69.859155</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE PROGRESISTA CIVICO Y SOCIAL</th>\n",
" <td>51.014085</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE RENOVADOR DE LA ESPERANZA</th>\n",
" <td>7.591549</td>\n",
" </tr>\n",
" <tr>\n",
" <th>UNION PRO FEDERAL</th>\n",
" <td>84.183099</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos en Blanco</th>\n",
" <td>18.281690</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"6\" valign=\"top\">BELGRANO</th>\n",
" <th>FRENTE JUSTICIALISTA PARA LA VICTORIA</th>\n",
" <td>60.518519</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE PROGRESISTA CIVICO Y SOCIAL</th>\n",
" <td>71.370370</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE RENOVADOR DE LA ESPERANZA</th>\n",
" <td>6.388889</td>\n",
" </tr>\n",
" <tr>\n",
" <th>UNION PRO FEDERAL</th>\n",
" <td>101.009259</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos Anulados</th>\n",
" <td>5.240741</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos en Blanco</th>\n",
" <td>11.814815</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"6\" valign=\"top\">CASEROS</th>\n",
" <th>FRENTE JUSTICIALISTA PARA LA VICTORIA</th>\n",
" <td>50.153488</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE PROGRESISTA CIVICO Y SOCIAL</th>\n",
" <td>72.748837</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE RENOVADOR DE LA ESPERANZA</th>\n",
" <td>9.093023</td>\n",
" </tr>\n",
" <tr>\n",
" <th>UNION PRO FEDERAL</th>\n",
" <td>91.911628</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos Anulados</th>\n",
" <td>6.967442</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos en Blanco</th>\n",
" <td>12.627907</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"6\" valign=\"top\">CASTELLANOS</th>\n",
" <th>FRENTE JUSTICIALISTA PARA LA VICTORIA</th>\n",
" <td>90.985542</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE PROGRESISTA CIVICO Y SOCIAL</th>\n",
" <td>57.987952</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE RENOVADOR DE LA ESPERANZA</th>\n",
" <td>6.669880</td>\n",
" </tr>\n",
" <tr>\n",
" <th>UNION PRO FEDERAL</th>\n",
" <td>70.127711</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos Anulados</th>\n",
" <td>6.067470</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos en Blanco</th>\n",
" <td>7.115663</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"6\" valign=\"top\">CONSTITUCIÓN</th>\n",
" <th>FRENTE JUSTICIALISTA PARA LA VICTORIA</th>\n",
" <td>67.569444</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE PROGRESISTA CIVICO Y SOCIAL</th>\n",
" <td>73.532407</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE RENOVADOR DE LA ESPERANZA</th>\n",
" <td>8.648148</td>\n",
" </tr>\n",
" <tr>\n",
" <th>UNION PRO FEDERAL</th>\n",
" <td>74.245370</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos Anulados</th>\n",
" <td>5.773148</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos en Blanco</th>\n",
" <td>11.504630</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"6\" valign=\"top\">GARAY</th>\n",
" <th>FRENTE JUSTICIALISTA PARA LA VICTORIA</th>\n",
" <td>73.037037</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE PROGRESISTA CIVICO Y SOCIAL</th>\n",
" <td>52.777778</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE RENOVADOR DE LA ESPERANZA</th>\n",
" <td>6.240741</td>\n",
" </tr>\n",
" <tr>\n",
" <th>UNION PRO FEDERAL</th>\n",
" <td>79.870370</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos Anulados</th>\n",
" <td>5.259259</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos en Blanco</th>\n",
" <td>15.055556</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"5\" valign=\"top\">GENERAL LÓPEZ</th>\n",
" <th>FRENTE JUSTICIALISTA PARA LA VICTORIA</th>\n",
" <td>55.075107</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE PROGRESISTA CIVICO Y SOCIAL</th>\n",
" <td>83.175966</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE RENOVADOR DE LA ESPERANZA</th>\n",
" <td>7.437768</td>\n",
" </tr>\n",
" <tr>\n",
" <th>UNION PRO FEDERAL</th>\n",
" <td>82.152361</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos en Blanco</th>\n",
" <td>10.976395</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"6\" valign=\"top\">GENERAL OBLIGADO</th>\n",
" <th>FRENTE JUSTICIALISTA PARA LA VICTORIA</th>\n",
" <td>73.019608</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE PROGRESISTA CIVICO Y SOCIAL</th>\n",
" <td>83.588235</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE RENOVADOR DE LA ESPERANZA</th>\n",
" <td>7.387255</td>\n",
" </tr>\n",
" <tr>\n",
" <th>UNION PRO FEDERAL</th>\n",
" <td>65.223039</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos Anulados</th>\n",
" <td>5.105392</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos en Blanco</th>\n",
" <td>11.526961</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"6\" valign=\"top\">IRIONDO</th>\n",
" <th>FRENTE JUSTICIALISTA PARA LA VICTORIA</th>\n",
" <td>59.910714</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE PROGRESISTA CIVICO Y SOCIAL</th>\n",
" <td>72.172619</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE RENOVADOR DE LA ESPERANZA</th>\n",
" <td>7.369048</td>\n",
" </tr>\n",
" <tr>\n",
" <th>UNION PRO FEDERAL</th>\n",
" <td>89.434524</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos Anulados</th>\n",
" <td>6.732143</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos en Blanco</th>\n",
" <td>11.172619</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"7\" valign=\"top\">LA CAPITAL</th>\n",
" <th>FRENTE DE IZQUIERDA Y DE LOS TRABAJADORES</th>\n",
" <td>5.849754</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE JUSTICIALISTA PARA LA VICTORIA</th>\n",
" <td>80.976601</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE PROGRESISTA CIVICO Y SOCIAL</th>\n",
" <td>69.038177</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE RENOVADOR DE LA ESPERANZA</th>\n",
" <td>11.842365</td>\n",
" </tr>\n",
" <tr>\n",
" <th>UNION PRO FEDERAL</th>\n",
" <td>72.028325</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos Anulados</th>\n",
" <td>9.296798</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos en Blanco</th>\n",
" <td>5.490148</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"6\" valign=\"top\">LA CAPITAL CAMPAÑA</th>\n",
" <th>FRENTE JUSTICIALISTA PARA LA VICTORIA</th>\n",
" <td>84.262658</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE PROGRESISTA CIVICO Y SOCIAL</th>\n",
" <td>57.829114</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE RENOVADOR DE LA ESPERANZA</th>\n",
" <td>9.231013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>UNION PRO FEDERAL</th>\n",
" <td>81.088608</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos Anulados</th>\n",
" <td>8.468354</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos en Blanco</th>\n",
" <td>6.797468</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"6\" valign=\"top\">LAS COLONIAS</th>\n",
" <th>FRENTE JUSTICIALISTA PARA LA VICTORIA</th>\n",
" <td>64.423664</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE PROGRESISTA CIVICO Y SOCIAL</th>\n",
" <td>68.610687</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE RENOVADOR DE LA ESPERANZA</th>\n",
" <td>8.274809</td>\n",
" </tr>\n",
" <tr>\n",
" <th>UNION PRO FEDERAL</th>\n",
" <td>84.377863</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos Anulados</th>\n",
" <td>5.267176</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos en Blanco</th>\n",
" <td>10.034351</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"6\" valign=\"top\">ROSARIO</th>\n",
" <th>FRENTE DE IZQUIERDA Y DE LOS TRABAJADORES</th>\n",
" <td>9.826156</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE JUSTICIALISTA PARA LA VICTORIA</th>\n",
" <td>51.103668</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE PROGRESISTA CIVICO Y SOCIAL</th>\n",
" <td>101.730463</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE RENOVADOR DE LA ESPERANZA</th>\n",
" <td>10.357257</td>\n",
" </tr>\n",
" <tr>\n",
" <th>UNION PRO FEDERAL</th>\n",
" <td>66.385965</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos Anulados</th>\n",
" <td>6.835726</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"7\" valign=\"top\">ROSARIO BARRIOS</th>\n",
" <th>FRENTE DE IZQUIERDA Y DE LOS TRABAJADORES</th>\n",
" <td>9.798171</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE JUSTICIALISTA PARA LA VICTORIA</th>\n",
" <td>70.072502</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE PROGRESISTA CIVICO Y SOCIAL</th>\n",
" <td>77.970607</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE RENOVADOR DE LA ESPERANZA</th>\n",
" <td>11.160026</td>\n",
" </tr>\n",
" <tr>\n",
" <th>UNION PRO FEDERAL</th>\n",
" <td>63.915741</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos Anulados</th>\n",
" <td>11.238406</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos en Blanco</th>\n",
" <td>6.130634</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"7\" valign=\"top\">ROSARIO CAMPAÑA</th>\n",
" <th>FRENTE DE IZQUIERDA Y DE LOS TRABAJADORES</th>\n",
" <td>6.252874</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE JUSTICIALISTA PARA LA VICTORIA</th>\n",
" <td>79.022989</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE PROGRESISTA CIVICO Y SOCIAL</th>\n",
" <td>71.533662</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE RENOVADOR DE LA ESPERANZA</th>\n",
" <td>8.522167</td>\n",
" </tr>\n",
" <tr>\n",
" <th>UNION PRO FEDERAL</th>\n",
" <td>76.100164</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos Anulados</th>\n",
" <td>9.591133</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos en Blanco</th>\n",
" <td>8.558292</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"4\" valign=\"top\">SAN CRISTOBAL</th>\n",
" <th>FRENTE JUSTICIALISTA PARA LA VICTORIA</th>\n",
" <td>69.158192</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE PROGRESISTA CIVICO Y SOCIAL</th>\n",
" <td>75.553672</td>\n",
" </tr>\n",
" <tr>\n",
" <th>UNION PRO FEDERAL</th>\n",
" <td>64.683616</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos en Blanco</th>\n",
" <td>13.045198</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"5\" valign=\"top\">SAN JAVIER</th>\n",
" <th>FRENTE JUSTICIALISTA PARA LA VICTORIA</th>\n",
" <td>79.886076</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE PROGRESISTA CIVICO Y SOCIAL</th>\n",
" <td>69.873418</td>\n",
" </tr>\n",
" <tr>\n",
" <th>UNION PRO FEDERAL</th>\n",
" <td>65.759494</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos Anulados</th>\n",
" <td>6.177215</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos en Blanco</th>\n",
" <td>16.746835</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"6\" valign=\"top\">SAN JERÓNIMO</th>\n",
" <th>FRENTE JUSTICIALISTA PARA LA VICTORIA</th>\n",
" <td>72.791262</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE PROGRESISTA CIVICO Y SOCIAL</th>\n",
" <td>62.140777</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE RENOVADOR DE LA ESPERANZA</th>\n",
" <td>6.577670</td>\n",
" </tr>\n",
" <tr>\n",
" <th>UNION PRO FEDERAL</th>\n",
" <td>79.509709</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos Anulados</th>\n",
" <td>6.165049</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos en Blanco</th>\n",
" <td>11.941748</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"5\" valign=\"top\">SAN JUSTO</th>\n",
" <th>FRENTE JUSTICIALISTA PARA LA VICTORIA</th>\n",
" <td>57.773913</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE PROGRESISTA CIVICO Y SOCIAL</th>\n",
" <td>61.939130</td>\n",
" </tr>\n",
" <tr>\n",
" <th>UNION PRO FEDERAL</th>\n",
" <td>80.600000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos Anulados</th>\n",
" <td>5.234783</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos en Blanco</th>\n",
" <td>8.991304</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"7\" valign=\"top\">SAN LORENZO</th>\n",
" <th>FRENTE DE IZQUIERDA Y DE LOS TRABAJADORES</th>\n",
" <td>5.508951</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE JUSTICIALISTA PARA LA VICTORIA</th>\n",
" <td>84.250639</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE PROGRESISTA CIVICO Y SOCIAL</th>\n",
" <td>72.913043</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE RENOVADOR DE LA ESPERANZA</th>\n",
" <td>7.312020</td>\n",
" </tr>\n",
" <tr>\n",
" <th>UNION PRO FEDERAL</th>\n",
" <td>76.074169</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos Anulados</th>\n",
" <td>7.797954</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos en Blanco</th>\n",
" <td>7.959079</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"6\" valign=\"top\">SAN MARTIN</th>\n",
" <th>FRENTE JUSTICIALISTA PARA LA VICTORIA</th>\n",
" <td>53.357576</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE PROGRESISTA CIVICO Y SOCIAL</th>\n",
" <td>61.927273</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE RENOVADOR DE LA ESPERANZA</th>\n",
" <td>6.072727</td>\n",
" </tr>\n",
" <tr>\n",
" <th>UNION PRO FEDERAL</th>\n",
" <td>100.236364</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos Anulados</th>\n",
" <td>6.278788</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos en Blanco</th>\n",
" <td>12.684848</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"5\" valign=\"top\">VERA</th>\n",
" <th>FRENTE JUSTICIALISTA PARA LA VICTORIA</th>\n",
" <td>69.725926</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE PROGRESISTA CIVICO Y SOCIAL</th>\n",
" <td>51.992593</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE RENOVADOR DE LA ESPERANZA</th>\n",
" <td>6.392593</td>\n",
" </tr>\n",
" <tr>\n",
" <th>UNION PRO FEDERAL</th>\n",
" <td>71.014815</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos en Blanco</th>\n",
" <td>13.888889</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" votosGob\n",
"nombreSeccion nombrePartido \n",
"9 DE JULIO FRENTE JUSTICIALISTA PARA LA VICTORIA 69.859155\n",
" FRENTE PROGRESISTA CIVICO Y SOCIAL 51.014085\n",
" FRENTE RENOVADOR DE LA ESPERANZA 7.591549\n",
" UNION PRO FEDERAL 84.183099\n",
" Votos en Blanco 18.281690\n",
"BELGRANO FRENTE JUSTICIALISTA PARA LA VICTORIA 60.518519\n",
" FRENTE PROGRESISTA CIVICO Y SOCIAL 71.370370\n",
" FRENTE RENOVADOR DE LA ESPERANZA 6.388889\n",
" UNION PRO FEDERAL 101.009259\n",
" Votos Anulados 5.240741\n",
" Votos en Blanco 11.814815\n",
"CASEROS FRENTE JUSTICIALISTA PARA LA VICTORIA 50.153488\n",
" FRENTE PROGRESISTA CIVICO Y SOCIAL 72.748837\n",
" FRENTE RENOVADOR DE LA ESPERANZA 9.093023\n",
" UNION PRO FEDERAL 91.911628\n",
" Votos Anulados 6.967442\n",
" Votos en Blanco 12.627907\n",
"CASTELLANOS FRENTE JUSTICIALISTA PARA LA VICTORIA 90.985542\n",
" FRENTE PROGRESISTA CIVICO Y SOCIAL 57.987952\n",
" FRENTE RENOVADOR DE LA ESPERANZA 6.669880\n",
" UNION PRO FEDERAL 70.127711\n",
" Votos Anulados 6.067470\n",
" Votos en Blanco 7.115663\n",
"CONSTITUCIÓN FRENTE JUSTICIALISTA PARA LA VICTORIA 67.569444\n",
" FRENTE PROGRESISTA CIVICO Y SOCIAL 73.532407\n",
" FRENTE RENOVADOR DE LA ESPERANZA 8.648148\n",
" UNION PRO FEDERAL 74.245370\n",
" Votos Anulados 5.773148\n",
" Votos en Blanco 11.504630\n",
"GARAY FRENTE JUSTICIALISTA PARA LA VICTORIA 73.037037\n",
" FRENTE PROGRESISTA CIVICO Y SOCIAL 52.777778\n",
" FRENTE RENOVADOR DE LA ESPERANZA 6.240741\n",
" UNION PRO FEDERAL 79.870370\n",
" Votos Anulados 5.259259\n",
" Votos en Blanco 15.055556\n",
"GENERAL LÓPEZ FRENTE JUSTICIALISTA PARA LA VICTORIA 55.075107\n",
" FRENTE PROGRESISTA CIVICO Y SOCIAL 83.175966\n",
" FRENTE RENOVADOR DE LA ESPERANZA 7.437768\n",
" UNION PRO FEDERAL 82.152361\n",
" Votos en Blanco 10.976395\n",
"GENERAL OBLIGADO FRENTE JUSTICIALISTA PARA LA VICTORIA 73.019608\n",
" FRENTE PROGRESISTA CIVICO Y SOCIAL 83.588235\n",
" FRENTE RENOVADOR DE LA ESPERANZA 7.387255\n",
" UNION PRO FEDERAL 65.223039\n",
" Votos Anulados 5.105392\n",
" Votos en Blanco 11.526961\n",
"IRIONDO FRENTE JUSTICIALISTA PARA LA VICTORIA 59.910714\n",
" FRENTE PROGRESISTA CIVICO Y SOCIAL 72.172619\n",
" FRENTE RENOVADOR DE LA ESPERANZA 7.369048\n",
" UNION PRO FEDERAL 89.434524\n",
" Votos Anulados 6.732143\n",
" Votos en Blanco 11.172619\n",
"LA CAPITAL FRENTE DE IZQUIERDA Y DE LOS TRABAJADORES 5.849754\n",
" FRENTE JUSTICIALISTA PARA LA VICTORIA 80.976601\n",
" FRENTE PROGRESISTA CIVICO Y SOCIAL 69.038177\n",
" FRENTE RENOVADOR DE LA ESPERANZA 11.842365\n",
" UNION PRO FEDERAL 72.028325\n",
" Votos Anulados 9.296798\n",
" Votos en Blanco 5.490148\n",
"LA CAPITAL CAMPAÑA FRENTE JUSTICIALISTA PARA LA VICTORIA 84.262658\n",
" FRENTE PROGRESISTA CIVICO Y SOCIAL 57.829114\n",
" FRENTE RENOVADOR DE LA ESPERANZA 9.231013\n",
" UNION PRO FEDERAL 81.088608\n",
" Votos Anulados 8.468354\n",
" Votos en Blanco 6.797468\n",
"LAS COLONIAS FRENTE JUSTICIALISTA PARA LA VICTORIA 64.423664\n",
" FRENTE PROGRESISTA CIVICO Y SOCIAL 68.610687\n",
" FRENTE RENOVADOR DE LA ESPERANZA 8.274809\n",
" UNION PRO FEDERAL 84.377863\n",
" Votos Anulados 5.267176\n",
" Votos en Blanco 10.034351\n",
"ROSARIO FRENTE DE IZQUIERDA Y DE LOS TRABAJADORES 9.826156\n",
" FRENTE JUSTICIALISTA PARA LA VICTORIA 51.103668\n",
" FRENTE PROGRESISTA CIVICO Y SOCIAL 101.730463\n",
" FRENTE RENOVADOR DE LA ESPERANZA 10.357257\n",
" UNION PRO FEDERAL 66.385965\n",
" Votos Anulados 6.835726\n",
"ROSARIO BARRIOS FRENTE DE IZQUIERDA Y DE LOS TRABAJADORES 9.798171\n",
" FRENTE JUSTICIALISTA PARA LA VICTORIA 70.072502\n",
" FRENTE PROGRESISTA CIVICO Y SOCIAL 77.970607\n",
" FRENTE RENOVADOR DE LA ESPERANZA 11.160026\n",
" UNION PRO FEDERAL 63.915741\n",
" Votos Anulados 11.238406\n",
" Votos en Blanco 6.130634\n",
"ROSARIO CAMPAÑA FRENTE DE IZQUIERDA Y DE LOS TRABAJADORES 6.252874\n",
" FRENTE JUSTICIALISTA PARA LA VICTORIA 79.022989\n",
" FRENTE PROGRESISTA CIVICO Y SOCIAL 71.533662\n",
" FRENTE RENOVADOR DE LA ESPERANZA 8.522167\n",
" UNION PRO FEDERAL 76.100164\n",
" Votos Anulados 9.591133\n",
" Votos en Blanco 8.558292\n",
"SAN CRISTOBAL FRENTE JUSTICIALISTA PARA LA VICTORIA 69.158192\n",
" FRENTE PROGRESISTA CIVICO Y SOCIAL 75.553672\n",
" UNION PRO FEDERAL 64.683616\n",
" Votos en Blanco 13.045198\n",
"SAN JAVIER FRENTE JUSTICIALISTA PARA LA VICTORIA 79.886076\n",
" FRENTE PROGRESISTA CIVICO Y SOCIAL 69.873418\n",
" UNION PRO FEDERAL 65.759494\n",
" Votos Anulados 6.177215\n",
" Votos en Blanco 16.746835\n",
"SAN JERÓNIMO FRENTE JUSTICIALISTA PARA LA VICTORIA 72.791262\n",
" FRENTE PROGRESISTA CIVICO Y SOCIAL 62.140777\n",
" FRENTE RENOVADOR DE LA ESPERANZA 6.577670\n",
" UNION PRO FEDERAL 79.509709\n",
" Votos Anulados 6.165049\n",
" Votos en Blanco 11.941748\n",
"SAN JUSTO FRENTE JUSTICIALISTA PARA LA VICTORIA 57.773913\n",
" FRENTE PROGRESISTA CIVICO Y SOCIAL 61.939130\n",
" UNION PRO FEDERAL 80.600000\n",
" Votos Anulados 5.234783\n",
" Votos en Blanco 8.991304\n",
"SAN LORENZO FRENTE DE IZQUIERDA Y DE LOS TRABAJADORES 5.508951\n",
" FRENTE JUSTICIALISTA PARA LA VICTORIA 84.250639\n",
" FRENTE PROGRESISTA CIVICO Y SOCIAL 72.913043\n",
" FRENTE RENOVADOR DE LA ESPERANZA 7.312020\n",
" UNION PRO FEDERAL 76.074169\n",
" Votos Anulados 7.797954\n",
" Votos en Blanco 7.959079\n",
"SAN MARTIN FRENTE JUSTICIALISTA PARA LA VICTORIA 53.357576\n",
" FRENTE PROGRESISTA CIVICO Y SOCIAL 61.927273\n",
" FRENTE RENOVADOR DE LA ESPERANZA 6.072727\n",
" UNION PRO FEDERAL 100.236364\n",
" Votos Anulados 6.278788\n",
" Votos en Blanco 12.684848\n",
"VERA FRENTE JUSTICIALISTA PARA LA VICTORIA 69.725926\n",
" FRENTE PROGRESISTA CIVICO Y SOCIAL 51.992593\n",
" FRENTE RENOVADOR DE LA ESPERANZA 6.392593\n",
" UNION PRO FEDERAL 71.014815\n",
" Votos en Blanco 13.888889"
]
},
"execution_count": 19,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"pd.set_option('display.max_rows', 2000)\n",
"promedio_gob_seccion = pd.pivot_table(computados, index=['nombreSeccion', 'nombrePartido'], values=['votosGob']) \n",
"promedio_gob_seccion[promedio_gob_seccion.votosGob > 5]"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Totales absolutos y porcentuales por partido "
]
},
{
"cell_type": "code",
"execution_count": 23,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"import numpy as np"
]
},
{
"cell_type": "code",
"execution_count": 87,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr>\n",
" <th></th>\n",
" <th>%</th>\n",
" <th>total</th>\n",
" </tr>\n",
" <tr>\n",
" <th></th>\n",
" <th>votosGob</th>\n",
" <th>votosGob</th>\n",
" </tr>\n",
" <tr>\n",
" <th>nombrePartido</th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>FRENTE PROGRESISTA CIVICO Y SOCIAL</th>\n",
" <td>30.683739</td>\n",
" <td>558352</td>\n",
" </tr>\n",
" <tr>\n",
" <th>UNION PRO FEDERAL</th>\n",
" <td>30.566797</td>\n",
" <td>556224</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE JUSTICIALISTA PARA LA VICTORIA</th>\n",
" <td>29.244161</td>\n",
" <td>532156</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE RENOVADOR DE LA ESPERANZA</th>\n",
" <td>3.679837</td>\n",
" <td>66962</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos en Blanco</th>\n",
" <td>3.468429</td>\n",
" <td>63115</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos Anulados</th>\n",
" <td>3.218003</td>\n",
" <td>58558</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRENTE DE IZQUIERDA Y DE LOS TRABAJADORES</th>\n",
" <td>2.329725</td>\n",
" <td>42394</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Dif. a det. en E.Definitivo</th>\n",
" <td>0.135352</td>\n",
" <td>2463</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos Impugnados</th>\n",
" <td>0.015607</td>\n",
" <td>284</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Votos Recurridos</th>\n",
" <td>0.011705</td>\n",
" <td>213</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" % total\n",
" votosGob votosGob\n",
"nombrePartido \n",
"FRENTE PROGRESISTA CIVICO Y SOCIAL 30.683739 558352\n",
"UNION PRO FEDERAL 30.566797 556224\n",
"FRENTE JUSTICIALISTA PARA LA VICTORIA 29.244161 532156\n",
"FRENTE RENOVADOR DE LA ESPERANZA 3.679837 66962\n",
"Votos en Blanco 3.468429 63115\n",
"Votos Anulados 3.218003 58558\n",
"FRENTE DE IZQUIERDA Y DE LOS TRABAJADORES 2.329725 42394\n",
"Dif. a det. en E.Definitivo 0.135352 2463\n",
"Votos Impugnados 0.015607 284\n",
"Votos Recurridos 0.011705 213"
]
},
"execution_count": 87,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"total_gob = pd.pivot_table(computados, index=['nombrePartido'], values=['votosGob'], aggfunc=np.sum).sort('votosGob', ascending=False)\n",
"no_pos = ['Votos en Blanco', 'Votos Anulados', 'Dif. a det. en E.Definitivo']\n",
"total_positivos = total_gob.votosGob.sum() - total_gob.ix[no_validos].votosGob.sum()\n",
"porcent = total_gob.apply(lambda x: 100*x/total_validos)\n",
"pd.concat({'total': total_gob, '%': porcent}, axis=1).ix[:10]"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"total_gob['nombrePartido'].isin"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Mesas desestimadas"
]
},
{
"cell_type": "code",
"execution_count": 58,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"desestimados = pd.read_csv('desestimados.csv')"
]
},
{
"cell_type": "code",
"execution_count": 59,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"codigoCentro\n",
"ROSARIO 176\n",
"SANTAFE 135\n",
"Name: nroMesa, dtype: int64"
]
},
"execution_count": 59,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"desestimados.groupby(\"codigoCentro\").nroMesa.count()"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": []
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"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.4.2"
}
},
"nbformat": 4,
"nbformat_minor": 0
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment