In [1]:
import pandas as pd
In [2]:
path = '../dane/robocze/'
In [3]:
def_kom_2015 = pd.read_csv(path+'def_kom_2015.csv', sep=';', index_col=0)
def_kom_2019 = pd.read_csv(path+'def_kom_2019.csv', sep=';', index_col=0)
kom_okr_2015 = pd.read_csv(path+'kom_okr_2015.csv', sep=';', index_col=0)
kom_okr_2019 = pd.read_csv(path+'kom_okr_2019.csv', sep=';', index_col=0)
prez20t1 = pd.read_csv(path+'prez20t1_powiat.csv', sep=';')
prez20t2 = pd.read_csv(path+'prez20t2_powiat.csv', sep=';')
In [4]:
tlumaczenie = {str(nr): skrot for nr, skrot in def_kom_2015['Skrót'].to_dict().items()}
sejm2015 = kom_okr_2015.rename(columns=tlumaczenie).fillna(0)
In [5]:
tlumaczenie = {str(nr): skrot for nr, skrot in def_kom_2019['Skrót'].to_dict().items()}
sejm2019 = kom_okr_2019.rename(columns=tlumaczenie).fillna(0)
In [6]:
sejm2015
Out[6]:
PiS PO Razem KORWiN PSL Lewica Kukiz Nowoczesna Bezpartyjni Stonoga RSRP ZŚ Samoobrona Braun KNP MN OP
Nr okręgu
1 127370 90060 13003 15427 13886 37298 34229 25506 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
2 72929 76424 7984 10075 7448 20517 20634 15544 2540.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
3 163323 159582 22059 27341 13604 31932 45726 55756 0.0 2779.0 0.0 0.0 0.0 1269.0 0.0 0.0 0.0
4 113024 110948 14062 17002 22701 37583 29080 27334 0.0 2543.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
5 121703 93432 13227 14134 24476 39003 30159 23563 0.0 2041.0 0.0 0.0 772.0 0.0 0.0 0.0 0.0
6 232014 80892 13395 24376 37733 29172 45448 22158 0.0 0.0 599.0 0.0 580.0 1353.0 0.0 0.0 0.0
7 163122 41823 8116 14835 38689 24161 35567 12745 0.0 0.0 0.0 0.0 628.0 0.0 0.0 0.0 0.0
8 97877 97676 13825 17274 17743 34695 30284 34586 0.0 2258.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
9 107350 112333 16627 17163 9710 37615 25992 32274 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
10 134134 44173 8747 11160 21364 21352 28808 15983 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
11 147623 78314 13077 15171 29044 30256 32973 19681 0.0 1905.0 0.0 0.0 712.0 989.0 0.0 0.0 0.0
12 133213 55454 8840 12089 8226 14473 23551 15731 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
13 209607 133558 21053 34446 14644 34643 39379 52822 0.0 0.0 0.0 0.0 0.0 1372.0 1244.0 0.0 0.0
14 188010 43309 6627 13379 12929 7924 24318 11468 0.0 1606.0 0.0 0.0 0.0 0.0 891.0 0.0 0.0
15 151623 42887 7082 13766 23552 9933 28005 13233 0.0 0.0 0.0 0.0 0.0 906.0 654.0 0.0 0.0
16 131431 49353 10062 12214 31994 24440 25257 15451 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
17 130758 48332 7203 10770 25933 13258 23149 13233 0.0 2050.0 0.0 0.0 0.0 0.0 656.0 0.0 0.0
18 191733 50858 9964 16332 38396 16327 31378 17386 1045.0 0.0 582.0 0.0 0.0 1239.0 0.0 0.0 0.0
19 327342 301672 60663 67700 7882 93666 84937 146629 0.0 0.0 2760.0 0.0 0.0 0.0 0.0 0.0 1964.0
20 190355 123227 18895 23586 18666 27774 35418 49098 0.0 3597.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
21 93926 88731 10202 13346 12464 22841 42533 24152 1772.0 0.0 0.0 0.0 0.0 751.0 0.0 27530.0 0.0
22 174900 44971 7595 13984 23805 14893 29919 12981 2289.0 1528.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
23 284642 66516 11623 25163 23667 22409 47071 21106 0.0 2919.0 0.0 0.0 0.0 1363.0 778.0 0.0 0.0
24 197575 72894 11258 20297 35116 32015 39509 23361 0.0 2088.0 0.0 0.0 626.0 0.0 629.0 0.0 0.0
25 126466 148305 16992 21366 12904 28168 30536 39184 0.0 3210.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
26 145698 156147 18918 20677 15064 30973 37410 38344 0.0 3477.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
27 136330 79506 12557 15788 11533 22122 31570 27882 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
28 84773 49580 8625 10111 11799 26305 27521 15942 0.0 1378.0 0.0 0.0 0.0 600.0 0.0 0.0 0.0
29 89584 85130 12181 14949 7342 21163 35793 26122 0.0 0.0 0.0 0.0 0.0 1403.0 0.0 0.0 0.0
30 114799 70188 9669 13136 5197 17201 32794 18341 0.0 0.0 0.0 7928.0 0.0 710.0 0.0 0.0 0.0
31 135367 116658 16786 22803 4064 27837 41344 35591 0.0 0.0 0.0 10740.0 0.0 0.0 0.0 0.0 0.0
32 84410 72755 12652 13682 6687 39774 29161 25522 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
33 200652 80866 13106 19395 44574 36880 44115 23360 2344.0 1792.0 0.0 0.0 448.0 1158.0 0.0 0.0 0.0
34 63236 60359 7608 9480 13411 15407 16514 11668 1426.0 1253.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
35 80970 72055 9948 13584 22458 23312 23888 18141 0.0 1810.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
36 115668 89668 11497 15422 39874 32047 28996 25557 1973.0 1982.0 0.0 0.0 500.0 0.0 0.0 0.0 0.0
37 103781 56111 11032 11061 19027 32649 24486 19237 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
38 73665 83845 10591 11004 20712 24723 24359 18859 0.0 2515.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
39 97975 146141 18854 19548 7809 33080 24825 59387 2267.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
40 62032 65262 8466 9672 8972 24697 20428 17488 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
41 110697 121479 15678 20291 14776 32584 32030 32964 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
In [7]:
sejm2019
Out[7]:
PSL PiS Lewica Konfederacja KO KW Prawica AZER BS Liroy MN
Numer okręgu
1 31006 183364 71061 25319 108191 0.0 0.0 13495.0 0.0 0.0
2 20528 114728 34957 15346 90812 0.0 0.0 6631.0 0.0 0.0
3 42269 226915 100843 48775 214629 0.0 0.0 21024.0 0.0 0.0
4 41497 167550 69763 32406 142844 0.0 0.0 5922.0 0.0 0.0
5 49225 182648 67076 28625 119526 0.0 0.0 5230.0 0.0 0.0
6 51474 313284 44152 40012 109185 0.0 0.0 7490.0 0.0 0.0
7 47604 238802 27404 23439 59401 0.0 0.0 4668.0 0.0 0.0
8 50943 150188 68341 31490 136955 0.0 0.0 0.0 0.0 0.0
9 18828 136731 83524 27627 148830 0.0 0.0 0.0 0.0 0.0
10 36151 194658 37930 23427 54160 0.0 0.0 0.0 0.0 0.0
11 47373 229245 55116 27054 94268 0.0 0.0 7183.0 0.0 0.0
12 24996 169106 26909 22334 72869 0.0 0.0 0.0 0.0 0.0
13 47219 256847 84457 51855 197930 1765.0 0.0 9214.0 0.0 0.0
14 27203 243583 22483 25747 51183 0.0 0.0 0.0 0.0 0.0
15 46333 206845 20618 24695 48597 0.0 0.0 0.0 0.0 0.0
16 56227 194371 32448 19405 62429 0.0 0.0 5681.0 0.0 0.0
17 34185 193709 24884 19724 57449 0.0 0.0 2555.0 2503.0 0.0
18 54085 270641 29235 29390 63124 0.0 1412.0 5019.0 0.0 0.0
19 65683 379880 251434 103843 581077 0.0 0.0 0.0 0.0 0.0
20 51484 244823 78348 39675 171286 0.0 0.0 13111.0 0.0 0.0
21 41901 152999 47699 23176 108570 0.0 0.0 0.0 0.0 32094.0
22 30655 247488 23577 26615 62246 0.0 0.0 0.0 0.0 0.0
23 45868 367268 38817 48600 84703 0.0 0.0 0.0 3530.0 0.0
24 48566 270888 47342 36207 109527 0.0 1775.0 4001.0 2272.0 0.0
25 31203 169753 71236 38153 218484 0.0 0.0 0.0 0.0 0.0
26 46132 211582 72436 42364 208208 0.0 0.0 0.0 0.0 0.0
27 27752 182027 44701 28900 105876 0.0 0.0 0.0 0.0 0.0
28 24704 125990 44354 17278 64374 0.0 0.0 7817.0 0.0 0.0
29 20408 128579 45583 26114 111078 0.0 0.0 8885.0 0.0 0.0
30 18816 161160 32300 23939 92493 0.0 0.0 5128.0 0.0 0.0
31 20512 184030 55992 34416 174683 0.0 0.0 0.0 0.0 0.0
32 16263 124553 73466 21650 99499 0.0 0.0 0.0 0.0 0.0
33 56289 314455 56699 33895 94880 0.0 0.0 5400.0 8273.0 0.0
34 27319 102478 29196 14187 71320 0.0 0.0 6319.0 0.0 0.0
35 43758 128760 45912 23134 87780 0.0 0.0 0.0 2340.0 0.0
36 58759 195053 61674 30177 113489 0.0 0.0 0.0 0.0 0.0
37 34620 166965 53090 23810 72295 0.0 2261.0 0.0 0.0 0.0
38 48371 124392 46355 23123 106810 0.0 0.0 0.0 0.0 0.0
39 31875 130319 84835 34024 233474 0.0 0.0 0.0 0.0 0.0
40 25632 100078 41943 16259 87799 0.0 0.0 0.0 0.0 0.0
41 34807 165200 71756 30744 168022 0.0 0.0 0.0 0.0 0.0
In [8]:
prez20t1
Out[8]:
Nr OKW Kod TERYT Powiat Województwo Okr sejm Komisje obwodowe otrzymały kart do głosowania Liczba wyborców uprawnionych do głosowania Nie wykorzystano kart do głosowania Liczba wyborców, którym wydano karty do głosowania Liczba wyborców głosujących przez pełnomocnika ... Andrzej Sebastian DUDA Szymon Franciszek HOŁOWNIA Marek JAKUBIAK Władysław Marcin KOSINIAK-KAMYSZ Mirosław Mariusz PIOTROWSKI Paweł Jan TANAJNO Rafał Kazimierz TRZASKOWSKI Waldemar Włodzimierz WITKOWSKI Stanisław Józef ŻÓŁTEK Liczba obwodów
0 2 20100 bolesławiecki dolnośląskie 1 63490 68554 22570 40920 10 ... 17053 6726 52 633 29 50 12732 52 97 63
1 4 20200 dzierżoniowski dolnośląskie 2 73223 78876 27052 46170 41 ... 20403 6336 55 687 46 82 14770 46 89 83
2 3 20300 głogowski dolnośląskie 1 62325 67357 20428 41897 15 ... 18568 5969 42 736 44 57 13000 42 82 53
3 1 20400 górowski dolnośląskie 3 24915 27089 10382 14532 18 ... 7307 1918 21 378 12 14 3722 10 22 23
4 2 20500 jaworski dolnośląskie 1 36471 39708 13321 23150 29 ... 11139 2607 28 717 27 22 6708 15 44 39
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
377 49 321700 wałecki zachodniopomorskie 40 31182 40574 8027 23153 20 ... 8189 3978 38 508 28 26 8470 24 49 37
378 48 321800 łobeski zachodniopomorskie 41 24552 28082 9996 14556 13 ... 6126 2407 25 470 10 18 4567 12 18 29
379 49 326100 Koszalin zachodniopomorskie 40 71015 81709 17638 53356 22 ... 15975 8671 93 990 37 92 23262 77 140 53
380 48 326200 Szczecin zachodniopomorskie 41 265563 294599 68791 196776 104 ... 60954 29940 295 3288 201 372 83695 380 501 207
381 48 326300 Świnoujście zachodniopomorskie 41 30005 32985 8468 21535 17 ... 6316 3091 29 371 22 34 9852 26 37 27

