Skip to content

Instantly share code, notes, and snippets.

@danmusetoiu

danmusetoiu/alegeri.ipynb

Last active November 15, 2019 12:32
Show Gist options
  • Save danmusetoiu/f35e7d8e3b6dbb63599a2673341c4617 to your computer and use it in GitHub Desktop.
Save danmusetoiu/f35e7d8e3b6dbb63599a2673341c4617 to your computer and use it in GitHub Desktop.
Download ZIP
primul tur, just play around
Display the source blob
Display the rendered blob
Raw
alegeri.ipynb
{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Datele sunt cele oficiale, de la BEC, https://prezenta.bec.ro/prezidentiale10112019/romania-pv-final"
]
},
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Judet</th>\n",
" <th>UAT</th>\n",
" <th>Localitate</th>\n",
" <th>Siruta</th>\n",
" <th>Nr sectie de votare</th>\n",
" <th>Nume sectie de votare</th>\n",
" <th>Mediu</th>\n",
" <th>Votanti lista</th>\n",
" <th>LP</th>\n",
" <th>LS</th>\n",
" <th>...</th>\n",
" <th>Femei 111</th>\n",
" <th>Femei 112</th>\n",
" <th>Femei 113</th>\n",
" <th>Femei 114</th>\n",
" <th>Femei 115</th>\n",
" <th>Femei 116</th>\n",
" <th>Femei 117</th>\n",
" <th>Femei 118</th>\n",
" <th>Femei 119</th>\n",
" <th>Femei 120</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>AB</td>\n",
" <td>MUNICIPIUL ALBA IULIA</td>\n",
" <td>ALBA IULIA</td>\n",
" <td>1026.0</td>\n",
" <td>1</td>\n",
" <td>CENTRUL DE ZI PENTRU PERSOANE VÂRSTNICE</td>\n",
" <td>U</td>\n",
" <td>1618</td>\n",
" <td>880</td>\n",
" <td>50</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>AB</td>\n",
" <td>MUNICIPIUL ALBA IULIA</td>\n",
" <td>ALBA IULIA</td>\n",
" <td>1026.0</td>\n",
" <td>10</td>\n",
" <td>COLEGIUL NAŢIONAL „HOREA CLOŞCA ŞI CRIŞAN”</td>\n",
" <td>U</td>\n",
" <td>1440</td>\n",
" <td>678</td>\n",
" <td>117</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>AB</td>\n",
" <td>MUNICIPIUL SEBEŞ</td>\n",
" <td>SEBEŞ</td>\n",
" <td>1883.0</td>\n",
" <td>100</td>\n",
" <td>ŞCOALA GIMNAZIALĂ NR. 2 SEBEŞ</td>\n",
" <td>U</td>\n",
" <td>1417</td>\n",
" <td>757</td>\n",
" <td>66</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>AB</td>\n",
" <td>MUNICIPIUL SEBEŞ</td>\n",
" <td>SEBEŞ</td>\n",
" <td>1883.0</td>\n",
" <td>101</td>\n",
" <td>COLEGIUL NAŢIONAL ”LUCIAN BLAGA” SEBEŞ</td>\n",
" <td>U</td>\n",
" <td>1275</td>\n",
" <td>711</td>\n",
" <td>30</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>AB</td>\n",
" <td>MUNICIPIUL SEBEŞ</td>\n",
" <td>SEBEŞ</td>\n",
" <td>1883.0</td>\n",
" <td>102</td>\n",
" <td>COLEGIUL NAŢIONAL ”LUCIAN BLAGA” SEBEŞ</td>\n",
" <td>U</td>\n",
" <td>1384</td>\n",
" <td>747</td>\n",
" <td>80</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>5 rows × 229 columns</p>\n",
"</div>"
],
"text/plain": [
" Judet UAT Localitate Siruta Nr sectie de votare \\\n",
"0 AB MUNICIPIUL ALBA IULIA ALBA IULIA 1026.0 1 \n",
"1 AB MUNICIPIUL ALBA IULIA ALBA IULIA 1026.0 10 \n",
"2 AB MUNICIPIUL SEBEŞ SEBEŞ 1883.0 100 \n",
"3 AB MUNICIPIUL SEBEŞ SEBEŞ 1883.0 101 \n",
"4 AB MUNICIPIUL SEBEŞ SEBEŞ 1883.0 102 \n",
"\n",
" Nume sectie de votare Mediu Votanti lista LP LS \\\n",
"0 CENTRUL DE ZI PENTRU PERSOANE VÂRSTNICE U 1618 880 50 \n",
"1 COLEGIUL NAŢIONAL „HOREA CLOŞCA ŞI CRIŞAN” U 1440 678 117 \n",
"2 ŞCOALA GIMNAZIALĂ NR. 2 SEBEŞ U 1417 757 66 \n",
"3 COLEGIUL NAŢIONAL ”LUCIAN BLAGA” SEBEŞ U 1275 711 30 \n",
"4 COLEGIUL NAŢIONAL ”LUCIAN BLAGA” SEBEŞ U 1384 747 80 \n",
"\n",
" ... Femei 111 Femei 112 Femei 113 Femei 114 Femei 115 Femei 116 \\\n",
"0 ... 0 0 0 0 0 0 \n",
"1 ... 0 0 0 0 0 0 \n",
"2 ... 0 0 0 0 0 0 \n",
"3 ... 0 0 0 0 0 0 \n",
"4 ... 0 0 0 0 0 0 \n",
"\n",
" Femei 117 Femei 118 Femei 119 Femei 120 \n",
"0 0 0 0 0 \n",
"1 0 0 0 0 \n",
"2 0 0 0 0 \n",
"3 0 0 0 0 \n",
"4 0 0 0 0 \n",
"\n",
"[5 rows x 229 columns]"
]
},
"execution_count": 1,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"import pandas as pd\n",
"import numpy as np\n",
"import matplotlib.pyplot as plt\n",
"data = pd.read_csv('presence_now.csv')\n",
"data.head()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Prima observatie, cu ochiul liber: sunt trecuti alegatori cu varsta maxima 120 de ani :D <br>\n",
"Ceea ce ma duce cu gandul la urmatoarea intrebare: oare cati votanti de peste 100 de ani au fost?"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"________________________________________\n",
"Numar de Femei 100 : 16\n",
"________________________________________\n",
"Numar de Femei 101 : 3\n",
"________________________________________\n",
"Numar de Femei 102 : 3\n",
"________________________________________\n",
"Numar de Femei 103 : 3\n",
"________________________________________\n",
"Niciun exemplar din tronsonul Femei 104\n",
"________________________________________\n",
"Numar de Femei 105 : 1\n",
"________________________________________\n",
"Niciun exemplar din tronsonul Femei 106\n",
"________________________________________\n",
"Niciun exemplar din tronsonul Femei 107\n",
"________________________________________\n",
"Niciun exemplar din tronsonul Femei 108\n",
"________________________________________\n",
"Niciun exemplar din tronsonul Femei 109\n",
"________________________________________\n",
"Niciun exemplar din tronsonul Femei 110\n",
"________________________________________\n",
"Niciun exemplar din tronsonul Femei 111\n",
"________________________________________\n",
"Niciun exemplar din tronsonul Femei 112\n",
"________________________________________\n",
"Niciun exemplar din tronsonul Femei 113\n",
"________________________________________\n",
"Niciun exemplar din tronsonul Femei 114\n",
"________________________________________\n",
"Niciun exemplar din tronsonul Femei 115\n",
"________________________________________\n",
"Niciun exemplar din tronsonul Femei 116\n",
"________________________________________\n",
"Niciun exemplar din tronsonul Femei 117\n",
"________________________________________\n",
"Niciun exemplar din tronsonul Femei 118\n",
"________________________________________\n",
"Niciun exemplar din tronsonul Femei 119\n",
"________________________________________\n",
"Niciun exemplar din tronsonul Femei 120\n",
"********************\n",
"Numar total de femei peste 100 de ani: 26\n",
"________________________________________\n",
"Numar de Barbati 100 : 17\n",
"________________________________________\n",
"Numar de Barbati 101 : 6\n",
"________________________________________\n",
"Numar de Barbati 102 : 2\n",
"________________________________________\n",
"Numar de Barbati 103 : 4\n",
"________________________________________\n",
"Numar de Barbati 104 : 3\n",
"________________________________________\n",
"Niciun exemplar din tronsonul Barbati 105\n",
"________________________________________\n",
"Niciun exemplar din tronsonul Barbati 106\n",
"________________________________________\n",
"Niciun exemplar din tronsonul Barbati 107\n",
"________________________________________\n",
"Niciun exemplar din tronsonul Barbati 108\n",
"________________________________________\n",
"Niciun exemplar din tronsonul Barbati 109\n",
"________________________________________\n",
"Niciun exemplar din tronsonul Barbati 110\n",
"________________________________________\n",
"Numar de Barbati 111 : 1\n",
"________________________________________\n",
"Niciun exemplar din tronsonul Barbati 112\n",
"________________________________________\n",
"Niciun exemplar din tronsonul Barbati 113\n",
"________________________________________\n",
"Niciun exemplar din tronsonul Barbati 114\n",
"________________________________________\n",
"Niciun exemplar din tronsonul Barbati 115\n",
"________________________________________\n",
"Niciun exemplar din tronsonul Barbati 116\n",
"________________________________________\n",
"Niciun exemplar din tronsonul Barbati 117\n",
"________________________________________\n",
"Niciun exemplar din tronsonul Barbati 118\n",
"________________________________________\n",
"Niciun exemplar din tronsonul Barbati 119\n",
"________________________________________\n",
"Numar de Barbati 120 : 1\n",
"********************\n",
"Numar total de barbati peste 100 de ani: 34\n"
]
}
],
"source": [
"# in primul rand, sa-i selectam pe toti\n",
"femei_peste_100 = [item for item in data.columns if 'Femei' in item][-21:]\n",
"barbati_peste_100 = [item for item in data.columns if 'Barbati' in item ][-21:]\n",
"total_peste_100 = femei_peste_100 + barbati_peste_100\n",
"\n",
"# apoi sa iteram si sa printam rezultatele\n",
"\n",
"numar_femei_peste_100 = []\n",
"for item in femei_peste_100:\n",
" try:\n",
" print( 20 * '__')\n",
" print('Numar de {0} : {1}'.format(item, data[item].value_counts()[1]))\n",
" numar_femei_peste_100.append(data[item].value_counts()[1])\n",
" \n",
" except KeyError:\n",
" \n",
" print('Niciun exemplar din tronsonul {}'.format(item))\n",
"print(20*'*')\n",
"print('Numar total de femei peste 100 de ani: {}'.format(sum(numar_femei_peste_100)))\n",
"\n",
"numar_barbati_peste_100 = []\n",
"for item in barbati_peste_100:\n",
" try:\n",
" \n",
" print( 20 * '__')\n",
" print('Numar de {0} : {1}'.format(item, data[item].value_counts()[1]))\n",
" numar_barbati_peste_100.append(data[item].value_counts()[1])\n",
" \n",
" except KeyError:\n",
" print('Niciun exemplar din tronsonul {}'.format(item))\n",
" \n",
"print(20*'*')\n",
"print('Numar total de barbati peste 100 de ani: {}'.format(sum(numar_barbati_peste_100)))"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Hai sa si vedem:"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {},
"outputs": [
{
"data": {
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAV0AAAD5CAYAAACEcub7AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjEsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy8QZhcZAAAd1klEQVR4nO3debgcVb3u8e8PCGNCR0nAw5QWGQS5DAcRBC8goh4oEAijzDOIx8jg8bQoUAxy2ovAZZLxIvM8QyODDF7CIENIDMhoKEBmCBQJBDKt88eqfehsdpK9k+pe1dXv53n6yU537+q3s5M3q1dVrTLnHCIi0h4LhA4gItJNVLoiIm2k0hURaSOVrohIG6l0RUTaSKUrItJGKl0ZMDP7k5ntHTpHJzCzfcxsdIDXPdfMjm7368rcqXQLxszuMrPj+7h/WzN7y8wWmsv35/qP3MxiM7u8+T7n3JbOuUvyeo1+ZKiamZvbe5/LNs43s+fNbKaZ7dPH44dnf76pmV1kZov0ev37zewTM3vOzLaY1xzt4pw7xDl3Qugc8kUq3eK5GNjTzKzX/XsCVzjnprc/UimMAw4FxvR+wMx+CNSA7wFVYCXguKanXAU8BSwF/Bq43syGtzivlJVzTrcC3YDFgBTYpOm+LwGfAmtnv68AlwLvAq8Av8H/B7p69rwZwGTgw+z5Eb40PgJeA+KmbVcBB+wNvAq8B/w6e+zfgKnAtGx747L7HwAOmE3+GLgeuAaYhC+5tZseXxa4Icv+MjCq6bFvAU9kOd8GTs3ufzXLODm7fTu7fz/gWeAD4C5gRD/+fEcD+/S670rgpKbffw94K/t6VeAzYEjT4w8Ch8xm+0sBt2bv4THgBGB00+NfB+4BJgLPAzvPIeu+2fubBEwADm56bDPgn8CRwDvAm8C+TY9fDJwY+u+zbl+8aaRbMM65KcC1wF5Nd+8MPOecG5f9/kx88a4EbJo9d1/n3LPAIcAjzrnBzrmh2fM/zp4zFF/APzGz7Xq99HeA1fCFc4yZre6cuxM4Cbgm297a/Xwb2wLXAV/GF9rNZjbIzBYAbsOPOpfLXuuwbKQJcDpwunNuSeBr2Z8DwCbZr0OzHI9k+Y8CRgLD8UV4VT/z9faNLFOPccAyZrZU9tgE59ykXo9/YzbbOhv/H9+/4P9T2K/nATNbAl+4VwJLAz8G/mBms9vWO8DWwJL4Aj7NzP616fGv4P8eLAfsD5xtZl+a67uVoFS6xXQJsJOZLZb9fq/sPsxsQWAX4FfOuUnOuQQ4BT/90Cfn3APOufHOuZnOub/hy2nTXk87zjk3JSv2cUB/C7YvTzrnrnfOTQNOBRYFNgTWB4Y75453zk11zk0ALgB2zb5vGrCymQ1zzk12zj06h9c4GPgv59yzzk+5nASsY2Yj5iHvYPynix49Xw/p47Gex4f03kj2s9kBOMY597Fz7mmyn1tmayBxzv3ROTfdOTcGP+rfsa9QzrmGc+4fzvsLcDfwv5ueMg043jk3zTl3B/5TwGr9e8sSikq3gJxzo/Efv7c1s5XwZXVl9vAwYGH8tEKPV/CjnT6Z2QbZjqB3zSzFj4aH9XraW01ff4Ivm3n1Ws8XzrmZ+I/BywIjgGXN7MOeG360ukz29P3xH+efM7PHzWzrObzGCOD0pu1MBIw5/DnMwWT8aLJHz9eT+nis5/FJfNFwYCGa3j+z/pxGABv0ev+740esX2BmW5rZo2Y2MXvuVsz6c3vfzTrHP78/N2kDlW5xXYof4e4J3O2cezu7/z38CKd5RLci8Hr2dV/Lxl2Jn2dcwTlXAc7FF1R/zMsydCv0fJFNKSwPvIEvo5edc0ObbkOcc1sBOOdedM79GP/R+3f4HVZLzCbDa/g5zuZtLeace3ge8j7DrCP7tYG3nXPvZ4+tZGZDej3+TB/beReY3vz+8T+b5sx/6ZV5sHPuJ703lB09cQPwe2CZbKroDvr/c5OCUukW16XAFsCBNH1Edc7NwM91/tbMhmQfp48Aeg7rehtY3swWbtrWEGCic+5TM/sWsNsAcrwNVLPy7K/1zGxkdojXYfgdUY/idyx9ZGb/aWaLmdmCZramma0PYGZ7mNnwbHT8YbatGfgym4mfw+5xLvCrnvlQM6uY2U6zC2RmC5vZovjSGmRmiza9p0uB/c1sjWxO9Df4HVE4514AxgLHZt+zPbAWvhBnkf1sbgRiM1vczNbA76DscTuwqpntmc1xDzKz9c1s9T4iLwwskr336Wa2JfCD2b0/6Rwq3YLK5mofBpbAj1Kb/Qy/c2wCfm/8lcBF2WP34Udhb5nZe9l9hwLHm9kk4Bg+30HVH9dlv75vZl843Go2bsHPO3+AH6mPzOYdZwDbAOvgj1x4D7gQvzMI/NESz5jZZPxOtV2dc5865z4Bfgs8lH0s39A5dxN+NHy1mX0EPA1sOYdMdwNTgI2A87OvNwHIdhj+H+B+/HTAK8CxTd+7K/DN7P3UgR2dc+/O5nX+Hf8R/y18cf+x54FsZ9wPsu29kT3nd/hynUX23FH4n9UH+P8oe/89kA5kzmkRc8mPmcXAys65PUJnESkijXRFRNpIpSsi0kaaXhARaSONdEVE2kilKyLSRipdkT6Y2QwzG9t0q7bwtX5kZrVWbV+KRXO6In0ws8nOOZ1SK7nTSFekn7Iz6E7O1oX4m5kdnN2/mZn9xcyuNbMXzKxuZrub2WNmNt7MvpY9b7iZ3ZB9/+NmtnF2/z5mdlbI9ybtM88r8YuU3GJmNjb7+mXn3Pb4BXlS59z62doID5nZ3dlz1savZzwRf6bghc65b5nZz/FnEB6GP8vuNOfcaDNbEb8GcF+nAEuJqXRF+jbFObdOr/t+AKxlZj1LMVaAVfALvT/unHsTwMz+gT/tGGA88N3s6y2ANZouCrJkr4V0pAuodEX6z4CfOefumuVOs83wi/r0mNn0+5l8/u9sAfxVL6b0+v6WhJVi0pyuSP/dhb/qxiAAM1s1W3qyv+7GL4hD9v29R9LSBVS6Iv13IfB3YIyZPQ2cx8A+LY4CvpnthPs7fjF56TI6ZExEpI000hURaSOVrohIG6l0RUTaSIeMSeFUa41h+OuhrQgMxV/+ZjD+0kWDm26LAJ/ir4I7Jfu1+fYBn19+57WkHs1o6xsR6YN2pEkQ1VpjSfx1x1bHF+xKwFezW+9LnudhOv6KyUnT7TlgDPBiUo/0D0HaQqUrLVetNRYA1gA2bLqtTnGmtz4CnsJfrfhh4OGkHr0TNpKUlUpXWqJaa6wGbAt8H/gWrRm9ttJLwD34K/Del9SjqYHzSEmodCUX2Wh2A3zRbgesFjZRribhzya7FWgk9ej9wHmkg6l0ZZ5lRft9YEdgG2CZsInaYgbwCHAjcFlSj94LnEc6jEpXBqxaaywDHAAcCIwIHCekz4CbgPOSevRA4CzSIVS60i/VWsOAzfHrBWwLDAqbqHBeAM4HLtHoV+ZEpStzVK01huBHtAcDqwaO0wk+A24AfpfUo7+FDiPFo9KVPlVrjQrw8+z25cBxOpHDz/sel9Sj8aHDSHGodGUW2cj2COBw/JURZP44/Mj3uKQePR06jISn0hUAqrXGosChwK+AYYHjlJHKVwCVrgDVWmNH4FRghdBZusBM4FzgqKQepaHDSPupdLtYtdYYAZwNRKGzdKG3gSOTenRF6CDSXirdLlStNRbCz9seCyweOE63uw84NKlHz4cOIu2h0u0y1VpjQ/y1vdYKnUX+x1TgZOC3ST2aMrcnS2dT6XaJbEfZ7/E7y3TN72J6EdglqUdPhQ4irVOUpfWkhbIVvx4DfooKt8hWAR6p1hqjQgeR1tFIt+SqtcYewDn4Ky1I57gV2DepRxNDB5F8qXRLqlprLAacBewXOovMs9eA3ZJ6NDp0EMmPSreEqrXG6sC1wJqhs8h8m4E/yuQkXVKoHFS6JVOtNbYGrsZfxFHK40r8dIOuYNHhtCOtRKq1xoHAzahwy2g34K5qrTE0dBCZPyrdkqjWGsfh13NdMHQWaZnNgIeyMwmlQ2l6ocNlZ5edh3aYdZM3ga2TejQmdBAZOJVuB6vWGkvgd5htFTqLtN1kYOekHv0pdBAZGJVuh8oWGb8bf3lz6U7TgJFJPbo9dBDpP5VuB6rWGovjC3fj0FkkuM+AbZJ6dE/oINI/2pHWYaq1xiLALahwxVsEuLlaa2wSOoj0j0q3g2Q7za4FtgidRQplceD2aq2xQeggMncq3Q5RrTUWAC4FfhQ6ixTSEODOaq2xbuggMmcq3c5xLvDj0CGk0IYCd2engUtBqXQ7QLXWOAY4MHQO6QjD8FMNS4UOIn3T0QsFV601tsHvONM6uDIQfwG+n9SjaaGDyKw00i2waq2xKnAZKlwZuE2BP4QOIV+k0i2oaq0xBL94TSV0FulYB1RrjYNDh5BZaXqhgKq1hgE3AtuFziIdbyqwSVKP/ho6iHga6RbTb1DhSj4WBq6v1hrDQwcRT6VbMNVaY3PguNA5pFSWBy4IHUI8TS8USLXWGAyMB6qBo0g57ZXUo8tCh+h2GukWy+9R4UrrnFGtNZYLHaLbqXQLolprbAFoT7O00lDgwtAhup1KtwCyw8P+X+gc0hX+LbuWngSi0i2GU4AVQ4eQrnGKrrMWjko3sGqt8X20roK01xD8RUwlAB29EFC2Pu544Ouhs0hXipJ6dEfoEN1GI92wDkCFK+GcXK01FgwdotuodAPJdp7FoXNIV1sDTW21nUo3nF8Cy4QOIV3vuGwAIG2i0g2gWmssCxwROocIsDTwq9AhuolKN4wT8RcTFCmCw6u1hg5ZbBOVbptVa401gb1D5xBpsihwbOgQ3UKl235HoT93KZ49qrXGV0KH6Ab6x99G1VqjCuwcOodIHxYGfhY6RDdQ6bbXkYCOi5SiOqRaaywROkTZqXTb65/Au6FDiMzGl4H9QocoO50G3GbVWmNRYE/gcGD1wHFEepsArJrUoxmhg5SVRrptltSjT5N6dAHwDWAr4M+BI4k0WwkYGTpEmWmkWwDVWmMt/Mh3N/wODZGQHkrq0XdChygrlW6BZIfs/BQ4BBgWOI50t5WSevRy6BBlpOmFAknq0VtJPToav6D5IcBzgSNJ99otdICy0ki3wKq1huHnfY8ANg8cR7rLs0k9WiN0iDJS6XaIaq2xNr58d0XzvtIe6yb1aGzoEGWj6YUOkdSjcUk92ht/ifaTgIlhE0kX2D10gDLSSLfV4sog4FDgEuL0w7w2W601FscvnHMYsGpe2xVp8jqwYlKPZoYOUiYa6bbejsD/BV4jrpxBXFkpj40m9eiTpB6dg7/cz4+AB/LYrkiT5YBNQocoG410Wy2uPAx8u+memcAtwKnE6eg8X6paa6yLn/fdBRiU57ala52c1KNfhg5RJirdVoor/wo8OYdnPAacBlxPnE7P62WzK1P8DDgY+FJe25WuNCapR+uFDlEmKt1WiisXAfv245mvAmcCFxCnaV4vn60YtQ/wc2CVvLYrXWUmMDypR9pxmxOVbqvElcXxK4oN5LI8k4CLgNOJ09zOBqrWGgsA2+CnHjRHJwO1Y1KPbggdoixUuq0SV0YC8/oXdQZwM37e9+H8QkG11lgPX747oXlf6Z9zknp0aOgQZaHSbZW4chmwRw5behQ/73sDcZrbcnvVWmN5/LzvQcDQvLYrpfRCUo9WCx2iLFS6reCPzX2HfMvsFeAM4ELi9KO8NprN++6Hn/f9Wl7bldJZIalH/wwdogx0nG5rfJf8R48jgFOAfxJXTiOuVPPYaFKPPk7q0Zn4EyxGAg/msV0pnU1DBygLlW5rbN/CbQ/Bn4X2EnHlOuLKhnlsNKlHM5N6dFNSjzYB1geuAnI7jE063lqhA5SFphfyFlcWwJ8+2c7LWT8KnArcmPO87wrAKOBAoJLXdqUj3ZHUoyh0iDJQ6eYtrmwEPBTo1RM+n/edlNdGq7XGYGB//LzvV/ParnSUV5N6NCJ0iDJQ6eYtrpwM/CJwio+AC4AziNNX89podrzv9vhDzjbKa7vSMZZM6lFu/5l3K5Vu3uLKSxTnKIDp+GOFTyFOH89zw9VaYwN8+e4ALJjntqWwNkrq0SOhQ3Q6lW6e4soK+FN6i+gh/LzvzcRpbkv1VWuNEfh53wOAJfParhTSQdmVrGU+6OiFfBV5YZCN8aPeF4kro4grg/PYaFKPXknq0ZHA8viRb5LHdqWQ1gwdoAxUuvkqcun2WAk4Hb++78nZ6Hy+JfVoUlKPTgNWBnbGH1Eh5bJy6ABloOmFPMWVO4AtQ8cYoOnA9fh53yfy3HC11tgQP/odieZ9y+CJpB6tHzpEp1Pp5imuvA0sHTrGfBiNn/e9Jed53yp+3nd/NO/byXTYWA5UunmJK8sDr4WOkZN/4KcgLiJOP85ro9VaY0n8DrdR+NOapbN8mtSjxUKH6HQq3bzElW3xyzGWyQd8frzv63lttFprLIg/1OwIYIO8tittUUnqUW4LLnUjlW5e4srxwNGhY7TINOA6/LzvmDw3XK01NsKX73Zo3rcTrJLUo5dCh+hkKt28xJUGsFXoGG3w//HzvrflPO/7VfxpxvvhF/WRYto4qUe5LqzfbXTIWH464XCxPGyCn0Z5jrjy0+yyRPMtqUcvJ/XoMGAF4D8oz/x42XTyjuJC0Eg3D3FlCH69g240ETgfOJM4fSOvjVZrjYWAHfFTDzpMqTj2SurRZaFDdDKVbh7iysrAi6FjBDYNuAZ/Xben8txwtdb4Dr58t0WfzkLbN6lHF4cO0cn0Fzgf+sjlL3K5BzCGuHI/cWUb4orlseGkHo1O6tFI/GXkzwQm57FdmScLhQ7Q6VS6+VDpzmoz4Fb8vO9Pcpz3nZDUo1H4ed//BHTNrvbTESbzSdMLeYgrB+LnNaVv7wPnAWcRp2/mueFsjV9pk6Qe5XbESrdS6eYhrvwaODF0jA4wFbgaP+87LnQYkRA0SsiHphf6Z2FgL2AsceVe4kqU17yvSKdQ6eZDpTtwmwO3A38nrhxMXNE5/dIVVLr5UOnOu68D5wKvEldOIK4sEzqQSCupdPMxPHSAEhgG/AZ4hbjyR+LK/wodSKQVtCMtD3HlVfxhTJKvPwOnAX8iTvUXVUpBI10psi2ABvAMceUg4sqioQOJzC+NdPMQVxK0KHc7vIuf/z2bOH07dBiReaHSzUNcmQB8NXSMLjINmBQ6RJc5kTg9LXSIMtB51PnQWTrtNQj4cugQXUZdkRPN6eZjRugAIi02LXSAslDp5uOT0AFEWmx66ABlodLNh5YalLLTSDcnKt185HaZcpGC0sAiJyrdfKh0pey0dnFOVLr56Nbro0n3UOnmRKWbD125VsrModLNjUo3Hy+FDiDSQu8Rp5+FDlEWKt18/CN0AJEW0ie5HKl086GRrpSZSjdHKt08+MVXdEiNlJXmc3Ok0s2PphikrDTSzZFKNz8qXSkrlW6OVLr50byulFUSOkCZqHTzo5GulNE04KnQIcpEpZsfjXSljMYSp1NChygTlW5+nkTr6kr5PBw6QNmodPMSpyn6GCblo9LNmUo3Xw+EDiCSs4dCBygblW6+7g8dQCRHrxGnr4cOUTYq3Xw9iC5rIuWhqYUWUOnmKU4n4XeoiZSBSrcFVLr50xSDlIVKtwVUuvlT6UoZTALGhg5RRird/D2Erpwqne9m4lT7J1pApZu3OP0Y+GvoGCLz6arQAcpKpdsa14cOIDIf3gPuCR2irFS6rXEFmmKQznWDphZaR6XbCnH6HnB76Bgi80hTCy2k0m2di0MHEJkHr+NP8pEWUem2zh3AO6FDiAzQtcTpzNAhykyl2yp+Tuzy0DFEBkhTCy2m0m2ti0MHEBmAl4jTx0OHKDuVbivF6XhgTOgYIv10SegA3UCl23oXhw4g0g+fAOeEDtENVLqtdwX+L7RIkf2ROH0/dIhuoNJttTidCJwfOobIHMwETg0doluodNvjZOCz0CFEZuMm4nRC6BDdQqXbDnH6BnBR6Bgis3FS6ADdRKXbPnW0HoMUz23EqY6waSOVbrvE6atotCvFE4cO0G1Uuu11PDAldAiRjEa5Aah028nP7Z4ROoYI/oiFY0OH6EYq3farAx+EDiFd71zi9KnQIbqRSrfd4vRD4L9Cx5Cu9iZwVOgQ3UqlG8Zp6EqrEs7hxGkaOkS3Mudc6AzdKa6sCzwGLBQ6inSVO4nTLUOH6GYa6Ybi59PqoWNIV5kCHBo6RLdT6YZ1AvBM6BDSNU4gTl8OHaLbqXRDitOpwL7AjNBRpPSeAX4fOoSodMPzK/WfEjqGlJoDDiZOdRp6Aah0i+FY4PnQIaS0ziJOHwodQjyVbhHE6afAfvizhETy9DBwZOgQ8jmVblHE6cPoaAbJ11vATppWKBaVbrEcDdwaOoSUwjR84b4ROojMSqVbJHE6E9gd+FvoKNLxfkGcjg4dQr5IZ6QVUVwZgT9bbenQUaQjXU6c7hk6hPRNI90iitNXgJHA1NBRpOOMAw4KHUJmT6VbVP4QH/3jkYH4ABhJnGqh/AJT6RZZnF6Cv5KwyNxMBXbRVX2LT6VbfDXgttAhpNCmAjsQp/eEDiJzpx1pnSCuDAbuBDYOHUUKp+fQsFtCB5H+0Ui3E8TpZOCHwH2ho0ihTAd2VeF2FpVup4jTj4EI+FPoKFII04HdiNMbQweRgVHpdhK/RsN2wE2ho0hQM4A9iNPrQgeRgVPpdhq/Bu/OwFWho0gQM4G9iNNrQgeReaPS7URxOh3YA7godBRpqxnAvsTplaGDyLzT0QudLK4YcCbw09BRpOU+wh+He2foIDJ/VLplEFeOw69QZqGjSEu8DGxNnP49dBCZfyrdsogr2wOXAENCR5FcjQa2J07fCx1E8qE53bKI05uADYAXQkeR3JwHfE+FWy4a6ZZNXFkSuBTYNnQUmWdTgJ9ka29Iyah0yyqujMIvlrNw6CgyIBPwK4WNCx1EWkPTC2UVp2cAGwEvhY4i/XYZ8E0VbrlppFt2cWUIcDagKwkUVwIcTJzeHTqItJ5Kt1vElc2Bs4DVQ0eR/zEDOAM4OltbQ7qASrebxJVBwBH4Y3qXCJym240DDiBOnwgdRNpLpduN4soKwGnADqGjdKFPgeOBk7PTuaXLqHS7WVz5If404lVCR+kS9+Pnbl8MHUTCUel2u7iyMPAfwK+BxQKnKasHgeOI03tDB5HwVLrixZWvAD8HDgGGBk5TFvcDxxOnD4QOIsWh0pVZ+UPMDgIOA5YPnKZT/Rlftg+GDiLFo9KVvvkjHXYDfgGsGThNp7gTX7aPhA4ixaXSlTnza/ZuBfwS2CRwmiKaBFwPnEOcPh46jBSfSlf6L66sjz+zbQdg2cBpQpoO3IU/bfdW4nRK4DzSQVS6MnBxZQH8ug47ATvSPQX8OL5oryZO3w0dRjqTSlfmj59+2BhfwDsAy4UNlLuXgSuAy4nT50OHkc6n0pX8+ALeCBiJn/9dB1goaKaBexd/qNe9wH3EqVZpk1ypdKV14soS+KtZfAdfxusBw4JmmpXDX2njUeAR4GHgaeJU/yikZVS60l5+3Yd1s9s6wAr4OeGlgQVb9Krv45dPbL69CDxOnE5s0WuK9EmlK8Xgd84tDfxL023Zpq8XwS+FOD37dUYfv5+OP4TrFZoLNk4nt++NiMyZSldEpI10uR4RkTZS6ZaQmc0ws7FmNs7MxpjZRvOwjQF9JDez7cxsjabfH29mWwz0dUXKTtMLJWRmk51zg7Ovfwgc5ZzbtJ/fa4ABH/Vso5/fdzFwu3Pu+nmILNI1NNItvyWBDwDMbLCZ3ZuNfseb2bbZ/VUze9bM/gCMwR9RgJmdkj33XjMbnt13oJk9no2ibzCzxbOR9I+Ak7MR9tfM7GIz2zHIOxYpMI10S8jMZgDjgUXxe/43d849aWYLAYs75z4ys2H441NXAUYAE4CNnHOPZttwwB7OuSvM7Bhgaefcv5vZUs6597PnnAi87Zw7s/dIVyNfkb512tlC0j9TnHPrAJjZt4FLzWxN/LTBSWa2CTATf8ruMtn3vNJTuJmZwDXZ15cDN2Zfr5mV7VBgMH7hFxHpJ5VuyTnnHslGtcPxSzQOB9Zzzk0zswQ/GgaY2yXAez4SXQxs55wbZ2b7AJvlnVmkzDSnW3Jm9nX8mV7vAxXgnaxwv4ufVpidBfAriIFfzHx09vUQ4E0zGwTs3vT8SdljIjIHGumW02JmNjb72oC9nXMzzOwK4DYzewIYCzw3h218DHzDzJ4EUmCX7P6jgb/iz/oaz+dFezVwgZmN4vOyFpFetCNNRKSNNL0gItJGKl0RkTZS6YqItJFKV0SkjVS6IiJtpNIVEWkjla6ISBupdEVE2ui/Ab8vmAwcpBsRAAAAAElFTkSuQmCC\n",
"text/plain": [
"<Figure size 432x288 with 1 Axes>"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"explode = (0, 0.1)\n",
"\n",
"fig1, ax1 = plt.subplots()\n",
"ax1.pie([sum(numar_femei_peste_100), sum(numar_barbati_peste_100)], explode=explode, labels=\n",
" ['Femei', 'Barbati'])\n",
"ax1.axis('equal')\n",
"plt.title('Votanti peste 100 de ani')\n",
"plt.show()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Pare ca a votat si un barbat de 120 de ani! <br>\n",
"Sa vedem unde!"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"[('SIBIU', 'ŞCOALA GIMNAZIALĂ NR. 8')]"
]
},
"execution_count": 4,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"locul_faptei = [(data.Localitate[i], data['Nume sectie de votare'][i]) \n",
" for i in range(len(data)) if data['Barbati 120'][i] == 1]\n",
"locul_faptei"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Ii urez pe aceasta cale multa sanatate! <br>\n",
"Pe bune, chiar e de admirat!"
]
}
],
"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.7.4"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment