Hospital_Bill_estimation.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Bill_Estimation_Using_OneHot_Encoding_And_SkLearn\n",
    "## Process-1. Data_Cleaning\n",
    "## Process-2. Data_Visualisation\n",
    "## Process-2. OneHot_Encoding\n",
    "## Process-3. Building model\n",
    "## Process-4. Training model\n",
    "## Process-4. Testing model\n",
    "## Developed By- Sai Sankalp Reddy TV and Arpit Raj"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "import tensorflow as tf\n",
    "import pandas as pd\n",
    "from tqdm import tqdm"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 176,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Age</th>\n",
       "      <th>Diagnosis</th>\n",
       "      <th>Surgery</th>\n",
       "      <th>LOS</th>\n",
       "      <th>Bill Amt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>32</td>\n",
       "      <td>CAD</td>\n",
       "      <td>CAG</td>\n",
       "      <td>1</td>\n",
       "      <td>17300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>78</td>\n",
       "      <td>Chronic Kidney Disease</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>89500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>61</td>\n",
       "      <td>CAD</td>\n",
       "      <td>PTCA- DRUG ELUT</td>\n",
       "      <td>1</td>\n",
       "      <td>143700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>71</td>\n",
       "      <td>CAD</td>\n",
       "      <td>CAG</td>\n",
       "      <td>3</td>\n",
       "      <td>15000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>74</td>\n",
       "      <td>UTI</td>\n",
       "      <td>Incisional Hernia Repair</td>\n",
       "      <td>1</td>\n",
       "      <td>96000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2603</td>\n",
       "      <td>53</td>\n",
       "      <td>VARICOSE VEIN</td>\n",
       "      <td>Peripheral Angioplasty</td>\n",
       "      <td>1</td>\n",
       "      <td>150600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2604</td>\n",
       "      <td>68</td>\n",
       "      <td>CAD</td>\n",
       "      <td>PTCA- DRUG ELUT</td>\n",
       "      <td>2</td>\n",
       "      <td>157200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2605</td>\n",
       "      <td>57</td>\n",
       "      <td>Fever</td>\n",
       "      <td>Phaco Emulsification with IOL</td>\n",
       "      <td>1</td>\n",
       "      <td>6000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2606</td>\n",
       "      <td>54</td>\n",
       "      <td>Fever For Evaluation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>27900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2607</td>\n",
       "      <td>63</td>\n",
       "      <td>Fever</td>\n",
       "      <td>Cystoscopy DJS</td>\n",
       "      <td>2</td>\n",
       "      <td>126300</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2608 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Age               Diagnosis                        Surgery  LOS  \\\n",
       "0      32                     CAD                            CAG    1   \n",
       "1      78  Chronic Kidney Disease                            NaN    3   \n",
       "2      61                     CAD                PTCA- DRUG ELUT    1   \n",
       "3      71                     CAD                            CAG    3   \n",
       "4      74                     UTI       Incisional Hernia Repair    1   \n",
       "...   ...                     ...                            ...  ...   \n",
       "2603   53           VARICOSE VEIN         Peripheral Angioplasty    1   \n",
       "2604   68                     CAD                PTCA- DRUG ELUT    2   \n",
       "2605   57                   Fever  Phaco Emulsification with IOL    1   \n",
       "2606   54    Fever For Evaluation                            NaN    1   \n",
       "2607   63                   Fever                 Cystoscopy DJS    2   \n",
       "\n",
       "      Bill Amt  \n",
       "0        17300  \n",
       "1        89500  \n",
       "2       143700  \n",
       "3        15000  \n",
       "4        96000  \n",
       "...        ...  \n",
       "2603    150600  \n",
       "2604    157200  \n",
       "2605      6000  \n",
       "2606     27900  \n",
       "2607    126300  \n",
       "\n",
       "[2608 rows x 5 columns]"
      ]
     },
     "execution_count": 176,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_frame = pd.read_csv('./predict_data_vit.csv')\n",
    "data_frame"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 252,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  0%|          | 0/253 [00:00<?, ?it/s]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  0%|          | 1/253 [00:01<06:13,  1.48s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  1%|          | 2/253 [00:02<06:08,  1.47s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  1%|          | 3/253 [00:04<05:57,  1.43s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  2%|▏         | 4/253 [00:05<05:51,  1.41s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  2%|▏         | 5/253 [00:06<05:45,  1.39s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  2%|▏         | 6/253 [00:08<05:43,  1.39s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  3%|▎         | 7/253 [00:09<05:45,  1.40s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  3%|▎         | 8/253 [00:11<05:37,  1.38s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  4%|▎         | 9/253 [00:12<05:39,  1.39s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  4%|▍         | 10/253 [00:13<05:33,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  4%|▍         | 11/253 [00:15<05:31,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  5%|▍         | 12/253 [00:16<05:33,  1.38s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  5%|▌         | 13/253 [00:17<05:27,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  6%|▌         | 14/253 [00:19<05:25,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  6%|▌         | 15/253 [00:20<05:23,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  6%|▋         | 16/253 [00:22<05:30,  1.39s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  7%|▋         | 17/253 [00:23<05:28,  1.39s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  7%|▋         | 18/253 [00:24<05:26,  1.39s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  8%|▊         | 19/253 [00:26<05:19,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  8%|▊         | 20/253 [00:27<05:25,  1.40s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  8%|▊         | 21/253 [00:29<05:19,  1.38s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  9%|▊         | 22/253 [00:30<05:16,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  9%|▉         | 23/253 [00:31<05:12,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  9%|▉         | 24/253 [00:33<05:10,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 10%|▉         | 25/253 [00:34<05:14,  1.38s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 10%|█         | 26/253 [00:35<05:10,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 11%|█         | 27/253 [00:37<05:07,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 11%|█         | 28/253 [00:38<05:04,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 11%|█▏        | 29/253 [00:39<05:04,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 12%|█▏        | 30/253 [00:41<05:10,  1.39s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 12%|█▏        | 31/253 [00:42<05:09,  1.39s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 13%|█▎        | 32/253 [00:44<05:06,  1.39s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 13%|█▎        | 33/253 [00:45<05:08,  1.40s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 13%|█▎        | 34/253 [00:47<05:12,  1.43s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 14%|█▍        | 35/253 [00:48<05:11,  1.43s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 14%|█▍        | 36/253 [00:49<05:06,  1.41s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 15%|█▍        | 37/253 [00:51<05:03,  1.41s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 15%|█▌        | 38/253 [00:52<05:08,  1.43s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 15%|█▌        | 39/253 [00:54<05:03,  1.42s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 16%|█▌        | 40/253 [00:55<04:55,  1.39s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 16%|█▌        | 41/253 [00:56<04:50,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 17%|█▋        | 42/253 [00:58<04:53,  1.39s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 17%|█▋        | 43/253 [00:59<04:59,  1.43s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 17%|█▋        | 44/253 [01:01<04:57,  1.42s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 18%|█▊        | 45/253 [01:02<04:53,  1.41s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 18%|█▊        | 46/253 [01:03<04:48,  1.39s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 19%|█▊        | 47/253 [01:05<04:46,  1.39s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 19%|█▉        | 48/253 [01:06<04:47,  1.40s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 19%|█▉        | 49/253 [01:08<04:41,  1.38s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 20%|█▉        | 50/253 [01:09<04:36,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 20%|██        | 51/253 [01:10<04:40,  1.39s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 21%|██        | 52/253 [01:12<04:44,  1.42s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 21%|██        | 53/253 [01:13<04:37,  1.39s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 21%|██▏       | 54/253 [01:14<04:35,  1.38s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 22%|██▏       | 55/253 [01:16<04:31,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 22%|██▏       | 56/253 [01:17<04:30,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 23%|██▎       | 57/253 [01:19<04:27,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 23%|██▎       | 58/253 [01:20<04:26,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 23%|██▎       | 59/253 [01:21<04:29,  1.39s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 24%|██▎       | 60/253 [01:23<04:24,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 24%|██▍       | 61/253 [01:24<04:21,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 25%|██▍       | 62/253 [01:25<04:17,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 25%|██▍       | 63/253 [01:27<04:17,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 25%|██▌       | 64/253 [01:28<04:18,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 26%|██▌       | 65/253 [01:29<04:16,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 26%|██▌       | 66/253 [01:31<04:18,  1.38s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 26%|██▋       | 67/253 [01:32<04:15,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 27%|██▋       | 68/253 [01:34<04:12,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 27%|██▋       | 69/253 [01:35<04:09,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 28%|██▊       | 70/253 [01:36<04:11,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 28%|██▊       | 71/253 [01:38<04:08,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 28%|██▊       | 72/253 [01:39<04:05,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 29%|██▉       | 73/253 [01:40<04:07,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 29%|██▉       | 74/253 [01:42<04:02,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 30%|██▉       | 75/253 [01:43<03:58,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 30%|███       | 76/253 [01:44<04:01,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 30%|███       | 77/253 [01:46<04:00,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 31%|███       | 78/253 [01:47<04:03,  1.39s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 31%|███       | 79/253 [01:49<04:05,  1.41s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 32%|███▏      | 80/253 [01:50<04:06,  1.42s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 32%|███▏      | 81/253 [01:52<04:01,  1.40s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 32%|███▏      | 82/253 [01:53<03:56,  1.38s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 33%|███▎      | 83/253 [01:54<03:56,  1.39s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 33%|███▎      | 84/253 [01:56<03:52,  1.38s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 34%|███▎      | 85/253 [01:57<03:49,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 34%|███▍      | 86/253 [01:58<03:46,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 34%|███▍      | 87/253 [02:00<03:43,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 35%|███▍      | 88/253 [02:01<03:40,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 35%|███▌      | 89/253 [02:02<03:39,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 36%|███▌      | 90/253 [02:04<03:37,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 36%|███▌      | 91/253 [02:05<03:37,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 36%|███▋      | 92/253 [02:06<03:41,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 37%|███▋      | 93/253 [02:08<03:39,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 37%|███▋      | 94/253 [02:09<03:42,  1.40s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 38%|███▊      | 95/253 [02:11<03:38,  1.38s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 38%|███▊      | 96/253 [02:12<03:34,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 38%|███▊      | 97/253 [02:13<03:31,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 39%|███▊      | 98/253 [02:15<03:30,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 39%|███▉      | 99/253 [02:16<03:27,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 40%|███▉      | 100/253 [02:17<03:25,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 40%|███▉      | 101/253 [02:19<03:25,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 40%|████      | 102/253 [02:20<03:23,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 41%|████      | 103/253 [02:21<03:20,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 41%|████      | 104/253 [02:23<03:19,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 42%|████▏     | 105/253 [02:24<03:19,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 42%|████▏     | 106/253 [02:25<03:16,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 42%|████▏     | 107/253 [02:27<03:15,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 43%|████▎     | 108/253 [02:28<03:13,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 43%|████▎     | 109/253 [02:29<03:14,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 43%|████▎     | 110/253 [02:31<03:11,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 44%|████▍     | 111/253 [02:32<03:10,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 44%|████▍     | 112/253 [02:33<03:08,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 45%|████▍     | 113/253 [02:35<03:06,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 45%|████▌     | 114/253 [02:36<03:05,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 45%|████▌     | 115/253 [02:37<03:03,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 46%|████▌     | 116/253 [02:39<03:02,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 46%|████▌     | 117/253 [02:40<03:06,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 47%|████▋     | 118/253 [02:42<03:06,  1.38s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 47%|████▋     | 119/253 [02:43<03:03,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 47%|████▋     | 120/253 [02:44<03:00,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 48%|████▊     | 121/253 [02:46<02:57,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 48%|████▊     | 122/253 [02:47<02:56,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 49%|████▊     | 123/253 [02:48<02:54,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 49%|████▉     | 124/253 [02:50<02:52,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 49%|████▉     | 125/253 [02:51<02:54,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 50%|████▉     | 126/253 [02:52<02:51,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 50%|█████     | 127/253 [02:54<02:48,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 51%|█████     | 128/253 [02:55<02:47,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 51%|█████     | 129/253 [02:56<02:47,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 51%|█████▏    | 130/253 [02:58<02:46,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 52%|█████▏    | 131/253 [02:59<02:44,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 52%|█████▏    | 132/253 [03:00<02:47,  1.38s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 53%|█████▎    | 133/253 [03:02<02:46,  1.38s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 53%|█████▎    | 134/253 [03:03<02:45,  1.39s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 53%|█████▎    | 135/253 [03:05<02:42,  1.38s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 54%|█████▍    | 136/253 [03:06<02:39,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 54%|█████▍    | 137/253 [03:07<02:36,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 55%|█████▍    | 138/253 [03:09<02:36,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 55%|█████▍    | 139/253 [03:10<02:34,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 55%|█████▌    | 140/253 [03:11<02:32,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 56%|█████▌    | 141/253 [03:13<02:32,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 56%|█████▌    | 142/253 [03:14<02:30,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 57%|█████▋    | 143/253 [03:15<02:31,  1.38s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 57%|█████▋    | 144/253 [03:17<02:29,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 57%|█████▋    | 145/253 [03:18<02:26,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 58%|█████▊    | 146/253 [03:20<02:25,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 58%|█████▊    | 147/253 [03:21<02:24,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 58%|█████▊    | 148/253 [03:22<02:22,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 59%|█████▉    | 149/253 [03:24<02:19,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 59%|█████▉    | 150/253 [03:25<02:18,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 60%|█████▉    | 151/253 [03:26<02:16,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 60%|██████    | 152/253 [03:28<02:15,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 60%|██████    | 153/253 [03:29<02:15,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 61%|██████    | 154/253 [03:30<02:13,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 61%|██████▏   | 155/253 [03:32<02:12,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 62%|██████▏   | 156/253 [03:33<02:10,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 62%|██████▏   | 157/253 [03:34<02:09,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 62%|██████▏   | 158/253 [03:36<02:07,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 63%|██████▎   | 159/253 [03:37<02:05,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 63%|██████▎   | 160/253 [03:38<02:04,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 64%|██████▎   | 161/253 [03:40<02:02,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 64%|██████▍   | 162/253 [03:41<02:00,  1.32s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 64%|██████▍   | 163/253 [03:42<01:59,  1.32s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 65%|██████▍   | 164/253 [03:44<01:59,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 65%|██████▌   | 165/253 [03:45<01:58,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 66%|██████▌   | 166/253 [03:46<01:56,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 66%|██████▌   | 167/253 [03:48<01:55,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 66%|██████▋   | 168/253 [03:49<01:54,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 67%|██████▋   | 169/253 [03:50<01:54,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 67%|██████▋   | 170/253 [03:52<01:51,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 68%|██████▊   | 171/253 [03:53<01:52,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 68%|██████▊   | 172/253 [03:54<01:50,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 68%|██████▊   | 173/253 [03:56<01:51,  1.39s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 69%|██████▉   | 174/253 [03:57<01:51,  1.41s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 69%|██████▉   | 175/253 [03:59<01:54,  1.46s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 70%|██████▉   | 176/253 [04:00<01:50,  1.44s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 70%|██████▉   | 177/253 [04:02<01:49,  1.45s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 70%|███████   | 178/253 [04:03<01:48,  1.44s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 71%|███████   | 179/253 [04:05<01:44,  1.41s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 71%|███████   | 180/253 [04:06<01:41,  1.39s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 72%|███████▏  | 181/253 [04:07<01:40,  1.40s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 72%|███████▏  | 182/253 [04:09<01:37,  1.38s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 72%|███████▏  | 183/253 [04:10<01:35,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 73%|███████▎  | 184/253 [04:11<01:33,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 73%|███████▎  | 185/253 [04:13<01:31,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 74%|███████▎  | 186/253 [04:14<01:29,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 74%|███████▍  | 187/253 [04:15<01:28,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 74%|███████▍  | 188/253 [04:17<01:26,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 75%|███████▍  | 189/253 [04:18<01:25,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 75%|███████▌  | 190/253 [04:19<01:24,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 75%|███████▌  | 191/253 [04:21<01:23,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 76%|███████▌  | 192/253 [04:22<01:21,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 76%|███████▋  | 193/253 [04:23<01:19,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 77%|███████▋  | 194/253 [04:25<01:19,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 77%|███████▋  | 195/253 [04:26<01:17,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 77%|███████▋  | 196/253 [04:27<01:18,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 78%|███████▊  | 197/253 [04:29<01:15,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 78%|███████▊  | 198/253 [04:30<01:14,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 79%|███████▊  | 199/253 [04:32<01:13,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 79%|███████▉  | 200/253 [04:33<01:11,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 79%|███████▉  | 201/253 [04:34<01:10,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 80%|███████▉  | 202/253 [04:36<01:08,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 80%|████████  | 203/253 [04:37<01:07,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 81%|████████  | 204/253 [04:38<01:05,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 81%|████████  | 205/253 [04:40<01:04,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 81%|████████▏ | 206/253 [04:41<01:02,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 82%|████████▏ | 207/253 [04:42<01:01,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 82%|████████▏ | 208/253 [04:44<01:00,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 83%|████████▎ | 209/253 [04:45<00:58,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 83%|████████▎ | 210/253 [04:46<00:57,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 83%|████████▎ | 211/253 [04:48<00:56,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 84%|████████▍ | 212/253 [04:49<00:55,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 84%|████████▍ | 213/253 [04:50<00:54,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 85%|████████▍ | 214/253 [04:52<00:52,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 85%|████████▍ | 215/253 [04:53<00:52,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 85%|████████▌ | 216/253 [04:55<00:52,  1.41s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 86%|████████▌ | 217/253 [04:56<00:50,  1.41s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 86%|████████▌ | 218/253 [04:57<00:48,  1.39s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 87%|████████▋ | 219/253 [04:59<00:47,  1.39s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 87%|████████▋ | 220/253 [05:00<00:45,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 87%|████████▋ | 221/253 [05:01<00:44,  1.38s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 88%|████████▊ | 222/253 [05:03<00:42,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 88%|████████▊ | 223/253 [05:04<00:41,  1.38s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 89%|████████▊ | 224/253 [05:05<00:39,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 89%|████████▉ | 225/253 [05:07<00:38,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 89%|████████▉ | 226/253 [05:08<00:36,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 90%|████████▉ | 227/253 [05:10<00:35,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 90%|█████████ | 228/253 [05:11<00:33,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 91%|█████████ | 229/253 [05:12<00:32,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 91%|█████████ | 230/253 [05:14<00:31,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 91%|█████████▏| 231/253 [05:15<00:29,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 92%|█████████▏| 232/253 [05:16<00:29,  1.39s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 92%|█████████▏| 233/253 [05:18<00:28,  1.40s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 92%|█████████▏| 234/253 [05:19<00:26,  1.41s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 93%|█████████▎| 235/253 [05:21<00:25,  1.42s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 93%|█████████▎| 236/253 [05:22<00:24,  1.41s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 94%|█████████▎| 237/253 [05:24<00:22,  1.43s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 94%|█████████▍| 238/253 [05:25<00:21,  1.40s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 94%|█████████▍| 239/253 [05:26<00:19,  1.38s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 95%|█████████▍| 240/253 [05:28<00:18,  1.40s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 95%|█████████▌| 241/253 [05:29<00:17,  1.42s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 96%|█████████▌| 242/253 [05:31<00:15,  1.42s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 96%|█████████▌| 243/253 [05:32<00:14,  1.41s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 96%|█████████▋| 244/253 [05:33<00:12,  1.39s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 97%|█████████▋| 245/253 [05:35<00:10,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 97%|█████████▋| 246/253 [05:36<00:09,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 98%|█████████▊| 247/253 [05:37<00:08,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 98%|█████████▊| 248/253 [05:39<00:06,  1.39s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 98%|█████████▊| 249/253 [05:40<00:05,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 99%|█████████▉| 250/253 [05:41<00:04,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 99%|█████████▉| 251/253 [05:43<00:02,  1.39s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "100%|█████████▉| 252/253 [05:44<00:01,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "100%|██████████| 253/253 [05:46<00:00,  1.37s/it]\n"
     ]
    }
   ],
   "source": [
    "# data_frame.insert(3,\"abc\",1)\n",
    "# data_frame\n",
    "data_frame = pd.read_csv('./predict_data_vit.csv')\n",
    "data_frame\n",
    "\n",
    "\n",
    "Surgery = list(raw_data['Surgery'])\n",
    "for i in range(len(Surgery)):\n",
    "    Surgery[i] = str(Surgery[i]).split(\",\")\n",
    "Surgery_list_of_lists = Surgery\n",
    "\n",
    "Surgery_unique = []\n",
    "for i in range(len(Surgery)):\n",
    "    Surgery_unique += Surgery[i]\n",
    "Surgery_unique=list(set(Surgery_unique))\n",
    "    \n",
    "for i in tqdm(range(len(Surgery_unique))):\n",
    "    su = Surgery_unique[i]\n",
    "    heading = su\n",
    "    value = pd.Series([])\n",
    "    for j in range(len(Surgery_list_of_lists)):\n",
    "        sl = Surgery_list_of_lists[j]\n",
    "        value[j] = sl.count(su)\n",
    "#     print(heading)\n",
    "#     print(value)\n",
    "    data_frame.insert(3+i,heading,value)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 253,
   "metadata": {},
   "outputs": [],
   "source": [
    "data_frame\n",
    "data_frame.to_csv('data_frame.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 280,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>Age</th>\n",
       "      <th>Diagnosis</th>\n",
       "      <th>Surgery</th>\n",
       "      <th>Bipolar Hemiarthroplasty</th>\n",
       "      <th>Chemoport Removal</th>\n",
       "      <th>Hypospadias</th>\n",
       "      <th>Gastro jejunostomy</th>\n",
       "      <th>ORIF WITHMEDIAL MALLELOUS FIXATIONWITH FIBULA</th>\n",
       "      <th>Check URS</th>\n",
       "      <th>...</th>\n",
       "      <th>Lumbar Drain</th>\n",
       "      <th>Reconstruction of Acetabular Posterior Wall</th>\n",
       "      <th>Llap Pyeloplasty</th>\n",
       "      <th>Burr hole</th>\n",
       "      <th>FLAP DIVISION &amp; INSET</th>\n",
       "      <th>Nephrorectomy</th>\n",
       "      <th>Bladder Neck Incision</th>\n",
       "      <th>Chemoport Insertion</th>\n",
       "      <th>LOS</th>\n",
       "      <th>Bill Amt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>32</td>\n",
       "      <td>CAD</td>\n",
       "      <td>CAG</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>17300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>78</td>\n",
       "      <td>Chronic Kidney Disease</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>89500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>61</td>\n",
       "      <td>CAD</td>\n",
       "      <td>PTCA- DRUG ELUT</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>143700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>71</td>\n",
       "      <td>CAD</td>\n",
       "      <td>CAG</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>15000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>74</td>\n",
       "      <td>UTI</td>\n",
       "      <td>Incisional Hernia Repair</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>96000</td>\n",
       "    </tr>\n",
       "    <tr>\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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2603</td>\n",
       "      <td>2603</td>\n",
       "      <td>53</td>\n",
       "      <td>VARICOSE VEIN</td>\n",
       "      <td>Peripheral Angioplasty</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>150600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2604</td>\n",
       "      <td>2604</td>\n",
       "      <td>68</td>\n",
       "      <td>CAD</td>\n",
       "      <td>PTCA- DRUG ELUT</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>157200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2605</td>\n",
       "      <td>2605</td>\n",
       "      <td>57</td>\n",
       "      <td>Fever</td>\n",
       "      <td>Phaco Emulsification with IOL</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>6000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2606</td>\n",
       "      <td>2606</td>\n",
       "      <td>54</td>\n",
       "      <td>Fever For Evaluation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>27900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2607</td>\n",
       "      <td>2607</td>\n",
       "      <td>63</td>\n",
       "      <td>Fever</td>\n",
       "      <td>Cystoscopy DJS</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>126300</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2608 rows × 259 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Unnamed: 0  Age               Diagnosis                        Surgery  \\\n",
       "0              0   32                     CAD                            CAG   \n",
       "1              1   78  Chronic Kidney Disease                            NaN   \n",
       "2              2   61                     CAD                PTCA- DRUG ELUT   \n",
       "3              3   71                     CAD                            CAG   \n",
       "4              4   74                     UTI       Incisional Hernia Repair   \n",
       "...          ...  ...                     ...                            ...   \n",
       "2603        2603   53           VARICOSE VEIN         Peripheral Angioplasty   \n",
       "2604        2604   68                     CAD                PTCA- DRUG ELUT   \n",
       "2605        2605   57                   Fever  Phaco Emulsification with IOL   \n",
       "2606        2606   54    Fever For Evaluation                            NaN   \n",
       "2607        2607   63                   Fever                 Cystoscopy DJS   \n",
       "\n",
       "      Bipolar Hemiarthroplasty  Chemoport Removal  Hypospadias  \\\n",
       "0                            0                  0            0   \n",
       "1                            0                  0            0   \n",
       "2                            0                  0            0   \n",
       "3                            0                  0            0   \n",
       "4                            0                  0            0   \n",
       "...                        ...                ...          ...   \n",
       "2603                         0                  0            0   \n",
       "2604                         0                  0            0   \n",
       "2605                         0                  0            0   \n",
       "2606                         0                  0            0   \n",
       "2607                         0                  0            0   \n",
       "\n",
       "      Gastro jejunostomy  ORIF WITHMEDIAL MALLELOUS FIXATIONWITH FIBULA  \\\n",
       "0                      0                                              0   \n",
       "1                      0                                              0   \n",
       "2                      0                                              0   \n",
       "3                      0                                              0   \n",
       "4                      0                                              0   \n",
       "...                  ...                                            ...   \n",
       "2603                   0                                              0   \n",
       "2604                   0                                              0   \n",
       "2605                   0                                              0   \n",
       "2606                   0                                              0   \n",
       "2607                   0                                              0   \n",
       "\n",
       "      Check URS  ...  Lumbar Drain  \\\n",
       "0             0  ...             0   \n",
       "1             0  ...             0   \n",
       "2             0  ...             0   \n",
       "3             0  ...             0   \n",
       "4             0  ...             0   \n",
       "...         ...  ...           ...   \n",
       "2603          0  ...             0   \n",
       "2604          0  ...             0   \n",
       "2605          0  ...             0   \n",
       "2606          0  ...             0   \n",
       "2607          0  ...             0   \n",
       "\n",
       "      Reconstruction of Acetabular Posterior Wall  Llap Pyeloplasty  \\\n",
       "0                                               0                 0   \n",
       "1                                               0                 0   \n",
       "2                                               0                 0   \n",
       "3                                               0                 0   \n",
       "4                                               0                 0   \n",
       "...                                           ...               ...   \n",
       "2603                                            0                 0   \n",
       "2604                                            0                 0   \n",
       "2605                                            0                 0   \n",
       "2606                                            0                 0   \n",
       "2607                                            0                 0   \n",
       "\n",
       "      Burr hole  FLAP DIVISION & INSET  Nephrorectomy  Bladder Neck Incision  \\\n",
       "0             0                      0              0                      0   \n",
       "1             0                      0              0                      0   \n",
       "2             0                      0              0                      0   \n",
       "3             0                      0              0                      0   \n",
       "4             0                      0              0                      0   \n",
       "...         ...                    ...            ...                    ...   \n",
       "2603          0                      0              0                      0   \n",
       "2604          0                      0              0                      0   \n",
       "2605          0                      0              0                      0   \n",
       "2606          0                      0              0                      0   \n",
       "2607          0                      0              0                      0   \n",
       "\n",
       "      Chemoport Insertion  LOS  Bill Amt  \n",
       "0                       0    1     17300  \n",
       "1                       0    3     89500  \n",
       "2                       0    1    143700  \n",
       "3                       0    3     15000  \n",
       "4                       0    1     96000  \n",
       "...                   ...  ...       ...  \n",
       "2603                    0    1    150600  \n",
       "2604                    0    2    157200  \n",
       "2605                    0    1      6000  \n",
       "2606                    0    1     27900  \n",
       "2607                    0    2    126300  \n",
       "\n",
       "[2608 rows x 259 columns]"
      ]
     },
     "execution_count": 280,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_frame1 = pd.read_csv('./data_frame.csv')\n",
    "data_frame1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 281,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  0%|          | 0/246 [00:00<?, ?it/s]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  0%|          | 1/246 [00:01<05:29,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  1%|          | 2/246 [00:02<05:26,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  1%|          | 3/246 [00:03<05:23,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  2%|▏         | 4/246 [00:05<05:21,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  2%|▏         | 5/246 [00:06<05:21,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  2%|▏         | 6/246 [00:07<05:18,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  3%|▎         | 7/246 [00:09<05:17,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  3%|▎         | 8/246 [00:10<05:15,  1.32s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  4%|▎         | 9/246 [00:11<05:13,  1.32s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  4%|▍         | 10/246 [00:13<05:10,  1.32s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  4%|▍         | 11/246 [00:14<05:09,  1.32s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  5%|▍         | 12/246 [00:15<05:08,  1.32s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  5%|▌         | 13/246 [00:17<05:14,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  6%|▌         | 14/246 [00:18<05:11,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  6%|▌         | 15/246 [00:19<05:08,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  7%|▋         | 16/246 [00:21<05:06,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  7%|▋         | 17/246 [00:22<05:08,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  7%|▋         | 18/246 [00:23<05:05,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  8%|▊         | 19/246 [00:25<05:10,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  8%|▊         | 20/246 [00:27<05:27,  1.45s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  9%|▊         | 21/246 [00:28<05:22,  1.43s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  9%|▉         | 22/246 [00:29<05:17,  1.42s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "  9%|▉         | 23/246 [00:31<05:11,  1.40s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 10%|▉         | 24/246 [00:32<05:06,  1.38s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 10%|█         | 25/246 [00:33<05:03,  1.38s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 11%|█         | 26/246 [00:35<05:01,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 11%|█         | 27/246 [00:36<05:03,  1.38s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 11%|█▏        | 28/246 [00:38<05:02,  1.39s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 12%|█▏        | 29/246 [00:39<04:59,  1.38s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 12%|█▏        | 30/246 [00:40<04:53,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 13%|█▎        | 31/246 [00:42<04:49,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 13%|█▎        | 32/246 [00:43<04:46,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 13%|█▎        | 33/246 [00:44<04:44,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 14%|█▍        | 34/246 [00:46<04:48,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 14%|█▍        | 35/246 [00:47<04:44,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 15%|█▍        | 36/246 [00:48<04:49,  1.38s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 15%|█▌        | 37/246 [00:50<04:45,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 15%|█▌        | 38/246 [00:51<04:41,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 16%|█▌        | 39/246 [00:52<04:36,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 16%|█▋        | 40/246 [00:54<04:39,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 17%|█▋        | 41/246 [00:55<04:41,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 17%|█▋        | 42/246 [00:56<04:36,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 17%|█▋        | 43/246 [00:58<04:36,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 18%|█▊        | 44/246 [00:59<04:33,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 18%|█▊        | 45/246 [01:01<04:31,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 19%|█▊        | 46/246 [01:02<04:28,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 19%|█▉        | 47/246 [01:03<04:26,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 20%|█▉        | 48/246 [01:05<04:25,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 20%|█▉        | 49/246 [01:06<04:24,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 20%|██        | 50/246 [01:07<04:21,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 21%|██        | 51/246 [01:09<04:20,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 21%|██        | 52/246 [01:10<04:18,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 22%|██▏       | 53/246 [01:11<04:17,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 22%|██▏       | 54/246 [01:12<04:14,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 22%|██▏       | 55/246 [01:14<04:12,  1.32s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 23%|██▎       | 56/246 [01:15<04:11,  1.32s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 23%|██▎       | 57/246 [01:17<04:14,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 24%|██▎       | 58/246 [01:18<04:11,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 24%|██▍       | 59/246 [01:19<04:08,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 24%|██▍       | 60/246 [01:21<04:14,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 25%|██▍       | 61/246 [01:22<04:10,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 25%|██▌       | 62/246 [01:23<04:05,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 26%|██▌       | 63/246 [01:25<04:07,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 26%|██▌       | 64/246 [01:26<04:08,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 26%|██▋       | 65/246 [01:27<04:04,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 27%|██▋       | 66/246 [01:29<04:01,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 27%|██▋       | 67/246 [01:30<04:00,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 28%|██▊       | 68/246 [01:31<04:00,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 28%|██▊       | 69/246 [01:33<03:57,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 28%|██▊       | 70/246 [01:34<04:03,  1.38s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 29%|██▉       | 71/246 [01:35<03:59,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 29%|██▉       | 72/246 [01:37<03:58,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 30%|██▉       | 73/246 [01:38<03:59,  1.39s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 30%|███       | 74/246 [01:40<03:56,  1.38s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 30%|███       | 75/246 [01:41<03:52,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 31%|███       | 76/246 [01:42<03:50,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 31%|███▏      | 77/246 [01:44<03:47,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 32%|███▏      | 78/246 [01:45<03:44,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 32%|███▏      | 79/246 [01:46<03:43,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 33%|███▎      | 80/246 [01:48<03:41,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 33%|███▎      | 81/246 [01:49<03:46,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 33%|███▎      | 82/246 [01:51<03:48,  1.39s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 34%|███▎      | 83/246 [01:52<03:42,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 34%|███▍      | 84/246 [01:53<03:40,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 35%|███▍      | 85/246 [01:54<03:36,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 35%|███▍      | 86/246 [01:56<03:36,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 35%|███▌      | 87/246 [01:57<03:33,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 36%|███▌      | 88/246 [01:59<03:34,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 36%|███▌      | 89/246 [02:00<03:31,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 37%|███▋      | 90/246 [02:01<03:34,  1.38s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 37%|███▋      | 91/246 [02:03<03:30,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 37%|███▋      | 92/246 [02:04<03:31,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 38%|███▊      | 93/246 [02:05<03:27,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 38%|███▊      | 94/246 [02:07<03:23,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 39%|███▊      | 95/246 [02:08<03:22,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 39%|███▉      | 96/246 [02:09<03:21,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 39%|███▉      | 97/246 [02:11<03:18,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 40%|███▉      | 98/246 [02:12<03:18,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 40%|████      | 99/246 [02:13<03:16,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 41%|████      | 100/246 [02:15<03:17,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 41%|████      | 101/246 [02:16<03:17,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 41%|████▏     | 102/246 [02:17<03:16,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 42%|████▏     | 103/246 [02:19<03:13,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 42%|████▏     | 104/246 [02:20<03:11,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 43%|████▎     | 105/246 [02:21<03:09,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 43%|████▎     | 106/246 [02:23<03:07,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 43%|████▎     | 107/246 [02:24<03:06,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 44%|████▍     | 108/246 [02:26<03:05,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 44%|████▍     | 109/246 [02:27<03:07,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 45%|████▍     | 110/246 [02:28<03:07,  1.38s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 45%|████▌     | 111/246 [02:30<03:04,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 46%|████▌     | 112/246 [02:31<03:01,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 46%|████▌     | 113/246 [02:32<03:02,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 46%|████▋     | 114/246 [02:34<02:58,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 47%|████▋     | 115/246 [02:35<02:56,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 47%|████▋     | 116/246 [02:36<02:58,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 48%|████▊     | 117/246 [02:38<02:55,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 48%|████▊     | 118/246 [02:39<02:53,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 48%|████▊     | 119/246 [02:41<02:51,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 49%|████▉     | 120/246 [02:42<02:50,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 49%|████▉     | 121/246 [02:43<02:47,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 50%|████▉     | 122/246 [02:44<02:45,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 50%|█████     | 123/246 [02:46<02:45,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 50%|█████     | 124/246 [02:47<02:43,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 51%|█████     | 125/246 [02:49<02:41,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 51%|█████     | 126/246 [02:50<02:42,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 52%|█████▏    | 127/246 [02:51<02:39,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 52%|█████▏    | 128/246 [02:53<02:41,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 52%|█████▏    | 129/246 [02:54<02:38,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 53%|█████▎    | 130/246 [02:55<02:35,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 53%|█████▎    | 131/246 [02:57<02:34,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 54%|█████▎    | 132/246 [02:58<02:31,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 54%|█████▍    | 133/246 [02:59<02:30,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 54%|█████▍    | 134/246 [03:01<02:28,  1.32s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 55%|█████▍    | 135/246 [03:02<02:26,  1.32s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 55%|█████▌    | 136/246 [03:03<02:25,  1.32s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 56%|█████▌    | 137/246 [03:05<02:23,  1.32s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 56%|█████▌    | 138/246 [03:06<02:24,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 57%|█████▋    | 139/246 [03:07<02:27,  1.38s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 57%|█████▋    | 140/246 [03:09<02:26,  1.38s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 57%|█████▋    | 141/246 [03:10<02:30,  1.44s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 58%|█████▊    | 142/246 [03:12<02:27,  1.42s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 58%|█████▊    | 143/246 [03:13<02:24,  1.40s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 59%|█████▊    | 144/246 [03:14<02:21,  1.39s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 59%|█████▉    | 145/246 [03:16<02:20,  1.39s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 59%|█████▉    | 146/246 [03:17<02:17,  1.38s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 60%|█████▉    | 147/246 [03:19<02:15,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 60%|██████    | 148/246 [03:20<02:13,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 61%|██████    | 149/246 [03:21<02:10,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 61%|██████    | 150/246 [03:22<02:08,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 61%|██████▏   | 151/246 [03:24<02:06,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 62%|██████▏   | 152/246 [03:25<02:04,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 62%|██████▏   | 153/246 [03:26<02:03,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 63%|██████▎   | 154/246 [03:28<02:02,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 63%|██████▎   | 155/246 [03:29<02:02,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 63%|██████▎   | 156/246 [03:31<02:00,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 64%|██████▍   | 157/246 [03:32<01:58,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 64%|██████▍   | 158/246 [03:33<01:58,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 65%|██████▍   | 159/246 [03:35<01:56,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 65%|██████▌   | 160/246 [03:36<01:54,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 65%|██████▌   | 161/246 [03:37<01:53,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 66%|██████▌   | 162/246 [03:39<01:52,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 66%|██████▋   | 163/246 [03:40<01:50,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 67%|██████▋   | 164/246 [03:41<01:48,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 67%|██████▋   | 165/246 [03:42<01:47,  1.32s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 67%|██████▋   | 166/246 [03:44<01:45,  1.32s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 68%|██████▊   | 167/246 [03:45<01:44,  1.32s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 68%|██████▊   | 168/246 [03:47<01:46,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 69%|██████▊   | 169/246 [03:48<01:45,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 69%|██████▉   | 170/246 [03:49<01:44,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 70%|██████▉   | 171/246 [03:51<01:41,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 70%|██████▉   | 172/246 [03:52<01:39,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 70%|███████   | 173/246 [03:53<01:38,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 71%|███████   | 174/246 [03:55<01:36,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 71%|███████   | 175/246 [03:56<01:34,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 72%|███████▏  | 176/246 [03:57<01:33,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 72%|███████▏  | 177/246 [03:59<01:32,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 72%|███████▏  | 178/246 [04:00<01:31,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 73%|███████▎  | 179/246 [04:01<01:31,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 73%|███████▎  | 180/246 [04:03<01:29,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 74%|███████▎  | 181/246 [04:04<01:27,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 74%|███████▍  | 182/246 [04:05<01:25,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 74%|███████▍  | 183/246 [04:07<01:23,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 75%|███████▍  | 184/246 [04:08<01:21,  1.32s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 75%|███████▌  | 185/246 [04:09<01:20,  1.32s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 76%|███████▌  | 186/246 [04:11<01:19,  1.32s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 76%|███████▌  | 187/246 [04:12<01:17,  1.32s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 76%|███████▋  | 188/246 [04:13<01:16,  1.32s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 77%|███████▋  | 189/246 [04:15<01:14,  1.32s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 77%|███████▋  | 190/246 [04:16<01:13,  1.32s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 78%|███████▊  | 191/246 [04:17<01:13,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 78%|███████▊  | 192/246 [04:19<01:11,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 78%|███████▊  | 193/246 [04:20<01:10,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 79%|███████▉  | 194/246 [04:21<01:08,  1.32s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 79%|███████▉  | 195/246 [04:23<01:07,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 80%|███████▉  | 196/246 [04:24<01:07,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 80%|████████  | 197/246 [04:25<01:05,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 80%|████████  | 198/246 [04:27<01:03,  1.33s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 81%|████████  | 199/246 [04:28<01:02,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 81%|████████▏ | 200/246 [04:29<01:02,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 82%|████████▏ | 201/246 [04:31<01:00,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 82%|████████▏ | 202/246 [04:32<00:59,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 83%|████████▎ | 203/246 [04:33<00:58,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 83%|████████▎ | 204/246 [04:35<00:58,  1.38s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 83%|████████▎ | 205/246 [04:36<00:56,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 84%|████████▎ | 206/246 [04:37<00:54,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 84%|████████▍ | 207/246 [04:39<00:53,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 85%|████████▍ | 208/246 [04:40<00:52,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 85%|████████▍ | 209/246 [04:42<00:50,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 85%|████████▌ | 210/246 [04:43<00:48,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 86%|████████▌ | 211/246 [04:44<00:46,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 86%|████████▌ | 212/246 [04:46<00:46,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 87%|████████▋ | 213/246 [04:47<00:44,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 87%|████████▋ | 214/246 [04:48<00:43,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 87%|████████▋ | 215/246 [04:50<00:41,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 88%|████████▊ | 216/246 [04:51<00:41,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 88%|████████▊ | 217/246 [04:52<00:39,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 89%|████████▊ | 218/246 [04:54<00:38,  1.39s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 89%|████████▉ | 219/246 [04:55<00:38,  1.41s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 89%|████████▉ | 220/246 [04:57<00:36,  1.42s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 90%|████████▉ | 221/246 [04:58<00:35,  1.44s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 90%|█████████ | 222/246 [05:00<00:34,  1.45s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 91%|█████████ | 223/246 [05:01<00:33,  1.45s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 91%|█████████ | 224/246 [05:03<00:31,  1.41s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 91%|█████████▏| 225/246 [05:04<00:29,  1.41s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 92%|█████████▏| 226/246 [05:06<00:29,  1.46s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 92%|█████████▏| 227/246 [05:07<00:27,  1.46s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 93%|█████████▎| 228/246 [05:08<00:26,  1.45s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 93%|█████████▎| 229/246 [05:10<00:24,  1.42s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 93%|█████████▎| 230/246 [05:11<00:22,  1.41s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 94%|█████████▍| 231/246 [05:13<00:21,  1.41s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 94%|█████████▍| 232/246 [05:14<00:19,  1.41s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 95%|█████████▍| 233/246 [05:15<00:18,  1.40s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 95%|█████████▌| 234/246 [05:17<00:16,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 96%|█████████▌| 235/246 [05:18<00:14,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 96%|█████████▌| 236/246 [05:19<00:13,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 96%|█████████▋| 237/246 [05:21<00:12,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 97%|█████████▋| 238/246 [05:22<00:10,  1.34s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 97%|█████████▋| 239/246 [05:23<00:09,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 98%|█████████▊| 240/246 [05:25<00:08,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 98%|█████████▊| 241/246 [05:26<00:06,  1.38s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 98%|█████████▊| 242/246 [05:28<00:05,  1.37s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 99%|█████████▉| 243/246 [05:29<00:04,  1.36s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      " 99%|█████████▉| 244/246 [05:30<00:02,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "100%|█████████▉| 245/246 [05:32<00:01,  1.35s/it]\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "\n",
      "100%|██████████| 246/246 [05:33<00:00,  1.36s/it]\n"
     ]
    }
   ],
   "source": [
    "Diagnosis = list(data_frame1['Diagnosis'])\n",
    "\n",
    "Diagnosis_unique=list(set(Diagnosis))\n",
    "\n",
    "Diagnosis_unique[14] = \"implant removal\"\n",
    "Diagnosis_unique[24] = 'ppi'\n",
    "Diagnosis_unique[130]= 'av Fistula'\n",
    "Diagnosis_unique[131]= 'cabg'\n",
    "Diagnosis_unique[140]= 'tracheostomy'\n",
    "Diagnosis_unique[144]= 'circumcision'\n",
    "Diagnosis_unique[172]= 'laparotomy'\n",
    "Diagnosis_unique[177]= 'lSCS'\n",
    "Diagnosis_unique[207]= 'thyroidectomy'\n",
    "Diagnosis_unique[212]= 'total Knee Replacement'\n",
    "    \n",
    "for i in tqdm(range(len(Diagnosis_unique))):\n",
    "    heading = Diagnosis_unique[i]\n",
    "    value = pd.Series([])\n",
    "    for j in range(len(Diagnosis)):\n",
    "        sl = Diagnosis[j]\n",
    "        value[j] = int(sl==heading)\n",
    "#     print(heading)\n",
    "#     print(value)\n",
    "    data_frame1.insert(3+i,heading,value)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 283,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>Age</th>\n",
       "      <th>Diagnosis</th>\n",
       "      <th>Heamaturia</th>\n",
       "      <th>MAXILLARY FRACTURE</th>\n",
       "      <th>FRACTURE FEMUR</th>\n",
       "      <th>IHD,ACS,CAD</th>\n",
       "      <th>Urinary incontinence</th>\n",
       "      <th>Antenatal Case</th>\n",
       "      <th>Complete Heart Block</th>\n",
       "      <th>...</th>\n",
       "      <th>Lumbar Drain</th>\n",
       "      <th>Reconstruction of Acetabular Posterior Wall</th>\n",
       "      <th>Llap Pyeloplasty</th>\n",
       "      <th>Burr hole</th>\n",
       "      <th>FLAP DIVISION &amp; INSET</th>\n",
       "      <th>Nephrorectomy</th>\n",
       "      <th>Bladder Neck Incision</th>\n",
       "      <th>Chemoport Insertion</th>\n",
       "      <th>LOS</th>\n",
       "      <th>Bill Amt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>32</td>\n",
       "      <td>CAD</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>17300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>78</td>\n",
       "      <td>Chronic Kidney Disease</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>89500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>61</td>\n",
       "      <td>CAD</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>143700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>71</td>\n",
       "      <td>CAD</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>15000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>74</td>\n",
       "      <td>UTI</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>96000</td>\n",
       "    </tr>\n",
       "    <tr>\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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2603</td>\n",
       "      <td>2603</td>\n",
       "      <td>53</td>\n",
       "      <td>VARICOSE VEIN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>150600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2604</td>\n",
       "      <td>2604</td>\n",
       "      <td>68</td>\n",
       "      <td>CAD</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>157200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2605</td>\n",
       "      <td>2605</td>\n",
       "      <td>57</td>\n",
       "      <td>Fever</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>6000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2606</td>\n",
       "      <td>2606</td>\n",
       "      <td>54</td>\n",
       "      <td>Fever For Evaluation</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>27900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2607</td>\n",
       "      <td>2607</td>\n",
       "      <td>63</td>\n",
       "      <td>Fever</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>126300</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2608 rows × 505 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Unnamed: 0  Age               Diagnosis  Heamaturia  MAXILLARY FRACTURE  \\\n",
       "0              0   32                     CAD           0                   0   \n",
       "1              1   78  Chronic Kidney Disease           0                   0   \n",
       "2              2   61                     CAD           0                   0   \n",
       "3              3   71                     CAD           0                   0   \n",
       "4              4   74                     UTI           0                   0   \n",
       "...          ...  ...                     ...         ...                 ...   \n",
       "2603        2603   53           VARICOSE VEIN           0                   0   \n",
       "2604        2604   68                     CAD           0                   0   \n",
       "2605        2605   57                   Fever           0                   0   \n",
       "2606        2606   54    Fever For Evaluation           0                   0   \n",
       "2607        2607   63                   Fever           0                   0   \n",
       "\n",
       "      FRACTURE FEMUR  IHD,ACS,CAD  Urinary incontinence  Antenatal Case  \\\n",
       "0                  0            0                     0               0   \n",
       "1                  0            0                     0               0   \n",
       "2                  0            0                     0               0   \n",
       "3                  0            0                     0               0   \n",
       "4                  0            0                     0               0   \n",
       "...              ...          ...                   ...             ...   \n",
       "2603               0            0                     0               0   \n",
       "2604               0            0                     0               0   \n",
       "2605               0            0                     0               0   \n",
       "2606               0            0                     0               0   \n",
       "2607               0            0                     0               0   \n",
       "\n",
       "      Complete Heart Block  ...  Lumbar Drain  \\\n",
       "0                        0  ...             0   \n",
       "1                        0  ...             0   \n",
       "2                        0  ...             0   \n",
       "3                        0  ...             0   \n",
       "4                        0  ...             0   \n",
       "...                    ...  ...           ...   \n",
       "2603                     0  ...             0   \n",
       "2604                     0  ...             0   \n",
       "2605                     0  ...             0   \n",
       "2606                     0  ...             0   \n",
       "2607                     0  ...             0   \n",
       "\n",
       "      Reconstruction of Acetabular Posterior Wall  Llap Pyeloplasty  \\\n",
       "0                                               0                 0   \n",
       "1                                               0                 0   \n",
       "2                                               0                 0   \n",
       "3                                               0                 0   \n",
       "4                                               0                 0   \n",
       "...                                           ...               ...   \n",
       "2603                                            0                 0   \n",
       "2604                                            0                 0   \n",
       "2605                                            0                 0   \n",
       "2606                                            0                 0   \n",
       "2607                                            0                 0   \n",
       "\n",
       "      Burr hole  FLAP DIVISION & INSET  Nephrorectomy  Bladder Neck Incision  \\\n",
       "0             0                      0              0                      0   \n",
       "1             0                      0              0                      0   \n",
       "2             0                      0              0                      0   \n",
       "3             0                      0              0                      0   \n",
       "4             0                      0              0                      0   \n",
       "...         ...                    ...            ...                    ...   \n",
       "2603          0                      0              0                      0   \n",
       "2604          0                      0              0                      0   \n",
       "2605          0                      0              0                      0   \n",
       "2606          0                      0              0                      0   \n",
       "2607          0                      0              0                      0   \n",
       "\n",
       "      Chemoport Insertion  LOS  Bill Amt  \n",
       "0                       0    1     17300  \n",
       "1                       0    3     89500  \n",
       "2                       0    1    143700  \n",
       "3                       0    3     15000  \n",
       "4                       0    1     96000  \n",
       "...                   ...  ...       ...  \n",
       "2603                    0    1    150600  \n",
       "2604                    0    2    157200  \n",
       "2605                    0    1      6000  \n",
       "2606                    0    1     27900  \n",
       "2607                    0    2    126300  \n",
       "\n",
       "[2608 rows x 505 columns]"
      ]
     },
     "execution_count": 283,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_frame1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 284,
   "metadata": {},
   "outputs": [],
   "source": [
    "data_frame1.to_csv('data_frame1.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>Unnamed: 0.1</th>\n",
       "      <th>Age</th>\n",
       "      <th>Diagnosis</th>\n",
       "      <th>Heamaturia</th>\n",
       "      <th>MAXILLARY FRACTURE</th>\n",
       "      <th>FRACTURE FEMUR</th>\n",
       "      <th>IHD,ACS,CAD</th>\n",
       "      <th>Urinary incontinence</th>\n",
       "      <th>Antenatal Case</th>\n",
       "      <th>...</th>\n",
       "      <th>Lumbar Drain</th>\n",
       "      <th>Reconstruction of Acetabular Posterior Wall</th>\n",
       "      <th>Llap Pyeloplasty</th>\n",
       "      <th>Burr hole</th>\n",
       "      <th>FLAP DIVISION &amp; INSET</th>\n",
       "      <th>Nephrorectomy</th>\n",
       "      <th>Bladder Neck Incision</th>\n",
       "      <th>Chemoport Insertion</th>\n",
       "      <th>LOS</th>\n",
       "      <th>Bill Amt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>32</td>\n",
       "      <td>CAD</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>17300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>78</td>\n",
       "      <td>Chronic Kidney Disease</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>89500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>61</td>\n",
       "      <td>CAD</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>143700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>71</td>\n",
       "      <td>CAD</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>15000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>74</td>\n",
       "      <td>UTI</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>96000</td>\n",
       "    </tr>\n",
       "    <tr>\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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2603</td>\n",
       "      <td>2603</td>\n",
       "      <td>2603</td>\n",
       "      <td>53</td>\n",
       "      <td>VARICOSE VEIN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>150600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2604</td>\n",
       "      <td>2604</td>\n",
       "      <td>2604</td>\n",
       "      <td>68</td>\n",
       "      <td>CAD</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>157200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2605</td>\n",
       "      <td>2605</td>\n",
       "      <td>2605</td>\n",
       "      <td>57</td>\n",
       "      <td>Fever</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>6000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2606</td>\n",
       "      <td>2606</td>\n",
       "      <td>2606</td>\n",
       "      <td>54</td>\n",
       "      <td>Fever For Evaluation</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>27900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2607</td>\n",
       "      <td>2607</td>\n",
       "      <td>2607</td>\n",
       "      <td>63</td>\n",
       "      <td>Fever</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>126300</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2608 rows × 506 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Unnamed: 0  Unnamed: 0.1  Age               Diagnosis  Heamaturia  \\\n",
       "0              0             0   32                     CAD           0   \n",
       "1              1             1   78  Chronic Kidney Disease           0   \n",
       "2              2             2   61                     CAD           0   \n",
       "3              3             3   71                     CAD           0   \n",
       "4              4             4   74                     UTI           0   \n",
       "...          ...           ...  ...                     ...         ...   \n",
       "2603        2603          2603   53           VARICOSE VEIN           0   \n",
       "2604        2604          2604   68                     CAD           0   \n",
       "2605        2605          2605   57                   Fever           0   \n",
       "2606        2606          2606   54    Fever For Evaluation           0   \n",
       "2607        2607          2607   63                   Fever           0   \n",
       "\n",
       "      MAXILLARY FRACTURE  FRACTURE FEMUR  IHD,ACS,CAD  Urinary incontinence  \\\n",
       "0                      0               0            0                     0   \n",
       "1                      0               0            0                     0   \n",
       "2                      0               0            0                     0   \n",
       "3                      0               0            0                     0   \n",
       "4                      0               0            0                     0   \n",
       "...                  ...             ...          ...                   ...   \n",
       "2603                   0               0            0                     0   \n",
       "2604                   0               0            0                     0   \n",
       "2605                   0               0            0                     0   \n",
       "2606                   0               0            0                     0   \n",
       "2607                   0               0            0                     0   \n",
       "\n",
       "      Antenatal Case  ...  Lumbar Drain  \\\n",
       "0                  0  ...             0   \n",
       "1                  0  ...             0   \n",
       "2                  0  ...             0   \n",
       "3                  0  ...             0   \n",
       "4                  0  ...             0   \n",
       "...              ...  ...           ...   \n",
       "2603               0  ...             0   \n",
       "2604               0  ...             0   \n",
       "2605               0  ...             0   \n",
       "2606               0  ...             0   \n",
       "2607               0  ...             0   \n",
       "\n",
       "      Reconstruction of Acetabular Posterior Wall  Llap Pyeloplasty  \\\n",
       "0                                               0                 0   \n",
       "1                                               0                 0   \n",
       "2                                               0                 0   \n",
       "3                                               0                 0   \n",
       "4                                               0                 0   \n",
       "...                                           ...               ...   \n",
       "2603                                            0                 0   \n",
       "2604                                            0                 0   \n",
       "2605                                            0                 0   \n",
       "2606                                            0                 0   \n",
       "2607                                            0                 0   \n",
       "\n",
       "      Burr hole  FLAP DIVISION & INSET  Nephrorectomy  Bladder Neck Incision  \\\n",
       "0             0                      0              0                      0   \n",
       "1             0                      0              0                      0   \n",
       "2             0                      0              0                      0   \n",
       "3             0                      0              0                      0   \n",
       "4             0                      0              0                      0   \n",
       "...         ...                    ...            ...                    ...   \n",
       "2603          0                      0              0                      0   \n",
       "2604          0                      0              0                      0   \n",
       "2605          0                      0              0                      0   \n",
       "2606          0                      0              0                      0   \n",
       "2607          0                      0              0                      0   \n",
       "\n",
       "      Chemoport Insertion  LOS  Bill Amt  \n",
       "0                       0    1     17300  \n",
       "1                       0    3     89500  \n",
       "2                       0    1    143700  \n",
       "3                       0    3     15000  \n",
       "4                       0    1     96000  \n",
       "...                   ...  ...       ...  \n",
       "2603                    0    1    150600  \n",
       "2604                    0    2    157200  \n",
       "2605                    0    1      6000  \n",
       "2606                    0    1     27900  \n",
       "2607                    0    2    126300  \n",
       "\n",
       "[2608 rows x 506 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_frame2 = pd.read_csv('./data_frame1.csv')\n",
    "data_frame2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "def scale(data_frame,stri):\n",
    "    x = list(data_frame[stri])\n",
    "    mn = min(x)\n",
    "    mx = max(x)\n",
    "    l=[]\n",
    "    for i in x:\n",
    "        l.append((i-mn)/(mx-mn))\n",
    "    return mx,l"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "max_age,l_age = scale(data_frame2,'Age')\n",
    "max_los,l_los = scale(data_frame2,'LOS')\n",
    "max_bill,l_bill = scale(data_frame2,'Bill Amt')\n",
    "\n",
    "data_frame2.insert(1,\"bill\",l_bill)\n",
    "data_frame2.insert(1,\"los\",l_los)\n",
    "data_frame2.insert(1,\"age\",l_age)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2720000"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "max_bill"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 318,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>age</th>\n",
       "      <th>los</th>\n",
       "      <th>bill</th>\n",
       "      <th>Unnamed: 0.1</th>\n",
       "      <th>Age</th>\n",
       "      <th>Diagnosis</th>\n",
       "      <th>Heamaturia</th>\n",
       "      <th>MAXILLARY FRACTURE</th>\n",
       "      <th>FRACTURE FEMUR</th>\n",
       "      <th>...</th>\n",
       "      <th>Lumbar Drain</th>\n",
       "      <th>Reconstruction of Acetabular Posterior Wall</th>\n",
       "      <th>Llap Pyeloplasty</th>\n",
       "      <th>Burr hole</th>\n",
       "      <th>FLAP DIVISION &amp; INSET</th>\n",
       "      <th>Nephrorectomy</th>\n",
       "      <th>Bladder Neck Incision</th>\n",
       "      <th>Chemoport Insertion</th>\n",
       "      <th>LOS</th>\n",
       "      <th>Bill Amt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.31</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.006360</td>\n",
       "      <td>0</td>\n",
       "      <td>32</td>\n",
       "      <td>CAD</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>17300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0.77</td>\n",
       "      <td>0.045455</td>\n",
       "      <td>0.032904</td>\n",
       "      <td>1</td>\n",
       "      <td>78</td>\n",
       "      <td>Chronic Kidney Disease</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>89500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0.60</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.052831</td>\n",
       "      <td>2</td>\n",
       "      <td>61</td>\n",
       "      <td>CAD</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>143700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>0.70</td>\n",
       "      <td>0.045455</td>\n",
       "      <td>0.005515</td>\n",
       "      <td>3</td>\n",
       "      <td>71</td>\n",
       "      <td>CAD</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>15000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>0.73</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.035294</td>\n",
       "      <td>4</td>\n",
       "      <td>74</td>\n",
       "      <td>UTI</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>96000</td>\n",
       "    </tr>\n",
       "    <tr>\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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2603</td>\n",
       "      <td>2603</td>\n",
       "      <td>0.52</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.055368</td>\n",
       "      <td>2603</td>\n",
       "      <td>53</td>\n",
       "      <td>VARICOSE VEIN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>150600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2604</td>\n",
       "      <td>2604</td>\n",
       "      <td>0.67</td>\n",
       "      <td>0.022727</td>\n",
       "      <td>0.057794</td>\n",
       "      <td>2604</td>\n",
       "      <td>68</td>\n",
       "      <td>CAD</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>157200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2605</td>\n",
       "      <td>2605</td>\n",
       "      <td>0.56</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.002206</td>\n",
       "      <td>2605</td>\n",
       "      <td>57</td>\n",
       "      <td>Fever</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>6000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2606</td>\n",
       "      <td>2606</td>\n",
       "      <td>0.53</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.010257</td>\n",
       "      <td>2606</td>\n",
       "      <td>54</td>\n",
       "      <td>Fever For Evaluation</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>27900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2607</td>\n",
       "      <td>2607</td>\n",
       "      <td>0.62</td>\n",
       "      <td>0.022727</td>\n",
       "      <td>0.046434</td>\n",
       "      <td>2607</td>\n",
       "      <td>63</td>\n",
       "      <td>Fever</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>126300</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2608 rows × 509 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Unnamed: 0   age       los      bill  Unnamed: 0.1  Age  \\\n",
       "0              0  0.31  0.000000  0.006360             0   32   \n",
       "1              1  0.77  0.045455  0.032904             1   78   \n",
       "2              2  0.60  0.000000  0.052831             2   61   \n",
       "3              3  0.70  0.045455  0.005515             3   71   \n",
       "4              4  0.73  0.000000  0.035294             4   74   \n",
       "...          ...   ...       ...       ...           ...  ...   \n",
       "2603        2603  0.52  0.000000  0.055368          2603   53   \n",
       "2604        2604  0.67  0.022727  0.057794          2604   68   \n",
       "2605        2605  0.56  0.000000  0.002206          2605   57   \n",
       "2606        2606  0.53  0.000000  0.010257          2606   54   \n",
       "2607        2607  0.62  0.022727  0.046434          2607   63   \n",
       "\n",
       "                   Diagnosis  Heamaturia  MAXILLARY FRACTURE  FRACTURE FEMUR  \\\n",
       "0                        CAD           0                   0               0   \n",
       "1     Chronic Kidney Disease           0                   0               0   \n",
       "2                        CAD           0                   0               0   \n",
       "3                        CAD           0                   0               0   \n",
       "4                        UTI           0                   0               0   \n",
       "...                      ...         ...                 ...             ...   \n",
       "2603           VARICOSE VEIN           0                   0               0   \n",
       "2604                     CAD           0                   0               0   \n",
       "2605                   Fever           0                   0               0   \n",
       "2606    Fever For Evaluation           0                   0               0   \n",
       "2607                   Fever           0                   0               0   \n",
       "\n",
       "      ...  Lumbar Drain  Reconstruction of Acetabular Posterior Wall  \\\n",
       "0     ...             0                                            0   \n",
       "1     ...             0                                            0   \n",
       "2     ...             0                                            0   \n",
       "3     ...             0                                            0   \n",
       "4     ...             0                                            0   \n",
       "...   ...           ...                                          ...   \n",
       "2603  ...             0                                            0   \n",
       "2604  ...             0                                            0   \n",
       "2605  ...             0                                            0   \n",
       "2606  ...             0                                            0   \n",
       "2607  ...             0                                            0   \n",
       "\n",
       "      Llap Pyeloplasty  Burr hole  FLAP DIVISION & INSET  Nephrorectomy  \\\n",
       "0                    0          0                      0              0   \n",
       "1                    0          0                      0              0   \n",
       "2                    0          0                      0              0   \n",
       "3                    0          0                      0              0   \n",
       "4                    0          0                      0              0   \n",
       "...                ...        ...                    ...            ...   \n",
       "2603                 0          0                      0              0   \n",
       "2604                 0          0                      0              0   \n",
       "2605                 0          0                      0              0   \n",
       "2606                 0          0                      0              0   \n",
       "2607                 0          0                      0              0   \n",
       "\n",
       "      Bladder Neck Incision  Chemoport Insertion  LOS  Bill Amt  \n",
       "0                         0                    0    1     17300  \n",
       "1                         0                    0    3     89500  \n",
       "2                         0                    0    1    143700  \n",
       "3                         0                    0    3     15000  \n",
       "4                         0                    0    1     96000  \n",
       "...                     ...                  ...  ...       ...  \n",
       "2603                      0                    0    1    150600  \n",
       "2604                      0                    0    2    157200  \n",
       "2605                      0                    0    1      6000  \n",
       "2606                      0                    0    1     27900  \n",
       "2607                      0                    0    2    126300  \n",
       "\n",
       "[2608 rows x 509 columns]"
      ]
     },
     "execution_count": 318,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_frame2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 319,
   "metadata": {},
   "outputs": [],
   "source": [
    "data_frame2.to_csv('data_frame2.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 295,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[0.31,\n",
       " 0.77,\n",
       " 0.6,\n",
       " 0.7,\n",
       " 0.73,\n",
       " 0.47,\n",
       " 0.35,\n",
       " 0.71,\n",
       " 0.85,\n",
       " 0.42,\n",
       " 0.69,\n",
       " 0.36,\n",
       " 0.48,\n",
       " 0.57,\n",
       " 0.73,\n",
       " 0.62,\n",
       " 0.59,\n",
       " 0.62,\n",
       " 0.73,\n",
       " 0.58,\n",
       " 0.66,\n",
       " 0.64,\n",
       " 0.04,\n",
       " 0.57,\n",
       " 0.67,\n",
       " 0.37,\n",
       " 0.42,\n",
       " 0.49,\n",
       " 0.41,\n",
       " 0.83,\n",
       " 0.54,\n",
       " 0.7,\n",
       " 0.64,\n",
       " 0.52,\n",
       " 0.47,\n",
       " 0.55,\n",
       " 0.75,\n",
       " 0.56,\n",
       " 0.67,\n",
       " 0.64,\n",
       " 0.23,\n",
       " 0.26,\n",
       " 0.38,\n",
       " 0.3,\n",
       " 0.6,\n",
       " 0.69,\n",
       " 0.49,\n",
       " 0.68,\n",
       " 0.79,\n",
       " 0.72,\n",
       " 0.69,\n",
       " 0.65,\n",
       " 0.1,\n",
       " 0.69,\n",
       " 0.01,\n",
       " 0.6,\n",
       " 0.58,\n",
       " 0.51,\n",
       " 0.61,\n",
       " 0.72,\n",
       " 0.54,\n",
       " 0.94,\n",
       " 0.07,\n",
       " 0.77,\n",
       " 0.72,\n",
       " 0.33,\n",
       " 0.02,\n",
       " 0.67,\n",
       " 0.67,\n",
       " 0.32,\n",
       " 0.41,\n",
       " 0.67,\n",
       " 0.73,\n",
       " 0.58,\n",
       " 0.66,\n",
       " 0.7,\n",
       " 0.81,\n",
       " 0.69,\n",
       " 0.59,\n",
       " 0.72,\n",
       " 0.69,\n",
       " 0.74,\n",
       " 0.26,\n",
       " 0.8,\n",
       " 0.74,\n",
       " 0.57,\n",
       " 0.46,\n",
       " 0.37,\n",
       " 0.47,\n",
       " 0.63,\n",
       " 0.56,\n",
       " 0.87,\n",
       " 0.03,\n",
       " 0.03,\n",
       " 0.69,\n",
       " 0.65,\n",
       " 0.67,\n",
       " 0.77,\n",
       " 0.4,\n",
       " 0.42,\n",
       " 0.0,\n",
       " 0.67,\n",
       " 0.48,\n",
       " 0.07,\n",
       " 0.54,\n",
       " 0.33,\n",
       " 0.6,\n",
       " 0.52,\n",
       " 0.75,\n",
       " 0.25,\n",
       " 0.55,\n",
       " 0.83,\n",
       " 0.56,\n",
       " 0.61,\n",
       " 0.22,\n",
       " 0.61,\n",
       " 0.38,\n",
       " 0.58,\n",
       " 0.3,\n",
       " 0.63,\n",
       " 0.62,\n",
       " 0.22,\n",
       " 0.59,\n",
       " 0.82,\n",
       " 0.53,\n",
       " 0.53,\n",
       " 0.47,\n",
       " 0.53,\n",
       " 0.57,\n",
       " 0.52,\n",
       " 0.56,\n",
       " 0.62,\n",
       " 0.58,\n",
       " 0.67,\n",
       " 0.22,\n",
       " 0.64,\n",
       " 0.57,\n",
       " 0.63,\n",
       " 0.68,\n",
       " 0.65,\n",
       " 0.59,\n",
       " 0.65,\n",
       " 0.6,\n",
       " 0.07,\n",
       " 0.69,\n",
       " 0.48,\n",
       " 0.77,\n",
       " 0.57,\n",
       " 0.13,\n",
       " 0.56,\n",
       " 0.59,\n",
       " 0.7,\n",
       " 0.74,\n",
       " 0.47,\n",
       " 0.58,\n",
       " 0.67,\n",
       " 0.52,\n",
       " 0.66,\n",
       " 0.63,\n",
       " 0.53,\n",
       " 0.6,\n",
       " 0.23,\n",
       " 0.44,\n",
       " 0.66,\n",
       " 0.66,\n",
       " 0.69,\n",
       " 0.53,\n",
       " 0.47,\n",
       " 0.78,\n",
       " 0.75,\n",
       " 0.16,\n",
       " 0.78,\n",
       " 0.82,\n",
       " 0.75,\n",
       " 0.66,\n",
       " 0.59,\n",
       " 0.69,\n",
       " 0.37,\n",
       " 0.45,\n",
       " 0.65,\n",
       " 0.72,\n",
       " 0.4,\n",
       " 0.0,\n",
       " 0.58,\n",
       " 0.84,\n",
       " 0.79,\n",
       " 0.49,\n",
       " 0.47,\n",
       " 0.66,\n",
       " 0.39,\n",
       " 0.51,\n",
       " 0.26,\n",
       " 0.0,\n",
       " 0.58,\n",
       " 0.77,\n",
       " 0.57,\n",
       " 0.75,\n",
       " 0.46,\n",
       " 0.79,\n",
       " 0.56,\n",
       " 0.51,\n",
       " 0.86,\n",
       " 0.26,\n",
       " 0.43,\n",
       " 0.6,\n",
       " 0.26,\n",
       " 0.59,\n",
       " 0.43,\n",
       " 0.78,\n",
       " 0.75,\n",
       " 0.58,\n",
       " 0.3,\n",
       " 0.45,\n",
       " 0.34,\n",
       " 0.65,\n",
       " 0.6,\n",
       " 0.52,\n",
       " 0.88,\n",
       " 0.0,\n",
       " 0.47,\n",
       " 0.75,\n",
       " 0.75,\n",
       " 0.52,\n",
       " 0.69,\n",
       " 0.06,\n",
       " 0.66,\n",
       " 0.36,\n",
       " 0.37,\n",
       " 0.81,\n",
       " 0.55,\n",
       " 0.68,\n",
       " 0.86,\n",
       " 0.58,\n",
       " 0.49,\n",
       " 0.58,\n",
       " 0.78,\n",
       " 0.86,\n",
       " 0.56,\n",
       " 0.34,\n",
       " 0.52,\n",
       " 0.64,\n",
       " 0.45,\n",
       " 0.45,\n",
       " 0.57,\n",
       " 0.7,\n",
       " 0.4,\n",
       " 0.2,\n",
       " 0.47,\n",
       " 0.77,\n",
       " 0.68,\n",
       " 0.63,\n",
       " 0.05,\n",
       " 0.57,\n",
       " 0.24,\n",
       " 0.38,\n",
       " 0.4,\n",
       " 0.39,\n",
       " 0.64,\n",
       " 0.72,\n",
       " 0.57,\n",
       " 0.24,\n",
       " 0.69,\n",
       " 0.64,\n",
       " 0.37,\n",
       " 0.54,\n",
       " 0.76,\n",
       " 0.79,\n",
       " 0.39,\n",
       " 0.64,\n",
       " 0.53,\n",
       " 0.41,\n",
       " 0.21,\n",
       " 0.66,\n",
       " 0.75,\n",
       " 0.03,\n",
       " 0.69,\n",
       " 0.02,\n",
       " 0.42,\n",
       " 0.35,\n",
       " 0.5,\n",
       " 0.53,\n",
       " 0.31,\n",
       " 0.65,\n",
       " 0.11,\n",
       " 0.33,\n",
       " 0.71,\n",
       " 0.02,\n",
       " 0.5,\n",
       " 0.75,\n",
       " 0.11,\n",
       " 0.68,\n",
       " 0.83,\n",
       " 0.79,\n",
       " 0.45,\n",
       " 0.83,\n",
       " 0.66,\n",
       " 0.32,\n",
       " 0.27,\n",
       " 0.06,\n",
       " 0.55,\n",
       " 0.64,\n",
       " 0.41,\n",
       " 0.56,\n",
       " 0.71,\n",
       " 0.31,\n",
       " 0.71,\n",
       " 0.77,\n",
       " 0.55,\n",
       " 0.53,\n",
       " 0.54,\n",
       " 0.57,\n",
       " 0.7,\n",
       " 0.19,\n",
       " 0.61,\n",
       " 0.44,\n",
       " 0.63,\n",
       " 0.57,\n",
       " 0.54,\n",
       " 0.57,\n",
       " 0.61,\n",
       " 0.76,\n",
       " 0.7,\n",
       " 0.33,\n",
       " 0.64,\n",
       " 0.41,\n",
       " 0.65,\n",
       " 0.0,\n",
       " 0.76,\n",
       " 0.58,\n",
       " 0.31,\n",
       " 0.55,\n",
       " 0.77,\n",
       " 0.1,\n",
       " 0.76,\n",
       " 0.57,\n",
       " 0.68,\n",
       " 0.2,\n",
       " 0.84,\n",
       " 0.67,\n",
       " 0.56,\n",
       " 0.61,\n",
       " 0.38,\n",
       " 0.58,\n",
       " 0.36,\n",
       " 0.88,\n",
       " 0.78,\n",
       " 0.29,\n",
       " 0.64,\n",
       " 0.6,\n",
       " 0.4,\n",
       " 0.67,\n",
       " 0.01,\n",
       " 0.74,\n",
       " 0.63,\n",
       " 0.54,\n",
       " 0.02,\n",
       " 0.7,\n",
       " 0.53,\n",
       " 0.49,\n",
       " 0.24,\n",
       " 0.61,\n",
       " 0.57,\n",
       " 0.1,\n",
       " 0.77,\n",
       " 0.62,\n",
       " 0.59,\n",
       " 0.55,\n",
       " 0.41,\n",
       " 0.35,\n",
       " 0.52,\n",
       " 0.53,\n",
       " 0.8,\n",
       " 0.11,\n",
       " 0.21,\n",
       " 0.74,\n",
       " 0.69,\n",
       " 0.49,\n",
       " 0.64,\n",
       " 0.34,\n",
       " 0.63,\n",
       " 0.54,\n",
       " 0.62,\n",
       " 0.55,\n",
       " 0.66,\n",
       " 0.72,\n",
       " 0.75,\n",
       " 0.67,\n",
       " 0.59,\n",
       " 0.25,\n",
       " 0.38,\n",
       " 0.76,\n",
       " 0.67,\n",
       " 0.55,\n",
       " 0.62,\n",
       " 0.62,\n",
       " 0.65,\n",
       " 0.59,\n",
       " 0.8,\n",
       " 0.55,\n",
       " 0.81,\n",
       " 0.0,\n",
       " 0.61,\n",
       " 0.86,\n",
       " 0.79,\n",
       " 0.19,\n",
       " 0.61,\n",
       " 0.53,\n",
       " 0.8,\n",
       " 0.04,\n",
       " 0.56,\n",
       " 0.72,\n",
       " 0.09,\n",
       " 0.74,\n",
       " 0.26,\n",
       " 0.58,\n",
       " 0.52,\n",
       " 0.8,\n",
       " 0.72,\n",
       " 0.34,\n",
       " 0.28,\n",
       " 0.77,\n",
       " 0.74,\n",
       " 0.43,\n",
       " 0.49,\n",
       " 0.83,\n",
       " 0.69,\n",
       " 0.75,\n",
       " 0.58,\n",
       " 0.55,\n",
       " 0.81,\n",
       " 0.35,\n",
       " 0.69,\n",
       " 0.19,\n",
       " 0.68,\n",
       " 0.69,\n",
       " 0.02,\n",
       " 0.73,\n",
       " 0.64,\n",
       " 0.72,\n",
       " 0.77,\n",
       " 0.67,\n",
       " 0.59,\n",
       " 0.58,\n",
       " 0.18,\n",
       " 0.76,\n",
       " 0.8,\n",
       " 0.62,\n",
       " 0.0,\n",
       " 0.36,\n",
       " 0.45,\n",
       " 0.0,\n",
       " 0.54,\n",
       " 0.83,\n",
       " 0.61,\n",
       " 0.54,\n",
       " 0.79,\n",
       " 0.31,\n",
       " 0.32,\n",
       " 0.35,\n",
       " 0.79,\n",
       " 0.43,\n",
       " 0.65,\n",
       " 0.77,\n",
       " 0.7,\n",
       " 0.54,\n",
       " 0.65,\n",
       " 0.77,\n",
       " 0.46,\n",
       " 0.3,\n",
       " 0.67,\n",
       " 0.71,\n",
       " 0.57,\n",
       " 0.85,\n",
       " 0.66,\n",
       " 0.51,\n",
       " 0.09,\n",
       " 0.46,\n",
       " 0.53,\n",
       " 0.55,\n",
       " 0.73,\n",
       " 0.01,\n",
       " 0.6,\n",
       " 0.56,\n",
       " 0.31,\n",
       " 0.7,\n",
       " 0.82,\n",
       " 0.7,\n",
       " 0.62,\n",
       " 0.63,\n",
       " 0.47,\n",
       " 0.57,\n",
       " 0.46,\n",
       " 0.68,\n",
       " 0.53,\n",
       " 0.55,\n",
       " 0.57,\n",
       " 0.52,\n",
       " 0.51,\n",
       " 0.48,\n",
       " 0.57,\n",
       " 0.82,\n",
       " 0.24,\n",
       " 0.52,\n",
       " 0.47,\n",
       " 0.35,\n",
       " 0.78,\n",
       " 0.7,\n",
       " 0.38,\n",
       " 0.58,\n",
       " 0.05,\n",
       " 0.66,\n",
       " 0.4,\n",
       " 0.84,\n",
       " 0.75,\n",
       " 0.59,\n",
       " 0.47,\n",
       " 0.04,\n",
       " 0.01,\n",
       " 0.79,\n",
       " 0.8,\n",
       " 0.56,\n",
       " 0.48,\n",
       " 0.55,\n",
       " 0.79,\n",
       " 0.66,\n",
       " 0.51,\n",
       " 0.54,\n",
       " 0.76,\n",
       " 0.84,\n",
       " 0.7,\n",
       " 0.82,\n",
       " 0.37,\n",
       " 0.21,\n",
       " 0.82,\n",
       " 0.69,\n",
       " 0.27,\n",
       " 0.76,\n",
       " 0.48,\n",
       " 0.11,\n",
       " 0.35,\n",
       " 0.74,\n",
       " 0.72,\n",
       " 0.56,\n",
       " 0.56,\n",
       " 0.66,\n",
       " 0.56,\n",
       " 0.25,\n",
       " 0.62,\n",
       " 0.61,\n",
       " 0.77,\n",
       " 0.45,\n",
       " 0.62,\n",
       " 0.44,\n",
       " 0.03,\n",
       " 0.66,\n",
       " 0.63,\n",
       " 0.71,\n",
       " 0.24,\n",
       " 0.66,\n",
       " 0.69,\n",
       " 0.43,\n",
       " 0.58,\n",
       " 0.79,\n",
       " 0.42,\n",
       " 0.67,\n",
       " 0.44,\n",
       " 0.35,\n",
       " 0.92,\n",
       " 0.75,\n",
       " 0.45,\n",
       " 0.72,\n",
       " 0.42,\n",
       " 0.68,\n",
       " 0.51,\n",
       " 0.5,\n",
       " 0.29,\n",
       " 0.84,\n",
       " 0.67,\n",
       " 0.74,\n",
       " 0.76,\n",
       " 0.29,\n",
       " 0.59,\n",
       " 0.68,\n",
       " 0.56,\n",
       " 0.53,\n",
       " 0.76,\n",
       " 0.55,\n",
       " 0.7,\n",
       " 0.6,\n",
       " 0.68,\n",
       " 0.72,\n",
       " 0.71,\n",
       " 0.57,\n",
       " 0.53,\n",
       " 0.83,\n",
       " 0.48,\n",
       " 0.68,\n",
       " 0.51,\n",
       " 0.64,\n",
       " 0.49,\n",
       " 0.72,\n",
       " 0.27,\n",
       " 0.85,\n",
       " 0.39,\n",
       " 0.88,\n",
       " 0.83,\n",
       " 0.26,\n",
       " 0.35,\n",
       " 0.81,\n",
       " 0.76,\n",
       " 0.25,\n",
       " 0.57,\n",
       " 0.35,\n",
       " 0.38,\n",
       " 0.82,\n",
       " 0.69,\n",
       " 0.73,\n",
       " 0.81,\n",
       " 0.27,\n",
       " 0.68,\n",
       " 0.0,\n",
       " 0.75,\n",
       " 0.64,\n",
       " 0.76,\n",
       " 0.79,\n",
       " 0.75,\n",
       " 0.68,\n",
       " 0.48,\n",
       " 0.48,\n",
       " 0.38,\n",
       " 0.27,\n",
       " 0.41,\n",
       " 0.6,\n",
       " 0.6,\n",
       " 0.6,\n",
       " 0.85,\n",
       " 0.61,\n",
       " 0.45,\n",
       " 0.64,\n",
       " 0.75,\n",
       " 0.5,\n",
       " 0.56,\n",
       " 0.69,\n",
       " 0.66,\n",
       " 0.37,\n",
       " 0.78,\n",
       " 0.86,\n",
       " 0.17,\n",
       " 0.46,\n",
       " 0.81,\n",
       " 0.84,\n",
       " 0.25,\n",
       " 0.2,\n",
       " 0.58,\n",
       " 0.71,\n",
       " 0.55,\n",
       " 0.51,\n",
       " 0.61,\n",
       " 0.79,\n",
       " 0.45,\n",
       " 0.73,\n",
       " 0.63,\n",
       " 0.47,\n",
       " 0.72,\n",
       " 0.79,\n",
       " 0.76,\n",
       " 0.73,\n",
       " 0.26,\n",
       " 0.41,\n",
       " 0.56,\n",
       " 0.86,\n",
       " 0.66,\n",
       " 0.47,\n",
       " 0.67,\n",
       " 0.57,\n",
       " 0.42,\n",
       " 0.65,\n",
       " 0.21,\n",
       " 0.64,\n",
       " 0.26,\n",
       " 0.46,\n",
       " 0.62,\n",
       " 0.65,\n",
       " 0.56,\n",
       " 0.28,\n",
       " 0.23,\n",
       " 0.4,\n",
       " 0.69,\n",
       " 0.66,\n",
       " 0.69,\n",
       " 0.78,\n",
       " 0.72,\n",
       " 0.87,\n",
       " 0.29,\n",
       " 0.72,\n",
       " 0.64,\n",
       " 0.53,\n",
       " 0.05,\n",
       " 0.52,\n",
       " 0.74,\n",
       " 0.49,\n",
       " 0.5,\n",
       " 0.79,\n",
       " 0.77,\n",
       " 0.54,\n",
       " 0.55,\n",
       " 0.49,\n",
       " 0.67,\n",
       " 0.74,\n",
       " 0.86,\n",
       " 0.55,\n",
       " 0.51,\n",
       " 0.09,\n",
       " 0.32,\n",
       " 0.63,\n",
       " 0.58,\n",
       " 0.63,\n",
       " 0.39,\n",
       " 0.8,\n",
       " 0.49,\n",
       " 0.69,\n",
       " 0.57,\n",
       " 0.67,\n",
       " 0.41,\n",
       " 0.59,\n",
       " 0.78,\n",
       " 0.49,\n",
       " 0.78,\n",
       " 0.54,\n",
       " 0.52,\n",
       " 0.51,\n",
       " 0.69,\n",
       " 0.74,\n",
       " 0.34,\n",
       " 0.72,\n",
       " 0.25,\n",
       " 0.77,\n",
       " 0.6,\n",
       " 0.62,\n",
       " 0.77,\n",
       " 0.85,\n",
       " 0.71,\n",
       " 0.55,\n",
       " 0.64,\n",
       " 0.62,\n",
       " 0.71,\n",
       " 0.38,\n",
       " 0.46,\n",
       " 0.43,\n",
       " 0.73,\n",
       " 0.62,\n",
       " 0.53,\n",
       " 0.42,\n",
       " 0.53,\n",
       " 0.74,\n",
       " 0.63,\n",
       " 0.62,\n",
       " 0.31,\n",
       " 0.68,\n",
       " 0.52,\n",
       " 0.44,\n",
       " 0.56,\n",
       " 0.27,\n",
       " 0.53,\n",
       " 0.5,\n",
       " 0.1,\n",
       " 0.56,\n",
       " 0.69,\n",
       " 0.83,\n",
       " 0.72,\n",
       " 0.7,\n",
       " 0.82,\n",
       " 0.37,\n",
       " 0.72,\n",
       " 0.62,\n",
       " 0.48,\n",
       " 0.26,\n",
       " 0.53,\n",
       " 0.49,\n",
       " 0.5,\n",
       " 0.89,\n",
       " 0.58,\n",
       " 0.39,\n",
       " 0.78,\n",
       " 0.84,\n",
       " 0.59,\n",
       " 0.85,\n",
       " 0.6,\n",
       " 0.54,\n",
       " 0.74,\n",
       " 0.34,\n",
       " 0.5,\n",
       " 0.63,\n",
       " 0.57,\n",
       " 0.58,\n",
       " 0.76,\n",
       " 0.57,\n",
       " 0.66,\n",
       " 0.23,\n",
       " 0.53,\n",
       " 0.62,\n",
       " 0.44,\n",
       " 0.59,\n",
       " 0.6,\n",
       " 0.59,\n",
       " 0.32,\n",
       " 0.73,\n",
       " 0.74,\n",
       " 0.77,\n",
       " 0.26,\n",
       " 0.69,\n",
       " 0.67,\n",
       " 0.87,\n",
       " 0.5,\n",
       " 0.42,\n",
       " 0.66,\n",
       " 0.66,\n",
       " 0.66,\n",
       " 0.71,\n",
       " 0.42,\n",
       " 0.68,\n",
       " 0.48,\n",
       " 0.11,\n",
       " 0.49,\n",
       " 0.17,\n",
       " 0.4,\n",
       " 0.54,\n",
       " 0.57,\n",
       " 0.67,\n",
       " 0.78,\n",
       " 0.45,\n",
       " 0.34,\n",
       " 0.79,\n",
       " 0.9,\n",
       " 0.94,\n",
       " 0.82,\n",
       " 0.75,\n",
       " 0.69,\n",
       " 0.87,\n",
       " 0.64,\n",
       " 0.23,\n",
       " 0.69,\n",
       " 0.74,\n",
       " 0.59,\n",
       " 0.18,\n",
       " 0.7,\n",
       " 0.35,\n",
       " 0.47,\n",
       " 0.0,\n",
       " 0.41,\n",
       " 0.74,\n",
       " 0.67,\n",
       " 0.79,\n",
       " 0.72,\n",
       " 0.91,\n",
       " 0.51,\n",
       " 0.65,\n",
       " 0.29,\n",
       " 0.36,\n",
       " 0.05,\n",
       " 0.69,\n",
       " 0.6,\n",
       " 0.42,\n",
       " 0.55,\n",
       " 0.46,\n",
       " 0.05,\n",
       " 0.23,\n",
       " 0.32,\n",
       " 0.4,\n",
       " 0.63,\n",
       " 0.57,\n",
       " 0.42,\n",
       " 0.76,\n",
       " 0.41,\n",
       " 0.29,\n",
       " 0.61,\n",
       " 0.82,\n",
       " 0.63,\n",
       " 0.44,\n",
       " 0.46,\n",
       " 0.55,\n",
       " 0.33,\n",
       " 0.62,\n",
       " 0.64,\n",
       " 0.6,\n",
       " 0.68,\n",
       " 0.41,\n",
       " 0.02,\n",
       " 0.82,\n",
       " 0.0,\n",
       " 0.79,\n",
       " 0.68,\n",
       " 0.7,\n",
       " 0.41,\n",
       " 0.5,\n",
       " 0.65,\n",
       " 0.52,\n",
       " 0.25,\n",
       " 0.55,\n",
       " 0.0,\n",
       " 0.59,\n",
       " 0.29,\n",
       " 0.58,\n",
       " 0.78,\n",
       " 0.74,\n",
       " 0.24,\n",
       " 0.76,\n",
       " 0.63,\n",
       " 0.36,\n",
       " 0.32,\n",
       " 0.84,\n",
       " 0.48,\n",
       " 0.48,\n",
       " 0.78,\n",
       " 0.79,\n",
       " 0.21,\n",
       " 0.29,\n",
       " 0.54,\n",
       " 0.64,\n",
       " 0.29,\n",
       " 0.59,\n",
       " 0.32,\n",
       " 0.54,\n",
       " 0.51,\n",
       " 0.66,\n",
       " 0.05,\n",
       " 0.44,\n",
       " 0.44,\n",
       " 0.55,\n",
       " 0.7,\n",
       " 0.56,\n",
       " 0.61,\n",
       " 0.77,\n",
       " 0.49,\n",
       " 0.44,\n",
       " 0.13,\n",
       " 0.55,\n",
       " 0.76,\n",
       " 0.47,\n",
       " 0.45,\n",
       " 0.58,\n",
       " 0.73,\n",
       " 0.83,\n",
       " 0.74,\n",
       " 0.61,\n",
       " 0.58,\n",
       " 0.63,\n",
       " 0.54,\n",
       " 0.6,\n",
       " 0.24,\n",
       " 0.53,\n",
       " 0.05,\n",
       " 0.73,\n",
       " 0.58,\n",
       " 0.55,\n",
       " 0.12,\n",
       " 0.77,\n",
       " 0.44,\n",
       " 0.52,\n",
       " 0.46,\n",
       " 0.44,\n",
       " 0.02,\n",
       " 0.74,\n",
       " 0.33,\n",
       " 0.5,\n",
       " 0.67,\n",
       " 0.87,\n",
       " 0.56,\n",
       " 0.8,\n",
       " 0.57,\n",
       " 0.69,\n",
       " 0.63,\n",
       " 0.67,\n",
       " 0.27,\n",
       " 0.38,\n",
       " 0.34,\n",
       " 0.43,\n",
       " 0.49,\n",
       " 0.91,\n",
       " 0.66,\n",
       " 0.48,\n",
       " 0.79,\n",
       " 0.35,\n",
       " 0.44,\n",
       " 0.22,\n",
       " 0.66,\n",
       " 0.62,\n",
       " 0.5,\n",
       " 0.01,\n",
       " 0.81,\n",
       " 0.7,\n",
       " 0.07,\n",
       " 0.76,\n",
       " 0.59,\n",
       " 0.7,\n",
       " 0.77,\n",
       " 0.52,\n",
       " 0.46,\n",
       " 0.51,\n",
       " 0.44,\n",
       " ...]"
      ]
     },
     "execution_count": 295,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "l_age"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 298,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Age</th>\n",
       "      <th>Diagnosis</th>\n",
       "      <th>Surgery</th>\n",
       "      <th>Bipolar Hemiarthroplasty</th>\n",
       "      <th>Chemoport Removal</th>\n",
       "      <th>Hypospadias</th>\n",
       "      <th>Gastro jejunostomy</th>\n",
       "      <th>ORIF WITHMEDIAL MALLELOUS FIXATIONWITH FIBULA</th>\n",
       "      <th>Check URS</th>\n",
       "      <th>Temporay Pacemaker Implantation (TPI)</th>\n",
       "      <th>...</th>\n",
       "      <th>Lumbar Drain</th>\n",
       "      <th>Reconstruction of Acetabular Posterior Wall</th>\n",
       "      <th>Llap Pyeloplasty</th>\n",
       "      <th>Burr hole</th>\n",
       "      <th>FLAP DIVISION &amp; INSET</th>\n",
       "      <th>Nephrorectomy</th>\n",
       "      <th>Bladder Neck Incision</th>\n",
       "      <th>Chemoport Insertion</th>\n",
       "      <th>LOS</th>\n",
       "      <th>Bill Amt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>32</td>\n",
       "      <td>CAD</td>\n",
       "      <td>CAG</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>17300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>78</td>\n",
       "      <td>Chronic Kidney Disease</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>89500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>61</td>\n",
       "      <td>CAD</td>\n",
       "      <td>PTCA- DRUG ELUT</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>143700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>71</td>\n",
       "      <td>CAD</td>\n",
       "      <td>CAG</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>15000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>74</td>\n",
       "      <td>UTI</td>\n",
       "      <td>Incisional Hernia Repair</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>96000</td>\n",
       "    </tr>\n",
       "    <tr>\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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2603</td>\n",
       "      <td>53</td>\n",
       "      <td>VARICOSE VEIN</td>\n",
       "      <td>Peripheral Angioplasty</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>150600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2604</td>\n",
       "      <td>68</td>\n",
       "      <td>CAD</td>\n",
       "      <td>PTCA- DRUG ELUT</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>157200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2605</td>\n",
       "      <td>57</td>\n",
       "      <td>Fever</td>\n",
       "      <td>Phaco Emulsification with IOL</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>6000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2606</td>\n",
       "      <td>54</td>\n",
       "      <td>Fever For Evaluation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>27900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2607</td>\n",
       "      <td>63</td>\n",
       "      <td>Fever</td>\n",
       "      <td>Cystoscopy DJS</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>126300</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2608 rows × 258 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Age               Diagnosis                        Surgery  \\\n",
       "0      32                     CAD                            CAG   \n",
       "1      78  Chronic Kidney Disease                            NaN   \n",
       "2      61                     CAD                PTCA- DRUG ELUT   \n",
       "3      71                     CAD                            CAG   \n",
       "4      74                     UTI       Incisional Hernia Repair   \n",
       "...   ...                     ...                            ...   \n",
       "2603   53           VARICOSE VEIN         Peripheral Angioplasty   \n",
       "2604   68                     CAD                PTCA- DRUG ELUT   \n",
       "2605   57                   Fever  Phaco Emulsification with IOL   \n",
       "2606   54    Fever For Evaluation                            NaN   \n",
       "2607   63                   Fever                 Cystoscopy DJS   \n",
       "\n",
       "      Bipolar Hemiarthroplasty  Chemoport Removal  Hypospadias  \\\n",
       "0                            0                  0            0   \n",
       "1                            0                  0            0   \n",
       "2                            0                  0            0   \n",
       "3                            0                  0            0   \n",
       "4                            0                  0            0   \n",
       "...                        ...                ...          ...   \n",
       "2603                         0                  0            0   \n",
       "2604                         0                  0            0   \n",
       "2605                         0                  0            0   \n",
       "2606                         0                  0            0   \n",
       "2607                         0                  0            0   \n",
       "\n",
       "      Gastro jejunostomy  ORIF WITHMEDIAL MALLELOUS FIXATIONWITH FIBULA  \\\n",
       "0                      0                                              0   \n",
       "1                      0                                              0   \n",
       "2                      0                                              0   \n",
       "3                      0                                              0   \n",
       "4                      0                                              0   \n",
       "...                  ...                                            ...   \n",
       "2603                   0                                              0   \n",
       "2604                   0                                              0   \n",
       "2605                   0                                              0   \n",
       "2606                   0                                              0   \n",
       "2607                   0                                              0   \n",
       "\n",
       "      Check URS  Temporay Pacemaker Implantation (TPI)  ...  Lumbar Drain  \\\n",
       "0             0                                      0  ...             0   \n",
       "1             0                                      0  ...             0   \n",
       "2             0                                      0  ...             0   \n",
       "3             0                                      0  ...             0   \n",
       "4             0                                      0  ...             0   \n",
       "...         ...                                    ...  ...           ...   \n",
       "2603          0                                      0  ...             0   \n",
       "2604          0                                      0  ...             0   \n",
       "2605          0                                      0  ...             0   \n",
       "2606          0                                      0  ...             0   \n",
       "2607          0                                      0  ...             0   \n",
       "\n",
       "      Reconstruction of Acetabular Posterior Wall  Llap Pyeloplasty  \\\n",
       "0                                               0                 0   \n",
       "1                                               0                 0   \n",
       "2                                               0                 0   \n",
       "3                                               0                 0   \n",
       "4                                               0                 0   \n",
       "...                                           ...               ...   \n",
       "2603                                            0                 0   \n",
       "2604                                            0                 0   \n",
       "2605                                            0                 0   \n",
       "2606                                            0                 0   \n",
       "2607                                            0                 0   \n",
       "\n",
       "      Burr hole  FLAP DIVISION & INSET  Nephrorectomy  Bladder Neck Incision  \\\n",
       "0             0                      0              0                      0   \n",
       "1             0                      0              0                      0   \n",
       "2             0                      0              0                      0   \n",
       "3             0                      0              0                      0   \n",
       "4             0                      0              0                      0   \n",
       "...         ...                    ...            ...                    ...   \n",
       "2603          0                      0              0                      0   \n",
       "2604          0                      0              0                      0   \n",
       "2605          0                      0              0                      0   \n",
       "2606          0                      0              0                      0   \n",
       "2607          0                      0              0                      0   \n",
       "\n",
       "      Chemoport Insertion  LOS  Bill Amt  \n",
       "0                       0    1     17300  \n",
       "1                       0    3     89500  \n",
       "2                       0    1    143700  \n",
       "3                       0    3     15000  \n",
       "4                       0    1     96000  \n",
       "...                   ...  ...       ...  \n",
       "2603                    0    1    150600  \n",
       "2604                    0    2    157200  \n",
       "2605                    0    1      6000  \n",
       "2606                    0    1     27900  \n",
       "2607                    0    2    126300  \n",
       "\n",
       "[2608 rows x 258 columns]"
      ]
     },
     "execution_count": 298,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_frame"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 308,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Age</th>\n",
       "      <th>Diagnosis</th>\n",
       "      <th>Surgery</th>\n",
       "      <th>sur_no</th>\n",
       "      <th>LOS</th>\n",
       "      <th>Bill Amt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>32</td>\n",
       "      <td>CAD</td>\n",
       "      <td>CAG</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>17300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>78</td>\n",
       "      <td>Chronic Kidney Disease</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>89500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>61</td>\n",
       "      <td>CAD</td>\n",
       "      <td>PTCA- DRUG ELUT</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>143700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>71</td>\n",
       "      <td>CAD</td>\n",
       "      <td>CAG</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>15000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>74</td>\n",
       "      <td>UTI</td>\n",
       "      <td>Incisional Hernia Repair</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>96000</td>\n",
       "    </tr>\n",
       "    <tr>\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",
       "      <td>2603</td>\n",
       "      <td>53</td>\n",
       "      <td>VARICOSE VEIN</td>\n",
       "      <td>Peripheral Angioplasty</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>150600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2604</td>\n",
       "      <td>68</td>\n",
       "      <td>CAD</td>\n",
       "      <td>PTCA- DRUG ELUT</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>157200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2605</td>\n",
       "      <td>57</td>\n",
       "      <td>Fever</td>\n",
       "      <td>Phaco Emulsification with IOL</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>6000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2606</td>\n",
       "      <td>54</td>\n",
       "      <td>Fever For Evaluation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>27900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2607</td>\n",
       "      <td>63</td>\n",
       "      <td>Fever</td>\n",
       "      <td>Cystoscopy DJS</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>126300</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2608 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Age               Diagnosis                        Surgery  sur_no  LOS  \\\n",
       "0      32                     CAD                            CAG       1    1   \n",
       "1      78  Chronic Kidney Disease                            NaN       1    3   \n",
       "2      61                     CAD                PTCA- DRUG ELUT       1    1   \n",
       "3      71                     CAD                            CAG       1    3   \n",
       "4      74                     UTI       Incisional Hernia Repair       1    1   \n",
       "...   ...                     ...                            ...     ...  ...   \n",
       "2603   53           VARICOSE VEIN         Peripheral Angioplasty       1    1   \n",
       "2604   68                     CAD                PTCA- DRUG ELUT       1    2   \n",
       "2605   57                   Fever  Phaco Emulsification with IOL       1    1   \n",
       "2606   54    Fever For Evaluation                            NaN       1    1   \n",
       "2607   63                   Fever                 Cystoscopy DJS       1    2   \n",
       "\n",
       "      Bill Amt  \n",
       "0        17300  \n",
       "1        89500  \n",
       "2       143700  \n",
       "3        15000  \n",
       "4        96000  \n",
       "...        ...  \n",
       "2603    150600  \n",
       "2604    157200  \n",
       "2605      6000  \n",
       "2606     27900  \n",
       "2607    126300  \n",
       "\n",
       "[2608 rows x 6 columns]"
      ]
     },
     "execution_count": 308,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_frame5 = pd.read_csv('./predict_data_vit.csv')\n",
    "data_frame5\n",
    "\n",
    "Surgery = list(data_frame5['Surgery'])\n",
    "for i in range(len(Surgery)):\n",
    "    Surgery[i] = str(Surgery[i]).split(\",\")\n",
    "    Surgery[i] = len(Surgery[i])\n",
    "Surgery_no = Surgery\n",
    "\n",
    "Surgery_no\n",
    "data_frame5.insert(3,\"sur_no\",Surgery_no)\n",
    "data_frame5"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 312,
   "metadata": {},
   "outputs": [],
   "source": [
    "max_age,l_age = scale(data_frame5,'Age')\n",
    "max_los,l_los = scale(data_frame5,'LOS')\n",
    "max_bill,l_bill = scale(data_frame5,'Bill Amt')\n",
    "max_sur,l_sur = scale(data_frame5,'sur_no')\n",
    "\n",
    "data_frame5.insert(1,\"my_sur_no\",l_sur)\n",
    "data_frame5.insert(1,\"bill\",l_bill)\n",
    "data_frame5.insert(1,\"los\",l_los)\n",
    "data_frame5.insert(1,\"age\",l_age)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 313,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Age</th>\n",
       "      <th>age</th>\n",
       "      <th>los</th>\n",
       "      <th>bill</th>\n",
       "      <th>my_sur_no</th>\n",
       "      <th>Diagnosis</th>\n",
       "      <th>Surgery</th>\n",
       "      <th>sur_no</th>\n",
       "      <th>LOS</th>\n",
       "      <th>Bill Amt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>32</td>\n",
       "      <td>0.31</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.006360</td>\n",
       "      <td>0.0</td>\n",
       "      <td>CAD</td>\n",
       "      <td>CAG</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>17300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>78</td>\n",
       "      <td>0.77</td>\n",
       "      <td>0.045455</td>\n",
       "      <td>0.032904</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Chronic Kidney Disease</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>89500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>61</td>\n",
       "      <td>0.60</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.052831</td>\n",
       "      <td>0.0</td>\n",
       "      <td>CAD</td>\n",
       "      <td>PTCA- DRUG ELUT</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>143700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>71</td>\n",
       "      <td>0.70</td>\n",
       "      <td>0.045455</td>\n",
       "      <td>0.005515</td>\n",
       "      <td>0.0</td>\n",
       "      <td>CAD</td>\n",
       "      <td>CAG</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>15000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>74</td>\n",
       "      <td>0.73</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.035294</td>\n",
       "      <td>0.0</td>\n",
       "      <td>UTI</td>\n",
       "      <td>Incisional Hernia Repair</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>96000</td>\n",
       "    </tr>\n",
       "    <tr>\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",
       "      <td>2603</td>\n",
       "      <td>53</td>\n",
       "      <td>0.52</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.055368</td>\n",
       "      <td>0.0</td>\n",
       "      <td>VARICOSE VEIN</td>\n",
       "      <td>Peripheral Angioplasty</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>150600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2604</td>\n",
       "      <td>68</td>\n",
       "      <td>0.67</td>\n",
       "      <td>0.022727</td>\n",
       "      <td>0.057794</td>\n",
       "      <td>0.0</td>\n",
       "      <td>CAD</td>\n",
       "      <td>PTCA- DRUG ELUT</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>157200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2605</td>\n",
       "      <td>57</td>\n",
       "      <td>0.56</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.002206</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Fever</td>\n",
       "      <td>Phaco Emulsification with IOL</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>6000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2606</td>\n",
       "      <td>54</td>\n",
       "      <td>0.53</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.010257</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Fever For Evaluation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>27900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2607</td>\n",
       "      <td>63</td>\n",
       "      <td>0.62</td>\n",
       "      <td>0.022727</td>\n",
       "      <td>0.046434</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Fever</td>\n",
       "      <td>Cystoscopy DJS</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>126300</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2608 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Age   age       los      bill  my_sur_no               Diagnosis  \\\n",
       "0      32  0.31  0.000000  0.006360        0.0                     CAD   \n",
       "1      78  0.77  0.045455  0.032904        0.0  Chronic Kidney Disease   \n",
       "2      61  0.60  0.000000  0.052831        0.0                     CAD   \n",
       "3      71  0.70  0.045455  0.005515        0.0                     CAD   \n",
       "4      74  0.73  0.000000  0.035294        0.0                     UTI   \n",
       "...   ...   ...       ...       ...        ...                     ...   \n",
       "2603   53  0.52  0.000000  0.055368        0.0           VARICOSE VEIN   \n",
       "2604   68  0.67  0.022727  0.057794        0.0                     CAD   \n",
       "2605   57  0.56  0.000000  0.002206        0.0                   Fever   \n",
       "2606   54  0.53  0.000000  0.010257        0.0    Fever For Evaluation   \n",
       "2607   63  0.62  0.022727  0.046434        0.0                   Fever   \n",
       "\n",
       "                            Surgery  sur_no  LOS  Bill Amt  \n",
       "0                               CAG       1    1     17300  \n",
       "1                               NaN       1    3     89500  \n",
       "2                   PTCA- DRUG ELUT       1    1    143700  \n",
       "3                               CAG       1    3     15000  \n",
       "4          Incisional Hernia Repair       1    1     96000  \n",
       "...                             ...     ...  ...       ...  \n",
       "2603         Peripheral Angioplasty       1    1    150600  \n",
       "2604                PTCA- DRUG ELUT       1    2    157200  \n",
       "2605  Phaco Emulsification with IOL       1    1      6000  \n",
       "2606                            NaN       1    1     27900  \n",
       "2607                 Cystoscopy DJS       1    2    126300  \n",
       "\n",
       "[2608 rows x 10 columns]"
      ]
     },
     "execution_count": 313,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_frame5"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 314,
   "metadata": {},
   "outputs": [],
   "source": [
    "data_frame5.to_csv('data_frame_final_new.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "abc = str(set(sur)).replace(\"'\",\"\")\n",
    "abc = abc.replace(\" \",\"\")\n",
    "\n",
    "xyz = str(Diagnosis).replace(\"'\",\"\")\n",
    "xyz = xyz.replace(\" \",\"\")\n",
    "xyz"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    " sklearn.preprocessing as preprocessing"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "enc = preprocessing.OrdinalEncoder()\n",
    "enc.fit(diag_fin)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "enc.transform(diag_fin)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "oenc = preprocessing.OneHotEncoder(categories=sur)\n",
    "oenc.fit(sur_fin)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "oenc.transform(sur)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 272,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[[24, 'PPI'],\n",
       " [130, 'AV Fistula'],\n",
       " [131, 'CABG'],\n",
       " [140, 'Tracheostomy'],\n",
       " [144, 'Circumcision'],\n",
       " [172, 'Laparotomy'],\n",
       " [177, 'LSCS'],\n",
       " [207, 'Thyroidectomy'],\n",
       " [212, 'Total Knee Replacement']]"
      ]
     },
     "execution_count": 272,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "l=[]\n",
    "for i in range(len(Diagnosis_unique)):\n",
    "    for j in range(len(Surgery_unique)):\n",
    "        if(Diagnosis_unique[i]==Surgery_unique[j]):\n",
    "            l.append([i,Diagnosis_unique[i]])\n",
    "l"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "import sklearn as sk\n",
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>age</th>\n",
       "      <th>los</th>\n",
       "      <th>bill</th>\n",
       "      <th>Heamaturia</th>\n",
       "      <th>MAXILLARY FRACTURE</th>\n",
       "      <th>FRACTURE FEMUR</th>\n",
       "      <th>IHD,ACS,CAD</th>\n",
       "      <th>Urinary incontinence</th>\n",
       "      <th>Antenatal Case</th>\n",
       "      <th>Complete Heart Block</th>\n",
       "      <th>...</th>\n",
       "      <th>DHS</th>\n",
       "      <th>Lumbar Drain</th>\n",
       "      <th>Reconstruction of Acetabular Posterior Wall</th>\n",
       "      <th>Llap Pyeloplasty</th>\n",
       "      <th>Burr hole</th>\n",
       "      <th>FLAP DIVISION &amp; INSET</th>\n",
       "      <th>Nephrorectomy</th>\n",
       "      <th>Bladder Neck Incision</th>\n",
       "      <th>Chemoport Insertion</th>\n",
       "      <th>my_sur_no</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>0.31</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.006360</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>0.77</td>\n",
       "      <td>0.045455</td>\n",
       "      <td>0.032904</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>0.60</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.052831</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>0.70</td>\n",
       "      <td>0.045455</td>\n",
       "      <td>0.005515</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>0.73</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.035294</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2603</td>\n",
       "      <td>0.52</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.055368</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2604</td>\n",
       "      <td>0.67</td>\n",
       "      <td>0.022727</td>\n",
       "      <td>0.057794</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2605</td>\n",
       "      <td>0.56</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.002206</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2606</td>\n",
       "      <td>0.53</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.010257</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2607</td>\n",
       "      <td>0.62</td>\n",
       "      <td>0.022727</td>\n",
       "      <td>0.046434</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2608 rows × 503 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       age       los      bill  Heamaturia  MAXILLARY FRACTURE  \\\n",
       "0     0.31  0.000000  0.006360           0                   0   \n",
       "1     0.77  0.045455  0.032904           0                   0   \n",
       "2     0.60  0.000000  0.052831           0                   0   \n",
       "3     0.70  0.045455  0.005515           0                   0   \n",
       "4     0.73  0.000000  0.035294           0                   0   \n",
       "...    ...       ...       ...         ...                 ...   \n",
       "2603  0.52  0.000000  0.055368           0                   0   \n",
       "2604  0.67  0.022727  0.057794           0                   0   \n",
       "2605  0.56  0.000000  0.002206           0                   0   \n",
       "2606  0.53  0.000000  0.010257           0                   0   \n",
       "2607  0.62  0.022727  0.046434           0                   0   \n",
       "\n",
       "      FRACTURE FEMUR  IHD,ACS,CAD  Urinary incontinence  Antenatal Case  \\\n",
       "0                  0            0                     0               0   \n",
       "1                  0            0                     0               0   \n",
       "2                  0            0                     0               0   \n",
       "3                  0            0                     0               0   \n",
       "4                  0            0                     0               0   \n",
       "...              ...          ...                   ...             ...   \n",
       "2603               0            0                     0               0   \n",
       "2604               0            0                     0               0   \n",
       "2605               0            0                     0               0   \n",
       "2606               0            0                     0               0   \n",
       "2607               0            0                     0               0   \n",
       "\n",
       "      Complete Heart Block  ...  DHS  Lumbar Drain  \\\n",
       "0                        0  ...    0             0   \n",
       "1                        0  ...    0             0   \n",
       "2                        0  ...    0             0   \n",
       "3                        0  ...    0             0   \n",
       "4                        0  ...    0             0   \n",
       "...                    ...  ...  ...           ...   \n",
       "2603                     0  ...    0             0   \n",
       "2604                     0  ...    0             0   \n",
       "2605                     0  ...    0             0   \n",
       "2606                     0  ...    0             0   \n",
       "2607                     0  ...    0             0   \n",
       "\n",
       "      Reconstruction of Acetabular Posterior Wall  Llap Pyeloplasty  \\\n",
       "0                                               0                 0   \n",
       "1                                               0                 0   \n",
       "2                                               0                 0   \n",
       "3                                               0                 0   \n",
       "4                                               0                 0   \n",
       "...                                           ...               ...   \n",
       "2603                                            0                 0   \n",
       "2604                                            0                 0   \n",
       "2605                                            0                 0   \n",
       "2606                                            0                 0   \n",
       "2607                                            0                 0   \n",
       "\n",
       "      Burr hole  FLAP DIVISION & INSET  Nephrorectomy  Bladder Neck Incision  \\\n",
       "0             0                      0              0                      0   \n",
       "1             0                      0              0                      0   \n",
       "2             0                      0              0                      0   \n",
       "3             0                      0              0                      0   \n",
       "4             0                      0              0                      0   \n",
       "...         ...                    ...            ...                    ...   \n",
       "2603          0                      0              0                      0   \n",
       "2604          0                      0              0                      0   \n",
       "2605          0                      0              0                      0   \n",
       "2606          0                      0              0                      0   \n",
       "2607          0                      0              0                      0   \n",
       "\n",
       "      Chemoport Insertion  my_sur_no  \n",
       "0                       0        0.0  \n",
       "1                       0        0.0  \n",
       "2                       0        0.0  \n",
       "3                       0        0.0  \n",
       "4                       0        0.0  \n",
       "...                   ...        ...  \n",
       "2603                    0        0.0  \n",
       "2604                    0        0.0  \n",
       "2605                    0        0.0  \n",
       "2606                    0        0.0  \n",
       "2607                    0        0.0  \n",
       "\n",
       "[2608 rows x 503 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_frame = pd.read_csv('./data_frame_final.csv')\n",
    "data_frame"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.model_selection import train_test_split\n",
    "\n",
    "train, test = train_test_split(data_frame, test_size=0.05)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "y_train = np.array(train['bill'])\n",
    "y_test = np.array(test['bill'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "x_train = np.array(train)\n",
    "x_train = np.delete(x_train,2,1)\n",
    "x_test = np.array(test)\n",
    "x_test = np.delete(x_test,2,1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.neural_network import MLPRegressor"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "model = MLPRegressor(activation='tanh', alpha=0.06, batch_size='auto',\n",
    "                      beta_1=0.9, beta_2=0.999, early_stopping=False,\n",
    "                      epsilon=1e-08, hidden_layer_sizes=(200,),\n",
    "                      learning_rate='constant', learning_rate_init=0.01,\n",
    "                      max_iter=600, momentum=0.6, n_iter_no_change=10,\n",
    "                      nesterovs_momentum=True, power_t=0.5, random_state=1,\n",
    "                      shuffle=True, solver='adam', tol=0.0001,\n",
    "                      validation_fraction=0.1, verbose=False, warm_start=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "MLPRegressor(activation='tanh', alpha=0.06, batch_size='auto', beta_1=0.9,\n",
       "             beta_2=0.999, early_stopping=False, epsilon=1e-08,\n",
       "             hidden_layer_sizes=(200,), learning_rate='constant',\n",
       "             learning_rate_init=0.01, max_iter=600, momentum=0.6,\n",
       "             n_iter_no_change=10, nesterovs_momentum=True, power_t=0.5,\n",
       "             random_state=1, shuffle=True, solver='adam', tol=0.0001,\n",
       "             validation_fraction=0.1, verbose=False, warm_start=False)"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "model.fit(x_train,y_train)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.7947021185822472"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "model.score(x_test,y_test)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Accuracy obtained ~ 80% (Exact-79.4702)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "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.7.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}