382 rows × 39 columns

In [9]:
prez20t1.shape
Out[9]:
(382, 39)
In [10]:
prez20t2.shape
Out[10]:
(382, 30)
In [11]:
prez20t1 = prez20t1.iloc[:, [4]+list(range(27,38))].groupby('Okr sejm').agg('sum')
prez20t1.head(3)
Out[11]:
Robert BIEDROŃ Krzysztof BOSAK Andrzej Sebastian DUDA Szymon Franciszek HOŁOWNIA Marek JAKUBIAK Władysław Marcin KOSINIAK-KAMYSZ Mirosław Mariusz PIOTROWSKI Paweł Jan TANAJNO Rafał Kazimierz TRZASKOWSKI Waldemar Włodzimierz WITKOWSKI Stanisław Józef ŻÓŁTEK
Okr sejm
1 10155 27697 191859 64470 698 8448 449 663 149821 500 912
2 6566 17014 120466 41081 394 5622 266 462 104905 330 591
3 20524 47082 232676 95499 1231 13140 638 1231 257631 1333 2039
In [12]:
prez20t2 = prez20t2.iloc[:, [4]+list(range(27,29))].groupby('Okr sejm').agg('sum')
prez20t2.head(3)
Out[12]:
Andrzej Sebastian DUDA Rafał Kazimierz TRZASKOWSKI
Okr sejm
1 232692 244468
2 146027 168025
3 285112 411616
In [13]:
wyniki = pd.DataFrame()
In [14]:
wyniki["pis15"] = sejm2015["PiS"]
wyniki["pis19"] = sejm2019["PiS"]
wyniki["po15"] = sejm2015["PO"]
wyniki["ko19"] = sejm2019["KO"]
wyniki["lew15"] = sejm2015["Lewica"] + sejm2015["Razem"]
wyniki["lew19"] = sejm2019["Lewica"]
wyniki["psl15"] = sejm2015["PSL"]
wyniki["psl19"] = sejm2019["PSL"]
wyniki["kuk15"] = sejm2015["Kukiz"]
wyniki["n15"] = sejm2015["Nowoczesna"]
wyniki["kon15"] = sejm2015["KORWiN"] + sejm2015["Braun"] + sejm2015["KNP"]
wyniki["kon19"] = sejm2019["Konfederacja"]
wyniki["bs19"] = sejm2019["BS"]
wyniki["duda20"] = prez20t1["Andrzej Sebastian DUDA"]
wyniki["duda20_2"] = prez20t2["Andrzej Sebastian DUDA"]
wyniki["rt20"] = prez20t1["Rafał Kazimierz TRZASKOWSKI"]
wyniki["rt20_2"] = prez20t2["Rafał Kazimierz TRZASKOWSKI"]
wyniki["sh20"] = prez20t1["Szymon Franciszek HOŁOWNIA"]
wyniki["wkk20"] = prez20t1["Władysław Marcin KOSINIAK-KAMYSZ"]
wyniki["bosak20"] = prez20t1["Krzysztof BOSAK"]
wyniki["biedron20"] = prez20t1["Robert BIEDROŃ"]
wyniki["inni20"] = prez20t1[["Marek JAKUBIAK","Mirosław Mariusz PIOTROWSKI","Paweł Jan TANAJNO","Waldemar Włodzimierz WITKOWSKI","Stanisław Józef ŻÓŁTEK"]].sum(axis=1)
In [15]:
wyniki
Out[15]:
pis15 pis19 po15 ko19 lew15 lew19 psl15 psl19 kuk15 n15 ... bs19 duda20 duda20_2 rt20 rt20_2 sh20 wkk20 bosak20 biedron20 inni20
Nr okręgu
1 127370 183364 90060 108191 50301 71061 13886 31006 34229 25506 ... 13495.0 191859 232692 149821 244468 64470 8448 27697 10155 3222
2 72929 114728 76424 90812 28501 34957 7448 20528 20634 15544 ... 6631.0 120466 146027 104905 168025 41081 5622 17014 6566 2043
3 163323 226915 159582 214629 53991 100843 13604 42269 45726 55756 ... 21024.0 232676 285112 257631 411616 95499 13140 47082 20524 6472
4 113024 167550 110948 142844 51645 69763 22701 41497 29080 27334 ... 5922.0 179620 224327 165962 280466 79948 11310 27860 11256 3414
5 121703 182648 93432 119526 52230 67076 24476 49225 30159 23563 ... 5230.0 200570 252401 156999 262006 68649 12924 28672 10994 3282
6 232014 313284 80892 109185 42567 44152 37733 51474 45448 22158 ... 7490.0 331268 406431 126251 223998 64009 17280 49519 10592 5624
7 163122 238802 41823 59401 32277 27404 38689 47604 35567 12745 ... 4668.0 259966 319022 75320 144632 44978 14476 33884 6418 3757
8 97877 150188 97676 136955 48520 68341 17743 50943 30284 34586 ... 0.0 161894 199589 174894 296849 84590 9583 28743 10413 3332
9 107350 136731 112333 148830 54242 83524 9710 18828 25992 32274 ... 0.0 134235 161572 167436 253699 58675 7369 23672 12385 3429
10 134134 194658 44173 54160 30099 37930 21364 36151 28808 15983 ... 0.0 207609 254258 74447 136349 43226 9892 24707 6627 2878
11 147623 229245 78314 94268 43333 55116 29044 47373 32973 19681 ... 7183.0 247341 302574 121326 210625 61393 13984 29380 10010 3586
12 133213 169106 55454 72869 23313 26909 8226 24996 23551 15731 ... 0.0 177279 213349 78884 137426 40584 8446 26431 5314 2501
13 209607 256847 133558 197930 55696 84457 14644 47219 39379 52822 ... 9214.0 256829 314708 220398 368639 94721 19259 49840 19580 6857
14 188010 243583 43309 51183 14551 22483 12929 27203 24318 11468 ... 0.0 261686 316556 60889 118053 33717 8885 32533 4367 2558
15 151623 206845 42887 48597 17015 20618 23552 46333 28005 13233 ... 0.0 216658 262977 66779 125047 37012 15893 29799 4969 2566
16 131431 194371 49353 62429 34502 32448 31994 56227 25257 15451 ... 5681.0 214121 267938 93863 162369 43943 13363 24263 6616 2995
17 130758 193709 48332 57449 20461 24884 25933 34185 23149 13233 ... 2555.0 209644 256212 69904 123200 35011 10433 24808 5222 2502
18 191733 270641 50858 63124 26291 29235 38396 54085 31378 17386 ... 5019.0 291956 360991 86853 162144 52104 14457 36098 6639 3838
19 327342 379880 301672 581077 154329 251434 7882 65683 84937 146629 ... 0.0 340372 440311 636751 1004113 187336 21486 84568 50261 14100
20 190355 244823 123227 171286 46669 78348 18666 51484 35418 49098 ... 13111.0 249556 304894 212585 333121 90108 12924 39300 13059 5866
21 93926 152999 88731 108570 33043 47699 12464 41901 42533 24152 ... 0.0 176552 215648 139125 239682 72609 10146 26661 8039 3219
22 174900 247488 44971 62246 22488 23577 23805 30655 29919 12981 ... 0.0 264060 323110 68783 129981 38007 11562 34910 6170 2646
23 284642 367268 66516 84703 34032 38817 23667 45868 47071 21106 ... 0.0 382043 462535 104006 192152 62735 15725 60440 8632 4840
24 197575 270888 72894 109527 43273 47342 35116 48566 39509 23361 ... 4001.0 280113 352489 114076 233621 92088 11681 42823 8746 4190
25 126466 169753 148305 218484 45160 71236 12904 31203 30536 39184 ... 0.0 172382 219371 223373 364474 87815 10241 33812 14366 4580
26 145698 211582 156147 208208 49891 72436 15064 46132 37410 38344 ... 0.0 224787 293545 229633 399889 101575 12159 39166 15789 4514
27 136330 182027 79506 105876 34679 44701 11533 27752 31570 27882 ... 0.0 181930 222192 113872 200387 63603 7698 30480 7852 3188
28 84773 125990 49580 64374 34930 44354 11799 24704 27521 15942 ... 7817.0 134581 163150 86185 146581 43517 7349 18592 6444 2302
29 89584 128579 85130 111078 33344 45583 7342 20408 35793 26122 ... 8885.0 130629 159488 117254 193531 57717 6548 24986 8241 2946
30 114799 161160 70188 92493 26870 32300 5197 18816 32794 18341 ... 5128.0 159097 195467 92699 160825 52948 5844 28669 5948 2784
31 135367 184030 116658 174683 44623 55992 4064 20512 41344 35591 ... 0.0 178256 214481 162191 261310 74189 8329 32518 12476 4128
32 84410 124553 72755 99499 52426 73466 6687 16263 29161 25522 ... 0.0 128928 155455 120992 193260 49195 6857 21765 9844 2627
33 200652 314455 80866 94880 49986 56699 44574 56289 44115 23360 ... 5400.0 343752 419367 130670 231748 62383 19494 42544 10728 4069
34 63236 102478 60359 71320 23015 29196 13411 27319 16514 11668 ... 6319.0 115590 145532 84223 146210 39935 6912 16603 5547 1861
35 80970 128760 72055 87780 33260 45912 22458 43758 23888 18141 ... 0.0 138341 180191 124699 223526 53663 8777 25762 8478 2801
36 115668 195053 89668 113489 43544 61674 39874 58759 28996 25557 ... 0.0 216218 267483 139541 245319 73293 14263 32569 9597 3665
37 103781 166965 56111 72295 43681 53090 19027 34620 24486 19237 ... 0.0 185116 228286 97291 173840 56036 9359 22074 7395 2601
38 73665 124392 83845 106810 35314 46355 20712 48371 24359 18859 ... 0.0 138670 174522 122705 219025 69141 10829 22159 7676 2754
39 97975 130319 146141 233474 51934 84835 7809 31875 24825 59387 ... 0.0 126535 159299 236266 372944 94637 9683 29565 16532 4897
40 62032 100078 65262 87799 33163 41943 8972 25632 20428 17488 ... 0.0 110820 145630 112641 199747 47761 6856 15917 7989 2023
41 110697 165200 121479 168022 48262 71756 14776 34807 32030 32964 ... 0.0 176508 221466 195217 323366 79496 9879 29495 13673 3878

