For TamilNadu.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "#WORKING CODE - for TN \n",
    "\n",
    "import pandas as pd\n",
    "\n",
    "#For 1989-1999 datasets\n",
    "\n",
    "files=['1989.csv','1991.csv','1996.csv','1998.csv','1999.csv']\n",
    "year_parties=[]\n",
    "\n",
    "for file in files:\n",
    "    df=pd.read_csv(file)\n",
    "\n",
    "    y1=df[df['TERRITORY']=='TAMIL NADU']\n",
    "    y1=y1[['No.', '%', 'CONSTITUENCY', 'PARTY']]\n",
    "\n",
    "    j=-1\n",
    "    unique=list(y1.CONSTITUENCY.unique())\n",
    "    check=[]\n",
    "    votes_percent=[]\n",
    "    party=[]\n",
    "\n",
    "    for i in y1.index:\n",
    "        const=y1['CONSTITUENCY'][i]\n",
    "        if(const in unique and const not in check):\n",
    "            j+=1\n",
    "            check.append(const)\n",
    "            votes_percent.insert(j, y1['%'][i])\n",
    "            party.insert(j, y1['PARTY'][i])\n",
    "\n",
    "        if(const in unique and const in check):\n",
    "            if(y1['%'][i]>votes_percent[j]):\n",
    "                votes_percent[j]=y1['%'][i]\n",
    "                party[j]=y1['PARTY'][i]\n",
    "\n",
    "    f1=pd.DataFrame({'Constituency': check, file.split('.')[0]: party})\n",
    "    year_parties.append(party)\n",
    "    #print(f1)\n",
    "    \n",
    "#For 2004 dataset\n",
    "\n",
    "df=pd.read_csv('2004.csv')\n",
    "\n",
    "y1=df[df['TERRITORY']=='TAMIL NADU']\n",
    "y1=y1[['No', '% OF TOTAL VOTES', 'CONSTITUENCY', 'PARTY']]\n",
    "\n",
    "j=-1\n",
    "unique=list(y1.CONSTITUENCY.unique())\n",
    "check=[]\n",
    "votes_percent=[]\n",
    "party=[]\n",
    "\n",
    "for i in y1.index:\n",
    "    const=y1['CONSTITUENCY'][i]\n",
    "    if(const in unique and const not in check):\n",
    "        j+=1\n",
    "        check.append(const)\n",
    "        votes_percent.insert(j, y1['% OF TOTAL VOTES'][i])\n",
    "        party.insert(j, y1['PARTY'][i])\n",
    "        \n",
    "    if(const in unique and const in check):\n",
    "        if(y1['% OF TOTAL VOTES'][i]>votes_percent[j]):\n",
    "            votes_percent[j]=y1['%'][i]\n",
    "            party[j]=y1['PARTY'][i]\n",
    "\n",
    "f2=pd.DataFrame({'Constituency': check, '2004': party})\n",
    "#print(f2)\n",
    "\n",
    "#2009\n",
    "\n",
    "cols=['STATE','CONSTITUENCY','CANDIDATE','PARTY','% OF TOTAL VOTES']\n",
    "df = pd.read_csv(\"2009.csv\",usecols=cols)\n",
    "df=df[df['STATE']=='Tamil Nadu']\n",
    "\n",
    "ConstituenciesList = set(df['CONSTITUENCY'])\n",
    "Candidates_constituency = {}\n",
    "Winner={}\n",
    "\n",
    "for item in ConstituenciesList:\n",
    "    if item not in Candidates_constituency:\n",
    "        Candidates_constituency[item]=df[df['CONSTITUENCY']==item]\n",
    "    \n",
    "for dataframe in Candidates_constituency:\n",
    "    Candidates_constituency[dataframe]=Candidates_constituency[dataframe].sort_values(by=['% OF TOTAL VOTES'],ascending=False)\n",
    "    if dataframe not in Winner:\n",
    "        df_temp=Candidates_constituency[dataframe].head(1)\n",
    "        WinnerParty=str(df_temp['PARTY'])\n",
    "        WinnerParty=WinnerParty.split(' ')[4][:-6]\n",
    "        Winner[dataframe]=WinnerParty\n",
    "\n",
    "Const=[]\n",
    "Party2009=[]\n",
    "for item in Winner:\n",
    "    Const.append(item)\n",
    "    Party2009.append(Winner[item])\n",
    "    \n",
    "f3=pd.DataFrame({'Constituency': Const, '2009': Party2009})\n",
    "#print(f3)\n",
    "\n",
    "#2014\n",
    "\n",
    "cols=['TERRITORY','CONSTITUENCY','CANDIDATE','PARTY','% OF TOTAL POLLED']\n",
    "df = pd.read_csv(\"2014.csv\",usecols=cols)\n",
    "df=df[df['TERRITORY']=='Tamil Nadu']\n",
    "\n",
    "ConstituenciesList = set(df['CONSTITUENCY'])\n",
    "Candidates_constituency = {}\n",
    "Winner={}\n",
    "\n",
    "for item in ConstituenciesList:\n",
    "    if item not in Candidates_constituency:\n",
    "        Candidates_constituency[item]=df[df['CONSTITUENCY']==item]\n",
    "    \n",
    "for dataframe in Candidates_constituency:\n",
    "    Candidates_constituency[dataframe]=Candidates_constituency[dataframe].sort_values(by=['% OF TOTAL POLLED'],ascending=False)\n",
    "    if dataframe not in Winner:\n",
    "        df_temp=Candidates_constituency[dataframe].head(1)\n",
    "        WinnerParty=str(df_temp['PARTY'])\n",
    "        WinnerParty=WinnerParty.split(' ')[4][:-6]\n",
    "        Winner[dataframe]=WinnerParty\n",
    "\n",
    "Const=[]\n",
    "Party2014=[]\n",
    "for item in Winner:\n",
    "    Const.append(item)\n",
    "    Party2014.append(Winner[item])\n",
    "    \n",
    "f4=pd.DataFrame({'Constituency': Const, '2014': Party2014})\n",
    "#print(f4)\n",
    "\n",
    "\n",
    "FinalDF1 = pd.DataFrame ({'Constituency':check,'1989':year_parties[0],'1991':year_parties[1],'1996':year_parties[2],'1998':year_parties[3],'1999':year_parties[4],'2004':party})\n",
    "print (FinalDF1)\n",
    "\n",
    "FinalDF2 = pd.DataFrame ({'Constituency':Const,'2009':Party2009,'2014':Party2014})\n",
    "print (FinalDF2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Consolidating TN Data from 1989 Statewise\n",
    "\n",
    "import os\n",
    "import pandas as pd\n",
    "files=[]\n",
    "\n",
    "for file in os.listdir(os.getcwd()):\n",
    "    if not os.path.isdir(file):\n",
    "        filename=file.split('.')\n",
    "        if filename[1]=='csv' and int (filename[0])>=1989:\n",
    "            files.append(file)\n",
    "        \n",
    "files=sorted(files) \n",
    "\n",
    "#1989\n",
    "df=pd.read_csv(files[0],usecols=['TERRITORY','CONSTITUENCY','PARTY','%'])\n",
    "df1 = pd.DataFrame({'YEAR':files[0].split('.')[0],'STATE':df['TERRITORY'],'CONSTITUENCY':df['CONSTITUENCY'],'PARTY':df['PARTY'],'% of VOTES SECURED':df['%']})\n",
    "\n",
    "#1991\n",
    "df=pd.read_csv(files[1],usecols=['TERRITORY','CONSTITUENCY','PARTY','%'])\n",
    "df2=pd.DataFrame({'YEAR':files[1].split('.')[0],'STATE':df['TERRITORY'],'CONSTITUENCY':df['CONSTITUENCY'],'PARTY':df['PARTY'],'% of VOTES SECURED':df['%']})\n",
    "df1=df1.append(df2,ignore_index=True)\n",
    "\n",
    "#1996\n",
    "df=pd.read_csv(files[2],usecols=['TERRITORY','CONSTITUENCY','PARTY','%'])\n",
    "df2=pd.DataFrame({'YEAR':files[2].split('.')[0],'STATE':df['TERRITORY'],'CONSTITUENCY':df['CONSTITUENCY'],'PARTY':df['PARTY'],'% of VOTES SECURED':df['%']})\n",
    "df1=df1.append(df2,ignore_index=True)\n",
    "\n",
    "#1998\n",
    "df=pd.read_csv(files[3],usecols=['TERRITORY','CONSTITUENCY','PARTY','%'])\n",
    "df2=pd.DataFrame({'YEAR':files[3].split('.')[0],'STATE':df['TERRITORY'],'CONSTITUENCY':df['CONSTITUENCY'],'PARTY':df['PARTY'],'% of VOTES SECURED':df['%']})\n",
    "df1=df1.append(df2,ignore_index=True)\n",
    "\n",
    "#1999\n",
    "df=pd.read_csv(files[4],usecols=['TERRITORY','CONSTITUENCY','PARTY','%'])\n",
    "df2=pd.DataFrame({'YEAR':files[4].split('.')[0],'STATE':df['TERRITORY'],'CONSTITUENCY':df['CONSTITUENCY'],'PARTY':df['PARTY'],'% of VOTES SECURED':df['%']})\n",
    "df1=df1.append(df2,ignore_index=True)\n",
    "\n",
    "#2004\n",
    "df=pd.read_csv(files[5],usecols=['TERRITORY','CONSTITUENCY','PARTY','% OF TOTAL VOTES'])\n",
    "df2=pd.DataFrame({'YEAR':files[5].split('.')[0],'STATE':df['TERRITORY'],'CONSTITUENCY':df['CONSTITUENCY'],'PARTY':df['PARTY'],'% of VOTES SECURED':df['% OF TOTAL VOTES']})\n",
    "df1=df1.append(df2,ignore_index=True)\n",
    "\n",
    "#2009\n",
    "df=pd.read_csv(files[6],usecols=['STATE','CONSTITUENCY','PARTY','% OF TOTAL VOTES'])\n",
    "df2=pd.DataFrame({'YEAR':files[6].split('.')[0],'STATE':df['STATE'],'CONSTITUENCY':df['CONSTITUENCY'],'PARTY':df['PARTY'],'% of VOTES SECURED':df['% OF TOTAL VOTES']})\n",
    "df1=df1.append(df2,ignore_index=True)\n",
    "\n",
    "#2014\n",
    "df=pd.read_csv(files[7],usecols=['TERRITORY','CONSTITUENCY','PARTY','% OF TOTAL POLLED'])\n",
    "df2=pd.DataFrame({'YEAR':files[7].split('.')[0],'STATE':df['TERRITORY'],'CONSTITUENCY':df['CONSTITUENCY'],'PARTY':df['PARTY'],'% of VOTES SECURED':df['% OF TOTAL POLLED']})\n",
    "df1=df1.append(df2,ignore_index=True)\n",
    "\n",
    "if os.path.isdir('Consolidated'):\n",
    "    df1.to_csv('./Constituency Wise Vote Share per Candidate 1989-2004.csv')\n",
    "else:\n",
    "    os.mkdir('Consolidated')\n",
    "    df1.to_csv('./Consolidated/Constituency Wise Vote Share per Candidate 1989-2004.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "\n"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}