omop_data_preprocessing.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2018-05-18T13:52:26.430924Z",
     "start_time": "2018-05-18T13:52:26.043533Z"
    },
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2018-05-18T13:52:26.436034Z",
     "start_time": "2018-05-18T13:52:26.432745Z"
    },
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "fname = 'dataset_omop.pkl'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2018-05-18T13:52:26.459853Z",
     "start_time": "2018-05-18T13:52:26.438602Z"
    },
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pickle as pkl\n",
    "\n",
    "df = pkl.load(open(fname, 'rb'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2018-05-18T13:52:26.484226Z",
     "start_time": "2018-05-18T13:52:26.481260Z"
    },
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# df['measurement_datetime'] = df['measurement_datetime'].apply(pd.to_datetime)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2018-05-18T13:52:26.623847Z",
     "start_time": "2018-05-18T13:52:26.574412Z"
    },
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>measurement_datetime</th>\n",
       "      <th>target</th>\n",
       "      <th>super_target</th>\n",
       "      <th>person_id</th>\n",
       "      <th>BP diastolic</th>\n",
       "      <th>BP systolic</th>\n",
       "      <th>Body temperature</th>\n",
       "      <th>Glasgow coma scale</th>\n",
       "      <th>Heart rate</th>\n",
       "      <th>Mean blood pressure</th>\n",
       "      <th>...</th>\n",
       "      <th>race_UNABLE TO OBTAIN</th>\n",
       "      <th>race_UNKNOWN/NOT SPECIFIED</th>\n",
       "      <th>race_WHITE</th>\n",
       "      <th>race_WHITE - BRAZILIAN</th>\n",
       "      <th>race_WHITE - EASTERN EUROPEAN</th>\n",
       "      <th>race_WHITE - OTHER EUROPEAN</th>\n",
       "      <th>race_WHITE - RUSSIAN</th>\n",
       "      <th>race_NaN</th>\n",
       "      <th>age</th>\n",
       "      <th>Respiratory rate avg h-2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2182-07-31 04:11:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063393</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>60.8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2182-07-31 04:45:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063393</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>60.8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2188-11-12 10:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>88.0</td>\n",
       "      <td>146.0</td>\n",
       "      <td>36.388901</td>\n",
       "      <td>15.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>107.333</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>23.9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2188-11-12 10:30:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>95.0</td>\n",
       "      <td>140.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>134.0</td>\n",
       "      <td>110.000</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>23.9</td>\n",
       "      <td>38.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2188-11-12 10:45:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>97.0</td>\n",
       "      <td>144.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>134.0</td>\n",
       "      <td>112.667</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>23.9</td>\n",
       "      <td>36.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2188-11-12 11:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>91.0</td>\n",
       "      <td>140.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>134.0</td>\n",
       "      <td>107.333</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>23.9</td>\n",
       "      <td>37.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2188-11-12 12:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>98.0</td>\n",
       "      <td>139.0</td>\n",
       "      <td>97.599998</td>\n",
       "      <td>NaN</td>\n",
       "      <td>135.0</td>\n",
       "      <td>111.667</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>23.9</td>\n",
       "      <td>38.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2188-11-12 13:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>108.0</td>\n",
       "      <td>158.0</td>\n",
       "      <td>36.666698</td>\n",
       "      <td>15.0</td>\n",
       "      <td>134.0</td>\n",
       "      <td>124.667</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>23.9</td>\n",
       "      <td>39.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2188-11-12 13:03:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>36.700000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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>23.9</td>\n",
       "      <td>35.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2188-11-12 13:30:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>105.0</td>\n",
       "      <td>159.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>134.0</td>\n",
       "      <td>123.000</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>23.9</td>\n",
       "      <td>35.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 113 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  measurement_datetime  target  super_target  person_id  BP diastolic  \\\n",
       "0  2182-07-31 04:11:00       0             1   62063393           NaN   \n",
       "1  2182-07-31 04:45:00       0             1   62063393           NaN   \n",
       "2  2188-11-12 10:00:00       0             1   62063368          88.0   \n",
       "3  2188-11-12 10:30:00       0             1   62063368          95.0   \n",
       "4  2188-11-12 10:45:00       0             1   62063368          97.0   \n",
       "5  2188-11-12 11:00:00       0             1   62063368          91.0   \n",
       "6  2188-11-12 12:00:00       0             1   62063368          98.0   \n",
       "7  2188-11-12 13:00:00       0             1   62063368         108.0   \n",
       "8  2188-11-12 13:03:00       0             1   62063368           NaN   \n",
       "9  2188-11-12 13:30:00       0             1   62063368         105.0   \n",
       "\n",
       "   BP systolic  Body temperature  Glasgow coma scale  Heart rate  \\\n",
       "0          NaN               NaN                 NaN         NaN   \n",
       "1          NaN               NaN                 NaN         NaN   \n",
       "2        146.0         36.388901                15.0         NaN   \n",
       "3        140.0               NaN                 NaN       134.0   \n",
       "4        144.0               NaN                 NaN       134.0   \n",
       "5        140.0               NaN                 NaN       134.0   \n",
       "6        139.0         97.599998                 NaN       135.0   \n",
       "7        158.0         36.666698                15.0       134.0   \n",
       "8          NaN         36.700000                 NaN         NaN   \n",
       "9        159.0               NaN                 NaN       134.0   \n",
       "\n",
       "   Mean blood pressure            ...             race_UNABLE TO OBTAIN  \\\n",
       "0                  NaN            ...                                 0   \n",
       "1                  NaN            ...                                 0   \n",
       "2              107.333            ...                                 0   \n",
       "3              110.000            ...                                 0   \n",
       "4              112.667            ...                                 0   \n",
       "5              107.333            ...                                 0   \n",
       "6              111.667            ...                                 0   \n",
       "7              124.667            ...                                 0   \n",
       "8                  NaN            ...                                 0   \n",
       "9              123.000            ...                                 0   \n",
       "\n",
       "   race_UNKNOWN/NOT SPECIFIED  race_WHITE  race_WHITE - BRAZILIAN  \\\n",
       "0                           0           1                       0   \n",
       "1                           0           1                       0   \n",
       "2                           0           0                       0   \n",
       "3                           0           0                       0   \n",
       "4                           0           0                       0   \n",
       "5                           0           0                       0   \n",
       "6                           0           0                       0   \n",
       "7                           0           0                       0   \n",
       "8                           0           0                       0   \n",
       "9                           0           0                       0   \n",
       "\n",
       "   race_WHITE - EASTERN EUROPEAN  race_WHITE - OTHER EUROPEAN  \\\n",
       "0                              0                            0   \n",
       "1                              0                            0   \n",
       "2                              0                            0   \n",
       "3                              0                            0   \n",
       "4                              0                            0   \n",
       "5                              0                            0   \n",
       "6                              0                            0   \n",
       "7                              0                            0   \n",
       "8                              0                            0   \n",
       "9                              0                            0   \n",
       "\n",
       "   race_WHITE - RUSSIAN  race_NaN   age  Respiratory rate avg h-2  \n",
       "0                     0         0  60.8                       NaN  \n",
       "1                     0         0  60.8                       NaN  \n",
       "2                     0         0  23.9                       NaN  \n",
       "3                     0         0  23.9                 38.000000  \n",
       "4                     0         0  23.9                 36.000000  \n",
       "5                     0         0  23.9                 37.666667  \n",
       "6                     0         0  23.9                 38.250000  \n",
       "7                     0         0  23.9                 39.000000  \n",
       "8                     0         0  23.9                 35.000000  \n",
       "9                     0         0  23.9                 35.000000  \n",
       "\n",
       "[10 rows x 113 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.iloc[:10]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2018-05-18T13:52:26.714522Z",
     "start_time": "2018-05-18T13:52:26.708009Z"
    },
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "variable_names = df.columns.values\n",
    "mat = np.asarray(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2018-05-18T13:52:36.846131Z",
     "start_time": "2018-05-18T13:52:27.440615Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[INFO] adding /home/paulroujansky/git/DataForGood/batch4_diafoirus_fleming to sys.path\n"
     ]
    }
   ],
   "source": [
    "from datetime import timedelta\n",
    "from fleming_lib.preprocessing import fill_last_upto\n",
    "\n",
    "# Fill missing values with last one (up to h time prior to measurement)\n",
    "df = df.groupby('person_id', group_keys=False).apply(fill_last_upto, h=timedelta(hours=24))\n",
    "\n",
    "# Sort index\n",
    "df.sort_index(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2018-05-18T13:53:48.594041Z",
     "start_time": "2018-05-18T13:53:48.586479Z"
    },
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# Extracting dataframe for each patient\n",
    "list_df = dict()\n",
    "patients_id = []\n",
    "\n",
    "for patient_id, sub_df in df.groupby('person_id'):\n",
    "    list_df[patient_id] = sub_df\n",
    "    patients_id.append(patient_id)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2018-05-18T13:53:49.380093Z",
     "start_time": "2018-05-18T13:53:49.185728Z"
    },
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import warnings\n",
    "from datetime import timedelta\n",
    "\n",
    "class Dataloader():\n",
    "    \n",
    "    def __init__(self):\n",
    "        pass\n",
    "    \n",
    "    def load_data(self, df):\n",
    "        self.df = df\n",
    "        self.measurement_datetime = df['measurement_datetime']\n",
    "        self.start_dt = self.measurement_datetime.iloc[0]\n",
    "        self.end_dt = self.measurement_datetime.iloc[-1]\n",
    "        \n",
    "        self.variables = df.columns.values\n",
    "        \n",
    "    def make_timeline(self, start_dt=None, end_dt=None, step=timedelta(days=1), window=timedelta(days=1)):\n",
    "        \n",
    "        if start_dt is None:\n",
    "            start_dt = self.start_dt\n",
    "        if end_dt is None:\n",
    "            end_dt = self.end_dt\n",
    "            \n",
    "        if start_dt > self.end_dt:\n",
    "            raise ValueError('`start_date` cannot be greater than {}'.format(self.end_dt))\n",
    "        if end_dt < self.start_dt:\n",
    "            raise ValueError('`end_date` cannot be smaller than {}'.format(self.start_dt))\n",
    "        if start_dt > end_dt:\n",
    "            raise ValueError('`end_date` should be greater than `start_date`')\n",
    "        \n",
    "        timeline = []\n",
    "        \n",
    "        self.step = step\n",
    "        self.window = window\n",
    "        \n",
    "        delta = end_dt - start_dt\n",
    "\n",
    "        i = 0\n",
    "        t = start_dt\n",
    "        while t < end_dt:\n",
    "            t = start_dt + i * step\n",
    "            timeline.append(t)\n",
    "            i += 1\n",
    "            \n",
    "        self.timeline = timeline\n",
    "        self.n_times = len(self.timeline)\n",
    "        \n",
    "    def get_time(self, i):\n",
    "        if i > self.n_times:\n",
    "            raise ValueError('Cannot fetch time index {} (max {}).'.format(i, self.n_times - 1))\n",
    "        return self.timeline[i]\n",
    "        \n",
    "    def _make_batch(self, i):\n",
    "        time = self.get_time(i)\n",
    "        j = 1\n",
    "        mask = (self.measurement_datetime > time - j * self.window) & (self.measurement_datetime <= time)\n",
    "        batch = self.df[mask] \n",
    "        if len(batch.index) == 0:\n",
    "            # If no data is fetched, we go back in time to fetch some until we do.\n",
    "            while True:\n",
    "                j += 1\n",
    "                mask = (self.measurement_datetime > time - j * self.window) & (self.measurement_datetime <= time)\n",
    "                new_batch = self.df[mask]\n",
    "                if len(new_batch.index) > 0:\n",
    "                    warnings.warn('No data between {} and {}. Going back {}.'.format(time, time - j * self.window, self.window))\n",
    "                    batch = new_batch\n",
    "                    break\n",
    "        return batch\n",
    "    \n",
    "    def build_batches(self):\n",
    "        self.batches = [self._make_batch(i) for i in range(self.n_times)]\n",
    "        self.n_batches = len(self.batches)\n",
    "        \n",
    "    def get_batch(self, i):\n",
    "        if i > self.n_batches:\n",
    "            raise ValueError('Cannot fetch batch {} (max {}).'.format(i, self.n_batches - 1))\n",
    "        return self.batches[i]\n",
    "    \n",
    "    def batch_to_matrix(self, batches):\n",
    "        if not isinstance(batches, list):\n",
    "            return batches.as_matrix()\n",
    "        else:\n",
    "            return [batch.as_matrix() for batch in self.batches]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2018-05-18T13:53:50.412315Z",
     "start_time": "2018-05-18T13:53:50.346854Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "n_batches: 12\n",
      "n_batches: 5\n",
      "n_batches: 2\n"
     ]
    }
   ],
   "source": [
    "dataloaders = dict()\n",
    "\n",
    "for patient_id, sub_df in list_df.items():\n",
    "    \n",
    "    dataloader = Dataloader()\n",
    "\n",
    "    # Load dataset\n",
    "    dataloader.load_data(list_df[patient_id])\n",
    "\n",
    "    # Build timeline\n",
    "    step = timedelta(days=1)  # get batch every 'step'\n",
    "    window = timedelta(days=1)  # batch size of 'window'\n",
    "    dataloader.make_timeline(step=step, window=window)\n",
    "\n",
    "    # Build batches\n",
    "    dataloader.build_batches()\n",
    "    print('n_batches: {}'.format(dataloader.n_times))\n",
    "    \n",
    "    dataloaders[patient_id] = dataloader"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2018-05-18T13:53:52.028164Z",
     "start_time": "2018-05-18T13:53:51.963634Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>measurement_datetime</th>\n",
       "      <th>target</th>\n",
       "      <th>super_target</th>\n",
       "      <th>person_id</th>\n",
       "      <th>BP diastolic</th>\n",
       "      <th>BP systolic</th>\n",
       "      <th>Body temperature</th>\n",
       "      <th>Glasgow coma scale</th>\n",
       "      <th>Heart rate</th>\n",
       "      <th>Mean blood pressure</th>\n",
       "      <th>...</th>\n",
       "      <th>race_UNABLE TO OBTAIN</th>\n",
       "      <th>race_UNKNOWN/NOT SPECIFIED</th>\n",
       "      <th>race_WHITE</th>\n",
       "      <th>race_WHITE - BRAZILIAN</th>\n",
       "      <th>race_WHITE - EASTERN EUROPEAN</th>\n",
       "      <th>race_WHITE - OTHER EUROPEAN</th>\n",
       "      <th>race_WHITE - RUSSIAN</th>\n",
       "      <th>race_NaN</th>\n",
       "      <th>age</th>\n",
       "      <th>Respiratory rate avg h-2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2188-11-12 10:30:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>95</td>\n",
       "      <td>140</td>\n",
       "      <td>36.3889</td>\n",
       "      <td>15</td>\n",
       "      <td>134</td>\n",
       "      <td>110</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>23.9</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2188-11-12 10:45:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>97</td>\n",
       "      <td>144</td>\n",
       "      <td>36.3889</td>\n",
       "      <td>15</td>\n",
       "      <td>134</td>\n",
       "      <td>112.667</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>23.9</td>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2188-11-12 11:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>91</td>\n",
       "      <td>140</td>\n",
       "      <td>36.3889</td>\n",
       "      <td>15</td>\n",
       "      <td>134</td>\n",
       "      <td>107.333</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>23.9</td>\n",
       "      <td>37.6667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2188-11-12 12:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>98</td>\n",
       "      <td>139</td>\n",
       "      <td>97.6</td>\n",
       "      <td>15</td>\n",
       "      <td>135</td>\n",
       "      <td>111.667</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>23.9</td>\n",
       "      <td>38.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2188-11-12 13:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>108</td>\n",
       "      <td>158</td>\n",
       "      <td>36.6667</td>\n",
       "      <td>15</td>\n",
       "      <td>134</td>\n",
       "      <td>124.667</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>23.9</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2188-11-12 13:03:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>108</td>\n",
       "      <td>158</td>\n",
       "      <td>36.7</td>\n",
       "      <td>15</td>\n",
       "      <td>134</td>\n",
       "      <td>124.667</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>23.9</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2188-11-12 13:30:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>105</td>\n",
       "      <td>159</td>\n",
       "      <td>36.7</td>\n",
       "      <td>15</td>\n",
       "      <td>134</td>\n",
       "      <td>123</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>23.9</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2188-11-12 14:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>107</td>\n",
       "      <td>157</td>\n",
       "      <td>36.7</td>\n",
       "      <td>15</td>\n",
       "      <td>137</td>\n",
       "      <td>123.667</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>23.9</td>\n",
       "      <td>33.6667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2188-11-12 14:45:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>101</td>\n",
       "      <td>149</td>\n",
       "      <td>36.7</td>\n",
       "      <td>15</td>\n",
       "      <td>147</td>\n",
       "      <td>117</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>23.9</td>\n",
       "      <td>32.3333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2188-11-12 15:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>100</td>\n",
       "      <td>147</td>\n",
       "      <td>36.7</td>\n",
       "      <td>15</td>\n",
       "      <td>146</td>\n",
       "      <td>115.667</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>23.9</td>\n",
       "      <td>34.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2188-11-12 15:30:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>110</td>\n",
       "      <td>154</td>\n",
       "      <td>36.7</td>\n",
       "      <td>15</td>\n",
       "      <td>144</td>\n",
       "      <td>124.667</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>23.9</td>\n",
       "      <td>36.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2188-11-12 16:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>122</td>\n",
       "      <td>171</td>\n",
       "      <td>36.7</td>\n",
       "      <td>15</td>\n",
       "      <td>134</td>\n",
       "      <td>138.333</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>23.9</td>\n",
       "      <td>38.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2188-11-12 16:10:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>122</td>\n",
       "      <td>171</td>\n",
       "      <td>36.7</td>\n",
       "      <td>15</td>\n",
       "      <td>134</td>\n",
       "      <td>138.333</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>23.9</td>\n",
       "      <td>39.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2188-11-12 17:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>78</td>\n",
       "      <td>116</td>\n",
       "      <td>36.7</td>\n",
       "      <td>15</td>\n",
       "      <td>142</td>\n",
       "      <td>80</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>23.9</td>\n",
       "      <td>34.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2188-11-12 18:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>84</td>\n",
       "      <td>136</td>\n",
       "      <td>36.7</td>\n",
       "      <td>15</td>\n",
       "      <td>129</td>\n",
       "      <td>102</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>23.9</td>\n",
       "      <td>25.6667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2188-11-12 18:15:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>70</td>\n",
       "      <td>122</td>\n",
       "      <td>36.7</td>\n",
       "      <td>15</td>\n",
       "      <td>127</td>\n",
       "      <td>88</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>23.9</td>\n",
       "      <td>19.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2188-11-12 18:30:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>62</td>\n",
       "      <td>109</td>\n",
       "      <td>36.7</td>\n",
       "      <td>15</td>\n",
       "      <td>127</td>\n",
       "      <td>78</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>23.9</td>\n",
       "      <td>21.3333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2188-11-12 19:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>79</td>\n",
       "      <td>130</td>\n",
       "      <td>36.7</td>\n",
       "      <td>15</td>\n",
       "      <td>123</td>\n",
       "      <td>95</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>23.9</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2188-11-12 20:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>61</td>\n",
       "      <td>109</td>\n",
       "      <td>37.9444</td>\n",
       "      <td>10</td>\n",
       "      <td>135</td>\n",
       "      <td>77</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>23.9</td>\n",
       "      <td>21.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2188-11-12 20:36:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>61</td>\n",
       "      <td>109</td>\n",
       "      <td>37.9</td>\n",
       "      <td>10</td>\n",
       "      <td>135</td>\n",
       "      <td>77</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>23.9</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2188-11-12 21:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>73</td>\n",
       "      <td>125</td>\n",
       "      <td>37.9</td>\n",
       "      <td>10</td>\n",
       "      <td>135</td>\n",
       "      <td>90</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>23.9</td>\n",
       "      <td>16.6667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2188-11-12 21:16:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>73</td>\n",
       "      <td>125</td>\n",
       "      <td>37.9</td>\n",
       "      <td>10</td>\n",
       "      <td>135</td>\n",
       "      <td>90</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>23.9</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2188-11-12 22:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>79</td>\n",
       "      <td>134</td>\n",
       "      <td>39</td>\n",
       "      <td>10</td>\n",
       "      <td>137</td>\n",
       "      <td>97</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>23.9</td>\n",
       "      <td>15.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2188-11-12 22:04:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>79</td>\n",
       "      <td>134</td>\n",
       "      <td>37.8</td>\n",
       "      <td>10</td>\n",
       "      <td>137</td>\n",
       "      <td>97</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>23.9</td>\n",
       "      <td>16.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2188-11-12 23:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>82</td>\n",
       "      <td>135</td>\n",
       "      <td>37.8</td>\n",
       "      <td>10</td>\n",
       "      <td>151</td>\n",
       "      <td>99</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>23.9</td>\n",
       "      <td>15.4167</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2188-11-12 23:37:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>82</td>\n",
       "      <td>135</td>\n",
       "      <td>39</td>\n",
       "      <td>10</td>\n",
       "      <td>151</td>\n",
       "      <td>99</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>23.9</td>\n",
       "      <td>14.2222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2188-11-13 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>61</td>\n",
       "      <td>102</td>\n",
       "      <td>38.6667</td>\n",
       "      <td>9</td>\n",
       "      <td>147</td>\n",
       "      <td>75</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>23.9</td>\n",
       "      <td>18.1667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>2188-11-13 00:30:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>62</td>\n",
       "      <td>98</td>\n",
       "      <td>38.6667</td>\n",
       "      <td>9</td>\n",
       "      <td>140</td>\n",
       "      <td>74</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>23.9</td>\n",
       "      <td>25.3333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>2188-11-13 01:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>77</td>\n",
       "      <td>121</td>\n",
       "      <td>38.6667</td>\n",
       "      <td>9</td>\n",
       "      <td>141</td>\n",
       "      <td>92</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>23.9</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>2188-11-13 01:30:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>96</td>\n",
       "      <td>142</td>\n",
       "      <td>38.6667</td>\n",
       "      <td>9</td>\n",
       "      <td>133</td>\n",
       "      <td>111</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>23.9</td>\n",
       "      <td>32.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>2188-11-13 04:08:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>54</td>\n",
       "      <td>85</td>\n",
       "      <td>96.1</td>\n",
       "      <td>8</td>\n",
       "      <td>122</td>\n",
       "      <td>65</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>23.9</td>\n",
       "      <td>29.0833</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>2188-11-13 04:15:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>58</td>\n",
       "      <td>90</td>\n",
       "      <td>35.8333</td>\n",
       "      <td>8</td>\n",
       "      <td>125</td>\n",
       "      <td>70</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>23.9</td>\n",
       "      <td>29.0833</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>2188-11-13 04:30:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>61</td>\n",
       "      <td>94</td>\n",
       "      <td>35.5556</td>\n",
       "      <td>8</td>\n",
       "      <td>126</td>\n",
       "      <td>73</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>23.9</td>\n",
       "      <td>26.3333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>2188-11-13 05:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>64</td>\n",
       "      <td>99</td>\n",
       "      <td>35.5556</td>\n",
       "      <td>8</td>\n",
       "      <td>132</td>\n",
       "      <td>77</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>23.9</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>2188-11-13 05:49:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>64</td>\n",
       "      <td>99</td>\n",
       "      <td>37.6</td>\n",
       "      <td>8</td>\n",
       "      <td>132</td>\n",
       "      <td>77</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>23.9</td>\n",
       "      <td>14.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>2188-11-13 06:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>63</td>\n",
       "      <td>93</td>\n",
       "      <td>37.6</td>\n",
       "      <td>8</td>\n",
       "      <td>138</td>\n",
       "      <td>74</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>23.9</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>2188-11-13 06:15:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>57</td>\n",
       "      <td>82</td>\n",
       "      <td>37.6</td>\n",
       "      <td>8</td>\n",
       "      <td>138</td>\n",
       "      <td>66</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>23.9</td>\n",
       "      <td>14.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>2188-11-13 06:30:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>62</td>\n",
       "      <td>90</td>\n",
       "      <td>36.4444</td>\n",
       "      <td>8</td>\n",
       "      <td>135</td>\n",
       "      <td>73</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>23.9</td>\n",
       "      <td>21.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>2188-11-13 06:45:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>63</td>\n",
       "      <td>90</td>\n",
       "      <td>36.4444</td>\n",
       "      <td>8</td>\n",
       "      <td>135</td>\n",
       "      <td>73</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>23.9</td>\n",
       "      <td>26.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>2188-11-13 07:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>63</td>\n",
       "      <td>89</td>\n",
       "      <td>36.4444</td>\n",
       "      <td>8</td>\n",
       "      <td>135</td>\n",
       "      <td>73</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>23.9</td>\n",
       "      <td>27.6667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>2188-11-13 07:05:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>62</td>\n",
       "      <td>88</td>\n",
       "      <td>36.4444</td>\n",
       "      <td>8</td>\n",
       "      <td>136</td>\n",
       "      <td>72</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>23.9</td>\n",
       "      <td>33.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>2188-11-13 08:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>67</td>\n",
       "      <td>94</td>\n",
       "      <td>97.7</td>\n",
       "      <td>3</td>\n",
       "      <td>140</td>\n",
       "      <td>77</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>23.9</td>\n",
       "      <td>33.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>2188-11-13 08:13:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>67</td>\n",
       "      <td>94</td>\n",
       "      <td>97.7</td>\n",
       "      <td>3</td>\n",
       "      <td>140</td>\n",
       "      <td>77</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>23.9</td>\n",
       "      <td>27.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>2188-11-13 08:15:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>52</td>\n",
       "      <td>72</td>\n",
       "      <td>97.7</td>\n",
       "      <td>3</td>\n",
       "      <td>134</td>\n",
       "      <td>58</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>23.9</td>\n",
       "      <td>27.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>2188-11-13 08:25:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>52</td>\n",
       "      <td>73</td>\n",
       "      <td>97.7</td>\n",
       "      <td>3</td>\n",
       "      <td>133</td>\n",
       "      <td>59</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>23.9</td>\n",
       "      <td>27.3333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>2188-11-13 08:30:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>51</td>\n",
       "      <td>71</td>\n",
       "      <td>97.7</td>\n",
       "      <td>3</td>\n",
       "      <td>133</td>\n",
       "      <td>58</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>23.9</td>\n",
       "      <td>28.4286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>2188-11-13 08:40:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>53</td>\n",
       "      <td>74</td>\n",
       "      <td>97.7</td>\n",
       "      <td>3</td>\n",
       "      <td>134</td>\n",
       "      <td>60</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>23.9</td>\n",
       "      <td>29.5714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>2188-11-13 08:45:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>56</td>\n",
       "      <td>80</td>\n",
       "      <td>97.7</td>\n",
       "      <td>3</td>\n",
       "      <td>136</td>\n",
       "      <td>65</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>23.9</td>\n",
       "      <td>30.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>2188-11-13 08:50:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>55</td>\n",
       "      <td>79</td>\n",
       "      <td>97.7</td>\n",
       "      <td>3</td>\n",
       "      <td>132</td>\n",
       "      <td>64</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>23.9</td>\n",
       "      <td>30.625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>2188-11-13 08:53:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>55</td>\n",
       "      <td>79</td>\n",
       "      <td>36.5</td>\n",
       "      <td>3</td>\n",
       "      <td>132</td>\n",
       "      <td>64</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>23.9</td>\n",
       "      <td>31.1111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>2188-11-13 09:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>57</td>\n",
       "      <td>82</td>\n",
       "      <td>36.5</td>\n",
       "      <td>3</td>\n",
       "      <td>133</td>\n",
       "      <td>65</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>23.9</td>\n",
       "      <td>31.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>2188-11-13 09:15:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>53</td>\n",
       "      <td>74</td>\n",
       "      <td>98.2</td>\n",
       "      <td>3</td>\n",
       "      <td>133</td>\n",
       "      <td>60</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>23.9</td>\n",
       "      <td>31.1111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>2188-11-13 09:17:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>50</td>\n",
       "      <td>68</td>\n",
       "      <td>98.2</td>\n",
       "      <td>3</td>\n",
       "      <td>128</td>\n",
       "      <td>55</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>23.9</td>\n",
       "      <td>31.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>2188-11-13 09:25:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>54</td>\n",
       "      <td>72</td>\n",
       "      <td>98.2</td>\n",
       "      <td>3</td>\n",
       "      <td>127</td>\n",
       "      <td>60</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>23.9</td>\n",
       "      <td>31.8182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>2188-11-13 09:35:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>55</td>\n",
       "      <td>71</td>\n",
       "      <td>98.2</td>\n",
       "      <td>3</td>\n",
       "      <td>123</td>\n",
       "      <td>60</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>23.9</td>\n",
       "      <td>32.0833</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>2188-11-13 09:40:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>54</td>\n",
       "      <td>69</td>\n",
       "      <td>98.2</td>\n",
       "      <td>3</td>\n",
       "      <td>122</td>\n",
       "      <td>59</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>23.9</td>\n",
       "      <td>32.3077</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>2188-11-13 09:45:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>55</td>\n",
       "      <td>71</td>\n",
       "      <td>98.2</td>\n",
       "      <td>3</td>\n",
       "      <td>116</td>\n",
       "      <td>60</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>23.9</td>\n",
       "      <td>32.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>2188-11-13 09:50:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>52</td>\n",
       "      <td>66</td>\n",
       "      <td>98.2</td>\n",
       "      <td>3</td>\n",
       "      <td>114</td>\n",
       "      <td>57</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>23.9</td>\n",
       "      <td>32.6667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>2188-11-13 09:55:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>48</td>\n",
       "      <td>62</td>\n",
       "      <td>98.2</td>\n",
       "      <td>3</td>\n",
       "      <td>107</td>\n",
       "      <td>52</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>23.9</td>\n",
       "      <td>32.8125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>2188-11-13 10:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>62063368</td>\n",
       "      <td>50</td>\n",
       "      <td>66</td>\n",
       "      <td>98.2</td>\n",
       "      <td>3</td>\n",
       "      <td>102</td>\n",
       "      <td>55</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>23.9</td>\n",
       "      <td>32.9412</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>73 rows × 113 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   measurement_datetime  target  super_target  person_id BP diastolic  \\\n",
       "3   2188-11-12 10:30:00       0             1   62063368           95   \n",
       "4   2188-11-12 10:45:00       0             1   62063368           97   \n",
       "5   2188-11-12 11:00:00       0             1   62063368           91   \n",
       "6   2188-11-12 12:00:00       0             1   62063368           98   \n",
       "7   2188-11-12 13:00:00       0             1   62063368          108   \n",
       "8   2188-11-12 13:03:00       0             1   62063368          108   \n",
       "9   2188-11-12 13:30:00       0             1   62063368          105   \n",
       "10  2188-11-12 14:00:00       0             1   62063368          107   \n",
       "11  2188-11-12 14:45:00       0             1   62063368          101   \n",
       "12  2188-11-12 15:00:00       0             1   62063368          100   \n",
       "13  2188-11-12 15:30:00       0             1   62063368          110   \n",
       "14  2188-11-12 16:00:00       0             1   62063368          122   \n",
       "15  2188-11-12 16:10:00       0             1   62063368          122   \n",
       "16  2188-11-12 17:00:00       0             1   62063368           78   \n",
       "17  2188-11-12 18:00:00       0             1   62063368           84   \n",
       "18  2188-11-12 18:15:00       0             1   62063368           70   \n",
       "19  2188-11-12 18:30:00       0             1   62063368           62   \n",
       "20  2188-11-12 19:00:00       0             1   62063368           79   \n",
       "21  2188-11-12 20:00:00       0             1   62063368           61   \n",
       "22  2188-11-12 20:36:00       0             1   62063368           61   \n",
       "23  2188-11-12 21:00:00       0             1   62063368           73   \n",
       "24  2188-11-12 21:16:00       0             1   62063368           73   \n",
       "25  2188-11-12 22:00:00       0             1   62063368           79   \n",
       "26  2188-11-12 22:04:00       0             1   62063368           79   \n",
       "27  2188-11-12 23:00:00       0             1   62063368           82   \n",
       "28  2188-11-12 23:37:00       0             1   62063368           82   \n",
       "29  2188-11-13 00:00:00       0             1   62063368           61   \n",
       "30  2188-11-13 00:30:00       0             1   62063368           62   \n",
       "31  2188-11-13 01:00:00       0             1   62063368           77   \n",
       "32  2188-11-13 01:30:00       0             1   62063368           96   \n",
       "..                  ...     ...           ...        ...          ...   \n",
       "46  2188-11-13 04:08:00       0             1   62063368           54   \n",
       "47  2188-11-13 04:15:00       0             1   62063368           58   \n",
       "48  2188-11-13 04:30:00       0             1   62063368           61   \n",
       "49  2188-11-13 05:00:00       0             1   62063368           64   \n",
       "50  2188-11-13 05:49:00       0             1   62063368           64   \n",
       "51  2188-11-13 06:00:00       0             1   62063368           63   \n",
       "52  2188-11-13 06:15:00       0             1   62063368           57   \n",
       "53  2188-11-13 06:30:00       0             1   62063368           62   \n",
       "54  2188-11-13 06:45:00       0             1   62063368           63   \n",
       "55  2188-11-13 07:00:00       0             1   62063368           63   \n",
       "56  2188-11-13 07:05:00       0             1   62063368           62   \n",
       "57  2188-11-13 08:00:00       0             1   62063368           67   \n",
       "58  2188-11-13 08:13:00       0             1   62063368           67   \n",
       "59  2188-11-13 08:15:00       0             1   62063368           52   \n",
       "60  2188-11-13 08:25:00       0             1   62063368           52   \n",
       "61  2188-11-13 08:30:00       0             1   62063368           51   \n",
       "62  2188-11-13 08:40:00       0             1   62063368           53   \n",
       "63  2188-11-13 08:45:00       0             1   62063368           56   \n",
       "64  2188-11-13 08:50:00       0             1   62063368           55   \n",
       "65  2188-11-13 08:53:00       0             1   62063368           55   \n",
       "66  2188-11-13 09:00:00       0             1   62063368           57   \n",
       "67  2188-11-13 09:15:00       0             1   62063368           53   \n",
       "68  2188-11-13 09:17:00       0             1   62063368           50   \n",
       "69  2188-11-13 09:25:00       0             1   62063368           54   \n",
       "70  2188-11-13 09:35:00       0             1   62063368           55   \n",
       "71  2188-11-13 09:40:00       0             1   62063368           54   \n",
       "72  2188-11-13 09:45:00       0             1   62063368           55   \n",
       "73  2188-11-13 09:50:00       0             1   62063368           52   \n",
       "74  2188-11-13 09:55:00       0             1   62063368           48   \n",
       "75  2188-11-13 10:00:00       0             1   62063368           50   \n",
       "\n",
       "   BP systolic Body temperature Glasgow coma scale Heart rate  \\\n",
       "3          140          36.3889                 15        134   \n",
       "4          144          36.3889                 15        134   \n",
       "5          140          36.3889                 15        134   \n",
       "6          139             97.6                 15        135   \n",
       "7          158          36.6667                 15        134   \n",
       "8          158             36.7                 15        134   \n",
       "9          159             36.7                 15        134   \n",
       "10         157             36.7                 15        137   \n",
       "11         149             36.7                 15        147   \n",
       "12         147             36.7                 15        146   \n",
       "13         154             36.7                 15        144   \n",
       "14         171             36.7                 15        134   \n",
       "15         171             36.7                 15        134   \n",
       "16         116             36.7                 15        142   \n",
       "17         136             36.7                 15        129   \n",
       "18         122             36.7                 15        127   \n",
       "19         109             36.7                 15        127   \n",
       "20         130             36.7                 15        123   \n",
       "21         109          37.9444                 10        135   \n",
       "22         109             37.9                 10        135   \n",
       "23         125             37.9                 10        135   \n",
       "24         125             37.9                 10        135   \n",
       "25         134               39                 10        137   \n",
       "26         134             37.8                 10        137   \n",
       "27         135             37.8                 10        151   \n",
       "28         135               39                 10        151   \n",
       "29         102          38.6667                  9        147   \n",
       "30          98          38.6667                  9        140   \n",
       "31         121          38.6667                  9        141   \n",
       "32         142          38.6667                  9        133   \n",
       "..         ...              ...                ...        ...   \n",
       "46          85             96.1                  8        122   \n",
       "47          90          35.8333                  8        125   \n",
       "48          94          35.5556                  8        126   \n",
       "49          99          35.5556                  8        132   \n",
       "50          99             37.6                  8        132   \n",
       "51          93             37.6                  8        138   \n",
       "52          82             37.6                  8        138   \n",
       "53          90          36.4444                  8        135   \n",
       "54          90          36.4444                  8        135   \n",
       "55          89          36.4444                  8        135   \n",
       "56          88          36.4444                  8        136   \n",
       "57          94             97.7                  3        140   \n",
       "58          94             97.7                  3        140   \n",
       "59          72             97.7                  3        134   \n",
       "60          73             97.7                  3        133   \n",
       "61          71             97.7                  3        133   \n",
       "62          74             97.7                  3        134   \n",
       "63          80             97.7                  3        136   \n",
       "64          79             97.7                  3        132   \n",
       "65          79             36.5                  3        132   \n",
       "66          82             36.5                  3        133   \n",
       "67          74             98.2                  3        133   \n",
       "68          68             98.2                  3        128   \n",
       "69          72             98.2                  3        127   \n",
       "70          71             98.2                  3        123   \n",
       "71          69             98.2                  3        122   \n",
       "72          71             98.2                  3        116   \n",
       "73          66             98.2                  3        114   \n",
       "74          62             98.2                  3        107   \n",
       "75          66             98.2                  3        102   \n",
       "\n",
       "   Mean blood pressure            ...            race_UNABLE TO OBTAIN  \\\n",
       "3                  110            ...                                0   \n",
       "4              112.667            ...                                0   \n",
       "5              107.333            ...                                0   \n",
       "6              111.667            ...                                0   \n",
       "7              124.667            ...                                0   \n",
       "8              124.667            ...                                0   \n",
       "9                  123            ...                                0   \n",
       "10             123.667            ...                                0   \n",
       "11                 117            ...                                0   \n",
       "12             115.667            ...                                0   \n",
       "13             124.667            ...                                0   \n",
       "14             138.333            ...                                0   \n",
       "15             138.333            ...                                0   \n",
       "16                  80            ...                                0   \n",
       "17                 102            ...                                0   \n",
       "18                  88            ...                                0   \n",
       "19                  78            ...                                0   \n",
       "20                  95            ...                                0   \n",
       "21                  77            ...                                0   \n",
       "22                  77            ...                                0   \n",
       "23                  90            ...                                0   \n",
       "24                  90            ...                                0   \n",
       "25                  97            ...                                0   \n",
       "26                  97            ...                                0   \n",
       "27                  99            ...                                0   \n",
       "28                  99            ...                                0   \n",
       "29                  75            ...                                0   \n",
       "30                  74            ...                                0   \n",
       "31                  92            ...                                0   \n",
       "32                 111            ...                                0   \n",
       "..                 ...            ...                              ...   \n",
       "46                  65            ...                                0   \n",
       "47                  70            ...                                0   \n",
       "48                  73            ...                                0   \n",
       "49                  77            ...                                0   \n",
       "50                  77            ...                                0   \n",
       "51                  74            ...                                0   \n",
       "52                  66            ...                                0   \n",
       "53                  73            ...                                0   \n",
       "54                  73            ...                                0   \n",
       "55                  73            ...                                0   \n",
       "56                  72            ...                                0   \n",
       "57                  77            ...                                0   \n",
       "58                  77            ...                                0   \n",
       "59                  58            ...                                0   \n",
       "60                  59            ...                                0   \n",
       "61                  58            ...                                0   \n",
       "62                  60            ...                                0   \n",
       "63                  65            ...                                0   \n",
       "64                  64            ...                                0   \n",
       "65                  64            ...                                0   \n",
       "66                  65            ...                                0   \n",
       "67                  60            ...                                0   \n",
       "68                  55            ...                                0   \n",
       "69                  60            ...                                0   \n",
       "70                  60            ...                                0   \n",
       "71                  59            ...                                0   \n",
       "72                  60            ...                                0   \n",
       "73                  57            ...                                0   \n",
       "74                  52            ...                                0   \n",
       "75                  55            ...                                0   \n",
       "\n",
       "   race_UNKNOWN/NOT SPECIFIED race_WHITE race_WHITE - BRAZILIAN  \\\n",
       "3                           0          0                      0   \n",
       "4                           0          0                      0   \n",
       "5                           0          0                      0   \n",
       "6                           0          0                      0   \n",
       "7                           0          0                      0   \n",
       "8                           0          0                      0   \n",
       "9                           0          0                      0   \n",
       "10                          0          0                      0   \n",
       "11                          0          0                      0   \n",
       "12                          0          0                      0   \n",
       "13                          0          0                      0   \n",
       "14                          0          0                      0   \n",
       "15                          0          0                      0   \n",
       "16                          0          0                      0   \n",
       "17                          0          0                      0   \n",
       "18                          0          0                      0   \n",
       "19                          0          0                      0   \n",
       "20                          0          0                      0   \n",
       "21                          0          0                      0   \n",
       "22                          0          0                      0   \n",
       "23                          0          0                      0   \n",
       "24                          0          0                      0   \n",
       "25                          0          0                      0   \n",
       "26                          0          0                      0   \n",
       "27                          0          0                      0   \n",
       "28                          0          0                      0   \n",
       "29                          0          0                      0   \n",
       "30                          0          0                      0   \n",
       "31                          0          0                      0   \n",
       "32                          0          0                      0   \n",
       "..                        ...        ...                    ...   \n",
       "46                          0          0                      0   \n",
       "47                          0          0                      0   \n",
       "48                          0          0                      0   \n",
       "49                          0          0                      0   \n",
       "50                          0          0                      0   \n",
       "51                          0          0                      0   \n",
       "52                          0          0                      0   \n",
       "53                          0          0                      0   \n",
       "54                          0          0                      0   \n",
       "55                          0          0                      0   \n",
       "56                          0          0                      0   \n",
       "57                          0          0                      0   \n",
       "58                          0          0                      0   \n",
       "59                          0          0                      0   \n",
       "60                          0          0                      0   \n",
       "61                          0          0                      0   \n",
       "62                          0          0                      0   \n",
       "63                          0          0                      0   \n",
       "64                          0          0                      0   \n",
       "65                          0          0                      0   \n",
       "66                          0          0                      0   \n",
       "67                          0          0                      0   \n",
       "68                          0          0                      0   \n",
       "69                          0          0                      0   \n",
       "70                          0          0                      0   \n",
       "71                          0          0                      0   \n",
       "72                          0          0                      0   \n",
       "73                          0          0                      0   \n",
       "74                          0          0                      0   \n",
       "75                          0          0                      0   \n",
       "\n",
       "    race_WHITE - EASTERN EUROPEAN  race_WHITE - OTHER EUROPEAN  \\\n",
       "3                               0                            0   \n",
       "4                               0                            0   \n",
       "5                               0                            0   \n",
       "6                               0                            0   \n",
       "7                               0                            0   \n",
       "8                               0                            0   \n",
       "9                               0                            0   \n",
       "10                              0                            0   \n",
       "11                              0                            0   \n",
       "12                              0                            0   \n",
       "13                              0                            0   \n",
       "14                              0                            0   \n",
       "15                              0                            0   \n",
       "16                              0                            0   \n",
       "17                              0                            0   \n",
       "18                              0                            0   \n",
       "19                              0                            0   \n",
       "20                              0                            0   \n",
       "21                              0                            0   \n",
       "22                              0                            0   \n",
       "23                              0                            0   \n",
       "24                              0                            0   \n",
       "25                              0                            0   \n",
       "26                              0                            0   \n",
       "27                              0                            0   \n",
       "28                              0                            0   \n",
       "29                              0                            0   \n",
       "30                              0                            0   \n",
       "31                              0                            0   \n",
       "32                              0                            0   \n",
       "..                            ...                          ...   \n",
       "46                              0                            0   \n",
       "47                              0                            0   \n",
       "48                              0                            0   \n",
       "49                              0                            0   \n",
       "50                              0                            0   \n",
       "51                              0                            0   \n",
       "52                              0                            0   \n",
       "53                              0                            0   \n",
       "54                              0                            0   \n",
       "55                              0                            0   \n",
       "56                              0                            0   \n",
       "57                              0                            0   \n",
       "58                              0                            0   \n",
       "59                              0                            0   \n",
       "60                              0                            0   \n",
       "61                              0                            0   \n",
       "62                              0                            0   \n",
       "63                              0                            0   \n",
       "64                              0                            0   \n",
       "65                              0                            0   \n",
       "66                              0                            0   \n",
       "67                              0                            0   \n",
       "68                              0                            0   \n",
       "69                              0                            0   \n",
       "70                              0                            0   \n",
       "71                              0                            0   \n",
       "72                              0                            0   \n",
       "73                              0                            0   \n",
       "74                              0                            0   \n",
       "75                              0                            0   \n",
       "\n",
       "    race_WHITE - RUSSIAN  race_NaN   age  Respiratory rate avg h-2  \n",
       "3                      0         0  23.9                        38  \n",
       "4                      0         0  23.9                        36  \n",
       "5                      0         0  23.9                   37.6667  \n",
       "6                      0         0  23.9                     38.25  \n",
       "7                      0         0  23.9                        39  \n",
       "8                      0         0  23.9                        35  \n",
       "9                      0         0  23.9                        35  \n",
       "10                     0         0  23.9                   33.6667  \n",
       "11                     0         0  23.9                   32.3333  \n",
       "12                     0         0  23.9                     34.75  \n",
       "13                     0         0  23.9                     36.75  \n",
       "14                     0         0  23.9                     38.75  \n",
       "15                     0         0  23.9                     39.25  \n",
       "16                     0         0  23.9                      34.5  \n",
       "17                     0         0  23.9                   25.6667  \n",
       "18                     0         0  23.9                      19.5  \n",
       "19                     0         0  23.9                   21.3333  \n",
       "20                     0         0  23.9                        22  \n",
       "21                     0         0  23.9                     21.75  \n",
       "22                     0         0  23.9                        20  \n",
       "23                     0         0  23.9                   16.6667  \n",
       "24                     0         0  23.9                        19  \n",
       "25                     0         0  23.9                      15.5  \n",
       "26                     0         0  23.9                     16.25  \n",
       "27                     0         0  23.9                   15.4167  \n",
       "28                     0         0  23.9                   14.2222  \n",
       "29                     0         0  23.9                   18.1667  \n",
       "30                     0         0  23.9                   25.3333  \n",
       "31                     0         0  23.9                        28  \n",
       "32                     0         0  23.9                     32.75  \n",
       "..                   ...       ...   ...                       ...  \n",
       "46                     0         0  23.9                   29.0833  \n",
       "47                     0         0  23.9                   29.0833  \n",
       "48                     0         0  23.9                   26.3333  \n",
       "49                     0         0  23.9                        26  \n",
       "50                     0         0  23.9                      14.2  \n",
       "51                     0         0  23.9                        14  \n",
       "52                     0         0  23.9                      14.2  \n",
       "53                     0         0  23.9                      21.4  \n",
       "54                     0         0  23.9                      26.8  \n",
       "55                     0         0  23.9                   27.6667  \n",
       "56                     0         0  23.9                      33.5  \n",
       "57                     0         0  23.9                      33.5  \n",
       "58                     0         0  23.9                      27.5  \n",
       "59                     0         0  23.9                      27.5  \n",
       "60                     0         0  23.9                   27.3333  \n",
       "61                     0         0  23.9                   28.4286  \n",
       "62                     0         0  23.9                   29.5714  \n",
       "63                     0         0  23.9                     30.25  \n",
       "64                     0         0  23.9                    30.625  \n",
       "65                     0         0  23.9                   31.1111  \n",
       "66                     0         0  23.9                      31.5  \n",
       "67                     0         0  23.9                   31.1111  \n",
       "68                     0         0  23.9                      31.5  \n",
       "69                     0         0  23.9                   31.8182  \n",
       "70                     0         0  23.9                   32.0833  \n",
       "71                     0         0  23.9                   32.3077  \n",
       "72                     0         0  23.9                      32.5  \n",
       "73                     0         0  23.9                   32.6667  \n",
       "74                     0         0  23.9                   32.8125  \n",
       "75                     0         0  23.9                   32.9412  \n",
       "\n",
       "[73 rows x 113 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dataloaders[patients_id[0]].get_batch(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.5"
  },
  "latex_envs": {
   "LaTeX_envs_menu_present": true,
   "autoclose": false,
   "autocomplete": true,
   "bibliofile": "biblio.bib",
   "cite_by": "apalike",
   "current_citInitial": 1,
   "eqLabelWithNumbers": true,
   "eqNumInitial": 1,
   "hotkeys": {
    "equation": "Ctrl-E",
    "itemize": "Ctrl-I"
   },
   "labels_anchors": false,
   "latex_user_defs": false,
   "report_style_numbering": false,
   "user_envs_cfg": false
  },
  "toc": {
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": "block",
   "toc_window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}