41 rows × 22 columns

In [16]:
rozklad = wyniki / wyniki.sum()
In [17]:
rozklad
Out[17]:
pis15 pis19 po15 ko19 lew15 lew19 psl15 psl19 kuk15 n15 ... bs19 duda20 duda20_2 rt20 rt20_2 sh20 wkk20 bosak20 biedron20 inni20
Nr okręgu
1 0.022300 0.022773 0.024597 0.021380 0.029633 0.030630 0.017805 0.019642 0.025561 0.022076 ... 0.093215 0.022704 0.022287 0.025319 0.024402 0.023936 0.018391 0.021024 0.023500 0.020742
2 0.012768 0.014249 0.020872 0.017946 0.016790 0.015068 0.009550 0.013005 0.015409 0.013454 ... 0.045803 0.014255 0.013986 0.017728 0.016772 0.015252 0.012239 0.012915 0.015195 0.013152
3 0.028595 0.028181 0.043584 0.042414 0.031807 0.043468 0.017444 0.026778 0.034147 0.048258 ... 0.145220 0.027534 0.027308 0.043538 0.041087 0.035457 0.028605 0.035739 0.047495 0.041665
4 0.019788 0.020809 0.030301 0.028228 0.030425 0.030071 0.029109 0.026288 0.021716 0.023658 ... 0.040905 0.021256 0.021486 0.028047 0.027995 0.029683 0.024621 0.021148 0.026048 0.021978
5 0.021308 0.022684 0.025518 0.023620 0.030770 0.028913 0.031385 0.031184 0.022522 0.020394 ... 0.036126 0.023735 0.024175 0.026532 0.026153 0.025488 0.028134 0.021764 0.025441 0.021129
6 0.040621 0.038908 0.022093 0.021577 0.025077 0.019031 0.048383 0.032609 0.033939 0.019178 ... 0.051736 0.039201 0.038928 0.021336 0.022359 0.023765 0.037617 0.037589 0.024511 0.036206
7 0.028559 0.029658 0.011422 0.011739 0.019015 0.011812 0.049609 0.030157 0.026560 0.011031 ... 0.032244 0.030763 0.030556 0.012729 0.014437 0.016699 0.031513 0.025721 0.014852 0.024186
8 0.017136 0.018652 0.026677 0.027064 0.028584 0.029458 0.022751 0.032273 0.022615 0.029935 ... 0.000000 0.019158 0.019117 0.029556 0.029631 0.031406 0.020861 0.021818 0.024097 0.021450
9 0.018795 0.016981 0.030680 0.029411 0.031955 0.036003 0.012451 0.011928 0.019410 0.027934 ... 0.000000 0.015885 0.015475 0.028296 0.025324 0.021785 0.016042 0.017969 0.028660 0.022075
10 0.023484 0.024175 0.012064 0.010703 0.017732 0.016350 0.027394 0.022902 0.021513 0.013834 ... 0.000000 0.024568 0.024353 0.012581 0.013610 0.016049 0.021534 0.018755 0.015336 0.018528
11 0.025846 0.028471 0.021389 0.018629 0.025528 0.023757 0.037242 0.030011 0.024623 0.017034 ... 0.049616 0.029269 0.028980 0.020503 0.021024 0.022794 0.030442 0.022302 0.023164 0.023086
12 0.023323 0.021002 0.015145 0.014400 0.013734 0.011599 0.010548 0.015835 0.017587 0.013616 ... 0.000000 0.020978 0.020434 0.013331 0.013718 0.015068 0.018386 0.020063 0.012297 0.016101
13 0.036698 0.031899 0.036477 0.039114 0.032812 0.036405 0.018777 0.029913 0.029407 0.045719 ... 0.063644 0.030392 0.030143 0.037246 0.036797 0.035168 0.041925 0.037833 0.045311 0.044143
14 0.032917 0.030251 0.011828 0.010115 0.008572 0.009691 0.016578 0.017233 0.018160 0.009926 ... 0.000000 0.030967 0.030320 0.010290 0.011784 0.012518 0.019342 0.024695 0.010106 0.016468
15 0.026546 0.025689 0.011713 0.009603 0.010024 0.008887 0.030200 0.029352 0.020913 0.011453 ... 0.000000 0.025638 0.025188 0.011285 0.012482 0.013742 0.034598 0.022620 0.011499 0.016519
16 0.023011 0.024140 0.013479 0.012337 0.020326 0.013987 0.041025 0.035620 0.018861 0.013373 ... 0.039241 0.025338 0.025663 0.015862 0.016207 0.016315 0.029090 0.018418 0.015310 0.019281
17 0.022893 0.024057 0.013200 0.011353 0.012054 0.010726 0.033253 0.021656 0.017287 0.011453 ... 0.017648 0.024808 0.024540 0.011813 0.012298 0.012999 0.022712 0.018831 0.012084 0.016107
18 0.033569 0.033612 0.013890 0.012474 0.015489 0.012602 0.049234 0.034263 0.023432 0.015048 ... 0.034668 0.034549 0.034576 0.014678 0.016185 0.019345 0.031472 0.027401 0.015363 0.024708
19 0.057311 0.047179 0.082391 0.114829 0.090918 0.108379 0.010107 0.041610 0.063429 0.126911 ... 0.000000 0.040278 0.042173 0.107608 0.100228 0.069554 0.046773 0.064194 0.116310 0.090772
20 0.033327 0.030405 0.033655 0.033849 0.027494 0.033771 0.023935 0.032615 0.026449 0.042495 ... 0.090562 0.029531 0.029203 0.035926 0.033251 0.033455 0.028134 0.029832 0.030220 0.037764
21 0.016445 0.019002 0.024234 0.021455 0.019466 0.020560 0.015982 0.026544 0.031763 0.020904 ... 0.000000 0.020892 0.020655 0.023511 0.023925 0.026958 0.022087 0.020238 0.018603 0.020723
22 0.030621 0.030736 0.012282 0.012301 0.013248 0.010163 0.030524 0.019420 0.022343 0.011235 ... 0.000000 0.031248 0.030947 0.011624 0.012974 0.014111 0.025170 0.026500 0.014278 0.017034
23 0.049835 0.045612 0.018166 0.016739 0.020049 0.016732 0.030347 0.029058 0.035151 0.018268 ... 0.000000 0.045209 0.044301 0.017576 0.019180 0.023292 0.034232 0.045879 0.019976 0.031158
24 0.034591 0.033643 0.019908 0.021644 0.025493 0.020407 0.045028 0.030767 0.029504 0.020219 ... 0.027636 0.033147 0.033761 0.019278 0.023320 0.034190 0.025429 0.032506 0.020239 0.026974
25 0.022142 0.021082 0.040504 0.043176 0.026605 0.030706 0.016546 0.019767 0.022803 0.033915 ... 0.000000 0.020399 0.021011 0.037749 0.036381 0.032604 0.022294 0.025666 0.033245 0.029485
26 0.025509 0.026277 0.042646 0.041145 0.029392 0.031223 0.019316 0.029225 0.027937 0.033188 ... 0.000000 0.026600 0.028116 0.038807 0.039916 0.037713 0.026469 0.029730 0.036538 0.029060
27 0.023869 0.022607 0.021714 0.020923 0.020430 0.019268 0.014788 0.017581 0.023576 0.024133 ... 0.000000 0.021529 0.021281 0.019244 0.020002 0.023614 0.016758 0.023137 0.018171 0.020523
28 0.014842 0.015647 0.013541 0.012721 0.020578 0.019119 0.015129 0.015650 0.020552 0.013798 ... 0.053995 0.015926 0.015626 0.014565 0.014631 0.016157 0.015998 0.014113 0.014912 0.014820
29 0.015684 0.015969 0.023250 0.021951 0.019644 0.019648 0.009414 0.012929 0.026729 0.022609 ... 0.061372 0.015458 0.015276 0.019815 0.019318 0.021429 0.014254 0.018966 0.019071 0.018965
30 0.020099 0.020015 0.019169 0.018278 0.015830 0.013923 0.006664 0.011920 0.024490 0.015875 ... 0.035421 0.018827 0.018722 0.015666 0.016053 0.019658 0.012722 0.021762 0.013764 0.017923
31 0.023700 0.022855 0.031861 0.034520 0.026288 0.024135 0.005211 0.012994 0.030875 0.030805 ... 0.000000 0.021094 0.020543 0.027409 0.026083 0.027545 0.018132 0.024684 0.028871 0.026575
32 0.014778 0.015469 0.019870 0.019662 0.030885 0.031667 0.008574 0.010303 0.021777 0.022090 ... 0.000000 0.015257 0.014889 0.020447 0.019291 0.018265 0.014927 0.016521 0.022780 0.016912
33 0.035130 0.039053 0.022086 0.018750 0.029448 0.024440 0.057155 0.035659 0.032944 0.020219 ... 0.037300 0.040678 0.040167 0.022083 0.023133 0.023161 0.042437 0.032294 0.024826 0.026195
34 0.011071 0.012727 0.016485 0.014094 0.013559 0.012585 0.017196 0.017307 0.012332 0.010099 ... 0.043648 0.013678 0.013939 0.014233 0.014594 0.014827 0.015047 0.012603 0.012836 0.011981
35 0.014176 0.015991 0.019679 0.017347 0.019594 0.019790 0.028797 0.027721 0.017839 0.015701 ... 0.000000 0.016371 0.017259 0.021073 0.022312 0.019924 0.019107 0.019555 0.019619 0.018032
36 0.020251 0.024224 0.024490 0.022427 0.025653 0.026584 0.051129 0.037224 0.021653 0.022120 ... 0.000000 0.025586 0.025619 0.023582 0.024487 0.027212 0.031049 0.024723 0.022209 0.023594
37 0.018170 0.020736 0.015325 0.014287 0.025733 0.022884 0.024397 0.021932 0.018285 0.016650 ... 0.000000 0.021906 0.021865 0.016442 0.017352 0.020805 0.020374 0.016756 0.017113 0.016744
38 0.012897 0.015449 0.022899 0.021107 0.020804 0.019981 0.026558 0.030643 0.018191 0.016323 ... 0.000000 0.016410 0.016716 0.020737 0.021863 0.025671 0.023574 0.016821 0.017763 0.017729
39 0.017153 0.016185 0.039913 0.046138 0.030595 0.036568 0.010013 0.020193 0.018539 0.051401 ... 0.000000 0.014974 0.015258 0.039928 0.037226 0.035137 0.021079 0.022442 0.038257 0.031525
40 0.010861 0.012429 0.017824 0.017350 0.019537 0.018079 0.011504 0.016238 0.015255 0.015136 ... 0.000000 0.013114 0.013948 0.019036 0.019938 0.017733 0.014925 0.012082 0.018488 0.013023
41 0.019381 0.020517 0.033178 0.033204 0.028432 0.030930 0.018947 0.022050 0.023919 0.028531 ... 0.000000 0.020887 0.021212 0.032991 0.032278 0.029515 0.021506 0.022389 0.031641 0.024965

