This is an a review of how to use IPython Notebooks.
import pandas as pd
#This line is to make float division the default. For int division use //
from __future__ import division
path = "data/2014_indian_election_turnout.csv"
csv_data = pd.read_csv(path)
csv_data
State | PC Name | Male Electors | Male Voters | Female Electors | Female Voters | Total Electors | Total Voters | |
---|---|---|---|---|---|---|---|---|
0 | Andaman & Nicobar Islands | 1 - Andaman & Nicobar Islands | 142782 | 101178 | 126578 | 89150 | 269360 | 190328 |
1 | Andhra Pradesh | 1 - Adilabad | 687389 | 519364 | 698844 | 526475 | 1386233 | 1045839 |
2 | Andhra Pradesh | 2 - Peddapalle | 725767 | 520598 | 699594 | 501586 | 1425361 | 1022184 |
3 | Andhra Pradesh | 3 - Karimnagar | 777458 | 552489 | 773376 | 573202 | 1550834 | 1125691 |
4 | Andhra Pradesh | 4 - Nizamabad | 724504 | 469712 | 771689 | 564212 | 1496193 | 1033924 |
5 | Andhra Pradesh | 5 - Zahirabad | 717811 | 546746 | 727435 | 548060 | 1445246 | 1094806 |
6 | Andhra Pradesh | 6 - Medak | 775903 | 606863 | 760812 | 584233 | 1536715 | 1191096 |
7 | Andhra Pradesh | 7 - Malkajgiri | 1723413 | 878093 | 1459912 | 742304 | 3183325 | 1620397 |
8 | Andhra Pradesh | 8 - Secundrabad | 1012378 | 545749 | 881269 | 458020 | 1893647 | 1003769 |
9 | Andhra Pradesh | 9 - Hyderabad | 961290 | 526510 | 862374 | 444911 | 1823664 | 971421 |
10 | Andhra Pradesh | 10 - CHELVELLA | 1153049 | 696749 | 1032130 | 619113 | 2185179 | 1315862 |
11 | Andhra Pradesh | 11 - Mahbubnagar | 709711 | 511764 | 708961 | 503036 | 1418672 | 1014800 |
12 | Andhra Pradesh | 12 - Nagarkurnool | 745038 | 570342 | 732300 | 538626 | 1477338 | 1108968 |
13 | Andhra Pradesh | 13 - Nalgonda | 747281 | 602193 | 748299 | 587206 | 1495580 | 1189399 |
14 | Andhra Pradesh | 14 - Bhongir | 756963 | 622333 | 735288 | 589610 | 1492251 | 1211943 |
15 | Andhra Pradesh | 15 - Warangal | 771756 | 592484 | 766025 | 582147 | 1537781 | 1174631 |
16 | Andhra Pradesh | 16 - Mahabubabad | 688398 | 562073 | 698945 | 562297 | 1387343 | 1124370 |
17 | Andhra Pradesh | 17 - Khammam | 712329 | 588728 | 727960 | 594169 | 1440289 | 1182897 |
18 | Andhra Pradesh | 18 - Aruku | 622416 | 451350 | 650308 | 458264 | 1272724 | 909614 |
19 | Andhra Pradesh | 19 - Srikakulam | 706828 | 505010 | 707161 | 546436 | 1413989 | 1051446 |
20 | Andhra Pradesh | 20 - Vizianagaram | 700837 | 555005 | 703290 | 565311 | 1404127 | 1120316 |
21 | Andhra Pradesh | 21 - Visakhapatnam | 875187 | 585270 | 847850 | 578288 | 1723037 | 1163558 |
22 | Andhra Pradesh | 22 - Anakapalli | 689132 | 563818 | 712342 | 584254 | 1401474 | 1148072 |
23 | Andhra Pradesh | 23 - Kakinada | 709101 | 558689 | 709189 | 541310 | 1418290 | 1099999 |
24 | Andhra Pradesh | 24 - Amalapuram | 682607 | 568534 | 675259 | 552393 | 1357866 | 1120927 |
25 | Andhra Pradesh | 25 - Rajahmundry | 701707 | 577999 | 719581 | 576382 | 1421288 | 1154381 |
26 | Andhra Pradesh | 26 - Narsapuram | 652668 | 539357 | 672475 | 549594 | 1325143 | 1088951 |
27 | Andhra Pradesh | 27 - Eluru | 706916 | 597603 | 720844 | 604093 | 1427760 | 1201696 |
28 | Andhra Pradesh | 28 - Machilipatnam | 675774 | 567908 | 693537 | 573157 | 1369311 | 1141065 |
29 | Andhra Pradesh | 29 - Vijayawada | 781156 | 602198 | 783357 | 592877 | 1564513 | 1195075 |
30 | Andhra Pradesh | 30 - Guntur | 773027 | 617483 | 798989 | 627443 | 1572016 | 1244926 |
31 | Andhra Pradesh | 31 - Narasaraopet | 748465 | 638080 | 766396 | 643978 | 1514861 | 1282058 |
32 | Andhra Pradesh | 32 - Bapatla | 686482 | 587223 | 706483 | 597411 | 1392965 | 1184634 |
33 | Andhra Pradesh | 33 - Ongole | 736245 | 603025 | 734238 | 605200 | 1470483 | 1208225 |
34 | Andhra Pradesh | 34 - Nandyal | 783266 | 603562 | 793862 | 601394 | 1577128 | 1204956 |
35 | Andhra Pradesh | 35 - Kurnool | 738791 | 544802 | 743016 | 520930 | 1481807 | 1065732 |
36 | Andhra Pradesh | 36 - Anantapur | 775509 | 612890 | 761403 | 592164 | 1536912 | 1205054 |
37 | Andhra Pradesh | 37 - Hindupur | 734638 | 601932 | 711865 | 575325 | 1446503 | 1177257 |
38 | Andhra Pradesh | 38 - Kadapa | 765036 | 588805 | 785543 | 611857 | 1550579 | 1200662 |
39 | Andhra Pradesh | 39 - Nellore | 796583 | 593468 | 809557 | 594180 | 1606140 | 1187648 |
40 | Andhra Pradesh | 40 - Tirupati | 778778 | 604834 | 795766 | 608230 | 1574544 | 1213064 |
41 | Andhra Pradesh | 41 - Rajampet | 735347 | 573019 | 752151 | 585298 | 1487498 | 1158317 |
42 | Andhra Pradesh | 42 - Chittoor | 723996 | 598259 | 728145 | 600656 | 1452141 | 1198915 |
43 | Arunachal Pradesh | 1 - ARUNACHAL WEST | 219334 | 159978 | 227181 | 175687 | 446515 | 335665 |
44 | Arunachal Pradesh | 2 - ARUNACHAL EAST | 160293 | 129313 | 152579 | 131978 | 312872 | 261291 |
45 | Assam | 1 - Karimganj | 615198 | 482484 | 550799 | 404436 | 1165997 | 886920 |
46 | Assam | 2 - Silchar | 554540 | 428949 | 505635 | 370881 | 1060175 | 799830 |
47 | Assam | 3 - Autonomous District | 358880 | 279409 | 343010 | 263871 | 701890 | 543280 |
48 | Assam | 4 - Dhubri | 798124 | 709191 | 754430 | 660433 | 1552554 | 1369624 |
49 | Assam | 5 - Kokrajhar | 776071 | 636657 | 729405 | 587212 | 1505476 | 1223869 |
50 | Assam | 6 - Barpeta | 755559 | 634405 | 674616 | 571458 | 1430175 | 1205863 |
51 | Assam | 7 - Gauhati | 988067 | 785494 | 934203 | 726235 | 1922270 | 1511729 |
52 | Assam | 8 - Mangaldoi | 791539 | 651272 | 724137 | 581965 | 1515676 | 1233237 |
53 | Assam | 9 - Tezpur | 654866 | 505643 | 604702 | 475045 | 1259568 | 980688 |
54 | Assam | 10 - Nowgong | 792424 | 639392 | 731457 | 590682 | 1523881 | 1230074 |
55 | Assam | 11 - Kaliabor | 752785 | 605292 | 705080 | 561198 | 1457865 | 1166490 |
56 | Assam | 12 - Jorhat | 634236 | 483829 | 600212 | 447507 | 1234448 | 931336 |
57 | Assam | 13 - Dibrugarh | 579657 | 462412 | 544648 | 428556 | 1124305 | 890968 |
58 | Assam | 14 - Lakhimpur | 735263 | 572334 | 695731 | 539641 | 1430994 | 1111975 |
59 | Bihar | 1 - Valmiki Nagar | 786297 | 484621 | 670279 | 415493 | 1456576 | 900114 |
... | ... | ... | ... | ... | ... | ... | ... |
543 rows × 8 columns
csv_data["Male Turnout"] = csv_data["Male Voters"] / csv_data["Male Electors"]
csv_data["Female Turnout"] = csv_data["Female Voters"] / csv_data["Female Electors"]
csv_data["Total Turnout"] = csv_data["Total Voters"] / csv_data["Total Electors"]
csv_data.describe()
Male Electors | Male Voters | Female Electors | Female Voters | Total Electors | Total Voters | Male Turnout | Female Turnout | Total Turnout | |
---|---|---|---|---|---|---|---|---|---|
count | 543.000000 | 543.000000 | 543.000000 | 543.000000 | 543.000000 | 543.000000 | 543.000000 | 543.000000 | 543.000000 |
mean | 804883.127072 | 540030.900552 | 731215.360958 | 479861.918969 | 1536098.488029 | 1019892.819521 | 0.680646 | 0.663664 | 0.672688 |
std | 165950.096614 | 105316.219120 | 127159.414206 | 96137.678162 | 288064.231735 | 192716.272135 | 0.100641 | 0.111115 | 0.102917 |
min | 25433.000000 | 21585.000000 | 24489.000000 | 21654.000000 | 49922.000000 | 43239.000000 | 0.283097 | 0.232644 | 0.259047 |
25% | 728644.000000 | 491359.000000 | 691996.500000 | 430761.500000 | 1425052.000000 | 940426.500000 | 0.608490 | 0.578545 | 0.592252 |
50% | 814968.000000 | 549484.000000 | 740045.000000 | 484001.000000 | 1555779.000000 | 1033783.000000 | 0.680857 | 0.656567 | 0.667207 |
75% | 899919.500000 | 597803.000000 | 791426.500000 | 540898.000000 | 1692364.500000 | 1129424.500000 | 0.763453 | 0.756988 | 0.755237 |
max | 1723413.000000 | 878093.000000 | 1459912.000000 | 742304.000000 | 3183325.000000 | 1620397.000000 | 0.888572 | 0.892712 | 0.882175 |
8 rows × 9 columns
print '{0:,}'.format(csv_data["Total Electors"].sum())
834,101,479
print '%.2f%%' % (csv_data["Female Electors"].sum() / csv_data["Male Electors"].sum()*100)
90.85%
print '{0:,}'.format(csv_data["Total Voters"].sum())
553,801,801
print '%.2f%%' % (csv_data["Total Voters"].sum() / csv_data["Total Electors"].sum() * 100)
66.40%
states = pd.DataFrame(csv_data["State"].unique(), columns=["State"])
print "The number of states: %s" % len(states)
states
The number of states: 35
State | |
---|---|
0 | Andaman & Nicobar Islands |
1 | Andhra Pradesh |
2 | Arunachal Pradesh |
3 | Assam |
4 | Bihar |
5 | Chandigarh |
6 | Chattisgarh |
7 | Dadra & Nagar Haveli |
8 | Daman & Diu |
9 | Goa |
10 | Gujarat |
11 | Haryana |
12 | Himachal Pradesh |
13 | Jammu & Kashmir |
14 | Jharkhand |
15 | Karnataka |
16 | Kerala |
17 | Lakshadweep |
18 | Madhya Pradesh |
19 | Maharashtra |
20 | Manipur |
21 | Meghalaya |
22 | Mizoram |
23 | Nagaland |
24 | NCT OF Delhi |
25 | Orissa |
26 | Puducherry |
27 | Punjab |
28 | Rajasthan |
29 | Sikkim |
30 | Tamil Nadu |
31 | Tripura |
32 | Uttar Pradesh |
33 | Uttarakhand |
34 | West Bengal |
35 rows × 1 columns
# Calculating constituencies
seats = csv_data["State"].value_counts()
states["Seats"] = seats.sort_index().values
states.sort("Seats", ascending=False)
State | Seats | |
---|---|---|
32 | Uttar Pradesh | 80 |
19 | Maharashtra | 48 |
34 | West Bengal | 42 |
1 | Andhra Pradesh | 42 |
4 | Bihar | 40 |
30 | Tamil Nadu | 39 |
18 | Madhya Pradesh | 29 |
15 | Karnataka | 28 |
10 | Gujarat | 26 |
28 | Rajasthan | 25 |
25 | Orissa | 21 |
16 | Kerala | 20 |
3 | Assam | 14 |
14 | Jharkhand | 14 |
27 | Punjab | 13 |
6 | Chattisgarh | 11 |
11 | Haryana | 10 |
23 | Nagaland | 7 |
13 | Jammu & Kashmir | 6 |
33 | Uttarakhand | 5 |
12 | Himachal Pradesh | 4 |
9 | Goa | 2 |
21 | Meghalaya | 2 |
20 | Manipur | 2 |
2 | Arunachal Pradesh | 2 |
31 | Tripura | 2 |
5 | Chandigarh | 1 |
17 | Lakshadweep | 1 |
7 | Dadra & Nagar Haveli | 1 |
8 | Daman & Diu | 1 |
22 | Mizoram | 1 |
24 | NCT OF Delhi | 1 |
26 | Puducherry | 1 |
29 | Sikkim | 1 |
0 | Andaman & Nicobar Islands | 1 |
35 rows × 2 columns
total_electors = pd.pivot_table(csv_data, values="Total Electors", rows=["State"], aggfunc="sum")
total_votes = pd.pivot_table(csv_data, values="Total Voters", rows=["State"], aggfunc="sum")
states["Total Electors"] = total_electors.sort_index().values
states["Total Voters"] = total_votes.sort_index().values
states.sort("Total Electors", ascending=False)
State | Seats | Total Electors | Total Voters | |
---|---|---|---|---|
32 | Uttar Pradesh | 80 | 138965820 | 81092302 |
19 | Maharashtra | 48 | 80717283 | 48718844 |
1 | Andhra Pradesh | 42 | 64938750 | 48358545 |
4 | Bihar | 40 | 63761796 | 35885366 |
34 | West Bengal | 42 | 62833128 | 51622555 |
30 | Tamil Nadu | 39 | 55114505 | 40620440 |
18 | Madhya Pradesh | 29 | 48118040 | 29639796 |
15 | Karnataka | 28 | 46212109 | 31038888 |
28 | Rajasthan | 25 | 42969447 | 27110044 |
10 | Gujarat | 26 | 40603104 | 25824003 |
25 | Orissa | 21 | 29196041 | 21532275 |
16 | Kerala | 20 | 24326649 | 17975893 |
14 | Jharkhand | 14 | 20326743 | 12982940 |
27 | Punjab | 13 | 19608008 | 13845132 |
3 | Assam | 14 | 18885274 | 15085883 |
6 | Chattisgarh | 11 | 17623049 | 12255579 |
11 | Haryana | 10 | 16097749 | 11495150 |
23 | Nagaland | 7 | 12711236 | 8271766 |
13 | Jammu & Kashmir | 6 | 7202163 | 3566863 |
33 | Uttarakhand | 5 | 7129939 | 4391890 |
12 | Himachal Pradesh | 4 | 4810071 | 3098501 |
31 | Tripura | 2 | 2388819 | 2023859 |
20 | Manipur | 2 | 1774325 | 1412637 |
21 | Meghalaya | 2 | 1567241 | 1078058 |
24 | NCT OF Delhi | 1 | 1182948 | 1038910 |
9 | Goa | 2 | 1060777 | 817000 |
26 | Puducherry | 1 | 901357 | 740017 |
2 | Arunachal Pradesh | 2 | 759387 | 596956 |
22 | Mizoram | 1 | 702170 | 433201 |
5 | Chandigarh | 1 | 615214 | 453455 |
29 | Sikkim | 1 | 370611 | 308967 |
0 | Andaman & Nicobar Islands | 1 | 269360 | 190328 |
7 | Dadra & Nagar Haveli | 1 | 196617 | 165286 |
8 | Daman & Diu | 1 | 111827 | 87233 |
17 | Lakshadweep | 1 | 49922 | 43239 |
35 rows × 4 columns
states["Turnout"] = states["Total Voters"] / states["Total Electors"]
states.sort("Turnout", ascending=False)
State | Seats | Total Electors | Total Voters | Turnout | |
---|---|---|---|---|---|
24 | NCT OF Delhi | 1 | 1182948 | 1038910 | 0.878238 |
17 | Lakshadweep | 1 | 49922 | 43239 | 0.866131 |
31 | Tripura | 2 | 2388819 | 2023859 | 0.847222 |
7 | Dadra & Nagar Haveli | 1 | 196617 | 165286 | 0.840650 |
29 | Sikkim | 1 | 370611 | 308967 | 0.833669 |
34 | West Bengal | 42 | 62833128 | 51622555 | 0.821582 |
26 | Puducherry | 1 | 901357 | 740017 | 0.821003 |
3 | Assam | 14 | 18885274 | 15085883 | 0.798817 |
20 | Manipur | 2 | 1774325 | 1412637 | 0.796155 |
2 | Arunachal Pradesh | 2 | 759387 | 596956 | 0.786102 |
8 | Daman & Diu | 1 | 111827 | 87233 | 0.780071 |
9 | Goa | 2 | 1060777 | 817000 | 0.770190 |
1 | Andhra Pradesh | 42 | 64938750 | 48358545 | 0.744679 |
16 | Kerala | 20 | 24326649 | 17975893 | 0.738938 |
25 | Orissa | 21 | 29196041 | 21532275 | 0.737507 |
5 | Chandigarh | 1 | 615214 | 453455 | 0.737069 |
30 | Tamil Nadu | 39 | 55114505 | 40620440 | 0.737019 |
11 | Haryana | 10 | 16097749 | 11495150 | 0.714084 |
0 | Andaman & Nicobar Islands | 1 | 269360 | 190328 | 0.706593 |
27 | Punjab | 13 | 19608008 | 13845132 | 0.706096 |
6 | Chattisgarh | 11 | 17623049 | 12255579 | 0.695429 |
21 | Meghalaya | 2 | 1567241 | 1078058 | 0.687870 |
15 | Karnataka | 28 | 46212109 | 31038888 | 0.671661 |
23 | Nagaland | 7 | 12711236 | 8271766 | 0.650744 |
12 | Himachal Pradesh | 4 | 4810071 | 3098501 | 0.644169 |
14 | Jharkhand | 14 | 20326743 | 12982940 | 0.638712 |
10 | Gujarat | 26 | 40603104 | 25824003 | 0.636011 |
28 | Rajasthan | 25 | 42969447 | 27110044 | 0.630914 |
22 | Mizoram | 1 | 702170 | 433201 | 0.616946 |
18 | Madhya Pradesh | 29 | 48118040 | 29639796 | 0.615981 |
33 | Uttarakhand | 5 | 7129939 | 4391890 | 0.615979 |
19 | Maharashtra | 48 | 80717283 | 48718844 | 0.603574 |
32 | Uttar Pradesh | 80 | 138965820 | 81092302 | 0.583541 |
4 | Bihar | 40 | 63761796 | 35885366 | 0.562804 |
13 | Jammu & Kashmir | 6 | 7202163 | 3566863 | 0.495249 |
35 rows × 5 columns
states["Electors Per Seat"] = states["Total Electors"] / states["Seats"]
states.sort("Electors Per Seat", ascending=False)
State | Seats | Total Electors | Total Voters | Turnout | Electors Per Seat | |
---|---|---|---|---|---|---|
23 | Nagaland | 7 | 12711236 | 8271766 | 0.650744 | 1815890.857143 |
32 | Uttar Pradesh | 80 | 138965820 | 81092302 | 0.583541 | 1737072.750000 |
28 | Rajasthan | 25 | 42969447 | 27110044 | 0.630914 | 1718777.880000 |
19 | Maharashtra | 48 | 80717283 | 48718844 | 0.603574 | 1681610.062500 |
18 | Madhya Pradesh | 29 | 48118040 | 29639796 | 0.615981 | 1659242.758621 |
15 | Karnataka | 28 | 46212109 | 31038888 | 0.671661 | 1650432.464286 |
11 | Haryana | 10 | 16097749 | 11495150 | 0.714084 | 1609774.900000 |
6 | Chattisgarh | 11 | 17623049 | 12255579 | 0.695429 | 1602095.363636 |
4 | Bihar | 40 | 63761796 | 35885366 | 0.562804 | 1594044.900000 |
10 | Gujarat | 26 | 40603104 | 25824003 | 0.636011 | 1561657.846154 |
1 | Andhra Pradesh | 42 | 64938750 | 48358545 | 0.744679 | 1546160.714286 |
27 | Punjab | 13 | 19608008 | 13845132 | 0.706096 | 1508308.307692 |
34 | West Bengal | 42 | 62833128 | 51622555 | 0.821582 | 1496026.857143 |
14 | Jharkhand | 14 | 20326743 | 12982940 | 0.638712 | 1451910.214286 |
33 | Uttarakhand | 5 | 7129939 | 4391890 | 0.615979 | 1425987.800000 |
30 | Tamil Nadu | 39 | 55114505 | 40620440 | 0.737019 | 1413192.435897 |
25 | Orissa | 21 | 29196041 | 21532275 | 0.737507 | 1390287.666667 |
3 | Assam | 14 | 18885274 | 15085883 | 0.798817 | 1348948.142857 |
16 | Kerala | 20 | 24326649 | 17975893 | 0.738938 | 1216332.450000 |
12 | Himachal Pradesh | 4 | 4810071 | 3098501 | 0.644169 | 1202517.750000 |
13 | Jammu & Kashmir | 6 | 7202163 | 3566863 | 0.495249 | 1200360.500000 |
31 | Tripura | 2 | 2388819 | 2023859 | 0.847222 | 1194409.500000 |
24 | NCT OF Delhi | 1 | 1182948 | 1038910 | 0.878238 | 1182948.000000 |
26 | Puducherry | 1 | 901357 | 740017 | 0.821003 | 901357.000000 |
20 | Manipur | 2 | 1774325 | 1412637 | 0.796155 | 887162.500000 |
21 | Meghalaya | 2 | 1567241 | 1078058 | 0.687870 | 783620.500000 |
22 | Mizoram | 1 | 702170 | 433201 | 0.616946 | 702170.000000 |
5 | Chandigarh | 1 | 615214 | 453455 | 0.737069 | 615214.000000 |
9 | Goa | 2 | 1060777 | 817000 | 0.770190 | 530388.500000 |
2 | Arunachal Pradesh | 2 | 759387 | 596956 | 0.786102 | 379693.500000 |
29 | Sikkim | 1 | 370611 | 308967 | 0.833669 | 370611.000000 |
0 | Andaman & Nicobar Islands | 1 | 269360 | 190328 | 0.706593 | 269360.000000 |
7 | Dadra & Nagar Haveli | 1 | 196617 | 165286 | 0.840650 | 196617.000000 |
8 | Daman & Diu | 1 | 111827 | 87233 | 0.780071 | 111827.000000 |
17 | Lakshadweep | 1 | 49922 | 43239 | 0.866131 | 49922.000000 |
35 rows × 6 columns
path = "data/2014_indian_elections_results.csv"
results_data = pd.read_csv(path, sep="\t")
results_data
Name of State/ UT | Parliamentary Constituency | Candidate Name | Total Votes Polled | Winner or Not? | Party Abbreviation | Party Name | |
---|---|---|---|---|---|---|---|
0 | Andhra Pradesh | Adilabad | GODAM NAGESH | 430847 | yes | TRS | Telangana Rashtra Samithi |
1 | Andhra Pradesh | Adilabad | NETHAWATH RAMDAS | 41032 | no | IND | Independent |
2 | Andhra Pradesh | Adilabad | RAMESH RATHOD | 184198 | no | TDP | Telugu Desam |
3 | Andhra Pradesh | Adilabad | RATHOD SADASHIV | 94420 | no | BSP | Bahujan Samaj Party |
4 | Andhra Pradesh | Adilabad | MOSALI CHINNAIAH | 8859 | no | IND | Independent |
5 | Andhra Pradesh | Adilabad | NARESH | 259557 | no | INC | Indian National Congress |
6 | Andhra Pradesh | Adilabad | PAWAR KRISHNA | 5055 | no | IND | Independent |
7 | Andhra Pradesh | Adilabad | BANKA SAHADEV | 4787 | no | IND | Independent |
8 | Andhra Pradesh | Adilabad | None of the Above | 17084 | no | NOTA | None of the Above |
9 | Andhra Pradesh | Peddapalle | BALKA SUMAN | 565496 | yes | TRS | Telangana Rashtra Samithi |
10 | Andhra Pradesh | Peddapalle | None of the Above | 5361 | no | NOTA | None of the Above |
11 | Andhra Pradesh | Peddapalle | G. VIVEKANAND | 274338 | no | INC | Indian National Congress |
12 | Andhra Pradesh | Peddapalle | KALVALA SHANKAR | 9290 | no | PPOI | Pyramid Party of India |
13 | Andhra Pradesh | Peddapalle | MOUTAM RAVINDER | 2674 | no | IND | Independent |
14 | Andhra Pradesh | Peddapalle | VELTHURU MALLAIAH | 45977 | no | RP(K) | Republican Paksha (Khoripa) |
15 | Andhra Pradesh | Peddapalle | DR.JANAPATI SARAT BABU | 63334 | no | TDP | Telugu Desam |
16 | Andhra Pradesh | Peddapalle | KAMILLA JAYA RAO | 2742 | no | IND | Independent |
17 | Andhra Pradesh | Peddapalle | THALLAPALLI SRINIVAS | 3699 | no | IND | Independent |
18 | Andhra Pradesh | Peddapalle | VENKATA SWAMY INJAM | 3866 | no | MaSP | Mahajana Socialist Party |
19 | Andhra Pradesh | Peddapalle | GORRE RAMESH | 2361 | no | IND | Independent |
20 | Andhra Pradesh | Peddapalle | BUPELLI NARAYANA | 7258 | no | IND | Independent |
21 | Andhra Pradesh | Peddapalle | BOTHA VENKATA MALLAIAH | 2245 | no | BCUF | B. C. United Front |
22 | Andhra Pradesh | Peddapalle | JINNA RAMADEVI | 9199 | no | IND | Independent |
23 | Andhra Pradesh | Peddapalle | J.V. RAJU | 3020 | no | NIP | New India Party |
24 | Andhra Pradesh | Peddapalle | GADDALA VINAY KUMAR | 3266 | no | IND | Independent |
25 | Andhra Pradesh | Peddapalle | KALVALA SANJEEV | 8609 | no | RPI | Republican Party of India |
26 | Andhra Pradesh | Peddapalle | TAGARAM SHANKAR LAL | 9449 | no | BSP | Bahujan Samaj Party |
27 | Andhra Pradesh | Karimnagar | VINOD KUMAR BOINAPALLY | 505783 | yes | TRS | Telangana Rashtra Samithi |
28 | Andhra Pradesh | Karimnagar | SRINIVAS REDDY LINGAMPALLY | 3865 | no | IND | Independent |
29 | Andhra Pradesh | Karimnagar | RANAVENI LAKSHMAN | 2062 | no | NIP | New India Party |
30 | Andhra Pradesh | Karimnagar | MALLESH YADAV BARLA | 2760 | no | IND | Independent |
31 | Andhra Pradesh | Karimnagar | REDDI MALLA SRINIVAS | 8040 | no | RPI(A) | Republican Party of India (A) |
32 | Andhra Pradesh | Karimnagar | BURLA. RAVI | 4769 | no | NCP | Nationalist Congress Party |
33 | Andhra Pradesh | Karimnagar | KANDEM PRABHAKAR | 4731 | no | IND | Independent |
34 | Andhra Pradesh | Karimnagar | B. LAXMAN | 11333 | no | BSP | Bahujan Samaj Party |
35 | Andhra Pradesh | Karimnagar | SHAIK MAHMOOD | 39325 | no | WPOI | Welfare Party Of India |
36 | Andhra Pradesh | Karimnagar | PONNAM PRABHAKAR | 300706 | no | INC | Indian National Congress |
37 | Andhra Pradesh | Karimnagar | CHENNAMANENI VIDYA SAGAR RAO | 214828 | no | BJP | Bharatiya Janata Party |
38 | Andhra Pradesh | Karimnagar | MEESALA RAJI REDDY | 3080 | no | YSRCP | Yuvajana Sramika Rythu Congress Party |
39 | Andhra Pradesh | Karimnagar | MOHAMMED AMJAD MOHIUDDIN | 6720 | no | IND | Independent |
40 | Andhra Pradesh | Karimnagar | UPPULETI.LAXMAN | 2448 | no | IND | Independent |
41 | Andhra Pradesh | Karimnagar | L. PRABHAKAR REDDY | 3944 | no | PPOI | Pyramid Party of India |
42 | Andhra Pradesh | Karimnagar | PULIKOTA RAMESH | 1777 | no | IND | Independent |
43 | Andhra Pradesh | Karimnagar | DR.DHARMAIAH VENDAVETLA | 3773 | no | BMUP | Bahujan Mukti Party |
44 | Andhra Pradesh | Karimnagar | None of the Above | 5747 | no | NOTA | None of the Above |
45 | Andhra Pradesh | Nizamabad | KALVAKUNTLA KAVITHA | 439307 | yes | TRS | Telangana Rashtra Samithi |
46 | Andhra Pradesh | Nizamabad | BANJA VEERAPPA | 3651 | no | PPOI | Pyramid Party of India |
47 | Andhra Pradesh | Nizamabad | CHIRULINGADRULA VENKATESHAM | 3091 | no | IND | Independent |
48 | Andhra Pradesh | Nizamabad | KANDEM PRABHAKAR | 3990 | no | IND | Independent |
49 | Andhra Pradesh | Nizamabad | MALIK MOHTASIM KHAN | 43814 | no | WPOI | Welfare Party Of India |
50 | Andhra Pradesh | Nizamabad | S. CHANDRAIAH | 2817 | no | IND | Independent |
51 | Andhra Pradesh | Nizamabad | BAGWAN B | 8129 | no | IND | Independent |
52 | Andhra Pradesh | Nizamabad | ABDUL GANI | 4791 | no | BCUF | B. C. United Front |
53 | Andhra Pradesh | Nizamabad | ENDALA LAKSHMINARAYANA | 225333 | no | BJP | Bharatiya Janata Party |
54 | Andhra Pradesh | Nizamabad | ABDUL KAREEM KHAN (BABU) | 1601 | no | IND | Independent |
55 | Andhra Pradesh | Nizamabad | TALARI RAMULU | 7421 | no | BSP | Bahujan Samaj Party |
56 | Andhra Pradesh | Nizamabad | SAGAR SUDDALA | 1978 | no | BMUP | Bahujan Mukti Party |
57 | Andhra Pradesh | Nizamabad | MADHU YASKHI GOUD | 272123 | no | INC | Indian National Congress |
58 | Andhra Pradesh | Nizamabad | RAPELLY SRINIVAS | 2621 | no | AAAP | Aam Aadmi Party |
59 | Andhra Pradesh | Nizamabad | KOTAPATI NARSIMHAM NAIDU | 2462 | no | IND | Independent |
... | ... | ... | ... | ... | ... | ... |
8794 rows × 7 columns
winners = results_data[results_data["Winner or Not?"] == "yes"].sort("Name of State/ UT")
winners
Name of State/ UT | Parliamentary Constituency | Candidate Name | Total Votes Polled | Winner or Not? | Party Abbreviation | Party Name | |
---|---|---|---|---|---|---|---|
8548 | Andaman & Nicobar Islands | Andaman & Nicobar Islands | BISHNU PADA RAY | 90969 | yes | BJP | Bharatiya Janata Party |
0 | Andhra Pradesh | Adilabad | GODAM NAGESH | 430847 | yes | TRS | Telangana Rashtra Samithi |
9 | Andhra Pradesh | Peddapalle | BALKA SUMAN | 565496 | yes | TRS | Telangana Rashtra Samithi |
27 | Andhra Pradesh | Karimnagar | VINOD KUMAR BOINAPALLY | 505783 | yes | TRS | Telangana Rashtra Samithi |
45 | Andhra Pradesh | Nizamabad | KALVAKUNTLA KAVITHA | 439307 | yes | TRS | Telangana Rashtra Samithi |
62 | Andhra Pradesh | Zahirabad | B.B. PATIL | 508661 | yes | TRS | Telangana Rashtra Samithi |
73 | Andhra Pradesh | Medak | KALVAKUNTLA CHANDRASEKHAR RAO | 657492 | yes | TRS | Telangana Rashtra Samithi |
87 | Andhra Pradesh | Malkajgiri | CH.MALLA REDDY | 523336 | yes | TDP | Telugu Desam |
118 | Andhra Pradesh | Secundrabad | BANDARU DATTATREYA | 438271 | yes | BJP | Bharatiya Janata Party |
149 | Andhra Pradesh | Hyderabad | ASADUDDIN OWAISI | 513868 | yes | AIMIM | All India Majlis-E-Ittehadul Muslimeen |
166 | Andhra Pradesh | CHELVELLA | KONDA VISHWESHWAR REDDY | 435077 | yes | TRS | Telangana Rashtra Samithi |
182 | Andhra Pradesh | Mahbubnagar | AP JITHENDER REDDY | 334228 | yes | TRS | Telangana Rashtra Samithi |
192 | Andhra Pradesh | Nagarkurnool | YELLAIAH NANDI | 420075 | yes | INC | Indian National Congress |
199 | Andhra Pradesh | Nalgonda | GUTHA SUKHENDER REDDY | 472093 | yes | INC | Indian National Congress |
209 | Andhra Pradesh | Bhongir | DR. BOORA NARSAIAH GOUD | 448245 | yes | TRS | Telangana Rashtra Samithi |
223 | Andhra Pradesh | Warangal | KADIYAM SRIHARI | 661639 | yes | TRS | Telangana Rashtra Samithi |
236 | Andhra Pradesh | Mahabubabad | PROF. AZMEERA SEETARAM NAIK | 320569 | yes | TRS | Telangana Rashtra Samithi |
254 | Andhra Pradesh | Khammam | PONGULETI SRINIVASA REDDY | 421957 | yes | YSRCP | Yuvajana Sramika Rythu Congress Party |
282 | Andhra Pradesh | Aruku | KOTHAPALLI GEETHA | 413191 | yes | YSRCP | Yuvajana Sramika Rythu Congress Party |
294 | Andhra Pradesh | Srikakulam | RAMMOHAN NAIDU KINJARAPU | 556163 | yes | TDP | Telugu Desam |
305 | Andhra Pradesh | Vizianagaram | ASHOK GAJAPATHI RAJU PUSAPATI | 536549 | yes | TDP | Telugu Desam |
315 | Andhra Pradesh | Visakhapatnam | KAMBHAMPATI HARI BABU | 566832 | yes | BJP | Bharatiya Janata Party |
338 | Andhra Pradesh | Anakapalli | MUTTAMSETTI SRINIVASA RAO (AVANTHI) | 568463 | yes | TDP | Telugu Desam |
347 | Andhra Pradesh | Kakinada | THOTA NARASIMHAM | 514402 | yes | TDP | Telugu Desam |
370 | Andhra Pradesh | Amalapuram | DR PANDULA RAVINDRA BABU | 594547 | yes | TDP | Telugu Desam |
385 | Andhra Pradesh | Rajahmundry | MURALI MOHAN MAGANTI | 630573 | yes | TDP | Telugu Desam |
400 | Andhra Pradesh | Narsapuram | GOKARAJU GANGA RAJU | 540306 | yes | BJP | Bharatiya Janata Party |
415 | Andhra Pradesh | Eluru | MAGANTI VENKATESWARA RAO (BABU) | 623471 | yes | TDP | Telugu Desam |
431 | Andhra Pradesh | Machilipatnam | KONAKALLA NARAYANA RAO | 587280 | yes | TDP | Telugu Desam |
443 | Andhra Pradesh | Vijayawada | KESINENI SRINIVAS | 592696 | yes | TDP | Telugu Desam |
466 | Andhra Pradesh | Guntur | JAYADEV GALLA | 618417 | yes | TDP | Telugu Desam |
479 | Andhra Pradesh | Narasaraopet | SAMBASIVA RAO RAYAPATI | 632464 | yes | TDP | Telugu Desam |
491 | Andhra Pradesh | Bapatla | MALYADRI SRIRAM | 578145 | yes | TDP | Telugu Desam |
506 | Andhra Pradesh | Ongole | Y.V.SUBBA REDDY | 589960 | yes | YSRCP | Yuvajana Sramika Rythu Congress Party |
522 | Andhra Pradesh | Nandyal | S.P.Y REDDY | 622411 | yes | YSRCP | Yuvajana Sramika Rythu Congress Party |
537 | Andhra Pradesh | Kurnool | BUTTA RENUKA | 472782 | yes | YSRCP | Yuvajana Sramika Rythu Congress Party |
550 | Andhra Pradesh | Anantapur | J.C. DIVAKAR REDDI | 606509 | yes | TDP | Telugu Desam |
564 | Andhra Pradesh | Hindupur | KRISTAPPA NIMMALA | 604291 | yes | TDP | Telugu Desam |
577 | Andhra Pradesh | Kadapa | Y.S. AVINASH REDDY | 671983 | yes | YSRCP | Yuvajana Sramika Rythu Congress Party |
592 | Andhra Pradesh | Nellore | MEKAPATI RAJAMOHAN REDDY | 576396 | yes | YSRCP | Yuvajana Sramika Rythu Congress Party |
607 | Andhra Pradesh | Tirupati | VARAPRASAD RAO VELAGAPALLI | 580376 | yes | YSRCP | Yuvajana Sramika Rythu Congress Party |
622 | Andhra Pradesh | Rajampet | P.V.MIDHUN REDDY | 601752 | yes | YSRCP | Yuvajana Sramika Rythu Congress Party |
632 | Andhra Pradesh | Chittoor | NARAMALLI SIVAPRASAD | 594862 | yes | TDP | Telugu Desam |
640 | Arunachal Pradesh | ARUNACHAL WEST | KIREN RIJIJU | 169367 | yes | BJP | Bharatiya Janata Party |
649 | Arunachal Pradesh | ARUNACHAL EAST | NINONG ERING | 118455 | yes | INC | Indian National Congress |
653 | Assam | Karimganj | RADHESHYAM BISWAS | 362866 | yes | AIUDF | All India United Democratic Front |
669 | Assam | Silchar | SUSHMITA DEV | 336451 | yes | INC | Indian National Congress |
687 | Assam | Autonomous District | BIREN SINGH ENGTI | 213152 | yes | INC | Indian National Congress |
693 | Assam | Dhubri | BADRUDDIN AJMAL | 592569 | yes | AIUDF | All India United Democratic Front |
709 | Assam | Kokrajhar | NABA KUMAR SARANIA (HIRA) | 634428 | yes | IND | Independent |
716 | Assam | Barpeta | SIRAJ UDDIN AJMAL | 394702 | yes | AIUDF | All India United Democratic Front |
732 | Assam | Gauhati | BIJOYA CHAKRAVARTY | 764985 | yes | BJP | Bharatiya Janata Party |
751 | Assam | Mangaldoi | RAMEN DEKA | 486357 | yes | BJP | Bharatiya Janata Party |
764 | Assam | Tezpur | RAM PRASAD SARMAH | 446511 | yes | BJP | Bharatiya Janata Party |
774 | Assam | Nowgong | RAJEN GOHAIN | 494146 | yes | BJP | Bharatiya Janata Party |
783 | Assam | Kaliabor | GOURAV GOGOI | 443315 | yes | INC | Indian National Congress |
797 | Assam | Jorhat | KAMAKHYA PRASAD TASA | 456420 | yes | BJP | Bharatiya Janata Party |
808 | Assam | Dibrugarh | RAMESWAR TELI | 494364 | yes | BJP | Bharatiya Janata Party |
815 | Assam | Lakhimpur | SARBANANDA SONOWAL | 612543 | yes | BJP | Bharatiya Janata Party |
829 | Bihar | Valmiki Nagar | SATISH CHANDRA DUBEY | 364011 | yes | BJP | Bharatiya Janata Party |
... | ... | ... | ... | ... | ... | ... |
543 rows × 7 columns
csv_data["Candidate Name"] = winners["Candidate Name"].values
csv_data["Party Abbreviation"] = winners["Party Abbreviation"].values
csv_data["Party Name"] = winners["Party Name"].values
csv_data["Total Votes Polled"] = winners["Total Votes Polled"].values
csv_data
State | PC Name | Male Electors | Male Voters | Female Electors | Female Voters | Total Electors | Total Voters | Male Turnout | Female Turnout | Total Turnout | Candidate Name | Party Abbreviation | Party Name | Total Votes Polled | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | Andaman & Nicobar Islands | 1 - Andaman & Nicobar Islands | 142782 | 101178 | 126578 | 89150 | 269360 | 190328 | 0.708619 | 0.704309 | 0.706593 | BISHNU PADA RAY | BJP | Bharatiya Janata Party | 90969 |
1 | Andhra Pradesh | 1 - Adilabad | 687389 | 519364 | 698844 | 526475 | 1386233 | 1045839 | 0.755561 | 0.753351 | 0.754447 | GODAM NAGESH | TRS | Telangana Rashtra Samithi | 430847 |
2 | Andhra Pradesh | 2 - Peddapalle | 725767 | 520598 | 699594 | 501586 | 1425361 | 1022184 | 0.717307 | 0.716967 | 0.717140 | BALKA SUMAN | TRS | Telangana Rashtra Samithi | 565496 |
3 | Andhra Pradesh | 3 - Karimnagar | 777458 | 552489 | 773376 | 573202 | 1550834 | 1125691 | 0.710635 | 0.741169 | 0.725862 | VINOD KUMAR BOINAPALLY | TRS | Telangana Rashtra Samithi | 505783 |
4 | Andhra Pradesh | 4 - Nizamabad | 724504 | 469712 | 771689 | 564212 | 1496193 | 1033924 | 0.648322 | 0.731139 | 0.691037 | KALVAKUNTLA KAVITHA | TRS | Telangana Rashtra Samithi | 439307 |
5 | Andhra Pradesh | 5 - Zahirabad | 717811 | 546746 | 727435 | 548060 | 1445246 | 1094806 | 0.761685 | 0.753414 | 0.757522 | B.B. PATIL | TRS | Telangana Rashtra Samithi | 508661 |
6 | Andhra Pradesh | 6 - Medak | 775903 | 606863 | 760812 | 584233 | 1536715 | 1191096 | 0.782138 | 0.767907 | 0.775092 | KALVAKUNTLA CHANDRASEKHAR RAO | TRS | Telangana Rashtra Samithi | 657492 |
7 | Andhra Pradesh | 7 - Malkajgiri | 1723413 | 878093 | 1459912 | 742304 | 3183325 | 1620397 | 0.509508 | 0.508458 | 0.509027 | CH.MALLA REDDY | TDP | Telugu Desam | 523336 |
8 | Andhra Pradesh | 8 - Secundrabad | 1012378 | 545749 | 881269 | 458020 | 1893647 | 1003769 | 0.539076 | 0.519728 | 0.530072 | BANDARU DATTATREYA | BJP | Bharatiya Janata Party | 438271 |
9 | Andhra Pradesh | 9 - Hyderabad | 961290 | 526510 | 862374 | 444911 | 1823664 | 971421 | 0.547712 | 0.515914 | 0.532675 | ASADUDDIN OWAISI | AIMIM | All India Majlis-E-Ittehadul Muslimeen | 513868 |
10 | Andhra Pradesh | 10 - CHELVELLA | 1153049 | 696749 | 1032130 | 619113 | 2185179 | 1315862 | 0.604267 | 0.599840 | 0.602176 | KONDA VISHWESHWAR REDDY | TRS | Telangana Rashtra Samithi | 435077 |
11 | Andhra Pradesh | 11 - Mahbubnagar | 709711 | 511764 | 708961 | 503036 | 1418672 | 1014800 | 0.721088 | 0.709540 | 0.715317 | AP JITHENDER REDDY | TRS | Telangana Rashtra Samithi | 334228 |
12 | Andhra Pradesh | 12 - Nagarkurnool | 745038 | 570342 | 732300 | 538626 | 1477338 | 1108968 | 0.765521 | 0.735526 | 0.750653 | YELLAIAH NANDI | INC | Indian National Congress | 420075 |
13 | Andhra Pradesh | 13 - Nalgonda | 747281 | 602193 | 748299 | 587206 | 1495580 | 1189399 | 0.805845 | 0.784721 | 0.795276 | GUTHA SUKHENDER REDDY | INC | Indian National Congress | 472093 |
14 | Andhra Pradesh | 14 - Bhongir | 756963 | 622333 | 735288 | 589610 | 1492251 | 1211943 | 0.822145 | 0.801876 | 0.812158 | DR. BOORA NARSAIAH GOUD | TRS | Telangana Rashtra Samithi | 448245 |
15 | Andhra Pradesh | 15 - Warangal | 771756 | 592484 | 766025 | 582147 | 1537781 | 1174631 | 0.767709 | 0.759958 | 0.763848 | KADIYAM SRIHARI | TRS | Telangana Rashtra Samithi | 661639 |
16 | Andhra Pradesh | 16 - Mahabubabad | 688398 | 562073 | 698945 | 562297 | 1387343 | 1124370 | 0.816494 | 0.804494 | 0.810448 | PROF. AZMEERA SEETARAM NAIK | TRS | Telangana Rashtra Samithi | 320569 |
17 | Andhra Pradesh | 17 - Khammam | 712329 | 588728 | 727960 | 594169 | 1440289 | 1182897 | 0.826483 | 0.816211 | 0.821291 | PONGULETI SRINIVASA REDDY | YSRCP | Yuvajana Sramika Rythu Congress Party | 421957 |
18 | Andhra Pradesh | 18 - Aruku | 622416 | 451350 | 650308 | 458264 | 1272724 | 909614 | 0.725158 | 0.704688 | 0.714699 | KOTHAPALLI GEETHA | YSRCP | Yuvajana Sramika Rythu Congress Party | 413191 |
19 | Andhra Pradesh | 19 - Srikakulam | 706828 | 505010 | 707161 | 546436 | 1413989 | 1051446 | 0.714474 | 0.772718 | 0.743603 | RAMMOHAN NAIDU KINJARAPU | TDP | Telugu Desam | 556163 |
20 | Andhra Pradesh | 20 - Vizianagaram | 700837 | 555005 | 703290 | 565311 | 1404127 | 1120316 | 0.791917 | 0.803809 | 0.797874 | ASHOK GAJAPATHI RAJU PUSAPATI | TDP | Telugu Desam | 536549 |
21 | Andhra Pradesh | 21 - Visakhapatnam | 875187 | 585270 | 847850 | 578288 | 1723037 | 1163558 | 0.668737 | 0.682064 | 0.675295 | KAMBHAMPATI HARI BABU | BJP | Bharatiya Janata Party | 566832 |
22 | Andhra Pradesh | 22 - Anakapalli | 689132 | 563818 | 712342 | 584254 | 1401474 | 1148072 | 0.818157 | 0.820187 | 0.819189 | MUTTAMSETTI SRINIVASA RAO (AVANTHI) | TDP | Telugu Desam | 568463 |
23 | Andhra Pradesh | 23 - Kakinada | 709101 | 558689 | 709189 | 541310 | 1418290 | 1099999 | 0.787884 | 0.763280 | 0.775581 | THOTA NARASIMHAM | TDP | Telugu Desam | 514402 |
24 | Andhra Pradesh | 24 - Amalapuram | 682607 | 568534 | 675259 | 552393 | 1357866 | 1120927 | 0.832886 | 0.818046 | 0.825506 | DR PANDULA RAVINDRA BABU | TDP | Telugu Desam | 594547 |
25 | Andhra Pradesh | 25 - Rajahmundry | 701707 | 577999 | 719581 | 576382 | 1421288 | 1154381 | 0.823704 | 0.800997 | 0.812208 | MURALI MOHAN MAGANTI | TDP | Telugu Desam | 630573 |
26 | Andhra Pradesh | 26 - Narsapuram | 652668 | 539357 | 672475 | 549594 | 1325143 | 1088951 | 0.826388 | 0.817271 | 0.821761 | GOKARAJU GANGA RAJU | BJP | Bharatiya Janata Party | 540306 |
27 | Andhra Pradesh | 27 - Eluru | 706916 | 597603 | 720844 | 604093 | 1427760 | 1201696 | 0.845366 | 0.838036 | 0.841665 | MAGANTI VENKATESWARA RAO (BABU) | TDP | Telugu Desam | 623471 |
28 | Andhra Pradesh | 28 - Machilipatnam | 675774 | 567908 | 693537 | 573157 | 1369311 | 1141065 | 0.840382 | 0.826426 | 0.833313 | KONAKALLA NARAYANA RAO | TDP | Telugu Desam | 587280 |
29 | Andhra Pradesh | 29 - Vijayawada | 781156 | 602198 | 783357 | 592877 | 1564513 | 1195075 | 0.770906 | 0.756841 | 0.763864 | KESINENI SRINIVAS | TDP | Telugu Desam | 592696 |
30 | Andhra Pradesh | 30 - Guntur | 773027 | 617483 | 798989 | 627443 | 1572016 | 1244926 | 0.798786 | 0.785296 | 0.791930 | JAYADEV GALLA | TDP | Telugu Desam | 618417 |
31 | Andhra Pradesh | 31 - Narasaraopet | 748465 | 638080 | 766396 | 643978 | 1514861 | 1282058 | 0.852518 | 0.840268 | 0.846321 | SAMBASIVA RAO RAYAPATI | TDP | Telugu Desam | 632464 |
32 | Andhra Pradesh | 32 - Bapatla | 686482 | 587223 | 706483 | 597411 | 1392965 | 1184634 | 0.855409 | 0.845613 | 0.850441 | MALYADRI SRIRAM | TDP | Telugu Desam | 578145 |
33 | Andhra Pradesh | 33 - Ongole | 736245 | 603025 | 734238 | 605200 | 1470483 | 1208225 | 0.819055 | 0.824256 | 0.821652 | Y.V.SUBBA REDDY | YSRCP | Yuvajana Sramika Rythu Congress Party | 589960 |
34 | Andhra Pradesh | 34 - Nandyal | 783266 | 603562 | 793862 | 601394 | 1577128 | 1204956 | 0.770571 | 0.757555 | 0.764019 | S.P.Y REDDY | YSRCP | Yuvajana Sramika Rythu Congress Party | 622411 |
35 | Andhra Pradesh | 35 - Kurnool | 738791 | 544802 | 743016 | 520930 | 1481807 | 1065732 | 0.737424 | 0.701102 | 0.719211 | BUTTA RENUKA | YSRCP | Yuvajana Sramika Rythu Congress Party | 472782 |
36 | Andhra Pradesh | 36 - Anantapur | 775509 | 612890 | 761403 | 592164 | 1536912 | 1205054 | 0.790307 | 0.777727 | 0.784075 | J.C. DIVAKAR REDDI | TDP | Telugu Desam | 606509 |
37 | Andhra Pradesh | 37 - Hindupur | 734638 | 601932 | 711865 | 575325 | 1446503 | 1177257 | 0.819359 | 0.808194 | 0.813864 | KRISTAPPA NIMMALA | TDP | Telugu Desam | 604291 |
38 | Andhra Pradesh | 38 - Kadapa | 765036 | 588805 | 785543 | 611857 | 1550579 | 1200662 | 0.769644 | 0.778897 | 0.774331 | Y.S. AVINASH REDDY | YSRCP | Yuvajana Sramika Rythu Congress Party | 671983 |
39 | Andhra Pradesh | 39 - Nellore | 796583 | 593468 | 809557 | 594180 | 1606140 | 1187648 | 0.745017 | 0.733957 | 0.739442 | MEKAPATI RAJAMOHAN REDDY | YSRCP | Yuvajana Sramika Rythu Congress Party | 576396 |
40 | Andhra Pradesh | 40 - Tirupati | 778778 | 604834 | 795766 | 608230 | 1574544 | 1213064 | 0.776645 | 0.764333 | 0.770422 | VARAPRASAD RAO VELAGAPALLI | YSRCP | Yuvajana Sramika Rythu Congress Party | 580376 |
41 | Andhra Pradesh | 41 - Rajampet | 735347 | 573019 | 752151 | 585298 | 1487498 | 1158317 | 0.779250 | 0.778166 | 0.778702 | P.V.MIDHUN REDDY | YSRCP | Yuvajana Sramika Rythu Congress Party | 601752 |
42 | Andhra Pradesh | 42 - Chittoor | 723996 | 598259 | 728145 | 600656 | 1452141 | 1198915 | 0.826329 | 0.824913 | 0.825619 | NARAMALLI SIVAPRASAD | TDP | Telugu Desam | 594862 |
43 | Arunachal Pradesh | 1 - ARUNACHAL WEST | 219334 | 159978 | 227181 | 175687 | 446515 | 335665 | 0.729381 | 0.773335 | 0.751744 | KIREN RIJIJU | BJP | Bharatiya Janata Party | 169367 |
44 | Arunachal Pradesh | 2 - ARUNACHAL EAST | 160293 | 129313 | 152579 | 131978 | 312872 | 261291 | 0.806729 | 0.864981 | 0.835137 | NINONG ERING | INC | Indian National Congress | 118455 |
45 | Assam | 1 - Karimganj | 615198 | 482484 | 550799 | 404436 | 1165997 | 886920 | 0.784274 | 0.734271 | 0.760654 | RADHESHYAM BISWAS | AIUDF | All India United Democratic Front | 362866 |
46 | Assam | 2 - Silchar | 554540 | 428949 | 505635 | 370881 | 1060175 | 799830 | 0.773522 | 0.733496 | 0.754432 | SUSHMITA DEV | INC | Indian National Congress | 336451 |
47 | Assam | 3 - Autonomous District | 358880 | 279409 | 343010 | 263871 | 701890 | 543280 | 0.778558 | 0.769281 | 0.774024 | BIREN SINGH ENGTI | INC | Indian National Congress | 213152 |
48 | Assam | 4 - Dhubri | 798124 | 709191 | 754430 | 660433 | 1552554 | 1369624 | 0.888572 | 0.875407 | 0.882175 | BADRUDDIN AJMAL | AIUDF | All India United Democratic Front | 592569 |
49 | Assam | 5 - Kokrajhar | 776071 | 636657 | 729405 | 587212 | 1505476 | 1223869 | 0.820359 | 0.805056 | 0.812945 | NABA KUMAR SARANIA (HIRA) | IND | Independent | 634428 |
50 | Assam | 6 - Barpeta | 755559 | 634405 | 674616 | 571458 | 1430175 | 1205863 | 0.839650 | 0.847086 | 0.843158 | SIRAJ UDDIN AJMAL | AIUDF | All India United Democratic Front | 394702 |
51 | Assam | 7 - Gauhati | 988067 | 785494 | 934203 | 726235 | 1922270 | 1511729 | 0.794981 | 0.777385 | 0.786429 | BIJOYA CHAKRAVARTY | BJP | Bharatiya Janata Party | 764985 |
52 | Assam | 8 - Mangaldoi | 791539 | 651272 | 724137 | 581965 | 1515676 | 1233237 | 0.822792 | 0.803667 | 0.813655 | RAMEN DEKA | BJP | Bharatiya Janata Party | 486357 |
53 | Assam | 9 - Tezpur | 654866 | 505643 | 604702 | 475045 | 1259568 | 980688 | 0.772132 | 0.785585 | 0.778591 | RAM PRASAD SARMAH | BJP | Bharatiya Janata Party | 446511 |
54 | Assam | 10 - Nowgong | 792424 | 639392 | 731457 | 590682 | 1523881 | 1230074 | 0.806881 | 0.807542 | 0.807198 | RAJEN GOHAIN | BJP | Bharatiya Janata Party | 494146 |
55 | Assam | 11 - Kaliabor | 752785 | 605292 | 705080 | 561198 | 1457865 | 1166490 | 0.804070 | 0.795935 | 0.800136 | GOURAV GOGOI | INC | Indian National Congress | 443315 |
56 | Assam | 12 - Jorhat | 634236 | 483829 | 600212 | 447507 | 1234448 | 931336 | 0.762853 | 0.745582 | 0.754455 | KAMAKHYA PRASAD TASA | BJP | Bharatiya Janata Party | 456420 |
57 | Assam | 13 - Dibrugarh | 579657 | 462412 | 544648 | 428556 | 1124305 | 890968 | 0.797734 | 0.786849 | 0.792461 | RAMESWAR TELI | BJP | Bharatiya Janata Party | 494364 |
58 | Assam | 14 - Lakhimpur | 735263 | 572334 | 695731 | 539641 | 1430994 | 1111975 | 0.778407 | 0.775646 | 0.777065 | SARBANANDA SONOWAL | BJP | Bharatiya Janata Party | 612543 |
59 | Bihar | 1 - Valmiki Nagar | 786297 | 484621 | 670279 | 415493 | 1456576 | 900114 | 0.616333 | 0.619881 | 0.617966 | SATISH CHANDRA DUBEY | BJP | Bharatiya Janata Party | 364011 |
... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
543 rows × 15 columns
csv_data["Winner Percentage"] = csv_data["Total Votes Polled"] / csv_data["Total Voters"]
csv_data.sort("Winner Percentage", ascending=False)
State | PC Name | Male Electors | Male Voters | Female Electors | Female Voters | Total Electors | Total Voters | Male Turnout | Female Turnout | Total Turnout | Candidate Name | Party Abbreviation | Party Name | Total Votes Polled | Winner Percentage | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
138 | Gujarat | 24 - Surat | 803829 | 539368 | 680239 | 408554 | 1484068 | 947922 | 0.670998 | 0.600604 | 0.638732 | DARSHANA VIKRAM JARDOSH | BJP | Bharatiya Janata Party | 718412 | 0.757881 |
134 | Gujarat | 20 - Vadodara | 849077 | 625045 | 789244 | 536532 | 1638321 | 1161577 | 0.736146 | 0.679805 | 0.709005 | NARENDRA MODI | BJP | Bharatiya Janata Party | 845464 | 0.727859 |
139 | Gujarat | 25 - Navsari | 972090 | 649206 | 792532 | 511541 | 1764622 | 1160747 | 0.667846 | 0.645452 | 0.657788 | C. R. PATIL | BJP | Bharatiya Janata Party | 820831 | 0.707158 |
278 | Maharashtra | 26 - Mumbai North | 972645 | 527803 | 811225 | 418759 | 1783870 | 946562 | 0.542647 | 0.516206 | 0.530623 | GOPAL CHINAYYA SHETTY | BJP | Bharatiya Janata Party | 664004 | 0.701490 |
120 | Gujarat | 6 - Gandhinagar | 900744 | 620889 | 833228 | 514606 | 1733972 | 1135495 | 0.689307 | 0.617605 | 0.654852 | L.K.ADVANI | BJP | Bharatiya Janata Party | 773539 | 0.681235 |
355 | Rajasthan | 7 - Jaipur | 1047468 | 716874 | 910350 | 579932 | 1957818 | 1296806 | 0.684387 | 0.637043 | 0.662373 | RAMCHARAN BOHARA | BJP | Bharatiya Janata Party | 863358 | 0.665757 |
241 | Madhya Pradesh | 18 - VIDISHA | 872410 | 621326 | 761960 | 452147 | 1634370 | 1073473 | 0.712195 | 0.593400 | 0.656811 | SUSHMA SWARAJ | BJP | Bharatiya Janata Party | 714348 | 0.665455 |
364 | Rajasthan | 16 - Jodhpur | 910466 | 600132 | 816897 | 478466 | 1727363 | 1078598 | 0.659148 | 0.585712 | 0.624419 | GAJENDRASINGH SHEKHAWAT | BJP | Bharatiya Janata Party | 713515 | 0.661521 |
370 | Rajasthan | 22 - Rajsamand | 879526 | 508738 | 819875 | 473381 | 1699401 | 982119 | 0.578423 | 0.577382 | 0.577921 | HARIOM SINGH RATHORE | BJP | Bharatiya Janata Party | 644794 | 0.656533 |
415 | Tripura | 2 - Tripura East | 581599 | 489156 | 558670 | 461954 | 1140269 | 951110 | 0.841054 | 0.826882 | 0.834110 | JITENDRA CHOUDHURY | CPM | Communist Party of India (Marxist) | 623771 | 0.655835 |
255 | Maharashtra | 3 - Jalgaon | 909027 | 594892 | 798906 | 395440 | 1707933 | 990332 | 0.654427 | 0.494977 | 0.579842 | A.T. NANA PATIL | BJP | Bharatiya Janata Party | 647773 | 0.654097 |
363 | Rajasthan | 15 - Pali | 994082 | 581099 | 898948 | 514488 | 1893030 | 1095587 | 0.584558 | 0.572322 | 0.578748 | P P CHOUDHARY | BJP | Bharatiya Janata Party | 711772 | 0.649672 |
310 | NCT OF Delhi | 4 - NEW DELHI | 830322 | 546295 | 659825 | 423517 | 1490147 | 969812 | 0.657932 | 0.641863 | 0.650816 | UDIT RAJ | BJP | Bharatiya Janata Party | 629860 | 0.649466 |
249 | Madhya Pradesh | 26 - INDORE | 1106461 | 736759 | 1008842 | 580058 | 2115303 | 1316817 | 0.665870 | 0.574974 | 0.622519 | SUMITRA MAHAJAN (TAI) | BJP | Bharatiya Janata Party | 854972 | 0.649272 |
240 | Madhya Pradesh | 17 - HOSHANGABAD | 835492 | 593957 | 732635 | 437218 | 1568127 | 1031175 | 0.710907 | 0.596775 | 0.657584 | UDAY PRATAP SINGH | BJP | Bharatiya Janata Party | 669128 | 0.648899 |
313 | NCT OF Delhi | 7 - SOUTH DELHI | 1005289 | 638406 | 747452 | 464004 | 1752741 | 1102410 | 0.635047 | 0.620781 | 0.628963 | NEIPHIU RIO | NPF | Naga Peoples Front | 713372 | 0.647102 |
121 | Gujarat | 7 - Ahmedabad East | 852765 | 560074 | 749067 | 425451 | 1601832 | 985525 | 0.656774 | 0.567975 | 0.615249 | PARESH RAWAL | BJP | Bharatiya Janata Party | 633582 | 0.642888 |
122 | Gujarat | 8 - Ahmedabad West | 800933 | 534008 | 733467 | 430601 | 1534400 | 964609 | 0.666732 | 0.587076 | 0.628656 | DR. KIRIT P SOLANKI | BJP | Bharatiya Janata Party | 617104 | 0.639745 |
451 | Uttar Pradesh | 36 - Rae Bareli | 857875 | 437735 | 737079 | 387401 | 1594954 | 825136 | 0.510255 | 0.525590 | 0.517342 | SONIA GANDHI | INC | Indian National Congress | 526434 | 0.637997 |
242 | Madhya Pradesh | 19 - BHOPAL | 1039004 | 639683 | 917932 | 490499 | 1956936 | 1130182 | 0.615669 | 0.534352 | 0.577526 | ALOK SANJAR | BJP | Bharatiya Janata Party | 714178 | 0.631914 |
245 | Madhya Pradesh | 22 - UJJAIN | 790889 | 571525 | 734592 | 444880 | 1525481 | 1016405 | 0.722636 | 0.605615 | 0.666285 | PROF. CHINTAMANI MALVIYA | BJP | Bharatiya Janata Party | 641101 | 0.630753 |
350 | Rajasthan | 2 - Bikaner | 847064 | 526983 | 744004 | 402768 | 1591068 | 929751 | 0.622129 | 0.541352 | 0.584357 | ARJUN RAM MEGHWAL | BJP | Bharatiya Janata Party | 584932 | 0.629128 |
125 | Gujarat | 11 - Porbandar | 807383 | 471495 | 731840 | 337938 | 1539223 | 809433 | 0.583979 | 0.461765 | 0.525871 | RADADIYA VITHALBHAI HANSRAJBHAI | BJP | Bharatiya Janata Party | 508437 | 0.628140 |
414 | Tripura | 1 - Tripura West | 635976 | 546566 | 612574 | 526183 | 1248550 | 1072749 | 0.859413 | 0.858971 | 0.859196 | SANKAR PRASAD DATTA | CPM | Communist Party of India (Marxist) | 671665 | 0.626116 |
354 | Rajasthan | 6 - Jaipur Rural | 906275 | 554084 | 793187 | 459607 | 1699462 | 1013691 | 0.611386 | 0.579443 | 0.596478 | RAJYAVARDHAN SINGH RATHORE | BJP | Bharatiya Janata Party | 632930 | 0.624382 |
252 | Madhya Pradesh | 29 - BETUL | 836835 | 574150 | 770987 | 473569 | 1607822 | 1047719 | 0.686097 | 0.614237 | 0.651639 | JYOTI DHURVE | BJP | Bharatiya Janata Party | 643651 | 0.614336 |
280 | Maharashtra | 28 - Mumbai North East | 923016 | 485775 | 745341 | 375986 | 1668357 | 861761 | 0.526291 | 0.504448 | 0.516533 | KIRIT SOMAIYA | BJP | Bharatiya Janata Party | 525285 | 0.609548 |
307 | NCT OF Delhi | 1 - CHANDNI CHOWK | 791317 | 550825 | 655911 | 431038 | 1447228 | 981863 | 0.696086 | 0.657159 | 0.678444 | MANOJ TIWARI | BJP | Bharatiya Janata Party | 596125 | 0.607137 |
356 | Rajasthan | 8 - Alwar | 871339 | 587242 | 756728 | 475063 | 1628067 | 1062305 | 0.673954 | 0.627786 | 0.652495 | CHAND NATH | BJP | Bharatiya Janata Party | 642278 | 0.604608 |
332 | Orissa | 19 - Aska | 750999 | 449485 | 657781 | 446796 | 1408780 | 896281 | 0.598516 | 0.679247 | 0.636211 | LADU KISHORE SWAIN | BJD | Biju Janata Dal | 541473 | 0.604133 |
357 | Rajasthan | 9 - BHARATPUR | 911069 | 548105 | 775828 | 414327 | 1686897 | 962432 | 0.601606 | 0.534045 | 0.570534 | BAHADUR SINGH | BJP | Bharatiya Janata Party | 579825 | 0.602458 |
246 | Madhya Pradesh | 23 - MANDSOUR | 838076 | 640484 | 788495 | 520865 | 1626571 | 1161349 | 0.764231 | 0.660581 | 0.713986 | SUDHIR GUPTA | BJP | Bharatiya Janata Party | 698335 | 0.601314 |
256 | Maharashtra | 4 - Raver | 842682 | 554159 | 750688 | 455054 | 1593370 | 1009213 | 0.657613 | 0.606183 | 0.633383 | KHADASE RAKSHA NIKHIL | BJP | Bharatiya Janata Party | 605452 | 0.599925 |
369 | Rajasthan | 21 - Chittorgarh | 928572 | 632047 | 889575 | 540582 | 1818147 | 1172629 | 0.680666 | 0.607686 | 0.644958 | CHANDRA PRAKASH JOSHI | BJP | Bharatiya Janata Party | 703236 | 0.599709 |
129 | Gujarat | 15 - Bhavnagar | 834571 | 519525 | 759960 | 397877 | 1594531 | 917402 | 0.622505 | 0.523550 | 0.575343 | DR. BHARATIBEN DHIRUBHAI SHIYAL | BJP | Bharatiya Janata Party | 549529 | 0.599006 |
429 | Uttar Pradesh | 14 - Bulandshahr | 930831 | 549484 | 805616 | 460226 | 1736447 | 1009710 | 0.590316 | 0.571272 | 0.581480 | BHOLA SINGH | BJP | Bharatiya Janata Party | 604449 | 0.598636 |
436 | Uttar Pradesh | 21 - Mainpuri | 900568 | 580173 | 752497 | 419092 | 1653065 | 999265 | 0.644230 | 0.556935 | 0.604492 | MULAYAM SINGH YADAV | SP | Samajwadi Party | 595918 | 0.596356 |
115 | Gujarat | 1 - Kachchh | 806343 | 520905 | 727439 | 425335 | 1533782 | 946240 | 0.646009 | 0.584702 | 0.616933 | CHAVDA VINOD LAKHAMASHI | BJP | Bharatiya Janata Party | 562855 | 0.594833 |
497 | Uttarakhand | 2 - Garhwal | 652891 | 323143 | 616192 | 358881 | 1269083 | 682024 | 0.494942 | 0.582417 | 0.537415 | (MAJ GEN (RETD.) ) BHUWAN CHANDRA KHANDURI (AVSM) | BJP | Bharatiya Janata Party | 405690 | 0.594832 |
131 | Gujarat | 17 - Kheda | 833232 | 542955 | 766244 | 412951 | 1599476 | 955906 | 0.651625 | 0.538929 | 0.597637 | CHAUHAN DEVUSINH JESINGBHAI (CHAUHAN DEVUSINH) | BJP | Bharatiya Janata Party | 568235 | 0.594447 |
288 | Maharashtra | 36 - Shirur | 973236 | 613828 | 850876 | 475678 | 1824112 | 1089506 | 0.630708 | 0.559045 | 0.597280 | ADHALRAO SHIVAJI DATTATREY | SHS | Shivsena | 643415 | 0.590557 |
243 | Madhya Pradesh | 20 - RAJGARH | 827001 | 598652 | 751747 | 412072 | 1578748 | 1010724 | 0.723883 | 0.548153 | 0.640206 | RODMAL NAGAR | BJP | Bharatiya Janata Party | 596727 | 0.590396 |
418 | Uttar Pradesh | 3 - Muzaffarnagar | 875186 | 620606 | 713297 | 486828 | 1588483 | 1107434 | 0.709113 | 0.682504 | 0.697165 | (DR.) SANJEEV KUMAR BALYAN | BJP | Bharatiya Janata Party | 653391 | 0.590004 |
373 | Rajasthan | 25 - JHALAWAR-BARAN | 868977 | 635659 | 800865 | 510705 | 1669842 | 1146364 | 0.731503 | 0.637692 | 0.686510 | DUSHYANT SINGH | BJP | Bharatiya Janata Party | 676102 | 0.589780 |
124 | Gujarat | 10 - Rajkot | 864760 | 593333 | 790957 | 463736 | 1655717 | 1057069 | 0.686124 | 0.586297 | 0.638436 | KUNDARIYA MOHANBHAI KALYANJIBHAI | BJP | Bharatiya Janata Party | 621524 | 0.587969 |
113 | Goa | 1 - North Goa | 255870 | 200184 | 259571 | 206447 | 515441 | 406631 | 0.782366 | 0.795339 | 0.788899 | SHRIPAD YESSO NAIK | BJP | Bharatiya Janata Party | 237903 | 0.585059 |
296 | Maharashtra | 44 - Sangli | 861582 | 558707 | 787525 | 487952 | 1649107 | 1046659 | 0.648466 | 0.619602 | 0.634682 | SANJAYKAKA PATIL | BJP | Bharatiya Janata Party | 611563 | 0.584300 |
293 | Maharashtra | 41 - Latur | 897919 | 578053 | 784688 | 479103 | 1682607 | 1057156 | 0.643770 | 0.610565 | 0.628285 | DR. SUNIL BALIRAM GAIKWAD | BJP | Bharatiya Janata Party | 616509 | 0.583177 |
244 | Madhya Pradesh | 21 - DEWAS | 843555 | 654121 | 773660 | 489847 | 1617215 | 1143968 | 0.775434 | 0.633155 | 0.707369 | MANOHAR UNTWAL | BJP | Bharatiya Janata Party | 665646 | 0.581875 |
499 | Uttarakhand | 4 - Nainital-udhamsingh Nagar | 857781 | 590700 | 753029 | 510735 | 1610810 | 1101435 | 0.688637 | 0.678241 | 0.683777 | BHAGAT SINGH KOSHYARI | BJP | Bharatiya Janata Party | 636769 | 0.578127 |
118 | Gujarat | 4 - Mahesana | 777821 | 544710 | 720398 | 459548 | 1498219 | 1004258 | 0.700303 | 0.637908 | 0.670301 | PATEL JAYSHREEBEN KANUBHAI | BJP | Bharatiya Janata Party | 580250 | 0.577790 |
150 | Haryana | 10 - Faridabad | 969407 | 651411 | 770945 | 479315 | 1740352 | 1130726 | 0.671969 | 0.621724 | 0.649711 | KRISHAN PAL | BJP | Bharatiya Janata Party | 652516 | 0.577077 |
496 | Uttarakhand | 1 - Tehri Garhwal | 712039 | 403088 | 640806 | 373126 | 1352845 | 776214 | 0.566104 | 0.582276 | 0.573764 | MALA RAJYA LAXMI SHAH | BJP | Bharatiya Janata Party | 446733 | 0.575528 |
286 | Maharashtra | 34 - Pune | 949567 | 533686 | 886269 | 459588 | 1835836 | 993274 | 0.562031 | 0.518565 | 0.541047 | ANIL SHIROLE | BJP | Bharatiya Janata Party | 569825 | 0.573684 |
116 | Gujarat | 2 - Banaskantha | 796124 | 513893 | 719587 | 372741 | 1515711 | 886634 | 0.645494 | 0.517993 | 0.584962 | CHAUDHARY HARIBHAI PARTHIBHAI | BJP | Bharatiya Janata Party | 507856 | 0.572791 |
290 | Maharashtra | 38 - Shirdi | 765921 | 520229 | 693791 | 412416 | 1459712 | 932645 | 0.679220 | 0.594438 | 0.638924 | LOKHANDE SADASHIV KISAN | SHS | Shivsena | 532936 | 0.571424 |
371 | Rajasthan | 23 - Bhilwara | 904030 | 581524 | 850847 | 522566 | 1754877 | 1104090 | 0.643257 | 0.614172 | 0.629155 | SUBHASH BAHERIA | BJP | Bharatiya Janata Party | 630317 | 0.570893 |
151 | Himachal Pradesh | 1 - Kangra | 645888 | 392927 | 612713 | 406518 | 1258601 | 799445 | 0.608352 | 0.663472 | 0.635185 | SHANTA KUMAR | BJP | Bharatiya Janata Party | 456163 | 0.570600 |
251 | Madhya Pradesh | 28 - KHANDWA | 912747 | 677574 | 846663 | 579753 | 1759410 | 1257327 | 0.742346 | 0.684751 | 0.714630 | NANDKUMAR SINGH CHOUHAN (NANDU BHAIYA) | BJP | Bharatiya Janata Party | 717357 | 0.570541 |
289 | Maharashtra | 37 - Ahmadnagar | 898819 | 595960 | 800589 | 466358 | 1699408 | 1062318 | 0.663048 | 0.582519 | 0.625111 | GANDHI DILIPKUMAR MANSUKHLAL | BJP | Bharatiya Janata Party | 605185 | 0.569683 |
... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
543 rows × 16 columns
results = pd.DataFrame(csv_data["Party Abbreviation"].value_counts(), columns=["Seats"])
results["Seats Percentage"] = results["Seats"] / len(winners)
results
Seats | Seats Percentage | |
---|---|---|
BJP | 282 | 0.519337 |
INC | 44 | 0.081031 |
ADMK | 37 | 0.068140 |
AITC | 34 | 0.062615 |
BJD | 20 | 0.036832 |
SHS | 18 | 0.033149 |
TDP | 16 | 0.029466 |
TRS | 11 | 0.020258 |
CPM | 9 | 0.016575 |
YSRCP | 9 | 0.016575 |
LJP | 6 | 0.011050 |
NCP | 6 | 0.011050 |
SP | 5 | 0.009208 |
AAAP | 4 | 0.007366 |
RJD | 4 | 0.007366 |
SAD | 4 | 0.007366 |
AIUDF | 3 | 0.005525 |
IND | 3 | 0.005525 |
BLSP | 3 | 0.005525 |
JKPDP | 3 | 0.005525 |
INLD | 2 | 0.003683 |
JMM | 2 | 0.003683 |
IUML | 2 | 0.003683 |
JD(U) | 2 | 0.003683 |
AD | 2 | 0.003683 |
JD(S) | 2 | 0.003683 |
RSP | 1 | 0.001842 |
KEC(M) | 1 | 0.001842 |
CPI | 1 | 0.001842 |
SDF | 1 | 0.001842 |
AINRC | 1 | 0.001842 |
SWP | 1 | 0.001842 |
NPEP | 1 | 0.001842 |
AIMIM | 1 | 0.001842 |
NPF | 1 | 0.001842 |
PMK | 1 | 0.001842 |
36 rows × 2 columns
all_votes = pd.pivot_table(results_data, values="Total Votes Polled", rows="Party Abbreviation", aggfunc="sum")
all_votes_average = pd.pivot_table(results_data, values="Total Votes Polled", rows="Party Abbreviation", aggfunc="mean")
get_total_votes = lambda x: all_votes[x]
get_average_votes = lambda x: all_votes_average[x]
results["Total Votes"] = pd.Series(results.index.values).apply(get_total_votes).values
results["Average Votes"] = pd.Series(results.index.values).apply(get_average_votes).values
results
Seats | Seats Percentage | Total Votes | Average Votes | |
---|---|---|---|---|
BJP | 282 | 0.519337 | 171657549 | 401069.039720 |
INC | 44 | 0.081031 | 106938242 | 230470.349138 |
ADMK | 37 | 0.068140 | 18115825 | 452895.625000 |
AITC | 34 | 0.062615 | 21259681 | 162287.641221 |
BJD | 20 | 0.036832 | 9491497 | 451976.047619 |
SHS | 18 | 0.033149 | 10262982 | 176947.965517 |
TDP | 16 | 0.029466 | 14094545 | 469818.166667 |
TRS | 11 | 0.020258 | 6736490 | 396264.117647 |
CPM | 9 | 0.016575 | 17986773 | 193406.161290 |
YSRCP | 9 | 0.016575 | 13991280 | 368191.578947 |
LJP | 6 | 0.011050 | 2295929 | 327989.857143 |
NCP | 6 | 0.011050 | 8635554 | 239876.500000 |
SP | 5 | 0.009208 | 18672916 | 94786.375635 |
AAAP | 4 | 0.007366 | 11325635 | 26216.747685 |
RJD | 4 | 0.007366 | 7442313 | 248077.100000 |
SAD | 4 | 0.007366 | 3636148 | 363614.800000 |
AIUDF | 3 | 0.005525 | 2333040 | 129613.333333 |
IND | 3 | 0.005525 | 16743719 | 5175.801855 |
BLSP | 3 | 0.005525 | 1078473 | 269618.250000 |
JKPDP | 3 | 0.005525 | 732644 | 146528.800000 |
INLD | 2 | 0.003683 | 2799899 | 279989.900000 |
JMM | 2 | 0.003683 | 1637990 | 77999.523810 |
IUML | 2 | 0.003683 | 1100096 | 44003.840000 |
JD(U) | 2 | 0.003683 | 5992196 | 64432.215054 |
AD | 2 | 0.003683 | 821820 | 117402.857143 |
JD(S) | 2 | 0.003683 | 3731481 | 109749.441176 |
RSP | 1 | 0.001842 | 1666380 | 277730.000000 |
KEC(M) | 1 | 0.001842 | 424194 | 424194.000000 |
CPI | 1 | 0.001842 | 4327298 | 64586.537313 |
SDF | 1 | 0.001842 | 163698 | 163698.000000 |
AINRC | 1 | 0.001842 | 255826 | 255826.000000 |
SWP | 1 | 0.001842 | 1105073 | 552536.500000 |
NPEP | 1 | 0.001842 | 576444 | 82349.142857 |
AIMIM | 1 | 0.001842 | 685729 | 137145.800000 |
NPF | 1 | 0.001842 | 994505 | 497252.500000 |
PMK | 1 | 0.001842 | 1827566 | 203062.888889 |
36 rows × 4 columns
all_winning_votes = pd.pivot_table(csv_data, values="Total Votes Polled", rows="Party Abbreviation", aggfunc="sum")
all_winning_votes_average = pd.pivot_table(csv_data, values="Total Votes Polled", rows="Party Abbreviation", aggfunc="mean")
all_winning_votes_percentages = pd.pivot_table(csv_data, values="Winner Percentage", rows="Party Abbreviation", aggfunc="mean")
average_winning_elecors = pd.pivot_table(csv_data, values="Total Electors", rows="Party Abbreviation", aggfunc="mean")
get_total_winning_votes = lambda x: all_winning_votes[x]
get_average_winning_votes = lambda x: all_winning_votes_average[x]
get_average_winning_percentages = lambda x: all_winning_votes_percentages[x]
get_average_winning_elecors = lambda x: average_winning_elecors[x]
results["Total Winning Votes"] = pd.Series(results.index.values).apply(get_total_winning_votes).values
results["Average Winning Votes"] = pd.Series(results.index.values).apply(get_average_winning_votes).values
results["Average Winning Percentage"] = pd.Series(results.index.values).apply(get_average_winning_percentages).values
results["Average Winning Electors"] = pd.Series(results.index.values).apply(get_average_winning_elecors).values
results["Loosing Votes"] = results["Total Votes"] - results["Total Winning Votes"]
results["Winning Votes Ratio"] = results["Total Winning Votes"] / results["Total Votes"]
results
Seats | Seats Percentage | Total Votes | Average Votes | Total Winning Votes | Average Winning Votes | Average Winning Percentage | Average Winning Electors | Loosing Votes | Winning Votes Ratio | |
---|---|---|---|---|---|---|---|---|---|---|
BJP | 282 | 0.519337 | 171657549 | 401069.039720 | 139553310 | 494869 | 0.493188 | 1606886 | 32104239 | 0.812975 |
INC | 44 | 0.081031 | 106938242 | 230470.349138 | 18219598 | 414081 | 0.428075 | 1384055 | 88718644 | 0.170375 |
ADMK | 37 | 0.068140 | 18115825 | 452895.625000 | 17415881 | 470699 | 0.451634 | 1413200 | 699944 | 0.961363 |
AITC | 34 | 0.062615 | 21259681 | 162287.641221 | 18366652 | 540195 | 0.431486 | 1512020 | 2893029 | 0.863919 |
BJD | 20 | 0.036832 | 9491497 | 451976.047619 | 9169818 | 458490 | 0.449398 | 1389275 | 321679 | 0.966109 |
SHS | 18 | 0.033149 | 10262982 | 176947.965517 | 9010919 | 500606 | 0.510340 | 1676883 | 1252063 | 0.878002 |
TDP | 16 | 0.029466 | 14094545 | 469818.166667 | 9362168 | 585135 | 0.493163 | 1554833 | 4732377 | 0.664241 |
TRS | 11 | 0.020258 | 6736490 | 396264.117647 | 5307344 | 482485 | 0.430386 | 1532891 | 1429146 | 0.787850 |
CPM | 9 | 0.016575 | 17986773 | 193406.161290 | 4069667 | 452185 | 0.455675 | 1264327 | 13917106 | 0.226259 |
YSRCP | 9 | 0.016575 | 13991280 | 368191.578947 | 4950808 | 550089 | 0.478040 | 1495688 | 9040472 | 0.353850 |
LJP | 6 | 0.011050 | 2295929 | 327989.857143 | 1983574 | 330595 | 0.375127 | 1579884 | 312355 | 0.863953 |
NCP | 6 | 0.011050 | 8635554 | 239876.500000 | 2594704 | 432450 | 0.483694 | 1419258 | 6040850 | 0.300468 |
SP | 5 | 0.009208 | 18672916 | 94786.375635 | 2458349 | 491669 | 0.471728 | 1714211 | 16214567 | 0.131653 |
AAAP | 4 | 0.007366 | 11325635 | 26216.747685 | 1716952 | 429238 | 0.401053 | 1464262 | 9608683 | 0.151599 |
RJD | 4 | 0.007366 | 7442313 | 248077.100000 | 1429688 | 357422 | 0.367278 | 1636930 | 6012625 | 0.192103 |
SAD | 4 | 0.007366 | 3636148 | 363614.800000 | 1817385 | 454346 | 0.411916 | 1543844 | 1818763 | 0.499811 |
AIUDF | 3 | 0.005525 | 2333040 | 129613.333333 | 1350137 | 450045 | 0.389700 | 1382908 | 982903 | 0.578703 |
IND | 3 | 0.005525 | 16743719 | 5175.801855 | 1374887 | 458295 | 0.463283 | 1271567 | 15368832 | 0.082114 |
BLSP | 3 | 0.005525 | 1078473 | 269618.250000 | 1072804 | 357601 | 0.427755 | 1522716 | 5669 | 0.994743 |
JKPDP | 3 | 0.005525 | 732644 | 146528.800000 | 533629 | 177876 | 0.472012 | 1232333 | 199015 | 0.728361 |
INLD | 2 | 0.003683 | 2799899 | 279989.900000 | 1000848 | 500424 | 0.411830 | 1589081 | 1799051 | 0.357459 |
JMM | 2 | 0.003683 | 1637990 | 77999.523810 | 715322 | 357661 | 0.385344 | 1300163 | 922668 | 0.436707 |
IUML | 2 | 0.003683 | 1100096 | 44003.840000 | 816226 | 408113 | 0.473571 | 1189616 | 283870 | 0.741959 |
JD(U) | 2 | 0.003683 | 5992196 | 64432.215054 | 740808 | 370404 | 0.380420 | 1767467 | 5251388 | 0.123629 |
AD | 2 | 0.003683 | 821820 | 117402.857143 | 812325 | 406162 | 0.426682 | 1718643 | 9495 | 0.988446 |
JD(S) | 2 | 0.003683 | 3731481 | 109749.441176 | 1034211 | 517105 | 0.442053 | 1615299 | 2697270 | 0.277158 |
RSP | 1 | 0.001842 | 1666380 | 277730.000000 | 408528 | 408528 | 0.464735 | 1219415 | 1257852 | 0.245159 |
KEC(M) | 1 | 0.001842 | 424194 | 424194.000000 | 424194 | 424194 | 0.510072 | 1161463 | 0 | 1.000000 |
CPI | 1 | 0.001842 | 4327298 | 64586.537313 | 389209 | 389209 | 0.422821 | 1275288 | 3938089 | 0.089943 |
SDF | 1 | 0.001842 | 163698 | 163698.000000 | 163698 | 163698 | 0.529824 | 370611 | 0 | 1.000000 |
AINRC | 1 | 0.001842 | 255826 | 255826.000000 | 255826 | 255826 | 0.345703 | 901357 | 0 | 1.000000 |
SWP | 1 | 0.001842 | 1105073 | 552536.500000 | 640428 | 640428 | 0.538686 | 1630598 | 464645 | 0.579535 |
NPEP | 1 | 0.001842 | 576444 | 82349.142857 | 239301 | 239301 | 0.522410 | 586501 | 337143 | 0.415133 |
AIMIM | 1 | 0.001842 | 685729 | 137145.800000 | 513868 | 513868 | 0.528986 | 1823664 | 171861 | 0.749375 |
NPF | 1 | 0.001842 | 994505 | 497252.500000 | 713372 | 713372 | 0.647102 | 1752741 | 281133 | 0.717314 |
PMK | 1 | 0.001842 | 1827566 | 203062.888889 | 468194 | 468194 | 0.425111 | 1358273 | 1359372 | 0.256184 |
36 rows × 10 columns
results.describe()
Seats | Seats Percentage | Total Votes | Average Votes | Total Winning Votes | Average Winning Votes | Average Winning Percentage | Average Winning Electors | Loosing Votes | Winning Votes Ratio | |
---|---|---|---|---|---|---|---|---|---|---|
count | 36.000000 | 36.000000 | 3.600000e+01 | 36.000000 | 3.600000e+01 | 36.000000 | 36.000000 | 36.000000 | 36.000000 | 36.000000 |
mean | 15.083333 | 0.027778 | 1.365393e+07 | 236299.539018 | 7.252629e+06 | 435134.944444 | 0.453897 | 1412726.416667 | 6401299.944444 | 0.560735 |
std | 46.987156 | 0.086533 | 3.248419e+07 | 150275.821702 | 2.324585e+07 | 113343.272362 | 0.059478 | 305902.010647 | 15550652.495029 | 0.323618 |
min | 1.000000 | 0.001842 | 1.636980e+05 | 5175.801855 | 1.636980e+05 | 163698.000000 | 0.345703 | 370611.000000 | 0.000000 | 0.082114 |
25% | 1.000000 | 0.001842 | 1.094690e+06 | 115489.503151 | 6.137282e+05 | 384507.750000 | 0.420095 | 1274357.750000 | 305233.750000 | 0.253428 |
50% | 3.000000 | 0.005525 | 3.683814e+06 | 216766.619013 | 1.211470e+06 | 451115.000000 | 0.450516 | 1479975.000000 | 1308612.000000 | 0.579119 |
75% | 9.000000 | 0.016575 | 1.199205e+07 | 364758.994737 | 4.289952e+06 | 496257.750000 | 0.486061 | 1608989.250000 | 5441697.250000 | 0.863928 |
max | 282.000000 | 0.519337 | 1.716575e+08 | 552536.500000 | 1.395533e+08 | 713372.000000 | 0.647102 | 1823664.000000 | 88718644.000000 | 1.000000 |
8 rows × 10 columns
import matplotlib.pyplot as plt
plt.figure(figsize=(18,8))
cmap = plt.cm.hsv
colors = cmap(np.linspace(0., 1., len(results["Seats"])))
plt.pie(results["Seats"], labels=results.index, explode=np.array(range(len(results)))/10, autopct='%1.1f%%',
colors = colors)
plt.axis("equal")
plt.title("Indian general election 2014 results of seats per party")
plt.show();
plt.figure(figsize=(18,8))
plt.pie(results.sort("Total Votes", ascending=False)["Total Votes"], labels=results.sort("Total Votes", ascending=False).index,
explode=np.array(range(len(results)))**1.5/40, autopct='%1.1f%%', colors = colors)
plt.axis("equal")
plt.title("Indian general election 2014 results of votes per party")
plt.show();
plt.figure(figsize=(18,10))
for counter in range(len(results)):
x = results["Total Votes"][counter]
y = results["Seats"][counter]
label = "%s\n%s" % (results.index[counter], y)
plt.scatter(x,y, c = colors[counter],
s=y/x * 1e9, label =results.index[counter])
plt.annotate(label,
xy = (x, y), xytext = (-20, 20),
textcoords = 'offset points', ha = 'right', va = 'bottom',
bbox = dict(boxstyle = 'round,pad=0.5', fc = 'yellow', alpha = 0.5),
arrowprops = dict(arrowstyle = '->', connectionstyle = 'arc3,rad=0'))
plt.xscale("log")
plt.yscale("log")
plt.xlim(results["Total Votes"].min()*0.95, results["Total Votes"].max()*1.05)
plt.ylim(0)
plt.xlabel("Total Votes (log)")
plt.ylabel("Seats (log)")
plt.title("Indian General Elections 2014 Seats vs Total Votes on a log scale")
plt.grid()
plt.show();
print results
Seats Seats Percentage Total Votes Average Votes \ BJP 282 0.519337 171657549 401069.039720 INC 44 0.081031 106938242 230470.349138 ADMK 37 0.068140 18115825 452895.625000 AITC 34 0.062615 21259681 162287.641221 BJD 20 0.036832 9491497 451976.047619 SHS 18 0.033149 10262982 176947.965517 TDP 16 0.029466 14094545 469818.166667 TRS 11 0.020258 6736490 396264.117647 CPM 9 0.016575 17986773 193406.161290 YSRCP 9 0.016575 13991280 368191.578947 LJP 6 0.011050 2295929 327989.857143 NCP 6 0.011050 8635554 239876.500000 SP 5 0.009208 18672916 94786.375635 AAAP 4 0.007366 11325635 26216.747685 RJD 4 0.007366 7442313 248077.100000 SAD 4 0.007366 3636148 363614.800000 AIUDF 3 0.005525 2333040 129613.333333 IND 3 0.005525 16743719 5175.801855 BLSP 3 0.005525 1078473 269618.250000 JKPDP 3 0.005525 732644 146528.800000 INLD 2 0.003683 2799899 279989.900000 JMM 2 0.003683 1637990 77999.523810 IUML 2 0.003683 1100096 44003.840000 JD(U) 2 0.003683 5992196 64432.215054 AD 2 0.003683 821820 117402.857143 JD(S) 2 0.003683 3731481 109749.441176 RSP 1 0.001842 1666380 277730.000000 KEC(M) 1 0.001842 424194 424194.000000 CPI 1 0.001842 4327298 64586.537313 SDF 1 0.001842 163698 163698.000000 AINRC 1 0.001842 255826 255826.000000 SWP 1 0.001842 1105073 552536.500000 NPEP 1 0.001842 576444 82349.142857 AIMIM 1 0.001842 685729 137145.800000 NPF 1 0.001842 994505 497252.500000 PMK 1 0.001842 1827566 203062.888889 Total Winning Votes Average Winning Votes \ BJP 139553310 494869 INC 18219598 414081 ADMK 17415881 470699 AITC 18366652 540195 BJD 9169818 458490 SHS 9010919 500606 TDP 9362168 585135 TRS 5307344 482485 CPM 4069667 452185 YSRCP 4950808 550089 LJP 1983574 330595 NCP 2594704 432450 SP 2458349 491669 AAAP 1716952 429238 RJD 1429688 357422 SAD 1817385 454346 AIUDF 1350137 450045 IND 1374887 458295 BLSP 1072804 357601 JKPDP 533629 177876 INLD 1000848 500424 JMM 715322 357661 IUML 816226 408113 JD(U) 740808 370404 AD 812325 406162 JD(S) 1034211 517105 RSP 408528 408528 KEC(M) 424194 424194 CPI 389209 389209 SDF 163698 163698 AINRC 255826 255826 SWP 640428 640428 NPEP 239301 239301 AIMIM 513868 513868 NPF 713372 713372 PMK 468194 468194 Average Winning Percentage Average Winning Electors Loosing Votes \ BJP 0.493188 1606886 32104239 INC 0.428075 1384055 88718644 ADMK 0.451634 1413200 699944 AITC 0.431486 1512020 2893029 BJD 0.449398 1389275 321679 SHS 0.510340 1676883 1252063 TDP 0.493163 1554833 4732377 TRS 0.430386 1532891 1429146 CPM 0.455675 1264327 13917106 YSRCP 0.478040 1495688 9040472 LJP 0.375127 1579884 312355 NCP 0.483694 1419258 6040850 SP 0.471728 1714211 16214567 AAAP 0.401053 1464262 9608683 RJD 0.367278 1636930 6012625 SAD 0.411916 1543844 1818763 AIUDF 0.389700 1382908 982903 IND 0.463283 1271567 15368832 BLSP 0.427755 1522716 5669 JKPDP 0.472012 1232333 199015 INLD 0.411830 1589081 1799051 JMM 0.385344 1300163 922668 IUML 0.473571 1189616 283870 JD(U) 0.380420 1767467 5251388 AD 0.426682 1718643 9495 JD(S) 0.442053 1615299 2697270 RSP 0.464735 1219415 1257852 KEC(M) 0.510072 1161463 0 CPI 0.422821 1275288 3938089 SDF 0.529824 370611 0 AINRC 0.345703 901357 0 SWP 0.538686 1630598 464645 NPEP 0.522410 586501 337143 AIMIM 0.528986 1823664 171861 NPF 0.647102 1752741 281133 PMK 0.425111 1358273 1359372 Winning Votes Ratio BJP 0.812975 INC 0.170375 ADMK 0.961363 AITC 0.863919 BJD 0.966109 SHS 0.878002 TDP 0.664241 TRS 0.787850 CPM 0.226259 YSRCP 0.353850 LJP 0.863953 NCP 0.300468 SP 0.131653 AAAP 0.151599 RJD 0.192103 SAD 0.499811 AIUDF 0.578703 IND 0.082114 BLSP 0.994743 JKPDP 0.728361 INLD 0.357459 JMM 0.436707 IUML 0.741959 JD(U) 0.123629 AD 0.988446 JD(S) 0.277158 RSP 0.245159 KEC(M) 1.000000 CPI 0.089943 SDF 1.000000 AINRC 1.000000 SWP 0.579535 NPEP 0.415133 AIMIM 0.749375 NPF 0.717314 PMK 0.256184 [36 rows x 10 columns]