2018 City Level Election Results (as reported by AA)

il-cb-aa.csv

il-genel-aa.csv

scraper.py

from unidecode import unidecode
import pandas as pd
city_meta = 'https://raw.githubusercontent.com/oztalha/2015-11-01-Elections-Turkey/master/data/city_meta.csv'
cities = pd.read_csv(city_meta) # Cities w/ Turkish characters and license place codes

# get Presidential results
city_ttl = {}
province = {}
def get_il_results(city,
                   url='http://www.haberturk.com/secim/secim2018/cumhurbaskanligi-secimi/sehir/'):
    df = pd.read_html(url+unidecode(city.il).lower()+'-'+str(city.kod))
    city_ttl[city.il] = df[13].drop(0)
    province[city.il] = df[15].drop(0)
cities.apply(get_il_results,axis=1); 

il_df = pd.concat(city_ttl).reset_index(level=0)
il_df.columns = ['City','Candidate','Count','Share']
il_df = il_df.replace('[\.%,]','',regex=True)
il_df['Count'] = il_df.Count.astype(int)
il_df['Share'] = il_df.Share.astype(float)/100.

il_df.to_csv('il-cb-aa.csv',index=False)
il_df.pivot('City','Candidate','Count').to_csv('il-cb-count.csv')
il_df.pivot('City','Candidate','Share').to_csv('il-cb-share.csv')

# get MP results
genel = {}
def get_genel(city,
              url='http://www.haberturk.com/secim/secim2018/genel-secim/sehir/'):
    df = pd.read_html(url+unidecode(city.il).lower()+'-'+str(city.kod))
    genel[city.il] = df[6].drop(0)
cities.apply(get_genel,axis=1);

df = pd.concat(genel).reset_index(level=0)
df.columns = ['City','Party','Vote_count','Share','MP_count']
df = df.replace('[\.%,]','',regex=True)
df['Vote_count'] = df.Vote_count.astype(int)
df['MP_count'] = df.MP_count.astype(int)
df['Share'] = df.Share.astype(float)/100.

df.to_csv('il-genel-aa.csv',index=False)
df.pivot('City','Party','Vote_count').to_csv('il-genel-count.csv')
df.pivot('City','Party','Share').to_csv('il-genel-share.csv')