41 rows × 22 columns

In [18]:
rozklad.to_csv(path+'rozklad.csv')

Procentowy rozkład poparcia¶

poszczególnych partii i kandydatów na okręgi wyborcze.

Jak to czytać? Np. spośród wszystkich głosów na KO w 2019 r., 11.5% padło w okręgu 19 (Warszawa).

In [19]:
rozklad.map(lambda x: round(100 * x, 2))
Out[19]:
pis15 pis19 po15 ko19 lew15 lew19 psl15 psl19 kuk15 n15 ... bs19 duda20 duda20_2 rt20 rt20_2 sh20 wkk20 bosak20 biedron20 inni20
Nr okręgu
1 2.23 2.28 2.46 2.14 2.96 3.06 1.78 1.96 2.56 2.21 ... 9.32 2.27 2.23 2.53 2.44 2.39 1.84 2.10 2.35 2.07
2 1.28 1.42 2.09 1.79 1.68 1.51 0.96 1.30 1.54 1.35 ... 4.58 1.43 1.40 1.77 1.68 1.53 1.22 1.29 1.52 1.32
3 2.86 2.82 4.36 4.24 3.18 4.35 1.74 2.68 3.41 4.83 ... 14.52 2.75 2.73 4.35 4.11 3.55 2.86 3.57 4.75 4.17
4 1.98 2.08 3.03 2.82 3.04 3.01 2.91 2.63 2.17 2.37 ... 4.09 2.13 2.15 2.80 2.80 2.97 2.46 2.11 2.60 2.20
5 2.13 2.27 2.55 2.36 3.08 2.89 3.14 3.12 2.25 2.04 ... 3.61 2.37 2.42 2.65 2.62 2.55 2.81 2.18 2.54 2.11
6 4.06 3.89 2.21 2.16 2.51 1.90 4.84 3.26 3.39 1.92 ... 5.17 3.92 3.89 2.13 2.24 2.38 3.76 3.76 2.45 3.62
7 2.86 2.97 1.14 1.17 1.90 1.18 4.96 3.02 2.66 1.10 ... 3.22 3.08 3.06 1.27 1.44 1.67 3.15 2.57 1.49 2.42
8 1.71 1.87 2.67 2.71 2.86 2.95 2.28 3.23 2.26 2.99 ... 0.00 1.92 1.91 2.96 2.96 3.14 2.09 2.18 2.41 2.15
9 1.88 1.70 3.07 2.94 3.20 3.60 1.25 1.19 1.94 2.79 ... 0.00 1.59 1.55 2.83 2.53 2.18 1.60 1.80 2.87 2.21
10 2.35 2.42 1.21 1.07 1.77 1.63 2.74 2.29 2.15 1.38 ... 0.00 2.46 2.44 1.26 1.36 1.60 2.15 1.88 1.53 1.85
11 2.58 2.85 2.14 1.86 2.55 2.38 3.72 3.00 2.46 1.70 ... 4.96 2.93 2.90 2.05 2.10 2.28 3.04 2.23 2.32 2.31
12 2.33 2.10 1.51 1.44 1.37 1.16 1.05 1.58 1.76 1.36 ... 0.00 2.10 2.04 1.33 1.37 1.51 1.84 2.01 1.23 1.61
13 3.67 3.19 3.65 3.91 3.28 3.64 1.88 2.99 2.94 4.57 ... 6.36 3.04 3.01 3.72 3.68 3.52 4.19 3.78 4.53 4.41
14 3.29 3.03 1.18 1.01 0.86 0.97 1.66 1.72 1.82 0.99 ... 0.00 3.10 3.03 1.03 1.18 1.25 1.93 2.47 1.01 1.65
15 2.65 2.57 1.17 0.96 1.00 0.89 3.02 2.94 2.09 1.15 ... 0.00 2.56 2.52 1.13 1.25 1.37 3.46 2.26 1.15 1.65
16 2.30 2.41 1.35 1.23 2.03 1.40 4.10 3.56 1.89 1.34 ... 3.92 2.53 2.57 1.59 1.62 1.63 2.91 1.84 1.53 1.93
17 2.29 2.41 1.32 1.14 1.21 1.07 3.33 2.17 1.73 1.15 ... 1.76 2.48 2.45 1.18 1.23 1.30 2.27 1.88 1.21 1.61
18 3.36 3.36 1.39 1.25 1.55 1.26 4.92 3.43 2.34 1.50 ... 3.47 3.45 3.46 1.47 1.62 1.93 3.15 2.74 1.54 2.47
19 5.73 4.72 8.24 11.48 9.09 10.84 1.01 4.16 6.34 12.69 ... 0.00 4.03 4.22 10.76 10.02 6.96 4.68 6.42 11.63 9.08
20 3.33 3.04 3.37 3.38 2.75 3.38 2.39 3.26 2.64 4.25 ... 9.06 2.95 2.92 3.59 3.33 3.35 2.81 2.98 3.02 3.78
21 1.64 1.90 2.42 2.15 1.95 2.06 1.60 2.65 3.18 2.09 ... 0.00 2.09 2.07 2.35 2.39 2.70 2.21 2.02 1.86 2.07
22 3.06 3.07 1.23 1.23 1.32 1.02 3.05 1.94 2.23 1.12 ... 0.00 3.12 3.09 1.16 1.30 1.41 2.52 2.65 1.43 1.70
23 4.98 4.56 1.82 1.67 2.00 1.67 3.03 2.91 3.52 1.83 ... 0.00 4.52 4.43 1.76 1.92 2.33 3.42 4.59 2.00 3.12
24 3.46 3.36 1.99 2.16 2.55 2.04 4.50 3.08 2.95 2.02 ... 2.76 3.31 3.38 1.93 2.33 3.42 2.54 3.25 2.02 2.70
25 2.21 2.11 4.05 4.32 2.66 3.07 1.65 1.98 2.28 3.39 ... 0.00 2.04 2.10 3.77 3.64 3.26 2.23 2.57 3.32 2.95
26 2.55 2.63 4.26 4.11 2.94 3.12 1.93 2.92 2.79 3.32 ... 0.00 2.66 2.81 3.88 3.99 3.77 2.65 2.97 3.65 2.91
27 2.39 2.26 2.17 2.09 2.04 1.93 1.48 1.76 2.36 2.41 ... 0.00 2.15 2.13 1.92 2.00 2.36 1.68 2.31 1.82 2.05
28 1.48 1.56 1.35 1.27 2.06 1.91 1.51 1.57 2.06 1.38 ... 5.40 1.59 1.56 1.46 1.46 1.62 1.60 1.41 1.49 1.48
29 1.57 1.60 2.33 2.20 1.96 1.96 0.94 1.29 2.67 2.26 ... 6.14 1.55 1.53 1.98 1.93 2.14 1.43 1.90 1.91 1.90
30 2.01 2.00 1.92 1.83 1.58 1.39 0.67 1.19 2.45 1.59 ... 3.54 1.88 1.87 1.57 1.61 1.97 1.27 2.18 1.38 1.79
31 2.37 2.29 3.19 3.45 2.63 2.41 0.52 1.30 3.09 3.08 ... 0.00 2.11 2.05 2.74 2.61 2.75 1.81 2.47 2.89 2.66
32 1.48 1.55 1.99 1.97 3.09 3.17 0.86 1.03 2.18 2.21 ... 0.00 1.53 1.49 2.04 1.93 1.83 1.49 1.65 2.28 1.69
33 3.51 3.91 2.21 1.87 2.94 2.44 5.72 3.57 3.29 2.02 ... 3.73 4.07 4.02 2.21 2.31 2.32 4.24 3.23 2.48 2.62
34 1.11 1.27 1.65 1.41 1.36 1.26 1.72 1.73 1.23 1.01 ... 4.36 1.37 1.39 1.42 1.46 1.48 1.50 1.26 1.28 1.20
35 1.42 1.60 1.97 1.73 1.96 1.98 2.88 2.77 1.78 1.57 ... 0.00 1.64 1.73 2.11 2.23 1.99 1.91 1.96 1.96 1.80
36 2.03 2.42 2.45 2.24 2.57 2.66 5.11 3.72 2.17 2.21 ... 0.00 2.56 2.56 2.36 2.45 2.72 3.10 2.47 2.22 2.36
37 1.82 2.07 1.53 1.43 2.57 2.29 2.44 2.19 1.83 1.67 ... 0.00 2.19 2.19 1.64 1.74 2.08 2.04 1.68 1.71 1.67
38 1.29 1.54 2.29 2.11 2.08 2.00 2.66 3.06 1.82 1.63 ... 0.00 1.64 1.67 2.07 2.19 2.57 2.36 1.68 1.78 1.77
39 1.72 1.62 3.99 4.61 3.06 3.66 1.00 2.02 1.85 5.14 ... 0.00 1.50 1.53 3.99 3.72 3.51 2.11 2.24 3.83 3.15
40 1.09 1.24 1.78 1.74 1.95 1.81 1.15 1.62 1.53 1.51 ... 0.00 1.31 1.39 1.90 1.99 1.77 1.49 1.21 1.85 1.30
41 1.94 2.05 3.32 3.32 2.84 3.09 1.89 2.21 2.39 2.85 ... 0.00 2.09 2.12 3.30 3.23 2.95 2.15 2.24 3.16 2.50

