dwh/query_lib_biq_query_examples.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "ee790913",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Examples of Using Big Query as backend to Query data.\n",
    "# Examples assume \n",
    "# a. google auth login - commands have been run to set up auth and default project\n",
    "# b. the default project has `synthea_big` dataset with Patient, Encounter and Observation tables with sample data\n",
    "# that is used in this notebook"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "64081a30",
   "metadata": {},
   "outputs": [],
   "source": [
    "import warnings\n",
    "from query_lib_big_query import BigQueryPatientQuery\n",
    "\n",
    "_BIGQUERY_DATASET = \"synthea_big\"\n",
    "_CODE_SYSTEM = \"http://www.ampathkenya.org\"\n",
    "_PROJECT_NAME = \"fhir-analytics-test\"\n",
    "warnings.filterwarnings(\"ignore\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "29d76127",
   "metadata": {},
   "source": [
    "# Example 1: Fetch Encounter data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "efc2ec9f",
   "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>encPatientId</th>\n",
       "      <th>locationId</th>\n",
       "      <th>encTypeSystem</th>\n",
       "      <th>encTypeCode</th>\n",
       "      <th>locationDisplay</th>\n",
       "      <th>num_encounters</th>\n",
       "      <th>firstDate</th>\n",
       "      <th>lastDate</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>fc387977-6f2e-4ee0-8bfa-767e7fadfd49</td>\n",
       "      <td>2131aff8-2e2a-480a-b7ab-4ac53250262b</td>\n",
       "      <td>http://fhir.openmrs.org/code-system/encounter-...</td>\n",
       "      <td>5021b1a1-e7f6-44b4-ba02-da2f2bcf8718</td>\n",
       "      <td>Isolation Ward</td>\n",
       "      <td>16</td>\n",
       "      <td>1944-01-31T05:29:31+00:00</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>14f70276-b8bb-40db-adaa-603a68a1f7a6</td>\n",
       "      <td>2131aff8-2e2a-480a-b7ab-4ac53250262b</td>\n",
       "      <td>http://fhir.openmrs.org/code-system/encounter-...</td>\n",
       "      <td>5021b1a1-e7f6-44b4-ba02-da2f2bcf8718</td>\n",
       "      <td>Isolation Ward</td>\n",
       "      <td>16</td>\n",
       "      <td>1941-04-23T08:29:15+00:00</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>50b579ef-aeb6-4fe4-a4b1-0397aea91c49</td>\n",
       "      <td>2131aff8-2e2a-480a-b7ab-4ac53250262b</td>\n",
       "      <td>http://fhir.openmrs.org/code-system/encounter-...</td>\n",
       "      <td>5021b1a1-e7f6-44b4-ba02-da2f2bcf8718</td>\n",
       "      <td>Isolation Ward</td>\n",
       "      <td>18</td>\n",
       "      <td>1914-05-02T02:54:26+00:00</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>b6103345-e809-401a-bcbb-914313d89fdc</td>\n",
       "      <td>2131aff8-2e2a-480a-b7ab-4ac53250262b</td>\n",
       "      <td>http://fhir.openmrs.org/code-system/encounter-...</td>\n",
       "      <td>5021b1a1-e7f6-44b4-ba02-da2f2bcf8718</td>\n",
       "      <td>Isolation Ward</td>\n",
       "      <td>16</td>\n",
       "      <td>1912-06-20T00:23:18+00:00</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>09890e2f-1c2e-44d7-8d2f-a2089700ed44</td>\n",
       "      <td>2131aff8-2e2a-480a-b7ab-4ac53250262b</td>\n",
       "      <td>http://fhir.openmrs.org/code-system/encounter-...</td>\n",
       "      <td>5021b1a1-e7f6-44b4-ba02-da2f2bcf8718</td>\n",
       "      <td>Isolation Ward</td>\n",
       "      <td>24</td>\n",
       "      <td>1949-01-13T22:13:16+00:00</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                           encPatientId                            locationId  \\\n",
       "0  fc387977-6f2e-4ee0-8bfa-767e7fadfd49  2131aff8-2e2a-480a-b7ab-4ac53250262b   \n",
       "1  14f70276-b8bb-40db-adaa-603a68a1f7a6  2131aff8-2e2a-480a-b7ab-4ac53250262b   \n",
       "2  50b579ef-aeb6-4fe4-a4b1-0397aea91c49  2131aff8-2e2a-480a-b7ab-4ac53250262b   \n",
       "3  b6103345-e809-401a-bcbb-914313d89fdc  2131aff8-2e2a-480a-b7ab-4ac53250262b   \n",
       "4  09890e2f-1c2e-44d7-8d2f-a2089700ed44  2131aff8-2e2a-480a-b7ab-4ac53250262b   \n",
       "\n",
       "                                       encTypeSystem  \\\n",
       "0  http://fhir.openmrs.org/code-system/encounter-...   \n",
       "1  http://fhir.openmrs.org/code-system/encounter-...   \n",
       "2  http://fhir.openmrs.org/code-system/encounter-...   \n",
       "3  http://fhir.openmrs.org/code-system/encounter-...   \n",
       "4  http://fhir.openmrs.org/code-system/encounter-...   \n",
       "\n",
       "                            encTypeCode locationDisplay  num_encounters  \\\n",
       "0  5021b1a1-e7f6-44b4-ba02-da2f2bcf8718  Isolation Ward              16   \n",
       "1  5021b1a1-e7f6-44b4-ba02-da2f2bcf8718  Isolation Ward              16   \n",
       "2  5021b1a1-e7f6-44b4-ba02-da2f2bcf8718  Isolation Ward              18   \n",
       "3  5021b1a1-e7f6-44b4-ba02-da2f2bcf8718  Isolation Ward              16   \n",
       "4  5021b1a1-e7f6-44b4-ba02-da2f2bcf8718  Isolation Ward              24   \n",
       "\n",
       "                   firstDate lastDate  \n",
       "0  1944-01-31T05:29:31+00:00     None  \n",
       "1  1941-04-23T08:29:15+00:00     None  \n",
       "2  1914-05-02T02:54:26+00:00     None  \n",
       "3  1912-06-20T00:23:18+00:00     None  \n",
       "4  1949-01-13T22:13:16+00:00     None  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pq = BigQueryPatientQuery(\n",
    "        bq_dataset=_BIGQUERY_DATASET, code_system=\"http://www.ampathkenya.org\", project_name=_PROJECT_NAME\n",
    "    )\n",
    "pq.encounter_constraints(\n",
    "        typeSystem=\"http://fhir.openmrs.org/code-system/encounter-type\"\n",
    "    )\n",
    "\n",
    "encounter_df = pq.get_patient_encounter_view(\n",
    "        force_location_type_columns=False\n",
    "    )\n",
    "encounter_df.head(5)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "4b76d6c6",
   "metadata": {},
   "source": [
    "# Example 2: Encounter Data based on codes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "76eb1465",
   "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>encPatientId</th>\n",
       "      <th>locationId</th>\n",
       "      <th>encTypeSystem</th>\n",
       "      <th>encTypeCode</th>\n",
       "      <th>locationDisplay</th>\n",
       "      <th>num_encounters</th>\n",
       "      <th>firstDate</th>\n",
       "      <th>lastDate</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>8295eb5b-fba6-4e83-a5cb-2817b135cd27</td>\n",
       "      <td>b1a8b05e-3542-4037-bbd3-998ee9c40574</td>\n",
       "      <td>http://fhir.openmrs.org/code-system/encounter-...</td>\n",
       "      <td>e22e39fd-7db2-45e7-80f1-60fa0d5a4378</td>\n",
       "      <td>Inpatient Ward</td>\n",
       "      <td>2</td>\n",
       "      <td>2019-02-28T10:43:00+00:00</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>8295eb5b-fba6-4e83-a5cb-2817b135cd27</td>\n",
       "      <td>b1a8b05e-3542-4037-bbd3-998ee9c40574</td>\n",
       "      <td>http://fhir.openmrs.org/code-system/encounter-...</td>\n",
       "      <td>181820aa-88c9-479b-9077-af92f5364329</td>\n",
       "      <td>Inpatient Ward</td>\n",
       "      <td>2</td>\n",
       "      <td>2019-03-03T10:43:00+00:00</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                           encPatientId                            locationId  \\\n",
       "0  8295eb5b-fba6-4e83-a5cb-2817b135cd27  b1a8b05e-3542-4037-bbd3-998ee9c40574   \n",
       "1  8295eb5b-fba6-4e83-a5cb-2817b135cd27  b1a8b05e-3542-4037-bbd3-998ee9c40574   \n",
       "\n",
       "                                       encTypeSystem  \\\n",
       "0  http://fhir.openmrs.org/code-system/encounter-...   \n",
       "1  http://fhir.openmrs.org/code-system/encounter-...   \n",
       "\n",
       "                            encTypeCode locationDisplay  num_encounters  \\\n",
       "0  e22e39fd-7db2-45e7-80f1-60fa0d5a4378  Inpatient Ward               2   \n",
       "1  181820aa-88c9-479b-9077-af92f5364329  Inpatient Ward               2   \n",
       "\n",
       "                   firstDate lastDate  \n",
       "0  2019-02-28T10:43:00+00:00     None  \n",
       "1  2019-03-03T10:43:00+00:00     None  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pq = BigQueryPatientQuery(\n",
    "        bq_dataset=_BIGQUERY_DATASET, code_system=\"dummy_code_system\", project_name=_PROJECT_NAME\n",
    "    )\n",
    "test_codes = [\n",
    "        \"e22e39fd-7db2-45e7-80f1-60fa0d5a4378\",\n",
    "        \"181820aa-88c9-479b-9077-af92f5364329\",\n",
    "    ]\n",
    "\n",
    "pq.encounter_constraints(typeCode=test_codes)\n",
    "\n",
    "encounter_df = pq.get_patient_encounter_view(\n",
    "        force_location_type_columns=False\n",
    "    )\n",
    "encounter_df.head(5)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8c1a65ff",
   "metadata": {},
   "source": [
    "# Example 3: Fetch Encounter data based on location id"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "c04429f3",
   "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>encPatientId</th>\n",
       "      <th>locationId</th>\n",
       "      <th>encTypeSystem</th>\n",
       "      <th>encTypeCode</th>\n",
       "      <th>locationDisplay</th>\n",
       "      <th>num_encounters</th>\n",
       "      <th>firstDate</th>\n",
       "      <th>lastDate</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>fc387977-6f2e-4ee0-8bfa-767e7fadfd49</td>\n",
       "      <td>2131aff8-2e2a-480a-b7ab-4ac53250262b</td>\n",
       "      <td>http://fhir.openmrs.org/code-system/encounter-...</td>\n",
       "      <td>5021b1a1-e7f6-44b4-ba02-da2f2bcf8718</td>\n",
       "      <td>Isolation Ward</td>\n",
       "      <td>16</td>\n",
       "      <td>1944-01-31T05:29:31+00:00</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>14f70276-b8bb-40db-adaa-603a68a1f7a6</td>\n",
       "      <td>2131aff8-2e2a-480a-b7ab-4ac53250262b</td>\n",
       "      <td>http://fhir.openmrs.org/code-system/encounter-...</td>\n",
       "      <td>5021b1a1-e7f6-44b4-ba02-da2f2bcf8718</td>\n",
       "      <td>Isolation Ward</td>\n",
       "      <td>16</td>\n",
       "      <td>1941-04-23T08:29:15+00:00</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>50b579ef-aeb6-4fe4-a4b1-0397aea91c49</td>\n",
       "      <td>2131aff8-2e2a-480a-b7ab-4ac53250262b</td>\n",
       "      <td>http://fhir.openmrs.org/code-system/encounter-...</td>\n",
       "      <td>5021b1a1-e7f6-44b4-ba02-da2f2bcf8718</td>\n",
       "      <td>Isolation Ward</td>\n",
       "      <td>18</td>\n",
       "      <td>1914-05-02T02:54:26+00:00</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>b6103345-e809-401a-bcbb-914313d89fdc</td>\n",
       "      <td>2131aff8-2e2a-480a-b7ab-4ac53250262b</td>\n",
       "      <td>http://fhir.openmrs.org/code-system/encounter-...</td>\n",
       "      <td>5021b1a1-e7f6-44b4-ba02-da2f2bcf8718</td>\n",
       "      <td>Isolation Ward</td>\n",
       "      <td>16</td>\n",
       "      <td>1912-06-20T00:23:18+00:00</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>09890e2f-1c2e-44d7-8d2f-a2089700ed44</td>\n",
       "      <td>2131aff8-2e2a-480a-b7ab-4ac53250262b</td>\n",
       "      <td>http://fhir.openmrs.org/code-system/encounter-...</td>\n",
       "      <td>5021b1a1-e7f6-44b4-ba02-da2f2bcf8718</td>\n",
       "      <td>Isolation Ward</td>\n",
       "      <td>24</td>\n",
       "      <td>1949-01-13T22:13:16+00:00</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                           encPatientId                            locationId  \\\n",
       "0  fc387977-6f2e-4ee0-8bfa-767e7fadfd49  2131aff8-2e2a-480a-b7ab-4ac53250262b   \n",
       "1  14f70276-b8bb-40db-adaa-603a68a1f7a6  2131aff8-2e2a-480a-b7ab-4ac53250262b   \n",
       "2  50b579ef-aeb6-4fe4-a4b1-0397aea91c49  2131aff8-2e2a-480a-b7ab-4ac53250262b   \n",
       "3  b6103345-e809-401a-bcbb-914313d89fdc  2131aff8-2e2a-480a-b7ab-4ac53250262b   \n",
       "4  09890e2f-1c2e-44d7-8d2f-a2089700ed44  2131aff8-2e2a-480a-b7ab-4ac53250262b   \n",
       "\n",
       "                                       encTypeSystem  \\\n",
       "0  http://fhir.openmrs.org/code-system/encounter-...   \n",
       "1  http://fhir.openmrs.org/code-system/encounter-...   \n",
       "2  http://fhir.openmrs.org/code-system/encounter-...   \n",
       "3  http://fhir.openmrs.org/code-system/encounter-...   \n",
       "4  http://fhir.openmrs.org/code-system/encounter-...   \n",
       "\n",
       "                            encTypeCode locationDisplay  num_encounters  \\\n",
       "0  5021b1a1-e7f6-44b4-ba02-da2f2bcf8718  Isolation Ward              16   \n",
       "1  5021b1a1-e7f6-44b4-ba02-da2f2bcf8718  Isolation Ward              16   \n",
       "2  5021b1a1-e7f6-44b4-ba02-da2f2bcf8718  Isolation Ward              18   \n",
       "3  5021b1a1-e7f6-44b4-ba02-da2f2bcf8718  Isolation Ward              16   \n",
       "4  5021b1a1-e7f6-44b4-ba02-da2f2bcf8718  Isolation Ward              24   \n",
       "\n",
       "                   firstDate lastDate  \n",
       "0  1944-01-31T05:29:31+00:00     None  \n",
       "1  1941-04-23T08:29:15+00:00     None  \n",
       "2  1914-05-02T02:54:26+00:00     None  \n",
       "3  1912-06-20T00:23:18+00:00     None  \n",
       "4  1949-01-13T22:13:16+00:00     None  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pq = BigQueryPatientQuery(\n",
    "        bq_dataset=_BIGQUERY_DATASET, code_system=\"dummy_code_system\", project_name=_PROJECT_NAME\n",
    "    )\n",
    "\n",
    "test_locations = [\"2131aff8-2e2a-480a-b7ab-4ac53250262b\"]\n",
    "\n",
    "pq.encounter_constraints(locationId=test_locations)\n",
    "\n",
    "encounter_df = pq.get_patient_encounter_view(\n",
    "        force_location_type_columns=False\n",
    "    )\n",
    "encounter_df.head(5)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "dc50e1e7",
   "metadata": {},
   "source": [
    "# Example 4: Encounter data with multiple condition"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "7409ad53",
   "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>encPatientId</th>\n",
       "      <th>locationId</th>\n",
       "      <th>encTypeSystem</th>\n",
       "      <th>encTypeCode</th>\n",
       "      <th>locationDisplay</th>\n",
       "      <th>num_encounters</th>\n",
       "      <th>firstDate</th>\n",
       "      <th>lastDate</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>8295eb5b-fba6-4e83-a5cb-2817b135cd27</td>\n",
       "      <td>b1a8b05e-3542-4037-bbd3-998ee9c40574</td>\n",
       "      <td>http://fhir.openmrs.org/code-system/encounter-...</td>\n",
       "      <td>e22e39fd-7db2-45e7-80f1-60fa0d5a4378</td>\n",
       "      <td>Inpatient Ward</td>\n",
       "      <td>2</td>\n",
       "      <td>2019-02-28T10:43:00+00:00</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>8295eb5b-fba6-4e83-a5cb-2817b135cd27</td>\n",
       "      <td>b1a8b05e-3542-4037-bbd3-998ee9c40574</td>\n",
       "      <td>http://fhir.openmrs.org/code-system/encounter-...</td>\n",
       "      <td>181820aa-88c9-479b-9077-af92f5364329</td>\n",
       "      <td>Inpatient Ward</td>\n",
       "      <td>2</td>\n",
       "      <td>2019-03-03T10:43:00+00:00</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                           encPatientId                            locationId  \\\n",
       "0  8295eb5b-fba6-4e83-a5cb-2817b135cd27  b1a8b05e-3542-4037-bbd3-998ee9c40574   \n",
       "1  8295eb5b-fba6-4e83-a5cb-2817b135cd27  b1a8b05e-3542-4037-bbd3-998ee9c40574   \n",
       "\n",
       "                                       encTypeSystem  \\\n",
       "0  http://fhir.openmrs.org/code-system/encounter-...   \n",
       "1  http://fhir.openmrs.org/code-system/encounter-...   \n",
       "\n",
       "                            encTypeCode locationDisplay  num_encounters  \\\n",
       "0  e22e39fd-7db2-45e7-80f1-60fa0d5a4378  Inpatient Ward               2   \n",
       "1  181820aa-88c9-479b-9077-af92f5364329  Inpatient Ward               2   \n",
       "\n",
       "                   firstDate lastDate  \n",
       "0  2019-02-28T10:43:00+00:00     None  \n",
       "1  2019-03-03T10:43:00+00:00     None  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test_locations = [\"b1a8b05e-3542-4037-bbd3-998ee9c40574\"]\n",
    "test_codes = [\n",
    "    \"e22e39fd-7db2-45e7-80f1-60fa0d5a4378\",\n",
    "    \"181820aa-88c9-479b-9077-af92f5364329\",\n",
    "]\n",
    "test_type_system = \"http://fhir.openmrs.org/code-system/encounter-type\"\n",
    "\n",
    "pq = BigQueryPatientQuery(\n",
    "    bq_dataset=_BIGQUERY_DATASET, code_system=\"http://www.ampathkenya.org\", project_name=_PROJECT_NAME\n",
    ")\n",
    "pq.encounter_constraints(\n",
    "    typeSystem=test_type_system,\n",
    "    locationId=test_locations,\n",
    "    typeCode=test_codes\n",
    ")\n",
    "encounter_df = pq.get_patient_encounter_view(\n",
    "    force_location_type_columns=False,\n",
    "    sample_count=10,\n",
    ")\n",
    "encounter_df.head(5)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "351cf8bd",
   "metadata": {},
   "source": [
    "# Example 5: Observation Data with multiple conditions"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "579816e3",
   "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>patientId</th>\n",
       "      <th>code</th>\n",
       "      <th>birthDate</th>\n",
       "      <th>gender</th>\n",
       "      <th>num_obs</th>\n",
       "      <th>min_value</th>\n",
       "      <th>max_value</th>\n",
       "      <th>min_date</th>\n",
       "      <th>max_date</th>\n",
       "      <th>last_value</th>\n",
       "      <th>first_value</th>\n",
       "      <th>last_value_code</th>\n",
       "      <th>first_value_code</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ee2cfd13-384d-4dfe-b44e-ee415a3c95f4</td>\n",
       "      <td>844</td>\n",
       "      <td>1993-04-06</td>\n",
       "      <td>female</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019-09-10T11:38:57+00:00</td>\n",
       "      <td>2019-09-10T11:38:57+00:00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1138AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA</td>\n",
       "      <td>1138</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ee2cfd13-384d-4dfe-b44e-ee415a3c95f4</td>\n",
       "      <td>1030</td>\n",
       "      <td>1993-04-06</td>\n",
       "      <td>female</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019-09-10T11:38:57+00:00</td>\n",
       "      <td>2019-09-10T11:38:57+00:00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1138AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA</td>\n",
       "      <td>1138</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>bdf7cdff-23de-4e1f-9b38-c0de6eaf2af5</td>\n",
       "      <td>844</td>\n",
       "      <td>1972-04-25</td>\n",
       "      <td>male</td>\n",
       "      <td>14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2008-05-26T10:25:50+00:00</td>\n",
       "      <td>2016-07-08T10:25:50+00:00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>704</td>\n",
       "      <td>1304</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>bdf7cdff-23de-4e1f-9b38-c0de6eaf2af5</td>\n",
       "      <td>1030</td>\n",
       "      <td>1972-04-25</td>\n",
       "      <td>male</td>\n",
       "      <td>14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2008-05-26T10:25:50+00:00</td>\n",
       "      <td>2016-07-08T10:25:50+00:00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>704</td>\n",
       "      <td>1304</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>158a5cdb-671d-463a-b71a-5cd332055127</td>\n",
       "      <td>844</td>\n",
       "      <td>1993-12-31</td>\n",
       "      <td>male</td>\n",
       "      <td>7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-02-01T22:56:24+00:00</td>\n",
       "      <td>2018-10-15T22:56:24+00:00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1138AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA</td>\n",
       "      <td>664</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                              patientId  code   birthDate  gender  num_obs  \\\n",
       "0  ee2cfd13-384d-4dfe-b44e-ee415a3c95f4   844  1993-04-06  female        2   \n",
       "1  ee2cfd13-384d-4dfe-b44e-ee415a3c95f4  1030  1993-04-06  female        2   \n",
       "2  bdf7cdff-23de-4e1f-9b38-c0de6eaf2af5   844  1972-04-25    male       14   \n",
       "3  bdf7cdff-23de-4e1f-9b38-c0de6eaf2af5  1030  1972-04-25    male       14   \n",
       "4  158a5cdb-671d-463a-b71a-5cd332055127   844  1993-12-31    male        7   \n",
       "\n",
       "   min_value  max_value                   min_date                   max_date  \\\n",
       "0        NaN        NaN  2019-09-10T11:38:57+00:00  2019-09-10T11:38:57+00:00   \n",
       "1        NaN        NaN  2019-09-10T11:38:57+00:00  2019-09-10T11:38:57+00:00   \n",
       "2        NaN        NaN  2008-05-26T10:25:50+00:00  2016-07-08T10:25:50+00:00   \n",
       "3        NaN        NaN  2008-05-26T10:25:50+00:00  2016-07-08T10:25:50+00:00   \n",
       "4        NaN        NaN  2016-02-01T22:56:24+00:00  2018-10-15T22:56:24+00:00   \n",
       "\n",
       "  last_value first_value                       last_value_code  \\\n",
       "0       None        None  1138AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA   \n",
       "1       None        None  1138AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA   \n",
       "2       None        None                                   704   \n",
       "3       None        None                                   704   \n",
       "4       None        None  1138AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA   \n",
       "\n",
       "  first_value_code  \n",
       "0             1138  \n",
       "1             1138  \n",
       "2             1304  \n",
       "3             1304  \n",
       "4              664  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "_VL_CODE = \"856\"  # HIV VIRAL LOAD\n",
    "_ARV_PLAN = \"1255\"  # ANTIRETROVIRAL PLAN\n",
    "end_date = \"2017-01-01\"\n",
    "start_date = \"2000-01-01\"\n",
    "_BASE_URL = \"\"\n",
    "\n",
    "# Creating a new `patient_query` to drop all previous constraints\n",
    "# and recreate flat views.\n",
    "patient_query = BigQueryPatientQuery(\n",
    "    bq_dataset=_BIGQUERY_DATASET, code_system=_CODE_SYSTEM, project_name=_PROJECT_NAME\n",
    ")\n",
    "\n",
    "patient_query.include_obs_values_in_time_range(\n",
    "    _VL_CODE, min_time=start_date, max_time=end_date\n",
    ")\n",
    "patient_query.include_obs_values_in_time_range(\n",
    "    _ARV_PLAN, min_time=start_date, max_time=end_date\n",
    ")\n",
    "\n",
    "other_end_date = \"2020-01-01\"\n",
    "other_start_date = \"1998-01-01\"\n",
    "patient_query.include_all_other_codes(\n",
    "    min_time=other_start_date, max_time=other_end_date\n",
    ")\n",
    "\n",
    "patient_query.encounter_constraints(\n",
    "    #locationId=[\"7f65d926-57d6-4402-ae10-a5b3bcbf7986\"]\n",
    ")\n",
    "\n",
    "obs_df = patient_query.get_patient_obs_view()\n",
    "obs_df.head()\n",
    "#obs_df[obs_df['patientId'=='00c1426f-ca04-414a-8db7-043bb41b64d2']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "5fdcbece",
   "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>patientId</th>\n",
       "      <th>code</th>\n",
       "      <th>birthDate</th>\n",
       "      <th>gender</th>\n",
       "      <th>num_obs</th>\n",
       "      <th>min_value</th>\n",
       "      <th>max_value</th>\n",
       "      <th>min_date</th>\n",
       "      <th>max_date</th>\n",
       "      <th>last_value</th>\n",
       "      <th>first_value</th>\n",
       "      <th>last_value_code</th>\n",
       "      <th>first_value_code</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>32250</th>\n",
       "      <td>00c1426f-ca04-414a-8db7-043bb41b64d2</td>\n",
       "      <td>1271</td>\n",
       "      <td>1994-04-18</td>\n",
       "      <td>male</td>\n",
       "      <td>100</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2009-07-07T01:44:23+00:00</td>\n",
       "      <td>2012-07-02T01:44:23+00:00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>856AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA</td>\n",
       "      <td>1107</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39247</th>\n",
       "      <td>00c1426f-ca04-414a-8db7-043bb41b64d2</td>\n",
       "      <td>6174</td>\n",
       "      <td>1994-04-18</td>\n",
       "      <td>male</td>\n",
       "      <td>19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2009-07-07T01:44:23+00:00</td>\n",
       "      <td>2012-07-02T01:44:23+00:00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>967</td>\n",
       "      <td>140238AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45601</th>\n",
       "      <td>00c1426f-ca04-414a-8db7-043bb41b64d2</td>\n",
       "      <td>5085</td>\n",
       "      <td>1994-04-18</td>\n",
       "      <td>male</td>\n",
       "      <td>6</td>\n",
       "      <td>101.0</td>\n",
       "      <td>244.0</td>\n",
       "      <td>2009-07-07T01:44:23+00:00</td>\n",
       "      <td>2012-07-02T01:44:23+00:00</td>\n",
       "      <td>244</td>\n",
       "      <td>101</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48634</th>\n",
       "      <td>00c1426f-ca04-414a-8db7-043bb41b64d2</td>\n",
       "      <td>5087</td>\n",
       "      <td>1994-04-18</td>\n",
       "      <td>male</td>\n",
       "      <td>3</td>\n",
       "      <td>50.0</td>\n",
       "      <td>111.0</td>\n",
       "      <td>2009-07-07T01:44:23+00:00</td>\n",
       "      <td>2012-07-02T01:44:23+00:00</td>\n",
       "      <td>65</td>\n",
       "      <td>111</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50448</th>\n",
       "      <td>00c1426f-ca04-414a-8db7-043bb41b64d2</td>\n",
       "      <td>5088</td>\n",
       "      <td>1994-04-18</td>\n",
       "      <td>male</td>\n",
       "      <td>3</td>\n",
       "      <td>36.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>2009-07-07T01:44:23+00:00</td>\n",
       "      <td>2012-07-02T01:44:23+00:00</td>\n",
       "      <td>36</td>\n",
       "      <td>38</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56248</th>\n",
       "      <td>00c1426f-ca04-414a-8db7-043bb41b64d2</td>\n",
       "      <td>856</td>\n",
       "      <td>1994-04-18</td>\n",
       "      <td>male</td>\n",
       "      <td>3</td>\n",
       "      <td>182520.0</td>\n",
       "      <td>836370.0</td>\n",
       "      <td>2009-07-07T01:44:23+00:00</td>\n",
       "      <td>2012-07-02T01:44:23+00:00</td>\n",
       "      <td>836370</td>\n",
       "      <td>823690</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57508</th>\n",
       "      <td>00c1426f-ca04-414a-8db7-043bb41b64d2</td>\n",
       "      <td>844</td>\n",
       "      <td>1994-04-18</td>\n",
       "      <td>male</td>\n",
       "      <td>6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2009-07-07T01:44:23+00:00</td>\n",
       "      <td>2012-07-02T01:44:23+00:00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1138AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA</td>\n",
       "      <td>1138</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57509</th>\n",
       "      <td>00c1426f-ca04-414a-8db7-043bb41b64d2</td>\n",
       "      <td>1030</td>\n",
       "      <td>1994-04-18</td>\n",
       "      <td>male</td>\n",
       "      <td>6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2009-07-07T01:44:23+00:00</td>\n",
       "      <td>2012-07-02T01:44:23+00:00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1138AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA</td>\n",
       "      <td>1138</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74842</th>\n",
       "      <td>00c1426f-ca04-414a-8db7-043bb41b64d2</td>\n",
       "      <td>5092</td>\n",
       "      <td>1994-04-18</td>\n",
       "      <td>male</td>\n",
       "      <td>3</td>\n",
       "      <td>73.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>2009-07-07T01:44:23+00:00</td>\n",
       "      <td>2012-07-02T01:44:23+00:00</td>\n",
       "      <td>75</td>\n",
       "      <td>73</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77702</th>\n",
       "      <td>00c1426f-ca04-414a-8db7-043bb41b64d2</td>\n",
       "      <td>5089</td>\n",
       "      <td>1994-04-18</td>\n",
       "      <td>male</td>\n",
       "      <td>1</td>\n",
       "      <td>64.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>2009-07-07T01:44:23+00:00</td>\n",
       "      <td>2009-07-07T01:44:23+00:00</td>\n",
       "      <td>64</td>\n",
       "      <td>64</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80576</th>\n",
       "      <td>00c1426f-ca04-414a-8db7-043bb41b64d2</td>\n",
       "      <td>1040</td>\n",
       "      <td>1994-04-18</td>\n",
       "      <td>male</td>\n",
       "      <td>8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2009-07-07T01:44:23+00:00</td>\n",
       "      <td>2012-07-02T01:44:23+00:00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>704</td>\n",
       "      <td>1304</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102682</th>\n",
       "      <td>00c1426f-ca04-414a-8db7-043bb41b64d2</td>\n",
       "      <td>5090</td>\n",
       "      <td>1994-04-18</td>\n",
       "      <td>male</td>\n",
       "      <td>1</td>\n",
       "      <td>169.0</td>\n",
       "      <td>169.0</td>\n",
       "      <td>2009-07-07T01:44:23+00:00</td>\n",
       "      <td>2009-07-07T01:44:23+00:00</td>\n",
       "      <td>169</td>\n",
       "      <td>169</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                   patientId  code   birthDate gender  \\\n",
       "32250   00c1426f-ca04-414a-8db7-043bb41b64d2  1271  1994-04-18   male   \n",
       "39247   00c1426f-ca04-414a-8db7-043bb41b64d2  6174  1994-04-18   male   \n",
       "45601   00c1426f-ca04-414a-8db7-043bb41b64d2  5085  1994-04-18   male   \n",
       "48634   00c1426f-ca04-414a-8db7-043bb41b64d2  5087  1994-04-18   male   \n",
       "50448   00c1426f-ca04-414a-8db7-043bb41b64d2  5088  1994-04-18   male   \n",
       "56248   00c1426f-ca04-414a-8db7-043bb41b64d2   856  1994-04-18   male   \n",
       "57508   00c1426f-ca04-414a-8db7-043bb41b64d2   844  1994-04-18   male   \n",
       "57509   00c1426f-ca04-414a-8db7-043bb41b64d2  1030  1994-04-18   male   \n",
       "74842   00c1426f-ca04-414a-8db7-043bb41b64d2  5092  1994-04-18   male   \n",
       "77702   00c1426f-ca04-414a-8db7-043bb41b64d2  5089  1994-04-18   male   \n",
       "80576   00c1426f-ca04-414a-8db7-043bb41b64d2  1040  1994-04-18   male   \n",
       "102682  00c1426f-ca04-414a-8db7-043bb41b64d2  5090  1994-04-18   male   \n",
       "\n",
       "        num_obs  min_value  max_value                   min_date  \\\n",
       "32250       100        NaN        NaN  2009-07-07T01:44:23+00:00   \n",
       "39247        19        NaN        NaN  2009-07-07T01:44:23+00:00   \n",
       "45601         6      101.0      244.0  2009-07-07T01:44:23+00:00   \n",
       "48634         3       50.0      111.0  2009-07-07T01:44:23+00:00   \n",
       "50448         3       36.0       38.0  2009-07-07T01:44:23+00:00   \n",
       "56248         3   182520.0   836370.0  2009-07-07T01:44:23+00:00   \n",
       "57508         6        NaN        NaN  2009-07-07T01:44:23+00:00   \n",
       "57509         6        NaN        NaN  2009-07-07T01:44:23+00:00   \n",
       "74842         3       73.0       90.0  2009-07-07T01:44:23+00:00   \n",
       "77702         1       64.0       64.0  2009-07-07T01:44:23+00:00   \n",
       "80576         8        NaN        NaN  2009-07-07T01:44:23+00:00   \n",
       "102682        1      169.0      169.0  2009-07-07T01:44:23+00:00   \n",
       "\n",
       "                         max_date last_value first_value  \\\n",
       "32250   2012-07-02T01:44:23+00:00       None        None   \n",
       "39247   2012-07-02T01:44:23+00:00       None        None   \n",
       "45601   2012-07-02T01:44:23+00:00        244         101   \n",
       "48634   2012-07-02T01:44:23+00:00         65         111   \n",
       "50448   2012-07-02T01:44:23+00:00         36          38   \n",
       "56248   2012-07-02T01:44:23+00:00     836370      823690   \n",
       "57508   2012-07-02T01:44:23+00:00       None        None   \n",
       "57509   2012-07-02T01:44:23+00:00       None        None   \n",
       "74842   2012-07-02T01:44:23+00:00         75          73   \n",
       "77702   2009-07-07T01:44:23+00:00         64          64   \n",
       "80576   2012-07-02T01:44:23+00:00       None        None   \n",
       "102682  2009-07-07T01:44:23+00:00        169         169   \n",
       "\n",
       "                             last_value_code  \\\n",
       "32250   856AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA   \n",
       "39247                                    967   \n",
       "45601                                   None   \n",
       "48634                                   None   \n",
       "50448                                   None   \n",
       "56248                                   None   \n",
       "57508   1138AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA   \n",
       "57509   1138AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA   \n",
       "74842                                   None   \n",
       "77702                                   None   \n",
       "80576                                    704   \n",
       "102682                                  None   \n",
       "\n",
       "                            first_value_code  \n",
       "32250                                   1107  \n",
       "39247   140238AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA  \n",
       "45601                                   None  \n",
       "48634                                   None  \n",
       "50448                                   None  \n",
       "56248                                   None  \n",
       "57508                                   1138  \n",
       "57509                                   1138  \n",
       "74842                                   None  \n",
       "77702                                   None  \n",
       "80576                                   1304  \n",
       "102682                                  None  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "obs_df[obs_df['patientId']=='00c1426f-ca04-414a-8db7-043bb41b64d2']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "dd8377b9",
   "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>patientId</th>\n",
       "      <th>code</th>\n",
       "      <th>birthDate</th>\n",
       "      <th>gender</th>\n",
       "      <th>num_obs</th>\n",
       "      <th>min_value</th>\n",
       "      <th>max_value</th>\n",
       "      <th>min_date</th>\n",
       "      <th>max_date</th>\n",
       "      <th>last_value</th>\n",
       "      <th>first_value</th>\n",
       "      <th>last_value_code</th>\n",
       "      <th>first_value_code</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>6158</th>\n",
       "      <td>01188340-b29f-471a-9cc8-2b2247aa9f84</td>\n",
       "      <td>1040</td>\n",
       "      <td>1953-08-02</td>\n",
       "      <td>male</td>\n",
       "      <td>16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1998-02-22T11:44:13+00:00</td>\n",
       "      <td>2006-08-05T11:44:13+00:00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>704</td>\n",
       "      <td>703</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9171</th>\n",
       "      <td>01188340-b29f-471a-9cc8-2b2247aa9f84</td>\n",
       "      <td>1088</td>\n",
       "      <td>1953-08-02</td>\n",
       "      <td>male</td>\n",
       "      <td>133</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1998-02-22T11:44:13+00:00</td>\n",
       "      <td>2006-09-04T11:44:13+00:00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>84795AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA</td>\n",
       "      <td>104567AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11256</th>\n",
       "      <td>01188340-b29f-471a-9cc8-2b2247aa9f84</td>\n",
       "      <td>1111</td>\n",
       "      <td>1953-08-02</td>\n",
       "      <td>male</td>\n",
       "      <td>140</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1998-02-22T11:44:13+00:00</td>\n",
       "      <td>2006-09-04T11:44:13+00:00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>78280AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA</td>\n",
       "      <td>1107</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16947</th>\n",
       "      <td>01188340-b29f-471a-9cc8-2b2247aa9f84</td>\n",
       "      <td>1250</td>\n",
       "      <td>1953-08-02</td>\n",
       "      <td>male</td>\n",
       "      <td>135</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1998-02-22T11:44:13+00:00</td>\n",
       "      <td>2006-09-04T11:44:13+00:00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>84795AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA</td>\n",
       "      <td>628</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21093</th>\n",
       "      <td>01188340-b29f-471a-9cc8-2b2247aa9f84</td>\n",
       "      <td>1261</td>\n",
       "      <td>1953-08-02</td>\n",
       "      <td>male</td>\n",
       "      <td>16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1998-02-22T11:44:13+00:00</td>\n",
       "      <td>2006-09-04T11:44:13+00:00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1260AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA</td>\n",
       "      <td>1256</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24149</th>\n",
       "      <td>01188340-b29f-471a-9cc8-2b2247aa9f84</td>\n",
       "      <td>1265</td>\n",
       "      <td>1953-08-02</td>\n",
       "      <td>male</td>\n",
       "      <td>16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1998-02-22T11:44:13+00:00</td>\n",
       "      <td>2006-09-04T11:44:13+00:00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1107AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA</td>\n",
       "      <td>981</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27813</th>\n",
       "      <td>01188340-b29f-471a-9cc8-2b2247aa9f84</td>\n",
       "      <td>1268</td>\n",
       "      <td>1953-08-02</td>\n",
       "      <td>male</td>\n",
       "      <td>16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1998-02-22T11:44:13+00:00</td>\n",
       "      <td>2006-09-04T11:44:13+00:00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1260AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA</td>\n",
       "      <td>1260</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30748</th>\n",
       "      <td>01188340-b29f-471a-9cc8-2b2247aa9f84</td>\n",
       "      <td>1270</td>\n",
       "      <td>1953-08-02</td>\n",
       "      <td>male</td>\n",
       "      <td>159</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1998-02-22T11:44:13+00:00</td>\n",
       "      <td>2006-09-04T11:44:13+00:00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>82900AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA</td>\n",
       "      <td>1108</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33679</th>\n",
       "      <td>01188340-b29f-471a-9cc8-2b2247aa9f84</td>\n",
       "      <td>1271</td>\n",
       "      <td>1953-08-02</td>\n",
       "      <td>male</td>\n",
       "      <td>261</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1998-02-22T11:44:13+00:00</td>\n",
       "      <td>2006-08-05T11:44:13+00:00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>856AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA</td>\n",
       "      <td>1107</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37956</th>\n",
       "      <td>01188340-b29f-471a-9cc8-2b2247aa9f84</td>\n",
       "      <td>6174</td>\n",
       "      <td>1953-08-02</td>\n",
       "      <td>male</td>\n",
       "      <td>33</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1998-02-22T11:44:13+00:00</td>\n",
       "      <td>2006-08-05T11:44:13+00:00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>6171</td>\n",
       "      <td>133027AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41667</th>\n",
       "      <td>01188340-b29f-471a-9cc8-2b2247aa9f84</td>\n",
       "      <td>2154</td>\n",
       "      <td>1953-08-02</td>\n",
       "      <td>male</td>\n",
       "      <td>10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1998-02-22T11:44:13+00:00</td>\n",
       "      <td>2006-09-04T11:44:13+00:00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1652AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA</td>\n",
       "      <td>1652AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46025</th>\n",
       "      <td>01188340-b29f-471a-9cc8-2b2247aa9f84</td>\n",
       "      <td>5085</td>\n",
       "      <td>1953-08-02</td>\n",
       "      <td>male</td>\n",
       "      <td>12</td>\n",
       "      <td>56.0</td>\n",
       "      <td>227.0</td>\n",
       "      <td>1998-02-22T11:44:13+00:00</td>\n",
       "      <td>2006-08-05T11:44:13+00:00</td>\n",
       "      <td>62</td>\n",
       "      <td>181</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49784</th>\n",
       "      <td>01188340-b29f-471a-9cc8-2b2247aa9f84</td>\n",
       "      <td>5088</td>\n",
       "      <td>1953-08-02</td>\n",
       "      <td>male</td>\n",
       "      <td>6</td>\n",
       "      <td>35.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>1998-02-22T11:44:13+00:00</td>\n",
       "      <td>2006-08-05T11:44:13+00:00</td>\n",
       "      <td>35</td>\n",
       "      <td>37</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53217</th>\n",
       "      <td>01188340-b29f-471a-9cc8-2b2247aa9f84</td>\n",
       "      <td>5092</td>\n",
       "      <td>1953-08-02</td>\n",
       "      <td>male</td>\n",
       "      <td>6</td>\n",
       "      <td>72.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>1998-02-22T11:44:13+00:00</td>\n",
       "      <td>2006-08-05T11:44:13+00:00</td>\n",
       "      <td>77</td>\n",
       "      <td>88</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56762</th>\n",
       "      <td>01188340-b29f-471a-9cc8-2b2247aa9f84</td>\n",
       "      <td>856</td>\n",
       "      <td>1953-08-02</td>\n",
       "      <td>male</td>\n",
       "      <td>4</td>\n",
       "      <td>170820.0</td>\n",
       "      <td>812660.0</td>\n",
       "      <td>2001-04-04T11:44:13+00:00</td>\n",
       "      <td>2006-08-05T11:44:13+00:00</td>\n",
       "      <td>812660</td>\n",
       "      <td>170820</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70844</th>\n",
       "      <td>01188340-b29f-471a-9cc8-2b2247aa9f84</td>\n",
       "      <td>5087</td>\n",
       "      <td>1953-08-02</td>\n",
       "      <td>male</td>\n",
       "      <td>6</td>\n",
       "      <td>50.0</td>\n",
       "      <td>197.0</td>\n",
       "      <td>1998-02-22T11:44:13+00:00</td>\n",
       "      <td>2006-08-05T11:44:13+00:00</td>\n",
       "      <td>104</td>\n",
       "      <td>178</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81440</th>\n",
       "      <td>01188340-b29f-471a-9cc8-2b2247aa9f84</td>\n",
       "      <td>1255</td>\n",
       "      <td>1953-08-02</td>\n",
       "      <td>male</td>\n",
       "      <td>8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2001-04-04T11:44:13+00:00</td>\n",
       "      <td>2006-09-04T11:44:13+00:00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1256AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA</td>\n",
       "      <td>981</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89333</th>\n",
       "      <td>01188340-b29f-471a-9cc8-2b2247aa9f84</td>\n",
       "      <td>844</td>\n",
       "      <td>1953-08-02</td>\n",
       "      <td>male</td>\n",
       "      <td>15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1998-02-22T11:44:13+00:00</td>\n",
       "      <td>2006-08-05T11:44:13+00:00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1304AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA</td>\n",
       "      <td>703</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89334</th>\n",
       "      <td>01188340-b29f-471a-9cc8-2b2247aa9f84</td>\n",
       "      <td>1030</td>\n",
       "      <td>1953-08-02</td>\n",
       "      <td>male</td>\n",
       "      <td>15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1998-02-22T11:44:13+00:00</td>\n",
       "      <td>2006-08-05T11:44:13+00:00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1304AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA</td>\n",
       "      <td>703</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  patientId  code   birthDate gender  num_obs  \\\n",
       "6158   01188340-b29f-471a-9cc8-2b2247aa9f84  1040  1953-08-02   male       16   \n",
       "9171   01188340-b29f-471a-9cc8-2b2247aa9f84  1088  1953-08-02   male      133   \n",
       "11256  01188340-b29f-471a-9cc8-2b2247aa9f84  1111  1953-08-02   male      140   \n",
       "16947  01188340-b29f-471a-9cc8-2b2247aa9f84  1250  1953-08-02   male      135   \n",
       "21093  01188340-b29f-471a-9cc8-2b2247aa9f84  1261  1953-08-02   male       16   \n",
       "24149  01188340-b29f-471a-9cc8-2b2247aa9f84  1265  1953-08-02   male       16   \n",
       "27813  01188340-b29f-471a-9cc8-2b2247aa9f84  1268  1953-08-02   male       16   \n",
       "30748  01188340-b29f-471a-9cc8-2b2247aa9f84  1270  1953-08-02   male      159   \n",
       "33679  01188340-b29f-471a-9cc8-2b2247aa9f84  1271  1953-08-02   male      261   \n",
       "37956  01188340-b29f-471a-9cc8-2b2247aa9f84  6174  1953-08-02   male       33   \n",
       "41667  01188340-b29f-471a-9cc8-2b2247aa9f84  2154  1953-08-02   male       10   \n",
       "46025  01188340-b29f-471a-9cc8-2b2247aa9f84  5085  1953-08-02   male       12   \n",
       "49784  01188340-b29f-471a-9cc8-2b2247aa9f84  5088  1953-08-02   male        6   \n",
       "53217  01188340-b29f-471a-9cc8-2b2247aa9f84  5092  1953-08-02   male        6   \n",
       "56762  01188340-b29f-471a-9cc8-2b2247aa9f84   856  1953-08-02   male        4   \n",
       "70844  01188340-b29f-471a-9cc8-2b2247aa9f84  5087  1953-08-02   male        6   \n",
       "81440  01188340-b29f-471a-9cc8-2b2247aa9f84  1255  1953-08-02   male        8   \n",
       "89333  01188340-b29f-471a-9cc8-2b2247aa9f84   844  1953-08-02   male       15   \n",
       "89334  01188340-b29f-471a-9cc8-2b2247aa9f84  1030  1953-08-02   male       15   \n",
       "\n",
       "       min_value  max_value                   min_date  \\\n",
       "6158         NaN        NaN  1998-02-22T11:44:13+00:00   \n",
       "9171         NaN        NaN  1998-02-22T11:44:13+00:00   \n",
       "11256        NaN        NaN  1998-02-22T11:44:13+00:00   \n",
       "16947        NaN        NaN  1998-02-22T11:44:13+00:00   \n",
       "21093        NaN        NaN  1998-02-22T11:44:13+00:00   \n",
       "24149        NaN        NaN  1998-02-22T11:44:13+00:00   \n",
       "27813        NaN        NaN  1998-02-22T11:44:13+00:00   \n",
       "30748        NaN        NaN  1998-02-22T11:44:13+00:00   \n",
       "33679        NaN        NaN  1998-02-22T11:44:13+00:00   \n",
       "37956        NaN        NaN  1998-02-22T11:44:13+00:00   \n",
       "41667        NaN        NaN  1998-02-22T11:44:13+00:00   \n",
       "46025       56.0      227.0  1998-02-22T11:44:13+00:00   \n",
       "49784       35.0       39.0  1998-02-22T11:44:13+00:00   \n",
       "53217       72.0       95.0  1998-02-22T11:44:13+00:00   \n",
       "56762   170820.0   812660.0  2001-04-04T11:44:13+00:00   \n",
       "70844       50.0      197.0  1998-02-22T11:44:13+00:00   \n",
       "81440        NaN        NaN  2001-04-04T11:44:13+00:00   \n",
       "89333        NaN        NaN  1998-02-22T11:44:13+00:00   \n",
       "89334        NaN        NaN  1998-02-22T11:44:13+00:00   \n",
       "\n",
       "                        max_date last_value first_value  \\\n",
       "6158   2006-08-05T11:44:13+00:00       None        None   \n",
       "9171   2006-09-04T11:44:13+00:00       None        None   \n",
       "11256  2006-09-04T11:44:13+00:00       None        None   \n",
       "16947  2006-09-04T11:44:13+00:00       None        None   \n",
       "21093  2006-09-04T11:44:13+00:00       None        None   \n",
       "24149  2006-09-04T11:44:13+00:00       None        None   \n",
       "27813  2006-09-04T11:44:13+00:00       None        None   \n",
       "30748  2006-09-04T11:44:13+00:00       None        None   \n",
       "33679  2006-08-05T11:44:13+00:00       None        None   \n",
       "37956  2006-08-05T11:44:13+00:00       None        None   \n",
       "41667  2006-09-04T11:44:13+00:00       None        None   \n",
       "46025  2006-08-05T11:44:13+00:00         62         181   \n",
       "49784  2006-08-05T11:44:13+00:00         35          37   \n",
       "53217  2006-08-05T11:44:13+00:00         77          88   \n",
       "56762  2006-08-05T11:44:13+00:00     812660      170820   \n",
       "70844  2006-08-05T11:44:13+00:00        104         178   \n",
       "81440  2006-09-04T11:44:13+00:00       None        None   \n",
       "89333  2006-08-05T11:44:13+00:00       None        None   \n",
       "89334  2006-08-05T11:44:13+00:00       None        None   \n",
       "\n",
       "                            last_value_code  \\\n",
       "6158                                    704   \n",
       "9171   84795AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA   \n",
       "11256  78280AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA   \n",
       "16947  84795AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA   \n",
       "21093  1260AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA   \n",
       "24149  1107AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA   \n",
       "27813  1260AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA   \n",
       "30748  82900AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA   \n",
       "33679  856AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA   \n",
       "37956                                  6171   \n",
       "41667  1652AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA   \n",
       "46025                                  None   \n",
       "49784                                  None   \n",
       "53217                                  None   \n",
       "56762                                  None   \n",
       "70844                                  None   \n",
       "81440  1256AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA   \n",
       "89333  1304AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA   \n",
       "89334  1304AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA   \n",
       "\n",
       "                           first_value_code  \n",
       "6158                                    703  \n",
       "9171   104567AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA  \n",
       "11256                                  1107  \n",
       "16947                                   628  \n",
       "21093                                  1256  \n",
       "24149                                   981  \n",
       "27813                                  1260  \n",
       "30748                                  1108  \n",
       "33679                                  1107  \n",
       "37956  133027AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA  \n",
       "41667  1652AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA  \n",
       "46025                                  None  \n",
       "49784                                  None  \n",
       "53217                                  None  \n",
       "56762                                  None  \n",
       "70844                                  None  \n",
       "81440                                   981  \n",
       "89333                                   703  \n",
       "89334                                   703  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "patient_id = \"01188340-b29f-471a-9cc8-2b2247aa9f84\"\n",
    "obs_df[obs_df['patientId']==patient_id]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "f22028c8",
   "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>patientId</th>\n",
       "      <th>code</th>\n",
       "      <th>birthDate</th>\n",
       "      <th>gender</th>\n",
       "      <th>num_obs</th>\n",
       "      <th>min_value</th>\n",
       "      <th>max_value</th>\n",
       "      <th>min_date</th>\n",
       "      <th>max_date</th>\n",
       "      <th>last_value</th>\n",
       "      <th>first_value</th>\n",
       "      <th>last_value_code</th>\n",
       "      <th>first_value_code</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>930</th>\n",
       "      <td>04472fb9-14d2-4510-8459-db44c9271986</td>\n",
       "      <td>844</td>\n",
       "      <td>1974-07-08</td>\n",
       "      <td>male</td>\n",
       "      <td>6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2011-09-30T20:26:46+00:00</td>\n",
       "      <td>2014-03-05T20:26:46+00:00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1138AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA</td>\n",
       "      <td>1138</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>931</th>\n",
       "      <td>04472fb9-14d2-4510-8459-db44c9271986</td>\n",
       "      <td>1030</td>\n",
       "      <td>1974-07-08</td>\n",
       "      <td>male</td>\n",
       "      <td>6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2011-09-30T20:26:46+00:00</td>\n",
       "      <td>2014-03-05T20:26:46+00:00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1138AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA</td>\n",
       "      <td>1138</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4140</th>\n",
       "      <td>04472fb9-14d2-4510-8459-db44c9271986</td>\n",
       "      <td>1040</td>\n",
       "      <td>1974-07-08</td>\n",
       "      <td>male</td>\n",
       "      <td>8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2011-09-30T20:26:46+00:00</td>\n",
       "      <td>2014-03-05T20:26:46+00:00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>704</td>\n",
       "      <td>703</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8275</th>\n",
       "      <td>04472fb9-14d2-4510-8459-db44c9271986</td>\n",
       "      <td>1088</td>\n",
       "      <td>1974-07-08</td>\n",
       "      <td>male</td>\n",
       "      <td>52</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-10-20T20:26:46+00:00</td>\n",
       "      <td>2014-03-05T20:26:46+00:00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>84795AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA</td>\n",
       "      <td>104565AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13394</th>\n",
       "      <td>04472fb9-14d2-4510-8459-db44c9271986</td>\n",
       "      <td>1111</td>\n",
       "      <td>1974-07-08</td>\n",
       "      <td>male</td>\n",
       "      <td>33</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-10-20T20:26:46+00:00</td>\n",
       "      <td>2014-03-05T20:26:46+00:00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>75948AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA</td>\n",
       "      <td>1107</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18962</th>\n",
       "      <td>04472fb9-14d2-4510-8459-db44c9271986</td>\n",
       "      <td>1250</td>\n",
       "      <td>1974-07-08</td>\n",
       "      <td>male</td>\n",
       "      <td>34</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-10-20T20:26:46+00:00</td>\n",
       "      <td>2014-03-05T20:26:46+00:00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>86663AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA</td>\n",
       "      <td>623</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20019</th>\n",
       "      <td>04472fb9-14d2-4510-8459-db44c9271986</td>\n",
       "      <td>1255</td>\n",
       "      <td>1974-07-08</td>\n",
       "      <td>male</td>\n",
       "      <td>6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-10-20T20:26:46+00:00</td>\n",
       "      <td>2014-03-05T20:26:46+00:00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1256AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA</td>\n",
       "      <td>1256</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31199</th>\n",
       "      <td>04472fb9-14d2-4510-8459-db44c9271986</td>\n",
       "      <td>1270</td>\n",
       "      <td>1974-07-08</td>\n",
       "      <td>male</td>\n",
       "      <td>61</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-10-20T20:26:46+00:00</td>\n",
       "      <td>2014-03-05T20:26:46+00:00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>82900AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA</td>\n",
       "      <td>1108</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36192</th>\n",
       "      <td>04472fb9-14d2-4510-8459-db44c9271986</td>\n",
       "      <td>1271</td>\n",
       "      <td>1974-07-08</td>\n",
       "      <td>male</td>\n",
       "      <td>110</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2011-09-30T20:26:46+00:00</td>\n",
       "      <td>2014-03-05T20:26:46+00:00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>856AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA</td>\n",
       "      <td>1042</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37896</th>\n",
       "      <td>04472fb9-14d2-4510-8459-db44c9271986</td>\n",
       "      <td>6174</td>\n",
       "      <td>1974-07-08</td>\n",
       "      <td>male</td>\n",
       "      <td>26</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2011-09-30T20:26:46+00:00</td>\n",
       "      <td>2014-03-05T20:26:46+00:00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>967</td>\n",
       "      <td>138905AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42360</th>\n",
       "      <td>04472fb9-14d2-4510-8459-db44c9271986</td>\n",
       "      <td>2154</td>\n",
       "      <td>1974-07-08</td>\n",
       "      <td>male</td>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-10-20T20:26:46+00:00</td>\n",
       "      <td>2014-03-05T20:26:46+00:00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>817AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA</td>\n",
       "      <td>1652AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45410</th>\n",
       "      <td>04472fb9-14d2-4510-8459-db44c9271986</td>\n",
       "      <td>5085</td>\n",
       "      <td>1974-07-08</td>\n",
       "      <td>male</td>\n",
       "      <td>6</td>\n",
       "      <td>59.0</td>\n",
       "      <td>206.0</td>\n",
       "      <td>2011-09-30T20:26:46+00:00</td>\n",
       "      <td>2014-03-05T20:26:46+00:00</td>\n",
       "      <td>206</td>\n",
       "      <td>162</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55319</th>\n",
       "      <td>04472fb9-14d2-4510-8459-db44c9271986</td>\n",
       "      <td>856</td>\n",
       "      <td>1974-07-08</td>\n",
       "      <td>male</td>\n",
       "      <td>3</td>\n",
       "      <td>437660.0</td>\n",
       "      <td>961780.0</td>\n",
       "      <td>2011-09-30T20:26:46+00:00</td>\n",
       "      <td>2014-03-05T20:26:46+00:00</td>\n",
       "      <td>437660</td>\n",
       "      <td>961780</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64821</th>\n",
       "      <td>04472fb9-14d2-4510-8459-db44c9271986</td>\n",
       "      <td>1268</td>\n",
       "      <td>1974-07-08</td>\n",
       "      <td>male</td>\n",
       "      <td>6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-10-20T20:26:46+00:00</td>\n",
       "      <td>2014-03-05T20:26:46+00:00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1257AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA</td>\n",
       "      <td>1259</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70633</th>\n",
       "      <td>04472fb9-14d2-4510-8459-db44c9271986</td>\n",
       "      <td>5087</td>\n",
       "      <td>1974-07-08</td>\n",
       "      <td>male</td>\n",
       "      <td>3</td>\n",
       "      <td>64.0</td>\n",
       "      <td>130.0</td>\n",
       "      <td>2011-09-30T20:26:46+00:00</td>\n",
       "      <td>2014-03-05T20:26:46+00:00</td>\n",
       "      <td>64</td>\n",
       "      <td>101</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71786</th>\n",
       "      <td>04472fb9-14d2-4510-8459-db44c9271986</td>\n",
       "      <td>5088</td>\n",
       "      <td>1974-07-08</td>\n",
       "      <td>male</td>\n",
       "      <td>3</td>\n",
       "      <td>35.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>2011-09-30T20:26:46+00:00</td>\n",
       "      <td>2014-03-05T20:26:46+00:00</td>\n",
       "      <td>37</td>\n",
       "      <td>35</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74093</th>\n",
       "      <td>04472fb9-14d2-4510-8459-db44c9271986</td>\n",
       "      <td>5090</td>\n",
       "      <td>1974-07-08</td>\n",
       "      <td>male</td>\n",
       "      <td>1</td>\n",
       "      <td>171.0</td>\n",
       "      <td>171.0</td>\n",
       "      <td>2011-09-30T20:26:46+00:00</td>\n",
       "      <td>2011-09-30T20:26:46+00:00</td>\n",
       "      <td>171</td>\n",
       "      <td>171</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82343</th>\n",
       "      <td>04472fb9-14d2-4510-8459-db44c9271986</td>\n",
       "      <td>1265</td>\n",
       "      <td>1974-07-08</td>\n",
       "      <td>male</td>\n",
       "      <td>6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-10-20T20:26:46+00:00</td>\n",
       "      <td>2014-03-05T20:26:46+00:00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1107AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA</td>\n",
       "      <td>981</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87320</th>\n",
       "      <td>04472fb9-14d2-4510-8459-db44c9271986</td>\n",
       "      <td>5092</td>\n",
       "      <td>1974-07-08</td>\n",
       "      <td>male</td>\n",
       "      <td>3</td>\n",
       "      <td>79.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>2011-09-30T20:26:46+00:00</td>\n",
       "      <td>2014-03-05T20:26:46+00:00</td>\n",
       "      <td>92</td>\n",
       "      <td>79</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91104</th>\n",
       "      <td>04472fb9-14d2-4510-8459-db44c9271986</td>\n",
       "      <td>1261</td>\n",
       "      <td>1974-07-08</td>\n",
       "      <td>male</td>\n",
       "      <td>6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-10-20T20:26:46+00:00</td>\n",
       "      <td>2014-03-05T20:26:46+00:00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1256AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA</td>\n",
       "      <td>1256</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95063</th>\n",
       "      <td>04472fb9-14d2-4510-8459-db44c9271986</td>\n",
       "      <td>5089</td>\n",
       "      <td>1974-07-08</td>\n",
       "      <td>male</td>\n",
       "      <td>1</td>\n",
       "      <td>63.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>2011-09-30T20:26:46+00:00</td>\n",
       "      <td>2011-09-30T20:26:46+00:00</td>\n",
       "      <td>63</td>\n",
       "      <td>63</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  patientId  code   birthDate gender  num_obs  \\\n",
       "930    04472fb9-14d2-4510-8459-db44c9271986   844  1974-07-08   male        6   \n",
       "931    04472fb9-14d2-4510-8459-db44c9271986  1030  1974-07-08   male        6   \n",
       "4140   04472fb9-14d2-4510-8459-db44c9271986  1040  1974-07-08   male        8   \n",
       "8275   04472fb9-14d2-4510-8459-db44c9271986  1088  1974-07-08   male       52   \n",
       "13394  04472fb9-14d2-4510-8459-db44c9271986  1111  1974-07-08   male       33   \n",
       "18962  04472fb9-14d2-4510-8459-db44c9271986  1250  1974-07-08   male       34   \n",
       "20019  04472fb9-14d2-4510-8459-db44c9271986  1255  1974-07-08   male        6   \n",
       "31199  04472fb9-14d2-4510-8459-db44c9271986  1270  1974-07-08   male       61   \n",
       "36192  04472fb9-14d2-4510-8459-db44c9271986  1271  1974-07-08   male      110   \n",
       "37896  04472fb9-14d2-4510-8459-db44c9271986  6174  1974-07-08   male       26   \n",
       "42360  04472fb9-14d2-4510-8459-db44c9271986  2154  1974-07-08   male        5   \n",
       "45410  04472fb9-14d2-4510-8459-db44c9271986  5085  1974-07-08   male        6   \n",
       "55319  04472fb9-14d2-4510-8459-db44c9271986   856  1974-07-08   male        3   \n",
       "64821  04472fb9-14d2-4510-8459-db44c9271986  1268  1974-07-08   male        6   \n",
       "70633  04472fb9-14d2-4510-8459-db44c9271986  5087  1974-07-08   male        3   \n",
       "71786  04472fb9-14d2-4510-8459-db44c9271986  5088  1974-07-08   male        3   \n",
       "74093  04472fb9-14d2-4510-8459-db44c9271986  5090  1974-07-08   male        1   \n",
       "82343  04472fb9-14d2-4510-8459-db44c9271986  1265  1974-07-08   male        6   \n",
       "87320  04472fb9-14d2-4510-8459-db44c9271986  5092  1974-07-08   male        3   \n",
       "91104  04472fb9-14d2-4510-8459-db44c9271986  1261  1974-07-08   male        6   \n",
       "95063  04472fb9-14d2-4510-8459-db44c9271986  5089  1974-07-08   male        1   \n",
       "\n",
       "       min_value  max_value                   min_date  \\\n",
       "930          NaN        NaN  2011-09-30T20:26:46+00:00   \n",
       "931          NaN        NaN  2011-09-30T20:26:46+00:00   \n",
       "4140         NaN        NaN  2011-09-30T20:26:46+00:00   \n",
       "8275         NaN        NaN  2012-10-20T20:26:46+00:00   \n",
       "13394        NaN        NaN  2012-10-20T20:26:46+00:00   \n",
       "18962        NaN        NaN  2012-10-20T20:26:46+00:00   \n",
       "20019        NaN        NaN  2012-10-20T20:26:46+00:00   \n",
       "31199        NaN        NaN  2012-10-20T20:26:46+00:00   \n",
       "36192        NaN        NaN  2011-09-30T20:26:46+00:00   \n",
       "37896        NaN        NaN  2011-09-30T20:26:46+00:00   \n",
       "42360        NaN        NaN  2012-10-20T20:26:46+00:00   \n",
       "45410       59.0      206.0  2011-09-30T20:26:46+00:00   \n",
       "55319   437660.0   961780.0  2011-09-30T20:26:46+00:00   \n",
       "64821        NaN        NaN  2012-10-20T20:26:46+00:00   \n",
       "70633       64.0      130.0  2011-09-30T20:26:46+00:00   \n",
       "71786       35.0       37.0  2011-09-30T20:26:46+00:00   \n",
       "74093      171.0      171.0  2011-09-30T20:26:46+00:00   \n",
       "82343        NaN        NaN  2012-10-20T20:26:46+00:00   \n",
       "87320       79.0       96.0  2011-09-30T20:26:46+00:00   \n",
       "91104        NaN        NaN  2012-10-20T20:26:46+00:00   \n",
       "95063       63.0       63.0  2011-09-30T20:26:46+00:00   \n",
       "\n",
       "                        max_date last_value first_value  \\\n",
       "930    2014-03-05T20:26:46+00:00       None        None   \n",
       "931    2014-03-05T20:26:46+00:00       None        None   \n",
       "4140   2014-03-05T20:26:46+00:00       None        None   \n",
       "8275   2014-03-05T20:26:46+00:00       None        None   \n",
       "13394  2014-03-05T20:26:46+00:00       None        None   \n",
       "18962  2014-03-05T20:26:46+00:00       None        None   \n",
       "20019  2014-03-05T20:26:46+00:00       None        None   \n",
       "31199  2014-03-05T20:26:46+00:00       None        None   \n",
       "36192  2014-03-05T20:26:46+00:00       None        None   \n",
       "37896  2014-03-05T20:26:46+00:00       None        None   \n",
       "42360  2014-03-05T20:26:46+00:00       None        None   \n",
       "45410  2014-03-05T20:26:46+00:00        206         162   \n",
       "55319  2014-03-05T20:26:46+00:00     437660      961780   \n",
       "64821  2014-03-05T20:26:46+00:00       None        None   \n",
       "70633  2014-03-05T20:26:46+00:00         64         101   \n",
       "71786  2014-03-05T20:26:46+00:00         37          35   \n",
       "74093  2011-09-30T20:26:46+00:00        171         171   \n",
       "82343  2014-03-05T20:26:46+00:00       None        None   \n",
       "87320  2014-03-05T20:26:46+00:00         92          79   \n",
       "91104  2014-03-05T20:26:46+00:00       None        None   \n",
       "95063  2011-09-30T20:26:46+00:00         63          63   \n",
       "\n",
       "                            last_value_code  \\\n",
       "930    1138AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA   \n",
       "931    1138AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA   \n",
       "4140                                    704   \n",
       "8275   84795AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA   \n",
       "13394  75948AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA   \n",
       "18962  86663AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA   \n",
       "20019  1256AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA   \n",
       "31199  82900AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA   \n",
       "36192  856AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA   \n",
       "37896                                   967   \n",
       "42360  817AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA   \n",
       "45410                                  None   \n",
       "55319                                  None   \n",
       "64821  1257AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA   \n",
       "70633                                  None   \n",
       "71786                                  None   \n",
       "74093                                  None   \n",
       "82343  1107AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA   \n",
       "87320                                  None   \n",
       "91104  1256AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA   \n",
       "95063                                  None   \n",
       "\n",
       "                           first_value_code  \n",
       "930                                    1138  \n",
       "931                                    1138  \n",
       "4140                                    703  \n",
       "8275   104565AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA  \n",
       "13394                                  1107  \n",
       "18962                                   623  \n",
       "20019                                  1256  \n",
       "31199                                  1108  \n",
       "36192                                  1042  \n",
       "37896  138905AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA  \n",
       "42360  1652AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA  \n",
       "45410                                  None  \n",
       "55319                                  None  \n",
       "64821                                  1259  \n",
       "70633                                  None  \n",
       "71786                                  None  \n",
       "74093                                  None  \n",
       "82343                                   981  \n",
       "87320                                  None  \n",
       "91104                                  1256  \n",
       "95063                                  None  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "patient_id = '01b747b4-2029-4842-bf32-e3157c4f4f06'\n",
    "patient_id = '04472fb9-14d2-4510-8459-db44c9271986'\n",
    "obs_df[obs_df['patientId']==patient_id] #[['code', 'first_value_code', 'last_value_code']]"
   ]
  }
 ],
 "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.9.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}