okruga-spb

parse_okruga.py

#!/usr/bin/env python3
# -*- coding: utf-8 -*-

from pandas import read_csv

csv = read_csv('doma_uik_okruga.csv')

with open('uiks_by_duma.json', 'w+') as file:
    file.write(csv.groupby('округ Дума')['УИК'].unique().to_json())

with open('uiks_by_zaks.json', 'w+') as file:
    file.write(csv.groupby('округ ЗАКС')['УИК'].unique().to_json())

uiks_by_duma.json

{"211":[1582,1583,1584,1585,1575,1574,1576,1466,1470,1475,1472,1474,1473,1468,1581,1570,1548,1549,1555,1561,1557,1565,1566,1558,1577,1562,1579,1547,1567,1580,1569,1530,1525,1526,1529,1478,1476,1479,1484,1488,1464,1462,1443,1487,1446,1445,1447,1442,1440,1485,1435,1434,1425,1426,1489,1486,1550,1523,1517,1516,1527,1524,1545,1467,1455,1453,1432,1438,1429,1433,1528,1594,1596,1592,1457,1458,1471,1465,1463,1499,1500,1456,1461,1460,1546,1551,1604,1552,1564,1560,1568,1477,1481,1469,1483,1459,1450,1451,1480,1448,1591,1589,1593,1598,1600,1599,1573,1531,1521,1491,1520,1509,1492,1495,1508,1505,1504,1572,1514,1512,1515,1556,1553,1454,1449,1444,1452,1519,1518,1428,1430,1437,1436,1439,1578,1431,1586,1424,1423,1422,1427,1554,1482,1490,1501,1493,1502,1497,1503,1563,1597,1602,1522,1587,1588,1595,1603,1571,1559,1511,1506,1507,1510,1496,1441,1494,1498,1513,1590,1601,2252,2257,2256,2258,2253,2254,2260,2250,2249,2259,2247,2248,2243,2262,2265,2264,2245,2246,2240,2242,2241,2233,2236,2251,2263,2244,2234,2261,2239,2237,2238,2235,2255,
2267,2266,2268],"212":[762,775,774,773,792,767,776,769,794,778,777,800,799,801,802,808,810,811,759,766,758,781,785,783,784,786,768,795,803,793,804,805,796,787,788,791,771,757,760,761,798,807,813,812,814,809,789,790,772,779,780,763,764,770,765,797,782,806,1193,1181,1211,1180,1179,1097,1090,1096,1095,1173,1176,1174,1175,1171,1212,1202,1146,1148,1149,1145,1147,1153,1150,1151,1124,1136,1185,1109,1103,1196,1099,1160,1168,1167,1091,1092,1165,1172,1206,1201,1208,1214,1215,1216,1200,1199,1197,1203,1183,1134,1133,1128,1127,1074,1064,1063,1062,1129,1125,1121,1119,1115,1116,1155,1156,1154,1157,1161,1162,1100,1169,1170,1184,1186,1187,1189,1073,1075,1076,1210,1209,1188,1131,1130,1120,1108,1107,1117,1106,1113,1105,1078,1071,1123,1122,1112,1111,1110,1132,1072,1077,1066,1067,1080,1070,1198,1088,1089,1081,1082,1079,1059,1118,1126,1060,1065,1068,1069,1135,1207,1152,1163,1177,1178,1098,1204,1205,1158,1159,1058,1104,1114,1061,1086,1094,1093,1087,1166,1182,1194,1195,1102,1101,1213,1677,1687,1682,1685,1700,1708,1683,1684,1686,
1711,1717,1710,1723,1714,1701,1674,1706,1691,1699,1707,1675,1696,1698,1697,1694,1688,1679,1680,1695,1678,1693,1692,1712,1713,1709,1676,1716,1721,1689,1690,1715,1718,1719,1720,1722,1681],"213":[342,341,293,290,294,296,359,353,360,363,356,352,345,357,358,291,289,331,211,339,340,338,288,261,260,258,257,255,256,330,335,354,332,333,334,351,305,304,292,268,282,295,281,287,252,368,373,366,367,365,364,371,370,375,396,397,238,243,242,240,384,225,222,393,392,350,348,349,285,284,283,302,308,229,239,232,233,355,361,259,266,267,279,280,276,275,278,265,369,372,220,210,199,200,219,213,208,216,205,206,374,337,336,254,401,398,389,388,386,237,236,235,215,217,253,307,362,309,344,234,221,227,203,202,201,226,297,299,298,274,273,270,269,224,212,231,207,209,347,218,387,390,380,379,385,391,383,378,394,382,277,272,228,204,230,286,346,399,400,303,306,263,264,262,214,381,271,395,244,241,223,300,301,514,512,525,526,513,515,529,541,542,531,545,544,571,570,567,562,568,560,561,517,521,563,555,537,536,535,528,565,569,566,518,530,520,527,
559,532,539,558,554,538,552,516,519,540,547,572,548,533,534,546,524,523,543,564,557,556,522,549,550,551,553],"214":[425,426,424,420,428,419,506,486,505,504,484,429,430,434,435,432,418,433,422,421,416,463,464,449,448,445,466,467,444,462,457,461,458,454,460,443,431,438,439,440,437,436,498,480,481,483,492,477,470,473,471,475,455,479,482,469,472,474,478,451,452,447,450,497,496,503,502,417,442,414,415,499,500,501,495,494,493,476,456,468,453,485,487,427,491,441,459,490,488,489,423,465,446,1043,1044,929,919,918,917,1046,1045,1023,1018,1017,903,905,928,932,930,934,936,924,926,923,925,927,909,908,907,1029,951,952,953,957,956,961,960,902,945,943,944,949,955,954,986,1007,982,1006,1002,998,979,993,977,994,988,989,975,974,973,987,990,991,1041,1042,1047,1028,1032,1035,1036,1040,984,983,1003,1004,1001,1012,1026,1025,1027,1015,985,941,922,921,920,1038,1014,1013,1011,1019,1016,1020,1021,1008,1009,1005,946,947,904,906,910,916,913,914,915,933,931,1024,1000,992,1033,1010,942,948,950,997,999,1039,980,981,976,939,940,901,937,912,
978,1037,1022,935,938,911,995,996,1034,1030,1031],"215":[1220,1221,1231,1228,1233,1238,1232,1227,1229,1222,1235,1237,1230,1223,1226,1225,1224,1236,1234,1255,1264,1239,1261,1260,1240,1254,1265,1262,1269,1253,1258,1259,1246,1249,1250,1247,1256,1271,1252,1251,1248,1263,1245,1243,1267,1257,1266,1270,1268,1272,1241,1242,1244,1928,1927,1725,1730,1931,1897,1832,1839,1837,1910,1836,1912,1906,1915,1905,1838,1916,1909,1908,1830,1831,1923,1920,1914,1918,1799,1724,1938,1937,1868,1867,1870,1869,1877,1880,1813,1876,1729,1780,1776,1810,1809,1731,1732,1734,1737,1872,1736,1738,1740,1739,1742,1743,1760,1745,1761,1762,1746,1747,1751,1750,1753,1748,1873,1875,1929,1934,1930,1933,1935,1844,1733,1841,1843,1922,1943,1796,1795,1794,1793,1907,1835,1829,1898,1896,1911,1805,1840,1842,1874,1883,1879,1878,1817,1819,1822,1741,1744,1749,1800,1801,1871,1885,1884,1890,1889,1834,1826,1824,1827,1833,1901,1904,1902,1913,1924,1942,1887,1818,1821,1814,1823,1816,1825,1828,1893,1900,1895,1899,1903,1894,1944,1886,1888,1802,1806,1807,1803,1804,1808,
1757,1763,1815,1765,1764,1759,1767,1936,1940,1766,1755,1754,1758,1756,1892,1812,1735,1917,1921,1919,1941,1882,1797,1774,1781,1779,1783,1784,1770,1932,1769,1768,1771,1773,1782,1785,1777,1786,1881,1891,1798,1820,1787,1752,1772,1778,1775,1939,1726],"216":[43,53,46,51,57,45,44,47,50,48,31,30,11,14,3,5,21,29,40,16,32,25,24,15,33,34,17,39,42,59,60,61,37,36,38,12,7,13,28,19,23,20,18,22,26,2,6,27,10,9,49,1,52,8,54,56,4,35,41,58,55,104,106,119,110,124,123,111,125,114,126,112,127,130,129,113,128,115,117,116,120,118,132,107,105,108,121,122,109,174,180,140,141,142,131,147,135,134,133,136,138,137,139,143,181,179,177,178,176,169,168,175,145,155,153,152,157,163,161,167,164,165,170,166,171,172,158,173,156,154,148,144,149,150,151,160,159,162,146,1664,1658,1638,1637,1641,1642,1621,1643,1660,1657,1613,1615,1612,1647,1656,1648,1625,1633,1634,1630,1632,1631,1616,1619,1620,1624,1618,1649,1655,1650,1651,1636,1646,1640,1659,1622,1623,1662,1663,1661,1645,1644,1654,1653,1614,1626,1635,1639,1628,1652,1627,1617,1629,2204,2205,2180,2203,
2195,2194,2196,2197,2182,2181,2202,2212,2210,2222,2223,2224,2225,2221,2214,2207,2208,2209,2185,2201,2199,2193,2188,2189,2184,2198,2200,2213,2215,2183,2187,2218,2219,2220,2217,2186,2190,2192,2211,2216,2191,2206],"217":[892,879,880,841,840,826,888,887,889,846,849,855,845,847,881,844,843,842,856,868,872,866,867,827,870,876,883,884,885,861,862,860,864,865,873,874,875,836,837,835,839,828,829,831,854,878,848,838,830,832,833,850,851,882,891,890,886,853,852,857,859,869,834,863,858,871,877,2113,2114,2115,2107,2104,2105,2108,2109,2110,2040,2083,2085,2098,2097,2100,2099,2112,2084,2087,2048,2071,2072,2069,2070,2046,2053,2049,2068,2050,2055,2039,2035,2038,2054,2165,2158,2157,2164,2163,2052,2090,2086,2096,2095,2091,2094,2082,2111,2118,2122,2124,2123,2128,2152,2129,2159,2081,2160,2150,2042,2137,2134,2139,2140,2145,2146,2147,2043,2051,2089,2088,2092,2106,2047,2045,2044,2073,2077,2080,2078,2041,2116,2117,2135,2136,2037,2168,2131,2154,2126,2132,2151,2133,2141,2142,2130,2156,2162,2125,2175,2127,2119,2155,2153,2161,2172,2174,
2166,2167,2121,2036,2169,2170,2173,2149,2138,2148,2143,2171,2144,2120,2074,2079,2075,2061,2093,2060,2059,2056,2057,2062,2063,2064,2058,2067,2066,2065,2076,2176],"218":[609,610,596,607,605,604,606,576,577,578,586,587,583,580,603,628,630,602,582,631,632,588,589,591,595,601,594,600,611,612,617,585,590,581,584,599,598,608,593,643,641,644,613,618,616,614,615,619,597,579,635,636,639,642,633,638,634,627,621,620,625,622,624,623,629,626,637,640,592,1391,1407,1408,1404,1403,1325,1327,1326,1330,1332,1328,1329,1401,1383,1371,1396,1374,1373,1372,1397,1292,1293,1295,1304,1306,1307,1369,1282,1368,1287,1367,1298,1285,1290,1299,1400,1402,1283,1375,1376,1377,1378,1380,1398,1381,1393,1394,1399,1409,1308,1309,1310,1313,1316,1317,1318,1319,1322,1291,1294,1297,1281,1344,1324,1347,1350,1349,1279,1284,1323,1348,1412,1389,1305,1303,1302,1311,1314,1315,1320,1340,1343,1321,1390,1392,1384,1385,1388,1386,1387,1370,1395,1289,1331,1333,1335,1334,1341,1336,1342,1346,1337,1345,1286,1280,1382,1379,1338,1339,1410,1352,1405,1406,1351,1411,1288,
1312,1296,1300,1301,1986,1992,2010,1965,1961,1982,1988,1989,1984,1990,1954,1967,1968,1957,1960,2002,1973,1977,1958,1993,1985,1952,1998,1996,1951,1956,1955,2015,2004,2006,1991,1979,1950,1949,1953,1966,1978,1963,1971,1970,1964,1959,1975,2014,2018,1976,1974,2005,2011,2016,2012,2013,2007,2008,2009,1969,1981,1980,1962,2000,2001,2019,1995,1983,1994,1972,2003,2017,1997,1999,1987]}

