00_data_generation.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "# pip3 install sqlalchemy mysql-connector pyodbc pymssql"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "import random\n",
    "import time as t\n",
    "from datetime import date, datetime, time, timedelta\n",
    "\n",
    "import mysql.connector\n",
    "import pandas as pd\n",
    "# import pyodbc\n",
    "from sqlalchemy import create_engine"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "engine = create_engine(\"mssql+pymssql://atoti:atoti2@DESKTOP-G378BG1/?charset=utf8\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "dbConnection = engine.connect()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Uploading Hospital data to db"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "hospitals_df = pd.read_csv(\"data/hospital_details.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "hospitals_df.to_sql(name=\"hospitals\", con=dbConnection, schema=\"atoti\", if_exists=\"append\", index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "tags": []
   },
   "source": [
    "# Uploading devices to db"
   ]
  },
  {
   "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>EQUIPMENT</th>\n",
       "      <th>UNIT_COST</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Thermometer clinical</td>\n",
       "      <td>1.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Intubation tubes, assorted sizes</td>\n",
       "      <td>3.17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Pedal Pins</td>\n",
       "      <td>4.08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Stethoscope</td>\n",
       "      <td>5.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Chest tubes</td>\n",
       "      <td>5.43</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                          EQUIPMENT  UNIT_COST\n",
       "0              Thermometer clinical       1.36\n",
       "1  Intubation tubes, assorted sizes       3.17\n",
       "2                        Pedal Pins       4.08\n",
       "3                       Stethoscope       5.43\n",
       "4                       Chest tubes       5.43"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "medi_device = pd.read_csv(\"data/devices_details.csv\")\n",
    "medi_device.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 108,
   "metadata": {},
   "outputs": [],
   "source": [
    "medi_device.to_sql(name=\"devices\", con=dbConnection, schema=\"atoti\", if_exists=\"append\", index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "tags": []
   },
   "source": [
    "# Uploading Sales details to db"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "494"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sales_template = pd.read_csv(\"data/medical_device_price_listing.csv\")\n",
    "len(sales_template)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "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>DEPARTMENT</th>\n",
       "      <th>EQUIPMENT</th>\n",
       "      <th>QTY</th>\n",
       "      <th>UNIT_COST</th>\n",
       "      <th>TOTAL COST</th>\n",
       "      <th>EQUIPMENT_ID</th>\n",
       "      <th>PURCHASE_PRICE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>CASUALTY</td>\n",
       "      <td>Thermometer clinical</td>\n",
       "      <td>10</td>\n",
       "      <td>1.36</td>\n",
       "      <td>13.59</td>\n",
       "      <td>E0000</td>\n",
       "      <td>1.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>MCH/FP</td>\n",
       "      <td>Thermometer clinical</td>\n",
       "      <td>8</td>\n",
       "      <td>1.36</td>\n",
       "      <td>10.87</td>\n",
       "      <td>E0000</td>\n",
       "      <td>1.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>OUT PATIENT DEPARTMENT</td>\n",
       "      <td>Thermometer clinical</td>\n",
       "      <td>20</td>\n",
       "      <td>1.36</td>\n",
       "      <td>27.17</td>\n",
       "      <td>E0000</td>\n",
       "      <td>1.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>WARD</td>\n",
       "      <td>Thermometer clinical</td>\n",
       "      <td>10</td>\n",
       "      <td>1.36</td>\n",
       "      <td>13.59</td>\n",
       "      <td>E0000</td>\n",
       "      <td>1.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>CASUALTY</td>\n",
       "      <td>Intubation tubes, assorted sizes</td>\n",
       "      <td>6</td>\n",
       "      <td>3.17</td>\n",
       "      <td>19.02</td>\n",
       "      <td>E0001</td>\n",
       "      <td>2.61</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>489</th>\n",
       "      <td>X - RAY</td>\n",
       "      <td>Ultra sound unit(general)</td>\n",
       "      <td>1</td>\n",
       "      <td>27173.91</td>\n",
       "      <td>27173.91</td>\n",
       "      <td>E0487</td>\n",
       "      <td>19952.96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>490</th>\n",
       "      <td>X - RAY</td>\n",
       "      <td>OPG Unit</td>\n",
       "      <td>1</td>\n",
       "      <td>49818.84</td>\n",
       "      <td>49818.84</td>\n",
       "      <td>E0489</td>\n",
       "      <td>36075.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>491</th>\n",
       "      <td>X - RAY</td>\n",
       "      <td>Mammography unit</td>\n",
       "      <td>1</td>\n",
       "      <td>54347.83</td>\n",
       "      <td>54347.83</td>\n",
       "      <td>E0490</td>\n",
       "      <td>44115.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>492</th>\n",
       "      <td>X - RAY</td>\n",
       "      <td>Mobile X -ray unit with Image intensifier</td>\n",
       "      <td>1</td>\n",
       "      <td>63405.80</td>\n",
       "      <td>63405.80</td>\n",
       "      <td>E0491</td>\n",
       "      <td>50677.41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>493</th>\n",
       "      <td>X - RAY</td>\n",
       "      <td>Screening unit</td>\n",
       "      <td>1</td>\n",
       "      <td>108695.65</td>\n",
       "      <td>108695.65</td>\n",
       "      <td>E0493</td>\n",
       "      <td>84858.20</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>494 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 DEPARTMENT                                  EQUIPMENT  QTY  \\\n",
       "0                  CASUALTY                       Thermometer clinical   10   \n",
       "1                    MCH/FP                       Thermometer clinical    8   \n",
       "2    OUT PATIENT DEPARTMENT                       Thermometer clinical   20   \n",
       "3                      WARD                       Thermometer clinical   10   \n",
       "4                  CASUALTY           Intubation tubes, assorted sizes    6   \n",
       "..                      ...                                        ...  ...   \n",
       "489                 X - RAY                  Ultra sound unit(general)    1   \n",
       "490                 X - RAY                                   OPG Unit    1   \n",
       "491                 X - RAY                           Mammography unit    1   \n",
       "492                 X - RAY  Mobile X -ray unit with Image intensifier    1   \n",
       "493                 X - RAY                             Screening unit    1   \n",
       "\n",
       "     UNIT_COST  TOTAL COST EQUIPMENT_ID  PURCHASE_PRICE  \n",
       "0         1.36       13.59        E0000            1.01  \n",
       "1         1.36       10.87        E0000            1.01  \n",
       "2         1.36       27.17        E0000            1.01  \n",
       "3         1.36       13.59        E0000            1.01  \n",
       "4         3.17       19.02        E0001            2.61  \n",
       "..         ...         ...          ...             ...  \n",
       "489   27173.91    27173.91        E0487        19952.96  \n",
       "490   49818.84    49818.84        E0489        36075.26  \n",
       "491   54347.83    54347.83        E0490        44115.15  \n",
       "492   63405.80    63405.80        E0491        50677.41  \n",
       "493  108695.65   108695.65        E0493        84858.20  \n",
       "\n",
       "[494 rows x 7 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sales_combined = pd.merge(sales_template, medi_device, on=\"EQUIPMENT\")\n",
    "sales_combined"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "sales_combined.drop(columns=[\"TOTAL COST\", \"EQUIPMENT\", \"PURCHASE_PRICE\"], inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "hospital_list = [\n",
    "    \"US_HOSP_1\",\n",
    "    \"US_HOSP_2\",\n",
    "    \"US_HOSP_3\",\n",
    "    \"US_HOSP_4\",\n",
    "    \"US_HOSP_5\",\n",
    "    \"US_HOSP_6\",\n",
    "    \"US_HOSP_7\",\n",
    "    \"US_HOSP_8\",\n",
    "    \"US_HOSP_9\",\n",
    "    \"US_HOSP_10\",\n",
    "    \"FR_HOSP_1\",\n",
    "    \"FR_HOSP_2\",\n",
    "    \"FR_HOSP_3\",\n",
    "    \"FR_HOSP_4\",\n",
    "    \"FR_HOSP_5\",\n",
    "    \"FR_HOSP_6\",\n",
    "    \"FR_HOSP_7\",\n",
    "    \"FR_HOSP_8\",\n",
    "    \"FR_HOSP_9\",\n",
    "    \"FR_HOSP_10\",\n",
    "    \"DE_HOSP_1\",\n",
    "    \"DE_HOSP_2\",\n",
    "    \"DE_HOSP_3\",\n",
    "    \"DE_HOSP_4\",\n",
    "    \"DE_HOSP_5\",\n",
    "    \"DE_HOSP_6\",\n",
    "    \"DE_HOSP_7\",\n",
    "    \"DE_HOSP_8\",\n",
    "    \"DE_HOSP_9\",\n",
    "    \"DE_HOSP_10\",\n",
    "]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "sales_cnt = 1"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Functions to generate mock sales transaction"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 119,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Generating sales for range of date or for real-time data feed\n",
    "\n",
    "orders = pd.DataFrame()\n",
    "\n",
    "def generate_sales(txn_dt, realtime):\n",
    "    global sales_cnt, orders\n",
    "    sales_number = random.randint(90, 250)\n",
    "    sample_sales = sales_combined.sample(sales_number)\n",
    "\n",
    "    while len(sample_sales) > 10:\n",
    "        update_tm = datetime.now()\n",
    "            \n",
    "        if realtime == True:\n",
    "            # throttle the database insertion for demo effect since transactions normal come in different time in the day\n",
    "            sleep_tm = random.randint(1,10)\n",
    "            print(f\"sleeping {sleep_tm}\")\n",
    "            t.sleep(sleep_tm)\n",
    "        else:\n",
    "            rand_minute = random.randint(0,59) \n",
    "            rand_microsec = random.randint(1, 999999)\n",
    "            # just random update time\n",
    "            update_tm = datetime.combine(txn_dt, time((sales_cnt%8 + 10), rand_minute, rand_minute, rand_microsec))\n",
    "\n",
    "        frac_value = random.uniform(0.05, 0.25)\n",
    "        client_order = sample_sales.sample(frac=frac_value, random_state=1)\n",
    "        client_order[\"SALE_ID\"] = f\"M{str(sales_cnt).zfill(9)}\"\n",
    "        client_order[\"SALE_DATE\"] = update_tm.strftime(\"%Y-%m-%d\")\n",
    "        client_order[\"SALE_DATE\"] = pd.to_datetime(client_order[\"SALE_DATE\"])\n",
    "        \n",
    "        client_order[\"HOSPITAL_ID\"] = random.choice(hospital_list)\n",
    "        client_order[\"QTY\"] = client_order.apply(\n",
    "            lambda x: random.randint(1, x.QTY), axis=1\n",
    "        )\n",
    "        client_order[\"LAST_UPDATE_DATE\"] = update_tm\n",
    "        client_order.to_sql(name=\"medical_sales\", con=dbConnection, schema=\"atoti\", if_exists=\"append\", index=False)\n",
    "        orders = orders.append(client_order)\n",
    "\n",
    "        sales_cnt += 1\n",
    "        sample_sales = sample_sales.drop(client_order.index)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 120,
   "metadata": {},
   "outputs": [],
   "source": [
    "# trigger the sales from the given date till current date\n",
    "\n",
    "def initialize_sales(start_date):\n",
    "    day_count = (date.today() - start_date).days\n",
    "\n",
    "    for single_date in (start_date + timedelta(n) for n in range(day_count)):\n",
    "        generate_sales(single_date, False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Inserting the past sales transactions into database"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 121,
   "metadata": {},
   "outputs": [],
   "source": [
    "initialize_sales(date(2021, 4, 1))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 122,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "28192"
      ]
     },
     "execution_count": 122,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(orders)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 123,
   "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>DEPARTMENT</th>\n",
       "      <th>QTY</th>\n",
       "      <th>UNIT_COST</th>\n",
       "      <th>EQUIPMENT_ID</th>\n",
       "      <th>SALE_ID</th>\n",
       "      <th>SALE_DATE</th>\n",
       "      <th>HOSPITAL_ID</th>\n",
       "      <th>LAST_UPDATE_DATE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>329</th>\n",
       "      <td>MCH/FP</td>\n",
       "      <td>2</td>\n",
       "      <td>22.64</td>\n",
       "      <td>E0247</td>\n",
       "      <td>M000000001</td>\n",
       "      <td>2021-04-01</td>\n",
       "      <td>FR_HOSP_4</td>\n",
       "      <td>2021-04-01 11:15:15.036886</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>368</th>\n",
       "      <td>ORTHOPAEDIC TECHNOLOGY</td>\n",
       "      <td>1</td>\n",
       "      <td>36.23</td>\n",
       "      <td>E0302</td>\n",
       "      <td>M000000001</td>\n",
       "      <td>2021-04-01</td>\n",
       "      <td>FR_HOSP_4</td>\n",
       "      <td>2021-04-01 11:15:15.036886</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>386</th>\n",
       "      <td>ORTHOPAEDIC TECHNOLOGY</td>\n",
       "      <td>1</td>\n",
       "      <td>905.80</td>\n",
       "      <td>E0323</td>\n",
       "      <td>M000000001</td>\n",
       "      <td>2021-04-01</td>\n",
       "      <td>FR_HOSP_4</td>\n",
       "      <td>2021-04-01 11:15:15.036886</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>WARD</td>\n",
       "      <td>1</td>\n",
       "      <td>5.43</td>\n",
       "      <td>E0003</td>\n",
       "      <td>M000000001</td>\n",
       "      <td>2021-04-01</td>\n",
       "      <td>FR_HOSP_4</td>\n",
       "      <td>2021-04-01 11:15:15.036886</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>CASUALTY</td>\n",
       "      <td>1</td>\n",
       "      <td>4.53</td>\n",
       "      <td>E0022</td>\n",
       "      <td>M000000001</td>\n",
       "      <td>2021-04-01</td>\n",
       "      <td>FR_HOSP_4</td>\n",
       "      <td>2021-04-01 11:15:15.036886</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 DEPARTMENT  QTY  UNIT_COST EQUIPMENT_ID     SALE_ID  \\\n",
       "329                  MCH/FP    2      22.64        E0247  M000000001   \n",
       "368  ORTHOPAEDIC TECHNOLOGY    1      36.23        E0302  M000000001   \n",
       "386  ORTHOPAEDIC TECHNOLOGY    1     905.80        E0323  M000000001   \n",
       "12                     WARD    1       5.43        E0003  M000000001   \n",
       "53                 CASUALTY    1       4.53        E0022  M000000001   \n",
       "\n",
       "     SALE_DATE HOSPITAL_ID           LAST_UPDATE_DATE  \n",
       "329 2021-04-01   FR_HOSP_4 2021-04-01 11:15:15.036886  \n",
       "368 2021-04-01   FR_HOSP_4 2021-04-01 11:15:15.036886  \n",
       "386 2021-04-01   FR_HOSP_4 2021-04-01 11:15:15.036886  \n",
       "12  2021-04-01   FR_HOSP_4 2021-04-01 11:15:15.036886  \n",
       "53  2021-04-01   FR_HOSP_4 2021-04-01 11:15:15.036886  "
      ]
     },
     "execution_count": 123,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "orders.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Triggering sales for real-time demo purpose.  \n",
    "\n",
    "Toggle over to the dashboard from 02-main_mssql_realtime.ipynb to see the dashboards reflecting the changes real-time."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "generate_sales(None, True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 126,
   "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>DEPARTMENT</th>\n",
       "      <th>QTY</th>\n",
       "      <th>UNIT_COST</th>\n",
       "      <th>EQUIPMENT_ID</th>\n",
       "      <th>SALE_ID</th>\n",
       "      <th>SALE_DATE</th>\n",
       "      <th>HOSPITAL_ID</th>\n",
       "      <th>LAST_UPDATE_DATE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>329</th>\n",
       "      <td>MCH/FP</td>\n",
       "      <td>2</td>\n",
       "      <td>22.64</td>\n",
       "      <td>E0247</td>\n",
       "      <td>M000000001</td>\n",
       "      <td>2021-04-01</td>\n",
       "      <td>FR_HOSP_4</td>\n",
       "      <td>2021-04-01 11:15:15.036886</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>368</th>\n",
       "      <td>ORTHOPAEDIC TECHNOLOGY</td>\n",
       "      <td>1</td>\n",
       "      <td>36.23</td>\n",
       "      <td>E0302</td>\n",
       "      <td>M000000001</td>\n",
       "      <td>2021-04-01</td>\n",
       "      <td>FR_HOSP_4</td>\n",
       "      <td>2021-04-01 11:15:15.036886</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>386</th>\n",
       "      <td>ORTHOPAEDIC TECHNOLOGY</td>\n",
       "      <td>1</td>\n",
       "      <td>905.80</td>\n",
       "      <td>E0323</td>\n",
       "      <td>M000000001</td>\n",
       "      <td>2021-04-01</td>\n",
       "      <td>FR_HOSP_4</td>\n",
       "      <td>2021-04-01 11:15:15.036886</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>WARD</td>\n",
       "      <td>1</td>\n",
       "      <td>5.43</td>\n",
       "      <td>E0003</td>\n",
       "      <td>M000000001</td>\n",
       "      <td>2021-04-01</td>\n",
       "      <td>FR_HOSP_4</td>\n",
       "      <td>2021-04-01 11:15:15.036886</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>CASUALTY</td>\n",
       "      <td>1</td>\n",
       "      <td>4.53</td>\n",
       "      <td>E0022</td>\n",
       "      <td>M000000001</td>\n",
       "      <td>2021-04-01</td>\n",
       "      <td>FR_HOSP_4</td>\n",
       "      <td>2021-04-01 11:15:15.036886</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>MCH/FP</td>\n",
       "      <td>2</td>\n",
       "      <td>17.21</td>\n",
       "      <td>E0035</td>\n",
       "      <td>M000003064</td>\n",
       "      <td>2021-09-23</td>\n",
       "      <td>FR_HOSP_2</td>\n",
       "      <td>2021-09-23 08:32:15.144232</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>CASUALTY</td>\n",
       "      <td>6</td>\n",
       "      <td>3.17</td>\n",
       "      <td>E0001</td>\n",
       "      <td>M000003065</td>\n",
       "      <td>2021-09-23</td>\n",
       "      <td>DE_HOSP_6</td>\n",
       "      <td>2021-09-23 08:32:17.160095</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>CSSD</td>\n",
       "      <td>2</td>\n",
       "      <td>34250.73</td>\n",
       "      <td>E0055</td>\n",
       "      <td>M000003065</td>\n",
       "      <td>2021-09-23</td>\n",
       "      <td>DE_HOSP_6</td>\n",
       "      <td>2021-09-23 08:32:17.160095</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>356</th>\n",
       "      <td>OCCUPATIONAL THERAPY</td>\n",
       "      <td>1</td>\n",
       "      <td>31.70</td>\n",
       "      <td>E0291</td>\n",
       "      <td>M000003066</td>\n",
       "      <td>2021-09-23</td>\n",
       "      <td>DE_HOSP_2</td>\n",
       "      <td>2021-09-23 08:32:23.176160</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>258</th>\n",
       "      <td>LABORATORY</td>\n",
       "      <td>1</td>\n",
       "      <td>299.56</td>\n",
       "      <td>E0177</td>\n",
       "      <td>M000003067</td>\n",
       "      <td>2021-09-23</td>\n",
       "      <td>DE_HOSP_9</td>\n",
       "      <td>2021-09-23 08:32:33.199753</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>28489 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 DEPARTMENT  QTY  UNIT_COST EQUIPMENT_ID     SALE_ID  \\\n",
       "329                  MCH/FP    2      22.64        E0247  M000000001   \n",
       "368  ORTHOPAEDIC TECHNOLOGY    1      36.23        E0302  M000000001   \n",
       "386  ORTHOPAEDIC TECHNOLOGY    1     905.80        E0323  M000000001   \n",
       "12                     WARD    1       5.43        E0003  M000000001   \n",
       "53                 CASUALTY    1       4.53        E0022  M000000001   \n",
       "..                      ...  ...        ...          ...         ...   \n",
       "91                   MCH/FP    2      17.21        E0035  M000003064   \n",
       "4                  CASUALTY    6       3.17        E0001  M000003065   \n",
       "133                    CSSD    2   34250.73        E0055  M000003065   \n",
       "356    OCCUPATIONAL THERAPY    1      31.70        E0291  M000003066   \n",
       "258              LABORATORY    1     299.56        E0177  M000003067   \n",
       "\n",
       "     SALE_DATE HOSPITAL_ID           LAST_UPDATE_DATE  \n",
       "329 2021-04-01   FR_HOSP_4 2021-04-01 11:15:15.036886  \n",
       "368 2021-04-01   FR_HOSP_4 2021-04-01 11:15:15.036886  \n",
       "386 2021-04-01   FR_HOSP_4 2021-04-01 11:15:15.036886  \n",
       "12  2021-04-01   FR_HOSP_4 2021-04-01 11:15:15.036886  \n",
       "53  2021-04-01   FR_HOSP_4 2021-04-01 11:15:15.036886  \n",
       "..         ...         ...                        ...  \n",
       "91  2021-09-23   FR_HOSP_2 2021-09-23 08:32:15.144232  \n",
       "4   2021-09-23   DE_HOSP_6 2021-09-23 08:32:17.160095  \n",
       "133 2021-09-23   DE_HOSP_6 2021-09-23 08:32:17.160095  \n",
       "356 2021-09-23   DE_HOSP_2 2021-09-23 08:32:23.176160  \n",
       "258 2021-09-23   DE_HOSP_9 2021-09-23 08:32:33.199753  \n",
       "\n",
       "[28489 rows x 8 columns]"
      ]
     },
     "execution_count": 126,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "orders"
   ]
  }
 ],
 "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.8.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}