Saba Mohammad Ali_Karachi.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 106,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib as mp\n",
    "import matplotlib.pyplot as plt\n",
    "import csv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 107,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "dataset = pd.read_csv(\"C:/Users/saba.ali/Downloads/Updated Dataset/Dataset/chronic_kidney_disease_updated.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 108,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>age</th>\n",
       "      <th>bp</th>\n",
       "      <th>sg</th>\n",
       "      <th>al</th>\n",
       "      <th>su</th>\n",
       "      <th>rbc</th>\n",
       "      <th>pc</th>\n",
       "      <th>pcc</th>\n",
       "      <th>ba</th>\n",
       "      <th>bgr</th>\n",
       "      <th>...</th>\n",
       "      <th>pcv</th>\n",
       "      <th>wbcc</th>\n",
       "      <th>rbcc</th>\n",
       "      <th>htn</th>\n",
       "      <th>dm</th>\n",
       "      <th>cad</th>\n",
       "      <th>appet</th>\n",
       "      <th>pe</th>\n",
       "      <th>ane</th>\n",
       "      <th>class</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>48</td>\n",
       "      <td>80</td>\n",
       "      <td>1.020</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>?</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>121</td>\n",
       "      <td>...</td>\n",
       "      <td>44</td>\n",
       "      <td>7800</td>\n",
       "      <td>5.2</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>ckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>7</td>\n",
       "      <td>50</td>\n",
       "      <td>1.020</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>?</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>?</td>\n",
       "      <td>...</td>\n",
       "      <td>38</td>\n",
       "      <td>6000</td>\n",
       "      <td>?</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>ckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>62</td>\n",
       "      <td>80</td>\n",
       "      <td>1.010</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>normal</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>423</td>\n",
       "      <td>...</td>\n",
       "      <td>31</td>\n",
       "      <td>7500</td>\n",
       "      <td>?</td>\n",
       "      <td>no</td>\n",
       "      <td>yes</td>\n",
       "      <td>no</td>\n",
       "      <td>poor</td>\n",
       "      <td>no</td>\n",
       "      <td>yes</td>\n",
       "      <td>ckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>48</td>\n",
       "      <td>70</td>\n",
       "      <td>1.005</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>normal</td>\n",
       "      <td>abnormal</td>\n",
       "      <td>present</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>117</td>\n",
       "      <td>...</td>\n",
       "      <td>32</td>\n",
       "      <td>6700</td>\n",
       "      <td>3.9</td>\n",
       "      <td>yes</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>poor</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "      <td>ckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>51</td>\n",
       "      <td>80</td>\n",
       "      <td>1.010</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>normal</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>106</td>\n",
       "      <td>...</td>\n",
       "      <td>35</td>\n",
       "      <td>7300</td>\n",
       "      <td>4.6</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>ckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>60</td>\n",
       "      <td>90</td>\n",
       "      <td>1.015</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>?</td>\n",
       "      <td>?</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>74</td>\n",
       "      <td>...</td>\n",
       "      <td>39</td>\n",
       "      <td>7800</td>\n",
       "      <td>4.4</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>yes</td>\n",
       "      <td>no</td>\n",
       "      <td>ckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>68</td>\n",
       "      <td>70</td>\n",
       "      <td>1.010</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>?</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>100</td>\n",
       "      <td>...</td>\n",
       "      <td>36</td>\n",
       "      <td>?</td>\n",
       "      <td>?</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>ckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>24</td>\n",
       "      <td>?</td>\n",
       "      <td>1.015</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>normal</td>\n",
       "      <td>abnormal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>410</td>\n",
       "      <td>...</td>\n",
       "      <td>44</td>\n",
       "      <td>6900</td>\n",
       "      <td>5</td>\n",
       "      <td>no</td>\n",
       "      <td>yes</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>yes</td>\n",
       "      <td>no</td>\n",
       "      <td>ckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>52</td>\n",
       "      <td>100</td>\n",
       "      <td>1.015</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>normal</td>\n",
       "      <td>abnormal</td>\n",
       "      <td>present</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>138</td>\n",
       "      <td>...</td>\n",
       "      <td>33</td>\n",
       "      <td>9600</td>\n",
       "      <td>4.0</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>yes</td>\n",
       "      <td>ckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>53</td>\n",
       "      <td>90</td>\n",
       "      <td>1.020</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>abnormal</td>\n",
       "      <td>abnormal</td>\n",
       "      <td>present</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>70</td>\n",
       "      <td>...</td>\n",
       "      <td>29</td>\n",
       "      <td>12100</td>\n",
       "      <td>3.7</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "      <td>no</td>\n",
       "      <td>poor</td>\n",
       "      <td>no</td>\n",
       "      <td>yes</td>\n",
       "      <td>ckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>50</td>\n",
       "      <td>60</td>\n",
       "      <td>1.010</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>?</td>\n",
       "      <td>abnormal</td>\n",
       "      <td>present</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>490</td>\n",
       "      <td>...</td>\n",
       "      <td>28</td>\n",
       "      <td>?</td>\n",
       "      <td>?</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>yes</td>\n",
       "      <td>ckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>63</td>\n",
       "      <td>70</td>\n",
       "      <td>1.010</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>abnormal</td>\n",
       "      <td>abnormal</td>\n",
       "      <td>present</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>380</td>\n",
       "      <td>...</td>\n",
       "      <td>32</td>\n",
       "      <td>4500</td>\n",
       "      <td>3.8</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "      <td>no</td>\n",
       "      <td>poor</td>\n",
       "      <td>yes</td>\n",
       "      <td>no</td>\n",
       "      <td>ckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>68</td>\n",
       "      <td>70</td>\n",
       "      <td>1.015</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>?</td>\n",
       "      <td>normal</td>\n",
       "      <td>present</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>208</td>\n",
       "      <td>...</td>\n",
       "      <td>28</td>\n",
       "      <td>12200</td>\n",
       "      <td>3.4</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "      <td>poor</td>\n",
       "      <td>yes</td>\n",
       "      <td>no</td>\n",
       "      <td>ckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>68</td>\n",
       "      <td>70</td>\n",
       "      <td>?</td>\n",
       "      <td>?</td>\n",
       "      <td>?</td>\n",
       "      <td>?</td>\n",
       "      <td>?</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>98</td>\n",
       "      <td>...</td>\n",
       "      <td>?</td>\n",
       "      <td>?</td>\n",
       "      <td>?</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "      <td>poor</td>\n",
       "      <td>yes</td>\n",
       "      <td>no</td>\n",
       "      <td>ckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>68</td>\n",
       "      <td>80</td>\n",
       "      <td>1.010</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>normal</td>\n",
       "      <td>abnormal</td>\n",
       "      <td>present</td>\n",
       "      <td>present</td>\n",
       "      <td>157</td>\n",
       "      <td>...</td>\n",
       "      <td>16</td>\n",
       "      <td>11000</td>\n",
       "      <td>2.6</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "      <td>poor</td>\n",
       "      <td>yes</td>\n",
       "      <td>no</td>\n",
       "      <td>ckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>40</td>\n",
       "      <td>80</td>\n",
       "      <td>1.015</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>?</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>76</td>\n",
       "      <td>...</td>\n",
       "      <td>24</td>\n",
       "      <td>3800</td>\n",
       "      <td>2.8</td>\n",
       "      <td>yes</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>yes</td>\n",
       "      <td>ckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>47</td>\n",
       "      <td>70</td>\n",
       "      <td>1.015</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>?</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>99</td>\n",
       "      <td>...</td>\n",
       "      <td>?</td>\n",
       "      <td>?</td>\n",
       "      <td>?</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>ckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>47</td>\n",
       "      <td>80</td>\n",
       "      <td>?</td>\n",
       "      <td>?</td>\n",
       "      <td>?</td>\n",
       "      <td>?</td>\n",
       "      <td>?</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>114</td>\n",
       "      <td>...</td>\n",
       "      <td>?</td>\n",
       "      <td>?</td>\n",
       "      <td>?</td>\n",
       "      <td>yes</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>poor</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>ckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>60</td>\n",
       "      <td>100</td>\n",
       "      <td>1.025</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>?</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>263</td>\n",
       "      <td>...</td>\n",
       "      <td>37</td>\n",
       "      <td>11400</td>\n",
       "      <td>4.3</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>ckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>62</td>\n",
       "      <td>60</td>\n",
       "      <td>1.015</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>?</td>\n",
       "      <td>abnormal</td>\n",
       "      <td>present</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>100</td>\n",
       "      <td>...</td>\n",
       "      <td>30</td>\n",
       "      <td>5300</td>\n",
       "      <td>3.7</td>\n",
       "      <td>yes</td>\n",
       "      <td>no</td>\n",
       "      <td>yes</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>ckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>61</td>\n",
       "      <td>80</td>\n",
       "      <td>1.015</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>abnormal</td>\n",
       "      <td>abnormal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>173</td>\n",
       "      <td>...</td>\n",
       "      <td>24</td>\n",
       "      <td>9200</td>\n",
       "      <td>3.2</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "      <td>poor</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "      <td>ckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>60</td>\n",
       "      <td>90</td>\n",
       "      <td>?</td>\n",
       "      <td>?</td>\n",
       "      <td>?</td>\n",
       "      <td>?</td>\n",
       "      <td>?</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>?</td>\n",
       "      <td>...</td>\n",
       "      <td>32</td>\n",
       "      <td>6200</td>\n",
       "      <td>3.6</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>ckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>48</td>\n",
       "      <td>80</td>\n",
       "      <td>1.025</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>normal</td>\n",
       "      <td>abnormal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>95</td>\n",
       "      <td>...</td>\n",
       "      <td>32</td>\n",
       "      <td>6900</td>\n",
       "      <td>3.4</td>\n",
       "      <td>yes</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>yes</td>\n",
       "      <td>ckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>21</td>\n",
       "      <td>70</td>\n",
       "      <td>1.010</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>?</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>?</td>\n",
       "      <td>...</td>\n",
       "      <td>?</td>\n",
       "      <td>?</td>\n",
       "      <td>?</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>poor</td>\n",
       "      <td>no</td>\n",
       "      <td>yes</td>\n",
       "      <td>ckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>42</td>\n",
       "      <td>100</td>\n",
       "      <td>1.015</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>normal</td>\n",
       "      <td>abnormal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>present</td>\n",
       "      <td>?</td>\n",
       "      <td>...</td>\n",
       "      <td>39</td>\n",
       "      <td>8300</td>\n",
       "      <td>4.6</td>\n",
       "      <td>yes</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>poor</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>ckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>61</td>\n",
       "      <td>60</td>\n",
       "      <td>1.025</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>?</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>108</td>\n",
       "      <td>...</td>\n",
       "      <td>29</td>\n",
       "      <td>8400</td>\n",
       "      <td>3.7</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>yes</td>\n",
       "      <td>ckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>75</td>\n",
       "      <td>80</td>\n",
       "      <td>1.015</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>?</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>156</td>\n",
       "      <td>...</td>\n",
       "      <td>35</td>\n",
       "      <td>10300</td>\n",
       "      <td>4</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "      <td>no</td>\n",
       "      <td>poor</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>ckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>69</td>\n",
       "      <td>70</td>\n",
       "      <td>1.010</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>normal</td>\n",
       "      <td>abnormal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>264</td>\n",
       "      <td>...</td>\n",
       "      <td>37</td>\n",
       "      <td>9600</td>\n",
       "      <td>4.1</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "      <td>good</td>\n",
       "      <td>yes</td>\n",
       "      <td>no</td>\n",
       "      <td>ckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>75</td>\n",
       "      <td>70</td>\n",
       "      <td>?</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>?</td>\n",
       "      <td>?</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>123</td>\n",
       "      <td>...</td>\n",
       "      <td>?</td>\n",
       "      <td>?</td>\n",
       "      <td>?</td>\n",
       "      <td>no</td>\n",
       "      <td>yes</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>ckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>371</th>\n",
       "      <td>69</td>\n",
       "      <td>70</td>\n",
       "      <td>1.020</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>normal</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>83</td>\n",
       "      <td>...</td>\n",
       "      <td>50</td>\n",
       "      <td>9300</td>\n",
       "      <td>5.4</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>notckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>372</th>\n",
       "      <td>28</td>\n",
       "      <td>60</td>\n",
       "      <td>1.025</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>normal</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>79</td>\n",
       "      <td>...</td>\n",
       "      <td>51</td>\n",
       "      <td>6500</td>\n",
       "      <td>5.0</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>notckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>373</th>\n",
       "      <td>72</td>\n",
       "      <td>60</td>\n",
       "      <td>1.020</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>normal</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>109</td>\n",
       "      <td>...</td>\n",
       "      <td>52</td>\n",
       "      <td>10500</td>\n",
       "      <td>5.5</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>notckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>374</th>\n",
       "      <td>61</td>\n",
       "      <td>70</td>\n",
       "      <td>1.025</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>normal</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>133</td>\n",
       "      <td>...</td>\n",
       "      <td>47</td>\n",
       "      <td>9200</td>\n",
       "      <td>4.9</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>notckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>375</th>\n",
       "      <td>79</td>\n",
       "      <td>80</td>\n",
       "      <td>1.025</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>normal</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>111</td>\n",
       "      <td>...</td>\n",
       "      <td>40</td>\n",
       "      <td>8000</td>\n",
       "      <td>6.4</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>notckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>376</th>\n",
       "      <td>70</td>\n",
       "      <td>80</td>\n",
       "      <td>1.020</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>normal</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>74</td>\n",
       "      <td>...</td>\n",
       "      <td>48</td>\n",
       "      <td>9700</td>\n",
       "      <td>5.6</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>notckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>377</th>\n",
       "      <td>58</td>\n",
       "      <td>70</td>\n",
       "      <td>1.025</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>normal</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>88</td>\n",
       "      <td>...</td>\n",
       "      <td>53</td>\n",
       "      <td>9100</td>\n",
       "      <td>5.2</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>notckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>378</th>\n",
       "      <td>64</td>\n",
       "      <td>70</td>\n",
       "      <td>1.020</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>normal</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>97</td>\n",
       "      <td>...</td>\n",
       "      <td>49</td>\n",
       "      <td>6400</td>\n",
       "      <td>4.8</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>notckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>379</th>\n",
       "      <td>71</td>\n",
       "      <td>60</td>\n",
       "      <td>1.025</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>normal</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>?</td>\n",
       "      <td>...</td>\n",
       "      <td>42</td>\n",
       "      <td>7700</td>\n",
       "      <td>5.5</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>notckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>380</th>\n",
       "      <td>62</td>\n",
       "      <td>80</td>\n",
       "      <td>1.025</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>normal</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>78</td>\n",
       "      <td>...</td>\n",
       "      <td>50</td>\n",
       "      <td>5400</td>\n",
       "      <td>5.7</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>notckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>381</th>\n",
       "      <td>59</td>\n",
       "      <td>60</td>\n",
       "      <td>1.020</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>normal</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>113</td>\n",
       "      <td>...</td>\n",
       "      <td>54</td>\n",
       "      <td>6500</td>\n",
       "      <td>4.9</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>notckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>382</th>\n",
       "      <td>71</td>\n",
       "      <td>70</td>\n",
       "      <td>1.025</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>?</td>\n",
       "      <td>?</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>79</td>\n",
       "      <td>...</td>\n",
       "      <td>40</td>\n",
       "      <td>5800</td>\n",
       "      <td>5.9</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>notckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>383</th>\n",
       "      <td>48</td>\n",
       "      <td>80</td>\n",
       "      <td>1.025</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>normal</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>75</td>\n",
       "      <td>...</td>\n",
       "      <td>51</td>\n",
       "      <td>6000</td>\n",
       "      <td>6.5</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>notckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>384</th>\n",
       "      <td>80</td>\n",
       "      <td>80</td>\n",
       "      <td>1.025</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>normal</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>119</td>\n",
       "      <td>...</td>\n",
       "      <td>49</td>\n",
       "      <td>5100</td>\n",
       "      <td>5.0</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>notckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>385</th>\n",
       "      <td>57</td>\n",
       "      <td>60</td>\n",
       "      <td>1.020</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>normal</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>132</td>\n",
       "      <td>...</td>\n",
       "      <td>42</td>\n",
       "      <td>11000</td>\n",
       "      <td>4.5</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>notckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>386</th>\n",
       "      <td>63</td>\n",
       "      <td>70</td>\n",
       "      <td>1.020</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>normal</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>113</td>\n",
       "      <td>...</td>\n",
       "      <td>52</td>\n",
       "      <td>8000</td>\n",
       "      <td>5.1</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>notckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>387</th>\n",
       "      <td>46</td>\n",
       "      <td>70</td>\n",
       "      <td>1.025</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>normal</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>100</td>\n",
       "      <td>...</td>\n",
       "      <td>43</td>\n",
       "      <td>5700</td>\n",
       "      <td>6.5</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>notckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>388</th>\n",
       "      <td>15</td>\n",
       "      <td>80</td>\n",
       "      <td>1.025</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>normal</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>93</td>\n",
       "      <td>...</td>\n",
       "      <td>50</td>\n",
       "      <td>6200</td>\n",
       "      <td>5.2</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>notckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>389</th>\n",
       "      <td>51</td>\n",
       "      <td>80</td>\n",
       "      <td>1.020</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>normal</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>94</td>\n",
       "      <td>...</td>\n",
       "      <td>46</td>\n",
       "      <td>9500</td>\n",
       "      <td>6.4</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>notckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>390</th>\n",
       "      <td>41</td>\n",
       "      <td>80</td>\n",
       "      <td>1.025</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>normal</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>112</td>\n",
       "      <td>...</td>\n",
       "      <td>52</td>\n",
       "      <td>7200</td>\n",
       "      <td>5.8</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>notckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>391</th>\n",
       "      <td>52</td>\n",
       "      <td>80</td>\n",
       "      <td>1.025</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>normal</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>99</td>\n",
       "      <td>...</td>\n",
       "      <td>52</td>\n",
       "      <td>6300</td>\n",
       "      <td>5.3</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>notckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>392</th>\n",
       "      <td>36</td>\n",
       "      <td>80</td>\n",
       "      <td>1.025</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>normal</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>85</td>\n",
       "      <td>...</td>\n",
       "      <td>44</td>\n",
       "      <td>5800</td>\n",
       "      <td>6.3</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>notckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393</th>\n",
       "      <td>57</td>\n",
       "      <td>80</td>\n",
       "      <td>1.020</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>normal</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>133</td>\n",
       "      <td>...</td>\n",
       "      <td>46</td>\n",
       "      <td>6600</td>\n",
       "      <td>5.5</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>notckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>394</th>\n",
       "      <td>43</td>\n",
       "      <td>60</td>\n",
       "      <td>1.025</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>normal</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>117</td>\n",
       "      <td>...</td>\n",
       "      <td>54</td>\n",
       "      <td>7400</td>\n",
       "      <td>5.4</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>notckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>395</th>\n",
       "      <td>50</td>\n",
       "      <td>80</td>\n",
       "      <td>1.020</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>normal</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>137</td>\n",
       "      <td>...</td>\n",
       "      <td>45</td>\n",
       "      <td>9500</td>\n",
       "      <td>4.6</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>notckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>396</th>\n",
       "      <td>55</td>\n",
       "      <td>80</td>\n",
       "      <td>1.020</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>normal</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>140</td>\n",
       "      <td>...</td>\n",
       "      <td>47</td>\n",
       "      <td>6700</td>\n",
       "      <td>4.9</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>notckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>397</th>\n",
       "      <td>42</td>\n",
       "      <td>70</td>\n",
       "      <td>1.025</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>normal</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>75</td>\n",
       "      <td>...</td>\n",
       "      <td>54</td>\n",
       "      <td>7800</td>\n",
       "      <td>6.2</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>notckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>398</th>\n",
       "      <td>12</td>\n",
       "      <td>80</td>\n",
       "      <td>1.020</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>normal</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>100</td>\n",
       "      <td>...</td>\n",
       "      <td>49</td>\n",
       "      <td>6600</td>\n",
       "      <td>5.4</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>notckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>399</th>\n",
       "      <td>17</td>\n",
       "      <td>60</td>\n",
       "      <td>1.025</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>normal</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>114</td>\n",
       "      <td>...</td>\n",
       "      <td>51</td>\n",
       "      <td>7200</td>\n",
       "      <td>5.9</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>notckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>400</th>\n",
       "      <td>58</td>\n",
       "      <td>80</td>\n",
       "      <td>1.025</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>normal</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>131</td>\n",
       "      <td>...</td>\n",
       "      <td>53</td>\n",
       "      <td>6800</td>\n",
       "      <td>6.1</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>notckd</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>401 rows × 25 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     age   bp     sg   al   su       rbc        pc         pcc          ba  \\\n",
       "0    NaN  NaN    NaN  NaN  NaN       NaN       NaN         NaN         NaN   \n",
       "1     48   80  1.020    1    0         ?    normal  notpresent  notpresent   \n",
       "2      7   50  1.020    4    0         ?    normal  notpresent  notpresent   \n",
       "3     62   80  1.010    2    3    normal    normal  notpresent  notpresent   \n",
       "4     48   70  1.005    4    0    normal  abnormal     present  notpresent   \n",
       "5     51   80  1.010    2    0    normal    normal  notpresent  notpresent   \n",
       "6     60   90  1.015    3    0         ?         ?  notpresent  notpresent   \n",
       "7     68   70  1.010    0    0         ?    normal  notpresent  notpresent   \n",
       "8     24    ?  1.015    2    4    normal  abnormal  notpresent  notpresent   \n",
       "9     52  100  1.015    3    0    normal  abnormal     present  notpresent   \n",
       "10    53   90  1.020    2    0  abnormal  abnormal     present  notpresent   \n",
       "11    50   60  1.010    2    4         ?  abnormal     present  notpresent   \n",
       "12    63   70  1.010    3    0  abnormal  abnormal     present  notpresent   \n",
       "13    68   70  1.015    3    1         ?    normal     present  notpresent   \n",
       "14    68   70      ?    ?    ?         ?         ?  notpresent  notpresent   \n",
       "15    68   80  1.010    3    2    normal  abnormal     present     present   \n",
       "16    40   80  1.015    3    0         ?    normal  notpresent  notpresent   \n",
       "17    47   70  1.015    2    0         ?    normal  notpresent  notpresent   \n",
       "18    47   80      ?    ?    ?         ?         ?  notpresent  notpresent   \n",
       "19    60  100  1.025    0    3         ?    normal  notpresent  notpresent   \n",
       "20    62   60  1.015    1    0         ?  abnormal     present  notpresent   \n",
       "21    61   80  1.015    2    0  abnormal  abnormal  notpresent  notpresent   \n",
       "22    60   90      ?    ?    ?         ?         ?  notpresent  notpresent   \n",
       "23    48   80  1.025    4    0    normal  abnormal  notpresent  notpresent   \n",
       "24    21   70  1.010    0    0         ?    normal  notpresent  notpresent   \n",
       "25    42  100  1.015    4    0    normal  abnormal  notpresent     present   \n",
       "26    61   60  1.025    0    0         ?    normal  notpresent  notpresent   \n",
       "27    75   80  1.015    0    0         ?    normal  notpresent  notpresent   \n",
       "28    69   70  1.010    3    4    normal  abnormal  notpresent  notpresent   \n",
       "29    75   70      ?    1    3         ?         ?  notpresent  notpresent   \n",
       "..   ...  ...    ...  ...  ...       ...       ...         ...         ...   \n",
       "371   69   70  1.020    0    0    normal    normal  notpresent  notpresent   \n",
       "372   28   60  1.025    0    0    normal    normal  notpresent  notpresent   \n",
       "373   72   60  1.020    0    0    normal    normal  notpresent  notpresent   \n",
       "374   61   70  1.025    0    0    normal    normal  notpresent  notpresent   \n",
       "375   79   80  1.025    0    0    normal    normal  notpresent  notpresent   \n",
       "376   70   80  1.020    0    0    normal    normal  notpresent  notpresent   \n",
       "377   58   70  1.025    0    0    normal    normal  notpresent  notpresent   \n",
       "378   64   70  1.020    0    0    normal    normal  notpresent  notpresent   \n",
       "379   71   60  1.025    0    0    normal    normal  notpresent  notpresent   \n",
       "380   62   80  1.025    0    0    normal    normal  notpresent  notpresent   \n",
       "381   59   60  1.020    0    0    normal    normal  notpresent  notpresent   \n",
       "382   71   70  1.025    0    0         ?         ?  notpresent  notpresent   \n",
       "383   48   80  1.025    0    0    normal    normal  notpresent  notpresent   \n",
       "384   80   80  1.025    0    0    normal    normal  notpresent  notpresent   \n",
       "385   57   60  1.020    0    0    normal    normal  notpresent  notpresent   \n",
       "386   63   70  1.020    0    0    normal    normal  notpresent  notpresent   \n",
       "387   46   70  1.025    0    0    normal    normal  notpresent  notpresent   \n",
       "388   15   80  1.025    0    0    normal    normal  notpresent  notpresent   \n",
       "389   51   80  1.020    0    0    normal    normal  notpresent  notpresent   \n",
       "390   41   80  1.025    0    0    normal    normal  notpresent  notpresent   \n",
       "391   52   80  1.025    0    0    normal    normal  notpresent  notpresent   \n",
       "392   36   80  1.025    0    0    normal    normal  notpresent  notpresent   \n",
       "393   57   80  1.020    0    0    normal    normal  notpresent  notpresent   \n",
       "394   43   60  1.025    0    0    normal    normal  notpresent  notpresent   \n",
       "395   50   80  1.020    0    0    normal    normal  notpresent  notpresent   \n",
       "396   55   80  1.020    0    0    normal    normal  notpresent  notpresent   \n",
       "397   42   70  1.025    0    0    normal    normal  notpresent  notpresent   \n",
       "398   12   80  1.020    0    0    normal    normal  notpresent  notpresent   \n",
       "399   17   60  1.025    0    0    normal    normal  notpresent  notpresent   \n",
       "400   58   80  1.025    0    0    normal    normal  notpresent  notpresent   \n",
       "\n",
       "     bgr   ...    pcv   wbcc rbcc  htn   dm  cad appet   pe  ane   class  \n",
       "0    NaN   ...    NaN    NaN  NaN  NaN  NaN  NaN   NaN  NaN  NaN     NaN  \n",
       "1    121   ...     44   7800  5.2  yes  yes   no  good   no   no     ckd  \n",
       "2      ?   ...     38   6000    ?   no   no   no  good   no   no     ckd  \n",
       "3    423   ...     31   7500    ?   no  yes   no  poor   no  yes     ckd  \n",
       "4    117   ...     32   6700  3.9  yes   no   no  poor  yes  yes     ckd  \n",
       "5    106   ...     35   7300  4.6   no   no   no  good   no   no     ckd  \n",
       "6     74   ...     39   7800  4.4  yes  yes   no  good  yes   no     ckd  \n",
       "7    100   ...     36      ?    ?   no   no   no  good   no   no     ckd  \n",
       "8    410   ...     44   6900    5   no  yes   no  good  yes   no     ckd  \n",
       "9    138   ...     33   9600  4.0  yes  yes   no  good   no  yes     ckd  \n",
       "10    70   ...     29  12100  3.7  yes  yes   no  poor   no  yes     ckd  \n",
       "11   490   ...     28      ?    ?  yes  yes   no  good   no  yes     ckd  \n",
       "12   380   ...     32   4500  3.8  yes  yes   no  poor  yes   no     ckd  \n",
       "13   208   ...     28  12200  3.4  yes  yes  yes  poor  yes   no     ckd  \n",
       "14    98   ...      ?      ?    ?  yes  yes  yes  poor  yes   no     ckd  \n",
       "15   157   ...     16  11000  2.6  yes  yes  yes  poor  yes   no     ckd  \n",
       "16    76   ...     24   3800  2.8  yes   no   no  good   no  yes     ckd  \n",
       "17    99   ...      ?      ?    ?   no   no   no  good   no   no     ckd  \n",
       "18   114   ...      ?      ?    ?  yes   no   no  poor   no   no     ckd  \n",
       "19   263   ...     37  11400  4.3  yes  yes  yes  good   no   no     ckd  \n",
       "20   100   ...     30   5300  3.7  yes   no  yes  good   no   no     ckd  \n",
       "21   173   ...     24   9200  3.2  yes  yes  yes  poor  yes  yes     ckd  \n",
       "22     ?   ...     32   6200  3.6  yes  yes  yes  good   no   no     ckd  \n",
       "23    95   ...     32   6900  3.4  yes   no   no  good   no  yes     ckd  \n",
       "24     ?   ...      ?      ?    ?   no   no   no  poor   no  yes     ckd  \n",
       "25     ?   ...     39   8300  4.6  yes   no   no  poor   no   no     ckd  \n",
       "26   108   ...     29   8400  3.7  yes  yes   no  good   no  yes     ckd  \n",
       "27   156   ...     35  10300    4  yes  yes   no  poor   no   no     ckd  \n",
       "28   264   ...     37   9600  4.1  yes  yes  yes  good  yes   no     ckd  \n",
       "29   123   ...      ?      ?    ?   no  yes   no  good   no   no     ckd  \n",
       "..   ...   ...    ...    ...  ...  ...  ...  ...   ...  ...  ...     ...  \n",
       "371   83   ...     50   9300  5.4   no   no   no  good   no   no  notckd  \n",
       "372   79   ...     51   6500  5.0   no   no   no  good   no   no  notckd  \n",
       "373  109   ...     52  10500  5.5   no   no   no  good   no   no  notckd  \n",
       "374  133   ...     47   9200  4.9   no   no   no  good   no   no  notckd  \n",
       "375  111   ...     40   8000  6.4   no   no   no  good   no   no  notckd  \n",
       "376   74   ...     48   9700  5.6   no   no   no  good   no   no  notckd  \n",
       "377   88   ...     53   9100  5.2   no   no   no  good   no   no  notckd  \n",
       "378   97   ...     49   6400  4.8   no   no   no  good   no   no  notckd  \n",
       "379    ?   ...     42   7700  5.5   no   no   no  good   no   no  notckd  \n",
       "380   78   ...     50   5400  5.7   no   no   no  good   no   no  notckd  \n",
       "381  113   ...     54   6500  4.9   no   no   no  good   no   no  notckd  \n",
       "382   79   ...     40   5800  5.9   no   no   no  good   no   no  notckd  \n",
       "383   75   ...     51   6000  6.5   no   no   no  good   no   no  notckd  \n",
       "384  119   ...     49   5100  5.0   no   no   no  good   no   no  notckd  \n",
       "385  132   ...     42  11000  4.5   no   no   no  good   no   no  notckd  \n",
       "386  113   ...     52   8000  5.1   no   no   no  good   no   no  notckd  \n",
       "387  100   ...     43   5700  6.5   no   no   no  good   no   no  notckd  \n",
       "388   93   ...     50   6200  5.2   no   no   no  good   no   no  notckd  \n",
       "389   94   ...     46   9500  6.4   no   no   no  good   no   no  notckd  \n",
       "390  112   ...     52   7200  5.8   no   no   no  good   no   no  notckd  \n",
       "391   99   ...     52   6300  5.3   no   no   no  good   no   no  notckd  \n",
       "392   85   ...     44   5800  6.3   no   no   no  good   no   no  notckd  \n",
       "393  133   ...     46   6600  5.5   no   no   no  good   no   no  notckd  \n",
       "394  117   ...     54   7400  5.4   no   no   no  good   no   no  notckd  \n",
       "395  137   ...     45   9500  4.6   no   no   no  good   no   no  notckd  \n",
       "396  140   ...     47   6700  4.9   no   no   no  good   no   no  notckd  \n",
       "397   75   ...     54   7800  6.2   no   no   no  good   no   no  notckd  \n",
       "398  100   ...     49   6600  5.4   no   no   no  good   no   no  notckd  \n",
       "399  114   ...     51   7200  5.9   no   no   no  good   no   no  notckd  \n",
       "400  131   ...     53   6800  6.1   no   no   no  good   no   no  notckd  \n",
       "\n",
       "[401 rows x 25 columns]"
      ]
     },
     "execution_count": 108,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dataset"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 109,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['age', 'bp', 'sg', 'al', 'su', 'rbc', 'pc', 'pcc', 'ba', 'bgr', 'bu',\n",
       "       'sc', 'sod', 'pot', 'hemo', 'pcv', 'wbcc', 'rbcc', 'htn', 'dm', 'cad',\n",
       "       'appet', 'pe', 'ane', 'class'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 109,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Question 1\n",
    "\n",
    "dataset.columns[:] #shows all column headings of the dataset"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 110,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>age</th>\n",
       "      <th>bp</th>\n",
       "      <th>sg</th>\n",
       "      <th>al</th>\n",
       "      <th>su</th>\n",
       "      <th>rbc</th>\n",
       "      <th>pc</th>\n",
       "      <th>pcc</th>\n",
       "      <th>ba</th>\n",
       "      <th>bgr</th>\n",
       "      <th>...</th>\n",
       "      <th>pcv</th>\n",
       "      <th>wbcc</th>\n",
       "      <th>rbcc</th>\n",
       "      <th>htn</th>\n",
       "      <th>dm</th>\n",
       "      <th>cad</th>\n",
       "      <th>appet</th>\n",
       "      <th>pe</th>\n",
       "      <th>ane</th>\n",
       "      <th>class</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>48</td>\n",
       "      <td>80</td>\n",
       "      <td>1.020</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>?</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>121</td>\n",
       "      <td>...</td>\n",
       "      <td>44</td>\n",
       "      <td>7800</td>\n",
       "      <td>5.2</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>ckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>7</td>\n",
       "      <td>50</td>\n",
       "      <td>1.020</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>?</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>?</td>\n",
       "      <td>...</td>\n",
       "      <td>38</td>\n",
       "      <td>6000</td>\n",
       "      <td>?</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>good</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>ckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>62</td>\n",
       "      <td>80</td>\n",
       "      <td>1.010</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>normal</td>\n",
       "      <td>normal</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>423</td>\n",
       "      <td>...</td>\n",
       "      <td>31</td>\n",
       "      <td>7500</td>\n",
       "      <td>?</td>\n",
       "      <td>no</td>\n",
       "      <td>yes</td>\n",
       "      <td>no</td>\n",
       "      <td>poor</td>\n",
       "      <td>no</td>\n",
       "      <td>yes</td>\n",
       "      <td>ckd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>48</td>\n",
       "      <td>70</td>\n",
       "      <td>1.005</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>normal</td>\n",
       "      <td>abnormal</td>\n",
       "      <td>present</td>\n",
       "      <td>notpresent</td>\n",
       "      <td>117</td>\n",
       "      <td>...</td>\n",
       "      <td>32</td>\n",
       "      <td>6700</td>\n",
       "      <td>3.9</td>\n",
       "      <td>yes</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>poor</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "      <td>ckd</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 25 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   age   bp     sg   al   su     rbc        pc         pcc          ba  bgr  \\\n",
       "0  NaN  NaN    NaN  NaN  NaN     NaN       NaN         NaN         NaN  NaN   \n",
       "1   48   80  1.020    1    0       ?    normal  notpresent  notpresent  121   \n",
       "2    7   50  1.020    4    0       ?    normal  notpresent  notpresent    ?   \n",
       "3   62   80  1.010    2    3  normal    normal  notpresent  notpresent  423   \n",
       "4   48   70  1.005    4    0  normal  abnormal     present  notpresent  117   \n",
       "\n",
       "   ...   pcv  wbcc rbcc  htn   dm  cad appet   pe  ane class  \n",
       "0  ...   NaN   NaN  NaN  NaN  NaN  NaN   NaN  NaN  NaN   NaN  \n",
       "1  ...    44  7800  5.2  yes  yes   no  good   no   no   ckd  \n",
       "2  ...    38  6000    ?   no   no   no  good   no   no   ckd  \n",
       "3  ...    31  7500    ?   no  yes   no  poor   no  yes   ckd  \n",
       "4  ...    32  6700  3.9  yes   no   no  poor  yes  yes   ckd  \n",
       "\n",
       "[5 rows x 25 columns]"
      ]
     },
     "execution_count": 110,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Question 2\n",
    "\n",
    "dataset[0:5] #slice dataset from 0 to 4"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 111,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([nan, 'yes', 'no', ' yes', '\\tno', '\\tyes', '?'], dtype=object)"
      ]
     },
     "execution_count": 111,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Question 3\n",
    "\n",
    "dataset.dm.unique() #unique values in the dm column of the dataset"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 112,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "#Question 4\n",
    "\n",
    "def cleandata(dataset):\n",
    "    func = lambda x: str(x).strip() \n",
    "    dataset = dataset.applymap(func) #removes spaces and special characters in the values\n",
    "    dataset = dataset.replace(\"?\",np.nan) #removes question marks\n",
    "    dataset = dataset.replace(\"nan\",np.nan) #replaces string nan with numpy.nan\n",
    "    return dataset"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 113,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "cd = cleandata(dataset)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 114,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([nan, 'yes', 'no'], dtype=object)"
      ]
     },
     "execution_count": 114,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cd.dm.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 115,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "#Question 5\n",
    "#converting data types of following columns from object to float\n",
    "col = ['age', 'bp', 'bgr', 'bu', 'sc', 'sod', 'pot', 'hemo', 'pcv', 'wbcc', 'rbcc']\n",
    "for i in col:\n",
    "    cd[i] = cd[i].astype(float) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 116,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "age      float64\n",
       "bp       float64\n",
       "sg        object\n",
       "al        object\n",
       "su        object\n",
       "rbc       object\n",
       "pc        object\n",
       "pcc       object\n",
       "ba        object\n",
       "bgr      float64\n",
       "bu       float64\n",
       "sc       float64\n",
       "sod      float64\n",
       "pot      float64\n",
       "hemo     float64\n",
       "pcv      float64\n",
       "wbcc     float64\n",
       "rbcc     float64\n",
       "htn       object\n",
       "dm        object\n",
       "cad       object\n",
       "appet     object\n",
       "pe        object\n",
       "ane       object\n",
       "class     object\n",
       "dtype: object"
      ]
     },
     "execution_count": 116,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cd.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 117,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Normal RBC: 60\n",
      "Abormal RBC: 47\n"
     ]
    }
   ],
   "source": [
    "#Question 6\n",
    "\n",
    "norm = 0\n",
    "abnorm = 0\n",
    "\n",
    "for i in range(len(cd.rbc)):\n",
    "    if(cd['class'][i]==\"ckd\"): #if class is ckd\n",
    "        if(cd['rbc'][i]==\"normal\"): #and rbc is normal\n",
    "            norm+=1                 #increment normal count\n",
    "        if(cd['rbc'][i]==\"abnormal\"): #if rbc is abnormal\n",
    "            abnorm+=1                #increment abnormal count\n",
    "print (\"Normal RBC: \"+str(norm))\n",
    "print (\"Abormal RBC: \"+str(abnorm))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 118,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXQAAAEhCAYAAABvIFsXAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAD5BJREFUeJzt3WuMXHd9h/Hnix0aRMnFZGtZBHBoDZUFJKHbAAJxM6C0\nQThSkQW0aEVT+Q2laVWpdfuGwqv0RS9AoZLbhG7FNaJQu1AFjAsUShRYh0DuGNFEhNrxQrkkCAhJ\nfn0xx2Vtdj3j3dk9nv8+H8maOWfOaH8vVo//c3bOTKoKSdLke0zfA0iSxsOgS1IjDLokNcKgS1Ij\nDLokNcKgS1IjDLokNcKgS1IjDLokNWLjWv6wCy64oLZu3bqWP1KSJt6hQ4e+XVVTw45b06Bv3bqV\nubm5tfyRkjTxktw7ynGecpGkRhh0SWqEQZekRhh0SWqEQZekRowU9CTnJflwkruS3Jnk+Uk2JTmQ\n5HB3e/5qDytJWtqoK/S3AzdU1a8CFwN3AnuAg1W1DTjYbUuSejI06EnOBV4EXAtQVQ9V1feAncBs\nd9gscOVqDSlJGm6UC4suAuaB9yS5GDgEXA1srqoj3TFHgc2LPTnJbmA3wFOe8pQVD7wWtu75eN8j\nNOWea67oewRpXRjllMtG4DnA31fVpcAPOen0Sg2+aXrRb5uuqr1VNV1V01NTQ69clSQt0yhBvw+4\nr6pu6rY/zCDw9yfZAtDdHludESVJoxga9Ko6CnwzyTO6XTuAO4D9wEy3bwbYtyoTSpJGMuqHc70Z\neF+SxwLfAN7I4D+D65NcBdwL7FqdESVJoxgp6FV1CzC9yEM7xjuOJGm5vFJUkhph0CWpEQZdkhph\n0CWpEQZdkhph0CWpEQZdkhph0CWpEQZdkhph0CWpEQZdkhph0CWpEQZdkhph0CWpEQZdkhph0CWp\nEQZdkhph0CWpEQZdkhph0CWpEQZdkhph0CWpEQZdkhph0CWpEQZdkhph0CWpERtHOSjJPcADwCPA\nw1U1nWQT8CFgK3APsKuqvrs6Y0qShjmdFfpLq+qSqprutvcAB6tqG3Cw25Yk9WQlp1x2ArPd/Vng\nypWPI0larlGDXsCnkhxKsrvbt7mqjnT3jwKbF3tikt1J5pLMzc/Pr3BcSdJSRjqHDrywqr6V5JeA\nA0nuWvhgVVWSWuyJVbUX2AswPT296DGSpJUbaYVeVd/qbo8BHwUuA+5PsgWguz22WkNKkoYbGvQk\nj0/yhOP3gVcCtwH7gZnusBlg32oNKUkabpRTLpuBjyY5fvz7q+qGJF8Crk9yFXAvsGv1xpQkDTM0\n6FX1DeDiRfZ/B9ixGkNJkk6fV4pKUiMMuiQ1wqBLUiMMuiQ1YtQLiySdAbbu+XjfIzTlnmuu6HuE\nsXKFLkmNMOiS1AiDLkmNMOiS1AiDLkmNMOiS1AiDLkmNMOiS1AiDLkmNMOiS1AiDLkmNMOiS1AiD\nLkmNMOiS1AiDLkmNMOiS1AiDLkmNMOiS1AiDLkmNMOiS1IiRg55kQ5IvJ/lYt70pyYEkh7vb81dv\nTEnSMKezQr8auHPB9h7gYFVtAw5225KknowU9CQXAlcA/7hg905gtrs/C1w53tEkSadj1BX63wJ/\nAjy6YN/mqjrS3T8KbF7siUl2J5lLMjc/P7/8SSVJpzQ06EleBRyrqkNLHVNVBdQSj+2tqumqmp6a\nmlr+pJKkU9o4wjEvAF6d5DeBs4FzkrwXuD/Jlqo6kmQLcGw1B5UkndrQFXpV/VlVXVhVW4HXAv9R\nVb8D7AdmusNmgH2rNqUkaaiVvA/9GuAVSQ4DL++2JUk9GeWUy/+rqs8An+nufwfYMf6RJEnL4ZWi\nktQIgy5JjTDoktQIgy5JjTDoktQIgy5JjTDoktQIgy5JjTDoktQIgy5JjTDoktQIgy5JjTDoktQI\ngy5JjTDoktQIgy5JjTDoktQIgy5JjTDoktQIgy5JjTDoktQIgy5JjTDoktQIgy5JjTDoktQIgy5J\njRga9CRnJ/likq8kuT3JW7v9m5IcSHK4uz1/9ceVJC1llBX6T4CXVdXFwCXA5UmeB+wBDlbVNuBg\nty1J6snQoNfAg93mWd2/AnYCs93+WeDKVZlQkjSSkc6hJ9mQ5BbgGHCgqm4CNlfVke6Qo8DmJZ67\nO8lckrn5+fmxDC1J+nkjBb2qHqmqS4ALgcuSPPOkx4vBqn2x5+6tqumqmp6amlrxwJKkxZ3Wu1yq\n6nvAp4HLgfuTbAHobo+NfzxJ0qhGeZfLVJLzuvuPA14B3AXsB2a6w2aAfas1pCRpuI0jHLMFmE2y\ngcF/ANdX1ceS3Ahcn+Qq4F5g1yrOKUkaYmjQq+qrwKWL7P8OsGM1hpIknT6vFJWkRhh0SWqEQZek\nRhh0SWqEQZekRhh0SWqEQZekRhh0SWqEQZekRhh0SWqEQZekRhh0SWqEQZekRhh0SWqEQZekRhh0\nSWqEQZekRhh0SWqEQZekRhh0SWqEQZekRhh0SWqEQZekRhh0SWqEQZekRgwNepInJ/l0kjuS3J7k\n6m7/piQHkhzubs9f/XElSUsZZYX+MPDHVbUdeB7wpiTbgT3AwaraBhzstiVJPRka9Ko6UlU3d/cf\nAO4EngTsBGa7w2aBK1drSEnScKd1Dj3JVuBS4CZgc1Ud6R46Cmxe4jm7k8wlmZufn1/BqJKkUxk5\n6El+EfgX4A+r6gcLH6uqAmqx51XV3qqarqrpqampFQ0rSVraSEFPchaDmL+vqj7S7b4/yZbu8S3A\nsdUZUZI0ilHe5RLgWuDOqvrrBQ/tB2a6+zPAvvGPJ0ka1cYRjnkB8Abg1iS3dPv+HLgGuD7JVcC9\nwK7VGVGSNIqhQa+qzwNZ4uEd4x1HkrRcXikqSY0w6JLUCIMuSY0w6JLUCIMuSY0w6JLUCIMuSY0w\n6JLUCIMuSY0w6JLUCIMuSY0w6JLUCIMuSY0w6JLUCIMuSY0w6JLUCIMuSY0w6JLUCIMuSY0w6JLU\nCIMuSY0w6JLUCIMuSY0w6JLUCIMuSY0w6JLUiKFBT3JdkmNJbluwb1OSA0kOd7fnr+6YkqRhRlmh\n/xNw+Un79gAHq2obcLDbliT1aGjQq+o/gf89afdOYLa7PwtcOea5JEmnabnn0DdX1ZHu/lFg81IH\nJtmdZC7J3Pz8/DJ/nCRpmBX/UbSqCqhTPL63qqaranpqamqlP06StITlBv3+JFsAuttj4xtJkrQc\nyw36fmCmuz8D7BvPOJKk5RrlbYsfAG4EnpHkviRXAdcAr0hyGHh5ty1J6tHGYQdU1euWeGjHmGeR\nJK2AV4pKUiMMuiQ1wqBLUiMMuiQ1wqBLUiMMuiQ1wqBLUiMMuiQ1wqBLUiMMuiQ1wqBLUiMMuiQ1\nwqBLUiMMuiQ1wqBLUiMMuiQ1wqBLUiMMuiQ1wqBLUiMMuiQ1wqBLUiMMuiQ1wqBLUiMMuiQ1wqBL\nUiNWFPQklye5O8nXk+wZ11CSpNO37KAn2QC8C/gNYDvwuiTbxzWYJOn0rGSFfhnw9ar6RlU9BHwQ\n2DmesSRJp2vjCp77JOCbC7bvA5578kFJdgO7u80Hk9y9gp+pE10AfLvvIYbJX/Y9gXrg7+Z4PXWU\ng1YS9JFU1V5g72r/nPUoyVxVTfc9h3Qyfzf7sZJTLt8Cnrxg+8JunySpBysJ+peAbUkuSvJY4LXA\n/vGMJUk6Xcs+5VJVDyf5feATwAbguqq6fWyTaRSeytKZyt/NHqSq+p5BkjQGXikqSY0w6JLUCIMu\nSY0w6JLUiFW/sEjjkeQ5p3q8qm5eq1kknZl8l8uESPLpUzxcVfWyNRtGWiDJO4ElQ1JVf7CG46xr\nrtAnRFW9tO8ZpCXM9T2ABlyhT6Akz2TwkcVnH99XVf/c30SSzgQGfcIkeQvwEgZB/3cGn0f/+ap6\nTZ9zSUmmgD/l5xcbng5cI77LZfK8BtgBHK2qNwIXA+f2O5IEwPuAO4GLgLcC9zD4zCetEYM+eX5U\nVY8CDyc5BzjGiZ96KfXliVV1LfDTqvpsVf0u4Op8DflH0ckzl+Q84B+AQ8CDwI39jiQB8NPu9kiS\nK4D/ATb1OM+64zn0CZZkK3BOVX2151EkkrwK+ByDV4zvBM4B3lpVfqz2GjHoEyjJs4GtLHiFVVUf\n6W0gSWcET7lMmCTXAc8Gbgce7XYXYNDVqyQXAW/m5xcbr+5rpvXGFfqESXJHVW3vew7pZEm+AlwL\n3MrPFhtU1Wd7G2qdcYU+eW5Msr2q7uh7EOkkP66qd/Q9xHrmCn3CJHkxg+9uPQr8BAiDz3J5dq+D\nad1L8npgG/BJBr+bgB8ct5ZcoU+ea4E3cNLLWukM8CwGv5sv48S/7/he9DXiCn3CJLmxqp7f9xzS\nyZJ8HdheVQ/1Pct65Qp98nw5yfuBf+PEl7W+y0V9uw04j8HVy+qBQZ88j2MQ8lcu2OfbFnUmOA+4\nK8mXOHGx4dsW14hBnyBJNgBfraq/6XsWaRFv6XuA9c5z6BMmyRer6rK+55AW6hYbn/KLWPrlCn3y\n/FeSvwM+BPzw+E7fGqY+VdUjSR5Ncm5Vfb/vedYrV+gTZonvFvU7RdW7JPuAS4EDnLjY8DtF14hB\nlzQWSWYW219Vs2s9y3pl0CdMknMZ/PHpRd2uzwJv82WuzgRJHgs8vdu8u6p+eqrjNV5+Y9HkuQ54\nANjV/fsB8J5eJ5KAJC8BDgPvAt4NfC3Ji075JI2VK/QJk+SWqrpk2D5prSU5BLy+qu7utp8OfKCq\nfq3fydYPV+iT50dJXnh8I8kLgB/1OI903FnHYw5QVV8DzupxnnXHFfqESXIJMAuc2+36LjDj19Cp\nb92XrzwKvLfb9dvAhu7LorUGDPqESfILwGuAX2ZwqfX3Gbxt8W29DqZ1r/vdfBNw/BXk54B3V9VP\nln6WxsmgT5gkNwDfA24GHjm+v6r+qrehJJ0RDPqESXJbVT2z7zmkk3V/z/kL4Kmc+J2iT+trpvXG\nS/8nzxeSPKuqbu17EOkk1wJ/BBxiwatHrR1X6BMmyR3ArwD/jV9BpzNIkpuq6rl9z7GeGfQJk+Sp\ni+2vqnvXehZpoSTXABsYfDa/3ynaA4MuaSz84Lj+GXRJaoRXikoaiyRPTPKOJDcnOZTk7Ume2Pdc\n64lBlzQuHwTmgd9icPHbPIMvYtEa8ZSLpLFY7BqJJLdW1bP6mmm9cYUuaVw+meS1SR7T/dsFfKLv\nodYTV+iSViTJA0AxuCbi8fzsoqINwINVdU5fs603XikqaUWq6gnH7yfZBGwDzu5vovXLoEsaiyS/\nB1wNXAjcAjwP+AKwo8+51hPPoUsal6uBXwfuraqXApcy+HhnrRGDLmlcflxVP4bBZ6NX1V3AM3qe\naV3xlIukcbkvyXnAvwIHknwX8DOG1pDvcpE0dklezOBrEm+oqof6nme9MOiS1AjPoUtSIwy6JDXC\noEtSIwy6JDXi/wBao+1lj220vwAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x1d7e109d048>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "#plots count of normal and abnormal values where class is ckd\n",
    "\n",
    "cd[cd[\"class\"]==\"ckd\"].rbc.value_counts().plot(kind='bar') \n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 119,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "180.0"
      ]
     },
     "execution_count": 119,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Question 7\n",
    "#finding max of bp where class is ckd\n",
    "\n",
    "max = 0\n",
    "for i in range(len(cd.bp)):\n",
    "    if(max<cd.bp[i]and cd['class'][i]==\"ckd\"):\n",
    "        max = cd.bp[i]\n",
    "max"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 120,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "#Question 8\n",
    "#writing to a csv file\n",
    "cd.to_csv(\"clean_data.csv\",sep = ',', index = False)"
   ]
  },
  {
   "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": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}