Downloads: 1
[418e14]:
/
0_LOINC_and_Definitions.ipynb
8131 lines (8130 with data), 299.2 kB
{
"cells": [
{
"cell_type": "code",
"execution_count": 2,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"from IPython.display import display, HTML"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Background\n",
"\n",
"\"LOINC is a common language (set of identifiers, names, and codes) for identifying health measurements, observations, and documents. If you think of an observation as a \"question\" and the observation result value as an \"answer.\" (https://loinc.org/)\n",
"\n",
"We have a version of loinc included in this project, however it is not guaranteed to be the most up to date set of codes. \n",
"\n",
"To download LOINC and set it up to run with this notebook:\n",
"\n",
"**You will need to make an account at https://loinc.org/ to download the files.**\n",
"\n",
"1. Go to https://loinc.org/downloads/loinc/ \n",
"2. Download \"LOINC Table File (CSV)\" \n",
"3. Go to https://loinc.org/downloads/accessory-files/\n",
"4. Download \"LOINC Panels and Forms File\"\n",
"5. Unzip both of these into the same directory (./loinc is default for this code)\n",
"6. Update directory path below to point to their location\n",
"\n",
"The code below will set up LOINC as a psql database. Enjoy!"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"loinc_directory = 'loinc'\n",
"psql_username = 'postgres'\n",
"psql_password = '123'\n",
"loinc_dbname = 'loinc'"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"import loinc\n",
"dbm = loinc.LOINC_db_manager(psql_username, psql_password, loinc_dbname)"
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {
"collapsed": false
},
"outputs": [
{
"name": "stderr",
"output_type": "stream",
"text": [
"C:\\Users\\genkinjz\\AppData\\Local\\Continuum\\Anaconda2\\lib\\site-packages\\IPython\\core\\interactiveshell.py:2825: DtypeWarning: Columns (8,15,17,18,25,26,39,40,41,42,43,44,45) have mixed types. Specify dtype option on import or set low_memory=False.\n",
" if self.run_code(code, result):\n"
]
}
],
"source": [
"dbm.db_create()\n",
"dbm.add_loinc_tables(loinc_directory)\n",
"dbm.add_panels(loinc_directory)\n",
"dbm.add_indicies()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"You should now have a PSQL database set up for LOINC on your system. Lets test it out!"
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"import pandas as pd\n",
"from utils import psql_connect"
]
},
{
"cell_type": "code",
"execution_count": 7,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>loinc_num</th>\n",
" <th>component</th>\n",
" <th>property</th>\n",
" <th>time_aspct</th>\n",
" <th>system</th>\n",
" <th>scale_typ</th>\n",
" <th>method_typ</th>\n",
" <th>class</th>\n",
" <th>versionlastchanged</th>\n",
" <th>chng_type</th>\n",
" <th>...</th>\n",
" <th>common_test_rank</th>\n",
" <th>common_order_rank</th>\n",
" <th>common_si_test_rank</th>\n",
" <th>hl7_attachment_structure</th>\n",
" <th>external_copyright_link</th>\n",
" <th>paneltype</th>\n",
" <th>askatorderentry</th>\n",
" <th>associatedobservations</th>\n",
" <th>versionfirstreleased</th>\n",
" <th>validhl7attachmentrequest</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>10032-1</td>\n",
" <td>R' wave duration.lead V5</td>\n",
" <td>Time</td>\n",
" <td>Pt</td>\n",
" <td>Heart</td>\n",
" <td>Qn</td>\n",
" <td>EKG</td>\n",
" <td>EKG.MEAS</td>\n",
" <td>2.48</td>\n",
" <td>MIN</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>1.0i</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>1003-3</td>\n",
" <td>Indirect antiglobulin test.complement specific...</td>\n",
" <td>PrThr</td>\n",
" <td>Pt</td>\n",
" <td>Ser/Plas</td>\n",
" <td>Ord</td>\n",
" <td>None</td>\n",
" <td>BLDBK</td>\n",
" <td>2.56</td>\n",
" <td>MIN</td>\n",
" <td>...</td>\n",
" <td>227</td>\n",
" <td>108</td>\n",
" <td>227</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>1.0</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>10033-9</td>\n",
" <td>R' wave duration.lead V6</td>\n",
" <td>Time</td>\n",
" <td>Pt</td>\n",
" <td>Heart</td>\n",
" <td>Qn</td>\n",
" <td>EKG</td>\n",
" <td>EKG.MEAS</td>\n",
" <td>2.48</td>\n",
" <td>MIN</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>1.0i</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>10034-7</td>\n",
" <td>S wave amplitude.lead AVF</td>\n",
" <td>Elpot</td>\n",
" <td>Pt</td>\n",
" <td>Heart</td>\n",
" <td>Qn</td>\n",
" <td>EKG</td>\n",
" <td>EKG.MEAS</td>\n",
" <td>2.48</td>\n",
" <td>MIN</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>1.0i</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>10035-4</td>\n",
" <td>S wave amplitude.lead AVL</td>\n",
" <td>Elpot</td>\n",
" <td>Pt</td>\n",
" <td>Heart</td>\n",
" <td>Qn</td>\n",
" <td>EKG</td>\n",
" <td>EKG.MEAS</td>\n",
" <td>2.48</td>\n",
" <td>MIN</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>1.0i</td>\n",
" <td>None</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>5 rows × 46 columns</p>\n",
"</div>"
],
"text/plain": [
" loinc_num component property \\\n",
"0 10032-1 R' wave duration.lead V5 Time \n",
"1 1003-3 Indirect antiglobulin test.complement specific... PrThr \n",
"2 10033-9 R' wave duration.lead V6 Time \n",
"3 10034-7 S wave amplitude.lead AVF Elpot \n",
"4 10035-4 S wave amplitude.lead AVL Elpot \n",
"\n",
" time_aspct system scale_typ method_typ class versionlastchanged \\\n",
"0 Pt Heart Qn EKG EKG.MEAS 2.48 \n",
"1 Pt Ser/Plas Ord None BLDBK 2.56 \n",
"2 Pt Heart Qn EKG EKG.MEAS 2.48 \n",
"3 Pt Heart Qn EKG EKG.MEAS 2.48 \n",
"4 Pt Heart Qn EKG EKG.MEAS 2.48 \n",
"\n",
" chng_type ... common_test_rank common_order_rank \\\n",
"0 MIN ... 0 0 \n",
"1 MIN ... 227 108 \n",
"2 MIN ... 0 0 \n",
"3 MIN ... 0 0 \n",
"4 MIN ... 0 0 \n",
"\n",
" common_si_test_rank hl7_attachment_structure external_copyright_link \\\n",
"0 0 None None \n",
"1 227 None None \n",
"2 0 None None \n",
"3 0 None None \n",
"4 0 None None \n",
"\n",
" paneltype askatorderentry associatedobservations versionfirstreleased \\\n",
"0 None None None 1.0i \n",
"1 None None None 1.0 \n",
"2 None None None 1.0i \n",
"3 None None None 1.0i \n",
"4 None None None 1.0i \n",
"\n",
" validhl7attachmentrequest \n",
"0 None \n",
"1 None \n",
"2 None \n",
"3 None \n",
"4 None \n",
"\n",
"[5 rows x 46 columns]"
]
},
"execution_count": 7,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"conn = psql_connect(psql_username, psql_password, loinc_dbname)\n",
"df_loincs = pd.read_sql_query('SELECT * FROM loinc',conn)\n",
"df_loincs.head(5)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Mapping MIMIC-III items to LOINC codes\n",
"\n",
"Clearly, the information held in each LOINC number is useful if we can use that to identify and qualify data in the mimic-iii database. The concept of label mapping between disparate clinical databases is not uncommon, and is in fact a perpetual frustration which drives the need for standardized coding databases such as LOINC. This is not simply for understanding retrospective data, but also for safe and accurate exchange of healthcare information between EMR systems in realtime.In this case, our goal is to map MIMIC-III itemids to LOINC codes, thereby allowing us to leverage the wealth of data living in the LOINC database to help categorize and clean MIMIC-III data. \n",
"\n",
"Fortunately. Some of this has already been accomplished by some pervious work in the area: **_Abhyankar, Swapna, Dina Demner-Fushman, and Clement J. McDonald. \"Standardizing clinical laboratory data for secondary use.\" Journal of biomedical informatics 45.4 (2012): 642-650. http://www.sciencedirect.com/science/article/pii/S1532046412000652_**\n",
"\n",
"In this paper, they \"were able to map 87% of the unique laboratory tests that cover 94% of the total number of laboratory tests results.\" This was done on the MIMIC-II database, and those mapped codes have now been permamnently added to the MIMIC-III database.\n",
"\n",
"Lets investigate!"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Observations vs. Interventions\n",
"\n",
"First, it is important to acknowledge the limitations of LOINC in the context of this project. We are using 2 different types of data - observational data, and intervention data. LOINC is clearly purposed for the former and NOT the latter. Therefore, we will provide a utility to map as many of our observations as possible to the LOINC definitions, and, when not possible or when the desired data comes from an intervention, we will provide information ourselves on how this should look."
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Observations: LOINC"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Our basic process for this:\n",
"1. Search for the best LOINC via https://search.loinc.org/\n",
"2. Add that to our database"
]
},
{
"cell_type": "code",
"execution_count": 404,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"import definitions\n",
"import pandas as pd\n",
"import utils\n",
"import mimic_explorer\n",
"import uom\n",
"import constants"
]
},
{
"cell_type": "code",
"execution_count": 410,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"reload(definitions)\n",
"reload(utils)\n",
"defs_hdf5_fname = 'config/definitions'\n",
"loinc_accesor = definitions.loinc_accessor('postgres','123','loinc')\n",
"builder = definitions.builder(defs_hdf5_fname,[loinc_accesor])"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Start with **vital signs**. Will be using LOINC panel 34565-2 (\"Vital signs, weight and height panel\") as a point of reference\n",
"\n",
"https://r.details.loinc.org/LOINC/34565-2.html?sections=Comprehensive\n",
"\n",
"Normal range: https://medlineplus.gov/ency/article/002341.htm\n"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"component = \n",
"units = \n",
"upper_limit =\n",
"lower_limit =\n",
"variable_type = \n",
"clinical_source =\n",
"category_list =\n",
"standard_db_name =\n",
"standard_db_id ="
]
},
{
"cell_type": "code",
"execution_count": 411,
"metadata": {
"collapsed": false
},
"outputs": [
{
"name": "stderr",
"output_type": "stream",
"text": [
"definitions.py:86: PerformanceWarning: \n",
"your performance may suffer as PyTables will pickle object types that it cannot\n",
"map directly to c-types [inferred_type->mixed-integer,key->block0_values] [items->['component', 'units', 'variable_type', 'clinical_source', 'category_list_id', 'reference_id', 'reference_db']]\n",
"\n",
" def remove(self,component,units):\n",
"definitions.py:79: PerformanceWarning: \n",
"your performance may suffer as PyTables will pickle object types that it cannot\n",
"map directly to c-types [inferred_type->mixed-integer,key->block0_values] [items->['component', 'units', 'variable_type', 'clinical_source', 'category_list_id', 'reference_id', 'reference_db']]\n",
"\n",
" self.df = pd.concat([self.df,new_row])\n"
]
}
],
"source": [
"var_type=constants.variable_type.QUANTITATIVE,\n",
"source_type=constants.clinical_source.OBSERVATION\n",
"\n",
"\n",
"#Heart Rate - 8867-4\n",
"builder.add_standard('8867-4','loinc',component='Heart Rate',units='beats/min')\n",
"\n",
"#Systolic Blood Pressure - 8480-6\n",
"builder.add_standard('8480-6','loinc',component='Systolic Blood Pressure',units='mmHg')\n",
"\n",
"#Diastolic Blood Pressure - 8462-4\n",
"builder.add_standard('8462-4','loinc',component='Diastolic Blood Pressure',units='mmHg')\n",
"\n",
"#Respiratory Rate - 9279-1 \n",
"builder.add_standard('9279-1','loinc',component='Respiratory Rate',units='insp/min')\n",
"\n",
"#Temperature - 8310-5 \n",
"builder.add_standard('8310-5','loinc',component='Temperature',units='DegC')\n",
"\n",
"builder.add(component='Temperature',units='DegF',\n",
" var_type=constants.variable_type.QUANTITATIVE,\n",
" source_type=constants.clinical_source.OBSERVATION\n",
" )\n",
"\n",
"#O2Sat - 59408-5\n",
"builder.add_standard('59408-5','loinc',component='Oxygen Saturation',units='percent')"
]
},
{
"cell_type": "code",
"execution_count": 412,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>component</th>\n",
" <th>units</th>\n",
" <th>variable_type</th>\n",
" <th>clinical_source</th>\n",
" <th>category_list_id</th>\n",
" <th>reference_id</th>\n",
" <th>reference_db</th>\n",
" <th>component_id</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>Heart rate</td>\n",
" <td>beat / min</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>8867-4</td>\n",
" <td>loinc</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>Intravascular systolic</td>\n",
" <td>mmHg</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>8480-6</td>\n",
" <td>loinc</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>Intravascular diastolic</td>\n",
" <td>mmHg</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>8462-4</td>\n",
" <td>loinc</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>Breaths</td>\n",
" <td>br / min</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>9279-1</td>\n",
" <td>loinc</td>\n",
" <td>3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>Body temperature</td>\n",
" <td>celsius</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>8310-5</td>\n",
" <td>loinc</td>\n",
" <td>4</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>Oxygen saturation</td>\n",
" <td>percent</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>59408-5</td>\n",
" <td>loinc</td>\n",
" <td>5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>Body weight</td>\n",
" <td>lb</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>29463-7</td>\n",
" <td>loinc</td>\n",
" <td>6</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>Body weight</td>\n",
" <td>kg</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>29463-7</td>\n",
" <td>loinc</td>\n",
" <td>7</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>Fluid output.urine</td>\n",
" <td>cubic_centimeter</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>9187-6</td>\n",
" <td>loinc</td>\n",
" <td>8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>Fluid output.urine</td>\n",
" <td>ml / h</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>9188-4</td>\n",
" <td>loinc</td>\n",
" <td>9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>Urine output</td>\n",
" <td>ml / hr / kg</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>local</td>\n",
" <td>10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>Glasgow coma score.motor</td>\n",
" <td></td>\n",
" <td>Ord</td>\n",
" <td>observation</td>\n",
" <td>0</td>\n",
" <td>9268-4</td>\n",
" <td>loinc</td>\n",
" <td>11</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>Glasgow coma score.verbal</td>\n",
" <td></td>\n",
" <td>Ord</td>\n",
" <td>observation</td>\n",
" <td>1</td>\n",
" <td>9270-0</td>\n",
" <td>loinc</td>\n",
" <td>12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>Glasgow coma score.eye opening</td>\n",
" <td></td>\n",
" <td>Ord</td>\n",
" <td>observation</td>\n",
" <td>2</td>\n",
" <td>9267-6</td>\n",
" <td>loinc</td>\n",
" <td>13</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>Norepinephrine</td>\n",
" <td>mg</td>\n",
" <td>Qn</td>\n",
" <td>intervention</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>local</td>\n",
" <td>14</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>Norepinephrine</td>\n",
" <td>mcg</td>\n",
" <td>Qn</td>\n",
" <td>intervention</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>local</td>\n",
" <td>15</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>Norepinephrine</td>\n",
" <td>mcg / min</td>\n",
" <td>Qn</td>\n",
" <td>intervention</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>local</td>\n",
" <td>16</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>Norepinephrine</td>\n",
" <td>mcg / kg / min</td>\n",
" <td>Qn</td>\n",
" <td>intervention</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>local</td>\n",
" <td>17</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>Vasopressin</td>\n",
" <td>ml</td>\n",
" <td>Qn</td>\n",
" <td>intervention</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>local</td>\n",
" <td>18</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>Vasopressin</td>\n",
" <td>U</td>\n",
" <td>Qn</td>\n",
" <td>intervention</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>local</td>\n",
" <td>19</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>Vasopressin</td>\n",
" <td>U / min</td>\n",
" <td>Qn</td>\n",
" <td>intervention</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>local</td>\n",
" <td>20</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>Vasopressin</td>\n",
" <td>U / hr</td>\n",
" <td>Qn</td>\n",
" <td>intervention</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>local</td>\n",
" <td>21</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>Normal Saline</td>\n",
" <td>ml</td>\n",
" <td>Qn</td>\n",
" <td>intervention</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>local</td>\n",
" <td>22</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>Normal Saline</td>\n",
" <td>l</td>\n",
" <td>Qn</td>\n",
" <td>intervention</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>local</td>\n",
" <td>23</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>Normal Saline</td>\n",
" <td>ml / min</td>\n",
" <td>Qn</td>\n",
" <td>intervention</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>local</td>\n",
" <td>24</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>Normal Saline</td>\n",
" <td>ml / hr</td>\n",
" <td>Qn</td>\n",
" <td>intervention</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>local</td>\n",
" <td>25</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>Lactated Ringers</td>\n",
" <td>ml</td>\n",
" <td>Qn</td>\n",
" <td>intervention</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>local</td>\n",
" <td>26</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>Lactated Ringers</td>\n",
" <td>l</td>\n",
" <td>Qn</td>\n",
" <td>intervention</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>local</td>\n",
" <td>27</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>Lactated Ringers</td>\n",
" <td>ml / min</td>\n",
" <td>Qn</td>\n",
" <td>intervention</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>local</td>\n",
" <td>28</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>Lactated Ringers</td>\n",
" <td>ml / hr</td>\n",
" <td>Qn</td>\n",
" <td>intervention</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>local</td>\n",
" <td>29</td>\n",
" </tr>\n",
" <tr>\n",
" <th>30</th>\n",
" <td>Lactate</td>\n",
" <td>mmol / l</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>32693-4</td>\n",
" <td>loinc</td>\n",
" <td>30</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31</th>\n",
" <td>Lactate</td>\n",
" <td>mg / dl</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>59032-3</td>\n",
" <td>loinc</td>\n",
" <td>31</td>\n",
" </tr>\n",
" <tr>\n",
" <th>32</th>\n",
" <td>Respiratory Rate</td>\n",
" <td>br / min</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>9279-1</td>\n",
" <td>loinc</td>\n",
" <td>55</td>\n",
" </tr>\n",
" <tr>\n",
" <th>33</th>\n",
" <td>Temperature</td>\n",
" <td>celsius</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>8310-5</td>\n",
" <td>loinc</td>\n",
" <td>56</td>\n",
" </tr>\n",
" <tr>\n",
" <th>34</th>\n",
" <td>Heart Rate</td>\n",
" <td>beat / min</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>8867-4</td>\n",
" <td>loinc</td>\n",
" <td>57</td>\n",
" </tr>\n",
" <tr>\n",
" <th>35</th>\n",
" <td>Respiratory Rate</td>\n",
" <td>insp / min</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>9279-1</td>\n",
" <td>loinc</td>\n",
" <td>60</td>\n",
" </tr>\n",
" <tr>\n",
" <th>36</th>\n",
" <td>Heart Rate</td>\n",
" <td>beats/min</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>8867-4</td>\n",
" <td>loinc</td>\n",
" <td>61</td>\n",
" </tr>\n",
" <tr>\n",
" <th>37</th>\n",
" <td>Systolic Blood Pressure</td>\n",
" <td>mmHg</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>8480-6</td>\n",
" <td>loinc</td>\n",
" <td>62</td>\n",
" </tr>\n",
" <tr>\n",
" <th>38</th>\n",
" <td>Diastolic Blood Pressure</td>\n",
" <td>mmHg</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>8462-4</td>\n",
" <td>loinc</td>\n",
" <td>63</td>\n",
" </tr>\n",
" <tr>\n",
" <th>39</th>\n",
" <td>Respiratory Rate</td>\n",
" <td>insp/min</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>9279-1</td>\n",
" <td>loinc</td>\n",
" <td>64</td>\n",
" </tr>\n",
" <tr>\n",
" <th>40</th>\n",
" <td>Temperature</td>\n",
" <td>DegC</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>8310-5</td>\n",
" <td>loinc</td>\n",
" <td>65</td>\n",
" </tr>\n",
" <tr>\n",
" <th>41</th>\n",
" <td>Temperature</td>\n",
" <td>DegF</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>local</td>\n",
" <td>66</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42</th>\n",
" <td>Oxygen Saturation</td>\n",
" <td>percent</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>59408-5</td>\n",
" <td>loinc</td>\n",
" <td>67</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" component units variable_type \\\n",
"0 Heart rate beat / min Qn \n",
"1 Intravascular systolic mmHg Qn \n",
"2 Intravascular diastolic mmHg Qn \n",
"3 Breaths br / min Qn \n",
"4 Body temperature celsius Qn \n",
"5 Oxygen saturation percent Qn \n",
"6 Body weight lb Qn \n",
"7 Body weight kg Qn \n",
"8 Fluid output.urine cubic_centimeter Qn \n",
"9 Fluid output.urine ml / h Qn \n",
"10 Urine output ml / hr / kg Qn \n",
"11 Glasgow coma score.motor Ord \n",
"12 Glasgow coma score.verbal Ord \n",
"13 Glasgow coma score.eye opening Ord \n",
"14 Norepinephrine mg Qn \n",
"15 Norepinephrine mcg Qn \n",
"16 Norepinephrine mcg / min Qn \n",
"17 Norepinephrine mcg / kg / min Qn \n",
"18 Vasopressin ml Qn \n",
"19 Vasopressin U Qn \n",
"20 Vasopressin U / min Qn \n",
"21 Vasopressin U / hr Qn \n",
"22 Normal Saline ml Qn \n",
"23 Normal Saline l Qn \n",
"24 Normal Saline ml / min Qn \n",
"25 Normal Saline ml / hr Qn \n",
"26 Lactated Ringers ml Qn \n",
"27 Lactated Ringers l Qn \n",
"28 Lactated Ringers ml / min Qn \n",
"29 Lactated Ringers ml / hr Qn \n",
"30 Lactate mmol / l Qn \n",
"31 Lactate mg / dl Qn \n",
"32 Respiratory Rate br / min Qn \n",
"33 Temperature celsius Qn \n",
"34 Heart Rate beat / min Qn \n",
"35 Respiratory Rate insp / min Qn \n",
"36 Heart Rate beats/min Qn \n",
"37 Systolic Blood Pressure mmHg Qn \n",
"38 Diastolic Blood Pressure mmHg Qn \n",
"39 Respiratory Rate insp/min Qn \n",
"40 Temperature DegC Qn \n",
"41 Temperature DegF Qn \n",
"42 Oxygen Saturation percent Qn \n",
"\n",
" clinical_source category_list_id reference_id reference_db component_id \n",
"0 observation None 8867-4 loinc 0 \n",
"1 observation None 8480-6 loinc 1 \n",
"2 observation None 8462-4 loinc 2 \n",
"3 observation None 9279-1 loinc 3 \n",
"4 observation None 8310-5 loinc 4 \n",
"5 observation None 59408-5 loinc 5 \n",
"6 observation None 29463-7 loinc 6 \n",
"7 observation None 29463-7 loinc 7 \n",
"8 observation None 9187-6 loinc 8 \n",
"9 observation None 9188-4 loinc 9 \n",
"10 observation None None local 10 \n",
"11 observation 0 9268-4 loinc 11 \n",
"12 observation 1 9270-0 loinc 12 \n",
"13 observation 2 9267-6 loinc 13 \n",
"14 intervention None None local 14 \n",
"15 intervention None None local 15 \n",
"16 intervention None None local 16 \n",
"17 intervention None None local 17 \n",
"18 intervention None None local 18 \n",
"19 intervention None None local 19 \n",
"20 intervention None None local 20 \n",
"21 intervention None None local 21 \n",
"22 intervention None None local 22 \n",
"23 intervention None None local 23 \n",
"24 intervention None None local 24 \n",
"25 intervention None None local 25 \n",
"26 intervention None None local 26 \n",
"27 intervention None None local 27 \n",
"28 intervention None None local 28 \n",
"29 intervention None None local 29 \n",
"30 observation None 32693-4 loinc 30 \n",
"31 observation None 59032-3 loinc 31 \n",
"32 observation None 9279-1 loinc 55 \n",
"33 observation None 8310-5 loinc 56 \n",
"34 observation None 8867-4 loinc 57 \n",
"35 observation None 9279-1 loinc 60 \n",
"36 observation None 8867-4 loinc 61 \n",
"37 observation None 8480-6 loinc 62 \n",
"38 observation None 8462-4 loinc 63 \n",
"39 observation None 9279-1 loinc 64 \n",
"40 observation None 8310-5 loinc 65 \n",
"41 observation None None local 66 \n",
"42 observation None 59408-5 loinc 67 "
]
},
"execution_count": 412,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"utils.open_df(defs_hdf5_fname,'components')"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Now **weight**."
]
},
{
"cell_type": "code",
"execution_count": 192,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>component</th>\n",
" <th>units</th>\n",
" <th>variable_type</th>\n",
" <th>clinical_source</th>\n",
" <th>category_list_id</th>\n",
" <th>reference_id</th>\n",
" <th>reference_db</th>\n",
" <th>component_id</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>Heart rate</td>\n",
" <td>beat / min</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>8867-4</td>\n",
" <td>loinc</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>Intravascular systolic</td>\n",
" <td>mmHg</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>8480-6</td>\n",
" <td>loinc</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>Intravascular diastolic</td>\n",
" <td>mmHg</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>8462-4</td>\n",
" <td>loinc</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>Breaths</td>\n",
" <td>br / min</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>9279-1</td>\n",
" <td>loinc</td>\n",
" <td>3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>Body temperature</td>\n",
" <td>celsius</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>8310-5</td>\n",
" <td>loinc</td>\n",
" <td>4</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>Oxygen saturation</td>\n",
" <td>percent</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>59408-5</td>\n",
" <td>loinc</td>\n",
" <td>5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>Body weight</td>\n",
" <td>lb</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>29463-7</td>\n",
" <td>loinc</td>\n",
" <td>6</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>Body weight</td>\n",
" <td>kg</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>29463-7</td>\n",
" <td>loinc</td>\n",
" <td>7</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" component units variable_type clinical_source \\\n",
"0 Heart rate beat / min Qn observation \n",
"1 Intravascular systolic mmHg Qn observation \n",
"2 Intravascular diastolic mmHg Qn observation \n",
"3 Breaths br / min Qn observation \n",
"4 Body temperature celsius Qn observation \n",
"5 Oxygen saturation percent Qn observation \n",
"6 Body weight lb Qn observation \n",
"7 Body weight kg Qn observation \n",
"\n",
" category_list_id reference_id reference_db component_id \n",
"0 None 8867-4 loinc 0 \n",
"1 None 8480-6 loinc 1 \n",
"2 None 8462-4 loinc 2 \n",
"3 None 9279-1 loinc 3 \n",
"4 None 8310-5 loinc 4 \n",
"5 None 59408-5 loinc 5 \n",
"6 None 29463-7 loinc 6 \n",
"7 None 29463-7 loinc 7 "
]
},
"execution_count": 192,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"#Weight lbs - 29463-7 \n",
"builder.add_standard('29463-7','loinc',which_units=0)\n",
"\n",
"#Weight lbs - 29463-7 \n",
"builder.add_standard('29463-7','loinc',which_units=1)\n",
"\n",
"utils.open_df(defs_hdf5_fname,'components')"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"**Urine Output**"
]
},
{
"cell_type": "code",
"execution_count": 193,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>component</th>\n",
" <th>units</th>\n",
" <th>variable_type</th>\n",
" <th>clinical_source</th>\n",
" <th>category_list_id</th>\n",
" <th>reference_id</th>\n",
" <th>reference_db</th>\n",
" <th>component_id</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>Heart rate</td>\n",
" <td>beat / min</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>8867-4</td>\n",
" <td>loinc</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>Intravascular systolic</td>\n",
" <td>mmHg</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>8480-6</td>\n",
" <td>loinc</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>Intravascular diastolic</td>\n",
" <td>mmHg</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>8462-4</td>\n",
" <td>loinc</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>Breaths</td>\n",
" <td>br / min</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>9279-1</td>\n",
" <td>loinc</td>\n",
" <td>3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>Body temperature</td>\n",
" <td>celsius</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>8310-5</td>\n",
" <td>loinc</td>\n",
" <td>4</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>Oxygen saturation</td>\n",
" <td>percent</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>59408-5</td>\n",
" <td>loinc</td>\n",
" <td>5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>Body weight</td>\n",
" <td>lb</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>29463-7</td>\n",
" <td>loinc</td>\n",
" <td>6</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>Body weight</td>\n",
" <td>kg</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>29463-7</td>\n",
" <td>loinc</td>\n",
" <td>7</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>Fluid output.urine</td>\n",
" <td>cubic_centimeter</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>9187-6</td>\n",
" <td>loinc</td>\n",
" <td>8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>Fluid output.urine</td>\n",
" <td>ml / h</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>9188-4</td>\n",
" <td>loinc</td>\n",
" <td>9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>Urine output</td>\n",
" <td>ml / hr / kg</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>local</td>\n",
" <td>10</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" component units variable_type clinical_source \\\n",
"0 Heart rate beat / min Qn observation \n",
"1 Intravascular systolic mmHg Qn observation \n",
"2 Intravascular diastolic mmHg Qn observation \n",
"3 Breaths br / min Qn observation \n",
"4 Body temperature celsius Qn observation \n",
"5 Oxygen saturation percent Qn observation \n",
"6 Body weight lb Qn observation \n",
"7 Body weight kg Qn observation \n",
"8 Fluid output.urine cubic_centimeter Qn observation \n",
"9 Fluid output.urine ml / h Qn observation \n",
"10 Urine output ml / hr / kg Qn observation \n",
"\n",
" category_list_id reference_id reference_db component_id \n",
"0 None 8867-4 loinc 0 \n",
"1 None 8480-6 loinc 1 \n",
"2 None 8462-4 loinc 2 \n",
"3 None 9279-1 loinc 3 \n",
"4 None 8310-5 loinc 4 \n",
"5 None 59408-5 loinc 5 \n",
"6 None 29463-7 loinc 6 \n",
"7 None 29463-7 loinc 7 \n",
"8 None 9187-6 loinc 8 \n",
"9 None 9188-4 loinc 9 \n",
"10 None None local 10 "
]
},
"execution_count": 193,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"#UOP cc (cm^3)\n",
"builder.add_standard('9187-6','loinc')\n",
"#UOP mL/h\n",
"\n",
"builder.add_standard('9188-4','loinc')\n",
"\n",
"#UOP mL/kg/hr\n",
"builder.add(component='Urine output',units='ml/kg/hr',\n",
" var_type=constants.variable_type.QUANTITATIVE,\n",
" source_type=constants.clinical_source.OBSERVATION\n",
" )\n",
"\n",
"utils.open_df(defs_hdf5_fname,'components')"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"**GCS**"
]
},
{
"cell_type": "code",
"execution_count": 194,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>component</th>\n",
" <th>units</th>\n",
" <th>variable_type</th>\n",
" <th>clinical_source</th>\n",
" <th>category_list_id</th>\n",
" <th>reference_id</th>\n",
" <th>reference_db</th>\n",
" <th>component_id</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>Heart rate</td>\n",
" <td>beat / min</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>8867-4</td>\n",
" <td>loinc</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>Intravascular systolic</td>\n",
" <td>mmHg</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>8480-6</td>\n",
" <td>loinc</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>Intravascular diastolic</td>\n",
" <td>mmHg</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>8462-4</td>\n",
" <td>loinc</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>Breaths</td>\n",
" <td>br / min</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>9279-1</td>\n",
" <td>loinc</td>\n",
" <td>3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>Body temperature</td>\n",
" <td>celsius</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>8310-5</td>\n",
" <td>loinc</td>\n",
" <td>4</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>Oxygen saturation</td>\n",
" <td>percent</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>59408-5</td>\n",
" <td>loinc</td>\n",
" <td>5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>Body weight</td>\n",
" <td>lb</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>29463-7</td>\n",
" <td>loinc</td>\n",
" <td>6</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>Body weight</td>\n",
" <td>kg</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>29463-7</td>\n",
" <td>loinc</td>\n",
" <td>7</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>Fluid output.urine</td>\n",
" <td>cubic_centimeter</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>9187-6</td>\n",
" <td>loinc</td>\n",
" <td>8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>Fluid output.urine</td>\n",
" <td>ml / h</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>9188-4</td>\n",
" <td>loinc</td>\n",
" <td>9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>Urine output</td>\n",
" <td>ml / hr / kg</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>local</td>\n",
" <td>10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>Glasgow coma score.motor</td>\n",
" <td></td>\n",
" <td>Ord</td>\n",
" <td>observation</td>\n",
" <td>0</td>\n",
" <td>9268-4</td>\n",
" <td>loinc</td>\n",
" <td>11</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>Glasgow coma score.verbal</td>\n",
" <td></td>\n",
" <td>Ord</td>\n",
" <td>observation</td>\n",
" <td>1</td>\n",
" <td>9270-0</td>\n",
" <td>loinc</td>\n",
" <td>12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>Glasgow coma score.eye opening</td>\n",
" <td></td>\n",
" <td>Ord</td>\n",
" <td>observation</td>\n",
" <td>2</td>\n",
" <td>9267-6</td>\n",
" <td>loinc</td>\n",
" <td>13</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" component units variable_type \\\n",
"0 Heart rate beat / min Qn \n",
"1 Intravascular systolic mmHg Qn \n",
"2 Intravascular diastolic mmHg Qn \n",
"3 Breaths br / min Qn \n",
"4 Body temperature celsius Qn \n",
"5 Oxygen saturation percent Qn \n",
"6 Body weight lb Qn \n",
"7 Body weight kg Qn \n",
"8 Fluid output.urine cubic_centimeter Qn \n",
"9 Fluid output.urine ml / h Qn \n",
"10 Urine output ml / hr / kg Qn \n",
"11 Glasgow coma score.motor Ord \n",
"12 Glasgow coma score.verbal Ord \n",
"13 Glasgow coma score.eye opening Ord \n",
"\n",
" clinical_source category_list_id reference_id reference_db component_id \n",
"0 observation None 8867-4 loinc 0 \n",
"1 observation None 8480-6 loinc 1 \n",
"2 observation None 8462-4 loinc 2 \n",
"3 observation None 9279-1 loinc 3 \n",
"4 observation None 8310-5 loinc 4 \n",
"5 observation None 59408-5 loinc 5 \n",
"6 observation None 29463-7 loinc 6 \n",
"7 observation None 29463-7 loinc 7 \n",
"8 observation None 9187-6 loinc 8 \n",
"9 observation None 9188-4 loinc 9 \n",
"10 observation None None local 10 \n",
"11 observation 0 9268-4 loinc 11 \n",
"12 observation 1 9270-0 loinc 12 \n",
"13 observation 2 9267-6 loinc 13 "
]
},
"execution_count": 194,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"#GCS - motor\n",
"builder.add_standard('9268-4','loinc')\n",
"\n",
"#GCS - verbal\n",
"builder.add_standard('9270-0','loinc')\n",
"\n",
"#GCS - eye opening\n",
"builder.add_standard('9267-6','loinc')\n",
"\n",
"utils.open_df(defs_hdf5_fname,'components')"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"**Lactate**"
]
},
{
"cell_type": "code",
"execution_count": 200,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"#Lactate - mmol/L\n",
"builder.add_standard('32693-4','loinc')\n",
"#Lactate - mg/dL\n",
"builder.add_standard('59032-3','loinc')"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Interventions"
]
},
{
"cell_type": "code",
"execution_count": 195,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"component = 'Norepinephrine'\n",
"units = ['mg','mcg','mcg/min','mcg/kg/min']\n",
"\n",
"for unit in units:\n",
" builder.add(component=component,units=unit,\n",
" var_type=constants.variable_type.QUANTITATIVE,\n",
" source_type=constants.clinical_source.INTERVENTION\n",
" )"
]
},
{
"cell_type": "code",
"execution_count": 196,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"component = 'Vasopressin'\n",
"units = ['mL','U','U/min','U/hr']\n",
"\n",
"for unit in units:\n",
" builder.add(component=component,units=unit,\n",
" var_type=constants.variable_type.QUANTITATIVE,\n",
" source_type=constants.clinical_source.INTERVENTION\n",
" )"
]
},
{
"cell_type": "code",
"execution_count": 197,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"component = 'Normal Saline'\n",
"units = ['mL','L','mL/min','mL/hr']\n",
"\n",
"for unit in units:\n",
" builder.add(component=component,units=unit,\n",
" var_type=constants.variable_type.QUANTITATIVE,\n",
" source_type=constants.clinical_source.INTERVENTION\n",
" )"
]
},
{
"cell_type": "code",
"execution_count": 198,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"component = 'Lactated Ringers'\n",
"units = ['mL','L','mL/min','mL/hr']\n",
"\n",
"for unit in units:\n",
" builder.add(component=component,units=unit,\n",
" var_type=constants.variable_type.QUANTITATIVE,\n",
" source_type=constants.clinical_source.INTERVENTION\n",
" )"
]
},
{
"cell_type": "code",
"execution_count": 201,
"metadata": {
"collapsed": false,
"scrolled": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>component</th>\n",
" <th>units</th>\n",
" <th>variable_type</th>\n",
" <th>clinical_source</th>\n",
" <th>category_list_id</th>\n",
" <th>reference_id</th>\n",
" <th>reference_db</th>\n",
" <th>component_id</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>Heart rate</td>\n",
" <td>beat / min</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>8867-4</td>\n",
" <td>loinc</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>Intravascular systolic</td>\n",
" <td>mmHg</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>8480-6</td>\n",
" <td>loinc</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>Intravascular diastolic</td>\n",
" <td>mmHg</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>8462-4</td>\n",
" <td>loinc</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>Breaths</td>\n",
" <td>br / min</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>9279-1</td>\n",
" <td>loinc</td>\n",
" <td>3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>Body temperature</td>\n",
" <td>celsius</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>8310-5</td>\n",
" <td>loinc</td>\n",
" <td>4</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>Oxygen saturation</td>\n",
" <td>percent</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>59408-5</td>\n",
" <td>loinc</td>\n",
" <td>5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>Body weight</td>\n",
" <td>lb</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>29463-7</td>\n",
" <td>loinc</td>\n",
" <td>6</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>Body weight</td>\n",
" <td>kg</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>29463-7</td>\n",
" <td>loinc</td>\n",
" <td>7</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>Fluid output.urine</td>\n",
" <td>cubic_centimeter</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>9187-6</td>\n",
" <td>loinc</td>\n",
" <td>8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>Fluid output.urine</td>\n",
" <td>ml / h</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>9188-4</td>\n",
" <td>loinc</td>\n",
" <td>9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>Urine output</td>\n",
" <td>ml / hr / kg</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>local</td>\n",
" <td>10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>Glasgow coma score.motor</td>\n",
" <td></td>\n",
" <td>Ord</td>\n",
" <td>observation</td>\n",
" <td>0</td>\n",
" <td>9268-4</td>\n",
" <td>loinc</td>\n",
" <td>11</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>Glasgow coma score.verbal</td>\n",
" <td></td>\n",
" <td>Ord</td>\n",
" <td>observation</td>\n",
" <td>1</td>\n",
" <td>9270-0</td>\n",
" <td>loinc</td>\n",
" <td>12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>Glasgow coma score.eye opening</td>\n",
" <td></td>\n",
" <td>Ord</td>\n",
" <td>observation</td>\n",
" <td>2</td>\n",
" <td>9267-6</td>\n",
" <td>loinc</td>\n",
" <td>13</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>Norepinephrine</td>\n",
" <td>mg</td>\n",
" <td>Qn</td>\n",
" <td>intervention</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>local</td>\n",
" <td>14</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>Norepinephrine</td>\n",
" <td>mcg</td>\n",
" <td>Qn</td>\n",
" <td>intervention</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>local</td>\n",
" <td>15</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>Norepinephrine</td>\n",
" <td>mcg / min</td>\n",
" <td>Qn</td>\n",
" <td>intervention</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>local</td>\n",
" <td>16</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>Norepinephrine</td>\n",
" <td>mcg / kg / min</td>\n",
" <td>Qn</td>\n",
" <td>intervention</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>local</td>\n",
" <td>17</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>Vasopressin</td>\n",
" <td>ml</td>\n",
" <td>Qn</td>\n",
" <td>intervention</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>local</td>\n",
" <td>18</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>Vasopressin</td>\n",
" <td>U</td>\n",
" <td>Qn</td>\n",
" <td>intervention</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>local</td>\n",
" <td>19</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>Vasopressin</td>\n",
" <td>U / min</td>\n",
" <td>Qn</td>\n",
" <td>intervention</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>local</td>\n",
" <td>20</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>Vasopressin</td>\n",
" <td>U / hr</td>\n",
" <td>Qn</td>\n",
" <td>intervention</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>local</td>\n",
" <td>21</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>Normal Saline</td>\n",
" <td>ml</td>\n",
" <td>Qn</td>\n",
" <td>intervention</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>local</td>\n",
" <td>22</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>Normal Saline</td>\n",
" <td>l</td>\n",
" <td>Qn</td>\n",
" <td>intervention</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>local</td>\n",
" <td>23</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>Normal Saline</td>\n",
" <td>ml / min</td>\n",
" <td>Qn</td>\n",
" <td>intervention</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>local</td>\n",
" <td>24</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>Normal Saline</td>\n",
" <td>ml / hr</td>\n",
" <td>Qn</td>\n",
" <td>intervention</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>local</td>\n",
" <td>25</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>Lactated Ringers</td>\n",
" <td>ml</td>\n",
" <td>Qn</td>\n",
" <td>intervention</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>local</td>\n",
" <td>26</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>Lactated Ringers</td>\n",
" <td>l</td>\n",
" <td>Qn</td>\n",
" <td>intervention</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>local</td>\n",
" <td>27</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>Lactated Ringers</td>\n",
" <td>ml / min</td>\n",
" <td>Qn</td>\n",
" <td>intervention</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>local</td>\n",
" <td>28</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>Lactated Ringers</td>\n",
" <td>ml / hr</td>\n",
" <td>Qn</td>\n",
" <td>intervention</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>local</td>\n",
" <td>29</td>\n",
" </tr>\n",
" <tr>\n",
" <th>30</th>\n",
" <td>Lactate</td>\n",
" <td>mmol / l</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>32693-4</td>\n",
" <td>loinc</td>\n",
" <td>30</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31</th>\n",
" <td>Lactate</td>\n",
" <td>mg / dl</td>\n",
" <td>Qn</td>\n",
" <td>observation</td>\n",
" <td>None</td>\n",
" <td>59032-3</td>\n",
" <td>loinc</td>\n",
" <td>31</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" component units variable_type \\\n",
"0 Heart rate beat / min Qn \n",
"1 Intravascular systolic mmHg Qn \n",
"2 Intravascular diastolic mmHg Qn \n",
"3 Breaths br / min Qn \n",
"4 Body temperature celsius Qn \n",
"5 Oxygen saturation percent Qn \n",
"6 Body weight lb Qn \n",
"7 Body weight kg Qn \n",
"8 Fluid output.urine cubic_centimeter Qn \n",
"9 Fluid output.urine ml / h Qn \n",
"10 Urine output ml / hr / kg Qn \n",
"11 Glasgow coma score.motor Ord \n",
"12 Glasgow coma score.verbal Ord \n",
"13 Glasgow coma score.eye opening Ord \n",
"14 Norepinephrine mg Qn \n",
"15 Norepinephrine mcg Qn \n",
"16 Norepinephrine mcg / min Qn \n",
"17 Norepinephrine mcg / kg / min Qn \n",
"18 Vasopressin ml Qn \n",
"19 Vasopressin U Qn \n",
"20 Vasopressin U / min Qn \n",
"21 Vasopressin U / hr Qn \n",
"22 Normal Saline ml Qn \n",
"23 Normal Saline l Qn \n",
"24 Normal Saline ml / min Qn \n",
"25 Normal Saline ml / hr Qn \n",
"26 Lactated Ringers ml Qn \n",
"27 Lactated Ringers l Qn \n",
"28 Lactated Ringers ml / min Qn \n",
"29 Lactated Ringers ml / hr Qn \n",
"30 Lactate mmol / l Qn \n",
"31 Lactate mg / dl Qn \n",
"\n",
" clinical_source category_list_id reference_id reference_db component_id \n",
"0 observation None 8867-4 loinc 0 \n",
"1 observation None 8480-6 loinc 1 \n",
"2 observation None 8462-4 loinc 2 \n",
"3 observation None 9279-1 loinc 3 \n",
"4 observation None 8310-5 loinc 4 \n",
"5 observation None 59408-5 loinc 5 \n",
"6 observation None 29463-7 loinc 6 \n",
"7 observation None 29463-7 loinc 7 \n",
"8 observation None 9187-6 loinc 8 \n",
"9 observation None 9188-4 loinc 9 \n",
"10 observation None None local 10 \n",
"11 observation 0 9268-4 loinc 11 \n",
"12 observation 1 9270-0 loinc 12 \n",
"13 observation 2 9267-6 loinc 13 \n",
"14 intervention None None local 14 \n",
"15 intervention None None local 15 \n",
"16 intervention None None local 16 \n",
"17 intervention None None local 17 \n",
"18 intervention None None local 18 \n",
"19 intervention None None local 19 \n",
"20 intervention None None local 20 \n",
"21 intervention None None local 21 \n",
"22 intervention None None local 22 \n",
"23 intervention None None local 23 \n",
"24 intervention None None local 24 \n",
"25 intervention None None local 25 \n",
"26 intervention None None local 26 \n",
"27 intervention None None local 27 \n",
"28 intervention None None local 28 \n",
"29 intervention None None local 29 \n",
"30 observation None 32693-4 loinc 30 \n",
"31 observation None 59032-3 loinc 31 "
]
},
"execution_count": 201,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"utils.open_df(defs_hdf5_fname,'components')"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Finding this data in MIMIC III"
]
},
{
"cell_type": "code",
"execution_count": 235,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"import mimic_explorer"
]
},
{
"cell_type": "code",
"execution_count": 374,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"reload(mimic_explorer)\n",
"reload(definitions)\n",
"exp = mimic_explorer.explorer('postgres','123','mimic')\n",
"comp_dict = definitions.component_dictionary('config/definitions')\n",
"keep_dict = {}"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Lactate"
]
},
{
"cell_type": "code",
"execution_count": 312,
"metadata": {
"collapsed": true
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>label</th>\n",
" <th>abbreviation</th>\n",
" <th>linksto</th>\n",
" <th>category</th>\n",
" <th>unitname</th>\n",
" <th>score</th>\n",
" </tr>\n",
" <tr>\n",
" <th>itemid</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>50813</th>\n",
" <td>LACTATE</td>\n",
" <td>NaN</td>\n",
" <td>labevents</td>\n",
" <td>BLOOD GAS</td>\n",
" <td>NaN</td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1531</th>\n",
" <td>Lactic Acid</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td>Chemistry</td>\n",
" <td></td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>225668</th>\n",
" <td>Lactic Acid</td>\n",
" <td>Lactic Acid</td>\n",
" <td>chartevents</td>\n",
" <td>Labs</td>\n",
" <td>None</td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>220228</th>\n",
" <td>Hemoglobin</td>\n",
" <td>Hemoglobin</td>\n",
" <td>chartevents</td>\n",
" <td>Labs</td>\n",
" <td>g/dl</td>\n",
" <td>92.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2773</th>\n",
" <td>sjlactate</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>92.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>225835</th>\n",
" <td>Na Phos</td>\n",
" <td>Na Phos</td>\n",
" <td>inputevents_mv</td>\n",
" <td>Medications</td>\n",
" <td>mmol</td>\n",
" <td>86.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>225925</th>\n",
" <td>Potassium Phosphate</td>\n",
" <td>Potassium Phosphate</td>\n",
" <td>inputevents_mv</td>\n",
" <td>Nutrition - Supplements</td>\n",
" <td>mmol</td>\n",
" <td>86.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>227526</th>\n",
" <td>Citrate</td>\n",
" <td>Citrate</td>\n",
" <td>inputevents_mv</td>\n",
" <td>Medications</td>\n",
" <td>mmol</td>\n",
" <td>86.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>225834</th>\n",
" <td>K Phos</td>\n",
" <td>K Phos</td>\n",
" <td>inputevents_mv</td>\n",
" <td>Medications</td>\n",
" <td>mmol</td>\n",
" <td>86.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>818</th>\n",
" <td>Lactic Acid(0.5-2.0)</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td>Chemistry</td>\n",
" <td></td>\n",
" <td>81.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45673</th>\n",
" <td>NA ACETATE</td>\n",
" <td></td>\n",
" <td>inputevents_cv</td>\n",
" <td>Free Form Intake</td>\n",
" <td></td>\n",
" <td>76.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>220955</th>\n",
" <td>Ringers Lactate</td>\n",
" <td>Ringers Lactate</td>\n",
" <td>inputevents_mv</td>\n",
" <td>Fluids - Other (Not In Use)</td>\n",
" <td>mL</td>\n",
" <td>76.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>46433</th>\n",
" <td>Na Acetate</td>\n",
" <td></td>\n",
" <td>inputevents_cv</td>\n",
" <td>Free Form Intake</td>\n",
" <td></td>\n",
" <td>76.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42387</th>\n",
" <td>NA+ ACETATE</td>\n",
" <td></td>\n",
" <td>inputevents_cv</td>\n",
" <td>Free Form Intake</td>\n",
" <td></td>\n",
" <td>74.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>225832</th>\n",
" <td>Folic Acid</td>\n",
" <td>Folic Acid</td>\n",
" <td>inputevents_mv</td>\n",
" <td>Medications</td>\n",
" <td>mg</td>\n",
" <td>74.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>30021</th>\n",
" <td>Lactated Ringers</td>\n",
" <td></td>\n",
" <td>inputevents_cv</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>74.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2638</th>\n",
" <td>CEREBRAL LACTATE</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>74.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5067</th>\n",
" <td>Folic Acid</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>74.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1634</th>\n",
" <td>lactated ringers</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>74.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6022</th>\n",
" <td>Critic Aide</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>74.000000</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" label abbreviation linksto \\\n",
"itemid \n",
"50813 LACTATE NaN labevents \n",
"1531 Lactic Acid chartevents \n",
"225668 Lactic Acid Lactic Acid chartevents \n",
"220228 Hemoglobin Hemoglobin chartevents \n",
"2773 sjlactate chartevents \n",
"225835 Na Phos Na Phos inputevents_mv \n",
"225925 Potassium Phosphate Potassium Phosphate inputevents_mv \n",
"227526 Citrate Citrate inputevents_mv \n",
"225834 K Phos K Phos inputevents_mv \n",
"818 Lactic Acid(0.5-2.0) chartevents \n",
"45673 NA ACETATE inputevents_cv \n",
"220955 Ringers Lactate Ringers Lactate inputevents_mv \n",
"46433 Na Acetate inputevents_cv \n",
"42387 NA+ ACETATE inputevents_cv \n",
"225832 Folic Acid Folic Acid inputevents_mv \n",
"30021 Lactated Ringers inputevents_cv \n",
"2638 CEREBRAL LACTATE chartevents \n",
"5067 Folic Acid chartevents \n",
"1634 lactated ringers chartevents \n",
"6022 Critic Aide chartevents \n",
"\n",
" category unitname score \n",
"itemid \n",
"50813 BLOOD GAS NaN 100.000000 \n",
"1531 Chemistry 100.000000 \n",
"225668 Labs None 100.000000 \n",
"220228 Labs g/dl 92.666667 \n",
"2773 92.000000 \n",
"225835 Medications mmol 86.666667 \n",
"225925 Nutrition - Supplements mmol 86.666667 \n",
"227526 Medications mmol 86.666667 \n",
"225834 Medications mmol 86.666667 \n",
"818 Chemistry 81.333333 \n",
"45673 Free Form Intake 76.000000 \n",
"220955 Fluids - Other (Not In Use) mL 76.000000 \n",
"46433 Free Form Intake 76.000000 \n",
"42387 Free Form Intake 74.666667 \n",
"225832 Medications mg 74.000000 \n",
"30021 74.000000 \n",
"2638 74.000000 \n",
"5067 74.000000 \n",
"1634 74.000000 \n",
"6022 74.000000 "
]
},
"execution_count": 312,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"out_df = exp.search(['lactate','lactic acid','mmol/L','mg/dL'])\n",
"out_df.head(20)"
]
},
{
"cell_type": "code",
"execution_count": 327,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"keep_dict[comp_dict.LACTATE.name] = [1531,50813,225668,818]"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Heart Rate"
]
},
{
"cell_type": "code",
"execution_count": 356,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>label</th>\n",
" <th>abbreviation</th>\n",
" <th>linksto</th>\n",
" <th>category</th>\n",
" <th>unitname</th>\n",
" <th>score</th>\n",
" </tr>\n",
" <tr>\n",
" <th>itemid</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>223765</th>\n",
" <td>Orthostatic HR sitting</td>\n",
" <td>Orthostatic HR sitting</td>\n",
" <td>chartevents</td>\n",
" <td>Routine Vital Signs</td>\n",
" <td>bpm</td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>223775</th>\n",
" <td>VAD Beat Rate R</td>\n",
" <td>VAD Beat Rate R</td>\n",
" <td>chartevents</td>\n",
" <td>Hemodynamics</td>\n",
" <td>bpm</td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1341</th>\n",
" <td>PULSE</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224363</th>\n",
" <td>VAD Beat Rate L</td>\n",
" <td>VAD Beat Rate L</td>\n",
" <td>chartevents</td>\n",
" <td>Hemodynamics</td>\n",
" <td>bpm</td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1725</th>\n",
" <td>Pulse</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224751</th>\n",
" <td>Temporary Pacemaker Rate</td>\n",
" <td>Temp Pacemaker Rate</td>\n",
" <td>chartevents</td>\n",
" <td>Cardiovascular (Pacer Data)</td>\n",
" <td>bpm</td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>220047</th>\n",
" <td>Heart Rate Alarm - Low</td>\n",
" <td>HR Alarm - Low</td>\n",
" <td>chartevents</td>\n",
" <td>Alarms</td>\n",
" <td>bpm</td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>211</th>\n",
" <td>Heart Rate</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1332</th>\n",
" <td>pulse</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>220045</th>\n",
" <td>Heart Rate</td>\n",
" <td>HR</td>\n",
" <td>chartevents</td>\n",
" <td>Routine Vital Signs</td>\n",
" <td>bpm</td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>223764</th>\n",
" <td>Orthostatic HR lying</td>\n",
" <td>Orthostatic HR lying</td>\n",
" <td>chartevents</td>\n",
" <td>Routine Vital Signs</td>\n",
" <td>bpm</td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>226764</th>\n",
" <td>HrApacheIIValue</td>\n",
" <td>HrApacheIIValue</td>\n",
" <td>chartevents</td>\n",
" <td>Scores - APACHE II</td>\n",
" <td>bpm</td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224647</th>\n",
" <td>Orthostatic HR standing</td>\n",
" <td>Orthostatic HR standing</td>\n",
" <td>chartevents</td>\n",
" <td>Routine Vital Signs</td>\n",
" <td>bpm</td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224422</th>\n",
" <td>Spont RR</td>\n",
" <td>Spont RR</td>\n",
" <td>chartevents</td>\n",
" <td>Respiratory</td>\n",
" <td>bpm</td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>227581</th>\n",
" <td>BiPap bpm (S/T -Back up)</td>\n",
" <td>BiPap bpm (S/T -Back up)</td>\n",
" <td>chartevents</td>\n",
" <td>Respiratory</td>\n",
" <td>bpm</td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>220046</th>\n",
" <td>Heart rate Alarm - High</td>\n",
" <td>HR Alarm - High</td>\n",
" <td>chartevents</td>\n",
" <td>Alarms</td>\n",
" <td>bpm</td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>227018</th>\n",
" <td>HR_ApacheIV</td>\n",
" <td>HR_ApacheIV</td>\n",
" <td>chartevents</td>\n",
" <td>Scores - APACHE IV (2)</td>\n",
" <td>bpm</td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>220052</th>\n",
" <td>Arterial Blood Pressure mean</td>\n",
" <td>ABPm</td>\n",
" <td>chartevents</td>\n",
" <td>Routine Vital Signs</td>\n",
" <td>mmHg</td>\n",
" <td>90.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>220181</th>\n",
" <td>Non Invasive Blood Pressure mean</td>\n",
" <td>NBPm</td>\n",
" <td>chartevents</td>\n",
" <td>Routine Vital Signs</td>\n",
" <td>mmHg</td>\n",
" <td>90.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3494</th>\n",
" <td>Lowest Heart Rate</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>82.666667</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" label abbreviation \\\n",
"itemid \n",
"223765 Orthostatic HR sitting Orthostatic HR sitting \n",
"223775 VAD Beat Rate R VAD Beat Rate R \n",
"1341 PULSE \n",
"224363 VAD Beat Rate L VAD Beat Rate L \n",
"1725 Pulse \n",
"224751 Temporary Pacemaker Rate Temp Pacemaker Rate \n",
"220047 Heart Rate Alarm - Low HR Alarm - Low \n",
"211 Heart Rate \n",
"1332 pulse \n",
"220045 Heart Rate HR \n",
"223764 Orthostatic HR lying Orthostatic HR lying \n",
"226764 HrApacheIIValue HrApacheIIValue \n",
"224647 Orthostatic HR standing Orthostatic HR standing \n",
"224422 Spont RR Spont RR \n",
"227581 BiPap bpm (S/T -Back up) BiPap bpm (S/T -Back up) \n",
"220046 Heart rate Alarm - High HR Alarm - High \n",
"227018 HR_ApacheIV HR_ApacheIV \n",
"220052 Arterial Blood Pressure mean ABPm \n",
"220181 Non Invasive Blood Pressure mean NBPm \n",
"3494 Lowest Heart Rate \n",
"\n",
" linksto category unitname score \n",
"itemid \n",
"223765 chartevents Routine Vital Signs bpm 100.000000 \n",
"223775 chartevents Hemodynamics bpm 100.000000 \n",
"1341 chartevents 100.000000 \n",
"224363 chartevents Hemodynamics bpm 100.000000 \n",
"1725 chartevents 100.000000 \n",
"224751 chartevents Cardiovascular (Pacer Data) bpm 100.000000 \n",
"220047 chartevents Alarms bpm 100.000000 \n",
"211 chartevents 100.000000 \n",
"1332 chartevents 100.000000 \n",
"220045 chartevents Routine Vital Signs bpm 100.000000 \n",
"223764 chartevents Routine Vital Signs bpm 100.000000 \n",
"226764 chartevents Scores - APACHE II bpm 100.000000 \n",
"224647 chartevents Routine Vital Signs bpm 100.000000 \n",
"224422 chartevents Respiratory bpm 100.000000 \n",
"227581 chartevents Respiratory bpm 100.000000 \n",
"220046 chartevents Alarms bpm 100.000000 \n",
"227018 chartevents Scores - APACHE IV (2) bpm 100.000000 \n",
"220052 chartevents Routine Vital Signs mmHg 90.666667 \n",
"220181 chartevents Routine Vital Signs mmHg 90.666667 \n",
"3494 chartevents 82.666667 "
]
},
"execution_count": 356,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"out_df = exp.search(['heart rate','beats','bpm','pulse'])\n",
"out_df.head(20)"
]
},
{
"cell_type": "code",
"execution_count": 357,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"keep_dict[comp_dict.HEART_RATE.name] = [211,220045,1341,1725,1332]"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Breaths/Respiratory Rate"
]
},
{
"cell_type": "code",
"execution_count": 316,
"metadata": {
"collapsed": true
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>label</th>\n",
" <th>abbreviation</th>\n",
" <th>linksto</th>\n",
" <th>category</th>\n",
" <th>unitname</th>\n",
" <th>score</th>\n",
" </tr>\n",
" <tr>\n",
" <th>itemid</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>224161</th>\n",
" <td>Resp Alarm - High</td>\n",
" <td>Resp Alarm - High</td>\n",
" <td>chartevents</td>\n",
" <td>Alarms</td>\n",
" <td>insp/min</td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>226774</th>\n",
" <td>RRApacheIIValue</td>\n",
" <td>RRApacheIIValue</td>\n",
" <td>chartevents</td>\n",
" <td>Scores - APACHE II</td>\n",
" <td>insp/min</td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>220210</th>\n",
" <td>Respiratory Rate</td>\n",
" <td>RR</td>\n",
" <td>chartevents</td>\n",
" <td>Respiratory</td>\n",
" <td>insp/min</td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224688</th>\n",
" <td>Respiratory Rate (Set)</td>\n",
" <td>Respiratory Rate (Set)</td>\n",
" <td>chartevents</td>\n",
" <td>Respiratory</td>\n",
" <td>insp/min</td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224689</th>\n",
" <td>Respiratory Rate (spontaneous)</td>\n",
" <td>Respiratory Rate (spontaneous)</td>\n",
" <td>chartevents</td>\n",
" <td>Respiratory</td>\n",
" <td>insp/min</td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>618</th>\n",
" <td>Respiratory Rate</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224690</th>\n",
" <td>Respiratory Rate (Total)</td>\n",
" <td>Respiratory Rate (Total)</td>\n",
" <td>chartevents</td>\n",
" <td>Respiratory</td>\n",
" <td>insp/min</td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3603</th>\n",
" <td>Resp Rate</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224162</th>\n",
" <td>Resp Alarm - Low</td>\n",
" <td>Resp Alarm - Low</td>\n",
" <td>chartevents</td>\n",
" <td>Alarms</td>\n",
" <td>insp/min</td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>223875</th>\n",
" <td>Fspn High</td>\n",
" <td>Fspn High</td>\n",
" <td>chartevents</td>\n",
" <td>Respiratory</td>\n",
" <td>insp/min</td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>227050</th>\n",
" <td>RR_ApacheIV</td>\n",
" <td>RR_ApacheIV</td>\n",
" <td>chartevents</td>\n",
" <td>Scores - APACHE IV (2)</td>\n",
" <td>insp/min</td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8113</th>\n",
" <td>Resp. Rate</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>94.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>619</th>\n",
" <td>Respiratory Rate Set</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>92.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224721</th>\n",
" <td>HR > 140</td>\n",
" <td>HR > 140</td>\n",
" <td></td>\n",
" <td>Respiratory</td>\n",
" <td></td>\n",
" <td>87.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224718</th>\n",
" <td>RR > 35 for > 5 min</td>\n",
" <td>RR > 35 for > 5 min</td>\n",
" <td></td>\n",
" <td>Respiratory</td>\n",
" <td></td>\n",
" <td>87.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>227580</th>\n",
" <td>BiPap IPAP</td>\n",
" <td>BiPap IPAP</td>\n",
" <td>chartevents</td>\n",
" <td>Respiratory</td>\n",
" <td>cmH2O</td>\n",
" <td>87.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>227581</th>\n",
" <td>BiPap bpm (S/T -Back up)</td>\n",
" <td>BiPap bpm (S/T -Back up)</td>\n",
" <td>chartevents</td>\n",
" <td>Respiratory</td>\n",
" <td>bpm</td>\n",
" <td>87.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224727</th>\n",
" <td>Resting Energy Expenditure</td>\n",
" <td>REE</td>\n",
" <td>chartevents</td>\n",
" <td>Respiratory</td>\n",
" <td>kcal/day</td>\n",
" <td>87.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224713</th>\n",
" <td>Circuit Changed</td>\n",
" <td>Circuit Changed</td>\n",
" <td></td>\n",
" <td>Respiratory</td>\n",
" <td></td>\n",
" <td>87.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224715</th>\n",
" <td>SBT Started</td>\n",
" <td>SBT Started</td>\n",
" <td></td>\n",
" <td>Respiratory</td>\n",
" <td></td>\n",
" <td>87.333333</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" label abbreviation \\\n",
"itemid \n",
"224161 Resp Alarm - High Resp Alarm - High \n",
"226774 RRApacheIIValue RRApacheIIValue \n",
"220210 Respiratory Rate RR \n",
"224688 Respiratory Rate (Set) Respiratory Rate (Set) \n",
"224689 Respiratory Rate (spontaneous) Respiratory Rate (spontaneous) \n",
"618 Respiratory Rate \n",
"224690 Respiratory Rate (Total) Respiratory Rate (Total) \n",
"3603 Resp Rate \n",
"224162 Resp Alarm - Low Resp Alarm - Low \n",
"223875 Fspn High Fspn High \n",
"227050 RR_ApacheIV RR_ApacheIV \n",
"8113 Resp. Rate \n",
"619 Respiratory Rate Set \n",
"224721 HR > 140 HR > 140 \n",
"224718 RR > 35 for > 5 min RR > 35 for > 5 min \n",
"227580 BiPap IPAP BiPap IPAP \n",
"227581 BiPap bpm (S/T -Back up) BiPap bpm (S/T -Back up) \n",
"224727 Resting Energy Expenditure REE \n",
"224713 Circuit Changed Circuit Changed \n",
"224715 SBT Started SBT Started \n",
"\n",
" linksto category unitname score \n",
"itemid \n",
"224161 chartevents Alarms insp/min 100.000000 \n",
"226774 chartevents Scores - APACHE II insp/min 100.000000 \n",
"220210 chartevents Respiratory insp/min 100.000000 \n",
"224688 chartevents Respiratory insp/min 100.000000 \n",
"224689 chartevents Respiratory insp/min 100.000000 \n",
"618 chartevents 100.000000 \n",
"224690 chartevents Respiratory insp/min 100.000000 \n",
"3603 chartevents 100.000000 \n",
"224162 chartevents Alarms insp/min 100.000000 \n",
"223875 chartevents Respiratory insp/min 100.000000 \n",
"227050 chartevents Scores - APACHE IV (2) insp/min 100.000000 \n",
"8113 chartevents 94.666667 \n",
"619 chartevents 92.666667 \n",
"224721 Respiratory 87.333333 \n",
"224718 Respiratory 87.333333 \n",
"227580 chartevents Respiratory cmH2O 87.333333 \n",
"227581 chartevents Respiratory bpm 87.333333 \n",
"224727 chartevents Respiratory kcal/day 87.333333 \n",
"224713 Respiratory 87.333333 \n",
"224715 Respiratory 87.333333 "
]
},
"execution_count": 316,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"out_df = exp.search(['respiratory rate','resp rate','insp/min','breath/min'])\n",
"out_df.head(20)"
]
},
{
"cell_type": "code",
"execution_count": 317,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"keep_dict[comp_dict.BREATHS] = [220210,3603,618,8113]"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Body Temp"
]
},
{
"cell_type": "code",
"execution_count": 318,
"metadata": {
"collapsed": true
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>label</th>\n",
" <th>abbreviation</th>\n",
" <th>linksto</th>\n",
" <th>category</th>\n",
" <th>unitname</th>\n",
" <th>score</th>\n",
" </tr>\n",
" <tr>\n",
" <th>itemid</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>50825</th>\n",
" <td>TEMPERATURE</td>\n",
" <td>NaN</td>\n",
" <td>labevents</td>\n",
" <td>BLOOD GAS</td>\n",
" <td>NaN</td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>223762</th>\n",
" <td>Temperature Celsius</td>\n",
" <td>Temperature C</td>\n",
" <td>chartevents</td>\n",
" <td>Routine Vital Signs</td>\n",
" <td>?C</td>\n",
" <td>94.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>678</th>\n",
" <td>Temperature F</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>94.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>226170</th>\n",
" <td>Head of Bead Measurement</td>\n",
" <td>HOB Measurement</td>\n",
" <td>chartevents</td>\n",
" <td>Treatments</td>\n",
" <td>Degree</td>\n",
" <td>94.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>223761</th>\n",
" <td>Temperature Fahrenheit</td>\n",
" <td>Temperature F</td>\n",
" <td>chartevents</td>\n",
" <td>Routine Vital Signs</td>\n",
" <td>?F</td>\n",
" <td>94.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>676</th>\n",
" <td>Temperature C</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>94.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>591</th>\n",
" <td>RLE [Temperature]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>88.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>597</th>\n",
" <td>RUE [Temperature]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>88.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224642</th>\n",
" <td>Temperature Site</td>\n",
" <td>Temp Site</td>\n",
" <td></td>\n",
" <td>Routine Vital Signs</td>\n",
" <td></td>\n",
" <td>87.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224027</th>\n",
" <td>Skin Temperature</td>\n",
" <td>Skin Temp</td>\n",
" <td></td>\n",
" <td>Skin - Assessment</td>\n",
" <td></td>\n",
" <td>87.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>645</th>\n",
" <td>Skin [Temperature]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>85.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>677</th>\n",
" <td>Temperature C (calc)</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>82.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>679</th>\n",
" <td>Temperature F (calc)</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>82.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>227054</th>\n",
" <td>TemperatureF_ApacheIV</td>\n",
" <td>TemperatureF_ApacheIV</td>\n",
" <td>chartevents</td>\n",
" <td>Scores - APACHE IV (2)</td>\n",
" <td>?F</td>\n",
" <td>79.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224771</th>\n",
" <td>RLE Temp</td>\n",
" <td>RLE Temp</td>\n",
" <td></td>\n",
" <td>Cardiovascular</td>\n",
" <td></td>\n",
" <td>78.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224773</th>\n",
" <td>LLE Temp</td>\n",
" <td>LLE Temp</td>\n",
" <td></td>\n",
" <td>Cardiovascular</td>\n",
" <td></td>\n",
" <td>78.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224769</th>\n",
" <td>LUE Temp</td>\n",
" <td>LUE Temp</td>\n",
" <td></td>\n",
" <td>Cardiovascular</td>\n",
" <td></td>\n",
" <td>78.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224767</th>\n",
" <td>RUE Temp</td>\n",
" <td>RUE Temp</td>\n",
" <td></td>\n",
" <td>Cardiovascular</td>\n",
" <td></td>\n",
" <td>78.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224674</th>\n",
" <td>Changes in Temperature</td>\n",
" <td>Changes in Temperature</td>\n",
" <td></td>\n",
" <td>Toxicology</td>\n",
" <td></td>\n",
" <td>78.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2798</th>\n",
" <td>arm 90 degrees</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>78.000000</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" label abbreviation linksto \\\n",
"itemid \n",
"50825 TEMPERATURE NaN labevents \n",
"223762 Temperature Celsius Temperature C chartevents \n",
"678 Temperature F chartevents \n",
"226170 Head of Bead Measurement HOB Measurement chartevents \n",
"223761 Temperature Fahrenheit Temperature F chartevents \n",
"676 Temperature C chartevents \n",
"591 RLE [Temperature] chartevents \n",
"597 RUE [Temperature] chartevents \n",
"224642 Temperature Site Temp Site \n",
"224027 Skin Temperature Skin Temp \n",
"645 Skin [Temperature] chartevents \n",
"677 Temperature C (calc) chartevents \n",
"679 Temperature F (calc) chartevents \n",
"227054 TemperatureF_ApacheIV TemperatureF_ApacheIV chartevents \n",
"224771 RLE Temp RLE Temp \n",
"224773 LLE Temp LLE Temp \n",
"224769 LUE Temp LUE Temp \n",
"224767 RUE Temp RUE Temp \n",
"224674 Changes in Temperature Changes in Temperature \n",
"2798 arm 90 degrees chartevents \n",
"\n",
" category unitname score \n",
"itemid \n",
"50825 BLOOD GAS NaN 100.000000 \n",
"223762 Routine Vital Signs ?C 94.666667 \n",
"678 94.666667 \n",
"226170 Treatments Degree 94.666667 \n",
"223761 Routine Vital Signs ?F 94.666667 \n",
"676 94.666667 \n",
"591 88.000000 \n",
"597 88.000000 \n",
"224642 Routine Vital Signs 87.333333 \n",
"224027 Skin - Assessment 87.333333 \n",
"645 85.666667 \n",
"677 82.333333 \n",
"679 82.333333 \n",
"227054 Scores - APACHE IV (2) ?F 79.333333 \n",
"224771 Cardiovascular 78.000000 \n",
"224773 Cardiovascular 78.000000 \n",
"224769 Cardiovascular 78.000000 \n",
"224767 Cardiovascular 78.000000 \n",
"224674 Toxicology 78.000000 \n",
"2798 78.000000 "
]
},
"execution_count": 318,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"out_df = exp.search(['temperature','temp','celcius','farenheit','degrees','deg'])\n",
"out_df.head(20)"
]
},
{
"cell_type": "code",
"execution_count": 321,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"keep_dict[comp_dict.BODY_TEMPERATURE.name] = [223761,678,223762,676]"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Blood Pressure"
]
},
{
"cell_type": "code",
"execution_count": 322,
"metadata": {
"collapsed": true
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>label</th>\n",
" <th>abbreviation</th>\n",
" <th>linksto</th>\n",
" <th>category</th>\n",
" <th>unitname</th>\n",
" <th>score</th>\n",
" </tr>\n",
" <tr>\n",
" <th>itemid</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>224314</th>\n",
" <td>ABI Brachial BP R (Impella)</td>\n",
" <td>ABI Brachial BP R (Impella)</td>\n",
" <td>chartevents</td>\n",
" <td>Impella</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224645</th>\n",
" <td>Orthostatic BPs lying</td>\n",
" <td>Orthostatic BPs lying</td>\n",
" <td>chartevents</td>\n",
" <td>Routine Vital Signs</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>220235</th>\n",
" <td>Arterial CO2 Pressure</td>\n",
" <td>PCO2 (Arterial)</td>\n",
" <td>chartevents</td>\n",
" <td>Labs</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>220224</th>\n",
" <td>Arterial O2 pressure</td>\n",
" <td>PO2 (Arterial)</td>\n",
" <td>chartevents</td>\n",
" <td>Labs</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>220181</th>\n",
" <td>Non Invasive Blood Pressure mean</td>\n",
" <td>NBPm</td>\n",
" <td>chartevents</td>\n",
" <td>Routine Vital Signs</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>220180</th>\n",
" <td>Non Invasive Blood Pressure diastolic</td>\n",
" <td>NBPd</td>\n",
" <td>chartevents</td>\n",
" <td>Routine Vital Signs</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>220179</th>\n",
" <td>Non Invasive Blood Pressure systolic</td>\n",
" <td>NBPs</td>\n",
" <td>chartevents</td>\n",
" <td>Routine Vital Signs</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>220074</th>\n",
" <td>Central Venous Pressure</td>\n",
" <td>CVP</td>\n",
" <td>chartevents</td>\n",
" <td>Hemodynamics</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>220073</th>\n",
" <td>Central Venous Pressure Alarm - Low</td>\n",
" <td>CVP Alarm - Low</td>\n",
" <td>chartevents</td>\n",
" <td>Alarms</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>220072</th>\n",
" <td>Central Venous Pressure Alarm - High</td>\n",
" <td>CVP Alarm - High</td>\n",
" <td>chartevents</td>\n",
" <td>Alarms</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>220069</th>\n",
" <td>Left Artrial Pressure</td>\n",
" <td>LAP</td>\n",
" <td>chartevents</td>\n",
" <td>Hemodynamics</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>220066</th>\n",
" <td>Pulmonary Artery Pressure Alarm - Low</td>\n",
" <td>PAP Alarm - Low</td>\n",
" <td>chartevents</td>\n",
" <td>Alarms</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>220063</th>\n",
" <td>Pulmonary Artery Pressure Alarm - High</td>\n",
" <td>PAP Alarm - High</td>\n",
" <td>chartevents</td>\n",
" <td>Alarms</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>220061</th>\n",
" <td>Pulmonary Artery Pressure mean</td>\n",
" <td>PAPm</td>\n",
" <td>chartevents</td>\n",
" <td>Hemodynamics</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>220060</th>\n",
" <td>Pulmonary Artery Pressure diastolic</td>\n",
" <td>PAPd</td>\n",
" <td>chartevents</td>\n",
" <td>Hemodynamics</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>220059</th>\n",
" <td>Pulmonary Artery Pressure systolic</td>\n",
" <td>PAPs</td>\n",
" <td>chartevents</td>\n",
" <td>Hemodynamics</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>220058</th>\n",
" <td>Arterial Blood Pressure Alarm - High</td>\n",
" <td>ABP Alarm - High</td>\n",
" <td>chartevents</td>\n",
" <td>Alarms</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>223751</th>\n",
" <td>Non-Invasive Blood Pressure Alarm - High</td>\n",
" <td>NBP Alarm - High</td>\n",
" <td>chartevents</td>\n",
" <td>Alarms</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>227066</th>\n",
" <td>Cerebral Perfusion Pressure</td>\n",
" <td>CPP</td>\n",
" <td>chartevents</td>\n",
" <td>Hemodynamics</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>227516</th>\n",
" <td>PO2 (Mixed Venous)</td>\n",
" <td>PO2 (Mixed Venous)</td>\n",
" <td>chartevents</td>\n",
" <td>Labs</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" label abbreviation \\\n",
"itemid \n",
"224314 ABI Brachial BP R (Impella) ABI Brachial BP R (Impella) \n",
"224645 Orthostatic BPs lying Orthostatic BPs lying \n",
"220235 Arterial CO2 Pressure PCO2 (Arterial) \n",
"220224 Arterial O2 pressure PO2 (Arterial) \n",
"220181 Non Invasive Blood Pressure mean NBPm \n",
"220180 Non Invasive Blood Pressure diastolic NBPd \n",
"220179 Non Invasive Blood Pressure systolic NBPs \n",
"220074 Central Venous Pressure CVP \n",
"220073 Central Venous Pressure Alarm - Low CVP Alarm - Low \n",
"220072 Central Venous Pressure Alarm - High CVP Alarm - High \n",
"220069 Left Artrial Pressure LAP \n",
"220066 Pulmonary Artery Pressure Alarm - Low PAP Alarm - Low \n",
"220063 Pulmonary Artery Pressure Alarm - High PAP Alarm - High \n",
"220061 Pulmonary Artery Pressure mean PAPm \n",
"220060 Pulmonary Artery Pressure diastolic PAPd \n",
"220059 Pulmonary Artery Pressure systolic PAPs \n",
"220058 Arterial Blood Pressure Alarm - High ABP Alarm - High \n",
"223751 Non-Invasive Blood Pressure Alarm - High NBP Alarm - High \n",
"227066 Cerebral Perfusion Pressure CPP \n",
"227516 PO2 (Mixed Venous) PO2 (Mixed Venous) \n",
"\n",
" linksto category unitname score \n",
"itemid \n",
"224314 chartevents Impella mmHg 100.0 \n",
"224645 chartevents Routine Vital Signs mmHg 100.0 \n",
"220235 chartevents Labs mmHg 100.0 \n",
"220224 chartevents Labs mmHg 100.0 \n",
"220181 chartevents Routine Vital Signs mmHg 100.0 \n",
"220180 chartevents Routine Vital Signs mmHg 100.0 \n",
"220179 chartevents Routine Vital Signs mmHg 100.0 \n",
"220074 chartevents Hemodynamics mmHg 100.0 \n",
"220073 chartevents Alarms mmHg 100.0 \n",
"220072 chartevents Alarms mmHg 100.0 \n",
"220069 chartevents Hemodynamics mmHg 100.0 \n",
"220066 chartevents Alarms mmHg 100.0 \n",
"220063 chartevents Alarms mmHg 100.0 \n",
"220061 chartevents Hemodynamics mmHg 100.0 \n",
"220060 chartevents Hemodynamics mmHg 100.0 \n",
"220059 chartevents Hemodynamics mmHg 100.0 \n",
"220058 chartevents Alarms mmHg 100.0 \n",
"223751 chartevents Alarms mmHg 100.0 \n",
"227066 chartevents Hemodynamics mmHg 100.0 \n",
"227516 chartevents Labs mmHg 100.0 "
]
},
"execution_count": 322,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"out_df = exp.search(['blood pressure','systolic','diastolic','mmHg'])\n",
"out_df.iloc[0:20]"
]
},
{
"cell_type": "code",
"execution_count": 338,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"keep_dict[comp_dict.INTRAVASCULAR_SYSTOLIC] = [220179]\n",
"keep_dict[comp_dict.INTRAVASCULAR_DIASTOLIC] = [220180]"
]
},
{
"cell_type": "code",
"execution_count": 339,
"metadata": {
"collapsed": true
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>label</th>\n",
" <th>abbreviation</th>\n",
" <th>linksto</th>\n",
" <th>category</th>\n",
" <th>unitname</th>\n",
" <th>score</th>\n",
" </tr>\n",
" <tr>\n",
" <th>itemid</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>226062</th>\n",
" <td>Venous CO2 Pressure</td>\n",
" <td>PCO2 (Venous)</td>\n",
" <td>chartevents</td>\n",
" <td>Labs</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>226063</th>\n",
" <td>Venous O2 Pressure</td>\n",
" <td>PO2 (Venous)</td>\n",
" <td>chartevents</td>\n",
" <td>Labs</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224166</th>\n",
" <td>Doppler BP</td>\n",
" <td>Doppler BP</td>\n",
" <td>chartevents</td>\n",
" <td>Routine Vital Signs</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224167</th>\n",
" <td>Manual Blood Pressure Systolic Left</td>\n",
" <td>Manual BPs L</td>\n",
" <td>chartevents</td>\n",
" <td>Routine Vital Signs</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>225312</th>\n",
" <td>ART BP mean</td>\n",
" <td>ART BP mean</td>\n",
" <td>chartevents</td>\n",
" <td>Routine Vital Signs</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>225310</th>\n",
" <td>ART BP Diastolic</td>\n",
" <td>ART BP Diastolic</td>\n",
" <td>chartevents</td>\n",
" <td>Routine Vital Signs</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>225309</th>\n",
" <td>ART BP Systolic</td>\n",
" <td>ART BP Systolic</td>\n",
" <td>chartevents</td>\n",
" <td>Routine Vital Signs</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>226737</th>\n",
" <td>AaDO2ApacheIIValue</td>\n",
" <td>AaDO2ApacheIIValue</td>\n",
" <td>chartevents</td>\n",
" <td>Scores - APACHE II</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>226096</th>\n",
" <td>Orthostatic BPd standing</td>\n",
" <td>Orthostatic BPd standing</td>\n",
" <td>chartevents</td>\n",
" <td>Routine Vital Signs</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224643</th>\n",
" <td>Manual Blood Pressure Diastolic Left</td>\n",
" <td>Manual BPd L</td>\n",
" <td>chartevents</td>\n",
" <td>Routine Vital Signs</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>228148</th>\n",
" <td>ABI Ankle BP R (Impella)</td>\n",
" <td>ABI Ankle BP R (Impella)</td>\n",
" <td>chartevents</td>\n",
" <td>Impella</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>223752</th>\n",
" <td>Non-Invasive Blood Pressure Alarm - Low</td>\n",
" <td>NBP Alarm - Low</td>\n",
" <td>chartevents</td>\n",
" <td>Alarms</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>223763</th>\n",
" <td>Bladder Pressure</td>\n",
" <td>Bladder Pressure</td>\n",
" <td>chartevents</td>\n",
" <td>Routine Vital Signs</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>223766</th>\n",
" <td>Orthostatic BPs standing</td>\n",
" <td>Orthostatic BPs standing</td>\n",
" <td>chartevents</td>\n",
" <td>Routine Vital Signs</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224318</th>\n",
" <td>ABI Ankle BP L (Impella)</td>\n",
" <td>ABI Ankle BP L (Impella)</td>\n",
" <td>chartevents</td>\n",
" <td>Impella</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>227991</th>\n",
" <td>Intra Cranial Pressure #2 Alarm - Low</td>\n",
" <td>IC2 Alarm - Low</td>\n",
" <td>chartevents</td>\n",
" <td>Alarms</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>226094</th>\n",
" <td>Orthostatic BPd sitting</td>\n",
" <td>Orthostatic BPd sitting</td>\n",
" <td>chartevents</td>\n",
" <td>Routine Vital Signs</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>226092</th>\n",
" <td>Orthostatic BPd lying</td>\n",
" <td>Orthostatic BPd lying</td>\n",
" <td>chartevents</td>\n",
" <td>Routine Vital Signs</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>227989</th>\n",
" <td>Intra Cranial Pressure #2</td>\n",
" <td>IC2</td>\n",
" <td>chartevents</td>\n",
" <td>Hemodynamics</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224149</th>\n",
" <td>Access Pressure</td>\n",
" <td>Access Pressure</td>\n",
" <td>chartevents</td>\n",
" <td>Dialysis</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" label abbreviation \\\n",
"itemid \n",
"226062 Venous CO2 Pressure PCO2 (Venous) \n",
"226063 Venous O2 Pressure PO2 (Venous) \n",
"224166 Doppler BP Doppler BP \n",
"224167 Manual Blood Pressure Systolic Left Manual BPs L \n",
"225312 ART BP mean ART BP mean \n",
"225310 ART BP Diastolic ART BP Diastolic \n",
"225309 ART BP Systolic ART BP Systolic \n",
"226737 AaDO2ApacheIIValue AaDO2ApacheIIValue \n",
"226096 Orthostatic BPd standing Orthostatic BPd standing \n",
"224643 Manual Blood Pressure Diastolic Left Manual BPd L \n",
"228148 ABI Ankle BP R (Impella) ABI Ankle BP R (Impella) \n",
"223752 Non-Invasive Blood Pressure Alarm - Low NBP Alarm - Low \n",
"223763 Bladder Pressure Bladder Pressure \n",
"223766 Orthostatic BPs standing Orthostatic BPs standing \n",
"224318 ABI Ankle BP L (Impella) ABI Ankle BP L (Impella) \n",
"227991 Intra Cranial Pressure #2 Alarm - Low IC2 Alarm - Low \n",
"226094 Orthostatic BPd sitting Orthostatic BPd sitting \n",
"226092 Orthostatic BPd lying Orthostatic BPd lying \n",
"227989 Intra Cranial Pressure #2 IC2 \n",
"224149 Access Pressure Access Pressure \n",
"\n",
" linksto category unitname score \n",
"itemid \n",
"226062 chartevents Labs mmHg 100.0 \n",
"226063 chartevents Labs mmHg 100.0 \n",
"224166 chartevents Routine Vital Signs mmHg 100.0 \n",
"224167 chartevents Routine Vital Signs mmHg 100.0 \n",
"225312 chartevents Routine Vital Signs mmHg 100.0 \n",
"225310 chartevents Routine Vital Signs mmHg 100.0 \n",
"225309 chartevents Routine Vital Signs mmHg 100.0 \n",
"226737 chartevents Scores - APACHE II mmHg 100.0 \n",
"226096 chartevents Routine Vital Signs mmHg 100.0 \n",
"224643 chartevents Routine Vital Signs mmHg 100.0 \n",
"228148 chartevents Impella mmHg 100.0 \n",
"223752 chartevents Alarms mmHg 100.0 \n",
"223763 chartevents Routine Vital Signs mmHg 100.0 \n",
"223766 chartevents Routine Vital Signs mmHg 100.0 \n",
"224318 chartevents Impella mmHg 100.0 \n",
"227991 chartevents Alarms mmHg 100.0 \n",
"226094 chartevents Routine Vital Signs mmHg 100.0 \n",
"226092 chartevents Routine Vital Signs mmHg 100.0 \n",
"227989 chartevents Hemodynamics mmHg 100.0 \n",
"224149 chartevents Dialysis mmHg 100.0 "
]
},
"execution_count": 339,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"out_df.iloc[20:40]"
]
},
{
"cell_type": "code",
"execution_count": 340,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"keep_dict[comp_dict.INTRAVASCULAR_SYSTOLIC] += [225309,224167]\n",
"keep_dict[comp_dict.INTRAVASCULAR_DIASTOLIC] += [225310,224643]"
]
},
{
"cell_type": "code",
"execution_count": 341,
"metadata": {
"collapsed": true
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>label</th>\n",
" <th>abbreviation</th>\n",
" <th>linksto</th>\n",
" <th>category</th>\n",
" <th>unitname</th>\n",
" <th>score</th>\n",
" </tr>\n",
" <tr>\n",
" <th>itemid</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>224150</th>\n",
" <td>Filter Pressure</td>\n",
" <td>Filter Pressure</td>\n",
" <td>chartevents</td>\n",
" <td>Dialysis</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224151</th>\n",
" <td>Effluent Pressure</td>\n",
" <td>Effluent Pressure</td>\n",
" <td>chartevents</td>\n",
" <td>Dialysis</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224309</th>\n",
" <td>Assisted Systole</td>\n",
" <td>SYS - Assisted</td>\n",
" <td>chartevents</td>\n",
" <td>IABP</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224152</th>\n",
" <td>Return Pressure</td>\n",
" <td>Return Pressure</td>\n",
" <td>chartevents</td>\n",
" <td>Dialysis</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224310</th>\n",
" <td>Augmented Diastole</td>\n",
" <td>AUG</td>\n",
" <td>chartevents</td>\n",
" <td>IABP</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224311</th>\n",
" <td>BAEDP</td>\n",
" <td>DIA - Assisted</td>\n",
" <td>chartevents</td>\n",
" <td>IABP</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224315</th>\n",
" <td>ABI Brachial BP L</td>\n",
" <td>ABI Brachial BP L</td>\n",
" <td>chartevents</td>\n",
" <td>IABP</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224317</th>\n",
" <td>ABI Ankle BP R</td>\n",
" <td>ABI Ankle BP R</td>\n",
" <td>chartevents</td>\n",
" <td>IABP</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224322</th>\n",
" <td>IABP Mean</td>\n",
" <td>MAP - Assisted</td>\n",
" <td>chartevents</td>\n",
" <td>IABP</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>223767</th>\n",
" <td>Intra Cranial Pressure Alarm - High</td>\n",
" <td>ICP Alarm - High</td>\n",
" <td>chartevents</td>\n",
" <td>Alarms</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>227537</th>\n",
" <td>ART Blood Pressure Alarm - High</td>\n",
" <td>ART BP Alarm - High</td>\n",
" <td>chartevents</td>\n",
" <td>Alarms</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>227538</th>\n",
" <td>ART Blood Pressure Alarm - Low</td>\n",
" <td>ART BP Alarm - Low</td>\n",
" <td>chartevents</td>\n",
" <td>Alarms</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>220056</th>\n",
" <td>Arterial Blood Pressure Alarm - Low</td>\n",
" <td>ABP Alarm - Low</td>\n",
" <td>chartevents</td>\n",
" <td>Alarms</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>220052</th>\n",
" <td>Arterial Blood Pressure mean</td>\n",
" <td>ABPm</td>\n",
" <td>chartevents</td>\n",
" <td>Routine Vital Signs</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>220051</th>\n",
" <td>Arterial Blood Pressure diastolic</td>\n",
" <td>ABPd</td>\n",
" <td>chartevents</td>\n",
" <td>Routine Vital Signs</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>220050</th>\n",
" <td>Arterial Blood Pressure systolic</td>\n",
" <td>ABPs</td>\n",
" <td>chartevents</td>\n",
" <td>Routine Vital Signs</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>228145</th>\n",
" <td>ABI Ankle BP L</td>\n",
" <td>ABI Ankle BP L</td>\n",
" <td>chartevents</td>\n",
" <td>IABP</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>228146</th>\n",
" <td>ABI Brachial BP R</td>\n",
" <td>ABI Brachial BP R</td>\n",
" <td>chartevents</td>\n",
" <td>IABP</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>227039</th>\n",
" <td>PO2_ApacheIV</td>\n",
" <td>PO2_ApacheIV</td>\n",
" <td>chartevents</td>\n",
" <td>Scores - APACHE IV (2)</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>220765</th>\n",
" <td>Intra Cranial Pressure</td>\n",
" <td>ICP</td>\n",
" <td>chartevents</td>\n",
" <td>Hemodynamics</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" label abbreviation linksto \\\n",
"itemid \n",
"224150 Filter Pressure Filter Pressure chartevents \n",
"224151 Effluent Pressure Effluent Pressure chartevents \n",
"224309 Assisted Systole SYS - Assisted chartevents \n",
"224152 Return Pressure Return Pressure chartevents \n",
"224310 Augmented Diastole AUG chartevents \n",
"224311 BAEDP DIA - Assisted chartevents \n",
"224315 ABI Brachial BP L ABI Brachial BP L chartevents \n",
"224317 ABI Ankle BP R ABI Ankle BP R chartevents \n",
"224322 IABP Mean MAP - Assisted chartevents \n",
"223767 Intra Cranial Pressure Alarm - High ICP Alarm - High chartevents \n",
"227537 ART Blood Pressure Alarm - High ART BP Alarm - High chartevents \n",
"227538 ART Blood Pressure Alarm - Low ART BP Alarm - Low chartevents \n",
"220056 Arterial Blood Pressure Alarm - Low ABP Alarm - Low chartevents \n",
"220052 Arterial Blood Pressure mean ABPm chartevents \n",
"220051 Arterial Blood Pressure diastolic ABPd chartevents \n",
"220050 Arterial Blood Pressure systolic ABPs chartevents \n",
"228145 ABI Ankle BP L ABI Ankle BP L chartevents \n",
"228146 ABI Brachial BP R ABI Brachial BP R chartevents \n",
"227039 PO2_ApacheIV PO2_ApacheIV chartevents \n",
"220765 Intra Cranial Pressure ICP chartevents \n",
"\n",
" category unitname score \n",
"itemid \n",
"224150 Dialysis mmHg 100.0 \n",
"224151 Dialysis mmHg 100.0 \n",
"224309 IABP mmHg 100.0 \n",
"224152 Dialysis mmHg 100.0 \n",
"224310 IABP mmHg 100.0 \n",
"224311 IABP mmHg 100.0 \n",
"224315 IABP mmHg 100.0 \n",
"224317 IABP mmHg 100.0 \n",
"224322 IABP mmHg 100.0 \n",
"223767 Alarms mmHg 100.0 \n",
"227537 Alarms mmHg 100.0 \n",
"227538 Alarms mmHg 100.0 \n",
"220056 Alarms mmHg 100.0 \n",
"220052 Routine Vital Signs mmHg 100.0 \n",
"220051 Routine Vital Signs mmHg 100.0 \n",
"220050 Routine Vital Signs mmHg 100.0 \n",
"228145 IABP mmHg 100.0 \n",
"228146 IABP mmHg 100.0 \n",
"227039 Scores - APACHE IV (2) mmHg 100.0 \n",
"220765 Hemodynamics mmHg 100.0 "
]
},
"execution_count": 341,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"out_df.iloc[40:60]"
]
},
{
"cell_type": "code",
"execution_count": 342,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"keep_dict[comp_dict.INTRAVASCULAR_SYSTOLIC] += [220050]\n",
"keep_dict[comp_dict.INTRAVASCULAR_DIASTOLIC] += [220051]"
]
},
{
"cell_type": "code",
"execution_count": 343,
"metadata": {
"collapsed": true
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>label</th>\n",
" <th>abbreviation</th>\n",
" <th>linksto</th>\n",
" <th>category</th>\n",
" <th>unitname</th>\n",
" <th>score</th>\n",
" </tr>\n",
" <tr>\n",
" <th>itemid</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>227023</th>\n",
" <td>MAP_ApacheIV</td>\n",
" <td>MAP_ApacheIV</td>\n",
" <td>chartevents</td>\n",
" <td>Scores - APACHE IV (2)</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>223771</th>\n",
" <td>PCWP</td>\n",
" <td>PCWP</td>\n",
" <td>chartevents</td>\n",
" <td>Hemodynamics</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>223768</th>\n",
" <td>Intra Cranial Pressure Alarm - Low</td>\n",
" <td>ICP Alarm - Low</td>\n",
" <td>chartevents</td>\n",
" <td>Alarms</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>228149</th>\n",
" <td>ABI Brachial BP L (Impella)</td>\n",
" <td>ABI Brachial BP L (Impella)</td>\n",
" <td>chartevents</td>\n",
" <td>Impella</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>227990</th>\n",
" <td>Intra Cranial Pressure #2 Alarm - High</td>\n",
" <td>IC2 Alarm - High</td>\n",
" <td>chartevents</td>\n",
" <td>Alarms</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>226851</th>\n",
" <td>RV diastolic pressure(PA Line)</td>\n",
" <td>RV diastolic pressure(PA Line)</td>\n",
" <td>chartevents</td>\n",
" <td>PA Line Insertion</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>226853</th>\n",
" <td>PA diastolic pressure(PA Line)</td>\n",
" <td>PA diastolic pressure(PA Line)</td>\n",
" <td>chartevents</td>\n",
" <td>PA Line Insertion</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>226766</th>\n",
" <td>MapApacheIIValue</td>\n",
" <td>MapApacheIIValue</td>\n",
" <td>chartevents</td>\n",
" <td>Scores - APACHE II</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>227717</th>\n",
" <td>Cerebral Perfusion Pressure Alarm - Low</td>\n",
" <td>CPP Alarm - Low</td>\n",
" <td>chartevents</td>\n",
" <td>Alarms</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>227242</th>\n",
" <td>Manual Blood Pressure Diastolic Right</td>\n",
" <td>Manual BPd R</td>\n",
" <td>chartevents</td>\n",
" <td>Routine Vital Signs</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>227243</th>\n",
" <td>Manual Blood Pressure Systolic Right</td>\n",
" <td>Manual BPs R</td>\n",
" <td>chartevents</td>\n",
" <td>Routine Vital Signs</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>227716</th>\n",
" <td>Cerebral Perfusion Pressure Alarm - High</td>\n",
" <td>CPP Alarm - High</td>\n",
" <td>chartevents</td>\n",
" <td>Alarms</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>226849</th>\n",
" <td>RA (mean) pressure (PA Line)</td>\n",
" <td>RA (mean) pressure (PA Line)</td>\n",
" <td>chartevents</td>\n",
" <td>PA Line Insertion</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>226850</th>\n",
" <td>RV systolic pressure(PA Line)</td>\n",
" <td>RV systolic pressure(PA Line)</td>\n",
" <td>chartevents</td>\n",
" <td>PA Line Insertion</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>226852</th>\n",
" <td>PA systolic pressure(PA Line)</td>\n",
" <td>PA systolic pressure(PA Line)</td>\n",
" <td>chartevents</td>\n",
" <td>PA Line Insertion</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>228158</th>\n",
" <td>Purge Pressure</td>\n",
" <td>Purge Pressure</td>\n",
" <td>chartevents</td>\n",
" <td>Impella</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>226854</th>\n",
" <td>PCWP (v wave) (PA Line)</td>\n",
" <td>PCWP (v wave) (PA Line)</td>\n",
" <td>chartevents</td>\n",
" <td>PA Line Insertion</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224646</th>\n",
" <td>Orthostatic BPs sitting</td>\n",
" <td>Orthostatic BPs sitting</td>\n",
" <td>chartevents</td>\n",
" <td>Routine Vital Signs</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>226857</th>\n",
" <td>PA mean pressure (PA Line)</td>\n",
" <td>PA mean pressure (PA Line)</td>\n",
" <td>chartevents</td>\n",
" <td>PA Line Insertion</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>226855</th>\n",
" <td>PCWP (mean) (PA Line)</td>\n",
" <td>PCWP (mean) (PA Line)</td>\n",
" <td>chartevents</td>\n",
" <td>PA Line Insertion</td>\n",
" <td>mmHg</td>\n",
" <td>100.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" label \\\n",
"itemid \n",
"227023 MAP_ApacheIV \n",
"223771 PCWP \n",
"223768 Intra Cranial Pressure Alarm - Low \n",
"228149 ABI Brachial BP L (Impella) \n",
"227990 Intra Cranial Pressure #2 Alarm - High \n",
"226851 RV diastolic pressure(PA Line) \n",
"226853 PA diastolic pressure(PA Line) \n",
"226766 MapApacheIIValue \n",
"227717 Cerebral Perfusion Pressure Alarm - Low \n",
"227242 Manual Blood Pressure Diastolic Right \n",
"227243 Manual Blood Pressure Systolic Right \n",
"227716 Cerebral Perfusion Pressure Alarm - High \n",
"226849 RA (mean) pressure (PA Line) \n",
"226850 RV systolic pressure(PA Line) \n",
"226852 PA systolic pressure(PA Line) \n",
"228158 Purge Pressure \n",
"226854 PCWP (v wave) (PA Line) \n",
"224646 Orthostatic BPs sitting \n",
"226857 PA mean pressure (PA Line) \n",
"226855 PCWP (mean) (PA Line) \n",
"\n",
" abbreviation linksto category \\\n",
"itemid \n",
"227023 MAP_ApacheIV chartevents Scores - APACHE IV (2) \n",
"223771 PCWP chartevents Hemodynamics \n",
"223768 ICP Alarm - Low chartevents Alarms \n",
"228149 ABI Brachial BP L (Impella) chartevents Impella \n",
"227990 IC2 Alarm - High chartevents Alarms \n",
"226851 RV diastolic pressure(PA Line) chartevents PA Line Insertion \n",
"226853 PA diastolic pressure(PA Line) chartevents PA Line Insertion \n",
"226766 MapApacheIIValue chartevents Scores - APACHE II \n",
"227717 CPP Alarm - Low chartevents Alarms \n",
"227242 Manual BPd R chartevents Routine Vital Signs \n",
"227243 Manual BPs R chartevents Routine Vital Signs \n",
"227716 CPP Alarm - High chartevents Alarms \n",
"226849 RA (mean) pressure (PA Line) chartevents PA Line Insertion \n",
"226850 RV systolic pressure(PA Line) chartevents PA Line Insertion \n",
"226852 PA systolic pressure(PA Line) chartevents PA Line Insertion \n",
"228158 Purge Pressure chartevents Impella \n",
"226854 PCWP (v wave) (PA Line) chartevents PA Line Insertion \n",
"224646 Orthostatic BPs sitting chartevents Routine Vital Signs \n",
"226857 PA mean pressure (PA Line) chartevents PA Line Insertion \n",
"226855 PCWP (mean) (PA Line) chartevents PA Line Insertion \n",
"\n",
" unitname score \n",
"itemid \n",
"227023 mmHg 100.0 \n",
"223771 mmHg 100.0 \n",
"223768 mmHg 100.0 \n",
"228149 mmHg 100.0 \n",
"227990 mmHg 100.0 \n",
"226851 mmHg 100.0 \n",
"226853 mmHg 100.0 \n",
"226766 mmHg 100.0 \n",
"227717 mmHg 100.0 \n",
"227242 mmHg 100.0 \n",
"227243 mmHg 100.0 \n",
"227716 mmHg 100.0 \n",
"226849 mmHg 100.0 \n",
"226850 mmHg 100.0 \n",
"226852 mmHg 100.0 \n",
"228158 mmHg 100.0 \n",
"226854 mmHg 100.0 \n",
"224646 mmHg 100.0 \n",
"226857 mmHg 100.0 \n",
"226855 mmHg 100.0 "
]
},
"execution_count": 343,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"out_df.iloc[60:80]"
]
},
{
"cell_type": "code",
"execution_count": 344,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"keep_dict[comp_dict.INTRAVASCULAR_SYSTOLIC] += [227243]\n",
"keep_dict[comp_dict.INTRAVASCULAR_DIASTOLIC] += [227242]"
]
},
{
"cell_type": "code",
"execution_count": 345,
"metadata": {
"collapsed": true
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>label</th>\n",
" <th>abbreviation</th>\n",
" <th>linksto</th>\n",
" <th>category</th>\n",
" <th>unitname</th>\n",
" <th>score</th>\n",
" </tr>\n",
" <tr>\n",
" <th>itemid</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>224659</th>\n",
" <td>Vacuum Assist</td>\n",
" <td>Vacuum Assist</td>\n",
" <td>chartevents</td>\n",
" <td>Hemodynamics</td>\n",
" <td>mmHg</td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224652</th>\n",
" <td>Unassisted Systole</td>\n",
" <td>SYS - Unassisted</td>\n",
" <td>chartevents</td>\n",
" <td>IABP</td>\n",
" <td>mmHg</td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224654</th>\n",
" <td>PAEDP</td>\n",
" <td>DIA - Unassisted</td>\n",
" <td>chartevents</td>\n",
" <td>IABP</td>\n",
" <td>mmHg</td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7643</th>\n",
" <td>RVSYSTOLIC</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>92.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8441</th>\n",
" <td>NBP [Diastolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>85.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8364</th>\n",
" <td>ABP [Diastolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>85.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8448</th>\n",
" <td>PAP [Diastolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>85.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2027</th>\n",
" <td>Low pressure</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>84.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>455</th>\n",
" <td>NBP [Systolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>84.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>ABP [Systolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>84.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6944</th>\n",
" <td>LOW PRESSURE</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>84.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6417</th>\n",
" <td>low pressure</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>84.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7133</th>\n",
" <td>abd pressure</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>84.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6107</th>\n",
" <td>Low Pressure</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>84.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>492</th>\n",
" <td>PAP [Systolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>84.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8505</th>\n",
" <td>BP PAL [Diastolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>79.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8508</th>\n",
" <td>BP UAC [Diastolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>79.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3325</th>\n",
" <td>BP UAC [Systolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>78.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3319</th>\n",
" <td>BP PAL [Systolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>78.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6127</th>\n",
" <td>LO Press</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>78.000000</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" label abbreviation linksto category \\\n",
"itemid \n",
"224659 Vacuum Assist Vacuum Assist chartevents Hemodynamics \n",
"224652 Unassisted Systole SYS - Unassisted chartevents IABP \n",
"224654 PAEDP DIA - Unassisted chartevents IABP \n",
"7643 RVSYSTOLIC chartevents \n",
"8441 NBP [Diastolic] chartevents \n",
"8364 ABP [Diastolic] chartevents \n",
"8448 PAP [Diastolic] chartevents \n",
"2027 Low pressure chartevents \n",
"455 NBP [Systolic] chartevents \n",
"6 ABP [Systolic] chartevents \n",
"6944 LOW PRESSURE chartevents \n",
"6417 low pressure chartevents \n",
"7133 abd pressure chartevents \n",
"6107 Low Pressure chartevents \n",
"492 PAP [Systolic] chartevents \n",
"8505 BP PAL [Diastolic] chartevents \n",
"8508 BP UAC [Diastolic] chartevents \n",
"3325 BP UAC [Systolic] chartevents \n",
"3319 BP PAL [Systolic] chartevents \n",
"6127 LO Press chartevents \n",
"\n",
" unitname score \n",
"itemid \n",
"224659 mmHg 100.000000 \n",
"224652 mmHg 100.000000 \n",
"224654 mmHg 100.000000 \n",
"7643 92.666667 \n",
"8441 85.666667 \n",
"8364 85.666667 \n",
"8448 85.666667 \n",
"2027 84.333333 \n",
"455 84.333333 \n",
"6 84.333333 \n",
"6944 84.333333 \n",
"6417 84.333333 \n",
"7133 84.333333 \n",
"6107 84.333333 \n",
"492 84.333333 \n",
"8505 79.666667 \n",
"8508 79.666667 \n",
"3325 78.000000 \n",
"3319 78.000000 \n",
"6127 78.000000 "
]
},
"execution_count": 345,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"out_df.iloc[80:100]"
]
},
{
"cell_type": "code",
"execution_count": 346,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"keep_dict[comp_dict.INTRAVASCULAR_SYSTOLIC] += [455,6]\n",
"keep_dict[comp_dict.INTRAVASCULAR_DIASTOLIC] += [8441,8364]"
]
},
{
"cell_type": "code",
"execution_count": 347,
"metadata": {
"collapsed": true
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>label</th>\n",
" <th>abbreviation</th>\n",
" <th>linksto</th>\n",
" <th>category</th>\n",
" <th>unitname</th>\n",
" <th>score</th>\n",
" </tr>\n",
" <tr>\n",
" <th>itemid</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>8502</th>\n",
" <td>BP Cuff [Diastolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>77.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1404</th>\n",
" <td>Bladder pressure</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>77.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>996</th>\n",
" <td>BLADDER PRESSURE</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>77.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>993</th>\n",
" <td>bladder pressure</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>77.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1411</th>\n",
" <td>Bladder Pressure</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>77.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>46780</th>\n",
" <td>Bladdar pressure</td>\n",
" <td></td>\n",
" <td>inputevents_cv</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>77.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44862</th>\n",
" <td>BLADDER PRESSURE</td>\n",
" <td></td>\n",
" <td>inputevents_cv</td>\n",
" <td>Free Form Intake</td>\n",
" <td></td>\n",
" <td>77.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3313</th>\n",
" <td>BP Cuff [Systolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>76.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2347</th>\n",
" <td>BLADDER PRESSURE.</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>76.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>153</th>\n",
" <td>Diastolic Unloading</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>76.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6631</th>\n",
" <td>pressure low</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>75.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3108</th>\n",
" <td>PA PRESSURE</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>75.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2779</th>\n",
" <td>bladder pressures</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>75.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7504</th>\n",
" <td>Driv pressure</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>75.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>227539</th>\n",
" <td>ART Blood Pressure Alarm Source</td>\n",
" <td>ART BP Alarm Source</td>\n",
" <td></td>\n",
" <td>Alarms</td>\n",
" <td></td>\n",
" <td>74.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>666</th>\n",
" <td>Systolic Unloading</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>74.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8440</th>\n",
" <td>Manual BP [Diastolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>74.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43763</th>\n",
" <td>Bladder presure</td>\n",
" <td></td>\n",
" <td>inputevents_cv</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>74.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1509</th>\n",
" <td>bld pres</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>73.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6540</th>\n",
" <td>IntraABd pressure</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>73.666667</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" label abbreviation linksto \\\n",
"itemid \n",
"8502 BP Cuff [Diastolic] chartevents \n",
"1404 Bladder pressure chartevents \n",
"996 BLADDER PRESSURE chartevents \n",
"993 bladder pressure chartevents \n",
"1411 Bladder Pressure chartevents \n",
"46780 Bladdar pressure inputevents_cv \n",
"44862 BLADDER PRESSURE inputevents_cv \n",
"3313 BP Cuff [Systolic] chartevents \n",
"2347 BLADDER PRESSURE. chartevents \n",
"153 Diastolic Unloading chartevents \n",
"6631 pressure low chartevents \n",
"3108 PA PRESSURE chartevents \n",
"2779 bladder pressures chartevents \n",
"7504 Driv pressure chartevents \n",
"227539 ART Blood Pressure Alarm Source ART BP Alarm Source \n",
"666 Systolic Unloading chartevents \n",
"8440 Manual BP [Diastolic] chartevents \n",
"43763 Bladder presure inputevents_cv \n",
"1509 bld pres chartevents \n",
"6540 IntraABd pressure chartevents \n",
"\n",
" category unitname score \n",
"itemid \n",
"8502 77.666667 \n",
"1404 77.000000 \n",
"996 77.000000 \n",
"993 77.000000 \n",
"1411 77.000000 \n",
"46780 77.000000 \n",
"44862 Free Form Intake 77.000000 \n",
"3313 76.333333 \n",
"2347 76.000000 \n",
"153 76.000000 \n",
"6631 75.666667 \n",
"3108 75.333333 \n",
"2779 75.000000 \n",
"7504 75.000000 \n",
"227539 Alarms 74.666667 \n",
"666 74.666667 \n",
"8440 74.666667 \n",
"43763 74.333333 \n",
"1509 73.666667 \n",
"6540 73.666667 "
]
},
"execution_count": 347,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"out_df.iloc[100:120]"
]
},
{
"cell_type": "code",
"execution_count": 348,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"keep_dict[comp_dict.INTRAVASCULAR_SYSTOLIC] += [3313]\n",
"keep_dict[comp_dict.INTRAVASCULAR_DIASTOLIC] += [8502,8440]"
]
},
{
"cell_type": "code",
"execution_count": 349,
"metadata": {
"collapsed": true
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>label</th>\n",
" <th>abbreviation</th>\n",
" <th>linksto</th>\n",
" <th>category</th>\n",
" <th>unitname</th>\n",
" <th>score</th>\n",
" </tr>\n",
" <tr>\n",
" <th>itemid</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>442</th>\n",
" <td>Manual BP [Systolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>73.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6302</th>\n",
" <td>low press</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>72.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43744</th>\n",
" <td>NS bladder pressure</td>\n",
" <td></td>\n",
" <td>inputevents_cv</td>\n",
" <td>Free Form Intake</td>\n",
" <td></td>\n",
" <td>72.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7124</th>\n",
" <td>Low pressure Alarm</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>72.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45682</th>\n",
" <td>bladder pressure in</td>\n",
" <td></td>\n",
" <td>inputevents_cv</td>\n",
" <td>Free Form Intake</td>\n",
" <td></td>\n",
" <td>72.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2562</th>\n",
" <td>INTRA ABD PRESSURE</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>72.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8368</th>\n",
" <td>Arterial BP [Diastolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>72.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8503</th>\n",
" <td>BP Left Arm [Diastolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>72.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8504</th>\n",
" <td>BP Left Leg [Diastolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>72.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42735</th>\n",
" <td>Intra-abd. Pressure</td>\n",
" <td></td>\n",
" <td>inputevents_cv</td>\n",
" <td>Free Form Intake</td>\n",
" <td></td>\n",
" <td>71.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8507</th>\n",
" <td>BP Right Leg [Diastolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>71.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44344</th>\n",
" <td>BLADDER PRESSURE FLD</td>\n",
" <td></td>\n",
" <td>inputevents_cv</td>\n",
" <td>Free Form Intake</td>\n",
" <td></td>\n",
" <td>71.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3238</th>\n",
" <td>CSF PRESSURE</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>71.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44187</th>\n",
" <td>Blood emesis</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td>Free Form Intake</td>\n",
" <td></td>\n",
" <td>71.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8506</th>\n",
" <td>BP Right Arm [Diastolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>71.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2965</th>\n",
" <td>INTRAABDOM. PRESSURE</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>70.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3315</th>\n",
" <td>BP Left Arm [Systolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>70.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>51</th>\n",
" <td>Arterial BP [Systolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>70.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3317</th>\n",
" <td>BP Left Leg [Systolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>70.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7574</th>\n",
" <td>lumbar pressure</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>69.666667</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" label abbreviation linksto \\\n",
"itemid \n",
"442 Manual BP [Systolic] chartevents \n",
"6302 low press chartevents \n",
"43744 NS bladder pressure inputevents_cv \n",
"7124 Low pressure Alarm chartevents \n",
"45682 bladder pressure in inputevents_cv \n",
"2562 INTRA ABD PRESSURE chartevents \n",
"8368 Arterial BP [Diastolic] chartevents \n",
"8503 BP Left Arm [Diastolic] chartevents \n",
"8504 BP Left Leg [Diastolic] chartevents \n",
"42735 Intra-abd. Pressure inputevents_cv \n",
"8507 BP Right Leg [Diastolic] chartevents \n",
"44344 BLADDER PRESSURE FLD inputevents_cv \n",
"3238 CSF PRESSURE chartevents \n",
"44187 Blood emesis outputevents \n",
"8506 BP Right Arm [Diastolic] chartevents \n",
"2965 INTRAABDOM. PRESSURE chartevents \n",
"3315 BP Left Arm [Systolic] chartevents \n",
"51 Arterial BP [Systolic] chartevents \n",
"3317 BP Left Leg [Systolic] chartevents \n",
"7574 lumbar pressure chartevents \n",
"\n",
" category unitname score \n",
"itemid \n",
"442 73.000000 \n",
"6302 72.666667 \n",
"43744 Free Form Intake 72.333333 \n",
"7124 72.333333 \n",
"45682 Free Form Intake 72.333333 \n",
"2562 72.333333 \n",
"8368 72.000000 \n",
"8503 72.000000 \n",
"8504 72.000000 \n",
"42735 Free Form Intake 71.666667 \n",
"8507 71.000000 \n",
"44344 Free Form Intake 71.000000 \n",
"3238 71.000000 \n",
"44187 Free Form Intake 71.000000 \n",
"8506 71.000000 \n",
"2965 70.333333 \n",
"3315 70.000000 \n",
"51 70.000000 \n",
"3317 70.000000 \n",
"7574 69.666667 "
]
},
"execution_count": 349,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"out_df.iloc[120:140]"
]
},
{
"cell_type": "code",
"execution_count": 350,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"keep_dict[comp_dict.INTRAVASCULAR_SYSTOLIC] += [442,3315,51,3317]\n",
"keep_dict[comp_dict.INTRAVASCULAR_DIASTOLIC] += [8368,8503,8504,8507,8506]"
]
},
{
"cell_type": "code",
"execution_count": 351,
"metadata": {
"collapsed": true
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>label</th>\n",
" <th>abbreviation</th>\n",
" <th>linksto</th>\n",
" <th>category</th>\n",
" <th>unitname</th>\n",
" <th>score</th>\n",
" </tr>\n",
" <tr>\n",
" <th>itemid</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>2704</th>\n",
" <td>ABDOMINAL PRESSURE</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>69.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3321</th>\n",
" <td>BP Right Arm [Systolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>69.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3323</th>\n",
" <td>BP Right Leg [Systolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>69.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8555</th>\n",
" <td>Arterial BP #2 [Diastolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>69.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>70015</th>\n",
" <td>BLOOD</td>\n",
" <td></td>\n",
" <td>microbiologyevents</td>\n",
" <td>SPECIMEN</td>\n",
" <td></td>\n",
" <td>68.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6864</th>\n",
" <td>Low insp pressure</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>68.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>51466</th>\n",
" <td>BLOOD</td>\n",
" <td>NaN</td>\n",
" <td>labevents</td>\n",
" <td>HEMATOLOGY</td>\n",
" <td>NaN</td>\n",
" <td>68.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3143</th>\n",
" <td>low insp pressure</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>68.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44560</th>\n",
" <td>blood</td>\n",
" <td></td>\n",
" <td>inputevents_cv</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>68.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>Access mmHg</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>68.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7176</th>\n",
" <td>low insp. pressure</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>68.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>436</th>\n",
" <td>Low Insp. Pressure</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>68.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43901</th>\n",
" <td>blood loss</td>\n",
" <td></td>\n",
" <td>inputevents_cv</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>68.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>226579</th>\n",
" <td>Stool</td>\n",
" <td>Stool</td>\n",
" <td>outputevents</td>\n",
" <td>Output</td>\n",
" <td>mL</td>\n",
" <td>68.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>70064</th>\n",
" <td>STOOL</td>\n",
" <td></td>\n",
" <td>microbiologyevents</td>\n",
" <td>SPECIMEN</td>\n",
" <td></td>\n",
" <td>68.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>41670</th>\n",
" <td>stool</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>68.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1003</th>\n",
" <td>cuff pressure</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>67.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5786</th>\n",
" <td>high pressure</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>67.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2025</th>\n",
" <td>High pressure</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>67.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5668</th>\n",
" <td>CUFF PRESSURE</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>67.666667</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" label abbreviation linksto \\\n",
"itemid \n",
"2704 ABDOMINAL PRESSURE chartevents \n",
"3321 BP Right Arm [Systolic] chartevents \n",
"3323 BP Right Leg [Systolic] chartevents \n",
"8555 Arterial BP #2 [Diastolic] chartevents \n",
"70015 BLOOD microbiologyevents \n",
"6864 Low insp pressure chartevents \n",
"51466 BLOOD NaN labevents \n",
"3143 low insp pressure chartevents \n",
"44560 blood inputevents_cv \n",
"29 Access mmHg chartevents \n",
"7176 low insp. pressure chartevents \n",
"436 Low Insp. Pressure chartevents \n",
"43901 blood loss inputevents_cv \n",
"226579 Stool Stool outputevents \n",
"70064 STOOL microbiologyevents \n",
"41670 stool outputevents \n",
"1003 cuff pressure chartevents \n",
"5786 high pressure chartevents \n",
"2025 High pressure chartevents \n",
"5668 CUFF PRESSURE chartevents \n",
"\n",
" category unitname score \n",
"itemid \n",
"2704 69.666667 \n",
"3321 69.000000 \n",
"3323 69.000000 \n",
"8555 69.000000 \n",
"70015 SPECIMEN 68.666667 \n",
"6864 68.666667 \n",
"51466 HEMATOLOGY NaN 68.666667 \n",
"3143 68.666667 \n",
"44560 68.666667 \n",
"29 68.666667 \n",
"7176 68.000000 \n",
"436 68.000000 \n",
"43901 68.000000 \n",
"226579 Output mL 68.000000 \n",
"70064 SPECIMEN 68.000000 \n",
"41670 68.000000 \n",
"1003 67.666667 \n",
"5786 67.666667 \n",
"2025 67.666667 \n",
"5668 67.666667 "
]
},
"execution_count": 351,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"out_df.iloc[140:160]"
]
},
{
"cell_type": "code",
"execution_count": 352,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"keep_dict[comp_dict.INTRAVASCULAR_SYSTOLIC] += [3321,3323]\n",
"keep_dict[comp_dict.INTRAVASCULAR_DIASTOLIC] += [8555]"
]
},
{
"cell_type": "code",
"execution_count": 353,
"metadata": {
"collapsed": true
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>label</th>\n",
" <th>abbreviation</th>\n",
" <th>linksto</th>\n",
" <th>category</th>\n",
" <th>unitname</th>\n",
" <th>score</th>\n",
" </tr>\n",
" <tr>\n",
" <th>itemid</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>220179</th>\n",
" <td>Non Invasive Blood Pressure systolic</td>\n",
" <td>NBPs</td>\n",
" <td>chartevents</td>\n",
" <td>Routine Vital Signs</td>\n",
" <td>mmHg</td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>225309</th>\n",
" <td>ART BP Systolic</td>\n",
" <td>ART BP Systolic</td>\n",
" <td>chartevents</td>\n",
" <td>Routine Vital Signs</td>\n",
" <td>mmHg</td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224167</th>\n",
" <td>Manual Blood Pressure Systolic Left</td>\n",
" <td>Manual BPs L</td>\n",
" <td>chartevents</td>\n",
" <td>Routine Vital Signs</td>\n",
" <td>mmHg</td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>220050</th>\n",
" <td>Arterial Blood Pressure systolic</td>\n",
" <td>ABPs</td>\n",
" <td>chartevents</td>\n",
" <td>Routine Vital Signs</td>\n",
" <td>mmHg</td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>227243</th>\n",
" <td>Manual Blood Pressure Systolic Right</td>\n",
" <td>Manual BPs R</td>\n",
" <td>chartevents</td>\n",
" <td>Routine Vital Signs</td>\n",
" <td>mmHg</td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>455</th>\n",
" <td>NBP [Systolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>84.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>ABP [Systolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>84.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3313</th>\n",
" <td>BP Cuff [Systolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>76.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>442</th>\n",
" <td>Manual BP [Systolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>73.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3315</th>\n",
" <td>BP Left Arm [Systolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>70.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>51</th>\n",
" <td>Arterial BP [Systolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>70.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3317</th>\n",
" <td>BP Left Leg [Systolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>70.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3321</th>\n",
" <td>BP Right Arm [Systolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>69.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3323</th>\n",
" <td>BP Right Leg [Systolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>69.000000</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" label abbreviation linksto \\\n",
"itemid \n",
"220179 Non Invasive Blood Pressure systolic NBPs chartevents \n",
"225309 ART BP Systolic ART BP Systolic chartevents \n",
"224167 Manual Blood Pressure Systolic Left Manual BPs L chartevents \n",
"220050 Arterial Blood Pressure systolic ABPs chartevents \n",
"227243 Manual Blood Pressure Systolic Right Manual BPs R chartevents \n",
"455 NBP [Systolic] chartevents \n",
"6 ABP [Systolic] chartevents \n",
"3313 BP Cuff [Systolic] chartevents \n",
"442 Manual BP [Systolic] chartevents \n",
"3315 BP Left Arm [Systolic] chartevents \n",
"51 Arterial BP [Systolic] chartevents \n",
"3317 BP Left Leg [Systolic] chartevents \n",
"3321 BP Right Arm [Systolic] chartevents \n",
"3323 BP Right Leg [Systolic] chartevents \n",
"\n",
" category unitname score \n",
"itemid \n",
"220179 Routine Vital Signs mmHg 100.000000 \n",
"225309 Routine Vital Signs mmHg 100.000000 \n",
"224167 Routine Vital Signs mmHg 100.000000 \n",
"220050 Routine Vital Signs mmHg 100.000000 \n",
"227243 Routine Vital Signs mmHg 100.000000 \n",
"455 84.333333 \n",
"6 84.333333 \n",
"3313 76.333333 \n",
"442 73.000000 \n",
"3315 70.000000 \n",
"51 70.000000 \n",
"3317 70.000000 \n",
"3321 69.000000 \n",
"3323 69.000000 "
]
},
"execution_count": 353,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"out_df.loc[keep_dict[comp_dict.INTRAVASCULAR_SYSTOLIC]]"
]
},
{
"cell_type": "code",
"execution_count": 354,
"metadata": {
"collapsed": true
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>label</th>\n",
" <th>abbreviation</th>\n",
" <th>linksto</th>\n",
" <th>category</th>\n",
" <th>unitname</th>\n",
" <th>score</th>\n",
" </tr>\n",
" <tr>\n",
" <th>itemid</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>220180</th>\n",
" <td>Non Invasive Blood Pressure diastolic</td>\n",
" <td>NBPd</td>\n",
" <td>chartevents</td>\n",
" <td>Routine Vital Signs</td>\n",
" <td>mmHg</td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>225310</th>\n",
" <td>ART BP Diastolic</td>\n",
" <td>ART BP Diastolic</td>\n",
" <td>chartevents</td>\n",
" <td>Routine Vital Signs</td>\n",
" <td>mmHg</td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224643</th>\n",
" <td>Manual Blood Pressure Diastolic Left</td>\n",
" <td>Manual BPd L</td>\n",
" <td>chartevents</td>\n",
" <td>Routine Vital Signs</td>\n",
" <td>mmHg</td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>220051</th>\n",
" <td>Arterial Blood Pressure diastolic</td>\n",
" <td>ABPd</td>\n",
" <td>chartevents</td>\n",
" <td>Routine Vital Signs</td>\n",
" <td>mmHg</td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>227242</th>\n",
" <td>Manual Blood Pressure Diastolic Right</td>\n",
" <td>Manual BPd R</td>\n",
" <td>chartevents</td>\n",
" <td>Routine Vital Signs</td>\n",
" <td>mmHg</td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8441</th>\n",
" <td>NBP [Diastolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>85.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8364</th>\n",
" <td>ABP [Diastolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>85.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8502</th>\n",
" <td>BP Cuff [Diastolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>77.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8440</th>\n",
" <td>Manual BP [Diastolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>74.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8368</th>\n",
" <td>Arterial BP [Diastolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>72.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8503</th>\n",
" <td>BP Left Arm [Diastolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>72.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8504</th>\n",
" <td>BP Left Leg [Diastolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>72.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8507</th>\n",
" <td>BP Right Leg [Diastolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>71.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8506</th>\n",
" <td>BP Right Arm [Diastolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>71.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8555</th>\n",
" <td>Arterial BP #2 [Diastolic]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>69.000000</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" label abbreviation linksto \\\n",
"itemid \n",
"220180 Non Invasive Blood Pressure diastolic NBPd chartevents \n",
"225310 ART BP Diastolic ART BP Diastolic chartevents \n",
"224643 Manual Blood Pressure Diastolic Left Manual BPd L chartevents \n",
"220051 Arterial Blood Pressure diastolic ABPd chartevents \n",
"227242 Manual Blood Pressure Diastolic Right Manual BPd R chartevents \n",
"8441 NBP [Diastolic] chartevents \n",
"8364 ABP [Diastolic] chartevents \n",
"8502 BP Cuff [Diastolic] chartevents \n",
"8440 Manual BP [Diastolic] chartevents \n",
"8368 Arterial BP [Diastolic] chartevents \n",
"8503 BP Left Arm [Diastolic] chartevents \n",
"8504 BP Left Leg [Diastolic] chartevents \n",
"8507 BP Right Leg [Diastolic] chartevents \n",
"8506 BP Right Arm [Diastolic] chartevents \n",
"8555 Arterial BP #2 [Diastolic] chartevents \n",
"\n",
" category unitname score \n",
"itemid \n",
"220180 Routine Vital Signs mmHg 100.000000 \n",
"225310 Routine Vital Signs mmHg 100.000000 \n",
"224643 Routine Vital Signs mmHg 100.000000 \n",
"220051 Routine Vital Signs mmHg 100.000000 \n",
"227242 Routine Vital Signs mmHg 100.000000 \n",
"8441 85.666667 \n",
"8364 85.666667 \n",
"8502 77.666667 \n",
"8440 74.666667 \n",
"8368 72.000000 \n",
"8503 72.000000 \n",
"8504 72.000000 \n",
"8507 71.000000 \n",
"8506 71.000000 \n",
"8555 69.000000 "
]
},
"execution_count": 354,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"out_df.loc[keep_dict[comp_dict.INTRAVASCULAR_DIASTOLIC]]"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## O2 Sat"
]
},
{
"cell_type": "code",
"execution_count": 359,
"metadata": {
"collapsed": false,
"scrolled": true
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>label</th>\n",
" <th>abbreviation</th>\n",
" <th>linksto</th>\n",
" <th>category</th>\n",
" <th>unitname</th>\n",
" <th>score</th>\n",
" </tr>\n",
" <tr>\n",
" <th>itemid</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>50817</th>\n",
" <td>OXYGEN SATURATION</td>\n",
" <td>NaN</td>\n",
" <td>labevents</td>\n",
" <td>BLOOD GAS</td>\n",
" <td>NaN</td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>646</th>\n",
" <td>SpO2</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>220277</th>\n",
" <td>O2 saturation pulseoxymetry</td>\n",
" <td>SpO2</td>\n",
" <td>chartevents</td>\n",
" <td>Respiratory</td>\n",
" <td>%</td>\n",
" <td>100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>228232</th>\n",
" <td>PAR-Oxygen saturation</td>\n",
" <td>PAR-Oxygen saturation</td>\n",
" <td></td>\n",
" <td>Routine Vital Signs</td>\n",
" <td></td>\n",
" <td>92.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3785</th>\n",
" <td>PO2</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td>ABG's</td>\n",
" <td></td>\n",
" <td>90.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>50821</th>\n",
" <td>PO2</td>\n",
" <td>NaN</td>\n",
" <td>labevents</td>\n",
" <td>BLOOD GAS</td>\n",
" <td>NaN</td>\n",
" <td>90.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3837</th>\n",
" <td>pO2</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td>ABG'S</td>\n",
" <td></td>\n",
" <td>90.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6719</th>\n",
" <td>SpO2-L</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>86.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2955</th>\n",
" <td>JVO2 SAT</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>78.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2574</th>\n",
" <td>MVO2 SAT</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>78.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3835</th>\n",
" <td>pCO2</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td>ABG'S</td>\n",
" <td></td>\n",
" <td>75.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>50818</th>\n",
" <td>PCO2</td>\n",
" <td>NaN</td>\n",
" <td>labevents</td>\n",
" <td>BLOOD GAS</td>\n",
" <td>NaN</td>\n",
" <td>75.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>220227</th>\n",
" <td>Arterial O2 Saturation</td>\n",
" <td>SaO2</td>\n",
" <td>chartevents</td>\n",
" <td>Labs</td>\n",
" <td>%</td>\n",
" <td>75.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>838</th>\n",
" <td>SvO2</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td>Mixed Venous Gases</td>\n",
" <td></td>\n",
" <td>75.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3784</th>\n",
" <td>PCO2</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td>ABG's</td>\n",
" <td></td>\n",
" <td>75.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2194</th>\n",
" <td>SVO2</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>75.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>834</th>\n",
" <td>SaO2</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td>ABG's</td>\n",
" <td></td>\n",
" <td>75.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>223772</th>\n",
" <td>SvO2</td>\n",
" <td>SvO2</td>\n",
" <td>chartevents</td>\n",
" <td>Hemodynamics</td>\n",
" <td>%</td>\n",
" <td>75.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2641</th>\n",
" <td>SJO2</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>75.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>490</th>\n",
" <td>PAO2</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>75.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2774</th>\n",
" <td>sjo2</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>75.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2669</th>\n",
" <td>svo2</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>75.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2639</th>\n",
" <td>JPO2</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>75.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2842</th>\n",
" <td>JV O2 Sat</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>74.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5636</th>\n",
" <td>2nd O2 Sat</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>71.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>50984</th>\n",
" <td>STAT</td>\n",
" <td>NaN</td>\n",
" <td>labevents</td>\n",
" <td>CHEMISTRY</td>\n",
" <td>NaN</td>\n",
" <td>69.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>472</th>\n",
" <td>O2AV</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>69.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45783</th>\n",
" <td>SPC28</td>\n",
" <td></td>\n",
" <td>inputevents_cv</td>\n",
" <td>Free Form Intake</td>\n",
" <td></td>\n",
" <td>69.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1725</th>\n",
" <td>Pulse</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>68.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3288</th>\n",
" <td>O2 sat [Pre]</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>68.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1332</th>\n",
" <td>pulse</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>68.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1341</th>\n",
" <td>PULSE</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>68.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>50816</th>\n",
" <td>OXYGEN</td>\n",
" <td>NaN</td>\n",
" <td>labevents</td>\n",
" <td>BLOOD GAS</td>\n",
" <td>NaN</td>\n",
" <td>68.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2933</th>\n",
" <td>SVO2 SAT</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>67.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>227008</th>\n",
" <td>Ejection Fraction</td>\n",
" <td>Ejection Fraction</td>\n",
" <td>chartevents</td>\n",
" <td>Scores - APACHE IV (2)</td>\n",
" <td>%</td>\n",
" <td>66.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224704</th>\n",
" <td>ATC %</td>\n",
" <td>ATC %</td>\n",
" <td>chartevents</td>\n",
" <td>Respiratory</td>\n",
" <td>%</td>\n",
" <td>66.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>226993</th>\n",
" <td>ApacheIV_LOS</td>\n",
" <td>ApacheIV_LOS</td>\n",
" <td>chartevents</td>\n",
" <td>Scores - APACHE IV (2)</td>\n",
" <td>%</td>\n",
" <td>66.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>227010</th>\n",
" <td>FiO2_ApacheIV</td>\n",
" <td>FiO2_ApacheIV</td>\n",
" <td>chartevents</td>\n",
" <td>Scores - APACHE IV (2)</td>\n",
" <td>%</td>\n",
" <td>66.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>223770</th>\n",
" <td>O2 Saturation Pulseoxymetry Alarm - Low</td>\n",
" <td>SpO2 Alarm - Low</td>\n",
" <td>chartevents</td>\n",
" <td>Alarms</td>\n",
" <td>%</td>\n",
" <td>66.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>227873</th>\n",
" <td>Recovery O2 Sat - Aerobic Capacity</td>\n",
" <td>Recovery O2 Sat - Aerobic Capacity</td>\n",
" <td>chartevents</td>\n",
" <td>OT Notes</td>\n",
" <td>%</td>\n",
" <td>66.666667</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" label \\\n",
"itemid \n",
"50817 OXYGEN SATURATION \n",
"646 SpO2 \n",
"220277 O2 saturation pulseoxymetry \n",
"228232 PAR-Oxygen saturation \n",
"3785 PO2 \n",
"50821 PO2 \n",
"3837 pO2 \n",
"6719 SpO2-L \n",
"2955 JVO2 SAT \n",
"2574 MVO2 SAT \n",
"3835 pCO2 \n",
"50818 PCO2 \n",
"220227 Arterial O2 Saturation \n",
"838 SvO2 \n",
"3784 PCO2 \n",
"2194 SVO2 \n",
"834 SaO2 \n",
"223772 SvO2 \n",
"2641 SJO2 \n",
"490 PAO2 \n",
"2774 sjo2 \n",
"2669 svo2 \n",
"2639 JPO2 \n",
"2842 JV O2 Sat \n",
"5636 2nd O2 Sat \n",
"50984 STAT \n",
"472 O2AV \n",
"45783 SPC28 \n",
"1725 Pulse \n",
"3288 O2 sat [Pre] \n",
"1332 pulse \n",
"1341 PULSE \n",
"50816 OXYGEN \n",
"2933 SVO2 SAT \n",
"227008 Ejection Fraction \n",
"224704 ATC % \n",
"226993 ApacheIV_LOS \n",
"227010 FiO2_ApacheIV \n",
"223770 O2 Saturation Pulseoxymetry Alarm - Low \n",
"227873 Recovery O2 Sat - Aerobic Capacity \n",
"\n",
" abbreviation linksto \\\n",
"itemid \n",
"50817 NaN labevents \n",
"646 chartevents \n",
"220277 SpO2 chartevents \n",
"228232 PAR-Oxygen saturation \n",
"3785 chartevents \n",
"50821 NaN labevents \n",
"3837 chartevents \n",
"6719 chartevents \n",
"2955 chartevents \n",
"2574 chartevents \n",
"3835 chartevents \n",
"50818 NaN labevents \n",
"220227 SaO2 chartevents \n",
"838 chartevents \n",
"3784 chartevents \n",
"2194 chartevents \n",
"834 chartevents \n",
"223772 SvO2 chartevents \n",
"2641 chartevents \n",
"490 chartevents \n",
"2774 chartevents \n",
"2669 chartevents \n",
"2639 chartevents \n",
"2842 chartevents \n",
"5636 chartevents \n",
"50984 NaN labevents \n",
"472 chartevents \n",
"45783 inputevents_cv \n",
"1725 chartevents \n",
"3288 chartevents \n",
"1332 chartevents \n",
"1341 chartevents \n",
"50816 NaN labevents \n",
"2933 chartevents \n",
"227008 Ejection Fraction chartevents \n",
"224704 ATC % chartevents \n",
"226993 ApacheIV_LOS chartevents \n",
"227010 FiO2_ApacheIV chartevents \n",
"223770 SpO2 Alarm - Low chartevents \n",
"227873 Recovery O2 Sat - Aerobic Capacity chartevents \n",
"\n",
" category unitname score \n",
"itemid \n",
"50817 BLOOD GAS NaN 100.000000 \n",
"646 100.000000 \n",
"220277 Respiratory % 100.000000 \n",
"228232 Routine Vital Signs 92.666667 \n",
"3785 ABG's 90.666667 \n",
"50821 BLOOD GAS NaN 90.666667 \n",
"3837 ABG'S 90.666667 \n",
"6719 86.666667 \n",
"2955 78.000000 \n",
"2574 78.000000 \n",
"3835 ABG'S 75.000000 \n",
"50818 BLOOD GAS NaN 75.000000 \n",
"220227 Labs % 75.000000 \n",
"838 Mixed Venous Gases 75.000000 \n",
"3784 ABG's 75.000000 \n",
"2194 75.000000 \n",
"834 ABG's 75.000000 \n",
"223772 Hemodynamics % 75.000000 \n",
"2641 75.000000 \n",
"490 75.000000 \n",
"2774 75.000000 \n",
"2669 75.000000 \n",
"2639 75.000000 \n",
"2842 74.000000 \n",
"5636 71.333333 \n",
"50984 CHEMISTRY NaN 69.666667 \n",
"472 69.666667 \n",
"45783 Free Form Intake 69.666667 \n",
"1725 68.666667 \n",
"3288 68.666667 \n",
"1332 68.666667 \n",
"1341 68.666667 \n",
"50816 BLOOD GAS NaN 68.000000 \n",
"2933 67.666667 \n",
"227008 Scores - APACHE IV (2) % 66.666667 \n",
"224704 Respiratory % 66.666667 \n",
"226993 Scores - APACHE IV (2) % 66.666667 \n",
"227010 Scores - APACHE IV (2) % 66.666667 \n",
"223770 Alarms % 66.666667 \n",
"227873 OT Notes % 66.666667 "
]
},
"execution_count": 359,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"out_df = exp.search(['oxygen saturation','O2sat','pulse oximetry','%','spo2'])\n",
"out_df.head(40)"
]
},
{
"cell_type": "code",
"execution_count": 360,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"keep_dict[comp_dict.OXYGEN_SATURATION.name] = [646,220277,228232]"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Urine Output"
]
},
{
"cell_type": "code",
"execution_count": 378,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>label</th>\n",
" <th>abbreviation</th>\n",
" <th>linksto</th>\n",
" <th>category</th>\n",
" <th>unitname</th>\n",
" <th>score</th>\n",
" </tr>\n",
" <tr>\n",
" <th>itemid</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>226560</th>\n",
" <td>Void</td>\n",
" <td>Void</td>\n",
" <td>outputevents</td>\n",
" <td>Output</td>\n",
" <td>mL</td>\n",
" <td>110.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43332</th>\n",
" <td>void</td>\n",
" <td></td>\n",
" <td>inputevents_cv</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>110.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7672</th>\n",
" <td>Foley</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>110.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3686</th>\n",
" <td>Void</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>110.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45967</th>\n",
" <td>foley</td>\n",
" <td></td>\n",
" <td>inputevents_cv</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>110.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43053</th>\n",
" <td>URINE OUT</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>110.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>226559</th>\n",
" <td>Foley</td>\n",
" <td>Foley</td>\n",
" <td>outputevents</td>\n",
" <td>Output</td>\n",
" <td>mL</td>\n",
" <td>110.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44103</th>\n",
" <td>ER urine out</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>100.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44834</th>\n",
" <td>er urine out</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>100.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>227519</th>\n",
" <td>Urine output_ApacheIV</td>\n",
" <td>Urine output</td>\n",
" <td>chartevents</td>\n",
" <td>Scores - APACHE IV (2)</td>\n",
" <td>None</td>\n",
" <td>100.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44706</th>\n",
" <td>urine output</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>100.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42892</th>\n",
" <td>EW URINE OUT</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>100.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45415</th>\n",
" <td>ED Urine OUT</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>100.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43987</th>\n",
" <td>urine out or</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>100.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42666</th>\n",
" <td>E.R. URINE OUT</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>96.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44237</th>\n",
" <td>E.R. urine out</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>96.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42592</th>\n",
" <td>VICU URINE OUT</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>95.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>40069</th>\n",
" <td>Urine Out Void</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>95.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>46423</th>\n",
" <td>ed foley</td>\n",
" <td></td>\n",
" <td>inputevents_cv</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>94.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43931</th>\n",
" <td>Floor urine out</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>93.333333</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" label abbreviation linksto \\\n",
"itemid \n",
"226560 Void Void outputevents \n",
"43332 void inputevents_cv \n",
"7672 Foley chartevents \n",
"3686 Void chartevents \n",
"45967 foley inputevents_cv \n",
"43053 URINE OUT outputevents \n",
"226559 Foley Foley outputevents \n",
"44103 ER urine out outputevents \n",
"44834 er urine out outputevents \n",
"227519 Urine output_ApacheIV Urine output chartevents \n",
"44706 urine output outputevents \n",
"42892 EW URINE OUT outputevents \n",
"45415 ED Urine OUT outputevents \n",
"43987 urine out or outputevents \n",
"42666 E.R. URINE OUT outputevents \n",
"44237 E.R. urine out outputevents \n",
"42592 VICU URINE OUT outputevents \n",
"40069 Urine Out Void outputevents \n",
"46423 ed foley inputevents_cv \n",
"43931 Floor urine out outputevents \n",
"\n",
" category unitname score \n",
"itemid \n",
"226560 Output mL 110.000000 \n",
"43332 110.000000 \n",
"7672 110.000000 \n",
"3686 110.000000 \n",
"45967 110.000000 \n",
"43053 110.000000 \n",
"226559 Output mL 110.000000 \n",
"44103 100.666667 \n",
"44834 100.666667 \n",
"227519 Scores - APACHE IV (2) None 100.666667 \n",
"44706 100.666667 \n",
"42892 100.666667 \n",
"45415 100.666667 \n",
"43987 100.666667 \n",
"42666 96.666667 \n",
"44237 96.666667 \n",
"42592 95.333333 \n",
"40069 95.333333 \n",
"46423 94.666667 \n",
"43931 93.333333 "
]
},
"execution_count": 378,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"out_df = exp.search(['urine out','void','foley'])\n",
"out_df.head(20)"
]
},
{
"cell_type": "code",
"execution_count": 379,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>label</th>\n",
" <th>abbreviation</th>\n",
" <th>linksto</th>\n",
" <th>category</th>\n",
" <th>unitname</th>\n",
" <th>score</th>\n",
" </tr>\n",
" <tr>\n",
" <th>itemid</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>226560</th>\n",
" <td>Void</td>\n",
" <td>Void</td>\n",
" <td>outputevents</td>\n",
" <td>Output</td>\n",
" <td>mL</td>\n",
" <td>110.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43332</th>\n",
" <td>void</td>\n",
" <td></td>\n",
" <td>inputevents_cv</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>110.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7672</th>\n",
" <td>Foley</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>110.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3686</th>\n",
" <td>Void</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>110.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45967</th>\n",
" <td>foley</td>\n",
" <td></td>\n",
" <td>inputevents_cv</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>110.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43053</th>\n",
" <td>URINE OUT</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>110.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>226559</th>\n",
" <td>Foley</td>\n",
" <td>Foley</td>\n",
" <td>outputevents</td>\n",
" <td>Output</td>\n",
" <td>mL</td>\n",
" <td>110.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44103</th>\n",
" <td>ER urine out</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>100.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44834</th>\n",
" <td>er urine out</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>100.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>227519</th>\n",
" <td>Urine output_ApacheIV</td>\n",
" <td>Urine output</td>\n",
" <td>chartevents</td>\n",
" <td>Scores - APACHE IV (2)</td>\n",
" <td>None</td>\n",
" <td>100.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44706</th>\n",
" <td>urine output</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>100.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42892</th>\n",
" <td>EW URINE OUT</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>100.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45415</th>\n",
" <td>ED Urine OUT</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>100.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43987</th>\n",
" <td>urine out or</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>100.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42666</th>\n",
" <td>E.R. URINE OUT</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>96.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44237</th>\n",
" <td>E.R. urine out</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>96.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42592</th>\n",
" <td>VICU URINE OUT</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>95.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>40069</th>\n",
" <td>Urine Out Void</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>95.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>46423</th>\n",
" <td>ed foley</td>\n",
" <td></td>\n",
" <td>inputevents_cv</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>94.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43931</th>\n",
" <td>Floor urine out</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>93.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43348</th>\n",
" <td>urine output/kg</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>93.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>40405</th>\n",
" <td>Urine Out Other</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>93.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42810</th>\n",
" <td>angio urine out</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>93.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>46180</th>\n",
" <td>urine out-angio</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>93.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>40055</th>\n",
" <td>Urine Out Foley</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>93.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44253</th>\n",
" <td>Urine out angio</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>93.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44325</th>\n",
" <td>ED URINE OUTPUT</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>93.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>41857</th>\n",
" <td>urine out in er</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>93.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44824</th>\n",
" <td>EW urine output</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>93.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45991</th>\n",
" <td>ew-urine output</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>93.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42042</th>\n",
" <td>ANGIO URINE OUT</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>93.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>46177</th>\n",
" <td>URINE OUT-ANGIO</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>93.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44684</th>\n",
" <td>floor urine out</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>93.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>46658</th>\n",
" <td>ED Urine output</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>93.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>46578</th>\n",
" <td>URINE OUTPUT-ER</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>93.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42765</th>\n",
" <td>FARR 6 URINE OUT</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>91.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>70081</th>\n",
" <td>URINE</td>\n",
" <td></td>\n",
" <td>microbiologyevents</td>\n",
" <td>SPECIMEN</td>\n",
" <td></td>\n",
" <td>90.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3819</th>\n",
" <td>Urine Leukocytes</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td>Urine</td>\n",
" <td></td>\n",
" <td>90.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>70079</th>\n",
" <td>URINE</td>\n",
" <td></td>\n",
" <td>microbiologyevents</td>\n",
" <td>SPECIMEN</td>\n",
" <td></td>\n",
" <td>90.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43462</th>\n",
" <td>urine</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>90.666667</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" label abbreviation linksto \\\n",
"itemid \n",
"226560 Void Void outputevents \n",
"43332 void inputevents_cv \n",
"7672 Foley chartevents \n",
"3686 Void chartevents \n",
"45967 foley inputevents_cv \n",
"43053 URINE OUT outputevents \n",
"226559 Foley Foley outputevents \n",
"44103 ER urine out outputevents \n",
"44834 er urine out outputevents \n",
"227519 Urine output_ApacheIV Urine output chartevents \n",
"44706 urine output outputevents \n",
"42892 EW URINE OUT outputevents \n",
"45415 ED Urine OUT outputevents \n",
"43987 urine out or outputevents \n",
"42666 E.R. URINE OUT outputevents \n",
"44237 E.R. urine out outputevents \n",
"42592 VICU URINE OUT outputevents \n",
"40069 Urine Out Void outputevents \n",
"46423 ed foley inputevents_cv \n",
"43931 Floor urine out outputevents \n",
"43348 urine output/kg outputevents \n",
"40405 Urine Out Other outputevents \n",
"42810 angio urine out outputevents \n",
"46180 urine out-angio outputevents \n",
"40055 Urine Out Foley outputevents \n",
"44253 Urine out angio outputevents \n",
"44325 ED URINE OUTPUT outputevents \n",
"41857 urine out in er outputevents \n",
"44824 EW urine output outputevents \n",
"45991 ew-urine output outputevents \n",
"42042 ANGIO URINE OUT outputevents \n",
"46177 URINE OUT-ANGIO outputevents \n",
"44684 floor urine out outputevents \n",
"46658 ED Urine output outputevents \n",
"46578 URINE OUTPUT-ER outputevents \n",
"42765 FARR 6 URINE OUT outputevents \n",
"70081 URINE microbiologyevents \n",
"3819 Urine Leukocytes chartevents \n",
"70079 URINE microbiologyevents \n",
"43462 urine outputevents \n",
"\n",
" category unitname score \n",
"itemid \n",
"226560 Output mL 110.000000 \n",
"43332 110.000000 \n",
"7672 110.000000 \n",
"3686 110.000000 \n",
"45967 110.000000 \n",
"43053 110.000000 \n",
"226559 Output mL 110.000000 \n",
"44103 100.666667 \n",
"44834 100.666667 \n",
"227519 Scores - APACHE IV (2) None 100.666667 \n",
"44706 100.666667 \n",
"42892 100.666667 \n",
"45415 100.666667 \n",
"43987 100.666667 \n",
"42666 96.666667 \n",
"44237 96.666667 \n",
"42592 95.333333 \n",
"40069 95.333333 \n",
"46423 94.666667 \n",
"43931 93.333333 \n",
"43348 93.333333 \n",
"40405 93.333333 \n",
"42810 93.333333 \n",
"46180 93.333333 \n",
"40055 93.333333 \n",
"44253 93.333333 \n",
"44325 93.333333 \n",
"41857 93.333333 \n",
"44824 93.333333 \n",
"45991 93.333333 \n",
"42042 93.333333 \n",
"46177 93.333333 \n",
"44684 93.333333 \n",
"46658 93.333333 \n",
"46578 93.333333 \n",
"42765 91.333333 \n",
"70081 SPECIMEN 90.666667 \n",
"3819 Urine 90.666667 \n",
"70079 SPECIMEN 90.666667 \n",
"43462 90.666667 "
]
},
"execution_count": 379,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"out_df.head(40)"
]
},
{
"cell_type": "code",
"execution_count": 380,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"out_df = out_df[out_df.linksto.isin(['outputevents','chartevents'])]"
]
},
{
"cell_type": "code",
"execution_count": 381,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>label</th>\n",
" <th>abbreviation</th>\n",
" <th>linksto</th>\n",
" <th>category</th>\n",
" <th>unitname</th>\n",
" <th>score</th>\n",
" </tr>\n",
" <tr>\n",
" <th>itemid</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>226560</th>\n",
" <td>Void</td>\n",
" <td>Void</td>\n",
" <td>outputevents</td>\n",
" <td>Output</td>\n",
" <td>mL</td>\n",
" <td>110.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7672</th>\n",
" <td>Foley</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>110.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3686</th>\n",
" <td>Void</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>110.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43053</th>\n",
" <td>URINE OUT</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>110.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>226559</th>\n",
" <td>Foley</td>\n",
" <td>Foley</td>\n",
" <td>outputevents</td>\n",
" <td>Output</td>\n",
" <td>mL</td>\n",
" <td>110.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44103</th>\n",
" <td>ER urine out</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>100.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44834</th>\n",
" <td>er urine out</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>100.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>227519</th>\n",
" <td>Urine output_ApacheIV</td>\n",
" <td>Urine output</td>\n",
" <td>chartevents</td>\n",
" <td>Scores - APACHE IV (2)</td>\n",
" <td>None</td>\n",
" <td>100.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44706</th>\n",
" <td>urine output</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>100.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42892</th>\n",
" <td>EW URINE OUT</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>100.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45415</th>\n",
" <td>ED Urine OUT</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>100.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43987</th>\n",
" <td>urine out or</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>100.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42666</th>\n",
" <td>E.R. URINE OUT</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>96.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44237</th>\n",
" <td>E.R. urine out</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>96.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42592</th>\n",
" <td>VICU URINE OUT</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>95.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>40069</th>\n",
" <td>Urine Out Void</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>95.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43931</th>\n",
" <td>Floor urine out</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>93.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43348</th>\n",
" <td>urine output/kg</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>93.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>40405</th>\n",
" <td>Urine Out Other</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>93.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42810</th>\n",
" <td>angio urine out</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>93.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>46180</th>\n",
" <td>urine out-angio</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>93.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>40055</th>\n",
" <td>Urine Out Foley</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>93.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44253</th>\n",
" <td>Urine out angio</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>93.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44325</th>\n",
" <td>ED URINE OUTPUT</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>93.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>41857</th>\n",
" <td>urine out in er</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>93.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44824</th>\n",
" <td>EW urine output</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>93.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45991</th>\n",
" <td>ew-urine output</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>93.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42042</th>\n",
" <td>ANGIO URINE OUT</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>93.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>46177</th>\n",
" <td>URINE OUT-ANGIO</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>93.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44684</th>\n",
" <td>floor urine out</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>93.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>46658</th>\n",
" <td>ED Urine output</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>93.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>46578</th>\n",
" <td>URINE OUTPUT-ER</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>93.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42765</th>\n",
" <td>FARR 6 URINE OUT</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>91.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3819</th>\n",
" <td>Urine Leukocytes</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td>Urine</td>\n",
" <td></td>\n",
" <td>90.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43462</th>\n",
" <td>urine</td>\n",
" <td></td>\n",
" <td>outputevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>90.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3816</th>\n",
" <td>Urine Glucose</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td>Urine</td>\n",
" <td></td>\n",
" <td>90.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3817</th>\n",
" <td>Urine Heme</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td>Urine</td>\n",
" <td></td>\n",
" <td>90.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3818</th>\n",
" <td>Urine Ketones</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td>Urine</td>\n",
" <td></td>\n",
" <td>90.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3822</th>\n",
" <td>Urine Protein</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td>Urine</td>\n",
" <td></td>\n",
" <td>90.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6298</th>\n",
" <td>foley d/c</td>\n",
" <td></td>\n",
" <td>chartevents</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>90.666667</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" label abbreviation linksto \\\n",
"itemid \n",
"226560 Void Void outputevents \n",
"7672 Foley chartevents \n",
"3686 Void chartevents \n",
"43053 URINE OUT outputevents \n",
"226559 Foley Foley outputevents \n",
"44103 ER urine out outputevents \n",
"44834 er urine out outputevents \n",
"227519 Urine output_ApacheIV Urine output chartevents \n",
"44706 urine output outputevents \n",
"42892 EW URINE OUT outputevents \n",
"45415 ED Urine OUT outputevents \n",
"43987 urine out or outputevents \n",
"42666 E.R. URINE OUT outputevents \n",
"44237 E.R. urine out outputevents \n",
"42592 VICU URINE OUT outputevents \n",
"40069 Urine Out Void outputevents \n",
"43931 Floor urine out outputevents \n",
"43348 urine output/kg outputevents \n",
"40405 Urine Out Other outputevents \n",
"42810 angio urine out outputevents \n",
"46180 urine out-angio outputevents \n",
"40055 Urine Out Foley outputevents \n",
"44253 Urine out angio outputevents \n",
"44325 ED URINE OUTPUT outputevents \n",
"41857 urine out in er outputevents \n",
"44824 EW urine output outputevents \n",
"45991 ew-urine output outputevents \n",
"42042 ANGIO URINE OUT outputevents \n",
"46177 URINE OUT-ANGIO outputevents \n",
"44684 floor urine out outputevents \n",
"46658 ED Urine output outputevents \n",
"46578 URINE OUTPUT-ER outputevents \n",
"42765 FARR 6 URINE OUT outputevents \n",
"3819 Urine Leukocytes chartevents \n",
"43462 urine outputevents \n",
"3816 Urine Glucose chartevents \n",
"3817 Urine Heme chartevents \n",
"3818 Urine Ketones chartevents \n",
"3822 Urine Protein chartevents \n",
"6298 foley d/c chartevents \n",
"\n",
" category unitname score \n",
"itemid \n",
"226560 Output mL 110.000000 \n",
"7672 110.000000 \n",
"3686 110.000000 \n",
"43053 110.000000 \n",
"226559 Output mL 110.000000 \n",
"44103 100.666667 \n",
"44834 100.666667 \n",
"227519 Scores - APACHE IV (2) None 100.666667 \n",
"44706 100.666667 \n",
"42892 100.666667 \n",
"45415 100.666667 \n",
"43987 100.666667 \n",
"42666 96.666667 \n",
"44237 96.666667 \n",
"42592 95.333333 \n",
"40069 95.333333 \n",
"43931 93.333333 \n",
"43348 93.333333 \n",
"40405 93.333333 \n",
"42810 93.333333 \n",
"46180 93.333333 \n",
"40055 93.333333 \n",
"44253 93.333333 \n",
"44325 93.333333 \n",
"41857 93.333333 \n",
"44824 93.333333 \n",
"45991 93.333333 \n",
"42042 93.333333 \n",
"46177 93.333333 \n",
"44684 93.333333 \n",
"46658 93.333333 \n",
"46578 93.333333 \n",
"42765 91.333333 \n",
"3819 Urine 90.666667 \n",
"43462 90.666667 \n",
"3816 Urine 90.666667 \n",
"3817 Urine 90.666667 \n",
"3818 Urine 90.666667 \n",
"3822 Urine 90.666667 \n",
"6298 90.666667 "
]
},
"execution_count": 381,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"out_df.head(40)"
]
},
{
"cell_type": "code",
"execution_count": 390,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"import pint"
]
},
{
"cell_type": "code",
"execution_count": 391,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"ureg = pint.UnitRegistry()"
]
},
{
"cell_type": "code",
"execution_count": 397,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"degF"
],
"text/latex": [
"$\\mathrm{degF}$"
],
"text/plain": [
"<Unit('degF')>"
]
},
"execution_count": 397,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"ureg.parse_units('degF')"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": []
}
],
"metadata": {
"anaconda-cloud": {},
"kernelspec": {
"display_name": "Python [Root]",
"language": "python",
"name": "Python [Root]"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 2
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython2",
"version": "2.7.12"
}
},
"nbformat": 4,
"nbformat_minor": 0
}