uiks_by_zaks.json

{"1":[43,53,46,51,57,45,44,47,50,48,31,30,11,14,3,5,21,29,40,16,32,25,24,15,33,34,17,39,42,59,60,61,37,36,38,12,7,13,28,19,23,20,18,22,26,2,6,27,10,9,49,1,52,8,54,56,4,35,41,58,55,2204,2205,2180,2203,2182,2181,2202,2184,2183],"2":[2252,2257,2256,2258,2253,2254,2260,2250,2249,2259,2247,2248,2243,2262,2265,2264,2195,2194,2196,2245,2246,2197,2212,2210,2240,2222,2223,2224,2225,2221,2214,2242,2241,2207,2208,2209,2233,2185,2236,2251,2201,2199,2193,2188,2189,2263,2244,2198,2200,2213,2234,2215,2261,2239,2237,2238,2187,2235,2218,2219,2220,2255,2267,2217,2266,2186,2190,2192,2211,2216,2191,2268,2206],"3":[1664,1658,1638,1637,1641,1642,1621,1643,1660,1657,1613,1615,1612,1647,1656,1648,1625,1633,1634,1630,1632,1631,1616,1619,1620,1624,1618,1649,1655,1650,1651,1636,1646,1640,1659,1622,1623,1662,1663,1661,1645,1644,1654,1653,1614,1626,1635,1639,1628,1652,1627,1617,1629,1799,1810,1809,1844,1796,1795,1794,1793,1805,1800,1801,1802,1806,1807,1803,1804,1808,1797,1798],"4":[104,106,119,110,124,123,111,125,114,126,112,127,130,129,
113,128,115,117,116,120,118,132,107,105,108,121,122,109,174,180,140,141,142,131,147,135,134,133,136,138,137,139,143,181,179,177,178,176,169,168,175,145,155,153,152,157,163,161,167,164,165,170,166,171,172,158,173,156,154,148,144,149,150,151,160,159,162,146],"5":[342,341,359,353,360,363,356,352,345,357,358,331,339,340,338,330,335,354,332,333,334,351,368,373,366,367,365,364,371,370,375,396,397,238,243,242,240,384,225,393,392,350,348,349,239,232,233,355,361,369,372,374,337,336,401,398,389,388,386,237,236,235,362,344,234,347,387,390,380,379,385,391,383,378,394,382,346,399,400,381,395,244,241],"6":[425,426,424,420,428,419,570,567,562,568,560,561,429,430,434,435,432,418,433,422,563,565,421,416,569,566,443,431,438,439,440,437,436,480,481,483,477,470,473,471,475,547,479,482,469,472,474,478,572,548,417,442,564,414,415,476,427,441,423],"7":[514,512,525,526,513,515,529,541,542,531,545,544,517,521,537,536,535,528,518,530,520,527,532,539,538,516,519,540,533,534,546,524,523,543,522,929,919,918,917,903,905,928,932,930,934,
936,924,926,923,925,927,909,908,907,961,960,902,922,921,920,904,906,910,916,913,914,915,933,931,939,940,901,937,912,935,938,911],"8":[1043,1044,1046,1045,1023,1018,1017,1029,986,1007,982,1006,1002,998,979,993,977,994,988,989,975,974,973,987,990,991,1041,1042,1047,1028,1032,1035,1036,1040,984,983,1003,1004,1001,1012,1026,1025,1027,1015,985,1038,1014,1013,1011,1019,1016,1020,1021,1008,1009,1005,1024,1000,992,1033,1010,997,999,1039,980,981,976,978,1037,1022,995,996,1034,1030,1031],"9":[1466,1470,1475,1472,1474,1473,1468,1530,1525,1526,1529,1478,1476,1479,1484,1488,1464,1462,1487,1485,1489,1486,1523,1517,1516,1527,1524,1467,1528,1457,1458,1471,1465,1463,1499,1500,1461,1460,1477,1481,1469,1483,1459,1480,1531,1521,1491,1520,1509,1492,1495,1508,1505,1504,1514,1512,1515,1519,1518,1482,1490,1501,1493,1502,1497,1503,1522,1511,1506,1507,1510,1496,1494,1498,1513],"10":[293,290,294,296,291,289,305,304,292,295,302,308,307,309,297,299,298,303,306,300,301,1220,1221,1231,1228,1233,1238,1232,1227,1229,1222,1235,1237,1230,1223,
1226,1225,1224,1236,1234,1255,1264,1239,1261,1260,1240,1254,1265,1262,1269,1253,1258,1259,1246,1249,1250,1247,1256,1271,1252,1251,1248,1263,1245,1243,1267,1257,1266,1270,1268,1272,1241,1242,1244,1725,1730,1910,1912,1906,1915,1905,1916,1923,1920,1918,1724,1729,1922,1907,1911,1924,1917,1921,1919,1726],"11":[211,288,261,260,258,257,255,256,268,282,281,287,252,222,285,284,283,229,259,266,267,279,280,276,275,278,265,220,210,199,200,219,213,208,216,205,206,254,215,217,253,221,227,203,202,201,226,274,273,270,269,224,212,231,207,209,218,277,272,228,204,230,286,263,264,262,214,271,223],"12":[1928,1927,1931,1897,1909,1908,1914,1938,1937,1868,1867,1870,1869,1877,1880,1813,1876,1872,1873,1875,1929,1934,1930,1933,1935,1943,1829,1898,1896,1874,1883,1879,1878,1822,1871,1885,1884,1890,1889,1826,1824,1827,1901,1904,1902,1913,1942,1887,1814,1823,1816,1825,1828,1893,1900,1895,1899,1903,1894,1944,1886,1888,1815,1936,1940,1892,1812,1941,1882,1932,1881,1891,1939],"13":[1832,1839,1837,1836,1838,1830,1831,1780,1776,1731,1732,1734,
1737,1736,1738,1740,1739,1742,1743,1760,1745,1761,1762,1746,1747,1751,1750,1753,1748,1733,1841,1843,1835,1840,1842,1817,1819,1741,1744,1749,1834,1833,1818,1821,1757,1763,1765,1764,1759,1767,1766,1755,1754,1758,1756,1735,1774,1781,1779,1783,1784,1770,1769,1768,1771,1773,1782,1785,1777,1786,1820,1787,1752,1772,1778,1775],"14":[506,486,505,504,484,571,555,463,464,449,448,445,466,467,444,462,457,461,458,454,460,498,492,559,558,554,552,455,451,452,447,450,497,496,503,502,557,556,499,500,501,495,494,493,456,468,453,485,487,491,549,550,551,553,459,490,488,489,465,446],"15":[951,952,953,957,956,945,943,944,949,955,954,941,946,947,942,948,950,1548,1549,1555,1547,1550,1545,1546,1551,1552,1556,1553,1554,2040,2048,2071,2072,2069,2070,2046,2053,2049,2068,2050,2055,2039,2035,2038,2054,2052,2042,2043,2051,2047,2045,2044,2073,2077,2080,2078,2041,2135,2037,2036,2074,2079,2075,2061,2060,2059,2056,2057,2062,2063,2064,2058,2067,2066,2065,2076,2176],"16":[596,576,577,578,586,587,583,580,603,602,582,588,589,591,595,601,600,585,
590,581,584,599,598,593,597,579,592,1124,1136,1109,1103,1134,1133,1128,1127,1074,1064,1063,1062,1129,1125,1121,1119,1115,1116,1073,1075,1131,1130,1120,1108,1107,1117,1106,1113,1105,1123,1122,1112,1111,1110,1132,1066,1067,1070,1059,1118,1126,1060,1065,1068,1069,1135,1058,1104,1114,1061],"17":[792,628,794,630,800,799,801,802,808,810,811,795,803,793,631,804,805,796,632,787,611,788,791,612,617,798,807,813,812,814,809,643,641,644,789,790,613,618,616,614,615,619,635,636,639,642,633,638,634,627,621,620,625,622,624,623,629,626,637,640,797,806,1076,1078,1071,1072,1077,1080,1081,1082,1079],"18":[762,775,774,773,767,776,769,778,777,759,766,758,781,785,783,784,786,768,771,757,760,761,644,772,779,780,763,764,770,765,782,1097,1090,1096,1095,1146,1148,1149,1145,1147,1153,1150,1151,1099,1160,1168,1167,1091,1092,1165,1155,1156,1154,1157,1161,1162,1100,1169,1170,1088,1089,1152,1163,1098,1158,1159,1086,1094,1093,1087,1166,1102,1101],"19":[1193,1181,1211,1180,1179,1173,1176,1174,1175,1171,1212,1202,1185,1196,1172,1206,1201,1208,
1214,1215,1216,1200,1199,1197,1203,1183,1184,1186,1187,1189,1210,1209,1188,1198,1207,1177,1178,1204,1205,1182,1194,1195,1213,1677,1687,1682,1685,1700,1708,1683,1684,1686,1711,1717,1710,1723,1714,1701,1674,1706,1691,1699,1707,1675,1696,1698,1697,1694,1688,1679,1680,1695,1678,1693,1692,1712,1713,1709,1676,1716,1721,1689,1690,1715,1718,1719,1720,1722,1681],"20":[609,610,607,605,604,606,594,608,1391,1407,1408,1404,1403,1401,1383,1371,1396,1374,1373,1372,1397,1292,1293,1295,1369,1282,1368,1287,1367,1298,1285,1290,1299,1400,1402,1283,1375,1376,1377,1378,1380,1398,1381,1393,1394,1399,1409,1291,1294,1297,1281,1279,1284,1412,1389,1390,1392,1384,1385,1388,1386,1387,1370,1395,1289,1286,1280,1382,1379,1410,1405,1406,1411,1288,1296],"21":[1325,1327,1326,1330,1332,1328,1329,1304,1306,1307,1308,1309,1310,1313,1316,1317,1318,1319,1322,1344,1324,1347,1350,1349,1323,1348,1305,1303,1302,1311,1314,1315,1320,1340,1343,1321,1331,1333,1335,1334,1341,1336,1342,1346,1337,1345,1338,1339,1352,1351,1312,1300,1301,2083,2085,2098,2097,
2100,2099,2084,2087,2090,2086,2096,2095,2091,2094,2082,2081,2089,2088,2092,2093],"22":[2113,2114,2115,2107,2104,2105,2108,2109,2110,2112,2165,2158,2157,2164,2163,2111,2118,2122,2124,2123,2128,2152,2129,2159,2160,2150,2137,2134,2139,2140,2145,2146,2147,2106,2116,2117,2136,2168,2131,2154,2126,2132,2151,2133,2141,2142,2130,2156,2162,2125,2175,2127,2119,2155,2153,2161,2172,2174,2166,2167,2121,2169,2170,2173,2149,2138,2148,2143,2171,2144,2120],"23":[1582,1583,1584,1585,1575,1574,1576,1581,1570,1561,1557,1565,1566,1558,1577,1562,1579,1567,1580,1569,1443,1446,1445,1447,1442,1440,1435,1434,1425,1426,1455,1453,1432,1438,1429,1433,1594,1596,1592,1456,1604,1564,1560,1568,1450,1451,1448,1591,1589,1593,1598,1600,1599,1573,1572,1454,1449,1444,1452,1428,1430,1437,1436,1439,1578,1431,1586,1424,1423,1422,1427,1563,1597,1602,1587,1588,1595,1603,1571,1559,1441,1590,1601],"24":[1986,1992,2010,1965,1961,1982,1988,1989,1984,1990,1954,1967,1968,1957,1960,2002,1973,1977,1958,1993,1985,1952,1998,1996,1951,1956,1955,2015,2004,2006,
1991,1979,1950,1949,1953,1966,1978,1963,1971,1970,1964,1959,1975,2014,2018,1976,1974,2005,2011,2016,2012,2013,2007,2008,2009,1969,1981,1980,1962,2000,2001,2019,1995,1983,1994,1972,2003,2017,1997,1999,1987],"25":[892,879,880,841,840,826,888,887,889,846,849,855,845,847,881,844,843,842,856,868,872,866,867,827,870,876,883,884,885,861,862,860,864,865,873,874,875,836,837,835,839,828,829,831,854,878,848,838,830,832,833,850,851,882,891,890,886,853,852,857,859,869,834,863,858,871,877]}