41 rows × 22 columns

In [20]:
rozklad.columns.to_list()
Out[20]:
['pis15',
 'pis19',
 'po15',
 'ko19',
 'lew15',
 'lew19',
 'psl15',
 'psl19',
 'kuk15',
 'n15',
 'kon15',
 'kon19',
 'bs19',
 'duda20',
 'duda20_2',
 'rt20',
 'rt20_2',
 'sh20',
 'wkk20',
 'bosak20',
 'biedron20',
 'inni20']

Szacunki 2023¶

Biorę historyczne rozkłady z różnymi wagami i buduję szacowany rozkład na wybory 2023.

In [21]:
r23 = pd.DataFrame(index=range(1, 42))
r23.index.name = "Nr okręgu"
srednia = rozklad.mean(axis=1)
In [22]:
r23["KO"] = 0.15 * rozklad["po15"] + 0.1 * rozklad["n15"] + 0.35 * rozklad["ko19"] + 0.25 * rozklad["rt20"] + 0.15 * rozklad["rt20_2"]
r23["Lewica"] = 0.3 * rozklad["lew15"] + 0.4 * rozklad["lew19"] + 0.15 * rozklad["biedron20"] + 0.15 * rozklad["rt20_2"]
r23["3D"] = 0.1 * rozklad["psl15"] + 0.15 * rozklad["n15"] + 0.05 * rozklad["kuk15"] + 0.25 * rozklad["psl19"] + 0.35 * rozklad["sh20"] + 0.1 * rozklad["wkk20"]
r23["BS"] = 0.3 * rozklad["bs19"] + 0.2 * rozklad["kuk15"] + 0.1 * rozklad["inni20"] + 0.4 * srednia
r23["Konf"] = 0.3 * rozklad["kon15"] + 0.4 * rozklad["kon19"] + 0.3 * rozklad["bosak20"]
r23["PiS"] = 0.2 * rozklad["pis15"] + 0.3 * rozklad["pis19"] + 0.3 * rozklad["duda20"] + 0.2 * rozklad["duda20_2"]
In [23]:
r23
Out[23]:
KO Lewica 3D BS Konf PiS
Nr okręgu
1 0.023370 0.028327 0.021497 0.045567 0.020611 0.022560
2 0.017705 0.015859 0.013557 0.024542 0.012837 0.013902
3 0.043256 0.040217 0.032655 0.070848 0.037827 0.027895
4 0.028002 0.029262 0.026969 0.029218 0.023541 0.020874
5 0.024690 0.028535 0.026854 0.027615 0.021361 0.023022
6 0.021471 0.022166 0.029644 0.038679 0.034427 0.039342
7 0.012273 0.014823 0.024479 0.026530 0.021182 0.029949
8 0.028301 0.028418 0.029043 0.016134 0.023560 0.018594
9 0.028562 0.032085 0.018616 0.014675 0.021131 0.016714
10 0.012126 0.016201 0.019386 0.013231 0.017600 0.024190
11 0.019711 0.023790 0.026035 0.032428 0.021843 0.028287
12 0.014064 0.012662 0.015048 0.011332 0.018021 0.021346
13 0.038564 0.036721 0.034186 0.044500 0.042857 0.032055
14 0.010647 0.009732 0.014679 0.012033 0.021380 0.031013
15 0.010957 0.010159 0.021391 0.013076 0.020850 0.025745
16 0.014074 0.016420 0.024576 0.025996 0.016646 0.024578
17 0.011897 0.011564 0.018142 0.017324 0.016552 0.024146
18 0.014051 0.014419 0.026836 0.027442 0.024687 0.034077
19 0.107176 0.103108 0.062643 0.050762 0.079714 0.046134
20 0.035114 0.031277 0.032767 0.050040 0.031125 0.030487
21 0.022701 0.020443 0.024602 0.016632 0.019154 0.019388
22 0.012123 0.012127 0.018166 0.013750 0.022081 0.030909
23 0.017681 0.018581 0.026372 0.021715 0.040284 0.046074
24 0.020901 0.022344 0.031212 0.028066 0.029746 0.033708
25 0.039473 0.030708 0.026465 0.018332 0.028492 0.021075
26 0.039805 0.032775 0.031459 0.020501 0.030772 0.026588
27 0.020805 0.019562 0.020614 0.014721 0.022530 0.022271
28 0.013699 0.018252 0.015778 0.028709 0.014069 0.015566
29 0.021283 0.019511 0.017827 0.033919 0.020621 0.015620
30 0.017185 0.014791 0.015405 0.024489 0.019753 0.019417
31 0.030706 0.025784 0.021388 0.018329 0.027590 0.022033
32 0.020077 0.028243 0.015721 0.013138 0.017386 0.015151
33 0.020888 0.025804 0.031661 0.032796 0.028796 0.038979
34 0.014163 0.013216 0.014872 0.022739 0.012134 0.012924
35 0.019208 0.020084 0.021941 0.012764 0.018728 0.015996
36 0.023303 0.025334 0.031449 0.016665 0.023264 0.024117
37 0.015677 0.022043 0.020654 0.012634 0.017082 0.020800
38 0.020918 0.020178 0.025017 0.012963 0.016860 0.015480
39 0.042841 0.035128 0.029092 0.017696 0.025475 0.015830
40 0.018010 0.018857 0.015942 0.010217 0.012715 0.012625
41 0.032540 0.030489 0.025364 0.017250 0.024716 0.020540
In [24]:
r23.sum()
Out[24]:
KO        1.0
Lewica    1.0
3D        1.0
BS        1.0
Konf      1.0
PiS       1.0
dtype: float64
In [25]:
r23.to_csv(path+'szacunek_rozkladu_2023.csv', sep=';')

