Analyzer.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "----- htn.sas7bdat -----\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 8675 entries, 0 to 8674\n",
      "Data columns (total 17 columns):\n",
      " #   Column              Non-Null Count  Dtype  \n",
      "---  ------              --------------  -----  \n",
      " 0   RN_KEY              8675 non-null   object \n",
      " 1   RN_INDI             8675 non-null   float64\n",
      " 2   RN_INST             8675 non-null   float64\n",
      " 3   MDCARE_STRT_DT      8675 non-null   object \n",
      " 4   FORM_CD             8675 non-null   object \n",
      " 5   SICK_SYM1           8675 non-null   object \n",
      " 6   SICK_SYM2           6327 non-null   object \n",
      " 7   OPRTN_YN            8675 non-null   object \n",
      " 8   MDCARE_DD_CNT       8675 non-null   float64\n",
      " 9   VSHSP_DD_CNT        8675 non-null   float64\n",
      " 10  TOT_PRSC_DD_CNT     8675 non-null   float64\n",
      " 11  MCARE_RSLT_TYPE     7765 non-null   object \n",
      " 12  ED_RC_TOT_AMT       8675 non-null   float64\n",
      " 13  EDC_SBA             8675 non-null   float64\n",
      " 14  EDC_INSUR_BRDN_AMT  8675 non-null   float64\n",
      " 15  SPCF_SYM_TYPE       38 non-null     object \n",
      " 16  year                8675 non-null   object \n",
      "dtypes: float64(8), object(9)\n",
      "memory usage: 1.1+ MB\n",
      "None\n",
      "\n",
      "Sample Data:\n"
     ]
    },
    {
     "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>RN_KEY</th>\n",
       "      <th>RN_INDI</th>\n",
       "      <th>RN_INST</th>\n",
       "      <th>MDCARE_STRT_DT</th>\n",
       "      <th>FORM_CD</th>\n",
       "      <th>SICK_SYM1</th>\n",
       "      <th>SICK_SYM2</th>\n",
       "      <th>OPRTN_YN</th>\n",
       "      <th>MDCARE_DD_CNT</th>\n",
       "      <th>VSHSP_DD_CNT</th>\n",
       "      <th>TOT_PRSC_DD_CNT</th>\n",
       "      <th>MCARE_RSLT_TYPE</th>\n",
       "      <th>ED_RC_TOT_AMT</th>\n",
       "      <th>EDC_SBA</th>\n",
       "      <th>EDC_INSUR_BRDN_AMT</th>\n",
       "      <th>SPCF_SYM_TYPE</th>\n",
       "      <th>year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>b'20060000001608'</td>\n",
       "      <td>4225033.0</td>\n",
       "      <td>992958.0</td>\n",
       "      <td>b'20060120'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'I10'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>9380.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>6380.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'2006'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>b'20060000004844'</td>\n",
       "      <td>2300934.0</td>\n",
       "      <td>951117.0</td>\n",
       "      <td>b'20060209'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'I10'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>9380.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>7880.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'2006'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>b'20060000001330'</td>\n",
       "      <td>3706592.0</td>\n",
       "      <td>219959.0</td>\n",
       "      <td>b'20060104'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'I10'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>9380.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>6380.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'2006'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>b'20060000020574'</td>\n",
       "      <td>3706592.0</td>\n",
       "      <td>219959.0</td>\n",
       "      <td>b'20060515'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'I10'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>9380.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>6380.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'2006'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>b'20060000018981'</td>\n",
       "      <td>9548129.0</td>\n",
       "      <td>211618.0</td>\n",
       "      <td>b'20060508'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'I10'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>9380.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>7880.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'2006'</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              RN_KEY    RN_INDI   RN_INST MDCARE_STRT_DT FORM_CD SICK_SYM1  \\\n",
       "0  b'20060000001608'  4225033.0  992958.0    b'20060120'   b'03'    b'I10'   \n",
       "1  b'20060000004844'  2300934.0  951117.0    b'20060209'   b'03'    b'I10'   \n",
       "2  b'20060000001330'  3706592.0  219959.0    b'20060104'   b'03'    b'I10'   \n",
       "3  b'20060000020574'  3706592.0  219959.0    b'20060515'   b'03'    b'I10'   \n",
       "4  b'20060000018981'  9548129.0  211618.0    b'20060508'   b'03'    b'I10'   \n",
       "\n",
       "  SICK_SYM2 OPRTN_YN  MDCARE_DD_CNT  VSHSP_DD_CNT  TOT_PRSC_DD_CNT  \\\n",
       "0       NaN     b'0'            1.0           1.0             30.0   \n",
       "1       NaN     b'0'            1.0           1.0             30.0   \n",
       "2       NaN     b'0'            1.0           1.0             30.0   \n",
       "3       NaN     b'0'            1.0           1.0             30.0   \n",
       "4       NaN     b'0'            1.0           1.0             30.0   \n",
       "\n",
       "  MCARE_RSLT_TYPE  ED_RC_TOT_AMT  EDC_SBA  EDC_INSUR_BRDN_AMT SPCF_SYM_TYPE  \\\n",
       "0            b'1'         9380.0   3000.0              6380.0           NaN   \n",
       "1            b'1'         9380.0   1500.0              7880.0           NaN   \n",
       "2            b'1'         9380.0   3000.0              6380.0           NaN   \n",
       "3            b'1'         9380.0   3000.0              6380.0           NaN   \n",
       "4            b'1'         9380.0   1500.0              7880.0           NaN   \n",
       "\n",
       "      year  \n",
       "0  b'2006'  \n",
       "1  b'2006'  \n",
       "2  b'2006'  \n",
       "3  b'2006'  \n",
       "4  b'2006'  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "----- htn_age.sas7bdat -----\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 8675 entries, 0 to 8674\n",
      "Data columns (total 18 columns):\n",
      " #   Column              Non-Null Count  Dtype  \n",
      "---  ------              --------------  -----  \n",
      " 0   RN_KEY              8675 non-null   object \n",
      " 1   RN_INDI             8675 non-null   float64\n",
      " 2   RN_INST             8675 non-null   float64\n",
      " 3   MDCARE_STRT_DT      8675 non-null   object \n",
      " 4   FORM_CD             8675 non-null   object \n",
      " 5   SICK_SYM1           8675 non-null   object \n",
      " 6   SICK_SYM2           6327 non-null   object \n",
      " 7   OPRTN_YN            8675 non-null   object \n",
      " 8   MDCARE_DD_CNT       8675 non-null   float64\n",
      " 9   VSHSP_DD_CNT        8675 non-null   float64\n",
      " 10  TOT_PRSC_DD_CNT     8675 non-null   float64\n",
      " 11  MCARE_RSLT_TYPE     7765 non-null   object \n",
      " 12  ED_RC_TOT_AMT       8675 non-null   float64\n",
      " 13  EDC_SBA             8675 non-null   float64\n",
      " 14  EDC_INSUR_BRDN_AMT  8675 non-null   float64\n",
      " 15  SPCF_SYM_TYPE       38 non-null     object \n",
      " 16  year                8675 non-null   object \n",
      " 17  BTH_YYYY            8675 non-null   object \n",
      "dtypes: float64(8), object(10)\n",
      "memory usage: 1.2+ MB\n",
      "None\n",
      "\n",
      "Sample Data:\n"
     ]
    },
    {
     "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>RN_KEY</th>\n",
       "      <th>RN_INDI</th>\n",
       "      <th>RN_INST</th>\n",
       "      <th>MDCARE_STRT_DT</th>\n",
       "      <th>FORM_CD</th>\n",
       "      <th>SICK_SYM1</th>\n",
       "      <th>SICK_SYM2</th>\n",
       "      <th>OPRTN_YN</th>\n",
       "      <th>MDCARE_DD_CNT</th>\n",
       "      <th>VSHSP_DD_CNT</th>\n",
       "      <th>TOT_PRSC_DD_CNT</th>\n",
       "      <th>MCARE_RSLT_TYPE</th>\n",
       "      <th>ED_RC_TOT_AMT</th>\n",
       "      <th>EDC_SBA</th>\n",
       "      <th>EDC_INSUR_BRDN_AMT</th>\n",
       "      <th>SPCF_SYM_TYPE</th>\n",
       "      <th>year</th>\n",
       "      <th>BTH_YYYY</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>b'20100000067962'</td>\n",
       "      <td>1075059.0</td>\n",
       "      <td>561627.0</td>\n",
       "      <td>b'20101124'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'I10'</td>\n",
       "      <td>b'E782'</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>19970.0</td>\n",
       "      <td>2990.0</td>\n",
       "      <td>16980.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'2010'</td>\n",
       "      <td>b'1960'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>b'20060000010864'</td>\n",
       "      <td>1075059.0</td>\n",
       "      <td>616626.0</td>\n",
       "      <td>b'20060303'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'I10'</td>\n",
       "      <td>b'J36'</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>9490.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>8490.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'2006'</td>\n",
       "      <td>b'1960'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>b'20080000032274'</td>\n",
       "      <td>1075059.0</td>\n",
       "      <td>561627.0</td>\n",
       "      <td>b'20080621'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'E782'</td>\n",
       "      <td>b'I10'</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>27810.0</td>\n",
       "      <td>4170.0</td>\n",
       "      <td>23640.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'2008'</td>\n",
       "      <td>b'1960'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>b'20100000003911'</td>\n",
       "      <td>1075059.0</td>\n",
       "      <td>561627.0</td>\n",
       "      <td>b'20100128'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'I10'</td>\n",
       "      <td>b'E782'</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>9730.0</td>\n",
       "      <td>1450.0</td>\n",
       "      <td>8280.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'2010'</td>\n",
       "      <td>b'1960'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>b'20080000069344'</td>\n",
       "      <td>1075059.0</td>\n",
       "      <td>561627.0</td>\n",
       "      <td>b'20081201'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'E782'</td>\n",
       "      <td>b'I10'</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>9420.0</td>\n",
       "      <td>1410.0</td>\n",
       "      <td>8010.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'2008'</td>\n",
       "      <td>b'1960'</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              RN_KEY    RN_INDI   RN_INST MDCARE_STRT_DT FORM_CD SICK_SYM1  \\\n",
       "0  b'20100000067962'  1075059.0  561627.0    b'20101124'   b'03'    b'I10'   \n",
       "1  b'20060000010864'  1075059.0  616626.0    b'20060303'   b'03'    b'I10'   \n",
       "2  b'20080000032274'  1075059.0  561627.0    b'20080621'   b'03'   b'E782'   \n",
       "3  b'20100000003911'  1075059.0  561627.0    b'20100128'   b'03'    b'I10'   \n",
       "4  b'20080000069344'  1075059.0  561627.0    b'20081201'   b'03'   b'E782'   \n",
       "\n",
       "  SICK_SYM2 OPRTN_YN  MDCARE_DD_CNT  VSHSP_DD_CNT  TOT_PRSC_DD_CNT  \\\n",
       "0   b'E782'     b'0'            1.0           1.0             30.0   \n",
       "1    b'J36'     b'0'            1.0           1.0              2.0   \n",
       "2    b'I10'     b'0'            2.0           2.0             30.0   \n",
       "3   b'E782'     b'0'            1.0           1.0             30.0   \n",
       "4    b'I10'     b'0'            1.0           1.0             30.0   \n",
       "\n",
       "  MCARE_RSLT_TYPE  ED_RC_TOT_AMT  EDC_SBA  EDC_INSUR_BRDN_AMT SPCF_SYM_TYPE  \\\n",
       "0            b'1'        19970.0   2990.0             16980.0           NaN   \n",
       "1            b'1'         9490.0   1000.0              8490.0           NaN   \n",
       "2            b'1'        27810.0   4170.0             23640.0           NaN   \n",
       "3            b'1'         9730.0   1450.0              8280.0           NaN   \n",
       "4            b'1'         9420.0   1410.0              8010.0           NaN   \n",
       "\n",
       "      year BTH_YYYY  \n",
       "0  b'2010'  b'1960'  \n",
       "1  b'2006'  b'1960'  \n",
       "2  b'2008'  b'1960'  \n",
       "3  b'2010'  b'1960'  \n",
       "4  b'2008'  b'1960'  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "----- htn_pts.sas7bdat -----\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 502 entries, 0 to 501\n",
      "Data columns (total 16 columns):\n",
      " #   Column              Non-Null Count  Dtype  \n",
      "---  ------              --------------  -----  \n",
      " 0   RN_KEY              502 non-null    object \n",
      " 1   RN_INDI             502 non-null    float64\n",
      " 2   RN_INST             502 non-null    float64\n",
      " 3   MDCARE_STRT_DT      502 non-null    object \n",
      " 4   FORM_CD             502 non-null    object \n",
      " 5   SICK_SYM1           502 non-null    object \n",
      " 6   SICK_SYM2           324 non-null    object \n",
      " 7   OPRTN_YN            502 non-null    object \n",
      " 8   MDCARE_DD_CNT       502 non-null    float64\n",
      " 9   VSHSP_DD_CNT        502 non-null    float64\n",
      " 10  TOT_PRSC_DD_CNT     502 non-null    float64\n",
      " 11  MCARE_RSLT_TYPE     462 non-null    object \n",
      " 12  ED_RC_TOT_AMT       502 non-null    float64\n",
      " 13  EDC_SBA             502 non-null    float64\n",
      " 14  EDC_INSUR_BRDN_AMT  502 non-null    float64\n",
      " 15  SPCF_SYM_TYPE       3 non-null      object \n",
      "dtypes: float64(8), object(8)\n",
      "memory usage: 62.9+ KB\n",
      "None\n",
      "\n",
      "Sample Data:\n"
     ]
    },
    {
     "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>RN_KEY</th>\n",
       "      <th>RN_INDI</th>\n",
       "      <th>RN_INST</th>\n",
       "      <th>MDCARE_STRT_DT</th>\n",
       "      <th>FORM_CD</th>\n",
       "      <th>SICK_SYM1</th>\n",
       "      <th>SICK_SYM2</th>\n",
       "      <th>OPRTN_YN</th>\n",
       "      <th>MDCARE_DD_CNT</th>\n",
       "      <th>VSHSP_DD_CNT</th>\n",
       "      <th>TOT_PRSC_DD_CNT</th>\n",
       "      <th>MCARE_RSLT_TYPE</th>\n",
       "      <th>ED_RC_TOT_AMT</th>\n",
       "      <th>EDC_SBA</th>\n",
       "      <th>EDC_INSUR_BRDN_AMT</th>\n",
       "      <th>SPCF_SYM_TYPE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>b'20060000004329'</td>\n",
       "      <td>1075059.0</td>\n",
       "      <td>616626.0</td>\n",
       "      <td>b'20060104'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'I10'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>17340.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>15340.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>b'20060000020113'</td>\n",
       "      <td>1078047.0</td>\n",
       "      <td>384809.0</td>\n",
       "      <td>b'20060509'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'I10'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>9380.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>7880.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>b'20060000004811'</td>\n",
       "      <td>1128290.0</td>\n",
       "      <td>120395.0</td>\n",
       "      <td>b'20060210'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'I209'</td>\n",
       "      <td>b'I10'</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>11830.0</td>\n",
       "      <td>11830.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>b'20060000015502'</td>\n",
       "      <td>1144977.0</td>\n",
       "      <td>978379.0</td>\n",
       "      <td>b'20060401'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'I10'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>13810.0</td>\n",
       "      <td>6900.0</td>\n",
       "      <td>6910.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>b'20100000016754'</td>\n",
       "      <td>1145565.0</td>\n",
       "      <td>324510.0</td>\n",
       "      <td>b'20100303'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'I10'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>10360.0</td>\n",
       "      <td>3100.0</td>\n",
       "      <td>7260.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              RN_KEY    RN_INDI   RN_INST MDCARE_STRT_DT FORM_CD SICK_SYM1  \\\n",
       "0  b'20060000004329'  1075059.0  616626.0    b'20060104'   b'03'    b'I10'   \n",
       "1  b'20060000020113'  1078047.0  384809.0    b'20060509'   b'03'    b'I10'   \n",
       "2  b'20060000004811'  1128290.0  120395.0    b'20060210'   b'03'   b'I209'   \n",
       "3  b'20060000015502'  1144977.0  978379.0    b'20060401'   b'03'    b'I10'   \n",
       "4  b'20100000016754'  1145565.0  324510.0    b'20100303'   b'03'    b'I10'   \n",
       "\n",
       "  SICK_SYM2 OPRTN_YN  MDCARE_DD_CNT  VSHSP_DD_CNT  TOT_PRSC_DD_CNT  \\\n",
       "0       NaN     b'0'            2.0           2.0             17.0   \n",
       "1       NaN     b'0'            1.0           1.0             30.0   \n",
       "2    b'I10'     b'0'            1.0           1.0             90.0   \n",
       "3       NaN     b'0'            1.0           1.0             60.0   \n",
       "4       NaN     b'0'            1.0           1.0             30.0   \n",
       "\n",
       "  MCARE_RSLT_TYPE  ED_RC_TOT_AMT  EDC_SBA  EDC_INSUR_BRDN_AMT SPCF_SYM_TYPE  \n",
       "0            b'1'        17340.0   2000.0             15340.0           NaN  \n",
       "1            b'1'         9380.0   1500.0              7880.0           NaN  \n",
       "2            b'1'        11830.0  11830.0                 0.0           NaN  \n",
       "3            b'1'        13810.0   6900.0              6910.0           NaN  \n",
       "4            b'1'        10360.0   3100.0              7260.0           NaN  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "----- htn_pts_2006.sas7bdat -----\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 324 entries, 0 to 323\n",
      "Data columns (total 11 columns):\n",
      " #   Column        Non-Null Count  Dtype  \n",
      "---  ------        --------------  -----  \n",
      " 0   RN_INDI       324 non-null    float64\n",
      " 1   year          324 non-null    object \n",
      " 2   STD_YYYY      324 non-null    object \n",
      " 3   SEX           324 non-null    object \n",
      " 4   SIDO          324 non-null    object \n",
      " 5   GAIBJA_TYPE   324 non-null    object \n",
      " 6   CTRB_Q10      296 non-null    float64\n",
      " 7   DSB_SVRT_CD   32 non-null     object \n",
      " 8   DSB_TYPE_CD   32 non-null     object \n",
      " 9   G1E_OBJ_YN    155 non-null    object \n",
      " 10  SMPL_TYPE_CD  324 non-null    object \n",
      "dtypes: float64(2), object(9)\n",
      "memory usage: 28.0+ KB\n",
      "None\n",
      "\n",
      "Sample Data:\n"
     ]
    },
    {
     "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>RN_INDI</th>\n",
       "      <th>year</th>\n",
       "      <th>STD_YYYY</th>\n",
       "      <th>SEX</th>\n",
       "      <th>SIDO</th>\n",
       "      <th>GAIBJA_TYPE</th>\n",
       "      <th>CTRB_Q10</th>\n",
       "      <th>DSB_SVRT_CD</th>\n",
       "      <th>DSB_TYPE_CD</th>\n",
       "      <th>G1E_OBJ_YN</th>\n",
       "      <th>SMPL_TYPE_CD</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1075059.0</td>\n",
       "      <td>b'2006'</td>\n",
       "      <td>b'2006'</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>b'29'</td>\n",
       "      <td>b'7'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'1'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1078047.0</td>\n",
       "      <td>b'2006'</td>\n",
       "      <td>b'2006'</td>\n",
       "      <td>b'2'</td>\n",
       "      <td>b'41'</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'1'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1128290.0</td>\n",
       "      <td>b'2006'</td>\n",
       "      <td>b'2006'</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>b'28'</td>\n",
       "      <td>b'5'</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'Y'</td>\n",
       "      <td>b'1'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1144977.0</td>\n",
       "      <td>b'2006'</td>\n",
       "      <td>b'2006'</td>\n",
       "      <td>b'2'</td>\n",
       "      <td>b'41'</td>\n",
       "      <td>b'2'</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'1'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1234482.0</td>\n",
       "      <td>b'2006'</td>\n",
       "      <td>b'2006'</td>\n",
       "      <td>b'2'</td>\n",
       "      <td>b'11'</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>6.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'Y'</td>\n",
       "      <td>b'1'</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     RN_INDI     year STD_YYYY   SEX   SIDO GAIBJA_TYPE  CTRB_Q10 DSB_SVRT_CD  \\\n",
       "0  1075059.0  b'2006'  b'2006'  b'1'  b'29'        b'7'       NaN         NaN   \n",
       "1  1078047.0  b'2006'  b'2006'  b'2'  b'41'        b'1'       1.0         NaN   \n",
       "2  1128290.0  b'2006'  b'2006'  b'1'  b'28'        b'5'       4.0         NaN   \n",
       "3  1144977.0  b'2006'  b'2006'  b'2'  b'41'        b'2'       5.0         NaN   \n",
       "4  1234482.0  b'2006'  b'2006'  b'2'  b'11'        b'1'       6.0         NaN   \n",
       "\n",
       "  DSB_TYPE_CD G1E_OBJ_YN SMPL_TYPE_CD  \n",
       "0         NaN        NaN         b'1'  \n",
       "1         NaN        NaN         b'1'  \n",
       "2         NaN       b'Y'         b'1'  \n",
       "3         NaN        NaN         b'1'  \n",
       "4         NaN       b'Y'         b'1'  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "----- htn_sub.sas7bdat -----\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 12030 entries, 0 to 12029\n",
      "Data columns (total 16 columns):\n",
      " #   Column              Non-Null Count  Dtype  \n",
      "---  ------              --------------  -----  \n",
      " 0   RN_KEY              12030 non-null  object \n",
      " 1   RN_INDI             12030 non-null  float64\n",
      " 2   RN_INST             12030 non-null  float64\n",
      " 3   MDCARE_STRT_DT      12030 non-null  object \n",
      " 4   FORM_CD             12030 non-null  object \n",
      " 5   SICK_SYM1           12030 non-null  object \n",
      " 6   SICK_SYM2           8850 non-null   object \n",
      " 7   OPRTN_YN            12030 non-null  object \n",
      " 8   MDCARE_DD_CNT       12030 non-null  float64\n",
      " 9   VSHSP_DD_CNT        12030 non-null  float64\n",
      " 10  TOT_PRSC_DD_CNT     12030 non-null  float64\n",
      " 11  MCARE_RSLT_TYPE     10695 non-null  object \n",
      " 12  ED_RC_TOT_AMT       12030 non-null  float64\n",
      " 13  EDC_SBA             12030 non-null  float64\n",
      " 14  EDC_INSUR_BRDN_AMT  12030 non-null  float64\n",
      " 15  SPCF_SYM_TYPE       75 non-null     object \n",
      "dtypes: float64(8), object(8)\n",
      "memory usage: 1.5+ MB\n",
      "None\n",
      "\n",
      "Sample Data:\n"
     ]
    },
    {
     "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>RN_KEY</th>\n",
       "      <th>RN_INDI</th>\n",
       "      <th>RN_INST</th>\n",
       "      <th>MDCARE_STRT_DT</th>\n",
       "      <th>FORM_CD</th>\n",
       "      <th>SICK_SYM1</th>\n",
       "      <th>SICK_SYM2</th>\n",
       "      <th>OPRTN_YN</th>\n",
       "      <th>MDCARE_DD_CNT</th>\n",
       "      <th>VSHSP_DD_CNT</th>\n",
       "      <th>TOT_PRSC_DD_CNT</th>\n",
       "      <th>MCARE_RSLT_TYPE</th>\n",
       "      <th>ED_RC_TOT_AMT</th>\n",
       "      <th>EDC_SBA</th>\n",
       "      <th>EDC_INSUR_BRDN_AMT</th>\n",
       "      <th>SPCF_SYM_TYPE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>b'20060000001608'</td>\n",
       "      <td>4225033.0</td>\n",
       "      <td>992958.0</td>\n",
       "      <td>b'20060120'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'I10'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>9380.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>6380.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>b'20060000004844'</td>\n",
       "      <td>2300934.0</td>\n",
       "      <td>951117.0</td>\n",
       "      <td>b'20060209'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'I10'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>9380.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>7880.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>b'20060000001330'</td>\n",
       "      <td>3706592.0</td>\n",
       "      <td>219959.0</td>\n",
       "      <td>b'20060104'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'I10'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>9380.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>6380.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>b'20060000020574'</td>\n",
       "      <td>3706592.0</td>\n",
       "      <td>219959.0</td>\n",
       "      <td>b'20060515'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'I10'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>9380.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>6380.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>b'20060000018981'</td>\n",
       "      <td>9548129.0</td>\n",
       "      <td>211618.0</td>\n",
       "      <td>b'20060508'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'I10'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>9380.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>7880.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              RN_KEY    RN_INDI   RN_INST MDCARE_STRT_DT FORM_CD SICK_SYM1  \\\n",
       "0  b'20060000001608'  4225033.0  992958.0    b'20060120'   b'03'    b'I10'   \n",
       "1  b'20060000004844'  2300934.0  951117.0    b'20060209'   b'03'    b'I10'   \n",
       "2  b'20060000001330'  3706592.0  219959.0    b'20060104'   b'03'    b'I10'   \n",
       "3  b'20060000020574'  3706592.0  219959.0    b'20060515'   b'03'    b'I10'   \n",
       "4  b'20060000018981'  9548129.0  211618.0    b'20060508'   b'03'    b'I10'   \n",
       "\n",
       "  SICK_SYM2 OPRTN_YN  MDCARE_DD_CNT  VSHSP_DD_CNT  TOT_PRSC_DD_CNT  \\\n",
       "0       NaN     b'0'            1.0           1.0             30.0   \n",
       "1       NaN     b'0'            1.0           1.0             30.0   \n",
       "2       NaN     b'0'            1.0           1.0             30.0   \n",
       "3       NaN     b'0'            1.0           1.0             30.0   \n",
       "4       NaN     b'0'            1.0           1.0             30.0   \n",
       "\n",
       "  MCARE_RSLT_TYPE  ED_RC_TOT_AMT  EDC_SBA  EDC_INSUR_BRDN_AMT SPCF_SYM_TYPE  \n",
       "0            b'1'         9380.0   3000.0              6380.0           NaN  \n",
       "1            b'1'         9380.0   1500.0              7880.0           NaN  \n",
       "2            b'1'         9380.0   3000.0              6380.0           NaN  \n",
       "3            b'1'         9380.0   3000.0              6380.0           NaN  \n",
       "4            b'1'         9380.0   1500.0              7880.0           NaN  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "----- htn_sub_pts.sas7bdat -----\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 564 entries, 0 to 563\n",
      "Data columns (total 16 columns):\n",
      " #   Column              Non-Null Count  Dtype  \n",
      "---  ------              --------------  -----  \n",
      " 0   RN_KEY              564 non-null    object \n",
      " 1   RN_INDI             564 non-null    float64\n",
      " 2   RN_INST             564 non-null    float64\n",
      " 3   MDCARE_STRT_DT      564 non-null    object \n",
      " 4   FORM_CD             564 non-null    object \n",
      " 5   SICK_SYM1           564 non-null    object \n",
      " 6   SICK_SYM2           358 non-null    object \n",
      " 7   OPRTN_YN            564 non-null    object \n",
      " 8   MDCARE_DD_CNT       564 non-null    float64\n",
      " 9   VSHSP_DD_CNT        564 non-null    float64\n",
      " 10  TOT_PRSC_DD_CNT     564 non-null    float64\n",
      " 11  MCARE_RSLT_TYPE     519 non-null    object \n",
      " 12  ED_RC_TOT_AMT       564 non-null    float64\n",
      " 13  EDC_SBA             564 non-null    float64\n",
      " 14  EDC_INSUR_BRDN_AMT  564 non-null    float64\n",
      " 15  SPCF_SYM_TYPE       3 non-null      object \n",
      "dtypes: float64(8), object(8)\n",
      "memory usage: 70.6+ KB\n",
      "None\n",
      "\n",
      "Sample Data:\n"
     ]
    },
    {
     "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>RN_KEY</th>\n",
       "      <th>RN_INDI</th>\n",
       "      <th>RN_INST</th>\n",
       "      <th>MDCARE_STRT_DT</th>\n",
       "      <th>FORM_CD</th>\n",
       "      <th>SICK_SYM1</th>\n",
       "      <th>SICK_SYM2</th>\n",
       "      <th>OPRTN_YN</th>\n",
       "      <th>MDCARE_DD_CNT</th>\n",
       "      <th>VSHSP_DD_CNT</th>\n",
       "      <th>TOT_PRSC_DD_CNT</th>\n",
       "      <th>MCARE_RSLT_TYPE</th>\n",
       "      <th>ED_RC_TOT_AMT</th>\n",
       "      <th>EDC_SBA</th>\n",
       "      <th>EDC_INSUR_BRDN_AMT</th>\n",
       "      <th>SPCF_SYM_TYPE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>b'20060000004329'</td>\n",
       "      <td>1075059.0</td>\n",
       "      <td>616626.0</td>\n",
       "      <td>b'20060104'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'I10'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>17340.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>15340.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>b'20060000020113'</td>\n",
       "      <td>1078047.0</td>\n",
       "      <td>384809.0</td>\n",
       "      <td>b'20060509'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'I10'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>9380.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>7880.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>b'20060000004811'</td>\n",
       "      <td>1128290.0</td>\n",
       "      <td>120395.0</td>\n",
       "      <td>b'20060210'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'I209'</td>\n",
       "      <td>b'I10'</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>11830.0</td>\n",
       "      <td>11830.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>b'20060000015502'</td>\n",
       "      <td>1144977.0</td>\n",
       "      <td>978379.0</td>\n",
       "      <td>b'20060401'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'I10'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>13810.0</td>\n",
       "      <td>6900.0</td>\n",
       "      <td>6910.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>b'20100000016754'</td>\n",
       "      <td>1145565.0</td>\n",
       "      <td>324510.0</td>\n",
       "      <td>b'20100303'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'I10'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>10360.0</td>\n",
       "      <td>3100.0</td>\n",
       "      <td>7260.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              RN_KEY    RN_INDI   RN_INST MDCARE_STRT_DT FORM_CD SICK_SYM1  \\\n",
       "0  b'20060000004329'  1075059.0  616626.0    b'20060104'   b'03'    b'I10'   \n",
       "1  b'20060000020113'  1078047.0  384809.0    b'20060509'   b'03'    b'I10'   \n",
       "2  b'20060000004811'  1128290.0  120395.0    b'20060210'   b'03'   b'I209'   \n",
       "3  b'20060000015502'  1144977.0  978379.0    b'20060401'   b'03'    b'I10'   \n",
       "4  b'20100000016754'  1145565.0  324510.0    b'20100303'   b'03'    b'I10'   \n",
       "\n",
       "  SICK_SYM2 OPRTN_YN  MDCARE_DD_CNT  VSHSP_DD_CNT  TOT_PRSC_DD_CNT  \\\n",
       "0       NaN     b'0'            2.0           2.0             17.0   \n",
       "1       NaN     b'0'            1.0           1.0             30.0   \n",
       "2    b'I10'     b'0'            1.0           1.0             90.0   \n",
       "3       NaN     b'0'            1.0           1.0             60.0   \n",
       "4       NaN     b'0'            1.0           1.0             30.0   \n",
       "\n",
       "  MCARE_RSLT_TYPE  ED_RC_TOT_AMT  EDC_SBA  EDC_INSUR_BRDN_AMT SPCF_SYM_TYPE  \n",
       "0            b'1'        17340.0   2000.0             15340.0           NaN  \n",
       "1            b'1'         9380.0   1500.0              7880.0           NaN  \n",
       "2            b'1'        11830.0  11830.0                 0.0           NaN  \n",
       "3            b'1'        13810.0   6900.0              6910.0           NaN  \n",
       "4            b'1'        10360.0   3100.0              7260.0           NaN  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "----- htn_sym.sas7bdat -----\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 1007532 entries, 0 to 1007531\n",
      "Data columns (total 17 columns):\n",
      " #   Column              Non-Null Count    Dtype  \n",
      "---  ------              --------------    -----  \n",
      " 0   RN_KEY              1007532 non-null  object \n",
      " 1   RN_INDI             1007532 non-null  float64\n",
      " 2   RN_INST             1007532 non-null  float64\n",
      " 3   MDCARE_STRT_DT      1007532 non-null  object \n",
      " 4   FORM_CD             1007532 non-null  object \n",
      " 5   SICK_SYM1           1007532 non-null  object \n",
      " 6   SICK_SYM2           787506 non-null   object \n",
      " 7   OPRTN_YN            1007532 non-null  object \n",
      " 8   MDCARE_DD_CNT       1007532 non-null  float64\n",
      " 9   VSHSP_DD_CNT        1007532 non-null  float64\n",
      " 10  TOT_PRSC_DD_CNT     1007532 non-null  float64\n",
      " 11  MCARE_RSLT_TYPE     899154 non-null   object \n",
      " 12  ED_RC_TOT_AMT       1007532 non-null  float64\n",
      " 13  EDC_SBA             1007532 non-null  float64\n",
      " 14  EDC_INSUR_BRDN_AMT  1007532 non-null  float64\n",
      " 15  SPCF_SYM_TYPE       2775 non-null     object \n",
      " 16  year                1007532 non-null  object \n",
      "dtypes: float64(8), object(9)\n",
      "memory usage: 130.7+ MB\n",
      "None\n",
      "\n",
      "Sample Data:\n"
     ]
    },
    {
     "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>RN_KEY</th>\n",
       "      <th>RN_INDI</th>\n",
       "      <th>RN_INST</th>\n",
       "      <th>MDCARE_STRT_DT</th>\n",
       "      <th>FORM_CD</th>\n",
       "      <th>SICK_SYM1</th>\n",
       "      <th>SICK_SYM2</th>\n",
       "      <th>OPRTN_YN</th>\n",
       "      <th>MDCARE_DD_CNT</th>\n",
       "      <th>VSHSP_DD_CNT</th>\n",
       "      <th>TOT_PRSC_DD_CNT</th>\n",
       "      <th>MCARE_RSLT_TYPE</th>\n",
       "      <th>ED_RC_TOT_AMT</th>\n",
       "      <th>EDC_SBA</th>\n",
       "      <th>EDC_INSUR_BRDN_AMT</th>\n",
       "      <th>SPCF_SYM_TYPE</th>\n",
       "      <th>year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>b'20100000067962'</td>\n",
       "      <td>1075059.0</td>\n",
       "      <td>561627.0</td>\n",
       "      <td>b'20101124'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'I10'</td>\n",
       "      <td>b'E782'</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>19970.0</td>\n",
       "      <td>2990.0</td>\n",
       "      <td>16980.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'2010'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>b'20060000010864'</td>\n",
       "      <td>1075059.0</td>\n",
       "      <td>616626.0</td>\n",
       "      <td>b'20060303'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'I10'</td>\n",
       "      <td>b'J36'</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>9490.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>8490.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'2006'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>b'20080000032274'</td>\n",
       "      <td>1075059.0</td>\n",
       "      <td>561627.0</td>\n",
       "      <td>b'20080621'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'E782'</td>\n",
       "      <td>b'I10'</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>27810.0</td>\n",
       "      <td>4170.0</td>\n",
       "      <td>23640.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'2008'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>b'20100000003911'</td>\n",
       "      <td>1075059.0</td>\n",
       "      <td>561627.0</td>\n",
       "      <td>b'20100128'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'I10'</td>\n",
       "      <td>b'E782'</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>9730.0</td>\n",
       "      <td>1450.0</td>\n",
       "      <td>8280.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'2010'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>b'20080000069344'</td>\n",
       "      <td>1075059.0</td>\n",
       "      <td>561627.0</td>\n",
       "      <td>b'20081201'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'E782'</td>\n",
       "      <td>b'I10'</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>9420.0</td>\n",
       "      <td>1410.0</td>\n",
       "      <td>8010.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'2008'</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              RN_KEY    RN_INDI   RN_INST MDCARE_STRT_DT FORM_CD SICK_SYM1  \\\n",
       "0  b'20100000067962'  1075059.0  561627.0    b'20101124'   b'03'    b'I10'   \n",
       "1  b'20060000010864'  1075059.0  616626.0    b'20060303'   b'03'    b'I10'   \n",
       "2  b'20080000032274'  1075059.0  561627.0    b'20080621'   b'03'   b'E782'   \n",
       "3  b'20100000003911'  1075059.0  561627.0    b'20100128'   b'03'    b'I10'   \n",
       "4  b'20080000069344'  1075059.0  561627.0    b'20081201'   b'03'   b'E782'   \n",
       "\n",
       "  SICK_SYM2 OPRTN_YN  MDCARE_DD_CNT  VSHSP_DD_CNT  TOT_PRSC_DD_CNT  \\\n",
       "0   b'E782'     b'0'            1.0           1.0             30.0   \n",
       "1    b'J36'     b'0'            1.0           1.0              2.0   \n",
       "2    b'I10'     b'0'            2.0           2.0             30.0   \n",
       "3   b'E782'     b'0'            1.0           1.0             30.0   \n",
       "4    b'I10'     b'0'            1.0           1.0             30.0   \n",
       "\n",
       "  MCARE_RSLT_TYPE  ED_RC_TOT_AMT  EDC_SBA  EDC_INSUR_BRDN_AMT SPCF_SYM_TYPE  \\\n",
       "0            b'1'        19970.0   2990.0             16980.0           NaN   \n",
       "1            b'1'         9490.0   1000.0              8490.0           NaN   \n",
       "2            b'1'        27810.0   4170.0             23640.0           NaN   \n",
       "3            b'1'         9730.0   1450.0              8280.0           NaN   \n",
       "4            b'1'         9420.0   1410.0              8010.0           NaN   \n",
       "\n",
       "      year  \n",
       "0  b'2010'  \n",
       "1  b'2006'  \n",
       "2  b'2008'  \n",
       "3  b'2010'  \n",
       "4  b'2008'  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "----- nsc2_edu_bnc.sas7bdat -----\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 11840 entries, 0 to 11839\n",
      "Data columns (total 10 columns):\n",
      " #   Column        Non-Null Count  Dtype  \n",
      "---  ------        --------------  -----  \n",
      " 0   STD_YYYY      11840 non-null  object \n",
      " 1   RN_INDI       11840 non-null  float64\n",
      " 2   SEX           11840 non-null  object \n",
      " 3   SIDO          11840 non-null  object \n",
      " 4   GAIBJA_TYPE   11840 non-null  object \n",
      " 5   CTRB_Q10      11272 non-null  float64\n",
      " 6   DSB_SVRT_CD   515 non-null    object \n",
      " 7   DSB_TYPE_CD   515 non-null    object \n",
      " 8   G1E_OBJ_YN    3851 non-null   object \n",
      " 9   SMPL_TYPE_CD  11840 non-null  object \n",
      "dtypes: float64(2), object(8)\n",
      "memory usage: 925.1+ KB\n",
      "None\n",
      "\n",
      "Sample Data:\n"
     ]
    },
    {
     "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>STD_YYYY</th>\n",
       "      <th>RN_INDI</th>\n",
       "      <th>SEX</th>\n",
       "      <th>SIDO</th>\n",
       "      <th>GAIBJA_TYPE</th>\n",
       "      <th>CTRB_Q10</th>\n",
       "      <th>DSB_SVRT_CD</th>\n",
       "      <th>DSB_TYPE_CD</th>\n",
       "      <th>G1E_OBJ_YN</th>\n",
       "      <th>SMPL_TYPE_CD</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>b'2006'</td>\n",
       "      <td>1001978.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>b'41'</td>\n",
       "      <td>b'2'</td>\n",
       "      <td>7.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'1'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>b'2006'</td>\n",
       "      <td>1003339.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>b'11'</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>7.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'1'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>b'2006'</td>\n",
       "      <td>1005530.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>b'43'</td>\n",
       "      <td>b'6'</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'1'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>b'2006'</td>\n",
       "      <td>1011725.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>b'26'</td>\n",
       "      <td>b'5'</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'Y'</td>\n",
       "      <td>b'1'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>b'2006'</td>\n",
       "      <td>1016532.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>b'11'</td>\n",
       "      <td>b'6'</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'1'</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  STD_YYYY    RN_INDI   SEX   SIDO GAIBJA_TYPE  CTRB_Q10 DSB_SVRT_CD  \\\n",
       "0  b'2006'  1001978.0  b'1'  b'41'        b'2'       7.0         NaN   \n",
       "1  b'2006'  1003339.0  b'1'  b'11'        b'1'       7.0         NaN   \n",
       "2  b'2006'  1005530.0  b'1'  b'43'        b'6'       5.0         NaN   \n",
       "3  b'2006'  1011725.0  b'1'  b'26'        b'5'       4.0         NaN   \n",
       "4  b'2006'  1016532.0  b'1'  b'11'        b'6'       2.0         NaN   \n",
       "\n",
       "  DSB_TYPE_CD G1E_OBJ_YN SMPL_TYPE_CD  \n",
       "0         NaN        NaN         b'1'  \n",
       "1         NaN        NaN         b'1'  \n",
       "2         NaN        NaN         b'1'  \n",
       "3         NaN       b'Y'         b'1'  \n",
       "4         NaN        NaN         b'1'  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "----- nsc2_edu_bnd.sas7bdat -----\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 3000 entries, 0 to 2999\n",
      "Data columns (total 5 columns):\n",
      " #   Column    Non-Null Count  Dtype  \n",
      "---  ------    --------------  -----  \n",
      " 0   RN_INDI   3000 non-null   float64\n",
      " 1   BTH_YYYY  3000 non-null   object \n",
      " 2   DTH_YYYY  146 non-null    object \n",
      " 3   COD1      144 non-null    object \n",
      " 4   COD2      17 non-null     object \n",
      "dtypes: float64(1), object(4)\n",
      "memory usage: 117.3+ KB\n",
      "None\n",
      "\n",
      "Sample Data:\n"
     ]
    },
    {
     "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>RN_INDI</th>\n",
       "      <th>BTH_YYYY</th>\n",
       "      <th>DTH_YYYY</th>\n",
       "      <th>COD1</th>\n",
       "      <th>COD2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>6829078.0</td>\n",
       "      <td>b'1960'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>8759563.0</td>\n",
       "      <td>b'1960'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>5053957.0</td>\n",
       "      <td>b'1960'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2137595.0</td>\n",
       "      <td>b'1950'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2429515.0</td>\n",
       "      <td>b'1960'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     RN_INDI BTH_YYYY DTH_YYYY COD1 COD2\n",
       "0  6829078.0  b'1960'      NaN  NaN  NaN\n",
       "1  8759563.0  b'1960'      NaN  NaN  NaN\n",
       "2  5053957.0  b'1960'      NaN  NaN  NaN\n",
       "3  2137595.0  b'1950'      NaN  NaN  NaN\n",
       "4  2429515.0  b'1960'      NaN  NaN  NaN"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "----- nsc2_edu_d20.sas7bdat -----\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 12459 entries, 0 to 12458\n",
      "Data columns (total 16 columns):\n",
      " #   Column              Non-Null Count  Dtype  \n",
      "---  ------              --------------  -----  \n",
      " 0   RN_KEY              12459 non-null  object \n",
      " 1   RN_INDI             12459 non-null  float64\n",
      " 2   RN_INST             12459 non-null  float64\n",
      " 3   MDCARE_STRT_DT      12459 non-null  object \n",
      " 4   FORM_CD             12459 non-null  object \n",
      " 5   SICK_SYM1           12459 non-null  object \n",
      " 6   SICK_SYM2           1607 non-null   object \n",
      " 7   OPRTN_YN            12459 non-null  object \n",
      " 8   MDCARE_DD_CNT       12459 non-null  float64\n",
      " 9   VSHSP_DD_CNT        12459 non-null  float64\n",
      " 10  TOT_PRSC_DD_CNT     12459 non-null  float64\n",
      " 11  MCARE_RSLT_TYPE     12459 non-null  object \n",
      " 12  ED_RC_TOT_AMT       12459 non-null  float64\n",
      " 13  EDC_SBA             12459 non-null  float64\n",
      " 14  EDC_INSUR_BRDN_AMT  12459 non-null  float64\n",
      " 15  SPCF_SYM_TYPE       8 non-null      object \n",
      "dtypes: float64(8), object(8)\n",
      "memory usage: 1.5+ MB\n",
      "None\n",
      "\n",
      "Sample Data:\n"
     ]
    },
    {
     "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>RN_KEY</th>\n",
       "      <th>RN_INDI</th>\n",
       "      <th>RN_INST</th>\n",
       "      <th>MDCARE_STRT_DT</th>\n",
       "      <th>FORM_CD</th>\n",
       "      <th>SICK_SYM1</th>\n",
       "      <th>SICK_SYM2</th>\n",
       "      <th>OPRTN_YN</th>\n",
       "      <th>MDCARE_DD_CNT</th>\n",
       "      <th>VSHSP_DD_CNT</th>\n",
       "      <th>TOT_PRSC_DD_CNT</th>\n",
       "      <th>MCARE_RSLT_TYPE</th>\n",
       "      <th>ED_RC_TOT_AMT</th>\n",
       "      <th>EDC_SBA</th>\n",
       "      <th>EDC_INSUR_BRDN_AMT</th>\n",
       "      <th>SPCF_SYM_TYPE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>b'20060000000026'</td>\n",
       "      <td>2682851.0</td>\n",
       "      <td>645953.0</td>\n",
       "      <td>b'20060104'</td>\n",
       "      <td>b'05'</td>\n",
       "      <td>b'K088'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'9'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>21490.0</td>\n",
       "      <td>6440.0</td>\n",
       "      <td>15050.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>b'20060000000036'</td>\n",
       "      <td>4455898.0</td>\n",
       "      <td>887167.0</td>\n",
       "      <td>b'20060126'</td>\n",
       "      <td>b'05'</td>\n",
       "      <td>b'K040'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>22700.0</td>\n",
       "      <td>7000.0</td>\n",
       "      <td>15700.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>b'20060000000089'</td>\n",
       "      <td>7530085.0</td>\n",
       "      <td>518771.0</td>\n",
       "      <td>b'20060110'</td>\n",
       "      <td>b'05'</td>\n",
       "      <td>b'K036'</td>\n",
       "      <td>b'K050'</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>22840.0</td>\n",
       "      <td>6850.0</td>\n",
       "      <td>15990.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>b'20060000000119'</td>\n",
       "      <td>2043177.0</td>\n",
       "      <td>578882.0</td>\n",
       "      <td>b'20060120'</td>\n",
       "      <td>b'05'</td>\n",
       "      <td>b'K040'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>48720.0</td>\n",
       "      <td>14610.0</td>\n",
       "      <td>34110.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>b'20060000000120'</td>\n",
       "      <td>2331328.0</td>\n",
       "      <td>675594.0</td>\n",
       "      <td>b'20060119'</td>\n",
       "      <td>b'05'</td>\n",
       "      <td>b'K053'</td>\n",
       "      <td>b'K02'</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>35340.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>35340.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              RN_KEY    RN_INDI   RN_INST MDCARE_STRT_DT FORM_CD SICK_SYM1  \\\n",
       "0  b'20060000000026'  2682851.0  645953.0    b'20060104'   b'05'   b'K088'   \n",
       "1  b'20060000000036'  4455898.0  887167.0    b'20060126'   b'05'   b'K040'   \n",
       "2  b'20060000000089'  7530085.0  518771.0    b'20060110'   b'05'   b'K036'   \n",
       "3  b'20060000000119'  2043177.0  578882.0    b'20060120'   b'05'   b'K040'   \n",
       "4  b'20060000000120'  2331328.0  675594.0    b'20060119'   b'05'   b'K053'   \n",
       "\n",
       "  SICK_SYM2 OPRTN_YN  MDCARE_DD_CNT  VSHSP_DD_CNT  TOT_PRSC_DD_CNT  \\\n",
       "0       NaN     b'9'            1.0           1.0              1.0   \n",
       "1       NaN     b'0'            2.0           2.0              0.0   \n",
       "2   b'K050'     b'0'            1.0           1.0              3.0   \n",
       "3       NaN     b'0'            1.0           1.0              3.0   \n",
       "4    b'K02'     b'0'            1.0           1.0              0.0   \n",
       "\n",
       "  MCARE_RSLT_TYPE  ED_RC_TOT_AMT  EDC_SBA  EDC_INSUR_BRDN_AMT SPCF_SYM_TYPE  \n",
       "0            b'1'        21490.0   6440.0             15050.0           NaN  \n",
       "1            b'1'        22700.0   7000.0             15700.0           NaN  \n",
       "2            b'1'        22840.0   6850.0             15990.0           NaN  \n",
       "3            b'1'        48720.0  14610.0             34110.0           NaN  \n",
       "4            b'1'        35340.0      0.0             35340.0           NaN  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "----- nsc2_edu_d30.sas7bdat -----\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 58505 entries, 0 to 58504\n",
      "Data columns (total 17 columns):\n",
      " #   Column            Non-Null Count  Dtype  \n",
      "---  ------            --------------  -----  \n",
      " 0   RN_INDI           58505 non-null  float64\n",
      " 1   RN_KEY            58505 non-null  object \n",
      " 2   MDCARE_STRT_DT    58505 non-null  object \n",
      " 3   FORM_CD           58505 non-null  object \n",
      " 4   MCARE_DESC_LN_NO  58505 non-null  object \n",
      " 5   CLA_CD            58505 non-null  object \n",
      " 6   ITEM_CD           58505 non-null  object \n",
      " 7   CLSF_PTTN_CD      58505 non-null  object \n",
      " 8   MCARE_DIV_CD      58505 non-null  object \n",
      " 9   UPRC              58505 non-null  float64\n",
      " 10  DD1_MQTY_FREQ     58505 non-null  float64\n",
      " 11  TOT_MCNT          58505 non-null  float64\n",
      " 12  AMT               58505 non-null  float64\n",
      " 13  TIME1_MDCT_CPCT   44844 non-null  float64\n",
      " 14  MDCN_UD           18823 non-null  float64\n",
      " 15  MCEXP_TYPE_CD     58505 non-null  object \n",
      " 16  EFMDC_CLSF_NO     3688 non-null   object \n",
      "dtypes: float64(7), object(10)\n",
      "memory usage: 7.6+ MB\n",
      "None\n",
      "\n",
      "Sample Data:\n"
     ]
    },
    {
     "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>RN_INDI</th>\n",
       "      <th>RN_KEY</th>\n",
       "      <th>MDCARE_STRT_DT</th>\n",
       "      <th>FORM_CD</th>\n",
       "      <th>MCARE_DESC_LN_NO</th>\n",
       "      <th>CLA_CD</th>\n",
       "      <th>ITEM_CD</th>\n",
       "      <th>CLSF_PTTN_CD</th>\n",
       "      <th>MCARE_DIV_CD</th>\n",
       "      <th>UPRC</th>\n",
       "      <th>DD1_MQTY_FREQ</th>\n",
       "      <th>TOT_MCNT</th>\n",
       "      <th>AMT</th>\n",
       "      <th>TIME1_MDCT_CPCT</th>\n",
       "      <th>MDCN_UD</th>\n",
       "      <th>MCEXP_TYPE_CD</th>\n",
       "      <th>EFMDC_CLSF_NO</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2682851.0</td>\n",
       "      <td>b'20060000000026'</td>\n",
       "      <td>b'20060104'</td>\n",
       "      <td>b'05'</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>b'01'</td>\n",
       "      <td>b'01'</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>b'AA100'</td>\n",
       "      <td>10080.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>10080.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2682851.0</td>\n",
       "      <td>b'20060000000026'</td>\n",
       "      <td>b'20060104'</td>\n",
       "      <td>b'05'</td>\n",
       "      <td>b'3'</td>\n",
       "      <td>b'05'</td>\n",
       "      <td>b'01'</td>\n",
       "      <td>b'3'</td>\n",
       "      <td>b'314300BIJ'</td>\n",
       "      <td>356.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>356.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'3'</td>\n",
       "      <td>b'121'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2682851.0</td>\n",
       "      <td>b'20060000000026'</td>\n",
       "      <td>b'20060104'</td>\n",
       "      <td>b'05'</td>\n",
       "      <td>b'2'</td>\n",
       "      <td>b'01'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>b'AL801'</td>\n",
       "      <td>160.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>160.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2682851.0</td>\n",
       "      <td>b'20060000000026'</td>\n",
       "      <td>b'20060104'</td>\n",
       "      <td>b'05'</td>\n",
       "      <td>b'4'</td>\n",
       "      <td>b'05'</td>\n",
       "      <td>b'01'</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>b'L0905'</td>\n",
       "      <td>3860.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3860.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'2'</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2682851.0</td>\n",
       "      <td>b'20060000000026'</td>\n",
       "      <td>b'20060104'</td>\n",
       "      <td>b'05'</td>\n",
       "      <td>b'5'</td>\n",
       "      <td>b'08'</td>\n",
       "      <td>b'01'</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>b'U4430'</td>\n",
       "      <td>5620.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5620.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'2'</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     RN_INDI             RN_KEY MDCARE_STRT_DT FORM_CD MCARE_DESC_LN_NO  \\\n",
       "0  2682851.0  b'20060000000026'    b'20060104'   b'05'             b'1'   \n",
       "1  2682851.0  b'20060000000026'    b'20060104'   b'05'             b'3'   \n",
       "2  2682851.0  b'20060000000026'    b'20060104'   b'05'             b'2'   \n",
       "3  2682851.0  b'20060000000026'    b'20060104'   b'05'             b'4'   \n",
       "4  2682851.0  b'20060000000026'    b'20060104'   b'05'             b'5'   \n",
       "\n",
       "  CLA_CD ITEM_CD CLSF_PTTN_CD  MCARE_DIV_CD     UPRC  DD1_MQTY_FREQ  TOT_MCNT  \\\n",
       "0  b'01'   b'01'         b'1'      b'AA100'  10080.0            1.0       1.0   \n",
       "1  b'05'   b'01'         b'3'  b'314300BIJ'    356.0            1.0       1.0   \n",
       "2  b'01'   b'03'         b'1'      b'AL801'    160.0            1.0       1.0   \n",
       "3  b'05'   b'01'         b'1'      b'L0905'   3860.0            1.0       1.0   \n",
       "4  b'08'   b'01'         b'1'      b'U4430'   5620.0            1.0       1.0   \n",
       "\n",
       "       AMT  TIME1_MDCT_CPCT  MDCN_UD MCEXP_TYPE_CD EFMDC_CLSF_NO  \n",
       "0  10080.0              NaN      NaN          b'1'           NaN  \n",
       "1    356.0              NaN      NaN          b'3'        b'121'  \n",
       "2    160.0              NaN      NaN          b'1'           NaN  \n",
       "3   3860.0              NaN      NaN          b'2'           NaN  \n",
       "4   5620.0              NaN      NaN          b'2'           NaN  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "----- nsc2_edu_d40.sas7bdat -----\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 14278 entries, 0 to 14277\n",
      "Data columns (total 6 columns):\n",
      " #   Column          Non-Null Count  Dtype  \n",
      "---  ------          --------------  -----  \n",
      " 0   RN_INDI         14278 non-null  float64\n",
      " 1   RN_KEY          14278 non-null  object \n",
      " 2   MDCARE_STRT_DT  14278 non-null  object \n",
      " 3   FORM_CD         14278 non-null  object \n",
      " 4   MCEX_SICK_SYM   14278 non-null  object \n",
      " 5   SICK_CLSF_TYPE  11644 non-null  object \n",
      "dtypes: float64(1), object(5)\n",
      "memory usage: 669.4+ KB\n",
      "None\n",
      "\n",
      "Sample Data:\n"
     ]
    },
    {
     "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>RN_INDI</th>\n",
       "      <th>RN_KEY</th>\n",
       "      <th>MDCARE_STRT_DT</th>\n",
       "      <th>FORM_CD</th>\n",
       "      <th>MCEX_SICK_SYM</th>\n",
       "      <th>SICK_CLSF_TYPE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2682851.0</td>\n",
       "      <td>b'20060000000026'</td>\n",
       "      <td>b'20060104'</td>\n",
       "      <td>b'05'</td>\n",
       "      <td>b'K088'</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4455898.0</td>\n",
       "      <td>b'20060000000036'</td>\n",
       "      <td>b'20060126'</td>\n",
       "      <td>b'05'</td>\n",
       "      <td>b'K040'</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>7530085.0</td>\n",
       "      <td>b'20060000000089'</td>\n",
       "      <td>b'20060110'</td>\n",
       "      <td>b'05'</td>\n",
       "      <td>b'K050'</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>7530085.0</td>\n",
       "      <td>b'20060000000089'</td>\n",
       "      <td>b'20060110'</td>\n",
       "      <td>b'05'</td>\n",
       "      <td>b'K036'</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2043177.0</td>\n",
       "      <td>b'20060000000119'</td>\n",
       "      <td>b'20060120'</td>\n",
       "      <td>b'05'</td>\n",
       "      <td>b'K040'</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     RN_INDI             RN_KEY MDCARE_STRT_DT FORM_CD MCEX_SICK_SYM  \\\n",
       "0  2682851.0  b'20060000000026'    b'20060104'   b'05'       b'K088'   \n",
       "1  4455898.0  b'20060000000036'    b'20060126'   b'05'       b'K040'   \n",
       "2  7530085.0  b'20060000000089'    b'20060110'   b'05'       b'K050'   \n",
       "3  7530085.0  b'20060000000089'    b'20060110'   b'05'       b'K036'   \n",
       "4  2043177.0  b'20060000000119'    b'20060120'   b'05'       b'K040'   \n",
       "\n",
       "  SICK_CLSF_TYPE  \n",
       "0            NaN  \n",
       "1            NaN  \n",
       "2            NaN  \n",
       "3            NaN  \n",
       "4            NaN  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "----- nsc2_edu_d60.sas7bdat -----\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 8185 entries, 0 to 8184\n",
      "Data columns (total 13 columns):\n",
      " #   Column                  Non-Null Count  Dtype  \n",
      "---  ------                  --------------  -----  \n",
      " 0   RN_INDI                 8185 non-null   float64\n",
      " 1   RN_KEY                  8185 non-null   object \n",
      " 2   MDCARE_STRT_DT          8185 non-null   object \n",
      " 3   FORM_CD                 8185 non-null   object \n",
      " 4   MCARE_DESC_LN_NO        8185 non-null   object \n",
      " 5   CLSF_PTTN_CD            8185 non-null   object \n",
      " 6   MPRSC_TIME1_TUYAK_CPCT  8185 non-null   float64\n",
      " 7   MPRSC_DD1_TUYAK_CPCT    8185 non-null   float64\n",
      " 8   TOT_MCNT                8185 non-null   float64\n",
      " 9   UPRC                    8185 non-null   float64\n",
      " 10  AMT                     8185 non-null   float64\n",
      " 11  GNL_NM_CD               8185 non-null   object \n",
      " 12  EFMDC_CLSF_NO           8162 non-null   object \n",
      "dtypes: float64(6), object(7)\n",
      "memory usage: 831.4+ KB\n",
      "None\n",
      "\n",
      "Sample Data:\n"
     ]
    },
    {
     "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>RN_INDI</th>\n",
       "      <th>RN_KEY</th>\n",
       "      <th>MDCARE_STRT_DT</th>\n",
       "      <th>FORM_CD</th>\n",
       "      <th>MCARE_DESC_LN_NO</th>\n",
       "      <th>CLSF_PTTN_CD</th>\n",
       "      <th>MPRSC_TIME1_TUYAK_CPCT</th>\n",
       "      <th>MPRSC_DD1_TUYAK_CPCT</th>\n",
       "      <th>TOT_MCNT</th>\n",
       "      <th>UPRC</th>\n",
       "      <th>AMT</th>\n",
       "      <th>GNL_NM_CD</th>\n",
       "      <th>EFMDC_CLSF_NO</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2682851.0</td>\n",
       "      <td>b'20060000000026'</td>\n",
       "      <td>b'20060104'</td>\n",
       "      <td>b'05'</td>\n",
       "      <td>b'3'</td>\n",
       "      <td>b'3'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>198.0</td>\n",
       "      <td>594.0</td>\n",
       "      <td>b'186101ATB'</td>\n",
       "      <td>b'114'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2682851.0</td>\n",
       "      <td>b'20060000000026'</td>\n",
       "      <td>b'20060104'</td>\n",
       "      <td>b'05'</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>b'3'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>450.0</td>\n",
       "      <td>b'130101ACH'</td>\n",
       "      <td>b'618'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2682851.0</td>\n",
       "      <td>b'20060000000026'</td>\n",
       "      <td>b'20060104'</td>\n",
       "      <td>b'05'</td>\n",
       "      <td>b'4'</td>\n",
       "      <td>b'3'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>177.0</td>\n",
       "      <td>b'281300ATB'</td>\n",
       "      <td>b'234'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2682851.0</td>\n",
       "      <td>b'20060000000026'</td>\n",
       "      <td>b'20060104'</td>\n",
       "      <td>b'05'</td>\n",
       "      <td>b'2'</td>\n",
       "      <td>b'3'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>240.0</td>\n",
       "      <td>b'438901ATB'</td>\n",
       "      <td>b'395'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>7530085.0</td>\n",
       "      <td>b'20060000000089'</td>\n",
       "      <td>b'20060110'</td>\n",
       "      <td>b'05'</td>\n",
       "      <td>b'3'</td>\n",
       "      <td>b'3'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>855.0</td>\n",
       "      <td>b'108103ACH'</td>\n",
       "      <td>b'618'</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     RN_INDI             RN_KEY MDCARE_STRT_DT FORM_CD MCARE_DESC_LN_NO  \\\n",
       "0  2682851.0  b'20060000000026'    b'20060104'   b'05'             b'3'   \n",
       "1  2682851.0  b'20060000000026'    b'20060104'   b'05'             b'1'   \n",
       "2  2682851.0  b'20060000000026'    b'20060104'   b'05'             b'4'   \n",
       "3  2682851.0  b'20060000000026'    b'20060104'   b'05'             b'2'   \n",
       "4  7530085.0  b'20060000000089'    b'20060110'   b'05'             b'3'   \n",
       "\n",
       "  CLSF_PTTN_CD  MPRSC_TIME1_TUYAK_CPCT  MPRSC_DD1_TUYAK_CPCT  TOT_MCNT   UPRC  \\\n",
       "0         b'3'                     1.0                   3.0       1.0  198.0   \n",
       "1         b'3'                     1.0                   3.0       1.0  150.0   \n",
       "2         b'3'                     1.0                   3.0       1.0   59.0   \n",
       "3         b'3'                     1.0                   3.0       1.0   80.0   \n",
       "4         b'3'                     1.0                   3.0       3.0   95.0   \n",
       "\n",
       "     AMT     GNL_NM_CD EFMDC_CLSF_NO  \n",
       "0  594.0  b'186101ATB'        b'114'  \n",
       "1  450.0  b'130101ACH'        b'618'  \n",
       "2  177.0  b'281300ATB'        b'234'  \n",
       "3  240.0  b'438901ATB'        b'395'  \n",
       "4  855.0  b'108103ACH'        b'618'  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "----- nsc2_edu_g1e.sas7bdat -----\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 2496 entries, 0 to 2495\n",
      "Data columns (total 82 columns):\n",
      " #   Column               Non-Null Count  Dtype  \n",
      "---  ------               --------------  -----  \n",
      " 0   EXMD_BZ_YYYY         2496 non-null   object \n",
      " 1   RN_INDI              2496 non-null   float64\n",
      " 2   HME_YYYYMM           2496 non-null   object \n",
      " 3   Q_PHX1_DZ_V0208      220 non-null    float64\n",
      " 4   Q_PHX1_YR            153 non-null    float64\n",
      " 5   Q_PHX1_CR            200 non-null    float64\n",
      " 6   Q_PHX2_DZ_V0208      49 non-null     float64\n",
      " 7   Q_PHX2_YR            24 non-null     float64\n",
      " 8   Q_PHX2_CR            37 non-null     float64\n",
      " 9   Q_PHX3_DZ_V0208      19 non-null     float64\n",
      " 10  Q_PHX3_YR            4 non-null      float64\n",
      " 11  Q_PHX3_CR            7 non-null      float64\n",
      " 12  Q_FHX_LVDZ           998 non-null    float64\n",
      " 13  Q_FHX_HTN            1984 non-null   float64\n",
      " 14  Q_FHX_STK            1957 non-null   float64\n",
      " 15  Q_FHX_HTDZ           1959 non-null   float64\n",
      " 16  Q_FHX_DM             1970 non-null   float64\n",
      " 17  Q_FHX_CC             1004 non-null   float64\n",
      " 18  Q_AWR_YN             1029 non-null   float64\n",
      " 19  Q_AWR_DZ             196 non-null    object \n",
      " 20  Q_NTR_PRF            1041 non-null   float64\n",
      " 21  Q_DRK_FRQ_V0108      1045 non-null   float64\n",
      " 22  Q_DRK_AMT_V0108      521 non-null    float64\n",
      " 23  Q_SMK_YN             2440 non-null   float64\n",
      " 24  Q_SMK_NOW_AMT_V0108  262 non-null    float64\n",
      " 25  Q_SMK_DRT            341 non-null    float64\n",
      " 26  Q_SMK_STRT_YR        113 non-null    float64\n",
      " 27  Q_SMK_STOP_YR        38 non-null     float64\n",
      " 28  Q_PA_FRQ             1037 non-null   float64\n",
      " 29  G1E_HGHT             2494 non-null   float64\n",
      " 30  G1E_WGHT             2494 non-null   float64\n",
      " 31  G1E_BMI              2494 non-null   float64\n",
      " 32  G1E_WSTC             2002 non-null   float64\n",
      " 33  G1E_VA_LT            2495 non-null   float64\n",
      " 34  G1E_VA_RT            2495 non-null   float64\n",
      " 35  G1E_HA_LT            2495 non-null   float64\n",
      " 36  G1E_HA_RT            2495 non-null   float64\n",
      " 37  G1E_BP_SYS           2495 non-null   float64\n",
      " 38  G1E_BP_DIA           2495 non-null   float64\n",
      " 39  G1E_URN_GLU          1049 non-null   float64\n",
      " 40  G1E_URN_PROT         2483 non-null   float64\n",
      " 41  G1E_URN_OCC_BLD      1087 non-null   float64\n",
      " 42  G1E_URN_PH           1049 non-null   float64\n",
      " 43  G1E_HGB              2496 non-null   float64\n",
      " 44  G1E_FBS              2496 non-null   float64\n",
      " 45  G1E_TOT_CHOL         2494 non-null   float64\n",
      " 46  G1E_SGOT             2494 non-null   float64\n",
      " 47  G1E_SGPT             2494 non-null   float64\n",
      " 48  G1E_GGT              2496 non-null   float64\n",
      " 49  G1E_CHST_XRAY_RST    1763 non-null   float64\n",
      " 50  G1E_EKG_RST          666 non-null    float64\n",
      " 51  Q_PHX_DX_STK         929 non-null    float64\n",
      " 52  Q_PHX_DX_HTDZ        935 non-null    float64\n",
      " 53  Q_PHX_DX_HTN         990 non-null    float64\n",
      " 54  Q_PHX_DX_DM          947 non-null    float64\n",
      " 55  Q_PHX_DX_DLD         938 non-null    float64\n",
      " 56  Q_PHX_DX_PTB         932 non-null    float64\n",
      " 57  Q_PHX_DX_ETC         939 non-null    float64\n",
      " 58  Q_PHX_TX_STK         5 non-null      float64\n",
      " 59  Q_PHX_TX_HTDZ        26 non-null     float64\n",
      " 60  Q_PHX_TX_HTN         255 non-null    float64\n",
      " 61  Q_PHX_TX_DM          82 non-null     float64\n",
      " 62  Q_PHX_TX_DLD         34 non-null     float64\n",
      " 63  Q_PHX_TX_PTB         17 non-null     float64\n",
      " 64  Q_PHX_TX_ETC         95 non-null     float64\n",
      " 65  Q_FHX_ETC            965 non-null    float64\n",
      " 66  Q_HBV_AG             1402 non-null   float64\n",
      " 67  Q_SMK_PRE_DRT        194 non-null    float64\n",
      " 68  Q_SMK_PRE_AMT        193 non-null    float64\n",
      " 69  Q_SMK_NOW_DRT        334 non-null    float64\n",
      " 70  Q_SMK_NOW_AMT_V09N   333 non-null    float64\n",
      " 71  Q_DRK_FRQ_V09N       1401 non-null   float64\n",
      " 72  Q_DRK_AMT_V09N       843 non-null    float64\n",
      " 73  Q_PA_VD              1402 non-null   float64\n",
      " 74  Q_PA_MD              1400 non-null   float64\n",
      " 75  Q_PA_WALK            1402 non-null   float64\n",
      " 76  G1E_TG               1404 non-null   float64\n",
      " 77  G1E_HDL              1404 non-null   float64\n",
      " 78  G1E_LDL              1388 non-null   float64\n",
      " 79  G1E_CRTN             1404 non-null   float64\n",
      " 80  G1E_GFR              717 non-null    float64\n",
      " 81  G1E_GFR_MTHD         721 non-null    float64\n",
      "dtypes: float64(79), object(3)\n",
      "memory usage: 1.6+ MB\n",
      "None\n",
      "\n",
      "Sample Data:\n"
     ]
    },
    {
     "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>EXMD_BZ_YYYY</th>\n",
       "      <th>RN_INDI</th>\n",
       "      <th>HME_YYYYMM</th>\n",
       "      <th>Q_PHX1_DZ_V0208</th>\n",
       "      <th>Q_PHX1_YR</th>\n",
       "      <th>Q_PHX1_CR</th>\n",
       "      <th>Q_PHX2_DZ_V0208</th>\n",
       "      <th>Q_PHX2_YR</th>\n",
       "      <th>Q_PHX2_CR</th>\n",
       "      <th>Q_PHX3_DZ_V0208</th>\n",
       "      <th>...</th>\n",
       "      <th>Q_DRK_AMT_V09N</th>\n",
       "      <th>Q_PA_VD</th>\n",
       "      <th>Q_PA_MD</th>\n",
       "      <th>Q_PA_WALK</th>\n",
       "      <th>G1E_TG</th>\n",
       "      <th>G1E_HDL</th>\n",
       "      <th>G1E_LDL</th>\n",
       "      <th>G1E_CRTN</th>\n",
       "      <th>G1E_GFR</th>\n",
       "      <th>G1E_GFR_MTHD</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>b'2006'</td>\n",
       "      <td>7251920.0</td>\n",
       "      <td>b'200610'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>b'2006'</td>\n",
       "      <td>2539729.0</td>\n",
       "      <td>b'200602'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>b'2006'</td>\n",
       "      <td>1739352.0</td>\n",
       "      <td>b'200607'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>b'2006'</td>\n",
       "      <td>4847207.0</td>\n",
       "      <td>b'200611'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>b'2006'</td>\n",
       "      <td>3086124.0</td>\n",
       "      <td>b'200612'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 82 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  EXMD_BZ_YYYY    RN_INDI HME_YYYYMM  Q_PHX1_DZ_V0208  Q_PHX1_YR  Q_PHX1_CR  \\\n",
       "0      b'2006'  7251920.0  b'200610'              NaN        NaN        NaN   \n",
       "1      b'2006'  2539729.0  b'200602'              NaN        NaN        NaN   \n",
       "2      b'2006'  1739352.0  b'200607'              NaN        NaN        NaN   \n",
       "3      b'2006'  4847207.0  b'200611'              NaN        NaN        NaN   \n",
       "4      b'2006'  3086124.0  b'200612'              NaN        NaN        NaN   \n",
       "\n",
       "   Q_PHX2_DZ_V0208  Q_PHX2_YR  Q_PHX2_CR  Q_PHX3_DZ_V0208  ...  \\\n",
       "0              NaN        NaN        NaN              NaN  ...   \n",
       "1              NaN        NaN        NaN              NaN  ...   \n",
       "2              NaN        NaN        NaN              NaN  ...   \n",
       "3              NaN        NaN        NaN              NaN  ...   \n",
       "4              NaN        NaN        NaN              NaN  ...   \n",
       "\n",
       "   Q_DRK_AMT_V09N  Q_PA_VD  Q_PA_MD  Q_PA_WALK  G1E_TG  G1E_HDL  G1E_LDL  \\\n",
       "0             NaN      NaN      NaN        NaN     NaN      NaN      NaN   \n",
       "1             NaN      NaN      NaN        NaN     NaN      NaN      NaN   \n",
       "2             NaN      NaN      NaN        NaN     NaN      NaN      NaN   \n",
       "3             NaN      NaN      NaN        NaN     NaN      NaN      NaN   \n",
       "4             NaN      NaN      NaN        NaN     NaN      NaN      NaN   \n",
       "\n",
       "   G1E_CRTN  G1E_GFR G1E_GFR_MTHD  \n",
       "0       NaN      NaN          NaN  \n",
       "1       NaN      NaN          NaN  \n",
       "2       NaN      NaN          NaN  \n",
       "3       NaN      NaN          NaN  \n",
       "4       NaN      NaN          NaN  \n",
       "\n",
       "[5 rows x 82 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "----- nsc2_edu_inst.sas7bdat -----\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 61277 entries, 0 to 61276\n",
      "Data columns (total 10 columns):\n",
      " #   Column          Non-Null Count  Dtype  \n",
      "---  ------          --------------  -----  \n",
      " 0   STD_YYYY        61277 non-null  object \n",
      " 1   RN_INST         61277 non-null  float64\n",
      " 2   INST_CLSFC_CD   61277 non-null  object \n",
      " 3   SGG_INST        61277 non-null  object \n",
      " 4   DISP_SUBJ_TYPE  26797 non-null  object \n",
      " 5   CNT_DR_TOT      61277 non-null  float64\n",
      " 6   CNT_NRS_TOT     61277 non-null  float64\n",
      " 7   CNT_BED_INP     61277 non-null  float64\n",
      " 8   CNT_BED_OP      61277 non-null  float64\n",
      " 9   CNT_BED_ER      61277 non-null  float64\n",
      "dtypes: float64(6), object(4)\n",
      "memory usage: 4.7+ MB\n",
      "None\n",
      "\n",
      "Sample Data:\n"
     ]
    },
    {
     "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>STD_YYYY</th>\n",
       "      <th>RN_INST</th>\n",
       "      <th>INST_CLSFC_CD</th>\n",
       "      <th>SGG_INST</th>\n",
       "      <th>DISP_SUBJ_TYPE</th>\n",
       "      <th>CNT_DR_TOT</th>\n",
       "      <th>CNT_NRS_TOT</th>\n",
       "      <th>CNT_BED_INP</th>\n",
       "      <th>CNT_BED_OP</th>\n",
       "      <th>CNT_BED_ER</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>b'2006'</td>\n",
       "      <td>558084.0</td>\n",
       "      <td>b'5'</td>\n",
       "      <td>b'11680'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>b'2006'</td>\n",
       "      <td>239666.0</td>\n",
       "      <td>b'5'</td>\n",
       "      <td>b'11680'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>b'2006'</td>\n",
       "      <td>782883.0</td>\n",
       "      <td>b'5'</td>\n",
       "      <td>b'11680'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>b'2006'</td>\n",
       "      <td>493594.0</td>\n",
       "      <td>b'5'</td>\n",
       "      <td>b'11680'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>b'2006'</td>\n",
       "      <td>607428.0</td>\n",
       "      <td>b'5'</td>\n",
       "      <td>b'11680'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  STD_YYYY   RN_INST INST_CLSFC_CD  SGG_INST DISP_SUBJ_TYPE  CNT_DR_TOT  \\\n",
       "0  b'2006'  558084.0          b'5'  b'11680'            NaN         1.0   \n",
       "1  b'2006'  239666.0          b'5'  b'11680'            NaN         1.0   \n",
       "2  b'2006'  782883.0          b'5'  b'11680'            NaN         1.0   \n",
       "3  b'2006'  493594.0          b'5'  b'11680'            NaN         1.0   \n",
       "4  b'2006'  607428.0          b'5'  b'11680'            NaN         1.0   \n",
       "\n",
       "   CNT_NRS_TOT  CNT_BED_INP  CNT_BED_OP  CNT_BED_ER  \n",
       "0          0.0          0.0         0.0         0.0  \n",
       "1          0.0          0.0         0.0         0.0  \n",
       "2          0.0          0.0         0.0         0.0  \n",
       "3          0.0          0.0         0.0         0.0  \n",
       "4          0.0          0.0         0.0         0.0  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "----- nsc2_edu_k20.sas7bdat -----\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 18436 entries, 0 to 18435\n",
      "Data columns (total 16 columns):\n",
      " #   Column              Non-Null Count  Dtype  \n",
      "---  ------              --------------  -----  \n",
      " 0   RN_KEY              18436 non-null  object \n",
      " 1   RN_INDI             18436 non-null  float64\n",
      " 2   RN_INST             18436 non-null  float64\n",
      " 3   MDCARE_STRT_DT      18436 non-null  object \n",
      " 4   FORM_CD             18436 non-null  object \n",
      " 5   SICK_SYM1           18436 non-null  object \n",
      " 6   SICK_SYM2           3051 non-null   object \n",
      " 7   OPRTN_YN            18436 non-null  object \n",
      " 8   MDCARE_DD_CNT       18436 non-null  float64\n",
      " 9   VSHSP_DD_CNT        18436 non-null  float64\n",
      " 10  TOT_PRSC_DD_CNT     18436 non-null  float64\n",
      " 11  MCARE_RSLT_TYPE     18436 non-null  object \n",
      " 12  ED_RC_TOT_AMT       18436 non-null  float64\n",
      " 13  EDC_SBA             18436 non-null  float64\n",
      " 14  EDC_INSUR_BRDN_AMT  18436 non-null  float64\n",
      " 15  SPCF_SYM_TYPE       32 non-null     object \n",
      "dtypes: float64(8), object(8)\n",
      "memory usage: 2.3+ MB\n",
      "None\n",
      "\n",
      "Sample Data:\n"
     ]
    },
    {
     "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>RN_KEY</th>\n",
       "      <th>RN_INDI</th>\n",
       "      <th>RN_INST</th>\n",
       "      <th>MDCARE_STRT_DT</th>\n",
       "      <th>FORM_CD</th>\n",
       "      <th>SICK_SYM1</th>\n",
       "      <th>SICK_SYM2</th>\n",
       "      <th>OPRTN_YN</th>\n",
       "      <th>MDCARE_DD_CNT</th>\n",
       "      <th>VSHSP_DD_CNT</th>\n",
       "      <th>TOT_PRSC_DD_CNT</th>\n",
       "      <th>MCARE_RSLT_TYPE</th>\n",
       "      <th>ED_RC_TOT_AMT</th>\n",
       "      <th>EDC_SBA</th>\n",
       "      <th>EDC_INSUR_BRDN_AMT</th>\n",
       "      <th>SPCF_SYM_TYPE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>b'20060000000045'</td>\n",
       "      <td>3132955.0</td>\n",
       "      <td>535705.0</td>\n",
       "      <td>b'20060102'</td>\n",
       "      <td>b'13'</td>\n",
       "      <td>b'H1312'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>29720.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>26720.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>b'20060000000080'</td>\n",
       "      <td>4696743.0</td>\n",
       "      <td>602269.0</td>\n",
       "      <td>b'20060102'</td>\n",
       "      <td>b'13'</td>\n",
       "      <td>b'J_'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>29990.0</td>\n",
       "      <td>6000.0</td>\n",
       "      <td>23990.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>b'20060000000088'</td>\n",
       "      <td>8900742.0</td>\n",
       "      <td>745141.0</td>\n",
       "      <td>b'20060102'</td>\n",
       "      <td>b'13'</td>\n",
       "      <td>b'D687'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>44500.0</td>\n",
       "      <td>9000.0</td>\n",
       "      <td>35500.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>b'20060000000093'</td>\n",
       "      <td>8284698.0</td>\n",
       "      <td>944723.0</td>\n",
       "      <td>b'20060112'</td>\n",
       "      <td>b'13'</td>\n",
       "      <td>b'C042'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>29190.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>26190.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>b'20060000000105'</td>\n",
       "      <td>4197823.0</td>\n",
       "      <td>935712.0</td>\n",
       "      <td>b'20060104'</td>\n",
       "      <td>b'13'</td>\n",
       "      <td>b'K01'</td>\n",
       "      <td>b'K051'</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>18170.0</td>\n",
       "      <td>5450.0</td>\n",
       "      <td>12720.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              RN_KEY    RN_INDI   RN_INST MDCARE_STRT_DT FORM_CD SICK_SYM1  \\\n",
       "0  b'20060000000045'  3132955.0  535705.0    b'20060102'   b'13'  b'H1312'   \n",
       "1  b'20060000000080'  4696743.0  602269.0    b'20060102'   b'13'     b'J_'   \n",
       "2  b'20060000000088'  8900742.0  745141.0    b'20060102'   b'13'   b'D687'   \n",
       "3  b'20060000000093'  8284698.0  944723.0    b'20060112'   b'13'   b'C042'   \n",
       "4  b'20060000000105'  4197823.0  935712.0    b'20060104'   b'13'    b'K01'   \n",
       "\n",
       "  SICK_SYM2 OPRTN_YN  MDCARE_DD_CNT  VSHSP_DD_CNT  TOT_PRSC_DD_CNT  \\\n",
       "0       NaN     b'0'            2.0           2.0              0.0   \n",
       "1       NaN     b'0'            2.0           2.0              0.0   \n",
       "2       NaN     b'0'            3.0           3.0              0.0   \n",
       "3       NaN     b'0'            2.0           2.0              0.0   \n",
       "4   b'K051'     b'0'            1.0           1.0              0.0   \n",
       "\n",
       "  MCARE_RSLT_TYPE  ED_RC_TOT_AMT  EDC_SBA  EDC_INSUR_BRDN_AMT SPCF_SYM_TYPE  \n",
       "0            b'1'        29720.0   3000.0             26720.0           NaN  \n",
       "1            b'1'        29990.0   6000.0             23990.0           NaN  \n",
       "2            b'1'        44500.0   9000.0             35500.0           NaN  \n",
       "3            b'1'        29190.0   3000.0             26190.0           NaN  \n",
       "4            b'1'        18170.0   5450.0             12720.0           NaN  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "----- nsc2_edu_k30.sas7bdat -----\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 79999 entries, 0 to 79998\n",
      "Data columns (total 17 columns):\n",
      " #   Column            Non-Null Count  Dtype  \n",
      "---  ------            --------------  -----  \n",
      " 0   RN_INDI           79999 non-null  float64\n",
      " 1   RN_KEY            79999 non-null  object \n",
      " 2   MDCARE_STRT_DT    79999 non-null  object \n",
      " 3   FORM_CD           79999 non-null  object \n",
      " 4   MCARE_DESC_LN_NO  79999 non-null  object \n",
      " 5   CLA_CD            79999 non-null  object \n",
      " 6   ITEM_CD           79999 non-null  object \n",
      " 7   CLSF_PTTN_CD      79999 non-null  object \n",
      " 8   MCARE_DIV_CD      79999 non-null  object \n",
      " 9   UPRC              79999 non-null  float64\n",
      " 10  DD1_MQTY_FREQ     79999 non-null  float64\n",
      " 11  TOT_MCNT          79999 non-null  float64\n",
      " 12  AMT               79999 non-null  float64\n",
      " 13  TIME1_MDCT_CPCT   70140 non-null  float64\n",
      " 14  MDCN_UD           34287 non-null  float64\n",
      " 15  MCEXP_TYPE_CD     79999 non-null  object \n",
      " 16  EFMDC_CLSF_NO     0 non-null      object \n",
      "dtypes: float64(7), object(10)\n",
      "memory usage: 10.4+ MB\n",
      "None\n",
      "\n",
      "Sample Data:\n"
     ]
    },
    {
     "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>RN_INDI</th>\n",
       "      <th>RN_KEY</th>\n",
       "      <th>MDCARE_STRT_DT</th>\n",
       "      <th>FORM_CD</th>\n",
       "      <th>MCARE_DESC_LN_NO</th>\n",
       "      <th>CLA_CD</th>\n",
       "      <th>ITEM_CD</th>\n",
       "      <th>CLSF_PTTN_CD</th>\n",
       "      <th>MCARE_DIV_CD</th>\n",
       "      <th>UPRC</th>\n",
       "      <th>DD1_MQTY_FREQ</th>\n",
       "      <th>TOT_MCNT</th>\n",
       "      <th>AMT</th>\n",
       "      <th>TIME1_MDCT_CPCT</th>\n",
       "      <th>MDCN_UD</th>\n",
       "      <th>MCEXP_TYPE_CD</th>\n",
       "      <th>EFMDC_CLSF_NO</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3132955.0</td>\n",
       "      <td>b'20060000000045'</td>\n",
       "      <td>b'20060102'</td>\n",
       "      <td>b'13'</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>b'01'</td>\n",
       "      <td>b'02'</td>\n",
       "      <td>b'A'</td>\n",
       "      <td>b'10200'</td>\n",
       "      <td>5810.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>11620.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3132955.0</td>\n",
       "      <td>b'20060000000045'</td>\n",
       "      <td>b'20060102'</td>\n",
       "      <td>b'13'</td>\n",
       "      <td>b'4'</td>\n",
       "      <td>b'04'</td>\n",
       "      <td>b'02'</td>\n",
       "      <td>b'A'</td>\n",
       "      <td>b'40302'</td>\n",
       "      <td>1170.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2340.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'2'</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3132955.0</td>\n",
       "      <td>b'20060000000045'</td>\n",
       "      <td>b'20060102'</td>\n",
       "      <td>b'13'</td>\n",
       "      <td>b'2'</td>\n",
       "      <td>b'04'</td>\n",
       "      <td>b'01'</td>\n",
       "      <td>b'A'</td>\n",
       "      <td>b'40012'</td>\n",
       "      <td>3290.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>6580.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'2'</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3132955.0</td>\n",
       "      <td>b'20060000000045'</td>\n",
       "      <td>b'20060102'</td>\n",
       "      <td>b'13'</td>\n",
       "      <td>b'3'</td>\n",
       "      <td>b'04'</td>\n",
       "      <td>b'01'</td>\n",
       "      <td>b'A'</td>\n",
       "      <td>b'40060'</td>\n",
       "      <td>3410.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>6820.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'2'</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4696743.0</td>\n",
       "      <td>b'20060000000080'</td>\n",
       "      <td>b'20060102'</td>\n",
       "      <td>b'13'</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>b'01'</td>\n",
       "      <td>b'02'</td>\n",
       "      <td>b'A'</td>\n",
       "      <td>b'10200'</td>\n",
       "      <td>5810.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>11620.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     RN_INDI             RN_KEY MDCARE_STRT_DT FORM_CD MCARE_DESC_LN_NO  \\\n",
       "0  3132955.0  b'20060000000045'    b'20060102'   b'13'             b'1'   \n",
       "1  3132955.0  b'20060000000045'    b'20060102'   b'13'             b'4'   \n",
       "2  3132955.0  b'20060000000045'    b'20060102'   b'13'             b'2'   \n",
       "3  3132955.0  b'20060000000045'    b'20060102'   b'13'             b'3'   \n",
       "4  4696743.0  b'20060000000080'    b'20060102'   b'13'             b'1'   \n",
       "\n",
       "  CLA_CD ITEM_CD CLSF_PTTN_CD MCARE_DIV_CD    UPRC  DD1_MQTY_FREQ  TOT_MCNT  \\\n",
       "0  b'01'   b'02'         b'A'     b'10200'  5810.0            1.0       2.0   \n",
       "1  b'04'   b'02'         b'A'     b'40302'  1170.0            1.0       2.0   \n",
       "2  b'04'   b'01'         b'A'     b'40012'  3290.0            1.0       2.0   \n",
       "3  b'04'   b'01'         b'A'     b'40060'  3410.0            1.0       2.0   \n",
       "4  b'01'   b'02'         b'A'     b'10200'  5810.0            1.0       2.0   \n",
       "\n",
       "       AMT  TIME1_MDCT_CPCT  MDCN_UD MCEXP_TYPE_CD EFMDC_CLSF_NO  \n",
       "0  11620.0              NaN      NaN          b'1'           NaN  \n",
       "1   2340.0              NaN      NaN          b'2'           NaN  \n",
       "2   6580.0              NaN      NaN          b'2'           NaN  \n",
       "3   6820.0              NaN      NaN          b'2'           NaN  \n",
       "4  11620.0              NaN      NaN          b'1'           NaN  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "----- nsc2_edu_k40.sas7bdat -----\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 22317 entries, 0 to 22316\n",
      "Data columns (total 6 columns):\n",
      " #   Column          Non-Null Count  Dtype  \n",
      "---  ------          --------------  -----  \n",
      " 0   RN_INDI         22317 non-null  float64\n",
      " 1   RN_KEY          22317 non-null  object \n",
      " 2   MDCARE_STRT_DT  22317 non-null  object \n",
      " 3   FORM_CD         22317 non-null  object \n",
      " 4   MCEX_SICK_SYM   22317 non-null  object \n",
      " 5   SICK_CLSF_TYPE  19644 non-null  object \n",
      "dtypes: float64(1), object(5)\n",
      "memory usage: 1.0+ MB\n",
      "None\n",
      "\n",
      "Sample Data:\n"
     ]
    },
    {
     "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>RN_INDI</th>\n",
       "      <th>RN_KEY</th>\n",
       "      <th>MDCARE_STRT_DT</th>\n",
       "      <th>FORM_CD</th>\n",
       "      <th>MCEX_SICK_SYM</th>\n",
       "      <th>SICK_CLSF_TYPE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3132955.0</td>\n",
       "      <td>b'20060000000045'</td>\n",
       "      <td>b'20060102'</td>\n",
       "      <td>b'13'</td>\n",
       "      <td>b'H1312'</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4696743.0</td>\n",
       "      <td>b'20060000000080'</td>\n",
       "      <td>b'20060102'</td>\n",
       "      <td>b'13'</td>\n",
       "      <td>b'J_'</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>8900742.0</td>\n",
       "      <td>b'20060000000088'</td>\n",
       "      <td>b'20060102'</td>\n",
       "      <td>b'13'</td>\n",
       "      <td>b'D687'</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>8284698.0</td>\n",
       "      <td>b'20060000000093'</td>\n",
       "      <td>b'20060112'</td>\n",
       "      <td>b'13'</td>\n",
       "      <td>b'C042'</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4197823.0</td>\n",
       "      <td>b'20060000000105'</td>\n",
       "      <td>b'20060104'</td>\n",
       "      <td>b'13'</td>\n",
       "      <td>b'K051'</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     RN_INDI             RN_KEY MDCARE_STRT_DT FORM_CD MCEX_SICK_SYM  \\\n",
       "0  3132955.0  b'20060000000045'    b'20060102'   b'13'      b'H1312'   \n",
       "1  4696743.0  b'20060000000080'    b'20060102'   b'13'         b'J_'   \n",
       "2  8900742.0  b'20060000000088'    b'20060102'   b'13'       b'D687'   \n",
       "3  8284698.0  b'20060000000093'    b'20060112'   b'13'       b'C042'   \n",
       "4  4197823.0  b'20060000000105'    b'20060104'   b'13'       b'K051'   \n",
       "\n",
       "  SICK_CLSF_TYPE  \n",
       "0            NaN  \n",
       "1            NaN  \n",
       "2            NaN  \n",
       "3            NaN  \n",
       "4            NaN  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "----- nsc2_edu_m20.sas7bdat -----\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 137867 entries, 0 to 137866\n",
      "Data columns (total 16 columns):\n",
      " #   Column              Non-Null Count   Dtype  \n",
      "---  ------              --------------   -----  \n",
      " 0   RN_KEY              137867 non-null  object \n",
      " 1   RN_INDI             137867 non-null  float64\n",
      " 2   RN_INST             137867 non-null  float64\n",
      " 3   MDCARE_STRT_DT      137867 non-null  object \n",
      " 4   FORM_CD             137867 non-null  object \n",
      " 5   SICK_SYM1           137867 non-null  object \n",
      " 6   SICK_SYM2           93832 non-null   object \n",
      " 7   OPRTN_YN            137867 non-null  object \n",
      " 8   MDCARE_DD_CNT       137867 non-null  float64\n",
      " 9   VSHSP_DD_CNT        137867 non-null  float64\n",
      " 10  TOT_PRSC_DD_CNT     137867 non-null  float64\n",
      " 11  MCARE_RSLT_TYPE     133973 non-null  object \n",
      " 12  ED_RC_TOT_AMT       137867 non-null  float64\n",
      " 13  EDC_SBA             137867 non-null  float64\n",
      " 14  EDC_INSUR_BRDN_AMT  137867 non-null  float64\n",
      " 15  SPCF_SYM_TYPE       3150 non-null    object \n",
      "dtypes: float64(8), object(8)\n",
      "memory usage: 16.8+ MB\n",
      "None\n",
      "\n",
      "Sample Data:\n"
     ]
    },
    {
     "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>RN_KEY</th>\n",
       "      <th>RN_INDI</th>\n",
       "      <th>RN_INST</th>\n",
       "      <th>MDCARE_STRT_DT</th>\n",
       "      <th>FORM_CD</th>\n",
       "      <th>SICK_SYM1</th>\n",
       "      <th>SICK_SYM2</th>\n",
       "      <th>OPRTN_YN</th>\n",
       "      <th>MDCARE_DD_CNT</th>\n",
       "      <th>VSHSP_DD_CNT</th>\n",
       "      <th>TOT_PRSC_DD_CNT</th>\n",
       "      <th>MCARE_RSLT_TYPE</th>\n",
       "      <th>ED_RC_TOT_AMT</th>\n",
       "      <th>EDC_SBA</th>\n",
       "      <th>EDC_INSUR_BRDN_AMT</th>\n",
       "      <th>SPCF_SYM_TYPE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>b'20060000018543'</td>\n",
       "      <td>8535957.0</td>\n",
       "      <td>304175.0</td>\n",
       "      <td>b'20060515'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'D_'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>11120.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>8120.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>b'20060000021910'</td>\n",
       "      <td>1465659.0</td>\n",
       "      <td>681824.0</td>\n",
       "      <td>b'20060515'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'L20'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>11120.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>8120.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>b'20060000020587'</td>\n",
       "      <td>4612031.0</td>\n",
       "      <td>894625.0</td>\n",
       "      <td>b'20060504'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'J069'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>11120.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>8120.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>b'20060000016674'</td>\n",
       "      <td>1882994.0</td>\n",
       "      <td>269266.0</td>\n",
       "      <td>b'20060426'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'J02'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>11120.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>8120.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>b'20060000004810'</td>\n",
       "      <td>7307523.0</td>\n",
       "      <td>238926.0</td>\n",
       "      <td>b'20060206'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'J02'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>11120.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>8120.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              RN_KEY    RN_INDI   RN_INST MDCARE_STRT_DT FORM_CD SICK_SYM1  \\\n",
       "0  b'20060000018543'  8535957.0  304175.0    b'20060515'   b'03'     b'D_'   \n",
       "1  b'20060000021910'  1465659.0  681824.0    b'20060515'   b'03'    b'L20'   \n",
       "2  b'20060000020587'  4612031.0  894625.0    b'20060504'   b'03'   b'J069'   \n",
       "3  b'20060000016674'  1882994.0  269266.0    b'20060426'   b'03'    b'J02'   \n",
       "4  b'20060000004810'  7307523.0  238926.0    b'20060206'   b'03'    b'J02'   \n",
       "\n",
       "  SICK_SYM2 OPRTN_YN  MDCARE_DD_CNT  VSHSP_DD_CNT  TOT_PRSC_DD_CNT  \\\n",
       "0       NaN     b'0'            1.0           1.0              0.0   \n",
       "1       NaN     b'0'            1.0           1.0              3.0   \n",
       "2       NaN     b'0'            1.0           1.0              3.0   \n",
       "3       NaN     b'0'            1.0           1.0              3.0   \n",
       "4       NaN     b'0'            1.0           1.0              3.0   \n",
       "\n",
       "  MCARE_RSLT_TYPE  ED_RC_TOT_AMT  EDC_SBA  EDC_INSUR_BRDN_AMT SPCF_SYM_TYPE  \n",
       "0            b'1'        11120.0   3000.0              8120.0           NaN  \n",
       "1            b'1'        11120.0   3000.0              8120.0           NaN  \n",
       "2            b'1'        11120.0   3000.0              8120.0           NaN  \n",
       "3            b'1'        11120.0   3000.0              8120.0           NaN  \n",
       "4            b'1'        11120.0   3000.0              8120.0           NaN  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "----- nsc2_edu_m30.sas7bdat -----\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 658195 entries, 0 to 658194\n",
      "Data columns (total 17 columns):\n",
      " #   Column            Non-Null Count   Dtype  \n",
      "---  ------            --------------   -----  \n",
      " 0   RN_INDI           658195 non-null  float64\n",
      " 1   RN_KEY            658195 non-null  object \n",
      " 2   MDCARE_STRT_DT    658195 non-null  object \n",
      " 3   FORM_CD           658195 non-null  object \n",
      " 4   MCARE_DESC_LN_NO  658195 non-null  object \n",
      " 5   CLA_CD            658195 non-null  object \n",
      " 6   ITEM_CD           658195 non-null  object \n",
      " 7   CLSF_PTTN_CD      658195 non-null  object \n",
      " 8   MCARE_DIV_CD      658195 non-null  object \n",
      " 9   UPRC              658195 non-null  float64\n",
      " 10  DD1_MQTY_FREQ     658195 non-null  float64\n",
      " 11  TOT_MCNT          658195 non-null  float64\n",
      " 12  AMT               658195 non-null  float64\n",
      " 13  TIME1_MDCT_CPCT   533805 non-null  float64\n",
      " 14  MDCN_UD           247170 non-null  float64\n",
      " 15  MCEXP_TYPE_CD     658195 non-null  object \n",
      " 16  EFMDC_CLSF_NO     117759 non-null  object \n",
      "dtypes: float64(7), object(10)\n",
      "memory usage: 85.4+ MB\n",
      "None\n",
      "\n",
      "Sample Data:\n"
     ]
    },
    {
     "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>RN_INDI</th>\n",
       "      <th>RN_KEY</th>\n",
       "      <th>MDCARE_STRT_DT</th>\n",
       "      <th>FORM_CD</th>\n",
       "      <th>MCARE_DESC_LN_NO</th>\n",
       "      <th>CLA_CD</th>\n",
       "      <th>ITEM_CD</th>\n",
       "      <th>CLSF_PTTN_CD</th>\n",
       "      <th>MCARE_DIV_CD</th>\n",
       "      <th>UPRC</th>\n",
       "      <th>DD1_MQTY_FREQ</th>\n",
       "      <th>TOT_MCNT</th>\n",
       "      <th>AMT</th>\n",
       "      <th>TIME1_MDCT_CPCT</th>\n",
       "      <th>MDCN_UD</th>\n",
       "      <th>MCEXP_TYPE_CD</th>\n",
       "      <th>EFMDC_CLSF_NO</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3397751.0</td>\n",
       "      <td>b'20060000053279'</td>\n",
       "      <td>b'20061218'</td>\n",
       "      <td>b'02'</td>\n",
       "      <td>b'5'</td>\n",
       "      <td>b'W'</td>\n",
       "      <td>b'01'</td>\n",
       "      <td>b'8'</td>\n",
       "      <td>b'J4302035'</td>\n",
       "      <td>24710.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>24710.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'2'</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3397751.0</td>\n",
       "      <td>b'20060000027449'</td>\n",
       "      <td>b'20060624'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'5'</td>\n",
       "      <td>b'04'</td>\n",
       "      <td>b'01'</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>b'KK052'</td>\n",
       "      <td>1840.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1840.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'2'</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3397751.0</td>\n",
       "      <td>b'20060000050347'</td>\n",
       "      <td>b'20061106'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'5'</td>\n",
       "      <td>b'04'</td>\n",
       "      <td>b'01'</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>b'KK052'</td>\n",
       "      <td>1840.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1840.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'2'</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3397751.0</td>\n",
       "      <td>b'20060000034031'</td>\n",
       "      <td>b'20060826'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'5'</td>\n",
       "      <td>b'04'</td>\n",
       "      <td>b'01'</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>b'KK052'</td>\n",
       "      <td>1840.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1840.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'2'</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3397751.0</td>\n",
       "      <td>b'20060000043390'</td>\n",
       "      <td>b'20061018'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'7'</td>\n",
       "      <td>b'04'</td>\n",
       "      <td>b'01'</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>b'KK052'</td>\n",
       "      <td>1840.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1840.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'2'</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     RN_INDI             RN_KEY MDCARE_STRT_DT FORM_CD MCARE_DESC_LN_NO  \\\n",
       "0  3397751.0  b'20060000053279'    b'20061218'   b'02'             b'5'   \n",
       "1  3397751.0  b'20060000027449'    b'20060624'   b'03'             b'5'   \n",
       "2  3397751.0  b'20060000050347'    b'20061106'   b'03'             b'5'   \n",
       "3  3397751.0  b'20060000034031'    b'20060826'   b'03'             b'5'   \n",
       "4  3397751.0  b'20060000043390'    b'20061018'   b'03'             b'7'   \n",
       "\n",
       "  CLA_CD ITEM_CD CLSF_PTTN_CD MCARE_DIV_CD     UPRC  DD1_MQTY_FREQ  TOT_MCNT  \\\n",
       "0   b'W'   b'01'         b'8'  b'J4302035'  24710.0            1.0       1.0   \n",
       "1  b'04'   b'01'         b'1'     b'KK052'   1840.0            1.0       1.0   \n",
       "2  b'04'   b'01'         b'1'     b'KK052'   1840.0            1.0       1.0   \n",
       "3  b'04'   b'01'         b'1'     b'KK052'   1840.0            1.0       1.0   \n",
       "4  b'04'   b'01'         b'1'     b'KK052'   1840.0            1.0       1.0   \n",
       "\n",
       "       AMT  TIME1_MDCT_CPCT  MDCN_UD MCEXP_TYPE_CD EFMDC_CLSF_NO  \n",
       "0  24710.0              NaN      NaN          b'2'           NaN  \n",
       "1   1840.0              NaN      NaN          b'2'           NaN  \n",
       "2   1840.0              NaN      NaN          b'2'           NaN  \n",
       "3   1840.0              NaN      NaN          b'2'           NaN  \n",
       "4   1840.0              NaN      NaN          b'2'           NaN  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "----- nsc2_edu_m40.sas7bdat -----\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 346225 entries, 0 to 346224\n",
      "Data columns (total 6 columns):\n",
      " #   Column          Non-Null Count   Dtype  \n",
      "---  ------          --------------   -----  \n",
      " 0   RN_INDI         346225 non-null  float64\n",
      " 1   RN_KEY          346225 non-null  object \n",
      " 2   MDCARE_STRT_DT  346225 non-null  object \n",
      " 3   FORM_CD         346225 non-null  object \n",
      " 4   MCEX_SICK_SYM   346225 non-null  object \n",
      " 5   SICK_CLSF_TYPE  288185 non-null  object \n",
      "dtypes: float64(1), object(5)\n",
      "memory usage: 15.8+ MB\n",
      "None\n",
      "\n",
      "Sample Data:\n"
     ]
    },
    {
     "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>RN_INDI</th>\n",
       "      <th>RN_KEY</th>\n",
       "      <th>MDCARE_STRT_DT</th>\n",
       "      <th>FORM_CD</th>\n",
       "      <th>MCEX_SICK_SYM</th>\n",
       "      <th>SICK_CLSF_TYPE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>6921271.0</td>\n",
       "      <td>b'20060000043255'</td>\n",
       "      <td>b'20061002'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'I10'</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>6364824.0</td>\n",
       "      <td>b'20060000044346'</td>\n",
       "      <td>b'20061002'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'I10'</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>6468684.0</td>\n",
       "      <td>b'20060000043838'</td>\n",
       "      <td>b'20061002'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'I10'</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>6299458.0</td>\n",
       "      <td>b'20060000045834'</td>\n",
       "      <td>b'20061002'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'I10'</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>7167317.0</td>\n",
       "      <td>b'20060000042725'</td>\n",
       "      <td>b'20061002'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'I10'</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     RN_INDI             RN_KEY MDCARE_STRT_DT FORM_CD MCEX_SICK_SYM  \\\n",
       "0  6921271.0  b'20060000043255'    b'20061002'   b'03'        b'I10'   \n",
       "1  6364824.0  b'20060000044346'    b'20061002'   b'03'        b'I10'   \n",
       "2  6468684.0  b'20060000043838'    b'20061002'   b'03'        b'I10'   \n",
       "3  6299458.0  b'20060000045834'    b'20061002'   b'03'        b'I10'   \n",
       "4  7167317.0  b'20060000042725'    b'20061002'   b'03'        b'I10'   \n",
       "\n",
       "  SICK_CLSF_TYPE  \n",
       "0            NaN  \n",
       "1            NaN  \n",
       "2            NaN  \n",
       "3            NaN  \n",
       "4            NaN  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "----- nsc2_edu_m60.sas7bdat -----\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 421105 entries, 0 to 421104\n",
      "Data columns (total 13 columns):\n",
      " #   Column                  Non-Null Count   Dtype  \n",
      "---  ------                  --------------   -----  \n",
      " 0   RN_INDI                 421105 non-null  float64\n",
      " 1   RN_KEY                  421105 non-null  object \n",
      " 2   MDCARE_STRT_DT          421105 non-null  object \n",
      " 3   FORM_CD                 421105 non-null  object \n",
      " 4   MCARE_DESC_LN_NO        421105 non-null  object \n",
      " 5   CLSF_PTTN_CD            421105 non-null  object \n",
      " 6   MPRSC_TIME1_TUYAK_CPCT  421105 non-null  float64\n",
      " 7   MPRSC_DD1_TUYAK_CPCT    421105 non-null  float64\n",
      " 8   TOT_MCNT                421105 non-null  float64\n",
      " 9   UPRC                    421105 non-null  float64\n",
      " 10  AMT                     421105 non-null  float64\n",
      " 11  GNL_NM_CD               421096 non-null  object \n",
      " 12  EFMDC_CLSF_NO           420862 non-null  object \n",
      "dtypes: float64(6), object(7)\n",
      "memory usage: 41.8+ MB\n",
      "None\n",
      "\n",
      "Sample Data:\n"
     ]
    },
    {
     "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>RN_INDI</th>\n",
       "      <th>RN_KEY</th>\n",
       "      <th>MDCARE_STRT_DT</th>\n",
       "      <th>FORM_CD</th>\n",
       "      <th>MCARE_DESC_LN_NO</th>\n",
       "      <th>CLSF_PTTN_CD</th>\n",
       "      <th>MPRSC_TIME1_TUYAK_CPCT</th>\n",
       "      <th>MPRSC_DD1_TUYAK_CPCT</th>\n",
       "      <th>TOT_MCNT</th>\n",
       "      <th>UPRC</th>\n",
       "      <th>AMT</th>\n",
       "      <th>GNL_NM_CD</th>\n",
       "      <th>EFMDC_CLSF_NO</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>8953059.0</td>\n",
       "      <td>b'20060000043813'</td>\n",
       "      <td>b'20061014'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>b'3'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>270.0</td>\n",
       "      <td>b'268000ATB'</td>\n",
       "      <td>b'222'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>5607220.0</td>\n",
       "      <td>b'20060000052330'</td>\n",
       "      <td>b'20061211'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>b'3'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>270.0</td>\n",
       "      <td>b'268000ATB'</td>\n",
       "      <td>b'222'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2266688.0</td>\n",
       "      <td>b'20060000054336'</td>\n",
       "      <td>b'20061218'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>b'3'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>270.0</td>\n",
       "      <td>b'268000ATB'</td>\n",
       "      <td>b'222'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1633507.0</td>\n",
       "      <td>b'20060000012596'</td>\n",
       "      <td>b'20060321'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>b'3'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>270.0</td>\n",
       "      <td>b'268000ATB'</td>\n",
       "      <td>b'222'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5143201.0</td>\n",
       "      <td>b'20060000020142'</td>\n",
       "      <td>b'20060512'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>b'3'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>270.0</td>\n",
       "      <td>b'268000ATB'</td>\n",
       "      <td>b'222'</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     RN_INDI             RN_KEY MDCARE_STRT_DT FORM_CD MCARE_DESC_LN_NO  \\\n",
       "0  8953059.0  b'20060000043813'    b'20061014'   b'03'             b'1'   \n",
       "1  5607220.0  b'20060000052330'    b'20061211'   b'03'             b'1'   \n",
       "2  2266688.0  b'20060000054336'    b'20061218'   b'03'             b'1'   \n",
       "3  1633507.0  b'20060000012596'    b'20060321'   b'03'             b'1'   \n",
       "4  5143201.0  b'20060000020142'    b'20060512'   b'03'             b'1'   \n",
       "\n",
       "  CLSF_PTTN_CD  MPRSC_TIME1_TUYAK_CPCT  MPRSC_DD1_TUYAK_CPCT  TOT_MCNT  UPRC  \\\n",
       "0         b'3'                     1.0                   3.0       3.0  30.0   \n",
       "1         b'3'                     1.0                   3.0       3.0  30.0   \n",
       "2         b'3'                     1.0                   3.0       3.0  30.0   \n",
       "3         b'3'                     1.0                   3.0       3.0  30.0   \n",
       "4         b'3'                     1.0                   3.0       3.0  30.0   \n",
       "\n",
       "     AMT     GNL_NM_CD EFMDC_CLSF_NO  \n",
       "0  270.0  b'268000ATB'        b'222'  \n",
       "1  270.0  b'268000ATB'        b'222'  \n",
       "2  270.0  b'268000ATB'        b'222'  \n",
       "3  270.0  b'268000ATB'        b'222'  \n",
       "4  270.0  b'268000ATB'        b'222'  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "----- nsc2_edu_p20.sas7bdat -----\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 223098 entries, 0 to 223097\n",
      "Data columns (total 16 columns):\n",
      " #   Column              Non-Null Count   Dtype  \n",
      "---  ------              --------------   -----  \n",
      " 0   RN_KEY              223098 non-null  object \n",
      " 1   RN_INDI             223098 non-null  float64\n",
      " 2   RN_INST             223098 non-null  float64\n",
      " 3   MDCARE_STRT_DT      223098 non-null  object \n",
      " 4   FORM_CD             223098 non-null  object \n",
      " 5   SICK_SYM1           160057 non-null  object \n",
      " 6   SICK_SYM2           116477 non-null  object \n",
      " 7   OPRTN_YN            223098 non-null  object \n",
      " 8   MDCARE_DD_CNT       223098 non-null  float64\n",
      " 9   VSHSP_DD_CNT        223098 non-null  float64\n",
      " 10  TOT_PRSC_DD_CNT     223098 non-null  float64\n",
      " 11  MCARE_RSLT_TYPE     0 non-null       object \n",
      " 12  ED_RC_TOT_AMT       223098 non-null  float64\n",
      " 13  EDC_SBA             223098 non-null  float64\n",
      " 14  EDC_INSUR_BRDN_AMT  223098 non-null  float64\n",
      " 15  SPCF_SYM_TYPE       3011 non-null    object \n",
      "dtypes: float64(8), object(8)\n",
      "memory usage: 27.2+ MB\n",
      "None\n",
      "\n",
      "Sample Data:\n"
     ]
    },
    {
     "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>RN_KEY</th>\n",
       "      <th>RN_INDI</th>\n",
       "      <th>RN_INST</th>\n",
       "      <th>MDCARE_STRT_DT</th>\n",
       "      <th>FORM_CD</th>\n",
       "      <th>SICK_SYM1</th>\n",
       "      <th>SICK_SYM2</th>\n",
       "      <th>OPRTN_YN</th>\n",
       "      <th>MDCARE_DD_CNT</th>\n",
       "      <th>VSHSP_DD_CNT</th>\n",
       "      <th>TOT_PRSC_DD_CNT</th>\n",
       "      <th>MCARE_RSLT_TYPE</th>\n",
       "      <th>ED_RC_TOT_AMT</th>\n",
       "      <th>EDC_SBA</th>\n",
       "      <th>EDC_INSUR_BRDN_AMT</th>\n",
       "      <th>SPCF_SYM_TYPE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>b'20060000042181'</td>\n",
       "      <td>842016.0</td>\n",
       "      <td>690477.0</td>\n",
       "      <td>b'20061002'</td>\n",
       "      <td>b'21'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9190.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>7690.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>b'20060000042181'</td>\n",
       "      <td>8426705.0</td>\n",
       "      <td>690477.0</td>\n",
       "      <td>b'20061002'</td>\n",
       "      <td>b'21'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9190.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>7690.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>b'20060000043633'</td>\n",
       "      <td>460812.0</td>\n",
       "      <td>615453.0</td>\n",
       "      <td>b'20061002'</td>\n",
       "      <td>b'21'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9100.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>7600.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>b'20060000043633'</td>\n",
       "      <td>4917819.0</td>\n",
       "      <td>615453.0</td>\n",
       "      <td>b'20061002'</td>\n",
       "      <td>b'21'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9100.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>7600.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>b'20060000045417'</td>\n",
       "      <td>509343.0</td>\n",
       "      <td>756152.0</td>\n",
       "      <td>b'20061002'</td>\n",
       "      <td>b'21'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9600.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>8100.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              RN_KEY    RN_INDI   RN_INST MDCARE_STRT_DT FORM_CD SICK_SYM1  \\\n",
       "0  b'20060000042181'   842016.0  690477.0    b'20061002'   b'21'       NaN   \n",
       "1  b'20060000042181'  8426705.0  690477.0    b'20061002'   b'21'       NaN   \n",
       "2  b'20060000043633'   460812.0  615453.0    b'20061002'   b'21'       NaN   \n",
       "3  b'20060000043633'  4917819.0  615453.0    b'20061002'   b'21'       NaN   \n",
       "4  b'20060000045417'   509343.0  756152.0    b'20061002'   b'21'       NaN   \n",
       "\n",
       "  SICK_SYM2 OPRTN_YN  MDCARE_DD_CNT  VSHSP_DD_CNT  TOT_PRSC_DD_CNT  \\\n",
       "0       NaN     b'0'            3.0           1.0              3.0   \n",
       "1       NaN     b'0'            3.0           1.0              3.0   \n",
       "2       NaN     b'0'            3.0           1.0              3.0   \n",
       "3       NaN     b'0'            3.0           1.0              3.0   \n",
       "4       NaN     b'0'            3.0           1.0              3.0   \n",
       "\n",
       "  MCARE_RSLT_TYPE  ED_RC_TOT_AMT  EDC_SBA  EDC_INSUR_BRDN_AMT SPCF_SYM_TYPE  \n",
       "0             NaN         9190.0   1500.0              7690.0           NaN  \n",
       "1             NaN         9190.0   1500.0              7690.0           NaN  \n",
       "2             NaN         9100.0   1500.0              7600.0           NaN  \n",
       "3             NaN         9100.0   1500.0              7600.0           NaN  \n",
       "4             NaN         9600.0   1500.0              8100.0           NaN  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "----- nsc2_edu_p30.sas7bdat -----\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 1007097 entries, 0 to 1007096\n",
      "Data columns (total 17 columns):\n",
      " #   Column            Non-Null Count    Dtype  \n",
      "---  ------            --------------    -----  \n",
      " 0   RN_INDI           1007097 non-null  float64\n",
      " 1   RN_KEY            1007097 non-null  object \n",
      " 2   MDCARE_STRT_DT    1007097 non-null  object \n",
      " 3   FORM_CD           1007097 non-null  object \n",
      " 4   MCARE_DESC_LN_NO  1007097 non-null  object \n",
      " 5   CLA_CD            1007097 non-null  object \n",
      " 6   ITEM_CD           1007097 non-null  object \n",
      " 7   CLSF_PTTN_CD      1007097 non-null  object \n",
      " 8   MCARE_DIV_CD      1007097 non-null  object \n",
      " 9   UPRC              1007097 non-null  float64\n",
      " 10  DD1_MQTY_FREQ     1007097 non-null  float64\n",
      " 11  TOT_MCNT          1007097 non-null  float64\n",
      " 12  AMT               1007097 non-null  float64\n",
      " 13  TIME1_MDCT_CPCT   742051 non-null   float64\n",
      " 14  MDCN_UD           315923 non-null   float64\n",
      " 15  MCEXP_TYPE_CD     1007097 non-null  object \n",
      " 16  EFMDC_CLSF_NO     438871 non-null   object \n",
      "dtypes: float64(7), object(10)\n",
      "memory usage: 130.6+ MB\n",
      "None\n",
      "\n",
      "Sample Data:\n"
     ]
    },
    {
     "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>RN_INDI</th>\n",
       "      <th>RN_KEY</th>\n",
       "      <th>MDCARE_STRT_DT</th>\n",
       "      <th>FORM_CD</th>\n",
       "      <th>MCARE_DESC_LN_NO</th>\n",
       "      <th>CLA_CD</th>\n",
       "      <th>ITEM_CD</th>\n",
       "      <th>CLSF_PTTN_CD</th>\n",
       "      <th>MCARE_DIV_CD</th>\n",
       "      <th>UPRC</th>\n",
       "      <th>DD1_MQTY_FREQ</th>\n",
       "      <th>TOT_MCNT</th>\n",
       "      <th>AMT</th>\n",
       "      <th>TIME1_MDCT_CPCT</th>\n",
       "      <th>MDCN_UD</th>\n",
       "      <th>MCEXP_TYPE_CD</th>\n",
       "      <th>EFMDC_CLSF_NO</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>5741543.0</td>\n",
       "      <td>b'20060000043084'</td>\n",
       "      <td>b'20061002'</td>\n",
       "      <td>b'21'</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>b'02'</td>\n",
       "      <td>b'01'</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>b'Z1000'</td>\n",
       "      <td>680.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>680.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'2'</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>8457787.0</td>\n",
       "      <td>b'20060000044428'</td>\n",
       "      <td>b'20061002'</td>\n",
       "      <td>b'21'</td>\n",
       "      <td>b'5'</td>\n",
       "      <td>b'02'</td>\n",
       "      <td>b'01'</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>b'Z1000'</td>\n",
       "      <td>680.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>680.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'2'</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>5951350.0</td>\n",
       "      <td>b'20060000043150'</td>\n",
       "      <td>b'20061002'</td>\n",
       "      <td>b'21'</td>\n",
       "      <td>b'5'</td>\n",
       "      <td>b'02'</td>\n",
       "      <td>b'01'</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>b'Z1000'</td>\n",
       "      <td>680.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>680.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'2'</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>7251920.0</td>\n",
       "      <td>b'20060000046087'</td>\n",
       "      <td>b'20061002'</td>\n",
       "      <td>b'21'</td>\n",
       "      <td>b'5'</td>\n",
       "      <td>b'02'</td>\n",
       "      <td>b'01'</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>b'Z1000'</td>\n",
       "      <td>680.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>680.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'2'</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>7567284.0</td>\n",
       "      <td>b'20060000045512'</td>\n",
       "      <td>b'20061002'</td>\n",
       "      <td>b'21'</td>\n",
       "      <td>b'5'</td>\n",
       "      <td>b'02'</td>\n",
       "      <td>b'01'</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>b'Z1000'</td>\n",
       "      <td>680.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>680.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'2'</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     RN_INDI             RN_KEY MDCARE_STRT_DT FORM_CD MCARE_DESC_LN_NO  \\\n",
       "0  5741543.0  b'20060000043084'    b'20061002'   b'21'             b'1'   \n",
       "1  8457787.0  b'20060000044428'    b'20061002'   b'21'             b'5'   \n",
       "2  5951350.0  b'20060000043150'    b'20061002'   b'21'             b'5'   \n",
       "3  7251920.0  b'20060000046087'    b'20061002'   b'21'             b'5'   \n",
       "4  7567284.0  b'20060000045512'    b'20061002'   b'21'             b'5'   \n",
       "\n",
       "  CLA_CD ITEM_CD CLSF_PTTN_CD MCARE_DIV_CD   UPRC  DD1_MQTY_FREQ  TOT_MCNT  \\\n",
       "0  b'02'   b'01'         b'1'     b'Z1000'  680.0            1.0       1.0   \n",
       "1  b'02'   b'01'         b'1'     b'Z1000'  680.0            1.0       1.0   \n",
       "2  b'02'   b'01'         b'1'     b'Z1000'  680.0            1.0       1.0   \n",
       "3  b'02'   b'01'         b'1'     b'Z1000'  680.0            1.0       1.0   \n",
       "4  b'02'   b'01'         b'1'     b'Z1000'  680.0            1.0       1.0   \n",
       "\n",
       "     AMT  TIME1_MDCT_CPCT  MDCN_UD MCEXP_TYPE_CD EFMDC_CLSF_NO  \n",
       "0  680.0              NaN      NaN          b'2'           NaN  \n",
       "1  680.0              NaN      NaN          b'2'           NaN  \n",
       "2  680.0              NaN      NaN          b'2'           NaN  \n",
       "3  680.0              NaN      NaN          b'2'           NaN  \n",
       "4  680.0              NaN      NaN          b'2'           NaN  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "----- q2.sas7bdat -----\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 11840 entries, 0 to 11839\n",
      "Data columns (total 1 columns):\n",
      " #   Column  Non-Null Count  Dtype \n",
      "---  ------  --------------  ----- \n",
      " 0   SEX     11840 non-null  object\n",
      "dtypes: object(1)\n",
      "memory usage: 92.6+ KB\n",
      "None\n",
      "\n",
      "Sample Data:\n"
     ]
    },
    {
     "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>SEX</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>b'1'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>b'1'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>b'1'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>b'1'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>b'1'</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    SEX\n",
       "0  b'1'\n",
       "1  b'1'\n",
       "2  b'1'\n",
       "3  b'1'\n",
       "4  b'1'"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "----- q5.sas7bdat -----\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 0 entries\n",
      "Data columns (total 13 columns):\n",
      " #   Column                  Non-Null Count  Dtype  \n",
      "---  ------                  --------------  -----  \n",
      " 0   RN_INDI                 0 non-null      float64\n",
      " 1   RN_KEY                  0 non-null      object \n",
      " 2   MDCARE_STRT_DT          0 non-null      object \n",
      " 3   FORM_CD                 0 non-null      object \n",
      " 4   MCARE_DESC_LN_NO        0 non-null      object \n",
      " 5   CLSF_PTTN_CD            0 non-null      object \n",
      " 6   MPRSC_TIME1_TUYAK_CPCT  0 non-null      float64\n",
      " 7   MPRSC_DD1_TUYAK_CPCT    0 non-null      float64\n",
      " 8   TOT_MCNT                0 non-null      float64\n",
      " 9   UPRC                    0 non-null      float64\n",
      " 10  AMT                     0 non-null      float64\n",
      " 11  GNL_NM_CD               0 non-null      object \n",
      " 12  EFMDC_CLSF_NO           0 non-null      object \n",
      "dtypes: float64(6), object(7)\n",
      "memory usage: 124.0+ bytes\n",
      "None\n",
      "\n",
      "Sample Data:\n"
     ]
    },
    {
     "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>RN_INDI</th>\n",
       "      <th>RN_KEY</th>\n",
       "      <th>MDCARE_STRT_DT</th>\n",
       "      <th>FORM_CD</th>\n",
       "      <th>MCARE_DESC_LN_NO</th>\n",
       "      <th>CLSF_PTTN_CD</th>\n",
       "      <th>MPRSC_TIME1_TUYAK_CPCT</th>\n",
       "      <th>MPRSC_DD1_TUYAK_CPCT</th>\n",
       "      <th>TOT_MCNT</th>\n",
       "      <th>UPRC</th>\n",
       "      <th>AMT</th>\n",
       "      <th>GNL_NM_CD</th>\n",
       "      <th>EFMDC_CLSF_NO</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [RN_INDI, RN_KEY, MDCARE_STRT_DT, FORM_CD, MCARE_DESC_LN_NO, CLSF_PTTN_CD, MPRSC_TIME1_TUYAK_CPCT, MPRSC_DD1_TUYAK_CPCT, TOT_MCNT, UPRC, AMT, GNL_NM_CD, EFMDC_CLSF_NO]\n",
       "Index: []"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "----- q6.sas7bdat -----\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 552 entries, 0 to 551\n",
      "Data columns (total 25 columns):\n",
      " #   Column                  Non-Null Count  Dtype  \n",
      "---  ------                  --------------  -----  \n",
      " 0   RN_KEY                  552 non-null    object \n",
      " 1   RN_INDI                 552 non-null    float64\n",
      " 2   RN_INST                 552 non-null    float64\n",
      " 3   MDCARE_STRT_DT          552 non-null    object \n",
      " 4   FORM_CD                 552 non-null    object \n",
      " 5   SICK_SYM1               552 non-null    object \n",
      " 6   SICK_SYM2               390 non-null    object \n",
      " 7   OPRTN_YN                552 non-null    object \n",
      " 8   MDCARE_DD_CNT           552 non-null    float64\n",
      " 9   VSHSP_DD_CNT            552 non-null    float64\n",
      " 10  TOT_PRSC_DD_CNT         552 non-null    float64\n",
      " 11  MCARE_RSLT_TYPE         543 non-null    object \n",
      " 12  ED_RC_TOT_AMT           552 non-null    float64\n",
      " 13  EDC_SBA                 552 non-null    float64\n",
      " 14  EDC_INSUR_BRDN_AMT      552 non-null    float64\n",
      " 15  SPCF_SYM_TYPE           1 non-null      object \n",
      " 16  MCARE_DESC_LN_NO        552 non-null    object \n",
      " 17  CLSF_PTTN_CD            552 non-null    object \n",
      " 18  MPRSC_TIME1_TUYAK_CPCT  552 non-null    float64\n",
      " 19  MPRSC_DD1_TUYAK_CPCT    552 non-null    float64\n",
      " 20  TOT_MCNT                552 non-null    float64\n",
      " 21  UPRC                    552 non-null    float64\n",
      " 22  AMT                     552 non-null    float64\n",
      " 23  GNL_NM_CD               552 non-null    object \n",
      " 24  EFMDC_CLSF_NO           552 non-null    object \n",
      "dtypes: float64(13), object(12)\n",
      "memory usage: 107.9+ KB\n",
      "None\n",
      "\n",
      "Sample Data:\n"
     ]
    },
    {
     "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>RN_KEY</th>\n",
       "      <th>RN_INDI</th>\n",
       "      <th>RN_INST</th>\n",
       "      <th>MDCARE_STRT_DT</th>\n",
       "      <th>FORM_CD</th>\n",
       "      <th>SICK_SYM1</th>\n",
       "      <th>SICK_SYM2</th>\n",
       "      <th>OPRTN_YN</th>\n",
       "      <th>MDCARE_DD_CNT</th>\n",
       "      <th>VSHSP_DD_CNT</th>\n",
       "      <th>...</th>\n",
       "      <th>SPCF_SYM_TYPE</th>\n",
       "      <th>MCARE_DESC_LN_NO</th>\n",
       "      <th>CLSF_PTTN_CD</th>\n",
       "      <th>MPRSC_TIME1_TUYAK_CPCT</th>\n",
       "      <th>MPRSC_DD1_TUYAK_CPCT</th>\n",
       "      <th>TOT_MCNT</th>\n",
       "      <th>UPRC</th>\n",
       "      <th>AMT</th>\n",
       "      <th>GNL_NM_CD</th>\n",
       "      <th>EFMDC_CLSF_NO</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>b'20060000012105'</td>\n",
       "      <td>2220638.0</td>\n",
       "      <td>838172.0</td>\n",
       "      <td>b'20060331'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'H660'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>b'3'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>270.0</td>\n",
       "      <td>b'108101ACH'</td>\n",
       "      <td>b'618'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>b'20060000001046'</td>\n",
       "      <td>4063791.0</td>\n",
       "      <td>316004.0</td>\n",
       "      <td>b'20060109'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'O_'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'3'</td>\n",
       "      <td>b'3'</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>540.0</td>\n",
       "      <td>b'108101ACH'</td>\n",
       "      <td>b'618'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>b'20060000023127'</td>\n",
       "      <td>8314791.0</td>\n",
       "      <td>685243.0</td>\n",
       "      <td>b'20060517'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'H000'</td>\n",
       "      <td>b'H109'</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>b'3'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>270.0</td>\n",
       "      <td>b'108101ACH'</td>\n",
       "      <td>b'618'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>b'20060000019842'</td>\n",
       "      <td>8314791.0</td>\n",
       "      <td>685243.0</td>\n",
       "      <td>b'20060518'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'H000'</td>\n",
       "      <td>b'H109'</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>b'3'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>405.0</td>\n",
       "      <td>b'108101ACH'</td>\n",
       "      <td>b'618'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>b'20060000004117'</td>\n",
       "      <td>4154763.0</td>\n",
       "      <td>916357.0</td>\n",
       "      <td>b'20060126'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'J019'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'4'</td>\n",
       "      <td>b'3'</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>1350.0</td>\n",
       "      <td>b'108101ACH'</td>\n",
       "      <td>b'618'</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 25 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              RN_KEY    RN_INDI   RN_INST MDCARE_STRT_DT FORM_CD SICK_SYM1  \\\n",
       "0  b'20060000012105'  2220638.0  838172.0    b'20060331'   b'03'   b'H660'   \n",
       "1  b'20060000001046'  4063791.0  316004.0    b'20060109'   b'03'     b'O_'   \n",
       "2  b'20060000023127'  8314791.0  685243.0    b'20060517'   b'03'   b'H000'   \n",
       "3  b'20060000019842'  8314791.0  685243.0    b'20060518'   b'03'   b'H000'   \n",
       "4  b'20060000004117'  4154763.0  916357.0    b'20060126'   b'03'   b'J019'   \n",
       "\n",
       "  SICK_SYM2 OPRTN_YN  MDCARE_DD_CNT  VSHSP_DD_CNT  ...  SPCF_SYM_TYPE  \\\n",
       "0       NaN     b'0'            1.0           1.0  ...            NaN   \n",
       "1       NaN     b'0'            1.0           1.0  ...            NaN   \n",
       "2   b'H109'     b'0'            1.0           1.0  ...            NaN   \n",
       "3   b'H109'     b'0'            2.0           2.0  ...            NaN   \n",
       "4       NaN     b'0'            1.0           1.0  ...            NaN   \n",
       "\n",
       "  MCARE_DESC_LN_NO  CLSF_PTTN_CD  MPRSC_TIME1_TUYAK_CPCT  \\\n",
       "0             b'1'          b'3'                     1.0   \n",
       "1             b'3'          b'3'                     2.0   \n",
       "2             b'1'          b'3'                     1.0   \n",
       "3             b'1'          b'3'                     1.0   \n",
       "4             b'4'          b'3'                     2.0   \n",
       "\n",
       "   MPRSC_DD1_TUYAK_CPCT TOT_MCNT  UPRC     AMT     GNL_NM_CD  EFMDC_CLSF_NO  \n",
       "0                   3.0      2.0  45.0   270.0  b'108101ACH'         b'618'  \n",
       "1                   3.0      2.0  45.0   540.0  b'108101ACH'         b'618'  \n",
       "2                   3.0      2.0  45.0   270.0  b'108101ACH'         b'618'  \n",
       "3                   3.0      3.0  45.0   405.0  b'108101ACH'         b'618'  \n",
       "4                   3.0      5.0  45.0  1350.0  b'108101ACH'         b'618'  \n",
       "\n",
       "[5 rows x 25 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "----- q7.sas7bdat -----\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 3086 entries, 0 to 3085\n",
      "Data columns (total 16 columns):\n",
      " #   Column              Non-Null Count  Dtype  \n",
      "---  ------              --------------  -----  \n",
      " 0   RN_KEY              3086 non-null   object \n",
      " 1   RN_INDI             3086 non-null   float64\n",
      " 2   RN_INST             3086 non-null   float64\n",
      " 3   MDCARE_STRT_DT      3086 non-null   object \n",
      " 4   FORM_CD             3086 non-null   object \n",
      " 5   SICK_SYM1           3086 non-null   object \n",
      " 6   SICK_SYM2           2512 non-null   object \n",
      " 7   OPRTN_YN            3086 non-null   object \n",
      " 8   MDCARE_DD_CNT       3086 non-null   float64\n",
      " 9   VSHSP_DD_CNT        3086 non-null   float64\n",
      " 10  TOT_PRSC_DD_CNT     3086 non-null   float64\n",
      " 11  MCARE_RSLT_TYPE     2954 non-null   object \n",
      " 12  ED_RC_TOT_AMT       3086 non-null   float64\n",
      " 13  EDC_SBA             3086 non-null   float64\n",
      " 14  EDC_INSUR_BRDN_AMT  3086 non-null   float64\n",
      " 15  SPCF_SYM_TYPE       36 non-null     object \n",
      "dtypes: float64(8), object(8)\n",
      "memory usage: 385.9+ KB\n",
      "None\n",
      "\n",
      "Sample Data:\n"
     ]
    },
    {
     "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>RN_KEY</th>\n",
       "      <th>RN_INDI</th>\n",
       "      <th>RN_INST</th>\n",
       "      <th>MDCARE_STRT_DT</th>\n",
       "      <th>FORM_CD</th>\n",
       "      <th>SICK_SYM1</th>\n",
       "      <th>SICK_SYM2</th>\n",
       "      <th>OPRTN_YN</th>\n",
       "      <th>MDCARE_DD_CNT</th>\n",
       "      <th>VSHSP_DD_CNT</th>\n",
       "      <th>TOT_PRSC_DD_CNT</th>\n",
       "      <th>MCARE_RSLT_TYPE</th>\n",
       "      <th>ED_RC_TOT_AMT</th>\n",
       "      <th>EDC_SBA</th>\n",
       "      <th>EDC_INSUR_BRDN_AMT</th>\n",
       "      <th>SPCF_SYM_TYPE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>b'20060000022525'</td>\n",
       "      <td>8533978.0</td>\n",
       "      <td>734183.0</td>\n",
       "      <td>b'20060522'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'E117'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>10350.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>8850.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>b'20060000020557'</td>\n",
       "      <td>3154615.0</td>\n",
       "      <td>792817.0</td>\n",
       "      <td>b'20060512'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'E11'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>10350.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>7350.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>b'20060000014266'</td>\n",
       "      <td>6757847.0</td>\n",
       "      <td>386025.0</td>\n",
       "      <td>b'20060401'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'E11'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>21030.0</td>\n",
       "      <td>6000.0</td>\n",
       "      <td>15030.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>b'20060000020185'</td>\n",
       "      <td>2576841.0</td>\n",
       "      <td>624836.0</td>\n",
       "      <td>b'20060512'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'E114'</td>\n",
       "      <td>b'E115'</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>10350.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>8850.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>b'20060000015455'</td>\n",
       "      <td>2576841.0</td>\n",
       "      <td>624836.0</td>\n",
       "      <td>b'20060407'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'E114'</td>\n",
       "      <td>b'E115'</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>10350.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>8850.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              RN_KEY    RN_INDI   RN_INST MDCARE_STRT_DT FORM_CD SICK_SYM1  \\\n",
       "0  b'20060000022525'  8533978.0  734183.0    b'20060522'   b'03'   b'E117'   \n",
       "1  b'20060000020557'  3154615.0  792817.0    b'20060512'   b'03'    b'E11'   \n",
       "2  b'20060000014266'  6757847.0  386025.0    b'20060401'   b'03'    b'E11'   \n",
       "3  b'20060000020185'  2576841.0  624836.0    b'20060512'   b'03'   b'E114'   \n",
       "4  b'20060000015455'  2576841.0  624836.0    b'20060407'   b'03'   b'E114'   \n",
       "\n",
       "  SICK_SYM2 OPRTN_YN  MDCARE_DD_CNT  VSHSP_DD_CNT  TOT_PRSC_DD_CNT  \\\n",
       "0       NaN     b'0'            1.0           1.0             30.0   \n",
       "1       NaN     b'0'            1.0           1.0             30.0   \n",
       "2       NaN     b'0'            2.0           2.0             25.0   \n",
       "3   b'E115'     b'0'            1.0           1.0             30.0   \n",
       "4   b'E115'     b'0'            1.0           1.0             30.0   \n",
       "\n",
       "  MCARE_RSLT_TYPE  ED_RC_TOT_AMT  EDC_SBA  EDC_INSUR_BRDN_AMT SPCF_SYM_TYPE  \n",
       "0            b'1'        10350.0   1500.0              8850.0           NaN  \n",
       "1            b'1'        10350.0   3000.0              7350.0           NaN  \n",
       "2            b'1'        21030.0   6000.0             15030.0           NaN  \n",
       "3            b'1'        10350.0   1500.0              8850.0           NaN  \n",
       "4            b'1'        10350.0   1500.0              8850.0           NaN  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "----- q7_1.sas7bdat -----\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 3086 entries, 0 to 3085\n",
      "Data columns (total 16 columns):\n",
      " #   Column              Non-Null Count  Dtype  \n",
      "---  ------              --------------  -----  \n",
      " 0   RN_KEY              3086 non-null   object \n",
      " 1   RN_INDI             3086 non-null   float64\n",
      " 2   RN_INST             3086 non-null   float64\n",
      " 3   MDCARE_STRT_DT      3086 non-null   object \n",
      " 4   FORM_CD             3086 non-null   object \n",
      " 5   SICK_SYM1           3086 non-null   object \n",
      " 6   SICK_SYM2           2512 non-null   object \n",
      " 7   OPRTN_YN            3086 non-null   object \n",
      " 8   MDCARE_DD_CNT       3086 non-null   float64\n",
      " 9   VSHSP_DD_CNT        3086 non-null   float64\n",
      " 10  TOT_PRSC_DD_CNT     3086 non-null   float64\n",
      " 11  MCARE_RSLT_TYPE     2954 non-null   object \n",
      " 12  ED_RC_TOT_AMT       3086 non-null   float64\n",
      " 13  EDC_SBA             3086 non-null   float64\n",
      " 14  EDC_INSUR_BRDN_AMT  3086 non-null   float64\n",
      " 15  SPCF_SYM_TYPE       36 non-null     object \n",
      "dtypes: float64(8), object(8)\n",
      "memory usage: 385.9+ KB\n",
      "None\n",
      "\n",
      "Sample Data:\n"
     ]
    },
    {
     "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>RN_KEY</th>\n",
       "      <th>RN_INDI</th>\n",
       "      <th>RN_INST</th>\n",
       "      <th>MDCARE_STRT_DT</th>\n",
       "      <th>FORM_CD</th>\n",
       "      <th>SICK_SYM1</th>\n",
       "      <th>SICK_SYM2</th>\n",
       "      <th>OPRTN_YN</th>\n",
       "      <th>MDCARE_DD_CNT</th>\n",
       "      <th>VSHSP_DD_CNT</th>\n",
       "      <th>TOT_PRSC_DD_CNT</th>\n",
       "      <th>MCARE_RSLT_TYPE</th>\n",
       "      <th>ED_RC_TOT_AMT</th>\n",
       "      <th>EDC_SBA</th>\n",
       "      <th>EDC_INSUR_BRDN_AMT</th>\n",
       "      <th>SPCF_SYM_TYPE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>b'20060000000115'</td>\n",
       "      <td>1698705.0</td>\n",
       "      <td>517394.0</td>\n",
       "      <td>b'20060131'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'E114'</td>\n",
       "      <td>b'I11'</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>10350.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>8850.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>b'20060000000197'</td>\n",
       "      <td>5259114.0</td>\n",
       "      <td>882372.0</td>\n",
       "      <td>b'20060131'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'E11'</td>\n",
       "      <td>b'K599'</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>69690.0</td>\n",
       "      <td>27870.0</td>\n",
       "      <td>41820.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>b'20060000000270'</td>\n",
       "      <td>2012004.0</td>\n",
       "      <td>383686.0</td>\n",
       "      <td>b'20060113'</td>\n",
       "      <td>b'08'</td>\n",
       "      <td>b'E11'</td>\n",
       "      <td>b'F_'</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3850.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3850.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>b'20060000000331'</td>\n",
       "      <td>8875293.0</td>\n",
       "      <td>578878.0</td>\n",
       "      <td>b'20060103'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'E11'</td>\n",
       "      <td>b'K29'</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>9990.0</td>\n",
       "      <td>3990.0</td>\n",
       "      <td>6000.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>b'20060000000335'</td>\n",
       "      <td>6381614.0</td>\n",
       "      <td>504244.0</td>\n",
       "      <td>b'20060113'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'E114'</td>\n",
       "      <td>b'I10'</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>20.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>63180.0</td>\n",
       "      <td>39200.0</td>\n",
       "      <td>23980.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              RN_KEY    RN_INDI   RN_INST MDCARE_STRT_DT FORM_CD SICK_SYM1  \\\n",
       "0  b'20060000000115'  1698705.0  517394.0    b'20060131'   b'03'   b'E114'   \n",
       "1  b'20060000000197'  5259114.0  882372.0    b'20060131'   b'03'    b'E11'   \n",
       "2  b'20060000000270'  2012004.0  383686.0    b'20060113'   b'08'    b'E11'   \n",
       "3  b'20060000000331'  8875293.0  578878.0    b'20060103'   b'03'    b'E11'   \n",
       "4  b'20060000000335'  6381614.0  504244.0    b'20060113'   b'03'   b'E114'   \n",
       "\n",
       "  SICK_SYM2 OPRTN_YN  MDCARE_DD_CNT  VSHSP_DD_CNT  TOT_PRSC_DD_CNT  \\\n",
       "0    b'I11'     b'0'            1.0           1.0             30.0   \n",
       "1   b'K599'     b'0'            1.0           1.0             14.0   \n",
       "2     b'F_'     b'0'            1.0           1.0             30.0   \n",
       "3    b'K29'     b'0'            1.0           1.0             28.0   \n",
       "4    b'I10'     b'0'           20.0           1.0             30.0   \n",
       "\n",
       "  MCARE_RSLT_TYPE  ED_RC_TOT_AMT  EDC_SBA  EDC_INSUR_BRDN_AMT SPCF_SYM_TYPE  \n",
       "0            b'1'        10350.0   1500.0              8850.0           NaN  \n",
       "1            b'1'        69690.0  27870.0             41820.0           NaN  \n",
       "2             NaN         3850.0      0.0              3850.0           NaN  \n",
       "3            b'1'         9990.0   3990.0              6000.0           NaN  \n",
       "4            b'1'        63180.0  39200.0             23980.0           NaN  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "----- q7_2.sas7bdat -----\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 212 entries, 0 to 211\n",
      "Data columns (total 16 columns):\n",
      " #   Column              Non-Null Count  Dtype  \n",
      "---  ------              --------------  -----  \n",
      " 0   RN_KEY              212 non-null    object \n",
      " 1   RN_INDI             212 non-null    float64\n",
      " 2   RN_INST             212 non-null    float64\n",
      " 3   MDCARE_STRT_DT      212 non-null    object \n",
      " 4   FORM_CD             212 non-null    object \n",
      " 5   SICK_SYM1           212 non-null    object \n",
      " 6   SICK_SYM2           149 non-null    object \n",
      " 7   OPRTN_YN            212 non-null    object \n",
      " 8   MDCARE_DD_CNT       212 non-null    float64\n",
      " 9   VSHSP_DD_CNT        212 non-null    float64\n",
      " 10  TOT_PRSC_DD_CNT     212 non-null    float64\n",
      " 11  MCARE_RSLT_TYPE     202 non-null    object \n",
      " 12  ED_RC_TOT_AMT       212 non-null    float64\n",
      " 13  EDC_SBA             212 non-null    float64\n",
      " 14  EDC_INSUR_BRDN_AMT  212 non-null    float64\n",
      " 15  SPCF_SYM_TYPE       1 non-null      object \n",
      "dtypes: float64(8), object(8)\n",
      "memory usage: 26.6+ KB\n",
      "None\n",
      "\n",
      "Sample Data:\n"
     ]
    },
    {
     "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>RN_KEY</th>\n",
       "      <th>RN_INDI</th>\n",
       "      <th>RN_INST</th>\n",
       "      <th>MDCARE_STRT_DT</th>\n",
       "      <th>FORM_CD</th>\n",
       "      <th>SICK_SYM1</th>\n",
       "      <th>SICK_SYM2</th>\n",
       "      <th>OPRTN_YN</th>\n",
       "      <th>MDCARE_DD_CNT</th>\n",
       "      <th>VSHSP_DD_CNT</th>\n",
       "      <th>TOT_PRSC_DD_CNT</th>\n",
       "      <th>MCARE_RSLT_TYPE</th>\n",
       "      <th>ED_RC_TOT_AMT</th>\n",
       "      <th>EDC_SBA</th>\n",
       "      <th>EDC_INSUR_BRDN_AMT</th>\n",
       "      <th>SPCF_SYM_TYPE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>b'20060000002516'</td>\n",
       "      <td>1049401.0</td>\n",
       "      <td>503221.0</td>\n",
       "      <td>b'20060119'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'E119'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>10410.0</td>\n",
       "      <td>5200.0</td>\n",
       "      <td>5210.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>b'20120000034332'</td>\n",
       "      <td>1079876.0</td>\n",
       "      <td>915828.0</td>\n",
       "      <td>b'20120615'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'E119'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>11890.0</td>\n",
       "      <td>3500.0</td>\n",
       "      <td>8390.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>b'20120000035309'</td>\n",
       "      <td>1162366.0</td>\n",
       "      <td>573214.0</td>\n",
       "      <td>b'20120621'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'E119'</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>12610.0</td>\n",
       "      <td>6300.0</td>\n",
       "      <td>6310.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>b'20060000012097'</td>\n",
       "      <td>1174796.0</td>\n",
       "      <td>452880.0</td>\n",
       "      <td>b'20060324'</td>\n",
       "      <td>b'02'</td>\n",
       "      <td>b'E11'</td>\n",
       "      <td>b'I110'</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>43.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>b'9'</td>\n",
       "      <td>742960.0</td>\n",
       "      <td>148590.0</td>\n",
       "      <td>594370.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>b'20060000015829'</td>\n",
       "      <td>1234482.0</td>\n",
       "      <td>640561.0</td>\n",
       "      <td>b'20060414'</td>\n",
       "      <td>b'03'</td>\n",
       "      <td>b'E11'</td>\n",
       "      <td>b'I10'</td>\n",
       "      <td>b'0'</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>b'1'</td>\n",
       "      <td>10350.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>8850.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              RN_KEY    RN_INDI   RN_INST MDCARE_STRT_DT FORM_CD SICK_SYM1  \\\n",
       "0  b'20060000002516'  1049401.0  503221.0    b'20060119'   b'03'   b'E119'   \n",
       "1  b'20120000034332'  1079876.0  915828.0    b'20120615'   b'03'   b'E119'   \n",
       "2  b'20120000035309'  1162366.0  573214.0    b'20120621'   b'03'   b'E119'   \n",
       "3  b'20060000012097'  1174796.0  452880.0    b'20060324'   b'02'    b'E11'   \n",
       "4  b'20060000015829'  1234482.0  640561.0    b'20060414'   b'03'    b'E11'   \n",
       "\n",
       "  SICK_SYM2 OPRTN_YN  MDCARE_DD_CNT  VSHSP_DD_CNT  TOT_PRSC_DD_CNT  \\\n",
       "0       NaN     b'0'            1.0           1.0             30.0   \n",
       "1       NaN     b'0'            1.0           1.0              0.0   \n",
       "2       NaN     b'0'            1.0           1.0              0.0   \n",
       "3   b'I110'     b'0'           43.0          13.0              0.0   \n",
       "4    b'I10'     b'0'            1.0           1.0             30.0   \n",
       "\n",
       "  MCARE_RSLT_TYPE  ED_RC_TOT_AMT   EDC_SBA  EDC_INSUR_BRDN_AMT SPCF_SYM_TYPE  \n",
       "0            b'1'        10410.0    5200.0              5210.0           NaN  \n",
       "1            b'1'        11890.0    3500.0              8390.0           NaN  \n",
       "2            b'1'        12610.0    6300.0              6310.0           NaN  \n",
       "3            b'9'       742960.0  148590.0            594370.0           NaN  \n",
       "4            b'1'        10350.0    1500.0              8850.0           NaN  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "import os\n",
    "import pandas as pd\n",
    "\n",
    "data_dir = \".\\data\"\n",
    "\n",
    "data_files = [f for f in os.listdir(data_dir) if f.endswith(\".sas7bdat\")]\n",
    "\n",
    "dataframes = {file: pd.read_sas(os.path.join(data_dir, file)) for file in data_files}\n",
    "\n",
    "for file, df in dataframes.items():\n",
    "    print(f\"\\n----- {file} -----\")\n",
    "    print(df.info())\n",
    "    print(\"\\nSample Data:\")\n",
    "    display(df.head())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "----- nsc2_edu_m20.sas7bdat Info -----\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 137867 entries, 0 to 137866\n",
      "Data columns (total 16 columns):\n",
      " #   Column              Non-Null Count   Dtype  \n",
      "---  ------              --------------   -----  \n",
      " 0   RN_KEY              137867 non-null  object \n",
      " 1   RN_INDI             137867 non-null  float64\n",
      " 2   RN_INST             137867 non-null  float64\n",
      " 3   MDCARE_STRT_DT      137867 non-null  object \n",
      " 4   FORM_CD             137867 non-null  object \n",
      " 5   SICK_SYM1           137867 non-null  object \n",
      " 6   SICK_SYM2           93832 non-null   object \n",
      " 7   OPRTN_YN            137867 non-null  object \n",
      " 8   MDCARE_DD_CNT       137867 non-null  float64\n",
      " 9   VSHSP_DD_CNT        137867 non-null  float64\n",
      " 10  TOT_PRSC_DD_CNT     137867 non-null  float64\n",
      " 11  MCARE_RSLT_TYPE     133973 non-null  object \n",
      " 12  ED_RC_TOT_AMT       137867 non-null  float64\n",
      " 13  EDC_SBA             137867 non-null  float64\n",
      " 14  EDC_INSUR_BRDN_AMT  137867 non-null  float64\n",
      " 15  SPCF_SYM_TYPE       3150 non-null    object \n",
      "dtypes: float64(8), object(8)\n",
      "memory usage: 16.8+ MB\n",
      "None\n"
     ]
    }
   ],
   "source": [
    "print(\"\\n----- nsc2_edu_m20.sas7bdat Info -----\")\n",
    "print(dataframes['nsc2_edu_m20.sas7bdat'].info())"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "base",
   "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.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}