vital_signs.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "a570f68c-d378-4716-b1ff-1b50f4acd8a3",
   "metadata": {},
   "outputs": [],
   "source": [
    "filepath = './data/csv/observations.csv'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "f717307c-ddd5-4e7e-9e7f-440b2b009835",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "833a7f9c-d3a1-4743-ae12-602576e92ce2",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv(filepath)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "33ea73db-da7a-4621-9910-c646c0271a6f",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 20742 entries, 0 to 20741\n",
      "Data columns (total 9 columns):\n",
      " #   Column       Non-Null Count  Dtype \n",
      "---  ------       --------------  ----- \n",
      " 0   DATE         20742 non-null  object\n",
      " 1   PATIENT      20742 non-null  object\n",
      " 2   ENCOUNTER    19194 non-null  object\n",
      " 3   CATEGORY     19194 non-null  object\n",
      " 4   CODE         20742 non-null  object\n",
      " 5   DESCRIPTION  20742 non-null  object\n",
      " 6   VALUE        20742 non-null  object\n",
      " 7   UNITS        14744 non-null  object\n",
      " 8   TYPE         20742 non-null  object\n",
      "dtypes: object(9)\n",
      "memory usage: 1.4+ MB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "9b2aae31-6744-448e-bf8a-385dc52fac8c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['vital-signs', 'social-history', 'survey', 'laboratory', nan,\n",
       "       'exam', 'procedure'], dtype=object)"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[\"CATEGORY\"].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "7c14585b-e91a-4467-87c3-dbb82ae24857",
   "metadata": {},
   "outputs": [],
   "source": [
    "def isnumber(num):\n",
    "    try:\n",
    "        float(num)\n",
    "        return True\n",
    "    except ValueError:\n",
    "        return False"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "d096f972-5cbe-434b-a640-6d77fcb76b2c",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = df[df[\"VALUE\"].apply(lambda x: isnumber(x))]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "e27de5af-ffc1-473c-a4b4-514b38a4feb3",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "ecafbe81-3d34-40dc-b670-4ee6a507fda5",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 18 entries, 0 to 13685\n",
      "Data columns (total 2 columns):\n",
      " #   Column       Non-Null Count  Dtype \n",
      "---  ------       --------------  ----- \n",
      " 0   DESCRIPTION  18 non-null     object\n",
      " 1   UNITS        18 non-null     object\n",
      "dtypes: object(2)\n",
      "memory usage: 432.0+ bytes\n"
     ]
    }
   ],
   "source": [
    "df[df[\"CATEGORY\"] == 'vital-signs'][['DESCRIPTION', 'UNITS']].drop_duplicates().info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "dfb869f3-ec6e-4484-8ddb-93b913fd7dfd",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>DATE</th>\n",
       "      <th>PATIENT</th>\n",
       "      <th>ENCOUNTER</th>\n",
       "      <th>CATEGORY</th>\n",
       "      <th>CODE</th>\n",
       "      <th>DESCRIPTION</th>\n",
       "      <th>VALUE</th>\n",
       "      <th>UNITS</th>\n",
       "      <th>TYPE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>19203</th>\n",
       "      <td>2021-05-18T06:00:31Z</td>\n",
       "      <td>ba193b51-efb6-4323-51df-db3877751e4b</td>\n",
       "      <td>61df5560-7382-462b-7b98-23c1ef382ed7</td>\n",
       "      <td>laboratory</td>\n",
       "      <td>20454-5</td>\n",
       "      <td>Protein [Presence] in Urine by Test strip</td>\n",
       "      <td>1.0</td>\n",
       "      <td>{presence}</td>\n",
       "      <td>numeric</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                       DATE                               PATIENT  \\\n",
       "19203  2021-05-18T06:00:31Z  ba193b51-efb6-4323-51df-db3877751e4b   \n",
       "\n",
       "                                  ENCOUNTER    CATEGORY     CODE  \\\n",
       "19203  61df5560-7382-462b-7b98-23c1ef382ed7  laboratory  20454-5   \n",
       "\n",
       "                                     DESCRIPTION VALUE       UNITS     TYPE  \n",
       "19203  Protein [Presence] in Urine by Test strip   1.0  {presence}  numeric  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df[\"DESCRIPTION\"] == 'Protein [Presence] in Urine by Test strip']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "bf60d2a8-252f-4bcc-82d5-8a5265d67b9b",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'DESCRIPTION': 'Glucose', 'UNITS': 'mg/dL'},\n",
       " {'DESCRIPTION': 'Urea Nitrogen', 'UNITS': 'mg/dL'},\n",
       " {'DESCRIPTION': 'Creatinine', 'UNITS': 'mg/dL'},\n",
       " {'DESCRIPTION': 'Calcium', 'UNITS': 'mg/dL'},\n",
       " {'DESCRIPTION': 'Sodium', 'UNITS': 'mmol/L'},\n",
       " {'DESCRIPTION': 'Potassium', 'UNITS': 'mmol/L'},\n",
       " {'DESCRIPTION': 'Chloride', 'UNITS': 'mmol/L'},\n",
       " {'DESCRIPTION': 'Carbon Dioxide', 'UNITS': 'mmol/L'},\n",
       " {'DESCRIPTION': 'Total Cholesterol', 'UNITS': 'mg/dL'},\n",
       " {'DESCRIPTION': 'Triglycerides', 'UNITS': 'mg/dL'},\n",
       " {'DESCRIPTION': 'Low Density Lipoprotein Cholesterol', 'UNITS': 'mg/dL'},\n",
       " {'DESCRIPTION': 'High Density Lipoprotein Cholesterol', 'UNITS': 'mg/dL'},\n",
       " {'DESCRIPTION': 'Hemoglobin A1c/Hemoglobin.total in Blood', 'UNITS': '%'},\n",
       " {'DESCRIPTION': 'Leukocytes [#/volume] in Blood by Automated count',\n",
       "  'UNITS': '10*3/uL'},\n",
       " {'DESCRIPTION': 'Erythrocytes [#/volume] in Blood by Automated count',\n",
       "  'UNITS': '10*6/uL'},\n",
       " {'DESCRIPTION': 'Hemoglobin [Mass/volume] in Blood', 'UNITS': 'g/dL'},\n",
       " {'DESCRIPTION': 'Hematocrit [Volume Fraction] of Blood by Automated count',\n",
       "  'UNITS': '%'},\n",
       " {'DESCRIPTION': 'MCV [Entitic volume] by Automated count', 'UNITS': 'fL'},\n",
       " {'DESCRIPTION': 'MCH [Entitic mass] by Automated count', 'UNITS': 'pg'},\n",
       " {'DESCRIPTION': 'MCHC [Mass/volume] by Automated count', 'UNITS': 'g/dL'},\n",
       " {'DESCRIPTION': 'Erythrocyte distribution width [Entitic volume] by Automated count',\n",
       "  'UNITS': 'fL'},\n",
       " {'DESCRIPTION': 'Platelets [#/volume] in Blood by Automated count',\n",
       "  'UNITS': '10*3/uL'},\n",
       " {'DESCRIPTION': 'Platelet distribution width [Entitic volume] in Blood by Automated count',\n",
       "  'UNITS': 'fL'},\n",
       " {'DESCRIPTION': 'Platelet mean volume [Entitic volume] in Blood by Automated count',\n",
       "  'UNITS': 'fL'},\n",
       " {'DESCRIPTION': 'Glomerular filtration rate/1.73 sq M.predicted',\n",
       "  'UNITS': 'mL/min'},\n",
       " {'DESCRIPTION': 'Glucose [Mass/volume] in Urine by Test strip',\n",
       "  'UNITS': 'mg/dL'},\n",
       " {'DESCRIPTION': 'Bilirubin.total [Mass/volume] in Urine by Test strip',\n",
       "  'UNITS': 'mg/dL'},\n",
       " {'DESCRIPTION': 'Ketones [Mass/volume] in Urine by Test strip',\n",
       "  'UNITS': 'mg/dL'},\n",
       " {'DESCRIPTION': 'Specific gravity of Urine by Test strip',\n",
       "  'UNITS': '{nominal}'},\n",
       " {'DESCRIPTION': 'pH of Urine by Test strip', 'UNITS': 'pH'},\n",
       " {'DESCRIPTION': 'Protein [Mass/volume] in Urine by Test strip',\n",
       "  'UNITS': 'mg/dL'},\n",
       " {'DESCRIPTION': 'Erythrocyte distribution width [Ratio] by Automated count',\n",
       "  'UNITS': '%'},\n",
       " {'DESCRIPTION': 'Neutrophils/100 leukocytes in Blood by Automated count',\n",
       "  'UNITS': '%'},\n",
       " {'DESCRIPTION': 'Lymphocytes/100 leukocytes in Blood by Automated count',\n",
       "  'UNITS': '%'},\n",
       " {'DESCRIPTION': 'Monocytes/100 leukocytes in Blood by Automated count',\n",
       "  'UNITS': '%'},\n",
       " {'DESCRIPTION': 'Eosinophils/100 leukocytes in Blood by Automated count',\n",
       "  'UNITS': '%'},\n",
       " {'DESCRIPTION': 'Basophils/100 leukocytes in Blood by Automated count',\n",
       "  'UNITS': '%'},\n",
       " {'DESCRIPTION': 'Neutrophils [#/volume] in Blood by Automated count',\n",
       "  'UNITS': '10*3/uL'},\n",
       " {'DESCRIPTION': 'Lymphocytes [#/volume] in Blood by Automated count',\n",
       "  'UNITS': '10*3/uL'},\n",
       " {'DESCRIPTION': 'Monocytes [#/volume] in Blood by Automated count',\n",
       "  'UNITS': '10*3/uL'},\n",
       " {'DESCRIPTION': 'Eosinophils [#/volume] in Blood by Automated count',\n",
       "  'UNITS': '10*3/uL'},\n",
       " {'DESCRIPTION': 'Basophils [#/volume] in Blood by Automated count',\n",
       "  'UNITS': '10*3/uL'},\n",
       " {'DESCRIPTION': 'Glucose [Mass/volume] in Serum or Plasma', 'UNITS': 'mg/dL'},\n",
       " {'DESCRIPTION': 'Urea nitrogen [Mass/volume] in Serum or Plasma',\n",
       "  'UNITS': 'mg/dL'},\n",
       " {'DESCRIPTION': 'Creatinine [Mass/volume] in Serum or Plasma',\n",
       "  'UNITS': 'mg/dL'},\n",
       " {'DESCRIPTION': 'Calcium [Mass/volume] in Serum or Plasma', 'UNITS': 'mg/dL'},\n",
       " {'DESCRIPTION': 'Sodium [Moles/volume] in Serum or Plasma',\n",
       "  'UNITS': 'mmol/L'},\n",
       " {'DESCRIPTION': 'Potassium [Moles/volume] in Serum or Plasma',\n",
       "  'UNITS': 'mmol/L'},\n",
       " {'DESCRIPTION': 'Chloride [Moles/volume] in Serum or Plasma',\n",
       "  'UNITS': 'mmol/L'},\n",
       " {'DESCRIPTION': 'Carbon dioxide  total [Moles/volume] in Serum or Plasma',\n",
       "  'UNITS': 'mmol/L'},\n",
       " {'DESCRIPTION': 'Protein [Mass/volume] in Serum or Plasma', 'UNITS': 'g/dL'},\n",
       " {'DESCRIPTION': 'Albumin [Mass/volume] in Serum or Plasma', 'UNITS': 'g/dL'},\n",
       " {'DESCRIPTION': 'Bilirubin.total [Mass/volume] in Serum or Plasma',\n",
       "  'UNITS': 'mg/dL'},\n",
       " {'DESCRIPTION': 'Alkaline phosphatase [Enzymatic activity/volume] in Serum or Plasma',\n",
       "  'UNITS': 'U/L'},\n",
       " {'DESCRIPTION': 'Alanine aminotransferase [Enzymatic activity/volume] in Serum or Plasma',\n",
       "  'UNITS': 'U/L'},\n",
       " {'DESCRIPTION': 'Aspartate aminotransferase [Enzymatic activity/volume] in Serum or Plasma',\n",
       "  'UNITS': 'U/L'},\n",
       " {'DESCRIPTION': 'Fibrin D-dimer FEU [Mass/volume] in Platelet poor plasma',\n",
       "  'UNITS': 'ug/mL'},\n",
       " {'DESCRIPTION': 'Ferritin [Mass/volume] in Serum or Plasma', 'UNITS': 'ug/L'},\n",
       " {'DESCRIPTION': 'Troponin I.cardiac [Mass/volume] in Serum or Plasma by High sensitivity method',\n",
       "  'UNITS': 'pg/mL'},\n",
       " {'DESCRIPTION': 'Lactate dehydrogenase [Enzymatic activity/volume] in Serum or Plasma by Lactate to pyruvate reaction',\n",
       "  'UNITS': 'U/L'},\n",
       " {'DESCRIPTION': 'Creatine kinase [Enzymatic activity/volume] in Serum or Plasma',\n",
       "  'UNITS': 'U/L'},\n",
       " {'DESCRIPTION': 'C reactive protein [Mass/volume] in Serum or Plasma',\n",
       "  'UNITS': 'mg/L'},\n",
       " {'DESCRIPTION': 'Prothrombin time (PT)', 'UNITS': 's'},\n",
       " {'DESCRIPTION': 'INR in Platelet poor plasma by Coagulation assay',\n",
       "  'UNITS': '{INR}'},\n",
       " {'DESCRIPTION': 'Procalcitonin [Mass/volume] in Serum or Plasma',\n",
       "  'UNITS': 'ng/mL'},\n",
       " {'DESCRIPTION': 'NT-proBNP', 'UNITS': 'pg/mL'},\n",
       " {'DESCRIPTION': 'Magnesium [Mass/volume] in Serum or Plasma',\n",
       "  'UNITS': 'mg/dL'},\n",
       " {'DESCRIPTION': 'Iron [Mass/volume] in Serum or Plasma', 'UNITS': 'ug/dL'},\n",
       " {'DESCRIPTION': 'Iron binding capacity [Mass/volume] in Serum or Plasma',\n",
       "  'UNITS': 'ug/dL'},\n",
       " {'DESCRIPTION': 'Iron saturation [Mass Fraction] in Serum or Plasma',\n",
       "  'UNITS': '%'},\n",
       " {'DESCRIPTION': 'Left ventricular Ejection fraction', 'UNITS': '%'},\n",
       " {'DESCRIPTION': 'Hematocrit [Volume Fraction] of Blood', 'UNITS': '%'},\n",
       " {'DESCRIPTION': 'WBC Auto (Bld) [#/Vol]', 'UNITS': '10*3/uL'},\n",
       " {'DESCRIPTION': 'RBC Auto (Bld) [#/Vol]', 'UNITS': '10*6/uL'},\n",
       " {'DESCRIPTION': 'RDW - Erythrocyte distribution width Auto (RBC) [Entitic vol]',\n",
       "  'UNITS': 'fL'},\n",
       " {'DESCRIPTION': 'Globulin [Mass/volume] in Serum by calculation',\n",
       "  'UNITS': 'g/L'},\n",
       " {'DESCRIPTION': 'Hemoglobin.gastrointestinal [Presence] in Stool by Immunologic method',\n",
       "  'UNITS': 'ng/mL'},\n",
       " {'DESCRIPTION': 'Microalbumin Creatinine Ratio', 'UNITS': 'mg/g'},\n",
       " {'DESCRIPTION': 'Estimated Glomerular Filtration Rate',\n",
       "  'UNITS': 'mL/min/{1.73_m2}'},\n",
       " {'DESCRIPTION': 'Peanut IgE Ab in Serum', 'UNITS': 'kU/L'},\n",
       " {'DESCRIPTION': 'Walnut IgE Ab in Serum', 'UNITS': 'kU/L'},\n",
       " {'DESCRIPTION': 'Codfish IgE Ab in Serum', 'UNITS': 'kU/L'},\n",
       " {'DESCRIPTION': 'Shrimp IgE Ab in Serum', 'UNITS': 'kU/L'},\n",
       " {'DESCRIPTION': 'Wheat IgE Ab in Serum', 'UNITS': 'kU/L'},\n",
       " {'DESCRIPTION': 'Egg white IgE Ab in Serum', 'UNITS': 'kU/L'},\n",
       " {'DESCRIPTION': 'Soybean IgE Ab in Serum', 'UNITS': 'kU/L'},\n",
       " {'DESCRIPTION': 'Cow milk IgE Ab in Serum', 'UNITS': 'kU/L'},\n",
       " {'DESCRIPTION': 'White oak IgE Ab in Serum', 'UNITS': 'kU/L'},\n",
       " {'DESCRIPTION': 'Common Ragweed IgE Ab in Serum', 'UNITS': 'kU/L'},\n",
       " {'DESCRIPTION': 'Cat dander IgE Ab in Serum', 'UNITS': 'kU/L'},\n",
       " {'DESCRIPTION': 'American house dust mite IgE Ab in Serum', 'UNITS': 'kU/L'},\n",
       " {'DESCRIPTION': 'Cladosporium herbarum IgE Ab in Serum', 'UNITS': 'kU/L'},\n",
       " {'DESCRIPTION': 'Honey bee IgE Ab in Serum', 'UNITS': 'kU/L'},\n",
       " {'DESCRIPTION': 'Latex IgE Ab in Serum', 'UNITS': 'kU/L'},\n",
       " {'DESCRIPTION': 'Lactate [Moles/volume] in Blood', 'UNITS': 'mmol/L'},\n",
       " {'DESCRIPTION': 'Diastolic Blood Pressure', 'UNITS': 'mm[Hg]'},\n",
       " {'DESCRIPTION': 'Magnesium [Mass/volume] in Blood', 'UNITS': 'mg/dL'},\n",
       " {'DESCRIPTION': 'aPTT in Blood by Coagulation assay', 'UNITS': 's'},\n",
       " {'DESCRIPTION': 'Troponin I.cardiac [Mass/volume] in Serum or Plasma by High sensitivity method',\n",
       "  'UNITS': 'ng/L'},\n",
       " {'DESCRIPTION': 'Phosphate [Mass/volume] in Serum or Plasma',\n",
       "  'UNITS': 'mg/dL'},\n",
       " {'DESCRIPTION': 'pH of Arterial blood', 'UNITS': '[pH]'},\n",
       " {'DESCRIPTION': 'Carbon dioxide [Partial pressure] in Arterial blood',\n",
       "  'UNITS': 'mm[Hg]'},\n",
       " {'DESCRIPTION': 'Oxygen [Partial pressure] in Arterial blood',\n",
       "  'UNITS': 'mm[Hg]'},\n",
       " {'DESCRIPTION': 'Bicarbonate [Moles/volume] in Arterial blood',\n",
       "  'UNITS': 'mmol/L'},\n",
       " {'DESCRIPTION': 'Activated clotting time (ACT) of Blood by Coagulation assay',\n",
       "  'UNITS': 's'},\n",
       " {'DESCRIPTION': 'pH of Venous blood', 'UNITS': '[pH]'},\n",
       " {'DESCRIPTION': 'Carbon dioxide [Partial pressure] in Venous blood',\n",
       "  'UNITS': 'mm[Hg]'},\n",
       " {'DESCRIPTION': 'Oxygen [Partial pressure] in Venous blood',\n",
       "  'UNITS': 'mm[Hg]'},\n",
       " {'DESCRIPTION': 'Bicarbonate [Moles/volume] in Venous blood',\n",
       "  'UNITS': 'mmol/L'},\n",
       " {'DESCRIPTION': 'Carbon dioxide  total [Moles/volume] in Venous blood',\n",
       "  'UNITS': 'mmol/L'},\n",
       " {'DESCRIPTION': 'Thyrotropin [Units/volume] in Serum or Plasma',\n",
       "  'UNITS': 'm[IU]/L'},\n",
       " {'DESCRIPTION': 'Glucose [Presence] in Urine by Test strip',\n",
       "  'UNITS': '{presence}'},\n",
       " {'DESCRIPTION': 'Bilirubin.total [Presence] in Urine by Test strip',\n",
       "  'UNITS': '{presence}'},\n",
       " {'DESCRIPTION': 'Ketones [Presence] in Urine by Test strip',\n",
       "  'UNITS': '{presence}'},\n",
       " {'DESCRIPTION': 'Specific gravity of Urine by Test strip', 'UNITS': '{SG}'},\n",
       " {'DESCRIPTION': 'pH of Urine by Test strip', 'UNITS': '[pH]'},\n",
       " {'DESCRIPTION': 'Protein [Presence] in Urine by Test strip',\n",
       "  'UNITS': '{presence}'},\n",
       " {'DESCRIPTION': 'Nitrite [Presence] in Urine by Test strip',\n",
       "  'UNITS': '{presence}'},\n",
       " {'DESCRIPTION': 'Hemoglobin [Presence] in Urine by Test strip',\n",
       "  'UNITS': '{presence}'},\n",
       " {'DESCRIPTION': 'Leukocyte esterase [Presence] in Urine by Test strip',\n",
       "  'UNITS': '{presence}'}]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df[\"CATEGORY\"] == 'laboratory'][['DESCRIPTION', 'UNITS']].dropna().drop_duplicates().to_dict('records')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "d1688233-f642-4001-988a-7a55d6b198e4",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>DATE</th>\n",
       "      <th>PATIENT</th>\n",
       "      <th>ENCOUNTER</th>\n",
       "      <th>CATEGORY</th>\n",
       "      <th>CODE</th>\n",
       "      <th>DESCRIPTION</th>\n",
       "      <th>VALUE</th>\n",
       "      <th>UNITS</th>\n",
       "      <th>TYPE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-12-23T09:39:51Z</td>\n",
       "      <td>068eef5f-34ae-7fc9-6c6c-a5af808089dc</td>\n",
       "      <td>6bcbdd0b-7a02-384d-80ac-c520fb3ab179</td>\n",
       "      <td>vital-signs</td>\n",
       "      <td>8302-2</td>\n",
       "      <td>Body Height</td>\n",
       "      <td>170.1</td>\n",
       "      <td>cm</td>\n",
       "      <td>numeric</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-12-23T09:39:51Z</td>\n",
       "      <td>068eef5f-34ae-7fc9-6c6c-a5af808089dc</td>\n",
       "      <td>6bcbdd0b-7a02-384d-80ac-c520fb3ab179</td>\n",
       "      <td>vital-signs</td>\n",
       "      <td>72514-3</td>\n",
       "      <td>Pain severity - 0-10 verbal numeric rating [Sc...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>{score}</td>\n",
       "      <td>numeric</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2021-05-25T23:58:21Z</td>\n",
       "      <td>0e11fbdf-a5f4-75fd-241c-039c9d4eedb2</td>\n",
       "      <td>240bad83-5e31-bb5e-f6d9-9b0d0542d9fa</td>\n",
       "      <td>vital-signs</td>\n",
       "      <td>8302-2</td>\n",
       "      <td>Body Height</td>\n",
       "      <td>153.2</td>\n",
       "      <td>cm</td>\n",
       "      <td>numeric</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2021-05-25T23:58:21Z</td>\n",
       "      <td>0e11fbdf-a5f4-75fd-241c-039c9d4eedb2</td>\n",
       "      <td>240bad83-5e31-bb5e-f6d9-9b0d0542d9fa</td>\n",
       "      <td>vital-signs</td>\n",
       "      <td>72514-3</td>\n",
       "      <td>Pain severity - 0-10 verbal numeric rating [Sc...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>{score}</td>\n",
       "      <td>numeric</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2021-05-25T23:58:21Z</td>\n",
       "      <td>0e11fbdf-a5f4-75fd-241c-039c9d4eedb2</td>\n",
       "      <td>240bad83-5e31-bb5e-f6d9-9b0d0542d9fa</td>\n",
       "      <td>vital-signs</td>\n",
       "      <td>29463-7</td>\n",
       "      <td>Body Weight</td>\n",
       "      <td>42.5</td>\n",
       "      <td>kg</td>\n",
       "      <td>numeric</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   DATE                               PATIENT  \\\n",
       "0  2020-12-23T09:39:51Z  068eef5f-34ae-7fc9-6c6c-a5af808089dc   \n",
       "1  2020-12-23T09:39:51Z  068eef5f-34ae-7fc9-6c6c-a5af808089dc   \n",
       "2  2021-05-25T23:58:21Z  0e11fbdf-a5f4-75fd-241c-039c9d4eedb2   \n",
       "3  2021-05-25T23:58:21Z  0e11fbdf-a5f4-75fd-241c-039c9d4eedb2   \n",
       "4  2021-05-25T23:58:21Z  0e11fbdf-a5f4-75fd-241c-039c9d4eedb2   \n",
       "\n",
       "                              ENCOUNTER     CATEGORY     CODE  \\\n",
       "0  6bcbdd0b-7a02-384d-80ac-c520fb3ab179  vital-signs   8302-2   \n",
       "1  6bcbdd0b-7a02-384d-80ac-c520fb3ab179  vital-signs  72514-3   \n",
       "2  240bad83-5e31-bb5e-f6d9-9b0d0542d9fa  vital-signs   8302-2   \n",
       "3  240bad83-5e31-bb5e-f6d9-9b0d0542d9fa  vital-signs  72514-3   \n",
       "4  240bad83-5e31-bb5e-f6d9-9b0d0542d9fa  vital-signs  29463-7   \n",
       "\n",
       "                                         DESCRIPTION  VALUE    UNITS     TYPE  \n",
       "0                                        Body Height  170.1       cm  numeric  \n",
       "1  Pain severity - 0-10 verbal numeric rating [Sc...    3.0  {score}  numeric  \n",
       "2                                        Body Height  153.2       cm  numeric  \n",
       "3  Pain severity - 0-10 verbal numeric rating [Sc...    3.0  {score}  numeric  \n",
       "4                                        Body Weight   42.5       kg  numeric  "
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "2fdae325-04d7-4edc-b114-db9663452cb0",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 3527 entries, 0 to 20711\n",
      "Data columns (total 9 columns):\n",
      " #   Column       Non-Null Count  Dtype \n",
      "---  ------       --------------  ----- \n",
      " 0   DATE         3527 non-null   object\n",
      " 1   PATIENT      3527 non-null   object\n",
      " 2   ENCOUNTER    3527 non-null   object\n",
      " 3   CATEGORY     3527 non-null   object\n",
      " 4   CODE         3527 non-null   object\n",
      " 5   DESCRIPTION  3527 non-null   object\n",
      " 6   VALUE        3527 non-null   object\n",
      " 7   UNITS        3527 non-null   object\n",
      " 8   TYPE         3527 non-null   object\n",
      "dtypes: object(9)\n",
      "memory usage: 275.5+ KB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "357470c4-15e6-4d60-8584-1435ffea4924",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Body Height',\n",
       "       'Pain severity - 0-10 verbal numeric rating [Score] - Reported',\n",
       "       'Body Weight', 'Body Mass Index',\n",
       "       'Body mass index (BMI) [Percentile] Per age and gender',\n",
       "       'Diastolic Blood Pressure', 'Systolic Blood Pressure',\n",
       "       'Heart rate', 'Respiratory rate', 'Body temperature',\n",
       "       'Oxygen saturation in Arterial blood',\n",
       "       'Weight-for-length Per age and sex',\n",
       "       'Head Occipital-frontal circumference Percentile',\n",
       "       'Head Occipital-frontal circumference', 'Body Temperature',\n",
       "       'Oxygen Saturation', 'Mean blood pressure',\n",
       "       'Natriuretic peptide.B prohormone N-Terminal [Mass/volume] in Blood by Immunoassay'],\n",
       "      dtype=object)"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[\"DESCRIPTION\"].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d4b6b3ef-7e94-4fee-90ab-b9fb4c701545",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}