Kod do skopiowania do aplikacji webowej

In [26]:
for okr, partie in r23.iterrows():
    print(',', partie.to_list())

, [0.023370223990776897, 0.028327482722150764, 0.021497388066773884, 0.04556699459979914, 0.020610606469802374, 0.02256035020932659]
, [0.0177051435910797, 0.01585931119043732, 0.013556899889736858, 0.024541735701745972, 0.012837209749385122, 0.013902144759203918]
, [0.043255827077965915, 0.040216505997983834, 0.03265516088036022, 0.07084816801699798, 0.03782695658704231, 0.027895094858036866]
, [0.028001863267545207, 0.029262380234123732, 0.026968648877499567, 0.029217927733740767, 0.02354070354887925, 0.020874078342872086]
, [0.024690032035758553, 0.028535143623010593, 0.026853962067903497, 0.027615292220034993, 0.021361198840153237, 0.02302202926232517]
, [0.021471317938474663, 0.02216621949583907, 0.029643808718129428, 0.038678749407351616, 0.0344268198922059, 0.03934239043768504]
, [0.01227265192679523, 0.01482276420174495, 0.024479020951963543, 0.026529853857163718, 0.021181579422748276, 0.029949337450454375]
, [0.02830117472529825, 0.028417579462775622, 0.02904265923224424, 0.016133665253355467, 0.023560412721663794, 0.018593650699249707]
, [0.02856169524083064, 0.03208512778341937, 0.018616402014443173, 0.014674956520188355, 0.021131357160492983, 0.01671380742727668]
, [0.012125785208802572, 0.016201233196566474, 0.01938607744367979, 0.013231061552796452, 0.017600004311548425, 0.0241902449575975]
, [0.01971127439027354, 0.02378973545578892, 0.026035316263867323, 0.03242780058930578, 0.021842771574647882, 0.028287275867971324]
, [0.014063717052190637, 0.012662047724893707, 0.015047655659426357, 0.011332055820659423, 0.018020908116911094, 0.02134558764098412]
, [0.038564240155229336, 0.03672144225955993, 0.034185527873371084, 0.04449992399515912, 0.04285719800752538, 0.032055370989762674]
, [0.010646953440308974, 0.009731582756840287, 0.014678634081197793, 0.012033376376958942, 0.021379641823237316, 0.03101276780574525]
, [0.010957132939046656, 0.010159184166652577, 0.021391082476828353, 0.013076097321919347, 0.020849815725693388, 0.025744970280978132]
, [0.014073764757737545, 0.016419975765278122, 0.024575793108753234, 0.02599630012052604, 0.01664571534337428, 0.024578137763607413]
, [0.011896821110627972, 0.011563915866586156, 0.018142498668842277, 0.017324191875247016, 0.016552296810171056, 0.02414634799807022]
, [0.014051436494972687, 0.014419436323086824, 0.026835876756905536, 0.027442240438066458, 0.02468729409693405, 0.034077064130703216]
, [0.10717611705095648, 0.10310788956616442, 0.06264250006196184, 0.0507617332485583, 0.07971440844636228, 0.04613383173845373]
, [0.03511396486820968, 0.031277390768473745, 0.03276681966841137, 0.05003986557602325, 0.03112480395546043, 0.03048705938323319]
, [0.0227012490209269, 0.020443193139743847, 0.024602111897746765, 0.01663225853749537, 0.01915422932467185, 0.019388030730543224]
, [0.012123273258821605, 0.012127406809678281, 0.018165730100014446, 0.013750266259246005, 0.022081371932629375, 0.030909028685095728]
, [0.017681379732704835, 0.018580760678828013, 0.026372288313564064, 0.021714772549636416, 0.04028444262443154, 0.04607382697432142]
, [0.020901143747510818, 0.022344308608106156, 0.031212051561629525, 0.028066111831221815, 0.02974648154943903, 0.0337075304494896]
, [0.0394729294510919, 0.030707582963825066, 0.0264645175505342, 0.01833221489155929, 0.028491875689828274, 0.021074950596814815]
, [0.039805482414845585, 0.03277482671228295, 0.031459098360563965, 0.020500869647010582, 0.03077221897032025, 0.02658813622180682]
, [0.020804579705463518, 0.019562162310081517, 0.02061357366019372, 0.014721038803617779, 0.022530106523896053, 0.022270654361520197]
, [0.013699313731623811, 0.018252332320418996, 0.015777516488718224, 0.0287093919492653, 0.01406888188088595, 0.015565574669967126]
, [0.021282676080040995, 0.019510669403254025, 0.017827034130254226, 0.03391936856283654, 0.020620749611821906, 0.015620049490118018]
, [0.017184535292653805, 0.014790618941038239, 0.015404706758215002, 0.02448942030729345, 0.019752685601779545, 0.01941672995476961]
, [0.030706460076576396, 0.025783645793670124, 0.021387997976355454, 0.01832941343107975, 0.027589784481947547, 0.02203342096090192]
, [0.020076782019966283, 0.028243037055388075, 0.0157209057996303, 0.01313842512680317, 0.017385645912979593, 0.015151233278885408]
, [0.020887617003398574, 0.02580399324100718, 0.03166053714387589, 0.03279568848630293, 0.028796179389832144, 0.03897884302187425]
, [0.014162947410171104, 0.013216098474627713, 0.014871892254390572, 0.022739197388805754, 0.01213388406608797, 0.012923739287082708]
, [0.0192084945450346, 0.020083920972856238, 0.021941120378304618, 0.01276417211381237, 0.018728436742304108, 0.015995532813271887]
, [0.023303440756032617, 0.025333843977260868, 0.031448755268836684, 0.016665348511318963, 0.02326401769467019, 0.024117321039462864]
, [0.015677270580934845, 0.022043436777129957, 0.020653621590445852, 0.012633857896001396, 0.017082204231380814, 0.020799580770622564]
, [0.020918217488986597, 0.020177535943800718, 0.02501665959843571, 0.01296346293686473, 0.016859858862570676, 0.015480082968255485]
, [0.04284120997416986, 0.03512817679365943, 0.029092350416868685, 0.01769616637458026, 0.025474689461174715, 0.015829736495080394]
, [0.018009530671635906, 0.01885667559392541, 0.015942041811975307, 0.010216814091556288, 0.012714773781485963, 0.012624699060619773]
, [0.03254032977452831, 0.03048942492804079, 0.0253637561771474, 0.01724975007809371, 0.024715779061623637, 0.020539756165959013]