bayram_kurban_kesimi_kazaları.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "nufus = pd.read_csv(\"data/tr_iller.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Yıl</th>\n",
       "      <th>İl</th>\n",
       "      <th>Toplam Nüfus</th>\n",
       "      <th>Erkek Nüfusu</th>\n",
       "      <th>Kadın Nüfusu</th>\n",
       "      <th>Nüfus Yüzdesi</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2016</td>\n",
       "      <td>İstanbul</td>\n",
       "      <td>14.804.116</td>\n",
       "      <td>7.424.390</td>\n",
       "      <td>7.379.726</td>\n",
       "      <td>% 18.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2016</td>\n",
       "      <td>Ankara</td>\n",
       "      <td>5.346.518</td>\n",
       "      <td>2.653.431</td>\n",
       "      <td>2.693.087</td>\n",
       "      <td>% 6.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2016</td>\n",
       "      <td>İzmir</td>\n",
       "      <td>4.223.545</td>\n",
       "      <td>2.104.632</td>\n",
       "      <td>2.118.913</td>\n",
       "      <td>% 5.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2016</td>\n",
       "      <td>Bursa</td>\n",
       "      <td>2.901.396</td>\n",
       "      <td>1.454.059</td>\n",
       "      <td>1.447.337</td>\n",
       "      <td>% 3.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2016</td>\n",
       "      <td>Antalya</td>\n",
       "      <td>2.328.555</td>\n",
       "      <td>1.174.936</td>\n",
       "      <td>1.153.619</td>\n",
       "      <td>% 2.92</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Yıl        İl Toplam Nüfus Erkek Nüfusu Kadın Nüfusu Nüfus Yüzdesi\n",
       "0  2016  İstanbul   14.804.116    7.424.390    7.379.726       % 18.55\n",
       "1  2016    Ankara    5.346.518    2.653.431    2.693.087        % 6.70\n",
       "2  2016     İzmir    4.223.545    2.104.632    2.118.913        % 5.29\n",
       "3  2016     Bursa    2.901.396    1.454.059    1.447.337        % 3.64\n",
       "4  2016   Antalya    2.328.555    1.174.936    1.153.619        % 2.92"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "nufus.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "kurban = pd.read_csv(\"data/kurban_kaza.csv\", names=[\"iller\",\"kazalar\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>iller</th>\n",
       "      <th>kazalar</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>İstanbul</td>\n",
       "      <td>583</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Bursa</td>\n",
       "      <td>551</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Konya</td>\n",
       "      <td>178</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>İzmir</td>\n",
       "      <td>161</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Kırıkkale</td>\n",
       "      <td>137</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       iller  kazalar\n",
       "0   İstanbul      583\n",
       "1      Bursa      551\n",
       "2      Konya      178\n",
       "3      İzmir      161\n",
       "4  Kırıkkale      137"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "kurban.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "bilanco = pd.merge(nufus, kurban, left_on=\"İl\",right_on=\"iller\")\n",
    "bilanco.drop([\"iller\",\"Yıl\",\"Erkek Nüfusu\",\"Kadın Nüfusu\",\"Nüfus Yüzdesi\"],axis=1, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>İl</th>\n",
       "      <th>Toplam Nüfus</th>\n",
       "      <th>kazalar</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>İstanbul</td>\n",
       "      <td>14.804.116</td>\n",
       "      <td>583</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Bursa</td>\n",
       "      <td>2.901.396</td>\n",
       "      <td>551</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Konya</td>\n",
       "      <td>2.161.303</td>\n",
       "      <td>178</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>İzmir</td>\n",
       "      <td>4.223.545</td>\n",
       "      <td>161</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>Kırıkkale</td>\n",
       "      <td>277.984</td>\n",
       "      <td>137</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           İl Toplam Nüfus  kazalar\n",
       "0    İstanbul   14.804.116      583\n",
       "2       Bursa    2.901.396      551\n",
       "5       Konya    2.161.303      178\n",
       "1       İzmir    4.223.545      161\n",
       "58  Kırıkkale      277.984      137"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bilanco.sort_values(\"kazalar\", ascending=False).head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 101,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "İl              object\n",
       "Toplam Nüfus    object\n",
       "kazalar          int64\n",
       "dtype: object"
      ]
     },
     "execution_count": 101,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bilanco.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 102,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "bilanco[\"Toplam Nüfus\"] = bilanco[\"Toplam Nüfus\"].str.replace(\".\",\"\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 103,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "İl              object\n",
       "Toplam Nüfus    object\n",
       "kazalar          int64\n",
       "dtype: object"
      ]
     },
     "execution_count": 103,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bilanco.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 113,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "bilanco[\"Toplam Nüfus\"] = bilanco[\"Toplam Nüfus\"].astype(\"int\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 114,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "İl               object\n",
       "Toplam Nüfus      int64\n",
       "kazalar           int64\n",
       "oran-10binde    float64\n",
       "dtype: object"
      ]
     },
     "execution_count": 114,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bilanco.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 115,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "bilanco[\"oran-10binde\"] = bilanco.kazalar / bilanco[\"Toplam Nüfus\"] * 10000"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 116,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>İl</th>\n",
       "      <th>Toplam Nüfus</th>\n",
       "      <th>kazalar</th>\n",
       "      <th>oran-10binde</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>Kırıkkale</td>\n",
       "      <td>277984</td>\n",
       "      <td>137</td>\n",
       "      <td>4.928341</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>Bilecik</td>\n",
       "      <td>218297</td>\n",
       "      <td>71</td>\n",
       "      <td>3.252450</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>Kilis</td>\n",
       "      <td>130825</td>\n",
       "      <td>34</td>\n",
       "      <td>2.598892</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>Nevşehir</td>\n",
       "      <td>290895</td>\n",
       "      <td>65</td>\n",
       "      <td>2.234483</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>Çankırı</td>\n",
       "      <td>183880</td>\n",
       "      <td>38</td>\n",
       "      <td>2.066565</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Aksaray</td>\n",
       "      <td>396673</td>\n",
       "      <td>81</td>\n",
       "      <td>2.041984</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Kütahya</td>\n",
       "      <td>573642</td>\n",
       "      <td>114</td>\n",
       "      <td>1.987302</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>Gümüşhane</td>\n",
       "      <td>172034</td>\n",
       "      <td>34</td>\n",
       "      <td>1.976354</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Bursa</td>\n",
       "      <td>2901396</td>\n",
       "      <td>551</td>\n",
       "      <td>1.899086</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>Karaman</td>\n",
       "      <td>245610</td>\n",
       "      <td>43</td>\n",
       "      <td>1.750743</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Yozgat</td>\n",
       "      <td>421041</td>\n",
       "      <td>68</td>\n",
       "      <td>1.615045</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>Erzincan</td>\n",
       "      <td>226032</td>\n",
       "      <td>35</td>\n",
       "      <td>1.548453</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>Yalova</td>\n",
       "      <td>241665</td>\n",
       "      <td>35</td>\n",
       "      <td>1.448286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Eskişehir</td>\n",
       "      <td>844842</td>\n",
       "      <td>121</td>\n",
       "      <td>1.432220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Adıyaman</td>\n",
       "      <td>610484</td>\n",
       "      <td>85</td>\n",
       "      <td>1.392338</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Osmaniye</td>\n",
       "      <td>522175</td>\n",
       "      <td>72</td>\n",
       "      <td>1.378848</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>Karabük</td>\n",
       "      <td>242347</td>\n",
       "      <td>33</td>\n",
       "      <td>1.361684</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>Bayburt</td>\n",
       "      <td>90154</td>\n",
       "      <td>11</td>\n",
       "      <td>1.220134</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Çanakkale</td>\n",
       "      <td>519793</td>\n",
       "      <td>63</td>\n",
       "      <td>1.212021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Denizli</td>\n",
       "      <td>1005687</td>\n",
       "      <td>117</td>\n",
       "      <td>1.163384</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>Kars</td>\n",
       "      <td>289786</td>\n",
       "      <td>31</td>\n",
       "      <td>1.069755</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Sivas</td>\n",
       "      <td>621224</td>\n",
       "      <td>66</td>\n",
       "      <td>1.062419</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>Bartın</td>\n",
       "      <td>192389</td>\n",
       "      <td>20</td>\n",
       "      <td>1.039560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>Niğde</td>\n",
       "      <td>351468</td>\n",
       "      <td>36</td>\n",
       "      <td>1.024275</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>Kastamonu</td>\n",
       "      <td>376945</td>\n",
       "      <td>38</td>\n",
       "      <td>1.008105</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>Kırşehir</td>\n",
       "      <td>229975</td>\n",
       "      <td>23</td>\n",
       "      <td>1.000109</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>Rize</td>\n",
       "      <td>331048</td>\n",
       "      <td>32</td>\n",
       "      <td>0.966627</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>Düzce</td>\n",
       "      <td>370371</td>\n",
       "      <td>34</td>\n",
       "      <td>0.917998</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>Ardahan</td>\n",
       "      <td>98335</td>\n",
       "      <td>9</td>\n",
       "      <td>0.915239</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Erzurum</td>\n",
       "      <td>762021</td>\n",
       "      <td>68</td>\n",
       "      <td>0.892364</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Ağrı</td>\n",
       "      <td>542255</td>\n",
       "      <td>28</td>\n",
       "      <td>0.516362</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Aydın</td>\n",
       "      <td>1068260</td>\n",
       "      <td>53</td>\n",
       "      <td>0.496134</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>Amasya</td>\n",
       "      <td>326351</td>\n",
       "      <td>15</td>\n",
       "      <td>0.459628</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Şanlıurfa</td>\n",
       "      <td>1940627</td>\n",
       "      <td>88</td>\n",
       "      <td>0.453462</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Adana</td>\n",
       "      <td>2201670</td>\n",
       "      <td>93</td>\n",
       "      <td>0.422407</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Giresun</td>\n",
       "      <td>444467</td>\n",
       "      <td>18</td>\n",
       "      <td>0.404979</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>İstanbul</td>\n",
       "      <td>14804116</td>\n",
       "      <td>583</td>\n",
       "      <td>0.393809</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>İzmir</td>\n",
       "      <td>4223545</td>\n",
       "      <td>161</td>\n",
       "      <td>0.381196</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Trabzon</td>\n",
       "      <td>779379</td>\n",
       "      <td>29</td>\n",
       "      <td>0.372091</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Samsun</td>\n",
       "      <td>1295927</td>\n",
       "      <td>42</td>\n",
       "      <td>0.324092</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Manisa</td>\n",
       "      <td>1396945</td>\n",
       "      <td>45</td>\n",
       "      <td>0.322132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>Burdur</td>\n",
       "      <td>261401</td>\n",
       "      <td>8</td>\n",
       "      <td>0.306043</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Muş</td>\n",
       "      <td>406501</td>\n",
       "      <td>12</td>\n",
       "      <td>0.295202</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>Sinop</td>\n",
       "      <td>205478</td>\n",
       "      <td>6</td>\n",
       "      <td>0.292002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Isparta</td>\n",
       "      <td>427324</td>\n",
       "      <td>12</td>\n",
       "      <td>0.280817</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Balıkesir</td>\n",
       "      <td>1196176</td>\n",
       "      <td>32</td>\n",
       "      <td>0.267519</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Afyonkarahisar</td>\n",
       "      <td>714523</td>\n",
       "      <td>17</td>\n",
       "      <td>0.237921</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>Siirt</td>\n",
       "      <td>322664</td>\n",
       "      <td>7</td>\n",
       "      <td>0.216944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Malatya</td>\n",
       "      <td>781305</td>\n",
       "      <td>14</td>\n",
       "      <td>0.179187</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Antalya</td>\n",
       "      <td>2328555</td>\n",
       "      <td>41</td>\n",
       "      <td>0.176075</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Hatay</td>\n",
       "      <td>1555165</td>\n",
       "      <td>27</td>\n",
       "      <td>0.173615</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Ordu</td>\n",
       "      <td>750588</td>\n",
       "      <td>11</td>\n",
       "      <td>0.146552</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Mardin</td>\n",
       "      <td>796237</td>\n",
       "      <td>9</td>\n",
       "      <td>0.113032</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Hakkari</td>\n",
       "      <td>267813</td>\n",
       "      <td>3</td>\n",
       "      <td>0.112018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>Bingöl</td>\n",
       "      <td>269560</td>\n",
       "      <td>3</td>\n",
       "      <td>0.111292</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Şırnak</td>\n",
       "      <td>483788</td>\n",
       "      <td>5</td>\n",
       "      <td>0.103351</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Batman</td>\n",
       "      <td>576899</td>\n",
       "      <td>5</td>\n",
       "      <td>0.086670</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Muğla</td>\n",
       "      <td>923773</td>\n",
       "      <td>6</td>\n",
       "      <td>0.064951</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>Bitlis</td>\n",
       "      <td>341225</td>\n",
       "      <td>2</td>\n",
       "      <td>0.058612</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Tekirdağ</td>\n",
       "      <td>972875</td>\n",
       "      <td>5</td>\n",
       "      <td>0.051394</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>77 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                İl  Toplam Nüfus  kazalar  oran-10binde\n",
       "58       Kırıkkale        277984      137      4.928341\n",
       "67         Bilecik        218297       71      3.252450\n",
       "74           Kilis        130825       34      2.598892\n",
       "56        Nevşehir        290895       65      2.234483\n",
       "71         Çankırı        183880       38      2.066565\n",
       "45         Aksaray        396673       81      2.041984\n",
       "34         Kütahya        573642      114      1.987302\n",
       "72       Gümüşhane        172034       34      1.976354\n",
       "2            Bursa       2901396      551      1.899086\n",
       "62         Karaman        245610       43      1.750743\n",
       "42          Yozgat        421041       68      1.615045\n",
       "66        Erzincan        226032       35      1.548453\n",
       "64          Yalova        241665       35      1.448286\n",
       "21       Eskişehir        844842      121      1.432220\n",
       "29        Adıyaman        610484       85      1.392338\n",
       "37        Osmaniye        522175       72      1.378848\n",
       "63         Karabük        242347       33      1.361684\n",
       "76         Bayburt         90154       11      1.220134\n",
       "38       Çanakkale        519793       63      1.212021\n",
       "17         Denizli       1005687      117      1.163384\n",
       "57            Kars        289786       31      1.069755\n",
       "28           Sivas        621224       66      1.062419\n",
       "70          Bartın        192389       20      1.039560\n",
       "50           Niğde        351468       36      1.024275\n",
       "46       Kastamonu        376945       38      1.008105\n",
       "65        Kırşehir        229975       23      1.000109\n",
       "52            Rize        331048       32      0.966627\n",
       "47           Düzce        370371       34      0.917998\n",
       "75         Ardahan         98335        9      0.915239\n",
       "25         Erzurum        762021       68      0.892364\n",
       "..             ...           ...      ...           ...\n",
       "35            Ağrı        542255       28      0.516362\n",
       "16           Aydın       1068260       53      0.496134\n",
       "53          Amasya        326351       15      0.459628\n",
       "7        Şanlıurfa       1940627       88      0.453462\n",
       "4            Adana       2201670       93      0.422407\n",
       "40         Giresun        444467       18      0.404979\n",
       "0         İstanbul      14804116      583      0.393809\n",
       "1            İzmir       4223545      161      0.381196\n",
       "24         Trabzon        779379       29      0.372091\n",
       "13          Samsun       1295927       42      0.324092\n",
       "11          Manisa       1396945       45      0.322132\n",
       "61          Burdur        261401        8      0.306043\n",
       "43             Muş        406501       12      0.295202\n",
       "68           Sinop        205478        6      0.292002\n",
       "41         Isparta        427324       12      0.280817\n",
       "14       Balıkesir       1196176       32      0.267519\n",
       "27  Afyonkarahisar        714523       17      0.237921\n",
       "54           Siirt        322664        7      0.216944\n",
       "23         Malatya        781305       14      0.179187\n",
       "3          Antalya       2328555       41      0.176075\n",
       "10           Hatay       1555165       27      0.173615\n",
       "26            Ordu        750588       11      0.146552\n",
       "22          Mardin        796237        9      0.113032\n",
       "60         Hakkari        267813        3      0.112018\n",
       "59          Bingöl        269560        3      0.111292\n",
       "39          Şırnak        483788        5      0.103351\n",
       "33          Batman        576899        5      0.086670\n",
       "20           Muğla        923773        6      0.064951\n",
       "51          Bitlis        341225        2      0.058612\n",
       "19        Tekirdağ        972875        5      0.051394\n",
       "\n",
       "[77 rows x 4 columns]"
      ]
     },
     "execution_count": 116,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bilanco.sort_values(\"oran-10binde\",ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "4563"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bilanco.kazalar.sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}