K_means.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['2017.csv', '.~lock.Dataset.csv#', 'kmeans1.xlsx', 'Dataset.csv']"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import os\n",
    "os.chdir('/home/tapas/data/')\n",
    "os.listdir(\".\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>ID Tag</th>\n",
       "      <th>Model</th>\n",
       "      <th>WO count</th>\n",
       "      <th>AVG Labor</th>\n",
       "      <th>Labor Cost</th>\n",
       "      <th>No Problem</th>\n",
       "      <th>Avg Cost</th>\n",
       "      <th>Travel</th>\n",
       "      <th>Travel Cost</th>\n",
       "      <th>Department</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>MYLAB ALPHA</td>\n",
       "      <td>10</td>\n",
       "      <td>43.333333</td>\n",
       "      <td>54.166667</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>CARDIOVASCULAR IMAGING</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>ASPEN</td>\n",
       "      <td>1</td>\n",
       "      <td>24.000000</td>\n",
       "      <td>30.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>CARDIOVASCULAR IMAGING</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>IE33</td>\n",
       "      <td>4</td>\n",
       "      <td>210.000000</td>\n",
       "      <td>262.500000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>CARDIOVASCULAR IMAGING</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>BVI 9400</td>\n",
       "      <td>9</td>\n",
       "      <td>54.666667</td>\n",
       "      <td>68.333333</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>REHAB CENTER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>BVI 9400</td>\n",
       "      <td>1</td>\n",
       "      <td>102.000000</td>\n",
       "      <td>127.500000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>REHAB CENTER</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   ID Tag        Model  WO count   AVG Labor  Labor Cost  No Problem  \\\n",
       "0       1  MYLAB ALPHA        10   43.333333   54.166667           0   \n",
       "1       2        ASPEN         1   24.000000   30.000000           0   \n",
       "2       3         IE33         4  210.000000  262.500000           0   \n",
       "3       4     BVI 9400         9   54.666667   68.333333           1   \n",
       "4       5     BVI 9400         1  102.000000  127.500000           0   \n",
       "\n",
       "   Avg Cost  Travel   Travel Cost              Department  \n",
       "0       0.0      2.0        150.0  CARDIOVASCULAR IMAGING  \n",
       "1       0.0      2.0        150.0  CARDIOVASCULAR IMAGING  \n",
       "2       0.0      2.0        150.0  CARDIOVASCULAR IMAGING  \n",
       "3       0.0      2.0        150.0            REHAB CENTER  \n",
       "4       0.0      2.0        150.0            REHAB CENTER  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_excel('kmeans1.xlsx')\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>WO count</th>\n",
       "      <th>AVG Labor</th>\n",
       "      <th>Labor Cost</th>\n",
       "      <th>No Problem</th>\n",
       "      <th>Avg Cost</th>\n",
       "      <th>Travel</th>\n",
       "      <th>Travel Cost</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>10</td>\n",
       "      <td>43.333333</td>\n",
       "      <td>54.166667</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>150.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>24.000000</td>\n",
       "      <td>30.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>150.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4</td>\n",
       "      <td>210.000000</td>\n",
       "      <td>262.500000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>150.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>9</td>\n",
       "      <td>54.666667</td>\n",
       "      <td>68.333333</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>150.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>102.000000</td>\n",
       "      <td>127.500000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>150.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   WO count   AVG Labor  Labor Cost  No Problem  Avg Cost  Travel   \\\n",
       "0        10   43.333333   54.166667           0       0.0      2.0   \n",
       "1         1   24.000000   30.000000           0       0.0      2.0   \n",
       "2         4  210.000000  262.500000           0       0.0      2.0   \n",
       "3         9   54.666667   68.333333           1       0.0      2.0   \n",
       "4         1  102.000000  127.500000           0       0.0      2.0   \n",
       "\n",
       "   Travel Cost  \n",
       "0        150.0  \n",
       "1        150.0  \n",
       "2        150.0  \n",
       "3        150.0  \n",
       "4        150.0  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1 = df.drop([\"ID Tag\", \"Model\", \"Department\"], axis = 1)\n",
    "df1.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.cluster import KMeans\n",
    "km = KMeans(n_clusters=4, init='k-means++', n_init=10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "KMeans(algorithm='auto', copy_x=True, init='k-means++', max_iter=300,\n",
       "    n_clusters=4, n_init=10, n_jobs=1, precompute_distances='auto',\n",
       "    random_state=None, tol=0.0001, verbose=0)"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "km.fit(df1)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([0, 0, 3, 0, 3, 3, 2, 3, 0, 3, 3, 3, 0, 3, 2, 0, 3, 0, 3, 0, 0, 0,\n",
       "       3, 0, 0, 3, 2, 3, 3, 2, 3, 0, 3, 3, 3, 2, 3, 0, 3, 0, 3, 3, 3, 0,\n",
       "       3, 0, 3, 3, 0, 3, 0, 3, 3, 0, 3, 2, 0, 0, 3, 3, 3, 3, 0, 0, 3, 0,\n",
       "       3, 3, 3, 0, 0, 0, 3, 3, 3, 0, 3, 3, 2, 3, 0, 0, 0, 3, 0, 0, 3, 3,\n",
       "       3, 0, 3, 0, 0, 0, 0, 0, 3, 1, 0, 0, 2, 3, 0, 3, 3, 3, 0, 0, 0, 3,\n",
       "       3, 0, 3, 3, 2, 3, 0, 0, 0, 3, 3, 3, 3, 0, 2, 3, 0, 3, 3, 0, 3, 0,\n",
       "       3, 0, 0, 0, 0, 0, 3, 0, 3, 3, 0, 3, 3, 0, 0, 0, 3, 3, 0, 3, 0, 0,\n",
       "       3, 3, 3, 3, 3, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0,\n",
       "       0, 3, 0, 3, 0, 0, 0, 0, 3, 3, 3, 3, 0, 3, 0, 0, 0, 0, 0, 3],\n",
       "      dtype=int32)"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "x = km.fit_predict(df1)\n",
    "x"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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>ID Tag</th>\n",
       "      <th>Model</th>\n",
       "      <th>WO count</th>\n",
       "      <th>AVG Labor</th>\n",
       "      <th>Labor Cost</th>\n",
       "      <th>No Problem</th>\n",
       "      <th>Avg Cost</th>\n",
       "      <th>Travel</th>\n",
       "      <th>Travel Cost</th>\n",
       "      <th>Department</th>\n",
       "      <th>Cluster</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>MYLAB ALPHA</td>\n",
       "      <td>10</td>\n",
       "      <td>43.333333</td>\n",
       "      <td>54.166667</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>CARDIOVASCULAR IMAGING</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>ASPEN</td>\n",
       "      <td>1</td>\n",
       "      <td>24.000000</td>\n",
       "      <td>30.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>CARDIOVASCULAR IMAGING</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>IE33</td>\n",
       "      <td>4</td>\n",
       "      <td>210.000000</td>\n",
       "      <td>262.500000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>CARDIOVASCULAR IMAGING</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>BVI 9400</td>\n",
       "      <td>9</td>\n",
       "      <td>54.666667</td>\n",
       "      <td>68.333333</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>REHAB CENTER</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>BVI 9400</td>\n",
       "      <td>1</td>\n",
       "      <td>102.000000</td>\n",
       "      <td>127.500000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>REHAB CENTER</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   ID Tag        Model  WO count   AVG Labor  Labor Cost  No Problem  \\\n",
       "0       1  MYLAB ALPHA        10   43.333333   54.166667           0   \n",
       "1       2        ASPEN         1   24.000000   30.000000           0   \n",
       "2       3         IE33         4  210.000000  262.500000           0   \n",
       "3       4     BVI 9400         9   54.666667   68.333333           1   \n",
       "4       5     BVI 9400         1  102.000000  127.500000           0   \n",
       "\n",
       "   Avg Cost  Travel   Travel Cost              Department  Cluster  \n",
       "0       0.0      2.0        150.0  CARDIOVASCULAR IMAGING        0  \n",
       "1       0.0      2.0        150.0  CARDIOVASCULAR IMAGING        0  \n",
       "2       0.0      2.0        150.0  CARDIOVASCULAR IMAGING        3  \n",
       "3       0.0      2.0        150.0            REHAB CENTER        0  \n",
       "4       0.0      2.0        150.0            REHAB CENTER        3  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[\"Cluster\"]= x\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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>ID Tag</th>\n",
       "      <th>Model</th>\n",
       "      <th>WO count</th>\n",
       "      <th>AVG Labor</th>\n",
       "      <th>Labor Cost</th>\n",
       "      <th>No Problem</th>\n",
       "      <th>Avg Cost</th>\n",
       "      <th>Travel</th>\n",
       "      <th>Travel Cost</th>\n",
       "      <th>Department</th>\n",
       "      <th>Cluster</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>MYLAB ALPHA</td>\n",
       "      <td>10</td>\n",
       "      <td>43.333333</td>\n",
       "      <td>54.166667</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>150.000000</td>\n",
       "      <td>CARDIOVASCULAR IMAGING</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>124</td>\n",
       "      <td>Z.ONE ULTRA</td>\n",
       "      <td>6</td>\n",
       "      <td>66.000000</td>\n",
       "      <td>82.500000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>CARDIAC NON-INVASIVE</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>127</td>\n",
       "      <td>IE33</td>\n",
       "      <td>16</td>\n",
       "      <td>81.000000</td>\n",
       "      <td>101.250000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.562500</td>\n",
       "      <td>117.187500</td>\n",
       "      <td>CARDIAC NON-INVASIVE</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>66</td>\n",
       "      <td>HD15</td>\n",
       "      <td>4</td>\n",
       "      <td>67.500000</td>\n",
       "      <td>84.375000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>150.000000</td>\n",
       "      <td>EKG</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>130</td>\n",
       "      <td>IU22</td>\n",
       "      <td>7</td>\n",
       "      <td>78.857143</td>\n",
       "      <td>98.571429</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>VASCULAR LABORATORY</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>64</td>\n",
       "      <td>M-TURBO</td>\n",
       "      <td>2</td>\n",
       "      <td>60.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>150.000000</td>\n",
       "      <td>ER</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>63</td>\n",
       "      <td>ACUSON S2000</td>\n",
       "      <td>16</td>\n",
       "      <td>85.600000</td>\n",
       "      <td>107.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>150.000000</td>\n",
       "      <td>BREAST CENTER</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>132</td>\n",
       "      <td>S-CATH</td>\n",
       "      <td>1</td>\n",
       "      <td>90.000000</td>\n",
       "      <td>112.500000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>CATH LAB</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>134</td>\n",
       "      <td>X300</td>\n",
       "      <td>7</td>\n",
       "      <td>79.714286</td>\n",
       "      <td>99.642857</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>CARDIAC ELECTROPHYSIOLOGY</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>135</td>\n",
       "      <td>LOGIQ E9</td>\n",
       "      <td>5</td>\n",
       "      <td>97.200000</td>\n",
       "      <td>121.500000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>RADIOLOGY - MAMMOGRAPHY</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>136</td>\n",
       "      <td>S NERVE</td>\n",
       "      <td>2</td>\n",
       "      <td>45.000000</td>\n",
       "      <td>56.250000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>ANESTHESIA</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>58</td>\n",
       "      <td>IE33</td>\n",
       "      <td>1</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>150.000000</td>\n",
       "      <td>CARDIOVASCULAR IMAGING</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>57</td>\n",
       "      <td>X300</td>\n",
       "      <td>1</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>7.500000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>150.000000</td>\n",
       "      <td>CARD ASSOC</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>137</td>\n",
       "      <td>S NERVE</td>\n",
       "      <td>2</td>\n",
       "      <td>60.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>ANESTHESIA</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>138</td>\n",
       "      <td>S NERVE</td>\n",
       "      <td>2</td>\n",
       "      <td>45.000000</td>\n",
       "      <td>56.250000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>ANESTHESIA</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>54</td>\n",
       "      <td>IE33</td>\n",
       "      <td>1</td>\n",
       "      <td>60.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>150.000000</td>\n",
       "      <td>CARDIOVASCULAR IMAGING</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>140</td>\n",
       "      <td>IE33</td>\n",
       "      <td>2</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>93.750000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>ANESTHESIA</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>143</td>\n",
       "      <td>INVENIA ABUS</td>\n",
       "      <td>1</td>\n",
       "      <td>90.000000</td>\n",
       "      <td>112.500000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>RADIOLOGY - MAMMOGRAPHY</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>51</td>\n",
       "      <td>HD11XE</td>\n",
       "      <td>1</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>7.500000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>150.000000</td>\n",
       "      <td>ADVANCED CARDIOLOGY</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>146</td>\n",
       "      <td>FLEX FOCUS 800</td>\n",
       "      <td>1</td>\n",
       "      <td>60.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>OPERATING ROOM</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>119</td>\n",
       "      <td>BVI 9400</td>\n",
       "      <td>1</td>\n",
       "      <td>18.000000</td>\n",
       "      <td>22.500000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>CLINICAL ENGINEERING DEPT</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>70</td>\n",
       "      <td>EDGE</td>\n",
       "      <td>1</td>\n",
       "      <td>60.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>INTENSIVE CARE UNIT</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>71</td>\n",
       "      <td>S-ICU</td>\n",
       "      <td>1</td>\n",
       "      <td>36.000000</td>\n",
       "      <td>45.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>PEDIATRIC INTENSIVE CARE</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>72</td>\n",
       "      <td>2270969</td>\n",
       "      <td>8</td>\n",
       "      <td>79.500000</td>\n",
       "      <td>99.375000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>LABOR AND DELIVERY</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>92</td>\n",
       "      <td>M-TURBO</td>\n",
       "      <td>7</td>\n",
       "      <td>95.142857</td>\n",
       "      <td>118.928571</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>EMERGENCY DEPARTMENT</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>95</td>\n",
       "      <td>LOGIQ S6</td>\n",
       "      <td>40</td>\n",
       "      <td>75.600000</td>\n",
       "      <td>94.500000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>RADIOLOGY - MAMMOGRAPHY</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>90</td>\n",
       "      <td>S SERIES</td>\n",
       "      <td>4</td>\n",
       "      <td>48.000000</td>\n",
       "      <td>60.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>8.125000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>CLINIC - AMBULATORY SERV</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>96</td>\n",
       "      <td>LOGIQ P6</td>\n",
       "      <td>22</td>\n",
       "      <td>69.545455</td>\n",
       "      <td>86.931818</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>RADIOLOGY - MAMMOGRAPHY</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194</th>\n",
       "      <td>195</td>\n",
       "      <td>FLEX FOCUS 500</td>\n",
       "      <td>1</td>\n",
       "      <td>90.000000</td>\n",
       "      <td>112.500000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>ENDOSCOPY</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>99</td>\n",
       "      <td>S SERIES</td>\n",
       "      <td>10</td>\n",
       "      <td>100.800000</td>\n",
       "      <td>126.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>ANESTHESIA</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>87</td>\n",
       "      <td>SEQUOIA 512</td>\n",
       "      <td>39</td>\n",
       "      <td>110.769231</td>\n",
       "      <td>138.461538</td>\n",
       "      <td>2</td>\n",
       "      <td>54.974359</td>\n",
       "      <td>1.179487</td>\n",
       "      <td>88.461538</td>\n",
       "      <td>PEDIATRIC CARDIOLOGY</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>88</td>\n",
       "      <td>LOGIQ E9</td>\n",
       "      <td>52</td>\n",
       "      <td>112.269231</td>\n",
       "      <td>140.336538</td>\n",
       "      <td>0</td>\n",
       "      <td>18.615385</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>ULTRASOUND</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>97</td>\n",
       "      <td>HI VISION 900</td>\n",
       "      <td>9</td>\n",
       "      <td>106.666667</td>\n",
       "      <td>133.333333</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>ENDOSCOPY SUITE</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>78</td>\n",
       "      <td>VIVID 7</td>\n",
       "      <td>80</td>\n",
       "      <td>104.700000</td>\n",
       "      <td>130.875000</td>\n",
       "      <td>4</td>\n",
       "      <td>46.976625</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>PEDIATRIC CARDIOLOGY</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>121</td>\n",
       "      <td>IE33</td>\n",
       "      <td>67</td>\n",
       "      <td>118.208955</td>\n",
       "      <td>147.761194</td>\n",
       "      <td>3</td>\n",
       "      <td>9.507463</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>CARDIAC NON-INVASIVE</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>122</td>\n",
       "      <td>IE33</td>\n",
       "      <td>70</td>\n",
       "      <td>124.285714</td>\n",
       "      <td>155.357143</td>\n",
       "      <td>3</td>\n",
       "      <td>163.085714</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>CARDIAC NON-INVASIVE</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>123</td>\n",
       "      <td>IE33</td>\n",
       "      <td>19</td>\n",
       "      <td>116.842105</td>\n",
       "      <td>146.052632</td>\n",
       "      <td>0</td>\n",
       "      <td>2.434737</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>CARDIAC NON-INVASIVE</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>91</td>\n",
       "      <td>SSA-550A-2</td>\n",
       "      <td>10</td>\n",
       "      <td>123.000000</td>\n",
       "      <td>153.750000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>EMERGENCY DEPARTMENT</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>145</td>\n",
       "      <td>EPIQ 7C</td>\n",
       "      <td>7</td>\n",
       "      <td>182.571429</td>\n",
       "      <td>228.214286</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>CARDIAC NON-INVASIVE</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>144</td>\n",
       "      <td>VENUE 50</td>\n",
       "      <td>5</td>\n",
       "      <td>126.000000</td>\n",
       "      <td>157.500000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>X-RAY SPECIAL PROCEDURES</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>52</td>\n",
       "      <td>IE33</td>\n",
       "      <td>3</td>\n",
       "      <td>124.000000</td>\n",
       "      <td>155.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>66.666667</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>150.000000</td>\n",
       "      <td>CARDIOVASCULAR IMAGING</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>142</td>\n",
       "      <td>BK3000</td>\n",
       "      <td>1</td>\n",
       "      <td>120.000000</td>\n",
       "      <td>150.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>EMERGENCY DEPARTMENT</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>141</td>\n",
       "      <td>SENSILASE PAD-IQ</td>\n",
       "      <td>1</td>\n",
       "      <td>120.000000</td>\n",
       "      <td>150.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>VASCULAR LABORATORY</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>53</td>\n",
       "      <td>IE33</td>\n",
       "      <td>3</td>\n",
       "      <td>188.000000</td>\n",
       "      <td>235.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>150.000000</td>\n",
       "      <td>CARDIOVASCULAR IMAGING</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>139</td>\n",
       "      <td>CORE MOBILE</td>\n",
       "      <td>2</td>\n",
       "      <td>105.000000</td>\n",
       "      <td>131.250000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>OPERATING ROOM</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>55</td>\n",
       "      <td>IE33</td>\n",
       "      <td>3</td>\n",
       "      <td>180.000000</td>\n",
       "      <td>225.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>150.000000</td>\n",
       "      <td>MEDICAL INST</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>59</td>\n",
       "      <td>VIVID E9</td>\n",
       "      <td>2</td>\n",
       "      <td>255.000000</td>\n",
       "      <td>318.750000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>150.000000</td>\n",
       "      <td>CARDIAC IMAGING</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>60</td>\n",
       "      <td>LOGIQ S8</td>\n",
       "      <td>23</td>\n",
       "      <td>129.130435</td>\n",
       "      <td>161.413043</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>150.000000</td>\n",
       "      <td>ULTRASOUND</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>61</td>\n",
       "      <td>ANTARES 5936518</td>\n",
       "      <td>25</td>\n",
       "      <td>127.200000</td>\n",
       "      <td>159.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>150.000000</td>\n",
       "      <td>ULTRASOUND</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>133</td>\n",
       "      <td>LOGIQ E9</td>\n",
       "      <td>15</td>\n",
       "      <td>110.000000</td>\n",
       "      <td>137.500000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>ULTRASOUND</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>62</td>\n",
       "      <td>ANTARES 5936518</td>\n",
       "      <td>15</td>\n",
       "      <td>142.000000</td>\n",
       "      <td>177.500000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>150.000000</td>\n",
       "      <td>ULTRASOUND</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>131</td>\n",
       "      <td>EUB-5500</td>\n",
       "      <td>11</td>\n",
       "      <td>103.636364</td>\n",
       "      <td>129.545455</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>ENDOSCOPY SUITE</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>65</td>\n",
       "      <td>IE33</td>\n",
       "      <td>11</td>\n",
       "      <td>94.909091</td>\n",
       "      <td>118.636364</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>150.000000</td>\n",
       "      <td>EKG</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>129</td>\n",
       "      <td>IE33</td>\n",
       "      <td>10</td>\n",
       "      <td>108.000000</td>\n",
       "      <td>135.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.300000</td>\n",
       "      <td>97.500000</td>\n",
       "      <td>CARDIAC NON-INVASIVE</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>128</td>\n",
       "      <td>IE33</td>\n",
       "      <td>17</td>\n",
       "      <td>111.882353</td>\n",
       "      <td>139.852941</td>\n",
       "      <td>1</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.529412</td>\n",
       "      <td>114.705882</td>\n",
       "      <td>CARDIAC NON-INVASIVE</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>67</td>\n",
       "      <td>LOGIQ E</td>\n",
       "      <td>5</td>\n",
       "      <td>115.200000</td>\n",
       "      <td>144.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>150.000000</td>\n",
       "      <td>OPERATING ROOM</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>126</td>\n",
       "      <td>IE33</td>\n",
       "      <td>17</td>\n",
       "      <td>98.470588</td>\n",
       "      <td>123.088235</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.588235</td>\n",
       "      <td>119.117647</td>\n",
       "      <td>CARDIAC NON-INVASIVE</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>68</td>\n",
       "      <td>LOGIQ E9</td>\n",
       "      <td>3</td>\n",
       "      <td>110.000000</td>\n",
       "      <td>137.500000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>150.000000</td>\n",
       "      <td>BREAST CENTER</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>47</td>\n",
       "      <td>VOLUSON E8 EXPERT</td>\n",
       "      <td>8</td>\n",
       "      <td>97.500000</td>\n",
       "      <td>121.875000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>150.000000</td>\n",
       "      <td>Maternal Fetal Medicine</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>196</td>\n",
       "      <td>EPIQ 7C</td>\n",
       "      <td>4</td>\n",
       "      <td>288.000000</td>\n",
       "      <td>360.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>PEDIATRIC CARDIOLOGY</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>196 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     ID Tag              Model  WO count   AVG Labor  Labor Cost  No Problem  \\\n",
       "0         1        MYLAB ALPHA        10   43.333333   54.166667           0   \n",
       "123     124        Z.ONE ULTRA         6   66.000000   82.500000           0   \n",
       "126     127               IE33        16   81.000000  101.250000           0   \n",
       "65       66               HD15         4   67.500000   84.375000           0   \n",
       "129     130               IU22         7   78.857143   98.571429           0   \n",
       "63       64            M-TURBO         2   60.000000   75.000000           0   \n",
       "62       63       ACUSON S2000        16   85.600000  107.000000           0   \n",
       "131     132             S-CATH         1   90.000000  112.500000           0   \n",
       "133     134               X300         7   79.714286   99.642857           0   \n",
       "134     135           LOGIQ E9         5   97.200000  121.500000           0   \n",
       "135     136            S NERVE         2   45.000000   56.250000           0   \n",
       "57       58               IE33         1    0.000000    0.000000           0   \n",
       "56       57               X300         1    6.000000    7.500000           0   \n",
       "136     137            S NERVE         2   60.000000   75.000000           0   \n",
       "137     138            S NERVE         2   45.000000   56.250000           0   \n",
       "53       54               IE33         1   60.000000   75.000000           0   \n",
       "139     140               IE33         2   75.000000   93.750000           0   \n",
       "142     143       INVENIA ABUS         1   90.000000  112.500000           0   \n",
       "50       51             HD11XE         1    6.000000    7.500000           0   \n",
       "145     146     FLEX FOCUS 800         1   60.000000   75.000000           0   \n",
       "118     119           BVI 9400         1   18.000000   22.500000           0   \n",
       "69       70               EDGE         1   60.000000   75.000000           0   \n",
       "70       71              S-ICU         1   36.000000   45.000000           0   \n",
       "71       72            2270969         8   79.500000   99.375000           0   \n",
       "91       92            M-TURBO         7   95.142857  118.928571           0   \n",
       "94       95           LOGIQ S6        40   75.600000   94.500000           0   \n",
       "89       90           S SERIES         4   48.000000   60.000000           0   \n",
       "95       96           LOGIQ P6        22   69.545455   86.931818           0   \n",
       "194     195     FLEX FOCUS 500         1   90.000000  112.500000           0   \n",
       "98       99           S SERIES        10  100.800000  126.000000           0   \n",
       "..      ...                ...       ...         ...         ...         ...   \n",
       "86       87        SEQUOIA 512        39  110.769231  138.461538           2   \n",
       "87       88           LOGIQ E9        52  112.269231  140.336538           0   \n",
       "96       97      HI VISION 900         9  106.666667  133.333333           0   \n",
       "77       78            VIVID 7        80  104.700000  130.875000           4   \n",
       "120     121               IE33        67  118.208955  147.761194           3   \n",
       "121     122               IE33        70  124.285714  155.357143           3   \n",
       "122     123               IE33        19  116.842105  146.052632           0   \n",
       "90       91         SSA-550A-2        10  123.000000  153.750000           0   \n",
       "144     145            EPIQ 7C         7  182.571429  228.214286           0   \n",
       "143     144           VENUE 50         5  126.000000  157.500000           0   \n",
       "51       52               IE33         3  124.000000  155.000000           0   \n",
       "141     142             BK3000         1  120.000000  150.000000           0   \n",
       "140     141   SENSILASE PAD-IQ         1  120.000000  150.000000           0   \n",
       "52       53               IE33         3  188.000000  235.000000           0   \n",
       "138     139        CORE MOBILE         2  105.000000  131.250000           0   \n",
       "54       55               IE33         3  180.000000  225.000000           0   \n",
       "58       59           VIVID E9         2  255.000000  318.750000           0   \n",
       "59       60           LOGIQ S8        23  129.130435  161.413043           0   \n",
       "60       61    ANTARES 5936518        25  127.200000  159.000000           0   \n",
       "132     133           LOGIQ E9        15  110.000000  137.500000           0   \n",
       "61       62    ANTARES 5936518        15  142.000000  177.500000           0   \n",
       "130     131           EUB-5500        11  103.636364  129.545455           0   \n",
       "64       65               IE33        11   94.909091  118.636364           0   \n",
       "128     129               IE33        10  108.000000  135.000000           0   \n",
       "127     128               IE33        17  111.882353  139.852941           1   \n",
       "66       67            LOGIQ E         5  115.200000  144.000000           0   \n",
       "125     126               IE33        17   98.470588  123.088235           0   \n",
       "67       68           LOGIQ E9         3  110.000000  137.500000           0   \n",
       "46       47  VOLUSON E8 EXPERT         8   97.500000  121.875000           0   \n",
       "195     196            EPIQ 7C         4  288.000000  360.000000           0   \n",
       "\n",
       "       Avg Cost   Travel   Travel Cost                 Department  Cluster  \n",
       "0      0.000000  2.000000   150.000000     CARDIOVASCULAR IMAGING        0  \n",
       "123    0.000000  1.000000    75.000000       CARDIAC NON-INVASIVE        0  \n",
       "126    0.000000  1.562500   117.187500       CARDIAC NON-INVASIVE        0  \n",
       "65     0.000000  2.000000   150.000000                        EKG        0  \n",
       "129    0.000000  1.000000    75.000000        VASCULAR LABORATORY        0  \n",
       "63     0.000000  2.000000   150.000000                         ER        0  \n",
       "62     0.000000  2.000000   150.000000              BREAST CENTER        0  \n",
       "131    0.000000  1.000000    75.000000                   CATH LAB        0  \n",
       "133    0.000000  1.000000    75.000000  CARDIAC ELECTROPHYSIOLOGY        0  \n",
       "134    0.000000  1.000000    75.000000    RADIOLOGY - MAMMOGRAPHY        0  \n",
       "135    0.000000  1.000000    75.000000                 ANESTHESIA        0  \n",
       "57     0.000000  2.000000   150.000000     CARDIOVASCULAR IMAGING        0  \n",
       "56     0.000000  2.000000   150.000000                 CARD ASSOC        0  \n",
       "136    0.000000  1.000000    75.000000                 ANESTHESIA        0  \n",
       "137    0.000000  1.000000    75.000000                 ANESTHESIA        0  \n",
       "53     0.000000  2.000000   150.000000     CARDIOVASCULAR IMAGING        0  \n",
       "139    0.000000  1.000000    75.000000                 ANESTHESIA        0  \n",
       "142    0.000000  1.000000    75.000000    RADIOLOGY - MAMMOGRAPHY        0  \n",
       "50     0.000000  2.000000   150.000000        ADVANCED CARDIOLOGY        0  \n",
       "145    0.000000  1.000000    75.000000             OPERATING ROOM        0  \n",
       "118    0.000000  1.000000    75.000000  CLINICAL ENGINEERING DEPT        0  \n",
       "69     0.000000  1.000000    75.000000        INTENSIVE CARE UNIT        0  \n",
       "70     0.000000  1.000000    75.000000   PEDIATRIC INTENSIVE CARE        0  \n",
       "71     0.000000  1.000000    75.000000         LABOR AND DELIVERY        0  \n",
       "91     0.000000  1.000000    75.000000       EMERGENCY DEPARTMENT        0  \n",
       "94     0.000000  1.000000    75.000000    RADIOLOGY - MAMMOGRAPHY        0  \n",
       "89     8.125000  1.000000    75.000000   CLINIC - AMBULATORY SERV        0  \n",
       "95     0.000000  1.000000    75.000000    RADIOLOGY - MAMMOGRAPHY        0  \n",
       "194    0.000000  0.000000     0.000000                  ENDOSCOPY        0  \n",
       "98     0.000000  1.000000    75.000000                 ANESTHESIA        0  \n",
       "..          ...       ...          ...                        ...      ...  \n",
       "86    54.974359  1.179487    88.461538       PEDIATRIC CARDIOLOGY        3  \n",
       "87    18.615385  1.000000    75.000000                 ULTRASOUND        3  \n",
       "96     0.000000  1.000000    75.000000            ENDOSCOPY SUITE        3  \n",
       "77    46.976625  1.000000    75.000000       PEDIATRIC CARDIOLOGY        3  \n",
       "120    9.507463  1.000000    75.000000       CARDIAC NON-INVASIVE        3  \n",
       "121  163.085714  1.000000    75.000000       CARDIAC NON-INVASIVE        3  \n",
       "122    2.434737  1.000000    75.000000       CARDIAC NON-INVASIVE        3  \n",
       "90     0.000000  1.000000    75.000000       EMERGENCY DEPARTMENT        3  \n",
       "144    0.000000  1.000000    75.000000       CARDIAC NON-INVASIVE        3  \n",
       "143    0.000000  1.000000    75.000000   X-RAY SPECIAL PROCEDURES        3  \n",
       "51    66.666667  2.000000   150.000000     CARDIOVASCULAR IMAGING        3  \n",
       "141    0.000000  1.000000    75.000000       EMERGENCY DEPARTMENT        3  \n",
       "140    0.000000  1.000000    75.000000        VASCULAR LABORATORY        3  \n",
       "52     0.000000  2.000000   150.000000     CARDIOVASCULAR IMAGING        3  \n",
       "138    0.000000  1.000000    75.000000             OPERATING ROOM        3  \n",
       "54     0.000000  2.000000   150.000000              MEDICAL INST         3  \n",
       "58     0.000000  2.000000   150.000000           CARDIAC IMAGING         3  \n",
       "59     0.000000  2.000000   150.000000                 ULTRASOUND        3  \n",
       "60     0.000000  2.000000   150.000000                 ULTRASOUND        3  \n",
       "132    0.000000  1.000000    75.000000                 ULTRASOUND        3  \n",
       "61     0.000000  2.000000   150.000000                 ULTRASOUND        3  \n",
       "130    0.000000  1.000000    75.000000            ENDOSCOPY SUITE        3  \n",
       "64     0.000000  2.000000   150.000000                        EKG        3  \n",
       "128    0.000000  1.300000    97.500000       CARDIAC NON-INVASIVE        3  \n",
       "127    0.000000  1.529412   114.705882       CARDIAC NON-INVASIVE        3  \n",
       "66     0.000000  2.000000   150.000000             OPERATING ROOM        3  \n",
       "125    0.000000  1.588235   119.117647       CARDIAC NON-INVASIVE        3  \n",
       "67     0.000000  2.000000   150.000000              BREAST CENTER        3  \n",
       "46     0.000000  2.000000   150.000000    Maternal Fetal Medicine        3  \n",
       "195    0.000000  0.000000     0.000000       PEDIATRIC CARDIOLOGY        3  \n",
       "\n",
       "[196 rows x 11 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1 = df.sort_values(['Cluster'])\n",
    "df1"
   ]
  },
  {
   "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": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.14"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}