{
"metadata": {
"name": "Elections"
},
"nbformat": 3,
"nbformat_minor": 0,
"worksheets": [
{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Karnataka election results 2013\n",
"\n",
"Unfortunately does not provide the Karnataka 2013 assembly results as a CSV file yet (as of 18 Aug 2013). But [numb_and_number](http://www.reddit.com/user/numb_and_number) [posted](http://www.reddit.com/r/india/comments/1dzn99/) a [scraper](http://pastebin.com/s7mbAcLT) and its [results](http://pastebin.com/raw.php?i=4vwCDpUA), which we'll use.\n",
"\n",
"(This sort of stuff is also available on [datameet](https://groups.google.com/forum/#!msg/datameet/oV3KE3k9JYw/z_pdvdodv-IJ))\n",
"\n",
"I've converted this into a CSV file called `karnataka-2013-results.csv`"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"import pandas as pd\n",
"data = pd.read_csv('karnataka-2013-results.csv')\n",
"data.head()"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"
\n",
"
\n",
" \n",
" \n",
" | \n",
" District | \n",
" Candidate | \n",
" Party | \n",
" Votes | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" Afzalpur | \n",
" MALIKAYYA VENKAYYA GUTTEDAR | \n",
" Indian National Congress | \n",
" 38093 | \n",
"
\n",
" \n",
" 1 | \n",
" Afzalpur | \n",
" M.Y.PATIL | \n",
" Karnataka Jantha Paksha | \n",
" 32855 | \n",
"
\n",
" \n",
" 2 | \n",
" Afzalpur | \n",
" VITTHAL HEROOR | \n",
" Janata Dal (Secular) | \n",
" 22847 | \n",
"
\n",
" \n",
" 3 | \n",
" Afzalpur | \n",
" GOVIND VISHWANATH BHAT | \n",
" Samajwadi Party | \n",
" 14648 | \n",
"
\n",
" \n",
" 4 | \n",
" Afzalpur | \n",
" DILIP R. PATIL | \n",
" Bharatiya Janata Party | \n",
" 10347 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"output_type": "pyout",
"prompt_number": 4,
"text": [
" District Candidate Party Votes\n",
"0 Afzalpur MALIKAYYA VENKAYYA GUTTEDAR Indian National Congress 38093\n",
"1 Afzalpur M.Y.PATIL Karnataka Jantha Paksha 32855\n",
"2 Afzalpur VITTHAL HEROOR Janata Dal (Secular) 22847\n",
"3 Afzalpur GOVIND VISHWANATH BHAT Samajwadi Party 14648\n",
"4 Afzalpur DILIP R. PATIL Bharatiya Janata Party 10347"
]
}
],
"prompt_number": 4
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Before we proceed, let's set some basic options to improve our display."
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"pd.set_option('display.line_width', 200)\n",
"pd.set_option('display.max_columns', 20)"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 9
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Let's ask some simple questions before we move on to the interesting ones.\n",
"\n",
"## How many people voted in Karnataka?"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"data['Votes'].sum()"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "pyout",
"prompt_number": 36,
"text": [
"31216708"
]
}
],
"prompt_number": 36
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Who got the maximum votes?"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"data[data['Votes'] == data['Votes'].max()]"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"\n",
"
\n",
" \n",
" \n",
" | \n",
" District | \n",
" Candidate | \n",
" Party | \n",
" Votes | \n",
" Rank | \n",
"
\n",
" \n",
" \n",
" \n",
" 2926 | \n",
" Yeshvanthapura | \n",
" S.T.SOMASHEKAR | \n",
" Indian National Congress | \n",
" 120380 | \n",
" 1 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"output_type": "pyout",
"prompt_number": 39,
"text": [
" District Candidate Party Votes Rank\n",
"2926 Yeshvanthapura S.T.SOMASHEKAR Indian National Congress 120380 1"
]
}
],
"prompt_number": 39
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## In how many places did each party contest?"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"data['Party'].value_counts()"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "pyout",
"prompt_number": 123,
"text": [
"Independent 1217\n",
"Indian National Congress 223\n",
"Bharatiya Janata Party 222\n",
"Janata Dal (Secular) 221\n",
"Karnataka Jantha Paksha 203\n",
"Badavara Shramikara Raitara Congress Party 175\n",
"Bahujan Samaj Party 174\n",
"Janata Dal (United) 116\n",
"Samajwadi Party 27\n",
"Nationalist Congress Party 24\n",
"SOCIAL DEMOCRATIC PARTY OF INDIA 23\n",
"Lok Satta Party 23\n",
"National People's Party 21\n",
"Bharatiya Dr. B.R.Ambedkar Janta Party 18\n",
"Samajwadi Janata Party(Karnataka) 17\n",
"Communist Party of India (Marxist-Leninist) Red Star 17\n",
"Communist Party of India (Marxist) 16\n",
"Lok Jan Shakti Party 15\n",
"Welfare Party Of India 12\n",
"Republican Party of India (A) 12\n",
"Pyramid Party of India 11\n",
"Hindusthan Nirman Dal 11\n",
"SOCIALIST UNITY CENTRE OF INDIA (COMMUNIST) 11\n",
"Sarva Janata Party 10\n",
"Ambedkar National Congress 10\n",
"Communist Party of India 8\n",
"Hindustan Janta Party 8\n",
"Communist Party of India (Marxist-Leninist) (Liberation) 8\n",
"Rani Chennamma Party 8\n",
"Karnataka Rajya Ryota Sangha 7\n",
"Karnataka Makkala Paksha 7\n",
"Sarvodaya Karnataka Paksha 6\n",
"Republican Party of India 6\n",
"Indian Union Muslim League 5\n",
"All India Anna Dravida Munnetra Kazhagam 5\n",
"Ambedkar Janatha Party 5\n",
"Bharatiya Praja Paksha 5\n",
"Bharatiya Janta Dal 4\n",
"National Development Party 3\n",
"Kannada Chalavali Vatal Paksha 3\n",
"Shubha Karnataka 2\n",
"Mahila Pradhana Paksha 2\n",
"Bharatiya Republican Paksha 2\n",
"Akhila Bharatiya Rytha Party 2\n",
"Akhil Bharatiya Muslim League (Secular) 1\n",
"Democratic Prajakranthi Party Secularist 1\n",
"Indian National League 1\n",
"Rashtriya Samaj Paksha 1\n",
"Bharatiya Peoples Party 1\n",
"People's Party of India(secular) 1\n",
"Jai Vijaya Bharathi Party 1\n",
"Akhil Bharat Hindu Mahasabha 1\n",
"All India Forward Bloc (Subhasist) 1\n",
"Vichara Jagruthi Congress Paksha 1\n",
"Karnataka Swarajya Party 1\n",
"Socialistic Democratic Party 1\n",
"Samajwadi Janata Party (Rashtriya) 1\n",
"Shivsena 1\n",
"Kamarajar Deseeya Congress 1\n",
"Length: 59, dtype: int64"
]
}
],
"prompt_number": 123
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Now let's ask interesting questions.\n",
"\n",
"# Which party won?"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"data['Rank'] = data.groupby('District')['Votes'].rank(ascending=False)\n",
"data.head()"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"\n",
"
\n",
" \n",
" \n",
" | \n",
" District | \n",
" Candidate | \n",
" Party | \n",
" Votes | \n",
" Rank | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" Afzalpur | \n",
" MALIKAYYA VENKAYYA GUTTEDAR | \n",
" Indian National Congress | \n",
" 38093 | \n",
" 1 | \n",
"
\n",
" \n",
" 1 | \n",
" Afzalpur | \n",
" M.Y.PATIL | \n",
" Karnataka Jantha Paksha | \n",
" 32855 | \n",
" 2 | \n",
"
\n",
" \n",
" 2 | \n",
" Afzalpur | \n",
" VITTHAL HEROOR | \n",
" Janata Dal (Secular) | \n",
" 22847 | \n",
" 3 | \n",
"
\n",
" \n",
" 3 | \n",
" Afzalpur | \n",
" GOVIND VISHWANATH BHAT | \n",
" Samajwadi Party | \n",
" 14648 | \n",
" 4 | \n",
"
\n",
" \n",
" 4 | \n",
" Afzalpur | \n",
" DILIP R. PATIL | \n",
" Bharatiya Janata Party | \n",
" 10347 | \n",
" 5 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"output_type": "pyout",
"prompt_number": 51,
"text": [
" District Candidate Party Votes Rank\n",
"0 Afzalpur MALIKAYYA VENKAYYA GUTTEDAR Indian National Congress 38093 1\n",
"1 Afzalpur M.Y.PATIL Karnataka Jantha Paksha 32855 2\n",
"2 Afzalpur VITTHAL HEROOR Janata Dal (Secular) 22847 3\n",
"3 Afzalpur GOVIND VISHWANATH BHAT Samajwadi Party 14648 4\n",
"4 Afzalpur DILIP R. PATIL Bharatiya Janata Party 10347 5"
]
}
],
"prompt_number": 51
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"data[data['Rank'] == 1]['Party'].value_counts()"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "pyout",
"prompt_number": 34,
"text": [
"Indian National Congress 121\n",
"Bharatiya Janata Party 40\n",
"Janata Dal (Secular) 40\n",
"Independent 9\n",
"Karnataka Jantha Paksha 6\n",
"Badavara Shramikara Raitara Congress Party 4\n",
"Sarvodaya Karnataka Paksha 1\n",
"Karnataka Makkala Paksha 1\n",
"Samajwadi Party 1\n",
"dtype: int64"
]
}
],
"prompt_number": 34
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"So it's clear that the Congress had a clear sweep. Now, let's ask a few more questions...\n",
"\n",
"# Who won by the largest margins?"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"data[data['Rank'] == 1].set_index('District').head()"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"\n",
"
\n",
" \n",
" \n",
" | \n",
" Candidate | \n",
" Party | \n",
" Votes | \n",
" Rank | \n",
"
\n",
" \n",
" District | \n",
" | \n",
" | \n",
" | \n",
" | \n",
"
\n",
" \n",
" \n",
" \n",
" Afzalpur | \n",
" MALIKAYYA VENKAYYA GUTTEDAR | \n",
" Indian National Congress | \n",
" 38093 | \n",
" 1 | \n",
"
\n",
" \n",
" Aland | \n",
" BHOJARAJ RAMCHANDRA | \n",
" Karnataka Jantha Paksha | \n",
" 67085 | \n",
" 1 | \n",
"
\n",
" \n",
" Anekal | \n",
" SHIVANNA B. | \n",
" Indian National Congress | \n",
" 105464 | \n",
" 1 | \n",
"
\n",
" \n",
" Arabhavi | \n",
" BALACHANDRA LAXMANRAO JARKIHOLI | \n",
" Bharatiya Janata Party | \n",
" 99283 | \n",
" 1 | \n",
"
\n",
" \n",
" Arkalgud | \n",
" MANJU A | \n",
" Indian National Congress | \n",
" 61369 | \n",
" 1 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"output_type": "pyout",
"prompt_number": 57,
"text": [
" Candidate Party Votes Rank\n",
"District \n",
"Afzalpur MALIKAYYA VENKAYYA GUTTEDAR Indian National Congress 38093 1\n",
"Aland BHOJARAJ RAMCHANDRA Karnataka Jantha Paksha 67085 1\n",
"Anekal SHIVANNA B. Indian National Congress 105464 1\n",
"Arabhavi BALACHANDRA LAXMANRAO JARKIHOLI Bharatiya Janata Party 99283 1\n",
"Arkalgud MANJU A Indian National Congress 61369 1"
]
}
],
"prompt_number": 57
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"rank1 = data[data['Rank'] == 1].set_index('District')\n",
"rank2 = data[data['Rank'] == 2].set_index('District')\n",
"pd.merge(rank1, rank2, left_index=True, right_index=True, suffixes=['1', '2']).head()"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"\n",
"
\n",
" \n",
" \n",
" | \n",
" Candidate1 | \n",
" Party1 | \n",
" Votes1 | \n",
" Rank1 | \n",
" Candidate2 | \n",
" Party2 | \n",
" Votes2 | \n",
" Rank2 | \n",
"
\n",
" \n",
" District | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
"
\n",
" \n",
" \n",
" \n",
" Afzalpur | \n",
" MALIKAYYA VENKAYYA GUTTEDAR | \n",
" Indian National Congress | \n",
" 38093 | \n",
" 1 | \n",
" M.Y.PATIL | \n",
" Karnataka Jantha Paksha | \n",
" 32855 | \n",
" 2 | \n",
"
\n",
" \n",
" Aland | \n",
" BHOJARAJ RAMCHANDRA | \n",
" Karnataka Jantha Paksha | \n",
" 67085 | \n",
" 1 | \n",
" SUBHASH RUKMAIAH | \n",
" Janata Dal (Secular) | \n",
" 49971 | \n",
" 2 | \n",
"
\n",
" \n",
" Anekal | \n",
" SHIVANNA B. | \n",
" Indian National Congress | \n",
" 105464 | \n",
" 1 | \n",
" A. NARAYANASWAMY | \n",
" Bharatiya Janata Party | \n",
" 65282 | \n",
" 2 | \n",
"
\n",
" \n",
" Arabhavi | \n",
" BALACHANDRA LAXMANRAO JARKIHOLI | \n",
" Bharatiya Janata Party | \n",
" 99283 | \n",
" 1 | \n",
" UTAGI RAMAPPA KAREPPA | \n",
" Indian National Congress | \n",
" 24062 | \n",
" 2 | \n",
"
\n",
" \n",
" Arkalgud | \n",
" MANJU A | \n",
" Indian National Congress | \n",
" 61369 | \n",
" 1 | \n",
" A.T RAMASWAMY | \n",
" Janata Dal (Secular) | \n",
" 52575 | \n",
" 2 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"output_type": "pyout",
"prompt_number": 70,
"text": [
" Candidate1 Party1 Votes1 Rank1 Candidate2 Party2 Votes2 Rank2\n",
"District \n",
"Afzalpur MALIKAYYA VENKAYYA GUTTEDAR Indian National Congress 38093 1 M.Y.PATIL Karnataka Jantha Paksha 32855 2\n",
"Aland BHOJARAJ RAMCHANDRA Karnataka Jantha Paksha 67085 1 SUBHASH RUKMAIAH Janata Dal (Secular) 49971 2\n",
"Anekal SHIVANNA B. Indian National Congress 105464 1 A. NARAYANASWAMY Bharatiya Janata Party 65282 2\n",
"Arabhavi BALACHANDRA LAXMANRAO JARKIHOLI Bharatiya Janata Party 99283 1 UTAGI RAMAPPA KAREPPA Indian National Congress 24062 2\n",
"Arkalgud MANJU A Indian National Congress 61369 1 A.T RAMASWAMY Janata Dal (Secular) 52575 2"
]
}
],
"prompt_number": 70
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"margins = pd.merge(rank1, rank2, left_index=True, right_index=True, suffixes=['1', '2'])\n",
"margins['Margin'] = margins['Votes1'] - margins['Votes2']"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 74
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"margins.sort('Margin', ascending=False).head()"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"\n",
"
\n",
" \n",
" \n",
" | \n",
" Candidate1 | \n",
" Party1 | \n",
" Votes1 | \n",
" Rank1 | \n",
" Candidate2 | \n",
" Party2 | \n",
" Votes2 | \n",
" Rank2 | \n",
" Margin | \n",
"
\n",
" \n",
" District | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
"
\n",
" \n",
" \n",
" \n",
" Chikkodi-Sadalga | \n",
" PRAKASH BABANNA HUKKERI | \n",
" Indian National Congress | \n",
" 102237 | \n",
" 1 | \n",
" BASAVANNI RUDRAPPA SANGAPPAGOL | \n",
" Bharatiya Janata Party | \n",
" 25649 | \n",
" 2 | \n",
" 76588 | \n",
"
\n",
" \n",
" Arabhavi | \n",
" BALACHANDRA LAXMANRAO JARKIHOLI | \n",
" Bharatiya Janata Party | \n",
" 99283 | \n",
" 1 | \n",
" UTAGI RAMAPPA KAREPPA | \n",
" Indian National Congress | \n",
" 24062 | \n",
" 2 | \n",
" 75221 | \n",
"
\n",
" \n",
" Hukkeri | \n",
" UMESH VISHWANATH KATTI | \n",
" Bharatiya Janata Party | \n",
" 81810 | \n",
" 1 | \n",
" RAVI BASAVARAJ KARALE | \n",
" Indian National Congress | \n",
" 24484 | \n",
" 2 | \n",
" 57326 | \n",
"
\n",
" \n",
" Davanagere North | \n",
" S S MALLIKARJUNA | \n",
" Indian National Congress | \n",
" 88101 | \n",
" 1 | \n",
" S A RAVINDRANATH | \n",
" Bharatiya Janata Party | \n",
" 30821 | \n",
" 2 | \n",
" 57280 | \n",
"
\n",
" \n",
" B.t.m layout | \n",
" RAMALINGAREDDY | \n",
" Indian National Congress | \n",
" 69712 | \n",
" 1 | \n",
" N. SUDHAKAR | \n",
" Bharatiya Janata Party | \n",
" 20664 | \n",
" 2 | \n",
" 49048 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"output_type": "pyout",
"prompt_number": 77,
"text": [
" Candidate1 Party1 Votes1 Rank1 Candidate2 Party2 Votes2 Rank2 Margin\n",
"District \n",
"Chikkodi-Sadalga PRAKASH BABANNA HUKKERI Indian National Congress 102237 1 BASAVANNI RUDRAPPA SANGAPPAGOL Bharatiya Janata Party 25649 2 76588\n",
"Arabhavi BALACHANDRA LAXMANRAO JARKIHOLI Bharatiya Janata Party 99283 1 UTAGI RAMAPPA KAREPPA Indian National Congress 24062 2 75221\n",
"Hukkeri UMESH VISHWANATH KATTI Bharatiya Janata Party 81810 1 RAVI BASAVARAJ KARALE Indian National Congress 24484 2 57326\n",
"Davanagere North S S MALLIKARJUNA Indian National Congress 88101 1 S A RAVINDRANATH Bharatiya Janata Party 30821 2 57280\n",
"B.t.m layout RAMALINGAREDDY Indian National Congress 69712 1 N. SUDHAKAR Bharatiya Janata Party 20664 2 49048"
]
}
],
"prompt_number": 77
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"So, despite the Congress having a clean sweep, 2 of the top 5 margin victories are for the BJP. But let's look at percentage of votes."
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"margins['Votes'] = data.groupby('District')['Votes'].sum()\n",
"margins['% Margin'] = margins['Margin'].astype(float) / margins['Votes']\n",
"margins.sort('% Margin', ascending=False).head()"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"\n",
"
\n",
" \n",
" \n",
" | \n",
" Candidate1 | \n",
" Party1 | \n",
" Votes1 | \n",
" Rank1 | \n",
" Candidate2 | \n",
" Party2 | \n",
" Votes2 | \n",
" Rank2 | \n",
" Margin | \n",
" Votes | \n",
" % Margin | \n",
"
\n",
" \n",
" District | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
"
\n",
" \n",
" \n",
" \n",
" Arabhavi | \n",
" BALACHANDRA LAXMANRAO JARKIHOLI | \n",
" Bharatiya Janata Party | \n",
" 99283 | \n",
" 1 | \n",
" UTAGI RAMAPPA KAREPPA | \n",
" Indian National Congress | \n",
" 24062 | \n",
" 2 | \n",
" 75221 | \n",
" 145099 | \n",
" 0.518412 | \n",
"
\n",
" \n",
" Chikkodi-Sadalga | \n",
" PRAKASH BABANNA HUKKERI | \n",
" Indian National Congress | \n",
" 102237 | \n",
" 1 | \n",
" BASAVANNI RUDRAPPA SANGAPPAGOL | \n",
" Bharatiya Janata Party | \n",
" 25649 | \n",
" 2 | \n",
" 76588 | \n",
" 149375 | \n",
" 0.512723 | \n",
"
\n",
" \n",
" B.t.m layout | \n",
" RAMALINGAREDDY | \n",
" Indian National Congress | \n",
" 69712 | \n",
" 1 | \n",
" N. SUDHAKAR | \n",
" Bharatiya Janata Party | \n",
" 20664 | \n",
" 2 | \n",
" 49048 | \n",
" 110486 | \n",
" 0.443930 | \n",
"
\n",
" \n",
" Hukkeri | \n",
" UMESH VISHWANATH KATTI | \n",
" Bharatiya Janata Party | \n",
" 81810 | \n",
" 1 | \n",
" RAVI BASAVARAJ KARALE | \n",
" Indian National Congress | \n",
" 24484 | \n",
" 2 | \n",
" 57326 | \n",
" 132961 | \n",
" 0.431149 | \n",
"
\n",
" \n",
" Davanagere North | \n",
" S S MALLIKARJUNA | \n",
" Indian National Congress | \n",
" 88101 | \n",
" 1 | \n",
" S A RAVINDRANATH | \n",
" Bharatiya Janata Party | \n",
" 30821 | \n",
" 2 | \n",
" 57280 | \n",
" 134450 | \n",
" 0.426032 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"output_type": "pyout",
"prompt_number": 87,
"text": [
" Candidate1 Party1 Votes1 Rank1 Candidate2 Party2 Votes2 Rank2 Margin Votes % Margin\n",
"District \n",
"Arabhavi BALACHANDRA LAXMANRAO JARKIHOLI Bharatiya Janata Party 99283 1 UTAGI RAMAPPA KAREPPA Indian National Congress 24062 2 75221 145099 0.518412\n",
"Chikkodi-Sadalga PRAKASH BABANNA HUKKERI Indian National Congress 102237 1 BASAVANNI RUDRAPPA SANGAPPAGOL Bharatiya Janata Party 25649 2 76588 149375 0.512723\n",
"B.t.m layout RAMALINGAREDDY Indian National Congress 69712 1 N. SUDHAKAR Bharatiya Janata Party 20664 2 49048 110486 0.443930\n",
"Hukkeri UMESH VISHWANATH KATTI Bharatiya Janata Party 81810 1 RAVI BASAVARAJ KARALE Indian National Congress 24484 2 57326 132961 0.431149\n",
"Davanagere North S S MALLIKARJUNA Indian National Congress 88101 1 S A RAVINDRANATH Bharatiya Janata Party 30821 2 57280 134450 0.426032"
]
}
],
"prompt_number": 87
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"This effect is even more pronounced now. The same 2 BJP constituencies are also in the top 5 as a percentage, and in fact, BJP's % victory at Arabhavi is the highest in the State.\n",
"\n",
"# How many constituencies won by an absolute majority (over 50% votes)? Which parties cornered these?"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"margins[margins['Votes1'].astype(float) / margins['Votes'] > 0.5].head()"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"\n",
"
\n",
" \n",
" \n",
" | \n",
" Candidate1 | \n",
" Party1 | \n",
" Votes1 | \n",
" Rank1 | \n",
" Candidate2 | \n",
" Party2 | \n",
" Votes2 | \n",
" Rank2 | \n",
" Margin | \n",
" Votes | \n",
" % Margin | \n",
"
\n",
" \n",
" District | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
"
\n",
" \n",
" \n",
" \n",
" Aland | \n",
" BHOJARAJ RAMCHANDRA | \n",
" Karnataka Jantha Paksha | \n",
" 67085 | \n",
" 1 | \n",
" SUBHASH RUKMAIAH | \n",
" Janata Dal (Secular) | \n",
" 49971 | \n",
" 2 | \n",
" 17114 | \n",
" 132385 | \n",
" 0.129274 | \n",
"
\n",
" \n",
" Anekal | \n",
" SHIVANNA B. | \n",
" Indian National Congress | \n",
" 105464 | \n",
" 1 | \n",
" A. NARAYANASWAMY | \n",
" Bharatiya Janata Party | \n",
" 65282 | \n",
" 2 | \n",
" 40182 | \n",
" 186461 | \n",
" 0.215498 | \n",
"
\n",
" \n",
" Arabhavi | \n",
" BALACHANDRA LAXMANRAO JARKIHOLI | \n",
" Bharatiya Janata Party | \n",
" 99283 | \n",
" 1 | \n",
" UTAGI RAMAPPA KAREPPA | \n",
" Indian National Congress | \n",
" 24062 | \n",
" 2 | \n",
" 75221 | \n",
" 145099 | \n",
" 0.518412 | \n",
"
\n",
" \n",
" Athani | \n",
" LAXMAN SANGAPPA SAVADI | \n",
" Bharatiya Janata Party | \n",
" 74299 | \n",
" 1 | \n",
" MAHESH IRANAGOUDA KUMATHALLI | \n",
" Indian National Congress | \n",
" 50528 | \n",
" 2 | \n",
" 23771 | \n",
" 146290 | \n",
" 0.162492 | \n",
"
\n",
" \n",
" B.t.m layout | \n",
" RAMALINGAREDDY | \n",
" Indian National Congress | \n",
" 69712 | \n",
" 1 | \n",
" N. SUDHAKAR | \n",
" Bharatiya Janata Party | \n",
" 20664 | \n",
" 2 | \n",
" 49048 | \n",
" 110486 | \n",
" 0.443930 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"output_type": "pyout",
"prompt_number": 94,
"text": [
" Candidate1 Party1 Votes1 Rank1 Candidate2 Party2 Votes2 Rank2 Margin Votes % Margin\n",
"District \n",
"Aland BHOJARAJ RAMCHANDRA Karnataka Jantha Paksha 67085 1 SUBHASH RUKMAIAH Janata Dal (Secular) 49971 2 17114 132385 0.129274\n",
"Anekal SHIVANNA B. Indian National Congress 105464 1 A. NARAYANASWAMY Bharatiya Janata Party 65282 2 40182 186461 0.215498\n",
"Arabhavi BALACHANDRA LAXMANRAO JARKIHOLI Bharatiya Janata Party 99283 1 UTAGI RAMAPPA KAREPPA Indian National Congress 24062 2 75221 145099 0.518412\n",
"Athani LAXMAN SANGAPPA SAVADI Bharatiya Janata Party 74299 1 MAHESH IRANAGOUDA KUMATHALLI Indian National Congress 50528 2 23771 146290 0.162492\n",
"B.t.m layout RAMALINGAREDDY Indian National Congress 69712 1 N. SUDHAKAR Bharatiya Janata Party 20664 2 49048 110486 0.443930"
]
}
],
"prompt_number": 94
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"margins[margins['Votes1'].astype(float) / margins['Votes'] > 0.5]['Party1'].value_counts()"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "pyout",
"prompt_number": 97,
"text": [
"Indian National Congress 40\n",
"Janata Dal (Secular) 9\n",
"Bharatiya Janata Party 8\n",
"Independent 4\n",
"Badavara Shramikara Raitara Congress Party 3\n",
"Karnataka Jantha Paksha 1\n",
"dtype: int64"
]
}
],
"prompt_number": 97
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"So Congress has had what looks like a disproportionate share of absolute majorities. Let's confirm that."
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"majority = pd.DataFrame({\n",
" 'Absolute majority': margins[margins['Votes1'].astype(float) / margins['Votes'] > 0.5]['Party1'].value_counts(),\n",
" 'Winning party': data[data['Rank'] == 1]['Party'].value_counts(),\n",
"})\n",
"majority['Ratio'] = majority['Absolute majority'] / majority['Winning party']\n",
"majority.dropna().sort('Ratio', ascending=False)"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"\n",
"
\n",
" \n",
" \n",
" | \n",
" Absolute majority | \n",
" Winning party | \n",
" Ratio | \n",
"
\n",
" \n",
" \n",
" \n",
" Badavara Shramikara Raitara Congress Party | \n",
" 3 | \n",
" 4 | \n",
" 0.750000 | \n",
"
\n",
" \n",
" Independent | \n",
" 4 | \n",
" 9 | \n",
" 0.444444 | \n",
"
\n",
" \n",
" Indian National Congress | \n",
" 40 | \n",
" 121 | \n",
" 0.330579 | \n",
"
\n",
" \n",
" Janata Dal (Secular) | \n",
" 9 | \n",
" 40 | \n",
" 0.225000 | \n",
"
\n",
" \n",
" Bharatiya Janata Party | \n",
" 8 | \n",
" 40 | \n",
" 0.200000 | \n",
"
\n",
" \n",
" Karnataka Jantha Paksha | \n",
" 1 | \n",
" 6 | \n",
" 0.166667 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"output_type": "pyout",
"prompt_number": 117,
"text": [
" Absolute majority Winning party Ratio\n",
"Badavara Shramikara Raitara Congress Party 3 4 0.750000\n",
"Independent 4 9 0.444444\n",
"Indian National Congress 40 121 0.330579\n",
"Janata Dal (Secular) 9 40 0.225000\n",
"Bharatiya Janata Party 8 40 0.200000\n",
"Karnataka Jantha Paksha 1 6 0.166667"
]
}
],
"prompt_number": 117
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"BSRCP won 3 of its 4 constituencies with an absolute majority. Independents: 4 out of 9. Congress did better at 33% than JD(S) at 22.5% which did better than BJP."
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Who lost their deposits?"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"First, let's get the total votes for a district in a way that aligns with `data`"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"data['District'].apply(lambda district: margins.ix[district]).head()"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"\n",
"
\n",
" \n",
" \n",
" | \n",
" Candidate1 | \n",
" Party1 | \n",
" Votes1 | \n",
" Rank1 | \n",
" Candidate2 | \n",
" Party2 | \n",
" Votes2 | \n",
" Rank2 | \n",
" Margin | \n",
" Votes | \n",
" % Margin | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" MALIKAYYA VENKAYYA GUTTEDAR | \n",
" Indian National Congress | \n",
" 38093 | \n",
" 1 | \n",
" M.Y.PATIL | \n",
" Karnataka Jantha Paksha | \n",
" 32855 | \n",
" 2 | \n",
" 5238 | \n",
" 128611 | \n",
" 0.040727 | \n",
"
\n",
" \n",
" 1 | \n",
" MALIKAYYA VENKAYYA GUTTEDAR | \n",
" Indian National Congress | \n",
" 38093 | \n",
" 1 | \n",
" M.Y.PATIL | \n",
" Karnataka Jantha Paksha | \n",
" 32855 | \n",
" 2 | \n",
" 5238 | \n",
" 128611 | \n",
" 0.040727 | \n",
"
\n",
" \n",
" 2 | \n",
" MALIKAYYA VENKAYYA GUTTEDAR | \n",
" Indian National Congress | \n",
" 38093 | \n",
" 1 | \n",
" M.Y.PATIL | \n",
" Karnataka Jantha Paksha | \n",
" 32855 | \n",
" 2 | \n",
" 5238 | \n",
" 128611 | \n",
" 0.040727 | \n",
"
\n",
" \n",
" 3 | \n",
" MALIKAYYA VENKAYYA GUTTEDAR | \n",
" Indian National Congress | \n",
" 38093 | \n",
" 1 | \n",
" M.Y.PATIL | \n",
" Karnataka Jantha Paksha | \n",
" 32855 | \n",
" 2 | \n",
" 5238 | \n",
" 128611 | \n",
" 0.040727 | \n",
"
\n",
" \n",
" 4 | \n",
" MALIKAYYA VENKAYYA GUTTEDAR | \n",
" Indian National Congress | \n",
" 38093 | \n",
" 1 | \n",
" M.Y.PATIL | \n",
" Karnataka Jantha Paksha | \n",
" 32855 | \n",
" 2 | \n",
" 5238 | \n",
" 128611 | \n",
" 0.040727 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"output_type": "pyout",
"prompt_number": 134,
"text": [
" Candidate1 Party1 Votes1 Rank1 Candidate2 Party2 Votes2 Rank2 Margin Votes % Margin\n",
"0 MALIKAYYA VENKAYYA GUTTEDAR Indian National Congress 38093 1 M.Y.PATIL Karnataka Jantha Paksha 32855 2 5238 128611 0.040727\n",
"1 MALIKAYYA VENKAYYA GUTTEDAR Indian National Congress 38093 1 M.Y.PATIL Karnataka Jantha Paksha 32855 2 5238 128611 0.040727\n",
"2 MALIKAYYA VENKAYYA GUTTEDAR Indian National Congress 38093 1 M.Y.PATIL Karnataka Jantha Paksha 32855 2 5238 128611 0.040727\n",
"3 MALIKAYYA VENKAYYA GUTTEDAR Indian National Congress 38093 1 M.Y.PATIL Karnataka Jantha Paksha 32855 2 5238 128611 0.040727\n",
"4 MALIKAYYA VENKAYYA GUTTEDAR Indian National Congress 38093 1 M.Y.PATIL Karnataka Jantha Paksha 32855 2 5238 128611 0.040727"
]
}
],
"prompt_number": 134
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"data['% votes'] = data['Votes'].astype(float) / data['District'].apply(lambda district: margins['Votes'][district])\n",
"data.head()"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"\n",
"
\n",
" \n",
" \n",
" | \n",
" District | \n",
" Candidate | \n",
" Party | \n",
" Votes | \n",
" Rank | \n",
" % votes | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" Afzalpur | \n",
" MALIKAYYA VENKAYYA GUTTEDAR | \n",
" Indian National Congress | \n",
" 38093 | \n",
" 1 | \n",
" 0.296188 | \n",
"
\n",
" \n",
" 1 | \n",
" Afzalpur | \n",
" M.Y.PATIL | \n",
" Karnataka Jantha Paksha | \n",
" 32855 | \n",
" 2 | \n",
" 0.255460 | \n",
"
\n",
" \n",
" 2 | \n",
" Afzalpur | \n",
" VITTHAL HEROOR | \n",
" Janata Dal (Secular) | \n",
" 22847 | \n",
" 3 | \n",
" 0.177644 | \n",
"
\n",
" \n",
" 3 | \n",
" Afzalpur | \n",
" GOVIND VISHWANATH BHAT | \n",
" Samajwadi Party | \n",
" 14648 | \n",
" 4 | \n",
" 0.113894 | \n",
"
\n",
" \n",
" 4 | \n",
" Afzalpur | \n",
" DILIP R. PATIL | \n",
" Bharatiya Janata Party | \n",
" 10347 | \n",
" 5 | \n",
" 0.080452 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"output_type": "pyout",
"prompt_number": 136,
"text": [
" District Candidate Party Votes Rank % votes\n",
"0 Afzalpur MALIKAYYA VENKAYYA GUTTEDAR Indian National Congress 38093 1 0.296188\n",
"1 Afzalpur M.Y.PATIL Karnataka Jantha Paksha 32855 2 0.255460\n",
"2 Afzalpur VITTHAL HEROOR Janata Dal (Secular) 22847 3 0.177644\n",
"3 Afzalpur GOVIND VISHWANATH BHAT Samajwadi Party 14648 4 0.113894\n",
"4 Afzalpur DILIP R. PATIL Bharatiya Janata Party 10347 5 0.080452"
]
}
],
"prompt_number": 136
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"sum(data['% votes'] < 1. / 6)"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "pyout",
"prompt_number": 147,
"text": [
"2413"
]
}
],
"prompt_number": 147
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"2,413 candidates [lost their deposit](http://eci.nic.in/eci_main1/Contesting.aspx) of Rs 10,000 (5,000 for SC/ST), out of a total of..."
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"len(data)"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "pyout",
"prompt_number": 148,
"text": [
"2940"
]
}
],
"prompt_number": 148
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"2,940 candidates. Who were the most unfortunate losers?"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"data[data['% votes'] < 1. / 6].sort('% votes').head(50)"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"\n",
"
\n",
" \n",
" \n",
" | \n",
" District | \n",
" Candidate | \n",
" Party | \n",
" Votes | \n",
" Rank | \n",
" % votes | \n",
"
\n",
" \n",
" \n",
" \n",
" 1434 | \n",
" K.r.pura | \n",
" M. RAMAKRISHNA | \n",
" Independent | \n",
" 67 | \n",
" 26 | \n",
" 0.000335 | \n",
"
\n",
" \n",
" 1433 | \n",
" K.r.pura | \n",
" SRINIVASA | \n",
" Independent | \n",
" 84 | \n",
" 25 | \n",
" 0.000420 | \n",
"
\n",
" \n",
" 2840 | \n",
" Vijay Nagar | \n",
" DR|| SYED THASADUK AHAMED | \n",
" Independent | \n",
" 64 | \n",
" 25 | \n",
" 0.000480 | \n",
"
\n",
" \n",
" 2284 | \n",
" Rajaji Nagar | \n",
" P.K PATIL | \n",
" Independent | \n",
" 52 | \n",
" 25 | \n",
" 0.000482 | \n",
"
\n",
" \n",
" 1432 | \n",
" K.r.pura | \n",
" SARALA BAI | \n",
" Independent | \n",
" 97 | \n",
" 24 | \n",
" 0.000485 | \n",
"
\n",
" \n",
" 1431 | \n",
" K.r.pura | \n",
" AYUB PASHA | \n",
" Independent | \n",
" 102 | \n",
" 23 | \n",
" 0.000510 | \n",
"
\n",
" \n",
" 1259 | \n",
" Hosakote | \n",
" ANANDA .M.G | \n",
" Independent | \n",
" 88 | \n",
" 11 | \n",
" 0.000529 | \n",
"
\n",
" \n",
" 2839 | \n",
" Vijay Nagar | \n",
" SYED ULLA HABIB | \n",
" Independent | \n",
" 73 | \n",
" 24 | \n",
" 0.000548 | \n",
"
\n",
" \n",
" 1258 | \n",
" Hosakote | \n",
" M.PREMSAGAR | \n",
" Independent | \n",
" 92 | \n",
" 10 | \n",
" 0.000553 | \n",
"
\n",
" \n",
" 582 | \n",
" Chamrajpet | \n",
" ASGAR-A-MAHEEN.S.M | \n",
" Independent | \n",
" 60 | \n",
" 20 | \n",
" 0.000557 | \n",
"
\n",
" \n",
" 2754 | \n",
" Tumkur City | \n",
" TOUFEEQ ULLA KHAN | \n",
" Independent | \n",
" 78 | \n",
" 14 | \n",
" 0.000564 | \n",
"
\n",
" \n",
" 548 | \n",
" Chamaraja | \n",
" NAYAZ AHMED | \n",
" Ambedkar National Congress | \n",
" 62 | \n",
" 20 | \n",
" 0.000564 | \n",
"
\n",
" \n",
" 1873 | \n",
" Malleshwaram | \n",
" PRABHAKAR | \n",
" Hindusthan Nirman Dal | \n",
" 62 | \n",
" 16 | \n",
" 0.000572 | \n",
"
\n",
" \n",
" 1843 | \n",
" Mahalakshmi Layout | \n",
" DHANANJAYA .R | \n",
" Independent | \n",
" 86 | \n",
" 14 | \n",
" 0.000582 | \n",
"
\n",
" \n",
" 1789 | \n",
" Madhugiri | \n",
" T.VENKATAREDDY | \n",
" Independent | \n",
" 87 | \n",
" 22 | \n",
" 0.000591 | \n",
"
\n",
" \n",
" 581 | \n",
" Chamrajpet | \n",
" B.K.ASLAM KHAN | \n",
" Independent | \n",
" 65 | \n",
" 19 | \n",
" 0.000604 | \n",
"
\n",
" \n",
" 547 | \n",
" Chamaraja | \n",
" AKEEL AHMEAD | \n",
" Independent | \n",
" 67 | \n",
" 19 | \n",
" 0.000609 | \n",
"
\n",
" \n",
" 2838 | \n",
" Vijay Nagar | \n",
" SYED SABEER | \n",
" Independent | \n",
" 83 | \n",
" 23 | \n",
" 0.000623 | \n",
"
\n",
" \n",
" 1430 | \n",
" K.r.pura | \n",
" KESHAV S. HIMALAI | \n",
" Independent | \n",
" 128 | \n",
" 22 | \n",
" 0.000639 | \n",
"
\n",
" \n",
" 546 | \n",
" Chamaraja | \n",
" ALI AHMED | \n",
" Independent | \n",
" 71 | \n",
" 18 | \n",
" 0.000646 | \n",
"
\n",
" \n",
" 2283 | \n",
" Rajaji Nagar | \n",
" LAKSHMANA SHETRU.H | \n",
" National People's Party | \n",
" 70 | \n",
" 24 | \n",
" 0.000649 | \n",
"
\n",
" \n",
" 1429 | \n",
" K.r.pura | \n",
" N. KODANDA REDDY | \n",
" Independent | \n",
" 130 | \n",
" 21 | \n",
" 0.000649 | \n",
"
\n",
" \n",
" 637 | \n",
" Chickpet | \n",
" M. ADHI MULAM | \n",
" Independent | \n",
" 71 | \n",
" 16 | \n",
" 0.000652 | \n",
"
\n",
" \n",
" 1872 | \n",
" Malleshwaram | \n",
" RAJESH. P. | \n",
" Independent | \n",
" 71 | \n",
" 15 | \n",
" 0.000656 | \n",
"
\n",
" \n",
" 636 | \n",
" Chickpet | \n",
" KURAM PASHA | \n",
" Independent | \n",
" 74 | \n",
" 15 | \n",
" 0.000680 | \n",
"
\n",
" \n",
" 494 | \n",
" Byatarayanapura | \n",
" ABDUL KHADEER | \n",
" Independent | \n",
" 142 | \n",
" 16 | \n",
" 0.000682 | \n",
"
\n",
" \n",
" 1428 | \n",
" K.r.pura | \n",
" K. SATHYANARAYANA | \n",
" Independent | \n",
" 137 | \n",
" 20 | \n",
" 0.000684 | \n",
"
\n",
" \n",
" 1651 | \n",
" Krishnaraja | \n",
" H.S.NANJUNDASWAMY | \n",
" Independent | \n",
" 88 | \n",
" 19 | \n",
" 0.000689 | \n",
"
\n",
" \n",
" 2837 | \n",
" Vijay Nagar | \n",
" C.K.RAVI | \n",
" Bharatiya Dr. B.R.Ambedkar Janta Party | \n",
" 93 | \n",
" 22 | \n",
" 0.000698 | \n",
"
\n",
" \n",
" 2282 | \n",
" Rajaji Nagar | \n",
" K.T NAGABHUSHAN | \n",
" Janata Dal (United) | \n",
" 76 | \n",
" 23 | \n",
" 0.000705 | \n",
"
\n",
" \n",
" 493 | \n",
" Byatarayanapura | \n",
" K.SRIDHAR | \n",
" Ambedkar Janatha Party | \n",
" 148 | \n",
" 15 | \n",
" 0.000710 | \n",
"
\n",
" \n",
" 1944 | \n",
" Mangalore City South | \n",
" HARISH ALVA | \n",
" Janata Dal (United) | \n",
" 96 | \n",
" 13 | \n",
" 0.000726 | \n",
"
\n",
" \n",
" 2180 | \n",
" Nippani | \n",
" JAY ALIAS JAYAVANT SATAPPA CHOUGULE | \n",
" Independent | \n",
" 112 | \n",
" 12 | \n",
" 0.000734 | \n",
"
\n",
" \n",
" 580 | \n",
" Chamrajpet | \n",
" C.B.ABDUL SAB | \n",
" Independent | \n",
" 79 | \n",
" 18 | \n",
" 0.000734 | \n",
"
\n",
" \n",
" 1788 | \n",
" Madhugiri | \n",
" ADHINARAYANAPPA | \n",
" Independent | \n",
" 109 | \n",
" 21 | \n",
" 0.000740 | \n",
"
\n",
" \n",
" 1787 | \n",
" Madhugiri | \n",
" G.M.NAGARAJU | \n",
" Independent | \n",
" 110 | \n",
" 20 | \n",
" 0.000747 | \n",
"
\n",
" \n",
" 875 | \n",
" Gandhi Nagar | \n",
" GHOUSE MOHIDDEN | \n",
" Independent | \n",
" 83 | \n",
" 14 | \n",
" 0.000749 | \n",
"
\n",
" \n",
" 1257 | \n",
" Hosakote | \n",
" B.N.ANANDA | \n",
" Independent | \n",
" 125 | \n",
" 9 | \n",
" 0.000751 | \n",
"
\n",
" \n",
" 250 | \n",
" Basavanagudi | \n",
" ARUNKUMAR.P. | \n",
" Independent | \n",
" 79 | \n",
" 18 | \n",
" 0.000762 | \n",
"
\n",
" \n",
" 2540 | \n",
" Shivajinagar | \n",
" M.PRAKASH | \n",
" Independent | \n",
" 70 | \n",
" 19 | \n",
" 0.000770 | \n",
"
\n",
" \n",
" 1427 | \n",
" K.r.pura | \n",
" P.P.APPANNA | \n",
" Communist Party of India (Marxist-Leninist) ... | \n",
" 155 | \n",
" 19 | \n",
" 0.000774 | \n",
"
\n",
" \n",
" 2281 | \n",
" Rajaji Nagar | \n",
" VIJAY KUMAR M K | \n",
" Independent | \n",
" 85 | \n",
" 22 | \n",
" 0.000788 | \n",
"
\n",
" \n",
" 635 | \n",
" Chickpet | \n",
" ASGAR 'A' MAHEEN.S.M | \n",
" Independent | \n",
" 89 | \n",
" 14 | \n",
" 0.000818 | \n",
"
\n",
" \n",
" 2460 | \n",
" Shanti Nagar | \n",
" PURUSOTHAMAN D.R. | \n",
" Independent | \n",
" 86 | \n",
" 15 | \n",
" 0.000830 | \n",
"
\n",
" \n",
" 249 | \n",
" Basavanagudi | \n",
" N.HEMANTH KUMAR GOWDA | \n",
" Janata Dal (United) | \n",
" 88 | \n",
" 17 | \n",
" 0.000849 | \n",
"
\n",
" \n",
" 492 | \n",
" Byatarayanapura | \n",
" D.DEVRAJ | \n",
" Independent | \n",
" 178 | \n",
" 14 | \n",
" 0.000854 | \n",
"
\n",
" \n",
" 1871 | \n",
" Malleshwaram | \n",
" N. S. SHIVANNA | \n",
" Independent | \n",
" 93 | \n",
" 14 | \n",
" 0.000859 | \n",
"
\n",
" \n",
" 783 | \n",
" Davanagere North | \n",
" G C PATIL | \n",
" Sarva Janata Party | \n",
" 116 | \n",
" 19 | \n",
" 0.000863 | \n",
"
\n",
" \n",
" 2179 | \n",
" Nippani | \n",
" JAYAVANT MIRAJAKAR | \n",
" Independent | \n",
" 132 | \n",
" 11 | \n",
" 0.000864 | \n",
"
\n",
" \n",
" 441 | \n",
" Bijapur City | \n",
" CHANDRU R KALABURGI | \n",
" Independent | \n",
" 103 | \n",
" 16 | \n",
" 0.000865 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"output_type": "pyout",
"prompt_number": 149,
"text": [
" District Candidate Party Votes Rank % votes\n",
"1434 K.r.pura M. RAMAKRISHNA Independent 67 26 0.000335\n",
"1433 K.r.pura SRINIVASA Independent 84 25 0.000420\n",
"2840 Vijay Nagar DR|| SYED THASADUK AHAMED Independent 64 25 0.000480\n",
"2284 Rajaji Nagar P.K PATIL Independent 52 25 0.000482\n",
"1432 K.r.pura SARALA BAI Independent 97 24 0.000485\n",
"1431 K.r.pura AYUB PASHA Independent 102 23 0.000510\n",
"1259 Hosakote ANANDA .M.G Independent 88 11 0.000529\n",
"2839 Vijay Nagar SYED ULLA HABIB Independent 73 24 0.000548\n",
"1258 Hosakote M.PREMSAGAR Independent 92 10 0.000553\n",
"582 Chamrajpet ASGAR-A-MAHEEN.S.M Independent 60 20 0.000557\n",
"2754 Tumkur City TOUFEEQ ULLA KHAN Independent 78 14 0.000564\n",
"548 Chamaraja NAYAZ AHMED Ambedkar National Congress 62 20 0.000564\n",
"1873 Malleshwaram PRABHAKAR Hindusthan Nirman Dal 62 16 0.000572\n",
"1843 Mahalakshmi Layout DHANANJAYA .R Independent 86 14 0.000582\n",
"1789 Madhugiri T.VENKATAREDDY Independent 87 22 0.000591\n",
"581 Chamrajpet B.K.ASLAM KHAN Independent 65 19 0.000604\n",
"547 Chamaraja AKEEL AHMEAD Independent 67 19 0.000609\n",
"2838 Vijay Nagar SYED SABEER Independent 83 23 0.000623\n",
"1430 K.r.pura KESHAV S. HIMALAI Independent 128 22 0.000639\n",
"546 Chamaraja ALI AHMED Independent 71 18 0.000646\n",
"2283 Rajaji Nagar LAKSHMANA SHETRU.H National People's Party 70 24 0.000649\n",
"1429 K.r.pura N. KODANDA REDDY Independent 130 21 0.000649\n",
"637 Chickpet M. ADHI MULAM Independent 71 16 0.000652\n",
"1872 Malleshwaram RAJESH. P. Independent 71 15 0.000656\n",
"636 Chickpet KURAM PASHA Independent 74 15 0.000680\n",
"494 Byatarayanapura ABDUL KHADEER Independent 142 16 0.000682\n",
"1428 K.r.pura K. SATHYANARAYANA Independent 137 20 0.000684\n",
"1651 Krishnaraja H.S.NANJUNDASWAMY Independent 88 19 0.000689\n",
"2837 Vijay Nagar C.K.RAVI Bharatiya Dr. B.R.Ambedkar Janta Party 93 22 0.000698\n",
"2282 Rajaji Nagar K.T NAGABHUSHAN Janata Dal (United) 76 23 0.000705\n",
"493 Byatarayanapura K.SRIDHAR Ambedkar Janatha Party 148 15 0.000710\n",
"1944 Mangalore City South HARISH ALVA Janata Dal (United) 96 13 0.000726\n",
"2180 Nippani JAY ALIAS JAYAVANT SATAPPA CHOUGULE Independent 112 12 0.000734\n",
"580 Chamrajpet C.B.ABDUL SAB Independent 79 18 0.000734\n",
"1788 Madhugiri ADHINARAYANAPPA Independent 109 21 0.000740\n",
"1787 Madhugiri G.M.NAGARAJU Independent 110 20 0.000747\n",
"875 Gandhi Nagar GHOUSE MOHIDDEN Independent 83 14 0.000749\n",
"1257 Hosakote B.N.ANANDA Independent 125 9 0.000751\n",
"250 Basavanagudi ARUNKUMAR.P. Independent 79 18 0.000762\n",
"2540 Shivajinagar M.PRAKASH Independent 70 19 0.000770\n",
"1427 K.r.pura P.P.APPANNA Communist Party of India (Marxist-Leninist) ... 155 19 0.000774\n",
"2281 Rajaji Nagar VIJAY KUMAR M K Independent 85 22 0.000788\n",
"635 Chickpet ASGAR 'A' MAHEEN.S.M Independent 89 14 0.000818\n",
"2460 Shanti Nagar PURUSOTHAMAN D.R. Independent 86 15 0.000830\n",
"249 Basavanagudi N.HEMANTH KUMAR GOWDA Janata Dal (United) 88 17 0.000849\n",
"492 Byatarayanapura D.DEVRAJ Independent 178 14 0.000854\n",
"1871 Malleshwaram N. S. SHIVANNA Independent 93 14 0.000859\n",
"783 Davanagere North G C PATIL Sarva Janata Party 116 19 0.000863\n",
"2179 Nippani JAYAVANT MIRAJAKAR Independent 132 11 0.000864\n",
"441 Bijapur City CHANDRU R KALABURGI Independent 103 16 0.000865"
]
}
],
"prompt_number": 149
}
],
"metadata": {}
}
]
}