Rashid_Ali_KHI_python_assignment_1.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['age', 'bp', 'sg', 'al', 'su', 'rbc', 'pc', 'pcc', 'ba', 'bgr', 'bu', 'sc', 'sod', 'pot', 'hemo', 'pcv', 'wbcc', 'rbcc', 'htn', 'dm', 'cad', 'appet', 'pe', 'ane', 'class']\n",
      "   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]\n",
      "['yes' 'no' ' yes' '\\tno' '\\tyes' '?']\n",
      "['yes' 'no' nan]\n",
      "           pc   al\n",
      "1      normal    1\n",
      "2      normal    4\n",
      "3      normal    2\n",
      "4    abnormal    4\n",
      "5      normal    2\n",
      "6         NaN    3\n",
      "7      normal    0\n",
      "8    abnormal    2\n",
      "9    abnormal    3\n",
      "10   abnormal    2\n",
      "11   abnormal    2\n",
      "12   abnormal    3\n",
      "13     normal    3\n",
      "14        NaN  NaN\n",
      "15   abnormal    3\n",
      "16     normal    3\n",
      "17     normal    2\n",
      "18        NaN  NaN\n",
      "19     normal    0\n",
      "20   abnormal    1\n",
      "21   abnormal    2\n",
      "22        NaN  NaN\n",
      "23   abnormal    4\n",
      "24     normal    0\n",
      "25   abnormal    4\n",
      "26     normal    0\n",
      "27     normal    0\n",
      "28   abnormal    3\n",
      "29        NaN    1\n",
      "30   abnormal    1\n",
      "..        ...  ...\n",
      "371    normal    0\n",
      "372    normal    0\n",
      "373    normal    0\n",
      "374    normal    0\n",
      "375    normal    0\n",
      "376    normal    0\n",
      "377    normal    0\n",
      "378    normal    0\n",
      "379    normal    0\n",
      "380    normal    0\n",
      "381    normal    0\n",
      "382       NaN    0\n",
      "383    normal    0\n",
      "384    normal    0\n",
      "385    normal    0\n",
      "386    normal    0\n",
      "387    normal    0\n",
      "388    normal    0\n",
      "389    normal    0\n",
      "390    normal    0\n",
      "391    normal    0\n",
      "392    normal    0\n",
      "393    normal    0\n",
      "394    normal    0\n",
      "395    normal    0\n",
      "396    normal    0\n",
      "397    normal    0\n",
      "398    normal    0\n",
      "399    normal    0\n",
      "400    normal    0\n",
      "\n",
      "[400 rows x 2 columns]\n",
      "180.0\n"
     ]
    }
   ],
   "source": [
    "# -*- coding: utf-8 -*-\n",
    "\"\"\"\n",
    "Created on Sat Mar 18 21:06:16 2017\n",
    "\n",
    "@author: r.ali\n",
    "\"\"\"\n",
    "\n",
    "import pandas\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "\n",
    " \n",
    "\n",
    "df=pandas.read_csv(\"D:/DIH/Assignment Material/Updated Dataset/Dataset/chronic_kidney_disease_updated.csv\")\n",
    "\n",
    "#print column names\n",
    "print(list(df) )\n",
    "\n",
    "#print first 5 rows\n",
    "print(df.head())\n",
    "\n",
    "df.drop(df.index[[0]], inplace=True)\n",
    "#df.drop('Unnamed: 0', axis=1, inplace=True)\n",
    "\n",
    "print(df.dm.unique() )\n",
    "\n",
    "def replace(tup, df):\n",
    "    for i in tup:\n",
    "        df.replace(to_replace=i, value=np.nan, inplace=True)\n",
    "        \n",
    "def cleandf(df):\n",
    "   df=df.applymap(lambda x: str(x).strip())\n",
    "   return df\n",
    "    \n",
    "df=cleandf(df)\n",
    "    \n",
    "replace(( \"\\t\", \" \", \"?\"), df)\n",
    "\n",
    "print(df.dm.unique() )\n",
    "\n",
    "numeric_columns= ['age', 'bp', 'bgr', 'bu', 'sc', 'sod', 'pot', 'hemo', 'pcv', 'wbcc', 'rbcc']\n",
    "for i in numeric_columns:\n",
    "   df[i] = pandas.to_numeric(df[i], errors='coerce')\n",
    "\n",
    "df.dtypes\n",
    "\n",
    "print(df[['pc','al']])\n",
    "\n",
    "\n",
    "df.rename(columns={'class': 'Class'}, inplace=True)\n",
    "ckd=df[df.Class=='ckd']\n",
    "\n",
    "normal_count=(len(ckd[ckd.rbc=='normal'].index))\n",
    "abnormal_count=(len(ckd[ckd.rbc=='abnormal'].index))\n",
    "\n",
    "ckd['rbc'].value_counts().plot(kind='bar')\n",
    "\n",
    "print(ckd['bp'].max())\n",
    "\n",
    "\n",
    "df.to_csv(path_or_buf=\"D:/DIH/Assignment Material/Updated Dataset/Dataset/chronic_kidney_disease_updated1.csv\")\n"
   ]
  },
  {
   "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
}