Kernel: Python 3 (Ubuntu Linux)
In [1]:
In [2]:
Presença com o crime organizado
In [3]:
/usr/local/lib/python3.5/dist-packages/matplotlib/figure.py:459: UserWarning: matplotlib is currently using a non-GUI backend, so cannot show the figure
"matplotlib is currently using a non-GUI backend, "
In [4]:
/usr/local/lib/python3.5/dist-packages/matplotlib/figure.py:459: UserWarning: matplotlib is currently using a non-GUI backend, so cannot show the figure
"matplotlib is currently using a non-GUI backend, "
In [5]:
In [6]:
In [7]:
/usr/local/lib/python3.5/dist-packages/matplotlib/figure.py:459: UserWarning: matplotlib is currently using a non-GUI backend, so cannot show the figure
"matplotlib is currently using a non-GUI backend, "
In [8]:
OrderedDict([('efetivo', 0.16666666666666663)])
/usr/local/lib/python3.5/dist-packages/matplotlib/figure.py:459: UserWarning: matplotlib is currently using a non-GUI backend, so cannot show the figure
"matplotlib is currently using a non-GUI backend, "
Número de eleitores
In [9]:
/usr/local/lib/python3.5/dist-packages/matplotlib/figure.py:459: UserWarning: matplotlib is currently using a non-GUI backend, so cannot show the figure
"matplotlib is currently using a non-GUI backend, "
In [10]:
/usr/local/lib/python3.5/dist-packages/matplotlib/figure.py:459: UserWarning: matplotlib is currently using a non-GUI backend, so cannot show the figure
"matplotlib is currently using a non-GUI backend, "
In [11]:
In [12]:
In [13]:
/usr/local/lib/python3.5/dist-packages/matplotlib/figure.py:459: UserWarning: matplotlib is currently using a non-GUI backend, so cannot show the figure
"matplotlib is currently using a non-GUI backend, "
In [14]:
OrderedDict([('efetivo', 0.6000000000000001)])
/usr/local/lib/python3.5/dist-packages/matplotlib/figure.py:459: UserWarning: matplotlib is currently using a non-GUI backend, so cannot show the figure
"matplotlib is currently using a non-GUI backend, "
Eleitores indígenas
In [15]:
/usr/local/lib/python3.5/dist-packages/matplotlib/figure.py:459: UserWarning: matplotlib is currently using a non-GUI backend, so cannot show the figure
"matplotlib is currently using a non-GUI backend, "
In [16]:
/usr/local/lib/python3.5/dist-packages/matplotlib/figure.py:459: UserWarning: matplotlib is currently using a non-GUI backend, so cannot show the figure
"matplotlib is currently using a non-GUI backend, "
In [17]:
In [18]:
In [19]:
/usr/local/lib/python3.5/dist-packages/matplotlib/figure.py:459: UserWarning: matplotlib is currently using a non-GUI backend, so cannot show the figure
"matplotlib is currently using a non-GUI backend, "
In [20]:
OrderedDict([('efetivo', 0.34444444444444444)])
/usr/local/lib/python3.5/dist-packages/matplotlib/figure.py:459: UserWarning: matplotlib is currently using a non-GUI backend, so cannot show the figure
"matplotlib is currently using a non-GUI backend, "
Modelo final
In [21]:
/usr/local/lib/python3.5/dist-packages/matplotlib/figure.py:459: UserWarning: matplotlib is currently using a non-GUI backend, so cannot show the figure
"matplotlib is currently using a non-GUI backend, "
In [22]:
/usr/local/lib/python3.5/dist-packages/matplotlib/figure.py:459: UserWarning: matplotlib is currently using a non-GUI backend, so cannot show the figure
"matplotlib is currently using a non-GUI backend, "
In [23]:
/usr/local/lib/python3.5/dist-packages/matplotlib/figure.py:459: UserWarning: matplotlib is currently using a non-GUI backend, so cannot show the figure
"matplotlib is currently using a non-GUI backend, "
In [24]:
/usr/local/lib/python3.5/dist-packages/matplotlib/figure.py:459: UserWarning: matplotlib is currently using a non-GUI backend, so cannot show the figure
"matplotlib is currently using a non-GUI backend, "
In [25]:
In [26]:
In [27]:
/usr/local/lib/python3.5/dist-packages/matplotlib/figure.py:459: UserWarning: matplotlib is currently using a non-GUI backend, so cannot show the figure
"matplotlib is currently using a non-GUI backend, "
In [28]:
0.16666666666666663
In [29]:
0.6000000000000001
In [30]:
0.34444444444444444
In [31]:
OrderedDict([('efetivo', 0.6)])
/usr/local/lib/python3.5/dist-packages/matplotlib/figure.py:459: UserWarning: matplotlib is currently using a non-GUI backend, so cannot show the figure
"matplotlib is currently using a non-GUI backend, "
WARNING: 1 intermediate output message was discarded.
WARNING: 1 intermediate output message was discarded.
Função para entrada e processamento dos dados
In [32]:
In [33]:
0.18511609712110966
Cálculo da planilha
In [34]:
In [35]:
In [36]:
longitude | latitude | COD_LOCALIDADE_TSE | NOM_LOCALIDADE_1 | NOM_BAIRRO | NUM_LOCAL | NOM_LOCAL | DES_ENDERECO | CODIGO | LQTD_SECOES | LQTD_APTOS | INDIGENAS | CV | GRUPOS VMP | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | -56.104889 | -15.589418 | 90670 | CUIABÁ | QUILOMBO | 2593 | COLÉGIO MAXI | RUA ESTEVÃO DE MENDONÇA, 1000 | 1906702593 | 16 | 6309 | 0 | 0 | 192 |
1 | -56.098308 | -15.592559 | 90670 | CUIABÁ | CENTRO | 1015 | INSTITUTO FEDERAL DE EDUCAÇÃO, CIÊNCIA E TECNO... | RUA ZULMIRA CANAVARROS, 95 | 1906701015 | 24 | 4916 | 0 | 0 | 192 |
2 | -56.081131 | -15.579708 | 90670 | CUIABÁ | ALVORADA | 2488 | ESCOLA MUNICIPAL CÂNDIDO MARIANO DA SILVA RONDON | RUA PIRATININGA, 101 | 1906702488 | 12 | 4571 | 0 | 100 | 201 |
3 | -56.113951 | -15.613200 | 90670 | CUIABÁ | PORTO | 2844 | ESCOLA ESTADUAL JOSÉ BARNABÉ DE MESQUITA | RUA BARÃO DE MELGACO, 945 | 1906702844 | 13 | 4471 | 0 | 100 | 193 |
4 | -56.128743 | -15.618736 | 90670 | CUIABÁ | COOPHAMIL | 2810 | ESCOLA MUNICIPAL DE EDUCAÇÃO BÁSICA PROFESSOR ... | RUA JOÃO PAULO DOS SANTOS, S/N | 1906702810 | 12 | 4308 | 0 | 0 | 222 |
In [37]:
CODIGO | CV | LQTD_APTOS | INDIGENAS | |
---|---|---|---|---|
0 | 1906702593 | 0 | 6309 | 0 |
1 | 1906701015 | 0 | 4916 | 0 |
2 | 1906702488 | 100 | 4571 | 0 |
3 | 1906702844 | 100 | 4471 | 0 |
4 | 1906702810 | 0 | 4308 | 0 |
In [38]:
CODIGO | CV | LQTD_APTOS | INDIGENAS | |
---|---|---|---|---|
1440 | 57908241112 | 0 | 118 | 118 |
1441 | 57898341228 | 0 | 110 | 0 |
1442 | 57908241104 | 0 | 110 | 0 |
1443 | 57908241082 | 0 | 95 | 95 |
1444 | 57898341171 | 0 | 58 | 0 |
In [39]:
In [40]:
longitude | latitude | COD_LOCALIDADE_TSE | NOM_LOCALIDADE_1 | NOM_BAIRRO | NUM_LOCAL | NOM_LOCAL | DES_ENDERECO | CODIGO | LQTD_SECOES | LQTD_APTOS | INDIGENAS | CV | GRUPOS VMP | EFETIVO | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
348 | -54.922355 | -15.809898 | 90719 | DOM AQUINO | CENTRO | 1023 | E. M. PROF. JULIANA NAZARÉ DE OLIVEIRA | AVENIDA PRESIDENTE VARGAS S/N | 12907191023 | 6 | 1289 | 0 | 0 | 282 | 1.5 |
349 | -54.922355 | -15.809898 | 90719 | DOM AQUINO | VILA ESPORTIVA | 1082 | ESCOLA ESTADUAL VINÍCIUS DE MORAES | AVENIDA JOÃO FURTADO DE MENDONÇA | 12907191082 | 4 | 1277 | 0 | 0 | 282 | 1.5 |
In [41]:
longitude | latitude | COD_LOCALIDADE_TSE | NOM_LOCALIDADE_1 | NOM_BAIRRO | NUM_LOCAL | NOM_LOCAL | DES_ENDERECO | CODIGO | LQTD_SECOES | LQTD_APTOS | INDIGENAS | CV | GRUPOS VMP | EFETIVO | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | -56.104889 | -15.589418 | 90670 | CUIABÁ | QUILOMBO | 2593 | COLÉGIO MAXI | RUA ESTEVÃO DE MENDONÇA, 1000 | 1906702593 | 16 | 6309 | 0 | 0 | 192 | 2.0 |
1 | -56.098308 | -15.592559 | 90670 | CUIABÁ | CENTRO | 1015 | INSTITUTO FEDERAL DE EDUCAÇÃO, CIÊNCIA E TECNO... | RUA ZULMIRA CANAVARROS, 95 | 1906701015 | 24 | 4916 | 0 | 0 | 192 | 2.0 |
2 | -56.081131 | -15.579708 | 90670 | CUIABÁ | ALVORADA | 2488 | ESCOLA MUNICIPAL CÂNDIDO MARIANO DA SILVA RONDON | RUA PIRATININGA, 101 | 1906702488 | 12 | 4571 | 0 | 100 | 201 | 2.0 |
3 | -56.113951 | -15.613200 | 90670 | CUIABÁ | PORTO | 2844 | ESCOLA ESTADUAL JOSÉ BARNABÉ DE MESQUITA | RUA BARÃO DE MELGACO, 945 | 1906702844 | 13 | 4471 | 0 | 100 | 193 | 2.0 |
4 | -56.128743 | -15.618736 | 90670 | CUIABÁ | COOPHAMIL | 2810 | ESCOLA MUNICIPAL DE EDUCAÇÃO BÁSICA PROFESSOR ... | RUA JOÃO PAULO DOS SANTOS, S/N | 1906702810 | 12 | 4308 | 0 | 0 | 222 | 2.0 |
In [42]: