HVBP_safety_facility.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "04b9cd36",
   "metadata": {},
   "source": [
    "# Generate HVBP safety dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "bd2f4650",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import warnings\n",
    "from IPython.utils import io\n",
    "import sys\n",
    "warnings.filterwarnings('ignore')\n",
    "pd.set_option('display.max_columns', None)\n",
    "pd.set_option('display.max_rows', None)\n",
    "\n",
    "main_dir = '/Users/kenlocey/Desktop/Rush/CMS_HospitalArchives/'"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8832e526",
   "metadata": {},
   "source": [
    "## Define Custom Functions"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "d2d345a4",
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "def check_lists(lists):\n",
    "    for i, ls in enumerate(lists):\n",
    "        for i2, ls2 in enumerate(lists):\n",
    "            for i3 in ls:\n",
    "                if i3 not in ls2:\n",
    "                    print('\\n')\n",
    "                    print(i3 + ': NOT FOUND IN')\n",
    "                    print(ls2)\n",
    "                    sys.exit()\n",
    "                        \n",
    "                        \n",
    "def curate(df):\n",
    "\n",
    "    try:\n",
    "        df = df[df['Facility ID'] != np.nan]\n",
    "        df['Facility ID'] = df['Facility ID'].values.astype(str)\n",
    "        \n",
    "        ids = df['Facility ID'].tolist()\n",
    "        ids2 = []\n",
    "        for i in ids:\n",
    "            if len(i) < 6:\n",
    "                i = '0' + i\n",
    "            ids2.append(i)\n",
    "        df['Facility ID'] = ids2\n",
    "        \n",
    "    except:\n",
    "        pass\n",
    "    try:\n",
    "        df = df[df['Facility Name'] != np.nan]\n",
    "    except:\n",
    "        pass\n",
    "    \n",
    "    for c in list(df):    \n",
    "        try:\n",
    "            df[c] = df[c].str.replace(\"\\t\",\"\")\n",
    "        except:\n",
    "            pass\n",
    "\n",
    "    return df\n",
    "\n",
    "\n",
    "def rename_and_fill(df):\n",
    "    \n",
    "    cols1 = ['Provider ID', \"Measure Start Date\", \"Measure End Date\",\n",
    "             'Hospital Name', 'Provider Number', ' ZIP Code',\n",
    "             ]\n",
    "    \n",
    "    \n",
    "    cols2 = ['Facility ID', \"Start Date\", \"End Date\",\n",
    "             'Facility Name', 'Facility ID', 'ZIP Code',\n",
    "             ]\n",
    "    \n",
    "    for i, col in enumerate(cols1):\n",
    "        if col in list(df):\n",
    "            df.rename(columns={col: cols2[i]}, inplace=True)\n",
    "            \n",
    "            \n",
    "    cols = ['Fiscal Year', 'HAI-1 Achievement Threshold', 'HAI-1 Benchmark',\n",
    "            'HAI-1 Baseline Rate', 'HAI-1 Performance Rate', 'HAI-1 Achievement Points',\n",
    "            'HAI-1 Improvement Points', 'HAI-1 Measure Score', 'HAI-2 Achievement Threshold',\n",
    "            'HAI-2 Benchmark', 'HAI-2 Baseline Rate', 'HAI-2 Performance Rate',\n",
    "            'HAI-2 Achievement Points', 'HAI-2 Improvement Points',\n",
    "            'HAI-2 Measure Score', 'Combined SSI Measure Score',\n",
    "            'HAI-3 Achievement Threshold', 'HAI-3 Benchmark', 'HAI-3 Baseline Rate',\n",
    "            'HAI-3 Performance Rate', 'HAI-3 Achievement Points',\n",
    "            'HAI-3 Improvement Points', 'HAI-3 Measure Score',\n",
    "            'HAI-4 Achievement Threshold', 'HAI-4 Benchmark', 'HAI-4 Baseline Rate',\n",
    "            'HAI-4 Performance Rate', 'HAI-4 Achievement Points', \n",
    "            'HAI-4 Improvement Points', 'HAI-4 Measure Score', \n",
    "            'HAI-5 Achievement Threshold', 'HAI-5 Benchmark', 'HAI-5 Baseline Rate',\n",
    "            'HAI-5 Performance Rate', 'HAI-5 Achievement Points',\n",
    "            'HAI-5 Improvement Points', 'HAI-5 Measure Score', 'HAI-6 Achievement Threshold',\n",
    "            'HAI-6 Benchmark', 'HAI-6 Baseline Rate', 'HAI-6 Performance Rate',\n",
    "            'HAI-6 Achievement Points', 'HAI-6 Improvement Points',\n",
    "            'HAI-6 Measure Score', 'MORT-30-AMI Achievement Threshold',\n",
    "            'MORT-30-AMI Benchmark', 'MORT-30-AMI Baseline Rate',\n",
    "            'MORT-30-AMI Performance Rate', 'MORT-30-AMI Achievement Points',\n",
    "            'MORT-30-AMI Improvement Points', 'MORT-30-AMI Measure Score',\n",
    "            'MORT-30-HF Achievement Threshold', 'MORT-30-HF Benchmark',\n",
    "            'MORT-30-HF Baseline Rate', 'MORT-30-HF Performance Rate',\n",
    "            'MORT-30-HF Achievement Points', 'MORT-30-HF Improvement Points',\n",
    "            'MORT-30-HF Measure Score', 'MORT-30-PN Achievement Threshold',\n",
    "            'MORT-30-PN Benchmark', 'MORT-30-PN Baseline Rate',\n",
    "            'MORT-30-PN Performance Rate', 'MORT-30-PN Achievement Points',\n",
    "            'MORT-30-PN Improvement Points', 'MORT-30-PN Measure Score',\n",
    "            'COMP-HIP-KNEE Achievement Threshold', 'COMP-HIP-KNEE Benchmark',\n",
    "            'COMP-HIP-KNEE Baseline Rate', 'COMP-HIP-KNEE Performance Rate',\n",
    "            'COMP-HIP-KNEE Achievement Points', 'COMP-HIP-KNEE Improvement Points',\n",
    "            'COMP-HIP-KNEE Measure Score', 'PC-01 Achievement Threshold',\n",
    "            'PC-01 Benchmark', 'PC-01 Baseline Rate', 'PC-01 Performance Rate',\n",
    "            'PC-01 Achievement Points', 'PC-01 Improvement Points',\n",
    "            'PC-01 Measure Score', 'PSI-90 Achievement Threshold',\n",
    "            'PSI-90 Benchmark', 'PSI-90 Baseline Rate', 'PSI-90 Performance Rate',\n",
    "            'PSI-90 Achievement Points', 'PSI-90 Improvement Points',\n",
    "            'PSI-90 Measure Score', \n",
    "            ]\n",
    "    \n",
    "    for col in cols:\n",
    "        if col not in list(df):\n",
    "            df[col] = float('NaN')\n",
    "    \n",
    "    l = list(df)\n",
    "    l = list(set([x for x in l if l.count(x) > 1]))\n",
    "    if len(l) > 0:\n",
    "        print('duplicates:', l)\n",
    "        sys.exit()\n",
    "        \n",
    "    return df\n",
    "\n",
    "\n",
    "def process2(df, lists, yr, mo):\n",
    "    df = rename_and_fill(df)\n",
    "    df = curate(df)\n",
    "    lists.append(list(df))\n",
    "    df['file_month'] = [mo]* df.shape[0]\n",
    "    df['file_year'] = [yr]* df.shape[0]\n",
    "    df = df.reindex(sorted(df.columns), axis=1)\n",
    "    return df, lists\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "12fdf6f4",
   "metadata": {},
   "source": [
    "## Load Files"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "eaed2965",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2023/hospitals_01_2023/hvbp_safety.csv :  (rows, columns) = (2517, 51)\n",
      "2023/hospitals_04_2023/hvbp_safety.csv :  (rows, columns) = (2517, 51)\n",
      "2022/hospitals_01_2022/hvbp_safety.csv :  (rows, columns) = (2676, 51)\n",
      "2022/hospitals_04_2022/hvbp_safety.csv :  (rows, columns) = (2236, 51)\n",
      "2022/hospitals_07_2022/hvbp_safety.csv :  (rows, columns) = (2236, 51)\n",
      "2021/hospitals_01_2021/hvbp_safety.csv :  (rows, columns) = (2676, 51)\n",
      "2021/hospitals_03_2021/hvbp_safety.csv :  (rows, columns) = (2676, 51)\n",
      "2021/hospitals_04_2021/hvbp_safety.csv :  (rows, columns) = (2676, 51)\n",
      "2021/hospitals_07_2021/hvbp_safety.csv :  (rows, columns) = (2676, 51)\n",
      "2021/hospitals_10_2021/hvbp_safety.csv :  (rows, columns) = (2676, 51)\n",
      "2020/hospitals_archive_10_2020/hvbp_clinical_outcomes_12_09_2019.csv :  (rows, columns) = (2731, 35)\n",
      "2020/hospitals_archive_07_2020/hvbp_safety.csv :  (rows, columns) = (2731, 57)\n",
      "2020/HOSArchive_Revised_Flatfiles_20200422/hvbp_safety_12_09_2019.csv :  (rows, columns) = (2731, 57)\n",
      "2020/HOSArchive_Revised_Flatfiles_20200129/hvbp_safety_12_09_2019.csv :  (rows, columns) = (2731, 57)\n",
      "2019/HOSArchive_Revised_Flatfiles_20191030/hvbp_safety_11_09_2018.csv :  (rows, columns) = (2786, 57)\n",
      "2019/HOSArchive_Revised_Flatfiles_20190702/hvbp_safety_11_09_2018.csv :  (rows, columns) = (2786, 57)\n",
      "2019/HOSArchive_Revised_FlatFiles_20190424/hvbp_safety_11_09_2018.csv :  (rows, columns) = (2786, 57)\n",
      "2019/HOSArchive_Revised_Flatfiles_20190321/hvbp_safety_11_09_2018.csv :  (rows, columns) = (2786, 57)\n",
      "2018/HOSArchive_Revised_FlatFiles_20181031/hvbp_safety_11_07_2017.csv :  (rows, columns) = (2808, 64)\n",
      "2018/HOSArchive_Revised_FlatFiles_20180725/hvbp_safety_11_07_2017.csv :  (rows, columns) = (2808, 64)\n",
      "2018/HOSArchive_Revised_FlatFiles_20180523/hvbp_safety_11_07_2017.csv :  (rows, columns) = (2808, 64)\n",
      "2018/HOSArchive_Revised_FlatFiles_20180126/hvbp_safety_11_07_2017.csv :  (rows, columns) = (2808, 64)\n",
      "2017/HOSArchive_Revised_FlatFiles_20171024/hvbp_safety_11_10_2016.csv :  (rows, columns) = (2955, 57)\n",
      "2017/HOSArchive_Revised_FlatFiles_20170726/hvbp_safety_11_10_2016.csv :  (rows, columns) = (2955, 57)\n",
      "2017/HOSArchive_Revised_Flatfiles_20170428/hvbp_safety_11_10_2016.csv :  (rows, columns) = (2955, 57)\n",
      "2016/HOSArchive_Revised_Flatfiles_20161219/hvbp_safety_11_10_2016.csv :  (rows, columns) = (2955, 57)\n",
      "hvb_df.shape: (70682, 95)\n"
     ]
    }
   ],
   "source": [
    "df_list = []\n",
    "lists = []\n",
    "\n",
    "yrs = ['2023', '2023',\n",
    "       '2022', '2022', '2022',\n",
    "       '2021','2021','2021', '2021', '2021',\n",
    "       '2020', '2020', '2020', '2020', \n",
    "       '2019', '2019', '2019', '2019', \n",
    "       '2018', '2018', '2018', '2018',\n",
    "       '2017', '2017', '2017',\n",
    "       '2016',\n",
    "       ]\n",
    "\n",
    "mos = ['01', '04',\n",
    "       '01', '04', '07',\n",
    "       '01', '03', '04', '07', '10', \n",
    "       '10', '07', '04', '01', \n",
    "       '10', '07', '04', '03', \n",
    "       '10', '07', '05', '01',\n",
    "       '10', '07', '04',\n",
    "       '12',\n",
    "       ]\n",
    "\n",
    "\n",
    "subdirs = ['2023/hospitals_01_2023/hvbp_safety.csv', \n",
    "           '2023/hospitals_04_2023/hvbp_safety.csv',\n",
    "           \n",
    "           '2022/hospitals_01_2022/hvbp_safety.csv', \n",
    "           '2022/hospitals_04_2022/hvbp_safety.csv',\n",
    "           '2022/hospitals_07_2022/hvbp_safety.csv',\n",
    "           \n",
    "           '2021/hospitals_01_2021/hvbp_safety.csv',\n",
    "           '2021/hospitals_03_2021/hvbp_safety.csv',\n",
    "           '2021/hospitals_04_2021/hvbp_safety.csv',\n",
    "           '2021/hospitals_07_2021/hvbp_safety.csv',\n",
    "           '2021/hospitals_10_2021/hvbp_safety.csv',\n",
    "           \n",
    "           '2020/hospitals_archive_10_2020/hvbp_clinical_outcomes_12_09_2019.csv',\n",
    "           '2020/hospitals_archive_07_2020/hvbp_safety.csv',\n",
    "           '2020/HOSArchive_Revised_Flatfiles_20200422/hvbp_safety_12_09_2019.csv',\n",
    "           '2020/HOSArchive_Revised_Flatfiles_20200129/hvbp_safety_12_09_2019.csv',\n",
    "           \n",
    "           '2019/HOSArchive_Revised_Flatfiles_20191030/hvbp_safety_11_09_2018.csv',\n",
    "           '2019/HOSArchive_Revised_Flatfiles_20190702/hvbp_safety_11_09_2018.csv',\n",
    "           '2019/HOSArchive_Revised_FlatFiles_20190424/hvbp_safety_11_09_2018.csv',\n",
    "           '2019/HOSArchive_Revised_Flatfiles_20190321/hvbp_safety_11_09_2018.csv',\n",
    "           \n",
    "           '2018/HOSArchive_Revised_FlatFiles_20181031/hvbp_safety_11_07_2017.csv',\n",
    "           '2018/HOSArchive_Revised_FlatFiles_20180725/hvbp_safety_11_07_2017.csv',\n",
    "           '2018/HOSArchive_Revised_FlatFiles_20180523/hvbp_safety_11_07_2017.csv', \n",
    "           '2018/HOSArchive_Revised_FlatFiles_20180126/hvbp_safety_11_07_2017.csv',\n",
    "           \n",
    "           '2017/HOSArchive_Revised_FlatFiles_20171024/hvbp_safety_11_10_2016.csv',\n",
    "           '2017/HOSArchive_Revised_FlatFiles_20170726/hvbp_safety_11_10_2016.csv', \n",
    "           '2017/HOSArchive_Revised_Flatfiles_20170428/hvbp_safety_11_10_2016.csv',\n",
    "           \n",
    "           '2016/HOSArchive_Revised_Flatfiles_20161219/hvbp_safety_11_10_2016.csv', \n",
    "           \n",
    "           ]\n",
    "\n",
    "for i, subdir in enumerate(subdirs):\n",
    "    with io.capture_output() as captured: df = pd.read_csv(main_dir + subdir, encoding = \"ISO-8859-1\")\n",
    "    print(subdir + ' :  (rows, columns) =', df.shape)\n",
    "    df, lists = process2(df, lists, yrs[i], mos[i])\n",
    "    df_list.append(df)\n",
    "\n",
    "check_lists(lists)\n",
    "subdir = 'HVBP/CombinedFiles_HVBP'\n",
    "hvb_df = pd.concat(df_list)\n",
    "print('hvb_df.shape:', hvb_df.shape)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "ab3567bb",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "HVBP df: (70682, 95)\n",
      "(70682, 88)\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>COMP-HIP-KNEE Achievement Points</th>\n",
       "      <th>COMP-HIP-KNEE Achievement Threshold</th>\n",
       "      <th>COMP-HIP-KNEE Baseline Rate</th>\n",
       "      <th>COMP-HIP-KNEE Benchmark</th>\n",
       "      <th>COMP-HIP-KNEE Improvement Points</th>\n",
       "      <th>COMP-HIP-KNEE Measure Score</th>\n",
       "      <th>COMP-HIP-KNEE Performance Rate</th>\n",
       "      <th>Combined SSI Measure Score</th>\n",
       "      <th>Facility ID</th>\n",
       "      <th>HAI-1 Achievement Points</th>\n",
       "      <th>HAI-1 Achievement Threshold</th>\n",
       "      <th>HAI-1 Baseline Rate</th>\n",
       "      <th>HAI-1 Benchmark</th>\n",
       "      <th>HAI-1 Improvement Points</th>\n",
       "      <th>HAI-1 Measure Score</th>\n",
       "      <th>HAI-1 Performance Rate</th>\n",
       "      <th>HAI-2 Achievement Points</th>\n",
       "      <th>HAI-2 Achievement Threshold</th>\n",
       "      <th>HAI-2 Baseline Rate</th>\n",
       "      <th>HAI-2 Benchmark</th>\n",
       "      <th>HAI-2 Improvement Points</th>\n",
       "      <th>HAI-2 Measure Score</th>\n",
       "      <th>HAI-2 Performance Rate</th>\n",
       "      <th>HAI-3 Achievement Points</th>\n",
       "      <th>HAI-3 Achievement Threshold</th>\n",
       "      <th>HAI-3 Baseline Rate</th>\n",
       "      <th>HAI-3 Benchmark</th>\n",
       "      <th>HAI-3 Improvement Points</th>\n",
       "      <th>HAI-3 Measure Score</th>\n",
       "      <th>HAI-3 Performance Rate</th>\n",
       "      <th>HAI-4 Achievement Points</th>\n",
       "      <th>HAI-4 Achievement Threshold</th>\n",
       "      <th>HAI-4 Baseline Rate</th>\n",
       "      <th>HAI-4 Benchmark</th>\n",
       "      <th>HAI-4 Improvement Points</th>\n",
       "      <th>HAI-4 Measure Score</th>\n",
       "      <th>HAI-4 Performance Rate</th>\n",
       "      <th>HAI-5 Achievement Points</th>\n",
       "      <th>HAI-5 Achievement Threshold</th>\n",
       "      <th>HAI-5 Baseline Rate</th>\n",
       "      <th>HAI-5 Benchmark</th>\n",
       "      <th>HAI-5 Improvement Points</th>\n",
       "      <th>HAI-5 Measure Score</th>\n",
       "      <th>HAI-5 Performance Rate</th>\n",
       "      <th>HAI-6 Achievement Points</th>\n",
       "      <th>HAI-6 Achievement Threshold</th>\n",
       "      <th>HAI-6 Baseline Rate</th>\n",
       "      <th>HAI-6 Benchmark</th>\n",
       "      <th>HAI-6 Improvement Points</th>\n",
       "      <th>HAI-6 Measure Score</th>\n",
       "      <th>HAI-6 Performance Rate</th>\n",
       "      <th>MORT-30-AMI Achievement Points</th>\n",
       "      <th>MORT-30-AMI Achievement Threshold</th>\n",
       "      <th>MORT-30-AMI Baseline Rate</th>\n",
       "      <th>MORT-30-AMI Benchmark</th>\n",
       "      <th>MORT-30-AMI Improvement Points</th>\n",
       "      <th>MORT-30-AMI Measure Score</th>\n",
       "      <th>MORT-30-AMI Performance Rate</th>\n",
       "      <th>MORT-30-HF Achievement Points</th>\n",
       "      <th>MORT-30-HF Achievement Threshold</th>\n",
       "      <th>MORT-30-HF Baseline Rate</th>\n",
       "      <th>MORT-30-HF Benchmark</th>\n",
       "      <th>MORT-30-HF Improvement Points</th>\n",
       "      <th>MORT-30-HF Measure Score</th>\n",
       "      <th>MORT-30-HF Performance Rate</th>\n",
       "      <th>MORT-30-PN Achievement Points</th>\n",
       "      <th>MORT-30-PN Achievement Threshold</th>\n",
       "      <th>MORT-30-PN Baseline Rate</th>\n",
       "      <th>MORT-30-PN Benchmark</th>\n",
       "      <th>MORT-30-PN Improvement Points</th>\n",
       "      <th>MORT-30-PN Measure Score</th>\n",
       "      <th>MORT-30-PN Performance Rate</th>\n",
       "      <th>PC-01 Achievement Points</th>\n",
       "      <th>PC-01 Achievement Threshold</th>\n",
       "      <th>PC-01 Baseline Rate</th>\n",
       "      <th>PC-01 Benchmark</th>\n",
       "      <th>PC-01 Improvement Points</th>\n",
       "      <th>PC-01 Measure Score</th>\n",
       "      <th>PC-01 Performance Rate</th>\n",
       "      <th>PSI-90 Achievement Points</th>\n",
       "      <th>PSI-90 Achievement Threshold</th>\n",
       "      <th>PSI-90 Baseline Rate</th>\n",
       "      <th>PSI-90 Benchmark</th>\n",
       "      <th>PSI-90 Improvement Points</th>\n",
       "      <th>PSI-90 Measure Score</th>\n",
       "      <th>PSI-90 Performance Rate</th>\n",
       "      <th>file_month</th>\n",
       "      <th>file_year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\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>Not Available</td>\n",
       "      <td>010001</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.589</td>\n",
       "      <td>0.742</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.476</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.65</td>\n",
       "      <td>0.324</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.306</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.717</td>\n",
       "      <td>0.650</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>1.228</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.738</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.000</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.726</td>\n",
       "      <td>0.548</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.912</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.52</td>\n",
       "      <td>0.537</td>\n",
       "      <td>0.014</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.644</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",
       "      <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",
       "      <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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\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>Not Available</td>\n",
       "      <td>010005</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.589</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>3.311</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.65</td>\n",
       "      <td>1.073</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>2.350</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.717</td>\n",
       "      <td>0.508</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.400</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.738</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.726</td>\n",
       "      <td>1.938</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.000</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.52</td>\n",
       "      <td>0.565</td>\n",
       "      <td>0.014</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.860</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",
       "      <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",
       "      <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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\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>Not Available</td>\n",
       "      <td>010006</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.589</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.507</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.65</td>\n",
       "      <td>0.222</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.602</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.717</td>\n",
       "      <td>0.820</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.871</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.738</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.726</td>\n",
       "      <td>0.654</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>1.640</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.52</td>\n",
       "      <td>0.426</td>\n",
       "      <td>0.014</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.080</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",
       "      <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",
       "      <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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\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>Not Available</td>\n",
       "      <td>010007</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.589</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.65</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.717</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.738</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.726</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.52</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.014</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.410</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",
       "      <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",
       "      <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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\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>Not Available</td>\n",
       "      <td>010011</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.589</td>\n",
       "      <td>0.421</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.728</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.65</td>\n",
       "      <td>0.598</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.927</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.717</td>\n",
       "      <td>0.930</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.268</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.738</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.726</td>\n",
       "      <td>0.964</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>1.346</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.52</td>\n",
       "      <td>0.343</td>\n",
       "      <td>0.014</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.607</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",
       "      <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",
       "      <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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  COMP-HIP-KNEE Achievement Points  COMP-HIP-KNEE Achievement Threshold  \\\n",
       "0                              NaN                                  NaN   \n",
       "1                              NaN                                  NaN   \n",
       "2                              NaN                                  NaN   \n",
       "3                              NaN                                  NaN   \n",
       "4                              NaN                                  NaN   \n",
       "\n",
       "  COMP-HIP-KNEE Baseline Rate  COMP-HIP-KNEE Benchmark  \\\n",
       "0                         NaN                      NaN   \n",
       "1                         NaN                      NaN   \n",
       "2                         NaN                      NaN   \n",
       "3                         NaN                      NaN   \n",
       "4                         NaN                      NaN   \n",
       "\n",
       "  COMP-HIP-KNEE Improvement Points COMP-HIP-KNEE Measure Score  \\\n",
       "0                              NaN                         NaN   \n",
       "1                              NaN                         NaN   \n",
       "2                              NaN                         NaN   \n",
       "3                              NaN                         NaN   \n",
       "4                              NaN                         NaN   \n",
       "\n",
       "  COMP-HIP-KNEE Performance Rate Combined SSI Measure Score Facility ID  \\\n",
       "0                            NaN              Not Available      010001   \n",
       "1                            NaN              Not Available      010005   \n",
       "2                            NaN              Not Available      010006   \n",
       "3                            NaN              Not Available      010007   \n",
       "4                            NaN              Not Available      010011   \n",
       "\n",
       "  HAI-1 Achievement Points  HAI-1 Achievement Threshold HAI-1 Baseline Rate  \\\n",
       "0            Not Available                        0.589               0.742   \n",
       "1            Not Available                        0.589               0.000   \n",
       "2            Not Available                        0.589               0.000   \n",
       "3            Not Available                        0.589       Not Available   \n",
       "4            Not Available                        0.589               0.421   \n",
       "\n",
       "   HAI-1 Benchmark HAI-1 Improvement Points HAI-1 Measure Score  \\\n",
       "0              0.0            Not Available       Not Available   \n",
       "1              0.0            Not Available       Not Available   \n",
       "2              0.0            Not Available       Not Available   \n",
       "3              0.0            Not Available       Not Available   \n",
       "4              0.0            Not Available       Not Available   \n",
       "\n",
       "  HAI-1 Performance Rate HAI-2 Achievement Points  \\\n",
       "0                  0.476            Not Available   \n",
       "1                  3.311            Not Available   \n",
       "2                  0.507            Not Available   \n",
       "3          Not Available            Not Available   \n",
       "4                  0.728            Not Available   \n",
       "\n",
       "   HAI-2 Achievement Threshold HAI-2 Baseline Rate  HAI-2 Benchmark  \\\n",
       "0                         0.65               0.324              0.0   \n",
       "1                         0.65               1.073              0.0   \n",
       "2                         0.65               0.222              0.0   \n",
       "3                         0.65       Not Available              0.0   \n",
       "4                         0.65               0.598              0.0   \n",
       "\n",
       "  HAI-2 Improvement Points HAI-2 Measure Score HAI-2 Performance Rate  \\\n",
       "0            Not Available       Not Available                  0.306   \n",
       "1            Not Available       Not Available                  2.350   \n",
       "2            Not Available       Not Available                  0.602   \n",
       "3            Not Available       Not Available          Not Available   \n",
       "4            Not Available       Not Available                  0.927   \n",
       "\n",
       "  HAI-3 Achievement Points  HAI-3 Achievement Threshold HAI-3 Baseline Rate  \\\n",
       "0            Not Available                        0.717               0.650   \n",
       "1            Not Available                        0.717               0.508   \n",
       "2            Not Available                        0.717               0.820   \n",
       "3            Not Available                        0.717       Not Available   \n",
       "4            Not Available                        0.717               0.930   \n",
       "\n",
       "   HAI-3 Benchmark HAI-3 Improvement Points HAI-3 Measure Score  \\\n",
       "0              0.0            Not Available       Not Available   \n",
       "1              0.0            Not Available       Not Available   \n",
       "2              0.0            Not Available       Not Available   \n",
       "3              0.0            Not Available       Not Available   \n",
       "4              0.0            Not Available       Not Available   \n",
       "\n",
       "  HAI-3 Performance Rate HAI-4 Achievement Points  \\\n",
       "0                  1.228            Not Available   \n",
       "1                  0.400            Not Available   \n",
       "2                  0.871            Not Available   \n",
       "3          Not Available            Not Available   \n",
       "4                  0.268            Not Available   \n",
       "\n",
       "   HAI-4 Achievement Threshold HAI-4 Baseline Rate  HAI-4 Benchmark  \\\n",
       "0                        0.738               0.000              0.0   \n",
       "1                        0.738       Not Available              0.0   \n",
       "2                        0.738       Not Available              0.0   \n",
       "3                        0.738       Not Available              0.0   \n",
       "4                        0.738       Not Available              0.0   \n",
       "\n",
       "  HAI-4 Improvement Points HAI-4 Measure Score HAI-4 Performance Rate  \\\n",
       "0            Not Available       Not Available                  0.000   \n",
       "1            Not Available       Not Available          Not Available   \n",
       "2            Not Available       Not Available          Not Available   \n",
       "3            Not Available       Not Available          Not Available   \n",
       "4            Not Available       Not Available          Not Available   \n",
       "\n",
       "  HAI-5 Achievement Points  HAI-5 Achievement Threshold HAI-5 Baseline Rate  \\\n",
       "0            Not Available                        0.726               0.548   \n",
       "1            Not Available                        0.726               1.938   \n",
       "2            Not Available                        0.726               0.654   \n",
       "3            Not Available                        0.726       Not Available   \n",
       "4            Not Available                        0.726               0.964   \n",
       "\n",
       "   HAI-5 Benchmark HAI-5 Improvement Points HAI-5 Measure Score  \\\n",
       "0              0.0            Not Available       Not Available   \n",
       "1              0.0            Not Available       Not Available   \n",
       "2              0.0            Not Available       Not Available   \n",
       "3              0.0            Not Available       Not Available   \n",
       "4              0.0            Not Available       Not Available   \n",
       "\n",
       "  HAI-5 Performance Rate HAI-6 Achievement Points  \\\n",
       "0                  0.912            Not Available   \n",
       "1                  0.000            Not Available   \n",
       "2                  1.640            Not Available   \n",
       "3          Not Available            Not Available   \n",
       "4                  1.346            Not Available   \n",
       "\n",
       "   HAI-6 Achievement Threshold HAI-6 Baseline Rate  HAI-6 Benchmark  \\\n",
       "0                         0.52               0.537            0.014   \n",
       "1                         0.52               0.565            0.014   \n",
       "2                         0.52               0.426            0.014   \n",
       "3                         0.52               0.000            0.014   \n",
       "4                         0.52               0.343            0.014   \n",
       "\n",
       "  HAI-6 Improvement Points HAI-6 Measure Score HAI-6 Performance Rate  \\\n",
       "0            Not Available       Not Available                  0.644   \n",
       "1            Not Available       Not Available                  0.860   \n",
       "2            Not Available       Not Available                  0.080   \n",
       "3            Not Available       Not Available                  0.410   \n",
       "4            Not Available       Not Available                  0.607   \n",
       "\n",
       "  MORT-30-AMI Achievement Points  MORT-30-AMI Achievement Threshold  \\\n",
       "0                            NaN                                NaN   \n",
       "1                            NaN                                NaN   \n",
       "2                            NaN                                NaN   \n",
       "3                            NaN                                NaN   \n",
       "4                            NaN                                NaN   \n",
       "\n",
       "  MORT-30-AMI Baseline Rate  MORT-30-AMI Benchmark  \\\n",
       "0                       NaN                    NaN   \n",
       "1                       NaN                    NaN   \n",
       "2                       NaN                    NaN   \n",
       "3                       NaN                    NaN   \n",
       "4                       NaN                    NaN   \n",
       "\n",
       "  MORT-30-AMI Improvement Points MORT-30-AMI Measure Score  \\\n",
       "0                            NaN                       NaN   \n",
       "1                            NaN                       NaN   \n",
       "2                            NaN                       NaN   \n",
       "3                            NaN                       NaN   \n",
       "4                            NaN                       NaN   \n",
       "\n",
       "  MORT-30-AMI Performance Rate MORT-30-HF Achievement Points  \\\n",
       "0                          NaN                           NaN   \n",
       "1                          NaN                           NaN   \n",
       "2                          NaN                           NaN   \n",
       "3                          NaN                           NaN   \n",
       "4                          NaN                           NaN   \n",
       "\n",
       "   MORT-30-HF Achievement Threshold MORT-30-HF Baseline Rate  \\\n",
       "0                               NaN                      NaN   \n",
       "1                               NaN                      NaN   \n",
       "2                               NaN                      NaN   \n",
       "3                               NaN                      NaN   \n",
       "4                               NaN                      NaN   \n",
       "\n",
       "   MORT-30-HF Benchmark MORT-30-HF Improvement Points  \\\n",
       "0                   NaN                           NaN   \n",
       "1                   NaN                           NaN   \n",
       "2                   NaN                           NaN   \n",
       "3                   NaN                           NaN   \n",
       "4                   NaN                           NaN   \n",
       "\n",
       "  MORT-30-HF Measure Score MORT-30-HF Performance Rate  \\\n",
       "0                      NaN                         NaN   \n",
       "1                      NaN                         NaN   \n",
       "2                      NaN                         NaN   \n",
       "3                      NaN                         NaN   \n",
       "4                      NaN                         NaN   \n",
       "\n",
       "  MORT-30-PN Achievement Points  MORT-30-PN Achievement Threshold  \\\n",
       "0                           NaN                               NaN   \n",
       "1                           NaN                               NaN   \n",
       "2                           NaN                               NaN   \n",
       "3                           NaN                               NaN   \n",
       "4                           NaN                               NaN   \n",
       "\n",
       "  MORT-30-PN Baseline Rate  MORT-30-PN Benchmark  \\\n",
       "0                      NaN                   NaN   \n",
       "1                      NaN                   NaN   \n",
       "2                      NaN                   NaN   \n",
       "3                      NaN                   NaN   \n",
       "4                      NaN                   NaN   \n",
       "\n",
       "  MORT-30-PN Improvement Points MORT-30-PN Measure Score  \\\n",
       "0                           NaN                      NaN   \n",
       "1                           NaN                      NaN   \n",
       "2                           NaN                      NaN   \n",
       "3                           NaN                      NaN   \n",
       "4                           NaN                      NaN   \n",
       "\n",
       "  MORT-30-PN Performance Rate PC-01 Achievement Points  \\\n",
       "0                         NaN                      NaN   \n",
       "1                         NaN                      NaN   \n",
       "2                         NaN                      NaN   \n",
       "3                         NaN                      NaN   \n",
       "4                         NaN                      NaN   \n",
       "\n",
       "   PC-01 Achievement Threshold PC-01 Baseline Rate  PC-01 Benchmark  \\\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",
       "  PC-01 Improvement Points PC-01 Measure Score PC-01 Performance Rate  \\\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",
       "  PSI-90 Achievement Points  PSI-90 Achievement Threshold  \\\n",
       "0                       NaN                           NaN   \n",
       "1                       NaN                           NaN   \n",
       "2                       NaN                           NaN   \n",
       "3                       NaN                           NaN   \n",
       "4                       NaN                           NaN   \n",
       "\n",
       "  PSI-90 Baseline Rate  PSI-90 Benchmark PSI-90 Improvement Points  \\\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",
       "  PSI-90 Measure Score PSI-90 Performance Rate file_month file_year  \n",
       "0                  NaN                     NaN         01      2023  \n",
       "1                  NaN                     NaN         01      2023  \n",
       "2                  NaN                     NaN         01      2023  \n",
       "3                  NaN                     NaN         01      2023  \n",
       "4                  NaN                     NaN         01      2023  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "hvb_df = pd.read_pickle(main_dir + 'HVBP/CombinedFiles_HVBP/' + 'hvbp_safety.pkl')\n",
    "print('HVBP df:', hvb_df.shape)\n",
    "\n",
    "\n",
    "hvb_df.drop(labels=['Address', 'City', 'County Name',\n",
    "                    'Facility Name', 'State', 'ZIP Code', 'Fiscal Year',\n",
    "                    ], axis=1, inplace=True)\n",
    "\n",
    "print(hvb_df.shape)\n",
    "hvb_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "f20ded31",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(70682, 88)\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>HVBP Safety: COMP-HIP-KNEE Achievement Points</th>\n",
       "      <th>HVBP Safety: COMP-HIP-KNEE Achievement Threshold</th>\n",
       "      <th>HVBP Safety: COMP-HIP-KNEE Baseline Rate</th>\n",
       "      <th>HVBP Safety: COMP-HIP-KNEE Benchmark</th>\n",
       "      <th>HVBP Safety: COMP-HIP-KNEE Improvement Points</th>\n",
       "      <th>HVBP Safety: COMP-HIP-KNEE Measure Score</th>\n",
       "      <th>HVBP Safety: COMP-HIP-KNEE Performance Rate</th>\n",
       "      <th>HVBP Safety: Combined SSI Measure Score</th>\n",
       "      <th>Facility ID</th>\n",
       "      <th>HVBP Safety: HAI-1 Achievement Points</th>\n",
       "      <th>HVBP Safety: HAI-1 Achievement Threshold</th>\n",
       "      <th>HVBP Safety: HAI-1 Baseline Rate</th>\n",
       "      <th>HVBP Safety: HAI-1 Benchmark</th>\n",
       "      <th>HVBP Safety: HAI-1 Improvement Points</th>\n",
       "      <th>HVBP Safety: HAI-1 Measure Score</th>\n",
       "      <th>HVBP Safety: HAI-1 Performance Rate</th>\n",
       "      <th>HVBP Safety: HAI-2 Achievement Points</th>\n",
       "      <th>HVBP Safety: HAI-2 Achievement Threshold</th>\n",
       "      <th>HVBP Safety: HAI-2 Baseline Rate</th>\n",
       "      <th>HVBP Safety: HAI-2 Benchmark</th>\n",
       "      <th>HVBP Safety: HAI-2 Improvement Points</th>\n",
       "      <th>HVBP Safety: HAI-2 Measure Score</th>\n",
       "      <th>HVBP Safety: HAI-2 Performance Rate</th>\n",
       "      <th>HVBP Safety: HAI-3 Achievement Points</th>\n",
       "      <th>HVBP Safety: HAI-3 Achievement Threshold</th>\n",
       "      <th>HVBP Safety: HAI-3 Baseline Rate</th>\n",
       "      <th>HVBP Safety: HAI-3 Benchmark</th>\n",
       "      <th>HVBP Safety: HAI-3 Improvement Points</th>\n",
       "      <th>HVBP Safety: HAI-3 Measure Score</th>\n",
       "      <th>HVBP Safety: HAI-3 Performance Rate</th>\n",
       "      <th>HVBP Safety: HAI-4 Achievement Points</th>\n",
       "      <th>HVBP Safety: HAI-4 Achievement Threshold</th>\n",
       "      <th>HVBP Safety: HAI-4 Baseline Rate</th>\n",
       "      <th>HVBP Safety: HAI-4 Benchmark</th>\n",
       "      <th>HVBP Safety: HAI-4 Improvement Points</th>\n",
       "      <th>HVBP Safety: HAI-4 Measure Score</th>\n",
       "      <th>HVBP Safety: HAI-4 Performance Rate</th>\n",
       "      <th>HVBP Safety: HAI-5 Achievement Points</th>\n",
       "      <th>HVBP Safety: HAI-5 Achievement Threshold</th>\n",
       "      <th>HVBP Safety: HAI-5 Baseline Rate</th>\n",
       "      <th>HVBP Safety: HAI-5 Benchmark</th>\n",
       "      <th>HVBP Safety: HAI-5 Improvement Points</th>\n",
       "      <th>HVBP Safety: HAI-5 Measure Score</th>\n",
       "      <th>HVBP Safety: HAI-5 Performance Rate</th>\n",
       "      <th>HVBP Safety: HAI-6 Achievement Points</th>\n",
       "      <th>HVBP Safety: HAI-6 Achievement Threshold</th>\n",
       "      <th>HVBP Safety: HAI-6 Baseline Rate</th>\n",
       "      <th>HVBP Safety: HAI-6 Benchmark</th>\n",
       "      <th>HVBP Safety: HAI-6 Improvement Points</th>\n",
       "      <th>HVBP Safety: HAI-6 Measure Score</th>\n",
       "      <th>HVBP Safety: HAI-6 Performance Rate</th>\n",
       "      <th>HVBP Safety: MORT-30-AMI Achievement Points</th>\n",
       "      <th>HVBP Safety: MORT-30-AMI Achievement Threshold</th>\n",
       "      <th>HVBP Safety: MORT-30-AMI Baseline Rate</th>\n",
       "      <th>HVBP Safety: MORT-30-AMI Benchmark</th>\n",
       "      <th>HVBP Safety: MORT-30-AMI Improvement Points</th>\n",
       "      <th>HVBP Safety: MORT-30-AMI Measure Score</th>\n",
       "      <th>HVBP Safety: MORT-30-AMI Performance Rate</th>\n",
       "      <th>HVBP Safety: MORT-30-HF Achievement Points</th>\n",
       "      <th>HVBP Safety: MORT-30-HF Achievement Threshold</th>\n",
       "      <th>HVBP Safety: MORT-30-HF Baseline Rate</th>\n",
       "      <th>HVBP Safety: MORT-30-HF Benchmark</th>\n",
       "      <th>HVBP Safety: MORT-30-HF Improvement Points</th>\n",
       "      <th>HVBP Safety: MORT-30-HF Measure Score</th>\n",
       "      <th>HVBP Safety: MORT-30-HF Performance Rate</th>\n",
       "      <th>HVBP Safety: MORT-30-PN Achievement Points</th>\n",
       "      <th>HVBP Safety: MORT-30-PN Achievement Threshold</th>\n",
       "      <th>HVBP Safety: MORT-30-PN Baseline Rate</th>\n",
       "      <th>HVBP Safety: MORT-30-PN Benchmark</th>\n",
       "      <th>HVBP Safety: MORT-30-PN Improvement Points</th>\n",
       "      <th>HVBP Safety: MORT-30-PN Measure Score</th>\n",
       "      <th>HVBP Safety: MORT-30-PN Performance Rate</th>\n",
       "      <th>HVBP Safety: PC-01 Achievement Points</th>\n",
       "      <th>HVBP Safety: PC-01 Achievement Threshold</th>\n",
       "      <th>HVBP Safety: PC-01 Baseline Rate</th>\n",
       "      <th>HVBP Safety: PC-01 Benchmark</th>\n",
       "      <th>HVBP Safety: PC-01 Improvement Points</th>\n",
       "      <th>HVBP Safety: PC-01 Measure Score</th>\n",
       "      <th>HVBP Safety: PC-01 Performance Rate</th>\n",
       "      <th>HVBP Safety: PSI-90 Achievement Points</th>\n",
       "      <th>HVBP Safety: PSI-90 Achievement Threshold</th>\n",
       "      <th>HVBP Safety: PSI-90 Baseline Rate</th>\n",
       "      <th>HVBP Safety: PSI-90 Benchmark</th>\n",
       "      <th>HVBP Safety: PSI-90 Improvement Points</th>\n",
       "      <th>HVBP Safety: PSI-90 Measure Score</th>\n",
       "      <th>HVBP Safety: PSI-90 Performance Rate</th>\n",
       "      <th>file_month</th>\n",
       "      <th>file_year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2950</th>\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>10 out of 10</td>\n",
       "      <td>670082</td>\n",
       "      <td>0 out of 10</td>\n",
       "      <td>0.457</td>\n",
       "      <td>1.247</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4 out of 9</td>\n",
       "      <td>4 out of 10</td>\n",
       "      <td>0.679</td>\n",
       "      <td>0 out of 10</td>\n",
       "      <td>0.845</td>\n",
       "      <td>2.538</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2 out of 9</td>\n",
       "      <td>2 out of 10</td>\n",
       "      <td>1.946</td>\n",
       "      <td>10 out of 10</td>\n",
       "      <td>0.751</td>\n",
       "      <td>0.588</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9 out of 9</td>\n",
       "      <td>10 out of 10</td>\n",
       "      <td>0.000</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.698</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>10 out of 10</td>\n",
       "      <td>0.799</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>10 out of 10</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0 out of 10</td>\n",
       "      <td>0.75</td>\n",
       "      <td>1.115</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0 out of 9</td>\n",
       "      <td>0 out of 10</td>\n",
       "      <td>1.353</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",
       "      <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",
       "      <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>10 out of 10</td>\n",
       "      <td>0.777936</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.547889</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>10 out of 10</td>\n",
       "      <td>0.393041</td>\n",
       "      <td>12</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2951</th>\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>0 out of 10</td>\n",
       "      <td>670085</td>\n",
       "      <td>10 out of 10</td>\n",
       "      <td>0.457</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>10 out of 10</td>\n",
       "      <td>0.000</td>\n",
       "      <td>10 out of 10</td>\n",
       "      <td>0.845</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>10 out of 10</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0 out of 10</td>\n",
       "      <td>0.751</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0 out of 10</td>\n",
       "      <td>2.973</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.698</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.799</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0 out of 10</td>\n",
       "      <td>0.75</td>\n",
       "      <td>0.323</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0 out of 9</td>\n",
       "      <td>0 out of 10</td>\n",
       "      <td>1.557</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",
       "      <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",
       "      <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>10 out of 10</td>\n",
       "      <td>0.777936</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.547889</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>10 out of 10</td>\n",
       "      <td>0.446768</td>\n",
       "      <td>12</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2952</th>\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>0 out of 10</td>\n",
       "      <td>670088</td>\n",
       "      <td>0 out of 10</td>\n",
       "      <td>0.457</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0 out of 10</td>\n",
       "      <td>0.975</td>\n",
       "      <td>3 out of 10</td>\n",
       "      <td>0.845</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>3 out of 10</td>\n",
       "      <td>0.586</td>\n",
       "      <td>0 out of 10</td>\n",
       "      <td>0.751</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0 out of 10</td>\n",
       "      <td>0.969</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.698</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.799</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>3 out of 10</td>\n",
       "      <td>0.75</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>3 out of 10</td>\n",
       "      <td>0.506</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",
       "      <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",
       "      <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>10 out of 10</td>\n",
       "      <td>0.777936</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.547889</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>10 out of 10</td>\n",
       "      <td>0.513223</td>\n",
       "      <td>12</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2953</th>\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>Not Available</td>\n",
       "      <td>670103</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.457</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.845</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.751</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.698</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.799</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0 out of 10</td>\n",
       "      <td>0.75</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0 out of 10</td>\n",
       "      <td>0.929</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",
       "      <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",
       "      <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>9 out of 10</td>\n",
       "      <td>0.777936</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.547889</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>9 out of 10</td>\n",
       "      <td>0.563756</td>\n",
       "      <td>12</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2954</th>\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>Not Available</td>\n",
       "      <td>670106</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.457</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.845</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.751</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.698</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.799</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.75</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Not Available</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",
       "      <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",
       "      <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>9 out of 10</td>\n",
       "      <td>0.777936</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.547889</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>9 out of 10</td>\n",
       "      <td>0.561992</td>\n",
       "      <td>12</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     HVBP Safety: COMP-HIP-KNEE Achievement Points  \\\n",
       "2950                                           NaN   \n",
       "2951                                           NaN   \n",
       "2952                                           NaN   \n",
       "2953                                           NaN   \n",
       "2954                                           NaN   \n",
       "\n",
       "      HVBP Safety: COMP-HIP-KNEE Achievement Threshold  \\\n",
       "2950                                               NaN   \n",
       "2951                                               NaN   \n",
       "2952                                               NaN   \n",
       "2953                                               NaN   \n",
       "2954                                               NaN   \n",
       "\n",
       "     HVBP Safety: COMP-HIP-KNEE Baseline Rate  \\\n",
       "2950                                      NaN   \n",
       "2951                                      NaN   \n",
       "2952                                      NaN   \n",
       "2953                                      NaN   \n",
       "2954                                      NaN   \n",
       "\n",
       "      HVBP Safety: COMP-HIP-KNEE Benchmark  \\\n",
       "2950                                   NaN   \n",
       "2951                                   NaN   \n",
       "2952                                   NaN   \n",
       "2953                                   NaN   \n",
       "2954                                   NaN   \n",
       "\n",
       "     HVBP Safety: COMP-HIP-KNEE Improvement Points  \\\n",
       "2950                                           NaN   \n",
       "2951                                           NaN   \n",
       "2952                                           NaN   \n",
       "2953                                           NaN   \n",
       "2954                                           NaN   \n",
       "\n",
       "     HVBP Safety: COMP-HIP-KNEE Measure Score  \\\n",
       "2950                                      NaN   \n",
       "2951                                      NaN   \n",
       "2952                                      NaN   \n",
       "2953                                      NaN   \n",
       "2954                                      NaN   \n",
       "\n",
       "     HVBP Safety: COMP-HIP-KNEE Performance Rate  \\\n",
       "2950                                         NaN   \n",
       "2951                                         NaN   \n",
       "2952                                         NaN   \n",
       "2953                                         NaN   \n",
       "2954                                         NaN   \n",
       "\n",
       "     HVBP Safety: Combined SSI Measure Score Facility ID  \\\n",
       "2950                            10 out of 10      670082   \n",
       "2951                             0 out of 10      670085   \n",
       "2952                             0 out of 10      670088   \n",
       "2953                           Not Available      670103   \n",
       "2954                           Not Available      670106   \n",
       "\n",
       "     HVBP Safety: HAI-1 Achievement Points  \\\n",
       "2950                           0 out of 10   \n",
       "2951                          10 out of 10   \n",
       "2952                           0 out of 10   \n",
       "2953                         Not Available   \n",
       "2954                         Not Available   \n",
       "\n",
       "      HVBP Safety: HAI-1 Achievement Threshold  \\\n",
       "2950                                     0.457   \n",
       "2951                                     0.457   \n",
       "2952                                     0.457   \n",
       "2953                                     0.457   \n",
       "2954                                     0.457   \n",
       "\n",
       "     HVBP Safety: HAI-1 Baseline Rate  HVBP Safety: HAI-1 Benchmark  \\\n",
       "2950                            1.247                           0.0   \n",
       "2951                    Not Available                           0.0   \n",
       "2952                    Not Available                           0.0   \n",
       "2953                    Not Available                           0.0   \n",
       "2954                    Not Available                           0.0   \n",
       "\n",
       "     HVBP Safety: HAI-1 Improvement Points HVBP Safety: HAI-1 Measure Score  \\\n",
       "2950                            4 out of 9                      4 out of 10   \n",
       "2951                         Not Available                     10 out of 10   \n",
       "2952                         Not Available                      0 out of 10   \n",
       "2953                         Not Available                    Not Available   \n",
       "2954                         Not Available                    Not Available   \n",
       "\n",
       "     HVBP Safety: HAI-1 Performance Rate  \\\n",
       "2950                               0.679   \n",
       "2951                               0.000   \n",
       "2952                               0.975   \n",
       "2953                       Not Available   \n",
       "2954                       Not Available   \n",
       "\n",
       "     HVBP Safety: HAI-2 Achievement Points  \\\n",
       "2950                           0 out of 10   \n",
       "2951                          10 out of 10   \n",
       "2952                           3 out of 10   \n",
       "2953                         Not Available   \n",
       "2954                         Not Available   \n",
       "\n",
       "      HVBP Safety: HAI-2 Achievement Threshold  \\\n",
       "2950                                     0.845   \n",
       "2951                                     0.845   \n",
       "2952                                     0.845   \n",
       "2953                                     0.845   \n",
       "2954                                     0.845   \n",
       "\n",
       "     HVBP Safety: HAI-2 Baseline Rate  HVBP Safety: HAI-2 Benchmark  \\\n",
       "2950                            2.538                           0.0   \n",
       "2951                    Not Available                           0.0   \n",
       "2952                    Not Available                           0.0   \n",
       "2953                    Not Available                           0.0   \n",
       "2954                    Not Available                           0.0   \n",
       "\n",
       "     HVBP Safety: HAI-2 Improvement Points HVBP Safety: HAI-2 Measure Score  \\\n",
       "2950                            2 out of 9                      2 out of 10   \n",
       "2951                         Not Available                     10 out of 10   \n",
       "2952                         Not Available                      3 out of 10   \n",
       "2953                         Not Available                    Not Available   \n",
       "2954                         Not Available                    Not Available   \n",
       "\n",
       "     HVBP Safety: HAI-2 Performance Rate  \\\n",
       "2950                               1.946   \n",
       "2951                               0.000   \n",
       "2952                               0.586   \n",
       "2953                       Not Available   \n",
       "2954                       Not Available   \n",
       "\n",
       "     HVBP Safety: HAI-3 Achievement Points  \\\n",
       "2950                          10 out of 10   \n",
       "2951                           0 out of 10   \n",
       "2952                           0 out of 10   \n",
       "2953                         Not Available   \n",
       "2954                         Not Available   \n",
       "\n",
       "      HVBP Safety: HAI-3 Achievement Threshold  \\\n",
       "2950                                     0.751   \n",
       "2951                                     0.751   \n",
       "2952                                     0.751   \n",
       "2953                                     0.751   \n",
       "2954                                     0.751   \n",
       "\n",
       "     HVBP Safety: HAI-3 Baseline Rate  HVBP Safety: HAI-3 Benchmark  \\\n",
       "2950                            0.588                           0.0   \n",
       "2951                    Not Available                           0.0   \n",
       "2952                    Not Available                           0.0   \n",
       "2953                    Not Available                           0.0   \n",
       "2954                    Not Available                           0.0   \n",
       "\n",
       "     HVBP Safety: HAI-3 Improvement Points HVBP Safety: HAI-3 Measure Score  \\\n",
       "2950                            9 out of 9                     10 out of 10   \n",
       "2951                         Not Available                      0 out of 10   \n",
       "2952                         Not Available                      0 out of 10   \n",
       "2953                         Not Available                    Not Available   \n",
       "2954                         Not Available                    Not Available   \n",
       "\n",
       "     HVBP Safety: HAI-3 Performance Rate  \\\n",
       "2950                               0.000   \n",
       "2951                               2.973   \n",
       "2952                               0.969   \n",
       "2953                       Not Available   \n",
       "2954                       Not Available   \n",
       "\n",
       "     HVBP Safety: HAI-4 Achievement Points  \\\n",
       "2950                         Not Available   \n",
       "2951                         Not Available   \n",
       "2952                         Not Available   \n",
       "2953                         Not Available   \n",
       "2954                         Not Available   \n",
       "\n",
       "      HVBP Safety: HAI-4 Achievement Threshold  \\\n",
       "2950                                     0.698   \n",
       "2951                                     0.698   \n",
       "2952                                     0.698   \n",
       "2953                                     0.698   \n",
       "2954                                     0.698   \n",
       "\n",
       "     HVBP Safety: HAI-4 Baseline Rate  HVBP Safety: HAI-4 Benchmark  \\\n",
       "2950                    Not Available                           0.0   \n",
       "2951                    Not Available                           0.0   \n",
       "2952                    Not Available                           0.0   \n",
       "2953                    Not Available                           0.0   \n",
       "2954                    Not Available                           0.0   \n",
       "\n",
       "     HVBP Safety: HAI-4 Improvement Points HVBP Safety: HAI-4 Measure Score  \\\n",
       "2950                         Not Available                    Not Available   \n",
       "2951                         Not Available                    Not Available   \n",
       "2952                         Not Available                    Not Available   \n",
       "2953                         Not Available                    Not Available   \n",
       "2954                         Not Available                    Not Available   \n",
       "\n",
       "     HVBP Safety: HAI-4 Performance Rate  \\\n",
       "2950                       Not Available   \n",
       "2951                       Not Available   \n",
       "2952                       Not Available   \n",
       "2953                       Not Available   \n",
       "2954                       Not Available   \n",
       "\n",
       "     HVBP Safety: HAI-5 Achievement Points  \\\n",
       "2950                          10 out of 10   \n",
       "2951                         Not Available   \n",
       "2952                         Not Available   \n",
       "2953                         Not Available   \n",
       "2954                         Not Available   \n",
       "\n",
       "      HVBP Safety: HAI-5 Achievement Threshold  \\\n",
       "2950                                     0.799   \n",
       "2951                                     0.799   \n",
       "2952                                     0.799   \n",
       "2953                                     0.799   \n",
       "2954                                     0.799   \n",
       "\n",
       "     HVBP Safety: HAI-5 Baseline Rate  HVBP Safety: HAI-5 Benchmark  \\\n",
       "2950                    Not Available                           0.0   \n",
       "2951                    Not Available                           0.0   \n",
       "2952                    Not Available                           0.0   \n",
       "2953                    Not Available                           0.0   \n",
       "2954                    Not Available                           0.0   \n",
       "\n",
       "     HVBP Safety: HAI-5 Improvement Points HVBP Safety: HAI-5 Measure Score  \\\n",
       "2950                         Not Available                     10 out of 10   \n",
       "2951                         Not Available                    Not Available   \n",
       "2952                         Not Available                    Not Available   \n",
       "2953                         Not Available                    Not Available   \n",
       "2954                         Not Available                    Not Available   \n",
       "\n",
       "     HVBP Safety: HAI-5 Performance Rate  \\\n",
       "2950                               0.000   \n",
       "2951                       Not Available   \n",
       "2952                       Not Available   \n",
       "2953                       Not Available   \n",
       "2954                       Not Available   \n",
       "\n",
       "     HVBP Safety: HAI-6 Achievement Points  \\\n",
       "2950                           0 out of 10   \n",
       "2951                           0 out of 10   \n",
       "2952                           3 out of 10   \n",
       "2953                           0 out of 10   \n",
       "2954                         Not Available   \n",
       "\n",
       "      HVBP Safety: HAI-6 Achievement Threshold  \\\n",
       "2950                                      0.75   \n",
       "2951                                      0.75   \n",
       "2952                                      0.75   \n",
       "2953                                      0.75   \n",
       "2954                                      0.75   \n",
       "\n",
       "     HVBP Safety: HAI-6 Baseline Rate  HVBP Safety: HAI-6 Benchmark  \\\n",
       "2950                            1.115                           0.0   \n",
       "2951                            0.323                           0.0   \n",
       "2952                    Not Available                           0.0   \n",
       "2953                    Not Available                           0.0   \n",
       "2954                    Not Available                           0.0   \n",
       "\n",
       "     HVBP Safety: HAI-6 Improvement Points HVBP Safety: HAI-6 Measure Score  \\\n",
       "2950                            0 out of 9                      0 out of 10   \n",
       "2951                            0 out of 9                      0 out of 10   \n",
       "2952                         Not Available                      3 out of 10   \n",
       "2953                         Not Available                      0 out of 10   \n",
       "2954                         Not Available                    Not Available   \n",
       "\n",
       "     HVBP Safety: HAI-6 Performance Rate  \\\n",
       "2950                               1.353   \n",
       "2951                               1.557   \n",
       "2952                               0.506   \n",
       "2953                               0.929   \n",
       "2954                       Not Available   \n",
       "\n",
       "     HVBP Safety: MORT-30-AMI Achievement Points  \\\n",
       "2950                                         NaN   \n",
       "2951                                         NaN   \n",
       "2952                                         NaN   \n",
       "2953                                         NaN   \n",
       "2954                                         NaN   \n",
       "\n",
       "      HVBP Safety: MORT-30-AMI Achievement Threshold  \\\n",
       "2950                                             NaN   \n",
       "2951                                             NaN   \n",
       "2952                                             NaN   \n",
       "2953                                             NaN   \n",
       "2954                                             NaN   \n",
       "\n",
       "     HVBP Safety: MORT-30-AMI Baseline Rate  \\\n",
       "2950                                    NaN   \n",
       "2951                                    NaN   \n",
       "2952                                    NaN   \n",
       "2953                                    NaN   \n",
       "2954                                    NaN   \n",
       "\n",
       "      HVBP Safety: MORT-30-AMI Benchmark  \\\n",
       "2950                                 NaN   \n",
       "2951                                 NaN   \n",
       "2952                                 NaN   \n",
       "2953                                 NaN   \n",
       "2954                                 NaN   \n",
       "\n",
       "     HVBP Safety: MORT-30-AMI Improvement Points  \\\n",
       "2950                                         NaN   \n",
       "2951                                         NaN   \n",
       "2952                                         NaN   \n",
       "2953                                         NaN   \n",
       "2954                                         NaN   \n",
       "\n",
       "     HVBP Safety: MORT-30-AMI Measure Score  \\\n",
       "2950                                    NaN   \n",
       "2951                                    NaN   \n",
       "2952                                    NaN   \n",
       "2953                                    NaN   \n",
       "2954                                    NaN   \n",
       "\n",
       "     HVBP Safety: MORT-30-AMI Performance Rate  \\\n",
       "2950                                       NaN   \n",
       "2951                                       NaN   \n",
       "2952                                       NaN   \n",
       "2953                                       NaN   \n",
       "2954                                       NaN   \n",
       "\n",
       "     HVBP Safety: MORT-30-HF Achievement Points  \\\n",
       "2950                                        NaN   \n",
       "2951                                        NaN   \n",
       "2952                                        NaN   \n",
       "2953                                        NaN   \n",
       "2954                                        NaN   \n",
       "\n",
       "      HVBP Safety: MORT-30-HF Achievement Threshold  \\\n",
       "2950                                            NaN   \n",
       "2951                                            NaN   \n",
       "2952                                            NaN   \n",
       "2953                                            NaN   \n",
       "2954                                            NaN   \n",
       "\n",
       "     HVBP Safety: MORT-30-HF Baseline Rate  HVBP Safety: MORT-30-HF Benchmark  \\\n",
       "2950                                   NaN                                NaN   \n",
       "2951                                   NaN                                NaN   \n",
       "2952                                   NaN                                NaN   \n",
       "2953                                   NaN                                NaN   \n",
       "2954                                   NaN                                NaN   \n",
       "\n",
       "     HVBP Safety: MORT-30-HF Improvement Points  \\\n",
       "2950                                        NaN   \n",
       "2951                                        NaN   \n",
       "2952                                        NaN   \n",
       "2953                                        NaN   \n",
       "2954                                        NaN   \n",
       "\n",
       "     HVBP Safety: MORT-30-HF Measure Score  \\\n",
       "2950                                   NaN   \n",
       "2951                                   NaN   \n",
       "2952                                   NaN   \n",
       "2953                                   NaN   \n",
       "2954                                   NaN   \n",
       "\n",
       "     HVBP Safety: MORT-30-HF Performance Rate  \\\n",
       "2950                                      NaN   \n",
       "2951                                      NaN   \n",
       "2952                                      NaN   \n",
       "2953                                      NaN   \n",
       "2954                                      NaN   \n",
       "\n",
       "     HVBP Safety: MORT-30-PN Achievement Points  \\\n",
       "2950                                        NaN   \n",
       "2951                                        NaN   \n",
       "2952                                        NaN   \n",
       "2953                                        NaN   \n",
       "2954                                        NaN   \n",
       "\n",
       "      HVBP Safety: MORT-30-PN Achievement Threshold  \\\n",
       "2950                                            NaN   \n",
       "2951                                            NaN   \n",
       "2952                                            NaN   \n",
       "2953                                            NaN   \n",
       "2954                                            NaN   \n",
       "\n",
       "     HVBP Safety: MORT-30-PN Baseline Rate  HVBP Safety: MORT-30-PN Benchmark  \\\n",
       "2950                                   NaN                                NaN   \n",
       "2951                                   NaN                                NaN   \n",
       "2952                                   NaN                                NaN   \n",
       "2953                                   NaN                                NaN   \n",
       "2954                                   NaN                                NaN   \n",
       "\n",
       "     HVBP Safety: MORT-30-PN Improvement Points  \\\n",
       "2950                                        NaN   \n",
       "2951                                        NaN   \n",
       "2952                                        NaN   \n",
       "2953                                        NaN   \n",
       "2954                                        NaN   \n",
       "\n",
       "     HVBP Safety: MORT-30-PN Measure Score  \\\n",
       "2950                                   NaN   \n",
       "2951                                   NaN   \n",
       "2952                                   NaN   \n",
       "2953                                   NaN   \n",
       "2954                                   NaN   \n",
       "\n",
       "     HVBP Safety: MORT-30-PN Performance Rate  \\\n",
       "2950                                      NaN   \n",
       "2951                                      NaN   \n",
       "2952                                      NaN   \n",
       "2953                                      NaN   \n",
       "2954                                      NaN   \n",
       "\n",
       "     HVBP Safety: PC-01 Achievement Points  \\\n",
       "2950                                   NaN   \n",
       "2951                                   NaN   \n",
       "2952                                   NaN   \n",
       "2953                                   NaN   \n",
       "2954                                   NaN   \n",
       "\n",
       "      HVBP Safety: PC-01 Achievement Threshold  \\\n",
       "2950                                       NaN   \n",
       "2951                                       NaN   \n",
       "2952                                       NaN   \n",
       "2953                                       NaN   \n",
       "2954                                       NaN   \n",
       "\n",
       "     HVBP Safety: PC-01 Baseline Rate  HVBP Safety: PC-01 Benchmark  \\\n",
       "2950                              NaN                           NaN   \n",
       "2951                              NaN                           NaN   \n",
       "2952                              NaN                           NaN   \n",
       "2953                              NaN                           NaN   \n",
       "2954                              NaN                           NaN   \n",
       "\n",
       "     HVBP Safety: PC-01 Improvement Points HVBP Safety: PC-01 Measure Score  \\\n",
       "2950                                   NaN                              NaN   \n",
       "2951                                   NaN                              NaN   \n",
       "2952                                   NaN                              NaN   \n",
       "2953                                   NaN                              NaN   \n",
       "2954                                   NaN                              NaN   \n",
       "\n",
       "     HVBP Safety: PC-01 Performance Rate  \\\n",
       "2950                                 NaN   \n",
       "2951                                 NaN   \n",
       "2952                                 NaN   \n",
       "2953                                 NaN   \n",
       "2954                                 NaN   \n",
       "\n",
       "     HVBP Safety: PSI-90 Achievement Points  \\\n",
       "2950                           10 out of 10   \n",
       "2951                           10 out of 10   \n",
       "2952                           10 out of 10   \n",
       "2953                            9 out of 10   \n",
       "2954                            9 out of 10   \n",
       "\n",
       "      HVBP Safety: PSI-90 Achievement Threshold  \\\n",
       "2950                                   0.777936   \n",
       "2951                                   0.777936   \n",
       "2952                                   0.777936   \n",
       "2953                                   0.777936   \n",
       "2954                                   0.777936   \n",
       "\n",
       "     HVBP Safety: PSI-90 Baseline Rate  HVBP Safety: PSI-90 Benchmark  \\\n",
       "2950                     Not Available                       0.547889   \n",
       "2951                     Not Available                       0.547889   \n",
       "2952                     Not Available                       0.547889   \n",
       "2953                     Not Available                       0.547889   \n",
       "2954                     Not Available                       0.547889   \n",
       "\n",
       "     HVBP Safety: PSI-90 Improvement Points HVBP Safety: PSI-90 Measure Score  \\\n",
       "2950                          Not Available                      10 out of 10   \n",
       "2951                          Not Available                      10 out of 10   \n",
       "2952                          Not Available                      10 out of 10   \n",
       "2953                          Not Available                       9 out of 10   \n",
       "2954                          Not Available                       9 out of 10   \n",
       "\n",
       "     HVBP Safety: PSI-90 Performance Rate file_month file_year  \n",
       "2950                             0.393041         12      2016  \n",
       "2951                             0.446768         12      2016  \n",
       "2952                             0.513223         12      2016  \n",
       "2953                             0.563756         12      2016  \n",
       "2954                             0.561992         12      2016  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "for i, n in enumerate(list(hvb_df)):\n",
    "    if n in ['Facility ID', 'file_month', 'file_year']:\n",
    "        continue\n",
    "    \n",
    "    #n1 = n[:n.index(\" \")]\n",
    "    #n2 = n[n.rindex(' ')+1:].strip()\n",
    "    hvb_df.rename(columns={n: 'HVBP Safety: ' + n}, inplace=True)\n",
    "    \n",
    "print(hvb_df.shape)\n",
    "hvb_df.tail()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "39e15b27",
   "metadata": {},
   "outputs": [],
   "source": [
    "ls_10 = []\n",
    "ls_9 = []\n",
    "\n",
    "for l in list(hvb_df):\n",
    "    ls = hvb_df[l].tolist()\n",
    "    for i in ls:\n",
    "        try:\n",
    "            if 'out of 10' in i:\n",
    "                ls_10.append(l)\n",
    "                break\n",
    "            elif 'out of 9' in i:\n",
    "                ls_9.append(l)\n",
    "                break\n",
    "        except:\n",
    "            continue\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "f66037b2",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>HVBP Safety: COMP-HIP-KNEE Achievement Points</th>\n",
       "      <th>HVBP Safety: COMP-HIP-KNEE Achievement Threshold</th>\n",
       "      <th>HVBP Safety: COMP-HIP-KNEE Baseline Rate</th>\n",
       "      <th>HVBP Safety: COMP-HIP-KNEE Benchmark</th>\n",
       "      <th>HVBP Safety: COMP-HIP-KNEE Improvement Points</th>\n",
       "      <th>HVBP Safety: COMP-HIP-KNEE Measure Score</th>\n",
       "      <th>HVBP Safety: COMP-HIP-KNEE Performance Rate</th>\n",
       "      <th>HVBP Safety: Combined SSI Measure Score</th>\n",
       "      <th>Facility ID</th>\n",
       "      <th>HVBP Safety: HAI-1 Achievement Points</th>\n",
       "      <th>HVBP Safety: HAI-1 Achievement Threshold</th>\n",
       "      <th>HVBP Safety: HAI-1 Baseline Rate</th>\n",
       "      <th>HVBP Safety: HAI-1 Benchmark</th>\n",
       "      <th>HVBP Safety: HAI-1 Improvement Points</th>\n",
       "      <th>HVBP Safety: HAI-1 Measure Score</th>\n",
       "      <th>HVBP Safety: HAI-1 Performance Rate</th>\n",
       "      <th>HVBP Safety: HAI-2 Achievement Points</th>\n",
       "      <th>HVBP Safety: HAI-2 Achievement Threshold</th>\n",
       "      <th>HVBP Safety: HAI-2 Baseline Rate</th>\n",
       "      <th>HVBP Safety: HAI-2 Benchmark</th>\n",
       "      <th>HVBP Safety: HAI-2 Improvement Points</th>\n",
       "      <th>HVBP Safety: HAI-2 Measure Score</th>\n",
       "      <th>HVBP Safety: HAI-2 Performance Rate</th>\n",
       "      <th>HVBP Safety: HAI-3 Achievement Points</th>\n",
       "      <th>HVBP Safety: HAI-3 Achievement Threshold</th>\n",
       "      <th>HVBP Safety: HAI-3 Baseline Rate</th>\n",
       "      <th>HVBP Safety: HAI-3 Benchmark</th>\n",
       "      <th>HVBP Safety: HAI-3 Improvement Points</th>\n",
       "      <th>HVBP Safety: HAI-3 Measure Score</th>\n",
       "      <th>HVBP Safety: HAI-3 Performance Rate</th>\n",
       "      <th>HVBP Safety: HAI-4 Achievement Points</th>\n",
       "      <th>HVBP Safety: HAI-4 Achievement Threshold</th>\n",
       "      <th>HVBP Safety: HAI-4 Baseline Rate</th>\n",
       "      <th>HVBP Safety: HAI-4 Benchmark</th>\n",
       "      <th>HVBP Safety: HAI-4 Improvement Points</th>\n",
       "      <th>HVBP Safety: HAI-4 Measure Score</th>\n",
       "      <th>HVBP Safety: HAI-4 Performance Rate</th>\n",
       "      <th>HVBP Safety: HAI-5 Achievement Points</th>\n",
       "      <th>HVBP Safety: HAI-5 Achievement Threshold</th>\n",
       "      <th>HVBP Safety: HAI-5 Baseline Rate</th>\n",
       "      <th>HVBP Safety: HAI-5 Benchmark</th>\n",
       "      <th>HVBP Safety: HAI-5 Improvement Points</th>\n",
       "      <th>HVBP Safety: HAI-5 Measure Score</th>\n",
       "      <th>HVBP Safety: HAI-5 Performance Rate</th>\n",
       "      <th>HVBP Safety: HAI-6 Achievement Points</th>\n",
       "      <th>HVBP Safety: HAI-6 Achievement Threshold</th>\n",
       "      <th>HVBP Safety: HAI-6 Baseline Rate</th>\n",
       "      <th>HVBP Safety: HAI-6 Benchmark</th>\n",
       "      <th>HVBP Safety: HAI-6 Improvement Points</th>\n",
       "      <th>HVBP Safety: HAI-6 Measure Score</th>\n",
       "      <th>HVBP Safety: HAI-6 Performance Rate</th>\n",
       "      <th>HVBP Safety: MORT-30-AMI Achievement Points</th>\n",
       "      <th>HVBP Safety: MORT-30-AMI Achievement Threshold</th>\n",
       "      <th>HVBP Safety: MORT-30-AMI Baseline Rate</th>\n",
       "      <th>HVBP Safety: MORT-30-AMI Benchmark</th>\n",
       "      <th>HVBP Safety: MORT-30-AMI Improvement Points</th>\n",
       "      <th>HVBP Safety: MORT-30-AMI Measure Score</th>\n",
       "      <th>HVBP Safety: MORT-30-AMI Performance Rate</th>\n",
       "      <th>HVBP Safety: MORT-30-HF Achievement Points</th>\n",
       "      <th>HVBP Safety: MORT-30-HF Achievement Threshold</th>\n",
       "      <th>HVBP Safety: MORT-30-HF Baseline Rate</th>\n",
       "      <th>HVBP Safety: MORT-30-HF Benchmark</th>\n",
       "      <th>HVBP Safety: MORT-30-HF Improvement Points</th>\n",
       "      <th>HVBP Safety: MORT-30-HF Measure Score</th>\n",
       "      <th>HVBP Safety: MORT-30-HF Performance Rate</th>\n",
       "      <th>HVBP Safety: MORT-30-PN Achievement Points</th>\n",
       "      <th>HVBP Safety: MORT-30-PN Achievement Threshold</th>\n",
       "      <th>HVBP Safety: MORT-30-PN Baseline Rate</th>\n",
       "      <th>HVBP Safety: MORT-30-PN Benchmark</th>\n",
       "      <th>HVBP Safety: MORT-30-PN Improvement Points</th>\n",
       "      <th>HVBP Safety: MORT-30-PN Measure Score</th>\n",
       "      <th>HVBP Safety: MORT-30-PN Performance Rate</th>\n",
       "      <th>HVBP Safety: PC-01 Achievement Points</th>\n",
       "      <th>HVBP Safety: PC-01 Achievement Threshold</th>\n",
       "      <th>HVBP Safety: PC-01 Baseline Rate</th>\n",
       "      <th>HVBP Safety: PC-01 Benchmark</th>\n",
       "      <th>HVBP Safety: PC-01 Improvement Points</th>\n",
       "      <th>HVBP Safety: PC-01 Measure Score</th>\n",
       "      <th>HVBP Safety: PC-01 Performance Rate</th>\n",
       "      <th>HVBP Safety: PSI-90 Achievement Points</th>\n",
       "      <th>HVBP Safety: PSI-90 Achievement Threshold</th>\n",
       "      <th>HVBP Safety: PSI-90 Baseline Rate</th>\n",
       "      <th>HVBP Safety: PSI-90 Benchmark</th>\n",
       "      <th>HVBP Safety: PSI-90 Improvement Points</th>\n",
       "      <th>HVBP Safety: PSI-90 Measure Score</th>\n",
       "      <th>HVBP Safety: PSI-90 Performance Rate</th>\n",
       "      <th>file_month</th>\n",
       "      <th>file_year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\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>010001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.589</td>\n",
       "      <td>0.742</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.476</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.65</td>\n",
       "      <td>0.324</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.306</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.717</td>\n",
       "      <td>0.650</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.228</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.738</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.726</td>\n",
       "      <td>0.548</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.912</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.52</td>\n",
       "      <td>0.537</td>\n",
       "      <td>0.014</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.644</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",
       "      <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",
       "      <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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\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>010005</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.589</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.311</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.65</td>\n",
       "      <td>1.073</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.350</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.717</td>\n",
       "      <td>0.508</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.400</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.738</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.726</td>\n",
       "      <td>1.938</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.52</td>\n",
       "      <td>0.565</td>\n",
       "      <td>0.014</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.860</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",
       "      <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",
       "      <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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\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>010006</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.589</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.507</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.65</td>\n",
       "      <td>0.222</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.602</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.717</td>\n",
       "      <td>0.820</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.871</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.738</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.726</td>\n",
       "      <td>0.654</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.640</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.52</td>\n",
       "      <td>0.426</td>\n",
       "      <td>0.014</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.080</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",
       "      <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",
       "      <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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\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>010007</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.589</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.65</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.717</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.738</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.726</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.52</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.014</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.410</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",
       "      <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",
       "      <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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\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>010011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.589</td>\n",
       "      <td>0.421</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.728</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.65</td>\n",
       "      <td>0.598</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.927</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.717</td>\n",
       "      <td>0.930</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.268</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.738</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.726</td>\n",
       "      <td>0.964</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.346</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.52</td>\n",
       "      <td>0.343</td>\n",
       "      <td>0.014</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.607</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",
       "      <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",
       "      <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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   HVBP Safety: COMP-HIP-KNEE Achievement Points  \\\n",
       "0                                            NaN   \n",
       "1                                            NaN   \n",
       "2                                            NaN   \n",
       "3                                            NaN   \n",
       "4                                            NaN   \n",
       "\n",
       "   HVBP Safety: COMP-HIP-KNEE Achievement Threshold  \\\n",
       "0                                               NaN   \n",
       "1                                               NaN   \n",
       "2                                               NaN   \n",
       "3                                               NaN   \n",
       "4                                               NaN   \n",
       "\n",
       "  HVBP Safety: COMP-HIP-KNEE Baseline Rate  \\\n",
       "0                                      NaN   \n",
       "1                                      NaN   \n",
       "2                                      NaN   \n",
       "3                                      NaN   \n",
       "4                                      NaN   \n",
       "\n",
       "   HVBP Safety: COMP-HIP-KNEE Benchmark  \\\n",
       "0                                   NaN   \n",
       "1                                   NaN   \n",
       "2                                   NaN   \n",
       "3                                   NaN   \n",
       "4                                   NaN   \n",
       "\n",
       "   HVBP Safety: COMP-HIP-KNEE Improvement Points  \\\n",
       "0                                            NaN   \n",
       "1                                            NaN   \n",
       "2                                            NaN   \n",
       "3                                            NaN   \n",
       "4                                            NaN   \n",
       "\n",
       "   HVBP Safety: COMP-HIP-KNEE Measure Score  \\\n",
       "0                                       NaN   \n",
       "1                                       NaN   \n",
       "2                                       NaN   \n",
       "3                                       NaN   \n",
       "4                                       NaN   \n",
       "\n",
       "  HVBP Safety: COMP-HIP-KNEE Performance Rate  \\\n",
       "0                                         NaN   \n",
       "1                                         NaN   \n",
       "2                                         NaN   \n",
       "3                                         NaN   \n",
       "4                                         NaN   \n",
       "\n",
       "   HVBP Safety: Combined SSI Measure Score Facility ID  \\\n",
       "0                                      NaN      010001   \n",
       "1                                      NaN      010005   \n",
       "2                                      NaN      010006   \n",
       "3                                      NaN      010007   \n",
       "4                                      NaN      010011   \n",
       "\n",
       "   HVBP Safety: HAI-1 Achievement Points  \\\n",
       "0                                    NaN   \n",
       "1                                    NaN   \n",
       "2                                    NaN   \n",
       "3                                    NaN   \n",
       "4                                    NaN   \n",
       "\n",
       "   HVBP Safety: HAI-1 Achievement Threshold HVBP Safety: HAI-1 Baseline Rate  \\\n",
       "0                                     0.589                            0.742   \n",
       "1                                     0.589                            0.000   \n",
       "2                                     0.589                            0.000   \n",
       "3                                     0.589                    Not Available   \n",
       "4                                     0.589                            0.421   \n",
       "\n",
       "   HVBP Safety: HAI-1 Benchmark  HVBP Safety: HAI-1 Improvement Points  \\\n",
       "0                           0.0                                    NaN   \n",
       "1                           0.0                                    NaN   \n",
       "2                           0.0                                    NaN   \n",
       "3                           0.0                                    NaN   \n",
       "4                           0.0                                    NaN   \n",
       "\n",
       "   HVBP Safety: HAI-1 Measure Score HVBP Safety: HAI-1 Performance Rate  \\\n",
       "0                               NaN                               0.476   \n",
       "1                               NaN                               3.311   \n",
       "2                               NaN                               0.507   \n",
       "3                               NaN                       Not Available   \n",
       "4                               NaN                               0.728   \n",
       "\n",
       "   HVBP Safety: HAI-2 Achievement Points  \\\n",
       "0                                    NaN   \n",
       "1                                    NaN   \n",
       "2                                    NaN   \n",
       "3                                    NaN   \n",
       "4                                    NaN   \n",
       "\n",
       "   HVBP Safety: HAI-2 Achievement Threshold HVBP Safety: HAI-2 Baseline Rate  \\\n",
       "0                                      0.65                            0.324   \n",
       "1                                      0.65                            1.073   \n",
       "2                                      0.65                            0.222   \n",
       "3                                      0.65                    Not Available   \n",
       "4                                      0.65                            0.598   \n",
       "\n",
       "   HVBP Safety: HAI-2 Benchmark  HVBP Safety: HAI-2 Improvement Points  \\\n",
       "0                           0.0                                    NaN   \n",
       "1                           0.0                                    NaN   \n",
       "2                           0.0                                    NaN   \n",
       "3                           0.0                                    NaN   \n",
       "4                           0.0                                    NaN   \n",
       "\n",
       "   HVBP Safety: HAI-2 Measure Score HVBP Safety: HAI-2 Performance Rate  \\\n",
       "0                               NaN                               0.306   \n",
       "1                               NaN                               2.350   \n",
       "2                               NaN                               0.602   \n",
       "3                               NaN                       Not Available   \n",
       "4                               NaN                               0.927   \n",
       "\n",
       "   HVBP Safety: HAI-3 Achievement Points  \\\n",
       "0                                    NaN   \n",
       "1                                    NaN   \n",
       "2                                    NaN   \n",
       "3                                    NaN   \n",
       "4                                    NaN   \n",
       "\n",
       "   HVBP Safety: HAI-3 Achievement Threshold HVBP Safety: HAI-3 Baseline Rate  \\\n",
       "0                                     0.717                            0.650   \n",
       "1                                     0.717                            0.508   \n",
       "2                                     0.717                            0.820   \n",
       "3                                     0.717                    Not Available   \n",
       "4                                     0.717                            0.930   \n",
       "\n",
       "   HVBP Safety: HAI-3 Benchmark  HVBP Safety: HAI-3 Improvement Points  \\\n",
       "0                           0.0                                    NaN   \n",
       "1                           0.0                                    NaN   \n",
       "2                           0.0                                    NaN   \n",
       "3                           0.0                                    NaN   \n",
       "4                           0.0                                    NaN   \n",
       "\n",
       "   HVBP Safety: HAI-3 Measure Score HVBP Safety: HAI-3 Performance Rate  \\\n",
       "0                               NaN                               1.228   \n",
       "1                               NaN                               0.400   \n",
       "2                               NaN                               0.871   \n",
       "3                               NaN                       Not Available   \n",
       "4                               NaN                               0.268   \n",
       "\n",
       "   HVBP Safety: HAI-4 Achievement Points  \\\n",
       "0                                    NaN   \n",
       "1                                    NaN   \n",
       "2                                    NaN   \n",
       "3                                    NaN   \n",
       "4                                    NaN   \n",
       "\n",
       "   HVBP Safety: HAI-4 Achievement Threshold HVBP Safety: HAI-4 Baseline Rate  \\\n",
       "0                                     0.738                            0.000   \n",
       "1                                     0.738                    Not Available   \n",
       "2                                     0.738                    Not Available   \n",
       "3                                     0.738                    Not Available   \n",
       "4                                     0.738                    Not Available   \n",
       "\n",
       "   HVBP Safety: HAI-4 Benchmark  HVBP Safety: HAI-4 Improvement Points  \\\n",
       "0                           0.0                                    NaN   \n",
       "1                           0.0                                    NaN   \n",
       "2                           0.0                                    NaN   \n",
       "3                           0.0                                    NaN   \n",
       "4                           0.0                                    NaN   \n",
       "\n",
       "   HVBP Safety: HAI-4 Measure Score HVBP Safety: HAI-4 Performance Rate  \\\n",
       "0                               NaN                               0.000   \n",
       "1                               NaN                       Not Available   \n",
       "2                               NaN                       Not Available   \n",
       "3                               NaN                       Not Available   \n",
       "4                               NaN                       Not Available   \n",
       "\n",
       "   HVBP Safety: HAI-5 Achievement Points  \\\n",
       "0                                    NaN   \n",
       "1                                    NaN   \n",
       "2                                    NaN   \n",
       "3                                    NaN   \n",
       "4                                    NaN   \n",
       "\n",
       "   HVBP Safety: HAI-5 Achievement Threshold HVBP Safety: HAI-5 Baseline Rate  \\\n",
       "0                                     0.726                            0.548   \n",
       "1                                     0.726                            1.938   \n",
       "2                                     0.726                            0.654   \n",
       "3                                     0.726                    Not Available   \n",
       "4                                     0.726                            0.964   \n",
       "\n",
       "   HVBP Safety: HAI-5 Benchmark  HVBP Safety: HAI-5 Improvement Points  \\\n",
       "0                           0.0                                    NaN   \n",
       "1                           0.0                                    NaN   \n",
       "2                           0.0                                    NaN   \n",
       "3                           0.0                                    NaN   \n",
       "4                           0.0                                    NaN   \n",
       "\n",
       "   HVBP Safety: HAI-5 Measure Score HVBP Safety: HAI-5 Performance Rate  \\\n",
       "0                               NaN                               0.912   \n",
       "1                               NaN                               0.000   \n",
       "2                               NaN                               1.640   \n",
       "3                               NaN                       Not Available   \n",
       "4                               NaN                               1.346   \n",
       "\n",
       "   HVBP Safety: HAI-6 Achievement Points  \\\n",
       "0                                    NaN   \n",
       "1                                    NaN   \n",
       "2                                    NaN   \n",
       "3                                    NaN   \n",
       "4                                    NaN   \n",
       "\n",
       "   HVBP Safety: HAI-6 Achievement Threshold HVBP Safety: HAI-6 Baseline Rate  \\\n",
       "0                                      0.52                            0.537   \n",
       "1                                      0.52                            0.565   \n",
       "2                                      0.52                            0.426   \n",
       "3                                      0.52                            0.000   \n",
       "4                                      0.52                            0.343   \n",
       "\n",
       "   HVBP Safety: HAI-6 Benchmark  HVBP Safety: HAI-6 Improvement Points  \\\n",
       "0                         0.014                                    NaN   \n",
       "1                         0.014                                    NaN   \n",
       "2                         0.014                                    NaN   \n",
       "3                         0.014                                    NaN   \n",
       "4                         0.014                                    NaN   \n",
       "\n",
       "   HVBP Safety: HAI-6 Measure Score HVBP Safety: HAI-6 Performance Rate  \\\n",
       "0                               NaN                               0.644   \n",
       "1                               NaN                               0.860   \n",
       "2                               NaN                               0.080   \n",
       "3                               NaN                               0.410   \n",
       "4                               NaN                               0.607   \n",
       "\n",
       "   HVBP Safety: MORT-30-AMI Achievement Points  \\\n",
       "0                                          NaN   \n",
       "1                                          NaN   \n",
       "2                                          NaN   \n",
       "3                                          NaN   \n",
       "4                                          NaN   \n",
       "\n",
       "   HVBP Safety: MORT-30-AMI Achievement Threshold  \\\n",
       "0                                             NaN   \n",
       "1                                             NaN   \n",
       "2                                             NaN   \n",
       "3                                             NaN   \n",
       "4                                             NaN   \n",
       "\n",
       "  HVBP Safety: MORT-30-AMI Baseline Rate  HVBP Safety: MORT-30-AMI Benchmark  \\\n",
       "0                                    NaN                                 NaN   \n",
       "1                                    NaN                                 NaN   \n",
       "2                                    NaN                                 NaN   \n",
       "3                                    NaN                                 NaN   \n",
       "4                                    NaN                                 NaN   \n",
       "\n",
       "   HVBP Safety: MORT-30-AMI Improvement Points  \\\n",
       "0                                          NaN   \n",
       "1                                          NaN   \n",
       "2                                          NaN   \n",
       "3                                          NaN   \n",
       "4                                          NaN   \n",
       "\n",
       "   HVBP Safety: MORT-30-AMI Measure Score  \\\n",
       "0                                     NaN   \n",
       "1                                     NaN   \n",
       "2                                     NaN   \n",
       "3                                     NaN   \n",
       "4                                     NaN   \n",
       "\n",
       "  HVBP Safety: MORT-30-AMI Performance Rate  \\\n",
       "0                                       NaN   \n",
       "1                                       NaN   \n",
       "2                                       NaN   \n",
       "3                                       NaN   \n",
       "4                                       NaN   \n",
       "\n",
       "   HVBP Safety: MORT-30-HF Achievement Points  \\\n",
       "0                                         NaN   \n",
       "1                                         NaN   \n",
       "2                                         NaN   \n",
       "3                                         NaN   \n",
       "4                                         NaN   \n",
       "\n",
       "   HVBP Safety: MORT-30-HF Achievement Threshold  \\\n",
       "0                                            NaN   \n",
       "1                                            NaN   \n",
       "2                                            NaN   \n",
       "3                                            NaN   \n",
       "4                                            NaN   \n",
       "\n",
       "  HVBP Safety: MORT-30-HF Baseline Rate  HVBP Safety: MORT-30-HF Benchmark  \\\n",
       "0                                   NaN                                NaN   \n",
       "1                                   NaN                                NaN   \n",
       "2                                   NaN                                NaN   \n",
       "3                                   NaN                                NaN   \n",
       "4                                   NaN                                NaN   \n",
       "\n",
       "   HVBP Safety: MORT-30-HF Improvement Points  \\\n",
       "0                                         NaN   \n",
       "1                                         NaN   \n",
       "2                                         NaN   \n",
       "3                                         NaN   \n",
       "4                                         NaN   \n",
       "\n",
       "   HVBP Safety: MORT-30-HF Measure Score  \\\n",
       "0                                    NaN   \n",
       "1                                    NaN   \n",
       "2                                    NaN   \n",
       "3                                    NaN   \n",
       "4                                    NaN   \n",
       "\n",
       "  HVBP Safety: MORT-30-HF Performance Rate  \\\n",
       "0                                      NaN   \n",
       "1                                      NaN   \n",
       "2                                      NaN   \n",
       "3                                      NaN   \n",
       "4                                      NaN   \n",
       "\n",
       "   HVBP Safety: MORT-30-PN Achievement Points  \\\n",
       "0                                         NaN   \n",
       "1                                         NaN   \n",
       "2                                         NaN   \n",
       "3                                         NaN   \n",
       "4                                         NaN   \n",
       "\n",
       "   HVBP Safety: MORT-30-PN Achievement Threshold  \\\n",
       "0                                            NaN   \n",
       "1                                            NaN   \n",
       "2                                            NaN   \n",
       "3                                            NaN   \n",
       "4                                            NaN   \n",
       "\n",
       "  HVBP Safety: MORT-30-PN Baseline Rate  HVBP Safety: MORT-30-PN Benchmark  \\\n",
       "0                                   NaN                                NaN   \n",
       "1                                   NaN                                NaN   \n",
       "2                                   NaN                                NaN   \n",
       "3                                   NaN                                NaN   \n",
       "4                                   NaN                                NaN   \n",
       "\n",
       "   HVBP Safety: MORT-30-PN Improvement Points  \\\n",
       "0                                         NaN   \n",
       "1                                         NaN   \n",
       "2                                         NaN   \n",
       "3                                         NaN   \n",
       "4                                         NaN   \n",
       "\n",
       "   HVBP Safety: MORT-30-PN Measure Score  \\\n",
       "0                                    NaN   \n",
       "1                                    NaN   \n",
       "2                                    NaN   \n",
       "3                                    NaN   \n",
       "4                                    NaN   \n",
       "\n",
       "  HVBP Safety: MORT-30-PN Performance Rate  \\\n",
       "0                                      NaN   \n",
       "1                                      NaN   \n",
       "2                                      NaN   \n",
       "3                                      NaN   \n",
       "4                                      NaN   \n",
       "\n",
       "   HVBP Safety: PC-01 Achievement Points  \\\n",
       "0                                    NaN   \n",
       "1                                    NaN   \n",
       "2                                    NaN   \n",
       "3                                    NaN   \n",
       "4                                    NaN   \n",
       "\n",
       "   HVBP Safety: PC-01 Achievement Threshold HVBP Safety: PC-01 Baseline Rate  \\\n",
       "0                                       NaN                              NaN   \n",
       "1                                       NaN                              NaN   \n",
       "2                                       NaN                              NaN   \n",
       "3                                       NaN                              NaN   \n",
       "4                                       NaN                              NaN   \n",
       "\n",
       "   HVBP Safety: PC-01 Benchmark  HVBP Safety: PC-01 Improvement Points  \\\n",
       "0                           NaN                                    NaN   \n",
       "1                           NaN                                    NaN   \n",
       "2                           NaN                                    NaN   \n",
       "3                           NaN                                    NaN   \n",
       "4                           NaN                                    NaN   \n",
       "\n",
       "   HVBP Safety: PC-01 Measure Score HVBP Safety: PC-01 Performance Rate  \\\n",
       "0                               NaN                                 NaN   \n",
       "1                               NaN                                 NaN   \n",
       "2                               NaN                                 NaN   \n",
       "3                               NaN                                 NaN   \n",
       "4                               NaN                                 NaN   \n",
       "\n",
       "   HVBP Safety: PSI-90 Achievement Points  \\\n",
       "0                                     NaN   \n",
       "1                                     NaN   \n",
       "2                                     NaN   \n",
       "3                                     NaN   \n",
       "4                                     NaN   \n",
       "\n",
       "   HVBP Safety: PSI-90 Achievement Threshold  \\\n",
       "0                                        NaN   \n",
       "1                                        NaN   \n",
       "2                                        NaN   \n",
       "3                                        NaN   \n",
       "4                                        NaN   \n",
       "\n",
       "  HVBP Safety: PSI-90 Baseline Rate  HVBP Safety: PSI-90 Benchmark  \\\n",
       "0                               NaN                            NaN   \n",
       "1                               NaN                            NaN   \n",
       "2                               NaN                            NaN   \n",
       "3                               NaN                            NaN   \n",
       "4                               NaN                            NaN   \n",
       "\n",
       "   HVBP Safety: PSI-90 Improvement Points  HVBP Safety: PSI-90 Measure Score  \\\n",
       "0                                     NaN                                NaN   \n",
       "1                                     NaN                                NaN   \n",
       "2                                     NaN                                NaN   \n",
       "3                                     NaN                                NaN   \n",
       "4                                     NaN                                NaN   \n",
       "\n",
       "  HVBP Safety: PSI-90 Performance Rate file_month file_year  \n",
       "0                                  NaN         01      2023  \n",
       "1                                  NaN         01      2023  \n",
       "2                                  NaN         01      2023  \n",
       "3                                  NaN         01      2023  \n",
       "4                                  NaN         01      2023  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "for l in ls_9:\n",
    "    hvb_df[l] = hvb_df[l].replace(['0 out of 9', \n",
    "                                   '1 out of 9', '2 out of 9', '3 out of 9',\n",
    "                                   '4 out of 9', '5 out of 9', '6 out of 9', \n",
    "                                   '7 out of 9', '8 out of 9', '9 out of 9'],\n",
    "                                  [0, 1, 2, 3, 4, 5, 6, 7, 8, 9])\n",
    "    hvb_df[l] = pd.to_numeric(hvb_df[l], errors='coerce')\n",
    "\n",
    "    \n",
    "\n",
    "for l in ls_10:\n",
    "    hvb_df[l] = hvb_df[l].replace(['0 out of 10', \n",
    "                                   '1 out of 10', '2 out of 10', '3 out of 10',\n",
    "                                   '4 out of 10', '5 out of 10', '6 out of 10', \n",
    "                                   '7 out of 10', '8 out of 10', '9 out of 10', \n",
    "                                   '10 out of 10'],\n",
    "                                  [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10])\n",
    "    hvb_df[l] = pd.to_numeric(hvb_df[l], errors='coerce')\n",
    "\n",
    "    \n",
    "    \n",
    "hvb_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "a6079ecb",
   "metadata": {},
   "outputs": [],
   "source": [
    "hvb_df.to_pickle('dataframes/hvbp_safety_df.pkl.gz', protocol=5, compression='gzip')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "82ec2c0b",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}