--- 
title: "Loksabha_2019_Data_Dive" 
output: html_document 
---

INTRO TO R: Data Dive

Dataset: Loksabha 2019 Candidates General Information. (https://www.kaggle.com/datasets/themlphdstudent/lok-sabha-election-candidate-list-2004-to-2019)

# Importing required libraries
library(tidyverse)
## ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
## ✔ dplyr     1.1.2     ✔ readr     2.1.4
## ✔ forcats   1.0.0     ✔ stringr   1.5.0
## ✔ ggplot2   3.4.3     ✔ tibble    3.2.1
## ✔ lubridate 1.9.2     ✔ tidyr     1.3.0
## ✔ purrr     1.0.2     
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag()    masks stats::lag()
## ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errors

Loading our dataset

# Loading our dataset
data <-read.csv('C:\\Users\\bhush\\Downloads\\Coursework\\I 590 INTRO TO R\\datasets\\data_final\\LokSabha2019_xl.csv')

Finding general summary of our data

# Finding the summary of our data
summary(data)
##   Candidate            Party           Criminal.Cases      Education        
##  Length:7968        Length:7968        Min.   :  0.0000   Length:7968       
##  Class :character   Class :character   1st Qu.:  0.0000   Class :character  
##  Mode  :character   Mode  :character   Median :  0.0000   Mode  :character  
##                                        Mean   :  0.5732                     
##                                        3rd Qu.:  0.0000                     
##                                        Max.   :240.0000                     
##                                                                             
##       Age         Total.Assets       Constituency        Liabilities       
##  Min.   :24.00   Min.   :9.000e+00   Length:7968        Min.   :0.000e+00  
##  1st Qu.:38.00   1st Qu.:5.040e+05   Class :character   1st Qu.:0.000e+00  
##  Median :46.00   Median :2.752e+06   Mode  :character   Median :0.000e+00  
##  Mean   :47.12   Mean   :4.201e+07                      Mean   :5.576e+06  
##  3rd Qu.:56.00   3rd Qu.:1.309e+07                      3rd Qu.:6.190e+05  
##  Max.   :90.00   Max.   :1.108e+10                      Max.   :1.548e+09  
##                  NA's   :60                                                
##      Winner           Gender         
##  Min.   :0.00000   Length:7968       
##  1st Qu.:0.00000   Class :character  
##  Median :0.00000   Mode  :character  
##  Mean   :0.03828                     
##  3rd Qu.:0.00000                     
##  Max.   :1.00000                     
## 

Our Dataset has 10 columns,

  1. Candidate: This column contains names of candidates who contested the 2019 Indian Loksabha elections (Loksabha elections are held once in every 5 years to elect India’s Prime Minister). This column has 7968 Character Values.

  2. Party: This column contains the name of the political party from which the candidate has contested the elections, This column contains some repeated values.

  3. Criminal Case: This column gives us the number of criminal cases which have been booked or cases which are onigoing in the name of the candidate. This column contains Integer values.

  4. Education: This column contains the level of education the candidate has completed. Some candidates have not shared their Level of education.

  5. Age: The Age column has a mean value of 47 and the youngest candidate is 24 years old.

  6. Total Assets: These assets can be of the form of properties, shares and other monetary sources.

  7. Constituency: This column specifies the location for which the candidate is contesting the election.

  8. Liabilities: This contains the liabilities the candidate owes.

  9. Winner: ‘0’ indicates that the candidate lost the election while ‘1’ indicates the candidate won the election.

  10. Gender: There are only two genders ‘Male’ and ‘Female’, the data of people of other gender who contested the election has not be released.

Goals/Purpose:

India will be having the Loksabha elections in 2024, so we can analyse the candidate information of 2019 and compare it with the future candidates or also we can compare it with the candidates of 2014 election and see what changes have happened or what can we expect to see in the upcoming years.

Data Exploration

# Distribution by gender
data |>
  count(Gender)
##   Gender    n
## 1      F  606
## 2      M 7362
ggplot(data, aes(x = Age)) +
  geom_histogram(binwidth = 5, fill = "blue") +
  labs(title = "Age Distribution", x = "Age", y = "Frequency")

# Distribution by Candidates - Political parties
data |>
  count(Party, sort=TRUE)
##                                             Party    n
## 1                                             IND 3389
## 2                                             BJP  436
## 3                                             INC  421
## 4                                             BSP  380
## 5                             Bahujan Mukti Party  120
## 6                                         SUCI(C)  113
## 7                                             SHS   97
## 8             Pragatishil Samajwadi Party (Lohia)   81
## 9                      Ambedkarite Party of India   76
## 10                                         CPI(M)   69
## 11                                           AITC   62
## 12            Peoples Party of India (Democratic)   56
## 13                           Bharat Prabhat Party   53
## 14                                            CPI   49
## 15                                             SP   49
## 16                         Pyramid Party of India   47
## 17                        Vanchit Bahujan Aaghadi   47
## 18                          Hindusthan Nirman Dal   46
## 19                            Makkal Needhi Maiam   36
## 20                                            AAP   35
## 21                                            NCP   35
## 22                            Naam Tamilar Katchi   35
## 23                                           AIFB   34
## 24                   Bhartiya Shakti Chetna Party   34
## 25                                         RPI(A)   32
## 26                               CPI(ML) Red Star   29
## 27             Bahujan Republican Socialist Party   27
## 28                       Uttama Prajaakeeya Party   26
## 29                                            TDP   25
## 30                                          YSRCP   25
## 31                                            DMK   24
## 32                                          JD(U)   24
## 33                  Suheldev Bhartiya Samaj Party   24
## 34                       Gondvana Gantantra Party   23
## 35                                 Janasena Party   23
## 36                                         AIADMK   22
## 37                     Aapki Apni Party (Peoples)   22
## 38                                     CPI(ML)(L)   22
## 39                     Ambedkar National Congress   21
## 40                                            BJD   21
## 41                                            RJD   21
## 42                              Jan Adhikar Party   20
## 43                     Voters Party International   20
## 44                          Bhartiya Tribal Party   19
## 45                             Bahujan Maha Party   18
## 46                                            TRS   17
## 47                     Tamil Nadu Ilangyar Katchi   16
## 48                           Bhartiya Kisan Party   15
## 49               Purvanchal Janta Party (Secular)   14
## 50                                           SDPI   14
## 51                                            JMM   13
## 52                           Moulik Adhikar Party   13
## 53                                    Peace Party   13
## 54                   Rashtriya Jansambhavna Party   13
## 55                          Right to Recall Party   13
## 56                         Rashtriya Samaj Paksha   12
## 57                                   Sapaks Party   12
## 58                       India Praja Bandhu Party   11
## 59                         Jai Prakash Janata Dal   11
## 60                                            NPP   11
## 61                         Samajwadi Forward Bloc   11
## 62                  Anti Corruption Dynamic Party   10
## 63                          Bhartiya Lok Seva Dal   10
## 64                    Desiya Makkal Sakthi Katchi   10
## 65                                           INLD   10
## 66                                            SAD   10
## 67                                  Amra Bangalee    9
## 68                          Hindustan Shakti Sena    9
## 69                             Hum Bhartiya Party    9
## 70                                           IUML    9
## 71                                          JD(S)    9
## 72                       Swatantra Jantaraj Party    9
## 73                           Aihra National Party    8
## 74                           Ambedkar Samaj Party    8
## 75                          Bharatiya Momin Front    8
## 76                 Bharatiya Praja Surajya Paksha    8
## 77           Bhartiya Manavadhikaar Federal Party    8
## 78                           Bihar Lok Nirman Dal    8
## 79                          Hindustan Janta Party    8
## 80        Jammu & Kashmir National Panthers Party    8
## 81                             Janhit Kisan Party    8
## 82                           Proutist Bloc, India    8
## 83                                            RPI    8
## 84            Rashtriya Janshakti Party (Secular)    8
## 85                      Rashtriya Lokswaraj Party    8
## 86                        Rashtriya Ulama Council    8
## 87                        Aam Janta Party (India)    7
## 88                       Bajjikanchal Vikas Party    7
## 89                                 Baliraja Party    7
## 90          Bharatiya Jan Kranti Dal (Democratic)    7
## 91            Bharatiya Nyay-Adhikar Raksha Party    7
## 92               Bhartiya Lokmat Rashtrwadi Party    7
## 93                             Jana Jagruti Party    7
## 94                                Janata Congress    7
## 95                           Jannayak Janta Party    7
## 96                                            LJP    7
## 97                          Lok Gathbandhan Party    7
## 98                           Proutist Sarva Samaj    7
## 99                       Rashtriya Jansabha Party    7
## 100                   Rashtriya Rashtrawadi Party    7
## 101                          Samagra Utthan Party    7
## 102                  Sanatan Sanskriti Raksha Dal    7
## 103                        Sarvodaya Bharat Party    7
## 104                           Satya Bahumat Party    7
## 105                             Shoshit Samaj Dal    7
## 106               Aajad Bharat Party (Democratic)    6
## 107                  Akhil Bharat Hindu Mahasabha    6
## 108                    Bharatiya Bahujan Congress    6
## 109              Kamatapur Peoples Party (United)    6
## 110     Marxist Communist Party of India (United)    6
## 111                                  Naitik Party    6
## 112                                   PRISM Party    6
## 113                         Pattali Makkal Katchi    6
## 114                           Rashtriya Hind Sena    6
## 115           Rashtriya Janadhikar Suraksha Party    6
## 116                 Rashtriya Shoshit Samaj Party    6
## 117                 Revolutionary Socialist Party    6
## 118                    Samaj Adhikar Kalyan Party    6
## 119                           Sanyukt Vikas Party    6
## 120                       Ulzaipali Makkal Katchy    6
## 121                Viduthalai Chiruthaigal Katchi    6
## 122                        Yuva Jan Jagriti Party    6
## 123                            Aam Adhikar Morcha    5
## 124                     Akhil Bharatiya Jan Sangh    5
## 125                       Akhil Bhartiya Apna Dal    5
## 126                 Akhil Bhartiya Gondwana Party    5
## 127                Bahujan Samaj Party (Ambedkar)    5
## 128                   Bhartiya Bahujan Kranti Dal    5
## 129                     Jan Sangharsh Virat Party    5
## 130                            Janral Samaj Party    5
## 131                                  Kalinga Sena    5
## 132                     Kranti Kari Jai Hind Sena    5
## 133                                       Lok Dal    5
## 134                 Mazdoor Kirayedar Vikas Party    5
## 135                       Navarang Congress Party    5
## 136                Party for Democratic Socialism    5
## 137                    Prabuddha Republican Party    5
## 138                          Rashtra Nirman Party    5
## 139                  Rashtriya Janasachetan Party    5
## 140                        Rashtriya Kranti Party    5
## 141                     Rashtriya Lok Samta Party    5
## 142                       Rashtriya Maratha Party    5
## 143               Rashtriya Samta Party (Secular)    5
## 144                               Republican Sena    5
## 145                         Yuva Krantikari Party    5
## 146                       AARAKSHAN VIRODHI PARTY    4
## 147                   Agila India Makkal Kazhagam    4
## 148                      Akhand Rashtrawadi Party    4
## 149            All India Hindustan Congress Party    4
## 150                              Asli Deshi Party    4
## 151                              Asom Jana Morcha    4
## 152                            Bahujan Awam Party    4
## 153                              Bahujan Nyay Dal    4
## 154                       Bharat Jan Aadhar Party    4
## 155                        Bharat Lok Sewak Party    4
## 156                       Bharatiya Gana Parishad    4
## 157                  Bharatiya National Janta Dal    4
## 158                     Bhartiya Anarakshit Party    4
## 159                      Bhartiya Jan Nayak Party    4
## 160                         Bhartiya Janraj Party    4
## 161                          Bhartiya Krishak Dal    4
## 162                                          DMDK    4
## 163                        Indian Christian Front    4
## 164          Indian Labour Party (Ambedkar Phule)    4
## 165                     Indian New Congress Party    4
## 166                     Jai Jawan Jai Kisan Party    4
## 167                          Jan Satya Path Party    4
## 168                                  Janata Party    4
## 169                               Jharkhand Party    4
## 170                       Jharkhand Peoples Party    4
## 171                         Kanshiram Bahujan Dal    4
## 172                    Karnataka Karmikara Paksha    4
## 173                 Kisan Mazdoor Sangharsh Party    4
## 174                    Manvadhikar National Party    4
## 175                         Mundadugu Praja Party    4
## 176                             Nagrik Ekta Party    4
## 177                     Nationalist Justice Party    4
## 178                      Pragatisheel Samaj Party    4
## 179                           Praja Shanthi Party    4
## 180                      Rashtravadi Janata Party    4
## 181          Rashtriya Krantikari Samajwadi Party    4
## 182         Republican Party of India (Karnataka)    4
## 183                Sardar Vallabhbhai Patel Party    4
## 184                   Secular Democratic Congress    4
## 185                           Smart Indians Party    4
## 186                                           UKD    4
## 187           Uttarakhand Kranti Dal (Democratic)    4
## 188                           Vanchit Samaj Party    4
## 189                    Vyavastha Parivartan Party    4
## 190                                         AIUDF    3
## 191                     Aam Janta Party Rashtriya    3
## 192                    All India Minorities Front    3
## 193                         All India Praja Party    3
## 194                            Asom Gana Parishad    3
## 195                             Awami Samta Party    3
## 196                           Bharat Bhoomi Party    3
## 197                      Bharath Dharma Jana Sena    3
## 198                   Bharatiya Samta Samaj Party    3
## 199                          Bhartiya Dalit Party    3
## 200                          Bhartiya Insan Party    3
## 201                    Bhartiya Manav Samaj Party    3
## 202                          Bhartiya Mitra Party    3
## 203               Bhartiya Navjawan Sena (Paksha)    3
## 204        Dalit Soshit Pichhara Varg Adhikar Dal    3
## 205                         Dalita Bahujana Party    3
## 206          Democratic Party of India (Ambedkar)    3
## 207                    Freethought Party of India    3
## 208                     Ganasangam Party of India    3
## 209                           Garvi Gujarat Party    3
## 210              Hindustani Awam Morcha (Secular)    3
## 211                          Jago Hindustan Party    3
## 212                        Jai Maha Bharath Party    3
## 213           Jammu & Kashmir National Conference    3
## 214             Jammu & Kashmir People Conference    3
## 215                         Janta Dal Rashtravadi    3
## 216                        Jantantrik Vikas Party    3
## 217                                  Krupaa Party    3
## 218                              Lok Insaaf Party    3
## 219                Madhya Pradesh Jan Vikas Party    3
## 220    Marxist Leninist Party of India (Red Flag)    3
## 221                   Minorities Democratic Party    3
## 222                        Moolniwasi Samaj Party    3
## 223                 New Democratic Party of India    3
## 224                        Parivartan Samaj Party    3
## 225                      Peoples Democratic Party    3
## 226               Peoples Party of India(secular)    3
## 227                Pragatisheel Manav Samaj Party    3
## 228                    Prithviraj Janshakti Party    3
## 229                             Punjab Ekta Party    3
## 230                      Purvanchal Mahapanchayat    3
## 231                                           RLD    3
## 232             Rashtriya Bharatiya Jan Jan Party    3
## 233                   Rashtriya Jan Adhikar Party    3
## 234                  Rashtriya Mazdoor Ekta Party    3
## 235                         Rashtriya Power Party    3
## 236                        Rashtriya Sahara Party    3
## 237                      Rashtriya Samrasta Party    3
## 238               Rashtriya mahan Gantantra Party    3
## 239                              Sabka Dal United    3
## 240                            Sarva Janata Party    3
## 241                 Social Justice Party of India    3
## 242                       Socialist Party (India)    3
## 243                               Swabhiman Party    3
## 244                           Swarna Bharat Party    3
## 245                       Swatantra Bharat Paksha    3
## 246                     VANCHITSAMAJ INSAAF PARTY    3
## 247                       Vikassheel Insaan Party    3
## 248                           Vishva SHakti Party    3
## 249                                         AIMIM    2
## 250                         Aadarsh Mithila Party    2
## 251                          Aasra Lokmanch Party    2
## 252                           Adhikar Vikas Party    2
## 253                          Adhunik Bharat Party    2
## 254                            Akhand Samaj Party    2
## 255               Akhil Bharatiya Manavata Paksha    2
## 256       Akhil Bharatiya Muslim League (Secular)    2
## 257          Akhil Hind Forward Bloc (Krantikari)    2
## 258                                 Al-Hind Party    2
## 259                             All Indians Party    2
## 260                  Ambedkarist Republican Party    2
## 261                Anaithu Makkal Puratchi Katchi    2
## 262                       Anna YSR Congress Party    2
## 263                           Apna Dal (Soneylal)    2
## 264                               Apna Desh Party    2
## 265                           Atulya Bharat Party    2
## 266                            Bahujan Azad Party    2
## 267             Bharat Rakshak Party (Democratic)    2
## 268                 Bharateeya Manavadhikar party    2
## 269                 Bharatiya Bahujan Samta Party    2
## 270       Bharatiya Minorities Suraksha Mahasangh    2
## 271            Bharatiya Prajagala Kalyana Paksha    2
## 272                    Bharatiya Rashtriya Morcha    2
## 273                     Bharipa Bahujan Mahasangh    2
## 274                          Bhartiya Amrit Party    2
## 275                      Bhartiya Bhaichara Party    2
## 276                            Bhartiya Hind Fauj    2
## 277                     Bhartiya Jan Samman Party    2
## 278           Bhartiya Manvadhikaar Federal Party    2
## 279                       Bhartiya Panchyat Party    2
## 280                      Bhartiya Sarvodaya Party    2
## 281                             Challengers Party    2
## 282                  Chhattisgarh Swabhiman Manch    2
## 283      Chhattisgarh Vikas Ganga Rashtriya Party    2
## 284            Desiya Uzhavar Uzhaipalar Kazhagam    2
## 285               Dogra Swabhiman Sangathan Party    2
## 286          Ezhuchi Tamilargal Munnetra Kazhagam    2
## 287                             Hamari Apni Party    2
## 288                           Hind Congress Party    2
## 289            Indian Democratic Republican Front    2
## 290                        Indian Gandhiyan Party    2
## 291                        Indian National League    2
## 292                    Indian Peoples Green Party    2
## 293                           Indian Unity Centre    2
## 294          Indigenousn Peoples Front Of Tripura    2
## 295                      Jamat-E-Seratul Mustakim    2
## 296      Jammu & Kashmir Peoples Democratic Party    2
## 297                              Jan Samman party    2
## 298                        Jan Seva Sahayak Party    2
## 299                                Jan Shakti Dal    2
## 300                           Janhit Bharat Party    2
## 301                       Jansatta Dal Loktantrik    2
## 302                                Jansatta Party    2
## 303              Janta Kranti Party (Rashtravadi)    2
## 304                               Janta Raj Party    2
## 305                      Janvadi Party(Socialist)    2
## 306                       Jharkhand Party (Naren)    2
## 307         Jharkhand Vikas Morcha (Prajatantrik)    2
## 308                       Karnataka Jantha Paksha    2
## 309           Karnataka Praja Party (RaithaParva)    2
## 310                          Kisan Party of India    2
## 311                          Lok Jan Vikas Morcha    2
## 312                      Loktanter Suraksha Party    2
## 313                       Maanavvaadi Janta Party    2
## 314                  Maharashtra Swabhimaan Paksh    2
## 315                       Mahasankalp Janta Party    2
## 316                            Makkalatchi Katchi    2
## 317                       Manavtawadi Samaj Party    2
## 318                      Mulnibasi Party of India    2
## 319                             Naam Indiar Party    2
## 320                  National Republican Congress    2
## 321                         National Womens Party    2
## 322                          National Youth Party    2
## 323                   Nationalist Janshakti Party    2
## 324                               Navodayam Party    2
## 325                  New All India Congress Party    2
## 326                               New India Party    2
## 327            North East India Development Party    2
## 328                    Peoples Party of Arunachal    2
## 329                   Pichhara Samaj Party United    2
## 330                Poorvanchal Rashtriya Congress    2
## 331                             Praja Satta Party    2
## 332                          Public Mission Party    2
## 333                               RPI(Khobragade)    2
## 334                            Rashtriya Apna Dal    2
## 335                          Rashtriya Azad Manch    2
## 336                           Rashtriya Garib Dal    2
## 337                     Rashtriya Jankranti Party    2
## 338                        Rashtriya Janmat Party    2
## 339           Rashtriya Jansangharsh Swaraj Party    2
## 340                    Rashtriya Jansurajya Party    2
## 341           Rashtriya Samajwadi Party (Secular)    2
## 342                         Rashtriya Samanta Dal    2
## 343                 Rashtriya Sarvjan Vikas Party    2
## 344         Republican Party of India (Reformist)    2
## 345          Revolutionary Marxist Party of India    2
## 346          SAD (Amritsar)(Simranjit Singh Mann)    2
## 347                                    Saaf Party    2
## 348                               Sabhi Jan Party    2
## 349                           Sabse Achchhi Party    2
## 350                           Samajik Nyaya Party    2
## 351                         Samdarshi Samaj Party    2
## 352                 Sankhyanupati Bhagidari Party    2
## 353                      Sarvjan Lok Shakti Party    2
## 354                            Sarvjan Sewa Party    2
## 355                 Sathi Aur Aapka Faisala Party    2
## 356          Subhashwadi Bhartiya Samajwadi Party    2
## 357              Svatantra Bharat Satyagrah Party    2
## 358                             Swabhimani Paksha    2
## 359                     Swaraj Party (Loktantrik)    2
## 360          The National Road Map Party of India    2
## 361                Uttarakhand Pragatisheel Party    2
## 362                             Vikas Insaf Party    2
## 363                             Vishwa Jana Party    2
## 364                                  Voters Party    2
## 365                           Wazib Adhikar Party    2
## 366                        Welfare Party Of India    2
## 367                                   Yuva Sarkar    2
## 368                                    AJSU Party    1
## 369                     Aadarsh Janata Sewa Party    1
## 370                         Aadarsh Sangram Party    1
## 371                             Aap Aur Hum Party    1
## 372                     Adarsh Nyay Rakshak Party    1
## 373                            Adarsh Samaj Party    1
## 374                    Adarshwaadi Congress Party    1
## 375                             Adim Bhartiya Dal    1
## 376    Ahila India Dhayaga Makkal Munnetra Katchi    1
## 377                        Ahimsa Socialist Party    1
## 378                            Ahinsa Samaj Party    1
## 379                             Akhand Hind Party    1
## 380             Akhil Bharat Samagra Kranti Party    1
## 381                          Akhil Bharatiya Sena    1
## 382                    Akhil Bhartiya Ekata Party    1
## 383                Akhil Bhartiya Jharkhand Party    1
## 384                        Akhil Bhartiya Lok Dal    1
## 385                  Akhil Bhartiya Mithila Party    1
## 386                Akhil Bhartiya Navnirman Party    1
## 387        Akhil Bhartiya Sarvadharma Samaj Party    1
## 388                  Akila India Vallalar Peravai    1
## 389                  All India Jana Andolan Party    1
## 390                        All India Labour Party    1
## 391        All India Majlis-E-Ittehadul Muslimeen    1
## 392                       All India N.R. Congress    1
## 393             All India Peoples Front (Radical)    1
## 394 All India Puratchi Thalaivar Makkal Munnettra    1
## 395                      All India Ulama Congress    1
## 396               All Indian Rajiv Congress Party    1
## 397                          All Pensioners Party    1
## 398                         All Pensioner’s Party    1
## 399                             All Peoples Party    1
## 400                            Ambedkar Yug Party    1
## 401                    Ambedkarite Party Of India    1
## 402                   Anaithu India Makkal Katchi    1
## 403                         Anaithu Makkal Katchi    1
## 404                 Andaman & Nicobar Janta Party    1
## 405                        Andhra Chaitanya Party    1
## 406                   Andhra Rastra Praja Samithi    1
## 407                            Anjaan Aadmi Party    1
## 408                                Annadata Party    1
## 409                         Apna Dal United Party    1
## 410                              Apna Kisan Party    1
## 411                              Apna Samaj Party    1
## 412                            Assam Dristi Party    1
## 413             Autonomous State Demand Committee    1
## 414                     Azad Mazdoor Kissan Party    1
## 415                            B. C. United Front    1
## 416                            BHARTIYA JANTA DAL    1
## 417                Bahujan Samyak Party (Mission)    1
## 418                          Bahujan Suraksha Dal    1
## 419                            Bahujan Uday Manch    1
## 420                         Bahujan Vikas Aaghadi    1
## 421       Bahujana Raajyam Party (Phule Ambedkar)    1
## 422                                 Bhapase Party    1
## 423               Bharat Bhrashtachar Mitao Party    1
## 424                           Bharat Nirman Party    1
## 425                      Bharatiya Aam Awam Party    1
## 426                   Bharatiya Aavaam Ekta Party    1
## 427            Bharatiya Bahujan Parivartan Party    1
## 428                       Bharatiya Bahujan Party    1
## 429                    Bharatiya Jan Morcha Party    1
## 430              Bharatiya Kisan Parivartan Party    1
## 431                 Bharatiya Majdoor Janta Party    1
## 432                       Bharatiya Peoples Party    1
## 433 Bharatiya Prajatantrik Shudh Gandhiwadi Krish    1
## 434                  Bharatiya Rashtravadi Paksha    1
## 435           Bharatiya Rashtravadi Samanta Party    1
## 436           Bharatiya Sampuran Krantikari Party    1
## 437              Bharatiya Sarvodaya Kranti Party    1
## 438                Bharatrashtra Democratic Party    1
## 439                            Bhartiya Azad Sena    1
## 440                          Bhartiya Harit Party    1
## 441                    Bhartiya Jan Sampark Party    1
## 442                      Bhartiya Jan Satta Party    1
## 443               Bhartiya Janta Dal (Integrated)    1
## 444              Bhartiya Kisan Union Samaj Party    1
## 445                     Bhartiya Kranti Vir Party    1
## 446                Bhartiya Naujawan Inklav Party    1
## 447                       Bhartiya Navodaya Party    1
## 448         Bhartiya New Sanskar Krantikari Party    1
## 449                          Bhartiya Nojawan Dal    1
## 450                Bhartiya Pragatisheel Congress    1
## 451                    Bhartiya Rashtrawadi Party    1
## 452             Bhartiya Republican Party (Insan)    1
## 453            Bhartiya Sarvjan Hitey Samaj Party    1
## 454                   Bhartiya Vanchitsamaj Party    1
## 455                        Bodoland Peoples Front    1
## 456                        Bundelkhand Kranti Dal    1
## 457                     Chandigarh Ki Aawaz Party    1
## 458                    Christian Democratic Front    1
## 459                    Corruption Abolition Party    1
## 460                                  Daksha Party    1
## 461        Democratic Corruption Liberation Front    1
## 462                     Democratic Party of India    1
## 463      Democratic Prajakranthi Party Secularist    1
## 464                             Desh Janhit Party    1
## 465                      Dr. Bhimrao Ambedkar Dal    1
## 466                              Ekta Samaj Party    1
## 467                               Engineers Party    1
## 468                             Fauji Janta Party    1
## 469               Forward Democratic Labour Party    1
## 470                            Gareeb Aadmi Party    1
## 471                         Garib Janshakti Party    1
## 472                     Gorkha Rashtriya Congress    1
## 473                 Gujarat Janta Panchayat Party    1
## 474                            Hamro Sikkim Party    1
## 475              Hardam Manavtawadi Rashtriya Dal    1
## 476                     Himachal Jan Kranti Party    1
## 477                           Hind Samrajya Party    1
## 478                             Hindu Samaj Party    1
## 479                       Hindusthan Praja Paksha    1
## 480                               Hum Sabki Party    1
## 481                  Ilantamilar Munnani Kazhagam    1
## 482                     Independent Peoples Party    1
## 483                    Indian Indira Congress (R)    1
## 484                Indian Rakshaka Nayakudu Party    1
## 485                             Inqalab Vikas Dal    1
## 486                                Jai Hind Party    1
## 487                          Jai Hind Samaj Party    1
## 488                                 Jai Lok Party    1
## 489                              Jai Swaraj Party    1
## 490                     Jai Vijaya Bharathi Party    1
## 491        Jammu & Kashmir Pir Panjal Awami Party    1
## 492                        Jan Adesh Akshuni Sena    1
## 493                Jan Adhikar Party (Loktantrik)    1
## 494                               Jan Sangh Party    1
## 495                         Jan Shakti Ekta Party    1
## 496                Janapaalana Party (Democratic)    1
## 497                         Janta Raj Vikas Party    1
## 498                     Jharkhand Anushilan Party    1
## 499              Jharkhand Mukti Morcha (Ulgulan)    1
## 500                     Jharkhand Party (Secular)    1
## 501                                 Justice Party    1
## 502                                     Jwala Dal    1
## 503                   Kalyankari Jantantrik Party    1
## 504                Kannada Chalavali Vatal Paksha    1
## 505         Karnataka Pragnyavantha Janatha Party    1
## 506                      Kartavya Rashtriya Party    1
## 507                               Kerala Congress    1
## 508                           Kerala Congress (M)    1
## 509                             Khusro Sena Party    1
## 510                  Kisan Majdoor Berojgar Sangh    1
## 511                            Kisan Raksha Party    1
## 512                                Lok Chetna Dal    1
## 513                       Lok Jan Sangharsh Party    1
## 514                                  Lok Sewa Dal    1
## 515                                Lokjagar Party    1
## 516                          Lokpriya Samaj Party    1
## 517                                    Loksangram    1
## 518                   Loktantrik Jan Swaraj Party    1
## 519                    Loktantrik Janshakti Party    1
## 520                  Loktantrik Rashrtavadi Party    1
## 521                                           MNF    1
## 522                       Maharashtra Kranti Sena    1
## 523                    Mahila & Yuva Shakti Party    1
## 524                     Majdoor Kisan Union Party    1
## 525          Makkal Sananayaga Kudiyarasu Katchi,    1
## 526              Manipur Democratic Peoples Front    1
## 527                         Manipur Peoples Party    1
## 528                                Manuvadi Party    1
## 529                    Marumalarchi Janata Katchi    1
## 530 Mazdoor Dalit Kisaan Mahila Gareeb Party (Hin    1
## 531                   Mera Adhikaar Rashtriya Dal    1
## 532                     Mithilanchal Mukti Morcha    1
## 533                                           NPF    1
## 534                           National Apni Party    1
## 535              National Bhrashtachar Mukt Party    1
## 536                   National Dalitha Dhal Party    1
## 537                    National Development Party    1
## 538                    National Fifty Fifty Front    1
## 539                        National Jagaran Party    1
## 540                         National Labour Party    1
## 541                         National Lokmat Party    1
## 542                   National Nava Kranthi Party    1
## 543                                National Women    1
## 544      Nationalist Democratic Progressive Party    1
## 545                     Nationalist Peoples Front    1
## 546                       Nava Praja Rajyam Party    1
## 547                              Nava Samaj Party    1
## 548                               Navataram Party    1
## 549                            Navbharat Ekta Dal    1
## 550                        Navbharat Nirman Party    1
## 551                               Navnirman Party    1
## 552                        Navsarjan Bharat Party    1
## 553                            Nawan Punjab Party    1
## 554 Netaji Subhash Chander Bose Rashtriya Azad Pa    1
## 555                        Nirbhay Bharteey Party    1
## 556                            Odisha Pragati Dal    1
## 557                          People’s Union Party    1
## 558                           Pichhra Samaj Party    1
## 559                        Pragatisheel Lok Manch    1
## 560                        Prahar Janshakti Party    1
## 561                          Prajaa Swaraaj Party    1
## 562                      Prajatantra Aadhar Party    1
## 563                   Prajatantrik Samadhan Party    1
## 564                          Pravasi Nivasi Party    1
## 565                               Prem Janata Dal    1
## 566                           Proutist Bloc India    1
## 567                  Puducherry Development Party    1
## 568                           Punjab Labour Party    1
## 569                       RASHTRIYA VIKLANG PARTY    1
## 570                       Radical Democrats Party    1
## 571                            Raita Bharat Party    1
## 572                        Rajnaitik Vikalp Party    1
## 573                            Rajyadhikara Party    1
## 574                              Rashtra Sewa Dal    1
## 575                    Rashtra Vikas Zumbes Party    1
## 576                        Rashtravadi Kranti Dal    1
## 577                    Rashtravadi Party (Bharat)    1
## 578                      Rashtrawadi Chetna Party    1
## 579                    Rashtrawadi Party of India    1
## 580                   Rashtrawadi Party of India,    1
## 581                    Rashtrawadi Shramjeevi Dal    1
## 582                Rashtriya Aadarsh Member Party    1
## 583                        Rashtriya Aamjan Party    1
## 584                        Rashtriya Ahinsa Manch    1
## 585                        Rashtriya Ambedkar Dal    1
## 586                      Rashtriya Backward Party    1
## 587              Rashtriya Bahujan Congress Party    1
## 588               Rashtriya Bhagidari Samaj Party    1
## 589                          Rashtriya Dal United    1
## 590                      Rashtriya Gondvana Party    1
## 591                   Rashtriya Indepndent Morcha    1
## 592                    Rashtriya Jan Gaurav Party    1
## 593                    Rashtriya Janadhikar Party    1
## 594              Rashtriya Janhit Sangharsh Party    1
## 595                      Rashtriya Jansanchar Dal    1
## 596                       Rashtriya Jansena Party    1
## 597                         Rashtriya Janta Party    1
## 598       Rashtriya Jantantrik Bharat Vikas Party    1
## 599                     Rashtriya Janutthan Party    1
## 600         Rashtriya Janvikas Party (Democratic)    1
## 601           Rashtriya Janwadi Party (Socialist)    1
## 602     Rashtriya Jatigat Aarakshan Virodhi Party    1
## 603               Rashtriya Lok Sarvadhikar Party    1
## 604                    Rashtriya Loktantrik Party    1
## 605                        Rashtriya Mahila Party    1
## 606                      Rashtriya Mangalam Party    1
## 607                      Rashtriya Matadata Party    1
## 608                        Rashtriya Naujawan Dal    1
## 609             Rashtriya Nav Nirman Bharat Party    1
## 610                       Rashtriya Pragati Party    1
## 611            Rashtriya Praja Congress (Secular)    1
## 612                        Rashtriya Sahyog Party    1
## 613                   Rashtriya Samta Vikas Party    1
## 614                       Rashtriya Sangail Party    1
## 615                 Rashtriya Surya Prakash Party    1
## 616                         Rashtriya Vikas Party    1
## 617                       Rashtriya Vyapari Party    1
## 618                   Rastriya Aam Jan Seva Party    1
## 619                         Rastriya Insaaf Party    1
## 620                   Rayalaseema Rashtra Samithi    1
## 621                          Real Democracy Party    1
## 622                       Republican Bahujan Sena    1
## 623                   Republican Paksha (Khoripa)    1
## 624            Republican Party of India (Kamble)    1
## 625 Revolutionary Socialist Party of India(Marxis    1
## 626                                           SDF    1
## 627                             Sadan Vikas Party    1
## 628                             Sajag Samaj Party    1
## 629                          Samaanya Praja Party    1
## 630                           Samaj Bhalai Morcha    1
## 631                   Samajtantric Party of India    1
## 632                        Samajwadi Jan Parishad    1
## 633               Samajwadi Janata Dal Democratic    1
## 634             Samajwadi Janata Party(Karnataka)    1
## 635                         Samajwadi Samaj Party    1
## 636                             Samata Kranti Dal    1
## 637                         Samata Samadhan Party    1
## 638                       Samrat Ashok Sena Party    1
## 639                             Samta Vikas Party    1
## 640                                Sangharsh Sena    1
## 641                          Sanjhi Virasat Party    1
## 642                         Sanman Rajkiya Paksha    1
## 643                              Sarv Vikas Party    1
## 644                             Sarvadharam Party    1
## 645            Sarvadharam Party (Madhya Pradesh)    1
## 646                       Sarvodaya Prabhat Party    1
## 647                              Sarvshreshth Dal    1
## 648                            Satya Kranti Party    1
## 649                     Shakti Sena (Bharat Desh)    1
## 650                              Shane Hind Fourm    1
## 651                 Shiromani Akali Dal (Taksali)    1
## 652                              Shri Janta Party    1
## 653                      Sikkim Krantikari Morcha    1
## 654                       Sikkim Republican Party    1
## 655                           Sikkim United Front    1
## 656                        Socialist Janata Party    1
## 657  Subhashwadi Bhartiya Samajwadi Party (Subhas    1
## 658                            Sunder Samaj Party    1
## 659                       Swarnim Bharat Inquilab    1
## 660                         Swatantra Samaj Party    1
## 661             Tamil Maanila Congress (Moopanar)    1
## 662                   Tamil Telugu National Party    1
## 663              Tamizhaga Murpokku Makkal Katchi    1
## 664            Telangana Communist Party of India    1
## 665                        Telangana Jana Samithi    1
## 666                       Telangana Prajala Party    1
## 667                  Telangana Sakalajanula Party    1
## 668                         Telangana Yuva Shakti    1
## 669                        The Future India Party    1
## 670                                    Tola Party    1
## 671                  UTTARAKHAND PARIVARTAN PARTY    1
## 672               United Democratic Front Secular    1
## 673                       United Democratic Party    1
## 674                 United Peoples Party, Liberal    1
## 675                  United States of India Party    1
## 676                Universal Brotherhood Movement    1
## 677                  Uttar Pradesh Navnirman Sena    1
## 678            Vishwa Manav Samaj Kalyan Parishad    1
## 679            Vivasayigal Makkal Munnetra Katchi    1
## 680    Yekikrutha Sankshema Rashtriya Praja Party    1
## 681                              Yuva Vikas Party    1

IND - Political party represent number of Independent candidates.

# # Winning candidates of BJP party
data |>
  filter(Party == "BJP") |>
  filter(Winner == 1)
##                                                     Candidate Party
## 1                                                   Tapir Gao   BJP
## 2                                                Kiren Rijiju   BJP
## 3                                               Rameswar Teli   BJP
## 4                                                   Queen Oja   BJP
## 5                                           Topon Kumar Gogoi   BJP
## 6                                            Kripanath Mallah   BJP
## 7                                               Pradan Baruah   BJP
## 8                                           Shri Dilip Saikia   BJP
## 9                                                 Rajdeep Roy   BJP
## 10                                          Pallab Lochan Das   BJP
## 11                                            Gopaljee Thakur   BJP
## 12                                           Ram Kripal Yadav   BJP
## 13                                        Ravi Shankar Prasad   BJP
## 14                                          Rajiv Pratap Rudy   BJP
## 15                                                Kirron Kher   BJP
## 16                                                   Arun Sao   BJP
## 17                                               Vijay Baghel   BJP
## 18                                            Guharam Ajgalle   BJP
## 19                                              Mohan Mandavi   BJP
## 20                                            Chunni Lal Sahu   BJP
## 21                                           Sunil Kumar Soni   BJP
## 22                                             Santosh Pandey   BJP
## 23                                        Renuka Singh Saruta   BJP
## 24                                    Patel Lalubhai Babubhai   BJP
## 25                                         Shripad Yesso Naik   BJP
## 26                                 Patel Hasmukhbhai Somabhai   BJP
## 27                                      Dr. Solanki Kiritbhai   BJP
## 28                            Kachhadiya Naranbhai Bhikhabhai   BJP
## 29                                           Parbatbhai Patel   BJP
## 30                              Parbhubhai Nagarbhai Vasava\t   BJP
## 31                                         Mansukhbhai Vasava   BJP
## 32                             Dr.Bharatiben Dhirubhai Shiyal   BJP
## 33                                Rathva Gitaben Vajesingbhai   BJP
## 34                              Jasvantsinh Sumanbhai Bhabhor   BJP
## 35                                 Poonamben Hematbhai Maadam   BJP
## 36                                     Chavda Vinod Lakhamshi   BJP
## 37                                           Chauhan Devusinh   BJP
## 38                                   Shardaben Anilbhai Patel   BJP
## 39                                           Ratansinh Rathod   BJP
## 40                               Dabhi Bharatsinhji Shankarji   BJP
## 41                                          Rameshbhai Dhaduk   BJP
## 42                                         Kundaria Mohanbhai   BJP
## 43                                 Rathod Dipsinh Shankarsinh   BJP
## 44                              Jardosh Darshnaben Vikrambhai   BJP
## 45                                      Mahendrabhai Munjpara   BJP
## 46                                            Ranjanben Bhatt   BJP
## 47                                               Dr.K.C.Patel   BJP
## 48                                         Rattan Lal Kataria   BJP
## 49                                            Dharambir Singh   BJP
## 50                                                Krishan Pal   BJP
## 51                                         Rao Inderjit Singh   BJP
## 52                                            Brijendra Singh   BJP
## 53                                              Sanjay Bhatia   BJP
## 54                                                Nayab Singh   BJP
## 55                                        Arvind Kumar Sharma   BJP
## 56                                              Sunita Duggal   BJP
## 57                                     Ramesh Chander Kaushik   BJP
## 58                                         Ram Swaroop Sharma   BJP
## 59                                       Suresh Kumar Kashyap   BJP
## 60                                              Jugal Kishore   BJP
## 61                                         Dr. Jitendra Singh   BJP
## 62                                          Sunil Kumar Singh   BJP
## 63                                       Pashupati Nath Singh   BJP
## 64                                                Sunil Soren   BJP
## 65                                               Jayant Sinha   BJP
## 66                                                Arjun Munda   BJP
## 67                                             Annapurna Devi   BJP
## 68                                           Sudarshan Bhagat   BJP
## 69                                           Vishnu Dayal Ram   BJP
## 70                                                Sanjay Seth   BJP
## 71                     Gaddigoudar Parvatagouda Chandanagouda   BJP
## 72                                                P. C. Mohan   BJP
## 73                                       D.V. Sadananda Gowda   BJP
## 74                                              Tejasvi Surya   BJP
## 75                                              Angadi Suresh   BJP
## 76                                             Y. Devendrappa   BJP
## 77                                Jigajinagi Ramesh Chandappa   BJP
## 78                                          V Srinivas Prasad   BJP
## 79                                            B.N.Bache Gowda   BJP
## 80                                    Annasaheb Shankar Jolle   BJP
## 81                                            A Narayanaswamy   BJP
## 82                                             G M Siddeshwar   BJP
## 83                                         Dr. Umesh G Jadhav   BJP
## 84                                                Udasi. S.C.   BJP
## 85                                      Raja Amareshwara Naik   BJP
## 86                                              G S Basavaraj   BJP
## 87                                       Dr. Dhal Singh Bisen   BJP
## 88                                     Durga Das (D.D.) Uikey   BJP
## 89                                                Sandhya Ray   BJP
## 90                                       Prahalad Singh Patel   BJP
## 91                                     Mahendra Singh Solanky   BJP
## 92                                          Krishna Pal Singh   BJP
## 93                                   Vivek Narayan Shejwalkar   BJP
## 94                                         Vishnu Datt Sharma   BJP
## 95                     Nandkumar Singh Chouhan (Nandu Bhaiya)   BJP
## 96                                 Gajendra Umrao Singh Patel   BJP
## 97                                       Faggan Singh Kulaste   BJP
## 98                                               Rodmal Nagar   BJP
## 99                                        Guman Singh Damor\t   BJP
## 100                                    Janardan Prasad Mishra   BJP
## 101                                             Himadri Singh   BJP
## 102                                               Riti Pathak   BJP
## 103                                            Virendra Kumar   BJP
## 104                                             Anil Firojiya   BJP
## 105                                         Ramakant Bhargava   BJP
## 106                                  Sujay Radhakrishna Vikhe   BJP
## 107                                     Kapil Moreshwar Patil   BJP
## 108                                              Bharti Pawar   BJP
## 109                                     Ashok Mahadevrao Nete   BJP
## 110                                Sudhakar Tukaram Shrangare   BJP
## 111                              Chikhalikar Pratap Govindrao   BJP
## 112                                    Heena Vijaykumar Gavit   BJP
## 113                                      Khadse Raksha Nikhil   BJP
## 114 Shri. Sha. Bra. Dr. Jay Siddeshwar Shivachrya Mahaswamiji   BJP
## 115                                Ramdas Chandrabhanji Tadas   BJP
## 116                                  Dr Rajkumar Ranjan Singh   BJP
## 117                                             Harsh Vardhan   BJP
## 118                                          Meenakashi Lekhi   BJP
## 119                                             Hans Raj Hans   BJP
## 120                                       Parvesh Sahib Singh   BJP
## 121                                             Suresh Pujari   BJP
## 122                                         Aparajita Sarangi   BJP
## 123                            Smt. Sangeeta Kumari Singh Deo   BJP
## 124                   Ajay Singh Dharmendra Deol (Sunny Deol)   BJP
## 125                                               Som Parkash   BJP
## 126                                       Bhagirath Chaudhary   BJP
## 127                                         Mahant Balak Nath   BJP
## 128                                           Kanakmal Katara   BJP
## 129                                           Ranjeeta Kumari   BJP
## 130                                   Subhash Chandra Baheria   BJP
## 131                                         Arjun Ram Meghwal   BJP
## 132                                           Chandra Prakash   BJP
## 133                                              Rahul Kaswan   BJP
## 134                                             Jaskaur Meena   BJP
## 135                                               Nihal Chand   BJP
## 136                                          Ram Charan Bohra   BJP
## 137                                 Col. Rajyavardhan Rathore   BJP
## 138                                              Devaji Patel   BJP
## 139                                                  Dushyant   BJP
## 140                                             Manoj Rajoria   BJP
## 141                                           P. P. Chaudhary   BJP
## 142                                               Diya Kumari   BJP
## 143                                     Sumedhanand Saraswati   BJP
## 144                                  Sukhbir Singh Jaunapuria   BJP
## 145                                            Arjunlal Meena   BJP
## 146                                   Gangapuram Kishan Reddy   BJP
## 147                                            Rebati Tripura   BJP
## 148                                           Pratima Bhoumik   BJP
## 149                                       Satish Kumar Gautam   BJP
## 150                                              Smriti Irani   BJP
## 151                                          Dharmendra Kumar   BJP
## 152                                            Akshayabar Lal   BJP
## 153                                     Santosh Kumar Gangwar   BJP
## 154                                  Dr. Mahendra Nath Pandey   BJP
## 155                                             Rajveer Singh   BJP
## 156                                             Mukesh Rajput   BJP
## 157                                     Sadhvi Niranjan Jyoti   BJP
## 158                                     Dr. Chandra Sen Jadon   BJP
## 159                                         Dr. Mahesh Sharma   BJP
## 160                     Kirti Vardhan Singh Alias Raja Bhaiya   BJP
## 161            Ravindra Shyamnarayan Shukla Alias Ravi Kishan   BJP
## 162                                               Jai Prakash   BJP
## 163                                              Rajvir Diler   BJP
## 164                                             Anurag Sharma   BJP
## 165                                         Satyadev Pachauri   BJP
## 166                                             Rajnath Singh   BJP
## 167                                    Bholanath (B.P. Saroj)   BJP
## 168                               Hema Malini Dharmendra Deol   BJP
## 169                                               Ashok Kumar   BJP
## 170                                       Feroze Varun Gandhi   BJP
## 171                                                  Ravinder   BJP
## 172                                      Praveen Kumar Nishad   BJP
## 173                                      Maneka Sanjay Gandhi   BJP
## 174                                             Narendra Modi   BJP
## 175                                                Ajay Tamta   BJP
## 176                                        Tirath Singh Rawat   BJP
## 177                                  Ramesh Pokhriyal Nishank   BJP
## 178                                                Ajay Bhatt   BJP
## 179                                     Mala Rajya Laxmi Shah   BJP
## 180                                          Sukanta Majumdar   BJP
## 181                              Surendrajeet Singh Ahluwalia   BJP
## 182                                                Raju Bista   BJP
## 183                                         Jayanta Kumar Roy   BJP
## 184                                             Kunar Hembram   BJP
##     Criminal.Cases             Education Age Total.Assets
## 1                0         Post Graduate  54    136628259
## 2                0 Graduate Professional  47     15279000
## 3                0             10th Pass  48      4370067
## 4                0              Graduate  67    630219570
## 5                0         Post Graduate  50     12597461
## 6                0              Graduate  46      1871040
## 7                0             12th Pass  53     14307978
## 8                0              Graduate  45      6206286
## 9                0         Post Graduate  48     29901767
## 10               0              Graduate  41     14445139
## 11               0         Post Graduate  49     19301808
## 12               0              Graduate  58     29213467
## 13               0         Post Graduate  64    235275591
## 14               0         Post Graduate  58     80740349
## 15               0         Post Graduate  66    474983574
## 16               0 Graduate Professional  51     13544588
## 17               0              Graduate  59     34429027
## 18               0 Graduate Professional  52     18400837
## 19               0         Post Graduate  61     28675553
## 20               0              Graduate  51     17591683
## 21               0              Graduate  57     46068126
## 22               0 Graduate Professional  51     24861970
## 23               0             12th Pass  55     27682493
## 24               0              8th Pass  63    213993750
## 25               0              Graduate  66     65795623
## 26               0                Others  58     74699690
## 27               0         Post Graduate  69     89474039
## 28               0             12th Pass  64     35900763
## 29               0 Graduate Professional  70     41819177
## 30               0                Others  49     28350217
## 31               0         Post Graduate  61      6835957
## 32               0 Graduate Professional  55     17753161
## 33               0             12th Pass  47      8634660
## 34               0 Graduate Professional  52     27070480
## 35               0              Graduate  44    427331034
## 36               0         Post Graduate  40     33508455
## 37               0                Others  54     13023202
## 38               0             12th Pass  71    440308300
## 39               0 Graduate Professional  59     10260663
## 40               0              Graduate  64     47373221
## 41               0             10th Pass  57    357564783
## 42               0              8th Pass  67     68818120
## 43               0              8th Pass  67     23997443
## 44               0              Graduate  58     23872876
## 45               0         Post Graduate  50     79084513
## 46               0             12th Pass  56     29426428
## 47               0 Graduate Professional  69     68239480
## 48               0         Post Graduate  67     54361499
## 49               0              Graduate  64     60642205
## 50               0 Graduate Professional  62    369652786
## 51               0 Graduate Professional  69    420970754
## 52               0         Post Graduate  46    146408734
## 53               0              Graduate  51      2256739
## 54               0 Graduate Professional  49     35785621
## 55               0         Post Graduate  56     41079284
## 56               0         Post Graduate  51     42596349
## 57               0 Graduate Professional  62    235859266
## 58               0             10th Pass  60     15724337
## 59               0         Post Graduate  48     15705738
## 60               0             10th Pass  56     56481801
## 61               0         Post Graduate  62     70827203
## 62               0         Post Graduate  55    226209137
## 63               0              Graduate  69     27286918
## 64               0             12th Pass  39      4737559
## 65               0         Post Graduate  55    770749002
## 66               0             12th Pass  50     91507865
## 67               0         Post Graduate  50     97636939
## 68               0              Graduate  52     12947303
## 69               0              Graduate  68     32273873
## 70               0 Graduate Professional  60     14044267
## 71               0 Graduate Professional  68     43980663
## 72               0             12th Pass  55    755529306
## 73               0 Graduate Professional  66    209384539
## 74               0 Graduate Professional  28      1346593
## 75               0 Graduate Professional  63    366164525
## 76               0              5th Pass  67     40107878
## 77               0              Graduate  66    504122985
## 78               0         Post Graduate  71    143804441
## 79               0 Graduate Professional  76   1153501141
## 80               0             12th Pass  55    344922831
## 81               0              Graduate  62     96197642
## 82               0             10th Pass  67    380164932
## 83               0         Post Graduate  60     37490597
## 84               0             12th Pass  52    718499195
## 85               0 Graduate Professional  62     30638375
## 86               0 Graduate Professional  78    510779150
## 87               0                Others  66     88648133
## 88               0         Post Graduate  55     15413532
## 89               0         Post Graduate  45     51108660
## 90               0 Graduate Professional  59     43292483
## 91               0 Graduate Professional  35      3812464
## 92               0 Graduate Professional  43     16266408
## 93               0 Graduate Professional  71     58911673
## 94               0         Post Graduate  49     10589334
## 95               0         Post Graduate  66     19076515
## 96               0 Graduate Professional  43     67303990
## 97               0         Post Graduate  59     26702373
## 98               0              Graduate  58     40198295
## 99               0 Graduate Professional  62     42072262
## 100              0 Graduate Professional  62     20359750
## 101              0              Graduate  32     36564408
## 102              0         Post Graduate  41     51541791
## 103              0             Doctorate  65     21503766
## 104              0             12th Pass  47     26417937
## 105              0             12th Pass  66     30032282
## 106              0             Doctorate  37    168664576
## 107              0              Graduate  58    418850781
## 108              0 Graduate Professional  40    122885349
## 109              0             12th Pass  55     50136369
## 110              0             10th Pass  57    286478302
## 111              0             12th Pass  57     52178606
## 112              0         Post Graduate  31    271634532
## 113              0              Graduate  31    172713734
## 114              0              Graduate  63     27870079
## 115              0             10th Pass  65     65807822
## 116              0             Doctorate  67     19616174
## 117              0         Post Graduate  64     30171897
## 118              0 Graduate Professional  51    361441689
## 119              0             10th Pass  57    130937732
## 120              0         Post Graduate  41    155195014
## 121              0         Post Graduate  58     11673429
## 122              0              Graduate  49     31677600
## 123              0              Graduate  57    379590851
## 124              0                Others  59    871925679
## 125              0         Post Graduate  70     29404519
## 126              0             12th Pass  64     85101774
## 127              0             10th Pass  35       352929
## 128              0 Graduate Professional  62     58711904
## 129              0              8th Pass  39      3117190
## 130              0              Graduate  62    232703276
## 131              0         Post Graduate  65     23524459
## 132              0              Graduate  43     19725115
## 133              0              Graduate  42     36723865
## 134              0         Post Graduate  71    143742564
## 135              0              Graduate  48     21014362
## 136              0             12th Pass  61    165322707
## 137              0              Graduate  49    127808070
## 138              0             10th Pass  42     88332292
## 139              0         Post Graduate  48    370432373
## 140              0         Post Graduate  49     64867148
## 141              0 Graduate Professional  65    385111923
## 142              0                Others  48    165984623
## 143              0         Post Graduate  67      2827638
## 144              0             12th Pass  61   1233802420
## 145              0         Post Graduate  54     48196946
## 146              0                Others  58     81430778
## 147              0         Post Graduate  43      1948315
## 148              0              Graduate  50       642398
## 149              0             10th Pass  46    109522559
## 150              0             12th Pass  43    111099609
## 151              0             10th Pass  50     21766502
## 152              0             10th Pass  73     45691463
## 153              0 Graduate Professional  70    126356142
## 154              0             Doctorate  62     33359734
## 155              0 Graduate Professional  58    383629735
## 156              0              Graduate  50     74964501
## 157              0             12th Pass  52     10667372
## 158              0 Graduate Professional  68     42872395
## 159              0 Graduate Professional  59    478759568
## 160              0         Post Graduate  53    232735285
## 161              0             12th Pass  51    208494688
## 162              0              Graduate  61    234032624
## 163              0             12th Pass  61     14930000
## 164              0         Post Graduate  54   1243060113
## 165              0         Post Graduate  71    132382819
## 166              0         Post Graduate  67     51492709
## 167              0              Graduate  58    259027394
## 168              0             Doctorate  70   2508270292
## 169              0         Post Graduate  52     48771207
## 170              0         Post Graduate  39    603200539
## 171              0             12th Pass  55     27031724
## 172              0 Graduate Professional  30      4300614
## 173              0             12th Pass  62    556926451
## 174              0         Post Graduate  68     25136119
## 175              0             12th Pass  46      9910448
## 176              0         Post Graduate  55     15032657
## 177              0             Doctorate  59     28739888
## 178              0 Graduate Professional  57     19699529
## 179              0             12th Pass  68   1846640100
## 180              0             Doctorate  40      5825866
## 181              0 Graduate Professional  67     26521750
## 182              0              Graduate  33    151106062
## 183              0 Graduate Professional  51     11625047
## 184              0 Graduate Professional  56     10387498
##                  Constituency Liabilities Winner Gender
## 1              Arunachal East           0      1      M
## 2              Arunachal West           0      1      M
## 3                   Dibrugarh           0      1      M
## 4                     Gauhati    34034178      1      F
## 5                      Jorhat      455398      1      M
## 6                   Karimganj           0      1      M
## 7                   Lakhimpur     5839285      1      M
## 8                   Mangaldoi           0      1      M
## 9                     Silchar     6976701      1      M
## 10                     Tezpur           0      1      M
## 11                  Darbhanga     1039660      1      M
## 12                Pataliputra     1717310      1      M
## 13                Patna Sahib           0      1      M
## 14                      Saran           0      1      M
## 15                 Chandigarh     6279188      1      F
## 16                   Bilaspur       50000      1      M
## 17                       Durg     8748686      1      M
## 18             Janjgir Champa           0      1      M
## 19                     Kanker      679000      1      M
## 20                 Mahasamund     1383014      1      M
## 21                     Raipur     2482214      1      M
## 22                Rajnandgaon     1519820      1      M
## 23                    Surguja     3251275      1      F
## 24              Daman And Diu     9969514      1      M
## 25                  North Goa     1491387      1      M
## 26             Ahmedabad East     6252577      1      M
## 27             Ahmedabad West           0      1      M
## 28                     Amreli      828961      1      M
## 29                Banaskantha     4500000      1      M
## 30                    Bardoli     3676869      1      M
## 31                    Bharuch           0      1      M
## 32                  Bhavnagar     3689036      1      F
## 33             Chhota Udaipur           0      1      F
## 34                      Dahod           0      1      M
## 35                   Jamnagar    98632194      1      F
## 36                    Kachchh    12458607      1      M
## 37                      Kheda      995240      1      M
## 38                   Mahesana     7477793      1      F
## 39                 Panchmahal     1081611      1      M
## 40                      Patan     5613860      1      M
## 41                  Porbandar   217944697      1      M
## 42                     Rajkot    16566856      1      M
## 43                Sabarkantha           0      1      M
## 44                      Surat           0      1      F
## 45              Surendranagar    14822528      1      M
## 46                   Vadodara           0      1      F
## 47                     Valsad           0      1      M
## 48                     Ambala      188861      1      M
## 49       Bhiwani Mahendragarh      240000      1      M
## 50                  Faridabad   105593242      1      M
## 51                    Gurgaon    31500000      1      M
## 52                      Hisar    27225637      1      M
## 53                     Karnal      500000      1      M
## 54                Kurukshetra     5720000      1      M
## 55                     Rohtak    16778090      1      M
## 56                      Sirsa     2500000      1      F
## 57                    Sonipat           0      1      M
## 58                      Mandi      783963      1      M
## 59                     Shimla     7873806      1      M
## 60                      Jammu   350040219      1      M
## 61                   Udhampur           0      1      M
## 62                     Chatra     1889051      1      M
## 63                    Dhanbad           0      1      M
## 64                      Dumka      685516      1      M
## 65                 Hazaribagh   193271437      1      M
## 66                     Khunti    27106434      1      M
## 67                    Kodarma     3189066      1      F
## 68                  Lohardaga      525000      1      M
## 69                     Palamu       90922      1      M
## 70                     Ranchi      100000      1      M
## 71                   Bagalkot     7987991      1      M
## 72          Bangalore Central   312521957      1      M
## 73            Bangalore North   104302653      1      M
## 74            Bangalore South           0      1      M
## 75                    Belgaum   198479638      1      M
## 76                    Bellary      250000      1      M
## 77                    Bijapur     1600000      1      M
## 78             Chamarajanagar      324909      1      M
## 79              Chikkballapur           0      1      M
## 80                   Chikkodi   195595693      1      M
## 81                Chitradurga           0      1      M
## 82                 Davanagere    14670809      1      M
## 83                   Gulbarga           0      1      M
## 84                     Haveri   165566495      1      M
## 85                    Raichur      678532      1      M
## 86                     Tumkur   113844867      1      M
## 87                   Balaghat     1530693      1      M
## 88                      Betul      875803      1      M
## 89                      Bhind    13400000      1      F
## 90                      Damoh     4230614      1      M
## 91                      Dewas     1832631      1      M
## 92                       Guna      494053      1      M
## 93                    Gwalior           0      1      M
## 94                  Khajuraho     2507176      1      M
## 95                    Khandwa     4819099      1      M
## 96                   Khargone     1885020      1      M
## 97                     Mandla     1000075      1      M
## 98                    Rajgarh     3921362      1      M
## 99                     Ratlam     4890940      1      M
## 100                      Rewa      580627      1      M
## 101                   Shahdol     1736289      1      F
## 102                     Sidhi      505922      1      F
## 103                 Tikamgarh     1974216      1      M
## 104                    Ujjain     3203766      1      M
## 105                   Vidisha     3332012      1      M
## 106                Ahmednagar     2623964      1      M
## 107                  Bhiwandi     5645459      1      M
## 108                   Dindori     1449572      1      F
## 109         Gadchiroli Chimur    15682840      1      M
## 110                     Latur   100250602      1      M
## 111                    Nanded      594000      1      M
## 112                 Nandurbar    15291251      1      F
## 113                     Raver           0      1      F
## 114                   Solapur           0      1      M
## 115                    Wardha     8961387      1      M
## 116             Inner Manipur           0      1      M
## 117             Chandni Chowk           0      1      M
## 118                 New Delhi     7938378      1      F
## 119          North West Delhi    47897494      1      M
## 120                West Delhi    40097329      1      M
## 121                   Bargarh           0      1      M
## 122               Bhubaneswar     4329959      1      F
## 123                  Bolangir     7500000      1      F
## 124                 Gurdaspur   534644785      1      M
## 125                Hoshiarpur           0      1      M
## 126                     Ajmer     8319942      1      M
## 127                     Alwar           0      1      M
## 128                  Banswara     1746729      1      M
## 129                 Bharatpur           0      1      F
## 130                  Bhilwara     1827380      1      M
## 131                   Bikaner     1060314      1      M
## 132               Chittorgarh      100000      1      M
## 133                     Churu    15163379      1      M
## 134                     Dausa     5825431      1      F
## 135                Ganganagar     3631287      1      M
## 136                    Jaipur    22000000      1      M
## 137              Jaipur Rural           0      1      M
## 138                    Jalore    60936530      1      M
## 139            Jhalawar Baran    85824156      1      M
## 140           Karauli Dholpur    22121569      1      M
## 141                      Pali     7278041      1      M
## 142                 Rajsamand           0      1      F
## 143                     Sikar     2719583      1      M
## 144       Tonk Sawai Madhopur           0      1      M
## 145                   Udaipur    15602872      1      M
## 146              Secunderabad     4500000      1      M
## 147              Tripura East           0      1      M
## 148              Tripura West           0      1      F
## 149                   Aligarh    28095176      1      M
## 150                    Amethi           0      1      F
## 151                     Aonla     3324300      1      M
## 152                  Bahraich     3028133      1      M
## 153                  Bareilly    13055209      1      M
## 154                 Chandauli           0      1      M
## 155                      Etah   100220000      1      M
## 156               Farrukhabad      388246      1      M
## 157                  Fatehpur      910148      1      F
## 158                 Firozabad           0      1      M
## 159       Gautam Buddha Nagar    43863749      1      M
## 160                     Gonda    23201603      1      M
## 161                 Gorakhpur    17711043      1      M
## 162                    Hardoi     2615368      1      M
## 163                   Hathras           0      1      M
## 164                    Jhansi    14212970      1      M
## 165                    Kanpur    31052190      1      M
## 166                   Lucknow           0      1      M
## 167              Machhlishahr    11194163      1      M
## 168                   Mathura   131288062      1      F
## 169                   Misrikh     5735470      1      M
## 170                  Pilibhit    28952800      1      M
## 171                  Salempur      249400      1      M
## 172          Sant Kabir Nagar     2326248      1      M
## 173                 Sultanpur    11935800      1      F
## 174                  Varanasi           0      1      M
## 175                    Almora       55845      1      M
## 176                   Garhwal     3500000      1      M
## 177                  Haridwar       16444      1      M
## 178 Nainital-Udhamsingh Nagar           0      1      M
## 179             Tehri Garhwal  1350000000      1      F
## 180                 Balurghat     2168170      1      M
## 181        Bardhaman Durgapur      744076      1      M
## 182                Darjeeling    27428941      1      M
## 183                Jalpaiguri     1352581      1      M
## 184                  Jhargram      565000      1      M
# Winning candidates of INC party
data |>
  filter(Party == "INC") |>
  filter(Winner == 1)
##                           Candidate Party Criminal.Cases             Education
## 1                Kuldeep Rai Sharma   INC              0 Graduate Professional
## 2                    Abdul Khaleque   INC              0         Post Graduate
## 3                      Gaurav Gogoi   INC              0         Post Graduate
## 4                  Pradyut Bordoloi   INC              0         Post Graduate
## 5                    Jyotsna Mahant   INC              0         Post Graduate
## 6  Cosme Francisco Caitano Sardinha   INC              0 Graduate Professional
## 7                        Nakul Nath   INC              0              Graduate
## 8                   Vincent H. Pala   INC              0 Graduate Professional
## 9            Saptagiri Sankar Ulaka   INC              0 Graduate Professional
## 10                  V. Vaithilingam   INC              0              Graduate
## 11              Gurjeet Singh Aujla   INC              0             12th Pass
## 12                    Manish Tewari   INC              0 Graduate Professional
## 13                 Mohammad Sadique   INC              0              5th Pass
## 14                       Amar Singh   INC              0         Post Graduate
## 15          Santokh Singh Chaudhary   INC              0 Graduate Professional
## 16                Jasbir Singh Gill   INC              0                Others
## 17                     Preneet Kaur   INC              0              Graduate
## 18                  Vasanthakumar H   INC              0         Post Graduate
## 19                      Jothimani S   INC              0         Post Graduate
## 20            Thirunavukkarasar. Su   INC              0         Post Graduate
## 21                   Dr.K.Jayakumar   INC              0             Doctorate
## 22         Abu Hasem Khan Chowdhury   INC              0             Doctorate
##    Age Total.Assets                Constituency Liabilities Winner Gender
## 1   52    132233012 Andaman And Nicobar Islands    80450870      1      M
## 2   44      7398753                     Barpeta     2703693      1      M
## 3   36     13727834                    Kaliabor     1250000      1      M
## 4   59     74143272                     Nawgong     4011152      1      M
## 5   65    150639697                       Korba           0      1      F
## 6   73     79402232                   South Goa           0      1      M
## 7   44   6601946757                  Chhindwara     8791712      1      M
## 8   51    549515421                    Shillong           0      1      M
## 9   40     37587560                     Koraput     1217963      1      M
## 10  68    108015548                  Puducherry      520989      1      M
## 11  46     34011739                    Amritsar     9031565      1      M
## 12  53    154637860              Anandpur Sahib           0      1      M
## 13  79     19793884                    Faridkot      311043      1      M
## 14  65     32808836             Fatehgarh Sahib           0      1      M
## 15  72     99925185                   Jalandhar     2534363      1      M
## 16  48     81393500               Khadoor Sahib     4655000      1      M
## 17  74    635973757                     Patiala    42453369      1      F
## 18  68   4174930444               Kanniyakumari  1547511439      1      M
## 19  43      6046055                       Karur      379000      1      F
## 20  69     32182184             Tiruchirappalli       40208      1      M
## 21  69     24583769                  Tiruvallur           0      1      M
## 22  72    270959520             Maldaha Dakshin      728107      1      M

Finding Candidate who won in Andaman and Nicobar Constituency

data |>
  filter(Constituency == "Andaman And Nicobar Islands") |>
  filter(Winner == 1) |>
  select('Candidate')
##            Candidate
## 1 Kuldeep Rai Sharma

Finding Candidate with highest assets and his/her election result

data |>
  arrange(desc(Total.Assets)) |>
  select('Candidate','Party','Constituency','Gender','Winner') |>
  head(data,n=1)
##             Candidate Party Constituency Gender Winner
## 1 Ramesh Kumar Sharma   IND  Pataliputra      M      0

Finding Education Level of the candidates

data|>
  ggplot()+
  geom_bar(mapping = aes(x = Education))+
  theme(axis.text.x = element_text(angle = 90, hjust = 1)) +
  labs(title = "Education level of candidates", x = "Education", y = "Count")